i-nth logo

Authors

Felienne Hermans, Martin Pinzger, & Arie van Deursen

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.

Sample

A spreadsheet dataflow visualization
A spreadsheet dataflow visualization

This is an example of the output of Breviz with the smell detection module enabled.

Publication

2010, Delft University of Technology, Software Engineering Research Group, Technical Report Series

Full article

Breviz: Spreadsheet visualization and quality analysis