{"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":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,21],[3,1,3,21],[4,1,4,21]]}
[]
[]
[null,"ANGGARAN BELANJA KEMENTERIAN KOORDINATOR MITRA KERJA BADAN ANGGARAN DPR RI"]
[null,"MENURUT BAGIAN ANGGARAN DAN PROGRAM"]
[null,"TAHUN ANGGARAN 2020-2022"]
[]
[null,null,"Badan Anggaran DPR RI mempunyai tugas sebagai berikut:"]
[null,null,"1. Membahas bersama Pemerintah untuk menentukan pokok-pokok kebijakan fiskal umum dan prioritas anggaran"]
[null,null,"2. Menetapkan pendapatan negara bersama Pemerintah dengan mengacu pada usulan komisi terkait"]
[null,null,"3. Membahas rancangan undang-undang tentang APBN bersama Presiden"]
[null,null,"4. Melakukan sinkronisasi terhadap hasil pembahasan di komisi mengenai rencana kerja dan anggaran kementerian/lembaga"]
[null,null,"5. Membahas laporan realisasi dan prognosis yang berkaitan dengan APBN"]
[null,null,"6. Membahas pokok-pokok penjelasan atas rancangan undang-undang tentang pertanggungjawaban pelaksanaan APBN"]
[]
[null,null,"Data anggaran belanja kementerian koordinator mitra kerja Badan Anggaran DPR RI disusun menurut kode bagian anggaran sebagai berikut:"]
[null,null,"034 - Kementerian Koordinator Bidang Politik, Hukum dan Keamanan"]
[null,null,"035 - Kementerian Koordinator Bidang Perekonomian"]
[null,null,"036 - Kementerian Koordinator Bidang Pembangunan Manusia dan Kebudayaan"]
[null,null,"120 - Kementerian Koordinator Bidang Kemaritiman dan Investasi"]
[]
[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 koordinator mitra kerja Badan Anggaran DPR RI dan program kementerian koordinator terkait yang dapat dipilih"]
[null,null,"Data Source",":","Sumber data anggaran yang disusun berdasarkan kode bagian anggaran kementerian koordinator mitra kerja Badan Anggaran DPR RI dan program kementerian koordinator terkait"]
[null,null,"Data Preparation",":","Tabel persiapan data yang memuat daftar nomenklatur program kementerian koordinator mitra kerja Badan Anggaran 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 koordinator 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 Kementerian Koordinator Bidang Kemaritiman dan Investasi 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 KOORDINATOR MITRA KERJA BADAN ANGGARAN DPR RI TAHUN ANGGARAN 2020-2022"]
[null,"(dalam ribuan rupiah)"]
[]
[null,"Langkah 1: Pilih Kementerian Koordinator",null,null,null,null,"Langkah 2: Pilih Program"]
[null,"Kementerian Koordinator Bidang Politik, Hukum dan Keamanan",null,null,null,null,"Program Koordinasi Pelaksanaan Kebijakan"]
[]
[null,null,2020,2021,2022,null,null,2021,2022]
[null,{"$f":"B6","v":"Kementerian Koordinator Bidang Politik, Hukum dan Keamanan"},{"$f":"INDEX('Data Source'!$D$7:$F$10,MATCH($B$9,'Data Source'!$C$7:$C$10,0),MATCH(C8,'Data Source'!$D$6:$F$6,0))","v":268970603},{"$f":"INDEX('Data Source'!$D$7:$F$10,MATCH($B$9,'Data Source'!$C$7:$C$10,0),MATCH(D8,'Data Source'!$D$6:$F$6,0))","v":232160650},{"$f":"INDEX('Data Source'!$D$7:$F$10,MATCH($B$9,'Data Source'!$C$7:$C$10,0),MATCH(E8,'Data Source'!$D$6:$F$6,0))","v":282380152},null,{"$f":"G6","v":"Program Koordinasi Pelaksanaan Kebijakan"},{"$f":"IFERROR(INDEX('Data Source'!$H$14:$I$21,MATCH($B$9&$G$9,INDEX('Data Source'!$C$14:$C$21&'Data Source'!$D$14:$D$21,0),0),MATCH(H8,'Data Source'!$H$13:$I$13,0)),\"\")","v":78418379},{"$f":"IFERROR(INDEX('Data Source'!$H$14:$I$21,MATCH($B$9&$G$9,INDEX('Data Source'!$C$14:$C$21&'Data Source'!$D$14:$D$21,0),0),MATCH(I8,'Data Source'!$H$13:$I$13,0)),\"\")","v":115719075}]

{"sheet":"Data Source","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,1,1,8],[2,1,2,8],[12,3,12,6]]}
[null,"RINCIAN ANGGARAN BELANJA KEMENTERIAN KOORDINATOR MITRA KERJA BADAN ANGGARAN DPR RI MENURUT BAGIAN ANGGARAN DAN PROGRAM"]
[null,"TAHUN ANGGARAN 2020-2022"]
[null,"(dalam ribuan rupiah)"]
[]
[]
[null,"Kode BA","Kementerian Koordinator",2020,2021,2022]
[null,"034 -","Kementerian Koordinator Bidang Politik, Hukum dan Keamanan",268970603,232160650,282380152]
[null,"035 -","Kementerian Koordinator Bidang Perekonomian",393334438,395696324,444900394]
[null,"036 -","Kementerian Koordinator Bidang Pembangunan Manusia dan Kebudayaan",232623827,206450970,230467321]
[null,"120 -","Kementerian Koordinator Bidang Kemaritiman dan Investasi",259596417,314596417,260926167]
[]
[]
[null,"Kode BA","Kementerian Koordinator","Program",null,null,null,2021,2022]
[null,"034 -","Kementerian Koordinator Bidang Politik, Hukum dan Keamanan","Program Koordinasi Pelaksanaan Kebijakan",null,null,null,78418379,115719075]
[null,"034 -","Kementerian Koordinator Bidang Politik, Hukum dan Keamanan","Program Dukungan Manajemen",null,null,null,153742271,166661077]
[null,"035 -","Kementerian Koordinator Bidang Perekonomian","Program Koordinasi Pelaksanaan Kebijakan",null,null,null,168801229,219225000]
[null,"035 -","Kementerian Koordinator Bidang Perekonomian","Program Dukungan Manajemen",null,null,null,226895095,225675394]
[null,"036 -","Kementerian Koordinator Bidang Pembangunan Manusia dan Kebudayaan","Program Koordinasi Pelaksanaan Kebijakan",null,null,null,42652850,62950000]
[null,"036 -","Kementerian Koordinator Bidang Pembangunan Manusia dan Kebudayaan","Program Dukungan Manajemen",null,null,null,163798120,167517321]
[null,"120 -","Kementerian Koordinator Bidang Kemaritiman dan Investasi","Program Koordinasi Pelaksanaan Kebijakan",null,null,null,120708099,87649910]
[null,"120 -","Kementerian Koordinator Bidang Kemaritiman dan Investasi","Program Dukungan Manajemen",null,null,null,193888318,173276257]

{"sheet":"Data Preparation","index":3,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,"NOMENKLATUR PROGRAM KEMENTERIAN KOORDINATOR MITRA KERJA BADAN ANGGARAN DPR RI"]
[null,"TAHUN ANGGARAN 2021-2022"]
[]
[]
[null,"Kementerian Koordinator:","Kementerian Koordinator Bidang Politik, Hukum dan Keamanan","Kementerian Koordinator Bidang Perekonomian","Kementerian Koordinator Bidang Pembangunan Manusia dan Kebudayaan","Kementerian Koordinator Bidang Kemaritiman dan Investasi"]
[null,"Program:","Program Koordinasi Pelaksanaan Kebijakan","Program Koordinasi Pelaksanaan Kebijakan","Program Koordinasi Pelaksanaan Kebijakan","Program Koordinasi Pelaksanaan Kebijakan"]
[null,null,"Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen","Program Dukungan Manajemen"]