0

I have ~2,000 paths/lines drawn in Google Earth and I would like to know their cumulative length. How can I do this easily?

I have been able to convert into excel the Lat & Long of each point in the string, but some are too long for Excel to accept. Dylan

1

in excel, you can use following formule (from Excel formula to calculate distance between 2 latitude, longitude (lat/lon) points (GPS positions)):

=ACOS(COS(RADIANS(90-A2)) *COS(RADIANS(90-A3)) +SIN(RADIANS(90-A2)) *SIN(RADIANS(90-A3)) 
*COS(RADIANS(B2-B3))) *6371

i hope it helps you...

  • I guess that's not very accurate... – AndreJ Aug 28 '13 at 11:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.