{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Eingabemaske","Datenbank","Tabelle1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Eingabemaske","index":0,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[35,4,35,7],[37,4,37,5],[39,4,39,5],[29,4,29,5],[31,4,31,5],[17,6,17,7],[19,4,19,7],[21,4,21,7],[23,4,23,5],[25,4,25,7]]}
["Reg.Nr.","Anrede","Titel","Vorname","Name","Geburtsdatum","Geburtsort","Beruf","Email","Straße priv.","Nr. priv.","PLZ priv.","Ort priv.","Arbeitgeber","Straße Ag.","Nr. Ag.","PLZ Ag.","Ort Ag.","Kommentarfeld ","Datum Zert.Erteilung","Re-Zertifizierung ","Gültigkeitsdauer","Rechnungsadresse","Geburtsland"]
[null,{"$f":"IF(A18=\"\",\"\",A18)","v":""},{"$f":"IF(C18=\"\",\"\",C18)","v":""},{"$f":"IF(E18=\"\",\"\",E18)","v":""},{"$f":"IF(G18=\"\",\"\",G18)","v":""},{"$f":"IF(E22=\"\",\"\",E22)","v":""},{"$f":"IF(E24=\"\",\"\",E24)","v":""},{"$f":"IF(E26=\"\",\"\",E26)","v":""},{"$f":"IF(E20=\"\",\"\",E20)","v":""},{"$f":"IF(E30=\"\",\"\",E30)","v":""},{"$f":"IF(H30=\"\",\"\",H30)","v":""},{"$f":"IF(H32=\"\",\"\",H32)","v":""},{"$f":"IF(E32=\"\",\"\",E32)","v":""},{"$f":"IF(E36=\"\",\"\",E36)","v":""},{"$f":"IF(E38=\"\",\"\",E38)","v":""},{"$f":"IF(H38=\"\",\"\",H38)","v":""},{"$f":"IF(H40=\"\",\"\",H40)","v":""},{"$f":"IF(E40=\"\",\"\",E40)","v":""},null,null,null,null,null,{"$f":"IF(H24=\"\",\"\",H24)","v":"Deutschland"}]
[null,"Feld erforderlich"]
[null,"x",null,"x","x",null,null,null,"x",null,null,null,null,{"$f":"IF($W$2=Tabelle1!$C$5,\"x\",\"\")","v":""},{"$f":"IF($W$2=Tabelle1!$C$5,\"x\",\"\")","v":""},{"$f":"IF($W$2=Tabelle1!$C$5,\"x\",\"\")","v":""},{"$f":"IF($W$2=Tabelle1!$C$5,\"x\",\"\")","v":""},{"$f":"IF($W$2=Tabelle1!$C$5,\"x\",\"\")","v":""}]
[]
[null,"Pflichteingabe fehlend?"]
[null,{"$f":"IF(AND(B4=\"x\",B2=\"\"),1,0)","v":1},{"$f":"IF(AND(C4=\"x\",C2=\"\"),1,0)","v":0},1,1,{"$f":"IF(AND(F4=\"x\",F2=\"\"),1,0)","v":0},0,0,1,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF(AND(X4=\"x\",X2=\"\"),1,0)","v":0}]
[]
["Anzahl unvollständiger Pflichteingaben",{"$f":"SUM(7:7)","v":4}]
["Erfassung"]
[]
[]
[]
[]
["Persönliche Daten "]
[]
["Anrede*",null,"Titel",null,"Vorname*",null,"Nachname*"]
[]
[]
["E-Mail-Adresse*"]
[]
["Geburtsdatum (DD.MM.JJJJ)*"]
[]
["Geburtsort *",null,null,null,null,null,"Geburtsland*","Deutschland"]
[]
["Beruf / Berufsausbildung*"]
[]
["Private Anschrift "]
[]
["Straße*",null,null,null,null,null,"Nr. *"]
[]
["Wohnort*",null,null,null,null,null,"PLZ*"]
[]
["Angaben Arbeitgeber "]
[]
["Name Arbeitgeber"]
[]
["Straße Arbeitgeber",null,null,null,null,null,"Nr. "]
[]
["Ort Arbeitgeber",null,null,null,null,null,"PLZ"]
[]
[]
[]
[]
[]
[]
["* = Pflichteingabe"]

{"sheet":"Datenbank","index":1,"n_rows":1,"n_cols":24,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Reg. Nr. ","Anrede","Titel","Vorname","Name","Geburtsdatum","Geburtsort","Beruf","E-Mail","Straße priv.","Nr. priv.","PLZ priv.","Ort priv.","Arbeitgeber","Straße Ag.","Nr. Ag.","PLZ Ag.","Ort Ag.","Kommentarfeld ","Datum Zert.Erteilung","Re-Zertifizierung ","Gültigkeitsdauer","Rechnungsadresse","Geburtsland"]

{"sheet":"Tabelle1","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Frau","Privatanschrift"]
[null,"Herr","Arbeitgeber"]
[null," "]