I made a BMW Maintenance Tracker Template on Google Sheets

flanmorrison · 01-09-2023, 11:38 PM

Hi all,
I couldn't find a good solution to tracking maintenance history and intervals, so I made one! This Google doc allows you to log your service history, set standard maintenance intervals, and decode your vin.

Maybe this will be useful to someone else also, so I figured I'd share it here.

Here is the link, don't forget to read the instructions to save your own copy!

Tejas1836 · 01-10-2023, 12:30 AM

Buy OP a gallon of fuel or electrical equivalent, whichever is higher.
Impresssive

Jbrown7403 · 01-10-2023, 12:42 AM

REALLY Cool! Double thumbs up!

slilley · 01-10-2023, 06:51 AM

Very cool, but where did the service intervals come from? I typically go by Mike Miller's recommendations when it comes to service.

flanmorrison · 01-10-2023, 11:32 AM

Quote:

Originally Posted by Onesie

Not all heroes wear capes. Pretty neat. Thanks for sharing. Front page-worthy stuff

I appreciate it! Glad it's helpful

lillyrockwell · 01-11-2023, 05:30 PM

Hello, I also live in Austin and take my vehicle to Terry Sayther. I am trying to use your tracker and have some questions about it.

Like, for instance, I tried putting in my brake pad repairs into the log but I did the front and rear brake pads separately, one in September and one in January. And I don't understand how to separate them out.

Help me, O Excel Wizard. I feel I have much to learn from you - I also want to create a house version of this and would pay you to help me.

flanmorrison · 01-12-2023, 01:35 PM

Quote:

Originally Posted by lillyrockwell

Hello, I also live in Austin and take my vehicle to Terry Sayther. I am trying to use your tracker and have some questions about it.

Like, for instance, I tried putting in my brake pad repairs into the log but I did the front and rear brake pads separately, one in September and one in January. And I don't understand how to separate them out.

Help me, O Excel Wizard. I feel I have much to learn from you - I also want to create a house version of this and would pay you to help me.

You should be able to add another maintenance item in the yellow highlighted section on "Intervals" tab (IE Rear Brake Pads) and change the "Brake Pads" item to "Front Brake Pads". Then copy and paste the formatting to get colors on the "Summary" Tab

flanmorrison · 01-12-2023, 01:36 PM

Quote:

Originally Posted by slilley

Very cool, but where did the service intervals come from? I typically go by Mike Miller's recommendations when it comes to service.

These are a combination of recommendations I have seen and practiced across a few different cars. They are pretty aggressive, so feel free to adjust as you see fit.

Almuliman · 01-12-2023, 01:52 PM

Nicely done!

I added a new type (Suspension) on the Intervals sheet, and while the Summary sheet did pick it up, it has a problem with it not having any regular intervals. Quick fix or something I should dive into myself? I'm not un-skilled with coding spreadsheets, but ... let's just say it's been a while

flanmorrison · 01-12-2023, 03:13 PM

Quote:

Originally Posted by Almuliman

Nicely done!

I added a new type (Suspension) on the Intervals sheet, and while the Summary sheet did pick it up, it has a problem with it not having any regular intervals. Quick fix or something I should dive into myself? I'm not un-skilled with coding spreadsheets, but ... let's just say it's been a while

Yeah, that's one limitation of the spreadsheet -- you need to put a milage/time interval or it'll show errors. You can throw on an =iferror([existingformula],"") and it'll prevent the errors from being displayed if that helps, or you can hide those rows, or you can put in 100k/99y for the intervals, whatever works best for you. I'll probably build this out more and make it a bit more intuitive, but everything on excel is just a little bit harder

Almuliman · 01-12-2023, 03:38 PM

I can work with that

And coding spreadsheets isn't just "a bit" harder. It's a god awful PITA (IMO, of course).

OriginalFake · 01-13-2023, 08:40 AM

My VIN doesn't fully resolve all the information but this is pretty cool.

F30StormTrooper · 01-09-2024, 11:07 PM

Thank you for doing this and sharing. This is going to be a huge tool for me moving forward!

01-09-2023, 11:38 PM	#1
flanmorrison M-Poser 71 Rep 56 Posts Drives: '15 M235i RWD Join Date: Sep 2022 Location: Austin, TX iTrader: (1)	I made a BMW Maintenance Tracker Template on Google Sheets Hi all, I couldn't find a good solution to tracking maintenance history and intervals, so I made one! This Google doc allows you to log your service history, set standard maintenance intervals, and decode your vin. Maybe this will be useful to someone else also, so I figured I'd share it here. Here is the link, don't forget to read the instructions to save your own copy! Attached Images
	Appreciate 22 deleted_397282_c43ae5ea84160.50 LogicalApex2204.50 Tejas18361074.00 Jbrown74032903.50 StradaRedlands6562.00 Alonso085253.00 M4ord965.00 wtwo319187.00 grannyknot1010.00 ///MPhatic15405.50 cooolone2691.00 Jhanksm3336.50 Wolf 3352571.50 Almuliman560.50 Rafichicago859.00 n55f151338.50 rmedina146.00 MadBullogna383.50 thrilla164.00 STATIC A$TRO50.50 WRCThree8.00 TanzaniteM340i1.50 Tweet Quote

01-10-2023, 12:30 AM	#2
Tejas1836 Captain 1074 Rep 913 Posts Drives: 2023 X5MC Workmaster 75 Join Date: Oct 2022 Location: Tejas iTrader: (0)	Buy OP a gallon of fuel or electrical equivalent, whichever is higher. Impresssive
	Appreciate 1 StradaRedlands6562.00 Quote

01-10-2023, 12:42 AM	#3
Jbrown7403 Captain 2904 Rep 690 Posts Drives: 2016 BMW M4 Join Date: Aug 2019 Location: Austin Texas iTrader: (0)	REALLY Cool! Double thumbs up!
	Appreciate 0 Quote

01-10-2023, 06:51 AM	#4
slilley Private First Class 93 Rep 104 Posts Drives: 2023 X5, plus others Join Date: Jan 2023 Location: Reading PA iTrader: (0)	Very cool, but where did the service intervals come from? I typically go by Mike Miller's recommendations when it comes to service.
	Appreciate 0 Quote

01-11-2023, 05:30 PM	#6
lillyrockwell Registered 0 Rep 1 Posts Drives: BMW X3 xDrive28i Join Date: Jan 2023 Location: Austin, TX iTrader: (0)	I'd like to understand your tracker better! I love it! Hello, I also live in Austin and take my vehicle to Terry Sayther. I am trying to use your tracker and have some questions about it. Like, for instance, I tried putting in my brake pad repairs into the log but I did the front and rear brake pads separately, one in September and one in January. And I don't understand how to separate them out. Help me, O Excel Wizard. I feel I have much to learn from you - I also want to create a house version of this and would pay you to help me.
	Appreciate 0 Quote

01-12-2023, 01:52 PM	#9
Almuliman Lieutenant 561 Rep 599 Posts Drives: 2013 LMB 6MT 128i, 2000 M5 Join Date: Jun 2020 Location: Outside Seattle iTrader: (0)	Nicely done! I added a new type (Suspension) on the Intervals sheet, and while the Summary sheet did pick it up, it has a problem with it not having any regular intervals. Quick fix or something I should dive into myself? I'm not un-skilled with coding spreadsheets, but ... let's just say it's been a while Attached Images
	Appreciate 0 Quote

01-12-2023, 03:38 PM	#11
Almuliman Lieutenant 561 Rep 599 Posts Drives: 2013 LMB 6MT 128i, 2000 M5 Join Date: Jun 2020 Location: Outside Seattle iTrader: (0)	I can work with that And coding spreadsheets isn't just "a bit" harder. It's a god awful PITA (IMO, of course).
	Appreciate 0 Quote

01-13-2023, 08:40 AM	#12
OriginalFake Captain 577 Rep 614 Posts Drives: 2023 M240i Join Date: Jul 2010 Location: NC iTrader: (0)	My VIN doesn't fully resolve all the information but this is pretty cool.
	Appreciate 0 Quote

01-09-2024, 11:07 PM	#13
F30StormTrooper Registered 0 Rep 4 Posts Drives: F30 Join Date: Dec 2023 Location: Texas iTrader: (0)	Thank you for doing this and sharing. This is going to be a huge tool for me moving forward!
	Appreciate 0 Quote