Join Date: Jul 2007
Location: Northport, NY
Thanked 83 Times in 83 Posts
Rep Power: 0
Re: Maintenance, Repair, and To-do logs. How do you do it?
I set up an excel spread sheet for the boat, It has multiple tabs where I record information. I have one with a list of equipment on the boat, one for serial numbers, one for electrical wire size/load calculation, one for stats for the boat, a maintenance log, a tab for each winter storage (includes projects etc.), tab for watch schedules, a tab for project planning, various tabs for spares lists, tab for an insurance claim, tabs for locker contents/inventory, tab for contacts and of course the MAINTENANCE log you asked about.
I add tabs as need be. The most used tabs are on the left side.
I make a copy of the boat spread sheet and put it on a USB drive and bring it to the boat where I have a computer. which has the same spread sheet... I need to sync them so I do it with the USB.
These days I take pics with my phone and keep a file with them. Useful for any project. I can plan projects from home with pics. Never too many pics and so easy to take. When I take measurements or draw a sketch and write them down, I will take a pic of that too and toss out the paper.
Excel is very powerful, searchable and you have a lot of graphic control. You can draw, import text, graphics and pics. Power uses can use it for data analysis. I don't. I use it to record information.
Maintenance log tab has
engine hrs (next oil change eng hr.)
list of belts, filters, oil, zinc
You can add comments to cells as well.... like who was on board or what you ate!
pay attention... someone's life depends on it