ag-cartographer

What problem does it solve?

Excel workbooks, especially complex financial or operational models, often act as black boxes where it is nearly impossible to trace how calculations flow between sheets, or identify hidden structural dependencies like named ranges, data validations, and conditional formatting rules. This makes auditing, debugging, and documenting models extremely time-consuming and error-prone.

Core Features & Use Cases

• Full Dependency Tracing: Maps both visible formula-layer references (direct cell and cross-sheet links) and hidden shadow-layer dependencies (data validations, named ranges, tables, conditional formatting) across entire workbooks.
• Automated Flowchart Generation: Produces Mermaid flowcharts for workbook-level maps, sheet-level section maps, critical calculation paths, and shadow dependency maps for easy visualisation.
• Comprehensive Documentation: Generates a full dependency register and shadow inventory to support model audits, governance reviews, and onboarding for new team members.
• Use Case: For a 30-sheet financial model used for company forecasting, use this skill to quickly map how input assumptions flow through revenue and cost calculations to final output metrics, and flag any broken named ranges that could cause silent errors in dropdown menus.

Quick Start

Use the ag-cartographer skill to map all dependency flows and generate Mermaid flowcharts for the uploaded Excel model file.