check_formulas
Audit spreadsheet formulas structurally without calculating: detect broken references, #NAME? errors, circular references, inconsistent patterns, hardcoded numbers, and volatile functions, grouped by issue type.
Instructions
Audit formulas structurally (nothing is calculated). Reports: broken references (#REF! or a missing sheet), unknown names (#NAME?), cells currently showing error values, circular references reachable through direct cell/range references, formulas that differ from the pattern (R1C1) of the formulas directly above AND below them in the same column, typed numbers sitting inside a column of formulas, hardcoded numbers inside arithmetic (e.g. =A2*1.18), and volatile functions (NOW, TODAY, RAND, OFFSET, INDIRECT ...). Results are grouped per kind and capped by max_issues. Use sheet= to check one sheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| sheet | No | ||
| max_issues | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |