loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
2005 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC'05)
Goal-Directed Debugging of Spreadsheets
Dallas, Texas
September 20-September 24
ISBN: 0-7695-2443-5
Robin Abraham, Oregon State University
Martin Erwig, Oregon State University
We present a semi-automatic debugger for spreadsheet systems that is specifically targeted at end-user programmers. Users can report expected values for cells that yield incorrect results. The system then generates change suggestions that could correct the error. Users can interactively explore, apply, refine, or reject these change suggestions. The computation of change suggestions is based on a formal inference system that propagates expected values backwards across formulas. The system is fully integrated into Microsoft Excel and can be used to automatically detect and correct various kinds of errors in spreadsheets. Test results show that the system works accurately and reliably.
Index Terms:
Spreadsheet, Debugging, Static Analysis, End-User Software Engineering
Citation:
Robin Abraham, Martin Erwig, "Goal-Directed Debugging of Spreadsheets," vlhcc, pp.37-44, 2005 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC'05), 2005
Usage of this product signifies your acceptance of the Terms of Use.