2022 Tracking Spreadsheet
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Been working on the spreadsheet all night trying to add some things, did not go too well.
The transit number has always been problematic. I'll get it fixed tomorrow.
I'll ask for patience from everyone.
The transit number has always been problematic. I'll get it fixed tomorrow.
I'll ask for patience from everyone.
Fleet Mechanic
Joined: Jan 2018
Posts: 1,579
Likes: 636
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
The transit number is the average number of days from the ship date to the eta start date. Basically the number of days between KTP and your dealer.
The problem with the data is it comes through in an "hour" format so anything over 24 days shows as 0. I'll work on it more tomorrow, but the transit date is relative unimportant since it usually calculates to about the eta start. Maybe I'll eliminate that column.
More importantly - I've found a way to identify trucks with certain options like adaptive steering. I'll have to use the codes from the order guide. For example, the 3 digit code for adaptive steering is 60A. I won't add too many options, but I should be able to add some tomorrow, plus bed length and paint color.
What other options should we have a column for? Probably a max of 10 or so.
The problem with the data is it comes through in an "hour" format so anything over 24 days shows as 0. I'll work on it more tomorrow, but the transit date is relative unimportant since it usually calculates to about the eta start. Maybe I'll eliminate that column.
More importantly - I've found a way to identify trucks with certain options like adaptive steering. I'll have to use the codes from the order guide. For example, the 3 digit code for adaptive steering is 60A. I won't add too many options, but I should be able to add some tomorrow, plus bed length and paint color.
What other options should we have a column for? Probably a max of 10 or so.
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Senior User
Joined: Sep 2016
Posts: 161
Likes: 92
From: NH
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
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
I've made some pretty major changes.
Added vehicle color, a section to identify options and moved charts to it's own tab.
Need to take a break and mow the lawn now.
I'll add long bed vs short bed later. What other options should we chart?
Let me know if you see errors, misspellings, etc.
Oh - and Sundays kick back errors. If there are trucks at the bottom with no info, don't worry. I think they perform updates or something on their side on Sundays, because it's the day I get individual errors returned.
Added vehicle color, a section to identify options and moved charts to it's own tab.
Need to take a break and mow the lawn now.
I'll add long bed vs short bed later. What other options should we chart?
Let me know if you see errors, misspellings, etc.
Oh - and Sundays kick back errors. If there are trucks at the bottom with no info, don't worry. I think they perform updates or something on their side on Sundays, because it's the day I get individual errors returned.
New User
Joined: Jun 2021
Posts: 16
Likes: 12
I've made some pretty major changes.
Added vehicle color, a section to identify options and moved charts to it's own tab.
Need to take a break and mow the lawn now.
I'll add long bed vs short bed later. What other options should we chart?
Let me know if you see errors, misspellings, etc.
Oh - and Sundays kick back errors. If there are trucks at the bottom with no info, don't worry. I think they perform updates or something on their side on Sundays, because it's the day I get individual errors returned.
Added vehicle color, a section to identify options and moved charts to it's own tab.
Need to take a break and mow the lawn now.
I'll add long bed vs short bed later. What other options should we chart?
Let me know if you see errors, misspellings, etc.
Oh - and Sundays kick back errors. If there are trucks at the bottom with no info, don't worry. I think they perform updates or something on their side on Sundays, because it's the day I get individual errors returned.
Tuned
Joined: Jun 2020
Posts: 405
Likes: 212
From: Texas
In addition to the 53R, you might include 53Q which is the "F-250 Trailer Tow High Capacity w/Ultimate Trailer Tow Camera
System......." since the UTT portion has been suspect to commodity holds. Thanks again for your hard work.
System......." since the UTT portion has been suspect to commodity holds. Thanks again for your hard work.
Cross-Country
Joined: Jun 2021
Posts: 55
Likes: 74
From: Central TX
My dealer gave me the train car number from the VVR and I can track its progress using the instructions in this thread:
https://blueovalforums.com/forums/in...-instructions/
https://blueovalforums.com/forums/in...-instructions/
