Tasks · desk · Spreadsheet
August sales commissions with refund recoveries
commission-calculation · timeout 1800 s · source
The ask
Sent verbatim as the prompt. The agent works in a copy of the workspace below and sees nothing else.
Work out August commissions for the team sales reps and save them as commissions.xlsx. Everything you need is in the folder - the plan, July's statement, the CRM export, the refunds and Marcus's emails.
Workspace
- commission_statement_2026-07.xlsx
- crm_opportunities_2026-08.csv
- email_from_marcus.txt
- refunds_processed_august.csv
- team_sales_commission_plan_2026.pdf
Expected deliverables
- commissions.xlsx
Checks
The task passes only when every required check passes. Reference answers, tolerances, and the planted traps are in the repository, not here.
| Check | Type | Required | Failed (frozen) / 6 |
|---|---|---|---|
| live formulas | xlsx_has_formulas | yes | 0 |
| no error cells | xlsx_no_errors | yes | 0 |
| Osei commission (graduated bands, split deals halved) | xlsx_value_present | yes | 0 |
| Brooks net payout (July deal recovered at 8%) | xlsx_value_present | yes | 0 |
| Kim net payout (August deal recovered at 3%) | xlsx_value_present | yes | 0 |
| Haddad net payout (senior plan, July deal at the standard rate) | xlsx_value_present | yes | 0 |
| total net payout | xlsx_value_present | yes | 1 |
Recorded results, complete desk comparison
pass pass, frozen scorer only fail timed out
| System | Repetitions | Frozen / 3 | Raw / 3 | Median minutes | Mean cost (USD) |
|---|---|---|---|---|---|
| Proto / DeepSeek V4.1 Flash | 3 | 3 | 4.7 | 0.0532 | |
| Codex / GPT-5.6 sol | 2 | 2 | 7.4 | 0.7442 |
Per-attempt check verdicts, raw and frozen verdicts, usage, receipt and artifact hashes for this task are in results/latest/attempts.jsonl under "task": "commission-calculation".