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.
npx claudepluginhub jeremylongshore/claude-code-plugins-plus-skillsThis skill is limited to using the following tools:
Performs comprehensive budget vs actual variance analysis with automated drill-down, root cause identification, and 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 Excel spreadsheets (.xlsx, .xlsm, CSV, TSV): create, edit, analyze data, formulas (error-free), charts, pivot tables, formatting, validation.
Generates ownership-ready variance narratives from budget-vs-actual reports for CRE properties. Screens materiality, classifies variances as timing/permanent/one-time/trend, projects full-year NOI impact, drafts investor explanations.
Share bugs, ideas, or general feedback.
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 templates