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

{"sheet":"Gambaran Umum Anggaran","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[{"$nulls":7}," "]
[null,"Saldo"]
[null,"Proyeksi Saldo",null,{"$f":"Penghasilan_Proyeksi-Pengeluaran_Proyeksi","v":{"v":1585,"d":"Rp1,585"}},null,"Proyeksi dikurangi pengeluaran"]
[null,"Saldo Aktual ",null,{"$f":"Penghasilan_Aktual-Pengeluaran_Aktual","v":{"v":1740,"d":"Rp1,740"}},null,"Aktual dikurangi pengeluaran"]
[null,"Selisih",null,{"$f":"D4-D3","v":{"v":155,"d":"Rp155"}},null,"Aktual dikurangi proyeksi"]
[null,"Pendapatan",{"$nulls":3},"Pengeluaran"]
[null,null,"Proyeksi","Aktual",null,"Proyeksi","Aktual"]
[null,"Pendapatan 1",{"v":6000,"d":"Rp6,000"},{"v":5800,"d":"Rp5,800"},null,{"$f":"SUM(Tabel_Pengeluaran_Bulanan[Proyeksi Biaya])","v":{"v":7915,"d":"Rp7,915"}},{"$f":"SUM(Tabel_Pengeluaran_Bulanan[Biaya Aktual])","v":{"v":7860,"d":"Rp7,860"}}]
[null,"Pendapatan 2",{"v":1000,"d":"Rp1,000"},{"v":2300,"d":"Rp2,300"}]
[null,"Pendapatan tambahan",{"v":2500,"d":"Rp2,500"},{"v":1500,"d":"Rp1,500"}]
[null,"Total Pendapatan",{"$f":"SUM(C8:C10)","v":{"v":9500,"d":"Rp9,500"}},{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"Rp9,600"}}]
[null,"Perincian Pengeluaran Aktual"]

{"sheet":"Ringkasan Anggaran","index":1,"n_rows":41,"n_cols":7,"rows_kept":41}
[null,"Ringkasan Anggaran",{"$nulls":4}," "]
[]
[null,"Label Baris","Proyeksi Biaya ","Biaya Aktual ","Selisih "]
[null,"Anak",{"v":140,"d":"Rp140"},{"v":140,"d":"Rp140"},{"v":0,"d":"Rp0"}]
[null,"Biaya Sekolah",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"v":0,"d":"Rp0"}]
[null,"Kegiatan Ekstrakurikuler",{"v":40,"d":"Rp40"},{"v":40,"d":"Rp40"},{"v":0,"d":"Rp0"}]
[null,"Obat-obatan",null,null,{"v":0,"d":"Rp0"}]
[null,"Perlengkapan Sekolah",null,null,{"v":0,"d":"Rp0"}]
[]
[null,"Hiburan",{"v":400,"d":"Rp400"},{"v":358,"d":"Rp358"},{"v":42,"d":"Rp42"}]
[null,"Acara Olahraga",{"v":0,"d":"Rp0"},{"v":40,"d":"Rp40"},{"v":-40,"d":"-Rp40"}]
[null,"Film",{"v":50,"d":"Rp50"},{"v":28,"d":"Rp28"},{"v":22,"d":"Rp22"}]
[null,"Konser",{"v":50,"d":"Rp50"},{"v":40,"d":"Rp40"},{"v":10,"d":"Rp10"}]
[null,"Musik (CD, Unduhan, dll.)",{"v":50,"d":"Rp50"},{"v":30,"d":"Rp30"},{"v":20,"d":"Rp20"}]
[null,"Pertunjukan Teater",{"v":200,"d":"Rp200"},{"v":150,"d":"Rp150"},{"v":50,"d":"Rp50"}]
[null,"Video/DVD (Pembelian)",{"v":20,"d":"Rp20"},{"v":50,"d":"Rp50"},{"v":-30,"d":"-Rp30"}]
[null,"Video/DVD (Penyewaan)",{"v":30,"d":"Rp30"},{"v":20,"d":"Rp20"},{"v":10,"d":"Rp10"}]
[]
[null,"Asuransi",{"v":900,"d":"Rp900"},{"v":900,"d":"Rp900"},{"v":0,"d":"Rp0"}]
[]
[null,"Binatang Peliharaan",{"v":170,"d":"Rp170"},{"v":100,"d":"Rp100"},{"v":70,"d":"Rp70"}]
[]
[null,"Hadiah dan Amal",{"v":100,"d":"Rp100"},{"v":125,"d":"Rp125"},{"v":-25,"d":"-Rp25"}]
[]
[null,"Kebutuhan Rumah Tangga",{"v":2830,"d":"Rp2,830"},{"v":2702,"d":"Rp2,702"},{"v":-72,"d":"-Rp72"}]
[]
[null,"Makanan",{"v":1100,"d":"Rp1,100"},{"v":1320,"d":"Rp1,320"},{"v":-220,"d":"-Rp220"}]
[]
[null,"Pajak",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"v":0,"d":"Rp0"}]
[]
[null,"Perawatan Pribadi",{"v":150,"d":"Rp150"},{"v":140,"d":"Rp140"},{"v":10,"d":"Rp10"}]
[]
[null,"Pinjaman",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"v":0,"d":"Rp0"}]
[]
[null,"Transportasi",{"v":1425,"d":"Rp1,425"},{"v":1375,"d":"Rp1,375"},{"v":50,"d":"Rp50"}]
[]
[null,"Tabungan",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"v":0,"d":"Rp0"}]
[null,"Rekening Investasi",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"v":0,"d":"Rp0"}]
[null,"Rekening Pensiun",null,null,{"v":0,"d":"Rp0"}]
[]
[null,"Total Keseluruhan",{"v":7915,"d":"Rp7,915"},{"v":7860,"d":"Rp7,860"},{"v":-145,"d":"-Rp145"}]

{"sheet":"Pengeluaran Bulanan","index":2,"n_rows":61,"n_cols":8,"rows_kept":61}
[{"$nulls":7}," "]
[null,"Deskripsi","Kategori","Proyeksi Biaya","Biaya Aktual","Selisih","Gambaran Umum Biaya Aktual"]
[null,"Kegiatan Ekstrakurikuler","Anak",{"v":40,"d":"Rp40"},{"v":40,"d":"Rp40"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":40}]
[null,"Obat-obatan","Anak",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Perlengkapan Sekolah","Anak",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Biaya Sekolah","Anak",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":100}]
[null,"Konser","Hiburan",{"v":50,"d":"Rp50"},{"v":40,"d":"Rp40"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":10,"d":"Rp10"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":40}]
[null,"Pertunjukan Teater","Hiburan",{"v":200,"d":"Rp200"},{"v":150,"d":"Rp150"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":50,"d":"Rp50"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":150}]
[null,"Film","Hiburan",{"v":50,"d":"Rp50"},{"v":28,"d":"Rp28"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":22,"d":"Rp22"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":28}]
[null,"Musik (CD, Unduhan, dll.)","Hiburan",{"v":50,"d":"Rp50"},{"v":30,"d":"Rp30"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":20,"d":"Rp20"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":30}]
[null,"Acara Olahraga","Hiburan",{"v":0,"d":"Rp0"},{"v":40,"d":"Rp40"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-40,"d":"-Rp40"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":40}]
[null,"Video/DVD (Pembelian)","Hiburan",{"v":20,"d":"Rp20"},{"v":50,"d":"Rp50"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-30,"d":"-Rp30"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":50}]
[null,"Video/DVD (Penyewaan)","Hiburan",{"v":30,"d":"Rp30"},{"v":20,"d":"Rp20"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":10,"d":"Rp10"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":20}]
[null,"Makan di Restoran","Makanan",{"v":1000,"d":"Rp1,000"},{"v":1200,"d":"Rp1,200"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-200,"d":"-Rp200"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":1200}]
[null,"Belanja","Makanan",{"v":100,"d":"Rp100"},{"v":120,"d":"Rp120"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-20,"d":"-Rp20"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":120}]
[null,"Amal 1","Hadiah dan Amal",{"v":75,"d":"Rp75"},{"v":100,"d":"Rp100"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-25,"d":"-Rp25"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":100}]
[null,"Amal 2","Hadiah dan Amal",{"v":25,"d":"Rp25"},{"v":25,"d":"Rp25"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":25}]
[null,"Hadiah 1","Hadiah dan Amal",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Hadiah 2","Hadiah dan Amal",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"TV Kabel/Satelit","Kebutuhan Rumah Tangga",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":100}]
[null,"Listrik","Kebutuhan Rumah Tangga",{"v":45,"d":"Rp45"},{"v":50,"d":"Rp50"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-5,"d":"-Rp5"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":50}]
[null,"Bahan Bakar","Kebutuhan Rumah Tangga",{"v":300,"d":"Rp300"},{"v":400,"d":"Rp400"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-100,"d":"-Rp100"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":400}]
[null,"Layanan Kebersihan Rumah","Kebutuhan Rumah Tangga",{"v":200,"d":"Rp200"},null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Pemeliharaan","Kebutuhan Rumah Tangga",{"v":200,"d":"Rp200"},{"v":150,"d":"Rp150"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":50,"d":"Rp50"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":150}]
[null,"Hipotek atau Sewa","Kebutuhan Rumah Tangga",{"v":1700,"d":"Rp1,700"},{"v":1700,"d":"Rp1,700"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":1700}]
[null,"Minyak/Gas Alam","Kebutuhan Rumah Tangga",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Layanan Internet/Online","Kebutuhan Rumah Tangga",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":100}]
[null,"Telepon (Seluler)","Kebutuhan Rumah Tangga",{"v":60,"d":"Rp60"},{"v":60,"d":"Rp60"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":60}]
[null,"Telepon (Rumah)","Kebutuhan Rumah Tangga",{"v":35,"d":"Rp35"},{"v":39,"d":"Rp39"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-4,"d":"-Rp4"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":39}]
[null,"Perlengkapan","Kebutuhan Rumah Tangga",{"v":40,"d":"Rp40"},{"v":55,"d":"Rp55"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-15,"d":"-Rp15"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":55}]
[null,"Pembuangan Sampah dan Daur Ulang","Kebutuhan Rumah Tangga",{"v":25,"d":"Rp25"},{"v":22,"d":"Rp22"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":3,"d":"Rp3"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":22}]
[null,"Air dan Saluran Pembuangan","Kebutuhan Rumah Tangga",{"v":25,"d":"Rp25"},{"v":26,"d":"Rp26"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-1,"d":"-Rp1"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":26}]
[null,"Kesehatan","Asuransi",{"v":400,"d":"Rp400"},{"v":400,"d":"Rp400"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":400}]
[null,"Rumah","Asuransi",{"v":400,"d":"Rp400"},{"v":400,"d":"Rp400"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":400}]
[null,"Asuransi Jiwa","Asuransi",{"v":100,"d":"Rp100"},{"v":100,"d":"Rp100"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":100}]
[null,"Kartu Kredit 1","Pinjaman",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":200}]
[null,"Kartu Kredit 2","Pinjaman",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Kartu Kredit 3","Pinjaman",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Pribadi","Pinjaman",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Siswa","Pinjaman",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Pakaian","Perawatan Pribadi",{"v":150,"d":"Rp150"},{"v":140,"d":"Rp140"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":10,"d":"Rp10"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":140}]
[null,"Penatu","Perawatan Pribadi",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Rambut/Kuku","Perawatan Pribadi",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Klub Kesehatan","Perawatan Pribadi",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Obat-obatan","Perawatan Pribadi",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Makanan","Binatang Peliharaan",{"v":150,"d":"Rp150"},{"v":75,"d":"Rp75"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":75,"d":"Rp75"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":75}]
[null,"Perawatan","Binatang Peliharaan",{"v":20,"d":"Rp20"},{"v":25,"d":"Rp25"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-5,"d":"-Rp5"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":25}]
[null,"Obat-obatan","Binatang Peliharaan",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Mainan","Binatang Peliharaan",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Rekening Investasi","Tabungan",{"v":200,"d":"Rp200"},{"v":200,"d":"Rp200"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":200}]
[null,"Rekening Pensiun","Tabungan",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Pajak Provinsi","Pajak",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":300}]
[null,"Pajak Lokal","Pajak",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Pajak Negara","Pajak",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Biaya Bus/Taksi","Transportasi",{"v":100,"d":"Rp100"},{"v":150,"d":"Rp150"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":-50,"d":"-Rp50"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":150}]
[null,"Bahan Bakar","Transportasi",{"v":450,"d":"Rp450"},{"v":400,"d":"Rp400"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":50,"d":"Rp50"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":400}]
[null,"Asuransi","Transportasi",{"v":300,"d":"Rp300"},{"v":300,"d":"Rp300"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":300}]
[null,"Pelisensian ","Transportasi",{"v":25,"d":"Rp25"},{"v":25,"d":"Rp25"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":25}]
[null,"Pemeliharaan","Transportasi",{"v":100,"d":"Rp100"},{"v":50,"d":"Rp50"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":50,"d":"Rp50"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":50}]
[null,"Biaya Parkir","Transportasi",null,null,{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":""},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":0}]
[null,"Pembayaran Kendaraan","Transportasi",{"v":450,"d":"Rp450"},{"v":450,"d":"Rp450"},{"$f":"IF(OR(Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]=\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]=\"\"),\"\",Tabel_Pengeluaran_Bulanan[[#This Row],[Proyeksi Biaya]]-Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]])","v":{"v":0,"d":"Rp0"}},{"$f":"Tabel_Pengeluaran_Bulanan[[#This Row],[Biaya Aktual]]","v":450}]

{"sheet":"Data Tambahan","index":3,"n_rows":17,"n_cols":6,"rows_kept":17}
[{"$nulls":5}," "]
[null,"PivotTable untuk Bagan Anggaran",null,null,"Daftar Kategori"]
[]
[null,"Kategori","Biaya",null,"Untuk menambahkan kategori, ketik di bawah ini"]
[null,"Binatang Peliharaan",{"v":100,"d":"Rp100"},null,"Anak"]
[null,"Hadiah dan Amal",{"v":125,"d":"Rp125"},null,"Hiburan"]
[null,"Anak",{"v":140,"d":"Rp140"},null,"Makanan"]
[null,"Perawatan Pribadi",{"v":140,"d":"Rp140"},null,"Hadiah dan Amal"]
[null,"Tabungan",{"v":200,"d":"Rp200"},null,"Kebutuhan Rumah Tangga"]
[null,"Pinjaman",{"v":200,"d":"Rp200"},null,"Asuransi"]
[null,"Pajak",{"v":300,"d":"Rp300"},null,"Pinjaman"]
[null,"Hiburan",{"v":358,"d":"Rp358"},null,"Perawatan Pribadi"]
[null,"Asuransi",{"v":900,"d":"Rp900"},null,"Binatang Peliharaan"]
[null,"Makanan",{"v":1320,"d":"Rp1,320"},null,"Tabungan"]
[null,"Transportasi",{"v":1375,"d":"Rp1,375"},null,"Pajak"]
[null,"Kebutuhan Rumah Tangga",{"v":2702,"d":"Rp2,702"},null,"Transportasi"]
[null,"Total Keseluruhan",{"v":7860,"d":"Rp7,860"}]