For those interested, my dissertation is available on FigShare! Questions or remarks? Feel free to post below. If you don’t feel like digging through hundreds of pages of spreadsheet goodness, the following slide deck presents a quick overview. An overview of my PhD research from Felienne Hermans I printed by thesis with Proefschriftmaken.nl and I […]
Proposition #1
The core reasons for the success of spreadsheets are their immediate feedback system and their continuous deployment model. Spreadsheets are enormously successful. It is estimated that 95% of all US companies use spreadsheets for financial reporting (1). In the eighties spreadsheets became “the medium, the method, the tool, and the language of financial analysis” (2) This success raises the […]
TinyToCS: Exact and Near-miss Clone Detection in Spreadsheets
Our mini-paper ‘Exact and Near-miss Clone Detection in Spreadsheets’ was accepted in the first volume of TinyToCS. Tiny Transactions on Computer Science is a cute new initiative started by two researchers from the University of California in Berkeley, that aims to make computer science research more accessible to the general public. In their own words: “Tiny […]
Implication of Data Quality for Spreadsheet Analysis
by Donald P. Ballou, Harold L. Pazer, Salvatore Belardo and Barbara Klein —School of Business-State University of New York at Albany This paper describes the implication errors in spreadsheet data can have, and they kick of with some nice observations in the intro: Intro However, the obvious problem of the impact of faulty data on spreadsheet computations […]
Detecting Code Smells in Spreadsheet Formulas
We just learned this paper is accepted at ICSM 2012. The idea The basic idea of this paper is to investigate whether we could apply the known code smells invented by Martin Fowler in his book Refactoring to spreadsheet formulas. You could view a formula as a small piece of code, so it makes sense to […]
