evaluate_workbook_scenarios
Compare explicit workbook alternatives read-only, or commit one verified outcome with guarded sum/count checks and rollback protection.
Instructions
Compare explicit alternatives read-only, or commit one exact verified outcome.
scenario_set requires version=1, a Recipe v1 (only sum/count; output is never
written), key_fields, guards=[{metric, scope: overall|each_group, min?, max?}],
and scenarios=[{id, updates: [{key: {...}, values: {...}}]}]. Bounds are inclusive
exact comparisons. Each-group checks include all baseline/candidate groups;
missing baseline groups and empty coverage fail. No optimization or forecasting.
One native table, existing keys/literal updates only, no formulas/key changes.
Commit requires the identical set, selected_scenario id, scenario_token and
expected_workbook_sha256 from comparison; source drift requires a new comparison.
Full metric checks run again on the saved workbook under ChangeSet rollback.
Limits: 5 alternatives, 8 sum/count metrics, 20 guards, 50000 source cells,
1000 targets/49 column spans per alternative, 256KB JSON, sample_limit 1-5.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | compare | |
| filepath | Yes | Reuse supplied server path; NEVER prepend client cwd. Rooted: relative OK; unrooted stdio: absolute, ask if missing. | |
| sample_limit | No | ||
| scenario_set | Yes | ||
| scenario_token | No | ||
| selected_scenario | No | ||
| expected_workbook_sha256 | No |