NavList:

In my previous post I did not zip the Celestial Navigator workbook & it was not included. See attachment for a zipped copy of my Celestial Navigator workbook.

I use this workbook as used as a teaching aid in my USPS JN & N Classes & would appreciate any suggestions or additions for improveing it's utility.

Ron

______________________________________________________________________________________________________________________________

The Celestial Navigator Excel Workbook contains the following worksheets:

 ■  Nav Bodies .. GHA, Dec & other data for Sun, Moon, Planets & Stars for a given date, time & position
 ■  Sight Planning .. Help in selecting sights for a two or three body fix
 ■  Sight Averaging .. Shows a graph of up to 10 sights and allows bad sights to be removed
 ■  Sight Reduction .. Using Law of Cosines Method +NASR +Time Diagram +Meridian Diagram
 ■  SR 96 .. Sight Checker for USPS Form SR96
 ■  SR by DC .. Sight Reduction by Direct Computation, Nautical Almanac pages 277--> 285
■  Fix by DC ... Position from intercept & azimuth by direct calculation (See page 282 &283 of Nautical Almanac)
 ■  Hs to Ho .. Calculating Ho from Hs, Nautical Almanac pages 280 & 281
 ■  Moon Ha to Ho .. Nautical Almanac Moon Altitude Corrections
 ■  Meridian Transit .. Latitude by Sight on a body at meridian transit
 ■  Polaris .. Latitude by Sight on Polaris, Nautical Almanac pages 274 & 275
 ■  24 Hc & Zn .. A graph of the Sun's Altitude and Azimuth vs Zone Time for a given date & position
 ■  Analemma .. A graph of the Sun's Declination vs the Equation-of-Time for an entire year
 ■  NAV Coordinates .. Celestial Navigation Coordinates & the Celestial Sphere
 ■  Yellow Pages .. Nautical Almanac Increments & Corrections
 ■  DR 2 Body Fix ..Two Body Fix,  from a DR position
 ■  AP 2 Body Fix .. Two Body Fix, from an assumed position
 ■  DR 3 Body Fix .. Three Body Fix, from a DR position
 ■  AP 3 Body Fix .. Three Body Fix, from an assumed position
 ■  Set & Drift .. Calculates set & drift +Track & SMG + Course to Steer & SOA
 ■  60 D ST .. Speed, Time & Distance calculations
 ■  Interpolation & Data Conversions
 ■  Arrival Coordinates .. Calculated using mid-latitude sailing equations
 ■  Course & Distance .. Calculated using rhumb line equations
 ■  Great Circle Route .. Calculates Great Circle Distance and initial course heading
 ■  Rhumb Line .. Distance vs. Great Circle Distance
 ■  Tides .. Rule of 1/12 for Tide Prediction

Note: Cell A1 of most worksheets contain an explanatory note of additional user information.