All AutosheetBench tasks

Sort months in calendar order with a formula

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

On the Report sheet, put the headers in row 1 and use a formula starting in A2 to sort the months from Jan to Dec rather than alphabetically.

Data

Starting sheet
AB
1MonthRevenue
2Apr9100
3Jan7600
4Mar8400
5Feb7800
6Jun9800
7May9500
8Aug10200
9Jul9950
10Oct11000
11Sep10750
12Dec12100
13Nov11850

Report

Starting sheet
A
1

Expected result

How each AI configuration did

22 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • Report!A1:B13 hold the expected values
  • Report!A2 uses a formula

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed17s · 5¢
Report26 cells changed

A1=Data!A1

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Autosheet in Excel GPT-6 Astra · Low

Passed11s · 8¢
Report26 cells changed

A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)

AB
1MonthRevenue
2Jan7,600
3Feb7,800
4Mar8,400
5Apr9,100
6May9,500
7Jun9,800
8Jul9,950
9Aug10,200
10Sep10,750
11Oct11,000
12Nov11,850
13Dec12,100

Autosheet in Sheets Opus 5.5 · Medium

Passed19s · 4¢
Report26 cells changed

A2=SORT(Data!A2:B13, MATCH(Data!A2:A13, {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, 0), TRUE)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Autosheet in Excel Sonnet 5.5 · Medium

Passed6s · 2¢
Report26 cells changed

A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Claude in Excel Opus 5.5 · High

Passed14s · 9¢
Report26 cells changed

A1=Data!A1

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Autosheet in Excel Haiku 5.5 · High

Passed14s · 0.2¢
Report26 cells changed

A2=INDEX(Data!$A$2:$A$13,MATCH(TEXT(DATE(2026,ROWS($A$2:A2),1),"mmm"),Data!$A$2:$A$13,0))

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Claude in Sheets Opus 5.5 · Medium

Passed23s · 6¢
Report26 cells changed

A1=Data!A1

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed30s · N/A
Report26 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), MATCH(FILTER(Data!A2:A1000, Data!A2:A1000<>""""), {""Jan"";""Feb"";""Mar"";""Apr"";""May"";""Jun"";""Jul"";""Aug"";""Sep"";""Oct"";""Nov"";""Dec""}, 0), TRUE)"),"Jan")

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Autosheet in Excel GPT-6.1 Sol · Medium

Passed13s · 2¢
Report26 cells changed

A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)

AB
1MonthRevenue
2Jan7,600
3Feb7,800
4Mar8,400
5Apr9,100
6May9,500
7Jun9,800
8Jul9,950
9Aug10,200
10Sep10,750
11Oct11,000
12Nov11,850
13Dec12,100

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed35s · N/A
Report26 cells changed

A2=SORT(Data!A2:B13, MATCH(Data!A2:A13, {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, 0), TRUE)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed32s · N/A
Report26 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), MATCH(FILTER(Data!A2:A1000, Data!A2:A1000<>""""), {""Jan"",""Feb"",""Mar"",""Apr"",""May"",""Jun"",""Jul"",""Aug"",""Sep"",""Oct"",""Nov"",""Dec""}, 0), TRUE)"),"Jan")

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Autosheet in Sheets Haiku 5.5 · High

Passed41s · 0.4¢
Report26 cells changed

A2=CHOOSECOLS(SORT({Data!A2:B13, MATCH(Data!A2:A13, {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, 0)}, 3, TRUE), 1, 2)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

ChatGPT in Excel GPT-6 Astra · Medium

Passed18s · 43¢
Report26 cells changed

A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Claude in Excel Haiku 5.5 · High

Passed10s · 0.4¢
Report26 cells changed

A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Claude in Sheets Haiku 5.5 · High

Passed23s · 0.4¢
Report26 cells changed

A1=Data!A1

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Autosheet in Excel GPT-6 Luna · High

Passed12s · 0.2¢
Report26 cells changed

A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Copilot in Excel Auto

Passed21s · N/A
Report26 cells changed

A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)

AB
1MonthRevenue
2Jan7,600
3Feb7,800
4Mar8,400
5Apr9,100
6May9,500
7Jun9,800
8Jul9,950
9Aug10,200
10Sep10,750
11Oct11,000
12Nov11,850
13Dec12,100

ChatGPT + Drive MCP GPT-6 · Medium

Passed28s · N/A
Report26 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(FILTER(Data!A2:B1000,Data!A2:A1000<>""""),ARRAYFORMULA(MATCH(FILTER(Data!A2:A1000,Data!A2:A1000<>""""),{""Jan"";""Feb"";""Mar"";""Apr"";""May"";""Jun"";""Jul"";""Aug"";""Sep"";""Oct"";""Nov"";""Dec""},0)),TRUE)"),"Jan")

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

ChatGPT in Excel GPT-6 Luna · High

Passed24s · 0.5¢
Report26 cells changed

A2=SORTBY(Data!A2:B13,MONTH(DATEVALUE("1 "&Data!A2:A13)),1)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

Gemini in Sheets Auto

Passed2m 17s · N/A
Report26 cells changed

A2=SORT(Data!A2:B13, MONTH(Data!A2:A13&1), 1)

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

ChatGPT in Sheets GPT-6 Astra · Medium

Passed49s · 44¢
Report26 cells changed

A2=INDEX(Data!A$2:A$13,MATCH(CHOOSE(ROWS($A$2:$A2),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),Data!$A$2:$A$13,0))

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100

ChatGPT in Sheets GPT-6 Luna · High

Passed45s · 0.5¢
Report26 cells changed

A2=INDEX(Data!$A$2:$A$13,MATCH(CHOOSE(ROWS($A$2:A2),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),Data!$A$2:$A$13,0))

AB
1MonthRevenue
2Jan7600
3Feb7800
4Mar8400
5Apr9100
6May9500
7Jun9800
8Jul9950
9Aug10200
10Sep10750
11Oct11000
12Nov11850
13Dec12100