ag-sentry-auditor

What problem does it solve?

Excel workbooks often contain hidden technical errors like broken references, dead named ranges, and invalid data validation rules that can cause calculation failures, incorrect reporting, and broken business workflows, especially in complex or shared models where manual checks are time-consuming and easy to miss issues.

Core Features & Use Cases

• Full Error Sweep: Detects all native Excel error types (#REF!, #VALUE!, #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #SPILL!, #CALC!) across every sheet including hidden sheets, with an intentional error filter to exclude #N/A values deliberately used for chart gap suppression.
• Name Manager Audit: Identifies dead named ranges with broken references, hidden names from add-ins or copied sheets, and scope conflicts.
• Data Validation Audit: Catches invalid validation rules with broken source ranges, missing list references, or erroring custom formulas.
• Circular Reference Check: Identifies unintentional calculation loops, excluding intentional iterative calculation patterns.
• Use Case: Use this skill to audit a quarterly financial model before sharing it with stakeholders to catch hidden errors that could lead to incorrect forecasts or broken reporting.

Quick Start

Use the ag-sentry-auditor skill to run a complete audit of the attached Excel workbook and receive a full report of all critical errors, broken named ranges, and invalid data validation rules.