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
    Perpetual Almanac and Sight Reduction
    From: Andy Smith
    Date: 2010 Feb 16, 01:23 -0800

    Greetings from a new member to this group.

    I've been an avid yachtsman for most of my life and have always managed to find my way by compass and sextant, albeit with the aid of Decca, and latterly the wonders of GPS. My interests in traditional methods of navigation have never waned however and I am keen to develop my skills.
    If of interest to the group I've attached the following links to some spreadsheets I developed to aid my own understanding.

    The perpetual almanacs are for the SUN only and will give you GHA and Declination for the next hundred years or so.

    The Sight Reduction spreadsheet lets you enter your GPS position as your EP. Something I found very useful when I was in the Med and the US Dept. of Defense were messing with Selective Availability during Gulf War 1.

    I also have my own slant on the Air Tables pub 229, but it's a pretty big file at 10Mb. I'll post a link if there's enough interest.

    A perpetual almanac for Excel 2003

    A perpetual almanac for Excel 2007

    Sight reduction spreadsheet for Excel 2003

    Sight reduction spreadsheet for Excel 2007

    For all files you will have to enable Iteration under Tools/Calculation. The Sight Reduction Spreadsheets require Macros enabled.

    The files are password protected to prevent accidental deletion or corruption of any cell. If you wish to delve deeper into the spreadsheets the password is overmydeadbody

    If there are any errors in my spreadsheets I would welcome feedback.

    NavList message boards and member settings: www.fer3.com/NavList
    Members may optionally receive posts by email.
    To cancel email delivery, send a message to NoMail[at]fer3.com

    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