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, 01:56 AM   #1
magas
New Member
3
Rep
20
Posts

 
Drives: 2008 128i 2013 X3 1999 M3
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 08:54 AM. Reason: Update
Appreciate 0
      02-19-2014, 07:59 AM   #2
dmk08
///Maniac
dmk08's Avatar
75
Rep
3,435
Posts

 
Drives: 15 F80 MG/SO 6MT
Join Date: Jul 2012
Location: Atlanta

iTrader: (9)

Garage List
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, 02:02 PM   #3
Maz335i
BMW 4 Life...
Maz335i's Avatar
Canada
55
Rep
3,222
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, 02:12 PM   #4
Ash83
Major
Ash83's Avatar
United_States
14
Rep
1,168
Posts

 
Drives: 10' 135i (sold)/14' Audi RS5
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, 02:27 PM   #5
325rider
Zyzz Follower
United_States
9
Rep
788
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, 02:52 PM   #6
chris s
Major General
chris s's Avatar
71
Rep
5,476
Posts

 
Drives: 2012 e92 M3
Join Date: Oct 2008
Location: New York

iTrader: (8)

Cool!
__________________

2012 MR e92 M3 DCT, fully loaded... ESS VT2-625, Brembo 380, BBS FI's, Akra/Challenge Sport, KW Sleeve kit, Full OEM CF Interior
2008 e92 M3 Coupe 6MT | AW/BLK Extended...SOLD!
Appreciate 0
      02-20-2014, 03:02 PM   #7
Definitive
definitivecars.com
Definitive's Avatar
United_States
94
Rep
3,793
Posts

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

iTrader: (3)

Garage List
Send a message via AIM to Definitive Send a message via MSN to Definitive
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, 03:20 PM   #8
bigsid05
Enlisted Member
0
Rep
40
Posts

 
Drives: N/A
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, 03:21 PM   #9
angelc5
Second Lieutenant
angelc5's Avatar
United_States
3
Rep
201
Posts

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

iTrader: (0)

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


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

 
Drives: E92 M3, E46 M3, F30, E30
Join Date: Jan 2008
Location: Irvine, California

iTrader: (5)

Send a message via AIM to Malek@MRF
Mine came out to $86,890. I am not sure how I feel about that.
__________________

BMW PERFORMANCE SPECIALISTS. Suspension. Forced Induction. Brakes. Race Preparation. Service. Alignments.
OFFICIAL PARTNERS: Íhlins. KW Suspension. Brembo. AP Racing. ESS Tuning. iND Distribution. Turner Motorsport.
Facebook | Instagram | Yelp! | Flikr | Contact | YouTube
Appreciate 0
      02-20-2014, 04:06 PM   #11
jbockrd
Lieutenant
jbockrd's Avatar
United_States
7
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, 04:12 PM   #12
cotmfk
Brigadier General
cotmfk's Avatar
40
Rep
3,494
Posts

 
Drives: 2007 335i
Join Date: Mar 2009
Location: DC, MD, VA

iTrader: (11)

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!
__________________
Appreciate 0
      02-20-2014, 04:13 PM   #13
Sedan_Clan
Banned
Brazil
130
Rep
10,918
Posts

 
Drives: '14 335i(prev.IB,AW M3's & X5)
Join Date: Jun 2006
Location: On 2 wheels clipping an apex!

iTrader: (25)

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, 04:17 PM   #14
hwelvaar
Major
Belgium
24
Rep
1,071
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, 05:18 PM   #15
Doctor///M
Colonel
Doctor///M's Avatar
52
Rep
2,204
Posts

 
Drives: F80 M3, R56 MCS
Join Date: Feb 2012
Location: HTX

iTrader: (4)

Garage List
2015 BMW M3  [4.00]
2009 BMW 335i  [0.00]
2010 MINI Cooper S  [0.00]
awesome!
__________________
2015 BMW M3 (ED 03-11-14) /l\ Austin Yellow /i\ 6MT /l\ Exec Pkg /i\ HK Audio /l\ 437M
CCA Member
Appreciate 0
      02-20-2014, 05:31 PM   #16
pkimM3r
Banned
pkimM3r's Avatar
95
Rep
7,321
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, 05:32 PM   #17
pkimM3r
Banned
pkimM3r's Avatar
95
Rep
7,321
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, 05:33 PM   #18
pkimM3r
Banned
pkimM3r's Avatar
95
Rep
7,321
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, 05:49 PM   #19
Maddict3
Major
Maddict3's Avatar
25
Rep
1,074
Posts

 
Drives: 2015 MW M4
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, 06:03 PM   #20
pkimM3r
Banned
pkimM3r's Avatar
95
Rep
7,321
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, 07:59 PM   #21
BKMK5
First Lieutenant
9
Rep
322
Posts

 
Drives: 2014 X5 50i M Sport
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, 08:12 PM   #22
BMWonlyZone
I Reserve the Right!
BMWonlyZone's Avatar
United_States
3
Rep
225
Posts

 
Drives: 2014 M5/MCB over SSII
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
Forum Jump


All times are GMT -5. The time now is 07:42 PM.




f80post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
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