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, 02: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 09:54 AM. Reason: Update
Appreciate 0
      02-19-2014, 08:59 AM   #2
dmk08
///Maniac
dmk08's Avatar
304
Rep
4,670
Posts

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

iTrader: (10)

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, 03:02 PM   #3
Maz335i
BMW 4 Life...
Maz335i's Avatar
Canada
78
Rep
3,336
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, 03:12 PM   #4
Ash83
Major
Ash83's Avatar
United_States
14
Rep
1,172
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, 03:27 PM   #5
325rider
Zyzz Follower
United_States
10
Rep
806
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, 03:52 PM   #6
chris s
Major General
chris s's Avatar
144
Rep
5,893
Posts

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

iTrader: (10)

Cool!
__________________

2012 MR e92 M3 DCT, fully loaded... FOR SALE!!!
2008 e92 M3 Coupe 6MT | AW/BLK Extended...SOLD!
Appreciate 0
      02-20-2014, 04:02 PM   #7
Definitive
definitivecars.com
Definitive's Avatar
United_States
108
Rep
3,804
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, 04:20 PM   #8
bigsid05
Private
8
Rep
83
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, 04:21 PM   #9
angelc5
Second Lieutenant
angelc5's Avatar
United_States
4
Rep
205
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, 04:53 PM   #10
Malek@MRF
Brigadier General
Malek@MRF's Avatar
United_States
112
Rep
3,504
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, 05:06 PM   #11
jbockrd
Lieutenant
jbockrd's Avatar
United_States
12
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, 05:12 PM   #12
cotmfk
Brigadier General
cotmfk's Avatar
56
Rep
3,689
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, 05:13 PM   #13
Sedan_Clan
California Highway Patrolling
Sedan_Clan's Avatar
Brazil
166
Rep
11,094
Posts

Drives: '15 M4 (lots-of-M's, RRS, 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, 05:17 PM   #14
hwelvaar
Major
Belgium
25
Rep
1,082
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, 06:18 PM   #15
Doctor///M
Colonel
Doctor///M's Avatar
144
Rep
2,713
Posts

Drives: F80 M3
Join Date: Feb 2012
Location: USA

iTrader: (5)

Garage List
2015 M3  [5.00]
2009 BMW 335i  [0.00]
2010 MINI Cooper S  [0.00]
awesome!
__________________
2015 BMW M3 /l\ Austin Yellow /i\ 6MT /l\ Exec Pkg /i\ HK Audio /l\ 437M
My Ultimate ED + PCD Experience
CCA Member

Appreciate 0
      02-20-2014, 06:31 PM   #16
pkimM3r
Banned
pkimM3r's Avatar
102
Rep
7,315
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, 06:32 PM   #17
pkimM3r
Banned
pkimM3r's Avatar
102
Rep
7,315
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, 06:33 PM   #18
pkimM3r
Banned
pkimM3r's Avatar
102
Rep
7,315
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, 06:49 PM   #19
Maddict3
Major
Maddict3's Avatar
35
Rep
1,143
Posts

Drives: 2015 MW M4
Join Date: Jul 2012
Location: Miami

iTrader: (0)

I had plans to do this today! you beat me to it! nice
Appreciate 0
      02-20-2014, 07:03 PM   #20
pkimM3r
Banned
pkimM3r's Avatar
102
Rep
7,315
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, 08:59 PM   #21
BKMK5
First Lieutenant
11
Rep
323
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, 09:12 PM   #22
BMWonlyZone
I Reserve the Right!
BMWonlyZone's Avatar
United_States
3
Rep
234
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 -4. The time now is 02:32 AM.




f80post
f80post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2015, 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