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: Azimith forumula for Great Circle sailings- having problems
    From: Peter Hakel
    Date: 2014 Dec 24, 22:13 +0000

    Please visit:

    You can download all spreadsheets in a single TAR or a ZIP archive file, or you can individually download only those that you are interested in.

    The weird looking fractions you asked about are an artifact of the decision I made years ago about using compound fractions to enter angular data in degrees so they fit in a single Excel cell. In retrospect the result is indeed somewhat hard to read but I am not going to go back and change it now.

    When you want to specify 39° 58' you enter 39 58/60, which then Excel displays as 39 29/30 (or something even more cryptic, such as 147/911...). The whole degree part is still visible in the original input (green) cell. As a sanity check for the user the fractional part is displayed in the neighboring gray cell in arcminutes rounded to 0.1'.

    Peter Hakel

    [rest deleted]
    Peter.  Where do I find this spreadsheet you’ve used?  Where does the 29/30 under lat and 147/911 come from?  Dave
    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