Embedding, evolution, and validation of model-driven spreadsheets

Jácome Cunha, João Paulo Fernandes, Jorge Mendes, João Saraiva

Research output: Contribution to journalArticle

12 Citations (Scopus)

Abstract

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.

Original languageEnglish
Article number6915751
Pages (from-to)241-263
Number of pages23
JournalIEEE Transactions on Software Engineering
Volume41
Issue number3
DOIs
Publication statusPublished - 1 Mar 2015

Keywords

  • ClassSheets
  • Embedding
  • Empirical Validation
  • Evolution
  • Models
  • Spreadsheets

Fingerprint Dive into the research topics of 'Embedding, evolution, and validation of model-driven spreadsheets'. Together they form a unique fingerprint.

Cite this