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

    On Thu, 4 May 2006 Smith_Peter@emc.com wrote:

    >How have others handled this?

    More or less the same way you did.
    My spreadsheet consists essentially of
    three columns: one for whole degrees,
    second for minutes with fractions,
    third for radians.
    Exception in the row where I enter time
    it has an extra cell for time seconds.

    The rows are of two types: input rows and
    output rows. In the input rows I enter
    degrees and minutes of my input,
    and the formula in the radian cell transfers them
    to radians.
    The output rows act in the opposite direction.
    The radian cell contains some formula for computing
    some quanity, like azimuth, altitude, or a distance,
    it is computed in radians.
    Then the result is translated into degrees and minutes
    by a formula in each correspoinding cell of the same row.

    I have several spreadsheets for varioius tasks.
    (Sun altitudes, stars, planets, star distances and Lunar distances).

    The idea to CONCATENATE degrees and minutes in one
    output cell did not occure to me:-)
    Thanks for suggesting it.


    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