Build an e-commerce KPI dashboard
ChartsMediumLLM judge scoringLatest run
Passed by 9 of 12 products on their best model. Failed: ChatGPT + Drive MCP, Gemini in Sheets and ChatGPT in Sheets.
Prompt
In a new Dashboard sheet, build me a dashboard with charts for orders, revenue, and customer count — I need to see the trends at a glance
Add a chart showing the return rate trend too
Starting spreadsheet
Sheet1| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Month | Orders | Revenue | Returns | Avg Order Value | Customer Count |
| 2 | Jan 2025 | 1240 | 87300 | 62 | 70.40 | 980 |
| 3 | Feb 2025 | 1380 | 96100 | 71 | 69.64 | 1050 |
| 4 | Mar 2025 | 1520 | 109800 | 89 | 72.24 | 1180 |
| 5 | Apr 2025 | 1410 | 101200 | 74 | 71.77 | 1120 |
| 6 | May 2025 | 1650 | 118400 | 92 | 71.76 | 1290 |
| 7 | Jun 2025 | 1780 | 131700 | 103 | 73.99 | 1380 |
| 8 | Jul 2025 | 1620 | 119500 | 98 | 73.77 | 1250 |
| 9 | Aug 2025 | 1590 | 115800 | 88 | 72.83 | 1230 |
| 10 | Sep 2025 | 1870 | 140200 | 108 | 74.97 | 1440 |
| 11 | Oct 2025 | 2010 | 154600 | 119 | 76.92 | 1560 |
| 12 | Nov 2025 | 2340 | 184700 | 142 | 78.93 | 1810 |
| 13 | Dec 2025 | 2680 | 217400 | 158 | 81.12 | 2070 |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- At least 2 trend charts of the monthly KPIs
- No pie charts for the monthly data
- A chart of the return rate
Passed 16
Autosheet in Excel Opus 5.5 · Medium
Autosheet in Excel GPT-6 Astra · Low
Autosheet in Sheets Opus 5.5 · Medium
Autosheet in Excel Sonnet 5.5 · Medium
Claude in Excel Opus 5.5 · High
Autosheet in Excel Haiku 5.5 · High
Claude in Sheets Opus 5.5 · Medium
Claude Code + Sheets MCP Opus 5.5 · Medium
Claude Code + Autosheet MCP Opus 5.5 · Medium
ChatGPT + Autosheet MCP GPT-6 · Medium
Autosheet in Sheets Haiku 5.5 · High
ChatGPT in Excel GPT-6 Astra · Medium
Claude in Excel Haiku 5.5 · High
Claude in Sheets Haiku 5.5 · High
Copilot in Excel Auto
ChatGPT in Excel GPT-6 Luna · High
Failed 6
Autosheet in Excel GPT-6.1 Sol · Medium
Why it failed: Dashboard KPI cards contain visible hash overflow (###) for primary metrics.
Autosheet in Excel GPT-6 Luna · High
Why it failed: Document 1 shows pervasive hash overflow (###) across data columns B, E, and H, clipped column headers ('IV Ord', 'IV Rev', 'IV Cust', 'IV Return R'), and clipped chart titles due to…
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: The 'TOTAL REVENUE' KPI card is materially clipped, showing '$1,576,7' instead of '$1,576,700', which conceals numbers and makes the value misleading/unreadable.
Gemini in Sheets Auto
Why it failed: Still working at the 5-minute time limit. No chart for returns or return rate was created; the four charts plot Revenue, Orders, Customer Count, and Average Order Value.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: The dashboard has no charts.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: The dashboard has no charts.