Saturday, January 07, 2012

Tracking spreadsheet for #WIP500

Because I'm writing offline, I'm finding it difficult to keep up with my daily totals. I'm writing them down, sorta, in my notebook, but I've been bad about it. I'm marking which day is which, but I don't want to re-count each time.

So I made a simple spreadsheet on Google Docs. See, I love spreadsheets... I'm not GOOD at them, but I love them. Eventually, I hope to have progress charts, reports, all kinds of things to show off how I did month-to-month and such, but for now, it's just the basics. I have it tracking your best day, how many days you've entered a count for, average words per day, totals, and the percentage of the total you've got so far.

I also have it flagging days you wrote under 500 with red, and over 500 with green.

Here's the clean copy so you can download it for your own use if you'd like to. Feel free to redistribute, edit, do whatever to your own copy. :)

My personal progress (which is terribly inaccurate for the first 6 days, because I kinda guessed based on G+ posts and what my totals are on Cara's site) can be found here.

I plan to continue adding to it as I figure out how to make Docs display the data in a useful way. I like charts.

3 comments:

Brooke R. Busse said...

I love that! The challenge is also quite admirable.

Anonymous said...

My husband saw me tracking my progress in a plain text file and he's very keen on making me a spreadsheet. If he wasn't doing that for me, I'd download yours. It's cool you're making it available for everyone!

Happy Writing!

Heather Dudley said...

I'm glad you guys like it... it's been fun so far, and I haven't felt this motivated to write in years. If you haven't started the challenge... give it a shot!