excel_audit_calculations
Identify cells with hardcoded values that should contain formulas in Excel worksheets to maintain calculation integrity and prevent errors.
Instructions
Audit a worksheet to find cells that should contain formulas but have hardcoded values
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| worksheetName | Yes | ||
| suspiciousPatterns | No | Text patterns that suggest a cell should contain a calculation | |
| checkNumericCells | No | Check all numeric cells for potential formulas |