CtrlK
BlogDocsLog inGet started
Tessl Logo

large-file-conditional-formatting

根据Excel总行数自动切换Parquet加速读取,计算特定维度的时间序列平均值,并使用openpyxl输出带有条件格式(如低于均值标绿)和自定义样式的分析报告。

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-cell-coloring/threshold-cell-coloring/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 skill provides executable, concise code organized into a clear three-step sequence, but it has an undefined-variable data-flow gap, no validation checkpoints, and keeps all content inline with no reference split.

Suggestions

Fix the Step1→Step2 data flow: assign the loaded sheet DataFrame to 'df' (or explicitly re-read the target sheet in Step2) so the code runs as written.

Add a validation/verification checkpoint before export (e.g., assert result_df is non-empty and avg_value is finite, then confirm output_report.xlsx was written).

Extract the reusable styling logic into a scripts/ helper (e.g., apply_conditional_format.py) and reference it from SKILL.md to improve progressive disclosure.

DimensionReasoningScore

Conciseness

Prose is minimal and task-specific; code is the actual work product with brief comments and no re-explanation of concepts Claude already knows, matching the lean/efficient anchor.

3 / 3

Actionability

Code is concrete and copy-paste-oriented, but Step2 references an undefined 'df' (Step1 used 'df_temp') and hardcodes placeholder assumptions ('iloc[6, 1:10]', target_entity='Target_Entity'), leaving key details incomplete.

2 / 3

Workflow Clarity

Three steps are sequenced, but there are no validation checkpoints and a data-flow gap between Step1 and Step2 (df never assigned), fitting the 'sequence present but checkpoints missing' anchor.

2 / 3

Progressive Disclosure

Content is organized into labeled steps, but at >50 lines with no bundle/reference files everything is inline, matching the 'structure exists but content that should be separate is inline' anchor.

2 / 3

Total

9

/

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 clearly distinct, but it states only what the skill does without an explicit 'Use when...' trigger clause, leaving the activation condition implicit.

Suggestions

Add an explicit 'Use when...' clause naming natural triggers (e.g., 'Use when generating Excel analysis reports with conditional formatting, or when the user asks to highlight below-average values in green').

Soften jargon toward user-spoken terms (e.g., 'highlight below-average rows in green' alongside '条件格式') to improve trigger-term coverage.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — '自动切换Parquet加速读取', '计算特定维度的时间序列平均值', '使用openpyxl输出带有条件格式(如低于均值标绿)和自定义样式' — matching the multi-action anchor rather than the single-domain score-2 example.

3 / 3

Completeness

Clearly answers 'what' with concrete actions but has no explicit 'when/Use when' trigger guidance, which per the guidelines caps completeness at 2.

2 / 3

Trigger Term Quality

Contains relevant terms (Excel, Parquet, openpyxl, 条件格式, 低于均值标绿) but leans technical (Parquet加速读取, 时间序列) and lacks common user-said variations; not the broad natural coverage of the score-3 anchor.

2 / 3

Distinctiveness Conflict Risk

The Excel + Parquet + openpyxl + conditional-formatting niche is specific and unlikely to trigger for unrelated skills, matching the distinct-niche anchor.

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.