@conference {DBLP:conf/cefp/notes, title = {Spreadsheet Engineering}, booktitle = {CEFP - Central European Functional Programming School}, year = {2014}, month = {October}, address = {Oxford, UK}, abstract = {
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). These relations are then used to infer a model dening the business logic of the spreadsheet. Such a model of a spreadsheet data is a visual domain specic language that we embed in a well-known spreadsheet system. The embedded model is the building block to dene techniques for modeldriven spreadsheet development, where advanced techniques are used to guarantee the model-instance synchronization. In this model-driven environment, any user data update as to follow the the model-instance conformance relation, thus, guiding spreadsheet users to introduce correct data. Data renement techniques are used to synchronize models and instances after users update/evolve the model. These notes brie y 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.
}, attachments = {https://haslab.uminho.pt/sites/default/files/jacome/files/dsl13_notes.pdf}, author = {J{\'a}come Cunha and Jo{\~a}o Paulo Fernandes and Jo{\~a}o Alexandre Saraiva} }