{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Seite 1","Seite 2","Seite 3","Seite 4","Seite 5","Seite 6","Seite 7","Seite 8","Attribute","Drucken","Eintragung","Kanzleidaten","Stammdaten"],"not_rendered":{"images":3,"macros":1,"defined_names":407},"read":"whole","date_system":"1900"}

{"sheet":"Seite 1","index":0,"n_rows":88,"n_cols":44,"rows_kept":88,"merged":[[0,4,0,11],[5,5,5,14],[5,37,5,47],[6,5,6,34],[8,5,8,10],[8,12,8,26],[9,5,9,35],[10,7,10,47],[12,7,12,35],[14,5,14,15],[15,5,15,21],[16,5,16,7],[16,33,16,36],[17,5,17,31],[17,33,17,47],[19,5,19,10],[20,5,20,31],[22,5,22,10],[22,39,22,43],[23,5,23,37],[23,39,23,47],[25,5,25,7],[26,5,26,47],[28,5,28,8],[28,12,28,16],[28,20,28,24],[29,5,29,9],[29,12,29,18],[29,20,29,47],[31,5,31,8],[31,13,31,15],[32,5,32,10],[32,13,32,39],[34,5,34,8],[34,13,34,17],[34,42,34,44],[35,5,35,10],[35,13,35,39],[35,42,35,47],[37,13,37,18],[38,5,38,12],[38,13,38,25],[38,43,38,45],[38,46,38,47],[40,5,40,30],[41,5,41,13],[41,17,41,21],[41,28,41,36],[41,39,41,46],[42,5,42,14],[42,17,42,25],[42,28,42,37],[42,39,42,47],[44,5,44,28],[45,5,45,7],[45,33,45,36],[46,5,46,31],[46,33,46,47],[48,5,48,10],[49,5,49,31],[51,5,51,10],[51,39,51,43],[52,5,52,37],[52,39,52,47],[53,5,53,13],[54,5,54,15],[54,16,54,18],[55,5,55,47],[57,5,57,8],[57,12,57,16],[57,20,57,24],[58,5,58,9],[58,12,58,18],[58,20,58,47],[60,5,60,8],[60,13,60,15],[61,5,61,10],[61,13,61,36],[63,13,63,18],[64,5,64,12],[64,13,64,25],[64,43,64,45],[64,46,64,47],[66,5,66,25],[67,5,67,8],[68,5,68,10],[68,12,68,15],[68,23,68,25],[69,5,69,9],[69,12,69,20],[69,23,69,47],[71,5,71,10],[71,12,71,15],[71,23,71,25],[72,5,72,9],[72,12,72,20],[72,23,72,47],[74,5,74,7],[75,5,75,47],[77,5,77,9],[78,5,78,47],[80,5,80,47],[81,5,81,47],[83,5,83,47],[87,8,87,18],[87,19,87,37],[87,38,87,46]]}
[]
[]
[]
[]
[]
[{"$nulls":5},"An das Finanzamt",{"$nulls":31},"Eingangsstempel oder -datum"]
[]
[]
[{"$nulls":5},"Steuernummer"]
[{"$nulls":5},"Fragebogen zur steuerlichen Erfassung"]
[{"$nulls":7},"Aufnahme einer gewerblichen, selbständigen (freiberuflichen) oder land- und forstwirtschaftlichen Tätigkeit"]
[]
[{"$nulls":5},"",null,"Beteiligung an einer Personengesellschaft/-gemeinschaft"]
[]
[{"$nulls":5},"1. Allgemeine Angaben"]
[{"$nulls":5},"1.1 Steuerpflichtige(r)/Beteiligte(r)"]
[{"$nulls":5},"Name",{"$nulls":27},"Vorname"]
[]
[]
[{"$nulls":5},"ggf. Geburtsname"]
[]
[]
[{"$nulls":5},"Ausgeübter Beruf",{"$nulls":33},"Geburtsdatum"]
[]
[]
[{"$nulls":5},"Straße"]
[]
[]
[{"$nulls":5},"Hausnummer",{"$nulls":6},"Hausnummerzusatz",{"$nulls":7},"Adressergänzung"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":7},"Wohnort"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":7},"Ort (Postfach)",{"$nulls":28},"Postfach"]
[]
[]
[{"$nulls":13},"Identifikationsnummer"]
[{"$nulls":5},"Identifikationsnummer",{"$nulls":37},"Religion "]
[]
[{"$nulls":5},"Stand der Ehe/eingetragenen Lebenspartnerschaft (Datum = TT.MM.JJJJ)"]
[{"$nulls":5},"Verheiratet/Eingetragen seit dem",{"$nulls":11},"Verwitwet seit dem",{"$nulls":10},"Geschieden/Aufgehoben seit dem",{"$nulls":10},"Dauernd getrennt lebend seit dem"]
[]
[]
[{"$nulls":5},"1.2 Ehegatte/Ehegattin/eingetragene(r) Lebenspartner(in)"]
[{"$nulls":5},"Name",{"$nulls":27},"Vorname"]
[]
[]
[{"$nulls":5},"ggf. Geburtsname"]
[]
[]
[{"$nulls":5},"Ausgeübter Beruf",{"$nulls":33},"Geburtsdatum"]
[]
[]
[{"$nulls":5},"Falls von den Zeilen 8 und 10 abweichend:",{"$nulls":10},"Straße"]
[]
[]
[{"$nulls":5},"Hausnummer",{"$nulls":6},"Hausnummerzusatz",{"$nulls":7},"Adressergänzung"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":7},"Wohnort"]
[]
[]
[{"$nulls":13},"Identifikationsnummer"]
[{"$nulls":5},"Identifikationsnummer",{"$nulls":37},"Religion "]
[]
[{"$nulls":5},"1.3 Kommunikationsverbindungen"]
[{"$nulls":5},"Telefon:"]
[{"$nulls":5},"Vorwahl international",{"$nulls":6},"Vorwahl national",{"$nulls":10},"Rufnummer"]
[]
[]
[{"$nulls":5},"Vorwahl international",{"$nulls":6},"Vorwahl national",{"$nulls":10},"Rufnummer"]
[]
[]
[{"$nulls":5},"E-Mail"]
[]
[]
[{"$nulls":5},"Internetadresse"]
[]
[]
[{"$nulls":5},"1.4 Art der Tätigkeit (genaue Bezeichnung des Gewerbezweiges)"]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},"2016FsEEU011",{"$nulls":10},"- Juni 2016 -",{"$nulls":18},"  2016FsEEU011"]

{"sheet":"Seite 2","index":1,"n_rows":88,"n_cols":42,"rows_kept":88,"merged":[[0,3,0,12],[2,3,2,47],[5,4,5,19],[6,4,6,10],[6,11,6,26],[8,4,8,40],[9,4,9,46],[10,4,10,6],[11,4,11,46],[13,4,13,5],[14,4,14,17],[16,4,16,10],[17,4,17,46],[19,19,19,29],[20,5,20,11],[20,13,20,18],[20,19,20,46],[22,4,22,40],[23,4,23,29],[25,4,25,6],[26,4,26,45],[29,4,29,16],[31,4,31,10],[32,4,32,46],[34,19,34,29],[35,5,35,11],[35,13,35,18],[35,19,35,46],[36,4,36,18],[37,4,37,40],[38,4,38,29],[40,4,40,6],[41,4,41,45],[43,4,43,5],[44,4,44,16],[46,4,46,10],[47,4,47,46],[49,19,49,29],[50,5,50,11],[50,13,50,18],[50,19,50,46],[52,4,52,41],[53,6,53,26],[56,4,56,14],[56,18,56,19],[57,4,57,6],[58,4,58,46],[59,4,59,6],[60,4,60,6],[60,33,60,35],[61,4,61,31],[61,33,61,46],[63,4,63,6],[64,4,64,46],[66,4,66,7],[66,11,66,14],[66,19,66,24],[67,4,67,8],[67,11,67,17],[67,19,67,46],[69,4,69,7],[70,4,70,9],[70,12,70,46],[72,4,72,7],[72,12,72,15],[72,41,72,42],[73,4,73,9],[73,12,73,38],[73,41,73,46],[74,4,74,14],[75,4,75,7],[76,4,76,9],[76,11,76,14],[76,22,76,25],[77,4,77,8],[77,11,77,19],[77,22,77,46],[79,4,79,6],[80,4,80,46],[87,7,87,14],[87,37,87,45]]}
[]
[]
[{"$nulls":3},""]
[]
[]
[]
[{"$nulls":4},"Steuernummer",{"$nulls":6},{"$f":"IF(ZFaSteuernummer=\"\",\"\",ZFaSteuernummer)","v":""}]
[]
[{"$nulls":4},"1.5 Bankverbindung(en)  für Steuererstattungen/SEPA-Lastschriftverfahren"]
[{"$nulls":4},"Alle Steuererstattungen sollen an folgende Bankverbindung erfolgen:"]
[{"$nulls":4},"IBAN"]
[{"$nulls":4},""]
[]
[{"$nulls":4},"BIC"]
[{"$nulls":4},""]
[]
[{"$nulls":4},"Geldinstitut (Name, Ort)"]
[{"$nulls":4},""]
[]
[{"$nulls":19},"ggf. abweichende(r) Kontoinhaber(in)"]
[{"$nulls":5}," lt. Zeile 5",{"$nulls":7}," lt. Zeile 14 oder:",{"$nulls":5},""]
[]
[{"$nulls":4}," Personensteuererstattungen"]
[{"$nulls":4}," (z.B. Einkommensteuer) sollen an folgende Bankverbindung erfolgen:"]
[]
[{"$nulls":4},"IBAN"]
[{"$nulls":4},""]
[]
[{"$nulls":4},"BIC"]
[{"$nulls":4},""]
[]
[{"$nulls":4},"Geldinstitut (Name, Ort)"]
[{"$nulls":4},""]
[]
[{"$nulls":19},"ggf. abweichende(r) Kontoinhaber(in)"]
[{"$nulls":5}," lt. Zeile 5",{"$nulls":7}," lt. Zeile 14 oder:",{"$nulls":5},""]
[]
[{"$nulls":4}," Betriebssteuererstattungen"]
[{"$nulls":4}," (z.B. Umsatz-, Lohnsteuer) sollen an folgende Bankverbindung erfolgen:"]
[]
[{"$nulls":4},"IBAN"]
[{"$nulls":4},""]
[]
[{"$nulls":4},"BIC"]
[{"$nulls":4},""]
[]
[{"$nulls":4},"Geldinstitut (Name, Ort)"]
[{"$nulls":4},""]
[]
[{"$nulls":19},"ggf. abweichende(r) Kontoinhaber(in)"]
[{"$nulls":5}," lt. Zeile 5",{"$nulls":7}," lt. Zeile 14 oder:",{"$nulls":5},""]
[]
[{"$nulls":4}," Möchten Sie am SEPA-Lastschriftverfahren, dem für beide Seiten einfachsten Zahlungsweg, teilnehmen?"]
[{"$nulls":6},"Ja. Das ausgefüllte SEPA-Lastschriftmandat ist beigefügt."]
[]
[]
[{"$nulls":4},"1.6 Steuerliche Beratung",{"$nulls":13},"Nein",{"$nulls":5},"Ja"]
[{"$nulls":4},"Firma"]
[]
[{"$nulls":4},"oder"]
[{"$nulls":4},"Name",{"$nulls":28},"Vorname"]
[]
[]
[{"$nulls":4},"Straße"]
[]
[]
[{"$nulls":4},"Hausnummer",{"$nulls":6},"Hausnummerzusatz",{"$nulls":7},"Adressergänzung"]
[]
[]
[{"$nulls":4},"Postleitzahl",{"$nulls":7},"Ort"]
[]
[]
[{"$nulls":4},"Postleitzahl",{"$nulls":7},"Ort (Postfach)",{"$nulls":28},"Postfach"]
[]
[{"$nulls":4},"Kommunikationsverbindungen"]
[{"$nulls":4},"Telefon:"]
[{"$nulls":4},"Vorwahl international",{"$nulls":6},"Vorwahl national",{"$nulls":10},"Rufnummer"]
[]
[]
[{"$nulls":4},"E-Mail"]
{"$rows_empty":7}
[{"$nulls":7},"2016FsEEU012",{"$nulls":29},"2016FsEEU012"]

{"sheet":"Seite 3","index":2,"n_rows":98,"n_cols":44,"rows_kept":98,"merged":[[0,4,0,14],[2,4,2,49],[5,5,5,21],[6,5,6,12],[6,13,6,27],[8,5,8,27],[9,7,9,48],[10,5,10,7],[11,5,11,7],[12,5,12,48],[13,5,13,7],[14,5,14,7],[14,35,14,37],[15,5,15,32],[15,35,15,48],[17,5,17,7],[18,5,18,48],[20,5,20,8],[20,13,20,16],[20,21,20,25],[21,5,21,9],[21,13,21,18],[21,21,21,48],[23,5,23,8],[24,5,24,11],[24,14,24,48],[26,5,26,8],[26,14,26,17],[26,43,26,44],[27,5,27,11],[27,14,27,40],[27,43,27,48],[28,5,28,16],[29,5,29,7],[30,5,30,11],[30,13,30,16],[30,24,30,26],[31,5,31,11],[31,13,31,22],[31,24,31,48],[33,5,33,7],[34,5,34,48],[35,5,35,23],[36,7,36,35],[38,5,39,22],[39,26,39,33],[40,5,40,25],[40,26,41,35],[41,5,42,7],[43,5,43,48],[45,5,45,8],[45,13,45,16],[45,21,45,25],[46,5,46,9],[46,13,46,18],[46,21,46,48],[48,5,48,8],[48,14,48,16],[49,5,49,11],[49,14,49,40],[51,5,51,8],[51,14,51,17],[51,43,51,44],[52,5,52,11],[52,14,52,40],[52,43,52,48],[53,5,53,48],[54,5,55,14],[55,15,55,17],[56,7,56,8],[56,15,56,48],[58,15,58,18],[59,15,59,30],[61,5,61,48],[62,5,62,21],[63,5,63,8],[64,5,64,48],[66,5,66,7],[67,5,67,48],[69,5,69,8],[69,13,69,16],[69,21,69,25],[70,5,70,9],[70,13,70,18],[70,21,70,48],[72,5,72,8],[73,5,73,11],[73,14,73,40],[75,5,75,8],[75,14,75,17],[75,43,75,44],[76,5,76,11],[76,14,76,40],[76,43,76,48],[77,5,77,20],[78,5,78,7],[79,5,79,48],[81,5,81,8],[81,13,81,16],[81,21,81,25],[82,5,82,9],[82,13,82,18],[82,21,82,48],[84,5,84,8],[85,5,85,11],[85,14,85,48],[86,5,86,16],[87,5,87,7],[88,5,88,11],[88,13,88,16],[88,24,88,26],[89,5,89,9],[89,13,89,21],[89,24,89,48],[91,5,91,7],[92,5,92,48],[94,5,94,9],[95,5,95,48],[97,8,97,17],[97,39,97,47]]}
[]
[]
[{"$nulls":4},""]
[]
[]
[]
[{"$nulls":5},"Steuernummer",{"$nulls":7},{"$f":"IF(ZFaSteuernummer=\"\",\"\",ZFaSteuernummer)","v":""}]
[]
[{"$nulls":5},"1.7 Empfangsbevollmächtigte(r) für alle Steuerarten"]
[{"$nulls":7},"Die unter Tz. 1.6 angegebene steuerliche Beratung ist empfangsbevollmächtigt. Die gesonderte Vollmacht ist beigefügt."]
[{"$nulls":5},"oder"]
[{"$nulls":5},"Firma"]
[{"$nulls":5},""]
[{"$nulls":5},"oder"]
[{"$nulls":5},"Name",{"$nulls":29},"Vorname"]
[{"$nulls":5},"",{"$nulls":29},""]
[]
[{"$nulls":5},"Straße"]
[{"$nulls":5},""]
[]
[{"$nulls":5},"Hausnummer",{"$nulls":7},"Hausnummerzusatz",{"$nulls":7},"Adressergänzung"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Ort"]
[{"$nulls":5},"",{"$nulls":8},""]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Ort (Postfach)",{"$nulls":28},"Postfach"]
[{"$nulls":5},"",{"$nulls":8},"",{"$nulls":28},""]
[{"$nulls":5},"Kommunikationsverbindungen"]
[{"$nulls":5},"Telefon:"]
[{"$nulls":5},"Vorwahl international",{"$nulls":7},"Vorwahl national",{"$nulls":10},"Rufnummer"]
[{"$nulls":24},""]
[]
[{"$nulls":5},"E-Mail"]
[{"$nulls":5},""]
[]
[{"$nulls":7},"Die gesonderte Vollmacht für Zeile 52 oder 53 ist beigefügt."]
[]
[{"$nulls":5},"1.8 Bisherige persönliche Verhältnisse"]
[{"$nulls":26},"Zugezogen am (TT.MM.JJJJ)"]
[{"$nulls":5},"Falls Sie innerhalb der letzten 12 Monate zugezogen sind:"]
[{"$nulls":5},"Straße"]
[]
[]
[]
[{"$nulls":5},"Hausnummer",{"$nulls":7},"Hausnummerzusatz",{"$nulls":7},"Adressergänzung"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Wohnort"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Ort (Postfach)",{"$nulls":28},"Postfach"]
[]
[{"$nulls":5}," Waren Sie (oder ggf. Ihr(e) Ehegatte/Ehegattin/eingetragene(r) Lebenspartner(in)) in den letzten drei Jahren für Zwecke der Einkommen-"]
[{"$nulls":5}," steuer steuerlich erfasst?"]
[{"$nulls":15},"Finanzamt"]
[{"$nulls":7},"Nein",{"$nulls":5},"Ja"]
[]
[{"$nulls":15},"Steuernummer"]
[]
[]
[{"$nulls":5},"2. Angaben zur gewerblichen, selbständigen (freiberuflichen) oder land- und forstwirtschaftlichen Tätigkeit"]
[{"$nulls":5},"2.1 Anschrift des Unternehmens"]
[{"$nulls":5},"Bezeichnung"]
[]
[]
[{"$nulls":5},"Straße"]
[]
[]
[{"$nulls":5},"Hausnummer",{"$nulls":7},"Hausnummerzusatz",{"$nulls":7},"Adressergänzung"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Ort"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Ort (Postfach)",{"$nulls":28},"Postfach"]
[]
[{"$nulls":5},"ggf. abweichender Ort der Geschäftsleitung"]
[{"$nulls":5},"Straße"]
[]
[]
[{"$nulls":5},"Hausnummer",{"$nulls":7},"Hausnummerzusatz",{"$nulls":7},"Adressergänzung"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Ort"]
[]
[{"$nulls":5},"Kommunikationsverbindungen"]
[{"$nulls":5},"Telefon:"]
[{"$nulls":5},"Vorwahl international",{"$nulls":7},"Vorwahl national",{"$nulls":10},"Rufnummer"]
[]
[]
[{"$nulls":5},"E-Mail"]
[]
[]
[{"$nulls":5},"Internetadresse"]
[]
[]
[{"$nulls":8},"2016FsEEU013",{"$nulls":30},"2016FsEEU013"]

{"sheet":"Seite 4","index":3,"n_rows":92,"n_cols":53,"rows_kept":92,"merged":[[0,3,0,14],[2,3,2,58],[5,4,5,22],[6,12,6,30],[9,4,9,31],[9,32,9,43],[9,44,9,53],[11,4,11,14],[12,4,12,27],[12,28,12,29],[12,30,12,32],[14,15,14,17],[15,8,15,12],[15,15,15,57],[16,4,16,25],[17,15,17,19],[18,15,18,57],[20,15,20,18],[20,22,20,26],[20,33,20,39],[21,15,21,19],[21,22,21,30],[21,33,21,57],[23,15,23,17],[24,15,24,20],[24,24,24,57],[25,15,25,16],[26,15,26,20],[26,22,26,27],[26,37,26,40],[27,15,27,19],[27,22,27,33],[27,37,27,57],[30,15,30,17],[31,8,31,12],[31,15,31,57],[33,15,33,19],[34,15,34,57],[36,15,36,18],[36,22,36,26],[36,33,36,39],[37,15,37,19],[37,22,37,30],[37,33,37,57],[39,15,39,17],[40,15,40,20],[40,24,40,57],[41,15,41,16],[42,15,42,20],[42,22,42,26],[42,37,42,40],[43,15,43,19],[43,22,43,33],[43,37,43,57],[46,15,46,26],[46,28,46,29],[46,30,46,47],[48,4,48,18],[50,6,50,8],[50,10,50,20],[50,28,50,29],[50,30,50,32],[50,37,50,50],[52,6,52,20],[52,37,52,53],[54,37,54,39],[54,40,54,51],[54,52,54,57],[57,4,57,57],[59,4,59,8],[60,4,60,28],[62,4,63,35],[62,37,63,45],[64,19,64,30],[64,35,64,43],[64,47,64,57],[66,6,66,17],[66,19,66,30],[66,35,66,45],[66,47,66,57],[68,4,68,14],[69,4,69,57],[70,4,70,6],[71,4,71,6],[71,40,71,42],[72,4,72,37],[72,40,72,57],[74,4,74,6],[75,4,75,57],[77,4,77,7],[77,12,77,16],[77,22,77,26],[78,4,78,8],[78,12,78,19],[78,22,78,57],[80,4,80,7],[81,4,81,10],[81,14,81,57],[83,4,83,7],[83,39,83,42],[84,4,84,35],[84,39,84,57],[86,4,86,16],[87,4,87,19],[91,7,91,16],[91,47,91,56]]}
[]
[]
[{"$nulls":3},""]
[]
[]
[]
[{"$nulls":4},"Steuernummer",{"$nulls":7},{"$f":"IF(ZFaSteuernummer=\"\",\"\",ZFaSteuernummer)","v":""}]
[]
[]
[{"$nulls":4},"2.2 Beginn der Tätigkeit   (inklusiveVorbereitungshandlungen)",{"$nulls":39},"  (TT.MM.JJJJ)"]
[]
[{"$nulls":4},"2.3 Betriebsstätten"]
[{"$nulls":4},"Werden in mehreren Gemeinden Betriebsstätten unterhalten?",{"$nulls":25}," Nein"]
[]
[{"$nulls":15},"Bezeichnung"]
[{"$nulls":4},"",null,"Ja",null,"0 0 1"]
[]
[{"$nulls":15},"Anschrift, Straße"]
[]
[]
[{"$nulls":15},"Hausnummer",{"$nulls":6},"Hausnummerzusatz",{"$nulls":10},"Adressergänzung"]
[]
[]
[{"$nulls":15},"Postleitzahl",{"$nulls":8},"Ort"]
[]
[{"$nulls":15},"Telefon:"]
[{"$nulls":15},"Vorwahl international",{"$nulls":6},"Vorwahl national",{"$nulls":14},"Rufnummer"]
[]
[]
[]
[{"$nulls":15},"Bezeichnung"]
[{"$nulls":8},"0 0 2"]
[]
[{"$nulls":15},"Anschrift, Straße"]
[]
[]
[{"$nulls":15},"Hausnummer",{"$nulls":6},"Hausnummerzusatz",{"$nulls":10},"Adressergänzung"]
[]
[]
[{"$nulls":15},"Postleitzahl",{"$nulls":8},"Ort"]
[]
[{"$nulls":15},"Telefon:"]
[{"$nulls":15},"Vorwahl international",{"$nulls":6},"Vorwahl national",{"$nulls":14},"Rufnummer"]
[]
[]
[]
[{"$nulls":15},"Bei mehr als zwei Betriebsstätten:",{"$nulls":14}," Gesonderte Aufstellung ist beigefügt."]
[]
[{"$nulls":4},"2.4 Handelsregistereintragung"]
[]
[{"$nulls":6},"Ja, seit",{"$nulls":23}," Nein",{"$nulls":6},"Eine Eintragung ist beabsichtigt."]
[]
[{"$nulls":37},"Antrag beim Handelsregister gestellt"]
[]
[{"$nulls":37},"am",{"$nulls":14},"  (TT.MM.JJJJ)"]
[]
[{"$nulls":4},"Ort"]
[]
[]
[{"$nulls":4},"Registernummer"]
[]
[]
[{"$nulls":4},"2.5 Gründungsform  (Bitte ggf. die entsprechenden Verträge beifügen!)",{"$nulls":32},"(Datum = TT.MM.JJJJ)"]
[]
[{"$nulls":6},"Neugründung zum",{"$nulls":28},"Verlegung zum"]
[]
[{"$nulls":6},"Vererbung, Schenkung) zum",{"$nulls":28},"gung/Verschmelzung"]
[]
[{"$nulls":4},"Vorheriges Unternehmen: Firma"]
[]
[{"$nulls":4},"oder"]
[{"$nulls":4},"Name",{"$nulls":35},"Vorname"]
[]
[]
[{"$nulls":4},"Straße"]
[]
[]
[{"$nulls":4},"Hausnummer",{"$nulls":7},"Hausnummerzusatz",{"$nulls":9},"Adressergänzung"]
[]
[]
[{"$nulls":4},"Postleitzahl",{"$nulls":9},"Ort"]
[]
[]
[{"$nulls":4},"Finanzamt",{"$nulls":34},"Steuernummer"]
[]
[]
[{"$nulls":4},"ggf. Umsatzsteuer-Identifikationsnummer"]
[]
[]
[]
[]
[{"$nulls":7},"2016FsEEU014",{"$nulls":39},"2016FsEEU014"]

{"sheet":"Seite 5","index":4,"n_rows":87,"n_cols":45,"rows_kept":87,"merged":[[0,4,0,14],[2,4,2,53],[5,5,5,22],[6,5,6,12],[6,13,6,30],[9,5,9,22],[10,5,10,52],[11,5,11,52],[13,15,13,24],[14,7,14,8],[14,15,14,52],[16,15,16,16],[17,15,17,52],[19,15,19,17],[20,15,20,25],[20,28,20,38],[20,39,20,47],[22,15,22,17],[22,37,22,41],[23,15,23,35],[23,37,23,52],[25,15,25,27],[26,15,26,30],[28,5,28,46],[30,15,30,35],[30,36,30,52],[31,15,31,24],[31,25,31,35],[31,36,31,43],[31,44,31,52],[32,15,32,24],[32,25,32,35],[32,36,32,43],[32,44,32,52],[33,5,33,14],[33,15,33,24],[33,25,33,35],[33,36,33,43],[33,44,33,52],[35,5,35,14],[35,15,35,24],[35,25,35,35],[35,36,35,43],[35,44,35,52],[37,5,37,14],[37,15,37,24],[37,25,37,35],[37,36,37,43],[37,44,37,52],[39,5,39,14],[39,15,39,24],[39,25,39,35],[39,36,39,43],[39,44,39,52],[41,15,41,24],[41,25,41,35],[41,36,41,43],[41,44,41,52],[43,5,43,14],[43,15,43,24],[43,25,43,35],[43,36,43,43],[43,44,43,52],[45,5,45,14],[45,15,45,24],[45,25,45,35],[45,36,45,43],[45,44,45,52],[47,5,47,14],[49,5,49,14],[49,15,49,24],[49,25,49,35],[49,36,49,43],[49,44,49,52],[51,5,51,14],[51,15,51,24],[51,25,51,35],[51,36,51,43],[51,44,51,52],[53,5,53,19],[55,5,55,14],[55,16,55,30],[57,16,57,30],[59,16,59,48],[61,16,61,26],[61,27,61,52],[63,5,63,30],[65,16,65,17],[65,19,65,20],[65,26,65,28],[65,30,65,39],[65,40,65,48],[67,5,67,41],[67,42,67,49],[69,5,69,52],[70,5,70,52],[72,7,72,52],[74,5,74,33],[77,5,77,11],[77,13,77,16],[77,17,77,22],[77,25,77,34],[77,35,77,38],[77,39,77,48],[77,49,77,52],[80,17,80,28],[80,29,80,37],[83,5,83,16],[83,18,83,28],[83,32,83,39],[83,42,83,52],[86,8,86,17],[86,42,86,51]]}
[]
[]
[{"$nulls":4},""]
[]
[]
[]
[{"$nulls":5},"Steuernummer",{"$nulls":7},{"$f":"IF(ZFaSteuernummer=\"\",\"\",ZFaSteuernummer)","v":""}]
[]
[]
[{"$nulls":5},"2.6 Bisherige betriebliche Verhältnisse"]
[{"$nulls":5},"Ist in den letzten fünf Jahren schon ein Gewerbe, eine selbständige (freiberufliche) oder eine land- und forstwirtschaftliche Tätigkeit"]
[{"$nulls":5},"ausgeübt worden oder waren Sie an einer Personengesellschaft oder zu mindestens 1% an einer Kapitalgesellschaft beteiligt?"]
[]
[{"$nulls":15},"Art der Tätigkeit/Beteiligung"]
[{"$nulls":7},"Nein",{"$nulls":5},"Ja"]
[]
[{"$nulls":15},"Ort"]
[]
[]
[{"$nulls":15},"Dauer vom",{"$nulls":12},"bis"]
[{"$nulls":39},"    (TT.MM.JJJJ)"]
[]
[{"$nulls":15},"Finanzamt",{"$nulls":21},"Steuernummer"]
[]
[]
[{"$nulls":15},"ggf. Umsatzsteuer-Identifikationsnummer"]
[]
[]
[{"$nulls":5},"3. Angaben zur Festsetzung der Vorauszahlungen (Einkommensteuer, Gewerbesteuer)"]
[]
[{"$nulls":15},"im Jahr der Betriebseröffnung",{"$nulls":20},"im Folgejahr"]
[{"$nulls":15},"Steuerpflichtige(r)",{"$nulls":9},"Ehegatte(in)/Lebenspartner(in)",{"$nulls":10},"Steuerpflichtige(r)",{"$nulls":7},"Ehegatte(in)/Lebenspartner(in)"]
[{"$nulls":15},"EUR",{"$nulls":9},"EUR",{"$nulls":10},"EUR",{"$nulls":7},"EUR"]
[{"$nulls":5},"Land- und Forstwirtschaft"]
[]
[{"$nulls":5},"Gewerbebetrieb"]
[]
[{"$nulls":5},"Selbständiger Arbeit"]
[]
[{"$nulls":5},"Nichtselbständiger Arbeit"]
[]
[{"$nulls":5},"Kapitalvermögen"]
[]
[{"$nulls":5},"Verpachtung"]
[]
[{"$nulls":5},"(z. B. Renten)"]
[]
[{"$nulls":5},"3.2 Voraussichtliche"]
[{"$nulls":5},"      "]
[{"$nulls":5},"Sonderausgaben"]
[]
[{"$nulls":5},"Steuerabzugsbeträge"]
[]
[{"$nulls":5},"4. Angaben zur Gewinnermittlung"]
[]
[{"$nulls":5},"Gewinnermittlungsart",{"$nulls":10}," Einnahmenüberschussrechnung"]
[]
[{"$nulls":16}," Vermögensvergleich (Bilanz)"]
[]
[{"$nulls":16}," Gewinnermittlung nach Durchschnittssätzen (nur bei Land- und Forstwirtschaft)"]
[]
[{"$nulls":16}," Sonstige (z. B. § 5a EStG)"]
[]
[{"$nulls":5},"Liegt ein vom Kalenderjahr abweichendes Wirtschaftsjahr vor?"]
[]
[{"$nulls":16}," Nein",{"$nulls":5},"Ja",{"$nulls":3},"Beginn",{"$nulls":13},"    (TT.MM.JJJJ)"]
[]
[{"$nulls":5},"5. Freistellungsbescheinigung gemäß § 48b Einkommensteuergesetz (EStG)",{"$nulls":36}," (\"Bauabzugsteuer\")"]
[]
[{"$nulls":5},"Das Merkblatt zum Steuerabzug bei Bauleistungen steht Ihnen im Internet unter www.bzst.de zum Download zur Verfügung."]
[{"$nulls":5},"Sie können es aber auch bei Ihrem Finanzamt erhalten."]
[]
[{"$nulls":7},"Ich beantrage die Erteilung einer Bescheinigung zur Freistellung vom Steuerabzug bei Bauleistungen gemäß § 48b EStG."]
[]
[{"$nulls":5},"6. Angaben zur Anmeldung und Abführung der Lohnsteuer"]
[]
[]
[{"$nulls":5},"Aushilfskräfte)",{"$nulls":7},"Insgesamt",{"$nulls":11},"angehörige",{"$nulls":13},"Beschäftigte"]
[]
[]
[{"$nulls":5},"Beginn der Lohnzahlungen",{"$nulls":23},"    (TT.MM.JJJJ)"]
[]
[]
[{"$nulls":5},"(voraussichtliche Lohnsteuer",{"$nulls":12}," (mehr als 4.000 EUR)",{"$nulls":13},"(mehr als 1.080 EUR)",{"$nulls":9}," (nicht mehr als 1.080 EUR)"]
[]
[]
[{"$nulls":8},"2016FsEEU015",{"$nulls":33},"2016FsEEU015"]

{"sheet":"Seite 6","index":5,"n_rows":93,"n_cols":51,"rows_kept":93,"merged":[[0,3,0,13],[2,3,2,52],[5,4,5,20],[6,4,6,10],[6,11,6,27],[8,4,8,48],[10,4,10,7],[11,4,11,51],[13,4,13,6],[14,4,14,51],[16,4,16,7],[16,11,16,16],[16,20,16,25],[17,4,17,8],[17,11,17,18],[17,20,17,51],[19,4,19,7],[19,13,19,14],[20,4,20,9],[20,13,20,51],[22,4,22,31],[23,4,23,16],[23,17,23,26],[23,30,23,40],[24,6,24,9],[24,17,24,26],[24,30,24,40],[26,17,26,26],[26,30,26,41],[28,4,29,39],[30,4,30,47],[32,6,32,7],[32,13,32,14],[32,17,32,31],[34,4,34,18],[36,6,36,36],[38,6,38,51],[40,6,40,51],[42,6,42,36],[43,6,43,51],[44,6,44,51],[46,4,47,20],[48,6,48,24],[50,4,50,6],[51,4,51,51],[52,4,52,19],[53,4,53,6],[54,4,54,51],[56,4,56,7],[56,11,56,16],[56,20,56,25],[57,4,57,8],[57,11,57,18],[57,20,57,51],[59,4,59,7],[59,13,59,14],[60,4,60,9],[60,13,60,51],[62,4,62,7],[62,13,62,17],[62,46,62,48],[63,4,63,9],[63,13,63,42],[63,46,63,51],[65,4,65,7],[66,4,66,51],[68,4,68,13],[69,4,69,13],[69,14,69,15],[69,16,69,23],[69,47,69,50],[71,4,71,7],[71,35,71,38],[72,4,72,32],[72,35,72,51],[74,4,74,16],[75,4,75,18],[76,4,76,38],[77,4,77,14],[79,16,79,23],[80,6,80,7],[80,13,80,14],[80,16,80,44],[80,45,80,47],[80,48,80,49],[80,50,80,51],[82,4,82,12],[83,4,83,49],[84,16,84,23],[85,6,85,7],[85,13,85,14],[85,16,85,40],[85,41,85,47],[85,48,85,49],[85,50,85,51],[87,4,87,23],[88,4,88,49],[89,16,89,23],[90,6,90,7],[90,13,90,14],[90,16,90,40],[90,41,90,47],[90,48,90,49],[90,50,90,51],[92,7,92,16],[92,41,92,50]]}
[null,null,"         "]
[]
[{"$nulls":3},""]
[]
[]
[]
[{"$nulls":4},"Steuernummer",{"$nulls":6},{"$f":"IF(ZFaSteuernummer=\"\",\"\",ZFaSteuernummer)","v":""}]
[]
[{"$nulls":4},"Die für die Lohnberechnung maßgebenden Lohnbestandteile werden zusammengefasst im Betrieb/Betriebsteil:"]
[]
[{"$nulls":4},"Bezeichnung"]
[]
[]
[{"$nulls":4},"Straße"]
[]
[]
[{"$nulls":4},"Hausnummer",{"$nulls":6},"Hausnummerzusatz",{"$nulls":8},"Adressergänzung"]
[]
[]
[{"$nulls":4},"Postleitzahl",{"$nulls":8},"Ort"]
[]
[]
[{"$nulls":4},"7. Angaben zur Anmeldung und Abführung der Umsatzsteuer"]
[{"$nulls":4},"7.1 Summe der Umsätze",{"$nulls":12},"im Jahr der Betriebseröffnung",{"$nulls":12},"im Folgejahr"]
[{"$nulls":6},"(geschätzt)",{"$nulls":10},"EUR",{"$nulls":12},"EUR"]
[]
[]
[]
[{"$nulls":4},"7.2 Geschäftsveräußerung im Ganzen (§ 1 Abs. 1a Umsatzsteuergesetz (UStG) )"]
[]
[{"$nulls":4},"Es wurde ein Unternehmen oder ein in der Gliederung eines Unternehmens gesondert geführter Betrieb erworben:"]
[]
[{"$nulls":6},"Nein",{"$nulls":6}," Ja",{"$nulls":3},"(siehe Eintragungen zu Tz. 2.6 Übernahme)"]
[]
[{"$nulls":4},"7.3 Kleinunternehmer-Regelung"]
[]
[{"$nulls":6},"Es wird die Kleinunternehmer-Regelung (§ 19 Abs. 1 UStG) in Anspruch genommen."]
[]
[{"$nulls":6},"In Rechnungen wird keine Umsatzsteuer gesondert ausgewiesen und es kann kein Vorsteuerabzug geltend gemacht werden."]
[]
[{"$nulls":6},"Hinweis: Angaben zu Tz. 7.8 sind nicht erforderlich; Umsatzsteuer-Voranmeldungen sind grundsätzlich nicht zu übermitteln."]
[]
[{"$nulls":6},"Es wird auf die Anwendung der Kleinunternehmer-Regelung verzichtet."]
[{"$nulls":6},"Die Besteuerung erfolgt nach den allgemeinen Vorschriften des Umsatzsteuergesetzes für mindestens fünf Kalenderjahre"]
[{"$nulls":6},"(§ 19 Abs. 2 UStG); Umsatzsteuer-Voranmeldungen sind monatlich in elektronischer Form authentifiziert zu übermitteln."]
[]
[{"$nulls":4},"7.4 Organschaft (§ 2 Abs. 2 Nr. 2 UStG)"]
[]
[{"$nulls":6},"Ich bin Organträger folgender Organgesellschaft:"]
[]
[{"$nulls":4},"Firma"]
[]
[]
[{"$nulls":4},"Straße"]
[]
[]
[{"$nulls":4},"Hausnummer",{"$nulls":6},"Hausnummerzusatz",{"$nulls":8},"Adressergänzung"]
[]
[]
[{"$nulls":4},"Postleitzahl",{"$nulls":8},"Ort"]
[]
[]
[{"$nulls":4},"Postleitzahl",{"$nulls":8},"Ort (Postfach)",{"$nulls":32},"Postfach"]
[]
[]
[{"$nulls":4},"Rechtsform"]
[]
[]
[{"$nulls":4},"Beteiligungsverhältnis (Bruchteil)"]
[{"$nulls":14},"/"]
[]
[{"$nulls":4},"Finanzamt",{"$nulls":30},"Steuernummer"]
[]
[]
[{"$nulls":4},"ggf. Umsatzsteuer-Identifikationsnummer"]
[]
[{"$nulls":4},"Hinweis: Weitere organschaftliche Verbindungen bitte in einer Anlage (formlos) mitteilen."]
[{"$nulls":4},"7.5 Steuerbefreiung"]
[{"$nulls":4},"Es werden ganz oder teilweise steuerfreie Umsätze gem. § 4 UStG ausgeführt:"]
[{"$nulls":16},"Art des Umsatzes/der Tätigkeit"]
[{"$nulls":6},"Nein",{"$nulls":6}," Ja",{"$nulls":31},"(§ 4 Nr.",{"$nulls":4},"UStG)"]
[]
[{"$nulls":4},"7.6 Steuersatz"]
[{"$nulls":4},"Es werden Umsätze ausgeführt, die ganz oder teilweise dem ermäßigten Steuersatz gem. § 12 Abs. 2 UStG unterliegen:"]
[{"$nulls":16},"Art des Umsatzes/der Tätigkeit"]
[{"$nulls":6},"Nein",{"$nulls":6}," Ja",{"$nulls":27},"(§ 12 Abs. 2 Nr.",{"$nulls":8},"UStG)"]
[]
[{"$nulls":4},"7.7 Durchschnittssatzbesteuerung"]
[{"$nulls":4},"Es werden ganz oder teilweise Umsätze ausgeführt, die der Durchschnittssatzbesteuerung gem. § 24 UStG unterliegen:"]
[{"$nulls":16},"Art des Umsatzes/der Tätigkeit"]
[{"$nulls":6},"Nein",{"$nulls":6}," Ja",{"$nulls":27},"(§ 24 Abs. 1 Nr.",{"$nulls":8},"UStG)"]
[]
[{"$nulls":7},"2016FsEEU016",{"$nulls":33},"2016FsEEU016"]

{"sheet":"Seite 7","index":6,"n_rows":85,"n_cols":46,"rows_kept":85,"merged":[[0,4,0,12],[2,4,2,49],[5,5,5,23],[6,5,6,11],[6,12,6,28],[8,5,9,24],[10,5,10,18],[10,20,10,34],[12,20,12,45],[14,21,14,22],[14,23,14,48],[16,21,16,22],[16,23,16,48],[18,21,18,22],[18,23,18,48],[20,5,20,24],[21,6,21,48],[23,5,23,8],[23,9,23,48],[25,6,25,34],[27,6,27,9],[27,10,27,25],[27,30,27,34],[27,35,27,44],[27,45,27,48],[29,5,29,48],[30,6,30,48],[32,8,32,48],[34,8,34,48],[36,5,36,8],[36,9,36,48],[39,5,39,48],[41,5,41,48],[42,5,42,48],[43,5,43,48],[45,6,45,48],[48,5,48,36],[50,5,50,16],[51,5,51,48],[52,5,52,22],[53,5,53,7],[54,5,54,48],[56,5,56,8],[56,13,56,17],[56,22,56,26],[57,5,57,9],[57,13,57,18],[57,22,57,48],[59,5,59,8],[59,14,59,16],[60,5,60,10],[60,14,60,40],[62,5,62,8],[62,14,62,16],[62,43,62,44],[63,5,63,10],[63,14,63,40],[63,43,63,48],[65,5,65,8],[65,34,65,38],[66,5,66,32],[66,34,66,48],[68,5,68,27],[71,5,71,8],[71,9,71,48],[72,9,72,48],[79,5,79,24],[80,5,80,8],[80,27,80,48],[81,27,81,48],[84,8,84,19],[84,39,84,47]]}
[]
[]
[{"$nulls":4},""]
[]
[]
[]
[{"$nulls":5},"Steuernummer",{"$nulls":6},{"$f":"IF(ZFaSteuernummer=\"\",\"\",ZFaSteuernummer)","v":""}]
[]
[{"$nulls":5},"7.8 Soll-/Istversteuerung der Entgelte"]
[]
[{"$nulls":5},"Ich berechne die Umsatzsteuer nach",{"$nulls":14}," vereinbarten Entgelten (Sollversteuerung)."]
[]
[{"$nulls":20}," vereinnahmten Entgelten. Ich beantrage hiermit die Istversteuerung, weil"]
[]
[{"$nulls":23}," der auf das Kalenderjahr hochgerechnete Gesamtumsatz für das Gründungsjahr"]
[]
[{"$nulls":23}," ich von der Verpflichtung, Bücher zu führen und auf Grund jährlicher Bestandsaufnahmen"]
[]
[{"$nulls":23}," von § 18 Abs. 1 Nr. 1 des Einkommensteuergesetzes weder buchführungspfichtig bin"]
[]
[{"$nulls":5},"7.9 Umsatzsteuer-Identifikationsnummer"]
[{"$nulls":6}," Ich benötige für die Teilnahme am innergemeinschaftlichen Waren- und Dienstleistungsverkehr eine Umsatzsteuer-Identifikations-"]
[]
[{"$nulls":5},"Hinweis:",{"$nulls":3},"Bei Vorliegen einer Organschaft ist die Ust-IdNr. der Organgesellschaft vom Organträger zu beantragen."]
[]
[{"$nulls":6}," Ich habe bereits für eine frühere Tätigkeit folgende USt-IdNr. erhalten:"]
[]
[{"$nulls":6}," USt-IdNr.",{"$nulls":23},"Vergabedatum:",{"$nulls":14},"  (TT.MM.JJJJ)"]
[]
[{"$nulls":5},"7.10 Steuerschuldnerschaft des Leistungsempfängers bei Bau- und/oder Gebäudereinigungsleistungen"]
[{"$nulls":6}," Es wird die Erteilung eines Nachweises zur Steuerschuldnerschaft des Leistungsempfängers bei Bau- und/oder Gebäudereinigungs-"]
[]
[{"$nulls":8}," Der Umfang der ausgeführten Bauleistungen i. S. des § 13b Abs. 2 Nr. 4 UStG beträgt voraussichtlich mehr als"]
[]
[{"$nulls":8}," Der Umfang der ausgeführten Gebäudereinigungsleistungen i. S. des § 13b Abs. 2 Nr. 8 UStG beträgt voraussichtlich"]
[]
[{"$nulls":5},"Hinweis:",{"$nulls":3},"Die Voraussetzungen zur Erteilung der Bescheinigung sind in geeigneter Weise in einer Anlage glaubhaft zu machen."]
[]
[]
[{"$nulls":5},"7.11 Besonderes Besteuerungsverfahren „Mini-one-stop-shop“"]
[]
[{"$nulls":5},"Nur bei Ausführung von Telekommunikationsleistungen, Rundfunk- und Fernsehdienstleistungen oder auf elektronischem Weg"]
[{"$nulls":5},"erbrachten sonstigen Leistungen durch einen in einem anderen EU-Mitgliedstaat ansässigen Unternehmer an einen im Inland"]
[{"$nulls":5},"ansässigen Nichtunternehmer:"]
[]
[{"$nulls":6}," Ich nehme das besondere Besteuerungsverfahren („Mini-one-stop-shop“) in Anspruch. Die entsprechenden Umsätze erkläre"]
[]
[]
[{"$nulls":5},"8. Angaben zur Beteiligung an einer Personengesellschaft/-gemeinschaft"]
[]
[{"$nulls":5},"Bezeichnung der Gesellschaft / Gemeinschaft"]
[]
[]
[{"$nulls":5},"Straße"]
[]
[]
[{"$nulls":5},"Hausnummer",{"$nulls":7},"Hausnummerzusatz",{"$nulls":8},"Adressergänzung"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Wohnort"]
[]
[]
[{"$nulls":5},"Postleitzahl",{"$nulls":8},"Ort (Postfach)",{"$nulls":28},"Postfach"]
[]
[]
[{"$nulls":5},"Finanzamt",{"$nulls":28},"Steuernummer"]
[]
[]
[{"$nulls":5},"(Fügen Sie bitte eine Kopie des Gesellschaftsvertrags bei!)"]
[]
[]
[{"$nulls":5},"Hinweis:",{"$nulls":3},"Die mit diesem Fragebogen angeforderten Daten werden aufgrund der §§ 85, 88, 90, 93 und 97 AO"]
[{"$nulls":9},"erhoben."]
{"$rows_empty":7}
[{"$nulls":5},"Ort, Datum",{"$nulls":21},"Unterschrift des/der Steuerpflichtigen und ggf. des Ehegatten/der Ehegattin bzw. des/der"]
[{"$nulls":27},"eingetragenen Lebenspartners/Lebenspartnerin bzw. des/der Vertreter(s) oder Bevollmächtigten"]
[]
[]
[{"$nulls":8},"2016FsEEU017",{"$nulls":30},"2016FsEEU017"]

{"sheet":"Seite 8","index":7,"n_rows":71,"n_cols":35,"rows_kept":71,"merged":[[0,3,0,12],[2,3,2,44],[5,4,5,17],[6,4,6,9],[6,10,6,23],[10,4,10,8],[10,11,10,43],[12,11,12,27],[14,11,14,27],[16,11,16,27],[18,11,18,27],[20,11,20,27],[22,11,22,42],[27,4,27,28],[29,5,29,8],[32,5,32,24],[33,5,33,24],[34,5,34,24],[70,7,70,14],[70,34,70,41]]}
[]
[]
[{"$nulls":3},""]
[]
[]
[]
[{"$nulls":4},"Steuernummer",{"$nulls":5},{"$f":"IF(ZFaSteuernummer=\"\",\"\",ZFaSteuernummer)","v":""}]
[]
[]
[]
[{"$nulls":4},"Anlagen:",{"$nulls":6},"Teilnahmeerklärung für das SEPA-Lastschriftverfahren (Tz. 1.5)"]
[]
[{"$nulls":11},"Empfangsvollmacht (Tz. 1.7)"]
[]
[{"$nulls":11},"Aufstellung über Betriebstätten (Tz. 2.3)"]
[]
[{"$nulls":11},"Verträge bei Übernahme bzw. Umwandlung (Tz. 2.5)"]
[]
[{"$nulls":11},"Weitere organschaftliche Verbindungen (Tz. 7.4)"]
[]
[{"$nulls":11},"Gesellschaftsvertrag (Tz. 8)"]
{"$rows_empty":8}
[{"$nulls":5},"Finanzamt"]
{"$rows_empty":40}
[{"$nulls":7},"2016FsEEU018",{"$nulls":26},"2016FsEEU018"]

{"sheet":"Attribute","index":8,"n_rows":6,"n_cols":3,"rows_kept":6,"hidden":true}
["KAW-Variable","Wert","Bezeichnung"]
["KAW020001",{"$f":"IF(Mandantennummer=\"\",\"\",Mandantennummer)","v":""},"Nummer"]
["KAW010101",{"$f":"IF(FirstRun=\"\",\"\",YEAR(FirstRun))","v":2017},"Jahr"]
["KAW010102",{"$f":"IF(FirstRun=\"\",\"\",MONTH(FirstRun))","v":3},"Monat"]
["KAW010103","Fragebogen - Aufnahme gewerbliche Tätigkeit / Beteiligung Personengesellschaft","Beschreibung"]
["KAW010105","Fragebogen, Aufnahme gewerbliche Tätigkeit, Beteiligung Personengesellschaft","Stichworte"]

{"sheet":"Drucken","index":9,"n_rows":9,"n_cols":12,"rows_kept":9,"hidden":true}
["Sheetname","Header","Caption","Checked","Druck","Linebreak","WithBlankSheet","BlankSheetName","Seiten","Drucker","BeraterMandant","Duplex"]
["Seite 1","Header",null,"true",true,{"$nulls":3},1,null,true,true]
["Seite 2","Header2",null,"true",true,{"$nulls":3},1]
["Seite 3","Header3",null,"true",true,{"$nulls":3},1]
["Seite 4","Header4",null,"true",true,{"$nulls":3},1]
["Seite 5","Header5",null,"true",true,{"$nulls":3},1]
["Seite 6","Header6",null,"true",true,{"$nulls":3},1]
["Seite 7","Header7",null,"true",true,{"$nulls":3},1]
["Seite 8","Header8",null,"true",true,{"$nulls":3},1]

{"sheet":"Eintragung","index":10,"n_rows":219,"n_cols":28,"rows_kept":219,"hidden":true}
["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",null,"Werte 1-5","Werte 6-10","Werte 1-5","Werte 6-10","Werte 1-5","Werte 6-10","Werte 1-5","Werte 6-10","Werte 1-5","Werte 6-10"]
["ZMSD","$Mandant.Nummer","NA",null,"Mandantennummer","",null,"FA Person"]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Bezeichnung1","NA",null,"FaPersName","",null,"FA Person"]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Hauptstrasse.Strasse","NA",null,"FaPersStrasse","",null,{"$f":"IF(AND(FaPersName=\"\",FaPersStrasse=\"\",FaPersPLZStrasse=\"\",FaPersOrtStrasse=\"\",FaPersPostfach=\"\",FaPersPLZPostfach=\"\",FaPersOrtPostfach=\"\",FaPersSteuernummer=\"\"),\"\",\"FA\")","v":""}]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Hauptstrasse.PLZ","NA",null,"FaPersPLZStrasse",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Hauptstrasse.Ort","NA",null,"FaPersOrtStrasse",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Hauptpostfach.Postfach","NA",null,"FaPersPostfach",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Hauptpostfach.PLZ","NA",null,"FaPersPLZPostfach",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Hauptpostfach.Ort","NA",null,"FaPersOrtPostfach",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Steuernummer","NA",null,"FaPersSteuernummer",""]
["ZMSD","NA","$Betrieb.Hauptfinanzamt.Info.Bezeichnung1",null,"FaUntName","",null,"FA Betrieb"]
["ZMSD","NA","$Betrieb.Hauptfinanzamt.Info.Korrespondenz.Strasse",null,"FaUntStrasse","",null,{"$f":"IF(AND(FaUntName=\"\",FaUntStrasse=\"\",FaUntPLZStrasse=\"\",FaUntOrtStrasse=\"\",FaUntPostfach=\"\",FaUntSteuernummer=\"\"),\"\",\"FA\")","v":""}]
["ZMSD","NA","$Betrieb.Hauptfinanzamt.Info.Korrespondenz.PLZ",null,"FaUntPLZStrasse",""]
["ZMSD","NA","$Betrieb.Hauptfinanzamt.Info.Korrespondenz.Ort",null,"FaUntOrtStrasse",""]
["ZMSD","NA","$Betrieb.Hauptfinanzamt.Info.Korrespondenz.Postfach",null,"FaUntPostfach",""]
["ZMSD","NA","$Betrieb.Hauptfinanzamt.Steuernummer",null,"FaUntSteuernummer",""]
["ZMSD","$Steuerpflichtiger.TitelAkademischerGrad","NA",null,"PersTitel",""]
["ZMSD","$Steuerpflichtiger.Vorname","NA",null,"PersVorname",""]
["ZMSD","$Steuerpflichtiger.Nachname","NA",null,"PersName",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Geburt.Name","NA",null,"PersGeburtsname",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Geburt.Datum","NA",null,"PersGeburtsdatum",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Religion","NA",null,"PersReligion",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Beruf","NA",null,"PersBeruf",""]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.Strasse","NA",null,"PersStrasse",""]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.PLZ","NA",null,"PersPLZStrasse",""]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.Ort","NA",null,"PersOrtStrasse",""]
["ZMSD","$Steuerpflichtiger.Hauptpostfach.Postfach","NA",null,"PersPostfach",""]
["ZMSD","$Steuerpflichtiger.Hauptpostfach.PLZ","NA",null,"PersPLZPostfach",""]
["ZMSD","$Steuerpflichtiger.Hauptpostfach.Ort","NA",null,"PersOrtPostfach",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Identifikationsnummer","NA",null,"PersIdentNr"]
["ZMSD","$Steuerpflichtiger.Haupttelefon.Nummer","NA",null,"PersTelefon",""]
["ZMSD","$Steuerpflichtiger.Hauptemail.Nummer","NA",null,"PersEmail",""]
["ZMSD","$Steuerpflichtiger.Kommunikation[].Medium","NA",10,"PersKomm","",null,"","","","","","","","","",""]
["ZMSD","$Steuerpflichtiger.Kommunikation[].Nummer","NA",10,"PersKommNummer","",null,"","","","","","","","","",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Familienstand","NA",null,"PersFamilienstand",""]
["ZMSD","NA","NA",null,"PersFamilieDatum",""]
["ZMSD","$Ehegatte.TitelAkademischerGrad","NA",null,"EgTitel",""]
["ZMSD","$Ehegatte.Vorname","NA",null,"EgVorname",""]
["ZMSD","$Ehegatte.Nachname","NA",null,"EgNachname",""]
["ZMSD","$Ehegatte.PersoenlicheDaten.Geburt.Name","NA",null,"EgGeburtsname",""]
["ZMSD","$Ehegatte.PersoenlicheDaten.Geburt.Datum","NA",null,"EgGeburtsdatum",""]
["ZMSD","$Ehegatte.PersoenlicheDaten.Religion","NA",null,"EgReligion",""]
["ZMSD","$Ehegatte.PersoenlicheDaten.Beruf","NA",null,"EgBeruf",""]
["ZMSD","$Ehegatte.Hauptstrasse.Strasse","NA",null,"EgStrasse",""]
["ZMSD","$Ehegatte.Hauptstrasse.PLZ","NA",null,"EgPLZ",""]
["ZMSD","$Ehegatte.Hauptstrasse.Ort","NA",null,"EgOrt",""]
["ZMSD","$Ehegatte.PersoenlicheDaten.Identifikationsnummer","NA",null,"EgIdentNr"]
["ZMSD","$Kind[].Vorname","NA","3","KindVorname","",null,"","","","","","","","","",""]
["ZMSD","$Kind[].Nachname","NA","3","KindAbwName","",null,"","","","","","","","","",""]
["ZMSD","$Kind[].PersoenlicheDaten.Geburt.Datum","NA","3","KindGeburtsdatum","",null,"","","","","","","","","",""]
["ZMSD","$Steuerpflichtiger.Bank[].Bankkonto.Info.Bezeichnung1","NA","30","PersBankName","",0,"","","","","","","","","",""]
["ZMSD","$Steuerpflichtiger.Bank[].Bankkonto.IBAN","NA","30","PersBankIBAN"]
["ZMSD","$Steuerpflichtiger.Bank[].Bankkonto.Info.BIC","NA","30","PersBankBIC"]
["ZMSD","$Steuerpflichtiger.Bank[].AbwKontoinhaber","NA","30","PersBankAbweicher","",null,"","","","","","","","","",""]
["ZMSD","$Steuerpflichtiger.Hauptbank.Bankkonto.IBAN","NA",null,"PersBankHauptIBAN",null,{"$f":"IF(PersBankHauptIBAN<>\"\",IF(ISNA(MATCH(PersBankHauptIBAN,H52:IV52,0)),0,MATCH(PersBankHauptIBAN,H52:IV52,0)),0)","v":0}]
["ZMSD","NA","$Betrieb.Bank[].Bankkonto.Info.Bezeichnung1","30","UntBankName","",0,"","","","","","","","","",""]
["ZMSD","NA","$Betrieb.Bank[].Bankkonto.IBAN","30","UntBankIBAN"]
["ZMSD","NA","$Betrieb.Bank[].Bankkonto.Info.BIC","30","UntBankBIC"]
["ZMSD","NA","$Betrieb.Bank[].AbwKontoinhaber","30","UntBankAbweicher","",null,"","","","","","","","","",""]
["ZMSD","NA","$Betrieb.Hauptbank.Bankkonto.IBAN",null,"UntBankHauptIBAN",null,{"$f":"IF(UntBankHauptIBAN<>\"\",IF(ISNA(MATCH(UntBankHauptIBAN,H57:IV57,0)),0,MATCH(UntBankHauptIBAN,H57:IV57,0)),0)","v":0}]
["ZMSD","NA","NA",null,"BankAlleBezeichnung","","0","","","","","","","","","",""]
["ZMSD","NA","NA",null,"BankAlleIBAN"]
["ZMSD","NA","NA",null,"BankAlleBic"]
["ZMSD","NA","NA",null,"BankAlleAbweicher","",null,"","","","","","","","","",""]
["ZMSD","NA","NA",null,"BankPers","",{"$f":"IF(PersBankHauptIBAN<>\"\",IF(ISNA(MATCH(PersBankHauptIBAN,H52:IV52,0)),0,MATCH(PersBankHauptIBAN,H52:IV52,0)),0)","v":0}]
["ZMSD","NA","NA",null,"BankUnt",null,{"$f":"IF(UntBankHauptIBAN<>\"\",IF(ISNA(MATCH(UntBankHauptIBAN,H57:IV57,0)),0,MATCH(UntBankHauptIBAN,H57:IV57,0)),0)","v":0}]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Unternehmensbezeichnung","NA",null,"EmpfPersBezeichnung",null,null,"Empf Person"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.TitelAkademischerGrad","NA",null,"EmpfPersTitel",null,null,{"$f":"IF(AND(EmpfPersBezeichnung=\"\",EmpfPersTitel=\"\",EmpfPersVorname=\"\",EmpfPersNachname=\"\",EmpfPersStrasse=\"\",EmpfPersPLZStrasse=\"\",EmpfPersOrtStrasse=\"\",EmpfPersPLZPostfach=\"\",EmpfPersOrtPostfach=\"\",EmpfPersPostfach=\"\"),\"\",\"Empf\")","v":""}]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Vorname","NA",null,"EmpfPersVorname"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Nachname","NA",null,"EmpfPersNachname"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Hauptstrasse.Strasse","NA",null,"EmpfPersStrasse"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Hauptstrasse.PLZ","NA",null,"EmpfPersPLZStrasse"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Hauptstrasse.Ort","NA",null,"EmpfPersOrtStrasse"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Hauptpostfach.PLZ","NA",null,"EmpfPersPLZPostfach"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Hauptpostfach.Ort","NA",null,"EmpfPersOrtPostfach"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Hauptpostfach.Postfach","NA",null,"EmpfPersPostfach"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Haupttelefon.Nummer","NA",null,"EmpfPersTel"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Haupttelefax.Nummer","NA",null,"EmpfPersFax"]
["ZMSD","$EmpfangsbevollmaechtigerPerson.Hauptemail.Nummer","NA",null,"EmpfPersEmail"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Unternehmensbezeichnung",null,"EmpfUntBezeichnung",null,null,"Empf Betrieb"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.TitelAkademischerGrad",null,"EmpfUntTitel",null,null,{"$f":"IF(AND(EmpfUntBezeichnung=\"\",EmpfUntTitel=\"\",EmpfUntVorname=\"\",EmpfUntNachname=\"\",EmpfUntStrasse=\"\",EmpfUntPLZStrasse=\"\",EmpfUntOrtStrasse=\"\",EmpfUntPLZPostfach=\"\",EmpfUntOrtPostfach=\"\",EmpfUntPostfach=\"\"),\"\",\"Empf\")","v":""}]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Vorname",null,"EmpfUntVorname"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Nachname",null,"EmpfUntNachname"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Hauptstrasse.Strasse",null,"EmpfUntStrasse"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Hauptstrasse.PLZ",null,"EmpfUntPLZStrasse"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Hauptstrasse.Ort",null,"EmpfUntOrtStrasse"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Hauptpostfach.PLZ",null,"EmpfUntPLZPostfach"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Hauptpostfach.Ort",null,"EmpfUntOrtPostfach"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Hauptpostfach.Postfach",null,"EmpfUntPostfach"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Haupttelefon.Nummer",null,"EmpfUntTel"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Haupttelefax.Nummer",null,"EmpfUntFax"]
["ZMSD","NA","$EmpfangsbevollmaechtigerUnternehmen.Hauptemail.Nummer",null,"EmpfUntEmail"]
["ZMSD","NA","$Betrieb.Unternehmensgegenstand",null,"UntGegenstand",""]
["ZMSD","NA","$Betrieb.Unternehmensbezeichnung",null,"UntBezeichnung",""]
["ZMSD","NA","$Betrieb.Hauptstrasse.Strasse",null,"UntStrasse",""]
["ZMSD","NA","$Betrieb.Hauptstrasse.PLZ",null,"UntPLZStrasse",""]
["ZMSD","NA","$Betrieb.Hauptstrasse.Ort",null,"UntOrtStrasse",""]
["ZMSD","NA","$Betrieb.Hauptpostfach.Postfach",null,"UntPostfach",""]
["ZMSD","NA","$Betrieb.Hauptpostfach.PLZ",null,"UntPLZPostfach",""]
["ZMSD","NA","$Betrieb.Hauptpostfach.Ort",null,"UntOrtPostfach",""]
["ZMSD","NA","$Betrieb.Geschaeftsleitung.Strasse",null,"UntGlStrasse"]
["ZMSD","NA","$Betrieb.Geschaeftsleitung.PLZ",null,"UntGlPlz"]
["ZMSD","NA","$Betrieb.Geschaeftsleitung.Ort",null,"UntGlOrt"]
["ZMSD","NA","$Betrieb.Haupttelefon.Nummer",null,"UntTelefon",""]
["ZMSD","NA","$Betrieb.Haupttelefax.Nummer",null,"UntFax",""]
["ZMSD","NA","$Betrieb.Hauptemail.Nummer",null,"UntEmail",""]
["ZMSD","NA","$Betrieb.Kommunikation[].Medium",10,"UntKomm","",null,"","","","","","","","","",""]
["ZMSD","NA","$Betrieb.Kommunikation[].Nummer",10,"UntKommNummer","",null,"","","","","","","","","",""]
["ZMSD","NA","$Betriebsstaette[].Unternehmen.Unternehmensbezeichnung","5","BsBezeichnung","","0","","","","","","","","","",""]
["ZMSD","NA","$Betriebsstaette[].Unternehmen.Hauptstrasse.Strasse","5","BsStrasse","",null,"","","","","","","","","",""]
["ZMSD","NA","$Betriebsstaette[].Unternehmen.Hauptstrasse.PLZ","5","BsPLZ","",null,"","","","","","","","","",""]
["ZMSD","NA","$Betriebsstaette[].Unternehmen.Hauptstrasse.Ort","5","BsOrt","",null,"","","","","","","","","",""]
["ZMSD","NA","$Betriebsstaette[].Unternehmen.Haupttelefon.Nummer","5","BsTelefon","",null,"","","","","","","","","",""]
["ZMSD","NA","$Betrieb.BetrieblicheDaten.Register.Art",null,"UntRegister",""]
["ZMSD","NA","$Betrieb.BetrieblicheDaten.Register.Gericht",null,"UntRegisterGericht"]
["ZMSD","NA","$Betrieb.BetrieblicheDaten.Register.Gerichtsnummer",null,"UntRegisterNummer"]
["ZMSD","NA","$Betrieb.BetrieblicheDaten.Register.EintragAm",null,"UntRegisterDatum","",null,"Länge=8?","Beginn abweichend?","Ende abweichend?","Dauer 12 Monate?","Innerhalb Kalenderjahr?"]
["ZMSD","NA","$Betrieb.BetrieblicheDaten.Wirtschaftsjahr",null,"UntWj",null,null,{"$f":"IF(LEN(UntWj)=8,TRUE,FALSE)","v":false},{"$f":"IF(LEFT(UntWj,4)=\"0101\",FALSE,TRUE)","v":true},{"$f":"IF(RIGHT(UntWj,4)=\"3112\",FALSE,TRUE)","v":true},{"$f":"IF(H118,IF(OR(DATE(YEAR(TODAY()),VALUE(MID(UntWj,7,2)),VALUE(MID(UntWj,5,2)))+1=DATE(YEAR(TODAY()),VALUE(MID(UntWj,3,2)),VALUE(MID(UntWj,1,2))),NOT(OR(I118,J118))),TRUE,FALSE),TRUE)","v":true},{"$f":"IF(H118,IF(VALUE(MID(UntWj,3,2))>VALUE(MID(UntWj,7,2)),FALSE,TRUE),TRUE)","v":true}]
["ZMSD","NA","$Betrieb.Umsatzsteuer.UmsatzsteuerId",null,"USt_IdNr",""]
["COPY",{"$nulls":3},"ZFaBezeichnung",{"$f":"IF(AND(FAPerson=\"\",FABetrieb=\"\"),\"\",IF(FABetrieb=\"\",IF(FaPersName=\"\",\"\",FaPersName),IF(FaUntName=\"\",\"\",FaUntName)))","v":""}]
["COPY",{"$nulls":3},"ZFaSteuernummer",{"$f":"IF(AND(FaPersName=\"\",FaUntName=\"\"),\"\",IF(FaUntName=\"\",FaPersSteuernummer,FaUntSteuernummer))","v":""}]
["COPY",{"$nulls":3},"ZPersName",{"$f":"IF(PersName=\"\",\"\",PersName) & IF(PersTitel=\"\",\"\",\", \"&PersTitel)","v":""}]
["COPY",{"$nulls":3},"ZPersVorname",{"$f":"IF(PersVorname=\"\",\"\",PersVorname)","v":""}]
["COPY",{"$nulls":3},"ZPersGeburtsname",{"$f":"IF(PersGeburtsname=\"\",\"\",PersGeburtsname)","v":""}]
["COPY",{"$nulls":3},"ZPersGeburt",{"$f":"IF(PersGeburtsdatum=\"\",\"\",Datumkonvert(PersGeburtsdatum))","v":""}]
["COPY",{"$nulls":3},"ZPersReligion",{"$f":"IF(PersReligion=\"\",\"\",IF(PersReligion=\"EV\",\"EV\",IF(PersReligion=\"RK\",\"RK\",IF(PersReligion=\"KL\",\"VD\",\"\"))))","v":""}]
["COPY",{"$nulls":3},"ZPersBeruf",{"$f":"IF(PersBeruf=\"\",\"\",PersBeruf)","v":""}]
["COPY",{"$nulls":3},"ZPersStrasse",{"$f":"IF(PersStrasse=\"\",\"\",PersStrasse)","v":""}]
["COPY",{"$nulls":3},"ZPersPLZStrasse",{"$f":"IF(PersPLZStrasse=\"\",\"\",PersPLZStrasse)","v":""}]
["COPY",{"$nulls":3},"ZPersOrtStrasse",{"$f":"IF(PersOrtStrasse=\"\",\"\",PersOrtStrasse)","v":""}]
["COPY",{"$nulls":3},"ZPersPostfach",{"$f":"IF(PersPostfach=\"\",\"\",PersPostfach)","v":""}]
["COPY",{"$nulls":3},"ZPersPLZPostfach",{"$f":"IF(PersPLZPostfach=\"\",\"\",PersPLZPostfach)","v":""}]
["COPY",{"$nulls":3},"ZPersOrtPostfach",{"$f":"IF(PersOrtPostfach=\"\",\"\",PersOrtPostfach)","v":""}]
["COPY",{"$nulls":3},"ZPersIdentNr",{"$f":"IF(PersIdentNr=\"\",\"\",PersIdentNr)","v":""}]
["COPY",{"$nulls":3},"ZPersTelefon",{"$f":"IF(PersTelefon=\"\",\"\",PersTelefon)","v":""}]
["COPY",{"$nulls":3},"ZPersEmail",{"$f":"IF(PersEmail=\"\",\"\",PersEmail)","v":""}]
["COPY",{"$nulls":3},"ZPersInternet",{"$f":"IF(ISNA(HLOOKUP(\"3\",H33:Q34,2,FALSE)),\"\",HLOOKUP(\"3\",H33:Q34,2,FALSE))","v":""}]
["COPY",{"$nulls":3},"ZPersVerheiratet",{"$f":"IF(OR(PersFamilienstand=\"VH\",PersFamilienstand=\"PE\"),Datumkonvert(PersFamilieDatum),\"\")","v":""}]
["COPY",{"$nulls":3},"ZPersVerwitwet",{"$f":"IF(PersFamilienstand=\"VW\",Datumkonvert(PersFamilieDatum),\"\")","v":""}]
["COPY",{"$nulls":3},"ZPersGeschieden",{"$f":"IF(OR(PersFamilienstand=\"GS\",PersFamilienstand=\"PA\"),Datumkonvert(PersFamilieDatum),\"\")","v":""}]
["COPY",{"$nulls":3},"ZPersGetrennt",{"$f":"IF(PersFamilienstand=\"GT\",Datumkonvert(PersFamilieDatum),\"\")","v":""}]
["COPY",{"$nulls":3},"ZEgName",{"$f":"IF(EgNachname=\"\",\"\",EgNachname) & IF(EgTitel=\"\",\"\",\", \"&EgTitel)","v":""}]
["COPY",{"$nulls":3},"ZEgVorname",{"$f":"IF(EgVorname=\"\",\"\",EgVorname)","v":""}]
["COPY",{"$nulls":3},"ZEgGeburtsname",{"$f":"IF(EgGeburtsname=\"\",\"\",EgGeburtsname)","v":""}]
["COPY",{"$nulls":3},"ZEgGeburt",{"$f":"IF(EgGeburtsdatum=\"\",\"\",Datumkonvert(EgGeburtsdatum))","v":""}]
["COPY",{"$nulls":3},"ZEgReligion",{"$f":"IF(EgReligion=\"\",\"\",IF(EgReligion=\"EV\",\"EV\",IF(EgReligion=\"RK\",\"RK\",IF(EgReligion=\"KL\",\"VD\",\"\"))))","v":""}]
["COPY",{"$nulls":3},"ZEgBeruf",{"$f":"IF(EgBeruf=\"\",\"\",EgBeruf)","v":""}]
["COPY",{"$nulls":3},"ZEgStrasse",{"$f":"IF(EgStrasse=\"\",\"\",IF(EgStrasse=PersStrasse,\"\",EgStrasse))","v":""}]
["COPY",{"$nulls":3},"ZEgPLZ",{"$f":"IF(EgPLZ=\"\",\"\",IF(EgPLZ=PersPLZStrasse,\"\",EgPLZ))","v":""}]
["COPY",{"$nulls":3},"ZEgOrt",{"$f":"IF(EgOrt=\"\",\"\",IF(EgOrt=PersOrtStrasse,\"\",EgOrt))","v":""}]
["COPY",{"$nulls":3},"ZEgIdentNr",{"$f":"IF(EgIdentNr=\"\",\"\",EgIdentNr)","v":""}]
["COPY",{"$nulls":3},"ZAlleIBAN",{"$f":"IF(BankAlleIBAN=\"\",\"\",BankAlleIBAN)","v":""}]
["COPY",{"$nulls":3},"ZAlleBIC",{"$f":"IF(BankAlleBic=\"\",\"\",BankAlleBic)","v":""}]
["COPY",{"$nulls":3},"ZAlleName",{"$f":"IF(BankAlleBezeichnung=\"\",\"\",BankAlleBezeichnung)","v":""}]
["COPY",{"$nulls":3},"ZAlleAbweicher",{"$f":"IF(BankAlleAbweicher=\"\",\"\",BankAlleAbweicher)","v":""}]
["COPY",{"$nulls":3},"ZPersonIBAN",{"$f":"IF(PersBankIBAN=\"\",\"\",PersBankIBAN)","v":""}]
["COPY",{"$nulls":3},"ZPersonBIC",{"$f":"IF(PersBankBIC=\"\",\"\",PersBankBIC)","v":""}]
["COPY",{"$nulls":3},"ZPersonName",{"$f":"IF(PersBankName=\"\",\"\",PersBankName)","v":""}]
["COPY",{"$nulls":3},"ZPersonAbweicher",{"$f":"IF(PersBankAbweicher=\"\",\"\",PersBankAbweicher)","v":""}]
["COPY",{"$nulls":3},"ZBetriebIBAN",{"$f":"IF(UntBankIBAN=\"\",\"\",UntBankIBAN)","v":""}]
["COPY",{"$nulls":3},"ZBetriebBIC",{"$f":"IF(UntBankBIC=\"\",\"\",UntBankBIC)","v":""}]
["COPY",{"$nulls":3},"ZBetriebName",{"$f":"IF(UntBankName=\"\",\"\",UntBankName)","v":""}]
["COPY",{"$nulls":3},"ZBetriebAbweicher",{"$f":"IF(UntBankAbweicher=\"\",\"\",UntBankAbweicher)","v":""}]
["COPY",{"$nulls":3},"ZEmpfBezeichnung",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntBezeichnung=\"\",\"\",EmpfUntBezeichnung),IF(EmpfPersBezeichnung=\"\",\"\",EmpfPersBezeichnung)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfName",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntNachname=\"\",\"\",EmpfUntNachname) & IF(EmpfUntTitel=\"\",\"\",\", \" & EmpfUntTitel),IF(EmpfPersNachname=\"\",\"\",EmpfPersNachname) & IF(EmpfPersTitel=\"\",\"\",\", \" & EmpfPersTitel)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfVorname",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntVorname=\"\",\"\",EmpfUntVorname),IF(EmpfPersVorname=\"\",\"\",EmpfPersVorname)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfStrasse",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntStrasse=\"\",\"\",EmpfUntStrasse),IF(EmpfPersStrasse=\"\",\"\",EmpfPersStrasse)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfPLZStrasse",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntPLZStrasse=\"\",\"\",EmpfUntPLZStrasse),IF(EmpfPersPLZStrasse=\"\",\"\",EmpfPersPLZStrasse)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfOrtStrasse",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntOrtStrasse=\"\",\"\",EmpfUntOrtStrasse),IF(EmpfPersOrtStrasse=\"\",\"\",EmpfPersOrtStrasse)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfPLZPostfach",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntPLZPostfach=\"\",\"\",EmpfUntPLZPostfach),IF(EmpfPersPLZPostfach=\"\",\"\",EmpfPersPLZPostfach)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfOrtPostfach",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntOrtPostfach=\"\",\"\",EmpfUntOrtPostfach),IF(EmpfPersOrtPostfach=\"\",\"\",EmpfPersOrtPostfach)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfPostfach",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntPostfach=\"\",\"\",EmpfUntPostfach),IF(EmpfPersPostfach=\"\",\"\",EmpfPersPostfach)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfTelefon",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntTel=\"\",\"\",EmpfUntTel),IF(EmpfPersTel=\"\",\"\",EmpfPersTel)))","v":""}]
["COPY",{"$nulls":3},"ZEmpfEMail",{"$f":"IF(AND(EmpfPerson=\"\",EmpfBetrieb=\"\"),\"\",IF(EmpfBetrieb=\"Empf\",IF(EmpfUntEmail=\"\",\"\",EmpfUntEmail),IF(EmpfPersEmail=\"\",\"\",EmpfPersEmail)))","v":""}]
["COPY",{"$nulls":3},"ZUntGegenstand1",{"$f":"IF(UntGegenstand=\"\",\"\",UntGegenstand)","v":""}]
["COPY",{"$nulls":3},"ZUntGegenstand2",{"$f":"\"\"","v":""}]
["COPY",{"$nulls":3},"ZUntBezeichnung",{"$f":"IF(UntBezeichnung=\"\",\"\",UntBezeichnung)","v":""}]
["COPY",{"$nulls":3},"ZUntStrasse",{"$f":"IF(UntStrasse=\"\",\"\",UntStrasse)","v":""}]
["COPY",{"$nulls":3},"ZUntPLZStrasse",{"$f":"IF(UntPLZStrasse=\"\",\"\",UntPLZStrasse)","v":""}]
["COPY",{"$nulls":3},"ZUntOrtStrasse",{"$f":"IF(UntOrtStrasse=\"\",\"\",UntOrtStrasse)","v":""}]
["COPY",{"$nulls":3},"ZUntPLZPostfach",{"$f":"IF(UntPLZPostfach=\"\",\"\",UntPLZPostfach)","v":""}]
["COPY",{"$nulls":3},"ZUntOrtPostfach",{"$f":"IF(UntOrtPostfach=\"\",\"\",UntOrtPostfach)","v":""}]
["COPY",{"$nulls":3},"ZUntPostfach",{"$f":"IF(UntPostfach=\"\",\"\",UntPostfach)","v":""}]
["COPY",{"$nulls":3},"ZUntGlStrasse",{"$f":"IF(UntGlStrasse=\"\",\"\",IF(UntGlStrasse=UntStrasse,\"\",UntGlStrasse))","v":""}]
["COPY",{"$nulls":3},"ZUntGlPLZ",{"$f":"IF(UntGlPlz=\"\",\"\",IF(UntGlPlz=UntPLZStrasse,\"\",UntGlPlz))","v":""}]
["COPY",{"$nulls":3},"ZUntGlOrt",{"$f":"IF(UntGlOrt=\"\",\"\",IF(UntGlPlz=UntOrtStrasse,\"\",UntGlOrt))","v":""}]
["COPY",{"$nulls":3},"ZUntTelefon",{"$f":"IF(UntTelefon=\"\",\"\",UntTelefon)","v":""}]
["COPY",{"$nulls":3},"ZUntEmail",{"$f":"IF(UntEmail=\"\",\"\",UntEmail)","v":""}]
["COPY",{"$nulls":3},"ZUntInternet",{"$f":"IF(ISNA(HLOOKUP(\"3\",H107:Q108,2,FALSE)),\"\",HLOOKUP(\"3\",H107:Q108,2,FALSE))","v":""}]
["COPY",{"$nulls":3},"ZBsBezeichnung1",{"$f":"IF(H109=\"\",\"\",H109 )","v":""}]
["COPY",{"$nulls":3},"ZBsStrasse1",{"$f":"IF(H110=\"\",\"\",H110 )","v":""}]
["COPY",{"$nulls":3},"ZBsPLZ1",{"$f":"IF(H111=\"\",\"\",H111)","v":""}]
["COPY",{"$nulls":3},"ZBsOrt1",{"$f":"IF(H112=\"\",\"\",H112)","v":""}]
["COPY",{"$nulls":3},"ZBsTelefon1",{"$f":"IF(H113=\"\",\"\",H113)","v":""}]
["COPY",{"$nulls":3},"ZBsbezeichnung2",{"$f":"IF(I109=\"\",\"\",I109 )","v":""}]
["COPY",{"$nulls":3},"ZBsStrasse2",{"$f":"IF(I110=\"\",\"\",I110)","v":""}]
["COPY",{"$nulls":3},"ZBsPLZ2",{"$f":"IF(I111=\"\",\"\",I111)","v":""}]
["COPY",{"$nulls":3},"ZBsOrt2",{"$f":"IF(I112=\"\",\"\",I112)","v":""}]
["COPY",{"$nulls":3},"ZBsTelefon2",{"$f":"IF(I113=\"\",\"\",I113)","v":""}]
["COPY",{"$nulls":3},"ein_rx_5_1",{"$f":"\"\"","v":""}]
["COPY",{"$nulls":3},"ein_rx_5_2",{"$f":"IF(AND(F190=\"\",F195=\"\"),\"\",\"X\")","v":""}]
["COPY",{"$nulls":3},"ein_rx_7_1",{"$f":"IF(UntRegister=\"HAN\",\"X\",\"\")","v":""}]
["COPY",{"$nulls":3},"ein_rx_7_2",{"$f":"\"\"","v":""}]
["COPY",{"$nulls":3},"ZRegisterEintragDatum",{"$f":"IF(UntRegister=\"HAN\",Datumkonvert(UntRegisterDatum),\"\")","v":""}]
["COPY",{"$nulls":3},"ZRegisterOrt",{"$f":"IF(UntRegister=\"HAN\",IF(UntRegisterGericht=\"\",\"\",UntRegisterGericht),\"\")","v":""}]
["COPY",{"$nulls":3},"ZRegisterNummer",{"$f":"IF(UntRegister=\"HAN\",IF(UntRegisterNummer=\"\",\"\",UntRegisterNummer),\"\")","v":""}]
["COPY",{"$nulls":3},"ZWjBeginn",{"$f":"IF(AND(H118,I118,J118,K118),MID(UntWj,1,2) & \".\" & MID(UntWj,3,2) & \".\" & IF(L118,YEAR(NOW()),YEAR(NOW())-1),\"\")","v":""}]
["COPY",{"$nulls":3},"ein_rx_12_1",{"$f":"\"\"","v":""}]
["COPY",{"$nulls":3},"ein_rx_12_2",{"$f":"IF(F207=\"\",\"\",\"X\")","v":""}]
["COPY",{"$nulls":3},"ZBsName",{"$f":"IF(BsBezeichnung=\"\",\"\",BsBezeichnung)","v":""}]
["COPY",{"$nulls":3},"ZBsStrasse",{"$f":"IF(BsStrasse=\"\",\"\",BsStrasse)","v":""}]
["COPY",{"$nulls":3},"ZBsPLZ",{"$f":"IF(BsPLZ=\"\",\"\",BsPLZ)","v":""}]
["COPY",{"$nulls":3},"ZBsOrt",{"$f":"IF(BsOrt=\"\",\"\",BsOrt)","v":""}]
["COPY",{"$nulls":3},"ein_x_12",{"$f":"IF(USt_IdNr=\"\",\"\",\"X\")","v":""}]
["COPY",{"$nulls":3},"ZUSt_IdNr",{"$f":"IF(USt_IdNr=\"\",\"\",USt_IdNr)","v":""}]
["COPY",{"$nulls":3},"ZOrtDatum",{"$f":"IF(AND(PersOrtStrasse=\"\",UntOrtStrasse=\"\"),TEXT(TODAY(),\"TT.MM.JJJJ\"),IF(UntOrtStrasse=\"\",PersOrtStrasse,UntOrtStrasse) & \", \" & TEXT(TODAY(),\"TT.MM.JJJJ\"))","v":"23.03.2017"}]
["COPY",{"$nulls":3},"ZFaName",{"$f":"IF(AND(FAPerson=\"\",FABetrieb=\"\"),\"\",IF(FABetrieb=\"\",IF(FaPersName=\"\",\"\",FaPersName),IF(FaUntName=\"\",\"\",FaUntName)))","v":""}]
["COPY",{"$nulls":3},"ZFaPostfachStrasse",{"$f":"IF(AND(FAPerson=\"\",FABetrieb=\"\"),\"\",IF(FABetrieb=\"\",IF(AND(FaPersStrasse=\"\",FaPersPostfach=\"\"),\"\",IF(FaPersPostfach=\"\",FaPersStrasse,\"Postfach \" & FaPersPostfach)),IF(AND(FaUntStrasse=\"\",FaUntPostfach=\"\"),\"\",IF(FaUntPostfach=\"\",FaUntStrasse,\"Postfach \" & FaUntPostfach))))","v":""}]
["COPY",{"$nulls":3},"ZFaPLZOrt",{"$f":"IF(AND(FAPerson=\"\",FABetrieb=\"\"),\"\",IF(FABetrieb=\"\",IF(FaPersPostfach=\"\",IF(FaPersPLZStrasse=\"\",\"\",FaPersPLZStrasse&\" \")&IF(FaPersOrtStrasse=\"\",\"\",FaPersOrtStrasse),IF(FaPersPLZPostfach=\"\",\"\",FaPersPLZPostfach&\" \")&IF(FaPersOrtPostfach=\"\",\"\",FaPersOrtPostfach)),IF(FaUntPLZStrasse=\"\",\"\",FaUntPLZStrasse&\" \")&IF(FaUntOrtStrasse=\"\",\"\",FaUntOrtStrasse)))","v":""}]

{"sheet":"Kanzleidaten","index":11,"n_rows":41,"n_cols":3,"rows_kept":41,"hidden":true}
["Aktion","Quelle / Ziel","Wert"]
["KANZLEI","KDBezeichnung1"]
["KANZLEI","KDBezeichnung2"]
["KANZLEI","KDStrasse_alt"]
["KANZLEI","KDStrasse"]
["KANZLEI","KDAdresszusatz"]
["KANZLEI","KDHausnummer"]
["KANZLEI","KDHausnummerZusatz"]
["KANZLEI","KDPLZ"]
["KANZLEI","KDOrt"]
["KANZLEI","KDTel"]
["KANZLEI","KDFax"]
["KANZLEI","KDMobil"]
["KANZLEI","KDEmail"]
["KANZLEI","KDInternet"]
["CopyStB","ZStBName",{"$f":"IF(KDBezeichnung1=\"\",\"\",KDBezeichnung1 & \" \")&IF(KDBezeichnung2=\"\",\"\",KDBezeichnung2)","v":""}]
["CopyStB","ZStBStrasse",{"$f":"IF(KDStrasse=\"\",IF(KDStrasse_alt=\"\",\"\",KDStrasse_alt),KDStrasse)","v":""}]
["CopyStB","ZStBHausnummer",{"$f":"IF(KDHausnummer=\"\",\"\",KDHausnummer)","v":""}]
["CopyStB","ZStBHausnummerZusatz",{"$f":"IF(KDHausnummerZusatz=\"\",\"\",KDHausnummerZusatz)","v":""}]
["CopyStB","ZStBAdressergaenzung",{"$f":"IF(KDAdresszusatz=\"\",\"\",KDAdresszusatz)","v":""}]
["CopyStB","ZStBPLZ",{"$f":"IF(KDPLZ=\"\",\"\",KDPLZ)","v":""}]
["CopyStB","ZStBOrt",{"$f":"IF(KDOrt=\"\",\"\",KDOrt)","v":""}]
["CopyStB","ZStBTel",{"$f":"IF(KDTel=\"\",IF(KDMobil=\"\",\"\",KDMobil),KDTel)","v":""}]
["CopyStB","ZStBEmail",{"$f":"IF(KDEmail=\"\",\"\",KDEmail)","v":""}]
["CopyEmpf","ZEmpfBezeichnung",{"$f":"IF(KDBezeichnung1=\"\",\"\",KDBezeichnung1 & \" \")&IF(KDBezeichnung2=\"\",\"\",KDBezeichnung2)","v":""}]
["CopyEmpf","ZEmpfStrasse",{"$f":"IF(KDStrasse=\"\",IF(KDStrasse_alt=\"\",\"\",KDStrasse_alt),KDStrasse)","v":""}]
["CopyEmpf","ZEmpfHausnummer",{"$f":"IF(KDHausnummer=\"\",\"\",KDHausnummer)","v":""}]
["CopyEmpf","ZEmpfHausnummerZusatz",{"$f":"IF(KDHausnummerZusatz=\"\",\"\",KDHausnummerZusatz)","v":""}]
["CopyEmpf","ZEmpfAdressergaenzung",{"$f":"IF(KDAdresszusatz=\"\",\"\",KDAdresszusatz)","v":""}]
["CopyEmpf","ZEmpfPLZStrasse",{"$f":"IF(KDPLZ=\"\",\"\",KDPLZ)","v":""}]
["CopyEmpf","ZEmpfOrtStrasse",{"$f":"IF(KDOrt=\"\",\"\",KDOrt)","v":""}]
["CopyEmpf","ZEmpfTelefon",{"$f":"IF(KDTel=\"\",IF(KDMobil=\"\",\"\",KDMobil),KDTel)","v":""}]
["CopyEmpf","ZEmpfEMail",{"$f":"IF(KDEmail=\"\",\"\",KDEmail)","v":""}]
[null,null,""]
[null,null,""]
[]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"Stammdaten","index":12,"n_rows":8,"n_cols":2,"rows_kept":8,"hidden":true}
["Stammdaten"]
["ToolName","Neuanlage eines Mandats"]
["ToolVersion","V.4.2"]
["ToolDatum","(14.12.2016)"]
["ToolInfo",{"$f":"ToolName & \" \" & ToolVersion & \" \" & ToolDatum","v":"Neuanlage eines Mandats V.4.2 (14.12.2016)"}]
["Eingabekontrolle",true]
["Header",{"$f":"IF(ZPersName=\"\",\"\",ZPersName) & IF(OR(ZPersName=\"\",ZFaSteuernummer=\"\"),\"\",\" / \") & IF(ZFaSteuernummer=\"\",\"\",ZFaSteuernummer)","v":""}]
["FirstRun","23.03.2017"]