{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Übersicht","Guthaben","Verbindlichkeiten","Berechnungen"],"not_rendered":{"charts":4,"images":6,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Übersicht","index":0,"n_rows":18,"n_cols":8,"rows_kept":18}
[]
[null,"ÜBERSICHT",{"$nulls":4},"EIGENKAPITALÜBERSICHT"," "]
{"$rows_empty":8}
[null,{"$f":"EigenKapital","v":{"v":166600,"d":"166,600 €"}},null,{"$f":"GuthabenGesamt","v":{"v":387800,"d":"387,800 €"}},null,null,{"$f":"VerbindlichkeitenGesamt","v":{"v":221200,"d":"221,200 €"}}]
[null,"EIGENKAPITAL",null,"GUTHABEN GESAMT",null,null,"VERBINDLICHKEITEN GESAMT"]
[{"$nulls":3}," BARGELD",null,null," UNGESICHERT"]
[{"$nulls":3}," INVESTITIONEN",null,null," GESICHERT"]
[{"$nulls":3}," ALTERSVORSORGE"]
[{"$nulls":3}," PRIVAT"]
[]
[{"$nulls":3},"GUTHABEN ANZEIGEN >",null,null,"VERBINDLICHKEITEN ANZEIGEN >"]

{"sheet":"Guthaben","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"GUTHABEN",{"$nulls":6},"EIGENKAPITALÜBERSICHT",null," "]
[]
[{"$nulls":3}," ","BARGELD","WERT",null," ","PRIVAT","WERT"]
[{"$nulls":4},"VORHANDENES BARGELD",{"v":2000,"d":"2,000"},null,null,"HAUPTWOHNSITZ",{"v":233000,"d":"233,000"}]
[{"$nulls":4},"GIROKONTEN",{"v":2500,"d":"2,500"},null,null,"ZWEITWOHNSITZ"]
[{"$nulls":4},"SPARKONTEN",{"v":4000,"d":"4,000"},null,null,"SAMMLUNGEN"]
[{"$nulls":4},"GELDMARKTKONTEN",{"v":3300,"d":"3,300"},null,null,"FAHRZWEUGE",{"v":32000,"d":"32,000"}]
[{"$nulls":4},"DEPOSITENKONTEN",{"v":14000,"d":"14,000"},null,null,"MÖBEL",{"v":10000,"d":"10,000"}]
[{"$nulls":4},"USA SCHATZBRIEFE",{"$nulls":3},"PELZE UND SCHMUCK"]
[{"$nulls":4},"BARWERT DER LEBENSVERSICHERUNG",{"v":24500,"d":"24,500"},null,null,"SONSTIGE GUTHABEN 1",{"v":1500,"d":"1,500"}]
[null,{"$f":"GuthabenGesamt","v":{"v":387800,"d":"387,800 €"}},null,null,"ANDERE BARWERTE",{"$nulls":3},"SONSTIGE GUTHABEN 2"]
[{"$nulls":4},"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblCash[WERT])","v":{"v":50300,"d":"50,300"}},null,null,"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblPersonal[WERT])","v":{"v":276500,"d":"276,500"}}]
[null,"GUTHABEN GESAMT"]
[]
[{"$nulls":3}," ","INVESTITIONEN","WERT",null," ","ALTERSVORSORGE","WERT"]
[null,"VERBINDLICHKEITEN ANZEIGEN >",null,null,"AKTIEN",{"v":15000,"d":"15,000"},null,null,"PENSION"]
[null,"< DASHBOARD ANZEIGEN",null,null,"OBLIGATIONEN",{"$nulls":3},"IRA-KONTEN"]
[{"$nulls":4},"INVESTMENTFONDBETEILIGUNGEN",{"$nulls":3},"KEOGH-KONTEN"]
[{"$nulls":4},"BETEILIGUNGEN",{"$nulls":3},"401K",{"v":46000,"d":"46,000"}]
[{"$nulls":4},"ANDERE INVESTITIONEN 1",{"$nulls":3},"SEP"]
[{"$nulls":4},"ANDERE INVESTITIONEN 2",{"$nulls":3},"WEITERE ALTERSVORSORGEN"]
[{"$nulls":4},"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblInvestments[WERT])","v":{"v":15000,"d":"15,000"}},null,null,"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblRetirement[WERT])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"Verbindlichkeiten","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"VERBINDLICHKEITEN",{"$nulls":6},"EIGENKAPITALÜBERSICHT",null," "]
[]
[{"$nulls":3}," ","UNGESICHERT","SCHULDEN",null," ","GESICHERT","SCHULDEN"]
[{"$nulls":4},"KREDITKARTEN",{"v":1200,"d":"1,200"},null,null,"AUTOKREDITE",{"v":14500,"d":"14,500"}]
[{"$nulls":4},"KREDITKONTEN",{"v":3000,"d":"3,000"},null,null,"GEBRAUCHTWAGENKREDITE"]
[{"$nulls":4},"STUDIENKREDITE",{"v":17500,"d":"17,500"},null,null,"KREDITE FÜR HAUSHALTSGERÄTE"]
[{"$nulls":4},"ALIMENTE",{"$nulls":3},"HYPOTHEKENDARLEHN",{"v":144000,"d":"144,000"}]
[{"$nulls":4},"KINDERVORSORGE",{"$nulls":3},"IMMOBILIENKREDITE",{"v":21000,"d":"21,000"}]
[{"$nulls":4},"STEUERSCHULDEN",{"v":8000,"d":"8,000"},null,null,"STEUERSCHULDEN"]
[{"$nulls":4},"UNGESICHERT ANDERE 1",{"v":6000,"d":"6,000"},null,null,"GESICHERT ANDERE 1",{"v":4000,"d":"4,000"}]
[null,{"$f":"VerbindlichkeitenGesamt","v":{"v":221200,"d":"221,200 €"}},null,null,"UNGESICHERT ANDERE 2",{"$nulls":3},"GESICHERT ANDERE 2",{"v":2000,"d":"2,000"}]
[{"$nulls":4},"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblUnsecured[SCHULDEN])","v":{"v":35700,"d":"35,700"}},null,null,"ZWISCHENSUMME",{"$f":"SUBTOTAL(109,tblSecured[SCHULDEN])","v":{"v":185500,"d":"185,500"}}]
[null,"VERBINDLICHKEITEN GESAMT"]
[]
[]
[null,"< GUTHABEN ANZEIGEN"]
[null,"< DASHBOARD ANZEIGEN"]

{"sheet":"Berechnungen","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** Dieses Blatt sollte nicht angezeigt werden ***"]
{"$rows_empty":8}
[null,{"$f":"tblCash[[#Headers],[BARGELD]]","v":"BARGELD"},{"$f":"SUM(tblCash[WERT])","v":{"v":50300,"d":"50,300 €"}}]
[null,{"$f":"tblInvestments[[#Headers],[INVESTITIONEN]]","v":"INVESTITIONEN"},{"$f":"SUM(tblInvestments[WERT])","v":{"v":15000,"d":"15,000 €"}}]
[null,{"$f":"tblRetirement[[#Headers],[ALTERSVORSORGE]]","v":"ALTERSVORSORGE"},{"$f":"SUM(tblRetirement[WERT])","v":{"v":46000,"d":"46,000 €"}}]
[null,{"$f":"tblPersonal[[#Headers],[PRIVAT]]","v":"PRIVAT"},{"$f":"SUM(tblPersonal[WERT])","v":{"v":276500,"d":"276,500 €"}}]
[null,"Guthaben gesamt",{"$f":"SUM(tblCash[WERT],tblInvestments[WERT],tblRetirement[WERT],tblPersonal[WERT])","v":{"v":387800,"d":"387,800 €"}}]
[]
[]
[null,{"$f":"tblUnsecured[[#Headers],[UNGESICHERT]]","v":"UNGESICHERT"},{"$f":"SUM(tblUnsecured[SCHULDEN])","v":{"v":35700,"d":"35,700 €"}}]
[null,{"$f":"tblSecured[[#Headers],[GESICHERT]]","v":"GESICHERT"},{"$f":"SUM(tblSecured[SCHULDEN])","v":{"v":185500,"d":"185,500 €"}}]
[null,"Verbindlichkeiten gesamt",{"$f":"SUM(tblUnsecured[SCHULDEN],tblSecured[SCHULDEN])","v":{"v":221200,"d":"221,200 €"}}]
[]
[]
[null,"Eigenkapital",{"$f":"C15-C20","v":{"v":166600,"d":"166,600 €"}}]