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. You can add a graph by clicking on the in the dropdown and selecting Add a New Graph (this will open the Graph Series Property Panel).
• 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

Once you add more than one page you will also see an icon to edit multiple pages in the collection (collections mixing graphs and tables do not have common elements to edit). 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.
• Data Orientation lets you specify which way time runs.
  • Vertical Time, if checked, will make time run down, so that each column is a variable.
  • Horizontal Time, if checked, will make time run across, so each row is a variable.
• Comparative - select this check box to create a comparative table, which shows successive runs.
• Stash Data - checking this option adds the icon to the table that, when clicked, is used to keep the values in the table for the current run when a new run is made. See Stash Data for more discussion.
• Show correlations across runs
  • 
  • If checked this show the correlation of the selected variables with the specified common variables. Click on to select the common variable. For more information on correlations see Correlation Graph. This option is only available for comparative tables.

Item List

• Group items by Run, if checked, will display all of the included variables for each run together, then display them for the next run. If not checked all runs for each variable will be displayed together.
• 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 will open the Find window to select a variable to add.
• Delete will delete the currently selected item in the list.
• Add Blank will add a blank line to the table creating a space. If grouping by run adding a blank as the last entry will create a space between runs.
• Expand If you have selected a series with a * in it, the button will appear. This will expand the * showing each of the individual elements (e.g. sales[North], sales[South] from sales[*]).
• 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 (you can arrays with ?(Wildcards) or * for all elements).

  Tell me how

  Choose a variable in one of the following ways:

  • Click on the then in the Find window that opens click on the variable you want. If the variable is arrayed you will be asked to select array elements, placeholders or wildcards.
  • If you have already selected a variable, its name will appear in the variable box and you can replace it by:
    • In the Variable box, begin typing the name of the variable you want to add. A list of matching variables will appear. Click on the variable you want (or use the arrow keys to move 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. If it is arrayed you will be asked to select an element.
    • 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.
• Number Formatting - click on this to specify the number format to be used for the variable. This will open the Format Variable dialog box.

Percentiles

The option to show percentiles is only available if comparative has been selected. 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 will be treated as 0 and greater than 100 as 100.

Reporting Options

• Financial format will display tables the way information is normally displayed in financial reports (flows accumulated over the reporting period and values displayed for the end of the period).
• Computational format will display values in tables as they are computed so that it is easy to do analysis on them. Flows and converters will be reported instantaneously based on the stock values at each time. That is, the stock values at a time will be reported along with the flow values resulting from those stock values. This is the same way that things appear in graphs.
• Custom format allows you to choose more specific 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.
• Start Time is the first time that will be shown in the table. If this is blank, it will default to the start time specified for the model in the Model Settings Properties Panel. If this is less than the start time for the model then the model start time will be used.
• Stop Time is the last time that will be shown in the table. If this is blank, it will default to the stop time specified for the model in the Model Settings Properties Panel. If this is greater than the stop time for the model then the model stop time will be used.

Note Though you can enter any value for start and stop time, usually an integer will work best so as not to cause accumulations to occur over non-standard intervals.

• Interval - choose a time interval for which you want to display values.
  • Every DT Click Every DT to display values at the model's time interval setting.