Latest Contributions by KasperSmith_Larsen

Now I got the Haversine fomula to work so problem solved Thanks to all of you for your input they really helped.   ... View more

Thanks for your answers. I have tried using the Haversine formula in excel but I can’t get the right distance. I have calculated the following parameter: R = earth’s radius (mean radius = 6,371km) Δlat = lat 2 − lat 1 Δlong = long 2 − long 1 a = sin²(Δlat/2) + cos(lat 1 )*cos(lat 2 )*sin²(Δlong/2) c = 2*atan2(√a, √(1−a)) d = R*c (distance)       As described at http://www.ig.utexas.edu/outreach/googleearth/latlong.html It says on the web-site that angles need to be in radians and I tried with radians calculated from both decimal degrees and degrees, minutes, seconds.  ... View more