Welcome to the NavList Message Boards.

NavList:

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

Compose Your Message

Message:αβγ
Message:abc
Add Images & Files
    or...
       
    Reply
    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.



    File:
    Celestial-Navigator-12-1-5.zip

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    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)

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