{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Anleitung","MASTER","Gruppeneinteilung","Spielplan Versand","Resultate VR","Schlussrangliste","Spielberichte"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":"Anleitung","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"MASTER","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Wettbewerb","Ostschweizer Meisterschaft"]
[]
["Datum Ort","So. 15.12.2019","Aadorf, Löhracker"]
[null,null,"Anspielzeit","Rhythmus"]
["Wettbewerb 1","Vorrunde","13:30:00","00:30:00"]
[null,"Finalrunde","15:00:00","00:40:00"]
[]
["Saison","Halle 2019/2020"]
[]
["Kategorie","U14"]

{"sheet":"Gruppeneinteilung","index":2,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CONCATENATE(MASTER!B1, \" \", MASTER!B8, \" - Kat. \", MASTER!B10)","v":"Ostschweizer Meisterschaft Halle 2019/2020 - Kat. U14"}]
[{"$f":"CONCATENATE(MASTER!B3,\" / \",MASTER!C3)","v":"So. 15.12.2019 / Aadorf, Löhracker"}]
[{"$f":"MASTER!B6","v":"Finalrunde"}]
[]
["Gruppe A","Mannschaften"]
["A1","STV Affeltrangen"]
["A2","FG RiWi 2"]
["A3","SVD Diepoldsau"]
[]
["Gruppe B"]
["B1","TS Höchst"]
["B2","FBV Ettenhausen "]
["B3","FBT Flums"]
[]
["Gruppe C"]
["C1","FG RiWi 1"]
["C2","TS Schwarzach"]
["C3","STV Wigoltingen"]
["C4","Satus Kreuzlingen"]
["C5","JFB Widnau"]

{"sheet":"Spielplan Versand","index":3,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,2,14,4],[14,8,14,10],[21,8,21,10],[21,14,21,16],[22,8,22,10],[22,14,22,16],[23,2,23,4],[23,8,23,10],[23,14,23,16],[21,2,21,4],[22,2,22,4],[31,14,31,16],[24,2,24,4],[24,8,24,10],[24,14,24,16],[25,8,25,10],[25,14,25,16]]}
[{"$f":"CONCATENATE(MASTER!B1, \" \", MASTER!B8, \" - Kat. \", MASTER!B10)","v":"Ostschweizer Meisterschaft Halle 2019/2020 - Kat. U14"}]
[{"$f":"CONCATENATE(MASTER!B3,\" / \",MASTER!C3)","v":"So. 15.12.2019 / Aadorf, Löhracker"}]
[{"$f":"MASTER!B6","v":"Finalrunde"}]
[]
[]
[null,"Gruppe A (Ränge 1-6)",null,null,null,null,null,"Gruppe B (Ränge 1-6)"]
[null,"A1",{"$f":"VLOOKUP(B7, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"STV Affeltrangen"},null,null,null,null,"B1",{"$f":"VLOOKUP(H7, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"TS Höchst"}]
[null,"A2",{"$f":"VLOOKUP(B8, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"FG RiWi 2"},null,null,null,null,"B2",{"$f":"VLOOKUP(H8, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"FBV Ettenhausen "}]
[null,"A3",{"$f":"VLOOKUP(B9, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"SVD Diepoldsau"},null,null,null,null,"B3",{"$f":"VLOOKUP(H9, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"FBT Flums"}]
[]
[]
[]
["Vorrunde (2 Gewinnsätze à 11 Punkte; max. 15:14)"]
[]
["Zeit","Spiel","Feld 1",null,null,"SR",null,"Spiel","Feld 2",null,null,"SR"]
[{"$f":"MASTER!C5","v":"13:30:00"},1,{"$f":"$B$7","v":"A1"},"-",{"$f":"$B$8","v":"A2"},{"$f":"B9","v":"A3"},null,{"$f":"+B16+1","v":2},{"$f":"$H$7","v":"B1"},"-",{"$f":"$H$8","v":"B2"},{"$f":"$H$9","v":"B3"}]
["anschl.",{"$f":"+B16+2","v":3},{"$f":"$B$8","v":"A2"},"-",{"$f":"$B$9","v":"A3"},{"$f":"$B$7","v":"A1"},null,{"$f":"+H16+2","v":4},{"$f":"$H$8","v":"B2"},"-",{"$f":"$H$9","v":"B3"},{"$f":"H7","v":"B1"}]
[null,{"$f":"+B17+2","v":5},{"$f":"$B$7","v":"A1"},"-",{"$f":"$B$9","v":"A3"},{"$f":"B8","v":"A2"},null,{"$f":"+H17+2","v":6},{"$f":"$H$7","v":"B1"},"-",{"$f":"$H$9","v":"B3"},{"$f":"$H$8","v":"B2"}]
[]
[{"$f":"CONCATENATE(MASTER!B6,\" (2 Gewinnsätze à 11 Punkte; max. 15:14)\")","v":"Finalrunde (2 Gewinnsätze à 11 Punkte; max. 15:14)"}]
[]
[null,"Spiel","Feld 1",null,null,"SR",null,"Spiel","Feld 2",null,null,"SR"]
[null,7,"2.A-3.B Viertelfinale",null,null,"1.A",null,{"$f":"+B23+1","v":8},"2.B.-3.A Viertelfinale",null,null,"1.B"]
[null,{"$f":"+B23+2","v":9},"1.A-S8 Halbfinale",null,null,"V7",null,{"$f":"+H23+2","v":10},"1.B-S7 Halbfinale",null,null,"V8"]
[null,{"$f":"+B24+2","v":11},"V7-V8              Rang 5/6",null,null,"S9",null,12,"V9-V10         Rang 3/4",null,null,"S10"]
[null,null,null,null,null,null,null,{"$f":"+B25+2","v":13},"S9-S10          Final",null,null,"S12"]
[]
["Die Pause zwischen den Spielen beträgt maximal 10 Minuten."]
[]
[]
[]
[null,"Gruppe C (Ränge 7-11)",null,null,null,null,null,null,null,null,null,null,"Zeit","Spiel","Feld 3",null,null,"SR"]
[null,"C1",{"$f":"VLOOKUP(B33, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"FG RiWi 1"},null,null,null,null,null,null,null,null,null,"12:00",14,{"$f":"$B$33","v":"C1"},"-",{"$f":"$B$34","v":"C2"},{"$f":"$B$37","v":"C5"}]
[null,"C2",{"$f":"VLOOKUP(B34, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"TS Schwarzach"},null,null,null,null,null,null,null,null,null,"anschl.",{"$f":"+N33+1","v":15},{"$f":"$B$35","v":"C3"},"-",{"$f":"$B$36","v":"C4"},{"$f":"$B$33","v":"C1"}]
[null,"C3",{"$f":"VLOOKUP(B35, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"STV Wigoltingen"},null,null,null,null,null,null,null,null,null,null,{"$f":"+N34+1","v":16},{"$f":"$B$33","v":"C1"},"-",{"$f":"$B$37","v":"C5"},{"$f":"$B$36","v":"C4"}]
[null,"C4",{"$f":"VLOOKUP(B36, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"Satus Kreuzlingen"},null,null,null,null,null,null,null,null,null,null,{"$f":"+N35+1","v":17},{"$f":"$B$34","v":"C2"},"-",{"$f":"$B$35","v":"C3"},{"$f":"$B$33","v":"C1"}]
[null,"C5",{"$f":"VLOOKUP(B37, Gruppeneinteilung!$A$6:$B$1000, 2,FALSE)","v":"JFB Widnau"},null,null,null,null,null,null,null,null,null,null,18,{"$f":"$B$36","v":"C4"},"-",{"$f":"$B$37","v":"C5"},{"$f":"$B$34","v":"C2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"$B$33","v":"C1"},"-",{"$f":"$B$35","v":"C3"},{"$f":"$B$37","v":"C5"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"$B$34","v":"C2"},"-",{"$f":"$B$37","v":"C5"},{"$f":"$B$35","v":"C3"}]
[null,"2 Sätze à 11 Punkte; max. 15:14; 1 Punkt pro Satz",null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"$B$33","v":"C1"},"-",{"$f":"$B$36","v":"C4"},{"$f":"$B$34","v":"C2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"$B$35","v":"C3"},"-",{"$f":"$B$37","v":"C5"},{"$f":"$B$36","v":"C4"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"$B$34","v":"C2"},"-",{"$f":"$B$36","v":"C4"},{"$f":"$B$35","v":"C3"}]

{"sheet":"Resultate VR","index":4,"n_rows":76,"n_cols":70,"rows_kept":76,"cut":false,"hidden":false,"merged":[[62,30,66,30],[62,31,66,31],[52,30,56,30],[52,31,56,31],[38,6,38,8],[57,30,61,30],[57,31,61,31],[47,30,51,30],[47,31,51,31],[9,6,9,8],[16,34,16,35],[11,26,12,26],[42,26,43,26],[20,6,20,8],[22,26,23,26],[35,34,35,35],[42,30,46,30],[42,31,46,31]]}
[{"$f":"CONCATENATE(MASTER!B1, \" \", MASTER!B8, \" - Kat. \", MASTER!B10)","v":"Ostschweizer Meisterschaft Halle 2019/2020 - Kat. U14"},null,null,null,null,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":"TODAY()","v":"2019-12-15"}]
[{"$f":"CONCATENATE(MASTER!B3,\" / \",MASTER!C3)","v":"So. 15.12.2019 / Aadorf, Löhracker"}]
[{"$f":"MASTER!B6","v":"Finalrunde"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sp","Pkte","S+","S-","S+/-","B+","B-","B+/-"]
["Resultate Gruppe 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,"A1",{"$f":"VLOOKUP(AE5,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Affeltrangen"},1,{"$f":"IF(OR(AQ5>0,AR5>0),1,0)","v":1},{"$f":"((AQ5>AR5)*1+(AS5>AT5)*1+(AU5>AV5)*1+(AW5>AX5)*1+(AY5>AZ5)*1>1.99)*2+((BB5>BC5)*1+(BD5>BE5)*1+(BF5>BG5)*1+(BH5>BI5)*1+(BJ5>BK5)*1>1.99)*2","v":0},{"$f":"IF(AQ5>AR5,1,0)+IF(AS5>AT5,1,0)+IF(AU5>AV5,1,0)+IF(AW5>AX5,1,0)+IF(AY5>AZ5,1,0)+IF(BB5>BC5,1,0)+IF(BD5>BE5,1,0)+IF(BF5>BG5,1,0)+IF(BH5>BI5,1,0)+IF(BJ5>BK5,1,0)","v":0},{"$f":"IF(AQ5<AR5,1,0)+IF(AS5<AT5,1,0)+IF(AU5<AV5,1,0)+IF(AW5<AX5,1,0)+IF(AY5<AZ5,1,0)+IF(BB5<BC5,1,0)+IF(BD5<BE5,1,0)+IF(BF5<BG5,1,0)+IF(BH5<BI5,1,0)+IF(BJ5<BK5,1,0)","v":2},{"$f":"AJ5-AK5","v":-2},{"$f":"AQ5+AS5+AU5+BB5+BD5+BF5","v":15},24,{"$f":"AM5-AN5","v":-9},null,{"$f":"O6","v":4},{"$f":"Q6","v":11},{"$f":"S6","v":11},{"$f":"U6","v":13},{"$f":"W6","v":0},{"$f":"Y6","v":0}]
[null,{"$f":"VLOOKUP(AB6,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Affeltrangen"},null,"-",{"$f":"VLOOKUP(AC6,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 2"},null,null,null,null,0,":",2,null,"(",4,":",11,",",11,":",13,",",null,":",null,")",null,"A1","A2",null,null,null,2,{"$f":"IF(OR(AQ6>0,AR6>0),1,0)","v":1},{"$f":"((AQ6>AR6)*1+(AS6>AT6)*1+(AU6>AV6)*1+(AW6>AX6)*1+(AY6>AZ6)*1>1.99)*2+((BB6>BC6)*1+(BD6>BE6)*1+(BF6>BG6)*1+(BH6>BI6)*1+(BJ6>BK6)*1>1.99)*2","v":2},{"$f":"IF(AQ6>AR6,1,0)+IF(AS6>AT6,1,0)+IF(AU6>AV6,1,0)+IF(AW6>AX6,1,0)+IF(AY6>AZ6,1,0)+IF(BB6>BC6,1,0)+IF(BD6>BE6,1,0)+IF(BF6>BG6,1,0)+IF(BH6>BI6,1,0)+IF(BJ6>BK6,1,0)","v":2},{"$f":"IF(AQ6<AR6,1,0)+IF(AS6<AT6,1,0)+IF(AU6<AV6,1,0)+IF(AW6<AX6,1,0)+IF(AY6<AZ6,1,0)+IF(BB6<BC6,1,0)+IF(BD6<BE6,1,0)+IF(BF6<BG6,1,0)+IF(BH6<BI6,1,0)+IF(BJ6<BK6,1,0)","v":1},{"$f":"AJ6-AK6","v":1},35,34,{"$f":"AM6-AN6","v":1},null,{"$f":"O8","v":9},{"$f":"Q8","v":11},{"$f":"S8","v":15},{"$f":"U8","v":14},{"$f":"W8","v":11},{"$f":"Y8","v":9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direkte Begegnung Gruppe A"]
[null,{"$f":"VLOOKUP(AB7,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 2"},null,"-",{"$f":"VLOOKUP(AC7,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"SVD Diepoldsau"},null,null,null,null,2,":",0,null,"(",12,":",10,",",11,":",9,",",null,":",null,")",null,"A2","A3",null,null,null,null,{"$f":"SUM(AH5:AH6)","v":2},2,2,3,-1,50,58,-8]
[null,{"$f":"VLOOKUP(AB8,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Affeltrangen"},null,"-",{"$f":"VLOOKUP(AC8,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"SVD Diepoldsau"},null,null,null,null,2,":",1,null,"(",9,":",11,",",15,":",14,",",11,":",9,")",null,"A1","A3",null,"A2",{"$f":"VLOOKUP(AE8,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 2"},1,{"$f":"IF(OR(AQ8>0,AR8>0),1,0)","v":1},{"$f":"((AQ8>AR8)*1+(AS8>AT8)*1+(AU8>AV8)*1+(AW8>AX8)*1+(AY8>AZ8)*1>1.99)*2+((BB8>BC8)*1+(BD8>BE8)*1+(BF8>BG8)*1+(BH8>BI8)*1+(BJ8>BK8)*1>1.99)*2","v":2},{"$f":"IF(AQ8>AR8,1,0)+IF(AS8>AT8,1,0)+IF(AU8>AV8,1,0)+IF(AW8>AX8,1,0)+IF(AY8>AZ8,1,0)+IF(BB8>BC8,1,0)+IF(BD8>BE8,1,0)+IF(BF8>BG8,1,0)+IF(BH8>BI8,1,0)+IF(BJ8>BK8,1,0)","v":2},{"$f":"IF(AQ8<AR8,1,0)+IF(AS8<AT8,1,0)+IF(AU8<AV8,1,0)+IF(AW8<AX8,1,0)+IF(AY8<AZ8,1,0)+IF(BB8<BC8,1,0)+IF(BD8<BE8,1,0)+IF(BF8<BG8,1,0)+IF(BH8<BI8,1,0)+IF(BJ8<BK8,1,0)","v":0},{"$f":"AJ8-AK8","v":2},{"$f":"AQ8+AS8+AU8+BB8+BD8+BF8","v":24},{"$f":"AR8+AT8+AV8+BC8+BE8+BG8","v":15},{"$f":"AM8-AN8","v":9},null,{"$f":"Q6","v":11},{"$f":"O6","v":4},{"$f":"U6","v":13},{"$f":"S6","v":11},{"$f":"Y6","v":0},{"$f":"W6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$11-$F$12","v":2},{"$f":"$F$12-$F$13","v":2},null,null,null,{"$f":"MIN(BM8:BQ8)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(OR(AQ9>0,AR9>0),1,0)","v":1},{"$f":"((AQ9>AR9)*1+(AS9>AT9)*1+(AU9>AV9)*1+(AW9>AX9)*1+(AY9>AZ9)*1>1.99)*2+((BB9>BC9)*1+(BD9>BE9)*1+(BF9>BG9)*1+(BH9>BI9)*1+(BJ9>BK9)*1>1.99)*2","v":2},{"$f":"IF(AQ9>AR9,1,0)+IF(AS9>AT9,1,0)+IF(AU9>AV9,1,0)+IF(AW9>AX9,1,0)+IF(AY9>AZ9,1,0)+IF(BB9>BC9,1,0)+IF(BD9>BE9,1,0)+IF(BF9>BG9,1,0)+IF(BH9>BI9,1,0)+IF(BJ9>BK9,1,0)","v":2},{"$f":"IF(AQ9<AR9,1,0)+IF(AS9<AT9,1,0)+IF(AU9<AV9,1,0)+IF(AW9<AX9,1,0)+IF(AY9<AZ9,1,0)+IF(BB9<BC9,1,0)+IF(BD9<BE9,1,0)+IF(BF9<BG9,1,0)+IF(BH9<BI9,1,0)+IF(BJ9<BK9,1,0)","v":0},{"$f":"AJ9-AK9","v":2},{"$f":"AQ9+AS9+AU9+BB9+BD9+BF9","v":23},19,{"$f":"AM9-AN9","v":4},null,{"$f":"O7","v":12},{"$f":"Q7","v":10},{"$f":"S7","v":11},{"$f":"U7","v":9},{"$f":"W7","v":0},{"$f":"Y7","v":0}]
["Rangliste Gruppe A",null,null,null,{"$f":"AG17","v":"Sp."},"Pkte.","Bälle",null,null,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":"SUM(AH8:AH9)","v":2},4,4,0,4,47,34,13]
[null,"1.",{"$f":"AF18","v":"FG RiWi 2"},null,{"$f":"AG18","v":2},{"$f":"AH18","v":4},{"$f":"AI18","v":47},":",{"$f":"AJ18","v":34},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A3",{"$f":"VLOOKUP(AE11,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"SVD Diepoldsau"},1,{"$f":"IF(OR(AQ11>0,AR11>0),1,0)","v":1},{"$f":"((AQ11>AR11)*1+(AS11>AT11)*1+(AU11>AV11)*1+(AW11>AX11)*1+(AY11>AZ11)*1>1.99)*2+((BB11>BC11)*1+(BD11>BE11)*1+(BF11>BG11)*1+(BH11>BI11)*1+(BJ11>BK11)*1>1.99)*2","v":0},{"$f":"IF(AQ11>AR11,1,0)+IF(AS11>AT11,1,0)+IF(AU11>AV11,1,0)+IF(AW11>AX11,1,0)+IF(AY11>AZ11,1,0)+IF(BB11>BC11,1,0)+IF(BD11>BE11,1,0)+IF(BF11>BG11,1,0)+IF(BH11>BI11,1,0)+IF(BJ11>BK11,1,0)","v":1},{"$f":"IF(AQ11<AR11,1,0)+IF(AS11<AT11,1,0)+IF(AU11<AV11,1,0)+IF(AW11<AX11,1,0)+IF(AY11<AZ11,1,0)+IF(BB11<BC11,1,0)+IF(BD11<BE11,1,0)+IF(BF11<BG11,1,0)+IF(BH11<BI11,1,0)+IF(BJ11<BK11,1,0)","v":2},{"$f":"AJ11-AK11","v":-1},{"$f":"AQ11+AS11+AU11+BB11+BD11+BF11","v":34},35,{"$f":"AM11-AN11","v":-1},null,{"$f":"Q8","v":11},{"$f":"O8","v":9},{"$f":"U8","v":14},{"$f":"S8","v":15},{"$f":"Y8","v":9},{"$f":"W8","v":11}]
[null,"2.",{"$f":"AF19","v":"STV Affeltrangen"},null,{"$f":"AG19","v":2},{"$f":"AH19","v":2},{"$f":"AI19","v":50},":",{"$f":"AJ19","v":58},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BR8=0, \"DIREKTE BEGEGNUNG\", \"\")","v":""},null,null,null,null,null,2,{"$f":"IF(OR(AQ12>0,AR12>0),1,0)","v":1},{"$f":"((AQ12>AR12)*1+(AS12>AT12)*1+(AU12>AV12)*1+(AW12>AX12)*1+(AY12>AZ12)*1>1.99)*2+((BB12>BC12)*1+(BD12>BE12)*1+(BF12>BG12)*1+(BH12>BI12)*1+(BJ12>BK12)*1>1.99)*2","v":0},{"$f":"IF(AQ12>AR12,1,0)+IF(AS12>AT12,1,0)+IF(AU12>AV12,1,0)+IF(AW12>AX12,1,0)+IF(AY12>AZ12,1,0)+IF(BB12>BC12,1,0)+IF(BD12>BE12,1,0)+IF(BF12>BG12,1,0)+IF(BH12>BI12,1,0)+IF(BJ12>BK12,1,0)","v":0},{"$f":"IF(AQ12<AR12,1,0)+IF(AS12<AT12,1,0)+IF(AU12<AV12,1,0)+IF(AW12<AX12,1,0)+IF(AY12<AZ12,1,0)+IF(BB12<BC12,1,0)+IF(BD12<BE12,1,0)+IF(BF12<BG12,1,0)+IF(BH12<BI12,1,0)+IF(BJ12<BK12,1,0)","v":2},{"$f":"AJ12-AK12","v":-2},{"$f":"AQ12+AS12+AU12+BB12+BD12+BF12","v":19},{"$f":"AR12+AT12+AV12+BC12+BE12+BG12","v":23},{"$f":"AM12-AN12","v":-4},null,{"$f":"Q7","v":10},{"$f":"O7","v":12},{"$f":"U7","v":9},{"$f":"S7","v":11},{"$f":"Y7","v":0},{"$f":"W7","v":0}]
[null,"3.","SVD Diepoldsau",null,2,0,53,":",{"$f":"AJ20","v":58},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":"SUM(AH11:AH12)","v":2},0,1,4,-3,53,58,-5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontrollsummen",null,null,{"$f":"+AH7+AH10+AH13","v":6},6,7,7,0,150,150,0,null,{"$f":"SUM(AQ5:AQ13)","v":57},57,73,73,20,20,0,0,0,0,null,{"$f":"SUM(BB5:BB13)","v":0},0,0,0,0,0,0,0,0,0]
["Resultate Gruppe B"]
[null,{"$f":"VLOOKUP(AB17,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Höchst"},null,"-",{"$f":"VLOOKUP(AC17,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBV Ettenhausen "},null,null,null,null,0,":",2,null,"(",7,":",11,",",8,":",11,",",null,":",null,")",null,"B1","B2",null,null,null,"Sp.","Pkte.","Bälle",null,"+/-"]
[null,{"$f":"VLOOKUP(AB18,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBV Ettenhausen "},null,"-",{"$f":"VLOOKUP(AC18,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBT Flums"},null,null,null,null,2,":",0,null,"(",11,":",4,",",14,":",12,",",null,":",null,")",null,"B2","B3",null,"1.",{"$f":"$AF$8","v":"FG RiWi 2"},{"$f":"$AH$10","v":2},{"$f":"$AI$10","v":4},{"$f":"$AM$10","v":47},{"$f":"$AN$10","v":34},{"$f":"$AO$10","v":13}]
[null,{"$f":"VLOOKUP(AB19,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Höchst"},null,"-",{"$f":"VLOOKUP(AC19,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBT Flums"},null,null,null,null,2,":",1,null,"(",11,":",9,",",8,":",11,",",8,":",11,")",null,"B1","B3",null,"2.",{"$f":"$AF$5","v":"STV Affeltrangen"},{"$f":"$AH$7","v":2},{"$f":"$AI$7","v":2},{"$f":"$AM$7","v":50},{"$f":"$AN$7","v":58},{"$f":"$AO$7","v":-8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.",{"$f":"$AF$11","v":"SVD Diepoldsau"},{"$f":"$AH$13","v":2},{"$f":"$AI$13","v":0},{"$f":"$AM$13","v":53},{"$f":"$AN$13","v":58},{"$f":"$AO$13","v":-5}]
["Rangliste Gruppe B",null,null,null,{"$f":"AG36","v":"Sp."},{"$f":"AH36","v":"Pkte."},{"$f":"AI36","v":"Bälle"}]
[null,"1.",{"$f":"AF37","v":"FBV Ettenhausen "},null,2,4,47,":",{"$f":"AJ37","v":31}]
[null,"2.",{"$f":"AF38","v":"FBT Flums"},null,2,2,47,":",52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BR27=0, \"DIREKTE BEGEGNUNG\", \"\")","v":""},null,null,null,null,null,null,"Sp","Pkte","S+","S-","S+/-","B+","B-","B+/-"]
[null,"3.","TS Höchst",null,2,0,42,":",53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B1",{"$f":"VLOOKUP(AE24,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Höchst"},1,{"$f":"IF(OR(AQ24>0,AR24>0),1,0)","v":1},{"$f":"((AQ24>AR24)*1+(AS24>AT24)*1+(AU24>AV24)*1+(AW24>AX24)*1+(AY24>AZ24)*1>1.99)*2+((BB24>BC24)*1+(BD24>BE24)*1+(BF24>BG24)*1+(BH24>BI24)*1+(BJ24>BK24)*1>1.99)*2","v":0},{"$f":"IF(AQ24>AR24,1,0)+IF(AS24>AT24,1,0)+IF(AU24>AV24,1,0)+IF(AW24>AX24,1,0)+IF(AY24>AZ24,1,0)+IF(BB24>BC24,1,0)+IF(BD24>BE24,1,0)+IF(BF24>BG24,1,0)+IF(BH24>BI24,1,0)+IF(BJ24>BK24,1,0)","v":0},{"$f":"IF(AQ24<AR24,1,0)+IF(AS24<AT24,1,0)+IF(AU24<AV24,1,0)+IF(AW24<AX24,1,0)+IF(AY24<AZ24,1,0)+IF(BB24<BC24,1,0)+IF(BD24<BE24,1,0)+IF(BF24<BG24,1,0)+IF(BH24<BI24,1,0)+IF(BJ24<BK24,1,0)","v":2},{"$f":"AJ24-AK24","v":-2},{"$f":"AQ24+AS24+AU24+BB24+BD24+BF24","v":15},{"$f":"AR24+AT24+AV24+BC24+BE24+BG24","v":22},{"$f":"AM24-AN24","v":-7},null,{"$f":"O17","v":7},{"$f":"Q17","v":11},{"$f":"S17","v":8},{"$f":"U17","v":11},{"$f":"W17","v":0},{"$f":"Y17","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,2,{"$f":"IF(OR(AQ25>0,AR25>0),1,0)","v":1},{"$f":"((AQ25>AR25)*1+(AS25>AT25)*1+(AU25>AV25)*1+(AW25>AX25)*1+(AY25>AZ25)*1>1.99)*2+((BB25>BC25)*1+(BD25>BE25)*1+(BF25>BG25)*1+(BH25>BI25)*1+(BJ25>BK25)*1>1.99)*2","v":0},{"$f":"IF(AQ25>AR25,1,0)+IF(AS25>AT25,1,0)+IF(AU25>AV25,1,0)+IF(AW25>AX25,1,0)+IF(AY25>AZ25,1,0)+IF(BB25>BC25,1,0)+IF(BD25>BE25,1,0)+IF(BF25>BG25,1,0)+IF(BH25>BI25,1,0)+IF(BJ25>BK25,1,0)","v":1},{"$f":"IF(AQ25<AR25,1,0)+IF(AS25<AT25,1,0)+IF(AU25<AV25,1,0)+IF(AW25<AX25,1,0)+IF(AY25<AZ25,1,0)+IF(BB25<BC25,1,0)+IF(BD25<BE25,1,0)+IF(BF25<BG25,1,0)+IF(BH25<BI25,1,0)+IF(BJ25<BK25,1,0)","v":2},{"$f":"AJ25-AK25","v":-1},27,31,{"$f":"AM25-AN25","v":-4},null,{"$f":"O19","v":11},{"$f":"Q19","v":9},{"$f":"S19","v":8},{"$f":"U19","v":11},{"$f":"W19","v":8},{"$f":"Y19","v":11},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direkte Begegnung Gruppe 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,null,{"$f":"SUM(AH24:AH25)","v":2},0,1,4,-3,42,53,-11]
["Resultate Gruppe 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,"B2",{"$f":"VLOOKUP(AE27,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBV Ettenhausen "},1,{"$f":"IF(OR(AQ27>0,AR27>0),1,0)","v":1},{"$f":"((AQ27>AR27)*1+(AS27>AT27)*1+(AU27>AV27)*1+(AW27>AX27)*1+(AY27>AZ27)*1>1.99)*2+((BB27>BC27)*1+(BD27>BE27)*1+(BF27>BG27)*1+(BH27>BI27)*1+(BJ27>BK27)*1>1.99)*2","v":2},{"$f":"IF(AQ27>AR27,1,0)+IF(AS27>AT27,1,0)+IF(AU27>AV27,1,0)+IF(AW27>AX27,1,0)+IF(AY27>AZ27,1,0)+IF(BB27>BC27,1,0)+IF(BD27>BE27,1,0)+IF(BF27>BG27,1,0)+IF(BH27>BI27,1,0)+IF(BJ27>BK27,1,0)","v":2},{"$f":"IF(AQ27<AR27,1,0)+IF(AS27<AT27,1,0)+IF(AU27<AV27,1,0)+IF(AW27<AX27,1,0)+IF(AY27<AZ27,1,0)+IF(BB27<BC27,1,0)+IF(BD27<BE27,1,0)+IF(BF27<BG27,1,0)+IF(BH27<BI27,1,0)+IF(BJ27<BK27,1,0)","v":0},{"$f":"AJ27-AK27","v":2},{"$f":"AQ27+AS27+AU27+BB27+BD27+BF27","v":22},{"$f":"AR27+AT27+AV27+BC27+BE27+BG27","v":15},{"$f":"AM27-AN27","v":7},null,{"$f":"Q17","v":11},{"$f":"O17","v":7},{"$f":"U17","v":11},{"$f":"S17","v":8},{"$f":"Y17","v":0},{"$f":"W17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$11-$F$12","v":2},{"$f":"$F$12-$F$13","v":2},null,null,null,{"$f":"MIN(BM27:BQ27)","v":2}]
[null,{"$f":"VLOOKUP(AB28,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},null,"-",{"$f":"VLOOKUP(AC28,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},null,null,null,null,2,":",0,null,"(",11,":",6,",",11,":",4,",",null,":",null,")",null,"C1","C2",null,null,null,3,{"$f":"IF(OR(AQ28>0,AR28>0),1,0)","v":1},{"$f":"((AQ28>AR28)*1+(AS28>AT28)*1+(AU28>AV28)*1+(AW28>AX28)*1+(AY28>AZ28)*1>1.99)*2+((BB28>BC28)*1+(BD28>BE28)*1+(BF28>BG28)*1+(BH28>BI28)*1+(BJ28>BK28)*1>1.99)*2","v":2},{"$f":"IF(AQ28>AR28,1,0)+IF(AS28>AT28,1,0)+IF(AU28>AV28,1,0)+IF(AW28>AX28,1,0)+IF(AY28>AZ28,1,0)+IF(BB28>BC28,1,0)+IF(BD28>BE28,1,0)+IF(BF28>BG28,1,0)+IF(BH28>BI28,1,0)+IF(BJ28>BK28,1,0)","v":2},{"$f":"IF(AQ28<AR28,1,0)+IF(AS28<AT28,1,0)+IF(AU28<AV28,1,0)+IF(AW28<AX28,1,0)+IF(AY28<AZ28,1,0)+IF(BB28<BC28,1,0)+IF(BD28<BE28,1,0)+IF(BF28<BG28,1,0)+IF(BH28<BI28,1,0)+IF(BJ28<BK28,1,0)","v":0},{"$f":"AJ28-AK28","v":2},25,16,{"$f":"AM28-AN28","v":9},null,{"$f":"O18","v":11},{"$f":"Q18","v":4},{"$f":"S18","v":14},{"$f":"U18","v":12},{"$f":"W18","v":0},{"$f":"Y18","v":0}]
[null,{"$f":"VLOOKUP(AB29,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},null,"-",{"$f":"VLOOKUP(AC29,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},null,null,null,null,2,":",0,null,"(",11,":",7,",",14,":",12,",",null,":",null,")",null,"C3","C4",null,null,null,null,{"$f":"SUM(AH27:AH28)","v":2},4,4,0,4,47,31,16]
[null,{"$f":"VLOOKUP(AB30,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},null,"-",{"$f":"VLOOKUP(AC30,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},null,null,null,null,2,":",0,null,"(",11,":",6,",",11,":",9,",",null,":",null,")",null,"C1","C5",null,"B3",{"$f":"VLOOKUP(AE30,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBT Flums"},1,{"$f":"IF(OR(AQ30>0,AR30>0),1,0)","v":1},{"$f":"((AQ30>AR30)*1+(AS30>AT30)*1+(AU30>AV30)*1+(AW30>AX30)*1+(AY30>AZ30)*1>1.99)*2+((BB30>BC30)*1+(BD30>BE30)*1+(BF30>BG30)*1+(BH30>BI30)*1+(BJ30>BK30)*1>1.99)*2","v":2},{"$f":"IF(AQ30>AR30,1,0)+IF(AS30>AT30,1,0)+IF(AU30>AV30,1,0)+IF(AW30>AX30,1,0)+IF(AY30>AZ30,1,0)+IF(BB30>BC30,1,0)+IF(BD30>BE30,1,0)+IF(BF30>BG30,1,0)+IF(BH30>BI30,1,0)+IF(BJ30>BK30,1,0)","v":2},{"$f":"IF(AQ30<AR30,1,0)+IF(AS30<AT30,1,0)+IF(AU30<AV30,1,0)+IF(AW30<AX30,1,0)+IF(AY30<AZ30,1,0)+IF(BB30<BC30,1,0)+IF(BD30<BE30,1,0)+IF(BF30<BG30,1,0)+IF(BH30<BI30,1,0)+IF(BJ30<BK30,1,0)","v":1},{"$f":"AJ30-AK30","v":1},{"$f":"AQ30+AS30+AU30+BB30+BD30+BF30","v":31},{"$f":"AR30+AT30+AV30+BC30+BE30+BG30","v":27},{"$f":"AM30-AN30","v":4},null,{"$f":"Q19","v":9},{"$f":"O19","v":11},{"$f":"U19","v":11},{"$f":"S19","v":8},{"$f":"Y19","v":11},{"$f":"W19","v":8}]
[null,{"$f":"VLOOKUP(AB31,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},null,"-",{"$f":"VLOOKUP(AC31,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},null,null,null,null,0,":",2,null,"(",8,":",11,",",4,":",11,",",null,":",null,")",null,"C2","C3",null,null,null,2,{"$f":"IF(OR(AQ31>0,AR31>0),1,0)","v":1},{"$f":"((AQ31>AR31)*1+(AS31>AT31)*1+(AU31>AV31)*1+(AW31>AX31)*1+(AY31>AZ31)*1>1.99)*2+((BB31>BC31)*1+(BD31>BE31)*1+(BF31>BG31)*1+(BH31>BI31)*1+(BJ31>BK31)*1>1.99)*2","v":0},0,2,{"$f":"AJ31-AK31","v":-2},16,25,{"$f":"AM31-AN31","v":-9},null,{"$f":"Q18","v":4},{"$f":"O18","v":11},{"$f":"U18","v":12},{"$f":"S18","v":14},{"$f":"Y18","v":0},{"$f":"W18","v":0}]
[null,{"$f":"VLOOKUP(AB32,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},null,"-",{"$f":"VLOOKUP(AC32,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},null,null,null,null,0,":",2,null,"(",5,":",11,",",5,":",11,",",null,":",null,")",null,"C4","C5",null,null,null,null,{"$f":"SUM(AH30:AH31)","v":2},2,2,3,-1,47,52,-5]
[null,{"$f":"VLOOKUP(AB33,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},null,"-",{"$f":"VLOOKUP(AC33,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},null,null,null,null,2,":",0,null,"(",11,":",5,",",11,":",7,",",null,":",null,")",null,"C1","C4"]
[null,{"$f":"VLOOKUP(AB34,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},null,"-",{"$f":"VLOOKUP(AC34,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},null,null,null,null,1,":",1,null,"(",11,":",9,",",8,":",11,",",null,":",null,")",null,"C2","C5",null,"Kontrollsummen",null,null,{"$f":"+AH26+AH29+AH32","v":6},6,7,7,0,136,136,0,null,{"$f":"SUM(AQ24:AQ32)","v":53},53,64,64,19,19,0,0,0,0,null,{"$f":"SUM(BB24:BB32)","v":0},0,0,0,0,0,0,0,0,0]
[null,{"$f":"VLOOKUP(AB35,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},null,"-",{"$f":"VLOOKUP(AC35,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},null,null,null,null,2,":",0,null,"(",11,":",9,",",11,":",6,",",null,":",null,")",null,"C1","C3"]
[null,{"$f":"VLOOKUP(AB36,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},null,"-",{"$f":"VLOOKUP(AC36,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},null,null,null,null,2,":",0,null,"(",11,":",8,",",14,":",12,",",null,":",null,")",null,"C2","C4",null,null,null,"Sp.","Pkte.","Bälle",null,"+/-"]
[null,{"$f":"VLOOKUP(AB37,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},null,"-",{"$f":"VLOOKUP(AC37,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},null,null,null,null,2,":",0,null,"(",11,":",8,",",11,":",9,",",null,":",null,")",null,"C3","C5",null,"1.",{"$f":"$AF$27","v":"FBV Ettenhausen "},{"$f":"$AH$29","v":2},{"$f":"$AI$29","v":4},{"$f":"$AM$29","v":47},{"$f":"$AN$29","v":31},{"$f":"$AO$29","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.",{"$f":"$AF$30","v":"FBT Flums"},{"$f":"$AH$32","v":2},{"$f":"$AI$32","v":2},{"$f":"$AM$32","v":47},{"$f":"$AN$32","v":52},{"$f":"$AO$32","v":-5}]
["Rangliste Gruppe 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,"3.",{"$f":"$AF$24","v":"TS Höchst"},{"$f":"$AH$26","v":2},{"$f":"$AI$26","v":0},{"$f":"$AM$26","v":42},{"$f":"$AN$26","v":53},{"$f":"$AO$26","v":-11}]
[null,"1.",{"$f":"AF72","v":"FG RiWi 1"},null,{"$f":"AG72","v":4},{"$f":"AH72","v":8},{"$f":"AI72","v":88},":",{"$f":"AJ72","v":52}]
[null,"2.",{"$f":"AF73","v":"STV Wigoltingen"},null,4,6,84,":",70]
[null,"3.","JFB Widnau",null,4,3,74,":",73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sp","Pkte","S+","S-","S+/-","B+","B-","B+/-"]
[null,"4.","TS Schwarzach",null,4,3,66,":",84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BR46=0, \"DIREKTE BEGEGNUNG\", \"\")","v":"DIREKTE BEGEGNUNG"},null,null,null,"C1",{"$f":"VLOOKUP(AE43,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},1,{"$f":"IF(OR(AQ43>0,AR43>0),1,0)","v":1},{"$f":"((AQ43>AR43)*1+(AS43>AT43)*1+(AU43>AV43)*1+(AW43>AX43)*1+(AY43>AZ43)*1>1.99)*2+((BB43>BC43)*1+(BD43>BE43)*1+(BF43>BG43)*1+(BH43>BI43)*1+(BJ43>BK43)*1>1.99)*2","v":2},{"$f":"IF(AQ43>AR43,1,0)+IF(AS43>AT43,1,0)+IF(AU43>AV43,1,0)+IF(AW43>AX43,1,0)+IF(AY43>AZ43,1,0)+IF(BB43>BC43,1,0)+IF(BD43>BE43,1,0)+IF(BF43>BG43,1,0)+IF(BH43>BI43,1,0)+IF(BJ43>BK43,1,0)","v":2},{"$f":"IF(AQ43<AR43,1,0)+IF(AS43<AT43,1,0)+IF(AU43<AV43,1,0)+IF(AW43<AX43,1,0)+IF(AY43<AZ43,1,0)+IF(BB43<BC43,1,0)+IF(BD43<BE43,1,0)+IF(BF43<BG43,1,0)+IF(BH43<BI43,1,0)+IF(BJ43<BK43,1,0)","v":0},{"$f":"AJ43-AK43","v":2},{"$f":"AQ43+AS43+AU43+BB43+BD43+BF43","v":22},{"$f":"AR43+AT43+AV43+BC43+BE43+BG43","v":10},{"$f":"AM43-AN43","v":12},null,{"$f":"O28","v":11},{"$f":"Q28","v":6},{"$f":"S28","v":11},{"$f":"U28","v":4},{"$f":"W28","v":0},{"$f":"Y28","v":0}]
[null,"5.","Satus Kreuzlingen",null,4,0,61,":",94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(OR(AQ44>0,AR44>0),1,0)","v":1},{"$f":"((AQ44>AR44)*1+(AS44>AT44)*1+(AU44>AV44)*1+(AW44>AX44)*1+(AY44>AZ44)*1>1.99)*2+((BB44>BC44)*1+(BD44>BE44)*1+(BF44>BG44)*1+(BH44>BI44)*1+(BJ44>BK44)*1>1.99)*2","v":2},{"$f":"IF(AQ44>AR44,1,0)+IF(AS44>AT44,1,0)+IF(AU44>AV44,1,0)+IF(AW44>AX44,1,0)+IF(AY44>AZ44,1,0)+IF(BB44>BC44,1,0)+IF(BD44>BE44,1,0)+IF(BF44>BG44,1,0)+IF(BH44>BI44,1,0)+IF(BJ44>BK44,1,0)","v":2},{"$f":"IF(AQ44<AR44,1,0)+IF(AS44<AT44,1,0)+IF(AU44<AV44,1,0)+IF(AW44<AX44,1,0)+IF(AY44<AZ44,1,0)+IF(BB44<BC44,1,0)+IF(BD44<BE44,1,0)+IF(BF44<BG44,1,0)+IF(BH44<BI44,1,0)+IF(BJ44<BK44,1,0)","v":0},{"$f":"AJ44-AK44","v":2},22,15,{"$f":"AM44-AN44","v":7},null,{"$f":"O35","v":11},{"$f":"Q35","v":9},{"$f":"S35","v":11},{"$f":"U35","v":6},{"$f":"W35","v":0},{"$f":"Y35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direkte Begegnung Gruppe 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,3,{"$f":"IF(OR(AQ45>0,AR45>0),1,0)","v":1},{"$f":"((AQ45>AR45)*1+(AS45>AT45)*1+(AU45>AV45)*1+(AW45>AX45)*1+(AY45>AZ45)*1>1.99)*2+((BB45>BC45)*1+(BD45>BE45)*1+(BF45>BG45)*1+(BH45>BI45)*1+(BJ45>BK45)*1>1.99)*2","v":2},2,0,{"$f":"AJ45-AK45","v":2},22,12,{"$f":"AM45-AN45","v":10},null,{"$f":"O33","v":11},{"$f":"Q33","v":5},{"$f":"S33","v":11},{"$f":"U33","v":7},{"$f":"W33","v":0},{"$f":"Y33","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,4,{"$f":"IF(OR(AQ46>0,AR46>0),1,0)","v":1},{"$f":"((AQ46>AR46)*1+(AS46>AT46)*1+(AU46>AV46)*1+(AW46>AX46)*1+(AY46>AZ46)*1>1.99)*2+((BB46>BC46)*1+(BD46>BE46)*1+(BF46>BG46)*1+(BH46>BI46)*1+(BJ46>BK46)*1>1.99)*2","v":2},2,0,{"$f":"AJ46-AK46","v":2},22,15,{"$f":"AM46-AN46","v":7},null,{"$f":"O30","v":11},{"$f":"Q30","v":6},{"$f":"S30","v":11},{"$f":"U30","v":9},{"$f":"W30","v":0},{"$f":"Y30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$40-$F$41","v":2},{"$f":"$F$41-$F$42","v":3},{"$f":"$F$42-$F$43","v":0},{"$f":"$F$43-$F$44","v":3},null,{"$f":"MIN(BM46:BQ46)","v":0}]
[{"$f":"A1","v":"Ostschweizer Meisterschaft Halle 2019/2020 - Kat. U14"},null,null,null,null,null,null,null,null,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":"SUM(AH43:AH46)","v":4},{"$f":"SUM(AI43:AI46)","v":8},8,0,8,88,52,36]
[{"$f":"A2","v":"So. 15.12.2019 / Aadorf, Löhracker"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C2",{"$f":"VLOOKUP(AE48,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},1,{"$f":"IF(OR(AQ48>0,AR48>0),1,0)","v":1},{"$f":"((AQ48>AR48)*1+(AS48>AT48)*1+(AU48>AV48)*1+(AW48>AX48)*1+(AY48>AZ48)*1>1.99)*2+((BB48>BC48)*1+(BD48>BE48)*1+(BF48>BG48)*1+(BH48>BI48)*1+(BJ48>BK48)*1>1.99)*2","v":0},{"$f":"IF(AQ48>AR48,1,0)+IF(AS48>AT48,1,0)+IF(AU48>AV48,1,0)+IF(AW48>AX48,1,0)+IF(AY48>AZ48,1,0)+IF(BB48>BC48,1,0)+IF(BD48>BE48,1,0)+IF(BF48>BG48,1,0)+IF(BH48>BI48,1,0)+IF(BJ48>BK48,1,0)","v":0},{"$f":"IF(AQ48<AR48,1,0)+IF(AS48<AT48,1,0)+IF(AU48<AV48,1,0)+IF(AW48<AX48,1,0)+IF(AY48<AZ48,1,0)+IF(BB48<BC48,1,0)+IF(BD48<BE48,1,0)+IF(BF48<BG48,1,0)+IF(BH48<BI48,1,0)+IF(BJ48<BK48,1,0)","v":2},{"$f":"AJ48-AK48","v":-2},{"$f":"AQ48+AS48+AU48+BB48+BD48+BF48","v":10},{"$f":"AR48+AT48+AV48+BC48+BE48+BG48","v":22},{"$f":"AM48-AN48","v":-12},null,{"$f":"Q28","v":6},{"$f":"O28","v":11},{"$f":"U28","v":4},{"$f":"S28","v":11},{"$f":"Y28","v":0},{"$f":"W28","v":0}]
[{"$f":"A3","v":"Finalrunde"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(OR(AQ49>0,AR49>0),1,0)","v":1},{"$f":"((AQ49>AR49)*1+(AS49>AT49)*1+(AU49>AV49)*1+(AW49>AX49)*1+(AY49>AZ49)*1>1.99)*2+((BB49>BC49)*1+(BD49>BE49)*1+(BF49>BG49)*1+(BH49>BI49)*1+(BJ49>BK49)*1>1.99)*2","v":2},{"$f":"IF(AQ49>AR49,1,0)+IF(AS49>AT49,1,0)+IF(AU49>AV49,1,0)+IF(AW49>AX49,1,0)+IF(AY49>AZ49,1,0)+IF(BB49>BC49,1,0)+IF(BD49>BE49,1,0)+IF(BF49>BG49,1,0)+IF(BH49>BI49,1,0)+IF(BJ49>BK49,1,0)","v":2},{"$f":"IF(AQ49<AR49,1,0)+IF(AS49<AT49,1,0)+IF(AU49<AV49,1,0)+IF(AW49<AX49,1,0)+IF(AY49<AZ49,1,0)+IF(BB49<BC49,1,0)+IF(BD49<BE49,1,0)+IF(BF49<BG49,1,0)+IF(BH49<BI49,1,0)+IF(BJ49<BK49,1,0)","v":0},{"$f":"AJ49-AK49","v":2},25,20,{"$f":"AM49-AN49","v":5},null,{"$f":"O36","v":11},{"$f":"Q36","v":8},{"$f":"S36","v":14},{"$f":"U36","v":12},{"$f":"W36","v":0},{"$f":"Y36","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,3,{"$f":"IF(OR(AQ50>0,AR50>0),1,0)","v":1},{"$f":"((AQ50>AR50)*1+(AS50>AT50)*1+(AU50>AV50)*1+(AW50>AX50)*1+(AY50>AZ50)*1>1.99)*2+((BB50>BC50)*1+(BD50>BE50)*1+(BF50>BG50)*1+(BH50>BI50)*1+(BJ50>BK50)*1>1.99)*2","v":0},0,2,{"$f":"AJ50-AK50","v":-2},12,22,{"$f":"AM50-AN50","v":-10},null,{"$f":"O31","v":8},{"$f":"Q31","v":11},{"$f":"S31","v":4},{"$f":"U31","v":11},{"$f":"W31","v":0},{"$f":"Y31","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,4,{"$f":"IF(OR(AQ51>0,AR51>0),1,0)","v":1},{"$f":"((AQ51>AR51)*1+(AS51>AT51)*1+(AU51>AV51)*1+(AW51>AX51)*1+(AY51>AZ51)*1>1.99)*2+((BB51>BC51)*1+(BD51>BE51)*1+(BF51>BG51)*1+(BH51>BI51)*1+(BJ51>BK51)*1>1.99)*2","v":0},1,1,{"$f":"AJ51-AK51","v":0},19,20,{"$f":"AM51-AN51","v":-1},null,{"$f":"O34","v":11},{"$f":"Q34","v":9},{"$f":"S34","v":8},{"$f":"U34","v":11},{"$f":"W34","v":0},{"$f":"Y34","v":0}]
[null,"Viertelfinals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S","V",null,null,null,null,{"$f":"SUM(AH48:AH51)","v":4},{"$f":"SUM(AI48:AI51)","v":2},{"$f":"SUM(AJ48:AJ51)","v":3},{"$f":"SUM(AK48:AK51)","v":5},{"$f":"SUM(AL48:AL51)","v":-2},{"$f":"SUM(AM48:AM51)","v":66},{"$f":"SUM(AN48:AN51)","v":84},{"$f":"SUM(AO48:AO51)","v":-18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C3",{"$f":"VLOOKUP(AE53,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},1,{"$f":"IF(OR(AQ53>0,AR53>0),1,0)","v":1},{"$f":"((AQ53>AR53)*1+(AS53>AT53)*1+(AU53>AV53)*1+(AW53>AX53)*1+(AY53>AZ53)*1>1.99)*2+((BB53>BC53)*1+(BD53>BE53)*1+(BF53>BG53)*1+(BH53>BI53)*1+(BJ53>BK53)*1>1.99)*2","v":2},{"$f":"IF(AQ53>AR53,1,0)+IF(AS53>AT53,1,0)+IF(AU53>AV53,1,0)+IF(AW53>AX53,1,0)+IF(AY53>AZ53,1,0)+IF(BB53>BC53,1,0)+IF(BD53>BE53,1,0)+IF(BF53>BG53,1,0)+IF(BH53>BI53,1,0)+IF(BJ53>BK53,1,0)","v":2},{"$f":"IF(AQ53<AR53,1,0)+IF(AS53<AT53,1,0)+IF(AU53<AV53,1,0)+IF(AW53<AX53,1,0)+IF(AY53<AZ53,1,0)+IF(BB53<BC53,1,0)+IF(BD53<BE53,1,0)+IF(BF53<BG53,1,0)+IF(BH53<BI53,1,0)+IF(BJ53<BK53,1,0)","v":0},{"$f":"AJ53-AK53","v":2},{"$f":"AQ53+AS53+AU53+BB53+BD53+BF53","v":25},{"$f":"AR53+AT53+AV53+BC53+BE53+BG53","v":19},{"$f":"AM53-AN53","v":6},null,{"$f":"O29","v":11},{"$f":"Q29","v":7},{"$f":"S29","v":14},{"$f":"U29","v":12},{"$f":"W29","v":0},{"$f":"Y29","v":0}]
["VF1",{"$f":"C12","v":"STV Affeltrangen"},null,"-",{"$f":"C24","v":"TS Höchst"},null,null,null,null,2,":",0,null,"(",11,":",3,",",11,":",6,",",null,":",null,")",null,{"$f":"IF(L54=2,E54,(IF(J54=2,B54,\"Sieger VF1\")))","v":"STV Affeltrangen"},{"$f":"IF(AB54=B54,E54,(IF(AB54=E54,B54,\"Verlierer VF1\")))","v":"TS Höchst"},null,null,null,2,{"$f":"IF(OR(AQ54>0,AR54>0),1,0)","v":1},{"$f":"((AQ54>AR54)*1+(AS54>AT54)*1+(AU54>AV54)*1+(AW54>AX54)*1+(AY54>AZ54)*1>1.99)*2+((BB54>BC54)*1+(BD54>BE54)*1+(BF54>BG54)*1+(BH54>BI54)*1+(BJ54>BK54)*1>1.99)*2","v":0},{"$f":"IF(AQ54>AR54,1,0)+IF(AS54>AT54,1,0)+IF(AU54>AV54,1,0)+IF(AW54>AX54,1,0)+IF(AY54>AZ54,1,0)+IF(BB54>BC54,1,0)+IF(BD54>BE54,1,0)+IF(BF54>BG54,1,0)+IF(BH54>BI54,1,0)+IF(BJ54>BK54,1,0)","v":0},{"$f":"IF(AQ54<AR54,1,0)+IF(AS54<AT54,1,0)+IF(AU54<AV54,1,0)+IF(AW54<AX54,1,0)+IF(AY54<AZ54,1,0)+IF(BB54<BC54,1,0)+IF(BD54<BE54,1,0)+IF(BF54<BG54,1,0)+IF(BH54<BI54,1,0)+IF(BJ54<BK54,1,0)","v":2},{"$f":"AJ54-AK54","v":-2},15,22,{"$f":"AM54-AN54","v":-7},null,{"$f":"Q35","v":9},{"$f":"O35","v":11},{"$f":"U35","v":6},{"$f":"S35","v":11},{"$f":"Y35","v":0},{"$f":"W35","v":0}]
[null,"(2. Gruppe A)",null,null,"(3. Gruppe 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,3,{"$f":"IF(OR(AQ55>0,AR55>0),1,0)","v":1},{"$f":"((AQ55>AR55)*1+(AS55>AT55)*1+(AU55>AV55)*1+(AW55>AX55)*1+(AY55>AZ55)*1>1.99)*2+((BB55>BC55)*1+(BD55>BE55)*1+(BF55>BG55)*1+(BH55>BI55)*1+(BJ55>BK55)*1>1.99)*2","v":2},2,0,{"$f":"AJ55-AK55","v":2},22,12,{"$f":"AM55-AN55","v":10},null,{"$f":"Q31","v":11},{"$f":"O31","v":8},{"$f":"U31","v":11},{"$f":"S31","v":4},{"$f":"Y31","v":0},{"$f":"W31","v":0}]
["VF2",{"$f":"C23","v":"FBT Flums"},null,"-",{"$f":"C13","v":"SVD Diepoldsau"},null,null,null,null,1,":",2,null,"(",11,":",6,",",11,":",13,",",9,":",11,")",null,{"$f":"IF(L56=2,E56,(IF(J56=2,B56,\"Sieger VF2\")))","v":"SVD Diepoldsau"},{"$f":"IF(AB56=B56,E56,(IF(AB56=E56,B56,\"Verlierer VF2\")))","v":"FBT Flums"},null,null,null,4,{"$f":"IF(OR(AQ56>0,AR56>0),1,0)","v":1},{"$f":"((AQ56>AR56)*1+(AS56>AT56)*1+(AU56>AV56)*1+(AW56>AX56)*1+(AY56>AZ56)*1>1.99)*2+((BB56>BC56)*1+(BD56>BE56)*1+(BF56>BG56)*1+(BH56>BI56)*1+(BJ56>BK56)*1>1.99)*2","v":2},2,0,{"$f":"AJ56-AK56","v":2},22,17,{"$f":"AM56-AN56","v":5},null,{"$f":"O37","v":11},{"$f":"Q37","v":8},{"$f":"S37","v":11},{"$f":"U37","v":9},{"$f":"W37","v":0},{"$f":"Y37","v":0}]
[null,"(2. Gruppe B)",null,null,"(3. Gruppe 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,{"$f":"SUM(AH53:AH56)","v":4},{"$f":"SUM(AI53:AI56)","v":6},{"$f":"SUM(AJ53:AJ56)","v":6},{"$f":"SUM(AK53:AK56)","v":2},{"$f":"SUM(AL53:AL56)","v":4},{"$f":"SUM(AM53:AM56)","v":84},{"$f":"SUM(AN53:AN56)","v":70},{"$f":"SUM(AO53:AO56)","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C4",{"$f":"VLOOKUP(AE58,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},1,{"$f":"IF(OR(AQ58>0,AR58>0),1,0)","v":1},{"$f":"((AQ58>AR58)*1+(AS58>AT58)*1+(AU58>AV58)*1+(AW58>AX58)*1+(AY58>AZ58)*1>1.99)*2+((BB58>BC58)*1+(BD58>BE58)*1+(BF58>BG58)*1+(BH58>BI58)*1+(BJ58>BK58)*1>1.99)*2","v":0},{"$f":"IF(AQ58>AR58,1,0)+IF(AS58>AT58,1,0)+IF(AU58>AV58,1,0)+IF(AW58>AX58,1,0)+IF(AY58>AZ58,1,0)+IF(BB58>BC58,1,0)+IF(BD58>BE58,1,0)+IF(BF58>BG58,1,0)+IF(BH58>BI58,1,0)+IF(BJ58>BK58,1,0)","v":0},{"$f":"IF(AQ58<AR58,1,0)+IF(AS58<AT58,1,0)+IF(AU58<AV58,1,0)+IF(AW58<AX58,1,0)+IF(AY58<AZ58,1,0)+IF(BB58<BC58,1,0)+IF(BD58<BE58,1,0)+IF(BF58<BG58,1,0)+IF(BH58<BI58,1,0)+IF(BJ58<BK58,1,0)","v":2},{"$f":"AJ58-AK58","v":-2},{"$f":"AQ58+AS58+AU58+BB58+BD58+BF58","v":19},{"$f":"AR58+AT58+AV58+BC58+BE58+BG58","v":25},{"$f":"AM58-AN58","v":-6},null,{"$f":"Q29","v":7},{"$f":"O29","v":11},{"$f":"U29","v":12},{"$f":"S29","v":14},{"$f":"Y29","v":0},{"$f":"W29","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,2,{"$f":"IF(OR(AQ59>0,AR59>0),1,0)","v":1},{"$f":"((AQ59>AR59)*1+(AS59>AT59)*1+(AU59>AV59)*1+(AW59>AX59)*1+(AY59>AZ59)*1>1.99)*2+((BB59>BC59)*1+(BD59>BE59)*1+(BF59>BG59)*1+(BH59>BI59)*1+(BJ59>BK59)*1>1.99)*2","v":0},{"$f":"IF(AQ59>AR59,1,0)+IF(AS59>AT59,1,0)+IF(AU59>AV59,1,0)+IF(AW59>AX59,1,0)+IF(AY59>AZ59,1,0)+IF(BB59>BC59,1,0)+IF(BD59>BE59,1,0)+IF(BF59>BG59,1,0)+IF(BH59>BI59,1,0)+IF(BJ59>BK59,1,0)","v":0},{"$f":"IF(AQ59<AR59,1,0)+IF(AS59<AT59,1,0)+IF(AU59<AV59,1,0)+IF(AW59<AX59,1,0)+IF(AY59<AZ59,1,0)+IF(BB59<BC59,1,0)+IF(BD59<BE59,1,0)+IF(BF59<BG59,1,0)+IF(BH59<BI59,1,0)+IF(BJ59<BK59,1,0)","v":2},{"$f":"AJ59-AK59","v":-2},20,25,{"$f":"AM59-AN59","v":-5},null,{"$f":"Q36","v":8},{"$f":"O36","v":11},{"$f":"U36","v":12},{"$f":"S36","v":14},{"$f":"Y36","v":0},{"$f":"W36","v":0}]
[null,"Halbfinals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(OR(AQ60>0,AR60>0),1,0)","v":1},{"$f":"((AQ60>AR60)*1+(AS60>AT60)*1+(AU60>AV60)*1+(AW60>AX60)*1+(AY60>AZ60)*1>1.99)*2+((BB60>BC60)*1+(BD60>BE60)*1+(BF60>BG60)*1+(BH60>BI60)*1+(BJ60>BK60)*1>1.99)*2","v":0},0,2,{"$f":"AJ60-AK60","v":-2},10,22,{"$f":"AM60-AN60","v":-12},null,{"$f":"O32","v":5},{"$f":"Q32","v":11},{"$f":"S32","v":5},{"$f":"U32","v":11},{"$f":"W32","v":0},{"$f":"Y32","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,4,{"$f":"IF(OR(AQ61>0,AR61>0),1,0)","v":1},{"$f":"((AQ61>AR61)*1+(AS61>AT61)*1+(AU61>AV61)*1+(AW61>AX61)*1+(AY61>AZ61)*1>1.99)*2+((BB61>BC61)*1+(BD61>BE61)*1+(BF61>BG61)*1+(BH61>BI61)*1+(BJ61>BK61)*1>1.99)*2","v":0},0,2,{"$f":"AJ61-AK61","v":-2},12,22,{"$f":"AM61-AN61","v":-10},null,{"$f":"Q33","v":5},{"$f":"O33","v":11},{"$f":"U33","v":7},{"$f":"S33","v":11},{"$f":"Y33","v":0},{"$f":"W33","v":0}]
["HF1",{"$f":"C11","v":"FG RiWi 2"},null,"-",{"$f":"AB56","v":"SVD Diepoldsau"},null,null,null,null,2,":",0,null,"(",11,":",8,",",11,":",9,",",null,":",null,")",null,{"$f":"IF(L62=2,E62,(IF(J62=2,B62,\"Sieger HF1\")))","v":"FG RiWi 2"},{"$f":"IF(AB62=B62,E62,(IF(AB62=E62,B62,\"Verlierer HF1\")))","v":"SVD Diepoldsau"},null,null,null,null,{"$f":"SUM(AH58:AH61)","v":4},{"$f":"SUM(AI58:AI61)","v":0},0,8,-8,61,94,-33]
[null,"(1. Gruppe A)",null,null,"(Sieger VF2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C5",{"$f":"VLOOKUP(AE63,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},1,{"$f":"IF(OR(AQ63>0,AR63>0),1,0)","v":1},{"$f":"((AQ63>AR63)*1+(AS63>AT63)*1+(AU63>AV63)*1+(AW63>AX63)*1+(AY63>AZ63)*1>1.99)*2+((BB63>BC63)*1+(BD63>BE63)*1+(BF63>BG63)*1+(BH63>BI63)*1+(BJ63>BK63)*1>1.99)*2","v":0},{"$f":"IF(AQ63>AR63,1,0)+IF(AS63>AT63,1,0)+IF(AU63>AV63,1,0)+IF(AW63>AX63,1,0)+IF(AY63>AZ63,1,0)+IF(BB63>BC63,1,0)+IF(BD63>BE63,1,0)+IF(BF63>BG63,1,0)+IF(BH63>BI63,1,0)+IF(BJ63>BK63,1,0)","v":0},{"$f":"IF(AQ63<AR63,1,0)+IF(AS63<AT63,1,0)+IF(AU63<AV63,1,0)+IF(AW63<AX63,1,0)+IF(AY63<AZ63,1,0)+IF(BB63<BC63,1,0)+IF(BD63<BE63,1,0)+IF(BF63<BG63,1,0)+IF(BH63<BI63,1,0)+IF(BJ63<BK63,1,0)","v":2},{"$f":"AJ63-AK63","v":-2},{"$f":"AQ63+AS63+AU63+BB63+BD63+BF63","v":15},{"$f":"AR63+AT63+AV63+BC63+BE63+BG63","v":22},{"$f":"AM63-AN63","v":-7},null,{"$f":"Q30","v":6},{"$f":"O30","v":11},{"$f":"U30","v":9},{"$f":"S30","v":11},{"$f":"Y30","v":0},{"$f":"W30","v":0}]
["HF2",{"$f":"C22","v":"FBV Ettenhausen "},null,"-",{"$f":"AB54","v":"STV Affeltrangen"},null,null,null,null,2,":",0,null,"(",12,":",10,",",11,":",0,",",null,":",null,")",null,{"$f":"IF(L64=2,E64,(IF(J64=2,B64,\"Sieger HF2\")))","v":"FBV Ettenhausen "},{"$f":"IF(AB64=B64,E64,(IF(AB64=E64,B64,\"Verlierer HF2\")))","v":"STV Affeltrangen"},null,null,null,2,{"$f":"IF(OR(AQ64>0,AR64>0),1,0)","v":1},{"$f":"((AQ64>AR64)*1+(AS64>AT64)*1+(AU64>AV64)*1+(AW64>AX64)*1+(AY64>AZ64)*1>1.99)*2+((BB64>BC64)*1+(BD64>BE64)*1+(BF64>BG64)*1+(BH64>BI64)*1+(BJ64>BK64)*1>1.99)*2","v":2},{"$f":"IF(AQ64>AR64,1,0)+IF(AS64>AT64,1,0)+IF(AU64>AV64,1,0)+IF(AW64>AX64,1,0)+IF(AY64>AZ64,1,0)+IF(BB64>BC64,1,0)+IF(BD64>BE64,1,0)+IF(BF64>BG64,1,0)+IF(BH64>BI64,1,0)+IF(BJ64>BK64,1,0)","v":2},{"$f":"IF(AQ64<AR64,1,0)+IF(AS64<AT64,1,0)+IF(AU64<AV64,1,0)+IF(AW64<AX64,1,0)+IF(AY64<AZ64,1,0)+IF(BB64<BC64,1,0)+IF(BD64<BE64,1,0)+IF(BF64<BG64,1,0)+IF(BH64<BI64,1,0)+IF(BJ64<BK64,1,0)","v":0},{"$f":"AJ64-AK64","v":2},22,10,{"$f":"AM64-AN64","v":12},null,{"$f":"Q32","v":11},{"$f":"O32","v":5},{"$f":"U32","v":11},{"$f":"S32","v":5},{"$f":"Y32","v":0},{"$f":"W32","v":0}]
[null,"(1. Gruppe B)",null,null,"(Sieger VF1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(OR(AQ65>0,AR65>0),1,0)","v":1},{"$f":"((AQ65>AR65)*1+(AS65>AT65)*1+(AU65>AV65)*1+(AW65>AX65)*1+(AY65>AZ65)*1>1.99)*2+((BB65>BC65)*1+(BD65>BE65)*1+(BF65>BG65)*1+(BH65>BI65)*1+(BJ65>BK65)*1>1.99)*2","v":0},1,1,{"$f":"AJ65-AK65","v":0},20,19,{"$f":"AM65-AN65","v":1},null,{"$f":"Q34","v":9},{"$f":"O34","v":11},{"$f":"U34","v":11},{"$f":"S34","v":8},{"$f":"Y34","v":0},{"$f":"W34","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,4,{"$f":"IF(OR(AQ66>0,AR66>0),1,0)","v":1},{"$f":"((AQ66>AR66)*1+(AS66>AT66)*1+(AU66>AV66)*1+(AW66>AX66)*1+(AY66>AZ66)*1>1.99)*2+((BB66>BC66)*1+(BD66>BE66)*1+(BF66>BG66)*1+(BH66>BI66)*1+(BJ66>BK66)*1>1.99)*2","v":0},0,2,{"$f":"AJ66-AK66","v":-2},17,22,{"$f":"AM66-AN66","v":-5},null,{"$f":"Q37","v":8},{"$f":"O37","v":11},{"$f":"U37","v":9},{"$f":"S37","v":11},{"$f":"Y37","v":0},{"$f":"W37","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,{"$f":"SUM(AH63:AH66)","v":4},{"$f":"SUM(AI63:AI66)","v":2},3,5,-2,74,73,1]
[null,"Platzierungsspiele"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontrollsummen"]
["5/6",{"$f":"AC54","v":"TS Höchst"},null,"-",{"$f":"AC56","v":"FBT Flums"},null,null,null,null,2,":",0,null,"(",11,":",6,",",11,":",4,",",null,":",null,")",null,{"$f":"IF(L70=2,E70,(IF(J70=2,B70,\"5. Rang\")))","v":"TS Höchst"},{"$f":"IF(AB70=B70,E70,(IF(AB70=E70,B70,\"6. Rang\")))","v":"FBT Flums"}]
[null,"(Verlierer VF1)",null,null,"(Verlierer VF2)"]
["3/4",{"$f":"AC62","v":"SVD Diepoldsau"},null,"-",{"$f":"AC64","v":"STV Affeltrangen"},null,null,null,null,2,":",0,null,"(",11,":",6,",",11,":",9,",",null,":",null,")",null,{"$f":"IF(L72=2,E72,(IF(J72=2,B72,\"3. Rang\")))","v":"SVD Diepoldsau"},{"$f":"IF(AB72=B72,E72,(IF(AB72=E72,B72,\"4. Rang\")))","v":"STV Affeltrangen"},null,"1.",{"$f":"$AF$43","v":"FG RiWi 1"},{"$f":"$AH$47","v":4},{"$f":"$AJ$47","v":8},{"$f":"$AM$47","v":88},{"$f":"$AN$47","v":52},{"$f":"$AO$47","v":36}]
[null,"(Verlierer HF1)",null,null,"(Verlierer HF2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.",{"$f":"$AF$53","v":"STV Wigoltingen"},{"$f":"$AH$57","v":4},{"$f":"$AJ$57","v":6},{"$f":"$AM$57","v":84},{"$f":"$AN$57","v":70},{"$f":"$AO$57","v":14}]
["1/2",{"$f":"AB62","v":"FG RiWi 2"},null,"-",{"$f":"AB64","v":"FBV Ettenhausen "},null,null,null,null,0,":",2,null,"(",9,":",11,",",7,":",11,",",null,":",null,")",null,{"$f":"IF(L74=2,E74,(IF(J74=2,B74,\"1. Rang\")))","v":"FBV Ettenhausen "},{"$f":"IF(AB74=B74,E74,(IF(AB74=E74,B74,\"2. Rang\")))","v":"FG RiWi 2"},null,"5.",{"$f":"$AF$63","v":"JFB Widnau"},{"$f":"$AH$67","v":4},{"$f":"$AJ$67","v":3},{"$f":"$AM$67","v":74},{"$f":"$AN$67","v":73},{"$f":"$AO$67","v":1}]
[null,"(Sieger HF1)",null,null,"(Sieger HF2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.",{"$f":"$AF$48","v":"TS Schwarzach"},{"$f":"$AH$52","v":4},{"$f":"$AJ$52","v":3},{"$f":"$AM$52","v":66},{"$f":"$AN$52","v":84},{"$f":"$AO$52","v":-18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.",{"$f":"$AF$58","v":"Satus Kreuzlingen"},{"$f":"$AH$62","v":4},{"$f":"$AJ$62","v":0},{"$f":"$AM$62","v":61},{"$f":"$AN$62","v":94},{"$f":"$AO$62","v":-33}]

{"sheet":"Schlussrangliste","index":5,"n_rows":51,"n_cols":63,"rows_kept":51,"cut":false,"hidden":false,"merged":[[37,30,41,30],[37,31,41,31],[45,34,45,35],[22,30,26,30],[22,31,26,31],[27,30,31,30],[27,31,31,31],[32,30,36,30],[32,31,36,31]]}
[{"$f":"CONCATENATE(MASTER!B1, \" \", MASTER!B8, \" - Kat. \", MASTER!B10)","v":"Ostschweizer Meisterschaft Halle 2019/2020 - Kat. U14"},null,null,null,null,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":"TODAY()","v":"2019-12-15"}]
[{"$f":"CONCATENATE(MASTER!B3,\" / \",MASTER!C3)","v":"So. 15.12.2019 / Aadorf, Löhracker"}]
[]
[]
[]
[null,"Schlussrangliste"]
[]
[]
[null,"1.",{"$f":"CONCATENATE('Resultate VR'!AB74,\" (OSTSCHWEIZERMEISTER)\")","v":"FBV Ettenhausen  (OSTSCHWEIZERMEISTER)"}]
[null,"2.",{"$f":"'Resultate VR'!AC74","v":"FG RiWi 2"}]
[null,"3.",{"$f":"'Resultate VR'!AB72","v":"SVD Diepoldsau"}]
[null,"4.",{"$f":"'Resultate VR'!AC72","v":"STV Affeltrangen"}]
[null,"5.",{"$f":"'Resultate VR'!AB70","v":"TS Höchst"}]
[null,"6.",{"$f":"'Resultate VR'!AC70","v":"FBT Flums"}]
[null,"7.",{"$f":"'Resultate VR'!C40","v":"FG RiWi 1"}]
[null,"8.",{"$f":"'Resultate VR'!C41","v":"STV Wigoltingen"}]
[null,"9.",{"$f":"'Resultate VR'!C42","v":"JFB Widnau"}]
[null,"10.",{"$f":"'Resultate VR'!C43","v":"TS Schwarzach"}]
[null,"11.",{"$f":"'Resultate VR'!C44","v":"Satus Kreuzlingen"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sp","Pkte","S+","S-","S+/-","B+","B-","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,"B2",{"$f":"VLOOKUP(AE23,Gruppeneinteilung!$A$5:$B$13,2,0)","v":"FBV Ettenhausen "},1,{"$f":"(COUNTIFS(AQ23,\">0\"))+(COUNTIFS(AR23,\">0\"))","v":0},{"$f":"((AQ23>AR23)*1+(AS23>AT23)*1+(AU23>AV23)*1+(AW23>AX23)*1+(AY23>AZ23)*1>1.99)*2+((BB23>BC23)*1+(BD23>BE23)*1+(BF23>BG23)*1+(BH23>BI23)*1+(BJ23>BK23)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ23>AR23,1,0)+IF(AS23>AT23,1,0)+IF(AU23>AV23,1,0)+IF(AW23>AX23,1,0)+IF(AY23>AZ23,1,0)+IF(BB23>BC23,1,0)+IF(BD23>BE23,1,0)+IF(BF23>BG23,1,0)+IF(BH23>BI23,1,0)+IF(BJ23>BK23,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ23<AR23,1,0)+IF(AS23<AT23,1,0)+IF(AU23<AV23,1,0)+IF(AW23<AX23,1,0)+IF(AY23<AZ23,1,0)+IF(BB23<BC23,1,0)+IF(BD23<BE23,1,0)+IF(BF23<BG23,1,0)+IF(BH23<BI23,1,0)+IF(BJ23<BK23,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ23-AK23","v":{"$error":"#REF!"}},{"$f":"AQ23+AS23+AU23+BB23+BD23+BF23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"AM23-AN23","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(COUNTIFS(AQ24,\">0\"))+(COUNTIFS(AR24,\">0\"))","v":0},{"$f":"((AQ24>AR24)*1+(AS24>AT24)*1+(AU24>AV24)*1+(AW24>AX24)*1+(AY24>AZ24)*1>1.99)*2+((BB24>BC24)*1+(BD24>BE24)*1+(BF24>BG24)*1+(BH24>BI24)*1+(BJ24>BK24)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ24>AR24,1,0)+IF(AS24>AT24,1,0)+IF(AU24>AV24,1,0)+IF(AW24>AX24,1,0)+IF(AY24>AZ24,1,0)+IF(BB24>BC24,1,0)+IF(BD24>BE24,1,0)+IF(BF24>BG24,1,0)+IF(BH24>BI24,1,0)+IF(BJ24>BK24,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ24<AR24,1,0)+IF(AS24<AT24,1,0)+IF(AU24<AV24,1,0)+IF(AW24<AX24,1,0)+IF(AY24<AZ24,1,0)+IF(BB24<BC24,1,0)+IF(BD24<BE24,1,0)+IF(BF24<BG24,1,0)+IF(BH24<BI24,1,0)+IF(BJ24<BK24,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ24-AK24","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM24-AN24","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,{"$f":"((AQ25>AR25)*1+(AS25>AT25)*1+(AU25>AV25)*1+(AW25>AX25)*1+(AY25>AZ25)*1>1.99)*2+((BB25>BC25)*1+(BD25>BE25)*1+(BF25>BG25)*1+(BH25>BI25)*1+(BJ25>BK25)*1>1.99)*2","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AJ25-AK25","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM25-AN25","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,{"$f":"((AQ26>AR26)*1+(AS26>AT26)*1+(AU26>AV26)*1+(AW26>AX26)*1+(AY26>AZ26)*1>1.99)*2+((BB26>BC26)*1+(BD26>BE26)*1+(BF26>BG26)*1+(BH26>BI26)*1+(BJ26>BK26)*1>1.99)*2","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AJ26-AK26","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM26-AN26","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,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":"SUM(AH23:AH26)","v":0},{"$f":"SUM(AI23:AI26)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B3",{"$f":"VLOOKUP(AE28,Gruppeneinteilung!$A$5:$B$13,2,0)","v":"FBT Flums"},1,{"$f":"(COUNTIFS(AQ28,\">0\"))+(COUNTIFS(AR28,\">0\"))","v":0},{"$f":"((AQ28>AR28)*1+(AS28>AT28)*1+(AU28>AV28)*1+(AW28>AX28)*1+(AY28>AZ28)*1>1.99)*2+((BB28>BC28)*1+(BD28>BE28)*1+(BF28>BG28)*1+(BH28>BI28)*1+(BJ28>BK28)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ28>AR28,1,0)+IF(AS28>AT28,1,0)+IF(AU28>AV28,1,0)+IF(AW28>AX28,1,0)+IF(AY28>AZ28,1,0)+IF(BB28>BC28,1,0)+IF(BD28>BE28,1,0)+IF(BF28>BG28,1,0)+IF(BH28>BI28,1,0)+IF(BJ28>BK28,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ28<AR28,1,0)+IF(AS28<AT28,1,0)+IF(AU28<AV28,1,0)+IF(AW28<AX28,1,0)+IF(AY28<AZ28,1,0)+IF(BB28<BC28,1,0)+IF(BD28<BE28,1,0)+IF(BF28<BG28,1,0)+IF(BH28<BI28,1,0)+IF(BJ28<BK28,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ28-AK28","v":{"$error":"#REF!"}},{"$f":"AQ28+AS28+AU28+BB28+BD28+BF28","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"AM28-AN28","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(COUNTIFS(AQ29,\">0\"))+(COUNTIFS(AR29,\">0\"))","v":0},{"$f":"((AQ29>AR29)*1+(AS29>AT29)*1+(AU29>AV29)*1+(AW29>AX29)*1+(AY29>AZ29)*1>1.99)*2+((BB29>BC29)*1+(BD29>BE29)*1+(BF29>BG29)*1+(BH29>BI29)*1+(BJ29>BK29)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ29>AR29,1,0)+IF(AS29>AT29,1,0)+IF(AU29>AV29,1,0)+IF(AW29>AX29,1,0)+IF(AY29>AZ29,1,0)+IF(BB29>BC29,1,0)+IF(BD29>BE29,1,0)+IF(BF29>BG29,1,0)+IF(BH29>BI29,1,0)+IF(BJ29>BK29,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ29<AR29,1,0)+IF(AS29<AT29,1,0)+IF(AU29<AV29,1,0)+IF(AW29<AX29,1,0)+IF(AY29<AZ29,1,0)+IF(BB29<BC29,1,0)+IF(BD29<BE29,1,0)+IF(BF29<BG29,1,0)+IF(BH29<BI29,1,0)+IF(BJ29<BK29,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ29-AK29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM29-AN29","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,{"$f":"((AQ30>AR30)*1+(AS30>AT30)*1+(AU30>AV30)*1+(AW30>AX30)*1+(AY30>AZ30)*1>1.99)*2+((BB30>BC30)*1+(BD30>BE30)*1+(BF30>BG30)*1+(BH30>BI30)*1+(BJ30>BK30)*1>1.99)*2","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AJ30-AK30","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM30-AN30","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,{"$f":"((AQ31>AR31)*1+(AS31>AT31)*1+(AU31>AV31)*1+(AW31>AX31)*1+(AY31>AZ31)*1>1.99)*2+((BB31>BC31)*1+(BD31>BE31)*1+(BF31>BG31)*1+(BH31>BI31)*1+(BJ31>BK31)*1>1.99)*2","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AJ31-AK31","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM31-AN31","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,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":"SUM(AH28:AH31)","v":0},{"$f":"SUM(AI28:AI31)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B4",{"$f":"VLOOKUP(AE33,Gruppeneinteilung!$A$5:$B$13,2,0)","v":{"$error":"#N/A"}},1,{"$f":"(COUNTIFS(AQ33,\">0\"))+(COUNTIFS(AR33,\">0\"))","v":0},{"$f":"((AQ33>AR33)*1+(AS33>AT33)*1+(AU33>AV33)*1+(AW33>AX33)*1+(AY33>AZ33)*1>1.99)*2+((BB33>BC33)*1+(BD33>BE33)*1+(BF33>BG33)*1+(BH33>BI33)*1+(BJ33>BK33)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ33>AR33,1,0)+IF(AS33>AT33,1,0)+IF(AU33>AV33,1,0)+IF(AW33>AX33,1,0)+IF(AY33>AZ33,1,0)+IF(BB33>BC33,1,0)+IF(BD33>BE33,1,0)+IF(BF33>BG33,1,0)+IF(BH33>BI33,1,0)+IF(BJ33>BK33,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ33<AR33,1,0)+IF(AS33<AT33,1,0)+IF(AU33<AV33,1,0)+IF(AW33<AX33,1,0)+IF(AY33<AZ33,1,0)+IF(BB33<BC33,1,0)+IF(BD33<BE33,1,0)+IF(BF33<BG33,1,0)+IF(BH33<BI33,1,0)+IF(BJ33<BK33,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ33-AK33","v":{"$error":"#REF!"}},{"$f":"AQ33+AS33+AU33+BB33+BD33+BF33","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"AM33-AN33","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(COUNTIFS(AQ34,\">0\"))+(COUNTIFS(AR34,\">0\"))","v":0},{"$f":"((AQ34>AR34)*1+(AS34>AT34)*1+(AU34>AV34)*1+(AW34>AX34)*1+(AY34>AZ34)*1>1.99)*2+((BB34>BC34)*1+(BD34>BE34)*1+(BF34>BG34)*1+(BH34>BI34)*1+(BJ34>BK34)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ34>AR34,1,0)+IF(AS34>AT34,1,0)+IF(AU34>AV34,1,0)+IF(AW34>AX34,1,0)+IF(AY34>AZ34,1,0)+IF(BB34>BC34,1,0)+IF(BD34>BE34,1,0)+IF(BF34>BG34,1,0)+IF(BH34>BI34,1,0)+IF(BJ34>BK34,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ34<AR34,1,0)+IF(AS34<AT34,1,0)+IF(AU34<AV34,1,0)+IF(AW34<AX34,1,0)+IF(AY34<AZ34,1,0)+IF(BB34<BC34,1,0)+IF(BD34<BE34,1,0)+IF(BF34<BG34,1,0)+IF(BH34<BI34,1,0)+IF(BJ34<BK34,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ34-AK34","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM34-AN34","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,{"$f":"((AQ35>AR35)*1+(AS35>AT35)*1+(AU35>AV35)*1+(AW35>AX35)*1+(AY35>AZ35)*1>1.99)*2+((BB35>BC35)*1+(BD35>BE35)*1+(BF35>BG35)*1+(BH35>BI35)*1+(BJ35>BK35)*1>1.99)*2","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AJ35-AK35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM35-AN35","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,{"$f":"((AQ36>AR36)*1+(AS36>AT36)*1+(AU36>AV36)*1+(AW36>AX36)*1+(AY36>AZ36)*1>1.99)*2+((BB36>BC36)*1+(BD36>BE36)*1+(BF36>BG36)*1+(BH36>BI36)*1+(BJ36>BK36)*1>1.99)*2","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AJ36-AK36","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM36-AN36","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,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":"SUM(AH33:AH36)","v":0},{"$f":"SUM(AI33:AI36)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B5",{"$f":"VLOOKUP(AE38,Gruppeneinteilung!$A$5:$B$13,2,0)","v":{"$error":"#N/A"}},1,{"$f":"(COUNTIFS(AQ38,\">0\"))+(COUNTIFS(AR38,\">0\"))","v":0},{"$f":"((AQ38>AR38)*1+(AS38>AT38)*1+(AU38>AV38)*1+(AW38>AX38)*1+(AY38>AZ38)*1>1.99)*2+((BB38>BC38)*1+(BD38>BE38)*1+(BF38>BG38)*1+(BH38>BI38)*1+(BJ38>BK38)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ38>AR38,1,0)+IF(AS38>AT38,1,0)+IF(AU38>AV38,1,0)+IF(AW38>AX38,1,0)+IF(AY38>AZ38,1,0)+IF(BB38>BC38,1,0)+IF(BD38>BE38,1,0)+IF(BF38>BG38,1,0)+IF(BH38>BI38,1,0)+IF(BJ38>BK38,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ38<AR38,1,0)+IF(AS38<AT38,1,0)+IF(AU38<AV38,1,0)+IF(AW38<AX38,1,0)+IF(AY38<AZ38,1,0)+IF(BB38<BC38,1,0)+IF(BD38<BE38,1,0)+IF(BF38<BG38,1,0)+IF(BH38<BI38,1,0)+IF(BJ38<BK38,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ38-AK38","v":{"$error":"#REF!"}},{"$f":"AQ38+AS38+AU38+BB38+BD38+BF38","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"AM38-AN38","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(COUNTIFS(AQ39,\">0\"))+(COUNTIFS(AR39,\">0\"))","v":0},{"$f":"((AQ39>AR39)*1+(AS39>AT39)*1+(AU39>AV39)*1+(AW39>AX39)*1+(AY39>AZ39)*1>1.99)*2+((BB39>BC39)*1+(BD39>BE39)*1+(BF39>BG39)*1+(BH39>BI39)*1+(BJ39>BK39)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ39>AR39,1,0)+IF(AS39>AT39,1,0)+IF(AU39>AV39,1,0)+IF(AW39>AX39,1,0)+IF(AY39>AZ39,1,0)+IF(BB39>BC39,1,0)+IF(BD39>BE39,1,0)+IF(BF39>BG39,1,0)+IF(BH39>BI39,1,0)+IF(BJ39>BK39,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ39<AR39,1,0)+IF(AS39<AT39,1,0)+IF(AU39<AV39,1,0)+IF(AW39<AX39,1,0)+IF(AY39<AZ39,1,0)+IF(BB39<BC39,1,0)+IF(BD39<BE39,1,0)+IF(BF39<BG39,1,0)+IF(BH39<BI39,1,0)+IF(BJ39<BK39,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ39-AK39","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM39-AN39","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,{"$f":"((AQ40>AR40)*1+(AS40>AT40)*1+(AU40>AV40)*1+(AW40>AX40)*1+(AY40>AZ40)*1>1.99)*2+((BB40>BC40)*1+(BD40>BE40)*1+(BF40>BG40)*1+(BH40>BI40)*1+(BJ40>BK40)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ40>AR40,1,0)+IF(AS40>AT40,1,0)+IF(AU40>AV40,1,0)+IF(AW40>AX40,1,0)+IF(AY40>AZ40,1,0)+IF(BB40>BC40,1,0)+IF(BD40>BE40,1,0)+IF(BF40>BG40,1,0)+IF(BH40>BI40,1,0)+IF(BJ40>BK40,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ40<AR40,1,0)+IF(AS40<AT40,1,0)+IF(AU40<AV40,1,0)+IF(AW40<AX40,1,0)+IF(AY40<AZ40,1,0)+IF(BB40<BC40,1,0)+IF(BD40<BE40,1,0)+IF(BF40<BG40,1,0)+IF(BH40<BI40,1,0)+IF(BJ40<BK40,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ40-AK40","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM40-AN40","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,{"$f":"((AQ41>AR41)*1+(AS41>AT41)*1+(AU41>AV41)*1+(AW41>AX41)*1+(AY41>AZ41)*1>1.99)*2+((BB41>BC41)*1+(BD41>BE41)*1+(BF41>BG41)*1+(BH41>BI41)*1+(BJ41>BK41)*1>1.99)*2","v":{"$error":"#REF!"}},{"$f":"IF(AQ41>AR41,1,0)+IF(AS41>AT41,1,0)+IF(AU41>AV41,1,0)+IF(AW41>AX41,1,0)+IF(AY41>AZ41,1,0)+IF(BB41>BC41,1,0)+IF(BD41>BE41,1,0)+IF(BF41>BG41,1,0)+IF(BH41>BI41,1,0)+IF(BJ41>BK41,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AQ41<AR41,1,0)+IF(AS41<AT41,1,0)+IF(AU41<AV41,1,0)+IF(AW41<AX41,1,0)+IF(AY41<AZ41,1,0)+IF(BB41<BC41,1,0)+IF(BD41<BE41,1,0)+IF(BF41<BG41,1,0)+IF(BH41<BI41,1,0)+IF(BJ41<BK41,1,0)","v":{"$error":"#REF!"}},{"$f":"AJ41-AK41","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AM41-AN41","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,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":"SUM(AH38:AH41)","v":0},{"$f":"SUM(AI38:AI41)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontrollsummen",null,null,{"$f":"+#REF!+AH27+AH32+AH37+AH42","v":{"$error":"#REF!"}},{"$f":"+#REF!+AI27+AI32+AI37+AI42","v":{"$error":"#REF!"}},{"$f":"+#REF!+AJ27+AJ32+AJ37+AJ42","v":{"$error":"#REF!"}},{"$f":"+#REF!+AK27+AK32+AK37+AK42","v":{"$error":"#REF!"}},{"$f":"+#REF!+AL27+AL32+AL37+AL42","v":{"$error":"#REF!"}},{"$f":"+#REF!+AM27+AM32+AM37+AM42","v":{"$error":"#REF!"}},{"$f":"+#REF!+AN27+AN32+AN37+AN42","v":{"$error":"#REF!"}},{"$f":"+#REF!+AO27+AO32+AO37+AO42","v":{"$error":"#REF!"}},null,{"$f":"SUM(AQ23:AQ42)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},0,0,0,0,null,{"$f":"SUM(BB23:BB37)","v":0},0,0,0,0,0,0,0,0,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,"Sp.","Pkte.","Bälle",null,"+/-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.",{"$f":"$AF$28","v":"FBT Flums"},{"$f":"$AH$32","v":0},{"$f":"$AJ$32","v":{"$error":"#REF!"}},{"$f":"$AM$32","v":{"$error":"#REF!"}},{"$f":"$AN$32","v":{"$error":"#REF!"}},{"$f":"$AO$32","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.",{"$f":"$AF$23","v":"FBV Ettenhausen "},{"$f":"$AH$27","v":0},{"$f":"$AJ$27","v":{"$error":"#REF!"}},{"$f":"$AM$27","v":{"$error":"#REF!"}},{"$f":"$AN$27","v":{"$error":"#REF!"}},{"$f":"$AO$27","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.",{"$f":"$AF$38","v":{"$error":"#N/A"}},{"$f":"$AH$42","v":0},{"$f":"$AJ$42","v":{"$error":"#REF!"}},{"$f":"$AM$42","v":{"$error":"#REF!"}},{"$f":"$AN$42","v":{"$error":"#REF!"}},{"$f":"$AO$42","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.",{"$f":"$AF$33","v":{"$error":"#N/A"}},{"$f":"$AH$37","v":0},{"$f":"$AJ$37","v":{"$error":"#REF!"}},{"$f":"$AM$37","v":{"$error":"#REF!"}},{"$f":"$AN$37","v":{"$error":"#REF!"}},{"$f":"$AO$37","v":{"$error":"#REF!"}}]

{"sheet":"Spielberichte","index":6,"n_rows":36,"n_cols":48,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,4,4,14],[4,21,4,32],[1,0,1,26],[2,0,2,26],[2,27,2,28],[2,29,2,30],[2,31,2,32],[13,0,14,5],[13,15,14,20],[13,21,13,22],[14,21,14,22],[6,0,6,14],[6,15,6,32],[7,0,7,14],[7,15,7,29],[9,0,9,14],[10,0,10,14],[12,23,12,24],[12,25,12,26],[12,27,12,28],[12,29,12,30],[12,31,12,32],[16,0,17,1],[18,0,19,1],[20,0,21,1],[22,0,23,1],[24,0,25,1],[28,4,28,27],[28,28,29,32],[29,0,29,3],[29,4,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[29,20,29,23],[29,24,29,27],[28,0,28,3],[30,24,30,27],[30,28,30,32],[30,0,30,3],[30,4,30,7],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23]]}
[null,null,null,null,null,null,"FAUSTBALL-SPIELBERICHT"]
[{"$f":"CONCATENATE(MASTER!B1,\" \",MASTER!B8)","v":"Ostschweizer Meisterschaft Halle 2019/2020"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gr.",null,"Feld Nr.",null,"Spiel  Nr.",null,null,null,"Spiel Nr.",13,null,"Spiel","Gruppe","Feld","Spiel","Team A","Team B","Schiri","Team A","Team B","Schiri"]
[{"$f":"CONCATENATE(\"Kat. \",MASTER!B10,\" / FINALRUNDE\")","v":"Kat. U14 / FINALRUNDE"},null,null,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":"VLOOKUP(AK2,AM3:AV30,2,1)","v":"1/2"},null,{"$f":"VLOOKUP(AK2,AM3:AV30,3,1)","v":1},null,{"$f":"VLOOKUP(AK2,AM3:AV30,4,1)","v":13},null,null,null,null,null,null,1,"A",1,1,{"$f":"VLOOKUP(AT3,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Affeltrangen"},{"$f":"VLOOKUP(AU3,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 2"},{"$f":"VLOOKUP(AV3,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"SVD Diepoldsau"},"A1","A2","A3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"B",2,2,{"$f":"VLOOKUP(AT4,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Höchst"},{"$f":"VLOOKUP(AU4,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBV Ettenhausen "},{"$f":"VLOOKUP(AV4,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBT Flums"},"B1","B2","B3"]
["  Datum/Zeit:",null,null,null,{"$f":"MASTER!B3","v":"So. 15.12.2019"},null,null,null,null,null,null,null,null,null,null,"  Sportplatz/Halle:",null,null,null,null,null,{"$f":"MASTER!C3","v":"Aadorf, Löhracker"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"A",1,3,{"$f":"VLOOKUP(AT5,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 2"},{"$f":"VLOOKUP(AU5,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"SVD Diepoldsau"},{"$f":"VLOOKUP(AV5,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Affeltrangen"},"A2","A3","A1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"B",2,4,{"$f":"VLOOKUP(AT6,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBV Ettenhausen "},{"$f":"VLOOKUP(AU6,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBT Flums"},{"$f":"VLOOKUP(AV6,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Höchst"},"B2","B3","B1"]
["Mannschaft A:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft B:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"A",1,5,{"$f":"VLOOKUP(AT7,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Affeltrangen"},{"$f":"VLOOKUP(AU7,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"SVD Diepoldsau"},{"$f":"VLOOKUP(AV7,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 2"},"A1","A3","A2"]
[{"$f":"VLOOKUP(AK2,AM3:AV30,5,1)","v":"FG RiWi 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AK2,AM3:AV30,6,1)","v":"FBV Ettenhausen "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"B",2,6,{"$f":"VLOOKUP(AT8,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Höchst"},{"$f":"VLOOKUP(AU8,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBT Flums"},{"$f":"VLOOKUP(AV8,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FBV Ettenhausen "},"B1","B3","B2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"VF1",1,7,{"$f":"'Resultate VR'!B54","v":"STV Affeltrangen"},{"$f":"'Resultate VR'!E54","v":"TS Höchst"},{"$f":"'Resultate VR'!C11","v":"FG RiWi 2"}]
["  Schiedsrichter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Anschreiber:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"VF2",2,8,{"$f":"'Resultate VR'!B56","v":"FBT Flums"},{"$f":"'Resultate VR'!E56","v":"SVD Diepoldsau"},{"$f":"'Resultate VR'!C22","v":"FBV Ettenhausen "}]
[{"$f":"VLOOKUP(AK2,AM3:AV30,7,1)","v":"SVD Diepoldsau"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Linienrichter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"HF1",1,9,{"$f":"'Resultate VR'!B62","v":"FG RiWi 2"},{"$f":"'Resultate VR'!E62","v":"SVD Diepoldsau"},{"$f":"'Resultate VR'!AC54","v":"TS Höchst"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"HF2",2,10,{"$f":"'Resultate VR'!B64","v":"FBV Ettenhausen "},{"$f":"'Resultate VR'!E64","v":"STV Affeltrangen"},{"$f":"'Resultate VR'!AC56","v":"FBT Flums"}]
[null,null,null,null,null,null,null,"1.Satz/Halbzeit",null,null,null,null,"5.Satz",null,null,null,null,null,null,null,null,null,null,"1. Satz",null,"2. Satz",null,"3. Satz",null,"4. Satz",null,"5. Satz",null,null,null,null,null,null,11,"5/6",1,11,{"$f":"'Resultate VR'!B70","v":"TS Höchst"},{"$f":"'Resultate VR'!E70","v":"FBT Flums"},{"$f":"'Resultate VR'!AB62","v":"FG RiWi 2"}]
["  Ballwahl/Anspiel:",null,null,null,null,null,"A",null,null,null,null,null,null,null,null,"Timeout:",null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"3/4",2,12,{"$f":"'Resultate VR'!B72","v":"SVD Diepoldsau"},{"$f":"'Resultate VR'!E72","v":"STV Affeltrangen"},{"$f":"'Resultate VR'!AB64","v":"FBV Ettenhausen "}]
[null,null,null,null,null,null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"1/2",1,13,{"$f":"'Resultate VR'!B74","v":"FG RiWi 2"},{"$f":"'Resultate VR'!E74","v":"FBV Ettenhausen "},{"$f":"'Resultate VR'!AB72","v":"SVD Diepoldsau"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"C",3,14,{"$f":"VLOOKUP(AT16,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},{"$f":"VLOOKUP(AU16,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},{"$f":"VLOOKUP(AV16,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},"C1","C2","C5"]
["1. Satz",null,"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,"A",null,null,null,null,null,15,"C",3,15,{"$f":"VLOOKUP(AT17,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},{"$f":"VLOOKUP(AU17,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},{"$f":"VLOOKUP(AV17,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},"C3","C4","C1"]
[null,null,"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,"B",null,null,null,null,null,16,"C",3,16,{"$f":"VLOOKUP(AT18,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},{"$f":"VLOOKUP(AU18,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},{"$f":"VLOOKUP(AV18,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},"C1","C5","C4"]
["2. Satz",null,"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,"A",null,null,null,null,null,17,"C",3,17,{"$f":"VLOOKUP(AT19,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},{"$f":"VLOOKUP(AU19,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},{"$f":"VLOOKUP(AV19,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},"C2","C3","C1"]
[null,null,"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,"B",null,null,null,null,null,18,"C",3,18,{"$f":"VLOOKUP(AT20,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},{"$f":"VLOOKUP(AU20,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},{"$f":"VLOOKUP(AV20,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},"C4","C5","C2"]
["3. Satz",null,"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,"A",null,null,null,null,null,19,"C",3,19,{"$f":"VLOOKUP(AT21,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},{"$f":"VLOOKUP(AU21,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},{"$f":"VLOOKUP(AV21,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},"C1","C3","C5"]
[null,null,"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,"B",null,null,null,null,null,20,"C",3,20,{"$f":"VLOOKUP(AT22,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},{"$f":"VLOOKUP(AU22,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},{"$f":"VLOOKUP(AV22,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},"C2","C5","C3"]
["4. Satz",null,"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,"A",null,null,null,null,null,21,"C",3,21,{"$f":"VLOOKUP(AT23,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"FG RiWi 1"},{"$f":"VLOOKUP(AU23,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},{"$f":"VLOOKUP(AV23,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},"C1","C4","C2"]
[null,null,"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,"B",null,null,null,null,null,22,"C",3,22,{"$f":"VLOOKUP(AT24,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},{"$f":"VLOOKUP(AU24,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"JFB Widnau"},{"$f":"VLOOKUP(AV24,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},"C3","C5","C4"]
["5. Satz",null,"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,"A",null,null,null,null,null,23,"C",3,23,{"$f":"VLOOKUP(AT25,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"TS Schwarzach"},{"$f":"VLOOKUP(AU25,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"Satus Kreuzlingen"},{"$f":"VLOOKUP(AV25,Gruppeneinteilung!$A$5:$B$20,2,0)","v":"STV Wigoltingen"},"C2","C4","C3"]
[null,null,"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,"B"]
[]
["Ergebnis   (A : B)"]
["Spiel nach Zeit",null,null,null,"              Spiel nach Sätzen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Endstand\n(Sätze)"]
["Halbzeit",null,null,null,"1. Satz",null,null,null,"2. Satz",null,null,null,"3. Satz",null,null,null,"4. Satz",null,null,null,"5. Satz",null,null,null,"Total Bälle"]
[":",null,null,null,":",null,null,null,":",null,null,null,":",null,null,null,":",null,null,null,":",null,null,null,":",null,null,null,":"]
["  Sieger:"]
[]
["  Für die Richtigkeit der Eintragungen"]
["  Schiedsrichter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Spielführer A:"]
["  Anschreiber:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Spielführer B:"]