skills.rest
Sampi314
Sampi314COMMUNITY
Explore all skills by this author →
GitHub

ag-model-auditor

Audit Excel financial models for formula, formatting, link, and code issues.

1|Updated Jun 12, 2026
Search Tags:#audit#excel#financial model#vba#power query#formula validation#spreadsheet review
One-click install
npx skills add https://github.com/Sampi314/Sam-Plugin-Marketplace --skill ag-model-auditor
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ag-model-auditor
Source: https://github.com/Sampi314/Sam-Plugin-Marketplace/tree/main/Audit%20General/skills/ag-model-auditor
Command: npx skills add https://github.com/Sampi314/Sam-Plugin-Marketplace --skill ag-model-auditor

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pywin32, openpyxl, and includes scripts (resource) and references (resource) components.

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.

Frequently Asked Questions about ag-model-auditor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I audit an Excel financial model for formula errors and semantic mismatches?▼

Auditing an Excel financial model automatically detects formula errors, semantic mismatches between labels and calculations, and formatting inconsistencies. It applies 12 predefined semantic rules to flag issues and generates a structured report for stakeholder review.

What is the best way to review VBA and Power Query code in Excel spreadsheets?▼

The best way to review VBA and Power Query code in Excel spreadsheets is to scan modules for missing error handling, hardcoded paths, and inefficient logic. This process identifies common add-in issues to prevent calculation mistakes before financial close.

Do I need a Windows environment with Excel installed to run automated spreadsheet reviews?▼

Yes, you need a Windows environment with Excel installed to run automated spreadsheet reviews. The process relies on pywin32 COM automation checks paired with AI judgment and the openpyxl Python dependency to validate formulas and formatting.

Can I check broken hyperlinks and formatting inconsistencies in a corporate financial workbook?▼

Yes, you can check broken hyperlinks and formatting inconsistencies in a corporate financial workbook. The audit validates inconsistent number formats, mixed fonts, decimal place mismatches, invalid named ranges, and broken data validation rules automatically.

How does automated formula validation handle ambiguous calculations in financial models?▼

Automated formula validation handles ambiguous calculations in financial models by pairing pywin32 COM automation checks with AI judgment. This combination detects semantic mismatches, like a cell labeled "Total" using multiplication instead of SUM, ensuring accurate spreadsheet logic review.

Related Skills

Explore More Finance & Accounting Skills→
Awannaphasch2016Awannaphasch2016

mcp-integration

Register MCP servers via .mcp.json and escalate configuration through CLAUDE.md and hooks.

Community
Advanced
Sampi314Sampi314
1

ag-audit-manager

Orchestrate 12 audit agents to review Excel financial models and consolidate findings.

Community
Advanced
pingqLINpingqLIN

power-bi-dax-best-practices

Review DAX formulas in Power BI files for best practices and patterns.

Community
Intermediate
Sampi314Sampi314
1

ag-ai-auditor

Audit Excel financial models for AI-introduced errors like formula-as-text and broken links.

Community
Advanced