{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Seite 1","Seite 2","Attribute","Drucken","Eintragung","Kanzleidaten","Stammdaten"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":119,"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":"Seite 1","index":0,"n_rows":82,"n_cols":77,"rows_kept":82,"cut":false,"hidden":false,"merged":[[33,3,33,4],[40,3,40,4],[71,3,71,4],[73,3,73,4],[61,3,62,4],[54,3,54,4],[64,3,64,4],[69,3,69,4],[56,3,56,4],[59,3,59,4],[50,3,50,4],[25,6,25,46],[25,3,25,4],[27,3,27,4],[29,3,29,4],[31,3,31,4],[26,6,26,22],[28,6,28,22],[7,3,7,4],[12,6,12,54],[7,57,7,77],[7,6,7,56],[8,6,8,56],[12,3,12,4],[13,6,13,31],[14,6,15,54],[18,3,19,4],[10,3,10,4],[23,3,23,4],[19,6,19,47],[18,48,19,76],[11,6,11,18],[17,5,18,22],[17,48,17,77],[20,62,21,76],[21,3,22,4],[21,6,22,26],[20,6,20,26],[75,3,77,4],[74,3,74,4],[42,3,42,4],[44,3,44,4],[46,3,46,4],[52,3,52,4],[48,5,48,35],[43,6,43,27],[52,59,52,77],[54,59,54,77],[52,6,52,33],[54,6,54,33],[46,6,46,14],[74,7,74,77],[75,7,75,77],[77,7,77,77],[44,6,44,76],[46,18,46,76],[45,18,45,46],[45,6,45,17],[57,6,57,77],[52,51,52,57],[54,51,54,57],[52,43,52,49],[54,43,54,49],[52,35,52,41],[54,35,54,41],[50,64,50,75],[59,8,59,77],[33,42,33,56],[30,6,30,14],[30,18,30,26],[31,18,31,76],[32,40,32,59],[32,62,32,77],[33,62,33,76],[33,6,33,20],[33,24,33,38],[31,6,31,14],[32,6,32,20],[32,24,32,38],[38,62,38,76],[41,6,41,22],[39,6,39,22],[37,62,37,76],[36,6,36,56],[6,20,6,46],[81,7,81,25],[81,55,81,74],[81,31,81,50],[14,3,15,4],[38,6,38,26],[38,3,38,4],[40,6,40,46],[42,6,42,46],[22,62,23,76],[23,6,24,27],[10,6,10,17],[10,18,10,42],[27,6,27,46],[29,6,29,76],[37,6,37,26]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Bitte weiße Felder ausfüllen oder  ankreuzen -"]
[null,null,null,"Zeile",null,null,"Antrag auf Steuerklassenwechsel bei Ehegatten / Lebenspartnern",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,null,null,null,null,null,null,null,null,"Eingangsstempel"]
[null,null,null,null,null,null,"(Bitte Erläuterungen auf der Rückseite beachten)"]
[]
[null,null,null,"1  ",null,null,"Steuernummer",null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,"An das Finanzamt"]
[null,null,null,"2  "]
[null,null,null,null,null,null,"Bei Wohnsitzwechsel: bisheriges Finanzamt"]
[null,null,null,"3  "]
[]
[]
[null,null,null,null,null,"  A. Allgemeine Angaben",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,"Telefonische Rücksprache unter Nummer"]
[null,null,null,"4  "]
[null,null,null,null,null,null,"Antragstellende Person"]
[null,null,null,null,null,null,"Identifikationsnummer (IdNr.)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geburtsdatum"]
[null,null,null,"5  "]
[]
[null,null,null,null,null,null,"Name"]
[]
[null,null,null,"6  "]
[null,null,null,null,null,null,"Vorname"]
[null,null,null,"7  "]
[null,null,null,null,null,null,"Straße, Hausnummer"]
[null,null,null,"8  "]
[null,null,null,null,null,null,"Postleitzahl",null,null,null,null,null,null,null,null,null,null,null,"Wohnort"]
[null,null,null,"9  "]
[null,null,null,null,null,null,"Verheiratet / Verpartnert seit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verwitwet seit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geschieden / Lebenspart. aufgehoben seit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dauernd getrennt lebend seit"]
[null,null,null,"10  "]
[]
[]
[null,null,null,null,null,null,"Ehegatte / Lebenspartner(in) nach dem Lebenspartnerschaftsgesetz"]
[null,null,null,null,null,null,"Identifikationsnummer (IdNr.)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geburtsdatum"]
[null,null,null,"11  ",null,null,""]
[null,null,null,null,null,null,"Name"]
[null,null,null,"12  "]
[null,null,null,null,null,null,"Vorname"]
[null,null,null,"13  "]
[null,null,null,null,null,null,"Straße, Hausnummer (falls abweichend)"]
[null,null,null,"14  "]
[null,null,null,null,null,null,"PLZ (falls abweichend)",null,null,null,null,null,null,null,null,null,null,null,"Wohnort (falls abweichend)"]
[null,null,null,"15  ",null,null,""]
[]
[null,null,null,null,null,"  B. Steuerklassenwechsel / Faktorverfahren"]
[]
[null,null,null,"16  ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELStAM gewünscht   ",null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,"17  ",null,null,"(Antragstellende Person / Ehegatte, Lebenspartner[in])",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," III / V",null,null,null,null,null,null,""," IV / IV",null,null,null,null,null,null,""," V / III",null,null,null,null,null,null,""," IV / Faktor"]
[]
[null,null,null,"18  ",null,null,"(Antragstellende Person / Ehegatte, Lebenspartner[in])",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," III / V",null,null,null,null,null,null,null," IV / IV2",null,null,null,null,null,null,null," V / III",null,null,null,null,null,null,null," IV / Faktor"]
[]
[]
[null,null,null,null,null,null,"Der Steuerklassenwechsel wird grundsätzlich ab dem Folgemonat wirksam."]
[]
[null,null,null,"19  ",null,null,null,null,"Der Steuerklassenwechsel lt. Zeile 18 soll davon abweichend im Jahr der Eheschließung rückwirkend ab dem Monat der Heirat gelten."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"20  ",null,null,null,"1) Der Wechsel von der Steuerklasse III oder V in die Steuerklasse IV ist auch auf Antrag nur eines Ehegatten / Lebenspartners"]
[null,null,null,null,null,null,null,"   möglich. Dies hat zur Folge, dass beide Ehegatten / Lebenspartner in die Steuerklasse IV eingereiht werden."]
[]
[null,null,null,null,null,null,null,"2) Bei Eheschließung wird die Steuerklassenkombination IV / IV automatisiert gebildet."]
[]
[]
[]
[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,"- März 2020 -"]

{"sheet":"Seite 2","index":1,"n_rows":77,"n_cols":70,"rows_kept":77,"cut":false,"hidden":false,"merged":[[68,5,68,76],[69,5,69,76],[80,51,80,75],[80,6,80,24],[49,31,49,48],[49,55,49,73],[64,5,64,76],[65,5,65,76],[67,5,67,76],[71,5,71,76],[72,5,72,76],[73,5,73,76],[74,5,74,76],[75,5,75,76],[76,5,76,76],[51,5,51,24],[53,5,53,76],[54,5,54,76],[55,5,55,76],[56,5,56,76],[57,5,57,76],[58,5,58,76],[61,5,61,76],[63,5,63,76],[38,1,38,3],[43,1,43,3],[47,1,48,3],[44,1,45,3],[49,7,49,25],[44,5,44,20],[45,5,45,20],[39,48,39,76],[40,48,40,76],[41,48,41,76],[41,5,41,13],[42,5,42,10],[42,11,42,28],[29,44,29,54],[31,68,31,76],[27,5,27,43],[31,5,31,43],[25,68,25,76],[25,5,25,43],[25,62,25,66],[27,68,27,76],[59,5,59,76],[42,29,42,47],[6,1,6,3],[11,5,11,43],[11,1,11,3],[13,1,13,3],[13,5,13,43],[19,1,19,3],[19,5,19,43],[19,44,19,54],[9,44,9,54],[10,44,10,54],[13,44,13,54],[11,44,11,54],[7,4,7,23],[7,30,7,32],[15,1,15,3],[15,5,15,43],[17,1,17,3],[17,5,17,43],[15,50,15,54],[17,47,17,54],[7,44,8,76],[9,60,9,72],[7,1,7,3],[4,6,4,75],[25,45,25,49],[31,45,31,49],[33,45,33,49],[11,61,11,71],[13,61,13,71],[35,48,35,76],[43,4,43,76],[33,5,33,43],[33,62,33,66],[33,68,33,76],[31,62,31,66],[37,48,37,76],[38,48,38,76],[21,5,21,43],[21,44,21,54],[21,61,21,71],[15,67,15,71],[17,64,17,71],[19,61,19,71],[25,51,25,60],[27,51,27,60],[28,61,28,71],[28,44,28,54],[60,1,61,3],[45,69,45,76],[23,44,24,54],[23,60,24,72],[44,28,44,42],[45,28,45,42],[45,48,45,62],[44,48,44,62],[10,61,10,71],[35,5,37,47],[29,61,29,71],[21,1,21,3],[25,1,25,3],[27,1,27,3],[29,1,29,3],[31,1,31,3],[33,1,33,3],[31,51,31,60],[33,51,33,60],[27,62,27,63],[27,45,27,46],[27,47,27,50],[27,64,27,67],[29,5,29,43]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"- 2 -"]
[]
[null,"Zeile"]
[null,"31  ",null,null,"  C. Angaben",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,"Die Steuerklassen IV / IV mit Faktor haben eine Gültigkeit von bis zu zwei Jahren und sind für Folgejahre neu zu beantragen."]
[]
[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,null,null,"Antragstellende Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehegatte / Lebenspartner(in)"]
[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,null,null,"- EUR -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- EUR -"]
[null,"32  ",null,null,null,"aus dem ersten Dienstverhältnis"]
[]
[null,"33  ",null,null,null,"im Jahresbruttoarbeitslohn enthaltene Versorgungsbezüge"]
[]
[null,"34  ",null,null,null,"gezahlt wurden / werden"]
[]
[null,"35  ",null,null,null,"wurde / wird"]
[]
[null,"36  ",null,null,null,"ersten vollen Monat"]
[]
[null,"37  ",null,null,null,"gungsbeginn ein Rechtsanspruch bestand / besteht"]
[]
[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,null,null,"Antragstellende Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehegatte / Lebenspartner(in)"]
[]
[null,"38  ",null,null,null,"einer berufsständischen Versorgungseinrichtung versichert.",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," Ja",null,null,null,null,null," Nein",null,null,null,null,null,null,null,null,null,null," Ja",null,null,null,null,null,"   Nein"]
[]
[null,"39  ",null,null,null,"Pflegeversicherung versichert.",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," Ja",null,null,null,null,null," trag in %",null,null,null,null,null,null,null,null,null,null," Ja",null,null,null,null,null," trag in %"]
[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,null,null,"EUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR"]
[null,"40  ",null,null,null,"(Basisabsicherung) und zur privaten Pflege-Pflichtversicherung"]
[]
[null,"41  ",null,null,null,"cherung und zur privaten Pflege-Pflichtversicherung erhalten.",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," Ja",null,null,null,null,null," Nein",null,null,null,null,null,null,null,null,null,null," Ja",null,null,null,null,null,"   Nein"]
[]
[null,"42  ",null,null,null,"Kinderlose (§ 55 Abs. 3 SGB XI).",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," Ja",null,null,null,null,null," Nein",null,null,null,null,null,null,null,null,null,null," Ja",null,null,null,null,null,"   Nein"]
[]
[null,null,null,null,null,"Der Antrag ist von beiden Ehegatten / Lebenspartnern zu unterschreiben\n(Ausnahme: vgl. Fußnote 1 auf der Vorderseite).",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,"Bei der Ausfertigung des Antrags hat mitgewirkt:"]
[]
[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,null,null,null,null,null,null,""]
[null,"43  ",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"29.10.2023",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,""]
[null,null,null,null,null,"  Datum",null,null,null,null,null," Unterschrift antragstellende Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Ehegatte / Lebenspartner(in)"]
[null,null,null,null,"Verfügung des Finanzamts"]
[null,"44  ",null,null,null,"2. Änderung der ELStAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  2. Ausdruck der ELStAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  3. Vormerkung für"]
[null,null,null,null,null,"    veranlasst",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      übergeben / versandt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      ESt-Veranlagung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 4. z.d.A."]
[]
[null,"45  "]
[]
[null,null,null,null,null,null,null,"Sachgebietsleiter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sachbearbeiter"]
[]
[null,null,null,null,null,"Erläuterungen:"]
[]
[null,null,null,null,null,"Die Eintragungsmöglichkeiten für Lebenspartner beziehen sich nur auf Lebenspartner nach dem Lebenspartnerschaftsgesetz. Anstelle"]
[null,null,null,null,null,"der Steuerklassenkombination III / V oder IV / IV kann die Berücksichtigung der Steuerklasse IV in Verbindung mit einem Faktor"]
[null,null,null,null,null,"beantragt werden. Dies hat zur Folge, dass die einzubehaltende Lohnsteuer in Anlehnung an das Splittingverfahren ermittelt wird."]
[null,null,null,null,null,"Falls zusätzlich Werbungskosten, Sonderausgaben, außergewöhnliche Belastungen oder andere steuermindernde Beträge beim"]
[null,null,null,null,null,"Lohnsteuerabzug berücksichtigt werden sollen, reichen Sie bitte zusätzlich den „Antrag auf Lohnsteuer-Ermäßigung“ ein. Ein bereits für"]
[null,null,null,null,null,"das Antragsjahr gültiger Freibetrag wird vom Finanzamt in die Berechnung des Faktors einbezogen und für beide Jahre der Gültigkeit"]
[null,null,null,null,null,"des Faktorverfahrens berücksichtigt."]
[null,"46"]
[null,null,null,null,null,"Der Steuerklassenwechsel wird grundsätzlich zu Beginn des Kalendermonats wirksam, der auf die Antragstellung folgt."]
[]
[null,null,null,null,null,"Der Antrag auf Steuerklassenwechsel kann grundsätzlich nur bearbeitet werden, wenn ihn beide Ehegatten / Lebenspartner unter-"]
[null,null,null,null,null,"schrieben haben. Abweichend hiervon reicht die Unterschrift eines Ehegatten / Lebenspartners aus, wenn von ihm ein Wechsel von der"]
[null,null,null,null,null,"Steuerklasse III oder V in die Steuerklasse IV beantragt wird."]
[]
[null,null,null,null,null,"Sie sind verpflichtet, nach Ablauf des Kalenderjahres eine Einkommensteuererklärung abzugeben, wenn beide Ehegatten /Lebenspartner"]
[null,null,null,null,null,"Arbeitslohn bezogen haben und im laufenden Kalenderjahr die Steuerklassenkombinationen III / V oder IV / IV mit Faktor vorlag (§ 46"]
[null,null,null,null,null,"Abs. 2 Nr. 3a des Einkommensteuergesetzes - EStG)."]
[]
[null,null,null,null,null,"Nach den Vorschriften der Datenschutzgesetze wird darauf hingewiesen, dass die Angabe der Telefonnummer freiwillig im Sinne dieser"]
[null,null,null,null,null,"Gesetze ist und im Übrigen die mit diesem Antrag angeforderten Daten auf Grund der §§ 149, 150 der Abgabenordnung und der §§ 39"]
[null,null,null,null,null,"Abs. 6, 39e, 39f EStG erhoben werden. Informationen über die Verarbeitung personenbezogener Daten in der Steuerverwaltung und"]
[null,null,null,null,null,"über Ihre Rechte nach der Datenschutz-Grundverordnung sowie über Ihre Ansprechpartner in Datenschutzfragen entnehmen Sie bitte"]
[null,null,null,null,null,"dem allgemeinen Informationsschreiben der Finanzverwaltung. Dieses Informationsschreiben finden Sie unter www.finanzamt.de (unter"]
[null,null,null,null,null,"der Rubrik „Datenschutz“) oder erhalten Sie bei Ihrem Finanzamt."]

{"sheet":"Attribute","index":2,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["KAW-Variable","Wert","Bezeichnung"]
["KAW020001",{"$f":"IF(Mandantennummer=\"\",\"\",Mandantennummer)","v":""},"Nummer"]
["KAW010101",{"$f":"IF(FirstRun=\"\",\"\",YEAR(FirstRun))","v":2023},"Jahr"]
["KAW010102",{"$f":"IF(FirstRun=\"\",\"\",MONTH(FirstRun))","v":10},"Monat"]
["KAW010103","Antrag auf Steuerklassenwechsel bei Ehegatten/Lebenspartnern","Beschreibung"]
["KAW010105","Steuerklassenwechsel, Ehegatten/Lebenspartnern","Stichworte"]

{"sheet":"Drucken","index":3,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Sheetname","Header","Caption","Checked","Druck","Linebreak","WithBlankSheet","BlankSheetName","Seiten","Drucker","BeraterMandant","Duplex"]
["Seite 1",null,null,"true",true,null,null,null,1,null,false,true]
["Seite 2",null,null,"true",true,null,null,null,1]

{"sheet":"Eintragung","index":4,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["Art","Person","Betrieb","VF","Quelle / Ziel","Wert","VF","Wert 1","Wert 2","Wert 3","Wert 4","Wert 5","Wert 6","Wert 7","Wert 8","Wert 9","Wert 10"]
["ZMSD","$Mandant.Nummer","NA",null,"Mandantennummer",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Steuernummer","NA",null,"StPfFASteuerNr","",null,"Person vorhanden?"]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Identifikationsnummer","NA",null,"StPfIdentNr","",null,{"$f":"IF(AND(StPfVorname=\"\",StPfNachname=\"\"),\"Nein\",\"Ja\")","v":"Nein"}]
["ZMSD","$Ehegatte.PersoenlicheDaten.Identifikationsnummer","NA",null,"EgIdentNr","",null,"Geschlecht der Person"]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Bezeichnung1","NA",null,"StPfFAName","",null,{"$f":"IF(StPfGeschlecht=\"\",\"\",StPfGeschlecht)","v":""}]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Geschlecht","NA",null,"StPfGeschlecht",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Geburt.Datum","NA",null,"StPfGebDatum","",null,"Ehegatte vorhanden?"]
["ZMSD","$Steuerpflichtiger.TitelAkademischerGrad","NA",null,"StPfTitel","",null,{"$f":"IF(AND(EgVorname=\"\",EgNachname=\"\"),\"Nein\",\"Ja\")","v":"Nein"}]
["ZMSD","$Steuerpflichtiger.Vorname","NA",null,"StPfVorname",null,null,"Geschlecht des Ehegatten"]
["ZMSD","$Steuerpflichtiger.Nachname","NA",null,"StPfNachname",null,null,{"$f":"IF(EgGeschlecht=\"\",\"\",EgGeschlecht)","v":""}]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.Strasse","NA",null,"StPfStrasse"]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.PLZ","NA",null,"StPfPLZ",null,null,"Felder in Seite 1 vertauschen?"]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.Ort","NA",null,"StPfOrt",null,null,{"$f":"IF(AND(Bedingung1=\"Ja\",Bedingung3=\"Ja\",Bedingung2=\"W\",Bedingung4=\"M\"),\"Ja\",\"Nein\")","v":"Nein"}]
["ZMSD","$Steuerpflichtiger.Haupttelefon.Nummer","NA",null,"StPfTelefon",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Familienstand","NA",null,"StPfFamStand",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.","NA",null,"StPfFamSeit",""]
["ZMSD","$Ehegatte.Hauptfinanzamt.Steuernummer","NA",null,"EgSteuerNr",""]
["ZMSD","$Ehegatte.Hauptfinanzamt.Info.Bezeichnung1","NA",null,"EgFAName",""]
["ZMSD","$Ehegatte.PersoenlicheDaten.Geschlecht","NA",null,"EgGeschlecht",""]
["ZMSD","$Ehegatte.PersoenlicheDaten.Geburt.Datum","NA",null,"EgGebDatum",""]
["ZMSD","$Ehegatte.TitelAkademischerGrad","NA",null,"EgTitel",""]
["ZMSD","$Ehegatte.Vorname","NA",null,"EgVorname",""]
["ZMSD","$Ehegatte.Nachname","NA",null,"EgNachname",""]
["ZMSD","$Ehegatte.Hauptstrasse.Strasse","NA",null,"EgStrasse",""]
["ZMSD","$Ehegatte.Hauptstrasse.PLZ","NA",null,"EgPLZ",""]
["ZMSD","$Ehegatte.Hauptstrasse.Ort","NA",null,"EgOrt",""]
["ZMSD","$Ehegatte.Haupttelefon.Nummer","NA",null,"EgTelefon",""]
["ZMSD","$Ehegatte.PersoenlicheDaten.Familienstand","NA",null,"EgFamStand"]
["ZMSD","$Ehegatte.PersoenlicheDaten.","NA",null,"EgFamSeit"]
["COPY",null,null,null,"ZStPfFASteuerNr",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfFASteuerNr=\"\",\"\",StPfFASteuerNr),IF(EgSteuerNr=\"\",\"\",EgSteuerNr))","v":""}]
["COPY",null,null,null,"ein_id_1",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfIdentNr=\"\",\"\",StPfIdentNr),IF(EgIdentNr=\"\",\"\",EgIdentNr))","v":""}]
["COPY",null,null,null,"ein_id_2",{"$f":"IF(Vertauschen=\"Nein\",IF(EgIdentNr=\"\",\"\",EgIdentNr),IF(StPfIdentNr=\"\",\"\",StPfIdentNr))","v":""}]
["COPY",null,null,null,"ZStPfFAName",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfFAName=\"\",\"\",StPfFAName),IF(EgFAName=\"\",\"\",EgFAName))","v":""}]
["COPY",null,null,null,"ZStPfFANameAlt",{"$f":"\"\"","v":""}]
["COPY",null,null,null,"ein_d_1",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfGebDatum=\"\",\"\",Datumkonvert(StPfGebDatum)),IF(EgGebDatum=\"\",\"\",Datumkonvert(EgGebDatum)))","v":""}]
["COPY",null,null,null,"ZStPfName",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfTitel=\"\",\"\",StPfTitel & \" \") & IF(StPfNachname=\"\",\"\",StPfNachname),IF(EgTitel=\"\",\"\",EgTitel & \" \") & IF(EgNachname=\"\",\"\",EgNachname))","v":""}]
["COPY",null,null,null,"ZStPfVorname",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfVorname=\"\",\"\",StPfVorname),IF(EgVorname=\"\",\"\",EgVorname))","v":""}]
["COPY",null,null,null,"ZStPfStrasse",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfStrasse=\"\",\"\",StPfStrasse),IF(EgStrasse=\"\",\"\",EgStrasse))","v":""}]
["COPY",null,null,null,"ZStPfPLZ",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfPLZ=\"\",\"\",StPfPLZ),IF(EgPLZ=\"\",\"\",EgPLZ))","v":""}]
["COPY",null,null,null,"ZStPfOrt",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfOrt=\"\",\"\",StPfOrt),IF(EgOrt=\"\",\"\",EgOrt))","v":""}]
["COPY",null,null,null,"ein_d_2",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfFamStand=\"VH\",Datumkonvert(StPfFamSeit),\"\"),IF(EgFamStand=\"VH\",Datumkonvert(EgFamSeit),\"\"))","v":""}]
["COPY",null,null,null,"ein_d_3",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfFamStand=\"VW\",Datumkonvert(StPfFamSeit),\"\"),IF(EgFamStand=\"VW\",Datumkonvert(EgFamSeit),\"\"))","v":""}]
["COPY",null,null,null,"ein_d_4",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfFamStand=\"GS\",Datumkonvert(StPfFamSeit),\"\"),IF(EgFamStand=\"GS\",Datumkonvert(EgFamSeit),\"\"))","v":""}]
["COPY",null,null,null,"ein_d_5",{"$f":"IF(Vertauschen=\"Nein\",IF(StPfFamStand=\"GT\",Datumkonvert(StPfFamSeit),\"\"),IF(EgFamStand=\"GT\",Datumkonvert(EgFamSeit),\"\"))","v":""}]
["COPY",null,null,null,"ZStPfTelefon",{"$f":"IF(StPfTelefon=\"\",\"\",StPfTelefon)","v":""}]
["COPY",null,null,null,"ein_d_6",{"$f":"IF(Vertauschen=\"Nein\",IF(EgGebDatum=\"\",\"\",Datumkonvert(EgGebDatum)),IF(StPfGebDatum=\"\",\"\",Datumkonvert(StPfGebDatum)))","v":""}]
["COPY",null,null,null,"ZEgName",{"$f":"IF(Vertauschen=\"Nein\",IF(EgTitel=\"\",\"\",EgTitel & \" \") & IF(EgNachname=\"\",\"\",EgNachname),IF(StPfTitel=\"\",\"\",StPfTitel & \" \") & IF(StPfNachname=\"\",\"\",StPfNachname))","v":""}]
["COPY",null,null,null,"ZEgVorname",{"$f":"IF(Vertauschen=\"Nein\",IF(EgVorname=\"\",\"\",EgVorname),IF(StPfVorname=\"\",\"\",StPfVorname))","v":""}]
["COPY",null,null,null,"ZEgStrasse",{"$f":"IF(Vertauschen=\"Nein\",IF(EgStrasse=\"\",\"\",IF(EgStrasse=StPfStrasse,\"\",EgStrasse)),IF(StPfStrasse=\"\",\"\",IF(EgStrasse=StPfStrasse,\"\",StPfStrasse)))","v":""}]
["COPY",null,null,null,"ZEgPLZ",{"$f":"IF(Vertauschen=\"Nein\",IF(EgPLZ=\"\",\"\",IF(EgPLZ=StPfPLZ,\"\",EgPLZ)),IF(StPfPLZ=\"\",\"\",IF(EgPLZ=StPfPLZ,\"\",StPfPLZ)))","v":""}]
["COPY",null,null,null,"ZEgOrt",{"$f":"IF(Vertauschen=\"Nein\",IF(EgOrt=\"\",\"\",IF(EgOrt=StPfOrt,\"\",EgOrt)),IF(StPfOrt=\"\",\"\",IF(EgOrt=StPfOrt,\"\",StPfOrt)))","v":""}]

{"sheet":"Kanzleidaten","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Kanzleidaten"]
["KANZLEI","KD_Bezeichnung",""]
["KANZLEI","KD_Bezeichnung1",""]
["KANZLEI","KD_Strasse",""]
["KANZLEI","KD_PLZ",""]
["KANZLEI","KD_Ort",""]
["KANZLEI","KD_Telefon",""]
["COPY","ZKDBezeichnung1",{"$f":"IF(KD_Bezeichnung=\"\",\"\",KD_Bezeichnung)","v":""}]
["COPY","ZKDBezeichnung2",{"$f":"IF(KD_Bezeichnung1=\"\",\"\",KD_Bezeichnung1)","v":""}]
["COPY","ZKDStrasse",{"$f":"IF(KD_Strasse=\"\",\"\",KD_Strasse)","v":""}]
["COPY","ZKDPLZOrt",{"$f":"IF(KD_PLZ=\"\",\"\",KD_PLZ & \" \") & IF(KD_Ort=\"\",\"\",KD_Ort)","v":""}]
["COPY","ZKDTelefon",{"$f":"IF(KD_Telefon=\"\",\"\",KD_Telefon)","v":""}]

{"sheet":"Stammdaten","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Stammdaten"]
["ToolName","Ergänzende Steuerformulare"]
["ToolVersion","V.5.61"]
["ToolDatum","(02.03.2022)"]
["ToolInfo",{"$f":"ToolName & \" \" & ToolVersion & \" \" & ToolDatum","v":"Ergänzende Steuerformulare V.5.61 (02.03.2022)"}]
["Eingabekontrolle",true]
["FirstRun","29.10.2023"]
["ToolID","Stklwe"]
["ToolKompID","T0000025"]