excel-variance-analyzer — Claude Code skill: setup and overview
excel-variance-analyzer is a Claude Code skill that compares budget and actual figures in Excel, flags variances, builds waterfall charts, and identifies root causes.
MIT 3 installs ★ 2,935 updated 2026-11-01
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a claude-codeWhat excel-variance-analyzer does
This skill automates budget vs actual comparisons inside spreadsheet workflows. It calculates dollar and percentage gaps, flags favorable and unfavorable movements, and applies materiality thresholds so noise is filtered out. Breakdowns can be grouped by reporting period or cost center.
For management presentations, the skill produces waterfall charts illustrating the bridge from target budget to actual figures. If a budget line contains zero, percentage math breaks without explicit IF formulas for division by zero. When the chart of accounts shifts, you must supply a category mapping table to keep comparisons aligned.
Analysis depends on having structured budget and actual data by department or cost center. The skill references calculation logic from references/variance-formulas.md to assemble exception reports for finance leads.
What it helps with
- calculate absolute and percentage variances between budget and actual spend
- generate variance waterfall charts for executive reviews
- filter out immaterial discrepancies using threshold rules
- identify specific departments and line items driving cost overruns
Example prompts for the agent
- Analyze why we missed budget by $500K this month
- Which departments are over budget YTD?
- Run an actual vs budget variance check and flag major differences
How to install excel-variance-analyzer
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a claude-code2Manually: put the files in place
~/.claude/skills/excel-variance-analyzer/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/excel-variance-analyzer/
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a codex2Manually: put the files in place
.agents/skills/excel-variance-analyzer/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a cursor2Manually: put the files in place
.cursor/skills/excel-variance-analyzer/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install jeremylongshore/tons-of-skills-marketplace skills/.curated/excel-variance-analyzer2Manually: put the files in place
.github/skills/excel-variance-analyzer/SKILL.md1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a gemini-cli2Platform CLI
gemini skills install https://github.com/jeremylongshore/tons-of-skills-marketplace --path skills/.curated/excel-variance-analyzerManually: put the files in place
.devin/skills/excel-variance-analyzer/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about excel-variance-analyzer
How to install excel-variance-analyzer in Claude Code?
Run npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a claude-code. The tool installs into your Claude Code skills directory.
What does excel-variance-analyzer do?
It compares planned budgets against actual spreadsheet numbers, flags material deviations, and generates variance waterfall charts showing root causes.
What inputs does the skill require to run?
You need budget and actual data broken down by period and category, along with an established department or cost center structure.
Source text
SKILL.md · MIT
--- name: excel-variance-analyzer description: 'Analyze budget vs actual variances in Excel with drill-down and root cause analysis. Use when performing variance analysis or explaining budget differences. Trigger with phrases like ''excel variance'', ''analyze budget variance'', ''actual vs budget''. ' allowed-tools: Read, Write, Edit, Grep, Glob, Bash(cmd:*) version: 1.22.0 author: Jeremy Longshore <[email protected]> license: MIT tags: - business - excel-variance compatibility: Designed for Claude Code --- # Excel Variance Analyzer ## Overview Performs comprehensive budget vs actual variance analysis with automated drill-down, root cause identification, and executive reporting. ## Prerequisites - Excel or compatible spreadsheet software - Budget data by period and category - Actual results for comparison - Cost center or department structure ## Instructions 1. Import budget and actual data into comparison template 2. Calculate absolute and percentage variances 3. Apply materiality thresholds for flagging 4. Create drill-down by category, period, or cost center 5. Generate variance waterfall chart for executive reporting ## Output - Variance summary with favorable/unfavorable indicators - Materiality-filtered exception report - Waterfall chart showing budget-to-actual bridge - Drill-down by category or cost center ## Error Handling | Error | Cause | Solution | |-------|-------|----------| | Missing periods | Data gaps | Fill with zeros or interpolate | | Percentage calc error | Zero budget | Use IF to handle div/0 | | Misaligned categories | Changed chart of accounts | Create mapping table | ## Examples **Example: Monthly P&L Variance** Request: "Analyze why we missed budget by $500K this month" Result: Variance waterfall showing revenue shortfall offset by OPEX savings **Example: Department Budget Review** Request: "Which departments are over budget YTD?" Result: Ranked list by variance magnitude with drill-down to line items ## Resources - [FP&A Best Practices](https://www.fpanda.org/) - [`references/variance-formulas.md`](references/variance-formulas.md) for calculation templates
© Jeremy Longshore · MIT · jeremylongshore/tons-of-skills-marketplace