{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["DAFTAR INVENTARIS PERLENGKAPAN"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"DAFTAR INVENTARIS PERLENGKAPAN","index":0,"n_rows":9,"n_cols":19,"rows_kept":9,"merged":[[0,1,0,5],[0,6,0,9],[0,10,0,12],[0,13,0,14],[2,1,2,6],[2,7,2,18]]}
[null,"DAFTAR INVENTARIS PERLENGKAPAN"]
[]
[null,"KONDISI FISIK",{"$nulls":5},"STATUS KEUANGAN"]
[null,"Aset atau nomor seri","Deskripsi item (merek dan model)","Lokasi","Kondisi","Vendor","Tahun servis tersisa ","Nilai awal","Uang muka","Tanggal dibeli atau disewakan","Masa sewa dalam tahun","Tarif sewa","Pembayaran \nbulanan","Biaya operasional bulanan","Total biaya bulanan","Perkiraan nilai di akhir masa sewa","Penyusutan tahunan dengan garis lurus","Penyusutan bulanan dengan garis lurus","Nilai saat ini"]
[null,123,"Merek dan Model","Cabang utama","Baik","lokal",5,{"v":300000000,"d":"Rp300,000,000.00"},{"v":50000000,"d":"Rp50,000,000.00"},{"$f":"DATE(YEAR(TODAY())-2, 1,1)","v":"2016-01-01"},4,{"v":0.1,"d":"10.00%"},{"$f":"IFERROR(IF(AND(Data[[#This Row],[Nilai awal]]>0,Data[[#This Row],[Nilai awal]]<>Data[[#This Row],[Uang muka]]),-1*PMT(Data[[#This Row],[Tarif sewa]]/12,Data[[#This Row],[Masa sewa dalam tahun]]*12,Data[[#This Row],[Nilai awal]]-Data[[#This Row],[Uang muka]]),0),0)","v":{"v":6340645.858686796,"d":"Rp6,340,645.86"}},{"v":2000000,"d":"Rp2,000,000.00"},{"$f":"IFERROR(Data[[#This Row],[Biaya operasional bulanan]]+Data[[#This Row],[Pembayaran \nbulanan]],\"\")","v":{"v":8340645.858686796,"d":"Rp8,340,645.86"}},{"v":200000000,"d":"Rp200,000,000.00"},{"$f":"IFERROR(IF(Data[[#This Row],[Nilai awal]]>0,SLN(Data[[#This Row],[Nilai awal]],Data[[#This Row],[Perkiraan nilai di akhir masa sewa]],Data[[#This Row],[Tahun servis tersisa ]]),0),0)","v":{"v":20000000,"d":"Rp20,000,000.00"}},{"$f":"IFERROR(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]/12,0)","v":{"v":1666666.6666666667,"d":"Rp1,666,666.67"}},{"$f":"IFERROR(Data[[#This Row],[Nilai awal]]-(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]*((TODAY()-Data[[#This Row],[Tanggal dibeli atau disewakan]])/365)),0)","v":{"v":250136986.30136985,"d":"Rp250,136,986.30"}}]
[null,456,"Merek dan Model","Cabang utama","Sangat baik","lokal",3,{"v":50000000,"d":"Rp50,000,000.00"},{"v":50000000,"d":"Rp50,000,000.00"},{"$f":"DATE(YEAR(TODAY())-1, 1,1)","v":"2017-01-01"},null,null,{"$f":"IFERROR(IF(AND(Data[[#This Row],[Nilai awal]]>0,Data[[#This Row],[Nilai awal]]<>Data[[#This Row],[Uang muka]]),-1*PMT(Data[[#This Row],[Tarif sewa]]/12,Data[[#This Row],[Masa sewa dalam tahun]]*12,Data[[#This Row],[Nilai awal]]-Data[[#This Row],[Uang muka]]),0),0)","v":{"v":0,"d":"Rp0.00"}},{"v":200000,"d":"Rp200,000.00"},{"$f":"IFERROR(Data[[#This Row],[Biaya operasional bulanan]]+Data[[#This Row],[Pembayaran \nbulanan]],\"\")","v":{"v":200000,"d":"Rp200,000.00"}},null,{"$f":"IFERROR(IF(Data[[#This Row],[Nilai awal]]>0,SLN(Data[[#This Row],[Nilai awal]],Data[[#This Row],[Perkiraan nilai di akhir masa sewa]],Data[[#This Row],[Tahun servis tersisa ]]),0),0)","v":{"v":16666666.666666666,"d":"Rp16,666,666.67"}},{"$f":"IFERROR(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]/12,0)","v":{"v":1388888.8888888888,"d":"Rp1,388,888.89"}},{"$f":"IFERROR(Data[[#This Row],[Nilai awal]]-(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]*((TODAY()-Data[[#This Row],[Tanggal dibeli atau disewakan]])/365)),0)","v":{"v":25159817.351598173,"d":"Rp25,159,817.35"}}]
[null,789,"Merek dan Model","Pesisir timur","Cukup baik","lokal",6,{"v":500000000,"d":"Rp500,000,000.00"},{"v":200000000,"d":"Rp200,000,000.00"},{"$f":"TODAY()","v":"2018-06-29"},5,{"v":0.05,"d":"5.00%"},{"$f":"IFERROR(IF(AND(Data[[#This Row],[Nilai awal]]>0,Data[[#This Row],[Nilai awal]]<>Data[[#This Row],[Uang muka]]),-1*PMT(Data[[#This Row],[Tarif sewa]]/12,Data[[#This Row],[Masa sewa dalam tahun]]*12,Data[[#This Row],[Nilai awal]]-Data[[#This Row],[Uang muka]]),0),0)","v":{"v":5661370.09320328,"d":"Rp5,661,370.09"}},{"v":400000,"d":"Rp400,000.00"},{"$f":"IFERROR(Data[[#This Row],[Biaya operasional bulanan]]+Data[[#This Row],[Pembayaran \nbulanan]],\"\")","v":{"v":6061370.09320328,"d":"Rp6,061,370.09"}},{"v":15000000,"d":"Rp15,000,000.00"},{"$f":"IFERROR(IF(Data[[#This Row],[Nilai awal]]>0,SLN(Data[[#This Row],[Nilai awal]],Data[[#This Row],[Perkiraan nilai di akhir masa sewa]],Data[[#This Row],[Tahun servis tersisa ]]),0),0)","v":{"v":80833333.33333333,"d":"Rp80,833,333.33"}},{"$f":"IFERROR(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]/12,0)","v":{"v":6736111.111111111,"d":"Rp6,736,111.11"}},{"$f":"IFERROR(Data[[#This Row],[Nilai awal]]-(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]*((TODAY()-Data[[#This Row],[Tanggal dibeli atau disewakan]])/365)),0)","v":{"v":500000000,"d":"Rp500,000,000.00"}}]
[{"$nulls":12},{"$f":"IFERROR(IF(AND(Data[[#This Row],[Nilai awal]]>0,Data[[#This Row],[Nilai awal]]<>Data[[#This Row],[Uang muka]]),-1*PMT(Data[[#This Row],[Tarif sewa]]/12,Data[[#This Row],[Masa sewa dalam tahun]]*12,Data[[#This Row],[Nilai awal]]-Data[[#This Row],[Uang muka]]),0),0)","v":{"v":0,"d":"Rp0.00"}},null,{"$f":"IFERROR(Data[[#This Row],[Biaya operasional bulanan]]+Data[[#This Row],[Pembayaran \nbulanan]],\"\")","v":{"v":0,"d":"Rp0.00"}},null,{"$f":"IFERROR(IF(Data[[#This Row],[Nilai awal]]>0,SLN(Data[[#This Row],[Nilai awal]],Data[[#This Row],[Perkiraan nilai di akhir masa sewa]],Data[[#This Row],[Tahun servis tersisa ]]),0),0)","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]/12,0)","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(Data[[#This Row],[Nilai awal]]-(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]*((TODAY()-Data[[#This Row],[Tanggal dibeli atau disewakan]])/365)),0)","v":{"v":0,"d":"Rp0.00"}}]
[{"$nulls":12},{"$f":"IFERROR(IF(AND(Data[[#This Row],[Nilai awal]]>0,Data[[#This Row],[Nilai awal]]<>Data[[#This Row],[Uang muka]]),-1*PMT(Data[[#This Row],[Tarif sewa]]/12,Data[[#This Row],[Masa sewa dalam tahun]]*12,Data[[#This Row],[Nilai awal]]-Data[[#This Row],[Uang muka]]),0),0)","v":{"v":0,"d":"Rp0.00"}},null,{"$f":"IFERROR(Data[[#This Row],[Biaya operasional bulanan]]+Data[[#This Row],[Pembayaran \nbulanan]],\"\")","v":{"v":0,"d":"Rp0.00"}},null,{"$f":"IFERROR(IF(Data[[#This Row],[Nilai awal]]>0,SLN(Data[[#This Row],[Nilai awal]],Data[[#This Row],[Perkiraan nilai di akhir masa sewa]],Data[[#This Row],[Tahun servis tersisa ]]),0),0)","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]/12,0)","v":{"v":0,"d":"Rp0.00"}},{"$f":"IFERROR(Data[[#This Row],[Nilai awal]]-(Data[[#This Row],[Penyusutan tahunan dengan garis lurus]]*((TODAY()-Data[[#This Row],[Tanggal dibeli atau disewakan]])/365)),0)","v":{"v":0,"d":"Rp0.00"}}]