{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Spielbericht","import"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Spielbericht","index":0,"n_rows":41,"n_cols":36,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,6,25,9],[27,6,27,9],[26,1,26,3],[24,1,24,3],[26,4,27,4],[26,5,27,5],[24,5,25,5],[24,6,24,9],[26,6,26,9],[24,4,25,4],[17,9,17,13],[17,14,17,15],[20,2,20,6],[20,9,20,13],[20,14,20,15],[23,5,23,9],[23,1,23,4],[25,1,25,3],[26,16,27,16],[26,15,27,15],[26,14,27,14],[26,13,27,13],[26,12,27,12],[24,16,25,16],[24,15,25,15],[24,14,25,14],[24,13,25,13],[24,12,25,12],[18,14,18,15],[27,1,27,3],[20,0,21,1],[20,8,21,8],[24,0,25,0],[26,0,27,0],[4,0,4,16],[5,0,5,16],[34,6,34,9],[35,6,35,9],[32,6,32,9],[33,6,33,9],[34,1,34,3],[33,1,33,3],[32,1,32,3],[30,6,30,9],[31,6,31,9],[28,6,28,9],[29,6,29,9],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[21,14,21,15],[17,2,17,6],[19,14,19,15],[39,0,39,16],[40,0,40,16],[36,0,36,14],[38,0,38,16],[15,14,15,15],[16,14,16,15],[8,0,8,16],[9,0,9,2],[9,7,9,10],[10,13,10,15],[9,11,9,16],[10,0,10,2],[10,3,10,4],[9,4,9,5],[10,7,10,10],[12,0,12,1],[12,2,12,6],[12,9,12,13],[12,14,12,15],[13,0,13,1],[13,2,13,6],[13,9,13,13],[13,14,13,15],[14,0,14,1],[14,2,14,6],[14,9,14,13],[14,14,14,15],[35,1,35,3],[21,2,21,6],[21,9,21,13],[15,0,15,1],[15,2,15,6],[15,9,15,13],[16,0,16,1],[16,2,16,6],[16,9,16,13],[17,0,17,1],[18,0,19,1],[18,8,19,8],[18,2,18,6],[19,2,19,6],[19,9,19,13],[18,9,18,13],[24,11,25,11],[24,10,25,10],[26,11,27,11],[26,10,27,10]]}
[]
[]
[]
[]
["TTVMV – Mannschaftsspielformular",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ligen"]
["Bundessystem ( 2 Doppel, 8 Einzel)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Landesliga"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bezirksliga"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15<>\"\",IF(C16<>\"\",IF(C17<>\"\",IF(C18<>\"\",C18,C17),C16),C15),C15)","v":0},null,"Bezirksklasse"]
[{"$f":"IF(ISNA(VLOOKUP($D$11,import!R2:T10,3,FALSE)),\"Bitte Gastgeber auswählen\",VLOOKUP($D$11,import!R2:T10,3,FALSE))","v":"Bitte Gastgeber auswählen"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$11<>\"\",VLOOKUP(D11,Mannschaften[],2,FALSE),9)","v":9},{"$f":"IF(ISNA(VLOOKUP(R8,Table2[[Name]:[Spieler Nr.]],5,FALSE)),10,VLOOKUP(R8,Table2[[Name]:[Spieler Nr.]],5,FALSE))","v":10},"Kreisliga"]
["Staffel:",null,null,null,"Spiel-Nr.:",null,null," Herren/Jungen/Schüler",null,null,null," Damen/Mädchen/Schülerinnen",null,null,null,null,null,null,null,"1. Kreisklasse"]
["Gastgeber:",null,null,null,null,null,"Gast:",null,null,null,null,null,"Datum:",{"$f":"TODAY()","v":"2024-12-10"},null,null,null,null,null,"2. Kreisklasse"]
[]
[null,null,"Aufstellung Gastgeber",null,null,null,null,null,null,"Aufstellung Gast",null,null,null,null,null,null,null,null,null,"Einzel",null,null,null,null,null,null,null,null,"Doppel"]
[null,null,"Name, Vorname",null,null,null,null,"SBN",null,"Name, Vorname",null,null,null,null,"SBN",null,null,null,null,"Liga","Rang","QTTR","Name","A","Status","Mannschaft Nr.","Spieler Nr.",null,"Liga","Rang","QTTR","Name","A","Status","Mannschaft Nr.","Spieler Nr."]
[1,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,null,3]
[4,null,null,null,null,null,null,null,4]
["Dop-\npel 1",null,null,null,null,null,null,null,"Dop-\npel1"]
[]
["Dop- pel 2",null,null,null,null,null,null,null,"Dop- pel2"]
[]
[]
["Nr","Gastgeber",null,null,null,"Gast",null,null,null,null,"1.Satz","2.Satz","3.Satz","4.Satz","5.Satz","Sätze","Pkt."]
[1,{"$f":"IF(C19=\"\",\"\",C19)","v":""},null,null,"D1","D1",{"$f":"IF(J19=\"\",\"\",J19)","v":""},null,null,null,":",":",":",":",":",":",":"]
[null,"",null,null,null,null,{"$f":"IF(J20=\"\",\"\",J20)","v":""}]
[2,"",null,null,"D2","D2",{"$f":"IF(J21=\"\",\"\",J21)","v":""},null,null,null,":",":",":",":",":",":",":"]
[null,{"$f":"IF(C22=\"\",\"\",C22)","v":""},null,null,null,null,{"$f":"IF(J22=\"\",\"\",J22)","v":""}]
[3,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":""},null,null,1,2,{"$f":"IF($J$16=\"\",\"\",$J$16)","v":""},null,null,null,":",":",":",":",":",":",":"]
[4,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":""},null,null,2,1,{"$f":"IF($J$15=\"\",\"\",$J$15)","v":""},null,null,null,":",":",":",":",":",":",":"]
[5,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":""},null,null,3,4,{"$f":"IF($J$18=\"\",\"\",$J$18)","v":""},null,null,null,":",":",":",":",":",":",":"]
[6,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":""},null,null,4,3,{"$f":"IF($J$17=\"\",\"\",$J$17)","v":""},null,null,null,":",":",":",":",":",":",":"]
[7,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":""},null,null,1,1,{"$f":"IF($J$15=\"\",\"\",$J$15)","v":""},null,null,null,":",":",":",":",":",":",":"]
[8,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":""},null,null,2,2,{"$f":"IF($J$16=\"\",\"\",$J$16)","v":""},null,null,null,":",":",":",":",":",":",":"]
[9,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":""},null,null,3,3,{"$f":"IF($J$17=\"\",\"\",$J$17)","v":""},null,null,null,":",":",":",":",":",":",":"]
[10,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":""},null,null,4,4,{"$f":"IF($J$18=\"\",\"\",$J$18)","v":""},null,null,null,":",":",":",":",":",":",":"]
["Gesamt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",":"]
[]
["Ergebnis: Sieger mit ....... ...... Punkten...........................................................           unentschieden\nEinheitliche Spielkleidung      Gastgeber: Ja /Nein                     Gast: Ja /Nein "]
["Protest wurde eingelegt/nicht eingelegt  (siehe Rückseite)"]
["Unterschrift Gastgeber.................................           Unterschrift Gast.........................................."]

{"sheet":"import","index":1,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"TTSV Anklam, Herren"]
["Liga","Rang","QTTR","Name","A","Status","Mannschaft Nr.","Spieler Nr.",null,null,null,null,null,null,null,null,null,"Name","Nr.","Mannschaftszuordnung"]
[{"$f":"VLOOKUP(VALUE(G3),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.1",952,"Jonas, Theo",null,null,{"$f":"LEFT(B3,1)","v":"1"},{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B3,1)&RIGHT(B3,2),LEFT(B3,1)&RIGHT(B3,1))","v":"11"},null,null,null,null,null,null,null,null,null,"TTSV Anklam LL13",1,"Landesliga U13"]
[{"$f":"VLOOKUP(VALUE(G4),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.2",839,"Rogge, Frieda",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B4,1)&RIGHT(B4,2),LEFT(B4,1)&RIGHT(B4,1))","v":"12"},null,null,null,null,null,null,null,null,null,"TTSV Anklam LL19",2,"Landesliga U19"]
[{"$f":"VLOOKUP(VALUE(G5),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.3",828,"Hackbart, Mylo Liam",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B5,1)&RIGHT(B5,2),LEFT(B5,1)&RIGHT(B5,1))","v":"13"}]
[{"$f":"VLOOKUP(VALUE(G6),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.4","852*","Lorenzen, Vincent",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B6,1)&RIGHT(B6,2),LEFT(B6,1)&RIGHT(B6,1))","v":"14"}]
[{"$f":"VLOOKUP(VALUE(G7),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.5",null,"Marziniak, Max",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B7,1)&RIGHT(B7,2),LEFT(B7,1)&RIGHT(B7,1))","v":"15"}]
[{"$f":"VLOOKUP(VALUE(G8),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.6",764,"Hoth, Lotta",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B8,1)&RIGHT(B8,2),LEFT(B8,1)&RIGHT(B8,1))","v":"16"}]
[{"$f":"VLOOKUP(VALUE(G9),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.7",723,"Hansow, Lotta",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B9,1)&RIGHT(B9,2),LEFT(B9,1)&RIGHT(B9,1))","v":"17"}]
[{"$f":"VLOOKUP(VALUE(G10),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.8",null,"Ketelhut, Carlos",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B10,1)&RIGHT(B10,2),LEFT(B10,1)&RIGHT(B10,1))","v":"18"}]
[{"$f":"VLOOKUP(VALUE(G11),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.9",null,"Zahn, Matteo",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B11,1)&RIGHT(B11,2),LEFT(B11,1)&RIGHT(B11,1))","v":"19"}]
[{"$f":"VLOOKUP(VALUE(G12),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U13"},"1.10",null,"Batthauer, Lennart",null,null,"1",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B12,1)&RIGHT(B12,2),LEFT(B12,1)&RIGHT(B12,1))","v":"110"}]
[]
[]
[]
[{"$f":"VLOOKUP(VALUE(G16),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.1",null,"Stanislawczyk, Patryk","eA",null,{"$f":"LEFT(B16,1)+1","v":2},{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B16,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B16,1))","v":"21"}]
[{"$f":"VLOOKUP(VALUE(G17),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.2",null,"Koper, Lukasz","eA",null,{"$f":"LEFT(B17,1)+1","v":2},{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B17,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B17,1))","v":"22"}]
[{"$f":"VLOOKUP(VALUE(G18),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.3",null,"Kmiecik, Zuzanna","eA",null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B18,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B18,1))","v":"23"}]
[{"$f":"VLOOKUP(VALUE(G19),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.4",952,"Jonas, Theo",null,"NES",2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B19,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B19,1))","v":"24"}]
[{"$f":"VLOOKUP(VALUE(G20),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.5",868,"Harder, Cedric",null,null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B20,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B20,1))","v":"25"}]
[{"$f":"VLOOKUP(VALUE(G21),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.6",823,"Plamann, Kuno",null,null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B21,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B21,1))","v":"26"}]
[{"$f":"VLOOKUP(VALUE(G22),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.7","826*","Rittmeyer, Richard",null,null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B22,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B22,1))","v":"27"}]
[{"$f":"VLOOKUP(VALUE(G23),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.8","852*","Lorenzen, Vincent",null,"NES",2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B23,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B23,1))","v":"28"}]
[{"$f":"VLOOKUP(VALUE(G24),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.9",839,"Rogge, Frieda",null,"NES",2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B24,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B24,1))","v":"29"}]
[{"$f":"VLOOKUP(VALUE(G25),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.10",828,"Hackbart, Mylo Liam",null,"NES",2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B25,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B25,1))","v":"210"}]
[{"$f":"VLOOKUP(VALUE(G26),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.11",null,"Winter, Jamie",null,null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B26,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B26,1))","v":"211"}]
[{"$f":"VLOOKUP(VALUE(G27),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.12",null,"Gottschalk, Jan",null,null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B27,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B27,1))","v":"212"}]
[{"$f":"VLOOKUP(VALUE(G28),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.13",null,"Haß, Kenny",null,null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B28,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B28,1))","v":"213"}]
[{"$f":"VLOOKUP(VALUE(G29),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.14",null,"Marziniak, Max",null,"NES",2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B29,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B29,1))","v":"214"}]
[{"$f":"VLOOKUP(VALUE(G30),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.15",760,"Marquardt, Klara",null,null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B30,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B30,1))","v":"215"}]
[{"$f":"VLOOKUP(VALUE(G31),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.16",764,"Hoth, Lotta",null,"NES",2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B31,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B31,1))","v":"216"}]
[{"$f":"VLOOKUP(VALUE(G32),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.17",723,"Hansow, Lotta",null,"NES , Nachmeldung ab 29.11.2024",2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B32,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B32,1))","v":"217"}]
[{"$f":"VLOOKUP(VALUE(G33),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga U19"},"1.18",null,"Pauer, Jason",null,null,2,{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B33,2),Table2[[#This Row],[Mannschaft Nr.]]&RIGHT(B33,1))","v":"218"}]