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
    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.
    Thanks,
    Robert Gainer
    
    
    

       
    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