Sample Writing Log 2017 (save a copy and rename me)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
Background
2
3
This spreadsheet encourages you to write consistently by setting yourself a goal of 10,000 words per month. Write between 323 and 357 words a day and at the end of 9 months you'll have enough words for an average-sized novel! If you miss a day or three, it's easy to make up in one session, which encourages you to keep coming back to your writing.
4
5
If you meet your daily goal exactly, the "Words today" cell will turn yellow. If you fall below your daily goal, it will turn red. If you exceed your goal, it will turn green. Hooray!
6
7
(I know, it sounds childish, but it's fun to see the cells turn green and even better to see them stack up. Try it!)
8
9
Instructions:
10
Copy this spreadsheet and save it to your own GDrive or hard drive. Rename it.
11
12
DO NOT TYPE in any column except "Words Today" and "Notes" (or any columns you create yourself)
13
14
In The "Words Today" column, enter how many words you wrote today. The spreadsheet will automatically calculate how many more words you need to write to reach your goal this month; how many words on averaage you need to write durin each remaining day of the month, how many word you've written this year,
15
16
If you want to aim for more than 10,000 words in a month, change the value of cell D2 ("Remaining"). Everything else should recalculate for you.
17
18
Tips:
19
20
You may want to copy all the tabs while they're empty, so you have a set of empty tabs waiting for next year (you can rename them...)
21
22
PROJECT LIST SHEET: If you juggle multiple projects, use the optional Project List sheet to assign a number to each. Each month you can use the column called "Project Number" to see how many words you are writing for each project, keep track of ebbs and flows etc. If not, ignore or delete that column.
23
24
Create a bookmark for your copy of this spreadsheet right in your browser's links bar. (Every month I edit the bookmark so that it links to this month's sheet. Yes, I am that lazy. Even having to find and click on the correct tab might make me NOT log my words. You may not care. I like to remove obstacles.) OR, on a smartphone/tablet, use Google Sheets.
25
26
BROUGHT TO YOU BY JULIE DUFFY & STORYADAY.ORG - HOME OF THE STORYADAY MAY EXTREME WRITING CHALLENGE
27
28
Copy this, use it with joy, write great stories, and, if it has been of any use, spread the word about StoryADay May as payment ;) http://storyaday.org
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Instructions
Project List
Jan17
Feb17
Mar17
Apr17
May17
Jun17
Jul17
Aug17
Sep17
Oct17
Nov17
Dec17
Form Responses 1