• DocumentCode
    2030677
  • Title

    Using objects of measurement to detect spreadsheet errors

  • Author

    Coblenz, Michael J. ; Ko, Andrew J. ; Myers, Brad A.

  • Author_Institution
    Sch. of Comput. Sci., Carnegie Mellon Univ., Pittsburgh, PA, USA
  • fYear
    2005
  • fDate
    20-24 Sept. 2005
  • Firstpage
    314
  • Lastpage
    316
  • 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.
  • Keywords
    programming language semantics; spreadsheet programs; type theory; measurement objects; spreadsheet error detection; spreadsheet values; statically-typed spreadsheet language; Computer displays; Computer errors; Computer science; Concrete; Costs; Inspection; Measurement units; Object detection; USA Councils;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Visual Languages and Human-Centric Computing, 2005 IEEE Symposium on
  • Print_ISBN
    0-7695-2443-5
  • Type

    conf

  • DOI
    10.1109/VLHCC.2005.67
  • Filename
    1509526