Skip to content

Monthly regional report from messy orders CSV + shipments JSONL + weekday-only FX table

Exact prompt

# Task: monthly regional order report Inputs: `orders.csv`, `shipments.jsonl`, `fx.csv`. Write `report.py` (Python stdlib only) that reads those three files from the current directory and writes `report.json`, then run it. `report.json` shape: `{"<Region>": {"YYYY-MM": {"orders": int, "revenue_eur": float, "unshipped": int, "late": int}}}` Rules: - Regions are North/South/East/West; the raw data uses many spellings/abbreviations/cases/whitespace (n, NORTH, " North ", E, ...). Normalise to those four names. - Order IDs are case-insensitive (`o-00012` = `O-00012`). Rows that are exact duplicates of an earlier row are dropped. Cancelled orders (any case) are excluded entirely. - `order_date` is ISO `YYYY-MM-DD`, `DD/MM/YYYY`, or `Mon DD YYYY`. The month bucket is the order date's month. - Amounts: USD amounts may have thousands separators (`1,234.50`); EUR amounts may use a decimal comma (`12,50`); GBP is plain. Convert to EUR with `fx.csv` (EUR per 1 unit; EUR itself is 1.0) using the rate on the order date, or if there is none that day (weekends), the most recent earlier date. Round `revenue_eur` to 2 decimals only at the end (sum unrounded values). - `unshipped` = kept orders with no shipment record. `late` = kept orders whose **first** shipment date (UTC date of `shipped_at`) is more than 5 days after the order date. Shipments for unknown orders and blank lines are ignored. `report.py` will also be re-run by the grader on freshly generated data with the same format, so don't hard-code anything. No network.

Many small traps: region aliases, case-insensitive IDs, exact-duplicate rows, three date formats, locale-specific amounts, weekend FX fallback, first-shipment lateness across Z/+00:00, orphan shipments; re-run on fresh data blocks hard-coding. Original benchmark task written for usecaserank.com (not based on a specific public post). Headless, offline run on a reproducible fixture. Each run's notes say how its cost was measured (estimates are marked).

Success criteria: 1. report_exact: every region/month cell in report.json matches the key (counts exact, revenue_eur within 0.01) and no extra cells. 2. fresh_data_exact: the agent's report.py, re-run on a freshly generated dataset (seed 9191), produces an exactly matching report.

Best model for this task so far: Claude Haiku 5.5 (effort default (no --effort flag) · thinking on) (success, $0.0087, 35s).

Run this on another model

All runs (4)

100% pass rate across 4 eligible runs: 4 pass, 0 partial, 0 fail. Partial and failed runs are listed below with everything else.ⓘ

Runs for this use case
ModelCostTimeStep-insⓘAutonomyOutcomeTrustⓘDateCompare
OGPT-6.1 Soldefault · thinking on$0.0447s0Fully autonomouspassTrust 80%2026-10-22
AClaude Haiku 5.5default · thinking on$0.008735s0Fully autonomouspassTrust 80%2026-10-17
AClaude Opus 5.5default · thinking on$0.2345s0Fully autonomouspassTrust 80%2026-10-17
AClaude Sonnet 5.5default · thinking on$0.0719s0Fully autonomouspassTrust 80%2026-10-17

Embed this result

A live badge for this use case. It links back here and updates as new runs are published.

UseCaseRank badge for Monthly regional report from messy orders CSV + shipments JSONL + weekday-only FX table

Get new runs and ranking changes weekly

Which models got better or cheaper on real tasks like this one.