Compute budget variances and totals
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
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| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | ||
| 3 | Rent | 24000 | 24000 | ||
| 4 | Marketing | 15000 | 11350 | ||
| 5 | Software Subscriptions | 8400 | 9120 | ||
| 6 | Office Supplies | 3200 | 2870 | ||
| 7 | Travel & Expenses | 12000 | 14580 | ||
| 8 | Utilities | 4800 | 4650 | ||
| 9 | Insurance | 6500 | 6500 | ||
| 10 | Training & Development | 5000 | 3200 | ||
| 11 | Legal & Compliance | 7500 | 8900 | ||
| 12 | Equipment Maintenance | 4200 | 3750 | ||
| 13 | Miscellaneous | 2500 | 3140 |
A passing output
Autosheet in Excel · Opus 5.5D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3,650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1,800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2,160 | 1.2% |
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.D2:D14,E2:E13andB14:C14hold the expected valuesD2:E13andB14:D14use formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
Passed23s · 7¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3,650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1,800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2,160 | 1.2% |
Autosheet in Excel GPT-6 Astra · Low
Passed19s · 14¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 3.76% |
| 3 | Rent | 24000 | 24000 | 0 | 0.00% |
| 4 | Marketing | 15000 | 11350 | -3650 | -24.33% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.57% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.31% |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 21.50% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.12% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.00% |
| 10 | Training & Development | 5000 | 3200 | -1800 | -36.00% |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 18.67% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.71% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.60% |
| 14 | Total | 178,100.00 | 180,260.00 | 2,160.00 |
Autosheet in Sheets Opus 5.5 · Medium
Passed27s · 8¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3,650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1,800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178,100 | 180,260 | 2,160 | 1.2% |
Autosheet in Excel Sonnet 5.5 · Medium
Passed12s · 4¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3,650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1,800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178,100 | 180,260 | 2,160 | 1.2% |
Claude in Excel Opus 5.5 · High
Passed22s · 17¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | - | - |
| 4 | Marketing | 15000 | 11350 | (3,650) | (24.3%) |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | (330) | (10.3%) |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | (150) | (3.1%) |
| 9 | Insurance | 6500 | 6500 | - | - |
| 10 | Training & Development | 5000 | 3200 | (1,800) | (36.0%) |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | (450) | (10.7%) |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178,100 | 180,260 | 2,160 | 1.2% |
Autosheet in Excel Haiku 5.5 · High
Passed15s · 0.3¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3,650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1,800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178,100 | 180,260 | 2,160 |
Claude in Sheets Opus 5.5 · Medium
Passed49s · 12¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | - | - |
| 4 | Marketing | 15000 | 11350 | (3,650) | (24.3%) |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | (330) | (10.3%) |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | (150) | (3.1%) |
| 9 | Insurance | 6500 | 6500 | - | - |
| 10 | Training & Development | 5000 | 3200 | (1,800) | (36.0%) |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | (450) | (10.7%) |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2,160 | 1.2% |
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed43s · N/A
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2160 |
Autosheet in Excel GPT-6.1 Sol · Medium
Passed27s · 5¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200.00 | 3.76% |
| 3 | Rent | 24000 | 24000 | 0.00 | 0.00% |
| 4 | Marketing | 15000 | 11350 | -3,650.00 | -24.33% |
| 5 | Software Subscriptions | 8400 | 9120 | 720.00 | 8.57% |
| 6 | Office Supplies | 3200 | 2870 | -330.00 | -10.31% |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580.00 | 21.50% |
| 8 | Utilities | 4800 | 4650 | -150.00 | -3.13% |
| 9 | Insurance | 6500 | 6500 | 0.00 | 0.00% |
| 10 | Training & Development | 5000 | 3200 | -1,800.00 | -36.00% |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400.00 | 18.67% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450.00 | -10.71% |
| 13 | Miscellaneous | 2500 | 3140 | 640.00 | 25.60% |
| 14 | Total | 178,100.00 | 180,260.00 | 2,160.00 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed2m 2s · N/A
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2160 | 1.2% |
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed1m 8s · N/A
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2160 | 1.2% |
Autosheet in Sheets Haiku 5.5 · High
Passed44s · 0.3¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2160 | 1.2% |
ChatGPT in Excel GPT-6 Astra · Medium
Passed21s · 75¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2160 |
Claude in Excel Haiku 5.5 · High
Passed16s · 0.7¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | - | - |
| 4 | Marketing | 15000 | 11350 | (3,650) | (24.3%) |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | (330) | (10.3%) |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | (150) | (3.1%) |
| 9 | Insurance | 6500 | 6500 | - | - |
| 10 | Training & Development | 5000 | 3200 | (1,800) | (36.0%) |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | (450) | (10.7%) |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178,100 | 180,260 | 2,160 |
Claude in Sheets Haiku 5.5 · High
Passed38s · 2¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | - | - |
| 4 | Marketing | 15000 | 11350 | (3,650) | (24.3%) |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | (330) | (10.3%) |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | (150) | (3.1%) |
| 9 | Insurance | 6500 | 6500 | - | - |
| 10 | Training & Development | 5000 | 3200 | (1,800) | (36.0%) |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | (450) | (10.7%) |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178,100 | 180,260 | 2,160 | 1.2% |
Autosheet in Excel GPT-6 Luna · High
Passed14s · 0.3¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 0.037647059 |
| 3 | Rent | 24000 | 24000 | 0 | 0 |
| 4 | Marketing | 15000 | 11350 | -3650 | -0.243333333 |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 0.085714286 |
| 6 | Office Supplies | 3200 | 2870 | -330 | -0.103125 |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 0.215 |
| 8 | Utilities | 4800 | 4650 | -150 | -0.03125 |
| 9 | Insurance | 6500 | 6500 | 0 | 0 |
| 10 | Training & Development | 5000 | 3200 | -1800 | -0.36 |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 0.186666667 |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -0.107142857 |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 0.256 |
| 14 | Total | 178100 | 180260 | 2160 |
Copilot in Excel Auto
Passed42s · N/A
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3,650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1,800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178,100 | 180,260 | 2,160 |
ChatGPT + Drive MCP GPT-6 · Medium
Passed1m 5s · N/A
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 3.76% |
| 3 | Rent | 24000 | 24000 | 0 | 0.00% |
| 4 | Marketing | 15000 | 11350 | -3650 | -24.33% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.57% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.31% |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 21.50% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.12% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.00% |
| 10 | Training & Development | 5000 | 3200 | -1800 | -36.00% |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 18.67% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.71% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.60% |
| 14 | Total | 178100 | 180260 | 2160 |
ChatGPT in Excel GPT-6 Luna · High
Passed26s · 0.8¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 0.037647059 |
| 3 | Rent | 24000 | 24000 | 0 | 0 |
| 4 | Marketing | 15000 | 11350 | -3650 | -0.243333333 |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 0.085714286 |
| 6 | Office Supplies | 3200 | 2870 | -330 | -0.103125 |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 0.215 |
| 8 | Utilities | 4800 | 4650 | -150 | -0.03125 |
| 9 | Insurance | 6500 | 6500 | 0 | 0 |
| 10 | Training & Development | 5000 | 3200 | -1800 | -0.36 |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 0.186666667 |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -0.107142857 |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 0.256 |
| 14 | Total | 178100 | 180260 | 2160 |
Gemini in Sheets Auto
Passed3m 25s · N/A
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3,200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3,650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2,580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1,800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1,400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178,100 | 180,260 | 2,160 | 1.2% |
ChatGPT in Sheets GPT-6 Astra · Medium
Passed44s · 67¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 3.8% |
| 3 | Rent | 24000 | 24000 | 0 | 0.0% |
| 4 | Marketing | 15000 | 11350 | -3650 | -24.3% |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 8.6% |
| 6 | Office Supplies | 3200 | 2870 | -330 | -10.3% |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 21.5% |
| 8 | Utilities | 4800 | 4650 | -150 | -3.1% |
| 9 | Insurance | 6500 | 6500 | 0 | 0.0% |
| 10 | Training & Development | 5000 | 3200 | -1800 | -36.0% |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 18.7% |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -10.7% |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 25.6% |
| 14 | Total | 178100 | 180260 | 2160 |
ChatGPT in Sheets GPT-6 Luna · High
Passed34s · 0.6¢
D2=C2-B2
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Budget | Actual | Variance | Variance% |
| 2 | Salaries | 85000 | 88200 | 3200 | 0.037647059 |
| 3 | Rent | 24000 | 24000 | 0 | 0 |
| 4 | Marketing | 15000 | 11350 | -3650 | -0.243333333 |
| 5 | Software Subscriptions | 8400 | 9120 | 720 | 0.085714286 |
| 6 | Office Supplies | 3200 | 2870 | -330 | -0.103125 |
| 7 | Travel & Expenses | 12000 | 14580 | 2580 | 0.215 |
| 8 | Utilities | 4800 | 4650 | -150 | -0.03125 |
| 9 | Insurance | 6500 | 6500 | 0 | 0 |
| 10 | Training & Development | 5000 | 3200 | -1800 | -0.36 |
| 11 | Legal & Compliance | 7500 | 8900 | 1400 | 0.186666667 |
| 12 | Equipment Maintenance | 4200 | 3750 | -450 | -0.107142857 |
| 13 | Miscellaneous | 2500 | 3140 | 640 | 0.256 |
| 14 | Total | 178100 | 180260 | 2160 |