Print Email Facebook Twitter Supporting professional spreadsheet users by generating leveled dataflow diagrams Title Supporting professional spreadsheet users by generating leveled dataflow diagrams Author Hermans, F. Pinzger, M. Van Deursen, A. Faculty Electrical Engineering, Mathematics and Computer Science Department Software Technology Date 2010-12-31 Abstract 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, using leveled dataflow diagrams. Our approach comes with three different views on the dataflow and allows the user to analyze the dataflow diagrams in a top-down fashion also using slicing techniques. 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. Subject data flow diagramsvisualizationspreadsheetsend-user programming To reference this document use: http://resolver.tudelft.nl/uuid:12790b0c-b81c-4aca-b047-5c8ee19928af Publisher Delft University of Technology, Software Engineering Research Group ISSN 1872-5392 Source Technical Report Series TUD-SERG-2010-036 Part of collection Institutional Repository Document type report Rights © 2010 The Author(s) . Software Engineering Research Group, Department of Software Technology, Faculty of Electrical Engineering, Mathematics and Computer Science, Delft University of Technology Files PDF TUD-SERG-2010-036.pdf 486.3 KB Close viewer /islandora/object/uuid:12790b0c-b81c-4aca-b047-5c8ee19928af/datastream/OBJ/view