CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

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 at most 1 chart and fewer than 10 rows (use xlsx).

Quality

95%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Low

Low-risk findings worth noting

SKILL.md
Quality
Evals
Security

Quality

Content

88%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 scene-layer skill: executable commands for every step, an eight-gate QA cycle with feedback loops, and genuine disclosure of schema detail to officecli help and the parent xlsx skill. Its main weaknesses are repeated multi-section explanations of the same gotchas and a monolithic inline structure that would benefit from a references/ split.

Suggestions

Consolidate the fullCalcOnLoad/cachedValue-staleness explanation (currently in Requirements, Gate 8, and D-16) into one canonical location — e.g. D-16 — and cross-reference it from the others; do the same for the scatter xValues (chart table, Honest limits, D-3) and pie→doughnut (chart table, D-9) notes.

Move the Known Issues table (D-1..D-17) and/or the print-ready delivery command block and gate scripts into references/ files (e.g. references/known-issues.md, references/qa-gates.md), keeping SKILL.md as a lean overview with well-signaled one-level-deep pointers.

Trim rhetorical repetition around the visual-delivery floor ("skipping ships ### to the user" appears in Requirements, Gate 7 prose, and D-5) to a single stated rule plus one pointer.

DimensionReasoningScore

Conciseness

The body is dense with CLI-version-specific knowledge Claude cannot know (DeferredAddKeys, "LibreOffice does not evaluate formulas in hidden columns", cachedValue staleness) and explicitly refuses to re-teach inherited material ("is not re-taught here"). However, the fullCalcOnLoad/cache-staleness gotcha is explained three times (Requirements, Gate 8 preamble, D-16), scatter xValues three times (chart table, Honest limits, D-3), and pie→doughnut twice — so it is efficient with minor redundancy to trim, not the every-token-earns-its-place of a 5.

4 / 5

Actionability

Copy-paste-ready bash throughout: exact set/add/import commands with props, jq pipelines for every gate, raw-set XPath with full XML literals, and a Quick Start "Verified end-to-end on a 12-row revenue CSV". It is not a 4 because no guidance is left at the pseudocode or high-level-hint stage.

5 / 5

Workflow Clarity

A phased Quick Start with an explicit build order ("raw-set activeTab LAST"), eight delivery gates using COUNT-then-if rejection, "Assume there are problems. Your job is to find them", and "If anything fails, fix at source, re-run the full cycle" — a clear sequence with validation checkpoints and feedback loops, matching the top anchor.

5 / 5

Progressive Disclosure

It delegates well — "Full schemas live in help... This skill does not mirror them" and §-pointers into officecli-xlsx instead of re-teaching — and sections are clearly organized. It is not a 5 because the single 410-line file inlines material that belongs in reference files (the 17-row Known Issues table, the print-delivery command block, and the full gate scripts), with no references/ split at all.

4 / 5

Total

18

/

20

Passed

Description

100%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.

The description is exemplary: concrete what-clause with input/output formats, seven natural trigger phrases, and an explicit DO-NOT-invoke list that hands off to sibling skills. All four dimensions sit at the top anchor with no vagueness or over-claiming.

DimensionReasoningScore

Specificity

"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... Output is a single .xlsx" names concrete component actions plus input and output formats, matching the comprehensive-coverage anchor. It is not a 4 because no concrete capability of the skill is left unspecified.

5 / 5

Completeness

It explicitly answers what ("build a multi-element Excel dashboard... Output is a single .xlsx") and when ("Trigger on: 'dashboard', 'KPI dashboard'...") with concrete trigger phrases. It is not a 4 because the when-clause is fully explicit rather than improvable.

5 / 5

Trigger Term Quality

"Trigger on: 'dashboard', 'KPI dashboard', 'analytics dashboard', 'executive dashboard', 'metrics dashboard', 'CSV to dashboard', 'data visualization'" covers the natural synonyms a user would say, and ".xlsx" appears as the output format. It is not a 4 because the natural-phrase coverage including synonyms and the file extension is complete rather than merely good.

5 / 5

Distinctiveness Conflict Risk

"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 at most 1 chart and fewer than 10 rows (use xlsx)" is an explicit reverse handoff that resolves overlap with sibling skills. It is not a 4 because even minor conflict risk is addressed by named alternative skills.

5 / 5

Total

20

/

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

Path

skills/officecli-data-dashboard/SKILL.md

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.