All AutosheetBench tasks

Compute each row's share of the total

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in H2:H8 to calculate each row's Revenue as a share of total Revenue.

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
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

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.
  • H2:H8 hold the expected values, from formulas

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed13s · 3¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Autosheet in Excel GPT-6 Astra · Low

Passed11s · 7¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.22%
3O-1002North America2026-01-17Q145082508.15%
4O-1003Europe2026-02-09Q19801890018.67%
5O-1004Asia2026-02-17Q16101120011.06%
6O-1005Europe2026-03-03Q15401650016.30%
7O-1006Europe2026-04-12Q212502480024.49%
8O-1007North America2026-05-06Q232072007.11%

Autosheet in Sheets Opus 5.5 · Medium

Passed11s · 3¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Autosheet in Excel Sonnet 5.5 · Medium

Passed9s · 2¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Claude in Excel Opus 5.5 · High

Passed9s · 6¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Autosheet in Excel Haiku 5.5 · High

Passed8s · 0.1¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.22%
3O-1002North America2026-01-17Q145082508.15%
4O-1003Europe2026-02-09Q19801890018.67%
5O-1004Asia2026-02-17Q16101120011.06%
6O-1005Europe2026-03-03Q15401650016.30%
7O-1006Europe2026-04-12Q212502480024.49%
8O-1007North America2026-05-06Q232072007.11%

Claude in Sheets Opus 5.5 · Medium

Passed30s · 7¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed27s · N/A
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Autosheet in Excel GPT-6.1 Sol · Medium

Passed16s · 2¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.22%
3O-1002North America2026-01-17Q145082508.15%
4O-1003Europe2026-02-09Q19801890018.67%
5O-1004Asia2026-02-17Q16101120011.06%
6O-1005Europe2026-03-03Q15401650016.30%
7O-1006Europe2026-04-12Q212502480024.49%
8O-1007North America2026-05-06Q232072007.11%

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed49s · N/A
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.22%
3O-1002North America2026-01-17Q145082508.15%
4O-1003Europe2026-02-09Q19801890018.67%
5O-1004Asia2026-02-17Q16101120011.06%
6O-1005Europe2026-03-03Q15401650016.30%
7O-1006Europe2026-04-12Q212502480024.49%
8O-1007North America2026-05-06Q232072007.11%

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed48s · N/A
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.22%
3O-1002North America2026-01-17Q145082508.15%
4O-1003Europe2026-02-09Q19801890018.67%
5O-1004Asia2026-02-17Q16101120011.06%
6O-1005Europe2026-03-03Q15401650016.30%
7O-1006Europe2026-04-12Q212502480024.49%
8O-1007North America2026-05-06Q232072007.11%

Autosheet in Sheets Haiku 5.5 · High

Passed17s · 0.1¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.22%
3O-1002North America2026-01-17Q145082508.15%
4O-1003Europe2026-02-09Q19801890018.67%
5O-1004Asia2026-02-17Q16101120011.06%
6O-1005Europe2026-03-03Q15401650016.30%
7O-1006Europe2026-04-12Q212502480024.49%
8O-1007North America2026-05-06Q232072007.11%

ChatGPT in Excel GPT-6 Astra · Medium

Passed19s · 41¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Claude in Excel Haiku 5.5 · High

Passed7s · 0.3¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Claude in Sheets Haiku 5.5 · High

Passed23s · 0.4¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

Autosheet in Excel GPT-6 Luna · High

Passed9s · 0.1¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144000.142222222
3O-1002North America2026-01-17Q145082500.081481481
4O-1003Europe2026-02-09Q1980189000.186666667
5O-1004Asia2026-02-17Q1610112000.110617284
6O-1005Europe2026-03-03Q1540165000.162962963
7O-1006Europe2026-04-12Q21250248000.244938272
8O-1007North America2026-05-06Q232072000.071111111

Copilot in Excel Auto

Passed17s · N/A
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.22%
3O-1002North America2026-01-17Q145082508.15%
4O-1003Europe2026-02-09Q19801890018.67%
5O-1004Asia2026-02-17Q16101120011.06%
6O-1005Europe2026-03-03Q15401650016.30%
7O-1006Europe2026-04-12Q212502480024.49%
8O-1007North America2026-05-06Q232072007.11%

ChatGPT + Drive MCP GPT-6 · Medium

Passed32s · N/A
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.22%
3O-1002North America2026-01-17Q145082508.15%
4O-1003Europe2026-02-09Q19801890018.67%
5O-1004Asia2026-02-17Q16101120011.06%
6O-1005Europe2026-03-03Q15401650016.30%
7O-1006Europe2026-04-12Q212502480024.49%
8O-1007North America2026-05-06Q232072007.11%

ChatGPT in Excel GPT-6 Luna · High

Passed17s · 0.4¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144000.142222222
3O-1002North America2026-01-17Q145082500.081481481
4O-1003Europe2026-02-09Q1980189000.186666667
5O-1004Asia2026-02-17Q1610112000.110617284
6O-1005Europe2026-03-03Q1540165000.162962963
7O-1006Europe2026-04-12Q21250248000.244938272
8O-1007North America2026-05-06Q232072000.071111111

Gemini in Sheets Auto

Passed52s · N/A
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

ChatGPT in Sheets GPT-6 Astra · Medium

Passed22s · 33¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440014.2%
3O-1002North America2026-01-17Q145082508.1%
4O-1003Europe2026-02-09Q19801890018.7%
5O-1004Asia2026-02-17Q16101120011.1%
6O-1005Europe2026-03-03Q15401650016.3%
7O-1006Europe2026-04-12Q212502480024.5%
8O-1007North America2026-05-06Q232072007.1%

ChatGPT in Sheets GPT-6 Luna · High

Passed21s · 0.3¢
Orders7 cells changed

H2=F2/SUM($F$2:$F$8)

ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q1720144000.142222222
3O-1002North America2026-01-17Q145082500.081481481
4O-1003Europe2026-02-09Q1980189000.186666667
5O-1004Asia2026-02-17Q1610112000.110617284
6O-1005Europe2026-03-03Q1540165000.162962963
7O-1006Europe2026-04-12Q21250248000.244938272
8O-1007North America2026-05-06Q232072000.071111111