Home | Overview | Model Builder | Solution Manager | Model Manager | A VORSIM Model

The Report Writer, Data Analysis, and Solution Charts control screen provides several methods of moving data to user-created reports from models, solutions, and data files. Report workbooks can be automatically updated.

[Load Any File] – Load any file in model directory. [Load Equation Workbook], [Load Data Workbook] – Load equation, data workbooks. [Chart Parameter Block] – Create charts of parameters from equation matrices. [Chart/Trend Data Value] – Create chart/trend line for a selected variable in data workbook. Data can be extrapolated to end of model projection period. [Chart Block of Data] – Create charts of adjacent variables from data workbook. [Regression Analysis of Data] – Multiple regression analysis of variables in data workbook. Simple regression analysis is made available within VORSIM. [Create Supply Demand Report] – Create a report which uses model elasticities and solution values from 2 solutions to calculate welfare impacts and show changes in supply and demand. [Create New Movelist Report (*.mlt)],  [Load Movelist (*.mlt); Modify, Update] – Create, load/modify ‘Movelist’ files that move data from one workbook to another (e.g. from a solution workbook to a report). This procedure is useful whenever automated data transfer is needed between any workbooks. [Chart Solution Time Series Variable(s)] – Create time series graphs of solution variables. [Load a Solution], [Chart Cross-Section – Solution Variables] – View a solution workbook, chart solution values. [List All Files] – Create a list of all files in the model directory. [Create New (Empty) Report (*.rpt)], [Load an Existing Report (*.rpt)] – Create and open Excel report workbooks. Report workbooks are user-designed. Movelists or items on the VORSIM pull-down menu can be used to move model solution and other data into reports. Once model data has been moved into a report, the data can be automatically updated. |VORSIM| menu in Report Writer: Most options are ways of moving workbook data to user-built reports. Data can be copied to, or linked to reports (or any file). Once data has been added to a report sheet by any of these methods (or movelists), it is possible to automatically update the data without copying it again. This is possible by creating a comment containing the source information for every data block transferred. Other commands set data column width, clear text boxes from sheet, or make comments visible/invisible.