NaNoWriMo word count and planning- Sample

	A	B	C	D	E	F	G	H	I	K	L	M	N	O
1	Set-up: Customize yellow boxes below to use 'Day Types' in boxes to the right
2	Or just fill out daily word goal by hand in ORANGE boxes
3	Daily: Fill out BLUE boxes each day with actual word count. Everything else should fill in!
4		Type: use Name in 'Day Type' boxes (column J)	Word Count					Goal =>	50,000
5			Daily			Total			Percent Finished
6	Date		Planned	Actual	Balance	Planned	Actual	Balance	Percent Finished

7	Fri, Nov 1	Full	4000			4000				Choose names/word count for types of days. Use totals at bottom to tune for total words
8	Sat, Nov 2	500	500			4500				Total Word Goal:		50,000
9	Sun, Nov 3	Off	0			4500				Day Type			Calculate expected words
10	Mon, Nov 4	Half	2000			6500				Name: choose your own	Choose word goal for day type	Num of this day type per week	Words/week this category	Weeks working
11	Tue, Nov 5	Full	4000			10500				Full	4000	3	12000	3.25
12	Wed, Nov 6	Full	4000			14500				Half	2000	1	2000
13	Thu, Nov 7	500	500			15000				500	500	3	1500
14	Fri, Nov 8	Full	4000			19000				Other			0
15	Sat, Nov 9	500	500			19500				Other			0
16	Sun, Nov 10	Off	0			19500
17	Mon, Nov 11	Half	2000			21500				Totals: tune above numbers to get desired total			Expected words per week	Overall Total words
18	Tue, Nov 12	Full	4000			25500					Should = 7 =>	7	15500	50375
19	Wed, Nov 13	Full	4000			29500					Missing Days =>	0	Total compared to Goal	375
20	Thu, Nov 14	500	500			30000
21	Fri, Nov 15	Full	4000			34000
22	Sat, Nov 16	500	500			34500
23	Sun, Nov 17	Off	0			34500
24	Mon, Nov 18	Half	2000			36500
25	Tue, Nov 19	Full	4000			40500
26	Wed, Nov 20	Full	4000			44500
27	Thu, Nov 21	500	500			45000
28	Fri, Nov 22	Full	4000			49000
29	Sat, Nov 23	500	500			49500
30	Sun, Nov 24	Off	0			49500
31	Mon, Nov 25	Off	0			49500
32	Tue, Nov 26	Off	0			49500
33	Wed, Nov 27	Off	0			49500
34	Thu, Nov 28	Off	0			49500
35	Fri, Nov 29	Half	2000			51500
36	Sat, Nov 30	500	500			52000
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