Productivity Tracker Spreadsheet That Measures Inputs

Hey folks, it's Ren here.

There is a small notebook on my desk. Black cover, ring-bound, scuffed corner. It has been sitting there for about a year and a half. I tally three numbers in it every day: deep work hours, the number of restarts after an interruption, and how my energy actually felt versus how I expected it to feel.

Three numbers. About fifteen seconds of writing.

For most of my life I tried to measure productivity the obvious way. Count the tasks. Count the emails answered, the words written, the meetings survived. The numbers always went up and the weeks always felt the same.

The notebook does something different. It measures the inputs that make a productive day possible, not the outputs that fall out the bottom.

That swap is the whole point of a good productivity tracker spreadsheet: stop measuring what got done, start measuring what made it possible.

"Clarity about what matters provides clarity about what does not." — Cal Newport

📊 Why output-based productivity trackers lie to you

Most productivity trackers count outputs. Tasks done. Emails sent. Inbox zero or not. The numbers feel meaningful because they are easy to count and they reliably move up.

But output is downstream. You can have a twelve-task day that empties you out for the rest of the week, and a four-task day that compounds into the next month's work. The output count cannot tell the difference. The week feels productive while the system underneath quietly burns down.

Please do not be hard on yourself if you have ever ended a "high-output" week feeling like you barely moved anything important. The tracker was measuring the wrong number.

The usual ways output-only trackers mislead:

• They reward churn over depth. Ten emails reads the same as one piece of real thinking.
• They miss the cost of restarts, so a fragmented eight-hour day looks the same as a clear four-hour one.
• They count meetings survived as productivity, which makes a calendar full of nothing rank high.
• They do not see the days you spent quietly setting up next month's compounding work.

🪶 The three inputs worth tracking, and why

Inputs predict outputs. They are also the bits you can actually change. Three of them carry almost the entire signal, and you can log them in under a minute a day.

Deep work hours, restart count, and the gap between expected and actual energy. That is it.

Deep work hours measure how long you actually held a single thing in your head with no other tabs open. Restart count is how many times an interruption pulled you out and you had to context-switch back. The energy gap is how much your end-of-day energy differed from what you expected when you sat down. Each one is a lever you can pull next week.

🛠️ How to set up an input-based productivity tracker spreadsheet

About twenty minutes in Google Sheets or Excel. Five columns is plenty.

1. Date. One row per working day. Skip weekends unless you want to see them.
2. Deep work hours. Total hours spent in single-task focus mode, however you define focus. Round to the nearest half hour. Honesty beats precision.
3. Restart count. How many times you came back to the same task after an unplanned interruption. Tally marks on paper, transcribed in the evening, is fine.
4. Energy expected vs actual. Two numbers from 1 to 5. The morning prediction and the end-of-day reality. The gap is the data.
5. One-word note. The single word that captures the day. Clear. Fractured. Slow. Surprising. Two months of these and the patterns are visible.

Run it for a month before you change anything. The point is not to optimise the week on day five. It is to see which inputs actually correlate with the days that felt and were productive.

⚠️ Mistakes to sidestep

• Adding a "tasks completed" column. Fix it: leave it off. The output count is exactly what you are trying to escape.
• Logging deep work to the minute. Fix it: half-hour rounding is honest enough. False precision kills the habit by week two.
• Reading the data daily. Fix it: log daily, read weekly. Daily reads create noise; weekly reads create signal.
• Trying to push deep work hours up immediately. Fix it: track for a month first. The hours move on their own once restarts go down.

If you want the wider weekly system this tracker sits inside, the task tracker spreadsheet guide walks through the architecture that input tracking bolts onto.

🎯 Your action steps this week

• Open a sheet with the five columns above. Twenty minutes.
• Log tonight, even if today was messy. The messy day is the most useful first data point.
• Use tally marks for restarts during the day; transcribe at end of day.
• Set a Sunday five-minute review on the calendar. That review is the system.
• If a habit-tracking layer would help underneath this, the habit tracker spreadsheet guide pairs cleanly with the input view.

⚡ Quick answers

What is a productivity tracker spreadsheet?

A simple sheet that logs the inputs that make a productive day possible: deep work hours, restart count, and the gap between expected and actual energy. Five columns, one row per day, weekly review.

Should I track outputs or inputs?

Inputs. Output counts feel meaningful but they reward churn over depth. The inputs are upstream and they are the bits you can actually change next week. Run the input view for a month and the outputs follow.

How do I count deep work hours?

However you honestly can. Round to the nearest half hour. Hours where you held a single thing in your head with no other tabs open count. Hours of fragmented multitasking do not. Precision is less important than consistency.

What is a good restart count?

Under five for a typical day, ideally under three on a deep work day. Above eight is a signal that the environment is fragmenting attention, not that you are weak. The number is diagnostic, not a target to lower for its own sake.

Can I use Google Sheets or Excel for this?

Either works. Google Sheets is best if you want to log from your phone in the evening. Excel is great if your work already lives there. The columns are the same.

The notebook is still on the desk. Three numbers a day. The corner is more scuffed now and the weeks feel different.

To the work that compounds,
Ren

This article is for general information only and is not professional advice. Productivity systems work differently for different people, so use what fits you and adapt the rest.