All AutosheetBench tasks

Fix numbers stored as text

Data operationsEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

The Total cell currently shows an error when it sums the amounts, can you fix ?

Starting spreadsheet

Import
AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total#DIV/0!

A passing output

Autosheet in Excel · Opus 5.5
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

How each AI configuration did

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

Pass criteria

All must be met, checked automatically.
  • B2:B7 hold the expected values
  • B7 uses a formula

Passed 18

Autosheet in Excel Opus 5.5 · Medium

Passed13s · 4¢
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

Autosheet in Sheets Opus 5.5 · Medium

Passed17s · 4¢
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

Autosheet in Excel Sonnet 5.5 · Medium

Passed6s · 1¢
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6590.5

Claude in Excel Opus 5.5 · High

Passed11s · 7¢
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

Claude in Sheets Opus 5.5 · Medium

Passed29s · 6¢
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed33s · N/A
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

Autosheet in Excel GPT-6.1 Sol · Medium

Passed42s · 5¢
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed41s · N/A
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed34s · N/A
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Autosheet in Sheets Haiku 5.5 · High

Passed43s · 0.5¢
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

ChatGPT in Excel GPT-6 Astra · Medium

Passed19s · 39¢
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Claude in Excel Haiku 5.5 · High

Passed10s · 0.4¢
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

Claude in Sheets Haiku 5.5 · High

Passed25s · 0.8¢
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

Copilot in Excel Auto

Passed25s · N/A
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

ChatGPT + Drive MCP GPT-6 · Medium

Passed30s · N/A
Import1 cell changed

B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))

AB
1ProductAmount
2Atlas1,250.00
3Beacon980.50
4Comet2,100.00
5Delta760.00
6Echo1,500.00
7Total6,590.50

ChatGPT in Excel GPT-6 Luna · High

Passed37s · 0.5¢
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Gemini in Sheets Auto

Passed3m 5s · N/A
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

ChatGPT in Sheets GPT-6 Astra · Medium

Passed24s · 31¢
Import1 cell changed

B7=SUM(B2:B6)

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Failed 4

Autosheet in Excel GPT-6 Astra · Low

Failed11s · 8¢
Import1 cell changedWrong value

B7=SUMPRODUCT(--B2:B6)

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Why it failed: 5 cells are wrong, such as B2: "1250" instead of 1,250.

Autosheet in Excel Haiku 5.5 · High

Failed13s · 0.2¢
Import1 cell changedWrong value

B7=SUMPRODUCT(VALUE(B2:B6))

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Why it failed: 5 cells are wrong, such as B2: "1250" instead of 1,250.

Autosheet in Excel GPT-6 Luna · High

Failed14s · 0.3¢
Import1 cell changedWrong value

B7=SUMPRODUCT(NUMBERVALUE(B2:B6,".",","))

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Why it failed: 5 cells are wrong, such as B2: "1250" instead of 1,250.

ChatGPT in Sheets GPT-6 Luna · High

Failed41s · 0.4¢
Import1 cell changedWrong value

B7=SUMPRODUCT(--B2:B6)

AB
1ProductAmount
2Atlas1250
3Beacon980.5
4Comet2100
5Delta760
6Echo1500
7Total6590.5

Why it failed: 5 cells are wrong, such as B2: "1250" instead of 1,250.