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
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| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Event Name | Date | Location | Expected Guests | Total Budget |
| 2 | Q1 Sales Kickoff | 2024-01-15 | Chicago Marriott | 120 | 28000 |
| 3 | Annual Tech Summit | 2024-03-22 | San Francisco Convention Center | 450 | 95000 |
| 4 | Team Offsite Retreat | 2024-05-10 | Lake Tahoe Resort | 60 | 18500 |
| 5 | Customer Appreciation Gala | 2024-09-14 | New York Plaza Hotel | 300 | 72000 |
| 6 | Year-End Awards Dinner | 2024-12-06 | Los Angeles Ballroom | 200 | 45000 |
A passing output
Autosheet in Excel · Opus 5.5A2=Sheet1!$A$2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | €8,400 | €70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35% | €9,800 | €81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | €4,200 | €35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | €2,240 | €18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | €3,360 | €28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30% | €28,500 | €63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35% | €33,250 | €73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15% | €14,250 | €31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8% | €7,600 | €16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12% | €11,400 | €25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30% | €5,550 | €92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35% | €6,475 | €107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | €2,775 | €46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8% | €1,480 | €24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12% | €2,220 | €37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30% | €21,600 | €72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35% | €25,200 | €84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | €10,800 | €36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8% | €5,760 | €19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12% | €8,640 | €28.80 | 12.0% |
Pass criteria
All must be met, checked automatically.Budget Breakdown!D2:F26use formulasBudget Breakdown!A1:F26match the expected answers- A Budget Breakdown sheet exists
Passed 21
Autosheet in Excel Opus 5.5 · Medium
A2=Sheet1!$A$2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | €8,400 | €70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35% | €9,800 | €81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | €4,200 | €35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | €2,240 | €18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | €3,360 | €28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30% | €28,500 | €63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35% | €33,250 | €73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15% | €14,250 | €31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8% | €7,600 | €16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12% | €11,400 | €25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30% | €5,550 | €92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35% | €6,475 | €107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | €2,775 | €46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8% | €1,480 | €24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12% | €2,220 | €37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30% | €21,600 | €72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35% | €25,200 | €84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | €10,800 | €36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8% | €5,760 | €19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12% | €8,640 | €28.80 | 12.0% |
Autosheet in Excel GPT-6 Astra · Low
A2=INDEX(Sheet1!$A$2:$A$6,INT((ROW()-2)/5)+1)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | 8,400.00 | 70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | 9,800.00 | 81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | 4,200.00 | 35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | 2,240.00 | 18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | 3,360.00 | 28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | 28,500.00 | 63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | 33,250.00 | 73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | 14,250.00 | 31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | 7,600.00 | 16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | 11,400.00 | 25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | 5,550.00 | 92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | 6,475.00 | 107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | 2,775.00 | 46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | 1,480.00 | 24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | 2,220.00 | 37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | 21,600.00 | 72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | 25,200.00 | 84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | 10,800.00 | 36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | 5,760.00 | 19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | 8,640.00 | 28.80 | 12% |
Autosheet in Sheets Opus 5.5 · Medium
A2=INDEX(Sheet1!$A$2:$A$6, INT((ROW()-2)/5)+1)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400.00 | $70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800.00 | $81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200.00 | $35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240.00 | $18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360.00 | $28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500.00 | $63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250.00 | $73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250.00 | $31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600.00 | $16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400.00 | $25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550.00 | $92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475.00 | $107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775.00 | $46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480.00 | $24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220.00 | $37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600.00 | $72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200.00 | $84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800.00 | $36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760.00 | $19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640.00 | $28.80 | 12.0% |
Autosheet in Excel Sonnet 5.5 · Medium
A2=Sheet1!A2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400 | $70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800 | $81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200 | $35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240 | $18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360 | $28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500 | $63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250 | $73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250 | $31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600 | $16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400 | $25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550 | $92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475 | $107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775 | $46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480 | $24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220 | $37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600 | $72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200 | $84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800 | $36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760 | $19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640 | $28.80 | 12% |
Claude in Excel Opus 5.5 · High
A2=INDEX(Sheet1!$A$2:$A$6,INT((ROW()-ROW($A$2))/5)+1)
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget | Line Item | Allocation % | ||
| 2 | Q1 Sales Kickoff | Venue | 30.0% | €8,400 | €70.00 | 30.0% | Venue | 30.0% | ||
| 3 | Q1 Sales Kickoff | Catering | 35.0% | €9,800 | €81.67 | 35.0% | Catering | 35.0% | ||
| 4 | Q1 Sales Kickoff | AV Equipment | 15.0% | €4,200 | €35.00 | 15.0% | AV Equipment | 15.0% | ||
| 5 | Q1 Sales Kickoff | Decorations | 8.0% | €2,240 | €18.67 | 8.0% | Decorations | 8.0% | ||
| 6 | Q1 Sales Kickoff | Staffing | 12.0% | €3,360 | €28.00 | 12.0% | Staffing | 12.0% | ||
| 7 | Annual Tech Summit | Venue | 30.0% | €28,500 | €63.33 | 30.0% | Total | 100.0% | ||
| 8 | Annual Tech Summit | Catering | 35.0% | €33,250 | €73.89 | 35.0% | ||||
| 9 | Annual Tech Summit | AV Equipment | 15.0% | €14,250 | €31.67 | 15.0% | ||||
| 10 | Annual Tech Summit | Decorations | 8.0% | €7,600 | €16.89 | 8.0% | ||||
| 11 | Annual Tech Summit | Staffing | 12.0% | €11,400 | €25.33 | 12.0% | ||||
| 12 | Team Offsite Retreat | Venue | 30.0% | €5,550 | €92.50 | 30.0% | ||||
| 13 | Team Offsite Retreat | Catering | 35.0% | €6,475 | €107.92 | 35.0% | ||||
| 14 | Team Offsite Retreat | AV Equipment | 15.0% | €2,775 | €46.25 | 15.0% | ||||
| 15 | Team Offsite Retreat | Decorations | 8.0% | €1,480 | €24.67 | 8.0% | ||||
| 16 | Team Offsite Retreat | Staffing | 12.0% | €2,220 | €37.00 | 12.0% | ||||
| 17 | Customer Appreciation Gala | Venue | 30.0% | €21,600 | €72.00 | 30.0% | ||||
| 18 | Customer Appreciation Gala | Catering | 35.0% | €25,200 | €84.00 | 35.0% | ||||
| 19 | Customer Appreciation Gala | AV Equipment | 15.0% | €10,800 | €36.00 | 15.0% | ||||
| 20 | Customer Appreciation Gala | Decorations | 8.0% | €5,760 | €19.20 | 8.0% | ||||
| 21 | Customer Appreciation Gala | Staffing | 12.0% | €8,640 | €28.80 | 12.0% |
Autosheet in Excel Haiku 5.5 · High
A2=Sheet1!A2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400.00 | $70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800.00 | $81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200.00 | $35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240.00 | $18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360.00 | $28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500.00 | $63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250.00 | $73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250.00 | $31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600.00 | $16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400.00 | $25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550.00 | $92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475.00 | $107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775.00 | $46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480.00 | $24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220.00 | $37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600.00 | $72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200.00 | $84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800.00 | $36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760.00 | $19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640.00 | $28.80 | 12% |
Claude in Sheets Opus 5.5 · Medium
A2=Sheet1!$A$2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30.0% | $8,400 | $70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35.0% | $9,800 | $81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15.0% | $4,200 | $35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8.0% | $2,240 | $18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12.0% | $3,360 | $28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30.0% | $28,500 | $63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35.0% | $33,250 | $73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15.0% | $14,250 | $31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8.0% | $7,600 | $16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12.0% | $11,400 | $25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30.0% | $5,550 | $92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35.0% | $6,475 | $107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15.0% | $2,775 | $46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8.0% | $1,480 | $24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12.0% | $2,220 | $37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30.0% | $21,600 | $72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35.0% | $25,200 | $84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15.0% | $10,800 | $36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8.0% | $5,760 | $19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12.0% | $8,640 | $28.80 | 12.0% |
Claude Code + Sheets MCP Opus 5.5 · Medium
A2=Sheet1!$A$2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400.00 | $70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800.00 | $81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200.00 | $35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240.00 | $18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360.00 | $28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500.00 | $63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250.00 | $73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250.00 | $31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600.00 | $16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400.00 | $25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550.00 | $92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475.00 | $107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775.00 | $46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480.00 | $24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220.00 | $37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600.00 | $72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200.00 | $84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800.00 | $36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760.00 | $19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640.00 | $28.80 | 12% |
Autosheet in Excel GPT-6.1 Sol · Medium
A2=INDEX(Sheet1!$A$2:$A$6,INT((ROW()-2)/5)+1)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400.00 | $70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800.00 | $81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200.00 | $35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240.00 | $18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360.00 | $28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500.00 | $63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250.00 | $73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250.00 | $31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600.00 | $16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400.00 | $25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550.00 | $92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475.00 | $107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775.00 | $46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480.00 | $24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220.00 | $37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600.00 | $72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200.00 | $84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800.00 | $36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760.00 | $19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640.00 | $28.80 | 12% |
Claude Code + Autosheet MCP Opus 5.5 · Medium
A2=INDEX(Sheet1!$A:$A, INT((ROW()-2)/5)+2)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400.00 | $70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800.00 | $81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200.00 | $35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240.00 | $18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360.00 | $28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500.00 | $63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250.00 | $73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250.00 | $31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600.00 | $16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400.00 | $25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550.00 | $92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475.00 | $107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775.00 | $46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480.00 | $24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220.00 | $37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600.00 | $72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200.00 | $84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800.00 | $36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760.00 | $19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640.00 | $28.80 | 12.0% |
ChatGPT + Autosheet MCP GPT-6 · Medium
A2=INDEX(Sheet1!$A:$A, 2 + INT((ROW() - 2) / 5))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400.00 | $70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800.00 | $81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200.00 | $35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240.00 | $18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360.00 | $28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500.00 | $63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250.00 | $73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250.00 | $31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600.00 | $16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400.00 | $25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550.00 | $92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475.00 | $107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775.00 | $46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480.00 | $24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220.00 | $37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600.00 | $72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200.00 | $84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800.00 | $36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760.00 | $19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640.00 | $28.80 | 12.0% |
Autosheet in Sheets Haiku 5.5 · High
A2=Sheet1!A2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400.00 | $70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800.00 | $81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200.00 | $35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240.00 | $18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360.00 | $28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500.00 | $63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250.00 | $73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250.00 | $31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600.00 | $16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400.00 | $25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550.00 | $92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475.00 | $107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775.00 | $46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480.00 | $24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220.00 | $37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600.00 | $72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200.00 | $84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800.00 | $36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760.00 | $19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640.00 | $28.80 | 12% |
ChatGPT in Excel GPT-6 Astra · Medium
A2=Sheet1!A2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | 8,400.00 | 70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | 9,800.00 | 81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | 4,200.00 | 35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | 2,240.00 | 18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | 3,360.00 | 28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | 28,500.00 | 63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | 33,250.00 | 73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | 14,250.00 | 31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | 7,600.00 | 16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | 11,400.00 | 25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | 5,550.00 | 92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | 6,475.00 | 107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | 2,775.00 | 46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | 1,480.00 | 24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | 2,220.00 | 37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | 21,600.00 | 72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | 25,200.00 | 84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | 10,800.00 | 36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | 5,760.00 | 19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | 8,640.00 | 28.80 | 12% |
Claude in Excel Haiku 5.5 · High
A2=Sheet1!$A$2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | 8,400 | 70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35% | 9,800 | 81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | 4,200 | 35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | 2,240 | 18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | 3,360 | 28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30% | 28,500 | 63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35% | 33,250 | 73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15% | 14,250 | 31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8% | 7,600 | 16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12% | 11,400 | 25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30% | 5,550 | 92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35% | 6,475 | 107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | 2,775 | 46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8% | 1,480 | 24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12% | 2,220 | 37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30% | 21,600 | 72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35% | 25,200 | 84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | 10,800 | 36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8% | 5,760 | 19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12% | 8,640 | 28.80 | 12.0% |
Claude in Sheets Haiku 5.5 · High
A2=Sheet1!$A$2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400 | $70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800 | $81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200 | $35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240 | $18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360 | $28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500 | $63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250 | $73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250 | $31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600 | $16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400 | $25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550 | $92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475 | $107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775 | $46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480 | $24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220 | $37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600 | $72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200 | $84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800 | $36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760 | $19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640 | $28.80 | 12.0% |
Autosheet in Excel GPT-6 Luna · High
D2=XLOOKUP(A2,Sheet1!$A$2:$A$6,Sheet1!$E$2:$E$6)*C2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | 8,400.00 | 70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | 9,800.00 | 81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | 4,200.00 | 35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | 2,240.00 | 18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | 3,360.00 | 28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | 28,500.00 | 63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | 33,250.00 | 73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | 14,250.00 | 31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | 7,600.00 | 16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | 11,400.00 | 25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | 5,550.00 | 92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | 6,475.00 | 107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | 2,775.00 | 46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | 1,480.00 | 24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | 2,220.00 | 37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | 21,600.00 | 72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | 25,200.00 | 84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | 10,800.00 | 36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | 5,760.00 | 19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | 8,640.00 | 28.80 | 12% |
Copilot in Excel Auto
D2=C2*XLOOKUP(A2,Sheet1!$A$2:$A$6,Sheet1!$E$2:$E$6)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | €8,400.00 | €70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | €9,800.00 | €81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | €4,200.00 | €35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | €2,240.00 | €18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | €3,360.00 | €28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | €28,500.00 | €63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | €33,250.00 | €73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | €14,250.00 | €31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | €7,600.00 | €16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | €11,400.00 | €25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | €5,550.00 | €92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | €6,475.00 | €107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | €2,775.00 | €46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | €1,480.00 | €24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | €2,220.00 | €37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | €21,600.00 | €72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | €25,200.00 | €84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | €10,800.00 | €36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | €5,760.00 | €19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | €8,640.00 | €28.80 | 12% |
ChatGPT + Drive MCP GPT-6 · Medium
A2=Sheet1!A2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | 8,400.00 | 70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | 9,800.00 | 81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | 4,200.00 | 35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | 2,240.00 | 18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | 3,360.00 | 28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | 28,500.00 | 63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | 33,250.00 | 73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | 14,250.00 | 31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | 7,600.00 | 16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | 11,400.00 | 25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | 5,550.00 | 92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | 6,475.00 | 107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | 2,775.00 | 46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | 1,480.00 | 24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | 2,220.00 | 37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | 21,600.00 | 72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | 25,200.00 | 84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | 10,800.00 | 36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | 5,760.00 | 19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | 8,640.00 | 28.80 | 12% |
ChatGPT in Excel GPT-6 Luna · High
A2=Sheet1!A2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | €8,400 | €70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | €9,800 | €81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | €4,200 | €35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | €2,240 | €18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | €3,360 | €28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | €28,500 | €63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | €33,250 | €73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | €14,250 | €31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | €7,600 | €16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | €11,400 | €25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | €5,550 | €92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | €6,475 | €107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | €2,775 | €46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | €1,480 | €24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | €2,220 | €37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | €21,600 | €72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | €25,200 | €84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | €10,800 | €36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | €5,760 | €19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | €8,640 | €28.80 | 12% |
ChatGPT in Sheets GPT-6 Astra · Medium
A2=Sheet1!$A$2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | 8,400.00 | 70.00 | 30% |
| 3 | Q1 Sales Kickoff | Catering | 35% | 9,800.00 | 81.67 | 35% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | 4,200.00 | 35.00 | 15% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | 2,240.00 | 18.67 | 8% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | 3,360.00 | 28.00 | 12% |
| 7 | Annual Tech Summit | Venue | 30% | 28,500.00 | 63.33 | 30% |
| 8 | Annual Tech Summit | Catering | 35% | 33,250.00 | 73.89 | 35% |
| 9 | Annual Tech Summit | AV Equipment | 15% | 14,250.00 | 31.67 | 15% |
| 10 | Annual Tech Summit | Decorations | 8% | 7,600.00 | 16.89 | 8% |
| 11 | Annual Tech Summit | Staffing | 12% | 11,400.00 | 25.33 | 12% |
| 12 | Team Offsite Retreat | Venue | 30% | 5,550.00 | 92.50 | 30% |
| 13 | Team Offsite Retreat | Catering | 35% | 6,475.00 | 107.92 | 35% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | 2,775.00 | 46.25 | 15% |
| 15 | Team Offsite Retreat | Decorations | 8% | 1,480.00 | 24.67 | 8% |
| 16 | Team Offsite Retreat | Staffing | 12% | 2,220.00 | 37.00 | 12% |
| 17 | Customer Appreciation Gala | Venue | 30% | 21,600.00 | 72.00 | 30% |
| 18 | Customer Appreciation Gala | Catering | 35% | 25,200.00 | 84.00 | 35% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | 10,800.00 | 36.00 | 15% |
| 20 | Customer Appreciation Gala | Decorations | 8% | 5,760.00 | 19.20 | 8% |
| 21 | Customer Appreciation Gala | Staffing | 12% | 8,640.00 | 28.80 | 12% |
ChatGPT in Sheets GPT-6 Luna · High
A2=Sheet1!A2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400.00 | $70.00 | 30.0% |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800.00 | $81.67 | 35.0% |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200.00 | $35.00 | 15.0% |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240.00 | $18.67 | 8.0% |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360.00 | $28.00 | 12.0% |
| 7 | Annual Tech Summit | Venue | 30% | $28,500.00 | $63.33 | 30.0% |
| 8 | Annual Tech Summit | Catering | 35% | $33,250.00 | $73.89 | 35.0% |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250.00 | $31.67 | 15.0% |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600.00 | $16.89 | 8.0% |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400.00 | $25.33 | 12.0% |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550.00 | $92.50 | 30.0% |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475.00 | $107.92 | 35.0% |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775.00 | $46.25 | 15.0% |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480.00 | $24.67 | 8.0% |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220.00 | $37.00 | 12.0% |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600.00 | $72.00 | 30.0% |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200.00 | $84.00 | 35.0% |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800.00 | $36.00 | 15.0% |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760.00 | $19.20 | 8.0% |
| 21 | Customer Appreciation Gala | Staffing | 12% | $8,640.00 | $28.80 | 12.0% |
Failed 1
Gemini in Sheets Auto
A2=Sheet1!A2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Event Name | Line Item | Allocation % | Estimated Cost | Cost per Person | % of Event Budget |
| 2 | Q1 Sales Kickoff | Venue | 30% | $8,400 | $70.00 | |
| 3 | Q1 Sales Kickoff | Catering | 35% | $9,800 | $81.67 | |
| 4 | Q1 Sales Kickoff | AV Equipment | 15% | $4,200 | $35.00 | |
| 5 | Q1 Sales Kickoff | Decorations | 8% | $2,240 | $18.67 | |
| 6 | Q1 Sales Kickoff | Staffing | 12% | $3,360 | $28.00 | |
| 7 | Annual Tech Summit | Venue | 30% | $28,500 | $63.33 | |
| 8 | Annual Tech Summit | Catering | 35% | $33,250 | $73.89 | |
| 9 | Annual Tech Summit | AV Equipment | 15% | $14,250 | $31.67 | |
| 10 | Annual Tech Summit | Decorations | 8% | $7,600 | $16.89 | |
| 11 | Annual Tech Summit | Staffing | 12% | $11,400 | $25.33 | |
| 12 | Team Offsite Retreat | Venue | 30% | $5,550 | $92.50 | |
| 13 | Team Offsite Retreat | Catering | 35% | $6,475 | $107.92 | |
| 14 | Team Offsite Retreat | AV Equipment | 15% | $2,775 | $46.25 | |
| 15 | Team Offsite Retreat | Decorations | 8% | $1,480 | $24.67 | |
| 16 | Team Offsite Retreat | Staffing | 12% | $2,220 | $37.00 | |
| 17 | Customer Appreciation Gala | Venue | 30% | $21,600 | $72.00 | |
| 18 | Customer Appreciation Gala | Catering | 35% | $25,200 | $84.00 | |
| 19 | Customer Appreciation Gala | AV Equipment | 15% | $10,800 | $36.00 | |
| 20 | Customer Appreciation Gala | Decorations | 8% | $5,760 | $19.20 | |
| 21 | Customer Appreciation Gala | Staffing | 12% | $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.