Reconcile a total
reconcile_totalsSum a selected numeric column and compare it against an expected total within a tolerance to verify CSV/XLSX data; cached formula results are labeled and counted, not recalculated.
Instructions
Sum one selected numeric column and compare it with a supplied control total and tolerance. Formulas are not calculated; usable cached results are labeled and counted.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | Exact normalized column name from inspect_workbook. | |
| file_path | Yes | CSV/XLSX path relative to KINGWORKBOOK_ROOT. | |
| tolerance | No | Allowed absolute difference as a decimal string; defaults to zero. | 0 |
| sheet_name | No | Optional sheet name in an XLSX workbook. | |
| expected_total | Yes | Expected total as a decimal string, for example 1250.00. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| notes | Yes | ||
| column | Yes | ||
| status | Yes | ||
| data_rows | Yes | ||
| file_path | Yes | ||
| tolerance | Yes | ||
| difference | Yes | ||
| sheet_name | Yes | ||
| computed_total | Yes | ||
| expected_total | Yes | ||
| within_tolerance | Yes | ||
| blank_values_skipped | Yes | ||
| numeric_values_included | Yes | ||
| nonnumeric_values_skipped | Yes | ||
| formulas_without_cached_values | Yes |