The Mother of all Spreadsheets (MOAS) from the Chief

As Chief Engineer, I am required to keep proper records. As an ex-CFO, I am probably slightly manic about this responsibility. So I have devised "The Mother of all Spreadsheets" (MOAS) which takes very little input and gives an extraordinary amount of output.

Here is the Daily Input:
1. Main engine hours
2. Generator hours
3. Fuel onboard

Here is the passage specific Input:
1. Destination
2. Miles to Destination
3. Date/Time of Departure
4. Daily Miles Made Good to Destination
5. Daily Lat/Lon at 10:00AM Local

Here is the Output:
Main Engine
1. Hours left on Fuel Filter and yellow light when getting close; red light when due
2. Hours left on Oil Filter and yellow light when getting close; red light when due
3. Hours left on Oil Change and yellow light when getting close; red light when due
4. Hours left on Impeller Change and yellow light when getting close; red light when due
5. Average % of engine use vs. sails
6. Daily Liters Fuel/hour
7. Average Liters Fuel/hour
Generator
1. Hours left on Fuel Filter and yellow light when getting close; red light when due
2. Hours left on Oil Filter and yellow light when getting close; red light when due
3. Hours left on Oil Change and yellow light when getting close; red light when due
4. Hours left on Impeller Change and yellow light when getting close; red light when due
5. Daily Liters Fuel/hour
6. Average Liters Fuel/hour
7. Average daily hours of use
Dual Racor Fuel Filtering System
1. Hours left on Port Fuel Filter and yellow light when getting close; red light when due
2. Hours left on Starboard Fuel Filter and yellow light when getting close; red light when due
Passage Information
1. Miles completed
2. Miles to go
3. Fuel Consumed to date
4. Fuel Predicted to be consumed
5. Fuel Predicted to be on hand at arrival
6. Average Daily Miles Made Good
7. Average Daily Velocity Made Good (Average Speed)
8. Daily Lat/Lon
9. Predicted Arrival Date/Time GMT
10. Predicted Date/Time Local
11. Table reflecting average passage speeds from 4 to 8kts in 0.2kt increments and the expected Date/Time of arrival GMT and the Date/Time of arrival Local. This table is continuously updated and reflects the remaining passage miles and helps me with "what if" situations when we are trying to speed up or slow down to achieve a certain arrival time. As example to arrive before dark we need to maintain X.0kts for the next 24 hours.

The MOAS also has several tables for converting liters to gallons and currency converters to help me with how much I am actually paying for a liter converting to US dollars and US gallons.

I also record oil, fuel & oil filter changes and impeller changes for the main engine and generator when they occur.

There are a number of smaller tables in the MOAS and about the only thing the MOAS does not have is a table to predict best fishing times, although I have some ideas on how to do this.

Oh, one more thing, the MOAS requires a little alcohol to understand its subtle inner workings….Beer-Thirty…Bye for now!