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
    Formatting in spreadsheets (was: learning sight reduction)
    From: UNK
    Date: 2006 May 4, 09:43 -0500

    In NavList 115, on Thursday, May 04, 2006 10:10 AM, Alex said:
    >> I do like the ability to enter dd/mm.m in the Casio.
    > Seems to be a unique feature that is lost on modern calculators.
    > Does your Excel have the ability to store a number is such format?
    > My spreadshit does not:-)
    > I have to allocate 3 cells for each number:
    > for whole degrees, minutes with decimals, and for fractional degrees,
    > converted (or radians).

    In Excel, I've handled this in two cells as follows:

    In the working cell -- from which calculations will be done or results
    stored -- I enter degrees using fractions. Thus, 12° 34.5' would be
    entered as: =12+34.5/60. This displays as 12.575 . Likewise 12° 34' 56"
    can be entered as: =12+34/60+56/3600.

    Next to each such decimal-degrees cell, I set up a display cell, which
    displays the adjacent value formatted naturally. To display the value
    from cell A1 as degrees, minutes, and tenths, the formula would be:

    =CONCATENATE(TEXT(INT(A1),"0"),"° ",TEXT(60*(A1-INT(A1)),"00.0'"))

    One can take that one step farther if the value is signed and should be
    labeled: for a latitude where + implies North and - implies South:

    =CONCATENATE( TEXT(INT(ABS(A1)),"0"), "° ",
                  IF(A1>0," N"," S") )

    So, each of my worksheets tends to have two columns: one for working
    values and one to format those values readably. That makes the sheet
    both readable and debuggable.

    How have others handled this?

    -- Peter

    To post to this group, send email to NavList@fer3.com
    To unsubscribe from this group, send email to NavList-unsubscribe@fer3.com
    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