Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →dongsheng123132/excel-helper
Excel 表格助手 - 公式编写、数据透视表、图表可视化、宏自动化、数据清洗
Passed 22 of 22 test cases with the skill, and 21 of 22 without it.
1 fixed21 passed either way0 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.
In Excel column A (dates) and column B (amounts), write a formula to sum amounts where the date is on or after January 1, 2024. A colleague suggested manually filtering, but I need an automated formula.
| Checked | Without skill | With skill |
|---|---|---|
| Uses the SUMIF function | Missed | Passed |
| Includes the comparison operator >= within the criteria argument | Passed | Passed |
The instructions your model reads when the skill loads.
专业的数据处理和分析工具，帮你高效完成表格制作和数据计算。
=SUMIF(A:A,">=2024-01-01",B:B) -- 条件求和
=COUNTIF(B:B,">100") -- 条件计数
=AVERAGEIF(C:C,"北京",D:D) -- 条件平均
=VLOOKUP(E2,数据源!A:C,3,FALSE) -- 垂直查找
=INDEX(B:B,MATCH(D2,A:A,0)) -- 反向查找
=XLOOKUP(查找值,查找列,返回列) -- 现代查找
=TEXT(A2,"YYYY-MM") -- 格式化日期
=EDATE(B2,3) -- 日期加减
=WEEKDAY(C2,2) -- 星期几
| 数据类型 | 推荐图表 |
|---|---|
| 趋势变化 | 折线图 |
test cases passed, vs 21 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.