- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Formula 1 chief appalled to find team using Excel to manage 20,000 car parts
Posted on 3/21/24 at 3:50 am
Posted on 3/21/24 at 3:50 am
quote:
There's a new boss at a storied 47-year-old Formula 1 team, and he's eager to shake things up. He's been saying that the team is far behind its competition in technology and coordination. And Excel is a big part of it.
Starting in early 2023, Williams team principal James Vowles and chief technical officer Pat Fry started reworking the F1 team's systems for designing and building its car. It would be painful, but the pain would keep the team from falling even further behind. As they started figuring out new processes and systems, they encountered what they considered a core issue: Microsoft Excel.
The Williams car build workbook, with roughly 20,000 individual parts, was "a joke," Vowles recently told The Race. "Impossible to navigate and impossible to update." This colossal Excel file lacked information on how much each of those parts cost and the time it took to produce them, along with whether the parts were already on order. Prioritizing one car section over another, from manufacture through inspection, was impossible, Vowles suggested.
LINK
This post was edited on 3/21/24 at 7:51 am
Posted on 3/21/24 at 4:52 am to rickgrimes
Apparently they need a class on how to use Excel.
Posted on 3/21/24 at 5:01 am to Chrome
quote:
Apparently they need a class on how to use Excel.
I’m not saying this is the best software to use for an inventory program but 20,000 rows in Excel isn’t that much data and what he was complaining about could have been easily fixed.
Posted on 3/21/24 at 5:08 am to rickgrimes
quote:
"When you start tracking now hundreds of thousands of components through your organization moving around, an Excel spreadsheet is useless,"
Spoken like someone who doesn't know how to use vlookup.
Posted on 3/21/24 at 5:17 am to Chrome
It sounds like this is the case.
Posted on 3/21/24 at 5:22 am to rickgrimes
Williams should worry more about designing something that isn’t a shite box than someone using excel.
Posted on 3/21/24 at 5:48 am to ApisMellifera
Vlookup can't look left, xlookup is where it's at.
Sumifs by category would work fine for QOH totals so who knows how they have this thing setup!
It is kind of shocking with the money that these teams have that they're using Excel for anything other than financial data.
Sumifs by category would work fine for QOH totals so who knows how they have this thing setup!
It is kind of shocking with the money that these teams have that they're using Excel for anything other than financial data.
Posted on 3/21/24 at 5:50 am to rickgrimes
My man doesn't t know how to work Excel. I think the average Joe would have their mind blown if they realized how much accounting goes on in Excel. PowerBI is slowly taking more of the work share, but I still export out of accounting programs every day to use the data in Excel.
Posted on 3/21/24 at 5:59 am to rickgrimes
I bet this guy doesn’t know how to use the three sea shells either.
Posted on 3/21/24 at 6:04 am to SB9513
quote:
Vlookup can't look left, xlookup is where it's at.
Posted on 3/21/24 at 6:07 am to KLSU
When properly built it is a better database platform than their consumer database platform.
Posted on 3/21/24 at 6:26 am to KLSU
quote:
but 20,000 rows in Excel
quote:
"When you start tracking now hundreds of thousands of components..."
Also, Microsoft Office = bloatware
Posted on 3/21/24 at 6:26 am to rickgrimes
Doesn’t sound like excels fault, sounds like they don’t know how to properly build workbooks
Posted on 3/21/24 at 6:29 am to KLSU
quote:
I’m not saying this is the best software to use for an inventory program but 20,000 rows in Excel isn’t that much data and what he was complaining about could have been easily fixed.
This.
A dedicated dbms is probably a better solution but someone with decent excel skills could easily make this work with just a little effort and some lookup functions and drop downs.
Posted on 3/21/24 at 6:45 am to Chrome
quote:
Apparently they need a class on how to use Excel.
This. Blaming it on Excel is dumb. It’s not excel that’s the problem and it could do what they need. It’s whoever designed and maintains the workbook.
That said, there are much better products out there for inventory management, and since it’s F1, I’m sure they don’t mind spending the money.
Posted on 3/21/24 at 6:47 am to rickgrimes
I'm not a data guy but excel for 20,000 items doesn't seem that bad if used properly
Posted on 3/21/24 at 6:48 am to rickgrimes
they need to learn how to use excel
Posted on 3/21/24 at 6:49 am to SB9513
quote:
xlookup is where it's at.
yup.
Posted on 3/21/24 at 6:51 am to rickgrimes
Typical C-suite mindset. Oh let’s drop Excel and pay $200,000 a year to hire a software company to build the same tool for us that uses databases in the backend.
Posted on 3/21/24 at 7:01 am to GreatLakesTiger24
quote:
I'm not a data guy but excel for 20,000 items doesn't seem that bad if used properly
It's not. Excel maxes out at around 250,000 rows I believe. Depending on the data set, that could either be plenty or not nearly enough. Problem is if you max out the the sheet, and have it full of a bunch of vlookups and functions, it can take forever to load and save.
Popular
Back to top
Follow TigerDroppings for LSU Football News