Notices
2017 - 2022 Super Duty The 2017-2022 Ford F250, F350, F450, F550 & F600 Super Duty Pickup and Chassis Cab
Sponsored by:
Sponsored by: CARiD

2022 Tracking Spreadsheet

Thread Tools
 
Search this Thread
 
Old Aug 12, 2021 | 08:32 AM
  #736  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
I swapped out the last 5 options for the ones below. It does appear that the retractable tonneau adds 6-7 days, except for aafd806 who somehow got all the post production options and shipped in 1 day.


ETA - Folding Tonneau could be dealer installed, I don't know.
 
Reply
Old Aug 12, 2021 | 08:52 AM
  #737  
kshoop1958's Avatar
kshoop1958
Laughing Gas
5 Year Member
Liked
Loved
Community Favorite
Joined: Apr 2021
Posts: 988
Likes: 596
From: Middle TN
Phoenixfla, I'm wondering how you pull in "Delivered" status? Your spreadsheet is showing me as the first and only one so far for 8/12, but the trackers still show me "In Transit". I'm hoping you're right!
 
Reply
Old Aug 12, 2021 | 09:16 AM
  #738  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Originally Posted by kshoop1958
Phoenixfla, I'm wondering how you pull in "Delivered" status? Your spreadsheet is showing me as the first and only one so far for 8/12, but the trackers still show me "In Transit". I'm hoping you're right!
All the data fields are populated directly from the Ford database. I have not seen one show delivered that wasn't actually delivered. I'll bet you $1 it's at your dealer.
 
Reply
Old Aug 12, 2021 | 09:23 AM
  #739  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Originally Posted by slurugger
On several tabs there is the Transit column, wondering if that is the actual number of days from release to delivery - for trucks that have been delivered? I looked at various tabs but wasn't sure if Transit was just a calculation based on estimates or actuals? It might be helpful for folks to know after being released ( you pick), how many actual days it's taking to be delivered. It might give folks an idea how long it's taking to get to various states. I realize this isn't an exact indication as logistical factors go into the various shipments but would give us an idea. If this info is in there and I'm missing please point me in the right direction. thx @Phoenixfla
I don't have an exact answer regarding the transit date. I can only tell you my observations. The transit date is consistently the number of days between shipment and start ETA, BUT sometimes the ETA start is a few days after shipment + transit. I suspect in some instances there is an additional buffer built in.

Sometimes, after it is unloaded by train, it can travel on not just 1, but 2 car haulers to make it to its destination.

I haven't quite figured out why the start ETA could be after transit, but I suspect the above could be one factor.

So, as a rule of thumb, shipment date + transit + possible few day buffer = ETA start.

 
Reply
Old Aug 12, 2021 | 09:35 AM
  #740  
jackfordsd350's Avatar
jackfordsd350
Laughing Gas
5 Year Member
Photogenic
Liked
Loved
Joined: May 2016
Posts: 997
Likes: 262
From: Central New York
Severe shortage of F450s on the list. Even less with a.s. and other popular options. This could be a long wait but still hoping to get scheduled this week.
 
Reply
Old Aug 12, 2021 | 09:41 AM
  #741  
Brantel's Avatar
Brantel
More Turbo
Joined: Sep 2020
Posts: 508
Likes: 196
Today is the day for my truck! Hopefully the production date populates soon. I see several with sent to plant dates earlier than mine but no production date. Makes me nervous!
 
Reply
Old Aug 12, 2021 | 09:54 AM
  #742  
kshoop1958's Avatar
kshoop1958
Laughing Gas
5 Year Member
Liked
Loved
Community Favorite
Joined: Apr 2021
Posts: 988
Likes: 596
From: Middle TN
Originally Posted by Phoenixfla
All the data fields are populated directly from the Ford database. I have not seen one show delivered that wasn't actually delivered. I'll bet you $1 it's at your dealer.
Woohoo, the trackers now also show delivered! I'll try to get up there and get a picture!

This is redundant, but I also want to thank you for doing this spreadsheet. It really helped me keep my sanity!
 
Reply
Old Aug 12, 2021 | 09:56 AM
  #743  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Hi everyone,

I have repurposed some of the columns on the delivered tab to calculate a few items.

I've calculated the number of days between production and release and the number of days between release and shipment.

I also calculated the number of days the truck was actually in shipment.

Finally I compared the actual number of days in shipment versus the quoted Transit time. I've color coded these columns, which should be self-explanatory.

For the Actual Shipment vs Transit, green indicates it was delivered sooner than the expected transit days, and red indicates it exceeded the transit days (but was likely still delivered before the end ETA that Ford quotes as the ETA).

 
Reply
FTE Stories

Ford Trucks for Ford Truck Enthusiasts

story-0

This Hennessey Takes the Expedition Tremor's Off-Roading Capability to the Next Level

 Verdad Gallardo
story-1

Top 10 Fords at 2026 Carlisle Ford Nationals

 Joe Kucinski
story-2

3 Best / 3 Worst Parts of Modern Ford Ownership

 Brett Foote
story-3

10 Amazing Upgrades That Solve Common Ford Truck Owner Headaches

 Pouria Savadkouei
story-4

Every 2026 Ford Engine Explained

 Brett Foote
story-5

10 Ugly Ford Trucks That We Still Kinda Love

 Joe Kucinski
story-6

10 Things Every Truck Owner NEEDS (2026 Edition)

 Michael S. Palmer
story-7

Rezvani's Latest Post-Apocalyptic Monster Is a Ford F-150 Raptor Underneath

 Verdad Gallardo
story-8

Top 10 Most Expensive Ford Trucks Ever Sold on Bring a Trailer

 Joe Kucinski
story-9

2027 Ford Super Duty Buyer's Guide (Every Model, Engine, & Package)

 Brett Foote
Old Aug 12, 2021 | 10:03 AM
  #744  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Originally Posted by jackfordsd350
Severe shortage of F450s on the list. Even less with a.s. and other popular options. This could be a long wait but still hoping to get scheduled this week.
I think what you see on the tracker is just the take rate of F-450s

On the tracker - 25 of 245 are F-450s = 10.2%
​​​On Unscheduled list - 20 of 174 are F-450s = 11.5%

So not a big difference. The earlier weeks saw fewer F-450s, but they are scheduling them at a good pace now.
 
Reply
Old Aug 12, 2021 | 10:05 AM
  #745  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Originally Posted by Brantel
Today is the day for my truck! Hopefully the production date populates soon. I see several with sent to plant dates earlier than mine but no production date. Makes me nervous!
If it's being produced today, the trackers won't show that until tomorrow, and it may not be till the end of the day tomorrow, so don't worry if you don't see any action today.
 
Reply
Old Aug 12, 2021 | 11:38 AM
  #746  
slurugger's Avatar
slurugger
Mountain Pass
15 Year Member
Liked
Loved
Community Favorite
Joined: Jan 2009
Posts: 178
Likes: 65
Originally Posted by Brantel
Today is the day for my truck! Hopefully the production date populates soon.
Same here, hopefully everyone at the plant woke up on a good side of the bed and had their coffee!
 
Reply
Old Aug 12, 2021 | 07:14 PM
  #747  
KU4OJ's Avatar
KU4OJ
Fleet Mechanic
15 Year Member
Photogenic
Community Favorite
Top Answer: 1
Joined: Jul 2008
Posts: 1,937
Likes: 1,221
From: Southern Crescent
Today I got the email confirming my promotion form unscheduled to scheduled for the week of Sept 13.
Ford IS SCHEDULING XLT with the PTBA and 360 Cameras. (even on 2WD)
I entered my VIN and order code on the submission form but don't see it yet on the spreadsheet. I guess it takes a while.
127 days after the order I finally have a VIN.
Hang in there.
 
Reply
Old Aug 12, 2021 | 07:14 PM
  #748  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Welcome all the new users to the tracker. We have had 23 new signups in the last 3 hours.

If you have submitted your info for the tracker, please remember to fill out this one additional form if you know your build date.

Build Date Submission / Update

Thanks!
 
Reply
Old Aug 12, 2021 | 07:18 PM
  #749  
Phoenixfla's Avatar
Phoenixfla
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Originally Posted by KU4OJ
Today I got the email confirming my promotion form unscheduled to scheduled for the week of Sept 13.
Ford IS SCHEDULING XLT with the PTBA and 360 Cameras. (even on 2WD)
I entered my VIN and order code on the submission form but don't see it yet on the spreadsheet. I guess it takes a while.
127 days after the order I finally have a VIN.
Hang in there.
Yep, I see you in the queue. I have to add new submissions between updates so about every 2 hours a batch can be loaded. Yours should appear in about 8:30 EST, but won't pull data for another 90 minutes after that.

Congratulations and welcome!
 
Reply
Old Aug 12, 2021 | 09:49 PM
  #750  
chamdaddy's Avatar
chamdaddy
Tuned
Joined: Jun 2020
Posts: 405
Likes: 212
From: Texas
He finally found his way home.


 
Reply



All times are GMT -5. The time now is 06:24 PM.

story-0
This Hennessey Takes the Expedition Tremor's Off-Roading Capability to the Next Level

Slideshow: The VelociRaptor Expedition gains a lift, upgraded suspension, Brembo brakes, and trail-ready equipment while retaining the stock 440-horsepower EcoBoost V6.

By Verdad Gallardo | 2026-06-12 11:01:55


VIEW MORE
story-1
Top 10 Fords at 2026 Carlisle Ford Nationals

Slideshow: Top 10 Fords at 2026 Ford Nationals

By Joe Kucinski | 2026-06-09 11:10:08


VIEW MORE
story-2
3 Best / 3 Worst Parts of Modern Ford Ownership

Based on years of owning multiple modern Ford products.

By Brett Foote | 2026-06-09 10:53:36


VIEW MORE
story-3
10 Amazing Upgrades That Solve Common Ford Truck Owner Headaches

SPONSORED: From muddy boots to rain-soaked cargo, these upgrades address some of the most common frustrations Ford truck owners face every day.

By Pouria Savadkouei | 2026-06-08 18:50:34


VIEW MORE
story-4
Every 2026 Ford Engine Explained

Here's everything you need to know about every Ford engine available for the 2026 model year.

By Brett Foote | 2026-06-05 12:58:01


VIEW MORE
story-5
10 Ugly Ford Trucks That We Still Kinda Love

Slideshow: 10 ugly Ford trucks that we still kinda love.

By Joe Kucinski | 2026-06-03 09:51:16


VIEW MORE
story-6
10 Things Every Truck Owner NEEDS (2026 Edition)

Slideshow: the best gifts for dads & grads

By Michael S. Palmer | 2026-06-03 15:43:58


VIEW MORE
story-7
Rezvani's Latest Post-Apocalyptic Monster Is a Ford F-150 Raptor Underneath

Slideshow: Called the Fortress, the 850-horsepower pickup combines Raptor underpinnings with military-inspired features, survival equipment, and a starting price of $285,000.

By Verdad Gallardo | 2026-06-03 11:38:36


VIEW MORE
story-8
Top 10 Most Expensive Ford Trucks Ever Sold on Bring a Trailer

Slideshow: 10 most expensive Ford trucks ever sold on Bring a Trailer.

By Joe Kucinski | 2026-05-27 16:24:34


VIEW MORE
story-9
2027 Ford Super Duty Buyer's Guide (Every Model, Engine, & Package)

Here's everything that has changed for the latest model year.

By Brett Foote | 2026-05-27 16:17:28


VIEW MORE