kesslernity/awesome-copilot-office-skills / skills/variance-explainer
variance-explainer
VerifiedExplains the movement between two periods or between plan and actual in the open workbook by splitting it into the drivers the data supports, reconciling the named drivers back to the total, and reporting the remainder as unexplained rather than attributing it. Invents no driver. Use when the user asks why a number moved, to bridge two periods, or to explain a variance.
README.md
View on GitHub# Variance explainer
> Splits a movement into the drivers the data supports and reports the remainder as unexplained. Invents no driver.
## What it produces
See the Output section of [SKILL.md](SKILL.md). Every output is a draft: the skill stops at a human approval checkpoint before it changes anything.
## Install in 60 seconds
1. Download `dist/personal/variance-explainer.zip` from this repository, or copy this folder.
2. In Excel, open Copilot, select **Settings**, then **Manage plugins & skills**, then **Custom skills**, then **Create OneDrive folder** and **Open skills folder**. Place the `variance-explainer` folder inside, then select **Refresh**. Your Office display language must be set to English, or skills do not appear.
3. Type `@variance-explainer` in the Copilot prompt, followed by your request.
Other tools: see [runtimes/](../../runtimes/).
## Example triggers
- "Why did this move between the two periods?"
- "Bridge plan to actual for me"
- "Explain this variance and show what is unexplained"
## Complements, and where it overlaps
None directly: refuses to force the bridge to tie.
## Status
Format-validated by `scripts/validate` on 2026-10-24. Tested in a live Excel tenant: pending. Report results with the tenant behaviour issue template.
## Changelog
| Version | Date | Change |
|---|---|---|
| 1.0 | 2026-10-24 | Initial version |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |