Eight of the Worst Spreadsheet Blunders

Spreadsheet typos and oversights can wind up costing your company millions. Here's a look at eight big mistakes, and tips on how to prevent them from happening at your company.

Fri, August 17, 2007CIO Spreadsheet errors can happen to the best of us. As a result, many public companies and government organizations are trying to wean themselves off their reliance on spreadsheets for complex and critical financial transactions.

Of course, to achieve such a goal, organizations need all the help they can get. Most businesses today rely on spreadsheets in some way. The multi-celled document is used heavily for finance and accounting, as well as supply chain, customer relationship and sales functions.

However, recent financial regulations, such as Sarbanes-Oxley requirements, have had a huge impact on how companies manage changes and controls in financial documents, such as spreadsheets. Because of their preponderance and the amount of digital fingertips that can touch these documents, spreadsheets have come under a lot of fire. In particular, companies lack the appropriate controls and repeatable processes to mitigate the risks.

This isn't about software defects within the applications, such as Microsoft Excel or OpenOffice. The problems associated with a spreadsheet ordinarily do not reside in the software program itself. It's those imperfect human beings who are using the applications: inputting data, copying and pasting numbers from row to row and column to column, and writing inaccurate formulae.

Research abounds on the prominence of spreadsheet errors. One project found that 80 percent of spreadsheets contain significant errors. "That means that of every five spreadsheets, at most one will give the correct results," writes Louise Pryor, an actuary and consultant who specializes in software risk management. (A PDF document by Pryor contains tips for managing and preventing spreadsheet problems.)

The European Spreadsheet Risks Interest Group (EuSpRIG), a consortium of academics, researchers and professionals who examine spreadsheet risks and develop methods for prevention, holds a conference each year to talk about the spreadsheet's inherent dangers to organizations. (Last July's get-together was titled "Enterprise Spreadsheet Management: A Necessary Evil?")

"Research has repeatedly shown that an alarming proportion of corporate spreadsheet models are not tested to the extent necessary to support directors' fiduciary, reporting and compliance obligations," says the EuSpRIG website.

"Uncontrolled and untested spreadsheet models therefore pose significant business risks. These risks include: lost revenue and profits; mispricing and poor decision making due to prevalent but undetected errors; fraud due to malicious tampering; and difficulties in demonstrating fiduciary and regulatory compliance.

"These risks are ignored due to a widespread failure to inventory (keep records of), test, document, backup, archive and control the legions of spreadsheets that support critical corporate infrastructure," says the site.


Loading...
Applications MarketSpace
Service Level Reporting and Communication
Service level reporting is the most visible output and often the most time-consuming activity in SLM. Learn more »
Lower IT Costs with Oracle Database 11g Release 2
Learn how upgrading to Oracle Database 11g Release 2 can transform your business, budgets, and service levels Learn more »
Managing Your SAP System
Learn how to more effectively manage your SAP system. Learn more »
 
SPONSORED LINKS
 

White Paper: 4 Customer Service Myths

White Paper: Improve Agility with Operational Responsiveness

Removing the Barriers to IT Governance: How On-Demand Software Changes the Game

Cloud Computing--Latest Buzzword or a Glimpse of the Future?

A Balanced Approach to an Application Development Platform

Adobe® LiveCycle®solutions for intuitive user experience

10 Ways Excel Drives More Value from Your SAP Investment

What's New in SOA Suite 11g?

Unleash the Power of Java with Oracle JRockit Real Time

SOA Best Practices and Design Patterns

Application Grid: Ideal Platform for IT Consolidation

Ready to virtualize tier one applications? Check your virtualization maturity.

Learn how to provide complete Business Service Management.

Increase ROI of Your Application Portfolio

See how AT&T can help protect your network.

Top Five CIO Challenges

Streamline IT Costs. Boost Performance with WAN Optimization.

Want to know how you can maximize employee productivity?

Build your 1st app FREE with Force.com

TDWI checklist helps define data readiness for analytics. Download report.

A new fleet of PCs with a total ROI in 10 months. Find your ROI.

eZine: A Roadmap to Reducing IT Complexity

Reduce risk, gain agility. See how Progress can help your business.

Virtualization Technology as a Business Solution

eZine: A Roadmap to Reducing IT Complexity

White Paper: Managed Security for a Not-So-Secure World

SharePoint - Unchecked growth of content is unsustainable.

Focus Under Pressure: Why IT Governance Becomes Mission-Critical in a Down Economy

Should Your Email Live In The Cloud? A Comparative Cost Analysis

Adobe® LiveCycle® solutions for business process automation

Architecting Business Intelligence Applications for Change: The Open Solution

Increase UPS efficiency without sacrificing protection.

Unlocking the Mainframe: Modernizing Legacy System to SOA

State of the Data Integration Market

Enhance Customer Loyalty through Higher Responsiveness

Achieving Business Agility with Application Grid

Seven Ways ITIL Can Help You in an Economic Downturn

Four steps to populate your CMDB.

"Enterprise-Proven" is the Prerequisite for Enterprise SaaS Portal Solutions

Join us at the US-Brazil IT-BPO Summit, on November 10th in New York.

Unified Communications: Thoughts, Strategies and Predictions. Join the discussion

Read the RSA report: Security for Business Innovation

Webcast: Looking to the Cloud for Email and Collaboration Services

64-page prescriptive guide to security, compliance, and IT operations.

Keep your IT expertise up to date. Join the Intel Premier IT Professionals.

A Clear View Toward Virtualization

Virtualization Technology as a Business Solution

The rules of infrastructure management just changed.

A Clear View Toward Virtualization

Interactive Q&A helps you discover key ways to maximize IT assets.

 
 
RESOURCE CENTER