SUBSIM Radio Room Forums - View Single Post - Almanac and Celestial Navigation Calculator

Sean C · 01-16-21, 03:17 AM

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.

01-16-21, 03:17 AM	#10
Sean C Grey Wolf Join Date: Jun 2017 Location: Norfolk, VA Posts: 984 Downloads: 16 Uploads: 2	Update! 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. __________________ 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.