{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Anggaran Bulanan Pribadi"],"read":"whole","date_system":"1900"}

{"sheet":"Anggaran Bulanan Pribadi","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"merged":[[0,1,0,9],[2,1,4,1],[2,2,2,3],[2,7,2,8],[3,2,3,3],[3,7,3,8],[4,2,4,3],[4,6,4,8],[5,1,7,1],[5,2,5,3],[5,7,5,8],[6,2,6,3],[6,7,6,8],[7,2,7,3],[7,6,7,8],[20,6,20,9],[21,1,21,4],[29,6,29,9],[31,1,31,4],[36,6,36,9],[38,1,38,4],[42,6,42,9],[44,1,44,4],[48,6,48,9],[52,1,52,4],[55,6,55,9]]}
[null,"Anggaran Bulanan Pribadi"]
[]
[null,"PRAKIRAAN PENDAPATAN BULANAN","Pendapatan 1",null,{"v":2500,"d":"Rp2,500"},null,"TOTAL PRAKIRAAN PENGELUARAN ","(Prakiraan pendapatan dikurangi pengeluaran)",null,{"$f":"SUM(C21,C31,C38,C44,C52,C62,H20,H29,H36,H42,H48,H55)","v":{"v":2060,"d":"Rp2,060"}}]
[null,null,"Pendapatan tambahan",null,{"v":500,"d":"Rp500"},null,"TOTAL PENGELUARAN AKTUAL ","(Pendapatan aktual dikurangi pengeluaran)",null,{"$f":"SUM(D21,D31,D38,D44,D52,D62,I20,I29,I36,I42,I48,I55)","v":{"v":2040,"d":"Rp2,040"}}]
[null,null,"Total pendapatan bulanan",null,{"$f":"SUM(E3:E4)","v":{"v":3000,"d":"Rp3,000"}},null,"Total Selisih Pengeluaran",null,null,{"$f":"SUM(E21,E31,E38,E44,E52,E62,J20,J29,J36,J42,J48,J55)","v":{"v":20,"d":"Rp20"}}]
[null,"PENDAPATAN BULANAN AKTUAL","Pendapatan 1",null,{"v":2500,"d":"Rp2,500"},null,"PRAKIRAAN SALDO","(Prakiraan pendapatan dikurangi pengeluaran)",null,{"$f":"E5-J3","v":{"v":940,"d":"Rp940"}}]
[null,null,"Pendapatan tambahan",null,{"v":500,"d":"Rp500"},null,"SALDO AKTUAL","(Pendapatan aktual dikurangi pengeluaran)",null,{"$f":"E8-J4","v":{"v":960,"d":"Rp960"}}]
[null,null,"Total pendapatan bulanan",null,{"$f":"SUM(E6:E7)","v":{"v":3000,"d":"Rp3,000"}},null,"SELISIH SALDO (Aktual dikurangi prakiraan)",null,null,{"$f":"J7-J6","v":{"v":20,"d":"Rp20"}}]
[]
[null,"RUMAH","Prakiraan Biaya","Biaya Aktual","Selisih",null,"HIBURAN","Prakiraan Biaya","Biaya Aktual","Selisih"]
[null,"Hipotek atau sewa",{"v":1500,"d":"Rp1,500"},{"v":1400,"d":"Rp1,400"},{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"Rp100"}},null,"Video/DVD",{"v":0,"d":"Rp0"},{"v":50,"d":"Rp50"},{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":-50,"d":"-Rp50"}}]
[null,"Telepon",{"v":60,"d":"Rp60"},{"v":100,"d":"Rp100"},{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":-40,"d":"-Rp40"}},null,"CD",null,null,{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Listrik",{"v":50,"d":"Rp50"},{"v":60,"d":"Rp60"},{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":-10,"d":"-Rp10"}},null,"Film",null,null,{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Bahan Bakar",{"v":200,"d":"Rp200"},{"v":180,"d":"Rp180"},{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":20,"d":"Rp20"}},null,"Konser",null,null,{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Air dan saluran pembuangan",null,null,{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Acara olahraga",null,null,{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"TV Kabel",null,null,{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Teater langsung",null,null,{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pembuangan limbah",null,null,{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pemeliharaan atau perbaikan",null,null,{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Persediaan",null,null,{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Hiburan[[#This Row],[Prakiraan Biaya]]-Hiburan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Rumah[[#This Row],[Prakiraan Biaya]]-Rumah[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Hiburan[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Hiburan[Biaya Aktual])","v":{"v":50,"d":"Rp50"}},{"$f":"SUBTOTAL(109,Hiburan[Selisih])","v":{"v":-50,"d":"-Rp50"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Rumah[Prakiraan Biaya])","v":{"v":1810,"d":"Rp1,810"}},{"$f":"SUBTOTAL(109,Rumah[Biaya Aktual])","v":{"v":1740,"d":"Rp1,740"}},{"$f":"SUBTOTAL(109,Rumah[Selisih])","v":{"v":70,"d":"Rp70"}}]
[{"$nulls":6},"PINJAMAN","Prakiraan Biaya","Biaya Aktual","Selisih"]
[null,"TRANSPORTASI","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Pribadi",null,null,{"$f":"Pinjaman[[#This Row],[Prakiraan Biaya]]-Pinjaman[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pembayaran kendaraan",{"v":250,"d":"Rp250"},{"v":250,"d":"Rp250"},{"$f":"Transportasi[[#This Row],[Prakiraan Biaya]]-Transportasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Siswa",null,null,{"$f":"Pinjaman[[#This Row],[Prakiraan Biaya]]-Pinjaman[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Biaya bus/taksi",null,null,{"$f":"Transportasi[[#This Row],[Prakiraan Biaya]]-Transportasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Kartu kredit",null,null,{"$f":"Pinjaman[[#This Row],[Prakiraan Biaya]]-Pinjaman[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Asuransi",null,null,{"$f":"Transportasi[[#This Row],[Prakiraan Biaya]]-Transportasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Kartu kredit",null,null,{"$f":"Pinjaman[[#This Row],[Prakiraan Biaya]]-Pinjaman[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Surat-surat",null,null,{"$f":"Transportasi[[#This Row],[Prakiraan Biaya]]-Transportasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Kartu kredit",null,null,{"$f":"Pinjaman[[#This Row],[Prakiraan Biaya]]-Pinjaman[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Bahan bakar",null,null,{"$f":"Transportasi[[#This Row],[Prakiraan Biaya]]-Transportasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Pinjaman[[#This Row],[Prakiraan Biaya]]-Pinjaman[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pemeliharaan",null,null,{"$f":"Transportasi[[#This Row],[Prakiraan Biaya]]-Transportasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Pinjaman[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pinjaman[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pinjaman[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Transportasi[[#This Row],[Prakiraan Biaya]]-Transportasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Transportasi[Prakiraan Biaya])","v":{"v":250,"d":"Rp250"}},{"$f":"SUBTOTAL(109,Transportasi[Biaya Aktual])","v":{"v":250,"d":"Rp250"}},{"$f":"SUBTOTAL(109,Transportasi[Selisih])","v":{"v":0,"d":"Rp0"}},null,"PAJAK","Prakiraan Biaya","Biaya Aktual","Selisih"]
[{"$nulls":6},"Provinsi",null,null,{"$f":"Pajak[[#This Row],[Prakiraan Biaya]]-Pajak[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"ASURANSI","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Negara",null,null,{"$f":"Pajak[[#This Row],[Prakiraan Biaya]]-Pajak[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Rumah",null,null,{"$f":"Asuransi[[#This Row],[Prakiraan Biaya]]-Asuransi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Kabupaten/Kota",null,null,{"$f":"Pajak[[#This Row],[Prakiraan Biaya]]-Pajak[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Kesehatan",null,null,{"$f":"Asuransi[[#This Row],[Prakiraan Biaya]]-Asuransi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Pajak[[#This Row],[Prakiraan Biaya]]-Pajak[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Jiwa",null,null,{"$f":"Asuransi[[#This Row],[Prakiraan Biaya]]-Asuransi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Pajak[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pajak[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Pajak[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Asuransi[[#This Row],[Prakiraan Biaya]]-Asuransi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Asuransi[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Asuransi[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Asuransi[Selisih])","v":{"v":0,"d":"Rp0"}},null,"TABUNGAN ATAU INVESTASI","Prakiraan Biaya","Biaya Aktual","Selisih"]
[{"$nulls":6},"Rekening pensiun",null,null,{"$f":"TabunganAtauInvestasi[[#This Row],[Prakiraan Biaya]]-TabunganAtauInvestasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"MAKANAN","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Rekening investasi",null,null,{"$f":"TabunganAtauInvestasi[[#This Row],[Prakiraan Biaya]]-TabunganAtauInvestasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Bahan Makanan",null,null,{"$f":"Makanan[[#This Row],[Prakiraan Biaya]]-Makanan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"TabunganAtauInvestasi[[#This Row],[Prakiraan Biaya]]-TabunganAtauInvestasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Makan",null,null,{"$f":"Makanan[[#This Row],[Prakiraan Biaya]]-Makanan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,TabunganAtauInvestasi[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,TabunganAtauInvestasi[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,TabunganAtauInvestasi[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Makanan[[#This Row],[Prakiraan Biaya]]-Makanan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Makanan[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Makanan[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Makanan[Selisih])","v":{"v":0,"d":"Rp0"}},null,"HADIAH DAN DONASI","Prakiraan Biaya","Biaya Aktual","Selisih"]
[{"$nulls":6},"Amal 1",null,null,{"$f":"HadiahDanDonasi[[#This Row],[Prakiraan Biaya]]-HadiahDanDonasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"PELIHARAAN","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Amal 2",null,null,{"$f":"HadiahDanDonasi[[#This Row],[Prakiraan Biaya]]-HadiahDanDonasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Makanan",null,null,{"$f":"Peliharaan[[#This Row],[Prakiraan Biaya]]-Peliharaan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Amal 3",null,null,{"$f":"HadiahDanDonasi[[#This Row],[Prakiraan Biaya]]-HadiahDanDonasi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pengobatan",null,null,{"$f":"Peliharaan[[#This Row],[Prakiraan Biaya]]-Peliharaan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,HadiahDanDonasi[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,HadiahDanDonasi[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,HadiahDanDonasi[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Perawatan",null,null,{"$f":"Peliharaan[[#This Row],[Prakiraan Biaya]]-Peliharaan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Mainan",null,null,{"$f":"Peliharaan[[#This Row],[Prakiraan Biaya]]-Peliharaan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"HUKUM","Prakiraan Biaya","Biaya Aktual","Selisih"]
[null,"Lainnya",null,null,{"$f":"Peliharaan[[#This Row],[Prakiraan Biaya]]-Peliharaan[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Pengacara",null,null,{"$f":"Hukum[[#This Row],[Prakiraan Biaya]]-Hukum[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Peliharaan[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Peliharaan[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Peliharaan[Selisih])","v":{"v":0,"d":"Rp0"}},null,"Alimentasi",null,null,{"$f":"Hukum[[#This Row],[Prakiraan Biaya]]-Hukum[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":6},"Pembayaran atas hak gadai atau putusan",null,null,{"$f":"Hukum[[#This Row],[Prakiraan Biaya]]-Hukum[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"PERAWATAN PRIBADI","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Lainnya",null,null,{"$f":"Hukum[[#This Row],[Prakiraan Biaya]]-Hukum[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pengobatan",null,null,{"$f":"PerawatanPribadi[[#This Row],[Prakiraan Biaya]]-PerawatanPribadi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Hukum[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Hukum[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Hukum[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Rambut/kuku",null,null,{"$f":"PerawatanPribadi[[#This Row],[Prakiraan Biaya]]-PerawatanPribadi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pakaian",null,null,{"$f":"PerawatanPribadi[[#This Row],[Prakiraan Biaya]]-PerawatanPribadi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Cucian",null,null,{"$f":"PerawatanPribadi[[#This Row],[Prakiraan Biaya]]-PerawatanPribadi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Klub kesehatan",null,null,{"$f":"PerawatanPribadi[[#This Row],[Prakiraan Biaya]]-PerawatanPribadi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Iuran atau biaya organisasi",null,null,{"$f":"PerawatanPribadi[[#This Row],[Prakiraan Biaya]]-PerawatanPribadi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"PerawatanPribadi[[#This Row],[Prakiraan Biaya]]-PerawatanPribadi[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,PerawatanPribadi[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PerawatanPribadi[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PerawatanPribadi[Selisih])","v":{"v":0,"d":"Rp0"}}]