Developing spreadsheet models

Top  Previous  Next

Many OAK users will be preoccupied by developing significant spreadsheets.  Steps in the process where OAK may be useful include

1Summarize workbook, to deliver a list of all the values that serve as inputs to the model.  These are candidates for inclusion in any documentation that is being prepared to accompany the model.
2OAK's various extensions to Excel's facilities for manipulating names, that address several obstacles that deter many analysts from expressing models in meaningful names rather than less meaningful coordinates.
3Compare workbooks/worksheets, to establish a version history if one has not been maintained during the development.