© Navigation Spreadsheets - All rights reserved.

The spreadsheet transit.xls is a generalization of noon_motion.xls that can process meridian transit data (both upper and lower) for any celestial body. The rate of change of declination (in arc minutes per hour) is entered in cell F7. In cell H15 enter “U” for upper and “L” for lower meridian transit.

Summary for spreadsheet transit.xls:

Input cells: column A, column B, F1, F2, F4, F7, H3, H4, H5, H14, H15

Output cells: H9, H10, H11, H16, H17, H18

Intermediate cell: H13