# NavList:

## A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Message:αβγ
Message:abc
 Add Images & Files Posting Code: Name: Email:
Re: Sight reduction methods
From: Ron Jones
Date: 2015 Nov 6, 16:49 -0800

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.

Browse Files

Drop Files

### Join NavList

 Name: (please, no nicknames or handles) Email:
 Do you want to receive all group messages by email? Yes No
You can also join by posting. Your first on-topic post automatically makes you a member.

### Posting Code

Enter the email address associated with your NavList messages. Your posting code will be emailed to you immediately.
 Email:

### Email Settings

 Posting Code:

### Custom Index

 Subject: Author: Start date: (yyyymm dd) End date: (yyyymm dd)