A Toolkit for Scalable Spreadsheet Visualization

This paper presents a toolkit for spreadsheet visualization based on logical areas, semantic classes and data modules. Logical areas, semantic classes and data modules are abstract representations of spreadsheet programs that are meant to reduce the auditing and comprehension effort, especially for large and regular spreadsheets. The toolkit is integrated as a plug-in in the Gnumeric spreadsheet system for Linux. It can process large, industry scale spreadsheet programs in reasonable time and is tightly integrated with its host spreadsheet system. Users can generate hierarchical and graph-based representations of their spreadsheets. This allows them to spot conceptual similarities in different regions of the spreadsheet, that would otherwise not fit on a screen. As it is assumed that the learning effort for effective use of such a tool should be kept low, we aim for intuitive handling of most of the tool's functions.

[1]  Raymond J. Butler,et al.  Is this spreadsheet a tax evader? How HM Customs and Excise test spreadsheet applications , 2000, Proceedings of the 33rd Annual Hawaii International Conference on System Sciences.

[2]  R PankoRaymond.  Applying code inspection to spreadsheet testing , 1999 .

[3]  Raymond R. Panko,et al.  What we know about spreadsheet errors , 1998 .

[4]  Sabine Hipfl.  Using Layout Information for Spreadsheet Visualization , 2008, ArXiv.

[5]  John D. Gould,et al.  An experimental study of people creating spreadsheets , 1987, TOIS.

[6]  Roland Mittermeir,et al.  A Spreadsheet Auditing Tool Evaluated in an Industrial Context , 2008, ArXiv.

[7]  Jorma Sajaniemi.  Modeling Spreadsheet Audit: A Rigorous Approach to Automatic Visualization , 2000, J. Vis. Lang. Comput..

[8]  Bonnie A. Nardi,et al.  An ethnographic study of distributed problem solving in spreadsheet development , 1990, CSCW '90.

[9]  Brian Knight,et al.  Quality control in spreadsheets: a software engineering-based approach to spreadsheet development , 2000, Proceedings of the 33rd Annual Hawaii International Conference on System Sciences.

[10]  Raymond R. Panko,et al.  Applying Code Inspection to Spreadsheet Testing , 1999, J. Manag. Inf. Syst..

[11]  Emden R. Gansner,et al.  An open graph visualization system and its applications to software engineering , 2000, Softw. Pract. Exp..

[12]  Markus Clermont.  Analyzing large spreadsheet programs , 2003, 10th Working Conference on Reverse Engineering, 2003. WCRE 2003. Proceedings..

[13]  Roland Mittermeir,et al.  Detecting Errors in Spreadsheets , 2008, ArXiv.

[14]  Gregg Rothermel,et al.  Slicing spreadsheets: an integrated methodology for spreadsheet testing and debugging , 1999, DSL '99.

[15]  Markus Clermont,et al.  A Scalable Approach to Spreadsheet Visualization , 2003 .

[16]  Henry C. Lucas,et al.  Toward a logical/physical theory of spreadsheet modeling , 1992, TOIS.

[17]  Gregg Rothermel,et al.  WYSIWYT testing in the spreadsheet paradigm: an empirical evaluation , 2000, Proceedings of the 2000 International Conference on Software Engineering. ICSE 2000 the New Millennium.