CtrlK
BlogDocsLog inGet started
Tessl Logo

excel-basic-statistics-and-routing

对多Sheet Excel文件进行基础统计与,支持按条件筛选计算均值,以及从指定行区间提取数据去重求和,并生成结果文件与下载链接。

60

Quality

70%

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-statistics/basic-statistics/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

75%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 content delivers concise, mostly executable pandas guidance across a clearly sequenced three-step workflow with reasonable validation, but depends on parent-context variables without explicitly signaling where they are defined and lacks output-write verification in the final step.

Suggestions

Explicitly note that df_analysis, total_rows, file_path, and output() are provided by the parent workflow context, so the sub-skill is not read as standalone.

Add an output verification checkpoint in Step3 (e.g. assert os.path.exists(output_path) after to_excel) to close the validation gap.

Replace the bare 'except: pass' blocks in Step2 with targeted exception handling or a logged warning so silent failures do not hide malformed rows.

DimensionReasoningScore

Conciseness

The body is mostly lean — brief per-step Chinese descriptions followed by code, with no padding explaining pandas/Excel basics; minor trimmable bits (repeated inline DataFrame construction, a bare 'import os' mid-step) keep it just below a 5.

4 / 5

Actionability

Provides concrete, executable pandas code for filtering, interval extraction/dedup, and Excel output, but it relies on undefined parent-context variables (df_analysis, total_rows, file_path, output()) so it is not fully standalone copy-paste ready.

4 / 5

Workflow Clarity

Steps are clearly sequenced (Step1 filter+stats, Step2 interval extraction+dedup, Step3 save+output) and Step1 has explicit validation (missing-column checks, numeric-conversion try/except); Step3 lacks verification that the output file was written, a minor validation gap.

4 / 5

Progressive Disclosure

Content is well-sectioned under '## Skill Steps' with a clearly signaled one-level reference to the parent workflow SKILL.md; no bundle files are present so the structure is appropriate, though reliance on parent-context variables is not explicitly flagged as 'defined in parent'.

4 / 5

Total

16

/

20

Passed

Description

66%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 conveys a clear, specific capability set for multi-sheet Excel statistics and row-interval extraction, but omits any explicit 'when to use' trigger clause (capping completeness at 3) and contains a grammatical defect (dangling '与,').

Suggestions

Add an explicit trigger clause, e.g. 'Use when the user needs conditional group averages or row-interval extraction/dedup-summing from multi-sheet Excel files.'

Fix the dangling '与' in '进行基础统计与,' — either complete the phrase (e.g. '基础统计与分析') or remove the conjunction.

Include the '.xlsx' file extension and a synonym or two (e.g. '电子表格') to broaden natural trigger-term coverage.

DimensionReasoningScore

Specificity

Lists several concrete actions (基础统计, 按条件筛选计算均值, 从指定行区间提取数据去重求和, 生成结果文件与下载链接), matching the 'several specific actions; minor gaps' anchor; the dangling '与' and slight imprecision keep it below the comprehensive 5.

4 / 5

Completeness

The 'what' is clearly stated, but there is no 'Use when...' clause or equivalent explicit trigger guidance, so completeness is capped at 3 per the judging guideline — matches the 'clear what, when missing' anchor exactly.

3 / 5

Trigger Term Quality

Good natural-term coverage ('多Sheet Excel文件', '筛选', '均值', '去重求和', '行区间', '下载链接') that users would plausibly say, but missing file extensions like '.xlsx' and synonyms, so not a 5.

4 / 5

Distinctiveness Conflict Risk

The niche combination of row-interval extraction with dedup-sum plus conditional-group mean computation is mostly distinct from generic Excel skills, with only minor overlap risk with related analysis 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.