Now, granted, with some of the new stats on the My NaNo pages (have you SEEN those? Cuz they're awesome!) some of the spreadsheet is superfluous, but nevertheless I'm still using it.
I'll show you the completed one from 2009, since the 2010 once is identical, just not filled out as much since we're only a week into it.
Here's a screenshot:
The above is where I actually make changes. The document automatically fills in the Red zeroes in the "Words Written" Column. All I have to do is type in the words I wrote that day and everything else is calculated. It also automatically turns green. In the "Over/Under" column you can see how many words I was ahead or behind for that day. So on day 10 you can see I wrote an extra 10 words (it says -10 due to the math involved, but you can see it's green which is good) whereas on Day 11 I didn't write any words, so I was 1667 words behind (red = bad)
The next column is a simple Count Up - it tells me how many words I've written in total up to that point. Then there's the "Total Remaining" column which tells me how many total words I have to write before I reach 50,000
This part of the spreadsheet is just a chart. Mostly I included this because it's a pain to try and see your chart on the website when there's a lot of traffic. Also, I like visible representations. The red bars are what I wrote for that day, the black bars are where I was supposed to be (don't ask me why there's not a black bar for day 30.)
At the top of the Spreadsheet I just keep a running total of how much I've written and how much I have to go, so I don't have to do a lot of scrolling around.
So that's it. It's colorful, which I like, and provides me with a lot of data.
If anyone would like a copy, I'd be happy to email you the blank template. Just send me an email (my email on my profile is up to date)
Anyone else keep a spreadsheet or a NaNo measurement system outside of the website?