Nanowrimo 2011 Report Card

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Nanowrimo 2011 Report Card
2	This Excel spreadsheet is designed to help give you an idea of your progress without forcing you to spend all of your time with a calculator when you should be working on your novel. The only columns you should edit are the ones highlighted in orange. The rest are calculated automatically.
3		Your Personal Goal:
4		Words per day:	1667
5		Total Word Count:	50000
6
7		NaNoWriMo Health	You're falling a little behind. But don't worry, just try to write 0 words a day and you'll still make it.
8	Day	Total Word Count	Hours You Wrote Today	Number of Words Written Today	Words Per Hour	Words You Have Left	Days Remaining	Avg Words Per Day	Goal For Tomorrow	% Change in Pace	At This Rate You'll Be Done On	Percent Complete	Writing Hours Left	Your Morale	Comments	Day	Minimum	Goal	Projected Word Count	Actual Word Count	Date	Morale
9		(fill in this column)		(leave these cells blank, they'll fill in automatically)										(1=bad, 10=good)	(any comments you'd like to leave)
10	11/1						29									1	1666	1667			1
11	11/2						28									2	3333	3334			2
12	11/3						27									3	5000	5001			3
13	11/4						26									4	6666	6668			4
14	11/5						25									5	8333	8335			5
15	11/6						24									6	10000	10002			6
16	11/7						23									7	11666	11669			7
17	11/8						22									8	13333	13336			8
18	11/9						21									9	15000	15003			9
19	11/10						20									10	16666	16670			10
20	11/11						19									11	18333	18337			11
21	11/12						18									12	20000	20004			12
22	11/13						17									13	21666	21671			13
23	11/14						16									14	23333	23338			14
24	11/15						15									15	25000	25005			15
25	11/16						14									16	26666	26672			16
26	11/17						13									17	28333	28339			17
27	11/18						12									18	30000	30006			18
28	11/19						11									19	31666	31673			19
29	11/20						10									20	33333	33340			20
30	11/21						9									21	35000	35007			21
31	11/22						8									22	36666	36674			22
32	11/23						7									23	38333	38341			23
33	11/24						6									24	40000	40008			24
34	11/25						5									25	41666	41675			25
35	11/26						4									26	43333	43342			26
36	11/27						3									27	45000	45009			27
37	11/28						2									28	46666	46676			28
38	11/29						1									29	48333	48343			29
39	11/30						0									30	50000	50010			30
40
41		Completed	Total Hours Spent	Remaining	Avg Hours Per Day	Days Left		Avg Words Per Day	Days With Writing	Avg Words Per Hour	Writing Hours Remaining	Avg. Moral Per Day	Avg. Needed Per Day
42		0	0	50000	0	30		0	0	0		#DIV/0!
43
44
47
48	This spreadsheet is a deliberate copy of Erik Benson's excellent Excel Report Card. His is much better, with full-size charts and such. If you see any errors in this one, or would like additional features, please email me at kmauch@gmail.com.
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