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

88%

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 highly actionable, well-sequenced skill with strong validation discipline and clean deferral to sibling skills for shared knowledge. Its main weakness is cross-section redundancy (width-sizing and cache-staleness rules repeated across Requirements, Quick Start, Design Ideas, and the known-issues table).

Suggestions

Consolidate the column-width-sizing rule into a single canonical location and cross-reference it from D-5 and Design Ideas instead of restating it.

Merge the fullCalcOnLoad / cache-staleness guidance (Requirements, Quick Start, D-16, D-17) into one section to remove repetition.

Consider moving the D-1..D-17 pitfalls table into a bundled references file to reduce SKILL.md length and improve progressive disclosure.

Dimension	Reasoning	Score
Conciseness	The body explicitly defers known concepts to officecli-xlsx ('comes from officecli-xlsx and is not re-taught here') and assumes Claude's competence, but several rules are restated across sections — column-width sizing appears in Requirements, Design Ideas, and D-5; the fullCalcOnLoad/cache-staleness rule appears in Requirements, Quick Start, D-16, and D-17 — which is trimmable redundancy rather than verbosity about basics.	3 / 5
Actionability	Fully executable, copy-paste-ready bash across a 4-phase Quick Start, the print-delivery block, and eight QA gates with concrete jq/grep scripts; specific examples cover the common 12-month-revenue case.	5 / 5
Workflow Clarity	Batch/destructive .xlsx and raw-set XML work is phased with explicit ordering ('activeTab LAST'), eight validation Gates using COUNT-then-if, and a feedback loop ('If anything fails, fix at source, re-run the full cycle') — clear sequence with explicit validation and error recovery.	5 / 5
Progressive Disclosure	Well-sectioned body with clear headers and disciplined one-level external deferral ('→ see officecli-xlsx §...', 'Full schemas live in help... This skill does not mirror them'), but no bundle files exist and the large 17-row known-issues table and design-ideas content are fully inlined, leaving minor organization gaps.	4 / 5
	Total	17 / 20 Passed

Description

95%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 strong, specific description with explicit trigger phrases, clear what/when coverage, and well-drawn boundaries against sibling skills. The only ding is the second-person 'Use this skill to build...' phrasing, which the rubric penalizes on specificity.

Suggestions

Switch to third-person voice ('Builds a multi-element Excel dashboard...') to recover the specificity point lost to the second-person penalty.

Optionally name the output file extension among trigger terms ('.xlsx') to round out trigger-term coverage.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete components and actions ('formula-driven KPI cards, multiple charts, sparklines, and conditional formatting — from CSV or tabular input', 'Output is a single .xlsx') with comprehensive coverage, which is a 5; reduced by 1 per the second-person penalty for the opening 'Use this skill to build...' imperative.	4 / 5
Completeness	Clearly answers both 'what' (build a multi-element dashboard from CSV → single .xlsx) and 'when' ('Trigger on: ...' with concrete phrases), plus explicit exclusion guidance.	5 / 5
Trigger Term Quality	Explicit and extensive natural trigger list ('dashboard', 'KPI dashboard', 'analytics dashboard', 'executive dashboard', 'metrics dashboard', 'CSV to dashboard', 'data visualization') covers synonyms and common phrasings a user would actually say.	5 / 5
Distinctiveness Conflict Risk	Distinct niche (multi-element dashboards) with explicit 'DO NOT invoke for' boundaries separating it from xlsx and financial-model skills, minimizing conflict risk.	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: iOfficeAI/OfficeCLI
Path: skills/officecli-data-dashboard/SKILL.md
Commit: 459b1a4

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.