A model is not a diary. A model is a simulator.
Sheet Kapesne already has days, income, spending, left, levers F1/F2. Today you put together three stories of one table: a normal week, a week with ice cream, a saving week. The same structure, different inputs — a different balance.
The Modeller answers a parent’s questions: “What if you spend 30% more?”
Three scenarios — one model
-
Column H
Model spending=C2*$F$2. Column IAfter reserve=H2*(1+$F$1)or according to your reserve model from the dollar lesson. I10 or D8 = balance at the end of the week — the target number. -
Scenario A Normal: F1=0.1, F2=1. Write I10 into table J1:K5 (column J name, K result).
-
Scenario B Ice cream: F2=1.35 (or raise only C5 by 40 Kč and F2=1). Write the new I10. Difference against A in column L:
=K2-K3. -
Scenario C Saving: F2=0.75 or lower column C by 20%. Write I10.
-
For each scenario a sentence on
Poznamky: “With ice cream I finish with X Kč, Y less than normally.” Y from the difference, not by eye.
Change either F2 or a specific day C5 — not both at once, until you want a complex scenario. Otherwise you do not know what caused what.
A link with the data table
When you have a data table F2 vs. I10, Ice cream point = F2=1.35. Saving point = 0.75. The same numbers — a different presentation (a story vs. a grid).
What often goes wrong
A hardcoded result in K. K must be a link or written after switching F2 — not an old number.
Forgotten return F2=1. You hand in an ice-cream week as normal.
A sentence without a number. “I will spend more” — how much? K and L.
🏫 Grade average — a parallel
“What if the three from English was a two?” B4=2, watch B8. The same scenario logic, a different sheet.
💰 Pocket money — the main lesson
Three scenarios, table J:K, differences L, three sentences. That is the core of the Modeller with money.
📊 Class survey — not money
Scenario “5 people change their vote” — a copy of E, not F2. A separate Poznamky sheet.
🏆 Mini dashboard — normal
The dashboard shows the real week F2=1. Scenarios in table J — for parents in a home talk, not for the class.
Now you 💪
First: three scenarios in J:K with I10 numbers.
Second: three sentences with concrete Kč differences.
Check: Normal scenario restored. Differences calculated. Model H/I reacts to F2.
What to take from this lesson
- A scenario = the same model, different levers or days.
- Table J:K + differences + sentences = a clear “what if”.
- After the exercise put normal F2 back.
© 2026 Ing. Martin Polak / AlgoRhino · コンテンツ利用規約