My 997.2 maintenance spreadsheet
#1
Rennlist Member
Thread Starter
Join Date: Feb 2018
Location: NoVA
Posts: 33
Likes: 0
Received 0 Likes
on
0 Posts
My 997.2 maintenance spreadsheet
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. 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'm a professional pilot and made the transition from paper logbooks to electronic a few year back. It was hard but I brought myself into the current generation! And yes, I still print out hard copies for posterity.
Anyway, I attached a sanitized version if anyone is interested. It does a few things automatically, here's the quick rundown. As with any spreadsheet it's in a constant state of modification and improvement. If anyone sees anything they'd improve on feel free to post your version back up:
1. Three tabs. 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). The last two are used to set the baseline for service due reminders. The second tab is a cut/paste of the 997.2 maintenance schedule I found online (forget the source). That tab also includes a mini-spreadsheet summarizing the dates and mileage intervals to use in calculations on the first tab. The third tab is just a data tab to use for drop-down options on the first tab. Unless you disagree with or have your own preference for service intervals there shouldn't be a need to modify tabs 2 or 3
2. Main tab instructions:
Jim
Anyway, I attached a sanitized version if anyone is interested. It does a few things automatically, here's the quick rundown. As with any spreadsheet it's in a constant state of modification and improvement. If anyone sees anything they'd improve on feel free to post your version back up:
1. Three tabs. 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). The last two are used to set the baseline for service due reminders. The second tab is a cut/paste of the 997.2 maintenance schedule I found online (forget the source). That tab also includes a mini-spreadsheet summarizing the dates and mileage intervals to use in calculations on the first tab. The third tab is just a data tab to use for drop-down options on the first tab. Unless you disagree with or have your own preference for service intervals there shouldn't be a need to modify tabs 2 or 3
2. Main tab instructions:
- Type in your in-service date manually. The "spent" cell auto calculates from the costs in the detailed listing below. The current date auto populates. Manually type in your mileage whenever you feel like updating it. The fields under the picture of my car are self-explanatory.
- I'll get to the summary of service dates and dates due after discussing the detailed list of servicing
- Detailed servicing section:
- Most columns are self explanatory. The "total cost" column auto calculates. The "oil/filter" thru "AWD Diff" columns are drop-down data using data validation in order to calculate correctly. Only use the options available in the drop down to ensure the upper section gets filled in and calculated correctly.
- Example: In the PDK section, you can type "Clutch Oil", "Trans Oil", or "N". If you type "N" nothing happens. 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. Similar calculations happen for all the other services, all based on the service interval I created on the second tab. Feel free to add or delete, you can probably figure out what values need to change based on Cell IDs
- The spreadsheet has to be filled out in ascending chronological order (earliest on top). I'm not a huge excel expert so the formulas I used was a simple LOOKUP. 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. It puts that date in the accomplished section. Then adds the correct service interval in the "Due" section.
- If a service is due within 30 days, conditional formatting makes it yellow. If it's due or overdue conditional formatting makes the date red
- Since I don't DD my car I have only created due dates based of of years of service, not mileage. That plus I don't know how to do an either/or in excel yet!
- 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. Those baseline dates are the top two service entries and are just the in-service dates to start the clock. If I bought the car new I'd have done the same for all the other services.
- There are some lingering comments and tool tips from the template I started working with. Ignore them, I couldn't figure out how to delete them.
- If I'm using the wrong servicing schedule please let me know!
- Yes I know I'm due for the 6 year PDK, Drive Belt, and AWD Controller service. I'm trying to line a few things up to get everything done at once. Plus I know it will be expensive!
Jim
#3
#4
Rennlist Member
Thread Starter
Join Date: Feb 2018
Location: NoVA
Posts: 33
Likes: 0
Received 0 Likes
on
0 Posts
Thank you, that's good to know - and a relief as well, though I'm definitely prepared for hefty maintenance costs!
Last edited by jimf15e; 06-13-2018 at 10:46 PM.
#5
Rennlist Member
Thread Starter
Join Date: Feb 2018
Location: NoVA
Posts: 33
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by josserman
Wow you’re the man! Huge thanks for sharing this. Will download later on PC, but from your description it sounds awesome!
#6
Rennlist Member
Thanks so much. This is awesome.