GPCE 2018
Mon 5 - Tue 6 November 2018 Boston, Massachusetts, United States
co-located with SPLASH 2018
Tue 6 Nov 2018 14:45 - 15:00 at Studio 2 - V Chair(s): Tijs van der Storm

Spreadsheets constitute a severe software risk for many companies and institutions. The impact of existing design, testing, and debugging tools on spreadsheet quality is limited, since spreadsheets often change owners and have to be used by people who haven’t created the spreadsheet. This flux often contributes to a lack of understanding, which is a major reason for mistakes in the use and maintenance of spreadsheets.

Based on the concept of explanation sheets, we present an approach to make spreadsheets easier to understand and thus easier to use and maintain. Explanation sheets are an instance of the idea of explanation languages. We identify the notion of explanation soundness and show that explanation sheets which conform to simple rules of formula coverage provide sound explanations. We also present a practical evaluation of explanation sheets based on samples drawn from widely used spreadsheet corpora and based on a user study.

In addition to supporting spreadsheet understanding and maintenance, our work on explanation sheets has also uncovered several general principles of explanation languages that can help guide the design of explanations for other programming and domain-specific languages.

Tue 6 Nov

gpce-2018
13:30 - 15:00: GPCE 2018 - V at Studio 2
Chair(s): Tijs van der StormCWI & University of Groningen
gpce-201813:30 - 14:30
Talk
gpce-201814:30 - 14:45
Talk
L. Thomas van BinsbergenRoyal Holloway University of London
gpce-201814:45 - 15:00
Talk
Jácome CunhaUniversity of Minho, Mihai DanOregon State University, Martin ErwigOregon State University, Danila FedorinOregon State University, Alex GrejucOregon State University