{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Datenerfassung","Druck","Datenexport","DATEN"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Datenerfassung","index":0,"n_rows":78,"n_cols":17,"rows_kept":78,"merged":[[0,11,0,13],[13,4,13,13],[14,1,14,2],[18,1,18,6],[22,1,22,6],[22,8,22,13],[28,1,28,6],[28,10,28,13],[31,6,31,9],[33,6,33,9],[35,6,35,9],[37,4,37,8],[37,10,37,13],[39,5,39,13],[47,4,47,10],[47,12,47,13],[49,4,49,8],[55,4,55,8],[55,10,55,13],[58,4,58,6],[58,10,58,12],[61,4,61,8],[61,10,61,14]]}
["Änderungsmitteilung für Vereine",{"$nulls":10},{"$f":"IF(AND(B12=\"\",H12=\"\"),\"\",IF(P1+Q1=0,\"Angaben sind vollständig!\",\"Angaben sind noch unvollständig!\"))","v":""},{"$nulls":3},{"$f":"IF(B12=\"x\",SUM(P17:P50),0)","v":0},{"$f":"(IF(H12=\"x\",SUM(Q17:Q50),0))","v":0}]
[null,"Version: 1.1.2018"]
[]
[null,"Die Ausschreibung ist zu speichern unter Angabe"]
[null,"   der Vereinsnummer (z. B. 07-0199) und der Bezeichnung \"Dateibezeichnung\""]
[null,"und zu senden an   service(at)tln-ev.de   [Beispiel: 07-0199__datenaenderung.xlsx]!"]
[]
[null,"Hinweise zu dem Formular und den Ausschreibungen:"]
[null,"Das Formular ist schreibgeschützt. Nur die vorgegebenen Zellen können ausgefüllt werden. Eine Formatänderung ist nicht möglich."]
[null,"Die rotumrandeten und gelbunterlegten Felder sind PFLICHTFELDER!"]
[]
[null,null,"   Grunddaten ändern",{"$nulls":5},"   Bankdaten ändern",{"$nulls":4},"   Zusatzdaten ändern"]
[]
[null,"07/",null,null,{"$f":"IF(CONCATENATE(\"07/\",TEXT(C14,\"0000\"))=P14,VLOOKUP(CONCATENATE(B14,TEXT(C14,\"0000\")),DATEN!$E$2:$F$86,2),\"Vereinsdaten nicht vorhanden! - Bitte aktuelles Formular herunterladen!\")","v":{"$error":"#N/A"}},{"$nulls":10},{"$f":"VLOOKUP(CONCATENATE(\"07/\",TEXT(C14,\"0000\")),DATEN!$E$2:$G$86,3)","v":{"$error":"#N/A"}}]
[null,"Vereinsnummer"]
[]
[null,{"$f":"CONCATENATE(\"Datenänderung / -ergänzung [\",IF(B12=\"x\",\"Grunddaten\",\"\"),IF(AND(B12=\"x\",H12=\"x\"),\" - \",\"\"),IF(H12=\"x\",\"Bankdaten\",\"\"),IF(AND(OR(B12=\"x\",H12=\"x\"),M12=\"x\"),\" - \",\"\"),IF(M12=\"x\",\"Zusatzdaten\",\"\"),\"]\")","v":"Datenänderung / -ergänzung []"},{"$nulls":13},7,3]
[]
[null,{"$f":"IF(CONCATENATE(\"07/\",TEXT(C14,\"0000\"))=P14,CONCATENATE(\"07/\",TEXT(C14,\"0000\"),\"__datenaenderung.xlsx\"),\"\")","v":{"$error":"#N/A"}},{"$nulls":6},{"$f":"IF(C14=\"\",\"\",\"Dateikennzeichnung bitte beachten!\")","v":""}]
[]
[null,"Ansprechpartner/in"]
[]
[{"$nulls":15},{"$f":"IF(B23<>\"\",-1,0)+IF(I23<>\"\",-1,0)","v":0}]
[null,"Vorname",{"$nulls":6},"Name"]
[]
[]
[null,"Geschlecht"]
[]
[{"$nulls":15},{"$f":"IF(B29<>\"\",-1,0)+IF(I29<>\"\",-1,0)+IF(K29<>\"\",-1,0)","v":0}]
[null,"Straße / Postfach",{"$nulls":6},"Plz",null,"Ort"]
[]
[null,"Telefon:",{"$nulls":3},"/",{"$nulls":9},{"$f":"IF(E32<>\"\",-1,0)+IF(G32<>\"\",-1,0)","v":0}]
[]
[null,"Telefax:",{"$nulls":3},"/"]
[]
[null,"Mobil:",{"$nulls":3},"/"]
[]
[null,"E-Post-Adresse:",{"$nulls":7},"@"]
[]
[null,"Netzauftritt:",null,null,"http://"]
[]
[null,null," Meine Daten können im TLN-Infoheft veröffentlicht werden. Ist die Anschrift die Vereinsadresse"]
[null,"ja = x"," wird diese automatisch im TLN-Infoheft veröffentlicht!"]
[]
[]
[null,"Bankdaten"]
[]
[null,"Bankname [BIC]:",{"$nulls":14},{"$f":"IF(E48<>\"\",-1,0)+IF(M48<>\"\",-1,0)","v":0}]
[]
[null,"IBAN:",{"$nulls":14},{"$f":"IF(E50<>\"\",-1,\"\")","v":""}]
[{"$nulls":4},"(ohne Leerzeichen eingeben)"]
[]
[]
[null,"Zusatzdaten",null,null,"Ansprechpartner \"Ausbildung\"",{"$nulls":5},"Ansprechpartner \"Jugend\""]
[]
[]
[{"$nulls":4},"Vorname und Name",{"$nulls":5},"Vorname und Name"]
[]
[]
[{"$nulls":4},"Telefon",{"$nulls":5},"Telefon"]
[]
[]
[{"$nulls":4},"E-Post-Adresse",{"$nulls":5},"E-Post-Adresse"]
[]
[null,null,"INLUSION:",null,null,"   Tauchverein kann Menschen mit Einschränkungen beim Tauchen begleiten"]
[]
[{"$nulls":5},"   Tauchverein kann Menschen mit Einschränkungen zum Tauchen ausbilden"]
[]
[]
[null,"Angaben zur Datenverwendung"]
[]
[null,"DATENSCHUTZERKLÄRUNG"]
[null,"Der Tauchsportlandesverband Niedersachsen speichert die Daten personenbezogen und verwendet"]
[null,"sie satzungsgemäß im Rahmen seiner Geschäftstätigkeit. Die Daten werden nicht an Dritte weiterge-"]
[null,"geben! - Der Verein kann jederzeit der Speicherung und Nutzung der Daten des Ansprechparters/in"]
[null,"widerrufen! Der Widerruf ist schriftlich per elektronischer Mitteilung an  service(at)tln-ev.de  oder"]
[null,"per Post an TLN e.V., Sachabt. \"Presse\", c/o Volkmar Braun, Alter Postweg 13, 26131 Oldenburg "]
[null,"zu richten."]

{"sheet":"Druck","index":1,"n_rows":35,"n_cols":3,"rows_kept":35,"merged":[[3,1,3,3],[33,1,33,3],[34,1,34,3]]}
["Änderung/Ergänzung „Vereinsdaten“"]
[]
[]
["Verein:",{"$f":"CONCATENATE(Datenerfassung!B14,TEXT(Datenerfassung!C14,\"0000\"),\" - \",Datenerfassung!E14)","v":{"$error":"#N/A"}}]
[]
[{"$f":"IF(Datenerfassung!B12=\"x\",\"Ansprechpartner/in:\",\"GRUNDDATEN:\")","v":"GRUNDDATEN:"},{"$f":"IF(Datenerfassung!B12=\"x\",CONCATENATE(Datenerfassung!B23,\" \",Datenerfassung!I23,\" [\",Datenerfassung!B26,\"]\"),\"- keine Änderung/Ergänzung -\")","v":"- keine Änderung/Ergänzung -"}]
[null,{"$f":"Datenerfassung!B29","v":0}]
[null,{"$f":"CONCATENATE(Datenerfassung!I29,\" \",Datenerfassung!K29)","v":" "}]
[]
[{"$f":"IF(Datenerfassung!E32<>\"\",\"Fon: \",\"\")","v":""},{"$f":"CONCATENATE(Datenerfassung!E32,IF(Datenerfassung!E32=\"\",\"\",\"/\"),Datenerfassung!G32)","v":""}]
[{"$f":"IF(Datenerfassung!E34<>\"\",\"Fax: \",\"\")","v":""},{"$f":"CONCATENATE(Datenerfassung!E34,IF(Datenerfassung!E34=\"\",\"\",\"/\"),Datenerfassung!G34)","v":""}]
[{"$f":"IF(Datenerfassung!E36<>\"\",\"Mobil: \",\"\")","v":""},{"$f":"CONCATENATE(Datenerfassung!E36,IF(Datenerfassung!E36=\"\",\"\",\"/\"),Datenerfassung!G36)","v":""}]
[]
[{"$f":"IF(Datenerfassung!E38<>\"\",\"ePost: \",\"\")","v":""},{"$f":"CONCATENATE(Datenerfassung!E38,IF(Datenerfassung!E38=\"\",\"\",\"@\"),Datenerfassung!K38)","v":""}]
[{"$f":"IF(Datenerfassung!F40<>\"\",\"Netzauftritt: \",\"\")","v":""},{"$f":"CONCATENATE(IF(Datenerfassung!F40=\"\",\"\",\"http://\"),Datenerfassung!F40)","v":""}]
[]
[null,"Meine Daten können im TLN-Infoheft veröffentlicht werden: ",{"$f":"IF(Datenerfassung!B42=\"x\",\"ja\",\"nein\")","v":"nein"}]
[]
[]
["Bankdaten:",{"$f":"IF(Datenerfassung!H12=\"x\",Datenerfassung!E48,\"- keine Änderung/Ergänzung -\")","v":"- keine Änderung/Ergänzung -"}]
["IBAN: ",{"$f":"CONCATENATE(LEFT(Datenerfassung!E50,4),\" \",MID(Datenerfassung!E50,5,4),\" \",MID(Datenerfassung!E50,9,4),\" \",MID(Datenerfassung!E50,13,4),\" \",MID(Datenerfassung!E50,17,4),\" \",RIGHT(Datenerfassung!E50,2))","v":"     "}]
["BIC: ",{"$f":"Datenerfassung!M48","v":0}]
[]
["Zusatzdaten:",{"$f":"IF(Datenerfassung!M12=\"\",\"- keine Änderung/Ergänzung -\",\"\")","v":"- keine Änderung/Ergänzung -"}]
[]
["Ansprechp. \"Ausbilung\": ",{"$f":"Datenerfassung!E56","v":0}]
[null,{"$f":"IF(Datenerfassung!E59=\"\",\"\",CONCATENATE(\"Telefon: \",Datenerfassung!E59))","v":""}]
[null,{"$f":"IF(Datenerfassung!E62=\"\",\"\",CONCATENATE(\"E-Post: \",Datenerfassung!E62))","v":""}]
[]
["Ansprechp. \"Jugend\": ",{"$f":"Datenerfassung!K56","v":0}]
[null,{"$f":"IF(Datenerfassung!K59=\"\",\"\",CONCATENATE(\"Telefon: \",Datenerfassung!K59))","v":""}]
[null,{"$f":"IF(Datenerfassung!K62=\"\",\"\",CONCATENATE(\"E-Post: \",Datenerfassung!K62))","v":""}]
[]
["INKLUSION: ",{"$f":"CONCATENATE(IF(Datenerfassung!E65=\"x\",\"Tauchverein kann Menschen mit Einschränkungen beim Tauchen begleiten!\",\"\"),IF(AND(Datenerfassung!E65=\"\",Datenerfassung!E67=\"x\"),\"Tauchverein kann Menschen mit Einschränkungen zum Tauchen ausbilden!\",\"\"))","v":""}]
[null,{"$f":"IF(AND(Datenerfassung!E65=\"x\",Datenerfassung!E67=\"x\"),\"Tauchverein kann Menschen mit Einschränkungen zum Tauchen ausbilden!\",\"\")","v":""}]

{"sheet":"Datenexport","index":2,"n_rows":10,"n_cols":16,"rows_kept":10,"merged":[[5,2,5,3],[6,2,6,3],[8,2,8,3],[8,5,8,6],[8,7,8,9],[8,11,8,12],[9,2,9,3],[9,5,9,6],[9,7,9,9],[9,11,9,12]]}
["VD_Nr","VD_Organisation","VD_Vorname","VD_Nachname","VD_Adresszusatz","VD_Geschlecht","VD_Strasse","VD_Plz","VD_Ort","VD_Ortsschl","VD_Stimme","VD_Telefon","VD_Telefax","VD_Mobil","VD_Homepage","VD_Email"]
[{"$f":"CONCATENATE(\"07/\",TEXT(Datenerfassung!C14,\"0000\"))","v":"07/0000"},{"$f":"Datenerfassung!E14","v":{"$error":"#N/A"}},{"$f":"Datenerfassung!B23","v":0},{"$f":"Datenerfassung!I23","v":0},{"$f":"IF(F2=\"n\",\"Geschäftsstelle\",\"\")","v":""},{"$f":"Datenerfassung!B26","v":0},{"$f":"Datenerfassung!B29","v":0},{"$f":"Datenerfassung!I29","v":0},{"$f":"Datenerfassung!K29","v":0},{"$f":"VLOOKUP(LEFT(J4,3),DATEN!$B$2:$C$33,2)","v":{"$error":"#N/A"}},{"$f":"IF(Datenerfassung!B42<>\"\",\"WAHR\",\"FALSCH\")","v":"FALSCH"},{"$f":"CONCATENATE(Datenerfassung!E32,\"/\",TEXT(Datenerfassung!G32,\"0\"))","v":"/0"},{"$f":"IF(Datenerfassung!E34<>\"\",CONCATENATE(Datenerfassung!E34,\"/\",TEXT(Datenerfassung!G34,\"0\")),\"\")","v":""},{"$f":"IF(Datenerfassung!E36<>\"\",CONCATENATE(Datenerfassung!E36,\"/\",TEXT(Datenerfassung!G36,\"0\")),\"\")","v":""},{"$f":"IF(Datenerfassung!F40<>\"\",Datenerfassung!F40,\"\")","v":""},{"$f":"IF(Datenerfassung!E38<>\"\",CONCATENATE(Datenerfassung!E38,\"@\",Datenerfassung!K38),\"\")","v":""}]
[]
[{"$nulls":8},"Ortsschlüsselauslesung:"]
[]
["VD_Nr","VD_Organisation","Bank",null,"IBAN","BIC"]
[{"$f":"CONCATENATE(\"07/\",TEXT(Datenerfassung!C14,\"0000\"))","v":"07/0000"},{"$f":"Datenerfassung!E14","v":{"$error":"#N/A"}},{"$f":"Datenerfassung!E48","v":0},null,{"$f":"Datenerfassung!E50","v":0},{"$f":"Datenerfassung!M48","v":0}]
[]
["VD_Nr","VD_Organisation","Ansprechpartner AUSBILDUNG",null,"Telefon","eMail",null,"Ansprechpartner JUGEND",null,null,"Telefon","eMail",null,"Inklusion (Tge - ja)","Inklusion (TAusb - ja)"]
[{"$f":"CONCATENATE(\"07/\",TEXT(Datenerfassung!C14,\"0000\"))","v":"07/0000"},{"$f":"Datenerfassung!E14","v":{"$error":"#N/A"}}]

{"sheet":"DATEN","index":3,"n_rows":85,"n_cols":7,"rows_kept":85,"hidden":true}
["Ortsschlüssel \"Auslesung\"",{"$nulls":3},"Vereine"]
["BSL - Braunschweig (Umland)","BSL",11,null,"07/0151","TC Qualle Braunschweig","07/0151"]
["BSS - Braunschweig (Stadt)","BSS",10,null,"07/0160","TC Stelle","07/0160"]
["CXS - Cuxhaven (Stadt)","CXS",15,null,"07/0165","SV Munster - Abt. Tauchen -","07/0165"]
["ELM - Emsland (Mittleres)","ELM",33,null,"07/0166","TG Waspo Hannover","07/0166"]
["ELN - Emsland (Nördliches)","ELN",44,null,"07/0167","TC Hydra Lingen","07/0167"]
["ELS - Emsland (Südliches)","ELS",32,null,"07/0168","DUC Salzgitter-Bad","07/0168"]
["GÖT - Göttingen (Region)","GÖT",23,null,"07/0169","TUW Nordland","07/0169"]
["HBR - Bremen (Region)","HBR",17,null,"07/0170","WSV Burkana - Abt. Tauchen -","07/0170"]
["HHR - Hamburg (Region)","HHR",12,null,"07/0171","UC Hannover","07/0171"]
["HIL - Hildesheim (Umland)","HIL",24,null,"07/0172","TG Jugenddorf  - Abt. Tauchen -","07/0172"]
["HIS - Hildesheim (Stadt)","HIS",28,null,"07/0173","TSC Gifhorn","07/0173"]
["HLA - Hannover (Umland)","HLA",4,null,"07/0174","TC Barakuda Mellendorf","07/0174"]
["HSA - Hannover (Stadt)","HSA",27,null,"07/0175","USC Seegurke Göttingen","07/0175"]
["HÜM - Hümmling","HÜM",53,null,"07/0176","TC Wolfsburg","07/0176"]
["HZR - Harz (Region)","HZR",2,null,"07/0177","Harzer TG Altenau","07/0177"]
["LBH - Lüneburger Heide","LBH",9,null,"07/0178","Osteroder TC","07/0178"]
["LBL - Leinebergland","LBL",19,null,"07/0179","UWC Manta Wilhelmshaven","07/0179"]
["OFI - Ostfries. Inseln","OFI",6,null,"07/0180","TC Cuxhaven","07/0180"]
["OFL - Ostfriesland","OFL",3,null,"07/4000","PSV Oldenburg - Abt. Tauchen -","07/4000"]
["OLL - Oldenburg (Land)","OLL",42,null,"07/4001","UC Osnabrück","07/4001"]
["OLS - Oldenburg (Stadt)","OLS",41,null,"07/4006","TC Hannover","07/4006"]
["OML - Oldenburger Münsterland","OML",14,null,"07/4021","TG Papenburg","07/4021"]
["OSL - Osnabrück (Umland)","OSL",7,null,"07/4030","Delmenhorster Sporttaucher","07/4030"]
["OSS - Osnabrück (Stadt)","OSS",13,null,"07/4067","Emder TC Delphin","07/4067"]
["SAT - Saterland","SAT",43,null,"07/4073","USC Braunschweig - Abt. Tauchen -","07/4073"]
["SCH - Schaumburger Land","SCH",54,null,"07/4095","Eintracht Hildesheim - Abt. Tauchen -","07/4095"]
["SHM - Steinhuder Meer (Region)","SHM",37,null,"07/4121","TC Neustadt","07/4121"]
["SZR - Salzgitter (Region)","SZR",46,null,"07/4130","TSV Gronau - Abt. Tauchen -","07/4130"]
["WBL - Weserbergland","WBL",21,null,"07/4134","TSC Wunstorf","07/4134"]
["WBL - Wolfsburg (Umland)","WBL",29,null,"07/4135","TSV Anderten - Abt. Tauchen -","07/4135"]
["WBS - Wolfsburg (Stadt)","WBS",31,null,"07/4136","VfL Wolfsburg Diving Team","07/4136"]
["WHV - Wilhelmshaven (Stadt)","WHV",49,null,"07/4137","Heidjer TC Celle","07/4137"]
[{"$nulls":4},"07/4138","TC Schloapmütz-Divers","07/4138"]
[{"$nulls":4},"07/4139","SSV UNION 06 - Abt. Tauchen -","07/4139"]
[{"$nulls":4},"07/4141","VSK 1848 OHZ - Abt. Tauchen -","07/4141"]
[{"$nulls":4},"07/4143","UWR-Club Salzgitter","07/4143"]
[{"$nulls":4},"07/4144","TC Delphin Cloppenburg","07/4144"]
[{"$nulls":4},"07/4145","TC Schaumburg","07/4145"]
[{"$nulls":4},"07/4146","HSV 1892 - Abt. Tauchen -","07/4146"]
[{"$nulls":4},"07/4147","Triton Diving Club Celle","07/4147"]
[{"$nulls":4},"07/4149","Wasserfreunde Bispingen","07/4149"]
[{"$nulls":4},"07/4150","TWG 1861 Göttingen - Abt. Tauchen -","07/4150"]
[{"$nulls":4},"07/4151","Wissenschaftliche TG Clausthal","07/4151"]
[{"$nulls":4},"07/4152","Hamelner TC","07/4152"]
[{"$nulls":4},"07/4153","SG Diepholz - Abt. Tauchen -","07/4153"]
[{"$nulls":4},"07/4154","TC Bad Harzburg","07/4154"]
[{"$nulls":4},"07/4156","MTV Freiheit - Abt. Tauchen -","07/4156"]
[{"$nulls":4},"07/4158","1. Uelzer Tauchvereinigung","07/4158"]
[{"$nulls":4},"07/4159","TC Beluga Aurich","07/4159"]
[{"$nulls":4},"07/4160","Barakuda Club Uelzen","07/4160"]
[{"$nulls":4},"07/4163","Dive Team Lohnde","07/4163"]
[{"$nulls":4},"07/4164","TC Ulendiver Peine","07/4164"]
[{"$nulls":4},"07/4166","OLDENBURGER DELPHINE Tauchsport","07/4166"]
[{"$nulls":4},"07/4167","TC Nautilus Braunschweig","07/4167"]
[{"$nulls":4},"07/4169","TSG Emmerthal - Abt. Tauchen -","07/4169"]
[{"$nulls":4},"07/4170","Göttinger Skizunft - Abt. Tauchen -","07/4170"]
[{"$nulls":4},"07/4171","TSV Friesen Hänigsen Tauchen","07/4171"]
[{"$nulls":4},"07/4172","TSC Einbeck","07/4172"]
[{"$nulls":4},"07/4173","TG Pulpo","07/4173"]
[{"$nulls":4},"07/4174","Tauchgemeinschaft Lingen","07/4174"]
[{"$nulls":4},"07/4175","Tauchclub Manati","07/4175"]
[{"$nulls":4},"07/4176","Tauchgemeinschaft Beluga","07/4176"]
[{"$nulls":4},"07/4178","Tauchclub Seestern","07/4178"]
[{"$nulls":4},"07/4179","Tauchsport u. Umwelt Osnabrück","07/4179"]
[{"$nulls":4},"07/4180","Haubentaucher Emden","07/4180"]
[{"$nulls":4},"07/4182","TC Barsinghausen","07/4182"]
[{"$nulls":4},"07/4183","TC Longimanus","07/4183"]
[{"$nulls":4},"07/4184","TC Lindhorst","07/4184"]
[{"$nulls":4},"07/4185","TSC Bramsche","07/4185"]
[{"$nulls":4},"07/4186","Oldenburger Yachtclub - Abt. Tauchen -","07/4186"]
[{"$nulls":4},"07/4187","TG v. 1848 Northeim - Abt. Tauchen -","07/4187"]
[{"$nulls":4},"07/4188","TSG Scubi","07/4188"]
[{"$nulls":4},"07/4189","Beluga Oldenburg","07/4189"]
[{"$nulls":4},"07/4191","TC Hibaru","07/4191"]
[{"$nulls":4},"07/4192","Taucherflöhe Emsland","07/4192"]
[{"$nulls":4},"07/4193","TKW Tauchteam Nienburg","07/4193"]
[{"$nulls":4},"07/4194","Barakuda Club Hannover","07/4194"]
[{"$nulls":4},"07/4195","Lazy Divers Oldenburg","07/4195"]
[{"$nulls":4},"07/4196","TC Hai-Society Lingen","07/4196"]
[{"$nulls":4},"07/4198","Hümmlinger Tauchclub","07/4198"]
[{"$nulls":4},"07/4199","Freedivers Göttingen","07/4199"]
[{"$nulls":4},"07/4200","TC Seeigel","07/4200"]
[{"$nulls":4},"07/4201","TC Koralle","07/4201"]
[{"$nulls":4},"07/4202","Ivans TC","07/4202"]