# NavList:

## A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Message:αβγ
Message:abc
 Add Images & Files Posting Code: Name: Email:
Re: Z or ZN and a couple other fx 260 to excel conversions
From: Greg R_
Date: 2006 May 30, 00:34 -0700

```Guy wrote:

> Using the calculator my Hc is 58 deg 20.4 min. Using a demo version of
> navigator light it give me an Hc of 58 deg 51.0 min.

That's off by ~30 NM, so something's not right somewhere - make sure
you're using the same AP for both calculations, otherwise I'll have to look
at this in more detail when I have more time than I do right now.

As a side note, I *have* reduced sights by calculator in the past and the
results were very close to HO 249 (their Z values are whole numbers, so you
may see a difference there when you do it more "accurately" without rounding
on a calculator).

> When I pluged =SIN(A4*PI()/180) into my spread sheet it returned
> 0.014855204

What value do you have in cell A4? That formula was copied/pasted from my
own Excel worksheet - as always, your mileage may vary depending on how you
have yours setup...  :-)

> I was looking for a number like 58.33935111

Depending on what you have in cell A4, that looks like a valid sine value to
me.

Sine values (at least the ones that I'm familiar with) run from 0.0000 to
1.0000 - I think what you're looking for here is an arcsine (what you were
calling "Shift Sin-1" earlier) - for that you would use the ASIN function.

--
GregR

----- Original Message -----
From: Guy Schwartz
Sent: Monday, May 29, 2006 8:24 PM
Subject: Re: Z or ZN and a couple other fx 260 to excel conversions

Using the calculator my Hc is 58 deg 20.4 min. Using a demo version of
navigator light it give me an Hc of 58 deg 51.0 min.  The Az  Calc is 210.
The 210 agrees with HO 249 and Navagatoir Light. My issue is when I did the
calculation for Zn I wound up with 148 deg 11.4 min.

When I pluged =SIN(A4*PI()/180) into my spread sheet it returned
0.014855204

I was looking for a number like 58.33935111

On one of my spread sheet I break up Deg, minutes and seconds on another I
use the H:mm:ss formating however it will not do the trig as you know.

```
Browse Files

Drop Files

### 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)