Towards a catalog of spreadsheet smells

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 usual...

Full description

Bibliographic Details
Main Author: Cunha, Jácome Miguel Costa (author)
Other Authors: Fernandes, João Paulo (author), Ribeiro, Hugo (author), Saraiva, João Alexandre (author)
Format: conferencePaper
Language:eng
Published: 2012
Subjects:
Online Access:http://hdl.handle.net/1822/36070
Country:Portugal
Oai:oai:repositorium.sdum.uminho.pt:1822/36070
Description
Summary: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.