Understanding other people's models

Top  Previous  Next

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.

1Summarize 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
2OAK can prepare a map of the workbook, to give a high level view of how formulas have been copied across the worksheet.
3OAK 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.