# Excel Great Circle calculator

Tags:
Last response: in Video Games
Share
Anonymous

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 =----
Anonymous

=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 =----
Anonymous

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
> =----
Related resources

good start.. what [is the] format of Lat and Long?

-G

On Wed, 22 Jun 2005 16:20:58 GMT, "RHinNC" <rhinnc@hotmail.com>
brought the following to our attention:

>
>Found this awhile back, dont remember where tho....
>
>
>"Lynndel Humphreys" <lynndel@xtn.net> wrote in message
>
>>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
>> =----
>

"Gregory"

Dallas
Anonymous