2022 Tracking Spreadsheet
Laughing Gas
Joined: May 2016
Posts: 997
Likes: 262
From: Central New York
Thanks for the reply. Confirmed what I was thinking but good to hear the explanation.
Thanks again for the spreadsheet, keeps us from driving our friends and spouses crazy during the wait.
Thanks again for the spreadsheet, keeps us from driving our friends and spouses crazy during the wait.
5th Wheeling
Joined: Jul 2021
Posts: 44
Likes: 23
Finally here!
Got nervous because the trackers just changed today extending my delivery time another week; however just got an email from my dealer that it was just delivered to them tonight! Finally will be able to pick up on Friday. 2022 F250 King Ranch 7.3 gas. Ordered 4/9 - what a wait!
New User
Joined: Aug 2021
Posts: 13
Likes: 7
Users supply username vin and order number when they join.
They then have the option of adding a build date by separate form.
Some of the columns are created by deciphering the VIN, but most of the data is retrieved about every 2 hours from the Ford customer database, which is where the other one-off trackers pull their data from.
If you are familiar with the Mach E tracker, there is a Raw Data button on the bottom. This spreadsheet is based on the same data feed that you can see there. It's sent in JSON format.
They then have the option of adding a build date by separate form.
Some of the columns are created by deciphering the VIN, but most of the data is retrieved about every 2 hours from the Ford customer database, which is where the other one-off trackers pull their data from.
If you are familiar with the Mach E tracker, there is a Raw Data button on the bottom. This spreadsheet is based on the same data feed that you can see there. It's sent in JSON format.
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Have you considered including the city of the dealership on the spreadsheet? It could possibly help get a better understanding of shipping time frames, for example, I'm in El Paso, Texas and my shipping time does not compare to someone in Austin or San Antonio, Texas just because of the vast distance and different rail yards associated with cities in Texas. My delivery rail yard is in Albuquerque (I'm 90% certain the ramp code is CR4B) 4 hours away and in another state. I see other people getting their trucks delivered in Texas after mine was shipped and I always wonder what city in Texas they're in.
I had a few users concerned that someone could use the spreadsheet to identify an incoming truck and then try to buy it out from under the rightful buyer.
I therefore removed both those columns. I don't think I'd add back in the dealer name, but I could add back in the city. I dunno, anyone object to that?
I agree more data is better, but I try to balance privacy with data accessibility.
4wd High
Joined: Sep 2021
Posts: 9
Likes: 11
Back in the olden days, I had a column with the city of the Dealer (and before that the Dealer Name).
I had a few users concerned that someone could use the spreadsheet to identify an incoming truck and then try to buy it out from under the rightful buyer.
I therefore removed both those columns. I don't think I'd add back in the dealer name, but I could add back in the city. I dunno, anyone object to that?
I agree more data is better, but I try to balance privacy with data accessibility.
I had a few users concerned that someone could use the spreadsheet to identify an incoming truck and then try to buy it out from under the rightful buyer.
I therefore removed both those columns. I don't think I'd add back in the dealer name, but I could add back in the city. I dunno, anyone object to that?
I agree more data is better, but I try to balance privacy with data accessibility.
New User
Joined: Aug 2021
Posts: 13
Likes: 7
Back in the olden days, I had a column with the city of the Dealer (and before that the Dealer Name).
I had a few users concerned that someone could use the spreadsheet to identify an incoming truck and then try to buy it out from under the rightful buyer.
I therefore removed both those columns. I don't think I'd add back in the dealer name, but I could add back in the city. I dunno, anyone object to that?
I agree more data is better, but I try to balance privacy with data accessibility.
I had a few users concerned that someone could use the spreadsheet to identify an incoming truck and then try to buy it out from under the rightful buyer.
I therefore removed both those columns. I don't think I'd add back in the dealer name, but I could add back in the city. I dunno, anyone object to that?
I agree more data is better, but I try to balance privacy with data accessibility.
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Oh ok yeah that's understandable and I'm all for privacy without issues as well just thought I'd ask and see if it helped others like myself. I could see the benefit in large states that have many dealerships to chose from but like Shane60 mentioned, some cities only have 1 dealership. I thought because you signed and ordered a vehicle it was locked in to you only?
Would it happen? Unlikely. Could it happen? If an unethical buyer connected with an unethical dealer, it's possible.
Tuned
Joined: Jun 2010
Posts: 286
Likes: 31
From: Kilgore, Texas
Right now my F-450 is in the UP system heading toward Texas. Is there any way to check on the car's progress like you do with the CSX system. Checked with the dealer on the VVR and it shows it was received at Junction Point UP railroad Gatyard, Illinois on Oct 2. Car is BNSF300766
FTE Stories
Ford Trucks for Ford Truck Enthusiasts
AEV FXL Super Duty - the Super Duty Raptor Ford Doesn't Make
Brett Foote
Lobo Vs Lobo: Proof the F-150 Lobo Should Be Even Lower!
Michael S. Palmer
Ford's 2001 Explorer Sportsman Concept Looks For a New Home
Verdad Gallardo
10 Best Ford Truck Engines We Miss the Most!
Joe Kucinski
2026 Shelby F-150 Off-Road: Better Than a Raptor R?
Brett Foote
2027 Super Duty Carhartt Package First Look: 12 Things You NEED to Know!
Michael S. Palmer
10 Most Surprising 2026 Ford Truck Features!
Joe Kucinski
Top 10 Ford Trucks Coming to Mecum Indy 2026
Brett Foote
5 Best / 5 Worst Ford Truck Wheels of All Time
Joe Kucinski
New User
Joined: Aug 2021
Posts: 13
Likes: 7
Right now my F-450 is in the UP system heading toward Texas. Is there any way to check on the car's progress like you do with the CSX system. Checked with the dealer on the VVR and it shows it was received at Junction Point UP railroad Gatyard, Illinois on Oct 2. Car is BNSF300766
New User
Joined: Aug 2021
Posts: 13
Likes: 7
Since I've been doing this (not really that long) I've not encountered a buyer that had a truck sold out from under them, either a current order, or in the past. I think it would be extremely unlikely and would take a dealer that knowingly screws their 1st buyer for more $. The vast majority of dealers wouldn't think about doing this, but when I hear stories of people having dealers adding accessories during PDI without the buyer's knowledge I recognize there are some unscrupulous dealers around.
Would it happen? Unlikely. Could it happen? If an unethical buyer connected with an unethical dealer, it's possible.
Would it happen? Unlikely. Could it happen? If an unethical buyer connected with an unethical dealer, it's possible.
Tuned
Joined: Jun 2010
Posts: 286
Likes: 31
From: Kilgore, Texas
Laughing Gas
Joined: Aug 2004
Posts: 856
Likes: 270
From: SoCal
Dealer just called and the truck was delivered last night. It’s 10 -1/2 weeks from order to dealer lot. Spent the last two weeks at the railyard 30 miles away. I’ll post some pics later.
Thanks Phoenixfla!!
Thanks Phoenixfla!!
New User
Joined: Aug 2021
Posts: 14
Likes: 7
Since I've been doing this (not really that long) I've not encountered a buyer that had a truck sold out from under them, either a current order, or in the past. I think it would be extremely unlikely and would take a dealer that knowingly screws their 1st buyer for more $. The vast majority of dealers wouldn't think about doing this, but when I hear stories of people having dealers adding accessories during PDI without the buyer's knowledge I recognize there are some unscrupulous dealers around.
Would it happen? Unlikely. Could it happen? If an unethical buyer connected with an unethical dealer, it's possible.
Would it happen? Unlikely. Could it happen? If an unethical buyer connected with an unethical dealer, it's possible.