All AutosheetBench tasks

Compute budget variances and totals

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in D2:E13 to calculate variance and variance percentage for each line item.

Add a total row in row 14 using formulas to total Budget, Actual, and Variance.

Starting spreadsheet

Sheet1
ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries8500088200
3Rent2400024000
4Marketing1500011350
5Software Subscriptions84009120
6Office Supplies32002870
7Travel & Expenses1200014580
8Utilities48004650
9Insurance65006500
10Training & Development50003200
11Legal & Compliance75008900
12Equipment Maintenance42003750
13Miscellaneous25003140

A passing output

Autosheet in Excel · Opus 5.5
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent240002400000.0%
4Marketing1500011350-3,650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses12000145802,58021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1,800-36.0%
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total1781001802602,1601.2%

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.
  • D2:D14, E2:E13 and B14:C14 hold the expected values
  • D2:E13 and B14:D14 use formulas

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed23s · 7¢
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent240002400000.0%
4Marketing1500011350-3,650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses12000145802,58021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1,800-36.0%
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total1781001802602,1601.2%

Autosheet in Excel GPT-6 Astra · Low

Passed19s · 14¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032003.76%
3Rent240002400000.00%
4Marketing1500011350-3650-24.33%
5Software Subscriptions840091207208.57%
6Office Supplies32002870-330-10.31%
7Travel & Expenses1200014580258021.50%
8Utilities48004650-150-3.12%
9Insurance6500650000.00%
10Training & Development50003200-1800-36.00%
11Legal & Compliance75008900140018.67%
12Equipment Maintenance42003750-450-10.71%
13Miscellaneous2500314064025.60%
14Total178,100.00180,260.002,160.00

Autosheet in Sheets Opus 5.5 · Medium

Passed27s · 8¢
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent240002400000.0%
4Marketing1500011350-3,650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses12000145802,58021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1,800-36.0%
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total178,100180,2602,1601.2%

Autosheet in Excel Sonnet 5.5 · Medium

Passed12s · 4¢
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent240002400000.0%
4Marketing1500011350-3,650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses12000145802,58021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1,800-36.0%
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total178,100180,2602,1601.2%

Claude in Excel Opus 5.5 · High

Passed22s · 17¢
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent2400024000--
4Marketing1500011350(3,650)(24.3%)
5Software Subscriptions840091207208.6%
6Office Supplies32002870(330)(10.3%)
7Travel & Expenses12000145802,58021.5%
8Utilities48004650(150)(3.1%)
9Insurance65006500--
10Training & Development50003200(1,800)(36.0%)
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750(450)(10.7%)
13Miscellaneous2500314064025.6%
14Total178,100180,2602,1601.2%

Autosheet in Excel Haiku 5.5 · High

Passed15s · 0.3¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent240002400000.0%
4Marketing1500011350-3,650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses12000145802,58021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1,800-36.0%
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total178,100180,2602,160

Claude in Sheets Opus 5.5 · Medium

Passed49s · 12¢
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent2400024000--
4Marketing1500011350(3,650)(24.3%)
5Software Subscriptions840091207208.6%
6Office Supplies32002870(330)(10.3%)
7Travel & Expenses12000145802,58021.5%
8Utilities48004650(150)(3.1%)
9Insurance65006500--
10Training & Development50003200(1,800)(36.0%)
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750(450)(10.7%)
13Miscellaneous2500314064025.6%
14Total1781001802602,1601.2%

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed43s · N/A
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032003.8%
3Rent240002400000.0%
4Marketing1500011350-3650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses1200014580258021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1800-36.0%
11Legal & Compliance75008900140018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total1781001802602160

Autosheet in Excel GPT-6.1 Sol · Medium

Passed27s · 5¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,200.003.76%
3Rent24000240000.000.00%
4Marketing1500011350-3,650.00-24.33%
5Software Subscriptions84009120720.008.57%
6Office Supplies32002870-330.00-10.31%
7Travel & Expenses12000145802,580.0021.50%
8Utilities48004650-150.00-3.13%
9Insurance650065000.000.00%
10Training & Development50003200-1,800.00-36.00%
11Legal & Compliance750089001,400.0018.67%
12Equipment Maintenance42003750-450.00-10.71%
13Miscellaneous25003140640.0025.60%
14Total178,100.00180,260.002,160.00

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed2m 2s · N/A
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032003.8%
3Rent240002400000.0%
4Marketing1500011350-3650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses1200014580258021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1800-36.0%
11Legal & Compliance75008900140018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total17810018026021601.2%

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed1m 8s · N/A
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032003.8%
3Rent240002400000.0%
4Marketing1500011350-3650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses1200014580258021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1800-36.0%
11Legal & Compliance75008900140018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total17810018026021601.2%

Autosheet in Sheets Haiku 5.5 · High

Passed44s · 0.3¢
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032003.8%
3Rent240002400000.0%
4Marketing1500011350-3650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses1200014580258021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1800-36.0%
11Legal & Compliance75008900140018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total17810018026021601.2%

ChatGPT in Excel GPT-6 Astra · Medium

Passed21s · 75¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032003.8%
3Rent240002400000.0%
4Marketing1500011350-3650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses1200014580258021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1800-36.0%
11Legal & Compliance75008900140018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total1781001802602160

Claude in Excel Haiku 5.5 · High

Passed16s · 0.7¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent2400024000--
4Marketing1500011350(3,650)(24.3%)
5Software Subscriptions840091207208.6%
6Office Supplies32002870(330)(10.3%)
7Travel & Expenses12000145802,58021.5%
8Utilities48004650(150)(3.1%)
9Insurance65006500--
10Training & Development50003200(1,800)(36.0%)
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750(450)(10.7%)
13Miscellaneous2500314064025.6%
14Total178,100180,2602,160

Claude in Sheets Haiku 5.5 · High

Passed38s · 2¢
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent2400024000--
4Marketing1500011350(3,650)(24.3%)
5Software Subscriptions840091207208.6%
6Office Supplies32002870(330)(10.3%)
7Travel & Expenses12000145802,58021.5%
8Utilities48004650(150)(3.1%)
9Insurance65006500--
10Training & Development50003200(1,800)(36.0%)
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750(450)(10.7%)
13Miscellaneous2500314064025.6%
14Total178,100180,2602,1601.2%

Autosheet in Excel GPT-6 Luna · High

Passed14s · 0.3¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032000.037647059
3Rent240002400000
4Marketing1500011350-3650-0.243333333
5Software Subscriptions840091207200.085714286
6Office Supplies32002870-330-0.103125
7Travel & Expenses120001458025800.215
8Utilities48004650-150-0.03125
9Insurance6500650000
10Training & Development50003200-1800-0.36
11Legal & Compliance7500890014000.186666667
12Equipment Maintenance42003750-450-0.107142857
13Miscellaneous250031406400.256
14Total1781001802602160

Copilot in Excel Auto

Passed42s · N/A
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent240002400000.0%
4Marketing1500011350-3,650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses12000145802,58021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1,800-36.0%
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total178,100180,2602,160

ChatGPT + Drive MCP GPT-6 · Medium

Passed1m 5s · N/A
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032003.76%
3Rent240002400000.00%
4Marketing1500011350-3650-24.33%
5Software Subscriptions840091207208.57%
6Office Supplies32002870-330-10.31%
7Travel & Expenses1200014580258021.50%
8Utilities48004650-150-3.12%
9Insurance6500650000.00%
10Training & Development50003200-1800-36.00%
11Legal & Compliance75008900140018.67%
12Equipment Maintenance42003750-450-10.71%
13Miscellaneous2500314064025.60%
14Total1781001802602160

ChatGPT in Excel GPT-6 Luna · High

Passed26s · 0.8¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032000.037647059
3Rent240002400000
4Marketing1500011350-3650-0.243333333
5Software Subscriptions840091207200.085714286
6Office Supplies32002870-330-0.103125
7Travel & Expenses120001458025800.215
8Utilities48004650-150-0.03125
9Insurance6500650000
10Training & Development50003200-1800-0.36
11Legal & Compliance7500890014000.186666667
12Equipment Maintenance42003750-450-0.107142857
13Miscellaneous250031406400.256
14Total1781001802602160

Gemini in Sheets Auto

Passed3m 25s · N/A
Sheet129 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries85000882003,2003.8%
3Rent240002400000.0%
4Marketing1500011350-3,650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses12000145802,58021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1,800-36.0%
11Legal & Compliance750089001,40018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total178,100180,2602,1601.2%

ChatGPT in Sheets GPT-6 Astra · Medium

Passed44s · 67¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032003.8%
3Rent240002400000.0%
4Marketing1500011350-3650-24.3%
5Software Subscriptions840091207208.6%
6Office Supplies32002870-330-10.3%
7Travel & Expenses1200014580258021.5%
8Utilities48004650-150-3.1%
9Insurance6500650000.0%
10Training & Development50003200-1800-36.0%
11Legal & Compliance75008900140018.7%
12Equipment Maintenance42003750-450-10.7%
13Miscellaneous2500314064025.6%
14Total1781001802602160

ChatGPT in Sheets GPT-6 Luna · High

Passed34s · 0.6¢
Sheet128 cells changed

D2=C2-B2

ABCDE
1CategoryBudgetActualVarianceVariance%
2Salaries850008820032000.037647059
3Rent240002400000
4Marketing1500011350-3650-0.243333333
5Software Subscriptions840091207200.085714286
6Office Supplies32002870-330-0.103125
7Travel & Expenses120001458025800.215
8Utilities48004650-150-0.03125
9Insurance6500650000
10Training & Development50003200-1800-0.36
11Legal & Compliance7500890014000.186666667
12Equipment Maintenance42003750-450-0.107142857
13Miscellaneous250031406400.256
14Total1781001802602160