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

Fingerprint

Spreadsheets
Concretes
Industry
Specifications

Keywords

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

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
Mendes, Jorge ; Cunha, Jacome ; Duarte, Francisco ; Engels, Gregor ; Saraiva, Joao ; Sauer, Stefan. / Systematic spreadsheet construction processes. Proceedings - 2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017. Vol. 2017-October IEEE Computer Society, 2017. pp. 123-127
@inproceedings{77ece2ef35f04c48a8a1356d4aa5fde4,
title = "Systematic spreadsheet construction processes",
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.",
keywords = "construction process, model-driven engineering, situational method engineering, spreadsheet",
author = "Jorge Mendes and Jacome Cunha and Francisco Duarte and Gregor Engels and Joao Saraiva and Stefan Sauer",
note = "Sem PDF. RDF - European Regional Development Fund through the Operational Programme for Competitiveness and Internationalisation - COMPETE 2020 Programme (POCI-01-0145-FEDER-016718) FCT (UID/CEC/04516/2013; SFRH/BD/112651/2015) FCT/DAAD (441.00)",
year = "2017",
month = "11",
day = "9",
doi = "10.1109/VLHCC.2017.8103459",
language = "English",
volume = "2017-October",
pages = "123--127",
booktitle = "Proceedings - 2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017",
publisher = "IEEE Computer Society",

}

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, 8103459, IEEE Computer Society, pp. 123-127, 2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017, Raleigh, United States, 11/10/17. https://doi.org/10.1109/VLHCC.2017.8103459

Systematic spreadsheet construction processes. / Mendes, Jorge; Cunha, Jacome; Duarte, Francisco; Engels, Gregor; Saraiva, Joao; Sauer, Stefan.

Proceedings - 2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017. Vol. 2017-October IEEE Computer Society, 2017. p. 123-127 8103459.

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

TY - GEN

T1 - Systematic spreadsheet construction processes

AU - Mendes, Jorge

AU - Cunha, Jacome

AU - Duarte, Francisco

AU - Engels, Gregor

AU - Saraiva, Joao

AU - Sauer, Stefan

N1 - Sem PDF. RDF - European Regional Development Fund through the Operational Programme for Competitiveness and Internationalisation - COMPETE 2020 Programme (POCI-01-0145-FEDER-016718) FCT (UID/CEC/04516/2013; SFRH/BD/112651/2015) FCT/DAAD (441.00)

PY - 2017/11/9

Y1 - 2017/11/9

N2 - 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.

AB - 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.

KW - construction process

KW - model-driven engineering

KW - situational method engineering

KW - spreadsheet

UR - http://www.scopus.com/inward/record.url?scp=85040970690&partnerID=8YFLogxK

U2 - 10.1109/VLHCC.2017.8103459

DO - 10.1109/VLHCC.2017.8103459

M3 - Conference contribution

VL - 2017-October

SP - 123

EP - 127

BT - Proceedings - 2017 IEEE Symposium on Visual Languages and Human-Centric Computing, VL/HCC 2017

PB - IEEE Computer Society

ER -

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