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(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]


"Dennis Tucker" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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" <(E-Mail Removed)> wrote in message
news:A34AD1BC-2C50-4E90-B39E-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:OANuLY#(E-Mail Removed)...
> 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]
>
>
> "Dennis Tucker" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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"
<(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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
>