MERIDIAN TRANSIT ON A MOVING VESSEL
© 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