The Modeller does not calculate for calculating. It calculates for a decision.
You can XLOOKUP both ways, percent change, scenario manager, data tables, three pocket-money stories, linking sheets Prehled and a model audit. That is the skeleton of a table that answers “what if” without a pencil.
Today a final check of the model and preparation for the dashboard.
Modeller check list
| Lesson | Can you? |
|---|---|
| XLOOKUP + a missing value | ☐ |
| Percent change and share | ☐ |
| Scenarios F1/F2 + table J | ☐ |
| 1D data table (F2) | ☐ |
| 2D grid or 3×3 by hand | ☐ |
| Three pocket-money scenarios + sentences | ☐ |
| Prehled with links | ☐ |
| Model audit | ☐ |
Final state of the model
-
Ciselnik — subject codes, survey mapping if needed.
-
Kapesne — F1, F2, H model, scenarios J:K, data table or grid, I10 formula.
-
Prehled — B1 average, B2 spending, B3/B4 survey. Formats.
-
Run the audit from the last lesson. F2=1 after all tests.
-
PDF of sheets
Kapesne+Prehledfor parents — “this is how the model works”.
Certificate: the whole Modeller level? In Certificates print the Modeller diploma 📐 — you can build tables that recalculate.
What you hand to the Workbook boss
Prehled → Dashboard. Links =Znamky!B8, not copies. Scenarios stay on Kapesne. The grades chart from Chart maker comes onto the Dashboard as a picture or a linked chart.
The Modeller delivered logic. The Boss delivers presentation and sharing.
🏫 Grade average — a link
One average B8. Prehled and later Dashboard only show.
💰 Pocket money — a complete model
F1/F2, scenarios, grid, audit. Reality C separated from model H.
📊 Class survey — summary
D:E COUNTIF, shares, a link to Prehled.
🏆 Mini dashboard — Prehled done
Prehled is the Dashboard blueprint. After the Modeller you have numbers — the Boss will format them and add a chart.
Now you 💪
- Tick off the checklist.
- Audit without errors.
- One sentence to a parent: “When F2=1.3, I finish with ___ Kč.”
Check: You are a Modeller — the model reacts, scenarios make sense, Prehled lives. 🎉
What to take from this lesson
- Modeller = formulas + scenarios + linking + audit.
- Prehled ready for the Dashboard.
- Modeller certificate after finishing the checklist.
© 2026 Ing. Martin Polak / AlgoRhino · Content usage terms