Automated pricing spreadsheet to calculate total cost of 2015 M3 and M4

MRV99 · 02-20-2014, 07:23 PM

posted below

hyperboost · 02-20-2014, 07:41 PM

really useful but it's painful to look at the sum, lol. $87K

BKMK5 · 02-20-2014, 09:09 PM

Not sure if this is accurate but seemed to be.
https://drive.google.com/file/d/0B1i...it?usp=sharing

magas · 02-20-2014, 10:44 PM

I uploaded a new file that is more complex and lists the codes to keep the ordering straight.

https://drive.google.com/file/d/0B2t...it?usp=sharing

I am calling it version 1.0

It needs work due to the many ordering configurations which are dependent on each-other and is definitely not perfect.

If anyone has more Excel experience you are welcome to improve it.

I will post the most updated file on the first page of this post.
Cant wait for the BMWUSA configurator to go up, I like many other got tired of waiting.

Glad to see so many people actually used it.

MRV99 · 02-20-2014, 11:07 PM

I have took Megas sheet and made it more automated.

On the First tab(Build Sheet) any cell which is Green has a drop down list associated with it. By clicking on that green field, one can choose the option for that field. The items which you choose are Model(M3/M4), Option(Yes/No), Delivery Option(US/ED/Diplomat). If you select and option which requires or depends on another option(ZEC comes to mind) the calculator will automatically add that option to the price. Same goes for your leather options, if you choose extended and then select full, extended will be removed. If you add the full leather with the ZEC option, the price will be modified.

You may find that when you select an option (Like Driver Assistance Package) which requires a dependent option(ZEC), it will add that options price to the build sheet but will not toggle that options yes/no indicator. It was designed to allow you to remove that package and automatically remove the package which it depended on. That way it reduces the amount of yes/no changing when selecting options.

On the Second tab(Finanical Calculator) I also have added simple Calculators for both financing and leasing. Once again, on this tab, the orange cells are manual entries and the green cells will have a drop down list. I carry over values from the first tab for these calculations.

Enjoy

Spreadsheet: Updated 2/21/2014 5:00pm (fixed bug which did not reduce Rear shade from $500 to $350 if full leather option selected)

https://drive.google.com/file/d/0B-r...it?usp=sharing

///Mobbin · 02-21-2014, 09:50 AM

Thanks to you both, very useful!

One thought might be to add in individual color or interior options. I am on the fence about ditching surround-view and the led headlights for an individual color, though that only gets me part way there!

jafza412 · 02-21-2014, 07:30 PM

I took a stab too and got it all into one page.

http://f80.bimmerpost.com/forums/sho...d.php?t=949482

MRV99 · 03-03-2014, 10:26 AM

Spread sheet update.
-Bug fix for the financial calculator: Hard coded the term instead of referencing the drop down. thanks bhap!
-Added the new leasing rates to the sheet. (yes they only reflect 36month residuals)

https://drive.google.com/file/d/0B-r...it?usp=sharing

dmk08 · 03-03-2014, 10:57 AM

Quote:

Originally Posted by MRV99

Spread sheet update.
-Bug fix for the financial calculator: Hard coded the term instead of referencing the drop down. thanks bhap!
-Added the new leasing rates to the sheet. (yes they only reflect 36month residuals)

https://drive.google.com/file/d/0B-r...it?usp=sharing

Nice works great. Definitely think I'll rock a 36/12 on this first F8x with plans to trade in after 2 years for LCI on a purchase. I would probably be okay with 10 but want to be safe.

gswcowboy · 04-25-2017, 12:05 PM

Quote:

Originally Posted by MRV99

Spread sheet update.
-Bug fix for the financial calculator: Hard coded the term instead of referencing the drop down. thanks bhap!
-Added the new leasing rates to the sheet. (yes they only reflect 36month residuals)

https://drive.google.com/file/d/0B-r...it?usp=sharing

Is there something similar for the 440i Grand Coupe?!?!

MRV99 · 04-25-2017, 05:08 PM

Quote:

Originally Posted by gswcowboy

Quote:

Originally Posted by MRV99

Spread sheet update.
-Bug fix for the financial calculator: Hard coded the term instead of referencing the drop down. thanks bhap!
-Added the new leasing rates to the sheet. (yes they only reflect 36month residuals)

https://drive.google.com/file/d/0B-r...it?usp=sharing

Is there something similar for the 440i Grand Coupe?!?!

Unfortunately no. This was made due to the excitement for the M3/M4. I have no excitement for plain 440's

gswcowboy · 05-01-2017, 04:52 PM

Quote:

Originally Posted by MRV99

Unfortunately no. This was made due to the excitement for the M3/M4. I have no excitement for plain 440's

LOL, for shame!!! JK

MRV99 · 05-01-2017, 07:19 PM

Quote:

Originally Posted by gswcowboy

Quote:

Originally Posted by MRV99

Unfortunately no. This was made due to the excitement for the M3/M4. I have no excitement for plain 440's

LOL, for shame!!! JK

Feel free to take the spread sheet and modify it to fit the 440. Pretty straight forward. Price on tab one ends up on second page. Only tricky part is the selection of one package may change another package price

02-20-2014, 07:23 PM	#23
MRV99 Major 254 Rep 1,067 Posts Drives: 2017 M3 ZCP / 2017 RRS SC Join Date: Aug 2012 Location: Naperville iTrader: (1) Garage List 2017 BMW M3 ZCP [0.00]	posted below Last edited by MRV99; 02-21-2014 at 12:22 PM..
	Appreciate 0 Quote

02-20-2014, 07:41 PM	#24
hyperboost Captain 66 Rep 813 Posts Drives: M3 Boxster Corvette M5C Join Date: Mar 2010 Location: Boston iTrader: (0)	really useful but it's painful to look at the sum, lol. $87K __________________ 21 M5C DD\|21 M550 xDrive\|05 E46M3 race car 6SPD\|2019 2LT Corvette GS 7SPD track car\|22 Tundra SR5 TRD Sport\|19 Q7 V6 & 22 Q7 2.0T\|20 G63\|19 Vantage 4.0TT\|22 Boxster 25 Year 6SPD sold\|08 Porsche Cayman 5SPD sold\|18 R8 RWS sold\|Many previous cars
	Appreciate 0 Quote

02-20-2014, 09:09 PM	#25
BKMK5 First Lieutenant 29 Rep 344 Posts Drives: 2019 MB C43 Join Date: Jan 2009 Location: NY iTrader: (0)	Not sure if this is accurate but seemed to be. https://drive.google.com/file/d/0B1i...it?usp=sharing __________________ 2014 BMW X5 50i M Sport TOTALED-2013 Mercedes-Benz GL450 SOLD-2013 Porsche Cayenne S SOLD-2011.5 ///M3 Sedan ZCP SOLD-2008 E90 335i Sport
	Appreciate 0 Quote

02-20-2014, 10:44 PM	#26
magas Enlisted Member 12 Rep 46 Posts Drives: 2022 X6 Join Date: Jan 2013 Location: FL iTrader: (0)	I uploaded a new file that is more complex and lists the codes to keep the ordering straight. https://drive.google.com/file/d/0B2t...it?usp=sharing I am calling it version 1.0 It needs work due to the many ordering configurations which are dependent on each-other and is definitely not perfect. If anyone has more Excel experience you are welcome to improve it. I will post the most updated file on the first page of this post. Cant wait for the BMWUSA configurator to go up, I like many other got tired of waiting. Glad to see so many people actually used it. Last edited by magas; 02-21-2014 at 07:55 AM..
	Appreciate 0 Quote

02-20-2014, 11:07 PM	#27
MRV99 Major 254 Rep 1,067 Posts Drives: 2017 M3 ZCP / 2017 RRS SC Join Date: Aug 2012 Location: Naperville iTrader: (1) Garage List 2017 BMW M3 ZCP [0.00]	I have took Megas sheet and made it more automated. On the First tab(Build Sheet) any cell which is Green has a drop down list associated with it. By clicking on that green field, one can choose the option for that field. The items which you choose are Model(M3/M4), Option(Yes/No), Delivery Option(US/ED/Diplomat). If you select and option which requires or depends on another option(ZEC comes to mind) the calculator will automatically add that option to the price. Same goes for your leather options, if you choose extended and then select full, extended will be removed. If you add the full leather with the ZEC option, the price will be modified. You may find that when you select an option (Like Driver Assistance Package) which requires a dependent option(ZEC), it will add that options price to the build sheet but will not toggle that options yes/no indicator. It was designed to allow you to remove that package and automatically remove the package which it depended on. That way it reduces the amount of yes/no changing when selecting options. On the Second tab(Finanical Calculator) I also have added simple Calculators for both financing and leasing. Once again, on this tab, the orange cells are manual entries and the green cells will have a drop down list. I carry over values from the first tab for these calculations. Enjoy Spreadsheet: Updated 2/21/2014 5:00pm (fixed bug which did not reduce Rear shade from $500 to $350 if full leather option selected) https://drive.google.com/file/d/0B-r...it?usp=sharing __________________ 17 M3 ZCP -- 2017 Range Rover Sport SC --RIP-- 12 X5 50i Sport -- 11 M3 DCT -- 2011 X5 50i(Lemon) -- 2008 550 Msport -- 2007 x5 4.8 sport -- 2004 545 sport -- 2002 x5 4.4 sport -- 2001 540i Msport 2000 SL500 -- 1997 SL500 Last edited by MRV99; 02-21-2014 at 04:53 PM..
	Appreciate 0 Quote

02-21-2014, 09:50 AM	#28
///Mobbin Colonel 1477 Rep 2,672 Posts Drives: m3 Join Date: Jul 2011 Location: Houston iTrader: (3)	Thanks to you both, very useful! One thought might be to add in individual color or interior options. I am on the fence about ditching surround-view and the led headlights for an individual color, though that only gets me part way there!
	Appreciate 0 Quote

02-21-2014, 07:30 PM	#29
jafza412 Lieutenant 93 Rep 414 Posts Drives: AW M4 CS Join Date: Jul 2010 Location: Boston, MA iTrader: (3)	I took a stab too and got it all into one page. http://f80.bimmerpost.com/forums/sho...d.php?t=949482 Attached Images __________________ Current: 2016 M3 \| Mineral Grey on Black Retired: 2010 E92 335xi, 2007 E90 328i, 2010 A4, 2003 E46 325xi
	Appreciate 0 Quote

03-03-2014, 10:26 AM	#30
MRV99 Major 254 Rep 1,067 Posts Drives: 2017 M3 ZCP / 2017 RRS SC Join Date: Aug 2012 Location: Naperville iTrader: (1) Garage List 2017 BMW M3 ZCP [0.00]	Spread sheet update. -Bug fix for the financial calculator: Hard coded the term instead of referencing the drop down. thanks bhap! -Added the new leasing rates to the sheet. (yes they only reflect 36month residuals) https://drive.google.com/file/d/0B-r...it?usp=sharing __________________ 17 M3 ZCP -- 2017 Range Rover Sport SC --RIP-- 12 X5 50i Sport -- 11 M3 DCT -- 2011 X5 50i(Lemon) -- 2008 550 Msport -- 2007 x5 4.8 sport -- 2004 545 sport -- 2002 x5 4.4 sport -- 2001 540i Msport 2000 SL500 -- 1997 SL500
	Appreciate 0 Quote

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search