Recently, Jamie Todd Rubin posted about how he tracks his writing progress with Evernote and a Google spreadsheet. (If you’re interested in using his method, Margaret McGaffey Fisk has an Excel spreadsheet available for download.)
I have a similar spreadsheet that I (used to) use for novel first drafts. But for over a year now, I’ve been tracking my writing in Bento. This is the same program that I use to keep a list of projects and track my submissions, and it’s convenient to have it all in one place.
Bento is a slightly simplified database program–you can’t directly hook things together (so I have to manually tell it to associate a “submission” entry to a “project” entry, but this is very easy to do).
I’ve mostly been tracking time spent, rather than word count, so that I can include planning and revision time as well. I only added a word count column and a “wrote new words today” checkbox a couple months ago, because I’d like to be producing more new stuff.
My column setup is:
Date, Project (the name of a novel, “Short Stories”, or “None” for critting or writing classes), Task (writing, revising, critting, etc), Duration (in minutes), Notes (where I type in what story I worked on, or whatever else I feel like noting), Word count (duh), New words (checked if I created new stuff, unchecked if I didn’t).
For the most part I don’t actually look at the data much. I can do basic searches to figure out how many hours I spent on X project in December, or how many hours Y short story took. The latter is something that’s becoming useful to know for planning purposes, though it doesn’t account for fermenting time.
I’m working on a project in Mathematica that will let me do a bunch more analysis and make pretty charts, but it’s been going in fits and starts. To be honest it’s more of a learn-Mathematica project than a improve-writing-productivity project (which I want to do because, and here is the disclaimer, I work for the company that makes it). I’ve nearly duplicated the functionality I’ve been getting from Bento’s search results.
For the next novel first draft, I will probably just type word counts into Bento and use Scrivener’s session targets instead of going back to my Excel spreadsheet. One less thing to mess with.