Authors
Jacome Cunha, Joao Paulo Fernandes, Pedro Martins, Jorge Mendes, & Joao Saraiva
Abstract
This tool demo paper presents SmellSheet Detective: a tool for automatically detecting bad smells in spreadsheets.
We have defined a catalog of bad smells in spreadsheet data which was fully implemented in a reusable library for the manipulation of spreadsheets. This library is the building block of the SmellSheet Detective tool, that has been used to detect smells in large, real-world spreadsheets within the EUSES corpus, in order to validate and evolve our bad smells catalog.
Sample
Running the SmellSheet Detective tool on 180 spreadsheets from the Euses corpus resulted in 22% of cells (285 from 1315) being identified as smells that deteriorate the quality of the spreadsheet.
Publication
2012, IEEE Symposium on Visual Languages and Human-Centric Computing, September/October, pages 243–244
Full article
SmellSheet Detective: A tool for detecting bad smells in spreadsheets
