Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums - Camaro5.com
 
Anthony @ LG Motorsports
Go Back   Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums - Camaro5.com > General Camaro Forums > Camaro Price | Ordering | Tracking | Dealers Discussions


Reply
 
Thread Tools
Old 06-27-2013, 08:34 AM   #1
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,275
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:


__________________
Click to view my build thread

Last edited by The Stig; 09-07-2013 at 01:56 PM.
The Stig is offline   Reply With Quote
Old 07-05-2013, 09:47 AM   #2
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,275
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
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-05-2013, 10:36 AM   #3
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,275
It's not a virus by the way - just you know, in case people weren't clicking it for that reason.
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-05-2013, 10:42 AM   #4
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,716
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.

Bad@ssCamaro is offline   Reply With Quote
Old 07-05-2013, 10:45 AM   #5
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,275
Quote:
Originally Posted by Bad@ssCamaro View Post
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.
So you got it to work then? Thoughts?
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-05-2013, 10:52 AM   #6
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,716
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.

Bad@ssCamaro is offline   Reply With Quote
Old 07-05-2013, 10:58 AM   #7
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,275
Quote:
Originally Posted by Bad@ssCamaro View Post
FYI: Base model price for 2SS is way off. It's listing at $41855
Huh? In the screenshot it's showing as 36 thousand and change? Do you maybe have "convertible" selected?

__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-05-2013, 11:04 AM   #8
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,716
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.

Bad@ssCamaro is offline   Reply With Quote
Old 07-05-2013, 11:07 AM   #9
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,716
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.

Bad@ssCamaro is offline   Reply With Quote
Old 07-05-2013, 11:13 AM   #10
VChula
SoCal C5 Family Member
 
VChula's Avatar
 
Drives: 1996 Z28 SS & 2010 RS
Join Date: Apr 2009
Location: Santee, CA
Posts: 601
Probably should also add the Gas Guzzler Tax rates for the ZL1.
__________________
Vance Chula -
1996 Camaro Z28 SS #1688
2014 Camaro ZL1 Coupe #1956
VChula is offline   Reply With Quote
Old 07-05-2013, 11:15 AM   #11
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,716
and the additional costs for metallic paints.
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Bad@ssCamaro is offline   Reply With Quote
Old 07-05-2013, 11:18 AM   #12
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,275
Quote:
Originally Posted by Bad@ssCamaro View Post
yup It did let me select the 1LE package though.
Uploaded a new corrected version

Quote:
Originally Posted by Bad@ssCamaro View Post
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,
Do-able, but might take a little while as I have to look up all the different costs of stuff. Probably can do it today or tomorrow.

Quote:
Originally Posted by VChula View Post
Probably should also add the Gas Guzzler Tax rates for the ZL1.
Working on that one now.

Quote:
Originally Posted by Bad@ssCamaro View Post
and the additional costs for metallic paints.
again, working on adding those now.
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-05-2013, 12:15 PM   #13
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,275
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




Name:  Build_your_own_camaro_spreadsheet_5.png
Views: 1432
Size:  154.4 KB
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-05-2013, 03:29 PM   #14
The Stig
knows 2 facts about ducks
 
The Stig's Avatar
 
Drives: ...and they're both wrong
Join Date: Aug 2009
Location: The HMS Invincible
Posts: 26,275
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.
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
 
Reply

Thread Tools

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:02 AM.


Powered by vBulletin® Version 3.8.9 Beta 4
Copyright ©2000 - 2016, vBulletin Solutions, Inc.