officecli-data-dashboard

Use this skill to build a multi-element Excel dashboard — Dashboard sheet on open, multiple formula-driven KPI cards, multiple charts, sparklines, and conditional formatting — from CSV or tabular input. Trigger on: 'dashboard', 'KPI dashboard', 'analytics dashboard', 'executive dashboard', 'metrics dashboard', 'CSV to dashboard', 'data visualization'. Output is a single .xlsx. Scene-layer on officecli-xlsx: inherits every xlsx hard rule. DO NOT invoke for: a single budget tracker / one-sheet CSV-with-formatting (use xlsx), a 3-statement / DCF / LBO financial model (use financial-model), a weekly report with ≤ 1 chart and < 10 rows (use xlsx).

Quality

86%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Critical

Do not install without reviewing

Quality

Content

81%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A high-signal, executable skill body with a strong phased workflow and rigorous validation gates; its weakness is length and mild redundancy across the Requirements, Reference, and Known Issues sections. Progressive disclosure is well-handled via external references despite the absence of a local bundle.

Suggestions

Consolidate the repeated DeferredAddKeys and fullCalcOnLoad-staleness notes into a single canonical location and cross-reference it, to trim conciseness from 3 toward 4.

Move the 17-row Known Issues table and the CF/chart-type/preset reference tables into a references/ bundle file (e.g. REFERENCE.md) and keep SKILL.md as an overview, lifting progressive_disclosure toward 5.

Tighten the Gate 7 fallback block, which repeats the title×0.18 check already in Gate 2, with a single shared helper.

Dimension	Reasoning	Score
Conciseness	The body is dense and assumes Claude's competence (no beginner-level re-explanation of Excel/CSV/dashboards), but it runs ~400 lines with mild redundancy — DeferredAddKeys and fullCalcOnLoad staleness each appear in Help-First, Core/Requirements, Reference, and the D-1/D-16 pitfall rows — so it is mostly efficient with sections that could be tightened.	3 / 5
Actionability	Fully executable, copy-paste-ready bash across Quick Start phases 1-4, print-ready delivery, and eight QA gates with concrete jq/grep pipelines and a col_num helper, matching the anchor-5 example of covering common cases.	5 / 5
Workflow Clarity	Explicit phased build order (charts/CF first → fullCalcOnLoad → raw-set activeTab LAST) plus eight delivery gates using COUNT-then-if with reject/exit and an explicit 'fix at source, re-run the full cycle' feedback loop, matching anchor 5.	5 / 5
Progressive Disclosure	No local bundle files exist; the body defers schemas to sibling officecli-xlsx and 'help' (one level deep, clearly signaled) and is organized into well-named sections, though substantial reference material (CF/chart-type/preset tables, 17 pitfall rows) is inlined rather than split into separate files.	4 / 5
	Total	17 / 20 Passed

Description

92%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A tightly-scoped, third-person description that pairs a concrete action list with explicit positive triggers and negative reverse-triggers, distinguishing it cleanly from sibling skills. The only gap is the absence of a file extension and a few common synonyms in the trigger list.

Suggestions

Add the .xlsx file extension and a synonym like 'report' to the Trigger-on list to reach anchor-5 trigger-term coverage.

Consider tightening 'metrics dashboard' / 'analytics dashboard' overlap by noting the distinguishing 'multiple KPI cards + multiple charts' qualifier once.

Dimension	Reasoning	Score
Specificity	Names multiple concrete composition actions — 'Dashboard sheet on open, multiple formula-driven KPI cards, multiple charts, sparklines, and conditional formatting — from CSV or tabular input' — with comprehensive coverage, matching the anchor-5 example.	5 / 5
Completeness	Explicitly answers both 'what' (build a multi-element dashboard composition) and 'when' via a concrete 'Trigger on:' clause plus a 'DO NOT invoke for:' reverse-trigger list, matching the anchor-5 example.	5 / 5
Trigger Term Quality	Strong natural trigger list ('dashboard', 'KPI dashboard', 'analytics dashboard', 'executive dashboard', 'metrics dashboard', 'CSV to dashboard', 'data visualization') with synonyms, but lacks a file extension like .xlsx and a couple of common variants, stopping short of anchor 5.	4 / 5
Distinctiveness Conflict Risk	Clear niche (multi-element dashboard composition) with an explicit DO-NOT-INVOKE list carving it off from officecli-xlsx and officecli-financial-model, giving minimal conflict risk as in the anchor-5 example.	5 / 5
	Total	19 / 20 Passed

Validation

100%

Warnings & errors only

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository: Team-Commonly/commonly
Path: backend/commonly-bundled-skills/officecli/skills/officecli-data-dashboard/SKILL.md
Commit: e701dba

Reviewed: 1 day ago

Table of Contents

Discovery Implementation Validation

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.