Normalize ticket priorities
Bulk data processingMediumWhole-set scoringLatest run
Passed by 9 of 12 products on their best model. Failed: Autosheet in Excel, Autosheet in Sheets and Claude Code + Autosheet MCP.
Prompt
Create a new
priority_cleanin column E. Priority should be one of Low, Medium, High, Urgent.
Starting spreadsheet
Sheet1 · rows 1–21 of 1,001| A | B | C | D | |
|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw |
| 2 | 18285 | high | Pending, | 2026-08-28 |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 |
| 4 | 18249 | p2 | In queue | 28.08.2026 |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 |
| 6 | 18263 | med | In progress | 2026-08-28 |
| 7 | 18284 | LOW | Closed | 08/28/2026 |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 |
| 11 | 18245 | MEDIUM | Referred upward. | 08/28/2026 |
| 12 | 18260 | p3 | In progress | 28.08.2026 |
| 13 | 18283 | Low priority | No further action required | Aug 28, 2026 |
| 14 | 18238 | high | Awaiting resolution, | 2026-08-28 |
| 15 | 18281 | LOW | In progress. | 08/28/2026 |
| 16 | 18280 | p2 | Closed | 28.08.2026 |
| 17 | 18282 | Low priority | Awaiting resolution | Aug 28, 2026 |
| 18 | 18203 | low | Yet to commence, | 2026-08-27 |
| 19 | 18204 | LOW | Closed. | 08/27/2026 |
| 20 | 18140 | p3 | Resolved | 27.08.2026 |
| 21 | 18138 | Low priority | In progress | Aug 27, 2026 |
A passing output
Claude in Excel · Opus 5.5E2=IF(OR(LOWER(TRIM(B2))={"p0","urgent","critical"}),"Urgent",IF(OR(LOWER(TRIM(B2))="p1",LEFT(LOWER(TRIM(B2)),4)="high"),"High",IF(OR(LOWER(TRIM(B2))="p2",LEFT(LOWER(TRIM(B2)),3)="med"),"Medium",IF(OR(LOWER(TRIM(B2))="p3",LEFT(LOWER(TRIM(B2)),3)="low"),"Low","Unmapped"))))
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
Pass criteria
Each must be met on at least 98% of rows.E2:E1001: filled with text, matching the expected answers
Passed 13
Claude in Excel Opus 5.5 · High
E2=IF(OR(LOWER(TRIM(B2))={"p0","urgent","critical"}),"Urgent",IF(OR(LOWER(TRIM(B2))="p1",LEFT(LOWER(TRIM(B2)),4)="high"),"High",IF(OR(LOWER(TRIM(B2))="p2",LEFT(LOWER(TRIM(B2)),3)="med"),"Medium",IF(OR(LOWER(TRIM(B2))="p3",LEFT(LOWER(TRIM(B2)),3)="low"),"Low","Unmapped"))))
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
Claude in Sheets Opus 5.5 · Medium
E2=IFERROR(__xludf.DUMMYFUNCTION("ARRAYFORMULA(IF(B2:B1001="""",,IFERROR(VLOOKUP(TRIM(REGEXREPLACE(LOWER(B2:B1001),""priority"","""")),{""p0"",""Urgent"";""urgent"",""Urgent"";""critical"",""Urgent"";""p1"",""High"";""high"",""High"";""p2"",""Medium"";""medium"",""Medium"";""med"",""Mediu"&"m"";""p3"",""Low"";""low"",""Low""},2,FALSE),""UNMAPPED"")))"),"High")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
Claude Code + Sheets MCP Opus 5.5 · Medium
E2=IFERROR(__xludf.DUMMYFUNCTION("ARRAYFORMULA(IF(B2:B1001="""","""",IFNA(VLOOKUP(LOWER(TRIM(REGEXREPLACE(B2:B1001,""(?i)\s*priority\s*$"",""""))),{""low"",""Low"";""p3"",""Low"";""med"",""Medium"";""medium"",""Medium"";""p2"",""Medium"";""high"",""High"";""p1"",""High"";""urgent"",""Urge"&"nt"";""critical"",""Urgent"";""p0"",""Urgent""},2,FALSE),""Unmapped"")))"),"High")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
ChatGPT + Autosheet MCP GPT-6 · Medium
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Astra · Medium
E2=SWITCH(LOWER(TRIM(B2)),"low","Low","low priority","Low","p3","Low","med","Medium","medium","Medium","medium priority","Medium","p2","Medium","high","High","high priority","High","p1","High","critical","Urgent","urgent","Urgent","p0","Urgent")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
Claude in Excel Haiku 5.5 · High
E2=IFERROR(INDEX($H$2:$H$14,MATCH(TRIM(B2),$G$2:$G$14,0)),"Unmapped")
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean | priority_raw | priority_clean | |
| 2 | 18285 | high | Pending, | 2026-08-28 | High | high | High | |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High | high priority | High | |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium | p1 | High | |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High | med | Medium | |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium | medium priority | Medium | |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low | p2 | Medium | |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium | low | Low | |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High | low priority | Low | |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium | p3 | Low |
10 of 1,001 rows
Claude in Sheets Haiku 5.5 · High
E2=IFERROR(XLOOKUP(TRIM(B2),$G$2:$G$14,$H$2:$H$14),"Unmapped")
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean | priority_raw (lookup key) | priority_clean | |
| 2 | 18285 | high | Pending, | 2026-08-28 | High | low | Low | |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High | low priority | Low | |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium | p3 | Low | |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High | med | Medium | |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium | medium | Medium | |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low | medium priority | Medium | |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium | p2 | Medium | |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High | high | High | |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium | high priority | High |
10 of 1,001 rows
Copilot in Excel Auto
E2=SWITCH(LOWER(TRIM(B2)),"low","Low","low priority","Low","p3","Low","medium","Medium","medium priority","Medium","med","Medium","p2","Medium","high","High","high priority","High","p1","High","urgent","Urgent","critical","Urgent","p0","Urgent","")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
ChatGPT + Drive MCP GPT-6 · Medium
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Luna · High
E2=IF(OR(LOWER(TRIM(B2))="urgent",LOWER(TRIM(B2))="critical",LOWER(TRIM(B2))="p0"),"Urgent",IF(OR(LOWER(TRIM(B2))="high",LOWER(TRIM(B2))="high priority",LOWER(TRIM(B2))="p1"),"High",IF(OR(LOWER(TRIM(B2))="medium",LOWER(TRIM(B2))="med",LOWER(TRIM(B2))="medium priority",LOWER(TRIM(B2))="p2"),"Medium",IF(OR(LOWER(TRIM(B2))="low",LOWER(TRIM(B2))="low priority",LOWER(TRIM(B2))="p3"),"Low",""))))
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
Gemini in Sheets Auto
E2=SWITCH(LOWER(TRIM(B2)),"p0","Urgent","urgent","Urgent","critical","Urgent","p1","High","high","High","high priority","High","p2","Medium","med","Medium","medium","Medium","medium priority","Medium","p3","Low","low","Low","low priority","Low","")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Astra · Medium
E2=LET(p,LOWER(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CLEAN(B2),CHAR(160)," "),".",""),",",""))),SWITCH(p,"low","Low","low priority","Low","p3","Low","p4","Low","medium","Medium","med","Medium","medium priority","Medium","p2","Medium","high","High","high priority","High","p1","High","urgent","Urgent","urgent priority","Urgent","critical","Urgent","p0","Urgent",""))
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Luna · High
E2=SWITCH(LOWER(TRIM(B2)),"urgent","Urgent","critical","Urgent","p0","Urgent","high","High","high priority","High","p1","High","medium","Medium","med","Medium","medium priority","Medium","p2","Medium","low","Low","low priority","Low","p3","Low","")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | Medium |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | Medium |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
10 of 1,001 rows
Failed 9
Autosheet in Excel Opus 5.5 · Medium
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 242 cells are wrong: it read each p-code one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.
Autosheet in Excel GPT-6 Astra · Low
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 242 cells are wrong: it read each p-code one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.
Autosheet in Sheets Opus 5.5 · Medium
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 242 cells are wrong: it read each p-code one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.
Autosheet in Excel Sonnet 5.5 · Medium
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 243 cells are wrong: it read each p-code one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.
Autosheet in Excel Haiku 5.5 · High
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 242 cells are wrong: it read each p-code one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.
Autosheet in Excel GPT-6.1 Sol · Medium
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 242 cells are wrong: it read each p-code one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.
Claude Code + Autosheet MCP Opus 5.5 · Medium
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 242 cells are wrong: it read each p-code one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.
Autosheet in Sheets Haiku 5.5 · High
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 242 cells are wrong: it read each p-code one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.
Autosheet in Excel GPT-6 Luna · High
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | id | priority_raw | status_raw | date_raw | priority_clean |
| 2 | 18285 | high | Pending, | 2026-08-28 | High |
| 3 | 18190 | HIGH | Awaiting action | 08/28/2026 | High |
| 4 | 18249 | p2 | In queue | 28.08.2026 | High |
| 5 | 18234 | High priority | Awaiting resolution. | Aug 28, 2026 | High |
| 6 | 18263 | med | In progress | 2026-08-28 | Medium |
| 7 | 18284 | LOW | Closed | 08/28/2026 | Low |
| 8 | 18247 | p2 | Successfully concluded. | 28.08.2026 | High |
| 9 | 18261 | High priority | In review. | Aug 28, 2026 | High |
| 10 | 18262 | med | Awaiting resolution | 2026-08-28 | Medium |
| 12 | 18260 | p3 | In progress | 28.08.2026 | Medium |
| 16 | 18280 | p2 | Closed | 28.08.2026 | High |
| 20 | 18140 | p3 | Resolved | 27.08.2026 | Medium |
| 24 | 18216 | p1 | Resolved | 27.08.2026 | Urgent |
| 28 | 18085 | p2 | In review | 27.08.2026 | High |
15 of 1,001 rows
Why it failed: 248 cells are wrong, 242 of them a p-code read one level too high. p0 is Urgent, p1 High, p2 Medium and p3 Low.