Welcome to Astronomy Morsels!

Explore a collection of astronomy-related spreadsheets (called "morsels").

Access a variety of handy morsels covering topics such as Spacetime (special relativity), Lagrange points (points of equilibrium), telescope equations, eclipse predictors, moon phases, planetary positions, including satellites and Jupiter's Great Red Spot, star and Messier object observations, eclipse cycles and the Sarox-Inex Panorama, some sundial designs, etc. Also, models of gear trains of astronomical clocks are analysed (e.g., Antikythera, Eise Eisinga Planetarium, Prague Orloj, Ancient Maya Solar System). These morsels are free till 31.12.2024 and I sincerely hope they aid in your astronomical interests. From 2025 on, so-called "morsel packages" will be offered for a fair/reasonable price. 

Remark: all morsels are standalone spreadsheets, without any macros, there are no security issues. Instead of online apps with hidden formulas, these morsels show every calculation step and can be adjusted/improved according to your needs. All morsels have been carefully reviewed, and calculation results have been compared with other applications. But, Astronomy Morsels expresses no warranty: use is at your own risk.

Request: please share your opinion about these morsels, at least if you have downloaded one or more,  positive (4-5 stars) feedback implies more and better morsels ...! 

Rating: 5 stars
17 votes

Moon, Sun, Planets

NEW! Equinoxes, Solstices V1.0
Excel – 1.5 MB 5 downloads
NEW! Moon Nodes V1.0
Excel – 985.3 KB 3 downloads
Moon Phases V1.0
Excel – 1.6 MB 30 downloads
NEW! Jupiter Great Red Spot V1.0
Excel – 1.1 MB 13 downloads
Jupiter Moons V1.0
Excel – 2.6 MB 22 downloads
NEW! Time On Mars V1.0
Excel – 3.5 MB 10 downloads
NEW! Visual Binary Stars V1.0
Excel – 776.2 KB 10 downloads
NEW! Sun's Position V1.0
Excel – 963.3 KB 4 downloads
Sun-Earth-Moon Model V1.0
Excel – 1.8 MB 37 downloads
Moon Phase-Node Model V1.0
Excel – 1.8 MB 26 downloads
Planet Fact Sheet V1.0
Excel – 358.7 KB 13 downloads
Planet Orbits V1.0
Excel – 3.0 MB 35 downloads
NEW! Perihelion, Aphelion V1.0
Excel – 655.9 KB 0 downloads

Astronomy (general)

Telescope Equations V1.0
Excel – 3.7 MB 71 downloads
Spacetime V1.0
Excel – 400.1 KB 34 downloads
Lagrange Points V1.0
Excel – 961.0 KB 25 downloads
Kepler's Laws V1.1
Excel – 1.2 MB 33 downloads
Messier Observations V1.0
Excel – 927.8 KB 29 downloads
NEW! Eastern Dates V1.0
Excel – 1.6 MB 1 download
Object Data (Star, Nebulae,...) V1.0
Excel – 2.7 MB 38 downloads
Equation-of-Time V1.0
Excel – 1.7 MB 26 downloads
H-R Diagram V1.0
Excel – 2.4 MB 26 downloads

Astronomical Clocks/Buildings

Antikythera Gear Train V1.0
Excel – 3.6 MB 24 downloads
Antikythera Pin-and-Slot V1.0
Excel – 1.7 MB 18 downloads
Eclipses Abacus V1.0
Excel – 6.1 MB 20 downloads
E. Eisinga Planetarium Gear Train V1.0
Excel – 2.3 MB 16 downloads
Astronomical Clock Prague V1.0
Excel – 784.4 KB 23 downloads
Gear Ratios V1.0
Excel – 11.3 MB 19 downloads

Eclipses

Eclipse Cycles V1.0
Excel – 4.7 MB 23 downloads
Eclipse Data V1.0
Excel – 8.2 MB 19 downloads
Saros-Inex Panorama V1.0
Excel – 1.9 MB 19 downloads

Sundials, Maya Solar System

Analemmatic Sundial V1.0
Excel – 3.3 MB 15 downloads
A Combined Sundial V1.0
Excel – 1.9 MB 18 downloads
Solar System Ancient Maya V1.0
Excel – 9.3 MB 15 downloads

Stars

Star Magnitudes V1.0
Excel – 668.9 KB 6 downloads
Star Data V1.0
Excel – 5.5 MB 13 downloads
Star Observations V1.0
Excel – 465.9 KB 27 downloads

Supporting Morsels

RA, DEC, LST, HA V1.0
Excel – 285.1 KB 12 downloads
Utilities V1.1
Excel – 1.2 MB 19 downloads
Daylength V1.0
Excel – 742.2 KB 17 downloads

Prototypes, experiments

Proto: Black Holes V1.0
Excel – 4.0 MB 6 downloads
Proto: Template V0.1
Excel – 61.6 KB 7 downloads
Proto: ΛCDM Model V0.1
Excel – 1.6 MB 6 downloads

Regarding Proto Morsels:  you are invited to help think how the morsel in question might look, focus on mathematical equations that can be implemented in Excel.

Feel free to share your thoughts!

 

Do you have ideas for new morsels? Do you have tips for improving existing morsels?

Did you find any bugs? Be in touch!