Almanac and Celestial Navigation Calculator

[Sean C]

Originally Posted by ET2SN

is it possible to download the zipped version?

Well, I'm home. I must admit: it took me a while to figure out how to download the file myself. Apparently you might need to "open the sidebar" (see attached pic) before you see the download button. Maybe I should use another file sharing service.


Also, here is a link to the unzipped spreadsheet. I also attached it to the first post.

[Sean C]

FYI: It seems my spreadsheet may lose functionality or output incorrect data if opened with a program other than MS Excel.


First post updated.

[Sean C]

Bug fixes/changes:

• 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.

Should be even more accurate now. (Still only guaranteed to work on Excel, sorry.)


See my sig or the first post for the link.


Cheers!


PS
I am going to have that Dionne Warwick song stuck in my head forever now. Thanks, vienna.

[Skybird]

All nice and well, but the engine still cannot play the Subsim Defence, Skybird variation.

[Sean C]

Links have been updated in the first post. Or, see my sig.



Bug fixes/changes:

• 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.

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.

[Sean C]

Bug fixes/changes:

• 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.

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

[Sean C]

Just found a new bug: the data series calculator gives incorrect distances for stars. That will be fixed in the next version.