Excel variance analyzer
Skill jeremylongshore/claude-code-plugins-plus-skills/skills/.curated/excel-variance-analyzer
425 plugins, 2,810 skills, 200 agents for Claude Code. Open-source marketplace at tonsofskills.com with the ccpi CLI package manager.
npx -y skills add jeremylongshore/claude-code-plugins-plus-skills --skill excel-variance-analyzerAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
What its author says it does
Copied from the file, not written here
'Analyze budget vs actual variances in Excel with drill-down and root cause analysis.
The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.
SKILL.md
2.1 KB, as published. Nobody here has run it
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
- Import budget and actual data into comparison template
- Calculate absolute and percentage variances
- Apply materiality thresholds for flagging
- Create drill-down by category, period, or cost center
- 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
${CLAUDE_SKILL_DIR}/references/variance-formulas.mdfor calculation templates