Determining Distance from Latitude and Longitude

M

morchard

Is there a formula for deriving the great circle distance between tw
points on the earth's surface when you have their latitude an
longitude?

The format I have the latitude/longitude in is:
Latitude Longitude
017/025S 145/030W
026/045S 141/000E
031/008N 033/048E
036/050N 008/000
 
A

Aaron

I have been racking my brain triple checking my equation, and it's not
computing correctly.

I have:

=($M$1*ACOS(COS(I1)*COS(K5)))+(SIN(I1)*SIN(K5)*COS(J1-L5))

M1 is the earth radius

All in radians
I1: lat1
K5: lat2
J1: long1
L5: long2

For this example,
city 1: 0.74933823, 1.56014357
city 2: 0.750862496, 1.560638039

And it gives me 3985 as the answer. It should be 14.2.

Help please!!

Thanks





Dave Peterson said:
Take a look at Chip Pearson's notes:
http://cpearson.com/excel/latlong.htm
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distance calculator from longitude and latitude 2
Distance between latitude and longitude 1
Calculation: miles between two points using latitude & Longitude 1
Formula for Mileage from Latitude and Longitude 3
Calculating the distance customers live from a branch office 5
Minimum Distance Calculation using Array and Geographical Coordinates 1
Can distance be calculated using latitude and longitude? 1
Distance/Heading from Latitude Longitude Formula 1

Top