{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Papan Pemuka","Senarai Peralatan","Data Pangsi"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Papan Pemuka","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Papan Pemuka"]
[]
[]
[null,null,null,null,null,"Jumlah Kiraan"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Kiraan\",'Data Pangsi'!$B$11)","v":3}]
[]
[null,null,null,null,null,"Jumlah Kos Bulanan"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Hasil Tambah bagi Jumlah Kos Bulanan\",'Data Pangsi'!$B$11)","v":1765.5943035068672}]
[]
[null,null,null,null,null,"Kos pengendalian"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Kos Pengendalian\",'Data Pangsi'!$B$11)","v":605}]
[]
[null,null,null,null,null,"Susut Nilai Bulanan"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Susut Nilai Bulanan\n(Garis Lurus)\",'Data Pangsi'!$B$11)","v":659.72222222222217}]
[]
[null,null,null,null,null,"Amaun Bayaran"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Amaun Pembayaran\",'Data Pangsi'!$B$11)","v":1160.5943035068672}]
[]
[null,null,null,null,null,"Nilai Semasa"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Hasil Tambah bagi Nilai Semasa\",'Data Pangsi'!$B$11)","v":36838.584474885851}]

{"sheet":"Senarai Peralatan","index":1,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Senarai Peralatan"]
[]
[null,null,null,null,"Serlahkan apabila baki bayaran bulanan adalah kurang daripada: ",20]
[]
[null,"Aset atau\nNombor Siri","Perihalan Item\n(Buat dan Model)","Lokasi","Syarat","Vendor","Baki\nTahun Perkhidmatan ","Nilai Awal","Bayaran Pendahuluan","Tarikh Dibeli\natau Pajak","Terma Pinjaman\n(Tahun)","Kadar Pinjaman","Kos\nPengendalian Bulanan","Nilai Jangkaan pada Penghujung Kontrak","Baki\nBayaran Bulanan","Bayaran Bulanan","Jumlah Kos Bulanan","Susut Nilai Tahunan\n(Garis Lurus)","Susut Nilai Bulanan\n(Garis Lurus)","Nilai Semasa"]
[null,123,"Buat Model 1","Cawangan utama","Baik","Tempatan",5,30000,5000,"2011-01-15",4,0.1,200,20000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])+Equipment[[#This Row],[Terma Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])-1,DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])+Equipment[[#This Row],[Terma Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]),DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))-1)=DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))),0)","v":24},{"$f":"IFERROR(-(Equipment[Nilai Awal]>0)*(Equipment[Nilai Awal]<>Equipment[Bayaran Pendahuluan])*PMT(Equipment[Kadar Pinjaman]/MonthsInYear,Equipment[Terma Pinjaman\n(Tahun)]*MonthsInYear,Equipment[Nilai Awal]-Equipment[Bayaran Pendahuluan]),0)","v":634.06458586867973},{"$f":"Equipment[[#This Row],[Bayaran Bulanan]]+Equipment[Kos\nPengendalian Bulanan]","v":834.06458586867973},{"$f":"IFERROR((Equipment[Nilai Awal]>0)*SLN(Equipment[Nilai Awal],Equipment[Nilai Jangkaan pada Penghujung Kontrak],Equipment[Terma Pinjaman\n(Tahun)]),0)","v":2500},{"$f":"IFERROR(Equipment[Susut Nilai Tahunan\n(Garis Lurus)]/MonthsInYear,0)","v":208.33333333333334},{"$f":"IFERROR(Equipment[Nilai Awal]-(Equipment[Susut Nilai Tahunan\n(Garis Lurus)]*((TODAY()-Equipment[Tarikh Dibeli\natau Pajak])/DaysInYear)),0)","v":25068.493150684932}]
[null,234,"Buat Model 2","Cawangan utama","Baik","Tempatan",4,12500,1500,"2011-03-10",3,7.7499999999999999E-2,120,3000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])+Equipment[[#This Row],[Terma Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])-1,DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])+Equipment[[#This Row],[Terma Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]),DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))-1)=DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))),0)","v":14},{"$f":"IFERROR(-(Equipment[Nilai Awal]>0)*(Equipment[Nilai Awal]<>Equipment[Bayaran Pendahuluan])*PMT(Equipment[Kadar Pinjaman]/MonthsInYear,Equipment[Terma Pinjaman\n(Tahun)]*MonthsInYear,Equipment[Nilai Awal]-Equipment[Bayaran Pendahuluan]),0)","v":343.43280007691891},{"$f":"Equipment[[#This Row],[Bayaran Bulanan]]+Equipment[Kos\nPengendalian Bulanan]","v":463.43280007691891},{"$f":"IFERROR((Equipment[Nilai Awal]>0)*SLN(Equipment[Nilai Awal],Equipment[Nilai Jangkaan pada Penghujung Kontrak],Equipment[Terma Pinjaman\n(Tahun)]),0)","v":3166.6666666666665},{"$f":"IFERROR(Equipment[Susut Nilai Tahunan\n(Garis Lurus)]/MonthsInYear,0)","v":263.88888888888886},{"$f":"IFERROR(Equipment[Nilai Awal]-(Equipment[Susut Nilai Tahunan\n(Garis Lurus)]*((TODAY()-Equipment[Tarikh Dibeli\natau Pajak])/DaysInYear)),0)","v":6721.9178082191784}]
[null,345,"Buat Model 2","Cawangan 1","Sederhana","Lain",1,10000,2500,"2010-09-15",4,0.08,285,1000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])+Equipment[[#This Row],[Terma Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])-1,DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]])+Equipment[[#This Row],[Terma Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]),DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))-1)=DAY(Equipment[[#This Row],[Tarikh Dibeli\natau Pajak]]))),0)","v":20},{"$f":"IFERROR(-(Equipment[Nilai Awal]>0)*(Equipment[Nilai Awal]<>Equipment[Bayaran Pendahuluan])*PMT(Equipment[Kadar Pinjaman]/MonthsInYear,Equipment[Terma Pinjaman\n(Tahun)]*MonthsInYear,Equipment[Nilai Awal]-Equipment[Bayaran Pendahuluan]),0)","v":183.09691756126861},{"$f":"Equipment[[#This Row],[Bayaran Bulanan]]+Equipment[Kos\nPengendalian Bulanan]","v":468.09691756126858},{"$f":"IFERROR((Equipment[Nilai Awal]>0)*SLN(Equipment[Nilai Awal],Equipment[Nilai Jangkaan pada Penghujung Kontrak],Equipment[Terma Pinjaman\n(Tahun)]),0)","v":2250},{"$f":"IFERROR(Equipment[Susut Nilai Tahunan\n(Garis Lurus)]/MonthsInYear,0)","v":187.5},{"$f":"IFERROR(Equipment[Nilai Awal]-(Equipment[Susut Nilai Tahunan\n(Garis Lurus)]*((TODAY()-Equipment[Tarikh Dibeli\natau Pajak])/DaysInYear)),0)","v":4809.58904109589}]
[null,"Jumlah  ",null,null,null,null,{"$f":"SUBTOTAL(101,Equipment[Baki\nTahun Perkhidmatan ])","v":3.3333333333333335},{"$f":"SUBTOTAL(109,Equipment[Nilai Awal])","v":52500},{"$f":"SUBTOTAL(109,Equipment[Bayaran Pendahuluan])","v":9000},null,{"$f":"SUBTOTAL(101,Equipment[Terma Pinjaman\n(Tahun)])","v":3.6666666666666665},{"$f":"SUBTOTAL(101,Equipment[Kadar Pinjaman])","v":8.5833333333333331E-2},{"$f":"SUBTOTAL(109,Equipment[Kos\nPengendalian Bulanan])","v":605},{"$f":"SUBTOTAL(109,Equipment[Nilai Jangkaan pada Penghujung Kontrak])","v":24000},{"$f":"SUBTOTAL(101,Equipment[Baki\nBayaran Bulanan])","v":19.333333333333332},{"$f":"SUBTOTAL(109,Equipment[Bayaran Bulanan])","v":1160.5943035068672},{"$f":"SUBTOTAL(109,Equipment[Jumlah Kos Bulanan])","v":1765.5943035068672},{"$f":"SUBTOTAL(101,Equipment[Susut Nilai Tahunan\n(Garis Lurus)])","v":2638.8888888888887},{"$f":"SUBTOTAL(101,Equipment[Susut Nilai Bulanan\n(Garis Lurus)])","v":219.90740740740739},{"$f":"SUBTOTAL(109,Equipment[Nilai Semasa])","v":36600}]

{"sheet":"Data Pangsi","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"Data Pangsi"]
[null,"Helaian ini sepatutnya kekal tersembunyi. Mengubah struktur Jadual Pangsi pada helaian ini akan menyebabkan ralat dalam Penghiris Papan Pemuka."]
[]
[null,"Perihalan Item","(Semua)"]
[null,"Lokasi","(Semua)"]
[null,"Syarat","(Semua)"]
[null,"Vendor","(Semua)"]
[null,"Baki\nTahun Perkhidmatan ","(Semua)"]
[null,"Terma Pinjaman","(Semua)"]
[]
[null,"Label Baris","Kiraan","Kos Pengendalian","Amaun Pembayaran","Hasil Tambah bagi Jumlah Kos Bulanan","Susut Nilai Bulanan","Hasil Tambah bagi Nilai Semasa"]
[null,123,1,200,634.06458586867973,834.06458586867973,208.33333333333334,25143.835616438359]
[null,234,1,120,343.43280007691891,463.43280007691891,263.88888888888886,6817.3515981735163]
[null,345,1,285,183.09691756126861,468.09691756126858,187.5,4877.3972602739732]
[null,"Jumlah Besar",3,605,1160.5943035068672,1765.5943035068672,659.72222222222217,36838.584474885851]