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
    Re: Noonsite using artificial horizon? Did I do it correctly?
    From: Peter Hakel
    Date: 2014 Aug 26, 07:00 -0700
    Samuel,

    The noon altitude in the example is

    70° 11.1’
    which you enter as
    70 111/600

    After entering the number Excel displays the fractional part in its base form (111/600 becomes 37/200), so the 11.1’ is also displayed in the neighboring gray cell to verify the input. The integer part (70) can still be seen in the green cell.

    If you want to enter degrees/minutes/seconds, then you can do so with a formula (i.e., preceded by the = symbol), so:

    70° 11’ 06”
    is entered as
    = 70 + 11/60 + 6/3600

    Entering
    = 70 + 11.1/60
    also works.

    Take special care to handle negative numbers. If you go with the compound fraction form, there is only one minus sign up front, so the declination in the example (S 13° 24.6') is entered as

    -13 246/600

    However, if you want to use a formula, then we have minus signs preceding each term:

    = -13 - 246/600

    or you can factor the minus (to represent southern declinations/latitudes and western longitudes):

    = - ( 13 + 246/600 )


    Peter Hakel



    From: Samuel L <NoReply_SamuelL@fer3.com>
    To: pmh099---.com
    Sent: Tuesday, August 26, 2014 6:56 AM
    Subject: [NavList] Re: Noonsite using artificial horizon? Did I do it correctly?

    Got the excel spreadsheets last year but have no idea how to enter degrees, minutes & seconds into them.
    For example- the noon_sight.xls shows in the example (http://www.navigation-spreadsheets.com/noon_shots.html) Noon Altitude 70    37/200  and Declination  -13  41/100
    No idea what the 37/100 and 41/100 mean.
    Can you explain it to me?


       
    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