November 3, 2009 12:15 PM
NaNoWriMo word count tracker

Each year, I use someone else's spreadsheet to track how I'm doing throughout the month. They've never quite been up to par for my taste, so I made my own.


Keep in mind, this relies heavily on conditional formatting to tell you how you're doing, so it only works in Microsoft Excel 2007. If there's interest, I can make a copy available that'll work on older versions, too. 

This sheet keeps track of your daily word count, the percentage completed, your average words per day and will tell you, if you fall behind, or get ahead, how much you can adjust your daily word counts and still reach your goal. The colors and symbols on the sheet adjust depending on how well (or how not well) you're doing. I'm shooting for 60,000 instead of NaNoWriMo's 50,000 -- so the monthly goal is customizeable, too. Just pop in what ever word count you're aiming for. The second sheet is the same, I just loaded it with some sample data so you can get an idea of what things will look like as you go through the month.

Good luck!

Blog Widget by LinkWithin


Comments

  • Vale
    It's AWESOME!!! thank you so much!
  • Peter
    I love this! Thanks very much, I'll be using this for the rest of the month especially since I figured how to convert it over to OpenOffice format.
  • Glad you like it! Is it working okay?
  • Fabulous! All the other word trackers I've found are cumbersome and I had to scroll all over the place to find a bunch of numbers I don't even care about. Yours is clean and ultimately usable. Thanks!
  • Glad you like it. Wondering what I can do to tweak it for next year...
blog comments powered by Disqus