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

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