Decaying Word Count Tracker Spreadsheet
I have a gift for you, my lovelies. I know. You’re all excited. Decaying, you say? What does that mean? I have created a beauteous word count tracker for you.
(Skip this fluffernutter stand and go straight to just download it!)
It’s a fancy mathey way to say reverse NaNoWriMo (National Novel Writing Month) using the Reward System. In the Reward System you reward yourself at the end by only having to type one word. I didn’t do that exactly, because I wanted to be able to stretch my deadline out, and math is hard. Anyways. You start with a large word count goal and each day it counts down. But nothing explodes at the end. If you’re all excited and you get a lot of words at the start, but struggle at the end, this is the word-count goal calculator for you.
Not only does this word count tracker wind down, but this spiffy worksheet recalculates based on the words and days you have left. So say one day life happens and you get a big shiny 0. It just bumps your total down to the next day and chops it into little bits all over again.
For example. I’m attempting to write 75,000 words in 28 days.
Daily wordcount goal:
Day 1: 3800
Day 2: 3744
Day 3: 3687 (etc)
Note: Feel free to write more. If it’s coming (and if you have the time) why wouldn’t you write more? It’s not a cutoff. It’s a goal. You’re a grown up. Do what you want.
Also note: 75,000 words in 28 days is not realistic for me. I don’t think. Actually I usually have no problem getting 3,000 words in a 2 hour writing session. So close if I don’t skip any. Instead of torturing myself, I will make a concerted effort. I will see how it goes, and at the end I expect to have a good idea of when I can actually finish. Then I can just drag my formulas down for the additional days I need to add to my deadline.
You will also see some spiffy charts on the right to help motivate you. I have to say the wordcount goal countdown is a much more encouraging method that I find very motivating. It’s almost like whack-a-mole, I have the urge to squash that bugger.
The first time I tried NaNoWriMo I had something happen and I missed a couple of days. This left me with no idea how many words I needed to get, except to double up, which I did not have time for. I failed and it’s TRAGIC.
Even if NaNoWriMo just doesn’t work for you, you can still set aside some concentrated time to work. If you add rows at the bottom of this spreadsheet you can extend your deadline. Copy that last row, pull it down, and paste. Voila! Two months to work. Or three. Or thirteen. Or something more realistic than one. You can use this for AnyNoWriMo or AlltheNoWriMos. I’m using this for my FebNoWriMo.
Download sparkly Decaying Word Count Tracker Spreadsheet for YourNoWriMo:

Download zip file with .xlsx file
Edit the start and end date, the total word count, and add your actual word counts as you go.
Other fun word trackers:
If you want a pretty word tracker for anytime check out Svenja
If you want a classic NaNo-type tracker you can use for AnyWriMo try Justin McLachlan
If you’re willing to pay you might like the Writing and Revision Tracker from Jamie Raintree
On a side note, you can use Beat Sheets to estimate if you’re where you need to be in the novel with Jami Gold
Troubleshooting: If you break it I can’t help you, except to break it more. My husband charges an exorbitant rate. I suggest redownloading or asking Google.
Thank you to hubby for doing the hard math!
UPDATE:
The decaying word count tracker worked out ok. The problem is if you miss a day it starts snowballing on you. So my chart started looking scary when I got sick. Luckily, I vastly overestimated how many words I needed for my draft. I’m still new at this, I had no idea what I should be aiming for.
Here is what the chart would have looked like for a regular NaNoWriMo goal:
Here is what the chart looked like with my actual word count:
Pingback:MyNoWriMo Report - How I Did & What I Learned - M D Flyn
Thank you! I’m excited to use this tracker. Love the idea of it counting down!