90% of spreadsheets have at least one major error: Study

Share post:

A recent study has brought to light a startling statistic: 90% of spreadsheets containing more than 150 rows have at least one significant error. This finding underscores the inherent risks in the widespread use of spreadsheets, a tool integral to numerous business operations worldwide.

The very flexibility that has made spreadsheets a cornerstone in various industries is also a contributing factor to these errors. Despite advancements like the integration of Python scripting in Excel, human error remains the primary culprit behind spreadsheet-related issues.

Occasionally, these errors have led to high-profile incidents. For instance, the Police Service of Northern Ireland suffered a massive data leak due to a spreadsheet error, compromising the personal details of 10,000 officers. In Wales, a spreadsheet mistake significantly disrupted the recruitment process for trainee anaesthetists, mistakenly classifying all candidates as “unappointable.” Financial blunders include Crypto.com erroneously transferring $10.5 million instead of $100 to a customer and an Icelandic bank undervaluing its shares by millions due to a spreadsheet error.

The lack of published examples from the US or Canada doesn’t mean such errors are non-existent in these regions. In fact, for every major spreadsheet error that makes the news, countless others occur daily in various organizations.

According to an article from The Conversation, these widespread errors often stem from a lack of standardization in spreadsheet formatting and structure. This issue, combined with the prevalent practice of manual data entry, significantly increases the likelihood of mistakes.

The study suggests that it might be time for organizations to adopt more standardized practices in spreadsheet usage. Improving training for users and fostering a culture that encourages critical thinking in spreadsheet creation and maintenance could be key steps in mitigating these risks.

This situation brings to mind a famous line from Spiderman’s Uncle Ben: “With great power comes great responsibility.” As spreadsheets continue to be powerful tools for data management and analysis, the responsibility to use them accurately and effectively becomes increasingly important.

Sources include: The Conversation

Featured Tech Jobs

SUBSCRIBE NOW

Related articles

OpenAI claims New York Times manipulated ChatGPT “fabricate data”

OpenAI has challenged the New York Times' copyright lawsuit, asserting the newspaper manipulated ChatGPT to fabricate evidence. The...

Wendy’s leverages digital tech to test “surge pricing”

Wendy's is set to experiment with Uber-like surge pricing, a concept referred to as "dynamic pricing," starting in...

Meta is gathering data on Quest virtual reality users

Meta's latest policy update reveals plans to start collecting "anonymized" data from its Quest headset users, intensifying concerns...

Apple pulls the plug on autonomous electric vehicle

Apple has decided to cancel its electric car project, a venture it had been exploring for over a...

Become a member

New, Relevant Tech Stories. Our article selection is done by industry professionals. Our writers summarize them to give you the key takeaways