Systematic Evolution of Model-Based Spreadsheet Applications Public Deposited

http://ir.library.oregonstate.edu/concern/defaults/3r074w31n

This is the author's manuscript version. The published article is copyrighted by Elsevier and can be found at:  http://www.journals.elsevier.com/journal-of-visual-languages-and-computing/.

Descriptions

Attribute NameValues
Creator
Abstract or Summary
  • Using spreadsheets is the preferred method to calculate, display or store anything that fits into a table-like structure. They are often used by end users to create applications, although they have one critical drawback—spreadsheets are very error-prone. Recent research has developed methods to reduce this error-proneness by introducing a new way of object-oriented modeling of spreadsheets before using them. These spreadsheet models, termed ClassSheets, are used to generate concrete spreadsheets on the instance level. By this approach sources of errors are reduced and spreadsheet applications become easier to understand. As usual for almost every other application, requirements on spreadsheets change due to the changing environment. Thus, the problem of evolution of spreadsheets arises. The update and evolution of spreadsheets is the uttermost source of errors that may have severe impact. In this article, we will introduce a model-based approach to spreadsheet evolution by propagating updates on spreadsheet models (i.e. ClassSheets) to spreadsheets. To this end, update commands for the ClassSheet layer are automatically transformed to those for the spreadsheet layer. We describe spreadsheet model update propagation using a formal framework and present an integrated tool suite that allows the easy creation and safe update of spreadsheet models. The presented approach greatly contributes to the problem of software evolution and maintenance for spreadsheets and thus avoids many errors that might have severe impacts.
Resource Type
DOI
Date Available
Date Issued
Citation
  • Luckey, M., Erwig, M., & Engels, G. (2012). Systematic evolution of model-based spreadsheet applications. JOURNAL OF VISUAL LANGUAGES AND COMPUTING, 23(5), 267-286. doi: 10.1016/j.jvlc.2011.11.009
Series
Keyword
Rights Statement
Publisher
Peer Reviewed
Language
Replaces
Additional Information
  • description.provenance : Made available in DSpace on 2013-01-28T19:07:55Z (GMT). No. of bitstreams: 1 ErwigMartinEECSSystematicEvolutionModel.pdf: 1487244 bytes, checksum: b87f2aaa0e296a4adee2af10b1d602d3 (MD5) Previous issue date: 2012-10
  • description.provenance : Approved for entry into archive by Deanne Bruner(deanne.bruner@oregonstate.edu) on 2013-01-28T19:07:55Z (GMT) No. of bitstreams: 1 ErwigMartinEECSSystematicEvolutionModel.pdf: 1487244 bytes, checksum: b87f2aaa0e296a4adee2af10b1d602d3 (MD5)
  • description.provenance : Submitted by Deanne Bruner (deanne.bruner@oregonstate.edu) on 2013-01-24T18:57:44Z No. of bitstreams: 1 ErwigMartinEECSSystematicEvolutionModel.pdf: 1487244 bytes, checksum: b87f2aaa0e296a4adee2af10b1d602d3 (MD5)

Relationships

In Administrative Set:
Last modified: 07/18/2017

Downloadable Content

Download PDF
Citations:

EndNote | Zotero | Mendeley

Items