variance-explainer SKILL.md skillA

variance-explainer from kesslernity/awesome-copilot-office-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add kesslernity/awesome-copilot-office-skills/variance-explainer@git:20261024.a411dc2

Pins git:20261024.a411dc2 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
kesslernity/awesome-copilot-office-skills
Path
skills/variance-explainer/SKILL.md
Versions recorded
1
Latest version
git:20261024.a411dc2, committed Oct 24, 2026
Size
4,928 bytes
Repository stars
8
License
CC-BY-SA-4.0

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.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Variance explainer

## Purpose

Explain a movement without inventing a reason for it. The skill decomposes the change between two columns into the drivers the workbook can actually evidence, re-adds those drivers back to the total movement, and states the remainder as unexplained. A bridge that reconciles to the penny with no unexplained line is usually a bridge that has been forced.

## When to use

- The user asks why a figure moved, to bridge two periods, or to explain plan against actual.
- A variance needs a written explanation for a pack, a review or a meeting.
- Do not use to decide which driver matters most commercially. This skill decomposes, the user interprets.

## Inputs

1. The open workbook (required), and the two columns or ranges being compared, with which is the base and which is the comparison.
2. Driver data (optional): the dimensions available to split by, such as volume, price, mix, rate, currency, entity or product.
3. Materiality (optional): the threshold below which a driver is grouped into Other. Default is one per cent of the total movement.

## Procedure
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add kesslernity/awesome-copilot-office-skills/variance-explainer@sha256:1ef9a31c346c4393

The line at the top of this page pins the label git:20261024.a411dc2, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_pooq6occ2kebkfys.svg)](https://markdownregistry.com/a/art_pooq6occ2kebkfys)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Oct 24, 2026.

versioncommittedcommitsizeaudit
git:20261024.a411dc2 latest2026-10-24 a411dc2 4,928 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (4928 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

kesslernity/awesome-copilot-office-skills · 8 stars · license CC-BY-SA-4.0 · pushed 2026-10-25 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_pooq6occ2kebkfys
GET https://markdownregistry.com/api/v1/resolve?ref=kesslernity/awesome-copilot-office-skills/variance-explainer
GET https://markdownregistry.com/api/v1/blob/1ef9a31c346c4393e3e91b8a33ba5c82d4364d3970b9465d2e4d127cb275a719

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from kesslernity/awesome-copilot-office-skills

accessibility-pass SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/accessibility-pass/SKILL.md · Reviews the open presentation for accessibility issues (missing or duplicate slide titles, missing alt text, reading…
git:20261024.a411dc2 · audit A · 8 stars
action-title-rewrite SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/action-title-rewrite/SKILL.md · Reviews every slide title in the open presentation and proposes action titles that state each slide's message as a full…
git:20261024.a411dc2 · audit A · 8 stars
ai-writing-tells-check SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/ai-writing-tells-check/SKILL.md · Finds the patterns that make slide text read as machine-written (filler openers, inflated verbs, groups of three, em…
git:20261025.7203ae2 · audit A · 8 stars
appendix-split SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/appendix-split/SKILL.md · Separates the deck that gets presented from the detail that answers questions, by proposing which slides move to an…
git:20261024.9aa8eaa · audit A · 8 stars
assumptions-register SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/assumptions-register/SKILL.md · Finds every hardcoded input in the open workbook, separates genuine assumptions from calculated cells, and builds a…
git:20261024.a411dc2 · audit A · 8 stars
brand-rules-check SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/brand-rules-check/SKILL.md · Checks every slide of the open presentation against written brand rules (colours with hex codes, fonts, logo use…
git:20261024.9aa8eaa · audit A · 8 stars
chart-intent-check SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/chart-intent-check/SKILL.md · Checks every chart in the open workbook against what its title and labels claim: truncated or inverted axes…
git:20261024.a411dc2 · audit A · 8 stars
data-quality-sweep SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/data-quality-sweep/SKILL.md · Sweeps a data range in the open workbook for conditions that break reporting: mixed types in a column, numbers and…
git:20261024.9aa8eaa · audit A · 8 stars
decision-slide SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/decision-slide/SKILL.md · Builds one decision slide that sets out the question, the options, the criteria, a comparison, the recommended option…
git:20261024.a411dc2 · audit A · 8 stars
deck-consistency-sweep SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/deck-consistency-sweep/SKILL.md · Sweeps the open presentation for the inconsistencies a reader notices and an author stops seeing: a term used two ways…
git:20261024.a411dc2 · audit A · 8 stars
deck-message-review SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/deck-message-review/SKILL.md · Reads a whole deck and reports whether it carries one message, whether the slides support it in order, and whether it…
git:20261025.7203ae2 · audit A · 8 stars
deck-trim-proposal SKILL.md skill
kesslernity/awesome-copilot-office-skills · skills/deck-trim-proposal/SKILL.md · Proposes which slides to cut, merge or move to an appendix so a deck fits its slot and its argument, using repetition…
git:20261024.9aa8eaa · audit A · 8 stars

Every file in kesslernity/awesome-copilot-office-skills

Browse by kind, by grade A, or by owner.