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
 
Drives: 2008 128i 2013 X3 1999 M3
Join Date: Jan 2013
Location: FL

Posts: 20
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
magas is offline  
0
Reply With Quote
      02-19-2014, 07:59 AM   #2
dmk08
///Maniac
 
dmk08's Avatar
 
Drives: 2011 E92 M3
Join Date: Jul 2012
Location: Atlanta

Posts: 2,352
iTrader: (8)

Garage List
2011 BMW M3 E92  [0.00]
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.
dmk08 is offline  
0
Reply With Quote
      02-20-2014, 02:02 PM   #3
Maz335i
BMW 4 Life...
 
Maz335i's Avatar
 
Drives: 2012 335i M Sport (Special Ed)
Join Date: Feb 2012
Location: Mississauga, Ontario

Posts: 3,100
iTrader: (0)

Thanks bud!
__________________
MODS: *** / M Sport + Performance / Meisterschaft / Challenge / MORR / more to come! ***
Maz335i is offline   Canada
0
Reply With Quote
      02-20-2014, 02:12 PM   #4
Ash83
Major
 
Ash83's Avatar
 
Drives: 10' 135i (sold)/14' Audi RS5
Join Date: Jan 2010
Location: Miami, FL

Posts: 1,168
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
Ash83 is offline   United_States
0
Reply With Quote
      02-20-2014, 02:27 PM   #5
325rider
Zyzz Follower
 
Drives: '11 e90 M3 6mt
Join Date: Aug 2010
Location: Miami, Fl

Posts: 769
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
325rider is offline   United_States
0
Reply With Quote
      02-20-2014, 02:52 PM   #6
chris s
Major General
 
chris s's Avatar
 
Drives: 2012 e92 M3
Join Date: Oct 2008
Location: New York

Posts: 5,299
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!
chris s is offline  
0
Reply With Quote
      02-20-2014, 03:02 PM   #7
Definitive
definitivecars.com
 
Definitive's Avatar
 
Drives: Elsa - 2015 F80 M3 - YMB/SS
Join Date: Aug 2006
Location: So Cal

Posts: 3,722
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
__________________
Definitive is offline   United_States
0
Reply With Quote
      02-20-2014, 03:20 PM   #8
bigsid05
Enlisted Member
 
Drives: N/A
Join Date: May 2013
Location: NY

Posts: 38
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.
bigsid05 is offline  
0
Reply With Quote
      02-20-2014, 03:21 PM   #9
angelc5
Private First Class
 
angelc5's Avatar
 
Drives: 2000 Z3, 2015 M4
Join Date: Sep 2013
Location: Charlotte NC

Posts: 184
iTrader: (0)

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


2000 Z3 2.3
2011 328
angelc5 is offline   United_States
0
Reply With Quote
      02-20-2014, 03:53 PM   #10
Malek@MRF
Brigadier General
 
Malek@MRF's Avatar
 
Drives: E92 M3
Join Date: Jan 2008
Location: Irvine, California

Posts: 3,365
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
Malek@MRF is offline   United_States
0
Reply With Quote
      02-20-2014, 04:06 PM   #11
jbockrd
Lieutenant
 
jbockrd's Avatar
 
Drives: e92 Alpine White/Carbon M3
Join Date: Jul 2006
Location: Yardley, PA

Posts: 550
iTrader: (0)

Thank you!!!!
__________________
On the list for an M4!!
jbockrd is offline   United_States
0
Reply With Quote
      02-20-2014, 04:12 PM   #12
cotmfk
Brigadier General
 
cotmfk's Avatar
 
Drives: 2007 335i
Join Date: Mar 2009
Location: DC, MD, VA

Posts: 3,461
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!
__________________
cotmfk is offline  
0
Reply With Quote
      02-20-2014, 04:13 PM   #13
Sedan_Clan
Banned
 
Drives: '14 335i(prev.IB,AW M3's & X5)
Join Date: Jun 2006
Location: On 2 wheels clipping an apex!

Posts: 10,923
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!
Sedan_Clan is offline   Brazil
0
Reply With Quote
      02-20-2014, 04:17 PM   #14
hwelvaar
Major
 
Drives: BMW M135i MT
Join Date: Jan 2008
Location: Belgium

Posts: 1,069
iTrader: (0)

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

hwelvaar is offline   Belgium
0
Reply With Quote
      02-20-2014, 05:18 PM   #15
notan///m
Lieutenant Colonel
 
notan///m's Avatar
 
Drives: AY F80 (in the oven)
Join Date: Feb 2012
Location: USA

Posts: 1,951
iTrader: (4)

Garage List
awesome!
__________________


CCA Member

notan///m is offline  
0
Reply With Quote
      02-20-2014, 05:31 PM   #16
pkimM3r
Major General
 
pkimM3r's Avatar
 
Drives: m3 saloon in granny mode.
Join Date: Dec 2009
Location: lost angeles

Posts: 7,306
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
__________________
the intardnet is 95% troll, 5% actual good shit. so are my posts.
my channel: pkim
pkimM3r is offline  
0
Reply With Quote
      02-20-2014, 05:32 PM   #17
pkimM3r
Major General
 
pkimM3r's Avatar
 
Drives: m3 saloon in granny mode.
Join Date: Dec 2009
Location: lost angeles

Posts: 7,306
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.
__________________
the intardnet is 95% troll, 5% actual good shit. so are my posts.
my channel: pkim
pkimM3r is offline  
0
Reply With Quote
      02-20-2014, 05:33 PM   #18
pkimM3r
Major General
 
pkimM3r's Avatar
 
Drives: m3 saloon in granny mode.
Join Date: Dec 2009
Location: lost angeles

Posts: 7,306
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
__________________
the intardnet is 95% troll, 5% actual good shit. so are my posts.
my channel: pkim
pkimM3r is offline  
0
Reply With Quote
      02-20-2014, 05:49 PM   #19
Maddict3
Captain
 
Maddict3's Avatar
 
Drives: 2015 MW M4
Join Date: Jun 2012
Location: Miami

Posts: 830
iTrader: (0)

I had plans to do this today! you beat me to it! nice
Maddict3 is offline  
0
Reply With Quote
      02-20-2014, 06:03 PM   #20
pkimM3r
Major General
 
pkimM3r's Avatar
 
Drives: m3 saloon in granny mode.
Join Date: Dec 2009
Location: lost angeles

Posts: 7,306
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.
__________________
the intardnet is 95% troll, 5% actual good shit. so are my posts.
my channel: pkim
pkimM3r is offline  
0
Reply With Quote
      02-20-2014, 07:59 PM   #21
BKMK5
First Lieutenant
 
Drives: 2014 X5 50i M Sport
Join Date: Jan 2009
Location: NY

Posts: 313
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
BKMK5 is offline  
0
Reply With Quote
      02-20-2014, 08:12 PM   #22
BMWonlyZone
I Reserve the Right!
 
BMWonlyZone's Avatar
 
Drives: 2014 M5/MCB over SSII
Join Date: Jan 2014
Location: Northern NJ/NYC Metro

Posts: 217
iTrader: (0)

Curious to see how these babies will lease out. For the first year or so I bet its ugly!
BMWonlyZone is offline   United_States
0
Reply With Quote
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 01:06 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