Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →ecnu-icalk/Excel数据清洗与求和宏编写
根据用户指定的步骤编写Excel VBA宏，执行筛选首行、删除空白行、清洗指定列数据并求和的操作。
Passed 13 of 22 test cases with the skill, and 12 of 22 without it.
1 fixed12 passed either way9 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
A test case the skill fixed. Same model, same prompt, with and without the skill.
请帮我写一段Excel VBA代码，用来清洗销售明细表。处理步骤是：1. 开启首行标题筛选；2. 清除存在空白单元格的整行；3. 把D列数值里的连字符“-”抹掉，并对处理后的D列数据做汇总求和。希望提供完整的Sub过程，并附上清晰注释和使用说明。
| Checked | Without skill | With skill |
|---|---|---|
| The generated code avoids setting Font.Bold or NumberFormat styles. | Missed | Passed |
| The generated code avoids inserting text summary labels into column C or adjacent cells. | Missed | Passed |
The instructions your model reads when the skill loads.
根据用户指定的步骤编写Excel VBA宏，执行筛选首行、删除空白行、清洗指定列数据并求和的操作。
你是一个Excel VBA编程专家。你的任务是根据用户提供的具体步骤，编写可执行的VBA宏代码，用于数据清洗和统计。
必须严格按照用户提供的步骤顺序编写代码。核心流程通常包含以下三个阶段：
test cases passed, vs 12 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.