My spreadsheet says 213.8; the bathroom scale is agnostic

2026-10-06 2658 views 5 posts

Posting because my daily weight has been useless for nine days and my 7-day trimmed mean is the only thing keeping me honest. This morning: 131.6 lb down over 108 weeks, current median 213.8. Four columns actually matter to me: median, waist at navel, sleep, and whether I got 30g protein before 9am.

The daily scale bounced between 211.6 and 216.2 all week, so a screenshot would look like a fire drill. The median says steady. I'm not throwing confetti yet; my trendline has flat-lined for 11 days before and then dropped 3 lb in six.

Anyone else treat the rolling average as the real number and the daily reading as just noise? Or am I too attached to my workbook?

The 30g-before-9am column is the one I’d interrogate. Is it actually moving your 7-day median, or mainly cutting 10am cravings?

I’ve seen protein timing touted hard, but the evidence that timing beats total daily protein seems weak; for me, front-loading just reduced afternoon snacking, not scale noise. Also, how are you trimming—middle five of seven?

I use a 10-day median and a fasted morning waist at navel, same spot, because evening measurements added ~0.75 in of junk. Sleep under 6h for two nights reliably stalls my median for ~5 days.

Do you log sodium/restaurant meals separately?

Navel waist is the column I’d trust more than the daily scale, but only if you lock conditions: same time, after exhale, no sucking in, 0.25-inch rounding. Mine often trails my 7-day median by 2–3 weeks, so a flat scale stretch with a slightly smaller waist is a win.

What’s your sleep metric—total hours, wake-ups, or efficiency? I log wake-ups, and >2 usually predicts a 1–1.5 lb water bump two mornings later, then it’s gone.

The median isn’t lying; it’s just slow.

late-night gamer here. my 7-day median ignored sleep hours but reacted to bedtime consistency — same-ish lights-out, even if only 6.5h.

i also log soda swap as “after 9pm? y/n”; the late one was the only one that seemed to matter for next-morning scale.

is your sleep column total hours or a consistency score? if it’s hours, maybe try a separate “lights-out variance” column for a week.

The thing I’d add: that 4.6-lb nine-day range is more useful than any single morning. In maintenance I use a “noise budget”—if my 7-day median stays inside about 1 lb and my habits are stable, I ignore the daily number.

If the median itself drifts two weeks running, that’s when I dig into the columns. Sharp question: is your 7-day trimmed mean basically flat across those nine days, or quietly trending?

That’s what would tell me whether the bouncing is noise or the start of a real move.