Tracking Sheets & Trend Reading

A number you don't write down never happened. This is the recording layer of the quarterly audit: the four-column sheet, the rules for telling a real trend from a noisy quarter, the annotation habit that makes old numbers legible, and the fifteen-minute ritual that turns the sheet into action.

The Four-Column Format

The whole recording system is one sheet with four columns: the measure, this quarter's value, last quarter's value, and last year's value. Nothing else. No graphs, no color codes, no scoring system — four columns that make the comparison unavoidable.

• 📏 Why four columns — one quarter apart shows movement; one year apart shows trajectory. This quarter vs last quarter is the check; this quarter vs last year is the story.
• 🖨️ Print this page — the print styles on this page strip the navigation and footer, so printing gives you a clean sheet plus the reference tables. One sheet per year, quarter columns filled in as you go.
• ✂️ The shifting rule — when a new quarter ends, this quarter becomes last quarter. Update the columns by shifting, not by re-copying the whole sheet: the year column stays put until it's replaced.
• 🖊️ Pencil, not pen — the columns shift every quarter. Pencil keeps the sheet legible for a full year; pen turns it into a palimpsest by June.
• 🧾 Starting mid-year — if your first audit is Q3, leave last quarter and last year blank and write a dash. The trend machinery only starts turning when the second quarter lands, and that's fine: an honest gap beats an invented history.
• 🔢 Plain numbers only — no emojis, no arrows, no verdicts in the cells. Judgments belong in your head and in the context line, never in the data column.

Context line: ______________________________________________________________________

One line for the quarter's story — travel, illness, a new training block, a medication change. Not judgments; data about the data.

Trend Reading: Signal From Noise

The sheet's whole purpose is to answer one question reliably: did anything actually change? Most single-quarter movements answer "maybe." The rule that separates signal from noise is direction:

• 📉 One quarter is noise — hydration, cuff technique, a bad sleep week, travel, and plain measurement error move every number by more than a single quarter's real change usually is. One bad quarter is a prompt to re-measure, not a diagnosis.
• 🧭 Two quarters is a signal — the same direction, two quarters running, is a real trend worth acting on. If the number also matches a context line (new training, more alcohol, a new medication), the story closes.
• 🏔 Three quarters is a fact — at three, the change is established and the question shifts from "is this real" to "what are we doing about it."
• 🎢 Direction beats magnitude — a small change in the same direction for two quarters outranks a large one-quarter spike. The audit watches which way the arrow points, not how far it jumped.
• 🧮 Worked example — waist-to-height creeps up 0.01 in Q2 and again in Q3: two quarters, same direction, and the context line says "took up running." That's a real trend with a plausible story — act. A single 0.02 jump in Q1 followed by a flat Q2: noise, re-measure, no action. Same magnitude, opposite verdicts, because direction decided.
• 📊 The noise floor — every measure has a threshold below which change doesn't count: roughly ±5 mmHg blood pressure, ±1 cm waist, ±2 kg grip, ±3 s balance, ±4 bpm resting heart rate, ±30 minutes sleep. Inside those bounds, a move is measurement noise even if it repeats.

How Much History Is Enough

The sheet holds a rolling year: four quarters, plus the year column that anchors them. That is enough to read a trend and short enough that the sheet survives contact with real life.

• 🗄️ The rolling window — when the fifth quarter arrives, the oldest quarter falls off. You're not building a museum; you're keeping a window.
• 📅 Why the year column matters — seasonality is real: winter weight, summer activity, holiday quarters. Last year's same quarter filters the season out of the comparison.
• 🧯 When a year isn't enough — annual labs (ApoB, HbA1c, glucose) change slowly; three to five years of those is genuinely useful. Keep that small archive separately and let the quarterly sheet stay quarterly.
• 📦 Where old sheets go — a folder or a drawer, unceremoniously. Old sheets rarely change today's decision; the context line is what makes them worth keeping at all.
• 🪞 Why not more — beyond a year, the quarterly sheet starts answering questions you're no longer asking. The window stays small on purpose: it's the size at which the sheet still gets read.

The Annotation Habit

Numbers without context are unreadable a year later. The annotation habit is one line per change, written at the moment of filing:

• ✍️ One line per change — "two weeks of travel, alcohol-heavy," "started lifting in May," "flu for ten days in January," "new beta-blocker." Not essays; one clause each.
• 🕵️ Why it matters — an explained spike is noise you can ignore. An unexplained change is the one that deserves attention. The context line is how the sheet tells the difference.
• 📍 Where it lives — the line under the sheet, or the Notes column if you went digital. Nowhere else: scattered context is lost context.
• 🗃️ The archive exception — annual lab values get their own longer archive of three to five years, because they move slowly and rarely. The context line stays one line even there; length is not what makes it useful.
• 🚫 What not to write — verdicts and confessions ("lazy quarter," "failed again") have no diagnostic value and make the sheet unpleasant to open. Facts only: what happened, not what it means.
• 🔄 Write it at filing time — memory reconstructs stories months later and smooths them. The line written in the moment is the honest one.

Spreadsheet Versus Paper, Honestly

The format matters less than the habit — but the formats differ in predictable ways:

For four entries a year, the paper sheet on the fridge beats the app in a drawer. If you already live in a spreadsheet, use it — the best tool is the one you will still open in December. A hybrid works too: the paper sheet for the quarterly ritual, a spreadsheet tab for the slow annual lab archive.

The Review Ritual

The sheet is only worth keeping if it gets read. The ritual is fifteen minutes, once a quarter, three moves:

• 🔍 Compare — this quarter against last quarter, then against last year. The first comparison is the check; the second is the story.
• 📝 Note — one context line per change, written in the moment, before memory edits it.
• 🎯 Act — one action, not five. The audit's output is a single next step — book the lab, adjust the training, re-run the blood pressure week — routed to whichever protocol page owns the fix.
• 📅 Anchor it — the first weekend after the quarter ends, on the calendar. A ritual without a date is a wish.
• 👥 The partner variant — if the pass keeps slipping, do it with someone else. A second reader asks the questions you skip — "what does the context line actually say?" — and fifteen minutes of company beats three months of intention.
• 🚪 Then close it — the sheet is not a dashboard to live in. File it, act once, and stop looking at it for three months.

Where the Evidence Lives

This page is the recording layer. The numbers it records each have a home elsewhere, and this series references rather than repeats them:

• 🩺 The measures and targets — the Quarterly Self-Audit series lead defines the nine numbers; this page only records them.
• 🔬 The lab science — ApoB, HbA1c, and glucose in full detail live in the Biomarker Testing topic; Blood Markers (Part 2) is the series summary.
• 😴 The recovery rows — wake-time spread, duration, and resting heart rate are measured in The Sleep & Recovery Audit (Part 4).
• 📏 The body metrics rows — waist, grip, and balance protocol detail is in Body Metrics (Part 3).

What to Do When It Goes Wrong

• 🚩 You skipped two quarters — do not reconstruct the missing numbers from memory; memory lies. Start fresh with today's values, mark the gap with a context line, and resume. The trend simply restarts; nothing else is lost.
• 🚩 Every number moved at once — that is usually one confounder wearing nine costumes: a new medication, an illness, a major life change, a different cuff or scale. Annotate the likely cause and re-measure in a month before engineering any response.
• 🚩 The sheet is filling with notes — annotations should stay one line per change. A sheet that reads like a diary gets abandoned by its own author; strip it back to facts.
• 🚩 You enter numbers but never read them — the ritual's three moves are compare, note, act. Without the act, the sheet is decoration. Put the fifteen-minute pass on the calendar with a reminder; a filled sheet that never gets read is a filled sheet that never mattered.
• 🚩 The numbers have become a source of dread — the audit is a tool, not a tribunal. Drop to twice a year, keep only the five core measures, or hand the sheet to a partner to fill during the ritual. Any of those is better than quitting.

Questions, Answered Briefly

• ❓ Paper or spreadsheet? — The one you will still be using in a year. For four entries a quarter, paper wins for most people; spreadsheet wins if you already live in one.
• ❓ How long until I can trust a trend? — Two quarters in the same direction, three to call it established. One quarter is re-measure territory, not decision territory.
• ❓ Do I keep every old sheet forever? — A rolling year of quarterly sheets is enough. The exception is annual labs: keep those for three to five years in a separate envelope or spreadsheet tab.
• ❓ All my numbers are already in range — why keep a sheet? — In-range numbers are exactly the ones you need trend data for: the question isn't "am I okay now" but "is anything drifting." A guardrail matters most when the road looks straight.

This Page in One Workflow

1. Open — the sheet, paper or spreadsheet, first weekend after the quarter ends.
2. Fill — this quarter's numbers into the second column, from the audit's measurements.
3. Shift — last quarter's column slides left; the year column updates.
4. Annotate — one context line for every change, written now.
5. Act — one action, routed to the protocol that owns the fix, then file until next quarter.

Related Topics