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
    ExcelNav.ZIP Question
    From: Robert Gainer
    Date: 2006 Apr 8, 10:19 -0400

    Peter, and others
    Not being a person that can program an Excel spreadsheet, I am not even sure 
    how to ask the question. In my copy of Excel, using the dialog box for 
    formatting cells I see you can define an input field as ?custom? and have 
    input in combinations of time and number. That is to say, enter a number + 
    minuets, and seconds (##0 MM SS) or just HHH MM SS using that custom mask. 
    Why can?t the spreadsheet you wrote use time as a stand-in for degrees, 
    minuets and seconds of an angle. The spreadsheet understands that a minuet 
    and a second have 60 integers in them so it would seem like you can trick it 
    into using that input mask to make a user friendly front end. If I understand 
    it correctly, you can unstring the data to use in calculations later in the 
    spreadsheet so it looks doable in the company of a sufficient amount of 
    ignorance on my part.
    Robert Gainer

    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