DocumentCode :
3027379
Title :
Dimension inference in spreadsheets
Author :
Chambers, Chris ; Erwig, Martin
Author_Institution :
Oregon State Univ., Eugene, OH
fYear :
2008
fDate :
15-19 Sept. 2008
Firstpage :
123
Lastpage :
130
Abstract :
We present a reasoning system for inferring dimension information in spreadsheets. This system can be used to check the consistency of spreadsheet formulas and can be employed to detect errors in spreadsheets. We have prototypically implemented the system as an add-in to Excel. In an evaluation of this implementation we were able to detect dimension errors in almost 50% of the investigated spreadsheets, which shows (i) that the system works reliably in practice and (ii) that dimension information can be well exploited to uncover errors in spreadsheets.
Keywords :
inference mechanisms; spreadsheet programs; Excel; dimension information inference; reasoning system; spreadsheet formulas; Automatic testing; Automation; Computer languages; Concrete; Feedback; Measurement units; Prototypes; Software testing; System testing; Usability;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Visual Languages and Human-Centric Computing, 2008. VL/HCC 2008. IEEE Symposium on
Conference_Location :
Herrsching am Ammersee
ISSN :
1943-6092
Print_ISBN :
978-1-4244-2528-0
Electronic_ISBN :
1943-6092
Type :
conf
DOI :
10.1109/VLHCC.2008.4639072
Filename :
4639072
Link To Document :
بازگشت