{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Dasbor","Aset","Kewajiban","penghitungan"],"not_rendered":{"charts":4,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Dasbor","index":0,"n_rows":16,"n_cols":8,"rows_kept":16}
[]
[null,"DASBOR",{"$nulls":4},"KEKAYAAN BERSIH"," "]
{"$rows_empty":8}
[null,{"$f":"NetWorth","v":{"v":159600,"d":"Rp159,600"}},null,{"$f":"TotalAssets","v":{"v":380800,"d":"Rp380,800"}},null,null,{"$f":"TotalLiabilites","v":{"v":221200,"d":"Rp221,200"}}]
[null,"KEKAYAAN BERSIH",null,"TOTAL ASET",null,null,"TOTAL KEWAJIBAN"]
[{"$nulls":3},"KAS",null,null,"TIDAK TERJAMIN"]
[{"$nulls":3},"INVESTASI",null,null,"TERJAMIN"]
[{"$nulls":3},"PENSIUN"]
[{"$nulls":3},"PRIBADI"]

{"sheet":"Aset","index":1,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[11,1,12,1],[13,1,14,1],[13,2,13,4],[13,6,13,8],[23,2,23,4],[23,6,23,8]]}
[]
[null,"ASET",{"$nulls":5},"KEKAYAAN BERSIH",null," "]
[]
[null,null," ","KAS","NILAI",null," ","PRIBADI","NILAI"]
[{"$nulls":3},"JUMLAH KAS TERSEDIA",{"v":2000,"d":"2,000"},null,null,"TEMPAT TINGGAL UTAMA",{"v":233000,"d":"233,000"}]
[{"$nulls":3},"REKENING GIRO",{"v":2500,"d":"2,500"},null,null,"TEMPAT TINGGAL KEDUA"]
[{"$nulls":3},"REKENING TABUNGAN",{"v":4000,"d":"4,000"},null,null,"BARANG KOLEKSI BERHARGA"]
[{"$nulls":3},"REKENING PASAR UANG",{"v":3300,"d":"3,300"},null,null,"KENDARAAN",{"v":32000,"d":"32,000"}]
[{"$nulls":3},"REKENING DANA PASAR UANG",{"v":7000,"d":"7,000"},null,null,"FURNITUR RUMAH",{"v":10000,"d":"10,000"}]
[{"$nulls":3},"SERTIFIKAT DEPOSITO",{"$nulls":3},"MANTEL BULU DAN PERHIASAN"]
[{"$nulls":3},"SURAT BERHARGA A.S",{"$nulls":3},"ASET LAINNYA",{"v":1500,"d":"1,500"}]
[null,{"$f":"TotalAssets","v":{"v":380800,"d":"Rp380,800"}},null,"NILAI KAS ASURANSI JIWA",{"v":24500,"d":"24,500"}]
[{"$nulls":3},"SUBTOTAL",{"$f":"SUBTOTAL(109,tblCash[NILAI])","v":{"v":43300,"d":"43,300"}},null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,tblPersonal[NILAI])","v":{"v":276500,"d":"276,500"}}]
[null,"TOTAL ASET"]
[]
[null,null," ","INVESTASI","NILAI",null," ","PENSIUN","NILAI"]
[{"$nulls":3},"SAHAM",{"v":15000,"d":"15,000"},null,null,"PENSIUN"]
[{"$nulls":3},"OBLIGASI",{"$nulls":3},"REKENING PENSIUN INDIVIDUAL"]
[{"$nulls":3},"INVESTASI REKSA DANA",{"$nulls":3},"REKENING PENSIUN SWASTA"]
[{"$nulls":3},"BUNGA KEMITRAAN",{"$nulls":3},"401K",{"v":46000,"d":"46,000"}]
[{"$nulls":3},"INVESTASI LAIN",{"$nulls":3},"SEP"]
[{"$nulls":7},"ESOP"]
[{"$nulls":3},"SUBTOTAL",{"$f":"SUBTOTAL(109,tblInvestments[NILAI])","v":{"v":15000,"d":"15,000"}},null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,tblRetirement[NILAI])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"Kewajiban","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"Kewajiban",{"$nulls":5},"KEKAYAAN BERSIH",null," "]
[]
[null,null," ","TIDAK TERJAMIN","UTANG",null," ","TERJAMIN","UTANG"]
[{"$nulls":3},"KARTU KREDIT",{"v":1200,"d":"1,200"},null,null,"Pinjaman Kendaraan Bermotor",{"v":14500,"d":"14,500"}]
[{"$nulls":3},"REKENING PENJUALAN KREDIT",{"v":3000,"d":"3,000"},null,null,"Rek. Pinjaman Kendaraan"]
[{"$nulls":3},"PINJAMAN KULIAH",{"v":17500,"d":"17,500"},null,null,"Pinjaman Perabotan"]
[{"$nulls":3},"TUNJANGAN CERAI",{"$nulls":3},"Hipotek Rumah",{"v":144000,"d":"144,000"}]
[{"$nulls":3},"TUNJANGAN ANAK",{"$nulls":3},"Pinjaman Jaminan Rumah",{"v":21000,"d":"21,000"}]
[{"$nulls":3},"KEWAJIBAN PAJAK",{"v":8000,"d":"8,000"},null,null,"Pinjaman lainnya"]
[{"$nulls":3},"LAINNYA",{"v":6000,"d":"6,000"},null,null,"Kewajiban Pajak",{"v":4000,"d":"4,000"}]
[null,{"$f":"TotalLiabilites","v":{"v":221200,"d":"Rp221,200"}},{"$nulls":5},"Lainnya",{"v":2000,"d":"2,000"}]
[{"$nulls":3},"SUBTOTAL",{"$f":"SUBTOTAL(109,tblUnsecured[UTANG])","v":{"v":35700,"d":"35,700"}},null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,tblSecured[UTANG])","v":{"v":185500,"d":"185,500"}}]
[null,"TOTAL ASET"]

{"sheet":"penghitungan","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** Lembar ini harus tetap tersembunyi ***"]
{"$rows_empty":8}
[null,{"$f":"tblCash[[#Headers],[KAS]]","v":"KAS"},{"$f":"SUM(tblCash[NILAI])","v":{"v":43300,"d":"Rp43,300"}}]
[null,{"$f":"tblInvestments[[#Headers],[INVESTASI]]","v":"INVESTASI"},{"$f":"SUM(tblInvestments[NILAI])","v":{"v":15000,"d":"Rp15,000"}}]
[null,{"$f":"tblRetirement[[#Headers],[PENSIUN]]","v":"PENSIUN"},{"$f":"SUM(tblRetirement[NILAI])","v":{"v":46000,"d":"Rp46,000"}}]
[null,{"$f":"tblPersonal[[#Headers],[PRIBADI]]","v":"PRIBADI"},{"$f":"SUM(tblPersonal[NILAI])","v":{"v":276500,"d":"Rp276,500"}}]
[null,"Total Aset",{"$f":"SUM(tblCash[NILAI],tblInvestments[NILAI],tblRetirement[NILAI],tblPersonal[NILAI])","v":{"v":380800,"d":"Rp380,800"}}]
[]
[]
[null,{"$f":"tblUnsecured[[#Headers],[TIDAK TERJAMIN]]","v":"TIDAK TERJAMIN"},{"$f":"SUM(tblUnsecured[UTANG])","v":{"v":35700,"d":"Rp35,700"}}]
[null,{"$f":"tblSecured[[#Headers],[TERJAMIN]]","v":"TERJAMIN"},{"$f":"SUM(tblSecured[UTANG])","v":{"v":185500,"d":"Rp185,500"}}]
[null,"Total kewajiban",{"$f":"SUM(tblUnsecured[UTANG],tblSecured[UTANG])","v":{"v":221200,"d":"Rp221,200"}}]
[]
[]
[null,"Kekayaan Bersih",{"$f":"C15-C20","v":{"v":159600,"d":"Rp159,600"}}]