An experimental study of people creating spreadsheets
ACM Transactions on Information Systems (TOIS)
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)
WEUSE I Proceedings of the first workshop on End-user software engineering
An end-user oriented graph-based visualization for spreadsheets
Proceedings of the 4th international workshop on End-user software engineering
A dynamic graph-based visualization for spreadsheets
HCI '08 Proceedings of the Third IASTED International Conference on Human Computer Interaction
Graphael: a system for generalized force-directed layouts
GD'04 Proceedings of the 12th international conference on Graph Drawing
| Hi-index | 0.00 |
Spreadsheet programs, artefacts developed by end-user programmers, are used for a variety of important tasks and decisions. However, as the literature indicates, a significant proportion of spreadsheet programs contain faults. One of the contributing factors to the quality issue is the invisibility of cell dependencies (which define the dataflow structure of a spreadsheet) up on which computations are performed. In an attempt to provide a guide in understanding spreadsheets, this paper presents an approach to visualize a spreadsheet in terms of logical areas using the MCL (Markov Clustering) algorithm. Instead of focusing their attention on the whole spreadsheet, spreadsheet users may narrow their focus to one logical area at a time. To evaluate our approach, a prototype tool has been developed and integrated into Microsoft Excel.