Documenting Repairs/Maint using Excel
#1
Repairs/Maint documenting them using Excel
I have been documenting the repairs and maintenance on all of our vehicles for the last 15 years.
It is helpful to be able to open the excel spreadsheet and use the edit/find to locate the last time a particular type of job was done on the vehicle.
Its details the date, the mileage when it was done, the description of the item (Parts, Labor, misc), the prices paid for the components of the job and the total price of the job.
In the title section, the date the vehicle was purchased, the date when it was new and put in service, and then the grand total dollars spent since we purchased the vehicle.
Here is a pdf file of Excel spreadsheet:
2001 Jaguar XJ8 sp.pdf
Hope this helps you maintain your Jaguar.
It is helpful to be able to open the excel spreadsheet and use the edit/find to locate the last time a particular type of job was done on the vehicle.
Its details the date, the mileage when it was done, the description of the item (Parts, Labor, misc), the prices paid for the components of the job and the total price of the job.
In the title section, the date the vehicle was purchased, the date when it was new and put in service, and then the grand total dollars spent since we purchased the vehicle.
Here is a pdf file of Excel spreadsheet:
2001 Jaguar XJ8 sp.pdf
Hope this helps you maintain your Jaguar.
Last edited by jimlombardi; 02-28-2011 at 02:38 PM. Reason: updated PDF file
#2
That's great documentation.
Personally, I am not that disciplined to keep records like that. I'm lucky if I have the big stuff in the glove box. Everything else is categorized in quicken as auto maintenance so I can get the total, but not a description of the activity. The vendor may shed a light on what happened, but the little stuff like your entry for fuses may just slip through the cracks.
Personally, I am not that disciplined to keep records like that. I'm lucky if I have the big stuff in the glove box. Everything else is categorized in quicken as auto maintenance so I can get the total, but not a description of the activity. The vendor may shed a light on what happened, but the little stuff like your entry for fuses may just slip through the cracks.
#3
The description helps a lot. Many times I do a review on what it costs us the last time for a particular part and the labor to complete the repair. Labor rates change but you still can get a good idea of the hours it took to do the job. Also the entry for the fuses reminds me that I might still have of the assortment of fuses around somewhere here in the house.
Last edited by jimlombardi; 10-12-2010 at 02:19 PM.
Thread
Thread Starter
Forum
Replies
Last Post
FS[SouthWest]: 19" Aquila Wheels with Tires
jorgef858
PRIVATE For Sale / Trade or Buy Classifieds
4
01-14-2016 11:32 AM
davidboger
XJ6 & XJ12 Series I, II & III
2
10-01-2015 10:13 AM
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)