The ex_meridian.xls spreadsheet has the same general format of input and output cells as the other meridian-transit-category spreadsheets. The one extra input data point is in cell B11 marking the time away from the actual meridian transit in the hours:minutes:seconds (HH:MM:SS) format. Cell B12 displays the intermediate results: (altitude factor) from Bowditch Table 24, and cell B13 shows the absolute value of the resulting change in altitude/ latitude from Bowditch Table 25. The ex_meridian_t.xls version of this spreadsheet takes the meridian angle t (in degrees) as input in cell B11.

Summary for spreadsheets ex_meridian.xls, ex_meridian_t.xls:

Input cells: B1, B3, B4, B5, B9, B11, B15

Output cells: B16, B17, B18

Intermediate cells: B12, B13