{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Vermögenswerte","Verbindlichkeiten","Berechnungen"],"not_rendered":{"charts":4,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":16,"n_cols":8,"rows_kept":16}
[]
[null,"DASHBOARD",{"$nulls":4},"ZUSAMMENFASSUNG DER VERMÖGENSWERTE"," "]
{"$rows_empty":8}
[null,{"$f":"Nettowert","v":{"v":159600,"d":"159,600.00 €"}},null,{"$f":"GesamteVermögenswerte","v":{"v":380800,"d":"380,800.00 €"}},null,null,{"$f":"GesamteVerbindlichkeiten","v":{"v":221200,"d":"221,200.00 €"}}]
[null,"NETTOWERT",null,"VERMÖGENSWERTE GESAMT",null,null,"VERBINDLICHKEITEN GESAMT"]
[{"$nulls":3},"BARVERMÖGEN",null,null,"UNGEDECKT"]
[{"$nulls":3},"ANLAGEWERTE",null,null,"GEDECKT"]
[{"$nulls":3},"ALTERSVORSORGE"]
[{"$nulls":3},"PRIVATVERMÖGEN"]

{"sheet":"Vermögenswerte","index":1,"n_rows":24,"n_cols":10,"rows_kept":24,"merged":[[11,1,12,1],[13,1,14,1],[14,2,14,4],[14,6,14,8],[25,2,25,4],[25,6,25,8]]}
[]
[null,"VERMÖGENSWERTE",{"$nulls":5},"ZUSAMMENFASSUNG DER VERMÖGENSWERTE",null," "]
[]
[null,null," ","BARVERMÖGEN","WERT",null," ","PRIVATVERMÖGEN","WERT"]
[{"$nulls":3},"HANDKASSE",{"v":2000,"d":"2,000"},null,null,"HAUPTWOHNSITZ",{"v":233000,"d":"233,000"}]
[{"$nulls":3},"GIROKONTEN",{"v":2500,"d":"2,500"},null,null,"ZWEITWOHNSITZ"]
[{"$nulls":3},"SPARKONTEN",{"v":4000,"d":"4,000"},null,null,"SAMMLERSTÜCKE"]
[{"$nulls":3},"GELDMARKTKONTEN",{"v":3300,"d":"3,300"},null,null,"KRAFTFAHRZEUGE",{"v":32000,"d":"32,000"}]
[{"$nulls":3},"GELDMARKTFONDS",{"v":7000,"d":"7,000"},null,null,"MÖBEL",{"v":10000,"d":"10,000"}]
[{"$nulls":3},"EINLAGENZERTIFIKATE",{"$nulls":3},"PELZE & SCHMUCK"]
[{"$nulls":3},"BUNDESSCHATZBRIEFE",{"$nulls":3},"WEITERE VERMÖGENSWERTE",{"v":1500,"d":"1,500"}]
[null,{"$f":"GesamteVermögenswerte","v":{"v":380800,"d":"380,800.00 €"}},null,"BARWERT VON LEBENSVERSICHERUNGEN",{"v":24500,"d":"24,500"}]
[{"$nulls":3},"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblBarvermögen[WERT])","v":{"v":43300,"d":"43,300"}},null,null,"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblPrivatvermögen[WERT])","v":{"v":276500,"d":"276,500"}}]
[null,"VERMÖGENSWERTE GESAMT"]
[]
[]
[null,null," ","ANLAGEWERTE","WERT",null," ","ALTERSVORSORGE","WERT"]
[{"$nulls":3},"AKTIEN",{"v":15000,"d":"15,000"},null,null,"PENSIONEN"]
[{"$nulls":3},"ANLEIHEN",{"$nulls":3},"RENTENKONTEN"]
[{"$nulls":3},"INVESTMENTFONDS",{"$nulls":3},"PRIVATE RENTENKONTEN"]
[{"$nulls":3},"KOMMANDITANTEILE",{"$nulls":3},"Riester-Rente",{"v":46000,"d":"46,000"}]
[{"$nulls":3},"WEITERE ANLAGEWERTE",{"$nulls":3},"SEP"]
[{"$nulls":7},"Mitarbeiterbeteiligungsprogramm"]
[{"$nulls":3},"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblInvestitionen[WERT])","v":{"v":15000,"d":"15,000"}},null,null,"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblAltersvorsorge[WERT])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"Verbindlichkeiten","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"VERBINDLICHKEITEN",{"$nulls":5},"ZUSAMMENFASSUNG DER VERMÖGENSWERTE",null," "]
[]
[null,null," ","UNGEDECKT","OWE",null," ","GEDECKT","SCHULDEN"]
[{"$nulls":3},"KREDITKARTEN",{"v":1200,"d":"1,200"},null,null,"KFZ-Darlehen",{"v":14500,"d":"14,500"}]
[{"$nulls":3},"KUNDENKREDITKONTEN",{"v":3000,"d":"3,000"},null,null,"Darlehen für Wohnmobil"]
[{"$nulls":3},"STUDIENDARLEHEN",{"v":17500,"d":"17,500"},null,null,"Darlehen für Haushaltsgeräte"]
[{"$nulls":3},"UNTERHALTSZAHLUNGEN",{"$nulls":3},"Hypothekendarlehen",{"v":144000,"d":"144,000"}]
[{"$nulls":3},"ALIMENTE",{"$nulls":3},"Eigenkapitalbasierte Darlehen aufs Eigenheim",{"v":21000,"d":"21,000"}]
[{"$nulls":3},"STEUERSCHULDEN",{"v":8000,"d":"8,000"},null,null,"Sonstige Darlehen"]
[{"$nulls":3},"SONSTIGES",{"v":6000,"d":"6,000"},null,null,"Steuerschulden",{"v":4000,"d":"4,000"}]
[null,{"$f":"GesamteVerbindlichkeiten","v":{"v":221200,"d":"221,200.00 €"}},{"$nulls":5},"Andere",{"v":2000,"d":"2,000"}]
[{"$nulls":3},"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblUngedeckt[OWE])","v":{"v":35700,"d":"35,700"}},null,null,"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblGedeckt[SCHULDEN])","v":{"v":185500,"d":"185,500"}}]
[null,"VERBINDLICHKEITEN GESAMT"]

{"sheet":"Berechnungen","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** Dieses Arbeitsblatt sollte ausgeblendet bleiben ***"]
{"$rows_empty":8}
[null,{"$f":"tblBarvermögen[[#Headers],[BARVERMÖGEN]]","v":"BARVERMÖGEN"},{"$f":"SUM(tblBarvermögen[WERT])","v":{"v":43300,"d":"43,300 €"}}]
[null,{"$f":"tblInvestitionen[[#Headers],[ANLAGEWERTE]]","v":"ANLAGEWERTE"},{"$f":"SUM(tblInvestitionen[WERT])","v":{"v":15000,"d":"15,000 €"}}]
[null,{"$f":"tblAltersvorsorge[[#Headers],[ALTERSVORSORGE]]","v":"ALTERSVORSORGE"},{"$f":"SUM(tblAltersvorsorge[WERT])","v":{"v":46000,"d":"46,000 €"}}]
[null,{"$f":"tblPrivatvermögen[[#Headers],[PRIVATVERMÖGEN]]","v":"PRIVATVERMÖGEN"},{"$f":"SUM(tblPrivatvermögen[])","v":{"v":276500,"d":"276,500 €"}}]
[null,"Vermögenswerte gesamt",{"$f":"SUM(tblBarvermögen[WERT],tblInvestitionen[WERT],tblAltersvorsorge[WERT],tblPrivatvermögen[WERT])","v":{"v":380800,"d":"380,800 €"}}]
[]
[]
[null,{"$f":"tblUngedeckt[[#Headers],[UNGEDECKT]]","v":"UNGEDECKT"},{"$f":"SUM(tblUngedeckt[OWE])","v":{"v":35700,"d":"35,700 €"}}]
[null,{"$f":"tblGedeckt[[#Headers],[GEDECKT]]","v":"GEDECKT"},{"$f":"SUM(tblGedeckt[SCHULDEN])","v":{"v":185500,"d":"185,500 €"}}]
[null,"Verbindlichkeiten gesamt",{"$f":"SUM(tblUngedeckt[OWE],tblGedeckt[SCHULDEN])","v":{"v":221200,"d":"221,200 €"}}]
[]
[]
[null,"Nettowert",{"$f":"C15-C20","v":{"v":159600,"d":"159,600 €"}}]