Business Bench

Tasks · desk · Spreadsheet

Consolidate the crew timesheets for payroll

timesheet-consolidate · 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.

Can you pull the crew timesheets for this pay period into one table for payroll, overtime worked out? Save it as hours.csv. Rachel's note says how we count hours.

Workspace

  • install_crew_timesheet_0830.xlsx
  • install_crew_timesheet_0906.xlsx
  • irrigation_a_william.xlsx
  • irrigation_b_william.xlsx
  • maintenance_crew_week_2026-08-30.csv
  • maintenance_crew_week_2026-09-06.csv
  • note_from_rachel.txt

Expected deliverables

  • hours.csv

This task also has a task-specific grader (check.py).

Checks

The task passes only when every required check passes. Reference answers, tolerances, and the planted traps are in the repository, not here.

CheckTypeRequiredFailed (frozen) / 6
requested columnscsv_columnsyes0
people on the tablecsv_set_equalyes0
row count (one line per person per week)csv_row_countyes0
total hours per person-weekcustomyes0
overtime per person-weekcustomyes0

Recorded results, complete desk comparison

pass pass, frozen scorer only fail timed out
SystemRepetitionsFrozen / 3Raw / 3Median minutesMean cost (USD)
Proto / DeepSeek V4.1 Flash331.50.0229
Codex / GPT-5.6 sol332.20.2917

Per-attempt check verdicts, raw and frozen verdicts, usage, receipt and artifact hashes for this task are in results/latest/attempts.jsonl under "task": "timesheet-consolidate".