Excel Great Circle calculator

Archived from groups: alt.games.microsoft.flight-sim (More info?)

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

Found this awhile back, dont remember where tho....


"Lynndel Humphreys" <lynndel@xtn.net> wrote in message
news:42b98009$1_1@spool9-west.superfeed.net...
>I need to setup an excel spreadsheet to calculate Great Circle distance and
> bearing from a list of latitude and longitude data. In columns A,B,.....
> what formulae do I need?
>
>
>
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
> News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
> Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption
> =----

Archived from groups: alt.games.microsoft.flight-sim (More info?)

=3963*(ACOS(COS(A1)*COS(A2)*COS(B1-B2))+(SIN(A1)*SIN(A2))) doesn't work for
the distance


"Lynndel Humphreys" <lynndel@xtn.net> wrote in message
news:42b98009$1_1@spool9-west.superfeed.net...
> I need to setup an excel spreadsheet to calculate Great Circle distance
and
> bearing from a list of latitude and longitude data. In columns A,B,.....
> what formulae do I need?
>
>
>
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption
=----



----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Archived from groups: alt.games.microsoft.flight-sim (More info?)

"Lynndel Humphreys" <lynndel@xtn.net> wrote in message
news:42b98009$1_1@spool9-west.superfeed.net...
> I need to setup an excel spreadsheet to calculate Great Circle distance
and
> bearing from a list of latitude and longitude data. In columns A,B,.....
> what formulae do I need?

Download freeware "Distance Calculator.xls" here
http://www.gliding-in-melbourne.org/resource.htm