CelNav Spreadsheet Change Log/Bug Fixes
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.
· 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.
v 0.3.1 - 2021, Oct 31
· Added rise, set, transit and twilight calculator.
· Increased precision of azimuths on the printable list to 0.1°.
· Added button to Data Series calculator to get the date and time from the Almanac.
· Added ecliptic longitude of Sun, Moon and planets to the Data Series calculator to facilitate determination of the times of equinoxes, conjunctions, etc.
· Corrected a minor error in the calculation of Ha of the LL of the Moon and Sun at extremely low altitudes.
· Added PA correction to the Sun.
· Updated delta-T table.
· Extended visibility chart to -5°.
· Minor formatting changes.
v 0.3.2 - 2021, Nov 2
· Fixed a bug [again] causing the spreadsheet to display incorrect values for the equation of time under certain circumstances.
v 0.3.3 - 2021, Nov 7
· Added the option to the sky chart to display all 1,535 stars in the basic FK5 catalogue. (This increased the size of the spreadsheet from 2.5MB to 3.7MB.)
· Tip: You can hover your mouse over any star to see its calculated azimuth and altitude.
· Fixed a bug causing the almanac date and time to change when using the data series or rise/set calculators. (Almanac date and time will still change when using the sight reduction tab.)
· Improved map alignment. Waypoints and DR/Fix will now be plotted more accurately.
· Minor formatting changes.
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.
v 0.3.5 - 2023, September 10
· Fixed a very old bug causing the LMST/LAST to exceed 24h.