ag-model-auditor

What problem does it solve?

Manually auditing large Excel financial models for hidden formula errors, semantic mismatches between labels and calculations, formatting inconsistencies, broken links, and VBA/Power Query code issues is extremely time-consuming and prone to oversight, leading to costly financial mistakes if errors go undetected.

Core Features & Use Cases

• Comprehensive Formula Auditing: Checks for formula pattern breaks across rows/columns, hardcoded values in formula ranges, and semantic mismatches (e.g. a cell labeled "Total" that uses multiplication instead of SUM) using 12 predefined semantic rules.
• Formatting & Link Validation: Audits inconsistent number formats, mixed fonts, decimal place mismatches, broken hyperlinks, invalid named ranges, and broken data validation rules.
• Code Review for Excel Add-ins: Scans VBA modules, Power Query M code, and Power Pivot DAX measures for common issues like missing error handling, hardcoded paths, and inefficient logic.
• Use Case: For a 100-sheet corporate financial model, use this skill to automatically flag all critical issues in minutes, generating a structured report ready for stakeholder review or compliance checks.

Quick Start

Use the ag-model-auditor skill to run a full audit of your attached Excel financial model file and generate a structured report of all detected issues.