Spreadsheet Engineering

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

Autores

Cunha, J (Autor) Outra; Joao Paulo Fernandes (Autor) Outra; Mendes, J (Autor) Outra; Saraiva, J (Autor) Outra

Ata de Conferência Internacional

Título: Central European Functional Programming School, CEFP 2013

Páginas: 246-299

5th Central European Functional Programming School (CEFP)

Babes-Bolyai University, Faculty of Mathematics and Informatics, Cluj-Napoca, ROMANIA, JUL 08-20, 2013

Indexação

ISI Web of Knowledge - 4 Citações

Scopus - 6 Citações

Outras Informações

ID Authenticus: P-00A-9AW

DOI: 10.1007/978-3-319-15940-9_6

Abstract (EN): These tutorial notes present a methodology for spreadsheet engineering. First, we present data mining and database techniques to reason about spreadsheet data. These techniques are used to compute relationships between spreadsheet elements (cells/columns/rows), which are later used to infer a model defining the business logic of the spreadsheet. Such a model of a spreadsheet data is a visual domain specific language that we embed in a well-known spreadsheet system. The embedded model is the building block to define techniques for model-driven spreadsheet development, where advanced techniques are used to guarantee the model-instance synchronization. In this model-driven environment, any user data update has to follow the model-instance conformance relation, thus, guiding spreadsheet users to introduce correct data. Data refinement techniques are used to synchronize models and instances after users update/evolve the model. These notes briefly describe our model-driven spreadsheet environment, the MDSheet environment, that implements the presented methodology. To evaluate both proposed techniques and the MDSheet tool, we have conducted, in laboratory sessions, an empirical study with the summer school participants. The results of this study are presented in these notes.

Idioma: Inglês

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

Nº de páginas: 54