{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Activa","Passiva","berekeningen "],"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},"OVERZICHT NETTOWAARDE"," "]
{"$rows_empty":8}
[null,{"$f":"Nettowaarde","v":{"v":159600,"d":"€ 159,600"}},null,{"$f":"TotaalActiva","v":{"v":380800,"d":"€ 380,800"}},null,null,{"$f":"TotaalPassiva","v":{"v":221200,"d":"€ 221,200"}}]
[null,"NETTOWAARDE",null,"TOTALE ACTIVA",null,null,"TOTALE PASSIVA"]
[{"$nulls":3},"CONTANTEN",null,null,"ONGEDEKT"]
[{"$nulls":3},"INVESTERINGEN",null,null,"GEDEKT"]
[{"$nulls":3},"PENSIOEN"]
[{"$nulls":3},"PERSOONLIJK"]

{"sheet":"Activa","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,"ACTIVA",{"$nulls":5},"OVERZICHT NETTOWAARDE",null," "]
[]
[null,null," ","CONTANTEN","WAARDE",null," ","PERSOONLIJK","WAARDE"]
[{"$nulls":3},"CONTANT GELD",{"v":2000,"d":"2,000"},null,null,"HOOFDWONING",{"v":233000,"d":"233,000"}]
[{"$nulls":3},"LOPENDE REKENINGEN",{"v":2500,"d":"2,500"},null,null,"TWEEDE WONING"]
[{"$nulls":3},"SPAARREKENINGEN",{"v":4000,"d":"4,000"},null,null,"VERZAMELINGEN"]
[{"$nulls":3},"GELDMARKTREKENINGEN",{"v":3300,"d":"3,300"},null,null,"AUTO'S",{"v":32000,"d":"32,000"}]
[{"$nulls":3},"GELDMARKTFONDSREKENINGEN",{"v":7000,"d":"7,000"},null,null,"MEUBILAIR",{"v":10000,"d":"10,000"}]
[{"$nulls":3},"DEPOSITOBEWIJZEN",{"$nulls":3},"BONT EN JUWELEN"]
[{"$nulls":3},"SCHATKISTPROMESSES",{"$nulls":3},"OVERIGE ACTIVA",{"v":1500,"d":"1,500"}]
[null,{"$f":"TotaalActiva","v":{"v":380800,"d":"€ 380,800"}},null,"GELDWAARDE VAN LEVENSVERZEKERING",{"v":24500,"d":"24,500"}]
[{"$nulls":3},"SUBTOTAAL",{"$f":"SUBTOTAL(109,tblContanten[WAARDE])","v":{"v":43300,"d":"43,300"}},null,null,"SUBTOTAAL",{"$f":"SUBTOTAL(109,tblPersoonlijk[WAARDE])","v":{"v":276500,"d":"276,500"}}]
[null,"TOTALE ACTIVA"]
[]
[]
[null,null," ","INVESTERINGEN","WAARDE",null," ","PENSIOEN","WAARDE"]
[{"$nulls":3},"AANDELEN",{"v":15000,"d":"15,000"},null,null,"PENSIOEN"]
[{"$nulls":3},"OBLIGATIES",{"$nulls":3},"PENSIOENREKENINGEN"]
[{"$nulls":3},"INVESTERINGEN VIA BELEGGINGSMAATSCHAPPIJEN",{"$nulls":3},"LIJFRENTES"]
[{"$nulls":3},"BELANGEN IN VENNOOTSCHAP",{"$nulls":3},"Pensioenrekening",{"v":46000,"d":"46,000"}]
[{"$nulls":3},"OVERIGE INVESTERINGEN",{"$nulls":3},"Individueel pensioen"]
[{"$nulls":7},"Werknemersaandelen"]
[{"$nulls":3},"SUBTOTAAL",{"$f":"SUBTOTAL(109,tblBeleggingen[WAARDE])","v":{"v":15000,"d":"15,000"}},null,null,"SUBTOTAAL",{"$f":"SUBTOTAL(109,tblPensioen[WAARDE])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"Passiva","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"PASSIVA",{"$nulls":5},"OVERZICHT NETTOWAARDE",null," "]
[]
[null,null," ","ONGEDEKT","SCHULDEN",null," ","GEDEKT","SCHULDEN"]
[{"$nulls":3},"CREDITCARDS",{"v":1200,"d":"1,200"},null,null,"Autoleningen",{"v":14500,"d":"14,500"}]
[{"$nulls":3},"BETAALREKENINGEN",{"v":3000,"d":"3,000"},null,null,"Leningen voor recr. voertuigen"]
[{"$nulls":3},"STUDIELENINGEN",{"v":17500,"d":"17,500"},null,null,"Persoonlijke leningen"]
[{"$nulls":3},"ALIMENTATIE",{"$nulls":3},"Hypotheken",{"v":144000,"d":"144,000"}]
[{"$nulls":3},"ALIMENTATIE VOOR KINDEREN",{"$nulls":3},"Doorlopende kredieten",{"v":21000,"d":"21,000"}]
[{"$nulls":3},"BELASTINGSCHULDEN",{"v":8000,"d":"8,000"},null,null,"Overige leningen"]
[{"$nulls":3},"OVERIGE",{"v":6000,"d":"6,000"},null,null,"Belastingschulden",{"v":4000,"d":"4,000"}]
[null,{"$f":"TotaalPassiva","v":{"v":221200,"d":"€ 221,200"}},{"$nulls":5},"Overige",{"v":2000,"d":"2,000"}]
[{"$nulls":3},"SUBTOTAAL",{"$f":"SUBTOTAL(109,tblOngedekt[SCHULDEN])","v":{"v":35700,"d":"35,700"}},null,null,"SUBTOTAAL",{"$f":"SUBTOTAL(109,tblGedekt[SCHULDEN])","v":{"v":185500,"d":"185,500"}}]
[null,"TOTALE ACTIVA"]

{"sheet":"berekeningen ","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** Dit blad moet verborgen blijven ***"]
{"$rows_empty":8}
[null,{"$f":"tblContanten[[#Headers],[CONTANTEN]]","v":"CONTANTEN"},{"$f":"SUM(tblContanten[WAARDE])","v":{"v":43300,"d":"€ 43,300"}}]
[null,{"$f":"tblBeleggingen[[#Headers],[INVESTERINGEN]]","v":"INVESTERINGEN"},{"$f":"SUM(tblBeleggingen[WAARDE])","v":{"v":15000,"d":"€ 15,000"}}]
[null,{"$f":"tblPensioen[[#Headers],[PENSIOEN]]","v":"PENSIOEN"},{"$f":"SUM(tblPensioen[WAARDE])","v":{"v":46000,"d":"€ 46,000"}}]
[null,{"$f":"tblPersoonlijk[[#Headers],[PERSOONLIJK]]","v":"PERSOONLIJK"},{"$f":"SUM(tblPersoonlijk[WAARDE])","v":{"v":276500,"d":"€ 276,500"}}]
[null,"Totale activa",{"$f":"SUM(tblContanten[WAARDE],tblBeleggingen[WAARDE],tblPensioen[WAARDE],tblPersoonlijk[WAARDE])","v":{"v":380800,"d":"€ 380,800"}}]
[]
[]
[null,{"$f":"tblOngedekt[[#Headers],[ONGEDEKT]]","v":"ONGEDEKT"},{"$f":"SUM(tblOngedekt[SCHULDEN])","v":{"v":35700,"d":"€ 35,700"}}]
[null,{"$f":"tblGedekt[[#Headers],[GEDEKT]]","v":"GEDEKT"},{"$f":"SUM(tblGedekt[SCHULDEN])","v":{"v":185500,"d":"€ 185,500"}}]
[null,"Totale passiva",{"$f":"SUM(tblOngedekt[SCHULDEN],tblGedekt[SCHULDEN])","v":{"v":221200,"d":"€ 221,200"}}]
[]
[]
[null,"Nettowaarde",{"$f":"C15-C20","v":{"v":159600,"d":"€ 159,600"}}]