{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["READ ME","Dasbor","Beban KK","Beban IS","Beban PUE","Parameter Teknis SMG","Daftar Peralatan"],"not_rendered":{"charts":0,"images":30,"macros":0,"external_links":1,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"READ ME","index":0,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[[40,1,40,3],[16,2,17,2],[18,2,19,2],[20,2,21,2],[22,2,23,2],[24,2,25,2],[32,0,32,10],[9,1,11,9],[39,1,39,3],[7,1,7,9],[22,3,23,9],[14,1,14,9],[24,3,25,9],[20,3,21,9],[18,3,19,9],[16,3,17,9],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3]]}
{"$rows_empty":7}
[null,"ALAT PERHITUNGAN DAYA DAN TARIF UNTUK SOLAR MINI-GRID"]
[]
[null,"Alat ini memungkinkan untuk memperkirakan kapasitas solar mini-grid (kW dan kWh) dan investasi (Rp) serta biaya listrik (Rp per bulan). Biaya listrik dihitung berdasarkan praktek umum dalam listrik pedesaan dimana mini-grid dikelola oleh masyarakat itu sendiri."]
[]
[]
[null,"Disusun oleh: Amalia Suryani dan Robert Schultz"]
[null,"Berkolaborasi dengan: Aliyah Fitrotun, David Jarrett, dan Prisma Megantoro"]
[null,"ISTILAH-ISTILAH"]
[]
[null,null,"KK","Kepala keluarga atau rumah tangga, dikategorikan menurut peralatan listrik yang dimiliki: dasar, sedang, tinggi (beberapa KK bisa terbebas dari  tarif listrik)"]
[]
[null,null,"IS","Institusi sosial/fasilitas publik misalnya sekolah, masjid, gereja, pura, pusat kesehatan, lampu jalan"]
[]
[null,null,"PUE","Productive use of energy atau bisnis perdesaan misalnya warung, pertukangan kayu, penjahit, bengkel, penetasan telur"]
[]
[null,null,"SMG","Solar mini-grid atau dikenal dengan PLTS (pembangkit listrik tenaga surya)"]
[]
[null,null,"TPD","Tim pengelola desa (TPD): organisasi masyarakat yang bertanggungjawab dalam mengelola dan mengoperasikansolar mini-grid"]
[]
[]
[null,"BAGAIMANA CARA MENGGUNAKAN?"]
[]
[null,"xyz","Isian oleh pengguna",null,"xyz","Sesuai dengan permintaan/konsumsi KK"]
[null,"xyz","Peringatan",null,"xyz","Sesuai dengan permintaan/konsumsi IS"]
[{"$nulls":4},"xyz","Sesuai dengan permintaan/konsumsi PUE"]
["Semua sel berwarna dalam alat ini terkunci untuk memasukkan data, demi menjamin integritas alat."]
[null,"LEMBARAN"]
[]
[null,"Dasbor",null,null,"RINGKASAN hasil perhitungan untuk membuat keputusan"]
[null,"Beban KK",null,null,"Untuk memasukkan peralatan rumah tangga dan waktu pemakaian"]
[null,"Beban IS",null,null,"Untuk memasukkan peralatan institusi sosial dan waktu pemakaian"]
[null,"Beban PUE",null,null,"Untuk memasukkan peralatan bisnis perdesaan dan waktu pemakaian"]
[null,"Parameter Teknis SMG",null,null,"Untuk memasukkan data teknis dan keuangan dasar solar mini-grid"]
[null,"Daftar Peralatan",null,null,"Untuk memasukkan berbagai peralatan listrik dan perkiraan daya (W)"]
[]
[null,"ASUMSI UNTUK PERHITUNGAN"]
[]
[null,"1. Tarif dasar adalah [pengeluaran & tabungan] dibagi dengan [jumlah KK yang membayar]"]
[null,"2. Tarif KK dasar adalah tarif terendah yang disarankan untuk rumah tangga"]
[null,"3. Proporsi IS dihitung secara relatif terhadap tarif dasar"]
[null,"4. Tarif PUE dihitung secara relatif terhadap tarif dasar"]
[null,"5. KK yang juga memiliki bisnis (PUE) harus membayar tarif akumulasi [tarif KK + tarif PUE]"]
[null,"6. Tarif tidak berlaku untuk IS"]
[]
["Untuk informasi lebih lanjut: www.endev-indonesia.org; endev.indonesia@giz.de"]

{"sheet":"Dasbor","index":1,"n_rows":31,"n_cols":22,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,16,5,16],[27,10,27,11],[25,8,25,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[27,8,27,9],[26,8,26,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[0,1,0,22],[1,15,1,22],[1,7,2,13],[1,1,1,5],[3,2,3,3],[6,2,6,3],[28,1,28,3],[23,1,23,3],[26,1,26,3],[27,1,27,3],[24,1,24,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[17,1,18,3],[20,1,20,5],[21,1,21,3],[22,1,22,3],[13,1,13,2],[4,20,5,20],[4,21,5,21],[25,1,25,3],[7,2,7,3],[4,17,5,17],[4,18,5,18],[9,8,9,12],[9,16,9,19],[15,16,15,19],[22,16,22,19],[4,19,5,19],[4,8,4,12],[11,8,11,12],[23,8,23,12],[4,2,4,3],[5,2,5,3],[30,20,30,22],[25,18,25,19],[26,18,26,19],[27,18,27,19],[28,18,28,19],[29,18,29,19],[30,18,30,19],[28,20,28,22],[29,20,29,22],[25,20,25,22],[26,20,26,22],[27,20,27,22]]}
[null,"OUTPUT: Dasbor Hasil Perhitungan"]
[null,"PENGELUARAN TPD",{"$nulls":5},"RINGKASAN",{"$nulls":7},"PERMINTAAN LISTRIK"]
[null,"1) Gaji bulanan"]
[null,null,"Operator 1",null,500000,"IDR/bulan"]
[null,null,"Operator 2",null,400000,"IDR/bulan",null,null,"PASOKAN LISTRIK",{"$nulls":7},"Permintaan rumah tangga (KK)","W per KK","Wh per KK","# Koneksi","Total kW","Total kWh"]
[null,null,"Bendahara",null,300000,"IDR/bulan",null,null,"Total kapasitas pembangkitan",null,{"$f":"E24","v":17},"kW"]
[null,null,"Sekretaris",null,300000,"IDR/bulan",null,null,"Total beban",null,null,{"$f":"U10+U16+U23","v":9.8049999999999997},"kW",null,null,null,{"$f":"'Beban KK'!D2","v":"KK Dasar"},{"$f":"'Beban KK'!F14","v":140},{"$f":"'Beban KK'!G14","v":480},50,{"$f":"R7*T7/1000","v":7},{"$f":"S7*T7/1000","v":24}]
[null,null,"Ketua",null,300000,"IDR/bulan",null,null,"Total permintaan energi",null,{"$f":"V10+V16+V23","v":41.685000000000002},"kWh/hari",{"$nulls":4},{"$f":"'Beban KK'!K2","v":"KK Sedang"},{"$f":"'Beban KK'!M14","v":115},{"$f":"'Beban KK'!N14","v":655},10,{"$f":"R8*T8/1000","v":1.1499999999999999},{"$f":"S8*T8/1000","v":6.55}]
[{"$nulls":4},{"$f":"SUM(E4:E8)","v":1800000},"IDR/bulan",null,null,"Surplus/defisit energi",null,null,{"$f":"E26-K8","v":43.314999999999998},"kWh/hari",null,null,null,{"$f":"'Beban KK'!R2","v":"KK Tinggi"},{"$f":"'Beban KK'!T14","v":475},{"$f":"'Beban KK'!U14","v":655},1,{"$f":"R9*T9/1000","v":0.47499999999999998},{"$f":"S9*T9/1000","v":0.65500000000000003}]
[null,"2) Pemeliharaan bulanan",null,null,100000,"IDR/bulan",null,null,"Apabila energi defisit, kurangi permintaan listrik Anda!",{"$nulls":7},"Total permintaan KK",null,null,null,{"$f":"SUM(U7:U9)","v":8.625},{"$f":"SUM(V7:V9)","v":31.205000000000002}]
[null,"3) Pengeluaran perbaikan",null,null,100000,"IDR/bulan"]
[null,"4) Tabungan yang diharapkan",null,null,200000,"IDR/bulan",null,null,"TARIF PELANGGAN",{"$nulls":7},"Permintaan institusi sosial (IS)","W per IS","Wh per IS","# Koneksi","Total kW","Total kWh"]
[{"$nulls":8},"Tarif dasar:",null,null,{"$f":"E14/(E29-K15)","v":36065.573770491806},"IDR/bulan",null,null,null,{"$f":"'Beban IS'!E2","v":"Sekolah"},{"$f":"'Beban IS'!F14","v":120},{"$f":"'Beban IS'!G14","v":960},1,{"$f":"R13*T13/1000","v":0.12},{"$f":"S13*T13/1000","v":0.96}]
[null,"Total PENGELUARAN",null,null,{"$f":"E9+E10+E11+E12","v":2200000},"IDR/bulan",null,null,"Proporsi IS:",null,0.05,{"$f":"L13*K14","v":1803.2786885245905},"IDR/bulan",null,null,null,{"$f":"'Beban IS'!L2","v":"Lampu jalan"},{"$f":"'Beban IS'!M14","v":10},{"$f":"'Beban IS'!N14","v":80},50,{"$f":"R14*T14/1000","v":0.5},{"$f":"S14*T14/1000","v":4}]
[{"$nulls":8},"Jumlah KK terbebas dari tarif:",null,0,"KK",{"$nulls":4},{"$f":"'Beban IS'!S2","v":"Tipe 3"},{"$f":"'Beban IS'!T14","v":0},{"$f":"'Beban IS'!U14","v":0},0,{"$f":"R15*T15/1000","v":0},{"$f":"S15*T15/1000","v":0}]
[null,"Total PEMASUKAN",null,null,{"$f":"SUM(U26:U31)","v":2897361.680327869},"IDR/bulan",null,null,{"$f":"IF(T7=0,\"\",'Beban KK'!D2)","v":"KK Dasar"},null,null,{"$f":"L13+L14","v":37868.852459016394},"IDR/bulan",null,null,null,"Total permintaan IS",null,null,null,{"$f":"SUM(U13:U15)","v":0.62},{"$f":"SUM(V13:V15)","v":4.96}]
[{"$nulls":8},{"$f":"IF(T8=0,\"\",'Beban KK'!K2)","v":"KK Sedang"},null,null,{"$f":"IF(T8=0,\"\",(S8/S7)*L16)","v":51675.204918032789},"IDR/bulan"]
[null,"Untung/Defisit Aktual",null,null,{"$f":"E16-E14","v":697361.68032786902},"IDR/bulan",null,null,{"$f":"IF(T9=0,\"\",'Beban KK'!R2)","v":"KK Tinggi"},null,null,{"$f":"IF(T9=0,\"\",(S9/S7)*L16)","v":51675.204918032789},"IDR/bulan",null,null,null,"Permintaan bisnis perdesaan (PUE)","W per PUE","Wh per PUE","# Koneksi","Total kW","Total kWh"]
[{"$nulls":4},{"$f":"E18*12","v":8368340.1639344282},"IDR/tahun",null,null,{"$f":"IF(T19=0,\"\",'Beban PUE'!D2)","v":"Penjahit"},null,null,{"$f":"IF(T19=0,\"\",(S19/S7)*L16)","v":56803.278688524588},"IDR/bulan",null,null,null,{"$f":"'Beban PUE'!D2","v":"Penjahit"},{"$f":"'Beban PUE'!F14","v":360},{"$f":"'Beban PUE'!G14","v":720},1,{"$f":"R19*T19/1000","v":0.36},{"$f":"S19*T19/1000","v":0.72}]
[{"$nulls":8},{"$f":"IF(T20=0,\"\",'Beban PUE'!K2)","v":"Penetasan telur"},null,null,{"$f":"IF(T20=0,\"\",(S20/S7)*L16)","v":378688.52459016396},"IDR/bulan",null,null,null,{"$f":"'Beban PUE'!K2","v":"Penetasan telur"},{"$f":"'Beban PUE'!M14","v":200},{"$f":"'Beban PUE'!N14","v":4800},1,{"$f":"R20*T20/1000","v":0.2},{"$f":"S20*T20/1000","v":4.8}]
[null,"PASOKAN LISTRIK",{"$nulls":6},{"$f":"IF(T21=0,\"\",'Beban PUE'!D16)","v":""},null,null,{"$f":"IF(S21=0,\"\",(S21/S7)*L16)","v":""},"IDR/bulan",null,null,null,{"$f":"'Beban PUE'!D16","v":"Tipe 3"},{"$f":"'Beban PUE'!F28","v":0},{"$f":"'Beban PUE'!G28","v":0},0,{"$f":"R21*T21/1000","v":0},{"$f":"S21*T21/1000","v":0}]
[null,"Kapasitas pembangkitan listrik",null,null,20,"kW",null,null,{"$f":"IF(T22=0,\"\",'Beban PUE'!K16)","v":""},null,null,{"$f":"IF(S22=0,\"\",(S22/S7)*L16)","v":""},"IDR/bulan",null,null,null,{"$f":"'Beban PUE'!K16","v":"Tipe 4"},{"$f":"'Beban PUE'!M28","v":0},{"$f":"'Beban PUE'!N28","v":0},0,{"$f":"R22*T22/1000","v":0},{"$f":"S22*T22/1000","v":0}]
[null,"Faktor Ketersediaan dan Efisiensi",null,null,0.85,"%",{"$nulls":10},"Total permintaan PUE",null,null,null,{"$f":"SUM(U19:U22)","v":0.56000000000000005},{"$f":"SUM(V19:V22)","v":5.52}]
[null,"Kapasitas tersedia",null,null,{"$f":"E22*E23","v":17},"kW",null,null,"LAINNYA"]
[null,"Waktu pembangkitan per hari",null,null,{"$f":"'Parameter Teknis SMG'!D21","v":5},"jam",null,null,"Jumlah modul PV yang diperlukan",null,null,{"$f":"'Parameter Teknis SMG'!K13","v":100},"Modul PV"]
[null,"Energi terbangkit per hari (pasokan)",null,null,{"$f":"E24*E25","v":85},"kWh",null,null,"Jumlah baterai yang diperlukan",null,null,{"$f":"'Parameter Teknis SMG'!K15","v":145},"Baterai",{"$nulls":5},{"$f":"Q7","v":"KK Dasar"},null,{"$f":"IF(T7=0,\"\",T7*L16)","v":1893442.6229508198}]
[null,"Konsumsi energi per hari (permintaan)",null,null,{"$f":"K8","v":41.685000000000002},"kWh",null,null,"Luas tanah yang diperlukan",null,null,{"$f":"'Parameter Teknis SMG'!L19","v":572.5},"m2",{"$nulls":5},{"$f":"Q8","v":"KK Sedang"},null,{"$f":"IF(T8=0,\"\",T8*L17)","v":516752.04918032791}]
[null,"Surplus/defisit energi per hari",null,null,{"$f":"E26-E27","v":43.314999999999998},"kWh",null,null,"Perkiraan biaya infrastruktur",null,{"$f":"'Parameter Teknis SMG'!G14","v":3007000000},null,"IDR",{"$nulls":5},{"$f":"Q9","v":"KK Tinggi"},null,{"$f":"IF(T9=0,\"\",T9*L18)","v":51675.204918032789}]
[null,"Jumlah KK di desa",null,null,{"$f":"SUM(T7:T9)","v":61},"KK",{"$nulls":12},{"$f":"Q19","v":"Penjahit"},null,{"$f":"IF(T19=0,\"\",T19*L19)","v":56803.278688524588}]
[{"$nulls":18},{"$f":"Q20","v":"Penetasan telur"},null,{"$f":"IF(T20=0,\"\",T20*L20)","v":378688.52459016396}]
[{"$nulls":18},{"$f":"Q22","v":"Tipe 4"},null,{"$f":"IF(T22=0,\"\",T22*L22)","v":""}]

{"sheet":"Beban KK","index":2,"n_rows":14,"n_cols":21,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,20],[1,10,1,13],[1,17,1,20],[1,3,1,6],[1,1,1,2],[13,1,13,4],[13,8,13,11],[13,15,13,18],[1,8,1,9],[1,15,1,16]]}
[null,"INPUT: Perhitungan Beban Harian Rumah Tangga (KK)"]
[null,"Permintaan rumah tangga:",null,"KK Dasar",{"$nulls":4},"Permintaan rumah tangga:",null,"KK Sedang",{"$nulls":4},"Permintaan rumah tangga:",null,"KK Tinggi"]
[null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh",null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh",null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh"]
[null,"Lampu (fluorescent)",{"$f":"VLOOKUP(B4,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":20},3,4,{"$f":"C4*D4","v":60},{"$f":"E4*F4","v":240},null,"Lampu (fluorescent)",{"$f":"VLOOKUP(I4,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":20},3,8,{"$f":"J4*K4","v":60},{"$f":"L4*M4","v":480},null,"Lampu (fluorescent)",{"$f":"VLOOKUP(P4,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":20},1,2,{"$f":"Q4*R4","v":20},{"$f":"S4*T4","v":40}]
[null,"Kipas angin",{"$f":"VLOOKUP(B5,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":40},2,3,{"$f":"C5*D5","v":80},{"$f":"E5*F5","v":240},null,"Kipas angin",{"$f":"VLOOKUP(I5,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":40},1,4,40,160,null,"Handphone charger",{"$f":"VLOOKUP(P5,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":15},1,1,{"$f":"Q5*R5","v":15},{"$f":"S5*T5","v":15}]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B6,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,{"$f":"C6*D6","v":0},0,null,"Handphone charger",{"$f":"VLOOKUP(I6,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":15},1,1,15,15,null,"Kipas angin",{"$f":"VLOOKUP(P6,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":40},1,5,{"$f":"Q6*R6","v":40},200]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B7,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,{"$f":"C7*D7","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I7,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Rice cooker",{"$f":"VLOOKUP(P7,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":400},1,1,{"$f":"Q7*R7","v":400},400]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B8,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,{"$f":"C8*D8","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I8,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P8,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,{"$f":"Q8*R8","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B9,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I9,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P9,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B10,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I10,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P10,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B11,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I11,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P11,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B12,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I12,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P12,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B13,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I13,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P13,'Daftar Peralatan'!$B$4:$C$23,2,FALSE)","v":0},0,0,0,0]
[null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(F4:F13)","v":140},{"$f":"SUM(G4:G13)","v":480},null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(M4:M13)","v":115},{"$f":"SUM(N4:N13)","v":655},null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(T4:T13)","v":475},{"$f":"SUM(U4:U13)","v":655}]

{"sheet":"Beban IS","index":3,"n_rows":14,"n_cols":21,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,4],[13,8,13,11],[13,15,13,18],[0,1,0,20],[1,1,1,3],[1,4,1,6],[1,8,1,10],[1,11,1,13],[1,15,1,17],[1,18,1,20]]}
[null,"INPUT: Perhitungan Beban Harian Institusi Sosial (IS)"]
[null,"Permintaan IS:",null,null,"Sekolah",null,null,null,"Permintaan IS:",null,null,"Lampu jalan",null,null,null,"Permintaan IS:",null,null,"Tipe 3"]
[null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh",null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh",null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh"]
[null,"Lampu",{"$f":"VLOOKUP(B4,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":20},6,8,{"$f":"C4*D4","v":120},{"$f":"E4*F4","v":960},null,"Lampu jalan",{"$f":"VLOOKUP(I4,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":10},1,8,{"$f":"J4*K4","v":10},{"$f":"L4*M4","v":80},null,"Pilih peralatan",{"$f":"VLOOKUP(P4,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,{"$f":"Q4*R4","v":0},{"$f":"S4*T4","v":0}]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B5,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,{"$f":"C5*D5","v":0},{"$f":"E5*F5","v":0},null,"Pilih peralatan",{"$f":"VLOOKUP(I5,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},0,0,{"$f":"J5*K5","v":0},{"$f":"L5*M5","v":0},null,"Pilih peralatan",{"$f":"VLOOKUP(P5,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},0,0,{"$f":"Q5*R5","v":0},{"$f":"S5*T5","v":0}]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B6,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},0,0,{"$f":"C6*D6","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I6,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},0,0,{"$f":"J6*K6","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(P6,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},0,0,{"$f":"Q6*R6","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B7,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,{"$f":"C7*D7","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I7,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,{"$f":"J7*K7","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(P7,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,{"$f":"Q7*R7","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B8,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,{"$f":"C8*D8","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I8,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,{"$f":"J8*K8","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(P8,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,{"$f":"Q8*R8","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B9,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I9,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P9,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B10,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I10,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P10,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B11,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I11,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P11,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B12,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I12,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P12,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B13,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I13,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(P13,'Daftar Peralatan'!$E$4:$F$23,2,FALSE)","v":0},null,null,0,0]
[null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(F4:F13)","v":120},{"$f":"SUM(G4:G13)","v":960},null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(M4:M13)","v":10},{"$f":"SUM(N4:N13)","v":80},null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(T4:T13)","v":0},{"$f":"SUM(U4:U13)","v":0}]

{"sheet":"Beban PUE","index":4,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,4],[27,8,27,11],[0,1,0,14],[1,1,1,2],[1,8,1,9],[15,1,15,2],[15,8,15,9],[13,1,13,4],[13,8,13,11],[1,3,1,6],[1,10,1,13],[15,3,15,6],[15,10,15,13]]}
[null,"INPUT: Perhitungan Beban Harian Bisnis (PUE)"]
[null,"Permintaan PUE:",null,"Penjahit",{"$nulls":4},"Permintaan PUE:",null,"Penetasan telur"]
[null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh",null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh"]
[null,"Mesin jahit",{"$f":"VLOOKUP(B4,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":120},3,2,{"$f":"C4*D4","v":360},{"$f":"E4*F4","v":720},null,"Inkubator telur",{"$f":"VLOOKUP(I4,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":200},1,24,{"$f":"J4*K4","v":200},{"$f":"L4*M4","v":4800}]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B5,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"C5*D5","v":0},{"$f":"E5*F5","v":0},null,"Pilih peralatan",{"$f":"VLOOKUP(I5,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},0,0,{"$f":"J5*K5","v":0},{"$f":"L5*M5","v":0}]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B6,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"C6*D6","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I6,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},0,0,{"$f":"J6*K6","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B7,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"C7*D7","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I7,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"J7*K7","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B8,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"C8*D8","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I8,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"J8*K8","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B9,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I9,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B10,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I10,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B11,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I11,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B12,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I12,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B13,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I13,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(F4:F13)","v":360},{"$f":"SUM(G4:G13)","v":720},null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(M4:M13)","v":200},{"$f":"SUM(N4:N13)","v":4800}]
[]
[null,"Permintaan PUE:",null,"Tipe 3",{"$nulls":4},"Permintaan PUE:",null,"Tipe 4"]
[null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh",null,"Peralatan","Wattage","Jml","Jam/\nHari","Total W","Total Wh"]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B18,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"C18*D18","v":0},{"$f":"E18*F18","v":0},null,"Pilih peralatan",{"$f":"VLOOKUP(I18,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"J18*K18","v":0},{"$f":"L18*M18","v":0}]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B19,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},0,0,{"$f":"C19*D19","v":0},{"$f":"E19*F19","v":0},null,"Pilih peralatan",{"$f":"VLOOKUP(I19,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"J19*K19","v":0},{"$f":"L19*M19","v":0}]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B20,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},0,0,{"$f":"C20*D20","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I20,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},0,0,{"$f":"J20*K20","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B21,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"C21*D21","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I21,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"J21*K21","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B22,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"C22*D22","v":0},0,null,"Pilih peralatan",{"$f":"VLOOKUP(I22,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,{"$f":"J22*K22","v":0},0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B23,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I23,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B24,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I24,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B25,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I25,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B26,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I26,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Pilih peralatan",{"$f":"VLOOKUP(B27,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0,null,"Pilih peralatan",{"$f":"VLOOKUP(I27,'Daftar Peralatan'!$H$4:$I$39,2,FALSE)","v":0},null,null,0,0]
[null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(F18:F27)","v":0},{"$f":"SUM(G18:G27)","v":0},null,"Permintaan/konsumsi harian",null,null,null,{"$f":"SUM(M18:M27)","v":0},{"$f":"SUM(N18:N27)","v":0}]

{"sheet":"Parameter Teknis SMG","index":5,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,11],[22,1,22,3],[14,5,14,7],[1,1,1,3],[1,5,1,7],[1,9,1,11],[2,9,2,11],[10,9,10,11],[7,1,7,3],[10,1,10,3],[3,1,3,3],[19,1,19,3],[13,1,13,3]]}
[null,"INPUT: Parameter Teknis Solar Mini-grid (SMG)"]
[null,"Spesifikasi Teknis SMG",null,null,null,"Biaya Pemasangan SMG",null,null,null,"Ringkasan"]
[null,"Parameter","Unit","Nilai",null,null,null,"Konversi mata uang",null,"Pelanggan listrik"]
[null,"MODUL SURYA",null,null,null,"Komponen","Total Biaya",15500,null,"Tipe","Jumlah","Energi per Hari"]
[null,"Power","Wp",200,null,"Modul PV",{"$f":"D7*K13","v":500000000},{"$f":"G5/$H$4","v":32258.064516129034},null,{"$f":"Dasbor!Q5","v":"Permintaan rumah tangga (KK)"},{"$f":"SUM(Dasbor!T7:T9)","v":61},{"$f":"SUM(Dasbor!V10)","v":31.205000000000002}]
[null,"Module Type",null,"Thin Film PV",null,"Controller",{"$f":"D10*K14","v":18000000},1161.2903225806451,null,{"$f":"Dasbor!Q12","v":"Permintaan institusi sosial (IS)"},{"$f":"SUM(Dasbor!T13:T15)","v":51},{"$f":"SUM(Dasbor!V16)","v":4.96}]
[null,"Harga Unit",null,5000000,null,"Baterai",{"$f":"D19*K15","v":1319500000},85129.032258064515,null,{"$f":"Dasbor!Q18","v":"Permintaan bisnis perdesaan (PUE)"},{"$f":"SUM(Dasbor!T19:T22)","v":2},{"$f":"Dasbor!V23","v":5.52}]
[null,"CHARGE CONTROLLER",null,null,null,"DC/AC Converter",{"$f":"D13*K16","v":320000000},20645.16129032258,null,"Total Energi Dikonsumsi per Hari",null,{"$f":"SUM(L5:L7)","v":41.685000000000002}]
[null,"Rated Power","kWatt",5,null,"Alat lain",250000000,16129.032258064517,null,"Total energi terbangkit per hari",null,{"$f":"L13*D21*Dasbor!E23","v":85}]
[null,"Harga Unit",null,4500000,null,"Lahan",{"$f":"D22*L19","v":286250000},18467.741935483871,null,"Surplus/defisit energi per hari",null,{"$f":"L9-L8","v":43.314999999999998}]
[null,"INVERTER",null,null,null,"Transportasi",{"$f":"SUM(G5:G9)*H17","v":0},0,null,"Instalasi SMG"]
[null,"Rated Power","kWatt",6,null,"Tenaga kerja",{"$f":"H18*(G5+G6+G7+G8+G9)","v":240750000},15532.258064516129,null,"Tipe","Jumlah","Kapasitas Total"]
[null,"Harga Unit",null,80000000,null,"Bangunan",{"$f":"H19*L18","v":72500000},4677.4193548387093,null,"Modul PV",{"$f":"(Dasbor!E22*D27)/'Parameter Teknis SMG'!D5","v":100},{"$f":"(K13*D5)/D27","v":20}]
[null,"BATERAI",null,null,null,"TOTAL",{"$f":"SUM(G5:G13)","v":3007000000},194000,null,"Charge Controller",{"$f":"ROUNDUP(L13/'Parameter Teknis SMG'!D9,0)","v":4},{"$f":"ROUNDUP(K14*D9,3)","v":20}]
[null,"Op. Voltage","Volt",2,null,"Asumsi untuk Perhitungan",null,null,null,"Baterai",{"$f":"ROUNDUP((L8*D27/D15)/(D16*D17),0)*D18","v":145},{"$f":"K15*'Parameter Teknis SMG'!D15*'Parameter Teknis SMG'!D16/1000","v":348}]
[null,"Capacity","Ah",1200,null,"Biaya lain-lain:",null,null,null,"Inverter",{"$f":"ROUNDUP((L13/'Parameter Teknis SMG'!D12), 0)","v":4},{"$f":"K16*'Parameter Teknis SMG'!D12","v":24}]
[null,"Deep of Discharge","%",0.6,null,"Transportasi","% dari biaya peralatan",0,null,"Luas lahan PV",{"$f":"VLOOKUP(D6,B24:D26,3,FALSE)","v":25},{"$f":"L13*K17","v":500}]
[null,"Autonomy","Days",5,null,"Tenaga kerja","% dari biaya peralatan",0.1,null,"Luas powerhouse",null,{"$f":"K15*D28","v":72.5}]
[null,"Harga Unit",null,9100000,null,"Bangunan (shelter)","IDR per m2",1000000,null,"Total luas instalasi",null,{"$f":"L17+L18","v":572.5}]
[null,"LOKASI"]
[null,"Peak Sun Hours","hours/day",5]
[null,"Harga tanah per m²",null,500000]
[null,"Asumsi untuk Perhitungan"]
[null,"Monocrystalline","1kWp",12]
[null,"Polycrystalline ","1 MW",14]
[null,"Thin Film PV","1 MW",25]
[null,"kW PV / MW","1 kW",1000]
[null,"Powerhouse","per baterai",0.5]

{"sheet":"Daftar Peralatan","index":6,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,7,1,8],[1,1,1,2],[1,4,1,5],[0,0,0,9]]}
["Daftar Peralatan"]
[null,"Rumah tangga",null,null,"Institusi sosial/fasilitas publik",null,null,"Bisnis perdesaan (PUE)"]
[null,"Jenis Peralatan","Wattage",null,"Jenis Peralatan","Wattage",null,"Jenis Peralatan","Wattage"]
[null,"Pilih peralatan",0,null,"Pilih peralatan",0,null,"Pilih peralatan",0]
[null,"DVD player",40,null,"Komputer (PC)",70,null,"Bench drill",1500]
[null,"Handphone charger",15,null,"Lampu",20,null,"Bench grinder",200]
[null,"Kipas angin",40,null,"Lampu jalan",10,null,"Blender",350]
[null,"Lampu (fluorescent)",20,null,"Printer",60,null,"Blower",600]
[null,"Microwave",1000,null,"Speaker",25,null,"Bor tangan",450]
[null,"Rice cooker",400,{"$nulls":4},"Dispenser",350]
[null,"TV colour 21 inch",70,{"$nulls":4},"Freezer",130]
[{"$nulls":7},"Gergaji mesin",1050]
[{"$nulls":7},"Gerinda logam",600]
[{"$nulls":7},"Inkubator telur",200]
[{"$nulls":7},"Kompresor",1500]
[{"$nulls":7},"Lampu meja",20]
[{"$nulls":7},"Las inverter",1300]
[{"$nulls":7},"Mesin amplas (sander)",180]
[{"$nulls":7},"Mesin bordir",250]
[{"$nulls":7},"Mesin jahit",120]
[{"$nulls":7},"Mesin neci",100]
[{"$nulls":7},"Mesin obras",100]
[{"$nulls":7},"Mesin planer",580]
[{"$nulls":7},"Mesin trimmer (profiler)",530]
[{"$nulls":7},"Mixer adonan",170]
[{"$nulls":7},"Mixer makanan",200]
[{"$nulls":7},"Oven",800]
[{"$nulls":7},"Pengepak vakum",300]
[{"$nulls":7},"Penggiling kopi",900]
[{"$nulls":7},"Penggiling padi",1500]
[{"$nulls":7},"Rice cooker",400]
[{"$nulls":7},"Sealer",400]
[]
[]
[]
[]
[null,"TIPS!"]
[null,"1. Anda bisa menambah daftar ini dengan peralatan lainnya"]
[null,"2. Disarankan untuk mengurut daftar yang baru untuk mempermudah pencarian"]