NONSIM
Basic Overview
AVAILABLE SINCE 6.0
Description | The NONSIM function returns the value for the inserted node with no assumptions applied. All nodes that affect this input node will have assumptions applied. |
Signature | NONSIM(Node [, useVariablesFrom]) |
Parameters |
|
Limitations |
|
Example 1
Project default variables
$MY_VAR = 10
Nodes:
Node 1
Year | Measure |
---|---|
2020 | $MY_VAR |
2021 | $MY_VAR |
2022 | $MY_VAR |
2023 | $MY_VAR |
Node 2
Year | Measure |
---|---|
2020 | 1 |
2021 | 1 |
2022 | 1 |
2023 | 1 |
Result Node = Node 1 * Node 2
Year | Measure |
---|---|
2020 | 10 |
2021 | 10 |
2022 | 10 |
2023 | 10 |
Note: Results above are the baseline results, i.e. with no assumptions applied.
Variable override via scenario and assumptions
$MY_VAR = 20
Node 1 (with overridden $MY_VAR as 'Base' and activated assumptions as 'Change')
Year | Base | Change | Result |
---|---|---|---|
2020 | 20 | 0 | 20 |
2021 | 20 | 10 | 30 |
2022 | 20 | 20 | 40 |
2023 | 20 | 30 | 50 |
Node 2 (with the initial measures as ‘Base’ and activated assumptions as ‘Change’)
Year | Base | Change | Result |
---|---|---|---|
2020 | 1 | 1 | 2 |
2021 | 1 | 2 | 3 |
2022 | 1 | 3 | 4 |
2023 | 1 | 4 | 5 |
Result Node (with the results of the calculation as ‘Base' and activated assumptions as 'Change’)
Year | Base (Node 1 * Node 2) | Change | Result |
---|---|---|---|
2020 | 20 * 2 | 5 | 45 |
2021 | 30 * 3 | 5 | 95 |
2022 | 40 * 4 | 5 | 165 |
2023 | 50 * 5 | 5 | 255 |
Calling the NONSIM function when calculating the model for the Scenario
NONSIM('Result Node') = NONSIM('Result Node', “SCENARIO”)
Year | Base (Node 1 * Node 2) |
---|---|
2020 | 20*2=40 |
2021 | 30*3=90 |
2022 | 40*4=160 |
2023 | 50*5=250 |
NONSIM('Result Node', “PROJECT”)
Year | Base (Node 1 * Node 2) |
---|---|
2020 | 10*2 = 20 |
2021 | (10+10)*3 = 60 |
2022 | (10+20)*4 = 120 |
2023 | (10+30)*5 = 200 |