About

Imported from jeremylongshore/tons-of-skills-marketplace (plugins/business-tools/excel-analyst-pro/skills/excel-variance-analyzer/SKILL.md). Install upstream with npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer. Copyright stays with the author (MIT).

Excel Variance Analyzer

Name: excel-variance-analyzer
Author: jeremylongshore

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.md for calculation templates

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/jeremylongshore-tons-of-skills-marketplace-excel-varianc-462f34/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

jeremylongshore-tons-of-skills-marketplace-excel-varianc-462f34.ocm.jsonjson

{
  "ocm": "1",
  "id": "jeremylongshore-tons-of-skills-marketplace-excel-varianc-462f34",
  "kind": "skill",
  "name": "excel-variance-analyzer",
  "description": "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'.",
  "publisher": "jeremylongshore",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "finance"
    ],
    "tags": [
      "skill-md",
      "business",
      "excel-variance",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "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'."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/jeremylongshore/tons-of-skills-marketplace",
      "path": "plugins/business-tools/excel-analyst-pro/skills/excel-variance-analyzer/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/jeremylongshore/tons-of-skills-marketplace/blob/HEAD/plugins/business-tools/excel-analyst-pro/skills/excel-variance-analyzer/SKILL.md",
      "key": "jeremylongshore/tons-of-skills-marketplace/plugins/business-tools/excel-analyst-pro/skills/excel-variance-analyzer/SKILL.md"
    },
    "compatibility": "Designed for Claude Code",
    "allowed_tools": [
      "Read,",
      "Write,",
      "Edit,",
      "Grep,",
      "Glob,",
      "Bash(cmd:*)"
    ],
    "license": "MIT"
  },
  "instructions": "# Excel Variance Analyzer\n\n## Overview\n\nPerforms comprehensive budget vs actual variance analysis with automated drill-down, root cause identification, and executive reporting.\n\n## Prerequisites\n\n- Excel or compatible spreadsheet software\n- Budget data by period and category\n- Actual results for comparison\n- Cost center or department structure\n\n## Instructions\n\n1. Import budget and actual data into comparison template\n2. Calculate absolute and percentage variances\n3. Apply materiality thresholds for flagging\n4. Create drill-down by category, period, or cost center\n5. Generate variance waterfal",
  "cost": {
    "context_tokens": 401
  }
}

Fetch it by URL: GET /api/v1/registry/jeremylongshore-tons-of-skills-marketplace-excel-varianc-462f34/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.