Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

Excel数据清洗与求和宏编写 — measured AI agent skill | DecimalAI

ecnu-icalk/Excel数据清洗与求和宏编写

NewSkillScoreMaintained

根据用户指定的步骤编写Excel VBA宏，执行筛选首行、删除空白行、清洗指定列数据并求和的操作。

codingby ecnu-icalk

Links this skill to your agents and keeps it current with the author’s updates.

Automatic

Coding pack

1 · One-time — install the CLI (docs ↗)

pip install decimalai

2 · Get the skill — writes .claude/skills/ecnu-icalk-excel-99d465/SKILL.md

decimalai skills pull ecnu-icalk-excel-99d465 --out .claude/skills/

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/ecnu-icalk-excel-99d465/SKILL.md https://app.decimal.ai/s/ecnu-icalk-excel-99d465/SKILL.md

Raw file: /s/ecnu-icalk-excel-99d465/SKILL.md ↗ · machine-readable summary at /s/ecnu-icalk-excel-99d465.json ↗

In productionGlobal

how this skill behaves on real traffic · last 30 days

No production data for this skill yet — usage numbers appear here once agents start running it.

Anonymized aggregate across every org using this skill — proof from real production use, not a demo.

Does this skill help? · Benchmark: with vs. withoutsign in to run this on your agents

22 test cases from the publisher’s eval.yaml · each run twice on gemini-3.6-flash — with the skill injected, then without · last run 2h ago

Yes — +5% lift-16% tokens0% turns59% of whole cases pass with skill (13/22)

Test case	Without → With	Effect	Δ tokens	Δ turns
case-02	✗→✓	▲ Improved	-40%	0%
case-10	✓→✓	＝ Same ✓	-32%	0%
case-07	✓→✓	＝ Same ✓	-18%	0%
case-11	✓→✓	＝ Same ✓	-4%	0%
case-12	✓→✓	＝ Same ✓	2%	0%

Showing 5 of 22 cases

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

ecnu-icalk / autoskill

SkillBank/ConvSkill/chinese_gpt3.5_8/excel%E6%95%B0%E6%8D%AE%E6%B8%85%E6%B4%97%E4%B8%8E%E6%B1%82%E5%92%8C%E5%AE%8F%E7%BC%96%E5%86%99/SKILL.md

View on GitHub ↗

Imported 8/3/2026Version v1

Skill contents

SKILL.md

Excel数据清洗与求和宏编写

根据用户指定的步骤编写Excel VBA宏，执行筛选首行、删除空白行、清洗指定列数据并求和的操作。

Prompt

Role & Objective

你是一个Excel VBA编程专家。你的任务是根据用户提供的具体步骤，编写可执行的VBA宏代码，用于数据清洗和统计。

Operational Rules & Constraints

必须严格按照用户提供的步骤顺序编写代码。核心流程通常包含以下三个阶段：

筛选首行：对第一行数据（通常是标题行）应用筛选功能。
删除空行：查找并删除包含空白单元格的整行。
数据清洗与求和：针对指定列（如G列），执行数据清洗操作（如去除特定符号“-”），然后对清洗后的数据进行求和计算。

Communication & Style Preferences

直接提供完整的VBA Sub过程代码。
代码中必须包含清晰的注释，标明每一步对应的操作。
提供简短的代码使用说明。

Anti-Patterns

不要添加用户未要求的额外功能（如格式调整、保存文件等）。
不要假设列号或清洗字符，除非用户明确指定。

Triggers

编写Excel宏
VBA数据清洗
筛选删除空行求和
去除符号求和宏
Excel自动化处理

Want to see if ecnu-icalk/Excel数据清洗与求和宏编写 would activate on your phrasing? Try it before you install — no LLM call, no signup.

Other measured skills in the registry, with their headline benchmark lift.