The Amazing Mechanical Wordcount Tracker

The Amazing Mechanical Wordcount Tracker

Game on…

If you’re anything like me, then you’re a bit of an obsessive with an addiction to custard creams. And if you’re a writer who writes regularly, you also probably get some satisfaction from tracking your wordcount as the days tick past.

I find it motivating to do this: to tally the daily wordcount and see those totals rise and those targets begin to get a bit closer.

To that end, I’ve created my trusty Amazing Mechanical Wordcount Tracker™ spreadsheet which does all sorts of (semi) clever stuff behind the scenes, allowing me to type in my daily wordcount and see — at a glance, ladies and gentlemen — how I’m progressing.

It shows me my weekly totals (against targets), changes colours when I meet or exceed targets and draws a nice chart showing how far away I am from my 2014 wordcount goal.

Which adds a certain amount of reward / gratification to things. Gamifying the wordcount, if you like.

Well, it works for me.

Note: I do not have a similar spreadsheet to track my custard cream consumption. (Though perhaps I should…)

Your FREE copy of The Amazing Mechanical Wordcount Tracker

Progress so far...For users of Google Drive, here is a free copy of The Amazing Mechanical Wordcount Tracker.

To access this for your own use, follow the link above to open the spreadsheet in Google Drive, then choose File>Make a copy… from the menu at the top left. This will create a copy of the spreadsheet for your own personal use on your own Google Drive account.

From there, you can change the target daily wordcount (currently set at 1,500) in cell Q1. All the totals and targets should update to whatever your own target wordcount is.

The ‘Target’ column will change colour (from red to blue) if you exceed your weekly wordcount. At present, the colours of the daily cells will also change, although this is ‘hard set’ to change based on my own daily wordcount of 1,500 (due to a Google limitation, your own wordcount figure isn’t automatically picked up).

To change this, highlight all the cells containing the daily counts (cell B2 in the top left through to cell H53 at the bottom right). Then select the Format>Conditional formatting… menu item.

You will see the rules have already been set, based on a wordcount of 1,500. Change these to reflect your own daily wordcount (e.g if you’re aiming for 1,000 words a day, change the first number to 1,000 and the second to 999). That should do it – the daily wordcount columns will now change colour (to blue) when you meet or exceed your daily target!

Disclaimer: Use entirely at your own risk. I will not be held responsible if anything – including your brain – breaks as a result of using this spreadsheet.

Loading Facebook Comments ...

Leave a Reply

Your email address will not be published. Required fields are marked *