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
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| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Account | Q1 Actual | Q1 Budget | Q1 Variance | Q2 Actual | Q2 Budget | Q2 Variance |
| 2 | Revenue | 482000 | 500000 | -18000 | 531000 | 510000 | 21000 |
| 3 | COGS | -289000 | -300000 | 11000 | -312000 | -306000 | -6000 |
| 4 | Gross Profit | 193000 | 200000 | -7000 | 219000 | 204000 | 15000 |
| 5 | Sales & Marketing | -54000 | -50000 | -4000 | -61000 | -55000 | -6000 |
| 6 | Research & Development | -38000 | -35000 | -3000 | -42000 | -40000 | -2000 |
| 7 | General & Administrative | -29000 | -28000 | -1000 | -31000 | -30000 | -1000 |
| 8 | Depreciation | -12000 | -12000 | 0 | -12000 | -12000 | 0 |
| 9 | Operating Expenses | -133000 | -125000 | -8000 | -146000 | -137000 | -9000 |
| 10 | EBITDA | 60000 | 75000 | -15000 | 73000 | 67000 | 6000 |
| 11 | Interest Expense | -8000 | -8000 | 0 | -8000 | -8000 | 0 |
| 12 | Tax Provision | -14000 | -18000 | 4000 | -17000 | -18000 | 1000 |
| 13 | Net Income | 38000 | 49000 | -11000 | 48000 | 41000 | 7000 |
| 14 | |||||||
| 15 | Total YTD Revenue | 1013000 | |||||
| 16 | YTD Net Income | 86000 |
A passing output
Autosheet in Excel · Opus 5.5Excel 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¢
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Account | Q1 Actual | Q1 Budget | Q1 Variance | Q2 Actual | Q2 Budget | Q2 Variance |
| 2 | Revenue | $482,000 | $500,000 | ($18,000) | $531,000 | $510,000 | $21,000 |
| 3 | COGS | ($289,000) | ($300,000) | $11,000 | ($312,000) | ($306,000) | ($6,000) |
| 4 | Gross Profit | $193,000 | $200,000 | ($7,000) | $219,000 | $204,000 | $15,000 |
| 5 | Sales & Marketing | ($54,000) | ($50,000) | ($4,000) | ($61,000) | ($55,000) | ($6,000) |
| 6 | Research & Development | ($38,000) | ($35,000) | ($3,000) | ($42,000) | ($40,000) | ($2,000) |
| 7 | General & Administrative | ($29,000) | ($28,000) | ($1,000) | ($31,000) | ($30,000) | ($1,000) |
| 8 | Depreciation | ($12,000) | ($12,000) | - | ($12,000) | ($12,000) | - |
| 9 | Operating Expenses | ($133,000) | ($125,000) | ($8,000) | ($146,000) | ($137,000) | ($9,000) |
| 10 | EBITDA | $60,000 | $75,000 | ($15,000) | $73,000 | $67,000 | $6,000 |
| 11 | Interest Expense | ($8,000) | ($8,000) | - | ($8,000) | ($8,000) | - |
| 12 | Tax Provision | ($14,000) | ($18,000) | $4,000 | ($17,000) | ($18,000) | $1,000 |
| 13 | Net Income | $38,000 | $49,000 | ($11,000) | $48,000 | $41,000 | $7,000 |
| 14 | |||||||
| 15 | Total YTD Revenue | $1,013,000 | |||||
| 16 | YTD 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¢
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Account ($) | Q1 Actual | Q1 Budget | Q1 Variance | Q2 Actual | Q2 Budget | Q2 Variance |
| 2 | Revenue | $482,000 | $500,000 | $(18,000) | $531,000 | $510,000 | $21,000 |
| 3 | COGS | $(289,000) | $(300,000) | $11,000 | $(312,000) | $(306,000) | $(6,000) |
| 4 | Gross Profit | $193,000 | $200,000 | $(7,000) | $219,000 | $204,000 | $15,000 |
| 5 | Sales & Marketing | $(54,000) | $(50,000) | $(4,000) | $(61,000) | $(55,000) | $(6,000) |
| 6 | Research & Development | $(38,000) | $(35,000) | $(3,000) | $(42,000) | $(40,000) | $(2,000) |
| 7 | General & Administrative | $(29,000) | $(28,000) | $(1,000) | $(31,000) | $(30,000) | $(1,000) |
| 8 | Depreciation | $(12,000) | $(12,000) | $- | $(12,000) | $(12,000) | $- |
| 9 | Operating Expenses | $(133,000) | $(125,000) | $(8,000) | $(146,000) | $(137,000) | $(9,000) |
| 10 | EBITDA | $60,000 | $75,000 | $(15,000) | $73,000 | $67,000 | $6,000 |
| 11 | Interest Expense | $(8,000) | $(8,000) | $- | $(8,000) | $(8,000) | $- |
| 12 | Tax Provision | $(14,000) | $(18,000) | $4,000 | $(17,000) | $(18,000) | $1,000 |
| 13 | Net Income | $38,000 | $49,000 | $(11,000) | $48,000 | $41,000 | $7,000 |
| 14 | |||||||
| 15 | Total YTD Revenue | $1,013,000 | |||||
| 16 | YTD 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¢
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Account | Q1 Actual | Q1 Budget | Q1 Variance | Q2 Actual | Q2 Budget | Q2 Variance |
| 2 | Revenue | $482,000 | $500,000 | ($18,000) | $531,000 | $510,000 | $21,000 |
| 3 | COGS | ($289,000) | ($300,000) | $11,000 | ($312,000) | ($306,000) | ($6,000) |
| 4 | Gross Profit | $193,000 | $200,000 | ($7,000) | $219,000 | $204,000 | $15,000 |
| 5 | Sales & Marketing | ($54,000) | ($50,000) | ($4,000) | ($61,000) | ($55,000) | ($6,000) |
| 6 | Research & Development | ($38,000) | ($35,000) | ($3,000) | ($42,000) | ($40,000) | ($2,000) |
| 7 | General & Administrative | ($29,000) | ($28,000) | ($1,000) | ($31,000) | ($30,000) | ($1,000) |
| 8 | Depreciation | ($12,000) | ($12,000) | 0 | ($12,000) | ($12,000) | 0 |
| 9 | Operating Expenses | ($133,000) | ($125,000) | ($8,000) | ($146,000) | ($137,000) | ($9,000) |
| 10 | EBITDA | $60,000 | $75,000 | ($15,000) | $73,000 | $67,000 | $6,000 |
| 11 | Interest Expense | ($8,000) | ($8,000) | 0 | ($8,000) | ($8,000) | 0 |
| 12 | Tax Provision | ($14,000) | ($18,000) | $4,000 | ($17,000) | ($18,000) | $1,000 |
| 13 | Net Income | $38,000 | $49,000 | ($11,000) | $48,000 | $41,000 | $7,000 |
| 14 | |||||||
| 15 | Total YTD Revenue | $1,013,000 | |||||
| 16 | YTD 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).