• Corpus ID: 15593651

Metrics-Based Spreadsheet Visualization: Support for Focused Maintenance

@article{Hodnigg2008MetricsBasedSV,
  title={Metrics-Based Spreadsheet Visualization: Support for Focused Maintenance},
  author={Karin Hodnigg and Roland Mittermeir},
  journal={ArXiv},
  year={2008},
  volume={abs/0809.3009}
}
Legacy spreadsheets are both, an asset, and an enduring problem concerning spreadsheets in business. To make spreadsheets stay alive and remain correct, comprehension of a given spreadsheet is highly important. Visualization techniques should ease the complex and mindblowing challenges of finding structures in a huge set of spreadsheet cells for building an adequate mental model of spreadsheet programs. Since spreadsheet programs are as diverse as the purpose they are serving and as… 

Figures from this paper

Analyzing and Visualizing Spreadsheets
TLDR
This dissertation aims at developing methods to support spreadsheet users to understand, update and improve spreadsheets and found that methods from software engineering can be applied to spreadsheets very well, and that these methods support end-users in working with spreadsheets.
Automated model-based spreadsheet debugging
TLDR
Several new algorithmic enhancements of the general MBD approach are combined in this thesis to allow spreadsheet users to debug their spreadsheets and to efficiently find the reason of the observed unexpected output values.
A Maintainability Checklist for Spreadsheets
TLDR
This paper presents a checklist aimed at measuring the maintainability of a spreadsheet, and demonstrates the applicability of this approach on 11 spreadsheets from the EUSES corpus.
XVIZIT: Visualizing cognitive units in spreadsheets
  • K. Hodnigg, M. Pinzger
  • Computer Science
    2015 IEEE 3rd Working Conference on Software Visualization (VISSOFT)
  • 2015
Spreadsheets can be large and complex and their maintenance and comprehension difficult to end-users. Large numbers of cells, complex formulae and missing documentation can impede the understanding
A decomposition-based approach to spreadsheet testing and debugging
TLDR
This work proposes to split spreadsheets into smaller logically connected parts (called fragments) which can be individually tested for correctness, and presents an algorithmic approach to compute such fragments.
Visualizing Cognitive Units in Spreadsheets
Spreadsheets can be large and complex and their maintenance and comprehension difficult to end-users. Large numbers of cells, complex formulae and missing documentation can impede the understanding
What we understand is what we get: Assessment in Spreadsheets
TLDR
This paper evaluates the (comprehension) coverage of SACHS on an Excel-based financial controlling system via a "Wizard-of-Oz" experiment, and shows that SAC HS adds significant value, but systematically misses important classes of explanations.
Detecting and visualizing inter-worksheet smells in spreadsheets
TLDR
The results of the evaluation indicate that smells can indeed reveal weaknesses in a spreadsheet's design, and that data flow diagrams are an appropriate way to show those weaknesses.
EXACT: A tool for comprehending VBA‐based Excel spreadsheet applications
TLDR
A reverse engineering tool intended to support the comprehension of Excel spreadsheet applications developed using the Visual Basic for Application programming language that is implemented as an add‐in that extends the Excel working environment by providing analysis and visualization features.
...
...

References

SHOWING 1-10 OF 29 REFERENCES
Finding high-level structures in spreadsheet programs
TLDR
An approach to help maintainers understand the structure of large spreadsheets as well as to zoom into certain parts of the spreadsheet to cope with large sheets is introduced.
Modeling Spreadsheet Audit: A Rigorous Approach to Automatic Visualization
TLDR
A theoretical model of spreadsheets and a technique to describe spreadsheet auditing tools are presented and it is hoped that visualizations that point out parts ofspreadsheets that contain anomalies will be found.
Spreadsheet Visualisation to Improve End-user Understanding
TLDR
New ways to visualise spreadsheets in a manner that is independent of the program they were created in are explored, the technology involved is explained, and examples of the visualisations that can be produced are presented.
Analyzing large spreadsheet programs
  • Markus Clermont
  • Computer Science
    10th Working Conference on Reverse Engineering, 2003. WCRE 2003. Proceedings.
  • 2003
TLDR
An approach is introduced that enables the decomposing of large spreadsheets into self contained parts, that are similar to modules in conventional software, and which can be considered orthogonal to semanticclasses, that have been introduced in prior work.
A Pragmatic Approach to Spreadsheet Training Based Upon the "Projection-Screen" Model
TLDR
The main problem fields are presented, a didactical model is presented, and some rather pragmatic advice on how to teach spreadsheets is presented.
Complexity Metrics for Spreadsheet Models
TLDR
Two conceptual constructs - the reference branching condition cell and the condition block - are discussed, aiming at improving the reliability, modifiability, auditability and comprehensibility of logical tests.
Spreadsheet Debugging
TLDR
The fault tracing technique proposed uses the dataflow information and cell marks to identify the most influential faulty cell(s) for a given formula cell containing a propagated fault in spreadsheet programs.
Heuristics for the automatic identification of irregularities in spreadsheets
TLDR
It is found that most end users are willing to verify their spreadsheets, but only view have the time and skills to do really systematic testing of spreadsheets.
Using Layout Information for Spreadsheet Visualization
This paper extends a spreadsheet visualization technique by using layout information. The original approach identifies logically or semantically related cells by relying exclusively on the content of
Spreadsheet Validation and Analysis through Content Visualization
TLDR
Oculus Excel Visualizer is a point and click data visualization experiment which directly visualizes Excel data and re-uses the layout and formatting already present in the spreadsheet.
...
...