{"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":64,"n_cols":10,"rows_kept":64,"merged":[[1,1,1,9],[2,1,2,9],[4,1,6,1],[4,2,4,3],[4,6,5,8],[4,9,5,9],[5,2,5,3],[6,2,6,3],[6,6,7,8],[6,9,7,9],[7,1,9,1],[7,2,7,3],[8,2,8,3],[8,6,9,8],[8,9,9,9],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9]]}
[]
[null,"Anggaran Bulanan Pribadi"]
[]
[]
[null,"PRAKIRAAN PENDAPATAN BULANAN","Pendapatan 1",null,{"v":2500,"d":"Rp2,500"},null,"PRAKIRAAN SALDO (Prakiraan pendapatan dikurangi pengeluaran)",null,null,{"$f":"E7-J59","v":{"v":940,"d":"Rp940"}}]
[null,null,"Pendapatan tambahan",null,{"v":500,"d":"Rp500"}]
[null,null,"Total pendapatan bulanan",null,{"$f":"SUM(E5:E6)","v":{"v":3000,"d":"Rp3,000"}},null,"SALDO AKTUAL (Pendapatan aktual dikurangi pengeluaran)",null,null,{"$f":"E10-J61","v":{"v":960,"d":"Rp960"}}]
[null,"PENDAPATAN BULANAN AKTUAL","Pendapatan 1",null,{"v":2500,"d":"Rp2,500"}]
[null,null,"Pendapatan tambahan",null,{"v":500,"d":"Rp500"},null,"SELISIH (Aktual dikurangi prakiraan)",null,null,{"$f":"J7-J5","v":{"v":20,"d":"Rp20"}}]
[null,null,"Total pendapatan bulanan",null,{"$f":"SUM(E8:E9)","v":{"v":3000,"d":"Rp3,000"}}]
[]
[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":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"Rp100"}},null,"Video/DVD",{"v":0,"d":"Rp0"},{"v":50,"d":"Rp50"},{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":-50,"d":"-Rp50"}}]
[null,"Telepon",{"v":60,"d":"Rp60"},{"v":100,"d":"Rp100"},{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":-40,"d":"-Rp40"}},null,"CD",null,null,{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Listrik",{"v":50,"d":"Rp50"},{"v":60,"d":"Rp60"},{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":-10,"d":"-Rp10"}},null,"Film",null,null,{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Bahan Bakar",{"v":200,"d":"Rp200"},{"v":180,"d":"Rp180"},{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":20,"d":"Rp20"}},null,"Konser",null,null,{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Air dan saluran pembuangan",null,null,{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Acara olahraga",null,null,{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"TV Kabel",null,null,{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Teater langsung",null,null,{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pembuangan limbah",null,null,{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pemeliharaan atau perbaikan",null,null,{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Persediaan",null,null,{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Tabel2[[#This Row],[Prakiraan Biaya]]-Tabel2[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Tabel1[[#This Row],[Prakiraan Biaya]]-Tabel1[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel2[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel2[Biaya Aktual])","v":{"v":50,"d":"Rp50"}},{"$f":"SUBTOTAL(109,Tabel2[Selisih])","v":{"v":-50,"d":"-Rp50"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel1[Prakiraan Biaya])","v":{"v":1810,"d":"Rp1,810"}},{"$f":"SUBTOTAL(109,Tabel1[Biaya Aktual])","v":{"v":1740,"d":"Rp1,740"}},{"$f":"SUBTOTAL(109,Tabel1[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":"Tabel8[[#This Row],[Prakiraan Biaya]]-Tabel8[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pembayaran kendaraan",{"v":250,"d":"Rp250"},{"v":250,"d":"Rp250"},{"$f":"Tabel3[[#This Row],[Prakiraan Biaya]]-Tabel3[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Siswa",null,null,{"$f":"Tabel8[[#This Row],[Prakiraan Biaya]]-Tabel8[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Biaya bus/taksi",null,null,{"$f":"Tabel3[[#This Row],[Prakiraan Biaya]]-Tabel3[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Kartu kredit",null,null,{"$f":"Tabel8[[#This Row],[Prakiraan Biaya]]-Tabel8[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Asuransi",null,null,{"$f":"Tabel3[[#This Row],[Prakiraan Biaya]]-Tabel3[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Kartu kredit",null,null,{"$f":"Tabel8[[#This Row],[Prakiraan Biaya]]-Tabel8[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Surat-surat",null,null,{"$f":"Tabel3[[#This Row],[Prakiraan Biaya]]-Tabel3[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Kartu kredit",null,null,{"$f":"Tabel8[[#This Row],[Prakiraan Biaya]]-Tabel8[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Bahan bakar",null,null,{"$f":"Tabel3[[#This Row],[Prakiraan Biaya]]-Tabel3[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Tabel8[[#This Row],[Prakiraan Biaya]]-Tabel8[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pemeliharaan",null,null,{"$f":"Tabel3[[#This Row],[Prakiraan Biaya]]-Tabel3[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel8[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel8[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel8[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Tabel3[[#This Row],[Prakiraan Biaya]]-Tabel3[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel3[Prakiraan Biaya])","v":{"v":250,"d":"Rp250"}},{"$f":"SUBTOTAL(109,Tabel3[Biaya Aktual])","v":{"v":250,"d":"Rp250"}},{"$f":"SUBTOTAL(109,Tabel3[Selisih])","v":{"v":0,"d":"Rp0"}},null,"PAJAK","Prakiraan Biaya","Biaya Aktual","Selisih"]
[{"$nulls":6},"Provinsi",null,null,{"$f":"Tabel9[[#This Row],[Prakiraan Biaya]]-Tabel9[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"ASURANSI","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Negara",null,null,{"$f":"Tabel9[[#This Row],[Prakiraan Biaya]]-Tabel9[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Rumah",null,null,{"$f":"Tabel4[[#This Row],[Prakiraan Biaya]]-Tabel4[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Kabupaten/Kota",null,null,{"$f":"Tabel9[[#This Row],[Prakiraan Biaya]]-Tabel9[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Kesehatan",null,null,{"$f":"Tabel4[[#This Row],[Prakiraan Biaya]]-Tabel4[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Tabel9[[#This Row],[Prakiraan Biaya]]-Tabel9[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Jiwa",null,null,{"$f":"Tabel4[[#This Row],[Prakiraan Biaya]]-Tabel4[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel9[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel9[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel9[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Tabel4[[#This Row],[Prakiraan Biaya]]-Tabel4[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel4[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel4[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel4[Selisih])","v":{"v":0,"d":"Rp0"}},null,"TABUNGAN ATAU INVESTASI","Prakiraan Biaya","Biaya Aktual","Selisih"]
[{"$nulls":6},"Rekening pensiun",null,null,{"$f":"Tabel10[[#This Row],[Prakiraan Biaya]]-Tabel10[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"MAKANAN","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Rekening investasi",null,null,{"$f":"Tabel10[[#This Row],[Prakiraan Biaya]]-Tabel10[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Bahan Makanan",null,null,{"$f":"Tabel5[[#This Row],[Prakiraan Biaya]]-Tabel5[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Lainnya",null,null,{"$f":"Tabel10[[#This Row],[Prakiraan Biaya]]-Tabel10[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Makan",null,null,{"$f":"Tabel5[[#This Row],[Prakiraan Biaya]]-Tabel5[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel10[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel10[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel10[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Tabel5[[#This Row],[Prakiraan Biaya]]-Tabel5[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel5[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel5[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel5[Selisih])","v":{"v":0,"d":"Rp0"}},null,"HADIAH DAN DONASI","Prakiraan Biaya","Biaya Aktual","Selisih"]
[{"$nulls":6},"Amal 1",null,null,{"$f":"Tabel11[[#This Row],[Prakiraan Biaya]]-Tabel11[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"PELIHARAAN","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Amal 2",null,null,{"$f":"Tabel11[[#This Row],[Prakiraan Biaya]]-Tabel11[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Makanan",null,null,{"$f":"Tabel6[[#This Row],[Prakiraan Biaya]]-Tabel6[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Amal 3",null,null,{"$f":"Tabel11[[#This Row],[Prakiraan Biaya]]-Tabel11[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pengobatan",null,null,{"$f":"Tabel6[[#This Row],[Prakiraan Biaya]]-Tabel6[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel11[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel11[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel11[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Perawatan",null,null,{"$f":"Tabel6[[#This Row],[Prakiraan Biaya]]-Tabel6[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Mainan",null,null,{"$f":"Tabel6[[#This Row],[Prakiraan Biaya]]-Tabel6[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"HUKUM","Prakiraan Biaya","Biaya Aktual","Selisih"]
[null,"Lainnya",null,null,{"$f":"Tabel6[[#This Row],[Prakiraan Biaya]]-Tabel6[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Pengacara",null,null,{"$f":"Tabel12[[#This Row],[Prakiraan Biaya]]-Tabel12[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel6[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel6[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel6[Selisih])","v":{"v":0,"d":"Rp0"}},null,"Alimentasi",null,null,{"$f":"Tabel12[[#This Row],[Prakiraan Biaya]]-Tabel12[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[{"$nulls":6},"Pembayaran atas hak gadai atau putusan",null,null,{"$f":"Tabel12[[#This Row],[Prakiraan Biaya]]-Tabel12[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"PERAWATAN PRIBADI","Prakiraan Biaya","Biaya Aktual","Selisih",null,"Lainnya",null,null,{"$f":"Tabel12[[#This Row],[Prakiraan Biaya]]-Tabel12[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pengobatan",null,null,{"$f":"Tabel7[[#This Row],[Prakiraan Biaya]]-Tabel7[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"Total",{"$f":"SUBTOTAL(109,Tabel12[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel12[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel12[Selisih])","v":{"v":0,"d":"Rp0"}}]
[null,"Rambut/kuku",null,null,{"$f":"Tabel7[[#This Row],[Prakiraan Biaya]]-Tabel7[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pakaian",null,null,{"$f":"Tabel7[[#This Row],[Prakiraan Biaya]]-Tabel7[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"TOTAL PRAKIRAAN BIAYA",null,null,{"$f":"SUM(C23,C33,C40,C46,C54,C64,H22,H31,H38,H44,H50,H57)","v":{"v":2060,"d":"Rp2,060"}}]
[null,"Cucian",null,null,{"$f":"Tabel7[[#This Row],[Prakiraan Biaya]]-Tabel7[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Klub kesehatan",null,null,{"$f":"Tabel7[[#This Row],[Prakiraan Biaya]]-Tabel7[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"TOTAL BIAYA AKTUAL",null,null,{"$f":"SUM(D23,D33,D40,D46,D54,D64,I22,I31,I38,I44,I50,I57)","v":{"v":2040,"d":"Rp2,040"}}]
[null,"Iuran atau biaya organisasi",null,null,{"$f":"Tabel7[[#This Row],[Prakiraan Biaya]]-Tabel7[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Lainnya",null,null,{"$f":"Tabel7[[#This Row],[Prakiraan Biaya]]-Tabel7[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},null,"TOTAL SELISIH",null,null,{"$f":"SUM(E23,E33,E40,E46,E54,E64,J22,J31,J38,J44,J50,J57)","v":{"v":20,"d":"Rp20"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabel7[Prakiraan Biaya])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel7[Biaya Aktual])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,Tabel7[Selisih])","v":{"v":0,"d":"Rp0"}}]