What's worth tracking (and what belongs on paper)
Okay sooo. New module. We've spent the last few lessons building a budget, and now we're branching out. Because once people get comfortable with a sheet, they want to track everything. I see it happen every single time.
Here's the thing though. Not everything belongs in a spreadsheet. Some stuff genuinely works better on paper, and I say that as someone who does this for a living, so hear me out before you think I'm just being contrarian for fun.
The test I actually use
Before I build a tracking sheet for anything, I ask myself one question: am I going to do math with this, or am I just trying to remember it?
If you need to add it up, average it, sort it, or watch it change over time, that's a spreadsheet job. Money in and out. Miles driven. How many diapers you're going through in a week (yes, I built that tracker, yes it was half a joke, yes I still use it).
If you just need to know a date and maybe a note, that's a paper job. My birthday and anniversary list lives in a little notebook by month, and it stays there on purpose. I don't need to calculate anything about my sister-in-law's birthday. I just need to see March and remember it's her month.
Where this goes sideways
I helped out at a Relief Society activity a while back and offered to make a sign-up sheet for a dinner thing. Simple ask. Except I cannot help myself, so by the end of the night it had turned into a full spreadsheet with tabs. One for who's bringing what, one for a headcount, one with a little formula checking whether we had enough of each dish category. It worked great.
But then three different people came up to me before I even left and asked if I'd make one for THEIR thing too. A carpool schedule. A book club rotation. Something for a fundraiser. And that's when it hit me, not every one of those needed what I'd built. The carpool one, sure, that's got real scheduling logic, a spreadsheet earns its keep there. But the book club thing was really just "who's hosting and when," which is a list. That one probably wanted a note on the fridge more than a formula.
The lesson isn't "spreadsheets are bad." The lesson is that just because you CAN build something complicated doesn't mean the problem needed it. Match the tool to the actual question you're trying to answer.
A quick gut-check list
When you're deciding, ask:
- Do I need a total, an average, or a comparison over time? Sheet.
- Am I sorting or filtering this by date or category? Sheet.
- Is this just "remember this thing on this date"? Paper, or your phone calendar, whatever you'll actually check.
- Will I update this weekly or more? Sheet, because retyping the same info by hand gets old fast and you'll quit.
- Is this a one-time list, like packing for a trip? Paper's fine. Don't overbuild it.
That last one trips people up the most. I've watched folks build elaborate packing-list spreadsheets with checkboxes and conditional formatting for a weekend trip up the canyon. It's genuinely more effort than the trip.
My actual opinion here
You do not need to track everything just because tracking is possible. I say this in the budget lessons too, but it applies everywhere: precision you won't maintain is worse than a rough system you'll actually keep using. A spreadsheet you abandon after two weeks did less good than the notebook you kept opening for three years.
What we're building next
For this module we're making one simple tracking sheet, the kind that answers a real question you have right now. Not a budget, we've already got that. Something else. Maybe it's gas mileage, maybe it's a side project's hours, maybe it's how often the water softener needs salt (ours eats through it fast with our hard water, don't get me started).
Come to the next lesson with one question you actually want answered. Not "I should track my spending on X," but the actual question, like "am I spending more on gas since I started that new job." If you've got that question ready, building the sheet is the easy part.
Before next time
Think about one thing in your life right now that's living in your head, or scattered across sticky notes, that would genuinely be better as either a quick sheet or a page in a notebook. Just pick the side. We'll build it together next time if it's the sheet side.
- C