All AutosheetBench tasks

Count the orders above an amount

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Using a formula, put the number of orders with an Amount above $500 in J2.

Starting spreadsheet

Orders
ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q172014400
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

A passing output

Autosheet in Excel · Opus 5.5
Orders2 cells changed

J2=COUNTIF(E2:E8,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of TotalOrders > $500
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

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.
  • J2 is 5
  • J2 uses a formula

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed13s · 3¢
Orders2 cells changed

J2=COUNTIF(E2:E8,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of TotalOrders > $500
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel GPT-6 Astra · Low

Passed5s · 3¢
Orders1 cell changed

J2=COUNTIF(Orders!E2:E9,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Sheets Opus 5.5 · Medium

Passed10s · 2¢
Orders2 cells changed

J2=COUNTIF(E2:E8, ">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of TotalOrders > $500
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel Sonnet 5.5 · Medium

Passed3s · 0.8¢
Orders1 cell changed

J2=COUNTIF(E2:E9,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude in Excel Opus 5.5 · High

Passed10s · 6¢
Orders1 cell changed

J2=COUNTIF(E:E,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel Haiku 5.5 · High

Passed5s · 0.1¢
Orders1 cell changed

J2=COUNTIF(E:E,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude in Sheets Opus 5.5 · Medium

Passed18s · 6¢
Orders1 cell changed

J2=COUNTIF(E2:E1000,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed17s · N/A
Orders1 cell changed

J2=COUNTIF(E2:E1000, ">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel GPT-6.1 Sol · Medium

Passed5s · 0.9¢
Orders1 cell changed

J2=COUNTIF(E2:E9,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed29s · N/A
Orders2 cells changed

J2=COUNTIF(E2:E8, ">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of TotalOrders > $500
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed30s · N/A
Orders1 cell changed

J2=COUNTIF(E2:E8,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Sheets Haiku 5.5 · High

Passed13s · 0.1¢
Orders1 cell changed

J2=COUNTIF(E2:E1000,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT in Excel GPT-6 Astra · Medium

Passed2m 15s · 38¢
Orders1 cell changed

J2=COUNTIF(E2:E9,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude in Excel Haiku 5.5 · High

Passed5s · 0.3¢
Orders1 cell changed

J2=COUNTIF(E2:E8,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude in Sheets Haiku 5.5 · High

Passed22s · 0.2¢
Orders1 cell changed

J2=COUNTIF(E2:E1000,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel GPT-6 Luna · High

Passed5s · 0.1¢
Orders1 cell changed

J2=COUNTIF(Orders!E2:E9,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Copilot in Excel Auto

Passed15s · N/A
Orders1 cell changed

J2=COUNTIF(E2:E9,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT + Drive MCP GPT-6 · Medium

Passed24s · N/A
Orders1 cell changed

J2=COUNTIF(E2:E1000,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT in Excel GPT-6 Luna · High

Passed15s · 0.4¢
Orders1 cell changed

J2=COUNTIF(E:E,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Gemini in Sheets Auto

Passed33s · N/A
Orders1 cell changed

J2=COUNTIF(E2:E8, ">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT in Sheets GPT-6 Astra · Medium

Passed19s · 30¢
Orders1 cell changed

J2=COUNTIF(E2:E8,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT in Sheets GPT-6 Luna · High

Passed17s · 0.3¢
Orders1 cell changed

J2=COUNTIF(E2:E8,">500")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144005
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200