Word Tracking

Long time no read, sorry I’ve been pretty busy. Have been writing and reading, so that’s a plus. Thought I would share how I track everything word wise.

I am a tracker, I like to have a visual of my progress and love excel. I know there are others out there so naturally, I hunted the internet for different templates, but none really felt right for me. I would tweak the templates for a better fit, but still not right for me.

It took a while to figure out how I wanted everything to work, but finally came up with my daily spreadsheet.

Screenshot (1)

Just the basics: Code name of the project and how much I wrote in that for the day. Totals for overall and how much I have written per project in that one month. At the bottom I decide on a goal, keep an overall running total and then how much more I need to go. January was obviously a bit of a slow month as I only barely reached my goal.

Then, I wasn’t just satisfied with the daily numbers. I wanted to expand and see both monthly and yearly. It was a pain to figure out how to get the totals to show up on a different spreadsheet, but had a hay day when I got it where I wanted them.

Screenshot (2)

It’s simple and similar to the daily. Track the projects and number of projects I’ve worked on in the year (better understood for later) and pull the totals for the month from the daily page. It ends in totals for both monthly and project wise throughout the year. If they are blacked out as three of them are for January, that means I didn’t work on those projects at all that month.

The yearly page is my favorite because I have pulled the yearly totals used another formula for words per page and created charts to better visualize my work. This helps motivate me to work on different projects because I can see where I am putting most of my concentration and which books seem to be falling by the wayside.

Screenshot (3)

Advertisements