jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-variance-analyzer

Claude Code and agent skill by jukeyman/jukeyman-skills

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

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'.

Install

npx vskill@latest install jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-variance-analyzer

SKILL.md

The same SKILL.md was published earlier as jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-variance-analyzer.

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

ErrorCauseSolution
Missing periodsData gapsFill with zeros or interpolate
Percentage calc errorZero budgetUse IF to handle div/0
Misaligned categoriesChanged chart of accountsCreate 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.md for calculation templates

Security

  • Security scanPassed, 90 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

Repository stars
1
7-day trend score
8

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-variance-analyzer/badge)](https://verified-skill.com/skills/jukeyman/jukeyman-skills/business-tools-excel-analyst-pro-excel-variance-analyzer)

Something wrong with this skill or its page? Tell us.