Table Properties
Use the Table Settings tab of the Properties panel to view and edit the properties of the selected table. Use the Table Styles Tab to specify colors and fonts. (See Getting Started Online for differences in online editing).
Table Settings tab
- Add/delete page - click or to add or delete a page.
- Previous/next page - click or to move to the previous or next page.
You can reorder pages by clicking on and rearranging the sequence in the Reorder Pages
See Pages Styles (Interface)for more discussion of the pages.
Table Options
- Title - use this option to enter a title for the table.
- Selection Label specified the label that will be used if the table pages are selectable using tabs or a dropdown list. This is only visible when working on the interface and when there are multiple tables included.
- Mark for Export - check this to have the table available for export in the Export Data dialog box
- When checked, fill in the name you'd like to refer to the table by for selection during export setup.
- Comparative - select this check box to create a comparative table, which shows successive runs.
- Manage Comparative Data will open the Data Manager allowing you to remove or reorder runs. This button is only active when Comparative is checked.
-
Preserve Table Data will preserve the data currently displayed in the table by specifying specific variable and run combinations. After clicking on this, the table will no longer change when you make new runs and will not be emptied when you restore outputs. To clear a table that you have preserved this way you will need to click on Release Table Data.
-
Release Table Data becomes available if click on Preserve Table Data above. If the table was previously comparative (and there is more than one run preserved) the table will again be marked comparative.
-
Note Releasing table data can't be completely undone. If you are releasing data from runs that are marked locked in the data manager those runs will be permanently deleted.
-
Series List
- Vertical/Horizontal Time - choose one to orient the table to show time in a row or column.
- Item List - this list shows the current list of items in the table. Select an item to set its Type, Variable, Run, and Header Text.
- Add/Delete Item - click or to add or delete an item. Click the item to delete it.
- Type - choose Values and enter a variable, or choose Blank to create a blank column or row.
-
Variable - choose a variable for the selected item.
Tell me how
Choose a variable in one of the following ways:
- In the Variable box, begin typing the name of the variable you want to add. A list of matching variables will appear. Click the variable you want, (or arrow to it) and press Enter.
- Click the Find icon at the top of the Properties panel and begin typing the name of the variable you want to add. A list of matches will appear. Drag the name you want to the Variable box.
- Ctrl-drag (⌘-drag on Mac) directly from the model to the Variable box.
- Run - choose a simulation run to show for the selected item. If you choose something other than Current Run, the selected run is locked and appears each time you run the simulation.
- Header Text - use this option to enter text to appear along the item's column or row.
Percentiles
The option to show percentiles is only available if comparative has been selected and you are working in the model window. Percentiles are displayed for all times.
Show percentiles, if selected, will display percentile values across all runs rather than values from individual runs. This option is only available for comparative tables.
Include mean in table, if checked, will display the arithmetic average across runs in the table. The minimum, maximum, and median can be included by specifying the percentiles 0, 50, and 100 respectively, and the labeling with reflect this.
Include standard deviation in table, if checked, will display the standard deviation across runs.
Include interquartile range in table, if checked, will include the difference between the 25th and 75th percentile values.
Comma separated list of percentiles is the list of what will be displayed. Use 0 for the minimum, 50 for the median and 100 for the maximum. You can include as few or many as you want. Values less than 0 wil be treated as 0 and greater than 100 as 100.
Reporting Options
- Show values at start/end of interval - choose whether values should be shown at the start or the end of the interval.
- Show instantaneous flow values/flows accumulated over interval - choose whether to show an accumulated value or to show the current value.
- Interval - choose a time interval for which you want to display values. Click Every DT to display values at the model's time interval setting.
- Time - if you set the model's Time Unit to months, select the Use Month Names check box to use month names in the time rows or columns.