{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Enter Information Here","Wall Poster","3-4 Format","Pool Points Calculator","Playoff Brackets","Runner Up Playoff","Results Report"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Instructions"]
[]
[null,null,"Disclaimer:  "]
[null,null,"This program was conceived my Mike McDonnell and reconfigured by Sean MacDonald into a different format.  "]
[null,null,"I (Sean) am not an Expert at Excel and it's possible there could be bugs.  Please contact the New England Region if you see a problem with the sheet"]
[null,null,"2019: I (Mike) reconfigured the reconfiguration to meet the 2019 Open Format for NERVA. There is no Substitute for the Incredible work he (Sean) Did! "]
[]
[null,null,"What's different from the old program?:"]
[]
[null,null,"1.  The new program uses a \"macro\" to function properly.  You will see a security warning near the top about disabled content. "]
[null,null,"     You must choose to enable this content for the program to work."]
[]
[null,null,"2:  The new program has a different screen to enter the scores.  Scores are entered in a way that follows the pool schedule"]
[]
[null,null,"3:  The new program will automatically breaks head to head ties that will not eliminate a team from the championship."]
[]
[null,null,"4.  If there is a 2, 3, or 4 way tie that requires a 15 point play in game, the program will fill in a bracket with the play-in teams and it lists the work team.  "]
[null,null,"     When you enter the scores of the play-in games, it will advance the winner, and when all play-in sets are complete, it will list the final pool standings"]
[null,null,"     The brackets are located below the pool standings"]
[]
[null,null,"5.  After the pool standings are complete, the program will fill in the championship and consolation brackets with the appropriate teams on the next tab."]
[null,null,"     There are 2 tabs.  One with a championship and consolation bracket for open play or as an option for club tournaments.  The other is the championship bracket"]
[null,null,"     only, in tournaments where only the top 2 from each pool advance and the 3rd place team works the playoffs.  It can be ignored or hidded for open tournaments"]
[null,null,"     "]
[null,null,"6. After the tournament is complete, it will list the teams in order of finish.  Teams that are tied for 3rd, 5th or 7th are not listed in a particular order "]

{"sheet":"Enter Information Here","index":1,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,0,10,2]]}
[]
["Seed","Team Name"]
[1,"Team 1 Pool A",null,null,null,null,null,"Tournament Date"]
[2,"Team 1 Pool B"]
[3,"Team 2 Pool B",null,null,null,null,null,"Tournament Site"]
[4,"Team 2 Pool A"]
[5,"Team 3 Pool A",null,null,null,null,null,"Age Group"]
[6,"Team 3 Pool B"]
[7,"Team 4 Pool A",null,null,null,null,null,"Tournament Level"]
[8]
["All Times are Estimates - Times Below For 4-Team Pool",null,null,null,null,null,null,"Host Club"]
["First Match (Round 1)","09:00:00","00:50:00"]
["Round 2",{"$f":"SUM(B12+$C$12)","v":"09:50:00"},null,null,null,null,null,"Tournament Director Name"]
["Round 3",{"$f":"SUM(B13+$C$12)","v":"10:40:00"},null,null,null,null,null,"TD Phone Number"]
["Round 4",{"$f":"SUM(B14+$C$12)","v":"11:30:00"}]
["Round 5",{"$f":"SUM(B15+$C$12)","v":"12:20:00"}]
["Round 6",{"$f":"SUM(B16+$C$12)","v":"13:10:00"},null,null,null,null,null,"Results entered by"]
[null,null,null,null,null,null,null,"Email"]
["Semi-Finals Round One",{"$f":"SUM(B17+$C$12)","v":"14:00:00"},"00:35:00"]
["Semi-Finals Round Two",{"$f":"SUM(B19+$C$19)","v":"14:35:00"},"00:35:00"]
["Runner Up Round",{"$f":"B20+C20","v":"15:10:00"}]
["Finals",{"$f":"SUM(B21+$C$20)","v":"15:45:00"}]
["Finish Time",{"$f":"SUM(B22+$C$20)","v":"16:20:00"}]
[]
["Total Run Time",{"$f":"SUM(B23-B12)","v":"07:20:00"}]
[]
[]
["Enter Division:"]

{"sheet":"Wall Poster","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[9,1,9,2],[0,0,0,5],[1,0,1,5],[2,0,2,2],[3,1,3,2],[8,0,8,2]]}
["NERVA Club Tournament Format"]
[]
["Pool - B"]
["Seed","Team Name",null,null,"Won","Lost"]
[1,{"$f":"'3-4 Format'!C4","v":"Team 1 Pool B"}]
[2,{"$f":"'3-4 Format'!C5","v":"Team 2 Pool B"}]
[3,{"$f":"'3-4 Format'!C6","v":"Team 3 Pool B"}]
[]
["Pool - A"]
["Seed","Team Name",null,null,"Won","Lost"]
[1,{"$f":"'3-4 Format'!H4","v":"Team 1 Pool A"}]
[2,{"$f":"'3-4 Format'!H5","v":"Team 2 Pool A"}]
[3,{"$f":"'3-4 Format'!H6","v":"Team 3 Pool A"}]
[4,{"$f":"'3-4 Format'!H7","v":"Team 4 Pool A"}]
[]
["Pool play will be 2 - 21 point sets (Start at 4-4 and ending at 25)"]
[" Rules for implementing a cap may be announced at coaches meeting."]

{"sheet":"3-4 Format","index":3,"n_rows":90,"n_cols":12,"rows_kept":90,"cut":false,"hidden":false,"merged":[[68,8,69,8],[77,2,77,9],[84,8,85,8],[80,0,81,1],[87,0,88,1],[72,0,73,1],[4,0,4,1],[5,0,5,1],[16,0,16,1],[50,0,51,1],[23,0,23,1],[20,0,20,3],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[22,0,22,1],[23,2,23,3],[61,2,61,9],[65,0,66,1],[53,8,54,8],[57,0,58,1],[6,3,6,4],[6,0,6,2],[16,2,16,3],[44,2,44,9],[46,0,46,1],[17,2,17,3],[18,2,18,3],[19,2,19,3],[21,2,21,3],[22,2,22,3],[47,6,60,6],[13,1,13,9],[0,0,0,1],[0,2,0,8],[1,2,1,7],[2,0,2,1],[3,0,3,1]]}
[{"$f":"'Enter Information Here'!B28","v":0},null," NERVA Tournament Format",null,null,null,null,null,null,{"$f":"'Enter Information Here'!B28","v":0}," "," "]
[]
["Pool Seed",null,"Pool - B","Schedule","Work Team",null,"Pool Seed","Pool - A","Schedule","Work Team"]
[1,null,{"$f":"'Enter Information Here'!B4","v":"Team 1 Pool B"},"1  vs  3",2,null,1,{"$f":"'Enter Information Here'!B3","v":"Team 1 Pool A"},"1 vs 3",2]
[2,null,{"$f":"'Enter Information Here'!B5","v":"Team 2 Pool B"},"2  vs  3",1,null,2,{"$f":"'Enter Information Here'!B6","v":"Team 2 Pool A"},"2 vs 4",1]
[3,null,{"$f":"'Enter Information Here'!B8","v":"Team 3 Pool B"},"1  vs  2",3,null,3,{"$f":"'Enter Information Here'!B7","v":"Team 3 Pool A"},"1 vs 4",3]
[null,null,null,"30 Minute Lunch Break",null,null,4,{"$f":"'Enter Information Here'!B9","v":"Team 4 Pool A"},"2 vs 3",1]
[null,null,null,"1  vs  3",2,null,null,null,"3 vs 4",2]
[null,null,null,"2  vs  3",1,null,null,null,"1 vs 2",4]
[null,null,null,"1  vs  2",3]
[]
["Pool Play"]
[]
[null,"Pool A: All matches before lunch break are 2 sets to 21 points (starting at 4). All matches after lunch are 1  set to 21 points (starting at 4). No cap unless announced."]
[null,"Pool B: All matches are 2 sets to 21 points (starting at 4). No cap unless announced prior to start of tournament."]
[]
["Work",null,"Pool B Matches",null,"Round",null,"Round","Pool A Matches","Work","Time"]
[{"$f":"C5","v":"Team 2 Pool B"},null,{"$f":"CONCATENATE(C4, \" vs \", C6)","v":"Team 1 Pool B vs Team 3 Pool B"},null,1,null,1,{"$f":"CONCATENATE(H4, \" vs \", H6)","v":"Team 1 Pool A vs Team 3 Pool A"},{"$f":"H5","v":"Team 2 Pool A"},{"$f":"'Enter Information Here'!B12","v":"09:00:00"}]
[{"$f":"C4","v":"Team 1 Pool B"},null,{"$f":"CONCATENATE(C5, \" vs \", C6)","v":"Team 2 Pool B vs Team 3 Pool B"},null,2,null,2,{"$f":"CONCATENATE(H5, \" vs \", H7)","v":"Team 2 Pool A vs Team 4 Pool A"},{"$f":"H4","v":"Team 1 Pool A"},{"$f":"'Enter Information Here'!B13","v":"09:50:00"}]
[{"$f":"C6","v":"Team 3 Pool B"},null,{"$f":"CONCATENATE(C4, \" vs \", C5)","v":"Team 1 Pool B vs Team 2 Pool B"},null,3,null,3,{"$f":"CONCATENATE(H4, \" vs \", H7)","v":"Team 1 Pool A vs Team 4 Pool A"},{"$f":"H6","v":"Team 3 Pool A"},{"$f":"'Enter Information Here'!B14","v":"10:40:00"}]
["30 Minute Lunch Break",null,null,null,null,null,4,{"$f":"CONCATENATE(H5, \" vs \", H6)","v":"Team 2 Pool A vs Team 3 Pool A"},{"$f":"H4","v":"Team 1 Pool A"},{"$f":"'Enter Information Here'!B15","v":"11:30:00"}]
[{"$f":"C5","v":"Team 2 Pool B"},null,{"$f":"CONCATENATE(C4, \" vs \", C6)","v":"Team 1 Pool B vs Team 3 Pool B"},null,4,null,5,{"$f":"CONCATENATE(H6, \" vs \", H7)","v":"Team 3 Pool A vs Team 4 Pool A"},{"$f":"H5","v":"Team 2 Pool A"},{"$f":"'Enter Information Here'!B16","v":"12:20:00"}]
[{"$f":"C4","v":"Team 1 Pool B"},null,{"$f":"CONCATENATE(C5, \" vs \", C6)","v":"Team 2 Pool B vs Team 3 Pool B"},null,5,null,6,{"$f":"CONCATENATE(H4, \" vs \", H5)","v":"Team 1 Pool A vs Team 2 Pool A"},{"$f":"H7","v":"Team 4 Pool A"},{"$f":"'Enter Information Here'!B17","v":"13:10:00"}]
[{"$f":"C6","v":"Team 3 Pool B"},null,{"$f":"CONCATENATE(C4, \" vs \", C5)","v":"Team 1 Pool B vs Team 2 Pool B"},null,6]
[]
["Warm ups"]
[null,"Prior to call for captains; Any team assigned to a particular court may conduct warmups (no coach initiated drills)*"]
[null,"1-4-4 - First Two Rounds, 1 minute shared ball handling on own side, 4 minutes eact team (serving team then receiving team)"]
[null,"1-3-3 - All additional rounds:  1 minute shared ball handling on own side, 3 minutes each team (serving team then receiving team)",null,null,null,null,null,null,null,null," "," "]
[null,"No warm-ups or activity of any kind in the free area of any court by an opponent during a team's official warmup time.",null,null,null,null,null,null,null," "]
["Advancement to Playoffs",null,null,null,null,null," "]
[" ","1st and 2nd from each pool advance to Championship Bracket court 1"]
[null,"3rd and 4th from each pool advance to Consolation Bracket court 2."]
[" ","There will be a Runner Up Bracket to determine 3rd & 4th Place (See Tab Below)"]
["Tiebreakers "]
["2 way tie for 1st in pool - a. Head to Head, b. Point Ratio between tied teams, c. Pt Ratio. in pool, d. coin toss "]
["2 way tie for 2nd - One 15 point set - first place team works."]
["3 way tie for 1st in pool - Point Ratio (overall pool play) for 1st, 2vs3-1W - 15 point set no cap"]
["3 way tie for 2nd in pool - seed by pt ratio. (overall pool play), 3 vs 4 (2 works) and than 2 vs winner (loser 3/4 works) 15 pt set no cap"]
["Tie for 3rd in pool - a. Head to Head, b. Point ratio. head to head, c. point ratio. (overall pool), coin toss"]
["4 way tie for 1st - a. Seed by Match record, Set Ratio then Point Ratio (overall pool play) for 1st, then follow 3 way tie for 2nd in pool (above)."]
["Playoffs "]
["All Play Off matches (Championship and Consolation Brackets) will be one set to 25 points (starting at 0-0)"]
[]
[null,null,"CHAMPIONSHIP BRACKET"]
[]
["Courts",null,"SEMI-FINALS",null,null,null,"TIME","FINALS","TIME","CHAMPIONS"]
[null,null,null,null,null,null,"Runner Up Match Played between Semi-Finals and Final Match"]
[" ",null,"1ST POOL A"]
[null,null," "]
[1,null,"2nd in Pool A"]
[]
[" ",null,"2ND POOL B"]
[null,null," ",null,null,null,null,null,"Court 1"]
[]
[" ",null,"1ST POOL B",null,null,null,null,"(work team: loser of 2nd Semi)"]
[null,null," "]
[1,null,"Winner of 1st Semi"]
[]
[" ",null,"2ND POOL A"]
[null,null," "]
[null,null,"CONSOLATION BRACKET"]
[]
[" ",null,"3RD POOL A"]
[null,null," "]
[2,null,"(work team 4th Pool A)"]
[]
[" ",null,"4TH POOL B"]
[null,null," ",null,null,null,null,null,"Court 2"]
[]
[" ",null,"3RD POOL B",null,null,null,null,"(work team: loser of 2nd Semi)"]
[null,null," "]
[2,null,"(work team: winner 1st Semi-Final)"]
[]
[" ",null,"4TH POOL A"]
[]
[]
[null,null,"CONSOLATION BRACKET"]
[" "]
[null,null,"3rd POOL B"]
[2,null," "]
[null,null,"3rd in Pool A"]
[" "]
[null,null,"4th POOL A"]
[null,null," ",null,null,null,null,null,"Court 2"]
[" "]
[null,null,null,null,null,null,null,"(work team: loser of 1st Semi)"]
[2]
[]
[" ",null,null,null,null,null,null,"3rd POOL A"]

{"sheet":"Pool Points Calculator","index":4,"n_rows":179,"n_cols":70,"rows_kept":179,"cut":false,"hidden":false,"merged":[[103,24,103,27],[105,5,105,8],[112,1,118,1],[112,2,112,3],[114,3,114,4],[114,5,114,8],[116,2,116,3],[116,5,116,8],[116,10,116,12],[118,5,118,8],[99,24,99,27],[101,5,101,8],[101,21,101,22],[101,24,101,27],[101,29,101,31],[90,2,90,3],[90,10,90,11],[97,20,103,20],[97,21,97,22],[99,1,105,1],[99,2,99,3],[99,22,99,23],[103,2,103,3],[103,5,103,8],[103,10,103,12],[101,4,106,4],[87,2,87,3],[87,10,87,11],[88,2,88,3],[88,10,88,11],[89,2,89,3],[89,10,89,11],[72,23,73,23],[72,24,73,24],[72,25,73,25],[85,1,86,1],[85,2,86,3],[85,9,86,9],[85,10,86,11],[72,3,73,3],[72,4,73,4],[72,5,73,5],[72,6,73,6],[72,22,73,22],[35,54,35,55],[35,66,35,67],[36,54,36,55],[36,66,36,67],[41,1,42,1],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,9,42,9],[41,10,42,10],[41,11,42,11],[41,12,42,12],[41,13,42,13],[29,54,29,55],[29,66,29,67],[30,54,30,55],[30,66,30,67],[34,54,34,55],[34,66,34,67],[23,54,23,55],[23,66,23,67],[24,54,24,55],[24,66,24,67],[28,54,28,55],[28,66,28,67],[17,54,17,55],[17,66,17,67],[18,54,18,55],[18,66,18,67],[22,54,22,55],[22,66,22,67],[11,54,11,55],[11,66,11,67],[12,54,12,55],[12,66,12,67],[16,54,16,55],[16,66,16,67],[5,54,5,55],[5,66,5,67],[6,54,6,55],[6,66,6,67],[10,54,10,55],[10,66,10,67],[0,52,1,52],[0,54,1,55],[0,64,1,64],[0,66,1,67],[4,54,4,55],[4,66,4,67],[0,13,1,13],[0,1,1,2],[0,4,1,4],[0,5,1,5],[0,9,1,10],[0,12,1,12]]}
[null,"Pool B",null,null,"Set 1","Set 2",null,null,null,"Pool A",null,null,"Set 1","Set 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diff",null,"H-H winner",null,null,"H-H Loser",null,null,null,null,null,null,"Diff",null,"H-H winner",null,null,"H-H Loser"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Example:",null,"Set 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5+9","5+7"]
[]
[]
[null,null,{"$f":"'3-4 Format'!C4","v":"Team 1 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H4","v":"Team 1 Pool A"},null,null,null,null,null,"Team Pink",null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E5+F5)-(E7+F7)","v":0},null,{"$f":"IF(E5>E7,1,0)+IF(F5>F7,1,0)+IF(E23>E25,1,0)","v":0},null,null,null,null,null,"7+9","7+9",null,null,{"$f":"(M5+N5)-(M7+N7)","v":0},null,{"$f":"IF(M5>M7,1,0)+IF(N5>N7,1,0)","v":0}]
[null,"Rd 1","vs",null,null,null,null,null,null,"Rd 1","vs",null,null,null,null,null,"vs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BC5>BC7,C5,IF(BC7>BC5,C7,IF(BC5=1,IF(BA5>BA7,C5,IF(BA5<BA7,C7,IF(BA5=BA7,IF(F44>F46,C5,IF(F44<F46,C7,\"Flip the Coin!\"))))))))","v":false},null,14,{"$f":"IF(BC5<BC7,C5,IF(BC7<BC5,C7,IF(BC5=1,IF(BA5<BA7,C5,IF(BA5>BA7,C7,IF(BA5=BA7,IF(F44<F46,C5,IF(F44>F46,C7,\"Flip the Coin!\"))))))))","v":false},null,null,null,null,null,null,null,null,{"$f":"IF(BO5>BO7,K5,IF(BO7>BO5,K7,IF(BO5=1,IF(BM5>BM7,K5,IF(BM5<BM7,K7,IF(BM5=BM7,IF(N44>N46,K5,IF(N44<N46,K7,\"Flip the Coin!\"))))))))","v":false},null,14,{"$f":"IF(BO5<BO7,K5,IF(BO7<BO5,K7,IF(BO5=1,IF(BM5<BM7,K5,IF(BM5>BM7,K7,IF(BM5=BM7,IF(N44<N46,K5,IF(N44>N46,K7,\"Flip the Coin!\"))))))))","v":false}]
[null,null,{"$f":"'3-4 Format'!C6","v":"Team 3 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H6","v":"Team 3 Pool A"},null,null,null,null,null,"Team Blue",null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E7+F7)-(E5+F5)","v":0},null,{"$f":"IF(E5<E7,1,0)+IF(F5<F7,1,0)+IF(E23<E25,1,0)","v":0},null,null,null,null,null,"5+7","5+9",null,null,{"$f":"(M7+N7)-(M5+N5)","v":0},null,{"$f":"IF(M5<M7,1,0)+IF(N5<N7,1,0)","v":0}]
[]
[]
[]
[null,null,{"$f":"'3-4 Format'!C5","v":"Team 2 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H5","v":"Team 2 Pool A"},null,null,null,null,null,"Team Blue wins Set 1,   25-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E11+F11)-(E13+F13)","v":0},null,{"$f":"IF(E11>E13,1,0)+IF(F11>F13,1,0)+IF(E29>E31,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M11+N11)-(M13+N13)","v":0},null,{"$f":"IF(M11>M13,1,0)+IF(N11>N13,1,0)","v":0}]
[null,"Rd 2","vs",null,null,null,null,null,null,"Rd 2","vs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BC11>BC13,C11,IF(BC13>BC11,C13,IF(BC11=1,IF(BA11>BA13,C11,IF(BA11<BA13,C13,IF(BA11=BA13,IF(F45>F46,C11,IF(F45<F46,C13,\"Flip the Coin!\"))))))))","v":false},null,16,{"$f":"IF(BC11<BC13,C11,IF(BC13<BC11,C13,IF(BC11=1,IF(BA11<BA13,C11,IF(BA11>BA13,C13,IF(BA11=BA13,IF(F45<F46,C11,IF(F45>F46,C13,\"Flip the Coin!\"))))))))","v":false},null,null,null,null,null,null,null,null,{"$f":"IF(BO11>BO13,K11,IF(BO13>BO11,K13,IF(BO11=1,IF(BM11>BM13,K11,IF(BM11<BM13,K13,IF(BM11=BM13,IF(N45>N47,K11,IF(N45<N47,K13,\"Flip the Coin!\"))))))))","v":false},null,20,{"$f":"IF(BO11<BO13,K11,IF(BO13<BO11,K13,IF(BO11=1,IF(BM11<BM13,K11,IF(BM11>BM13,K13,IF(BM11=BM13,IF(N45<N47,K11,IF(N45>N47,K13,\"Flip the Coin!\"))))))))","v":false}]
[null,null,{"$f":"'3-4 Format'!C6","v":"Team 3 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H7","v":"Team 4 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E13+F13)-(E11+F11)","v":0},null,{"$f":"IF(E11<E13,1,0)+IF(F11<F13,1,0)+IF(E29<E31,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M13+N13)-(M11+N11)","v":0},null,{"$f":"IF(M11<M13,1,0)+IF(N11<N13,1,0)","v":0}]
[]
[]
[]
[null,null,{"$f":"'3-4 Format'!C4","v":"Team 1 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H4","v":"Team 1 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E17+F17)-(E19+F19)","v":0},null,{"$f":"IF(E17>E19,1,0)+IF(F17>F19,1,0)+IF(E35>E37,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M17+N17)-(M19+N19)","v":0},null,{"$f":"IF(M17>M19,1,0)+IF(N17>N19,1,0)","v":0}]
[null,"Rd 3","vs",null,null,null,null,null,null,"Rd 3","vs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BC17>BC19,C17,IF(BC19>BC17,C19,IF(BC17=1,IF(BA17>BA19,C17,IF(BA17<BA19,C19,IF(BA17=BA19,IF(F44>F45,C17,IF(F44<F45,C19,\"Flip the Coin!\"))))))))","v":false},null,12,{"$f":"IF(BC17<BC19,C17,IF(BC19<BC17,C19,IF(BC17=1,IF(BA17<BA19,C17,IF(BA17>BA19,C19,IF(BA17=BA19,IF(F44<F45,C17,IF(F44>F45,C19,\"Flip the Coin!\"))))))))","v":false},null,null,null,null,null,null,null,null,{"$f":"IF(BO17>BO19,K17,IF(BO19>BO17,K19,IF(BO17=1,IF(BM17>BM19,K17,IF(BM17<BM19,K19,IF(BM17=BM19,IF(N44>N47,K17,IF(N44<N47,K19,\"Flip the Coin!\"))))))))","v":false},null,18,{"$f":"IF(BO17<BO19,K17,IF(BO19<BO17,K19,IF(BO17=1,IF(BM17<BM19,K17,IF(BM17>BM19,K19,IF(BM17=BM19,IF(N44<N47,K17,IF(N44>N47,K19,\"Flip the Coin!\"))))))))","v":false}]
[null,null,{"$f":"'3-4 Format'!C5","v":"Team 2 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H7","v":"Team 4 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E19+F19)-(E17+F17)","v":0},null,{"$f":"IF(E17<E19,1,0)+IF(F17<F19,1,0)+IF(E35<E37,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M19+N19)-(M17+N17)","v":0},null,{"$f":"IF(M17<M19,1,0)+IF(N17<N19,1,0)","v":0}]
[]
[]
[]
[null,null,{"$f":"'3-4 Format'!C4","v":"Team 1 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H5","v":"Team 2 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E23+F23)-(E25+F25)","v":0},null,{"$f":"IF(E23>E25,1,0)+IF(F23>F25,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M23+N23)-(M25+N25)","v":0},null,{"$f":"IF(M23>M25,1,0)+IF(N23>N25,1,0)","v":0}]
[null,"Rd 4","vs",null,null,null,null,null,null,"Rd 4","vs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BC23>BC25,C23,IF(BC25>BC23,C25,IF(BC23=1,IF(BA23>BA25,C23,IF(BA23<BA25,C25,IF(BA23=BA25,IF(F45>F47,C23,IF(F45<F47,C25,\"Flip the Coin!\"))))))))","v":false},null,null,{"$f":"IF(BC23<BC25,C23,IF(BC25<BC23,C25,IF(BC23=1,IF(BA23<BA25,C23,IF(BA23>BA25,C25,IF(BA23=BA25,IF(F45<F47,C23,IF(F45>F47,C25,\"Flip the Coin!\"))))))))","v":false},null,null,null,null,null,null,null,null,{"$f":"IF(BO23>BO25,K23,IF(BO25>BO23,K25,IF(BO23=1,IF(BM23>BM25,K23,IF(BM23<BM25,K25,IF(BM23=BM25,IF(N45>N46,K23,IF(N45<N46,K25,\"Flip the Coin!\"))))))))","v":false},null,16,{"$f":"IF(BO23<BO25,K23,IF(BO25<BO23,K25,IF(BO23=1,IF(BM23<BM25,K23,IF(BM23>BM25,K25,IF(BM23=BM25,IF(N45<N46,K23,IF(N45>N46,K25,\"Flip the Coin!\"))))))))","v":false}]
[null,null,{"$f":"'3-4 Format'!C6","v":"Team 3 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H6","v":"Team 3 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E25+F25)-(E23+F23)","v":0},null,{"$f":"IF(E23<E25,1,0)+IF(F23<F25,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M25+N25)-(M23+N23)","v":0},null,{"$f":"IF(M23<M25,1,0)+IF(N23<N25,1,0)","v":0}]
[]
[]
[]
[null,null,{"$f":"'3-4 Format'!C5","v":"Team 2 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H6","v":"Team 3 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E29+F29)-(E31+F31)","v":0},null,{"$f":"IF(E29>E31,1,0)+IF(F29>F31,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M29+N29)-(M31+N31)","v":0},null,{"$f":"IF(M29>M31,1,0)+IF(N29>N31,1,0)","v":0}]
[null,"Rd 5","vs",null,null,null,null,null,null,"Rd 5","vs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BC29>BC31,C29,IF(BC31>BC29,C31,IF(BC29=1,IF(BA29>BA31,C29,IF(BA29<BA31,C31,IF(BA29=BA31,IF(F44>F45,C29,IF(F44<F45,C31,\"Flip the Coin!\"))))))))","v":false},null,null,{"$f":"IF(BC29<BC31,C29,IF(BC31<BC29,C31,IF(BC29=1,IF(BA29<BA31,C29,IF(BA29>BA31,C31,IF(BA29=BA31,IF(F44<F45,C29,IF(F44>F45,C31,\"Flip the Coin!\"))))))))","v":false},null,null,null,null,null,null,null,null,{"$f":"IF(BO29>BO31,K29,IF(BO31>BO29,K31,IF(BO29=1,IF(BM29>BM31,K29,IF(BM29<BM31,K31,IF(BM29=BM31,IF(N46>N47,K29,IF(N46<N47,K31,\"Flip the Coin!\"))))))))","v":false},null,22,{"$f":"IF(BO29<BO31,K29,IF(BO31<BO29,K31,IF(BO29=1,IF(BM29<BM31,K29,IF(BM29>BM31,K31,IF(BM29=BM31,IF(N46<N47,K29,IF(N46>N47,K31,\"Flip the Coin!\"))))))))","v":false}]
[null,null,{"$f":"'3-4 Format'!C6","v":"Team 3 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H7","v":"Team 4 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E31+F31)-(E29+F29)","v":0},null,{"$f":"IF(E29<E31,1,0)+IF(F29<F31,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M31+N31)-(M29+N29)","v":0},null,{"$f":"IF(M29<M31,1,0)+IF(N29<N31,1,0)","v":0}]
[]
[]
[]
[null,null,{"$f":"'3-4 Format'!C4","v":"Team 1 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H4","v":"Team 1 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E35+F35)-(E37+F37)","v":0},null,{"$f":"IF(E35>E37,1,0)+IF(F35>F37,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M35+N35)-(M37+N37)","v":0},null,{"$f":"IF(M35>M37,1,0)+IF(N35>N37,1,0)","v":0}]
[null,"Rd 6","vs",null,null,null,null,null,null,"Rd 6","vs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BC35>BC37,C35,IF(BC37>BC35,C37,IF(BC35=1,IF(BA35>BA37,C35,IF(BA35<BA37,C37,IF(BA35=BA37,IF(F46>F47,C35,IF(F46<F47,C37,\"Flip the Coin!\"))))))))","v":false},null,null,{"$f":"IF(BC35<BC37,C35,IF(BC37<BC35,C37,IF(BC35=1,IF(BA35<BA37,C35,IF(BA35>BA37,C37,IF(BA35=BA37,IF(F46<F47,C35,IF(F46>F47,C37,\"Flip the Coin!\"))))))))","v":false},null,null,null,null,null,null,null,null,{"$f":"IF(BO35>BO37,K35,IF(BO37>BO35,K37,IF(BO35=1,IF(BM35>BM37,K35,IF(BM35<BM37,K37,IF(BM35=BM37,IF(N44>N45,K35,IF(N44<N45,K37,\"Flip the Coin!\"))))))))","v":false},null,12,{"$f":"IF(BO35<BO37,K35,IF(BO37<BO35,K37,IF(BO35=1,IF(BM35<BM37,K35,IF(BM35>BM37,K37,IF(BM35=BM37,IF(N44<N45,K35,IF(N44>N45,K37,\"Flip the Coin!\"))))))))","v":false}]
[null,null,{"$f":"'3-4 Format'!C5","v":"Team 2 Pool B"},null,null,null,null,null,null,null,{"$f":"'3-4 Format'!H5","v":"Team 2 Pool A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(E37+F37)-(E35+F35)","v":0},null,{"$f":"IF(E35<E37,1,0)+IF(F35<F37,1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(M37+N37)-(M35+N35)","v":0},null,{"$f":"IF(M35<M37,1,0)+IF(N35<N37,1,0)","v":0}]
[]
[]
[]
[]
[null,"Rank","Pool B","Won","Lost","Ratio","Set",null,null,"Rank","Pool A","Won","Lost","Ratio","Set"]
[null,null,null,null,null,null,"%",null,null,null,null,null,null,null,"%"]
[null,{"$f":"RANK(F75,F75:F78,0)","v":1},{"$f":"'3-4 Format'!C4","v":"Team 1 Pool B"},{"$f":"IF(E5>E7,1,0)+IF(F5>F7,1,0)+IF(E17>E19,1,0)+IF(F17>F19,1,0)+IF(E23>E25,1,0)+IF(E35>E37,1,0)","v":0},{"$f":"IF(E5<E7,1,0)+IF(F5<F7,1,0)+IF(E17<E19,1,0)+IF(F17<F19,1,0)+IF(E23<E25,1,0)+IF(E35<E37,1,0)","v":0},{"$f":"D75/E75","v":{"$error":"#DIV/0!"}},{"$f":"D44/(D44+E44)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"RANK(Y75,Y75:Y78,0)","v":1},{"$f":"'3-4 Format'!H4","v":"Team 1 Pool A"},{"$f":"IF(M5>M7,1,0)+IF(N5>N7,1,0)+IF(M17>M19,1,0)+IF(N17>N19,1,0)+IF(M35>M37,1,0)+IF(N35>N37,1,0)","v":0},{"$f":"IF(M5<M7,1,0)+IF(N5<N7,1,0)+IF(M17<M19,1,0)+IF(N17<N19,1,0)+IF(M35<M37,1,0)+IF(N35<N37,1,0)","v":0},{"$f":"W75/X75","v":{"$error":"#DIV/0!"}},{"$f":"L44/(L44+M44)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"RANK(F76,F75:F78,0)","v":1},{"$f":"'3-4 Format'!C5","v":"Team 2 Pool B"},{"$f":"IF(E11>E13,1,0)+IF(F11>F13,1,0)+IF(E19>E17,1,0)+IF(F19>F17,1,0)+IF(E29>E31,1,0)+IF(E37>E35,1,0)","v":0},{"$f":"IF(E11<E13,1,0)+IF(F11<F13,1,0)+IF(E19<E17,1,0)+IF(F19<F17,1,0)+IF(E29<E31,1,0)+IF(E37<E35,1,0)","v":0},{"$f":"D76/E76","v":{"$error":"#DIV/0!"}},{"$f":"D45/(D45+E45)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"RANK(Y76,Y75:Y78,0)","v":1},{"$f":"'3-4 Format'!H5","v":"Team 2 Pool A"},{"$f":"IF(M11>M13,1,0)+IF(N11>N13,1,0)+IF(M23>M25,1,0)+IF(N23>N25,1,0)+IF(M37>M35,1,0)+IF(N37>N35,1,0)","v":0},{"$f":"IF(M11<M13,1,0)+IF(N11<N13,1,0)+IF(M23<M25,1,0)+IF(N23<N25,1,0)+IF(M37<M35,1,0)+IF(N37<N35,1,0)","v":0},{"$f":"W76/X76","v":{"$error":"#DIV/0!"}},{"$f":"L45/(L45+M45)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"RANK(F77,F75:F78,0)","v":1},{"$f":"'3-4 Format'!C6","v":"Team 3 Pool B"},{"$f":"IF(E7>E5,1,0)+IF(F7>F5,1,0)+IF(E13>E11,1,0)+IF(F13>F11,1,0)+IF(E25>E23,1,0)+IF(E31>E29,1,0)","v":0},{"$f":"IF(E7<E5,1,0)+IF(F7<F5,1,0)+IF(E13<E11,1,0)+IF(F13<F11,1,0)+IF(E25<E23,1,0)+IF(E31<E29,1,0)","v":0},{"$f":"D77/E77","v":{"$error":"#DIV/0!"}},{"$f":"D46/(D46+E46)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"RANK(Y77,Y75:Y78,0)","v":1},{"$f":"'3-4 Format'!H6","v":"Team 3 Pool A"},{"$f":"IF(M7>M5,1,0)+IF(N7>N5,1,0)+IF(M25>M23,1,0)+IF(N25>N23,1,0)+IF(M29>M31,1,0)+IF(N29>N31,1,0)","v":0},{"$f":"IF(M7<M5,1,0)+IF(N7<N5,1,0)+IF(M25<M23,1,0)+IF(N25<N23,1,0)+IF(M29<M31,1,0)+IF(N29<N31,1,0)","v":0},{"$f":"W77/X77","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"RANK(Y78,Y75:Y78,0)","v":1},{"$f":"'3-4 Format'!H7","v":"Team 4 Pool A"},{"$f":"IF(M13>M11,1,0)+IF(N13>N11,1,0)+IF(M19>M17,1,0)+IF(N19>N17,1,0)+IF(M31>M29,1,0)+IF(N31>N29,1,0)","v":0},{"$f":"IF(M13<M11,1,0)+IF(N13<N11,1,0)+IF(M19<M17,1,0)+IF(N19<N17,1,0)+IF(M31<M29,1,0)+IF(N31<N29,1,0)","v":0},{"$f":"W78/X78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,"How many 1st?",{"$f":"COUNTIF(B44:B47,\"1\")","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How many 1st?",{"$f":"COUNTIF(J44:J47,\"1\")","v":4}]
[null,null,"How many 2nd?",{"$f":"COUNTIF(B44:B47,\"2\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How many 2nd?",{"$f":"COUNTIF(J44:J47,\"2\")","v":0}]
[null,null,"How many 3rd?",{"$f":"COUNTIF(B44:B47,\"3\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How many 3rd?",{"$f":"COUNTIF(J44:J47,\"3\")","v":0}]
[null,null,"How many 4th?",{"$f":"COUNTIF(B44:B47,\"4\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How many 4th?",{"$f":"COUNTIF(J44:J47,\"4\")","v":0}]
[]
[null,null,"1st",null,null,"Sum",null,"2 way",null,"3 way","3 way",null,null,null,null,null,null,null,null,null,null,"1st",null,null,"Sum",null,"2 way",null,"3 way","3 way"]
[null,{"$f":"INDEX($F$44:$F$47,MATCH(C58,($C$44:$C$47),0))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUPNTH(1,$B$44:$C$47,2,1)","v":"Team 1 Pool B"},{"$f":"IF(C58=C5,5,IF(C58=C11,7,IF(C58=C7,9,0)))","v":5},null,{"$f":"D58+D59","v":12},null,{"$f":"INDEX($BC$6:$BC$36,MATCH(F58,($BE$6:$BE$36),0))","v":false},null,{"$f":"IF(D52=3,(RANK(B58,B58:B60,0)),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"INDEX($C$58:$C$60,MATCH(1,($J$58:$J$60),0))","v":{"$error":"#N/A"}},1,null,null,null,null,null,null,null,null,{"$f":"INDEX($N$44:$N$47,MATCH(V58,($K$44:$K$47),0))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUPNTH(1,$J$44:$K$47,2,1)","v":"Team 1 Pool A"},{"$f":"IF(V58=K5,5,IF(V58=K11,7,IF(V58=K7,9,IF(V58=K13,13,0))))","v":5},null,{"$f":"W58+W59","v":12},null,{"$f":"INDEX($BO$6:$BO$36,MATCH(Y58,($BQ$6:BQ$36),0))","v":false},null,{"$f":"IF(W52=3,(RANK(U58,U58:U60,0)),\"\")","v":""},{"$f":"INDEX($V$58:$V$60,MATCH(1,($AC$58:$AC$60),0))","v":{"$error":"#N/A"}},1]
[null,{"$f":"INDEX($F$44:$F$47,MATCH(C59,($C$44:$C$47),0))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUPNTH(1,$B$44:$C$47,2,2)","v":"Team 2 Pool B"},{"$f":"IF(C59=C5,5,IF(C59=C11,7,IF(C59=C7,9,0)))","v":7},null,null,null,{"$f":"INDEX($BF$6:$BF$36,MATCH(F58,($BE$6:$BE$36),0))","v":false},null,{"$f":"IF(D52=3,(RANK(B59,B58:B60,0)),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"INDEX($C$58:$C$60,MATCH(2,($J$58:$J$60),0))","v":{"$error":"#N/A"}},2,null,null,null,null,null,null,null,null,{"$f":"INDEX($N$44:$N$47,MATCH(V59,($K$44:$K$47),0))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUPNTH(1,$J$44:$K$47,2,2)","v":"Team 2 Pool A"},{"$f":"IF(V59=K5,5,IF(V59=K11,7,IF(V59=K7,9,IF(V59=K13,13,0))))","v":7},null,null,null,{"$f":"INDEX($BR$6:$BR$36,MATCH(Y58,($BQ$6:$BQ$36),0))","v":false},null,{"$f":"IF(W52=3,(RANK(U59,U58:U60,0)),\"\")","v":""},{"$f":"INDEX($V$58:$V$60,MATCH(2,($AC$58:$AC$60),0))","v":{"$error":"#N/A"}},2]
[null,{"$f":"INDEX($F$44:$F$47,MATCH(C60,($C$44:$C$47),0))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUPNTH(1,$B$44:$C$47,2,3)","v":"Team 3 Pool B"},null,null,null,null,null,null,{"$f":"IF(D52=3,(RANK(B60,B58:B60,0)),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"INDEX($C$58:$C$60,MATCH(3,($J$58:$J$60),0))","v":{"$error":"#N/A"}},3,null,null,null,null,null,null,null,null,{"$f":"INDEX($N$44:$N$47,MATCH(V60,($K$44:$K$47),0))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUPNTH(1,$J$44:$K$47,2,3)","v":"Team 3 Pool A"},null,null,null,null,null,null,{"$f":"IF(W52=3,(RANK(U60,U58:U60,0)),\"\")","v":""},{"$f":"INDEX($V$58:$V$60,MATCH(3,($AC$58:$AC$60),0))","v":{"$error":"#N/A"}},3]
[]
[null,null,"2nd",null,null,"Sum",null,"TB",null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd",null,null,"Sum",null,"TB"]
[null,{"$f":"INDEX($F$44:$F$47,MATCH(C63,($C$44:$C$47),0))","v":{"$error":"#N/A"}},{"$f":"VLOOKUPNTH(2,$B$44:$C$47,2,1)","v":""},{"$f":"IF(C63=C5,5,IF(C63=C11,7,IF(C63=C7,9,0)))","v":0},null,{"$f":"D63+D64","v":0},null,{"$f":"INDEX($BC$6:$BC$36,MATCH(F63,($BE$6:$BE$36),0))","v":{"$error":"#N/A"}},null,{"$f":"IF(D53=3,(RANK(B63,B63:B65,0)),\"\")","v":""},{"$f":"INDEX($C$63:$C$65,MATCH(1,($J$63:$J$65),0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,{"$f":"INDEX($N$44:$N$47,MATCH(V63,($K$44:$K$47),0))","v":{"$error":"#N/A"}},{"$f":"VLOOKUPNTH(2,$J$44:$K$47,2,1)","v":""},{"$f":"IF(V63=K5,5,IF(V63=K11,7,IF(V63=K7,9,IF(V63=K13,13,0))))","v":0},null,{"$f":"W63+W64","v":0},null,{"$f":"INDEX($BO$6:$BO$36,MATCH(Y63,($BQ$6:$BQ$36),0))","v":{"$error":"#N/A"}},null,{"$f":"IF(W53=3,(RANK(U63,U63:U65,0)),\"\")","v":""},{"$f":"INDEX($V$63:$V$65,MATCH(1,($AC$63:$AC$65),0))","v":{"$error":"#N/A"}}]
[null,{"$f":"INDEX($F$44:$F$47,MATCH(C64,($C$44:$C$47),0))","v":{"$error":"#N/A"}},{"$f":"VLOOKUPNTH(2,$B$44:$C$47,2,2)","v":""},{"$f":"IF(C64=C5,5,IF(C64=C11,7,IF(C64=C7,9,0)))","v":0},null,null,null,{"$f":"INDEX($BF$6:$BF$36,MATCH(F63,($BE$6:$BE$36),0))","v":{"$error":"#N/A"}},null,{"$f":"IF(D53=3,(RANK(B64,B63:B65,0)),\"\")","v":""},{"$f":"INDEX($C$63:$C$65,MATCH(2,($J$63:$J$65),0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,{"$f":"INDEX($N$44:$N$47,MATCH(V64,($K$44:$K$47),0))","v":{"$error":"#N/A"}},{"$f":"VLOOKUPNTH(2,$J$44:$K$47,2,2)","v":""},{"$f":"IF(V64=K5,5,IF(V64=K11,7,IF(V64=K7,9,IF(V64=K13,13,0))))","v":0},null,null,null,{"$f":"INDEX($BR$6:$BR$36,MATCH(Y63,($BQ$6:$BQ$36),0))","v":{"$error":"#N/A"}},null,{"$f":"IF(W53=3,(RANK(U64,U63:U65,0)),\"\")","v":""},{"$f":"INDEX($V$63:$V$65,MATCH(2,($AC$63:$AC$65),0))","v":{"$error":"#N/A"}}]
[null,{"$f":"INDEX($F$44:$F$47,MATCH(C65,($C$44:$C$47),0))","v":{"$error":"#N/A"}},{"$f":"VLOOKUPNTH(2,$B$44:$C$47,2,3)","v":""},null,null,null,null,null,null,{"$f":"IF(D53=3,(RANK(B65,B63:B65,0)),\"\")","v":""},{"$f":"INDEX($C$63:$C$65,MATCH(3,($J$63:$J$65),0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,{"$f":"INDEX($N$44:$N$47,MATCH(V65,($K$44:$K$47),0))","v":{"$error":"#N/A"}},{"$f":"VLOOKUPNTH(2,$J$44:$K$47,2,3)","v":""},null,null,null,null,null,null,{"$f":"IF(W53=3,(RANK(U65,U63:U65,0)),\"\")","v":""},{"$f":"INDEX($V$63:$V$65,MATCH(3,($AC$63:$AC$65),0))","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"3rd",null,null,"Sum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3rd",null,null,"Sum"]
[null,null,{"$f":"VLOOKUPNTH(3,$B$44:$C$47,2,1)","v":""},{"$f":"IF(C69=C5,5,IF(C69=C11,7,IF(C69=C7,9,0)))","v":0},null,{"$f":"D69+D70","v":0},null,{"$f":"INDEX($BC$6:$BC$36,MATCH(F69,($BE$6:$BE$36),0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUPNTH(3,$J$44:$K$47,2,1)","v":""},{"$f":"IF(V69=K5,5,IF(V69=K11,7,IF(V69=K7,9,IF(V69=K13,13,0))))","v":0},null,{"$f":"W69+W70","v":0},null,{"$f":"INDEX($BO$6:$BO$36,MATCH(Y69,($BQ$6:$BQ$36),0))","v":{"$error":"#N/A"}}]
[null,null,{"$f":"VLOOKUPNTH(3,$B$44:$C$47,2,2)","v":""},{"$f":"IF(C70=C5,5,IF(C70=C11,7,IF(C70=C7,9,0)))","v":0},null,null,null,{"$f":"INDEX($BF$6:$BF$36,MATCH(F69,($BE$6:$BE$36),0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUPNTH(3,$J$44:$K$47,2,2)","v":""},{"$f":"IF(V70=K5,5,IF(V70=K11,7,IF(V70=K7,9,IF(V70=K13,13,0))))","v":0},null,null,null,{"$f":"INDEX($BR$6:$BR$36,MATCH(Y69,($BQ$6:$BQ$36),0))","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,"For","Against","Rating",{"$f":"IF(B44+B45+B46+B47=4,\"Rank by Points\",IF(B44+B45+B46+B47=7,\"Rank by Points\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For","Against","Rating",{"$f":"IF(J44+J45+J46+J47=4,\"Rank by Points\",IF(J44+J45+J46+J47=7,\"Rank by Points\",\"\"))","v":"Rank by Points"}]
[]
[null,null,null,{"$f":"SUM(E5,F5,E17,F17,E23, E35)","v":0},{"$f":"SUM(E7,F7,E19,F19,E25,E37)","v":0},{"$f":"IFERROR(D44/(D44+E44),0)","v":0},{"$f":"IF(B44+B45+B46+B47=4,RANK(F44,F$44:F$47),IF(B44+B45+B46+B47=7,RANK(F44,F$44:F$47),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M5,N5,M17,N17,M35, N35)","v":0},{"$f":"SUM(M7,N7,M19,N19,M37,N37)","v":0},{"$f":"IFERROR(L44/(L44+M44),0)","v":0},{"$f":"IF(J44+J45+J46+J47=4,RANK(N44,N$44:N$47),IF(J44+J45+J46+J47=7,RANK(N44,N$44:N$47),\"\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"SUM(E19,F19,E11,F11,E37,E29)","v":0},{"$f":"SUM(E17,F17,E13,F13,E31,E35,)","v":0},{"$f":"IFERROR(D45/(D45+E45),0)","v":0},{"$f":"IF(B44+B45+B46+B47=4,RANK(F45,F$44:F$47),IF(B44+B45+B46+B47=7,RANK(F45,F$44:F$47),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M11,N11,M23,N23,M37,N37)","v":0},{"$f":"SUM(M35,N35,M25,N25,M13,N13,)","v":0},{"$f":"IFERROR(L45/(L45+M45),0)","v":0},{"$f":"IF(J44+J45+J46+J47=4,RANK(N45,N$44:N$47),IF(J44+J45+J46+J47=7,RANK(N45,N$44:N$47),\"\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"SUM(E7,F7,E13,F13,E25,E31,)","v":0},{"$f":"SUM(E5,F5,E11,F11,E23,E29,)","v":0},{"$f":"IFERROR(D46/(D46+E46),0)","v":0},{"$f":"IF(B44+B45+B46+B47=4,RANK(F46,F$44:F$47),IF(B44+B45+B46+B47=7,RANK(F46,F$44:F$47),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25,N25,M7,N7,M29,N29,)","v":0},{"$f":"SUM(M5,N5,M23,N23,M31,N31,)","v":0},{"$f":"IFERROR(L46/(L46+M46),0)","v":0},{"$f":"IF(J44+J45+J46+J47=4,RANK(N46,N$44:N$47),IF(J44+J45+J46+J47=7,RANK(N46,N$44:N$47),\"\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"IF(B44+B45+B46+B47=4,RANK(F47,F$44:F$47),IF(B44+B45+B46+B47=7,RANK(F47,F$44:F$47),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M31,N31,M19,N19,M13,N13)","v":0},{"$f":"SUM(M29,N29,M17,N17,M11,N11)","v":0},{"$f":"IFERROR(L47/(L47+M47),0)","v":0},{"$f":"IF(J44+J45+J46+J47=4,RANK(N47,N$44:N$47),IF(J44+J45+J46+J47=7,RANK(N47,N$44:N$47),\"\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"set%","Pt Rat"]
[null,"3A",{"$f":"C90","v":""},{"$f":"INDEX(G44:G46,MATCH(C80,C44:C46,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(F44:F46,MATCH(C80,C44:C46,0))","v":{"$error":"#N/A"}}]
[null,"3B",{"$f":"K90","v":""},{"$f":"INDEX(O44:O47,MATCH(C81,K44:K47,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(N44:N47,MATCH(C81,K44:K47,0))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[null,"Rank","Final Pool B Standings",null,null,null,null,null,null,"Rank","Final Pool A Standings"]
[]
[null,"1st",{"$f":"IF(F13>0,IF(D52=3,K58,IF(D52=4,(INDEX($C$44:$C$47,MATCH(1,$G$75:$G$78,0))),IF(D52=1,(INDEX($C$44:$C$47,MATCH(1,$B$44:$B$47,0))),H58))),\"\")","v":""},null,null,null,null,null,null,"1st",{"$f":"IF(N13>0,IF(W52=3,AD58,IF(W52=4,(INDEX($K$44:$K$47,MATCH(1,$Z$75:$Z$78,0))),IF(W52=1,(INDEX($K$44:$K$47,MATCH(1,$J$44:$J$47,0))),AA58))),\"\")","v":""}]
[null,"2nd",{"$f":"IF(F13>0,IF(D53=1,INDEX($C$44:$C$47,MATCH(2,$B$44:$B$47,0)),IF(D52=2,H59,IF(D52=4,K104,IF(D52=3,K104,IF(D53=3,K104,IF(D53=2,K104,\"\")))))),\"\")","v":""},null,null,null,null,null,null,"2nd",{"$f":"IF(N13>0,IF(W53=1,INDEX($K$44:$K$47,MATCH(2,$J$44:$J$47,0)),IF(W52=2,AA59,IF(W52=4,K117,IF(W52=3,K117,IF(W53=3,K117,IF(W53=2,K117,\"\")))))),\"\")","v":""}]
[null,"3rd",{"$f":"IF(F13>0,IF(D54=1,(INDEX($C$44:$C$47,MATCH(3,$B$44:$B$47,0))),IF(D54=2,H69,IF(J102<J106,F102,(IF(J106<J102,F106,\"\"))))),\"\")","v":""},null,null,null,null,null,null,"3rd",{"$f":"IF(N13>0,IF(W54=1,(INDEX($K$44:$K$47,MATCH(3,$J$44:$J$47,0))),IF(W54=2,AA69,IF(J115<J119,F115,(IF(J119<J115,F119,\"\"))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"4th",{"$f":"IF(N13>0,IF(W55=1,(INDEX($K$44:$K$47,MATCH(4,$J$44:$J$47,0))),IF(W54=2,AA70,IF(W52=4,IF(E113<E117,C113,IF(E117<E113,C117,\"\")),IF(W53=3,IF(E113<E117,C113,IF(E117<E113,C117,\"\")))))),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiebreaker Bracket for Pool A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 set to 15 points starting at 0-0, switch at 8"]
[null,null,null,null,"Tiebreaker Brackets for pools B & A (IF NECESSARY)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Tiebreaker Bracket for Pool B",null,null,null,null,null,null,null,null,null,"B",{"$f":"IF(W53=3,AD64,IF(W52=4,(INDEX(K44:K47,MATCH(3,Z75:Z78,0))),\"\"))","v":{"$error":"#N/A"}},null,0]
[null,null,null,null,null,null,null,null,null,null,"1 set to 15 points starting at 0-0, switch at 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W53=3,AD63,IF(W52=4,(INDEX(K44:K47,MATCH(2,Z75:Z78,0))),\"\"))","v":{"$error":"#N/A"}},"Work",null,{"$f":"IF(W52=3,AD59,IF(W53=2,AA63,IF(X98>X102,V98,(IF(X102>X98,V102,\"\")))))","v":""},null,null,null,0]
[]
[null,null,null,null,"B",{"$f":"IF(E37>0,IF(D52=3,K59,IF(D53=2,H63,\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W53=3,AD65,IF(W52=4,(INDEX(K44:K47,MATCH(4,Z75:Z78,0))),\"\"))","v":{"$error":"#N/A"}},null,0,{"$f":"IF(W52=3,K88,IF(W53=2,K88,IF(X98<X102,V98,(IF(X102<X98,V102,\"\")))))","v":""},null,null,null,"Work",{"$f":"IF(AC100>AC104,Y100,(IF(AC104>AC100,Y104,\"\")))","v":""},null,null,"is the 2nd Place team in Pool B"]
[]
[null,null,null,null,null,{"$f":"IF(D52=3,C88,IF(D53=2,C88,\"\"))","v":""},null,null,null,"Work",{"$f":"IF(J102>J106,F102,(IF(J106>J102,F106,\"\")))","v":""},null,null,"is the 2nd Place team in Pool B",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W53=3,AD63,IF(W52=4,(INDEX(K44:K47,MATCH(2,Z75:Z78,0))),IF(W52=3,AD60,IF(W53=2,AA64,\"\"))))","v":{"$error":"#N/A"}},null,null,null,0]
[]
[null,null,null,null,null,{"$f":"IF(E37>0,IF(D52=3,K60,IF(D53=2,H64,\"\")),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Tiebreaker Bracket for Pool A"]
[null,null,null,null,null,null,null,null,null,null,"1 set to 15 points starting at 0-0, switch at 8"]
[null,"A",{"$f":"IF(N37>0,IF(W53=3,AD64,IF(W52=4,(INDEX(K44:K47,MATCH(3,Z75:Z78,0))),\"\")),\"\")","v":""}]
[]
[null,null,{"$f":"IF(N37>0,IF(W53=3,AD63,IF(W52=4,(INDEX(K44:K47,MATCH(2,Z75:Z78,0))),\"\")),\"\")","v":""},"Work",null,{"$f":"IF(W52=3,AD59,IF(W53=2,AA63,IF(E113>E117,C113,(IF(E117>E113,C117,\"\")))))","v":""}]
[]
[null,null,{"$f":"IF(N37>0,IF(W53=3,AD65,IF(W52=4,(INDEX(K44:K47,MATCH(4,Z75:Z78,0))),\"\")),\"\")","v":""},null,null,{"$f":"IF(W52=3,K88,IF(W53=2,K88,IF(E113<E117,C113,(IF(E117<E113,C117,\"\")))))","v":""},null,null,null,"Work",{"$f":"IF(J115>J119,F115,(IF(J119>J115,F119,\"\")))","v":""},null,null,"is the 2nd Place team in Pool A"]
[]
[null,null,null,null,null,{"$f":"IF(N37>0,IF(W53=3,AD63,IF(W52=4,(INDEX(K44:K47,MATCH(2,Z75:Z78,0))),IF(W52=3,AD60,IF(W53=2,AA64,\"\")))),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiebreaker Bracket"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D53=3,(INDEX($C$44:$C$47,MATCH(3,$G$75:$G$78,0))),IF(D52=4,(INDEX($C$44:$C$47,MATCH(3,$G$75:$G$78,0))),\"\"))","v":""},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D53=3,(INDEX($C$44:$C$47,MATCH(2,$G$75:$G$78,0))),IF(D52=4,(INDEX($C$44:$C$47,MATCH(2,$G$75:$G$78,0))),\"\"))","v":""},null,null,{"$f":"IF(D52=3,(INDEX($C$44:$C$47,MATCH(3,$G$75:$G$78,0))),IF(BB140>BB144,BA140,(IF(BB144>BB140,AZ144,\"\"))))","v":{"$error":"#N/A"}},null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D53=3,(INDEX($C$44:$C$47,MATCH(4,$G$75:$G$78,0))),IF(D52=4,(INDEX($C$44:$C$47,MATCH(4,$G$75:$G$78,0))),\"\"))","v":""},null,0,{"$f":"IF(D52=3,(INDEX($C$44:$C$47,MATCH(1,$G$75:$G$78,0))),IF(BB140<BB144,BA140,(IF(BB144<BB140,AZ144,\"\"))))","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(BF142>BF146,BC142,(IF(BF146>BF142,BC146,\"\")))","v":""},null,null,"is the 2nd Place team in Pool A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D53=3,(INDEX($C$44:$C$47,MATCH(2,$G$75:$G$78,0))),IF(D52=4,(INDEX($C$44:$C$47,MATCH(2,$G$75:$G$78,0))),IF(D52=3,(INDEX($C$44:$C$47,MATCH(2,$G$75:$G$78,0))),\"\")))","v":{"$error":"#N/A"}},null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D53=3,(INDEX($C$44:$C$47,MATCH(1,$B$44:$B$47,0))),IF(D52=4,(INDEX($C$44:$C$47,MATCH(1,$G$75:$G$78,0))),IF(D52=1,(INDEX($C$44:$C$47,MATCH(1,$B$44:$B$47,0))),H58)))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D53=1,INDEX($C$44:$C$47,MATCH(2,$B$44:$B$47,0)),IF(D52=2,H59,BG144))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D54=1,(INDEX($C$44:$C$47,MATCH(3,$B$44:$B$47,0))),IF(D54=2,H69,IF(BF142<BF146,BC142,(IF(BF146<BF142,BC146,\"\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D54=1,(INDEX($C$44:$C$47,MATCH(4,$B$44:$B$47,0))),IF(D54=2,H70,IF(BB140<BB144,BA140,(IF(BB144<BB140,AZ144,\"\")))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Known Bugs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 way tie for second - If 2nd place has more pool points than 1st place"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ties on points in pool"]

{"sheet":"Playoff Brackets","index":5,"n_rows":47,"n_cols":26,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,9,2,10],[10,9,18,10],[7,9,8,10],[20,9,21,10],[48,1,48,4],[11,1,11,4],[17,1,17,4],[20,1,20,4],[20,6,20,8],[20,11,20,14],[23,1,23,4],[38,12,38,16],[28,0,28,2],[38,17,38,18],[30,1,30,4],[33,1,33,4],[33,6,33,8],[33,11,33,14],[36,1,36,4],[39,19,39,22],[42,1,42,4],[45,1,45,4],[45,6,45,8],[45,11,45,14],[39,13,39,16],[13,17,13,18],[14,13,14,16],[14,19,14,22],[5,1,5,4],[8,1,8,4],[8,6,8,8],[8,11,8,14],[13,12,13,16],[10,25,10,27],[11,25,11,27],[5,25,5,27],[6,25,6,27],[7,25,7,27],[8,25,8,27],[9,25,9,27]]}
[]
[null,null,null,null,null,null,null,null,null,"Runner Up Match"]
[null,"Champion Bracket",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final Results"]
[null,null,null,null,null,null,"Set 1","Set 2","Set 3",null,null,null,null,null,null,null,"Set 1","Set 2 ","Set 3"]
[]
[null,{"$f":"'Pool Points Calculator'!C88","v":""},null,null,null,{"$f":"IF(G6>G12,1,0)+IF(H6>H12,1,0)+IF(I6>I12,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1st",{"$f":"T15","v":""}]
[null,"1st in Pool B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd",{"$f":"IF(P9<P21,L9,IF(P21<P9,L21,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Runner Up Playoff'!B4","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3rd",{"$f":"'Runner Up Playoff'!J7","v":""}]
[null,{"$f":"'Pool Points Calculator'!C89","v":""},null,null,null,null,"Work team",null,null,null,null,{"$f":"IF(G12>0,IF(F6>F12,B6,IF(F12>F6,B12,\"\")),\"\")","v":""},null,null,null,{"$f":"IF(Q9>Q21,1,0)+IF(R9>R21,1,0)+IF(S9>S21,1,0)","v":0},null,null,null,null,null,null,null,null,"4th",{"$f":"'Runner Up Playoff'!J8","v":""}]
["Semi #1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5th",{"$f":"IF(P34>P46,L34,IF(P46>P34,L46,\"\"))","v":""}]
["1 set to 25",null,null,null,null,null,null,null,null,"Runner Up Match Played Here - See Tab Below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6th",{"$f":"IF(P34<P46,L34,IF(P46<P34,L46,\"\"))","v":""}]
[null,{"$f":"'Pool Points Calculator'!K89","v":""},null,null,null,{"$f":"IF(G6<G12,1,0)+IF(H6<H12,1,0)+IF(I6<I12,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7th",{"$f":"M39","v":""}]
[null,"2nd in Pool A"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G24>0,IF(F18<F24,B18,IF(F24<F18,B24,\"\")),\"\")","v":""},null,null,null,null,"Work team"]
[null,null,null,null,null,null,null,null,null,null,null,"Final",null,null,null,null,null,null,null,{"$f":"IF(P9>P21,L9,IF(P21>P9,L21,\"\"))","v":""}]
[null,null,null,null,null,null,"Set 1","Set 2 ","Set 3",null,null,"1 set to 25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tournament Champion"]
[null,{"$f":"'Pool Points Calculator'!C89","v":""},null,null,null,{"$f":"IF(G18>G24,1,0)+IF(H18>H24,1,0)+IF(I18>I24,1,0)","v":0}]
[null,"2nd in Pool B"]
[]
[null,{"$f":"L9","v":""},null,null,null,null,"Work team",null,null,{"$f":"'Runner Up Playoff'!B10","v":" "},null,{"$f":"IF(G24>0,IF(F18>F24,B18,IF(F24>F18,B24,\"\")),\"\")","v":""},null,null,null,{"$f":"IF(Q9<Q21,1,0)+IF(R9<R21,1,0)+IF(S9<S21,1,0)","v":0}]
["Semi #2"]
["1 set to 25"]
[null,{"$f":"'Pool Points Calculator'!K88","v":""},null,null,null,{"$f":"IF(G18<G24,1,0)+IF(H18<H24,1,0)+IF(I18<I24,1,0)","v":0}]
[null,"1st in Pool A"]
[]
[]
[null,null,null,null,null,null,"Set 1","Set 2 ","Set 3",null,null,null,null,null,null,null,"Set 1","Set 2 ","Set 3"]
["Consolation Bracket"]
[]
[null,{"$f":"'Pool Points Calculator'!C90","v":""},null,null,null,{"$f":"IF(G31>G37,1,0)+IF(H31>H37,1,0)+IF(I31>I37,1,0)","v":0}]
[null,"3rd In Pool B"]
[]
[null,{"$f":"IFERROR(IF('Pool Points Calculator'!D80>'Pool Points Calculator'!D81,'Pool Points Calculator'!C80,IF('Pool Points Calculator'!D81>'Pool Points Calculator'!D80,'Pool Points Calculator'!C81,IF('Pool Points Calculator'!D80='Pool Points Calculator'!D81,IF('Pool Points Calculator'!E80>'Pool Points Calculator'!E81,'Pool Points Calculator'!C80,'Pool Points Calculator'!C81)))),\" \")","v":" "},null,null,null,null,"Work team",null,null,null,null,{"$f":"IF(G37>0,IF(F31>F37,B31,IF(F37>F31,B37,\"\")),\"\")","v":""},null,null,null,{"$f":"IF(Q34>Q46,1,0)+IF(R34>R46,1,0)+IF(S34>S46,1,0)","v":0}]
["Semi #1"]
["1 set to 25"]
[null,{"$f":"'Pool Points Calculator'!K91","v":""},null,null,null,{"$f":"IF(G31<G37,1,0)+IF(H31<H37,1,0)+IF(I31<I37,1,0)","v":0}]
[null,"4th in Pool A"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G37>0,IF(F31<F37,B31,IF(F37<F31,B37,\"\")),\"\")","v":""},null,null,null,null,"Work team"]
[null,null,null,null,null,null,null,null,null,null,null,"Final",null,null,null,null,null,null,null,{"$f":"IF(P34>P46,L34,IF(P46>P34,L46,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"1 set to 25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consolation Winner"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Pool Points Calculator'!K90","v":""},null,null,null,{"$f":"IF(Q34<Q46,1,0)+IF(R34<R46,1,0)+IF(S34<S46,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"3rd in Pool A"]

{"sheet":"Runner Up Playoff","index":6,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,14,1,18],[6,9,6,11],[7,9,7,11],[9,1,9,4],[0,0,0,8],[3,1,3,4],[6,1,6,4],[6,6,6,8]]}
["Championship Runer Up Bracket (3rd & 4th)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Runner Up Results"]
[null,null,null,null,null,null,"Set 1","Set 2","Set 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3rd",{"$f":"J7","v":""}]
[null,{"$f":"IF('Playoff Brackets'!L9<>\"\",(IF('Playoff Brackets'!L9='Playoff Brackets'!B6,'Playoff Brackets'!B12,'Playoff Brackets'!B6)),\" \")","v":" "},null,null,null,{"$f":"IF(G4>G10,1,0)+IF(H4>H10,1,0)+IF(I4>I10,1,0)","v":0},null,null,null,null,null,null,null,null,"4th",{"$f":"J8","v":""}]
[null,"Loser Semi #1"]
[]
[null," AND/OR ",null,null,null,null,"Work team",null,null,{"$f":"IF(G10>0,IF(F4>F10,B4,IF(F10>F4,B10,\"\")),\"\")","v":""},null,null,"3rd Place"]
["Semi #1",null,null,null,null,null,null,null,null,{"$f":"IF(G10>0,IF(F4<F10,B4,IF(F10<F4,B10,\"\")),\"\")","v":""},null,null,"4th Place"]
[]
[null,{"$f":"IF('Playoff Brackets'!L21<>\"\",(IF('Playoff Brackets'!L21='Playoff Brackets'!B18,'Playoff Brackets'!B24,'Playoff Brackets'!B18)),\" \")","v":" "},null,null,null,{"$f":"IF(G4<G10,1,0)+IF(H4<H10,1,0)+IF(I4<I10,1,0)","v":0}]
[null,"Loser Semi #2"]

{"sheet":"Results Report","index":7,"n_rows":182,"n_cols":8,"rows_kept":182,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Results Entry Sheet",null,null,"Age Group",null,{"$f":"'Enter Information Here'!I7","v":0}]
[]
[]
[null,null,"Tournament Date",null,"Number of teams in the Tournament"]
[null,null,{"$f":"'Enter Information Here'!I3","v":"00:00:00"},null,8]
[]
[null,null,"Tournament Site",null,"Host Club"]
[null,null,{"$f":"'Enter Information Here'!I5","v":"00:00:00"},null,{"$f":"'Enter Information Here'!I11","v":"00:00:00"}]
[]
[null,null,"Tournament Level",null,"Person entering Results"]
[null,null,{"$f":"'Enter Information Here'!I9","v":"00:00:00"},null,{"$f":"'Enter Information Here'!I17","v":"00:00:00"}]
[]
[null,null,"Tournament Director Name",null,"Email"]
[null,null,{"$f":"'Enter Information Here'!I13","v":"00:00:00"},null,{"$f":"'Enter Information Here'!I18","v":"00:00:00"}]
[]
[null,null,"TD Phone Number"]
[null,null,{"$f":"'Enter Information Here'!I14","v":"00:00:00"}]
[]
[]
[null,null,"Winner of the Tournament"]
[null,null,{"$f":"'Playoff Brackets'!Z6","v":""}]
[]
[null,null,"Games won in Pool",null,"Games lost in Pool"]
[1,null,{"$f":"INDEX(D150:D157,MATCH(C22,C150:C157,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX(E150:E157,MATCH(C22,C150:C157,0))","v":{"$error":"#N/A"}}]
[]
[null,null,"Final Finish in Tournament"]
[null,null,{"$f":"CONCATENATE(C12,\" \",1)","v":"0 1"}]
[]
[]
[]
[null,null,"2nd Place - Runner up"]
[null,null,{"$f":"'Playoff Brackets'!Z7","v":""}]
[]
[null,null,"Games won in Pool",null,"Games lost in Pool"]
[2,null,{"$f":"INDEX(D150:D157,MATCH(C33,C150:C157,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX(E150:E157,MATCH(C33,C150:C157,0))","v":{"$error":"#N/A"}}]
[]
[null,null,"Final Finish in Tournament"]
[null,null,{"$f":"CONCATENATE(C12,\" \",2)","v":"0 2"}]
[]
[]
[]
[null,null,"Tied for 3rd"]
[null,null,{"$f":"'Playoff Brackets'!Z8","v":""}]
[]
[null,null,"Games won in Pool",null,"Games lost in Pool"]
[3,null,{"$f":"INDEX(D150:D157,MATCH(C44,C150:C157,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX(E150:E157,MATCH(C44,C150:C157,0))","v":{"$error":"#N/A"}}]
[]
[null,null,"Final Finish in Tournament"]
[null,null,{"$f":"CONCATENATE(C12,\" \",\"T 3\")","v":"0 T 3"}]
[]
[]
[]
[null,null,"Tied for 3rd"]
[null,null,{"$f":"'Playoff Brackets'!Z9","v":""}]
[]
[null,null,"Games won in Pool",null,"Games lost in Pool"]
[4,null,{"$f":"INDEX(D150:D157,MATCH(C55,C150:C157,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX(E150:E157,MATCH(C55,C150:C157,0))","v":{"$error":"#N/A"}}]
[]
[null,null,"Final Finish in Tournament"]
[null,null,{"$f":"CONCATENATE(C12,\" \",\"T 3\")","v":"0 T 3"}]
[]
[]
[]
[null,null,"Soley in 5th place"]
[null,null,{"$f":"'Playoff Brackets'!Z10","v":""}]
[]
[null,null,"Games won in Pool",null,"Games lost in Pool"]
[5,null,{"$f":"INDEX(D150:D157,MATCH(C66,C150:C157,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX(E150:E157,MATCH(C66,C150:C157,0))","v":{"$error":"#N/A"}}]
[]
[null,null,"Final Finish in Tournament"]
[null,null,{"$f":"CONCATENATE(C12, \" \", \"5\")","v":"0 5"}]
[]
[]
[]
[null,null,"Solely in 6th Place"]
[null,null,{"$f":"'Playoff Brackets'!Z11","v":""}]
[]
[null,null,"Games won in Pool",null,"Games lost in Pool"]
[6,null,{"$f":"INDEX(D150:D157,MATCH(C77,C150:C157,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX(E150:E157,MATCH(C77,C150:C157,0))","v":{"$error":"#N/A"}}]
[]
[null,null,"Final Finish in Tournament"]
[null,null,{"$f":"CONCATENATE(C12, \" \", \"6\")","v":"0 6"}]
[]
[]
[]
[null,null,"Solely in 7th Place"]
[null,null,{"$f":"'Playoff Brackets'!Z12","v":""}]
[]
[null,null,"Games won in Pool",null,"Games lost in Pool"]
[7,null,{"$f":"INDEX(D150:D157,MATCH(C88,C150:C157,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX(E150:E157,MATCH(C88,C150:C157,0))","v":{"$error":"#N/A"}}]
[]
[null,null,"Final Finish in Tournament"]
[null,null,{"$f":"CONCATENATE(C12,\" \", \"7\")","v":"0 7"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Individual Team Results in pool"]
[]
[null,"Seed"]
[null,null,null,"W","L","Pool Finish"]
[null,1,{"$f":"'Enter Information Here'!B3","v":"Team 1 Pool A"},{"$f":"'Pool Points Calculator'!D44","v":0},{"$f":"'Pool Points Calculator'!E44","v":0},{"$f":"'Pool Points Calculator'!B44","v":1}]
[null,2,{"$f":"'Enter Information Here'!B4","v":"Team 1 Pool B"},{"$f":"'Pool Points Calculator'!L44","v":0},{"$f":"'Pool Points Calculator'!M44","v":0},{"$f":"'Pool Points Calculator'!J44","v":1}]
[null,3,{"$f":"'Enter Information Here'!B5","v":"Team 2 Pool B"},{"$f":"'Pool Points Calculator'!L45","v":0},{"$f":"'Pool Points Calculator'!M45","v":0},{"$f":"'Pool Points Calculator'!J45","v":1}]
[null,4,{"$f":"'Enter Information Here'!B6","v":"Team 2 Pool A"},{"$f":"'Pool Points Calculator'!D45","v":0},{"$f":"'Pool Points Calculator'!E45","v":0},{"$f":"'Pool Points Calculator'!B45","v":1}]
[null,5,{"$f":"'Enter Information Here'!B7","v":"Team 3 Pool A"},{"$f":"'Pool Points Calculator'!D46","v":0},{"$f":"'Pool Points Calculator'!E46","v":0},{"$f":"'Pool Points Calculator'!B46","v":1}]
[null,6,{"$f":"'Enter Information Here'!B8","v":"Team 3 Pool B"},{"$f":"'Pool Points Calculator'!L46","v":0},{"$f":"'Pool Points Calculator'!M46","v":0},{"$f":"'Pool Points Calculator'!J46","v":1}]
[null,7,{"$f":"'Enter Information Here'!B9","v":"Team 4 Pool A"},{"$f":"'Pool Points Calculator'!L47","v":0},{"$f":"'Pool Points Calculator'!M47","v":0},{"$f":"'Pool Points Calculator'!J47","v":1}]
[null,8,{"$f":"'Enter Information Here'!B10","v":0},0,0,1]
[]
[]
[null,null,"Championship Semi #1"]
[null,"Winner",{"$f":"'Playoff Brackets'!L9","v":""},{"$f":"INDEX('Playoff Brackets'!G6:G12,MATCH(C161,'Playoff Brackets'!B6:B12,0))","v":0},{"$f":"INDEX('Playoff Brackets'!H6:H12,MATCH(C161,'Playoff Brackets'!B6:B12,0))","v":0},{"$f":"INDEX('Playoff Brackets'!I6:I12,MATCH(C161,'Playoff Brackets'!B6:B12,0))","v":0}]
[null,"Loser",{"$f":"'Playoff Brackets'!Z8","v":""},{"$f":"INDEX('Playoff Brackets'!G6:G12,MATCH(C162,'Playoff Brackets'!B6:B12,0))","v":0},{"$f":"INDEX('Playoff Brackets'!H6:H12,MATCH(C162,'Playoff Brackets'!B6:B12,0))","v":0},{"$f":"INDEX('Playoff Brackets'!I6:I12,MATCH(C162,'Playoff Brackets'!B6:B12,0))","v":0}]
[]
[null,null,"Championship Semi #2"]
[null,"Winner",{"$f":"'Playoff Brackets'!L21","v":""},{"$f":"INDEX('Playoff Brackets'!G18:G24,MATCH(C165,'Playoff Brackets'!B18:B24,0))","v":0},{"$f":"INDEX('Playoff Brackets'!H18:H24,MATCH(C165,'Playoff Brackets'!B18:B24,0))","v":0},{"$f":"INDEX('Playoff Brackets'!I18:I24,MATCH(C165,'Playoff Brackets'!B18:B24,0))","v":0}]
[null,"Loser",{"$f":"'Playoff Brackets'!Z9","v":""},{"$f":"INDEX('Playoff Brackets'!G18:G24,MATCH(C166,'Playoff Brackets'!B18:B24,0))","v":0},{"$f":"INDEX('Playoff Brackets'!H18:H24,MATCH(C166,'Playoff Brackets'!B18:B24,0))","v":0},{"$f":"INDEX('Playoff Brackets'!I18:I24,MATCH(C166,'Playoff Brackets'!B18:B24,0))","v":0}]
[]
[null,null,"Championship Final"]
[null,"Winner",{"$f":"'Playoff Brackets'!Z6","v":""},{"$f":"INDEX('Playoff Brackets'!Q9:Q21,MATCH(C169,'Playoff Brackets'!L9:L21,0))","v":0},{"$f":"INDEX('Playoff Brackets'!R9:R21,MATCH(C169,'Playoff Brackets'!L9:L21,0))","v":0},{"$f":"INDEX('Playoff Brackets'!S9:S21,MATCH(C169,'Playoff Brackets'!L9:L21,0))","v":0}]
[null,"Loser",{"$f":"'Playoff Brackets'!Z7","v":""},{"$f":"INDEX('Playoff Brackets'!Q9:Q21,MATCH(C170,'Playoff Brackets'!L9:L21,0))","v":0},{"$f":"INDEX('Playoff Brackets'!R9:R21,MATCH(C170,'Playoff Brackets'!L9:L21,0))","v":0},{"$f":"INDEX('Playoff Brackets'!S9:S21,MATCH(C170,'Playoff Brackets'!L9:L21,0))","v":0}]
[]
[null,null,"Consolation Semi #1"]
[null,"Winner",{"$f":"'Playoff Brackets'!L34","v":""},{"$f":"INDEX('Playoff Brackets'!G31:G37,MATCH(C173,'Playoff Brackets'!B31:B37,0))","v":0},{"$f":"INDEX('Playoff Brackets'!H31:H37,MATCH(C173,'Playoff Brackets'!B31:B37,0))","v":0},{"$f":"INDEX('Playoff Brackets'!I31:I37,MATCH(C173,'Playoff Brackets'!B31:B37,0))","v":0}]
[null,"Loser",{"$f":"'Playoff Brackets'!Z12","v":""},{"$f":"INDEX('Playoff Brackets'!G31:G37,MATCH(C174,'Playoff Brackets'!B31:B37,0))","v":0},{"$f":"INDEX('Playoff Brackets'!H31:H37,MATCH(C174,'Playoff Brackets'!B31:B37,0))","v":0},{"$f":"INDEX('Playoff Brackets'!I31:I37,MATCH(C174,'Playoff Brackets'!B31:B37,0))","v":0}]
[]
[null,null,"Consolation Semi #2"]
[null,"Winner","","","",""]
[null,"Loser","","","",""]
[]
[null,null,"Consolation Final"]
[null,"Winner",{"$f":"'Playoff Brackets'!Z10","v":""},{"$f":"INDEX('Playoff Brackets'!Q34:Q46,MATCH(C181,'Playoff Brackets'!L34:L46,0))","v":0},{"$f":"INDEX('Playoff Brackets'!R34:R46,MATCH(C181,'Playoff Brackets'!L34:L46,0))","v":0},{"$f":"INDEX('Playoff Brackets'!S34:S46,MATCH(C181,'Playoff Brackets'!L34:L46,0))","v":0}]
[null,"Loser",{"$f":"'Playoff Brackets'!Z11","v":""},{"$f":"INDEX('Playoff Brackets'!Q34:Q46,MATCH(C182,'Playoff Brackets'!L34:L46,0))","v":0},{"$f":"INDEX('Playoff Brackets'!R34:R46,MATCH(C182,'Playoff Brackets'!L34:L46,0))","v":0},{"$f":"INDEX('Playoff Brackets'!S34:S46,MATCH(C182,'Playoff Brackets'!L34:L46,0))","v":0}]