{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Arus Kas","Pendapatan Bulanan","Pengeluaran Bulanan","Data Bagan"],"not_rendered":{"charts":1,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Arus Kas","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," Nama Keluarga"]
[null,"Anggaran Keluarga"]
[null,{"$f":"\" Untuk Bulan \" & TEXT(TODAY(),\"mmmm yyyy\")","v":" Untuk Bulan September 2021"}]
[]
[]
[null,"Analisis Arus Kas"]
[]
[]
[null," ","Perkiraan","Aktual","Selisih"]
[{"$f":"Pendapatan[[#Totals],[Selisih]]","v":{"v":300,"d":"Rp300.00"}},"Total Pendapatan",{"$f":"Pendapatan[[#Totals],[Perkiraan]]","v":{"v":5700,"d":"Rp5,700"}},{"$f":"Pendapatan[[#Totals],[Aktual]]","v":{"v":6000,"d":"Rp6,000"}},{"$f":"A12","v":{"v":300,"d":"Rp300"}}]
[{"$f":"Pengeluaran[[#Totals],[Selisih]]","v":-52},"Total Pengeluaran",{"$f":"Pengeluaran[[#Totals],[Perkiraan]]","v":{"v":3603,"d":"Rp3,603"}},{"$f":"Pengeluaran[[#Totals],[Aktual]]","v":{"v":3655,"d":"Rp3,655"}},{"$f":"A13","v":{"v":-52,"d":"-Rp52"}}]
[null,"Total Kas",{"$f":"C12-C13","v":{"v":2097,"d":"Rp2,097"}},{"$f":"D12-D13","v":{"v":2345,"d":"Rp2,345"}},{"$f":"SUBTOTAL(109,ArusKas[Selisih])","v":{"v":248,"d":"Rp248"}}]

{"sheet":"Pendapatan Bulanan","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"Pendapatan Bulanan"]
[]
[]
[null," ","Perkiraan","Aktual","Selisih"]
[null,"Pendapatan 1",{"v":4000,"d":"Rp4,000.00"},{"v":4000,"d":"Rp4,000.00"},{"$f":"Pendapatan[[#This Row],[Aktual]]-Pendapatan[[#This Row],[Perkiraan]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pendapatan 2",{"v":1400,"d":"Rp1,400.00"},{"v":1500,"d":"Rp1,500.00"},{"$f":"Pendapatan[[#This Row],[Aktual]]-Pendapatan[[#This Row],[Perkiraan]]","v":{"v":100,"d":"Rp100.00"}}]
[null,"Pendapatan Lainnya",{"v":300,"d":"Rp300.00"},{"v":500,"d":"Rp500.00"},{"$f":"Pendapatan[[#This Row],[Aktual]]-Pendapatan[[#This Row],[Perkiraan]]","v":{"v":200,"d":"Rp200.00"}}]
[null,"Total Pendapatan",{"$f":"SUBTOTAL(109,Pendapatan[Perkiraan])","v":{"v":5700,"d":"Rp5,700.00"}},{"$f":"SUBTOTAL(109,Pendapatan[Aktual])","v":{"v":6000,"d":"Rp6,000.00"}},{"$f":"SUBTOTAL(109,Pendapatan[Selisih])","v":{"v":300,"d":"Rp300.00"}}]

{"sheet":"Pengeluaran Bulanan","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"Pengeluaran Bulanan"]
[]
[]
[null," ","Perkiraan","Aktual","Selisih"]
[null,"Perumahan",{"v":1500,"d":"Rp1,500.00"},{"v":1500,"d":"Rp1,500.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Bahan Makanan",{"v":250,"d":"Rp250.00"},{"v":280,"d":"Rp280.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-30,"d":"-Rp30.00"}}]
[null,"Telepon",{"v":38,"d":"Rp38.00"},{"v":38,"d":"Rp38.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Listrik / Gas",{"v":65,"d":"Rp65.00"},{"v":78,"d":"Rp78.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-13,"d":"-Rp13.00"}}]
[null,"Air / Saluran Pembuangan / Sampah",{"v":25,"d":"Rp25.00"},{"v":21,"d":"Rp21.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":4,"d":"Rp4.00"}}]
[null,"TV Kabel",{"v":75,"d":"Rp75.00"},{"v":83,"d":"Rp83.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-8,"d":"-Rp8.00"}}]
[null,"Internet",{"v":60,"d":"Rp60.00"},{"v":60,"d":"Rp60.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pemeliharaan / Perbaikan",{"v":0,"d":"Rp0.00"},{"v":60,"d":"Rp60.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-60,"d":"-Rp60.00"}}]
[null,"Penitipan Anak",{"v":180,"d":"Rp180.00"},{"v":150,"d":"Rp150.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":30,"d":"Rp30.00"}}]
[null,"Biaya Pendidikan",{"v":250,"d":"Rp250.00"},{"v":250,"d":"Rp250.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Binatang Peliharaan",{"v":75,"d":"Rp75.00"},{"v":80,"d":"Rp80.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-5,"d":"-Rp5.00"}}]
[null,"Transportasi",{"v":280,"d":"Rp280.00"},{"v":260,"d":"Rp260.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":20,"d":"Rp20.00"}}]
[null,"Perawatan Pribadi",{"v":75,"d":"Rp75.00"},{"v":65,"d":"Rp65.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":10,"d":"Rp10.00"}}]
[null,"Asuransi",{"v":255,"d":"Rp255.00"},{"v":255,"d":"Rp255.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Kartu Kredit",{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pinjaman",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pajak",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Hadiah / Amal",{"v":150,"d":"Rp150.00"},{"v":150,"d":"Rp150.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Tabungan",{"v":225,"d":"Rp225.00"},{"v":225,"d":"Rp225.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Lainnya",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$f":"Pengeluaran[[#This Row],[Perkiraan]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Pengeluaran[Perkiraan])","v":{"v":3603,"d":"Rp3,603.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[Aktual])","v":{"v":3655,"d":"Rp3,655.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[Selisih])","v":{"v":-52,"d":"-Rp52.00"}}]

{"sheet":"Data Bagan","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Data Bagan"]
[]
[null,null,"Perkiraan","Aktual"]
[null,"Pendapatan Bulanan",{"$f":"Pendapatan[[#Totals],[Perkiraan]]","v":5700},{"$f":"Pendapatan[[#Totals],[Aktual]]","v":6000}]
[null,"Pengeluaran Bulanan",{"$f":"Pengeluaran[[#Totals],[Perkiraan]]","v":3603},{"$f":"Pengeluaran[[#Totals],[Aktual]]","v":3655}]
[null,"Arus Kas",{"$f":"ArusKas[[#Totals],[Perkiraan]]","v":2097},{"$f":"ArusKas[[#Totals],[Aktual]]","v":2345}]