https://twitter.com/arstechnica/status/1770515888434827579
I think if your fancy car can't be maintained with a spreadsheet, it's too fancy
Team Williams showing up with a 2009 Honda Accord and a 2012 Kia Soul
Have some people racing on the side in regular cars for a point of reference
Have a regular ass car do a qualifier run and list the best lap time for it.
I remember when I was a kid, spending Saturdays out in the garage with my dad. He taught me how to do basic maintenance and repairs that every vehicle owner should know with just a pivot table,
COUNTIFSand conditional formatting. Now the damn things are so complicated you need MySQL just to inflate the tyres!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.
"When you start tracking now hundreds of thousands of components through your organization moving around, an Excel spreadsheet is useless," Vowles told The Race. Because of the multiple states each part could be in—ordered, backordered, inspected, returned—humans are often left to work out the details. "And once you start putting that level of complexity in, which is where modern Formula 1 is, the Excel spreadsheet falls over, and humans fall over. And that's exactly where we are."
Does F1 not have access to database technology?
---
Edit
For some reason I started to wonder if HyperCard (for Macs) which came out 35+ years ago could even be used to make a database for the records that was simple to update and easy to understand.
Clearly the actual problem is insufficient excel mastery.
Excel is fine for warehousing, but it's not super easy to navigate without tons of way too complex macros and you can't have multiple edit sessions on one file.
I'd just use like a Postgres instance with something like Metabase for active tracking of part status with some basic CRUD scripts set up to buttons on dashboards for each car section or something.
Maybe a Wekan or something for active tracking of part production and general activity stuff.
I'm of the mind that if the thing you're doing is too large or complicated to use Excel, then it doesn't need doing.
Too many parts and systems in your car for excel to be navigable? Car needs fewer parts and systems.
Too many guys in your military to fit on an excel sheet? Your military needs to be smaller.
Excel has a limit of 1,048,576 rows while the army has "1,073,200 total uniformed personnel" according to Wikipedia, time to start decimating.
I'm sure you can just consolidate all the people called Mike into a single guy with the "Duplicate Entry" function.
Do you mean to tell me there's a way to post here other than using an excel script?
Williams has existed for like 50 years, I guarantee it's done this way because some old guy used to do it this way and just handed the Excel sheet down to the next person.
Williams was the worst team on the grid for quite a few years. They're still not very good, but they have at least one very good driver and James Vowles, who was the Chief Strategist at Mercedes, just took over the Team Principal role last season. He's done a lot to right the ship, and I imagine that fixing things like this were a pretty crucial part of it.
Only guess there is that maybe he thought an American driver would lead to American sponsors?
If it’s good enough to run our entire banking system for some reason…
Is that why it crashes with almost every new president?
tfw Access sucks so hard people would rather continue using Excel
Sounds like an organizational problem with your excel. Which is pretty typical.
