Example of action for what-if scenarios

3.93K viewsScripting
0

Hi.
I enclose a model with an action which iterates over a list of scenarios, changing for each one a subset of assumptions and storing a subset of results.
Sort of “data table” functionality in traditional spreadsheets, but with the power and flexibility of Quantrix.
You can find brief instructions in the comments to the first matrix in the Model Browser.

0

Brilliant! Thanx so much for the example Luca

Tafadzwa

0

Hi Tafadzwa,
I have extended my example to scenarios over two dimensions (i.e. revenue growth vs. credit conditions). You can define a set of related input variables for each scenario dimension (not just one as in 2-way data table). The script iterates over the two scenario categories scenario1 and scenario2 and stores the result in a two-way matrix.
The model seems to work, but should require additional testing.

0

Hi Luca

Your example is brilliant. Im wondering if with the coming of 4.0 l can do 2way data tables. Actually ,l got an excel model which im converting to quantrix, which needs some of the techniques you just demonstrated.

Thanx

Tafadzwa

0

I thank you, Dominik, for the very useful knowledge of Groovy you are sharing with us.

0

Hi Luca,
Many thanks for you interesting and useful example.

Dominik