ag-efficiency-auditor

What problem does it solve?

Excel financial models with overly long, redundant, or volatile formulas are difficult to audit, slow to recalculate, and prone to hidden errors, creating significant maintenance and verification overhead for finance and accounting teams.

Core Features & Use Cases

• Mega-Formula Detection: Flags formulas exceeding 500 characters (critical severity if over 1,000) that are unauditable even when mathematically correct.
• Volatile Function Audit: Identifies high-impact volatile functions (OFFSET, INDIRECT, RAND, etc.) that trigger full workbook recalculation and degrade performance.
• Redundancy Scanning: Catches repeated identical calculations across disjoint row groups that can be consolidated into single helper rows to reduce bloat. Use case: For a 10,000-row financial model with dozens of nested IF statements and OFFSET functions, this skill flags 12 critical Mega-Formulas, 27 volatile function instances, and 3 sets of redundant subtotal calculations, delivering a prioritized list of fixes to improve model speed and auditability.

Quick Start

Use the ag-efficiency-auditor skill to audit the attached Excel financial model for formula complexity, redundant calculations, and volatile function usage, then provide a prioritized list of findings and actionable improvement recommendations.