Calculation

Use Run Iterations to generate results from your Inputs definition. This page covers what happens inside Excel for each scenario, how that differs from probabilities and strategies, how macros fit in, and where to go once you have results.

Running iterations

Before you assign probabilities (and refine signals), click Run Iterations in the task pane from the Inputs or Analysis flow. That walk-through calculates every combination of decision and uncertainty cases you defined and captures your tracked results for each scenario.

Running iterations first gives you a full set of scenario results to inspect. Probability weights you set later describe how much attention each uncertainty path deserves when you summarize expected values and distribution-style views—they do not replace having up-to-date scenario numbers from the workbook.

What the iteration loop does

Bear Decisions walks your workbook through each combination of decision cases and uncertainty cases you defined on the Inputs tab. For each scenario, it writes the corresponding input values, lets Excel recalculate (including any enabled macro hooks—see Automatic Macro Execution), then captures tracked results you configured.

At the end of the calculation process the original inputs are returned to the input cells (and macros re-run if applicable).

Probabilities, strategies, and signals

Assigning case probabilities, configuring strategies and timings, and interpreting signals do not, by themselves, require re-executing every Excel iteration. Those layers reshape how scenario weights combine and how recommendations are derived when you analyze results—they are applied when summarizing and optimizing against the scenario grid, not by rerunning the full combination traversal every time you adjust a likelihood or strategy rule.

When you change structural inputs (new cases, different cells, model logic) re-run Run Iterations again so stored scenario numbers stay aligned with the workbook. If you open Analysis without an up-to-date grid, the task pane can warn you.

Macros during calculation

If your model depends on VBA during each recalculation, configure the adjustment to your macro following the integration patterns in Macros and adjust the evaluation process as described under Settings & Configuration before you trust the generated results.

Next Steps