1. Explaining spreadsheets with spreadsheets (short paper)
- Author
-
GrejucAlex, CunhaJácome, DanMihai, FedorinDanila, ErwigMartin, and Universidade do Minho
- Subjects
Soundness ,Science & Technology ,business.industry ,Computer science ,Programming language ,05 social sciences ,Short paper ,Software Understanding ,Ciências Naturais::Ciências da Computação e da Informação ,020207 software engineering ,Explanation Principles ,02 engineering and technology ,computer.software_genre ,Computer Graphics and Computer-Aided Design ,Work (electrical) ,020204 information systems ,0202 electrical engineering, electronic engineering, information engineering ,0501 psychology and cognitive sciences ,Software engineering ,business ,computer ,050107 human factors ,Software ,Engenharia e Tecnologia::Engenharia Eletrotécnica, Eletrónica e Informática ,Simple (philosophy) - Abstract
Based on the concept of explanation sheets, we present an approach to make spreadsheets easier to understand and thus easier to use and maintain. 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 small 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., This work is partially supported by the National Science Foundation under the grant CCF-1717300. Work financed by European Regional Development Fund through the Operational Programme for Competitiveness and Internationalization COMPETE 2020 Programme and by National Funds through the Portuguese funding agency FCT project POCI-01-0145-FEDER-016718 and NOVA LINCS UID/CEC/04516/2013, and by FLAD project 233/2014.
- Published
- 2018
- Full Text
- View/download PDF