One of the things I’ve been seeing a lot of posts on as we roll over the start of 2020 is wrap-up posts, and that got me thinking. Although I do my monthly recaps, I’ve never really paid much attention to how much I’m writing throughout the year. I’m usually pretty good about keeping track of where I’m at and what I’m doing in my planner, but that doesn’t give me the option to review the year as a whole.
Out of curiosity, I’ve set up a tracker in Excel. I already keep track of my daily word count in my planner but I also wanted to keep track of where those words are being written. I already have project list set up to track what state each project is in and keep an eye on how large my WIP list is so I ended up adding a new page to that.
I don’t need to track much, mostly just the monthly totals. I’ll have to remember to update and add in the daily counts as I go. I’ve also included three categories of project: Completed, Started and Editing. I’ve also included rules for myself about what counts for each category. Although it’s basic, I’m happy. I can’t wait to see what it looks like at the end of the year.
How do you track your writing stats?