Finally, this year, I have managed to keep up my writing spreadsheet for twelve months! I started this method of keeping track at the end of 2015, but in 2016 and 2017 I forgot about it during the summer and never resumed making entries. My research journal records some word counts for the months in which I was not using the spreadsheet, but I also use the research journal to “park” projects that have to be put aside, to work through problems that come up, and to do certain kinds of free-writing or data recording, so it’s a bit of a job to go through it looking for word counts.
Leaving aside the writing I did for my promotion application, the spreadsheet shows that I wrote about 18K words in 2018. This seems about right, as a lot of the work I did this year was on the translation (recorded as lines translated or reviewed). I’ve written two conference abstracts, a sort of place-holder document for an essay I hope to write in spring 2019 (maybe), done some work toward a set of revisions that I have repeatedly put aside because of more pressing deadlines, and, most recently, re-written the introduction to the translation. That is, I’m still working on that last, but the end is now in sight. I’ve also reviewed two sets of proofs; one of those articles is now in print, and the other will appear in 2019 (sigh . . . annuals).
For 2017, I recorded about 6000 words of writing before I forgot about the spreadsheet in June. I wrote far more than that, because that was the year I revised the most complex part of the MMP, which involved adding 3000 words and 25 footnotes to the beast. The way I work, that 3000 words probably started as at least double that number. In 2017, I also revised the article that came out this year, under pressure from an editor who is also a friend. I wouldn’t have done it without him leaning on me, because I was very worried about my aged father, but that work provided a very helpful counter-irritant to the family drama.
One thing that helped me keep up with the spreadsheet this year is that I set it up for the entire year in advance, rather than doing a month or so at a time. It probably also helped that I did not travel in summer 2018, so that my work habits didn’t suffer any large disruption or shift in place. I did neglect it during June, when our house was first on the market and I was also often feeling unwell, but my personal journal shows that I did keep working on the translation that month.
The spreadsheet is a means, not an end. It’s better to write and not keep track than to obsess about tracking at the expense of writing. Some years, the research journal is probably more helpful than a spreadsheet. There’s a lot more to research than just writing words; there’s reading, taking notes, planning, outlining, mining online databases, transcribing wills written in Secretary Hand, to name a few activities. I do have columns for “pages read” and “other” in my spreadsheet. I like the spreadsheet because it shows at a glance where my research time has gone. (I’m wondering if it might be similarly helpful to start one for teaching duties. I often put off grading because I just don’t want to get started; seeing blocks of days on which I’ve done nothing might motivate me to get on with it.) I like the research journal because re-reading it often gives me good ideas, or reminds me of old ones.
I’ve set up two years’ worth of writing spreadsheets, so now I’m covered for 2019 and 2020 (2019 is fully formatted; 2020 just has the basics, for now). We’ll see how it goes. I still have a bunch of things hanging around that I would have liked to have finished by now. But I am going to get back to my book in 2019. The two conference papers I am going to give are planned as parts of one chapter, although one of them could be a spin-off: we’ll see what happens. That “maybe” article is about a text I’m teaching this spring, so I’ll see what I can do about the article while I’m talking about the book with my class. If I make some progress and then put it down again, that’s okay.
I never feel that I am as productive as I would like to be, but the evidence shows that I’m making progress. Long-term projects are gradually coming to completion, and smaller ones also are getting done. Jonathan’s idea of mediocritas has been very helpful to me. Sometimes it’s frustrating to keep chipping away and never feel that there is much progress, but 18K words is a lot of words: even if they have to be boiled down to half that, that’s a substantial article’s worth right there.