{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Ringkasan","Pengeluaran"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Ringkasan","index":0,"n_rows":10,"n_cols":15,"rows_kept":10,"merged":[[0,1,0,2]]}
[null,"Anggaran Pribadi"]
[null,null,"Jan","Feb","Maret","April","Mei","Juni","Juli","Agu","Sep","Okt","Nov","Des","Tahun"]
[null,"Total pengeluaran",{"$f":"Pengeluaran[[#Totals],[Jan]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Feb]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Maret]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[April]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Mei]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Juni]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Juli]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Agu]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Sep]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Okt]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Nov]]","v":{"v":0,"d":"Rp0"}},{"$f":"Pengeluaran[[#Totals],[Des]]","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(C3:N3)","v":{"v":0,"d":"Rp0"}}]
[null,"Kekurangan/tambahan kas",{"$f":"SUM(Pendapatan[[#Totals],[Jan]]-C3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Feb]]-D3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Maret]]-E3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[April]]-F3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Mei]]-G3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Juni]]-H3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Juli]]-I3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Agu]]-J3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Sep]]-K3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Okt]]-L3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Nov]]-M3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(Pendapatan[[#Totals],[Des]]-N3)","v":{"v":0,"d":"Rp0"}},{"$f":"SUM(C4:N4)","v":{"v":0,"d":"Rp0"}}]
[null,"Pendapatan"]
[null,"Kategori","Jan","Feb","Maret","April","Mei","Juni","Juli","Agu","Sep","Okt","Nov","Des","Tahun"]
[null,"Gaji",{"$nulls":12},{"$f":"SUM(Pendapatan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0"}}]
[null,"Bunga/dividen",{"$nulls":12},{"$f":"SUM(Pendapatan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0"}}]
[null,"Lain-lain",{"$nulls":12},{"$f":"SUM(Pendapatan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Pendapatan[Jan])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Feb])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Maret])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[April])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Mei])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Juni])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Juli])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Agu])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Sep])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Okt])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Nov])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Des])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pendapatan[Tahun])","v":{"v":0,"d":"Rp0"}}]

{"sheet":"Pengeluaran","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"merged":[[0,1,0,2]]}
[null,"Anggaran Pribadi"]
[null,"Pengeluaran"]
[null,"Kategori","Subkategori","Jan","Feb","Maret","April","Mei","Juni","Juli","Agu","Sep","Okt","Nov","Des","Tahun"]
[null,"Rumah","Hipotek/sewa",{"$nulls":12},{"$f":"SUM(Pengeluaran!$D4:$O4)","v":{"v":0,"d":"Rp0"}}]
[null,"Harian","Bahan Makanan ",{"$nulls":12},{"$f":"SUM(Pengeluaran!$D5:$O5)","v":{"v":0,"d":"Rp0"}}]
[null,"Transportasi","Gas/bahan bakar",{"$nulls":12},{"$f":"SUM(Pengeluaran!$D6:$O6)","v":{"v":0,"d":"Rp0"}}]
[null,"Hiburan","TV Kabel",{"$nulls":12},{"$f":"SUM(Pengeluaran!$D7:$O7)","v":{"v":0,"d":"Rp0"}}]
[null,"Kesehatan","Iuran klub kesehatan",{"$nulls":12},{"$f":"SUM(Pengeluaran!$D8:$O8)","v":{"v":0,"d":"Rp0"}}]
[null,"Liburan","Tiket pesawat",{"$nulls":12},{"$f":"SUM(Pengeluaran!$D9:$O9)","v":{"v":0,"d":"Rp0"}}]
[null,"Rekreasi","Biaya pusat kebugaran",{"$nulls":12},{"$f":"SUM(Pengeluaran!$D10:$O10)","v":{"v":0,"d":"Rp0"}}]
[null,"Iuran/Langganan","Majalah",{"$nulls":12},{"$f":"SUM(Pengeluaran!$D11:$O11)","v":{"v":0,"d":"Rp0"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Pengeluaran[Jan])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Feb])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Maret])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[April])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Mei])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Juni])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Juli])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Agu])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Sep])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Okt])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Nov])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Des])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pengeluaran[Tahun])","v":{"v":0,"d":"Rp0"}}]