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, moon phases, planetary positions, including satellites and Jupiter's Great Red Spot, Messier/Nebula/Caldwell/Herschel and star 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). 

All morsels are standalone spreadsheets, without any macros, there are no security issues. 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.

Do not forget to vote!   please share your opinion about these morsels, at least if you download one or more morsels:  positive (4-5 stars) feedback implies more and better morsels ...! 

Rating: 4.9739583333333 stars
384 votes

Astronomy (Object Databases, updated!)

Deep Sky 500 Objects V1.2
Excel – 5.9 MB 746 downloads
Caldwell 109 Objects V1.2
Excel – 5.0 MB 610 downloads
Herschel 400 Objects V1.2
Excel – 1.6 MB 564 downloads
Messier 110 Objects V1.2
Excel – 2.0 MB 658 downloads
Nebulae 100 Objects V1.2
Excel – 1.9 MB 602 downloads
Monthly Highlights (CH, BE) V1.2
Excel – 1.9 MB 591 downloads
Dark Nebula V1.2
Excel – 3.7 MB 630 downloads
NEW! Top 100 Astrophotography Objects V1.0
Excel – 21.5 MB 513 downloads
Combined Database V1.0
Excel – 2.8 MB 560 downloads

Astronomy (Star Databases, updated!)

Multiple Star Systems V1.2
Excel – 1.8 MB 517 downloads
Triple Stars V1.2
Excel – 3.1 MB 499 downloads
Binary Stars V1.2
Excel – 1.6 MB 528 downloads
Visual Binary Stars V1.1
Excel – 2.2 MB 608 downloads
Brightest, Nearest Stars V1.2
Excel – 1.4 MB 512 downloads
Star Magnitudes V1.0
Excel – 669.0 KB 497 downloads
Star Data V1.0
Excel – 5.5 MB 555 downloads

Moon, Sun, Planets

Mercury Transits V1.0
Excel – 786.8 KB 510 downloads
Tides (Springs, Neads) V1.0
Excel – 1.1 MB 512 downloads
Venus Transits V1.0
Excel – 1.4 MB 496 downloads
Jupiter's Moons V1.1
Excel – 2.8 MB 563 downloads
Jupiter Great Red Spot V1.0
Excel – 1.1 MB 585 downloads
Time On Mars V1.0
Excel – 3.5 MB 496 downloads
Sun-Earth-Moon Model V1.0
Excel – 1.8 MB 694 downloads
Sun, Moon Position (full day) V1.1
Excel – 2.0 MB 578 downloads
Sun-Earth-Moon Distance V1.0
Excel – 2.5 MB 555 downloads
Sun Position V1.1
Excel – 963.5 KB 558 downloads
Moon Phase-Node Model V1.0
Excel – 1.8 MB 618 downloads
Moon Nodes V1.0
Excel – 980.6 KB 536 downloads
Moon Phases V1.1
Excel – 2.0 MB 723 downloads
Moon Position V1.0
Excel – 831.2 KB 563 downloads
Moon Illuminated Fraction V1.1
Excel – 1.6 MB 598 downloads
Satellite Orbit V1.0
Excel – 3.3 MB 529 downloads
Planet Orbits V1.1
Excel – 1.5 MB 674 downloads
Planet Fact Sheet V1.0
Excel – 461.9 KB 515 downloads
Ring of Saturn V1.0
Excel – 1.3 MB 602 downloads
NEW! Rise, Transit, Set Times V1.0
Excel – 1.2 MB 433 downloads

Astronomy (General)

Telescope Equations V1.0
Excel – 3.7 MB 664 downloads
Spacetime V1.0
Excel – 400.1 KB 532 downloads
Kepler's Laws V1.1
Excel – 1.2 MB 554 downloads
Equation of Time V1.0
Excel – 1.7 MB 536 downloads
H-R Diagram V1.0
Excel – 2.4 MB 614 downloads
Eastern Dates V1.0
Excel – 1.6 MB 498 downloads
Equinoxes, Solstices V1.1
Excel – 1.5 MB 420 downloads
Lagrange Points V1.0
Excel – 961.1 KB 511 downloads
Perihelion, Aphelion V1.0
Excel – 654.6 KB 505 downloads

Astronomical Clocks/Buildings

NEW! Antikythera Gear Train V1.1
Excel – 5.1 MB 408 downloads
Antikythera Pin-and-Slot V1.0
Excel – 1.7 MB 517 downloads
Eclipses Abacus V1.0
Excel – 6.1 MB 560 downloads
E. Eisinga Planetarium Gear Train V1.0
Excel – 2.3 MB 481 downloads
Astronomical Clock Prague V1.0
Excel – 820.7 KB 502 downloads
Gear Ratios V1.0
Excel – 11.3 MB 501 downloads

Eclipses

Eclipse Cycles V1.0
Excel – 4.7 MB 518 downloads
Eclipse Data V1.0
Excel – 8.2 MB 526 downloads
Saros-Inex Panorama V1.0
Excel – 1.9 MB 552 downloads

Sundials, Maya Solar System

Analemmatic Sundial V1.0
Excel – 3.3 MB 571 downloads
A Combined Sundial V1.0
Excel – 1.9 MB 475 downloads
Solar System Maya V1.0
Excel – 9.3 MB 484 downloads

Supporting Morsels

Coordinate Transformations V1.0
Excel – 1.0 MB 511 downloads
Utilities V1.1
Excel – 1.2 MB 559 downloads
Sun phases, Daylength V1.1
Excel – 750.7 KB 507 downloads

Prototypes, Experiments

Proto: Black Holes V0.1
Excel – 4.0 MB 469 downloads
Template V0.2
Excel – 1.1 MB 467 downloads
Proto: ΛCDM Model V0.1
Excel – 1.6 MB 457 downloads
Leftovers V1.0
Excel – 130.2 KB 473 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!