{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Zuweisung zu Altersstufe","Muster Gewehr","Berechnung Altersstufe","GEWEHR","PISTOLE"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"comments":4,"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":"Zuweisung zu Altersstufe","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,0,7,1],[9,0,9,4]]}
[]
[]
[]
[]
[]
[]
[]
["Wer ist wo einzuteilen?",null,null,null,"Reg.-Nr. 6.42.05"]
[]
["Wichtig für die Zuweisung zur massgebenden Altersstufe und Kategorie ist das Alter gemäss Jahrgang am Schweizer Jugendfinal.                                                                               Beispiel:   Jahrgang des Jugendlichen 2003, Alterstufe am Jugendtag 2015 = U13 = Kategorie je nach Stellung. Der gleiche Jugendliche ist am Schweizer Jugendfinal 2016 in Kategorie U15."]
[null,null,null,null,null,null,"Bewertung"]
["Sportgerät","Stellung","Alter","Altersstufe","Kategorie","Testresultate","Polysport"]
["Gewehr 10m","sitzend oder stehend, feste Auflage","8 - 9","U10","G10K","3 x 20 Schuss","U10"]
["Gewehr 10 m","stehend, feste Auflage","10 - 12","U13","G10A","3 x 20 Schuss","U13"]
["Gewehr 10 m","stehend, bewegliche Auflage","10 - 14","U13 / U15","G10B","3 x 20 Schuss","U15"]
["Gewehr 10 m","stehend frei","10 - 14","U13 / U15","G10C","3 x 20 Schuss","U15"]
["Gewehr 10 m","stehend frei","15 - 16","U17","G10D","3 x 40 Schuss"," - "]
["Gewehr 50 m","liegend aufgelegt","10 - 14","U13 / U15","G50A","3 x 20 Schuss","U13 oder U15"]
["Gewehr 50 m","liegend frei","10 - 14","U13 / U15","G50C","3 x 20 Schuss","U13 oder U15"]
["Gewehr 50 m ","liegend frei","15 - 16","U17","G50D","3 x 40 Schuss"," -"]
["Pistole 10m","sitzend oder stehend feste Auflage","8 - 9","U10","P10K","3 x 20 Schuss","U10"]
["Pistole 10 m","stehend, feste Auflage","10 - 12","U13","P10A","3 x 20 Schuss","U13"]
["Pistole 10 m","stehend, bewegliche Auflage","10 - 14","U13 / U15","P10B","3 x 20 Schuss","U15"]
["Pistole 10 m","stehend frei","10 - 14","U13 / U15","P10C","3 x 20 Schuss","U15"]
["Pistole 10 m","stehend frei","15 - 16","U17","P10D","3 x 40 Schuss"," - "]
["Pistole 10 m (5 Schuss)","stehend frei","13 - 16","U15 / U17","P10E","3 x 30 Schuss"," - "]
["Pistole 25m","stehend frei","13 - 16","U15 / U17","P25D","2 x 15 Schuss"," - "]
[]
["Weitere Formulare für die Berechnung der Altersstufen und die Testschiessen Gewehr und Pistole"]
["finden Sie in weiteren Registerkarten in der unteren Menüleiste! "]

{"sheet":"Muster Gewehr","index":1,"n_rows":72,"n_cols":17,"rows_kept":72,"cut":false,"hidden":true,"merged":[[71,5,71,11],[15,7,15,8],[17,11,18,11],[17,7,17,10],[15,10,15,11],[17,6,18,6],[3,4,3,8],[13,1,13,4],[8,1,8,4],[8,5,8,7],[13,5,13,7],[4,4,4,9],[6,8,6,9],[13,8,13,11],[8,8,8,11],[14,1,14,4],[17,2,18,2],[15,1,15,4],[17,5,18,5],[17,1,18,1],[17,4,18,4],[17,3,18,3]]}
[null,null,null,null,{"$f":"IF(F1>0,\"Falsches Alter\",\"\")","v":""},{"$f":"COUNTIF(F21:F69,\"#NV\")","v":0},null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,{"$f":"IF(N19=O19,\"\",\"Bitte alle Finalteilnehmer mit ja oder nein eintragen\")","v":""}]
[null,null,null,null,{"$f":"IF(N19=O19,\"\",\"Les participants à la finale, obligatoirement repondre avec oui ou non\")","v":""},null,null,null,null,null,null,"Reg.-Nr. 6.51.11"]
[]
["Meldeformular für Resultate der Testschiessen in den NWK",null,null,null,null,null,null,null,"Gewehr",null,"10m"]
[]
["Verein / société:","Hütten FSV",null,null,null,"KSV/UV / SCT/SF:",null,null,"Zürich"]
[]
["Leitung der NWK / Responsable du cours des releve:",null,null,null,null,"Region West/Mitte/Ost:",null,null,"West"]
[]
[]
["Name / Nom:","Hauser",null,null,null,"Vorname / Prénom:",null,null,"Peter"]
["Adresse / Adresse:","Chneus, 8825 Hütten"]
["E-Mail / Courriel:","hauser@bluewin.ch",null,null,null,"Tel.:",null,"044 788 16 30",null,"Natel:","079 486 57 55"]
[]
["Name / Vorname                                     ","Jg.             Année","f / m","KSV/UV","Verein","Altersstufe\nclasse d'age","Kat.","Testschiessen",null,null,null,"Finalteilnahme    JA / NEIN"]
["Nom / Prénom",null,null,null,null,null,null,"Test 1","Test 2","Test 3","TOTAL",null,"Anzahl",{"$f":"IF(K7=\"50m\",\"\",COUNTA(A21:A69))","v":20},{"$f":"IF(K7=\"50m\",\"\",COUNTA(L21:L69))","v":20}]
[]
["Baer  Markus",99,"w","ospsv","Schönenberg FSV",{"$f":"IF(B21=\"\",\"\",VLOOKUP(N21,$P$21:$Q$39,2,N21))","v":{"$error":"#REF!"}},"G10B",125,125,125,{"$f":"SUM(H21,I21,J21)","v":375},"ja",{"$f":"IF(A21=\"\",\"\",ROW()-20)","v":1},{"$f":"IF(B21<20,$N$1-(2000+B21),$N$1-(1900+B21))","v":{"$error":"#REF!"}},null,8,"U9"]
["Baer  David",99,"m","ZH","Hütten FSV",{"$f":"IF(B22=\"\",\"\",VLOOKUP(N22,$P$21:$Q$39,2,N22))","v":{"$error":"#REF!"}},"P10B",136,136,136,{"$f":"SUM(H22,I22,J22)","v":408},"ja",{"$f":"IF(A22=\"\",\"\",ROW()-20)","v":2},{"$error":"#REF!"},null,9,"U9"]
["Baumann  Michael",99,"w","ZH","Hirzel SV",{"$error":"#REF!"},"G10D",310,325,322,957,"ja",3,{"$error":"#REF!"},null,10,"U12"]
["Calarota Ruedi",95,"m","ZH","Hütten FSV",{"$error":"#REF!"},"G10D",322,318,332,972,"nein",4,{"$error":"#REF!"},null,11,"U12"]
["Falk  Andreas",78,"w","ZH","Hütten FSV",{"$error":"#REF!"},"G10C",108,108,108,324,"nein",5,{"$error":"#REF!"},null,12,"U12"]
["Fideeler  Adrian",60,"m","ZH","Schönenberg FSV",{"$error":"#REF!"},"G10D",331,322,330,983,"ja",6,{"$error":"#REF!"},null,13,"U14"]
["Fleischmann  Hans",96,"m","ZH","Hirzel SV",{"$error":"#REF!"},"G10B",126,126,126,378,"nein",7,{"$error":"#REF!"},null,14,"U14"]
["Fleischmann  Tobias",92,"m","ZH","Schönenberg FSV",{"$error":"#REF!"},"G10B",134,134,134,402,"ja",8,{"$error":"#REF!"},null,15,"U16"]
["Kubli  Beat",90,"m","ZH","Schönenberg FSV",{"$error":"#REF!"},"G10A",131,131,131,393,"nein",9,{"$error":"#REF!"},null,16,"U16"]
["Liniger Michael",91,"m","ZH","Hütten FSV",{"$error":"#REF!"},"G10B",112,112,112,336,"nein",10,{"$error":"#REF!"},null,17,"U18"]
["Liniger  Andreas",89,"m","ZH","Hütten FSV",{"$error":"#REF!"},"G10B",122,122,122,366,"ja",11,{"$error":"#REF!"},null,18,"U18"]
["Lötscher  Sergo",90,"m","ZH","Schönenberg FSV",{"$error":"#REF!"},"G10A",125,125,125,375,"ja",12,{"$error":"#REF!"},null,19,"U20"]
["Mäder  Andreas",91,"m","ZH","Hütten FSV",{"$error":"#REF!"},"G10C",103,103,103,309,"nein",13,{"$error":"#REF!"},null,20,"U20"]
["Pfister  Andrea",95,"w","ZH","Hütten FSV",{"$error":"#REF!"},"G10A",145,145,145,435,"ja",14,{"$error":"#REF!"}]
["Pfister  Jürg",93,"m","ZH","Hirzel SV",{"$error":"#REF!"},"G10D",282,301,299,882,"ja",15,{"$error":"#REF!"}]
["Schaufelbühl  Pascal",95,"m","ZH","Schönenberg FSV",{"$error":"#REF!"},"G10D",296,311,315,922,"ja",16,{"$error":"#REF!"}]
["Schmid  Michael",96,"m","ZH","Schönenberg FSV",{"$error":"#REF!"},"G10D",302,286,312,900,"nein",17,{"$error":"#REF!"}]
["Schuler  Markus",97,"m","ZH","Hirzel SV",{"$error":"#REF!"},"G10A",145,145,145,435,"ja",18,{"$error":"#REF!"}]
["Schuler  Felix",98,"m","ZH","Schönenberg FSV",{"$error":"#REF!"},"G10A",112,112,112,336,"nein",19,{"$error":"#REF!"}]
["Winkler  Felix",89,"w","ZH","Hütten FSV",{"$error":"#REF!"},"G10A",123,123,123,{"$f":"SUM(H40,I40,J40)","v":369},"ja",20,{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$f":"IF(B43<20,$N$1-(2000+B43),$N$1-(1900+B43))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
[null,null,null,null,null,"",null,null,null,null,0,null,"",{"$error":"#REF!"}]
["Total Anzahl Finalteilnehmer",null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(L21:L69,\"ja\")","v":12}]
[]
["Datum / date:",null,null,null,"Unterschrift:","sig.  P. Hauser"]

{"sheet":"Berechnung Altersstufe","index":2,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,8],[21,9,21,18],[16,17,16,18],[6,1,6,2],[6,3,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[11,1,11,18],[16,1,16,2],[5,1,5,13],[6,14,6,18],[16,3,16,16]]}
["Berechnung Altersstufe aus dem Altersjahr oder dem Jahrgang "]
["Stichtag - Final resp. letzter Schiesstag eines Wettkampfs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgabe 2016"]
[]
["Wettkampf-\nJahr",2019,null,null,null,null,null,null,null,"̶"]
[]
[null,"Junioren U10 - U21"]
["Altersstufen","U10",null,"U13",null,null,"U15",null,"U17",null,"U19",null,"U21",null,"Elite"]
["Altersjahr",8,{"$f":"+B8+1","v":9},10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
["Jahrgang",{"$f":"+$B$4-B8","v":2011},2010,2009,2008,2007,2006,2005,2004,2003,2002,2001,2000,1999,1998,1997,1996,1995,1994]
[]
[]
["Altersstufen","Elite (offene Altersstufe ohne Altersbegrenzung)"]
["Altersjahr",26,{"$f":"+B13+1","v":27},28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43]
["Jahrgang",{"$f":"+$B$4-B13","v":1993},1992,1991,1990,1989,1988,1987,1986,1985,1984,1983,1982,1981,1980,1979,1978,1977,1976]
[]
[]
["Altersstufen","Elite",null,"Senioren",null,null,null,null,null,null,null,null,null,null,null,null,null,"Veteranen"]
["Altersjahr",44,{"$f":"+B18+1","v":45},46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61]
["Jahrgang",{"$f":"+$B$4-B18","v":1975},1974,1973,1972,1971,1970,1969,1968,1967,1966,1965,1964,1963,1962,1961,1960,1959,1958]
[]
[]
["Altersstufen","Veteranen",null,null,null,null,null,null,null,"Seniorveteranen"]
["Altersjahr",62,{"$f":"+B23+1","v":63},64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79]
["Jahrgang",{"$f":"+$B$4-B23","v":1957},1956,1955,1954,1953,1952,1951,1950,1949,1948,1947,1946,1945,1944,1943,1942,1941,1940]
[]
["Luzern, 06.02.2015 / plu"]

{"sheet":"GEWEHR","index":3,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[6,8,6,9],[14,1,14,4],[15,6,15,8],[13,5,13,7],[8,1,8,4],[8,5,8,7],[8,8,8,11],[17,6,18,6],[17,5,18,5],[13,8,13,11],[17,11,18,11],[17,7,17,10],[15,10,15,11],[14,8,14,11],[3,5,3,12],[4,5,4,12],[17,1,18,1],[71,1,71,3],[13,1,13,4],[17,4,18,4],[15,1,15,4],[17,3,18,3],[17,2,18,2],[71,7,71,11]]}
[null,null,null,null,{"$f":"IF(F1>0,\"Falsches Alter\",\"\")","v":""},{"$f":"COUNTIF(F21:F69,\"#NV\")","v":0},null,null,null,null,null,null,null,{"$f":"+L11","v":2019}]
[null,null,null,null,null,null,null,null,null,null,null,"Reg.-Nr. 6.42.05"]
[]
[null,null,null,null,null,{"$f":"IF(N19=O19,\"\",\"Bitte alle Finalteilnehmer mit ja oder nein eintragen\")","v":""}]
[null,null,null,null,null,{"$f":"IF(N19=O19,\"\",\"Les participants à la finale, obligatoirement repondre avec oui ou non\")","v":""}]
[]
["Meldeformular für Resultate der Testschiessen J+S Kurse Sportschiessen",null,null,null,null,null,null,null,"Gewehr",null,"10m"]
[]
["Verein / société:",null,null,null,null,"KSV/UV / SCT/SF:"]
[]
["Leitung der J+S Kurse / Responsable du J+S tir sportif:",null,null,null,null,"Region West/Mitte/Ost:",null,null,"?",null,"Wettkampf-Final:",2019]
[]
[]
["Name / Nom:",null,null,null,null,"Adresse / Adresse:"]
["Vorname / Prénom:",null,null,null,null,"PLZ, Ort:"]
["E-Mail / Courriel:",null,null,null,null,"Tel.:",null,null,null,"Natel:"]
[]
["Name / Vorname                                     ","Jg.             Année","f / m","KSV/UV","Verein","Altersstufe\nclasse d'age","Kat.","Testschiessen",null,null,null,"Finalteilnahme    JA / NEIN"]
["Nom / Prénom",null,null,null,null,null,null,"Test 1","Test 2","Test 3","TOTAL",null,"Anzahl",{"$f":"IF(K7=\"50m\",\"\",COUNTA(A21:A69))","v":0},{"$f":"IF(K7=\"50m\",\"\",COUNTA(L21:L69))","v":0}]
[]
[null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",VLOOKUP(N21,$P$21:$Q$39,2,FALSE))","v":""},null,null,null,null,{"$f":"SUM(H21,I21,J21)","v":0},null,{"$f":"IF(A21=\"\",\"\",ROW()-20)","v":""},{"$f":"IF(B21>0,$N$1-B21,\"\")","v":""},null,8,"U10"]
[null,null,null,null,null,{"$f":"IF(B22=\"\",\"\",VLOOKUP(N22,$P$21:$Q$39,2,N22))","v":""},null,null,null,null,0,null,"",{"$f":"IF(B22>0,$N$1-B22,\"\")","v":""},null,9,"U10"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,10,"U13"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,11,"U13"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,12,"U13"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,13,"U15"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,14,"U15"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,15,"U17"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,16,"U17"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,17,"U19"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,18,"U19"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,19,"U21"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,20,"U21"]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,"West"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,"Mitte"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,"Ost"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,"?"]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2010]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2011]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2012]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2013]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2014]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2015]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2016]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2017]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2018]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2019]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2020]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
["Total Anzahl Finalteilnehmer",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(L21:L69,\"ja\")","v":0}]

{"sheet":"PISTOLE","index":4,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[4,5,4,12],[3,5,3,12],[71,1,71,3],[71,7,71,11],[17,3,18,3],[17,2,18,2],[17,5,18,5],[17,11,18,11],[17,7,17,10],[17,4,18,4],[8,1,8,4],[6,8,6,9],[13,5,13,7],[8,5,8,7],[13,8,13,11],[8,8,8,11],[15,1,15,4],[14,1,14,4],[17,1,18,1],[13,1,13,4],[15,10,15,11],[17,6,18,6],[14,8,14,11],[15,6,15,8]]}
[null,null,null,null,{"$f":"IF(F1>0,\"Falsches Alter\",\"\")","v":""},{"$f":"COUNTIF(F21:F69,\"#NV\")","v":0},null,null,null,null,null,null,null,{"$f":"+L11","v":2019}]
[null,null,null,null,null,null,null,null,null,null,null,"Reg.-Nr. 6.42.05"]
[]
[null,null,null,null,null,{"$f":"IF(N19=O19,\"\",\"Bitte alle Finalteilnehmer mit ja oder nein eintragen\")","v":""}]
[null,null,null,null,null,{"$f":"IF(N19=O19,\"\",\"Les participants à la finale, obligatoirement repondre avec oui ou non\")","v":""}]
[]
["Meldeformular für Resultate der Testschiessen J+S Kurse Sportschiessen",null,null,null,null,null,null,null,"Pistole",null,"10m"]
[]
["Verein / société:",null,null,null,null,"KSV/UV / SCT/SF:"]
[]
["Leitung der J+S Kurse / Responsable du J+S tir sportif:",null,null,null,null,"Region West/Mitte/Ost:",null,null,"?",null,"Wettkampf-Final:",2019]
[]
[]
["Name / Nom:",null,null,null,null,"Adresse / Adresse:"]
["Vorname / Prénom:",null,null,null,null,"PLZ, Ort:"]
["E-Mail / Courriel:",null,null,null,null,"Tel.:",null,null,null,"Natel:"]
[]
["Name / Vorname                                     ","Jg.             Année","f / m","KSV/UV","Verein","Altersstufe\nclasse d'age","Kat.","Testschiessen",null,null,null,"Finalteilnahme    JA / NEIN"]
["Nom / Prénom",null,null,null,null,null,null,"Test 1","Test 2","Test 3","TOTAL",null,"Anzahl",{"$f":"IF(K7=\"50m\",\"\",COUNTA(A21:A69))","v":0},{"$f":"IF(K7=\"50m\",\"\",COUNTA(L21:L69))","v":0}]
[]
[null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",VLOOKUP(N21,$P$21:$Q$39,2,FALSE))","v":""},null,null,null,null,{"$f":"SUM(H21,I21,J21)","v":0},null,{"$f":"IF(A21=\"\",\"\",ROW()-20)","v":""},{"$f":"IF(B21>0,$N$1-B21,\"\")","v":""},null,8,"U10"]
[null,null,null,null,null,{"$f":"IF(B22=\"\",\"\",VLOOKUP(N22,$P$21:$Q$39,2,FALSE))","v":""},null,null,null,null,0,null,"",{"$f":"IF(B22>0,$N$1-B22,\"\")","v":""},null,9,"U10"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,10,"U13"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,11,"U13"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,12,"U13"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,13,"U15"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,14,"U15"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,15,"U17"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,16,"U17"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,17,"U19"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,18,"U19"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,19,"U21"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,20,"U21"]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,"West"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,"Mitte"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,"Ost"]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,"?"]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2010]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2011]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2012]
[null,null,null,null,null,"",null,null,null,null,{"$f":"SUM(H53,I53,J53)","v":0},null,{"$f":"IF(A53=\"\",\"\",ROW()-20)","v":""},"",null,null,2013]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2014]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2015]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2016]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2017]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2018]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2019]
[null,null,null,null,null,"",null,null,null,null,0,null,"","",null,null,2020]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
[null,null,null,null,null,"",null,null,null,null,0,null,"",""]
["Total Anzahl Finalteilnehmer",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(L21:L69,\"ja\")","v":0}]