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
    Name or NavList Code:
    Email:
       
    Reply
    Re: Navigation spreadsheet lessons
    From: Peter Fogg
    Date: 2009 Jan 17, 19:35 +1100


    Frank wrote:

    We need one more formula to get near the almanac table. Refraction modifies dip by some factor. So let's add a label below "R earth:". In cell A16, type "ref factor:". Then in cell B16, enter 0.85 ...

    And now we can finally do something useful with this spreadsheet. You can enter trial values for "ref factor" until your table matches the one in the Nautical Almanac. And just that easily you have reverse-engineered their table.
     

    The "ref factor" that gives the same results (to six or seven decimal places) as the formula:
    Dip = (sqrt height of eye in feet)*0.95
    is 0.8935097, but I guess that this formula uses an approximation of refraction anyway .. and maybe the 0.95 is also an approximation?

    --~--~---------~--~----~------------~-------~--~----~
    Navigation List archive: www.fer3.com/arc
    To post, email NavList@fer3.com
    To , email NavList-@fer3.com
    -~----------~----~----~----~------~----~------~--~---

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Get a NavList ID Code

    Name:
    (please, no nicknames or handles)
    Email:
    Do you want to receive all group messages by email?
    Yes No

    A NavList ID Code guarantees your identity in NavList posts and allows faster posting of messages.

    Retrieve a NavList ID Code

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

    Email Settings

    NavList ID 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