About a month ago, I automated the process of capturing how much time I spend writing each day, and incorporated that data into my Google Doc Writing Scripts. Here is how this work:
- I use RescueTime on all of my computers, home and work.
- RescueTime tracks how much time I spend in various applications, including specific documents.
- Using the RescueTime API, I wrote a script that captures how much time I spend in Google Docs each day.
- That number gets recorded in my writing spreadsheet automatically each night.
This means I no longer have to “clock in” or “clock out” to track my writing time. I just start writing, stop writing, continue later, etc. and all of it captured automatically by my script. With almost a month of this type of data on the books, it’s interesting to look at how my guesses match reality.
Generally, when I’m firing on all cylinders, I can write 6 pages (1,500 word) per hour. Put another way that is about a page every ten minutes. Of course, I don’t always reach this apogee of output. It turns out (with about 30 days worth of data to go on) that the correlation between the time I spend writing and how much I write is pretty strong (0.59). I took the data and ran a scatter plot, with a trendline using that correlation, and here is the results:
It is clear that the more time I spend, the more I write, but it’s not as strong a correlation as you might think. Part of the reason is that sometimes, it takes a while to get things out of my head. Here is what that same set of data looks like plotted individually over time. First the word counts…
and then the time spent…
These two charts illustrate that while the correlation is pretty strong, there are times when I clearly get bogged down. August 5 is a good example. I wrote just about 1,200 words, but it took me 79 minutes. And yet on August 7, I wrote 1,600 words and it took me under an hour. This variability is caused by two things:
- Concentration. Sometimes, in difficult scenes, I slow way down to think things through and work them out. Remember, I generally don’t plot ahead, so especially in first draft, I’m working out things on the fly.
- Interruptions. I’ve talked about how in order to write every day, I’ve had to learn to write with distraction. Sometimes, the kids will need me for something, I’ll step away for 5 or 10 minutes with no progress on the document, and then return and write more. That clearly shows up as slower.
But that red trendline in the first chart is pretty accurate, and comes close to my intuitive guesses. I have said that I wrote about 500 words in 20 minutes. That’s 1,000 words in 40 minutes. If you look at the 1,000 word-mark on that first chart, and then go up to where the red trendline crosses the 1,000 word-mark, it’s right about the 40-45 minute mark. My intuition is pretty accurate! You’ll also note that 1,500 words crosses at right about the 60 minute mark.
I have less than 30 days of the time data, but as this volume of data increases, I expect the trendline to become more accurate. One thing that is particularly useful about a chart like this is that it can tell you for a given amount of time you have available, how much you can accomplish. Or, flipping it around, if you want to write 1,000 words, how much time will you need to set aside?
I wanted to call this out one more time. All of the data above is generated automatically. I don’t spend a single instant of my time collecting it. That is perhaps the biggest value. Once I wrote the scripts (which I did spent time on) I get the data without any effort, and this can be used to help me make adjustments down the road.
You can see my realtime data, including how much writing I’ve done at various intervals (my ongoing writing streak, for example) and how much time I’ve spent writing. Head on over to open.jamierubin.net to check it out.