|
Many more senior spreadsheet users don't want to develop models themselves, nor do they have time to check every cell in them, but they do want a means of understanding quickly what is going on inside them and understanding the key calculations.
| 1 | Summarize workbook, which will prepare a table providing the main statistics of the workbook: number of worksheets, distinct formulas and so on. This gives some idea of how big a spreadsheet is |
| 2 | OAK can prepare a map of the workbook, to give a high level view of how formulas have been copied across the worksheet. |
| 3 | OAK can prepare concise reconstructions of fragments of the spreadsheet that perform particular calculations, giving some idea of what a segment of a model is seeking to do, and identify the inputs it uses. |
|