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
    Name or NavList Code:
    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 from this group, send email to NavList-@fer3.com
    Browse Files

    Drop Files


    What is NavList?

    Get a NavList ID Code

    (please, no nicknames or handles)
    Do you want to receive all group messages by email?
    Yes No

    A NavList ID Code guarantees your identity in NavList posts and allows faster posting of messages.

    Retrieve a NavList ID Code

    Enter the email address associated with your NavList messages. Your NavList code will be emailed to you immediately.

    Email Settings

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