- Thread starter
- #21
Sure thing. It's a Google Sheet primarily because its easy to edit on a PC, phone, tablet, etc and its always saving updates. It auto-color codes some cells based on input so its easier to keep tabs on things at a glance. I also have a tab for trail spare inventory and a number of other more specific tasks/parts lists.
It's detailed here:
http://oppositelock.kinja.com/spreadsheets-maintenance-and-parts-1794504389 and I'll copy the important bits to future-proof it.
The first tab is the maintenance log. Columns are as follows:
- 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.
- 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.
Maintenance Log and Parts
