@inproceedings{3f2a7757d77d4beca9ae83cb905c5151,
title = "Calculation View: multiple-representation editing in spreadsheets",
abstract = "Spreadsheet errors are ubiquitous and costly, an unfortunate combination that is well-reported. A large class of these errors can be attributed to the inability to clearly see the underlying computational structure, as well as poor support for abstraction (encapsulation, re-use, etc). In this paper we propose a novel solution: a multiple-representation spreadsheet containing additional representations that allow abstract operations, without altering the conventional grid representation or its formula syntax. Through a user study, we demonstrate that the use of multiple representations can significantly improve user performance when performing spreadsheet authoring and debugging tasks. We close with a discussion of design implications and outline future directions for this line of inquiry.",
keywords = "computational linguistics, human computer interaction, program debugging, spreadsheet programs, calculation view, multiple-representation editing, spreadsheet errors, abstraction, multiple-representation spreadsheet, abstract operations, multiple representations, user performance, debugging tasks, computational structure, spreadsheet authoring, Syntactics, Task analysis, Visualization, Semantics, Debugging, Vocabulary, Layout",
author = "Advait Sarkar and Gordon, {Andrew D.} and Jones, {Simon Peyton} and Neil Toronto",
year = "2018",
month = oct,
day = "25",
doi = "10.1109/VLHCC.2018.8506584",
language = "English",
isbn = "978-1-5386-4236-8",
publisher = "Institute of Electrical and Electronics Engineers (IEEE)",
pages = "85--93",
booktitle = "2018 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)",
address = "United States",
}