Menu | <<<< | >>>> | The workbook (file) structure for a VORSIM-built model

VORSIM is system of programs for the creation, organization, and management of Excel spreadsheet models. The file structure for a model is consistent with Excel capabilities and the normal organizational requirements of model building. A VORSIM model actually consists of many workbooks (files) besides the model workbook itself. This diagram shows the files for the demonstration model DEMO and the relationships between them. The simulation model itself is the Excel workbook <Demomod.xls> that is created with its own programs and controls for model operations. The definition, data, and equation workbooks are created as part of the model building process. A workbook of indicators is created to add post-solution variables to workbooks of model solutions that have been saved. Buttons controlling operations in workbooks are placed on workbook sheets when the workbooks are first constructed. Values for variables from selected solutions can be compared in workbooks containing charts and pivot tables. Excel reports can be created with methods that move or link solution and other workbook data into the report workbooks. Other workbooks contain banked equations, backup files, etc. The <DirSummary.xls> file which can be created from the Model Manager control screen, lists all files/workbooks in an active model directory by type.