{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Anleitung","Vereinsanmeldung","Personenerfassung","Gruppenübersicht","Auswahlfelder","Altersstufe","Hilfsliste_Gruppen"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Anleitung","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,1,11,7],[13,1,14,7]]}
[]
[]
[null,null,null,"Verband"]
[null,null,null,"der Sportschützen Zürich"]
[null,null,null,"und Umgebung"]
[]
[]
["Anleitung Anmeldung Verbandsschiessen"]
[]
[]
["1)","Datei zuerst öffnen und abspeichern, sofern noch nicht lokal gespeichert. Die Sicherheitswarnung (gelb) \"Inhalt aktivieren\" (dies ist für die automatischen Funktionen zwingend notwendig) bestätigen."]
[]
["2)","Beim Erfassen Daten nicht mit Drag&Drop verschieben!"]
[null,"(Ansonsten funktioniert es nicht mehr - falls irrtümlich doch gemacht, mit \"Rückgänig\" wieder richtig stellen.)"]
[]
["3)","Vereinsanmeldung ausfüllen"]
[null,"° bei Teilnahme am Gruppenwettkampf; Anzahl Gruppen eingeben"]
[null,"° anschliessend pro Gruppe einen Namen erfassen"]
[]
["4)","Schützen inkl. Lizenz-Nr. und Stellung in Register Personenerfassung ausfüllen"]
[null,"° pro Schütze Gruppenzuteilung machen (1,2,3,4 oder 5)"]
[null,"° wenn alle Schützen erfass sind, mit Button alphabetisch sortieren lassen"]
[null,"  (wenn ein Schütze nachträglich ergänzt wird nochmals sortieren)"]
[]
["5)","Datei abspeichern und als Excel-Datei (nicht PDF) per Mail an SSGW schicken"]
[]
["6)","Falls gewünscht, kann mit Button auf Deckblatt alles ausgedruckt werden"]
[]
[]
["Bei Fragen oder Problemen bitte melden"]
[]
["Michael Glaus, SSG Wallisellen"]
["michael.glaus@ssgw.ch"]

{"sheet":"Vereinsanmeldung","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[23,2,23,6],[27,2,27,3],[27,5,27,6],[18,2,18,5],[21,2,21,5],[25,2,25,5],[35,2,35,6],[37,2,37,6],[39,2,39,6],[41,2,41,6],[43,2,43,6]]}
[]
[]
[]
[]
[]
[]
["Verband"]
["der Sportschützen Zürich"]
["und Umgebung"]
[]
[]
[]
["VERBANDSSCHIESSEN"]
["Vereins-Anmeldung",null,null,null,null,null,2025]
[]
[]
[]
[]
["Name des Vereins:"]
[]
[]
["Vereins-Funktionär:"]
[]
["Adresse:"]
[]
["Mail:"]
[]
["Telefon","tagsüber:",null,null,"abends:"]
[]
[]
[]
[]
["Anzahl Gruppen:"]
[]
[]
["Name Gruppe    1:"]
[]
["Name Gruppe    2:"]
[]
["Name Gruppe    3:"]
[]
["Name Gruppe    4:"]
[]
["Name Gruppe    5:"]

{"sheet":"Personenerfassung","index":2,"n_rows":39,"n_cols":29,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,4,0,8],[2,7,3,7],[2,5,3,5],[2,0,3,0],[2,1,3,1],[2,3,3,3],[2,4,3,4],[2,6,3,6]]}
["Erfassung Schützen von:",null,null,null,{"$f":"IF(Vereinsanmeldung!C19=\"\",\"\",Vereinsanmeldung!C19)","v":""}]
[]
["Nr.","Grp-Nr.",null,"Lizenznummer","Name","Vorname","Jg","V/J","frei"]
[null,null,null,null,null,null,null,null,"aufg.",null,null,null,null,null,1,2,3,4,5,1,2,3,4,5,1,2,3,4,5]
[0]
[{"$f":"A5+1","v":1},null,{"$f":"SUM(Y6:AC6)","v":0},null,null,null,null,{"$f":"VLOOKUP(G6,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,{"$f":"IF(OR(M6>0,D6>0),\"\",\"Lizenznummer fehlt !!!\")","v":""},{"$f":"IF(OR(M6>0,I6>0),\"\",\"Angabe Stellung fehlt !!!\")","v":""},{"$f":"IF(E6>\"\",0,1)","v":1},{"$f":"B6-ROW()/100","v":-0.06},{"$f":"IF(AND(N6<1,N6>0),N6,\"\")","v":""},{"$f":"IF(AND(N6<2,N6>1),N6,\"\")","v":""},{"$f":"IF(AND(N6<3,N6>2),N6,\"\")","v":""},{"$f":"IF(AND(N6<4,N6>3),N6,\"\")","v":""},{"$f":"IF(AND(N6<5,N6>4),N6,\"\")","v":""},{"$f":"IF(O6=\"\",\"\",RANK(O6,$O$6:$O$35))","v":""},{"$f":"IF(P6=\"\",\"\",RANK(P6,$P$6:$P$35))","v":""},{"$f":"IF(Q6=\"\",\"\",RANK(Q6,$Q$5:$Q$34))","v":""},{"$f":"IF(R6=\"\",\"\",RANK(R6,$R$5:$R$34))","v":""},{"$f":"IF(S6=\"\",\"\",RANK(S6,$S$5:$S$34))","v":""},{"$f":"IF(T6=\"\",\"\",T6/10+1)","v":""},{"$f":"IF(U6=\"\",\"\",U6/10+2)","v":""},{"$f":"IF(V6=\"\",\"\",V6/10+3)","v":""},{"$f":"IF(W6=\"\",\"\",W6/10+4)","v":""},{"$f":"IF(X6=\"\",\"\",X6/10+5)","v":""}]
[2,null,0,null,null,null,null,{"$f":"VLOOKUP(G7,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-7.0000000000000007E-2,"","","","","","","","","","","","","","",""]
[3,null,0,null,null,null,null,{"$f":"VLOOKUP(G8,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.08,"","","","","","","","","","","","","","",""]
[4,null,0,null,null,null,null,{"$f":"VLOOKUP(G9,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.09,"","","","","","","","","","","","","","",""]
[5,null,0,null,null,null,null,{"$f":"VLOOKUP(G10,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.1,"","","","","","","","","","","","","","",""]
[6,null,0,null,null,null,null,{"$f":"VLOOKUP(G11,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.11,"","","","","","","","","","","","","","",""]
[7,null,0,null,null,null,null,{"$f":"VLOOKUP(G12,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.12,"","","","","","","","","","","","","","",""]
[8,null,0,null,null,null,null,{"$f":"VLOOKUP(G13,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.13,"","","","","","","","","","","","","","",""]
[9,null,0,null,null,null,null,{"$f":"VLOOKUP(G14,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.14000000000000001,"","","","","","","","","","","","","","",""]
[10,null,0,null,null,null,null,{"$f":"VLOOKUP(G15,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.15,"","","","","","","","","","","","","","",""]
[11,null,0,null,null,null,null,{"$f":"VLOOKUP(G16,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.16,"","","","","","","","","","","","","","",""]
[12,null,0,null,null,null,null,{"$f":"VLOOKUP(G17,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.17,"","","","","","","","","","","","","","",""]
[13,null,0,null,null,null,null,{"$f":"VLOOKUP(G18,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.18,"","","","","","","","","","","","","","",""]
[14,null,0,null,null,null,null,{"$f":"VLOOKUP(G19,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.19,"","","","","","","","","","","","","","",""]
[15,null,0,null,null,null,null,{"$f":"VLOOKUP(G20,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.2,"","","","","","","","","","","","","","",""]
[16,null,0,null,null,null,null,{"$f":"VLOOKUP(G21,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.21,"","","","","","","","","","","","","","",""]
[17,null,0,null,null,null,null,{"$f":"VLOOKUP(G22,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.22,"","","","","","","","","","","","","","",""]
[18,null,0,null,null,null,null,{"$f":"VLOOKUP(G23,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.23,"","","","","","","","","","","","","","",""]
[19,null,0,null,null,null,null,{"$f":"VLOOKUP(G24,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.24,"","","","","","","","","","","","","","",""]
[20,null,0,null,null,null,null,{"$f":"VLOOKUP(G25,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.25,"","","","","","","","","","","","","","",""]
[21,null,0,null,null,null,null,{"$f":"VLOOKUP(G26,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.26,"","","","","","","","","","","","","","",""]
[22,null,0,null,null,null,null,{"$f":"VLOOKUP(G27,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.27,"","","","","","","","","","","","","","",""]
[23,null,0,null,null,null,null,{"$f":"VLOOKUP(G28,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.28000000000000003,"","","","","","","","","","","","","","",""]
[24,null,null,null,null,null,null,{"$f":"VLOOKUP(G29,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.28999999999999998,"","","","","","","","","","","","","","",""]
[25,null,{"$f":"SUM(Y30:AC30)","v":0},null,null,null,null,{"$f":"VLOOKUP(G30,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.3,"","","","","","","","","","","","","","",""]
[26,null,0,null,null,null,null,{"$f":"VLOOKUP(G31,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.31,"","","","","","","","","","","","","","",""]
[27,null,0,null,null,null,null,{"$f":"VLOOKUP(G32,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.32,"","","","","","","","","","","","","","",""]
[28,null,0,null,null,null,null,{"$f":"VLOOKUP(G33,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.33,"","","","","","","","","","","","","","",""]
[29,null,0,null,null,null,null,{"$f":"VLOOKUP(G34,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.34,"","","","","","","","","","","","","","",""]
[30,null,0,null,null,null,null,{"$f":"VLOOKUP(G35,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.35,"","","","","","","","","","","","","","",""]
[31,null,0,null,null,null,null,{"$f":"VLOOKUP(G36,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.36,"","","","","","","","","","","","","","",""]
[32,null,0,null,null,null,null,{"$f":"VLOOKUP(G37,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.37,"","","","","","","","","","","","","","",""]
[33,null,0,null,null,null,null,{"$f":"VLOOKUP(G38,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.38,"","","","","","","","","","","","","","",""]
[34,null,0,null,null,null,null,{"$f":"VLOOKUP(G39,Altersstufe!$E$6:$F$94,2,FALSE)","v":" "},null,null,"","",1,-0.39,"","","","","","","","","","","","","","",""]

{"sheet":"Gruppenübersicht","index":3,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[41,4,41,5],[3,3,3,5],[8,4,8,5],[17,4,17,5],[25,4,25,5],[33,4,33,5]]}
[null,null,"Verband"]
[null,null,"der Sportschützenvereine Zürich"]
[null,null,"und Umgebung"]
[null,null,null,{"$f":"IF(Vereinsanmeldung!C19>0,Vereinsanmeldung!C19,\"\")","v":""}]
[]
["Verbandsschiessen"]
["Anmeldung zum Gruppenwettkampf"]
[]
["Gruppe:",null,1,"Gruppenname: ",{"$f":"IF(Vereinsanmeldung!C36>0,Vereinsanmeldung!C36,\"\")","v":""}]
[]
[1,null,{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!B9)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!C9)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!D9)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!E9)","v":""}]
[2,null,{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!B10)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!C10)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!D10)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!E10)","v":""}]
[3,null,{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!B11)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!C11)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!D11)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!E11)","v":""}]
[4,null,{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!B12)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!C12)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!D12)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!E12)","v":""}]
[5,null,{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!B13)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!C13)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!D13)","v":""},{"$f":"IF($E$9=\"\",\"\",Hilfsliste_Gruppen!E13)","v":""}]
[]
[]
["Gruppe:",null,2,"Gruppenname: ",{"$f":"IF(Vereinsanmeldung!C38>0,Vereinsanmeldung!C38,\"\")","v":""}]
[]
[1,null,{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!G9)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!H9)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!I9)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!J9)","v":""}]
[2,null,{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!G10)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!H10)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!I10)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!J10)","v":""}]
[3,null,{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!G11)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!H11)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!I11)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!J11)","v":""}]
[4,null,{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!G12)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!H12)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!I12)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!J12)","v":""}]
[5,null,{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!G13)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!H13)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!I13)","v":""},{"$f":"IF($E$18=\"\",\"\",Hilfsliste_Gruppen!J13)","v":""}]
[]
["Gruppe:",null,3,"Gruppenname: ",{"$f":"IF(Vereinsanmeldung!C40>0,Vereinsanmeldung!C40,\"\")","v":""}]
[]
[1,null,{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!L9)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!M9)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!N9)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!O9)","v":""}]
[2,null,{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!L10)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!M10)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!N10)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!O10)","v":""}]
[3,null,{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!L11)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!M11)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!N11)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!O11)","v":""}]
[4,null,{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!L12)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!M12)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!N12)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!O12)","v":""}]
[5,null,{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!L13)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!M13)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!N13)","v":""},{"$f":"IF($E$26=\"\",\"\",Hilfsliste_Gruppen!O13)","v":""}]
[]
["Gruppe:",null,4,"Gruppenname: ",{"$f":"IF(Vereinsanmeldung!C42>0,Vereinsanmeldung!C42,\"\")","v":""}]
[]
[1,null,{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!Q9)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!R9)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!S9)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!T9)","v":""}]
[2,null,{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!Q10)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!R10)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!S10)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!T10)","v":""}]
[3,null,{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!Q11)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!R11)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!S11)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!T11)","v":""}]
[4,null,{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!Q12)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!R12)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!S12)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!T12)","v":""}]
[5,null,{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!Q13)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!R13)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!S13)","v":""},{"$f":"IF($E$34=\"\",\"\",Hilfsliste_Gruppen!T13)","v":""}]
[]
["Gruppe:",null,5,"Gruppenname: ",{"$f":"IF(Vereinsanmeldung!C44>0,Vereinsanmeldung!C44,\"\")","v":""}]
[]
[1,null,{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!V9)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!W9)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!X9)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!Y9)","v":""}]
[2,null,{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!V10)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!W10)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!X10)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!Y10)","v":""}]
[3,null,{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!V11)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!W11)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!X11)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!Y11)","v":""}]
[4,null,{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!V12)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!W12)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!X12)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!Y12)","v":""}]
[5,null,{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!V13)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!W13)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!X13)","v":""},{"$f":"IF($E$42=\"\",\"\",Hilfsliste_Gruppen!Y13)","v":""}]

{"sheet":"Auswahlfelder","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Anzahl Gruppen",null,"Stellung"]
[" ",null," "]
[1,null,"frei"]
[2,null,"aufg."]
[3]
[4]
[5]

{"sheet":"Altersstufe","index":5,"n_rows":94,"n_cols":6,"rows_kept":94,"cut":false,"hidden":true,"merged":[[19,1,43,2],[44,1,57,2],[58,1,67,2],[68,1,93,2],[4,1,4,2],[6,1,18,1],[6,2,7,2],[8,2,10,2],[11,2,12,2],[13,2,14,2],[15,2,16,2],[17,2,18,2]]}
["Berechnung Altersstufe aus dem Altersjahr oder dem Jahrgang "]
[]
["Wettkampf-\nJahr",{"$f":"Vereinsanmeldung!G14","v":2025}]
[]
[null,"Altersstufen",null,"Altersjahr","Jahrgang","Kategorie"]
[null,null,null,0,0," "]
[null,"Junioren U10 - U21","U10",8,{"$f":"+$B$3-D7","v":2017},"U17"]
[null,null,null,{"$f":"+D7+1","v":9},2016,"U17"]
[null,null,"U13",10,2015,"U17"]
[null,null,null,11,2014,"U17"]
[null,null,null,12,2013,"U17"]
[null,null,"U15",13,2012,"U17"]
[null,null,null,14,2011,"U17"]
[null,null,"U17",15,2010,"U17"]
[null,null,null,16,2009,"U17"]
[null,null,"U19",17,2008,"U21"]
[null,null,null,18,2007,"U21"]
[null,null,"U21",19,2006,"U21"]
[null,null,null,20,2005,"U21"]
[null,"Elite (offene Altersstufe ohne Altersbegrenzung)",null,21,2004,"E"]
[null,null,null,22,2003,"E"]
[null,null,null,23,2002,"E"]
[null,null,null,24,2001,"E"]
[null,null,null,25,2000,"E"]
[null,null,null,26,1999,"E"]
[null,null,null,{"$f":"+D25+1","v":27},1998,"E"]
[null,null,null,28,1997,"E"]
[null,null,null,29,1996,"E"]
[null,null,null,30,1995,"E"]
[null,null,null,31,1994,"E"]
[null,null,null,32,1993,"E"]
[null,null,null,33,1992,"E"]
[null,null,null,34,1991,"E"]
[null,null,null,35,1990,"E"]
[null,null,null,36,1989,"E"]
[null,null,null,37,1988,"E"]
[null,null,null,38,1987,"E"]
[null,null,null,39,1986,"E"]
[null,null,null,40,1985,"E"]
[null,null,null,41,1984,"E"]
[null,null,null,42,1983,"E"]
[null,null,null,43,1982,"E"]
[null,null,null,44,1981,"E"]
[null,null,null,{"$f":"+D43+1","v":45},1980,"E"]
[null,"Senioren",null,46,1979,"S"]
[null,null,null,47,1978,"S"]
[null,null,null,48,1977,"S"]
[null,null,null,49,1976,"S"]
[null,null,null,50,1975,"S"]
[null,null,null,51,1974,"S"]
[null,null,null,52,1973,"S"]
[null,null,null,53,1972,"S"]
[null,null,null,54,1971,"S"]
[null,null,null,55,1970,"S"]
[null,null,null,56,1969,"S"]
[null,null,null,57,1968,"S"]
[null,null,null,58,1967,"S"]
[null,null,null,59,1966,"S"]
[null,"Veteranen",null,60,1965,"V"]
[null,null,null,61,1964,"V"]
[null,null,null,62,1963,"V"]
[null,null,null,{"$f":"+D61+1","v":63},1962,"V"]
[null,null,null,64,1961,"V"]
[null,null,null,65,1960,"V"]
[null,null,null,66,1959,"V"]
[null,null,null,67,1958,"V"]
[null,null,null,68,1957,"V"]
[null,null,null,69,1956,"V"]
[null,"Seniorveteranen",null,70,1955,"SV"]
[null,null,null,71,1954,"SV"]
[null,null,null,72,{"$f":"+$B$3-D71","v":1953},"SV"]
[null,null,null,73,1952,"SV"]
[null,null,null,74,1951,"SV"]
[null,null,null,75,1950,"SV"]
[null,null,null,76,1949,"SV"]
[null,null,null,77,1948,"SV"]
[null,null,null,78,1947,"SV"]
[null,null,null,79,1946,"SV"]
[null,null,null,80,1945,"SV"]
[null,null,null,81,1944,"SV"]
[null,null,null,82,1943,"SV"]
[null,null,null,83,1942,"SV"]
[null,null,null,84,1941,"SV"]
[null,null,null,85,1940,"SV"]
[null,null,null,86,1939,"SV"]
[null,null,null,87,1938,"SV"]
[null,null,null,88,1937,"SV"]
[null,null,null,89,1936,"SV"]
[null,null,null,90,1935,"SV"]
[null,null,null,91,1934,"SV"]
[null,null,null,92,1933,"SV"]
[null,null,null,93,1932,"SV"]
[null,null,null,94,1931,"SV"]
[null,null,null,95,1930,"SV"]

{"sheet":"Hilfsliste_Gruppen","index":6,"n_rows":13,"n_cols":25,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[1.1000000000000001,{"$f":"VLOOKUP(A1,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A1,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A1,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A1,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},2.1,{"$f":"VLOOKUP(F1,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F1,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F1,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F1,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},3.1,{"$f":"VLOOKUP(K1,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K1,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K1,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K1,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},4.0999999999999996,{"$f":"VLOOKUP(P1,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P1,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P1,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P1,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},5.0999999999999996,{"$f":"VLOOKUP(U1,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U1,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U1,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U1,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}}]
[1.2,{"$f":"VLOOKUP(A2,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A2,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A2,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A2,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},2.2000000000000002,{"$f":"VLOOKUP(F2,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F2,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F2,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F2,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},3.2,{"$f":"VLOOKUP(K2,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K2,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K2,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K2,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},4.2,{"$f":"VLOOKUP(P2,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P2,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P2,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P2,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},5.2,{"$f":"VLOOKUP(U2,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U2,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U2,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U2,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}}]
[1.3,{"$f":"VLOOKUP(A3,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},2.2999999999999998,{"$f":"VLOOKUP(F3,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F3,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F3,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F3,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},3.3,{"$f":"VLOOKUP(K3,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K3,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K3,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K3,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},4.3,{"$f":"VLOOKUP(P3,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P3,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P3,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P3,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},5.3,{"$f":"VLOOKUP(U3,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U3,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U3,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U3,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}}]
[1.4,{"$f":"VLOOKUP(A4,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A4,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A4,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A4,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},2.4,{"$f":"VLOOKUP(F4,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F4,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F4,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F4,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},3.4,{"$f":"VLOOKUP(K4,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K4,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K4,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K4,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},4.4000000000000004,{"$f":"VLOOKUP(P4,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P4,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P4,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P4,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},5.4,{"$f":"VLOOKUP(U4,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U4,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U4,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U4,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}}]
[1.5,{"$f":"VLOOKUP(A5,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A5,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A5,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A5,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},2.5,{"$f":"VLOOKUP(F5,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F5,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F5,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F5,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},3.5,{"$f":"VLOOKUP(K5,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K5,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K5,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K5,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},4.5,{"$f":"VLOOKUP(P5,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P5,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P5,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P5,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}},5.5,{"$f":"VLOOKUP(U5,Personenerfassung!$C$6:$I$35,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U5,Personenerfassung!$C$6:$I$35,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U5,Personenerfassung!$C$6:$I$35,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(U5,Personenerfassung!$C$6:$I$35,7,FALSE)","v":{"$error":"#N/A"}}]
[]
[5,6,7,8,null,12,13,14,15,null,19,20,21,22,null,26,27,28,29,null,33,34,35,36]
[]
[{"$f":"A1","v":1.1000000000000001},{"$f":"IF(ISERROR(B1),\"\",B1)","v":""},{"$f":"IF(ISERROR(C1),\"\",C1)","v":""},"","",{"$f":"F1","v":2.1},{"$f":"IF(ISERROR(G1),\"\",G1)","v":""},"","","",{"$f":"K1","v":3.1},{"$f":"IF(ISERROR(L1),\"\",L1)","v":""},"","","",{"$f":"P1","v":4.0999999999999996},{"$f":"IF(ISERROR(Q1),\"\",Q1)","v":""},"","","",{"$f":"U1","v":5.0999999999999996},{"$f":"IF(ISERROR(V1),\"\",V1)","v":""},"","",""]
[{"$f":"A2","v":1.2},{"$f":"IF(ISERROR(B2),\"\",B2)","v":""},"","","",{"$f":"F2","v":2.2000000000000002},{"$f":"IF(ISERROR(G2),\"\",G2)","v":""},"","","",{"$f":"K2","v":3.2},{"$f":"IF(ISERROR(L2),\"\",L2)","v":""},"","","",{"$f":"P2","v":4.2},{"$f":"IF(ISERROR(Q2),\"\",Q2)","v":""},"","","",{"$f":"U2","v":5.2},{"$f":"IF(ISERROR(V2),\"\",V2)","v":""},"","",""]
[1.3,{"$f":"IF(ISERROR(B3),\"\",B3)","v":""},"","","",2.2999999999999998,{"$f":"IF(ISERROR(G3),\"\",G3)","v":""},"","","",3.3,{"$f":"IF(ISERROR(L3),\"\",L3)","v":""},"","","",4.3,{"$f":"IF(ISERROR(Q3),\"\",Q3)","v":""},"","","",5.3,{"$f":"IF(ISERROR(V3),\"\",V3)","v":""},"","",""]
[1.4,{"$f":"IF(ISERROR(B4),\"\",B4)","v":""},"","","",2.4,{"$f":"IF(ISERROR(G4),\"\",G4)","v":""},"","","",3.4,{"$f":"IF(ISERROR(L4),\"\",L4)","v":""},"","","",4.4000000000000004,{"$f":"IF(ISERROR(Q4),\"\",Q4)","v":""},"","","",5.4,{"$f":"IF(ISERROR(V4),\"\",V4)","v":""},"","",""]
[1.5,{"$f":"IF(ISERROR(B5),\"\",B5)","v":""},"","","",2.5,{"$f":"IF(ISERROR(G5),\"\",G5)","v":""},"","","",3.5,{"$f":"IF(ISERROR(L5),\"\",L5)","v":""},"","","",4.5,{"$f":"IF(ISERROR(Q5),\"\",Q5)","v":""},"","","",5.5,{"$f":"IF(ISERROR(V5),\"\",V5)","v":""},"","",""]