Point and Click MSRP Tool
#1
Moderator
Thread Starter
Point and Click MSRP Tool
Want to quickly determine what the MSRP for your C7 will be? This Excel spreadsheet uses radio buttons and check boxes to select the model and options and calculates the MSRP of your configuration. If you choose an invalid combination (for example, try to add the Carbon Fiber interior option to a 1LT), you are notified the choice is not valid. I believe this has all of the options that have had prices released thus far. Also, there is a tab that has the details (with photos) of the different trim levels (1LT, 2LT, 3LT) taken from the sales guide. If you find this useful, great. If not, at least I learned how to use some controls in Excel.
Fixed problems with Nav/MyLink (UY4) and Sueded Microfiber-Wrapped Trim Package (IWE).
Fixed problems with Nav/MyLink (UY4) and Sueded Microfiber-Wrapped Trim Package (IWE).
Last edited by Zymurgy; 04-29-2013 at 11:00 AM.
#2
Le Mans Master
Member Since: Apr 2013
Posts: 6,657
Received 4,116 Likes
on
1,470 Posts
2020 C8 of the Year Finalist - Unmodified
Nice. Great post.
#4
I think there's an error. If I try to select the Sueded microfiber-wrapped trim package (IWE) with 3LT...it get's kicked out as invalid. That's actually the way I ordered it at my dealer the other day and it's not invalid.
#5
Le Mans Master
Member Since: Apr 2013
Posts: 6,657
Received 4,116 Likes
on
1,470 Posts
2020 C8 of the Year Finalist - Unmodified
Also if you select 3LT, it lets you select Nav. Nav comes with 3LT.
#6
Melting Slicks
#10
Great job! only one thing that needs to be updated that I have noticed.
When clicking on "Navigation" for 1LT or 2LT equipped cars, it doesn't add it to the total vehicle price. Hope this help!
When clicking on "Navigation" for 1LT or 2LT equipped cars, it doesn't add it to the total vehicle price. Hope this help!
#11
Melting Slicks
Member Since: Feb 2013
Location: Central Gulf Coast Florida
Posts: 2,483
Received 574 Likes
on
328 Posts
Want to quickly determine what the MSRP for your C7 will be? This Excel spreadsheet uses radio buttons and check boxes to select the model and options and calculates the MSRP of your configuration. If you choose an invalid combination (for example, try to add the Carbon Fiber interior option to a 1LT), you are notified the choice is not valid. I believe this has all of the options that have had prices released thus far. Also, there is a tab that has the details (with photos) of the different trim levels (1LT, 2LT, 3LT) taken from the sales guide. If you find this useful, great. If not, at least I learned how to use some controls in Excel.
#12
Moderator
Thread Starter
#13
The "Invalid Selection" warning has been removed for "Sueded microfiber-wrapped trim package (IWE)" but the cost still isn't added to the total when clicked.
Thanks for doing this!
Thanks for doing this!
#17
Moderator
Thread Starter
It is in the original post. I replaced the attachment.
#18
Moderator
Thread Starter
#20
Burning Brakes
I can select Z51 with Auto, but in the RPO it is not an option. Is this an error?
Nevermind. Learned once again Reading is fundamental. I read the RPO wrong.
Nevermind. Learned once again Reading is fundamental. I read the RPO wrong.
Last edited by Thompyt; 04-29-2013 at 11:13 AM.