{"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":38,"n_cols":6,"rows_kept":38,"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 V DPR RI"]
[null,"MENURUT BAGIAN ANGGARAN DAN PROGRAM"]
[null,"TAHUN ANGGARAN 2020-2022"]
[]
[null,null,"Komisi V DPR RI mempunyai ruang lingkup tugas di bidang:"]
[null,null,"1. Infrastruktur"]
[null,null,"2. Transportasi"]
[null,null,"3. Daerah Tertinggal dan Transmigrasi"]
[null,null,"4. Meteorologi, Klimatologi, dan Geofisika"]
[null,null,"5. Pencarian dan Pertolongan"]
[]
[null,null,"Data anggaran belanja kementerian/lembaga mitra kerja Komisi V DPR RI disusun menurut kode bagian anggaran sebagai berikut:"]
[null,null,"022 - Kementerian Perhubungan"]
[null,null,"033 - Kementerian Pekerjaan Umum dan Perumahan Rakyat"]
[null,null,"067 - Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi"]
[null,null,"075 - Badan Meteorologi, Klimatologi dan Geofisika (BMKG)"]
[null,null,"107 - Badan Nasional Pencarian dan Pertolongan (Basarnas)"]
[null,null,"109 - Badan Pengembangan Wilayah Surabaya Madura"]
[]
[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 V 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 V DPR RI dan program kementerian/lembaga terkait"]
[null,null,"Data Preparation",":","Tabel persiapan data yang memuat daftar nomenklatur program kementerian/lembaga mitra kerja Komisi V 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 Badan Pengembangan Wilayah Surabaya Madura 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 V 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 Perhubungan",null,null,null,null,"Program Pendidikan dan Pelatihan Vokasi"]
[]
[null,null,2020,2021,2022,null,null,2021,2022]
[null,{"$f":"B6","v":"Kementerian Perhubungan"},{"$f":"INDEX('Data Source'!$D$7:$F$12,MATCH($B$9,'Data Source'!$C$7:$C$12,0),MATCH(C8,'Data Source'!$D$6:$F$6,0))","v":32745701301},{"$f":"INDEX('Data Source'!$D$7:$F$12,MATCH($B$9,'Data Source'!$C$7:$C$12,0),MATCH(D8,'Data Source'!$D$6:$F$6,0))","v":34659251725},{"$f":"INDEX('Data Source'!$D$7:$F$12,MATCH($B$9,'Data Source'!$C$7:$C$12,0),MATCH(E8,'Data Source'!$D$6:$F$6,0))","v":32938320363},null,{"$f":"G6","v":"Program Pendidikan dan Pelatihan Vokasi"},{"$f":"IFERROR(INDEX('Data Source'!$J$16:$K$32,MATCH($B$9&$G$9,INDEX('Data Source'!$C$16:$C$32&'Data Source'!$D$16:$D$32,0),0),MATCH(H8,'Data Source'!$J$15:$K$15,0)),\"\")","v":1267734701},{"$f":"IFERROR(INDEX('Data Source'!$J$16:$K$32,MATCH($B$9&$G$9,INDEX('Data Source'!$C$16:$C$32&'Data Source'!$D$16:$D$32,0),0),MATCH(I8,'Data Source'!$J$15:$K$15,0)),\"\")","v":2370007938}]

{"sheet":"Data Source","index":2,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[14,3,14,8],[0,1,0,10],[1,1,1,10],[2,1,2,10]]}
[null,"RINCIAN ANGGARAN BELANJA KEMENTERIAN/LEMBAGA MITRA KERJA KOMISI V 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,"022 -","Kementerian Perhubungan",32745701301,34659251725,32938320363]
[null,"033 -","Kementerian Pekerjaan Umum dan Perumahan Rakyat",75632407614,161312757487,100597698915]
[null,"067 -","Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi",2376218926,3089194851,3102388046]
[null,"075 -","Badan Meteorologi, Klimatologi dan Geofisika (BMKG)",2157797896,2903225163,3108611438]
[null,"107 -","Badan Nasional Pencarian dan Pertolongan (Basarnas)",1583163924,1869314237,1967176959]
[null,"109 -","Badan Pengembangan Wilayah Surabaya Madura",156866492,156377732,0]
[]
[]
[null,"Kode BA","Kementerian/Lembaga","Program",null,null,null,null,null,2021,2022]
[null,"022 -","Kementerian Perhubungan","Program Pendidikan dan Pelatihan Vokasi",null,null,null,null,null,1267734701,2370007938]
[null,"022 -","Kementerian Perhubungan","Program Infrastruktur Konektivitas",null,null,null,null,null,25157499773,21643878902]
[null,"022 -","Kementerian Perhubungan","Program Riset dan Inovasi Ilmu Pengetahuan dan Teknologi",null,null,null,null,null,67123545,94882583]
[null,"022 -","Kementerian Perhubungan","Program Dukungan Manajemen",null,null,null,null,null,8166893706,8829550940]
[null,"033 -","Kementerian Pekerjaan Umum dan Perumahan Rakyat","Program Pendidikan dan Pelatihan Vokasi",null,null,null,null,null,93548988,138172236]
[null,"033 -","Kementerian Pekerjaan Umum dan Perumahan Rakyat","Program Ketahanan Sumber Daya Air",null,null,null,null,null,54733948005,38778950026]
[null,"033 -","Kementerian Pekerjaan Umum dan Perumahan Rakyat","Program Infrastruktur Konektivitas",null,null,null,null,null,63878064822,37295614651]
[null,"033 -","Kementerian Pekerjaan Umum dan Perumahan Rakyat","Program Perumahan dan Kawasan Permukiman",null,null,null,null,null,34628287294,16209930531]
[null,"033 -","Kementerian Pekerjaan Umum dan Perumahan Rakyat","Program Dukungan Manajemen",null,null,null,null,null,7978908378,8175031471]
[null,"067 -","Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi","Program Daerah Tertinggal, Kawasan Perbatasan, Perdesaan, dan Transmigrasi",null,null,null,null,null,2441934868,2397404117]
[null,"067 -","Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi","Program Dukungan Manajemen",null,null,null,null,null,647259983,704983929]
[null,"075 -","Badan Meteorologi, Klimatologi dan Geofisika (BMKG)","Program Meteorologi, Klimatologi, dan Geofisika",null,null,null,null,null,2522553224,1896143607]
[null,"075 -","Badan Meteorologi, Klimatologi dan Geofisika (BMKG)","Program Dukungan Manajemen",null,null,null,null,null,380671939,1212467831]
[null,"107 -","Badan Nasional Pencarian dan Pertolongan (Basarnas)","Program Pencarian dan Pertolongan pada Kecelakaan dan Bencana",null,null,null,null,null,1087516475,1059670084]
[null,"107 -","Badan Nasional Pencarian dan Pertolongan (Basarnas)","Program Dukungan Manajemen",null,null,null,null,null,781797762,907506875]
[null,"109 -","Badan Pengembangan Wilayah Surabaya Madura","Program Pengembangan Kawasan Strategis",null,null,null,null,null,128311436,0]
[null,"109 -","Badan Pengembangan Wilayah Surabaya Madura","Program Dukungan Manajemen",null,null,null,null,null,28066296,0]

{"sheet":"Data Preparation","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4]]}
[null,"NOMENKLATUR PROGRAM KEMENTERIAN/LEMBAGA MITRA KERJA KOMISI V DPR RI"]
[null,"TAHUN ANGGARAN 2021-2022"]
[]
[]
[null,"Kementerian/Lembaga:","Kementerian Perhubungan","Kementerian Pekerjaan Umum dan Perumahan Rakyat","Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi","Badan Meteorologi, Klimatologi dan Geofisika (BMKG)","Badan Nasional Pencarian dan Pertolongan (Basarnas)","Badan Pengembangan Wilayah Surabaya Madura"]
[null,"Program:","Program Pendidikan dan Pelatihan Vokasi","Program Pendidikan dan Pelatihan Vokasi","Program Daerah Tertinggal, Kawasan Perbatasan, Perdesaan, dan Transmigrasi","Program Meteorologi, Klimatologi, dan Geofisika","Program Pencarian dan Pertolongan pada Kecelakaan dan Bencana","Program Pengembangan Kawasan Strategis"]
[null,null,"Program Infrastruktur Konektivitas","Program Ketahanan Sumber Daya Air","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen"]
[null,null,"Program Riset dan Inovasi Ilmu Pengetahuan dan Teknologi","Program Infrastruktur Konektivitas"]
[null,null,"Program Dukungan Manajemen","Program Perumahan dan Kawasan Permukiman"]
[null,null,null,"Program Dukungan Manajemen"]