214 Nights, 23 Sleep Fixes, One Spreadsheet: The Diary Of A Woman Who Tested Everything
She logged every night since February: what she tried, what her tracker said. Twenty-two rows of nothing. Then a pharmacist niece read row 9, said four words about it, and the graph bent.
I am a retired bookkeeper. When something in my life breaks, I make a spreadsheet. In February, after one 3am too many, sleep became the something.
Column A, date. Column B, intervention. Column C, what my tracker said. Rules: one change at a time, at least a week each, no wishful rounding.
Rows 1 through 22, abridged
- No caffeine after noon (Feb): deep sleep unchanged. Mood: casualty.
- $200 sunrise alarm (Mar): lovely wake-ups. Same broken nights.
- Lavender everything (Mar): the room smelled wonderful at 3am.
- Drugstore magnesium tablets (Apr): nothing on the tracker, unhappy stomach. Crossed the whole mineral off the list. Remember this row.
- Mouth tape, blue-light glasses, 10-3-2-1 rule (May): rows 12 through 14, flat.
- Cold room, socks, military method, tart cherry juice (Jun): flat, flat, flat, and one ruined tablecloth.
- The expensive topper and a genuinely boring book (Jul): comfortable and well-read at 3:07am.
Five months. Average wake-ups per night: 2.4. Deep sleep: barely moved. I have the graphs, and they look like Kansas.
The barbecue audit
In August my niece, a pharmacist, scrolled the spreadsheet at a family barbecue, the way other people scroll vacation photos. She stopped at row 9, the April magnesium row, and said four words:
Then, over potato salad, the explanation nobody at any counter had given me. The cheap tablet form barely crosses the gut wall; it is famous for doing nothing except what it did to my stomach. The mineral was never the failed experiment. The form was. The absorbable form is bisglycinate, magnesium bound to an amino acid that carries it through. She wrote it on a napkin. I still have the napkin.
Rows 23 and counting
I ordered Kaive that night, mostly because two sugar-free raspberry gummies beat another tablet, and my compliance data (see rows 4, 9, and 12) is honest about what I actually stick with.
Nights 199 through 214, nothing else changed, because at this point I am a scientist: wake-ups down from 2.4 to 0.6 average. Deep sleep up almost an hour on the good nights. On August 19 I slept 7 hours 41 minutes straight through, and my tracker sent me a congratulations notification, which I screenshotted and framed, because data people celebrate strangely.
The whole point
I wasted five months and several hundred dollars testing everything except the right form of the one thing. You do not need my spreadsheet. You need row 23 and thirty nights, and if your column C does not move, the guarantee refunds it, which is more than I can say for the topper.
