{"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":45,"n_cols":6,"rows_kept":45,"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 II DPR RI"]
[null,"MENURUT BAGIAN ANGGARAN DAN PROGRAM"]
[null,"TAHUN ANGGARAN 2020-2022"]
[]
[null,null,"Komisi II DPR RI mempunyai ruang lingkup tugas di bidang:"]
[null,null,"1. Pemerintahan Dalam Negeri dan Otonomi Daerah"]
[null,null,"2. Aparatur Negara dan Reformasi Birokrasi"]
[null,null,"3. Kepemiluan"]
[null,null,"4. Pertanahan dan Reforma Agraria"]
[]
[null,null,"Data anggaran belanja kementerian/lembaga mitra kerja Komisi II DPR RI disusun menurut kode bagian anggaran sebagai berikut:"]
[null,null,"007 - Kementerian Sekretariat Negara"]
[null,null,"010 - Kementerian Dalam Negeri"]
[null,null,"048 - Kementerian Pendayagunaan Aparatur Negara dan Reformasi Birokrasi"]
[null,null,"056 - Kementerian Agraria dan Tata Ruang/ Badan Pertanahan Nasional"]
[null,null,"076 - Komisi Pemilihan Umum"]
[null,null,"086 - Lembaga Administrasi Negara"]
[null,null,"087 - Arsip Nasional Republik Indonesia"]
[null,null,"088 - Badan Kepegawaian Negara"]
[null,null,"110 - Ombudsman RI"]
[null,null,"111 - Badan Nasional Pengelolaan Perbatasan"]
[null,null,"114 - Sekretariat Kabinet"]
[null,null,"115 - Badan Pengawas Pemilihan Umum"]
[null,null,"122 - Badan Pembinaan Ideologi Pancasila"]
[]
[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 II 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 II DPR RI dan program kementerian/lembaga terkait"]
[null,null,"Data Preparation",":","Tabel persiapan data yang memuat daftar nomenklatur program kementerian/lembaga mitra kerja Komisi II 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."]
[null,null,"Data anggaran Ombudsman RI tahun 2021 bersumber dari Laporan Hasil Pemeriksaan Badan Pemeriksa Keuangan Atas Laporan Keuangan Pemerintah Pusat Tahun 2021 (Lampiran 34 Laporan Kinerja Pemerintah Pusat Tahun Anggaran 2021)."]
[null,null,"Data anggaran Arsip Nasional Republik Indonesia dan Badan Nasional Pengelolaan Perbatasan tahun 2021 bersumber dari Peraturan Presiden Nomor 113 Tahun 2020 tentang Rincian Anggaran Pendapatan dan Belanja Negara Tahun Anggaran 2021 (Lampiran III)."]

{"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 II 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 Sekretariat Negara",null,null,null,null,"Program Penyelenggaraan Layanan kepada Presiden dan Wakil Presiden"]
[]
[null,null,2020,2021,2022,null,null,2021,2022]
[null,{"$f":"B6","v":"Kementerian Sekretariat Negara"},{"$f":"INDEX('Data Source'!$D$7:$F$19,MATCH(Dashboard!$B$9,'Data Source'!$C$7:$C$19,0),MATCH(C8,'Data Source'!$D$6:$F$6,0))","v":1633673716},{"$f":"INDEX('Data Source'!$D$7:$F$19,MATCH(Dashboard!$B$9,'Data Source'!$C$7:$C$19,0),MATCH(D8,'Data Source'!$D$6:$F$6,0))","v":2314874225},{"$f":"INDEX('Data Source'!$D$7:$F$19,MATCH(Dashboard!$B$9,'Data Source'!$C$7:$C$19,0),MATCH(E8,'Data Source'!$D$6:$F$6,0))","v":1897456361},null,{"$f":"G6","v":"Program Penyelenggaraan Layanan kepada Presiden dan Wakil Presiden"},{"$f":"IFERROR(INDEX('Data Source'!$I$23:$J$51,MATCH($B$9&$G$9,INDEX('Data Source'!$C$23:$C$51&'Data Source'!$D$23:$D$51,0),0),MATCH(H8,'Data Source'!$I$22:$J$22,0)),\"\")","v":1109436354},{"$f":"IFERROR(INDEX('Data Source'!$I$23:$J$51,MATCH($B$9&$G$9,INDEX('Data Source'!$C$23:$C$51&'Data Source'!$D$23:$D$51,0),0),MATCH(I8,'Data Source'!$I$22:$J$22,0)),\"\")","v":664408545}]

{"sheet":"Data Source","index":2,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[21,3,21,7],[0,1,0,9],[1,1,1,9],[2,1,2,9]]}
[null,"RINCIAN ANGGARAN BELANJA KEMENTERIAN/LEMBAGA MITRA KERJA KOMISI II 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,"007 -","Kementerian Sekretariat Negara",1633673716,2314874225,1897456361]
[null,"010 -","Kementerian Dalam Negeri",2471591078,2934557569,3034904881]
[null,"048 -","Kementerian Pendayagunaan Aparatur Negara dan Reformasi Birokrasi",224366346,247466368,295349382]
[null,"056 -","Kementerian Agraria dan Tata Ruang/ Badan Pertanahan Nasional",8180542799,8517134455,8003434525]
[null,"076 -","Komisi Pemilihan Umum",1861968253,3166767417,2452965805]
[null,"086 -","Lembaga Administrasi Negara",305044603,308446909,316997157]
[null,"087 -","Arsip Nasional Republik Indonesia",165418004,292439611,281045829]
[null,"088 -","Badan Kepegawaian Negara",700644563,752415051,579797786]
[null,"110 -","Ombudsman RI",137839359,198162445,216196508]
[null,"111 -","Badan Nasional Pengelolaan Perbatasan",213002832,227704562,247680529]
[null,"114 -","Sekretariat Kabinet",250941188,297668676,326315931]
[null,"115 -","Badan Pengawas Pemilihan Umum",1573240603,1868372424,1982860804]
[null,"122 -","Badan Pembinaan Ideologi Pancasila",160050978,159797209,343877246]
[]
[]
[null,"Kode BA","Kementerian/Lembaga","Program",null,null,null,null,2021,2022]
[null,"007 -","Kementerian Sekretariat Negara","Program Penyelenggaraan Layanan kepada Presiden dan Wakil Presiden",null,null,null,null,1109436354,664408545]
[null,"007 -","Kementerian Sekretariat Negara","Program Dukungan Manajemen",null,null,null,null,1205437871,1233047816]
[null,"010 -","Kementerian Dalam Negeri","Program Kapasitas Pemerintahan Daerah dan Desa",null,null,null,null,450597849,459299143]
[null,"010 -","Kementerian Dalam Negeri","Program Tata Kelola Kependudukan",null,null,null,null,628153706,476338543]
[null,"010 -","Kementerian Dalam Negeri","Program Pembinaan Politik dan Pemerintahan Umum",null,null,null,null,145063300,146626418]
[null,"010 -","Kementerian Dalam Negeri","Program Dukungan Manajemen",null,null,null,null,1710742714,1952640777]
[null,"048 -","Kementerian Pendayagunaan Aparatur Negara dan Reformasi Birokrasi","Program Kebijakan, Pembinaan Profesi, dan Tata Kelola ASN",null,null,null,null,75281664,79473064]
[null,"048 -","Kementerian Pendayagunaan Aparatur Negara dan Reformasi Birokrasi","Program Dukungan Manajemen",null,null,null,null,172184704,215876318]
[null,"056 -","Kementerian Agraria dan Tata Ruang/ Badan Pertanahan Nasional","Program Pengelolaan dan Pelayanan Pertanahan",null,null,null,null,3951955545,3284358350]
[null,"056 -","Kementerian Agraria dan Tata Ruang/ Badan Pertanahan Nasional","Program Penyelenggaraan Penataan Ruang",null,null,null,null,278812763,205623867]
[null,"056 -","Kementerian Agraria dan Tata Ruang/ Badan Pertanahan Nasional","Program Dukungan Manajemen",null,null,null,null,4286366147,4513452308]
[null,"076 -","Komisi Pemilihan Umum","Penyelenggaraan Pemilu dalam Proses Konsolidasi Demokrasi",null,null,null,null,1261621084,505915190]
[null,"076 -","Komisi Pemilihan Umum","Program Dukungan Manajemen",null,null,null,null,1905146333,1947050615]
[null,"086 -","Lembaga Administrasi Negara","Program Kebijakan, Pembinaan Profesi, dan Tata Kelola ASN",null,null,null,null,52607061,63446225]
[null,"086 -","Lembaga Administrasi Negara","Program Dukungan Manajemen",null,null,null,null,255839848,253550932]
[null,"087 -","Arsip Nasional Republik Indonesia","Program Penyelenggaraan Kearsipan Nasional",null,null,null,null,70021225,82039670]
[null,"087 -","Arsip Nasional Republik Indonesia","Program Dukungan Manajemen",null,null,null,null,222418386,199006159]
[null,"088 -","Badan Kepegawaian Negara","Program Kebijakan, Pembinaan Profesi, dan Tata Kelola ASN",null,null,null,null,230276845,70382634]
[null,"088 -","Badan Kepegawaian Negara","Program Dukungan Manajemen",null,null,null,null,522138206,509415152]
[null,"110 -","Ombudsman RI","Program Pengawasan Penyelenggaraan Pelayanan Publik",null,null,null,null,32685323,25487808]
[null,"110 -","Ombudsman RI","Program Dukungan Manajemen",null,null,null,null,165477122,190708700]
[null,"111 -","Badan Nasional Pengelolaan Perbatasan","Program Pengelolaan Batas Wilayah Negara dan Kawasan Perbatasan",null,null,null,null,56954089,48471309]
[null,"111 -","Badan Nasional Pengelolaan Perbatasan","Program Dukungan Manajemen",null,null,null,null,170750473,199209220]
[null,"114 -","Sekretariat Kabinet","Penyelenggaraan Layanan kepada Presiden dan Wakil Presiden",null,null,null,null,23293346,37451201]
[null,"114 -","Sekretariat Kabinet","Program Dukungan Manajemen",null,null,null,null,274375330,288864730]
[null,"115 -","Badan Pengawas Pemilihan Umum","Program Penyelenggaraan Pemilu dalam Proses Konsolidasi Demokrasi",null,null,null,null,631790742,574222977]
[null,"115 -","Badan Pengawas Pemilihan Umum","Program Dukungan Manajemen",null,null,null,null,1236581682,1408637827]
[null,"122 -","Badan Pembinaan Ideologi Pancasila","Program Pembinaan Ideologi Pancasila",null,null,null,null,56713567,173488827]
[null,"122 -","Badan Pembinaan Ideologi Pancasila","Program Dukungan Manajemen",null,null,null,null,103083642,170388419]

{"sheet":"Data Preparation","index":3,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,14],[1,1,1,14]]}
[null,"NOMENKLATUR PROGRAM KEMENTERIAN/LEMBAGA MITRA KERJA KOMISI II DPR RI"]
[null,"TAHUN ANGGARAN 2021-2022"]
[]
[]
[null,"Kementerian/Lembaga:","Kementerian Sekretariat Negara","Kementerian Dalam Negeri","Kementerian Pendayagunaan Aparatur Negara dan Reformasi Birokrasi","Kementerian Agraria dan Tata Ruang/ Badan Pertanahan Nasional","Komisi Pemilihan Umum","Lembaga Administrasi Negara","Arsip Nasional Republik Indonesia","Badan Kepegawaian Negara","Ombudsman RI","Badan Nasional Pengelolaan Perbatasan","Sekretariat Kabinet","Badan Pengawas Pemilihan Umum","Badan Pembinaan Ideologi Pancasila"]
[null,"Program:","Program Penyelenggaraan Layanan kepada Presiden dan Wakil Presiden","Program Kapasitas Pemerintahan Daerah dan Desa","Program Kebijakan, Pembinaan Profesi, dan Tata Kelola ASN","Program Pengelolaan dan Pelayanan Pertanahan","Penyelenggaraan Pemilu dalam Proses Konsolidasi Demokrasi","Program Kebijakan, Pembinaan Profesi, dan Tata Kelola ASN","Program Penyelenggaraan Kearsipan Nasional","Program Kebijakan, Pembinaan Profesi, dan Tata Kelola ASN","Program Pengawasan Penyelenggaraan Pelayanan Publik","Program Pengelolaan Batas Wilayah Negara dan Kawasan Perbatasan","Penyelenggaraan Layanan kepada Presiden dan Wakil Presiden","Program Penyelenggaraan Pemilu dalam Proses Konsolidasi Demokrasi","Program Pembinaan Ideologi Pancasila"]
[null,null,"Program Dukungan Manajemen","Program Tata Kelola Kependudukan","Program Dukungan Manajemen","Program Penyelenggaraan Penataan Ruang","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen"]
[null,null,null,"Program Pembinaan Politik dan Pemerintahan Umum",null,"Program Dukungan Manajemen"]
[null,null,null,"Program Dukungan Manajemen"]