@inproceedings{sarkar2018calculation, author = {Sarkar, Advait and Gordon, Andy and Peyton Jones, Simon and Toronto, Neil}, title = {Calculation View: multiple-representation editing in spreadsheets}, booktitle = {IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)}, year = {2018}, month = {October}, 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.}, publisher = {IEEE}, url = {http://approjects.co.za/?big=en-us/research/publication/calculation-view-multiple-representation-editing-in-spreadsheets/}, pages = {85-93}, }