{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Perancang Bajet"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Perancang Bajet","index":0,"n_rows":136,"n_cols":7,"rows_kept":136,"merged":[[15,1,15,5],[22,1,22,5],[36,2,36,5],[47,2,47,5],[54,2,54,5],[60,2,60,5],[72,2,72,5],[80,2,80,5],[90,2,90,5],[100,2,100,5],[109,2,109,5],[116,2,116,5],[123,2,123,5],[129,2,129,5],[136,2,136,5]]}
[{"$nulls":6}," "]
[{"$nulls":6}," "]
[]
[]
[]
[{"$nulls":6}," "]
[]
[]
[{"$nulls":6}," "]
[]
[]
[null,"  ","Aliran Tunai","Terunjur","Sebenar","Varians"]
[null,null,"Jumlah Pendapatan",{"$f":"SUM(Income[Terunjur])","v":{"v":5600,"d":"5,600"}},{"$f":"SUM(Income[Sebenar])","v":{"v":4700,"d":"4,700"}},{"$f":"SUM(Income[Varians])","v":-900}]
[null,null,"Jumlah Perbelanjaan",{"$f":"totalExpenseProjected","v":{"v":1195,"d":"1,195"}},{"$f":"totalExpenseActual","v":736},{"$f":"CashFlow[[#This Row],[Terunjur]]-CashFlow[[#This Row],[Sebenar]]","v":459}]
[null,null,"JUMLAH ALIRAN TUNAI",{"$f":"D13-D14","v":{"v":4405,"d":"4,405"}},{"$f":"E13-E14","v":{"v":3964,"d":"3,964"}},{"$f":"CashFlow[[#This Row],[Sebenar]]-CashFlow[[#This Row],[Terunjur]]","v":-441}]
[]
[null," ","Pendapatan Bulanan","Terunjur","Sebenar","Varians"]
[null,null,"Pendapatan 1",{"v":4000,"d":"4,000"},{"v":3000,"d":"3,000"},{"$f":"Income[[#This Row],[Sebenar]]-Income[[#This Row],[Terunjur]]","v":{"v":-1000,"d":"-1,000"}}]
[null,null,"Pendapatan 2",{"v":1300,"d":"1,300"},{"v":1400,"d":"1,400"},{"$f":"Income[[#This Row],[Sebenar]]-Income[[#This Row],[Terunjur]]","v":100}]
[null,null,"Pendapatan Tambahan",300,300,{"$f":"Income[[#This Row],[Sebenar]]-Income[[#This Row],[Terunjur]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Income[[#This Row],[Sebenar]]-Income[[#This Row],[Terunjur]]","v":0}]
[null,null,"JUMLAH PENDAPATAN",{"$f":"SUBTOTAL(109,Income[Terunjur])","v":{"v":5600,"d":"5,600"}},{"$f":"SUBTOTAL(109,Income[Sebenar])","v":{"v":4700,"d":"4,700"}},{"$f":"SUBTOTAL(109,Income[Varians])","v":-900}]
[]
[null,null,"Perbelanjaan Perumahan","Terunjur","Sebenar","Varians"]
[null,null,"Gadai janji atau sewa",{"v":1000,"d":"1,000"},500,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":500}]
[null,null,"Gadai janji atau sewa kedua",0,0,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":0}]
[null,null,"Telefon",54,100,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":-46}]
[null,null,"Elektrik",44,56,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":-12}]
[null,null,"Gas",22,28,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":-6}]
[null,null,"Air dan pembetung",8,8,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":0}]
[null,null,"Kabel",34,34,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":0}]
[null,null,"Pembuangan Sampah",10,10,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":0}]
[null,null,"Penyenggaraan atau pembaikan",23,0,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":23}]
[null,null,"Bekalan",0,0,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",0,0,{"$f":"Housing[[#This Row],[Terunjur]]-Housing[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Housing[Terunjur])","v":{"v":1195,"d":"1,195"}},{"$f":"SUBTOTAL(109,Housing[Sebenar])","v":736},{"$f":"SUBTOTAL(109,Housing[Varians])","v":459}]
[]
[null,null,"Pengangkutan","Terunjur","Sebenar","Varians"]
[null,null,"Bayaran kenderaan 1",null,null,{"$f":"Transportation[[#This Row],[Terunjur]]-Transportation[[#This Row],[Sebenar]]","v":0}]
[null,null,"Bayaran kenderaan 2",null,null,{"$f":"Transportation[[#This Row],[Terunjur]]-Transportation[[#This Row],[Sebenar]]","v":0}]
[null,null,"Tambang bas/teksi",null,null,{"$f":"Transportation[[#This Row],[Terunjur]]-Transportation[[#This Row],[Sebenar]]","v":0}]
[null,null,"Insurans",null,null,{"$f":"Transportation[[#This Row],[Terunjur]]-Transportation[[#This Row],[Sebenar]]","v":0}]
[null,null,"Pelesenan",null,null,{"$f":"Transportation[[#This Row],[Terunjur]]-Transportation[[#This Row],[Sebenar]]","v":0}]
[null,null,"Minyak",null,null,{"$f":"Transportation[[#This Row],[Terunjur]]-Transportation[[#This Row],[Sebenar]]","v":0}]
[null,null,"Penyenggaraan",null,null,{"$f":"Transportation[[#This Row],[Terunjur]]-Transportation[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Transportation[[#This Row],[Terunjur]]-Transportation[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Transportation[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Transportation[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Transportation[Varians])","v":0}]
[]
[null,null,"Insurans","Terunjur","Sebenar","Varians"]
[null,null,"Rumah",null,null,{"$f":"Insurance[[#This Row],[Terunjur]]-Insurance[[#This Row],[Sebenar]]","v":0}]
[null,null,"Kesihatan",null,null,{"$f":"Insurance[[#This Row],[Terunjur]]-Insurance[[#This Row],[Sebenar]]","v":0}]
[null,null,"Kehidupan",null,null,{"$f":"Insurance[[#This Row],[Terunjur]]-Insurance[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Insurance[[#This Row],[Terunjur]]-Insurance[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Insurance[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Insurance[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Insurance[Varians])","v":0}]
[]
[null,null,"Makanan","Terunjur","Sebenar","Varians"]
[null,null,"Barang Runcit",null,null,{"$f":"Food[[#This Row],[Terunjur]]-Food[[#This Row],[Sebenar]]","v":0}]
[null,null,"Makan Di Luar",null,null,{"$f":"Food[[#This Row],[Terunjur]]-Food[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Food[[#This Row],[Terunjur]]-Food[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Food[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Food[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Food[Varians])","v":0}]
[]
[null,null,"Anak-anak","Terunjur","Sebenar","Varians"]
[null,null,"Perubatan",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"Pakaian",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"Tuisyen sekolah",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"Bekalan sekolah",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"Yuran organisasi",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"Wang makan tengah hari",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"Penjagaan anak",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"Mainan/permainan",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Children[[#This Row],[Terunjur]]-Children[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Children[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Children[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Children[Varians])","v":0}]
[]
[null,null,"Haiwan Peliharaan","Terunjur","Sebenar","Varians"]
[null,null,"Makanan",null,null,{"$f":"Pets[[#This Row],[Terunjur]]-Pets[[#This Row],[Sebenar]]","v":0}]
[null,null,"Perubatan",null,null,{"$f":"Pets[[#This Row],[Terunjur]]-Pets[[#This Row],[Sebenar]]","v":0}]
[null,null,"Hias diri",null,null,{"$f":"Pets[[#This Row],[Terunjur]]-Pets[[#This Row],[Sebenar]]","v":0}]
[null,null,"Mainan",null,null,{"$f":"Pets[[#This Row],[Terunjur]]-Pets[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Pets[[#This Row],[Terunjur]]-Pets[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Pets[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Pets[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Pets[Varians])","v":0}]
[]
[null,null,"Jaga Diri","Terunjur","Sebenar","Varians"]
[null,null,"Perubatan",null,null,{"$f":"PersonalCare[[#This Row],[Terunjur]]-PersonalCare[[#This Row],[Sebenar]]","v":0}]
[null,null,"Rambut/kuku",null,null,{"$f":"PersonalCare[[#This Row],[Terunjur]]-PersonalCare[[#This Row],[Sebenar]]","v":0}]
[null,null,"Pakaian",null,null,{"$f":"PersonalCare[[#This Row],[Terunjur]]-PersonalCare[[#This Row],[Sebenar]]","v":0}]
[null,null,"Cuci kering",null,null,{"$f":"PersonalCare[[#This Row],[Terunjur]]-PersonalCare[[#This Row],[Sebenar]]","v":0}]
[null,null,"Kelab kesihatan",null,null,{"$f":"PersonalCare[[#This Row],[Terunjur]]-PersonalCare[[#This Row],[Sebenar]]","v":0}]
[null,null,"Yuran organisasi",null,null,{"$f":"PersonalCare[[#This Row],[Terunjur]]-PersonalCare[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"PersonalCare[[#This Row],[Terunjur]]-PersonalCare[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,PersonalCare[Terunjur])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Sebenar])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Varians])","v":0}]
[]
[null,null,"Hiburan","Terunjur","Sebenar","Varians"]
[null,null,"Video/DVD",null,null,{"$f":"Entertainment[[#This Row],[Terunjur]]-Entertainment[[#This Row],[Sebenar]]","v":0}]
[null,null,"CD",null,null,{"$f":"Entertainment[[#This Row],[Terunjur]]-Entertainment[[#This Row],[Sebenar]]","v":0}]
[null,null,"Wayang",null,null,{"$f":"Entertainment[[#This Row],[Terunjur]]-Entertainment[[#This Row],[Sebenar]]","v":0}]
[null,null,"Konsert",null,null,{"$f":"Entertainment[[#This Row],[Terunjur]]-Entertainment[[#This Row],[Sebenar]]","v":0}]
[null,null,"Acara sukan",null,null,{"$f":"Entertainment[[#This Row],[Terunjur]]-Entertainment[[#This Row],[Sebenar]]","v":0}]
[null,null,"Teater langsung",null,null,{"$f":"Entertainment[[#This Row],[Terunjur]]-Entertainment[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Entertainment[[#This Row],[Terunjur]]-Entertainment[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Entertainment[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Varians])","v":0}]
[]
[null,null,"Pinjaman","Terunjur","Sebenar","Varians"]
[null,null,"Peribadi",null,null,{"$f":"Loans[[#This Row],[Terunjur]]-Loans[[#This Row],[Sebenar]]","v":0}]
[null,null,"Pelajar",null,null,{"$f":"Loans[[#This Row],[Terunjur]]-Loans[[#This Row],[Sebenar]]","v":0}]
[null,null,"Kad kredit",null,null,{"$f":"Loans[[#This Row],[Terunjur]]-Loans[[#This Row],[Sebenar]]","v":0}]
[null,null,"Kad kredit",null,null,{"$f":"Loans[[#This Row],[Terunjur]]-Loans[[#This Row],[Sebenar]]","v":0}]
[null,null,"Kad kredit",null,null,{"$f":"Loans[[#This Row],[Terunjur]]-Loans[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Loans[[#This Row],[Terunjur]]-Loans[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Loans[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Loans[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Loans[Varians])","v":0}]
[]
[null,null,"Cukai","Terunjur","Sebenar","Varians"]
[null,null,"Persekutuan",null,null,{"$f":"Taxes[[#This Row],[Terunjur]]-Taxes[[#This Row],[Sebenar]]","v":0}]
[null,null,"Negeri",null,null,{"$f":"Taxes[[#This Row],[Terunjur]]-Taxes[[#This Row],[Sebenar]]","v":0}]
[null,null,"Tempatan",null,null,{"$f":"Taxes[[#This Row],[Terunjur]]-Taxes[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Taxes[[#This Row],[Terunjur]]-Taxes[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Taxes[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Taxes[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Taxes[Varians])","v":0}]
[]
[null,null,"Simpanan atau Pelaburan","Terunjur","Sebenar","Varians"]
[null,null,"Akaun persaraan",null,null,{"$f":"Savings[[#This Row],[Terunjur]]-Savings[[#This Row],[Sebenar]]","v":0}]
[null,null,"Akaun pelaburan",null,null,{"$f":"Savings[[#This Row],[Terunjur]]-Savings[[#This Row],[Sebenar]]","v":0}]
[null,null,"Kolej",null,null,{"$f":"Savings[[#This Row],[Terunjur]]-Savings[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Savings[[#This Row],[Terunjur]]-Savings[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Savings[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Savings[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Savings[Varians])","v":0}]
[]
[null,null,"Hadiah dan Derma","Terunjur","Sebenar","Varians"]
[null,null,"Amal 1",null,null,{"$f":"Gifts[[#This Row],[Terunjur]]-Gifts[[#This Row],[Sebenar]]","v":0}]
[null,null,"Amal 2",null,null,{"$f":"Gifts[[#This Row],[Terunjur]]-Gifts[[#This Row],[Sebenar]]","v":0}]
[null,null,"Amal 3",null,null,{"$f":"Gifts[[#This Row],[Terunjur]]-Gifts[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Gifts[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Gifts[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Gifts[Varians])","v":0}]
[]
[null,null,"Guaman","Terunjur","Sebenar","Varians"]
[null,null,"Wakil",null,null,{"$f":"Legal[[#This Row],[Terunjur]]-Legal[[#This Row],[Sebenar]]","v":0}]
[null,null,"Alimoni",null,null,{"$f":"Legal[[#This Row],[Terunjur]]-Legal[[#This Row],[Sebenar]]","v":0}]
[null,null,"Bayaran berdasarkan lien atau penghakiman",null,null,{"$f":"Legal[[#This Row],[Terunjur]]-Legal[[#This Row],[Sebenar]]","v":0}]
[null,null,"Lain",null,null,{"$f":"Legal[[#This Row],[Terunjur]]-Legal[[#This Row],[Sebenar]]","v":0}]
[null,null,"SUBJUMLAH",{"$f":"SUBTOTAL(109,Legal[Terunjur])","v":0},{"$f":"SUBTOTAL(109,Legal[Sebenar])","v":0},{"$f":"SUBTOTAL(109,Legal[Varians])","v":0}]