Drop-downs are labeled "menu" and input cells are labeled "input" for ease of use. An epoch selector automatically adjusts the values of astronomical contants and obliquity of the ecliptic. You can add new epoch variables or input any year you choose. Altering the epoch selection will impact the numerical drop-down menu if the selected value changes temporally. A variety of epochs associated with ancient cultures are pre-programmed in the epoch worksheet, where you can add others. The eclipse calculator features are in the calc worksheet. The temporal selector is in the v2009 worksheet, where correlated astronomical constant values display along with lookup drop-down menus.

Some lookups support direct input of code and display the value and the code term for easy verification. All code terms are available in a single table in the aegeo worksheet. The Excel name feature in the formula bar selects the entire table to facilitate sorting. (I prefer not to create macros because some users do not download files with macros for security reasons.) The "aegeo" name selects the table. Other named ranges support the lookup and drop-down menu functions.

In the math calc area you can input both codes and multiples. Adjacent unused cells in the worksheets allow custom calculations. A variety of other features are also provided, including a logarithm calculator, a Maya Long Count converter, planetary data with a code lookup, and other conversion tools. Formuls for all the constants are displayed in the formulas worksheet.

Enjoy the applet. Feedback appreciated.

The Dresden Codex Lunar Series and Sidereal Astronomy

Eclipses, Cosmic Clockwork of the Ancients

Return to:   Archaeoastronomy   Astronomy   Home