wbr-metrics-excel
description (verbatim frontmatter)
The coworker Weekly Business Review workbook: a 21-sheet Excel deliverable (Fleet + 20 per-coworker sheets) built from the metric registry and the rpt_wbr warehouse view, with WoW deltas shipped as live Excel FORMULAS never hardcoded values. Three files: metrics_seed.py (THE metric registry — 21 Metric pydantic rows, the only writer of dim_metric), generate_wbr.py (the openpyxl workbook builder, step-0 excel-toolchain autoresolve, best- effort xlwings recalc), and this skill's own validate.py (registry gate + informational xlsx presence check) and audit_xlsx.py (the workbook correctness gate — sheet/band/formula/footnote/owner-row checks plus gate G5 warehouse reconciliation). Use on "wbr excel", "generate the workbook", "metric registry", "audit the workbook", "seed metrics", "weekly business review", "fleet north-star metrics", or when a WBR deliverable needs to go to the operator/PM for Monday/Wednesday review. Do NOT use for Cloudflare cache/CDN snapshots (cwc-analytics-engineering) or the Coworkers sprint board itself (cwc-data-engineering's session-telemetry-erd) — this skill owns the metric DEFINITIONS and the Excel deliverable, not the underlying fact tables' DDL or the board UI.
summary
The coworker Weekly Business Review workbook: a 21-sheet Excel deliverable (Fleet + 20 per-coworker sheets) built from the metric registry and the rpt_wbr warehouse view, with WoW deltas shipped as live Excel FORMULAS never hardcoded values.
source
plugins/cwc-finance/skills/wbr-metrics-excel/SKILL.md
provenance
created 2026-07-10 18:13:13 · JSON