|
Post Reply |
|
Thread Tools | Search this Thread |
02-19-2014, 12:56 AM | #1 |
Enlisted Member
12
Rep 46
Posts |
Automated pricing spreadsheet to calculate total cost of 2015 M3 and M4
Featured on BIMMERPOST.com Thought some other members could use it to. It's a spreadsheet with all the most recent US prices and options (as of the 2/18/14 Pricing Guide) that you can pick and choose and to calculate your cost of your M3/M4.
Simple Version Type in prices and price calculates: More Automated Version Use Pull Down Menu to calculate cost and give Codes I am calling it version 1.0 Second Version needs work due to the many ordering configurations which are dependent on each-other, limiting which options can be chosen etc... It needs changes and to be improved, also will calculate Taxes. Enjoy ........... If anyone has more Excel experience you are welcome to improve it. Last edited by magas; 02-21-2014 at 07:54 AM.. Reason: Update |
02-19-2014, 06:59 AM | #2 |
Gone Fishin’
7316
Rep 12,125
Posts |
Works well for me. Definitely better than the janky spreadsheet I had thrown together.
Just a note in Google Drive you can just do 'file -> Open With -> Google Sheets' and you don't even have to DL the sheet to use it. |
Appreciate
0
|
02-20-2014, 01:12 PM | #4 |
Major
41
Rep 1,177
Posts |
Good Job
__________________
Alpine White, Coral RED , Glacier Silver Aluminum trim, M sport, 6MT, NAV, HiFi, USB-iPod, Bluetooth
Performance: JB4|BMW PE|DP Cosmetics: BMW Sport Pedals|Black Kidney Grill |
Appreciate
0
|
02-20-2014, 01:27 PM | #5 |
Captain
36
Rep 826
Posts |
__________________
Check out my YouTube Fitness Channel if your into that https://www.youtube.com/channel/UCoz...XQVuG0se8cTpUQ |
Appreciate
0
|
02-20-2014, 01:52 PM | #6 |
Major General
1250
Rep 6,912
Posts |
Cool!
__________________
2022 Dravit/Fiona M3cx - Dinan midpipe w/VC, NW Carbonhaus CF, AST Springs, FC Spacers...more to come!
2016 Indi F80 M3 - SMB|Amaro | Mode Carbon | ESS | Akra EVO | KW HAS...SOLD 2012 MR e92 M3 DCT, ESS SC, Brembo BBK, BBS FI... GONE but not forgotten! 2008 AW e92 M3 6MT, ESS SC, BBS LM's...SOLD! |
Appreciate
0
|
02-20-2014, 02:02 PM | #7 |
definitivecars.com
354
Rep 3,833
Posts
Drives: Elsa - 2015 F80 M3 - YMB/SS
Join Date: Aug 2006
Location: So Cal
iTrader: (3)
Garage List 2011 E90 M3 [6.66]
2009 (Lease up Sept ... [0.00] 2007 (Lease up 6/19 ... [0.00] 2007 (Lease up Octo ... [0.00] |
Interesting, are you guys all on PC's? Im on a Macbook and I dont see how to use the automated spread sheet. In Google or in excel...
D |
Appreciate
0
|
02-20-2014, 02:21 PM | #9 |
Second Lieutenant
24
Rep 206
Posts
Drives: 2000 Z3, 2015 M4
Join Date: Sep 2013
Location: Charlotte NC
|
Thank You
__________________
2000 Z3 2.3 2011 328 |
Appreciate
0
|
02-20-2014, 02:53 PM | #10 |
Brigadier General
731
Rep 3,735
Posts |
Mine came out to $86,890. I am not sure how I feel about that.
__________________
BMW PERFORMANCE SPECIALISTS. Race Engines. Suspension. F/I. Brakes. Race Preparation. Factory Service. Alignments.
OFFICIAL PARTNERS: KW. MOTON. Brembo. AP Racing. BBS Motorsport. iND. HRE. Turner Motorsport. VAC. BMW Motorsport. Facebook | Instagram | Yelp! | Flikr Phone: 949-233-0448 | E-Mail: info@mrfengineering.com |
Appreciate
0
|
02-20-2014, 03:12 PM | #12 |
Major General
2042
Rep 6,107
Posts |
That must have errrything in it. Mine came out under $64k!
__________________
When you say impact instead of affect/effect, you are communicating that you don't understand the difference between the two words, and are too lazy to learn.
|
Appreciate
0
|
02-20-2014, 03:13 PM | #13 |
Law Enforcer
25021
Rep 22,269
Posts
Drives: '22 Chalk Gray Porsche C2S
Join Date: Jun 2006
Location: ..in your rearview!!!
|
|
Appreciate
0
|
02-20-2014, 04:18 PM | #15 |
Brigadier General
1792
Rep 4,216
Posts |
awesome!
__________________
2020 F87 M2 Competition /l\ LBB /i\ Executive Package 2013 E70 X5M /l\ Space Grey /i\ Full Silverstone Leather /l\ LED Headlights /i\ Comfort Access /l\ HUD /i\ Ventilated Seats /l\ 22" BBS SV BMW CCA Member |
Appreciate
0
|
02-20-2014, 04:32 PM | #17 | |
Banned
205
Rep 7,298
Posts |
Quote:
|
|
Appreciate
0
|
02-20-2014, 04:33 PM | #18 | |
Banned
205
Rep 7,298
Posts |
Quote:
|
|
Appreciate
0
|
02-20-2014, 05:03 PM | #20 |
Banned
205
Rep 7,298
Posts |
wait this is not automated at all....you basically have to type in your price, which you wouldn't know unless you had some that info in handy. i was excited to see some excel nerdness but i guess not. i can reload something up later.
|
Appreciate
0
|
02-20-2014, 06:59 PM | #21 |
First Lieutenant
29
Rep 344
Posts |
Me and ChicagoFan have been using a spreadsheet for automating calculations on BMW Select. I'll have to put on a google drive for you guys to see/critique. Give me a couple hours.
__________________
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
|
Post Reply |
Bookmarks |
|
|