{"id":1477,"date":"2015-01-27T12:27:32","date_gmt":"2015-01-27T01:27:32","guid":{"rendered":"http:\/\/excelatfinance.com\/online\/?page_id=1477"},"modified":"2015-08-14T08:54:09","modified_gmt":"2015-08-13T22:54:09","slug":"references-academic","status":"publish","type":"page","link":"https:\/\/excelatfinance.com\/online\/references-academic\/","title":{"rendered":"References &#8211; spreadsheet modeling"},"content":{"rendered":"<p><?php include \"..\/includes\/access.php\"; ?><\/p>\n<h2>References &#8211; academic<\/h2>\n<p style=\"margin-left:.5in;text-indent:-.5in\">Baker K. R., Powell S, Lawson B, and Foster-Johnson L, (2009). &#8216;Comparison of Characteristics and Practices amongst Spreadsheet Users with Different Levels of Experience&#8217;, <em>Omega<\/em> 37.3, pp.579-590. <a href=\"http:\/\/arxiv.org\/abs\/0803.0168\" rel=\"nofollow\" title=\"We developed an internet-based questionnaire on spreadsheet use that we administered to a large number of users in several companies and organizations to document how spreadsheets are currently being developed and used in business. In this paper, we discuss the results drawn from of a comparison of responses from individuals with the most experience and expertise with those from individuals with the least. These results describe two views of spreadsheet design and use in organizations, and reflect gaps between these two groups and between these groups and the entire population of nearly 1600 respondents. Moreover, our results indicate that these gaps have multiple dimensions: they reflect not only the context, skill, and practices of individual users but also the policies of large organizations.\">Abstract and link<\/a><\/p>\n<p style=\"margin-left:.5in;text-indent:-.5in\">Bishop B, and McDaid K, (2008), &#8216;Spreadsheet End-User Behaviour Analysis&#8217;, <em>Proc. European Spreadsheet Risks Int. Grp.<\/em> pp.141-152. <a href=\"http:\/\/arxiv.org\/abs\/0809.3587\" rel=\"nofollow\" title=\"To aid the development of spreadsheet debugging tools, a knowledge of end-users natural behaviour within the Excel environment would be advantageous. This paper details the design and application of a novel data acquisition tool, which can be used for the unobtrusive recording of end-users mouse, keyboard and Excel specific actions during the debugging of Excel spreadsheets. A debugging experiment was conducted using this data acquisition tool, and based on analysis of end-users performance and behaviour data, the authors developed a &#147;spreadsheet cell coverage feedback&#148; debugging tool. Results from the debugging experiment are presented in terms of enduser debugging performance and behaviour, and the outcomes of an evaluation experiment with the debugging tool are detailed.\">Abstract and link<\/a><\/p>\n<p style=\"margin-left:.5in;text-indent:-.5in\">Hermans F, Pinzger M, and van Deursen A, (2011), &#8216;Supporting professional spreadsheet users by generating leveled dataflow diagrams&#8217;, <em>In Proceedings of the 33rd International Conference on Software Engineering<\/em>, pp.451-460, ACM. <a href=\"#\" rel=\"nofollow\" title=\"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. &#13;&#13;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. &#13;&#13;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.\">Abstract<\/a><\/p>\n<p style=\"margin-left:.5in;text-indent:-.5in\">Hermans F, Pinzger M, and Deursen A, (2012), &#8216;Detecting and visualizing inter-worksheet smells in spreadsheets&#8217;, <em>In Proceedings of the 2012 International Conference on Software Engineering<\/em>, pp.441-451, IEEE Press. <a href=\"#\" rel=\"nofollow\" title=\"Spreadsheets are often used in business, for simple tasks, as well as for mission critical tasks such as finance or forecasting. Similar to software, some spreadsheets are of better quality than others, for instance with respect to usability, maintainability or reliability. In contrast with software however, spreadsheets are rarely checked, tested or certified. In this paper, we aim at developing an approach for detecting smells that indicate weak points in a spreadsheet's design. To that end we first study code smells and transform these code smells to their spreadsheet counterparts. We then present an approach to detect the smells, and communicate located smells to spreadsheet users with data flow diagrams. We analyzed occurrences of these smells in the Euses corpus. Furthermore we conducted ten case studies in an industrial setting. The results of the evaluation indicate that smells can indeed reveal weaknesses in a spreadsheet's design, and that data flow diagrams are an appropriate way to show those weaknesses.\">Abstract<\/a><\/p>\n<p style=\"margin-left:.5in;text-indent:-.5in\">Jansen B, and Hermans F, (2014), &#8216;Using a Visual Language to Create Better Spreadsheets&#8217;, <em>Software Engineering Methods in Spreadsheets &#8211; CEUR Workshop Proceedings<\/em>, <a href=\"#\" rel=\"nofollow\" title=\"It is known that spreadsheets are error-prone. It is very difficult for users to get an overview of the design of the spreadsheet, and this is causing errors. Furthermore users are not always aware of the best way to structure a spread- sheet and just start modeling. To address this we will build a visual language to develop spreadsheet models. This enables users to visualize the design of their spreadsheets. A spreadsheet generator will create the spreadsheet based on the specifications made with our visual language. During this process, best practices for structuring spreadsheets are automatically incorporated. There will be a bidirectional link between the model and the associated spreadsheet.\">Abstract<\/a><\/p>\n<p style=\"margin-left:.5in;text-indent:-.5in\">McDaid K, MacRuairi R, Clynch N, Logue K, Clancy C, and Hayes S, (2011), &#8216;Spreadsheets in financial departments: An automated analysis of 65,000 spreadsheets using the luminous technology&#8217;. <em>In Proc. European Spreadsheet Risks Int. Grp<\/em> <a href=\"http:\/\/arxiv.org\/abs\/1111.6866\" rel=\"nofollow\" title=\"Spreadsheet technology is a cornerstone of IT systems in most organisations. It is often the glue that binds more structured transaction-based systems together. Financial operations are a case in point where spreadsheets fill the gaps left by dedicated accounting systems, particularly covering reporting and business process operations. However, little is understood as to the nature of spreadsheet usage in organisations and the contents and structure of these spreadsheets as they relate to key business functions with few, if any, comprehensive analyses of spreadsheet repositories in real organisations. As such this paper represents an important attempt at profiling real and substantial spreadsheet repositories. &#13;&#13;Using the Luminous technology an analysis of 65,000 spreadsheets for the financial departments of both a government and a private commercial organisation was conducted. This provides an important insight into the nature and structure of these spreadsheets, the links between them, the existence and nature of macros and the level of repetitive processes performed through the spreadsheets. Furthermore it highlights the organisational dependence on spreadsheets and the range and number of spreadsheets dealt with by individuals on a daily basis. In so doing, this paper prompts important questions that can frame future research in the domain.\">Abstract and Link<\/a><\/p>\n<p><?php include '..\/includes\/next-prev.php'; ?><\/p>\n","protected":false},"excerpt":{"rendered":"<p>References &#8211; academic Baker K. R., Powell S, Lawson B, and Foster-Johnson L, (2009). &#8216;Comparison of Characteristics and Practices amongst Spreadsheet Users with Different Levels of Experience&#8217;, Omega 37.3, pp.579-590. Abstract and link Bishop B, and McDaid K, (2008), &#8216;Spreadsheet End-User Behaviour Analysis&#8217;, Proc. European Spreadsheet Risks Int. Grp. pp.141-152. Abstract and link Hermans F, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false},"jetpack_shortlink":"https:\/\/wp.me\/P59BC0-nP","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/pages\/1477"}],"collection":[{"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/comments?post=1477"}],"version-history":[{"count":0,"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/pages\/1477\/revisions"}],"wp:attachment":[{"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/media?parent=1477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}