The formula, in plain words
-
✓
Above your target? Green. You're good. Nothing to do.
-
1
One day under your target? Still fine. One low day is just a Tuesday. No panic.
-
2
Two days in a row under? Yellow. Fix it now. That's a pattern starting. It's small today — keep it small.
-
!
Any day under your crash line? Red. Act today. Don't wait for tomorrow's number.
The whole idea: don't watch for the crash. Watch for the two low days that come before it.
Try it right now
Type your daily target, then three days of totals. Watch the rule work.
Get the free spreadsheet
Same formula, already built. You only ever type two things:
- Once: your target and crash line (two yellow cells)
- Daily: the date and one total
The sheet colors each day green, yellow, or red by itself — and flags "2 days in a row" for you automatically. 120 days of rows, ready to go. Works in Excel, Google Sheets, and Numbers.
⬇ Download the tracker (.xlsx)Free. No sign-up, no email, nothing tracked. It's just a spreadsheet.