NaNoWriMo Progress Chart
Monday, November 5th, 2007So in my usual habit of playing with progress tracking rather than actually making progress, I made a tracking spreadsheet for NaNoWriMo that helps keep track of your daily writing and lets you know if you’re on track or not. The usual goal is 1667 words per day, but that’s only if you actually get to sit down and conquer that goal every day. If you skip a day, or if you’re a little short one day, the spreadsheet will redistribute your remaining wordcount over the remaining days of the month, which helps you to compensate much better than having to make up those lost 1667 words the very next day.
Here it is as an xls file: NaNo Progress Chart
If you don’t have Excel, you can upload it to Google Docs and use it from there, which is where I made it to begin with. You only need to update your overall wordcount (the white column) for each day, and the spreadsheet will do the rest. Your “daily quota” is how much you can expect to have to write every day for the rest of the month in order to reach 50,000 words, dependent on how much you’ve written so far. The “words to go” is how much more you’ll need to write on a given day in order to keep a quota consistent, but if you stop short of your “words to go,” the next day’s daily quota (with the red circle) is your new goal for every day of writing.

So if you miss a day, or are short for a day, it will help you plan how to get to 50,000 words anyway, rather than reminding you how dreadfully far behind you are. :)
\o/

