OREGON STATE UNIVERSITY

You are here

Dimension Inference in Spreadsheets

TitleDimension Inference in Spreadsheets
Publication TypeConference Paper
Year of Publication2008
AuthorsChambers, C., and M. Erwig
Conference Name2008 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
Pagination123 - 130
Date Published09/2008
PublisherIEEE
Conference LocationHerrsching am Ammersee
ISBN Number978-1-4244-2528-0
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.

Notes

Best Paper Award

DOI10.1109/VLHCC.2008.4639072