Oil Record

Status
Not open for further replies.
I modify Excel spreadsheets for each of my cars and my mother's car. For each car I have a sheet for lubrication services and another for other maintenance and repairs. I also save all receipts for backup.
 
I use AutoTracker from Pennzoil. Don't think it is available anymore. I also put some stuff in Excel. I also keep a 3 hole binder in the garage with accounting type columns paper. Date on left, mileage, Oil Change column, air filter, spark plugs,
fuel filter, each get their own column, makes it easy to see when an item is due. Last column is tires, misc, etc. As automakers stretch out the intervals many columns don't get used much, but it is easy to check.
 
I always keep a written record of all my maintenance and repairs in a notebook. As well, I keep a copy of all my receipts for parts and service.
 
I log all of my gas mileage and service in a excel spreadsheet. I love messing around with all of the graphing functions.
 
I'm kinda like dgreen. Maintain all maintenence records (including P/Ns) for all my vehicles, lawn mower, snowblower, generator, in an excel database.
Use formulas & pivot tables to display miles between oil changes, and a running avg. of miles between changes, gas milage, etc. for the rides.
 
In addition to keeping original sales receipt of maintenance in a special file folder, I also enter the maintenance data in a special table created in MS Word format.
 
I have kept a little notebook in the glovebox of every car or truck I have owned since 1969. It contains all gasoline purchases as well as oil usage, oil changes, tire rotations, etc.
 
I use an old freeware program. C.A.R. (Chris's Automobile Recorder) It works great once you set it up. Keeps track of everything. Calculates MPG, operating costs, maintenance reminders, etc.
It is a DOS program, but otherwise works great.
If anyone is interested, I would be happy to email a .zip file.
 
I maintain all fuel records for all 15 vehicles in Excel, with a running average of kilometers per liter and kilometers per m3 on natural gas. We add tire purchases for easy reference.
Since I own 3 oil change facilities, I can see what oils have been changed when on every customer as well as my own.
The rest of the maintenance, unfortunately only gets a copy of the work detail in a binder, so it takes a page by page review to see the work done.
 
I started tracking oil changes by writing the date, miles and type of oil on the top of the filter box. Then I started adding a note about any service I performed. I stick the notes between the windshield washer tank and the inner fender. When the notes got too thick to fit, I wrapped a rubber band around it and tossed it in the glove box. My father has been logging every gas fill up since '57
 
Quote:
I keep a little logbook in the glove box, and a computer spreadsheet that gets backed up along with pictures of my kid, quicken records etc.
Add me to the list.. a small spiral notebook in the glovebox. All maintenance recorded. Receipts in an envelope, chronological. The maintenance records did get me an extra 500.00 on a trade in when I got my Focus. And backed up pictures of my best friends son, laying under the van with me, changing trans fluid.
smile.gif
 
For the truck I keep a log of all fueling, lube changes, etc., in a medium size log book. Looking over it yesterday I noticed that mileage can drop a drop 1 mpg worst case in town with the slightly larger winter tires, even allowing for speedo differences, from 17-18 mpg to 16-18 mpg. Highway mileage is still 19-20 mpg, so I guess spirited acceleration with the slightly higher gearing uses more fuel.
 
I used to use a foot-long piece of duct tape that I taped to the wall for my 2002 Grand Am that I would write date and mileage of all of the work I did, but with my newly aquired 95 Prizm, I am entering the information into a spreadsheet with the first column being mileage, second being the service, and all the details on the third column, all of my UOA results and important sales/service receipts are in there. Since I am planning to do all but the most difficult work on my own with this car, I am make sure to keep all the receipts for anything that isn't oil(since I've got my UOA results).
 
I said it in another thread, but Honda's Owner Link now has a feature where you can enter your "Do it yourself" work into a database...and I assume that dealer work gets logged in there automatically. Pretty cool.
 
Matt89: Subaru has that feature as well on their "My Subaru" site. I can enter a record for service performed by me, and service performed by the dealer shows up in the database as well.
 
I just keep all the receipts I ever get related to a car in a file folder in my desk drawer. Whenever I get rid of the car, the folder goes with it in the front seat.
 
Status
Not open for further replies.
Back
Top Bottom