Preface This volume contains the papers presented at SEMS’15: Second Workshop on Software Engineering Methods in Spreadsheets held on May 18, 2015 in Flo- rence, Italy, as part of the 37th International Conference on Software Engi- neering (ICSE). The workshop was organised by Felienne Hermans (TU Delft), Richard Paige (University of York) and Peter Sestoft (IT University of Copen- hagen) as a result of their observations that significant research was taking place on spreadsheets in software engineering, and that the time was ripe for a col- lective meeting bringing together people from different communities - e.g., the end-user programming community, modelling community, testing and verifica- tion community, etc. A first workshop had been organised in 2014, co-located with Eusprig, in Delft, the Netherlands. The program committee reviewed and selected 11 papers (including short papers, long papers and tools papers) for presentation during the workshop. Each paper received 3 reviews, and there was further discussion amongst the reviewers and organisers to select these papers from amongst 16 submissions. The organisers would like to thank the ICSE’15 local organising team for their support for organising the workshop as part of ICSE; the workshop chairs were particularly helpful in coordination. As well, they would like to acknowledge use of Easychair in organising the program committee activities. Normally, ICSE workshop proceedings are published behind a paywall, in the ACM or IEEE Digital Library. The organisers of SEMS support full open access publication of all publically funded research, and are pleased that it was possible and feasible to publish the proceedings in CEUR. 18 May 2015 Felienne Hermans Delft, York and Copenhagen Richard F. Paige Peter Sestoft v Table of Contents Using Calculation Fragments for Spreadsheet Testing and Debugging . . . . 1 Dietmar Jannach and Thomas Schmitz Spreadsheets in an ERP environment - not what the doctor ordered . . . . . 3 Noam Newman Business Rule Mining from Spreadsheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Sohon Roy Towards the Design and Implementation of Aspect-Oriented Programming for Spreadsheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Pedro Maia, Jorge Mendes, Jácome Cunha, Henrique Rebêlo and João Saraiva Assessment for Spreadsheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Alexandru Toader, Andrea Kohlhase and Michael Kohlhase Context in Spreadsheet Comprehension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Andrea Kohlhase, Michael Kohlhase and Ana Guseva Live-Inspection of Spreadsheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Daniel Kulesz, Fabian Toth and Fabian Beck Toward Reverse Engineering of VBA Based Excel Spreadsheet Applications 30 Domenico Amalfitano, Nicola Amatucci, Vincenzo De Simone, Anna Rita Fasolino and Porfirio Tramontana Structured Spreadsheet Modeling and Implementation . . . . . . . . . . . . . . . . . 32 Paul Mireault Spreadsheets for Stream Partitions and Windows . . . . . . . . . . . . . . . . . . . . . 39 Martin Hirzel, Rodric Rabbah, Philippe Suter, Olivier Tardieu and Man- dana Vaziri Enron versus EUSES: A Comparison of Two Spreadsheet Corpora . . . . . . 41 Bas Jansen vi 1 Program Committee and External Reviewers The Program Committee was composed of a diverse group of members from seven different countries. There were 48 reviews provided for the 16 submissions that were received. We thank the following members of the SEMS 2015 Program Committee for their assistance in reviewing and discussing the papers. – Rui Abreu, University of Porto, Portugal – S.C. Cheung, The Hong Kong University of Science and Technology, Hong Kong – Jácome Cunha, Universidade Nova de Lisboa & HASLab/INESC TEC, Por- tugal – Felienne Hermans, Delft University of Technology, The Netherlands – Birgit Hofer, Technische Universitaet Graz, Austria – Richard Paige, University of York, UK – Martin Pinzger, University of Klagenfurt, Austria – Peter Sestoft, IT University of Copenhagen, Denmark – Leif Singer, University of Victoria, Canada Additional Reviewers – Joao Fernandes – Alexandre Perez vii