All AutosheetBench tasks

Break event budgets into line items

Spreadsheet manipulationEasyDeterministic scoringLatest run

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

Prompt and starting spreadsheet

Task files

Prompt

On a new tab "Budget Breakdown", create a summary starting at A1 with these columns: Event Name, Line Item, Allocation %, Estimated Cost. Keep the events in the same order as Sheet1 and repeat each event for these five line items, in this order: Venue, Catering, AV Equipment, Decorations, Staffing. Use allocation percentages of 30%, 35%, 15%, 8%, and 12%, respectively. Calculate Estimated Cost using each event's Total Budget from Sheet1.

Add Cost per Person and % of Event Budget as the next two table columns, using the matching Expected Guests and Total Budget from Sheet1.

Starting spreadsheet

Sheet1
ABCDE
1Event NameDateLocationExpected GuestsTotal Budget
2Q1 Sales Kickoff2024-01-15Chicago Marriott12028000
3Annual Tech Summit2024-03-22San Francisco Convention Center45095000
4Team Offsite Retreat2024-05-10Lake Tahoe Resort6018500
5Customer Appreciation Gala2024-09-14New York Plaza Hotel30072000
6Year-End Awards Dinner2024-12-06Los Angeles Ballroom20045000

A passing output

Autosheet in Excel · Opus 5.5
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!$A$2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%€8,400€70.0030.0%
3Q1 Sales KickoffCatering35%€9,800€81.6735.0%
4Q1 Sales KickoffAV Equipment15%€4,200€35.0015.0%
5Q1 Sales KickoffDecorations8%€2,240€18.678.0%
6Q1 Sales KickoffStaffing12%€3,360€28.0012.0%
7Annual Tech SummitVenue30%€28,500€63.3330.0%
8Annual Tech SummitCatering35%€33,250€73.8935.0%
9Annual Tech SummitAV Equipment15%€14,250€31.6715.0%
10Annual Tech SummitDecorations8%€7,600€16.898.0%
11Annual Tech SummitStaffing12%€11,400€25.3312.0%
12Team Offsite RetreatVenue30%€5,550€92.5030.0%
13Team Offsite RetreatCatering35%€6,475€107.9235.0%
14Team Offsite RetreatAV Equipment15%€2,775€46.2515.0%
15Team Offsite RetreatDecorations8%€1,480€24.678.0%
16Team Offsite RetreatStaffing12%€2,220€37.0012.0%
17Customer Appreciation GalaVenue30%€21,600€72.0030.0%
18Customer Appreciation GalaCatering35%€25,200€84.0035.0%
19Customer Appreciation GalaAV Equipment15%€10,800€36.0015.0%
20Customer Appreciation GalaDecorations8%€5,760€19.208.0%
21Customer Appreciation GalaStaffing12%€8,640€28.8012.0%

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.
  • Budget Breakdown!D2:F26 use formulas
  • Budget Breakdown!A1:F26 match the expected answers
  • A Budget Breakdown sheet exists

Passed 21

Autosheet in Excel Opus 5.5 · Medium

Passed27s · 9¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!$A$2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%€8,400€70.0030.0%
3Q1 Sales KickoffCatering35%€9,800€81.6735.0%
4Q1 Sales KickoffAV Equipment15%€4,200€35.0015.0%
5Q1 Sales KickoffDecorations8%€2,240€18.678.0%
6Q1 Sales KickoffStaffing12%€3,360€28.0012.0%
7Annual Tech SummitVenue30%€28,500€63.3330.0%
8Annual Tech SummitCatering35%€33,250€73.8935.0%
9Annual Tech SummitAV Equipment15%€14,250€31.6715.0%
10Annual Tech SummitDecorations8%€7,600€16.898.0%
11Annual Tech SummitStaffing12%€11,400€25.3312.0%
12Team Offsite RetreatVenue30%€5,550€92.5030.0%
13Team Offsite RetreatCatering35%€6,475€107.9235.0%
14Team Offsite RetreatAV Equipment15%€2,775€46.2515.0%
15Team Offsite RetreatDecorations8%€1,480€24.678.0%
16Team Offsite RetreatStaffing12%€2,220€37.0012.0%
17Customer Appreciation GalaVenue30%€21,600€72.0030.0%
18Customer Appreciation GalaCatering35%€25,200€84.0035.0%
19Customer Appreciation GalaAV Equipment15%€10,800€36.0015.0%
20Customer Appreciation GalaDecorations8%€5,760€19.208.0%
21Customer Appreciation GalaStaffing12%€8,640€28.8012.0%

Autosheet in Excel GPT-6 Astra · Low

Passed38s · 30¢
Budget BreakdownNew sheet · 156 cells changed

A2=INDEX(Sheet1!$A$2:$A$6,INT((ROW()-2)/5)+1)

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%8,400.0070.0030%
3Q1 Sales KickoffCatering35%9,800.0081.6735%
4Q1 Sales KickoffAV Equipment15%4,200.0035.0015%
5Q1 Sales KickoffDecorations8%2,240.0018.678%
6Q1 Sales KickoffStaffing12%3,360.0028.0012%
7Annual Tech SummitVenue30%28,500.0063.3330%
8Annual Tech SummitCatering35%33,250.0073.8935%
9Annual Tech SummitAV Equipment15%14,250.0031.6715%
10Annual Tech SummitDecorations8%7,600.0016.898%
11Annual Tech SummitStaffing12%11,400.0025.3312%
12Team Offsite RetreatVenue30%5,550.0092.5030%
13Team Offsite RetreatCatering35%6,475.00107.9235%
14Team Offsite RetreatAV Equipment15%2,775.0046.2515%
15Team Offsite RetreatDecorations8%1,480.0024.678%
16Team Offsite RetreatStaffing12%2,220.0037.0012%
17Customer Appreciation GalaVenue30%21,600.0072.0030%
18Customer Appreciation GalaCatering35%25,200.0084.0035%
19Customer Appreciation GalaAV Equipment15%10,800.0036.0015%
20Customer Appreciation GalaDecorations8%5,760.0019.208%
21Customer Appreciation GalaStaffing12%8,640.0028.8012%

Autosheet in Sheets Opus 5.5 · Medium

Passed52s · 15¢
Budget BreakdownNew sheet · 156 cells changed

A2=INDEX(Sheet1!$A$2:$A$6, INT((ROW()-2)/5)+1)

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400.00$70.0030.0%
3Q1 Sales KickoffCatering35%$9,800.00$81.6735.0%
4Q1 Sales KickoffAV Equipment15%$4,200.00$35.0015.0%
5Q1 Sales KickoffDecorations8%$2,240.00$18.678.0%
6Q1 Sales KickoffStaffing12%$3,360.00$28.0012.0%
7Annual Tech SummitVenue30%$28,500.00$63.3330.0%
8Annual Tech SummitCatering35%$33,250.00$73.8935.0%
9Annual Tech SummitAV Equipment15%$14,250.00$31.6715.0%
10Annual Tech SummitDecorations8%$7,600.00$16.898.0%
11Annual Tech SummitStaffing12%$11,400.00$25.3312.0%
12Team Offsite RetreatVenue30%$5,550.00$92.5030.0%
13Team Offsite RetreatCatering35%$6,475.00$107.9235.0%
14Team Offsite RetreatAV Equipment15%$2,775.00$46.2515.0%
15Team Offsite RetreatDecorations8%$1,480.00$24.678.0%
16Team Offsite RetreatStaffing12%$2,220.00$37.0012.0%
17Customer Appreciation GalaVenue30%$21,600.00$72.0030.0%
18Customer Appreciation GalaCatering35%$25,200.00$84.0035.0%
19Customer Appreciation GalaAV Equipment15%$10,800.00$36.0015.0%
20Customer Appreciation GalaDecorations8%$5,760.00$19.208.0%
21Customer Appreciation GalaStaffing12%$8,640.00$28.8012.0%

Autosheet in Excel Sonnet 5.5 · Medium

Passed14s · 4¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!A2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400$70.0030%
3Q1 Sales KickoffCatering35%$9,800$81.6735%
4Q1 Sales KickoffAV Equipment15%$4,200$35.0015%
5Q1 Sales KickoffDecorations8%$2,240$18.678%
6Q1 Sales KickoffStaffing12%$3,360$28.0012%
7Annual Tech SummitVenue30%$28,500$63.3330%
8Annual Tech SummitCatering35%$33,250$73.8935%
9Annual Tech SummitAV Equipment15%$14,250$31.6715%
10Annual Tech SummitDecorations8%$7,600$16.898%
11Annual Tech SummitStaffing12%$11,400$25.3312%
12Team Offsite RetreatVenue30%$5,550$92.5030%
13Team Offsite RetreatCatering35%$6,475$107.9235%
14Team Offsite RetreatAV Equipment15%$2,775$46.2515%
15Team Offsite RetreatDecorations8%$1,480$24.678%
16Team Offsite RetreatStaffing12%$2,220$37.0012%
17Customer Appreciation GalaVenue30%$21,600$72.0030%
18Customer Appreciation GalaCatering35%$25,200$84.0035%
19Customer Appreciation GalaAV Equipment15%$10,800$36.0015%
20Customer Appreciation GalaDecorations8%$5,760$19.208%
21Customer Appreciation GalaStaffing12%$8,640$28.8012%

Claude in Excel Opus 5.5 · High

Passed39s · 24¢
Budget BreakdownNew sheet · 170 cells changed

A2=INDEX(Sheet1!$A$2:$A$6,INT((ROW()-ROW($A$2))/5)+1)

ABCDEFGHIJ
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event BudgetLine ItemAllocation %
2Q1 Sales KickoffVenue30.0%€8,400€70.0030.0%Venue30.0%
3Q1 Sales KickoffCatering35.0%€9,800€81.6735.0%Catering35.0%
4Q1 Sales KickoffAV Equipment15.0%€4,200€35.0015.0%AV Equipment15.0%
5Q1 Sales KickoffDecorations8.0%€2,240€18.678.0%Decorations8.0%
6Q1 Sales KickoffStaffing12.0%€3,360€28.0012.0%Staffing12.0%
7Annual Tech SummitVenue30.0%€28,500€63.3330.0%Total100.0%
8Annual Tech SummitCatering35.0%€33,250€73.8935.0%
9Annual Tech SummitAV Equipment15.0%€14,250€31.6715.0%
10Annual Tech SummitDecorations8.0%€7,600€16.898.0%
11Annual Tech SummitStaffing12.0%€11,400€25.3312.0%
12Team Offsite RetreatVenue30.0%€5,550€92.5030.0%
13Team Offsite RetreatCatering35.0%€6,475€107.9235.0%
14Team Offsite RetreatAV Equipment15.0%€2,775€46.2515.0%
15Team Offsite RetreatDecorations8.0%€1,480€24.678.0%
16Team Offsite RetreatStaffing12.0%€2,220€37.0012.0%
17Customer Appreciation GalaVenue30.0%€21,600€72.0030.0%
18Customer Appreciation GalaCatering35.0%€25,200€84.0035.0%
19Customer Appreciation GalaAV Equipment15.0%€10,800€36.0015.0%
20Customer Appreciation GalaDecorations8.0%€5,760€19.208.0%
21Customer Appreciation GalaStaffing12.0%€8,640€28.8012.0%

Autosheet in Excel Haiku 5.5 · High

Passed28s · 0.6¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!A2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400.00$70.0030%
3Q1 Sales KickoffCatering35%$9,800.00$81.6735%
4Q1 Sales KickoffAV Equipment15%$4,200.00$35.0015%
5Q1 Sales KickoffDecorations8%$2,240.00$18.678%
6Q1 Sales KickoffStaffing12%$3,360.00$28.0012%
7Annual Tech SummitVenue30%$28,500.00$63.3330%
8Annual Tech SummitCatering35%$33,250.00$73.8935%
9Annual Tech SummitAV Equipment15%$14,250.00$31.6715%
10Annual Tech SummitDecorations8%$7,600.00$16.898%
11Annual Tech SummitStaffing12%$11,400.00$25.3312%
12Team Offsite RetreatVenue30%$5,550.00$92.5030%
13Team Offsite RetreatCatering35%$6,475.00$107.9235%
14Team Offsite RetreatAV Equipment15%$2,775.00$46.2515%
15Team Offsite RetreatDecorations8%$1,480.00$24.678%
16Team Offsite RetreatStaffing12%$2,220.00$37.0012%
17Customer Appreciation GalaVenue30%$21,600.00$72.0030%
18Customer Appreciation GalaCatering35%$25,200.00$84.0035%
19Customer Appreciation GalaAV Equipment15%$10,800.00$36.0015%
20Customer Appreciation GalaDecorations8%$5,760.00$19.208%
21Customer Appreciation GalaStaffing12%$8,640.00$28.8012%

Claude in Sheets Opus 5.5 · Medium

Passed38s · 11¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!$A$2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30.0%$8,400$70.0030.0%
3Q1 Sales KickoffCatering35.0%$9,800$81.6735.0%
4Q1 Sales KickoffAV Equipment15.0%$4,200$35.0015.0%
5Q1 Sales KickoffDecorations8.0%$2,240$18.678.0%
6Q1 Sales KickoffStaffing12.0%$3,360$28.0012.0%
7Annual Tech SummitVenue30.0%$28,500$63.3330.0%
8Annual Tech SummitCatering35.0%$33,250$73.8935.0%
9Annual Tech SummitAV Equipment15.0%$14,250$31.6715.0%
10Annual Tech SummitDecorations8.0%$7,600$16.898.0%
11Annual Tech SummitStaffing12.0%$11,400$25.3312.0%
12Team Offsite RetreatVenue30.0%$5,550$92.5030.0%
13Team Offsite RetreatCatering35.0%$6,475$107.9235.0%
14Team Offsite RetreatAV Equipment15.0%$2,775$46.2515.0%
15Team Offsite RetreatDecorations8.0%$1,480$24.678.0%
16Team Offsite RetreatStaffing12.0%$2,220$37.0012.0%
17Customer Appreciation GalaVenue30.0%$21,600$72.0030.0%
18Customer Appreciation GalaCatering35.0%$25,200$84.0035.0%
19Customer Appreciation GalaAV Equipment15.0%$10,800$36.0015.0%
20Customer Appreciation GalaDecorations8.0%$5,760$19.208.0%
21Customer Appreciation GalaStaffing12.0%$8,640$28.8012.0%

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed2m 4s · N/A
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!$A$2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400.00$70.0030%
3Q1 Sales KickoffCatering35%$9,800.00$81.6735%
4Q1 Sales KickoffAV Equipment15%$4,200.00$35.0015%
5Q1 Sales KickoffDecorations8%$2,240.00$18.678%
6Q1 Sales KickoffStaffing12%$3,360.00$28.0012%
7Annual Tech SummitVenue30%$28,500.00$63.3330%
8Annual Tech SummitCatering35%$33,250.00$73.8935%
9Annual Tech SummitAV Equipment15%$14,250.00$31.6715%
10Annual Tech SummitDecorations8%$7,600.00$16.898%
11Annual Tech SummitStaffing12%$11,400.00$25.3312%
12Team Offsite RetreatVenue30%$5,550.00$92.5030%
13Team Offsite RetreatCatering35%$6,475.00$107.9235%
14Team Offsite RetreatAV Equipment15%$2,775.00$46.2515%
15Team Offsite RetreatDecorations8%$1,480.00$24.678%
16Team Offsite RetreatStaffing12%$2,220.00$37.0012%
17Customer Appreciation GalaVenue30%$21,600.00$72.0030%
18Customer Appreciation GalaCatering35%$25,200.00$84.0035%
19Customer Appreciation GalaAV Equipment15%$10,800.00$36.0015%
20Customer Appreciation GalaDecorations8%$5,760.00$19.208%
21Customer Appreciation GalaStaffing12%$8,640.00$28.8012%

Autosheet in Excel GPT-6.1 Sol · Medium

Passed1m 4s · 12¢
Budget BreakdownNew sheet · 156 cells changed

A2=INDEX(Sheet1!$A$2:$A$6,INT((ROW()-2)/5)+1)

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400.00$70.0030%
3Q1 Sales KickoffCatering35%$9,800.00$81.6735%
4Q1 Sales KickoffAV Equipment15%$4,200.00$35.0015%
5Q1 Sales KickoffDecorations8%$2,240.00$18.678%
6Q1 Sales KickoffStaffing12%$3,360.00$28.0012%
7Annual Tech SummitVenue30%$28,500.00$63.3330%
8Annual Tech SummitCatering35%$33,250.00$73.8935%
9Annual Tech SummitAV Equipment15%$14,250.00$31.6715%
10Annual Tech SummitDecorations8%$7,600.00$16.898%
11Annual Tech SummitStaffing12%$11,400.00$25.3312%
12Team Offsite RetreatVenue30%$5,550.00$92.5030%
13Team Offsite RetreatCatering35%$6,475.00$107.9235%
14Team Offsite RetreatAV Equipment15%$2,775.00$46.2515%
15Team Offsite RetreatDecorations8%$1,480.00$24.678%
16Team Offsite RetreatStaffing12%$2,220.00$37.0012%
17Customer Appreciation GalaVenue30%$21,600.00$72.0030%
18Customer Appreciation GalaCatering35%$25,200.00$84.0035%
19Customer Appreciation GalaAV Equipment15%$10,800.00$36.0015%
20Customer Appreciation GalaDecorations8%$5,760.00$19.208%
21Customer Appreciation GalaStaffing12%$8,640.00$28.8012%

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed2m 2s · N/A
Budget BreakdownNew sheet · 156 cells changed

A2=INDEX(Sheet1!$A:$A, INT((ROW()-2)/5)+2)

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400.00$70.0030.0%
3Q1 Sales KickoffCatering35%$9,800.00$81.6735.0%
4Q1 Sales KickoffAV Equipment15%$4,200.00$35.0015.0%
5Q1 Sales KickoffDecorations8%$2,240.00$18.678.0%
6Q1 Sales KickoffStaffing12%$3,360.00$28.0012.0%
7Annual Tech SummitVenue30%$28,500.00$63.3330.0%
8Annual Tech SummitCatering35%$33,250.00$73.8935.0%
9Annual Tech SummitAV Equipment15%$14,250.00$31.6715.0%
10Annual Tech SummitDecorations8%$7,600.00$16.898.0%
11Annual Tech SummitStaffing12%$11,400.00$25.3312.0%
12Team Offsite RetreatVenue30%$5,550.00$92.5030.0%
13Team Offsite RetreatCatering35%$6,475.00$107.9235.0%
14Team Offsite RetreatAV Equipment15%$2,775.00$46.2515.0%
15Team Offsite RetreatDecorations8%$1,480.00$24.678.0%
16Team Offsite RetreatStaffing12%$2,220.00$37.0012.0%
17Customer Appreciation GalaVenue30%$21,600.00$72.0030.0%
18Customer Appreciation GalaCatering35%$25,200.00$84.0035.0%
19Customer Appreciation GalaAV Equipment15%$10,800.00$36.0015.0%
20Customer Appreciation GalaDecorations8%$5,760.00$19.208.0%
21Customer Appreciation GalaStaffing12%$8,640.00$28.8012.0%

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed2m 5s · N/A
Budget BreakdownNew sheet · 156 cells changed

A2=INDEX(Sheet1!$A:$A, 2 + INT((ROW() - 2) / 5))

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400.00$70.0030.0%
3Q1 Sales KickoffCatering35%$9,800.00$81.6735.0%
4Q1 Sales KickoffAV Equipment15%$4,200.00$35.0015.0%
5Q1 Sales KickoffDecorations8%$2,240.00$18.678.0%
6Q1 Sales KickoffStaffing12%$3,360.00$28.0012.0%
7Annual Tech SummitVenue30%$28,500.00$63.3330.0%
8Annual Tech SummitCatering35%$33,250.00$73.8935.0%
9Annual Tech SummitAV Equipment15%$14,250.00$31.6715.0%
10Annual Tech SummitDecorations8%$7,600.00$16.898.0%
11Annual Tech SummitStaffing12%$11,400.00$25.3312.0%
12Team Offsite RetreatVenue30%$5,550.00$92.5030.0%
13Team Offsite RetreatCatering35%$6,475.00$107.9235.0%
14Team Offsite RetreatAV Equipment15%$2,775.00$46.2515.0%
15Team Offsite RetreatDecorations8%$1,480.00$24.678.0%
16Team Offsite RetreatStaffing12%$2,220.00$37.0012.0%
17Customer Appreciation GalaVenue30%$21,600.00$72.0030.0%
18Customer Appreciation GalaCatering35%$25,200.00$84.0035.0%
19Customer Appreciation GalaAV Equipment15%$10,800.00$36.0015.0%
20Customer Appreciation GalaDecorations8%$5,760.00$19.208.0%
21Customer Appreciation GalaStaffing12%$8,640.00$28.8012.0%

Autosheet in Sheets Haiku 5.5 · High

Passed1m 18s · 1¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!A2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400.00$70.0030%
3Q1 Sales KickoffCatering35%$9,800.00$81.6735%
4Q1 Sales KickoffAV Equipment15%$4,200.00$35.0015%
5Q1 Sales KickoffDecorations8%$2,240.00$18.678%
6Q1 Sales KickoffStaffing12%$3,360.00$28.0012%
7Annual Tech SummitVenue30%$28,500.00$63.3330%
8Annual Tech SummitCatering35%$33,250.00$73.8935%
9Annual Tech SummitAV Equipment15%$14,250.00$31.6715%
10Annual Tech SummitDecorations8%$7,600.00$16.898%
11Annual Tech SummitStaffing12%$11,400.00$25.3312%
12Team Offsite RetreatVenue30%$5,550.00$92.5030%
13Team Offsite RetreatCatering35%$6,475.00$107.9235%
14Team Offsite RetreatAV Equipment15%$2,775.00$46.2515%
15Team Offsite RetreatDecorations8%$1,480.00$24.678%
16Team Offsite RetreatStaffing12%$2,220.00$37.0012%
17Customer Appreciation GalaVenue30%$21,600.00$72.0030%
18Customer Appreciation GalaCatering35%$25,200.00$84.0035%
19Customer Appreciation GalaAV Equipment15%$10,800.00$36.0015%
20Customer Appreciation GalaDecorations8%$5,760.00$19.208%
21Customer Appreciation GalaStaffing12%$8,640.00$28.8012%

ChatGPT in Excel GPT-6 Astra · Medium

Passed35s · 81¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!A2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%8,400.0070.0030%
3Q1 Sales KickoffCatering35%9,800.0081.6735%
4Q1 Sales KickoffAV Equipment15%4,200.0035.0015%
5Q1 Sales KickoffDecorations8%2,240.0018.678%
6Q1 Sales KickoffStaffing12%3,360.0028.0012%
7Annual Tech SummitVenue30%28,500.0063.3330%
8Annual Tech SummitCatering35%33,250.0073.8935%
9Annual Tech SummitAV Equipment15%14,250.0031.6715%
10Annual Tech SummitDecorations8%7,600.0016.898%
11Annual Tech SummitStaffing12%11,400.0025.3312%
12Team Offsite RetreatVenue30%5,550.0092.5030%
13Team Offsite RetreatCatering35%6,475.00107.9235%
14Team Offsite RetreatAV Equipment15%2,775.0046.2515%
15Team Offsite RetreatDecorations8%1,480.0024.678%
16Team Offsite RetreatStaffing12%2,220.0037.0012%
17Customer Appreciation GalaVenue30%21,600.0072.0030%
18Customer Appreciation GalaCatering35%25,200.0084.0035%
19Customer Appreciation GalaAV Equipment15%10,800.0036.0015%
20Customer Appreciation GalaDecorations8%5,760.0019.208%
21Customer Appreciation GalaStaffing12%8,640.0028.8012%

Claude in Excel Haiku 5.5 · High

Passed24s · 1¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!$A$2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%8,40070.0030.0%
3Q1 Sales KickoffCatering35%9,80081.6735.0%
4Q1 Sales KickoffAV Equipment15%4,20035.0015.0%
5Q1 Sales KickoffDecorations8%2,24018.678.0%
6Q1 Sales KickoffStaffing12%3,36028.0012.0%
7Annual Tech SummitVenue30%28,50063.3330.0%
8Annual Tech SummitCatering35%33,25073.8935.0%
9Annual Tech SummitAV Equipment15%14,25031.6715.0%
10Annual Tech SummitDecorations8%7,60016.898.0%
11Annual Tech SummitStaffing12%11,40025.3312.0%
12Team Offsite RetreatVenue30%5,55092.5030.0%
13Team Offsite RetreatCatering35%6,475107.9235.0%
14Team Offsite RetreatAV Equipment15%2,77546.2515.0%
15Team Offsite RetreatDecorations8%1,48024.678.0%
16Team Offsite RetreatStaffing12%2,22037.0012.0%
17Customer Appreciation GalaVenue30%21,60072.0030.0%
18Customer Appreciation GalaCatering35%25,20084.0035.0%
19Customer Appreciation GalaAV Equipment15%10,80036.0015.0%
20Customer Appreciation GalaDecorations8%5,76019.208.0%
21Customer Appreciation GalaStaffing12%8,64028.8012.0%

Claude in Sheets Haiku 5.5 · High

Passed1m 21s · 2¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!$A$2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400$70.0030.0%
3Q1 Sales KickoffCatering35%$9,800$81.6735.0%
4Q1 Sales KickoffAV Equipment15%$4,200$35.0015.0%
5Q1 Sales KickoffDecorations8%$2,240$18.678.0%
6Q1 Sales KickoffStaffing12%$3,360$28.0012.0%
7Annual Tech SummitVenue30%$28,500$63.3330.0%
8Annual Tech SummitCatering35%$33,250$73.8935.0%
9Annual Tech SummitAV Equipment15%$14,250$31.6715.0%
10Annual Tech SummitDecorations8%$7,600$16.898.0%
11Annual Tech SummitStaffing12%$11,400$25.3312.0%
12Team Offsite RetreatVenue30%$5,550$92.5030.0%
13Team Offsite RetreatCatering35%$6,475$107.9235.0%
14Team Offsite RetreatAV Equipment15%$2,775$46.2515.0%
15Team Offsite RetreatDecorations8%$1,480$24.678.0%
16Team Offsite RetreatStaffing12%$2,220$37.0012.0%
17Customer Appreciation GalaVenue30%$21,600$72.0030.0%
18Customer Appreciation GalaCatering35%$25,200$84.0035.0%
19Customer Appreciation GalaAV Equipment15%$10,800$36.0015.0%
20Customer Appreciation GalaDecorations8%$5,760$19.208.0%
21Customer Appreciation GalaStaffing12%$8,640$28.8012.0%

Autosheet in Excel GPT-6 Luna · High

Passed1m · 1¢
Budget BreakdownNew sheet · 156 cells changed

D2=XLOOKUP(A2,Sheet1!$A$2:$A$6,Sheet1!$E$2:$E$6)*C2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%8,400.0070.0030%
3Q1 Sales KickoffCatering35%9,800.0081.6735%
4Q1 Sales KickoffAV Equipment15%4,200.0035.0015%
5Q1 Sales KickoffDecorations8%2,240.0018.678%
6Q1 Sales KickoffStaffing12%3,360.0028.0012%
7Annual Tech SummitVenue30%28,500.0063.3330%
8Annual Tech SummitCatering35%33,250.0073.8935%
9Annual Tech SummitAV Equipment15%14,250.0031.6715%
10Annual Tech SummitDecorations8%7,600.0016.898%
11Annual Tech SummitStaffing12%11,400.0025.3312%
12Team Offsite RetreatVenue30%5,550.0092.5030%
13Team Offsite RetreatCatering35%6,475.00107.9235%
14Team Offsite RetreatAV Equipment15%2,775.0046.2515%
15Team Offsite RetreatDecorations8%1,480.0024.678%
16Team Offsite RetreatStaffing12%2,220.0037.0012%
17Customer Appreciation GalaVenue30%21,600.0072.0030%
18Customer Appreciation GalaCatering35%25,200.0084.0035%
19Customer Appreciation GalaAV Equipment15%10,800.0036.0015%
20Customer Appreciation GalaDecorations8%5,760.0019.208%
21Customer Appreciation GalaStaffing12%8,640.0028.8012%

Copilot in Excel Auto

Passed46s · N/A
Budget BreakdownNew sheet · 156 cells changed

D2=C2*XLOOKUP(A2,Sheet1!$A$2:$A$6,Sheet1!$E$2:$E$6)

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%€8,400.00€70.0030%
3Q1 Sales KickoffCatering35%€9,800.00€81.6735%
4Q1 Sales KickoffAV Equipment15%€4,200.00€35.0015%
5Q1 Sales KickoffDecorations8%€2,240.00€18.678%
6Q1 Sales KickoffStaffing12%€3,360.00€28.0012%
7Annual Tech SummitVenue30%€28,500.00€63.3330%
8Annual Tech SummitCatering35%€33,250.00€73.8935%
9Annual Tech SummitAV Equipment15%€14,250.00€31.6715%
10Annual Tech SummitDecorations8%€7,600.00€16.898%
11Annual Tech SummitStaffing12%€11,400.00€25.3312%
12Team Offsite RetreatVenue30%€5,550.00€92.5030%
13Team Offsite RetreatCatering35%€6,475.00€107.9235%
14Team Offsite RetreatAV Equipment15%€2,775.00€46.2515%
15Team Offsite RetreatDecorations8%€1,480.00€24.678%
16Team Offsite RetreatStaffing12%€2,220.00€37.0012%
17Customer Appreciation GalaVenue30%€21,600.00€72.0030%
18Customer Appreciation GalaCatering35%€25,200.00€84.0035%
19Customer Appreciation GalaAV Equipment15%€10,800.00€36.0015%
20Customer Appreciation GalaDecorations8%€5,760.00€19.208%
21Customer Appreciation GalaStaffing12%€8,640.00€28.8012%

ChatGPT + Drive MCP GPT-6 · Medium

Passed59s · N/A
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!A2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%8,400.0070.0030%
3Q1 Sales KickoffCatering35%9,800.0081.6735%
4Q1 Sales KickoffAV Equipment15%4,200.0035.0015%
5Q1 Sales KickoffDecorations8%2,240.0018.678%
6Q1 Sales KickoffStaffing12%3,360.0028.0012%
7Annual Tech SummitVenue30%28,500.0063.3330%
8Annual Tech SummitCatering35%33,250.0073.8935%
9Annual Tech SummitAV Equipment15%14,250.0031.6715%
10Annual Tech SummitDecorations8%7,600.0016.898%
11Annual Tech SummitStaffing12%11,400.0025.3312%
12Team Offsite RetreatVenue30%5,550.0092.5030%
13Team Offsite RetreatCatering35%6,475.00107.9235%
14Team Offsite RetreatAV Equipment15%2,775.0046.2515%
15Team Offsite RetreatDecorations8%1,480.0024.678%
16Team Offsite RetreatStaffing12%2,220.0037.0012%
17Customer Appreciation GalaVenue30%21,600.0072.0030%
18Customer Appreciation GalaCatering35%25,200.0084.0035%
19Customer Appreciation GalaAV Equipment15%10,800.0036.0015%
20Customer Appreciation GalaDecorations8%5,760.0019.208%
21Customer Appreciation GalaStaffing12%8,640.0028.8012%

ChatGPT in Excel GPT-6 Luna · High

Passed1m 6s · 1¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!A2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%€8,400€70.0030%
3Q1 Sales KickoffCatering35%€9,800€81.6735%
4Q1 Sales KickoffAV Equipment15%€4,200€35.0015%
5Q1 Sales KickoffDecorations8%€2,240€18.678%
6Q1 Sales KickoffStaffing12%€3,360€28.0012%
7Annual Tech SummitVenue30%€28,500€63.3330%
8Annual Tech SummitCatering35%€33,250€73.8935%
9Annual Tech SummitAV Equipment15%€14,250€31.6715%
10Annual Tech SummitDecorations8%€7,600€16.898%
11Annual Tech SummitStaffing12%€11,400€25.3312%
12Team Offsite RetreatVenue30%€5,550€92.5030%
13Team Offsite RetreatCatering35%€6,475€107.9235%
14Team Offsite RetreatAV Equipment15%€2,775€46.2515%
15Team Offsite RetreatDecorations8%€1,480€24.678%
16Team Offsite RetreatStaffing12%€2,220€37.0012%
17Customer Appreciation GalaVenue30%€21,600€72.0030%
18Customer Appreciation GalaCatering35%€25,200€84.0035%
19Customer Appreciation GalaAV Equipment15%€10,800€36.0015%
20Customer Appreciation GalaDecorations8%€5,760€19.208%
21Customer Appreciation GalaStaffing12%€8,640€28.8012%

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 39s · $1.35
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!$A$2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%8,400.0070.0030%
3Q1 Sales KickoffCatering35%9,800.0081.6735%
4Q1 Sales KickoffAV Equipment15%4,200.0035.0015%
5Q1 Sales KickoffDecorations8%2,240.0018.678%
6Q1 Sales KickoffStaffing12%3,360.0028.0012%
7Annual Tech SummitVenue30%28,500.0063.3330%
8Annual Tech SummitCatering35%33,250.0073.8935%
9Annual Tech SummitAV Equipment15%14,250.0031.6715%
10Annual Tech SummitDecorations8%7,600.0016.898%
11Annual Tech SummitStaffing12%11,400.0025.3312%
12Team Offsite RetreatVenue30%5,550.0092.5030%
13Team Offsite RetreatCatering35%6,475.00107.9235%
14Team Offsite RetreatAV Equipment15%2,775.0046.2515%
15Team Offsite RetreatDecorations8%1,480.0024.678%
16Team Offsite RetreatStaffing12%2,220.0037.0012%
17Customer Appreciation GalaVenue30%21,600.0072.0030%
18Customer Appreciation GalaCatering35%25,200.0084.0035%
19Customer Appreciation GalaAV Equipment15%10,800.0036.0015%
20Customer Appreciation GalaDecorations8%5,760.0019.208%
21Customer Appreciation GalaStaffing12%8,640.0028.8012%

ChatGPT in Sheets GPT-6 Luna · High

Passed2m 24s · 1¢
Budget BreakdownNew sheet · 156 cells changed

A2=Sheet1!A2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400.00$70.0030.0%
3Q1 Sales KickoffCatering35%$9,800.00$81.6735.0%
4Q1 Sales KickoffAV Equipment15%$4,200.00$35.0015.0%
5Q1 Sales KickoffDecorations8%$2,240.00$18.678.0%
6Q1 Sales KickoffStaffing12%$3,360.00$28.0012.0%
7Annual Tech SummitVenue30%$28,500.00$63.3330.0%
8Annual Tech SummitCatering35%$33,250.00$73.8935.0%
9Annual Tech SummitAV Equipment15%$14,250.00$31.6715.0%
10Annual Tech SummitDecorations8%$7,600.00$16.898.0%
11Annual Tech SummitStaffing12%$11,400.00$25.3312.0%
12Team Offsite RetreatVenue30%$5,550.00$92.5030.0%
13Team Offsite RetreatCatering35%$6,475.00$107.9235.0%
14Team Offsite RetreatAV Equipment15%$2,775.00$46.2515.0%
15Team Offsite RetreatDecorations8%$1,480.00$24.678.0%
16Team Offsite RetreatStaffing12%$2,220.00$37.0012.0%
17Customer Appreciation GalaVenue30%$21,600.00$72.0030.0%
18Customer Appreciation GalaCatering35%$25,200.00$84.0035.0%
19Customer Appreciation GalaAV Equipment15%$10,800.00$36.0015.0%
20Customer Appreciation GalaDecorations8%$5,760.00$19.208.0%
21Customer Appreciation GalaStaffing12%$8,640.00$28.8012.0%

Failed 1

Gemini in Sheets Auto

Failed5m · N/A
Budget BreakdownNew sheet · 131 cells changedWrong or missing value

A2=Sheet1!A2

ABCDEF
1Event NameLine ItemAllocation %Estimated CostCost per Person% of Event Budget
2Q1 Sales KickoffVenue30%$8,400$70.00
3Q1 Sales KickoffCatering35%$9,800$81.67
4Q1 Sales KickoffAV Equipment15%$4,200$35.00
5Q1 Sales KickoffDecorations8%$2,240$18.67
6Q1 Sales KickoffStaffing12%$3,360$28.00
7Annual Tech SummitVenue30%$28,500$63.33
8Annual Tech SummitCatering35%$33,250$73.89
9Annual Tech SummitAV Equipment15%$14,250$31.67
10Annual Tech SummitDecorations8%$7,600$16.89
11Annual Tech SummitStaffing12%$11,400$25.33
12Team Offsite RetreatVenue30%$5,550$92.50
13Team Offsite RetreatCatering35%$6,475$107.92
14Team Offsite RetreatAV Equipment15%$2,775$46.25
15Team Offsite RetreatDecorations8%$1,480$24.67
16Team Offsite RetreatStaffing12%$2,220$37.00
17Customer Appreciation GalaVenue30%$21,600$72.00
18Customer Appreciation GalaCatering35%$25,200$84.00
19Customer Appreciation GalaAV Equipment15%$10,800$36.00
20Customer Appreciation GalaDecorations8%$5,760$19.20
21Customer Appreciation GalaStaffing12%$8,640$28.80

Why it failed: Still working at the 5-minute time limit. 25 cells are wrong, such as F2: empty instead of 0.3. F2:F26 hold no formula.