{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["DATOS GENERALES","P1 P2 PROYECTO","E1 ASISTENCIA TECNICA","E2 DIRECTOR OBRA","E3 DIRECTOR EJECUCION","E4 LABORATORIO DE ENSAYOS","E5 EMPRESA CONSTRUCTORA","E6 SUPERVISORES EJECUCION","ÍNDICE DE CALIDAD","ETIQUETA DE CALIDAD"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"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":"DATOS GENERALES","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,null,"PROYECTO/OBRA"]
[]
[null,null,null,"DATOS OBLIGATORIOS",null,null,"OTROS DATOS:"]
[null,null,null,"REFERENCIA:","Obra Ejemplo €",null,"Valores en el estándar e"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros",10000000]
[null,null,null,"TIEMPO DE DURACIÓN en meses",18]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",2]
[]
[]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LAS EDIFICACIONES"]
[null,null,null,null,"Baja","Media","Alta","Muy alta"]
[null,null,null,"Viviendas",null,1]
[null,null,null,"Oficinas",null,1]
[null,null,null,"Centros comerciales y de ocio",null,null,2]
[null,null,null,"Edificios docentes",null,1]
[null,null,null,"Hospitales",null,null,null,4]
[null,null,null,"Construcciones auxiliares",0.5,null,2]
[null,null,null,"Aeropuertos",null,null,null,4]
[null,null,null,"Puertos",null,null,null,4]
[null,null,null,"Urbanización adscrita a los edificios",null,1]
[null,null,null,"Edificios administrativos",null,1]
[null,null,null,"Hoteles y residencias",null,1]
[null,null,null,"Edificios industriales",null,null,2]

{"sheet":"P1 P2 PROYECTO","index":1,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,null,"PROYECTO/OBRA"]
[]
[null,null,null,{"$f":"'DATOS GENERALES'!D7","v":"DATOS OBLIGATORIOS"},null,null,null,null,null,null,"LEYENDA"]
[null,null,null,{"$f":"'DATOS GENERALES'!D8","v":"REFERENCIA:"},{"$f":"'DATOS GENERALES'!E8","v":"Obra Ejemplo €"},null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D9","v":"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros"},{"$f":"'DATOS GENERALES'!E9","v":10000000},null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D10","v":"TIEMPO DE DURACIÓN en meses"},{"$f":"'DATOS GENERALES'!E10","v":18},null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D11","v":"COMPLEJIDAD ORGANIZATIVA DE LA OBRA"},{"$f":"'DATOS GENERALES'!E11","v":2}]
[]
[null,null,null,"FASE PROYECTO"]
[]
[null,"Ref","TIPO","P1 INDICADORES PROYECTISTA","VALORES","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","PESO REAL","Peso del grupo P1","Peso real del grupo P1","Desviación del IC","ACCIONES"]
[null,"P1.1","I-","Número de aclaraciones solicitadas",4,"(0,PEM/1000000)",0,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9/1000000),0)))","v":10},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G16+1/3*(H16-G16)),0))","v":4},10,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E16=\"\",\"\",IF(E16<$G16,\"ERROR\",IF(E16>$H16,\"ERROR\",IF(E16<=$I16,$J16+(0.2*$J16*ABS(E16-$I16)/ABS($G16-$I16)),$J16*ABS($H16-E16)/ABS($H16-$I16)))))))","v":10},null,null,null,{"$f":"IF(K16=\"\",\"\",IF(K16<$J16,\"Requiere acciones correctoras\",IF(K16>$J16,\"Valorar acciones de estímulo\",IF(K16=$J16,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"P1.2","I-","Número de complementos solicitados",2,"(0,PEM/2000000)",0,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9/2000000),0)))","v":5},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G17+1/3*(H17-G17)),0)))","v":2},10,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E17=\"\",\"\",IF(E17<$G17,\"ERROR\",IF(E17>$H17,\"ERROR\",IF(E17<=$I17,$J17+(0.2*$J17*ABS(E17-$I17)/ABS($G17-$I17)),$J17*ABS($H17-E17)/ABS($H17-$I17)))))))","v":10},null,null,null,{"$f":"IF(K17=\"\",\"\",IF(K17<$J17,\"Requiere acciones correctoras\",IF(K17>$J17,\"Valorar acciones de estímulo\",IF(K17=$J17,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"P1.3","I-","Número de correcciones solicitadas",2,"(0,PEM/2000000)",0,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9/2000000),0)))","v":5},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G18+1/3*(H18-G18)),0)))","v":2},20,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(E18<$G18,\"ERROR\",IF(E18>$H18,\"ERROR\",IF(E18<=$I18,$J18+(0.2*$J18*ABS(E18-$I18)/ABS($G18-$I18)),$J18*ABS($H18-E18)/ABS($H18-$I18)))))))","v":20},null,null,null,{"$f":"IF(K17=\"\",\"\",IF(K18<$J18,\"Requiere acciones correctoras\",IF(K18>$J18,\"Valorar acciones de estímulo\",IF(K18=$J18,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"P1.4","I-","Días de respuesta a las solicitudes por parte del proyectista",6,"(1, C.O.*suma de solicitudes)",0,{"$f":"$E$11*(E16+E17+E18)","v":16},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G19+1/3*(H19-G19)),0)))","v":6},20,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E19<$G19,\"ERROR\",IF(E19>$H19,\"ERROR\",IF(E19<=$I19,$J19+(0.2*$J19*ABS(E19-$I19)/ABS($G19-$I19)),$J19*ABS($H19-E19)/ABS($H19-$I19))))))","v":20},null,null,null,{"$f":"IF(K19=\"\",\"\",IF(K19<$J19,\"Requiere acciones correctoras\",IF(K19>$J19,\"Valorar acciones de estímulo\",IF(K19=$J19,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"P1.5","I+","% PEM destinado al Plan de Control",1,"(e-20%, e+20%)",{"$f":"1*(1-1/5)","v":0.8},{"$f":"1*(1+1/5)","v":1.2},{"$f":"1","v":1},12,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$G20,\"ERROR\",IF(E20>$H20,\"ERROR\",IF(E20>=$I20,$J20+(0.2*$J20*ABS(E20-$I20)/ABS($H20-$I20)),$J20*ABS($G20-E20)/ABS($G20-$I20)))))))","v":12},null,null,null,{"$f":"IF(K20=\"\",\"\",IF(K20<$J20,\"Requiere acciones correctoras\",IF(K20>$J20,\"Valorar acciones de estímulo\",IF(K20=$J20,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"P1.6","I+","Número de documentos complementarios/voluntarios",2,"(0,PEM/8000000)",0,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/8000000),0)))","v":3},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G21+2/3*(H21-G21)),0)))","v":2},5,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$G21,\"ERROR\",IF(E21>$H21,\"ERROR\",IF(E21>=$I21,$J21+(0.2*$J21*ABS(E21-$I21)/ABS($H21-$I21)),$J21*ABS($G21-E21)/ABS($G21-$I21)))))))","v":5},null,null,null,{"$f":"IF(K21=\"\",\"\",IF(K21<$J21,\"Requiere acciones correctoras\",IF(K21>$J21,\"Valorar acciones de estímulo\",IF(K21=$J21,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J21)","v":77},{"$f":"SUM(K16:K21)","v":77},20]
[]
[null,null,null,"P2 INDICADORES SUPERVISORES PROYECTO","VALORES","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","PESO REAL","Peso del grupo P2","Peso real del grupo P2","Desviación del IC","ACCIONES"]
[null,"P2.1","I-","Tiempo de supervisión del proyecto (días laborables)",16,"(PEM*CO/150000, PEM*CO/1000000)",{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/1500000),0)))","v":14},{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/1000000),0)))","v":20},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G25+1/3*(H25-G25)),0))","v":16},10,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E25=\"\",\"\",IF(E25<$G25,\"ERROR\",IF(E25>$H25,\"ERROR\",IF(E25<=$I25,$J25+(0.2*$J25*ABS(E25-$I25)/ABS($G25-$I25)),$J25*ABS($H25-E25)/ABS($H25-$I25)))))))","v":10},null,null,null,{"$f":"IF(K25=\"\",\"\",IF(K25<$J25,\"Requiere acciones correctoras\",IF(K25>$J25,\"Valorar acciones de estímulo\",IF(K25=$J25,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"P2.2","I-","Tiempo de redacción del informe de supervisión (horas)",12,"(PEM/1000000, PEM/750000)",{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/1000000),0))","v":10},{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9/750000),0)))","v":14},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G26+1/3*(H26-G26)),0))","v":12},8,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E26=\"\",\"\",IF(E26<$G26,\"ERROR\",IF(E26>$H26,\"ERROR\",IF(E26<=$I26,$J26+(0.2*$J26*ABS(E26-$I26)/ABS($G26-$I26)),$J26*ABS($H26-E26)/ABS($H26-$I26)))))))","v":8},null,null,null,{"$f":"IF(K26=\"\",\"\",IF(K26<$J26,\"Requiere acciones correctoras\",IF(K26>$J26,\"Valorar acciones de estímulo\",IF(K26=$J26,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"P2.3","I-","Tiempo de comunicación al proyectista de las solicitudes (días laborables)",1,"(0, C.O.)",0,{"$f":"$E$11","v":2},{"$f":"ROUNDUP((G27+1/3*(H27-G27)),0)","v":1},5,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",IF(E27=\"\",\"\",IF(E27<$G27,\"ERROR\",IF(E27>$H27,\"ERROR\",IF(E27<=$I27,$J27+(0.2*$J27*ABS(E27-$I27)/ABS($G27-$I27)),$J27*ABS($H27-E27)/ABS($H27-$I27)))))))","v":5},null,null,null,{"$f":"IF(K27=\"\",\"\",IF(K27<$J27,\"Requiere acciones correctoras\",IF(K27>$J27,\"Valorar acciones de estímulo\",IF(K27=$J27,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J25:J27)","v":23},{"$f":"SUM(K25:K27)","v":23},5]
[]
[null,null,null,"P1+P2 INDICADORES PROYECTO",null,null,null,null,null,{"$f":"J22+J28","v":100},{"$f":"K22+K28","v":100},{"$f":"L22+L28","v":25},{"$f":"$L30*K30/100","v":25},{"$f":"M30/L30","v":1}]
[null,null,null,"CONTRIBUCIÓN DEL PROYECTO AL IC",null,null,null,null,null,null,{"$f":"$K$30","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,null,null,null,null,null,null,null,"A","Buena calidad"]
[null,null,null,null,null,null,null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,null,null,null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,"D","Mala calidad"]

{"sheet":"E1 ASISTENCIA TECNICA","index":2,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,null,"PROYECTO/OBRA"]
[]
[null,null,null,{"$f":"'DATOS GENERALES'!D7","v":"DATOS OBLIGATORIOS"},null,null,null,null,null,null,"LEYENDA"]
[null,null,null,{"$f":"'DATOS GENERALES'!D8","v":"REFERENCIA:"},{"$f":"'DATOS GENERALES'!E8","v":"Obra Ejemplo €"},null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D9","v":"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros"},{"$f":"'DATOS GENERALES'!E9","v":10000000},null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D10","v":"TIEMPO DE DURACIÓN en meses"},{"$f":"'DATOS GENERALES'!E10","v":18},null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D11","v":"COMPLEJIDAD ORGANIZATIVA DE LA OBRA"},{"$f":"'DATOS GENERALES'!$E$11","v":2}]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E1 INDICADORES ASISTENCIA TÉCNICA","VALORES INDICADORES","INTERVALO","MIN","MAX","ESTÁNDAR","Peso de referencia","PESO REAL","Peso del grupo E4","Peso real del grupo E4","Desviación del IC","ACCIONES"]
[null,"E1.1","I-","Nº de no conformidades detectadas/mes (*)",4,"(0, (PEM*C.O./(Nº meses*100000)))",0,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*100000)),0)))","v":12},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G16+1/3*(H16-G16)),0)))","v":4},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E16=\"\",\"\",IF(E16<$G16,\"ERROR\",IF(E16>$H16,\"ERROR\",IF(E16<=$I16,$J16+(0.2*$J16*ABS(E16-$I16)/ABS($G16-$I16)),$J16*ABS($H16-E16)/ABS($H16-$I16)))))))","v":10},null,null,null,{"$f":"IF(K16=\"\",\"\",IF(K16<$J16,\"Requiere acciones correctoras\",IF(K16>$J16,\"Valorar acciones de estímulo\",IF(K16=$J16,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E1.2","I+","Nº de no conformidades resueltas/mes (*)",3,"(0, nº de no conformidades)",0,{"$f":"E16","v":4},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G17+2/3*(H17-G17)),0)))","v":3},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E17=\"\",\"\",IF(E17<$G17,\"ERROR\",IF(E16=0,12,IF(E17>$H17,\"ERROR\",IF(E17>=$I17,$J17+(0.2*$J17*ABS(E17-$I17)/ABS($H17-$I17)),$J17*ABS($G17-E17)/ABS($G17-$I17))))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E1.3","I-","Nº de no conformidades pendientes /mes (*)",{"$f":"E16-E17","v":1},"(0, diferencia entre detectadas y resueltas)",0,{"$f":"E16-E17","v":1},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G18+1/3*(H18-G18)),0)))","v":1},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(E18<$G18,\"ERROR\",IF(E16=0,12,IF(E18=0,12,IF(E18>$H18,\"ERROR\",IF(E18<=$I18,$J18+(0.2*$J18*ABS(E18-$I18)/ABS($G18-$I18)),$J18*ABS($H18-E18)/ABS($H18-$I18)))))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E1.4","I-","Nº de acciones de doble control/mes (*)",1,"(0, No conformidades/3)",0,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$16/3),0)))","v":2},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G19+1/3*(H19-G19)),0)))","v":1},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$G19,\"ERROR\",IF(E17=0,12,IF(E19>$H19,\"ERROR\",IF(E19<=$I19,$J19+(0.2*$J19*ABS(E19-$I19)/ABS($G19-$I19)),$J19*ABS($H19-E19)/ABS($H19-$I19))))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E1.5","I-","Nº de acciones de triple (o +) control/mes (*)",1,"(0, No conformidades/6)",0,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($H$16/6),0)))","v":2},1,10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$G20,\"ERROR\",IF(E20>$H20,\"ERROR\",IF(E20<=$I20,$J20+(0.2*$J20*ABS(E20-$I20)/ABS($G20-$I20)),$J20*ABS($H20-E20)/ABS($H20-$I20)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E1.6","I-","Nº de recomendaciones a la dirección de obra/mes",8,"(0, (2*max de no conformidades detectadas))",0,{"$f":"2*H16","v":24},8,10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$G21,\"ERROR\",IF(E21>$H21,\"ERROR\",IF(E21<=$I21,$J21+(0.2*$J21*ABS(E21-$I21)/ABS($G21-$I21)),$J21*ABS($H21-E21)/ABS($H21-$I21)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E1.7","I-","Nº de recomendaciones del Coordinador de seguridad/mes",1,"(0, (PEM*C.O./(Nº meses*5000000))",0,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*500000)),0)))","v":3},1,10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E22=\"\",\"\",IF(E22<$G22,\"ERROR\",IF(E22>$H22,\"ERROR\",IF(E22<=$I22,$J22+(0.2*$J22*ABS(E22-$I22)/ABS($G22-$I22)),$J22*ABS($H22-E22)/ABS($H22-$I22)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E1.8","I+","Nº de visitas/reuniones de obra/mes",6,"(1, 2*(semanas/mes)*C.O.)",1,{"$f":"4.2*$E$11","v":8.4},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G23+2/3*(H23-G23)),0)))","v":6},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$G23,\"ERROR\",IF(E23>$H23,\"ERROR\",IF(E23>=$I23,$J23+(0.2*$J23*ABS(E23-$I23)/ABS($H23-$I23)),$J23*ABS($G23-E23)/ABS($G23-$I23)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E1.9","I+","Nº de informes de control para el promotor/mes",4,"(1, semanas/mes)",1,{"$f":"ROUNDUP((H23/2),0)","v":5},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G24+2/3*(H24-G24)),0)))","v":4},20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E24=\"\",\"\",IF(E24<$G24,\"ERROR\",IF(E24>$H24,\"ERROR\",IF(E24>=$I24,$J24+(0.2*$J24*ABS(E24-$I24)/ABS($H24-$I24)),$J24*ABS($G24-E24)/ABS($G24-$I24)))))))","v":20},null,null,null,"No requiere acciones"]
[null,null,null,"(*)Corregir con acumuladas. Datos en casilla gris se autocumplimentan",null,null,null,null,null,{"$f":"SUM(J16:J24)","v":100},{"$f":"SUM(K16:K24)","v":100},15,{"$f":"$L25*K25/100","v":15},{"$f":"M25/L25","v":1}]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E4 AL IC",null,null,null,null,null,null,{"$f":"$K$25","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,null,null,null,null,null,null,null,"A","Buena calidad"]
[null,null,null,null,null,null,null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,null,null,null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,"D","Mala calidad"]

{"sheet":"E2 DIRECTOR OBRA","index":3,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,null,"PROYECTO/OBRA"]
[]
[null,null,null,{"$f":"'DATOS GENERALES'!D7","v":"DATOS OBLIGATORIOS"},null,null,null,null,null,null,"LEYENDA"]
[null,null,null,{"$f":"'DATOS GENERALES'!D8","v":"REFERENCIA:"},{"$f":"'DATOS GENERALES'!E8","v":"Obra Ejemplo €"},null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D9","v":"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros"},{"$f":"'DATOS GENERALES'!E9","v":10000000},null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D10","v":"TIEMPO DE DURACIÓN en meses"},{"$f":"'DATOS GENERALES'!E10","v":18},null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D11","v":"COMPLEJIDAD ORGANIZATIVA DE LA OBRA"},{"$f":"'DATOS GENERALES'!E11","v":2}]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E2 INDICADORES DIRECTOR OBRA","VALORES INDICADORES","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","PESO REAL","Peso del grupo E2","Peso real del grupo E2","Desviación del IC","ACCIONES"]
[null,"E2.1","I-","Nº de correcciones del proyecto/mes",2,"(0, (PEM*C.O./(Nº meses*250.000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*250000)),0))))","v":5},{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G16+1/3*(H16-G16)),0))))","v":2},15,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E16=\"\",\"\",IF(E16<$G16,\"ERROR\",IF(E16>$H16,\"ERROR\",IF(E16<=$I16,$J16+(0.2*$J16*ABS(E16-$I16)/ABS($G16-$I16)),$J16*ABS($H16-E16)/ABS($H16-$I16)))))))","v":15},null,null,null,{"$f":"IF(K16=\"\",\"\",IF(K16<$J16,\"Requiere acciones correctoras\",IF(K16>$J16,\"Valorar acciones de estímulo\",IF(K16=$J16,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E2.2","I-","Nº de correcciones de la ejecución/mes",3,"(0, (PEM*C.O./(Nº meses*150.000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*150000)),0))))","v":8},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G17+1/3*(H17-G17)),0)))","v":3},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E17=\"\",\"\",IF(E17<$G17,\"ERROR\",IF(E17>$H17,\"ERROR\",IF(E17<=$I17,$J17+(0.2*$J17*ABS(E17-$I17)/ABS($G17-$I17)),$J17*ABS($H17-E17)/ABS($H17-$I17)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E2.3","I-","Nº de modificaciones del presupuesto/mes",2,"(0, (PEM*C.O./(Nº meses*250.000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*250000)),0))))","v":5},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G18+1/3*(H18-G18)),0)))","v":2},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(E18<$G18,\"ERROR\",IF(E18>$H18,\"ERROR\",IF(E18<=$I18,$J18+(0.2*$J18*ABS(E18-$I18)/ABS($G18-$I18)),$J18*ABS($H18-E18)/ABS($H18-$I18)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E2.4","I-","Nº de instrucciones de modificación Libro Órdenes/mes",3,"(0, (PEM*C.O./(Nº meses*150.000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*150000)),0))))","v":8},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G19+1/3*(H19-G19)),0)))","v":3},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$G19,\"ERROR\",IF(E19>$H19,\"ERROR\",IF(E19<=$I19,$J19+(0.2*$J19*ABS(E19-$I19)/ABS($G19-$I19)),$J19*ABS($H19-E19)/ABS($H19-$I19)))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E2.5","I+","Nº de apuntes (seguimiento) Libro Órdenes/mes",11,"(0, (PEM*C.O./(Nº meses*75.000))",1,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*75000)),0))))","v":15},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G20+2/3*(H20-G20)),0)))","v":11},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$G20,\"ERROR\",IF(E20>$H20,\"ERROR\",IF(E20>=$I20,$J20+(0.2*$J20*ABS(E20-$I20)/ABS($H20-$I20)),$J20*ABS($G20-E20)/ABS($G20-$I20)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E2.6","I+","Nº de visitas/reuniones de obra/mes",6,"(1,(semanas/mes)*C.O.)",1,{"$f":"4.2*$E$11","v":8.4},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G21+2/3*(H21-G21)),0)))","v":6},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$G21,\"ERROR\",IF(E21>$H21,\"ERROR\",IF(E21>=$I21,$J21+(0.2*$J21*ABS(E21-$I21)/ABS($H21-$I21)),$J21*ABS($G21-E21)/ABS($G21-$I21)))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E2.7","I+","Nº de informes de control para el promotor/mes",4,"(1, nº visitas/2)",1,{"$f":"ROUNDUP((H21/2),0)","v":5},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G22+2/3*(H22-G22)),0)))","v":4},15,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E22=\"\",\"\",IF(E22<$G22,\"ERROR\",IF(E22>$H22,\"ERROR\",IF(E22>=$I22,$J22+(0.2*$J22*ABS(E22-$I22)/ABS($H22-$I22)),$J22*ABS($G22-E22)/ABS($G22-$I22)))))))","v":15},null,null,null,"No requiere acciones"]
[null,"E2.8","I-","Nº de instrucciones del coordinador de seguridad laboral/mes ",2,"(0, (PEM*C.O./(Nº meses*200000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*200000)),0))))","v":6},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G23+1/3*(H23-G23)),0)))","v":2},20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$G23,\"ERROR\",IF(E23>$H23,\"ERROR\",IF(E23<=$I23,$J23+(0.2*$J23*ABS(E23-$I23)/ABS($G23-$I23)),$J23*ABS($H23-E23)/ABS($H23-$I23)))))))","v":20},null,null,null,"No requiere acciones"]
[null,"E2.9","I-","Nº de recomendaciones de la Asistencia Técnica/mes",{"$f":"'E1 ASISTENCIA TECNICA'!$E$21","v":8},"(0, (2*max de no conformidades detectadas))",0,{"$f":"'E1 ASISTENCIA TECNICA'!$H$21","v":24},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G24+1/3*(H24-G24)),0)))","v":8},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E24=\"\",\"\",IF(E24<$G24,\"ERROR\",IF(E24>$H24,\"ERROR\",IF(E24<=$I24,$J24+(0.2*$J24*ABS(E24-$I24)/ABS($G24-$I24)),$J24*ABS($H24-E24)/ABS($H24-$I24)))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E2.10","I+","Nº de recomendaciones de la Asistencia Técnica consideradas/mes",6,"(0, nº recomendaciones de la AT)",0,{"$f":"$E$24","v":8},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G25+2/3*(H25-G25)),0)))","v":6},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E25=\"\",\"\",IF(E25<$G25,\"ERROR\",IF(E25>$H25,\"ERROR\",IF(E25=0,J25*1.2,IF(E25>=$I25,$J25+(0.2*$J25*ABS(E25-$I25)/ABS($H25-$I25)),$J25*ABS($G25-E25)/ABS($G25-$I25))))))))","v":5},null,null,null,"No requiere acciones"]
[null,null,null,"Datos en casilla gris se autocumplimentan",null,null,null,null,null,{"$f":"SUM(J16:J25)","v":100},{"$f":"SUM(K16:K25)","v":100},10,{"$f":"$L26*K26/100","v":10},{"$f":"M26/L26","v":1}]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E2 AL IC",null,null,null,null,null,null,{"$f":"$K$26","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,null,null,null,null,null,null,null,"A","Buena calidad"]
[null,null,null,null,null,null,null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,null,null,null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,"D","Mala calidad"]

{"sheet":"E3 DIRECTOR EJECUCION","index":4,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,null,"PROYECTO/OBRA"]
[]
[null,null,null,{"$f":"'DATOS GENERALES'!D7","v":"DATOS OBLIGATORIOS"},null,null,null,null,null,null,"LEYENDA"]
[null,null,null,{"$f":"'DATOS GENERALES'!D8","v":"REFERENCIA:"},{"$f":"'DATOS GENERALES'!E8","v":"Obra Ejemplo €"},null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D9","v":"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros"},{"$f":"'DATOS GENERALES'!E9","v":10000000},null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D10","v":"TIEMPO DE DURACIÓN en meses"},{"$f":"'DATOS GENERALES'!E10","v":18},null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D11","v":"COMPLEJIDAD ORGANIZATIVA DE LA OBRA"},{"$f":"'DATOS GENERALES'!E11","v":2}]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E3  INDICADORES DIRECTOR EJECUCIÓN OBRA","VALORES INDICADORES","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","PESO REAL","Peso del grupo E3","Peso real del grupo E3","Desviación del IC","ACCIONES"]
[null,null,null,"DATO: Nº Materiales recibidos/mes= Total mat",10]
[null,"E3.1","I-","Nº de materiales rechazados/mes por doc. incompleta",4,"(0, Total mat)",0,{"$f":"IF($E$16=\"\",\"\",$E$16)","v":10},{"$f":"IF($E$16=\"\",\"\",ROUNDUP((G17+1/3*(H17-G17)),0))","v":4},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E17=\"\",\"\",IF(E17<$G17,\"ERROR\",IF(E17>$H17,\"ERROR\",IF(E17<=$I17,$J17+(0.2*$J17*ABS(E17-$I17)/ABS($G17-$I17)),$J17*ABS($H17-E17)/ABS($H17-$I17)))))))","v":10},null,null,null,{"$f":"IF(K17=\"\",\"\",IF(K17<$J17,\"Requiere acciones correctoras\",IF(K17>$J17,\"Valorar acciones de estímulo\",IF(K17=$J17,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E3.2","I+","Nº de materiales aceptados/mes",4,"(0, diferencia recibidos y rechazados)",0,{"$f":"IF($E$16=\"\",\"\",($E$16-$E$17))","v":6},{"$f":"ROUNDUP((G18+2/3*(H18-G18)),0)","v":4},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(H18=I18,0,IF(E17=H17,0,IF(E18<$G18,\"ERROR\",IF(E18=0,0,IF(E18>$H18,\"ERROR\",IF(E18>=$I18,$J18+(0.2*$J18*ABS(E18-$I18)/ABS($H18-$I18)),$J18*ABS($G18-E18)/ABS($G18-$I18))))))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E3.3","I-","Nº de solicitudes complementarias de documentación de materiales",2,"(0, Total mat)",0,{"$f":"IF($E$16=\"\",\"\",$E$17)","v":4},{"$f":"ROUNDUP((G19+1/3*(H19-G19)),0)","v":2},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19=0,(J19*1.2),IF(E19<$G19,\"ERROR\",IF(E19>$H19,\"ERROR\",IF(E19<=$I19,$J19+(0.2*$J19*ABS(E19-$I19)/ABS($G19-$I19)),$J19*ABS($H19-E19)/ABS($H19-$I19))))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E3.4","I-","Nº de correcciones de la ejecución/mes",{"$f":"'E2 DIRECTOR OBRA'!$E$17","v":3},"(0, (PEM*C.O./(Nº meses*150.000))",0,{"$f":"'E2 DIRECTOR OBRA'!$H$17","v":8},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G20+1/3*(H20-G20)),0)))","v":3},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$G20,\"ERROR\",IF(E20>$H20,\"ERROR\",IF(E20<=$I20,$J20+(0.2*$J20*ABS(E20-$I20)/ABS($G20-$I20)),$J20*ABS($H20-E20)/ABS($H20-$I20)))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E3.5","I-","Nº de recomendaciones de la asistencia técnica/mes",{"$f":"'E1 ASISTENCIA TECNICA'!$E$21","v":8},"(0, (2*max de no conformidades detectadas))",{"$f":"'E1 ASISTENCIA TECNICA'!G21","v":0},{"$f":"'E1 ASISTENCIA TECNICA'!H21","v":24},{"$f":"'E1 ASISTENCIA TECNICA'!I21","v":8},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$G21,\"ERROR\",IF(E21>$H21,\"ERROR\",IF(E21<=$I21,$J21+(0.2*$J21*ABS(E21-$I21)/ABS($G21-$I21)),$J21*ABS($H21-E21)/ABS($H21-$I21)))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E3.6","I+","Nº de recomendaciones de la Asistencia Técnica consideradas/mes",6,"(0, nº de recoendaciones de la AT))",0,{"$f":"'E1 ASISTENCIA TECNICA'!$E$21","v":8},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G22+2/3*(H22-G22)),0)))","v":6},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E22=\"\",\"\",IF(E22<$G22,\"ERROR\",IF(E22>$H22,\"ERROR\",IF(E22=0,J22*1.2,IF(E22>=$I22,$J22+(0.2*$J22*ABS(E22-$I22)/ABS($H22-$I22)),$J22*ABS($G22-E22)/ABS($G22-$I22))))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E3.7","I+","Nº de visitas/reuniones de obra",6,"(1, (semanas/mes)*C.O.)",1,{"$f":"'E2 DIRECTOR OBRA'!$H$21","v":8.4},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G23+2/3*(H23-G23)),0)))","v":6},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$G23,\"ERROR\",IF(E23>$H23,\"ERROR\",IF(E23>=$I23,$J23+(0.2*$J23*ABS(E23-$I23)/ABS($H23-$I23)),$J23*ABS($G23-E23)/ABS($G23-$I23)))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E3.8","I-","Nº de recomendaciones del Coordinador de seguridad/mes",3,"(0, (PEM/(Nº meses*150000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*150000)),0))))","v":8},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G24+1/3*(H24-G24)),0)))","v":3},20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E24=\"\",\"\",IF(E24<$G24,\"ERROR\",IF(E24>$H24,\"ERROR\",IF(E24<=$I24,$J24+(0.2*$J24*ABS(E24-$I24)/ABS($G24-$I24)),$J24*ABS($H24-E24)/ABS($H24-$I24)))))))","v":20},null,null,null,"No requiere acciones"]
[null,"E3.9","I-","% Ajuste en plazo de la aplicación del Plan de Control/mes",1,"(e-20%, e+20%)",{"$f":"1*(1-1/5)","v":0.8},{"$f":"1*(1+1/5)","v":1.2},1,20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E25=\"\",\"\",IF(E25<$G25,\"ERROR\",IF(E25>$H25,\"ERROR\",IF(E25<=$I25,$J25+(0.2*$J25*ABS(E25-$I25)/ABS($G25-$I25)),$J25*ABS($H25-E25)/ABS($H25-$I25)))))))","v":20},null,null,null,"No requiere acciones"]
[null,"E3.10","I-","% Ajuste en presupuesto de la aplicación del Plan de Control/mes",1,"(e-20%, e+20%)",{"$f":"1*(1-1/5)","v":0.8},{"$f":"1*(1+1/5)","v":1.2},1,20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E26=\"\",\"\",IF(E26<$G26,\"ERROR\",IF(E26>$H26,\"ERROR\",IF(E26<=$I26,$J26+(0.2*$J26*ABS(E26-$I26)/ABS($G26-$I26)),$J26*ABS($H26-E26)/ABS($H26-$I26)))))))","v":20},null,null,null,"No requiere acciones"]
[null,null,null,"Datos en casilla gris se autocumplimentan",null,null,null,null,null,{"$f":"SUM(J17:J26)","v":100},{"$f":"SUM(K17:K26)","v":100},10,{"$f":"$L27*K27/100","v":10},{"$f":"M27/L27","v":1}]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E3 AL IC",null,null,null,null,null,null,{"$f":"$K$27","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,null,null,null,null,null,null,null,"A","Buena calidad"]
[null,null,null,null,null,null,null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,null,null,null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,"D","Mala calidad"]

{"sheet":"E4 LABORATORIO DE ENSAYOS","index":5,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,null,"PROYECTO/OBRA"]
[]
[null,null,null,{"$f":"'DATOS GENERALES'!D7","v":"DATOS OBLIGATORIOS"},null,null,null,null,null,null,"LEYENDA"]
[null,null,null,{"$f":"'DATOS GENERALES'!D8","v":"REFERENCIA:"},{"$f":"'DATOS GENERALES'!E8","v":"Obra Ejemplo €"},null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D9","v":"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros"},{"$f":"'DATOS GENERALES'!E9","v":10000000},null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D10","v":"TIEMPO DE DURACIÓN en meses"},{"$f":"'DATOS GENERALES'!E10","v":18},null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D11","v":"COMPLEJIDAD ORGANIZATIVA DE LA OBRA"},{"$f":"'DATOS GENERALES'!E11","v":2}]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E4  INDICADORES LABORATORIO DE ENSAYOS","VALORES INDICADORES","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","PESO REAL","Peso del grupo E4","Peso real del grupo E4","Desviación del IC","ACCIONES"]
[null,"E4.1","I+","% de resultados aceptados/mes",0.83333333333333337,"(0, todos)",0,1,{"$f":"H16*(1-1/6)","v":0.83333333333333337},20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E16=\"\",\"\",IF(E16<$G16,\"ERROR\",IF(E16>$H16,\"ERROR\",IF(E16>=$I16,$J16+(0.2*$J16*ABS(E16-$I16)/ABS($H16-$I16)),$J16*ABS($G16-E16)/ABS($G16-$I16)))))))","v":20},null,null,null,{"$f":"IF(K16=\"\",\"\",IF(K16<$J16,\"Requiere acciones correctoras\",IF(K16>$J16,\"Valorar acciones de estímulo\",IF(K16=$J16,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E4.2 ","I-","% de resultados rechazados/mes",{"$f":"1-E16","v":0.16666666666666663},"(0, todos)",0,{"$f":"H16","v":1},{"$f":"H16*1/6","v":0.16666666666666666},15,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E17=\"\",\"\",IF(E16=100, 100,IF(E17<$G17,\"ERROR\",IF(E17>$H17,\"ERROR\",IF(E17<=$I17,$J17+(0.2*$J17*ABS(E17-$I17)/ABS($G17-$I17)),$J17*ABS($H17-E17)/ABS($H17-$I17))))))))","v":15},null,null,null,"No requiere acciones"]
[null,"E4.3","I-","% de ensayos repetidos/mes (*)",0.27777777777777779,"(%rechazados, todos)",{"$f":"E17","v":0.16666666666666663},{"$f":"H17","v":1},{"$f":"(H18-G18)*1/3","v":0.27777777777777779},15,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(E18<$G18,\"ERROR\",IF(E18>$H18,\"ERROR\",IF(E18<=$I18,$J18+(0.2*$J18*ABS(E18-$I18)/ABS($G18-$I18)),$J18*ABS($H18-E18)/ABS($H18-$I18)))))))","v":15},null,null,null,"No requiere acciones"]
[null,"E4.4","I-","Nº de comunicaciones de anomalías al director de obra/mes",4,"(0, (PEM/(Nº meses*50000))",0,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9/($E$10*50000)),0)))","v":12},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G19+1/3*(H19-G19)),0)))","v":4},15,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$G19,\"ERROR\",IF(E19>$H19,\"ERROR\",IF(E19<=$I19,$J19+(0.2*$J19*ABS(E19-$I19)/ABS($G19-$I19)),$J19*ABS($H19-E19)/ABS($H19-$I19)))))))","v":15},null,null,null,"No requiere acciones"]
[null,"E4.5","I-","Nº de recomendaciones del Coordinador de seguridad/mes",1,"(0, (PEM*C.O./(Nº meses*500000))",0,{"$f":"IF($E$11=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*500000)),0)))","v":3},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G20+1/3*(H20-G20)),0)))","v":1},5,5,null,null,null,"No requiere acciones"]
[null,"E4.6","I-","% Ajuste en plazo de la aplicación del Plan de Control/mes",{"$f":"'E3 DIRECTOR EJECUCION'!$E$25","v":1},"(e-20%, e+20%)",{"$f":"1*(1-1/5)","v":0.8},{"$f":"'E3 DIRECTOR EJECUCION'!$H$25","v":1.2},{"$f":"'E3 DIRECTOR EJECUCION'!$I$25","v":1},15,15,null,null,null,"No requiere acciones"]
[null,"E4.7","I-","% Ajuste en presupuesto de la aplicación del Plan de Control/mes",{"$f":"'E3 DIRECTOR EJECUCION'!$E$26","v":1},"(e-20%, e+20%)",{"$f":"'E3 DIRECTOR EJECUCION'!$G$26","v":0.8},{"$f":"'E3 DIRECTOR EJECUCION'!$H$26","v":1.2},{"$f":"'E3 DIRECTOR EJECUCION'!$I$26","v":1},15,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E22=\"\",\"\",IF(E22<$G22,\"ERROR\",IF(E22>$H22,\"ERROR\",IF(E22<=$I22,$J22+(0.2*$J22*ABS(E22-$I22)/ABS($G22-$I22)),$J22*ABS($H22-E22)/ABS($H22-$I22)))))))","v":15},null,null,null,"No requiere acciones"]
[null,null,null,"(*)Corregir con acumuladas. Datos en casilla gris se autocumplimentan",null,null,null,null,null,{"$f":"SUM(J16:J22)","v":100},{"$f":"SUM(K16:K22)","v":100},10,{"$f":"$L23*K23/100","v":10},{"$f":"M23/L23","v":1}]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E5 AL IC",null,null,null,null,null,null,{"$f":"$K$23","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,null,null,null,null,null,null,null,"A","Buena calidad"]
[null,null,null,null,null,null,null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,null,null,null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,"D","Mala calidad"]

{"sheet":"E5 EMPRESA CONSTRUCTORA","index":6,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,null,"PROYECTO/OBRA"]
[]
[null,null,null,{"$f":"'DATOS GENERALES'!D7","v":"DATOS OBLIGATORIOS"},null,null,null,null,null,null,"LEYENDA"]
[null,null,null,{"$f":"'DATOS GENERALES'!D8","v":"REFERENCIA:"},{"$f":"'DATOS GENERALES'!E8","v":"Obra Ejemplo €"},null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D9","v":"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros"},{"$f":"'DATOS GENERALES'!E9","v":10000000},null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D10","v":"TIEMPO DE DURACIÓN en meses"},{"$f":"'DATOS GENERALES'!E10","v":18},null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,{"$f":"'DATOS GENERALES'!D11","v":"COMPLEJIDAD ORGANIZATIVA DE LA OBRA"},{"$f":"'DATOS GENERALES'!E11","v":2}]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E5 INDICADORES EMPRESA CONSTRUCTORA","VALORES INDICADORES","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","PESO REAL","Peso del grupo E5","Peso real del grupo E5","Desviación del IC","ACCIONES"]
[null,null,null,"DATO: Nº Materiales recibidos/mes= Total mat",{"$f":"'E3 DIRECTOR EJECUCION'!$E$16","v":10}]
[null,"E5.1","I-","Nº de instrucciones de modificación Libro Órdenes/mes",{"$f":"'E2 DIRECTOR OBRA'!$E$19","v":3},"(0, (PEM/(Nº meses*150000))",0,{"$f":"'E2 DIRECTOR OBRA'!$H$19","v":8},{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP((G17+1/3*(H17-G17)),0))))","v":3},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E17=\"\",\"\",IF(E17<$G17,\"ERROR\",IF(E17>$H17,\"ERROR\",IF(E17<=$I17,$J17+(0.2*$J17*ABS(E17-$I17)/ABS($G17-$I17)),$J17*ABS($H17-E17)/ABS($H17-$I17)))))))","v":5},null,null,null,{"$f":"IF(K17=\"\",\"\",IF(K17<$J17,\"Requiere acciones correctoras\",IF(K17>$J17,\"Valorar acciones de estímulo\",IF(K17=$J17,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E5.2","I-","% Ajuste en plazo de ejecución",1,"(e-20%, e+20%)",{"$f":"1*(1-1/5)","v":0.8},{"$f":"1*(1+1/5)","v":1.2},1,20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(E18<$G18,\"ERROR\",IF(E18>$H18,\"ERROR\",IF(E18<=$I18,$J18+(0.2*$J18*ABS(E18-$I18)/ABS($G18-$I18)),$J18*ABS($H18-E18)/ABS($H18-$I18)))))))","v":20},null,null,null,{"$f":"IF(K18<$J18,\"Requiere acciones correctoras\",IF(K18>$J18,\"Valorar acciones de estímulo\",IF(K18=$J18,\"No requiere acciones\")))","v":"No requiere acciones"}]
[null,"E5.3","I-","% Ajuste presupuesto sobre el total",1,"(e-20%, e+20%)",{"$f":"1*(1-1/5)","v":0.8},{"$f":"1*(1+1/5)","v":1.2},1,40,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$G19,\"ERROR\",IF(E19>$H19,\"ERROR\",IF(E19<=$I19,$J19+(0.2*$J19*ABS(E19-$I19)/ABS($G19-$I19)),$J19*ABS($H19-E19)/ABS($H19-$I19)))))))","v":40},null,null,null,"No requiere acciones"]
[null,"E5.4","I-","Nº de instrucciones aspectos seguridad laboral/mes ",3,"(0, (PEMC.O./(Nº meses*150000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*150000)),0))))","v":8},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G20+1/3*(H20-G20)),0)))","v":3},10,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$G20,\"ERROR\",IF(E20>$H20,\"ERROR\",IF(E20<=$I20,$J20+(0.2*$J20*ABS(E20-$I20)/ABS($G20-$I20)),$J20*ABS($H20-E20)/ABS($H20-$I20)))))))","v":10},null,null,null,{"$f":"IF(K20=\"\",\"\",IF(K20<$J20,\"Requiere acciones correctoras\",IF(K20>$J20,\"Valorar acciones de estímulo\",IF(K20=$J20,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E5.5","I-","Nº de recomendaciones del Coordinador de seguridad/mes",3,"(0, (PEM/(Nº meses*150000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*150000)),0))))","v":8},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G21+1/3*(H21-G21)),0)))","v":3},10,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$G21,\"ERROR\",IF(E21>$H21,\"ERROR\",IF(E21<=$I21,$J21+(0.2*$J21*ABS(E21-$I21)/ABS($G21-$I21)),$J21*ABS($H21-E21)/ABS($H21-$I21)))))))","v":10},null,null,null,{"$f":"IF(K21=\"\",\"\",IF(K21<$J21,\"Requiere acciones correctoras\",IF(K21>$J21,\"Valorar acciones de estímulo\",IF(K21=$J21,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E5.6","I+","Nº de modificaciones de la idreccion facultativa realizadas",10,"(0, (PEM*C.O./(Nº meses*75000))",0,{"$f":"IF( $E$11=\"\",\"\",IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9*$E$11/($E$10*75000)),0))))","v":15},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G22+2/3*(H22-G22)),0)))","v":10},5,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",IF(E22=\"\",\"\",IF(E22<$G22,\"ERROR\",IF(E22>$H22,\"ERROR\",IF(E22>=$I22,$J22+(0.2*$J22*ABS(E22-$I22)/ABS($H22-$I22)),$J22*ABS($G22-E22)/ABS($G22-$I22)))))))","v":5},null,null,null,{"$f":"IF(K22=\"\",\"\",IF(K22<$J22,\"Requiere acciones correctoras\",IF(K22>$J22,\"Valorar acciones de estímulo\",IF(K22=$J22,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E5.7","I-","Nº de materiales rechazados/mes por cualquier causa",4,"(0, Total mat)",0,{"$f":"$E$16","v":10},{"$f":"ROUNDUP((G23+1/3*(H23-G23)),0)","v":4},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$G23,\"ERROR\",IF(E23>$H23,\"ERROR\",IF(E23<=$I23,$J23+(0.2*$J23*ABS(E23-$I23)/ABS($G23-$I23)),$J23*ABS($H23-E23)/ABS($H23-$I23)))))))","v":10},null,null,null,"No requiere acciones"]
[null,null,null,"Datos en casilla gris se autocumplimentan",null,null,null,null,null,{"$f":"SUM(J17:J23)","v":100},{"$f":"SUM(K17:K23)","v":100},20,{"$f":"$L24*K24/100","v":20},{"$f":"M24/L24","v":1}]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E6 AL IC",null,null,null,null,null,null,{"$f":"$K$24","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,null,null,null,null,null,null,null,"A","Buena calidad"]
[null,null,null,null,null,null,null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,null,null,null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,"D","Mala calidad"]

{"sheet":"E6 SUPERVISORES EJECUCION","index":7,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,null,"PROYECTO/OBRA"]
[]
[null,null,null,{"$f":"'DATOS GENERALES'!D7","v":"DATOS OBLIGATORIOS"}]
[null,null,null,{"$f":"'DATOS GENERALES'!D8","v":"REFERENCIA:"},{"$f":"'DATOS GENERALES'!E8","v":"Obra Ejemplo €"}]
[null,null,null,{"$f":"'DATOS GENERALES'!D9","v":"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros"},{"$f":"'DATOS GENERALES'!E9","v":10000000}]
[null,null,null,{"$f":"'DATOS GENERALES'!D10","v":"TIEMPO DE DURACIÓN en meses"},{"$f":"'DATOS GENERALES'!E10","v":18}]
[null,null,null,{"$f":"'DATOS GENERALES'!D11","v":"COMPLEJIDAD ORGANIZATIVA DE LA OBRA"},{"$f":"'DATOS GENERALES'!E11","v":2}]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,"Ref","TIPO","E6 INDICADORES SUPERVISORES EJECUCIÓN","VALORES INDICADORES","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","PESO REAL","Peso del grupo E6","Peso real del grupo E6","Desviación del IC","ACCIONES"]
[null,"E6.1","I-","% Cumplimiento cuantitativo del plan de control/mes (€)",{"$f":"'E3 DIRECTOR EJECUCION'!$E$26","v":1},"(e-20%, e+20%)",0.8,{"$f":"'E3 DIRECTOR EJECUCION'!$H$26","v":1.2},1,10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E16=\"\",\"\",IF(E16<$G16,\"ERROR\",IF(E16>$H16,\"ERROR\",IF(E16<=$I16,$J16+(0.2*$J16*ABS(E16-$I16)/ABS($G16-$I16)),$J16*ABS($H16-E16)/ABS($H16-$I16)))))))","v":10},null,null,null,{"$f":"IF(K16=\"\",\"\",IF(K16<$J16,\"Requiere acciones correctoras\",IF(K16>$J16,\"Valorar acciones de estímulo\",IF(K16=$J16,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"E6.2","I+","% de resultados aceptados/mes",{"$f":"'E4 LABORATORIO DE ENSAYOS'!$E$16","v":0.83333333333333337},"(0%, 100%)",0,{"$f":"'E4 LABORATORIO DE ENSAYOS'!$H$16","v":1},{"$f":"'E4 LABORATORIO DE ENSAYOS'!$I$16","v":0.83333333333333337},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E17=\"\",\"\",IF(E17<$G17,\"ERROR\",IF(E17>$H17,\"ERROR\",IF(E17>=$I17,$J17+(0.2*$J17*ABS(E17-$I17)/ABS($H17-$I17)),$J17*ABS($G17-E17)/ABS($G17-$I17)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E6.3","I-","% de resultados rechazados/mes",{"$f":"'E4 LABORATORIO DE ENSAYOS'!$E$17","v":0.16666666666666663},"(0%, 100%)",0,{"$f":"'E4 LABORATORIO DE ENSAYOS'!$H$17","v":1},{"$f":"'E4 LABORATORIO DE ENSAYOS'!$I$17","v":0.16666666666666666},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(E18<$G18,\"ERROR\",IF(E18>$H18,\"ERROR\",IF(E18<=$I18,$J18+(0.2*$J18*ABS(E18-$I18)/ABS($G18-$I18)),$J18*ABS($H18-E18)/ABS($H18-$I18)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E6.4","I-","Nº de acciones que necesitan modificación de ejecución/mes",{"$f":"'E2 DIRECTOR OBRA'!$E$17","v":3},"(0, (PEM*C.O./(Nº meses*150.000))",0,{"$f":"'E2 DIRECTOR OBRA'!$H$17","v":8},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G19+1/3*(H19-G19)),0)))","v":3},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$G19,\"ERROR\",IF(E19>$H19,\"ERROR\",IF(E19<=$I19,$J19+(0.2*$J19*ABS(E19-$I19)/ABS($G19-$I19)),$J19*ABS($H19-E19)/ABS($H19-$I19)))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E6.5","I-","Nº de acciones que necesitan modificación presupuesto/mes",{"$f":"'E2 DIRECTOR OBRA'!$E$18","v":2},"(0, (PEM*C.O./(Nº meses*250.000))",0,{"$f":"'E2 DIRECTOR OBRA'!$H$18","v":5},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G20+1/3*(H20-G20)),0)))","v":2},20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$G20,\"ERROR\",IF(E20>$H20,\"ERROR\",IF(E20<=$I20,$J20+(0.2*$J20*ABS(E20-$I20)/ABS($G20-$I20)),$J20*ABS($H20-E20)/ABS($H20-$I20)))))))","v":20},null,null,null,"No requiere acciones"]
[null,"E6.6","I-","Nº de no conformidades detectadas/mes (*)",{"$f":"'E1 ASISTENCIA TECNICA'!$E$16","v":4},"(0, (PEM*C.O./(Nº meses*100000)))",0,{"$f":"'E1 ASISTENCIA TECNICA'!$H$16","v":12},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G21+1/3*(H21-G21)),0)))","v":4},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$G21,\"ERROR\",IF(E21>$H21,\"ERROR\",IF(E21<=$I21,$J21+(0.2*$J21*ABS(E21-$I21)/ABS($G21-$I21)),$J21*ABS($H21-E21)/ABS($H21-$I21)))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E6.7","I+","Nº de no conformidades resueltas/mes (*)",{"$f":"'E1 ASISTENCIA TECNICA'!$E$17","v":3},"(0, nº de no conformidades)",0,{"$f":"'E1 ASISTENCIA TECNICA'!$H$17","v":4},{"$f":"ROUNDUP((G22+2/3*(H22-G22)),0)","v":3},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E22=\"\",\"\",IF(G22=H22,(J22*1.2),IF(E22<$G22,\"ERROR\",IF(E22>$H22,\"ERROR\",IF(E22>=$I22,$J22+(0.2*$J22*ABS(E22-$I22)/ABS($H22-$I22)),$J22*ABS($G22-E22)/ABS($G22-$I22))))))))","v":5},null,null,null,"No requiere acciones"]
[null,"E6.8","I-","Nº de no conformidades pendientes /mes (*)",{"$f":"'E1 ASISTENCIA TECNICA'!$E$18","v":1},"(0, diferencia entre detectadas y resueltas)",0,{"$f":"'E1 ASISTENCIA TECNICA'!$H$18","v":1},{"$f":"ROUNDUP((G23+1/3*(H23-G23)),0)","v":1},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(G23=H23,(J23*1.2),IF(E23<$G23,\"ERROR\",IF(E23>$H23,\"ERROR\",IF(E23<=$I23,$J23+(0.2*$J23*ABS(E23-$I23)/ABS($G23-$I23)),$J23*ABS($H23-E23)/ABS($H23-$I23))))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E6.9","I-","Nº de acciones de doble control/mes (*)",{"$f":"'E1 ASISTENCIA TECNICA'!$E$19","v":1},"(0, No conformidades/3)",0,{"$f":"'E1 ASISTENCIA TECNICA'!$H$19","v":2},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G24+1/3*(H24-G24)),0)))","v":1},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E24=\"\",\"\",IF(G24=H24,(I24*1.2),IF(E24<$G24,\"ERROR\",IF(E24>$H24,\"ERROR\",IF(E24<=$I24,$J24+(0.2*$J24*ABS(E24-$I24)/ABS($G24-$I24)),$J24*ABS($H24-E24)/ABS($H24-$I24))))))))","v":10},null,null,null,"No requiere acciones"]
[null,"E6.10","I-","Nº de acciones de triple (o +) control/mes (*)",{"$f":"'E1 ASISTENCIA TECNICA'!$E$20","v":1},"(0, No conformidades/6)",0,{"$f":"'E1 ASISTENCIA TECNICA'!$H$20","v":2},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((G25+1/3*(H25-G25)),0)))","v":1},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E25=\"\",\"\",IF(E25<$G25,\"ERROR\",IF(E25>$H25,\"ERROR\",IF(E25<=$I25,$J25+(0.2*$J25*ABS(E25-$I25)/ABS($G25-$I25)),$J25*ABS($H25-E25)/ABS($H25-$I25)))))))","v":10},null,null,null,"No requiere acciones"]
[null,null,null,"(*)Corregir con acumuladas. Datos en gris provienen de otro Grupo",null,null,null,null,null,{"$f":"SUM(J16:J25)","v":100},{"$f":"SUM(K16:K25)","v":100},10,{"$f":"$L26*K26/100","v":10},{"$f":"M26/L26","v":1}]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E1 AL IC",null,null,null,null,null,null,{"$f":"$K$26","v":100}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,null,null,null,null,null,null,null,"A","Buena calidad"]
[null,null,null,null,null,null,null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,null,null,null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,"D","Mala calidad"]

{"sheet":"ÍNDICE DE CALIDAD","index":8,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,"PROYECTO/OBRA"]
[]
[null,null,{"$f":"'DATOS GENERALES'!D7","v":"DATOS OBLIGATORIOS"}]
[null,null,{"$f":"'DATOS GENERALES'!D8","v":"REFERENCIA:"},{"$f":"'DATOS GENERALES'!E8","v":"Obra Ejemplo €"}]
[null,null,{"$f":"'DATOS GENERALES'!D9","v":"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en euros"},{"$f":"'DATOS GENERALES'!E9","v":10000000}]
[null,null,{"$f":"'DATOS GENERALES'!D10","v":"TIEMPO DE DURACIÓN en meses"},{"$f":"'DATOS GENERALES'!E10","v":18}]
[null,null,{"$f":"'DATOS GENERALES'!D11","v":"COMPLEJIDAD ORGANIZATIVA DE LA OBRA"},{"$f":"'DATOS GENERALES'!E11","v":2}]
[null,null,null,null,"  IC parcial","Peso del grupo","Peso real del grupo"]
[null,null,"FASE PROYECTO"]
[]
[null,null,"P1 INDICADORES PROYECTISTA",null,{"$f":"'P1 P2 PROYECTO'!$K$22","v":77},{"$f":"'P1 P2 PROYECTO'!$L$22","v":20}]
[null,null,"P2 INDICADORES SUPERVISORES PROYECTO",null,{"$f":"'P1 P2 PROYECTO'!$K$28","v":23},{"$f":"'P1 P2 PROYECTO'!$L$28","v":5}]
[null,null,"PESO INDICADORES DE PROYECTO",null,{"$f":"E15+E16","v":100},{"$f":"F15+F16","v":25},{"$f":"E17*F17/100","v":25}]
[]
[null,null,"FASE EJECUCIÓN"]
[null,null,"E1INDICADORES ASISTENCIA TÉCNICA",null,{"$f":"'E1 ASISTENCIA TECNICA'!$K$26","v":100},{"$f":"'E1 ASISTENCIA TECNICA'!$L$25","v":15},{"$f":"E20*F20/100","v":15}]
[null,null,"E2 INDICADORES DIRECTOR OBRA",null,{"$f":"'E2 DIRECTOR OBRA'!$K$27","v":100},{"$f":"'E2 DIRECTOR OBRA'!$L$26","v":10},{"$f":"E21*F21/100","v":10}]
[null,null,"E3  INDICADORES DIRECTOR EJECUCIÓN OBRA",null,{"$f":"'E3 DIRECTOR EJECUCION'!$K$28","v":100},{"$f":"'E3 DIRECTOR EJECUCION'!$L$27","v":10},10]
[null,null,"E4  INDICADORES LABORATORIO DE ENSAYOS",null,{"$f":"'E4 LABORATORIO DE ENSAYOS'!$K$24","v":100},{"$f":"'E4 LABORATORIO DE ENSAYOS'!$L$23","v":10},10]
[null,null,"E5 INDICADORES EMPRESA CONSTRUCTORA",null,{"$f":"'E5 EMPRESA CONSTRUCTORA'!$K$25","v":100},{"$f":"'E5 EMPRESA CONSTRUCTORA'!$L$24","v":20},20]
[null,null,"E6INDICADORES SUPERVISORES EJECUCIÓN",null,{"$f":"'E6 SUPERVISORES EJECUCION'!$K$27","v":100},{"$f":"'E6 SUPERVISORES EJECUCION'!$L$26","v":10},{"$f":"E25*F25/100","v":10}]
[]
[null,null,"TOTAL PESO INDICADORES",null,null,{"$f":"SUM(F17:F26)","v":100},{"$f":"SUM(G17:G26)","v":100}]
[]
[]
[null,null,"ÍNDICE DE CALIDAD",null,null,null,{"$f":"G24+G23+G20+G22+G21+G25+G17","v":100}]
[]
[null,null,null,null,"LEYENDA"]
[null,null,null,null,"A","Buena calidad"]
[null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,"D","Mala calidad"]

{"sheet":"ETIQUETA DE CALIDAD","index":9,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"LEYENDA"]
[null,null,null,null,"A","Buena calidad +"]
[null,null,null,null,"B","Buena calidad"]
[null,null,null,null,"C","Calidad aceptable +"]
[null,null,null,null,"D","Calidad aceptable"]
[]
[]
[]
[null,null,"ETIQUETA DE CALIDAD"]
[null,null,"Obra: ",{"$f":"'DATOS GENERALES'!$E$8","v":"Obra Ejemplo €"},"IC=",{"$f":"VALUE('ÍNDICE DE CALIDAD'!$G$30)","v":100}]
[]
[]
[null,null,{"$f":"IF((90<VALUE($F$10))*AND(VALUE($F$10)<=93),VALUE($F$10),\" \")","v":" "},{"$f":"IF((93<VALUE($F$10))*AND(VALUE($F$10)<=99),VALUE($F$10),\" \")","v":" "},{"$f":"IF((99<VALUE($F$10))*AND(VALUE($F$10)<108),VALUE($F$10),\" \")","v":100},{"$f":"IF((108<=VALUE($F$10))*AND(VALUE($F$10)<=120),VALUE($F$10),\" \")","v":" "}]
[null,null,"Aceptable","Aceptable +","Buena","Buena+"]
[null,null,"90 a 93","93 a 99","99 a 108","108 a 120"]