Spreadsheet Refactoring

Patrick O'Beirne

Spreadsheet Refactoring

Software Engineering 2010-09-09 v1

Authors: Patrick O'Beirne

Abstract

Refactoring is a change made to the internal structure of software to make it easier to understand and cheaper to modify without changing its observable behaviour. A database refactoring is a small change to the database schema which improves its design without changing its semantics. This paper presents example 'spreadsheet refactorings', derived from the above and taking into account the unique characteristics of spreadsheet formulas and VBA code. The techniques are constrained by the tightly coupled data and code in spreadsheets.

Keywords

spreadsheet engineering relational database program analysis

Cite

@article{arxiv.1009.1412,
  title  = {Spreadsheet Refactoring},
  author = {Patrick O'Beirne},
  journal= {arXiv preprint arXiv:1009.1412},
  year   = {2010}
}

Comments

14 Pages

Related papers

View all related →