Zur Webseite der Informatik

Supplementary Material for "Integrating Anomaly Diagnosis Techniques into Spreadsheet Environments"

Publication:

Kulesz, D., Scheurich, J., Beck, F.: Integrating Anomaly Diagnosis Techniques into Spreadsheet Environments, accepted for publication at the 2nd IEEE Working Conference on Software Visualization (VISSOFT), Victoria, 2014

[ Download Final Paper ]

Abstract

Although spreadsheets are often faulty, end-users like them for their flexibility. Most existing approaches to spreadsheet diagnosis are fully automated and use static analysis techniques to find anomalies in formulas or methods to derive test cases without user interaction. The few more interactive approaches are based on values already present in spreadsheets as well. In our work, we advance the idea of testing spreadsheets with user-defined test scenarios but encourage visually aided creation of independent test cases by separating the definition of test scenarios from the specific values present in the spreadsheet—just like test code is separated from production code in professional software. We combine the testing approach with static analysis and integrate it into a common visual spreadsheet environment named SIFEI. It supports users in interactively creating, executing, and analyzing their own test scenarios with a number of visual markers. Findings from two qualitative studies indicate that the concept is suitable for casual spreadsheet users.

Video

Link to Video

Downloads and more information

Data from the experiments

Package containing our tools SIF and SIFEI

Installation manual

Links to our development websites on GitHub: SIF and SIFEI