{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Grunddaten","Inventar","Budget","Definitionen","Vermögen VBVV"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":7,"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":"Grunddaten","index":0,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,4,3,5]]}
["Inventaraufnahme"]
[]
["für:","Vorname Name KlientIn"]
["Geb.:","Geburtsdatum",null,"Geführt durch:","Vorname Name Beistand/Beiständin"]
[]
["per:","Stichtag der Inventaraufnahme"]

{"sheet":"Inventar","index":1,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,0,8,1],[12,0,12,1],[11,0,11,1],[10,0,10,1],[9,0,9,1],[19,0,19,1],[20,0,20,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[35,0,35,1],[36,0,36,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1]]}
["Inventar"]
[]
["für:",{"$f":"IF(Grunddaten!B3=\"Vorname Name KlientIn\",\"Eingabe in Grunddaten\",Grunddaten!B3)","v":"Eingabe in Grunddaten"}]
["Geb.:",{"$f":"IF(Grunddaten!B4=\"Geburtsdatum\",\"Eingabe in Grunddaten\",Grunddaten!B4)","v":"Eingabe in Grunddaten"},"Geführt durch:",{"$f":"IF(Grunddaten!E4:E4=\"Vorname Name Beistand/Beiständin\",\"Eingabe in Grunddaten\",Grunddaten!E4)","v":"Eingabe in Grunddaten"}]
[]
["per",{"$f":"IF(Grunddaten!B6=\"Stichtag der Inventaraufnahme\",\"Eingabe in Grunddaten\",Grunddaten!B6)","v":"Eingabe in Grunddaten"}]
[]
["Aktiven",null,null,"Alle Angaben in Fr."]
["Typ",null,"Text",{"$f":"IF(ISNUMBER(B6),CONCATENATE(\"Saldo am \",DAY(B6),\".\",MONTH(B6),\".\",YEAR(B6)),\"Saldo\")","v":"Saldo"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Aktiven",{"$f":"SUM(D10:D21)","v":0}]
[]
["Passiven",null,null,"Alle Angaben in Fr."]
["Typ",null,"Text",{"$f":"IF(ISNUMBER(B6),CONCATENATE(\"Saldo am \",DAY(B6),\".\",MONTH(B6),\".\",YEAR(B6)),\"Saldo\")","v":"Saldo"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Passiven",{"$f":"SUM(D26:D37)","v":0}]
[]
[null,null,{"$f":"IF(Grunddaten!B6=\"Stichtag der Inventaraufnahme\",\"Stichtag in Grunddaten eintragen\",IF(D22-D38>=0,CONCATENATE(\"Total Vermögen per \",DAY(Grunddaten!B6),\".\",MONTH(Grunddaten!B6),\".\",YEAR(Grunddaten!B6)),CONCATENATE(\"Total Schulden per \",Grunddaten!B6)))","v":"Stichtag in Grunddaten eintragen"},{"$f":"IF(Grunddaten!B6=\"Stichtag der Inventaraufnahme\",\" \",D22-D38)","v":" "}]
[]
[]
["Vermögensstruktur nach VBVV"]
["Vermögen für",null,"Typ Vermögen nach","Eingangssaldo"]
["die Sicherstellung des Lebensbedarfs",null,"Art. 6 VBVV",{"$f":"'Vermögen VBVV'!I16","v":0}]
["weitergehende Bedürfnisse",null,"Art. 7 Abs. 1 VBVV",{"$f":"'Vermögen VBVV'!I17","v":0}]
["besonders günstige finanz. Verhältnisse",null,"Art. 7 Abs. 3 VBVV",{"$f":"'Vermögen VBVV'!I18","v":0}]

{"sheet":"Budget","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Name/Vorname u. Geb.-Datum:",{"$f":"IF(Grunddaten!B3=\"Vorname Name KlientIn\",\"Name&Vorname in Grunddaten eintragen\",IF(ISTEXT(Grunddaten!B4),\"Geburtsdatum in Grunddaten eintragen\",CONCATENATE(Grunddaten!B3,\", Geb. \",DAY(Grunddaten!B4),\".\",MONTH(Grunddaten!B4),\".\",YEAR(Grunddaten!B4))))","v":"Name&Vorname in Grunddaten eintragen"}]
[null,"Budget","Budget","Budget"]
["Einnahmen","Pro Monat","Pro Jahr","Pro 2 Jahre"]
[]
["Lohn",null,{"$f":"B5*12","v":0},{"$f":"B5*24","v":0}]
["AHV/IV Rente",null,{"$f":"B6*12","v":0},{"$f":"B6*24","v":0}]
["Ergänzungsleistungen EL",null,0,0]
["Hilflosenentschädigung HE",null,0,0]
["Sozialhilfe WSH",null,0,0]
["Prämienverbilligung",null,0,0]
["Leistungen Krankenkasse",null,0,0]
["Krankheits-/Behind.-kosten EL",null,0,0]
["Zinsen/Dividenden",null,0,0]
["Verschiedene Einnahmen",null,0,0]
["Kapitalverschiebungen",null,0,0]
["Total Einnahmen",{"$f":"SUM(B5:B15)","v":0},0,0]
[]
["Ausgaben"]
[]
["Lebensunterhalt",null,{"$f":"B20*12","v":0},{"$f":"B20*24","v":0}]
["Mietkosten/ Heimkosten",null,{"$f":"B21*12","v":0},{"$f":"B21*24","v":0}]
["Übrige Wohnkosten",null,0,0]
["Ferien/Freizeit/Fahrzeuge",null,0,0]
["Prämien Krankenkasse",null,0,0]
["Krankheitskosten",null,0,0]
["Hilflosenentschädigung Dritte",null,0,0]
["AHV-Beiträge",null,0,0]
["Hausrat/Haftpflichtversicherung",null,0,0]
["Versicherungen",null,0,0]
["Bank-/Postspesen",null,0,0]
["Gebühren KESB",null,0,0]
["Steuern",null,0,0]
["Verschiedene Ausgaben",null,0,0]
["Anschaffungen",null,0,0]
["Kapitalverschiebungen",null,0,0]
["Total Ausgaben",{"$f":"SUM(B19:B35)","v":0},0,0]
[]
[{"$f":"IF(B16-B36<0,\"Ausgabenüberschuss\",\"Einnahmenüberschuss\")","v":"Einnahmenüberschuss"},{"$f":"B16-B36","v":0},{"$f":"C16-C36","v":0},{"$f":"D16-D36","v":0}]

{"sheet":"Definitionen","index":3,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Kategorien",null,"Min.Dat","2010-01-01",null,null,"Kontotypen Aktiven","VBVV Kat.",null,"Kontotypen Passiven","VBVV Kat.",null,"Optionen"]
["Aus: Lebensunterhalt",null,"MaxDat","2030-12-31",null,null,"Verkehrskonto",6,null,"Offene Rechnungen",6,null,"Ja"]
["Aus: Mietkosten/ Heimkosten",null,null,null,null,null,"Bank/Postkonto",6,null,"Konsumkredit",6,null,"Nein"]
["Aus: Übrige Wohnkosten",null,null,null,null,null,"Obligation bei Kantonalbank mit Staatsgarantie",6,null,"Privatkredit",6]
["Aus: Ferien/Freizeit/Fahrzeuge",null,null,null,null,null,"Obligation bei CH Bank ohne Staatsgarantie, max. 100'000 Fr.",6,null,"Hypothek",6]
["Aus: Prämien Krankenkasse",null,null,null,null,null,"Obligation CH Eidgenossenschaft",6]
["Aus: Krankheitskosten",null,null,null,null,null,"Obligation CH Pfandbriefzentralse",6]
["Aus: Hilflosenentschädigung Dritte",null,null,null,null,null,"Grundstücke / Liegenschaften",6]
["Aus: AHV-Beiträge",null,null,null,null,null,"Grundpfandgesicherte Forderung ",6]
["Aus: Hausrat/Haftpflichtversicherung",null,null,null,null,null,"CH Obligationen v. Gesellschaften m. guter Bonität",7.1]
["Aus: Versicherungen",null,null,null,null,null,"Aktien sFr v. Gesellschaften m. guter Bonität",7.1]
["Aus: Bank-/Postspesen",null,null,null,null,null,"Obligationenfonds CH v. Gesellschaften m. guter Bonität",7.1]
["Aus: Gebühren KESB",null,null,null,null,null,"Anlagefonds sFr max. 50% ausländische Titel",7.1]
["Aus: Steuern",null,null,null,null,null,"Lebensversicherungen",7.1]
["Aus: Verschiedene Ausgaben",null,null,null,null,null,"Obligationen andere",7.3]
["Aus: Anschaffungen",null,null,null,null,null,"Aktien andere",7.3]
["Aus: Kapitalverschiebungen",null,null,null,null,null,"Fonds andere",7.3]
["Ein: Lohn",null,null,null,null,null,"Devisen",7.3]
["Ein: AHV/IV Rente",null,null,null,null,null,"Darlehen",7.3]
["Ein: Ergänzungsleistungen EL",null,null,null,null,null,"Andere Anlagen",7.3]
["Ein: Hilflosenentschädigung HE"]
["Ein: Sozialhilfe WSH"]
["Ein: Prämienverbilligung"]
["Ein: Leistungen Krankenkasse"]
["Ein: Krankheits-/Behind.-kosten EL"]
["Ein: Zinsen/Dividenden"]
["Ein: Verschiedene Einnahmen"]
["Ein: Kapitalverschiebungen"]

{"sheet":"Vermögen VBVV","index":4,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Definitionen!G1","v":"Kontotypen Aktiven"},"VBVV Kat","Eröffnungssaldo","Schlussaldo","Veränderung"]
[{"$f":"Definitionen!G2","v":"Verkehrskonto"},{"$f":"Definitionen!H2","v":6},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A2)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A2)","v":{"$error":"#REF!"}},{"$f":"D2-C2","v":{"$error":"#REF!"}},null,null,"Aktiven"]
[{"$f":"Definitionen!G3","v":"Bank/Postkonto"},{"$f":"Definitionen!H3","v":6},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A3)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A3)","v":{"$error":"#REF!"}},{"$f":"D3-C3","v":{"$error":"#REF!"}},null,null,"VBVV Kat","Eröffnungssaldo","Schlusssaldo","Veränderung"]
[{"$f":"Definitionen!G4","v":"Obligation bei Kantonalbank mit Staatsgarantie"},{"$f":"Definitionen!H4","v":6},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A4)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A4)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,6,{"$f":"SUMIFS(C$2:C$20,B$2:B$20,$H4)","v":0},{"$f":"SUMIFS(D$2:D$20,B$2:B$20,$H4)","v":{"$error":"#REF!"}},{"$f":"J4-I4","v":{"$error":"#REF!"}}]
[{"$f":"Definitionen!G5","v":"Obligation bei CH Bank ohne Staatsgarantie, max. 100'000 Fr."},{"$f":"Definitionen!H5","v":6},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A5)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A5)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,7.1,{"$f":"SUMIFS(C$2:C$20,B$2:B$20,$H5)","v":0},{"$f":"SUMIFS(D$2:D$20,B$2:B$20,$H5)","v":{"$error":"#REF!"}},{"$f":"J5-I5","v":{"$error":"#REF!"}}]
[{"$f":"Definitionen!G6","v":"Obligation CH Eidgenossenschaft"},{"$f":"Definitionen!H6","v":6},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A6)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A6)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,7.3,{"$f":"SUMIFS(C$2:C$20,B$2:B$20,$H6)","v":0},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!G7","v":"Obligation CH Pfandbriefzentralse"},{"$f":"Definitionen!H7","v":6},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A7)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A7)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[{"$f":"Definitionen!G8","v":"Grundstücke / Liegenschaften"},{"$f":"Definitionen!H8","v":6},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A8)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A8)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,"Passiven"]
[{"$f":"Definitionen!G9","v":"Grundpfandgesicherte Forderung "},{"$f":"Definitionen!H9","v":6},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A9)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A9)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,"VBVV Kat","Eröffnungssaldo","Schlusssaldo","Veränderung"]
[{"$f":"Definitionen!G10","v":"CH Obligationen v. Gesellschaften m. guter Bonität"},{"$f":"Definitionen!H10","v":7.1},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A10)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A10)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,6,{"$f":"SUMIFS(C$23:C$26,B$23:B$26,$H10)","v":0},{"$f":"SUMIFS(D$23:D$26,B$23:B$26,$H10)","v":{"$error":"#REF!"}},{"$f":"J10-I10","v":{"$error":"#REF!"}}]
[{"$f":"Definitionen!G11","v":"Aktien sFr v. Gesellschaften m. guter Bonität"},{"$f":"Definitionen!H11","v":7.1},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A11)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A11)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,7.1,{"$f":"SUMIFS(C$23:C$26,B$23:B$26,$H11)","v":0},{"$f":"SUMIFS(D$23:D$26,B$23:B$26,$H11)","v":0},0]
[{"$f":"Definitionen!G12","v":"Obligationenfonds CH v. Gesellschaften m. guter Bonität"},{"$f":"Definitionen!H12","v":7.1},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A12)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,7.3,{"$f":"SUMIFS(C$23:C$26,B$23:B$26,$H12)","v":0},{"$f":"SUMIFS(D$23:D$26,B$23:B$26,$H12)","v":0},0]
[{"$f":"Definitionen!G13","v":"Anlagefonds sFr max. 50% ausländische Titel"},{"$f":"Definitionen!H13","v":7.1},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A13)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A13)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[{"$f":"Definitionen!G14","v":"Lebensversicherungen"},{"$f":"Definitionen!H14","v":7.1},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A14)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A14)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,"Total"]
[{"$f":"Definitionen!G15","v":"Obligationen andere"},{"$f":"Definitionen!H15","v":7.3},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A15)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A15)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,"VBVV Kat","Eröffnungssaldo","Schlusssaldo","Veränderung"]
[{"$f":"Definitionen!G16","v":"Aktien andere"},{"$f":"Definitionen!H16","v":7.3},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A16)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A16)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,6,{"$f":"I4-I10","v":0},{"$error":"#REF!"},{"$f":"J16-I16","v":{"$error":"#REF!"}}]
[{"$f":"Definitionen!G17","v":"Fonds andere"},{"$f":"Definitionen!H17","v":7.3},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A17)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,7.1,0,{"$error":"#REF!"},{"$f":"J17-I17","v":{"$error":"#REF!"}}]
[{"$f":"Definitionen!G18","v":"Devisen"},{"$f":"Definitionen!H18","v":7.3},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A18)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A18)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,7.3,0,{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!G19","v":"Darlehen"},{"$f":"Definitionen!H19","v":7.3},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A19)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A19)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[{"$f":"Definitionen!G20","v":"Andere Anlagen"},{"$f":"Definitionen!H20","v":7.3},{"$f":"SUMIFS(Inventar!D$10:D$21,Inventar!A$10:A$21,A20)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$10:A$21,A20)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[{"$f":"Definitionen!J1","v":"Kontotypen Passiven"}]
[{"$f":"Definitionen!J2","v":"Offene Rechnungen"},{"$f":"Definitionen!K2","v":6},{"$f":"SUMIFS(Inventar!D$26:D$37,Inventar!A$26:A$37,A23)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$26:A$37,B23)","v":{"$error":"#REF!"}},{"$f":"D23-C23","v":{"$error":"#REF!"}}]
[{"$f":"Definitionen!J3","v":"Konsumkredit"},{"$f":"Definitionen!K3","v":6},{"$f":"SUMIFS(Inventar!D$26:D$37,Inventar!A$26:A$37,A24)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$26:A$37,B24)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[{"$f":"Definitionen!J4","v":"Privatkredit"},{"$f":"Definitionen!K4","v":6},{"$f":"SUMIFS(Inventar!D$26:D$37,Inventar!A$26:A$37,A25)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$26:A$37,B25)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[{"$f":"Definitionen!J5","v":"Hypothek"},{"$f":"Definitionen!K5","v":6},{"$f":"SUMIFS(Inventar!D$26:D$37,Inventar!A$26:A$37,A26)","v":0},{"$f":"SUMIFS(Inventar!#REF!,Inventar!A$26:A$37,B26)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]