{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Persoonlijke nettowaarde","Activa","Schuld"],"not_rendered":{"charts":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Persoonlijke nettowaarde","index":0,"n_rows":19,"n_cols":21,"rows_kept":19,"merged":[[0,2,0,9],[2,2,2,4],[3,2,3,4],[8,2,8,4]]}
[{"$nulls":12},"Contanten en contantequivalent",{"$f":"SUMIF(TBL_Assets[Categorie],'Persoonlijke nettowaarde'!M1,TBL_Assets[Waarde])+ROW(M1)/10000","v":42500.0001},{"$f":"_xlfn.RANK.EQ(N1,$N$1:$N$5,0)","v":5},null,{"$f":"INDEX($M$1:$N$5,MATCH(5,$O$1:$O$5,0),1)","v":"Contanten en contantequivalent"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(5,$O$1:$O$5,0),2),2)","v":42500},null,"Totale activa",{"$f":"SUM(TBL_Assets[Waarde])","v":1923500}]
[{"$nulls":12},"Eigenschappen",{"$f":"SUMIF(TBL_Assets[Categorie],'Persoonlijke nettowaarde'!M2,TBL_Assets[Waarde])+ROW(M2)/10000","v":1205000.0002},{"$f":"_xlfn.RANK.EQ(N2,$N$1:$N$5,0)","v":1},null,{"$f":"INDEX($M$1:$N$5,MATCH(4,$O$1:$O$5,0),1)","v":"Pensioenspaargeld"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(4,$O$1:$O$5,0),2),2)","v":98000},null,"Totale schulden",{"$f":"SUM(TBL_Debts[Waarde])","v":652500}]
[null,null,"PERSOONLIJKE NETTOWAARDE",{"$nulls":3},"ACTIVA TEGENOVER SCHULDEN",{"$nulls":5},"Investeringen",{"$f":"SUMIF(TBL_Assets[Categorie],'Persoonlijke nettowaarde'!M3,TBL_Assets[Waarde])+ROW(M3)/10000","v":475000.0003},{"$f":"_xlfn.RANK.EQ(N3,$N$1:$N$5,0)","v":2},null,{"$f":"INDEX($M$1:$N$5,MATCH(3,$O$1:$O$5,0),1)","v":"Levensverzekeringen"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(3,$O$1:$O$5,0),2),2)","v":103000}]
[null,null,{"$f":"E5-E7","v":{"v":1271000,"d":"€ 1,271,000"}},{"$nulls":9},"Pensioenspaargeld",{"$f":"SUMIF(TBL_Assets[Categorie],'Persoonlijke nettowaarde'!M4,TBL_Assets[Waarde])+ROW(M4)/10000","v":98000.0004},{"$f":"_xlfn.RANK.EQ(N4,$N$1:$N$5,0)","v":4},null,{"$f":"INDEX($M$1:$N$5,MATCH(2,$O$1:$O$5,0),1)","v":"Investeringen"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(2,$O$1:$O$5,0),2),2)","v":475000}]
[{"$nulls":3},"Totaal activa",{"$f":"SUM(TBL_Assets[Waarde])","v":{"v":1923500,"d":"€ 1,923,500 "}},{"$nulls":7},"Levensverzekeringen",{"$f":"SUMIF(TBL_Assets[Categorie],'Persoonlijke nettowaarde'!M5,TBL_Assets[Waarde])+ROW(M5)/10000","v":103000.0005},{"$f":"_xlfn.RANK.EQ(N5,$N$1:$N$5,0)","v":3},null,{"$f":"INDEX($M$1:$N$5,MATCH(1,$O$1:$O$5,0),1)","v":"Eigenschappen"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(1,$O$1:$O$5,0),2),2)","v":1205000}]
[]
[{"$nulls":3},"Totale schulden",{"$f":"SUM(TBL_Debts[Waarde])","v":{"v":652500,"d":"€ 652,500 "}}]
[]
[null,null,"ASSETOVERZICHT"]
[]
[{"$nulls":7},{"$f":"Q5","v":"Eigenschappen"},{"$f":"R5","v":{"v":1205000,"d":"€ 1,205,000 "}}]
[]
[{"$nulls":7},{"$f":"Q4","v":"Investeringen"},{"$f":"R4","v":{"v":475000,"d":"€ 475,000 "}}]
[]
[{"$nulls":7},{"$f":"Q3","v":"Levensverzekeringen"},{"$f":"R3","v":{"v":103000,"d":"€ 103,000 "}}]
[]
[{"$nulls":7},{"$f":"Q2","v":"Pensioenspaargeld"},{"$f":"R2","v":{"v":98000,"d":"€ 98,000 "}}]
[]
[{"$nulls":7},{"$f":"Q1","v":"Contanten en contantequivalent"},{"$f":"R1","v":{"v":42500,"d":"€ 42,500 "}}]

{"sheet":"Activa","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[1,1,1,3]]}
[{"$nulls":4}," "]
[null,"ACTIVA"]
[null,"Categorie","Item","Waarde"]
[null,"Eigenschappen","Start",{"v":560000,"d":"€ 560,000.00"}]
[null,"Eigenschappen","Overig",{"v":255000,"d":"€ 255,000.00"}]
[null,"Pensioenspaargeld","Pensioenrekeningen",{"v":98000,"d":"€ 98,000.00"}]
[null,"Investeringen","Aandelen",{"v":53000,"d":"€ 53,000.00"}]
[null,"Investeringen","Obligaties",{"v":25000,"d":"€ 25,000.00"}]
[null,"Investeringen","Beleggingsfondsen",{"v":33000,"d":"€ 33,000.00"}]
[null,"Investeringen","Cd's",{"v":74000,"d":"€ 74,000.00"}]
[null,"Investeringen","Ongemunt goud",{"v":20000,"d":"€ 20,000.00"}]
[null,"Investeringen","Beheerde fondsen",{"v":250000,"d":"€ 250,000.00"}]
[null,"Levensverzekeringen","Zorgspaarrekening",{"v":18000,"d":"€ 18,000.00"}]
[null,"Levensverzekeringen","Nominale waarde van levensverzekeringspolis",{"v":85000,"d":"€ 85,000.00"}]
[null,"Investeringen","Overig",{"v":20000,"d":"€ 20,000.00"}]
[null,"Contanten en contantequivalent","Betaalrekeningen",{"v":35500,"d":"€ 35,500.00"}]
[null,"Contanten en contantequivalent","Spaarrekeningen",{"v":5000,"d":"€ 5,000.00"}]
[null,"Contanten en contantequivalent","Overig",{"v":2000,"d":"€ 2,000.00"}]
[null,"Eigenschappen","Auto's",{"v":55000,"d":"€ 55,000.00"}]
[null,"Eigenschappen","Overige voertuigen",{"v":85000,"d":"€ 85,000.00"}]
[null,"Eigenschappen","Meubilair",{"v":100000,"d":"€ 100,000.00"}]
[null,"Eigenschappen","Verzamelobjecten",{"v":50000,"d":"€ 50,000.00"}]
[null,"Eigenschappen","Sieraden",{"v":60000,"d":"€ 60,000.00"}]
[null,"Eigenschappen","Overige luxe goederen",{"v":40000,"d":"€ 40,000.00"}]

{"sheet":"Schuld","index":2,"n_rows":13,"n_cols":4,"rows_kept":13}
[{"$nulls":3}," "]
[null,"SCHULD"]
[null,"Categorie","Waarde"]
[null,"Hypotheken",{"v":400000,"d":"€ 400,000.00"}]
[null,"Tweede hypotheken",{"v":50000,"d":"€ 50,000.00"}]
[null,"Autoleningen",{"v":30000,"d":"€ 30,000.00"}]
[null,"Persoonlijke leningen",{"v":12500,"d":"€ 12,500.00"}]
[null,"Creditcards",{"v":65000,"d":"€ 65,000.00"}]
[null,"Studieleningen",{"v":10000,"d":"€ 10,000.00"}]
[null,"Investeringsleningen",{"v":20000,"d":"€ 20,000.00"}]
[null,"Levensverzekeringsleningen",{"v":5000,"d":"€ 5,000.00"}]
[null,"Leningen op basis van afbetalingen",{"v":10000,"d":"€ 10,000.00"}]
[null,"Overige schulden",{"v":50000,"d":"€ 50,000.00"}]