ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
HOW TO USE THIS SPREADSHEET
2
3
You will not be able to edit my original file, only view it. Go to File > Make a Copy and save it into your own Google Drive. You will then be able to edit the copy any way you please. The original files will be available for you to make copies for subsequent projects at any time. If you want to copy it into another program like Excel, you will need to Select All > Copy > then Paste it into your own software. You will need to do this for each of the 12 monthly sheets, as well as the 'By Month' sheet with your running totals.
4
5
There is a separate sheet for each month of the year, noted numerically. Add your daily word count total (even if it's zero) in column B. Each line is for a different day of the month.
6
7
Days in a Row you will add manually.
8
9
By Month' is your master sheet with all your monthly progress totals.
10
11
This sheet is also set up to indicate whether you have met a daily word count goal, by changing the colour of the cell red or green. You can change the conditional formatting ranges and colours by selecting all the cells in column B from 3-32/33 and then going Format > Conditional Formatting. Then edit the ranges and colours as suits you and your goals best. Or just remove these rules if they're not helpful!
12
13
Consider adding a column for notes! This will be especially useful if you're trying to figure out what's preventing you from writing some days.
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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