CtrlK
BlogDocsLog inGet started
Tessl Logo

excel-data-analysis-and-report-generation

从Excel提取多类型数据,并生成包含可视化图表与下载链接的综合分析报告。

55

Quality

62%

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-result-export/report-generation-export/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

65%

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

The body delivers concise, concrete Python for a three-step Excel analysis workflow, but it is weakened by undefined context variables and magic indices that block copy-paste use, and by an absence of validation checkpoints and progressive-disclosure structure for what is a sizable, code-heavy skill.

Suggestions

Make the code self-contained and copy-paste ready: show the imports (pandas, matplotlib, os, re) and define or note where combined_df and output_dir originate, and replace the magic row.iloc[8] index with a named/commented column lookup.

Add validation or verification checkpoints — e.g. confirm category_counts is non-empty before plotting, assert the chart file was written before generating its download link, and log unmatched limit-exceeding rows so the batch workflow has a feedback loop.

Add a brief overview/quick-start section at the top and consider moving the longer Step1–Step3 code blocks into a referenced file under references/ or scripts/ so the SKILL.md body stays a navigable overview.

DimensionReasoningScore

Conciseness

The body is lean — each step is a single descriptive line followed by working Python, with only brief section-label comments like '# 反向搜索限值' and '# 保存图表', and it never explains concepts Claude already knows (no intro to pandas/matplotlib), matching the 'lean and efficient; every token earns its place' anchor.

3 / 3

Actionability

It provides concrete, real Python (value_counts with percentages, crosstab, regex limit search, matplotlib pie chart) rather than pseudocode, but it is not copy-paste ready due to undefined context variables (combined_df, output_dir, os) and a magic hardcoded index (row.iloc[8]), fitting 'some concrete guidance but missing key details' over the fully-ready anchor.

2 / 3

Workflow Clarity

The three steps are clearly sequenced (categorize → detect limit-exceeding rows → visualize and save with download links), but there are no validation or verification checkpoints despite batch row-processing and file generation, so per the rubric a batch operation missing feedback loops caps workflow_clarity at 2.

2 / 3

Progressive Disclosure

Content is organized into three labeled steps, but at ~130 lines everything is inline with no overview/quick-start section and no reference files; the only navigation signal is a blockquote pointing to a parent SKILL.md, so it matches 'some structure but content that should be separate is inline' rather than a well-split, clearly navigable structure.

2 / 3

Total

9

/

12

Passed

Description

60%

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-oriented about Excel analysis and report generation, but it omits any 'Use when…' trigger guidance and lacks common keyword variations, leaving it functionally incomplete for reliable skill selection.

Suggestions

Add an explicit 'Use when…' trigger clause, e.g. 'Use when the user asks to analyze Excel data, summarize or count spreadsheet columns, or generate charts and downloadable analysis reports.'

Broaden trigger terms to include common variations a user might say, such as '.xlsx', '电子表格', 'spreadsheets', '数据统计', or '生成报表', to improve natural-keyword coverage.

Sharpen distinctiveness by tying the skill to its specific output (visualization charts + sandbox download links) so it is less likely to conflict with sibling Excel skills.

DimensionReasoningScore

Specificity

The description lists multiple concrete actions — '从Excel提取多类型数据' and '生成包含可视化图表与下载链接的综合分析报告' — naming the domain (Excel data) and several specific outputs (charts, download links, analysis report) in third-person voice, matching the 'lists multiple specific concrete actions' anchor.

3 / 3

Completeness

The 'what' is clearly stated (extract data, generate a report with charts and download links), but there is no 'Use when…' clause or equivalent trigger, so per the rubric guideline a missing explicit trigger caps completeness at 2.

2 / 3

Trigger Term Quality

It includes relevant natural terms like 'Excel', '数据', and '分析报告', but misses common variations a user might say such as '.xlsx', '电子表格/spreadsheet', or '报表', fitting the 'some relevant keywords but missing common variations' anchor rather than full coverage.

2 / 3

Distinctiveness Conflict Risk

The Excel-analysis-and-report niche is reasonably specific, yet without explicit trigger guidance it could still overlap with other Excel or data-analysis skills, matching 'somewhat specific but could still overlap with similar skills' rather than a clearly distinct, low-conflict profile.

2 / 3

Total

9

/

12

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

relative_links

Relative link issues: 2 suspicious

Warning

Total

15

/

16

Passed

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.