Adding Spreadsheets to the MDE Toolkit

  • Mārtiņš Francis
  • Dimitrios S. Kolovos
  • Nicholas Matragkas
  • Richard F. Paige
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8107)


Spreadsheets are widely used to support software development activities. They have been used to collect requirements and software defects, to capture traceability information between requirements and test cases, and in general, to fill in gaps that are not covered satisfactorily by more specialised tools. Despite their widespread use, spreadsheets have received little attention from researchers in the field of Model Driven Engineering. In this paper, we argue for the usefulness of model management support for querying and modifying spreadsheets, we identify the conceptual gap between contemporary model management languages and spreadsheets, and we propose an approach for bridging it. We present a prototype that builds atop the Epsilon and Google Drive platforms and we evaluate the proposed approach through a case study that involves validating and transforming software requirements captured using spreadsheets.


Eclipse Modelling Framework Model Drive Engineer Model Refactoring Model Management Operation Student Worksheet 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Firesmith, D.: Common requirements problems, their negative consequences, and industry best practices to help solve them. Journal of Object Technology 6, 17–33 (2007)CrossRefGoogle Scholar
  2. 2.
    Steinberg, D., Budinsky, F., Paternostro, M., Merks, E.: EMF: Eclipse Modelling Framework, 2nd edn. Eclipse Series. Addison-Wesley Professional (December 2008)Google Scholar
  3. 3.
    Kolovos, D.S., Rose, L.M., Williams, J., Matragkas, N., Paige, R.F.: A lightweight approach for managing xml documents with mde languages. In: Vallecillo, A., Tolvanen, J.-P., Kindler, E., Störrle, H., Kolovos, D. (eds.) ECMFA 2012. LNCS, vol. 7349, pp. 118–132. Springer, Heidelberg (2012)CrossRefGoogle Scholar
  4. 4.
    Jouault, F., Kurtev, I.: Transforming Models with ATL. In: Bruel, J.-M. (ed.) MoDELS 2005. LNCS, vol. 3844, pp. 128–138. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  5. 5.
    Muller, P.-A., Fleurey, F., Jézéquel, J.-M.: Weaving executability into object-oriented meta-languages. In: Briand, L.C., Williams, C. (eds.) MoDELS 2005. LNCS, vol. 3713, pp. 264–278. Springer, Heidelberg (2005)CrossRefGoogle Scholar
  6. 6.
    Kolovos, D.S., Paige, R.F., Polack, F.A.C.: The Epsilon Object Language (EOL). In: Rensink, A., Warmer, J. (eds.) ECMDA-FA 2006. LNCS, vol. 4066, pp. 128–142. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  7. 7.
    Eclipse Foundation. Epsilon Modeling GMT component,
  8. 8.
    Sun Microsystems. Meta Data Repository,
  9. 9.
    Woodcock, J., Davies, J.: Using Z: Specification, Refinement, and Proof. Prentice Hall (March 1996)Google Scholar
  10. 10.
    Community Z Tools,
  11. 11.
    The Apache Ant Project,
  12. 12.
    Kolovos, D.S., Paige, R.F., Polack, F.A.C.: A Framework for Composing Modular and Interoperable Model Management Tasks. In: Proc. Workshop on Model Driven Tool and Process Integration (MDTPI), ECMDA, Berlin, Germany (June 2008)Google Scholar
  13. 13.
    OMG, Systems Modeling Language, SysML (2012),
  14. 14.
    Graphviz - Graph Visualization Software, Official Web-Site,
  15. 15.
    Hermans, F., Pinzger, M., van Deursen, A.: Detecting and visualizing inter-worksheet smells in spreadsheets. In: ICSE, pp. 441–451. IEEE (2012)Google Scholar
  16. 16.
    Raymond, R.: Panko. Spreadsheet Errors: What We Know. What We Think We Can Do. In: Proceedings of the Spreadsheet Risk Symposium, European Spreadsheet Risks Interest Group (EuSpRIG) (July 2000)Google Scholar
  17. 17.
    Engels, G., Erwig, M.: Classsheets: automatic generation of spreadsheet applications from object-oriented specifications. In: Proceedings of the 20th IEEE/ACM International Conference on Automated Software Engineering, ASE 2005, pp. 124–133. ACM, New York (2005)CrossRefGoogle Scholar
  18. 18.
    Rothermel, G., Burnett, M., Li, L., Dupuis, C., Sheretov, A.: A methodology for testing spreadsheets. ACM Trans. Softw. Eng. Methodol. 10(1), 110–147 (2001)CrossRefGoogle Scholar
  19. 19.
    Prabhakararao, S., Cook, C., Ruthruff, J., Creswick, E., Main, M., Durham, M., Burnett, M.: Strategies and behaviors of end-user programmers with interactive fault localization. In: Proceedings of the 2003 IEEE Symposium on Human Centric Computing Languages and Environments, HCC 2003, pp. 15–22. IEEE Computer Society, Washington, DC (2003)CrossRefGoogle Scholar
  20. 20.
    Burnett, M., Cook, C., Pendse, O., Rothermel, G., Summet, J., Wallace, C.: End-user software engineering with assertions in the spreadsheet paradigm. In: Proceedings of the 25th International Conference on Software Engineering, ICSE 2003, pp. 93–103. IEEE Computer Society, Washington, DC (2003)CrossRefGoogle Scholar
  21. 21.
    Sajaniemi, J.: Modeling spreadsheet audit: A rigorous approach to automatic visualization. Journal of Visual Languages & Computing 11(1), 49–82 (2000)CrossRefGoogle Scholar
  22. 22.
    Cunha, J., Fernandes, J.P., Ribeiro, H., Saraiva, J.: Mdsheet: A framework for model-driven spreadsheet engineering. In: 34th International Conference on Software Engineering (ICSE), pp. 1395–1398 (June 2012)Google Scholar
  23. 23.
    Cunha, J., Fernandes, J.P., Ribeiro, H., Saraiva, J.: A bidirectional model-driven spreadsheet environment. In: 2012 34th International Conference on Software Engineering (ICSE), pp. 1443–1444 (June 2012)Google Scholar
  24. 24.
    Cunha, J., Fernandes, J.P., Ribeiro, H., Saraiva, J.: Towards a catalog of spreadsheet smells. In: Murgante, B., Gervasi, O., Misra, S., Nedjah, N., Rocha, A.M.A.C., Taniar, D., Apduhan, B.O. (eds.) ICCSA 2012, Part IV. LNCS, vol. 7336, pp. 202–216. Springer, Heidelberg (2012)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Mārtiņš Francis
    • 1
  • Dimitrios S. Kolovos
    • 1
  • Nicholas Matragkas
    • 1
  • Richard F. Paige
    • 1
  1. 1.Department of Computer ScienceUniversity of YorkDeramore LaneUK

Personalised recommendations