Systematic Spreadsheet Construction Processes

• Type: Article in International Conference Proceedings Book
• Date: 2017

Authors

Mendes, J (Author) Other; Cunha, J (Author) Other; Duarte, F (Author) Other; Engels, G (Author) Other; Saraiva, J (Author) Other; Sauer, S (Author) Other

Conference proceedings International

Title: 2017 IEEE SYMPOSIUM ON VISUAL LANGUAGES AND HUMAN-CENTRIC COMPUTING (VL/HCC)

Pages: 123-127

IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)

Raleigh, NC, OCT 11-14, 2017

Indexing

ISI Web of Knowledge - 1 Citation

Scopus - 1 Citation

Other information

Authenticus ID: P-00N-7NH

DOI: 10.1109/vlhcc.2017.8103459

Abstract (EN): 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.

Language: English

Type (Professor's evaluation): Scientific

No. of pages: 5