SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997 |
01-16-21, 03:17 AM | #16 |
Grey Wolf
|
Update!
Links have been updated in the first post. Or, see my sig.
Bug fixes/changes:
I still want to add Sunrise/set/twilight times. And maybe even some other calculators such as "Time Sights" and "Lunars". We'll see ... Enjoy! Sean C.
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet Last edited by Sean C; 01-16-21 at 03:34 AM. |
01-23-21, 06:02 AM | #17 |
Grey Wolf
|
Update!
Bug fixes/changes:
See the first post or my sig for the link. The new data series calculator can be used to make charts like the following for data comparison or analysis: Some stats: Total Sheets: 18 Cells with data: 180,868 Tables: 4 Formulas: 8,373 Charts: 2 Macros: 26 Days I've been working on it so far: 237
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
01-23-21, 09:16 AM | #18 |
Grey Wolf
|
D'oh!
Just found a new bug: the data series calculator gives incorrect distances for stars. That will be fixed in the next version.
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
01-27-21, 05:54 PM | #19 |
Grey Wolf
|
New version is available at my new website:
https://www.cooknavigation.com Bug fixes/changes:
Cheers!
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
02-02-21, 07:25 AM | #20 |
Grey Wolf
|
Update!
New version posted at my website.
Changes: v 0.2.6
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
02-06-21, 07:08 AM | #21 |
Grey Wolf
|
Update!
New version at my website.
beta v 0.2.7 Bug fixes/changes:
*** The spreadsheet is now also in the "Utilities" section of the SubSim downloads area. *** And here's an animation I made showing "Xerxes' Eclipse" on Oct. 2nd, 480 BC:
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet Last edited by Sean C; 02-06-21 at 09:08 AM. |
02-08-21, 12:57 AM | #22 |
Stowaway
Posts: n/a
Downloads:
Uploads:
|
Hi Sean C - Just a simple word of gratitude for your work and kind generosity. Thank you.
|
02-08-21, 10:12 AM | #23 | |
Grey Wolf
|
Quote:
You're very welcome! By the way, I just added my PostScript plotting sheets to my site. I'll upload them here too, if there's any interest in them. Cheers!
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
|
02-28-21, 04:19 AM | #24 |
Grey Wolf
|
Update!
New version available in the downloads section.
v 0.2.8 - 2021, Feb 28
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
10-31-21, 09:09 PM | #25 |
Grey Wolf
|
Update
New version available in the downloads section.
v 0.3.1 - 2021, Oct 31
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
11-02-21, 07:04 AM | #26 |
Grey Wolf
|
Update
Apologies, but I just found a bug ... of course. And it's a bug I thought I had already squashed. Maybe I'll get it right this time ... [Link]
v 0.3.2 - 2021, Nov 2
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
11-07-21, 03:20 AM | #27 |
Grey Wolf
|
Update
I have added the option to the sky chart to display all 1,535 stars in the basic FK5 catalogue (see screenshot, below). As with the navigational stars, corrections for proper motion have been included. There is a check-box below the chart to show or hide them. These will not be selectable in the almanac or sight reduction calculator. But if you hover your mouse over them, the calculated azimuth and altitude will be displayed. So, they can be used for navigation in a pinch ... you'll just have to plot the LOPs manually. Maybe I will change this in the future.
I have also tweaked the map alignment. Waypoints shouldn't be plotted off the edge of the map anymore [mostly], and the waypoints, DR and fix should be plotted a bit more accurately. (Although at this scale I admit it's hard to see the difference.) As always, the new version is available in the downloads section. Cheers! v 0.3.3 - 2021, Nov 7
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet Last edited by Sean C; 11-07-21 at 06:01 AM. |
10-24-22, 08:38 PM | #28 |
Grey Wolf
|
New version available in the downloads section:
v 0.3.4 - 2022, Oct 24 · Added day of the week calculation on Almanac tab. · Added the option to display the celestial equator and ecliptic to the sky chart. · Added the ability to increment time on the Almanac tab. · Updated the delta-T values. · Moved the "Auto-Fill" button for the date of celestial sights and added an arrow to hopefully clarify the button's purpose.
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
10-09-24, 07:41 PM | #29 |
Grey Wolf
|
Update
New version available in the downloads section:
v 0.3.5 - 2023, September 10 · Fixed a very old bug causing the LMST/LAST to exceed 24h. v 0.3.6 - 2024, October 9 · Updated Delta-T values and extended the predictions to 2035. · Corrected an error in the Delta-T tables which caused all BC years to be off by one year. The error resulted in a very minor mis-calculation of the position of all celestial bodies, most notably: the Moon. · Updated the text above the Almanac output fields and printable list to indicate whether the year is BC or AD. This text will now also show the Julian calendar year for BC years. (I.e. it will not display a year "zero".) · Fixed a bug which caused the times of rise, set & transit of the Moon to be calculated incorrectly under certain circumstances.
__________________
If you have a question about celestial navigation ... ask me! Celestial Navigation Spreadsheet |
Tags |
almanac, celestial navigation, excel, great circle, spreadsheet |
|
|