SUBSIM Radio Room Forums


SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997

Go Back   SUBSIM Radio Room Forums > Downloads > Utilities
Mods, missions, patches, & files for every subsim there ever was!

If you are experiencing trouble downloading, it could be due to an ad-blocker or extension in your Chrome browser.

Try whitelisting www.subsim.com in your ad-blocker extension, or switching to Microsoft Edge browser or Firefox to complete the download. Thanks.

Forget password? Reset here

Navigation
Main | Legacy Downloads | Utilities | Category Tree | Stats | Search

You must be registered with this forum to download files. If you are registered and getting this message,
then the Downloads section is experiencing heavy load volumes and has been temporarily restricted to members
who are in the Subsim Navy (donors). Please try again later.

 

Become an officer in the Subsim Navy here and have your download limit increased to 25, 35 or even 60 a day! Click here to join.

A website this big uses a lot of bandwidth and needs a really powerful server to stay online day after day, for 20 years. Thanks for the support!

File Name: Excel Almanac and Celestial Navigation Calculator (2.37 MB) Download
Author: Sean C (Uploaded by Sean C)
Date Added: 02-06-2021
Downloads: 30
Grade: Not Rated
Description
Almanac and celestial navigation calculator beta v0.2.8 for Microsoft Excel.
Updated Feb. 28th, 2021







Current features:

Perpetual almanac displays basic data necessary for celestial navigation
Sky chart showing traditional navigation bodies above the horizon
Printable list of celestial bodies above the horizon
Data series calculator for comparison/analysis
DR and sight reduction calculator
Position log
Great circle route calculator including internal database of 26,572 cities worldwide
Internal delta-T values for dates between 500 BC and AD 2030
Custom delta-T value fields for dates outside the above range
Only 2.5MB
* Verified to run on current versions of Microsoft Excel only *


Forum thread: https://www.subsim.com/radioroom/sho...d.php?t=247949


Hash values:

CelNav (Beta_v028).xlsm: MD5 = 35 72 C2 BE 26 77 8C 77 D9 25 77 E4 69 BC AE 52
CelNav (Beta_v028).xlsm: SHA1 = 9D94 B9B7 F900 5B49 EDBC B4EF AE6C FC00 7856 A63F
CelNav (Beta_v028).xlsm: RMD160 = DC48 607A 0CCB 18BD F7DC 8009 B5B0 765C 81EB 1EFE
CelNav (Beta_v028).xlsm: SHA224 = BF83062A 35509A11 6A64EEC8 182C07D1 39FB55C7 A4040090 25CE7F3F
CelNav (Beta_v028).xlsm: SHA256 = C96556DD 3D2A3938 BB10D4FB F09C72C8 C26BC658 00CECF1C C13436C0 274987BE
CelNav (Beta_v028).xlsm: SHA384 = 09AF3F95 3B154565 F5D27502 2CA9BB06 60DE6B9B C905F820 2DA88F6E E42090E7 5E9598B6 EF9227C4 0B693F3B E2A866F7
CelNav (Beta_v028).xlsm: SHA512 = 43294C61 D4990B0B AAA21EB1 6EE60192 8FE11ECD 8E810275 1FD2E622 A2CBE105 212FC350 40B17982 BF7857B5 6C8D9DFA D86F4A56 8031C096 5FAFC6DF F03FC244


If you have any questions, ask me in the forum or at my website:

https://www.cooknavigation.com

Thanks!

Shawn Cook
a.k.a.: Sean C
2021, Feb. 6th 13:45Z


Changelog:

v 0.2.1 - 2021, Jan 1

There was a bug causing some leap year dates to be calculated incorrectly. I fixed it ... I think.
Updated the delta-T values and extended the table into the past just a little. o.O
The notes on the Almanac tab did not reflect the changes. I polished them until they did.

v 0.2.3 - 2021, Jan 16

Fixed the bug preventing the sight reduction cells from clearing correctly ... I think.
Delta-T values are now interpolated for dates between table entries. This will have the most noticeable effect on really old dates which cannot be completely trusted anyway.
Added a note about compatibility issues. We're just not right for each other. (LibreOffice, not you - you're cool.)
Discovered the "Application.ScreenUpdating" VBA object. The spreadsheet generally runs more smoothly after a liberal application to the macros (as you do).
Added a nifty sky chart showing the positions of all visible traditional navigational bodies for the currently selected time and location which isn't quite what I intended, but looks pretty cool nonetheless.

v 0.2.4 - 2021, Jan 23

Fixed a long forgotten bug causing DRs to be calculated incorrectly when crossing the IDL.
Fixed the bug causing the "Send to Log" button to overwrite manual entries.
Added a "Data Series" tab which calculates data for a specified period and interval.
Created a new bug by doing the above. (See "Instructions" tab.)
Added a bar below the sky chart which indicates day/twilights/night.
Added notes about stellar positions/magnitudes on the "Instructions" tab.
Updated my contact email address. Please do not send mail to the previously listed one. Thank you.

v 0.2.5 - 2021, Jan 24

Fixed a bug causing the data series tab to display incorrect distances to some stars.
By request: Added Hiva Oa and Nuku Hiva, Fr. Polynesia to the city database.
Added unit indicators to the data series table headers.
Clarified the note about stellar magnitudes.
Added some credits to the "Instructions" tab.

v 0.2.6 - 2021, Feb 2
Added printable bodies list
Reformatted notes on "Precession and Stars" tab

v 0.2.7 - 2021, Feb 5
Fixed a bug causing the intercept "away/toward" cell for sight #10 to remain empty
Updated the cities database from ~15,500 cities to Pareto's current [free] offering: 26,570 cities (+ the two suggested cities)


v 0.2.8 - 2021, Feb 28
Increased the number of decimals of azimuth included in the data series to a ridiculous precision.
Fixed a bug causing the spreadsheet to display wildly inaccurate values for the equation of time under certain circumstances.
Images
Excel Almanac and Celestial Navigation Calculator by Sean C on 02-06-2021

You must be registered with this forum to download files. If you are registered and getting this message,
then the Downloads section is experiencing heavy load volumes and has been temporarily restricted to members
who are in the Subsim Navy (donors). Please try again later.

 

Become an officer in the Subsim Navy here and have your download limit increased to 25, 35 or even 60 a day! Click here to join.

A website this big uses a lot of bandwidth and needs a really powerful server to stay online day after day, for 20 years. Thanks for the support!



Comments


DownloadsII 5.1.0 by CyberRanger & Jelle
Based on ecDownloads 4.1 © Ronin
Graphics by Danlisa

All times are GMT -5. The time now is 05:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 1995- 2021 Subsim®
"Subsim" is a registered trademark, all rights reserved.