Vehicle service planner template
Now, before I take the car in for servicing, I'll print out my log with the recommended schedule so that I can tell whether I really need that "flush and replace every fluid in the entire vehicle" service. Where can I find a recommended maintenance schedule?
If you don't have the original service schedule that came with your vehicle, then you can do what I did and go to Edmund. I added a link to that page within the spreadsheet plus some fields at the top of the worksheet for recording some of the information you'll need like the Make, Model, Year, Engine.
License : Private Use not for distribution or resale. This is why the Car service schedule spreadsheet was created. The first page Odo reading of the spreadsheet allows to record a series of odo readings. Every time a new reading is inserted the spreadsheet automatically calculates the average distance that the car has travelled from the previous reading and also the average value from the first reading.
This data will be used to "predict" the date of next service, but can also be useful to get cheaper quotes when renewing the car insurance. The second page service planning allows the user to list all the services that will be due in the life of the car. For each of these it's possible to insert the target mileage or km. The spreadsheet will automatically calculate when the next service is due.
This is done by assuming that the car will continue travelling the same average distance with time. The more frequently the user does an odo reading, the more accurate the prediction will be. On the same page it's also possible to list all the items that are due on each service by ticking them from the list. For example, in my car the oil must be changed every km, but the brakes oil only every Both the items will be present in the list, but the second one will only be ticked on service 2.
Finally, it's possible to record the service completion date and miles or km. This helps to keep updated records and triggers the cell that will show the next service date. This can be used to set-up a calendar reminder that will notify the approaching calculate mileage. The last page Checklist is designed for the people who want to perform the service or part of it on their own. The user can select the service that is going to be performed.
This automatically pulls the table that lists all the items due in that specific service. When the user presses the "Print checklist" button, the table is automatically filtered to only show the items that are due. A window allows to choose the preferred printer, and this triggers the printing of the checklist. The page is designed to be printer friendly: it's black and white and only the essential information is recorded. New free material is regularly created.
If you are interested in receiving an email when a new spreadsheet is released you can subscribe to EnginExcel newsletter. EnginExcel free spreadsheets are free for personal and commercial use. This file is professionally designed to include columns for details such as date of service, work performed, mileage at service, and costs. You can open this template on other devices that let you edit with the available file format.
You can also see the Cleaning Schedule Template. Keep your business running smoothly by having your equipment at optimum condition. Make use of our Maintenance schedule template in keeping a tab on the inspection, cleaning, and repair of any of your equipment.
0コメント