{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["INICIO","REGISTRO DE ACCESORIO","INFORMACIÓN","AVISO REVISIÓN","REGISTRO REVISIONES","RESUMEN","BAJA INVENTARIO","PEDIDOS","DATOS_old","DATOS","REFERENCIAS"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":1,"defined_names":15,"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":"INICIO","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,2,1,12],[25,5,30,9]]}

{"sheet":"REGISTRO DE ACCESORIO","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,3,3,5],[4,3,4,5],[5,3,5,5],[0,9,1,12],[11,0,11,2],[11,3,11,5],[3,0,6,2],[7,0,7,2],[0,0,1,1],[7,3,7,5],[0,2,1,8],[6,3,6,5],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[4,11,4,12],[5,11,5,12],[6,11,6,12],[7,11,7,12],[8,11,8,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[4,8,4,9]]}
[null,null,"INVENTARIO DE ACCESORIOS DE ELEVACIÓN\nREVISIÓN PERIÓDICA DE ACCESORIOS",null,null,null,null,null,null,"EMPRESA"]
[]
[]
["NOTA SOBRE CUMPLIMENTACIÓN \nDE LAS TABLAS",null,null,"Elige del desplegable en las celdas naranjas",null,null,null,"DEFINE ÁREAS DE LA EMPRESA PARA UBICACIÓN DE ACCESORIOS"]
[null,null,null,"Cumplimenta las celdas amarillas",null,null,null,"ÁREA 1",null,null,"ÁREA 9"]
[null,null,null,"Las celdas azules son automáticas",null,null,null,"ÁREA 2",null,null,"ÁREA 10"]
[null,null,null,"Las celdas rayadas no se cumplimentan",null,null,null,"ÁREA 3",null,null,"ÁREA 11"]
["NOTA SOBRE REFERENCIA ",null,null,"Nº ÁREA + 4 LETRAS ACCESORIO + NºACCESORIO",null,null,null,"ÁREA 4",null,null,"ÁREA 12"]
[null,null,null,null,null,null,null,"ÁREA 5",null,null,"ÁREA 13"]
[null,null,null,null,null,null,null,"ÁREA 6",null,null,"ÁREA 14"]
[null,null,null,null,null,null,null,"ÁREA 7",null,null,"ÁREA 15"]
[null,null,null,null,null,null,null,"ÁREA 8",null,null,"ÁREA 16"]
["Para dar de alta un nuevo accesorio cumplimenta la tabla (sólo celdas naranjas y amarillas) y pulsa sobre añadir nuevo.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATOS_old!BF1","v":"Por favor, selecciona un accesorio del desplegable."}]
["Nº","REFERENCIA","ESTADO","ACCESORIO","TIPOLOGÍA","CMU kg","LONGITUD\n(MEDIDA)","MATERIAL","TERMINAL","ALMA","GRADO","Nº DE RAMALES","UBICACIÓN"]
[{"$f":"IF(D15=\"\",\"\",A16+1)","v":""},{"$f":"IF(D15=0,\"\",CONCATENATE(MID(M15,6,2),VLOOKUP(D15,DATOS_old!$I$2:$K$13,3,FALSE),COUNTIF(D18:D$18,D15)+1))","v":""},{"$f":"IF(B15=\"\",\"\",IFERROR(VLOOKUP(B15,'BAJA INVENTARIO'!B$18:C$44,2,FALSE),\"ACTIVO\"))","v":""},null,null,null,null,null,null,null,null,null,"Elige ubicación"]
[2,null,null,"REGISTRO DE ACCESORIOS DADOS DE ALTA EN LA EMPRESA"]
["Nº","REFERENCIA","ESTADO","ACCESORIO","TIPOLOGÍA","CMU kg","LONGITUD\n(MEDIDA)","MATERIAL","TERMINAL","ALMA","GRADO","Nº DE RAMALES","UBICACIÓN"]
[0,null,{"$f":"IF(B18=\"\",\"\",IFERROR(VLOOKUP(B18,Tabla1[[#All],[REFERENCIA]:[ESTADO]],2,FALSE),\"ACTIVO\"))","v":""}]
[-1]

{"sheet":"INFORMACIÓN","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,8,1,10],[0,2,1,7],[3,0,6,2],[7,0,7,2],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5]]}
[null,null,"INVENTARIO DE ACCESORIOS DE ELEVACIÓN\nREVISIÓN PERIÓDICA DE ACCESORIOS",null,null,null,null,null,"EMPRESA"]
[]
[]
["NOTA SOBRE \nCUMPLIMENTACIÓN \nDE LAS TABLAS",null,null,"Elige del desplegable en las celdas naranjas"]
[null,null,null,"Cumplimenta las celdas amarillas"]
[null,null,null,"Las celdas azules son automáticas"]
[null,null,null,"Las celdas rayadas no se cumplimentan"]
["NOTA SOBRE REFERENCIA ",null,null,"Nº DE ÁREA+ 4 LETRAS DE ACCESORIO + Nº ACC"]
[]
[]
["Para completar la información del nuevo accesorio cumplimenta la tabla (sólo celdas naranjas y amarillas) y pulsa \"GRABAR\".",null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATOS_old!BQ1","v":"Por favor cumplimenta si dispone de: Marcado CE, Declaración CE de Conformidad, Manual de Instrucciones, y vuelve a pulsar sobre GRABAR."}]
["Nº","REFERENCIA","ESTADO","ACCESORIO","MARCADO CE","DECLARACIÓN CE","MANUAL INSTRUCCIONES","MARCA","MODELO","REFERENCIA INTERNA","OBSERVACIONES","COPIA DE REFERENCIA"]
[{"$f":"IF(C13=\"\",\"\",'REGISTRO DE ACCESORIO'!A18)","v":""},{"$f":"IF('REGISTRO DE ACCESORIO'!B18=\"\",\"\",'REGISTRO DE ACCESORIO'!B18)","v":""},{"$f":"IF(B13=\"\",\"\",'REGISTRO DE ACCESORIO'!C18)","v":""},{"$f":"IF(C13=\"\",\"\",'REGISTRO DE ACCESORIO'!D18)","v":""},null,null,null,null,null,null,null,{"$f":"Tabla11[REFERENCIA]","v":""}]

{"sheet":"AVISO REVISIÓN","index":3,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,3,1,12],[3,0,6,3],[7,4,7,7],[3,4,3,7],[4,4,4,7],[5,4,5,7],[6,4,6,7],[3,9,3,13],[0,13,1,13],[7,0,7,3]]}
[null,null,null,"INVENTARIO DE ACCESORIOS DE ELEVACIÓN\nREVISIÓN PERIÓDICA DE ACCESORIOS",null,null,null,null,null,null,null,null,null,"EMPRESA"]
[]
[]
["NOTA SOBRE \nCUMPLIMENTACIÓN \nDE LAS TABLAS",null,null,null,"Elige del desplegable en las celdas naranjas"]
[null,null,null,null,"Cumplimenta las celdas amarillas"]
[null,null,null,null,"Las celdas azules son automáticas",null,null,null,{"$f":"TODAY()","v":"2023-05-05"}]
[null,null,null,null,"Las celdas rayadas no se cumplimentan"]
["NOTA SOBRE REFERENCIA ",null,null,null,"Nº DE ÁREA + 4 LETRAS DE ACCESORIO + Nº ACC"]
[]
["Para completar la información del nuevo accesorio cumplimenta la tabla (sólo celdas amarillas) y pulsa \"GRABAR\".",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATOS_old!BT1","v":"Por favor cumplimenta: la fecha de compra, la fecha de puesta en servicio, la persona responsable de la revisión, dirección de correo electrónico del presonsable de la revisión, y vuelve a pulsar sobre GRABAR."}]
["Nº","REFERENCIA","ESTADO","ACCESORIO","FECHA DE COMPRA","FECHA DE PUESTA EN SERVICIO","FECHA ÚLTIMA REVISIÓN","PERIODICIDAD DE REVISIÓN","REVISIÓN (MESES)","FECHA LÍMITE PRÓXIMA REVISIÓN","FECHA AVISO REVISIÓN","HOY","RESPONSABLE REVISIÓN","CUENTA DE CORREO","Columna1"]
[{"$f":"'REGISTRO DE ACCESORIO'!A18","v":0},{"$f":"IF('REGISTRO DE ACCESORIO'!B18=\"\",\"\",'REGISTRO DE ACCESORIO'!B18)","v":""},{"$f":"IF('REGISTRO DE ACCESORIO'!D18=\"\",\"\",'REGISTRO DE ACCESORIO'!C18)","v":""},{"$f":"IF('REGISTRO DE ACCESORIO'!D18=\"\",\"\",'REGISTRO DE ACCESORIO'!D18)","v":""},null,null,{"$f":"IF(OR(E12=\"\",F12=\"\"),\"\",IFERROR(VLOOKUP(B12,Tabla8[[#All],[REFERENCIA]:[FECHA REVISIÓN]],5,FALSE),F12))","v":""},{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,DATOS!$I$2:$L$13,4,FALSE))","v":""},null,{"$f":"IF(OR(E12=\"\",F12=\"\"),\"\",IF(H12=\"Según fabricante\",IF(I12=0,\"\",G12+INT(I12*30.4166666)),IF(H12=\"Antes de cada uso\",\"PREVIO USO\",G12+VLOOKUP(H12,DATOS!$L$2:$M$7,2,FALSE))))","v":""},{"$f":"IF(OR(G12=0,H12=\"Antes de cada uso\",J12=\"\"),\"\",J12-30)","v":""},{"$f":"IF(OR(J12=\"\",H12=\"Antes de cada uso\",C12=\"BAJA\",C12=\"BAJA P\"),\"\",IF(AND(J12-$I$6<41,J12-$I$6>0),\"ENVIAR CORREO\",\"AÚN NO\"))","v":""},null,null,{"$f":"IF(L12=\"ENVIAR CORREO\",N12,\"\")","v":""}]

{"sheet":"REGISTRO REVISIONES","index":4,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,6,1,7],[0,2,1,5],[13,1,13,2],[14,1,14,2],[12,1,12,4],[3,0,6,1],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4]]}
[null,null,"INVENTARIO DE ACCESORIOS DE ELEVACIÓN\nREVISIÓN PERIÓDICA DE ACCESORIOS",null,null,null,"EMPRESA"]
[]
[]
["NOTA SOBRE \nCUMPLIMENTACIÓN \nDE LAS TABLAS",null,"Elige del desplegable en las celdas naranjas"]
[null,null,"Cumplimenta las celdas amarillas"]
[null,null,"Las celdas azules son automáticas",null,null,null,null,null,{"$f":"TODAY()","v":"2023-05-05"}]
[null,null,"Las celdas rayadas no se cumplimentan"]
["NOTA SOBRE REFERENCIA ",null,"Nº DE ÁREA + 4 LETRAS DE ACCESORIO + Nº ACC"]
[]
[]
[]
[]
[null,"REGISTRAR REVISIÓN"]
[null,"REFERENCIA ",null,"ÚLTIMA REVISIÓN","FECHA DE REVISIÓN"]
[null,"Escribe o Elige",null,{"$f":"IF(OR(B15=\"Escribe o Elige\",B15=\"\"),\"\",VLOOKUP($B$15,Tabla10[[#All],[REFERENCIA]:[FECHA ÚLTIMA REVISIÓN]],6,FALSE))","v":""}]
[]
[null,{"$f":"B15","v":"Escribe o Elige"},{"$f":"VLOOKUP(B17,Tabla10[[#All],[REFERENCIA]:[FECHA ÚLTIMA REVISIÓN]],2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B17,Tabla10[[#All],[REFERENCIA]:[FECHA ÚLTIMA REVISIÓN]],3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(B17,Tabla10[[#All],[REFERENCIA]:[RESPONSABLE REVISIÓN]],12,FALSE)=\"\",\"SIN RESPONSABLE\",VLOOKUP(B17,Tabla10[[#All],[REFERENCIA]:[RESPONSABLE REVISIÓN]],12,FALSE))","v":{"$error":"#N/A"}},{"$f":"E15","v":"00:00:00"},{"$f":"TODAY()","v":"2023-05-05"},{"$f":"IFERROR(VLOOKUP(RESUMEN!C22,Tabla8[[#All],[REFERENCIA]],1,FALSE),\"\")","v":""}]
["NÚMERO DE REVISIÓN","REFERENCIA","ESTADO","ACCESORIO","RESPONSABLE","FECHA REVISIÓN","FECHA REGISTRO"]
[0]

{"sheet":"RESUMEN","index":5,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[21,0,21,1],[0,1,1,2],[0,3,1,3],[5,3,6,3]]}
[null,"INVENTARIO DE ACCESORIOS DE ELEVACIÓN\nREVISIÓN PERIÓDICA DE ACCESORIOS",null,"EMPRESA"]
[]
[]
[null,"Escribe la Referencia interna",null,{"$f":"IF(C4=\"\",\"\",IFERROR(VLOOKUP(C4,Tabla11[[REFERENCIA INTERNA]:[COPIA DE REFERENCIA]],3,FALSE),\"NO ENCONTRADO\"))","v":""}]
[null,null,{"$f":"IF(OR(D4=\"\",D4=\"NO ENCONTRADO\"),\"\",\"Busque la REFERENCIA indicada en el desplegable\")","v":""}]
[null,{"$f":"IF(C3=\"\",\"\",\"REFERENCIA\")","v":""},null,{"$f":"IF(C6=\"\",\"\",\"Busque la REFERENCIA indicada en el desplegable\")","v":""}]
[null,"REFERENCIA"]
[]
[null,"ACCESORIO",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",VLOOKUP($C$7,Tabla9[[#All],[REFERENCIA]:[ACCESORIO]],3,FALSE))","v":""}]
[null,"TIPOLOGÍA",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",VLOOKUP($C$7,Tabla9[[#All],[REFERENCIA]:[TIPOLOGÍA]],4,FALSE))","v":""}]
[null,"MARCA",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",VLOOKUP($C$7,Tabla11[[#All],[REFERENCIA]:[MARCA]],7,FALSE))","v":""}]
[null,"MODELO",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",VLOOKUP($C$7,Tabla11[[#All],[REFERENCIA]:[MODELO]],8,FALSE))","v":""}]
[null,"MARCADO CE",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",VLOOKUP($C$7,Tabla11[[#All],[REFERENCIA]:[MARCADO CE]],4,FALSE))","v":""}]
[null,"DECLARACIÓN CE",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",VLOOKUP($C$7,Tabla11[[#All],[REFERENCIA]:[DECLARACIÓN CE]],5,FALSE))","v":""}]
[null,"MANUAL INSTRUCCIONES",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",VLOOKUP($C$7,Tabla11[[#All],[REFERENCIA]:[MANUAL INSTRUCCIONES]],6,FALSE))","v":""}]
[null,"ESTADO",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",VLOOKUP($C$7,Tabla9[[#All],[REFERENCIA]:[ACCESORIO]],2,FALSE))","v":""}]
[null,"FECHA DE BAJA",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\",C16=\"ACTIVO\"),\"\",VLOOKUP($C$7,Tabla1[[#All],[REFERENCIA]:[FECHA DE BAJA]],6,FALSE))","v":""}]
[null,"FECHA DE COMPRA",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",IF(VLOOKUP($C$7,Tabla10[[#All],[REFERENCIA]:[FECHA DE COMPRA]],4,FALSE)=\"\",\"SIN FECHA\",VLOOKUP($C$7,Tabla10[[#All],[REFERENCIA]:[FECHA DE COMPRA]],4,FALSE)))","v":""}]
[null,"FECHA DE PUESTA EN SERVICIO",{"$f":"IF(OR(C7=\"\",C7=\"Escribe o Elige\"),\"\",IF(VLOOKUP($C$7,Tabla10[[#All],[REFERENCIA]:[FECHA DE PUESTA EN SERVICIO]],5,FALSE)=\"\",\"SIN FECHA\",VLOOKUP($C$7,Tabla10[[#All],[REFERENCIA]:[FECHA DE PUESTA EN SERVICIO]],5,FALSE)))","v":""}]
[null,"FECHA ÚLTIMA REVISIÓN",{"$f":"IF(OR(C7=\"Escribe o Elige\",C7=\"\"),\"\",VLOOKUP($C$7,Tabla10[[#All],[REFERENCIA]:[FECHA ÚLTIMA REVISIÓN]],6,FALSE))","v":""}]
[null,"PERIODICIDAD DE REVISIÓN",{"$f":"IF(OR(C7=\"Escribe o Elige\",C7=\"\"),\"\",IF(VLOOKUP($C$7,Tabla10[[#All],[REFERENCIA]:[PERIODICIDAD DE REVISIÓN]],7,FALSE)=\"Según fabricante\",CONCATENATE(VLOOKUP($C$7,Tabla10[[#All],[REFERENCIA]:[REVISIÓN (MESES)]],8,FALSE),\" meses\"),VLOOKUP($C$7,Tabla10[[#All],[REFERENCIA]:[PERIODICIDAD DE REVISIÓN]],7,FALSE)))","v":""}]
["REVISIONES REGISTRADAS DEL ACCESORIO:",null,{"$f":"IF(OR(C7=\"Escribe o Elige\",C7=\"\"),\"\",C7)","v":""}]
["RESPONSABLE","FECHA REVISIÓN","FECHA REGISTRO","MESES ENTRE REVISIONES"]
[null,null,null,{"$f":"IF(B24=\"\",\"\",IF(B25=\"\",CONCATENATE(ROUND((B24-$C$19)/30,0),\" meses 1ª revisión\"),CONCATENATE(ROUND((B24-B25)/30,0),\" meses\")))","v":""}]
[]
[null,null,null,{"$f":"IF(B26=\"\",\"\",IF(B27=\"\",CONCATENATE(ROUND((B26-$C$19)/30,0),\" meses 1ª revisión\"),CONCATENATE(ROUND((B26-B27)/30,0),\" meses\")))","v":""}]
[null,null,null,{"$f":"IF(B27=\"\",\"\",IF(B28=\"\",CONCATENATE(ROUND((B27-$C$19)/30,0),\" meses 1ª revisión\"),CONCATENATE(ROUND((B27-B28)/30,0),\" meses\")))","v":""}]
[null,null,null,{"$f":"IF(B28=\"\",\"\",IF(B29=\"\",CONCATENATE(ROUND((B28-$C$19)/30,0),\" meses 1ª revisión\"),CONCATENATE(ROUND((B28-B29)/30,0),\" meses\")))","v":""}]
[null,null,null,{"$f":"IF(B29=\"\",\"\",IF(B30=\"\",CONCATENATE(ROUND((B29-$C$19)/30,0),\" meses 1ª revisión\"),CONCATENATE(ROUND((B29-B30)/30,0),\" meses\")))","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"BAJA INVENTARIO","index":6,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,0,16,8],[7,0,7,2],[0,0,1,1],[0,2,1,6],[3,0,6,2],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[0,7,1,8]]}
[null,null,"INVENTARIO DE ACCESORIOS DE ELEVACIÓN\nREVISIÓN PERIÓDICA DE ACCESORIOS",null,null,null,null,"EMPRESA"]
[]
[]
["NOTA SOBRE \nCUMPLIMENTACIÓN \nDE LAS TABLAS",null,null,"Elige del desplegable en las celdas naranjas"]
[null,null,null,"Cumplimenta las celdas amarillas"]
[null,null,null,"Las celdas azules son automáticas"]
[null,null,null,"Las celdas rayadas no se cumplimentan"]
["NOTA SOBRE REFERENCIA ",null,null,"Nº DE ÁREA + 4 LETRAS DE ACCESORIO + Nº ACC"]
[]
[]
[]
[]
[null,"Para dar de BAJA un accesorio cumplimenta la tabla (sólo celdas naranjas y amarillas) y pulsa sobre \"DAR DE BAJA\".",null,null,null,null,null,null,{"$f":"DATOS_old!BW1","v":"Por favor, escibe o elige accesorio del desplegable"}]
[null,"REFERENCIA","PASA A ESTADO","ACCESORIO","TIPOLOGÍA","MOTIVO BAJA EN INVENTARIO","FECHA  DE BAJA","SOLICITUD NUEVO ELEMENTO","OBSERVACIONES"]
[null,"Escribe o Elige",{"$f":"IF(OR(B15=\"\",B15=\"Elige desp.\"),\"\",IF(F15=\"\",\"\",IF(F15=\"PÉRDIDA\",\"BAJA P\",\"BAJA\")))","v":""},{"$f":"IF(OR(B15=\"\",B15=\"Escribe o Elige\"),\"\",VLOOKUP($B$15,Tabla9[[#All],[REFERENCIA]:[ACCESORIO]],3,FALSE))","v":""},{"$f":"IF(OR(B15=\"\",B15=\"Escribe o Elige\"),\"\",VLOOKUP($B$15,Tabla9[[#All],[REFERENCIA]:[TIPOLOGÍA]],4,FALSE))","v":""}]
[]
["REGISTRO DE BAJAS"]
["Nº","REFERENCIA","ESTADO","ACCESORIO","TIPOLOGÍA","MOTIVO BAJA EN INVENTARIO","FECHA DE BAJA","SOLICITUD NUEVO ELEMENTO","OBSERVACIONES"]
[0]

{"sheet":"PEDIDOS","index":7,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,2,1,5],[3,0,6,2],[7,0,7,2],[6,6,6,7],[7,6,7,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[7,3,7,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[0,6,1,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[25,1,25,7],[13,6,13,7],[12,0,12,1],[13,0,13,1],[10,3,10,4],[11,0,11,1],[11,3,11,4],[12,3,12,4],[13,3,13,4]]}
[null,null,"INVENTARIO DE ACCESORIOS DE ELEVACIÓN\nREVISIÓN PERIÓDICA DE ACCESORIOS",null,null,null,"EMPRESA"]
[]
[]
["NOTA SOBRE \nCUMPLIMENTACIÓN \nDE LAS TABLAS",null,null,"Elige del desplegable en las celdas naranjas",null,"PROVEEDOR","WEB CATÁLOGO"]
[null,null,null,"Cumplimenta las celdas amarillas"]
[null,null,null,"Las celdas azules son automáticas"]
[null,null,null,"Las celdas rayadas no se cumplimentan"]
["NOTA SOBRE REFERENCIA ",null,null,"Nº DE ÁREA + 4 LETRAS DE ACCESORIO + Nº ACC"]
[]
[]
[null,null,"Destinatario","correo electrónico"]
["Dirigido a :"]
["Copia"]
["CCO:"]
[null,"Para dar hacer el pedido de un accesorio cumplimenta la tabla (sólo celdas naranjas y amarillas) y pulsa sobre \"Enviar Y REGISTRAR PEDIDO\".",null,null,null,null,null,{"$f":"DATOS_old!CB1","v":"Por favor, escibe o elige accesorio del desplegable"}]
[null,"ACCESORIO","TIPOLOGÍA","PROVEEDOR","FABRICANTE","REF FABRICANTE","INFORMACIÓN ADICIONAL","FECHA "]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-05-05"}]
[null,null,null,null,null,null,null,{"$f":"DATOS_old!CB14","v":"Necesitamos adquirir el siguiente accesorio de elevación: , lo antes posible."}]
[null,null,null,null,null,null,null,{"$f":"DATOS_old!CB15","v":"Si hubiera algún problema, por favor hágamelo saber."}]
[]
[]
[]
[]
[]
[]
[null,"REGISTRO DE PEDIDOS"]
[null,"ACCESORIO","TIPOLOGÍA","PROVEEDOR","FABRICANTE","REF FABRICANTE","INFORMACIÓN ADICIONAL","FECHA"]

{"sheet":"DATOS_old","index":8,"n_rows":58,"n_cols":87,"rows_kept":58,"cut":false,"hidden":true,"merged":[[5,31,5,33],[6,31,6,33],[9,31,9,33],[7,31,7,33],[8,31,8,33],[4,31,4,33],[2,31,2,33],[3,31,3,33],[0,16,0,18],[0,19,0,20],[0,21,0,22],[0,25,0,26],[1,29,1,30],[0,27,0,28],[0,29,0,30],[0,31,0,33],[1,27,1,28],[1,31,1,33]]}
["Elige ubicación","Escribe o Elige","Periodicidad","dias","Dispone",null,null,null,"Elige Accesorio",null,null,"Frecuencia de inspección",null,null,"Norma de referencia","Escribe o Elige","Accesorio de elevación",null,null,"Material",null,"Terminal",null,"Alma","Grado","Nº de ramales",null,"Longitud",null,"CMU o WLL",null,"Tipología ",null,null,"BAJA EN INVENTARIO",null,"SOLICITUD NUEVO ELEMENTO",null,null,null,null,"GRILLETE","CÁNCAMO_Y_ANILLA","ESLINGA_DE_CADENA","ESLINGA_DE_CABLE","ESLINGA_TEXTIL","VIGA DE SUSPENSIÓN","PINZA_DE_ELEVACIÓN","GANCHO C","IMÁN","VENTOSA DE VACÍO","FABRICACIÓN PROPIA ","OTRO",null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=\"\",BD2,IF(BE13=0,\"\",CONCATENATE(\"Por favor cumplimenta: \",BD3,BD4,BD5,BD6,BD7,BD8,BD9,BD10,BD11,BD12,\"y vuelve a pulsar sobre AÑADIR NUEVO.\")))","v":"Por favor, selecciona un accesorio del desplegable."},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BR5=0,\"\",CONCATENATE(\"Por favor cumplimenta si dispone de: \",BQ2,BQ3,BQ4,\"y vuelve a pulsar sobre GRABAR.\"))","v":"Por favor cumplimenta si dispone de: Marcado CE, Declaración CE de Conformidad, Manual de Instrucciones, y vuelve a pulsar sobre GRABAR."},null,null,{"$f":"IF(BU7=0,\"\",CONCATENATE(\"Por favor cumplimenta: \",BT2,BT3,BT4,BT5,BT6,\"y vuelve a pulsar sobre GRABAR.\"))","v":"Por favor cumplimenta: la fecha de compra, la fecha de puesta en servicio, la persona responsable de la revisión, dirección de correo electrónico del presonsable de la revisión, y vuelve a pulsar sobre GRABAR."},null,null,{"$f":"IF(OR('BAJA INVENTARIO'!B15=\"\",'BAJA INVENTARIO'!B15=\"Escribe o Elige\"),\"Por favor, escibe o elige accesorio del desplegable\",IF(BX5=0,\"\",CONCATENATE(\"Por favor cumplimenta: \",BW3,BW4,\"y vuelve a pulsar sobre DAR DE BAJA.\")))","v":"Por favor, escibe o elige accesorio del desplegable"},null,null,null,null,{"$f":"IF(OR(PEDIDOS!B17=\"\",PEDIDOS!B17=\"Escribe o Elige\"),\"Por favor, escibe o elige accesorio del desplegable\",IF(CC10>0,CONCATENATE(\"Por favor cumplimenta: \",CB2,CB3,CB5,CB6,CB11,\"y vuelve a pulsar sobre REGISTRAR PEDIDO.\"),IF(OR(CC7=1,CC8=1), IF(CC9=1,\"Por favor cumplimenta o el fabricante y su ferencia o la información adicional, y vuelve a pulsar sobre REGISTRAR PEDIDO\",\"\"),\"\")))","v":"Por favor, escibe o elige accesorio del desplegable"},null,null,null,null,null,null,"Escribe o Elige"]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I5=\"\",\"\",\"ÁREA 01\")","v":""},{"$f":"IFERROR(IF(VLOOKUP('REGISTRO DE ACCESORIO'!B18,Tabla9[[#All],[REFERENCIA]:[ESTADO]],2,FALSE)=\"ACTIVO\",'REGISTRO DE ACCESORIO'!B18,\"\"),\"\")","v":""},"Trimestral",90,"Si",null,"ACTIVO","SI","GRILLETE",null,"GRIL","Semestral",182,null,"UNE-EN 13889",{"$error":"#N/A"},null,null,null,"Poliester - PE",null,"Ojal y Metálico",null,"Textil",80,1,null,null,null,null,null,null,null,null,"DEFECTUOSO O ROTO",null,"SI",null,null,null,null,"Grillete recto pasador w","Cáncamo macho fijo","Eslinga de cadena 4mm","Eslinga de cable 8mm","Eslinga textil plana",null,"Horizontal",null,"Electroimán",null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=\"\",\"Por favor, selecciona un accesorio del desplegable.\",\"\")","v":"Por favor, selecciona un accesorio del desplegable."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"INFORMACIÓN!$E$13\")=\"\",\"Marcado CE, \",\"\")","v":"Marcado CE, "},{"$f":"IF(BQ2=\"\",0,1)","v":1},null,{"$f":"IF(INDIRECT(\"'AVISO REVISIÓN'!E12\")=\"\",\"la fecha de compra, \",\"\")","v":"la fecha de compra, "},{"$f":"IF(BT2=\"\",0,1)","v":1},null,null,null,null,null,null,{"$f":"IF(PEDIDOS!C12=\"\",\"destinatario, \",\"\")","v":"destinatario, "},{"$f":"IF(CB2=\"\",0,1)","v":1},null,null,null,null,null,{"$f":"'REGISTRO DE ACCESORIO'!B18","v":0}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I6=\"\",\"\",\"ÁREA 02\")","v":""},null,"Semestral",182,"No",null,"BAJA","NO","CÁNCAMO_Y_ANILLA",null,"CANC","Anual",365,null,"UNE-EN 3266","01GRIL2","Grillete recto pasador w",null,null,"Poliamida - PA",null,"Metalico",null,"Acero",100,2,null,null,null,null,null,null,null,null,"PÉRDIDA",null,"NO",null,null,null,null,"Grillete recto pasador X","Cáncamo macho giratorio","Eslinga de cadena 5mm","Eslinga de cable 9mm","Eslinga textil tubular",null,"Vertical",null,"Imán manual",null,null,null,null,null,{"$f":"IF(AND('REGISTRO DE ACCESORIO'!I5=\"\",'REGISTRO DE ACCESORIO'!I6=\"\",'REGISTRO DE ACCESORIO'!I7=\"\",'REGISTRO DE ACCESORIO'!I8=\"\",'REGISTRO DE ACCESORIO'!I9=\"\",'REGISTRO DE ACCESORIO'!I10=\"\",'REGISTRO DE ACCESORIO'!I11=\"\",'REGISTRO DE ACCESORIO'!I12=\"\",'REGISTRO DE ACCESORIO'!L5=\"\",'REGISTRO DE ACCESORIO'!L6=\"\",'REGISTRO DE ACCESORIO'!L7=\"\",'REGISTRO DE ACCESORIO'!L8=\"\",'REGISTRO DE ACCESORIO'!L9=\"\",'REGISTRO DE ACCESORIO'!L10=\"\",'REGISTRO DE ACCESORIO'!L11=\"\",'REGISTRO DE ACCESORIO'!L12=\"\"),\"las áreas de la empresa, \",\"\")","v":"las áreas de la empresa, "},{"$f":"IF(BD3=\"\",\"\",1)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"INFORMACIÓN!F13\")=\"\",\"Declaración CE de Conformidad, \",\"\")","v":"Declaración CE de Conformidad, "},{"$f":"IF(BQ3=\"\",0,1)","v":1},null,{"$f":"IF(INDIRECT(\"'AVISO REVISIÓN'!F12\")=\"\",\"la fecha de puesta en servicio, \",\"\")","v":"la fecha de puesta en servicio, "},{"$f":"IF(BT3=\"\",0,1)","v":1},null,{"$f":"IF('BAJA INVENTARIO'!F15=\"\",\"Motivo de dar de baja en el inventario, \",\"\")","v":"Motivo de dar de baja en el inventario, "},{"$f":"IF(BW3=\"\",0,1)","v":1},null,null,null,{"$f":"IF(PEDIDOS!D12=\"\",\"dirección de correo electrónico, \",\"\")","v":"dirección de correo electrónico, "},1]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I7=\"\",\"\",\"ÁREA 03\")","v":""},null,"Anual",365,null,null,null,null,"ESLINGA_DE_CADENA",null,"ECAD","Anual",null,null,"UNE-EN 818","01GRIL1","Grillete recto pasador X",null,null,"Polipropileno - PP",null,"Ojal",null,null,120,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grillete lira pasador w","Cáncamo hembra fijo","Eslinga de cadena 6mm","Eslinga de cable 10mm","Eslinga textil sin fin tubular",null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=\"\",\"\",IF('REGISTRO DE ACCESORIO'!F15=\"\",\"la CMU, \",\"\"))","v":""},{"$f":"IF(BD4=\"\",\"\",1)","v":""},"ACCESORIO","TIPOLOGÍA","CMU kg","LONGITUD\n(MEDIDA)","MATERIAL","TERMINAL","ALMA","GRADO","Nº DE RAMALES","UBICACIÓN",null,{"$f":"IF(INDIRECT(\"INFORMACIÓN!G13\")=\"\",\"Manual de Instrucciones, \",\"\")","v":"Manual de Instrucciones, "},{"$f":"IF(BQ4=\"\",0,1)","v":1},null,{"$f":"IF(OR(INDIRECT(\"'AVISO REVISIÓN'!D12\")=I7,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I8,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I9,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I10,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I11,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I12),IF(INDIRECT(\"'AVISO REVISIÓN'!I12\")=\"\",\"la revisión en meses, \",\"\"),\"\")","v":""},{"$f":"IF(BT4=\"\",0,1)","v":0},null,{"$f":"IF('BAJA INVENTARIO'!G15=\"\",\"fecha de la baja en el inventario, \",\"\")","v":"fecha de la baja en el inventario, "},{"$f":"IF(BW4=\"\",0,1)","v":1},null,null,null,{"$f":"IF(PEDIDOS!B17=\"\",\"Por favor, selecciona un accesorio del desplegable.\",\"\")","v":"Por favor, selecciona un accesorio del desplegable."},{"$f":"IF(CB4=\"\",0,1)","v":1}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I8=\"\",\"\",\"ÁREA 04\")","v":""},null,null,null,null,null,null,null,"ESLINGA_DE_CABLE",null,"ECAB","Anual",null,null,"UNE-EN 13414",null,"Grillete lira pasador w",null,null,null,null,"Sin Fin",null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grillete lira pasador X","Cáncamo hembra giratorio","Eslinga de cadena 7mm","Eslinga de cable 11mm","Eslinga textil sin fin plana",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('REGISTRO DE ACCESORIO'!D15=BF5,'REGISTRO DE ACCESORIO'!D15=BF6,'REGISTRO DE ACCESORIO'!D15=BF7,'REGISTRO DE ACCESORIO'!D15=BF8,'REGISTRO DE ACCESORIO'!D15=BF9,'REGISTRO DE ACCESORIO'!D15=BF13),IF('REGISTRO DE ACCESORIO'!E15=\"\",\"la tipología, \",\"\"),\"\")","v":""},{"$f":"IF(BD5=\"\",\"\",1)","v":""},"GRILLETE","X","X",null,null,null,null,null,null,"X",null,null,{"$f":"SUM(BR2:BR4)","v":3},null,{"$f":"IF(INDIRECT(\"'AVISO REVISIÓN'!M12\")=\"\",\"la persona responsable de la revisión, \",\"\")","v":"la persona responsable de la revisión, "},{"$f":"IF(BT5=\"\",0,1)","v":1},null,null,{"$f":"SUM(BX3:BX4)","v":2},null,null,null,{"$f":"IF(OR(PEDIDOS!B17=DATOS_old!AU1,PEDIDOS!B17=DATOS_old!AV1,PEDIDOS!B17=DATOS_old!AW1,PEDIDOS!B17=DATOS_old!AY1,PEDIDOS!B17=DATOS_old!AZ1,PEDIDOS!B17=DATOS_old!BA1),\"\",IF(PEDIDOS!C17=\"\",\"la tipología del accesorio, \",\"\"))","v":"la tipología del accesorio, "},{"$f":"IF(CB5=\"\",0,1)","v":1},{"$f":"IF(PEDIDOS!C17=\"\",\"\",CONCATENATE(\" de tipología: \",PEDIDOS!C17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I9=\"\",\"\",\"ÁREA 05\")","v":""},null,null,null,null,null,null,null,"ESLINGA_TEXTIL",null,"ETEX","Anual",0,null,"UNE-EN 1492",null,"Grillete lira pasador X",null,null,null,null,null,null,null,null,"Sin fin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 8mm","Eslinga de cable 12mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('REGISTRO DE ACCESORIO'!D15=BF7,'REGISTRO DE ACCESORIO'!D15=BF8,'REGISTRO DE ACCESORIO'!D15=BF9,'REGISTRO DE ACCESORIO'!D15=BF10),IF('REGISTRO DE ACCESORIO'!G15=\"\",\"la longitud, \",\"\"),\"\")","v":""},"","CÁNCAMO_Y_ANILLA","X","X",null,null,null,null,null,null,"X",null,null,null,null,{"$f":"IF(INDIRECT(\"'AVISO REVISIÓN'!N12\")=\"\",\"dirección de correo electrónico del presonsable de la revisión, \",\"\")","v":"dirección de correo electrónico del presonsable de la revisión, "},{"$f":"IF(BT6=\"\",0,1)","v":1},null,null,null,null,null,null,{"$f":"IF(PEDIDOS!D17=\"\",\"el proveedor, \",\"\")","v":"el proveedor, "},{"$f":"IF(CB6=\"\",0,1)","v":1},{"$f":"IF(PEDIDOS!D17=\"\",\"\",CONCATENATE(\" del proveedor: \",PEDIDOS!D17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I10=\"\",\"\",\"ÁREA 06\")","v":""},null,null,null,null,null,null,null,"VIGA DE SUSPENSIÓN",null,"VSUS","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 4mm",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,"Eslinga de cadena 10mm","Eslinga de cable 13mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=BF9,IF('REGISTRO DE ACCESORIO'!H15=\"\",\"el material, \",\"\"),\"\")","v":""},"","ESLINGA_DE_CADENA","X","X","X",null,null,null,"X","X","X",null,null,null,null,null,{"$f":"SUM(BU2:BU6)","v":4},null,null,null,null,null,null,{"$f":"IF(PEDIDOS!E17=\"\",\"el fabricante, \",\"\")","v":"el fabricante, "},1,{"$f":"IF(PEDIDOS!E17=\"\",\"\",CONCATENATE(\" del fabricante : \",PEDIDOS!E17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I11=\"\",\"\",\"ÁREA 07\")","v":""},null,null,null,null,null,null,null,"PINZA_DE_ELEVACIÓN",null,"PELE","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 5mm",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,"Eslinga de cadena 13mm","Eslinga de cable 14mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('REGISTRO DE ACCESORIO'!D15=BF9,OR('REGISTRO DE ACCESORIO'!E15=\"Eslinga textil plana\",'REGISTRO DE ACCESORIO'!E15=\"Eslinga textil tubular\")),IF('REGISTRO DE ACCESORIO'!I15=\"\",\"el terminal, \",\"\"),\"\")","v":""},"","ESLINGA_DE_CABLE","X","X","X",null,null,"X",null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PEDIDOS!F17=\"\",\"la referencia del fabricante, \",\"\")","v":"la referencia del fabricante, "},1,{"$f":"IF(PEDIDOS!F17=\"\",\"\",CONCATENATE(\" con referencia: \",PEDIDOS!F17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I12=\"\",\"\",\"ÁREA 08\")","v":""},null,null,null,null,null,null,null,"GANCHO C",null,"GANC","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 6mm",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,"Eslinga de cadena 16mm","Eslinga de cable 16mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=BF8,IF('REGISTRO DE ACCESORIO'!J15=\"\",\"el alma, \",\"\"),\"\")","v":""},"","ESLINGA_TEXTIL","X","X","X","X","X",null,null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PEDIDOS!G17=\"\",\"información adicional, \",\"\")","v":"información adicional, "},1,{"$f":"IF(PEDIDOS!G17=\"\",\"\",CONCATENATE(\" y con la información adicional: \",PEDIDOS!G17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L5=\"\",\"\",\"ÁREA 09\")","v":""},null,null,null,null,null,null,null,"IMÁN",null,"IMAN","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 7mm",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,"Eslinga de cadena 18mm","Eslinga de cable 18mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=BF7,IF('REGISTRO DE ACCESORIO'!K15=\"\",\"el grado, \",\"\"),\"\")","v":""},"","VIGA DE SUSPENSIÓN",null,"X","X",null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CC2:CC3,CC5:CC6)","v":4}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L6=\"\",\"\",\"ÁREA 10\")","v":""},null,null,null,null,null,null,null,"VENTOSA DE VACÍO",null,"VVAC","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 8mm",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,"Eslinga de cadena 19mm","Eslinga de cable 20mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('REGISTRO DE ACCESORIO'!D15=BF7,'REGISTRO DE ACCESORIO'!D15=BF8,AND('REGISTRO DE ACCESORIO'!D15=BF9,OR('REGISTRO DE ACCESORIO'!E15=\"Eslinga textil plana\",'REGISTRO DE ACCESORIO'!E15=\"Eslinga textil tubular\"))),IF('REGISTRO DE ACCESORIO'!L15=\"\",\"el número de ramales, \",\"\"),\"\")","v":""},"","PINZA DE ELEVACIÓN",null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CC11>0,\"el fabricante, su referencia o la información adicional \",\"\")","v":"el fabricante, su referencia o la información adicional "},{"$f":"SUM(CC7:CC9)","v":3}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L7=\"\",\"\",\"ÁREA 11\")","v":""},null,null,null,null,null,null,null,"FABRICACIÓN PROPIA ",null,"FPIA","Según fabricante",null,null,null,null,"Eslinga de cadena 10mm",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,"Eslinga de cadena 20mm","Eslinga de cable 22mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=\"\",\"\",IF(OR('REGISTRO DE ACCESORIO'!M15=\"\",'REGISTRO DE ACCESORIO'!M15=\"Elige ubicación\"),\"la ubicación del accesorio, \",\"\"))","v":""},"","GANCHO C",null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,"CUERPO DEL CORREO"]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L8=\"\",\"\",\"ÁREA 12\")","v":""},null,null,null,null,null,null,null,"OTRO",null,"OTRO","Según fabricante",null,null,null,null,"Eslinga de cadena 13mm",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,"Eslinga de cadena 22mm","Eslinga de cable 24mm",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BE3:BE12)","v":1},"IMÁN","X","X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Estimado/a \",PEDIDOS!C12)","v":"Estimado/a "}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L9=\"\",\"\",\"ÁREA 13\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 16mm",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,"Eslinga de cadena 23mm","Eslinga de cable 26mm",null,null,null,null,null,null,null,null,null,null,null,null,"VENTOSA DE VACÍO",null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Necesitamos adquirir el siguiente accesorio de elevación: \",PEDIDOS!B17,\",\",CD5,CD6,CD7,CD8,CD9,\" lo antes posible.\")","v":"Necesitamos adquirir el siguiente accesorio de elevación: , lo antes posible."}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L10=\"\",\"\",\"ÁREA 14\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MID(Q3,1,2)","v":"Gr"},null,null,null,"Eslinga de cadena 18mm",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,"Eslinga de cadena 25mm","Eslinga de cable 28mm",null,null,null,null,null,null,null,null,null,null,null,null,"FABRICACIÓN PROPIA ",null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,"Si hubiera algún problema, por favor hágamelo saber."]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L11=\"\",\"\",\"ÁREA 15\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 19mm",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,"Eslinga de cadena 26mm","Eslinga de cable 32mm",null,null,null,null,null,null,null,null,null,null,null,null,"OTRO",null,"X",null,null,null,null,null,null,"X"]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L12=\"\",\"\",\"ÁREA 16\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 20mm",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,"Eslinga de cadena 28mm","Eslinga de cable 36mm",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,"ERROR DE CORREO DE DESTINATARIOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 22mm",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,"Eslinga de cadena 32mm","Eslinga de cable 40mm",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,{"$f":"IFERROR(SEARCH(\"@\",PEDIDOS!D12,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 23mm",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,"Eslinga de cadena 36mm","Eslinga de cable 44mm",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,{"$f":"IFERROR(SEARCH(\"@\",PEDIDOS!D13,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 25mm",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,"Eslinga de cadena 40mm","Eslinga de cable 48mm",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,{"$f":"IFERROR(SEARCH(\"@\",PEDIDOS!D14,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 26mm",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,"Eslinga de cadena 45mm","Eslinga de cable 52mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 28mm",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,"Eslinga de cable 56mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 32mm",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,"Eslinga de cable 60mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 36mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 40mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 45mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 8mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 9mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 10mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 11mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 12mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 13mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 14mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 16mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 18mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 20mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 22mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 24mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 26mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 28mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 32mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 36mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 40mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 44mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 48mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 52mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 56mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 60mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cáncamo macho fijo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cáncamo macho giratorio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cáncamo hembra fijo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cáncamo hembra giratorio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga textil plana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga textil tubular"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga sin fin tubular"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga sin fin plana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electroimán"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Imán manual"]

{"sheet":"DATOS","index":9,"n_rows":58,"n_cols":87,"rows_kept":58,"cut":false,"hidden":true,"merged":[[0,16,0,18],[0,19,0,20],[0,21,0,22],[0,25,0,26],[0,27,0,28],[9,31,9,33],[0,31,0,33],[1,27,1,28],[1,29,1,30],[1,31,1,33],[2,31,2,33],[3,31,3,33],[0,29,0,30],[4,31,4,33],[5,31,5,33],[6,31,6,33],[7,31,7,33],[8,31,8,33]]}
["Elige ubicación","Escribe o Elige","Periodicidad","dias","Dispone",null,null,null,"Elige Accesorio",null,null,"Frecuencia de inspección",null,null,"Norma de referencia","Escribe o Elige","Accesorio de elevación",null,null,"Material",null,"Terminal",null,"Alma","Grado","Nº de ramales",null,"Longitud",null,"CMU o WLL",null,"Tipología ",null,null,"BAJA EN INVENTARIO",null,"SOLICITUD NUEVO ELEMENTO",null,null,null,null,"GRILLETE","CÁNCAMO_Y_ANILLA","ESLINGA_DE_CADENA","ESLINGA_DE_CABLE","ESLINGA_TEXTIL","VIGA DE SUSPENSIÓN","PINZA DE ELEVACIÓN","GANCHO C","IMÁN","VENTOSA DE VACÍO","FABRICACIÓN PROPIA ","OTRO",null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=\"\",BD2,IF(BE13=0,\"\",CONCATENATE(\"Por favor cumplimenta: \",BD3,BD4,BD5,BD6,BD7,BD8,BD9,BD10,BD11,BD12,\"y vuelve a pulsar sobre AÑADIR NUEVO.\")))","v":"Por favor, selecciona un accesorio del desplegable."},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BR5=0,\"\",CONCATENATE(\"Por favor cumplimenta si dispone de: \",BQ2,BQ3,BQ4,\"y vuelve a pulsar sobre GRABAR.\"))","v":"Por favor cumplimenta si dispone de: Marcado CE, Declaración CE de Conformidad, Manual de Instrucciones, y vuelve a pulsar sobre GRABAR."},null,null,{"$f":"IF(BU7=0,\"\",CONCATENATE(\"Por favor cumplimenta: \",BT2,BT3,BT4,BT5,BT6,\"y vuelve a pulsar sobre GRABAR.\"))","v":"Por favor cumplimenta: la fecha de compra, la fecha de puesta en servicio, la persona responsable de la revisión, dirección de correo electrónico del presonsable de la revisión, y vuelve a pulsar sobre GRABAR."},null,null,{"$f":"IF(OR('BAJA INVENTARIO'!B15=\"\",'BAJA INVENTARIO'!B15=\"Escribe o Elige\"),\"Por favor, escibe o elige accesorio del desplegable\",IF(BX5=0,\"\",CONCATENATE(\"Por favor cumplimenta: \",BW3,BW4,\"y vuelve a pulsar sobre DAR DE BAJA.\")))","v":"Por favor, escibe o elige accesorio del desplegable"},null,null,null,null,{"$f":"IF(OR(PEDIDOS!B17=\"\",PEDIDOS!B17=\"Escribe o Elige\"),\"Por favor, escibe o elige accesorio del desplegable\",IF(CC10>0,CONCATENATE(\"Por favor cumplimenta: \",CB2,CB3,CB5,CB6,CB11,\"y vuelve a pulsar sobre REGISTRAR PEDIDO.\"),IF(OR(CC7=1,CC8=1), IF(CC9=1,\"Por favor cumplimenta o el fabricante y su ferencia o la información adicional, y vuelve a pulsar sobre REGISTRAR PEDIDO\",\"\"),\"\")))","v":"Por favor, escibe o elige accesorio del desplegable"},null,null,null,null,null,null,"TodasREF"]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I5=\"\",\"\",\"ÁREA 01\")","v":""},{"$f":"IFERROR(IF(VLOOKUP('REGISTRO DE ACCESORIO'!B18,Tabla9[[#All],[REFERENCIA]:[ESTADO]],2,FALSE)=\"ACTIVO\",'REGISTRO DE ACCESORIO'!B18,\"\"),\"\")","v":""},"Trimestral",90,"Si",null,"ACTIVO","SI","GRILLETE",null,"GRIL","Semestral",182,null,"UNE-EN 13889",{"$error":"#N/A"},null,null,null,"Poliester - PE",null,"Ojal y Metálico",null,"Textil",80,1,null,null,null,null,null,null,null,null,"DEFECTUOSO O ROTO",null,"SI",null,null,null,null,"Grillete recto pasador w","Cáncamo macho fijo","Eslinga de cadena 4mm","Eslinga de cable 8mm","Eslinga textil plana",null,null,null,"Electroimán",null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=\"\",\"Por favor, selecciona un accesorio del desplegable.\",\"\")","v":"Por favor, selecciona un accesorio del desplegable."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"INFORMACIÓN!$E$13\")=\"\",\"Marcado CE, \",\"\")","v":"Marcado CE, "},{"$f":"IF(BQ2=\"\",0,1)","v":1},null,{"$f":"IF(INDIRECT(\"'AVISO REVISIÓN'!E12\")=\"\",\"la fecha de compra, \",\"\")","v":"la fecha de compra, "},{"$f":"IF(BT2=\"\",0,1)","v":1},null,null,null,null,null,null,{"$f":"IF(PEDIDOS!C12=\"\",\"destinatario, \",\"\")","v":"destinatario, "},{"$f":"IF(CB2=\"\",0,1)","v":1},null,null,null,null,null,{"$f":"'REGISTRO DE ACCESORIO'!B18","v":0}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I6=\"\",\"\",\"ÁREA 02\")","v":""},null,"Semestral",182,"No",null,"BAJA","NO","CÁNCAMO_Y_ANILLA",null,"CANC","Anual",365,null,"UNE-EN 3266","01GRIL2","Grillete recto pasador w",null,null,"Poliamida - PA",null,"Metalico",null,"Acero",100,2,null,null,null,null,null,null,null,null,"PÉRDIDA",null,"NO",null,null,null,null,"Grillete recto pasador X","Cáncamo macho giratorio","Eslinga de cadena 5mm","Eslinga de cable 9mm","Eslinga textil tubular",null,null,null,"Imán manual",null,null,null,null,null,{"$f":"IF(AND('REGISTRO DE ACCESORIO'!I5=\"\",'REGISTRO DE ACCESORIO'!I6=\"\",'REGISTRO DE ACCESORIO'!I7=\"\",'REGISTRO DE ACCESORIO'!I8=\"\",'REGISTRO DE ACCESORIO'!I9=\"\",'REGISTRO DE ACCESORIO'!I10=\"\",'REGISTRO DE ACCESORIO'!I11=\"\",'REGISTRO DE ACCESORIO'!I12=\"\",'REGISTRO DE ACCESORIO'!L5=\"\",'REGISTRO DE ACCESORIO'!L6=\"\",'REGISTRO DE ACCESORIO'!L7=\"\",'REGISTRO DE ACCESORIO'!L8=\"\",'REGISTRO DE ACCESORIO'!L9=\"\",'REGISTRO DE ACCESORIO'!L10=\"\",'REGISTRO DE ACCESORIO'!L11=\"\",'REGISTRO DE ACCESORIO'!L12=\"\"),\"las áreas de la empresa, \",\"\")","v":"las áreas de la empresa, "},{"$f":"IF(BD3=\"\",\"\",1)","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(\"INFORMACIÓN!F13\")=\"\",\"Declaración CE de Conformidad, \",\"\")","v":"Declaración CE de Conformidad, "},{"$f":"IF(BQ3=\"\",0,1)","v":1},null,{"$f":"IF(INDIRECT(\"'AVISO REVISIÓN'!F12\")=\"\",\"la fecha de puesta en servicio, \",\"\")","v":"la fecha de puesta en servicio, "},{"$f":"IF(BT3=\"\",0,1)","v":1},null,{"$f":"IF('BAJA INVENTARIO'!F15=\"\",\"Motivo de dar de baja en el inventario, \",\"\")","v":"Motivo de dar de baja en el inventario, "},{"$f":"IF(BW3=\"\",0,1)","v":1},null,null,null,{"$f":"IF(PEDIDOS!D12=\"\",\"dirección de correo electrónico, \",\"\")","v":"dirección de correo electrónico, "},1]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I7=\"\",\"\",\"ÁREA 03\")","v":""},null,"Anual",365,null,null,null,null,"ESLINGA_DE_CADENA",null,"ECAD","Anual",null,null,"UNE-EN 818","01GRIL1","Grillete recto pasador X",null,null,"Polipropileno - PP",null,"Ojal",null,null,120,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grillete lira pasador w","Cáncamo hembra fijo","Eslinga de cadena 6mm","Eslinga de cable 10mm","Eslinga textil sin fin tubular",null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=\"\",\"\",IF('REGISTRO DE ACCESORIO'!F15=\"\",\"la CMU, \",\"\"))","v":""},{"$f":"IF(BD4=\"\",\"\",1)","v":""},"ACCESORIO","TIPOLOGÍA","CMU kg","LONGITUD\n(MEDIDA)","MATERIAL","TERMINAL","ALMA","GRADO","Nº DE RAMALES","UBICACIÓN",null,{"$f":"IF(INDIRECT(\"INFORMACIÓN!G13\")=\"\",\"Manual de Instrucciones, \",\"\")","v":"Manual de Instrucciones, "},{"$f":"IF(BQ4=\"\",0,1)","v":1},null,{"$f":"IF(OR(INDIRECT(\"'AVISO REVISIÓN'!D12\")=I7,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I8,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I9,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I10,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I11,INDIRECT(\"'AVISO REVISIÓN'!D12\")=I12),IF(INDIRECT(\"'AVISO REVISIÓN'!I12\")=\"\",\"la revisión en meses, \",\"\"),\"\")","v":""},{"$f":"IF(BT4=\"\",0,1)","v":0},null,{"$f":"IF('BAJA INVENTARIO'!G15=\"\",\"fecha de la baja en el inventario, \",\"\")","v":"fecha de la baja en el inventario, "},{"$f":"IF(BW4=\"\",0,1)","v":1},null,null,null,{"$f":"IF(PEDIDOS!B17=\"\",\"Por favor, selecciona un accesorio del desplegable.\",\"\")","v":"Por favor, selecciona un accesorio del desplegable."},{"$f":"IF(CB4=\"\",0,1)","v":1}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I8=\"\",\"\",\"ÁREA 04\")","v":""},null,null,null,null,null,null,null,"ESLINGA_DE_CABLE",null,"ECAB","Anual",null,null,"UNE-EN 13414",null,"Grillete lira pasador w",null,null,null,null,"Sin Fin",null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grillete lira pasador X","Cáncamo hembra giratorio","Eslinga de cadena 7mm","Eslinga de cable 11mm","Eslinga textil sin fin plana",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('REGISTRO DE ACCESORIO'!D15=BF5,'REGISTRO DE ACCESORIO'!D15=BF6,'REGISTRO DE ACCESORIO'!D15=BF7,'REGISTRO DE ACCESORIO'!D15=BF8,'REGISTRO DE ACCESORIO'!D15=BF9,'REGISTRO DE ACCESORIO'!D15=BF13),IF('REGISTRO DE ACCESORIO'!E15=\"\",\"la tipología, \",\"\"),\"\")","v":""},{"$f":"IF(BD5=\"\",\"\",1)","v":""},"GRILLETE","X","X",null,null,null,null,null,null,"X",null,null,{"$f":"SUM(BR2:BR4)","v":3},null,{"$f":"IF(INDIRECT(\"'AVISO REVISIÓN'!M12\")=\"\",\"la persona responsable de la revisión, \",\"\")","v":"la persona responsable de la revisión, "},{"$f":"IF(BT5=\"\",0,1)","v":1},null,null,{"$f":"SUM(BX3:BX4)","v":2},null,null,null,{"$f":"IF(OR(PEDIDOS!B17=DATOS!AU1,PEDIDOS!B17=DATOS!AV1,PEDIDOS!B17=DATOS!AW1,PEDIDOS!B17=DATOS!AY1,PEDIDOS!B17=DATOS!AZ1,PEDIDOS!B17=DATOS!BA1),\"\",IF(PEDIDOS!C17=\"\",\"la tipología del accesorio, \",\"\"))","v":"la tipología del accesorio, "},{"$f":"IF(CB5=\"\",0,1)","v":1},{"$f":"IF(PEDIDOS!C17=\"\",\"\",CONCATENATE(\" de tipología: \",PEDIDOS!C17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I9=\"\",\"\",\"ÁREA 05\")","v":""},null,null,null,null,null,null,null,"ESLINGA_TEXTIL",null,"ETEX","Anual",0,null,"UNE-EN 1492",null,"Grillete lira pasador X",null,null,null,null,null,null,null,null,"Sin fin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 8mm","Eslinga de cable 12mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('REGISTRO DE ACCESORIO'!D15=BF7,'REGISTRO DE ACCESORIO'!D15=BF8,'REGISTRO DE ACCESORIO'!D15=BF9,'REGISTRO DE ACCESORIO'!D15=BF10),IF('REGISTRO DE ACCESORIO'!G15=\"\",\"la longitud, \",\"\"),\"\")","v":""},"","CÁNCAMO_Y_ANILLA","X","X",null,null,null,null,null,null,"X",null,null,null,null,{"$f":"IF(INDIRECT(\"'AVISO REVISIÓN'!N12\")=\"\",\"dirección de correo electrónico del presonsable de la revisión, \",\"\")","v":"dirección de correo electrónico del presonsable de la revisión, "},{"$f":"IF(BT6=\"\",0,1)","v":1},null,null,null,null,null,null,{"$f":"IF(PEDIDOS!D17=\"\",\"el proveedor, \",\"\")","v":"el proveedor, "},{"$f":"IF(CB6=\"\",0,1)","v":1},{"$f":"IF(PEDIDOS!D17=\"\",\"\",CONCATENATE(\" del proveedor: \",PEDIDOS!D17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I10=\"\",\"\",\"ÁREA 06\")","v":""},null,null,null,null,null,null,null,"VIGA DE SUSPENSIÓN",null,"VSUS","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 4mm",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,"Eslinga de cadena 10mm","Eslinga de cable 13mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=BF9,IF('REGISTRO DE ACCESORIO'!H15=\"\",\"el material, \",\"\"),\"\")","v":""},"","ESLINGA_DE_CADENA","X","X","X",null,null,null,"X","X","X",null,null,null,null,null,{"$f":"SUM(BU2:BU6)","v":4},null,null,null,null,null,null,{"$f":"IF(PEDIDOS!E17=\"\",\"el fabricante, \",\"\")","v":"el fabricante, "},1,{"$f":"IF(PEDIDOS!E17=\"\",\"\",CONCATENATE(\" del fabricante : \",PEDIDOS!E17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I11=\"\",\"\",\"ÁREA 07\")","v":""},null,null,null,null,null,null,null,"PINZA_DE_ELEVACIÓN",null,"PELE","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 5mm",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,"Eslinga de cadena 13mm","Eslinga de cable 14mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('REGISTRO DE ACCESORIO'!D15=BF9,OR('REGISTRO DE ACCESORIO'!E15=\"Eslinga textil plana\",'REGISTRO DE ACCESORIO'!E15=\"Eslinga textil tubular\")),IF('REGISTRO DE ACCESORIO'!I15=\"\",\"el terminal, \",\"\"),\"\")","v":""},"","ESLINGA_DE_CABLE","X","X","X",null,null,"X",null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PEDIDOS!F17=\"\",\"la referencia del fabricante, \",\"\")","v":"la referencia del fabricante, "},1,{"$f":"IF(PEDIDOS!F17=\"\",\"\",CONCATENATE(\" con referencia: \",PEDIDOS!F17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!I12=\"\",\"\",\"ÁREA 08\")","v":""},null,null,null,null,null,null,null,"GANCHO C",null,"GANC","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 6mm",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,"Eslinga de cadena 16mm","Eslinga de cable 16mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=BF8,IF('REGISTRO DE ACCESORIO'!J15=\"\",\"el alma, \",\"\"),\"\")","v":""},"","ESLINGA_TEXTIL","X","X","X","X","X",null,null,"X","X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PEDIDOS!G17=\"\",\"información adicional, \",\"\")","v":"información adicional, "},1,{"$f":"IF(PEDIDOS!G17=\"\",\"\",CONCATENATE(\" y con la información adicional: \",PEDIDOS!G17,\",\"))","v":""}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L5=\"\",\"\",\"ÁREA 09\")","v":""},null,null,null,null,null,null,null,"IMÁN",null,"IMAN","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 7mm",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,"Eslinga de cadena 18mm","Eslinga de cable 18mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=BF7,IF('REGISTRO DE ACCESORIO'!K15=\"\",\"el grado, \",\"\"),\"\")","v":""},"","VIGA DE SUSPENSIÓN",null,"X","X",null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CC2:CC3,CC5:CC6)","v":4}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L6=\"\",\"\",\"ÁREA 10\")","v":""},null,null,null,null,null,null,null,"VENTOSA DE VACÍO",null,"VVAC","Según fabricante",null,null,"UNE-EN 13155",null,"Eslinga de cadena 8mm",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,"Eslinga de cadena 19mm","Eslinga de cable 20mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('REGISTRO DE ACCESORIO'!D15=BF7,'REGISTRO DE ACCESORIO'!D15=BF8,AND('REGISTRO DE ACCESORIO'!D15=BF9,OR('REGISTRO DE ACCESORIO'!E15=\"Eslinga textil plana\",'REGISTRO DE ACCESORIO'!E15=\"Eslinga textil tubular\"))),IF('REGISTRO DE ACCESORIO'!L15=\"\",\"el número de ramales, \",\"\"),\"\")","v":""},"","PINZA DE ELEVACIÓN",null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CC11>0,\"el fabricante, su referencia o la información adicional \",\"\")","v":"el fabricante, su referencia o la información adicional "},{"$f":"SUM(CC7:CC9)","v":3}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L7=\"\",\"\",\"ÁREA 11\")","v":""},null,null,null,null,null,null,null,"FABRICACIÓN PROPIA ",null,"FPIA","Según fabricante",null,null,null,null,"Eslinga de cadena 10mm",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,"Eslinga de cadena 20mm","Eslinga de cable 22mm",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('REGISTRO DE ACCESORIO'!D15=\"\",\"\",IF(OR('REGISTRO DE ACCESORIO'!M15=\"\",'REGISTRO DE ACCESORIO'!M15=\"Elige ubicación\"),\"la ubicación del accesorio, \",\"\"))","v":""},"","GANCHO C",null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,"CUERPO DEL CORREO"]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L8=\"\",\"\",\"ÁREA 12\")","v":""},null,null,null,null,null,null,null,"OTRO",null,"OTRO","Según fabricante",null,null,null,null,"Eslinga de cadena 13mm",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,"Eslinga de cadena 22mm","Eslinga de cable 24mm",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BE3:BE12)","v":1},"IMÁN","X","X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Estimado/a \",PEDIDOS!C12)","v":"Estimado/a "}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L9=\"\",\"\",\"ÁREA 13\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 16mm",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,"Eslinga de cadena 23mm","Eslinga de cable 26mm",null,null,null,null,null,null,null,null,null,null,null,null,"VENTOSA DE VACÍO",null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Necesitamos adquirir el siguiente accesorio de elevación: \",PEDIDOS!B17,\",\",CD5,CD6,CD7,CD8,CD9,\" lo antes posible.\")","v":"Necesitamos adquirir el siguiente accesorio de elevación: , lo antes posible."}]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L10=\"\",\"\",\"ÁREA 14\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MID(Q3,1,2)","v":"Gr"},null,null,null,"Eslinga de cadena 18mm",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,"Eslinga de cadena 25mm","Eslinga de cable 28mm",null,null,null,null,null,null,null,null,null,null,null,null,"FABRICACIÓN PROPIA ",null,"X",null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,"Si hubiera algún problema, por favor hágamelo saber."]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L11=\"\",\"\",\"ÁREA 15\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 19mm",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,"Eslinga de cadena 26mm","Eslinga de cable 32mm",null,null,null,null,null,null,null,null,null,null,null,null,"OTRO",null,"X",null,null,null,null,null,null,"X"]
[{"$f":"IF('REGISTRO DE ACCESORIO'!L12=\"\",\"\",\"ÁREA 16\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 20mm",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,"Eslinga de cadena 28mm","Eslinga de cable 36mm",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,"ERROR DE CORREO DE DESTINATARIOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 22mm",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,"Eslinga de cadena 32mm","Eslinga de cable 40mm",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,{"$f":"IFERROR(SEARCH(\"@\",PEDIDOS!D12,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 23mm",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,"Eslinga de cadena 36mm","Eslinga de cable 44mm",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,{"$f":"IFERROR(SEARCH(\"@\",PEDIDOS!D13,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 25mm",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,"Eslinga de cadena 40mm","Eslinga de cable 48mm",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,{"$f":"IFERROR(SEARCH(\"@\",PEDIDOS!D14,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 26mm",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,"Eslinga de cadena 45mm","Eslinga de cable 52mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 28mm",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,"Eslinga de cable 56mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 32mm",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,"Eslinga de cable 60mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 36mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 40mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cadena 45mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 8mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 9mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 10mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 11mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 12mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 13mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 14mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 16mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 18mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 20mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 22mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 24mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 26mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 28mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 32mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 36mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 40mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 44mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 48mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 52mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 56mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga de cable 60mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cáncamo macho fijo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cáncamo macho giratorio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cáncamo hembra fijo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cáncamo hembra giratorio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga textil plana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga textil tubular"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga textil sin fin tubular"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eslinga textil sin fin plana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electroimán"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Imán manual"]

{"sheet":"REFERENCIAS","index":10,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Escribe o Elige",null,"Escribe o Elige"]
["01OTRO1",null,""]
["01FPIA1",null,""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]