Pocket money — income and spend · البرمجة مع مارتن

The pocket money project — now it counts

Sheet Pocket already has days and headings. Today you add formulas like in Formula kid: a daily difference, week totals, maybe an average.

Income = column B In. Spend = C Spent. Left = D.

💡

Daily vs a running till. Daily: =B2-C2 — only that day. Running: =D2+B3-C3 from Wednesday — it remembers yesterday. The course uses daily as the base. Running is a bonus from the copying lesson.

Fill numbers (or leave the sample)

Day	B In	C Spent
Mon	50	20
Tue	0	15
Wed	20	0
Thu	0	30
Fri	0	10
Sat	100	40
Sun	0	0

The left formula — one, drag

D2 =B2-C2. Enter. 30 for Monday.
The square of D2 to D8. Seven results. D3 −15 for Tuesday — fine.
Click D5. It must be =B5-C5, not still B2.

Totals under the week

A10 Total in, B10 =SUM(B2:B8).
A11 Total spent, B11 =SUM(C2:C8).
A12 Week difference, B12 =B10-B11 or =SUM(D2:D8) with the daily version.

With the sample numbers: in 170, spent 115, difference 55.

Average daily spend

A13 Average spend/day, B13 =AVERAGE(C2:C8).

Zeros on Tuesday and Thursday count — an average across seven days.

⚠️

Text in B or C. #VALUE! in column D. Fix to a number. Do not type a koruna into the cell — a bare number for now.

Link the dashboard

Dashboard B4 =SUM(Pocket!B2:B8) or the difference =Pocket!B12 if B12 already counts the week.

🏫 Grade average

One sheet, two columns: subject and grade. At the bottom a sum and an average.

💰 Pocket money

Rows = days, columns = income / spend / left.

📊 Class survey

One question, answers in one column, later a chart.

🏆 Mini dashboard

Three numbers at the top and one chart. Numbers as a link, not copied by hand.

Now you 💪

Column D has seven formulas from one =B2-C2.
Under the table a sum of income, a sum of spend, a difference.
A change of spend on Wednesday changes D4 and B11/B12.
No #VALUE! — B and C are numbers.
The Dashboard shows at least one number from Pocket via Pocket!.

✅

Check: Pocket money is a live project with formulas, not left typed by hand.

What to take from this lesson

D = B − C, copied for the week.
SUM under the table = total income/spend.
Minus = you spent more than came in that day.
An average of spend counts zero days too.
The Dashboard points at sheet Pocket.