All AutosheetBench tasks

Turn scores into letter grades

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in E2:E6 to assign A for scores of 90 or more, B for 80–89, C for 70–79, and D below 70.

Starting spreadsheet

Orders
ABCDE
1OrderAmountScoreFlagGrade
2O-165094
3O-2125086
4O-3100073
5O-4220064
6O-547551

A passing output

Autosheet in Excel · Opus 5.5
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

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

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed11s · 3¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Autosheet in Excel GPT-6 Astra · Low

Passed6s · 5¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Autosheet in Sheets Opus 5.5 · Medium

Passed10s · 2¢
Orders5 cells changed

E2=IF(C2="", "", IFS(C2>=90, "A", C2>=80, "B", C2>=70, "C", TRUE, "D"))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Autosheet in Excel Sonnet 5.5 · Medium

Passed5s · 1¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Claude in Excel Opus 5.5 · High

Passed11s · 8¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Autosheet in Excel Haiku 5.5 · High

Passed6s · 0.1¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Claude in Sheets Opus 5.5 · Medium

Passed42s · 8¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed19s · N/A
Orders5 cells changed

E2=IFS(C2>=90,"A",C2>=80,"B",C2>=70,"C",TRUE,"D")

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Autosheet in Excel GPT-6.1 Sol · Medium

Passed8s · 1¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed29s · N/A
Orders5 cells changed

E2=IFS(C2>=90, "A", C2>=80, "B", C2>=70, "C", TRUE, "D")

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed37s · N/A
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Autosheet in Sheets Haiku 5.5 · High

Passed13s · 0.1¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

ChatGPT in Excel GPT-6 Astra · Medium

Passed15s · 40¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Claude in Excel Haiku 5.5 · High

Passed9s · 0.4¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Claude in Sheets Haiku 5.5 · High

Passed14s · 0.3¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Autosheet in Excel GPT-6 Luna · High

Passed8s · 0.1¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Copilot in Excel Auto

Passed17s · N/A
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

ChatGPT + Drive MCP GPT-6 · Medium

Passed21s · N/A
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

ChatGPT in Excel GPT-6 Luna · High

Passed17s · 0.4¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

Gemini in Sheets Auto

Passed38s · N/A
Orders5 cells changed

E2=IFS(C2>=90, "A", C2>=80, "B", C2>=70, "C", TRUE, "D")

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

ChatGPT in Sheets GPT-6 Astra · Medium

Passed25s · 32¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D

ChatGPT in Sheets GPT-6 Luna · High

Passed20s · 0.3¢
Orders5 cells changed

E2=IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C","D")))

ABCDE
1OrderAmountScoreFlagGrade
2O-165094A
3O-2125086B
4O-3100073C
5O-4220064D
6O-547551D