Stats
Actions
Tags
From excel-analyst-pro
Analyzes budget vs. actual variances in Excel files with drill-down, root cause analysis, materiality thresholds, waterfall charts, and executive reports.
How this skill is triggered — by the user, by Claude, or both
Slash command
/excel-analyst-pro:excel-variance-analyzerThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Performs comprehensive budget vs actual variance analysis with automated drill-down, root cause identification, and executive reporting.
Performs comprehensive budget vs actual variance analysis with automated drill-down, root cause identification, and executive reporting.
| 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 |
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
${CLAUDE_SKILL_DIR}/references/variance-formulas.md for calculation templatesnpx claudepluginhub nickloveinvesting/nick-love-plugins --plugin excel-analyst-proAnalyzes budget vs actual variances in Excel spreadsheets with automated drill-down, root cause identification, materiality thresholds, and waterfall charts for executive reporting.
Decomposes financial variances into price/volume/mix/headcount drivers with formulas, narratives, examples, and waterfall analysis for budget vs. actual or period-over-period changes.
Processes bookkeeper Excel/CSV exports into categorized spending, budget comparisons, variance analysis, runway calculations, and burn rate trends. Useful for month-end financial reviews.