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.