NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Noonsite using artificial horizon? Did I do it correctly?
From: Peter Hakel
Date: 2014 Aug 26, 07:00 -0700
From: Samuel L <NoReply_SamuelL@fer3.com>
To: pmh099@yahoo.com
Sent: Tuesday, August 26, 2014 6:56 AM
Subject: [NavList] 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
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@yahoo.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?
