MRR by month and churn for the first half
mrr-report · timeout 1200 s · source
The ask
Sent verbatim as the prompt. The agent works in a copy of the workspace below and sees nothing else.
The board pack needs our MRR month by month for the first half and what we lost to churn. Build it as mrr.xlsx with live formulas and write memo.md alongside it. Marcus's email says how he wants the subscriptions counted.
Workspace
- email_from_finance.txt
- opening_book_dec2025.xlsx
- subscription_events_2026.csv
Expected deliverables
- memo.md
- mrr.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 |
|---|---|---|---|
| mrr.xlsx exists | file_exists | yes | 0 |
| live formulas | xlsx_has_formulas | yes | 0 |
| no error cells | xlsx_no_errors | yes | 0 |
| March ending MRR | xlsx_value_present | yes | 1 |
| June ending MRR | xlsx_value_present | yes | 1 |
| churned MRR in May | xlsx_value_present | yes | 2 |
| churned MRR for the half | xlsx_value_present | yes | 1 |
| memo carries the June MRR and the churn figure | text_numbers_present | yes | 0 |
| memo names the month the churn landed in | text_sentence_matches | 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 | 1 | 1 | 10.1 | 0.1212 | |
| Codex / GPT-5.6 sol | 1 | 1 | 8.9 | 0.9275 |
Per-attempt check verdicts, raw and frozen verdicts, usage, receipt and artifact hashes for this task are in results/latest/attempts.jsonl under "task": "mrr-report".