NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Z or ZN and a couple other fx 260 to excel conversions
From: Guy Schwartz
Date: 2006 May 29, 11:56 -0700
From: Guy Schwartz
Date: 2006 May 29, 11:56 -0700
I was working out a problem here are the particluars
DR 40 deg 9 min N
45 deg W
object Regulus
Dec 11deg 59. 9 min N
LHA 16:25:48
HC 58 Deg 20.4 Min
Using HO 249 the Z is 150 and the ZN is 210 I also checked with the star
section and the ZN was the same.
When I did the calculations using
Cos rasied to -1 (Zn) = sin (dec) - Sin (lat) x sin (Hc) / cos (Hc) x cos
(lat)
The answer came out to 148 deg 11.4 min which is close to the 150 Z however
I though that formula gave me the Zn?
New question, what is the equalvalent function in excel to the Shift
Sin-1
and the Shift Cos-1
Thank you.
Guy
| Hc and Zn by calculation using Casio fx 260 calculator | ||||||
| Sin-1Hc = sin(dec) x sin(lat) + cos(dec) x cos(lat) x cos(LHA) | ||||||
| sin(dec) | x | sin(lat) | = | |||
| A= | 0.207883238 | X | 0.644790904 | 0.134041221 | ||
| cos(dec) | x | cos(lat) | x | cos(LHA) | = | |
| B= | 0.978153648 | X | 0.764359006 | X | 0.959166009 | 0.717130586 |
| Total A + B | 0.851171807 | |||||
| Declination, +North -South | Shift Sin-1(Hc) | |||||
| Latitude, +North -South | 0999 Hc | |||||
| Cos-1 (Zn)= sin(dec) - sin(lat) x sin(Hc) / cos(Hc) x cos(lat) | ||||||
| cos(Hc) | x | cos(lat) | = | |||
| A= | 0.524877545 | X | 0.764359006 | 0.401194878 | ||
| sin(lat) | x | sin(Hc) | = | |||
| B= | 0.644790904 | X | 0.85117775 | 0.548831671 | ||
| sin(dec) | - | B | = | |||
| C= | 0.207883238 | - | 0.548831671 | -0.340948434 | ||
| C | / | A | = | |||
| D= | -0.340948434 | / | 0.401194878 | -0.849832469 | ||
| Shift Cos-1 (Zn) | ||||||
| 0999 Zn | ||||||
