{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Mulai","Laporan Anggaran Bulanan","Pengeluaran Bulanan","Data Tambahan"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Mulai","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"TENTANG TEMPLAT INI"]
[null,"Gunakan buku kerja ini untuk mencatat pengeluaran Anda dan membuat Anggaran Keluarga."]
[null,"Masukkan proyeksi pendapatan dan pendapatan aktual dari beberapa sumber ke lembar kerja Laporan Anggaran Bulanan, serta proyeksi jumlah dan jumlah aktual yang digunakan pada berbagai kategori ke lembar kerja Pengeluaran Bulanan."]
[null,"Proyeksi Saldo, Saldo Aktual, dan Selisih dihitung secara otomatis. Bagan Ringkasan Anggaran dan Gambaran Umum Anggaran diperbarui dalam lembar kerja Laporan Anggaran Bulanan."]
[null,"Anda dapat mengubah atau memasukkan kategori baru ke tabel dalam lembar kerja Data Tambahan."]
[null,"Catatan: "]
[null,"Instruksi tambahan telah disediakan di kolom A dalam lembar kerja LAPORAN ANGGARAN BULANAN serta di sel A1 dalam lembar kerja PENGELUARAN BULANAN dan DATA TAMBAHAN. Teks ini sengaja disembunyikan. Untuk menghapus teks, pilih kolom A atau sel A1, lalu pilih HAPUS. Untuk memperlihatkan teks, pilih kolom A atau sel A1, lalu ubah warna font."]
[null,"Untuk mempelajari selengkapnya tentang tabel, tekan SHIFT lalu F10 dalam tabel, pilih opsi TABEL, kemudian pilih TEKS ALTERNATIF. Untuk PivotTable, tekan SHIFT lalu F10 dalam tabel, pilih OPSI PIVOTTABLE, kemudian pilih tab TEKS ALT."]

{"sheet":"Laporan Anggaran Bulanan","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,13],[1,9,5,13],[2,2,2,5],[3,2,3,5],[4,2,4,5],[7,1,10,1],[7,5,10,5],[7,6,10,6],[8,9,31,9],[12,1,16,1],[12,5,16,5],[12,6,16,6],[19,1,34,6]]}
["Buat Laporan Anggaran Bulanan dalam lembar kerja ini. Judul lembar kerja ini ada di sel sebelah kanan dan subjudul di sel J1. Pilih sel F1 untuk menavigasi ke lembar kerja Pengeluaran Bulanan. Instruksi bermanfaat lainnya tentang cara menggunakan lembar kerja ini ada pada beberapa sel di kolom ini.","Gambaran Umum Anggaran",{"$nulls":3},"Pengeluaran Bulanan",{"$nulls":3},"Ringkasan Anggaran",null,null,"Satu batang gandum berwarna hijau ada di sel ini."]
["Label Saldo ada di sel sebelah kanan. Pemotong PivotTable untuk memfilter data tabel ada di sel J2 hingga N6. Untuk memilih beberapa kategori, tahan tombol Control.","Saldo",{"$nulls":7},"Pemotong Kategori untuk memfilter PivotTable di bawah ini menurut kategori yang dipilih ada di sel ini."]
["Label Proyeksi Saldo ada di sel sebelah kanan. Proyeksi Saldo dihitung secara otomatis di sel G3.","Proyeksi Saldo","(Proyeksi dikurangi pengeluaran)",{"$nulls":3},{"$f":"D17-SUM(DetailAnggaran[Proyeksi Biaya])","v":{"v":1585,"d":"Rp1,585"}}]
["Label Saldo Aktual ada di sel sebelah kanan. Saldo Aktual dihitung secara otomatis di sel G4.","Saldo Aktual ","(Aktual dikurangi pengeluaran)",{"$nulls":3},{"$f":"D11-SUM(DetailAnggaran[Biaya Aktual])","v":{"v":1740,"d":"Rp1,740"}}]
["Label Selisih ada di sel sebelah kanan. Selisih dihitung secara otomatis di sel G5. Instruksi berikutnya ada di sel A7.","Selisih","(Aktual dikurangi proyeksi)",{"$nulls":3},{"$f":"G4-G3","v":{"v":155,"d":"Rp155"}}]
[]
["Label Pendapatan ada di sel sebelah kanan, label Pengeluaran di sel F7, dan Tips untuk Ringkasan Anggaran di sel J7.","Pendapatan",{"$nulls":3},"Pengeluaran",{"$nulls":3},"Pilih PivotTable di bawah ini, lalu pilih Refresh pada tab Analisis untuk memperbarui."]
["Label Pendapatan Aktual ada di sel sebelah kanan dan label pengeluaran Aktual di sel F8. Masukkan Pendapatan 1 di sel D8. Pengeluaran Aktual dihitung secara otomatis di sel G8.","AKTUAL","Pendapatan 1",{"v":5800,"d":"Rp5,800"},null,"AKTUAL",{"$f":"SUM(DetailAnggaran[Biaya Aktual])","v":{"v":7860,"d":"Rp7,860"}}]
["Masukkan Pendapatan 2 di sel D9. Gambar ada di sel J9. PivotTable dimulai dari sel K9. Untuk memperbarui PivotTable, pilih Refresh pada tab Analisis.",null,"Pendapatan 2",{"v":2300,"d":"Rp2,300"},{"$nulls":5},"Gambar ada di sel ini.","Kategori","Proyeksi Biaya ","Biaya Aktual ","Selisih "]
["Masukkan Pendapatan Tambahan di sel D10.",null,"Pendapatan tambahan",{"v":1500,"d":"Rp1,500"},{"$nulls":6},"Anak",{"v":140,"d":"Rp140"},{"v":140,"d":"Rp140"},{"v":0,"d":"Rp0"}]
["Label Total Pendapatan ada di sel C11 dan Total Pendapatan dihitung secara otomatis di sel D11. Instruksi berikutnya ada di sel A13.",null,"Total pendapatan",{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"Rp9,600"}}]
[{"$nulls":10},"Asuransi",{"v":900,"d":"Rp900"},{"v":900,"d":"Rp900"},{"v":0,"d":"Rp0"}]
["Label Proyeksi Pendapatan ada di sel sebelah kanan dan label Proyeksi pengeluaran di sel F13. Proyeksi Pengeluaran dihitung secara otomatis di sel G13.","PROYEKSI",{"$nulls":3},"PROYEKSI",{"$f":"SUM(DetailAnggaran[Proyeksi Biaya])","v":{"v":7915,"d":"Rp7,915"}}]
["Masukkan proyeksi Pendapatan 1 di sel D14.",null,"Pendapatan 1",{"v":6000,"d":"Rp6,000"},{"$nulls":6},"Hadiah dan Amal",{"v":100,"d":"Rp100"},{"v":125,"d":"Rp125"},{"v":-25,"d":"-Rp25"}]
["Masukkan proyeksi Pendapatan 2 di sel D15.",null,"Pendapatan 2",{"v":1000,"d":"Rp1,000"}]
["Masukkan Pendapatan Tambahan di sel D16.",null,"Pendapatan tambahan",{"v":2500,"d":"Rp2,500"},{"$nulls":6},"Hiburan",{"v":400,"d":"Rp400"},{"v":358,"d":"Rp358"},{"v":42,"d":"Rp42"}]
["Label Total Pendapatan ada di sel C17 dan Total Pendapatan dihitung secara otomatis di sel D17. Instruksi berikutnya ada di sel A20.",null,"Total pendapatan",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"Rp9,500"}}]
[{"$nulls":10},"Kebutuhan Rumah Tangga",{"v":2830,"d":"Rp2,830"},{"v":2702,"d":"Rp2,702"},{"v":128,"d":"Rp128"}]
[]
["Bagan pai yang memperlihatkan persentase pengeluaran menurut kategori ada di sel sebelah kanan.","Bagan pai yang memperlihatkan persentase pengeluaran menurut kategori ada di sel ini.",{"$nulls":8},"Makanan",{"v":1100,"d":"Rp1,100"},{"v":1320,"d":"Rp1,320"},{"v":-220,"d":"-Rp220"}]
[]
[{"$nulls":10},"Pajak",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"v":0,"d":"Rp0"}]
[]
[{"$nulls":10},"Peliharaan",{"v":170,"d":"Rp170"},{"v":100,"d":"Rp100"},{"v":70,"d":"Rp70"}]
[]
[{"$nulls":10},"Perawatan Pribadi",{"v":150,"d":"Rp150"},{"v":140,"d":"Rp140"},{"v":10,"d":"Rp10"}]
[]
[{"$nulls":10},"Pinjaman",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"v":0,"d":"Rp0"}]
[]
[{"$nulls":10},"Tabungan atau Investasi",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"v":0,"d":"Rp0"}]
[]
[{"$nulls":10},"Transportasi",{"v":1425,"d":"Rp1,425"},{"v":1375,"d":"Rp1,375"},{"v":50,"d":"Rp50"}]
[]
[{"$nulls":10},"Total Keseluruhan",{"v":7915,"d":"Rp7,915"},{"v":7860,"d":"Rp7,860"},{"v":55,"d":"Rp55"}]

{"sheet":"Pengeluaran Bulanan","index":2,"n_rows":62,"n_cols":7,"rows_kept":62,"merged":[[0,1,0,4],[0,5,0,6]]}
["Hitung pengeluaran bulanan Anda dalam lembar kerja ini. Judul lembar kerja ada di sel sebelah kanan. Pilih sel F1 untuk menavigasi ke lembar kerja Laporan Anggaran Bulanan.","Pengeluaran Bulanan",{"$nulls":3},"Laporan Anggaran Bulanan"]
[" Masukkan data dalam tabel Detail Anggaran yang dimulai di sel sebelah kanan.","Deskripsi","Kategori","Proyeksi Biaya","Biaya Aktual","Selisih","Gambaran Umum Biaya Aktual"]
[null,"Kegiatan ekstrakurikuler","Anak",{"v":40,"d":"Rp40"},{"v":40,"d":"Rp40"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":40,"d":"Rp40"}}]
[null,"Obat-obatan","Anak",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Perlengkapan Sekolah","Anak",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Biaya Sekolah","Anak",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"Rp100"}}]
[null,"Konser","Hiburan",{"v":50,"d":"Rp50"},{"v":40,"d":"Rp40"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":10,"d":"Rp10"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":40,"d":"Rp40"}}]
[null,"Pertunjukan Teater","Hiburan",{"v":200,"d":"Rp200"},{"v":150,"d":"Rp150"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":150,"d":"Rp150"}}]
[null,"Film","Hiburan",{"v":50,"d":"Rp50"},{"v":28,"d":"Rp28"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":22,"d":"Rp22"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":28,"d":"Rp28"}}]
[null,"Musik (CD, unduhan, dll.)","Hiburan",{"v":50,"d":"Rp50"},{"v":30,"d":"Rp30"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":20,"d":"Rp20"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":30,"d":"Rp30"}}]
[null,"Acara Olahraga","Hiburan",{"v":0,"d":"Rp0"},{"v":40,"d":"Rp40"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-40,"d":"-Rp40"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":40,"d":"Rp40"}}]
[null,"Video/DVD (Pembelian)","Hiburan",{"v":20,"d":"Rp20"},{"v":50,"d":"Rp50"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-30,"d":"-Rp30"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}}]
[null,"Video/DVD (Penyewaan)","Hiburan",{"v":30,"d":"Rp30"},{"v":20,"d":"Rp20"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":10,"d":"Rp10"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":20,"d":"Rp20"}}]
[null,"Makan","Makanan",{"v":1000,"d":"Rp1,000"},{"v":1200,"d":"Rp1,200"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-200,"d":"-Rp200"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":1200,"d":"Rp1,200"}}]
[null,"Belanja","Makanan",{"v":100,"d":"Rp100"},{"v":120,"d":"Rp120"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-20,"d":"-Rp20"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":120,"d":"Rp120"}}]
[null,"Amal 1","Hadiah dan Amal",{"v":75,"d":"Rp75"},{"v":100,"d":"Rp100"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-25,"d":"-Rp25"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"Rp100"}}]
[null,"Amal 2","Hadiah dan Amal",{"v":25,"d":"Rp25"},{"v":25,"d":"Rp25"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":25,"d":"Rp25"}}]
[null,"Hadiah 1","Hadiah dan Amal",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Hadiah 2","Hadiah dan Amal",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"TV Kabel/Satelit","Kebutuhan Rumah Tangga",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"Rp100"}}]
[null,"Listrik","Kebutuhan Rumah Tangga",{"v":45,"d":"Rp45"},{"v":50,"d":"Rp50"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-5,"d":"-Rp5"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}}]
[null,"Bahan Bakar","Kebutuhan Rumah Tangga",{"v":300,"d":"Rp300"},{"v":400,"d":"Rp400"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-100,"d":"-Rp100"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":400,"d":"Rp400"}}]
[null,"Layanan Kebersihan Rumah","Kebutuhan Rumah Tangga",{"v":200,"d":"Rp200"},null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":200,"d":"Rp200"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pemeliharaan","Kebutuhan Rumah Tangga",{"v":200,"d":"Rp200"},{"v":150,"d":"Rp150"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":150,"d":"Rp150"}}]
[null,"Hipotek atau Sewa","Kebutuhan Rumah Tangga",{"v":1700,"d":"Rp1,700"},{"v":1700,"d":"Rp1,700"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":1700,"d":"Rp1,700"}}]
[null,"Minyak/gas alam","Kebutuhan Rumah Tangga",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Layanan Internet/Online","Kebutuhan Rumah Tangga",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"Rp100"}}]
[null,"Telepon (Seluler)","Kebutuhan Rumah Tangga",{"v":60,"d":"Rp60"},{"v":60,"d":"Rp60"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":60,"d":"Rp60"}}]
[null,"Telepon (Rumah)","Kebutuhan Rumah Tangga",{"v":35,"d":"Rp35"},{"v":39,"d":"Rp39"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-4,"d":"-Rp4"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":39,"d":"Rp39"}}]
[null,"Perlengkapan","Kebutuhan Rumah Tangga",{"v":40,"d":"Rp40"},{"v":55,"d":"Rp55"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-15,"d":"-Rp15"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":55,"d":"Rp55"}}]
[null,"Pembuangan Sampah dan Daur Ulang","Kebutuhan Rumah Tangga",{"v":25,"d":"Rp25"},{"v":22,"d":"Rp22"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":3,"d":"Rp3"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":22,"d":"Rp22"}}]
[null,"Air dan Saluran Pembuangan","Kebutuhan Rumah Tangga",{"v":25,"d":"Rp25"},{"v":26,"d":"Rp26"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-1,"d":"-Rp1"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":26,"d":"Rp26"}}]
[null,"Kesehatan","Asuransi",{"v":400,"d":"Rp400"},{"v":400,"d":"Rp400"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":400,"d":"Rp400"}}]
[null,"Rumah","Asuransi",{"v":400,"d":"Rp400"},{"v":400,"d":"Rp400"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":400,"d":"Rp400"}}]
[null,"Asuransi Jiwa","Asuransi",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"Rp100"}}]
[null,"Kartu Kredit 1","Pinjaman",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":200,"d":"Rp200"}}]
[null,"Kartu Kredit 2","Pinjaman",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Kartu Kredit 3","Pinjaman",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pribadi","Pinjaman",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Siswa","Pinjaman",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pakaian","Perawatan Pribadi",{"v":150,"d":"Rp150"},{"v":140,"d":"Rp140"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":10,"d":"Rp10"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":140,"d":"Rp140"}}]
[null,"Penatu","Perawatan Pribadi",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Rambut/Kuku","Perawatan Pribadi",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Klub Kesehatan","Perawatan Pribadi",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Obat-obatan","Perawatan Pribadi",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Makanan","Peliharaan",{"v":150,"d":"Rp150"},{"v":75,"d":"Rp75"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":75,"d":"Rp75"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":75,"d":"Rp75"}}]
[null,"Perawatan","Peliharaan",{"v":20,"d":"Rp20"},{"v":25,"d":"Rp25"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-5,"d":"-Rp5"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":25,"d":"Rp25"}}]
[null,"Obat-obatan","Peliharaan",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Mainan","Peliharaan",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Rekening investasi","Tabungan atau Investasi",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":200,"d":"Rp200"}}]
[null,"Rekening pensiun","Tabungan atau Investasi",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pajak Provinsi","Pajak",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":300,"d":"Rp300"}}]
[null,"Pajak Lokal","Pajak",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pajak Negara","Pajak",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Biaya bus/taksi","Transportasi",{"v":100,"d":"Rp100"},{"v":150,"d":"Rp150"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":-50,"d":"-Rp50"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":150,"d":"Rp150"}}]
[null,"Bahan bakar","Transportasi",{"v":450,"d":"Rp450"},{"v":400,"d":"Rp400"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":400,"d":"Rp400"}}]
[null,"Asuransi","Transportasi",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":300,"d":"Rp300"}}]
[null,"Pelisensian ","Transportasi",{"v":25,"d":"Rp25"},{"v":25,"d":"Rp25"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":25,"d":"Rp25"}}]
[null,"Pemeliharaan","Transportasi",{"v":100,"d":"Rp100"},{"v":50,"d":"Rp50"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}}]
[null,"Biaya parkir","Transportasi",null,null,{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}}]
[null,"Pembayaran kendaraan","Transportasi",{"v":450,"d":"Rp450"},{"v":450,"d":"Rp450"},{"$f":"DetailAnggaran[[#This Row],[Proyeksi Biaya]]-DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"DetailAnggaran[[#This Row],[Biaya Aktual]]","v":{"v":450,"d":"Rp450"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,DetailAnggaran[Proyeksi Biaya])","v":{"v":7915,"d":"Rp7,915"}},{"$f":"SUBTOTAL(109,DetailAnggaran[Biaya Aktual])","v":{"v":7860,"d":"Rp7,860"}},{"$f":"SUBTOTAL(109,DetailAnggaran[Selisih])","v":{"v":55,"d":"Rp55"}}]

{"sheet":"Data Tambahan","index":3,"n_rows":15,"n_cols":5,"rows_kept":15}
["Gunakan lembar kerja ini untuk mengubah daftar menurun kolom Kategori pada tabel Detail Anggaran dalam lembar kerja Pengeluaran Bulanan. Untuk hal ini, ubah atau masukkan kategori baru dalam tabel Pencarian Kategori Anggaran yang dimulai dari sel E2. PivotTable yang tertaut ke bagan Gambaran Umum Anggaran dalam lembar kerja Laporan Anggaran Bulanan dimulai dari sel B2.","PivotTable untuk bagan Gambaran Umum Anggaran",null,null,"Daftar Pencarian untuk Kategori Detail Anggaran"]
[null,"Kategori","Biaya ",null,"Pencarian Kategori Anggaran"]
[null,"Anak",{"v":140,"d":"Rp140"},null,"Anak"]
[null,"Asuransi",{"v":900,"d":"Rp900"},null,"Hiburan"]
[null,"Hadiah dan Amal",{"v":125,"d":"Rp125"},null,"Makanan"]
[null,"Hiburan",{"v":358,"d":"Rp358"},null,"Hadiah dan Amal"]
[null,"Kebutuhan Rumah Tangga",{"v":2702,"d":"Rp2,702"},null,"Kebutuhan Rumah Tangga"]
[null,"Makanan",{"v":1320,"d":"Rp1,320"},null,"Asuransi"]
[null,"Pajak",{"v":300,"d":"Rp300"},null,"Pinjaman"]
[null,"Peliharaan",{"v":100,"d":"Rp100"},null,"Perawatan Pribadi"]
[null,"Perawatan Pribadi",{"v":140,"d":"Rp140"},null,"Peliharaan"]
[null,"Pinjaman",{"v":200,"d":"Rp200"},null,"Tabungan atau Investasi"]
[null,"Tabungan atau Investasi",{"v":200,"d":"Rp200"},null,"Pajak"]
[null,"Transportasi",{"v":1375,"d":"Rp1,375"},null,"Transportasi"]
[null,"Total Keseluruhan",{"v":7860,"d":"Rp7,860"}]