{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Varsity","JV","VarsityBracket","JVBracket","Button Guide","BracketPlayScoreSheet"],"not_rendered":{"charts":0,"images":0,"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":"Varsity","index":0,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,19],[2,1,2,3]]}
["Heartbreaker 2016 Varsity"]
[]
[null,"# of Qualifying Teams:",null,null,16]
[]
["Seed","School","Game 1","Game 2","Set 1 Total","Game 3","Game 4","Set 2 Total","Game 5","Game 6","Set 3 Total","Game 7","Game 8","Set 4 Total","Game 9","Game 10","Set 5 Total","Game 11","Game 12","Total"]
[null,"CC/Mercy Varsity",174,158,{"$f":"SUM(C6:D6)","v":332},167,163,{"$f":"SUM(F6:G6)","v":330},139,183,{"$f":"SUM(I6:J6)","v":322},148,148,{"$f":"SUM(L6:M6)","v":296},168,186,{"$f":"SUM(O6:P6)","v":354},155,129,{"$f":"E6+H6+K6+N6+Q6+R6+S6","v":1918}]
[null,"Chippewa Valley Varsity A",162,203,365,196,234,430,157,148,305,179,171,350,158,178,336,135,155,2076]
[null,"Chippewa Valley Varsity B",208,146,354,156,202,358,167,160,327,115,170,285,171,129,300,144,132,1900]
[null,"Chippewa Valley Varsity C",170,167,337,157,201,358,179,158,337,190,193,383,139,185,324,110,189,2038]
[null,"Cousino Varsity A",195,190,385,206,160,366,212,208,420,166,196,362,248,235,483,181,187,2384]
[null,"Cousino Varsity B",147,175,322,150,133,283,118,146,264,172,220,392,184,181,365,114,105,1845]
[null,"Cousino Varsity C",137,142,279,174,144,318,167,165,332,155,171,326,158,165,323,165,123,1866]
[null,"Davison Varsity",201,169,370,194,224,418,171,190,361,217,226,443,165,179,344,170,223,2329]
[null,"DLS/Regina Varsity A",178,188,366,176,168,344,170,146,316,193,153,346,175,194,369,158,126,2025]
[null,"DLS/Regina Varsity B",186,176,362,133,161,294,187,173,360,122,131,253,125,151,276,185,155,1885]
[null,"DLS/Regina Varsity C",178,134,312,99,114,213,125,156,281,134,181,315,139,131,270,163,154,1708]
[null,"East Detroit Varsity",134,181,315,186,170,356,158,125,283,128,147,275,136,153,289,170,154,1842]
[null,"Father Gabriel Richard Varsity A",167,115,282,165,152,317,132,134,266,164,150,314,166,156,322,165,199,1865]
[null,"Father Gabriel Richard Varsity B",144,118,262,152,89,241,109,97,206,102,110,212,139,117,256,137,105,1419]
[null,"Father Gabriel Richard Varsity C",99,98,197,134,129,263,106,114,220,103,79,182,96,121,217,127,122,1328]
[null,"Lakeview Varsity A",193,161,354,172,147,319,208,149,357,148,153,301,118,150,268,168,175,1942]
[null,"Lakeview Varsity B",199,203,402,179,209,388,134,195,329,201,192,393,193,167,360,171,199,2242]
[null,"LCN Varsity A",217,197,414,187,209,396,185,158,343,182,238,420,164,192,356,222,267,2418]
[null,"LCN Varsity B",204,156,360,186,211,397,212,187,399,257,174,431,173,208,381,157,198,2323]
[null,"LCN Varsity C",137,124,261,190,149,339,184,168,352,192,194,386,141,165,306,149,174,1967]
[null,"Port Huron Northern Varsity A",167,143,310,186,182,368,162,174,336,173,203,376,212,145,357,145,192,2084]
[null,"Port Huron Northern Varsity B",196,153,349,184,136,320,165,149,314,145,151,296,162,151,313,218,191,2001]
[null,"Port Huron Northern Varsity C",113,138,251,160,128,288,114,191,305,179,141,320,146,215,361,153,112,1790]
[null,"Riverview Varsity",169,164,333,183,158,341,126,203,329,146,117,263,108,219,327,211,133,1937]
[null,"Stevenson Varsity A",168,162,330,167,177,344,183,156,339,156,135,291,175,189,364,198,207,2073]
[null,"Stevenson Varsity B",246,168,414,143,236,379,182,148,330,159,174,333,193,199,392,169,164,2181]
[null,"Stevenson Varsity C",136,175,311,178,171,349,158,170,328,137,142,279,162,140,302,161,145,1875]
[null,"Troy Varsity",144,139,283,137,151,288,199,122,321,175,188,363,189,172,361,217,128,1961]
[null,"Utica Varsity A",169,176,345,143,209,352,184,218,402,179,184,363,170,165,335,181,205,2183]
[null,"Utica Varsity B",218,188,406,166,174,340,146,138,284,145,168,313,173,121,294,154,153,1944]
[null,"Warren Mott Varsity",202,165,367,172,205,377,135,156,291,200,180,380,167,199,366,194,183,2158]
[null,"Warren Woods Tower Varsity",205,175,380,108,128,236,114,172,286,116,161,277,189,127,316,173,159,1827]
[null,null,null,null,{"$f":"SUM(C38:D38)","v":0},null,null,{"$f":"SUM(F38:G38)","v":0},null,null,{"$f":"SUM(I38:J38)","v":0},null,null,{"$f":"SUM(L38:M38)","v":0},null,null,{"$f":"SUM(O38:P38)","v":0},null,null,{"$f":"E38+H38+K38+N38+Q38+R38+S38","v":0}]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,{"$f":"SUM(C46:D46)","v":0},null,null,{"$f":"SUM(F46:G46)","v":0},null,null,{"$f":"SUM(I46:J46)","v":0},null,null,{"$f":"SUM(L46:M46)","v":0},null,null,{"$f":"SUM(O46:P46)","v":0},null,null,{"$f":"E46+H46+K46+N46+Q46+R46+S46","v":0}]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"SUM(C61:S61)","v":0}]

{"sheet":"JV","index":1,"n_rows":69,"n_cols":20,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,19],[2,1,2,3]]}
["Heartbreaker 2016 JV"]
[]
[null,"# of Qualifying Teams:",null,null,8]
[]
["Seed","School","Game 1","Game 2","Set 1 Total","Game 3","Game 4","Set 2 Total","Game 5","Game 6","Set 3 Total","Game 7","Game 8","Set 4 Total","Game 9","Game 10","Set 5 Total","Game 11","Game 12","Total"]
[null,"CC/Mercy JV",137,155,{"$f":"SUM(C6:D6)","v":292},122,139,{"$f":"SUM(F6:G6)","v":261},143,120,{"$f":"SUM(I6:J6)","v":263},158,158,{"$f":"SUM(L6:M6)","v":316},165,179,{"$f":"SUM(O6:P6)","v":344},135,183,{"$f":"E6+H6+K6+N6+Q6+R6+S6","v":1794}]
[null,"DLS/Regina JV A",121,108,229,109,128,237,81,103,184,147,153,300,121,118,239,118,102,1409]
[null,"DLS/Regina JV B",165,149,314,130,140,270,169,144,313,119,126,245,119,149,268,145,90,1645]
[null,"Father Gabriel Richard JV A",136,102,238,81,100,181,101,113,214,100,100,200,123,107,230,114,118,1295]
[null,"Father Gabriel Richard JV B",172,117,289,89,77,166,105,150,255,106,104,210,84,103,187,103,109,1319]
[null,"Lakeview JV A",145,112,257,137,133,270,149,148,297,116,144,260,139,153,292,151,165,1692]
[null,"Lakeview JV B",138,104,242,134,135,269,108,130,238,128,137,265,146,127,273,147,156,1590]
[null,"LCN JV",143,142,285,157,139,296,184,158,342,148,127,275,150,152,302,112,161,1773]
[null,"Troy JV",154,111,265,168,99,267,168,184,352,140,149,289,138,162,300,170,134,1777]
[null,null,null,null,{"$f":"SUM(C15:D15)","v":0},null,null,{"$f":"SUM(F15:G15)","v":0},null,null,{"$f":"SUM(I15:J15)","v":0},null,null,{"$f":"SUM(L15:M15)","v":0},null,null,{"$f":"SUM(O15:P15)","v":0},null,null,{"$f":"E15+H15+K15+N15+Q15+R15+S15","v":0}]
[null,null,null,null,{"$f":"SUM(C16:D16)","v":0},null,null,{"$f":"SUM(F16:G16)","v":0},null,null,{"$f":"SUM(I16:J16)","v":0},null,null,{"$f":"SUM(L16:M16)","v":0},null,null,{"$f":"SUM(O16:P16)","v":0},null,null,{"$f":"E16+H16+K16+N16+Q16+R16+S16","v":0}]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,{"$f":"SUM(C21:D21)","v":0},null,null,{"$f":"SUM(F21:G21)","v":0},null,null,{"$f":"SUM(I21:J21)","v":0},null,null,{"$f":"SUM(L21:M21)","v":0},null,null,{"$f":"SUM(O21:P21)","v":0},null,null,{"$f":"E21+H21+K21+N21+Q21+R21+S21","v":0}]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,{"$f":"SUM(C38:D38)","v":0},null,null,{"$f":"SUM(F38:G38)","v":0},null,null,{"$f":"SUM(I38:J38)","v":0},null,null,{"$f":"SUM(L38:M38)","v":0},null,null,{"$f":"SUM(O38:P38)","v":0},null,null,{"$f":"E38+H38+K38+N38+Q38+R38+S38","v":0}]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"SUM(C69:S69)","v":0}]

{"sheet":"VarsityBracket","index":2,"n_rows":43,"n_cols":25,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,23,2,24],[0,0,0,24],[1,0,1,4],[1,6,1,10],[1,12,1,16],[1,18,1,24]]}
["Varsity Bracket"]
["Round 1",null,null,null,null,null,"Round 2",null,null,null,null,null,"Round 3",null,null,null,null,null,"Final Round"]
["Seed","Team","Gm 1","Gm 2","Gm 3",null,"Seed","Team","Gm 1","Gm 2","Gm 3",null,"Seed","Team","Gm 1","Gm 2","Gm 3",null,"Seed","Team","Gm 1","Gm 2","Gm 3","Results"]
[]
[1,"LCN Varsity A",237,211]
[null,"Lane 3",null,null,null,null,{"$f":"IF(C5+C8+D5+D8+E5+E8=0,\"\",IF(C5>C8,IF(D5>D8,A5,IF(E5>E8,A5,A8)),IF(D5>D8,IF(E5>E8,A5,A8),A8)))","v":1},{"$f":"IF(C5+C8+D5+D8+E5+E8=0,\"\",IF(C5>C8,IF(D5>D8,B5,IF(E5>E8,B5,B8)),IF(D5>D8,IF(E5>E8,B5,B8),B8)))","v":"LCN Varsity A"},167,178,178]
[null,"Lane 4",null,null,null,null,null,"Lane 7"]
[16,"Troy Varsity",147,203]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I6+I12+J6+J12+K6+K12=0,\"\",IF(I6>I12,IF(J6>J12,G6,IF(K6>K12,G6,G12)),IF(J6>J12,IF(K6>K12,G6,G12),G12)))","v":1},{"$f":"IF(I6+I12+J6+J12+K6+K12=0,\"\",IF(I6>I12,IF(J6>J12,H6,IF(K6>K12,H6,H12)),IF(J6>J12,IF(K6>K12,H6,H12),H12)))","v":"LCN Varsity A"},213,178]
[8,"Warren Mott Varsity",178,182,null,null,null,null,null,null,null,null,null,"Lane 11"]
[null,"Lane 5",null,null,null,null,null,"Lane 8"]
[null,"Lane 6",null,null,null,null,{"$f":"IF(C10+C13+D10+D13+E10+E13=0,\"\",IF(C10>C13,IF(D10>D13,A10,IF(E10>E13,A10,A13)),IF(D10>D13,IF(E10>E13,A10,A13),A13)))","v":8},{"$f":"IF(C10+C13+D10+D13+E10+E13=0,\"\",IF(C10>C13,IF(D10>D13,B10,IF(E10>E13,B10,B13)),IF(D10>D13,IF(E10>E13,B10,B13),B13)))","v":"Warren Mott Varsity"},206,167,161]
[9,"Port Huron Northern Varsity A",155,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O9+O19+P9+P19+Q9+Q19=0,\"\",IF(O9>O19,IF(P9>P19,M9,IF(Q9>Q19,M9,M19)),IF(P9>P19,IF(Q9>Q19,M9,M19),M19)))","v":1},{"$f":"IF(O9+O19+P9+P19+Q9+Q19=0,\"\",IF(O9>O19,IF(P9>P19,N9,IF(Q9>Q19,N9,N19)),IF(P9>P19,IF(Q9>Q19,N9,N19),N19)))","v":"LCN Varsity A"},207,220]
[5,"Lakeview Varsity B",143,167,199,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane 15"]
[null,"Lane 9",null,null,null,null,{"$f":"IF(C15+C18+D15+D18+E15+E18=0,\"\",IF(C15>C18,IF(D15>D18,A15,IF(E15>E18,A15,A18)),IF(D15>D18,IF(E15>E18,A15,A18),A18)))","v":5},{"$f":"IF(C15+C18+D15+D18+E15+E18=0,\"\",IF(C15>C18,IF(D15>D18,B15,IF(E15>E18,B15,B18)),IF(D15>D18,IF(E15>E18,B15,B18),B18)))","v":"Lakeview Varsity B"},181,222,202]
[null,"Lane 10",null,null,null,null,null,"Lane 5"]
[12,"Chippewa Valley Varsity C",167,161,147,null,null,null,null,null,null,null,null,"Lane 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I16+I22+J16+J22+K16+K22=0,\"\",IF(I16>I22,IF(J16>J22,G16,IF(K16>K22,G16,G22)),IF(J16>J22,IF(K16>K22,G16,G22),G22)))","v":13},{"$f":"IF(I16+I22+J16+J22+K16+K22=0,\"\",IF(I16>I22,IF(J16>J22,H16,IF(K16>K22,H16,H22)),IF(J16>J22,IF(K16>K22,H16,H22),H22)))","v":"DLS/Regina Varsity A"},170,175]
[4,"LCN Varsity B",142,159]
[null,"Lane 11",null,null,null,null,null,"Lane 6"]
[null,"Lane 12",null,null,null,null,{"$f":"IF(C20+C23+D20+D23+E20+E23=0,\"\",IF(C20>C23,IF(D20>D23,A20,IF(E20>E23,A20,A23)),IF(D20>D23,IF(E20>E23,A20,A23),A23)))","v":13},{"$f":"IF(C20+C23+D20+D23+E20+E23=0,\"\",IF(C20>C23,IF(D20>D23,B20,IF(E20>E23,B20,B23)),IF(D20>D23,IF(E20>E23,B20,B23),B23)))","v":"DLS/Regina Varsity A"},203,176,221]
[13,"DLS/Regina Varsity A",162,213,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Champion",{"$f":"IF(U14+U34+V14+V34+W14+W34=0,\"\",IF(U14>U34,IF(V14>V34,T14,IF(W14>W34,T14,T34)),IF(V14>V34,IF(W14>W34,T14,T34),T34)))","v":"LCN Varsity A"}]
[]
[6,"Utica Varsity A",226,238,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Runner-up",{"$f":"IF(U14+U34+V14+V34+W14+W34=0,\"\",IF(U14>U34,IF(V14>V34,T34,IF(W14>W34,T34,T14)),IF(V14>V34,IF(W14>W34,T34,T14),T14)))","v":"Cousino Varsity A"}]
[null,"Lane 15",null,null,null,null,{"$f":"IF(C25+C28+D25+D28+E25+E28=0,\"\",IF(C25>C28,IF(D25>D28,A25,IF(E25>E28,A25,A28)),IF(D25>D28,IF(E25>E28,A25,A28),A28)))","v":6},{"$f":"IF(C25+C28+D25+D28+E25+E28=0,\"\",IF(C25>C28,IF(D25>D28,B25,IF(E25>E28,B25,B28)),IF(D25>D28,IF(E25>E28,B25,B28),B28)))","v":"Utica Varsity A"},200,173,217]
[null,"Lane 16",null,null,null,null,null,"Lane 11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3rd Place",{"$f":"IF(U39+U43+V39+V43+W39+W43=0,\"\",IF(U39>U43,IF(V39>V43,T39,IF(W39>W43,T39,T43)),IF(V39>V43,IF(W39>W43,T39,T43),T43)))","v":"DLS/Regina Varsity A"}]
[11,"Stevenson Varsity A",156,180]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I26+I32+J26+J32+K26+K32=0,\"\",IF(I26>I32,IF(J26>J32,G26,IF(K26>K32,G26,G32)),IF(J26>J32,IF(K26>K32,G26,G32),G32)))","v":6},{"$f":"IF(I26+I32+J26+J32+K26+K32=0,\"\",IF(I26>I32,IF(J26>J32,H26,IF(K26>K32,H26,H32)),IF(J26>J32,IF(K26>K32,H26,H32),H32)))","v":"Utica Varsity A"},185,163,null,null,null,null,null,null,null,"4th Place",{"$f":"IF(U39+U43+V39+V43+W39+W43=0,\"\",IF(U39>U43,IF(V39>V43,T43,IF(W39>W43,T43,T39)),IF(V39>V43,IF(W39>W43,T43,T39),T39)))","v":"Utica Varsity A"}]
[3,"Davison Varsity",199,192,null,null,null,null,null,null,null,null,null,"Lane 9"]
[null,"Lane 17",null,null,null,null,null,"Lane 12"]
[null,"Lane 18",null,null,null,null,{"$f":"IF(C30+C33+D30+D33+E30+E33=0,\"\",IF(C30>C33,IF(D30>D33,A30,IF(E30>E33,A30,A33)),IF(D30>D33,IF(E30>E33,A30,A33),A33)))","v":3},{"$f":"IF(C30+C33+D30+D33+E30+E33=0,\"\",IF(C30>C33,IF(D30>D33,B30,IF(E30>E33,B30,B33)),IF(D30>D33,IF(E30>E33,B30,B33),B33)))","v":"Davison Varsity"},189,207,214]
[14,"Port Huron Northern Varsity B",152,168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane 16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O29+O39+P29+P39+Q29+Q39=0,\"\",IF(O29>O39,IF(P29>P39,M29,IF(Q29>Q39,M29,M39)),IF(P29>P39,IF(Q29>Q39,M29,M39),M39)))","v":2},{"$f":"IF(O29+O39+P29+P39+Q29+Q39=0,\"\",IF(O29>O39,IF(P29>P39,N29,IF(Q29>Q39,N29,N39)),IF(P29>P39,IF(Q29>Q39,N29,N39),N39)))","v":"Cousino Varsity A"},173,205]
[7,"Stevenson Varsity B",188,165,154]
[null,"Lane 21",null,null,null,null,{"$f":"IF(C35+C38+D35+D38+E35+E38=0,\"\",IF(C35>C38,IF(D35>D38,A35,IF(E35>E38,A35,A38)),IF(D35>D38,IF(E35>E38,A35,A38),A38)))","v":10},{"$f":"IF(C35+C38+D35+D38+E35+E38=0,\"\",IF(C35>C38,IF(D35>D38,B35,IF(E35>E38,B35,B38)),IF(D35>D38,IF(E35>E38,B35,B38),B38)))","v":"Chippewa Valley Varsity A"},210,177]
[null,"Lane 22",null,null,null,null,null,"Lane 13"]
[10,"Chippewa Valley Varsity A",162,222,222,null,null,null,null,null,null,null,null,"Lane 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I36+I42+J36+J42+K36+K42=0,\"\",IF(I36>I42,IF(J36>J42,G36,IF(K36>K42,G36,G42)),IF(J36>J42,IF(K36>K42,G36,G42),G42)))","v":2},{"$f":"IF(I36+I42+J36+J42+K36+K42=0,\"\",IF(I36>I42,IF(J36>J42,H36,IF(K36>K42,H36,H42)),IF(J36>J42,IF(K36>K42,H36,H42),H42)))","v":"Cousino Varsity A"},196,200,null,null,{"$f":"IF(O9+O19+P9+P19+Q9+Q19=0,\"\",IF(O9>O19,IF(P9>P19,M19,IF(Q9>Q19,M19,M9)),IF(P9>P19,IF(Q9>Q19,M19,M9),M9)))","v":13},{"$f":"IF(O9+O19+P9+P19+Q9+Q19=0,\"\",IF(O9>O19,IF(P9>P19,N19,IF(Q9>Q19,N19,N9)),IF(P9>P19,IF(Q9>Q19,N19,N9),N9)))","v":"DLS/Regina Varsity A"},127,169,188]
[2,"Cousino Varsity A",188,179,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane 7"]
[null,"Lane 23",null,null,null,null,null,"Lane 14"]
[null,"Lane 24",null,null,null,null,{"$f":"IF(C40+C43+D40+D43+E40+E43=0,\"\",IF(C40>C43,IF(D40>D43,A40,IF(E40>E43,A40,A43)),IF(D40>D43,IF(E40>E43,A40,A43),A43)))","v":2},{"$f":"IF(C40+C43+D40+D43+E40+E43=0,\"\",IF(C40>C43,IF(D40>D43,B40,IF(E40>E43,B40,B43)),IF(D40>D43,IF(E40>E43,B40,B43),B43)))","v":"Cousino Varsity A"},213,208,null,null,null,null,null,null,null,null,null,"Lane 8"]
[15,"LCN Varsity C",146,162,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O29+O39+P29+P39+Q29+Q39=0,\"\",IF(O29>O39,IF(P29>P39,M39,IF(Q29>Q39,M39,M29)),IF(P29>P39,IF(Q29>Q39,M39,M29),M29)))","v":6},{"$f":"IF(O29+O39+P29+P39+Q29+Q39=0,\"\",IF(O29>O39,IF(P29>P39,N39,IF(Q29>Q39,N39,N29)),IF(P29>P39,IF(Q29>Q39,N39,N29),N29)))","v":"Utica Varsity A"},190,152,170]

{"sheet":"JVBracket","index":3,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,1,4],[0,0,0,19],[1,6,1,10],[1,12,1,19],[2,17,2,19],[19,17,19,18],[17,17,17,18],[15,17,15,18],[13,17,13,18]]}
["JV Bracket"]
["Round 1",null,null,null,null,null,"Round 2",null,null,null,null,null,"Final Round"]
["Seed","Team","Gm 1","Gm 2","Gm 3",null,"Seed","Team","Gm 1","Gm 2","Gm 3",null,"Seed","Team","Gm 1","Gm 2","Gm 3","Results"]
[]
[1,"CC/Mercy JV",164,115]
[null,"Lane 27",null,null,null,null,{"$f":"IF(C5+C8+D5+D8+E5+E8=0,\"\",IF(C5>C8,IF(D5>D8,A5,IF(E5>E8,A5,A8)),IF(D5>D8,IF(E5>E8,A5,A8),A8)))","v":1},{"$f":"IF(C5+C8+D5+D8+E5+E8=0,\"\",IF(C5>C8,IF(D5>D8,B5,IF(E5>E8,B5,B8)),IF(D5>D8,IF(E5>E8,B5,B8),B8)))","v":"CC/Mercy JV"},131,138]
[null,"Lane 28",null,null,null,null,null,"Lane 21"]
[8,"Father Gabriel Richard JV B",123,86]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I6+I12+J6+J12+K6+K12=0,\"\",IF(I6>I12,IF(J6>J12,G6,IF(K6>K12,G6,G12)),IF(J6>J12,IF(K6>K12,G6,G12),G12)))","v":4},{"$f":"IF(I6+I12+J6+J12+K6+K12=0,\"\",IF(I6>I12,IF(J6>J12,H6,IF(K6>K12,H6,H12)),IF(J6>J12,IF(K6>K12,H6,H12),H12)))","v":"Lakeview JV A"},143,196,116]
[4,"Lakeview JV A",138,140,null,null,null,null,null,null,null,null,null,"Lane 17"]
[null,"Lane 29",null,null,null,null,null,"Lane 22"]
[null,"Lane 30",null,null,null,null,{"$f":"IF(C10+C13+D10+D13+E10+E13=0,\"\",IF(C10>C13,IF(D10>D13,A10,IF(E10>E13,A10,A13)),IF(D10>D13,IF(E10>E13,A10,A13),A13)))","v":4},{"$f":"IF(C10+C13+D10+D13+E10+E13=0,\"\",IF(C10>C13,IF(D10>D13,B10,IF(E10>E13,B10,B13)),IF(D10>D13,IF(E10>E13,B10,B13),B13)))","v":"Lakeview JV A"},157,142]
[5,"DLS/Regina JV B",115,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Champion",null,{"$f":"IF(O9+O19+P9+P19+Q9+Q19=0,\"\",IF(O9>O19,IF(P9>P19,N9,IF(Q9>Q19,N9,N19)),IF(P9>P19,IF(Q9>Q19,N9,N19),N19)))","v":"LCN JV"}]
[3,"LCN JV",166,169,129]
[null,"Lane 33",null,null,null,null,{"$f":"IF(C15+C18+D15+D18+E15+E18=0,\"\",IF(C15>C18,IF(D15>D18,A15,IF(E15>E18,A15,A18)),IF(D15>D18,IF(E15>E18,A15,A18),A18)))","v":3},{"$f":"IF(C15+C18+D15+D18+E15+E18=0,\"\",IF(C15>C18,IF(D15>D18,B15,IF(E15>E18,B15,B18)),IF(D15>D18,IF(E15>E18,B15,B18),B18)))","v":"LCN JV"},161,127,null,null,null,null,null,null,null,"Runner-up",null,{"$f":"IF(O9+O19+P9+P19+Q9+Q19=0,\"\",IF(O9>O19,IF(P9>P19,N19,IF(Q9>Q19,N19,N9)),IF(P9>P19,IF(Q9>Q19,N19,N9),N9)))","v":"Lakeview JV A"}]
[null,"Lane 34",null,null,null,null,null,"Lane 23"]
[6,"Lakeview JV B",137,185,114,null,null,null,null,null,null,null,null,"Lane 18"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I16+I22+J16+J22+K16+K22=0,\"\",IF(I16>I22,IF(J16>J22,G16,IF(K16>K22,G16,G22)),IF(J16>J22,IF(K16>K22,G16,G22),G22)))","v":3},{"$f":"IF(I16+I22+J16+J22+K16+K22=0,\"\",IF(I16>I22,IF(J16>J22,H16,IF(K16>K22,H16,H22)),IF(J16>J22,IF(K16>K22,H16,H22),H22)))","v":"LCN JV"},155,132,117]
[2,"Troy JV",135,122]
[null,"Lane 35",null,null,null,null,null,"Lane 24"]
[null,"Lane 36",null,null,null,null,{"$f":"IF(C20+C23+D20+D23+E20+E23=0,\"\",IF(C20>C23,IF(D20>D23,A20,IF(E20>E23,A20,A23)),IF(D20>D23,IF(E20>E23,A20,A23),A23)))","v":7},{"$f":"IF(C20+C23+D20+D23+E20+E23=0,\"\",IF(C20>C23,IF(D20>D23,B20,IF(E20>E23,B20,B23)),IF(D20>D23,IF(E20>E23,B20,B23),B23)))","v":"DLS/Regina JV A"},124,115]
[7,"DLS/Regina JV A",144,149]

{"sheet":"Button Guide","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Button Guide"]
[null,"Name","Key Combination","Description"]
[null,"Seed",null,"During qualifying this macro sorts the active qualifying sheet (Varsity or JV) by total score, seeds according to number of qualifying teams, and hides columns and rows for printability."]
[null,"Alpha Sort",null,"During qualifying this marco sorts alphabetically by team name, removes seeding, and unhides columns hidden by Seed macro to allow qualifying round score entry."]
[null,"Brackets",null,"After qualifying is completed this macro seeds teams and builds brackets based on what qualifying sheet (Varsity or JV) you are viewing."]
[null,"Clear","Ctrl+Shift+C","If needed, this marco removes all brackets and formating, and clears team names and scores from all sheets."]
[null,"Hide",null,"Hide columns to show only current set for score entry."]
[null,"Unhide",null,"Shows all columns "]

{"sheet":"BracketPlayScoreSheet","index":5,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Bracket Play",null,null,"Game 1","Game 2","Game 3"]
[]
["Team 1"]
[]
[]
["Team 2"]