2022 MY Pricing and Codes
Thread Starter
Melting Slicks
Joined: Jul 2011
Posts: 2,780
Likes: 314
From: Morris Co. NJ
St. Jude Donor '12-'13-'14-'15-'16-'17-'18,'21
2022 MY Pricing and Codes (Spreadsheet)
This is the 8th model year that I am posting an Excel spreadsheet that will let you figure out what your new car will set you back. You can download the spreadsheet below. If you need help you can PM me. Anyone who finds any errors please let me know and I will fix and update the spreadsheet and this page. This is version 3.
Column "H" is where you will make all your selections except as noted below You can select an item by putting an "x" in column H (x is the only character that can be used). If the option is not available pricing won't show up. When certain options are selected there are others that will be selected automatically and any additional costs will be added.
For those interested I have included an amortization / loan calculator. It will give you a good idea of your monthly payments will be.
If you are not familiar with Excel or this spreadsheet please read the following:
In column H you will see a Yellow ribbon running from cell H2 to cell H281. To start select the model of the car you want to specify by putting an "x" in column H next to the model. Next select the trim 1LT, 2LT, or 3LT by using the same process. Once you select the trim level some of the yellow boxes in column H will automatically become populated to indicate that the option or feature is included in your vehicle. The same will happen when certain options are selected. In the Yellow column continue putting x’s next to the options that you want. Keep in mind the following:
You must select a model and trim before you will see the seating options.
If you want the ZCR option, keep in mind that there are only two exterior color options, Accelerate Yellow Metallic or Hypersonic Gray Metallic.
Once you have selected all your options you can now proceed to the bottom of the page. Column “D” is where you will be working. Cell D284 will give you the MSRP for the vehicle. If you have a trade cell D285 is the place to put it. In cell D286 you can put in any number you want to indicate a discount you think is fair and reasonable[img]file:///C:\Users\Michael\AppData\Local\Temp\msoh tmlclip1\01\clip_image001.gif[/img]. Cell D287 is where you can insert any dealer or GM incentives. You can figure sales tax if you like (you need to change the percentage in column C cell 289 by putting in the percentage for your state. You can then enter Motor Vehicle charges if any.
Some people say that you can do this online. That maybe true but you can do so much more that I think you will find this spreadsheet worthwhile.
For those who live in the 7 US states that do not give you credit for a trade in regarding state sales tax put an "x" in cell E280.
This spreadsheet will be updated as new pricing or error corrections are made.
Thank you and enjoy!!!
Column "H" is where you will make all your selections except as noted below You can select an item by putting an "x" in column H (x is the only character that can be used). If the option is not available pricing won't show up. When certain options are selected there are others that will be selected automatically and any additional costs will be added.
For those interested I have included an amortization / loan calculator. It will give you a good idea of your monthly payments will be.
If you are not familiar with Excel or this spreadsheet please read the following:
In column H you will see a Yellow ribbon running from cell H2 to cell H281. To start select the model of the car you want to specify by putting an "x" in column H next to the model. Next select the trim 1LT, 2LT, or 3LT by using the same process. Once you select the trim level some of the yellow boxes in column H will automatically become populated to indicate that the option or feature is included in your vehicle. The same will happen when certain options are selected. In the Yellow column continue putting x’s next to the options that you want. Keep in mind the following:
You must select a model and trim before you will see the seating options.
If you want the ZCR option, keep in mind that there are only two exterior color options, Accelerate Yellow Metallic or Hypersonic Gray Metallic.
Once you have selected all your options you can now proceed to the bottom of the page. Column “D” is where you will be working. Cell D284 will give you the MSRP for the vehicle. If you have a trade cell D285 is the place to put it. In cell D286 you can put in any number you want to indicate a discount you think is fair and reasonable[img]file:///C:\Users\Michael\AppData\Local\Temp\msoh tmlclip1\01\clip_image001.gif[/img]. Cell D287 is where you can insert any dealer or GM incentives. You can figure sales tax if you like (you need to change the percentage in column C cell 289 by putting in the percentage for your state. You can then enter Motor Vehicle charges if any.
Some people say that you can do this online. That maybe true but you can do so much more that I think you will find this spreadsheet worthwhile.
For those who live in the 7 US states that do not give you credit for a trade in regarding state sales tax put an "x" in cell E280.
This spreadsheet will be updated as new pricing or error corrections are made.
Thank you and enjoy!!!
Last edited by MKenM; Nov 14, 2021 at 02:27 PM.
Instructor
Joined: Aug 2019
Posts: 188
Likes: 144
From: Aurora, Colorado
It's showing not available for Morello Red Dipped and Tension/Twilight Blue Dipped even though I have 3LT and GT2 seats selected.
Also, it won't let me select ZF1 Aero Delete even though I have Z51 selected.
Also, it won't let me select ZF1 Aero Delete even though I have Z51 selected.
Last edited by Smuuth; Aug 30, 2021 at 12:17 PM.
Melting Slicks
Joined: Feb 2006
Posts: 2,261
Likes: 1,431
From: Brentwood CA
Thank you!!! I do, however, have the same issue here. I can put an "X" for TVS but it does not add the price when I select it.
Last edited by Dave O; Aug 30, 2021 at 04:00 PM.
Corvette Stories
The Best of Corvette for Corvette Enthusiasts
Top 10 Most Expensive Corvettes Ever Sold on Bring A Trailer
Brett Foote
10 Things Every Corvette Owner Needs (2026 Edition)
Michael S. Palmer
8 Most "Only Corvette Owners Understand" Quirks and Problems
Pouria Savadkouei
10 Reasons the C6 Z06 is Still A Performance Benchmark After 20 Years
Joe Kucinski
How Much Horsepower Every Corvette Engine "LOST" in 1972
Joe Kucinski
Top 10 DOs and DON'Ts for Protecting Your Convertible Top!
Michael S. Palmer
Top 10 Most Explosive Corvettes Ever Made: Power-to-Weight Ratio Ranked!
Joe Kucinski
150 hp to 1,250 hp: Every Corvette Generation Compared by the Specs That Matter
Joe Kucinski
8 Coolest Corvette Pace Cars (and Replicas) of All Time
Verdad Gallardo
Intermediate
Joined: Nov 2005
Posts: 42
Likes: 26
Thank you for doing this once again.
I also am questioning the twilight blue interior not being available. I have a 2022 order at 2000 status that shows twilight blue interior. Also, I see the new lower spoiler option in your spreadsheet but I had been told the option was not available with Z51? I have written to Mike at Criswell for clarification and I will post his reply.
Mark
I also am questioning the twilight blue interior not being available. I have a 2022 order at 2000 status that shows twilight blue interior. Also, I see the new lower spoiler option in your spreadsheet but I had been told the option was not available with Z51? I have written to Mike at Criswell for clarification and I will post his reply.
Mark
Moderator
Joined: Feb 2006
Posts: 39,135
Likes: 17,985
From: DFW Area TX
Thank you for doing this once again.
I also am questioning the twilight blue interior not being available. I have a 2022 order at 2000 status that shows twilight blue interior. Also, I see the new lower spoiler option in your spreadsheet but I had been told the option was not available with Z51? I have written to Mike at Criswell for clarification and I will post his reply.
Mark
I also am questioning the twilight blue interior not being available. I have a 2022 order at 2000 status that shows twilight blue interior. Also, I see the new lower spoiler option in your spreadsheet but I had been told the option was not available with Z51? I have written to Mike at Criswell for clarification and I will post his reply.
Mark
ZF1 Aero delete, removes spoiler and splitter from Z51 Performance Package
1 - Requires (Z51) Z51 Performance Package. Not available with 5VM, 5W8, 5V5, 5ZU, 5ZZ.
1 - Requires (Z51) Z51 Performance Package. Not available with 5VM, 5W8, 5V5, 5ZU, 5ZZ.
TVS NEW! Low-profile rear spoiler and front splitter
1 - Requires (ZF1) aero delete if (Z51) Z51 Performance Package is ordered.
1 - Requires (ZF1) aero delete if (Z51) Z51 Performance Package is ordered.
Racer
Joined: Apr 2021
Posts: 459
Likes: 397
From: Mason, OH
Was just playing with the file to compare it to the Workbench preliminary order detail my dealer printed for me and here's something I noticed: I selected HT7 on row 115 and the description in column B says it includes N26 but cell I124says 'Available' instead of "Included in Package" and therefore the $595 Option MSRP isn't being included in the totals on row 282. When my dealer input HT7 it defaulted to include N26 and I noticed there is a $595 total cost difference in my build between the Workbench doc and the excel spreadsheet. Should an X be automatically added to cell H124 when selected HT7 ? Thanks.
Last edited by DEC8; Aug 30, 2021 at 10:43 PM.
Thread Starter
Melting Slicks
Joined: Jul 2011
Posts: 2,780
Likes: 314
From: Morris Co. NJ
St. Jude Donor '12-'13-'14-'15-'16-'17-'18,'21
Was just playing with the file to compare it to the Workbench preliminary order detail my dealer printed for me and here's something I noticed: I selected HT7 on row 115 and the description in column B says it includes N26 but cell I124says 'Available' instead of "Included in Package" and therefore the $595 Option MSRP isn't being included in the totals on row 282. When my dealer input HT7 it defaulted to include N26 and I noticed there is a $595 total cost difference in my build between the Workbench doc and the excel spreadsheet. Should an X be automatically added to cell H124 when selected HT7 ? Thanks.
Thread Starter
Melting Slicks
Joined: Jul 2011
Posts: 2,780
Likes: 314
From: Morris Co. NJ
St. Jude Donor '12-'13-'14-'15-'16-'17-'18,'21
Thank you for doing this once again.
I also am questioning the twilight blue interior not being available. I have a 2022 order at 2000 status that shows twilight blue interior. Also, I see the new lower spoiler option in your spreadsheet but I had been told the option was not available with Z51? I have written to Mike at Criswell for clarification and I will post his reply.
Mark
I also am questioning the twilight blue interior not being available. I have a 2022 order at 2000 status that shows twilight blue interior. Also, I see the new lower spoiler option in your spreadsheet but I had been told the option was not available with Z51? I have written to Mike at Criswell for clarification and I will post his reply.
Mark
Thread Starter
Melting Slicks
Joined: Jul 2011
Posts: 2,780
Likes: 314
From: Morris Co. NJ
St. Jude Donor '12-'13-'14-'15-'16-'17-'18,'21
Mike
Racer
Joined: Apr 2021
Posts: 459
Likes: 397
From: Mason, OH
Thanks for the quick reply and fix. I remember our communications regarding the MY21 file and the incredibly complex formulas in some of those cells so certainly understand how adjustment might be needed.
Instructor
Joined: Aug 2019
Posts: 188
Likes: 144
From: Aurora, Colorado
Robert