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

{"sheet":"Arus Kas","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"Nama"]
[null,"Anggaran Keluarga"]
[null,{"$f":"TEXT(TODAY(),\"mmmm\")","v":"Januari"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"Catatan: Tabel arus kas dihitung secara otomatis berdasarkan masukan dari tabel Pendapatan Bulanan dan Pengeluaran Bulanan"]
[null,"Arus Kas","Proyeksi","Aktual","Varians"]
[null,"Total Pendapatan",{"$f":"Pendapatan[[#Totals],[Proyeksi]]","v":{"v":5700000,"d":"5,700,000"}},{"$f":"Pendapatan[[#Totals],[Aktual]]","v":{"v":19000000,"d":"19,000,000"}},{"$f":"Pendapatan[[#Totals],[Varians]]","v":{"v":13300000,"d":"13,300,000"}}]
[null,"Total Pengeluaran",{"$f":"Pengeluaran[[#Totals],[Proyeksi]]","v":{"v":3603000,"d":"3,603,000"}},{"$f":"Pengeluaran[[#Totals],[Aktual]]","v":{"v":3655000,"d":"3,655,000"}},{"$f":"Pengeluaran[[#Totals],[Varians]]","v":{"v":-52000,"d":"-52,000"}}]
[null,"Total Kas",{"$f":"C7-C8","v":{"v":2097000,"d":"2,097,000"}},{"$f":"D7-D8","v":{"v":15345000,"d":"15,345,000"}},{"$f":"SUBTOTAL(109,ArusKas[Varians])","v":{"v":13248000,"d":"13,248,000"}}]

{"sheet":"Pendapatan Bulanan","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"Nama","v":"Nama"}]
[null,{"$f":"JudulAnggaran","v":"Anggaran Keluarga"}]
[null,{"$f":"Bulan","v":"Januari"}]
[null,{"$f":"Tahun","v":2017}]
[null,"Pendapatan Bulanan","Proyeksi","Aktual","Varians"]
[null,"Pendapatan 1",{"v":4000000,"d":"4,000,000"},{"v":4000000,"d":"4,000,000"},{"$f":"Pendapatan[[#This Row],[Aktual]]-Pendapatan[[#This Row],[Proyeksi]]","v":0}]
[null,"Pendapatan 2",{"v":1400000,"d":"1,400,000"},{"v":15000000,"d":"15,000,000"},{"$f":"Pendapatan[[#This Row],[Aktual]]-Pendapatan[[#This Row],[Proyeksi]]","v":{"v":13600000,"d":"13,600,000"}}]
[null,"Pendapatan Lainnya",{"v":300000,"d":"300,000"},0,{"$f":"Pendapatan[[#This Row],[Aktual]]-Pendapatan[[#This Row],[Proyeksi]]","v":{"v":-300000,"d":"-300,000"}}]
[null,"Total Pendapatan",{"$f":"SUBTOTAL(109,Pendapatan[Proyeksi])","v":{"v":5700000,"d":"5,700,000"}},{"$f":"SUBTOTAL(109,Pendapatan[Aktual])","v":{"v":19000000,"d":"19,000,000"}},{"$f":"SUBTOTAL(109,Pendapatan[Varians])","v":{"v":13300000,"d":"13,300,000"}}]

{"sheet":"Pengeluaran Bulanan","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"Nama","v":"Nama"}]
[null,{"$f":"JudulAnggaran","v":"Anggaran Keluarga"}]
[null,{"$f":"Bulan","v":"Januari"}]
[null,{"$f":"Tahun","v":2017}]
[null,"Pengeluaran Bulanan","Proyeksi","Aktual","Varians"]
[null,"Perumahan",{"v":1500000,"d":"1,500,000"},{"v":1500000,"d":"1,500,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Bahan Makanan",{"v":250000,"d":"250,000"},{"v":280000,"d":"280,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-30000,"d":"-30,000"}}]
[null,"Telepon",{"v":38000,"d":"38,000"},{"v":38000,"d":"38,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Listrik / Gas",{"v":65000,"d":"65,000"},{"v":78000,"d":"78,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-13000,"d":"-13,000"}}]
[null,"Air / Saluran Pembuangan / Sampah",{"v":25000,"d":"25,000"},{"v":21000,"d":"21,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":4000,"d":"4,000"}}]
[null,"TV Kabel",{"v":75000,"d":"75,000"},{"v":83000,"d":"83,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-8000,"d":"-8,000"}}]
[null,"Internet",{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Pemeliharaan / Perbaikan",0,{"v":60000,"d":"60,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-60000,"d":"-60,000"}}]
[null,"Penitipan Anak",{"v":180000,"d":"180,000"},{"v":150000,"d":"150,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":30000,"d":"30,000"}}]
[null,"Biaya Pendidikan",{"v":250000,"d":"250,000"},{"v":250000,"d":"250,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Binatang Peliharaan",{"v":75000,"d":"75,000"},{"v":80000,"d":"80,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":-5000,"d":"-5,000"}}]
[null,"Transportasi",{"v":280000,"d":"280,000"},{"v":260000,"d":"260,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":20000,"d":"20,000"}}]
[null,"Perawatan Pribadi",{"v":75000,"d":"75,000"},{"v":65000,"d":"65,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":{"v":10000,"d":"10,000"}}]
[null,"Asuransi",{"v":255000,"d":"255,000"},{"v":255000,"d":"255,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Kartu Kredit",{"v":100000,"d":"100,000"},{"v":100000,"d":"100,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Pinjaman",0,0,{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Pajak",0,0,{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Hadiah / Amal",{"v":150000,"d":"150,000"},{"v":150000,"d":"150,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Tabungan",{"v":225000,"d":"225,000"},{"v":225000,"d":"225,000"},{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Lainnya",0,0,{"$f":"Pengeluaran[[#This Row],[Proyeksi]]-Pengeluaran[[#This Row],[Aktual]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Pengeluaran[Proyeksi])","v":{"v":3603000,"d":"3,603,000"}},{"$f":"SUBTOTAL(109,Pengeluaran[Aktual])","v":{"v":3655000,"d":"3,655,000"}},{"$f":"SUBTOTAL(109,Pengeluaran[Varians])","v":{"v":-52000,"d":"-52,000"}}]

{"sheet":"DATA BAGAN","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"DATA BAGAN"]
[]
[null,null,"Proyeksi","Aktual"]
[null,"Arus Kas",{"$f":"ArusKas[[#Totals],[Proyeksi]]","v":2097000},{"$f":"ArusKas[[#Totals],[Aktual]]","v":15345000}]
[null,"Pendapatan Bulanan",{"$f":"Pendapatan[[#Totals],[Proyeksi]]","v":5700000},{"$f":"Pendapatan[[#Totals],[Aktual]]","v":19000000}]
[null,"Pengeluaran Bulanan",{"$f":"Pengeluaran[[#Totals],[Proyeksi]]","v":3603000},{"$f":"Pengeluaran[[#Totals],[Aktual]]","v":3655000}]