On the Emergence of Patterns for Spreadsheets Data Arrangements

Ricardo Teixeira, Vasco Amaral

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

Spreadsheets are widely used both by individuals as well as large companies in a vast plethora of application domains. One of the reasons for this popularity is the general purpose flexibility spreadsheets offer to the end user. This flexibility favors the existence of multiple spreadsheet designs regarding the physical organization of the data presented by a spreadsheet. Nevertheless, to the best of our knowledge, little is still known about patterns of spreadsheet data arrangements. Works refer the emergence of commonalities and templates but it is hard to find a systematic study on the topic that presents us catalogues. It is known that spreadsheets are extremely error-prone. Therefore, to know the typical data arrangement patterns can be very useful insight on how to build mechanisms and strategies in order to prevent errors regarding spreadsheets specification and maintenance. The present work aims at present data arrangement patterns that emerged from our studies and direct observation of real-world spreadsheet samples from two large datasets, and, additionally, a formal representation of the patterns identified through the use of conceptual models. © Springer International Publishing AG 2016.
Original languageEnglish
Title of host publicationSoftware Technologies: Applications and Foundations
Subtitle of host publicationSTAF 2016 Collocated Workshops: DataMod, GCM, HOFM, MELO, SEMS, VeryComp, Vienna Austria, July 4-8, 2016, Revised Selected Papers
Pages333-345
ISBN (Electronic)978-3-319-50230-4
DOIs
Publication statusPublished - 2016

Keywords

  • Spreadsheets
  • Data arrangements
  • Patterns
  • Conceptual model
  • UML

Fingerprint Dive into the research topics of 'On the Emergence of Patterns for Spreadsheets Data Arrangements'. Together they form a unique fingerprint.

  • Cite this

    Teixeira, R., & Amaral, V. (2016). On the Emergence of Patterns for Spreadsheets Data Arrangements. In Software Technologies: Applications and Foundations: STAF 2016 Collocated Workshops: DataMod, GCM, HOFM, MELO, SEMS, VeryComp, Vienna Austria, July 4-8, 2016, Revised Selected Papers (pp. 333-345) https://doi.org/10.1007/978-3-319-50230-4_25