When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.
I will never be able to fill C8J's shoes with this spreadsheet, but I'm going to give it a shot... With 2021 production on the near horizon, he and I both thought it would be a good time to start a thread for all of us (myself included) who are anxiously awaiting our C8's in the 2021 model year to follow the great soap opera called "life" and how it impacts us getting the object of our desires.
I have been working on the 2021 spreadsheet, and it's format will be familiar to those who have been following the 2020 version, but I've made some small tweeks based on feedback I've noticed over the past few months, that will hopefully help those new people who are more interested in following their own car. With those new people in mind, before we get going, I just wanted to set some expectations on what this spreadsheet is, and is not, and provide a quick explanation of how to interpret it. While it will likely morph over the coming months as life happens, but I expect the general idea to stay similar, as it's worked so well in the past.
What this is, and is not, is tracking of daily/weekly serial numbers that come off the line at the assembly plant in Bowling Green (BGA), and a projection of what might happen in the future. I am just an old guy, and not in any way an insider. Those numbers come from the internet, and we all know everything we see on the internet is correct right? Also, being just a guy, I have no idea on when production starts, or ends in 2021. We will all learn those dates together. And the spreadsheet will get changed to reflect them when we know more. So, the example I'll post below, includes the possibility of a 12-8 start week, and projects through the end of August. When we know better, we'll fix it.
So, here's an example of the initial spreadsheet. I've minimized acronyms for the acrophobes, and to make it easier to just look at it and figure it out for someone who jumps in mid thread, but beware, they will still be used. I'll explain the details below:
This fictional example assumes it's Thursday, 1-28-2021, and we've got yesterday's production numbers. The spreadsheet shows the current week broken out daily at the top, and the various weeks at the bottom. The current date/week is highlighted in yellow. Past history is highlighted in a light orange color, and future projections have no highlighting. In the weekly section, the column header "est or actual made" will contain actual numbers when highlighted with history, projections when not highlighted, and a mix when highlighted in yellow. The build projection numbers will be populated by a "2 week rolling average" of the production numbers from the previous two weeks. This may change as time goes by, and when (if?) there are plant shutdowns, it may have to be a manual guesstimate. (remember, I don't have access to any GM plans, so I'm basing this on history being a fair indicator of future performance)
The example also makes an "assumption" that production started on Monday, 12-14. I have no idea if that's what will happen, it's just an example. The "real" spreadsheet will reflect what really happens when we know it.
So, how do you use it? Well, once you reach code 3400, you should be able to get a partial VIN, and a Target Production Week (TPW). Find where that VIN fits in the projected weekly numbers, and you can get a fair idea when it will be made. As it gets closer, the range will be expanded to daily production, and you can then have an idea of what day your C8 rolls off the assembly line. This is very helpful as life impacts the production, as GM is not very responsive to the end buyer in terms of information.
I hope this helps, and if there are any requests or errors, I'm sure you'll be so kind as to tell me!
Yay me! Week 32 is hopefully going to bring a close to the adventure of purchasing a C8 for me. Compared to some, it was a short wait of nearly 13 months, but it had plenty of ups and downs, like any good roller coaster should... The plan is to hop on a flying bus tomorrow morning about the time Mr. Riel shares the daily production numbers, head to MM, pick up the car, and then do the old fart version of the cannonball run (probably more of a beach ball run I suppose) home.
That of course, makes it difficult to get the spreadsheet ready and post it in a timely manner. So, we will have a guest host, VetteBlessed, posting the spreadsheet this week. He was gracious enough to help out so I could make this happen, and I thank him very much. It will give him a chance to be prepared for the upcoming MY22 run, and keep those who read this thread as up to date as we can.
I thank you all in advance for your supporting VetteBlessed...
I will never be able to fill C8J's shoes with this spreadsheet, but I'm going to give it a shot... With 2021 production on the near horizon, he and I both thought it would be a good time to start a thread for all of us (myself included) who are anxiously awaiting our C8's in the 2021 model year to follow the great soap opera called "life" and how it impacts us getting the object of our desires.
I have been working on the 2021 spreadsheet, and it's format will be familiar to those who have been following the 2020 version, but I've made some small tweeks based on feedback I've noticed over the past few months, that will hopefully help those new people who are more interested in following their own car. With those new people in mind, before we get going, I just wanted to set some expectations on what this spreadsheet is, and is not, and provide a quick explanation of how to interpret it. While it will likely morph over the coming months as life happens, but I expect the general idea to stay similar, as it's worked so well in the past.
What this is, and is not, is tracking of daily/weekly serial numbers that come off the line at the assembly plant in Bowling Green (BGA), and a projection of what might happen in the future. I am just an old guy, and not in any way an insider. Those numbers come from the internet, and we all know everything we see on the internet is correct right? Also, being just a guy, I have no idea on when production starts, or ends in 2021. We will all learn those dates together. And the spreadsheet will get changed to reflect them when we know more. So, the example I'll post below, includes the possibility of a 12-8 start week, and projects through the end of August. When we know better, we'll fix it.
So, here's an example of the initial spreadsheet. I've minimized acronyms for the acrophobes, and to make it easier to just look at it and figure it out for someone who jumps in mid thread, but beware, they will still be used. I'll explain the details below:
This fictional example assumes it's Thursday, 1-28-2021, and we've got yesterday's production numbers. The spreadsheet shows the current week broken out daily at the top, and the various weeks at the bottom. The current date/week is highlighted in yellow. Past history is highlighted in a light orange color, and future projections have no highlighting. In the weekly section, the column header "est or actual made" will contain actual numbers when highlighted with history, projections when not highlighted, and a mix when highlighted in yellow. The build projection numbers will be populated by a "2 week rolling average" of the production numbers from the previous two weeks. This may change as time goes by, and when (if?) there are plant shutdowns, it may have to be a manual guesstimate. (remember, I don't have access to any GM plans, so I'm basing this on history being a fair indicator of future performance)
The example also makes an "assumption" that production started on Monday, 12-14. I have no idea if that's what will happen, it's just an example. The "real" spreadsheet will reflect what really happens when we know it.
So, how do you use it? Well, once you reach code 3400, you should be able to get a partial VIN, and a Target Production Week (TPW). Find where that VIN fits in the projected weekly numbers, and you can get a fair idea when it will be made. As it gets closer, the range will be expanded to daily production, and you can then have an idea of what day your C8 rolls off the assembly line. This is very helpful as life impacts the production, as GM is not very responsive to the end buyer in terms of information.
I hope this helps, and if there are any requests or errors, I'm sure you'll be so kind as to tell me!
Fantastic, very user friendly, appreciate your efforts. Thanks so much for doing this and thanks for your service!
Thank you so much for doing this for all of us. I am sure a lot of dealers are also thanking you as it will probably reduce the incoming "how much longer before my car is produced" inquiries.
I'm relieved that the SS moves on and in Capable Hands! In a few short weeks the 202My will close out and I look forward to getting my mornings back - again. Yes I have another job. A business to run. This has been my method of coping with the insanity 2020 has been, not to mention the POS. In fairness, my job with the 202MY SS will seem relatively a POC compared to what I anticipate Bob will have to deal with this upcoming MY. As one that knows what is involved to do tis on a daily basis, Please be patient and support him by being kind. I'm sure he will do everyone well!.
There is no need for Here.
Wishing you Fair Winds & Following Seas
I just noticed - Thanks, but the title should be 2021 BobG Production Spreadsheet.
Thanks, C8J for all the time you spent providing a very informative spread sheet.
Thanks, BobG for stepping up and taking the time consuming chore of inputting the new spread sheet. I will be more interested in the 2021 SS, simply because, eventually my VIN # will be on it!
Happy Thanksgiving!
Last edited by Mike's LS3; Nov 25, 2020 at 01:18 PM.
I'm one of the first 2021 orders at 3000 status and I'll try and help out where I can with TPWs etc. I've purchased the Corvette Museum Production Book so I should be receiving some early insight from Shane into TPW.
The next few weeks will be fun watching the 20s end and 21s begin!
I will never be able to fill C8J's shoes with this spreadsheet, but I'm going to give it a shot... With 2021 production on the near horizon, he and I both thought it would be a good time to start a thread for all of us (myself included) who are anxiously awaiting our C8's in the 2021 model year to follow the great soap opera called "life" and how it impacts us getting the object of our desires.
I have been working on the 2021 spreadsheet, and it's format will be familiar to those who have been following the 2020 version, but I've made some small tweeks based on feedback I've noticed over the past few months, that will hopefully help those new people who are more interested in following their own car. With those new people in mind, before we get going, I just wanted to set some expectations on what this spreadsheet is, and is not, and provide a quick explanation of how to interpret it. While it will likely morph over the coming months as life happens, but I expect the general idea to stay similar, as it's worked so well in the past.
What this is, and is not, is tracking of daily/weekly serial numbers that come off the line at the assembly plant in Bowling Green (BGA), and a projection of what might happen in the future. I am just an old guy, and not in any way an insider. Those numbers come from the internet, and we all know everything we see on the internet is correct right? Also, being just a guy, I have no idea on when production starts, or ends in 2021. We will all learn those dates together. And the spreadsheet will get changed to reflect them when we know more. So, the example I'll post below, includes the possibility of a 12-8 start week, and projects through the end of August. When we know better, we'll fix it.
So, here's an example of the initial spreadsheet. I've minimized acronyms for the acrophobes, and to make it easier to just look at it and figure it out for someone who jumps in mid thread, but beware, they will still be used. I'll explain the details below:
This fictional example assumes it's Thursday, 1-28-2021, and we've got yesterday's production numbers. The spreadsheet shows the current week broken out daily at the top, and the various weeks at the bottom. The current date/week is highlighted in yellow. Past history is highlighted in a light orange color, and future projections have no highlighting. In the weekly section, the column header "est or actual made" will contain actual numbers when highlighted with history, projections when not highlighted, and a mix when highlighted in yellow. The build projection numbers will be populated by a "2 week rolling average" of the production numbers from the previous two weeks. This may change as time goes by, and when (if?) there are plant shutdowns, it may have to be a manual guesstimate. (remember, I don't have access to any GM plans, so I'm basing this on history being a fair indicator of future performance)
The example also makes an "assumption" that production started on Monday, 12-14. I have no idea if that's what will happen, it's just an example. The "real" spreadsheet will reflect what really happens when we know it.
So, how do you use it? Well, once you reach code 3400, you should be able to get a partial VIN, and a Target Production Week (TPW). Find where that VIN fits in the projected weekly numbers, and you can get a fair idea when it will be made. As it gets closer, the range will be expanded to daily production, and you can then have an idea of what day your C8 rolls off the assembly line. This is very helpful as life impacts the production, as GM is not very responsive to the end buyer in terms of information.
I hope this helps, and if there are any requests or errors, I'm sure you'll be so kind as to tell me!
@BobG thank you for volunteering. I appreciate it. So do many others. @C8J we very much want to thank you for the countless hours doing a thankless job. I’m sure you’ve had your share of “No good deed goes unpunished” thoughts. It was very much appreciated.
2021 C8J Production Spreadsheet
With 2021 production on the near horizon, he and I both thought it would be a good time to start a thread for all of us (myself included) who are anxiously awaiting our C8's in the 2021 model year to follow the great soap opera called "life" and how it impacts us getting the object of our desires.
Here.
