Validating the unit correctness of spreadsheet programs

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 physi...

Full description

Saved in:
Bibliographic Details
Published inProceedings. 26th International Conference on Software Engineering pp. 439 - 448
Main Authors Antoniu, T., Steckler, P.A., Krishnamurthi, S., Neuwirth, E., Felleisen, M.
Format Conference Proceeding
LanguageEnglish
Published IEEE 2004
Subjects
Debugging
Design engineering
Education
Postal services
Programming profession
Prototypes
Software engineering
Spreadsheet programs
Testing
Online AccessGet full text

Cover

More Information
Summary: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.
ISBN:9780769521633
0769521630
ISSN:0270-5257
1558-1225
DOI:10.1109/ICSE.2004.1317466