Make a table look professional
FormattingHardLLM judge scoringLatest run
Passed by 2 of 12 products on their best model: Autosheet in Excel and Autosheet in Sheets.
Prompt
Make this table look professionnal.
Starting spreadsheet
Data| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Date | Items sold | Revenue | Target revenue | Above target | Margin | Margin % |
| 2 | 45672 | 1250 | 18500 | 17000 | TRUE | 6200 | 0.3351 |
| 3 | 45689 | 980 | 14250 | 15000 | FALSE | 4100 | 0.2877 |
| 4 | 45705 | 2100 | 26300 | 24000 | TRUE | 7900 | 0.3004 |
| 5 | 45721 | 1575 | 19800 | 20000 | FALSE | 5600 | 0.2828 |
| 6 | 45737 | 3050 | 41200 | 38000 | TRUE | 12600 | 0.3058 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- Formatted in place, with a distinct header
- Dates as dates, thousands separators on quantities
- Currency and percentage formats
- Above target colored green or red
Passed 4
Autosheet in Excel Opus 5.5 · Medium
Autosheet in Excel GPT-6 Astra · Low
Autosheet in Sheets Opus 5.5 · Medium
Autosheet in Excel GPT-6.1 Sol · Medium
Failed 18
Autosheet in Excel Sonnet 5.5 · Medium
Why it failed: The 'Above target' values (TRUE/FALSE) are displayed in plain black font without any green/red text or cell background color coding.
Claude in Excel Opus 5.5 · High
Why it failed: Revenue and Target revenue were given number format '#,##0' without currency formatting or symbols.
Autosheet in Excel Haiku 5.5 · High
Why it failed: Revenue and Target revenue were formatted with standard thousands separators without any currency formatting/symbol.
Claude in Sheets Opus 5.5 · Medium
Why it failed: Revenue and Target revenue were formatted as plain integers with comma separators rather than being formatted as currency.
Claude Code + Sheets MCP Opus 5.5 · Medium
Why it failed: The 'Above target' column uses standard checkboxes rather than visual color coding (such as green for TRUE and red for FALSE).
Claude Code + Autosheet MCP Opus 5.5 · Medium
Why it failed: Above target values remain standard text without color coding.
ChatGPT + Autosheet MCP GPT-6 · Medium
Why it failed: The Above target column is not color coded; TRUE and FALSE are displayed as standard black text.
Autosheet in Sheets Haiku 5.5 · High
Why it failed: The 'Above target' column shows standard black text ('TRUE'/'FALSE') with no color coding applied.
ChatGPT in Excel GPT-6 Astra · Medium
Why it failed: Revenue and Target revenue get thousands separators but no currency format.
Claude in Excel Haiku 5.5 · High
Why it failed: Revenue and Target revenue are formatted as plain integers with space separators (e.g., 18 500) rather than currency.
Claude in Sheets Haiku 5.5 · High
Why it failed: Revenue and Target revenue are formatted as plain numbers (#,##0) without any currency formatting or currency symbols.
Autosheet in Excel GPT-6 Luna · High
Why it failed: Revenue amounts lack currency symbols.
Copilot in Excel Auto
Why it failed: Revenue and Target revenue lack currency symbols.
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: Revenue and Target revenue columns are formatted with plain thousand separators (e.g., 18,500) rather than currency symbols/formatting.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: Revenue and Target revenue are formatted as standard numbers with thousand separators ('18 500', '17 000') rather than as currency.
Gemini in Sheets Auto
Why it failed: The 'Above target' column contains plain black text with white backgrounds and is not visually color coded.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: Revenue and Target revenue are formatted as plain numbers with thousands separators (e.g., '18,500', '17,000') rather than currency formatted with a currency symbol.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: Revenue and Target revenue were formatted with commas but lack currency formatting (as noted in the transcript: 'I left revenue and margin without a currency symbol').