Table of Contents
Table
Tables present simulation output data in tabular form. Data can be organized in different ways depending on the dimension of the data.
For instance, a table might display concentrations of three contaminants, for ten time-points. This data can be arranged by time (rows) and contaminants (columns):
Time | Nickel | Lead | Silver |
---|---|---|---|
0.0 | 1 | 2 | 3 |
5.0 | 2 | 8 | 5 |
… | … | … | … |
100.0 | 3 | 9 | 5 |
by contaminants (rows) and contaminants (columns):
Contaminants | 0.0 | 5.0 | … | 100.0 |
---|---|---|---|---|
Nickel | 1 | 2 | … | 3 |
Lead | 2 | 8 | … | 9 |
Silver | 3 | 5 | … | 5 |
If the data is probabilistic the dimension increases to three. With n=1000 iterations, the table would then become:
Time | Nickel/1 | Lead/1 | Silver/1 | Nickel/2 | Lead/2 | Silver/2 | Nickel/n, | Lead/n | Silver/n | |
---|---|---|---|---|---|---|---|---|---|---|
0.0 | 1 | 2 | 3 | 4 | 3 | 2 | … | 5 | 3 | 2 |
5.0 | 2 | 8 | 5 | 2 | 6 | 1 | … | 8 | 6 | 8 |
… | … | … | … | … | … | … | … | … | … | … |
100.0 | 3 | 9 | 5 | 6 | 2 | 4 | … | 9 | 6 | 5 |
Reduction
For probabilistic data, it is more common to display statistics rather than data for each iteration. For example, by showing the mean and standard deviation the probabilistic dimension is reduced from thousands of items to just two:
Time | Nickel/mean | Lead/mean | Silver/mean | Nickel/std dev | Lead/std dev | Silver/std dev |
---|---|---|---|---|---|---|
0.0 | 3 | 1 | 3 | 7 | 9 | 4 |
5.0 | 7 | 3 | 1 | 2 | 6 | 3 |
… | … | … | … | … | … | … |
100.0 | 5 | 3 | 6 | 1 | 8 | 5 |
The same can be done for time: instead of showing all time points, just show the first and last time point:
Time | Nickel/mean | Lead/mean | Silver/mean | Nickel/std dev | Lead/std dev | Silver/std dev |
---|---|---|---|---|---|---|
First | 3 | 1 | 3 | 7 | 9 | 4 |
Last | 5 | 3 | 6 | 1 | 8 | 5 |
If only the last time point is shown, the dimension of the data is reduced so that we can use rows for contaminants instead:
Contaminant | mean, t=100 | std dev, t=100 |
---|---|---|
Nickel | 5 | 1 |
Lead | 3 | 8 |
Silver | 6 | 5 |
Order
When a table is created, AFRY Intelligent Scenario Modelling will automatically determine which dimensions it will have. The user can reduce dimensions or even “collapse” dimensions.
The user can also select the order in which the dimensions of the data are displayed. First, one dimension is selected for rows, then the priority of the column dimensions can be selected.
The following table shows data for the two outputs Weight and Length, where both Weight and Length depend on Country and Gender with the following order:
Row: Outputs Columns: Country, Gender
Output | Sweden/Male | Denmark/Male | Sweden/Female | Denmark/Female |
---|---|---|---|---|
Weight | ||||
Length |
Switching the order of the columns would yield
Row: Outputs Columns: Gender, Country
Output | Male/Sweden | Female/Sweden | Male/Denmark | Female/Denmark |
---|---|---|---|---|
Weight | ||||
Length |
Table types
The base version of AFRY Intelligent Scenario Modelling offers two types of tables:
- General table - General purpose table for normal simulation data.
- Correlation table - Table for displaying correlation coefficients
Editing table properties
This page includes general information about the table.
- Name – Enter a name for the table.
- Comment – A comment for the table, such as a summary of its contents.