{"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":7,"macros":1,"external_links":0,"defined_names":192,"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":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,2],[5,0,5,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"]
[]
[]
[]
[]
[{"$f":"IF(AND( XAdmin!B3 =\"\",XAdmin!B2 =\"\", XAdmin!B5 =\"\", XAdmin!B4=\"\"),\"\", XAdmin!B3 & \" \" & XAdmin!B2 & \", \" & XAdmin!B5 & \", \" & XAdmin!B4)","v":""}]
[]
[]
[]
[]
[]
[]
["Entscheid vom:"]
[]
[]
[]
["Inventarstichtag:"]
[]
[]
[]
["Aufnahmedatum:"]
[]
[]
[]
["Beistandsperson:","Name:"]
[]
[null,"Vorname:"]
[]
[null,"Mandat:","Beistandschaft auswählen"]
[]
[]
[]
[]
[]
[]
[]
["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önliche 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 fertig 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ände 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":182,"n_cols":20,"rows_kept":182,"cut":false,"hidden":false,"merged":[[141,7,141,9],[142,1,142,6],[142,7,142,9],[143,1,143,6],[149,1,149,5],[118,7,118,9],[134,7,134,9],[135,1,135,6],[135,7,135,9],[139,1,139,6],[139,7,139,9],[126,1,126,6],[126,7,126,9],[127,1,127,6],[127,7,127,9],[131,1,131,6],[147,8,147,9],[149,6,149,7],[149,8,149,9],[125,1,125,6],[125,7,125,9],[3,12,6,12],[3,14,6,14],[11,12,14,12],[11,14,14,14],[95,1,95,4],[94,1,94,4],[73,1,73,9],[72,1,72,9],[81,1,81,9],[80,1,80,9],[64,1,64,9],[63,1,63,9],[58,1,58,6],[58,7,58,9],[54,1,54,9],[57,1,57,9],[49,1,49,6],[49,7,49,9],[83,7,83,9],[71,1,71,9],[74,1,74,9],[75,1,75,6],[75,7,75,9],[46,7,46,9],[181,1,181,6],[181,7,181,9],[177,1,177,4],[180,1,180,4],[169,7,169,9],[170,1,170,6],[170,7,170,9],[178,1,178,4],[169,1,169,4],[179,1,179,4],[93,1,93,4],[96,1,96,4],[82,1,82,9],[83,1,83,6],[89,1,89,10],[47,1,47,6],[47,7,47,9],[65,1,65,9],[68,1,68,10],[79,1,79,9],[66,1,66,6],[56,1,56,9],[55,1,55,9],[66,7,66,9],[62,1,62,9],[160,1,160,6],[167,1,167,4],[167,7,167,9],[166,7,166,9],[161,1,161,6],[161,7,161,9],[151,1,151,6],[147,6,147,7],[97,1,97,6],[97,7,97,9],[159,1,159,6],[159,7,159,9],[157,1,157,6],[166,1,166,4],[148,6,148,7],[148,8,148,9],[157,7,157,9],[160,7,160,9],[151,7,151,9],[107,1,107,5],[109,1,109,5],[148,1,148,5],[150,1,150,5],[141,1,141,6],[26,1,26,6],[26,7,26,9],[23,1,23,5],[23,6,23,9],[25,1,25,5],[25,6,25,9],[31,1,31,5],[31,6,31,9],[168,1,168,4],[168,7,168,9],[140,1,140,6],[140,7,140,9],[131,7,131,9],[143,7,143,9],[147,1,147,4],[133,1,133,6],[133,7,133,9],[134,1,134,6],[150,6,150,7],[150,8,150,9],[158,1,158,6],[158,7,158,9],[132,1,132,6],[132,7,132,9],[33,1,33,5],[34,7,34,9],[6,1,6,5],[6,6,6,9],[8,1,8,5],[8,6,8,9],[14,1,14,5],[14,6,14,9],[16,1,16,5],[16,6,16,9],[7,1,7,5],[7,6,7,9],[9,1,9,5],[9,6,9,9],[15,1,15,5],[15,6,15,9],[22,1,22,5],[22,6,22,9],[24,1,24,5],[24,6,24,9],[30,1,30,5],[30,6,30,9],[32,1,32,5],[32,6,32,9],[52,12,54,12],[52,14,54,14],[10,1,10,6],[10,7,10,9],[20,12,22,12],[20,14,22,14],[28,12,30,12],[28,14,30,14],[44,12,46,12],[44,14,46,14],[36,12,38,12],[36,14,38,14],[42,1,42,6],[42,7,42,9],[50,1,50,6],[50,7,50,9],[18,1,18,6],[18,7,18,9],[34,1,34,6],[17,1,17,5],[17,6,17,9],[48,1,48,6],[48,7,48,9],[46,1,46,6],[117,1,117,4],[98,1,98,4],[108,6,108,9],[107,6,107,9],[114,1,114,4],[116,1,116,4],[115,1,115,4],[124,1,124,6],[124,7,124,9],[106,1,106,5],[108,1,108,5],[114,5,114,9],[116,5,116,9],[98,6,98,10],[109,6,109,9],[110,1,110,6],[123,1,123,6],[123,7,123,9],[118,1,118,6],[117,5,117,9],[40,1,40,5],[40,6,40,9],[167,5,167,6],[169,5,169,6],[178,5,178,9],[180,5,180,9],[33,6,33,9],[39,1,39,5],[39,6,39,9],[41,1,41,5],[41,6,41,9],[94,5,94,9],[96,5,96,9],[115,5,115,9],[166,5,166,6],[168,5,168,6],[177,5,177,9],[179,5,179,9],[38,1,38,5],[38,6,38,9],[93,5,93,9],[95,5,95,9],[110,7,110,9],[106,6,106,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,0,null,null,null,null,{"$f":"IF(NOT(Q9),IF(OR(M9<>\"\",O9<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$5=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q10),IF(OR(M10<>\"\",O10<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$5=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K8:K10)","v":0}]
[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(Q16),IF(OR(M16<>\"\",O16<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$13=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q17),IF(OR(M17<>\"\",O17<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$13=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q18),IF(OR(M18<>\"\",O18<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$13=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total p.m.",null,null,{"$f":"SUM(K16:K18)","v":0}]
[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(Q24),IF(OR(M24<>\"\",O24<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$21=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q25),IF(OR(M25<>\"\",O25<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$21=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q26),IF(OR(M26<>\"\",O26<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$21=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K24:K26)","v":0}]
[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(Q32),IF(OR(M32<>\"\",O32<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$29=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q33),IF(OR(M33<>\"\",O33<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$29=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q34),IF(OR(M34<>\"\",O34<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$29=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K32:K34)","v":0}]
[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(Q40),IF(OR(M40<>\"\",O40<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$37=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q41),IF(OR(M41<>\"\",O41<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$37=\"X\",TRUE,FALSE)","v":false}]
[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$37=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total p.m.",null,null,{"$f":"SUM(K40:K42)","v":0}]
[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(Q48),IF(OR(M48<>\"\",O48<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$45=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q49),IF(OR(M49<>\"\",O49<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$45=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q50),IF(OR(M50<>\"\",O50<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$45=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K48:K50)","v":0}]
[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(Q56),IF(OR(M56<>\"\",O56<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$53=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q57),IF(OR(M57<>\"\",O57<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$53=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q58),IF(OR(M58<>\"\",O58<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$53=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K56:K58)","v":0}]
[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(Q64),IF(OR(M64<>\"\",O64<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$61=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q65),IF(OR(M65<>\"\",O65<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$61=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q66),IF(OR(M66<>\"\",O66<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$61=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K64:K66)","v":0}]
[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(Q73),IF(OR(M73<>\"\",O73<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$70=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q74),IF(OR(M74<>\"\",O74<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$70=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q75),IF(OR(M75<>\"\",O75<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$70=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K73:K75)","v":0}]
[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(Q81),IF(OR(M81<>\"\",O81<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$78=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q82),IF(OR(M82<>\"\",O82<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$78=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q83),IF(OR(M83<>\"\",O83<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$78=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K81:K83)","v":0}]
[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(Q95),IF(OR(M95<>\"\",O95<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$92=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q96),IF(OR(M96<>\"\",O96<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$92=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q97),IF(OR(M97<>\"\",O97<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$92=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total p.m.",null,null,{"$f":"SUM(K95:K97)","v":0}]
[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(Q108),IF(OR(M108<>\"\",O108<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$101=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q109),IF(OR(M109<>\"\",O109<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$101=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q110),IF(OR(M110<>\"\",O110<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$101=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,{"$f":"IF(B103=\"X\",\"Total p.m.\", \"Total\")","v":"Total"},null,null,{"$f":"SUM(K108:K110)","v":0}]
[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(Q116),IF(OR(M116<>\"\",O116<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$113=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q117),IF(OR(M117<>\"\",O117<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$113=\"X\",TRUE,FALSE)","v":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},{"$f":"IF($B$113=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K116:K118)","v":0}]
[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(Q125),IF(OR(M125<>\"\",O125<>\"\"),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(Q126),IF(OR(M126<>\"\",O126<>\"\"),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(Q127),IF(OR(M127<>\"\",O127<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$122=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K125:K127)","v":0}]
[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(Q133),IF(OR(M133<>\"\",O133<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$130=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q134),IF(OR(M134<>\"\",O134<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$130=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q135),IF(OR(M135<>\"\",O135<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$130=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K132:K135)","v":0}]
[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(Q141),IF(OR(M141<>\"\",O141<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$138=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q142),IF(OR(M142<>\"\",O142<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$138=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q143),IF(OR(M143<>\"\",O143<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$138=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K141:K143)","v":0}]
[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(Q149),IF(OR(M149<>\"\",O149<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$146=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q150),IF(OR(M150<>\"\",O150<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$146=\"X\",TRUE,FALSE)","v":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},{"$f":"IF($B$146=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(K149:K151)","v":0}]
[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(Q159),IF(OR(M159<>\"\",O159<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$156=\"X\",TRUE,FALSE)","v":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},{"$f":"IF($B$156=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q161),IF(OR(M161<>\"\",O161<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$156=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null," Total p.m.",null,null,{"$f":"SUM(K159:K161)","v":0}]
[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(Q168),IF(OR(M168<>\"\",O168<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$165=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q169),IF(OR(M169<>\"\",O169<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$165=\"X\",TRUE,FALSE)","v":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},{"$f":"IF($B$165=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total p.m.",null,null,{"$f":"SUM(K168:K170)","v":0}]
[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(Q179),IF(OR(M179<>\"\",O179<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$176=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q180),IF(OR(M180<>\"\",O180<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$176=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(Q181),IF(OR(M181<>\"\",O181<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$176=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total p.m.",null,null,{"$f":"SUM(K179:K181)","v":0}]

{"sheet":"B-Einkünfte","index":3,"n_rows":91,"n_cols":18,"rows_kept":91,"cut":false,"hidden":false,"merged":[[75,2,75,7],[2,12,5,12],[89,1,89,4],[89,5,89,6],[86,1,86,4],[86,5,86,6],[81,1,81,7],[5,1,5,5],[8,1,8,5],[9,1,9,7],[2,10,5,10],[78,1,78,7],[46,1,46,7],[49,1,49,7],[54,1,54,7],[74,1,74,7],[26,1,26,7],[14,1,14,7],[22,1,22,7],[38,1,38,7],[70,1,70,7],[30,1,30,7],[17,1,17,7],[25,1,25,7],[41,1,41,7],[15,1,15,7],[18,1,18,7],[23,1,23,7],[24,1,24,7],[31,1,31,7],[32,1,32,7],[34,1,34,7],[39,1,39,7],[5,6,5,7],[8,6,8,7],[6,1,6,5],[6,6,6,7],[7,1,7,5],[7,6,7,7],[33,1,33,7],[62,1,62,7],[63,1,63,7],[57,1,57,7],[56,1,56,7],[58,1,58,7],[64,1,64,7],[42,1,42,7],[47,1,47,7],[50,1,50,7],[55,1,55,7],[16,1,16,7],[48,1,48,7],[90,1,90,7],[40,1,40,7],[88,1,88,4],[88,5,88,6],[79,1,79,7],[80,1,80,7],[82,1,82,7],[87,1,87,4],[87,5,87,6],[65,1,65,7],[66,1,66,7],[71,1,71,7],[72,1,72,7],[73,1,73,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,0,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,0,null,null,null,null,{"$f":"IF(NOT(O9),IF(OR(K9<>\"\",M9<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$4=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I7:I9)","v":0}]
[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(O16),IF(OR(K16<>\"\",M16<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$13=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O17),IF(OR(K17<>\"\",M17<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$13=\"X\",TRUE,FALSE)","v":false}]
[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,"Total",null,null,null,null,null,null,{"$f":"SUM(I16:I18)","v":0}]
[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(O24),IF(OR(K24<>\"\",M24<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$21=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O25),IF(OR(K25<>\"\",M25<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$21=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O26),IF(OR(K26<>\"\",M26<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$21=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I24:I26)","v":0}]
[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(O32),IF(OR(K32<>\"\",M32<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$29=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O33),IF(OR(K33<>\"\",M33<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$29=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O34),IF(OR(K34<>\"\",M34<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$29=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I32:I34)","v":0}]
[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(O40),IF(OR(K40<>\"\",M40<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$37=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O41),IF(OR(K41<>\"\",M41<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$37=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O42),IF(OR(K42<>\"\",M42<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$37=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I40:I42)","v":0}]
[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(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},{"$f":"IF($B$45=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I48:I50)","v":0}]
[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(O56),IF(OR(K56<>\"\",M56<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$53=\"X\",TRUE,FALSE)","v":false}]
[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$53=\"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$53=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I56:I58)","v":0}]
[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(O64),IF(OR(K64<>\"\",M64<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$61=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O65),IF(OR(K65<>\"\",M65<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$61=\"X\",TRUE,FALSE)","v":false}]
[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$61=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I64:I66)","v":0}]
[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(O72),IF(OR(K72<>\"\",M72<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$69=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O73),IF(OR(K73<>\"\",M73<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$69=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O74),IF(OR(K74<>\"\",M74<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$69=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I72:I74)","v":0}]
[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(O80),IF(OR(K80<>\"\",M80<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$77=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O81),IF(OR(K81<>\"\",M81<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$77=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O82),IF(OR(K82<>\"\",M82<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$77=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I80:I82)","v":0}]
[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","CHF pro Monat"]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O88),IF(OR(K88<>\"\",M88<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$85=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O89),IF(OR(K89<>\"\",M89<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$85=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O90),IF(OR(K90<>\"\",M90<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$85=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I88:I90)","v":0}]

{"sheet":"C-Ausgaben","index":4,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[87,2,87,7],[2,12,4,12],[58,1,58,5],[58,6,58,7],[37,1,37,7],[19,1,19,7],[33,1,33,5],[33,6,33,7],[39,1,39,5],[39,6,39,7],[34,1,34,5],[34,6,34,7],[35,1,35,5],[35,6,35,7],[49,1,49,5],[49,6,49,7],[2,10,4,10],[41,1,41,5],[41,6,41,7],[18,6,18,7],[43,1,43,7],[17,1,17,5],[17,6,17,7],[18,1,18,5],[40,1,40,5],[40,6,40,7],[8,1,8,7],[4,1,4,5],[4,6,4,7],[5,1,5,5],[5,6,5,7],[7,1,7,5],[7,6,7,7],[6,1,6,5],[6,6,6,7],[50,6,50,7],[48,1,48,5],[51,1,51,7],[15,1,15,5],[15,6,15,7],[16,1,16,5],[16,6,16,7],[48,6,48,7],[36,1,36,5],[36,6,36,7],[47,1,47,5],[47,6,47,7],[74,1,74,5],[63,1,63,5],[42,1,42,5],[42,6,42,7],[73,1,73,5],[73,6,73,7],[66,1,66,5],[66,6,66,7],[55,1,55,5],[55,6,55,7],[56,1,56,5],[56,6,56,7],[57,1,57,5],[57,6,57,7],[59,1,59,7],[50,1,50,5],[67,1,67,7],[71,1,71,5],[71,6,71,7],[72,1,72,5],[72,6,72,7],[86,2,86,7],[26,5,26,8],[26,1,26,4],[78,2,78,7],[79,2,79,7],[80,2,80,7],[81,2,81,7],[85,2,85,7],[27,1,27,7],[74,6,74,7],[75,1,75,7],[63,6,63,7],[64,1,64,5],[64,6,64,7],[65,1,65,5],[65,6,65,7]]}
[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,0,null,null,null,null,{"$f":"IF(OR(K7<>\"\",M7<>\"\"),FALSE,TRUE)","v":true}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(K8<>\"\",M8<>\"\"),FALSE,TRUE)","v":true}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I6:I8)","v":0}]
[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(O17),IF(OR(K17<>\"\",M17<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$12=\"X\",TRUE,FALSE)","v":false}]
[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$12=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O19),IF(OR(K19<>\"\",M19<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$12=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I17:I19)","v":0}]
[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(O27),IF(OR(K27<>\"\",M27<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$23=\"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(O35),IF(OR(K35<>\"\",M35<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$30=\"X\",TRUE,FALSE)","v":false}]
[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$30=\"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},{"$f":"IF($B$30=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I35:I37)","v":0}]
[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(K41<>\"\",M41<>\"\"),FALSE,TRUE)","v":true}]
[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,0,null,null,null,null,{"$f":"IF(OR(K43<>\"\",M43<>\"\"),FALSE,TRUE)","v":true}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I41:I43)","v":0}]
[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(O49),IF(OR(K49<>\"\",M49<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$46=\"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},{"$f":"IF($B$46=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O51),IF(OR(K51<>\"\",M51<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$46=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I49:I51)","v":0}]
[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(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},{"$f":"IF($B$54=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I57:I59)","v":0}]
[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(O65),IF(OR(K65<>\"\",M65<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$62=\"X\",TRUE,FALSE)","v":false}]
[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$62=\"X\",TRUE,FALSE)","v":false}]
[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$62=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I65:I67)","v":0}]
[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(O73),IF(OR(K73<>\"\",M73<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$70=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(NOT(O74),IF(OR(K74<>\"\",M74<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$70=\"X\",TRUE,FALSE)","v":false}]
[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$70=\"X\",TRUE,FALSE)","v":false}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I73:I75)","v":0}]
[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(B79=\"X\",IF(OR(K79<>\"\",M79<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B79=\"X\",FALSE,TRUE)","v":true},1,1,"CWohn21XDaten"]
[null,null,"Heimkosten",null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B80=\"X\",IF(OR(K80<>\"\",M80<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B80=\"X\",FALSE,TRUE)","v":true},1,1,"CWohn22XDaten"]
[null,null,"Hypozins",null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B81=\"X\",IF(OR(K81<>\"\",M81<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B81=\"X\",FALSE,TRUE)","v":true},1,1,"CWohn23XDaten"]
[null,null,"Verwaltungskosten Wohneigentum",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,"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(B86=\"X\",IF(OR(K86<>\"\",M86<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B86=\"X\",FALSE,TRUE)","v":true},1,1,"CWeitere31XDaten"]
[null,null,"Lohnverpflichtungen",null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B87=\"X\",IF(OR(K87<>\"\",M87<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B87=\"X\",FALSE,TRUE)","v":true},1,1,"CWeitere32XDaten"]
[null,null,"Weitere regelmässige relevante Ausgaben",null,null,null,null,null,0,null,null,null,null,{"$f":"IF(B88=\"X\",IF(OR(K88<>\"\",M88<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B88=\"X\",FALSE,TRUE)","v":true},1,1,"CWeitere33XDaten"]

{"sheet":"D-Fahrhabe","index":5,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":true,"merged":[[6,1,8,1],[1,1,2,1],[9,3,10,10],[2,3,2,9],[11,3,12,10],[6,7,6,9],[3,3,3,9],[4,3,4,9],[5,3,5,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$86=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$86=\"X\",TRUE,FALSE)","v":false},1,1]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF('A-Vermögenswerte'!$B$86=\"X\",TRUE,FALSE)","v":false},1,1]
[null,"Verwaltung",null,null,null,null,null,"Total p.m.",null,null,{"$f":"SUM(K4:K6)","v":0}]
[]
[]
[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":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[36,1,36,2],[36,3,36,7],[37,3,37,7],[57,3,57,7],[45,1,45,2],[45,3,45,7],[37,1,37,2],[55,3,55,7],[48,3,48,7],[46,1,46,2],[46,3,46,7],[48,1,48,2],[47,1,47,2],[47,3,47,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],[67,1,67,7],[64,1,64,7],[38,1,38,2],[38,3,38,7],[66,1,66,7],[65,1,65,7],[56,1,56,2],[56,3,56,7],[55,1,55,2],[54,1,54,2],[54,3,54,7],[50,1,50,3],[41,1,41,3],[57,1,57,2]]}
[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,2,2]
[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,2]
[]
[null,null,"Verheiratet / In eingetragener Partnerschaft",null,null,null,null,null,null,null,null,null,null,null,null,2,2]
[]
[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,0,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,0,null,null,null,null,{"$f":"IF(NOT(O39),IF(OR(K39<>\"\",M39<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$32=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I37:I39)","v":0}]
[null,"e.","Eigengüter"]
[null,"Ehefrau / Partner 1"]
[]
[null,"X","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(O47),IF(OR(K47<>\"\",M47<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B$44=\"X\",TRUE,FALSE)","v":true}]
[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":false},{"$f":"IF($B$44=\"X\",TRUE,FALSE)","v":true}]
[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":false},{"$f":"IF($B$44=\"X\",TRUE,FALSE)","v":true}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I47:I49)","v":0}]
[null,"Ehemann / Partner 2"]
[]
[null,"X","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(O56),IF(OR(K56<>\"\",M56<>\"\"),FALSE,TRUE),FALSE)","v":false},{"$f":"IF($B$53=\"X\",TRUE,FALSE)","v":true}]
[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":false},{"$f":"IF($B$53=\"X\",TRUE,FALSE)","v":true}]
[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":false},{"$f":"IF($B$53=\"X\",TRUE,FALSE)","v":true}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I56:I58)","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(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,0,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,0,null,null,null,null,{"$f":"IF(NOT(O68),IF(OR(K68<>\"\",M68<>\"\"),FALSE,TRUE),FALSE)","v":true},{"$f":"IF($B$63=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I66:I68)","v":0}]
[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'!K11","v":0}]
[null,null,"b.","Wertschriften in Depot",null,null,null,{"$f":"'A-Vermögenswerte'!K27","v":0}]
[null,null,"c.","Freizügigkeitskonten und Sparen 3",null,null,null,{"$f":"'A-Vermögenswerte'!K35","v":0}]
[null,null,"d.","Weitere Wertschriften und Anteilscheine",null,null,null,{"$f":"'A-Vermögenswerte'!K51","v":0}]
[null,null,"e.","Mieterkaution/Heimdepot",null,null,null,{"$f":"'A-Vermögenswerte'!K59","v":0}]
[null,"2.","Liegenschaften",null,null,null,null,{"$f":"'A-Vermögenswerte'!K67","v":0}]
[null,"3.","Weitere Guthaben",null,null,null,null,{"$f":"'A-Vermögenswerte'!K76","v":0}]
[null,"4.","Barschaft",null,null,null,null,{"$f":"'A-Vermögenswerte'!K84","v":0}]
[null,"5.","Geschäftsvermögen",null,null,null,null,{"$f":"IF('A-Vermögenswerte'!B103,\"p.m.\",'A-Vermögenswerte'!K111)","v":0}]
[null,"6.","Versicherungen mit Rückkaufswert",null,null,null,null,{"$f":"'A-Vermögenswerte'!K119","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'!K128","v":0}]
[null,"2.","Kredite",null,null,null,null,{"$f":"'A-Vermögenswerte'!K136","v":0}]
[null,"3.","Darlehen",null,null,null,null,{"$f":"'A-Vermögenswerte'!K144","v":0}]
[null,"4.","Geschuldete Unterhaltsbeiträge",null,null,null,null,{"$f":"'A-Vermögenswerte'!K152","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,"1.","Aktiven",null,null,null,null,{"$f":"SUM('A-Vermögenswerte'!K19,'A-Vermögenswerte'!K43,'A-Vermögenswerte'!K98)","v":0}]
[null,"2.","Passiven",null,null,null,null,{"$f":"SUM('A-Vermögenswerte'!K162,'A-Vermögenswerte'!K171,'A-Vermögenswerte'!K182)","v":0}]
[null,"3.","Fahrhabe",null,null,null,null,{"$f":"'D-Fahrhabe'!K7","v":0}]
[]
["Zusammenzug der Einnahmen und Ausgaben"]
[]
[null,"I.","Einnahmen",null,null,null,"Total",{"$f":"SUM('B-Einkünfte'!I10,'B-Einkünfte'!I19,'B-Einkünfte'!I27,'B-Einkünfte'!I35,'B-Einkünfte'!I43,'B-Einkünfte'!I51,'B-Einkünfte'!I59,'B-Einkünfte'!I67,'B-Einkünfte'!I75,'B-Einkünfte'!I83,'B-Einkünfte'!I91)","v":0}]
[]
[null,"II.","Ausgaben",null,null,null,"Total",{"$f":"SUM('C-Ausgaben'!I9,'C-Ausgaben'!I20,'C-Ausgaben'!I38,'C-Ausgaben'!I44,'C-Ausgaben'!I52,'C-Ausgaben'!I60,'C-Ausgaben'!I68,'C-Ausgaben'!I76,'C-Ausgaben'!I79,'C-Ausgaben'!I80,'C-Ausgaben'!I81,'C-Ausgaben'!I82,'C-Ausgaben'!I86,'C-Ausgaben'!I87,'C-Ausgaben'!I88)","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":227,"n_cols":3,"rows_kept":227,"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,"Tabellen Drucken"]
[null,"Allgemeines"]
[null,"A-Vermögenswerte"]
[null,"B-Einkünfte"]
[null,"C-Ausgaben"]
[null,"D-Fahrhabe"]
[null,"Ergänzende Angaben"]
[null,"Zusammenzug"]
[]
[]
[]
[]
[]
[]
["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$89"]
["CBelegeNummern","C-Ausgaben","$K$1:$K$87"]
["CBox","C-Ausgaben","$B$1:$B$89"]
["CButton","C-Ausgaben","$P$1:$P$89"]
["CButtonAnzahl","C-Ausgaben","$Q$1:$Q$89"]
["CButtonBereich","C-Ausgaben","$R$1:$R$89"]
["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$89"]
["CKranken","C-Ausgaben","$A$4:$M$9"]
["CKrankenDaten","C-Ausgaben","$B$6:$M$8"]
["CLeer","C-Ausgaben","$L$1:$L$89"]
["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$97"]
["CWeitere31XDaten","C-Ausgaben","$I$86:$M$86"]
["CWeitere32XDaten","C-Ausgaben","$I$87:$M$87"]
["CWeitere33","C-Ausgaben","$B$88"]
["CWeitere33XDaten","C-Ausgaben","$I$88:$M$88"]
["CWeitereGebaeude","C-Ausgaben","$A$61:$M$68"]
["CWeitereGebaeudeDaten","C-Ausgaben","$B$65:$M$67"]
["CWeitereRelevante","C-Ausgaben","$A$90:$I$97"]
["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$97"]
["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$59"]
["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$35:$C$35"]
["XDrucken","XAdmin","$B$21"]
["XPersonalien","XAdmin","$B$2:$B$5"]
["ZAktiven","Zusammenzug","$A$3:$H$15"]
["ZBelegeNummern","Zusammenzug","$J$46:$J$52"]
["ZBox","Zusammenzug","$B$46:$B$52"]
["ZButton","Zusammenzug","$M$46:$M$52"]
["ZButtonAnzahl","Zusammenzug","$N$46:$N$52"]
["ZButtonBereich","Zusammenzug","$O$46:$O$52"]
["ZEinAus","Zusammenzug","$A$29:$H$34"]
["ZKommentar","Zusammenzug","$A$53:$H$59"]
["ZLeer","Zusammenzug","$K$46:$K$52"]
["ZNichtAnderes","Zusammenzug","$B$51"]
["ZNichtGesundheit","Zusammenzug","$B$47"]
["ZNichtTermin","Zusammenzug","$B$49"]
["ZPassiven","Zusammenzug","$A$16:$H$23"]
["ZPendenzen","Zusammenzug","$L$46:$L$52"]
["ZTotalPM","Zusammenzug","$A$24:$H$27"]
["ZUnterschriften","Zusammenzug","$A$35:$E$43"]