All AutosheetBench tasks

Track what's left of a budget

FormulasEasyDeterministic scoringLatest run

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

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in D4:D18 to calculate Remaining as Budgeted minus Spent.

Use formulas in E4:E18 for Status: Over when spending exceeds budget, On Track when it is within 10% of budget, and Under otherwise.

Add a summary in G1:H3 for total budgeted, total spent, and overall remaining, with the values calculated by formulas in H1:H3.

Starting spreadsheet

Sheet1
ABCDE
1Monthly Budget Tracker — Enter your budgeted and actual spending in the columns below. Remaining and Status will be calculated automaticall…
2
3CategoryBudgetedSpentRemainingStatus
4Rent18001800
5Groceries400387
6Dining Out150214
7Utilities120108
8Transportation200195
9Phone8080
10Internet6060
11Streaming Services4052
12Gym Membership5050
13Clothing100143
14Healthcare7529
15Personal Care6068
16Entertainment8035
17Savings500500
18Pet Expenses90112

A passing output

Autosheet in Excel · Opus 5.5
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3,805
2Total Spent3,833
3CategoryBudgetedSpentRemainingStatusOverall Remaining(28)
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

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.
  • H1:H3 and D4:E18 hold the expected values
  • D4:E18 and H1:H3 use formulas

Passed 21

Autosheet in Excel Opus 5.5 · Medium

Passed25s · 9¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3,805
2Total Spent3,833
3CategoryBudgetedSpentRemainingStatusOverall Remaining(28)
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Autosheet in Excel GPT-6 Astra · Low

Passed24s · 20¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted$3,805.00
2Total Spent$3,833.00
3CategoryBudgetedSpentRemainingStatusOverall Remaining-$28.00
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Autosheet in Excel Sonnet 5.5 · Medium

Passed16s · 4¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3,805
2Total Spent3,833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Claude in Excel Opus 5.5 · High

Passed46s · 26¢
Sheet138 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On TrackOn Track band (% of budget)10%
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Autosheet in Excel Haiku 5.5 · High

Passed22s · 0.4¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Claude in Sheets Opus 5.5 · Medium

Passed1m 22s · 21¢
Sheet138 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3,805
2On Track band (within % of budget)10%Total Spent3,833
3CategoryBudgetedSpentRemainingStatusOverall Remaining(28)
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed1m 13s · N/A
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Autosheet in Excel GPT-6.1 Sol · Medium

Passed41s · 10¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted$3,805.00
2Total Spent$3,833.00
3CategoryBudgetedSpentRemainingStatusOverall Remaining-$28.00
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed1m 32s · N/A
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed1m 11s · N/A
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Autosheet in Sheets Haiku 5.5 · High

Passed39s · 0.4¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

ChatGPT in Excel GPT-6 Astra · Medium

Passed30s · $1.08
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Claude in Excel Haiku 5.5 · High

Passed49s · 1¢
Sheet138 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On TrackOn Track threshold10%
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Claude in Sheets Haiku 5.5 · High

Passed1m 19s · 2¢
Sheet138 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64OverOn Track Threshold
7Utilities12010812On Track10%
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Autosheet in Excel GPT-6 Luna · High

Passed29s · 0.6¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total budgeted3805
2Total spent3833
3CategoryBudgetedSpentRemainingStatusOverall remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Copilot in Excel Auto

Passed48s · N/A
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3,805.00
2Total Spent3,833.00
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28.00
4Rent180018000.00On Track
5Groceries40038713.00On Track
6Dining Out150214-64.00Over
7Utilities12010812.00On Track
8Transportation2001955.00On Track
9Phone80800.00On Track
10Internet60600.00On Track
11Streaming Services4052-12.00Over
12Gym Membership50500.00On Track
13Clothing100143-43.00Over
14Healthcare752946.00Under
15Personal Care6068-8.00Over
16Entertainment803545.00Under
17Savings5005000.00On Track
18Pet Expenses90112-22.00Over

ChatGPT + Drive MCP GPT-6 · Medium

Passed1m 4s · N/A
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

ChatGPT in Excel GPT-6 Luna · High

Passed52s · 1¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Gemini in Sheets Auto

Passed3m 1s · N/A
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 3s · 100¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

ChatGPT in Sheets GPT-6 Luna · High

Passed1m 5s · 1¢
Sheet136 cells changed

H1=SUM(B4:B18)

ABCDEFGH
1Monthly Budget Tracker …Total Budgeted3805
2Total Spent3833
3CategoryBudgetedSpentRemainingStatusOverall Remaining-28
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Failed 1

Autosheet in Sheets Opus 5.5 · Medium

Failed5m · 6¢
Sheet130 cells changedWrong or missing value

D4=B4-C4

ABCDEFGH
1Monthly Budget Tracker …
2
3CategoryBudgetedSpentRemainingStatus
4Rent180018000On Track
5Groceries40038713On Track
6Dining Out150214-64Over
7Utilities12010812On Track
8Transportation2001955On Track
9Phone80800On Track
10Internet60600On Track
11Streaming Services4052-12Over
12Gym Membership50500On Track
13Clothing100143-43Over
14Healthcare752946Under
15Personal Care6068-8Over
16Entertainment803545Under
17Savings5005000On Track
18Pet Expenses90112-22Over

Why it failed: Still working at the 5-minute time limit. 3 cells are wrong, such as H1: empty instead of 3,805. H1:H3 hold no formula.