{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Daten","Setup","Gesamt","Club1","Club2","Spielbericht","Spielbericht (2)","Zusatzblatt","Strafzeitencodes","Penaltyschießen","BesondereVorkommnisse"],"not_rendered":{"images":8,"macros":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Daten","index":0,"n_rows":26,"n_cols":5,"rows_kept":26,"hidden":true}
["Codes","Strafen","Count Strafe","Spielzeiten","Verlängerung"]
["A",2,2,{"v":1200,"d":"12:00"},{"v":500,"d":"05:00"}]
["B",5,5,{"v":1500,"d":"15:00"},{"v":1000,"d":"10:00"}]
["C",10,10,{"v":2000,"d":"20:00"}]
["D","5+GM",5]
["E","10+GM",10]
["F","GM"]
["G","MP"]
["H",1,1]
["I",2.5,2.5]
["J","2.5+GM",2.5]
["K"]
["L"]
["M"]
["N"]
["O"]
["P"]
["Q"]
["R"]
["S"]
["W"]
["X"]
["Y"]
["ZA"]
["ZB"]
["ZC"]

{"sheet":"Setup","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"merged":[[0,0,0,7],[0,10,0,11],[10,0,10,3],[11,0,11,1],[11,2,11,3]]}
["Setup zum Spiel",{"$nulls":9},"Zum Schluss!"]
[]
["Spielort","a-Heim",null,null,"Passnummer","Verein","Nachname","Vorname"]
["Datum",null,null,"Zeitnehmer 1","5001","a-Heim","C","a"]
["Startzeit",null,null,"Zeitnehmer 2","5002","a-Heim","C","b"]
["Endzeit",null,null,"Schiedsrichter 1","5003","b-Heim","D","a"]
["Spielnummer*",null,null,"Schiedsrichter 2","5004","b-Heim","D","b"]
["Spieltyp","Meisterschaft",null,"Tech. Direktor","5005","c-Heim","E","a"]
["Zuschauer",300]
[]
["Spielzeiten"]
["Reguläre Spielzeit",null,"Verlängerung"]
["Spielzeit/Abschnitt",{"v":2000,"d":"20:00"},"Spielzeit/Abschnitt",{"v":1000,"d":"10:00"}]
["Anzahl",3,"Anzahl",0]
[]
[]
["* kein Pflichtfeld",{"$nulls":5},"Version:","22.3.2024_Saison2024"]

{"sheet":"Gesamt","index":2,"n_rows":37,"n_cols":6,"rows_kept":37,"hidden":true}
["Passnummer","Trikotnummer","Funktion","Nachname","Vorname","Verein"]
[{"$f":"IF(Club1!E8=\"\",\"\",Club1!E8)","v":1000},{"$f":"IF(Club1!A8=\"\",\"\",Club1!A8)","v":1},{"$f":"IF(Club1!B8=\"\",\"\",Club1!B8)","v":"C"},{"$f":"IF(Club1!C8=\"\",\"\",Club1!C8)","v":"A"},{"$f":"IF(Club1!D8=\"\",\"\",Club1!D8)","v":"a"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E9=\"\",\"\",Club1!E9)","v":1001},{"$f":"IF(Club1!A9=\"\",\"\",Club1!A9)","v":2},{"$f":"IF(Club1!B9=\"\",\"\",Club1!B9)","v":"A"},{"$f":"IF(Club1!C9=\"\",\"\",Club1!C9)","v":"A"},{"$f":"IF(Club1!D9=\"\",\"\",Club1!D9)","v":"b"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E10=\"\",\"\",Club1!E10)","v":1002},{"$f":"IF(Club1!A10=\"\",\"\",Club1!A10)","v":3},{"$f":"IF(Club1!B10=\"\",\"\",Club1!B10)","v":"G"},{"$f":"IF(Club1!C10=\"\",\"\",Club1!C10)","v":"A"},{"$f":"IF(Club1!D10=\"\",\"\",Club1!D10)","v":"c"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E11=\"\",\"\",Club1!E11)","v":1003},{"$f":"IF(Club1!A11=\"\",\"\",Club1!A11)","v":4},{"$f":"IF(Club1!B11=\"\",\"\",Club1!B11)","v":"G"},{"$f":"IF(Club1!C11=\"\",\"\",Club1!C11)","v":"A"},{"$f":"IF(Club1!D11=\"\",\"\",Club1!D11)","v":"d"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E12=\"\",\"\",Club1!E12)","v":1004},{"$f":"IF(Club1!A12=\"\",\"\",Club1!A12)","v":5},{"$f":"IF(Club1!B12=\"\",\"\",Club1!B12)","v":"F"},{"$f":"IF(Club1!C12=\"\",\"\",Club1!C12)","v":"A"},{"$f":"IF(Club1!D12=\"\",\"\",Club1!D12)","v":"e"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E13=\"\",\"\",Club1!E13)","v":1005},{"$f":"IF(Club1!A13=\"\",\"\",Club1!A13)","v":6},{"$f":"IF(Club1!B13=\"\",\"\",Club1!B13)","v":"F"},{"$f":"IF(Club1!C13=\"\",\"\",Club1!C13)","v":"A"},{"$f":"IF(Club1!D13=\"\",\"\",Club1!D13)","v":"f"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E14=\"\",\"\",Club1!E14)","v":1006},{"$f":"IF(Club1!A14=\"\",\"\",Club1!A14)","v":7},{"$f":"IF(Club1!B14=\"\",\"\",Club1!B14)","v":"F"},{"$f":"IF(Club1!C14=\"\",\"\",Club1!C14)","v":"A"},{"$f":"IF(Club1!D14=\"\",\"\",Club1!D14)","v":"g"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E15=\"\",\"\",Club1!E15)","v":1007},{"$f":"IF(Club1!A15=\"\",\"\",Club1!A15)","v":8},{"$f":"IF(Club1!B15=\"\",\"\",Club1!B15)","v":"F"},{"$f":"IF(Club1!C15=\"\",\"\",Club1!C15)","v":"A"},{"$f":"IF(Club1!D15=\"\",\"\",Club1!D15)","v":"h"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E16=\"\",\"\",Club1!E16)","v":1008},{"$f":"IF(Club1!A16=\"\",\"\",Club1!A16)","v":9},{"$f":"IF(Club1!B16=\"\",\"\",Club1!B16)","v":"F"},{"$f":"IF(Club1!C16=\"\",\"\",Club1!C16)","v":"A"},{"$f":"IF(Club1!D16=\"\",\"\",Club1!D16)","v":"i"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E17=\"\",\"\",Club1!E17)","v":1009},{"$f":"IF(Club1!A17=\"\",\"\",Club1!A17)","v":10},{"$f":"IF(Club1!B17=\"\",\"\",Club1!B17)","v":"F"},{"$f":"IF(Club1!C17=\"\",\"\",Club1!C17)","v":"A"},{"$f":"IF(Club1!D17=\"\",\"\",Club1!D17)","v":"j"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E18=\"\",\"\",Club1!E18)","v":1010},{"$f":"IF(Club1!A18=\"\",\"\",Club1!A18)","v":11},{"$f":"IF(Club1!B18=\"\",\"\",Club1!B18)","v":"F"},{"$f":"IF(Club1!C18=\"\",\"\",Club1!C18)","v":"A"},{"$f":"IF(Club1!D18=\"\",\"\",Club1!D18)","v":"k"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E19=\"\",\"\",Club1!E19)","v":1011},{"$f":"IF(Club1!A19=\"\",\"\",Club1!A19)","v":12},{"$f":"IF(Club1!B19=\"\",\"\",Club1!B19)","v":"F"},{"$f":"IF(Club1!C19=\"\",\"\",Club1!C19)","v":"A"},{"$f":"IF(Club1!D19=\"\",\"\",Club1!D19)","v":"l"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E20=\"\",\"\",Club1!E20)","v":1012},{"$f":"IF(Club1!A20=\"\",\"\",Club1!A20)","v":13},{"$f":"IF(Club1!B20=\"\",\"\",Club1!B20)","v":"F"},{"$f":"IF(Club1!C20=\"\",\"\",Club1!C20)","v":"A"},{"$f":"IF(Club1!D20=\"\",\"\",Club1!D20)","v":"m"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E21=\"\",\"\",Club1!E21)","v":1013},{"$f":"IF(Club1!A21=\"\",\"\",Club1!A21)","v":14},{"$f":"IF(Club1!B21=\"\",\"\",Club1!B21)","v":"F"},{"$f":"IF(Club1!C21=\"\",\"\",Club1!C21)","v":"A"},{"$f":"IF(Club1!D21=\"\",\"\",Club1!D21)","v":"n"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E22=\"\",\"\",Club1!E22)","v":1014},{"$f":"IF(Club1!A22=\"\",\"\",Club1!A22)","v":15},{"$f":"IF(Club1!B22=\"\",\"\",Club1!B22)","v":"F"},{"$f":"IF(Club1!C22=\"\",\"\",Club1!C22)","v":"A"},{"$f":"IF(Club1!D22=\"\",\"\",Club1!D22)","v":"o"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E23=\"\",\"\",Club1!E23)","v":1015},{"$f":"IF(Club1!A23=\"\",\"\",Club1!A23)","v":16},{"$f":"IF(Club1!B23=\"\",\"\",Club1!B23)","v":"F"},{"$f":"IF(Club1!C23=\"\",\"\",Club1!C23)","v":"A"},{"$f":"IF(Club1!D23=\"\",\"\",Club1!D23)","v":"p"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E24=\"\",\"\",Club1!E24)","v":1016},{"$f":"IF(Club1!A24=\"\",\"\",Club1!A24)","v":17},{"$f":"IF(Club1!B24=\"\",\"\",Club1!B24)","v":"F"},{"$f":"IF(Club1!C24=\"\",\"\",Club1!C24)","v":"A"},{"$f":"IF(Club1!D24=\"\",\"\",Club1!D24)","v":"q"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club1!E25=\"\",\"\",Club1!E25)","v":1017},{"$f":"IF(Club1!A25=\"\",\"\",Club1!A25)","v":18},{"$f":"IF(Club1!B25=\"\",\"\",Club1!B25)","v":"F"},{"$f":"IF(Club1!C25=\"\",\"\",Club1!C25)","v":"A"},{"$f":"IF(Club1!D25=\"\",\"\",Club1!D25)","v":"r"},{"$f":"IF(Club1!$C$1=\"\",\"\",Club1!$C$1)","v":"a-Team"}]
[{"$f":"IF(Club2!E8=\"\",\"\",Club2!E8)","v":2001},{"$f":"IF(Club2!A8=\"\",\"\",Club2!A8)","v":1},{"$f":"IF(Club2!B8=\"\",\"\",Club2!B8)","v":"C"},{"$f":"IF(Club2!C8=\"\",\"\",Club2!C8)","v":"B"},{"$f":"IF(Club2!D8=\"\",\"\",Club2!D8)","v":"a"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E9=\"\",\"\",Club2!E9)","v":2002},{"$f":"IF(Club2!A9=\"\",\"\",Club2!A9)","v":2},{"$f":"IF(Club2!B9=\"\",\"\",Club2!B9)","v":"A"},{"$f":"IF(Club2!C9=\"\",\"\",Club2!C9)","v":"B"},{"$f":"IF(Club2!D9=\"\",\"\",Club2!D9)","v":"b"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E10=\"\",\"\",Club2!E10)","v":2003},{"$f":"IF(Club2!A10=\"\",\"\",Club2!A10)","v":3},{"$f":"IF(Club2!B10=\"\",\"\",Club2!B10)","v":"G"},{"$f":"IF(Club2!C10=\"\",\"\",Club2!C10)","v":"B"},{"$f":"IF(Club2!D10=\"\",\"\",Club2!D10)","v":"c"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E11=\"\",\"\",Club2!E11)","v":2004},{"$f":"IF(Club2!A11=\"\",\"\",Club2!A11)","v":4},{"$f":"IF(Club2!B11=\"\",\"\",Club2!B11)","v":"G"},{"$f":"IF(Club2!C11=\"\",\"\",Club2!C11)","v":"B"},{"$f":"IF(Club2!D11=\"\",\"\",Club2!D11)","v":"d"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E12=\"\",\"\",Club2!E12)","v":2005},{"$f":"IF(Club2!A12=\"\",\"\",Club2!A12)","v":5},{"$f":"IF(Club2!B12=\"\",\"\",Club2!B12)","v":"F"},{"$f":"IF(Club2!C12=\"\",\"\",Club2!C12)","v":"B"},{"$f":"IF(Club2!D12=\"\",\"\",Club2!D12)","v":"e"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E13=\"\",\"\",Club2!E13)","v":2006},{"$f":"IF(Club2!A13=\"\",\"\",Club2!A13)","v":6},{"$f":"IF(Club2!B13=\"\",\"\",Club2!B13)","v":"F"},{"$f":"IF(Club2!C13=\"\",\"\",Club2!C13)","v":"B"},{"$f":"IF(Club2!D13=\"\",\"\",Club2!D13)","v":"f"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E14=\"\",\"\",Club2!E14)","v":2007},{"$f":"IF(Club2!A14=\"\",\"\",Club2!A14)","v":7},{"$f":"IF(Club2!B14=\"\",\"\",Club2!B14)","v":"F"},{"$f":"IF(Club2!C14=\"\",\"\",Club2!C14)","v":"B"},{"$f":"IF(Club2!D14=\"\",\"\",Club2!D14)","v":"g"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E15=\"\",\"\",Club2!E15)","v":2008},{"$f":"IF(Club2!A15=\"\",\"\",Club2!A15)","v":8},{"$f":"IF(Club2!B15=\"\",\"\",Club2!B15)","v":"F"},{"$f":"IF(Club2!C15=\"\",\"\",Club2!C15)","v":"B"},{"$f":"IF(Club2!D15=\"\",\"\",Club2!D15)","v":"h"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E16=\"\",\"\",Club2!E16)","v":2009},{"$f":"IF(Club2!A16=\"\",\"\",Club2!A16)","v":9},{"$f":"IF(Club2!B16=\"\",\"\",Club2!B16)","v":"F"},{"$f":"IF(Club2!C16=\"\",\"\",Club2!C16)","v":"B"},{"$f":"IF(Club2!D16=\"\",\"\",Club2!D16)","v":"i"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E17=\"\",\"\",Club2!E17)","v":2010},{"$f":"IF(Club2!A17=\"\",\"\",Club2!A17)","v":10},{"$f":"IF(Club2!B17=\"\",\"\",Club2!B17)","v":"F"},{"$f":"IF(Club2!C17=\"\",\"\",Club2!C17)","v":"B"},{"$f":"IF(Club2!D17=\"\",\"\",Club2!D17)","v":"j"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E18=\"\",\"\",Club2!E18)","v":2011},{"$f":"IF(Club2!A18=\"\",\"\",Club2!A18)","v":11},{"$f":"IF(Club2!B18=\"\",\"\",Club2!B18)","v":"F"},{"$f":"IF(Club2!C18=\"\",\"\",Club2!C18)","v":"B"},{"$f":"IF(Club2!D18=\"\",\"\",Club2!D18)","v":"k"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E19=\"\",\"\",Club2!E19)","v":2012},{"$f":"IF(Club2!A19=\"\",\"\",Club2!A19)","v":12},{"$f":"IF(Club2!B19=\"\",\"\",Club2!B19)","v":"F"},{"$f":"IF(Club2!C19=\"\",\"\",Club2!C19)","v":"B"},{"$f":"IF(Club2!D19=\"\",\"\",Club2!D19)","v":"l"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E20=\"\",\"\",Club2!E20)","v":2013},{"$f":"IF(Club2!A20=\"\",\"\",Club2!A20)","v":13},{"$f":"IF(Club2!B20=\"\",\"\",Club2!B20)","v":"F"},{"$f":"IF(Club2!C20=\"\",\"\",Club2!C20)","v":"B"},{"$f":"IF(Club2!D20=\"\",\"\",Club2!D20)","v":"m"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E21=\"\",\"\",Club2!E21)","v":2014},{"$f":"IF(Club2!A21=\"\",\"\",Club2!A21)","v":14},{"$f":"IF(Club2!B21=\"\",\"\",Club2!B21)","v":"F"},{"$f":"IF(Club2!C21=\"\",\"\",Club2!C21)","v":"B"},{"$f":"IF(Club2!D21=\"\",\"\",Club2!D21)","v":"n"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E22=\"\",\"\",Club2!E22)","v":2015},{"$f":"IF(Club2!A22=\"\",\"\",Club2!A22)","v":15},{"$f":"IF(Club2!B22=\"\",\"\",Club2!B22)","v":"F"},{"$f":"IF(Club2!C22=\"\",\"\",Club2!C22)","v":"B"},{"$f":"IF(Club2!D22=\"\",\"\",Club2!D22)","v":"o"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E23=\"\",\"\",Club2!E23)","v":2016},{"$f":"IF(Club2!A23=\"\",\"\",Club2!A23)","v":16},{"$f":"IF(Club2!B23=\"\",\"\",Club2!B23)","v":"F"},{"$f":"IF(Club2!C23=\"\",\"\",Club2!C23)","v":"B"},{"$f":"IF(Club2!D23=\"\",\"\",Club2!D23)","v":"p"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E24=\"\",\"\",Club2!E24)","v":2017},{"$f":"IF(Club2!A24=\"\",\"\",Club2!A24)","v":17},{"$f":"IF(Club2!B24=\"\",\"\",Club2!B24)","v":"F"},{"$f":"IF(Club2!C24=\"\",\"\",Club2!C24)","v":"B"},{"$f":"IF(Club2!D24=\"\",\"\",Club2!D24)","v":"q"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]
[{"$f":"IF(Club2!E25=\"\",\"\",Club2!E25)","v":2018},{"$f":"IF(Club2!A25=\"\",\"\",Club2!A25)","v":18},{"$f":"IF(Club2!B25=\"\",\"\",Club2!B25)","v":"F"},{"$f":"IF(Club2!C25=\"\",\"\",Club2!C25)","v":"B"},{"$f":"IF(Club2!D25=\"\",\"\",Club2!D25)","v":"r"},{"$f":"IF(Club2!$C$1=\"\",\"\",Club2!$C$1)","v":"b-Team"}]

{"sheet":"Club1","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"merged":[[0,0,0,1],[0,2,0,3],[1,0,1,1],[1,2,1,4]]}
["Mannschaft 1:",null,"a-Team",null,1,"Spieleranzahl:",{"$f":"COUNTA(E8:E25)","v":18}]
["Liga:",null,"AB"]
[]
[null,"Coach","Nachname","Vorname"]
[null,null,"A","z"]
[]
["Trikotnummer","Funktion","Nachname","Vorname","Passnummer"]
[1,"C","A","a",1000]
[2,"A","A","b",1001]
[3,"G","A","c",1002]
[4,"G","A","d",1003]
[5,"F","A","e",1004]
[6,"F","A","f",1005]
[7,"F","A","g",1006]
[8,"F","A","h",1007]
[9,"F","A","i",1008]
[10,"F","A","j",1009]
[11,"F","A","k",1010]
[12,"F","A","l",1011]
[13,"F","A","m",1012]
[14,"F","A","n",1013]
[15,"F","A","o",1014]
[16,"F","A","p",1015]
[17,"F","A","q",1016]
[18,"F","A","r",1017]
[]
[{"$nulls":3},"Version:","22.3.2024_Saison2024"]

{"sheet":"Club2","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"merged":[[0,0,0,1],[0,2,0,3],[1,0,1,1],[1,2,1,4]]}
["Mannschaft 2:",null,"b-Team",null,2,"Spieleranzahl:",{"$f":"COUNTA(E8:E25)","v":18}]
["Liga:",null,"AB"]
[]
[null,"Coach","Nachname","Vorname"]
[null,null,"B","z"]
[]
["Trikotnummer","Funktion","Nachname","Vorname","Passnummer"]
[1,"C","B","a",2001]
[2,"A","B","b",2002]
[3,"G","B","c",2003]
[4,"G","B","d",2004]
[5,"F","B","e",2005]
[6,"F","B","f",2006]
[7,"F","B","g",2007]
[8,"F","B","h",2008]
[9,"F","B","i",2009]
[10,"F","B","j",2010]
[11,"F","B","k",2011]
[12,"F","B","l",2012]
[13,"F","B","m",2013]
[14,"F","B","n",2014]
[15,"F","B","o",2015]
[16,"F","B","p",2016]
[17,"F","B","q",2017]
[18,"F","B","r",2018]
[]
[{"$nulls":3},"Version:","22.3.2024_Saison2024"]

{"sheet":"Spielbericht","index":5,"n_rows":56,"n_cols":39,"rows_kept":56,"merged":[[0,0,5,2],[0,3,5,8],[0,10,0,15],[0,16,0,23],[0,24,0,29],[0,32,0,33],[1,9,3,9],[1,10,3,14],[1,17,3,17],[1,18,3,18],[1,19,3,19],[1,21,3,21],[1,22,3,22],[1,23,3,23],[1,25,3,25],[1,27,3,27],[1,30,3,30],[4,11,4,14],[5,11,5,14],[6,0,7,2],[6,3,7,7],[8,0,9,2],[8,3,9,7],[8,8,9,8],[8,11,8,14],[9,11,9,14],[10,0,11,2],[10,3,11,7],[10,8,11,8],[10,11,10,14],[11,11,11,14],[12,0,12,2],[12,3,13,5],[12,7,13,8],[12,11,12,14],[12,32,12,33],[13,0,13,2],[13,11,13,14],[14,2,15,2],[14,5,15,5],[14,6,14,7],[14,8,15,8],[14,11,14,14],[15,6,15,7],[15,11,15,14],[16,0,16,3],[16,6,16,7],[16,11,16,14],[17,0,17,3],[17,6,17,7],[17,11,17,14],[18,0,18,3],[18,6,18,7],[18,11,18,14],[19,0,20,0],[19,2,19,3],[19,7,19,8],[19,11,19,14],[20,2,20,3],[20,7,20,8],[20,11,20,14],[21,2,23,3],[21,5,23,5],[21,6,23,6],[21,7,23,8],[21,11,21,14],[22,0,23,0],[22,9,26,10],[22,11,24,11],[22,12,22,14],[22,15,24,15],[22,16,23,16],[22,17,23,17],[22,18,23,18],[22,19,23,19],[22,20,23,20],[22,21,23,21],[22,22,23,22],[22,23,23,23],[22,24,23,24],[22,25,23,25],[22,26,23,26],[22,27,23,27],[22,28,23,28],[22,29,23,29],[22,30,23,30],[23,12,23,14],[24,0,25,0],[24,2,26,3],[24,5,26,5],[24,6,26,6],[24,7,26,8],[24,12,24,14],[24,16,25,16],[24,17,25,17],[24,18,25,18],[24,19,25,19],[24,20,25,21],[24,22,25,23],[24,24,25,24],[24,25,25,25],[24,26,25,26],[24,27,25,27],[24,28,25,28],[24,29,25,29],[24,30,25,30],[25,11,26,11],[25,12,26,15],[26,16,26,19],[26,24,26,26],[27,0,29,0],[27,2,29,3],[27,5,29,5],[27,6,29,6],[27,7,29,8],[27,9,29,9],[27,10,29,15],[27,16,29,23],[27,24,29,29],[30,0,32,0],[30,2,32,3],[30,5,32,5],[30,6,32,6],[30,7,32,8],[30,9,32,9],[30,10,32,14],[30,17,32,17],[30,18,32,18],[30,19,32,19],[30,21,32,21],[30,22,32,22],[30,23,32,23],[30,25,32,25],[30,27,32,27],[30,30,32,30],[33,0,34,0],[33,2,34,3],[33,5,34,5],[33,6,34,6],[33,7,34,8],[33,11,33,14],[34,11,34,14],[35,0,35,8],[36,0,36,5],[36,6,37,8],[37,0,37,5],[37,11,37,14],[38,2,38,3],[38,7,38,8],[38,11,38,14],[39,1,40,1],[39,2,40,3],[39,4,40,4],[39,5,40,5],[39,6,40,6],[39,7,40,8],[39,11,39,14],[40,11,40,14],[41,1,42,1],[41,2,42,3],[41,4,42,4],[41,5,42,5],[41,6,41,8],[41,11,41,14],[42,6,42,8],[42,11,42,14],[43,1,44,1],[43,2,44,3],[43,4,44,4],[43,5,44,5],[43,11,43,14],[44,6,45,8],[44,11,44,14],[45,1,46,1],[45,2,46,3],[45,4,46,4],[45,5,46,5],[45,11,45,14],[46,11,46,14],[47,0,48,0],[47,1,48,1],[47,2,48,3],[47,4,48,4],[47,5,48,5],[47,6,48,8],[47,11,47,14],[48,11,48,14],[49,3,54,8],[49,11,49,14],[50,11,50,14],[51,0,52,2],[51,9,55,10],[51,11,53,11],[51,12,51,14],[51,15,53,15],[51,16,52,16],[51,17,52,17],[51,18,52,18],[51,19,52,19],[51,20,52,20],[51,21,52,21],[51,22,52,22],[51,23,52,23],[51,24,52,24],[51,25,52,25],[51,26,52,26],[51,27,52,27],[51,28,52,28],[51,29,52,29],[51,30,52,30],[52,12,52,14],[53,0,54,2],[53,12,53,14],[53,16,54,16],[53,17,54,17],[53,18,54,18],[53,19,54,19],[53,20,54,21],[53,22,54,23],[53,24,54,24],[53,25,54,25],[53,26,54,26],[53,27,54,27],[53,28,54,28],[53,29,54,29],[53,30,54,30],[54,11,55,11],[54,12,55,15],[55,0,55,7],[55,16,55,19],[55,24,55,26]]}
[{"$nulls":3},"e-Match Sheet Skaterhockey\ne-Spielbericht Skaterhockey",{"$nulls":5},1,{"$f":"D9","v":"a-Team 1"},{"$nulls":5},"Goals/Torschützen",{"$nulls":7},"Penalties/Strafen",{"$nulls":7},"Spielbeginn / -ende",null,null,"Club1","Club2"]
[{"$nulls":9},"Nr. No.","Surname                               Forname\nName                                    Vorname",{"$nulls":4},"Card","Time","G","A","T","Time","G","A","T","Time","Nr. No.",null,"Count","Fine",null,"Nummer\nStrafzeit",{"$nulls":4},"Drittel 1",{"$f":"Setup!B13","v":2000}]
[{"$nulls":15},"Pass","Zeit",{"$nulls":3},"Zeit",{"$nulls":3},"Zeit",null,"min",null,"Ende","Code",{"$nulls":5},"Drittel 2",{"$f":"AK2*2","v":4000}]
[{"$nulls":15},"No.","Temps",{"$nulls":3},"Temps",{"$nulls":14},"Drittel 3",{"$f":"AK2*3","v":6000}]
[{"$nulls":9},{"$f":"IF(INDIRECT($AJ$1&\"!a8\")=\"\",\"\",INDIRECT($AJ$1&\"!a8\"))","v":1},"C",{"$f":"IF(J5=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c8\")=\"\",\"\",INDIRECT($AJ$1&\"!c8\")),\", \",IF(INDIRECT($AJ$1&\"!d8\")=\"\",\"\",INDIRECT($AJ$1&\"!d8\"))))","v":"A, a"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},"Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e8\")=\"\",\"\",INDIRECT($AJ$1&\"!e8\"))","v":1000},{"$nulls":3},{"$f":"IF(TRIM(Q5)=\"\",\"\",1)","v":""},{"$nulls":3},{"$f":"IF(TRIM(U5)=\"\",\"\",T25+1)","v":""},{"$nulls":3},{"$f":"IF(AA5=\"\",0,VLOOKUP(AA5,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,1,{"$nulls":4},"Overtime",{"$f":"AK4+Setup!D13*Setup!D14","v":6000}]
[{"$nulls":9},{"$f":"IF(INDIRECT($AJ$1&\"!a9\")=\"\",\"\",INDIRECT($AJ$1&\"!a9\"))","v":2},"A",{"$f":"IF(J6=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c9\")=\"\",\"\",INDIRECT($AJ$1&\"!c9\")),\", \",IF(INDIRECT($AJ$1&\"!d9\")=\"\",\"\",INDIRECT($AJ$1&\"!d9\"))))","v":"A, b"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AJ$1&\"!e9\")=\"\",\"\",INDIRECT($AJ$1&\"!e9\"))","v":1001},{"$nulls":3},{"$f":"IF(TRIM(Q6)=\"\",\"\",T5+1)","v":""},{"$nulls":3},{"$f":"IF(TRIM(U6)=\"\",\"\",X5+1)","v":""},{"$nulls":3},{"$f":"IF(AA6=\"\",0,VLOOKUP(AA6,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,2,{"$nulls":4},"AnzahlDrittel",{"$f":"Setup!B14","v":3}]
[{"$nulls":3},"   Team / Mannschaft",{"$nulls":4},"League",{"$f":"IF(INDIRECT($AJ$1&\"!a10\")=\"\",\"\",INDIRECT($AJ$1&\"!a10\"))","v":3},"G",{"$f":"IF(J7=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c10\")=\"\",\"\",INDIRECT($AJ$1&\"!c10\")),\", \",IF(INDIRECT($AJ$1&\"!d10\")=\"\",\"\",INDIRECT($AJ$1&\"!d10\"))))","v":"A, c"},{"$nulls":3},{"$f":"IF(INDIRECT($AJ$1&\"!e10\")=\"\",\"\",INDIRECT($AJ$1&\"!e10\"))","v":1002},{"$nulls":3},{"$f":"IF(TRIM(Q7)=\"\",\"\",T6+1)","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA7=\"\",0,VLOOKUP(AA7,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,3]
[{"$nulls":8},"Liga",{"$f":"IF(INDIRECT($AJ$1&\"!a11\")=\"\",\"\",INDIRECT($AJ$1&\"!a11\"))","v":4},"G",{"$f":"IF(J8=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c11\")=\"\",\"\",INDIRECT($AJ$1&\"!c11\")),\", \",IF(INDIRECT($AJ$1&\"!d11\")=\"\",\"\",INDIRECT($AJ$1&\"!d11\"))))","v":"A, d"},{"$nulls":3},{"$f":"IF(INDIRECT($AJ$1&\"!e11\")=\"\",\"\",INDIRECT($AJ$1&\"!e11\"))","v":1003},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA8=\"\",0,VLOOKUP(AA8,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,4,{"$nulls":4},"Overtime?"]
["CLUB 1",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!c1\")=\"\",\"\",INDIRECT($AJ$1&\"!c1\")&\" \"&INDIRECT($AJ$1&\"!e1\"))","v":"a-Team 1"},{"$nulls":4},{"$f":"IF(D9=\"\",\"\",UPPER(SUBSTITUTE(INDIRECT(AJ1&\"!c2\"),\" \",\"\")))","v":"AB"},{"$f":"IF(INDIRECT($AJ$1&\"!a12\")=\"\",\"\",INDIRECT($AJ$1&\"!a12\"))","v":5},"F",{"$f":"IF(J9=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c12\")=\"\",\"\",INDIRECT($AJ$1&\"!c12\")),\", \",IF(INDIRECT($AJ$1&\"!d12\")=\"\",\"\",INDIRECT($AJ$1&\"!d12\"))))","v":"A, e"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AJ$1&\"!e12\")=\"\",\"\",INDIRECT($AJ$1&\"!e12\"))","v":1004},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA9=\"\",0,VLOOKUP(AA9,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,5,{"$nulls":4},"Heim 1",{"$f":"IF(MAX(Q5:Q26)>$AK$4,\"WAHR\",\"FALSCH\")","v":"FALSCH"},{"$f":"_xlfn.IFNA(MATCH(\"WAHR\",AK9:AK16,0),0)","v":0}]
[{"$nulls":9},{"$f":"IF(INDIRECT($AJ$1&\"!a13\")=\"\",\"\",INDIRECT($AJ$1&\"!a13\"))","v":6},"F",{"$f":"IF(J10=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c13\")=\"\",\"\",INDIRECT($AJ$1&\"!c13\")),\", \",IF(INDIRECT($AJ$1&\"!d13\")=\"\",\"\",INDIRECT($AJ$1&\"!d13\"))))","v":"A, f"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},"Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e13\")=\"\",\"\",INDIRECT($AJ$1&\"!e13\"))","v":1005},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA10=\"\",0,VLOOKUP(AA10,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,6,{"$nulls":4},"Heim 2",{"$f":"IF(MAX(U5:U24)>$AK$4,\"WAHR\",\"FALSCH\")","v":"FALSCH"}]
["CLUB 2",null,null,{"$f":"IF(INDIRECT($AK$1&\"!c1\")=\"\",\"\",INDIRECT($AK$1&\"!c1\")&\" \"&INDIRECT($AK$1&\"!e1\"))","v":"b-Team 2"},{"$nulls":4},{"$f":"IF(D11=\"\",\"\",UPPER(SUBSTITUTE(INDIRECT(AK1&\"!c2\"),\" \",\"\")))","v":"AB"},{"$f":"IF(INDIRECT($AJ$1&\"!a14\")=\"\",\"\",INDIRECT($AJ$1&\"!a14\"))","v":7},"F",{"$f":"IF(J11=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c14\")=\"\",\"\",INDIRECT($AJ$1&\"!c14\")),\", \",IF(INDIRECT($AJ$1&\"!d14\")=\"\",\"\",INDIRECT($AJ$1&\"!d14\"))))","v":"A, g"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e14\")=\"\",\"\",INDIRECT($AJ$1&\"!e14\"))","v":1006},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA11=\"\",0,VLOOKUP(AA11,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,7,{"$nulls":4},"Heim 3",{"$f":"IF(MAX(Y5:Y26)>$AK$4,\"WAHR\",\"FALSCH\")","v":"FALSCH"}]
[{"$nulls":9},{"$f":"IF(INDIRECT($AJ$1&\"!a15\")=\"\",\"\",INDIRECT($AJ$1&\"!a15\"))","v":8},"F",{"$f":"IF(J12=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c15\")=\"\",\"\",INDIRECT($AJ$1&\"!c15\")),\", \",IF(INDIRECT($AJ$1&\"!d15\")=\"\",\"\",INDIRECT($AJ$1&\"!d15\"))))","v":"A, h"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e15\")=\"\",\"\",INDIRECT($AJ$1&\"!e15\"))","v":1007},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA12=\"\",0,VLOOKUP(AA12,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,8,{"$nulls":4},"Heim 4",{"$f":"IF(MAX(AC5:AC26)>$AK$4,\"WAHR\",\"FALSCH\")","v":"FALSCH"}]
["Location",null,null,{"$f":"IF(Setup!B3=\"\",\"\",Setup!B3)","v":"a-Heim"},null,null,"Date",{"$f":"IF(Setup!B4=\"\",\"\",Setup!B4)","v":""},null,{"$f":"IF(INDIRECT($AJ$1&\"!a16\")=\"\",\"\",INDIRECT($AJ$1&\"!a16\"))","v":9},"F",{"$f":"IF(J13=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c16\")=\"\",\"\",INDIRECT($AJ$1&\"!c16\")),\", \",IF(INDIRECT($AJ$1&\"!d16\")=\"\",\"\",INDIRECT($AJ$1&\"!d16\"))))","v":"A, i"},{"$nulls":3},{"$f":"IF(INDIRECT($AJ$1&\"!e16\")=\"\",\"\",INDIRECT($AJ$1&\"!e16\"))","v":1008},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA13=\"\",0,VLOOKUP(AA13,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,9,null,"Zum Schluss!",null,null,"Gast 1",{"$f":"IF(MAX(Q34:Q55)>$AK$4,\"WAHR\",\"FALSCH\")","v":"FALSCH"}]
["Spielort",{"$nulls":5},"Datum",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!a17\")=\"\",\"\",INDIRECT($AJ$1&\"!a17\"))","v":10},"F",{"$f":"IF(J14=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c17\")=\"\",\"\",INDIRECT($AJ$1&\"!c17\")),\", \",IF(INDIRECT($AJ$1&\"!d17\")=\"\",\"\",INDIRECT($AJ$1&\"!d17\"))))","v":"A, j"},{"$nulls":3},{"$f":"IF(INDIRECT($AJ$1&\"!e17\")=\"\",\"\",INDIRECT($AJ$1&\"!e17\"))","v":1009},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA14=\"\",0,VLOOKUP(AA14,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,10,{"$nulls":4},"Gast 2",{"$f":"IF(MAX(U34:U53)>$AK$4,\"WAHR\",\"FALSCH\")","v":"FALSCH"}]
["Start",null,{"$f":"IF(Setup!B5=\"\",\"\",Setup!B5)","v":""},"End",null,{"$f":"IF(Setup!B6=\"\",\"\",Setup!B6)","v":""},"Match Number",null,{"$f":"IF(Setup!B7=\"\",\"\",Setup!B7)","v":""},{"$f":"IF(INDIRECT($AJ$1&\"!a18\")=\"\",\"\",INDIRECT($AJ$1&\"!a18\"))","v":11},"F",{"$f":"IF(J15=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c18\")=\"\",\"\",INDIRECT($AJ$1&\"!c18\")),\", \",IF(INDIRECT($AJ$1&\"!d18\")=\"\",\"\",INDIRECT($AJ$1&\"!d18\"))))","v":"A, k"},{"$nulls":3},{"$f":"IF(INDIRECT($AJ$1&\"!e18\")=\"\",\"\",INDIRECT($AJ$1&\"!e18\"))","v":1010},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA15=\"\",0,VLOOKUP(AA15,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,11,{"$nulls":4},"Gast 3",{"$f":"IF(MAX(Y34:Y55)>$AK$4,\"WAHR\",\"FALSCH\")","v":"FALSCH"}]
["Beginn",null,null,"Ende",null,null,"Spiel-Nr.",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!a19\")=\"\",\"\",INDIRECT($AJ$1&\"!a19\"))","v":12},"F",{"$f":"IF(J16=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c19\")=\"\",\"\",INDIRECT($AJ$1&\"!c19\")),\", \",IF(INDIRECT($AJ$1&\"!d19\")=\"\",\"\",INDIRECT($AJ$1&\"!d19\"))))","v":"A, l"},{"$nulls":3},{"$f":"IF(INDIRECT($AJ$1&\"!e19\")=\"\",\"\",INDIRECT($AJ$1&\"!e19\"))","v":1011},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA16=\"\",0,VLOOKUP(AA16,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,12,{"$nulls":4},"Gast 4",{"$f":"IF(MAX(AC34:AC55)>$AK$4,\"WAHR\",\"FALSCH\")","v":"FALSCH"}]
["Champoinship / Meisterschaft",{"$nulls":4},{"$f":"IF(Setup!B8=\"Meisterschaft\",\"X\",\"\")","v":"X"},"Friendly / Freundschaft",null,{"$f":"IF(Setup!$B$8=\"Freundschaft\",\"X\",\"\")","v":""},{"$f":"IF(INDIRECT($AJ$1&\"!a20\")=\"\",\"\",INDIRECT($AJ$1&\"!a20\"))","v":13},"F",{"$f":"IF(J17=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c20\")=\"\",\"\",INDIRECT($AJ$1&\"!c20\")),\", \",IF(INDIRECT($AJ$1&\"!d20\")=\"\",\"\",INDIRECT($AJ$1&\"!d20\"))))","v":"A, m"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},"Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e20\")=\"\",\"\",INDIRECT($AJ$1&\"!e20\"))","v":1012},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA17=\"\",0,VLOOKUP(AA17,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,13]
["Tournament / Turnier",{"$nulls":4},{"$f":"IF(Setup!$B$8=\"Turnier\",\"X\",\"\")","v":""},"Cup / Pokal",null,{"$f":"IF(Setup!$B$8=\"Pokal\",\"X\",\"\")","v":""},{"$f":"IF(INDIRECT($AJ$1&\"!a21\")=\"\",\"\",INDIRECT($AJ$1&\"!a21\"))","v":14},"F",{"$f":"IF(J18=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c21\")=\"\",\"\",INDIRECT($AJ$1&\"!c21\")),\", \",IF(INDIRECT($AJ$1&\"!d21\")=\"\",\"\",INDIRECT($AJ$1&\"!d21\"))))","v":"A, n"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e21\")=\"\",\"\",INDIRECT($AJ$1&\"!e21\"))","v":1013},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA18=\"\",0,VLOOKUP(AA18,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,14,{"$nulls":4},"GWG?"]
["Other / Sonstiges",{"$nulls":4},{"$f":"IF(Setup!$B$8=\"Sonstiges\",\"X\",\"\")","v":""},"Spectators / Zuschauer",null,{"$f":"IF(Setup!B9=\"\",\"\",Setup!B9)","v":300},{"$f":"IF(INDIRECT($AJ$1&\"!a22\")=\"\",\"\",INDIRECT($AJ$1&\"!a22\"))","v":15},"F",{"$f":"IF(J19=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c22\")=\"\",\"\",INDIRECT($AJ$1&\"!c22\")),\", \",IF(INDIRECT($AJ$1&\"!d22\")=\"\",\"\",INDIRECT($AJ$1&\"!d22\"))))","v":"A, o"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},"Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e22\")=\"\",\"\",INDIRECT($AJ$1&\"!e22\"))","v":1014},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA19=\"\",0,VLOOKUP(AA19,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,15,{"$nulls":4},"Heim 1",{"$f":"_xlfn.IFNA(VLOOKUP(\"GWG\",Q5:Q26,1,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(MATCH(\"GWG\",AK19:AK20,0),\"0\")","v":"0"},{"$f":"_xlfn.IFNA(MATCH(\"GWG\",AK19:AK22,0),\"0\")","v":"0"}]
[null,null,"Card No.",null,null,"Surname","Forname","Signature",null,{"$f":"IF(INDIRECT($AJ$1&\"!a23\")=\"\",\"\",INDIRECT($AJ$1&\"!a23\"))","v":16},"F",{"$f":"IF(J20=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c23\")=\"\",\"\",INDIRECT($AJ$1&\"!c23\")),\", \",IF(INDIRECT($AJ$1&\"!d23\")=\"\",\"\",INDIRECT($AJ$1&\"!d23\"))))","v":"A, p"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e23\")=\"\",\"\",INDIRECT($AJ$1&\"!e23\"))","v":1015},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA20=\"\",0,VLOOKUP(AA20,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,16,{"$nulls":4},"Heim 2",{"$f":"_xlfn.IFNA(VLOOKUP(\"GWG\",U5:U24,1,FALSE),0)","v":0}]
[null,null,"Lizenznummer",null,null,"Name","Vorname","Unterschrift",null,{"$f":"IF(INDIRECT($AJ$1&\"!a24\")=\"\",\"\",INDIRECT($AJ$1&\"!a24\"))","v":17},"F",{"$f":"IF(J21=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c24\")=\"\",\"\",INDIRECT($AJ$1&\"!c24\")),\", \",IF(INDIRECT($AJ$1&\"!d24\")=\"\",\"\",INDIRECT($AJ$1&\"!d24\"))))","v":"A, q"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e24\")=\"\",\"\",INDIRECT($AJ$1&\"!e24\"))","v":1016},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA21=\"\",0,VLOOKUP(AA21,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,17,null,"Version:","22.3.2024_Saison2024",null,"Gast 1",{"$f":"_xlfn.IFNA(VLOOKUP(\"GWG\",Q34:Q55,1,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(MATCH(\"GWG\",AK21:AK22,0),\"0\")","v":"0"}]
["Time Keeper",null,{"$f":"IF(Setup!E4=\"\",\"\",Setup!E4)","v":"5001"},null,null,{"$f":"IF(Setup!G4=\"\",\"\",Setup!G4)","v":"C"},{"$f":"IF(Setup!H4=\"\",\"\",Setup!H4)","v":"a"},null,null,{"$f":"IF(INDIRECT($AJ$1&\"!a25\")=\"\",\"\",INDIRECT($AJ$1&\"!a25\"))","v":18},"F",{"$f":"IF(J22=\"\",\"\",CONCATENATE(IF(INDIRECT($AJ$1&\"!c25\")=\"\",\"\",INDIRECT($AJ$1&\"!c25\")),\", \",IF(INDIRECT($AJ$1&\"!d25\")=\"\",\"\",INDIRECT($AJ$1&\"!d25\"))))","v":"A, r"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AJ$1&\"!e25\")=\"\",\"\",INDIRECT($AJ$1&\"!e25\"))","v":1017},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA22=\"\",0,VLOOKUP(AA22,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,18,{"$nulls":4},"Gast 2",{"$f":"_xlfn.IFNA(VLOOKUP(\"GWG\",U34:U53,1,FALSE),0)","v":0}]
["Zeitnehmer",{"$nulls":8},"COACH",null,"Surname                        Forname\nName                             Vorname","Signature",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!g1\")=\"\",\"\",INDIRECT($AJ$1&\"!g1\"))","v":18},{"$nulls":3},{"$f":"IF(TRIM(Q23)=\"\",\"\",T22+1)","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA23=\"\",0,VLOOKUP(AA23,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,19]
[{"$nulls":12},"Unterschrift",{"$nulls":14},{"$f":"IF(AA24=\"\",0,VLOOKUP(AA24,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}}]
["Official scorer",null,{"$f":"IF(Setup!E5=\"\",\"\",Setup!E5)","v":"5002"},null,null,{"$f":"IF(Setup!G5=\"\",\"\",Setup!G5)","v":"C"},{"$f":"IF(Setup!H5=\"\",\"\",Setup!H5)","v":"b"},{"$nulls":12},{"$f":"IF(TRIM(Q25)=\"\",\"\",T23+1)","v":""},"TOTAL",null,{"$f":"COUNT($T$5:$T$26,$X$5:$X$24)","v":0},{"$f":"COUNTA($T$5:$T$26,$X$5:$X$24)","v":39},{"$nulls":3},{"$f":"IF(AA25=\"\",0,VLOOKUP(AA25,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,20]
[{"$nulls":11},{"$f":"IF(D9=\"\",\"\",IF(INDIRECT($AJ$1&\"!c5\")=\"\",\"\",IF(INDIRECT($AJ$1&\"!d5\")=\"\",\"\",CONCATENATE(INDIRECT($AJ$1&\"!c5\"),\", \",INDIRECT($AJ$1&\"!d5\")))))","v":"A, z"},{"$nulls":10},{"$f":"COUNTA($T$5:$T$26,$X$5:$X$24)","v":39},{"$f":"COUNTA($T$5:$T$26,$X$5:$X$24)","v":39},{"$nulls":3},{"$f":"IF(AA26=\"\",0,VLOOKUP(AA26,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}}]
["Assistent",{"$nulls":15},"TIME OUT",{"$nulls":7},"TOTAL",{"$nulls":3},{"$f":"SUM(AB5:AB22)+AB23+AB25","v":0},"min."]
["Referee 1\nSR 1",null,{"$f":"IF(Setup!E6=\"\",\"\",Setup!E6)","v":"5003"},null,null,{"$f":"IF(Setup!G6=\"\",\"\",Setup!G6)","v":"D"},{"$f":"IF(Setup!H6=\"\",\"\",Setup!H6)","v":"a"},null,null,2,{"$f":"D11","v":"b-Team 2"},{"$nulls":5},"Goals/Torschützen",{"$nulls":7},"Penalties/Strafen"]
[]
[]
["Referee 2\nSR 2",null,{"$f":"IF(Setup!E7=\"\",\"\",Setup!E7)","v":"5004"},null,null,{"$f":"IF(Setup!G7=\"\",\"\",Setup!G7)","v":"D"},{"$f":"IF(Setup!H7=\"\",\"\",Setup!H7)","v":"b"},null,null,"Nr. No.","Surname                               Forname\nName                                    Vorname",{"$nulls":4},"Card","Time","G","A","T","Time","G","A","T","Time","Nr. No.",null,"Count","Fine",null,"Nummer\nStrafzeit"]
[{"$nulls":15},"Pass","Zeit",{"$nulls":3},"Zeit",{"$nulls":3},"Zeit",null,"min",null,"Ende","Code"]
[{"$nulls":15},"No."]
["Tecn. Director",null,{"$f":"IF(Setup!E8=\"\",\"\",Setup!E8)","v":"5005"},null,null,{"$f":"IF(Setup!G8=\"\",\"\",Setup!G8)","v":"E"},{"$f":"IF(Setup!H8=\"\",\"\",Setup!H8)","v":"a"},null,null,{"$f":"IF(INDIRECT($AK$1&\"!a8\")=\"\",\"\",INDIRECT($AK$1&\"!a8\"))","v":1},"C",{"$f":"IF(J34=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c8\")=\"\",\"\",INDIRECT($AK$1&\"!c8\")),\", \",IF(INDIRECT($AK$1&\"!d8\")=\"\",\"\",INDIRECT($AK$1&\"!d8\"))))","v":"B, a"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},"Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e8\")=\"\",\"\",INDIRECT($AK$1&\"!e8\"))","v":2001},{"$nulls":3},{"$f":"IF(TRIM(Q34)=\"\",\"\",1)","v":""},{"$nulls":3},{"$f":"IF(TRIM(U34)=\"\",\"\",T54+1)","v":""},{"$nulls":3},{"$f":"IF(AA34=\"\",0,VLOOKUP(AA34,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,1]
[{"$nulls":9},{"$f":"IF(INDIRECT($AK$1&\"!a9\")=\"\",\"\",INDIRECT($AK$1&\"!a9\"))","v":2},"A",{"$f":"IF(J35=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c9\")=\"\",\"\",INDIRECT($AK$1&\"!c9\")),\", \",IF(INDIRECT($AK$1&\"!d9\")=\"\",\"\",INDIRECT($AK$1&\"!d9\"))))","v":"B, b"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},{"$f":"IF(INDIRECT($AK$1&\"!e9\")=\"\",\"\",INDIRECT($AK$1&\"!e9\"))","v":2002},{"$nulls":3},{"$f":"IF(TRIM(Q35)=\"\",\"\",T34+1)","v":""},{"$nulls":3},{"$f":"IF(TRIM(U35)=\"\",\"\",X34+1)","v":""},{"$nulls":3},{"$f":"IF(AA35=\"\",0,VLOOKUP(AA35,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,2]
["RESULT / ERGEBNIS",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!a10\")=\"\",\"\",INDIRECT($AK$1&\"!a10\"))","v":3},"G",{"$f":"IF(J36=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c10\")=\"\",\"\",INDIRECT($AK$1&\"!c10\")),\", \",IF(INDIRECT($AK$1&\"!d10\")=\"\",\"\",INDIRECT($AK$1&\"!d10\"))))","v":"B, c"},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!e10\")=\"\",\"\",INDIRECT($AK$1&\"!e10\"))","v":2003},{"$nulls":3},{"$f":"IF(TRIM(Q36)=\"\",\"\",T35+1)","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA36=\"\",0,VLOOKUP(AA36,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,3]
["PERIOD SCORE",{"$nulls":5},"FINAL",null,null,{"$f":"IF(INDIRECT($AK$1&\"!a11\")=\"\",\"\",INDIRECT($AK$1&\"!a11\"))","v":4},"G",{"$f":"IF(J37=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c11\")=\"\",\"\",INDIRECT($AK$1&\"!c11\")),\", \",IF(INDIRECT($AK$1&\"!d11\")=\"\",\"\",INDIRECT($AK$1&\"!d11\"))))","v":"B, d"},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!e11\")=\"\",\"\",INDIRECT($AK$1&\"!e11\"))","v":2004},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA37=\"\",0,VLOOKUP(AA37,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,4]
["ZWISCHENSTAND",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!a12\")=\"\",\"\",INDIRECT($AK$1&\"!a12\"))","v":5},"F",{"$f":"IF(J38=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c12\")=\"\",\"\",INDIRECT($AK$1&\"!c12\")),\", \",IF(INDIRECT($AK$1&\"!d12\")=\"\",\"\",INDIRECT($AK$1&\"!d12\"))))","v":"B, e"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},"Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e12\")=\"\",\"\",INDIRECT($AK$1&\"!e12\"))","v":2005},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA38=\"\",0,VLOOKUP(AA38,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,5]
[null,null,"CLUB 1",null,null,"CLUB 2","CLUB 1","CLUB 2",null,{"$f":"IF(INDIRECT($AK$1&\"!a13\")=\"\",\"\",INDIRECT($AK$1&\"!a13\"))","v":6},"F",{"$f":"IF(J39=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c13\")=\"\",\"\",INDIRECT($AK$1&\"!c13\")),\", \",IF(INDIRECT($AK$1&\"!d13\")=\"\",\"\",INDIRECT($AK$1&\"!d13\"))))","v":"B, f"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e13\")=\"\",\"\",INDIRECT($AK$1&\"!e13\"))","v":2006},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA39=\"\",0,VLOOKUP(AA39,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,6]
["1 Time",{"$f":"SUM(COUNTIF($Q$5:$Q$26,\"<=\"&$AK$2),COUNTIF($U$5:$U$24,\"<=\"&$AK$2))","v":0},{"$f":"IF($AK$6>=1,$B40,\"\")","v":0},null,{"$f":"SUM(COUNTIF($Q$34:$Q$55,\"<=\"&$AK$2),COUNTIF($U$34:$U$53,\"<=\"&$AK$2))","v":0},{"$f":"IF($AK$6>=1,$E40,\"\")","v":0},{"$f":"SUM($C$40:$D$49)","v":0},{"$f":"SUM($F$40:$F$49)","v":0},{"$f":"SUM($F$40:$F$49)","v":0},{"$f":"IF(INDIRECT($AK$1&\"!a14\")=\"\",\"\",INDIRECT($AK$1&\"!a14\"))","v":7},"F",{"$f":"IF(J40=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c14\")=\"\",\"\",INDIRECT($AK$1&\"!c14\")),\", \",IF(INDIRECT($AK$1&\"!d14\")=\"\",\"\",INDIRECT($AK$1&\"!d14\"))))","v":"B, g"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e14\")=\"\",\"\",INDIRECT($AK$1&\"!e14\"))","v":2007},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA40=\"\",0,VLOOKUP(AA40,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,7]
["1. Drittel",{"$nulls":5},{"$f":"SUM($C$40:$D$49)","v":0},{"$f":"SUM($F$40:$F$49)","v":0},{"$f":"SUM($F$40:$F$49)","v":0},{"$f":"IF(INDIRECT($AK$1&\"!a15\")=\"\",\"\",INDIRECT($AK$1&\"!a15\"))","v":8},"F",{"$f":"IF(J41=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c15\")=\"\",\"\",INDIRECT($AK$1&\"!c15\")),\", \",IF(INDIRECT($AK$1&\"!d15\")=\"\",\"\",INDIRECT($AK$1&\"!d15\"))))","v":"B, h"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e15\")=\"\",\"\",INDIRECT($AK$1&\"!e15\"))","v":2008},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA41=\"\",0,VLOOKUP(AA41,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,8]
["2 Time",{"$f":"SUM(COUNTIF($Q$5:$Q$26,\"<=\"&$AK$3),COUNTIF($U$5:$U$24,\"<=\"&$AK$3))-B40","v":0},{"$f":"IF($AK$6>=2,$B42,\"\")","v":0},null,{"$f":"SUM(COUNTIF($Q$34:$Q$55,\"<=\"&$AK$3),COUNTIF($U$34:$U$53,\"<=\"&$AK$3))-E40","v":0},{"$f":"IF($AK$6>=2,$E42,\"\")","v":0},"Winner / Gewinner",null,null,{"$f":"IF(INDIRECT($AK$1&\"!a16\")=\"\",\"\",INDIRECT($AK$1&\"!a16\"))","v":9},"F",{"$f":"IF(J42=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c16\")=\"\",\"\",INDIRECT($AK$1&\"!c16\")),\", \",IF(INDIRECT($AK$1&\"!d16\")=\"\",\"\",INDIRECT($AK$1&\"!d16\"))))","v":"B, i"},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!e16\")=\"\",\"\",INDIRECT($AK$1&\"!e16\"))","v":2009},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA42=\"\",0,VLOOKUP(AA42,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,9]
["2. Drittel",{"$nulls":5},{"$f":"IF($G$40=$H$40,\"Unentschieden\",IF($G$40>$H$40,$D$9,IF($H$40>$G$40,$D$11,\"Fehler\")))","v":"Unentschieden"},{"$f":"IF($G$40=$H$40,\"Unentschieden\",IF($G$40>$H$40,$D$9,IF($H$40>$G$40,$D$11,\"Fehler\")))","v":"Unentschieden"},{"$f":"IF($G$40=$H$40,\"Unentschieden\",IF($G$40>$H$40,$D$9,IF($H$40>$G$40,$D$11,\"Fehler\")))","v":"Unentschieden"},{"$f":"IF(INDIRECT($AK$1&\"!a17\")=\"\",\"\",INDIRECT($AK$1&\"!a17\"))","v":10},"F",{"$f":"IF(J43=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c17\")=\"\",\"\",INDIRECT($AK$1&\"!c17\")),\", \",IF(INDIRECT($AK$1&\"!d17\")=\"\",\"\",INDIRECT($AK$1&\"!d17\"))))","v":"B, j"},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!e17\")=\"\",\"\",INDIRECT($AK$1&\"!e17\"))","v":2010},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA43=\"\",0,VLOOKUP(AA43,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,10]
["3 Time",{"$f":"SUM(COUNTIF($Q$5:$Q$26,\"<=\"&$AK$4),COUNTIF($U$5:$U$24,\"<=\"&$AK$4))-SUM(B40:B43)","v":0},{"$f":"IF($AK$6>=3,$B44,\"\")","v":0},null,{"$f":"SUM(COUNTIF($Q$34:$Q$55,\"<=\"&$AK$4),COUNTIF($U$34:$U$53,\"<=\"&$AK$4))-SUM(E40:E43)","v":0},{"$f":"IF($AK$6>=3,$E44,\"\")","v":0},"CAPTAIN 1 Signature/Unterschrift",null,null,{"$f":"IF(INDIRECT($AK$1&\"!a18\")=\"\",\"\",INDIRECT($AK$1&\"!a18\"))","v":11},"F",{"$f":"IF(J44=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c18\")=\"\",\"\",INDIRECT($AK$1&\"!c18\")),\", \",IF(INDIRECT($AK$1&\"!d18\")=\"\",\"\",INDIRECT($AK$1&\"!d18\"))))","v":"B, k"},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!e18\")=\"\",\"\",INDIRECT($AK$1&\"!e18\"))","v":2011},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA44=\"\",0,VLOOKUP(AA44,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,11]
["3. Drittel",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!a19\")=\"\",\"\",INDIRECT($AK$1&\"!a19\"))","v":12},"F",{"$f":"IF(J45=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c19\")=\"\",\"\",INDIRECT($AK$1&\"!c19\")),\", \",IF(INDIRECT($AK$1&\"!d19\")=\"\",\"\",INDIRECT($AK$1&\"!d19\"))))","v":"B, l"},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!e19\")=\"\",\"\",INDIRECT($AK$1&\"!e19\"))","v":2012},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA45=\"\",0,VLOOKUP(AA45,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,12]
["Overtime",{"$f":"SUM(COUNTIF($Q$5:$Q$26,\"<=\"&$AK$5),COUNTIF($U$5:$U$24,\"<=\"&$AK$5))-SUM(B40:B45)","v":0},{"$f":"IF(OR(AND(AL9>0,Setup!D14>0),AND(NOT(AM19=\"0\"),Setup!D14>0)),$B46,\"\")","v":""},null,{"$f":"SUM(COUNTIF($Q$34:$Q$55,\"<=\"&$AK$5),COUNTIF($U$34:$U$53,\"<=\"&$AK$5))-SUM(E40:E45)","v":0},{"$f":"IF(OR(AND(AL9>0,Setup!D14>0),AND(NOT(AM19=\"0\"),Setup!D14>0)),E46,\"\")","v":""},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!a20\")=\"\",\"\",INDIRECT($AK$1&\"!a20\"))","v":13},"F",{"$f":"IF(J46=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c20\")=\"\",\"\",INDIRECT($AK$1&\"!c20\")),\", \",IF(INDIRECT($AK$1&\"!d20\")=\"\",\"\",INDIRECT($AK$1&\"!d20\"))))","v":"B, m"},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},"Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e20\")=\"\",\"\",INDIRECT($AK$1&\"!e20\"))","v":2013},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA46=\"\",0,VLOOKUP(AA46,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,13]
["Verlängerung",{"$nulls":5},"CAPTAIN 2 Signature/Unterschrift",null,null,{"$f":"IF(INDIRECT($AK$1&\"!a21\")=\"\",\"\",INDIRECT($AK$1&\"!a21\"))","v":14},"F",{"$f":"IF(J47=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c21\")=\"\",\"\",INDIRECT($AK$1&\"!c21\")),\", \",IF(INDIRECT($AK$1&\"!d21\")=\"\",\"\",INDIRECT($AK$1&\"!d21\"))))","v":"B, n"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e21\")=\"\",\"\",INDIRECT($AK$1&\"!e21\"))","v":2014},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA47=\"\",0,VLOOKUP(AA47,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,14]
["Penalty",{"$f":"IF(NOT(AL19=\"0\"),1,0)","v":0},{"$f":"IF(NOT(AM19=\"0\"),B48,\"\")","v":""},null,{"$f":"IF(NOT(AL21=\"0\"),1,0)","v":0},{"$f":"IF(NOT(AM19=\"0\"),E48,\"\")","v":""},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!a22\")=\"\",\"\",INDIRECT($AK$1&\"!a22\"))","v":15},"F",{"$f":"IF(J48=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c22\")=\"\",\"\",INDIRECT($AK$1&\"!c22\")),\", \",IF(INDIRECT($AK$1&\"!d22\")=\"\",\"\",INDIRECT($AK$1&\"!d22\"))))","v":"B, o"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e22\")=\"\",\"\",INDIRECT($AK$1&\"!e22\"))","v":2015},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA48=\"\",0,VLOOKUP(AA48,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,15]
[{"$nulls":9},{"$f":"IF(INDIRECT($AK$1&\"!a23\")=\"\",\"\",INDIRECT($AK$1&\"!a23\"))","v":16},"F",{"$f":"IF(J49=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c23\")=\"\",\"\",INDIRECT($AK$1&\"!c23\")),\", \",IF(INDIRECT($AK$1&\"!d23\")=\"\",\"\",INDIRECT($AK$1&\"!d23\"))))","v":"B, p"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e23\")=\"\",\"\",INDIRECT($AK$1&\"!e23\"))","v":2016},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA49=\"\",0,VLOOKUP(AA49,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,16]
["Referees Comments",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!a24\")=\"\",\"\",INDIRECT($AK$1&\"!a24\"))","v":17},"F",{"$f":"IF(J50=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c24\")=\"\",\"\",INDIRECT($AK$1&\"!c24\")),\", \",IF(INDIRECT($AK$1&\"!d24\")=\"\",\"\",INDIRECT($AK$1&\"!d24\"))))","v":"B, q"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e24\")=\"\",\"\",INDIRECT($AK$1&\"!e24\"))","v":2017},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA50=\"\",0,VLOOKUP(AA50,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,17]
["SR-Bemerkungen",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!a25\")=\"\",\"\",INDIRECT($AK$1&\"!a25\"))","v":18},"F",{"$f":"IF(J51=\"\",\"\",CONCATENATE(IF(INDIRECT($AK$1&\"!c25\")=\"\",\"\",INDIRECT($AK$1&\"!c25\")),\", \",IF(INDIRECT($AK$1&\"!d25\")=\"\",\"\",INDIRECT($AK$1&\"!d25\"))))","v":"B, r"},"Trikotnummer","Trikotnummer","Trikotnummer",{"$f":"IF(INDIRECT($AK$1&\"!e25\")=\"\",\"\",INDIRECT($AK$1&\"!e25\"))","v":2018},{"$nulls":3},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA51=\"\",0,VLOOKUP(AA51,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,18]
[{"$nulls":9},"COACH",null,"Surname                        Forname\nName                             Vorname","Signature",null,null,{"$f":"IF(INDIRECT($AK$1&\"!g1\")=\"\",\"\",INDIRECT($AK$1&\"!g1\"))","v":18},{"$nulls":3},{"$f":"IF(TRIM(Q52)=\"\",\"\",T51+1)","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA52=\"\",0,VLOOKUP(AA52,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,19]
[{"$nulls":12},"Unterschrift",{"$nulls":14},{"$f":"IF(AA53=\"\",0,VLOOKUP(AA53,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}}]
[{"$nulls":19},{"$f":"IF(TRIM(Q54)=\"\",\"\",T52+1)","v":""},"TOTAL",null,{"$f":"COUNT($T$34:$T$54,$X$34:$X$53)","v":0},{"$f":"COUNTA($T$34:$T$54,$X$34:$X$53)","v":39},{"$nulls":3},{"$f":"IF(AA54=\"\",0,VLOOKUP(AA54,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,20]
[{"$nulls":11},{"$f":"IF(D11=\"\",\"\",IF(INDIRECT($AK$1&\"!c5\")=\"\",\"\",IF(INDIRECT($AK$1&\"!d5\")=\"\",\"\",CONCATENATE(INDIRECT($AK$1&\"!c5\"),\", \",INDIRECT($AK$1&\"!d5\")))))","v":"B, z"},{"$nulls":10},{"$f":"COUNTA($T$34:$T$54,$X$34:$X$53)","v":39},{"$f":"COUNTA($T$34:$T$54,$X$34:$X$53)","v":39},{"$nulls":3},{"$f":"IF(AA55=\"\",0,VLOOKUP(AA55,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}}]
["SPECIAL EVENT / BESONDERER VORFALL",{"$nulls":15},"TIME OUT",{"$nulls":7},"TOTAL",{"$nulls":3},{"$f":"SUM(AB34:AB51)+AB52+AB54","v":0},"min."]

{"sheet":"Spielbericht (2)","index":6,"n_rows":56,"n_cols":39,"rows_kept":56,"hidden":true,"merged":[[0,0,5,2],[0,3,5,8],[0,10,0,15],[0,16,0,23],[0,24,0,29],[0,31,22,31],[0,32,0,33],[0,34,22,34],[1,9,3,9],[1,10,3,14],[1,17,3,17],[1,18,3,18],[1,19,3,19],[1,21,3,21],[1,22,3,22],[1,23,3,23],[1,25,3,25],[1,27,3,27],[1,30,3,30],[1,32,22,33],[4,11,4,14],[5,11,5,14],[6,0,7,2],[6,3,7,7],[7,35,7,36],[8,0,9,2],[8,3,9,7],[8,8,9,8],[8,11,8,14],[9,11,9,14],[10,0,11,2],[10,3,11,7],[10,8,11,8],[10,11,10,14],[11,11,11,14],[12,0,12,2],[12,3,13,5],[12,7,13,8],[12,11,12,14],[13,0,13,2],[13,11,13,14],[14,2,15,2],[14,5,15,5],[14,8,15,8],[14,11,14,14],[15,11,15,14],[16,11,16,14],[17,11,17,14],[17,35,17,36],[18,11,18,14],[19,0,20,0],[19,11,19,14],[20,11,20,14],[21,2,23,3],[21,5,23,5],[21,6,23,6],[21,7,23,8],[21,11,21,14],[22,9,26,10],[22,11,24,11],[22,12,22,14],[22,15,24,15],[22,16,23,16],[22,17,23,17],[22,18,23,18],[22,19,23,19],[22,20,23,20],[22,21,23,21],[22,22,23,22],[22,23,23,23],[22,24,23,24],[22,25,23,25],[22,26,23,26],[22,27,23,27],[22,28,23,28],[22,29,23,29],[22,30,23,30],[23,12,23,14],[24,2,26,3],[24,5,26,5],[24,6,26,6],[24,7,26,8],[24,12,24,14],[24,16,25,16],[24,17,25,17],[24,18,25,18],[24,19,25,19],[24,20,25,21],[24,22,25,23],[24,24,25,24],[24,25,25,25],[24,26,25,26],[24,27,25,27],[24,28,25,28],[24,29,25,29],[24,30,25,30],[25,11,26,11],[25,12,26,15],[26,16,26,19],[26,24,26,26],[27,2,29,3],[27,5,29,5],[27,6,29,6],[27,7,29,8],[27,9,29,9],[27,10,29,15],[27,16,29,23],[27,24,29,29],[30,2,32,3],[30,5,32,5],[30,6,32,6],[30,7,32,8],[30,9,32,9],[30,10,32,14],[30,17,32,17],[30,18,32,18],[30,19,32,19],[30,21,32,21],[30,22,32,22],[30,23,32,23],[30,25,32,25],[30,27,32,27],[30,30,32,30],[33,2,34,3],[33,5,34,5],[33,6,34,6],[33,7,34,8],[33,11,33,14],[34,11,34,14],[35,5,35,6],[36,6,37,8],[37,11,37,14],[38,2,38,3],[38,7,38,8],[38,11,38,14],[39,1,40,1],[39,2,40,3],[39,4,40,4],[39,5,40,5],[39,6,40,6],[39,7,40,8],[39,11,39,14],[40,11,40,14],[41,1,42,1],[41,2,42,3],[41,4,42,4],[41,5,42,5],[41,6,41,8],[41,11,41,14],[42,6,42,8],[42,11,42,14],[43,1,44,1],[43,2,44,3],[43,4,44,4],[43,5,44,5],[43,11,43,14],[44,6,45,8],[44,11,44,14],[45,1,46,1],[45,2,46,3],[45,4,46,4],[45,5,46,5],[45,11,45,14],[46,11,46,14],[47,1,48,1],[47,2,48,3],[47,4,48,4],[47,5,48,5],[47,6,48,8],[47,11,47,14],[48,11,48,14],[49,3,54,8],[49,11,49,14],[50,11,50,14],[51,0,52,2],[51,9,55,10],[51,11,53,11],[51,12,51,14],[51,15,53,15],[51,16,52,16],[51,17,52,17],[51,18,52,18],[51,19,52,19],[51,20,52,20],[51,21,52,21],[51,22,52,22],[51,23,52,23],[51,24,52,24],[51,25,52,25],[51,26,52,26],[51,27,52,27],[51,28,52,28],[51,29,52,29],[51,30,52,30],[52,12,52,14],[53,0,54,2],[53,12,53,14],[53,16,54,16],[53,17,54,17],[53,18,54,18],[53,19,54,19],[53,20,54,21],[53,22,54,23],[53,24,54,24],[53,25,54,25],[53,26,54,26],[53,27,54,27],[53,28,54,28],[53,29,54,29],[53,30,54,30],[54,11,55,11],[54,12,55,15],[55,0,55,7],[55,16,55,19],[55,24,55,26]]}
[{"$nulls":3},"Match Sheet Skater Hockey                        Spielbericht Inline Hockey                         Rapport de jeu                                             Rapporto di gara                                        ",{"$nulls":5},1,{"$f":"D9","v":18},{"$nulls":5},"Goals/Torschützen/Buts/Reti",{"$nulls":7},"Penalties/Strafen/Punitions",{"$nulls":7},"Zum Schluss!",null,null,"Club1","Club2"]
[{"$nulls":9},"Nr. No.","Surname/Name                 Forname/Vorname        Nom/Prénom                     Nome/Cognome",{"$nulls":4},"Card/Pass","Time","G","A","T","Time","G","A","T","Time","Nr. No.",null,"Count","On/",null,"Nummer\nStrafzeit",{"$nulls":4},"Drittel 1",{"$f":"VLOOKUP(I9,Daten!#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
[{"$nulls":15},"Lic./Tess","Zeit",{"$nulls":3},"Zeit",{"$nulls":3},"Zeit",null,"min",null,"Ende/","code",{"$nulls":5},"Drittel 2",{"$f":"AK2*2","v":{"$error":"#REF!"}}]
[{"$nulls":15},"No.","Temps",{"$nulls":3},"Temps",{"$nulls":3},"Temps",{"$nulls":3},"Fin/Fine",{"$nulls":6},"Drittel 3",{"$f":"AK2*3","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"IF(INDIRECT($AJ$1&\"!A2\")=\"\",\"\",INDIRECT($AJ$1&\"!A2\"))","v":"Liga:"},"C",{"$nulls":8},{"$f":"IF(Q5=\"\",\"\",1)","v":""},{"$nulls":3},{"$f":"IF(U5=\"\",\"\",T25+1)","v":""},{"$nulls":3},{"$f":"IF(AA5=\"\",0,VLOOKUP(AA5,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,1,{"$nulls":4},"Overtime",{"$f":"AK4+VLOOKUP(I9,Daten!#REF!,4,FALSE)*VLOOKUP(I9,Daten!#REF!,5,FALSE)","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"IF(INDIRECT($AJ$1&\"!A3\")=\"\",\"\",INDIRECT($AJ$1&\"!A3\"))","v":""},"A",{"$nulls":8},{"$f":"IF(Q6=\"\",\"\",T5+1)","v":""},{"$nulls":3},{"$f":"IF(U6=\"\",\"\",X5+1)","v":""},{"$nulls":3},{"$f":"IF(AA6=\"\",0,VLOOKUP(AA6,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,2,{"$nulls":4},"AnzahlDrittel",{"$f":"VLOOKUP(I9,Daten!#REF!,3,FALSE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"   Team/Mannschaft/Club/Società",{"$nulls":4},"League/Liga",{"$f":"IF(INDIRECT($AJ$1&\"!A4\")=\"\",\"\",INDIRECT($AJ$1&\"!A4\"))","v":""},"G",{"$nulls":8},{"$f":"IF(Q7=\"\",\"\",T6+1)","v":""},{"$nulls":3},{"$f":"IF(U7=\"\",\"\",X6+1)","v":""},{"$nulls":3},{"$f":"IF(AA7=\"\",0,VLOOKUP(AA7,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,3]
[{"$nulls":8},"Ligue/ Lega",{"$f":"IF(INDIRECT($AJ$1&\"!A5\")=\"\",\"\",INDIRECT($AJ$1&\"!A5\"))","v":""},"G",{"$nulls":8},{"$f":"IF(Q8=\"\",\"\",T7+1)","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA8=\"\",0,VLOOKUP(AA8,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,4,{"$nulls":4},"Overtime?"]
["CLUB 1",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!g1\")=\"\",\"\",INDIRECT($AJ$1&\"!g1\"))","v":18},{"$nulls":4},{"$f":"IF(D9=\"\",\"\",SUBSTITUTE(INDIRECT(AJ1&\"!g2\"),\" \",\"\"))","v":""},{"$f":"IF(INDIRECT($AJ$1&\"!A6\")=\"\",\"\",INDIRECT($AJ$1&\"!A6\"))","v":""},"F",{"$nulls":8},{"$f":"IF(Q9=\"\",\"\",T8+1)","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA9=\"\",0,VLOOKUP(AA9,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,5,{"$nulls":4},"Heim 1",{"$f":"IF(MAX(Q5:Q26)>$AK$4,\"WAHR\",\"FALSCH\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.IFNA(MATCH(\"WAHR\",AK9:AK16,0),0)","v":0}]
[{"$nulls":9},{"$f":"IF(INDIRECT($AJ$1&\"!A7\")=\"\",\"\",INDIRECT($AJ$1&\"!A7\"))","v":"Trikotnummer"},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA10=\"\",0,VLOOKUP(AA10,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,6,{"$nulls":4},"Heim 2",{"$f":"IF(MAX(U5:U24)>$AK$4,\"WAHR\",\"FALSCH\")","v":{"$error":"#REF!"}}]
["CLUB 2",null,null,{"$f":"IF(INDIRECT($AK$1&\"!g1\")=\"\",\"\",INDIRECT($AK$1&\"!g1\"))","v":18},{"$nulls":4},{"$f":"IF(D11=\"\",\"\",SUBSTITUTE(INDIRECT(AK1&\"!g2\"),\" \",\"\"))","v":""},{"$f":"IF(INDIRECT($AJ$1&\"!A8\")=\"\",\"\",INDIRECT($AJ$1&\"!A8\"))","v":1},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA11=\"\",0,VLOOKUP(AA11,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,7,{"$nulls":4},"Heim 3",{"$f":"IF(MAX(Y5:Y26)>$AK$4,\"WAHR\",\"FALSCH\")","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"IF(INDIRECT($AJ$1&\"!A9\")=\"\",\"\",INDIRECT($AJ$1&\"!A9\"))","v":2},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA12=\"\",0,VLOOKUP(AA12,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,8,{"$nulls":4},"Heim 4",{"$f":"IF(MAX(AC5:AC26)>$AK$4,\"WAHR\",\"FALSCH\")","v":{"$error":"#REF!"}}]
["Location/Ort/",null,null,"Düsseldorf",null,null,"Date/Datum/",{"$f":"TODAY()","v":"2024-03-22"},null,{"$f":"IF(INDIRECT($AJ$1&\"!A10\")=\"\",\"\",INDIRECT($AJ$1&\"!A10\"))","v":3},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA13=\"\",0,VLOOKUP(AA13,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,9,{"$nulls":4},"Gast 1",{"$f":"IF(MAX(Q34:Q55)>$AK$4,\"WAHR\",\"FALSCH\")","v":{"$error":"#REF!"}}]
["Lieu/Luogo",{"$nulls":5},"Date/Data",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!A11\")=\"\",\"\",INDIRECT($AJ$1&\"!A11\"))","v":4},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA14=\"\",0,VLOOKUP(AA14,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,10,{"$nulls":4},"Gast 2",{"$f":"IF(MAX(U34:U53)>$AK$4,\"WAHR\",\"FALSCH\")","v":{"$error":"#REF!"}}]
["Start/Beginn/",null,null,"End/Ende/",null,null,"Match Number/Spiel-Nr./",null,10,{"$f":"IF(INDIRECT($AJ$1&\"!A12\")=\"\",\"\",INDIRECT($AJ$1&\"!A12\"))","v":5},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA15=\"\",0,VLOOKUP(AA15,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,11,{"$nulls":4},"Gast 3",{"$f":"IF(MAX(Y34:Y55)>$AK$4,\"WAHR\",\"FALSCH\")","v":{"$error":"#REF!"}}]
["Début/Inizio",null,null,"Fin/Fine",null,null,"Index/Indice di gara",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!A13\")=\"\",\"\",INDIRECT($AJ$1&\"!A13\"))","v":6},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA16=\"\",0,VLOOKUP(AA16,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,12,{"$nulls":4},"Gast 4",{"$f":"IF(MAX(AC34:AC55)>$AK$4,\"WAHR\",\"FALSCH\")","v":{"$error":"#REF!"}}]
["Champoinship/Meisterschaft./Championnat",{"$nulls":5},"Friendly/Freundschaft/Amical",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!A14\")=\"\",\"\",INDIRECT($AJ$1&\"!A14\"))","v":7},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA17=\"\",0,VLOOKUP(AA17,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,13]
["Tournament/Turnier/Tournoi/Torneo",{"$nulls":5},"Cup/Pokal/Coupe/Coppa",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!A15\")=\"\",\"\",INDIRECT($AJ$1&\"!A15\"))","v":8},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA18=\"\",0,VLOOKUP(AA18,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,14,{"$nulls":4},"GWG?"]
["Other/Sonstiges/Autre/Altro",{"$nulls":5},"Spectators/Zuschauer/Spectateurs",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!A16\")=\"\",\"\",INDIRECT($AJ$1&\"!A16\"))","v":9},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA19=\"\",0,VLOOKUP(AA19,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,15,{"$nulls":4},"Heim 1",{"$f":"_xlfn.IFNA(VLOOKUP(\"GWG\",Q5:Q26,1,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(MATCH(\"GWG\",AK19:AK20,0),\"0\")","v":"0"},{"$f":"_xlfn.IFNA(MATCH(\"GWG\",AK19:AK22,0),\"0\")","v":"0"}]
[null,null,"Card/Liz.No.",null,null,"Surname/Name","Forename/Vorname","Signature",null,{"$f":"IF(INDIRECT($AJ$1&\"!A17\")=\"\",\"\",INDIRECT($AJ$1&\"!A17\"))","v":10},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA20=\"\",0,VLOOKUP(AA20,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,16,{"$nulls":4},"Heim 2",{"$f":"_xlfn.IFNA(VLOOKUP(\"GWG\",U5:U24,1,FALSE),0)","v":0}]
[null,null,"Lic./Tess",null,null,"Nom/Prénom","Cognome/Nome","Unterschrift/Firma",null,{"$f":"IF(INDIRECT($AJ$1&\"!A18\")=\"\",\"\",INDIRECT($AJ$1&\"!A18\"))","v":11},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA21=\"\",0,VLOOKUP(AA21,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,17,{"$nulls":4},"Gast 1",{"$f":"_xlfn.IFNA(VLOOKUP(\"GWG\",Q34:Q55,1,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(MATCH(\"GWG\",AK21:AK22,0),\"0\")","v":"0"}]
["Time Keeper",{"$nulls":8},{"$f":"IF(INDIRECT($AJ$1&\"!A19\")=\"\",\"\",INDIRECT($AJ$1&\"!A19\"))","v":12},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA22=\"\",0,VLOOKUP(AA22,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,18,{"$nulls":4},"Gast 2",{"$f":"_xlfn.IFNA(VLOOKUP(\"GWG\",U34:U53,1,FALSE),0)","v":0}]
["Zeitnehmer",{"$nulls":8},"COACH",null,"Surname/Name Forname/Vorname Nom/Prénom     Nome/Cognome","Signature",null,null,{"$f":"IF(INDIRECT($AJ$1&\"!g3\")=\"\",\"\",INDIRECT($AJ$1&\"!g3\"))","v":""},{"$nulls":3},{"$f":"IF(Q23=\"\",\"\",T22+1)","v":""},{"$nulls":3},{"$f":"IF(U23=\"\",\"\",X22+1)","v":""},{"$nulls":3},{"$f":"IF(AA23=\"\",0,VLOOKUP(AA23,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,19]
["Chronométreur",{"$nulls":11},"Unterschrift",{"$nulls":14},{"$f":"IF(AA24=\"\",0,VLOOKUP(AA24,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}}]
["Official scorer",{"$nulls":11},"Firma",{"$nulls":6},{"$f":"IF(Q25=\"\",\"\",T23+1)","v":""},"TOTAL",null,{"$f":"COUNT($T$5:$T$26,$X$5:$X$24)","v":0},{"$f":"COUNTA($T$5:$T$26,$X$5:$X$24)","v":39},{"$nulls":3},{"$f":"IF(AA25=\"\",0,VLOOKUP(AA25,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,20]
["Assistent",{"$nulls":21},{"$f":"COUNTA($T$5:$T$26,$X$5:$X$24)","v":39},{"$f":"COUNTA($T$5:$T$26,$X$5:$X$24)","v":39},{"$nulls":3},{"$f":"IF(AA26=\"\",0,VLOOKUP(AA26,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}}]
["Marqueur",{"$nulls":15},"TIME OUT",{"$nulls":7},"TOTAL",{"$nulls":3},{"$f":"SUM(AB5:AB22)+AB23+AB25","v":{"v":0,"d":"0.0"}},"min."]
["Referee",{"$nulls":8},2,{"$f":"D11","v":18},{"$nulls":5},"Goals/Torschützen/Buts/Reti",{"$nulls":7},"Penalties/Strafen/Punitions"]
["Schiedrichter 1"]
["Arbitre"]
["Referee",{"$nulls":8},"Nr. No.","Surname/Name                 Forname/Vorname        Nom/Prénom                     Nome/Cognome",{"$nulls":4},"Card/Pass","Time","G","A","T","Time","G","A","T","Time","Nr. No.",null,"Count","On/",null,"Nummer\nStrafzeit"]
["Schiedrichter 2",{"$nulls":14},"Lic./Tess","Zeit",{"$nulls":3},"Zeit",{"$nulls":3},"Zeit",null,"min",null,"Ende/","code"]
["Arbitre",{"$nulls":14},"No.","Temps",{"$nulls":3},"Temps",{"$nulls":3},"Temps",{"$nulls":3},"Fin/Fine"]
["Tecn. Director",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!A2\")=\"\",\"\",INDIRECT($AK$1&\"!A2\"))","v":"Liga:"},"C",{"$nulls":8},{"$f":"IF(Q34=\"\",\"\",1)","v":""},{"$nulls":3},{"$f":"IF(U34=\"\",\"\",T54+1)","v":""},{"$nulls":3},{"$f":"IF(AA34=\"\",0,VLOOKUP(AA34,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,1]
["Directeur tech.",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!A3\")=\"\",\"\",INDIRECT($AK$1&\"!A3\"))","v":""},"A",{"$nulls":8},{"$f":"IF(Q35=\"\",\"\",T34+1)","v":""},{"$nulls":3},{"$f":"IF(U35=\"\",\"\",X34+1)","v":""},{"$nulls":3},{"$f":"IF(AA35=\"\",0,VLOOKUP(AA35,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,2]
[{"$nulls":5},"RESULT",{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!A4\")=\"\",\"\",INDIRECT($AK$1&\"!A4\"))","v":""},"G",{"$nulls":8},{"$f":"IF(Q36=\"\",\"\",T35+1)","v":""},{"$nulls":3},{"$f":"IF(U36=\"\",\"\",X35+1)","v":""},{"$nulls":3},{"$f":"IF(AA36=\"\",0,VLOOKUP(AA36,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,3]
["PERIOD SCORE/ZWISCHENSTAND",{"$nulls":5},"FINAL",null,null,{"$f":"IF(INDIRECT($AK$1&\"!A5\")=\"\",\"\",INDIRECT($AK$1&\"!A5\"))","v":""},"G",{"$nulls":8},{"$f":"IF(Q37=\"\",\"\",T36+1)","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA37=\"\",0,VLOOKUP(AA37,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,4]
["INTERMEDIAIRE/INTERMEDIO",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!A6\")=\"\",\"\",INDIRECT($AK$1&\"!A6\"))","v":""},"F",{"$nulls":8},{"$f":"IF(Q38=\"\",\"\",T37+1)","v":""},{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA38=\"\",0,VLOOKUP(AA38,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,5]
[null,null,"CLUB 1",null,null,"CLUB 2","CLUB 1","CLUB 2",null,{"$f":"IF(INDIRECT($AK$1&\"!A7\")=\"\",\"\",INDIRECT($AK$1&\"!A7\"))","v":"Trikotnummer"},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA39=\"\",0,VLOOKUP(AA39,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,6]
["1 Time/Drittel",{"$f":"SUM(COUNTIF($Q$5:$Q$26,\"<=\"&$AK$2),COUNTIF($U$5:$U$24,\"<=\"&$AK$2))","v":0},{"$f":"IF($AK$6>=1,$B40,\"\")","v":{"$error":"#REF!"}},null,{"$f":"SUM(COUNTIF($Q$34:$Q$55,\"<=\"&$AK$2),COUNTIF($U$34:$U$53,\"<=\"&$AK$2))","v":0},{"$f":"IF($AK$6>=1,$E40,\"\")","v":{"$error":"#REF!"}},{"$f":"SUM($C$40:$D$49)","v":{"$error":"#REF!"}},{"$f":"SUM($F$40:$F$49)","v":{"$error":"#REF!"}},{"$f":"SUM($F$40:$F$49)","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT($AK$1&\"!A8\")=\"\",\"\",INDIRECT($AK$1&\"!A8\"))","v":1},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA40=\"\",0,VLOOKUP(AA40,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,7]
["Tiers/Tempo",{"$nulls":5},{"$f":"SUM($C$40:$D$49)","v":{"$error":"#REF!"}},{"$f":"SUM($F$40:$F$49)","v":{"$error":"#REF!"}},{"$f":"SUM($F$40:$F$49)","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT($AK$1&\"!A9\")=\"\",\"\",INDIRECT($AK$1&\"!A9\"))","v":2},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA41=\"\",0,VLOOKUP(AA41,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,8]
["2 Time/Drittel",{"$f":"SUM(COUNTIF($Q$5:$Q$26,\"<=\"&$AK$3),COUNTIF($U$5:$U$24,\"<=\"&$AK$3))-B40","v":0},{"$f":"IF($AK$6>=2,$B42,\"\")","v":{"$error":"#REF!"}},null,{"$f":"SUM(COUNTIF($Q$34:$Q$55,\"<=\"&$AK$3),COUNTIF($U$34:$U$53,\"<=\"&$AK$3))-E40","v":0},{"$f":"IF($AK$6>=2,$E42,\"\")","v":{"$error":"#REF!"}},"Winner/Gewinner/Vainqueur/Vincitore",null,null,{"$f":"IF(INDIRECT($AK$1&\"!A10\")=\"\",\"\",INDIRECT($AK$1&\"!A10\"))","v":3},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA42=\"\",0,VLOOKUP(AA42,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,9]
["Tiers/Tempo",{"$nulls":5},{"$f":"IF($G$40=$H$40,\"Unentschieden\",IF($G$40>$H$40,$D$9,IF($H$40>$G$40,$D$11,\"Fehler\")))","v":{"$error":"#REF!"}},{"$f":"IF($G$40=$H$40,\"Unentschieden\",IF($G$40>$H$40,$D$9,IF($H$40>$G$40,$D$11,\"Fehler\")))","v":{"$error":"#REF!"}},{"$f":"IF($G$40=$H$40,\"Unentschieden\",IF($G$40>$H$40,$D$9,IF($H$40>$G$40,$D$11,\"Fehler\")))","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT($AK$1&\"!A11\")=\"\",\"\",INDIRECT($AK$1&\"!A11\"))","v":4},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA43=\"\",0,VLOOKUP(AA43,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,10]
["3 Time/Drittel",{"$f":"SUM(COUNTIF($Q$5:$Q$26,\"<=\"&$AK$4),COUNTIF($U$5:$U$24,\"<=\"&$AK$4))-SUM(B40:B43)","v":0},{"$f":"IF($AK$6>=3,$B44,\"\")","v":{"$error":"#REF!"}},null,{"$f":"SUM(COUNTIF($Q$34:$Q$55,\"<=\"&$AK$4),COUNTIF($U$34:$U$53,\"<=\"&$AK$4))-SUM(E40:E43)","v":0},{"$f":"IF($AK$6>=3,$E44,\"\")","v":{"$error":"#REF!"}},"CAPTAIN 1 Signature/Unterschrift",null,null,{"$f":"IF(INDIRECT($AK$1&\"!A12\")=\"\",\"\",INDIRECT($AK$1&\"!A12\"))","v":5},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA44=\"\",0,VLOOKUP(AA44,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,11]
["Tiers/Tempo",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!A13\")=\"\",\"\",INDIRECT($AK$1&\"!A13\"))","v":6},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA45=\"\",0,VLOOKUP(AA45,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,12]
["Overtime/Verl.",{"$f":"SUM(COUNTIF($Q$5:$Q$26,\"<=\"&$AK$5),COUNTIF($U$5:$U$24,\"<=\"&$AK$5))-SUM(B40:B45)","v":0},{"$f":"IF($AL$9>0,$B46,\"\")","v":""},null,{"$f":"SUM(COUNTIF($Q$34:$Q$55,\"<=\"&$AK$5),COUNTIF($U$34:$U$53,\"<=\"&$AK$5))-SUM(E40:E45)","v":0},{"$f":"IF($AL$9>0,$E46,\"\")","v":""},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!A14\")=\"\",\"\",INDIRECT($AK$1&\"!A14\"))","v":7},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA46=\"\",0,VLOOKUP(AA46,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,13]
["Prol./Sup.",{"$nulls":5},"CAPTAIN 2 Signature/Unterschrift",null,null,{"$f":"IF(INDIRECT($AK$1&\"!A15\")=\"\",\"\",INDIRECT($AK$1&\"!A15\"))","v":8},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA47=\"\",0,VLOOKUP(AA47,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,14]
["Penalty/",{"$f":"IF(NOT(AL19=\"0\"),1,0)","v":0},{"$f":"IF(NOT(AM19=\"0\"),B48,\"\")","v":""},null,{"$f":"IF(NOT(AL21=\"0\"),1,0)","v":0},{"$f":"IF(NOT(AM19=\"0\"),E48,\"\")","v":""},{"$nulls":3},{"$f":"IF(INDIRECT($AK$1&\"!A16\")=\"\",\"\",INDIRECT($AK$1&\"!A16\"))","v":9},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA48=\"\",0,VLOOKUP(AA48,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,15]
["Rigori",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!A17\")=\"\",\"\",INDIRECT($AK$1&\"!A17\"))","v":10},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA49=\"\",0,VLOOKUP(AA49,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,16]
["Referees Comments",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!A18\")=\"\",\"\",INDIRECT($AK$1&\"!A18\"))","v":11},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA50=\"\",0,VLOOKUP(AA50,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,17]
["SR-Bemerkungen",{"$nulls":8},{"$f":"IF(INDIRECT($AK$1&\"!A19\")=\"\",\"\",INDIRECT($AK$1&\"!A19\"))","v":12},"F",{"$nulls":8},"",{"$nulls":3},"",{"$nulls":3},{"$f":"IF(AA51=\"\",0,VLOOKUP(AA51,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,18]
["Remarques arb.",{"$nulls":8},"COACH",null,"Surname/Name Forname/Vorname Nom/Prénom     Nome/Cognome","Signature",null,null,{"$f":"IF(INDIRECT($AK$1&\"!g3\")=\"\",\"\",INDIRECT($AK$1&\"!g3\"))","v":""},{"$nulls":3},{"$f":"IF(Q52=\"\",\"\",T51+1)","v":""},{"$nulls":3},{"$f":"IF(U52=\"\",\"\",X51+1)","v":""},{"$nulls":3},{"$f":"IF(AA52=\"\",0,VLOOKUP(AA52,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,19]
[{"$nulls":12},"Unterschrift",{"$nulls":14},{"$f":"IF(AA53=\"\",0,VLOOKUP(AA53,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}}]
["Osservazioni arb.",{"$nulls":11},"Firma",{"$nulls":6},{"$f":"IF(Q54=\"\",\"\",T52+1)","v":""},"TOTAL",null,{"$f":"COUNT($T$34:$T$54,$X$34:$X$53)","v":0},{"$f":"COUNTA($T$34:$T$54,$X$34:$X$53)","v":39},{"$nulls":3},{"$f":"IF(AA54=\"\",0,VLOOKUP(AA54,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}},null,null,20]
[{"$nulls":22},{"$f":"COUNTA($T$34:$T$54,$X$34:$X$53)","v":39},{"$f":"COUNTA($T$34:$T$54,$X$34:$X$53)","v":39},{"$nulls":3},{"$f":"IF(AA55=\"\",0,VLOOKUP(AA55,Daten!$B$2:$C$11,2,FALSE))","v":{"v":0,"d":"0.0"}}]
["SPECIAL EVENT/BESONDERER VORFALL/EVENEMENT SPECIAL/EVENTO SPECIAL",{"$nulls":15},"TIME OUT",{"$nulls":7},"TOTAL",{"$nulls":3},{"$f":"SUM(AB34:AB51)+AB52+AB54","v":{"v":0,"d":"0.0"}},"min."]

{"sheet":"Zusatzblatt","index":7,"n_rows":58,"n_cols":27,"rows_kept":58,"merged":[[0,0,1,13],[0,25,0,26],[2,0,2,13],[7,1,7,5],[7,7,7,9],[7,12,7,13],[7,17,8,20],[7,22,11,22],[8,1,8,5],[8,7,8,9],[8,12,8,13],[9,1,9,5],[9,7,9,13],[9,17,9,18],[10,1,10,5],[10,7,10,13],[10,17,11,20],[11,2,11,3],[13,2,13,20],[14,2,14,10],[14,13,14,20],[15,2,15,10],[15,13,15,20],[16,2,16,10],[16,13,16,18],[16,19,16,20],[17,2,17,10],[17,13,17,20],[18,0,18,2],[18,3,18,10],[18,13,18,20],[19,0,19,2],[19,3,19,10],[19,13,19,20],[20,0,20,2],[20,3,20,10],[20,13,20,20],[21,0,21,2],[21,3,21,10],[21,13,21,20],[22,0,22,2],[22,3,22,10],[22,13,22,20],[23,0,23,2],[23,3,23,10],[23,13,23,20],[24,2,24,10],[24,14,24,20],[25,2,25,10],[25,14,25,20],[27,2,27,20],[28,2,28,10],[28,13,28,20],[29,2,29,10],[29,13,29,20],[30,2,30,10],[30,13,30,20],[31,2,31,10],[31,13,31,20],[32,2,32,10],[32,13,32,20],[33,2,33,6],[33,7,33,11],[33,13,33,20],[34,2,34,10],[34,13,34,20],[35,2,35,10],[35,13,35,20],[36,2,36,10],[36,13,36,20],[38,2,38,20],[39,2,39,5],[39,8,39,9],[39,12,39,13],[39,14,39,15],[40,2,40,15],[41,5,41,7],[41,8,41,15],[41,16,41,19],[42,2,42,3],[42,5,42,7],[42,8,42,15],[42,16,42,19],[43,2,43,3],[43,5,43,7],[43,8,43,15],[43,16,43,19],[44,2,44,3],[44,5,44,7],[44,8,44,15],[44,16,44,19],[46,2,46,20],[47,2,47,20],[51,7,52,12],[51,17,52,20],[53,7,53,12],[53,17,53,20],[55,2,56,5],[55,7,56,12],[55,17,56,20],[57,2,57,5],[57,7,57,12],[57,17,57,20]]}
["Deutscher Rollsport und Inline Verband e.V.",{"$nulls":24},"Zum Schluss!"]
[]
["Inline-Skaterhockey Deutschland (ISHD)"]
[]
[]
[{"$nulls":25},"Version:","22.3.2024_Saison2024"]
[]
[null,{"$f":"IF(Spielbericht!D13=\"\",\"\",Spielbericht!D13)","v":"a-Heim"},{"$nulls":5},{"$f":"IF(Spielbericht!I9=\"\",\"\",Spielbericht!I9)","v":"AB"},{"$nulls":4},{"$f":"IF(Spielbericht!H13=\"\",\"\",Spielbericht!H13)","v":""},{"$nulls":4},"e-Zusatzblatt zum Spielbericht",{"$nulls":4},{"$f":"YEAR(TODAY())","v":2024}]
[null,"Spielort",{"$nulls":5},"Liga",{"$nulls":4},"Datum"]
[null,{"$f":"IF(Spielbericht!D9=\"\",\"\",Spielbericht!D9)","v":"a-Team 1"},{"$nulls":4},"-",{"$f":"IF(Spielbericht!D11=\"\",\"\",Spielbericht!D11)","v":"b-Team 2"},{"$nulls":9},"Spielnummer:",null,{"$f":"IF(Spielbericht!I15=\"\",\"\",Spielbericht!I15)","v":""}]
[null,"Heimmannschaft",{"$nulls":5},"Gastmannschaft",{"$nulls":9},"Verstöße bitte im Zusatzblatt \"Besondere Vorkommnisse\" erfassen!"]
[null,{"$f":"IF(Setup!$B$8=\"Meisterschaft\",\"X\",\"\")","v":"X"},"Meisterschaft",null,{"$f":"IF(Setup!$B$8=\"Pokal\",\"X\",\"\")","v":""},"Pokal",{"$f":"IF(Setup!$B$8=\"Turnier\",\"X\",\"\")","v":""},"Turnier",null,{"$f":"IF(OR(Setup!$B$8=\"Freundschaft\",Setup!$B$8=\"Sonstiges\"),\"X\",\"\")","v":""},"Freundschaft/Sonstiges"]
[]
[null,null,"30 Minuten vor Spielbeginn"]
[null,null,"Checkliste für die Zeitnehmer",{"$nulls":10},"Checkliste für die Schiedsrichter"]
[null,null,"Schiedsrichter anwesend (s. Daten auf Spielbericht)",{"$nulls":10},"Zeitnehmer anwesend (s. Daten auf Spielbericht)"]
[null,null,"Schiedsricherausweise kontrollieren",{"$nulls":10},"gültige Nutzungserlaubnis, Nr.: ",{"$nulls":5},"19-07-2022"]
[null,null,"Schiedsrichterausrüstung (gem. §64 WKO)",{"$nulls":10},"Sind ausreichend Ordner vorhanden/gekennzeichnet"]
[{"$nulls":3},"Offizielles Schiedsrichtertrikot*",{"$nulls":9},"Aufstellung und Spielerpässe kontrollieren"]
[{"$nulls":3},"Offizielle Schiedsrichterhose*",{"$nulls":9},"Spielerkleidung (Hosen & Trikots)"]
[{"$nulls":3},"Kartensatz*",{"$nulls":9},"Trainer & -Lizenznummer (s. Mannschaftsaufstellung)"]
[{"$nulls":3},"Schiedsrichterpfeife mit Fingergriff",{"$nulls":9},"Teamoffizielle gemäß Aufstellung"]
[{"$nulls":3},"Inlineskates od. Rollschuhe",{"$nulls":9},"Zweiter Trikotsatz (bei Bedarf)"]
[{"$nulls":3},"Schwarzer Helm",{"$nulls":9},"BL-Bestimmungen (gem. §§52 & 53 WKO)"]
[null,null,"*gemäß den veröffentlichten Richtlinien",{"$nulls":11},"Trikots, Spielerzahl (1.BL: 10+2 / 2.BL: 8+1 / 1.DBL: 6+1)"]
[{"$nulls":14},"Spielfeldrundungen und Anzeigetafel"]
[]
[null,null,"Rechtzeitig vor Spielbeginn"]
[null,null,"Ausrüstung am Zeitnehmertisch",{"$nulls":10},"Spielfeld-Ausrüstung"]
[null,null,"Bandmaß (mind. 2 Meter)",{"$nulls":10},"Umkleideräume Gast u. Schiedsrichter"]
[null,null,"2 Sätze Schiedsrichterkarten, 2 Pfeifen",{"$nulls":10},"Spieler- und Strafbänke, Zeitnehmertisch*"]
[null,null,"10 offizielle Bälle",{"$nulls":10},"Zwei maßgerechte Tore mit Tornetzen*"]
[null,null,"Manuelle Toranzeige, Ersatz-Tonquelle",{"$nulls":10},"Trinkflaschenhalter an beiden Toren"]
[null,null,"EH-Ausrüstung & Ersthelfer / Name:",{"$nulls":10},"Fangnetze in beiden Toren"]
[null,null,"Handelsüblicher Lappen (Wischtuch)",{"$nulls":10},"Saubere Spielfläche u. befestigte Bande*"]
[null,null,"Spielregeln & WKO in der gültigen Fassung",{"$nulls":10},"Pflichtlinien (Torraum, Bully, Abstandslinien)*"]
[null,null,"Spielberichtsbogen, Spieluhr, 1 Spielball*",{"$nulls":10},"* Bei Fehlen dieser Ausrüstung darf das Spiel nicht angepfiffen werden!"]
[]
[null,null,"Nach dem Spiel"]
[null,null,"Schiedsrichterbezahlung",{"$nulls":4},"SR1: Spiel",null,null,"von",null,"SR2: Spiel",{"$nulls":3},"von"]
[null,null,"(Anfahrtskosten sind anteilig auf die Anzahl der geleiteten Spiele zu verteilen)"]
[{"$nulls":5},"Fahrkosten",null,null,"Aufwandsentschädigung",{"$nulls":7},"Spielgebühren",{"$nulls":3},"Gesamt"]
[null,null,"Schiedsrichter 1",{"$nulls":17},{"$f":"F43+I43+Q43","v":0}]
[null,null,"Schiedsrichter 2",{"$nulls":17},{"$f":"F44+I44+Q44","v":0}]
[null,null,"Gesamt",null,null,{"$f":"F43+F44","v":0},null,null,{"$f":"I43+I44","v":0},{"$nulls":7},{"$f":"Q43+Q44","v":0},{"$nulls":3},{"$f":"F45+I45+Q45","v":0}]
[]
[null,null,"Spielbericht und Zusatzblätter unterschreiben lassen + ausreichend frankierter & korrekt adressierter Briefumschlag!"]
[null,null,"Mit ihrer Unterschrift bestätigen die Unterzeichner die korrekte Prüfung der Checklisten bzw. die Kenntnisnahme der Ausführungen."]
[]
[]
[]
[]
[]
[{"$nulls":7},"Unterschrift Heimmannschaft",{"$nulls":9},"Unterschrift Gastmannschaft"]
[]
[]
[]
[null,null,"Unterschrift Zeitnehmer 1",{"$nulls":4},"Unterschrift Schiedsrichter 1",{"$nulls":9},"Unterschrift Schiedsrichter 2"]

{"sheet":"Strafzeitencodes","index":8,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Penaltyschießen","index":9,"n_rows":54,"n_cols":25,"rows_kept":54,"merged":[[0,0,1,13],[0,14,2,19],[0,20,6,20],[0,23,0,24],[2,0,2,13],[3,0,54,0],[3,1,6,19],[5,23,5,24],[7,1,7,5],[7,6,8,6],[7,7,7,8],[7,9,8,9],[7,11,7,13],[7,14,11,14],[7,15,8,19],[7,20,11,20],[8,1,8,5],[8,7,8,8],[8,11,8,13],[9,1,9,5],[9,6,9,7],[9,8,9,13],[9,16,9,19],[10,1,10,5],[10,6,10,7],[10,8,10,13],[10,15,11,19],[11,2,11,3],[11,10,11,13],[12,2,12,19],[12,20,54,20],[13,2,13,5],[13,6,13,11],[13,13,13,14],[13,15,13,19],[14,2,14,5],[14,6,14,11],[14,13,14,14],[14,15,14,19],[15,2,15,19],[16,2,16,19],[17,2,17,19],[18,2,19,2],[18,3,19,4],[18,5,19,7],[18,8,20,10],[18,11,20,11],[18,12,19,12],[18,13,19,13],[18,14,19,16],[18,17,20,19],[20,3,20,4],[20,5,20,7],[20,14,20,16],[21,2,21,19],[22,2,22,19],[23,2,24,2],[23,3,24,3],[23,5,24,7],[23,8,23,10],[23,11,27,11],[23,12,24,12],[23,13,24,13],[23,14,24,16],[23,17,23,19],[24,9,27,9],[24,18,27,18],[25,3,25,4],[25,5,25,7],[25,14,25,16],[26,3,26,4],[26,5,26,7],[26,14,26,16],[27,3,27,4],[27,5,27,7],[27,14,27,16],[28,2,28,19],[29,2,29,19],[30,2,31,2],[30,3,31,4],[30,5,31,7],[30,8,30,10],[30,11,33,11],[30,12,31,12],[30,13,31,13],[30,14,31,16],[30,17,30,19],[31,9,33,9],[31,18,33,18],[32,3,32,4],[32,5,32,7],[32,14,32,16],[33,3,33,4],[33,5,33,7],[33,14,33,16],[34,2,34,19],[35,2,35,19],[36,2,37,2],[36,3,37,4],[36,5,37,7],[36,8,36,10],[36,11,42,11],[36,12,37,12],[36,13,37,13],[36,14,37,16],[36,17,36,19],[37,9,42,9],[37,18,42,18],[38,3,38,4],[38,5,38,7],[38,14,38,16],[39,3,39,4],[39,5,39,7],[39,14,39,16],[40,3,40,4],[40,5,40,7],[40,14,40,16],[41,3,41,4],[41,5,41,7],[41,14,41,16],[42,3,42,4],[42,5,42,7],[42,14,42,16],[43,2,44,19],[45,2,45,19],[46,2,49,3],[46,4,49,19],[50,2,50,19],[51,2,53,6],[51,7,52,13],[51,14,53,14],[51,15,52,19],[53,7,53,13],[53,15,53,19],[54,2,54,19]]}
["Deutscher Rollsport und Inline Verband e.V.",{"$nulls":22},"Zum Schluss!"]
[]
["Inline-Skaterhockey Deutschland (ISHD)"]
[]
[]
[{"$nulls":23},"Fehler?"]
[]
[null,{"$f":"IF(Spielbericht!D13=\"\",\"\",Spielbericht!D13)","v":"a-Heim"},{"$nulls":5},{"$f":"IF(Spielbericht!I9=\"\",\"\",Spielbericht!I9)","v":"AB"},{"$nulls":3},{"$f":"IF(Spielbericht!H13=\"\",\"\",Spielbericht!H13)","v":""},{"$nulls":3},"e-Penaltyschießen",{"$nulls":4},{"$f":"YEAR(TODAY())","v":2024}]
[null,"Spielort",{"$nulls":5},"Liga",{"$nulls":3},"Datum"]
[null,{"$f":"IF(Spielbericht!D9=\"\",\"\",Spielbericht!D9)","v":"a-Team 1"},{"$nulls":4},"-",null,{"$f":"IF(Spielbericht!D11=\"\",\"\",Spielbericht!D11)","v":"b-Team 2"},{"$nulls":6},"Spielnummer:",{"$f":"IF(Spielbericht!I15=\"\",\"\",Spielbericht!I15)","v":""}]
[null,"Heimmannschaft",{"$nulls":6},"Gastmannschaft",{"$nulls":14},"Version:","22.3.2024_Saison2024"]
[null,{"$f":"IF(Setup!$B$8=\"Meisterschaft\",\"X\",\"\")","v":"X"},"Meisterschaft",null,{"$f":"IF(Setup!$B$8=\"Pokal\",\"X\",\"\")","v":""},"Pokal",{"$f":"IF(Setup!$B$8=\"Turnier\",\"X\",\"\")","v":""},"Turnier",null,{"$f":"IF(OR(Setup!$B$8=\"Freundschaft\",Setup!$B$8=\"Sonstiges\"),\"X\",\"\")","v":""},"Freundschaft/Sonstiges"]
[]
[{"$nulls":6},"Heimverein",{"$nulls":8},"Gastverein"]
[null,null,"Beginn*:"]
[null,null,"* Bitte ankreuzen, welches Team das Penaltyschießen beginnt."]
[]
[null,null,"Torhüter (1)"]
[{"$nulls":3},"Trikot-Nr.",null,"Name, Vorname",{"$nulls":7},"Trikot-Nr.","Name, Vorname"]
[]
[null,null,1,3,null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D21,Club1!$A$8:$E$25,4,FALSE))","v":"A, c"},{"$nulls":6},1,3,{"$f":"IF(N21=\"\",\"\",VLOOKUP(N21,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N21,Club2!$A$8:$E$25,4,FALSE))","v":"B, c"}]
[]
[null,null,"Feldspieler (5)"]
[{"$nulls":3},"Trikot-Nr.",null,"Name, Vorname",null,null,"Torerfolg",{"$nulls":4},"Trikot-Nr.","Name, Vorname",null,null,"Torerfolg"]
[{"$nulls":8},"ja",null,"nein",{"$nulls":6},"ja",null,"nein"]
[null,null,1,null,null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D26,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},1,null,{"$f":"IF(N26=\"\",\"\",VLOOKUP(N26,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N26,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,2,null,null,{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D27,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},2,null,{"$f":"IF(N27=\"\",\"\",VLOOKUP(N27,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N27,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,3,null,null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D28,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},3,null,{"$f":"IF(N28=\"\",\"\",VLOOKUP(N28,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N28,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[]
[null,null,"Ab hier Shoot-Out"]
[{"$nulls":3},"Trikot-Nr.",null,"Name, Vorname",null,null,"Torerfolg",{"$nulls":4},"Trikot-Nr.","Name, Vorname",null,null,"Torerfolg"]
[{"$nulls":8},"ja",null,"nein",{"$nulls":6},"ja",null,"nein"]
[null,null,4,null,null,{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D33,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},4,null,{"$f":"IF(N33=\"\",\"\",VLOOKUP(N33,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N33,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,5,null,null,{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D34,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},5,null,{"$f":"IF(N34=\"\",\"\",VLOOKUP(N34,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N34,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,"Sollte keine Entscheidung gefallen sein, wird der Shoot-Out in der selben Reihenfolge, mit denselben Feldspielern fortgesetzt."]
[]
[{"$nulls":3},"Trikot-Nr.",null,"Name, Vorname",null,null,"Torerfolg",{"$nulls":4},"Trikot-Nr.","Name, Vorname",null,null,"Torerfolg"]
[{"$nulls":8},"ja",null,"nein",{"$nulls":6},"ja",null,"nein"]
[null,null,1,{"$f":"IF(D26=\"\",\"\",D26)","v":""},null,{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D39,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},1,{"$f":"IF(N26=\"\",\"\",N26)","v":""},{"$f":"IF(N39=\"\",\"\",VLOOKUP(N39,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N39,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,2,{"$f":"IF(D27=\"\",\"\",D27)","v":""},null,{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D40,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},2,{"$f":"IF(N27=\"\",\"\",N27)","v":""},{"$f":"IF(N40=\"\",\"\",VLOOKUP(N40,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N40,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,3,{"$f":"IF(D28=\"\",\"\",D28)","v":""},null,{"$f":"IF(D41=\"\",\"\",VLOOKUP(D41,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D41,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},3,{"$f":"IF(N28=\"\",\"\",N28)","v":""},{"$f":"IF(N41=\"\",\"\",VLOOKUP(N41,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N41,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,4,{"$f":"IF(D33=\"\",\"\",D33)","v":""},null,{"$f":"IF(D42=\"\",\"\",VLOOKUP(D42,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D42,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},4,{"$f":"IF(N33=\"\",\"\",N33)","v":""},{"$f":"IF(N42=\"\",\"\",VLOOKUP(N42,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N42,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,5,{"$f":"IF(D34=\"\",\"\",D34)","v":""},null,{"$f":"IF(D43=\"\",\"\",VLOOKUP(D43,Club1!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(D43,Club1!$A$8:$E$25,4,FALSE))","v":""},{"$nulls":6},5,{"$f":"IF(N34=\"\",\"\",N34)","v":""},{"$f":"IF(N43=\"\",\"\",VLOOKUP(N43,Club2!$A$8:$E$25,3,FALSE)&\", \"&VLOOKUP(N43,Club2!$A$8:$E$25,4,FALSE))","v":""}]
[null,null,"Sollte keine Entscheidung gefallen sein, wird der Shoot-Out in derselben Reihenfolge, mit denselben Feldspielern fortgesetzt\n(für die Fortsetzung bitte separates Blatt benutzen)."]
[]
[]
[null,null,"Bemerkung:"]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"Schiedsrichter 1",{"$nulls":7},"Schiedsrichter 2"]

{"sheet":"BesondereVorkommnisse","index":10,"n_rows":61,"n_cols":23,"rows_kept":61,"merged":[[0,0,1,11],[0,21,0,22],[2,0,2,11],[4,21,4,22],[7,1,7,5],[7,7,7,8],[7,10,7,11],[7,13,7,17],[7,18,12,18],[8,1,8,5],[8,7,8,8],[8,10,8,11],[8,13,12,17],[10,1,10,5],[10,6,10,7],[10,8,10,11],[11,1,11,5],[11,8,11,11],[14,1,14,11],[14,15,14,16],[16,1,16,8],[16,10,16,11],[16,13,16,17],[17,1,17,8],[17,10,17,11],[17,13,17,17],[19,1,19,8],[19,10,19,11],[19,13,19,17],[20,1,20,8],[20,10,20,11],[20,13,20,17],[22,1,22,8],[22,10,22,11],[22,13,22,17],[23,1,23,8],[23,10,23,11],[23,13,23,17],[25,1,25,17],[27,1,27,8],[27,10,27,11],[27,13,27,14],[27,16,27,17],[28,1,29,8],[28,10,29,11],[28,13,29,14],[28,16,29,17],[31,1,31,17],[33,1,33,12],[34,1,34,5],[34,6,34,12],[35,3,35,12],[36,3,36,12],[37,3,37,12],[40,1,48,17],[50,1,50,5],[50,7,50,8],[50,10,50,11],[50,14,50,17],[52,7,55,11],[52,13,53,17],[54,13,55,17],[57,7,58,10],[57,13,58,17],[59,7,59,10],[59,13,59,17],[60,7,60,17]]}
["Deutscher Rollsport und Inline Verband e.V.",{"$nulls":20},"Zum Schluss!"]
[]
["Inline-Skaterhockey Deutschland (ISHD)"]
[]
[{"$nulls":21},"BV kopieren?"]
[]
[]
[null,{"$f":"IF(Spielbericht!D13=\"\",\"\",Spielbericht!D13)","v":"a-Heim"},{"$nulls":5},{"$f":"IF(Spielbericht!I9=\"\",\"\",Spielbericht!I9)","v":"AB"},null,null,{"$f":"IF(Spielbericht!H13=\"\",\"\",Spielbericht!H13)","v":""},null,null,"e-Besondere Vorkommnisse",{"$nulls":4},{"$f":"YEAR(TODAY())","v":2024}]
[null,"Spielort",{"$nulls":5},"Liga",null,null,"Datum",{"$nulls":10},"Version:","22.3.2024_Saison2024"]
[]
[null,{"$f":"IF(Spielbericht!D9=\"\",\"\",Spielbericht!D9)","v":"a-Team 1"},{"$nulls":4},"-",null,{"$f":"IF(Spielbericht!D11=\"\",\"\",Spielbericht!D11)","v":"b-Team 2"}]
[null,"Heimmannschaft",{"$nulls":6},"Gastmannschaft"]
[null,{"$f":"IF(Setup!$B$8=\"Meisterschaft\",\"X\",\"\")","v":"X"},"Meisterschaft",null,{"$f":"IF(Setup!$B$8=\"Pokal\",\"X\",\"\")","v":""},"Pokal",{"$f":"IF(Setup!$B$8=\"Turnier\",\"X\",\"\")","v":""},"Turnier",null,{"$f":"IF(OR(Setup!$B$8=\"Freundschaft\",Setup!$B$8=\"Sonstiges\"),\"X\",\"\")","v":""},"Freundschaft/Sonstiges"]
[]
[null,"Anwesende Offizielle (nur bei Matchstrafe oder Disziplinarvergehen ausfüllen)",{"$nulls":13},"Spielnummer:",null,{"$f":"Spielbericht!I15","v":""}]
[]
[null,{"$f":"IF(K17=\"\",\"\",Setup!G6&\", \"&Setup!H6&\" / \"&Setup!F6)","v":"D, a / b-Heim"},{"$nulls":8},{"$f":"IF(Setup!E6=\"\",\"\",Setup!E6)","v":"5003"}]
[null,"Schiedsrichter 1 / Verein",{"$nulls":8},"Passnummer",null,null,"Telefonnummer"]
[]
[null,{"$f":"IF(K20=\"\",\"\",Setup!G7&\", \"&Setup!H7&\" / \"&Setup!F7)","v":"D, b / b-Heim"},{"$nulls":8},{"$f":"IF(Setup!E7=\"\",\"\",Setup!E7)","v":"5004"}]
[null,"Schiedsrichter 2 / Verein",{"$nulls":8},"Passnummer",null,null,"Telefonnummer"]
[]
[]
[null,"ggf. weitere Zeugen",{"$nulls":8},"Funktion",null,null,"Telefonnummer"]
[]
[null,"Betroffene Person (Für jede betroffene Person und für jeden Vorfall ist ein separates Blatt auszufüllen)"]
[]
[null,{"$f":"IF(K28=\"\",\"\",VLOOKUP(K28,Gesamt!A2:E37,4,FALSE)&\", \"&VLOOKUP(K28,Gesamt!A2:E37,5,FALSE)&\" / \"&VLOOKUP(K28,Gesamt!A2:F37,6,FALSE))","v":"A, a / a-Team"},{"$nulls":8},1000,null,null,{"$f":"IF(K28=\"\",\"\",VLOOKUP(K28,Gesamt!A2:E37,2,FALSE))","v":1}]
[null,"Vorname und Nachname / Verein",{"$nulls":8},"Passnummer",null,null,"Trikotnummer",null,null,"Drittel / Spielzeit oder Uhrzeit des Vergehens"]
[]
[]
[null,"Detaillierte Beschreibung des Vorfalls (ggf. Rückseite verwenden und dort nochmals unterschreiben!)"]
[]
[null,"Bei Matchstrafen bitte beantworten (und in der Beschreibung erläutern):\n\n"]
[null,"Grund der Matchstrafe:"]
[{"$nulls":3},"Der gefoulte Spieler wurde verletzt"]
[{"$nulls":3},"Der Spieler konnte das Spiel nicht fortsetzen"]
[{"$nulls":3},"Rettungsdienst wurde gerufen"]
{"$rows_empty":12}
[null,"Angaben erfolgten durch"]
[]
[{"$nulls":7},"Nur bei Matchstrafe: Mit seiner Unterschrift bestätigt der Kapitän / Assistent die Kenntisnahme der o.a. Matchstrafe gegen den o.a. Spieler seiner Mannschaft"]
[]
[{"$nulls":13},"Unterschrift Kapitän / Assistent / Teamoffizieller der betreffenden Mannschaft"]
[]
[]
[]
[]
[{"$nulls":7},"Unterschrift Schiedsrichter 1",{"$nulls":5},"Unterschrift Schiedsrichter 2"]
[{"$nulls":7},"Mit ihrer Unterschrift bestätigen die Schiedsrichter die wahrheitsgemäße und sachlich korrekte Darstellung."]