explain_recipe_delta
Explains sum/count changes between two Excel source versions by recomputing a shared recipe and reporting added, removed, and updated contributions without modifying either file.
Instructions
Explain sum/count changes by source identity, without modifying either file.
Recompute one shared Recipe v1 on two distinct .xlsx source versions. Requires
nonblank unique key_fields (exact headers) on every source data row, even if
excluded by recipe filters. Supports at most 8 metrics, all sum/count.
Returns added/removed/updated contributions, group changes and bounded physical
source-row examples. Numeric evidence uses exact decimal strings. Recipe float
differences are explicit numeric_adjustment values, not business explanations.
Optional metric selects one exact output alias; group must give all group_by
fields with exact literal values. All calculations/checks remain complete;
sample_limit (1-10) only bounds examples and omitted contributions are reported.
Pin both source sha256 values and recipe_sha256 from a previous response for
repeatable drilldown. The explanation_token is an integrity fingerprint, not
authorization or a commit token. Does not validate saved report cells, infer
historical recipe definitions, evaluate formulas or establish business causes.
Limits per source: 50,000 table cells, 64 columns, 10,000 recomputed result cells.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| group | No | ||
| metric | No | ||
| recipe | Yes | ||
| key_fields | Yes | ||
| sample_limit | No | ||
| after_filepath | Yes | Reuse supplied server path; NEVER prepend client cwd. Rooted: relative OK; unrooted stdio: absolute, ask if missing. | |
| before_filepath | Yes | Reuse supplied server path; NEVER prepend client cwd. Rooted: relative OK; unrooted stdio: absolute, ask if missing. | |
| expected_after_sha256 | No | ||
| expected_before_sha256 | No | ||
| expected_recipe_sha256 | No |