2015 M3/M4 Configurator

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

I saw some other price guides floating around and thought I'd take a stab at innovating a little further. This should be ready to go with the M3/M4 pricing, and includes logic to manage interior pricing based on ZEC selection and the like. Please let me know if there are any bugs. Hope you like.

You choose from drop down selections in all of the grey boxes.

www.jamilafza.com/2015_M3M4_Configurator.xlsx

parky1215 · 02-21-2014, 08:00 PM

Gas guzzler tax? I doubt that this car will have it.

Carl L · 02-21-2014, 08:13 PM

Quote:

Originally Posted by parky1215

Gas guzzler tax? I doubt that this car will have it.

Yup, it does not.

Alpine F31 · 02-21-2014, 08:25 PM

Not a gas guzzler!

jafza412 · 02-21-2014, 08:57 PM

Really? Awesome! You can click "No" on that, but I will remove it as an option all together.

rottjr · 02-22-2014, 06:31 AM

When opened in excel the options area doesn't work correctly. The options list and corresponding drop down and pricing aren't aligned.

Still better than I could do on my own.

rottjr · 02-22-2014, 12:11 PM

Left off Destination Charge and Enhanced Bluetooth. I added it to the form I downloaded after a bit of tweaking to unlock the cells all is well now.

Thanks a Bunch

jafza412 · 02-22-2014, 12:39 PM

Quote:

Originally Posted by rottjr

Left off Destination Charge and Enhanced Bluetooth. I added it to the form I downloaded after a bit of tweaking to unlock the cells all is well now.

Thanks a Bunch

Updated with Destination Charge and Enhanced Bluetooh.

I didn't think I put any restrictions on the sheets, what did you have to unlock to modify?

CiprianS · 02-22-2014, 10:58 PM

The file is not there anymore... can you upload it again? Thanks.

jafza412 · 02-23-2014, 12:14 AM

Quote:

Originally Posted by CiprianS

The file is not there anymore... can you upload it again? Thanks.

It is back, sorry about that. I changed my hosting solution and had a hiccup.

rottjr · 02-23-2014, 07:16 AM

I didn't think I put any restrictions on the sheets, what did you have to unlock to modify?[/QUOTE]

What actually happened was the "yes/no" boxes didn't line up when I opened the file in excel. The drop downs always had the wheels in them. After I re-did the data verification in excel all was well.

Thanks Again

ZGM3 · 02-23-2014, 11:06 AM

Quote:

Originally Posted by parky1215

Gas guzzler tax? I doubt that this car will have it.

Gas guzzler tax= NO
Gas guzzler the first month of driving WOT= YES

CiprianS · 02-24-2014, 03:06 PM

Quote:

Originally Posted by jafza412

Updated with Destination Charge and Enhanced Bluetooh.

I didn't think I put any restrictions on the sheets, what did you have to unlock to modify?

Still not working...

404 Error File Not Found

The page you are looking for might have been removed,
had its name changed, or is temporarily unavailable.

jafza412 · 02-24-2014, 04:58 PM

Quote:

Originally Posted by CiprianS

Still not working...

404 Error File Not Found

The page you are looking for might have been removed,
had its name changed, or is temporarily unavailable.

Argh, okay it's back now. Sorry about that!

CiprianS · 02-24-2014, 06:51 PM

Thank you!

$84,681.88... with European Delivery... damn... this is a lot.

Better wait until next summer to see what deals they will throw then, right now they are not offering anything I guess.

Sir Loin · 03-03-2014, 05:57 PM

I found a couple bugs in the sheet:

Enhanced USB Bluetooth and Smartphone Integration is $500 according to the guide, not $350 as in the sheet now
Power Rear Sunshade is $575 without Full Merino Leather. With Full Merino Leather, it is $350. The sheet currently doesn’t take this into account and always add $575 whether Full Merino Leather is chosen or not.

Thanks for putting the sheet together.

02-21-2014, 07:26 PM	#1
jafza412 Lieutenant 93 Rep 414 Posts Drives: AW M4 CS Join Date: Jul 2010 Location: Boston, MA iTrader: (3)	2015 M3/M4 Configurator - Compact I saw some other price guides floating around and thought I'd take a stab at innovating a little further. This should be ready to go with the M3/M4 pricing, and includes logic to manage interior pricing based on ZEC selection and the like. Please let me know if there are any bugs. Hope you like. You choose from drop down selections in all of the grey boxes. www.jamilafza.com/2015_M3M4_Configurator.xlsx Attached Images __________________ Current: 2016 M3 \| Mineral Grey on Black Retired: 2010 E92 335xi, 2007 E90 328i, 2010 A4, 2003 E46 325xi Last edited by jafza412; 02-21-2014 at 07:39 PM..
	Appreciate 0 Tweet Quote

02-21-2014, 08:00 PM	#2
parky1215 Lieutenant Colonel 560 Rep 1,978 Posts Drives: F90 M5C \| G06 X6 M60i Join Date: Nov 2010 Location: Rancho Cucamonga, CA iTrader: (13)	Gas guzzler tax? I doubt that this car will have it.
	Appreciate 0 Quote

02-21-2014, 08:25 PM	#4
Alpine F31 Colonel 918 Rep 2,710 Posts Drives: MB E350 4MATIC Estate Join Date: Feb 2012 Location: Sherman Oaks, CA iTrader: (1) Garage List 2014 Jeep Grand Che ... [0.00] 2015 BMW M235i (sold) [0.00] 2013 BMW 328i (sold) [10.00]	Not a gas guzzler!
	Appreciate 0 Quote

02-21-2014, 08:57 PM	#5
jafza412 Lieutenant 93 Rep 414 Posts Drives: AW M4 CS Join Date: Jul 2010 Location: Boston, MA iTrader: (3)	Really? Awesome! You can click "No" on that, but I will remove it as an option all together. __________________ Current: 2016 M3 \| Mineral Grey on Black Retired: 2010 E92 335xi, 2007 E90 328i, 2010 A4, 2003 E46 325xi
	Appreciate 0 Quote

02-22-2014, 06:31 AM	#6
rottjr Private First Class 28 Rep 109 Posts Drives: m4 Join Date: Jan 2014 Location: Northern Virginia iTrader: (0)	When opened in excel the options area doesn't work correctly. The options list and corresponding drop down and pricing aren't aligned. Still better than I could do on my own.
	Appreciate 0 Quote

02-22-2014, 12:11 PM	#7
rottjr Private First Class 28 Rep 109 Posts Drives: m4 Join Date: Jan 2014 Location: Northern Virginia iTrader: (0)	Left off Destination Charge and Enhanced Bluetooth. I added it to the form I downloaded after a bit of tweaking to unlock the cells all is well now. Thanks a Bunch
	Appreciate 0 Quote

02-22-2014, 10:58 PM	#9
CiprianS M addicted 99 Rep 439 Posts Drives: G05 xDrive 40i Join Date: Jan 2007 Location: Houston, Texas iTrader: (0)	The file is not there anymore... can you upload it again? Thanks.
	Appreciate 0 Quote

02-23-2014, 07:16 AM	#11
rottjr Private First Class 28 Rep 109 Posts Drives: m4 Join Date: Jan 2014 Location: Northern Virginia iTrader: (0)	I didn't think I put any restrictions on the sheets, what did you have to unlock to modify?[/QUOTE] What actually happened was the "yes/no" boxes didn't line up when I opened the file in excel. The drop downs always had the wheels in them. After I re-did the data verification in excel all was well. Thanks Again
	Appreciate 0 Quote

02-24-2014, 06:51 PM	#15
CiprianS M addicted 99 Rep 439 Posts Drives: G05 xDrive 40i Join Date: Jan 2007 Location: Houston, Texas iTrader: (0)	Thank you! $84,681.88... with European Delivery... damn... this is a lot. Better wait until next summer to see what deals they will throw then, right now they are not offering anything I guess. Last edited by CiprianS; 02-24-2014 at 07:02 PM..
	Appreciate 0 Quote

03-03-2014, 05:57 PM	#16
Sir Loin M3AT LOVER 322 Rep 1,853 Posts Drives: Silverstone F80 M3 Join Date: Aug 2013 Location: Seattle iTrader: (0)	I found a couple bugs in the sheet: Enhanced USB Bluetooth and Smartphone Integration is $500 according to the guide, not $350 as in the sheet now Power Rear Sunshade is $575 without Full Merino Leather. With Full Merino Leather, it is $350. The sheet currently doesn’t take this into account and always add $575 whether Full Merino Leather is chosen or not. Thanks for putting the sheet together.
	Appreciate 0 Quote

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