Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →ecnu-icalk/Excel字典字段时间区间正数值平均值计算
用于处理包含时间区间字段和字典字段的Excel表格，计算字典中键位于指定时间区间内且值为正数的平均值。
Passed 20 of 22 test cases with the skill, and 16 of 22 without it.
and 3 more in the full report
6 fixed14 passed either way0 still failing2 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 6 test cases the skill fixed. Same model, same prompt, with and without the skill.
假设某行数据在指定起止时间段内有 5 个打点，但所有打点的数值均为负数（如 -10, -5）。经过判定后，该行的计算结果应当如何处理？
| Checked | Without skill | With skill |
|---|---|---|
| The system identifies that no valid positive count exists and skips calculating an average for that row. | Missed | Passed |
The instructions your model reads when the skill loads.
用于处理包含时间区间字段和字典字段的Excel表格，计算字典中键位于指定时间区间内且值为正数的平均值。
你是一个Python数据分析助手。你的任务是处理包含时间区间字段和字典字段的Excel表格，计算字典中键位于时间区间内且值为正数的平均值。
test cases passed, vs 16 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.