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: 969
Likes: 576
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: 969
Likes: 576
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

Top 10 Ford Truck Tragedies

 Joe Kucinski
story-1

AEV FXL Super Duty - the Super Duty Raptor Ford Doesn't Make

 Brett Foote
story-2

Lobo Vs Lobo: Proof the F-150 Lobo Should Be Even Lower!

 Michael S. Palmer
story-3

Ford's 2001 Explorer Sportsman Concept Looks For a New Home

 Verdad Gallardo
story-4

10 Best Ford Truck Engines We Miss the Most!

 Joe Kucinski
story-5

2026 Shelby F-150 Off-Road: Better Than a Raptor R?

 Brett Foote
story-6

2027 Super Duty Carhartt Package First Look: 12 Things You NEED to Know!

 Michael S. Palmer
story-7

10 Most Surprising 2026 Ford Truck Features!

 Joe Kucinski
story-8

Top 10 Ford Trucks Coming to Mecum Indy 2026

 Brett Foote
story-9

5 Best / 5 Worst Ford Truck Wheels of All Time

 Joe Kucinski
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 02:13 AM.

story-0
Top 10 Ford Truck Tragedies

Slideshow: Top 10 Ford truck tragedies.

By Joe Kucinski | 2026-05-18 19:34:33


VIEW MORE
story-1
AEV FXL Super Duty - the Super Duty Raptor Ford Doesn't Make

And it might be even better than that.

By Brett Foote | 2026-05-18 19:26:42


VIEW MORE
story-2
Lobo Vs Lobo: Proof the F-150 Lobo Should Be Even Lower!

Slideshow: Does lowering an F-150 Lobo RUIN the ride quality?

By Michael S. Palmer | 2026-05-18 19:20:37


VIEW MORE
story-3
Ford's 2001 Explorer Sportsman Concept Looks For a New Home

Slideshow: Ford's bizarre fishing-themed Explorer concept has resurfaced after spending decades largely forgotten.

By Verdad Gallardo | 2026-05-12 18:07:46


VIEW MORE
story-4
10 Best Ford Truck Engines We Miss the Most!

Slideshow: The 10 best Ford truck engines we miss the most.

By Joe Kucinski | 2026-05-12 13:09:47


VIEW MORE
story-5
2026 Shelby F-150 Off-Road: Better Than a Raptor R?

Slideshow: first look at the 810 hp 2026 Shelby F-150 Off-Road!

By Brett Foote | 2026-05-12 12:50:07


VIEW MORE
story-6
2027 Super Duty Carhartt Package First Look: 12 Things You NEED to Know!

Slideshow: Everything You Need to Know about the 2027 Super Duty Carhartt Package!

By Michael S. Palmer | 2026-05-07 17:51:06


VIEW MORE
story-7
10 Most Surprising 2026 Ford Truck Features!

Slideshow: 10 most surprising Ford truck options/features in 2026.

By Joe Kucinski | 2026-05-05 11:17:22


VIEW MORE
story-8
Top 10 Ford Trucks Coming to Mecum Indy 2026

Slideshow: Here are the top 10 Fords coming to Mecum Indy 2026.

By Brett Foote | 2026-05-04 13:49:49


VIEW MORE
story-9
5 Best / 5 Worst Ford Truck Wheels of All Time

Slideshow: The 5 best and 5 worst Ford truck wheels of all time

By Joe Kucinski | 2026-04-29 16:49:01


VIEW MORE