I have found the best way to keep track of this is using a single
spreadsheet with multiple worksheets on my computer. I use the one
included in the  free Libreoffice suite.

For maintenance I have worksheets for periodic tasks, todos/repairs, and
a maint log. They basically have the same column structure for things
like location, item and details. When I complete a task from the
periodic or todo list, I move/copy the line to the maint log worksheet
and add a date and some comments on what I did if it was not a standard
task or who I hired to take care of it.

I also added worksheets to keep a checklist of other boat related
activities and misc information:

• cruise pre-departure tasks

• storm preparation tasks

• leaving the boat for an extended period checklist

• Things I need to buy for the boat or for an upcoming project

• spares list and location

• Summary page of essential boat details: CG doc, hull id, key
  dimensions, engine model,...

• Notes on part numbers, dimensions, logons, .....

-  Cruising notes for the day which includes items like:  key nav
markers, landmarks, shoal warnings, bridge schedules and any other
things to be aware of for that days cruising.

• cruising log which documents the days events.

Some of these can change daily and others have not changed in the 11
years I have owned my boat.

I like that I can control the level of detail and that it is easy to add
items as you find them in articles and other peoples checklists. It is
all in one spreadsheet, so it is fairly easy to work with and I only
need to keep track of just one file (+ backups).

JonasB

Andiamo!

On 5/16/2019 11:00 AM, trawlers-request@lists.trawlering.com wrote:

Gee Jonas, when do you have time to cruise?
Just kidding!

RUDY & JILL SECHEZ
*BRINEY BUG-a 34' Sail-Assisted Trawler *
*850-832-7748 *

Palm Beach FL
TRAWLER TRAINING and ANCHORING CONSULTANTS
ANCHORING-"A Ground Tackler's Apprentice"- E-Book or Hard Copy

Ahh, just kidding folks, we, too, are religious about engine maintenance.
It's just, before Rich says it, there's nothing else on our boat to
maintain. Well, okay, other than Jill.

RUDY & JILL SECHEZ
*BRINEY BUG-a 34' Sail-Assisted Trawler *
*850-832-7748 *

Palm Beach FL
TRAWLER TRAINING and ANCHORING CONSULTANTS
ANCHORING-"A Ground Tackler's Apprentice"- E-Book or Hard Copy

I like the idea of multiple worksheets for checklists and inventory -- I need to add that to my list.  Mine is a single tab in an Excel workbook, evolved from one that came from someone else on this site.

It's divided into sections (engine, gen, safety, etc.).

At the top I input the current date, the hours on the engine and generator and the date of that reading.

Each row has an entry for columns for:  Item (ex. alternator belt), Action ( what needs to be done), Group (location), Interval (#hours and/or #days), LastPerformed (date, hours), NextTime (hours) and/or NextDate (mo/yr), and Notes.  The next service time or date is calculated from the last Interval and the last action, current hours or current date.  The formulas are pretty simple and use the IF function.

I added conditional formatting on the NextTime, NextCal columns show future maintenance times (hours, calendar date): green for not past due, and past due red font highlighted yellow .

An example of a row...
Item: alternator belt
Action: adjust tension
Group: engine
Interval: (every) 500 hours, 2 years
LastPerformed: 1/22/18, 1263 hrs
NextTime: 1763 hours
NextDate: Jan/2020
Notes: spare belt under stairs

I print a copy to take to the boat when I do maintenance.  Looking at it now, I see a lot of red, particularly in the non-engine items!

I'd share with anyone who wants a copy and sends me an e-mail.

Jamie Millar
Mainia, 2002 Mainship 390
Redondo Beach

-----Original Message-----
From: Jonas Butvila jonasb-n@earthlink.net
Sent: Friday, May 17, 2019 10:34 AM
To: trawlers@lists.trawlering.com; rpackard43@gmail.com
Subject: T&T: maintenance list

I have found the best way to keep track of this is using a single spreadsheet with multiple worksheets on my computer. I use the one included in the  free Libreoffice suite.

For maintenance I have worksheets for periodic tasks, todos/repairs, and a maint log. They basically have the same column structure for things like location, item and details. When I complete a task from the periodic or todo list, I move/copy the line to the maint log worksheet and add a date and some comments on what I did if it was not a standard task or who I hired to take care of it.

I also added worksheets to keep a checklist of other boat related activities and misc information:

• cruise pre-departure tasks

• storm preparation tasks

• leaving the boat for an extended period checklist

• Things I need to buy for the boat or for an upcoming project

• spares list and location

• Summary page of essential boat details: CG doc, hull id, key dimensions, engine model,...

• Notes on part numbers, dimensions, logons, .....

• Cruising notes for the day which includes items like:  key nav markers, landmarks, shoal warnings, bridge schedules and any other things to be aware of for that days cruising.

• cruising log which documents the days events.

Some of these can change daily and others have not changed in the 11 years I have owned my boat.

I like that I can control the level of detail and that it is easy to add items as you find them in articles and other peoples checklists. It is all in one spreadsheet, so it is fairly easy to work with and I only need to keep track of just one file (+ backups).

JonasB

Andiamo!

On 5/16/2019 11:00 AM, trawlers-request@lists.trawlering.com wrote: