I saw that Kameron Hurley (who’s great blog I recently discovered) recently posted a picture of her writing spreadsheet, so I’d thought I’d share my own, or at last a sample of it. Here we go!
So as you can see, the spreadsheet is divided into several columns. The first column has the date. The second the amount of time I spent writing on that given day. The third is the total amount of time I spent on the entire writing project (so above this section is all of the time I put into the rough draft). The next is the amount of progress, word wise, I made in this particular draft. The fifth column has the total words I’ve added into this draft (remember how I wrote over 65k during NaNoWriMo? Revisions are much more time consuming, and I actually spent a little more time writing in January then in November). The final column is dedicated to notes.
Now I have a couple reasons I together a spreadsheet like this. For one, I think statistics are neato. But its mostly due to the fact that it helps keep me focused. Just like creating goals and writing them down helps to put me on my path, being able to track my progress keeps me on it. It also makes me less satisfied with doing the bare minimum. I try to write for at least an hour every day, but seeing everything laid out like this often makes me want to do a little more.
Now this part of the spreadsheet is just dedicated to my work on Hero of Darkwood. I actually have separate spreadsheets dedicated to other fiction, and the time I spend submitting my work to agents. Now this may be taking things a little too far, but hey, if it’s helpful to me, why not keep doing it?
I’d be curious to see how many other writers have spreadsheets or similar methods to track how much time they write.