FWIW .... Here's some screen shots of the Spreadsheet I did to track our maintenance at work. It is the same format and design as the one I developed to track our POV's, collector vehicles and farm equipment here at HQ. It's Excell and consists of a master sheet connected to individual folders/sheets for each vehicle. The work one is grouped by type of vehicle -- trucks, equipment (tracked and wheeled), trailers (king pin, pintle and ball hitch) and misc (pumps, plate tampers, walk-behind sweeper, etc).

The spreadsheet is out of date as I turned the record keeping over to our lead mechanic to manage over a year ago. Presumably he's been keeping it up ... wink

Primary input is done from a notebook kept in the shop. End of each week, we input the data from the notebook.

It helps to keep track of oil changes, lube and adjustments, registrations, battery ages and tire wear. All good things to keep an eye on when scheduling equipment for job sites. Mark may have something better from his shop.
Attachments
screenshot-1.jpg (251.58 KB, 47 downloads)
This shows the main work book (captures the significant details from each of the subsequent work sheets
screenshot-2.jpg (195.23 KB, 47 downloads)
One of the individual vehicle work sheets that exports cells to the main sheet.


~ John

A kid raised on Hotwheels, Matchbox and Tonka cannot be reasonably expected to own only one vehicle as an adult.

1949 Chevrolet 3804
In the Legacy Gallery | In the Gallery Forum
1973 IH 1310 Dump
1963 Kaiser M38A1
2001 International/AmTran RE3000 "Skoolie"
2014 Ford E-350 4x4 (Quigley)