The NaNoWriMo Tracking Spreadsheet – 2009 Edition

Returning with a colourful visual refresh this year is my much loved NaNoWriMo tracking spreadsheet!

Its features include:

  • Automatic calculation of your word count for the day, words per minute and total remaining word count.
  • Automatic formatting indicates your progress towards the daily 1667 words target. (And bonus colours if you reach 5000!)
  • Smart charts showing your word counts, typing speed and overall progress.
  • Sheets are protected to prevent accidental changes to automatic cells, but can be unlocked to customise the sheet and targets.

Spreadsheet View

Progress PieWord Count Typing Speed

I recommend that you download the version for Microsoft Office Excel 2007:Download Office Open XML Excel Workbook

If you have an older version of Office (XP or 2003) and can not open this file, please use this version instead:

Download legacy Excel Workbook

Tags: , ,

This entry was posted on Sunday, October 25th, 2009 at 4:43 PM and is filed under NaNoWriMo. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

4 Comments

  1. Gab says:
    25/10/2009 at 5:40 PM

    Very nice! Thank you so much, Nido. :)

  2. Leah Marie says:
    29/10/2009 at 6:08 PM

    Just downloaded this and its freaking awesome. Thank you so much.

  3. Sean Hoade says:
    30/10/2009 at 1:51 PM

    This is SOOOOO very awesome! Thank you for contributing this priceless widget, seriously.

  4. Stephanie Marie says:
    03/11/2009 at 4:03 PM

    Very cool. Very helpful. You’re a lover.