{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["START","EINGABE","Uebersicht Alles","DRUCK Alles","DRUCK Mitglieder","DRUCK Ehrenveteranen)","DRUCK Ehrenmitglieder","DRUCK Funktionäre","STATISTIK","Admin"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":16,"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":"START","index":0,"n_rows":156,"n_cols":3,"rows_kept":156,"cut":false,"hidden":false,"merged":[[154,0,154,7],[155,0,155,7],[42,1,42,6],[146,0,146,1],[147,0,147,1],[148,0,148,1],[149,0,149,1]]}
["Geschätzte Kollegin, geschätzter Kollege"]
[]
["Die vorliegende Excel-Arbeitsmappe mit Makro - SAT-Admin_Listen erstellen.xlsm - hilft, aus der"]
["SAT-Admin-Auswertung \"SSV Mitgliederverzeichnis_ttmmjjjj.xlsx\" druckbare Listen für die"]
["Sektion zu erstellen."]
[]
["Für geübte Excel-Anwender kein Problem. Allen andern wird das Studium der nachfolgenden"]
["Beschreibung empfohlen."]
[]
["Beschreibung"]
[]
["1.","In SAT-Admin -> Auswertungen -> Personen, \"SSV-Mitgliederverzeichnis\" wählen."]
[null,"\"BERICHT GENERIEREN\" anklicken. Die Auswertung wird als Excel bereitgestellt"]
[null,"und auf dem eigenen PC, im Ordner \"Downloads\", unter dem Namen"]
[null,"\"SSV Mitgliederverzeichnis_ttmmjjjj.xlsx\" gespeichert."]
[]
["2","Arbeitsmappe \"SSV Mitgliederverzeichnis_ttmmjjjj.xlsx\", Tabelle"]
[null,"\"Mitgliederverzeichnis\" öffnen"]
[]
["3.","Kopieren der Werte aus der Tabelle \"Mitgliederverzeichnis\""]
[null,"Inhalt der Tabelle \"Mitgliederverzeichnis\" markieren und kopieren (ctrl+c)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"markieren der gesamten Tabelle mittels Klick auf die Ecke über der Zeile 1"]
[]
["4.","Einfügen der kopierten Werte in die Arbeitsmappe \"SAT-Admin_Listen erstellen.xlsm\""]
[null,"In der vorliegenden Arbeitsmappe (SAT-Admin_Listen erstellen.xlsm), Tabelle "]
[null,"\"EINGABE\" öffnen und kopierte Werte einfügen. Der Befehl ctrl+v wird für das Einfügen"]
[null,"der kopierten Werte nicht empfohlen. Eine Erklärung befindet sich am Schluss dieser"]
[null,"Beschreibung (*). Zum Einfügen geht man am besten wie folgt vor:"]
[]
[]
[]
["4.1.","Cursor in der Tabelle \"EINGABE\" auf Position Spalte A, Zeile 1 (A1) setzen"]
["4.2.","Start -> Einfügen (1) -> Inhalte einfügen… (2) -> Werte (3) -> OK (4)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Der Inhalt der SAT-Admin Tabelle \"SSV Mitgliederverzeichnis / Mitgliederverzeicnis\""]
[null,"wurde ohne in die vorliegende Arbeitsmappe, Tabelle \"EINGABE\" übertragen."]
[]
["5.","Die vorliegende Arbeitsmappe unter dem Namen der Sektion auf dem eigenen PC "]
[null,"speichern (z.B. Aargau, Beide Basel, Bern, Fribourg, Genève, Graubünden, Jura, Linth, "]
[null,"Neuchâtel, Ostschweiz, Solothurn, Ticino, Valais, Vaud, Zentralschweiz, Zürich). "]
[null,"Der Name der Sektion wird auf den gedruckten Listen aufgeführt."]
[null,"Beispiel:  Datei -> speichern unter -> ZENTRALSCHWEIZ.xlsm"]
[]
["6.","In der Tabelle \"START\" Taste \"LISTEN ERSTELLEN\" anklicken:"]
[]
["7.","Die Listen für die aktiven Mitglieder, die Ehrenveteranen, die Ehrenmitglieder und"]
[null,"die Funktionäre sind erstellt und können angesehen, resp. ausgedruckt werden."]
[]
["8.","Speichern"]
[]
["9.","Die Inhalte der Listen können durch Veränderung der Filter angepasst werden"]
[null,"(gilt vor allem für die Liste \"Alles\")"]
[]
[null,"Sollte eine Liste für den Ausdruck zu breit sein, können einzelne Spalten mit der"]
[null,"Maus etwas verengt werden."]
[]
["*","Wählt man zum Einfügen der Daten aus \"SSV Mitgliederverzeichnis_ttmmjjjj.xlsx\","]
[null,"Tabelle \"Mitgliederverzeichnis\" in SAT-Admin_Listen erstellen.xlsm, Tabelle"]
[null,"\"EINGABE\" den Befehl ctrl+v, werden nicht nur die Daten sondern auch die Formate"]
[null,"und Formeln übertragen. Dies führt bei einem späteren Aufruf der Liste zu folgender"]
[null,"Fehlermeldung:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OK anklicken. Der Inhalt der Arbeitsmappe ist trotzdem korrekt."]
[]
[]
["Tabellenfarben:"]
[]
["weiss",null,"Erklärungstext, Benutzeranleitung"]
["grün",null,"Einfügebereich für die Daten aus SAT-Admin"]
["gelb",null,"Listen, zum Ansehen und drucken"]
["schwarz",null,"gesperrt - nichts verändern"]
[]
[]
[]
[]
["Diese Excel-Arbeitsmappe wurde durch Bruno Briner erstellt."]
["Fragen und Hilfe: \"bruno.briner@datazug.ch\" oder 079 688 41 36."]

{"sheet":"EINGABE","index":1,"n_rows":3,"n_cols":39,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Personennummer","Lizenznummer","Anrede","Vorname","Nachname","Firma","Zusatz","Strasse","PLZ","Ort","Land","Telefonnummer Geschäft","Mobilnummer Geschäft","Telefonnummer Privat","Mobilnummer Privat","Email","Zusätzliche E-Mail","Webseite","Geschlecht","Geburtsdatum","Versichertennummer","Sprache","Nationalität","Vereinsnummer","Vereinsname","Kategorie","Eintrittsdatum","Austritt","Tätigkeit","Bemerkung Tätigkeit","Tätigkeit Eintrittsdatum","Tätigkeit Austrittsdatum","Zu fakturierende Verein","Vorstandsmeldung","Mitglied 'Aktiv'","Persönliche Briefanrede Schützenmuseum","Beitragskategorie","Verstorben","Werbung erwünscht"]
["1068694","120609","Herr","Felix","Muster","","","Musterweg 77","9999 Musterau","Musterkinden","CH","","","033 999 99 99","079 999 99 99","muster@bluewin.ch","","","Männlich","1953-11-15","756.5692.3085.04","Deutsch","CH","1.52.0.03","Veteranen-Sportschützen des Kantons Bern","Mitglied VSS G50","2016-01-01",null,"","",null,null,"1.02.1.00.060",0,1,"","",0,0]
["1070757","122673","Frau","Paula","Tester","","","Teststrasse 99",9999,"Testort","CH","","","033 999 99 99","079 999 99 99","","","","Weiblich","1949-11-18","","Deutsch","CH","1.52.0.03","Veteranen-Sportschützen des Kantons Bern","Mitglied VSS G50","2023-01-01",null,"","",null,null,"1.02.4.00.110",0,1,"","",0,1]

{"sheet":"Uebersicht Alles","index":2,"n_rows":3,"n_cols":39,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Personennummer","Lizenznummer","Anrede","Vorname","Nachname","Firma","Zusatz","Strasse","PLZ","Ort","Land","Telefonnummer Geschäft","Mobilnummer Geschäft","Telefonnummer Privat","Mobilnummer Privat","Email","Zusätzliche E-Mail","Webseite","Geschlecht","Geburtsdatum","Versichertennummer","Sprache","Nationalität","Vereinsnummer","Vereinsname","Kategorie","Eintrittsdatum","Austritt","Tätigkeit","Bemerkung Tätigkeit","Tätigkeit Eintrittsdatum","Tätigkeit Austrittsdatum","Zu fakturierende Verein","Vorstandsmeldung","Mitglied 'Aktiv'","Persönliche Briefanrede Schützenmuseum","Beitragskategorie","Verstorben","Werbung erwünscht"]
["1068694","120609","Herr","Felix","Muster","","","Musterweg 77","9999 Musterau","Musterkinden","CH","","","033 999 99 99","079 999 99 99","muster@bluewin.ch","","","Männlich","1953-11-15","756.5692.3085.04","Deutsch","CH","1.52.0.03","Veteranen-Sportschützen des Kantons Bern","Mitglied VSS G50","2016-01-01",null,"","",null,null,"1.02.1.00.060",0,1,"","",0,0]
["1070757","122673","Frau","Paula","Tester","","","Teststrasse 99",9999,"Testort","CH","","","033 999 99 99","079 999 99 99","","","","Weiblich","1949-11-18","","Deutsch","CH","1.52.0.03","Veteranen-Sportschützen des Kantons Bern","Mitglied VSS G50","2023-01-01",null,"","",null,null,"1.02.4.00.110",0,1,"","",0,1]

{"sheet":"DRUCK Alles","index":3,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Nachname","Vorname","Geb.Dat","Strasse","PLZ","Ort","Tf Privat","Tf Mobile","Email","Kategorie","Eintritt","Tätigkeit","Eintritt","Lizenz-Nr.","Anrede","A-Lizenz bei","Vorstand","Aktiv","Verstorben"]
["Muster","Felix","1953-11-15","Musterweg 77","9999 Musterau","Musterkinden","033 999 99 99","079 999 99 99","muster@bluewin.ch","Mitglied VSS G50","2016-01-01","",null,"120609","Herr","1.02.1.00.060",0,1,0]
["Tester","Paula","1949-11-18","Teststrasse 99",9999,"Testort","033 999 99 99","079 999 99 99","","Mitglied VSS G50","2023-01-01","",null,"122673","Frau","1.02.4.00.110",0,1,0]

{"sheet":"DRUCK Mitglieder","index":4,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Nachname","Vorname","Geb.Dat","Strasse","PLZ","Ort","Tf Privat","Tf Mobile","Email","Kategorie","Eintritt","Tätigkeit","Eintritt","Lizenz-Nr.","Anrede","A-Lizenz bei","Vorstand","Aktiv","Verstorben"]
["Muster","Felix","1953-11-15","Musterweg 77","9999 Musterau","Musterkinden","033 999 99 99","079 999 99 99","muster@bluewin.ch","Mitglied VSS G50","2016-01-01","",null,"120609","Herr","1.02.1.00.060",0,1,0]
["Tester","Paula","1949-11-18","Teststrasse 99",9999,"Testort","033 999 99 99","079 999 99 99","","Mitglied VSS G50","2023-01-01","",null,"122673","Frau","1.02.4.00.110",0,1,0]

{"sheet":"DRUCK Ehrenveteranen)","index":5,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Nachname","Vorname","Geb.Dat","Strasse","PLZ","Ort","Tf Privat","Tf Mobile","Email","Kategorie","Eintritt","Tätigkeit","Eintritt","Lizenz-Nr.","Anrede","A-Lizenz bei","Vorstand","Aktiv","Verstorben"]
["Muster","Felix","1953-11-15","Musterweg 77","9999 Musterau","Musterkinden","033 999 99 99","079 999 99 99","muster@bluewin.ch","Mitglied VSS G50","2016-01-01","",null,"120609","Herr","1.02.1.00.060",0,1,0]
["Tester","Paula","1949-11-18","Teststrasse 99",9999,"Testort","033 999 99 99","079 999 99 99","","Mitglied VSS G50","2023-01-01","",null,"122673","Frau","1.02.4.00.110",0,1,0]

{"sheet":"DRUCK Ehrenmitglieder","index":6,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Nachname","Vorname","Geb.Dat","Strasse","PLZ","Ort","Tf Privat","Tf Mobile","Email","Kategorie","Eintritt","Tätigkeit","Eintritt","Lizenz-Nr.","Anrede","A-Lizenz bei","Vorstand","Aktiv","Verstorben"]
["Muster","Felix","1953-11-15","Musterweg 77","9999 Musterau","Musterkinden","033 999 99 99","079 999 99 99","muster@bluewin.ch","Mitglied VSS G50","2016-01-01","",null,"120609","Herr","1.02.1.00.060",0,1,0]
["Tester","Paula","1949-11-18","Teststrasse 99",9999,"Testort","033 999 99 99","079 999 99 99","","Mitglied VSS G50","2023-01-01","",null,"122673","Frau","1.02.4.00.110",0,1,0]

{"sheet":"DRUCK Funktionäre","index":7,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Nachname","Vorname","Geb.Dat","Strasse","PLZ","Ort","Tf Privat","Tf Mobile","Email","Kategorie","Eintritt","Tätigkeit","Eintritt","Lizenz-Nr.","Anrede","A-Lizenz bei","Vorstand","Aktiv","Verstorben"]
["Muster","Felix","1953-11-15","Musterweg 77","9999 Musterau","Musterkinden","033 999 99 99","079 999 99 99","muster@bluewin.ch","Mitglied VSS G50","2016-01-01","",null,"120609","Herr","1.02.1.00.060",0,1,0]
["Tester","Paula","1949-11-18","Teststrasse 99",9999,"Testort","033 999 99 99","079 999 99 99","","Mitglied VSS G50","2023-01-01","",null,"122673","Frau","1.02.4.00.110",0,1,0]

{"sheet":"STATISTIK","index":8,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,7,1,8]]}
[{"$f":"'Uebersicht Alles'!Y2","v":"Veteranen-Sportschützen des Kantons Bern"}]
["STATISTIK",null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-08-22"}]
[]
[]
["Aus SSV Mitgliederverzeichnis (SAT-Admin) übertragene Mitglieder (mehrfach aufgeführt)",null,null,null,null,null,null,{"$f":"COUNTA('DRUCK Alles'!A:A)","v":3}]
["(Verstorbene, nicht Aktive, Ehrenveteranen, Ehrenmitglieder, Funktionäre, weitere)"]
[]
[]
["Anzahl Mitglieder (VSS Mitglied G50 und VSS Mitglied G10 / Aktiv = 1 / Verstorben = 0)",null,null,null,null,null,null,{"$f":"SUBTOTAL(3,'DRUCK Mitglieder'!A2:A2000)","v":2},1]
[]
["- davon normale Mitglieder",null,null,null,null,null,null,{"$f":"H9-(H12+H13+H14)","v":2},{"$f":"H11/TotalMitglieder","v":1}]
["- davon Ehrenveteranen (Ehrenveteran / Aktiv = 1 / Verstorben = 0)",null,null,null,null,null,null,{"$f":"SUBTOTAL(3,'DRUCK Ehrenveteranen)'!A2:A2000)","v":0},{"$f":"H12/TotalMitglieder","v":0}]
["- davon Ehrenmitglieder (Ehrenmitglieder / Aktiv = 1 / Verstorben = 0)",null,null,null,null,null,null,{"$f":"SUBTOTAL(3,'DRUCK Ehrenmitglieder'!A2:A2000)","v":0},{"$f":"H13/TotalMitglieder","v":0}]
["- davon Vorstandsmitglieder und Funktionäre (Tätigkeit nicht leer / Aktiv = 1 / Verstorben = 0)",null,null,null,null,null,null,{"$f":"SUBTOTAL(3,'DRUCK Funktionäre'!A2:A2000)","v":0},{"$f":"H14/TotalMitglieder","v":0}]
[]
[null,null,null,null,"G50m","G10m"]
["Anzahl Damen",null,null,null,{"$f":"COUNTIFS('DRUCK Mitglieder'!O:O,\"Frau\",'DRUCK Mitglieder'!R:R,1,'DRUCK Mitglieder'!J:J,\"Mitglied VSS G50\",'DRUCK Mitglieder'!S:S,0)","v":1},{"$f":"COUNTIFS('DRUCK Mitglieder'!O:O,\"Frau\",'DRUCK Mitglieder'!R:R,1,'DRUCK Mitglieder'!J:J,\"Mitglied VSS G10\",'DRUCK Mitglieder'!S:S,0)","v":0},null,{"$f":"E17+F17","v":1},{"$f":"H17/TotalMitglieder","v":0.5}]
["Anzahl Herren",null,null,null,{"$f":"COUNTIFS('DRUCK Mitglieder'!O:O,\"Herr\",'DRUCK Mitglieder'!R:R,1,'DRUCK Mitglieder'!J:J,\"Mitglied VSS G50\",'DRUCK Mitglieder'!S:S,0)","v":1},{"$f":"COUNTIFS('DRUCK Mitglieder'!O:O,\"Herr\",'DRUCK Mitglieder'!R:R,1,'DRUCK Mitglieder'!J:J,\"Mitglied VSS G10\",'DRUCK Mitglieder'!S:S,0)","v":0},null,{"$f":"E18+F18","v":1},{"$f":"H18/TotalMitglieder","v":0.5}]
["Total",null,null,null,{"$f":"E17+E18","v":2},{"$f":"F17+F18","v":0},null,{"$f":"E19+F19","v":2},1]

{"sheet":"Admin","index":9,"n_rows":1,"n_cols":19,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Nachname","Vorname","Geb.Dat","Strasse","PLZ","Ort","Tf Privat","Tf Mobile","Email","Kategorie","Eintritt","Tätigkeit","Eintritt","Lizenz-Nr.","Anrede","A-Lizenz bei","Vorstand","Aktiv","Verstorben"]