Update: This paper will be presented at FSE 2014! Some spreadsheets can be improved While looking at spreadsheet and how they are used, over the past years I have noticed that many users don’t make their spreadsheets as easy as they could be. For instance, they use A1+A2+A3+A4+A5 instead of the simpler SUM(A1:A5) Sometimes because […]
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 […]