|
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
| 1 | Summarize 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. |
| 2 | Where the rebuilt model gives a different answer from the one being tested, OAK can analyse the discrepancy between the two and identify its origin. |
| 3 | Compare 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. |
|