Systematic spreadsheet construction processes

Jorge Mendes, Jacome Cunha, Francisco Duarte, Gregor Engels, Joao Saraiva, Stefan Sauer

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

Spreadsheets are used in professional business contexts to make decisions based on collected data. Usually, these spreadsheets are developed by end users in an ad-hoc way. Thus, the business logic of a concrete spreadsheet is not explicit to end users, making its correctness hard to assess and users have to trust. We present an approach where structure and computational behavior of a spreadsheet are specified by a model with a process-like notation based on pre-defined functional spreadsheet services with typed interfaces. This enables a consistent construction process of a spreadsheet that comprises defining its structure and computational behavior as well as filling it with data and executing the defined computational behavior. Thus, concrete spreadsheets are equipped with a specification of their construction process. This supports their understanding and correct usage, even in case of legacy spreadsheets. The approach has been developed in cooperation with an industrial partner.

Original languageEnglish
Title of host publicationProceedings - 2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017
PublisherIEEE Computer Society
Pages123-127
Number of pages5
Volume2017-October
ISBN (Electronic)9781538604434
DOIs
Publication statusPublished - 9 Nov 2017
Event2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017 - Raleigh, United States
Duration: 11 Oct 201714 Oct 2017

Conference

Conference2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017
CountryUnited States
CityRaleigh
Period11/10/1714/10/17

Keywords

  • construction process
  • model-driven engineering
  • situational method engineering
  • spreadsheet

Fingerprint Dive into the research topics of 'Systematic spreadsheet construction processes'. Together they form a unique fingerprint.

  • Cite this

    Mendes, J., Cunha, J., Duarte, F., Engels, G., Saraiva, J., & Sauer, S. (2017). Systematic spreadsheet construction processes. In Proceedings - 2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017 (Vol. 2017-October, pp. 123-127). [8103459] IEEE Computer Society. https://doi.org/10.1109/VLHCC.2017.8103459