**Home | Overview | Model Builder | Solution
Manager | Report Writer | Model Manager**

A VORSIM {1}, {2} – Sheets containing lagged data for simulation of the model DEMO. {Model} – The model sheet with yellow cells containing equations, white cells containing exogenous data, green cells containing control variables that are changed to reach a solution, and red cells containing equations targeted for solution by the Excel Solver. {Solver parameters} – (Not shown) Convergence tolerances, iteration limits, etc. for the Solver. This sheet is deleted when the model has been configured for solution and the Solver has been installed. {Current solution values} – A sheet containing tables of beginning and final solution target and control variables for each time period for the current solution. This information helps verify a satisfactory solution or diagnose solution problems if a model does not converge to equilibrium. A solution is saved as a named workbook using the formats on the model sheet. The solution workbook has a series of sheets (one sheet for each time period). The time of solution generations is entered automatically when the solution is saved. Textboxes containing explanations of the model have been added to the model workbook. This is an example of the use of normal Excel features in a VORSIM-built spreadsheet model. |