View Single Post
      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