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.|