Calculating Distance in MIles

[Dennis Tucker]

Lets say I have two locations on the earth surface. These locations are stated as

Location 1

geo:lat=57.64911

geo:lon=10.40744

&

Location 2

geo:lat=58.64911

geo:lon=11.40744

What is the easiest and accurate way to calculate the distance between these locations in miles?

What is the formula?

Dennis

 

[OssieMac]

Hello Dennis,

If you Google "distance between coordinates" you will find quite a bit on
this subject. Here is one link.

http://www.movable-type.co.uk/scripts/latlong.html

 

[macropod]

Hi Dennis,

For distances at sea level, try:
ACOS(SIN(RADIANS(Lat1))*SIN(RADIANS(Lat2))+COS(RADIANS(Lat1))*COS(RADIANS(Lat2))*COS(RADIANS(Long1-Long2)))*RadiusEarth
where:
Lat1, Lat2, Long1-Long2 are named cells containing the latitudes and longitudes (you could use cell addresses instead).
RadiusEarth = 3956.56 (the average distance in statute miles, but the distance around the equator is longer than around the poles).
You could adjust this for the average distances from the center of the earth for the start and end locations.

--
Cheers
macropod
[Microsoft MVP - Word]


Lets say I have two locations on the earth surface. These locations are stated as

Location 1

geo:lat=57.64911

geo:lon=10.40744

&

Location 2

geo:lat=58.64911

geo:lon=11.40744

What is the easiest and accurate way to calculate the distance between these locations in miles?

What is the formula?

Dennis

 

[Dennis Tucker]

Thanks, but I looked over the data on that web page before my questions.
I'm working strictly with Decimal Degrees.

I'm hoping someone has already done this conversion with VBA and is willing
to share it.

Dennis

 

[Dennis Tucker]

Thanks. I will try it out.

Dennis

 

[helene and gabor]

Hello Dennis,

The latitudes can be North or South, the longitudes East or West.

Best Regards

Gabor Sebo

Have program.

-----------------------------------------------------------------------------------------------------------------------------------------------------
Lets say I have two locations on the earth surface. These locations are stated as

Location 1

geo:lat=57.64911

geo:lon=10.40744

&

Location 2

geo:lat=58.64911

geo:lon=11.40744

What is the easiest and accurate way to calculate the distance between these locations in miles?

What is the formula?

Dennis

 

[Chip Pearson]

See http://www.cpearson.com/excel/latlong.aspx . It has a formula for
calculating the great circle distance of two points, given latitude
and longitude for each point. A great circle is the shortest path
between two points on a sphere.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com

 

[helene and gabor]

Hello Dennis,

My Excel program says the distance is:

78.1216 miles.

Best Regards,


Gabor Sebo

--------------------------------------------------------------------------
--------------------------------------------------------------------------
Lets say I have two locations on the earth surface. These locations are stated as

Location 1

geo:lat=57.64911

geo:lon=10.40744

&

Location 2

geo:lat=58.64911

geo:lon=11.40744

What is the easiest and accurate way to calculate the distance between these locations in miles?

What is the formula?

Dennis

 

[Dana DeLouis]

Hmmmm.. Getting away from it all for the weekend? :>)

http://maps.google.com/maps?ll=57.64911,10.40744&z=19&t=h&hl=en

Looks like a pretty drive... in the summer.

= = = = =
Dana DeLouis