{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Kekayaan Bersih Pribadi","Aset","Utang"],"not_rendered":{"charts":2,"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Kekayaan Bersih Pribadi","index":0,"n_rows":21,"n_cols":25,"rows_kept":21,"merged":[[3,2,4,7]]}
[{"$nulls":14}," "]
[{"$nulls":16},"Kas dan Setara Kas",{"$f":"SUMIF(TBL_Assets[Kategori],'Kekayaan Bersih Pribadi'!Q2,TBL_Assets[Nilai])+ROW(Q2)/10000","v":42500.0002},{"$f":"_xlfn.RANK.EQ(R2,$R$2:$R$6,0)","v":5},null,{"$f":"INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),1)","v":"Kas dan Setara Kas"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),2),2)","v":42500},null,"Total Aset",{"$f":"SUM(TBL_Assets[Nilai])","v":1923500}]
[null,null," KEKAYAAN BERSIH PRIBADI",{"$nulls":13},"Properti",{"$f":"SUMIF(TBL_Assets[Kategori],'Kekayaan Bersih Pribadi'!Q3,TBL_Assets[Nilai])+ROW(Q3)/10000","v":1205000.0003},{"$f":"_xlfn.RANK.EQ(R3,$R$2:$R$6,0)","v":1},null,{"$f":"INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),1)","v":"Tabungan Pensiun"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),2),2)","v":98000},null,"Total Utang",{"$f":"SUM(TBL_Debts[Nilai])","v":652500}]
[null,null,{"$f":"F6-F8","v":{"v":1271000,"d":"Rp1,271,000"}},{"$nulls":6},"ASET vs UTANG",{"$nulls":6},"Investasi",{"$f":"SUMIF(TBL_Assets[Kategori],'Kekayaan Bersih Pribadi'!Q4,TBL_Assets[Nilai])+ROW(Q4)/10000","v":475000.0004},{"$f":"_xlfn.RANK.EQ(R4,$R$2:$R$6,0)","v":2},null,{"$f":"INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),1)","v":"Asuransi Jiwa"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),2),2)","v":103000}]
[{"$nulls":16},"Tabungan Pensiun",{"$f":"SUMIF(TBL_Assets[Kategori],'Kekayaan Bersih Pribadi'!Q5,TBL_Assets[Nilai])+ROW(Q5)/10000","v":98000.0005},{"$f":"_xlfn.RANK.EQ(R5,$R$2:$R$6,0)","v":4},null,{"$f":"INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),1)","v":"Investasi"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),2),2)","v":475000}]
[{"$nulls":4},"Total Aset",{"$f":"SUM(TBL_Assets[Nilai])","v":{"v":1923500,"d":"Rp1,923,500"}},{"$nulls":10},"Asuransi Jiwa",{"$f":"SUMIF(TBL_Assets[Kategori],'Kekayaan Bersih Pribadi'!Q6,TBL_Assets[Nilai])+ROW(Q6)/10000","v":103000.0006},{"$f":"_xlfn.RANK.EQ(R6,$R$2:$R$6,0)","v":3},null,{"$f":"INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),1)","v":"Properti"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),2),2)","v":1205000}]
[]
[{"$nulls":4},"Total Utang",{"$f":"SUM(TBL_Debts[Nilai])","v":{"v":652500,"d":"Rp652,500"}}]
[]
[]
[]
[{"$nulls":3},"RINGKASAN ASET"]
[{"$nulls":10},{"$f":"U6","v":"Properti"},{"$f":"V6","v":{"v":1205000,"d":"Rp1,205,000"}}]
[]
[{"$nulls":10},{"$f":"U5","v":"Investasi"},{"$f":"V5","v":{"v":475000,"d":"Rp475,000"}}]
[]
[{"$nulls":10},{"$f":"U4","v":"Asuransi Jiwa"},{"$f":"V4","v":{"v":103000,"d":"Rp103,000"}}]
[]
[{"$nulls":10},{"$f":"U3","v":"Tabungan Pensiun"},{"$f":"V3","v":{"v":98000,"d":"Rp98,000"}}]
[]
[{"$nulls":10},{"$f":"U2","v":"Kas dan Setara Kas"},{"$f":"V2","v":{"v":42500,"d":"Rp42,500"}}]

{"sheet":"Aset","index":1,"n_rows":25,"n_cols":5,"rows_kept":25}
[{"$nulls":4}," "]
[null,"ASET"]
[]
[null,"Kategori","Item","Nilai"]
[null,"Properti","Rumah",{"v":560000,"d":"Rp560,000.00"}]
[null,"Properti","Lainnya",{"v":255000,"d":"Rp255,000.00"}]
[null,"Tabungan Pensiun","Rekening pensiun",{"v":98000,"d":"Rp98,000.00"}]
[null,"Investasi","Saham",{"v":53000,"d":"Rp53,000.00"}]
[null,"Investasi","Obligasi",{"v":25000,"d":"Rp25,000.00"}]
[null,"Investasi","Reksadana",{"v":33000,"d":"Rp33,000.00"}]
[null,"Investasi","CD",{"v":74000,"d":"Rp74,000.00"}]
[null,"Investasi","Emas/perak batangan",{"v":20000,"d":"Rp20,000.00"}]
[null,"Investasi","Dana amanah",{"v":250000,"d":"Rp250,000.00"}]
[null,"Asuransi Jiwa","Rekening tabungan kesehatan",{"v":18000,"d":"Rp18,000.00"}]
[null,"Asuransi Jiwa","Nilai nominal polis asuransi jiwa",{"v":85000,"d":"Rp85,000.00"}]
[null,"Investasi","Lainnya",{"v":20000,"d":"Rp20,000.00"}]
[null,"Kas dan Setara Kas","Rekening giro",{"v":35500,"d":"Rp35,500.00"}]
[null,"Kas dan Setara Kas","Rekening tabungan",{"v":5000,"d":"Rp5,000.00"}]
[null,"Kas dan Setara Kas","Lainnya",{"v":2000,"d":"Rp2,000.00"}]
[null,"Properti","Mobil",{"v":55000,"d":"Rp55,000.00"}]
[null,"Properti","Kendaraan lainnya",{"v":85000,"d":"Rp85,000.00"}]
[null,"Properti","Perabotan",{"v":100000,"d":"Rp100,000.00"}]
[null,"Properti","Koleksi",{"v":50000,"d":"Rp50,000.00"}]
[null,"Properti","Perhiasan",{"v":60000,"d":"Rp60,000.00"}]
[null,"Properti","Barang mewah lainnya",{"v":40000,"d":"Rp40,000.00"}]

{"sheet":"Utang","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[{"$nulls":3}," "]
[null,"UTANG"]
[]
[null,"Kategori","Nilai"]
[null,"Hipotek",{"v":400000,"d":"Rp400,000.00"}]
[null,"Pinjaman ekuitas rumah",{"v":50000,"d":"Rp50,000.00"}]
[null,"Pinjaman mobil",{"v":30000,"d":"Rp30,000.00"}]
[null,"Pinjaman pribadi",{"v":12500,"d":"Rp12,500.00"}]
[null,"Kartu kredit",{"v":65000,"d":"Rp65,000.00"}]
[null,"Pinjaman kuliah",{"v":10000,"d":"Rp10,000.00"}]
[null,"Pinjaman untuk investasi",{"v":20000,"d":"Rp20,000.00"}]
[null,"Pinjaman asuransi jiwa",{"v":5000,"d":"Rp5,000.00"}]
[null,"Pinjaman pemasangan lainnya",{"v":10000,"d":"Rp10,000.00"}]
[null,"Utang lain",{"v":50000,"d":"Rp50,000.00"}]