Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
for a distance calculation between geopoints I Need to add two latitutes
i.e.
51.0015983 + 52.6193168
I tried num and num#, but until now nothing works:-(
Please assist, for which I thank you all in advance
Wolfgang
Thanks to all Experts, I solved the 'distance-like-a-crow-flies' Problem and will start to
look behind the street distance Problem.
All of your answers were helpful.
Finally i use this formula:
=sqrt
((111.3*cos((lat1_c+lat2_c)/2*0.01745)*(lon1_c-lon2_c))*
(111.3*cos((lat1_c+lat2_c)/2*0.01745)*(lon1_c-lon2_c))+
(111.3*(lat1_c-lat2_c))*(111.3*(lat1_c-lat2_c)))
where _c stands for those coordinates changed from . to ,
See you again,
Wolfgang
Hi Expert,
unfortunately the formula did not work.
I use the following now:
=sqrt
((111.3*cos((lat1_c+lat2_c)/2*0.01745)*(lon1_c-lon2_c))*
(111.3*cos((lat1_c+lat2_c)/2*0.01745)*(lon1_c-lon2_c))+
(111.3*(lat1_c-lat2_c))*(111.3*(lat1_c-lat2_c)))
and it brings to me distances which are correct (counterchecked in the Internet:-))
Best regards
Wolfgang