Skip to content

kesslernity/awesome-copilot-office-skills / skills/variance-explainer

variance-explainer

Verified

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

FileKindSize
README.mdmarkdown1.3 KB
SKILL.mdskill md4.8 KB
# 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 |
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
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: 196kUpdated Claude CodeCodexVerifiedInstall