2022 Tracking Spreadsheet
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
I am an IT Pro and worked extensively with FoMoCo several years ago on a consulting contract. Something to keep in mind is Ford uses IBM Mainframe computer systems (since the 1960's) and these are batch (not real time) systems. This might explain the wonky/ad-hoc updates and the various systems being out of sync. I got an email from Ford that my truck is built and ready for shipment, but, my line on the spreadsheet is blank, web portal, and Mach-E tracker all show different status. Things will sync up as the batch processing jobs are run in sequence.
Sometimes data will update in the morning, revert back to the old data mid-day and then update again in the evening and hold that data.
Then Sundays are a mess. During the week, I may get an error here and there, but Sundays I'll get 10-20, which results in the blank lines in the spreadsheet.
Freshman User
Joined: Jul 2021
Posts: 46
Likes: 55
Thank you for that explanation!!!
Sometimes data will update in the morning, revert back to the old data mid-day and then update again in the evening and hold that data.
Then Sundays are a mess. During the week, I may get an error here and there, but Sundays I'll get 10-20, which results in the blank lines in the spreadsheet.
Sometimes data will update in the morning, revert back to the old data mid-day and then update again in the evening and hold that data.
Then Sundays are a mess. During the week, I may get an error here and there, but Sundays I'll get 10-20, which results in the blank lines in the spreadsheet.
That said, syncing Mainframe on-prem systems @ FoMoCo with mostly cloud based web, email, and messaging applications is cat herding on a good day.....especially on weekends when backups, ERP, batch financials, etc are all running. Some of the young'uns are used to instant, real-time everything.......manufacturing at FoMoCo scale requires big-iron IT to run and it can be somewhat inflexible at times.
Cargo Master
Joined: Jul 2021
Posts: 2,969
Likes: 2,408
From: Ridgway, CO
Thank you for that explanation!!!
Sometimes data will update in the morning, revert back to the old data mid-day and then update again in the evening and hold that data.
Then Sundays are a mess. During the week, I may get an error here and there, but Sundays I'll get 10-20, which results in the blank lines in the spreadsheet.
Sometimes data will update in the morning, revert back to the old data mid-day and then update again in the evening and hold that data.
Then Sundays are a mess. During the week, I may get an error here and there, but Sundays I'll get 10-20, which results in the blank lines in the spreadsheet.
Tuned
Joined: Jul 2021
Posts: 482
Likes: 248
From: Northwest FL
Phoenixfla on the tracker spreadsheet, would it be possible to add an answer key to the far right where the other notes are so the various options listed in columns V through AH are spelled out in plain language? A couple of the abbreviations are not intuitively obvious.
New User
Joined: Jul 2021
Posts: 13
Likes: 19
Senior User
Joined: Feb 2021
Posts: 158
Likes: 79
how many trucks have you deleted? can you give us numbers of delivered, vs in production, vs scheduled, vs ordered?
Junior User
Joined: Apr 2021
Posts: 55
Likes: 28
I believe he just moved them from the main tab to the "Delivered" tab on the spreadsheet. The tabs are on the bottom left.
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Phoenixfla on the tracker spreadsheet, would it be possible to add an answer key to the far right where the other notes are so the various options listed in columns V through AH are spelled out in plain language? A couple of the abbreviations are not intuitively obvious.
Senior User
Joined: Sep 2016
Posts: 161
Likes: 92
From: NH
My truck just joined about 30 trucks at the bottom of the spreadsheet with no data. Most of those trucks have a user supplied build week of 8/23. I’m hoping this is some sort of data issue that occurs before trucks are sent to plant, and I got moved up from the week of 9/6 to 8/23. Purely speculation and hope. I’m prepared to be disappointed. It would be especially convenient since I just made the deal to trade-in my 2016 F250 on 8/25, after I return from my last camping trip. I was planning to be at least a month without a truck, so a couple weeks early would be great.
New User
Joined: Aug 2021
Posts: 8
Likes: 3
Hopefully someone here has some insight, as my dealer is less than willing to help me. My truck was completed on 7/28, but has still not shipped. I've checked the JCT PALS portal for shipping info, and it's pretty bare too. Any idea why it's not shipped? All trucks built the same time period as mine on the tracker have been shipped, with several already delivered. Something seem odd, and I cant help but have this feeling that it was scrapped or in an accident or something.
Thread Starter
|
Fleet Mechanic
Joined: Jul 2006
Posts: 1,513
Likes: 1,252
From: Florida
Hopefully someone here has some insight, as my dealer is less than willing to help me. My truck was completed on 7/28, but has still not shipped. I've checked the JCT PALS portal for shipping info, and it's pretty bare too. Any idea why it's not shipped? All trucks built the same time period as mine on the tracker have been shipped, with several already delivered. Something seem odd, and I cant help but have this feeling that it was scrapped or in an accident or something.
New User
Joined: Jul 2021
Posts: 19
Likes: 7
Hopefully someone here has some insight, as my dealer is less than willing to help me. My truck was completed on 7/28, but has still not shipped. I've checked the JCT PALS portal for shipping info, and it's pretty bare too. Any idea why it's not shipped? All trucks built the same time period as mine on the tracker have been shipped, with several already delivered. Something seem odd, and I cant help but have this feeling that it was scrapped or in an accident or something.