My Spreadsheet Doesn't Lie: Why My Memory Only Works When My Sleep Score Hits the Green

My Spreadsheet Doesn't Lie: Why My Memory Only Works When My Sleep Score Hits the Green

I was staring at a column of red cells on my laptop in mid-November, realizing my recall test scores were plummeting despite the new stack of supplements I was testing. It was the kind of data trend that would have made me call an emergency meeting back in my accounting days, but here in my home office in suburban Dallas, the only person to fire was myself. My memory, the very thing I’d spent 30 years refining to keep track of complex tax codes and client portfolios, was essentially reporting a quarterly loss.

Before we get into the ledger, a quick note on transparency. This site uses affiliate links, which means I earn a commission if you buy something through them, at no extra cost to you. I only recommend brain supplements I have personally tested and tracked in my own spreadsheet—and as my wife will tell you, I track everything. I'm not a doctor or a neuroscientist; I’m just a guy who spent three decades making numbers add up and now applies that same obsessive auditing to his own aging brain. Please talk to your own doctor before changing your routine, especially if you're worried about cognitive decline.

The Brain Audit: Transitioning from Corporate Books to Cognitive Tracking

When I took early retirement, I didn't just walk away from the office; I walked away from a brain that felt like a reliable hard drive. Suddenly, I was forgetting names I’d known for twenty years. To process this, I did the only thing I knew how to do: I built a master spreadsheet. It has more tabs than our joint tax returns ever did. I track everything from caffeine intake to word-association speed. I even have a column for 'subjective clarity,' though I hit a snag early on. I found myself trying to track 'brain fog' on a scale of one to ten but realizing I was too foggy to remember what a four felt like compared to a six the day before. That’s a classic accounting error—subjective data is a nightmare to audit.

My goal was to find the perfect ROI for my brain health. I spent 14 months testing different capsules and powders, looking for that 'magic bullet' that would make me feel 35 again. I was looking for a single variable I could toggle to fix the output. But as I sat there in the quiet of my office, the blue light of the screen reflecting off my reading glasses, I realized I was ignoring the most important input in the entire equation. My spreadsheet has a limit of 1,048,576 rows, and I felt like I was going to need every single one of them to figure out why my memory was still failing despite the 'premium' supplements I was swallowing.

A sleep tracking wearable on a wrist next to a notebook with memory scores.

The Discovery: Cross-Referencing the REM Cycle and the Car Keys

In late February, I decided to cross-reference my wearable sleep tracker data with my morning memory tests. I’d been wearing the device for months, but I’d mostly been looking at 'total hours' rather than the quality of those hours. When I merged the two data sets, the correlation coefficient was startling. On days when my memory scores were in the bottom 10%, my deep sleep percentage had consistently dipped below the healthy floor of 20%. It didn't matter how many high-priced capsules I took the day before; if the sleep data was red, the memory data followed suit.

I started looking into the 'why' behind this, and while I’m no biologist, the accounting logic held up. Think of sleep as the overnight maintenance crew for a large office building. During the day, you’re creating 'waste'—metabolic byproducts. There is something called the Glymphatic system that essentially acts as the janitorial staff, clearing out this waste while you sleep. If the staff doesn't show up, or if they only work a half-shift, the trash piles up. By the time you sit down at your desk the next morning, you’re working in a cluttered, messy environment. No wonder I couldn't remember where I put the spare set of keys.

I also noticed that my body temperature fluctuation—which should be a drop of about 2 degrees during a healthy sleep cycle—was all over the place. My 'system' was running hot, which meant I wasn't getting into those restorative stages where Memory consolidation happens. This is the process where the brain moves files from the 'Temporary' folder (short-term memory) to the 'Archive' (long-term memory). If that process is interrupted, the files are just... deleted. My wife rolled her eyes as I tried to explain the correlation coefficient between my REM cycle and finding the car keys, but the numbers were right there in black and white.

The Night Shift Paradox: Why Standard Advice is a Bad Audit

This is where things got interesting. Most sleep advice is built for people with a standard 9-to-5 schedule. 'Sleep in a dark room,' they say. 'Go to bed at the same time every night.' But as I was digging through forums and talking to a neighbor who is a night-shift nurse, I realized that for a huge portion of the population—healthcare workers, first responders—this advice is essentially a bankrupt strategy. Their circadian rhythms are chronically misaligned, meaning their cortisol levels, which should reach their lowest point around midnight, are spiking when they should be dipping.

For these folks, memory consolidation isn't just difficult; it’s functionally broken. They are trying to run the 'overnight janitorial shift' while the sun is up and the world is noisy. I realized that my own habit of staying up until 2:00 AM auditing my spreadsheet was putting me in a similar 'pseudo-night shift' state. My brain health wasn't a single-variable equation; it was a complex set of interlocking systems that required the right frequency to synchronize. If the frequency is off, the whole balance sheet collapses. You can read more about my efforts to fix this in my article on My Spreadsheet vs. My Memory: Tracking Brain Health After Three Decades of Numbers.

Turning Point: Auditing 'The Brain Song'

After about six weeks of trying traditional sleep hygiene with mediocre results, I decided to test something a bit outside my usual 'capsule-only' comfort zone. I’d seen people talking about audio-based frequency supplements, specifically something called The Brain Song. To an old accountant, the idea of listening to a specific frequency to fix your brain sounds like a 'too good to be true' investment pitch. But since my deep sleep metrics were still flatlining, I decided to run a controlled trial.

The first night I used it, I experienced a strange, pleasant buzzing behind my eyelids. It wasn't distracting, but it was definitely a physical sensation. I woke up the next morning and, for the first time in months, my wearable tracker showed a deep sleep score that hit the 22% mark—firmly in the green. I didn't feel 'caffeinated' or 'wired'; I just felt... organized. It was like someone had finally come in and filed all the loose papers on my desk while I was out. I’ve written a more detailed breakdown of this in my post Does The Brain Song Help Clear Brain Fog After Retirement?

I continued the trial through April, and the results were consistent. My memory recall scores—the ones I track using a standard word-list test—improved by nearly 15% over that period. It wasn't a miracle, but in the world of cognitive decline, a 15% gain is a massive ROI. I even compared it to some of the higher-end capsules like NeuroPrime, which are great for focus during the day, but they didn't have the same impact on my sleep-to-memory conversion rate that the audio frequency did.

Final Balance Sheet: Realizing Brain Health is a System

One humid Tuesday evening in early June, I was sitting on the back porch, and I realized I hadn't forgotten a single name or misplaced my phone in over a week. The spreadsheet confirmed it. The 'red cells' were gone. This journey has taught me that you can't just throw money at supplements and expect your brain to fix itself. You have to audit the entire system. If you aren't clearing out the metabolic waste through deep sleep, you're essentially trying to paint a house that's currently on fire.

For those of you who, like me, are obsessed with the numbers, I recommend looking at your sleep quality as the primary 'overhead' of your brain's operation. If that cost is too high—meaning your sleep is poor—your cognitive profit will always be low. Whether you use something like The Brain Song to help find that frequency or you find another way to hit that 20% deep sleep mark, the goal is the same: balance the books before you start trying to grow the business.

I’m still tracking every day, of course. My wife says I’ll probably be the only person in the nursing home with a spreadsheet for his Jell-O flavors, but as long as I can remember the names of the people visiting me, I’ll consider that a successful audit. If you're looking for a place to start your own cognitive audit, check out my notes on NeuroPrime vs Brain Song for Better Name Recall and Memory.

Disclaimer: The information on this site is based on personal experience and research for informational purposes only. It is not a substitute for professional medical, financial, or legal advice. Always consult a qualified professional before making decisions that affect your health or finances.