Mini dashboard · Martinとコード

One screen, not a museum

A dashboard is a sheet you look at and you know the state. Three numbers and one chart. When you put everything there, it is not a dashboard — it is a dump.

The teacher, mum and you in a month have ten seconds. Grade average. Total spending. Maximum. Chart. Done. Let raw survey rows stay on their sheet.

Numbers on the dashboard are not calculated from scratch again. You do not say =PRŮMĚR(Znamky!B2:B6) again when the average already lives in B8. You link to the cell where the truth already is.

A link to another sheet looks like this:

=Znamky!B8
=Kapesne!D8

Read: go to sheet Znamky, take B8. The exclamation mark is a door between sheets. Do not put a full stop there. Spaces in a sheet name would want apostrophes — that is why sheets are called Znamky, not My grades.

(Fix the addresses according to where you have the average and the balance. If the average is in B9, link B9.)

Build three numbers and a chart

Down +. A new sheet. Rename to Dashboard. In A1 write Workbook status and make it bold. That is a sign, not a formula.
In A3 Grade average. In B3 click, write =, then at the bottom click the Znamky tab and tap the cell with the average (say B8). Enter. The table writes =Znamky!B8 itself. Fewer typos.
In A4 Total spending. In B4 a link to SUM from Kapesne by the same clicking. Say =Kapesne!C10, if the total lives in C10.
In A5 Maximum spending. Here you can put a link to a ready maximum, or one function:
```
=MAX(Kapesne!C2:C8)
```
In Czech sometimes =MAX.HODNOTA(Kapesne!C2:C8). English MAX. If #NÁZEV?, try the other language. Let the range not reach the label Total.
Format: B3 a number with one decimal. B4 and B5 currency. Once they are on one screen, the format says what is what.
Chart from Znamky: click the chart → three dots → コピー chart. Tab Dashboard, Ctrl+V (on a Mac Cmd+V). In Excel Ctrl+C on the chart and Ctrl+V on the dashboard. The chart still looks at Znamky. You change a grade — the bar on the dashboard goes up.

💡

When a link shows 0 or #REF!, the sheet or cell has a different name. #REF! = “that address is gone”. You deleted a sheet, or a row. Click into the formula, delete it and tap the right cell with the mouse — the address rewrites. Do not type Znamky!B8 from your head when you are not sure.

What you should see on one screen

Without scrolling, at the top:

A3 Grade average — B3 say 1.8
A4 Total spending — B4 say 95.00 Kč
A5 Maximum spending — B5 say 40.00 Kč
next to it or under it the chart Grades — March

Click B3. At the top =Znamky!B8 (or your cell).
Click B4. At the top =Kapesne!….
Click B5. At the top =MAX(...) or a link.

If B3 shows #REF!, sheet Znamky is not called Znamky. At the bottom at the tabs read the name. Rename, or click the formula again.

If B3 shows #NÁZEV?, a typo in the sheet name. Znamky and Známky is a different sheet for the table.

If B4 shows 0 and on Kapesne the total is not zero, you are linking to an empty cell. Tap the one where SUM really lives.

What should be on the dashboard and what should not

Yes: three numbers with labels, one chart with a human title, maybe two levers F1/F2 as a link, when you want to show them.

No: twenty survey rows. Seven pocket-money days. The whole lookup list. A second chart “just in case”. Numbers 1.8 copied by hand without an equals sign.

A handmade number on the dashboard gets old. A link recalculates. When you click B3 and in the formula bar is 1.8 without =, it is not a dashboard. It is paper.

⚠️

Do not copy a cell as a value (Ctrl+Shift+V / “values only”). That tears the link and a dead number stays on the dashboard. コピー the chart. Write numbers as =Sheet!Cell.

The link must live

A test without which you do not trust the dashboard:

Remember the number in B3 on Dashboard.
Go to Znamky, change one grade by one step.
Come back to Dashboard. B3 must change. The chart too.
You can put the grade back. What matters is that you did not touch the dashboard and it moved.

If it does not move, B3 is not a link, or it points at a different cell than the average. Open the formula and tap again.

The same test for B4: change one spending on Kapesne. The total on the dashboard must move.

🏆 Mini dashboard — project finale

Three numbers at the top, one chart, no raw survey rows. Raw data stays on Znamky, Kapesne and the survey sheet. The class and the teacher see only Dashboard. When you hand in, you download a PDF of exactly this sheet. Leave reserve levers on Kapesne, or link them here with one row — but do not copy the whole table of days.

Now you 💪

First: sheet Dashboard, three links, one copied chart. Format: average as a number, money as currency.

Second: change a grade on Znamky. The number on the dashboard must change without editing the dashboard. Then change a spending. The second number too. If you can change some number only by rewriting it on the dashboard, it is not a link — fix it.

If #REF!, do not panic. Delete the formula, click =, tap the right cell.

A third check when you have levers: on Kapesne change F1. If you put a link on the dashboard to the reserve or to a total that lives from the reserve, the number must move. The dashboard still owns nothing. It only shows.

✅

Check: The dashboard rewrites nothing by hand. It only shows. In the formula bar at B3, B4, B5 =OtherSheet!… lights up. The chart still has a human title.

What to take from this lesson

Three numbers + a chart. Nothing more. Data lives on its sheets.
Links =Znamky!B8, not copies of values. #REF! = a wrong address.
A change on Znamky must move the dashboard without you editing it.