Match Schedule
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWX
1
158564093140650836538Blue PilotRed PilotBlueRedNext match to scout:
2
258035472502613391754265Blue PilotRed PilotBlueRed68
3
342193158581643524033229Blue PilotRed PilotBlueRed
4
424853316632597329283824Blue PilotRed PilotBlueRedScoutColor
5
5247826421477218365606304Blue PilotRed PilotBlueRedDanielRad
6
695538344191288110021011Blue PilotRed PilotBlueRedVickyOrage
7
71153656361614414144723Blue PilotRed PilotBlueRedEmilyYella
8
8437145612468427667055970Blue PilotRed PilotBlueRedAndrew / ElleGr[ae]n
9
96241482265534024886388Blue PilotRed PilotBlueRedJeyanBluFALSE
10
1045904592382640604415499Blue PilotRed PilotBlueRedPallaviPizurple
11
1139912905561415745515418Blue PilotRed PilotBlueRed
12
125816650817595510021477Blue PilotRed PilotBlueRedPilot ScoutsColor
13
1397354723316315821831011Blue PilotRed PilotBlueRedMichaelBluer
14
14264265602403265524852468Blue PilotRed PilotBlueRedClaireRedder
15
155803435597024786244590Blue PilotRed PilotBlueRed
16
163656304148244129054265Blue PilotRed PilotBlueRedSubstituteColor
17
17488418382631401151339Blue PilotRed PilotBlueRedCameronGr[ae]y
18
18636142194060437128815614Blue PilotRed PilotBlueRedNicholasPink?
19
19614467055499340264095026Blue PilotRed PilotBlueRedTroyCyan
20
2045616388141415745853824Blue PilotRed PilotBlueRed
21
21551529288427645923834Blue PilotRed PilotBlueRedRobot StatusColorFormula
22
22365339914723632532294191Blue PilotRed PilotBlueRedCompleteWhite with Strikethrough=COUNTIFS(INDIRECT("ScoutData!$B$2:$B"),B1, INDIRECT("ScoutData!$C$2:$C"), ROW(B1))=1
23
23265510025803437163044060Blue PilotRed PilotBlueRedMatch off by up to 2Black=COUNTIFS(INDIRECT("ScoutData!$B$1:$B"),B1, INDIRECT("ScoutData!$C$1:$C"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$C$1:$C"), CONCAT("<", (ROW()+2)))=1
24
249732468549942656361435Blue PilotRed PilotBlueRedToo Many DatapointsRed=COUNTIFS(INDIRECT("ScoutData!$B$1:$B"),B1, INDIRECT("ScoutData!$C$1:$C"), concat(">", (ROW()-2)), INDIRECT("ScoutData!$C$1:$C"), concat("<", (ROW()+2)))>1
25
25624288148833166705175Blue PilotRed PilotBlueRed
26
2641854722403864091414Blue PilotRed PilotBlueRedPilots StatusColorFormulaAlt (Blue)
27
27218341916144459014822485Blue PilotRed PilotBlueRedCompleteWhite with Strikethrough=(COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$B1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$C1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$D1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$B1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$C1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$D1, INDIRECT("ScoutData!$W$2:$W"), ROW()))=2=(COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$E1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$F1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$G1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$E1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$F1, INDIRECT("ScoutData!$W$2:$W"), ROW()) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$G1, INDIRECT("ScoutData!$W$2:$W"), ROW()))=2
28
2863253140656013399551574Blue PilotRed PilotBlueRedMatch off by up to 2Black=(COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$B1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$C1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$D1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$B1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$C1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$D1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2)))=2)=(COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$E1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$F1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$G1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$E1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$F1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$G1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2)))=2)
29
29581638263824551550265614Blue PilotRed PilotBlueRedToo Many DatapointsRed=COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$B1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$C1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$D1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$B1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$C1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$D1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2)))>2=(COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$E1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$F1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$X$2:$X"),$G1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$E1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$F1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2))) + COUNTIFS(INDIRECT("ScoutData!$AD$2:$AD"),$G1, INDIRECT("ScoutData!$W$2:$W"), CONCAT(">", (ROW()-2)), INDIRECT("ScoutData!$W$2:$W"), CONCAT("<", (ROW()+2)))>2)
30
30365342761011472314776388Blue PilotRed PilotBlueRed
31
3165083834340245923229365Blue PilotRed PilotBlueRedAlliance StatusColorFormulaAlt (Blue)
32
3242192478115456129052928Blue PilotRed PilotBlueRedTeleopHighFuel off by 50%Dark Blue=AND(OR(((INDIRECT(CONCAT("ErrorTester!J", 1+ROW())))/(INDIRECT(CONCAT("ErrorTester!K", 1+ROW()))))>1.5,((INDIRECT(CONCAT("ErrorTester!J", 1+ROW())))/(INDIRECT(CONCAT("ErrorTester!K", 1+ROW()))))<0.67), NOT(INDIRECT(CONCAT("ErrorTester!K", 1+ROW())) = ""))=AND(OR(((INDIRECT(CONCAT("ErrorTester!L", 1+ROW())))/(INDIRECT(CONCAT("ErrorTester!M", 1+ROW()))))>1.5,((INDIRECT(CONCAT("ErrorTester!L", 1+ROW())))/(INDIRECT(CONCAT("ErrorTester!M", 1+ROW()))))<0.67), NOT(INDIRECT(CONCAT("ErrorTester!M", 1+ROW())) = ""))
33
333991264258544159703158Blue PilotRed PilotBlueRedAutoHighFuel off by 50%Dark Green=AND(OR(((INDIRECT(CONCAT("ErrorTester!F", 1+ROW())))/(INDIRECT(CONCAT("ErrorTester!G", 1+ROW()))))>1.5,((INDIRECT(CONCAT("ErrorTester!F", 1+ROW())))/(INDIRECT(CONCAT("ErrorTester!G", 1+ROW()))))<0.67), NOT(INDIRECT(CONCAT("ErrorTester!G", 1+ROW())) = ""))=AND(OR(((INDIRECT(CONCAT("ErrorTester!H", 1+ROW())))/(INDIRECT(CONCAT("ErrorTester!I", 1+ROW()))))>1.5,((INDIRECT(CONCAT("ErrorTester!H", 1+ROW())))/(INDIRECT(CONCAT("ErrorTester!I", 1+ROW()))))<0.67), NOT(INDIRECT(CONCAT("ErrorTester!I", 1+ROW())) = ""))
34
345472248543714184355816Blue PilotRed PilotBlueRedIncorrect ClimbsDark Red=AND(NOT(INDIRECT(CONCAT("ErrorTester!B", 1+ROW()))=INDIRECT(CONCAT("ErrorTester!C", 1+ROW()))), NOT(INDIRECT(CONCAT("ErrorTester!C", 1+ROW())) = ""))=AND(NOT(INDIRECT(CONCAT("ErrorTester!D", 1+ROW()))=INDIRECT(CONCAT("ErrorTester!E", 1+ROW()))), NOT(INDIRECT(CONCAT("ErrorTester!E", 1+ROW())) = ""))
35
3514141751482549947231011Blue PilotRed PilotBlueRed
No data in yet, but match played
Brown=INDIRECT(CONCAT("ErrorTester!C", 1+ROW()))="N/A"=INDIRECT(CONCAT("ErrorTester!E", 1+ROW()))="N/A"
36
365026815743656242468Blue PilotRed PilotBlueRed
37
37100261446560365329053824Blue PilotRed PilotBlueRed
38
38459026552881456165086325Blue PilotRed PilotBlueRed
39
39133945926705630431586361Blue PilotRed PilotBlueRed
40
404416388218329284884219Blue PilotRed PilotBlueRed
41
415515382611526429736409Blue PilotRed PilotBlueRed
42
42597033163991383424033140Blue PilotRed PilotBlueRed
43
435614955322958032478585Blue PilotRed PilotBlueRed
44
44427614774265419140603402Blue PilotRed PilotBlueRed
45
456304101165086246144418Blue PilotRed PilotBlueRed
46
46133945614414352485175Blue PilotRed PilotBlueRed
47
4710022183597067051158Blue PilotRed PilotBlueRed
48
4832293991636163889733826Blue PilotRed PilotBlueRed
49
4929055852403437145903402Blue PilotRed PilotBlueRed
50
50315855153140147724681482Blue PilotRed PilotBlueRed
51
5136531414955502640603834Blue PilotRed PilotBlueRed
52
524886325365656056145472Blue PilotRed PilotBlueRed
53
53580342763316421926425499Blue PilotRed PilotBlueRed
54
54382441916409265515744592Blue PilotRed PilotBlueRed
55
55472358162881247842652928Blue PilotRed PilotBlueRed
56
561752403614432299733140Blue PilotRed PilotBlueRed
57
5734021482561439916560435Blue PilotRed PilotBlueRed
58
58955365418365324682183Blue PilotRed PilotBlueRed
59
5945924219585670526555472Blue PilotRed PilotBlueRed
60
60147758032905640933164561Blue PilotRed PilotBlueRed
61
6143711339101124784418Blue PilotRed PilotBlueRed
62
62383445906361264258161574Blue PilotRed PilotBlueRed
63
6328814265315859703824115Blue PilotRed PilotBlueRed
64
6441916304292850265499488Blue PilotRed PilotBlueRed
65
65248540604723551563886508Blue PilotRed PilotBlueRed
66
6638266241414100263254276Blue PilotRed PilotBlueRed
67
6726424352905322910116705Blue PilotRed PilotBlueRed
68
68426583991421945906560Blue PilotRed PilotBlueRed
69
6944126555026218331402881Blue PilotRed PilotBlueRed
70
7024034882478147765081574Blue PilotRed PilotBlueRed
71
71638831583834632558036144Blue PilotRed PilotBlueRed
72
724276175561464091156304Blue PilotRed PilotBlueRed
73
735499100258524855515365Blue PilotRed PilotBlueRed
74
74246813394191141458163316Blue PilotRed PilotBlueRed
75
7563613653973456134025472Blue PilotRed PilotBlueRed
76
764060418382462447235970Blue PilotRed PilotBlueRed
77
7729289554592148238264371Blue PilotRed PilotBlueRed
78
78147732295499856142655Blue PilotRed PilotBlueRed
79
796560101111558165026585Blue PilotRed PilotBlueRed
80
804414219630497314146508Blue PilotRed PilotBlueRed
81
8129053402246828813834175Blue PilotRed PilotBlueRed
82
82264247234590547231401002Blue PilotRed PilotBlueRed
83
8359702478418148263616325Blue PilotRed PilotBlueRed
84
84315838244354884276955Blue PilotRed PilotBlueRed
85
8564092928406036513393991Blue PilotRed PilotBlueRed
86
8621834561624551541912403Blue PilotRed PilotBlueRed
87
87459243714265638861443316Blue PilotRed PilotBlueRed
88
88670515742485365358033826Blue PilotRed PilotBlueRed
89
89148250266508427663612642Blue PilotRed PilotBlueRed
90
9064095970459048814143229Blue PilotRed PilotBlueRed
91
91406058166325821832905Blue PilotRed PilotBlueRed
92
922478437136517541913158Blue PilotRed PilotBlueRed
93
93670524031002638813395614Blue PilotRed PilotBlueRed
94
94314034021011248538244219Blue PilotRed PilotBlueRed
95
9555153653331626556304435Blue PilotRed PilotBlueRed
96
9645615853834382642654723Blue PilotRed PilotBlueRed
97
97624549995514771153991Blue PilotRed PilotBlueRed
98
986560973459258034182881Blue PilotRed PilotBlueRed
99
9961441574246854724412928Blue PilotRed PilotBlueRed
100
100331656143158459036535026Blue PilotRed PilotBlueRed
Loading...