F1 team's failures blamed on Excel 'joke'
F1 team's failures blamed on Excel 'joke'
Everyone who uses a computer for work is familiar with Microsoft Excel and Excel formulas. However, few would have expected Formula 1 to be burdened by those same formulas.
A struggling F1 team has blamed its recent failures on the track on an unworkable Excel sheet which was used to help source parts when building and designing the car.
READ MORE: F1 team forced to contend with Australian Grand Prix ban
Williams team principal James Vowles was a major part of building this year's FW46, but revealed how last year's FW45 was designed from a list of parts on an Excel sheet, as well as using modified existing parts rather than creating new ones.
Additionally, some of the parts were still metal rather than carbon, making the FW45 heavier than it should have been.
One of the biggest problems Vowles encountered was the list of around 20,000 components in Microsoft Excel, which proved to be an extremely inefficient way of designing an F1 car.
“The Excel list was a joke. Impossible to navigate and impossible to update," Vowles told the Race.
READ MORE: EXCLUSIVE: Newey 'one hour' from forming all-champion F1 line up
“Take a front wing. A front wing is about 400 different bits. And when you say I would like one front wing, what you need to kick off is the metallic bits and the carbon bits that make up that single front wing.
“You need to go into the system, and they need to be ordered. Is a front wing more important than a front wishbone in that circumstance? When do they go through, when is the inspection?
“When you start tracking now hundreds of 1000s of components through your organisation moving around, an Excel spreadsheet is useless.
“You need to know where each one of those independent components are, how long it will take before it's complete, how long it will take before it goes to inspection. If there's been any problems with inspections, whether it has to go back again.
“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.
“There is more structure and system in our processes now. But they are nowhere near good enough. Nowhere near.”
READ MORE: Verstappen Mercedes F1 move 'close to done deal'
(SUM:F1) Microsoft Excel in Formula 1
Williams are not the only team who have been limited by their use of Microsoft Excel in F1.
In 2017, Renault infrastructure manager Mark Everest explained to Ars Technica that the F1 team had been using a 77,000-line spreadsheet to track their car design ahead of the new season.
"It was a mix of data exports from the old ERP [enterprise resource planning] system, some transformations, some manual work. It was pretty much out of date as soon as it was created," Everest admitted.
That proved to be an unmanageable approach, and forced the team to move to a more user-friendly cloud-based approach when tracking components, but like many frustrated office employees around the world, teams are still using Microsoft products to carry out day-to-day duties.
"Mostly it's Windows, for server and client," Everest continued. "We use Office 365 for collaboration and e-mail in the cloud, Sharepoint Online, and we're rolling out OneDrive to some users as a replacement for mapped drives.
"It makes it much easier to share data between Enstone, Viry-Chatillon, from the track, or even when people are at home."
So the next time you get annoyed at an Excel formula not working for you, just console yourself with the fact you don't have to use that formula to design an F1 car.
READ MORE: FIA announce huge F1 Saudi Arabian GP investigation result
Related
Change your timezone:
Latest News
F1 News Today: Hamilton hints Newey Ferrari move as Verstappen takes swipe at F1 rival
- 49 minutes ago
Newey Red Bull EXIT date revealed as F1 star confirmed at new team - GPFans F1 Recap
- Yesterday 23:57
Verstappen takes F1 swipe at Hamilton and rivals with ruthless remark
- Yesterday 22:57
Marko defends Ricciardo in 'unbelievable' idiot claim
- Yesterday 21:57
Hamilton hints at sensational Newey arrival at Ferrari
- Yesterday 20:57
Suspended Red Bull employee 'grilled' as Horner saga given potential END DATE
- Yesterday 19:57
Related news
F1 champion claims team may WRITE OFF Chinese GP sprint race
Schumacher fires scary message at F1 team boss as worst fears CONFIRMED
F1 team hire former Man Utd and Chelsea supremo
F1 team boss makes SHOCKING chassis revelation
F1 Standings
Drivers
- Oliver Bearman
- Charles Leclerc
- Carlos Sainz
- Lando Norris
- Oscar Piastri
- Pierre Gasly
- Esteban Ocon
- Sergio Pérez
- Max Verstappen
- Alexander Albon
- Logan Sargeant
- Lewis Hamilton
- George Russell
- Nico Hülkenberg
- Kevin Magnussen
- Fernando Alonso
- Lance Stroll
- Valtteri Bottas
- Zhou Guanyu
- Daniel Ricciardo
- Yuki Tsunoda
Races
- Gulf Air Grand Prix of Bahrain 2024
- Saudi Arabian Grand Prix 2024
- Grand Prix of Australia 2024
- MSC Cruises Grand Prix of Japan 2024
- Grand Prix of China 2024
- Miami Grand Prix 2024
- Gran Premio dell'Emilia Romagna 2024
- Grand Prix of Monaco 2024
- Grand Prix du Canada 2024
- Gran Premio de España 2024
- Grand Prix of Austria 2024
- Grand Prix of Great Britain 2024
- Grand Prix of Hungary 2024
- Grand Prix of Belgium 2024
- Heineken Dutch Grand Prix 2024
- Grand Prix of Italy 2024
- Grand Prix of Azerbaijan 2024
- Grand Prix of Singapore 2024
- Grand Prix of the United States 2024
- Gran Premio de la Ciudad de Mexico 2024
- Grande Prêmio de São Paulo 2024
- Heineken Silver Las Vegas Grand Prix 2024
- Qatar Grand Prix 2024
- Grand Prix of Abu Dhabi 2024
About GPFans
GPFans is a multi-platform, multi-language brand dedicated to Formula One coverage. We bring you all the ins and outs of the sport, 24/7, everything from up-to-the-minute news and features to the latest viral stories and clips.We believe that a new generation of exciting, outspoken drivers will make F1 more popular than ever before, and we want to give our users access to as much of their heroes as possible, on and off the track. From Lewis Hamilton to Max Verstappen, Daniel Ricciardo to Sebastian Vettel, we provide in-depth analysis of every every Grand Prix in the season, from Australia to Abu Dhabi.
With Formula One under the new ownership of Liberty Media, how the sport is being covered is evolving, and GPFans will look to be at the heart of this progression into new media, as one of the fastest-growing sites covering the king of motorsports.
Follow us on your favorite social media channel
Corporate & Media
Innovatieweg 20C7007 CD, Doetinchem, Netherlands
+31645516860