excel-formula-analyzer
CommunityReverse-engineer Excel formulas into DAGs.
Authortylermorganme
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps users understand complex Excel workbooks by reverse-engineering formula dependencies and tracing calculation chains, turning opaque spreadsheets into transparent, auditable logic.
Core Features & Use Cases
- Dependency tracing: Build a directed acyclic graph (DAG) of Excel formulas to see how inputs propagate to outputs.
- Formula auditing: Validate that calculations match expected results and identify potential logic gaps.
- Code generation ready: Provide a structured blueprint that can be translated into reusable Python/TypeScript implementations.
- Use Case: Imagine you have a large workbook with hundreds of interdependent cells; this skill helps you map the entire calculation flow and reproduce it in a programmatic calculator.
Quick Start
To trace dependencies, run the provided Python script: python .claude/skills/excel-formula-analyzer/scripts/trace-formula-dag.py "Workbook.xlsx" "Sheet Name" --columns 16-36,57,58,59
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: excel-formula-analyzer Download link: https://github.com/tylermorganme/crop_plan_2025/archive/main.zip#excel-formula-analyzer Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.