PDA

View Full Version : Download Distance calculator using - LAT/LONG



mail2paturi
2011-06-01, 10:25 PM
Dear all,

Here is a small excel tool attached to find the distance between two lat/Longs.

Hope so useful for some one.

wireless.com
2011-06-02, 12:15 AM
I x-checked with GE and the distance is not the same... is the result in meters?

aosan
2011-06-02, 02:04 AM
I x-checked with GE and the distance is not the same... is the result in meters?


you can use this formula if you want........it is accurate one


=RadiusEarth*ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2)))

Where RadiusEarth = 6371 Km

mail2paturi
2011-06-02, 06:57 PM
I x-checked with GE and the distance is not the same... is the result in meters?

Hi i have checked all the data its working fine.

Yeah its in meters.