Welcome to the NavList Message Boards.


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

Compose Your Message

Add Images & Files
    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.



    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


    What is NavList?

    Join NavList

    (please, no nicknames or handles)
    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 Settings

    Posting Code:

    Custom Index

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

    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site