AB
1
2
3
You earn bonus points for writing more words: 250 words = one point, 500 words = two points, 1000 words = three points, 2000 words = four points.
4
0
5
6
Find an open track in the most recent tab and add your name. Fill in your daily word count along the top line (words).
7
8
9
1 (number of levels to go up, this box will be green!)
10
11
12
-----
13
300 (new quota)
14
2 (new level)
15
(empty box, now blue or yellow, depending on your track)
16
-----
17
If you want to personalize your track with funky colors, please stick to the white/light-gray areas.
18
There's now a designated spot for your twitter handle or blog.
19
There's a spot for the title of your current project. If you specify a target word count, your words remaining will be updated for you.
20
Facebookhttps://www.facebook.com/groups/587685967914413/
21
Google+https://www.youtube.com/watch?v=jcxW_ciP5R4
22
Leveling Up
23
In the transition to the new Google Sheets, your current level probably got scrambled and you'll have to reset it. I've added some extra conditional formatting to assist with this. If you see a green box below your number, congratulations! You need to level up. Add the number in the green box to your current number and the green should reset to neutral (pale blue or yellow). If you see a red box, it means your current level is too high (an artifact of the move). Add the (negative) number in the red box to your current level.
24
About
25
The Magic Spreadsheet was created by Tony Pisculli and is currently being maintained by Derek Chamberlain. The incredible live leaderboard was created and is maintained by Travis Senzaki.
26
Archive
27
Jan 2013 — Feb 2014https://docs.google.com/spreadsheet/ccc?key=0AoK7WzmhEcBUdGVXUVFqX3dmRWtCcnJPMVdWZ1J4T0E&usp=sharing
28
Leveling Up
29
Level 02 = 495
30
Level 03 = 1,890Thanks to Mark Lindberg for these numbers [at left] showing how many points we need to level-up.
He had them posted over on the FB page but I thought it would be a good idea to put them where people could find them more easily.
31
Level 04 = 4,215
32
Level 05 = 7,470
33
Level 06 = 11,655
34
Level 07 = 16,770I've just created a Google+ community for those of you who prefer that or aren't on Facebook. I don't use Google+ much, so I'm not sure how to share the URL, or if that's even possible, but it's called "Magic Spreadsheet."
35
Level 08 = 22,815
36
Level 09 = 29,790
37
Level 10 = 37,695
38
Level 11 = 46,530Try this link:
39
Level 12 = 56,295https://plus.google.com/communities/106847484544547135997
40
Level 13 = 66,990
41
Level 14 = 78,615
42
Level 15 = 91,170
43
Level 16 = 104,655
44
Level 17 = 119,070
45
Level 18 = 134,415
46
Level 19 = 150,690
47
Level 20 = 167,895
48
Level 21 = 186,030
49
Level 22 = 205,095
50
Level 23 = 225,090
51
Level 24 = 246,015
52
Level 25 = 267,870
53
Level 26 = 290,655
54
<h2>New Text</h2>
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