Analyzes budget vs. actual variances in Excel files with drill-down, root cause analysis, materiality thresholds, waterfall charts, and executive reports.
From excel-analyst-pronpx claudepluginhub nickloveinvesting/nick-love-plugins --plugin excel-analyst-proThis skill is limited to using the following tools:
assets/README.mdreferences/README.mdreferences/variance-formulas.mdscripts/README.mdProvides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.
Calculates TAM/SAM/SOM using top-down, bottom-up, and value theory methodologies for market sizing, revenue estimation, and startup validation.
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