Authors
David Colver
Abstract
A review of 75 formal audit assignments shows that the effort taken to identify defects in financial models taken from the domain of limited recourse (project) finance is uncorrelated with common measures of the physical characteristics of the spreadsheets concerned.
Sample
This is a multiple regression model of the relationship between the sample spreadsheet characteristics and the number of hours needed to audit them.
The model suggests that average formula complexity is on the verge of joining the number of iterations as a significant contributor to the time taken to complete an audit.
Publication
2011, EuSpRIG
