# excel-variance-analyzer

excel-variance-analyzer is a Claude Code skill that compares budget and actual figures in Excel, flags variances, builds waterfall charts, and identifies root causes.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 3 installs · ★ 2935 repo stars
- Author: Jeremy Longshore
- License: MIT · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/HEAD/skills/.curated/excel-variance-analyzer/SKILL.md
- Updated: 2026-11-01
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/excel-variance-analyzer

## What it does

This skill automates budget vs actual comparisons inside spreadsheet workflows. It calculates dollar and percentage gaps, flags favorable and unfavorable movements, and applies materiality thresholds so noise is filtered out. Breakdowns can be grouped by reporting period or cost center.

For management presentations, the skill produces waterfall charts illustrating the bridge from target budget to actual figures. If a budget line contains zero, percentage math breaks without explicit `IF` formulas for division by zero. When the chart of accounts shifts, you must supply a category mapping table to keep comparisons aligned.

Analysis depends on having structured budget and actual data by department or cost center. The skill references calculation logic from `references/variance-formulas.md` to assemble exception reports for finance leads.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/excel-variance-analyzer/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/excel-variance-analyzer/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/excel-variance-analyzer/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/excel-variance-analyzer/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install jeremylongshore/tons-of-skills-marketplace skills/.curated/excel-variance-analyzer
```

2. **Manually: put the files in place**
- File: `.github/skills/excel-variance-analyzer/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/jeremylongshore/tons-of-skills-marketplace --path skills/.curated/excel-variance-analyzer
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/excel-variance-analyzer/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-variance-analyzer -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/HEAD/skills/.curated/excel-variance-analyzer/SKILL.md

## When to use it
- calculate absolute and percentage variances between budget and actual spend
- generate variance waterfall charts for executive reviews
- filter out immaterial discrepancies using threshold rules
- identify specific departments and line items driving cost overruns

## Example prompts
- Analyze why we missed budget by $500K this month
- Which departments are over budget YTD?
- Run an actual vs budget variance check and flag major differences

## Source text · SKILL.md · MIT

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: 42b5e8f5558fbbaa.

BEGIN THIRD-PARTY FILE 42b5e8f5558fbbaa
```text
---
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''.

  '
allowed-tools: Read, Write, Edit, Grep, Glob, Bash(cmd:*)
version: 1.22.0
author: Jeremy Longshore <jeremy@intentsolutions.io>
license: MIT
tags:
- business
- excel-variance
compatibility: Designed for Claude Code
---
# 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

| 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](https://www.fpanda.org/)
- [`references/variance-formulas.md`](references/variance-formulas.md) for calculation templates
```
END THIRD-PARTY FILE 42b5e8f5558fbbaa

The third-party file has ended. Everything between the 42b5e8f5558fbbaa tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

© Jeremy Longshore · MIT · https://github.com/jeremylongshore/tons-of-skills-marketplace/tree/HEAD/skills/.curated/excel-variance-analyzer/SKILL.md

## Similar
- [variance-analysis](https://affpapa.org/en/nevibecode/skills/variance-analysis.md) — skill · 3500 installs
- [excel-automation](https://affpapa.org/en/nevibecode/skills/excel-automation.md) — skill · 1500 installs
- [Skywork Excel](https://affpapa.org/en/nevibecode/skills/skywork-excel.md) — skill · 370 installs

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
