All AutosheetBench tasks

Make a financial report presentation-ready

FormattingEasyLLM judge scoringLatest run

Passed by 11 of 12 products on their best model. Failed: Gemini in Sheets.

Prompt and starting spreadsheet

Task files

Prompt

Format this spreadsheet to look presentation-ready

The currency columns need proper formatting — and highlight anything negative in red

Add borders around the whole table and freeze the header row

Starting spreadsheet

Sheet1
ABCDEFG
1AccountQ1 ActualQ1 BudgetQ1 VarianceQ2 ActualQ2 BudgetQ2 Variance
2Revenue482000500000-1800053100051000021000
3COGS-289000-30000011000-312000-306000-6000
4Gross Profit193000200000-700021900020400015000
5Sales & Marketing-54000-50000-4000-61000-55000-6000
6Research & Development-38000-35000-3000-42000-40000-2000
7General & Administrative-29000-28000-1000-31000-30000-1000
8Depreciation-12000-120000-12000-120000
9Operating Expenses-133000-125000-8000-146000-137000-9000
10EBITDA6000075000-1500073000670006000
11Interest Expense-8000-80000-8000-80000
12Tax Provision-14000-180004000-17000-180001000
13Net Income3800049000-1100048000410007000
14
15Total YTD Revenue1013000
16YTD Net Income86000

A passing output

Autosheet in Excel · Opus 5.5

How each AI configuration did

21 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked by an LLM judge.
  • The header row is styled
  • A currency format on columns B to G
  • Negatives highlighted in red
  • Borders around the table and a frozen header
  • All three requests handled

Passed 21

Autosheet in Excel Opus 5.5 · Medium

Passed45s · 15¢

Autosheet in Excel GPT-6 Astra · Low

Passed32s · 30¢

Autosheet in Sheets Opus 5.5 · Medium

Passed1m 6s · 23¢

Autosheet in Excel Sonnet 5.5 · Medium

Passed24s · 7¢

Claude in Excel Opus 5.5 · High

Passed1m 12s · 45¢

Autosheet in Excel Haiku 5.5 · High

Passed33s · 0.6¢

Claude in Sheets Opus 5.5 · Medium

Passed1m 11s · 20¢

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed2m 35s · N/A

Autosheet in Excel GPT-6.1 Sol · Medium

Passed1m 4s · 16¢

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed3m 5s · N/A

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed2m 59s · N/A

Autosheet in Sheets Haiku 5.5 · High

Passed1m 9s · 0.9¢
Sheet1No cell changed
ABCDEFG
1AccountQ1 ActualQ1 BudgetQ1 VarianceQ2 ActualQ2 BudgetQ2 Variance
2Revenue$482,000$500,000($18,000)$531,000$510,000$21,000
3COGS($289,000)($300,000)$11,000($312,000)($306,000)($6,000)
4Gross Profit$193,000$200,000($7,000)$219,000$204,000$15,000
5Sales & Marketing($54,000)($50,000)($4,000)($61,000)($55,000)($6,000)
6Research & Development($38,000)($35,000)($3,000)($42,000)($40,000)($2,000)
7General & Administrative($29,000)($28,000)($1,000)($31,000)($30,000)($1,000)
8Depreciation($12,000)($12,000)-($12,000)($12,000)-
9Operating Expenses($133,000)($125,000)($8,000)($146,000)($137,000)($9,000)
10EBITDA$60,000$75,000($15,000)$73,000$67,000$6,000
11Interest Expense($8,000)($8,000)-($8,000)($8,000)-
12Tax Provision($14,000)($18,000)$4,000($17,000)($18,000)$1,000
13Net Income$38,000$49,000($11,000)$48,000$41,000$7,000
14
15Total YTD Revenue$1,013,000
16YTD Net Income$86,000

ChatGPT in Excel GPT-6 Astra · Medium

Passed2m 10s · $2.20

Claude in Excel Haiku 5.5 · High

Passed52s · 2¢

Claude in Sheets Haiku 5.5 · High

Passed1m 20s · 2¢
Sheet11 cell changed
ABCDEFG
1Account ($)Q1 ActualQ1 BudgetQ1 VarianceQ2 ActualQ2 BudgetQ2 Variance
2Revenue$482,000$500,000$(18,000)$531,000$510,000$21,000
3COGS$(289,000)$(300,000)$11,000$(312,000)$(306,000)$(6,000)
4Gross Profit$193,000$200,000$(7,000)$219,000$204,000$15,000
5Sales & Marketing$(54,000)$(50,000)$(4,000)$(61,000)$(55,000)$(6,000)
6Research & Development$(38,000)$(35,000)$(3,000)$(42,000)$(40,000)$(2,000)
7General & Administrative$(29,000)$(28,000)$(1,000)$(31,000)$(30,000)$(1,000)
8Depreciation$(12,000)$(12,000)$-$(12,000)$(12,000)$-
9Operating Expenses$(133,000)$(125,000)$(8,000)$(146,000)$(137,000)$(9,000)
10EBITDA$60,000$75,000$(15,000)$73,000$67,000$6,000
11Interest Expense$(8,000)$(8,000)$-$(8,000)$(8,000)$-
12Tax Provision$(14,000)$(18,000)$4,000$(17,000)$(18,000)$1,000
13Net Income$38,000$49,000$(11,000)$48,000$41,000$7,000
14
15Total YTD Revenue$1,013,000
16YTD Net Income$86,000

Autosheet in Excel GPT-6 Luna · High

Passed41s · 1¢

Copilot in Excel Auto

Passed1m 21s · N/A

ChatGPT + Drive MCP GPT-6 · Medium

Passed1m 50s · N/A

ChatGPT in Excel GPT-6 Luna · High

Passed2m 51s · 3¢

ChatGPT in Sheets GPT-6 Astra · Medium

Passed2m 45s · $2.40

ChatGPT in Sheets GPT-6 Luna · High

Passed4m 12s · 2¢
Sheet1No cell changed
ABCDEFG
1AccountQ1 ActualQ1 BudgetQ1 VarianceQ2 ActualQ2 BudgetQ2 Variance
2Revenue$482,000$500,000($18,000)$531,000$510,000$21,000
3COGS($289,000)($300,000)$11,000($312,000)($306,000)($6,000)
4Gross Profit$193,000$200,000($7,000)$219,000$204,000$15,000
5Sales & Marketing($54,000)($50,000)($4,000)($61,000)($55,000)($6,000)
6Research & Development($38,000)($35,000)($3,000)($42,000)($40,000)($2,000)
7General & Administrative($29,000)($28,000)($1,000)($31,000)($30,000)($1,000)
8Depreciation($12,000)($12,000)0($12,000)($12,000)0
9Operating Expenses($133,000)($125,000)($8,000)($146,000)($137,000)($9,000)
10EBITDA$60,000$75,000($15,000)$73,000$67,000$6,000
11Interest Expense($8,000)($8,000)0($8,000)($8,000)0
12Tax Provision($14,000)($18,000)$4,000($17,000)($18,000)$1,000
13Net Income$38,000$49,000($11,000)$48,000$41,000$7,000
14
15Total YTD Revenue$1,013,000
16YTD Net Income$86,000

Failed 1

Gemini in Sheets Auto

Failed5m · N/A

Why it failed: Still working at the 5-minute time limit. The header row was not frozen (no freeze line extends across columns H–L).