{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Metadata","Dashboard","Data Source","Data Preparation"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"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":"Metadata","index":0,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,1,2,21],[3,1,3,21],[4,1,4,21]]}
[]
[]
[null,"ANGGARAN BELANJA KEMENTERIAN/LEMBAGA MITRA KERJA KOMISI IV DPR RI"]
[null,"MENURUT BAGIAN ANGGARAN DAN PROGRAM"]
[null,"TAHUN ANGGARAN 2020-2022"]
[]
[null,null,"Komisi IV DPR RI mempunyai ruang lingkup tugas di bidang:"]
[null,null,"1. Pertanian"]
[null,null,"2. Lingkungan Hidup dan Kehutanan"]
[null,null,"3. Kelautan"]
[]
[null,null,"Data anggaran belanja kementerian/lembaga mitra kerja Komisi IV DPR RI disusun menurut kode bagian anggaran sebagai berikut:"]
[null,null,"018 - Kementerian Pertanian"]
[null,null,"029 - Kementerian Lingkungan Hidup dan Kehutanan"]
[null,null,"032 - Kementerian Kelautan dan Perikanan"]
[]
[null,null,"Data anggaran ini mengacu pada:"]
[null,null,"Tahun Anggaran 2020:",null,null,"Peraturan Presiden Nomor 72 Tahun 2020 tentang Perubahan atas Peraturan Presiden Nomor 54 Tahun 2020 (Lampiran IV)"]
[null,null,"Tahun Anggaran 2021:",null,null,"Laporan Hasil Pemeriksaan Badan Pemeriksa Keuangan atas Laporan Keuangan Kementerian/Lembaga Tahun 2021"]
[null,null,"Tahun Anggaran 2022:",null,null,"Peraturan Presiden Nomor 98 Tahun 2022 tentang Perubahan atas Peraturan Presiden Nomor 104 Tahun 2021 (Lampiran III)"]
[]
[null,null,"Penjelasan worksheets:"]
[null,null,"Dashboard",":","Visualisasi data anggaran yang interaktif dengan daftar kementerian/lembaga mitra kerja Komisi IV DPR RI dan program kementerian/lembaga terkait yang dapat dipilih"]
[null,null,"Data Source",":","Sumber data anggaran yang disusun berdasarkan kode bagian anggaran kementerian/lembaga mitra kerja Komisi IV DPR RI dan program kementerian/lembaga terkait"]
[null,null,"Data Preparation",":","Tabel persiapan data yang memuat daftar nomenklatur program kementerian/lembaga mitra kerja Komisi IV DPR RI tahun anggaran 2021-2022"]
[]
[null,null,"Petunjuk penggunaan:"]
[null,null,"1. Aktifkan makro dengan mengeklik tombol \"Enable Content\" pada Security Warning di atas."]
[null,null,"2. Pada worksheet Dashboard, pilih kementerian/lembaga dan program dengan mengeklik cell berwarna kuning. Selanjutnya akan muncul tombol drop-down yang jika diklik akan menampilkan pilihan yang ada."]
[]
[null,null,"Catatan:"]
[null,null,"Sehubungan dengan adanya perubahan nomenklatur program kementerian/lembaga pada tahun anggaran 2021, data anggaran ini hanya menggunakan program kementerian/lembaga tahun 2021 dan 2022."]

{"sheet":"Dashboard","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,2,8]]}
[]
[null,"ANGGARAN BELANJA KEMENTERIAN/LEMBAGA MITRA KERJA KOMISI IV DPR RI TAHUN ANGGARAN 2020-2022"]
[null,"(dalam ribuan rupiah)"]
[]
[null,"Langkah 1: Pilih Kementerian/Lembaga",null,null,null,null,"Langkah 2: Pilih Program"]
[null,"Kementerian Lingkungan Hidup dan Kehutanan",null,null,null,null,"Program Pendidikan dan Pelatihan Vokasi"]
[]
[null,null,2020,2021,2022,null,null,2021,2022]
[null,{"$f":"B6","v":"Kementerian Lingkungan Hidup dan Kehutanan"},{"$f":"INDEX('Data Source'!$D$7:$F$9,MATCH($B$9,'Data Source'!$C$7:$C$9,0),MATCH(C8,'Data Source'!$D$6:$F$6,0))","v":5295132139},{"$f":"INDEX('Data Source'!$D$7:$F$9,MATCH($B$9,'Data Source'!$C$7:$C$9,0),MATCH(D8,'Data Source'!$D$6:$F$6,0))","v":8572916538},{"$f":"INDEX('Data Source'!$D$7:$F$9,MATCH($B$9,'Data Source'!$C$7:$C$9,0),MATCH(E8,'Data Source'!$D$6:$F$6,0))","v":7120421454},null,{"$f":"G6","v":"Program Pendidikan dan Pelatihan Vokasi"},{"$f":"IFERROR(INDEX('Data Source'!$H$13:$I$29,MATCH($B$9&$G$9,INDEX('Data Source'!$C$13:$C$29&'Data Source'!$D$13:$D$29,0),0),MATCH(H8,'Data Source'!$H$12:$I$12,0)),\"\")","v":94049341},{"$f":"IFERROR(INDEX('Data Source'!$H$13:$I$29,MATCH($B$9&$G$9,INDEX('Data Source'!$C$13:$C$29&'Data Source'!$D$13:$D$29,0),0),MATCH(I8,'Data Source'!$H$12:$I$12,0)),\"\")","v":93403000}]

{"sheet":"Data Source","index":2,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,3,11,6],[0,1,0,8],[1,1,1,8],[2,1,2,8]]}
[null,"RINCIAN ANGGARAN BELANJA KEMENTERIAN/LEMBAGA MITRA KERJA KOMISI IV DPR RI MENURUT BAGIAN ANGGARAN DAN PROGRAM"]
[null,"TAHUN ANGGARAN 2020-2022"]
[null,"(dalam ribuan rupiah)"]
[]
[]
[null,"Kode BA","Kementerian/Lembaga",2020,2021,2022]
[null,"018 -","Kementerian Pertanian",14049785814,16314906396,14451749428]
[null,"029 -","Kementerian Lingkungan Hidup dan Kehutanan",5295132139,8572916538,7120421454]
[null,"032 -","Kementerian Kelautan dan Perikanan",4600264778,4773318827,6115967397]
[]
[]
[null,"Kode BA","Kementerian/Lembaga","Program",null,null,null,2021,2022]
[null,"018 -","Kementerian Pertanian","Program Pendidikan dan Pelatihan Vokasi",null,null,null,985265346,754175701]
[null,"018 -","Kementerian Pertanian","Program Nilai Tambah dan Daya Saing Industri",null,null,null,1504749657,1648521807]
[null,"018 -","Kementerian Pertanian","Program Ketersediaan, Akses dan Konsumsi Pangan Berkualitas",null,null,null,8527075024,6805000931]
[null,"018 -","Kementerian Pertanian","Program Riset dan Inovasi Ilmu Pengetahuan dan Teknologi",null,null,null,479568593,315976615]
[null,"018 -","Kementerian Pertanian","Program Dukungan Manajemen",null,null,null,4818247776,4928074374]
[null,"029 -","Kementerian Lingkungan Hidup dan Kehutanan","Program Pendidikan dan Pelatihan Vokasi",null,null,null,94049341,93403000]
[null,"029 -","Kementerian Lingkungan Hidup dan Kehutanan","Program Ketahanan Bencana dan Perubahan Iklim",null,null,null,175358735,171348612]
[null,"029 -","Kementerian Lingkungan Hidup dan Kehutanan","Program Kualitas Lingkungan Hidup",null,null,null,707265907,814040111]
[null,"029 -","Kementerian Lingkungan Hidup dan Kehutanan","Program Pengelolaan Hutan Berkelanjutan",null,null,null,4437229246,2663958414]
[null,"029 -","Kementerian Lingkungan Hidup dan Kehutanan","Program Riset dan Inovasi Ilmu Pengetahuan dan Teknologi",null,null,null,54543374,0]
[null,"029 -","Kementerian Lingkungan Hidup dan Kehutanan","Program Dukungan Manajemen",null,null,null,3104469935,3377671317]
[null,"032 -","Kementerian Kelautan dan Perikanan","Program Pendidikan dan Pelatihan Vokasi",null,null,null,254279339,273074994]
[null,"032 -","Kementerian Kelautan dan Perikanan","Program Nilai Tambah dan Daya Saing Industri",null,null,null,113144752,172898844]
[null,"032 -","Kementerian Kelautan dan Perikanan","Program Kualitas Lingkungan Hidup",null,null,null,68200587,83633503]
[null,"032 -","Kementerian Kelautan dan Perikanan","Program Pengelolaan Perikanan dan Kelautan",null,null,null,1288529482,2150999920]
[null,"032 -","Kementerian Kelautan dan Perikanan","Program Riset dan Inovasi Ilmu Pengetahuan dan Teknologi",null,null,null,59503119,26735000]
[null,"032 -","Kementerian Kelautan dan Perikanan","Program Dukungan Manajemen",null,null,null,2989661548,3408625136]

{"sheet":"Data Preparation","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4]]}
[null,"NOMENKLATUR PROGRAM KEMENTERIAN/LEMBAGA MITRA KERJA KOMISI IV DPR RI"]
[null,"TAHUN ANGGARAN 2021-2022"]
[]
[]
[null,"Kementerian/Lembaga:","Kementerian Pertanian","Kementerian Lingkungan Hidup dan Kehutanan","Kementerian Kelautan dan Perikanan"]
[null,"Program:","Program Pendidikan dan Pelatihan Vokasi","Program Pendidikan dan Pelatihan Vokasi","Program Pendidikan dan Pelatihan Vokasi"]
[null,null,"Program Nilai Tambah dan Daya Saing Industri","Program Ketahanan Bencana dan Perubahan Iklim","Program Nilai Tambah dan Daya Saing Industri"]
[null,null,"Program Ketersediaan, Akses dan Konsumsi Pangan Berkualitas","Program Kualitas Lingkungan Hidup","Program Kualitas Lingkungan Hidup"]
[null,null,"Program Riset dan Inovasi Ilmu Pengetahuan dan Teknologi","Program Pengelolaan Hutan Berkelanjutan","Program Pengelolaan Perikanan dan Kelautan"]
[null,null,"Program Dukungan Manajemen","Program Riset dan Inovasi Ilmu Pengetahuan dan Teknologi","Program Riset dan Inovasi Ilmu Pengetahuan dan Teknologi"]
[null,null,null,"Program Dukungan Manajemen","Program Dukungan Manajemen"]