CtrlK
BlogDocsLog inGet started
Tessl Logo

excel-bar-chart-visualization

读取多工作表Excel文件,自动处理合并单元格与数据清洗,进行交叉分组统计并生成带总计行的结果表,最后绘制支持中英文字体的美化柱状图,适用于多维度数据汇总与可视化分析。

58

Quality

66%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./skills/sn-da-excel-workflow/capability/excel-data-visualization/bar-chart-visualization/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

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

The body is concise and actionable with clear step sequencing, but lacks validation/verification checkpoints for a batch data-and-output workflow, capping workflow clarity. No bundle files are present or needed, and structure is clean.

Suggestions

Add a verification checkpoint after Step2/Step3 (e.g. print grouped_stats shape or assert non-empty) before generating the Excel/chart output.

Re-declare or note shared variables (group_col, target_col, grouped_stats) at the top of each step so snippets are independently runnable.

Replace the deprecated fillna(method='ffill') with ffill() to keep the example current.

DimensionReasoningScore

Conciseness

Mostly lean code with brief, useful inline comments ('技巧:配置中英文字体', '处理合并单元格技巧1') and no padding explaining concepts Claude already knows; only minor spots could be trimmed.

4 / 5

Actionability

Provides concrete, mostly copy-paste-ready pandas/matplotlib code across all four steps, with minor gaps such as variables (group_col, target_col) flowing between steps without re-declaration.

4 / 5

Workflow Clarity

Steps are clearly sequenced Step1–Step4, but this batch/output-generating workflow has no validation or verification checkpoints (e.g. checking grouped_stats before plotting), which per the rubric caps workflow clarity at 3.

3 / 5

Progressive Disclosure

Well-organized into four labeled step sections in a single self-contained file with no nested references; the inline mapping dicts are short enough to stay inline, with only minor organization gaps.

4 / 5

Total

15

/

20

Passed

Description

63%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 specific and action-rich but lacks an explicit 'Use when' trigger clause and natural keyword variants, capping completeness and trigger quality. It is mostly distinct from sibling skills.

Suggestions

Add an explicit 'Use when...' trigger clause naming concrete user cues (e.g. multi-sheet Excel files, merged cells, cross-tabulation, bar charts).

Include natural synonyms and file extensions users actually say, such as '.xlsx', 'charts', 'pivot/交叉表'.

Consider splitting the long single sentence into a capability sentence plus a trigger sentence for scannability.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — '读取多工作表Excel文件', '处理合并单元格与数据清洗', '交叉分组统计', '生成带总计行的结果表', '绘制...柱状图' — giving comprehensive coverage of the capability.

5 / 5

Completeness

The 'what' is clearly stated, but there is no explicit 'Use when...' trigger clause — 'when' is only weakly implied by '适用于多维度数据汇总与可视化分析', which per the rubric caps completeness at 3.

3 / 5

Trigger Term Quality

Contains relevant terms like 'Excel文件', '柱状图', '数据汇总', '可视化分析', but omits natural variations/synonyms and file extensions (e.g. .xlsx, charts) that users would actually say.

3 / 5

Distinctiveness Conflict Risk

The niche (merged-cell handling + cross-tabulation + bilingual bar charts) is fairly distinct from generic Excel skills, with only minor overlap risk against broader spreadsheet skills.

4 / 5

Total

15

/

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.

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
OpenSenseNova/SenseNova-Skills
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.