April 9-11th 2014
Churchill College, Cambridge UK

Session

Session Title

Building a language for spreadsheet refactoring

Session Type Experience Report
Duration 45 minutes
Session Description

Spreadsheets are code too! You have constants, variable, functions and conditional statements, everything you need to build anything you want. If you really want it, you can even build a Turing machine with Excel. So if spreadsheets are code, can we also analyse, test and refactor them? Felienne thinks so. In this talk, she discusses her latest spreadsheet tool: BumbleBee. BumbleBee allows users to refactor and even metaprogram their spreadsheet. For this, Felienne designed a language in which the transformations can be described and built a pattern matcher in F# to transform spreadsheet formulas.

Speaker(s)

Felienne Hermans (Delft University of Technology)

Felienne Hermans is a computer scientist. During her PhD project, she researched the applicability of clone and smell detection to spreadsheets, and founded a spin off based on this idea. Now a professor, she continues her mission to improve spreadsheets in the wild using software engineering methods. In her spare time, Felienne volunteers as a referee for the First Lego League, a world wide technology competition for kids.