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

{"sheet":"Laporan Anggaran Bulanan","index":0,"n_rows":34,"n_cols":13,"rows_kept":34,"merged":[[7,1,10,1],[7,5,10,5],[7,6,10,6],[12,1,16,1],[12,5,16,5],[12,6,16,6]]}
[null,"Gambaran Umum Anggaran",{"$nulls":7},"Ringkasan Anggaran"]
[null,"Saldo"]
[null,"Proyeksi Saldo","(Proyeksi minus pengeluaran)",{"$nulls":3},{"$f":"D17-SUM(BudgetDetails[Proyeksi Biaya])","v":{"v":1585,"d":"Rp1,585"}}]
[null,"Saldo Aktual ","(Aktual minus pengeluaran)",{"$nulls":3},{"$f":"D11-SUM(BudgetDetails[Biaya Aktual])","v":{"v":1740,"d":"Rp1,740"}}]
[null,"Selisih","(Aktual minus proyeksi)",{"$nulls":3},{"$f":"G4-G3","v":{"v":155,"d":"Rp155"}}]
[]
[null,"Penghasilan",{"$nulls":3},"Pengeluaran",{"$nulls":3},"Klik kanan PivotTable di bawah ini lalu klik Refresh untuk memperbarui"]
[null,"AKTUAL","Penghasilan 1",{"v":5800,"d":"Rp5,800"},null,"AKTUAL",{"$f":"SUM(BudgetDetails[Biaya Aktual])","v":{"v":7860,"d":"Rp7,860"}}]
[null,null,"Penghasilan 2",{"v":2300,"d":"Rp2,300"},{"$nulls":5},"Kategori","Proyeksi Biaya ","Biaya Aktual ","Selisih "]
[null,null,"Penghasilan tambahan",{"v":1500,"d":"Rp1,500"},{"$nulls":5},"anak-anak",{"v":140,"d":"Rp140"},{"v":140,"d":"Rp140"},{"v":0,"d":"Rp0"}]
[null,null,"Total penghasilan",{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"Rp9,600"}}]
[{"$nulls":9},"Asuransi",{"v":900,"d":"Rp900"},{"v":900,"d":"Rp900"},{"v":0,"d":"Rp0"}]
[null,"PROYEKSI",{"$nulls":3},"PROYEKSI",{"$f":"SUM(BudgetDetails[Proyeksi Biaya])","v":{"v":7915,"d":"Rp7,915"}}]
[null,null,"Penghasilan 1",{"v":6000,"d":"Rp6,000"},{"$nulls":5},"Binatang Peliharaan",{"v":170,"d":"Rp170"},{"v":100,"d":"Rp100"},{"v":70,"d":"Rp70"}]
[null,null,"Penghasilan 2",{"v":1000,"d":"Rp1,000"}]
[null,null,"Penghasilan tambahan",{"v":2500,"d":"Rp2,500"},{"$nulls":5},"Hadiah dan Amal",{"v":100,"d":"Rp100"},{"v":125,"d":"Rp125"},{"v":-25,"d":"-Rp25"}]
[null,null,"Total penghasilan",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"Rp9,500"}}]
[{"$nulls":9},"Hiburan",{"v":400,"d":"Rp400"},{"v":358,"d":"Rp358"},{"v":42,"d":"Rp42"}]
[]
[{"$nulls":9},"Makanan",{"v":1100,"d":"Rp1,100"},{"v":1320,"d":"Rp1,320"},{"v":-220,"d":"-Rp220"}]
[]
[{"$nulls":9},"Pajak",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"v":0,"d":"Rp0"}]
[]
[{"$nulls":9},"Perawatan Pribadi",{"v":150,"d":"Rp150"},{"v":140,"d":"Rp140"},{"v":10,"d":"Rp10"}]
[]
[{"$nulls":9},"Pinjaman",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"v":0,"d":"Rp0"}]
[]
[{"$nulls":9},"Rumah",{"v":2830,"d":"Rp2,830"},{"v":2702,"d":"Rp2,702"},{"v":128,"d":"Rp128"}]
[]
[{"$nulls":9},"Tabungan atau Investasi",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"v":0,"d":"Rp0"}]
[]
[{"$nulls":9},"transportasi",{"v":1425,"d":"Rp1,425"},{"v":1375,"d":"Rp1,375"},{"v":50,"d":"Rp50"}]
[]
[{"$nulls":9},"Total Keseluruhan",{"v":7915,"d":"Rp7,915"},{"v":7860,"d":"Rp7,860"},{"v":55,"d":"Rp55"}]

{"sheet":"Pengeluaran Bulanan","index":1,"n_rows":62,"n_cols":7,"rows_kept":62}
[null,"Pengeluaran Bulanan"]
[null,"Deskripsi","Kategori","Proyeksi Biaya","Biaya Aktual","Selisih","Gambaran Umum Biaya Aktual"]
[null,"Aktivitas ekstrakurikuler","anak-anak",{"v":40,"d":"Rp40"},{"v":40,"d":"Rp40"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":40,"d":"$40"}}]
[null,"Obat-obatan","anak-anak",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Perbekalan Sekolah","anak-anak",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Biaya Sekolah","anak-anak",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"$100"}}]
[null,"Konser","Hiburan",{"v":50,"d":"Rp50"},{"v":40,"d":"Rp40"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":10,"d":"Rp10"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":40,"d":"$40"}}]
[null,"Teater Live","Hiburan",{"v":200,"d":"Rp200"},{"v":150,"d":"Rp150"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":150,"d":"$150"}}]
[null,"Film","Hiburan",{"v":50,"d":"Rp50"},{"v":28,"d":"Rp28"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":22,"d":"Rp22"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":28,"d":"$28"}}]
[null,"Musik (CD, unduhan, dll.)","Hiburan",{"v":50,"d":"Rp50"},{"v":30,"d":"Rp30"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":20,"d":"Rp20"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":30,"d":"$30"}}]
[null,"Acara Olahraga","Hiburan",{"v":0,"d":"Rp0"},{"v":40,"d":"Rp40"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-40,"d":"(Rp40)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":40,"d":"$40"}}]
[null,"Video/DVD (Beli)","Hiburan",{"v":20,"d":"Rp20"},{"v":50,"d":"Rp50"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-30,"d":"(Rp30)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"$50"}}]
[null,"Video/DVD (Sewa)","Hiburan",{"v":30,"d":"Rp30"},{"v":20,"d":"Rp20"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":10,"d":"Rp10"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":20,"d":"$20"}}]
[null,"Makan di Luar","Makanan",{"v":1000,"d":"Rp1,000"},{"v":1200,"d":"Rp1,200"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-200,"d":"(Rp200)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":1200,"d":"$1,200"}}]
[null,"Bahan Makanan","Makanan",{"v":100,"d":"Rp100"},{"v":120,"d":"Rp120"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-20,"d":"(Rp20)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":120,"d":"$120"}}]
[null,"Amal 1","Hadiah dan Amal",{"v":75,"d":"Rp75"},{"v":100,"d":"Rp100"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-25,"d":"(Rp25)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"$100"}}]
[null,"Amal 2","Hadiah dan Amal",{"v":25,"d":"Rp25"},{"v":25,"d":"Rp25"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":25,"d":"$25"}}]
[null,"Hadiah 1","Hadiah dan Amal",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Hadiah 2","Hadiah dan Amal",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"TV Kabel/Satelit","Rumah",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"$100"}}]
[null,"Listrik","Rumah",{"v":45,"d":"Rp45"},{"v":50,"d":"Rp50"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-5,"d":"(Rp5)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"$50"}}]
[null,"Gas","Rumah",{"v":300,"d":"Rp300"},{"v":400,"d":"Rp400"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-100,"d":"(Rp100)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":400,"d":"$400"}}]
[null,"Layanan Pembersihan Rumah","Rumah",{"v":200,"d":"Rp200"},null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":200,"d":"Rp200"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Pemeliharaan","Rumah",{"v":200,"d":"Rp200"},{"v":150,"d":"Rp150"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":150,"d":"$150"}}]
[null,"Hipotek atau Sewa","Rumah",{"v":1700,"d":"Rp1,700"},{"v":1700,"d":"Rp1,700"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":1700,"d":"$1,700"}}]
[null,"Gas alam/minyak","Rumah",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Layanan Online/Internet","Rumah",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"$100"}}]
[null,"Telepon (Seluler)","Rumah",{"v":60,"d":"Rp60"},{"v":60,"d":"Rp60"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":60,"d":"$60"}}]
[null,"Telepon (Rumah)","Rumah",{"v":35,"d":"Rp35"},{"v":39,"d":"Rp39"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-4,"d":"(Rp4)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":39,"d":"$39"}}]
[null,"Persediaan","Rumah",{"v":40,"d":"Rp40"},{"v":55,"d":"Rp55"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-15,"d":"(Rp15)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":55,"d":"$55"}}]
[null,"Pembuangan Limbah dan Daur Ulang","Rumah",{"v":25,"d":"Rp25"},{"v":22,"d":"Rp22"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":3,"d":"Rp3"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":22,"d":"$22"}}]
[null,"Air dan Selokan","Rumah",{"v":25,"d":"Rp25"},{"v":26,"d":"Rp26"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-1,"d":"(Rp1)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":26,"d":"$26"}}]
[null,"Kesehatan","Asuransi",{"v":400,"d":"Rp400"},{"v":400,"d":"Rp400"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":400,"d":"$400"}}]
[null,"Home","Asuransi",{"v":400,"d":"Rp400"},{"v":400,"d":"Rp400"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":400,"d":"$400"}}]
[null,"Jiwa","Asuransi",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":100,"d":"$100"}}]
[null,"Kartu Kredit 1","Pinjaman",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":200,"d":"$200"}}]
[null,"Kartu Kredit 2","Pinjaman",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Kartu Kredit 3","Pinjaman",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Pribadi","Pinjaman",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Mahasiswa","Pinjaman",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Pakaian","Perawatan Pribadi",{"v":150,"d":"Rp150"},{"v":140,"d":"Rp140"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":10,"d":"Rp10"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":140,"d":"$140"}}]
[null,"Cuci Kering","Perawatan Pribadi",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Rambut/Kuku","Perawatan Pribadi",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Klub Kesehatan","Perawatan Pribadi",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Obat-obatan","Perawatan Pribadi",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Makanan","Binatang Peliharaan",{"v":150,"d":"Rp150"},{"v":75,"d":"Rp75"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":75,"d":"Rp75"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":75,"d":"$75"}}]
[null,"Penampilan","Binatang Peliharaan",{"v":20,"d":"Rp20"},{"v":25,"d":"Rp25"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-5,"d":"(Rp5)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":25,"d":"$25"}}]
[null,"Obat-obatan","Binatang Peliharaan",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Mainan","Binatang Peliharaan",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Rekening investasi","Tabungan atau Investasi",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":200,"d":"$200"}}]
[null,"Rekening pensiun","Tabungan atau Investasi",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Pemerintah Pusat","Pajak",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":300,"d":"$300"}}]
[null,"Daerah","Pajak",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Provinsi","Pajak",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Ongkos Bus/Taksi","transportasi",{"v":100,"d":"Rp100"},{"v":150,"d":"Rp150"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":-50,"d":"(Rp50)"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":150,"d":"$150"}}]
[null,"Bahan Bakar","transportasi",{"v":450,"d":"Rp450"},{"v":400,"d":"Rp400"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":400,"d":"$400"}}]
[null,"Asuransi","transportasi",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":300,"d":"$300"}}]
[null,"Perizinan ","transportasi",{"v":25,"d":"Rp25"},{"v":25,"d":"Rp25"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":25,"d":"$25"}}]
[null,"Pemeliharaan","transportasi",{"v":100,"d":"Rp100"},{"v":50,"d":"Rp50"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"Rp50"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":50,"d":"$50"}}]
[null,"Biaya parkir","transportasi",null,null,{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"$0"}}]
[null,"Pembayaran kendaraan","transportasi",{"v":450,"d":"Rp450"},{"v":450,"d":"Rp450"},{"$f":"BudgetDetails[[#This Row],[Proyeksi Biaya]]-BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":0,"d":"Rp0"}},{"$f":"BudgetDetails[[#This Row],[Biaya Aktual]]","v":{"v":450,"d":"$450"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,BudgetDetails[Proyeksi Biaya])","v":{"v":7915,"d":"Rp7,915"}},{"$f":"SUBTOTAL(109,BudgetDetails[Biaya Aktual])","v":{"v":7860,"d":"Rp7,860"}},{"$f":"SUBTOTAL(109,BudgetDetails[Selisih])","v":{"v":55,"d":"Rp55"}}]

{"sheet":"Data Tambahan","index":2,"n_rows":15,"n_cols":5,"rows_kept":15}
[null,"PivotTable untuk bagan Gambaran Umum Anggaran",null,null,"Daftar Pencarian untuk Kategori Detail Anggaran"]
[null,"Kategori","Biaya",null,"Pencarian Kategori Anggaran"]
[null,"anak-anak",140,null,"anak-anak"]
[null,"Asuransi",900,null,"Hiburan"]
[null,"Binatang Peliharaan",100,null,"Makanan"]
[null,"Hadiah dan Amal",125,null,"Hadiah dan Amal"]
[null,"Hiburan",358,null,"Rumah"]
[null,"Makanan",1320,null,"Asuransi"]
[null,"Pajak",300,null,"Pinjaman"]
[null,"Perawatan Pribadi",140,null,"Perawatan Pribadi"]
[null,"Pinjaman",200,null,"Binatang Peliharaan"]
[null,"Rumah",2702,null,"Tabungan atau Investasi"]
[null,"Tabungan atau Investasi",200,null,"Pajak"]
[null,"transportasi",1375,null,"transportasi"]
[null,"Total Keseluruhan",7860]