CtrlK
BlogDocsLog inGet started
Tessl Logo

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

72

Quality

88%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Critical

Do not install without reviewing

SKILL.md
Quality
Evals
Security

Quality

Content

85%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 body: executable commands everywhere, phased workflow, and a rigorous validate-and-reject QA gate system with error recovery. Its weaknesses are mild redundancy around cachedValue staleness and title-width rules, and a monolithic inline layout where the pitfalls table and QA gate scripts would be better split into reference files.

Suggestions

Move the 17-row Known Issues & Pitfalls table (D-1..D-17) into a references/pitfalls.md file, keeping only the 3-4 most frequent traps inline with a one-line pointer per the existing '→ see officecli-xlsx §' pointer style.

Extract the Gate 1-8 bash scripts into a references/qa-gates.md (or scripts/run-gates.sh) and keep in SKILL.md only the gate list, what each verifies, and the COUNT-then-if pattern.

De-duplicate the cachedValue-staleness rule (Requirements bullet, Gate 8 intro, D-16) into a single authoritative statement plus a cross-reference, trimming roughly 15-20 lines.

DimensionReasoningScore

Conciseness

The body is dense with CLI-specific knowledge Claude would not know (DeferredAddKeys, raw-set activeTab ordering, SUMPRODUCT array-formula failures) and teaches no generic Excel concepts, so it broadly assumes competence. Minor over-explanation remains: the cachedValue-staleness rule is explained three times (Requirements, Gate 8 intro, D-16) and the chart-title-width rule appears in Design Ideas, Gate 2, and its comment, so it sits just below the lean anchor 5.

4 / 5

Actionability

Fully executable throughout: a phased Quick Start with copy-paste bash, concrete prop values ('--prop highPoint=true --prop highMarkerColor=FF0000'), worked arithmetic ('width ≈ ceil((visible_chars + 2) × 1.3)'), and complete gate scripts including the col_num helper. Common cases (revenue trend dashboard, print delivery, CF rule types) are all covered by specific commands.

5 / 5

Workflow Clarity

Clear sequencing with explicit validation: Quick Start is broken into phases 'so a single failed phase is obvious', Reference states the build order ('raw-set activeTab LAST after all sheets exist'), and the QA section is a REQUIRED delivery gate with eight count-then-if checks, per-failure REJECT messages, an error-recovery loop ('If anything fails, fix at source, re-run the full cycle'), and mandatory fallbacks when view html is blocked. This matches the anchor-5 validate→fix→retry pattern.

5 / 5

Progressive Disclosure

Structure and navigation are good (clear sections, explicit deferral of schemas to 'officecli help' and hard rules to the officecli-xlsx parent skill), but the ~400-line body inlines substantial material that clearly belongs in separate reference files — the 17-row Known Issues table and ~120 lines of copy-paste gate scripts. With no bundle files at all, this is 'some structure, content that should be separate is inline', not above the anchor-3 line; not below 3 because what external deferral exists is clearly signaled and one level deep.

3 / 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.

An exemplary description: concrete capabilities, an explicit trigger list, a stated output artifact, and explicit reverse-handoff guidance that sharply separates it from sibling xlsx/financial-model skills. The only gap is a handful of missing natural trigger phrasings like 'Excel dashboard' as an explicit trigger term.

DimensionReasoningScore

Specificity

The description lists multiple concrete actions with comprehensive coverage: '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' plus a concrete output contract ('Output is a single .xlsx'). Every capability named is specific and checkable; not below 4 because coverage of the skill's surface (inputs, elements, output) is complete.

5 / 5

Completeness

Both questions are answered explicitly: what ('build a multi-element Excel dashboard... Output is a single .xlsx') and when ('Trigger on: dashboard, KPI dashboard, ...' plus an explicit DO NOT INVOKE list routing three non-matching asks to sibling skills). This matches the anchor-5 example's structure of concrete what plus concrete trigger phrases, and exceeds it with explicit anti-triggers.

5 / 5

Trigger Term Quality

Good keyword coverage with natural variations users would say: 'dashboard', 'KPI dashboard', 'analytics dashboard', 'executive dashboard', 'metrics dashboard', 'CSV to dashboard', 'data visualization'. A few natural terms are missing from the trigger list (e.g., 'Excel dashboard' appears only in the capability sentence, and '.xlsx' / 'build a dashboard' phrasings), so it falls just under the comprehensive synonym+extension anchor 5.

4 / 5

Distinctiveness Conflict Risk

The description actively disambiguates against the three most confusable neighbors ('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)') and declares its scene-layer relationship to officecli-xlsx. Minimal conflict risk; clearly a distinct niche.

5 / 5

Total

19

/

20

Passed

Validation

100%

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
Reviewed

Table of Contents

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.