loading...
Header and Unit Inference for Spreadsheets Through Spatial Analyses
Rome, Italy September 26-September 29
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/VLHCC.2004.292004 IEEE Symposium on Visual Languag ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Robin Abraham, Oregon State University, Corvallis, OR
Martin Erwig, Oregon State University, Corvallis, OR
This paper describes the design and implementation of a unit and header inference system for spreadsheets. The system is based on a formal model of units that we have described in previous work. Since the unit inference depends on information about headers in a spreadsheet, a realistic unit inference system requires a method for automatically determining headers. The present paper describes (1) several spatial-analysis algorithms for header inference, (2) a framework that facilitates the integration of different algorithms, and (3) the implementation of the system.
The combined header and unit inference system is fully integrated into Microsoft Excel and can be used to automatically identify various kinds of errors in spreadsheets. Test results show that the system works accurately and reliably.
Citation:
Robin Abraham, Martin Erwig, "Header and Unit Inference for Spreadsheets Through Spatial Analyses," vlhcc, pp.165-172, 2004 IEEE Symposium on Visual Languages - Human Centric Computing (VLHCC'04), 2004
Usage of this product signifies your acceptance of the Terms of Use.