CtrlK
BlogDocsLog inGet started
Tessl Logo

grouped-statistics

对多 Sheet 的 Excel 文件进行行数统计、数据合并与前向填充。

59

Quality

67%

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/grouped-statistics/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 delivers mostly executable, concise code across a clear three-step sequence, but the multi-sheet batch workflow lacks any data-validation checkpoint, capping workflow clarity. Actionability is strong yet held back by undefined upstream variables and hardcoded row ranges. Structure is clean with a single well-signaled parent reference.

Suggestions

Add a validation checkpoint after Step1 (e.g. assert row counts or print merged_df.head() to confirm the merge/ffill produced expected data) before proceeding to styling.

Define or document the assumed upstream variables (file_path, sheet_names) and replace hardcoded row ranges (iloc[21:63], iloc[5:47]) with dynamically detected boundaries so the code is copy-paste ready.

Move the large styling block in Step2 to a referenced script (e.g. scripts/style_report.py) to reduce inline bulk and improve progressive disclosure.

DimensionReasoningScore

Conciseness

The body is mostly lean executable code with brief Chinese step descriptions and operational comments, assuming Claude's competence without explaining pandas/openpyxl; it is efficient with only minor prose that could be trimmed, so it sits above anchor 3 but below the fully lean anchor 5.

4 / 5

Actionability

Each step provides concrete, executable Python (real imports, real API calls) for reading, styling, and saving, but the code relies on undefined upstream variables (file_path, sheet_names) and hardcoded row ranges (iloc[21:63], iloc[5:47]), which are minor gaps preventing a 5.

4 / 5

Workflow Clarity

Step1→Step2→Step3 are sequenced, but this multi-sheet batch operation has no data-validation checkpoint — Step3 only checks file existence — so per the destructive/batch cap workflow_clarity cannot exceed 3.

3 / 5

Progressive Disclosure

Content is organized into clearly labeled Step1/2/3 sections with a single one-level-deep pointer to the parent workflow SKILL.md and no nested references; it is well-structured but inlines all code in one file, leaving minor organization gaps versus the anchor-5 overview.

4 / 5

Total

15

/

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 clearly states concrete capabilities on multi-sheet Excel files but omits any explicit 'when to use' trigger guidance, capping completeness. Trigger-term and specificity coverage are solid but lack synonyms and file extensions. Adding a Use-when clause would raise the weakest dimensions.

Suggestions

Add an explicit 'Use when...' trigger clause, e.g. 'Use when the user needs to count rows across multiple Excel sheets, merge sheet data, or forward-fill merged-cell gaps in .xlsx files.'

Include natural synonyms and the file extension in the description (e.g. 'spreadsheets', '.xlsx', 'fill down') to broaden trigger-term coverage.

Mention the relationship to the parent workflow in the description so Claude can distinguish this sub-skill from the full pipeline.

DimensionReasoningScore

Specificity

Names the domain ('多 Sheet 的 Excel 文件') and three concrete actions ('行数统计、数据合并与前向填充'), matching the anchor that lists several specific actions with minor gaps; not a 5 because coverage is not comprehensive across the full workflow.

4 / 5

Completeness

The 'what' is clear (row statistics, merging, forward-fill on multi-sheet Excel), but there is no 'Use when...' clause or equivalent trigger guidance; per the rubric guideline, a missing explicit trigger caps completeness at 3.

3 / 5

Trigger Term Quality

Contains natural terms a user would say ('Excel 文件', '行数统计', '数据合并', '前向填充') with good coverage, but lacks common synonyms and the .xlsx extension, so it stops short of anchor 5.

4 / 5

Distinctiveness Conflict Risk

The multi-sheet row-count/merge/forward-fill niche is mostly distinct with only minor overlap risk against general Excel skills; it is more specific than the anchor-3 example but lacks trigger phrases that would push it to 5.

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.