New approach to fixing spreadsheet errors could save billions
May 24, 2007Computer scientists at Oregon State University have created a new, much simpler approach to fixing errors in spreadsheets, a system that is easy to use and might help businesses around the world reduce mistakes and save billions of dollars.
The advances - which allow a non-specialist to identify and fix a problem by selecting from a short list of change suggestions – were announced today at the International Conference on Software Engineering in Minneapolis, Minn. The new system, called "GoalDebug," is being licensed to a spinoff company in Oregon.
Spreadsheets, a standard bookkeeping and accounting tool used by businesses to track everything from payroll to accounts receivable, are one of the most common of all computer software programs. In the U.S. it has been estimated that 11 million people create about 100 million spreadsheets a year, which in turn might be managed by up to 60 million users. But they are notoriously prone to errors, experts say.
"Most users of spreadsheets are overconfident, they believe that the data is correct," said Martin Erwig, an associate professor of computer science in the OSU College of Engineering. "But it has been observed that up to 90 percent of the spreadsheets being used have non-trivial errors in them. In fact, one auditor has said he never inspected a single spreadsheet during his entire career that was completely accurate."
Sometimes the result is a paycheck delayed or a few dollars misplaced. But often the costs or financial misrepresentations are far more serious, and companies have lost millions or billions of dollars, Erwig said, occasionally drawing notice and ridicule in the national press. The overall problem for business and industry is sufficiently large that OSU's work has already drawn the attention of some large financial institutions.
Part of the problem, Erwig said, is that spreadsheet use and development is so common that it is frequently being done by people with very limited training or interest in computer software programming. These "end users" of computer software don't have the background to investigate codes, programs or formulas, they just want the program to work, and often erroneously assume that it does.
"There are dozens of places an error can be made," Erwig said. "A person can click their mouse in the wrong spot, a simple mechanical error. They could use a plus instead of a minus, add a row at the end of a data area instead of in the middle, and get a completely different result. And these errors can be awfully difficult to spot, especially with large spreadsheets that have thousands of cells."
What the new OSU systems do is try to identify the ways that humans commonly make mistakes and then suggest what the correct approach might have been. For instance, if someone sees a figure in a spreadsheet that seems suspicious or is clearly incorrect, they can plug in the correct number, and the OSU system can suggest several programming mistakes that might have created the error - which the user can then sort through and use to identify the problem. A study performed by Robin Abraham, a recent OSU doctoral graduate, has shown that in 80 percent of the cases, the needed change is among the top five suggestions produced by the system, and in 72 percent of the cases it is among the top two suggestions.
"With this approach, people still have ultimate control over the spreadsheet programs," Erwig said. "What we do is give them a prioritized list of where the problem most likely is. They can literally start at the top of the list, see if that's what went wrong, and if not, move down to the second option on the list."
OSU's GoalDebug system, which stands for "Goal Directed Debugging of Spreadsheets," gives end users a chance to explore, apply, refine, or reject suggested changes. This much simpler and systematic approach allows people with comparatively little training in computer programming to identify and repair errors, Erwig said, by looking at a short list of possible problems instead of combing through hundreds or thousands of cells.
Software engineers spend 70-80 percent of their time testing and debugging programs, a recent study concluded - and even for these professionals, finding and fixing errors took an average of 17 hours.
"Spreadsheet debugging problems are huge," Erwig said. "We believe there will be a significant demand for these products, a large market."
Source: Oregon State University
-
Mom, dad and kids undergo novel genome analyses for medical risks in new study
Sep 15, 2011 |
5 / 5 (2) |
0
-
Tech-savvy put explosion of data to work
Nov 22, 2010 |
2.7 / 5 (3) |
0
-
As Master Data Management Matures, Its Availability Improves
Mar 31, 2007 |
4 / 5 (4) |
0
-
Management of TB cases falls short of international standards
1 hour ago |
not rated yet |
0
-
Entire genome of extinct human decoded from fossil
Feb 07, 2012 |
4.7 / 5 (53) |
36
-
Engineers build first sub-10-nm carbon nanotube transistor
Feb 01, 2012 |
4.9 / 5 (29) |
30
-
Something old, something new: Evolution and the structural divergence of duplicate genes
Jan 31, 2012 |
4.6 / 5 (7) |
1
-
The hidden nanoworld of ice crystals: Revealing the dynamic behavior of quasi-liquid layers
Jan 30, 2012 |
5 / 5 (3) |
1
-
Stock market network reveals investor clustering
Jan 27, 2012 |
3.9 / 5 (23) |
8
-
Of microchemistry and molecules: Electronic microfluidic device synthesizes biocompatible probes
Jan 26, 2012 |
5 / 5 (1) |
0
-
Synergistic relations between computer science and technology.
Feb 06, 2012
-
how do iphone gloves work?
Feb 05, 2012
-
iPhone battery over time
Jan 30, 2012
-
Best alternate Tablet to an iPad for writing math or physics equations?
Jan 26, 2012
-
Sending SMS to a website
Jan 20, 2012
-
Need help with my technical fest!
Jan 19, 2012
- More from Physics Forums - Computing & Technology
More news stories
Lenovo 3Q profit up by half, warns of disk supply
(AP) -- Lenovo Group Ltd., the world's second biggest personal computer maker, said Thursday that quarterly profit grew by more than half but warned hard drive costs would remain high amid a global shortage.
14 minutes ago |
not rated yet |
0
Facebook discloses details on bonuses
Facebook's top executives, including CEO Mark Zuckerberg, are eligible for twice-a-year bonuses of up to 45 percent of their base salaries and other earnings, according to a Wednesday regulatory filing.
43 minutes ago |
1 / 5 (1) |
0
Windows 8 preview set for February 29
Microsoft on Wednesday revealed plans to unveil a test version of its latest Windows computer operating software later this month.
14 hours ago |
3.8 / 5 (5) |
6
Darpa's Legged Squad Support System (LS3) to lighten troops' load
Todays dismounted warfighter can be saddled with more than 100 pounds of gear, resulting in physical strain, fatigue and degraded performance. Reducing the load on dismounted warfighters has become a ...
20 hours ago |
4.9 / 5 (7) |
12
Groupon fails to turn profit as revenue grows
Daily deals site Groupon on Wednesday issued its first earnings report as a publicly traded company, saying it failed to turn a profit despite revenue nearly tripling from a year earlier.
12 hours ago |
not rated yet |
0
Amazing skin gives sharks a push
Shark skin has long been known to improve the fish's swimming performance by reducing drag, but now George Lauder and Johannes Oeffner from Harvard University show that in addition, the skin generates thrust, giving the fish ...
Fruit flies drawn to the sweet smell of youth
Aging takes its toll on sex appeal and now an international team of researchers led by Baylor College of Medicine and the University of Michigan find that in fruit flies, at least, it even diminishes the come-hither ...
Life in Antarctic lake? It's everywhere else
If scientists find microbes in a frigid lake two miles beneath the thick ice of Antarctica, it will illustrate once again that somehow life finds a way to survive in the strangest and harshest places.
New study shows high cost of defensive medicine
Vanderbilt University Medical Center researchers estimate that U.S. orthopaedic surgeons create approximately $2 billion per year in unnecessary health care costs associated with orthopaedic care due to the practice of defensive ...
Continental mosquito with 'vector' potential found breeding in UK after 60 year absence
A species of mosquito has been discovered breeding in the UK that has not been seen in the country since 1945. Populations of the mosquito, found across mainland Europe and known only by its Latin name Culex modestus, were r ...
Presdisposition to common heart disease 'passed on from father to son'
A common heart disease which kills thousands each year may be passed genetically from father to son, according to a study led by the University of Leicester.