Autotalent
BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read

Go Back   BMW M3 and BMW M4 Forum > BMW F80 M3 / F82 M4 Forum > F80 M3 / M4 Pricing, Ordering, European Delivery

Post Reply
 
Thread Tools Search this Thread
      02-19-2014, 12:56 AM   #1
magas
Enlisted Member
12
Rep
46
Posts

Drives: 2022 X6
Join Date: Jan 2013
Location: FL

iTrader: (0)

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

BIMMERPOST
     Featured on BIMMERPOST.com
I just put this together to keep my options in order and to help organize my build. There are likely many mistakes.. Seems to work well so far.
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.
  1. Easiest thing is to open in Microsoft Excel.
  2. Or in Google Drive: 'file -> Open With -> Google Sheets' and you don't even have to DL.


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
Appreciate 0
      02-19-2014, 06:59 AM   #2
dmk08
Gone Fishin’
dmk08's Avatar
United_States
7315
Rep
12,125
Posts

Drives: Walks
Join Date: Jul 2012
Location: Atlanta

iTrader: (19)

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:02 PM   #3
Maz335i
BMW 4 Life...
Maz335i's Avatar
Canada
148
Rep
3,360
Posts

Drives: 2015 SO M3 (on order)
Join Date: Feb 2012
Location: Mississauga, Ontario

iTrader: (0)

Thanks bud!
__________________
MODS: *** / M Sport + Performance / Meisterschaft / Challenge / MORR / more to come! ***
Appreciate 0
      02-20-2014, 01:12 PM   #4
Ash83
Major
Ash83's Avatar
United_States
41
Rep
1,177
Posts

Drives: 135i & RS5 (SOLD)/ 18 CTS-V
Join Date: Jan 2010
Location: Miami, FL

iTrader: (1)

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
325rider
Captain
United_States
35
Rep
826
Posts

Drives: '11 e90 M3 6mt
Join Date: Aug 2010
Location: Miami, Fl

iTrader: (1)

Quote:
Originally Posted by dmk08 View Post
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.
__________________

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
chris s
Major General
chris s's Avatar
1239
Rep
6,906
Posts

Drives: 2022 Dravit G80 M3
Join Date: Oct 2008
Location: New York

iTrader: (12)

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
Definitive
definitivecars.com
Definitive's Avatar
United_States
352
Rep
3,833
Posts

Drives: Elsa - 2015 F80 M3 - YMB/SS
Join Date: Aug 2006
Location: So Cal

iTrader: (3)

Garage List
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:20 PM   #8
bigsid05
First Lieutenant
109
Rep
303
Posts

Drives: '15 MG/SO M4
Join Date: May 2013
Location: NY

iTrader: (0)

It's not overly automated, just nicely organized. Enter in the prices for the options you want in the right column and it'll add it up for you.
Appreciate 0
      02-20-2014, 02:21 PM   #9
angelc5
Second Lieutenant
angelc5's Avatar
United_States
24
Rep
206
Posts

Drives: 2000 Z3, 2015 M4
Join Date: Sep 2013
Location: Charlotte NC

iTrader: (0)

Garage List
2015 BMW M4  [8.00]
2000 BMW Z3  [0.00]
Thank You
__________________


2000 Z3 2.3
2011 328
Appreciate 0
      02-20-2014, 02:53 PM   #10
Malek@MRF
Brigadier General
Malek@MRF's Avatar
United_States
719
Rep
3,735
Posts

Drives: E92 M3, E46 M3, G82 M4
Join Date: Jan 2008
Location: Irvine, California

iTrader: (5)

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:06 PM   #11
jbockrd
Lieutenant
jbockrd's Avatar
United_States
23
Rep
550
Posts

Drives: e92 Alpine White/Carbon M3
Join Date: Jul 2006
Location: Yardley, PA

iTrader: (0)

Thank you!!!!
__________________
On the list for an M4!!
Appreciate 0
      02-20-2014, 03:12 PM   #12
cotmfk
Major General
cotmfk's Avatar
2018
Rep
6,088
Posts

Drives: M3
Join Date: Mar 2009
Location: Somewhere between DC and FL

iTrader: (12)

Quote:
Originally Posted by Malek@MRF View Post
Mine came out to $86,890. I am not sure how I feel about that.
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
Sedan_Clan
Law Enforcer
Sedan_Clan's Avatar
Brazil
24705
Rep
22,194
Posts

Drives: '22 Chalk Gray Porsche C2S
Join Date: Jun 2006
Location: ..in your rearview!!!

iTrader: (26)

Quote:
Originally Posted by Malek@MRF View Post
Mine came out to $86,890. I am not sure how I feel about that.
You can handle it balla!
Appreciate 0
      02-20-2014, 03:17 PM   #14
hwelvaar
Major
Belgium
112
Rep
1,140
Posts

Drives: BMW M135i MT
Join Date: Jan 2008
Location: Belgium

iTrader: (0)

Excel to calculate the price of your car...
As an ITer, I LOLed

Appreciate 0
      02-20-2014, 04:18 PM   #15
Doctor///M
Brigadier General
Doctor///M's Avatar
United_States
1781
Rep
4,215
Posts

Drives: 2023 AUDI RS6
Join Date: Feb 2012
Location: USA

iTrader: (14)

Garage List
2023 Audi RS6 Avant  [0.00]
BMW M2 Competition   [10.00]
2009 BMW 335i  [0.00]
2015 M3  [9.52]
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:31 PM   #16
pkimM3r
Banned
pkimM3r's Avatar
205
Rep
7,298
Posts

Drives: m3 saloon in granny mode.
Join Date: Dec 2009
Location: lost angeles

iTrader: (0)

Part of my job is financial modeling. I'll take a look upstairs. I'm taking a smoke break. Freaking excel nerds! Lol
Appreciate 0
      02-20-2014, 04:32 PM   #17
pkimM3r
Banned
pkimM3r's Avatar
205
Rep
7,298
Posts

Drives: m3 saloon in granny mode.
Join Date: Dec 2009
Location: lost angeles

iTrader: (0)

Quote:
Originally Posted by hwelvaar
Excel to calculate the price of your car...
As an ITer, I LOLed

Ha. I think excel is sometimes better than an interface.
Appreciate 0
      02-20-2014, 04:33 PM   #18
pkimM3r
Banned
pkimM3r's Avatar
205
Rep
7,298
Posts

Drives: m3 saloon in granny mode.
Join Date: Dec 2009
Location: lost angeles

iTrader: (0)

Quote:
Originally Posted by bigsid05
It's not overly automated, just nicely organized. Enter in the prices for the options you want in the right column and it'll add it up for you.
I'll try to automate it as much as possible without getting caught working on hobby shit lol
Appreciate 0
      02-20-2014, 04:49 PM   #19
Maddict3
Major
Maddict3's Avatar
192
Rep
1,292
Posts

Drives: 2015 991 GT3
Join Date: Jun 2012
Location: Miami

iTrader: (0)

I had plans to do this today! you beat me to it! nice
Appreciate 0
      02-20-2014, 05:03 PM   #20
pkimM3r
Banned
pkimM3r's Avatar
205
Rep
7,298
Posts

Drives: m3 saloon in granny mode.
Join Date: Dec 2009
Location: lost angeles

iTrader: (0)

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
BKMK5
First Lieutenant
29
Rep
344
Posts

Drives: 2019 MB C43
Join Date: Jan 2009
Location: NY

iTrader: (0)

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
      02-20-2014, 07:12 PM   #22
BMWonlyZone
I Reserve the Right!
BMWonlyZone's Avatar
41
Rep
262
Posts

Drives: 2022 M5 Comp - MBB/BLK
Join Date: Jan 2014
Location: Northern NJ/NYC Metro

iTrader: (0)

Curious to see how these babies will lease out. For the first year or so I bet its ugly!
Appreciate 0
Post Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -5. The time now is 06:22 AM.




f80post
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST