Group rows by category
Spreadsheet manipulationHardDeterministic scoringLatest run
Passed by 9 of 12 products on their best model. Failed: Copilot in Excel, Gemini in Sheets and ChatGPT in Sheets.
Prompt
Group the rows by category (alphabetical order) so I can collapse them.
Starting spreadsheet
Sheet1| A | B | C | |
|---|---|---|---|
| 1 | Category | Item | Amount |
| 2 | Travel | Flights | 1200 |
| 3 | Office | Supplies | 150 |
| 4 | Marketing | Ads | 900 |
| 5 | Travel | Hotel | 800 |
| 6 | Office | Software | 600 |
| 7 | Marketing | Events | 1100 |
| 8 | Travel | Meals | 300 |
A passing output
Autosheet in Excel · Opus 5.5Pass criteria
All must be met, checked automatically.- Rows are grouped into 3 collapsible categories
Passed 11
Autosheet in Excel Opus 5.5 · Medium
Autosheet in Excel GPT-6 Astra · Low
Autosheet in Sheets Opus 5.5 · Medium
Claude in Excel Opus 5.5 · High
Claude in Sheets Opus 5.5 · Medium
Claude Code + Sheets MCP Opus 5.5 · Medium
Autosheet in Excel GPT-6.1 Sol · Medium
Claude Code + Autosheet MCP Opus 5.5 · Medium
ChatGPT + Autosheet MCP GPT-6 · Medium
ChatGPT in Excel GPT-6 Astra · Medium
ChatGPT + Drive MCP GPT-6 · Medium
Failed 11
Autosheet in Excel Sonnet 5.5 · Medium
Why it failed: The rows aren't grouped by category.
Autosheet in Excel Haiku 5.5 · High
Why it failed: The rows aren't grouped by category.
Autosheet in Sheets Haiku 5.5 · High
Why it failed: The rows aren't grouped by category.
Claude in Excel Haiku 5.5 · High
Why it failed: The rows aren't grouped by category.
Claude in Sheets Haiku 5.5 · High
Why it failed: The rows aren't grouped by category.
Autosheet in Excel GPT-6 Luna · High
Why it failed: The rows aren't grouped by category.
Copilot in Excel Auto
Why it failed: The rows aren't grouped by category.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: The rows aren't grouped by category.
Gemini in Sheets Auto
Why it failed: The rows aren't grouped by category.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: The rows aren't grouped by category.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: The rows aren't grouped by category.