Sidebar: Oops! Many spreadsheets have errors
Audits find errors in 49 out of 54 spreadsheets
Computerworld - Washington-based Fannie Mae made a $1.2 billion accounting error last year because of what it called "honest mistakes made in a spreadsheet" used in the implementation of a new accounting standard. Toronto-based TransAlta Corp. took a $24 million charge last year after a bidding snafu caused by a cut-and-paste error in an Excel spreadsheet.
These are spine-chilling mistakes, but research indicates that many company spreadsheets have errors. Anecdotal evidence suggests that 20% to 40% of spreadsheets have errors, but recent audits of 54 spreadsheets found that 49 (or 91%) had errors, according to research by Raymond R. Panko, a professor at the University of Hawaii.
Either way, the amateur programmers who set up and use spreadsheet models are making a lot of mistakes, experts agree, in part because of a lack of training in model development and testing.
The mistakes range from mechanical errors (such as pointing to the wrong cell when entering a formula) to logic errors (such as entering the wrong formula) when setting up the spreadsheet, Panko says in a research paper. "Developers are overconfident, and policies are lax," he adds.
"Most casual enterprise users perceive data as movable from cell to cell with little unforeseen consequences," says Ed Chen, IT director at broadcaster KQED in San Francisco. "They need to be made aware of the nature of the data they are dealing with and what might happen to it when they manipulate it."
Microsoft provides a basic auditing tool in Excel, but the high risk of spreadsheet errors has spawned a tiny industry of spreadsheet auditors, add-in auditing tools and researchers. (Just type "spreadsheet errors" or "spreadsheet audit" into a Web search engine to find these resources.)
Longtime database consultant Shaku Atre cautions, "I have seen people using spreadsheets for anything and everything under the sun -- and many times they use them wrongly. Provide good training."
Read more about BI and Analytics in Computerworld's BI and Analytics Topic Center.


- Excel 2010 Cheat Sheet
- Register for this Computerworld Insider Cheat Sheet and gain access to hundreds of premium content articles, guides, product reviews and more.
- Switching Schedulers - Not As Complicated As You Think
- Changing or consolidating job schedulers may seem daunting. However, the benefits of switching to enterprise workload automation outweigh the risks. Read how BMC...
- Capture-Enabled Business Process Management
- Organizations today must deal with a vast amount of incoming information from many different sources. Efficient, automated business processes are critical to managing...
- Using Case Management to Empower Employees and transform Customer Service
- This Kofax paper shows how successful customer service organizations have transformed customer service by empowering their employees. We will see how Dynamic Case...
- Case Study: Audi-Volkswagen Improves Procurement Control
- Audi-Volkswagen required a user-friendly, easy-to-use Business Process Management system that did not require programming skills or high levels of technical expertise in-house. This...
- AIIM Market Intelligence: The paper-free office, dream or reality?
- In this Aiim Market Intelligence report, produced in association with Kofax, we look at the success of paper-elimination projects, where and why paper...
- Live Webcast
How to Reduce Complexity and Automate Your Partners for Efficient E-Business: - Date: Tuesday, June 5, 2012, 2:00 PM EDT
Whether your B2B complexity is caused by multiple technologies due to M&A, business or application specific... - Live Webcast
Data Privacy and Protection in Production Environments: New Research from Ponemon Institute - Date: Wednesday, June 13, 2012, 1:00 PM EDT / 10:00 AM PDT
In a recent study conducted by Ponemon Institute, fifty-five percent of respondents... - Live Webcast
A Geek's Guide to Presenting to Business People - Live Webcast: Wednesday, June 20th at 1:00 PM EDT
Join this live webinar with Paul Glen, author of Leading Geeks, to learn how to... - BMC Control-M - Single Point of Control Demo
- With BMC Control-M, you schedule and manage everything - down to the very last platform and application - from one simple interface. It's...
- BMC Control-M - Single Point of Control Demo
- With BMC Control-M, you schedule and manage everything - down to the very last platform and application - from one simple interface. It's...
- Sun Chemical Customer Success Story
- Sun Chemical, the world's largest producer of printing inks and pigments, quadrupled its complex batch environment with zero extra headcount using BMC Control-M's...
- Service-Enabling CICS Applications: Best Practices
- This informative webcast provides an informed, thorough look into CICS service-enablement options and how they can affect your environment. You'll learn how to...
- Teaching Legacy Application Elephants How to Dance
- This four-minute video podcast shows how you can create services to continuously reuse enterprise applications, however and whenever needed, while leaving legacy logic...