{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cetak","DB","CARI"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Cetak","index":0,"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,#REF!,10,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]
[null,"NAMA DEBITUR",{"$f":"IFERROR(VLOOKUP($C$2,#REF!,4,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]
[]
[null,"KETERANGAN SEWA",{"$f":"IF(IFERROR(VLOOKUP($C$2,#REF!,11,FALSE),\"TIDAK DITEMUKAN\")=\"TIDAK DITEMUKAN\",\"TIDAK DITEMUKAN\",IFERROR(VLOOKUP($C$2,#REF!,11,FALSE),\"\")&\" BERDASARKAN KONTRAK NO.\"&\" \"&$O$2)","v":"TIDAK DITEMUKAN"}]
[]
[null,"ALAMAT",{"$f":"IFERROR(VLOOKUP($C$2,#REF!,5,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]
[null,null,{"$f":"IFERROR(VLOOKUP($C$2,#REF!,6,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]
[null,null,{"$f":"IFERROR(VLOOKUP($C$2,#REF!,7,FALSE),\"TIDAK DITEMUKAN\")","v":"TIDAK DITEMUKAN"}]

{"sheet":"DB","index":1,"n_rows":11,"n_cols":85,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company Name"]
["No","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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[{"$f":"ROW()-3","v":0},1011,0,"ABC CDE, PT",55000,"Distributor","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"]
[1,1012,0,"BCA CDE, PT",null,"Distributor","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"]
[2,1013,0,"DEF GBD, PT",null,"MAIN DISTRIBUTOR","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"]
[3,1014,0,"FGH EBC, CV",null,"MAIN DISTRIBUTOR","2016-08-03","2005-12-20","2017-03-31","2018-03-31","2006-06-08",null,null,null,"2019-06-14",null,"2019-06-30",1,null,"2019-08-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-28",null,"2017-12-31","2019-08-03","2015-09-09",null,null,1,1,1,1,null,"API-U","2017-08-03","2022-08-03","2019-03-10",1,1,1,1,1,"2017-10-03",null,null,"AGEN , TRADING",null,"O"]
[4,1015,2,"KLM KLKL, CV",12000,"MAIN DISTRIBUTOR","2015-09-22","2017-03-01","2018-10-30","2019-10-30",null,"2021-12-13","2018-11-26",null,"2020-05-08",null,"2019-10-25",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-31",null,null,null,null,1,1,1,null,"2019-12-31","API-U","2016-04-08","2021-04-08",null,1,1,1,1,1,"2022-07-24",null,null,"AGEN , TRADING",null,"E,M"]
[5,1016,0,"DBC MBMB, CV",null,"MAIN DISTRIBUTOR",null,null,null,null,"2011-07-26",null,null,null,"2021-04-13",null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,"V",null,null,null,null,1,1,1,1,null,null,null,null,"AGEN , TRADING"]
[{"$f":"ROW()-3","v":6},1017,0,"AFG GBCK, PT",500,"JASA","2018-04-25","2019-05-06",null,null,"2018-05-08",null,null,null,"2023-05-21",null,"2019-10-29",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,1,1,1,1,null,null,null,null,"OTHER",null,"M"]
[{"$f":"ROW()-3","v":7},1018,0,"GBD AA, PT",600,"JASA","1998-10-23","2015-01-14",null,null,"2017-06-09",null,"2018-09-13","2023-09-20",null,null,"2022-03-16",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-31",null,null,null,null,1,1,1,null,"V","API-U","2017-10-23","2022-10-23",null,1,1,1,null,null,null,null,null,"AGEN , TRADING"]
[{"$f":"ROW()-3","v":8},1019,0,"CSG BC, CV",15000,"JASA","2008-03-14","2014-01-01",null,null,"2018-01-31",null,null,null,"2022-01-20","2019-01-03",null,1,null,null,null,null,null,null,null,null,"2019-10-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,1,1,1,1,1,"2019-01-03",null,null,"TRADING",null,"C"]

{"sheet":"CARI","index":2,"n_rows":5,"n_cols":69,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"No","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"]
[null,0,1011,0,"ABC, PT",55000,"Distributor","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",null,null,null,1]
[null,6,1017,0,"AFG, PT",500,"JASA","2018-04-25","2019-05-06",null,null,"2018-05-08",null,null,null,"2023-05-21",null,"2019-10-29",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,null,null,null,null,null,null,1,1,1,1,null,null,null,null,"OTHER",null,"M",null,null,null,1]