2019 Component OPR Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Instructions:
4
1. File > Make a copy > [choose a name] > Save
5
2. Use the "add_events_here" tab and "event to copy" box to add new events (takes a while)
6
3. Use the same tab and "event to remove" box to remove events, or click on the tab > Delete and repeat for all 3 tabs with the event key in it
7
4. You can delete this tab but not the "add_events_here" tab
8
9
To edit on mobile:
10
1. Add an event like normal (needs to be done from desktop)
11
2. Run by selecting the desired function from cell B4 on tab [event key]
12
13
Have other questions/issues or found a bug? Contact me on Chief Delphi (Rachel_Lim) or at rachellim@berkeley.edu
14
15
16
Details on OPR calculations:
17
OPR calculations are displayed on the tab named [event key]_opr
18
Columns ending with "_opr" are OPR calculations
19
Columns ending with "_avg" are just averages of that score breakdown for all the matches that team played in
20
Columns ending with a "(%)" are percentages of time that action was achieved for actions tracked per robot (sandstorm crossings per level, endgame climb)
21
Cargo ship averages subtract out preloaded hatches and cargo. Cargo that was preloaded, ejected, and then scored in teleop are therefore not included in the averages
22
Endgame averages do not include matches where a robot never crossed the hab line but started on a hab level
23
If there are other fields I didn't include but that you think that would be useful, please let me know and I'll add them
24
25
All fields in the [event key] tab are directly from TBA's API
26
27
28
29
30
31
32
33
34
35
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