As many of my followers will know, I really like planning and tracking data. This year I’ve been using a very complicated spreadsheet to manage my writing projects. I’m not aware of one with similar scope out there, so I thought I’d offer up the 2017 version for others.
The sheet tracks ten projects across four aspects–wordcount, pages edited, research time and marketing time. There is a simple instruction page included, but once you’ve set up your first project, it’s fairly self-explanatory.
Screenshots of bits of last year’s below to give you an idea of what to expect. Links to download the excel sheets from Dropbox are at the bottom (sheets are saved as .xlsx, which should work in OpenOffice variants too. If you need another format, message me). Any questions or queries, drop me a comment. Hopefully, some of you will get some use out of these.
I’ve had a go at different colour schemes (they don’t look right in the Dropbox preview but what you see below is what you should get once they’re downloaded):
ETA: If you downloaded one of these before January 1st, monthly research and marketing targets will not be calculated correctly. The problem is now fixed.