{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Hauptmenü","Hinweise","Bericht1","Druck1","Bericht2","Druck2","Bericht3","Druck3","Bericht4","Druck4","Bericht5","Druck5","Bericht6","Druck6","Bericht7","Druck7","Bericht 7-1","Daten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Hauptmenü","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,6,2,11],[3,6,3,11]]}
[]
[]
[null,null,null,null,null,null,"Spielberichte LVKB Sachsen-Anhalt"]
[null,null,null,null,null,null,"Sektion Bohle"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Version 3.0"]

{"sheet":"Hinweise","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"Hinweise zur Nutzung"]
[]
[null,"Für die Nutzung müssen die Makros aktiviert sein"]
[null,"Bei neueren Excel Versionen funktioniert dieses wie folgt:"]
[null,"1. Auf Registerkarte Datei klicken"]
[null,"2. Option wählen"]
[null,"3. Zur Rubrik \"Trust Center\" wechseln"]
[null,"4. Die Schaltfläche Einstellungen Trust Center wählen"]
[null,"5. In die Rubrik Einstellungen für Makros wechseln"]
[null,"6. Auf alle Makros aktivieren Aktivieren von VBA Makros) klicken"]
[]
[null,"Für den Fall das ein Streichergebnis benötigt wird, in dem \"gelben Feld\" bei dem entsprechenden Spieler ein \"Kreuz\" setzen. "]
[null,"Mehr ist nicht notwendig!!!"]
[]
[null,"Das aktuelle Datum wird mit dem Button \"Datum\" eingestellt"]
[]
[null,"Sämtliche Eingaben werden mit dem Button \"Eingaben löschen\" auf Null gesetzt"]
[]
[null,"Über den Button \"zur Druckseite\" gelangt man in den Bereich wo der fertige Spielbericht ausgedruckt werden kann"]
[]
[null,"Die Auswahl der Liga, der Altersklasse, der Heimmannschaft, der Gastmannschaft, Spielpässe, Werbung sowie des Spielorts sind mittels der \"Drag Down Liste\" auszuwählen"]
[]
[null,"Hinweise zur 4+1 oder 4+2 Regelung"]
[null,"Zur ordnungsgemäßen Darstellung des Spielberichtes müssen immer die erforderlichen Spieler (4, 5 oder 6)"]
[null,"je Mannschaft namentlich eingetragen werden. Es genügt, wenn eine Mannschaft in Unterzahl antritt,"]
[null,"dass für den 4., 5. oder 6. Spieler ein beliebiges Zeichen in die Namensspalte eingetragen wird."]

{"sheet":"Bericht1","index":2,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,2,9,12],[5,5,5,14],[5,17,5,27],[25,16,25,17],[26,2,26,13],[14,2,14,3],[14,16,14,17],[18,2,18,3],[18,16,18,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[25,2,25,3],[41,2,41,13],[41,16,41,27],[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[39,2,39,13],[39,16,39,27],[26,16,26,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[38,16,38,27],[28,2,28,27],[29,2,29,27],[35,2,36,3],[35,16,36,17],[35,4,36,4],[35,18,36,18],[0,1,0,28],[1,1,1,28],[3,3,3,14],[9,16,9,26],[15,2,15,3],[15,16,15,17],[3,17,3,27],[11,2,11,3],[11,16,11,17],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[8,2,8,12],[8,13,8,15],[8,16,8,27]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:"]
[]
[null,null,"Spiel-Nr.:",null,"Datum:",null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz",null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz",null,null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":""},null,null,{"$f":"IF(SUM(I13:L13)=0,\"\",SUM(I13:L13))","v":""},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(E13=\"\",\"\",IF(AND(O13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N13)))","v":""},{"$f":"IF(G13=\"\",\"\",IF($AG$12=2,RANK(G13,($G$13:$G$19,$U$13:$U$19),'Bericht 7-1'!M128)+COUNTIF($U$13:U13,G13),IF($AG$12=4,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U$14,G13))))","v":""},null,{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":""},null,null,{"$f":"IF(SUM(W13:Z13)=0,\"\",SUM(W13:Z13))","v":""},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":""},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(S13=\"\",\"\",IF(AND(AC13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB13)))","v":""},{"$f":"IF(U13=\"\",\"\",RANK(U13,($G$13:$G$19,$U$13:$U$19),0))","v":""}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":""},null,null,{"$f":"SUM(I14:L14)","v":0},null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G14=\"\",\"\",IF($AG$12=2,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14),IF($AG$12=4,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14))))","v":""},null,{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":""},null,null,{"$f":"SUM(W14:Z14)","v":0},null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U14=\"\",\"\",IF($AG$12=2,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14)+COUNTIF($G$13:G13,U14),IF($AG$12=4,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14))))","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G15=\"\",\"\",IF($AG$12=2,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U15,G15),IF($AG$12=4,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U16,G15))))","v":""},null,{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U15=\"\",\"\",IF($AG$12=2,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U14,U15)+COUNTIF($G$13:G14,U15),IF($AG$12=4,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U15)+COUNTIF($U$13:U14,U15))))","v":""},null,null,null,"pro M-Schaft:",6]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G16=\"\",\"\",IF($AG$12=2,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16),IF($AG$12=4,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16))))","v":""},null,{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U16=\"\",\"\",IF($AG$12=2,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U15,U16)+COUNTIF($G$13:G15,U16),IF($AG$12=4,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U16)+COUNTIF($U$13:U15,U16))))","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G17=\"\",\"\",IF($AG$12=2,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U17,G17),IF($AG$12=4,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U18,G17))))","v":""},null,{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U17=\"\",\"\",IF($AG$12=2,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U16,U17)+COUNTIF($G$13:G16,U17),IF($AG$12=4,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U17)+COUNTIF($U$13:U16,U17))))","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G18=\"\",\"\",IF($AG$12=2,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18),IF($AG$12=4,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18))))","v":""},null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U18=\"\",\"\",IF($AG$12=2,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U17,U18)+COUNTIF($G$13:G17,U18),IF($AG$12=4,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U18)+COUNTIF($U$13:U17,U18))))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,""]
[null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(G13:G19)=0,\"\",SUM(G13:G19))","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"IF(COUNT(M13:M19)>AK21,\"??\",SUM(M13:M19))","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(U13:U19)=0,\"\",SUM(U13:U19))","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"IF(COUNT(AA13:AA19)>AK21,\"??\",(SUM(AA13:AA19)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AG$15<=5,36,78)","v":78},null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":6}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"IF(E20=\"\",\"\",IF(E20>S20,2,IF(E20=S20,1,0)))","v":""},":",{"$f":"IF(S20=\"\",\"\",IF(S20>E20,2,IF(S20=E20,1,0)))","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":32}]
[null,null,null,{"$f":"IF(OR(COUNT(G13:G19)=4,COUNT(G13:G19)=5),ROUND(E20/4,1),IF(COUNT(G13:G19)>=6,ROUND(E20/6,1),\"\"))","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"IF(AND(M20=0,AA20=0),\"\",IF(COUNT(B13:B19)>(AK21+1),\"falsche Eing.\",IF(COUNT(B13:B19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(M20>(AH21-AH22),1,0)))))","v":{"$error":"#VALUE!"}},":",{"$f":"IF(AND(AA20=0,M20=0),\"\",IF(COUNT(P13:P19)>(AK21+1),\"falsche Eing.\",IF(COUNT(P13:P19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(AA20>=AH22,1,0)))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(COUNT(U13:U19)=4,COUNT(U13:U19)=5),ROUND(S20/4,1),IF(COUNT(U13:U19)>=6,ROUND(S20/6,1),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"IF(OR(N22=\"\",I277),\"\",N22+N23)","v":""},":",{"$f":"IF(OR(P22=\"\",P23=\"\"),\"\",P22+P23)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben"]
[]
[]
[null,null,"Unfall:"]
[]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[]
[]
[]
[null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung"]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,null,null,{"$f":"IF(F6=\"\",\"\",F6)","v":""}]

{"sheet":"Druck1","index":3,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",{"$f":"Bericht1!D4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",{"$f":"Bericht1!R4","v":0}]
[]
[null,null,"Spiel-Nr.:",{"$f":"Bericht1!D6","v":0},"Datum:",{"$f":"IF(Bericht1!F6=\"\",\"\",Bericht1!F6)","v":""},null,null,null,null,null,null,null,null,null,null,"Sportstätte:",{"$f":"Bericht1!R6","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,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,{"$f":"Bericht1!C9","v":0},null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,{"$f":"Bericht1!Q9","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,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz",null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz",null,null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":1},{"$f":"Bericht1!C13","v":0},null,{"$f":"Bericht1!E13","v":""},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":""},null,null,null,null,{"$f":"Bericht1!M13","v":""},{"$f":"Bericht1!N13","v":""},null,{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":1},{"$f":"Bericht1!Q13","v":0},null,{"$f":"Bericht1!S13","v":""},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":""},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":""},null,null,null,null,{"$f":"Bericht1!AA13","v":""},{"$f":"Bericht1!AB13","v":""}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":2},{"$f":"Bericht1!C14","v":0},null,{"$f":"Bericht1!E14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!M14","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!N14","v":""},null,{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":2},{"$f":"Bericht1!Q14","v":0},null,{"$f":"Bericht1!S14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!AA14","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!AB14","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":3},{"$f":"Bericht1!C15","v":0},null,{"$f":"Bericht1!E15","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!M15","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!N15","v":""},null,{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":3},{"$f":"Bericht1!Q15","v":0},null,{"$f":"Bericht1!S15","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!AA15","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!AB15","v":""},null,null,null,"pro M-Schaft:",6]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":4},{"$f":"Bericht1!C16","v":0},null,{"$f":"Bericht1!E16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!M16","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!N16","v":""},null,{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":4},{"$f":"Bericht1!Q16","v":0},null,{"$f":"Bericht1!S16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!AA16","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!AB16","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":5},{"$f":"Bericht1!C17","v":0},null,{"$f":"Bericht1!E17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!M17","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!N17","v":""},null,{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":5},{"$f":"Bericht1!Q17","v":0},null,{"$f":"Bericht1!S17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!AA17","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!AB17","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":6},{"$f":"Bericht1!C18","v":0},null,{"$f":"Bericht1!E18","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!M18","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!N18","v":""},null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":6},{"$f":"Bericht1!Q18","v":0},null,{"$f":"Bericht1!S18","v":0},null,0,0,null,null,null,null,{"$f":"Bericht1!AA18","v":{"$error":"#VALUE!"}},{"$f":"Bericht1!AB18","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(E19=\"\",\"\",IF(AND(O19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N19)))","v":""},null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(S19=\"\",\"\",IF(AND(AC19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB19)))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"Bericht1!E20","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"Bericht1!M20","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht1!S20","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"Bericht1!AA20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AG$15<=5,36,78)","v":78},null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":6}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"Bericht1!N22","v":""},":",{"$f":"Bericht1!P22","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":32}]
[null,null,null,{"$f":"Bericht1!D23","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"Bericht1!N23","v":{"$error":"#VALUE!"}},":",{"$f":"Bericht1!P23","v":{"$error":"#VALUE!"}},null,{"$f":"Bericht1!R23","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"Bericht1!N24","v":""},":",{"$f":"Bericht1!P24","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht1!E26","v":0},null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht1!S26","v":0}]
[null,null,{"$f":"Bericht1!C27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht1!Q27","v":0}]
[]
[null,null,"Unfall:"]
[null,null,{"$f":"Bericht1!C30","v":0}]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[null,null,{"$f":"Bericht1!C33","v":0}]
[null,null,{"$f":"Bericht1!C34","v":0}]
[]
[null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht1!E36","v":0},null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht1!S36","v":0}]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,{"$f":"Bericht1!C43","v":0},null,{"$f":"Bericht1!E43","v":""}]

{"sheet":"Bericht2","index":4,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:"]
[]
[null,null,"Spiel-Nr.:",null,"Datum:",null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz",null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz",null,null,null,"Bahnen pro Anlage ( 2 oder 4)",2]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":""},null,null,{"$f":"IF(SUM(I13:L13)=0,\"\",SUM(I13:L13))","v":""},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(E13=\"\",\"\",IF(AND(O13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N13)))","v":""},{"$f":"IF(G13=\"\",\"\",IF($AG$12=2,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,G13),IF($AG$12=4,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U$14,G13))))","v":""},null,{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":""},null,null,{"$f":"IF(SUM(W13:Z13)=0,\"\",SUM(W13:Z13))","v":""},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":""},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(S13=\"\",\"\",IF(AND(AC13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB13)))","v":""},{"$f":"IF(U13=\"\",\"\",RANK(U13,($G$13:$G$19,$U$13:$U$19),0))","v":""}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":""},null,null,{"$f":"SUM(I14:L14)","v":0},null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G14=\"\",\"\",IF($AG$12=2,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14),IF($AG$12=4,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14))))","v":""},null,{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":""},null,null,{"$f":"SUM(W14:Z14)","v":0},null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U14=\"\",\"\",IF($AG$12=2,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14)+COUNTIF($G$13:G13,U14),IF($AG$12=4,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14))))","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G15=\"\",\"\",IF($AG$12=2,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U15,G15),IF($AG$12=4,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U16,G15))))","v":""},null,{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U15=\"\",\"\",IF($AG$12=2,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U14,U15)+COUNTIF($G$13:G14,U15),IF($AG$12=4,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U15)+COUNTIF($U$13:U14,U15))))","v":""},null,null,null,"pro M-Schaft:",6]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G16=\"\",\"\",IF($AG$12=2,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16),IF($AG$12=4,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16))))","v":""},null,{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U16=\"\",\"\",IF($AG$12=2,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U15,U16)+COUNTIF($G$13:G15,U16),IF($AG$12=4,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U16)+COUNTIF($U$13:U15,U16))))","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G17=\"\",\"\",IF($AG$12=2,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U17,G17),IF($AG$12=4,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U18,G17))))","v":""},null,{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U17=\"\",\"\",IF($AG$12=2,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U16,U17)+COUNTIF($G$13:G16,U17),IF($AG$12=4,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U17)+COUNTIF($U$13:U16,U17))))","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G18=\"\",\"\",IF($AG$12=2,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18),IF($AG$12=4,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18))))","v":""},null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U18=\"\",\"\",IF($AG$12=2,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U17,U18)+COUNTIF($G$13:G17,U18),IF($AG$12=4,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U18)+COUNTIF($U$13:U17,U18))))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,""]
[null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(G13:G19)=0,\"\",SUM(G13:G19))","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"IF(COUNT(M13:M19)>AK21,\"??\",SUM(M13:M19))","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(U13:U19)=0,\"\",SUM(U13:U19))","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"IF(COUNT(AA13:AA19)>AK21,\"??\",(SUM(AA13:AA19)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AG$15<=5,36,78)","v":78},null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":6}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"IF(E20=\"\",\"\",IF(E20>S20,2,IF(E20=S20,1,0)))","v":""},":",{"$f":"IF(S20=\"\",\"\",IF(S20>E20,2,IF(S20=E20,1,0)))","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":32}]
[null,null,null,{"$f":"IF(OR(COUNT(G13:G19)=4,COUNT(G13:G19)=5),ROUND(E20/4,1),IF(COUNT(G13:G19)>=6,ROUND(E20/6,1),\"\"))","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"IF(AND(M20=0,AA20=0),\"\",IF(COUNT(B13:B19)>(AK21+1),\"falsche Eing.\",IF(COUNT(B13:B19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(M20>(AH21-AH22),1,0)))))","v":{"$error":"#VALUE!"}},":",{"$f":"IF(AND(AA20=0,M20=0),\"\",IF(COUNT(P13:P19)>(AK21+1),\"falsche Eing.\",IF(COUNT(P13:P19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(AA20>=AH22,1,0)))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(COUNT(U13:U19)=4,COUNT(U13:U19)=5),ROUND(S20/4,1),IF(COUNT(U13:U19)>=6,ROUND(S20/6,1),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"IF(OR(N22=\"\",I277),\"\",N22+N23)","v":""},":",{"$f":"IF(OR(P22=\"\",P23=\"\"),\"\",P22+P23)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben"]
[]
[]
[null,null,"Unfall:"]
[]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[]
[]
[]
[null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung"]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,null,null,{"$f":"IF(F6=\"\",\"\",F6)","v":""}]

{"sheet":"Druck2","index":5,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",{"$f":"Bericht2!D4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",{"$f":"Bericht2!R4","v":0}]
[]
[null,null,"Spiel-Nr.:",{"$f":"Bericht2!D6","v":0},"Datum:",{"$f":"Bericht2!F6","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,"Sportstätte:",{"$f":"Bericht2!R6","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,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,{"$f":"Bericht2!C9","v":0},null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,{"$f":"Bericht2!Q9","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,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz",null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz",null,null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":1},{"$f":"Bericht2!C13","v":0},null,{"$f":"Bericht2!E13","v":""},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":""},null,null,null,null,{"$f":"Bericht2!M13","v":""},{"$f":"Bericht2!N13","v":""},null,{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":1},{"$f":"Bericht2!Q13","v":0},null,{"$f":"Bericht2!S13","v":""},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":""},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":""},null,null,null,null,{"$f":"Bericht2!AA13","v":""},{"$f":"Bericht2!AB13","v":""}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":2},{"$f":"Bericht2!C14","v":0},null,{"$f":"Bericht2!E14","v":0},null,{"$f":"IF(OR(C14=\"\",E14=\"\"),\"\",IF(AND($AK$21=4,O14<>\"\"),\"\",E14))","v":0},{"$f":"IF(OR(C14=\"\",E14=\"\"),\"\",IF(AND($AK$21=4,O14<>\"\"),\"\",E14+F14*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht2!M14","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!N14","v":""},null,{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":2},{"$f":"Bericht2!Q14","v":0},null,{"$f":"Bericht2!S14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht2!AA14","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!AB14","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":3},{"$f":"Bericht2!C15","v":0},null,{"$f":"Bericht2!E15","v":0},null,0,0,null,null,null,null,{"$f":"Bericht2!M15","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!N15","v":""},null,{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":3},{"$f":"Bericht2!Q15","v":0},null,{"$f":"Bericht2!S15","v":0},null,{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15))","v":0},{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15+T15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht2!AA15","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!AB15","v":""},null,null,null,"pro M-Schaft:",6]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":4},{"$f":"Bericht2!C16","v":0},null,{"$f":"Bericht2!E16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht2!M16","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!N16","v":""},null,{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":4},{"$f":"Bericht2!Q16","v":0},null,{"$f":"Bericht2!S16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht2!AA16","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!AB16","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":5},{"$f":"Bericht2!C17","v":0},null,{"$f":"Bericht2!E17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht2!M17","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!N17","v":""},null,{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":5},{"$f":"Bericht2!Q17","v":0},null,{"$f":"Bericht2!S17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht2!AA17","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!AB17","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":6},{"$f":"Bericht2!C18","v":0},null,{"$f":"Bericht2!E18","v":0},null,0,0,null,null,null,null,{"$f":"Bericht2!M18","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!N18","v":""},null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":6},{"$f":"Bericht2!Q18","v":0},null,{"$f":"Bericht2!S18","v":0},null,0,0,null,null,null,null,{"$f":"Bericht2!AA18","v":{"$error":"#VALUE!"}},{"$f":"Bericht2!AB18","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(E19=\"\",\"\",IF(AND(O19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N19)))","v":""},null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(S19=\"\",\"\",IF(AND(AC19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB19)))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"Bericht2!E20","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"Bericht2!M20","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht2!S20","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"Bericht2!AA20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AG$15<=5,36,78)","v":78},null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":6}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"Bericht2!N22","v":""},":",{"$f":"Bericht2!P22","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":32}]
[null,null,null,{"$f":"Bericht2!D23","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"Bericht2!N23","v":{"$error":"#VALUE!"}},":",{"$f":"Bericht2!P23","v":{"$error":"#VALUE!"}},null,{"$f":"Bericht2!R23","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"Bericht2!N24","v":""},":",{"$f":"Bericht2!P24","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht2!E26","v":0},null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht2!S26","v":0}]
[null,null,{"$f":"Bericht2!C27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht2!Q27","v":0}]
[]
[null,null,"Unfall:"]
[null,null,{"$f":"Bericht2!C30","v":0}]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[null,null,{"$f":"Bericht2!C33","v":0}]
[null,null,{"$f":"Bericht2!C34","v":0}]
[]
[null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht2!E36","v":0},null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht2!S36","v":0}]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,{"$f":"Bericht2!C43","v":0},null,{"$f":"Bericht2!E43","v":""}]

{"sheet":"Bericht3","index":6,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:"]
[]
[null,null,"Spiel-Nr.:",null,"Datum:",null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":""},null,null,{"$f":"SUM(I13:L13)","v":0},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(E13=\"\",\"\",IF(AND(O13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(G13=\"\",\"\",IF($AG$12=2,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,G13),IF($AG$12=4,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U$14,G13))))","v":""},null,{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":""},null,null,{"$f":"SUM(W13:Z13)","v":0},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":""},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(S13=\"\",\"\",IF(AND(AC13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(U13=\"\",\"\",RANK(U13,($G$13:$G$19,$U$13:$U$19),0))","v":""}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":""},null,null,0,null,{"$f":"IF(OR(C14=\"\",E14=\"\"),\"\",IF(AND($AK$21=4,O14<>\"\"),\"\",E14))","v":""},{"$f":"IF(OR(C14=\"\",E14=\"\"),\"\",IF(AND($AK$21=4,O14<>\"\"),\"\",E14+F14*0.0000001))","v":""},null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G14=\"\",\"\",IF($AG$12=2,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14),IF($AG$12=4,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14))))","v":""},null,{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U14=\"\",\"\",IF($AG$12=2,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14)+COUNTIF($G$13:G13,U14),IF($AG$12=4,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14))))","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":""},null,null,0,null,{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15))","v":""},{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15+F15*0.0000001))","v":""},null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G15=\"\",\"\",IF($AG$12=2,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U15,G15),IF($AG$12=4,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U16,G15))))","v":""},null,{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U15=\"\",\"\",IF($AG$12=2,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U14,U15)+COUNTIF($G$13:G14,U15),IF($AG$12=4,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U15)+COUNTIF($U$13:U14,U15))))","v":""},null,null,null,"pro M-Schaft:",4]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":""},null,null,{"$f":"SUM(I16:L16)","v":0},null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G16=\"\",\"\",IF($AG$12=2,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16),IF($AG$12=4,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16))))","v":""},null,{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U16=\"\",\"\",IF($AG$12=2,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U15,U16)+COUNTIF($G$13:G15,U16),IF($AG$12=4,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U16)+COUNTIF($U$13:U15,U16))))","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":""},null,null,0,null,{"$f":"IF(OR(C17=\"\",E17=\"\"),\"\",IF(AND($AK$21=4,O17<>\"\"),\"\",E17))","v":""},{"$f":"IF(OR(C17=\"\",E17=\"\"),\"\",IF(AND($AK$21=4,O17<>\"\"),\"\",E17+F17*0.0000001))","v":""},null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G17=\"\",\"\",IF($AG$12=2,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U17,G17),IF($AG$12=4,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U18,G17))))","v":""},null,{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U17=\"\",\"\",IF($AG$12=2,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U16,U17)+COUNTIF($G$13:G16,U17),IF($AG$12=4,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U17)+COUNTIF($U$13:U16,U17))))","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,0,null,{"$f":"IF(OR(C18=\"\",E18=\"\"),\"\",IF(AND($AK$21=4,O18<>\"\"),\"\",E18))","v":""},{"$f":"IF(OR(C18=\"\",E18=\"\"),\"\",IF(AND($AK$21=4,O18<>\"\"),\"\",E18+F18*0.0000001))","v":""},null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G18=\"\",\"\",IF($AG$12=2,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18),IF($AG$12=4,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18))))","v":""},null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U18=\"\",\"\",IF($AG$12=2,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U17,U18)+COUNTIF($G$13:G17,U18),IF($AG$12=4,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U18)+COUNTIF($U$13:U17,U18))))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,""]
[null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(G13:G19)=0,\"\",SUM(G13:G19))","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"IF(COUNT(M13:M19)>AK21,\"??\",SUM(M13:M19))","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(U13:U19)=0,\"\",SUM(U13:U19))","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"IF(COUNT(AA13:AA19)>AK21,\"??\",(SUM(AA13:AA19)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":4}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"IF(E20=\"\",\"\",IF(E20>S20,2,IF(E20=S20,1,0)))","v":""},":",{"$f":"IF(S20=\"\",\"\",IF(S20>E20,2,IF(S20=E20,1,0)))","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":15}]
[null,null,null,{"$f":"IF(OR(COUNT(G13:G19)=4,COUNT(G13:G19)=5),ROUND(E20/4,1),IF(COUNT(G13:G19)>=6,ROUND(E20/6,1),\"\"))","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"IF(AND(M20=0,AA20=0),\"\",IF(COUNT(B13:B19)>(AK21+1),\"falsche Eing.\",IF(COUNT(B13:B19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(M20>(AH21-AH22),1,0)))))","v":{"$error":"#VALUE!"}},":",{"$f":"IF(AND(AA20=0,M20=0),\"\",IF(COUNT(P13:P19)>(AK21+1),\"falsche Eing.\",IF(COUNT(P13:P19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(AA20>=AH22,1,0)))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(COUNT(U13:U19)=4,COUNT(U13:U19)=5),ROUND(S20/4,1),IF(COUNT(U13:U19)>=6,ROUND(S20/6,1),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"IF(OR(N22=\"\",I277),\"\",N22+N23)","v":""},":",{"$f":"IF(OR(P22=\"\",P23=\"\"),\"\",P22+P23)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben"]
[]
[]
[null,null,"Unfall:"]
[]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[]
[]
[]
[null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung"]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,null,null,{"$f":"IF(F6=\"\",\"\",F6)","v":""}]

{"sheet":"Druck3","index":7,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",{"$f":"Bericht3!D4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",{"$f":"Bericht3!R4","v":0}]
[]
[null,null,"Spiel-Nr.:",{"$f":"Bericht3!D6","v":0},"Datum:",{"$f":"Bericht3!F6","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,"Sportstätte:",{"$f":"Bericht3!R6","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,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,{"$f":"Bericht3!C9","v":0},null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,{"$f":"Bericht3!Q9","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,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":1},{"$f":"Bericht3!C13","v":0},null,{"$f":"Bericht3!E13","v":0},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":0},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht3!M13","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!N13","v":""},{"$f":"Bericht3!O13","v":0},{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":1},{"$f":"Bericht3!Q13","v":0},null,{"$f":"Bericht3!S13","v":0},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":0},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht3!AA13","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!AB13","v":""},{"$f":"Bericht3!AC13","v":0}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":2},{"$f":"Bericht3!C14","v":0},null,{"$f":"Bericht3!E14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht3!M14","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!N14","v":""},{"$f":"Bericht3!O14","v":0},{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":2},{"$f":"Bericht3!Q14","v":0},null,{"$f":"Bericht3!S14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht3!AA14","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!AB14","v":""},{"$f":"Bericht3!AC14","v":0},null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":3},{"$f":"Bericht3!C15","v":0},null,{"$f":"Bericht3!E15","v":0},null,{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15))","v":0},{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15+F15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht3!M15","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!N15","v":""},{"$f":"Bericht3!O15","v":0},{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":3},{"$f":"Bericht3!Q15","v":0},null,{"$f":"Bericht3!S15","v":0},null,{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15))","v":0},{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15+T15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht3!AA15","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!AB15","v":""},{"$f":"Bericht3!AC15","v":0},null,null,"pro M-Schaft:",6]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":4},{"$f":"Bericht3!C16","v":0},null,{"$f":"Bericht3!E16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht3!M16","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!N16","v":""},{"$f":"Bericht3!O16","v":0},{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":4},{"$f":"Bericht3!Q16","v":0},null,{"$f":"Bericht3!S16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht3!AA16","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!AB16","v":""},{"$f":"Bericht3!AC16","v":0}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":5},{"$f":"Bericht3!C17","v":0},null,{"$f":"Bericht3!E17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht3!M17","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!N17","v":""},{"$f":"Bericht3!O17","v":0},{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":5},{"$f":"Bericht3!Q17","v":0},null,{"$f":"Bericht3!S17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht3!AA17","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!AB17","v":""},{"$f":"Bericht3!AC17","v":0}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":6},{"$f":"Bericht3!C18","v":0},null,{"$f":"Bericht3!E18","v":0},null,0,0,null,null,null,null,{"$f":"Bericht3!M18","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!N18","v":""},{"$f":"Bericht3!O18","v":0},{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":6},{"$f":"Bericht3!Q18","v":0},null,{"$f":"Bericht3!S18","v":0},null,0,0,null,null,null,null,{"$f":"Bericht3!AA18","v":{"$error":"#VALUE!"}},{"$f":"Bericht3!AB18","v":""},{"$f":"Bericht3!AC18","v":0}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(E19=\"\",\"\",IF(AND(O19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N19)))","v":""},null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(S19=\"\",\"\",IF(AND(AC19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB19)))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"Bericht3!E20","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"Bericht3!M20","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht3!S20","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"Bericht3!AA20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AG$15<=5,36,78)","v":78},null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":6}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"Bericht3!N22","v":""},":",{"$f":"Bericht3!P22","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":32}]
[null,null,null,{"$f":"Bericht3!D23","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"Bericht3!N23","v":{"$error":"#VALUE!"}},":",{"$f":"Bericht3!P23","v":{"$error":"#VALUE!"}},null,{"$f":"Bericht3!R23","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"Bericht3!N24","v":""},":",{"$f":"Bericht3!P24","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht3!E26","v":0},null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht3!S26","v":0}]
[null,null,{"$f":"Bericht3!C27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht3!Q27","v":0}]
[]
[null,null,"Unfall:"]
[null,null,{"$f":"Bericht3!C30","v":0}]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[null,null,{"$f":"Bericht3!C33","v":0}]
[null,null,{"$f":"Bericht3!C34","v":0}]
[]
[null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht3!E36","v":0},null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht3!S36","v":0}]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,{"$f":"Bericht3!C43","v":0},null,{"$f":"Bericht3!E43","v":""}]

{"sheet":"Bericht4","index":8,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:"]
[]
[null,null,"Spiel-Nr.:",null,"Datum:",null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,null,"Bahnen pro Anlage ( 2 oder 4)",2]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":""},null,null,{"$f":"SUM(I13:L13)","v":0},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(E13=\"\",\"\",IF(AND(O13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(G13=\"\",\"\",IF($AG$12=2,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,G13),IF($AG$12=4,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U$14,G13))))","v":""},null,{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":""},null,null,{"$f":"SUM(W13:Z13)","v":0},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":""},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(S13=\"\",\"\",IF(AND(AC13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(U13=\"\",\"\",RANK(U13,($G$13:$G$19,$U$13:$U$19),0))","v":""}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G14=\"\",\"\",IF($AG$12=2,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14),IF($AG$12=4,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14))))","v":""},null,{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U14=\"\",\"\",IF($AG$12=2,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14)+COUNTIF($G$13:G13,U14),IF($AG$12=4,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14))))","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G15=\"\",\"\",IF($AG$12=2,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U15,G15),IF($AG$12=4,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U16,G15))))","v":""},null,{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U15=\"\",\"\",IF($AG$12=2,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U14,U15)+COUNTIF($G$13:G14,U15),IF($AG$12=4,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U15)+COUNTIF($U$13:U14,U15))))","v":""},null,null,null,"pro M-Schaft:",4]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G16=\"\",\"\",IF($AG$12=2,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16),IF($AG$12=4,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16))))","v":""},null,{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U16=\"\",\"\",IF($AG$12=2,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U15,U16)+COUNTIF($G$13:G15,U16),IF($AG$12=4,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U16)+COUNTIF($U$13:U15,U16))))","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G17=\"\",\"\",IF($AG$12=2,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U17,G17),IF($AG$12=4,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U18,G17))))","v":""},null,{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U17=\"\",\"\",IF($AG$12=2,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U16,U17)+COUNTIF($G$13:G16,U17),IF($AG$12=4,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U17)+COUNTIF($U$13:U16,U17))))","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G18=\"\",\"\",IF($AG$12=2,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18),IF($AG$12=4,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18))))","v":""},null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U18=\"\",\"\",IF($AG$12=2,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U17,U18)+COUNTIF($G$13:G17,U18),IF($AG$12=4,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U18)+COUNTIF($U$13:U17,U18))))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,""]
[null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(G13:G19)=0,\"\",SUM(G13:G19))","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"IF(COUNT(M13:M19)>AK21,\"??\",SUM(M13:M19))","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(U13:U19)=0,\"\",SUM(U13:U19))","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"IF(COUNT(AA13:AA19)>AK21,\"??\",(SUM(AA13:AA19)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":4}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"IF(E20=\"\",\"\",IF(E20>S20,2,IF(E20=S20,1,0)))","v":""},":",{"$f":"IF(S20=\"\",\"\",IF(S20>E20,2,IF(S20=E20,1,0)))","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":15}]
[null,null,null,{"$f":"IF(OR(COUNT(G13:G19)=4,COUNT(G13:G19)=5),ROUND(E20/4,1),IF(COUNT(G13:G19)>=6,ROUND(E20/6,1),\"\"))","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"IF(AND(M20=0,AA20=0),\"\",IF(COUNT(B13:B19)>(AK21+1),\"falsche Eing.\",IF(COUNT(B13:B19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(M20>(AH21-AH22),1,0)))))","v":{"$error":"#VALUE!"}},":",{"$f":"IF(AND(AA20=0,M20=0),\"\",IF(COUNT(P13:P19)>(AK21+1),\"falsche Eing.\",IF(COUNT(P13:P19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(AA20>=AH22,1,0)))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(COUNT(U13:U19)=4,COUNT(U13:U19)=5),ROUND(S20/4,1),IF(COUNT(U13:U19)>=6,ROUND(S20/6,1),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"IF(OR(N22=\"\",I277),\"\",N22+N23)","v":""},":",{"$f":"IF(OR(P22=\"\",P23=\"\"),\"\",P22+P23)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben"]
[]
[]
[null,null,"Unfall:"]
[]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[]
[]
[]
[null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung"]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,null,null,{"$f":"IF(F6=\"\",\"\",F6)","v":""}]

{"sheet":"Druck4","index":9,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",{"$f":"Bericht4!D4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",{"$f":"Bericht4!R4","v":0}]
[]
[null,null,"Spiel-Nr.:",{"$f":"Bericht4!D6","v":0},"Datum:",{"$f":"Bericht4!F6","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,"Sportstätte:",{"$f":"Bericht4!R6","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,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,{"$f":"Bericht4!C9","v":0},null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,{"$f":"Bericht4!Q9","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,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":1},{"$f":"Bericht4!C13","v":0},null,{"$f":"Bericht4!E13","v":0},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":0},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht4!M13","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!N13","v":""},{"$f":"Bericht4!O13","v":0},{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":1},{"$f":"Bericht4!Q13","v":0},null,{"$f":"Bericht4!S13","v":0},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":0},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht4!AA13","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!AB13","v":""},{"$f":"Bericht4!AC13","v":0}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":2},{"$f":"Bericht4!C14","v":0},null,{"$f":"Bericht4!E14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht4!M14","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!N14","v":""},{"$f":"Bericht4!O14","v":0},{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":2},{"$f":"Bericht4!Q14","v":0},null,{"$f":"Bericht4!S14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht4!AA14","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!AB14","v":""},{"$f":"Bericht4!AC14","v":0},null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":3},{"$f":"Bericht4!C15","v":0},null,{"$f":"Bericht4!E15","v":0},null,{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15))","v":0},{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15+F15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht4!M15","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!N15","v":""},{"$f":"Bericht4!O15","v":0},{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":3},{"$f":"Bericht4!Q15","v":0},null,{"$f":"Bericht4!S15","v":0},null,{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15))","v":0},{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15+T15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht4!AA15","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!AB15","v":""},{"$f":"Bericht4!AC15","v":0},null,null,"pro M-Schaft:",6]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":4},{"$f":"Bericht4!C16","v":0},null,{"$f":"Bericht4!E16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht4!M16","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!N16","v":""},{"$f":"Bericht4!O16","v":0},{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":4},{"$f":"Bericht4!Q16","v":0},null,{"$f":"Bericht4!S16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht4!AA16","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!AB16","v":""},{"$f":"Bericht4!AC16","v":0}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":5},{"$f":"Bericht4!C17","v":0},null,{"$f":"Bericht4!E17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht4!M17","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!N17","v":""},{"$f":"Bericht4!O17","v":0},{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":5},{"$f":"Bericht4!Q17","v":0},null,{"$f":"Bericht4!S17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht4!AA17","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!AB17","v":""},{"$f":"Bericht4!AC17","v":0}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":6},{"$f":"Bericht4!C18","v":0},null,{"$f":"Bericht4!E18","v":0},null,0,0,null,null,null,null,{"$f":"Bericht4!M18","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!N18","v":""},{"$f":"Bericht4!O18","v":0},{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":6},{"$f":"Bericht4!Q18","v":0},null,{"$f":"Bericht4!S18","v":0},null,0,0,null,null,null,null,{"$f":"Bericht4!AA18","v":{"$error":"#VALUE!"}},{"$f":"Bericht4!AB18","v":""},{"$f":"Bericht4!AC18","v":0}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(E19=\"\",\"\",IF(AND(O19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N19)))","v":""},null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(S19=\"\",\"\",IF(AND(AC19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB19)))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"Bericht4!E20","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"Bericht4!M20","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht4!S20","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"Bericht4!AA20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AG$15<=5,36,78)","v":78},null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":6}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"Bericht4!N22","v":""},":",{"$f":"Bericht4!P22","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":32}]
[null,null,null,{"$f":"Bericht4!D23","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"Bericht4!N23","v":{"$error":"#VALUE!"}},":",{"$f":"Bericht4!P23","v":{"$error":"#VALUE!"}},null,{"$f":"Bericht4!R23","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"Bericht4!N24","v":""},":",{"$f":"Bericht4!P24","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht4!E26","v":0},null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht4!S26","v":0}]
[null,null,{"$f":"Bericht4!C27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht4!Q27","v":0}]
[]
[null,null,"Unfall:"]
[null,null,{"$f":"Bericht4!C30","v":0}]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[null,null,{"$f":"Bericht4!C33","v":0}]
[null,null,{"$f":"Bericht4!C34","v":0}]
[]
[null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht4!E36","v":0},null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht4!S36","v":0}]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,{"$f":"Bericht4!C43","v":0},null,{"$f":"Bericht4!E43","v":""}]

{"sheet":"Bericht5","index":10,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:"]
[]
[null,null,"Spiel-Nr.:",null,"Datum:",null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":""},null,null,{"$f":"SUM(I13:L13)","v":0},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(E13=\"\",\"\",IF(AND(O13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(G13=\"\",\"\",IF($AG$12=2,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,G13),IF($AG$12=4,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U$14,G13))))","v":""},null,{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":""},null,null,{"$f":"SUM(W13:Z13)","v":0},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":""},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(S13=\"\",\"\",IF(AND(AC13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(U13=\"\",\"\",RANK(U13,($G$13:$G$19,$U$13:$U$19),0))","v":""}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G14=\"\",\"\",IF($AG$12=2,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14),IF($AG$12=4,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14))))","v":""},null,{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U14=\"\",\"\",IF($AG$12=2,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14)+COUNTIF($G$13:G13,U14),IF($AG$12=4,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14))))","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G15=\"\",\"\",IF($AG$12=2,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U15,G15),IF($AG$12=4,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U16,G15))))","v":""},null,{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U15=\"\",\"\",IF($AG$12=2,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U14,U15)+COUNTIF($G$13:G14,U15),IF($AG$12=4,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U15)+COUNTIF($U$13:U14,U15))))","v":""},null,null,null,"pro M-Schaft:",4]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G16=\"\",\"\",IF($AG$12=2,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16),IF($AG$12=4,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16))))","v":""},null,{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U16=\"\",\"\",IF($AG$12=2,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U15,U16)+COUNTIF($G$13:G15,U16),IF($AG$12=4,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U16)+COUNTIF($U$13:U15,U16))))","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G17=\"\",\"\",IF($AG$12=2,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U17,G17),IF($AG$12=4,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U18,G17))))","v":""},null,{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U17=\"\",\"\",IF($AG$12=2,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U16,U17)+COUNTIF($G$13:G16,U17),IF($AG$12=4,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U17)+COUNTIF($U$13:U16,U17))))","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",{"$f":"IF(G18=\"\",\"\",IF($AG$12=2,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18),IF($AG$12=4,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18))))","v":""},null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",{"$f":"IF(U18=\"\",\"\",IF($AG$12=2,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U17,U18)+COUNTIF($G$13:G17,U18),IF($AG$12=4,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U18)+COUNTIF($U$13:U17,U18))))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,""]
[null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(G13:G19)=0,\"\",SUM(G13:G19))","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"IF(COUNT(M13:M19)>AK21,\"??\",SUM(M13:M19))","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(U13:U19)=0,\"\",SUM(U13:U19))","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"IF(COUNT(AA13:AA19)>AK21,\"??\",(SUM(AA13:AA19)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":4}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"IF(E20=\"\",\"\",IF(E20>S20,2,IF(E20=S20,1,0)))","v":""},":",{"$f":"IF(S20=\"\",\"\",IF(S20>E20,2,IF(S20=E20,1,0)))","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":15}]
[null,null,null,{"$f":"IF(OR(COUNT(G13:G19)=4,COUNT(G13:G19)=5),ROUND(E20/4,1),IF(COUNT(G13:G19)>=6,ROUND(E20/6,1),\"\"))","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"IF(AND(M20=0,AA20=0),\"\",IF(COUNT(B13:B19)>(AK21+1),\"falsche Eing.\",IF(COUNT(B13:B19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(M20>(AH21-AH22),1,0)))))","v":{"$error":"#VALUE!"}},":",{"$f":"IF(AND(AA20=0,M20=0),\"\",IF(COUNT(P13:P19)>(AK21+1),\"falsche Eing.\",IF(COUNT(P13:P19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(AA20>=AH22,1,0)))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(COUNT(U13:U19)=4,COUNT(U13:U19)=5),ROUND(S20/4,1),IF(COUNT(U13:U19)>=6,ROUND(S20/6,1),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"IF(OR(N22=\"\",I277),\"\",N22+N23)","v":""},":",{"$f":"IF(OR(P22=\"\",P23=\"\"),\"\",P22+P23)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben"]
[]
[]
[null,null,"Unfall:"]
[]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[]
[]
[]
[null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung"]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,null,null,{"$f":"IF(F6=\"\",\"\",F6)","v":""}]

{"sheet":"Druck5","index":11,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",{"$f":"Bericht5!D4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",{"$f":"Bericht5!R4","v":0}]
[]
[null,null,"Spiel-Nr.:",{"$f":"Bericht5!D6","v":0},"Datum:",{"$f":"Bericht5!F6","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,"Sportstätte:",{"$f":"Bericht5!R6","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,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,{"$f":"Bericht5!C9","v":0},null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,{"$f":"Bericht5!Q9","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,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":1},{"$f":"Bericht5!C13","v":0},null,{"$f":"Bericht5!E13","v":0},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":0},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht5!M13","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!N13","v":""},{"$f":"Bericht5!O13","v":0},{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":1},{"$f":"Bericht5!Q13","v":0},null,{"$f":"Bericht5!S13","v":0},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":0},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht5!AA13","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!AB13","v":""},{"$f":"Bericht5!AC13","v":0}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":2},{"$f":"Bericht5!C14","v":0},null,{"$f":"Bericht5!E14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht5!M14","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!N14","v":""},{"$f":"Bericht5!O14","v":0},{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":2},{"$f":"Bericht5!Q14","v":0},null,{"$f":"Bericht5!S14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht5!AA14","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!AB14","v":""},{"$f":"Bericht5!AC14","v":0},null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":3},{"$f":"Bericht5!C15","v":0},null,{"$f":"Bericht5!E15","v":0},null,{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15))","v":0},{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15+F15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht5!M15","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!N15","v":""},{"$f":"Bericht5!O15","v":0},{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":3},{"$f":"Bericht5!Q15","v":0},null,{"$f":"Bericht5!S15","v":0},null,{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15))","v":0},{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15+T15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht5!AA15","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!AB15","v":""},{"$f":"Bericht5!AC15","v":0},null,null,"pro M-Schaft:",6]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":4},{"$f":"Bericht5!C16","v":0},null,{"$f":"Bericht5!E16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht5!M16","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!N16","v":""},{"$f":"Bericht5!O16","v":0},{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":4},{"$f":"Bericht5!Q16","v":0},null,{"$f":"Bericht5!S16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht5!AA16","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!AB16","v":""},{"$f":"Bericht5!AC16","v":0}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":5},{"$f":"Bericht5!C17","v":0},null,{"$f":"Bericht5!E17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht5!M17","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!N17","v":""},{"$f":"Bericht5!O17","v":0},{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":5},{"$f":"Bericht5!Q17","v":0},null,{"$f":"Bericht5!S17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht5!AA17","v":{"$error":"#VALUE!"}},{"$f":"Bericht5!AB17","v":""},{"$f":"Bericht5!AC17","v":0}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,null,null,"","",null,null,null,null,null,null,null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(E19=\"\",\"\",IF(AND(O19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N19)))","v":""},null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(S19=\"\",\"\",IF(AND(AC19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB19)))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"Bericht5!E20","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"Bericht5!M20","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht5!S20","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"Bericht5!AA20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AG$15<=5,36,78)","v":78},null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":6}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"Bericht5!N22","v":""},":",{"$f":"Bericht5!P22","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":32}]
[null,null,null,{"$f":"Bericht5!D23","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"Bericht5!N23","v":{"$error":"#VALUE!"}},":",{"$f":"Bericht5!P23","v":{"$error":"#VALUE!"}},null,{"$f":"Bericht5!R23","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"Bericht5!N24","v":""},":",{"$f":"Bericht5!P24","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht5!E26","v":0},null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht5!S26","v":0}]
[null,null,{"$f":"Bericht5!C27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht5!Q27","v":0}]
[]
[null,null,"Unfall:"]
[null,null,{"$f":"Bericht5!C30","v":0}]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[null,null,{"$f":"Bericht5!C33","v":0}]
[null,null,{"$f":"Bericht5!C34","v":0}]
[]
[null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht5!E36","v":0},null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht5!S36","v":0}]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,{"$f":"Bericht5!C43","v":0},null,{"$f":"Bericht5!E43","v":""}]

{"sheet":"Bericht6","index":12,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:"]
[]
[null,null,"Spiel-Nr.:",null,"Datum:",null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,null,"Bahnen pro Anlage ( 2 oder 4)",2]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":""},null,null,{"$f":"SUM(I13:L13)","v":0},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":""},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(E13=\"\",\"\",IF(AND(O13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(G13=\"\",\"\",IF($AG$12=2,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,G13),IF($AG$12=4,RANK(G13,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U$14,G13))))","v":""},null,{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":""},null,null,{"$f":"SUM(W13:Z13)","v":0},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":""},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":""},null,null,null,null,{"$f":"IF(S13=\"\",\"\",IF(AND(AC13<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB13)))","v":{"$error":"#VALUE!"}},{"$f":"IF(U13=\"\",\"\",RANK(U13,($G$13:$G$19,$U$13:$U$19),0))","v":""}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G14=\"\",\"\",IF($AG$12=2,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14),IF($AG$12=4,RANK(G14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G13,G14)+COUNTIF($U$13:U14,G14))))","v":""},null,{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U14=\"\",\"\",IF($AG$12=2,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14)+COUNTIF($G$13:G13,U14),IF($AG$12=4,RANK(U14,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U13,U14))))","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G15=\"\",\"\",IF($AG$12=2,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U15,G15),IF($AG$12=4,RANK(G15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,G15)+COUNTIF($U$13:U16,G15))))","v":""},null,{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U15=\"\",\"\",IF($AG$12=2,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U14,U15)+COUNTIF($G$13:G14,U15),IF($AG$12=4,RANK(U15,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U15)+COUNTIF($U$13:U14,U15))))","v":""},null,null,null,"pro M-Schaft:",4]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G16=\"\",\"\",IF($AG$12=2,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16),IF($AG$12=4,RANK(G16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G15,G16)+COUNTIF($U$13:U16,G16))))","v":""},null,{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U16=\"\",\"\",IF($AG$12=2,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U15,U16)+COUNTIF($G$13:G15,U16),IF($AG$12=4,RANK(U16,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G14,U16)+COUNTIF($U$13:U15,U16))))","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(G17=\"\",\"\",IF($AG$12=2,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U17,G17),IF($AG$12=4,RANK(G17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,G17)+COUNTIF($U$13:U18,G17))))","v":""},null,{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":""},null,null,0,null,"","",null,null,null,null,{"$error":"#VALUE!"},{"$f":"IF(U17=\"\",\"\",IF($AG$12=2,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U16,U17)+COUNTIF($G$13:G16,U17),IF($AG$12=4,RANK(U17,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U17)+COUNTIF($U$13:U16,U17))))","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",{"$f":"IF(G18=\"\",\"\",IF($AG$12=2,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18),IF($AG$12=4,RANK(G18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G17,G18)+COUNTIF($U$13:U18,G18))))","v":""},null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",{"$f":"IF(U18=\"\",\"\",IF($AG$12=2,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($U$13:U17,U18)+COUNTIF($G$13:G17,U18),IF($AG$12=4,RANK(U18,($G$13:$G$19,$U$13:$U$19),0)+COUNTIF($G$13:G16,U18)+COUNTIF($U$13:U17,U18))))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,"",null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,""]
[null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(G13:G19)=0,\"\",SUM(G13:G19))","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"IF(COUNT(M13:M19)>AK21,\"??\",SUM(M13:M19))","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"IF(SUM(U13:U19)=0,\"\",SUM(U13:U19))","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"IF(COUNT(AA13:AA19)>AK21,\"??\",(SUM(AA13:AA19)))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":4}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"IF(E20=\"\",\"\",IF(E20>S20,2,IF(E20=S20,1,0)))","v":""},":",{"$f":"IF(S20=\"\",\"\",IF(S20>E20,2,IF(S20=E20,1,0)))","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":15}]
[null,null,null,{"$f":"IF(OR(COUNT(G13:G19)=4,COUNT(G13:G19)=5),ROUND(E20/4,1),IF(COUNT(G13:G19)>=6,ROUND(E20/6,1),\"\"))","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"IF(AND(M20=0,AA20=0),\"\",IF(COUNT(B13:B19)>(AK21+1),\"falsche Eing.\",IF(COUNT(B13:B19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(M20>(AH21-AH22),1,0)))))","v":{"$error":"#VALUE!"}},":",{"$f":"IF(AND(AA20=0,M20=0),\"\",IF(COUNT(P13:P19)>(AK21+1),\"falsche Eing.\",IF(COUNT(P13:P19)<AK21,\"fehl. Eing.\",IF((M20+AA20)>AH21,\"doppelte Platzierung !!\",IF(AA20>=AH22,1,0)))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(COUNT(U13:U19)=4,COUNT(U13:U19)=5),ROUND(S20/4,1),IF(COUNT(U13:U19)>=6,ROUND(S20/6,1),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"IF(OR(N22=\"\",I277),\"\",N22+N23)","v":""},":",{"$f":"IF(OR(P22=\"\",P23=\"\"),\"\",P22+P23)","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben"]
[]
[]
[null,null,"Unfall:"]
[]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[]
[]
[]
[null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung"]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,null,null,{"$f":"IF(F6=\"\",\"\",F6)","v":""}]

{"sheet":"Druck6","index":13,"n_rows":43,"n_cols":51,"rows_kept":43,"cut":false,"hidden":false,"merged":[[11,2,11,3],[11,16,11,17],[0,1,0,28],[1,1,1,28],[3,3,3,14],[3,17,3,27],[5,5,5,14],[5,17,5,27],[8,2,8,12],[8,13,8,15],[8,16,8,27],[9,2,9,12],[9,16,9,26],[12,2,12,3],[12,16,12,17],[13,2,13,3],[13,16,13,17],[14,2,14,3],[14,16,14,17],[15,2,15,3],[15,16,15,17],[16,2,16,3],[16,16,16,17],[17,2,17,3],[17,16,17,17],[35,2,36,3],[35,4,36,4],[35,16,36,17],[35,18,36,18],[18,2,18,3],[18,16,18,17],[25,2,25,3],[25,16,25,17],[26,2,26,13],[26,16,26,27],[28,2,28,27],[29,2,29,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[42,2,42,3],[42,4,42,13],[42,16,42,27],[38,2,38,13],[38,16,38,27],[39,2,39,13],[39,16,39,27],[41,2,41,13],[41,16,41,27]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,"Altersklasse:",{"$f":"Bericht6!D4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",{"$f":"Bericht6!R4","v":0}]
[]
[null,null,"Spiel-Nr.:",{"$f":"Bericht6!D6","v":0},"Datum:",{"$f":"Bericht6!F6","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,"Sportstätte:",{"$f":"Bericht6!R6","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,"mindest EWP      4er Mannsch.",15,null,{"$f":"TODAY()","v":"2023-09-04"}]
[]
[]
[null,null,{"$f":"Bericht6!C9","v":0},null,null,null,null,null,null,null,null,null,null,"  gegen",null,null,{"$f":"Bericht6!Q9","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,"mindest EWP      6er Mannsch.",32]
[null,null,"Heimmannschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gastmannschaft"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,null,"Bahnen pro Anlage ( 2 oder 4)",4]
[null,{"$f":"IF(OR(C13=\"\",AND($AK$21=4,O13<>\"\")),\"\",1)","v":1},{"$f":"Bericht6!C13","v":0},null,{"$f":"Bericht6!E13","v":0},null,{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13))","v":0},{"$f":"IF(OR(C13=\"\",E13=\"\"),\"\",IF(AND($AK$21=4,O13<>\"\"),\"\",E13+F13*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht6!M13","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!N13","v":""},{"$f":"Bericht6!O13","v":0},{"$f":"IF(OR(Q13=\"\",AND($AK$21=4,AC13<>\"\")),\"\",1)","v":1},{"$f":"Bericht6!Q13","v":0},null,{"$f":"Bericht6!S13","v":0},null,{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13))","v":0},{"$f":"IF(OR(Q13=\"\",S13=\"\"),\"\",IF(AND($AK$21=4,AC13<>\"\"),\"\",S13+T13*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht6!AA13","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!AB13","v":""},{"$f":"Bericht6!AC13","v":0}]
[null,{"$f":"IF(OR(C14=\"\",AND($AK$21=4,O14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":2},{"$f":"Bericht6!C14","v":0},null,{"$f":"Bericht6!E14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht6!M14","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!N14","v":""},{"$f":"Bericht6!O14","v":0},{"$f":"IF(OR(Q14=\"\",AND($AK$21=4,AC14<>\"\")),\"\",COUNT($P$13:P13)+1)","v":2},{"$f":"Bericht6!Q14","v":0},null,{"$f":"Bericht6!S14","v":0},null,0,0,null,null,null,null,{"$f":"Bericht6!AA14","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!AB14","v":""},{"$f":"Bericht6!AC14","v":0},null,null,"Spieler"]
[null,{"$f":"IF(OR(C15=\"\",AND($AK$21=4,O15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":3},{"$f":"Bericht6!C15","v":0},null,{"$f":"Bericht6!E15","v":0},null,{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15))","v":0},{"$f":"IF(OR(C15=\"\",E15=\"\"),\"\",IF(AND($AK$21=4,O15<>\"\"),\"\",E15+F15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht6!M15","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!N15","v":""},{"$f":"Bericht6!O15","v":0},{"$f":"IF(OR(Q15=\"\",AND($AK$21=4,AC15<>\"\")),\"\",COUNT($P$13:P14)+1)","v":3},{"$f":"Bericht6!Q15","v":0},null,{"$f":"Bericht6!S15","v":0},null,{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15))","v":0},{"$f":"IF(OR(Q15=\"\",S15=\"\"),\"\",IF(AND($AK$21=4,AC15<>\"\"),\"\",S15+T15*0.0000001))","v":0},null,null,null,null,{"$f":"Bericht6!AA15","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!AB15","v":""},{"$f":"Bericht6!AC15","v":0},null,null,"pro M-Schaft:",6]
[null,{"$f":"IF(OR(C16=\"\",AND($AK$21=4,O16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":4},{"$f":"Bericht6!C16","v":0},null,{"$f":"Bericht6!E16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht6!M16","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!N16","v":""},{"$f":"Bericht6!O16","v":0},{"$f":"IF(OR(Q16=\"\",AND($AK$21=4,AC16<>\"\")),\"\",COUNT($P$13:P15)+1)","v":4},{"$f":"Bericht6!Q16","v":0},null,{"$f":"Bericht6!S16","v":0},null,0,0,null,null,null,null,{"$f":"Bericht6!AA16","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!AB16","v":""},{"$f":"Bericht6!AC16","v":0}]
[null,{"$f":"IF(OR(C17=\"\",AND($AK$21=4,O17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":5},{"$f":"Bericht6!C17","v":0},null,{"$f":"Bericht6!E17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht6!M17","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!N17","v":""},{"$f":"Bericht6!O17","v":0},{"$f":"IF(OR(Q17=\"\",AND($AK$21=4,AC17<>\"\")),\"\",COUNT($P$13:P16)+1)","v":5},{"$f":"Bericht6!Q17","v":0},null,{"$f":"Bericht6!S17","v":0},null,0,0,null,null,null,null,{"$f":"Bericht6!AA17","v":{"$error":"#VALUE!"}},{"$f":"Bericht6!AB17","v":""},{"$f":"Bericht6!AC17","v":0}]
[null,{"$f":"IF(OR(C18=\"\",AND($AK$21=4,O18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,null,null,"","",null,null,null,null,null,null,null,{"$f":"IF(OR(Q18=\"\",AND($AK$21=4,AC18<>\"\")),\"\",COUNT($P$13:P17)+1)","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AK$21=4,O19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(E19=\"\",\"\",IF(AND(O19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-N19)))","v":""},null,null,{"$f":"IF(OR(Q19=\"\",AND($AK$21=4,AC19<>\"\")),\"\",COUNT($P$13:P18)+1)","v":""},null,null,null,null,"","",null,null,null,null,{"$f":"IF(S19=\"\",\"\",IF(AND(AC19<>\"\",$AK$21=4),\"\",2*$AK$21+(1-AB19)))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"Bericht6!E20","v":""},null,null,null,{"$f":"SUM(I13:I19)","v":0},{"$f":"SUM(J13:J19)","v":0},0,0,{"$f":"Bericht6!M20","v":{"$error":"#VALUE!"}},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht6!S20","v":""},null,null,null,{"$f":"SUM(W13:W19)","v":0},{"$f":"SUM(X13:X19)","v":0},0,0,{"$f":"Bericht6!AA20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AG$15<=5,36,78)","v":78},null,null,{"$f":"IF(AND($AG$15<=5,$AG$3=\"\"),4,IF(AND($AG$15>=6,$AG$3=\"\"),6,IF(AND($AG$15<=5,$AG$3<>\"\"),4,6)))","v":6}]
[null,null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,"Spielpunkte",null,{"$f":"Bericht6!N22","v":""},":",{"$f":"Bericht6!P22","v":""},null,null,"Mannschaftsdurchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK21=4,AW6,AW9)","v":32}]
[null,null,null,{"$f":"Bericht6!D23","v":""},null,null,null,null,null,null,null,"Z-Punkte",null,{"$f":"Bericht6!N23","v":{"$error":"#VALUE!"}},":",{"$f":"Bericht6!P23","v":{"$error":"#VALUE!"}},null,{"$f":"Bericht6!S23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"Bericht6!N24","v":""},":",{"$f":"Bericht6!P24","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht6!E26","v":0},null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht6!S26","v":0}]
[null,null,{"$f":"Bericht6!C27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht6!Q27","v":0}]
[]
[null,null,"Unfall:"]
[null,null,{"$f":"Bericht6!C30","v":0}]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:"]
[null,null,{"$f":"Bericht6!C33","v":0}]
[null,null,{"$f":"Bericht6!C34","v":0}]
[]
[null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht6!E36","v":0},null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht6!S36","v":0}]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,"Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter"]
[null,null,{"$f":"Bericht6!C43","v":0},null,{"$f":"Bericht6!E43","v":""}]

{"sheet":"Bericht7","index":14,"n_rows":41,"n_cols":73,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,41,40,51],[37,2,37,12],[37,15,37,25],[37,28,37,38],[37,41,37,51],[39,2,39,12],[39,15,39,25],[39,28,39,38],[39,41,39,51],[40,2,40,3],[40,4,40,12],[40,15,40,25],[40,28,40,29],[40,30,40,38],[30,41,30,51],[31,41,31,51],[33,41,34,42],[33,43,34,43],[36,2,36,12],[36,15,36,25],[36,28,36,38],[36,41,36,51],[33,2,34,3],[33,4,34,4],[33,15,34,16],[33,17,34,17],[33,28,34,29],[33,30,34,30],[30,2,30,12],[31,2,31,12],[30,15,30,25],[31,15,31,25],[30,28,30,38],[31,28,31,38],[24,2,24,12],[24,15,24,25],[24,28,24,38],[24,41,24,51],[27,2,27,12],[27,15,27,25],[27,28,27,38],[27,41,27,51],[18,2,18,3],[18,15,18,16],[18,28,18,29],[18,41,18,42],[23,2,23,3],[23,15,23,16],[23,28,23,29],[23,41,23,42],[16,2,16,3],[16,15,16,16],[16,28,16,29],[16,41,16,42],[17,2,17,3],[17,15,17,16],[17,28,17,29],[17,41,17,42],[14,2,14,3],[14,15,14,16],[14,28,14,29],[14,41,14,42],[15,2,15,3],[15,15,15,16],[15,28,15,29],[15,41,15,42],[12,2,12,3],[12,15,12,16],[12,28,12,29],[12,41,12,42],[13,2,13,3],[13,15,13,16],[13,28,13,29],[13,41,13,42],[11,2,11,3],[11,15,11,16],[11,28,11,29],[11,41,11,42],[9,2,9,12],[9,15,9,25],[9,28,9,38],[9,41,9,51],[5,5,5,13],[5,16,5,25],[5,31,5,39],[5,42,5,51],[8,2,8,12],[8,15,8,25],[8,28,8,38],[8,41,8,51],[0,1,0,53],[1,1,1,53],[3,3,3,13],[3,16,3,25],[3,29,3,39],[3,42,3,51]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",null,null,null,null,null,null,null,null,null,null,null,null,"Altersklasse:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",null,null,null,null,null,null,null,null,null,null,null,null,"Spiel-Nr.:",null,"Datum:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl  Mannschafzen",{"$f":"SUM(BG8:BG11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9<>\"\",1,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P9<>\"\",1,\"\")","v":""}]
[null,null,"Mannschaft 1",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 2",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 3",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC9<>\"\",1,\"\")","v":""}]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bahnen pro Anlage ( 2 oder 4)",4,null,{"$f":"IF(AP9<>\"\",1,\"\")","v":""}]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis"]
[null,{"$f":"IF(OR(C13=\"\",AND($AH$21=4,N13<>\"\")),\"\",1)","v":""},null,null,null,null,{"$f":"IF(OR($C$9=\"\",C13=\"\",E13=\"\"),\"\",IF(AND($BI$20=4,N13<>\"\"),\"\",IF(F13<>\"\",E13+F13*0.0000000001,E13)))","v":""},null,null,null,null,{"$f":"IF(M13=\"\",\"\",4*$BG$7+(1-M13))","v":""},{"$f":"IF(G13=\"\",\"\",RANK(G13,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P13=\"\",AND($AH$21=4,AA13<>\"\")),\"\",1)","v":""},null,null,null,null,{"$f":"IF(OR($P$9=\"\",P13=\"\",R13=\"\"),\"\",IF(AND($BI$20=4,AA13<>\"\"),\"\",IF(S13<>\"\",R13+S13*0.0000000001,R13)))","v":""},null,null,null,null,{"$f":"IF(Z13=\"\",\"\",4*$BG$7+(1-Z13))","v":""},{"$f":"IF(T13=\"\",\"\",RANK(T13,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC13=\"\",AND($AH$21=4,AN13<>\"\")),\"\",1)","v":""},null,null,null,null,{"$f":"IF(OR($AC$9=\"\",AC13=\"\",AE13=\"\"),\"\",IF(AND($BI$20=4,AN13<>\"\"),\"\",IF(AF13<>\"\",AE13+AF13*0.0000000001,AE13)))","v":""},null,null,null,null,{"$f":"IF(AM13=\"\",\"\",4*$BG$7+(1-AM13))","v":""},{"$f":"IF(AG13=\"\",\"\",RANK(AG13,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP13=\"\",AND($AH$21=4,BA13<>\"\")),\"\",1)","v":""},null,null,null,null,{"$f":"IF(OR($AP$9=\"\",AP13=\"\",AR13=\"\"),\"\",IF(AND($BI$20=4,BA13<>\"\"),\"\",IF(AS13<>\"\",AR13+AS13*0.0000000001,AR13)))","v":""},null,null,null,null,{"$f":"IF(AZ13=\"\",\"\",4*$BG$7+(1-AZ13))","v":""},{"$f":"IF(AT13=\"\",\"\",RANK(AT13,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C14=\"\",AND($AH$21=4,N14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":""},null,null,null,null,{"$f":"IF(OR($C$9=\"\",C14=\"\",E14=\"\"),\"\",IF(AND($BI$20=4,N14<>\"\"),\"\",IF(F14<>\"\",E14+F14*0.0000000001,E14)))","v":""},null,null,null,null,{"$f":"IF(M14=\"\",\"\",4*$BG$7+(1-M14))","v":""},{"$f":"IF(G14=\"\",\"\",RANK(G14,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P14=\"\",AND($AH$21=4,AA14<>\"\")),\"\",COUNT($O$13:O13)+1)","v":""},null,null,null,null,{"$f":"IF(OR($P$9=\"\",P14=\"\",R14=\"\"),\"\",IF(AND($BI$20=4,AA14<>\"\"),\"\",IF(S14<>\"\",R14+S14*0.0000000001,R14)))","v":""},null,null,null,null,"",{"$f":"IF(T14=\"\",\"\",RANK(T14,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC14=\"\",AND($AH$21=4,AN14<>\"\")),\"\",COUNT($AB$13:AB13)+1)","v":""},null,null,null,null,{"$f":"IF(OR($AC$9=\"\",AC14=\"\",AE14=\"\"),\"\",IF(AND($BI$20=4,AN14<>\"\"),\"\",IF(AF14<>\"\",AE14+AF14*0.0000000001,AE14)))","v":""},null,null,null,null,"",{"$f":"IF(AG14=\"\",\"\",RANK(AG14,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP14=\"\",AND($AH$21=4,BA14<>\"\")),\"\",COUNT($AO$13:AO13)+1)","v":""},null,null,null,null,{"$f":"IF(OR($AP$9=\"\",AP14=\"\",AR14=\"\"),\"\",IF(AND($BI$20=4,BA14<>\"\"),\"\",IF(AS14<>\"\",AR14+AS14*0.0000000001,AR14)))","v":""},null,null,null,null,"",{"$f":"IF(AT14=\"\",\"\",RANK(AT14,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,null,null,"pro M-Schaft:",4]
[null,{"$f":"IF(OR(C15=\"\",AND($AH$21=4,N15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(G15=\"\",\"\",RANK(G15,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P15=\"\",AND($AH$21=4,AA15<>\"\")),\"\",COUNT($O$13:O14)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(T15=\"\",\"\",RANK(T15,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC15=\"\",AND($AH$21=4,AN15<>\"\")),\"\",COUNT($AB$13:AB14)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AG15=\"\",\"\",RANK(AG15,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP15=\"\",AND($AH$21=4,BA15<>\"\")),\"\",COUNT($AO$13:AO14)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AT15=\"\",\"\",RANK(AT15,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C16=\"\",AND($AH$21=4,N16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(G16=\"\",\"\",RANK(G16,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P16=\"\",AND($AH$21=4,AA16<>\"\")),\"\",COUNT($O$13:O15)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(T16=\"\",\"\",RANK(T16,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC16=\"\",AND($AH$21=4,AN16<>\"\")),\"\",COUNT($AB$13:AB15)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AG16=\"\",\"\",RANK(AG16,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP16=\"\",AND($AH$21=4,BA16<>\"\")),\"\",COUNT($AO$13:AO15)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AT16=\"\",\"\",RANK(AT16,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AH$21=4,N17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(G17=\"\",\"\",RANK(G17,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P17=\"\",AND($AH$21=4,AA17<>\"\")),\"\",COUNT($O$13:O16)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(T17=\"\",\"\",RANK(T17,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC17=\"\",AND($AH$21=4,AN17<>\"\")),\"\",COUNT($AB$13:AB16)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AG17=\"\",\"\",RANK(AG17,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP17=\"\",AND($AH$21=4,BA17<>\"\")),\"\",COUNT($AO$13:AO16)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AT17=\"\",\"\",RANK(AT17,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AH$21=4,N18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,{"$f":"IF(SUM(H18:K18)=0,\"\",SUM(H18:K18))","v":""},null,{"$f":"IF(OR($C$9=\"\",C18=\"\",E18=\"\"),\"\",IF(AND($BI$20=4,N18<>\"\"),\"\",IF(F18<>\"\",E18+F18*0.0000000001,E18)))","v":""},null,null,null,null,"",{"$f":"IF(G18=\"\",\"\",RANK(G18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P18=\"\",AND($AH$21=4,AA18<>\"\")),\"\",COUNT($O$13:O17)+1)","v":""},null,null,{"$f":"IF(SUM(U18:X18)=0,\"\",SUM(U18:X18))","v":""},null,"",null,null,null,null,"",{"$f":"IF(T18=\"\",\"\",RANK(T18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC18=\"\",AND($AH$21=4,AN18<>\"\")),\"\",COUNT($AB$13:AB17)+1)","v":""},null,null,{"$f":"IF(SUM(AH18:AK18)=0,\"\",SUM(AH18:AK18))","v":""},null,"",null,null,null,null,"",{"$f":"IF(AG18=\"\",\"\",RANK(AG18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP18=\"\",AND($AH$21=4,BA18<>\"\")),\"\",COUNT($AO$13:AO17)+1)","v":""},null,null,{"$f":"IF(SUM(AU18:AX18)=0,\"\",SUM(AU18:AX18))","v":""},null,"",null,null,null,null,"",{"$f":"IF(AT18=\"\",\"\",RANK(AT18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AH$21=4,N19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,"",null,"",null,null,null,null,"",{"$f":"IF(G19=\"\",\"\",RANK(G19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P19=\"\",AND($AH$21=4,AA19<>\"\")),\"\",COUNT($O$13:O18)+1)","v":""},null,null,"",null,"",null,null,null,null,"",{"$f":"IF(T19=\"\",\"\",RANK(T19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC19=\"\",AND($AH$21=4,AN19<>\"\")),\"\",COUNT($AB$13:AB18)+1)","v":""},null,null,"",null,"",null,null,null,null,"",{"$f":"IF(AG19=\"\",\"\",RANK(AG19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP19=\"\",AND($AH$21=4,BA19<>\"\")),\"\",COUNT($AO$13:AO18)+1)","v":""},null,null,"",null,"",null,null,null,null,"",{"$f":"IF(AT19=\"\",\"\",RANK(AT19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"IF(COUNT(G13:G19)>$BI$20,\"Falsche Eingabe\",SUM(G13:G19))","v":0},null,null,null,null,null,null,{"$f":"SUM(L13:L17)","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"IF(COUNT(T13:T19)>$BI$20,\"Falsche Eingabe\",SUM(T13:T19))","v":0},null,null,null,null,null,null,{"$f":"SUM(Y13:Y17)","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"IF(COUNT(AG13:AG19)>$BI$20,\"Falsche Eingabe\",SUM(AG13:AG19))","v":0},null,null,null,null,null,null,{"$f":"SUM(AL13:AL19)","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"IF(COUNT(AT13:AT19)>$BI$20,\"Falsche Eingabe\",SUM(AT13:AT19))","v":0},null,null,null,null,null,null,{"$f":"SUM(AY13:AY17)","v":0},null,null,null,null,null,null,16,null,null,{"$f":"IF(AND($BE$11<=5,$BE$3=\"\"),4,IF(AND($BE$11>=6,$BE$3=\"\"),6,IF(AND($BE$11<=5,$BE$3<>\"\"),4,6)))","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BI20=4,BU5)","v":16}]
[null,null,null,"Platz",{"$f":"IF(C9=\"\",\"\",RANK(E20,($E$20,$R$20,$AE$20,$AR$20)))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"IF(P9=\"\",\"\",RANK(R20,($E$20,$R$20,$AE$20,$AR$20)))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"IF(AC9=\"\",\"\",RANK(AE20,($E$20,$R$20,$AE$20,$AR$20)))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"IF(AP9=\"\",\"\",RANK(AR20,($E$20,$R$20,$AE$20,$AR$20)))","v":""}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                       wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben"]
[]
[]
[null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:"]
[]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:"]
[]
[]
[]
[null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung"]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter",null,null,null,null,null,null,null,null,null,null,null,null,"Ort, Datum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF6=\"\",\"\",AF6)","v":""}]

{"sheet":"Druck7","index":15,"n_rows":41,"n_cols":73,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,53],[1,1,1,53],[3,3,3,13],[3,16,3,25],[3,29,3,39],[3,42,3,51],[5,5,5,13],[5,16,5,25],[5,31,5,39],[5,42,5,51],[8,2,8,12],[8,15,8,25],[8,28,8,38],[8,41,8,51],[9,2,9,12],[9,15,9,25],[9,28,9,38],[9,41,9,51],[11,2,11,3],[11,15,11,16],[11,28,11,29],[11,41,11,42],[12,2,12,3],[12,15,12,16],[12,28,12,29],[12,41,12,42],[13,2,13,3],[13,15,13,16],[13,28,13,29],[13,41,13,42],[14,2,14,3],[14,15,14,16],[14,28,14,29],[14,41,14,42],[15,2,15,3],[15,15,15,16],[15,28,15,29],[15,41,15,42],[16,2,16,3],[16,15,16,16],[16,28,16,29],[16,41,16,42],[17,2,17,3],[17,15,17,16],[17,28,17,29],[17,41,17,42],[18,2,18,3],[18,15,18,16],[18,28,18,29],[18,41,18,42],[23,2,23,3],[23,15,23,16],[23,28,23,29],[23,41,23,42],[24,2,24,12],[24,15,24,25],[24,28,24,38],[24,41,24,51],[27,2,27,12],[27,15,27,25],[27,28,27,38],[27,41,27,51],[30,2,30,12],[30,15,30,25],[30,28,30,38],[30,41,30,51],[31,2,31,12],[31,15,31,25],[31,28,31,38],[31,41,31,51],[33,41,34,42],[33,43,34,43],[36,2,36,12],[36,15,36,25],[36,28,36,38],[36,41,36,51],[33,2,34,3],[33,4,34,4],[33,15,34,16],[33,17,34,17],[33,28,34,29],[33,30,34,30],[40,41,40,51],[37,2,37,12],[37,15,37,25],[37,28,37,38],[37,41,37,51],[39,2,39,12],[39,15,39,25],[39,28,39,38],[39,41,39,51],[40,2,40,3],[40,4,40,12],[40,15,40,25],[40,28,40,29],[40,30,40,38]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",{"$f":"Bericht7!Q4","v":0},null,null,null,null,null,null,null,null,null,null,null,"Altersklasse:",{"$f":"Bericht7!AD4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",{"$f":"Bericht7!Q6","v":0},null,null,null,null,null,null,null,null,null,null,null,"Spiel-Nr.:",{"$f":"Bericht7!AD6","v":0},"Datum:",{"$f":"Bericht7!AF6","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl  Mannschafzen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,{"$f":"Bericht7!C9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!P9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AC9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AP9","v":0}]
[null,null,"Mannschaft 1",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 2",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 3",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 4"]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bahnen pro Anlage ( 2 oder 4)"]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis"]
[null,{"$f":"IF(OR(C13=\"\",AND($AH$21=4,N13<>\"\")),\"\",1)","v":1},{"$f":"Bericht7!C13","v":0},null,{"$f":"Bericht7!E13","v":0},null,null,{"$f":"Bericht7!H13","v":0},{"$f":"Bericht7!I13","v":0},{"$f":"Bericht7!J13","v":0},{"$f":"Bericht7!K13","v":0},{"$f":"Bericht7!L13","v":""},{"$f":"Bericht7!M13","v":""},{"$f":"Bericht7!N13","v":0},{"$f":"IF(OR(P13=\"\",AND($AH$21=4,AA13<>\"\")),\"\",1)","v":1},{"$f":"Bericht7!P13","v":0},null,{"$f":"Bericht7!R13","v":0},null,{"$f":"IF(OR($P$9=\"\",P13=\"\",R13=\"\"),\"\",IF(AND($BI$20=4,AA13<>\"\"),\"\",IF(S13<>\"\",R13+S13*0.0000000001,R13)))","v":0},null,null,null,null,{"$f":"Bericht7!Y13","v":""},{"$f":"Bericht7!Z13","v":""},{"$f":"Bericht7!AA13","v":0},{"$f":"IF(OR(AC13=\"\",AND($AH$21=4,AN13<>\"\")),\"\",1)","v":1},{"$f":"Bericht7!AC13","v":0},null,{"$f":"Bericht7!AE13","v":0},null,{"$f":"IF(OR($AC$9=\"\",AC13=\"\",AE13=\"\"),\"\",IF(AND($BI$20=4,AN13<>\"\"),\"\",IF(AF13<>\"\",AE13+AF13*0.0000000001,AE13)))","v":0},null,null,null,null,{"$f":"Bericht7!AL13","v":""},{"$f":"Bericht7!AM13","v":""},{"$f":"Bericht7!AN13","v":0},{"$f":"IF(OR(AP13=\"\",AND($AH$21=4,BA13<>\"\")),\"\",1)","v":1},{"$f":"Bericht7!AP13","v":0},null,{"$f":"Bericht7!AR13","v":0},null,{"$f":"IF(OR($AP$9=\"\",AP13=\"\",AR13=\"\"),\"\",IF(AND($BI$20=4,BA13<>\"\"),\"\",IF(AS13<>\"\",AR13+AS13*0.0000000001,AR13)))","v":0},null,null,null,null,{"$f":"Bericht7!AY13","v":""},{"$f":"Bericht7!AZ13","v":""},{"$f":"Bericht7!BA13","v":0},null,null,"Spieler"]
[null,{"$f":"IF(OR(C14=\"\",AND($AH$21=4,N14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":2},{"$f":"Bericht7!C14","v":0},null,{"$f":"Bericht7!E14","v":0},null,null,{"$f":"Bericht7!H14","v":0},{"$f":"Bericht7!I14","v":0},{"$f":"Bericht7!J14","v":0},{"$f":"Bericht7!K14","v":0},{"$f":"Bericht7!L14","v":""},{"$f":"Bericht7!M14","v":""},{"$f":"Bericht7!N14","v":0},{"$f":"IF(OR(P14=\"\",AND($AH$21=4,AA14<>\"\")),\"\",COUNT($O$13:O13)+1)","v":2},{"$f":"Bericht7!P14","v":0},null,{"$f":"Bericht7!R14","v":0},null,{"$f":"IF(OR($P$9=\"\",P14=\"\",R14=\"\"),\"\",IF(AND($BI$20=4,AA14<>\"\"),\"\",IF(S14<>\"\",R14+S14*0.0000000001,R14)))","v":0},null,null,null,null,{"$f":"Bericht7!Y14","v":""},{"$f":"Bericht7!Z14","v":""},{"$f":"Bericht7!AA14","v":0},{"$f":"IF(OR(AC14=\"\",AND($AH$21=4,AN14<>\"\")),\"\",COUNT($AB$13:AB13)+1)","v":2},{"$f":"Bericht7!AC14","v":0},null,{"$f":"Bericht7!AE14","v":0},null,{"$f":"IF(OR($AC$9=\"\",AC14=\"\",AE14=\"\"),\"\",IF(AND($BI$20=4,AN14<>\"\"),\"\",IF(AF14<>\"\",AE14+AF14*0.0000000001,AE14)))","v":0},null,null,null,null,{"$f":"Bericht7!AL14","v":""},{"$f":"Bericht7!AM14","v":""},{"$f":"Bericht7!AN14","v":0},{"$f":"IF(OR(AP14=\"\",AND($AH$21=4,BA14<>\"\")),\"\",COUNT($AO$13:AO13)+1)","v":2},{"$f":"Bericht7!AP14","v":0},null,{"$f":"Bericht7!AR14","v":0},null,{"$f":"IF(OR($AP$9=\"\",AP14=\"\",AR14=\"\"),\"\",IF(AND($BI$20=4,BA14<>\"\"),\"\",IF(AS14<>\"\",AR14+AS14*0.0000000001,AR14)))","v":0},null,null,null,null,{"$f":"Bericht7!AY14","v":""},{"$f":"Bericht7!AZ14","v":""},{"$f":"Bericht7!BA14","v":0},null,null,"pro M-Schaft:"]
[null,{"$f":"IF(OR(C15=\"\",AND($AH$21=4,N15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":3},{"$f":"Bericht7!C15","v":0},null,{"$f":"Bericht7!E15","v":0},null,null,{"$f":"Bericht7!H15","v":0},{"$f":"Bericht7!I15","v":0},{"$f":"Bericht7!J15","v":0},{"$f":"Bericht7!K15","v":0},{"$f":"Bericht7!L15","v":""},{"$f":"Bericht7!M15","v":""},{"$f":"Bericht7!N15","v":0},{"$f":"IF(OR(P15=\"\",AND($AH$21=4,AA15<>\"\")),\"\",COUNT($O$13:O14)+1)","v":3},{"$f":"Bericht7!P15","v":0},null,{"$f":"Bericht7!R15","v":0},null,0,null,null,null,null,{"$f":"Bericht7!Y15","v":""},{"$f":"Bericht7!Z15","v":""},{"$f":"Bericht7!AA15","v":0},{"$f":"IF(OR(AC15=\"\",AND($AH$21=4,AN15<>\"\")),\"\",COUNT($AB$13:AB14)+1)","v":3},{"$f":"Bericht7!AC15","v":0},null,{"$f":"Bericht7!AE15","v":0},null,0,null,null,null,null,{"$f":"Bericht7!AL15","v":""},{"$f":"Bericht7!AM15","v":""},{"$f":"Bericht7!AN15","v":0},{"$f":"IF(OR(AP15=\"\",AND($AH$21=4,BA15<>\"\")),\"\",COUNT($AO$13:AO14)+1)","v":3},{"$f":"Bericht7!AP15","v":0},null,{"$f":"Bericht7!AR15","v":0},null,0,null,null,null,null,{"$f":"Bericht7!AY15","v":""},{"$f":"Bericht7!AZ15","v":""},{"$f":"Bericht7!BA15","v":0}]
[null,{"$f":"IF(OR(C16=\"\",AND($AH$21=4,N16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":4},{"$f":"Bericht7!C16","v":0},null,{"$f":"Bericht7!E16","v":0},null,null,{"$f":"Bericht7!H16","v":0},{"$f":"Bericht7!I16","v":0},{"$f":"Bericht7!J16","v":0},{"$f":"Bericht7!K16","v":0},{"$f":"Bericht7!L16","v":""},{"$f":"Bericht7!M16","v":""},{"$f":"Bericht7!N16","v":0},{"$f":"IF(OR(P16=\"\",AND($AH$21=4,AA16<>\"\")),\"\",COUNT($O$13:O15)+1)","v":4},{"$f":"Bericht7!P16","v":0},null,{"$f":"Bericht7!R16","v":0},null,0,null,null,null,null,{"$f":"Bericht7!Y16","v":""},{"$f":"Bericht7!Z16","v":""},{"$f":"Bericht7!AA16","v":0},{"$f":"IF(OR(AC16=\"\",AND($AH$21=4,AN16<>\"\")),\"\",COUNT($AB$13:AB15)+1)","v":4},{"$f":"Bericht7!AC16","v":0},null,{"$f":"Bericht7!AE16","v":0},null,0,null,null,null,null,{"$f":"Bericht7!AL16","v":""},{"$f":"Bericht7!AM16","v":""},{"$f":"Bericht7!AN16","v":0},{"$f":"IF(OR(AP16=\"\",AND($AH$21=4,BA16<>\"\")),\"\",COUNT($AO$13:AO15)+1)","v":4},{"$f":"Bericht7!AP16","v":0},null,{"$f":"Bericht7!AR16","v":0},null,0,null,null,null,null,{"$f":"Bericht7!AY16","v":""},{"$f":"Bericht7!AZ16","v":""},{"$f":"Bericht7!BA16","v":0}]
[null,{"$f":"IF(OR(C17=\"\",AND($AH$21=4,N17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":5},{"$f":"Bericht7!C17","v":0},null,{"$f":"Bericht7!E17","v":0},null,null,{"$f":"Bericht7!H17","v":0},{"$f":"Bericht7!I17","v":0},{"$f":"Bericht7!J17","v":0},{"$f":"Bericht7!K17","v":0},{"$f":"Bericht7!L17","v":""},{"$f":"Bericht7!M17","v":""},{"$f":"Bericht7!N17","v":0},{"$f":"IF(OR(P17=\"\",AND($AH$21=4,AA17<>\"\")),\"\",COUNT($O$13:O16)+1)","v":5},{"$f":"Bericht7!P17","v":0},null,{"$f":"Bericht7!R17","v":0},null,0,null,null,null,null,{"$f":"Bericht7!Y17","v":""},{"$f":"Bericht7!Z17","v":""},{"$f":"Bericht7!AA17","v":0},{"$f":"IF(OR(AC17=\"\",AND($AH$21=4,AN17<>\"\")),\"\",COUNT($AB$13:AB16)+1)","v":5},{"$f":"Bericht7!AC17","v":0},null,{"$f":"Bericht7!AE17","v":0},null,0,null,null,null,null,{"$f":"Bericht7!AL17","v":""},{"$f":"Bericht7!AM17","v":""},{"$f":"Bericht7!AN17","v":0},{"$f":"IF(OR(AP17=\"\",AND($AH$21=4,BA17<>\"\")),\"\",COUNT($AO$13:AO16)+1)","v":5},{"$f":"Bericht7!AP17","v":0},null,{"$f":"Bericht7!AR17","v":0},null,0,null,null,null,null,{"$f":"Bericht7!AY17","v":""},{"$f":"Bericht7!AZ17","v":""},{"$f":"Bericht7!BA17","v":0}]
[null,{"$f":"IF(OR(C18=\"\",AND($AH$21=4,N18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,{"$f":"IF(SUM(H18:K18)=0,\"\",SUM(H18:K18))","v":""},null,null,null,null,null,null,{"$f":"IF(M18=\"\",\"\",4*$BG$7+(1-M18))","v":""},{"$f":"IF(G18=\"\",\"\",RANK(G18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P18=\"\",AND($AH$21=4,AA18<>\"\")),\"\",COUNT($O$13:O17)+1)","v":""},null,null,{"$f":"IF(SUM(U18:X18)=0,\"\",SUM(U18:X18))","v":""},null,"",null,null,null,null,{"$f":"IF(Z18=\"\",\"\",4*$BG$7+(1-Z18))","v":""},{"$f":"IF(T18=\"\",\"\",RANK(T18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC18=\"\",AND($AH$21=4,AN18<>\"\")),\"\",COUNT($AB$13:AB17)+1)","v":""},null,null,{"$f":"IF(SUM(AH18:AK18)=0,\"\",SUM(AH18:AK18))","v":""},null,"",null,null,null,null,{"$f":"IF(AM18=\"\",\"\",4*$BG$7+(1-AM18))","v":""},{"$f":"IF(AG18=\"\",\"\",RANK(AG18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP18=\"\",AND($AH$21=4,BA18<>\"\")),\"\",COUNT($AO$13:AO17)+1)","v":""},null,null,{"$f":"IF(SUM(AU18:AX18)=0,\"\",SUM(AU18:AX18))","v":""},null,"",null,null,null,null,{"$f":"IF(AZ18=\"\",\"\",4*$BG$7+(1-AZ18))","v":""},{"$f":"IF(AT18=\"\",\"\",RANK(AT18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AH$21=4,N19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,"",null,null,null,null,null,null,"",{"$f":"IF(G19=\"\",\"\",RANK(G19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P19=\"\",AND($AH$21=4,AA19<>\"\")),\"\",COUNT($O$13:O18)+1)","v":""},null,null,"",null,"",null,null,null,null,"",{"$f":"IF(T19=\"\",\"\",RANK(T19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC19=\"\",AND($AH$21=4,AN19<>\"\")),\"\",COUNT($AB$13:AB18)+1)","v":""},null,null,"",null,"",null,null,null,null,"",{"$f":"IF(AG19=\"\",\"\",RANK(AG19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP19=\"\",AND($AH$21=4,BA19<>\"\")),\"\",COUNT($AO$13:AO18)+1)","v":""},null,null,"",null,"",null,null,null,null,"",{"$f":"IF(AT19=\"\",\"\",RANK(AT19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"Bericht7!E20","v":0},null,null,null,null,null,null,{"$f":"Bericht7!L20","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht7!R20","v":0},null,null,null,null,null,null,{"$f":"Bericht7!Y20","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht7!AE20","v":0},null,null,null,null,null,null,{"$f":"Bericht7!AL20","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"Bericht7!AR20","v":0},null,null,null,null,null,null,{"$f":"Bericht7!AY20","v":0}]
[]
[null,null,null,"Platz",{"$f":"Bericht7!E22","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"Bericht7!R22","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"Bericht7!AE22","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"Bericht7!AR22","v":""}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht7!E24","v":0},null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht7!R24","v":0},null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                       wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht7!AE24","v":0},null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,{"$f":"Bericht7!AR24","v":0}]
[null,null,{"$f":"Bericht7!C25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!P25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AC25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AP25","v":0}]
[]
[null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:"]
[null,null,{"$f":"Bericht7!C28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!P28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AC28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AP28","v":0}]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:"]
[null,null,{"$f":"Bericht7!C31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!P31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AC31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AP31","v":0}]
[null,null,{"$f":"Bericht7!C32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!P32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AC32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Bericht7!AP32","v":0}]
[]
[null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht7!E34","v":0},null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht7!R34","v":0},null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht7!AE34","v":0},null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,{"$f":"Bericht7!AR34","v":0}]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter",null,null,null,null,null,null,null,null,null,null,null,null,"Ort, Datum"]
[null,null,null,null,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":"Bericht7!AC41","v":0},null,{"$f":"IF(AF6=\"\",\"\",AF6)","v":"00:00:00"}]

{"sheet":"Bericht 7-1","index":16,"n_rows":41,"n_cols":73,"rows_kept":41,"cut":false,"hidden":true,"merged":[[14,28,14,29],[16,41,16,42],[33,2,34,3],[33,4,34,4],[33,15,34,16],[33,17,34,17],[18,2,18,3],[18,15,18,16],[23,2,23,3],[23,15,23,16],[24,2,24,12],[24,15,24,25],[27,2,27,12],[27,15,27,25],[31,2,31,12],[27,28,27,38],[36,2,36,12],[36,15,36,25],[37,2,37,12],[37,15,37,25],[39,2,39,12],[39,15,39,25],[40,2,40,3],[40,4,40,12],[40,15,40,25],[40,41,40,51],[40,30,40,38],[40,28,40,29],[33,43,34,43],[33,41,34,42],[33,30,34,30],[33,28,34,29],[39,41,39,51],[39,28,39,38],[37,41,37,51],[37,28,37,38],[36,41,36,51],[36,28,36,38],[27,41,27,51],[17,2,17,3],[17,15,17,16],[23,41,23,42],[23,28,23,29],[17,41,17,42],[17,28,17,29],[12,2,12,3],[12,15,12,16],[24,41,24,51],[24,28,24,38],[18,41,18,42],[18,28,18,29],[16,28,16,29],[15,41,15,42],[14,2,14,3],[14,15,14,16],[15,2,15,3],[15,15,15,16],[16,2,16,3],[16,15,16,16],[15,28,15,29],[14,41,14,42],[0,1,0,53],[1,1,1,53],[8,41,8,51],[5,42,5,51],[5,31,5,39],[3,42,3,51],[3,29,3,39],[8,15,8,25],[8,28,8,38],[5,5,5,13],[5,16,5,25],[8,2,8,12],[3,3,3,13],[3,16,3,25],[9,41,9,51],[9,28,9,38],[9,15,9,25],[9,2,9,12],[30,2,30,12],[30,15,30,25],[13,41,13,42],[13,28,13,29],[12,41,12,42],[12,28,12,29],[11,41,11,42],[11,28,11,29],[11,2,11,3],[11,15,11,16],[13,2,13,3],[13,15,13,16],[31,15,31,25],[30,28,30,38],[31,28,31,38],[30,41,30,51],[31,41,31,51]]}
[null,"Landesverband Kegeln / Bowling Sachsen-Anhalt e.V."]
[null,"Spielbericht"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spielklasse:",null,null,null,null,null,null,null,null,null,null,null,null,"Altersklasse:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      4er Mannsch.",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sportstätte:",null,null,null,null,null,null,null,null,null,null,null,null,"Spiel-Nr.:",null,"Datum:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl  Mannschafzen",{"$f":"SUM(BG8:BG11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9<>\"\",1,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"mindest EWP      6er Mannsch.",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P9<>\"\",1,\"\")","v":""}]
[null,null,"Mannschaft 1",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 2",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 3",null,null,null,null,null,null,null,null,null,null,null,null,"Mannschaft 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC9<>\"\",1,\"\")","v":""}]
[null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,"Name und Vorname in der Reihenfolge des Starts:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bahnen pro Anlage ( 2 oder 4)",4,null,{"$f":"IF(AP9<>\"\",1,\"\")","v":""}]
[null,null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis",null,"Name, Vorname",null,"Holz","Auszlg",null,"Bahn 1","Bahn 2","Bahn 3","Bahn 4","Ew-Pkt","Platz","Streichergebnis"]
[null,{"$f":"IF(OR(C13=\"\",AND($AH$21=4,N13<>\"\")),\"\",1)","v":""},null,null,null,null,{"$f":"IF(OR($C$9=\"\",C13=\"\",E13=\"\"),\"\",IF(AND($BI$20=4,N13<>\"\"),\"\",IF(F13<>\"\",E13+F13*0.0000000001,E13)))","v":""},null,null,null,null,{"$f":"IF(M13=\"\",\"\",4*$BG$7+(1-M13))","v":""},{"$f":"IF(G13=\"\",\"\",RANK(G13,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P13=\"\",AND($AH$21=4,AA13<>\"\")),\"\",1)","v":""},null,null,null,null,{"$f":"IF(OR($P$9=\"\",P13=\"\",R13=\"\"),\"\",IF(AND($BI$20=4,AA13<>\"\"),\"\",IF(S13<>\"\",R13+S13*0.0000000001,R13)))","v":""},null,null,null,null,{"$f":"IF(Z13=\"\",\"\",4*$BG$7+(1-Z13))","v":""},{"$f":"IF(T13=\"\",\"\",RANK(T13,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC13=\"\",AND($AH$21=4,AN13<>\"\")),\"\",1)","v":""},null,null,null,null,{"$f":"IF(OR($AC$9=\"\",AC13=\"\",AE13=\"\"),\"\",IF(AND($BI$20=4,AN13<>\"\"),\"\",IF(AF13<>\"\",AE13+AF13*0.0000000001,AE13)))","v":""},null,null,null,null,{"$f":"IF(AM13=\"\",\"\",4*$BG$7+(1-AM13))","v":""},{"$f":"IF(AG13=\"\",\"\",RANK(AG13,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP13=\"\",AND($AH$21=4,BA13<>\"\")),\"\",1)","v":""},null,null,null,null,{"$f":"IF(OR($AP$9=\"\",AP13=\"\",AR13=\"\"),\"\",IF(AND($BI$20=4,BA13<>\"\"),\"\",IF(AS13<>\"\",AR13+AS13*0.0000000001,AR13)))","v":""},null,null,null,null,{"$f":"IF(AZ13=\"\",\"\",4*$BG$7+(1-AZ13))","v":""},{"$f":"IF(AT13=\"\",\"\",RANK(AT13,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,null,null,"Spieler"]
[null,{"$f":"IF(OR(C14=\"\",AND($AH$21=4,N14<>\"\")),\"\",COUNT($B$13:B13)+1)","v":""},null,null,null,null,{"$f":"IF(OR($C$9=\"\",C14=\"\",E14=\"\"),\"\",IF(AND($BI$20=4,N14<>\"\"),\"\",IF(F14<>\"\",E14+F14*0.0000000001,E14)))","v":""},null,null,null,null,{"$f":"IF(M14=\"\",\"\",4*$BG$7+(1-M14))","v":""},{"$f":"IF(G14=\"\",\"\",RANK(G14,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P14=\"\",AND($AH$21=4,AA14<>\"\")),\"\",COUNT($O$13:O13)+1)","v":""},null,null,null,null,{"$f":"IF(OR($P$9=\"\",P14=\"\",R14=\"\"),\"\",IF(AND($BI$20=4,AA14<>\"\"),\"\",IF(S14<>\"\",R14+S14*0.0000000001,R14)))","v":""},null,null,null,null,"",{"$f":"IF(T14=\"\",\"\",RANK(T14,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC14=\"\",AND($AH$21=4,AN14<>\"\")),\"\",COUNT($AB$13:AB13)+1)","v":""},null,null,null,null,{"$f":"IF(OR($AC$9=\"\",AC14=\"\",AE14=\"\"),\"\",IF(AND($BI$20=4,AN14<>\"\"),\"\",IF(AF14<>\"\",AE14+AF14*0.0000000001,AE14)))","v":""},null,null,null,null,"",{"$f":"IF(AG14=\"\",\"\",RANK(AG14,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP14=\"\",AND($AH$21=4,BA14<>\"\")),\"\",COUNT($AO$13:AO13)+1)","v":""},null,null,null,null,{"$f":"IF(OR($AP$9=\"\",AP14=\"\",AR14=\"\"),\"\",IF(AND($BI$20=4,BA14<>\"\"),\"\",IF(AS14<>\"\",AR14+AS14*0.0000000001,AR14)))","v":""},null,null,null,null,"",{"$f":"IF(AT14=\"\",\"\",RANK(AT14,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,null,null,"pro M-Schaft:",4]
[null,{"$f":"IF(OR(C15=\"\",AND($AH$21=4,N15<>\"\")),\"\",COUNT($B$13:B14)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(G15=\"\",\"\",RANK(G15,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P15=\"\",AND($AH$21=4,AA15<>\"\")),\"\",COUNT($O$13:O14)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(T15=\"\",\"\",RANK(T15,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC15=\"\",AND($AH$21=4,AN15<>\"\")),\"\",COUNT($AB$13:AB14)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AG15=\"\",\"\",RANK(AG15,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP15=\"\",AND($AH$21=4,BA15<>\"\")),\"\",COUNT($AO$13:AO14)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AT15=\"\",\"\",RANK(AT15,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C16=\"\",AND($AH$21=4,N16<>\"\")),\"\",COUNT($B$13:B15)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(G16=\"\",\"\",RANK(G16,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P16=\"\",AND($AH$21=4,AA16<>\"\")),\"\",COUNT($O$13:O15)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(T16=\"\",\"\",RANK(T16,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC16=\"\",AND($AH$21=4,AN16<>\"\")),\"\",COUNT($AB$13:AB15)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AG16=\"\",\"\",RANK(AG16,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP16=\"\",AND($AH$21=4,BA16<>\"\")),\"\",COUNT($AO$13:AO15)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AT16=\"\",\"\",RANK(AT16,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C17=\"\",AND($AH$21=4,N17<>\"\")),\"\",COUNT($B$13:B16)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(G17=\"\",\"\",RANK(G17,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P17=\"\",AND($AH$21=4,AA17<>\"\")),\"\",COUNT($O$13:O16)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(T17=\"\",\"\",RANK(T17,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC17=\"\",AND($AH$21=4,AN17<>\"\")),\"\",COUNT($AB$13:AB16)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AG17=\"\",\"\",RANK(AG17,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP17=\"\",AND($AH$21=4,BA17<>\"\")),\"\",COUNT($AO$13:AO16)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AT17=\"\",\"\",RANK(AT17,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C18=\"\",AND($AH$21=4,N18<>\"\")),\"\",COUNT($B$13:B17)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(G18=\"\",\"\",RANK(G18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P18=\"\",AND($AH$21=4,AA18<>\"\")),\"\",COUNT($O$13:O17)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(T18=\"\",\"\",RANK(T18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC18=\"\",AND($AH$21=4,AN18<>\"\")),\"\",COUNT($AB$13:AB17)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AG18=\"\",\"\",RANK(AG18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP18=\"\",AND($AH$21=4,BA18<>\"\")),\"\",COUNT($AO$13:AO17)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AT18=\"\",\"\",RANK(AT18,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,{"$f":"IF(OR(C19=\"\",AND($AH$21=4,N19<>\"\")),\"\",COUNT($B$13:B18)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(G19=\"\",\"\",RANK(G19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(P19=\"\",AND($AH$21=4,AA19<>\"\")),\"\",COUNT($O$13:O18)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(T19=\"\",\"\",RANK(T19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AC19=\"\",AND($AH$21=4,AN19<>\"\")),\"\",COUNT($AB$13:AB18)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AG19=\"\",\"\",RANK(AG19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""},null,{"$f":"IF(OR(AP19=\"\",AND($AH$21=4,BA19<>\"\")),\"\",COUNT($AO$13:AO18)+1)","v":""},null,null,null,null,"",null,null,null,null,"",{"$f":"IF(AT19=\"\",\"\",RANK(AT19,($G$13:$G$19,$T$13:$T$19,$AG$13:$AG$19,$AT$13:$AT$19),0))","v":""}]
[null,null,"Gesamtergebnis",null,{"$f":"IF(COUNT(G13:G19)>$BI$20,\"Falsche Eingabe\",SUM(G13:G19))","v":0},null,null,{"$f":"SUM(H13:H19)","v":0},{"$f":"SUM(I13:I19)","v":0},0,0,{"$f":"SUM(L13:L17)","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"IF(COUNT(T13:T19)>$BI$20,\"Falsche Eingabe\",SUM(T13:T19))","v":0},null,null,{"$f":"SUM(U13:U19)","v":0},{"$f":"SUM(V13:V19)","v":0},0,0,{"$f":"SUM(Y13:Y17)","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"IF(COUNT(AG13:AG19)>$BI$20,\"Falsche Eingabe\",SUM(AG13:AG19))","v":0},null,null,{"$f":"SUM(AH13:AH19)","v":0},{"$f":"SUM(AI13:AI19)","v":0},0,0,{"$f":"SUM(AL13:AL17)","v":0},null,null,null,"Gesamtergebnis",null,{"$f":"IF(COUNT(AT13:AT19)>$BI$20,\"Falsche Eingabe\",SUM(AT13:AT19))","v":0},null,null,{"$f":"SUM(AU13:AU19)","v":0},{"$f":"SUM(AV13:AV19)","v":0},0,0,{"$f":"SUM(AY13:AY17)","v":0},null,null,null,null,null,null,16,null,null,{"$f":"IF(AND($BE$11<=5,$BE$3=\"\"),4,IF(AND($BE$11>=6,$BE$3=\"\"),6,IF(AND($BE$11<=5,$BE$3<>\"\"),4,6)))","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BI20=4,BU5)","v":16}]
[null,null,null,"Platz",{"$f":"IF(C9=\"\",\"\",RANK(E20,($E$20,$R$20,$AE$20,$AR$20)))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"IF(P9=\"\",\"\",RANK(R20,($E$20,$R$20,$AE$20,$AR$20)))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"IF(AC9=\"\",\"\",RANK(AE20,($E$20,$R$20,$AE$20,$AR$20)))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Platz",{"$f":"IF(AP9=\"\",\"\",RANK(AR20,($E$20,$R$20,$AE$20,$AR$20)))","v":""}]
[]
[null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                    wenn ja, Produkt o. Firma angeben",null,null,null,null,null,null,null,null,null,null,null,null,"Trikotwerbung                                                                   wenn ja, Produkt o. Firma angeben"]
[]
[]
[null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:",null,null,null,null,null,null,null,null,null,null,null,null,"Unfall:"]
[]
[]
[null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:",null,null,null,null,null,null,null,null,null,null,null,null,"Beanstandungen und Einspruchsvermerke:"]
[]
[]
[]
[null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung",null,null,null,null,null,null,null,null,null,null,null,null,"Spielerpässe in Ordnung"]
[]
[]
[null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:",null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Mannschaftsleiter:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Wettspielleiter",null,null,null,null,null,null,null,null,null,null,null,null,"Ort, Datum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF6=\"\",\"\",AF6)","v":""}]

{"sheet":"Daten","index":17,"n_rows":115,"n_cols":12,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[]
["Verbandsliga",null,"Axiener SV ",null,null,"Alleringersleben,",null,"Damen","ja",{"$f":"TODAY()","v":"2023-09-04"},null,"Damen"]
["Landesliga Staffel 1",null,"Axiener SV II.",null,null,"Arendsee,",null,"Herren","nein",null,null,"Damen A/B/C"]
["Landesliga Staffel 2",null,"Blau-Gelb Alleringersleben",null,null,"Arneburg,",null,"Senioren",null,null,null,"Herren"]
["Landesliga Staffel 3",null,"Blau-Gelb Alleringersleben II.",null,null,"Aulosen,",null,null,null,null,null,"Herren A"]
["Landesliga Staffel 4",null,"Blau-Rot Coswig ",null,null,"Axien,",null,"KKBV Harz",null,null,null,"Herren B/C"]
["Landesklasse Staffel 1",null,"Blau-Rot Coswig II.",null,null,"Badeborn,",null,"KKV Stendal"]
["Landesklasse Staffel 2",null,"Blau-Rot Pratau",null,null,"Ballenstedt,",null,"KKV Wittenberg"]
["Landesklasse Staffel 3",null,"Blau-Rot Pratau II.",null,null,"Beendorf,",null,"KV Börde"]
["Landesklasse Staffel 4",null,"Börde Rottmersleben",null,null,"Binde,",null,"KV Altmark-West Salzwedel"]
["Harzliga ",null,"Börde Rottmersleben II.",null,null,"Bismark,",null,"KV Jerichower Land"]
["Harzklasse",null,"Burger KC 1953",null,null,"Blankenburg,"]
["Vereinsliga",null,"Burger KC 1953 II.",null,null,"Born,"]
["Vereinsklasse",null,"Einheit Halberstadt",null,null,"Burg,"]
[null,null,"ESV Lok Stendal",null,null,"Colbitz,"]
[null,null,"ESV Lok Stendal II.",null,null,"Coswig,"]
[null,null,"FSV Demker",null,null,"Dannefeld,"]
[null,null,"FSV Demker II.",null,null,"Demker,"]
[null,null,"Geele Kaugel Ditfurt",null,null,"Derenburg,"]
[null,null,"Genthiner KC",null,null,"Ditfurt,"]
[null,null,"Genthiner KC II.",null,null,"Ebendorf,"]
[null,null,"Germania Wartenberg",null,null,"Gallin,"]
[null,null,"Germania Wartenberg II.",null,null,"Gatersleben,"]
[null,null,"Grün-Weiß Süplingen ",null,null,"Genthin,"]
[null,null,"Grün-Weiß Süplingen II.",null,null,"Goldbeck,"]
[null,null,"Halberstädter KSV Harmonie",null,null,"Halberstadt,"]
[null,null,"Haldensleber KC",null,null,"Haldensleben,"]
[null,null,"Haldensleber KC II.",null,null,"Havelberg,"]
[null,null,"Hederslebener SV 1931",null,null,"Hedersleben,"]
[null,null,"Hederslebener SV 1931 II.",null,null,"Hessen,"]
[null,null,"Hessener SV",null,null,"Heudeber,"]
[null,null,"HSV Colbitz",null,null,"Hödingen,"]
[null,null,"HSV Colbitz II.",null,null,"Holzdorf,"]
[null,null,"Kali Wolmirstedt",null,null,"Jerichow,"]
[null,null,"Kali Wolmirstedt II.",null,null,"Kläden,"]
[null,null,"KC Arendsee",null,null,"Köckte,"]
[null,null,"KC Arendsee II.",null,null,"Kropstädt,"]
[null,null,"KC Rot-Weiß Seyda",null,null,"Kunrau,"]
[null,null,"KC Rot-Weiß Seyda II.",null,null,"Lockstedt,"]
[null,null,"KC Salzwedel",null,null,"Magdeburg,"]
[null,null,"KC Salzwedel II.",null,null,"Mieste,"]
[null,null,"Klädener SV",null,null,"Möckern,"]
[null,null,"Klädener SV II.",null,null,"Morsleben,"]
[null,null,"Kropstädter SV 02",null,null,"Osterburg,"]
[null,null,"Kropstädter SV 02 II.",null,null,"Pratau,"]
[null,null,"KSC Osterburg",null,null,"Quedlinburg,"]
[null,null,"KSC Osterburg II.",null,null,"Reinsdorf,"]
[null,null,"KSV Badeborn",null,null,"Rottmersleben,"]
[null,null,"KSV Badeborn II.",null,null,"Salzwedel,"]
[null,null,"KSV Holzdorf",null,null,"Seyda,"]
[null,null,"KSV Holzdorf II.",null,null,"Stendal,"]
[null,null,"KSV Reinsdorf ",null,null,"Stendal,"]
[null,null,"KSV Reinsdorf II.",null,null,"Süplingen,"]
[null,null,"KV Mieste",null,null,"Tangermünde,"]
[null,null,"KV Mieste II.",null,null,"Uchtdorf,"]
[null,null,"Lockstedter SV ",null,null,"Wartenberg,"]
[null,null,"Lockstedter SV II.",null,null,"Werben,"]
[null,null,"Lok Jerichow",null,null,"Wittenberg,"]
[null,null,"Lok Jerichow II.",null,null,"Wolmirstedt,"]
[null,null,"Möckeraner TV ",null,null,"Zahna,"]
[null,null,"Möckeraner TV II."]
[null,null,"Rot-Weiß Werben"]
[null,null,"Rot-Weiß Werben II."]
[null,null,"Saxonia Gatersleben"]
[null,null,"SC 1919 Heudeber"]
[null,null,"Schwarz-Weiß Bismark"]
[null,null,"Schwarz-Weiß Bismark II."]
[null,null,"SG Dannefeld"]
[null,null,"SG Dannefeld II."]
[null,null,"SG Eintracht Ebendorf"]
[null,null,"SG Eintracht Ebendorf II."]
[null,null,"SG Hydraulik Ballenstedt"]
[null,null,"SG Hydraulik Ballenstedt II."]
[null,null,"SG Hydraulik Ballenstedt III."]
[null,null,"SG Stahl Quedlinburg"]
[null,null,"SG Stahl Quedlinburg II."]
[null,null,"SG Traktor Gallin"]
[null,null,"SG Traktor Gallin II."]
[null,null,"Spg. Derenburg / Ilsenburg"]
[null,null,"Spg. Derenburg / Ilsenburg II."]
[null,null,"Spg. Goldbeck / Arneburg"]
[null,null,"Spg. Goldbeck / Arneburg II."]
[null,null,"Stendaler KC "]
[null,null,"Stendaler KC II."]
[null,null,"Stendaler KC III."]
[null,null,"SV 02 Heudeber"]
[null,null,"SV 90 Havelberg"]
[null,null,"SV 90 Havelberg II."]
[null,null,"SV 90 Köckte"]
[null,null,"SV 90 Köckte II."]
[null,null,"SV Aulosen"]
[null,null,"SV Aulosen II."]
[null,null,"SV Beendorf"]
[null,null,"SV Beendorf II."]
[null,null,"SV Binde"]
[null,null,"SV Binde II."]
[null,null,"SV Einheit Wittenberg"]
[null,null,"SV Einheit Wittenberg II."]
[null,null,"SV Hödingen"]
[null,null,"SV Hödingen II."]
[null,null,"SV Lok Blankenburg"]
[null,null,"SV Lok Blankenburg II."]
[null,null,"SV Lok Blankenburg III."]
[null,null,"TSV 05 Uchtdorf"]
[null,null,"TSV 05 Uchtdorf II."]
[null,null,"TSV Kunrau"]
[null,null,"TSV Kunrau II."]
[null,null,"TSV Tangermünde"]
[null,null,"TSV Tangermünde II."]
[null,null,"TuS Morsleben"]
[null,null,"TuS Morsleben II."]
[null,null,"VfB Born"]
[null,null,"VfB Born II."]
[null,null,"VfB Zahna 1921"]
[null,null,"VfB Zahna 1921 II."]