CtrlK
BlogDocsLog inGet started
Tessl Logo

excel-bar-chart-visualization

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

63

Quality

73%

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

80%

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

The content is concise and highly actionable, with executable pandas/matplotlib code across four well-named steps, but it lacks validation checkpoints for its batch/file-output operations and keeps everything inline with no external references.

Suggestions

Add a validation/verification step after writing the Excel file and rendering the chart (e.g., assert the file exists and check the figure is non-empty) to create a feedback loop.

Move the longer code blocks or stage-mapping tables into reference files (e.g. references/chart_styles.md) and link to them so the overview stays short.

Define shared variables (e.g., the initial data_frames) or note where they come from so each step reads as self-contained.

DimensionReasoningScore

Conciseness

The body is lean, code-driven, and assumes Claude's pandas/matplotlib competence; comments are terse, skill-specific pointers ('处理合并单元格技巧1:前向填充', '配置中英文字体') rather than explanations of basic concepts Claude already knows.

3 / 3

Actionability

Each step provides concrete, executable pandas/matplotlib code with specific calls (pd.concat, groupby, to_excel, ax.barh) and real styling parameters, making it largely copy-paste ready.

3 / 3

Workflow Clarity

The four steps are clearly sequenced (合并清洗 → 交叉分析 → 输出 → 绘图), but there are no validation/verification checkpoints for the batch data processing and file output; per the guideline this caps workflow clarity at 2.

2 / 3

Progressive Disclosure

No bundle files exist (references/scripts/assets are absent) and the ~119-line body keeps all four steps inline with no one-level-deep references, so it is structured but monolithic rather than progressively disclosed.

2 / 3

Total

10

/

12

Passed

Description

67%

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 distinctive, naming several concrete Excel/charting capabilities, but it omits an explicit 'Use when...' trigger clause and common keyword variations, which limits trigger-term quality and completeness.

Suggestions

Add an explicit trigger clause, e.g. 'Use when the user needs to summarize multi-sheet Excel data into grouped statistics with charts.'

Include common natural variations such as '.xlsx', '合并单元格', and '交叉统计/透视' to broaden trigger-term coverage.

Keep the third-person voice but make the 'when to use' condition as concrete as the 'what it does' list.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — '读取多工作表Excel文件', '自动处理合并单元格与数据清洗', '交叉分组统计', '生成带总计行的结果表', '绘制支持中英文字体的美化柱状图' — each naming a specific capability rather than vague language.

3 / 3

Completeness

It clearly states what the skill does, but the 'when' guidance is only implied via '适用于多维度数据汇总与可视化分析' rather than an explicit 'Use when...' clause; per the guideline a missing explicit trigger caps completeness at 2.

2 / 3

Trigger Term Quality

Contains relevant natural terms (Excel文件, 合并单元格, 柱状图, 数据汇总与可视化) but lacks common variations such as the .xlsx extension and offers no explicit 'Use when' trigger phrasing, so coverage is partial.

2 / 3

Distinctiveness Conflict Risk

The combination of merged-cell handling, cross-group statistics with total rows, and Chinese/English-font bar charts defines a clear niche unlikely to trigger for unrelated skills.

3 / 3

Total

10

/

12

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.