ag-architect-auditor

What problem does it solve?

This Skill solves the problem of fragile, unmaintainable Excel financial models that break when extended (e.g., adding a new forecast year), have mixed input/calculation/output layers, or use un-auditable "black box" mega-formulas that hide errors and make modifications risky.

Core Features & Use Cases

• Structural Integrity Audit: Evaluates sheet role separation, cross-sheet dependency maps, and time axis consistency to catch architectural flaws that cause silent errors.
• Scalability & Modularity Checks: Identifies hard-coded aggregation ranges, fixed-period logic, and condensed mega-formulas that prevent easy model extension or step-by-step auditing.
• Use Case: A financial planning team needs to extend a 5-year revenue forecast model to 7 years; this Skill flags hard-coded SUM ranges and date spine misalignments that would produce incorrect results if extended manually.

Quick Start

Use the ag-architect-auditor skill to run a full structural audit of the attached 2024-2028 operating expense forecast Excel model to identify scalability risks and modularity gaps.