Spreadsheets are growing like weeds, but they may be a liability in the Sarbanes-Oxley era.
Computerworld - In the beginning, there was VisiCalc, the first killer app for the PC. Lotus 1-2-3 subsequently took over, before yielding the throne to Microsoft Corp.'s Excel. Today, spreadsheets are so easy to use and ubiquitous that they've sprouted like weeds throughout most companies. And they often hold important financial data.
But what if Mary's sales spreadsheet differs from Tom's and has faulty data or a modeling error? What if Tom hoards his spreadsheet data -- it's a form of power, after all -- and won't let go? How do you get the data from dozens of far-flung spreadsheets into a companywide planning or budgeting system that meets the latest accounting standards?
Various studies report that 47% to 64% of companies use stand-alone spreadsheets for planning and budgeting, for example. But critics say spreadsheets -- invented as a personal productivity tool -- aren't well suited to collaboration, data quality or regulatory compliance. "Excel is a tool of information mavericks," says Eleanor Taylor, manager of business intelligence strategy at software vendor SAS Institute Inc. in Cary, N.C.
"Besides being extremely unwieldy for processes involving large volumes of data and multiple users, spreadsheets often contain substantial, material errors, according to academic research," wrote Paul Hamerman, a Forrester Research Inc. analyst, in a report last year.
Companies are just starting to look at the problems caused by spreadsheet proliferation, says Gartner Inc. analyst Michael Silver. "Some enterprises are addressing it, but most aren't," he says.
No one is suggesting that the spreadsheet is going away anytime soon or that it's a top-of-mind IT issue. "The subject is certainly of interest and has potential for improvement, but in the scheme of things, it's not high on the list of priorities," says Joe Iannello, CIO at watchmaker Movado Group Inc. in Paramus, N.J.
What's the Problem?
Questioning the desirability of spreadsheets, after their widespread acceptance over the past two decades, is almost like questioning mom and apple pie. But for a modern corporation looking for consolidated planning and financial reporting, spreadsheets pose challenges not dreamed of when they first began popping up on PCs across the land.
Here are three of the more significant spreadsheet issues that companies have to address:
Decentralization. Mentor Graphics Corp. in Wilsonville, Ore., had a central 25MB Excel spreadsheet and 1,200 budget spreadsheets across the enterprise, one for every cost center. But having numerous spreadsheets makes it difficult to collect important data. "Spreadsheets are great analysis tools, but at some point you start using them as a planning system, and that's where Excel starts breaking down," says Jan-Willem Beldman, Mentor's
- Best iPhone, iPad Business Apps for 2014
- 14 Tech Conventions You Should Attend in 2014
- 10 Desktop Apps to Power Your Windows PC
- How to Add New Job Skills Without Going Back to School
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- The value of smarter oil and gas fields With global energy requirements continuing to rise, the exploration, development and production of new oil and gas resources are shifting to increasingly challenging...
- Smarter Environmental Analytics Solutions: Offshore Oil and Gas Installations Example This IBM Redbooks® Solution Guide describes a solution for implementing smarter environmental monitoring and analytics for oil and gas industries. The solution implements...
- Piecing Together the Business Intelligence Puzzle Business intelligence (BI) technology collects and analyzes company data, delivering relevant information to corporate decision-makers in an effort to produce favorable outcomes.
- Harness IT -- An Introduction to Business Intelligence Solutions Learn the key selection criteria required to provide your organization with the capability to address structured data, unstructured data and mobile demands so...
- Live Webcast Increasing the Value of Your Reports and Dashboards Learn how incorporating other analytical capabilities such as predictive modeling and visualization can increase the value of your reports and dashboards by providing...
- The Software-Defined Data Center: Is your ADC ready? Data center transformation is accelerating beyond virtualization to next-generation cloud architectures and software-defined data centers, bringing new challenges for application performance, scalability and...
- Application Acceleration: Optimize the End-User Experience Watch this on-demand webcast and learn how you can optimize your web content, accelerate performance across any device and browser combination, and offload... All Business Intelligence/Analytics White Papers | Webcasts