2026-09-19T10:47:52Z https://www.ideals.illinois.edu/oai-pmh

oai:www.ideals.illinois.edu:2142/31155 2023-07-10 col_2142_10761 col_2142_5131 com_2142_10755 com_2142_234 com_2142_5130

text Dig, Daniel Badame, Sandro 2012-05-22T00:31:32Z 2012-05-22T00:31:32Z 2012-05 2012-05-22T00:31:32Z 2012-05 The number of end-users who write spreadsheet programs is at least an order of magnitude larger than the number of trained programmers who write professional software. We studied a corpus of 3691 spreadsheets and we found that their formulas are riddled with the same smells that plague professional software: hardcoded constants, duplicated expressions, unnecessary complex- ity, and unsanitized input. These make spreadsheets difficult to read and expensive to maintain. Like refactoring of object-oriented code, refactoring of spreadsheet formulas can be transformative. In this paper we present seven refactorings for spreadsheet formulas imple- mented in RefBook, a plugin for Microsoft Excel. To evaluate the usefulness of RefBook, we employed three kinds of empirical methods. First, we per- formed a Retrospective Case Study on the EUSES Spreadsheet Corpus with 3691 spreadsheets to determine how often we could apply the refactorings supported by RefBook. Second, we conducted a User Survey with 28 Excel users to find out whether they preferred the refactored formulas. Third, we conducted a Controlled Experiment with the same 28 participants to measure their productivity when doing manual refactorings. The results show: (i) the refactorings are widely applicable, (ii) users prefer the refactored formulas, and (iii) RefBook is faster and safer than manual refactoring. On average RefBook is able to apply the refactorings in less than half the time that users performed the refactorings manually. 92.54% of users introduced errors or new smells into the spreadsheet or where unable to complete the task. Item withdrawn by Mark Zulauf (zulauf@illinois.edu) on 2012-04-23T16:15:46Z Item was in collections: University of Illinois Theses & Dissertations (ID: 1) No. of bitstreams: 1 Badame_Sandro.pdf: 310778 bytes, checksum: c60f9b20e2dc64f87dcd8e9a23202991 (MD5) Made available in DSpace on 2012-05-22T00:31:32Z (GMT). No. of bitstreams: 2 Badame_Sandro.pdf: 310788 bytes, checksum: 95ee4724b64a42d55a6d6124b5cab667 (MD5) license.txt: 4062 bytes, checksum: 6dbdf60a208d9f296042bd0f5b1fa4e0 (MD5) http://hdl.handle.net/2142/31155 en Copyright 2012 Sandro Badame refactoring end-user spreadsheets Microsoft Excel code smells Refactoring meets spreadsheet formulas Computer Science 1434 Computer Science 0112 University of Illinois at Urbana-Champaign Thesis M.S. MS:Computer Science -UIUC 10KS0112MS