Reconciling to a template model

Top  Previous  Next

At least one spreadsheet auditor simply keys the assumptions into its own template model, and sees if it gets similar answers.

Steps in the process where OAK may be useful include

1Summarize workbook will deliver a list of all the values that serve as inputs to the model.  These are candidates for inserting into the template model.
2Where the rebuilt model gives a different answer from the one being tested, OAK can analyse the discrepancy between the two and identify its origin.
3Compare workbooks/worksheets, to understand how a new version of the model, which needs to be checked, differs from an older version that has been checked already.