{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Katalog","Cetak"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"Katalog","index":0,"n_rows":8,"n_cols":71,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71]
["No","X","XX","XXX","NO KATALOG","Rank - 2019","Company Name","Aset","REMARK","Akte Pendirian","Sertifikat Jamsostek","Wajib Lapor date","Wajib Lapor exp","SIUP date","SIUPexp","NIB_date","TDP date","TDP exp","Domisili_date","Domisili_exp","Data Personalia","LPJK_date","LPJK_exp","KADIN","HJKI","ASPEKINDO","APKLINDO","ABUJAPI","APSI","APLI","SBUM","ASPEKNAS","ARDIN","GAPENSI","APAKSINDO","AKLINDO","AKBARINDO","PERKINDO","APTEK","GAPAKESINDO","CCI","SIUJK","SKA_SKT","Surat_Ijin_penyedia_jasa_pekerja","PPJP","pengalaman","KTP","susunan_Pengurus","Perlengkapan_Peralatan","Surat_Keagenan","API_Jenis","API_date","API_exp","NPIK","NPWP","SPPKP","SPT_PPh3","SPT_PPh3","Laporan_Keuangan3","ISO_exp","OHAS_exp","TKDN","TYPE OF BUSINESS","LOCAL (L)   OR   FOREIGN (C) ","SCOPE OF SUPPLY","FORMALITIES ","SIUP","NIB","NPWP","NOTARY REPORT","AGENCY/OEM APPOINTMENT LETTER"]
[1,null,null,null,"0400039642",0,"ABC, PT",55000,"Jasa celaning service dan keamanan","2015-10-03","2016-09-15","2019-07-19","2020-07-19",null,"2020-11-19","2018-11-06",null,null,null,"2023-10-30",1,null,null,null,null,null,"2019-12-31","2018-12-19","2022-03-02",null,null,null,null,null,null,null,null,null,null,null,"2019-12-31",null,null,null,null,1,1,1,null,null,null,null,null,null,1,1,1,1,1,"2022-01-24","2022-01-24",null,"AGEN , OTHER",null,"O"]
[2,null,null,null,"0400022843",0,"DEF, PT",null,null,"2019-02-11","2013-05-20","2017-11-24","2018-11-24","2017-05-23",null,"2019-02-27",null,"2021-07-06",null,"2019-03-12",null,null,"2022-03-05",null,null,null,null,null,null,null,null,null,null,null,"2019-12-31",null,null,null,null,null,null,null,null,null,null,1,1,null,null,"V","API-P","2015-03-17","2020-03-17","V",1,1,null,null,null,"2020-08-24",null,"2022-05-22","AGEN , OTHER"]
[3,null,null,null,"400033562",0,"GHI, PT",null,"SUPPLIER, perdagangan bahan bahan bangunan, peralatan kontruksi, mekanikal, elektrikal, suku cadang mesin, jasa angkut jasa pemasangan","2006-01-26","2007-02-06",null,null,null,"2021-07-18",null,null,"2021-03-27",null,"2016-08-02",1,null,"2018-07-05",null,null,null,null,null,null,null,null,null,null,"2015-06-19",null,null,null,null,null,null,"2016-06-27","2018-06-16","2015-05-12",null,null,1,1,null,1,null,"API-U","2014-02-03","2019-02-03","V",1,1,1,1,1,null,null,null,"AGEN , TRADING",null,"E, M, I, O"]
[4,null,null,null,"0400022843",0,"DEF, PT",null,null,"2019-02-11","2013-05-20","2017-11-24","2018-11-24","2017-05-23",null,"2019-02-27",null,"2021-07-06",null,"2019-03-12",null,null,"2022-03-05",null,null,null,null,null,null,null,null,null,null,null,"2019-12-31",null,null,null,null,null,null,null,null,null,null,1,1,null,null,"V","API-P","2015-03-17","2020-03-17","V",1,1,null,null,null,"2020-08-24",null,"2022-05-22","AGEN , OTHER"]
[5,null,null,null,"400033562",0,"GHI, PT",null,"SUPPLIER, perdagangan bahan bahan bangunan, peralatan kontruksi, mekanikal, elektrikal, suku cadang mesin, jasa angkut jasa pemasangan","2006-01-26","2007-02-06",null,null,null,"2021-07-18",null,null,"2021-03-27",null,"2016-08-02",1,null,"2018-07-05",null,null,null,null,null,null,null,null,null,null,"2015-06-19",null,null,null,null,null,null,"2016-06-27","2018-06-16","2015-05-12",null,null,1,1,null,1,null,"API-U","2014-02-03","2019-02-03","V",1,1,1,1,1,null,null,null,"MANUFACTURE",null,"E, M, I, O"]

{"sheet":"Cetak","index":1,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,14,1,17],[1,2,1,5],[2,2,2,5],[7,2,7,5],[8,2,8,5],[6,2,6,5],[4,2,4,5]]}
[]
[null,"NO KATALOG","D.001.001",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($C$2,Table1[[NO KATALOG]:[SIUP date]],10,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]
[null,"NAMA DEBITUR",{"$f":"IFERROR(VLOOKUP($C$2,Table1[[NO KATALOG]:[SIUP date]],4,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]
[]
[null,"KETERANGAN SEWA",{"$f":"IF(IFERROR(VLOOKUP($C$2,Table1[[NO KATALOG]:[SIUP date]],11,FALSE),\"TIDAK DITEMUKAN\")=\"TIDAK DITEMUKAN\",\"TIDAK DITEMUKAN\",IFERROR(VLOOKUP($C$2,Table1[[NO KATALOG]:[SIUP date]],11,FALSE),\"\")&\" BERDASARKAN KONTRAK NO.\"&\" \"&$O$2)","v":"TIDAK DITEMUKAN"}]
[]
[null,"ALAMAT",{"$f":"IFERROR(VLOOKUP($C$2,Table1[[NO KATALOG]:[SIUP date]],5,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]
[null,null,{"$f":"IFERROR(VLOOKUP($C$2,Table1[[NO KATALOG]:[SIUP date]],6,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]
[null,null,{"$f":"IFERROR(VLOOKUP($C$2,Table1[[NO KATALOG]:[SIUP date]],7,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]