Day 106 · Tuesday, 17 November 2026
Every week's meter reading is different, so "higher than average" flags half of them. What a facilities manager needs to know is whether a week is further from normal than the usual week-to-week wobble can explain, and the standard deviation is that wobble measured. Two of them from the average is the usual line between noise and something worth walking the pipes for.
You look after facilities for a 60-room hotel, and the water company bills by the cubic metre. The last ten weekly meter readings are in A2:B11. In C2, show "Check" if that week's use is more than two standard deviations away from the ten-week average, in either direction, and "OK" otherwise. Work the average and the standard deviation out of B2:B11 inside the formula, then copy it down to C11.
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.