06-27-2013, 08:34 AM | #1 |
knows 2 facts about ducks
Drives: ...and they're both wrong Join Date: Aug 2009
Location: The HMS Invincible
Posts: 25,072
|
Build Your Own Camaro Spreadsheet
Made an Excel spreadsheet that does all the pricing/options stuffs for the camaro - my solution to the slightly confusing pricing spreadsheet (not that I'm not grateful for it of course). Basically it's the exact same this as the "Build Your Own" page on the Chevrolet website - minus the fancy graphics and rotating image. It's a macro-enabled Excel spreadsheet with Options/check boxes that gave you your 2014 order total.
I'll upload screenshots of the file shortly. Build_Your_Own_Camaro_by_The_Stig_and_BadassCamaro1.zip Screenshots: Last edited by The Stig; 09-07-2013 at 01:56 PM. |
07-05-2013, 09:47 AM | #2 |
knows 2 facts about ducks
Drives: ...and they're both wrong Join Date: Aug 2009
Location: The HMS Invincible
Posts: 25,072
|
Uploaded the Excel file to the OP - it's in a zip file because the site doesn't support uploading Excel files.
and I'm working on those screenshots now |
07-05-2013, 10:36 AM | #3 |
knows 2 facts about ducks
Drives: ...and they're both wrong Join Date: Aug 2009
Location: The HMS Invincible
Posts: 25,072
|
It's not a virus by the way - just you know, in case people weren't clicking it for that reason.
|
07-05-2013, 10:42 AM | #4 |
BeckyD Rocks :-)
|
I'm using MO 2007 and it's not allowing me to select any features.
Edit: nevermind, it was asking me if it wanted to enable the content first, it was in bar area above the tables, so I didn't notice it at first.
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade. Stage 3 BMR cam, ARH 1 7/8 headers, CAI,
BMR 1.25 drop springs, JPSS Billet Bushings, Peddars Cradle Bushings...460 whp...so far....SOLD, but not forgotten! |
07-05-2013, 10:45 AM | #5 |
knows 2 facts about ducks
Drives: ...and they're both wrong Join Date: Aug 2009
Location: The HMS Invincible
Posts: 25,072
|
So you got it to work then? Thoughts?
|
07-05-2013, 10:52 AM | #6 |
BeckyD Rocks :-)
|
FYI: Base model price for 2SS is way off. It's listing at $41855
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade. Stage 3 BMR cam, ARH 1 7/8 headers, CAI,
BMR 1.25 drop springs, JPSS Billet Bushings, Peddars Cradle Bushings...460 whp...so far....SOLD, but not forgotten! |
07-05-2013, 10:58 AM | #7 | |
knows 2 facts about ducks
Drives: ...and they're both wrong Join Date: Aug 2009
Location: The HMS Invincible
Posts: 25,072
|
Quote:
|
|
07-05-2013, 11:04 AM | #8 |
BeckyD Rocks :-)
|
yup It did let me select the 1LE package though.
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade. Stage 3 BMR cam, ARH 1 7/8 headers, CAI,
BMR 1.25 drop springs, JPSS Billet Bushings, Peddars Cradle Bushings...460 whp...so far....SOLD, but not forgotten! |
07-05-2013, 11:07 AM | #9 |
BeckyD Rocks :-)
|
How about adding on the other columns what the price would be for invoice, GMPP, etc.? Overall, it's a fairly easy and straightforward application to see what you can expect with options added on. Great job RJ,
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade. Stage 3 BMR cam, ARH 1 7/8 headers, CAI,
BMR 1.25 drop springs, JPSS Billet Bushings, Peddars Cradle Bushings...460 whp...so far....SOLD, but not forgotten! |
07-05-2013, 11:13 AM | #10 |
SoCal C5 Family Member
Drives: 1996 Z28 SS & 2014 ZL1 Join Date: Apr 2009
Location: Santee, CA
Posts: 799
|
Probably should also add the Gas Guzzler Tax rates for the ZL1.
__________________
Vance Chula -
1996 Camaro Z28 SS #1688 2014 Camaro ZL1 Coupe #1956 |
07-05-2013, 11:15 AM | #11 |
BeckyD Rocks :-)
|
and the additional costs for metallic paints.
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade. Stage 3 BMR cam, ARH 1 7/8 headers, CAI,
BMR 1.25 drop springs, JPSS Billet Bushings, Peddars Cradle Bushings...460 whp...so far....SOLD, but not forgotten! |
07-05-2013, 11:18 AM | #12 | |
knows 2 facts about ducks
Drives: ...and they're both wrong Join Date: Aug 2009
Location: The HMS Invincible
Posts: 25,072
|
Uploaded a new corrected version
Quote:
Working on that one now. again, working on adding those now. |
|
07-05-2013, 12:15 PM | #13 |
knows 2 facts about ducks
Drives: ...and they're both wrong Join Date: Aug 2009
Location: The HMS Invincible
Posts: 25,072
|
Uploaded a new version that includes color options (as well as the extra cost for BY and CRM). The extra paint cost gets added to the "Options Subtotal"
posting updated screenshots in a few as well |
07-05-2013, 03:29 PM | #14 |
knows 2 facts about ducks
Drives: ...and they're both wrong Join Date: Aug 2009
Location: The HMS Invincible
Posts: 25,072
|
Updated the sheet to include gas guzzler tax on the ZL1 - there's still a glitch where it doesn't always update the GG tax after you click the automatic option, to refresh it you just need to switch base models and then go back to whichever ZL1 you had clicked.
|
|
|
|
|