Towards 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

Abstract

Spreadsheets are used in professional business contexts to make decisions based on collected data. Usually, these spreadsheets are developed by end users (e.g. accountants) in an ad-hoc way. The effect of this practice is that the business logic of a concrete spreadsheet is not explicit to them. Thus, its correctness is 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 combining pre-defined functional spreadsheet services with typed interfaces. This allows for a consistent construction of a spreadsheet by 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 from the automotive industry.

Original languageEnglish
Title of host publicationProceedings - 2017 IEEE/ACM 39th International Conference on Software Engineering Companion, ICSE-C 2017
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages356-358
Number of pages3
ISBN (Electronic)978-1-5386-1589-8
DOIs
Publication statusPublished - 30 Jun 2017
Event39th IEEE/ACM International Conference on Software Engineering Companion, ICSE-C 2017 - Buenos Aires, Argentina
Duration: 20 May 201728 May 2017

Conference

Conference39th IEEE/ACM International Conference on Software Engineering Companion, ICSE-C 2017
CountryArgentina
CityBuenos Aires
Period20/05/1728/05/17

Keywords

  • Construction process
  • Model-driven engineering
  • Situational method engineering
  • Spreadsheet

Fingerprint Dive into the research topics of 'Towards 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). Towards systematic spreadsheet construction processes. In Proceedings - 2017 IEEE/ACM 39th International Conference on Software Engineering Companion, ICSE-C 2017 (pp. 356-358). [7965357] Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/ICSE-C.2017.141