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

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


--
Regards,

OssieMac


"Dennis Tucker" wrote:

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

Hi Dennis,

For distances at sea level, try:
ACOS(SIN(RADIANS(Lat1))*SIN(RADIANS(Lat2))+COS(RAD IANS(Lat1))*COS(RADIANS(Lat2))*COS(RADIANS(Long1-Long2)))*RadiusEarth
whe
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]


"Dennis Tucker" wrote in message ...
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

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

"OssieMac" wrote in message
...
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


--
Regards,

OssieMac


"Dennis Tucker" wrote:

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

Thanks. I will try it out.

Dennis

"macropod" wrote in message
...
Hi Dennis,

For distances at sea level, try:
ACOS(SIN(RADIANS(Lat1))*SIN(RADIANS(Lat2))+COS(RAD IANS(Lat1))*COS(RADIANS(Lat2))*COS(RADIANS(Long1-Long2)))*RadiusEarth
whe
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]


"Dennis Tucker" wrote in message
...
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

Hello Dennis,

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

Best Regards

Gabor Sebo

Have program.

-----------------------------------------------------------------------------------------------------------------------------------------------------
"Dennis Tucker" wrote in message ...
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

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



On Fri, 19 Mar 2010 20:34:33 -0700, "Dennis Tucker"
wrote:

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

Hello Dennis,

My Excel program says the distance is:

78.1216 miles.

Best Regards,


Gabor Sebo

--------------------------------------------------------------------------
--------------------------------------------------------------------------
"Dennis Tucker" wrote in message ...
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

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

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

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

= = = = =
Dana DeLouis



On 3/19/10 11:34 PM, Dennis Tucker wrote:
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