Applies to: RISKOptimizer in @RISK 6.x and Up, Industrial Edition

 

Optimizing “Value” in RISKOptimizer

When setting up an optimization target, RISKOptimizer lets you choose statistics like Mean, StdDev, Percentile, or Value.

• Value refers to the final value of the target cell at the end of a simulation. It mostly duplicates functions like Mean or Percentile but is useful in some cases.

When to use Value:

• If you want to optimize a custom expression involving simulation statistics, you can compute the statistic in a separate cell and then set that cell as the target with Value.

Example:
Suppose you want to optimize the difference between the means of two cells, A1 and A2.

1. In a new cell (say A3), enter:
   =RiskMean(A1) - RiskMean(A2)
   or
   =ABS(RiskMean(A1) - RiskMean(A2))

2. Set A3 as the optimization target and choose Value as the statistic.

RISKOptimizer will now optimize that expression directly, using the simulation statistics you calculated.