© Navigation Spreadsheets - All rights reserved.

The spreadsheet average2.xls performs the same function as average1.xls, but for observed altitude data (Ho) in column B, while allowing the procedure to also choose the slope of the fit. Additional input data include the speed (cell F1) and course (cell F2) of the vessel, the hourly declination change rate (cell F5, in arcminutes), and azimuth (cell F7, in degrees) of the observed body. The remaining cells serve the same function as in average1.xls. The weights in column D should come out neither all 1.000, nor all (but two) very small.

Summary for spreadsheet average2.xls:

Input cells: column A, column B, F1, F2, F5, F7, F9, F17

Output cells: column D, F10, F11, F12, F14, F15, F16, F18, G9, G10, G11, G12