Spreadsheet bibliography
Title | Towards a catalog of spreadsheet smells |
---|---|
Authors | Jacome Cunha, Joao Paulo Fernandes, Hugo Ribeiro, & Joao Saraiva |
Year | 2012 |
Type | Proceedings |
Publication | 12th international conference on computational science and its applications |
Series | Volume Part IV, pages 202-216 |
Abstract | Spreadsheets are considered to be the most widely used programming language in the world, and reports have shown that 90% of real-world spreadsheets contain errors. In this work, we try to identify spreadsheet smells, a concept adapted from software, which consists of a surface indication that usually corresponds to a deeper problem. Our smells have been integrated in a tool, and were computed for a large spreadsheet repository. Finally, the analysis of the results we obtained led to the refinement of our initial catalog. |
Full version | Available |
Sample | SmellSheet Detective architecture ![]() SmellSheet Detective uses the Java programming language, Google Web Toolkit, Apache POI library and the Google libraries to work with spreadsheets from the Google Docs. We also support spreadsheets written using desktop applications. |