NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Another "emergency navigation" sight reductionmethod
From: Hanno Ix
Date: 2015 Jul 16, 14:03 -0700
Please tell me: What cosmetic adaptations do you want to make?
The formula for all entries in my table is the same but it assumes certain relative
positions between the deg columns, the arc min rows and the specific entry cell.
So, when you reformat that table, these references might get disturbed and
the entire table becomes garbled.
Accordingly, there might be no such thing as reformatting without reprogramming.
If you'd like to do it by yourself: The formula I used is:
hav(x) = [ sin( x/2 ) ]^2
where angle x is : # degrees + #arcmin/60 and expressed in radiants.
The get angle x in radiants, you take angle x as measured in degrees,
divide that number by 180 and multiply the result with pi.
Strangely, in excel pi is expressed as PI().
H
From: Hanno Ix
Date: 2015 Jul 16, 14:03 -0700
Herman,
come to think of it: Please tell me: What cosmetic adaptations do you want to make?
If the changes are not too complicated I am happy to do this for you.
Therefore starting from scratch might turn out much simpler over all.
If you'd like to do it by yourself: The formula I used is:
hav(x) = [ sin( x/2 ) ]^2
where angle x is : # degrees + #arcmin/60 and expressed in radiants.
The #degrees and #arc min are located in the top rows and the marginal
columns, respectively
columns, respectively
On Thu, Jul 16, 2015 at 12:06 AM, Herman Dekker <NoReply_Dekker@fer3.com> wrote:
Hello Hanno,
If I have understand it correct, you have produced the 2 pages 4 digit haversine table.
Can you supply me (or us = navlist community) with the xls file?
I want to make one cosmetic adapth so it fits more for me.
regards
Herman Dekker