Wrapping up: keeping your sheets alive after class
This is the last lesson in the module, and it is an odd one, because I am not teaching you a new skill. I am simply talking about what happens after class ends and you are on your own with this thing.
Because a great many people build a really nice sheet in a class like this and then it just... sits there. Life happens, the sheet goes stale, and before long opening it feels like guilt rather than help. I do not want that for you. So let us talk about how to keep a sheet alive once nobody is making you touch it every week.
Give it a job, not a shrine
The sheets that last in my house are the ones that answer a question I keep asking myself. Where is the money going. Is this contract up for renewal. Am I buying wipes at a reasonable rate (yes, that is a real one I built, and no, do not ask).
The sheets that die are the ones I built because a sheet seemed like the responsible thing to own. No question behind them, nothing but a notion. If your budget sheet or your tracker no longer has a question attached to it, that is worth noticing. Either find the question again or let the sheet go. Not every sheet needs to live forever.
Autosave is not optional
I have said this before in this course, and I will say it once more, because it matters all the more once class is over and nobody is reminding you. Turn on autosave. Check that it is on. If you are in Excel and not using OneDrive, save by hand, and build the habit of pressing Ctrl+S the way some folks tap their foot.
I learned this one the hard way. Dawson, who was three at the time, poured apple juice straight into the keyboard while I was mid-formula. I lost about twenty minutes of work because autosave was off and I had not saved in a while. Sticky keys, dead time, the whole affair. I turned autosave on that very day and I have not hushed about it since. Do not try to be a hero about saving your own work. You will lose that bet eventually, and it is usually a toddler holding the cards.
Let it get a little messy
I will be honest, my own home sheets are not pretty. There is a cell in my budget, B12, that for one whole day read "kkkkkkkk," because my daughter Lilly climbed into my lap while I was working and typed a straight line of k's into it. I saw it, laughed, and left it there for a day because it made me smile every time I opened the file. Then I cleaned it up. Eventually.
The point is that a live sheet has fingerprints on it. Typos, a strange note to yourself, a cell that says "fix this later" that you never do fix. That is fine. A sheet too precious to touch is a sheet you will stop opening.
A once-a-month check-in, not a daily grind
You do not need to live in this sheet. Pick one small, ordinary recurring moment, the first Sunday of the month, payday, whatever suits your life, and simply open it and update it. Ten minutes. Check that your categories still make sense. Delete a formula that is plainly broken instead of letting it rot.
This ties to something I believe pretty firmly: you do not need forty categories to make a budget work. Five or six is plenty. If you find your tracker exhausting to update, the fix is usually not more discipline, it is fewer categories. People quit not because they are lazy; they quit because they built something too detailed to keep up. Simplify before you give up.
Know what belongs on paper
Some of what we tracked in this course might genuinely belong on paper going forward, or in a note on your phone, and not in a spreadsheet at all. I keep birthdays and anniversaries in a paper notebook, one page per month, and I have done that for years, even though I do this for a living all day long. It is simply the right tool for that particular job. A sheet is not automatically the better answer. Use whatever you will actually keep using.
When a sheet breaks
If you come back to a sheet in a month and a formula is plainly wrong, do not panic and do not scrap the whole thing. Click into the cell, look at what it is actually pointing at, and ask, "all right, this is broken, why." Usually it is a reference that moved when you inserted a row, or a copied formula that dragged wrong. Fixable in a minute, most of the time.
Before next time
You have no homework from me this time. Just open one sheet from this course sometime this week, even for two minutes, and see whether it still feels useful. If it does not, that is information too.
- C