A review of spreadsheet error reduction techniques

Abstract

Academic and practitioner research shows that spreadsheet errors are prevalent in spreadsheet models and that occasionally these errors cause organisations significant financial loss. A considerable body of research literature now exists on spreadsheet errors and methods to reduce the impact of these errors through technical or organisational approaches. This paper critically examines the literature on spreadsheet error reduction methods and suggests areas and directions of research that would benefit the development of the specific spreadsheet research projects and assist in the mitigation of spreadsheet error.