{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Vereinsmitglieder","Anmeldungen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Vereinsmitglieder","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,4,1,8],[2,4,2,8],[1,1,1,3],[2,1,2,3],[5,11,54,11],[1,11,2,11]]}
[]
[null,"Verein",null,null,"BC Shuttle",null,null,null,null,null,null,"ACHTUNG : Wenn du Makros NICHT aktivierst, wird die zweite Seite NICHT gefüllt!"]
[null,"Juniorenverantwortlicher",null,null,"Tim Trainer"]
[]
[null,null,"Vorname","Nachname","Geschlecht","Geburtstag","Kategorie","Nimmt am Turnier teil (x)","Bemerkungen",null,null,"Benutzungsanleitung"]
[null,1,null,null,null,null,{"$f":"IF(AND(OR(UPPER(E6)=\"H\",UPPER(E6)=\"D\"),YEAR(F6)+12>YEAR(NOW())),UPPER(E6)&\"E U\"&MAX(9,YEAR(NOW())-YEAR(F6)+1),\"\")","v":""},null,null,null,null,"\n1. Trage in Zelle E2 einmalig den Namen deines Vereins ein\n\n2. Trage in Zelle E3 einmalig die verantwortliche Person ein\n\n3. Trage in die Tabelle EINMALIG alle Junior(inn)en von deinem Verein ein,\n    die vom Jahrgang her an den BVN Event Tagen mitspielen dürfen:\n     - Vorname\n     - Nachname\n     - Geschlecht (H/D)\n     - Geburtsdatum\n     - Kategorie ... füllt sich automatisch, wenn alle Daten korrekt sind\n\n4. Vor jedem Turnier müssen dann nur noch die Kreuzchen in der\n    Spalte H gesetzt werden\n     - X ......... nimmt am Turnier teil --> Zeile wird grün\n     - (leer) ... nimmt NICHT am Turnier teil\n\n5. Fallst du dem Turnierleiter weitere Bemerkungen zukommen lassen\n    willst (nur Turnier, kein Essen, ...), dann bitte in der Spalte I\n\n6. Kontrolliere die Anmeldungen in der zweiten Tabelle (\"Anmeldungen\"),\n    wohin die relevanten Daten automatisch kopiert werden\n\n7. Die Liste in der zweiten Tabelle (\"Anmeldungen“) kann anschliessend\n    kopiert und dem Turnierleiter geschickt werden"]
[null,2,null,null,null,null,{"$f":"IF(AND(OR(UPPER(E7)=\"H\",UPPER(E7)=\"D\"),YEAR(F7)+12>YEAR(NOW())),UPPER(E7)&\"E U\"&MAX(9,YEAR(NOW())-YEAR(F7)+1),\"\")","v":""}]
[null,3,null,null,null,null,""]
[null,4,null,null,null,null,""]
[null,5,null,null,null,null,""]
[null,6,null,null,null,null,""]
[null,7,null,null,null,null,""]
[null,8,null,null,null,null,""]
[null,9,null,null,null,null,""]
[null,10,null,null,null,null,""]
[null,11,null,null,null,null,""]
[null,12,null,null,null,null,""]
[null,13,null,null,null,null,""]
[null,14,null,null,null,null,""]
[null,15,null,null,null,null,""]
[null,16,null,null,null,null,""]
[null,17,null,null,null,null,""]
[null,18,null,null,null,null,""]
[null,19,null,null,null,null,""]
[null,20,null,null,null,null,""]
[null,21,"Martin","Muster","H","2018-07-06","HE U9","x","Beispiel-Zeile"]
[null,22,"Berta","Beispiel","D","2019-08-07","DE U9","x","Beispiel-Zeile"]
[null,23,null,null,null,null,""]
[null,24,null,null,null,null,""]
[null,25,null,null,null,null,""]
[null,26,null,null,null,null,""]
[null,27,null,null,null,null,""]
[null,28,null,null,null,null,""]
[null,29,null,null,null,null,""]
[null,30,null,null,null,null,""]
[null,31,null,null,null,null,""]
[null,32,null,null,null,null,""]
[null,33,null,null,null,null,""]
[null,34,null,null,null,null,""]
[null,35,null,null,null,null,""]
[null,36,null,null,null,null,{"$f":"IF(AND(OR(UPPER(E41)=\"H\",UPPER(E41)=\"D\"),LEN(F41)>0),UPPER(E41)&\"E U\"&YEAR(NOW())-YEAR(F41),\"\")","v":""}]
[null,37,null,null,null,null,""]
[null,38,null,null,null,null,""]
[null,39,null,null,null,null,""]
[null,40,null,null,null,null,""]
[null,41,null,null,null,null,""]
[null,42,null,null,null,null,""]
[null,43,null,null,null,null,""]
[null,44,null,null,null,null,""]
[null,45,null,null,null,null,""]
[null,46,null,null,null,null,""]
[null,47,null,null,null,null,""]
[null,48,null,null,null,null,""]
[null,49,null,null,null,null,""]
[null,50,null,null,null,null,""]

{"sheet":"Anmeldungen","index":1,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3],[1,4,1,8],[2,4,2,8]]}
[]
[null,"Verein",null,null,{"$f":"Vereinsmitglieder!E2","v":"BC Shuttle"}]
[null,"Juniorenverantwortlicher",null,null,{"$f":"Vereinsmitglieder!E3","v":"Tim Trainer"}]
[]
[null,null,{"$f":"Vereinsmitglieder!C5","v":"Vorname"},{"$f":"Vereinsmitglieder!D5","v":"Nachname"},{"$f":"Vereinsmitglieder!E5","v":"Geschlecht"},{"$f":"Vereinsmitglieder!F5","v":"Geburtstag"},"Kategorie",{"$f":"Vereinsmitglieder!H5","v":"Nimmt am Turnier teil (x)"},{"$f":"Vereinsmitglieder!I5","v":"Bemerkungen"}]
[null,1,"Martin","Muster","H","2018-07-06",{"$f":"IF(AND(OR(UPPER(E6)=\"H\",UPPER(E6)=\"D\"),YEAR(F6)+12>YEAR(NOW())),UPPER(E6)&\"E U\"&MAX(9,YEAR(NOW())-YEAR(F6)+1),\"\")","v":"HE U9"},"x","Beispiel-Zeile"]
[null,2,"Berta","Beispiel","D","2019-08-07","DE U9","x","Beispiel-Zeile"]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]