March Allocation Tracker
Thread Starter
Melting Slicks
Joined: May 2019
Posts: 2,605
Likes: 1,702
From: Lakewood Ranch, FL
March Allocation Tracker
Just realized I never set up a Google sheets file for March allocations like I did for the last 6 or so months. Anyone who is in that group interested in owning the spreadsheet if I set one up, or should I not bother?
Edit: Tracker for March allocations is here
The desired (but never required) datapoints are:
username
Dealer
Body Style (Coupe/HTC)
PEG (1LT, 2LT, 3LT)
Color
Z51 (Yes//No)
Museum Delivery (Yes/No)
GM Order Number
MSRP
First deposit date (if applicable)
Second deposit date (if applicable)
Date of 2000
Date of 3000
TPW at 3000 (if you get one)
Date of 3300
TPW at 3300 (if you get one)
Date of 3400
TPW at 3400 (if you get one)
Adjusted TPW (sometimes it changes even after you hit 3400, so this is a "just in case" column)
VIN
Date of 3800 (Production)
Date of 5000 (Delivery)
Edit: Tracker for March allocations is here
The desired (but never required) datapoints are:
username
Dealer
Body Style (Coupe/HTC)
PEG (1LT, 2LT, 3LT)
Color
Z51 (Yes//No)
Museum Delivery (Yes/No)
GM Order Number
MSRP
First deposit date (if applicable)
Second deposit date (if applicable)
Date of 2000
Date of 3000
TPW at 3000 (if you get one)
Date of 3300
TPW at 3300 (if you get one)
Date of 3400
TPW at 3400 (if you get one)
Adjusted TPW (sometimes it changes even after you hit 3400, so this is a "just in case" column)
VIN
Date of 3800 (Production)
Date of 5000 (Delivery)
Last edited by PColasanto; Mar 29, 2022 at 08:22 PM. Reason: Added link and list of data elements
Racer
Joined: Sep 2017
Posts: 486
Likes: 302
From: Centerville, OH
What does "owning" the spreadsheet entail? What do I have to do?
Racer
Joined: Sep 2019
Posts: 374
Likes: 169
From: DeKalb
Might as well be kind and do yourself again, maybe Im wrong but I assume its a smaller allocation month if its trying to round out the year.
Id offer but I have no idea how to do these spreadsheets even if they are super simple haha.
If you do thank you! If you dont, well thank you for all the months you have done!!! The tracker threads are always fun to read up on.
Id offer but I have no idea how to do these spreadsheets even if they are super simple haha.
If you do thank you! If you dont, well thank you for all the months you have done!!! The tracker threads are always fun to read up on.
Advanced
Joined: Mar 2017
Posts: 53
Likes: 5
I have a March allocation and can run with it if you tell me what needs to be done
Instructor
Joined: Oct 2004
Posts: 240
Likes: 53
From: North Port FL
I do have an observation though, on the Sorted By tab, I don't think all of the cells have the date calculation formulas in them... which impacts the numbers you see on the Summaries tab... if you look at that you can see some blank cells where the date difference should appear (mine being one of them for a couple of the timeframes)... whoever has edit ability may want to look into that... thanks again, it was very useful and informative for me!
Thread Starter
Melting Slicks
Joined: May 2019
Posts: 2,605
Likes: 1,702
From: Lakewood Ranch, FL
Thanks for the heads up, I'll take a look.
I had a Feb allocation and used the spreadsheet... and thread... great source of information and a help to get through the excitement of build and delivery! Thank you for creating this!
I do have an observation though, on the Sorted By tab, I don't think all of the cells have the date calculation formulas in them... which impacts the numbers you see on the Summaries tab... if you look at that you can see some blank cells where the date difference should appear (mine being one of them for a couple of the timeframes)... whoever has edit ability may want to look into that... thanks again, it was very useful and informative for me!
I do have an observation though, on the Sorted By tab, I don't think all of the cells have the date calculation formulas in them... which impacts the numbers you see on the Summaries tab... if you look at that you can see some blank cells where the date difference should appear (mine being one of them for a couple of the timeframes)... whoever has edit ability may want to look into that... thanks again, it was very useful and informative for me!
Thread Starter
Melting Slicks
Joined: May 2019
Posts: 2,605
Likes: 1,702
From: Lakewood Ranch, FL
Some understanding of spreadsheets is helpful to fix things when one of the users accidentally breaks something, but really, it just means monitoring this thread, entering data for anyone who's not comfortable doing it themselves (or can't because their work blocks filesharing, etc), and shooting me an IM if you need a hand with fixing/changing anything.
I'll go ahead and create the file this evening and add it to my initial post. Worst case it no one uses it, I guess
I'll go ahead and create the file this evening and add it to my initial post. Worst case it no one uses it, I guess
Corvette Stories
The Best of Corvette for Corvette Enthusiasts
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
Top 10 Corvette Engines RANKED by Peak Torque (70+ Years of Muscle!)
Joe Kucinski
Corvette ZR1X Will Be Pacing the Indy 500, And Could Probably Race, Too!
Verdad Gallardo
Top 10 Corvettes Coming to Mecum Indy 2026!
Brett Foote
Top 10 C9 Corvette MUST-HAVES to Fix These C8 Generation Flaws!
Michael S. Palmer
10 Revolutionary 'Corvette Firsts' Most People Don't Know
Joe Kucinski
5 Reasons to Upgrade to an LS6-Powered Corvette; 5 Reasons to Stay LT2
Michael S. Palmer
Racer
Joined: Sep 2017
Posts: 486
Likes: 302
From: Centerville, OH
Some understanding of spreadsheets is helpful to fix things when one of the users accidentally breaks something, but really, it just means monitoring this thread, entering data for anyone who's not comfortable doing it themselves (or can't because their work blocks filesharing, etc), and shooting me an IM if you need a hand with fixing/changing anything.
I'll go ahead and create the file this evening and add it to my initial post. Worst case it no one uses it, I guess
I'll go ahead and create the file this evening and add it to my initial post. Worst case it no one uses it, I guess
Ooops. I missed seeing that Boomscatty had already stepped up. So I will just stand by.
Last edited by RKTKTV; Mar 29, 2022 at 05:58 PM. Reason: Missed seeing relevant post.
Thread Starter
Melting Slicks
Joined: May 2019
Posts: 2,605
Likes: 1,702
From: Lakewood Ranch, FL
Fixed. Looks like someone just randomly deleted a whole bunch of formulas. Weird.
that's the downside of a file that everyone can edit, but it saves me a sh*tload of time having to enter/monitor everything, so the occasional file fix is definitely much preferred
that's the downside of a file that everyone can edit, but it saves me a sh*tload of time having to enter/monitor everything, so the occasional file fix is definitely much preferred
I had a Feb allocation and used the spreadsheet... and thread... great source of information and a help to get through the excitement of build and delivery! Thank you for creating this!
I do have an observation though, on the Sorted By tab, I don't think all of the cells have the date calculation formulas in them... which impacts the numbers you see on the Summaries tab... if you look at that you can see some blank cells where the date difference should appear (mine being one of them for a couple of the timeframes)... whoever has edit ability may want to look into that... thanks again, it was very useful and informative for me!
I do have an observation though, on the Sorted By tab, I don't think all of the cells have the date calculation formulas in them... which impacts the numbers you see on the Summaries tab... if you look at that you can see some blank cells where the date difference should appear (mine being one of them for a couple of the timeframes)... whoever has edit ability may want to look into that... thanks again, it was very useful and informative for me!
Thread Starter
Melting Slicks
Joined: May 2019
Posts: 2,605
Likes: 1,702
From: Lakewood Ranch, FL
@Boomscatty and @RKTKTV , if you're both willing to help, all the better. The basic deal is shoot me an IM if something seems to be going wrong with the file/data/calcs, and keep an eye on the thread. If someone says "here's my info: blah blah blah", it probably means they're not comfortable adding it to the file themselves, so if you can do that for them, it would be great. The file will give you a warning at the top if their data is already entered, so you should notice pretty easily if there are duplicates.
Let me know if you have any questions/comments/concerns, and go ahead and enter your own data so you know how to help others.
Let me know if you have any questions/comments/concerns, and go ahead and enter your own data so you know how to help others.
Thread Starter
Melting Slicks
Joined: May 2019
Posts: 2,605
Likes: 1,702
From: Lakewood Ranch, FL
Racer
Joined: Sep 2017
Posts: 486
Likes: 302
From: Centerville, OH
OK - Thanks to PColasanto, the tracker spreadsheet for March 2022 allocations is up and running. Find it at the link provided in the first post, or repeated below:
https://docs.google.com/spreadsheets...t#gid=99609475
https://docs.google.com/spreadsheets...t#gid=99609475
Last edited by RKTKTV; Mar 31, 2022 at 09:42 AM. Reason: correct link; spelling
