Monday, November 11, 2019

NaNoWriMo 2019: Day 11

Today brought my first 2,000-word day in a week. Really happy to hit that mark again, especially on a time-limited weekday. The morning session was only 844 words. The groove of the session really kicked in...just as my alarm sounded and I had to get ready for work. 

Which meant the lunch session hit the ground running. Irritatingly, I hit the end of the session without getting to the end of the scene. Oh well, I know where I'll be starting tomorrow morning.

One of the things that keeps me going is my spreadsheet. I thought I'd share it today.

Date
Today
Pace
Diff
Pace Total
Actual Total
Total Diff
Remaining
1-Nov
2,063
1,667
396
1,667
2,063
396
47,937
2-Nov
2,724
1,667
1,057
3,334
4,787
1,453
45,213
3-Nov
2,189
1,667
522
5,001
6,976
1,975
43,024
4-Nov
2,033
1,667
366
6,668
9,009
2,341
40,991
5-Nov
1,769
1,667
102
8,335
10,778
2,443
39,222
6-Nov
1,899
1,667
232
10,002
12,677
2,675
37,323
7-Nov
1,207
1,667
-460
11,669
13,884
2,215
36,116
8-Nov
1,788
1,667
121
13,336
15,672
2,336
34,328
9-Nov
1,724
1,667
57
15,003
17,396
2,393
32,604
10-Nov
1,735
1,667
68
16,670
19,131
2,461
30,869
11-Nov
2,046
1,667
379
18,337
21,177
2,840
28,823


Date - Obvious
Today - Words written on that particular day
Pace - The 1,667 words you need to hit in order to reach 50,000 words by 30 November
Diff - Today number minus Pace. I color code it so I can get my green streak.
Pace Total - The number you get if you only write 1,667 words each day.
Actual Total - The number of words I actually wrote to date.
Total Diff - Difference between Pace Total and Actual Total
Remaining - How I'm doing relative to 50,000 words

Every addition/subtraction field has the formulas built in. The green and red are conditional formatted based on the number.

This spreadsheet helped me on 7 Nov when I didn't reach the 1,667 for the day, but I knew I was ahead of the pace overall.

Do you use a spreadsheet?

Day 1: 2,063 (47,937 remaining)
Day 2: 2,724 (4,787 total; 45,213 remaining)
Day 3: 2,189 (6,976 total; 43,024 remaining)
Day 4: 2,033 (9,009 total; 40,991 remaining)
Day 5: 1,769 (10,778 total; 39,222 remaining) *Rewrite of chapter 4 
Day 6: 1,899 (12,677 total; 37,323 remaining)
Day 7: 1,207 (13,884 total; 36,116 remaining) *First sub 1,667 day
Day 8: 1,788 (15,672 total ; 34,328 remaining) *Breakthrough on where story is going
Day 9: 1,724 (17,396 total; 32,604 remaining)
Day 10: 1,735 (19,131 total; 30,869 remaining)
Day 11: 2,046 (21,177 total; 28,823 remaining)

No comments: