{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dasbor","Daftar Perlengkapan","Data Pivot"],"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":"Dasbor","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Dasbor"]
[]
[]
[null,null,null,null,null,"Total Hitung"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Hitung\",'Data Pivot'!$B$11)","v":3}]
[]
[null,null,null,null,null,"Total Biaya Bulanan"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Total Biaya Bulanan\",'Data Pivot'!$B$11)","v":1765.5943035068672}]
[]
[null,null,null,null,null,"Biaya Operasi"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Biaya Operasi\",'Data Pivot'!$B$11)","v":605}]
[]
[null,null,null,null,null,"Depresiasi Bulanan"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Depresiasi Bulanan\",'Data Pivot'!$B$11)","v":659.72222222222217}]
[]
[null,null,null,null,null,"Jumlah Pembayaran"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Jumlah Pembayaran\",'Data Pivot'!$B$11)","v":1160.5943035068672}]
[]
[null,null,null,null,null,"Nilai Saat Ini"]
[null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Nilai Saat Ini \",'Data Pivot'!$B$11)","v":36600}]

{"sheet":"Daftar Perlengkapan","index":1,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Daftar Perlengkapan"]
[]
[null,null,null,"Sorot bila sisa biaya pembayaran bulanan kurang dari: ",20]
[]
[null,"Aset atau\nNomor Seri","Deskripsi Item\n(Buatan dan Model)","Lokasi","Kondisi","Vendor","Tahun\nSisa Layanan ","Nilai Awal","Uang Muka","Tanggal Beli\natau Sewa","Jangka Waktu Pinjaman\n(Tahun)","Suku Bunga Pinjaman","Biaya\nOperasi Bulanan","Nilai Yang Diharapkan pada Akhir Kontrak","Sisa\nPembayaran Bulanan","Pembayaran Bulanan","Total\nBiaya Bulanan","Depresiasi Tahunan\n(Garis Lurus)","Depresiasi Bulanan\n(Garis Lurus)","Nilai Saat Ini"]
[null,123,"Buatan Model 1","Cabang utama","Baik","Lokal",5,30000,5000,"2011-01-15",4,0.1,200,20000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Tanggal Beli\natau Sewa]])+Equipment[[#This Row],[Jangka Waktu Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tanggal Beli\natau Sewa]])-1,DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Tanggal Beli\natau Sewa]])+Equipment[[#This Row],[Jangka Waktu Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]),DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))-1)=DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))),0)","v":24},{"$f":"IFERROR(-(Equipment[Nilai Awal]>0)*(Equipment[Nilai Awal]<>Equipment[Uang Muka])*PMT(Equipment[Suku Bunga Pinjaman]/MonthsInYear,Equipment[Jangka Waktu Pinjaman\n(Tahun)]*MonthsInYear,Equipment[Nilai Awal]-Equipment[Uang Muka]),0)","v":634.06458586867973},{"$f":"Equipment[[#This Row],[Pembayaran Bulanan]]+Equipment[Biaya\nOperasi Bulanan]","v":834.06458586867973},{"$f":"IFERROR((Equipment[Nilai Awal]>0)*SLN(Equipment[Nilai Awal],Equipment[Nilai Yang Diharapkan pada Akhir Kontrak],Equipment[Jangka Waktu Pinjaman\n(Tahun)]),0)","v":2500},{"$f":"IFERROR(Equipment[Depresiasi Tahunan\n(Garis Lurus)]/MonthsInYear,0)","v":208.33333333333334},{"$f":"IFERROR(Equipment[Nilai Awal]-(Equipment[Depresiasi Tahunan\n(Garis Lurus)]*((TODAY()-Equipment[Tanggal Beli\natau Sewa])/DaysInYear)),0)","v":25068.493150684932}]
[null,234,"Buatan Model 2","Cabang utama","Baik","Lokal",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],[Tanggal Beli\natau Sewa]])+Equipment[[#This Row],[Jangka Waktu Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tanggal Beli\natau Sewa]])-1,DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Tanggal Beli\natau Sewa]])+Equipment[[#This Row],[Jangka Waktu Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]),DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))-1)=DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))),0)","v":14},{"$f":"IFERROR(-(Equipment[Nilai Awal]>0)*(Equipment[Nilai Awal]<>Equipment[Uang Muka])*PMT(Equipment[Suku Bunga Pinjaman]/MonthsInYear,Equipment[Jangka Waktu Pinjaman\n(Tahun)]*MonthsInYear,Equipment[Nilai Awal]-Equipment[Uang Muka]),0)","v":343.43280007691891},{"$f":"Equipment[[#This Row],[Pembayaran Bulanan]]+Equipment[Biaya\nOperasi Bulanan]","v":463.43280007691891},{"$f":"IFERROR((Equipment[Nilai Awal]>0)*SLN(Equipment[Nilai Awal],Equipment[Nilai Yang Diharapkan pada Akhir Kontrak],Equipment[Jangka Waktu Pinjaman\n(Tahun)]),0)","v":3166.6666666666665},{"$f":"IFERROR(Equipment[Depresiasi Tahunan\n(Garis Lurus)]/MonthsInYear,0)","v":263.88888888888886},{"$f":"IFERROR(Equipment[Nilai Awal]-(Equipment[Depresiasi Tahunan\n(Garis Lurus)]*((TODAY()-Equipment[Tanggal Beli\natau Sewa])/DaysInYear)),0)","v":6721.9178082191784}]
[null,345,"Buatan Model 2","Cabang 1","Sedang","Lainnya",1,10000,2500,"2010-09-15",4,0.08,285,1000,{"$f":"IFERROR(SUMPRODUCT(--(DAY(ROW(OFFSET($A$1,,,DATE(YEAR(Equipment[[#This Row],[Tanggal Beli\natau Sewa]])+Equipment[[#This Row],[Jangka Waktu Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tanggal Beli\natau Sewa]])-1,DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))-TODAY()))+DATE(YEAR(Equipment[[#This Row],[Tanggal Beli\natau Sewa]])+Equipment[[#This Row],[Jangka Waktu Pinjaman\n(Tahun)]],MONTH(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]),DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))-1)=DAY(Equipment[[#This Row],[Tanggal Beli\natau Sewa]]))),0)","v":20},{"$f":"IFERROR(-(Equipment[Nilai Awal]>0)*(Equipment[Nilai Awal]<>Equipment[Uang Muka])*PMT(Equipment[Suku Bunga Pinjaman]/MonthsInYear,Equipment[Jangka Waktu Pinjaman\n(Tahun)]*MonthsInYear,Equipment[Nilai Awal]-Equipment[Uang Muka]),0)","v":183.09691756126861},{"$f":"Equipment[[#This Row],[Pembayaran Bulanan]]+Equipment[Biaya\nOperasi Bulanan]","v":468.09691756126858},{"$f":"IFERROR((Equipment[Nilai Awal]>0)*SLN(Equipment[Nilai Awal],Equipment[Nilai Yang Diharapkan pada Akhir Kontrak],Equipment[Jangka Waktu Pinjaman\n(Tahun)]),0)","v":2250},{"$f":"IFERROR(Equipment[Depresiasi Tahunan\n(Garis Lurus)]/MonthsInYear,0)","v":187.5},{"$f":"IFERROR(Equipment[Nilai Awal]-(Equipment[Depresiasi Tahunan\n(Garis Lurus)]*((TODAY()-Equipment[Tanggal Beli\natau Sewa])/DaysInYear)),0)","v":4809.58904109589}]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(101,Equipment[Tahun\nSisa Layanan ])","v":3.3333333333333335},{"$f":"SUBTOTAL(109,Equipment[Nilai Awal])","v":52500},{"$f":"SUBTOTAL(109,Equipment[Uang Muka])","v":9000},null,{"$f":"SUBTOTAL(101,Equipment[Jangka Waktu Pinjaman\n(Tahun)])","v":3.6666666666666665},{"$f":"SUBTOTAL(101,Equipment[Suku Bunga Pinjaman])","v":8.5833333333333331E-2},{"$f":"SUBTOTAL(109,Equipment[Biaya\nOperasi Bulanan])","v":605},{"$f":"SUBTOTAL(109,Equipment[Nilai Yang Diharapkan pada Akhir Kontrak])","v":24000},{"$f":"SUBTOTAL(101,Equipment[Sisa\nPembayaran Bulanan])","v":19.333333333333332},{"$f":"SUBTOTAL(109,Equipment[Pembayaran Bulanan])","v":1160.5943035068672},{"$f":"SUBTOTAL(109,Equipment[Total\nBiaya Bulanan])","v":1765.5943035068672},{"$f":"SUBTOTAL(101,Equipment[Depresiasi Tahunan\n(Garis Lurus)])","v":2638.8888888888887},{"$f":"SUBTOTAL(101,Equipment[Depresiasi Bulanan\n(Garis Lurus)])","v":219.90740740740739},{"$f":"SUBTOTAL(109,Equipment[Nilai Saat Ini])","v":36600}]

{"sheet":"Data Pivot","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"Data Pivot"]
[null,"Lembar ini harus tetap tersembunyi. Mengubah struktur PivotTable pada lembar ini bisa menghasilkan kesalahan dalam Pemotong Dasbor."]
[]
[null,"Deskripsi Item\n(Buatan dan Model)","(Semua)"]
[null,"Lokasi","(Semua)"]
[null,"Kondisi","(Semua)"]
[null,"Vendor","(Semua)"]
[null,"Tahun\nSisa Layanan ","(Semua)"]
[null,"Jangka Waktu Pinjaman\n(Tahun)","(Semua)"]
[]
[null,"Label Baris","Hitung","Biaya Operasi","Jumlah Pembayaran","Total Biaya Bulanan","Depresiasi Bulanan","Nilai Saat Ini "]
[null,123,1,200,634.06458586867973,834.06458586867973,208.33333333333334,25068.493150684932]
[null,234,1,120,343.43280007691891,463.43280007691891,263.88888888888886,6721.9178082191784]
[null,345,1,285,183.09691756126861,468.09691756126858,187.5,4809.58904109589]
[null,"Total Keseluruhan",3,605,1160.5943035068672,1765.5943035068672,659.72222222222217,36600]