{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Allgemeines","Anleitung","A-Vermögenswerte","B-Einkünfte","C-Ausgaben","D-Fahrhabe","Ergänzende Angaben","Zusammenzug","XAdmin"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":189,"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":"Allgemeines","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,2],[0,0,0,3],[12,0,12,1],[16,0,16,1]]}
["Inventar der zu verwaltenden Vermögenswerte (IvV)\ngemäss Art. 405 Abs. 2 ZGB"]
[]
[]
["Name:"]
["Vorname:"]
["Geburtsdatum:"]
["Heimatort:"]
[]
[]
[]
[]
[]
["Entscheid vom:"]
[]
[]
[]
["Inventarstichtag:"]
[]
[]
[]
["Aufnahmedatum:"]
[]
[]
[]
["Beistandsperson:","Name:"]
[]
[null,"Vorname:"]
[]
[null,"Mandat:"]
[]
[]
[]
[]
[]
[]
[]
["Das Inventar über die zu verwaltenden Vermögenswerte bildet die Grundlage für die Rechnungsführung und Vermögensverwaltung durch die Mandatsperson. Das Inventar enthält die zu verwaltenden Aktiven, Passiven und regelmässigen Einkünfte."]

{"sheet":"Anleitung","index":1,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Anleitung zum Ausfüllen der einzelnen Register"]
[]
["Register \"Allgemeines\""]
["Über den Button \"Persönlich Daten der verbeiständeten Person bearbeiten\" sind die Angaben der verbeiständeten Person zu pflegen. "]
["Sie verlassen das Feld über den Button \"OK\"."]
[]
["Die farbigen Felder sind auszufüllen."]
[]
["Mit dem Button \"Formular Prüfen\" wird angezeigt, wo vergessen wurde einen Eintrag zu machen."]
["Mit dem Button \"Druck Ansicht\" wird jedes Register in der Seitenansicht angezeigt. Über Seitenansicht schliessen "]
["wechselt man zum nächsten Register."]
["Hat ein Register mehrere Seiten kann man innerhalb des Registers auch mit ",null,null,null,null,null,null,"zwischen den Seiten wechseln."]
["Mit dem Button \"Formular drucken\" kann man, wenn alles feritg ist, das Formular ausdrucken und unterschreiben bzw. unterschreiben lassen."]
[]
["Register \"A-Vermögenswerte\""]
["Nur die farbigen Felder können ausgefüllt werden. "]
["In den Spalten \"Beleg\" und \"Pendenz\" sind die Kästlein solange farbig, solange die Positition nicht bearbeitet wurde."]
["Ist die einzelne Position nicht relevant, ist das Feld \"Keine\" anzuklicken."]
["Jede Position kann über den Button \"Zeile einfügen\" erweitert werden"]
["Hat man aus versehen zu viele Zeilen eingefügt, kann das über \"Zeile entfernen\" wieder korrigiert werden."]
["Pro Position bleibt mind. eine Zeile bestehen. Wenn es keinen Eintrag gibt, bleibt die Zeile leer, wenn die Felder in den Spalten \"Beleg\" und \"Pendenz\" "]
["nicht mehr farbig sind, ist das ok."]
["Für jede Position, die ausgefüllt wird, ist auch ein Beleg beizulegen. "]
["Bitte geben Sie diesem Beleg eine Nummer. Ist das nicht möglich so bleibt es eine Pendenz. Klick auf die Spalte \"Pendenz\" und Beleg wird weiss."]
[]
["Register \"Zusammenzug\""]
["Hier müssen Sie sich nur dazu äussern, wieso die verbeiständete Person das Inventar nicht mitunterzeichnet hat."]
["Zudem haben Sie ganz unten ein Freitextfeld für Anmerkungen zur Verfügung."]
["Der Rest des Formulars wird automatisch ausgefüllt."]
["Wichtig:"]
["Hier das Inventarformular nach dem Ausdruck unterzeichnen."]
[]
["Register \"B-Einkünfte\""]
["Hier gilt das selbe wie im Register \"A-Vermögenswerte\""]
[]
["Register \"C-Ausgaben\""]
["Hier gilt das selbe wie im Register \"A-Vermögenswerte\""]
[]
["Register \"D-Fahrhabe\""]
["Dieses Register erscheint nur, wenn im Register \"A-Vermögenswerte\" bei Punkt 5 angeklickt wurde, dass es Fahrhabe von besonderem Wert gibt."]
["Bei Fahrhabe von besonderem Wert ist nicht nur der monetäre Wert gemeint."]
["Hier ist auch darauf zu achten, dass Sachen von sehr grossem emotionalem Wert aufgeführt werden."]
[]
["Register \"Ergänzende Angaben\""]
["Hier gilt das selbe wie im Register \"A-Vermögenswerte\""]
["Zudem haben Sie ganz unten ein Freitextfeld für Anmerkungen zur Verfügung."]

{"sheet":"A-Vermögenswerte","index":2,"n_rows":213,"n_cols":20,"rows_kept":213,"cut":false,"hidden":false,"merged":[[3,12,6,12],[3,14,6,14],[16,12,19,12],[16,14,19,14],[115,1,115,4],[114,1,114,4],[88,1,88,9],[87,1,87,9],[100,1,100,9],[99,1,99,9],[78,1,78,9],[77,1,77,9],[72,1,72,6],[72,7,72,9],[67,1,67,9],[71,1,71,9],[62,1,62,6],[62,7,62,9],[103,7,103,9],[58,7,58,9],[91,1,91,9],[92,1,92,9],[212,1,212,6],[212,7,212,9],[205,1,205,4],[211,1,211,4],[197,7,197,9],[198,1,198,6],[198,7,198,9],[206,1,206,4],[197,1,197,4],[207,1,207,4],[210,1,210,4],[210,5,210,9],[211,5,211,9],[208,1,208,4],[208,5,208,9],[209,1,209,4],[209,5,209,9],[176,8,176,9],[148,1,148,6],[148,7,148,9],[146,7,146,9],[207,5,207,9],[206,5,206,9],[169,1,169,6],[169,7,169,9],[170,1,170,6],[81,1,81,6],[69,1,69,9],[68,1,68,9],[81,7,81,9],[76,1,76,9],[79,1,79,9],[70,1,70,9],[174,8,174,9],[176,6,176,7],[86,1,86,9],[93,1,93,9],[94,1,94,6],[94,7,94,9],[141,1,141,6],[61,1,61,6],[61,7,61,9],[175,8,175,9],[185,7,185,9],[188,7,188,9],[179,7,179,9],[128,1,128,5],[131,1,131,5],[175,1,175,5],[178,1,178,5],[166,1,166,6],[166,7,166,9],[176,1,176,5],[141,7,141,9],[159,7,159,9],[160,1,160,6],[160,7,160,9],[164,1,164,6],[164,7,164,9],[150,1,150,6],[150,7,150,9],[151,1,151,6],[151,7,151,9],[155,1,155,6],[36,7,36,9],[29,1,29,5],[29,6,29,9],[35,1,35,5],[35,6,35,9],[41,1,41,5],[41,6,41,9],[196,1,196,4],[196,7,196,9],[165,1,165,6],[165,7,165,9],[155,7,155,9],[170,7,170,9],[174,1,174,4],[157,1,157,6],[157,7,157,9],[159,1,159,6],[178,6,178,7],[178,8,178,9],[186,1,186,6],[186,7,186,9],[156,1,156,6],[156,7,156,9],[188,1,188,6],[46,7,46,9],[6,1,6,5],[6,6,6,9],[8,1,8,5],[8,6,8,9],[19,1,19,5],[19,6,19,9],[21,1,21,5],[21,6,21,9],[7,1,7,5],[7,6,7,9],[14,1,14,5],[14,6,14,9],[20,1,20,5],[20,6,20,9],[28,1,28,5],[28,6,28,9],[30,1,30,5],[30,6,30,9],[40,1,40,5],[40,6,40,9],[42,1,42,5],[42,6,42,9],[36,1,36,6],[65,14,67,14],[15,1,15,6],[15,7,15,9],[26,12,28,12],[26,14,28,14],[38,12,40,12],[38,14,40,14],[56,12,58,12],[56,14,58,14],[48,12,50,12],[48,14,50,14],[54,1,54,6],[54,7,54,9],[63,1,63,6],[63,7,63,9],[24,1,24,6],[24,7,24,9],[46,1,46,6],[23,1,23,5],[23,6,23,9],[60,1,60,6],[60,7,60,9],[58,1,58,6],[45,1,45,5],[65,12,67,12],[113,1,113,4],[117,1,117,4],[102,1,102,9],[103,1,103,6],[109,1,109,10],[196,5,196,6],[205,5,205,9],[197,5,197,6],[194,5,194,6],[195,1,195,4],[195,7,195,9],[194,7,194,9],[189,1,189,6],[189,7,189,9],[179,1,179,6],[174,6,174,7],[118,1,118,6],[118,7,118,9],[187,1,187,6],[187,7,187,9],[185,1,185,6],[194,1,194,4],[175,6,175,7],[50,1,50,5],[50,6,50,9],[52,1,52,5],[52,6,52,9],[113,5,113,9],[115,5,115,9],[132,7,132,9],[127,6,127,9],[140,1,140,4],[119,1,119,4],[129,6,129,9],[51,1,51,5],[51,6,51,9],[53,1,53,5],[53,6,53,9],[114,5,114,9],[117,5,117,9],[137,5,137,9],[140,5,140,9],[59,1,59,6],[59,7,59,9],[80,1,80,9],[83,1,83,10],[98,1,98,9],[9,1,9,5],[9,6,9,9],[10,1,10,5],[10,6,10,9],[167,1,167,6],[167,7,167,9],[168,1,168,6],[168,7,168,9],[177,1,177,5],[177,6,177,7],[177,8,177,9],[158,1,158,6],[158,7,158,9],[149,1,149,6],[149,7,149,9],[139,1,139,4],[139,5,139,9],[130,1,130,5],[130,6,130,9],[116,1,116,4],[116,5,116,9],[101,1,101,9],[89,1,89,9],[90,1,90,9],[43,1,43,5],[43,6,43,9],[31,1,31,5],[31,6,31,9],[22,1,22,5],[22,6,22,9],[44,1,44,5],[44,6,44,9],[195,5,195,6],[128,6,128,9],[136,1,136,4],[138,1,138,4],[137,1,137,4],[147,1,147,6],[147,7,147,9],[127,1,127,5],[129,1,129,5],[136,5,136,9],[45,6,45,9],[138,5,138,9],[119,6,119,10],[131,6,131,9],[132,1,132,6],[146,1,146,6],[11,1,11,5],[11,6,11,9],[12,1,12,5],[12,6,12,9],[32,1,32,5],[32,6,32,9],[33,1,33,5],[33,6,33,9],[34,1,34,5],[34,6,34,9],[13,1,13,5],[13,6,13,9]]}
[null,"A."," Vermögenswerte",null,null,null,null,null,null,null,null,null,"Beleg",null,"Pendenz"]
[null,"I.","Aktiven"]
[null,"1.","Bankguthaben und Wertschriften"]
[null,"a1.","Bankguthaben"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"ABankA1Daten"]
[]
[null,"Kontobezeichnung / Bank",null,null,null,null,"Konto-Nummer",null,null,null,"Saldo"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q8),IF(OR(M8<>\"\",O8<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$5=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,true,false]
[null,null,null,null,null,null,null,"Total"]
[null,"a2.","Bankguthaben in Eigenverwaltung Klient/Klientin"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"ABankA2Daten"]
[]
[null,"Kontobezeichnung / Bank",null,null,null,null,"Konto-Nummer",null,null,null,"Saldo"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q21),IF(OR(M21<>\"\",O21<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$18=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q22),IF(OR(M22<>\"\",O22<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$18=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q23),IF(OR(M23<>\"\",O23<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$18=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q24),IF(OR(M24<>\"\",O24<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$18=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total p.m."]
[null,"b.","Wertschriften im Depot"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AWertschriftenB1Daten"]
[]
[null,"Depotbezeichnung/Bank",null,null,null,null,"Depot-Nr.",null,null,null,"Total Depot"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q30),IF(OR(M30<>\"\",O30<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$27=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"IF($B$27=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,true,false]
[null,null,null,null,null,null,null,"Total"]
[null,"c1.","Freizügigkeitskonten, Sparen 3, Lebensversicherung nach 3a in Verwaltung Beistand"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AFreizuegigkeitC1Daten"]
[]
[null,"Bezeichnung/Bank/Versicherung",null,null,null,null,"Konto-/Policen-Nummer",null,null,null,"Wert Guthaben Inventarstichtag"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q42),IF(OR(M42<>\"\",O42<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$39=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q43),IF(OR(M43<>\"\",O43<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$39=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q44),IF(OR(M44<>\"\",O44<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q45),IF(OR(M45<>\"\",O45<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q46),IF(OR(M46<>\"\",O46<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"c2.","Freizügigkeitskonten, Sparen 3, Lebensversicherung nach 3a pro memoria"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AFreizuegigkeitC2Daten"]
[]
[null,"Bezeichnung/Bank/Versicherung",null,null,null,null,"Konto-/Policen-Nummer",null,null,null,"Wert Guthaben Inventarstichtag"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q52),IF(OR(M52<>\"\",O52<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$49=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q53),IF(OR(M53<>\"\",O53<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$49=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q54),IF(OR(M54<>\"\",O54<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total p.m."]
[null,"d.","Weitere Wertschriften und Anteilscheine"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AWertschriftenD1Daten"]
[]
[null,"Bezeichnung/Valor",null,null,null,null,null,"Valuta",null,null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q60),IF(OR(M60<>\"\",O60<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$57=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q61),IF(OR(M61<>\"\",O61<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$57=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q62),IF(OR(M62<>\"\",O62<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q63),IF(OR(M63<>\"\",O63<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"e.","Mieterkaution/Heimdepot"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AMieterkautionE1Daten"]
[]
[null,"Wohnung/Heim",null,null,null,null,null,null,null,null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q69),IF(OR(M69<>\"\",O69<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$66=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q70),IF(OR(M70<>\"\",O70<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$66=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q71),IF(OR(M71<>\"\",O71<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q72),IF(OR(M72<>\"\",O72<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"2.","Liegenschaften (Grundeigentum/Baurecht)"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"ALiegenschaftenDaten"]
[]
[null,"Bezeichnung und Kataster-Nr.",null,null,null,null,null,null,null,null,"Wählen Sie aus"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q78),IF(OR(M78<>\"\",O78<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$75=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q79),IF(OR(M79<>\"\",O79<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$75=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q80),IF(OR(M80<>\"\",O80<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q81),IF(OR(M81<>\"\",O81<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"3.","Weitere Guthaben"]
[null,"(ausstehende Nachlassansprüche, Darlehen, fällige Forderungen, Lohnguthaben, \nausstehende Versicherungsleistungen, Genugtuungsansprüche etc.)"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AWeitereGuthabenDaten"]
[]
[null,"Bezeichnung",null,null,null,null,null,null,null,null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q88),IF(OR(M88<>\"\",O88<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$85=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"IF($B$85=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,true,false]
[null,null,null,null,null,null,null,"Total"]
[null,"4.","Barschaft"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"ABarschaftDaten"]
[]
[null,"Der Mandatsperson zur Verwaltung übergebenes Bargeld",null,null,null,null,null,null,null,null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q100),IF(OR(M100<>\"\",O100<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$97=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q101),IF(OR(M101<>\"\",O101<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$97=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q102),IF(OR(M102<>\"\",O102<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q103),IF(OR(M103<>\"\",O103<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"5.","Zu verwaltende Fahrhabe"]
[null,null,"Es ist keine Fahrhabe von besonderem Wert vorhanden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,"DFahrhabeDaten"]
[]
[null,null,"Es bestehen Möbel/Gegenstände von besonderem Wert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2]
[]
[null,"Listen Sie die zu verwaltende Fahrhabe bitte im Tabellenblatt \"D-Fahrhabe\" auf"]
[null,"6.","Schrankfächer"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"ASchrankfaecherDaten"]
[]
[null,"Bank/Schrankfach-Nr.",null,null,null,"Gegenstand/Inhalt",null,null,null,null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q115),IF(OR(M115<>\"\",O115<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$112=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q116),IF(OR(M116<>\"\",O116<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$112=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q117),IF(OR(M117<>\"\",O117<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q118),IF(OR(M118<>\"\",O118<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total p.m."]
[null,"Aufbewahrungsort Schlüssel:"]
[null,"7.","Geschäftsvermögen"]
[null,null,"Keines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,3,"AGeschaeftsvermoegenDaten"]
[]
[null,null,"Geschäftsvermögen wird nicht durch Mandatsperson verwaltet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3]
[]
[null,null,"Geschäftsvermögen wird durch Mandatsperson verwaltet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3]
[]
[null,"Firma",null,null,null,null,"Rechtsform",null,null,null,"Wert der Beteiligung"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q129),IF(OR(M129<>\"\",O129<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$122=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q130),IF(OR(M130<>\"\",O130<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$122=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q131),IF(OR(M131<>\"\",O131<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$122=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q132),IF(OR(M132<>\"\",O132<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$122=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,{"$f":"IF(B124=\"X\",\"Total p.m.\", \"Total\")","v":"Total"}]
[null,"8.","Versicherungen mit Rückkaufswert nach 3b"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AVersicherungenDaten"]
[]
[null,"Versicherungsgesellschaft/Agentur",null,null,null,"Policen-Nr.",null,null,null,null,"Rückkaufswert"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q138),IF(OR(M138<>\"\",O138<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$135=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q139),IF(OR(M139<>\"\",O139<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$135=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q140),IF(OR(M140<>\"\",O140<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q141),IF(OR(M141<>\"\",O141<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"II.","Passiven"]
[null,"1.","Hypotheken"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AHypothekenDaten"]
[]
[null,"Bank",null,null,null,null,null,"Laufzeit",null,null,"Höhe der Hypothek"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q148),IF(OR(M148<>\"\",O148<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$145=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q149),IF(OR(M149<>\"\",O149<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$145=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q150),IF(OR(M150<>\"\",O150<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q151),IF(OR(M151<>\"\",O151<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"2.","Kredite"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AKrediteDaten"]
[]
[null,"Bank/Kreditinstitut",null,null,null,null,null,"Laufzeit",null,null,"Kredithöhe"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q157),IF(OR(M157<>\"\",O157<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$154=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q158),IF(OR(M158<>\"\",O158<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$154=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q159),IF(OR(M159<>\"\",O159<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q160),IF(OR(M160<>\"\",O160<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"3.","Darlehen"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"ADarlehenDaten"]
[]
[null,"Name, Vorname darlehensgebende Person",null,null,null,null,null,"Laufzeit",null,null,"Höhe des Darlehen"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q166),IF(OR(M166<>\"\",O166<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$163=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q167),IF(OR(M167<>\"\",O167<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$163=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q168),IF(OR(M168<>\"\",O168<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q169),IF(OR(M169<>\"\",O169<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q170),IF(OR(M170<>\"\",O170<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"4.","Geschuldete Unterhaltsbeiträge"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AUnterhaltsbeitraegeDaten"]
[]
[null,"Name, Vorname Empfänger/in",null,null,null,null,"monatliche Summe",null,"befristet bis",null,"Ausstände"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q176),IF(OR(M176<>\"\",O176<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$173=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q177),IF(OR(M177<>\"\",O177<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$173=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q178),IF(OR(M178<>\"\",O178<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q179),IF(OR(M179<>\"\",O179<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"5.","Schulden"]
[null,"a.","offene Betreibungen"]
[]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"ABetreibungenDaten"]
[]
[null,"Name Betreibungsamt",null,null,null,null,null,"Datum Auszug aus\nBetreibungsregister ",null,null,"Schuld total"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q187),IF(OR(M187<>\"\",O187<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$184=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q188),IF(OR(M188<>\"\",O188<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$184=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q189),IF(OR(M189<>\"\",O189<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null," Total p.m."]
[null,"b.","Verlustscheine"]
[]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"AVerlustscheineDaten"]
[]
[null,"Name Betreibungsamt",null,null,null,"Anzahl Ver-\nlustscheine",null,"Datum Auszug aus\nBetreibungsregister ",null,null,"Erinnerungswert"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q196),IF(OR(M196<>\"\",O196<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$193=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(Q197),IF(OR(M197<>\"\",O197<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$193=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q198),IF(OR(M198<>\"\",O198<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total p.m."]
[null,"6.","Diverses, Spezielles"]
[null,null,"z.B. Leasing, Kreditkarte,offene Rechnungen (wenn sie mehr als 20% "]
[null,null,"der liquiden Mittel ausmachen) etc."]
[]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,"ADiversesDaten"]
[]
[null,"Art",null,null,null,"Gläubiger",null,null,null,null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q207),IF(OR(M207<>\"\",O207<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$204=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"IF($B$204=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,false]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,true,false]
[null,null,null,null,null,null,null,"Total p.m."]

{"sheet":"B-Einkünfte","index":3,"n_rows":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":false,"merged":[[2,12,5,12],[99,1,99,4],[99,5,99,6],[95,1,95,4],[95,5,95,6],[90,1,90,7],[5,1,5,5],[10,1,10,5],[11,1,11,7],[2,10,5,10],[85,1,85,7],[50,1,50,7],[54,1,54,7],[59,1,59,7],[81,1,81,7],[29,1,29,7],[5,6,5,7],[10,6,10,7],[6,1,6,5],[6,6,6,7],[7,1,7,5],[7,6,7,7],[8,1,8,5],[8,6,8,7],[9,1,9,5],[9,6,9,7],[16,1,16,7],[25,1,25,7],[41,1,41,7],[17,1,17,7],[55,1,55,7],[18,1,18,7],[33,1,33,7],[20,1,20,7],[28,1,28,7],[45,1,45,7],[21,1,21,7],[26,1,26,7],[27,1,27,7],[34,1,34,7],[35,1,35,7],[37,1,37,7],[100,1,100,7],[43,1,43,7],[97,1,97,4],[97,5,97,6],[86,1,86,7],[87,1,87,7],[91,1,91,7],[96,1,96,4],[96,5,96,6],[71,1,71,7],[72,1,72,7],[77,1,77,7],[76,1,76,7],[69,1,69,7],[63,1,63,7],[61,1,61,7],[78,1,78,7],[80,1,80,7],[70,1,70,7],[46,1,46,7],[19,1,19,7],[44,1,44,7],[53,1,53,7],[52,1,52,7],[51,1,51,7],[60,1,60,7],[62,1,62,7],[36,1,36,7],[68,1,68,7],[42,1,42,7],[64,1,64,7],[88,1,88,7],[89,1,89,7],[79,1,79,7],[98,1,98,4],[98,5,98,6],[82,2,82,7]]}
[null,"B.","Einkünfte",null,null,null,null,null,null,null,"Beleg",null,"Pendenz"]
[]
[null,"1.","Erwerbstätigkeit"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BErwerbDaten"]
[]
[null,"Arbeitgeber/in",null,null,null,null,"Beruf/Tätigkeit",null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O7),IF(OR(K7<>\"\",M7<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$4=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O8),IF(OR(K8<>\"\",M8<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$4=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O9),IF(OR(K9<>\"\",M9<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O10),IF(OR(K10<>\"\",M10<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O11),IF(OR(K11<>\"\",M11<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"2.","Sozialversicherungen"]
[null,"a. ","AHV-/IV-Rente"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BAHVDaten"]
[]
[null,"Ausgleichskasse Ort",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O18),IF(OR(K18<>\"\",M18<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$15=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O19),IF(OR(K19<>\"\",M19<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$15=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O20),IF(OR(K20<>\"\",M20<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O21),IF(OR(K21<>\"\",M21<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"b.","Hilflosenentschädigung"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BHilflosenDaten"]
[]
[null,"Ausgleichskasse Ort",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O27),IF(OR(K27<>\"\",M27<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$24=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O28),IF(OR(K28<>\"\",M28<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$24=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O29),IF(OR(K29<>\"\",M29<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"c.","Zusatzleistungen zur AHV/IV"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BAHVZusatzDaten"]
[]
[null,"Beschreibung",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O35),IF(OR(K35<>\"\",M35<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$32=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O36),IF(OR(K36<>\"\",M36<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$32=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O37),IF(OR(K37<>\"\",M37<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"d.","Pensionskassenrenten/weitere Sozialversicherungen"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BPKRenteDaten"]
[]
[null,"Ausgleichskasse Ort",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O43),IF(OR(K43<>\"\",M43<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$40=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O44),IF(OR(K44<>\"\",M44<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$40=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O45),IF(OR(K45<>\"\",M45<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O46),IF(OR(K46<>\"\",M46<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"e.","Private Rentenversicherungen"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BPrivateRentenDaten"]
[]
[null,"Rentenversicherung",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O52),IF(OR(K52<>\"\",M52<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$49=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O53),IF(OR(K53<>\"\",M53<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$49=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O54),IF(OR(K54<>\"\",M54<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O55),IF(OR(K55<>\"\",M55<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"f.","Rente (Unfallversicherung/Taggeldversicherung)"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BSUVADaten"]
[]
[null,"Beschreibung",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O61),IF(OR(K61<>\"\",M61<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$58=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O62),IF(OR(K62<>\"\",M62<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$58=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O63),IF(OR(K63<>\"\",M63<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O64),IF(OR(K64<>\"\",M64<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"3.","Wirtschaftliche Sozialhilfe Wohnsitzgemeinde"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BWirtschaftDaten"]
[]
[null,"Beschreibung (eventuell Leistungsbescheid beilegen)",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O70),IF(OR(K70<>\"\",M70<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$67=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O71),IF(OR(K71<>\"\",M71<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$67=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O72),IF(OR(K72<>\"\",M72<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"4.","Unterhaltsansprüche"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BUnterhaltDaten"]
[]
[null,"Unterhaltsschuldner/in",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O78),IF(OR(K78<>\"\",M78<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$75=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O79),IF(OR(K79<>\"\",M79<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$75=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O80),IF(OR(K80<>\"\",M80<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O81),IF(OR(K81<>\"\",M81<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"5.","Übrige Einkünfte (z.B. IPV*, Vermögenserträge, Mieterträge etc.)\n*Wenn keine ZL"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BUebrigeDaten"]
[]
[null,"Beschreibung",null,null,null,null,null,null,"CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O87),IF(OR(K87<>\"\",M87<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$84=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O88),IF(OR(K88<>\"\",M88<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$84=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O89),IF(OR(K89<>\"\",M89<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O90),IF(OR(K90<>\"\",M90<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O91),IF(OR(K91<>\"\",M91<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"6.","Nutzniessungsansprüche"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"BNutzniessungDaten"]
[]
[null,"Eigentümer",null,null,null,"Beschreibung (Früchte und Zinsen des Vermögens)",null,"Periode","Betrag/Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O97),IF(OR(K97<>\"\",M97<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$94=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O98),IF(OR(K98<>\"\",M98<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$94=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O99),IF(OR(K99<>\"\",M99<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O100),IF(OR(K100<>\"\",M100<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]

{"sheet":"C-Ausgaben","index":4,"n_rows":90,"n_cols":18,"rows_kept":90,"cut":false,"hidden":false,"merged":[[2,12,4,12],[59,1,59,5],[59,6,59,7],[38,1,38,7],[20,1,20,7],[34,1,34,5],[34,6,34,7],[40,1,40,5],[40,6,40,7],[35,1,35,5],[35,6,35,7],[36,1,36,5],[36,6,36,7],[50,1,50,5],[50,6,50,7],[49,1,49,5],[2,10,4,10],[42,1,42,5],[42,6,42,7],[19,6,19,7],[44,1,44,7],[18,1,18,5],[18,6,18,7],[19,1,19,5],[41,1,41,5],[41,6,41,7],[9,1,9,7],[4,1,4,5],[4,6,4,7],[5,1,5,5],[5,6,5,7],[8,1,8,5],[8,6,8,7],[6,1,6,5],[6,6,6,7],[51,6,51,7],[52,1,52,7],[16,1,16,5],[16,6,16,7],[17,1,17,5],[17,6,17,7],[49,6,49,7],[37,1,37,5],[37,6,37,7],[48,1,48,5],[48,6,48,7],[7,1,7,5],[7,6,7,7],[64,1,64,5],[43,1,43,5],[43,6,43,7],[75,1,75,5],[75,6,75,7],[68,1,68,5],[68,6,68,7],[56,1,56,5],[56,6,56,7],[57,1,57,5],[57,6,57,7],[58,1,58,5],[58,6,58,7],[60,1,60,7],[51,1,51,5],[67,1,67,5],[27,5,27,8],[27,1,27,4],[81,2,81,7],[82,2,82,7],[83,2,83,7],[28,1,28,7],[77,6,77,7],[78,1,78,7],[64,6,64,7],[65,1,65,5],[65,6,65,7],[66,1,66,5],[66,6,66,7],[69,1,69,7],[73,1,73,5],[73,6,73,7],[67,6,67,7],[76,1,76,5],[76,6,76,7],[89,2,89,7],[84,2,84,7],[88,2,88,7],[74,1,74,5],[74,6,74,7],[77,1,77,5]]}
[null,"C.","Ausgaben",null,null,null,null,null,null,null,"Beleg",null,"Pendenz"]
[]
[null,"1.","Versicherungen"]
[null,"a.","Kranken- und Unfallversicherungen"]
[null,"Krankenkasse / Agentur",null,null,null,null,"Versicherungs-Nr.",null,"Monatsprämie"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(K6<>\"\",M6<>\"\"),FALSE,TRUE)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K7<>\"\",M7<>\"\"),FALSE,TRUE)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K8<>\"\",M8<>\"\"),FALSE,TRUE)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K9<>\"\",M9<>\"\"),FALSE,TRUE)","v":true}]
[null,"Total"]
[null,"Separate Zusatzversicherung"]
[]
[null,null,"Nein",null,null,null,null,null,null,null,null,null,null,null,null,1,2,"CUnfallDaten"]
[]
[null,null,"Ja",null,false,"Nein",null,null,null,null,null,null,null,null,null,2,2]
[]
[null,"Versicherungsagentur",null,null,null,null,"Versicherungs-Nr.",null,"Monatsprämie"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O18),IF(OR(K18<>\"\",M18<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$13=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O19),IF(OR(K19<>\"\",M19<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$13=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O20),IF(OR(K20<>\"\",M20<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"Unfallversicherung Arbeitgeber"]
[]
[null,null,"Nein",null,null,null,null,null,null,null,null,null,null,null,null,1,2,"CUnfallArbeitgeber1XDaten"]
[]
[null,null,"Ja",null,false,"Nein",null,null,null,null,null,null,null,null,null,2,2]
[]
[null,"Arbeitgeber",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O28),IF(OR(K28<>\"\",M28<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$24=\"X\",TRUE,FALSE)","v":false}]
[]
[null,"b.","Nichterwerbstätigen-Beiträge"]
[null,null,"Nein",null,null,null,null,null,null,null,null,null,null,null,null,1,2,"CNichterwerbDaten"]
[]
[null,null,"Ja",null,false,"Nein",null,null,null,null,null,null,null,null,null,2,2]
[]
[null,"Ausgleichskasse",null,null,null,null,"Sozialversicheruns-Nr.",null,"Monatsprämie"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O36),IF(OR(K36<>\"\",M36<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$31=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O37),IF(OR(K37<>\"\",M37<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$31=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O38),IF(OR(K38<>\"\",M38<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"c.","Haftpflichtversicherungen"]
[null,"Versicherungsgesellschaft/Agentur",null,null,null,null,"Policen-Nr.",null,"Monatsprämie"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(K42<>\"\",M42<>\"\"),FALSE,TRUE)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K43<>\"\",M43<>\"\"),FALSE,TRUE)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K44<>\"\",M44<>\"\"),FALSE,TRUE)","v":true}]
[null,"Total"]
[null,"d.","Hausratversicherungen"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"CHausratDaten"]
[]
[null,"Versicherungsgesellschaft/Agentur",null,null,null,null,"Policen-Nr.",null,"Monatsprämie"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O50),IF(OR(K50<>\"\",M50<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$47=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O51),IF(OR(K51<>\"\",M51<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$47=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O52),IF(OR(K52<>\"\",M52<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"e.","Gebäudehaftpflichtversicherung"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"CGebaeudeDaten"]
[]
[null,"Versicherungsgesellschaft/Agentur",null,null,null,null,"Policen-Nr.",null,"Monatsprämie"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O58),IF(OR(K58<>\"\",M58<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$55=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O59),IF(OR(K59<>\"\",M59<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$55=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O60),IF(OR(K60<>\"\",M60<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"f.","Weitere Gebäudeversicherung"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"CWeitereGebaeudeDaten"]
[]
[null,"Versicherungsgesellschaft/Agentur",null,null,null,null,"Policen-Nr.",null,"Monatsprämie"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O66),IF(OR(K66<>\"\",M66<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$63=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O67),IF(OR(K67<>\"\",M67<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$63=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O68),IF(OR(K68<>\"\",M68<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O69),IF(OR(K69<>\"\",M69<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"g.","Weitere Versicherungen"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"CWeitereVersicherungenDaten"]
[]
[null,"Versicherungsgesellschaft/Agentur",null,null,null,null,"Policen-Nr.",null,"Monatsprämie"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O75),IF(OR(K75<>\"\",M75<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$72=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O76),IF(OR(K76<>\"\",M76<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$72=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O77),IF(OR(K77<>\"\",M77<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O78),IF(OR(K78<>\"\",M78<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,"Total"]
[null,"2.","Wohnkosten"]
[null,null,null,null,null,null,null,null,"CHF Pro Monat"]
[null,null,"Miete",null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B82=\"X\",IF(OR(K82<>\"\",M82<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B82=\"X\",FALSE,TRUE)","v":true},1,1,"CWohn21XDaten"]
[null,null,"Heimkosten",null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B83=\"X\",IF(OR(K83<>\"\",M83<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B83=\"X\",FALSE,TRUE)","v":true},1,1,"CWohn22XDaten"]
[null,null,"Hypozins",null,null,null,null,null,0,null,null,null,null,false,true,1,1,"CWohn23XDaten"]
[null,null,"Verwaltungskosten Wohneigentum",null,null,null,null,null,0,null,null,null,null,false,true,1,1,"CWohn24XDaten"]
[]
[null,"3.","Weitere Verpflichtungen"]
[null,null,null,null,null,null,null,null,"CHF Pro Monat"]
[null,null,"Familienrechtlicher Unterhalt",null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B89=\"X\",IF(OR(K89<>\"\",M89<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B89=\"X\",FALSE,TRUE)","v":true},1,1,"CWeitere31XDaten"]
[null,null,"Lohnverpflichtungen",null,null,null,null,null,0,null,null,null,null,false,{"$f":"IF($B90=\"X\",FALSE,TRUE)","v":true},1,1,"CWeitere32XDaten"]

{"sheet":"D-Fahrhabe","index":5,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,2,1],[30,3,31,10],[2,3,2,9],[32,3,33,10],[27,7,27,9],[3,3,3,9],[4,3,4,9],[26,3,26,9],[5,3,5,9],[6,3,6,9],[7,3,7,9],[8,3,8,9],[9,3,9,9],[10,3,10,9],[11,3,11,9],[12,3,12,9],[27,1,29,1],[13,3,13,9],[14,3,14,9],[15,3,15,9],[16,3,16,9],[17,3,17,9],[23,3,23,9],[24,3,24,9],[25,3,25,9],[18,3,18,9],[19,3,19,9],[20,3,20,9],[21,3,21,9],[22,3,22,9]]}
[null,"5.",null,"Zu verwaltende Fahrhabe"]
[null,"Beistand"]
[null,null,null,"zu verwaltende Wertgegenstände (Möbel, Bilder, Schmuck, Münzen, Fahrzeuge, Sammlungen, etc.)",null,null,null,null,null,null,"Schätzwert oder \np.m."]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$106=\"X\",TRUE,FALSE)","v":false},1,1]
[null,"Verwaltung",null,null,null,null,null,"Total p.m."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2]

{"sheet":"Ergänzende Angaben","index":6,"n_rows":73,"n_cols":18,"rows_kept":73,"cut":false,"hidden":false,"merged":[[36,1,36,2],[36,3,36,7],[37,3,37,7],[58,3,58,7],[46,1,46,2],[46,3,46,7],[37,1,37,2],[56,3,56,7],[49,3,49,7],[47,1,47,2],[47,3,47,7],[49,1,49,2],[48,1,48,2],[48,3,48,7],[38,1,38,2],[38,3,38,7],[6,1,6,3],[6,4,6,8],[35,1,35,2],[35,3,35,7],[28,1,28,3],[28,4,28,8],[27,1,27,3],[27,4,27,8],[29,1,29,3],[29,4,29,8],[18,2,18,7],[26,4,26,8],[26,1,26,3],[70,1,70,7],[65,1,65,7],[39,1,39,2],[39,3,39,7],[67,1,67,7],[66,1,66,7],[57,1,57,2],[57,3,57,7],[56,1,56,2],[55,1,55,2],[55,3,55,7],[51,1,51,3],[42,1,42,3],[58,1,58,2],[68,1,68,7],[69,1,69,7]]}
[null,"Ergänzende Angaben",null,null,null,null,null,null,null,null,"Beleg",null,"Pendenz"]
[null,"1.","Letztwillige Verfügungen / Erbverträge"]
[null,null,"Nein",null,null,null,null,null,null,null,null,null,null,null,null,1,2,"EVerfuegung11XDaten"]
[]
[null,null,"Ja",null,null,null,null,null,null,null,null,null,null,null,null,1,2,"EVerfuegung11XDaten"]
[null,false,"Ja"]
[null,"Aufbewahrungsort",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$3=\"X\",TRUE,FALSE)","v":false}]
[]
[null,"2.","Güterrechtliche Verhältnisse "]
[null,"a.","Zivilstand"]
[null,null,"Nicht verheiratet (ledig, geschieden, verwitwet)",null,null,null,null,null,null,null,null,null,null,null,null,1,3]
[]
[null,null,"Verheiratet / In eingetragener Partnerschaft",null,null,null,null,null,null,null,null,null,null,null,null,2,3]
[]
[null,"b.","Güterstand"]
[null,null,"Errungenschaftsbeteiligung",null,null,null,null,null,null,null,null,null,null,null,null,1,3]
[]
[null,null,"Gütergemeinschaft",null,null,null,null,null,null,null,null,null,null,null,null,2,3]
[null,false]
[null,null,"Gütertrennung",null,null,null,null,null,null,null,null,null,null,null,null,3,3]
[]
[null,"c.","Ehevertrag/Partnerschaftsvertrag:"]
[null,null,"Nein",null,null,null,null,null,null,null,null,null,null,null,null,1,2,"EEhevertrag2CDaten"]
[]
[null,null,"Ja",null,null,null,null,null,null,null,null,null,null,null,null,2,2]
[]
[null,"Datum",null,null,"Aufbewahrungsort"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$23=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$23=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$23=\"X\",TRUE,FALSE)","v":false}]
[null,"d.","Ausgerichtete Erbvorbezüge und Schenkungen"]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,2,"EVorbezugDaten"]
[]
[null,null,"Ja",null,null,null,null,null,null,null,null,null,null,null,null,2,2]
[]
[null,"Datum",null,"Empfänger",null,null,null,null,"Betrag in  CHF"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O37),IF(OR(K37<>\"\",M37<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$32=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O38),IF(OR(K38<>\"\",M38<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$32=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O39),IF(OR(K39<>\"\",M39<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O40),IF(OR(K40<>\"\",M40<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"e.","Eigengüter"]
[null,"Ehefrau / Partner 1"]
[]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"EEigengueter1Daten"]
[]
[null,"Datum",null,"Herkunft (eingebracht/Erblasser/Schenker)",null,null,null,null,"Betrag in  CHF"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O48),IF(OR(K48<>\"\",M48<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$45=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O49),IF(OR(K49<>\"\",M49<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$45=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O50),IF(OR(K50<>\"\",M50<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I48:I50)","v":0}]
[null,"Ehemann / Partner 2"]
[]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"EEigengueter2Daten"]
[]
[null,"Datum",null,"Herkunft (eingebracht/Erblasser/Schenker)",null,null,null,null,"Betrag in  CHF"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O57),IF(OR(K57<>\"\",M57<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$54=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O58),IF(OR(K58<>\"\",M58<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$54=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O59),IF(OR(K59<>\"\",M59<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I57:I59)","v":0}]
[null,"3.","Weitere vermögensrelevante Verpflichtungen"]
[null,"(z.B. Arbeitsverträge, Mietverträge etc.)"]
[]
[null,null,"Keine",null,null,null,null,null,null,null,null,null,null,null,null,1,1,"EWeitereVerpflichtungenDaten"]
[]
[null,"Art der Verpflichtung",null,null,null,null,null,null,"Betrag in  CHF"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O67),IF(OR(K67<>\"\",M67<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$64=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O68),IF(OR(K68<>\"\",M68<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$64=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O69),IF(OR(K69<>\"\",M69<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O70),IF(OR(K70<>\"\",M70<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(O71),IF(OR(K71<>\"\",M71<>\"\"),FALSE,TRUE),FALSE)","v":true},false]
[null,null,null,null,null,null,null,"Total"]
[null,"4.","Kommentar zu den Positionen mit Pendenzen:"]

{"sheet":"Zusammenzug","index":7,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Zusammenzug der Vermögenswerte"]
[]
[null,"I.","Aktiven"]
[null,"1.","Bankguthaben und Wertschriften"]
[null,null,"a.","Bankguthaben",null,null,null,{"$f":"'A-Vermögenswerte'!K16","v":0}]
[null,null,"b.","Wertschriften in Depot",null,null,null,{"$f":"'A-Vermögenswerte'!K37","v":0}]
[null,null,"c.","Freizügigkeitskonten und Sparen 3",null,null,null,{"$f":"'A-Vermögenswerte'!K47","v":0}]
[null,null,"d.","Weitere Wertschriften und Anteilscheine",null,null,null,{"$f":"'A-Vermögenswerte'!K64","v":0}]
[null,null,"e.","Mieterkaution/Heimdepot",null,null,null,{"$f":"'A-Vermögenswerte'!K73","v":0}]
[null,"2.","Liegenschaften",null,null,null,null,{"$f":"'A-Vermögenswerte'!K81","v":0}]
[null,"3.","Weitere Guthaben",null,null,null,null,{"$f":"'A-Vermögenswerte'!K95","v":0}]
[null,"4.","Barschaft",null,null,null,null,{"$f":"'A-Vermögenswerte'!K104","v":0}]
[null,"7.","Geschäftsvermögen",null,null,null,null,{"$f":"IF('A-Vermögenswerte'!B124,\"p.m.\",'A-Vermögenswerte'!K133)","v":0}]
[null,"8.","Versicherungen mit Rückkaufswert",null,null,null,null,{"$f":"'A-Vermögenswerte'!K142","v":0}]
[null,null,null,null,null,null,"Total Aktiven",{"$f":"SUM(H5:H14)","v":0}]
[]
[null,"II.","Passiven"]
[null,"1.","Hypotheken",null,null,null,null,{"$f":"'A-Vermögenswerte'!K152","v":0}]
[null,"2.","Kredite",null,null,null,null,{"$f":"'A-Vermögenswerte'!K161","v":0}]
[null,"3.","Darlehen",null,null,null,null,{"$f":"'A-Vermögenswerte'!K171","v":0}]
[null,"4.","Geschuldete Unterhaltsbeiträge",null,null,null,null,{"$f":"'A-Vermögenswerte'!K180","v":0}]
[null,null,null,null,null,null,"Total Passiven",{"$f":"SUM(H18:H21)","v":0}]
[null,null,null,null,null,null,"Gesamttotal",{"$f":"H15-H22","v":0}]
[]
[null,"III.","Total p.m."]
[null,null,"Aktiven",null,null,null,null,{"$f":"SUM('A-Vermögenswerte'!K25,'A-Vermögenswerte'!K55,'A-Vermögenswerte'!K119)","v":0}]
[null,null,"Passiven",null,null,null,null,{"$f":"SUM('A-Vermögenswerte'!K190,'A-Vermögenswerte'!K199,'A-Vermögenswerte'!K213)","v":0}]
[null,null,"Fahrhabe",null,null,null,null,{"$f":"'D-Fahrhabe'!K28","v":0}]
[]
["Zusammenzug der Einnahmen und Ausgaben"]
[]
[null,"I.","Einnahmen",null,null,null,"Total",{"$f":"SUM('B-Einkünfte'!I12,'B-Einkünfte'!I22,'B-Einkünfte'!I30,'B-Einkünfte'!I38,'B-Einkünfte'!I47,'B-Einkünfte'!I56,'B-Einkünfte'!I65,'B-Einkünfte'!I73,'B-Einkünfte'!I82,'B-Einkünfte'!I92,'B-Einkünfte'!I101)","v":0}]
[]
[null,"II.","Ausgaben",null,null,null,"Total",{"$f":"SUM('C-Ausgaben'!I10,'C-Ausgaben'!I21,'C-Ausgaben'!I39,'C-Ausgaben'!I45,'C-Ausgaben'!I53,'C-Ausgaben'!I61,'C-Ausgaben'!I70,'C-Ausgaben'!I79,'C-Ausgaben'!I82,'C-Ausgaben'!I83,'C-Ausgaben'!I84,'C-Ausgaben'!I89,'C-Ausgaben'!I90)","v":0}]
[]
[]
["Unterschriften"]
[]
["Mandatsperson:"]
[]
["Klientin/Klient:"]
[]
["Ort und Datum:"]
[]
["Falls von Klientin/Klient nicht unterzeichnet:"]
[]
[null,null,"Klient/Klientin kann aus gesundheitlichen Gründen nicht unterzeichnen",null,null,null,null,null,null,null,null,null,1,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2,3]
[]
[null,null,"Anderes",null,null,null,null,null,null,null,null,null,3,3]

{"sheet":"XAdmin","index":8,"n_rows":218,"n_cols":3,"rows_kept":218,"cut":false,"hidden":true,"merged":[]}
[null,"Personalien"]
[]
[]
[null,""]
[]
[]
[]
[null,"Liegenschaften"]
[null,"Wählen Sie aus"]
[null,"Steuerwert"]
[null,"Verkehrswert"]
[null,"Hypothekarwert"]
[]
[]
[null,"Mandatsperson"]
[null,"Beistandschaft auswählen"]
[null,"Berufliche Mandatsperson"]
[null,"Private Mandatsperson"]
[]
[]
[null,"Nicht Drucken"]
[null,"Anleitung"]
[null,"XAdmin"]
[]
[]
[]
[]
[]
["Bereich","Blatt","Adresse"]
["ABankA1","A-Vermögenswerte","$A$4:$O$11"]
["ABankA1Daten","A-Vermögenswerte","$B$8:$O$10"]
["ABankA2","A-Vermögenswerte","$A$12:$O$19"]
["ABankA2Daten","A-Vermögenswerte","$B$16:$O$18"]
["ABarschaft","A-Vermögenswerte","$A$77:$O$84"]
["ABarschaftDaten","A-Vermögenswerte","$B$81:$O$83"]
["ABelege","A-Vermögenswerte","$P$1:$P$183"]
["ABelegeNummern","A-Vermögenswerte","$M$1:$M$181"]
["ABetreibungen","A-Vermögenswerte","$A$154:$O$162"]
["ABetreibungenDaten","A-Vermögenswerte","$B$159:$O$161"]
["ABox","A-Vermögenswerte","$B$1:$B$183"]
["AButton","A-Vermögenswerte","$R$1:$R$183"]
["AButtonAnzahl","A-Vermögenswerte","$S$1:$S$183"]
["AButtonBereich","A-Vermögenswerte","$T$1:$T$183"]
["ADarlehen","A-Vermögenswerte","$A$137:$O$144"]
["ADarlehenDaten","A-Vermögenswerte","$B$141:$O$143"]
["ADiverses","A-Vermögenswerte","$A$172:$O$182"]
["ADiversesDaten","A-Vermögenswerte","$B$179:$O$181"]
["AFahrhabe","A-Vermögenswerte","$A$85:$O$90"]
["AFahrhabeNotiz","A-Vermögenswerte","$B$90:$K$90"]
["AFreizuegigkeitC1","A-Vermögenswerte","$A$28:$O$35"]
["AFreizuegigkeitC1Daten","A-Vermögenswerte","$B$32:$O$34"]
["AFreizuegigkeitC2","A-Vermögenswerte","$A$36:$O$43"]
["AFreizuegigkeitC2Daten","A-Vermögenswerte","$B$40:$O$42"]
["AGeschaeftsvermoegen","A-Vermögenswerte","$A$100:$O$111"]
["AGeschaeftsvermoegenDaten","A-Vermögenswerte","$B$108:$O$110"]
["AHypotheken","A-Vermögenswerte","$A$120:$O$128"]
["AHypothekenDaten","A-Vermögenswerte","$B$125:$O$127"]
["AKeine","A-Vermögenswerte","$Q$5:$Q$183"]
["AKredite","A-Vermögenswerte","$A$129:$O$136"]
["AKrediteDaten","A-Vermögenswerte","$B$133:$O$135"]
["ALeer","A-Vermögenswerte","$N$1:$N$183"]
["ALiegenschaften","A-Vermögenswerte","$A$60:$O$67"]
["ALiegenschaftenDaten","A-Vermögenswerte","$B$64:$O$66"]
["AMieterkautionE1","A-Vermögenswerte","$A$52:$O$59"]
["AMieterkautionE1Daten","A-Vermögenswerte","$B$56:$O$58"]
["APendenzen","A-Vermögenswerte","$O$1:$O$181"]
["ASchrankfaecher","A-Vermögenswerte","$A$91:$O$99"]
["ASchrankfaecherDaten","A-Vermögenswerte","$B$95:$O$97"]
["ASchulden","A-Vermögenswerte","$A$153:$O$171"]
["AUnterhaltsbeitraege","A-Vermögenswerte","$A$145:$O$152"]
["AUnterhaltsbeitraegeDaten","A-Vermögenswerte","$B$149:$O$151"]
["AVerlustscheine","A-Vermögenswerte","$A$163:$O$171"]
["AVerlustscheineDaten","A-Vermögenswerte","$B$168:$O$170"]
["AVersicherungen","A-Vermögenswerte","$A$112:$O$119"]
["AVersicherungenDaten","A-Vermögenswerte","$B$116:$O$118"]
["AWeitereGuthaben","A-Vermögenswerte","$A$68:$O$76"]
["AWeitereGuthabenDaten","A-Vermögenswerte","$B$73:$O$75"]
["AWertschriftenB1","A-Vermögenswerte","$A$20:$O$27"]
["AWertschriftenB1Daten","A-Vermögenswerte","$B$24:$O$26"]
["AWertschriftenD1","A-Vermögenswerte","$A$44:$O$51"]
["AWertschriftenD1Daten","A-Vermögenswerte","$B$48:$O$50"]
["BAHV","B-Einkünfte","$A$12:$M$19"]
["BAHVDaten","B-Einkünfte","$B$16:$M$18"]
["BAHVZusatz","B-Einkünfte","$A$28:$M$35"]
["BAHVZusatzDaten","B-Einkünfte","$B$32:$M$34"]
["BBelege","B-Einkünfte","$N$1:$N$92"]
["BBelegeNummern","B-Einkünfte","$K$1:$K$90"]
["BBox","B-Einkünfte","$B$1:$B$92"]
["BButton","B-Einkünfte","$P$1:$P$92"]
["BButtonAnzahl","B-Einkünfte","$Q$1:$Q$92"]
["BButtonBereich","B-Einkünfte","$R$1:$R$92"]
["BErwerb","B-Einkünfte","$A$3:$M$10"]
["BErwerbDaten","B-Einkünfte","$B$7:$M$9"]
["BHilflosen","B-Einkünfte","$A$20:$M$27"]
["BHilflosenDaten","B-Einkünfte","$B$24:$M$26"]
["BKeine","B-Einkünfte","$O$3:$O$92"]
["BLeer","B-Einkünfte","$L$1:$L$92"]
["BNutzniessung","B-Einkünfte","$A$84:$M$91"]
["BNutzniessungDaten","B-Einkünfte","$B$88:$M$90"]
["BPendenzen","B-Einkünfte","$M$1:$M$90"]
["BPKRente","B-Einkünfte","$A$36:$M$43"]
["BPKRenteDaten","B-Einkünfte","$B$40:$M$42"]
["BPrivateRenten","B-Einkünfte","$A$44:$M$51"]
["BPrivateRentenDaten","B-Einkünfte","$B$48:$M$50"]
["BSozialversicherungen","B-Einkünfte","$A$11:$M$11"]
["BSUVA","B-Einkünfte","$A$52:$M$59"]
["BSUVADaten","B-Einkünfte","$B$56:$M$58"]
["BUebrige","B-Einkünfte","$A$76:$M$83"]
["BUebrigeDaten","B-Einkünfte","$B$80:$M$82"]
["BUnterhalt","B-Einkünfte","$A$68:$M$75"]
["BUnterhaltDaten","B-Einkünfte","$B$72:$M$74"]
["BWirtschaft","B-Einkünfte","$A$60:$M$67"]
["BWirtschaftDaten","B-Einkünfte","$B$64:$M$66"]
["CBelege","C-Ausgaben","$N$1:$N$88"]
["CBelegeNummern","C-Ausgaben","$K$1:$K$87"]
["CBox","C-Ausgaben","$B$1:$B$88"]
["CButton","C-Ausgaben","$P$1:$P$88"]
["CButtonAnzahl","C-Ausgaben","$Q$1:$Q$88"]
["CButtonBereich","C-Ausgaben","$R$1:$R$88"]
["CGebaeude","C-Ausgaben","$A$53:$M$60"]
["CGebaeudeDaten","C-Ausgaben","$B$57:$M$59"]
["CHaftpflicht","C-Ausgaben","$A$39:$M$44"]
["CHaftpflichtDaten","C-Ausgaben","$B$41:$M$43"]
["CHausrat","C-Ausgaben","$A$45:$M$52"]
["CHausratDaten","C-Ausgaben","$B$49:$M$51"]
["CKeine","C-Ausgaben","$O$3:$O$88"]
["CKranken","C-Ausgaben","$A$4:$M$9"]
["CKrankenDaten","C-Ausgaben","$B$6:$M$8"]
["CLeer","C-Ausgaben","$L$1:$L$88"]
["CNichterwerb","C-Ausgaben","$A$29:$M$38"]
["CNichterwerbDaten","C-Ausgaben","$B$35:$M$37"]
["CPendenzen","C-Ausgaben","$M$1:$M$87"]
["CUnfall","C-Ausgaben","$A$10:$M$20"]
["CUnfallArbeitgeber","C-Ausgaben","$A$21:$M$28"]
["CUnfallArbeitgeber1XDaten","C-Ausgaben","$F$27:$M$27"]
["CUnfallDaten","C-Ausgaben","$B$17:$M$19"]
["CWeitere3","C-Ausgaben","$A$84:$M$88"]
["CWeitere31XDaten","C-Ausgaben","$I$86:$M$86"]
["CWeitere32XDaten","C-Ausgaben","$I$87:$M$87"]
["CWeitereGebaeude","C-Ausgaben","$A$61:$M$68"]
["CWeitereGebaeudeDaten","C-Ausgaben","$B$65:$M$67"]
["CWeitereVersicherungen","C-Ausgaben","$A$69:$M$76"]
["CWeitereVersicherungenDaten","C-Ausgaben","$B$73:$M$75"]
["CWohn2","C-Ausgaben","$A$77:$M$83"]
["CWohn21XDaten","C-Ausgaben","$I$79:$M$79"]
["CWohn22XDaten","C-Ausgaben","$I$80:$M$80"]
["CWohn23XDaten","C-Ausgaben","$I$81:$M$81"]
["CWohn24XDaten","C-Ausgaben","$I$82:$M$82"]
["DBelege","D-Fahrhabe","$Q$1:$Q$6"]
["DBelegeNummern","D-Fahrhabe","$M$1:$M$6"]
["DBox","D-Fahrhabe","$B$4:$B$13"]
["DButton","D-Fahrhabe","$S$1:$S$13"]
["DButtonAnzahl","D-Fahrhabe","$T$1:$T$13"]
["DButtonBereich","D-Fahrhabe","$U$1:$U$13"]
["DFahrhabe","D-Fahrhabe","$A$1:$N$7"]
["DFahrhabeDaten","D-Fahrhabe","$D$4:$K$6"]
["DKeine","D-Fahrhabe","$R$1:$R$8"]
["DLeer","D-Fahrhabe","$N$1:$N$13"]
["DPendenzen","D-Fahrhabe","$O$1"]
["Allgemeines!Print_Area","Allgemeines","$A$1:$D$37"]
["A-Vermögenswerte'!Print_Area","A-Vermögenswerte","$A$1:$O$182"]
["B-Einkünfte'!Print_Area","B-Einkünfte","$A$1:$M$91"]
["C-Ausgaben'!Print_Area","C-Ausgaben","$A$1:$M$87"]
["D-Fahrhabe'!Print_Area","D-Fahrhabe","$A$1:$L$13"]
["Ergänzende Angaben'!Print_Area","Ergänzende Angaben","$A$1:$M$82"]
["Zusammenzug!Print_Area","Zusammenzug","$A$1:$H$65"]
["DVerwaltung","D-Fahrhabe","$A$8:$K$13"]
["EBelege","Ergänzende Angaben","$N$41:$N$70"]
["EBelegeNummern","Ergänzende Angaben","$K$1:$K$68"]
["EBox","Ergänzende Angaben","$B$1:$B$70"]
["EButton","Ergänzende Angaben","$P$1:$P$70"]
["EButtonAnzahl","Ergänzende Angaben","$Q$1:$Q$70"]
["EButtonBereich","Ergänzende Angaben","$R$1:$R$70"]
["EEhevertrag2C","Ergänzende Angaben","$A$22:$M$30"]
["EEhevertrag2CDaten","Ergänzende Angaben","$B$28:$I$30"]
["EEigengueter1","Ergänzende Angaben","$A$41:$M$59"]
["EEigengueter1Daten","Ergänzende Angaben","$B$47:$M$49"]
["EEigengueter2","Ergänzende Angaben","$A$51:$M$59"]
["EEigengueter2Daten","Ergänzende Angaben","$B$56:$M$58"]
["EEigengueterAlles","Ergänzende Angaben","$I$41:$I$59"]
["EEigengueterE1","Ergänzende Angaben","$B$44"]
["EEigengueterE2","Ergänzende Angaben","$B$53"]
["EErrungenschaft2B","Ergänzende Angaben","$B$16"]
["EGemeinschaft2B","Ergänzende Angaben","$B$18"]
["EGueterstand","Ergänzende Angaben","$A$14:$M$21"]
["EKeine","Ergänzende Angaben","$O$41:$O$70"]
["EKommentarPendenz","Ergänzende Angaben","$A$70:$M$82"]
["ELeer","Ergänzende Angaben","$L$1:$L$82"]
["ELetzterWille","Ergänzende Angaben","$A$2:$M$7"]
["EPendenzen","Ergänzende Angaben","$M$1:$M$68"]
["ETrennung2B","Ergänzende Angaben","$B$20"]
["EVerfuegung1","Ergänzende Angaben","$A$2:$M$8"]
["EVerfuegung11XDaten","Ergänzende Angaben","$E$7:$I$7"]
["EVorbezug","Ergänzende Angaben","$A$31:$M$40"]
["EVorbezugDaten","Ergänzende Angaben","$B$37:$M$39"]
["EWeitereVerpflichtungen","Ergänzende Angaben","$A$60:$M$69"]
["EWeitereVerpflichtungenDaten","Ergänzende Angaben","$B$66:$M$68"]
["EZivilstand","Ergänzende Angaben","$A$9:$M$14"]
["Personalien","Allgemeines","$A$6"]
["XBereichNamen","XAdmin","$A$29:$C$29"]
["XNichtDrucken","XAdmin","$B$21"]
["XPersonalien","XAdmin","$B$2:$B$5"]
["ZAktiven","Zusammenzug","$A$3:$H$17"]
["ZBelegeNummern","Zusammenzug","$J$52:$J$58"]
["ZBox","Zusammenzug","$B$52:$B$58"]
["ZButton","Zusammenzug","$M$52:$M$58"]
["ZButtonAnzahl","Zusammenzug","$N$52:$N$58"]
["ZButtonBereich","Zusammenzug","$O$52:$O$58"]
["ZEinAus","Zusammenzug","$A$35:$H$40"]
["ZKommentar","Zusammenzug","$A$59:$H$65"]
["ZLeer","Zusammenzug","$K$52:$K$58"]
["ZNichtAnderes","Zusammenzug","$B$57"]
["ZNichtGesundheit","Zusammenzug","$B$53"]
["ZNichtTermin","Zusammenzug","$B$55"]
["ZPassiven","Zusammenzug","$A$18:$H$29"]
["ZPendenzen","Zusammenzug","$L$52:$L$58"]
["ZTotalPM","Zusammenzug","$A$30:$H$33"]
["ZUnterschriften","Zusammenzug","$A$41:$E$49"]