Excel Spreadsheet for tracking maintenance?
Thread Starter
|
Senior User
Joined: May 2004
Posts: 400
Likes: 0
Excel Spreadsheet for tracking maintenance?
Hi all;
I'm one of those guys that's always tracked his maintenance in a notebook, but I'm thinking about replacing the notebook with a computer.
Does anybody use an excel spreadsheet they particularly like for tracking their maintenance? Or maybe some other sort of more specialized software?
I'm looking for the basics - date, mileage, item description, etc.
Pluses would be vendor information, ability to record bulk purchases of filters, oil analysis results, etc.
All suggestions welcome...
I'm one of those guys that's always tracked his maintenance in a notebook, but I'm thinking about replacing the notebook with a computer.
Does anybody use an excel spreadsheet they particularly like for tracking their maintenance? Or maybe some other sort of more specialized software?
I'm looking for the basics - date, mileage, item description, etc.
Pluses would be vendor information, ability to record bulk purchases of filters, oil analysis results, etc.
All suggestions welcome...
Senior User
Joined: Dec 2004
Posts: 181
Likes: 0
Hotshot
Joined: Nov 2006
Posts: 11,288
Likes: 269
From: North of Greenville
I have a spreadsheet that I use mainly to track mileage, but I also make notes about all my mods and maintenance activities. I have a few SUMIFF equations added in so I can track the mileage by either CITY, HWY, MIX, or OVERALL categories. Below is a pdf link for how it looks right now. I've only had the truck for a little over a year, and haven't caught the file up in about a month, but you can get the idea pretty easily from the pdf.
Post Fiend
Joined: Dec 2002
Posts: 6,245
Likes: 1
From: IL, USA
I have an excel spreadsheet for all my trucks and trailers. Track oil changes, tranmission services, front brakes, rear brakes, alignment, fuel filter change, etc....
I'm thinking of creating another to keep inventory of all the filters that I have on hand (along with all the parts I keep in stock for all our equipment).
I'm thinking of creating another to keep inventory of all the filters that I have on hand (along with all the parts I keep in stock for all our equipment).
Postmaster
Joined: Apr 2006
Posts: 3,294
Likes: 1
From: Neptune Beach, FL
I'm still working on the program.. Hoping to get it done by the end of the year.. Plan to write it to manage everything.. Right now I use spreadsheets by the gazoo's.. Be nicer if I can get it into software.. Writing it with VB.. Knew those programming courses would pay off LMAO
Thread
Thread Starter
Forum
Replies
Last Post
BlueOvalRage
1948 - 1956 F1, F100 & Larger F-Series Trucks
16
Mar 14, 2016 09:13 AM
Gary Lewis
1980 - 1986 Bullnose F100, F150 & Larger F-Series Trucks
67
Nov 25, 2015 06:49 PM
