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

Camaro Price | Ordering | Tracking | Dealers Discussions Discuss pricing and ordering experiences.

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,690
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,690
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,690
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
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
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.
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........
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,690
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
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
FYI: Base model price for 2SS is way off. It's listing at $41855
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........
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,690
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
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
yup It did let me select the 1LE package though.
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........
Bad@ssCamaro is offline   Reply With Quote
Old 07-05-2013, 11:07 AM   #9
Bad@ssCamaro
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
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,
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........
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: 492
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
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
and the additional costs for metallic paints.
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........
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,690
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,690
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: 1346
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,690
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
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
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
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........

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: 371
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,690
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,690
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: 11,656
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,690
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
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
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, 44 views)
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........
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,690
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: earth
Posts: 426
good work. got the same numbers as when I added stuff up myself when the prices first came out.
__________________
RPM custom cam/ tune - 473hp/422tq
AGM 1LE is offline   Reply With Quote
Old 07-13-2013, 12:42 PM   #24
Bad@ssCamaro
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
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
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........
Bad@ssCamaro is offline   Reply With Quote
Old 07-15-2013, 07:24 PM   #25
Bad@ssCamaro
Ist State Chevy Supporter
 
Bad@ssCamaro's Avatar
 
Drives: 2015 1SS/1LE
Join Date: Sep 2009
Location: Western MA
Posts: 5,006
for new updates
__________________
Former Camaros: (gone but not forgotten)
1976 LT Black/Black 305 V8 (Bone Stock)
1976 LT Black/White 305 V8 (Bone Stock) except for Cragar chrome rims (yep - #2)
1985 Z-28 Black/Black 305 L69 M5(Bone Stock) I know: slow

Current Camaro:
CRT 1SS/1LE/RS/Recaro's/NPP/Nav/Rear vision pkg./BA speaker upgrade.

Quote:
Originally Posted by fbodfather View Post
CAFE STANDARDS! Get used to them or vote our electeds in Washington out of office...........
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 03:15 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.