Preface This volume contains the papers presented at SEMS-14: Workshop on Software Engineering Methods in Spreadsheets held on July 2, 2014 in Delft. The work- shop was organised by Felienne Hermans (TU Delft), Richard Paige (University of York) and Peter Sestoft (IT University of Copenhagen) as a result of their ob- servation that significant research was taking place on spreadsheets in software engineering, and that the time was ripe for a collective meeting bringing together people from different communities - e.g., the end-user programming community, modelling community, testing and verification community, etc. The intent was to have an open workshop, with a reviewing process and open-access proceedings, with the emphasis being on discussions and promoting collaboration. The event was organised by TU Delft and the Spreadsheets Team, as part of Eusprig. The program committee reviewed and selected 15 papers (including short papers, long papers and tools papers) for presentation during the workshop. Each paper received 3 reviews. The organisers would like to thank TU Delft for their support for organising Eusprig. As well, they would like to acknowledge use of Easychair in organising the program committee activities, and CEUR for publishing the post-workshop proceedings. 2 July, 2014 Felienne Hermans Delft, York and Copenhagen Richard F. Paige Peter Sestoft v Table of Contents Tool-supported fault localization in spreadsheets: Limitations of current research practice . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Birgit Hofer, Dietmar Jannach, Thomas Schmitz, Kostyantyn Shcheko- tykhin and Franz Wotawa Toward Interactive Spreadsheet Debugging . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Dietmar Jannach, Thomas Schmitz and Kostyantyn Shchekotykhin Improving Methodology in Spreadsheet Error Research . . . . . . . . . . . . . . . . 7 Raymond Panko Spreadsheets are models too . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Richard Paige, Dimitris Kolovos and Nicholas Matragkas On the Usage of Dependency-based Models for Spreadsheet Debugging . . 11 Birgit Hofer and Franz Wotawa A Spreadsheet Cell-Meaning Model for Testing . . . . . . . . . . . . . . . . . . . . . . . 15 Daniel Kulesz SBBRENG: Spreadsheet Based Business Rule Engine . . . . . . . . . . . . . . . . . 18 Pablo Palma End-user development via sheet-defined functions . . . . . . . . . . . . . . . . . . . . . 23 Peter Sestoft, Jonas Druedahl Rask and Simon Eikeland Timmermann Dependence Tracing Techniques for Spreadsheets: An Investigation . . . . . . 27 Sohon Roy and Felienne Hermans MDSheet Model-Driven Spreadsheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Jácome Cunha, Joao Fernandes, Jorge Mendes, Rui Pereira and João Saraiva How can we figure out what is inside thousands of spreadsheets? . . . . . . . . 34 Thomas Levine Sheetmusic: Making music from spreadsheets . . . . . . . . . . . . . . . . . . . . . . . . . 39 Thomas Levine Are We Overconfident in Our Understanding of Overconfidence? . . . . . . . . 43 Raymond Panko Anonymizing Spreadsheet Data and Metadata with AnonymousXL . . . . . . 45 Joeri van Veen and Felienne Hermans Using a Visual Language to Create Better Spreadsheets . . . . . . . . . . . . . . . . 48 Bas Jansen and Felienne Hermans vi Program Committee Jácome Cunha HASLab/INESC TEC & Universidade do Minho Felienne Hermans Delft University of Technology Nicholas Matragkas University of York Richard Paige University of York Peter Sestoft IT University of Copenhagen Leif Singer University of Victoria Tijs Van Der Storm Centrum Wiskunde & Informatica Arie van Deursen Delft University of Technology vii Additional Reviewers Fernandes, Joao Saraiva, João viii