Two levers at once
Reserve F1 and spending multiplier F2 together decide how much is left. A data table with two variables (Excel) fills a grid: rows = F1, columns = F2, cells = I10.
Sheets does not have this natively like Excel — you make a handmade grid or a smaller 3×3 table. The idea: see combinations, not one.
Grid F1 × F2
-
Kapesne: F1 reserve 0.1, F2 multiplier 1. Spending model H =C2*$F$2, reserve from H or from C — according to your model from the dollar address. I10 = final balance. -
Excel: top row K10:M10 = F2 (1; 1.2; 1.4). Left column J11:J13 = F1 (0; 0.1; 0.2). Top left corner J10 empty. J11
=I10. -
Select J10:M13. Data → What-if → Data table. Row input cell:
$F$1. Column input cell:$F$2. -
The grid shows nine balances. Where is it red (conditional formatting <0)? There the model falls.
-
Sheets: 3×3 by hand — set F1 and F2, write I10 into a grid cell, repeat nine times. Or a smaller 2×2 for tired fingers. Important: you understand that each cell = a different combination of levers.
Two variables = the number of combinations grows fast. 5×5 = 25 cells. 시작 with 3×3. The Modeller does not need the whole universe — they need a direction (is more F2 worse than more F1?).
Conditional formatting on the grid
Select the result grid. Conditional: cell < 0 → red. At a glance a “safe zone” — combination F1=0.2 and F2=1.
What often goes wrong
F1 and F2 swapped in the input cells. Rows vs. columns — check one known combination.
I10 does not depend on both. When F1 changes nothing in the model, the second dimension lies.
A grid that is too big. 시작 small. 복사ing mistakes.
🏫 Grade average — not 2D
Grades are not two levers F1/F2. A 2D data table is for pocket money and money scenarios.
💰 Pocket money — the core of the lesson
F1 × F2 → I10. Find the worst combination. Scenario “Ice cream” = one point in the grid, not the whole table.
📊 Class survey — out
The survey does not have two model levers. 2D table = pocket money.
🏆 Mini dashboard — one point
Dashboard = current F1, F2. The grid stays on Kapesne for deciding at home.
Now you 💪
First: a grid at least 3×3 (Excel auto or by hand in Sheets).
Second: conditional formatting <0 on the grid. Which cell is the worst?
Check: Nine (or more) combinations give different I10. Red cells make sense. F1 and F2 assigned correctly.
What to take from this lesson
- 2D data table = F1 on rows, F2 in columns, in the middle the result.
- 시작 with a small grid. Colour the minuses.
- Sheets: a handmade grid teaches the same logic as Excel.
© 2026 Ing. Martin Polak / AlgoRhino · 콘텐츠 이용 약관