Add seniority columns in the table's format
FormattingMediumLLM judge scoringLatest run
Passed by 9 of 12 products on their best model. Failed: ChatGPT in Excel, ChatGPT + Autosheet MCP and ChatGPT in Sheets.
Prompt
Calculate employee seniority and year of beginning
Starting spreadsheet
Generate and autofill formulas| A | |
|---|---|
| 1 | Employee start date |
| 2 | 2007-03-15 |
| 3 | 2012-08-22 |
| 4 | 2020-01-10 |
| 5 | 2003-11-05 |
| 6 | 2017-06-18 |
| 7 | 2001-09-27 |
| 8 | 2023-04-02 |
| 9 | 2010-12-14 |
| 10 | 2015-07-30 |
| 11 | 2005-02-19 |
A passing output
Autosheet in Excel · Opus 5.5Pass criteria
All must be met, checked by an LLM judge.- Columns B and C hold seniority and start year
- They're formatted like column A
Passed 12
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
Claude in Sheets Opus 5.5 · Medium
Claude Code + Sheets MCP Opus 5.5 · Medium
Claude Code + Autosheet MCP Opus 5.5 · 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
Failed 10
Autosheet in Excel GPT-6 Astra · Low
Why it failed: Columns B and C headers do not match column A: cells B1 and C1 have black font on a light blue background rather than white font on a dark blue background.
Autosheet in Excel Haiku 5.5 · High
Why it failed: Columns B and C were not formatted to match column A; specifically, B1 and C1 headers have default black text on white fill instead of white text on dark blue background.
Autosheet in Excel GPT-6.1 Sol · Medium
Why it failed: Columns B and C were not formatted like column A; headers B1 and C1 have black text on a light background instead of white font on a dark blue background.
ChatGPT + Autosheet MCP GPT-6 · Medium
Why it failed: Headers B1 and C1 have a white background with black text instead of matching column A's dark blue background with white font.
Autosheet in Sheets Haiku 5.5 · High
Why it failed: Columns B and C were not formatted like column A; headers B1 and C1 have default black text instead of white text on a dark blue background.
ChatGPT in Excel GPT-6 Astra · Medium
Why it failed: Headers B1 and C1 were not formatted like A1; they have black font on a white background rather than white font on a dark blue background.
Autosheet in Excel GPT-6 Luna · High
Why it failed: Columns B and C were not formatted to match column A; headers B1 and C1 remain plain black text on a white background rather than white font on a dark blue background.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: Headers B1 and C1 do not have the dark blue background or white font seen in A1.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: Columns B and C were not formatted like column A; specifically, the headers B1 and C1 lack the dark blue background and white font present in A1.
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: Headers B1 and C1 were not formatted like A1; they have black font without the dark blue header background fill.