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: 2017 IEEE SYMPOSIUM ON VISUAL LANGUAGES AND HUMAN-CENTRIC COMPUTING (VL/HCC)

Páginas: 123-127

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

Raleigh, NC, OCT 11-14, 2017

Indexação

ISI Web of Knowledge - 1 Citação

Scopus - 1 Citação

Outras Informações

ID Authenticus: 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.

Idioma: Inglês

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

Nº de páginas: 5