{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SETUP","SCORES","STANDINGS","BRACKETS","CALCS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"SETUP","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,4,37,6],[38,4,38,6],[36,0,38,1],[34,0,34,10],[33,0,33,10],[6,0,9,10],[11,1,11,2],[36,4,36,6],[12,0,15,0],[17,0,20,0],[22,0,25,0],[27,0,30,0],[5,0,5,4],[0,0,0,9],[2,0,2,1],[3,0,3,1],[2,7,2,9],[3,7,3,9]]}
["TOURNAMENT SETUP"]
[]
["<date>",null,null,"<tournament>",null,"<div>",null,"<location>"]
["DATE ",null,null,"TOURNAMENT ",null,"DIVISION ",null,"LOCATION"]
[]
["POOL SETUP",null,null,null,null,{"$f":"CALCS!AF1","v":16},"TEAM FORMAT"]
["Using the pool list below, enter team names into their assigned pools.  Follow the USAV Playoff Brack Format Sheet for instructions on how to setup your pools.  Leave empty pool positions blank.  Failure to setup the pools correctly will disable and invalidate the remainder of this tool.\nThe only formats currentl supported are: 8, 10, 11, 12, 13, 14, 15, and 16 Team formats."]
[]
[]
[]
[]
["POOL","POS",null,"TEAM"]
["A",1,{"$f":"IF(D13=0, 0, 1)","v":1},"<team>",null,"Each team will play",null,{"$f":"HLOOKUP(SUM(C$13:C$31),CALCS!B$127:I$131,2,FALSE)","v":3},"matches"]
[null,2,{"$f":"IF(D14=0, 0, 1)","v":1},"<team>",null,"Best of",{"$f":"HLOOKUP(SUM(C$13:C$31),CALCS!B$133:I$137,2,FALSE)","v":3},"sets each"]
[null,3,1,"<team>",null,{"$f":"HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)","v":2},"Set wins required for Match win"]
[null,4,1,"<team>"]
[]
["B",1,{"$f":"IF(D18=0, 0, 1)","v":1},"<team>",null,"Each team will play",null,{"$f":"HLOOKUP(SUM(C$13:C$31),CALCS!B$127:I$131,3,FALSE)","v":3},"matches"]
[null,2,1,"<team>",null,"Best of",{"$f":"HLOOKUP(SUM(C$13:C$31),CALCS!B$133:I$137,3,FALSE)","v":3},"sets each"]
[null,3,1,"<team>",null,{"$f":"HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)","v":2},"Set wins required for Match win"]
[null,4,1,"<team>"]
[]
["C",1,{"$f":"IF(D23=0, 0, 1)","v":1},"<team>",null,"Each team will play",null,{"$f":"HLOOKUP(SUM(C$13:C$31),CALCS!B$127:I$131,4,FALSE)","v":3},"matches"]
[null,2,1,"<team>",null,"Best of",{"$f":"HLOOKUP(SUM(C$13:C$31),CALCS!B$133:I$137,4,FALSE)","v":3},"sets each"]
[null,3,1,"<team>",null,{"$f":"HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)","v":2},"Set wins required for Match win"]
[null,4,1,"<team>"]
[]
["D",1,1,"<team>",null,"Each team will play",null,{"$f":"HLOOKUP(SUM(C$13:C$31),CALCS!B$127:I$131,5,FALSE)","v":3},"matches"]
[null,2,1,"<team>",null,"Best of",{"$f":"HLOOKUP(SUM(C$13:C$31),CALCS!B$133:I$137,5,FALSE)","v":3},"sets each"]
[null,3,1,"<team>",null,{"$f":"HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)","v":2},"Set wins required for Match win"]
[null,4,1,"<team>"]
[]
[]
["BREAKING 3RD PLACE TIES (11 and 12 Team Formats Only)"]
["The following logic is ONLY used to determine the 1st, 2nd, and 3rd Best Third-Place-Teams in tournament formats where it is necessary.  In the event that the resulting RANK still shows a tie, a coin toss is used to break the tie.  For 2-way ties, only a single coin toss is required. Enter \"1\" for the winner.  If breaking a 3-way tie, record the result of the 2nd coin toss in the appropriate cell."]
[null,null,null,null,null,null,null,"Rank Before\nCoin Toss","1st\nCoin Toss","2nd\nCoin Toss","FINAL\n3rd Place\nRank"]
["THIRD PLACE TEAMS",null,null,{"$f":"CALCS!A120","v":"Pool A"},{"$f":"CALCS!B120","v":0},null,null,{"$f":"CALCS!O120","v":1},null,null,{"$f":"CALCS!P120","v":" "}]
[null,null,null,{"$f":"CALCS!A121","v":"Pool B"},{"$f":"CALCS!B121","v":0},null,null,{"$f":"CALCS!O121","v":1},null,null,{"$f":"CALCS!P121","v":" "}]
[null,null,null,{"$f":"CALCS!A122","v":"Pool C"},{"$f":"CALCS!B122","v":0},null,null,{"$f":"CALCS!O122","v":1},null,null,{"$f":"CALCS!P122","v":" "}]

{"sheet":"SCORES","index":1,"n_rows":75,"n_cols":15,"rows_kept":75,"cut":false,"hidden":false,"merged":[[50,3,50,9],[42,4,42,6],[33,3,33,9],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6],[41,4,41,6],[35,4,35,6],[36,4,36,6],[2,9,2,10],[2,11,2,12],[0,0,0,14],[25,0,27,0],[25,1,29,1],[23,0,23,2],[2,13,2,14],[2,3,2,4],[2,5,2,6],[2,7,2,8],[30,0,30,2],[16,0,16,2],[4,0,6,0],[4,1,8,1],[11,0,13,0],[11,1,15,1],[18,0,20,0],[18,1,22,1],[9,0,9,2],[61,4,61,6],[43,4,43,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[47,4,47,6],[48,4,48,6],[60,4,60,6],[59,4,59,6],[58,4,58,6],[57,4,57,6],[56,4,56,6],[55,4,55,6],[54,4,54,6],[53,4,53,6],[52,4,52,6],[62,4,62,6],[63,4,63,6],[64,4,64,6],[65,4,65,6],[67,3,67,9],[74,4,74,6],[69,4,69,6],[70,4,70,6],[71,4,71,6],[72,4,72,6],[73,4,73,6]]}
["TOURNAMENT SCORE SUMMARY"]
[]
[null,null,null,"Match 1\n1 vs. 3\n(2 refs)",null,"Match 2\n2 vs. 4\n(1 refs)",null,"Match 3\n1 vs. 4\n(3 refs)",null,"Match 4\n2 vs. 3\n(1 refs)",null,"Match 5\n3 vs. 4\n(2 refs)",null,"Match 6\n1 vs. 2\n(4 refs)"]
[null,null,"SET","#1","#3","#2","#4","#1","#4","#2","#3","#3","#4","#1","#2"]
["3\n-\nS\nE\nT","5\n-\nS\nE\nT","A1"]
[null,null,"A2"]
[null,null,"A3"]
[null,null,"A4"]
[null,null,"A5"]
["COIN FLIP (enter 1)"]
[null,null,null,"#1","#3","#2","#4","#1","#4","#2","#3","#3","#4","#1","#2"]
["3\n-\nS\nE\nT","5\n-\nS\nE\nT","B1"]
[null,null,"B2"]
[null,null,"B3"]
[null,null,"B4"]
[null,null,"B5"]
["COIN FLIP (enter 1)"]
[null,null,null,"#1","#3","#2","#4","#1","#4","#2","#3","#3","#4","#1","#2"]
["3\n-\nS\nE\nT","5\n-\nS\nE\nT","C1"]
[null,null,"C2"]
[null,null,"C3"]
[null,null,"C4"]
[null,null,"C5"]
["COIN FLIP (enter 1)"]
[null,null,null,"#1","#3","#2","#4","#1","#4","#2","#3","#3","#4","#1","#2"]
["3\n-\nS\nE\nT","5\n-\nS\nE\nT","D1"]
[null,null,"D2"]
[null,null,"D3"]
[null,null,"D4"]
[null,null,"D5"]
["COIN FLIP (enter 1)"]
[]
[]
[null,null,null,"GOLD BRACKET SCORES"]
[null,null,null,null,null,null,null,"Set 1","Set 2","Set 3"]
[null,null,null,{"$f":"CALCS!AF3","v":"M1"},{"$f":"CALCS!AI3","v":" "}]
[null,null,null,null,{"$f":"CALCS!AI4","v":" "}]
[null,null,null,{"$f":"CALCS!AF5","v":"M5"},{"$f":"CALCS!AI5","v":" "}]
[null,null,null,null,{"$f":"CALCS!AI6","v":" "}]
[null,null,null,{"$f":"CALCS!AF7","v":"M2"},{"$f":"CALCS!AI7","v":" "}]
[null,null,null,null,{"$f":"CALCS!AI8","v":" "}]
[null,null,null,{"$f":"CALCS!AF9","v":"M6"},{"$f":"CALCS!AI9","v":" "}]
[null,null,null,null,{"$f":"CALCS!AI10","v":" "}]
[null,null,null,{"$f":"CALCS!AF11","v":"M9"},{"$f":"CALCS!AI11","v":" "}]
[null,null,null,null,{"$f":"CALCS!AI12","v":" "}]
[null,null,null,{"$f":"CALCS!AF13","v":"M10"},{"$f":"CALCS!AI13","v":" "}]
[null,null,null,null,{"$f":"CALCS!AI14","v":" "}]
[null,null,null,{"$f":"CALCS!AF15","v":"M13"},{"$f":"CALCS!AI15","v":" "}]
[null,null,null,{"$f":"CALCS!AF16","v":" "},{"$f":"CALCS!AI16","v":" "}]
[]
[null,null,null,"SILVER BRACKET SCORES"]
[null,null,null,null,null,null,null,"Set 1","Set 2","Set 3"]
[null,null,null,{"$f":"CALCS!AF18","v":" "},{"$f":"CALCS!AI18","v":" "}]
[null,null,null,{"$f":"CALCS!AF19","v":" "},{"$f":"CALCS!AI19","v":" "}]
[null,null,null,{"$f":"CALCS!AF20","v":" "},{"$f":"CALCS!AI20","v":" "}]
[null,null,null,{"$f":"CALCS!AF21","v":" "},{"$f":"CALCS!AI21","v":" "}]
[null,null,null,{"$f":"CALCS!AF22","v":" "},{"$f":"CALCS!AI22","v":" "}]
[null,null,null,{"$f":"CALCS!AF23","v":" "},{"$f":"CALCS!AI23","v":" "}]
[null,null,null,{"$f":"CALCS!AF24","v":" "},{"$f":"CALCS!AI24","v":" "}]
[null,null,null,{"$f":"CALCS!AF25","v":" "},{"$f":"CALCS!AI25","v":" "}]
[null,null,null,{"$f":"CALCS!AF26","v":"M3"},{"$f":"CALCS!AI26","v":" "}]
[null,null,null,{"$f":"CALCS!AF27","v":" "},{"$f":"CALCS!AI27","v":" "}]
[null,null,null,{"$f":"CALCS!AF28","v":"M7"},{"$f":"CALCS!AI28","v":" "}]
[null,null,null,{"$f":"CALCS!AF29","v":" "},{"$f":"CALCS!AI29","v":" "}]
[null,null,null,{"$f":"CALCS!AF30","v":"M11"},{"$f":"CALCS!AI30","v":" "}]
[null,null,null,null,{"$f":"CALCS!AI31","v":" "}]
[]
[null,null,null,"BRONZE BRACKET SCORES"]
[null,null,null,null,null,null,null,"Set 1","Set 2","Set 3"]
[null,null,null,{"$f":"CALCS!AF33","v":"M4"},{"$f":"CALCS!AI33","v":" "}]
[null,null,null,{"$f":"CALCS!AF34","v":" "},{"$f":"CALCS!AI34","v":" "}]
[null,null,null,{"$f":"CALCS!AF35","v":"M8"},{"$f":"CALCS!AI35","v":" "}]
[null,null,null,{"$f":"CALCS!AF36","v":" "},{"$f":"CALCS!AI36","v":" "}]
[null,null,null,{"$f":"CALCS!AF37","v":"M12"},{"$f":"CALCS!AI37","v":" "}]
[null,null,null,{"$f":"CALCS!AF38","v":" "},{"$f":"CALCS!AI38","v":" "}]

{"sheet":"STANDINGS","index":2,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[53,3,53,5],[0,0,0,9],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[46,5,46,9],[47,5,47,9],[48,5,48,9],[49,5,49,9],[41,5,41,9],[42,5,42,9],[43,5,43,9],[44,5,44,9],[45,5,45,9],[51,1,51,3],[41,1,41,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3]]}
["Tournament Standings Report"]
[]
["A","Teams","Matches\nWon","Matches\nLost","Sets\nWon","Sets\nLost","Match %","Set %","Point\nDiff","Finish"]
[1,{"$f":"IF(SETUP!D13=0, \" \", SETUP!D13)","v":"<team>"},{"$f":"IF($B4=\" \", \" \",CALCS!B10+CALCS!F10+CALCS!L10)","v":0},{"$f":"IF($B4=\" \", \" \",CALCS!C10+CALCS!G10+CALCS!M10)","v":0},{"$f":"IF($B4=\" \", \" \",CALCS!B8+CALCS!F8+CALCS!L8)","v":0},{"$f":"IF($B4=\" \", \" \",CALCS!C8+CALCS!G8+CALCS!M8)","v":0},{"$f":"IF($B4=\" \", \" \",IF(((C4+D4)>0),C4/(C4+D4),0))","v":0},{"$f":"IF($B4=\" \", \" \",IF(((E4+F4)>0),E4/(E4+F4),0))","v":0},{"$f":"IF($B4=\" \", \" \",SCORES!D5+SCORES!D6+SCORES!D7+SCORES!H5+SCORES!H6+SCORES!H7+SCORES!N5+SCORES!N6+SCORES!N7-SCORES!E5-SCORES!E6-SCORES!E7-SCORES!I5-SCORES!I6-SCORES!I7-SCORES!O5-SCORES!O6-SCORES!O7)","v":0},{"$f":"CALCS!P45","v":" "}]
[2,{"$f":"IF(SETUP!D14=0, \" \", SETUP!D14)","v":"<team>"},{"$f":"IF($B5=\" \", \" \",CALCS!D10+CALCS!H10+CALCS!M10)","v":0},{"$f":"IF($B5=\" \", \" \",CALCS!E10+CALCS!I10+CALCS!L10)","v":0},{"$f":"IF($B5=\" \", \" \",CALCS!D8+CALCS!H8+CALCS!M8)","v":0},{"$f":"IF($B5=\" \", \" \",CALCS!E8+CALCS!I8+CALCS!L8)","v":0},{"$f":"IF($B5=\" \", \" \",IF(((C5+D5)>0),C5/(C5+D5),0))","v":0},{"$f":"IF($B5=\" \", \" \",IF(((E5+F5)>0),E5/(E5+F5),0))","v":0},{"$f":"IF($B5=\" \", \" \",SCORES!F5+SCORES!F6+SCORES!F7+SCORES!J5+SCORES!J6+SCORES!J7+SCORES!O5+SCORES!O6+SCORES!O7-SCORES!G5-SCORES!G6-SCORES!G7-SCORES!K5-SCORES!K6-SCORES!K7-SCORES!N5-SCORES!N6-SCORES!N7)","v":0},{"$f":"CALCS!P46","v":" "}]
[3,{"$f":"IF(SETUP!D15=0, \" \", SETUP!D15)","v":"<team>"},{"$f":"IF($B6=\" \", \" \",CALCS!C10+CALCS!I10+CALCS!J10)","v":0},{"$f":"IF($B6=\" \", \" \",CALCS!B10+CALCS!H10+CALCS!K10)","v":0},{"$f":"IF($B6=\" \", \" \",CALCS!C8+CALCS!I8+CALCS!J8)","v":0},{"$f":"IF($B6=\" \", \" \",CALCS!B8+CALCS!H8+CALCS!K8)","v":0},{"$f":"IF($B6=\" \", \" \",IF(((C6+D6)>0),C6/(C6+D6),0))","v":0},{"$f":"IF($B6=\" \", \" \",IF(((E6+F6)>0),E6/(E6+F6),0))","v":0},{"$f":"IF($B6=\" \", \" \",SCORES!E5+SCORES!E6+SCORES!E7+SCORES!K5+SCORES!K6+SCORES!K7+SCORES!L5+SCORES!L6+SCORES!L7-SCORES!D5-SCORES!D6-SCORES!D7-SCORES!J5-SCORES!J6-SCORES!J7-SCORES!M5-SCORES!M6-SCORES!M7)","v":0},{"$f":"CALCS!P47","v":" "}]
[4,{"$f":"IF(SETUP!D16=0, \" \", SETUP!D16)","v":"<team>"},{"$f":"IF($B7=\" \", \" \",CALCS!E10+CALCS!G10+CALCS!K10)","v":0},{"$f":"IF($B7=\" \", \" \",CALCS!D10+CALCS!F10+CALCS!J10)","v":0},{"$f":"IF($B7=\" \", \" \",CALCS!E8+CALCS!G8+CALCS!K8)","v":0},{"$f":"IF($B7=\" \", \" \",CALCS!D8+CALCS!F8+CALCS!J8)","v":0},{"$f":"IF($B7=\" \", \" \",IF(((C7+D7)>0),C7/(C7+D7),0))","v":0},{"$f":"IF($B7=\" \", \" \",IF(((E7+F7)>0),E7/(E7+F7),0))","v":0},{"$f":"IF($B7=\" \", \" \",SCORES!G5+SCORES!G6+SCORES!G7+SCORES!I5+SCORES!I6+SCORES!I7+SCORES!M5+SCORES!M6+SCORES!M7-SCORES!F5-SCORES!F6-SCORES!F7-SCORES!H5-SCORES!H6-SCORES!H7-SCORES!L5-SCORES!L6-SCORES!L7)","v":0},{"$f":"CALCS!P48","v":" "}]
[]
[]
[]
[]
[]
[]
["B","Teams","Matches\nWon","Matches\nLost","Sets\nWon","Sets\nLost","Match %","Set %","Point\nDiff","Finish"]
[1,{"$f":"IF(SETUP!D18=0, \" \", SETUP!D18)","v":"<team>"},{"$f":"IF($B15=\" \", \" \",CALCS!B20+CALCS!F20+CALCS!L20)","v":0},{"$f":"IF($B15=\" \", \" \",CALCS!C20+CALCS!G20+CALCS!M20)","v":0},{"$f":"IF($B15=\" \", \" \",CALCS!B18+CALCS!F18+CALCS!L18)","v":0},{"$f":"IF($B15=\" \", \" \",CALCS!C18+CALCS!G18+CALCS!M18)","v":0},{"$f":"IF($B15=\" \", \" \",IF(((C15+D15)>0),C15/(C15+D15),0))","v":0},{"$f":"IF($B15=\" \", \" \",IF(((E15+F15)>0),E15/(E15+F15),0))","v":0},{"$f":"IF($B15=\" \", \" \",SCORES!D12+SCORES!D13+SCORES!D14+SCORES!H12+SCORES!H13+SCORES!H14+SCORES!N12+SCORES!N13+SCORES!N14-SCORES!E12-SCORES!E13-SCORES!E14-SCORES!I12-SCORES!I13-SCORES!I14-SCORES!O12-SCORES!O13-SCORES!O14)","v":0},{"$f":"CALCS!P55","v":" "}]
[2,{"$f":"IF(SETUP!D19=0, \" \", SETUP!D19)","v":"<team>"},{"$f":"IF($B16=\" \", \" \",CALCS!D20+CALCS!H20+CALCS!M20)","v":0},{"$f":"IF($B16=\" \", \" \",CALCS!E20+CALCS!I20+CALCS!L20)","v":0},{"$f":"IF($B16=\" \", \" \",CALCS!D18+CALCS!H18+CALCS!M18)","v":0},{"$f":"IF($B16=\" \", \" \",CALCS!E18+CALCS!I18+CALCS!L18)","v":0},{"$f":"IF($B16=\" \", \" \",IF(((C16+D16)>0),C16/(C16+D16),0))","v":0},{"$f":"IF($B16=\" \", \" \",IF(((E16+F16)>0),E16/(E16+F16),0))","v":0},{"$f":"IF($B16=\" \", \" \",SCORES!F12+SCORES!F13+SCORES!F14+SCORES!J12+SCORES!J13+SCORES!J14+SCORES!O12+SCORES!O13+SCORES!O14-SCORES!G12-SCORES!G13-SCORES!G14-SCORES!K12-SCORES!K13-SCORES!K14-SCORES!N12-SCORES!N13-SCORES!N14)","v":0},{"$f":"CALCS!P56","v":" "}]
[3,{"$f":"IF(SETUP!D20=0, \" \", SETUP!D20)","v":"<team>"},{"$f":"IF($B17=\" \", \" \",CALCS!C20+CALCS!I20+CALCS!J20)","v":0},{"$f":"IF($B17=\" \", \" \",CALCS!B20+CALCS!H20+CALCS!K20)","v":0},{"$f":"IF($B17=\" \", \" \",CALCS!C18+CALCS!I18+CALCS!J18)","v":0},{"$f":"IF($B17=\" \", \" \",CALCS!B18+CALCS!H18+CALCS!K18)","v":0},{"$f":"IF($B17=\" \", \" \",IF(((C17+D17)>0),C17/(C17+D17),0))","v":0},{"$f":"IF($B17=\" \", \" \",IF(((E17+F17)>0),E17/(E17+F17),0))","v":0},{"$f":"IF($B17=\" \", \" \",SCORES!E12+SCORES!E13+SCORES!E14+SCORES!K12+SCORES!K13+SCORES!K14+SCORES!L12+SCORES!L13+SCORES!L14-SCORES!D12-SCORES!D13-SCORES!D14-SCORES!J12-SCORES!J13-SCORES!J14-SCORES!M12-SCORES!M13-SCORES!M14)","v":0},{"$f":"CALCS!P57","v":" "}]
[4,{"$f":"IF(SETUP!D21=0, \" \", SETUP!D21)","v":"<team>"},{"$f":"IF($B18=\" \", \" \",CALCS!E20+CALCS!G20+CALCS!K20)","v":0},{"$f":"IF($B18=\" \", \" \",CALCS!D20+CALCS!F20+CALCS!J20)","v":0},{"$f":"IF($B18=\" \", \" \",CALCS!E18+CALCS!G18+CALCS!K18)","v":0},{"$f":"IF($B18=\" \", \" \",CALCS!D18+CALCS!F18+CALCS!J18)","v":0},{"$f":"IF($B18=\" \", \" \",IF(((C18+D18)>0),C18/(C18+D18),0))","v":0},{"$f":"IF($B18=\" \", \" \",IF(((E18+F18)>0),E18/(E18+F18),0))","v":0},{"$f":"IF($B18=\" \", \" \",SCORES!G12+SCORES!G13+SCORES!G14+SCORES!I12+SCORES!I13+SCORES!I14+SCORES!M12+SCORES!M13+SCORES!M14-SCORES!F12-SCORES!F13-SCORES!F14-SCORES!H12-SCORES!H13-SCORES!H14-SCORES!L12-SCORES!L13-SCORES!L14)","v":0},{"$f":"CALCS!P58","v":" "}]
[]
[]
[]
[]
[]
[]
["C","Teams","Matches\nWon","Matches\nLost","Sets\nWon","Sets\nLost","Match %","Set %","Point\nDiff","Finish"]
[1,{"$f":"IF(SETUP!D23=0, \" \", SETUP!D23)","v":"<team>"},{"$f":"IF($B26=\" \", \" \",CALCS!B30+CALCS!F30+CALCS!L30)","v":0},{"$f":"IF($B26=\" \", \" \",CALCS!C30+CALCS!G30+CALCS!M30)","v":0},{"$f":"IF($B26=\" \", \" \",CALCS!B28+CALCS!F28+CALCS!L28)","v":0},{"$f":"IF($B26=\" \", \" \",CALCS!C28+CALCS!G28+CALCS!M28)","v":0},{"$f":"IF($B26=\" \", \" \",IF(((C26+D26)>0),C26/(C26+D26),0))","v":0},{"$f":"IF($B26=\" \", \" \",IF(((E26+F26)>0),E26/(E26+F26),0))","v":0},{"$f":"IF($B26=\" \", \" \",SCORES!D19+SCORES!D20+SCORES!D21+SCORES!H19+SCORES!H20+SCORES!H21+SCORES!N19+SCORES!N20+SCORES!N21-SCORES!E19-SCORES!E20-SCORES!E21-SCORES!I19-SCORES!I20-SCORES!I21-SCORES!O19-SCORES!O20-SCORES!O21)","v":0},{"$f":"CALCS!P65","v":" "}]
[2,{"$f":"IF(SETUP!D24=0, \" \", SETUP!D24)","v":"<team>"},{"$f":"IF($B27=\" \", \" \",CALCS!D30+CALCS!H30+CALCS!M30)","v":0},{"$f":"IF($B27=\" \", \" \",CALCS!E30+CALCS!I30+CALCS!L30)","v":0},{"$f":"IF($B27=\" \", \" \",CALCS!D28+CALCS!H28+CALCS!M28)","v":0},{"$f":"IF($B27=\" \", \" \",CALCS!E28+CALCS!I28+CALCS!L28)","v":0},{"$f":"IF($B27=\" \", \" \",IF(((C27+D27)>0),C27/(C27+D27),0))","v":0},{"$f":"IF($B27=\" \", \" \",IF(((E27+F27)>0),E27/(E27+F27),0))","v":0},{"$f":"IF($B27=\" \", \" \",SCORES!F19+SCORES!F20+SCORES!F21+SCORES!J19+SCORES!J20+SCORES!J21+SCORES!O19+SCORES!O20+SCORES!O21-SCORES!G19-SCORES!G20-SCORES!G21-SCORES!K19-SCORES!K20-SCORES!K21-SCORES!N19-SCORES!N20-SCORES!N21)","v":0},{"$f":"CALCS!P66","v":" "}]
[3,{"$f":"IF(SETUP!D25=0, \" \", SETUP!D25)","v":"<team>"},{"$f":"IF($B28=\" \", \" \",CALCS!C30+CALCS!I30+CALCS!J30)","v":0},{"$f":"IF($B28=\" \", \" \",CALCS!B30+CALCS!H30+CALCS!K30)","v":0},{"$f":"IF($B28=\" \", \" \",CALCS!C28+CALCS!I28+CALCS!J28)","v":0},{"$f":"IF($B28=\" \", \" \",CALCS!B28+CALCS!H28+CALCS!K28)","v":0},{"$f":"IF($B28=\" \", \" \",IF(((C28+D28)>0),C28/(C28+D28),0))","v":0},{"$f":"IF($B28=\" \", \" \",IF(((E28+F28)>0),E28/(E28+F28),0))","v":0},{"$f":"IF($B28=\" \", \" \",SCORES!E19+SCORES!E20+SCORES!E21+SCORES!K19+SCORES!K20+SCORES!K21+SCORES!L19+SCORES!L20+SCORES!L21-SCORES!D19-SCORES!D20-SCORES!D21-SCORES!J19-SCORES!J20-SCORES!J21-SCORES!M19-SCORES!M20-SCORES!M21)","v":0},{"$f":"CALCS!P67","v":" "}]
[4,{"$f":"IF(SETUP!D26=0, \" \", SETUP!D26)","v":"<team>"},{"$f":"IF($B29=\" \", \" \",CALCS!E30+CALCS!G30+CALCS!K30)","v":0},{"$f":"IF($B29=\" \", \" \",CALCS!D30+CALCS!F30+CALCS!J30)","v":0},{"$f":"IF($B29=\" \", \" \",CALCS!E28+CALCS!G28+CALCS!K28)","v":0},{"$f":"IF($B29=\" \", \" \",CALCS!D28+CALCS!F28+CALCS!J28)","v":0},{"$f":"IF($B29=\" \", \" \",IF(((C29+D29)>0),C29/(C29+D29),0))","v":0},{"$f":"IF($B29=\" \", \" \",IF(((E29+F29)>0),E29/(E29+F29),0))","v":0},{"$f":"IF($B29=\" \", \" \",SCORES!G19+SCORES!G20+SCORES!G21+SCORES!I19+SCORES!I20+SCORES!I21+SCORES!M19+SCORES!M20+SCORES!M21-SCORES!F19-SCORES!F20-SCORES!F21-SCORES!H19-SCORES!H20-SCORES!H21-SCORES!L19-SCORES!L20-SCORES!L21)","v":0},{"$f":"CALCS!P68","v":" "}]
[]
[]
[]
[]
[]
[]
["D","Teams","Matches\nWon","Matches\nLost","Sets\nWon","Sets\nLost","Match %","Set %","Point\nDiff","Finish"]
[1,{"$f":"IF(SETUP!D28=0, \" \", SETUP!D28)","v":"<team>"},{"$f":"IF($B37=\" \", \" \",CALCS!B40+CALCS!F40+CALCS!L40)","v":0},{"$f":"IF($B37=\" \", \" \",CALCS!C40+CALCS!G40+CALCS!M40)","v":0},{"$f":"IF($B37=\" \", \" \",CALCS!B38+CALCS!F38+CALCS!L38)","v":0},{"$f":"IF($B37=\" \", \" \",CALCS!C38+CALCS!G38+CALCS!M38)","v":0},{"$f":"IF($B37=\" \", \" \",IF(((C37+D37)>0),C37/(C37+D37),0))","v":0},{"$f":"IF($B37=\" \", \" \",IF(((E37+F37)>0),E37/(E37+F37),0))","v":0},{"$f":"IF($B37=\" \", \" \",SCORES!D26+SCORES!D27+SCORES!D28+SCORES!H26+SCORES!H27+SCORES!H28+SCORES!N26+SCORES!N27+SCORES!N28-SCORES!E26-SCORES!E27-SCORES!E28-SCORES!I26-SCORES!I27-SCORES!I28-SCORES!O26-SCORES!O27-SCORES!O28)","v":0},{"$f":"CALCS!P75","v":" "}]
[2,{"$f":"IF(SETUP!D29=0, \" \", SETUP!D29)","v":"<team>"},{"$f":"IF($B38=\" \", \" \",CALCS!D40+CALCS!H40+CALCS!M40)","v":0},{"$f":"IF($B38=\" \", \" \",CALCS!E40+CALCS!I40+CALCS!L40)","v":0},{"$f":"IF($B38=\" \", \" \",CALCS!D38+CALCS!H38+CALCS!M38)","v":0},{"$f":"IF($B38=\" \", \" \",CALCS!E38+CALCS!I38+CALCS!L38)","v":0},{"$f":"IF($B38=\" \", \" \",IF(((C38+D38)>0),C38/(C38+D38),0))","v":0},{"$f":"IF($B38=\" \", \" \",IF(((E38+F38)>0),E38/(E38+F38),0))","v":0},{"$f":"IF($B38=\" \", \" \",SCORES!F26+SCORES!F27+SCORES!F28+SCORES!J26+SCORES!J27+SCORES!J28+SCORES!O26+SCORES!O27+SCORES!O28-SCORES!G26-SCORES!G27-SCORES!G28-SCORES!K26-SCORES!K27-SCORES!K28-SCORES!N26-SCORES!N27-SCORES!N28)","v":0},{"$f":"CALCS!P76","v":" "}]
[3,{"$f":"IF(SETUP!D30=0, \" \", SETUP!D30)","v":"<team>"},{"$f":"IF($B39=\" \", \" \",CALCS!C40+CALCS!I40+CALCS!J40)","v":0},{"$f":"IF($B39=\" \", \" \",CALCS!B40+CALCS!H40+CALCS!K40)","v":0},{"$f":"IF($B39=\" \", \" \",CALCS!C38+CALCS!I38+CALCS!J38)","v":0},{"$f":"IF($B39=\" \", \" \",CALCS!B38+CALCS!H38+CALCS!K38)","v":0},{"$f":"IF($B39=\" \", \" \",IF(((C39+D39)>0),C39/(C39+D39),0))","v":0},{"$f":"IF($B39=\" \", \" \",IF(((E39+F39)>0),E39/(E39+F39),0))","v":0},{"$f":"IF($B39=\" \", \" \",SCORES!E26+SCORES!E27+SCORES!E28+SCORES!K26+SCORES!K27+SCORES!K28+SCORES!L26+SCORES!L27+SCORES!L28-SCORES!D26-SCORES!D27-SCORES!D28-SCORES!J26-SCORES!J27-SCORES!J28-SCORES!M26-SCORES!M27-SCORES!M28)","v":0},{"$f":"CALCS!P77","v":" "}]
[4,{"$f":"IF(SETUP!D31=0, \" \", SETUP!D31)","v":"<team>"},{"$f":"IF($B40=\" \", \" \",CALCS!E40+CALCS!G40+CALCS!K40)","v":0},{"$f":"IF($B40=\" \", \" \",CALCS!D40+CALCS!F40+CALCS!J40)","v":0},{"$f":"IF($B40=\" \", \" \",CALCS!E38+CALCS!G38+CALCS!K38)","v":0},{"$f":"IF($B40=\" \", \" \",CALCS!D38+CALCS!F38+CALCS!J38)","v":0},{"$f":"IF($B40=\" \", \" \",IF(((C40+D40)>0),C40/(C40+D40),0))","v":0},{"$f":"IF($B40=\" \", \" \",IF(((E40+F40)>0),E40/(E40+F40),0))","v":0},{"$f":"IF($B40=\" \", \" \",SCORES!G26+SCORES!G27+SCORES!G28+SCORES!I26+SCORES!I27+SCORES!I28+SCORES!M26+SCORES!M27+SCORES!M28-SCORES!F26-SCORES!F27-SCORES!F28-SCORES!H26-SCORES!H27-SCORES!H28-SCORES!L26-SCORES!L27-SCORES!L28)","v":0},{"$f":"CALCS!P78","v":" "}]
[]
[null,"RESOLVING POOL FINISH TIES",null,null,null,"RESOLVING 'BEST 3RD PLACE TEAM' TIES"]
[null,null,null,null,null,"For 11 & 12 Team Formats Only"]
[null,"2-TEAM MATCH % TIE"]
[null,"Head to Head Result",null,null,null,"2 or 3-TEAM MATCH % TIE"]
[null,null,null,null,null,"Set % Order"]
[null,"3-TEAM MATCH % TIE",null,null,null,"If Set % Tie"]
[null,"Set % Order",null,null,null,"Overall Point Differential"]
[null,"If Set % Tie",null,null,null,"If Remaining Ties"]
[null,"Overall Point Differential",null,null,null,"Coin Toss Procedure"]
[null,"If Remaining Ties"]
[null,"Coin Toss Procedure"]

{"sheet":"BRACKETS","index":3,"n_rows":115,"n_cols":37,"rows_kept":115,"cut":false,"hidden":false,"merged":[[2,0,2,9],[4,10,4,19],[6,0,6,9],[8,20,8,29],[18,22,18,29],[8,12,8,19],[18,30,18,39],[11,2,12,9],[4,2,5,9],[4,0,5,1],[11,0,12,1],[14,0,14,6],[8,10,8,11],[3,0,3,6],[7,0,7,6],[5,10,5,16],[0,27,0,30],[88,10,88,16],[87,10,87,19],[95,30,95,39],[101,10,101,19],[105,20,105,29],[108,10,108,19],[95,22,95,29],[95,20,95,21],[62,10,62,19],[66,20,66,29],[66,12,66,19],[56,22,56,29],[56,30,56,39],[69,10,69,19],[42,10,42,19],[46,20,46,29],[49,10,49,19],[46,12,46,19],[28,20,28,29],[31,10,31,19],[84,20,84,29],[80,10,80,19],[28,12,28,19],[0,4,0,12],[0,16,0,22],[60,0,60,9],[64,0,64,9],[67,0,67,9],[62,2,63,9],[69,2,70,9],[71,0,71,9],[40,0,40,9],[44,0,44,9],[47,0,47,9],[51,0,51,9],[29,0,29,9],[33,0,33,9],[42,2,43,9],[31,2,32,9],[66,10,66,11],[56,20,56,21],[46,10,46,11],[28,10,28,11],[18,20,18,21],[43,10,43,16],[50,10,50,16],[47,20,47,26],[22,0,22,9],[26,0,26,9],[24,2,25,9],[24,10,24,19],[9,20,9,26],[29,20,29,26],[25,10,25,16],[32,10,32,16],[23,0,23,6],[27,0,27,6],[30,0,30,6],[24,0,25,1],[31,0,32,1],[12,10,12,16],[10,0,10,6],[9,0,9,9],[11,10,11,19],[13,0,13,9],[34,0,34,6],[41,0,41,6],[48,0,48,6],[45,0,45,6],[52,0,52,6],[36,0,36,9],[37,0,37,9],[49,0,50,1],[62,0,63,1],[49,2,50,9],[42,0,43,1],[76,35,76,38],[84,10,84,11],[84,12,84,19],[0,35,0,38],[0,0,0,3],[0,14,0,15],[0,24,0,26],[0,32,0,34],[38,0,38,3],[38,4,38,12],[38,14,38,15],[38,16,38,22],[38,24,38,26],[38,27,38,30],[38,32,38,34],[38,35,38,38],[67,20,67,26],[63,10,63,16],[70,10,70,16],[61,0,61,6],[76,0,76,3],[76,4,76,12],[76,14,76,15],[76,16,76,22],[37,31,37,34],[74,0,74,9],[75,0,75,9],[75,31,75,34],[113,0,113,9],[114,0,114,9],[114,31,114,34],[76,24,76,26],[76,27,76,30],[76,32,76,34],[85,20,85,26],[102,10,102,16],[109,10,109,16],[106,20,106,26],[105,10,105,11],[105,12,105,19],[68,0,68,6],[65,0,65,6],[69,0,70,1],[72,0,72,6],[81,10,81,16]]}
["Tournament:",null,null,null,{"$f":"SETUP!D$3","v":"<tournament>"},null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"SETUP!A$3","v":"<date>"},null,null,null,null,null,null,null,"Division:",null,null,{"$f":"SETUP!F$3","v":"<div>"},null,null,null,null,"Bracket:",null,null,"GOLD"]
[]
[{"$f":"CALCS!AI3","v":" "}]
[{"$f":"CALCS!AH3","v":"1st place Pool A"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC3=0,\" \",CALCS!AC3)","v":" "},{"$f":"IF(CALCS!AD3=0,\" \",CALCS!AD3)","v":" "},{"$f":"IF(CALCS!AE3=0,\" \",CALCS!AE3)","v":" "}]
[{"$f":"CALCS!AF3","v":"M1"},null,{"$f":"CALCS!AG3","v":"2nd place Pool C refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI11","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH11","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC11=0,\" \",CALCS!AC11)","v":" "},{"$f":"IF(CALCS!AD11=0,\" \",CALCS!AD11)","v":" "},{"$f":"IF(CALCS!AE11=0,\" \",CALCS!AE11)","v":" "}]
[{"$f":"CALCS!AI4","v":" "}]
[{"$f":"CALCS!AH4","v":"2nd place Pool B"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC4=0,\" \",CALCS!AC4)","v":" "},{"$f":"IF(CALCS!AD4=0,\" \",CALCS!AD4)","v":" "},{"$f":"IF(CALCS!AE4=0,\" \",CALCS!AE4)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF11","v":"M9"},null,{"$f":"CALCS!AG11","v":"Loser M5 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI15","v":" "}]
[{"$f":"CALCS!AI5","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH15","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC15=0,\" \",CALCS!AC15)","v":" "},{"$f":"IF(CALCS!AD15=0,\" \",CALCS!AD15)","v":" "},{"$f":"IF(CALCS!AE15=0,\" \",CALCS!AE15)","v":" "}]
[{"$f":"CALCS!AH5","v":"1st place Pool D"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC5=0,\" \",CALCS!AC5)","v":" "},{"$f":"IF(CALCS!AD5=0,\" \",CALCS!AD5)","v":" "},{"$f":"IF(CALCS!AE5=0,\" \",CALCS!AE5)","v":" "}]
[{"$f":"CALCS!AF5","v":"M5"},null,{"$f":"CALCS!AG5","v":"Loser M1 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI12","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH12","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC12=0,\" \",CALCS!AC12)","v":" "},{"$f":"IF(CALCS!AD12=0,\" \",CALCS!AD12)","v":" "},{"$f":"IF(CALCS!AE12=0,\" \",CALCS!AE12)","v":" "}]
[{"$f":"CALCS!AI6","v":" "}]
[{"$f":"CALCS!AH6","v":"2nd place Pool C"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC6=0,\" \",CALCS!AC6)","v":" "},{"$f":"IF(CALCS!AD6=0,\" \",CALCS!AD6)","v":" "},{"$f":"IF(CALCS!AE6=0,\" \",CALCS!AE6)","v":" "}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF15","v":"M13"},null,{"$f":"CALCS!AG15","v":"Last Loser M9/M10 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI17","v":" "}]
[]
[]
[]
[{"$f":"CALCS!AI7","v":" "}]
[{"$f":"CALCS!AH7","v":"1st place Pool B"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC7=0,\" \",CALCS!AC7)","v":" "},{"$f":"IF(CALCS!AD7=0,\" \",CALCS!AD7)","v":" "},{"$f":"IF(CALCS!AE7=0,\" \",CALCS!AE7)","v":" "}]
[{"$f":"CALCS!AF7","v":"M2"},null,{"$f":"CALCS!AG7","v":"2nd place Pool D refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI13","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH13","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC13=0,\" \",CALCS!AC13)","v":" "},{"$f":"IF(CALCS!AD13=0,\" \",CALCS!AD13)","v":" "},{"$f":"IF(CALCS!AE13=0,\" \",CALCS!AE13)","v":" "}]
[{"$f":"CALCS!AI8","v":" "}]
[{"$f":"CALCS!AH8","v":"2nd place Pool A"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC8=0,\" \",CALCS!AC8)","v":" "},{"$f":"IF(CALCS!AD8=0,\" \",CALCS!AD8)","v":" "},{"$f":"IF(CALCS!AE8=0,\" \",CALCS!AE8)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF13","v":"M10"},null,{"$f":"CALCS!AG13","v":"Loser M6 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI16","v":" "}]
[{"$f":"CALCS!AI9","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH16","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC16=0,\" \",CALCS!AC16)","v":" "},{"$f":"IF(CALCS!AD16=0,\" \",CALCS!AD16)","v":" "},{"$f":"IF(CALCS!AE16=0,\" \",CALCS!AE16)","v":" "}]
[{"$f":"CALCS!AH9","v":"1st place Pool C"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC9=0,\" \",CALCS!AC9)","v":" "},{"$f":"IF(CALCS!AD9=0,\" \",CALCS!AD9)","v":" "},{"$f":"IF(CALCS!AE9=0,\" \",CALCS!AE9)","v":" "}]
[{"$f":"CALCS!AF9","v":"M6"},null,{"$f":"CALCS!AG9","v":"Loser M2 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI14","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH14","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC14=0,\" \",CALCS!AC14)","v":" "},{"$f":"IF(CALCS!AD14=0,\" \",CALCS!AD14)","v":" "},{"$f":"IF(CALCS!AE14=0,\" \",CALCS!AE14)","v":" "}]
[{"$f":"CALCS!AI10","v":" "}]
[{"$f":"CALCS!AH10","v":"2nd place Pool D"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC10=0,\" \",CALCS!AC10)","v":" "},{"$f":"IF(CALCS!AD10=0,\" \",CALCS!AD10)","v":" "},{"$f":"IF(CALCS!AE10=0,\" \",CALCS!AE10)","v":" "}]
[]
["Ohio Valley Region, Inc. (www.ovr.org)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Juniors' Tournament Packet"]
["USA Volleyball",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Playoff Brackets:",null,null,null,{"$f":"CALCS!AF$1","v":16},"Teams"]
["Tournament:",null,null,null,{"$f":"SETUP!D$3","v":"<tournament>"},null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"SETUP!A$3","v":"<date>"},null,null,null,null,null,null,null,"Division:",null,null,{"$f":"SETUP!F$3","v":"<div>"},null,null,null,null,"Bracket:",null,null,"SILVER"]
[]
[{"$f":"CALCS!AI18","v":" "}]
[{"$f":"CALCS!AH18","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC18=0,\" \",CALCS!AC18)","v":" "},{"$f":"IF(CALCS!AD18=0,\" \",CALCS!AD18)","v":" "},{"$f":"IF(CALCS!AE18=0,\" \",CALCS!AE18)","v":" "}]
[{"$f":"CALCS!AF18","v":" "},null,{"$f":"CALCS!AG18","v":" "},null,null,null,null,null,null,null,{"$f":"CALCS!AI26","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH26","v":"3rd place Pool A"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC26=0,\" \",CALCS!AC26)","v":" "},{"$f":"IF(CALCS!AD26=0,\" \",CALCS!AD26)","v":" "},{"$f":"IF(CALCS!AE26=0,\" \",CALCS!AE26)","v":" "}]
[{"$f":"CALCS!AI19","v":" "}]
[{"$f":"CALCS!AH19","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC19=0,\" \",CALCS!AC19)","v":" "},{"$f":"IF(CALCS!AD19=0,\" \",CALCS!AD19)","v":" "},{"$f":"IF(CALCS!AE19=0,\" \",CALCS!AE19)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF26","v":"M3"},null,{"$f":"CALCS!AG26","v":"3rd place Pool C refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI30","v":" "}]
[{"$f":"CALCS!AI20","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH30","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC30=0,\" \",CALCS!AC30)","v":" "},{"$f":"IF(CALCS!AD30=0,\" \",CALCS!AD30)","v":" "},{"$f":"IF(CALCS!AE30=0,\" \",CALCS!AE30)","v":" "}]
[{"$f":"CALCS!AH20","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC20=0,\" \",CALCS!AC20)","v":" "},{"$f":"IF(CALCS!AD20=0,\" \",CALCS!AD20)","v":" "},{"$f":"IF(CALCS!AE20=0,\" \",CALCS!AE20)","v":" "}]
[{"$f":"CALCS!AF20","v":" "},null,{"$f":"CALCS!AG20","v":" "},null,null,null,null,null,null,null,{"$f":"CALCS!AI27","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH27","v":"3rd place Pool D"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC27=0,\" \",CALCS!AC27)","v":" "},{"$f":"IF(CALCS!AD27=0,\" \",CALCS!AD27)","v":" "},{"$f":"IF(CALCS!AE27=0,\" \",CALCS!AE27)","v":" "}]
[{"$f":"CALCS!AI21","v":" "}]
[{"$f":"CALCS!AH21","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC21=0,\" \",CALCS!AC21)","v":" "},{"$f":"IF(CALCS!AD21=0,\" \",CALCS!AD21)","v":" "},{"$f":"IF(CALCS!AE21=0,\" \",CALCS!AE21)","v":" "}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF30","v":"M11"},null,{"$f":"CALCS!AG30","v":"Loser M7 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI32","v":" "}]
[]
[]
[]
[{"$f":"CALCS!AI22","v":" "}]
[{"$f":"CALCS!AH22","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC22=0,\" \",CALCS!AC22)","v":" "},{"$f":"IF(CALCS!AD22=0,\" \",CALCS!AD22)","v":" "},{"$f":"IF(CALCS!AE22=0,\" \",CALCS!AE22)","v":" "}]
[{"$f":"CALCS!AF22","v":" "},null,{"$f":"CALCS!AG22","v":" "},null,null,null,null,null,null,null,{"$f":"CALCS!AI28","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH28","v":"3rd place Pool B"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC28=0,\" \",CALCS!AC28)","v":" "},{"$f":"IF(CALCS!AD28=0,\" \",CALCS!AD28)","v":" "},{"$f":"IF(CALCS!AE28=0,\" \",CALCS!AE28)","v":" "}]
[{"$f":"CALCS!AI23","v":" "}]
[{"$f":"CALCS!AH23","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC23=0,\" \",CALCS!AC23)","v":" "},{"$f":"IF(CALCS!AD23=0,\" \",CALCS!AD23)","v":" "},{"$f":"IF(CALCS!AE23=0,\" \",CALCS!AE23)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF28","v":"M7"},null,{"$f":"CALCS!AG28","v":"Loser M3 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI31","v":" "}]
[{"$f":"CALCS!AI24","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH31","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC31=0,\" \",CALCS!AC31)","v":" "},{"$f":"IF(CALCS!AD31=0,\" \",CALCS!AD31)","v":" "},{"$f":"IF(CALCS!AE31=0,\" \",CALCS!AE31)","v":" "}]
[{"$f":"CALCS!AH24","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC24=0,\" \",CALCS!AC24)","v":" "},{"$f":"IF(CALCS!AD24=0,\" \",CALCS!AD24)","v":" "},{"$f":"IF(CALCS!AE24=0,\" \",CALCS!AE24)","v":" "}]
[{"$f":"CALCS!AF24","v":" "},null,{"$f":"CALCS!AG24","v":" "},null,null,null,null,null,null,null,{"$f":"CALCS!AI29","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH29","v":"3rd place Pool C"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC29=0,\" \",CALCS!AC29)","v":" "},{"$f":"IF(CALCS!AD29=0,\" \",CALCS!AD29)","v":" "},{"$f":"IF(CALCS!AE29=0,\" \",CALCS!AE29)","v":" "}]
[{"$f":"CALCS!AI25","v":" "}]
[{"$f":"CALCS!AH25","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC25=0,\" \",CALCS!AC25)","v":" "},{"$f":"IF(CALCS!AD25=0,\" \",CALCS!AD25)","v":" "},{"$f":"IF(CALCS!AE25=0,\" \",CALCS!AE25)","v":" "}]
[]
["Ohio Valley Region, Inc. (www.ovr.org)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Juniors' Tournament Packet"]
["USA Volleyball",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Playoff Brackets:",null,null,null,{"$f":"CALCS!AF$1","v":16},"Teams"]
["Tournament:",null,null,null,{"$f":"SETUP!D$3","v":"<tournament>"},null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"SETUP!A$3","v":"<date>"},null,null,null,null,null,null,null,"Division:",null,null,{"$f":"SETUP!F$3","v":"<div>"},null,null,null,null,"Bracket:",null,null,"BRONZE"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AI33","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH33","v":"4th place Pool A"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC33=0,\" \",CALCS!AC33)","v":" "},{"$f":"IF(CALCS!AD33=0,\" \",CALCS!AD33)","v":" "},{"$f":"IF(CALCS!AE33=0,\" \",CALCS!AE33)","v":" "}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF33","v":"M4"},null,{"$f":"CALCS!AG33","v":"4th place Pool B refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI37","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH37","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC37=0,\" \",CALCS!AC37)","v":" "},{"$f":"IF(CALCS!AD37=0,\" \",CALCS!AD37)","v":" "},{"$f":"IF(CALCS!AE37=0,\" \",CALCS!AE37)","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AI34","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH34","v":"4th place Pool D"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC34=0,\" \",CALCS!AC34)","v":" "},{"$f":"IF(CALCS!AD34=0,\" \",CALCS!AD34)","v":" "},{"$f":"IF(CALCS!AE34=0,\" \",CALCS!AE34)","v":" "}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF37","v":"M12"},null,{"$f":"CALCS!AG37","v":"Loser M8 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI39","v":" "}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AI35","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH35","v":"4th place Pool B"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC35=0,\" \",CALCS!AC35)","v":" "},{"$f":"IF(CALCS!AD35=0,\" \",CALCS!AD35)","v":" "},{"$f":"IF(CALCS!AE35=0,\" \",CALCS!AE35)","v":" "}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AF35","v":"M8"},null,{"$f":"CALCS!AG35","v":"Loser M4 refs"},null,null,null,null,null,null,null,{"$f":"CALCS!AI38","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH38","v":" "},null,null,null,null,null,null,{"$f":"IF(CALCS!AC38=0,\" \",CALCS!AC38)","v":" "},{"$f":"IF(CALCS!AD38=0,\" \",CALCS!AD38)","v":" "},{"$f":"IF(CALCS!AE38=0,\" \",CALCS!AE38)","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AI36","v":" "}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CALCS!AH36","v":"4th place Pool C"},null,null,null,null,null,null,{"$f":"IF(CALCS!AC36=0,\" \",CALCS!AC36)","v":" "},{"$f":"IF(CALCS!AD36=0,\" \",CALCS!AD36)","v":" "},{"$f":"IF(CALCS!AE36=0,\" \",CALCS!AE36)","v":" "}]
[]
[]
[]
["Ohio Valley Region, Inc. (www.ovr.org)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Juniors' Tournament Packet"]
["USA Volleyball",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Playoff Brackets:",null,null,null,{"$f":"CALCS!AF$1","v":16},"Teams"]

{"sheet":"CALCS","index":4,"n_rows":143,"n_cols":79,"rows_kept":143,"cut":false,"hidden":false,"merged":[[125,0,125,14],[119,1,119,2],[120,1,120,2],[121,1,121,2],[80,0,80,13],[0,39,0,42],[0,35,0,38],[0,75,0,78],[0,71,0,74],[0,51,0,54],[0,47,0,50],[0,43,0,46],[0,55,0,58],[0,59,0,62],[0,63,0,66],[0,67,0,70]]}
["POOL A CONTROL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS",null,null,null,null,{"$f":"SUM(SETUP!C13:C31)","v":16},"Team Format",null,null,"5-team",null,null,null,"7-team",null,null,null,"8-team",null,null,null,"10-team",null,null,null,"11-team",null,null,null,"12-team",null,null,null,"13-team",null,null,null,"14-team",null,null,null,"15-team",null,null,null,"16-team",null,null,null,"20-team"]
[null,"#1","#3","#2","#4","#1","#4","#2","#3","#3","#4","#1","#2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Position","A/B","Set1","Set2","Set3","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team","Match","Referee","tag","team"]
["Set 1",{"$f":"IF(SCORES!D5>SCORES!E5,1,0)","v":0},{"$f":"IF(SCORES!E5>SCORES!D5,1,0)","v":0},{"$f":"IF(SCORES!F5>SCORES!G5,1,0)","v":0},{"$f":"IF(SCORES!G5>SCORES!F5,1,0)","v":0},{"$f":"IF(SCORES!H5>SCORES!I5,1,0)","v":0},{"$f":"IF(SCORES!I5>SCORES!H5,1,0)","v":0},{"$f":"IF(SCORES!J5>SCORES!K5,1,0)","v":0},{"$f":"IF(SCORES!K5>SCORES!J5,1,0)","v":0},{"$f":"IF(SCORES!L5>SCORES!M5,1,0)","v":0},{"$f":"IF(SCORES!M5>SCORES!L5,1,0)","v":0},{"$f":"IF(SCORES!N5>SCORES!O5,1,0)","v":0},{"$f":"IF(SCORES!O5>SCORES!N5,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,1,"A",{"$f":"SCORES!H36","v":0},{"$f":"SCORES!I36","v":0},{"$f":"SCORES!J36","v":0},{"$f":"IF($AF$1=8,IF(AR3=0,\" \",AR3),IF($AF$1=10,IF(AV3=0,\" \",AV3),IF($AF$1=11,IF(AZ3=0,\" \",AZ3),IF($AF$1=12,IF(BD3=0,\" \",BD3),IF($AF$1=13,IF(BH3=0,\" \",BH3),IF($AF$1=14,IF(BL3=0,\" \",BL3),IF($AF$1=15,IF(BP3=0,\" \",BP3),IF($AF$1=16,IF(BT3=0,\" \",BT3),0))))))))","v":"M1"},{"$f":"IF($AF$1=8,IF(AS3=0,\" \",AS3),IF($AF$1=10,IF(AW3=0,\" \",AW3),IF($AF$1=11,IF(BA3=0,\" \",BA3),IF($AF$1=12,IF(BE3=0,\" \",BE3),IF($AF$1=13,IF(BI3=0,\" \",BI3),IF($AF$1=14,IF(BM3=0,\" \",BM3),IF($AF$1=15,IF(BQ3=0,\" \",BQ3),IF($AF$1=16,IF(BU3=0,\" \",BU3),0))))))))","v":"2nd place Pool C refs"},{"$f":"IF($AF$1=8,IF(AT3=0,\" \",AT3),IF($AF$1=10,IF(AX3=0,\" \",AX3),IF($AF$1=11,IF(BB3=0,\" \",BB3),IF($AF$1=12,IF(BF3=0,\" \",BF3),IF($AF$1=13,IF(BJ3=0,\" \",BJ3),IF($AF$1=14,IF(BN3=0,\" \",BN3),IF($AF$1=15,IF(BR3=0,\" \",BR3),IF($AF$1=16,IF(BV3=0,\" \",BV3),0))))))))","v":"1st place Pool A"},{"$f":"IF($AF$1=8,IF(AU3=0,\" \",AU3),IF($AF$1=10,IF(AY3=0,\" \",AY3),IF($AF$1=11,IF(BC3=0,\" \",BC3),IF($AF$1=12,IF(BG3=0,\" \",BG3),IF($AF$1=13,IF(BK3=0,\" \",BK3),IF($AF$1=14,IF(BO3=0,\" \",BO3),IF($AF$1=15,IF(BS3=0,\" \",BS3),IF($AF$1=16,IF(BW3=0,\" \",BW3),0))))))))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"M1","1st place Pool A refs","2nd place Pool C",{"$f":"IF(STANDINGS!$J$26=2,STANDINGS!$B$26,IF(STANDINGS!$J$27=2,STANDINGS!$B$27,IF(STANDINGS!$J$28=2,STANDINGS!$B$28,IF(STANDINGS!$J$29=2,STANDINGS!$B$29,\" \"))))","v":" "},"M1","2nd place Pool B refs","1st place Pool A",{"$f":"IF(STANDINGS!$J$4=1,STANDINGS!$B$4,IF(STANDINGS!$J$5=1,STANDINGS!$B$5,IF(STANDINGS!$J$6=1,STANDINGS!$B$6,IF(STANDINGS!$J$7=1,STANDINGS!$B$7,\" \"))))","v":" "},"M1","2nd place Pool B refs","1st place Pool A",{"$f":"IF(STANDINGS!$J$4=1,STANDINGS!$B$4,IF(STANDINGS!$J$5=1,STANDINGS!$B$5,IF(STANDINGS!$J$6=1,STANDINGS!$B$6,IF(STANDINGS!$J$7=1,STANDINGS!$B$7,\" \"))))","v":" "},"M1","3rd place Pool D refs","1st place Pool A",{"$f":"IF(STANDINGS!$J$4=1,STANDINGS!$B$4,IF(STANDINGS!$J$5=1,STANDINGS!$B$5,IF(STANDINGS!$J$6=1,STANDINGS!$B$6,IF(STANDINGS!$J$7=1,STANDINGS!$B$7,\" \"))))","v":" "},"M1","2nd place Pool C refs","1st place Pool A",{"$f":"IF(STANDINGS!$J$4=1,STANDINGS!$B$4,IF(STANDINGS!$J$5=1,STANDINGS!$B$5,IF(STANDINGS!$J$6=1,STANDINGS!$B$6,IF(STANDINGS!$J$7=1,STANDINGS!$B$7,\" \"))))","v":" "},"M1","2nd place Pool C refs","1st place Pool A",{"$f":"IF(STANDINGS!$J$4=1,STANDINGS!$B$4,IF(STANDINGS!$J$5=1,STANDINGS!$B$5,IF(STANDINGS!$J$6=1,STANDINGS!$B$6,IF(STANDINGS!$J$7=1,STANDINGS!$B$7,\" \"))))","v":" "},"M1","2nd place Pool C refs","1st place Pool A",{"$f":"IF(STANDINGS!$J$4=1,STANDINGS!$B$4,IF(STANDINGS!$J$5=1,STANDINGS!$B$5,IF(STANDINGS!$J$6=1,STANDINGS!$B$6,IF(STANDINGS!$J$7=1,STANDINGS!$B$7,\" \"))))","v":" "}]
["Set 2",{"$f":"IF(SCORES!D6>SCORES!E6,1,0)","v":0},{"$f":"IF(SCORES!E6>SCORES!D6,1,0)","v":0},{"$f":"IF(SCORES!F6>SCORES!G6,1,0)","v":0},{"$f":"IF(SCORES!G6>SCORES!F6,1,0)","v":0},{"$f":"IF(SCORES!H6>SCORES!I6,1,0)","v":0},{"$f":"IF(SCORES!I6>SCORES!H6,1,0)","v":0},{"$f":"IF(SCORES!J6>SCORES!K6,1,0)","v":0},{"$f":"IF(SCORES!K6>SCORES!J6,1,0)","v":0},{"$f":"IF(SCORES!L6>SCORES!M6,1,0)","v":0},{"$f":"IF(SCORES!M6>SCORES!L6,1,0)","v":0},{"$f":"IF(SCORES!N6>SCORES!O6,1,0)","v":0},{"$f":"IF(SCORES!O6>SCORES!N6,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA3+1","v":2},"B",{"$f":"SCORES!H37","v":0},{"$f":"SCORES!I37","v":0},{"$f":"SCORES!J37","v":0}," "," ","2nd place Pool B"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd place Pool B",{"$f":"IF(STANDINGS!$J$15=2,STANDINGS!$B$15,IF(STANDINGS!$J$16=2,STANDINGS!$B$16,IF(STANDINGS!$J$17=2,STANDINGS!$B$17,IF(STANDINGS!$J$18=2,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"2nd-Best 3rd Place Record",{"$f":"IF(CALCS!P$120=2,CALCS!B$120,(IF(CALCS!P$121=2,CALCS!B$121,(IF(CALCS!P$122=2,CALCS!B$122,0)))))","v":0},null,null,"2nd-Best 3rd Place Record",{"$f":"IF(CALCS!P$120=2,CALCS!B$120,(IF(CALCS!P$121=2,CALCS!B$121,(IF(CALCS!P$122=2,CALCS!B$122,0)))))","v":0},null,null,"2nd place Pool B",{"$f":"IF(STANDINGS!$J$15=2,STANDINGS!$B$15,IF(STANDINGS!$J$16=2,STANDINGS!$B$16,IF(STANDINGS!$J$17=2,STANDINGS!$B$17,IF(STANDINGS!$J$18=2,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"2nd place Pool B",{"$f":"IF(STANDINGS!$J$15=2,STANDINGS!$B$15,IF(STANDINGS!$J$16=2,STANDINGS!$B$16,IF(STANDINGS!$J$17=2,STANDINGS!$B$17,IF(STANDINGS!$J$18=2,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"2nd place Pool B",{"$f":"IF(STANDINGS!$J$15=2,STANDINGS!$B$15,IF(STANDINGS!$J$16=2,STANDINGS!$B$16,IF(STANDINGS!$J$17=2,STANDINGS!$B$17,IF(STANDINGS!$J$18=2,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"2nd place Pool B",{"$f":"IF(STANDINGS!$J$15=2,STANDINGS!$B$15,IF(STANDINGS!$J$16=2,STANDINGS!$B$16,IF(STANDINGS!$J$17=2,STANDINGS!$B$17,IF(STANDINGS!$J$18=2,STANDINGS!$B$18,\" \"))))","v":" "}]
["Set 3",{"$f":"IF(SCORES!D7>SCORES!E7,1,0)","v":0},{"$f":"IF(SCORES!E7>SCORES!D7,1,0)","v":0},{"$f":"IF(SCORES!F7>SCORES!G7,1,0)","v":0},{"$f":"IF(SCORES!G7>SCORES!F7,1,0)","v":0},{"$f":"IF(SCORES!H7>SCORES!I7,1,0)","v":0},{"$f":"IF(SCORES!I7>SCORES!H7,1,0)","v":0},{"$f":"IF(SCORES!J7>SCORES!K7,1,0)","v":0},{"$f":"IF(SCORES!K7>SCORES!J7,1,0)","v":0},{"$f":"IF(SCORES!L7>SCORES!M7,1,0)","v":0},{"$f":"IF(SCORES!M7>SCORES!L7,1,0)","v":0},{"$f":"IF(SCORES!N7>SCORES!O7,1,0)","v":0},{"$f":"IF(SCORES!O7>SCORES!N7,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,3,"A",{"$f":"SCORES!H38","v":0},{"$f":"SCORES!I38","v":0},{"$f":"SCORES!J38","v":0},"M5","Loser M1 refs","1st place Pool D"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M4","Loser M1 refs","2nd place Pool C",{"$f":"IF(STANDINGS!$J$26=2,STANDINGS!$B$26,IF(STANDINGS!$J$27=2,STANDINGS!$B$27,IF(STANDINGS!$J$28=2,STANDINGS!$B$28,IF(STANDINGS!$J$29=2,STANDINGS!$B$29,\" \"))))","v":" "},"M4","Loser M1 refs","2nd place Pool C",{"$f":"IF(STANDINGS!$J$26=2,STANDINGS!$B$26,IF(STANDINGS!$J$27=2,STANDINGS!$B$27,IF(STANDINGS!$J$28=2,STANDINGS!$B$28,IF(STANDINGS!$J$29=2,STANDINGS!$B$29,\" \"))))","v":" "},"M2","4th place Pool A refs","1st place Pool D",{"$f":"IF(STANDINGS!$J$37=1,STANDINGS!$B$37,IF(STANDINGS!$J$38=1,STANDINGS!$B$38,IF(STANDINGS!$J$39=1,STANDINGS!$B$39,IF(STANDINGS!$J$40=1,STANDINGS!$B$40,\" \"))))","v":" "},"M5","Loser M1 refs","1st place Pool D",{"$f":"IF(STANDINGS!$J$37=1,STANDINGS!$B$37,IF(STANDINGS!$J$38=1,STANDINGS!$B$38,IF(STANDINGS!$J$39=1,STANDINGS!$B$39,IF(STANDINGS!$J$40=1,STANDINGS!$B$40,\" \"))))","v":" "},"M5","Loser M1 refs","1st place Pool D",{"$f":"IF(STANDINGS!$J$37=1,STANDINGS!$B$37,IF(STANDINGS!$J$38=1,STANDINGS!$B$38,IF(STANDINGS!$J$39=1,STANDINGS!$B$39,IF(STANDINGS!$J$40=1,STANDINGS!$B$40,\" \"))))","v":" "},"M5","Loser M1 refs","1st place Pool D",{"$f":"IF(STANDINGS!$J$37=1,STANDINGS!$B$37,IF(STANDINGS!$J$38=1,STANDINGS!$B$38,IF(STANDINGS!$J$39=1,STANDINGS!$B$39,IF(STANDINGS!$J$40=1,STANDINGS!$B$40,\" \"))))","v":" "}]
["Set 4",{"$f":"IF(SCORES!D8>SCORES!E8,1,0)","v":0},{"$f":"IF(SCORES!E8>SCORES!D8,1,0)","v":0},{"$f":"IF(SCORES!F8>SCORES!G8,1,0)","v":0},{"$f":"IF(SCORES!G8>SCORES!F8,1,0)","v":0},{"$f":"IF(SCORES!H8>SCORES!I8,1,0)","v":0},{"$f":"IF(SCORES!I8>SCORES!H8,1,0)","v":0},{"$f":"IF(SCORES!J8>SCORES!K8,1,0)","v":0},{"$f":"IF(SCORES!K8>SCORES!J8,1,0)","v":0},{"$f":"IF(SCORES!L8>SCORES!M8,1,0)","v":0},{"$f":"IF(SCORES!M8>SCORES!L8,1,0)","v":0},{"$f":"IF(SCORES!N8>SCORES!O8,1,0)","v":0},{"$f":"IF(SCORES!O8>SCORES!N8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,4,"B",{"$f":"SCORES!H39","v":0},{"$f":"SCORES!I39","v":0},{"$f":"SCORES!J39","v":0}," "," ","2nd place Pool C"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd place Pool B",{"$f":"IF(STANDINGS!$J$15=2,STANDINGS!$B$15,IF(STANDINGS!$J$16=2,STANDINGS!$B$16,IF(STANDINGS!$J$17=2,STANDINGS!$B$17,IF(STANDINGS!$J$18=2,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"2nd place Pool B",{"$f":"IF(STANDINGS!$J$15=2,STANDINGS!$B$15,IF(STANDINGS!$J$16=2,STANDINGS!$B$16,IF(STANDINGS!$J$17=2,STANDINGS!$B$17,IF(STANDINGS!$J$18=2,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"2nd place Pool C",{"$f":"IF(STANDINGS!$J$26=2,STANDINGS!$B$26,IF(STANDINGS!$J$27=2,STANDINGS!$B$27,IF(STANDINGS!$J$28=2,STANDINGS!$B$28,IF(STANDINGS!$J$29=2,STANDINGS!$B$29,\" \"))))","v":" "},null,null,"2nd place Pool C",{"$f":"IF(STANDINGS!$J$26=2,STANDINGS!$B$26,IF(STANDINGS!$J$27=2,STANDINGS!$B$27,IF(STANDINGS!$J$28=2,STANDINGS!$B$28,IF(STANDINGS!$J$29=2,STANDINGS!$B$29,\" \"))))","v":" "},null,null,"2nd place Pool C",{"$f":"IF(STANDINGS!$J$26=2,STANDINGS!$B$26,IF(STANDINGS!$J$27=2,STANDINGS!$B$27,IF(STANDINGS!$J$28=2,STANDINGS!$B$28,IF(STANDINGS!$J$29=2,STANDINGS!$B$29,\" \"))))","v":" "},null,null,"2nd place Pool C",{"$f":"IF(STANDINGS!$J$26=2,STANDINGS!$B$26,IF(STANDINGS!$J$27=2,STANDINGS!$B$27,IF(STANDINGS!$J$28=2,STANDINGS!$B$28,IF(STANDINGS!$J$29=2,STANDINGS!$B$29,\" \"))))","v":" "}]
["Set 5",{"$f":"IF(SCORES!D9>SCORES!E9,1,0)","v":0},{"$f":"IF(SCORES!E9>SCORES!D9,1,0)","v":0},{"$f":"IF(SCORES!F9>SCORES!G9,1,0)","v":0},{"$f":"IF(SCORES!G9>SCORES!F9,1,0)","v":0},{"$f":"IF(SCORES!H9>SCORES!I9,1,0)","v":0},{"$f":"IF(SCORES!I9>SCORES!H9,1,0)","v":0},{"$f":"IF(SCORES!J9>SCORES!K9,1,0)","v":0},{"$f":"IF(SCORES!K9>SCORES!J9,1,0)","v":0},{"$f":"IF(SCORES!L9>SCORES!M9,1,0)","v":0},{"$f":"IF(SCORES!M9>SCORES!L9,1,0)","v":0},{"$f":"IF(SCORES!N9>SCORES!O9,1,0)","v":0},{"$f":"IF(SCORES!O9>SCORES!N9,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,5,"A",{"$f":"SCORES!H40","v":0},{"$f":"SCORES!I40","v":0},{"$f":"SCORES!J40","v":0},"M2","2nd place Pool D refs","1st place Pool B"," ",null,null,null,null,null,null,null,null,null,null,null,null,"M2","1st place Pool B refs","2nd place Pool A",{"$f":"IF(STANDINGS!$J$4=2,STANDINGS!$B$4,IF(STANDINGS!$J$5=2,STANDINGS!$B$5,IF(STANDINGS!$J$6=2,STANDINGS!$B$6,IF(STANDINGS!$J$7=2,STANDINGS!$B$7,\" \"))))","v":" "},"M2","2nd place Pool A refs","1st place Pool B",{"$f":"IF(STANDINGS!$J$15=1,STANDINGS!$B$15,IF(STANDINGS!$J$16=1,STANDINGS!$B$16,IF(STANDINGS!$J$17=1,STANDINGS!$B$17,IF(STANDINGS!$J$18=1,STANDINGS!$B$18,\" \"))))","v":" "},"M2","2nd place Pool A refs","1st place Pool B",{"$f":"IF(STANDINGS!$J$15=1,STANDINGS!$B$15,IF(STANDINGS!$J$16=1,STANDINGS!$B$16,IF(STANDINGS!$J$17=1,STANDINGS!$B$17,IF(STANDINGS!$J$18=1,STANDINGS!$B$18,\" \"))))","v":" "},"M3","3rd place Pool B refs","1st place Pool B",{"$f":"IF(STANDINGS!$J$15=1,STANDINGS!$B$15,IF(STANDINGS!$J$16=1,STANDINGS!$B$16,IF(STANDINGS!$J$17=1,STANDINGS!$B$17,IF(STANDINGS!$J$18=1,STANDINGS!$B$18,\" \"))))","v":" "},"M2","2nd place Pool D refs","1st place Pool B",{"$f":"IF(STANDINGS!$J$15=1,STANDINGS!$B$15,IF(STANDINGS!$J$16=1,STANDINGS!$B$16,IF(STANDINGS!$J$17=1,STANDINGS!$B$17,IF(STANDINGS!$J$18=1,STANDINGS!$B$18,\" \"))))","v":" "},"M2","2nd place Pool D refs","1st place Pool B",{"$f":"IF(STANDINGS!$J$15=1,STANDINGS!$B$15,IF(STANDINGS!$J$16=1,STANDINGS!$B$16,IF(STANDINGS!$J$17=1,STANDINGS!$B$17,IF(STANDINGS!$J$18=1,STANDINGS!$B$18,\" \"))))","v":" "},"M2","2nd place Pool D refs","1st place Pool B",{"$f":"IF(STANDINGS!$J$15=1,STANDINGS!$B$15,IF(STANDINGS!$J$16=1,STANDINGS!$B$16,IF(STANDINGS!$J$17=1,STANDINGS!$B$17,IF(STANDINGS!$J$18=1,STANDINGS!$B$18,\" \"))))","v":" "}]
["Set Total",{"$f":"SUM(B3:B7)","v":0},0,0,0,0,0,{"$f":"SUM(H3:H7)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"B",{"$f":"SCORES!H41","v":0},{"$f":"SCORES!I41","v":0},{"$f":"SCORES!J41","v":0}," "," ","2nd place Pool A"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1st place Pool C",{"$f":"IF(STANDINGS!$J$26=1,STANDINGS!$B$26,IF(STANDINGS!$J$27=1,STANDINGS!$B$27,IF(STANDINGS!$J$28=1,STANDINGS!$B$28,IF(STANDINGS!$J$29=1,STANDINGS!$B$29,\" \"))))","v":" "},null,null,"Best 3rd Place Record",{"$f":"IF(CALCS!P$120=1,CALCS!B$120,(IF(CALCS!P$121=1,CALCS!B$121,(IF(CALCS!P$122=1,CALCS!B$122,0)))))","v":0},null,null,"Best 3rd Place Record",{"$f":"IF(CALCS!P$120=1,CALCS!B$120,(IF(CALCS!P$121=1,CALCS!B$121,(IF(CALCS!P$122=1,CALCS!B$122,0)))))","v":0},null,null,"2nd place Pool A",{"$f":"IF(STANDINGS!$J$4=2,STANDINGS!$B$4,IF(STANDINGS!$J$5=2,STANDINGS!$B$5,IF(STANDINGS!$J$6=2,STANDINGS!$B$6,IF(STANDINGS!$J$7=2,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"2nd place Pool A",{"$f":"IF(STANDINGS!$J$4=2,STANDINGS!$B$4,IF(STANDINGS!$J$5=2,STANDINGS!$B$5,IF(STANDINGS!$J$6=2,STANDINGS!$B$6,IF(STANDINGS!$J$7=2,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"2nd place Pool A",{"$f":"IF(STANDINGS!$J$4=2,STANDINGS!$B$4,IF(STANDINGS!$J$5=2,STANDINGS!$B$5,IF(STANDINGS!$J$6=2,STANDINGS!$B$6,IF(STANDINGS!$J$7=2,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"2nd place Pool A",{"$f":"IF(STANDINGS!$J$4=2,STANDINGS!$B$4,IF(STANDINGS!$J$5=2,STANDINGS!$B$5,IF(STANDINGS!$J$6=2,STANDINGS!$B$6,IF(STANDINGS!$J$7=2,STANDINGS!$B$7,\" \"))))","v":" "}]
["Score Total",{"$f":"SUM(SCORES!D5:D9)","v":0},{"$f":"SUM(SCORES!E5:E9)","v":0},{"$f":"SUM(SCORES!F5:F9)","v":0},{"$f":"SUM(SCORES!G5:G9)","v":0},{"$f":"SUM(SCORES!H5:H9)","v":0},{"$f":"SUM(SCORES!I5:I9)","v":0},{"$f":"SUM(SCORES!J5:J9)","v":0},{"$f":"SUM(SCORES!K5:K9)","v":0},{"$f":"SUM(SCORES!L5:L9)","v":0},{"$f":"SUM(SCORES!M5:M9)","v":0},{"$f":"SUM(SCORES!N5:N9)","v":0},{"$f":"SUM(SCORES!O5:O9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,7,"A",{"$f":"SCORES!H42","v":0},{"$f":"SCORES!I42","v":0},{"$f":"SCORES!J42","v":0},"M6","Loser M2 refs","1st place Pool C"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5","Loser M2 refs","1st place Pool C",{"$f":"IF(STANDINGS!$J$26=1,STANDINGS!$B$26,IF(STANDINGS!$J$27=1,STANDINGS!$B$27,IF(STANDINGS!$J$28=1,STANDINGS!$B$28,IF(STANDINGS!$J$29=1,STANDINGS!$B$29,\" \"))))","v":" "},"M5","Loser M2 refs","1st place Pool C",{"$f":"IF(STANDINGS!$J$26=1,STANDINGS!$B$26,IF(STANDINGS!$J$27=1,STANDINGS!$B$27,IF(STANDINGS!$J$28=1,STANDINGS!$B$28,IF(STANDINGS!$J$29=1,STANDINGS!$B$29,\" \"))))","v":" "},"M4","3rd place Pool C refs","1st place Pool C",{"$f":"IF(STANDINGS!$J$26=1,STANDINGS!$B$26,IF(STANDINGS!$J$27=1,STANDINGS!$B$27,IF(STANDINGS!$J$28=1,STANDINGS!$B$28,IF(STANDINGS!$J$29=1,STANDINGS!$B$29,\" \"))))","v":" "},"M6","Loser M2 refs","1st place Pool C",{"$f":"IF(STANDINGS!$J$26=1,STANDINGS!$B$26,IF(STANDINGS!$J$27=1,STANDINGS!$B$27,IF(STANDINGS!$J$28=1,STANDINGS!$B$28,IF(STANDINGS!$J$29=1,STANDINGS!$B$29,\" \"))))","v":" "},"M6","Loser M2 refs","1st place Pool C",{"$f":"IF(STANDINGS!$J$26=1,STANDINGS!$B$26,IF(STANDINGS!$J$27=1,STANDINGS!$B$27,IF(STANDINGS!$J$28=1,STANDINGS!$B$28,IF(STANDINGS!$J$29=1,STANDINGS!$B$29,\" \"))))","v":" "},"M6","Loser M2 refs","1st place Pool C",{"$f":"IF(STANDINGS!$J$26=1,STANDINGS!$B$26,IF(STANDINGS!$J$27=1,STANDINGS!$B$27,IF(STANDINGS!$J$28=1,STANDINGS!$B$28,IF(STANDINGS!$J$29=1,STANDINGS!$B$29,\" \"))))","v":" "}]
["Match",{"$f":"IF((B8>0)*AND(B8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((C8>0)*AND(C8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((D8>0)*AND(D8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((E8>0)*AND(E8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((F8>0)*AND(F8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((G8>0)*AND(G8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((H8>0)*AND(H8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((I8>0)*AND(I8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((J8>0)*AND(J8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((K8>0)*AND(K8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((L8>0)*AND(L8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},{"$f":"IF((M8>0)*AND(M8=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,2,FALSE)),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,8,"B",{"$f":"SCORES!H43","v":0},{"$f":"SCORES!I43","v":0},{"$f":"SCORES!J43","v":0}," "," ","2nd place Pool D"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd place Pool A",{"$f":"IF(STANDINGS!$J$4=2,STANDINGS!$B$4,IF(STANDINGS!$J$5=2,STANDINGS!$B$5,IF(STANDINGS!$J$6=2,STANDINGS!$B$6,IF(STANDINGS!$J$7=2,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"2nd place Pool A",{"$f":"IF(STANDINGS!$J$4=2,STANDINGS!$B$4,IF(STANDINGS!$J$5=2,STANDINGS!$B$5,IF(STANDINGS!$J$6=2,STANDINGS!$B$6,IF(STANDINGS!$J$7=2,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"2nd place Pool D",{"$f":"IF(STANDINGS!$J$37=2,STANDINGS!$B$37,IF(STANDINGS!$J$38=2,STANDINGS!$B$38,IF(STANDINGS!$J$39=2,STANDINGS!$B$39,IF(STANDINGS!$J$40=2,STANDINGS!$B$40,\" \"))))","v":" "},null,null,"2nd place Pool D",{"$f":"IF(STANDINGS!$J$37=2,STANDINGS!$B$37,IF(STANDINGS!$J$38=2,STANDINGS!$B$38,IF(STANDINGS!$J$39=2,STANDINGS!$B$39,IF(STANDINGS!$J$40=2,STANDINGS!$B$40,\" \"))))","v":" "},null,null,"2nd place Pool D",{"$f":"IF(STANDINGS!$J$37=2,STANDINGS!$B$37,IF(STANDINGS!$J$38=2,STANDINGS!$B$38,IF(STANDINGS!$J$39=2,STANDINGS!$B$39,IF(STANDINGS!$J$40=2,STANDINGS!$B$40,\" \"))))","v":" "},null,null,"2nd place Pool D",{"$f":"IF(STANDINGS!$J$37=2,STANDINGS!$B$37,IF(STANDINGS!$J$38=2,STANDINGS!$B$38,IF(STANDINGS!$J$39=2,STANDINGS!$B$39,IF(STANDINGS!$J$40=2,STANDINGS!$B$40,\" \"))))","v":" "}]
["POOL B CONTROL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"A",{"$f":"SCORES!H44","v":0},{"$f":"SCORES!I44","v":0},{"$f":"SCORES!J44","v":0},"M9","Loser M5 refs"," "," ",null,null,null,null,null,null,null,null,"M1","2nd place Pool A refs","1st place Pool A",{"$f":"IF(STANDINGS!$J$4=1,STANDINGS!$B$4,IF(STANDINGS!$J$5=1,STANDINGS!$B$5,IF(STANDINGS!$J$6=1,STANDINGS!$B$6,IF(STANDINGS!$J$7=1,STANDINGS!$B$7,\" \"))))","v":" "},"M4","Loser M1 refs",null,{"$f":"IF(($AC3>$AC4)*AND($AD3>$AD4), AY3, IF(($AC3<$AC4)*AND($AD3<$AD4), AY4, IF($AE3>$AE4, AY3, IF($AE3<$AE4, AY4, 0))))","v":0},"M7","Loser M4 refs",null,{"$f":"IF(($AC3>$AC4)*AND($AD3>$AD4), BC3, IF(($AC3<$AC4)*AND($AD3<$AD4), BC4, IF($AE3>$AE4, BC3, IF($AE3<$AE4, BC4, 0))))","v":0},"M7","Loser M4 refs",null,{"$f":"IF(($AC3>$AC4)*AND($AD3>$AD4), BG3, IF(($AC3<$AC4)*AND($AD3<$AD4), BG4, IF($AE3>$AE4, BG3, IF($AE3<$AE4, BG4, 0))))","v":0},"M6","Last Loser M1/M2 refs",null,{"$f":"IF(($AC3>$AC4)*AND($AD3>$AD4), BK3, IF(($AC3<$AC4)*AND($AD3<$AD4), BK4, IF($AE3>$AE4, BK3, IF($AE3<$AE4, BK4, 0))))","v":0},"M9","Loser M5 refs",null,{"$f":"IF(($AC3>$AC4)*AND($AD3>$AD4), BO3, IF(($AC3<$AC4)*AND($AD3<$AD4), BO4, IF($AE3>$AE4, BO3, IF($AE3<$AE4, BO4, 0))))","v":0},"M9","Loser M5 refs",null,{"$f":"IF(($AC3>$AC4)*AND($AD3>$AD4), BS3, IF(($AC3<$AC4)*AND($AD3<$AD4), BS4, IF($AE3>$AE4, BS3, IF($AE3<$AE4, BS4, 0))))","v":0},"M9","Loser M5 refs",null,{"$f":"IF(($AC3>$AC4)*AND($AD3>$AD4), BW3, IF(($AC3<$AC4)*AND($AD3<$AD4), BW4, IF($AE3>$AE4, BW3, IF($AE3<$AE4, BW4, 0))))","v":0}]
[null,"#1","#3","#2","#4","#1","#4","#2","#3","#3","#4","#1","#2",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"B",{"$f":"SCORES!H45","v":0},{"$f":"SCORES!I45","v":0},{"$f":"SCORES!J45","v":0}," "," "," "," ",null,null,null,null,null,null,null,null,null,null,"2nd place Pool B",{"$f":"IF(STANDINGS!$J$15=2,STANDINGS!$B$15,IF(STANDINGS!$J$16=2,STANDINGS!$B$16,IF(STANDINGS!$J$17=2,STANDINGS!$B$17,IF(STANDINGS!$J$18=2,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"1st place Pool A",{"$f":"IF(STANDINGS!$J$4=1,STANDINGS!$B$4,IF(STANDINGS!$J$5=1,STANDINGS!$B$5,IF(STANDINGS!$J$6=1,STANDINGS!$B$6,IF(STANDINGS!$J$7=1,STANDINGS!$B$7,\" \"))))","v":" "},null,null,null,{"$f":"IF(($AC5>$AC6)*AND($AD5>$AD6), BC5, IF(($AC5<$AC6)*AND($AD5<$AD6), BC6, IF($AE5>$AE6, BC5, IF($AE5<$AE6, BC6, 0))))","v":0},null,null,null,{"$f":"IF(($AC5>$AC6)*AND($AD5>$AD6), BG5, IF(($AC5<$AC6)*AND($AD5<$AD6), BG6, IF($AE5>$AE6, BG5, IF($AE5<$AE6, BG6, 0))))","v":0},null,null,null,{"$f":"IF(($AC5>$AC6)*AND($AD5>$AD6), BK5, IF(($AC5<$AC6)*AND($AD5<$AD6), BK6, IF($AE5>$AE6, BK5, IF($AE5<$AE6, BK6, 0))))","v":0},null,null,null,{"$f":"IF(($AC5>$AC6)*AND($AD5>$AD6), BO5, IF(($AC5<$AC6)*AND($AD5<$AD6), BO6, IF($AE5>$AE6, BO5, IF($AE5<$AE6, BO6, 0))))","v":0},null,null,null,{"$f":"IF(($AC5>$AC6)*AND($AD5>$AD6), BS5, IF(($AC5<$AC6)*AND($AD5<$AD6), BS6, IF($AE5>$AE6, BS5, IF($AE5<$AE6, BS6, 0))))","v":0},null,null,null,{"$f":"IF(($AC5>$AC6)*AND($AD5>$AD6), BW5, IF(($AC5<$AC6)*AND($AD5<$AD6), BW6, IF($AE5>$AE6, BW5, IF($AE5<$AE6, BW6, 0))))","v":0}]
["Set 1",{"$f":"IF(SCORES!D12>SCORES!E12,1,0)","v":0},{"$f":"IF(SCORES!E12>SCORES!D12,1,0)","v":0},{"$f":"IF(SCORES!F12>SCORES!G12,1,0)","v":0},{"$f":"IF(SCORES!G12>SCORES!F12,1,0)","v":0},{"$f":"IF(SCORES!H12>SCORES!I12,1,0)","v":0},{"$f":"IF(SCORES!I12>SCORES!H12,1,0)","v":0},{"$f":"IF(SCORES!J12>SCORES!K12,1,0)","v":0},{"$f":"IF(SCORES!K12>SCORES!J12,1,0)","v":0},{"$f":"IF(SCORES!L12>SCORES!M12,1,0)","v":0},{"$f":"IF(SCORES!M12>SCORES!L12,1,0)","v":0},{"$f":"IF(SCORES!N12>SCORES!O12,1,0)","v":0},{"$f":"IF(SCORES!O12>SCORES!N12,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,11,"A",{"$f":"SCORES!H46","v":0},{"$f":"SCORES!I46","v":0},{"$f":"SCORES!J46","v":0},"M10","Loser M6 refs"," "," ",null,null,null,null,null,null,null,null,"M3","Loser M1 refs","1st place Pool B",{"$f":"IF(STANDINGS!$J$15=1,STANDINGS!$B$15,IF(STANDINGS!$J$16=1,STANDINGS!$B$16,IF(STANDINGS!$J$17=1,STANDINGS!$B$17,IF(STANDINGS!$J$18=1,STANDINGS!$B$18,\" \"))))","v":" "},"M5","Loser M2 refs",null,{"$f":"IF(($AC7>$AC8)*AND($AD7>$AD8), AY7, IF(($AC7<$AC8)*AND($AD7<$AD8), AY8, IF($AE7>$AE8, AY7, IF($AE7<$AE8, AY8, 0))))","v":0},"M8","Loser M5 refs",null,{"$f":"IF(($AC7>$AC8)*AND($AD7>$AD8), BC7, IF(($AC7<$AC8)*AND($AD7<$AD8), BC8, IF($AE7>$AE8, BC7, IF($AE7<$AE8, BC8, 0))))","v":0},"M8","Loser M5 refs",null,{"$f":"IF(($AC7>$AC8)*AND($AD7>$AD8), BG7, IF(($AC7<$AC8)*AND($AD7<$AD8), BG8, IF($AE7>$AE8, BG7, IF($AE7<$AE8, BG8, 0))))","v":0},"M7","Last Loser M3/M4 refs",null,{"$f":"IF(($AC7>$AC8)*AND($AD7>$AD8), BK7, IF(($AC7<$AC8)*AND($AD7<$AD8), BK8, IF($AE7>$AE8, BK7, IF($AE7<$AE8, BK8, 0))))","v":0},"M10","Loser M6 refs",null,{"$f":"IF(($AC7>$AC8)*AND($AD7>$AD8), BO7, IF(($AC7<$AC8)*AND($AD7<$AD8), BO8, IF($AE7>$AE8, BO7, IF($AE7<$AE8, BO8, 0))))","v":0},"M10","Loser M6 refs",null,{"$f":"IF(($AC7>$AC8)*AND($AD7>$AD8), BS7, IF(($AC7<$AC8)*AND($AD7<$AD8), BS8, IF($AE7>$AE8, BS7, IF($AE7<$AE8, BS8, 0))))","v":0},"M10","Loser M6 refs",null,{"$f":"IF(($AC7>$AC8)*AND($AD7>$AD8), BW7, IF(($AC7<$AC8)*AND($AD7<$AD8), BW8, IF($AE7>$AE8, BW7, IF($AE7<$AE8, BW8, 0))))","v":0}]
["Set 2",{"$f":"IF(SCORES!D13>SCORES!E13,1,0)","v":0},{"$f":"IF(SCORES!E13>SCORES!D13,1,0)","v":0},{"$f":"IF(SCORES!F13>SCORES!G13,1,0)","v":0},{"$f":"IF(SCORES!G13>SCORES!F13,1,0)","v":0},{"$f":"IF(SCORES!H13>SCORES!I13,1,0)","v":0},{"$f":"IF(SCORES!I13>SCORES!H13,1,0)","v":0},{"$f":"IF(SCORES!J13>SCORES!K13,1,0)","v":0},{"$f":"IF(SCORES!K13>SCORES!J13,1,0)","v":0},{"$f":"IF(SCORES!L13>SCORES!M13,1,0)","v":0},{"$f":"IF(SCORES!M13>SCORES!L13,1,0)","v":0},{"$f":"IF(SCORES!N13>SCORES!O13,1,0)","v":0},{"$f":"IF(SCORES!O13>SCORES!N13,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,12,"B",{"$f":"SCORES!H47","v":0},{"$f":"SCORES!I47","v":0},{"$f":"SCORES!J47","v":0}," "," "," "," ",null,null,null,null,null,null,null,null,null,null,"2nd place Pool A",{"$f":"IF(STANDINGS!$J$4=2,STANDINGS!$B$4,IF(STANDINGS!$J$5=2,STANDINGS!$B$5,IF(STANDINGS!$J$6=2,STANDINGS!$B$6,IF(STANDINGS!$J$7=2,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"1st place Pool B",{"$f":"IF(STANDINGS!$J$15=1,STANDINGS!$B$15,IF(STANDINGS!$J$16=1,STANDINGS!$B$16,IF(STANDINGS!$J$17=1,STANDINGS!$B$17,IF(STANDINGS!$J$18=1,STANDINGS!$B$18,\" \"))))","v":" "},null,null,null,{"$f":"IF(($AC9>$AC10)*AND($AD9>$AD10), BC9, IF(($AC9<$AC10)*AND($AD9<$AD10), BC10, IF($AE9>$AE10, BC9, IF($AE9<$AE10, BC10, 0))))","v":0},null,null,null,{"$f":"IF(($AC9>$AC10)*AND($AD9>$AD10), BG9, IF(($AC9<$AC10)*AND($AD9<$AD10), BG10, IF($AE9>$AE10, BG9, IF($AE9<$AE10, BG10, 0))))","v":0},null,null,null,{"$f":"IF(($AC9>$AC10)*AND($AD9>$AD10), BK9, IF(($AC9<$AC10)*AND($AD9<$AD10), BK10, IF($AE9>$AE10, BK9, IF($AE9<$AE10, BK10, 0))))","v":0},null,null,null,{"$f":"IF(($AC9>$AC10)*AND($AD9>$AD10), BO9, IF(($AC9<$AC10)*AND($AD9<$AD10), BO10, IF($AE9>$AE10, BO9, IF($AE9<$AE10, BO10, 0))))","v":0},null,null,null,{"$f":"IF(($AC9>$AC10)*AND($AD9>$AD10), BS9, IF(($AC9<$AC10)*AND($AD9<$AD10), BS10, IF($AE9>$AE10, BS9, IF($AE9<$AE10, BS10, 0))))","v":0},null,null,null,{"$f":"IF(($AC9>$AC10)*AND($AD9>$AD10), BW9, IF(($AC9<$AC10)*AND($AD9<$AD10), BW10, IF($AE9>$AE10, BW9, IF($AE9<$AE10, BW10, 0))))","v":0}]
["Set 3",{"$f":"IF(SCORES!D14>SCORES!E14,1,0)","v":0},{"$f":"IF(SCORES!E14>SCORES!D14,1,0)","v":0},{"$f":"IF(SCORES!F14>SCORES!G14,1,0)","v":0},{"$f":"IF(SCORES!G14>SCORES!F14,1,0)","v":0},{"$f":"IF(SCORES!H14>SCORES!I14,1,0)","v":0},{"$f":"IF(SCORES!I14>SCORES!H14,1,0)","v":0},{"$f":"IF(SCORES!J14>SCORES!K14,1,0)","v":0},{"$f":"IF(SCORES!K14>SCORES!J14,1,0)","v":0},{"$f":"IF(SCORES!L14>SCORES!M14,1,0)","v":0},{"$f":"IF(SCORES!M14>SCORES!L14,1,0)","v":0},{"$f":"IF(SCORES!N14>SCORES!O14,1,0)","v":0},{"$f":"IF(SCORES!O14>SCORES!N14,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,13,"A",{"$f":"SCORES!H48","v":0},{"$f":"SCORES!I48","v":0},{"$f":"SCORES!J48","v":0},"M13","Last Loser M9/M10 refs"," "," ",null,null,null,null,null,null,null,null,"M5","Loser M3 refs",null,{"$f":"IF(($AC11>$AC128)*AND($AD11>$AD12), AU11, IF(($AC11<$AC12)*AND($AD11<$AD12), AU12, IF($AE11>$AE12, AU11, IF($AE11<$AE12, AU12, 0))))","v":0},"M7","Last Loser M4/M5 refs",null,{"$f":"IF(($AC11>$AC128)*AND($AD11>$AD12), AY11, IF(($AC11<$AC12)*AND($AD11<$AD12), AY12, IF($AE11>$AE12, AY11, IF($AE11<$AE12, AY12, 0))))","v":0},"M9","Last Loser M7/M8 refs",null,{"$f":"IF(($AC11>$AC128)*AND($AD11>$AD12), BC11, IF(($AC11<$AC12)*AND($AD11<$AD12), BC12, IF($AE11>$AE12, BC11, IF($AE11<$AE12, BC12, 0))))","v":0},"M10","Loser M7/M8 refs",null,{"$f":"IF(($AC11>$AC128)*AND($AD11>$AD12), BG11, IF(($AC11<$AC12)*AND($AD11<$AD12), BG12, IF($AE11>$AE12, BG11, IF($AE11<$AE12, BG12, 0))))","v":0},"M9","Last Loser M6/M7 refs",null,{"$f":"IF(($AC11>$AC128)*AND($AD11>$AD12), BK11, IF(($AC11<$AC12)*AND($AD11<$AD12), BK12, IF($AE11>$AE12, BK11, IF($AE11<$AE12, BK12, 0))))","v":0},"M12","Last Loser M9/M10 refs",null,{"$f":"IF(($AC11>$AC128)*AND($AD11>$AD12), BO11, IF(($AC11<$AC12)*AND($AD11<$AD12), BO12, IF($AE11>$AE12, BO11, IF($AE11<$AE12, BO12, 0))))","v":0},"M12","Last Loser M9/M10 refs",null,{"$f":"IF(($AC11>$AC128)*AND($AD11>$AD12), BS11, IF(($AC11<$AC12)*AND($AD11<$AD12), BS12, IF($AE11>$AE12, BS11, IF($AE11<$AE12, BS12, 0))))","v":0},"M13","Last Loser M9/M10 refs",null,{"$f":"IF(($AC11>$AC128)*AND($AD11>$AD12), BW11, IF(($AC11<$AC12)*AND($AD11<$AD12), BW12, IF($AE11>$AE12, BW11, IF($AE11<$AE12, BW12, 0))))","v":0}]
["Set 4",{"$f":"IF(SCORES!D15>SCORES!E15,1,0)","v":0},{"$f":"IF(SCORES!E15>SCORES!D15,1,0)","v":0},{"$f":"IF(SCORES!F15>SCORES!G15,1,0)","v":0},{"$f":"IF(SCORES!G15>SCORES!F15,1,0)","v":0},{"$f":"IF(SCORES!H15>SCORES!I15,1,0)","v":0},{"$f":"IF(SCORES!I15>SCORES!H15,1,0)","v":0},{"$f":"IF(SCORES!J15>SCORES!K15,1,0)","v":0},{"$f":"IF(SCORES!K15>SCORES!J15,1,0)","v":0},{"$f":"IF(SCORES!L15>SCORES!M15,1,0)","v":0},{"$f":"IF(SCORES!M15>SCORES!L15,1,0)","v":0},{"$f":"IF(SCORES!N15>SCORES!O15,1,0)","v":0},{"$f":"IF(SCORES!O15>SCORES!N15,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,14,"B",{"$f":"SCORES!H49","v":0},{"$f":"SCORES!I49","v":0},{"$f":"SCORES!J49","v":0}," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AC13>$AC14)*AND($AD13>$AD14), AU13, IF(($AC13<$AC14)*AND($AD13<$AD14), AU14, IF($AE13>$AE14, AU13, IF($AE13<$AE14, AU14, 0))))","v":0},null,null,null,{"$f":"IF(($AC13>$AC14)*AND($AD13>$AD14), AY13, IF(($AC13<$AC14)*AND($AD13<$AD14), AY14, IF($AE13>$AE14, AY13, IF($AE13<$AE14, AY14, 0))))","v":0},null,null,null,{"$f":"IF(($AC13>$AC14)*AND($AD13>$AD14), BC13, IF(($AC13<$AC14)*AND($AD13<$AD14), BC14, IF($AE13>$AE14, BC13, IF($AE13<$AE14, BC14, 0))))","v":0},null,null,null,{"$f":"IF(($AC13>$AC14)*AND($AD13>$AD14), BG13, IF(($AC13<$AC14)*AND($AD13<$AD14), BG14, IF($AE13>$AE14, BG13, IF($AE13<$AE14, BG14, 0))))","v":0},null,null,null,{"$f":"IF(($AC13>$AC14)*AND($AD13>$AD14), BK13, IF(($AC13<$AC14)*AND($AD13<$AD14), BK14, IF($AE13>$AE14, BK13, IF($AE13<$AE14, BK14, 0))))","v":0},null,null,null,{"$f":"IF(($AC13>$AC14)*AND($AD13>$AD14), BO13, IF(($AC13<$AC14)*AND($AD13<$AD14), BO14, IF($AE13>$AE14, BO13, IF($AE13<$AE14, BO14, 0))))","v":0},null,null,null,{"$f":"IF(($AC13>$AC14)*AND($AD13>$AD14), BS13, IF(($AC13<$AC14)*AND($AD13<$AD14), BS14, IF($AE13>$AE14, BS13, IF($AE13<$AE14, BS14, 0))))","v":0},null,null,null,{"$f":"IF(($AC13>$AC14)*AND($AD13>$AD14), BW13, IF(($AC13<$AC14)*AND($AD13<$AD14), BW14, IF($AE13>$AE14, BW13, IF($AE13<$AE14, BW14, 0))))","v":0}]
["Set 5",{"$f":"IF(SCORES!D16>SCORES!E16,1,0)","v":0},{"$f":"IF(SCORES!E16>SCORES!D16,1,0)","v":0},{"$f":"IF(SCORES!F16>SCORES!G16,1,0)","v":0},{"$f":"IF(SCORES!G16>SCORES!F16,1,0)","v":0},{"$f":"IF(SCORES!H16>SCORES!I16,1,0)","v":0},{"$f":"IF(SCORES!I16>SCORES!H16,1,0)","v":0},{"$f":"IF(SCORES!J16>SCORES!K16,1,0)","v":0},{"$f":"IF(SCORES!K16>SCORES!J16,1,0)","v":0},{"$f":"IF(SCORES!L16>SCORES!M16,1,0)","v":0},{"$f":"IF(SCORES!M16>SCORES!L16,1,0)","v":0},{"$f":"IF(SCORES!N16>SCORES!O16,1,0)","v":0},{"$f":"IF(SCORES!O16>SCORES!N16,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,15,"CHAMP",null,null,null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AC15>$AC16)*AND($AD15>$AD16), AU15, IF(($AC15<$AC16)*AND($AD15<$AD16), AU16, IF($AE15>$AE16, AU15, IF($AE15<$AE16, AU15, 0))))","v":0},null,null,null,{"$f":"IF(($AC15>$AC16)*AND($AD15>$AD16), AY15, IF(($AC15<$AC16)*AND($AD15<$AD16), AY16, IF($AE15>$AE16, AY15, IF($AE15<$AE16, AY15, 0))))","v":0},null,null,null,{"$f":"IF(($AC15>$AC16)*AND($AD15>$AD16), BC15, IF(($AC15<$AC16)*AND($AD15<$AD16), BC16, IF($AE15>$AE16, BC15, IF($AE15<$AE16, BC15, 0))))","v":0},null,null,null,{"$f":"IF(($AC15>$AC16)*AND($AD15>$AD16), BG15, IF(($AC15<$AC16)*AND($AD15<$AD16), BG16, IF($AE15>$AE16, BG15, IF($AE15<$AE16, BG15, 0))))","v":0},"CHAMP",null,null,{"$f":"IF(($AC15>$AC16)*AND($AD15>$AD16), BK15, IF(($AC15<$AC16)*AND($AD15<$AD16), BK16, IF($AE15>$AE16, BK15, IF($AE15<$AE16, BK15, 0))))","v":0},null,null,null,{"$f":"IF(($AC15>$AC16)*AND($AD15>$AD16), BO15, IF(($AC15<$AC16)*AND($AD15<$AD16), BO16, IF($AE15>$AE16, BO15, IF($AE15<$AE16, BO15, 0))))","v":0},null,null,null,{"$f":"IF(($AC15>$AC16)*AND($AD15>$AD16), BS15, IF(($AC15<$AC16)*AND($AD15<$AD16), BS16, IF($AE15>$AE16, BS15, IF($AE15<$AE16, BS15, 0))))","v":0},null,null,null,{"$f":"IF(($AC15>$AC16)*AND($AD15>$AD16), BW15, IF(($AC15<$AC16)*AND($AD15<$AD16), BW16, IF($AE15>$AE16, BW15, IF($AE15<$AE16, BW15, 0))))","v":0}]
["Set Total",{"$f":"SUM(B13:B17)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"A",{"$f":"SCORES!H53","v":0},{"$f":"SCORES!I53","v":0},{"$f":"SCORES!J53","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,"M5","3rd place Pool A refs","3rd place Pool D",{"$f":"IF(STANDINGS!$J$37=3,STANDINGS!$B$37,IF(STANDINGS!$J$38=3,STANDINGS!$B$38,IF(STANDINGS!$J$39=3,STANDINGS!$B$39,IF(STANDINGS!$J$40=3,STANDINGS!$B$40,\" \"))))","v":" "},"M3","3rd place Pool A refs","3rd place Pool D",{"$f":"IF(STANDINGS!$J$37=3,STANDINGS!$B$37,IF(STANDINGS!$J$38=3,STANDINGS!$B$38,IF(STANDINGS!$J$39=3,STANDINGS!$B$39,IF(STANDINGS!$J$40=3,STANDINGS!$B$40,\" \"))))","v":" "}]
["Score Total",{"$f":"SUM(SCORES!D12:D16)","v":0},{"$f":"SUM(SCORES!E12:E16)","v":0},{"$f":"SUM(SCORES!F12:F16)","v":0},{"$f":"SUM(SCORES!G12:G16)","v":0},{"$f":"SUM(SCORES!H12:H16)","v":0},{"$f":"SUM(SCORES!I12:I16)","v":0},{"$f":"SUM(SCORES!J12:J16)","v":0},{"$f":"SUM(SCORES!K12:K16)","v":0},{"$f":"SUM(SCORES!L12:L16)","v":0},{"$f":"SUM(SCORES!M12:M16)","v":0},{"$f":"SUM(SCORES!N12:N16)","v":0},{"$f":"SUM(SCORES!O12:O16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,17,"B",{"$f":"SCORES!H54","v":0},{"$f":"SCORES!I54","v":0},{"$f":"SCORES!J54","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,"4th place Pool A",{"$f":"IF(STANDINGS!$J$4=4,STANDINGS!$B$4,IF(STANDINGS!$J$5=4,STANDINGS!$B$5,IF(STANDINGS!$J$6=4,STANDINGS!$B$6,IF(STANDINGS!$J$7=4,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"4th place Pool B",{"$f":"IF(STANDINGS!$J$15=4,STANDINGS!$B$15,IF(STANDINGS!$J$16=4,STANDINGS!$B$16,IF(STANDINGS!$J$17=4,STANDINGS!$B$17,IF(STANDINGS!$J$18=4,STANDINGS!$B$18,\" \"))))","v":" "}]
["Match",{"$f":"IF((B18>0)*AND(B18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((C18>0)*AND(C18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((D18>0)*AND(D18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((E18>0)*AND(E18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((F18>0)*AND(F18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((G18>0)*AND(G18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((H18>0)*AND(H18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((I18>0)*AND(I18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((J18>0)*AND(J18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((K18>0)*AND(K18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((L18>0)*AND(L18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},{"$f":"IF((M18>0)*AND(M18=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,3,FALSE)),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,18,"A",{"$f":"SCORES!H55","v":0},{"$f":"SCORES!I55","v":0},{"$f":"SCORES!J55","v":0}," "," "," "," "]
["POOL C CONTROL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"B",{"$f":"SCORES!H56","v":0},{"$f":"SCORES!I56","v":0},{"$f":"SCORES!J56","v":0}," "," "," "," "]
[null,"#1","#3","#2","#4","#1","#4","#2","#3","#3","#4","#1","#2",null,null,null,null,null,null,null,null,null,null,null,null,null,20,"A",{"$f":"SCORES!H57","v":0},{"$f":"SCORES!I57","v":0},{"$f":"SCORES!J57","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,"M4","3rd place Pool B refs","3rd place Pool C",{"$f":"IF(STANDINGS!$J$26=3,STANDINGS!$B$26,IF(STANDINGS!$J$27=3,STANDINGS!$B$27,IF(STANDINGS!$J$28=3,STANDINGS!$B$28,IF(STANDINGS!$J$29=3,STANDINGS!$B$29,\" \"))))","v":" "}]
["Set 1",{"$f":"IF(SCORES!D19>SCORES!E19,1,0)","v":0},{"$f":"IF(SCORES!E19>SCORES!D19,1,0)","v":0},{"$f":"IF(SCORES!F19>SCORES!G19,1,0)","v":0},{"$f":"IF(SCORES!G19>SCORES!F19,1,0)","v":0},{"$f":"IF(SCORES!H19>SCORES!I19,1,0)","v":0},{"$f":"IF(SCORES!I19>SCORES!H19,1,0)","v":0},{"$f":"IF(SCORES!J19>SCORES!K19,1,0)","v":0},{"$f":"IF(SCORES!K19>SCORES!J19,1,0)","v":0},{"$f":"IF(SCORES!L19>SCORES!M19,1,0)","v":0},{"$f":"IF(SCORES!M19>SCORES!L19,1,0)","v":0},{"$f":"IF(SCORES!N19>SCORES!O19,1,0)","v":0},{"$f":"IF(SCORES!O19>SCORES!N19,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,21,"B",{"$f":"SCORES!H58","v":0},{"$f":"SCORES!I58","v":0},{"$f":"SCORES!J58","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,"4th place Pool A",{"$f":"IF(STANDINGS!$J$4=4,STANDINGS!$B$4,IF(STANDINGS!$J$5=4,STANDINGS!$B$5,IF(STANDINGS!$J$6=4,STANDINGS!$B$6,IF(STANDINGS!$J$7=4,STANDINGS!$B$7,\" \"))))","v":" "}]
["Set 2",{"$f":"IF(SCORES!D20>SCORES!E20,1,0)","v":0},{"$f":"IF(SCORES!E20>SCORES!D20,1,0)","v":0},{"$f":"IF(SCORES!F20>SCORES!G20,1,0)","v":0},{"$f":"IF(SCORES!G20>SCORES!F20,1,0)","v":0},{"$f":"IF(SCORES!H20>SCORES!I20,1,0)","v":0},{"$f":"IF(SCORES!I20>SCORES!H20,1,0)","v":0},{"$f":"IF(SCORES!J20>SCORES!K20,1,0)","v":0},{"$f":"IF(SCORES!K20>SCORES!J20,1,0)","v":0},{"$f":"IF(SCORES!L20>SCORES!M20,1,0)","v":0},{"$f":"IF(SCORES!M20>SCORES!L20,1,0)","v":0},{"$f":"IF(SCORES!N20>SCORES!O20,1,0)","v":0},{"$f":"IF(SCORES!O20>SCORES!N20,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,22,"A",{"$f":"SCORES!H59","v":0},{"$f":"SCORES!I59","v":0},{"$f":"SCORES!J59","v":0}," "," "," "," "]
["Set 3",{"$f":"IF(SCORES!D21>SCORES!E21,1,0)","v":0},{"$f":"IF(SCORES!E21>SCORES!D21,1,0)","v":0},{"$f":"IF(SCORES!F21>SCORES!G21,1,0)","v":0},{"$f":"IF(SCORES!G21>SCORES!F21,1,0)","v":0},{"$f":"IF(SCORES!H21>SCORES!I21,1,0)","v":0},{"$f":"IF(SCORES!I21>SCORES!H21,1,0)","v":0},{"$f":"IF(SCORES!J21>SCORES!K21,1,0)","v":0},{"$f":"IF(SCORES!K21>SCORES!J21,1,0)","v":0},{"$f":"IF(SCORES!L21>SCORES!M21,1,0)","v":0},{"$f":"IF(SCORES!M21>SCORES!L21,1,0)","v":0},{"$f":"IF(SCORES!N21>SCORES!O21,1,0)","v":0},{"$f":"IF(SCORES!O21>SCORES!N21,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,23,"B",{"$f":"SCORES!H60","v":0},{"$f":"SCORES!I60","v":0},{"$f":"SCORES!J60","v":0}," "," "," "," "]
["Set 4",{"$f":"IF(SCORES!D22>SCORES!E22,1,0)","v":0},{"$f":"IF(SCORES!E22>SCORES!D22,1,0)","v":0},{"$f":"IF(SCORES!F22>SCORES!G22,1,0)","v":0},{"$f":"IF(SCORES!G22>SCORES!F22,1,0)","v":0},{"$f":"IF(SCORES!H22>SCORES!I22,1,0)","v":0},{"$f":"IF(SCORES!I22>SCORES!H22,1,0)","v":0},{"$f":"IF(SCORES!J22>SCORES!K22,1,0)","v":0},{"$f":"IF(SCORES!K22>SCORES!J22,1,0)","v":0},{"$f":"IF(SCORES!L22>SCORES!M22,1,0)","v":0},{"$f":"IF(SCORES!M22>SCORES!L22,1,0)","v":0},{"$f":"IF(SCORES!N22>SCORES!O22,1,0)","v":0},{"$f":"IF(SCORES!O22>SCORES!N22,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,24,"A",{"$f":"SCORES!H61","v":0},{"$f":"SCORES!I61","v":0},{"$f":"SCORES!J61","v":0},"M3","3rd place Pool C refs","3rd place Pool A"," ",null,null,null,null,null,null,null,null,"M2","4th place Pool A refs","3rd place Pool A",{"$f":"IF(STANDINGS!$J$4=3,STANDINGS!$B$4,IF(STANDINGS!$J$5=3,STANDINGS!$B$5,IF(STANDINGS!$J$6=3,STANDINGS!$B$6,IF(STANDINGS!$J$7=3,STANDINGS!$B$7,\" \"))))","v":" "},"M3","4th place Pool A refs","3rd place Pool A",{"$f":"IF(STANDINGS!$J$4=3,STANDINGS!$B$4,IF(STANDINGS!$J$5=3,STANDINGS!$B$5,IF(STANDINGS!$J$6=3,STANDINGS!$B$6,IF(STANDINGS!$J$7=3,STANDINGS!$B$7,\" \"))))","v":" "},null,null,null,null,"M3","4th place Pool B refs","3rd-Best 3rd Place Record",{"$f":"IF(CALCS!P$120=3,CALCS!B$120,(IF(CALCS!P$121=3,CALCS!B$121,(IF(CALCS!P$122=3,CALCS!B$122,0)))))","v":0},"M10","Loser M8 refs",null,{"$f":"IF(($AC18>$AC19)*AND($AD18>$AD19), BK18, IF(($AC18<$AC19)*AND($AD18<$AD19), BK19, IF($AE18>$AE19, BK18, IF($AE18<$AE19, BK19, 0))))","v":0},"M7","Loser M3 refs",null,{"$f":"IF(($AC18>$AC19)*AND($AD18>$AD19), BO18, IF(($AC18<$AC19)*AND($AD18<$AD19), BO19, IF($AE18>$AE19, BO18, IF($AE18<$AE19, BO19, 0))))","v":0},"M3","3rd place Pool C refs","3rd place Pool A",{"$f":"IF(STANDINGS!$J$4=3,STANDINGS!$B$4,IF(STANDINGS!$J$5=3,STANDINGS!$B$5,IF(STANDINGS!$J$6=3,STANDINGS!$B$6,IF(STANDINGS!$J$7=3,STANDINGS!$B$7,\" \"))))","v":" "},"M3","3rd place Pool C refs","3rd place Pool A",{"$f":"IF(STANDINGS!$J$4=3,STANDINGS!$B$4,IF(STANDINGS!$J$5=3,STANDINGS!$B$5,IF(STANDINGS!$J$6=3,STANDINGS!$B$6,IF(STANDINGS!$J$7=3,STANDINGS!$B$7,\" \"))))","v":" "}]
["Set 5",{"$f":"IF(SCORES!D23>SCORES!E23,1,0)","v":0},{"$f":"IF(SCORES!E23>SCORES!D23,1,0)","v":0},{"$f":"IF(SCORES!F23>SCORES!G23,1,0)","v":0},{"$f":"IF(SCORES!G23>SCORES!F23,1,0)","v":0},{"$f":"IF(SCORES!H23>SCORES!I23,1,0)","v":0},{"$f":"IF(SCORES!I23>SCORES!H23,1,0)","v":0},{"$f":"IF(SCORES!J23>SCORES!K23,1,0)","v":0},{"$f":"IF(SCORES!K23>SCORES!J23,1,0)","v":0},{"$f":"IF(SCORES!L23>SCORES!M23,1,0)","v":0},{"$f":"IF(SCORES!M23>SCORES!L23,1,0)","v":0},{"$f":"IF(SCORES!N23>SCORES!O23,1,0)","v":0},{"$f":"IF(SCORES!O23>SCORES!N23,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,25,"B",{"$f":"SCORES!H62","v":0},{"$f":"SCORES!I62","v":0},{"$f":"SCORES!J62","v":0}," "," ","3rd place Pool D"," ",null,null,null,null,null,null,null,null,null,null,"4th place Pool B",{"$f":"IF(STANDINGS!$J$15=4,STANDINGS!$B$15,IF(STANDINGS!$J$16=4,STANDINGS!$B$16,IF(STANDINGS!$J$17=4,STANDINGS!$B$17,IF(STANDINGS!$J$18=4,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"3rd place Pool C",{"$f":"IF(STANDINGS!$J$26=3,STANDINGS!$B$26,IF(STANDINGS!$J$27=3,STANDINGS!$B$27,IF(STANDINGS!$J$28=3,STANDINGS!$B$28,IF(STANDINGS!$J$29=3,STANDINGS!$B$29,\" \"))))","v":" "},null,null,null,null,null,null,"4th place Pool A",{"$f":"IF(STANDINGS!$J$4=4,STANDINGS!$B$4,IF(STANDINGS!$J$5=4,STANDINGS!$B$5,IF(STANDINGS!$J$6=4,STANDINGS!$B$6,IF(STANDINGS!$J$7=4,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"3rd place Pool A",{"$f":"IF(STANDINGS!$J$4=3,STANDINGS!$B$4,IF(STANDINGS!$J$5=3,STANDINGS!$B$5,IF(STANDINGS!$J$6=3,STANDINGS!$B$6,IF(STANDINGS!$J$7=3,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"3rd place Pool A",{"$f":"IF(STANDINGS!$J$4=3,STANDINGS!$B$4,IF(STANDINGS!$J$5=3,STANDINGS!$B$5,IF(STANDINGS!$J$6=3,STANDINGS!$B$6,IF(STANDINGS!$J$7=3,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"3rd place Pool D",{"$f":"IF(STANDINGS!$J$37=3,STANDINGS!$B$37,IF(STANDINGS!$J$38=3,STANDINGS!$B$38,IF(STANDINGS!$J$39=3,STANDINGS!$B$39,IF(STANDINGS!$J$40=3,STANDINGS!$B$40,\" \"))))","v":" "},null,null,"3rd place Pool D",{"$f":"IF(STANDINGS!$J$37=3,STANDINGS!$B$37,IF(STANDINGS!$J$38=3,STANDINGS!$B$38,IF(STANDINGS!$J$39=3,STANDINGS!$B$39,IF(STANDINGS!$J$40=3,STANDINGS!$B$40,\" \"))))","v":" "}]
["Set Total",{"$f":"SUM(B23:B27)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"A",{"$f":"SCORES!H63","v":0},{"$f":"SCORES!I63","v":0},{"$f":"SCORES!J63","v":0},"M7","Loser M3 refs","3rd place Pool B"," ",null,null,null,null,null,null,null,null,"M4","Loser M2 refs","3rd place Pool B",{"$f":"IF(STANDINGS!$J$15=3,STANDINGS!$B$15,IF(STANDINGS!$J$16=3,STANDINGS!$B$16,IF(STANDINGS!$J$17=3,STANDINGS!$B$17,IF(STANDINGS!$J$18=3,STANDINGS!$B$18,\" \"))))","v":" "},"M6","Loser M3 refs","3rd place Pool B",{"$f":"IF(STANDINGS!$J$15=3,STANDINGS!$B$15,IF(STANDINGS!$J$16=3,STANDINGS!$B$16,IF(STANDINGS!$J$17=3,STANDINGS!$B$17,IF(STANDINGS!$J$18=3,STANDINGS!$B$18,\" \"))))","v":" "},"M3","3rd-Best 3rd Place Record refs","4th place Pool A",{"$f":"IF(STANDINGS!$J$4=4,STANDINGS!$B$4,IF(STANDINGS!$J$5=4,STANDINGS!$B$5,IF(STANDINGS!$J$6=4,STANDINGS!$B$6,IF(STANDINGS!$J$7=4,STANDINGS!$B$7,\" \"))))","v":" "},"M6","Loser M3 refs","4th place Pool C",{"$f":"IF(STANDINGS!$J$26=4,STANDINGS!$B$26,IF(STANDINGS!$J$27=4,STANDINGS!$B$27,IF(STANDINGS!$J$28=4,STANDINGS!$B$28,IF(STANDINGS!$J$29=4,STANDINGS!$B$29,\" \"))))","v":" "},"M8","First loser of M3/M4 refs","3rd place Pool B",{"$f":"IF(STANDINGS!$J$15=3,STANDINGS!$B$15,IF(STANDINGS!$J$16=3,STANDINGS!$B$16,IF(STANDINGS!$J$17=3,STANDINGS!$B$17,IF(STANDINGS!$J$18=3,STANDINGS!$B$18,\" \"))))","v":" "},"M8","Loser M4 refs",null,{"$f":"IF(($AC22>$AC23)*AND($AD22>$AD23), BO22, IF(($AC22<$AC23)*AND($AD22<$AD23), BO23, IF($AE22>$AE23, BO22, IF($AE22<$AE23, BO23, 0))))","v":0},"M7","Loser M3 refs","3rd place Pool B",{"$f":"IF(STANDINGS!$J$15=3,STANDINGS!$B$15,IF(STANDINGS!$J$16=3,STANDINGS!$B$16,IF(STANDINGS!$J$17=3,STANDINGS!$B$17,IF(STANDINGS!$J$18=3,STANDINGS!$B$18,\" \"))))","v":" "},"M7","Loser M3 refs","3rd place Pool B",{"$f":"IF(STANDINGS!$J$15=3,STANDINGS!$B$15,IF(STANDINGS!$J$16=3,STANDINGS!$B$16,IF(STANDINGS!$J$17=3,STANDINGS!$B$17,IF(STANDINGS!$J$18=3,STANDINGS!$B$18,\" \"))))","v":" "}]
["Score Total",{"$f":"SUM(SCORES!D19:D23)","v":0},{"$f":"SUM(SCORES!E19:E23)","v":0},{"$f":"SUM(SCORES!F19:F23)","v":0},{"$f":"SUM(SCORES!G19:G23)","v":0},{"$f":"SUM(SCORES!H19:H23)","v":0},{"$f":"SUM(SCORES!I19:I23)","v":0},{"$f":"SUM(SCORES!J19:J23)","v":0},{"$f":"SUM(SCORES!K19:K23)","v":0},{"$f":"SUM(SCORES!L19:L23)","v":0},{"$f":"SUM(SCORES!M19:M23)","v":0},{"$f":"SUM(SCORES!N19:N23)","v":0},{"$f":"SUM(SCORES!O19:O23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,27,"B",{"$f":"SCORES!H64","v":0},{"$f":"SCORES!I64","v":0},{"$f":"SCORES!J64","v":0}," "," ","3rd place Pool C"," ",null,null,null,null,null,null,null,null,null,null,"4th place Pool A",{"$f":"IF(STANDINGS!$J$4=4,STANDINGS!$B$4,IF(STANDINGS!$J$5=4,STANDINGS!$B$5,IF(STANDINGS!$J$6=4,STANDINGS!$B$6,IF(STANDINGS!$J$7=4,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"4th place Pool A",{"$f":"IF(STANDINGS!$J$4=4,STANDINGS!$B$4,IF(STANDINGS!$J$5=4,STANDINGS!$B$5,IF(STANDINGS!$J$6=4,STANDINGS!$B$6,IF(STANDINGS!$J$7=4,STANDINGS!$B$7,\" \"))))","v":" "},null,null,"4th place Pool B",{"$f":"IF(STANDINGS!$J$15=4,STANDINGS!$B$15,IF(STANDINGS!$J$16=4,STANDINGS!$B$16,IF(STANDINGS!$J$17=4,STANDINGS!$B$17,IF(STANDINGS!$J$18=4,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"4th place Pool B",{"$f":"IF(STANDINGS!$J$15=4,STANDINGS!$B$15,IF(STANDINGS!$J$16=4,STANDINGS!$B$16,IF(STANDINGS!$J$17=4,STANDINGS!$B$17,IF(STANDINGS!$J$18=4,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"3rd place Pool C",{"$f":"IF(STANDINGS!$J$26=3,STANDINGS!$B$26,IF(STANDINGS!$J$27=3,STANDINGS!$B$27,IF(STANDINGS!$J$28=3,STANDINGS!$B$28,IF(STANDINGS!$J$29=3,STANDINGS!$B$29,\" \"))))","v":" "},null,null,"3rd place Pool B",{"$f":"IF(STANDINGS!$J$15=3,STANDINGS!$B$15,IF(STANDINGS!$J$16=3,STANDINGS!$B$16,IF(STANDINGS!$J$17=3,STANDINGS!$B$17,IF(STANDINGS!$J$18=3,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"3rd place Pool C",{"$f":"IF(STANDINGS!$J$26=3,STANDINGS!$B$26,IF(STANDINGS!$J$27=3,STANDINGS!$B$27,IF(STANDINGS!$J$28=3,STANDINGS!$B$28,IF(STANDINGS!$J$29=3,STANDINGS!$B$29,\" \"))))","v":" "},null,null,"3rd place Pool C",{"$f":"IF(STANDINGS!$J$26=3,STANDINGS!$B$26,IF(STANDINGS!$J$27=3,STANDINGS!$B$27,IF(STANDINGS!$J$28=3,STANDINGS!$B$28,IF(STANDINGS!$J$29=3,STANDINGS!$B$29,\" \"))))","v":" "}]
["Match",{"$f":"IF((B28>0)*AND(B28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((C28>0)*AND(C28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((D28>0)*AND(D28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((E28>0)*AND(E28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((F28>0)*AND(F28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((G28>0)*AND(G28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((H28>0)*AND(H28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((I28>0)*AND(I28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((J28>0)*AND(J28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((K28>0)*AND(K28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((L28>0)*AND(L28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},{"$f":"IF((M28>0)*AND(M28=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,4,FALSE)),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,28,"A",{"$f":"SCORES!H65","v":0},{"$f":"SCORES!I65","v":0},{"$f":"SCORES!J65","v":0},"M11","Loser M7 refs"," "," ",null,null,null,null,null,null,null,null,"M6","Loser M4 refs",null,{"$f":"IF(($AC26>$AC27)*AND($AD26>$AD27), AU26, IF(($AC26<$AC27)*AND($AD26<$AD27), AU27, IF($AE26>$AE27, AU26, IF($AE26<$AE27, AU27, 0))))","v":0},"M8","Loser M6 refs",null,{"$f":"IF(($AC26>$AC27)*AND($AD26>$AD27), AY26, IF(($AC26<$AC27)*AND($AD26<$AD27), AY27, IF($AE26>$AE27, AY26, IF($AE26<$AE27, AY27, 0))))","v":0},"M6","Loser M3 refs","3rd-Best 3rd Place Record",{"$f":"IF(CALCS!P$120=3,CALCS!B$120,(IF(CALCS!P$121=3,CALCS!B$121,(IF(CALCS!P$122=3,CALCS!B$122,0)))))","v":0},"M9","Loser M6 refs",null,{"$f":"IF(($AC26>$AC27)*AND($AD26>$AD27), BG26, IF(($AC26<$AC27)*AND($AD26<$AD27), BG27, IF($AE26>$AE27, BG26, IF($AE26<$AE27, BG27, 0))))","v":0},"M11","Loser M10 refs",null,{"$f":"IF(($AC26>$AC27)*AND($AD26>$AD27), BK26, IF(($AC26<$AC27)*AND($AD26<$AD27), BK27, IF($AE26>$AE27, BK26, IF($AE26<$AE27, BK27, 0))))","v":0},"M11","Last Loser M7/M8 refs",null,{"$f":"IF(($AC26>$AC27)*AND($AD26>$AD27), BO26, IF(($AC26<$AC27)*AND($AD26<$AD27), BO27, IF($AE26>$AE27, BO26, IF($AE26<$AE27, BO27, 0))))","v":0},"M11","Loser M7 refs",null,{"$f":"IF(($AC26>$AC27)*AND($AD26>$AD27), BS26, IF(($AC26<$AC27)*AND($AD26<$AD27), BS27, IF($AE26>$AE27, BS26, IF($AE26<$AE27, BS27, 0))))","v":0},"M11","Loser M7 refs",null,{"$f":"IF(($AC26>$AC27)*AND($AD26>$AD27), BW26, IF(($AC26<$AC27)*AND($AD26<$AD27), BW27, IF($AE26>$AE27, BW26, IF($AE26<$AE27, BW27, 0))))","v":0}]
["POOL D CONTROL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"B",{"$f":"SCORES!H66","v":0},{"$f":"SCORES!I66","v":0},{"$f":"SCORES!J66","v":0}," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AC28>$AC29)*AND($AD28>$AD29), AU28, IF(($AC28<$AC29)*AND($AD28<$AD29), AU29, IF($AE28>$AE29, AU28, IF($AE28<$AE29, AU29, 0))))","v":0},null,null,null,{"$f":"IF(($AC28>$AC29)*AND($AD28>$AD29), AY28, IF(($AC28<$AC29)*AND($AD28<$AD29), AY29, IF($AE28>$AE29, AY28, IF($AE28<$AE29, AY29, 0))))","v":0},null,null,null,{"$f":"IF(($AC28>$AC29)*AND($AD28>$AD29), BC28, IF(($AC28<$AC29)*AND($AD28<$AD29), BC29, IF($AE28>$AE29, BC28, IF($AE28<$AE29, BC29, 0))))","v":0},null,null,null,{"$f":"IF(($AC28>$AC29)*AND($AD28>$AD29), BG28, IF(($AC28<$AC29)*AND($AD28<$AD29), BG29, IF($AE28>$AE29, BG28, IF($AE28<$AE29, BG29, 0))))","v":0},null,null,null,{"$f":"IF(($AC28>$AC29)*AND($AD28>$AD29), BK28, IF(($AC28<$AC29)*AND($AD28<$AD29), BK29, IF($AE28>$AE29, BK28, IF($AE28<$AE29, BK29, 0))))","v":0},null,null,null,{"$f":"IF(($AC28>$AC29)*AND($AD28>$AD29), BO28, IF(($AC28<$AC29)*AND($AD28<$AD29), BO29, IF($AE28>$AE29, BO28, IF($AE28<$AE29, BO29, 0))))","v":0},null,null,null,{"$f":"IF(($AC28>$AC29)*AND($AD28>$AD29), BS28, IF(($AC28<$AC29)*AND($AD28<$AD29), BS29, IF($AE28>$AE29, BS28, IF($AE28<$AE29, BS29, 0))))","v":0},null,null,null,{"$f":"IF(($AC28>$AC29)*AND($AD28>$AD29), BW28, IF(($AC28<$AC29)*AND($AD28<$AD29), BW29, IF($AE28>$AE29, BW28, IF($AE28<$AE29, BW29, 0))))","v":0}]
[null,"#1","#3","#2","#4","#1","#4","#2","#3","#3","#4","#1","#2",null,null,null,null,null,null,null,null,null,null,null,null,null,30,"CHAMP",null,null,null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AC30>$AC31)*AND($AD30>$AD31), AU30, IF(($AC30<$AC31)*AND($AD30<$AD31), AU31, IF($AE30>$AE31, AU30, IF($AE30<$AE31, AU31, 0))))","v":0},null,null,null,{"$f":"IF(($AC30>$AC31)*AND($AD30>$AD31), AY30, IF(($AC30<$AC31)*AND($AD30<$AD31), AY31, IF($AE30>$AE31, AY30, IF($AE30<$AE31, AY31, 0))))","v":0},null,null,null,{"$f":"IF(($AC30>$AC31)*AND($AD30>$AD31), BC30, IF(($AC30<$AC31)*AND($AD30<$AD31), BC31, IF($AE30>$AE31, BC30, IF($AE30<$AE31, BC31, 0))))","v":0},null,null,null,{"$f":"IF(($AC30>$AC31)*AND($AD30>$AD31), BG30, IF(($AC30<$AC31)*AND($AD30<$AD31), BG31, IF($AE30>$AE31, BG30, IF($AE30<$AE31, BG31, 0))))","v":0},null,null,null,{"$f":"IF(($AC30>$AC31)*AND($AD30>$AD31), BK30, IF(($AC30<$AC31)*AND($AD30<$AD31), BK31, IF($AE30>$AE31, BK30, IF($AE30<$AE31, BK31, 0))))","v":0},null,null,null,{"$f":"IF(($AC30>$AC31)*AND($AD30>$AD31), BO30, IF(($AC30<$AC31)*AND($AD30<$AD31), BO31, IF($AE30>$AE31, BO30, IF($AE30<$AE31, BO31, 0))))","v":0},null,null,null,{"$f":"IF(($AC30>$AC31)*AND($AD30>$AD31), BS30, IF(($AC30<$AC31)*AND($AD30<$AD31), BS31, IF($AE30>$AE31, BS30, IF($AE30<$AE31, BS31, 0))))","v":0},null,null,null,{"$f":"IF(($AC30>$AC31)*AND($AD30>$AD31), BW30, IF(($AC30<$AC31)*AND($AD30<$AD31), BW31, IF($AE30>$AE31, BW30, IF($AE30<$AE31, BW31, 0))))","v":0}]
["Set 1",{"$f":"IF(SCORES!D26>SCORES!E26,1,0)","v":0},{"$f":"IF(SCORES!E26>SCORES!D26,1,0)","v":0},{"$f":"IF(SCORES!F26>SCORES!G26,1,0)","v":0},{"$f":"IF(SCORES!G26>SCORES!F26,1,0)","v":0},{"$f":"IF(SCORES!H26>SCORES!I26,1,0)","v":0},{"$f":"IF(SCORES!I26>SCORES!H26,1,0)","v":0},{"$f":"IF(SCORES!J26>SCORES!K26,1,0)","v":0},{"$f":"IF(SCORES!K26>SCORES!J26,1,0)","v":0},{"$f":"IF(SCORES!L26>SCORES!M26,1,0)","v":0},{"$f":"IF(SCORES!M26>SCORES!L26,1,0)","v":0},{"$f":"IF(SCORES!N26>SCORES!O26,1,0)","v":0},{"$f":"IF(SCORES!O26>SCORES!N26,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,31,"A",{"$f":"SCORES!H70","v":0},{"$f":"SCORES!I70","v":0},{"$f":"SCORES!J70","v":0},"M4","4th place Pool B refs","4th place 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,"M4","4th place Pool B refs","4th place Pool A",{"$f":"IF(STANDINGS!$J$4=4,STANDINGS!$B$4,IF(STANDINGS!$J$5=4,STANDINGS!$B$5,IF(STANDINGS!$J$6=4,STANDINGS!$B$6,IF(STANDINGS!$J$7=4,STANDINGS!$B$7,\" \"))))","v":" "}]
["Set 2",{"$f":"IF(SCORES!D27>SCORES!E27,1,0)","v":0},{"$f":"IF(SCORES!E27>SCORES!D27,1,0)","v":0},{"$f":"IF(SCORES!F27>SCORES!G27,1,0)","v":0},{"$f":"IF(SCORES!G27>SCORES!F27,1,0)","v":0},{"$f":"IF(SCORES!H27>SCORES!I27,1,0)","v":0},{"$f":"IF(SCORES!I27>SCORES!H27,1,0)","v":0},{"$f":"IF(SCORES!J27>SCORES!K27,1,0)","v":0},{"$f":"IF(SCORES!K27>SCORES!J27,1,0)","v":0},{"$f":"IF(SCORES!L27>SCORES!M27,1,0)","v":0},{"$f":"IF(SCORES!M27>SCORES!L27,1,0)","v":0},{"$f":"IF(SCORES!N27>SCORES!O27,1,0)","v":0},{"$f":"IF(SCORES!O27>SCORES!N27,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,32,"B",{"$f":"SCORES!H71","v":0},{"$f":"SCORES!I71","v":0},{"$f":"SCORES!J71","v":0}," "," ","4th place Pool D"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4th place Pool D",{"$f":"IF(STANDINGS!$J$37=4,STANDINGS!$B$37,IF(STANDINGS!$J$38=4,STANDINGS!$B$38,IF(STANDINGS!$J$39=4,STANDINGS!$B$39,IF(STANDINGS!$J$40=4,STANDINGS!$B$40,\" \"))))","v":" "}]
["Set 3",{"$f":"IF(SCORES!D28>SCORES!E28,1,0)","v":0},{"$f":"IF(SCORES!E28>SCORES!D28,1,0)","v":0},{"$f":"IF(SCORES!F28>SCORES!G28,1,0)","v":0},{"$f":"IF(SCORES!G28>SCORES!F28,1,0)","v":0},{"$f":"IF(SCORES!H28>SCORES!I28,1,0)","v":0},{"$f":"IF(SCORES!I28>SCORES!H28,1,0)","v":0},{"$f":"IF(SCORES!J28>SCORES!K28,1,0)","v":0},{"$f":"IF(SCORES!K28>SCORES!J28,1,0)","v":0},{"$f":"IF(SCORES!L28>SCORES!M28,1,0)","v":0},{"$f":"IF(SCORES!M28>SCORES!L28,1,0)","v":0},{"$f":"IF(SCORES!N28>SCORES!O28,1,0)","v":0},{"$f":"IF(SCORES!O28>SCORES!N28,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,33,"A",{"$f":"SCORES!H72","v":0},{"$f":"SCORES!I72","v":0},{"$f":"SCORES!J72","v":0},"M8","Loser M4 refs",{"$f":"IF($AF$1=8,IF(AT35=0,\" \",AT35),IF($AF$1=10,IF(AX35=0,\" \",AX35),IF($AF$1=11,IF(BB35=0,\" \",BB35),IF($AF$1=12,IF(BF35=0,\" \",BF35),IF($AF$1=13,IF(BJ35=0,\" \",BJ35),IF($AF$1=14,IF(BN35=0,\" \",BN35),IF($AF$1=15,IF(BR35=0,\" \",BR35),IF($AF$1=16,IF(BV35=0,\" \",BV35),0))))))))","v":"4th place Pool B"}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M4","4th place Pool C refs","4th place Pool A",{"$f":"IF(STANDINGS!$J$4=4,STANDINGS!$B$4,IF(STANDINGS!$J$5=4,STANDINGS!$B$5,IF(STANDINGS!$J$6=4,STANDINGS!$B$6,IF(STANDINGS!$J$7=4,STANDINGS!$B$7,\" \"))))","v":" "},"M8","Loser M4 refs","4th place Pool B",{"$f":"IF(STANDINGS!$J$15=4,STANDINGS!$B$15,IF(STANDINGS!$J$16=4,STANDINGS!$B$16,IF(STANDINGS!$J$17=4,STANDINGS!$B$17,IF(STANDINGS!$J$18=4,STANDINGS!$B$18,\" \"))))","v":" "}]
["Set 4",{"$f":"IF(SCORES!D29>SCORES!E29,1,0)","v":0},{"$f":"IF(SCORES!E29>SCORES!D29,1,0)","v":0},{"$f":"IF(SCORES!F29>SCORES!G29,1,0)","v":0},{"$f":"IF(SCORES!G29>SCORES!F29,1,0)","v":0},{"$f":"IF(SCORES!H29>SCORES!I29,1,0)","v":0},{"$f":"IF(SCORES!I29>SCORES!H29,1,0)","v":0},{"$f":"IF(SCORES!J29>SCORES!K29,1,0)","v":0},{"$f":"IF(SCORES!K29>SCORES!J29,1,0)","v":0},{"$f":"IF(SCORES!L29>SCORES!M29,1,0)","v":0},{"$f":"IF(SCORES!M29>SCORES!L29,1,0)","v":0},{"$f":"IF(SCORES!N29>SCORES!O29,1,0)","v":0},{"$f":"IF(SCORES!O29>SCORES!N29,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,34,"B",{"$f":"SCORES!H73","v":0},{"$f":"SCORES!I73","v":0},{"$f":"SCORES!J73","v":0}," "," ","4th place Pool C"," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4th place Pool B",{"$f":"IF(STANDINGS!$J$15=4,STANDINGS!$B$15,IF(STANDINGS!$J$16=4,STANDINGS!$B$16,IF(STANDINGS!$J$17=4,STANDINGS!$B$17,IF(STANDINGS!$J$18=4,STANDINGS!$B$18,\" \"))))","v":" "},null,null,"4th place Pool C",{"$f":"IF(STANDINGS!$J$26=4,STANDINGS!$B$26,IF(STANDINGS!$J$27=4,STANDINGS!$B$27,IF(STANDINGS!$J$28=4,STANDINGS!$B$28,IF(STANDINGS!$J$29=4,STANDINGS!$B$29,\" \"))))","v":" "}]
["Set 5",{"$f":"IF(SCORES!D30>SCORES!E30,1,0)","v":0},{"$f":"IF(SCORES!E30>SCORES!D30,1,0)","v":0},{"$f":"IF(SCORES!F30>SCORES!G30,1,0)","v":0},{"$f":"IF(SCORES!G30>SCORES!F30,1,0)","v":0},{"$f":"IF(SCORES!H30>SCORES!I30,1,0)","v":0},{"$f":"IF(SCORES!I30>SCORES!H30,1,0)","v":0},{"$f":"IF(SCORES!J30>SCORES!K30,1,0)","v":0},{"$f":"IF(SCORES!K30>SCORES!J30,1,0)","v":0},{"$f":"IF(SCORES!L30>SCORES!M30,1,0)","v":0},{"$f":"IF(SCORES!M30>SCORES!L30,1,0)","v":0},{"$f":"IF(SCORES!N30>SCORES!O30,1,0)","v":0},{"$f":"IF(SCORES!O30>SCORES!N30,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,35,"A",{"$f":"SCORES!H74","v":0},{"$f":"SCORES!I74","v":0},{"$f":"SCORES!J74","v":0},"M12","Loser M8 refs"," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M8","Loser M4 refs","4th place Pool C",{"$f":"IF(STANDINGS!$J$26=4,STANDINGS!$B$26,IF(STANDINGS!$J$27=4,STANDINGS!$B$27,IF(STANDINGS!$J$28=4,STANDINGS!$B$28,IF(STANDINGS!$J$29=4,STANDINGS!$B$29,\" \"))))","v":" "},"M12","Loser M8 refs",null,{"$f":"IF(($AC33>$AC34)*AND($AD33>$AD34), BW33, IF(($AC33<$AC34)*AND($AD33<$AD34), BW34, IF($AE33>$AE34, BW33, IF($AE33<$AE34, BW34, 0))))","v":0}]
["Set Total",{"$f":"SUM(B33:B37)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"B",{"$f":"SCORES!H75","v":0},{"$f":"SCORES!I75","v":0},{"$f":"SCORES!J75","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,{"$f":"IF(($AC35>$AC36)*AND($AD35>$AD36), BS35, IF(($AC35<$AC36)*AND($AD35<$AD36), BS36, IF($AE35>$AE36, BS35, IF($AE35<$AE36, BS36, 0))))","v":0},null,null,null,{"$f":"IF(($AC35>$AC36)*AND($AD35>$AD36), BW35, IF(($AC35<$AC36)*AND($AD35<$AD36), BW36, IF($AE35>$AE36, BW35, IF($AE35<$AE36, BW36, 0))))","v":0}]
["Score Total",{"$f":"SUM(SCORES!D26:D30)","v":0},{"$f":"SUM(SCORES!E26:E30)","v":0},{"$f":"SUM(SCORES!F26:F30)","v":0},{"$f":"SUM(SCORES!G26:G30)","v":0},{"$f":"SUM(SCORES!H26:H30)","v":0},{"$f":"SUM(SCORES!I26:I30)","v":0},{"$f":"SUM(SCORES!J26:J30)","v":0},{"$f":"SUM(SCORES!K26:K30)","v":0},{"$f":"SUM(SCORES!L26:L30)","v":0},{"$f":"SUM(SCORES!M26:M30)","v":0},{"$f":"SUM(SCORES!N26:N30)","v":0},{"$f":"SUM(SCORES!O26:O30)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,37,"CHAMP",null,null,null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,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(($AC37>$AC38)*AND($AD37>$AD38), BS37, IF(($AC37<$AC38)*AND($AD37<$AD38), BS38, IF($AE37>$AE38, BS37, IF($AE37<$AE38, BS38, 0))))","v":0},null,null,null,{"$f":"IF(($AC37>$AC38)*AND($AD37>$AD38), BW37, IF(($AC37<$AC38)*AND($AD37<$AD38), BW38, IF($AE37>$AE38, BW37, IF($AE37<$AE38, BW38, 0))))","v":0}]
["Match",{"$f":"IF((B38>0)*AND(B38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((C38>0)*AND(C38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((D38>0)*AND(D38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((E38>0)*AND(E38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((F38>0)*AND(F38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((G38>0)*AND(G38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((H38>0)*AND(H38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((I38>0)*AND(I38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((J38>0)*AND(J38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((K38>0)*AND(K38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((L38>0)*AND(L38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0},{"$f":"IF((M38>0)*AND(M38=HLOOKUP(CALCS!$AF$1,CALCS!$B$139:$I$143,5,FALSE)),1,0)","v":0}]
[]
[]
[]
["Team","FINISHED","Match %","Set%","Point\nDiff","2-way Tie","2-way tie \nadjust%","Match Adjust","Adjusted\nMatch %","Set Adjust","Adjusted\nSet %","Points Adjust","Adjusted\nPoints","Coin Adjust","Fully Adjusted","RANK"]
[{"$f":"STANDINGS!B4","v":"<team>"},{"$f":"IF((SETUP!$H$13>0)*AND(B10+C10+F10+G10+L10+M10=SETUP!$H$13),1,0)","v":0},{"$f":"IF($A45=\" \",-1,STANDINGS!G4)","v":0},{"$f":"IF($B45=1,STANDINGS!H4,0)","v":0},{"$f":"IF($B45=1,STANDINGS!I4,0)","v":0},{"$f":"IF((C45=C46)*AND(C45<>C47)*AND(C45<>C48),IF(L10=1,1,0), IF((C45=C47)*AND(C45<>C46)*AND(C45<>C48),IF(B10=1,1,0),IF((C45=C48)*AND(C45<>C47)*AND(C45<>C46),IF(F10=1,1,0),0)))","v":0},{"$f":"C45+(F45/100)","v":0},{"$f":"RANK(G45,G$45:G$48,0)*-1","v":-1},{"$f":"C45+(H45/1000)","v":-1E-3},{"$f":"RANK(D45,D$45:D$48,0)*-1","v":-1},{"$f":"I45+(J45/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E45,E$45:E$48,0)*-1","v":-1},{"$f":"K45+(L45/100000)","v":-1.1100000000000001E-3},{"$f":"SCORES!D10+SCORES!H10+SCORES!N10","v":0},{"$f":"M45+(N45/1000000)","v":-1.1100000000000001E-3},{"$f":"IF((B45=1)*AND(B10+C10+F10+G10+L10+M10=SETUP!H$13),RANK(O45,O$45:O$48,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B5","v":"<team>"},{"$f":"IF((SETUP!$H$13>0)*AND(D10+E10+H10+I10+L10+M10=SETUP!$H$13),1,0)","v":0},{"$f":"IF($A46=\" \",-1,STANDINGS!G5)","v":0},{"$f":"IF($B46=1,STANDINGS!H5,0)","v":0},{"$f":"IF($B46=1,STANDINGS!I5,0)","v":0},{"$f":"IF((C46=C45)*AND(C46<>C47)*AND(C46<>C48),IF(M10=1,1,0), IF((C46=C47)*AND(C46<>C45)*AND(C46<>C48),IF(H10=1,1,0),IF((C46=C48)*AND(C46<>C47)*AND(C46<>C45),IF(D10=1,1,0),0)))","v":0},{"$f":"C46+(F46/100)","v":0},{"$f":"RANK(G46,G$45:G$48,0)*-1","v":-1},{"$f":"C46+(H46/1000)","v":-1E-3},{"$f":"RANK(D46,D$45:D$48,0)*-1","v":-1},{"$f":"I46+(J46/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E46,E$45:E$48,0)*-1","v":-1},{"$f":"K46+(L46/100000)","v":-1.1100000000000001E-3},{"$f":"SCORES!F10+SCORES!J10+SCORES!O10","v":0},{"$f":"M46+(N46/1000000)","v":-1.1100000000000001E-3},{"$f":"IF((B46=1)*AND(D10+E10+H10+I10+L10+M10=SETUP!H$13),RANK(O46,O$45:O$48,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B6","v":"<team>"},{"$f":"IF((SETUP!$H$13>0)*AND(B10+C10+H10+I10+J10+K10=SETUP!$H$13),1,0)","v":0},{"$f":"IF($A47=\" \",-1,STANDINGS!G6)","v":0},{"$f":"IF($B47=1,STANDINGS!H6,0)","v":0},{"$f":"IF($B47=1,STANDINGS!I6,0)","v":0},{"$f":"IF((C47=C45)*AND(C47<>C46)*AND(C47<>C48),IF(C10=1,1,0), IF((C47=C46)*AND(C47<>C45)*AND(C47<>C48),IF(I10=1,1,0),IF((C47=C48)*AND(C47<>C46)*AND(C47<>C45),IF(J10=1,1,0),0)))","v":0},0,{"$f":"RANK(G47,G$45:G$48,0)*-1","v":-1},{"$f":"C47+(H47/1000)","v":-1E-3},{"$f":"RANK(D47,D$45:D$48,0)*-1","v":-1},{"$f":"I47+(J47/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E47,E$45:E$48,0)*-1","v":-1},-1.1100000000000001E-3,{"$f":"SCORES!E10+SCORES!K10+SCORES!L10","v":0},-1.1100000000000001E-3,{"$f":"IF((B47=1)*AND(B10+C10+H10+I10+J10+K10=SETUP!H$13),RANK(O47,O$45:O$48,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B7","v":"<team>"},{"$f":"IF((SETUP!$H$13>0)*AND(D10+E10+F10+G10+J10+K10=SETUP!$H$13),1,0)","v":0},{"$f":"IF($A48=\" \",-1,STANDINGS!G7)","v":0},{"$f":"IF($B48=1,STANDINGS!H7,0)","v":0},{"$f":"IF($B48=1,STANDINGS!I7,0)","v":0},{"$f":"IF((C48=C45)*AND(C48<>C46)*AND(C48<>C47),IF(G10=1,1,0), IF((C48=C46)*AND(C48<>C45)*AND(C48<>C47),IF(E10=1,1,0),IF((C48=C47)*AND(C48<>C46)*AND(C48<>C45),IF(K10=1,1,0),0)))","v":0},0,{"$f":"RANK(G48,G$45:G$48,0)*-1","v":-1},{"$f":"C48+(H48/1000)","v":-1E-3},{"$f":"RANK(D48,D$45:D$48,0)*-1","v":-1},{"$f":"I48+(J48/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E48,E$45:E$48,0)*-1","v":-1},-1.1100000000000001E-3,{"$f":"SCORES!G10+SCORES!I10+SCORES!M10","v":0},-1.1100000000000001E-3,{"$f":"IF((B48=1)*AND(D10+E10+F10+G10+J10+K10=SETUP!H$13),RANK(O48,O$45:O$48,0),\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[{"$f":"STANDINGS!B15","v":"<team>"},{"$f":"IF((SETUP!$H$18>0)*AND(B20+C20+F20+G20+L20+M20=SETUP!$H$18),1,0)","v":0},{"$f":"IF($A55=\" \",-1,STANDINGS!G15)","v":0},{"$f":"IF($B55=1,STANDINGS!H15,0)","v":0},{"$f":"IF(B55=1,STANDINGS!I15,0)","v":0},{"$f":"IF((C55=C56)*AND(C55<>C57)*AND(C55<>C58),IF(L20=1,1,0), IF((C55=C57)*AND(C55<>C56)*AND(C55<>C58),IF(B20=1,1,0),IF((C55=C58)*AND(C55<>C57)*AND(C55<>C56),IF(F20=1,1,0),0)))","v":0},{"$f":"C55+(F55/100)","v":0},{"$f":"RANK(G55,G$55:G$58,0)*-1","v":-1},{"$f":"C55+(H55/1000)","v":-1E-3},{"$f":"RANK(D55,D$55:D$58,0)*-1","v":-1},{"$f":"I55+(J55/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E55,E$55:E$58,0)*-1","v":-1},{"$f":"K55+(L55/100000)","v":-1.1100000000000001E-3},{"$f":"SCORES!D17+SCORES!H17+SCORES!N17","v":0},{"$f":"M55+(N55/1000000)","v":-1.1100000000000001E-3},{"$f":"IF((B55=1)*AND(B20+C20+F20+G20+L20+M20=SETUP!H$18),RANK(O55,O$55:O$58,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B16","v":"<team>"},{"$f":"IF((SETUP!$H$18>0)*AND(D20+E20+H20+I20+L20+M20=SETUP!$H$18),1,0)","v":0},{"$f":"IF($A56=\" \",-1,STANDINGS!G16)","v":0},{"$f":"IF($B56=1,STANDINGS!H16,0)","v":0},{"$f":"IF(B56=1,STANDINGS!I16,0)","v":0},{"$f":"IF((C56=C55)*AND(C56<>C57)*AND(C56<>C58),IF(M20=1,1,0), IF((C56=C57)*AND(C56<>C55)*AND(C56<>C58),IF(H20=1,1,0),IF((C56=C58)*AND(C56<>C57)*AND(C56<>C55),IF(D20=1,1,0),0)))","v":0},{"$f":"C56+(F56/100)","v":0},{"$f":"RANK(G56,G$55:G$58,0)*-1","v":-1},{"$f":"C56+(H56/1000)","v":-1E-3},{"$f":"RANK(D56,D$55:D$58,0)*-1","v":-1},{"$f":"I56+(J56/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E56,E$55:E$58,0)*-1","v":-1},{"$f":"K56+(L56/100000)","v":-1.1100000000000001E-3},{"$f":"SCORES!F17+SCORES!J17+SCORES!O17","v":0},-1.1100000000000001E-3,{"$f":"IF((B56=1)*AND(D20+E20+H20+I20+L20+M20=SETUP!H$18),RANK(O56,O$55:O$58,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B17","v":"<team>"},{"$f":"IF((SETUP!$H$18>0)*AND(B20+C20+H20+I20+J20+K20=SETUP!$H$18),1,0)","v":0},{"$f":"IF($A57=\" \",-1,STANDINGS!G17)","v":0},{"$f":"IF($B57=1,STANDINGS!H17,0)","v":0},{"$f":"IF(B57=1,STANDINGS!I17,0)","v":0},{"$f":"IF((C57=C55)*AND(C57<>C56)*AND(C57<>C58),IF(C20=1,1,0), IF((C57=C56)*AND(C57<>C55)*AND(C57<>C58),IF(I20=1,1,0),IF((C57=C58)*AND(C57<>C56)*AND(C57<>C55),IF(J20=1,1,0),0)))","v":0},0,{"$f":"RANK(G57,G$55:G$58,0)*-1","v":-1},{"$f":"C57+(H57/1000)","v":-1E-3},{"$f":"RANK(D57,D$55:D$58,0)*-1","v":-1},{"$f":"I57+(J57/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E57,E$55:E$58,0)*-1","v":-1},-1.1100000000000001E-3,{"$f":"SCORES!E17+SCORES!K17+SCORES!L17","v":0},-1.1100000000000001E-3,{"$f":"IF((B57=1)*AND(B20+C20+H20+I20+J20+K20=SETUP!H$18),RANK(O57,O$55:O$58,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B18","v":"<team>"},{"$f":"IF((SETUP!$H$18>0)*AND(D20+E20+F20+G20+J20+K20=SETUP!$H$18),1,0)","v":0},{"$f":"IF($A58=\" \",-1,STANDINGS!G18)","v":0},{"$f":"IF($B58=1,STANDINGS!H18,0)","v":0},{"$f":"IF(B58=1,STANDINGS!I18,0)","v":0},{"$f":"IF((C58=C55)*AND(C58<>C56)*AND(C58<>C57),IF(G20=1,1,0), IF((C58=C56)*AND(C58<>C55)*AND(C58<>C57),IF(E20=1,1,0),IF((C58=C57)*AND(C58<>C56)*AND(C58<>C55),IF(K20=1,1,0),0)))","v":0},0,{"$f":"RANK(G58,G$55:G$58,0)*-1","v":-1},{"$f":"C58+(H58/1000)","v":-1E-3},{"$f":"RANK(D58,D$55:D$58,0)*-1","v":-1},{"$f":"I58+(J58/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E58,E$55:E$58,0)*-1","v":-1},-1.1100000000000001E-3,{"$f":"SCORES!G17+SCORES!I17+SCORES!M17","v":0},-1.1100000000000001E-3,{"$f":"IF((B58=1)*AND(D20+E20+F20+G20+J20+K20=SETUP!H$18),RANK(O58,O$55:O$58,0),\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[{"$f":"STANDINGS!B26","v":"<team>"},{"$f":"IF((SETUP!$H$23>0)*AND(B30+C30+F30+G30+L30+M30=SETUP!$H$23),1,0)","v":0},{"$f":"IF($A65=\" \",-1,STANDINGS!G26)","v":0},{"$f":"IF($B65=1,STANDINGS!H26,0)","v":0},{"$f":"IF(B65=1, STANDINGS!I26, 0)","v":0},{"$f":"IF((C65=C66)*AND(C65<>C67)*AND(C65<>C68),IF(L30=1,1,0), IF((C65=C67)*AND(C65<>C66)*AND(C65<>C68),IF(B30=1,1,0),IF((C65=C68)*AND(C65<>C67)*AND(C65<>C66),IF(F30=1,1,0),0)))","v":0},{"$f":"C65+(F65/100)","v":0},{"$f":"RANK(G65,G$65:G$68,0)*-1","v":-1},{"$f":"C65+(H65/1000)","v":-1E-3},{"$f":"RANK(D65,D$65:D$68,0)*-1","v":-1},{"$f":"I65+(J65/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E65,E$65:E$68,0)*-1","v":-1},{"$f":"K65+(L65/100000)","v":-1.1100000000000001E-3},{"$f":"SCORES!D24+SCORES!H24+SCORES!N24","v":0},{"$f":"M65+(N65/1000000)","v":-1.1100000000000001E-3},{"$f":"IF((B65=1)*AND(B30+C30+F30+G30+L30+M30=SETUP!H$23),RANK(O65,O$65:O$68,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B27","v":"<team>"},{"$f":"IF((SETUP!$H$23>0)*AND(D30+E30+H30+I30+L30+M30=SETUP!$H$23),1,0)","v":0},{"$f":"IF($A66=\" \",-1,STANDINGS!G27)","v":0},{"$f":"IF($B66=1,STANDINGS!H27,0)","v":0},{"$f":"IF(B66=1, STANDINGS!I27, 0)","v":0},{"$f":"IF((C66=C65)*AND(C66<>C67)*AND(C66<>C68),IF(M30=1,1,0), IF((C66=C67)*AND(C66<>C65)*AND(C66<>C68),IF(H30=1,1,0),IF((C66=C68)*AND(C66<>C67)*AND(C66<>C65),IF(D30=1,1,0),0)))","v":0},{"$f":"C66+(F66/100)","v":0},{"$f":"RANK(G66,G$65:G$68,0)*-1","v":-1},{"$f":"C66+(H66/1000)","v":-1E-3},{"$f":"RANK(D66,D$65:D$68,0)*-1","v":-1},{"$f":"I66+(J66/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E66,E$65:E$68,0)*-1","v":-1},{"$f":"K66+(L66/100000)","v":-1.1100000000000001E-3},{"$f":"SCORES!F24+SCORES!J24+SCORES!O24","v":0},-1.1100000000000001E-3,{"$f":"IF((B66=1)*AND(D30+E30+H30+I30+L30+M30=SETUP!H$23),RANK(O66,O$65:O$68,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B28","v":"<team>"},{"$f":"IF((SETUP!$H$23>0)*AND(B30+C30+H30+I30+J30+K30=SETUP!$H$23),1,0)","v":0},{"$f":"IF($A67=\" \",-1,STANDINGS!G28)","v":0},{"$f":"IF($B67=1,STANDINGS!H28,0)","v":0},{"$f":"IF(B67=1, STANDINGS!I28, 0)","v":0},{"$f":"IF((C67=C65)*AND(C67<>C66)*AND(C67<>C68),IF(C30=1,1,0), IF((C67=C66)*AND(C67<>C65)*AND(C67<>C68),IF(I30=1,1,0),IF((C67=C68)*AND(C67<>C66)*AND(C67<>C65),IF(J30=1,1,0),0)))","v":0},0,{"$f":"RANK(G67,G$65:G$68,0)*-1","v":-1},{"$f":"C67+(H67/1000)","v":-1E-3},{"$f":"RANK(D67,D$65:D$68,0)*-1","v":-1},{"$f":"I67+(J67/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E67,E$65:E$68,0)*-1","v":-1},-1.1100000000000001E-3,{"$f":"SCORES!E24+SCORES!K24+SCORES!L24","v":0},-1.1100000000000001E-3,{"$f":"IF((B67=1)*AND(B30+C30+H30+I30+J30+K30=SETUP!H$23),RANK(O67,O$65:O$68,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B29","v":"<team>"},{"$f":"IF((SETUP!$H$23>0)*AND(D30+E30+F30+G30+J30+K30=SETUP!$H$23),1,0)","v":0},{"$f":"IF($A68=\" \",-1,STANDINGS!G29)","v":0},{"$f":"IF($B68=1,STANDINGS!H29,0)","v":0},{"$f":"IF(B68=1, STANDINGS!I29, 0)","v":0},{"$f":"IF((C68=C65)*AND(C68<>C66)*AND(C68<>C67),IF(G30=1,1,0), IF((C68=C66)*AND(C68<>C65)*AND(C68<>C67),IF(E30=1,1,0),IF((C68=C67)*AND(C68<>C66)*AND(C68<>C65),IF(K30=1,1,0),0)))","v":0},0,{"$f":"RANK(G68,G$65:G$68,0)*-1","v":-1},{"$f":"C68+(H68/1000)","v":-1E-3},{"$f":"RANK(D68,D$65:D$68,0)*-1","v":-1},{"$f":"I68+(J68/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E68,E$65:E$68,0)*-1","v":-1},-1.1100000000000001E-3,{"$f":"SCORES!G24+SCORES!I24+SCORES!M24","v":0},-1.1100000000000001E-3,{"$f":"IF((B68=1)*AND(D30+E30+F30+G30+J30+K30=SETUP!H$23),RANK(O68,O$65:O$68,0),\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[{"$f":"STANDINGS!B37","v":"<team>"},{"$f":"IF((SETUP!$H$28>0)*AND(B40+C40+F40+G40+L40+M40=SETUP!$H$28),1,0)","v":0},{"$f":"IF($A75=\" \",-1,STANDINGS!G37)","v":0},{"$f":"IF($B75=1,STANDINGS!H37,0)","v":0},{"$f":"IF(B75=1,STANDINGS!I37,0)","v":0},{"$f":"IF((C75=C76)*AND(C75<>C77)*AND(C75<>C78),IF(L40=1,1,0), IF((C75=C77)*AND(C75<>C76)*AND(C75<>C78),IF(B40=1,1,0),IF((C75=C78)*AND(C75<>C77)*AND(C75<>C76),IF(F40=1,1,0),0)))","v":0},{"$f":"C75+(F75/100)","v":0},{"$f":"RANK(G75,G$75:G$78,0)*-1","v":-1},{"$f":"C75+(H75/1000)","v":-1E-3},{"$f":"RANK(D75,D$75:D$78,0)*-1","v":-1},{"$f":"I75+(J75/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E75,E$75:E$78,0)*-1","v":-1},{"$f":"K75+(L75/100000)","v":-1.1100000000000001E-3},{"$f":"SCORES!D31+SCORES!H31+SCORES!N31","v":0},{"$f":"M75+(N75/1000000)","v":-1.1100000000000001E-3},{"$f":"IF((B75=1)*AND(B40+C40+F40+G40+L40+M40=SETUP!H$28),RANK(O75,O$75:O$78,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B38","v":"<team>"},{"$f":"IF((SETUP!$H$28>0)*AND(D40+E40+H40+I40+L40+M40=SETUP!$H$28),1,0)","v":0},{"$f":"IF($A76=\" \",-1,STANDINGS!G38)","v":0},{"$f":"IF($B76=1,STANDINGS!H38,0)","v":0},{"$f":"IF(B76=1,STANDINGS!I38,0)","v":0},{"$f":"IF((C76=C75)*AND(C76<>C77)*AND(C76<>C78),IF(M40=1,1,0), IF((C76=C77)*AND(C76<>C75)*AND(C76<>C78),IF(H40=1,1,0),IF((C76=C78)*AND(C76<>C77)*AND(C76<>C75),IF(D40=1,1,0),0)))","v":0},{"$f":"C76+(F76/100)","v":0},{"$f":"RANK(G76,G$75:G$78,0)*-1","v":-1},{"$f":"C76+(H76/1000)","v":-1E-3},{"$f":"RANK(D76,D$75:D$78,0)*-1","v":-1},{"$f":"I76+(J76/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E76,E$75:E$78,0)*-1","v":-1},{"$f":"K76+(L76/100000)","v":-1.1100000000000001E-3},{"$f":"SCORES!F31+SCORES!J31+SCORES!O31","v":0},-1.1100000000000001E-3,{"$f":"IF((B76=1)*AND(D40+E40+H40+I40+L40+M40=SETUP!H$28),RANK(O76,O$75:O$78,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B39","v":"<team>"},{"$f":"IF((SETUP!$H$28>0)*AND(B40+C40+H40+I40+J40+K40=SETUP!$H$28),1,0)","v":0},{"$f":"IF($A77=\" \",-1,STANDINGS!G39)","v":0},{"$f":"IF($B77=1,STANDINGS!H39,0)","v":0},{"$f":"IF(B77=1,STANDINGS!I39,0)","v":0},{"$f":"IF((C77=C75)*AND(C77<>C76)*AND(C77<>C78),IF(C40=1,1,0), IF((C77=C76)*AND(C77<>C75)*AND(C77<>C78),IF(I40=1,1,0),IF((C77=C78)*AND(C77<>C76)*AND(C77<>C75),IF(J40=1,1,0),0)))","v":0},0,{"$f":"RANK(G77,G$75:G$78,0)*-1","v":-1},{"$f":"C77+(H77/1000)","v":-1E-3},{"$f":"RANK(D77,D$75:D$78,0)*-1","v":-1},{"$f":"I77+(J77/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E77,E$75:E$78,0)*-1","v":-1},-1.1100000000000001E-3,{"$f":"SCORES!E31+SCORES!K31+SCORES!L31","v":0},-1.1100000000000001E-3,{"$f":"IF((B77=1)*AND(B40+C40+H40+I40+J40+K40=SETUP!H$28),RANK(O77,O$75:O$78,0),\" \")","v":" "}]
[{"$f":"STANDINGS!B40","v":"<team>"},{"$f":"IF((SETUP!$H$28>0)*AND(D40+E40+F40+G40+J40+K40=SETUP!$H$28),1,0)","v":0},{"$f":"IF($A78=\" \",-1,STANDINGS!G40)","v":0},{"$f":"IF($B78=1,STANDINGS!H40,0)","v":0},{"$f":"IF(B78=1,STANDINGS!I40,0)","v":0},{"$f":"IF((C78=C75)*AND(C78<>C76)*AND(C78<>C77),IF(G40=1,1,0), IF((C78=C76)*AND(C78<>C75)*AND(C78<>C77),IF(E40=1,1,0),IF((C78=C77)*AND(C78<>C76)*AND(C78<>C75),IF(K40=1,1,0),0)))","v":0},0,{"$f":"RANK(G78,G$75:G$78,0)*-1","v":-1},{"$f":"C78+(H78/1000)","v":-1E-3},{"$f":"RANK(D78,D$75:D$78,0)*-1","v":-1},{"$f":"I78+(J78/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(E78,E$75:E$78,0)*-1","v":-1},-1.1100000000000001E-3,{"$f":"SCORES!G31+SCORES!I31+SCORES!M31","v":0},-1.1100000000000001E-3,{"$f":"IF((B78=1)*AND(D40+E40+F40+G40+J40+K40=SETUP!H$28),RANK(O78,O$75:O$78,0),\" \")","v":" "}]
[]
[]
["3RD PLACE TEAM SORT ORDER (11 and 12 Team Formats Only)"]
[]
["FINISH","Pool Finish Order","Match %","Set%","Point\nDiff"]
[1,{"$f":"IF((STANDINGS!J4=A84),STANDINGS!B4,IF((STANDINGS!J5=A84),STANDINGS!B5,IF((STANDINGS!J6=A84),STANDINGS!B6,IF((STANDINGS!J7=A84),STANDINGS!B7,0))))","v":0},{"$f":"IF((STANDINGS!$J4=$A84),STANDINGS!G4,IF((STANDINGS!$J5=$A84),STANDINGS!G5,IF((STANDINGS!$J6=$A84),STANDINGS!G6,IF((STANDINGS!$J7=$A84),STANDINGS!G7,0))))","v":0},{"$f":"IF((STANDINGS!$J4=$A84),STANDINGS!H4,IF((STANDINGS!$J5=$A84),STANDINGS!H5,IF((STANDINGS!$J6=$A84),STANDINGS!H6,IF((STANDINGS!$J7=$A84),STANDINGS!H7,0))))","v":0},{"$f":"IF((STANDINGS!$J4=$A84),STANDINGS!I4,IF((STANDINGS!$J5=$A84),STANDINGS!I5,IF((STANDINGS!$J6=$A84),STANDINGS!I6,IF((STANDINGS!$J7=$A84),STANDINGS!I7,0))))","v":0}]
[2,{"$f":"IF((STANDINGS!J5=A85),STANDINGS!B5,IF((STANDINGS!J6=A85),STANDINGS!B6,IF((STANDINGS!J7=A85),STANDINGS!B7,IF((STANDINGS!J8=A85),STANDINGS!B8,0))))","v":0},{"$f":"IF((STANDINGS!$J5=$A85),STANDINGS!G5,IF((STANDINGS!$J6=$A85),STANDINGS!G6,IF((STANDINGS!$J7=$A85),STANDINGS!G7,IF((STANDINGS!$J8=$A85),STANDINGS!G8,0))))","v":0},{"$f":"IF((STANDINGS!$J5=$A85),STANDINGS!H5,IF((STANDINGS!$J6=$A85),STANDINGS!H6,IF((STANDINGS!$J7=$A85),STANDINGS!H7,IF((STANDINGS!$J8=$A85),STANDINGS!H8,0))))","v":0},{"$f":"IF((STANDINGS!$J5=$A85),STANDINGS!I5,IF((STANDINGS!$J6=$A85),STANDINGS!I6,IF((STANDINGS!$J7=$A85),STANDINGS!I7,IF((STANDINGS!$J8=$A85),STANDINGS!I8,0))))","v":0}]
[3,{"$f":"IF((STANDINGS!J6=A86),STANDINGS!B6,IF((STANDINGS!J7=A86),STANDINGS!B7,IF((STANDINGS!J8=A86),STANDINGS!B8,IF((STANDINGS!J9=A86),STANDINGS!B9,0))))","v":0},{"$f":"IF((STANDINGS!$J6=$A86),STANDINGS!G6,IF((STANDINGS!$J7=$A86),STANDINGS!G7,IF((STANDINGS!$J8=$A86),STANDINGS!G8,IF((STANDINGS!$J9=$A86),STANDINGS!G9,0))))","v":0},{"$f":"IF((STANDINGS!$J6=$A86),STANDINGS!H6,IF((STANDINGS!$J7=$A86),STANDINGS!H7,IF((STANDINGS!$J8=$A86),STANDINGS!H8,IF((STANDINGS!$J9=$A86),STANDINGS!H9,0))))","v":0},{"$f":"IF((STANDINGS!$J6=$A86),STANDINGS!I6,IF((STANDINGS!$J7=$A86),STANDINGS!I7,IF((STANDINGS!$J8=$A86),STANDINGS!I8,IF((STANDINGS!$J9=$A86),STANDINGS!I9,0))))","v":0}]
[4,{"$f":"IF((STANDINGS!J7=A87),STANDINGS!B7,IF((STANDINGS!J8=A87),STANDINGS!B8,IF((STANDINGS!J9=A87),STANDINGS!B9,IF((STANDINGS!J10=A87),STANDINGS!B10,0))))","v":0},{"$f":"IF((STANDINGS!$J7=$A87),STANDINGS!G7,IF((STANDINGS!$J8=$A87),STANDINGS!G8,IF((STANDINGS!$J9=$A87),STANDINGS!G9,IF((STANDINGS!$J10=$A87),STANDINGS!G10,0))))","v":0},{"$f":"IF((STANDINGS!$J7=$A87),STANDINGS!H7,IF((STANDINGS!$J8=$A87),STANDINGS!H8,IF((STANDINGS!$J9=$A87),STANDINGS!H9,IF((STANDINGS!$J10=$A87),STANDINGS!H10,0))))","v":0},{"$f":"IF((STANDINGS!$J7=$A87),STANDINGS!I7,IF((STANDINGS!$J8=$A87),STANDINGS!I8,IF((STANDINGS!$J9=$A87),STANDINGS!I9,IF((STANDINGS!$J10=$A87),STANDINGS!I10,0))))","v":0}]
[]
[]
[]
[]
[]
[]
[1,{"$f":"IF((STANDINGS!J14=A94),STANDINGS!B14,IF((STANDINGS!J15=A94),STANDINGS!B15,IF((STANDINGS!J16=A94),STANDINGS!B16,IF((STANDINGS!J17=A94),STANDINGS!B17,0))))","v":0},{"$f":"IF((STANDINGS!$J14=$A94),STANDINGS!G14,IF((STANDINGS!$J15=$A94),STANDINGS!G15,IF((STANDINGS!$J16=$A94),STANDINGS!G16,IF((STANDINGS!$J17=$A94),STANDINGS!G17,0))))","v":0},{"$f":"IF((STANDINGS!$J14=$A94),STANDINGS!H14,IF((STANDINGS!$J15=$A94),STANDINGS!H15,IF((STANDINGS!$J16=$A94),STANDINGS!H16,IF((STANDINGS!$J17=$A94),STANDINGS!H17,0))))","v":0},{"$f":"IF((STANDINGS!$J14=$A94),STANDINGS!I14,IF((STANDINGS!$J15=$A94),STANDINGS!I15,IF((STANDINGS!$J16=$A94),STANDINGS!I16,IF((STANDINGS!$J17=$A94),STANDINGS!I17,0))))","v":0}]
[2,{"$f":"IF((STANDINGS!J15=A95),STANDINGS!B15,IF((STANDINGS!J16=A95),STANDINGS!B16,IF((STANDINGS!J17=A95),STANDINGS!B17,IF((STANDINGS!J18=A95),STANDINGS!B18,0))))","v":0},{"$f":"IF((STANDINGS!$J15=$A95),STANDINGS!G15,IF((STANDINGS!$J16=$A95),STANDINGS!G16,IF((STANDINGS!$J17=$A95),STANDINGS!G17,IF((STANDINGS!$J18=$A95),STANDINGS!G18,0))))","v":0},{"$f":"IF((STANDINGS!$J15=$A95),STANDINGS!H15,IF((STANDINGS!$J16=$A95),STANDINGS!H16,IF((STANDINGS!$J17=$A95),STANDINGS!H17,IF((STANDINGS!$J18=$A95),STANDINGS!H18,0))))","v":0},{"$f":"IF((STANDINGS!$J15=$A95),STANDINGS!I15,IF((STANDINGS!$J16=$A95),STANDINGS!I16,IF((STANDINGS!$J17=$A95),STANDINGS!I17,IF((STANDINGS!$J18=$A95),STANDINGS!I18,0))))","v":0}]
[3,{"$f":"IF((STANDINGS!J16=A96),STANDINGS!B16,IF((STANDINGS!J17=A96),STANDINGS!B17,IF((STANDINGS!J18=A96),STANDINGS!B18,IF((STANDINGS!J19=A96),STANDINGS!B19,0))))","v":0},{"$f":"IF((STANDINGS!$J16=$A96),STANDINGS!G16,IF((STANDINGS!$J17=$A96),STANDINGS!G17,IF((STANDINGS!$J18=$A96),STANDINGS!G18,IF((STANDINGS!$J19=$A96),STANDINGS!G19,0))))","v":0},{"$f":"IF((STANDINGS!$J16=$A96),STANDINGS!H16,IF((STANDINGS!$J17=$A96),STANDINGS!H17,IF((STANDINGS!$J18=$A96),STANDINGS!H18,IF((STANDINGS!$J19=$A96),STANDINGS!H19,0))))","v":0},{"$f":"IF((STANDINGS!$J16=$A96),STANDINGS!I16,IF((STANDINGS!$J17=$A96),STANDINGS!I17,IF((STANDINGS!$J18=$A96),STANDINGS!I18,IF((STANDINGS!$J19=$A96),STANDINGS!I19,0))))","v":0}]
[4,{"$f":"IF((STANDINGS!J17=A97),STANDINGS!B17,IF((STANDINGS!J18=A97),STANDINGS!B18,IF((STANDINGS!J19=A97),STANDINGS!B19,IF((STANDINGS!J20=A97),STANDINGS!B20,0))))","v":0},{"$f":"IF((STANDINGS!$J17=$A97),STANDINGS!G17,IF((STANDINGS!$J18=$A97),STANDINGS!G18,IF((STANDINGS!$J19=$A97),STANDINGS!G19,IF((STANDINGS!$J20=$A97),STANDINGS!G20,0))))","v":0},{"$f":"IF((STANDINGS!$J17=$A97),STANDINGS!H17,IF((STANDINGS!$J18=$A97),STANDINGS!H18,IF((STANDINGS!$J19=$A97),STANDINGS!H19,IF((STANDINGS!$J20=$A97),STANDINGS!H20,0))))","v":0},{"$f":"IF((STANDINGS!$J17=$A97),STANDINGS!I17,IF((STANDINGS!$J18=$A97),STANDINGS!I18,IF((STANDINGS!$J19=$A97),STANDINGS!I19,IF((STANDINGS!$J20=$A97),STANDINGS!I20,0))))","v":0}]
[]
[]
[]
[]
[]
[]
[1,{"$f":"IF((STANDINGS!J24=A104),STANDINGS!B24,IF((STANDINGS!J25=A104),STANDINGS!B25,IF((STANDINGS!J26=A104),STANDINGS!B26,IF((STANDINGS!J27=A104),STANDINGS!B27,0))))","v":0},{"$f":"IF((STANDINGS!$J24=$A104),STANDINGS!G24,IF((STANDINGS!$J25=$A104),STANDINGS!G25,IF((STANDINGS!$J26=$A104),STANDINGS!G26,IF((STANDINGS!$J27=$A104),STANDINGS!G27,0))))","v":0},{"$f":"IF((STANDINGS!$J24=$A104),STANDINGS!H24,IF((STANDINGS!$J25=$A104),STANDINGS!H25,IF((STANDINGS!$J26=$A104),STANDINGS!H26,IF((STANDINGS!$J27=$A104),STANDINGS!H27,0))))","v":0},{"$f":"IF((STANDINGS!$J24=$A104),STANDINGS!I24,IF((STANDINGS!$J25=$A104),STANDINGS!I25,IF((STANDINGS!$J26=$A104),STANDINGS!I26,IF((STANDINGS!$J27=$A104),STANDINGS!I27,0))))","v":0}]
[2,{"$f":"IF((STANDINGS!J25=A105),STANDINGS!B25,IF((STANDINGS!J26=A105),STANDINGS!B26,IF((STANDINGS!J27=A105),STANDINGS!B27,IF((STANDINGS!J28=A105),STANDINGS!B28,0))))","v":0},{"$f":"IF((STANDINGS!$J25=$A105),STANDINGS!G25,IF((STANDINGS!$J26=$A105),STANDINGS!G26,IF((STANDINGS!$J27=$A105),STANDINGS!G27,IF((STANDINGS!$J28=$A105),STANDINGS!G28,0))))","v":0},{"$f":"IF((STANDINGS!$J25=$A105),STANDINGS!H25,IF((STANDINGS!$J26=$A105),STANDINGS!H26,IF((STANDINGS!$J27=$A105),STANDINGS!H27,IF((STANDINGS!$J28=$A105),STANDINGS!H28,0))))","v":0},{"$f":"IF((STANDINGS!$J25=$A105),STANDINGS!I25,IF((STANDINGS!$J26=$A105),STANDINGS!I26,IF((STANDINGS!$J27=$A105),STANDINGS!I27,IF((STANDINGS!$J28=$A105),STANDINGS!I28,0))))","v":0}]
[3,{"$f":"IF((STANDINGS!J26=A106),STANDINGS!B26,IF((STANDINGS!J27=A106),STANDINGS!B27,IF((STANDINGS!J28=A106),STANDINGS!B28,IF((STANDINGS!J29=A106),STANDINGS!B29,0))))","v":0},{"$f":"IF((STANDINGS!$J26=$A106),STANDINGS!G26,IF((STANDINGS!$J27=$A106),STANDINGS!G27,IF((STANDINGS!$J28=$A106),STANDINGS!G28,IF((STANDINGS!$J29=$A106),STANDINGS!G29,0))))","v":0},{"$f":"IF((STANDINGS!$J26=$A106),STANDINGS!H26,IF((STANDINGS!$J27=$A106),STANDINGS!H27,IF((STANDINGS!$J28=$A106),STANDINGS!H28,IF((STANDINGS!$J29=$A106),STANDINGS!H29,0))))","v":0},{"$f":"IF((STANDINGS!$J26=$A106),STANDINGS!I26,IF((STANDINGS!$J27=$A106),STANDINGS!I27,IF((STANDINGS!$J28=$A106),STANDINGS!I28,IF((STANDINGS!$J29=$A106),STANDINGS!I29,0))))","v":0}]
[4,{"$f":"IF((STANDINGS!J27=A107),STANDINGS!B27,IF((STANDINGS!J28=A107),STANDINGS!B28,IF((STANDINGS!J29=A107),STANDINGS!B29,IF((STANDINGS!J30=A107),STANDINGS!B30,0))))","v":0},{"$f":"IF((STANDINGS!$J27=$A107),STANDINGS!G27,IF((STANDINGS!$J28=$A107),STANDINGS!G28,IF((STANDINGS!$J29=$A107),STANDINGS!G29,IF((STANDINGS!$J30=$A107),STANDINGS!G30,0))))","v":0},{"$f":"IF((STANDINGS!$J27=$A107),STANDINGS!H27,IF((STANDINGS!$J28=$A107),STANDINGS!H28,IF((STANDINGS!$J29=$A107),STANDINGS!H29,IF((STANDINGS!$J30=$A107),STANDINGS!H30,0))))","v":0},{"$f":"IF((STANDINGS!$J27=$A107),STANDINGS!I27,IF((STANDINGS!$J28=$A107),STANDINGS!I28,IF((STANDINGS!$J29=$A107),STANDINGS!I29,IF((STANDINGS!$J30=$A107),STANDINGS!I30,0))))","v":0}]
[]
[]
[]
[]
[]
[]
[1,{"$f":"IF((STANDINGS!J34=A114),STANDINGS!B34,IF((STANDINGS!J35=A114),STANDINGS!B35,IF((STANDINGS!J36=A114),STANDINGS!B36,IF((STANDINGS!J37=A114),STANDINGS!B37,0))))","v":0},{"$f":"IF((STANDINGS!$J34=$A114),STANDINGS!G34,IF((STANDINGS!$J35=$A114),STANDINGS!G35,IF((STANDINGS!$J36=$A114),STANDINGS!G36,IF((STANDINGS!$J37=$A114),STANDINGS!G37,0))))","v":0},{"$f":"IF((STANDINGS!$J34=$A114),STANDINGS!H34,IF((STANDINGS!$J35=$A114),STANDINGS!H35,IF((STANDINGS!$J36=$A114),STANDINGS!H36,IF((STANDINGS!$J37=$A114),STANDINGS!H37,0))))","v":0},{"$f":"IF((STANDINGS!$J34=$A114),STANDINGS!I34,IF((STANDINGS!$J35=$A114),STANDINGS!I35,IF((STANDINGS!$J36=$A114),STANDINGS!I36,IF((STANDINGS!$J37=$A114),STANDINGS!I37,0))))","v":0}]
[2,{"$f":"IF((STANDINGS!J35=A115),STANDINGS!B35,IF((STANDINGS!J36=A115),STANDINGS!B36,IF((STANDINGS!J37=A115),STANDINGS!B37,IF((STANDINGS!J38=A115),STANDINGS!B38,0))))","v":0},{"$f":"IF((STANDINGS!$J35=$A115),STANDINGS!G35,IF((STANDINGS!$J36=$A115),STANDINGS!G36,IF((STANDINGS!$J37=$A115),STANDINGS!G37,IF((STANDINGS!$J38=$A115),STANDINGS!G38,0))))","v":0},{"$f":"IF((STANDINGS!$J35=$A115),STANDINGS!H35,IF((STANDINGS!$J36=$A115),STANDINGS!H36,IF((STANDINGS!$J37=$A115),STANDINGS!H37,IF((STANDINGS!$J38=$A115),STANDINGS!H38,0))))","v":0},{"$f":"IF((STANDINGS!$J35=$A115),STANDINGS!I35,IF((STANDINGS!$J36=$A115),STANDINGS!I36,IF((STANDINGS!$J37=$A115),STANDINGS!I37,IF((STANDINGS!$J38=$A115),STANDINGS!I38,0))))","v":0}]
[3,{"$f":"IF((STANDINGS!J36=A116),STANDINGS!B36,IF((STANDINGS!J37=A116),STANDINGS!B37,IF((STANDINGS!J38=A116),STANDINGS!B38,IF((STANDINGS!J39=A116),STANDINGS!B39,0))))","v":0},{"$f":"IF((STANDINGS!$J36=$A116),STANDINGS!G36,IF((STANDINGS!$J37=$A116),STANDINGS!G37,IF((STANDINGS!$J38=$A116),STANDINGS!G38,IF((STANDINGS!$J39=$A116),STANDINGS!G39,0))))","v":0},{"$f":"IF((STANDINGS!$J36=$A116),STANDINGS!H36,IF((STANDINGS!$J37=$A116),STANDINGS!H37,IF((STANDINGS!$J38=$A116),STANDINGS!H38,IF((STANDINGS!$J39=$A116),STANDINGS!H39,0))))","v":0},{"$f":"IF((STANDINGS!$J36=$A116),STANDINGS!I36,IF((STANDINGS!$J37=$A116),STANDINGS!I37,IF((STANDINGS!$J38=$A116),STANDINGS!I38,IF((STANDINGS!$J39=$A116),STANDINGS!I39,0))))","v":0}]
[4,{"$f":"IF((STANDINGS!J37=A117),STANDINGS!B37,IF((STANDINGS!J38=A117),STANDINGS!B38,IF((STANDINGS!J39=A117),STANDINGS!B39,IF((STANDINGS!J40=A117),STANDINGS!B40,0))))","v":0},{"$f":"IF((STANDINGS!$J37=$A117),STANDINGS!G37,IF((STANDINGS!$J38=$A117),STANDINGS!G38,IF((STANDINGS!$J39=$A117),STANDINGS!G39,IF((STANDINGS!$J40=$A117),STANDINGS!G40,0))))","v":0},{"$f":"IF((STANDINGS!$J37=$A117),STANDINGS!H37,IF((STANDINGS!$J38=$A117),STANDINGS!H38,IF((STANDINGS!$J39=$A117),STANDINGS!H39,IF((STANDINGS!$J40=$A117),STANDINGS!H40,0))))","v":0},{"$f":"IF((STANDINGS!$J37=$A117),STANDINGS!I37,IF((STANDINGS!$J38=$A117),STANDINGS!I38,IF((STANDINGS!$J39=$A117),STANDINGS!I39,IF((STANDINGS!$J40=$A117),STANDINGS!I40,0))))","v":0}]
[]
[null,null,null,"Match %","Set %","Point Diff","Match\nRank","Match Adjusted","Set% Adjust","Set %\nAdjusted","Point\nAdjust","Points\nAdjusted","Coin Toss Advantage","Coin\nAdjusted",null,"3rd Place\nRank"]
["Pool A",{"$f":"CALCS!B86","v":0},null,{"$f":"CALCS!C86","v":0},{"$f":"CALCS!D86","v":0},{"$f":"CALCS!E86","v":0},{"$f":"RANK(D120,(D$120:D$122),0)*-1","v":-1},{"$f":"D120+(G120/1000)","v":-1E-3},{"$f":"RANK(E120,(E$120:E$122),0)*-1","v":-1},{"$f":"H120+(I120/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(F120,(F$120:F$122),0)*-1","v":-1},{"$f":"J120+(K120/100000)","v":-1.1100000000000001E-3},{"$f":"(SETUP!I37+(SETUP!J37*0.5))","v":0},{"$f":"L120+(M120/1000000)","v":-1.1100000000000001E-3},{"$f":"RANK(N120,N$120:N$122,0)","v":1},{"$f":"IF(O120=O121,\" \",IF(O120=O122,\" \",O120))","v":" "}]
["Pool B",{"$f":"CALCS!B96","v":0},null,{"$f":"CALCS!C96","v":0},{"$f":"CALCS!D96","v":0},{"$f":"CALCS!E96","v":0},{"$f":"RANK(D121,(D$120:D$122),0)*-1","v":-1},{"$f":"D121+(G121/1000)","v":-1E-3},{"$f":"RANK(E121,(E$120:E$122),0)*-1","v":-1},{"$f":"H121+(I121/10000)","v":-1.1000000000000001E-3},{"$f":"RANK(F121,(F$120:F$122),0)*-1","v":-1},{"$f":"J121+(K121/100000)","v":-1.1100000000000001E-3},{"$f":"(SETUP!I38+(SETUP!J38*0.5))","v":0},{"$f":"L121+(M121/1000000)","v":-1.1100000000000001E-3},{"$f":"RANK(N121,N$120:N$122,0)","v":1},{"$f":"IF(O121=O120,\" \",IF(O121=O122,\" \",O121))","v":" "}]
["Pool C",{"$f":"CALCS!B106","v":0},null,{"$f":"CALCS!C106","v":0},{"$f":"CALCS!D106","v":0},{"$f":"CALCS!E106","v":0},-1,-1E-3,-1,-1.1000000000000001E-3,-1,-1.1100000000000001E-3,{"$f":"(SETUP!I39+(SETUP!J39*0.5))","v":0},-1.1100000000000001E-3,1,{"$f":"IF(O122=O120,\" \",IF(O122=O121,\" \",O122))","v":" "}]
[]
[]
[]
["CALCULATIONS FOR HLOOKUP OF NUMBER OF MATCHES AND SETS BASED ON TOURNEY FORMAT"]
["NUM MATCHES",8,10,11,12,13,14,15,16]
["A",3,3,3,3,3,3,3,3]
["B",3,3,3,3,2,3,3,3]
["C",0,3,2,3,2,2,3,3]
["D",0,0,0,0,2,2,2,3]
[]
["BEST OF SETS",8,10,11,12,13,14,15,16]
["A",3,3,3,3,3,3,3,3]
["B",3,3,3,3,5,3,3,3]
["C",0,3,5,3,5,3,3,3]
["D",0,0,0,0,5,3,5,3]
[]
["SETS REQD TO WIN",8,10,11,12,13,14,15,16]
["A",2,2,2,2,2,2,2,2]
["B",2,2,2,2,3,2,2,2]
["C",0,2,3,2,3,2,2,2]
["D",0,0,0,0,3,2,3,2]