We’ve been using a couple of spreadsheet templates on m/v Positive Latitude for a while now to capture important information we want to track about our cruises (Captain’s Log) and all the maintenance we perform on the boat (Maintenance Log). There are a lot of good applications that accomplish the same thing but we want to customize and we don’t want to start over when an application we like is no longer supported. If you are interested in receiving the templates for free, fill out the form below and we’ll send you a link. An understanding of spreadsheets is useful or at least the desire to jump in and figure it out. Feel free to modify for your own use. If you don't use Excel, the templates seem to work fine in Google Sheets and Libre Calc.
Below is an introduction video for the Maintenance Log Template.
The workbook contains worksheets for:
Deck Log - includes calculations for entry Daily Time
Underway
as
well as a summary of Total Hours Underway, Total Days Underway, and Total Miles
Marina and
Anchorage
Log
- includes calculations for each entry for Total Cost, and a summary breakdown by # of Stays, # of Days,
and Total Cost by type (Marina, Mooring, Anchorage, Yacht Club, and Free Dock)
Fuel Log -
includes
calculations for entry Price per Gallon, Hours Since Last Fill, and Gallons Per Hour as well as overall
Average Gallons per Hour.
Pumpout Log - includes calculations on each entry for Days Since
Last
Pumpout
as well as Total Cost.
The grey boxes on the worksheets are calculated fields so you shouldn't enter any info in them directly - those get updated automatically as you enter new information. We start a new log file each year and store our log files in the cloud (One Drive is what we use, but there are many options). We can update using a laptop, a tablet, or even our phones, and the files get synced across our devices. However, you can just keep the file locally on your computer if you'd prefer.