{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Ringkasan","Penghasilan dan Pengeluaran"],"not_rendered":{"images":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Ringkasan","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,1,0,4],[0,5,5,5],[1,1,1,4],[2,1,2,3],[3,2,3,3]]}
[null,"Ringkasan Anggaran Bulanan",{"$nulls":3},"Kesulitan merencanakan anggaran Anda? Gunakan kalkulator anggaran bulanan ini untuk membantu Anda mengidentifikasi penghasilan dan pengeluaran bulanan. Tambahkan kategori baru yang ingin dicatat ke tabel ringkasan anggaran atau ubah kategori yang telah ditambahkan agar sesuai dengan kebutuhan Anda. Kemudian, masukkan semua penghasilan dan pengeluaran Anda selama satu bulan ke dalam tabel penghasilan dan pengeluaran bulanan, lalu tetapkan kategori untuk setiap item. Begitu jumlah dimasukkan, kategori terkait dalam tabel ringkasan anggaran akan diringkas secara otomatis."]
[null,"[MASUKKAN BULAN]"]
[null,{"$f":"CONCATENATE(\"Kurang/Lebih: \"&TEXT(KurangLebih,\"Rp#.##0;[Merah]-Rp#.##0\"))","v":"Kurang/Lebih: Rp928"}]
[null,null,"Ringkasan Anggaran"]
[null,null,"Kategori","Total"]
[null,null,"Penghasilan",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":4500,"d":"4,500.00"}}]
[null,null,"Rumah",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":1410,"d":"1,410.00"}}]
[null,null,"Kebutuhan Umum",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":73,"d":"73.00"}}]
[null,null,"Belanja Sehari-hari",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":220,"d":"220.00"}}]
[null,null,"Asuransi",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":180,"d":"180.00"}}]
[null,null,"Telepon",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":104,"d":"104.00"}}]
[null,null,"Kartu Kredit",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":315,"d":"315.00"}}]
[null,null,"Sekolah",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":1063,"d":"1,063.00"}}]
[null,null,"Tabungan",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":100,"d":"100.00"}}]
[null,null,"Hiburan",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":107,"d":"107.00"}}]
[null,null,"Lainnya",{"$f":"SUMIF(Register[Kategori],\"=\" &Kategori[[#This Row],[Kategori]],Register[Jumlah])","v":{"v":0,"d":"0.00"}}]

{"sheet":"Penghasilan dan Pengeluaran","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,{"$f":"Judul_Anggaran","v":"Ringkasan Anggaran Bulanan"}]
[null,"Penghasilan dan Pengeluaran"]
[null,"Kategori","Deskripsi","Jumlah","Catatan"]
[null,"Penghasilan","Gaji Patricia",{"v":1250,"d":"Rp1,250.00"}]
[null,"Sekolah","Pendaftaran sekolah",{"v":225,"d":"Rp225.00"}]
[null,"Kebutuhan Umum","Listrik & gas",{"v":73,"d":"Rp73.00"}]
[null,"Sekolah","Perlengkapan sekolah",{"v":38,"d":"Rp38.00"}]
[null,"Belanja Sehari-hari","Toko kelontong",{"v":40,"d":"Rp40.00"}]
[null,"Hiburan","Video southridge",{"v":7,"d":"Rp7.00"}]
[null,"Telepon","Perusahaan telepon",{"v":24,"d":"Rp24.00"},"Ponsel Jefri"]
[null,"Penghasilan","Gaji Joko",{"v":2000,"d":"Rp2,000.00"}]
[null,"Rumah","Woodgrove Bank",{"v":1000,"d":"Rp1,000.00"},"Hipotek"]
[null,"Rumah","Asuransi rumah",{"v":210,"d":"Rp210.00"},"Asuransi rumah"]
[null,"Sekolah","Sekolah Kesenian",{"v":800,"d":"Rp800.00"},"Uang Sekolah"]
[null,"Kartu Kredit","Bank Rakyat Indonesia",{"v":75,"d":"Rp75.00"},"Kartu Patricia"]
[null,"Tabungan","Woodgrove Bank",{"v":100,"d":"Rp100.00"}]
[null,"Telepon","Consolidated messenger",{"v":80,"d":"Rp80.00"},"Ponsel Patricia"]
[null,"Penghasilan","Gaji Patricia",{"v":1250,"d":"Rp1,250.00"}]
[null,"Rumah","Woodgrove Bank",{"v":200,"d":"Rp200.00"},"Pajak bumi dan bangunan"]
[null,"Asuransi","Asuransi kendaraan",{"v":180,"d":"Rp180.00"},"Asuransi kendaraan"]
[null,"Belanja Sehari-hari","Toko kelontong",{"v":180,"d":"Rp180.00"}]
[null,"Kartu Kredit","Woodgrove Bank",{"v":240,"d":"Rp240.00"},"Kartu Jefri"]
[null,"Hiburan","Makan malam dan nonton bioskop",{"v":100,"d":"Rp100.00"}]