{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Eingabe Daten","E-Mail für Rangliste","ELITE Final Resultate","JUNIOREN Final Resultate","ewigListe_Kategorie nach Alter"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"Eingabe Daten","index":0,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,11,5,15],[2,2,3,5],[2,7,3,7],[23,0,24,0],[0,2,1,7],[10,13,11,15],[22,0,22,1],[9,0,9,1],[19,1,19,2],[34,0,34,8],[19,4,19,5],[19,7,19,8],[7,2,7,4],[4,2,5,5],[31,1,31,2],[31,4,31,5],[31,7,31,8],[33,0,33,8]]}
[null,null,"Gruppenmeisterschaft G50m",null,null,null,null,null,null,null,"Version:","24_01 vom 24.04.2024 / M. Brupbacher"]
[]
[null,null,"ZSV Final",null,null,null,null,{"$f":"TODAY()","v":"2024-04-28"}]
[]
[null,null,"Meldedaten Gruppen"]
[]
[]
[null,"Verein:"]
[]
["Elite:"]
[]
[null,"Name + Vorname","JG (JJJJ)","E-Mail","Name + Vorname","JG (JJJJ)","E-Mail","Name + Vorname","JG (JJJJ)","E-Mail"]
[]
["1. liegend"]
["2. liegend"]
["3. liegend"]
["4. kniend"]
["5. kniend"]
[]
[null,{"$f":"C8&\" 1\"","v":" 1"},null,null,{"$f":"C8&\" 2\"","v":" 2"},null,null,{"$f":"C8&\" 3\"","v":" 3"}]
[]
[]
["Junioren:"]
[]
[null,"Name + Vorname","JG (JJJJ)","E-Mail","Name + Vorname","JG (JJJJ)","E-Mail","Name + Vorname","JG (JJJJ)","E-Mail"]
[]
["1. liegend"]
["2. liegend"]
["3. kniend"]
["4. kniend"]
[]
[null,{"$f":"C8&\" 1\"","v":" 1"},null,null,{"$f":"C8&\" 2\"","v":" 2"},null,null,{"$f":"C8&\" 3\"","v":" 3"}]
[]
["Anmeldungen elektronisch bis spätestens Mi 12.06.2024 per E-Mail an:"]
["per Mail an: aldobersanini.zsv@bluewin.ch. und  mail@armando-amrein.ch"]

{"sheet":"E-Mail für Rangliste","index":1,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
["Verein:",{"$f":"'Eingabe Daten'!C8","v":0}]
[]
["Elite:",{"$f":"'Eingabe Daten'!D14","v":0},{"$f":"'Eingabe Daten'!B14","v":0}]
[null,{"$f":"'Eingabe Daten'!D15","v":0},{"$f":"'Eingabe Daten'!B15","v":0}]
[null,{"$f":"'Eingabe Daten'!D16","v":0},{"$f":"'Eingabe Daten'!B16","v":0}]
[null,{"$f":"'Eingabe Daten'!D17","v":0},{"$f":"'Eingabe Daten'!B17","v":0}]
[null,{"$f":"'Eingabe Daten'!D18","v":0},{"$f":"'Eingabe Daten'!B18","v":0}]
[null,{"$f":"'Eingabe Daten'!G14","v":0},{"$f":"'Eingabe Daten'!E14","v":0}]
[null,{"$f":"'Eingabe Daten'!G15","v":0},{"$f":"'Eingabe Daten'!E15","v":0}]
[null,{"$f":"'Eingabe Daten'!G16","v":0},{"$f":"'Eingabe Daten'!E16","v":0}]
[null,{"$f":"'Eingabe Daten'!G17","v":0},{"$f":"'Eingabe Daten'!E17","v":0}]
[null,{"$f":"'Eingabe Daten'!G18","v":0},{"$f":"'Eingabe Daten'!E18","v":0}]
[null,{"$f":"'Eingabe Daten'!J14","v":0},{"$f":"'Eingabe Daten'!H14","v":0}]
[null,{"$f":"'Eingabe Daten'!J15","v":0},{"$f":"'Eingabe Daten'!H15","v":0}]
[null,{"$f":"'Eingabe Daten'!J16","v":0},{"$f":"'Eingabe Daten'!H16","v":0}]
[null,{"$f":"'Eingabe Daten'!J17","v":0},{"$f":"'Eingabe Daten'!H17","v":0}]
[null,{"$f":"'Eingabe Daten'!J18","v":0},{"$f":"'Eingabe Daten'!H18","v":0}]
["Junioren:",{"$f":"'Eingabe Daten'!D27","v":"00:00:00"},{"$f":"'Eingabe Daten'!B27","v":"00:00:00"}]
[null,{"$f":"'Eingabe Daten'!D28","v":"00:00:00"},{"$f":"'Eingabe Daten'!B28","v":"00:00:00"}]
[null,{"$f":"'Eingabe Daten'!D29","v":"00:00:00"},{"$f":"'Eingabe Daten'!B29","v":"00:00:00"}]
[null,{"$f":"'Eingabe Daten'!D30","v":"00:00:00"},{"$f":"'Eingabe Daten'!B30","v":"00:00:00"}]
[null,{"$f":"'Eingabe Daten'!G27","v":0},{"$f":"'Eingabe Daten'!E27","v":0}]
[null,{"$f":"'Eingabe Daten'!G28","v":0},{"$f":"'Eingabe Daten'!E28","v":0}]
[null,{"$f":"'Eingabe Daten'!G29","v":0},{"$f":"'Eingabe Daten'!E29","v":0}]
[null,{"$f":"'Eingabe Daten'!G30","v":0},{"$f":"'Eingabe Daten'!E30","v":0}]
[null,{"$f":"'Eingabe Daten'!J27","v":0},{"$f":"'Eingabe Daten'!H27","v":0}]
[null,{"$f":"'Eingabe Daten'!J28","v":0},{"$f":"'Eingabe Daten'!H28","v":0}]
[null,{"$f":"'Eingabe Daten'!J29","v":0},{"$f":"'Eingabe Daten'!H29","v":0}]
[null,{"$f":"'Eingabe Daten'!J30","v":0},{"$f":"'Eingabe Daten'!H30","v":0}]

{"sheet":"ELITE Final Resultate","index":2,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,6,6,8],[16,6,16,8],[26,6,26,8]]}
[]
[null,null,"Zentralschweizerischer Sportschützen Verband"]
[]
[null,null,"Final Gruppenmeisterschaft G50m",null,null,null,"Kat. Elite"]
[null,null,{"$f":"'Eingabe Daten'!H3","v":"2024-04-28"}]
[]
["Verein:",null,{"$f":"'Eingabe Daten'!C8:E8","v":0},null,null,"Gruppe",{"$f":"'Eingabe Daten'!B20","v":" 1"}]
[]
[null,null,"Name + Vorname","JG","1. \nRunde","2. \nRunde","Total","Final","Total"]
["E1","liegend",{"$f":"'Eingabe Daten'!B14","v":0},{"$f":"'Eingabe Daten'!C14","v":0},null,null,{"$f":"SUM(E10:F10)","v":0}]
["E2","liegend",{"$f":"'Eingabe Daten'!B15","v":0},{"$f":"'Eingabe Daten'!C15","v":0},null,null,{"$f":"SUM(E11:F11)","v":0}]
["E3","liegend",{"$f":"'Eingabe Daten'!B16","v":0},{"$f":"'Eingabe Daten'!C16","v":0},null,null,{"$f":"SUM(E12:F12)","v":0}]
["E4","kniend",{"$f":"'Eingabe Daten'!B17","v":0},{"$f":"'Eingabe Daten'!C17","v":0},null,null,{"$f":"SUM(E13:F13)","v":0}]
["E5","kniend",{"$f":"'Eingabe Daten'!B18","v":0},{"$f":"'Eingabe Daten'!C18","v":0},null,null,{"$f":"SUM(E14:F14)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E10:E14)","v":0},{"$f":"SUM(F10:F14)","v":0},{"$f":"SUM(G10:G14)","v":0},{"$f":"SUM(H10:H14)","v":0}]
[]
["Verein:",null,{"$f":"'Eingabe Daten'!C8:E8","v":0},null,null,"Gruppe",{"$f":"'Eingabe Daten'!E20","v":" 2"}]
[]
[null,null,"Name + Vorname","JG","1. \nRunde","2. \nRunde","Total","Final","Total"]
["E1","liegend",{"$f":"'Eingabe Daten'!E14","v":0},{"$f":"'Eingabe Daten'!F14","v":0},null,null,{"$f":"SUM(E20:F20)","v":0}]
["E2","liegend",{"$f":"'Eingabe Daten'!E15","v":0},{"$f":"'Eingabe Daten'!F15","v":0},null,null,{"$f":"SUM(E21:F21)","v":0}]
["E3","liegend",{"$f":"'Eingabe Daten'!E16","v":0},{"$f":"'Eingabe Daten'!F16","v":0},null,null,{"$f":"SUM(E22:F22)","v":0}]
["E4","kniend",{"$f":"'Eingabe Daten'!E17","v":0},{"$f":"'Eingabe Daten'!F17","v":0},null,null,{"$f":"SUM(E23:F23)","v":0}]
["E5","kniend",{"$f":"'Eingabe Daten'!E18","v":0},{"$f":"'Eingabe Daten'!F18","v":0},null,null,{"$f":"SUM(E24:F24)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E20:E24)","v":0},{"$f":"SUM(F20:F24)","v":0},{"$f":"SUM(G20:G24)","v":0},{"$f":"SUM(H20:H24)","v":0}]
[]
["Verein:",null,{"$f":"'Eingabe Daten'!C8:E8","v":0},null,null,"Gruppe",{"$f":"'Eingabe Daten'!H20","v":" 3"}]
[]
[null,null,"Name + Vorname","JG","1. \nRunde","2. \nRunde","Total","Final","Total"]
["E1","liegend",{"$f":"'Eingabe Daten'!H14","v":0},{"$f":"'Eingabe Daten'!I14","v":0},null,null,{"$f":"SUM(E30:F30)","v":0}]
["E2","liegend",{"$f":"'Eingabe Daten'!H15","v":0},{"$f":"'Eingabe Daten'!I15","v":0},null,null,{"$f":"SUM(E31:F31)","v":0}]
["E3","liegend",{"$f":"'Eingabe Daten'!H16","v":0},{"$f":"'Eingabe Daten'!I16","v":0},null,null,{"$f":"SUM(E32:F32)","v":0}]
["E4","kniend",{"$f":"'Eingabe Daten'!H17","v":0},{"$f":"'Eingabe Daten'!I17","v":0},null,null,{"$f":"SUM(E33:F33)","v":0}]
["E5","kniend",{"$f":"'Eingabe Daten'!H18","v":0},{"$f":"'Eingabe Daten'!I18","v":0},null,null,{"$f":"SUM(E34:F34)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E30:E34)","v":0},{"$f":"SUM(F30:F34)","v":0},{"$f":"SUM(G30:G34)","v":0},{"$f":"SUM(H30:H34)","v":0}]

{"sheet":"JUNIOREN Final Resultate","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,6,6,8],[15,6,15,8],[24,6,24,8]]}
[]
[null,null,"Zentralschweizerischer Sportschützen Verband"]
[]
[null,null,"Final Gruppenmeisterschaft G50m",null,null,null,"Kat. Junioren"]
[null,null,{"$f":"'Eingabe Daten'!H3","v":"2024-04-28"}]
[]
["Verein:",null,{"$f":"'Eingabe Daten'!C8:E8","v":0},null,null,"Gruppe",{"$f":"'Eingabe Daten'!B20","v":" 1"}]
[]
[null,null,"Name + Vorname","JG","1. \nRunde","2. \nRunde","Total","Final","Total"]
["E1","liegend",{"$f":"'Eingabe Daten'!B27","v":0},{"$f":"'Eingabe Daten'!C27","v":0},null,null,{"$f":"SUM(E10:F10)","v":0}]
["E2","liegend",{"$f":"'Eingabe Daten'!B28","v":0},{"$f":"'Eingabe Daten'!C28","v":0},null,null,{"$f":"SUM(E11:F11)","v":0}]
["E3","kniend",{"$f":"'Eingabe Daten'!B29","v":0},{"$f":"'Eingabe Daten'!C29","v":0},null,null,{"$f":"SUM(E12:F12)","v":0}]
["E4","kniend",{"$f":"'Eingabe Daten'!B30","v":0},{"$f":"'Eingabe Daten'!C30","v":0},null,null,{"$f":"SUM(E13:F13)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E10:E13)","v":0},{"$f":"SUM(F10:F13)","v":0},{"$f":"SUM(E14:F14)","v":0}]
[]
["Verein:",null,{"$f":"'Eingabe Daten'!C8:E8","v":0},null,null,"Gruppe",{"$f":"'Eingabe Daten'!E20","v":" 2"}]
[]
[null,null,"Name + Vorname","JG","1. \nRunde","2. \nRunde","Total","Final","Total"]
["E1","liegend",{"$f":"'Eingabe Daten'!E27","v":0},{"$f":"'Eingabe Daten'!F27","v":0},null,null,{"$f":"SUM(E19:F19)","v":0}]
["E2","liegend",{"$f":"'Eingabe Daten'!E28","v":0},{"$f":"'Eingabe Daten'!F28","v":0},null,null,{"$f":"SUM(E20:F20)","v":0}]
["E3","kniend",{"$f":"'Eingabe Daten'!E29","v":0},{"$f":"'Eingabe Daten'!F29","v":0},null,null,{"$f":"SUM(E21:F21)","v":0}]
["E4","kniend",{"$f":"'Eingabe Daten'!E30","v":0},{"$f":"'Eingabe Daten'!F30","v":0},null,null,{"$f":"SUM(E22:F22)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E19:E22)","v":0},{"$f":"SUM(F19:F22)","v":0},{"$f":"SUM(G19:G22)","v":0}]
[]
["Verein:",null,{"$f":"'Eingabe Daten'!C8:E8","v":0},null,null,"Gruppe",{"$f":"'Eingabe Daten'!H20","v":" 3"}]
[]
[null,null,"Name + Vorname","JG","1. \nRunde","2. \nRunde","Total","Final","Total"]
["E1","liegend",{"$f":"'Eingabe Daten'!H27","v":0},{"$f":"'Eingabe Daten'!I27","v":0},null,null,{"$f":"SUM(E28:F28)","v":0}]
["E2","liegend",{"$f":"'Eingabe Daten'!H28","v":0},{"$f":"'Eingabe Daten'!I28","v":0},null,null,{"$f":"SUM(E29:F29)","v":0}]
["E3","kniend",{"$f":"'Eingabe Daten'!H29","v":0},{"$f":"'Eingabe Daten'!I29","v":0},null,null,{"$f":"SUM(E30:F30)","v":0}]
["E4","kniend",{"$f":"'Eingabe Daten'!H30","v":0},{"$f":"'Eingabe Daten'!I30","v":0},null,null,{"$f":"SUM(E31:F31)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E28:E31)","v":0},{"$f":"SUM(F28:F31)","v":0},{"$f":"SUM(G28:G31)","v":0}]

{"sheet":"ewigListe_Kategorie nach Alter","index":4,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,27,18],[11,1,11,18],[16,1,16,2],[16,3,16,16],[16,17,16,18],[21,1,21,8],[21,9,21,18],[0,17,1,18],[5,0,6,0],[5,1,5,13],[6,1,6,2],[6,3,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,18]]}
["Berechnung Altersstufe aus dem Altersjahr oder dem Jahrgang   /  Calcul des classes d’âge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgabe/Edition 2020"]
["Stichtag - Final resp. letzter Schiesstag eines Wettkampfs"]
[]
["Wettkampf-\nJahr / l'année du concours",{"$f":"TODAY()","v":"2024-04-28"},null,null,null,null,null,null,null,"̶"]
[]
["Altersstufen","Junioren U10 - U21"]
[null,"U10",null,"U13",null,null,"U15",null,"U17",null,"U19",null,"U21",null,"Elite"]
["Altersjahr",8,{"$f":"+B8+1","v":9},{"$f":"+C8+1","v":10},11,12,13,14,15,16,17,18,19,20,21,{"$f":"+O8+1","v":22},{"$f":"+P8+1","v":23},{"$f":"+Q8+1","v":24},{"$f":"+R8+1","v":25}]
["Jahrgang",{"$f":"+$B$4-B8","v":45402},45401,45400,45399,45398,45397,45396,45395,45394,45393,45392,45391,45390,45389,45388,45387,45386,45385]
[]
[]
["Altersstufen","Elite"]
["Altersjahr",26,{"$f":"+B13+1","v":27},{"$f":"+C13+1","v":28},29,30,31,32,33,34,35,36,37,38,39,40,41,42,43]
["Jahrgang",{"$f":"+$B$4-B13","v":45384},45383,45382,45381,45380,45379,45378,45377,45376,45375,45374,45373,45372,45371,45370,45369,45368,45367]
[]
[]
["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},{"$f":"+C18+1","v":46},{"$f":"+D18+1","v":47},{"$f":"+E18+1","v":48},{"$f":"+F18+1","v":49},{"$f":"+G18+1","v":50},51,52,53,54,55,56,57,58,59,60,61]
["Jahrgang",{"$f":"+$B$4-B18","v":45366},45365,45364,45363,45362,45361,45360,45359,45358,45357,45356,45355,45354,45353,45352,45351,45350,45349]
[]
[]
["Altersstufen","Veteranen",null,null,null,null,null,null,null,"Seniorveteranen"]
["Altersjahr",62,{"$f":"+B23+1","v":63},{"$f":"+C23+1","v":64},65,66,67,68,69,70,71,72,73,74,75,76,77,78,79]
["Jahrgang",{"$f":"+$B$4-B23","v":45348},45347,45346,45345,45344,45343,45342,45341,45340,45339,45338,45337,45336,45335,45334,45333,45332,45331]
[]
["Bei Kalenderjahr übergreifenden Wettkämpfen ist das am Ende des Wettkampfes erreichte Altersjahr massgebend."]
[]
["Lors de concours se déroulant sur deux années calendrier, \nc’est l’âge atteint dans l’année au courant de laquelle le concours prend fin qui compte."]