Using objects of measurement to detect spreadsheet errors
Coblenz, M.J.
Ko, A.J.
Myers, B.A.
Sch. of Comput. Sci., Carnegie Mellon Univ., Pittsburgh, PA, USA;
This paper appears in: Visual Languages and Human-Centric Computing, 2005 IEEE Symposium on
Publication Date: 20-24 Sept. 2005
On page(s): 314- 316
ISBN: 0-7695-2443-5
INSPEC Accession Number: 8748233
Digital Object Identifier: 10.1109/VLHCC.2005.67
Current Version Published: 2005-10-17
Abstract
There are many common spreadsheet errors that traditional spreadsheet systems do not help users find. This paper presents a statically-typed spreadsheet language that adds additional information about the objects that the spreadsheet values represent. By annotating values with both units and labels, users denote both the system of measurement in which the values are expressed as well as the properties of the objects to which the values refer. This information is used during computation to detect some invalid computations and allow users to identify properties of the resulting values.
Index
Terms
Available to subscribers and IEEE members.
References
Available to subscribers and IEEE members.
Citing Documents
Available to subscribers and IEEE members.
Cart
