{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Gruppen","Parameter","KorrProtokoll"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":144,"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":"Gruppen","index":0,"n_rows":136,"n_cols":5,"rows_kept":136,"cut":false,"hidden":false,"merged":[[127,1,127,2],[134,1,134,2],[85,1,85,2],[92,1,92,2],[99,1,99,2],[106,1,106,2],[113,1,113,2],[120,1,120,2],[78,1,78,2],[1,1,1,2],[8,1,8,2],[15,1,15,2],[22,1,22,2],[29,1,29,2],[36,1,36,2],[43,1,43,2],[50,1,50,2],[57,1,57,2],[64,1,64,2],[71,1,71,2]]}
[{"$f":"IFERROR(VLOOKUP(B1,Sektionen,2,0),\"\")","v":"1.10.0.03.231"},{"$f":"IF(ISBLANK(Sektionsname),PlatzhalterSektion,Sektionsname)","v":"Corbières-Cerniat"},null,null,{"$f":"IF(ISBLANK(defRunde),\"- - -\",defRunde)","v":"Tour 2"}]
[{"$f":"txtGruppe","v":"Groupe"},"Corbières-Cerniat 1 JS",null,"JS",{"$f":"SUM(E4:E8)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[null,null,null,"F ass 90"]
[null,null,null,"F ass 90"]
[null,null,null,"F ass 90"]
[null,null,null,"F ass 90"]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E11:E15)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E18:E22)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E25:E29)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E32:E36)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E39:E43)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E46:E50)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E53:E57)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E60:E64)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E67:E71)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E74:E78)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E81:E85)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E88:E92)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E95:E99)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E102:E106)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E109:E113)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E116:E120)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E123:E127)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E130:E134)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]
[]
[]
[]
[]
[]
[{"$f":"txtGruppe","v":"Groupe"},null,null,null,{"$f":"SUM(E137:E141)","v":0}]
[null,null,null,{"$f":"txtWaffe","v":"Arme"},{"$f":"txtResultat","v":"Résultat"}]

{"sheet":"Parameter","index":1,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["Dateiname",{"$f":"E53","v":"Résultats"},null,null,null,null,null,null,null,"Fixe Texte",null,null,null,null,"SelectionChange aktiv:",1]
["Sektionsname","Corbières-Cerniat",null,null,null,null,null,null,null,{"$f":"fctSprache(K2,defSprache)","v":"Groupe"},"Gruppe","Groupe"]
["Runde",{"$f":"VLOOKUP(Runde,Runden,2,0)","v":"Tour 2"},2,null,null,null,null,null,null,{"$f":"fctSprache(K3,defSprache)","v":"Arme"},"Waffe","Arme"]
["Bezirk","Gruyère",null,null,null,null,null,null,null,{"$f":"fctSprache(K4,defSprache)","v":"Résultat"},"Resultat","Résultat"]
["Sprache",1]
["Platzhalter",1]
["SGM oder SGMJ",1,null,null,null,null,null,null,null,"Feldliste",null,{"$f":"fctSprache(M7,SGMtyp)","v":"FelderSGMJ"},"FelderSGM","FelderSGMJ"]
[]
["Version","2024-04-01",null,null,null,null,null,null,null,"A"]
["Anzahl Gruppenblöcke",20,"Anzahl Gruppenblöcke im Tabellenblatt",null,null,null,null,null,null,"D"]
[null,null,null,null,null,null,null,null,null,"E"]
[]
["Sektion","Sektionsnr","Bezirk",null,"Runde",null,null,null,null,"JS"]
["Belfaux","1.10.0.01.211",{"$f":"VALUE(MID(B14,8,2))","v":1},null,1,{"$f":"fctSprache(G14,defSprache)","v":"Tour 1"},"Runde 1","Tour 1",null,"JJ"]
["Ecuvillens","1.10.0.01.250",{"$f":"VALUE(MID(B15,8,2))","v":1},null,2,{"$f":"fctSprache(G15,defSprache)","v":"Tour 2"},"Runde 2","Tour 2"]
["Fribourg","1.10.0.01.267",1]
["Haute-Sarine","1.10.0.01.205",1,null,"Bezirke",null,null,null,null,"Meldungen"]
["La Giblana","1.10.0.01.326",1,null,"Broye",null,null,null,null,{"$f":"fctSprache(K18,defSprache)","v":"D'abord sélectionner une section s.v.p."},"Bitte zuerst noch eine Sektion auswählen","D'abord sélectionner une section s.v.p."]
["Marly","1.10.0.01.292",1,null,"Glâne",null,null,null,null,"Exporter les données","Daten exportieren","Exporter les données"]
["Prez et env.","1.10.0.01.316",1,null,"Gruyère",null,null,null,null,"Les données ont été exportées dans le fichier :","Die Daten wurden in folgende Datei exportiert:","Les données ont été exportées dans le fichier :"]
["Treyvaux","1.10.0.01.345",1,null,"Sarine",null,null,null,null,"Toutes les données saisies vont être effacées","Alle bisher erfassten Daten werden gelöscht","Toutes les données saisies vont être effacées"]
["Alterswil","1.10.0.02.004",2,null,"See / Lac",null,null,null,null,"Continuer ?","Weiterfahren ?","Continuer ?"]
["Bösingen-Laupen","1.10.0.02.013",2,null,"Sense",null,null,null,null,"Vider le tableau","Tabelle leeren","Vider le tableau"]
["Giffers-Tentlingen","1.10.0.02.070",2,null,"Veveyse",null,null,null,null,"Ceci n'est pas un fichier de résultats exporté depuis ce fichier Excel","Dies ist keine aus dieser Excel-Datei exportierte Resultatdatei","Ceci n'est pas un fichier de résultats exporté depuis ce fichier Excel"]
["Heitenried","1.10.0.02.080",2,null,null,null,null,null,null,"La valeur saisie n'est pas une arme autorisée!","Der eingegeben Wert ist keine erlaubte Waffe!","La valeur saisie n'est pas une arme autorisée!"]
["Plaffeien-Brünisried","1.10.0.02.016",2,null,"Sprachen",null,null,null,null,"Gruppen erfassen","Saisie des groupes"]
["Plasselb","1.10.0.02.112",2,null,0,"Deutsch",null,null,null,"Bitte zuerst ein Feld erfassen","Veuillez d'abord saisir un champ"]
["Rechthalten","1.10.0.02.119",2,null,1,"Français"]
["St. Antoni","1.10.0.02.129",2]
["St. Silvester","1.10.0.02.132",2,null,"Waffen A",null,null,"RF"]
["St. Ursen","1.10.0.02.133",2,null,{"$f":"fctSprache(F31,defSprache)","v":"AL"},"Frei-G","AL",10]
["Tafers","1.10.0.02.142",2,null,"F st","Stagw","F st",20]
["Überstorf","1.10.0.02.147",2,null,"Mousqueton","Karabiner","Mousqueton",30]
["Wünnewil-Flamatt","1.10.0.02.163",2,null,"F ass 90 ring","Stgw 90 Ring","F ass 90 ring",40]
["Bas-Intyamon","1.10.0.03.273",3,null,"F ass 90 bloc","Stgw 90 Block","F ass 90 bloc",50]
["Botterens","1.10.0.03.214",3,null,"F ass 57-02","Stgw 57-02","F ass 57-02",60,null,"Platzhalter Sektion"]
["Broc","1.10.0.03.215",3,null,{"$f":"fctSprache(F37,defSprache)","v":"F ass 57-03"},"Stgw 57-03","F ass 57-03",70,null,{"$f":"fctSprache(K37,defSprache)","v":"[  Sélectionner une Section ! ]"},"[ Sektion auswählen ! ]","[  Sélectionner une Section ! ]"]
["Bulle","1.10.0.03.217",3,null,"F ass 90","Stgw 90","F ass 90",80]
["Charmey","1.10.0.03.224",3]
["Corbières-Cerniat","1.10.0.03.231",3,null,"Waffen D",null,null,"RF"]
["Echarlens","1.10.0.03.249",3,null,{"$f":"fctSprache(F41,defSprache)","v":"F ass 90 ring"},"Stgw 90 Ring","F ass 90 ring",50]
["Gruyères","1.10.0.03.275",3,null,{"$f":"fctSprache(F42,defSprache)","v":"F ass 90 bloc"},"Stgw 90 Block","F ass 90 bloc",60]
["Hauteville","1.10.0.03.277",3,null,{"$f":"fctSprache(F43,defSprache)","v":"F ass 57-02"},"Stgw 57-02","F ass 57-02",70]
["Haut-Intyamon","1.10.0.03.298",3,null,{"$f":"fctSprache(F44,defSprache)","v":"F ass 57-03"},"Stgw 57-03","F ass 57-03",80]
["La Roche","1.10.0.03.322",3,null,{"$f":"fctSprache(F45,defSprache)","v":"Mousqueton"},"Karabiner","Mousqueton",40]
["Le Bry","1.10.0.03.313",3]
["Lessoc","1.10.0.03.288",3,null,"Waffen E",null,null,"RF"]
["Pont-la-Ville","1.10.0.03.314",3,null,{"$f":"fctSprache(F48,defSprache)","v":"F ass 90 ring"},"Stgw 90 Ring","F ass 90 ring",50]
["Sâles - Vaulruz","1.10.0.03.334",3,null,{"$f":"fctSprache(F49,defSprache)","v":"F ass 90 bloc"},"Stgw 90 Block","F ass 90 bloc",60]
["Sauthaux","1.10.0.03.344",3,null,{"$f":"fctSprache(F50,defSprache)","v":"F ass 57-02"},"Stgw 57-02","F ass 57-02",70]
["Sorens","1.10.0.03.341",3]
["Vuadens","1.10.0.03.358",3,null,"Dateinamen"]
["Agriswil-Ried","1.10.0.04.001",4,null,{"$f":"fctSprache(F53,defSprache)","v":"Résultats"},"Resultate","Résultats"]
["Cordast-Burg-Guschelmuth","1.10.0.04.032",4]
["Courgevaux","1.10.0.04.235",4,null,"SGMtyp"]
["Courlevon","1.10.0.04.036",4,null,0,{"$f":"fctSprache(G56,defSprache)","v":"CSG-300"},"SGM-300","CSG-300"]
["Cournillens","1.10.0.04.237",4,null,1,{"$f":"fctSprache(G57,defSprache)","v":"CSGJ-300"},"SGMJ-300","CSGJ-300"]
["Courtion","1.10.0.04.239",4]
["Cressier-sur-Morat","1.10.0.04.240",4,null,"maxResultat"]
["Fräschels-Muntelier","1.10.0.04.101",4,null,{"$f":"INDIRECT(F60)","v":200},"maxJJ"]
["Galmiz","1.10.0.04.068",4,null,"maxA",200]
["Gempenach-Büchslen","1.10.0.04.069",4,null,"maxD",150]
["Gurmels","1.10.0.04.076",4,null,"maxE",150]
["Kerzers","1.10.0.04.082",4,null,"maxJJ",200]
["Liebistorf-Kl.Bösingen","1.10.0.04.089",4,null,"maxJS",200]
["Murten","1.10.0.04.104",4]
["Salvenach-Jeuss","1.10.0.04.135",4,null,"Zusatz Gruppenname"]
["Ulmiz","1.10.0.04.148",4,null,{"$f":"fctSprache(F68,defSprache)","v":""},"",""]
["Villarepos-Chandossel","1.10.0.04.353",4,null,{"$f":"fctSprache(F69,defSprache)","v":"JS"},"JS","JS"]
["Vully","1.10.0.04.342",4,null,{"$f":"fctSprache(F70,defSprache)","v":"JJ"},"JJ","JJ"]
["Wallenried","1.10.0.04.362",4,null,{"$f":"fctSprache(F71,defSprache)","v":"JS+JJ"},"JS+JJ","JS+JJ"]
["Billens-Hennens","1.10.0.05.212",5,null,{"$f":"fctSprache(F72,defSprache)","v":"JJ+JS"},"JJ+JS","JJ+JS"]
["Châtonnaye","1.10.0.05.228",5]
["Mézières","1.10.0.05.294",5]
["Middes","1.10.0.05.295",5]
["Prez-vers-Siviriez","1.10.0.05.317",5]
["Romont","1.10.0.05.323",5]
["Rue","1.10.0.05.327",{"$f":"VALUE(MID(B78,8,2))","v":5}]
["Siviriez","1.10.0.05.340",5]
["Villarsiviriaux","1.10.0.05.354",5]
["Villaz-St-Pierre","1.10.0.05.355",5]
["Vuisternens-dt-Romont","1.10.0.05.361",5]
["Aumont","1.10.0.06.208",6]
["Bussy-Morens-Sévaz","1.10.0.06.221",6]
["Châbles-Cheyres","1.10.0.06.223",6]
["Cugy","1.10.0.06.242",6]
["Dompierre-Russy","1.10.0.06.246",6]
["Estavayer-le-Lac-Lully","1.10.0.06.254",6]
["Fétigny","1.10.0.06.256",6]
["Font-Châtillon","1.10.0.06.259",6]
["Forel-Autavaux-Montbrelloz","1.10.0.06.260",6]
["Léchelles","1.10.0.06.296",6]
["Murist","1.10.0.06.302",6]
["Rueyres-les-Prés","1.10.0.06.328",6]
["St-Aubin","1.10.0.06.330",6]
["Vallon","1.10.0.06.350",6]
["Villeneuve-Surpierre-Praratoud","1.10.0.06.356",6]
["Attalens","1.10.0.07.207",7]
["Châtel-St-Denis","1.10.0.07.226",7]
["Le Crêt","1.10.0.07.241",7]
["Porsel","1.10.0.07.315",7]
["Semsales","1.10.0.07.339",7]
["Beispiel","1.10.0.08.001",8]
["Exemple","1.10.0.08.002",8]

{"sheet":"KorrProtokoll","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Korrekturen seit der Version 20220403"]
[]
["Datum","Was","Einfluss auf Datenexport"]
["2022-04-21","Korrektur eines Anzeigefehlers bei fehlenden Werten. Bei der ersten fehlenden Waffe wird angezeigt, dass der Vorname fehlt.","NEIN"]
["2022-05-20","Geführtes Erfassen der Sektion (und Runde) sowie des Gruppennamens","NEIN"]
["2022-05-20","Datencheck mit der Überprüfung des Resultatfeldes ergänzt.","Nein"]
["2023-03-20","Sektionsliste gemäss Liste von Raymond nachgeführt","NEIN"]
["2023-04-05","maximales Resultat auf das Feld der Gruppe eingeschränkt, nicht wie bisher global 200","NEIN"]
["2023-04-06","Verwaltung der Gruppennummer optimiert","NEIN"]
["2023-04-23","Verwaltung der Gruppennummer optimiert -> Zusatz zum Gruppennamen auf JS, JJ, JS+JJ, JJ+JS eingeschränkt","NEIN"]
["2024-04-02","Domdidier und Jaun aus Sektionsnamen entfernt","NEIN"]