Towards Systematic Spreadsheet Construction Processes

• Tipo: Artigo em Livro de Atas de Conferência Internacional
• Data: 2017

Autores

Mendes, J (Autor) Outra; Cunha, J (Autor) Outra; Duarte, F (Autor) Outra; Engels, G (Autor) Outra; Saraiva, J (Autor) Outra; Sauer, S (Autor) Outra

Ata de Conferência Internacional

Título: Proceedings of the 39th International Conference on Software Engineering, ICSE 2017, Buenos Aires, Argentina, May 20-28, 2017 - Companion Volume

Páginas: 356-358

39th IEEE/ACM International Conference on Software Engineering Companion, ICSE-C 2017

20 May 2017 through 28 May 2017

Indexação

ISI Web of Knowledge - 0 Citações

Scopus - 0 Citações

Outras Informações

ID Authenticus: P-00M-T5B

DOI: 10.1109/icse-c.2017.141

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

Idioma: Inglês

Tipo (Avaliação Docente): Científica

Nº de páginas: 3