{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Hoja1","FORMATO DE OT","REGISTRO DE INGRESO DE OT","Clientes","DATOS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":0,"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":"Hoja1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FORMATO DE OT","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"CLIENTE:",null,null,"FECHA DE EMISIÓN:"]
[null,"OT:",null,null,"FECHA DE ENTREGA:"]
[null,"OC:"]
[]
[]
[null,"ITEM","DESCRIPCIÓN","MEDIDAS","CANTIDAD","MATERIAL","ACABADO"]

{"sheet":"REGISTRO DE INGRESO DE OT","index":2,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["O/T","CLIENTE","O/C","ITEM","DESCRIPCIÓN","MEDIDAS","CANT.","ACABADO","MATERIAL","Fecha Emisión","Entrega Entrega","Fecha de Salida"]

{"sheet":"Clientes","index":3,"n_rows":11,"n_cols":62,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["N°","RUBRO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO",null,"RAZON SOCIAL","NOMBRE COMERCIAL (ABREVIADO)","RUC","RUBRO","CÓDIGO"]
[1,"AGREGADOS",null,"CALIZA CEMENTO INCA S.A.",null,20471744493,"AGREGADOS",{"$f":"CONCATENATE(MID(G2,2,2),\"-\",MID(D2,1,1),IF(MID(D2,(SEARCH(\" \",D2,4)+1),1)=\"&\",MID(D2,(SEARCH(\" \",D2,9))+1,1),MID(D2,(SEARCH(\" \",D2,4)+1),1)),\"-\",MID(F2,3,3),MID(F2,11,1))","v":"GR-CC-4713"},null,"AGRARIA CHIQUITOY S.A.","CHIQUITOY",20131835621,"AGROINDUSTRIA",{"$f":"CONCATENATE(MID(M2,1,2),\"-\",MID(J2,1,1),IF(MID(J2,(SEARCH(\" \",J2,4)+1),1)=\"&\",MID(J2,(SEARCH(\" \",J2,9))+1,1),MID(J2,(SEARCH(\" \",J2,4)+1),1)),\"-\",MID(L2,3,3),MID(L2,11,1))","v":"AG-AC-1311"},null,"ACEROS DEL PERU S.A.C.","ACEPE S.A.C.",20430039254,"INDUSTRIA GENERAL",{"$f":"CONCATENATE(MID(S2,1,2),\"-\",MID(P2,1,1),IF(MID(P2,(SEARCH(\" \",P2,4)+1),1)=\"&\",MID(P2,(SEARCH(\" \",P2,9))+1,1),MID(P2,(SEARCH(\" \",P2,4)+1),1)),\"-\",MID(R2,3,3),MID(R2,11,1))","v":"IN-AD-4304"},null,"CONSTRUCCIONES A MAGGIOLO S.A.",null,20100247225,"ASTILLERO",{"$f":"CONCATENATE(MID(Y2,1,2),\"-\",MID(V2,1,1),IF(MID(V2,(SEARCH(\" \",V2,4)+1),1)=\"&\",MID(V2,(SEARCH(\" \",V2,9))+1,1),MID(V2,(SEARCH(\" \",V2,4)+1),1)),\"-\",MID(X2,3,3),MID(X2,11,1))","v":"AS-CA-1005"},null,"ACEROS & MANUFACTURAS S.A.C.",null,20506305285,"METALMECANICA",{"$f":"CONCATENATE(MID(AE2,1,2),\"-\",MID(AB2,1,1),IF(MID(AB2,(SEARCH(\" \",AB2,4)+1),1)=\"&\",MID(AB2,(SEARCH(\" \",AB2,9))+1,1),MID(AB2,(SEARCH(\" \",AB2,4)+1),1)),\"-\",MID(AD2,3,3),MID(AD2,11,1))","v":"ME-AM-5065"},null,"CATALINA HUANCA SOCIEDAD MINERA S.A.C.",null,20509551767,"MINERA",{"$f":"CONCATENATE(MID(AK2,1,2),\"-\",MID(AH2,1,1),IF(MID(AH2,(SEARCH(\" \",AH2,4)+1),1)=\"&\",MID(AH2,(SEARCH(\" \",AH2,9))+1,1),MID(AH2,(SEARCH(\" \",AH2,4)+1),1)),\"-\",MID(AJ2,3,3),MID(AJ2,11,1))","v":"MI-CH-5097"},null,"ACCESORIOS Y EQUIPOS MARINOS S.A.","ACEMAR S A",20178429192,"PESCA",{"$f":"CONCATENATE(MID(AQ2,1,2),\"-\",MID(AN2,1,1),IF(MID(AN2,(SEARCH(\" \",AN2,4)+1),1)=\"&\",MID(AN2,(SEARCH(\" \",AN2,9))+1,1),MID(AN2,(SEARCH(\" \",AN2,4)+1),1)),\"-\",MID(AP2,3,3),MID(AP2,11,1))","v":"PE-AY-1782"},null,"JIMMY FREDDY ALBARRAN IBAÑEZ",null,10108764606,"PERSONAS NATURALES",{"$f":"CONCATENATE(MID(AW2,1,2),\"-\",MID(AT2,1,1),IF(MID(AT2,(SEARCH(\" \",AT2,4)+1),1)=\"&\",MID(AT2,(SEARCH(\" \",AT2,9))+1,1),MID(AT2,(SEARCH(\" \",AT2,4)+1),1)),\"-\",MID(AV2,3,3),MID(AV2,11,1))","v":"PE-JF-1086"},null,"ACEMETAL INDUSTRIA Y COMERCIO E.I.R.L.  ","ACEMETAL E.I.R.L.",20522338011,"FUNDICION ",{"$f":"CONCATENATE(MID(BC2,1,2),\"-\",MID(AZ2,1,1),IF(MID(AZ2,(SEARCH(\" \",AZ2,4)+1),1)=\"&\",MID(AZ2,(SEARCH(\" \",AZ2,9))+1,1),MID(AZ2,(SEARCH(\" \",AZ2,4)+1),1)),\"-\",MID(BB2,3,3),MID(BB2,11,1))","v":"FU-AI-5221"},null,"FAMAI SEAL JET S.A.C.",null,20134690080,"HIDRÁULICA",{"$f":"CONCATENATE(MID(BI2,1,2),\"-\",MID(BF2,1,1),IF(MID(BF2,(SEARCH(\" \",BF2,4)+1),1)=\"&\",MID(BF2,(SEARCH(\" \",BF2,9))+1,1),MID(BF2,(SEARCH(\" \",BF2,4)+1),1)),\"-\",MID(BH2,3,3),MID(BH2,11,1))","v":"HI-FS-1340"}]
[2,"AGROINDUSTRIA",null,"CEMENTO ANDINO S.A.","CAS.A.",20129497077,"AGREGADOS",{"$f":"CONCATENATE(MID(G3,2,2),\"-\",MID(D3,1,1),IF(MID(D3,(SEARCH(\" \",D3,4)+1),1)=\"&\",MID(D3,(SEARCH(\" \",D3,9))+1,1),MID(D3,(SEARCH(\" \",D3,4)+1),1)),\"-\",MID(F3,3,3),MID(F3,11,1))","v":"GR-CA-1297"},null,"AGRO INDUSTRIAL PARAMONGA S.A.A.","AIPS.A.A.",20135948641,"AGROINDUSTRIA","AG-AI-1351",null,"ALARCON & CIA E.I.R.L.",null,20479885193,"INDUSTRIA GENERAL","IN-AC-4793",null,"CONSTRUCCIONES Y REPARACIONES MARINAS S.A.C.  ","COREMASA S.A.C",20107759736,"ASTILLERO",{"$f":"CONCATENATE(MID(Y3,1,2),\"-\",MID(V3,1,1),IF(MID(V3,(SEARCH(\" \",V3,4)+1),1)=\"&\",MID(V3,(SEARCH(\" \",V3,9))+1,1),MID(V3,(SEARCH(\" \",V3,4)+1),1)),\"-\",MID(X3,3,3),MID(X3,11,1))","v":"AS-CY-1076"},null,"ARCA   INDUSTRIAL S.A.",null,20109574784,"METALMECANICA","ME-A -1094",null,"CN MINERIA Y CONSTRUCCION S.A.C.","CN SAC",20120332067,"MINERA","MI-CY-1207",null,"CORPORACION PESQUERA INCA S.A.C.","COPEINCA S.A.C.",20224748711,"PESCA","PE-CP-2241",null,"PEDRO BOUBY MORALES",null,10084589824,"PERSONAS NATURALES",{"$f":"CONCATENATE(MID(AW3,1,2),\"-\",MID(AT3,1,1),IF(MID(AT3,(SEARCH(\" \",AT3,4)+1),1)=\"&\",MID(AT3,(SEARCH(\" \",AT3,9))+1,1),MID(AT3,(SEARCH(\" \",AT3,4)+1),1)),\"-\",MID(AV3,3,3),MID(AV3,11,1))","v":"PE-PB-0844"},null,"ALEACIONES METALURGICAS S.A.C.","ALMETS.A.C.",20504258191,"FUNDICION ","FU-AM-5041",null,"HIDRAULIC SYSTEMS S.A.C.",null,20254765652,"HIDRÁULICA",{"$f":"CONCATENATE(MID(BI3,1,2),\"-\",MID(BF3,1,1),IF(MID(BF3,(SEARCH(\" \",BF3,4)+1),1)=\"&\",MID(BF3,(SEARCH(\" \",BF3,9))+1,1),MID(BF3,(SEARCH(\" \",BF3,4)+1),1)),\"-\",MID(BH3,3,3),MID(BH3,11,1))","v":"HI-HS-2542"}]
[3,"INDUSTRIA GENERAL",null,"CEMENTOS PACASMAYO S.A.A.",null,20419387658,"AGREGADOS",{"$f":"CONCATENATE(MID(G4,2,2),\"-\",MID(D4,1,1),IF(MID(D4,(SEARCH(\" \",D4,4)+1),1)=\"&\",MID(D4,(SEARCH(\" \",D4,9))+1,1),MID(D4,(SEARCH(\" \",D4,4)+1),1)),\"-\",MID(F4,3,3),MID(F4,11,1))","v":"GR-CP-4198"},null,"AGROHOLDING S.A.C.","AGROHOLDING S.A.C.",20505885644,"AGROINDUSTRIA","AG-AS-5054",null,"ALUMINIO FAMA S.R.L.",null,20101345956,"INDUSTRIA GENERAL","IN-AF-1016",null,"SERVICIOS INDUSTRIALES DE LA MARINA S.A. ","SIMA PERU S. A.",20100003351,"ASTILLERO",{"$f":"CONCATENATE(MID(Y4,1,2),\"-\",MID(V4,1,1),IF(MID(V4,(SEARCH(\" \",V4,4)+1),1)=\"&\",MID(V4,(SEARCH(\" \",V4,9))+1,1),MID(V4,(SEARCH(\" \",V4,4)+1),1)),\"-\",MID(X4,3,3),MID(X4,11,1))","v":"AS-SI-1001"},null,"BOYLES BROS DIAMANTINA S.A.","BOYLES BROS DIAMANTINA S.A.",20100060311,"METALMECANICA","ME-BB-1001",null,"COMPAÑIA MINERA CARAVELI S.A.C.",null,20126702737,"MINERA","MI-CM-1267",null,"D & S COMECIAL",null,20491856344,"PESCA","PE-DS-4914",null,"RENDON LOPEZ TORRES JORGE LUIS",null,10255829837,"PERSONAS NATURALES",{"$f":"CONCATENATE(MID(AW4,1,2),\"-\",MID(AT4,1,1),IF(MID(AT4,(SEARCH(\" \",AT4,4)+1),1)=\"&\",MID(AT4,(SEARCH(\" \",AT4,9))+1,1),MID(AT4,(SEARCH(\" \",AT4,4)+1),1)),\"-\",MID(AV4,3,3),MID(AV4,11,1))","v":"PE-RL-2557"},null,"CORPORACION ACEROS AREQUIPA S.A.","ACEROS AREQUIPA",20370146994,"FUNDICION ","FU-CA-3704",null,"RECOLSA S.A.",null,20100248621,"HIDRÁULICA",{"$f":"CONCATENATE(MID(BI4,1,2),\"-\",MID(BF4,1,1),IF(MID(BF4,(SEARCH(\" \",BF4,4)+1),1)=\"&\",MID(BF4,(SEARCH(\" \",BF4,9))+1,1),MID(BF4,(SEARCH(\" \",BF4,4)+1),1)),\"-\",MID(BH4,3,3),MID(BH4,11,1))","v":"HI-RS-1001"}]
[4,"ASTILLERO",null,"CEMENTOS SELVA S.A.",null,20489174023,"AGREGADOS","GR-CS-4893",null,"AGROINDUSTRIAL LAREDO S.A.A.",null,20132377783,"AGROINDUSTRIA","AG-AL-1323",null,"ANDEAN MANAGEMENT S.A.C.",null,20515748939,"INDUSTRIA GENERAL","IN-AM-5159",null,"SERVINDUSTRIAS VALENCIA S.A.C.",null,20510466684,"ASTILLERO",{"$f":"CONCATENATE(MID(Y5,1,2),\"-\",MID(V5,1,1),IF(MID(V5,(SEARCH(\" \",V5,4)+1),1)=\"&\",MID(V5,(SEARCH(\" \",V5,9))+1,1),MID(V5,(SEARCH(\" \",V5,4)+1),1)),\"-\",MID(X5,3,3),MID(X5,11,1))","v":"AS-SV-5104"},null,"COMERCIAL DRILLING SERVICES S.A.C. ","CODRISE  S.A.C.",20516663643,"METALMECANICA","ME-CD-5163",null,"COMPAÑIA MINERA CONDESTABLE S.A.",null,20100056802,"MINERA","MI-CM-1002",null,"JULCA SANCHEZ REYNALDO TRINIDAD",null,10327683140,"PESCA","PE-JS-3270",null,null,null,null,null,null,null,"FUNDICION FERROSA SRL",null,20100653487,"FUNDICION ","FU-FF-1007"]
[5,"METALMECANICA",null,"FIRTH INDUSTRIES PERU S.A.",null,20263674929,"AGREGADOS","GR-FI-2639",null,"AGROINDUSTRIAL POMALCA S.A.A.","POMALCA S.A.A.",20163898200,"AGROINDUSTRIA","AG-AP-1630",null,"COFACER SERVICIOS Y COMERCIO E.I.R.L.","COFACER",20108633256,"INDUSTRIA GENERAL","IN-CS-1086",null,"SIMA IQUITOS S.R.LTDA.",20256391202,20203866497,"ASTILLERO",{"$f":"CONCATENATE(MID(Y6,1,2),\"-\",MID(V6,1,1),IF(MID(V6,(SEARCH(\" \",V6,4)+1),1)=\"&\",MID(V6,(SEARCH(\" \",V6,9))+1,1),MID(V6,(SEARCH(\" \",V6,4)+1),1)),\"-\",MID(X6,3,3),MID(X6,11,1))","v":"AS-SI-2037"},null,"EMPRESA METAL MECANICA S.A.","EMENSA S.A.",20100276322,"METALMECANICA","ME-EM-1002",null,"COMPAÑIA MINERA LUREN S.A.","C.M.L. LA CASA",20100179807,"MINERA","MI-CM-1007",null,"PESQUERA CANTABRIA S.A.",null,20504595863,"PESCA","PE-PC-5043",null,null,null,null,null,null,null,"FUNDICION VENTANILLA S.A.","FUNVES.A.",20100014808,"FUNDICION ","FU-FV-1008"]
[6,"MINERA",null,"GALLOS MARMOLERIA S.A.",null,20123444656,"AGREGADOS","GR-GM-1236",null,"AGROINDUSTRIAL TUMAN S.A.A.","EMP. AGROINDUST. TUMAN S.A.A",20136009614,"AGROINDUSTRIA","AG-AT-1364",null,"CORPORACION AYALA S.A.C.",null,20535988111,"INDUSTRIA GENERAL","IN-CA-5351",null,null,null,null,null,null,null,"FACTORIA BRERO HNOS. S.A.",null,20100263930,"METALMECANICA","ME-FB-1000",null,"CORPORACION MINERA TOMA LA MANO S.A.","CORMITOMA S.A.",20515464311,"MINERA","MI-CM-5151",null,"PESQUERA CECILIA PAOLA S.R.LTDA.",null,20115789008,"PESCA","PE-PC-1158",null,null,null,null,null,null,null,"METALURGICA PERUANA S.A.","MEPSA",20100049938,"FUNDICION ","FU-MP-1008"]
[7,"PESCA",null,"T & T INGENIERIA Y CONSTRUCCION S.A.",null,20308324266,"AGREGADOS","GR-TT-3086",null,"AGROINDUSTRIAS  SAN JACINTO S.A.A.","AGROINDUSTRIAS SAN JACINTO",20116225779,"AGROINDUSTRIA","AG-A -1169",null,"EJECUTORES INDUSTRIALES S.A.C.",null,20519170656,"INDUSTRIA GENERAL","IN-EI-5196",null,null,null,null,null,null,null,"FREPAMA S.R.Ltda.",null,20115755014,"METALMECANICA","ME-FS-1154",null,"DYNACOR EXPLORACIONES DEL PERU S.A.",null,20307825423,"MINERA","MI-DE-3073",null,"PESQUERA HAYDUY S.A.",null,20136165667,"PESCA","PE-PH-1367",null,null,null,null,null,null,null,"SIDERURGICA DEL PERU S.A.A","SIDER PERU",20402885549,"FUNDICION ","FU-SD-4029"]
[8,"PERSONAS NATURALES"]
[9,"FUNDICION "]
[10,"HIDRÁULICA"]

{"sheet":"DATOS","index":4,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Día","Mes","año","MATERIAL","Tipo de acabado"]
[1,"ENERO",2013,"SAE 40","Pre-mecanizado"]
[2,"FEBRERO",2014,"SAE 41","Acabado"]
[3,"MARZO",null,"SAE 430A"]
[4,"ABRIL",null,"SAE 430B"]
[5,"MAYO",null,"SAE 43"]
[6,"JUNIO",null,"SAE 620"]
[7,"JULIO",null,"SAE 62"]
[8,"AGOSTO",null,"SAE 622"]
[9,"SEPTIEMBRE",null,"SAE 63"]
[10,"OCTUBRE",null,"SAE 640"]
[11,"NOVIEMBRE",null,"SAE 64"]
[12,"DICIEMBRE",null,"SAE 65"]
[13,null,null,"SAE 660"]
[14,null,null,"SAE 66"]
[15,null,null,"SAE 67"]
[16,null,null,"SAE 68A"]
[17,null,null,"SAE 68B"]
[18,null,null,"SAE 710C"]
[19,null,null,"ACERO"]
[20,null,null,"COBRE"]
[21,null,null,null,{"$f":"MID(D22,11,9)","v":""}]
[22,null,null,null,""]
[23,null,null,null,""]
[24,null,null,null,""]
[25,null,null,null,""]
[26,null,null,null,""]
[27,null,null,null,""]
[28,null,null,null,""]
[29,null,null,null,""]
[30,null,null,null,""]
[31,null,null,null,""]