So if you’re not aware, I like spreadsheets. They’re great. It’s an excellent way to sort numerous types and quantities of data for easily viewing, searching, and referencing at a later time.
I’ve had more than a few jobs that require excellent documentation on a number of machines (3d printing farm) and picked up a few skills here and there on keeping maintenance logs. Hopefully someone will find this beneficial, if not helpful or indicative of a looney.
- A -C are self-labeled.
- D is the Action column- What was done to the component in Col C.
- E-F are for logging expenses of parts and labor. 0 value labor was completed by myself.
- G is asking if this action was required. Values are Yes, PM (preventative maintenance), Acc (Accessory- optional and not needed.)
- H is the notes column. If the part was merely inspected or repaired, details are recorded. If parts were replaced, part numbers are also noted. This makes it easier to recall exactly what I did to a certain part and to trace a future failure back to my actions if the repair may have been done incorrectly.
There are a lot of parts to keep tabs on. Some I’ve ordered and have lying around somewhere, some need to be ordered, and some come from numerous other sources. This is documented in the second tab of the spreadsheet here:
- A-B are self-labeled.
- C is the part status. N-no action. O-on order. D-done. H- on hand.
- D is the quantity on hand. If this value is less than the Quantity required (Col B) the cell is highlighted yellow.
- E is priority. Acc- accessory (optional, not needed) High Med and Low priority, Ref- line retained for reference.
- G-K are self-labeled documenting the part source, part number, estimated price, a link regarding some sort of detail (usually how to install) and any special notes regarding this line item. I.E. Change this with gasket P/N XX or similar.
This documentation is a bit time consuming, but its awesome for keeping track of stuff that I can’t remember. Snapping a picture of the odometer is an instand mileage and date record. I can usually remember what happened until I make it to a PC to update the log. Last oil change? Tire rotation? When’s it due for a trans drain and fill? CTRL+F and search! It’s been a godsend and has saved me more than once.
So, what says yous guys’s? How do you, or do you document your maintenance at all? How do you keep on top of the ever-growing list of to-do’s for your baby/dd/jalopy project?