Audit a spreadsheet for formula and model errors
audit_workbookAudits .xlsx workbooks to flag formula errors, broken references, inconsistent formulas, typed-over values, and hidden-sheet risks using static checks and independent recalculation.
Instructions
Audits an .xlsx workbook: error values after an independent recalculation, typed-over formulas, formulas that break the pattern of their neighbours, hard-coded numbers inside formulas, approximate-match lookups, volatile functions, external links, hidden sheets/rows/columns and broken named ranges. Heuristic: it points at where models usually go wrong, it cannot prove a model is right.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to the .xlsx file | |
| limit | No | ||
| recalc | No | Recalculate with an independent engine to find error values (slower on big files) | |
| min_severity | No | LOW |