Build a cover sheet for a project plan
Spreadsheet manipulationEasyLLM judge scoringLatest run
Passed by all 12 products on their best model.
Prompt
Create a cover sheet for this project plan — include formulas that pull the earliest start and latest end date from the Tasks sheet
Starting spreadsheet
Tasks| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Task | Owner | Start Date | End Date | Status | Priority |
| 2 | Discovery & Requirements | Sarah Kim | 2024-01-08 | 2024-01-19 | Complete | High |
| 3 | Architecture Design | David Patel | 2024-01-15 | 2024-02-02 | Complete | High |
| 4 | Database Schema | Raj Nguyen | 2024-01-22 | 2024-02-09 | Complete | Medium |
| 5 | API Development | Marcus Osei | 2024-02-05 | 2024-03-15 | In Progress | High |
| 6 | Frontend Build | Priya Lam | 2024-02-12 | 2024-03-29 | In Progress | High |
| 7 | QA Test Planning | Sarah Kim | 2024-02-19 | 2024-03-08 | Complete | Medium |
| 8 | Integration Testing | Raj Nguyen | 2024-03-11 | 2024-04-05 | Not Started | High |
| 9 | Performance Tuning | David Patel | 2024-03-25 | 2024-04-12 | Not Started | Medium |
| 10 | User Acceptance Testing | Marcus Osei | 2024-04-08 | 2024-04-26 | Not Started | High |
| 11 | Deployment & Handoff | Priya Lam | 2024-04-22 | 2024-05-03 | Not Started | Critical |
Expected result
Pass criteria
All must be met, checked by an LLM judge.- A new cover sheet with a title and date labels
- Working formulas pull the earliest start and latest end from Tasks
- A visibly formatted, readable project overview
- Correct dates and metrics: no raw date serials, zero dates or ####
- The Tasks sheet is untouched
Passed 19
Autosheet in Excel Opus 5.5 · Medium
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
Autosheet in Excel GPT-6.1 Sol · 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 + Drive MCP GPT-6 · Medium
Gemini in Sheets Auto
ChatGPT in Sheets GPT-6 Astra · Medium
ChatGPT in Sheets GPT-6 Luna · High
Failed 3
Autosheet in Excel GPT-6 Astra · Low
Why it failed: While the dates display correctly as 'Jan 8, 2024' and 'May 3, 2024', the optional summary metrics are not source-consistent: 'Total tasks' displays 11 instead of 10, resulting in an…
Autosheet in Excel GPT-6 Luna · High
Why it failed: The dates are displayed as raw Excel serial numbers (45299 and 45415) rather than human-readable formatted dates, which is an explicit failure condition.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: The earliest start date displays as '##########' overflow rather than the readable date '8 January 2024', which is an explicit failure condition.