Carnegie Mellon University
Browse

Using Objects of Measurement to Detect Spreadsheet Errors

Download (203.83 kB)
journal contribution
posted on 2005-01-01, 00:00 authored by Michael Coblenz, Andrew Ko, Brad Myers

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.

History

Date

2005-01-01

Usage metrics

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC