ABCDEFGHIJKLMNOPQRST
1
2
3
4
5
6
7
8
9
10
11
12
Moderator = skateman222
13
Big 20 Discord = https://discord.gg/jMpUN
14
Tutorials/Resources (in Detailed tab):
15
https://bestofnes.com/races/big20-10
16
17
18
19
20
21
22
23
24
To get your own personal sheet, type your name at the top of the summary page in the next empty column (feel free to change background and text color)
25
I will check periodically for new names and create your own personal spreadsheet where you can put in your times and customize it to your liking
26
If you have a Google account, I could also protect your sheet from being edited by anyone but your Google account
27
Just add your finished run times to the columns of run1, run2, run3, etc
28
It will automatically calculate the rest of the statistics for you such as best run, total runs and average time.
29
Format is hh:mm:ss, so a 10 minute run is 00:10:00 and a 1 hour, 30 minute run would be 01:30:00
30
You should be able to add additional columns if you run out of room - right click on the very top of the last colum and click 'add one right'
31
Sheet will calculate your Average and PB columns by following the instructions below
32
Feel free to customize your sheet and make it your own. Have fun with it!
33
To add your total PB column, click cell D23, then click the 'function' button at the top right of the icon bar at the top.
34
Click 'Sum', and while the cell is highlighted click cell D2, and highlight all cells down to D21, then press enter. Your PB column should now update
35
automatically when your enter a new PB. You can follow the same steps for the 'Average' column (or any column)
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