Lognormality > NaNoWriMo Tracker v.02

21 November 2009 | | categories: projects | blog archive

NaNoWriMo Calendar 2012 Fresh Ribbon A by Monda photo credit: Monda

-[ background ]-  

This is the sixth year that I’ve participated in NaNoWriMo, and (at least) the third year that I have used a spreadsheet to track my word count. Given that, as any WriMo knows, half (or more) of NaNoWriMo is spent avoiding actually writing one’s novel, I’ve spent far too long on this. The version from 2007 is lost, I’m afraid, but the sheet I created in 2008 has survived (and been tweaked incessantly so far this year). And that, dear reader/writer, is what I’m bringing to you. Behold!

Why am I “releasing” this? After all, there are over 300,000 hits when one googles “nanowrimo word count.” Not all of these are trackers, but you get the idea. There are web-based trackers and there are other Excel-based trackers.

Why, you ask? I figured that someone somewhere might find a use for it. Maybe I should have googled this before I built my own, though…but I still like it. Besides, it has given me a way to procrastinate during the past two Novembers.

Using it should be pretty intuitive, I think, but comment if you need help. It makes several assumptions (ie., dates are for November, total word count goal is 50,000, etc.), though these should be easy to change if you’re familiar with Excel. Perhaps there will be another version later that allows these to be variable. We shall see!

-[ features ]-

  • Daily and total word count
  • Best day
  • Average day (including zeroes)
  • Average writing day (excluding zeroes)
  • Pace
  • Projected completion date (updated daily)
  • Oodles of other statistics, many of which are redundant
  • Charts!

-[ screenshots ]-

Check out these screenshots! See how far behind I am!

The Tracker Itself

The Tracker Itself

Summary Statistics

Summary Statistics

Total Chart, showing performance relative to target

Total Chart, showing wordcount relative to goal for the month

Daily Chart, showing wordcount relative to goal on a daily basis

Daily Chart, showing wordcount relative to goal on a daily basis

-[ license ]-   Creative Commons License NaNoWriMo Tracker v.02 by Scumdog Steev is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

-[ download ]-  

[ releases ] [ all files ] [ Excel 2003 version ] [ Excel 2007 version ]