I thought I’d share my latest word count tracker. It’s very similar to last year’s word count tracker. I did put in a lock on some formula fields so that a simple mistake wouldn’t lead to hours of frustration.
January has already been a busy month for me. And this is going out a little later than I hoped to do it. Below, you’ll find some images of the tracker. The links to the pages are on the bottom of the post.
The first page is a statistics overview page with a chart that tracks your word count by month over the year and a place to keep track of your WIP status both finished state or revised. You put in a yearly goal in the yellow box and it will calculate how many words per month you need to write.
The second page keeps track of your WIP and Revisions The circular charts are for your in progress WIP. The first table is for your WIP in revision and can link to the revision page. The second table is a finished WIP tracker. It records finished WIP and length. You can link the finished total directly from the WIP page.
The third page is a month by month word count tracker with a chart beside it. If you’re focusing on revision or administrative duties you can note it on the day. You’ll need to enter the days total here if you’ve written anything. The stats page uses the totals from this page.
The next page is a sprint tracker page. If you do sprints, you can use this to keep track of them.
This is the actual WIP tracker. There are three of them in case you work on multiple stories as I do. You can keep a copy blank and ready to go. You input your expected word count. If you don’t know enter something, you can change it later. Goal word count, by this I mean daily word count.This comes in when your writing session totals. If you make your total, the daily words cell will change color when it gives you your count. A deadline date. Again, pick a date. You can change it as long as you don’t have an actual deadline. There are also cells for percent complete, your average words, the target words per day, total words to date. There’s a completion date cell. This would be projected completion date based upon the average words. Days to completion is the last cell on the top row.
On the table, you’ll find the date, total word count, end word count, sprint total (mainly so you can keep track of days when you do sprints), Daily words, percent today, words left, percent complete, and notes so that you can keep track of important facts. You’ll find a chart to the side that will fill as your total increases.
The last page is a revision table. You can list the tasks to be revised when you check off the task, the task will strike through and be counted as percent complete.
There are instructions for this, perhaps a little too many instructions. Basically on all pages except for the revision page, you fill in the areas that are highlighted yellow or have a yellow header. I’d recommend copying the sheet and keeping a blank WIP sheet available-because copying one that already has stuff on it and erasing the data there is a pain.
Here are the links to the google sheets version and an excel version.