Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsSpace ScienceAstronomyAmateur AstronomySpace FlightSpace StationShuttleSpace HistorySpace PolicySETI
SpaceKB.com
Contact UsLink To UsSearch & Site Map

Space Forum / Shuttle / June 2005



Tip: Looking for answers? Try searching our database.

Excel spreadsheet Great Circle calculator

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lynndel Humphreys - 22 Jun 2005 21:28 GMT
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?

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

Signature

Mr. Lynndel Humphreys
lynndel@xtn.net

Murray Anderson - 23 Jun 2005 04:25 GMT
William Kahan gives a stable formula at this link:
http://www.cs.berkeley.edu/~wkahan/Math128/angle.pdf
Note that he doesn't include the radius of the planet, you have to multiply
his 'v' (in radians) by the radius of the earth.
He's giving the angle between two stars using  alt-azimuth coordinates, but
his 'a' is the longitude difference, 'h' the latitude difference, and 'H'
the latitude of the first point in your application. You should filter out
the trivial cases where the tangents blow up, but the formula seems to work
anyway even if you don't (in Open Office 1.3).

Murray Anderson

> 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?
>
> =3963*(ACOS(COS(A1)*COS(A2)*COS(B1-B2))+(SIN(A1)*SIN(A2))) doesn't work for
> the distance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.