Embedding, Evolution, and Validation of Model-Driven Spreadsheets

• Type: Article in International Scientific Journal
• Date: 2015

Authors

Cunha, J (Author) Other; Joao Paulo Fernandes (Author) Other; Mendes, J (Author) Other; Saraiva, J (Author) Other

Journal

Title: IEEE Transactions on Software Engineering

Vol. 41

Pages: 241-263

ISSN: 0098-5589

Publisher: IEEE

Indexing

ISI Web of Knowledge - 10 Citations

Scopus - 14 Citations

Other information

Authenticus ID: P-00A-8VS

DOI: 10.1109/tse.2014.2361141

Abstract (EN): This paper proposes and validates a model-driven software engineering technique for spreadsheets. The technique that we envision builds on the embedding of spreadsheet models under a widely used spreadsheet system. This means that we enable the creation and evolution of spreadsheet models under a spreadsheet system. More precisely, we embed ClassSheets, a visual language with a syntax similar to the one offered by common spreadsheets, that was created with the aim of specifying spreadsheets. Our embedding allows models and their conforming instances to be developed under the same environment. In practice, this convenient environment enhances evolution steps at the model level while the corresponding instance is automatically co-evolved. Finally, we have designed and conducted an empirical study with human users in order to assess our technique in production environments. The results of this study are promising and suggest that productivity gains are realizable under our model-driven spreadsheet development setting.

Language: English

Type (Professor's evaluation): Scientific

No. of pages: 23