Those baseline dates are the top two service entries and are just the in-service dates to start the clock. Since I haven't yet reached the first interval for Drive Belt, PDK or AWD/Diff services (6 and 12 years) I made a baseline date so the formulas didn't return an error.That plus I don't know how to do an either/or in excel yet! Since I don't DD my car I have only created due dates based of of years of service, not mileage.If it's due or overdue conditional formatting makes the date red If a service is due within 30 days, conditional formatting makes it yellow.Then adds the correct service interval in the "Due" section. It puts that date in the accomplished section. To figure out when the last service was accomplished it looks in the appropriate column, down until the latest "YES" value, then back to the left to find the date of service. I'm not a huge excel expert so the formulas I used was a simple LOOKUP. The spreadsheet has to be filled out in ascending chronological order (earliest on top).Feel free to add or delete, you can probably figure out what values need to change based on Cell IDs Similar calculations happen for all the other services, all based on the service interval I created on the second tab. If you type "Clutch Oil" it auto fills in the latest date that service was performed in the "PDK Clutch Oil" date serviced in the top section, then auto calculates a Date Due based on the service interval on the second tab, in this case 6 years. Example: In the PDK section, you can type "Clutch Oil", "Trans Oil", or "N".Only use the options available in the drop down to ensure the upper section gets filled in and calculated correctly. The "oil/filter" thru "AWD Diff" columns are drop-down data using data validation in order to calculate correctly. I'll get to the summary of service dates and dates due after discussing the detailed list of servicing.The fields under the picture of my car are self-explanatory. Manually type in your mileage whenever you feel like updating it. The "spent" cell auto calculates from the costs in the detailed listing below. Type in your in-service date manually.Unless you disagree with or have your own preference for service intervals there shouldn't be a need to modify tabs 2 or 3 The third tab is just a data tab to use for drop-down options on the first tab. That tab also includes a mini-spreadsheet summarizing the dates and mileage intervals to use in calculations on the first tab. The second tab is a cut/paste of the 997.2 maintenance schedule I found online (forget the source). The last two are used to set the baseline for service due reminders. The first is a summary of service accomplished and due plus some quick-look details on the car (warranty date, VIN, sirius ID, in service date, up to date mileage). If anyone sees anything they'd improve on feel free to post your version back up:ġ. As with any spreadsheet it's in a constant state of modification and improvement. It does a few things automatically, here's the quick rundown. It was hard but I brought myself into the current generation! And yes, I still print out hard copies for posterity.Īnyway, I attached a sanitized version if anyone is interested. I'm a professional pilot and made the transition from paper logbooks to electronic a few year back. I tried AUTOsist for a little while but the report process is cumbersome - I was hoping to keep everything in an electronic logbook but still print a good hard copy report to keep in my binder. I wasn't a big fan of any of the online tools or apps that track vehicle maintenance so made a little spreadsheet of my own.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |