Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/37955
Título: | Smelling faults in spreadsheets |
Autor(es): | Abreu, Rui Cunha, Jácome Miguel Costa Fernandes, João Paulo Sousa Ferreira Martins, Pedro Miguel Ribeiro Perez, Alexandre Saraiva, João Alexandre |
Data: | 2014 |
Editora: | IEEE |
Revista: | Proceedings-Ieee International Conference on Software Maintenance |
Resumo(s): | Despite being staggeringly error prone, spreadsheets are a highly flexible programming environment that is widely used in industry. In fact, spreadsheets are widely adopted for decision making, and decisions taken upon wrong (spreadsheet-based) assumptions may have serious economical impacts on businesses, among other consequences. This paper proposes a technique to automatically pinpoint potential faults in spreadsheets. It combines a catalog of spreadsheet smells that provide a first indication of a potential fault, with a generic spectrum-based fault localization strategy in order to improve (in terms of accuracy and false positive rate) on these initial results. Our technique has been implemented in a tool which helps users detecting faults.To validate the proposed technique, we consider a wellknown and well-documented catalog of faulty spreadsheets. Our experiments yield two main results: we were able to distinguish between smells that can point to faulty cells from smells and those that are not capable of doing so; and we provide a technique capable of detecting a significant number of errors: two thirds of the cells labeled as faulty are in fact (documented) errors. |
Tipo: | Artigo em ata de conferência |
URI: | https://hdl.handle.net/1822/37955 |
ISBN: | 9780769553030 |
DOI: | 10.1109/ICSME.2014.33 |
ISSN: | 1063-6773 |
Versão da editora: | http://ieeexplore.ieee.org/xpl/articleDetails.jsp?arnumber=6976077 |
Arbitragem científica: | yes |
Acesso: | Acesso aberto |
Aparece nas coleções: |