{"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":49,"n_cols":36,"rows_kept":49,"cut":false,"hidden":false,"merged":[[39,1,39,3],[38,1,38,3],[37,1,37,3],[36,1,36,3],[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],[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],[47,0,47,16],[48,0,48,16],[42,6,42,9],[43,6,43,9],[40,6,40,9],[41,6,41,9],[43,1,43,3],[42,1,42,3],[41,1,41,3],[40,1,40,3],[44,0,44,14],[46,0,46,16],[4,0,4,16],[5,0,5,16],[38,6,38,9],[39,6,39,9],[36,6,36,9],[37,6,37,9],[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],[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],[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]]}
[]
[]
[]
[]
["TTVMV – Mannschaftsspielformular",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ligen"]
["Modifiziertes Werner- Scheffler- System ( 2 Doppel, 16 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(_xlfn.XLOOKUP($D$11,import!R3:$R$10,import!T3:T10)),\"Bitte Gastgeber auswählen\",_xlfn.XLOOKUP($D$11,import!R3:$R$10,import!T3:T10))","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-11-20"},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-\npel2"]
[]
["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,":",":",":",":",":",":",":"]
[11,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":""},null,null,3,1,{"$f":"IF($J$15=\"\",\"\",$J$15)","v":""},null,null,null,":",":",":",":",":",":",":"]
[12,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":""},null,null,1,3,{"$f":"IF($J$17=\"\",\"\",$J$17)","v":""},null,null,null,":",":",":",":",":",":",":"]
[13,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":""},null,null,2,4,{"$f":"IF($J$18=\"\",\"\",$J$18)","v":""},null,null,null,":",":",":",":",":",":",":"]
[14,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":""},null,null,4,2,{"$f":"IF($J$16=\"\",\"\",$J$16)","v":""},null,null,null,":",":",":",":",":",":",":"]
[15,{"$f":"IF($C$15=\"\",\"\",$C$15)","v":""},null,null,1,4,{"$f":"IF($J$18=\"\",\"\",$J$18)","v":""},null,null,null,":",":",":",":",":",":",":"]
[16,{"$f":"IF($C$18=\"\",\"\",$C$18)","v":""},null,null,4,1,{"$f":"IF($J$15=\"\",\"\",$J$15)","v":""},null,null,null,":",":",":",":",":",":",":"]
[17,{"$f":"IF($C$16=\"\",\"\",$C$16)","v":""},null,null,2,3,{"$f":"IF($J$17=\"\",\"\",$J$17)","v":""},null,null,null,":",":",":",":",":",":",":"]
[18,{"$f":"IF($C$17=\"\",\"\",$C$17)","v":""},null,null,3,2,{"$f":"IF($J$16=\"\",\"\",$J$16)","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":69,"n_cols":20,"rows_kept":69,"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"},"1.1",1871,"Pozniak, Darek","eA",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 I",1,"Landesliga"]
[{"$f":"VLOOKUP(VALUE(G4),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga"},"1.2",1732,"Zukowski, Janusz","eA",null,{"$f":"LEFT(B4,1)","v":"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 II",2,"Bezirksliga"]
[{"$f":"VLOOKUP(VALUE(G5),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga"},"1.3",1664,"Szymaszek, Kazimierz","eA",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"},null,null,null,null,null,null,null,null,null,"TTSV Anklam III",3,"Bezirksklasse"]
[{"$f":"VLOOKUP(VALUE(G6),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Landesliga"},"1.4",null,"Zdzieblowski, Lukasz","eA",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"},null,null,null,null,null,null,null,null,null,"TTSV Anklam IV",4,"Bezirksklasse"]
[{"$f":"VLOOKUP(VALUE(G7),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B7,1)&RIGHT(B7,2),LEFT(B7,1)&RIGHT(B7,1))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"TTSV Anklam V",5,"Kreisliga"]
[{"$f":"VLOOKUP(VALUE(G8),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksliga"},"2.1",null,"Stanislawczyk, Patryk","eA","SBE","2",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B8,1)&RIGHT(B8,2),LEFT(B8,1)&RIGHT(B8,1))","v":"21"},null,null,null,null,null,null,null,null,null,"TTSV Anklam VI",6,"1. Kreisklasse"]
[{"$f":"VLOOKUP(VALUE(G9),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksliga"},"2.2",null,"Koper, Lukasz","eA","SBE","2",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B9,1)&RIGHT(B9,2),LEFT(B9,1)&RIGHT(B9,1))","v":"22"},null,null,null,null,null,null,null,null,null,"TTSV Anklam VII",7,"1. Kreisklasse"]
[{"$f":"VLOOKUP(VALUE(G10),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksliga"},"2.3",null,"Kmiecik, Zuzanna","eA","SBE","2",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B10,1)&RIGHT(B10,2),LEFT(B10,1)&RIGHT(B10,1))","v":"23"},null,null,null,null,null,null,null,null,null,"TTSV Anklam VIII",8,"2. Kreisklasse"]
[{"$f":"VLOOKUP(VALUE(G11),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksliga"},"2.4",1620,"Biesel, Franz-Josef",null,null,"2",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B11,1)&RIGHT(B11,2),LEFT(B11,1)&RIGHT(B11,1))","v":"24"}]
[{"$f":"VLOOKUP(VALUE(G12),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B12,1)&RIGHT(B12,2),LEFT(B12,1)&RIGHT(B12,1))","v":{"$error":"#VALUE!"}}]
[{"$f":"VLOOKUP(VALUE(G13),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"3.1",1588,"Rouarch, Pascal",null,null,"3",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B13,1)&RIGHT(B13,2),LEFT(B13,1)&RIGHT(B13,1))","v":"31"}]
[{"$f":"VLOOKUP(VALUE(G14),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"3.2",1583,"Segebrecht, Jens",null,"RES","3",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B14,1)&RIGHT(B14,2),LEFT(B14,1)&RIGHT(B14,1))","v":"32"}]
[{"$f":"VLOOKUP(VALUE(G15),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"3.3",1558,"Mögenburg, Maik",null,null,"3",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B15,1)&RIGHT(B15,2),LEFT(B15,1)&RIGHT(B15,1))","v":"33"}]
[{"$f":"VLOOKUP(VALUE(G16),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"3.4",1533,"Rudnick, Mattes",null,null,"3",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B16,1)&RIGHT(B16,2),LEFT(B16,1)&RIGHT(B16,1))","v":"34"}]
[{"$f":"VLOOKUP(VALUE(G17),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"3.5",1535,"Brünning, Marcus",null,null,"3",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B17,1)&RIGHT(B17,2),LEFT(B17,1)&RIGHT(B17,1))","v":"35"}]
[{"$f":"VLOOKUP(VALUE(G18),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B18,1)&RIGHT(B18,2),LEFT(B18,1)&RIGHT(B18,1))","v":{"$error":"#VALUE!"}}]
[{"$f":"VLOOKUP(VALUE(G19),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"4.1",1512,"Köngerski-Bluhm, Mario",null,null,"4",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B19,1)&RIGHT(B19,2),LEFT(B19,1)&RIGHT(B19,1))","v":"41"}]
[{"$f":"VLOOKUP(VALUE(G20),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"4.2",1468,"Pohl, Niklas",null,null,"4",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B20,1)&RIGHT(B20,2),LEFT(B20,1)&RIGHT(B20,1))","v":"42"}]
[{"$f":"VLOOKUP(VALUE(G21),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"4.3","1464*","Franke, Alexander",null,"RES","4",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B21,1)&RIGHT(B21,2),LEFT(B21,1)&RIGHT(B21,1))","v":"43"}]
[{"$f":"VLOOKUP(VALUE(G22),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"4.4",1457,"Wolff, Tobias",null,null,"4",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B22,1)&RIGHT(B22,2),LEFT(B22,1)&RIGHT(B22,1))","v":"44"}]
[{"$f":"VLOOKUP(VALUE(G23),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Bezirksklasse"},"4.5",1423,"Storch, Jörn",null,null,"4",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B23,1)&RIGHT(B23,2),LEFT(B23,1)&RIGHT(B23,1))","v":"45"}]
[{"$f":"VLOOKUP(VALUE(G24),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B24,1)&RIGHT(B24,2),LEFT(B24,1)&RIGHT(B24,1))","v":{"$error":"#VALUE!"}}]
[{"$f":"VLOOKUP(VALUE(G25),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Kreisliga"},"5.1",1462,"Salden, Peter",null,null,"5",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B25,1)&RIGHT(B25,2),LEFT(B25,1)&RIGHT(B25,1))","v":"51"}]
[{"$f":"VLOOKUP(VALUE(G26),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Kreisliga"},"5.2",1468,"Hinz, Matthias",null,null,"5",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B26,1)&RIGHT(B26,2),LEFT(B26,1)&RIGHT(B26,1))","v":"52"}]
[{"$f":"VLOOKUP(VALUE(G27),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Kreisliga"},"5.3",1463,"Lück, Andreas",null,null,"5",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B27,1)&RIGHT(B27,2),LEFT(B27,1)&RIGHT(B27,1))","v":"53"}]
[{"$f":"VLOOKUP(VALUE(G28),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"Kreisliga"},"5.4",1426,"Michelson, Dietmar",null,null,"5",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B28,1)&RIGHT(B28,2),LEFT(B28,1)&RIGHT(B28,1))","v":"54"}]
[{"$f":"VLOOKUP(VALUE(G29),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B29,1)&RIGHT(B29,2),LEFT(B29,1)&RIGHT(B29,1))","v":{"$error":"#VALUE!"}}]
[{"$f":"VLOOKUP(VALUE(G30),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"6.1",1465,"Werner, Martin",null,null,"6",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B30,1)&RIGHT(B30,2),LEFT(B30,1)&RIGHT(B30,1))","v":"61"}]
[{"$f":"VLOOKUP(VALUE(G31),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"6.2",1386,"Braun, Jessica",null,null,"6",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B31,1)&RIGHT(B31,2),LEFT(B31,1)&RIGHT(B31,1))","v":"62"}]
[{"$f":"VLOOKUP(VALUE(G32),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"6.3",1402,"Beister, Andreas",null,null,"6",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B32,1)&RIGHT(B32,2),LEFT(B32,1)&RIGHT(B32,1))","v":"63"}]
[{"$f":"VLOOKUP(VALUE(G33),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"6.4",1363,"Luther, Tino",null,null,"6",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B33,1)&RIGHT(B33,2),LEFT(B33,1)&RIGHT(B33,1))","v":"64"}]
[{"$f":"VLOOKUP(VALUE(G34),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B34,1)&RIGHT(B34,2),LEFT(B34,1)&RIGHT(B34,1))","v":{"$error":"#VALUE!"}}]
[{"$f":"VLOOKUP(VALUE(G35),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"7.1",1406,"Kober, Carlo",null,"RES","7",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B35,1)&RIGHT(B35,2),LEFT(B35,1)&RIGHT(B35,1))","v":"71"}]
[{"$f":"VLOOKUP(VALUE(G36),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"7.2",1386,"Hippmann, Nils",null,null,"7",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B36,1)&RIGHT(B36,2),LEFT(B36,1)&RIGHT(B36,1))","v":"72"}]
[{"$f":"VLOOKUP(VALUE(G37),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"7.3",1349,"Kirsch, Beate",null,null,"7",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B37,1)&RIGHT(B37,2),LEFT(B37,1)&RIGHT(B37,1))","v":"73"}]
[{"$f":"VLOOKUP(VALUE(G38),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"7.4",1354,"Fischer, Manfred",null,null,"7",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B38,1)&RIGHT(B38,2),LEFT(B38,1)&RIGHT(B38,1))","v":"74"}]
[{"$f":"VLOOKUP(VALUE(G39),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"7.5",1331,"Hensch, Klaus",null,"RES","7",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B39,1)&RIGHT(B39,2),LEFT(B39,1)&RIGHT(B39,1))","v":"75"}]
[{"$f":"VLOOKUP(VALUE(G40),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"1. Kreisklasse"},"7.6",1258,"Schwirkschlies, Justin",null,null,"7",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B40,1)&RIGHT(B40,2),LEFT(B40,1)&RIGHT(B40,1))","v":"76"}]
[{"$f":"VLOOKUP(VALUE(G41),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B41,1)&RIGHT(B41,2),LEFT(B41,1)&RIGHT(B41,1))","v":{"$error":"#VALUE!"}}]
[{"$f":"VLOOKUP(VALUE(G42),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.1",1266,"Stanschus, Jürgen",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B42,1)&RIGHT(B42,2),LEFT(B42,1)&RIGHT(B42,1))","v":"81"}]
[{"$f":"VLOOKUP(VALUE(G43),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.2",1246,"Zimmermann, Norbert",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B43,1)&RIGHT(B43,2),LEFT(B43,1)&RIGHT(B43,1))","v":"82"}]
[{"$f":"VLOOKUP(VALUE(G44),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.3",1235,"Schmitwilken, Marcel",null,"Nachmeldung ab 26.08.2024","8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B44,1)&RIGHT(B44,2),LEFT(B44,1)&RIGHT(B44,1))","v":"83"}]
[{"$f":"VLOOKUP(VALUE(G45),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.4",1229,"Möller, Danilo",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B45,1)&RIGHT(B45,2),LEFT(B45,1)&RIGHT(B45,1))","v":"84"}]
[{"$f":"VLOOKUP(VALUE(G46),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.5",1217,"Putzar, Ronny",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B46,1)&RIGHT(B46,2),LEFT(B46,1)&RIGHT(B46,1))","v":"85"}]
[{"$f":"VLOOKUP(VALUE(G47),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.6",1206,"Stelter, Manfred",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B47,1)&RIGHT(B47,2),LEFT(B47,1)&RIGHT(B47,1))","v":"86"}]
[{"$f":"VLOOKUP(VALUE(G48),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.7",1219,"Stasun, Dieter",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B48,1)&RIGHT(B48,2),LEFT(B48,1)&RIGHT(B48,1))","v":"87"}]
[{"$f":"VLOOKUP(VALUE(G49),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.8",1222,"Sabin, Dirk",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B49,1)&RIGHT(B49,2),LEFT(B49,1)&RIGHT(B49,1))","v":"88"}]
[{"$f":"VLOOKUP(VALUE(G50),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.9",1217,"Schwark, Georg",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B50,1)&RIGHT(B50,2),LEFT(B50,1)&RIGHT(B50,1))","v":"89"}]
[{"$f":"VLOOKUP(VALUE(G51),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.10",1144,"Reckling, Moritz",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B51,1)&RIGHT(B51,2),LEFT(B51,1)&RIGHT(B51,1))","v":"810"}]
[{"$f":"VLOOKUP(VALUE(G52),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.11",1158,"Zimmermann, Lisa",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B52,1)&RIGHT(B52,2),LEFT(B52,1)&RIGHT(B52,1))","v":"811"}]
[{"$f":"VLOOKUP(VALUE(G53),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.12",null,"Anke, Lars",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B53,1)&RIGHT(B53,2),LEFT(B53,1)&RIGHT(B53,1))","v":"812"}]
[{"$f":"VLOOKUP(VALUE(G54),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.13",1128,"Voß, Michael",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B54,1)&RIGHT(B54,2),LEFT(B54,1)&RIGHT(B54,1))","v":"813"}]
[{"$f":"VLOOKUP(VALUE(G55),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.14",1108,"Schmidt, Dieter",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B55,1)&RIGHT(B55,2),LEFT(B55,1)&RIGHT(B55,1))","v":"814"}]
[{"$f":"VLOOKUP(VALUE(G56),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.15",1090,"Hippmann, Bernd",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B56,1)&RIGHT(B56,2),LEFT(B56,1)&RIGHT(B56,1))","v":"815"}]
[{"$f":"VLOOKUP(VALUE(G57),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.16","1095*","Krenz, Noah",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B57,1)&RIGHT(B57,2),LEFT(B57,1)&RIGHT(B57,1))","v":"816"}]
[{"$f":"VLOOKUP(VALUE(G58),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.17","1104*","Herrmann, Petra",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B58,1)&RIGHT(B58,2),LEFT(B58,1)&RIGHT(B58,1))","v":"817"}]
[{"$f":"VLOOKUP(VALUE(G59),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.18","1010*","Ollesch, Klaus",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B59,1)&RIGHT(B59,2),LEFT(B59,1)&RIGHT(B59,1))","v":"818"}]
[{"$f":"VLOOKUP(VALUE(G60),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.19",null,"Bierwerth, Frank",null,"Nachmeldung ab 26.08.2024","8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B60,1)&RIGHT(B60,2),LEFT(B60,1)&RIGHT(B60,1))","v":"819"}]
[{"$f":"VLOOKUP(VALUE(G61),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.20",868,"Harder, Cedric",null,"SBE","8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B61,1)&RIGHT(B61,2),LEFT(B61,1)&RIGHT(B61,1))","v":"820"}]
[{"$f":"VLOOKUP(VALUE(G62),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.21",null,"Winter, Jamie",null,"SBE","8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B62,1)&RIGHT(B62,2),LEFT(B62,1)&RIGHT(B62,1))","v":"821"}]
[{"$f":"VLOOKUP(VALUE(G63),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.22",null,"Rittmeyer, Björn",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B63,1)&RIGHT(B63,2),LEFT(B63,1)&RIGHT(B63,1))","v":"822"}]
[{"$f":"VLOOKUP(VALUE(G64),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.23",null,"Beck, Siegbert",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B64,1)&RIGHT(B64,2),LEFT(B64,1)&RIGHT(B64,1))","v":"823"}]
[{"$f":"VLOOKUP(VALUE(G65),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.24",null,"Wolff, Hartmut",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B65,1)&RIGHT(B65,2),LEFT(B65,1)&RIGHT(B65,1))","v":"824"}]
[{"$f":"VLOOKUP(VALUE(G66),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.25",905,"Heiden, Florian",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B66,1)&RIGHT(B66,2),LEFT(B66,1)&RIGHT(B66,1))","v":"825"}]
[{"$f":"VLOOKUP(VALUE(G67),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.26",null,"Krüger, Harold",null,"RES","8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B67,1)&RIGHT(B67,2),LEFT(B67,1)&RIGHT(B67,1))","v":"826"}]
[{"$f":"VLOOKUP(VALUE(G68),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.27",825,"Basner, Jenny",null,null,{"$f":"LEFT(B68,1)","v":"8"},{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B68,1)&RIGHT(B68,2),LEFT(B68,1)&RIGHT(B68,1))","v":"827"}]
[{"$f":"VLOOKUP(VALUE(G69),Mannschaften[[Nr.]:[Mannschaftszuordnung]],2,FALSE)","v":"2. Kreisklasse"},"8.28",833,"Beck, Angela",null,null,"8",{"$f":"IF(FIND(\".\",RIGHT(Table2[[#This Row],[Rang]],3))<2,LEFT(B69,1)&RIGHT(B69,2),LEFT(B69,1)&RIGHT(B69,1))","v":"828"}]