All AutosheetBench tasks

Model team capacity and hiring needs

FormulasEasyDeterministic scoringLatest run

Passed by 11 of 12 products on their best model. Failed: Gemini in Sheets.

Prompt and starting spreadsheet

Task files

Prompt

Add formulas for available hours and projected headcount at 85% target utilization

Add a gap formula showing how many people we need to hire or can let go

Starting spreadsheet

Sheet1
ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers8824045
3Backend Engineers12914245
4QA Engineers5783845
5DevOps3884048
6Product Managers4854045
7Designers6733845
8Data Engineers7934250
9ML Engineers2954450

A passing output

Autosheet in Excel · Opus 5.5
Sheet141 cells changed

F2=B2*E2-B2*D2*C2/100

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapHiring ActionTarget Utilization85%
2Frontend Engineers882404597.680On target
3Backend Engineers1291424581.4131Hire 1
4QA Engineers578384576.850On target
5DevOps388404838.441Hire 1
6Product Managers485404544.040On target
7Designers6733845103.660On target
8Data Engineers793425076.681Hire 1
9ML Engineers295445016.431Hire 1
10Total47534.7514Hire 4

How each AI configuration did

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

Pass criteria

All must be met, checked automatically.
  • F2:F9 hold the expected values, in an accepted form
  • F2:H9 use formulas
  • Rows 2–9: projected headcount at 85% and its gap, in an accepted way

Passed 21

Autosheet in Excel Opus 5.5 · Medium

Passed43s · 14¢
Sheet141 cells changed

F2=B2*E2-B2*D2*C2/100

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapHiring ActionTarget Utilization85%
2Frontend Engineers882404597.680On target
3Backend Engineers1291424581.4131Hire 1
4QA Engineers578384576.850On target
5DevOps388404838.441Hire 1
6Product Managers485404544.040On target
7Designers6733845103.660On target
8Data Engineers793425076.681Hire 1
9ML Engineers295445016.431Hire 1
10Total47534.7514Hire 4

Autosheet in Excel GPT-6 Astra · Low

Passed24s · 18¢
Sheet124 cells changed

F2=B2*E2*(1-C2/100)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404564.880
3Backend Engineers1291424548.6131
4QA Engineers578384549.550
5DevOps388404817.341
6Product Managers485404527.040
7Designers673384572.960
8Data Engineers793425024.581
9ML Engineers29544505.031

Autosheet in Sheets Opus 5.5 · Medium

Passed39s · 11¢
Sheet135 cells changed

F2=B2*(E2-D2)

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapHiring ActionTarget Utilization85%
2Frontend Engineers88240454080On target
3Backend Engineers1291424536131Hire 1
4QA Engineers57838453550On target
5DevOps38840482441Hire 1
6Product Managers48540452040On target
7Designers67338454260On target
8Data Engineers79342505681Hire 1
9ML Engineers29544501231Hire 1

Autosheet in Excel Sonnet 5.5 · Medium

Passed15s · 4¢
Sheet126 cells changed

F2=B2*D2*(1-C2/100)

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapTarget Utilization %85
2Frontend Engineers882404557.67.8-0.2
3Backend Engineers1291424545.3612.90.9
4QA Engineers578384541.84.6-0.4
5DevOps388404814.43.20.2
6Product Managers48540452440
7Designers673384561.565.2-0.8
8Data Engineers793425020.587.70.7
9ML Engineers29544504.42.30.3

Claude in Excel Opus 5.5 · High

Passed43s · 34¢
Sheet141 cells changed

F2=B2*E2*$B$12

ABCDEFGHI
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapHiring Action
2Frontend Engineers8824045306.07-1Let go 1
3Backend Engineers12914245459.0120No change
4QA Engineers5783845191.34-1Let go 1
5DevOps3884048122.430No change
6Product Managers4854045153.040No change
7Designers6733845229.55-1Let go 1
8Data Engineers7934250297.570No change
9ML Engineers295445085.020No change
10
11
12Target Utilisation85%
13Total to Hire0
14Total to Let Go3
15Net Headcount Change-3

Autosheet in Excel Haiku 5.5 · High

Passed32s · 0.6¢
Sheet126 cells changed

F2=B2*E2*$K$1-B2*D2*C2/100

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapTarget Utilization85%
2Frontend Engineers882404543.67-1
3Backend Engineers129142450.36120
4QA Engineers578384543.054-1
5DevOps388404816.830
6Product Managers48540451740
7Designers673384563.065-1
8Data Engineers793425024.0870
9ML Engineers29544501.420

Claude in Sheets Opus 5.5 · Medium

Passed1m 9s · 19¢
Sheet135 cells changed

F2=B2*(E2-D2)

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapHire / ReduceTarget Utilization85%
2Frontend Engineers88240454080No change
3Backend Engineers129142453613+1Hire 1
4QA Engineers57838453550No change
5DevOps3884048244+1Hire 1
6Product Managers48540452040No change
7Designers67338454260No change
8Data Engineers7934250568+1Hire 1
9ML Engineers2954450123+1Hire 1

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed1m 14s · N/A
Sheet126 cells changed

F2=B2*E2*(1-C2/100)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404564.88-
3Backend Engineers1291424548.613+1
4QA Engineers578384549.55-
5DevOps388404817.34+1
6Product Managers485404527.04-
7Designers673384572.96-
8Data Engineers793425024.58+1
9ML Engineers29544505.03+1
10
11Target Utilization %85

Autosheet in Excel GPT-6.1 Sol · Medium

Passed40s · 9¢
Sheet124 cells changed

F2=B2*(E2-D2*C2/100)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404597.607-1
3Backend Engineers1291424581.36120
4QA Engineers578384576.804-1
5DevOps388404838.4030
6Product Managers485404544.0040
7Designers6733845103.565-1
8Data Engineers793425076.5870
9ML Engineers295445016.4020

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed1m 42s · N/A
Sheet126 cells changed

F2=B2*E2*(1-C2/100)

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapTarget Utilization85%
2Frontend Engineers882404564.87.7-0.3
3Backend Engineers1291424548.612.80.8
4QA Engineers578384549.54.6-0.4
5DevOps388404817.33.10.1
6Product Managers485404527.04.00.0
7Designers673384572.95.2-0.8
8Data Engineers793425024.57.70.7
9ML Engineers29544505.02.20.2

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed1m 40s · N/A
Sheet127 cells changed

F2=B2*D2*(1-C2/100)

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountHeadcount Gap (+ Hire / - Release)Target Utilization85%
2Frontend Engineers882404557.680
3Backend Engineers1291424545.413+1
4QA Engineers578384541.850
5DevOps388404814.44+1
6Product Managers485404524.040
7Designers673384561.660
8Data Engineers793425020.68+1
9ML Engineers29544504.43+1

Autosheet in Sheets Haiku 5.5 · High

Passed47s · 0.5¢
Sheet124 cells changed

F2=B2*E2*0.85-B2*D2*C2/100

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404543.67-1
3Backend Engineers129142450.36120
4QA Engineers578384543.054-1
5DevOps388404816.830
6Product Managers48540451740
7Designers673384563.065-1
8Data Engineers793425024.0870
9ML Engineers29544501.420

ChatGPT in Excel GPT-6 Astra · Medium

Passed51s · 93¢
Sheet126 cells changed

F2=B2*(E2-D2)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers88240454080
3Backend Engineers1291424536131
4QA Engineers57838453550
5DevOps38840482441
6Product Managers48540452040
7Designers67338454260
8Data Engineers79342505681
9ML Engineers29544501231
10
11Target Utilization85%

Claude in Excel Haiku 5.5 · High

Passed28s · 1¢
Sheet126 cells changed

F2=B2*D2*$B$12

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers88240452727.70
3Backend Engineers1291424542812.8+1
4QA Engineers57838451624.60
5DevOps38840481023.10
6Product Managers48540451364.00
7Designers67338451945.2-1
8Data Engineers79342502507.7+1
9ML Engineers2954450752.20
10
11
12Target utilization85%

Claude in Sheets Haiku 5.5 · High

Passed1m 19s · 2¢
Sheet126 cells changed

F2=B2*E2*$K$1/100

ABCDEFGHIJK
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGapTarget Utilization %85%
2Frontend Engineers88240453068No change
3Backend Engineers1291424545913+1 to hire
4QA Engineers57838451915No change
5DevOps38840481224+1 to hire
6Product Managers48540451534No change
7Designers67338452306No change
8Data Engineers79342502988+1 to hire
9ML Engineers2954450853+1 to hire

Autosheet in Excel GPT-6 Luna · High

Passed32s · 0.8¢
Sheet124 cells changed

F2=B2*E2-(B2*D2*C2/100)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404597.67-1
3Backend Engineers1291424581.36120
4QA Engineers578384576.84-1
5DevOps388404838.430
6Product Managers48540454440
7Designers6733845103.565-1
8Data Engineers793425076.5870
9ML Engineers295445016.420

Copilot in Excel Auto

Passed32s · N/A
Sheet124 cells changed

F2=B2*(E2-D2)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers88240454080
3Backend Engineers129142453613+1
4QA Engineers57838453550
5DevOps3884048244+1
6Product Managers48540452040
7Designers67338454260
8Data Engineers7934250568+1
9ML Engineers2954450123+1

ChatGPT + Drive MCP GPT-6 · Medium

Passed57s · N/A
Sheet124 cells changed

F2=B2*E2-B2*D2*C2/100

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404597.67-1
3Backend Engineers1291424581.36120
4QA Engineers578384576.84-1
5DevOps388404838.430
6Product Managers48540454440
7Designers6733845103.565-1
8Data Engineers793425076.5870
9ML Engineers295445016.420

ChatGPT in Excel GPT-6 Luna · High

Passed1m 33s · 1¢
Sheet124 cells changed

F2=B2*E2*(1-C2/100)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404564.87.7176470590
3Backend Engineers1291424548.612.847058821
4QA Engineers578384549.54.5882352940
5DevOps388404817.283.1058823531
6Product Managers48540452740
7Designers673384572.95.1529411760
8Data Engineers793425024.57.6588235291
9ML Engineers295445052.2352941181

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 4s · 77¢
Sheet126 cells changed

F2=B2*(E2-D2)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404540.07.72-0.28
3Backend Engineers1291424536.012.85+0.85
4QA Engineers578384535.04.59-0.41
5DevOps388404824.03.11+0.11
6Product Managers485404520.04.000.00
7Designers673384542.05.15-0.85
8Data Engineers793425056.07.66+0.66
9ML Engineers295445012.02.24+0.24
10
11Target Utilization85%

ChatGPT in Sheets GPT-6 Luna · High

Passed1m 1s · 0.9¢
Sheet124 cells changed

F2=B2*E2*(1-C2/100)

ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers882404564.87.717647059-0.282352941
3Backend Engineers1291424548.612.847058820.847058823
4QA Engineers578384549.54.588235294-0.411764706
5DevOps388404817.283.1058823530.105882353
6Product Managers48540452740
7Designers673384572.95.152941176-0.847058823
8Data Engineers793425024.57.6588235290.658823529
9ML Engineers295445052.2352941180.235294118

Failed 1

Gemini in Sheets Auto

Failed5m · N/A
Sheet1No cell changedWrong or missing value
ABCDEFGH
1ResourceCurrent HeadcountUtilization %Avg Hours/WeekMax Capacity HoursAvailable HoursProjected HeadcountGap
2Frontend Engineers8824045
3Backend Engineers12914245
4QA Engineers5783845
5DevOps3884048
6Product Managers4854045
7Designers6733845
8Data Engineers7934250
9ML Engineers2954450

Why it failed: Still working at the 5-minute time limit. F2:H9 hold no formula. Not met: row 2: projected headcount at 85% and its gap.