Menu | <<<< | >>>> | The VORSIM pull–down menu on the Report Writer, Data Analysis screen

The VORSIM pull-down on the Reports, Data Analysis control screen has seven general items.

|Set Data Column Width| - Sets the widths of all columns in the data workbook so that numbers are all displayed. If this is not done, sometimes numbers may, for example, be larger than the number of places allowed by column widths and you would see ##### in cells rather than numbers. This command corrects that situation for the data workbook automatically.

|Clear Textboxes from Sheet| - Removes all of the textboxes from an active sheet.

The next four commands (two groups) operate on *.tmp reports. The first two add or change *.tmp report links to solutions or other workbooks. The second two copy data from workbooks to *.tmp report workbooks that you have created. When invoked, these commands bring up menus directing you what to do.

|Copy Matrix of Data from Excel File to Model Data Workbook| - This command allows you to automate the movement of model data from an Excel workbook to your model data workbook. Data in the Excel workbook must be in matrix form with model sheets as column heads and model categories as row heads. The left top cell must contain the variable name.