i-nth logo

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

Smells in the Euses corpus
Smells in the Euses corpus

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