Please enable JavaScript to view this site.

Vensim Help

If you ask to export a dataset that was created during a sensitivity simulation you will be asked:

If you answer No Vensim will continue to export only the run results using the dialog described above.  If you answer Yes you will get a different set of options.

Export to determines what file the data will be written to.  You can only export sensitivity results to tab delimited files.

Encoding determines the text encoding of the output file. See the discussion for exporting above.

Simulation index/time running determines the direction of the simulation index or time, depending on the setting of Modify variable names by below.  If this is down (the default) each row will represent either an experiment or, if you have checked Simulation number under Modify variable names, a time.

Write numbers in European format allows you to output numbers using the , as the decimal separator.

Export only final time, if checked, suppresses the reporting of values by time.  If this is checked, the items below it are ignored since it is not necessary to modify any names.

Modify variable names by is used to determine how sensitivity results are mapped to a two dimensional array.  By default sensitivity results are modified by time (T1 Profit, T2 Profit and so on).  See the example below for more detail.

Modify names using determines how the modified name appear.  If you have the variable profit[south] then this would become T1 profit[south] or profit[south,t1].  See the example below for more discussion.

Example

Suppose that you performed sensitivity analysis for a total of three simulations on a model that runs from time 0 to 1 varying target margin.  The results might look like this

               Time 0        Time 1
Simulation 1
target margin        .2
Profit[south]         10        20
total profit        24        18
Simulation 2
target margin        .1
Profit[south]         20        18
total profit        26        28
Simulation 3
target margin        .3
Profit[south]         30        10
total profit        44        8

By selecting to see the results at the final time and choosing Across for Simulation index/Time running you would get

Simulation1        2        3
target margin.2        .1        .3
Profit[south]20        18        10
total profit18        28        8

and it would be possible to transpose this by choosing Down for Simulation index/Time running.

If you ask to see all the results, again running the simulation index down, modifying variables by time and choosing the prefix option you would get:

Simulation1        2        3
target margin.2        .1        .3
T1 Profit[south]10        20        30
T2 Profit[south]20        18        10
T1 total profit24        26        44
T2 total profit18        28        8

the same thing choosing the final subscript option would yield:

Simulation1        2        3
target margin.2        .1        .3
Profit[south,T1]10        20        30
Profit[south,T2]20        18        10
total profit[T1]24        26        44
total profit[T2]18        28        8

If you choose to see all the results modifying the variables by the simulation index and choosing the prefix option you would get:

Time        0        1
S1 target margin.2
S2 target margin.1
S3 target margin.3
S1 profit[south]10        20
S2 profit[south]20        18
S3 profit[south]30        10
S1 total profit24        18
S2 total profit26        28
S3 total profit44        8

Finally choosing the same options except asking to see the simulation numbers as a final subscripts gives:

Time        0        1
target margin[S1].2
target margin[S2].1
target margin[S3].3
profit[south,S1]10        20
profit[south,S2]20        18
profit[south,S3]30        10
total profit[S1]24        18
total profit[S2]26        28
total profit[S3]44        8

All of the formats can be transposed and all are just different representations of the same data.  Which one is most convenient depends on what you plan to do with the results.  If you want to work further with them in Vensim, the last format may prove to be the most useful.