Example of action for what-if scenarios

4.04K 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

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.

You are viewing 1 out of 5 answers, click here to view all answers.