Track what's left of a budget
FormulasEasyDeterministic scoringLatest run
Passed by 11 of 12 products on their best model. Failed: Autosheet in Sheets.
Prompt
Use formulas in D4:D18 to calculate Remaining as Budgeted minus Spent.
Use formulas in E4:E18 for Status: Over when spending exceeds budget, On Track when it is within 10% of budget, and Under otherwise.
Add a summary in G1:H3 for total budgeted, total spent, and overall remaining, with the values calculated by formulas in H1:H3.
Starting spreadsheet
Sheet1| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker — Enter your budgeted and actual spending in the columns below. Remaining and Status will be calculated automaticall… | ||||
| 2 | |||||
| 3 | Category | Budgeted | Spent | Remaining | Status |
| 4 | Rent | 1800 | 1800 | ||
| 5 | Groceries | 400 | 387 | ||
| 6 | Dining Out | 150 | 214 | ||
| 7 | Utilities | 120 | 108 | ||
| 8 | Transportation | 200 | 195 | ||
| 9 | Phone | 80 | 80 | ||
| 10 | Internet | 60 | 60 | ||
| 11 | Streaming Services | 40 | 52 | ||
| 12 | Gym Membership | 50 | 50 | ||
| 13 | Clothing | 100 | 143 | ||
| 14 | Healthcare | 75 | 29 | ||
| 15 | Personal Care | 60 | 68 | ||
| 16 | Entertainment | 80 | 35 | ||
| 17 | Savings | 500 | 500 | ||
| 18 | Pet Expenses | 90 | 112 |
A passing output
Autosheet in Excel · Opus 5.5H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3,805 | |||||
| 2 | Total Spent | 3,833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | (28) | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Pass criteria
All must be met, checked automatically.H1:H3andD4:E18hold the expected valuesD4:E18andH1:H3use formulas
Passed 21
Autosheet in Excel Opus 5.5 · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3,805 | |||||
| 2 | Total Spent | 3,833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | (28) | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Autosheet in Excel GPT-6 Astra · Low
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | $3,805.00 | |||||
| 2 | Total Spent | $3,833.00 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -$28.00 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Autosheet in Excel Sonnet 5.5 · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3,805 | |||||
| 2 | Total Spent | 3,833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Claude in Excel Opus 5.5 · High
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | On Track band (% of budget) | 10% | |
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Autosheet in Excel Haiku 5.5 · High
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Claude in Sheets Opus 5.5 · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3,805 | |||||
| 2 | On Track band (within % of budget) | 10% | Total Spent | 3,833 | ||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | (28) | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Claude Code + Sheets MCP Opus 5.5 · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Autosheet in Excel GPT-6.1 Sol · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | $3,805.00 | |||||
| 2 | Total Spent | $3,833.00 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -$28.00 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Claude Code + Autosheet MCP Opus 5.5 · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
ChatGPT + Autosheet MCP GPT-6 · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Autosheet in Sheets Haiku 5.5 · High
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
ChatGPT in Excel GPT-6 Astra · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Claude in Excel Haiku 5.5 · High
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | On Track threshold | 10% | |
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Claude in Sheets Haiku 5.5 · High
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | On Track Threshold | ||
| 7 | Utilities | 120 | 108 | 12 | On Track | 10% | ||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Autosheet in Excel GPT-6 Luna · High
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total budgeted | 3805 | |||||
| 2 | Total spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Copilot in Excel Auto
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3,805.00 | |||||
| 2 | Total Spent | 3,833.00 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28.00 | |
| 4 | Rent | 1800 | 1800 | 0.00 | On Track | |||
| 5 | Groceries | 400 | 387 | 13.00 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64.00 | Over | |||
| 7 | Utilities | 120 | 108 | 12.00 | On Track | |||
| 8 | Transportation | 200 | 195 | 5.00 | On Track | |||
| 9 | Phone | 80 | 80 | 0.00 | On Track | |||
| 10 | Internet | 60 | 60 | 0.00 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12.00 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0.00 | On Track | |||
| 13 | Clothing | 100 | 143 | -43.00 | Over | |||
| 14 | Healthcare | 75 | 29 | 46.00 | Under | |||
| 15 | Personal Care | 60 | 68 | -8.00 | Over | |||
| 16 | Entertainment | 80 | 35 | 45.00 | Under | |||
| 17 | Savings | 500 | 500 | 0.00 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22.00 | Over |
ChatGPT + Drive MCP GPT-6 · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
ChatGPT in Excel GPT-6 Luna · High
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Gemini in Sheets Auto
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
ChatGPT in Sheets GPT-6 Astra · Medium
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
ChatGPT in Sheets GPT-6 Luna · High
H1=SUM(B4:B18)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | Total Budgeted | 3805 | |||||
| 2 | Total Spent | 3833 | ||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | Overall Remaining | -28 | |
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Failed 1
Autosheet in Sheets Opus 5.5 · Medium
D4=B4-C4
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget Tracker … | |||||||
| 2 | ||||||||
| 3 | Category | Budgeted | Spent | Remaining | Status | |||
| 4 | Rent | 1800 | 1800 | 0 | On Track | |||
| 5 | Groceries | 400 | 387 | 13 | On Track | |||
| 6 | Dining Out | 150 | 214 | -64 | Over | |||
| 7 | Utilities | 120 | 108 | 12 | On Track | |||
| 8 | Transportation | 200 | 195 | 5 | On Track | |||
| 9 | Phone | 80 | 80 | 0 | On Track | |||
| 10 | Internet | 60 | 60 | 0 | On Track | |||
| 11 | Streaming Services | 40 | 52 | -12 | Over | |||
| 12 | Gym Membership | 50 | 50 | 0 | On Track | |||
| 13 | Clothing | 100 | 143 | -43 | Over | |||
| 14 | Healthcare | 75 | 29 | 46 | Under | |||
| 15 | Personal Care | 60 | 68 | -8 | Over | |||
| 16 | Entertainment | 80 | 35 | 45 | Under | |||
| 17 | Savings | 500 | 500 | 0 | On Track | |||
| 18 | Pet Expenses | 90 | 112 | -22 | Over |
Why it failed: Still working at the 5-minute time limit. 3 cells are wrong, such as H1: empty instead of 3,805. H1:H3 hold no formula.