Spreadsheet analysis and design
Communications of the ACM
International Journal of Human-Computer Studies
Tools for spreadsheet auditing
International Journal of Human-Computer Studies
What you see is what you test: a methodology for testing form-based visual programs
Proceedings of the 20th international conference on Software engineering
Communications of the ACM
Structured Systems Analysis: Tools and Techniques
Structured Systems Analysis: Tools and Techniques
The spreadsheet interface: A basis for end user programming
INTERACT '90 Proceedings of the IFIP TC13 Third Interational Conference on Human-Computer Interaction
Scaling Up a "What You See Is What You Test" Methodology to Spreadsheet Grids
VL '99 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
Header and Unit Inference for Spreadsheets Through Spatial Analyses
VLHCC '04 Proceedings of the 2004 IEEE Symposium on Visual Languages - Human Centric Computing
WEUSE I Proceedings of the first workshop on End-user software engineering
Structured Analysis and System Specification
Structured Analysis and System Specification
CASCON '08 Proceedings of the 2008 conference of the center for advanced studies on collaborative research: meeting of minds
Automatically extracting class diagrams from spreadsheets
ECOOP'10 Proceedings of the 24th European conference on Object-oriented programming
The state of the art in end-user software engineering
ACM Computing Surveys (CSUR)
Supporting the cooperation of end-user programmers through social development environments
Proceedings of the 2nd International Workshop on Web 2.0 for Software Engineering
Detecting and visualizing inter-worksheet smells in spreadsheets
Proceedings of the 34th International Conference on Software Engineering
SourceTrac: tracing data sources within spreadsheets
IPAW'12 Proceedings of the 4th international conference on Provenance and Annotation of Data and Processes
Lessons learned from evaluating the usability of mobile spreadsheet applications
HCSE'12 Proceedings of the 4th international conference on Human-Centered Software Engineering
Data clone detection and visualization in spreadsheets
Proceedings of the 2013 International Conference on Software Engineering
Automated data provenance capture in spreadsheets, with case studies
Future Generation Computer Systems
Improving spreadsheet test practices
CASCON '13 Proceedings of the 2013 Conference of the Center for Advanced Studies on Collaborative Research
| Hi-index | 0.00 |
Thanks to their flexibility and intuitive programming model, spreadsheets are widely used in industry, often for businesscritical applications. Similar to software developers, professional spreadsheet users demand support for maintaining and transferring their spreadsheets. In this paper, we first study the problems and information needs of professional spreadsheet users by means of a survey conducted at a large financial company. Based on these needs, we then present an approach that extracts this information from spreadsheets and presents it in a compact and easy to understand way, with leveled dataflow diagrams. Our approach comes with three different views on the dataflow that allow the user to analyze the dataflow diagrams in a top-down fashion. To evaluate the usefulness of the proposed approach, we conducted a series of interviews as well as nine case studies in an industrial setting. The results of the evaluation clearly indicate the demand for and usefulness of our approach in ease the understanding of spreadsheets.