Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums - Camaro5.com
 
ModBargains
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,283
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,283
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,283
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,565
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,283
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,565
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,283
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,565
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,565
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: 566
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,565
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,283
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,283
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: 1409
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,283
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
Old 07-09-2013, 07:37 PM   #15
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,565
Hey RJ, I did some tweaks, let me know what you think. If you like it, post up some screen shots, since I can't seem to screen capture with my 'puter
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.


Last edited by Bad@ssCamaro; 07-09-2013 at 08:28 PM.
Bad@ssCamaro is offline   Reply With Quote
Old 07-09-2013, 10:39 PM   #16
Egon
 
Egon's Avatar
 
Drives: 2014 2SS/RS 1LE
Join Date: May 2013
Location: San Diego
Posts: 450
Found a slight bug that at first made me pretty happy then realized what was going on. The 1LE package is only adding its cost to the MSRP line, but not the other columns throwing those prices off by about $3k. Other than that a pretty nice work sheet if you are getting ready to buy a 2014 like I am! Thanks.
Egon is offline   Reply With Quote
Old 07-10-2013, 11:07 AM   #17
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,283
Quote:
Originally Posted by Bad@ssCamaro View Post
Hey RJ, I did some tweaks, let me know what you think. If you like it, post up some screen shots, since I can't seem to screen capture with my 'puter
Dude - AMAZING. Thank you. I've got to tweak the numbers a bit (stupid gas guzzler tax giving me issues)
Quote:
Originally Posted by Egon View Post
Found a slight bug that at first made me pretty happy then realized what was going on. The 1LE package is only adding its cost to the MSRP line, but not the other columns throwing those prices off by about $3k. Other than that a pretty nice work sheet if you are getting ready to buy a 2014 like I am! Thanks.
Fixed it. Thanks for the heads up on that. I'll upload a new version shortly once I finalize the GG tax
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-10-2013, 11:42 AM   #18
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,283
Updated the Excel sheet - it's pretty much perfect now.
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-10-2013, 11:57 AM   #19
2SSRS@Gen5diy
Salt & Pepper 2014 Z/28

 
2SSRS@Gen5diy's Avatar
 
Drives: 2010 2SS IOM ,2014 Z/28, 66 Nova
Join Date: Oct 2008
Location: By the lake in AZ
Posts: 12,316
where is the price on the Z/28 car ? LOL
__________________
2SSRS@Gen5diy is offline   Reply With Quote
Old 07-10-2013, 01:34 PM   #20
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,283
Quote:
Originally Posted by 2SSRS View Post
where is the price on the Z/28 car ? LOL
It was too much - I put the numbers in and it broke the spreadsheet
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-11-2013, 08:47 PM   #21
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,565
Added a couple more options and tweaks, NOW it's ALMOST perfect. Oh, and maybe you can figure out how to turn off the short throw shifter when selecting the 1LE package.
Attached Files
File Type: zip Build_Your_Own_Camaro_by_The_Stig_and_BadassCamaro.zip (154.0 KB, 54 views)
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Bad@ssCamaro is offline   Reply With Quote
Old 07-12-2013, 11:56 AM   #22
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,283
Quote:
Originally Posted by Bad@ssCamaro View Post
Added a couple more options and tweaks, NOW it's ALMOST perfect. Oh, and maybe you can figure out how to turn off the short throw shifter when selecting the 1LE package.
I'll upload it when I get back to my computer, and yes I can turn it off - very easy fix.
__________________
Click to view my build thread
The Stig is offline   Reply With Quote
Old 07-12-2013, 12:20 PM   #23
AGM 1LE
 
AGM 1LE's Avatar
 
Drives: 14 SS/ 1LE
Join Date: Jun 2013
Location: parts unknown
Posts: 531
good work. got the same numbers as when I added stuff up myself when the prices first came out.
__________________
Insert list of parts that no one reads here
AGM 1LE is offline   Reply With Quote
Old 07-13-2013, 12:42 PM   #24
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,565
Quote:
Originally Posted by The Stig View Post
I'll upload it when I get back to my computer, and yes I can turn it off - very easy fix.
Thanks RJ

ROTFLMAO...just saw your avatar
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Bad@ssCamaro is offline   Reply With Quote
Old 07-15-2013, 07:24 PM   #25
Bad@ssCamaro
Rogers' Rocks :-)
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,565
for new updates
__________________
2015 CRT 1SS/1LE RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Bad@ssCamaro 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 08:54 PM.


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