{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Personalfragebogen","Assistent","Listen","Listen (englisch)","Logo","Verwaltung"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":2,"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":"Personalfragebogen","index":0,"n_rows":351,"n_cols":41,"rows_kept":351,"cut":false,"hidden":false,"merged":[[32,3,32,35],[34,3,36,35],[31,39,31,47],[32,39,32,47],[34,39,36,47],[43,3,43,23],[61,21,61,23],[62,21,62,23],[13,3,13,23],[14,3,14,23],[16,3,18,23],[20,3,22,23],[24,3,26,23],[31,3,31,35],[44,3,44,23],[46,3,48,23],[43,27,43,47],[44,27,44,47],[46,27,48,47],[61,27,61,29],[62,27,62,29],[64,27,66,29],[53,3,53,23],[55,3,57,23],[52,27,52,47],[53,27,53,47],[55,27,57,47],[61,3,61,19],[61,31,61,47],[52,3,52,23],[79,3,79,23],[80,3,80,23],[82,3,84,23],[79,27,79,47],[80,27,80,47],[82,27,84,47],[62,31,62,47],[64,31,66,47],[70,3,70,23],[71,3,71,23],[73,3,75,23],[70,27,70,47],[71,27,71,47],[73,27,75,47],[62,3,62,19],[64,3,66,19],[64,21,66,23],[106,3,106,23],[107,3,107,23],[109,3,111,23],[106,27,106,47],[107,27,107,47],[109,27,111,47],[88,27,88,47],[89,27,89,47],[91,27,93,47],[97,3,97,23],[98,3,98,23],[100,3,102,23],[97,27,97,47],[98,27,98,47],[100,27,102,47],[88,3,88,11],[89,3,89,11],[91,3,93,11],[88,15,88,23],[89,15,89,23],[91,15,93,23],[118,27,118,47],[119,27,119,47],[121,27,123,47],[127,3,127,23],[128,3,128,23],[130,3,132,23],[127,27,127,47],[128,27,128,47],[130,27,132,47],[118,3,118,11],[119,3,119,11],[121,3,123,11],[118,15,118,23],[119,15,119,23],[121,15,123,23],[136,39,136,47],[137,39,137,47],[139,39,141,47],[145,3,145,23],[146,3,146,23],[148,3,150,23],[145,27,145,47],[146,27,146,47],[148,27,150,47],[136,3,136,23],[137,3,137,23],[139,3,141,23],[136,27,136,35],[137,27,137,35],[139,27,141,35],[163,3,163,23],[164,3,164,23],[166,3,168,23],[163,27,163,47],[164,27,164,47],[166,27,168,47],[154,3,154,23],[155,3,155,23],[157,3,159,23],[154,27,154,47],[155,27,155,47],[157,27,159,47],[172,27,172,47],[173,27,173,47],[175,27,177,47],[181,3,181,47],[182,3,182,47],[184,3,186,3],[184,4,186,11],[184,15,186,15],[184,16,186,23],[184,27,186,27],[172,3,172,11],[173,3,173,11],[175,3,177,11],[172,15,172,23],[173,15,173,23],[175,15,177,23],[184,28,186,35],[184,39,186,39],[184,40,186,47],[188,3,190,3],[188,4,190,11],[188,15,190,15],[188,16,190,23],[188,27,190,27],[188,28,190,35],[203,3,203,23],[204,3,204,23],[206,3,208,23],[203,27,203,47],[204,27,204,47],[206,27,208,47],[194,3,194,23],[195,3,195,23],[197,3,199,23],[194,27,194,47],[195,27,195,47],[197,27,199,47],[224,3,224,23],[225,3,225,23],[227,3,229,23],[224,27,224,47],[225,27,225,47],[227,27,229,47],[215,3,215,23],[216,3,216,23],[218,3,220,23],[215,27,215,47],[216,27,216,47],[218,27,220,47],[236,27,236,35],[237,27,237,35],[239,27,241,35],[236,39,236,47],[237,39,237,47],[239,39,241,47],[236,3,236,11],[237,3,237,11],[239,3,241,11],[236,15,236,23],[237,15,237,23],[239,15,241,23],[257,3,257,23],[258,3,258,23],[260,3,262,23],[257,27,257,47],[258,27,258,47],[260,27,262,47],[245,3,245,23],[246,3,246,23],[248,3,250,23],[245,27,245,47],[246,27,246,47],[248,27,250,47],[266,27,266,35],[267,27,267,35],[269,27,271,35],[266,39,266,47],[267,39,267,47],[269,39,271,47],[266,3,266,11],[267,3,267,11],[269,3,271,11],[266,15,266,23],[267,15,267,23],[269,15,271,23],[288,19,288,23],[290,19,292,23],[287,27,287,35],[288,27,288,35],[290,27,292,35],[287,39,287,47],[288,39,288,47],[290,39,292,47],[275,3,275,23],[276,3,276,23],[278,3,280,23],[287,3,287,7],[288,3,288,7],[290,3,292,7],[287,11,287,15],[288,11,288,15],[290,11,292,15],[287,19,287,23],[296,39,296,47],[297,39,297,47],[299,39,301,47],[308,3,308,23],[309,3,309,23],[311,3,313,23],[308,27,308,35],[309,27,309,35],[311,27,313,35],[308,39,308,47],[296,19,296,23],[297,19,297,23],[299,19,301,23],[296,27,296,35],[297,27,297,35],[299,27,301,35],[296,3,296,7],[297,3,297,7],[299,3,301,7],[296,11,296,15],[297,11,297,15],[299,11,301,15],[326,3,326,23],[327,3,327,23],[329,3,331,23],[326,27,326,47],[327,27,327,47],[329,27,331,47],[309,39,309,47],[311,39,313,47],[317,3,317,23],[318,3,318,23],[320,3,322,23],[317,27,317,47],[318,27,318,47],[320,27,322,47],[338,19,338,35],[339,19,339,35],[341,19,343,35],[338,39,338,47],[339,39,339,47],[341,39,343,47],[338,3,338,7],[339,3,339,7],[341,3,343,7],[338,11,338,15],[339,11,339,15],[341,11,343,15],[347,19,347,35],[348,19,348,35],[350,19,352,35],[347,39,347,47],[348,39,348,47],[350,39,352,47],[347,3,347,7],[348,3,348,7],[350,3,352,7],[347,11,347,15],[348,11,348,15],[350,11,352,15]]}
[]
[]
[null,null,null,"Personalfragebogen"]
[]
[null,null,null,"Die mit diesem Balken gekennzeichneten Felder sind"]
[null,null,null,"vom Arbeitgeber auszufüllen"]
[]
[null,null,null,"Die rot umrahmten Felder sind für das Erzeugen einer Exportdatei zwingend erforderlich"]
[]
[]
[]
[]
[]
[null,null,null,"Firma"]
[]
[]
[null,null,null,""]
[]
[]
[]
[null,null,null,""]
[]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[]
[null,null,null,"Name des Mitarbeiters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personalnummer"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Persönliche Angaben"]
[]
[]
[null,null,null,"Familienname",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorname"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Geburtsname",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geburtsdatum (TT.MM.JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Straße",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hausnr.",null,null,null,null,null,"PLZ",null,null,null,"Ort"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Anschriftenzusatz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versicherungsnummer gem. Sozialvers.-Ausweis"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Geburtsort (nur bei fehlender Versicherungs-Nr.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geburtsland (nur bei fehlender Versicherungs-Nr.)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Geschlecht",null,null,null,null,null,null,null,null,null,null,null,"Familienstand",null,null,null,null,null,null,null,null,null,null,null,"Staatsangehörigkeit"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Schwerbehindert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arbeitnehmernummer Sozialkasse - Bau"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIC"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Beschäftigung"]
[]
[]
[null,null,null,"Eintrittsdatum (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,"Ersteintrittsdatum (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,"Beschäftigungsbetrieb"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Berufsbezeichnung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgeübte Tätigkeit (Kennziffer gem. BA oder Bezeichnung)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Art der Beschäftigung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probezeit",null,null,null,null,null,null,null,null,null,null,null,"Dauer der Probezeit"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Üben Sie weitere Beschäftigungen aus?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handelt es sich hierbei um eine geringfügige Beschäftigung?"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Höchster Schulabschluss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Höchste Berufsausbildung"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Beginn der Ausbildung (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voraussichtliches Ende der Ausbildung (TT.MM.JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Wöchentliche Arbeitszeit",null,null,null,null,null,null,null,null,null,null,null,"Urlaubsanspruch (Kalenderjahr)",null,null,null,null,null,null,null,null,null,null,null,"Vertragsform"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Ggf. Verteilung der wöchentlichen Arbeitszeit (Std.)"]
[]
[]
[null,null,null,"Mo","",null,null,null,null,null,null,null,null,null,null,"Di","",null,null,null,null,null,null,null,null,null,null,"Mi","",null,null,null,null,null,null,null,null,null,null,"Do",""]
[]
[]
[]
[null,null,null,"Fr","",null,null,null,null,null,null,null,null,null,null,"Sa","",null,null,null,null,null,null,null,null,null,null,"So",""]
[]
[]
[]
[]
[]
[null,null,null,"Kostenstelle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abteilungsnummer"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Im Baugewerbe beschäftigt seit (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personengruppe"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Befristung"]
[]
[]
[null,null,null,"Art der Befristung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Befristung Arbeitsvertrag zum (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abschluss Arbeitsvertrag am (TT.MM.JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Steuer"]
[]
[]
[null,null,null,"Finanzamtsnummer",null,null,null,null,null,null,null,null,null,null,null,"Identifikationsnummer",null,null,null,null,null,null,null,null,null,null,null,"Steuerklasse",null,null,null,null,null,null,null,null,null,null,null,"Faktor"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Kinderfreibetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Konfession"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Sozialversicherung"]
[]
[]
[null,null,null,"Gesetzl. Krankenkasse (bei PKV: letzte ges. Krankenkasse)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elterneigenschaft"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"KV",null,null,null,null,null,null,null,null,null,null,null,"RV",null,null,null,null,null,null,null,null,null,null,null,"AV",null,null,null,null,null,null,null,null,null,null,null,"PV"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"UV-Gefahrtarif"]
[]
[]
[null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Entlohnung"]
[]
[]
[null,null,null,"Bezeichnung",null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)",null,null,null,null,null,null,null,"Stundenlohn",null,null,null,null,null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Bezeichnung",null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)",null,null,null,null,null,null,null,"Stundenlohn",null,null,null,null,null,null,null,null,null,null,null,"gültig ab (MM/JJJJ)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"VWL - nur notwendig, wenn Vertrag vorliegt"]
[]
[]
[null,null,null,"Empfänger VWL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betrag",null,null,null,null,null,null,null,null,null,null,null,"AG-Anteil (Höhe monatlich)"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"seit wann (TT.MM.JJJJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vertragsnummer"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIC"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Angaben zu steuerpflichtigen Vorbeschäftigungszeiten im laufenden Kalenderjahr"]
[]
[]
[null,null,null,"von (TT.MM.JJJJ)",null,null,null,null,null,null,null,"bis (TT.MM.JJJJ)",null,null,null,null,null,null,null,"Art der Beschäftigung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl der Beschäftigungstage"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"von (TT.MM.JJJJ)",null,null,null,null,null,null,null,"bis (TT.MM.JJJJ)",null,null,null,null,null,null,null,"Art der Beschäftigung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl der Beschäftigungstage"]
[]
[]
[null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Assistent","index":1,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
["Firma","Company name",null,null,"D17;D21;D25",null,";;"]
["Name des Mitarbeiters, Personalnummer","Employee name, Personnel number",null,null,"D35;AN35",null,";"]
["Familienname","Surname",null,null,"D47",null,""]
["Vorname","Given name",null,null,"AB47",null,""]
["Geburtsname","Maiden name",null,null,"D56",null,""]
["Geburtsdatum (TT.MM.JJJJ)","Date of birth (DD.MM.YYYY)",null,null,"AB56",null,""]
["Straße, Hausnr.","Street, House No.",null,null,"D65;V65",null,";"]
["PLZ, Ort","Postcode, City",null,null,"AB65;AF65",null,";"]
["Anschriftenzusatz","Additional information",null,null,"D74",null,""]
["Versicherungsnummer gem. Sozialvers.-Ausweis","Insurance number (as per social insurance card)",null,null,"AB74",null,""]
["Geburtsort (nur bei fehlender Versicherungs-Nr.)","Place of birth (only if without insurance number)",null,null,"D83",null,""]
["Geburtsland (nur bei fehlender Versicherungs-Nr.)","Country of birth (only if without insurance number)",null,null,"AB83",null,""]
["Geschlecht, Familienstand","Gender, Marital status","False","True","D92;P92","15,75;483",";",null,"cbx_Geschlecht;cbx_Familienstand"]
["Staatsangehörigkeit","Nationality",null,null,"AB92",null,""]
["Schwerbehindert","Severely disabled","True","True","D101","15,75;524,25",null,null,"cbx_Schwerbehindert"]
["Arbeitnehmernummer Sozialkasse - Bau","Employee number, pension fund - construction",null,null,"AB101",null,""]
["Kontonummer Bankleitzahl","Bank account number Sort code"]
["Bankbezeichnung","Name of bank institute"]
["IBAN","IBAN",null,null,"D110",null,""]
["BIC","BIC",null,null,"AB110",null,""]
[]
["Eintrittsdatum Ersteintrittsdatum","Date employment contract begins First day",null,null,"D122;P122",null,";"]
["Beschäftigungsbetrieb","Place of employment","True",null,"AB122",null,""]
["Berufsbezeichnung","Description of profession",null,null,"D131",null,""]
["Ausgeübte Tätigkeit (Kennziffer gem. BA oder Bezeichnung)","Job performed","True",null,"AB131",null,""]
["Art der Beschäftigung","Type of employment","False","True","D140","15,75;714,75",null,null,"cbx_Art_der_Beschaeftigung"]
["Probezeit","Probation period","True","True","AB140;AN140","348,75;714,75",null,null,"cbx_Probezeit"]
["Üben Sie weitere Beschäftigungen aus?","Do you carry out any other jobs?","False","True","D149","15,75;756",null,null,"cbx_Nebenbeschaeftigung"]
["Handelt es sich hierbei um eine geringfügige Beschäftigung?","Does this concern a low income employment?","False","True","AB149","348,75;756",null,null,"cbx_Geringfuegig"]
["Höchster Schulabschluss","Highest level of education","False","True","D158","15,75;797,25",null,null,"cbx_Schulabschluss"]
["Höchste Berufsausbildung","Highest level of professional training","False","True","AB158","348,75;797,25",null,null,"cbx_Berufsausbildung"]
["Beginn der Ausbildung (TT.MM.JJJJ)","Date apprenticeship begins (DD.MM.YYYY)",null,null,"D167",null,""]
["Voraussichtliches Ende der Ausbildung (TT.MM.JJJJ)","Planned date apprenticeship ends (DD.MM.YYYY)",null,null,"AB167",null,""]
["Wöchentliche Arbeitszeit Urlaubsanspruch","Weekly working hours Holiday entitlement",null,null,"D176;P176",null,";"]
["Vertragsform","Type of contract","True","True","AB176","348,75;879,75",null,null,"cbx_Vertragsform"]
["Wöchentliche Arbeitszeit","Weekly working hours",null,null,"E185;Q185;AC185;AO185;E189;Q189;AC189",null,";;;;;;"]
["Kostenstelle","Cost centre","True",null,"D198",null,""]
["Abteilungsnummer","Department number","True",null,"AB198",null,""]
["Im Baugewerbe beschäftigt seit (TT.MM.JJJJ)","Employed in construction industry since (DD.MM.YYYY)",null,null,"D207",null,""]
["Personengruppe","Person group","True","True","AB207","348,75;1027,5",null,null,"cbx_Personengruppe"]
[]
["Art der Befristung","Type of fixed-term contract","True","True","D219","15,75;1094,25",null,null,"cbx_Art_der_Befristung"]
[" "," ","True","True","AB219","348,75;1094,25",";"]
["Befristung Arbeitsvertrag zum (TT.MM.JJJJ)","Employment contract fixed until (DD.MM.YYYY)","True",null,"D228",null,""]
["Abschluss Arbeitsvertrag am (TT.MM.JJJJ)","Employment contract concluded on (DD.MM.YYYY)","True",null,"AB228",null,""]
[]
[]
["Finanzamtsnummer Identifikationsnummer","Tax office No. Identification No.",null,null,"D240;P240",null,";"]
["Steuerklasse, Faktor","Tax class, Factor",null,null,"AB240;AN240",null,";"]
["Kinderfreibetrag","Number of exemptions for children",null,null,"D249",null,""]
["Konfession","(Religious) Denomination","False","True","AB249","348,75;1243,5",null,null,"cbx_Konfession"]
[]
[]
["Gesetzl. Krankenkasse (bei PKV: letzte ges. Krankenkasse)","Statutory health insurance (HI) (in case of private HI: last statutory HI)",null,null,"D261",null,""]
[]
["Elterneigenschaft","Parenthood","False","True","AB261","348,75;1310,25",null,null,"cbx_Elterneigenschaft"]
["KV RV","Health insureance Pension insurance","True","True","D270;P270","15,75;1351,5",";",null,"cbx_KV;cbx_RV"]
["AV PV","Retirement insurance Provision insurance","True","True","AB270;AN270","348,75;1351,5",";",null,"cbx_AV;cbx_PV"]
["UV-Gefahrtarif","Accident insurance risk tariff","True",null,"D279",null,""]
[]
[]
[]
["Entlohnung","Remuneration",null,null,"D291;L291;T291;AB291;AN291",null,";;;;"]
["Entlohnung 2","Remuneration 2",null,null,"D300;L300;T300;AB300;AN300",null,";;;;"]
[]
[]
[]
[]
[]
[]
["Empfänger VWL","Recipient",null,null,"D312",null,""]
["Betrag, AG-Anteil","Amount Employer share",null,null,"AB312;AN312",null,";"]
["seit wann (TT.MM.JJJJ)","since (DD.MM.YYYY)",null,null,"D321",null,""]
["Vertragsnummer","Contract number",null,null,"AB321",null,""]
["Kontonummer Bankleitzahl","Bank account number Sort code"]
["Bankbezeichnung","Name of bank institute"]
["IBAN","IBAN",null,null,"D330",null,""]
["BIC","BIC",null,null,"AB330",null,""]
["Angaben zu steuerpflichtigen Vorbeschäftigungszeiten","Information of taxable previous employment periods",null,null,"D342;L342;T342;AN342",null,";;;"]
["Angaben zu steuerpflichtigen Vorbeschäftigungszeiten 2","Information of taxable previous employment periods 2",null,null,"D351;L351;T351;AN351",null,";;;"]
[]
[]
[]
[]
[]
[]
[]
[]
["Bea","Bea",null,null,"AN364:AV364",1813.5]

{"sheet":"Listen","index":2,"n_rows":24,"n_cols":30,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Arbeitsvertrag","Arbeitsvertrag","Ausbildungsvertrag"]
["Bescheinigung über LSt.-Abzug","Bescheinigung über LSt.-Abzug/Anzahl der Beschäftigungstage bei Vorarbeitgebern","Bescheinigung über LSt.-Abzug","männlich","ledig","ja","ja","Hauptbeschäftigung","ja","ja","ja","1 - Ohne Schulabschluss","1 - Ohne beruflichen Ausbildungsabschluss","1 - Unbefristet in Vollzeit","101 - Sozialversicherungspflichtig Beschäftigte","Arbeitnehmer/in","Befristet","Konfessionslos",0.02,"ja","ja","0 - Kein Beitrag","0 - Kein Beitrag","0 - Kein Beitrag zur BA","0 - Kein Beitrag zur gesetzlichen PV","Verzicht auf die RV-Option","Gesetzlich","geringfügig entlohnt","ja","ja"]
["SV-Ausweis","SV-Ausweis","SV-Ausweis","weiblich","verheiratet","nein","nein","Nebenbeschäftigung","nein","nein","nein","2 - Haupt-/Volksschulabschluss","2 - Abschluss einer anerkannten Berufsausbildung","2 - Unbefristet in Teilzeit","102 - Auszubildende ohne besondere Merkmale","Arbeitnehmer/in in Elternzeit","Unbefristet","rk - Römisch-Katholische Kirchensteuer",0.2,"nein","nein","1 - Allgemeiner Beitrag","1 - Beitrag zur Rentenversicherung","1 - Voller Beitrag zur BA","1 - Voller Beitrag zur gesetzlichen PV","Ausübung der RV-Option (Verzicht auf RV-Freiheit)","Privat","nicht geringfügig entlohnt","nein","nein"]
["Mitgliedsbescheinigung Krankenkasse","Antrag zur Befreiung von der RV-Pflicht","Mitgliedsbescheinigung Krankenkasse",null,"geschieden",null,null,null,null,null,null,"3 - Mittlere Reife oder gleichwertiger Abschluss","3 - Meister-/Techniker- oder gleichwertiger Fachschulabschluss","3 - Befristet in Vollzeit","103 - Beschäftigte in Altersteilzeit","Arbeitslose/r","Zweckbefristet","ev - Evangelische Kirchensteuer",null,null,null,"3 - Ermäßigter Beitrag","3 - 1/2 Beitrag zur Rentenversicherung","2 - Halber Beitrag zur BA","2 - Halber Beitrag zur gesetzlichen PV",null,null,"kurzfristig beschäftigt"]
["Bescheinigung der privaten Krankenversicherung","Bescheinigung der privaten Krankenversicherung","VWL-Vertrag",null,"verwitwet",null,null,null,null,null,null,"4 - Abitur/Fachabitur","4 - Bachelor","4 - Befristet in Teilzeit","104 - Hausgewerbetreibende","Beamtin/Beamter",null,"lt - Evangelisch lutherisch",null,null,null,"4 - Beitrag zur landwirtschaftlichen KV","5 - Geringfügig entlohnt"]
["VWL-Vertrag","VWL-Vertrag","Nachweis Elterneigenschaft",null,"dauernd getrennt",null,null,null,null,null,null,"9 - Abschluss unbekannt","5 - Diplom/Magister/Master/Staatsexamen",null,"105 - Praktikanten","Hausfrau/Hausmann",null,"rf - Evangelisch reformiert",null,null,null,"5 - Arbeitgeberbeitrag zur landwirtschaftlichen KV"]
["Nachweis Elterneigenschaft","Schul-/Studienbescheinigung","Vertrag Betriebliche Altersversorgung",null,null,null,null,null,null,null,null,null,"6 - Promotion",null,"106 - Werkstudenten","Schüler/in",null,"ak - Altkatholische Kirchensteuer",null,null,null,"6 - Pauschalbetrag für geringfügig Beschäftigte"]
["Vertrag Betriebliche Altersversorgung","Schwerbehindertenausweis","Schwerbehindertenausweis",null,null,null,null,null,null,null,null,null,"9 - Abschluss unbekannt",null,"107 - Behinderte Menschen in anerkannten Werkstätten oder gleichartigen Einrichtungen","Schulentlassene/r",null,"is - Israelitische / Jüdische Kultussteuer",null,null,null,"9 - Freiwillige KV, Firmenzahler"]
["Schwerbehindertenausweis","Unterlagen Sozialkasse Bau/Maler","Unterlagen Sozialkasse Bau/Maler",null,null,null,null,null,null,null,null,null,null,null,"108 - Bezieher von Vorruhestandsgeld","Selbstständige/r",null,"fb - Freireligiöse Landesgemeinde Baden"]
["Unterlagen Sozialkasse Bau/Maler",null,null,null,null,null,null,null,null,null,null,null,null,null,"109 - Geringfügig entlohnte Beschäftigte","Student/in",null,"ib - Israelitische Religionsgemeinschaft Baden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"110 - Kurzfristig Beschäftigte","Sozialhilfeempfänger/in",null,"fo - Freireligiöse Gemeinde Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"111 - Personen in berufsfördernden Maßnahmen zur Rehabilitation","Studienbewerber/in",null,"fp - Freireligiöse Landesgemeinde Pfalz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"112 - Mitarbeitende Familienangehörige in der Landwirtschaft","Wehr-/Zivildienstleistender",null,"fm - Freireligiöse Gemeinde Mainz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"113 - Nebenerwerbslandwirte",null,null,"jü - Jüdisch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"114 - Nebenerwerbslandwirte - saisonal beschäftigt",null,null,"iw - Israelitische Religionsgemeinschaft Württembergs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116 - Ausgleichsgeldempfänger nach dem FELEG",null,null,"if - Israelitische Kultussteuer Frankfurt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"118 - Unständig Beschäftigte",null,null,"il - Israelitische Kultussteuer Land"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"119 - Versicherungsfreie Altersvollrentner und Versorgungsbezieher wegen Alters",null,null,"fr - Französisch reformiert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"190 - Beschäftigte, die nur in der gesetzlichen Unfallversicherung versichert sind",null,null,"fa - Freie Religionsgemeinschaft Alzey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"900 - Nicht meldepflichtig Beschäftigte",null,null,"fg - Freireligiöse Landesgemeinde Pfalz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs - Freireligiöse Gemeinde Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ih - Jüdische Kultussteuer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jd - Jüdische Kultussteuer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jh - Jüdische Kultussteuer"]

{"sheet":"Listen (englisch)","index":3,"n_rows":24,"n_cols":30,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Employment contract","Employment contract","Apprenticeship contract"]
["Income tax card/written confirmation of income tax","Income tax card/number of days employed at previous employers","Income tax card/written confirmation of income tax","male","unwed","yes","yes","Regular employment","yes","yes","yes","1 - No school leaving certificate","1 - No vocational training","1 - Permanent full-time contract","101 - Employees subject to social insurance contributions","Employee","Fixed-term","Non-denominational",0.02,"yes","yes","0 - Private health insurance","0 - No contribution","0 - No contribution to occupational pension","0 - No contribution to statutory nursing care insurance","Refuse pension insurance option","State","Mini job","yes","yes"]
["Social insurance ID","Social insurance ID","Social insurance ID","female","married","no","no","Additional employment","no","no","no","2 - Haupt-/Volksschulabschluss (completion of secondary education)","2 - Officially recognised vocational training","2 - Permanent part-time contract","102 - Apprentices with no special attributes","Employee on parental leave","Permanent","rk - Roman-catholic church tax",0.2,"no","no","1 - General contribution","1 - Pension insurance contribution","1 - Full contribution to occupational pension","1 - Full contribution to statutory nursing care insurance","Excercise pension insurance option (waive pension insurance exemption)","Private","Non-mini job employment","no","no"]
["State insurance membership certificate","Application for exemption of pension insurance","State insurance membership certificate",null,"divorced",null,null,null,null,null,null,"3 - School leaving certificate or equivalent","3 - Master craftsman/technican/similar degree","3 - Fixed-term full-time contract","103 - Employees in partial retirement","Unemployed","Fixed-term ending on completion of assignment","ev - Protestant church tax",null,null,null,"3 - Reduced contribution","3 - 1/2 pension insurance contribution","2 - 1/2 contribution to occupational pension","2 - 1/2 contribution to statutory nursing care insurance",null,null,"Short-term employment"]
["Certificate of private health insurance","Certificate of private health insurance","Capital-forming benefits (VWL) contract",null,"widowed",null,null,null,null,null,null,"4 - Abitur/Fachabitur (equivalent of A levels in UK)","4 - Bachelor's degree","4 - Fixed-term part-time contract","104 - Self-employed persons","Civil servant",null,"lt - Protestant Lutheran",null,null,null,"4 - Contribution to agricultural sickness fund","5 - Low income"]
["Capital-forming benefits (VWL) contract","Capital-forming benefits (VWL) contract","Proof of parenthood",null,"permanently separated",null,null,null,null,null,null,"9 - Unknown","5 - Diploma/graduate degree/master's degree/state examination certificate",null,"105 - Interns","Housewife/house husband",null,"rf - Protestant reformed",null,null,null,"5 - Employer contribution to agricultural sickness fund"]
["Proof of parenthood","School/university certificate","Company retirement provision contract",null,null,null,null,null,null,null,null,null,"6 - PhD",null,"106 - Student trainees","School pupil",null,"ak - Old Catholic church tax",null,null,null,"6 - Flat-rate contribution for low-wage employees"]
["Company retirement provision contract","Severely disabled ID","Severely disabled ID",null,null,null,null,null,null,null,null,null,"9 - Unknown",null,"107 - Handicapped people in accredited sheltered workshops or similar facilities","Unqualified",null,"is - Israelite / Jewish “Kultussteuer” (community tax)",null,null,null,"9 - Paid by company"]
["Severely disabled ID","Pension fund documents construction/painting","Pension fund documents construction/painting",null,null,null,null,null,null,null,null,null,null,null,"108 - Early retirement pensioners","Self-employed",null,"fb - Non-denominational state parish Baden"]
["Pension fund documents construction/painting",null,null,null,null,null,null,null,null,null,null,null,null,null,"109 - Low income employees","Student",null,"ib - Israelite religious parish Baden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"110 - Short-term employees","Social welfare recipient",null,"fo - Non-denominational parish Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"111 - Persons participating in job-supporting measures for rehabilitation","University applicant",null,"fp - Non-denominational state parish Palatinate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"112 - Family members working in farming","Military/social service",null,"fm - Non-denominational parish Mainz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"113 - Part-time farmers ",null,null,"jü - Jewish"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"114 - Part-time farmers – working seasonally",null,null,"iw - Israelite religious parish Württemberg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116 - Persons receiving compensation money according to FELEG (Law encouraging the cessation of farm work)",null,null,"if - Israelite “Kultussteuer” (community tax) Frankfurt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"118 - Short-term contract workers",null,null,"il - Israelite “Kultussteuer” (community tax) State"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"119 - Full pensioners exempted from insurance and persons qualifying for pension related benefits due to age",null,null,"fr - French reformed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"190 - Employees only insured with statutory accident insurance",null,null,"fa - Non-denominational parish Alzey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"900 - Employees not subject to registration",null,null,"fg - Non-denominational state parish Palatinate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs - Non-denominational parish Offenbach/Main"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ih - Jewish “Kultussteuer” (community tax)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jd - Jewish “Kultussteuer” (community tax)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jh - Jewish “Kultussteuer” (community tax)"]

{"sheet":"Logo","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Verwaltung","index":5,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Gewählter Fragebogen","Neue MA"]
["Sprache PFB","Deutsch"]
["Eigenes Logo"]
[]
["Initialisierung durchgeführt","X"]
["Fragebogen erzeugt","X"]
[]
["Beraternummer"]
["Mandantennummer"]
[]
["Allgemein"]
["Persönliche Angaben",40]
["Beschäftigung",115]
["Befristung",212]
["Steuer",233]
["Sozialversicherung",254]
["Entlohnung",284]
[]
["VWL",305]
["Vorbeschäftigungszeiten",335]
[]
["Bea",null,1827]
["Angaben zu den Arbeitspapieren",null,1900.5]
["Arbeitnehmererklärung"]