Using Objects of Measurement to Detect Spreadsheet Errors

Authors:
Michael J. Coblenz;Andrew J. Ko;Brad A. Myers
Affiliations:
Carnegie Mellon University;Carnegie Mellon University;Carnegie Mellon University
Venue:
VLHCC '05 Proceedings of the 2005 IEEE Symposium on Visual Languages and Human-Centric Computing
Year:
2005

Citing 0
Cited 6

Inferring templates from spreadsheets

Proceedings of the 28th international conference on Software engineering
Type inference for spreadsheets

Proceedings of the 8th ACM SIGPLAN international conference on Principles and practice of declarative programming
Topes: reusable abstractions for validating data

Proceedings of the 30th international conference on Software engineering
Automatic detection of dimension errors in spreadsheets

Journal of Visual Languages and Computing
Reasoning about spreadsheets with labels and dimensions

Journal of Visual Languages and Computing
The state of the art in end-user software engineering

ACM Computing Surveys (CSUR)

Quantified Score

Hi-index	0.02

Visualization

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.