Interactive Spreadsheets for Celestial Navigation
Running fix


If two different celestial bodies are not available for simultaneous measurements, it is possible to obtain the two lines of position by observing the same  body twice within a few hours.  The first observed LOP then has to be displaced by the distance and direction traveled during the time interval between observations.  The spreadsheet running_fix.xls is an extended version of two_body_fix.xls and is used the same way.  Additional input information consists of the average speed in knots (cell A7), time interval in hours (cell B7, formatted as a regular floating-point number), and course (cell C7 - track, measured from true north clockwise).  The solutions are displayed in rows 10 and 12.  The distance traveled (in nautical miles) is in cell D7.

The following image shows the spreadsheet running_fix.xls.



Summary for spreadsheet running_fix.xls:

Input cells: A3, B3, C3, D3, E3, F3, A7, B7, C7
Output cells: D7, A10, B10, C10, D10, E10, F10,
                              A12, B12, C12, D12, E12, F12


Buy Now
Copyright . C V Imaging. All rights reserved.