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

Published by

Courtney M. Wendleton

I'm an author with an associate's in psychology. Interested in a lot of different things, and love controversy. The more controversial the better, but that's not all I'm interested in. Can be a bit confusing at times, but that's normal!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s