I’m a new writer who’s still trying to work out how to be productive and write faster. I also love data, and track my output in a spreadsheet. Here I just wanted a place where I could post the weekly totals that I discuss in my Sunday updates, so I could see everything at a glance. I’ll be updating this every week.
This form of progress tracking replaces the one I used previously, which didn’t differentiate between editing and writing, and as a result the words per hour calculation wasn’t accurate. I also realized that I was spending a lot of my time on the business aspect of self-publishing, such as reading about marketing and promotion on KBoards, but I wasn’t tracking this at all. So when I would look back on the total amount of time I spent each week on developing this side career, it looked quite low. My old way was like tracking the production line, but paying no attention to the hours logged by the marketing division or the research and development team. This new way of tracking truly captures how much time I am spending on launching my writing career.
Key: W/E = Writing and Editing; B = Business (learning, production, marketing, management); O = Other (learning craft, outlining); WPH-W/E = Average words per Hour when writing/editing.
|Wk||Week start||W/E||B||O||TOTAL||WPH-W||WPH-E||Net words|
|W-1||Jan 26, ’15||6:15||n/a||n/a||6:15||273||–||1,707|
|W-2||Feb 2, ’15||10:10||n/a||n/a||10:10||236||–||2,533|
|W-3||Feb 9, ’15||8:05||n/a||n/a||8:05||364||–||2,365|
|W-4||Feb 16, ’15||9:22||n/a||n/a||9:22||375||–||3,435|
|W-5||Feb 23, ’15||10:25||n/a||n/a||10:25||295||–||2,768|
|W-6||Mar 2, ’15||11:16||n/a||n/a||11:16||446||–||4,367|
|W-7||Mar 9, ’15||10:19||n/a||n/a||10:19||450||–||4,955|
|W-8||Mar 16, ’15||–||n/a||6:36||6:36||–||–||735|
|W-9||Mar 23, ’15||2:31||n/a||1:20||3:51||413||–||n/a|
|W-10||Mar 30, ’15||–||n/a||–||–||–||–||0|
|W-11||Apr 6, ’15||–||n/a||–||–||–||–||0|
|W-12||Apr 13, ’15||3:02||n/a||–||3:02||572||–||2,239|
|W-13||Apr 20, ’15||9:42||n/a||–||9:42||475||2,099||476|
|W-14||Apr 27, ’15||3:44||9:41||–||13:25||–||2,735||50|
|W-15||May 4, ’15||5:33||5:17||15:17||26:07||530||4,004||1,584|