{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Resumen PIFE","Hoja1","Usuarios"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Resumen PIFE","index":0,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[[26,6,26,10],[26,0,26,2],[1,0,1,9],[11,0,11,7],[22,0,22,2],[22,3,22,6],[26,3,26,5],[7,1,7,7],[9,1,9,7],[8,0,8,7],[6,0,6,7],[30,0,30,15],[40,9,40,13],[32,0,32,2],[32,3,32,6],[32,7,32,11],[36,0,36,4],[40,0,40,1],[36,5,36,10],[36,11,36,15],[40,2,40,7]]}
[]
["PIFES 2025 - RESUMEN - MEMORIA - PRESUPUESTO"]
[]
["ENTIDAD SOLICITANTE ",null,"CIF",null,"Nº CENSO ENTIDAD SOLICITANTE",null,"Nª CENSO ENTIDAD IMPARTICIÓN",null,null,"A RELLENAR POR LA ENTIDAD",null,null,null,"PRESENCIAL",1]
["LOCALIDAD IMPARTICIÓN",null,"TIPO/ZONA PIFE",null,"FAMILIA PROFESIONAL",null,{"$f":"+IF(H5<=15,\"Nº PARTICIPANTES\", \"NÚMERO MÁXIMO 15 PARTICIPANTES\")","v":"Nº PARTICIPANTES"},null,null,"CAMPOS CALCULADOS O COMPLETADOS POR EL SNE-NL",null,"TELEFORMACIÓN",2]
["MÓDULO ECONÓMICO MEDIO FORMACIÓN",{"$f":"+IF(OR(H5=\"\",F21=\"\"),\"\",H21/F21/H5)","v":""},"TOTAL SUBVENCIÓN SOLICITADA",{"$f":"+H21+C25+G25+C29+F29+K29","v":0},"PUNTUACIÓN",{"$f":"+SUM(C35+G35+L35+E39+K39+P39+B43+D43+H43)-N43","v":0},"¿ESTÁ DE ACUERDO CON LA PUNTUACIÓN?",null,{"$f":"+IF(OR(D4=\"\",H6=\"\"),\"MARQUE SI ESTÁ DE ACUERDO CON LA PUNTUACIÓN OBTENIDA\",\"\")","v":"MARQUE SI ESTÁ DE ACUERDO CON LA PUNTUACIÓN OBTENIDA"},"POSIBLE ERROR",null,"MIXTA",3]
[{"$f":"+IF(B8=\"\",\"ESCRIBA LA DENOMINACIÓN DEL PROGRAMA INTEGRADO DE FORMACIÓN Y EMPLEO (PIFE)\",\"\")","v":"ESCRIBA LA DENOMINACIÓN DEL PROGRAMA INTEGRADO DE FORMACIÓN Y EMPLEO (PIFE)"}]
["DENOMINACIÓN PIFE "]
[{"$f":"+IF(B10=\"\",\"DEFINA EL PERFIL PROFESIONAL AL QUE SE PRETENDE FORMAR CON ESTE PIFE\",\"\")","v":"DEFINA EL PERFIL PROFESIONAL AL QUE SE PRETENDE FORMAR CON ESTE PIFE"}]
["DESCRIPCIÓN PIFE"]
[]
["FORMACIÓN TÉCNICA"]
["CÓDIGO ESPECIALIDAD","DENOMINACIÓN ESPECIALIDAD","CÓDIGO MÓDULO","DENOMINACIÓN MÓDULO","FAMILIA PROFESIONAL","HORAS","MÓDULO","COSTE"]
[null,null,null,null,{"$f":"LEFT(A14,3)","v":""},300,{"$f":"IFERROR(IF(A14=\"\",\"\",VLOOKUP(E14,Hoja1!$E$4:$F$29,2,FALSE)),\"Revisar código especialidad\")","v":""},{"$f":"IFERROR(IF(G14=\"\",\"\",G14*F14*$H$5),\"\")","v":""}]
[null,null,null,null,"",null,{"$f":"IFERROR(IF(A15=\"\",\"\",VLOOKUP(E15,Hoja1!$E$4:$F$29,2,FALSE)),\"Revisar código especialidad\")","v":""},{"$f":"IFERROR(IF(G15=\"\",\"\",G15*F15*$H$5),\"\")","v":""}]
[null,null,null,null,"",null,{"$f":"IFERROR(IF(A16=\"\",\"\",VLOOKUP(E16,Hoja1!$E$4:$F$29,2,FALSE)),\"Revisar código especialidad\")","v":""},""]
[null,null,null,null,"",null,{"$f":"IFERROR(IF(A17=\"\",\"\",VLOOKUP(E17,Hoja1!$E$4:$F$29,2,FALSE)),\"Revisar código especialidad\")","v":""},""]
[null,null,null,null,"",null,{"$f":"IFERROR(IF(A18=\"\",\"\",VLOOKUP(E18,Hoja1!$E$4:$F$29,2,FALSE)),\"Revisar código especialidad\")","v":""},""]
[null,null,null,null,"",null,{"$f":"IFERROR(IF(A19=\"\",\"\",VLOOKUP(E19,Hoja1!$E$4:$F$29,2,FALSE)),\"Revisar código especialidad\")","v":""},""]
[null,null,null,null,"",null,{"$f":"IFERROR(IF(A20=\"\",\"\",VLOOKUP(E20,Hoja1!$E$4:$F$29,2,FALSE)),\"Revisar código especialidad\")","v":""},""]
[null,null,null,{"$f":"+IF(OR(H5=\"\",F21=\"\"),\"\",IF(AND(D5=Hoja1!C17,F21>360),\"MÁXIMO 360 HORAS\",IF(AND(D5<>Hoja1!C17,F21>300),\"MÁXIMO 300 HORAS\",\"\")))","v":""},"HORAS FORMACIÓN TÉCNICA",{"$f":"IF(F14=\"\",\"\",SUM(F14:F20))","v":300},"SUBVENCIÓN SOLICITADA",{"$f":"IF(H5=\"\",0,SUM(H14:H20))","v":0}]
[]
["FORMACIÓN EN TRANSFORMACIÓN DIGITAL, SOSTENIBILIDAD E IGUALDAD",null,null,"DESARROLLO DE COMPETENCIAS TRANSVERSALES"]
["PRECIO HORA","HORAS ","SUBVENCIÓN SOLICITADA","PRECIO HORA PRESENCIAL","HORAS MÁXIMAS GRUPO","HORAS SOLICITADAS GRUPO","SUBVENCIÓN SOLICITADA"]
[{"$f":"IF(OR(H5=\"\",B6=\"\"),0,B6)","v":0},{"$f":"+IF(H5=\"\",\"\",IF(F21<100,5,IF(F21>=100,10)))","v":""},{"$f":"+IF(H5=\"\",0,B25*H5*A25)","v":0},{"$f":"+Hoja1!F28","v":9.8800000000000008},{"$f":"+IF(F21=\"\",\"\",IF(F21<100,16*H5,IF(AND(F21>=100,F21<=200),32*H5,IF(F21>200,40*H5))))","v":0},null,{"$f":"+IF(H5=\"\",0,F25*D25)","v":0}]
[null,null,null,null,null,{"$f":"+IF(H5=\"\",\"\",IF(F25>E25,\"SUPERADO HORAS MÁXIMAS\",\"\"))","v":""}]
["GESTIÓN INSERCIÓN Y CONTRATOS",null,null,"EMPLEO",null,null,"ACOMPAÑAMIENTO"]
["PRECIO HORA","HORAS SOLICITADAS PARTICIPANTE","SUBVENCIÓN SOLICITADA","SUBVENCIÓN MÁXIMA GRUPO","SUBVENCIÓN SOLICITADA GRUPO","SUBVENCIÓN SOLICITADA","PRECIO HORA","HORAS MÁXIMAS GRUPO/MES","HORAS SOLICITADAS GRUPO/MES","TOTAL MESES","SUBVENCIÓN  SOLICITADA"]
[22,null,{"$f":"+IF(H5=\"\",0,A29*B29*H5)","v":0},{"$f":"+IF(H5=\"\",\"\",H5*4500)","v":""},null,{"$f":"+IF(H5=\"\",0,E29)","v":0},22,{"$f":"+IF(H5=\"\",\"\",H5*5)","v":""},null,{"$f":"IF(H5=\"\",\"\",IF(F21=\"\",\"\",(F21+B25+(F25/H5))/100)+3)","v":""},{"$f":"IF(OR(H5=\"\",I29=\"\",0),,G29*I29*J29)","v":0}]
[null,{"$f":"+IF(B29=\"\",\"\",IF(OR(B29<1,B29>6),\"ENTRE 1 Y 6 HORAS\",\"\"))","v":""},null,null,{"$f":"IF(E29>D29,\"SUPERADA SUBVENCIÓN MÁXIMA\",\"\")","v":""},null,null,null,{"$f":"+IF(H5=\"\",\"\",IF(I29>H29,\"SUPERADO HORAS MÁXIMAS\",\"\"))","v":""}]
["VALORACIÓN (HASTA 130 PUNTOS)"]
[]
["A) PUNTUACIÓN OBTENIDA EN LAS ENCUESTAS DEL SERVICIO NAVARRO DE EMPLEO-NAFAR LANSARE (15)",null,null,"B) SOLVENCIA FINANCIERA (10)",null,null,null,"C) ÍNDICE DE INSERCIÓN LABORAL (15)"]
["CENTRO NUEVO","PUNTUACIÓN ENCUESTAS","PUNTOS","VOLUMEN NEGOCIO","SUBVENCIONES","%","PUNTOS","CENTRO NUEVO","ALUMNADO 75%","ALUMNADO INSERTADO","ÍNDICE INSERCIÓN","PUNTOS"]
[{"$f":"IFERROR(IF($D$4=\"\",\"\",VLOOKUP($D$4,Hoja1!$I$4:'Hoja1'!$K$19,3,FALSE)),\"SÍ\")","v":""},{"$f":"IFERROR(IF(A35=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$J$18,2,FALSE)),Hoja1!J19)","v":""},{"$f":"IF(A35=\"\",0,IF(A35=\"SÍ\",Hoja1!J22,IF(AND(A35=\"NO\",B35>=3,B35<=4),(B35-3)*15,IF(AND(A35=\"NO\",B35<3),0,IF(AND(A35=\"NO\",B35>4),15)))))","v":0},null,null,{"$f":"IF(OR(D35=\"\",D35=0),\"\",+E35/D35)","v":""},{"$f":"+IF(F35>50%,0,IF(F35=50%,1,IF(AND(F35<50%,F35>=10%),((((50%-F35)*0.225))*100)+1,IF(F35<10%,10))))","v":0},{"$f":"IFERROR(IF($D$4=\"\",\"\",VLOOKUP($D$4,Hoja1!$I$4:'Hoja1'!$K$19,3,FALSE)),\"SÍ\")","v":""},{"$f":"IFERROR(IF(H35=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$T$18,4,FALSE)),Hoja1!L19)","v":""},{"$f":"IFERROR(IF(H35=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$T$18,5,FALSE)),Hoja1!M19)","v":""},{"$f":"IF(H35=\"\",\"\",IF(H35=\"SÍ\",0%,IF(AND(H35=\"NO\",I35=\"\"),0,IF(AND(H35=\"NO\",J35/I35<=100%),J35/I35,IF(AND(H35=\"NO\",J35/I35>100%),100%)))))","v":""},{"$f":"+IF(K35=\"\",0,IF(AND(H35=\"SÍ\",K35=0%),Hoja1!M23,IF(K35<10%,0,IF(K35=10%,2,IF(AND(K35>10%,K35<=90%),((((K35-10%)*13/80))*100)+2,IF(K35>90%,15))))))","v":0}]
[]
["D) CONTRATOS DE FORMACIÓN EN ALTERNANCIA (20)",null,null,null,null,"E) IGUALDAD (5)",null,null,null,null,null,"F) EFICACIA EN LA GESTIÓN DE LA SUBVENCIÓN (5)"]
["CENTRO NUEVO","PERSONAS CONCEDIDAS POR TRES MESES","MESES CONTRATOS FORMACIÓN EN ALTERNANCIA","PORCENTAJE","PUNTOS","CENTRO NUEVO","PLAN DE IGUALDAD VERIFICADO","¿TIENE OBLIGACIÓN PLAN DE IGUALDAD?","PLAN DE IGUALDAD REGISTRADO","CERTIFICADO IGUALDAD","PUNTOS","CENTRO NUEVO"," SUBVENCIÓN CONCEDIDA","SUBVENCIÓN  ABONADA","% EJECUCIÓN","PUNTOS"]
[{"$f":"IFERROR(IF($D$4=\"\",\"\",VLOOKUP($D$4,Hoja1!$I$4:'Hoja1'!$K$19,3,FALSE)),\"SÍ\")","v":""},{"$f":"IFERROR(IF(A39=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$P$18,7,FALSE)),Hoja1!N19)","v":""},{"$f":"IFERROR(IF(A39=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$P$18,8,FALSE)),Hoja1!P19)","v":""},{"$f":"IF(A39=\"\",\"\",IF(A39=\"SÍ\",0%,C39/B39))","v":""},{"$f":"+IF(D39=\"\",0,IF(AND(A39=\"SÍ\",D39=0%),Hoja1!P23,IF(D39=0,0,IF(D39<10%,0,IF(D39=10%,1,IF(AND(D39>=10%,D39<=90%),((((D39-10%)*19/80))*100)+1,IF(D39>90%,20)))))))","v":0},{"$f":"IFERROR(IF($D$4=\"\",\"\",VLOOKUP($D$4,Hoja1!$I$4:'Hoja1'!$K$19,3,FALSE)),\"SÍ\")","v":""},{"$f":"IFERROR(IF(D4=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$U$18,13,FALSE)),\"\")","v":""},null,null,null,{"$f":"IF(AND(G39=\"\",I39=\"\",J39=\"\"),0,IF(AND(H39=\"NO\",G39=\"SÍ\"),5,IF(AND(H39=\"NO\",I39=\"SÍ\"),5,IF(AND(H39=\"SÍ\",G39=\"SÍ\",J39=\"SÍ\"),5,IF(AND(H39=\"SÍ\",I39=\"SÍ\",J39=\"SÍ\"),5,0)))))","v":0},{"$f":"IFERROR(IF($D$4=\"\",\"\",VLOOKUP($D$4,Hoja1!$I$4:'Hoja1'!$K$19,3,FALSE)),\"SÍ\")","v":""},{"$f":"IFERROR(IF(L39=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$Q$18,9,FALSE)),0)","v":""},{"$f":"IFERROR(IF(L39=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$R$18,10,FALSE)),0)","v":""},{"$f":"IF(L39=\"\",\"\",IF(L39=\"SÍ\",0%,N39/M39))","v":""},{"$f":"+IF(O39=\"\",0,IF(O39>=90%,5,0))","v":0}]
[]
["G) COMPROMISO DE CONTRATACIÓN ADICIONAL (20)",null,"H) CONTRATACIÓN A JORNADA COMPLETA Y POR TIEMPO INDEFINIDO O CONVERSIÓN DE LA CONTRATACIÓN TEMPORAL EN CONTRATACIÓN A JORNADA COMPLETA Y POR TIEMPO INDEFINIDO (40)",null,null,null,null,null,null,"INEJECUCIÓN (-10 puntos)"]
["NÚMERO","PUNTOS","MUJERES FAMILIAS INFRARREPRESENTADAS","PUNTOS","HOMBRES","MUJERES","PUNTOS","TOTAL PUNTOS",null,"CENTRO NUEVO","HORAS CONCEDIDAS","HORAS EJECUTADAS","% INEJECUCIÓN","PUNTOS A DESCONTAR"]
[null,{"$f":"+IF(A43*4>20,20,A43*4)","v":0},null,{"$f":"+IF(OR(F5=Hoja1!A6,F5=Hoja1!A10,F5=Hoja1!A11,F5=Hoja1!A12,F5=Hoja1!A13,F5=Hoja1!A18,F5=Hoja1!A20,F5=Hoja1!A21,F5=Hoja1!A28),C43*5,0)","v":0},null,null,{"$f":"+IF(D43=0,SUM(E43*2,F43*10/3),E43*2)","v":0},{"$f":"+IF(SUM(D43,G43)>40,40,SUM(D43,G43))","v":0},null,{"$f":"IFERROR(IF($D$4=\"\",\"\",VLOOKUP($D$4,Hoja1!$I$4:'Hoja1'!$K$19,3,FALSE)),\"SÍ\")","v":""},{"$f":"IFERROR(IF(J43=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$T$18,11,FALSE)),Hoja1!S19)","v":""},{"$f":"IFERROR(IF(K43=\"\",\"\",VLOOKUP(D4,Hoja1!$I$4:$T$18,12,FALSE)),Hoja1!T19)","v":""},{"$f":"+IF(J43=\"\",\"\",IF(J43=\"SÍ\",0%,IF(AND(J43=\"NO\",L43=0),0%,IF(AND(J43=\"NO\",L43>0),100%-(L43/K43)))))","v":""},{"$f":"+IF(M43=\"\",0,IF(M43<=10%,0,((M43-10%)*10/90)*100))","v":0}]
[null,null,{"$f":"+IF(C43=\"\",\"\",IF(AND(C43>0,D43=0),\"NO ES OCUPACIÓN EN FAMILIA INFRARREPRESENTADA\",\"\"))","v":""}]

{"sheet":"Hoja1","index":1,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"X",null,null,null,null,null,null,"ENCUESTAS","CENTRO NUEVO","PERSONAS 75%","PERSONAS INSERTADAS","PERSONAS CONCEDIDAS","PERSONAS CONCEDIDAD POR TRES","CONTRATOS ALTERNANCIA","SUBVENCIÓN CONCEDIDA","SUBVENCIÓN ABONADA","HORAS CONCEDIDAS","HORAS EJECUTADAS","PLAN DE IGUALDAD"]
["ACTIVIDADES FÍSICAS Y DEPORTIVAS (AFD)",null,"Sin especificar","Actividades Físicas y Deportivas","AFD",10.85,null,"ACCIÓN LABORAL","V09409749",3.47,"NO",21,10,23,{"$f":"+N4*3","v":69},46.49,167475.23000000001,138262.12,520,520,"SÍ"]
["ADMINISTRACIÓN Y GESTIÓN (ADG)",null,1,"Administración y Gestión","ADG",9.8800000000000008,null,"ÁCTIMA CONSULTORÍA DE RECURSOS HUMANOS, S.L.  ","B31816689",3.7,"NO",12,8,13,{"$f":"+N5*3","v":39},39,90912.042000000001,90912.042000000001,200,200,"Lea la etiqueta referente a plan de igualdad registrado ."]
["AGRARIA (AGR)",null,2,"Agraria","AGA",12.6,null,"AGEFOR FORMACIÓN","B71448724",3.87,"NO",40,14,44,132,82.98,317319.45,266844.77,737,737,"Lea la etiqueta referente a plan de igualdad registrado ."]
["ARTES GRÁFICAS (ARG)",null,3,"Arte y Artesanías ","ART",11.8,null,"ASPACE","G31077050",3.99,"NO",9,4,10,30,28.69,82018.3,80431.340500000006,290,290,"Lea la etiqueta referente a plan de igualdad registrado ."]
["ARTE Y ARTESANÍAS (ART)",null,4,"Artes Gráficas","ARG",11.8,null,"ANTRV","G31084635",3.94,"NO",12,9,11,33,28.74,87070.2,83817.513400000011,339,339,"SÍ"]
["COMERCIO Y MARKETING (COM)",null,"NO ZONAL","Comercio y Marketing","COM",9.89,null,"ASOCIACIÓN NAVARRA SOCIAL  ","G71357750",3.21,"NO",13,5,15,45,29.31,94172.160000000003,77777.588499999998,195,195,"Lea la etiqueta referente a plan de igualdad registrado ."]
["EDIFICACIÓN Y OBRA CIVIL (EOC)",null,"ALTSASU / ALSASUA","Edificación y Obra Civil","EOC",12.17,null,"ASOCIACION POSTHAC - ENTIDAD SOCIAL POR EL EMPLEO","G71329221",3.64,"NO",24,8,30,90,59.37,187327.17,149398.82,385,385,"Lea la etiqueta referente a plan de igualdad registrado ."]
["ELECTRICIDAD Y ELECTRÓNICA (ELE)",null,"AOIZ / AGOITZ","Electricidad y Electrónica","ELE",11,null,"FC FORMACIÓN CONTINUA, S.I.","E71070064",3.79,"NO",29,18,30,90,54.26,193367.19,155537.17000000001,396,396,"Lea la etiqueta referente a plan de igualdad registrado ."]
["ENERGÍA Y AGUA (ENA)",null,"DONEZTEBE / SANTESTEBAN","Energía y Agua","ENA",11.29,null,"FORMACIÓN SOCIAL NAVARRA, S.L. ","B71404834",2.89,"NO",15,6,15,{"$f":"+N12*3","v":45},24,102216.75,80258.48000000001,250,250,"Lea la etiqueta referente a plan de igualdad registrado ."]
["FABRICACIÓN MECÁNICA (FME)",null,"ESTELLA-LIZARRA","Fabricación Mecánica","FME",12.35,null,"FUNDACIÓN ELKARTE ","G31830417",3.63,"NO",10,5,10,30,24.67,79585.98,70640.671499999997,274,274,"SÍ"]
["HOSTELERÍA Y TURISMO (HOT)",null,"LODOSA","Hostelería y Turismo","HOT",12.02,null,"FUNDACIÓN KOINE AEQUALITAS","G83496000",3.25,"NO",26,8,30,90,70.89,206185.83,171450.21,449,449,"Lea la etiqueta referente a plan de igualdad registrado ."]
["IMAGEN PERSONAL (IMP)",null,"TAFALLA","Imagen Personal","IMP",12.77,null,"FUNDACIÓN LABORAL DE LA COSTRUCCIÓN ","G80468416",3.49,"NO",54,13,68,204,127.97,497914.79,391061.16,1230,1230,"SÍ"]
["IMAGEN Y SONIDO (IMS)",null,"TUDELA","Imagen y Sonido","IMS",12.35,null,"GABINETE DE RECOLOCACIÓN INDUSTRIAL, S.L.  ","B09390105",3.15,"NO",52,12,60,180,105.38,410689.77,321381.36,870,870,"SÍ"]
["INDUSTRIAS ALIMENTARIAS (INA)",null,"PERSONAS CON DISCAPACIDAD","Industrias Alimentarias","INA",13.5,null,"NAFORLAN NAVARRA DE FORMACIÓN Y EMPLEO, S.L. ","B71364194",3.68,"NO",14,4,15,45,30,97614.88,81356.460000000006,230,230,"Lea la etiqueta referente a plan de igualdad registrado ."]
["INDUSTRIAS EXTRACTIVAS (IEX)",null,null,"Industrias Extractivas","IEX",12.17,null,"RODOIA 2000, S.L.","B48933618",3.68,"NO",38,18,45,135,82.41,332856.15000000002,286211.55,835,835,"Lea la etiqueta referente a plan de igualdad registrado ."]
["INFORMÁTICA Y COMUNICACIONES (IFC)",null,null,"Informática y Comunicaciones","IFC",9.8800000000000008,null,"Media",null,0,"NO",0,0,0,0,0,null,null,0,0]
["INSTALACIÓN Y MANTENIMIENTO (IMA)",null,"SÍ","Instalación y Mantenimiento","IMA",11.49,null,null,"PUNTOS",null,null,{"$f":"+SUM(L4:L18)","v":369},142,{"$f":"+SUM(N4:N18)","v":419},{"$f":"+SUM(O4:O18)","v":1257},{"$f":"+SUM(P4:P18)","v":834.16}]
["MADERA, MUEBLE Y CORCHO (MAM)",null,"NO","Madera, Mueble y Corcho","MAM",12.17,null,null,3.54,null,null,{"$f":"+M20/L20","v":0.38482384823848237},null,null,{"$f":"+P20/O20","v":0.66361177406523464}]
["MARÍTIMO PESQUERA (MAP)",null,null,"Química","QUI",10.71,null,null,{"$f":"IF(AND(I21>=3,J21<=4),(I21-3)*15,IF(I21<3,0))","v":8.1000000000000014},{"$f":"+I22*0.75","v":6.0750000000000011},null,{"$f":"+L21","v":0.38482384823848237},{"$f":"+IF(I22=\"\",0,IF(AND(I22=\"SÍ\",L22=0%),Hoja1!N12,IF(L22<10%,0,IF(L22=10%,2,IF(AND(L22>10%,L22<=90%),((((L22-10%)*13/80))*100)+2,IF(L22>90%,15))))))","v":6.6283875338753386},null,{"$f":"+O21","v":0.66361177406523464},{"$f":"+IF(O22=\"\",0,IF(AND(L22=\"SÍ\",O22=0%),Hoja1!AA8,IF(O22=0,0,IF(O22<10%,0,IF(O22=10%,1,IF(AND(O22>=10%,O22<=90%),((((O22-10%)*19/80))*100)+1,IF(O22>90%,20)))))))","v":14.385779634049324}]
["QUÍMICA (QUI)",null,null,"Sanidad","SAN",11.97,null,null,null,null,null,0.75,{"$f":"+M22*0.75","v":4.9712906504065035},null,0.75,{"$f":"+P22*0.75","v":10.789334725536992}]
["SANIDAD (SAN)",null,null,"Seguridad y Medio Ambiente","SEA",10.71]
["SEGURIDAD Y MEDIO AMBIENTE (SEA)",null,null,"Servicios Cocioculturales y a la Comunidad","SSC",10.71]
["SERVICIOS SOCIOCULTURALES Y A LA COMUNIDAD (SSC)",null,null,"Textil, Confección y Piel","TCP",12.35]
["TÉXTIL, CONFECCIÓN Y PIEL (TCP)",null,null,"Transporte y Mantenimiento de Vehículos","TMV",12.47]
["TRANSPORTE Y MANTENIMIENTO DE VEHÍCULOS (TMV)",null,null,"Competencias transversales","CTR",9.8800000000000008]
["VIDRIO Y CERÁMICA (VIC)",null,null,"Formación complementaria","FCO",9.8800000000000008]

{"sheet":"Usuarios","index":2,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["DNI","CONTRASEÑA","CENTRO"]
["V09409749","10AF","ACCIÓN LABORAL"]
["B31816689 ","15KI","ÁCTIMA CONSULTORÍA DE RECURSOS HUMANOS, S.L.  "]
["B71448724","20PA","AGEFOR FORMACIÓN"]
["G31077050","25LA","ASPACE"]
["G31084635","30MU","ANTRV"]
["G71357750 ","35HS","ASOCIACIÓN NAVARRA SOCIAL  "]
["G71329221","40TE","ASOCIACION POSTHAC - ENTIDAD SOCIAL POR EL EMPLEO"]
["E71070064","45AD","FC FORMACIÓN CONTINUA, S.I."]
["B71404834","50NC","FORMACIÓN SOCIAL NAVARRA, S.L. "]
["G31830417","55KM","FUNDACIÓN ELKARTE "]
["G83496000","60SE","FUNDACIÓN KOINE AEQUALITAS"]
["G80468416","65BU","FUNDACIÓN LABORAL DE LA COSTRUCCIÓN "]
["B09390105 ","70LF","GABINETE DE RECOLOCACIÓN INDUSTRIAL, S.L.  "]
["B71364194","75JP","NAFORLAN NAVARRA DE FORMACIÓN Y EMPLEO, S.L. "]
["B48933618","80ZD","RODOIA 2000, S.L."]