I have a four sided field with a center point (that is not really in the center) but is called center.
The four corners and "center" point are all known gps coordinates (known in UTM, Long Lat). I need an excel calculation that will allow me to automatically calculate the distance from the "center" point to the edge of the field from all 365 degrees. Assume that the four "corners" of the field can be connected to form a square if this makes this easier. I also need this formula to be generic enough so that it can accommodate any 4 corners and "center point" and give me the distance automatically.
For instance, if I have a column 1a that says 231 (degrees), id like column 1b to say the distance to the edge of the field given 231 degrees from the "center" point
Thanks in advance