Finger pushing


NORTHWEST NOTES: Getting back into it with spreadsheets

Holiday eating, spending and socializing got you in a tizzy? That’s why January was invented. January is the “get back” month. It’s when we get back on our diets, get back in the gym, get back on our budgets and back into our routines.Where to start? I start with spreadsheets.

OK, confession time: I live by spreadsheets. I’m ruled by them. I have spreadsheets for every writing project, home- and self-improvement project and financial project. I have a workbook full of monthly income, budget, debt and financial goal spreadsheets. I have spreadsheets of every newspaper article, column, web posting, book and blog I write. My spreadsheet addiction helped me organize my genealogy back to my great-great-great-grandparents, and my third-great-grandparents to my eighth-great-grandparents. I’m making spreadsheets of my eighth-great-grandparents to my thirteenth-great-grandparents, and once those are complete, I’ll track the thirteenths to the eighteenths. And so on.

If you’re not familiar with spreadsheets, they’re pages of little boxes or “cells” organized in columns and rows. Each cell has some data in it: a name, number, activity or amount. You can sort the cells to get different kinds of information. I color code my spreadsheets, sort them, filter them and use formulas to slice and dice the numbers.

I could make charts and graphs with my spreadsheets, but I like to see the big grid of everything I’ve done and have to do. I could use apps to track all this stuff, too, but where’s the fun in that? I could pour my spreadsheets into a pretty database, but I would miss all the cells — those individual bits of data that tell my life’s story.

Why do all this spreadsheeting? Like everyone else, I can’t remember everything. I don’t remember how much writing I did last year. But I can look at my spreadsheet and see that I wrote five books, 80 news stories, 29 columns and 47 articles for the web. Now I know why I didn’t have time for all those projects on my home improvement spreadsheet!

I couldn’t keep track of all those people in my family’s history without spreadsheets. Off the top of my head, I can’t recall the name of my fourteenth-great-grandfather on my maternal grandmother’s side of the family. But a glance at my spreadsheet tells me he was Sir Lord Robert Townsend, Knight of Ludlow, Lord Chief Justice of the Marches of Wales and Chester. I’ll probably forget about Sir Robert in five minutes, but no fear — he’s documented in my spreadsheet!

I don’t remember how much money I spent on beer last year and how much I put in savings, but I can look at my financial spreadsheet and get the answer. Ooohhh … I think I’ll keep that bit of information to myself.

There’s something very satisfying about spreadsheets and I suspect I’m not alone in this obsession. Each time I update a cell, add another name or enter a new number, I smile. It’s like a visual reminder that I did something, somewhere, at some time. I discovered a new relative and shared that with my family. I paid a bill or wrote another story. I did something that made me smile and hopefully made someone else smile, too.

Getting back to January, the get back month. I’m not the only person getting back on track this month and I don’t know how other people do it without spreadsheets. Knowing what I did — and didn’t do — last year tells me what I need to do differently this year. I need to get back on track with my home improvement projects. I need to get back on my budget, too, and back on my exercise plan. I need to spend less on beer and save more for retirement. Or maybe I just need to rethink my financial goals.

But right now, I’m going to make a cup of tea and go sit outside on the porch and enjoy the sunshine. My “get back January” is on track, safe and sound in a dozen spreadsheets. I’m closing all those spreadsheets, right after I update this one little thing … Northwest Notes Columns: 1. There!

Susan Joy Paul is an author, editor and freelance writer. She has lived on Colorado Springs’ northwest side for 20 years. Contact Susan with comments and suggestions at woodmennotes@gazettecommunitynews.com.



Welcome Back.

Streak: 9 days i

Stories you've missed since your last login:

Stories you've saved for later:

Recommended stories based on your interests:

Edit my interests