My Writing Spreadsheet

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!January Spreadsheet

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s