Debugging Spreadsheets: A CSP-based Approach

• Tipo: Artigo em Livro de Atas de Conferência Internacional
• Data: 2012

Autores

Rui Abreu (Autor) FEUP; Andre Riboira (Autor) Outra; Franz Wotawa (Autor) Outra

Ata de Conferência Internacional

Título: 23RD IEEE INTERNATIONAL SYMPOSIUM ON SOFTWARE RELIABILITY ENGINEERING WORKSHOPS (ISSRE 2012)

Páginas: 159-164

23rd IEEE International Symposium on Software Reliability Engineering Workshops (ISSREW)

Dallas, TX, NOV 27-30, 2012

Indexação

ISI Web of Knowledge - 6 Citações

Scopus - 8 Citações

Classificação Científica

FOS: Ciências da engenharia e tecnologias > Engenharia electrotécnica, electrónica e informática

Outras Informações

ID Authenticus: P-005-43H

DOI: 10.1109/issrew.2012.31

Abstract (EN): Despite being staggeringly error prone, spreadsheets can be viewed as a highly flexible end-users programming environment. As a consequence, spreadsheets are widely adopted for decision making, and may have a serious economical impact for the business. Hence, approaches for aiding the process of pinpointing the faulty cells in a spreadsheet are of great value. We present a constrain-based approach, CONBUG, for debugging spreadsheets. The approach takes as input a (faulty) spreadsheet and a test case that reveals the fault and computes a set of diagnosis candidates for the debugging problem we are trying to solve. To compute the set of diagnosis candidates we convert the spreadsheet and test case to a constraint satisfaction problem. From our experimental results, we conclude that CONBUG can be of added value for the end user to pinpoint faulty cells.

Idioma: Inglês

Tipo (Avaliação Docente): Científica

Nº de páginas: 6