NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Sight Reduction Spreadsheet
From: Peter Hakel
Date: 2015 Jan 17, 21:07 +0000
From: Sean C <NoReply_SeanC@fer3.com>
To: pmh099@yahoo.com
Sent: Saturday, January 17, 2015 7:21 AM
Subject: [NavList] Sight Reduction Spreadsheet
Attached File:
(Plot.xlsx: Open and save or View online)
From: Peter Hakel
Date: 2015 Jan 17, 21:07 +0000
Sean,
You probably meant this one:
Cheers,
Peter Hakel
From: Sean C <NoReply_SeanC@fer3.com>
To: pmh099@yahoo.com
Sent: Saturday, January 17, 2015 7:21 AM
Subject: [NavList] Sight Reduction Spreadsheet
I could have sworn there was a recent message on NavList about using Microsoft Excel to calculate GC routes and how using degrees in Excel is tricky. But I can't find it now. Anyway, I was working some sights and wanted to use the N.A. formula as a check for my plot. But using the formula with a TI-30XIIs can get laborious, so I decided to see if I could make my own spreadsheet to do the calculations. (No offense to all of the other authors out there.) The result is attached. Feel free to alter it as you like. The sheets are protected, but there's no password. I haven't tested all possible types of combinations, but what I have tried seems to work just fine. Any feedback would be most welcome. The first sheet was my main goal. The other three were added in a fit of obsession. I may add more. ;)
...And it was tricky, IMHO.
Regards,
Sean C.
Attached File:
(Plot.xlsx: Open and save or View online)
