i-nth logo

Spreadsheet bibliography

Title Breviz: Spreadsheet visualization and quality analysis
Authors Felienne Hermans, Martin Pinzger, & Arie van Deursen
Year 2010
Type Article
Publication Delft University of Technology
Series Software Engineering Research Group, Technical Report Series
Abstract

Thanks to their flexibility and intuitive programming model, spreadsheets are widely used in industry, often for business-critical applications. Similar to software developers, professional spreadsheet users demand support for understanding spreadsheets, and analyzing their quality.

This paper describes Breviz, a tool that visualizes spreadsheets as leveled dataflow diagrams, showing users all worksheet in a spreadsheet and the data that is flowing between them.

Initially, we used these diagrams to support spreadsheet users in explaining and transferring spreadsheets to colleagues. In further studies of the tool however, we have seen that the visualization is also useful to help detect anomalies in the spreadsheet.

Full version Available
Sample
A spreadsheet dataflow visualization
A spreadsheet dataflow visualization
This is an example of the output of Breviz with the smell detection module enabled.