An experimental study of people creating spreadsheets
ACM Transactions on Information Systems (TOIS)
A small matter of programming: perspectives on end user computing
A small matter of programming: perspectives on end user computing
International Journal of Human-Computer Studies
Tools for spreadsheet auditing
International Journal of Human-Computer Studies
What we know about spreadsheet errors
Journal of End User Computing - End User Development
Two Corpuses of Spreadsheet Errors
HICSS '00 Proceedings of the 33rd Hawaii International Conference on System Sciences-Volume 4 - Volume 4
Spreadsheet structure inspection using low level access and visualisation
AUIC '03 Proceedings of the Fourth Australasian user interface conference on User interfaces 2003 - Volume 18
Spreadsheet structure inspection using low level access and visualisation
AUIC '03 Proceedings of the Fourth Australasian user interface conference on User interfaces 2003 - Volume 18
Fluid Visualization of Spreadsheet Structures
VL '98 Proceedings of the IEEE Symposium on Visual Languages
3D Interactive Visualization for Inter-Cell Dependencies of Spreadsheets
INFOVIS '99 Proceedings of the 1999 IEEE Symposium on Information Visualization
Finding High-Level Structures in Spreadsheet Programs
WCRE '02 Proceedings of the Ninth Working Conference on Reverse Engineering (WCRE'02)
Topological Fisheye Views for Visualizing Large Graphs
IEEE Transactions on Visualization and Computer Graphics
Visualizing large graphs with compound-fisheye views and treemaps
GD'04 Proceedings of the 12th international conference on Graph Drawing
A visualization-based approach for improving spreadsheet quality
Proceedings of the Warm Up Workshop for ACM/IEEE ICSE 2010
Hi-index | 0.01 |
Spreadsheet systems are widely used and highly popular end-user systems. They are used for a variety of important tasks such as mathematical modelling, scientific computation, tabular and graphical data presentation, data analysis and decision making. However, a significant proportion of them have severe quality problems. One of the contributing factors is the invisibility of the data flow structure which is associated with cell formulas. The invisibility of the data flow makes program understanding and debugging very difficult. This paper aims to provide a visualization approach that can simplify understanding and debugging of spreadsheets based on compound fisheye views, the Markov Clustering (MCL) algorithm, and Treemaps. The MCL algorithm helps in visualizing large graphs by generating clusters of cells. Compound fisheye views allows us to view members of a particular cluster while showing their linkages with other clusters. Treemaps help to visualize the depth we are at while navigating a cluster tree. Our initial experiment shows that graph-based visualization using the MCL algorithm generates clusters which match with the corresponding logical areas of a spreadsheet.