Integrating Anomaly Diagnosis Techniques into Spreadsheet Environments

Kulesz, Daniel; Scheurich, Jonas; Beck, Fabian

doi:10.1109/vissoft.2014.12

Cited by 6 publications

(5 citation statements)

References 28 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Since 2011, the first author has supervised ten student theses and other projects in which a tool prototype named "Spreadsheet Inspection Framework" (SIF) was developed to implement Spreadsheet Guardian. SIF and its capabilities have already been described in previous work [31]. Therefore, this section covers SIF only briefly.…”

Section: Methodsmentioning

confidence: 99%

“…In previous work [31], we have presented a tool named Spreadsheet Inspection Framework (SIF). SIF is tightly integrated into Microsoft Excel and allows end-users to create unit-test-like test rules.…”

Section: Contributionsmentioning

confidence: 99%

“…There is a huge spectrum of possibilities to specify and execute test rules. In previous work [31], we reviewed both spreadsheet inspection approaches typically encountered in practice as well as inspection approaches proposed in literature for their underlying test rules. We identified three non-disjunct classes:…”

Section: Spreadsheet Inspectionsmentioning

confidence: 99%

See 2 more Smart Citations

Spreadsheet guardian: An approach to protecting semantic correctness throughout the evolution of spreadsheets

Kulesz

Käfer

Wagner

2018

J Software Evolu Process

Self Cite

View full text Add to dashboard Cite

Spreadsheets are powerful tools that play a business‐critical role in many organizations. However, many bad decisions taken due to faulty spreadsheets show that these tools need serious quality assurance. Furthermore, while collaboration on spreadsheets for maintenance tasks is common, there has been almost no support for ensuring that the spreadsheets remain correct during this process. We have developed an approach named Spreadsheet Guardian, which separates the specification of spreadsheet test rules from their execution. By automatically executing user‐defined test rules, our approach is able to detect semantic faults. It also protects all collaborating spreadsheet users from introducing faults during maintenance, even if only few end‐users specify test rules. To evaluate Spreadsheet Guardian, we implemented a representative testing technique as an add‐in for Microsoft Excel. We evaluated the testing technique in 2 empirical evaluations with 29 end‐users and 42 computer science students. The results indicate that the technique is easy to learn and to apply. Furthermore, after finishing maintenance, participants with spreadsheets “protected” by the technique are more realistic about the correctness of their spreadsheets than participants who use only “classic,” noninteractive test rules on the basis of static analysis techniques. Hence, we believe that Spreadsheet Guardian can be of use for business‐critical spreadsheets.

show abstract

Section: Methodsmentioning

confidence: 99%

Section: Contributionsmentioning

confidence: 99%

See 1 more Smart Citation

Spreadsheet guardian: An approach to protecting semantic correctness throughout the evolution of spreadsheets

Kulesz

Käfer

Wagner

2018

J Software Evolu Process

Self Cite

View full text Add to dashboard Cite

show abstract

“…It supports the visualization of transition systems that model the behavior of a software. SIFEI [52] and xViZiT [53] focus on the visualization of spreadsheets, whereas regVis [54] deals with the visualization of assembler control-flow based on regular expressions. Method Execution Reports [55] embed word-size graphics in reports of method executions.…”

Section: ) Behaviormentioning

confidence: 99%

VISON: An Ontology-Based Approach for Software Visualization Tool Discoverability

Merino

Kozlova

Nierstrasz

et al. 2019

2019 Working Conference on Software Visualization (VISSOFT)

View full text Add to dashboard Cite

Although many tools have been presented in the research literature of software visualization, there is little evidence of their adoption. To choose a suitable visualization tool, practitioners need to analyze various characteristics of tools such as their supported software concerns and level of maturity. Indeed, some tools can be prototypes for which the lifespan is expected to be short, whereas others can be fairly mature products that are maintained for a longer time. Although such characteristics are often described in papers, we conjecture that practitioners willing to adopt software visualizations require additional support to discover suitable visualization tools. In this paper, we elaborate on our efforts to provide such support. To this end, we systematically analyzed research papers in the literature of software visualization and curated a catalog of 70 available tools that employ various visualization techniques to support the analysis of multiple software concerns. We further encapsulate these characteristics in an ontology. VISON, our software visualization ontology, captures these semantics as concepts and relationships. We report on early results of usage scenarios that demonstrate how the ontology can support (i) developers to find suitable tools for particular development concerns, and (ii) researchers who propose new software visualization tools to identify a baseline tool for a controlled experiment. arXiv:1908.04090v1 [cs.SE] 12 Aug 2019Step 2. Consider reusing existing ontologies. To the best of our knowledge, this is the first ontology of software visualizations.Step 3. Enumerate important terms in the ontology. We include the characteristics of software visualization and their evaluations, as well as the classifications presented in previous studies [6], [7].

show abstract

“…In previous work, we developed a framework for specifying, executing and analyzing tests in spreadsheets [2]. Later, we developed an approach named "Spreadsheet Guardian" [3] for protecting spreadsheet users from the introduction of faults in collaborative settings.…”

Section: Contextmentioning

confidence: 99%

Asheetoxy: A Taxonomy for Classifying Negative Spreadsheet-related Phenomena

Kulesz,

Wagner

2018

Preprint

Self Cite

View full text Add to dashboard Cite

Spreadsheets (sometimes also called Excel programs) are powerful tools which play a business-critical role in many organizations. However, due to faulty spreadsheets many bad decisions have been taken in recent years. Since then, a number of researchers have been studying spreadsheet errors. However, one issue that hinders discussion among researchers and professionals is the lack of a commonly accepted taxonomy.Albeit a number of taxonomies for spreadsheet errors have been proposed in previous work, a major issue is that they use the term error that itself is already ambiguous. Furthermore, to apply most existing taxonomies, detailed knowledge about the underlying process and knowledge about the "brain state" of the acting spreadsheet users is required. Due to these limitations, known error-like phenomena in freely available spreadsheet corpora cannot be classified with these taxonomies.We propose Asheetoxy, a simple and phenomenon-oriented taxonomy that avoids the problematic term error altogether. An initial study with 7 participants indicates that even nonspreadsheet researchers similarly classify real-world spreadsheet phenomena using Asheetoxy.

show abstract

Integrating Anomaly Diagnosis Techniques into Spreadsheet Environments

Cited by 6 publications

References 28 publications

Spreadsheet guardian: An approach to protecting semantic correctness throughout the evolution of spreadsheets

Spreadsheet guardian: An approach to protecting semantic correctness throughout the evolution of spreadsheets

VISON: An Ontology-Based Approach for Software Visualization Tool Discoverability

Asheetoxy: A Taxonomy for Classifying Negative Spreadsheet-related Phenomena

Contact Info

Product

Resources

About