2022 Tracking Spreadsheet
Tuned
Joined: May 2021
Posts: 265
Likes: 214
I optioned wheel well liners and mud flaps, so that may be my "Sent Offsite" status.
Thought I'd share this for others that might have optioned these additional items to avoid any post build status surprises!
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
@Phoenixfla Can you add a new column and separate the trim from the truck F-series? Example: 'Model' column for F350, and 'Trim' column for Lariat. Will make it easier for sorting.
Thanks!
Thanks!
That particular column comes in as one field from the database. I may be able to create a formula that pulls the first 4 digits from that column and copies them to another column and the rest of the data to a third.
Are you able to sort the spreadsheet by columns on your end?
Cross-Country
Joined: Jun 2021
Posts: 55
Likes: 74
From: Central TX
I got the same email today. Says build week 19 July but I've known that for over a week.
Trailering
Joined: Jul 2021
Posts: 16
Likes: 11
Not easily. On the purgatory I manually filled in a lot of columns, so I broke that data down in more detail. With the 2022 tracker all the columns pull from Ford, or your own input.
That particular column comes in as one field from the database. I may be able to create a formula that pulls the first 4 digits from that column and copies them to another column and the rest of the data to a third.
Are you able to sort the spreadsheet by columns on your end?
That particular column comes in as one field from the database. I may be able to create a formula that pulls the first 4 digits from that column and copies them to another column and the rest of the data to a third.
Are you able to sort the spreadsheet by columns on your end?
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
I've made some enhancements to the spreadsheet. At @Hooves suggestion, I was able to separate the model from the trim, so I replaced the year column since we have no 2021s any more.
I've also color coded the model and trim.
While I was color coding, I set up the user submitted build date to color code by week. Trucks having the same color are scheduled for the same week. Key on far right side of spreadsheet. (and don't forget the 2nd tab at the bottom that sorts by build date.)
Great response from everyone submitting your build weeks / days and seeing more user notes being submitted. Particularly interested in the users that have been rescheduled to Sept adding the options they believe caused the delay.
Remember all the instructions for adding your truck to the tracker and adding /changing your build date and user defined notes are in the 1st post of this thread.
Thanks everyone!
ETA - Also, some members' forum usernames are their first and last names. From now on, on the tracker, I am just going to use first name and last initial.
I've also color coded the model and trim.
While I was color coding, I set up the user submitted build date to color code by week. Trucks having the same color are scheduled for the same week. Key on far right side of spreadsheet. (and don't forget the 2nd tab at the bottom that sorts by build date.)
Great response from everyone submitting your build weeks / days and seeing more user notes being submitted. Particularly interested in the users that have been rescheduled to Sept adding the options they believe caused the delay.
Remember all the instructions for adding your truck to the tracker and adding /changing your build date and user defined notes are in the 1st post of this thread.
Thanks everyone!
ETA - Also, some members' forum usernames are their first and last names. From now on, on the tracker, I am just going to use first name and last initial.
Senior User
Joined: Sep 2016
Posts: 192
Likes: 52
In addition to that, 2 years ago they increased the annual registration fees on vehicles over 10k GVWR instead of putting a toll on I-81. In addition to raising the base registration fee they also added a surcharge per 1000 lbs of GVWR. The effect of that caused my 3 year registration to go from $209 (2017) to $480 (2020).
And all of that is why I ordered my 2022 derated to 10k GVWR.
More Turbo
Joined: Sep 2020
Posts: 508
Likes: 196
I've made some enhancements to the spreadsheet. At @Hooves suggestion, I was able to separate the model from the trim, so I replaced the year column since we have no 2021s any more.
I've also color coded the model and trim.
While I was color coding, I set up the user submitted build date to color code by week. Trucks having the same color are scheduled for the same week. Key on far right side of spreadsheet. (and don't forget the 2nd tab at the bottom that sorts by build date.)
Great response from everyone submitting your build weeks / days and seeing more user notes being submitted. Particularly interested in the users that have been rescheduled to Sept adding the options they believe caused the delay.
Remember all the instructions for adding your truck to the tracker and adding /changing your build date and user defined notes are in the 1st post of this thread.
Thanks everyone!
I've also color coded the model and trim.
While I was color coding, I set up the user submitted build date to color code by week. Trucks having the same color are scheduled for the same week. Key on far right side of spreadsheet. (and don't forget the 2nd tab at the bottom that sorts by build date.)
Great response from everyone submitting your build weeks / days and seeing more user notes being submitted. Particularly interested in the users that have been rescheduled to Sept adding the options they believe caused the delay.
Remember all the instructions for adding your truck to the tracker and adding /changing your build date and user defined notes are in the 1st post of this thread.
Thanks everyone!
New User
Joined: Jul 2021
Posts: 2
Likes: 1
FTE Stories
Ford Trucks for Ford Truck Enthusiasts
Top 10 Fords at 2026 Carlisle Ford Nationals
Joe Kucinski
3 Best / 3 Worst Parts of Modern Ford Ownership
Brett Foote
10 Amazing Upgrades That Solve Common Ford Truck Owner Headaches
Pouria Savadkouei
Every 2026 Ford Engine Explained
Brett Foote
10 Ugly Ford Trucks That We Still Kinda Love
Joe Kucinski
10 Things Every Truck Owner NEEDS (2026 Edition)
Michael S. Palmer
Rezvani's Latest Post-Apocalyptic Monster Is a Ford F-150 Raptor Underneath
Verdad Gallardo
Top 10 Most Expensive Ford Trucks Ever Sold on Bring a Trailer
Joe Kucinski
2027 Ford Super Duty Buyer's Guide (Every Model, Engine, & Package)
Brett Foote
Senior User
Joined: Feb 2021
Posts: 158
Likes: 79
Did a little poking around on older threads and found a few tidbits of post build status info. Some guys on threads in 2020 were talking about the post build status "Released to Body Company" which specifically seemed to reference being sent out for spray in bedliner install, and another, "Sent Offsite" as mine shows now after yesterday's build. According to these common threads, "Sent Offsite" refers to other offsite installations such as wheel well liners, mud flaps, 5th wheel hitches etc. (things that aren't installed on the line).
I optioned wheel well liners and mud flaps, so that may be my "Sent Offsite" status.
Thought I'd share this for others that might have optioned these additional items to avoid any post build status surprises!
I optioned wheel well liners and mud flaps, so that may be my "Sent Offsite" status.
Thought I'd share this for others that might have optioned these additional items to avoid any post build status surprises!
its not really "off site" its just on the other side of the plant. See attached photo ( you can also find this photo on google images) . But the add on's (bedliner, fifth wheel etc...) are done at manning equiptment https://truckequip.com/our-story/ , its no father away from the plant than the train car loading facility (circled in green) or the truck loading facility across the street (circled in yellow)
Senior User
Joined: Mar 2021
Posts: 206
Likes: 138
Phoenixfla - what source do you use for the data? The tracking sites I use (Ford, F150, Mach E) all show my production date and an ETA, but it seems like the spreadsheet isn't updated yet.
Still no window sticker...
Just saw on the 2017+ facebook group that an early 2022 Stock unit has arrived and is for sale ($10k over MSRP).
Still no window sticker...
Just saw on the 2017+ facebook group that an early 2022 Stock unit has arrived and is for sale ($10k over MSRP).
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
I've got 2 trucks for you now, so I numbered them as such.
Phoenixfla - what source do you use for the data? The tracking sites I use (Ford, F150, Mach E) all show my production date and an ETA, but it seems like the spreadsheet isn't updated yet.
Still no window sticker...
Just saw on the 2017+ facebook group that an early 2022 Stock unit has arrived and is for sale ($10k over MSRP).
Still no window sticker...
Just saw on the 2017+ facebook group that an early 2022 Stock unit has arrived and is for sale ($10k over MSRP).
That data then makes its way to the customer database the the non-Ford trackers can access. Sometimes it takes a few hours or overnight for them to sync up.
Then we get to the spreadsheet. That pulls from the same customer database, but the data is not "pushed" to the spreadsheet, rather the spreadsheet has to reach out for updates. It is suppose to do that every hour, but the more trucks we add, the longer the updates take, and it does not start counting to start the next update until the last finishes. That can lead to delays so actual refreshes only happen about every 2 hours. This may lead to a need to cap the total number of trucks on the spreadsheet.
So Ford.com has the freshest data, followed by doing a 1-off search on the third party trackers, followed by the spreadsheet, which usually catches up in a few hours.
TMI?