Turn a revenue table into a heatmap
FormattingEasyLLM judge scoringLatest run
Passed by all 12 products on their best model.
Prompt
Format table so we can easily observe revenue intensity.
Starting spreadsheet
Data| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Jan | Feb | Mar | Apr | May | Jun |
| 2 | North | 1200 | 1450 | 1620 | 1750 | 1810 | 1940 |
| 3 | South | 980 | 1120 | 1280 | 1330 | 1410 | 1490 |
| 4 | East | 1320 | 1490 | 1570 | 1690 | 1760 | 1880 |
| 5 | West | 870 | 930 | 1010 | 1100 | 1190 | 1250 |
Expected result
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked by an LLM judge.- A heatmap on B2:G5
- Low and high revenue clearly differ
- The headers stay unchanged and uncolored
Passed 21
Autosheet in Excel Opus 5.5 · Medium
Passed10s · 3¢
Autosheet in Excel GPT-6 Astra · Low
Passed8s · 5¢
Autosheet in Sheets Opus 5.5 · Medium
Passed18s · 5¢
Autosheet in Excel Sonnet 5.5 · Medium
Passed6s · 1¢
Claude in Excel Opus 5.5 · High
Passed14s · 12¢
Autosheet in Excel Haiku 5.5 · High
Passed6s · 0.1¢
Claude in Sheets Opus 5.5 · Medium
Passed29s · 11¢
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed46s · N/A
Autosheet in Excel GPT-6.1 Sol · Medium
Passed11s · 7¢
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed57s · N/A
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed46s · N/A
Autosheet in Sheets Haiku 5.5 · High
Passed19s · 0.1¢
ChatGPT in Excel GPT-6 Astra · Medium
Passed24s · 57¢
Claude in Excel Haiku 5.5 · High
Passed13s · 0.6¢
Claude in Sheets Haiku 5.5 · High
Passed25s · 0.6¢
Copilot in Excel Auto
Passed27s · N/A
ChatGPT + Drive MCP GPT-6 · Medium
Passed44s · N/A
ChatGPT in Excel GPT-6 Luna · High
Passed1m 15s · 0.9¢
Gemini in Sheets Auto
Passed1m 32s · N/A
ChatGPT in Sheets GPT-6 Astra · Medium
Passed48s · 56¢
ChatGPT in Sheets GPT-6 Luna · High
Passed52s · 0.7¢
Failed 1
Autosheet in Excel GPT-6 Luna · High
Failed8s · 0.2¢
Why it failed: Column A width was set to 2.33, truncating the row headers into illegible fragments ('N', 'So', 'Ea', 'W', 'egi') rather than keeping them fully visible.