Print Email Facebook Twitter Tool-assisted Spreadsheet Refactoring and Parsing Spreadsheet Formulas Title Tool-assisted Spreadsheet Refactoring and Parsing Spreadsheet Formulas Author Hoepelman, D.J. Contributor Hermans, F.F.J. (mentor) Faculty Electrical Engineering, Mathematics and Computer Science Department Software Technology Programme Software Engineering Research Group (SERG) - Spreadsheet Lab Date 2015-11-17 Abstract Spreadsheets have a life-cycle similar to that of other software: they are inherited throughout an organization, are maintained by different users, and evolve over time to meet changing requirements. This leads to increased complexity and technical debt. In software engineering, refactoring is used to combat these problems by improving software structure without altering behavior. This technique can also be applied to spreadsheets. In this thesis we present an improved version of the spreadsheet refactoring tool BumbleBee, extended with six refactorings: Extract Formula, Inline Formula, Introduce Cell Name, Group References, Introduce Aggregate and Introduce Conditional Aggregate. The Inline Formula, Group References and Introduce Conditional Aggregate refactorings were not implemented before and Extract Formula and Introduce Cell Name improve upon previous implementations. To support these refactorings and facilitate future spreadsheet research the formula parser used needed improvements. We implemented these improvements and released the result as the open-source software package XLParser, a stand-alone C# parser for spreadsheet formulas. XLParser was evaluated on more than a million unique formulas from industrial datasets, and successfully parsed 99.999%. Subject spreadsheetsexcelrefactoring To reference this document use: http://resolver.tudelft.nl/uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e Part of collection Student theses Document type master thesis Rights (c) 2015 Hoepelman, D.J. Files PDF Tool-assisted_Spreadsheet ... rmulas.pdf 3.26 MB Close viewer /islandora/object/uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e/datastream/OBJ/view