loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
26th International Conference on Software Engineering (ICSE'04)
Validating the Unit Correctness of Spreadsheet Programs
Edinburgh, Scotland, United Kingdom
May 23-May 28
ISBN: 0-7695-2163-0
Tudor Antoniu, Blunk Microsystems
Paul A. Steckler, Northrop Grumman IT/FNMOC
Shriram Krishnamurthi, Brown University
Erich Neuwirth, Universität Wien
Matthias Felleisen, Northeastern University

Financial companies, engineering firms and even scientists create increasingly larger spreadsheets and spreadsheet programs. The creators of large spreadsheets make errors and must track them down. One common class of errors concerns unit errors, because spreadsheets often employ formulas with physical or monetary units.

In this paper, we describe XeLda, our tool for unit checking Excel spreadsheets. The tool highlights cells if their formulas process values with incorrect units and if derived units clash with unit annotations. In addition, it draws arrows to the sources of the formulas for debugging. The tool is sensitive to many of the intricacies of Excel spreadsheets including tables, matrices, and even circular references. Using XeLda, we have detected errors in some published scientific spreadsheets.

Citation:
Tudor Antoniu, Paul A. Steckler, Shriram Krishnamurthi, Erich Neuwirth, Matthias Felleisen, "Validating the Unit Correctness of Spreadsheet Programs," icse, pp.439-448, 26th International Conference on Software Engineering (ICSE'04), 2004
Usage of this product signifies your acceptance of the Terms of Use.