The Morning Spreadsheet That Changed Everything For Me

I started tracking every single hour of my day three years ago because I was losing track of where the hours went and it bothered me. I'm not talking about fancy app ecosystems or expensive habit trackers. I opened a Google Sheet, typed out 6am to 10pm in fifteen-minute increments, and started writing what I actually did. Not what I wanted to do. What I did. The first week was brutal because I pretended I was more productive than I was, then I stopped lying to myself and started recording honestly. The concept behind How I Live Now is simple: your life runs on systems you didn't intentionally design, so the first step is to map them out, identify the ones that are working, and fix or replace the ones that aren't. People overcomplicate this. They buy $50 planners, download seven different apps, and then abandon everything within two weeks because the friction is too high. The version I use doesn't require any of that.

How I Live Now: Building Your Daily Map

Here's the actual system. You'll need a spreadsheet, a notes app, and about an hour on a Sunday. That's it. Column one is date. Column two through twenty-four are time blocks in fifteen-minute increments for each weekday. Column twenty-five is a summary field where you write one sentence about the day. The spreadsheet lives in Google Sheets because you can edit it from your phone when you're at the grocery store and realize you forgot to log something from earlier in the day. Every evening, you spend roughly four minutes logging the day. Four minutes. If it takes longer than that, you're being too detailed. You don't need to write "attended team meeting about Q3 budget reconciliation." You write "team meeting, 45 min." The point isn't archival accuracy. The point is pattern recognition.

After two weeks, you look at the summary column. Patterns emerge. I found that every Wednesday afternoon I hit a wall around 3pm and I wasn't scheduling any deep work then. Turns out my most cognitively demanding task was getting pushed into the worst possible time slot because I was waiting for emails to clear first. I moved that task to 8:30am and my output on Wednesdays doubled without adding any hours.

Get the Full Details

How I Live Now Movie
How I Live Now Movie

The Decision Framework That Actually Matters

Tracking time is useful but it's only half the equation. The real leverage comes from identifying decision points and creating rules for them so you stop wasting mental energy on trivial choices. This is where most people get stuck because they try to apply this framework to everything and end up with a decision tree so complex it becomes counterproductive. Start with the decisions that happen more than three times per week. Lunch, commuting, email management, workout timing, bedtime. Those are your targets. For each one, write a default rule. "I eat lunch at 12:30 unless a meeting is scheduled." "I check email in three blocks: 9am, 1pm, 4:30pm." "I work out before noon unless I have a prior commitment." These rules sound basic but they eliminate decision fatigue in a way most people don't expect. Here's the part nobody mentions: you need a review cadence. I review my system every Sunday evening for twenty minutes. I look at the previous week's entries, I note what broke down, and I adjust one or two rules. Not ten rules. One or two. The people who fail at this are the ones who try to overhaul their entire system every Sunday. You're not building a startup. You're optimizing a schedule. Small tweaks compound.

A Specific Problem and the Workaround I Use

About eight months in, I hit a wall where my tracking felt meaningless. I was logging time but not connecting it to outcomes. I had hours logged for "work" but no way to know if those hours were producing anything worthwhile. I nearly quit the system entirely because it felt like busywork. The workaround was adding a simple outcome column to my spreadsheet. Not a complex scoring system. Just a one-word tag: shipped, delayed, abandoned, deferred. Every Friday, I went through my logged hours and tagged each block. It took about twelve minutes. After six weeks of this, I saw that roughly 40% of my logged "work" time was either deferred or abandoned with nothing to show for it. That number wasn't terrible but it was worse than I thought and seeing it in black and white forced me to restructure how I planned my days. I stopped batching similar tasks together and started blocking time for the highest-leverage work first.

How I Live Now: Tools and Implementation

My current setup uses Google Sheets for time tracking, Apple Reminders for daily task management, and a physical notebook for weekly reviews. I tried switching to Notion once because it seemed more capable and spent three weeks customizing templates instead of actually tracking my time. I switched back. Function beats features every time in this category. If you want to replicate this, here's what I recommend starting with. A Google Sheet with the structure I described above. An existing calendar app you already use. A free notes app. Do not add another tool. The moment you add a fifth tracking tool you've already lost momentum. Commit to the minimum viable system for thirty days before considering any additions. There's also a digital version of this system that some people prefer. I won't link to anything specific because these tools change frequently and I don't want to send you to something that's been updated into unusability, but searching for "daily routine tracker spreadsheet" will give you dozens of well-designed templates that do the same thing I've described. Pick one, import it, and start using it immediately. Don't spend a week comparing options.

How I Live Now [DVD]: Amazon.co.uk: Saoirse Ronan, Tom Holland, Anna Chancellor, George MacKay ...
How I Live Now [DVD]: Amazon.co.uk: Saoirse Ronan, Tom Holland, Anna Chancellor, George MacKay ...

When This System Fails Completely

I need to be honest about the situations where this approach falls apart. If you have an irregular schedule like rotating shifts, frequent travel, or caregiving responsibilities that make predictability impossible, the standard daily block system becomes noise rather than signal. I've seen people in these situations try to force this method and burn out because the gap between their actual life and their planned structure created constant frustration. In those cases, the alternative is event-based tracking instead of time-block tracking. You log activities by what happened, not by when they happened. "Walked dog" instead of "7:00am-7:20am: walked dog." It's less granular but it captures the same pattern-recognition value without fighting against your reality. Another failure mode is obsessive tracking. I know someone who spent two hours a week maintaining their system instead of living their life. The tracking became the goal instead of a tool for insight. If you find yourself optimizing the spreadsheet more than using the data, you've crossed the line and need to simplify immediately.

The core principle remains unchanged regardless of your circumstances: write down what you actually do, look for patterns, adjust one thing at a time, and review weekly. The rest is just ceremony.