{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Panduan","Aliran Tunai Tahunan","Aliran Tunai Bulanan","Aliran Tunai Harian"],"not_rendered":{"charts":4,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Panduan","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[4,1,5,5]]}
[]
[]
[]
[null,"ALIRAN TUNAI PERIBADI"]
[null,"Buku kerja ini mempunyai lembaran kerja aliran tunai tahunan, bulanan dan harian . Pilih jenis aliran tunai yang paling sesuai untuk anda atau menggunakan kesemuanya untuk membantu mengetahui aliran tunai peribadi anda."]
[]
[]
[]
[null,"Aliran Tunai Tahunan",null,"Aliran Tunai Bulanan",null,"Aliran Tunai Harian"]
[]
[null,"Masukkan amaun aliran tunai tahunan bagi pelbagai aspek. Lihat jumlah bulanan dan perbandingannya, dan penting sekali dasar anda berada dalam nilai tahunan dan bulanan.",null,"Masukkan aliran tunai bulanan yang anda alami setiap bulan atau anggarkan baki bulan untuk melihat aliran tunai yang diunjurkan bagi tahun setiap bulan.",null,"Masukkan amaun anggaran aliran tunai yang anda alami setiap hari dan semak semula jumlah bulanan dan tahunan anggaran. Gunakan ini untuk memahami cara perbelanjaan harian anda dalam bulan atau tahun."]

{"sheet":"Aliran Tunai Tahunan","index":1,"n_rows":48,"n_cols":16,"rows_kept":48,"merged":[[1,1,1,5],[1,7,1,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15],[16,1,16,3],[25,2,25,3],[25,6,25,7],[25,10,25,11],[25,14,25,15]]}
[null,"ALIRAN TUNAI PERIBADI"]
[null,{"$f":"AnnualCashFlowToDate","v":{"v":39750,"d":"RM39,750.00"}},{"$nulls":5},"Ini adalah anggaran tahunan. Gunakan lembaran kerja ini jika anda ingin melihat amaun tahunan dengan nilai bulanan anggaran\nJika anda ingin menambahkan item harian pada jadual, anggarkan amaun/nilai tahunannya dan letakkan nilai dalam lajur Tahunan."]
[]
[]
[null,"RINGKASAN PENDAPATAN",{"$nulls":3},"RINGKASAN PERBELANJAAN",{"$nulls":3},"RINGKASAN BUDI BICARA",{"$nulls":3},"RINGKASAN SIMPANAN"]
[null,"Jumlah Tahunan:",{"$f":"tblIncome[[#Totals],[Tahunan  ]]","v":{"v":125000,"d":"RM125,000.00"}},null,null,"Jumlah Tahunan:",{"$f":"tblExpenses[[#Totals],[Tahunan  ]]","v":{"v":49000,"d":"RM49,000.00"}},null,null,"Jumlah Tahunan:",{"$f":"tblDiscretionary[[#Totals],[Tahunan  ]]","v":{"v":13250,"d":"RM13,250.00"}},null,null,"Jumlah Tahunan:",{"$f":"tblSavings[[#Totals],[Tahunan  ]]","v":{"v":23000,"d":"RM23,000.00"}}]
{"$rows_empty":19}
[null,"Jumlah Bulanan:",{"$f":"tblIncome[[#Totals],[Bulanan ]]","v":{"v":10416.666666666668,"d":"RM10,416.67"}},null,null,"Jumlah Bulanan:",{"$f":"tblExpenses[[#Totals],[Bulanan ]]","v":{"v":4083.333333333333,"d":"RM4,083.33"}},null,null,"Jumlah Bulanan:",{"$f":"tblDiscretionary[[#Totals],[Bulanan ]]","v":{"v":1104.1666666666665,"d":"RM1,104.17"}},null,null,"Jumlah Bulanan:",{"$f":"tblSavings[[#Totals],[Bulanan ]]","v":{"v":1916.6666666666667,"d":"RM1,916.67"}}]
[]
[]
[null,"Pendapatan","Tahunan  ","Bulanan ",null,"Perbelanjaan","Tahunan  ","Bulanan ",null,"Perbelanjaan Budi Bicara","Tahunan  ","Bulanan ",null,"Simpanan","Tahunan  ","Bulanan "]
[null,"Gaji",{"v":90000,"d":"RM90,000.00"},{"$f":"tblIncome[[#This Row],[Tahunan  ]]/12","v":{"v":7500,"d":"RM7,500.00"}},null,"Persekutuan/SS/Jagaan Perubatan",{"v":15000,"d":"RM15,000.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":1250,"d":"RM1,250.00"}},null,"Makan Malam",{"v":1200,"d":"RM1,200.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":100,"d":"RM100.00"}},null,"Simpanan Tunai",{"v":5000,"d":"RM5,000.00"},{"$f":"tblSavings[[#This Row],[Tahunan  ]]/12","v":{"v":416.6666666666667,"d":"RM416.67"}}]
[null,"Komisen/Bonus",{"v":5000,"d":"RM5,000.00"},{"$f":"tblIncome[[#This Row],[Tahunan  ]]/12","v":{"v":416.6666666666667,"d":"RM416.67"}},null,"Cukai Pendapatan Negeri",{"v":2500,"d":"RM2,500.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":208.33333333333334,"d":"RM208.33"}},null,"Hadiah",{"v":600,"d":"RM600.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"RM50.00"}},null,"401(k)/Dll",{"v":12000,"d":"RM12,000.00"},{"$f":"tblSavings[[#This Row],[Tahunan  ]]/12","v":{"v":1000,"d":"RM1,000.00"}}]
[null,"Lain 1",{"v":30000,"d":"RM30,000.00"},{"$f":"tblIncome[[#This Row],[Tahunan  ]]/12","v":{"v":2500,"d":"RM2,500.00"}},null,"Cukai/Yuran Kenderaan",{"v":200,"d":"RM200.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":16.666666666666668,"d":"RM16.67"}},null,"Pelancongan",{"v":2250,"d":"RM2,250.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":187.5,"d":"RM187.50"}},null,"Simpanan/Pelaburan",{"v":6000,"d":"RM6,000.00"},{"$f":"tblSavings[[#This Row],[Tahunan  ]]/12","v":{"v":500,"d":"RM500.00"}}]
[null,"Lain 2",null,{"$f":"tblIncome[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}},null,"Bayaran Kenderaan",{"v":4000,"d":"RM4,000.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":333.3333333333333,"d":"RM333.33"}},null,"Hiburan",{"v":1200,"d":"RM1,200.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":100,"d":"RM100.00"}},null,"Lain 1",null,{"$f":"tblSavings[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}}]
[null,"Lain 3",null,{"$f":"tblIncome[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}},null,"Gadai Janji/Sewa",{"v":15000,"d":"RM15,000.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":1250,"d":"RM1,250.00"}},null,"Penjagaan Peribadi",{"v":300,"d":"RM300.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":25,"d":"RM25.00"}},null,"Lain 2",null,{"$f":"tblSavings[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}}]
[null,"Lain 4",null,{"$f":"tblIncome[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}},null,"Insurans",{"v":250,"d":"RM250.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":20.833333333333332,"d":"RM20.83"}},null,"Membeli-belah",{"v":2000,"d":"RM2,000.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":166.66666666666666,"d":"RM166.67"}},null,"  Jumlah",{"$f":"SUBTOTAL(109,tblSavings[[Tahunan  ]])","v":{"v":23000,"d":"RM23,000.00"}},{"$f":"SUBTOTAL(109,tblSavings[[Bulanan ]])","v":{"v":1916.6666666666667,"d":"RM1,916.67"}}]
[null," Jumlah",{"$f":"SUBTOTAL(109,tblIncome[[Tahunan  ]])","v":{"v":125000,"d":"RM125,000.00"}},{"$f":"SUBTOTAL(109,tblIncome[[Bulanan ]])","v":{"v":10416.666666666668,"d":"RM10,416.67"}},null,"Elektrik",{"v":1200,"d":"RM1,200.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":100,"d":"RM100.00"}},null,"Amal",{"v":600,"d":"RM600.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"RM50.00"}}]
[{"$nulls":5},"Gas",{"v":600,"d":"RM600.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"RM50.00"}},null,"Kelab/Keahlian",{"v":300,"d":"RM300.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":25,"d":"RM25.00"}}]
[{"$nulls":5},"Air/Pembentung",{"v":600,"d":"RM600.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"RM50.00"}},null,"Pembaikan Rumah",{"v":4800,"d":"RM4,800.00"},{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":400,"d":"RM400.00"}}]
[{"$nulls":5},"Sampah",{"v":150,"d":"RM150.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":12.5,"d":"RM12.50"}},null,"Lain 1",null,{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}}]
[{"$nulls":5},"Telefon",{"v":600,"d":"RM600.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"RM50.00"}},null,"Lain 2",null,{"$f":"tblDiscretionary[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}}]
[{"$nulls":5},"Internet",{"v":600,"d":"RM600.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"RM50.00"}},null,"  Jumlah",{"$f":"SUBTOTAL(109,tblDiscretionary[[Tahunan  ]])","v":{"v":13250,"d":"RM13,250.00"}},{"$f":"SUBTOTAL(109,tblDiscretionary[[Bulanan ]])","v":{"v":1104.1666666666665,"d":"RM1,104.17"}}]
[{"$nulls":5},"Premium nyawa/Kecacatan",{"v":1500,"d":"RM1,500.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":125,"d":"RM125.00"}}]
[{"$nulls":5},"Makanan",{"v":5000,"d":"RM5,000.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":416.6666666666667,"d":"RM416.67"}}]
[{"$nulls":5},"Pakaian",{"v":1200,"d":"RM1,200.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":100,"d":"RM100.00"}}]
[{"$nulls":5},"Perubatan/Pergigian/Rx",{"v":600,"d":"RM600.00"},{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"RM50.00"}}]
[{"$nulls":5},"Lain 1",null,{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}}]
[{"$nulls":5},"Lain 2",null,{"$f":"tblExpenses[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"RM0.00"}}]
[{"$nulls":5},"   Jumlah",{"$f":"SUBTOTAL(109,tblExpenses[[Tahunan  ]])","v":{"v":49000,"d":"RM49,000.00"}},{"$f":"SUBTOTAL(109,tblExpenses[[Bulanan ]])","v":{"v":4083.333333333333,"d":"RM4,083.33"}}]

{"sheet":"Aliran Tunai Bulanan","index":2,"n_rows":49,"n_cols":16,"rows_kept":49,"merged":[[1,1,1,5],[1,7,1,16],[49,1,49,15]]}
[null,"ALIRAN TUNAI PERIBADI"]
[null,{"$f":"MonthlyCashFlowToDate","v":{"v":18380,"d":"RM18,380.00"}},{"$nulls":5},"NOTA: Bagi item harian, anggarkan amaun/nilai bulanan dan letakkan nilai tersebut dalam lajur bulan berkaitan."]
[]
[]
[null,"Jenis","Perihalan","Jan","Feb","Mac","Apr","Mei","Jun","Jul","Ogo","Sep","Okt","Nov","Dis","Jumlah"]
[null,"Pendapatan","Gaji",{"v":7500,"d":"RM7,500.00"},{"v":7500,"d":"RM7,500.00"},{"v":7500,"d":"RM7,500.00"},{"v":7500,"d":"RM7,500.00"},{"v":7500,"d":"RM7,500.00"},{"v":7500,"d":"RM7,500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":45000,"d":"RM45,000.00"}}]
[null,"Pendapatan","Komisen/Bonus",{"v":400,"d":"RM400.00"},{"v":400,"d":"RM400.00"},{"v":500,"d":"RM500.00"},{"v":200,"d":"RM200.00"},{"v":0,"d":"RM0.00"},{"v":600,"d":"RM600.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":2100,"d":"RM2,100.00"}}]
[null,"Pendapatan","Lain 1",{"v":2500,"d":"RM2,500.00"},{"v":2500,"d":"RM2,500.00"},{"v":2500,"d":"RM2,500.00"},{"v":2500,"d":"RM2,500.00"},{"v":2500,"d":"RM2,500.00"},{"v":2500,"d":"RM2,500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":15000,"d":"RM15,000.00"}}]
[null,"Pendapatan","Lain 2",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Pendapatan","Lain 3",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Pendapatan","Lain 4",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Perbelanjaan","Persekutuan/SS/Jagaan Perubatan",{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":7500,"d":"RM7,500.00"}}]
[null,"Perbelanjaan","Cukai Pendapatan Negeri",{"v":208.33333333333334,"d":"RM208.33"},{"v":208.33333333333334,"d":"RM208.33"},{"v":208.33333333333334,"d":"RM208.33"},{"v":208.33333333333334,"d":"RM208.33"},{"v":208.33333333333334,"d":"RM208.33"},{"v":208.33333333333334,"d":"RM208.33"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":1250,"d":"RM1,250.00"}}]
[null,"Perbelanjaan","Cukai/Yuran Kenderaan",{"v":16.666666666666668,"d":"RM16.67"},{"v":16.666666666666668,"d":"RM16.67"},{"v":16.666666666666668,"d":"RM16.67"},{"v":16.666666666666668,"d":"RM16.67"},{"v":16.666666666666668,"d":"RM16.67"},{"v":16.666666666666668,"d":"RM16.67"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":100.00000000000001,"d":"RM100.00"}}]
[null,"Perbelanjaan","Bayaran Kenderaan",{"v":333.3333333333333,"d":"RM333.33"},{"v":333.3333333333333,"d":"RM333.33"},{"v":333.3333333333333,"d":"RM333.33"},{"v":333.3333333333333,"d":"RM333.33"},{"v":333.3333333333333,"d":"RM333.33"},{"v":333.3333333333333,"d":"RM333.33"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":1999.9999999999998,"d":"RM2,000.00"}}]
[null,"Perbelanjaan","Gadai Janji/Sewa",{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"v":1250,"d":"RM1,250.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":7500,"d":"RM7,500.00"}}]
[null,"Perbelanjaan","Insurans",{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":150,"d":"RM150.00"}}]
[null,"Perbelanjaan","Elektrik",{"v":100,"d":"RM100.00"},{"v":100,"d":"RM100.00"},{"v":100,"d":"RM100.00"},{"v":100,"d":"RM100.00"},{"v":100,"d":"RM100.00"},{"v":100,"d":"RM100.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":600,"d":"RM600.00"}}]
[null,"Perbelanjaan","Gas",{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":300,"d":"RM300.00"}}]
[null,"Perbelanjaan","Air",{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":300,"d":"RM300.00"}}]
[null,"Perbelanjaan","Pembetung",{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":150,"d":"RM150.00"}}]
[null,"Perbelanjaan","Sampah",{"v":12.5,"d":"RM12.50"},{"v":12.5,"d":"RM12.50"},{"v":12.5,"d":"RM12.50"},{"v":12.5,"d":"RM12.50"},{"v":12.5,"d":"RM12.50"},{"v":12.5,"d":"RM12.50"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":75,"d":"RM75.00"}}]
[null,"Perbelanjaan","Telefon",{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":300,"d":"RM300.00"}}]
[null,"Perbelanjaan","Internet",{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":300,"d":"RM300.00"}}]
[null,"Perbelanjaan","Premium nyawa/Kecacatan",{"v":125,"d":"RM125.00"},{"v":125,"d":"RM125.00"},{"v":125,"d":"RM125.00"},{"v":125,"d":"RM125.00"},{"v":125,"d":"RM125.00"},{"v":125,"d":"RM125.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":750,"d":"RM750.00"}}]
[null,"Perbelanjaan","Makanan",{"v":400,"d":"RM400.00"},{"v":500,"d":"RM500.00"},{"v":450,"d":"RM450.00"},{"v":400,"d":"RM400.00"},{"v":450,"d":"RM450.00"},{"v":425,"d":"RM425.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":2625,"d":"RM2,625.00"}}]
[null,"Perbelanjaan","Pakaian",{"v":50,"d":"RM50.00"},{"v":75,"d":"RM75.00"},{"v":100,"d":"RM100.00"},{"v":75,"d":"RM75.00"},{"v":125,"d":"RM125.00"},{"v":75,"d":"RM75.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":500,"d":"RM500.00"}}]
[null,"Perbelanjaan","Perubatan/Pergigian/Rx",{"v":50,"d":"RM50.00"},{"v":10,"d":"RM10.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":20,"d":"RM20.00"},{"v":70,"d":"RM70.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":200,"d":"RM200.00"}}]
[null,"Perbelanjaan","Bas",{"v":30,"d":"RM30.00"},{"v":30,"d":"RM30.00"},{"v":30,"d":"RM30.00"},{"v":20,"d":"RM20.00"},{"v":30,"d":"RM30.00"},{"v":30,"d":"RM30.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":170,"d":"RM170.00"}}]
[null,"Perbelanjaan","Lain 2",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Perbelanjaan","Lain 3",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Perbelanjaan","Lain 4",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Budi Bicara","Makan Malam",{"v":50,"d":"RM50.00"},{"v":150,"d":"RM150.00"},{"v":100,"d":"RM100.00"},{"v":50,"d":"RM50.00"},{"v":150,"d":"RM150.00"},{"v":100,"d":"RM100.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":600,"d":"RM600.00"}}]
[null,"Budi Bicara","Hadiah",{"v":25,"d":"RM25.00"},{"v":75,"d":"RM75.00"},{"v":50,"d":"RM50.00"},{"v":25,"d":"RM25.00"},{"v":75,"d":"RM75.00"},{"v":50,"d":"RM50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":300,"d":"RM300.00"}}]
[null,"Budi Bicara","Pelancongan",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":1000,"d":"RM1,000.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":1000,"d":"RM1,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":2000,"d":"RM2,000.00"}}]
[null,"Budi Bicara","Hiburan",{"v":50,"d":"RM50.00"},{"v":150,"d":"RM150.00"},{"v":100,"d":"RM100.00"},{"v":50,"d":"RM50.00"},{"v":150,"d":"RM150.00"},{"v":100,"d":"RM100.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":600,"d":"RM600.00"}}]
[null,"Budi Bicara","Penjagaan Peribadi",{"v":15,"d":"RM15.00"},{"v":25,"d":"RM25.00"},{"v":35,"d":"RM35.00"},{"v":15,"d":"RM15.00"},{"v":25,"d":"RM25.00"},{"v":35,"d":"RM35.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":150,"d":"RM150.00"}}]
[null,"Budi Bicara","Membeli-belah",{"v":100,"d":"RM100.00"},{"v":200,"d":"RM200.00"},{"v":150,"d":"RM150.00"},{"v":175,"d":"RM175.00"},{"v":150,"d":"RM150.00"},{"v":175,"d":"RM175.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":950,"d":"RM950.00"}}]
[null,"Budi Bicara","Amal",{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"v":50,"d":"RM50.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":300,"d":"RM300.00"}}]
[null,"Budi Bicara","Kelab/Keahlian",{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"v":25,"d":"RM25.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":150,"d":"RM150.00"}}]
[null,"Budi Bicara","Pembaikan Rumah",{"v":400,"d":"RM400.00"},{"v":400,"d":"RM400.00"},{"v":400,"d":"RM400.00"},{"v":400,"d":"RM400.00"},{"v":400,"d":"RM400.00"},{"v":400,"d":"RM400.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":2400,"d":"RM2,400.00"}}]
[null,"Budi Bicara","Lain 1",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Budi Bicara","Lain 2",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Simpanan","Simpanan Tunai",{"v":416.6666666666667,"d":"RM416.67"},{"v":416.6666666666667,"d":"RM416.67"},{"v":416.6666666666667,"d":"RM416.67"},{"v":416.6666666666667,"d":"RM416.67"},{"v":416.6666666666667,"d":"RM416.67"},{"v":416.6666666666667,"d":"RM416.67"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":2500,"d":"RM2,500.00"}}]
[null,"Simpanan","401(k)/Dll",{"v":1000,"d":"RM1,000.00"},{"v":1000,"d":"RM1,000.00"},{"v":1000,"d":"RM1,000.00"},{"v":1000,"d":"RM1,000.00"},{"v":1000,"d":"RM1,000.00"},{"v":1000,"d":"RM1,000.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":6000,"d":"RM6,000.00"}}]
[null,"Simpanan","Simpanan/Pelaburan/Akaun",{"v":500,"d":"RM500.00"},{"v":500,"d":"RM500.00"},{"v":500,"d":"RM500.00"},{"v":500,"d":"RM500.00"},{"v":500,"d":"RM500.00"},{"v":500,"d":"RM500.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":3000,"d":"RM3,000.00"}}]
[null,"Simpanan","Lain 1",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null,"Simpanan","Lain 2",{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"v":0,"d":"RM0.00"},{"$nulls":6},{"$f":"SUM(tblMontly[[#This Row],[Jan]:[Dis]])","v":{"v":0,"d":"RM0.00"}}]
[null," Jumlah",null,{"$f":"SUMIF(tblMontly[Jenis],\"Pendapatan\",tblMontly[Jan])-SUMIF(tblMontly[Jenis],\"<>Pendapatan\",tblMontly[Jan])","v":{"v":3692.5,"d":"RM3,692.50"}},{"$f":"SUMIF(tblMontly[Jenis],\"Pendapatan\",tblMontly[Feb])-SUMIF(tblMontly[Jenis],\"<>Pendapatan\",tblMontly[Feb])","v":{"v":3247.5,"d":"RM3,247.50"}},{"$f":"SUMIF(tblMontly[Jenis],\"Pendapatan\",tblMontly[Mac])-SUMIF(tblMontly[Jenis],\"<>Pendapatan\",tblMontly[Mac])","v":{"v":2522.5,"d":"RM2,522.50"}},{"$f":"SUMIF(tblMontly[Jenis],\"Pendapatan\",tblMontly[Apr])-SUMIF(tblMontly[Jenis],\"<>Pendapatan\",tblMontly[Apr])","v":{"v":3427.5,"d":"RM3,427.50"}},{"$f":"SUMIF(tblMontly[Jenis],\"Pendapatan\",tblMontly[Mei])-SUMIF(tblMontly[Jenis],\"<>Pendapatan\",tblMontly[Mei])","v":{"v":2887.5,"d":"RM2,887.50"}},{"$f":"SUMIF(tblMontly[Jenis],\"Pendapatan\",tblMontly[Jun])-SUMIF(tblMontly[Jenis],\"<>Pendapatan\",tblMontly[Jun])","v":{"v":2602.5,"d":"RM2,602.50"}},{"$f":"SUMIF(tblMontly[Jenis],\"Income\",tblMontly[Jul])-SUMIF(tblMontly[Jenis],\"<>Income\",tblMontly[Jul])","v":{"v":0,"d":"RM0.00"}},{"$f":"SUMIF(tblMontly[Jenis],\"Income\",tblMontly[Ogo])-SUMIF(tblMontly[Jenis],\"<>Income\",tblMontly[Ogo])","v":{"v":0,"d":"RM0.00"}},{"$f":"SUMIF(tblMontly[Jenis],\"Income\",tblMontly[Sep])-SUMIF(tblMontly[Jenis],\"<>Income\",tblMontly[Sep])","v":{"v":0,"d":"RM0.00"}},{"$f":"SUMIF(tblMontly[Jenis],\"Income\",tblMontly[Okt])-SUMIF(tblMontly[Jenis],\"<>Income\",tblMontly[Okt])","v":{"v":0,"d":"RM0.00"}},{"$f":"SUMIF(tblMontly[Jenis],\"Income\",tblMontly[Nov])-SUMIF(tblMontly[Jenis],\"<>Income\",tblMontly[Nov])","v":{"v":0,"d":"RM0.00"}},{"$f":"SUMIF(tblMontly[Jenis],\"Income\",tblMontly[Dis])-SUMIF(tblMontly[Jenis],\"<>Income\",tblMontly[Dis])","v":{"v":0,"d":"RM0.00"}},{"$f":"SUMIF(tblMontly[Jenis],\"Pendapatan\",tblMontly[Jumlah])-SUMIF(tblMontly[Jenis],\"<>Pendapatan\",tblMontly[Jumlah])","v":{"v":18380,"d":"RM18,380.00"}}]

{"sheet":"Aliran Tunai Harian","index":3,"n_rows":56,"n_cols":8,"rows_kept":56,"merged":[[1,1,1,5],[1,7,1,16],[9,1,9,5]]}
[null,"ALIRAN TUNAI PERIBADI"]
[null,{"$f":"DailyCashFlow","v":{"v":577.8399999999999,"d":"RM577.84"}},{"$nulls":5},"NOTE: If you wish to add daily items to the Table, estimate their monthly amount/value and place value in the appropriate month column."]
[]
[null,"RINGKASA HARIAN"]
[null,"JUMLAH"," ","Harian","Bulanan","Tahunan "]
[null,"Pendapatan",null,{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Harian])","v":{"v":342.47,"d":"RM342.47"}},{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Bulanan])","v":{"v":10416.795833333334,"d":"RM10,416.80"}},{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Tahunan])","v":{"v":125001.55000000002,"d":"RM125,001.55"}}]
[null,"Perbelanjaan",null,{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Harian])","v":{"v":136.05999999999997,"d":"RM136.06"}},{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Bulanan])","v":{"v":4138.491666666667,"d":"RM4,138.49"}},{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Tahunan])","v":{"v":49661.899999999994,"d":"RM49,661.90"}}]
[null,"Budi Bicara",null,{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Harian])","v":{"v":36.29,"d":"RM36.29"}},{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Bulanan])","v":{"v":1103.8208333333334,"d":"RM1,103.82"}},{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Tahunan])","v":{"v":13245.849999999999,"d":"RM13,245.85"}}]
[null,"Simpanan",null,{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Harian])","v":{"v":63.019999999999996,"d":"RM63.02"}},{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Bulanan])","v":{"v":1916.8583333333333,"d":"RM1,916.86"}},{"$f":"SUMIF(tblDaily[Jenis],tblDailyTotals[[#This Row],[JUMLAH]],tblDaily[Tahunan])","v":{"v":23002.300000000003,"d":"RM23,002.30"}}]
[]
[]
[null,"Jenis","Perihalan","Harian","Bulanan","Tahunan"]
[null,"Pendapatan","Gaji",{"v":246.58,"d":"RM246.58"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":7500.141666666667,"d":"RM7,500.14"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":90001.70000000001,"d":"RM90,001.70"}}]
[null,"Pendapatan","Komisen/Bonus",{"v":13.7,"d":"RM13.70"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":416.7083333333333,"d":"RM416.71"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":5000.5,"d":"RM5,000.50"}}]
[null,"Pendapatan","Lain 1",{"v":82.19,"d":"RM82.19"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":2499.945833333333,"d":"RM2,499.95"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":29999.35,"d":"RM29,999.35"}}]
[null,"Pendapatan","Lain 2",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Pendapatan","Lain 3",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Pendapatan","Lain 4",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Perbelanjaan","Persekutuan/SS/Jagaan Perubatan",{"v":41.1,"d":"RM41.10"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":1250.125,"d":"RM1,250.13"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":15001.5,"d":"RM15,001.50"}}]
[null,"Perbelanjaan","Cukai Pendapatan Negeri",{"v":6.85,"d":"RM6.85"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":208.35416666666666,"d":"RM208.35"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":2500.25,"d":"RM2,500.25"}}]
[null,"Perbelanjaan","Cukai/Yuran Kenderaan",{"v":0.55,"d":"RM0.55"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":16.729166666666668,"d":"RM16.73"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":200.75000000000003,"d":"RM200.75"}}]
[null,"Perbelanjaan","Bayaran Kenderaan",{"v":10.96,"d":"RM10.96"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":333.3666666666667,"d":"RM333.37"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":4000.4,"d":"RM4,000.40"}}]
[null,"Perbelanjaan","Gadai Janji/Sewa",{"v":41.1,"d":"RM41.10"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":1250.125,"d":"RM1,250.13"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":15001.5,"d":"RM15,001.50"}}]
[null,"Perbelanjaan","Insurans",{"v":0.68,"d":"RM0.68"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":20.683333333333334,"d":"RM20.68"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":248.20000000000002,"d":"RM248.20"}}]
[null,"Perbelanjaan","Elektrik",{"v":3.29,"d":"RM3.29"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":100.07083333333333,"d":"RM100.07"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":1200.85,"d":"RM1,200.85"}}]
[null,"Perbelanjaan","Gas",{"v":1.64,"d":"RM1.64"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"RM49.88"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"RM598.60"}}]
[null,"Perbelanjaan","Air",{"v":1.64,"d":"RM1.64"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"RM49.88"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"RM598.60"}}]
[null,"Perbelanjaan","Pembetung",{"v":0.82,"d":"RM0.82"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":24.941666666666663,"d":"RM24.94"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":299.29999999999995,"d":"RM299.30"}}]
[null,"Perbelanjaan","Sampah",{"v":0.41,"d":"RM0.41"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":12.470833333333331,"d":"RM12.47"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":149.64999999999998,"d":"RM149.65"}}]
[null,"Perbelanjaan","Telefon",{"v":1.64,"d":"RM1.64"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"RM49.88"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"RM598.60"}}]
[null,"Perbelanjaan","Internet",{"v":1.64,"d":"RM1.64"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"RM49.88"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"RM598.60"}}]
[null,"Perbelanjaan","Premium nyawa/Kecacatan",{"v":4.11,"d":"RM4.11"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":125.0125,"d":"RM125.01"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":1500.15,"d":"RM1,500.15"}}]
[null,"Perbelanjaan","Makanan",{"v":13.7,"d":"RM13.70"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":416.7083333333333,"d":"RM416.71"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":5000.5,"d":"RM5,000.50"}}]
[null,"Perbelanjaan","Pakaian",{"v":3.29,"d":"RM3.29"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":100.07083333333333,"d":"RM100.07"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":1200.85,"d":"RM1,200.85"}}]
[null,"Perbelanjaan","Perubatan/Pergigian/Rx",{"v":1.64,"d":"RM1.64"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"RM49.88"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"RM598.60"}}]
[null,"Perbelanjaan","Bas",{"v":1,"d":"RM1.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":30.416666666666668,"d":"RM30.42"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":365,"d":"RM365.00"}}]
[null,"Perbelanjaan","Lain 2",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Perbelanjaan","Lain 3",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Perbelanjaan","Lain 4",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Budi Bicara","Makan Malam",{"v":3.29,"d":"RM3.29"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":100.07083333333333,"d":"RM100.07"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":1200.85,"d":"RM1,200.85"}}]
[null,"Budi Bicara","Hadiah",{"v":1.64,"d":"RM1.64"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"RM49.88"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"RM598.60"}}]
[null,"Budi Bicara","Pelancongan",{"v":6.16,"d":"RM6.16"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":187.36666666666667,"d":"RM187.37"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":2248.4,"d":"RM2,248.40"}}]
[null,"Budi Bicara","Hiburan",{"v":3.29,"d":"RM3.29"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":100.07083333333333,"d":"RM100.07"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":1200.85,"d":"RM1,200.85"}}]
[null,"Budi Bicara","Penjagaan Peribadi",{"v":0.82,"d":"RM0.82"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":24.941666666666663,"d":"RM24.94"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":299.29999999999995,"d":"RM299.30"}}]
[null,"Budi Bicara","Membeli-belah",{"v":5.48,"d":"RM5.48"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":166.68333333333334,"d":"RM166.68"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":2000.2,"d":"RM2,000.20"}}]
[null,"Budi Bicara","Amal",{"v":1.64,"d":"RM1.64"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"RM49.88"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"RM598.60"}}]
[null,"Budi Bicara","Kelab/Keahlian",{"v":0.82,"d":"RM0.82"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":24.941666666666663,"d":"RM24.94"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":299.29999999999995,"d":"RM299.30"}}]
[null,"Budi Bicara","Pembaikan Rumah",{"v":13.15,"d":"RM13.15"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":399.9791666666667,"d":"RM399.98"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":4799.75,"d":"RM4,799.75"}}]
[null,"Budi Bicara","Lain 1",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Budi Bicara","Lain 2",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Simpanan","Simpanan Tunai",{"v":13.7,"d":"RM13.70"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":416.7083333333333,"d":"RM416.71"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":5000.5,"d":"RM5,000.50"}}]
[null,"Simpanan","401(k)/Dll",{"v":32.88,"d":"RM32.88"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":1000.1,"d":"RM1,000.10"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":12001.2,"d":"RM12,001.20"}}]
[null,"Simpanan","Simpanan/Pelaburan/Akaun",{"v":16.44,"d":"RM16.44"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":500.05,"d":"RM500.05"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":6000.6,"d":"RM6,000.60"}}]
[null,"Simpanan","Lain 1",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null,"Simpanan","Lain 2",{"v":0,"d":"RM0.00"},{"$f":"tblDaily[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"RM0.00"}},{"$f":"tblDaily[[#This Row],[Harian]]*365","v":{"v":0,"d":"RM0.00"}}]
[null," Jumlah ",null,{"$f":"SUMIF(tblDaily[Jenis],\"Pendapatan\",tblDaily[Harian])-SUMIF(tblDaily[Jenis],\"<>Pendapatan\",tblDaily[Harian])","v":{"v":107.10000000000014,"d":"RM107.10"}},{"$f":"SUMIF(tblDaily[Jenis],\"Pendapatan\",tblDaily[Bulanan])-SUMIF(tblDaily[Jenis],\"<>Pendapatan\",tblDaily[Bulanan])","v":{"v":3257.625,"d":"RM3,257.63"}},{"$f":"SUMIF(tblDaily[Jenis],\"Pendapatan\",tblDaily[Tahunan])-SUMIF(tblDaily[Jenis],\"<>Pendapatan\",tblDaily[Tahunan])","v":{"v":39091.500000000015,"d":"RM39,091.50"}}]