{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["DATOS GENERALES","P1 P2 PROYECTO","E1 SUPERVISORES EJECUCION","E2 DIRECTOR OBRA","E3 DIRECTOR EJECUCION","E4 ASISTENCIA TECNICA","E5 LABORATORIO DE ENSAYOS","E6 EMPRESA CONSTRUCTORA","IC OBRA A","ETIQUETA DE CALIDAD","CUADRO DE MANDO"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DATOS GENERALES","index":0,"n_rows":31,"n_cols":8,"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,"DATOS OBLIGATORIOS",null,null,"OTROS DATOS:"]
[null,null,null,"REF:","OBRA A",null,"Obras de urbanización"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79,null,"Año de construcción: 2010"]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[]
[]
[]
[]
[]
[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":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,"DATOS OBLIGATORIOS",null,null,null,null,null,null,"LEYENDA"]
[null,null,null,"REF:","OBRA A",null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79,null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12,null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[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",12,"(0,PEM/1000000)",0,{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/150000),0))","v":24},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G16+1/3*(H16-G16)),0))","v":8},10,{"$f":"IF(E9=\"\",\"\",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":7.5},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":"Requiere acciones correctoras"}]
[null,"P1.2","I-","Número de complementos solicitados",2,"(0,PEM/2000000)",0,{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/1000000),0))","v":4},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G17+1/3*(H17-G17)),0))","v":2},10,{"$f":"IF(E9=\"\",\"\",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",10,"(0,PEM/2000000)",0,{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/150000),0))","v":24},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G18+1/3*(H18-G18)),0))","v":8},20,{"$f":"IF(E9=\"\",\"\",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":17.5},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":"Requiere acciones correctoras"}]
[null,"P1.4","I-","Días de respuesta a las solicitudes por parte del proyectista",5,"(1, PEM/suma de solicitudes)",0,{"$f":"16","v":16},{"$f":"ROUNDUP((G19+1/3*(H19-G19)),0)","v":6},20,{"$f":"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":20.666666666666668},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":"Valorar acciones de estímulo"}]
[null,"P1.5","I+","% PEM destinado al Plan de Control",1.25,"SI PEM (O, 300000);(1.5,3) SI PEM (300000, 1000000);(1,2) SI PEM>1000000;(0,5-1,5)",0.5,1.25,{"$f":"G20+2/3*(H20-G20)","v":1},12,{"$f":"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":14.4},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":"Valorar acciones de estímulo"}]
[null,"P1.6","I+","Número de documentos complementarios/voluntarios",0,"(0,PEM/1000000)",0,{"$f":"IF(E9=\"\",\"\",ROUNDUP(($E$9/4000000),0))","v":1},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G21+2/3*(H21-G21)),0))","v":1},5,{"$f":"IF(E9=\"\",\"\",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":0},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":"Requiere acciones correctoras"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J21)","v":77},{"$f":"SUM(K16:K21)","v":70.066666666666677},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)",2,"(PEM/750000, PEM/500000)",{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/2000000),0))","v":2},{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/500000),0))","v":7},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G25+1/3*(H25-G25)),0))","v":4},10,{"$f":"IF(E9=\"\",\"\",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":12},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":"Valorar acciones de estímulo"}]
[null,"P2.2","I-","Tiempo de redacción del informe de supervisión (horas)",4,"(PEM/1000000, PEM/750000)",{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/1000000),0))","v":4},{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/750000),0))","v":5},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G26+1/3*(H26-G26)),0))","v":5},8,{"$f":"IF(E9=\"\",\"\",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":9.6},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":"Valorar acciones de estímulo"}]
[null,"P2.3","I-","Tiempo de comunicación al proyectista de las solicitudes (días laborables)",1,"(1, 3)",1,3,2,5,{"$f":"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":6},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":"Valorar acciones de estímulo"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J25:J27)","v":23},{"$f":"SUM(K25:K27)","v":27.6},5]
[null,null,null,null,null,null,null,null,null,{"$f":"J22+J28","v":100},{"$f":"K22+K28","v":97.666666666666686},{"$f":"L22+L28","v":25},{"$f":"$L29*K29/100","v":24.416666666666671},{"$f":"M29/L29","v":0.9766666666666669}]
[]
[null,null,null,"CONTRIBUCIÓN DEL PROYECTO AL IC",null,null,null,null,null,null,{"$f":"$K$29","v":97.666666666666686}]

{"sheet":"E1 SUPERVISORES EJECUCION","index":2,"n_rows":28,"n_cols":37,"rows_kept":28,"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,null,"REF:","OBRA A"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,"Ref","TIPO","E1 INDICADORES SUPERVISORES EJECUCIÓN","MES 1","MES 2","MES 3","MES 4","MES 5","MES 6","MES 7","MES 8","MES 9","MES 10","MES 11","MES 12","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","Preal MES 1","Preal MES 2","Preal MES 3","Preal MES 4","Preal MES 5","Preal MES 6","Preal MES 7","PrealL MES 8","Preal MES 9","Preal Mes 10","Preal Mes 11","Preal Mes 12","Peso del grupo E1","Peso real grupo E1","Desviación del IC","ACCIONES MES 1"]
[null,"E1.1","I-","% Cumplimiento cuantitativo del plan de control/mes (€)",0.9,1.05,0.75,0.75,0.8,1,0.9,1.05,0.95,1,0.75,1.2,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,10,{"$f":"IF(E16=\"\",\"\",IF(E16<$R16,\"ERROR\",IF(E16>$S16,\"ERROR\",IF(E16<=$T16,$U16+(0.2*$U16*ABS(E16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-E16)/ABS($S16-$T16)))))","v":10.8},{"$f":"IF(F16=\"\",\"\",IF(F16<$R16,\"ERROR\",IF(F16>$S16,\"ERROR\",IF(F16<=$T16,$U16+(0.2*$U16*ABS(F16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-F16)/ABS($S16-$T16)))))","v":7.9999999999999982},12,12,11.6,10,10.8,7.9999999999999982,10.4,10,12,2.0000000000000018,null,null,null,{"$f":"IF(V16=\"\",\"\",IF(V16<$U16,\"Requiere acciones correctoras\",IF(V16>$U16,\"Valorar acciones de estímulo\",IF(V16=$U16,\"No requiere acciones\"))))","v":"Valorar acciones de estímulo"}]
[null,"E1.2","I+","% de resultados aceptados/mes",1,0.75,0.85,0.6,0.75,0.7,0.9,0.85,0.8,0.9,0.75,1,"(NINGUNO, TODOS)",0,1,0.8,10,{"$f":"IF(E17=\"\",\"\",IF(E17<$R17,\"ERROR\",IF(E17>$S17,\"ERROR\",IF(E17>=$T17,$U17+(0.2*$U17*ABS(E17-$T17)/ABS($S17-$T17)),$U17*ABS($R17-E17)/ABS($R17-$T17)))))","v":12},{"$f":"IF(F17=\"\",\"\",IF(F17<$R17,\"ERROR\",IF(F17>$S17,\"ERROR\",IF(F17>=$T17,$U17+(0.2*$U17*ABS(F17-$T17)/ABS($S17-$T17)),$U17*ABS($R17-F17)/ABS($R17-$T17)))))","v":9.375},10.5,7.5,9.375,8.75,11,10.5,10,11,9.375,12,null,null,null,"Valorar acciones de estímulo"]
[null,"E1.3","I-","% de resultados rechazados/mes",0.15,0.25,0.15,0.7,0.9,0.85,0.8,0.9,0.75,1,0.3,0.5,"(NINGUNO, TODOS)",0,1,0.2,10,{"$f":"IF(E18=\"\",\"\",IF(E18<$R18,\"ERROR\",IF(E18>$S18,\"ERROR\",IF(E18<=$T18,$U18+(0.2*$U18*ABS(E18-$T18)/ABS($R18-$T18)),$U18*ABS($S18-E18)/ABS($S18-$T18)))))","v":10.5},{"$f":"IF(F18=\"\",\"\",IF(F18<$R18,\"ERROR\",IF(F18>$S18,\"ERROR\",IF(F18<=$T18,$U18+(0.2*$U18*ABS(F18-$T18)/ABS($R18-$T18)),$U18*ABS($S18-F18)/ABS($S18-$T18)))))","v":9.375},10.5,3.7500000000000004,1.2499999999999996,1.8750000000000002,2.4999999999999991,1.2499999999999996,3.125,0,8.75,6.25,null,null,null,"Valorar acciones de estímulo"]
[null,"E1.4","I-","Nº de acciones que necesitan modificación de ejecución/mes",3,2,2,1,2,1,2,3,3,3,2,2,"(0, (PEM/(Nº meses*20000))*1,33)",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R19+1/3*(S19-R19)),0)))","v":2},10,{"$f":"IF(E19=\"\",\"\",IF(E19<$R19,\"ERROR\",IF(E19>$S19,\"ERROR\",IF(E19<=$T19,$U19+(0.2*$U19*ABS(E19-$T19)/ABS($R19-$T19)),$U19*ABS($S19-E19)/ABS($S19-$T19)))))","v":7.5},10,10,11,10,11,10,7.5,7.5,7.5,10,10,null,null,null,"Requiere acciones correctoras"]
[null,"E1.5","I-","Nº de acciones que necesitan modificación presupuesto/mes",0,1,3,1,2,3,1,2,1,2,0,2,"(0, (PEM/(Nº meses*20000)))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*100000)),0)))","v":3},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R20+1/3*(S20-R20)),0)))","v":1},20,{"$f":"IF(E20=\"\",\"\",IF(E20<$R20,\"ERROR\",IF(E20>$S20,\"ERROR\",IF(E20<=$T20,$U20+(0.2*$U20*ABS(E20-$T20)/ABS($R20-$T20)),$U20*ABS($S20-E20)/ABS($S20-$T20)))))","v":24},20,0,20,10,0,20,10,20,10,24,10,null,null,null,"Valorar acciones de estímulo"]
[null,"E1.6","I-","Nº de no conformidades detectadas/mes (*)",34,25,18,12,14,10,15,11,8,18,10,12,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*5000)),0)))","v":58},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R21+1/3*(S21-R21)),0)))","v":20},5,3.1578947368421053,4.3421052631578947,5.0999999999999996,5.4,5.3,5.5,5.25,5.45,5.6,5.0999999999999996,5.5,5.4,null,null,null,"Requiere acciones correctoras"]
[null,"E1.7","I+","Nº de no conformidades resueltas/mes (*)",16,16,10,12,11,1,0,9,14,10,12,10,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"E21","v":34},{"$f":"ROUNDUP((R22+2/3*(S22-R22)),0)","v":23},5,{"$f":"IF(E22=\"\",\"\",IF(E22<$R22,\"ERROR\",IF(E22>$S22,\"ERROR\",IF(E22>=$T22,$U22+(0.2*$U22*ABS(E22-$T22)/ABS($S22-$T22)),$U22*ABS($R22-E22)/ABS($R22-$T22)))))","v":3.4782608695652173},3.4782608695652173,2.1739130434782608,2.6086956521739131,2.3913043478260869,0.21739130434782608,0,1.9565217391304348,3.0434782608695654,2.1739130434782608,2.6086956521739131,{"$f":"IF(P22=\"\",\"\",IF(P22<$R22,\"ERROR\",IF(P22>$S22,\"ERROR\",IF(P22>=$T22,$U22+(0.2*$U22*ABS(P22-$T22)/ABS($S22-$T22)),$U22*ABS($R22-P22)/ABS($R22-$T22)))))","v":2.1739130434782608},null,null,null,"Requiere acciones correctoras"]
[null,"E1.8","I-","Nº de no conformidades pendientes /mes (*)",18,9,15,3,4,5,6,7,8,4,6,6,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"E21","v":34},{"$f":"ROUNDUP((R23+1/3*(S23-R23)),0)","v":12},10,{"$f":"IF(E23=\"\",\"\",IF(E23<$R23,\"ERROR\",IF(E23>$S23,\"ERROR\",IF(E23<=$T23,$U23+(0.2*$U23*ABS(E23-$T23)/ABS($R23-$T23)),$U23*ABS($S23-E23)/ABS($S23-$T23)))))","v":7.2727272727272725},{"$f":"IF(F23=\"\",\"\",IF(F23<$R23,\"ERROR\",IF(F23>$S23,\"ERROR\",IF(F23<=$T23,$U23+(0.2*$U23*ABS(F23-$T23)/ABS($R23-$T23)),$U23*ABS($S23-F23)/ABS($S23-$T23)))))","v":10.5},8.6363636363636367,11.5,11.333333333333334,11.166666666666666,11,10.833333333333334,10.666666666666666,11.333333333333334,11,11,null,null,null,"Requiere acciones correctoras"]
[null,"E1.9","I-","Nº de acciones de doble control/mes (*)",4,8,6,4,5,6,7,8,4,2,3,4,"(0, (PEM/(Nº meses*5000)*)1/3)",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((S21/3),0)))","v":20},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R24+1/3*(S24-R24)),0)))","v":7},10,{"$f":"IF(E24=\"\",\"\",IF(E24<$R24,\"ERROR\",IF(E24>$S24,\"ERROR\",IF(E24<=$T24,$U24+(0.2*$U24*ABS(E24-$T24)/ABS($R24-$T24)),$U24*ABS($S24-E24)/ABS($S24-$T24)))))","v":10.857142857142858},9.2307692307692299,10.285714285714286,10.857142857142858,10.571428571428571,10.285714285714286,10,9.2307692307692299,10.857142857142858,11.428571428571429,11.142857142857142,10.857142857142858,null,null,null,"Valorar acciones de estímulo"]
[null,"E1.10","I-","Nº de acciones de triple (o +) control/mes (*)",1,4,2,0,1,2,3,4,5,3,2,3,"(0, (PEM/(Nº meses*5000)*)1/6)",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((S21/6),0)))","v":10},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R25+1/3*(S25-R25)),0)))","v":4},10,{"$f":"IF(E25=\"\",\"\",IF(E25<$R25,\"ERROR\",IF(E25>$S25,\"ERROR\",IF(E25<=$T25,$U25+(0.2*$U25*ABS(E25-$T25)/ABS($R25-$T25)),$U25*ABS($S25-E25)/ABS($S25-$T25)))))","v":11.5},10,11,12,11.5,11,10.5,10,8.3333333333333339,10.5,11,10.5,null,null,null,"Valorar acciones de estímulo"]
[null,null,null,"IC´s PARCIALES DELGRUPO E1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U16:U25)","v":100},{"$f":"SUM(V16:V25)","v":101.06602573627745},{"$f":"SUM(W16:W25)","v":94.301135363492335},80.195990965556192,96.615838509316774,83.321066252587997,69.794772256728777,91.05,74.720624303233009,89.525621118012424,79.035817805383019,105.37655279503105,80.181055900621118,15,{"$f":"AG28*AH26/100","v":13.064806262577997}]
[null,null,null,"(*)Corregir con acumuladas"]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E1 AL IC",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":"(SUM(V26:AG26))/12","v":87.098708417186643}]

{"sheet":"E2 DIRECTOR OBRA","index":3,"n_rows":28,"n_cols":37,"rows_kept":28,"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,null,null,null,null,"LEYENDA"]
[null,null,null,"REF:","OBRA A",null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79,null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12,null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E2 INDICADORES DIRECTOR OBRA","MES 1","MES2","MES 3","MES 4","MES 5","MES 6","MES 7","MES 8","MES 9","MES 10","MES 11","MES 12","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","Preal MES 1","Preal MES 2","Preal MES 3","Preal MES 4","Preal MES 5","Preal MES 6","Preal MES 7","PrealL MES 8","Preal MES 9","Preal Mes 10","Preal Mes 11","Preal Mes 12","Peso del grupo E2","Peso real del grupo E2","Desviación del IC","ACCIONES Mes 1"]
[null,"E2.1","I-","Nº de correcciones del proyecto/mes",1,1,1,0,1,2,3,2,2,1,1,0,"(0, (PEM/(Nº meses*250000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R16+1/3*(S16-R16)),0)))","v":2},15,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E16=\"\",\"\",IF(E16<$R16,\"ERROR\",IF(E16>$S16,\"ERROR\",IF(E16<=$T16,$U16+(0.2*$U16*ABS(E16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-E16)/ABS($S16-$T16)))))))","v":16.5},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F16=\"\",\"\",IF(F16<$R16,\"ERROR\",IF(F16>$S16,\"ERROR\",IF(F16<=$T16,$U16+(0.2*$U16*ABS(F16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-F16)/ABS($S16-$T16)))))))","v":16.5},16.5,18,16.5,15,11.25,15,15,16.5,16.5,18,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U16,\"Requiere acciones correctoras\",IF(#REF!>$U16,\"Valorar acciones de estímulo\",IF(#REF!=$U16,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.2","I-","Nº de correcciones de la ejecución/mes. IGUAL QUE E1.4",1,2,4,1,2,3,4,0,0,2,2,2,"(0, (PEM/(Nº meses*150000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R17+1/3*(S17-R17)),0)))","v":2},10,11,10,5,11,10,7.5,5,12,12,10,10,10,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U17,\"Requiere acciones correctoras\",IF(#REF!>$U17,\"Valorar acciones de estímulo\",IF(#REF!=$U17,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.3","I-","Nº de modificaciones del presupuesto/mes.  IGUAL QUE E1.5",1,1,1,1,2,1,2,1,2,1,2,3,"(0, (PEM/(Nº meses*250000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*100000)),0)))","v":3},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R18+1/3*(S18-R18)),0)))","v":1},10,10,10,10,10,5,10,5,10,5,10,5,0,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U18,\"Requiere acciones correctoras\",IF(#REF!>$U18,\"Valorar acciones de estímulo\",IF(#REF!=$U18,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.4","I+","Nº de instrucciones de modificación Libro Órdenes/mes",3,3,2,2,3,4,3,2,1,2,3,2,"(0, (PEM/(Nº meses*150000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*75000)),0)))","v":4},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R19+2/3*(S19-R19)),0)))","v":3},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$R19,\"ERROR\",IF(E19>$S19,\"ERROR\",IF(E19>=$T19,$U19+(0.2*$U19*ABS(E19-$T19)/ABS($S19-$T19)),$U19*ABS($R19-E19)/ABS($R19-$T19)))))))","v":5},5,3.3333333333333335,3.3333333333333335,5,6,5,3.3333333333333335,1.6666666666666667,3.3333333333333335,5,3.3333333333333335,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U19,\"Requiere acciones correctoras\",IF(#REF!>$U19,\"Valorar acciones de estímulo\",IF(#REF!=$U19,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.5","I+","Nº de apuntes (seguimiento) Libro Órdenes/mes",6,4,2,4,5,6,7,8,7,6,5,6,"(1, (PEM/(Nº meses*75000))",1,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*40000)),0)))","v":8},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R20+2/3*(S20-R20)),0)))","v":6},10,10,6,2,6,8,10,11,12,11,10,8,10,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U20,\"Requiere acciones correctoras\",IF(#REF!>$U20,\"Valorar acciones de estímulo\",IF(#REF!=$U20,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.6","I+","Nº de visitas/reuniones de obra/mes",6,4,2,6,5,4,5,6,7,8,7,6,"(1, (PEM/(Nº meses*75000))",1,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*40000)),0)))","v":8},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R21+2/3*(S21-R21)),0)))","v":6},5,5,3,1,5,4,3,4,5,5.5,6,5.5,5,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U21,\"Requiere acciones correctoras\",IF(#REF!>$U21,\"Valorar acciones de estímulo\",IF(#REF!=$U21,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.7","I+","Nº de informes de control para el promotor/mes",4,2,1,5,5,6,7,6,5,4,5,6,"(0, (PEM/(Nº meses*150000))",1,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R22+2/3*(S22-R22)),0)))","v":5},15,11.25,3.75,0,15,15,18,"ERROR",18,15,11.25,15,18,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U22,\"Requiere acciones correctoras\",IF(#REF!>$U22,\"Valorar acciones de estímulo\",IF(#REF!=$U22,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.8","I-","Nº de instrucciones del coordinador de seguridad laboral/mes ",2,3,4,2,3,4,2,3,1,3,2,2,"(0, (PEM/(Nº meses*150000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*75000)),0)))","v":4},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R23+1/3*(S23-R23)),0)))","v":2},20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$R23,\"ERROR\",IF(E23>$S23,\"ERROR\",IF(E23<=$T23,$U23+(0.2*$U23*ABS(E23-$T23)/ABS($R23-$T23)),$U23*ABS($S23-E23)/ABS($S23-$T23)))))))","v":20},10,0,20,10,0,20,10,22,10,20,20,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U23,\"Requiere acciones correctoras\",IF(#REF!>$U23,\"Valorar acciones de estímulo\",IF(#REF!=$U23,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.9","I-","Nº de recomendaciones de la Asistencia Técnica/mes",10,10,10,8,9,10,10,12,11,10,16,15,"(0, (PEM/(Nº meses*20000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*10000)),0)))","v":29},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R24+1/3*(S24-R24)),0)))","v":10},5,5,5,5,5.2,5.0999999999999996,5,5,4.4736842105263159,4.7368421052631575,5,3.4210526315789473,3.6842105263157894,null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U24,\"Requiere acciones correctoras\",IF(#REF!>$U24,\"Valorar acciones de estímulo\",IF(#REF!=$U24,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,"E2.10","I+","% de recomendaciones de la Asistencia Técnica consideradas/mes",10,5,3,10,12,13,16,18,19,15,20,19,"(0, (PEM/(Nº meses*25000))",0,{"$f":"E24","v":10},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R25+2/3*(S25-R25)),0)))","v":7},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E25=\"\",\"\",IF(E25<$R25,\"ERROR\",IF(E25>$S25,\"ERROR\",IF(E25>=$T25,$U25+(0.2*$U25*ABS(E25-$T25)/ABS($S25-$T25)),$U25*ABS($R25-E25)/ABS($R25-$T25)))))))","v":6},3.5714285714285716,2.1428571428571428,6,"ERROR","ERROR","ERROR","ERROR","ERROR","ERROR","ERROR","ERROR",null,null,null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<$U25,\"Requiere acciones correctoras\",IF(#REF!>$U25,\"Valorar acciones de estímulo\",IF(#REF!=$U25,\"No requiere acciones\"))))","v":{"$error":"#REF!"}}]
[null,null,null,"IC´s PARCIALES DELGRUPO E2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U16:U25)","v":100},99.75,72.821428571428569,44.976190476190482,99.533333333333346,78.599999999999994,74.5,66.25,89.807017543859658,91.903508771929808,82.083333333333343,88.421052631578945,88.017543859649123,10,{"$f":"AG28*AH26/100","v":8.1388617376775283}]
[]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E2 AL IC",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":"(SUM(V26:AG26))/12","v":81.388617376775272}]

{"sheet":"E3 DIRECTOR EJECUCION","index":4,"n_rows":28,"n_cols":37,"rows_kept":28,"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,null,null,null,null,"LEYENDA"]
[null,null,null,"REF:","OBRA A",null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79,null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12,null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E3  INDICADORES DIRECTOR EJECUCIÓN OBRA","MES 1","MES2","MES 3","MES 4","MES 5","MES 6","MES 7","MES 8","MES 9","MES 10","MES 11","MES 12","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","Preal MES 1","Preal MES 2","Preal MES 3","Preal MES 4","Preal MES 5","Preal MES 6","Preal MES 7","PrealL MES 8","Preal MES 9","Preal Mes 10","Preal Mes 11","Preal Mes 12","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F16=\"\",\"\",IF(F16<$R16,\"ERROR\",IF(F16>$S16,\"ERROR\",IF(F16<=$T16,$U16+(0.2*$U16*ABS(F16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-F16)/ABS($S16-$T16)))))))","v":""},"","","","","","","","","",""]
[null,"E3.1","I-","Nº de materiales rechazados/mes por doc. incompleta",2,3,4,5,4,7,1,5,4,3,2,0,"(0, Total mat)",0,{"$f":"E16","v":10},{"$f":"ROUNDUP((R17+1/3*(S17-R17)),0)","v":4},10,{"$f":"IF(E17=\"\",\"\",IF(E17<$R17,\"ERROR\",IF(E17>$S17,\"ERROR\",IF(E17<=$T17,$U17+(0.2*$U17*ABS(E17-$T17)/ABS($R17-$T17)),$U17*ABS($S17-E17)/ABS($S17-$T17)))))","v":11},{"$f":"IF(F17=\"\",\"\",IF(F17<$R17,\"ERROR\",IF(F17>$S17,\"ERROR\",IF(F17<=$T17,$U17+(0.2*$U17*ABS(F17-$T17)/ABS($R17-$T17)),$U17*ABS($S17-F17)/ABS($S17-$T17)))))","v":10.5},10,8.3333333333333339,10,5,11.5,8.3333333333333339,10,10.5,11,12,null,null,null,{"$f":"IF(V17=\"\",\"\",IF(V17<$U17,\"Requiere acciones correctoras\",IF(V17>$U17,\"Valorar acciones de estímulo\",IF(V17=$U17,\"No requiere acciones\"))))","v":"Valorar acciones de estímulo"}]
[null,"E3.2","I+","Nº de materiales aceptados/mes",8,7,6,5,6,3,9,5,6,7,8,10,"(0, Total mat)",0,{"$f":"E16","v":10},{"$f":"ROUNDUP((R18+2/3*(S18-R18)),0)","v":7},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(E18<$R18,\"ERROR\",IF(E18>$S18,\"ERROR\",IF(E18>=$T18,$U18+(0.2*$U18*ABS(E18-$T18)/ABS($S18-$T18)),$U18*ABS($R18-E18)/ABS($R18-$T18)))))))","v":5.333333333333333},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F18=\"\",\"\",IF(F18<$R18,\"ERROR\",IF(F18>$S18,\"ERROR\",IF(F18>=$T18,$U18+(0.2*$U18*ABS(F18-$T18)/ABS($S18-$T18)),$U18*ABS($R18-F18)/ABS($R18-$T18)))))))","v":5},4.2857142857142856,3.5714285714285716,4.2857142857142856,2.1428571428571428,5.666666666666667,3.5714285714285716,4.2857142857142856,5,5.333333333333333,6,null,null,null,"Valorar acciones de estímulo"]
[null,"E3.3","I-","Nº de solicitudes complementarias de doc. de materiales",5,3,3,3,2,1,2,1,3,2,1,0,"(0, Total mat)",0,{"$f":"E16","v":10},{"$f":"ROUNDUP((R19+1/3*(S19-R19)),0)","v":4},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$R19,\"ERROR\",IF(E19>$S19,\"ERROR\",IF(E19<=$T19,$U19+(0.2*$U19*ABS(E19-$T19)/ABS($R19-$T19)),$U19*ABS($S19-E19)/ABS($S19-$T19)))))))","v":4.166666666666667},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F19=\"\",\"\",IF(F19<$R19,\"ERROR\",IF(F19>$S19,\"ERROR\",IF(F19<=$T19,$U19+(0.2*$U19*ABS(F19-$T19)/ABS($R19-$T19)),$U19*ABS($S19-F19)/ABS($S19-$T19)))))))","v":5.25},5.25,5.25,5.5,5.75,5.5,5.75,5.25,5.5,5.75,6,null,null,null,"Requiere acciones correctoras"]
[null,"E3.4","I-","Nº de correcciones de la ejecución/mes",1,2,5,4,3,2,3,2,1,0,3,2,"(0, (PEM/(Nº meses*150000))*1,33)",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*75000)),0)))","v":4},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R20+1/3*(S20-R20)),0)))","v":2},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$R20,\"ERROR\",IF(E20>$S20,\"ERROR\",IF(E20<=$T20,$U20+(0.2*$U20*ABS(E20-$T20)/ABS($R20-$T20)),$U20*ABS($S20-E20)/ABS($S20-$T20)))))))","v":11},10,"ERROR",0,5,10,5,10,11,12,5,10,null,null,null,"Valorar acciones de estímulo"]
[null,"E3.5","I+","Nº de recomendaciones de la A. T. consideradas/mes",3,2,4,5,4,3,2,3,4,3,5,7,"(0, (PEM/(Nº meses*25000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*25000)),0)))","v":12},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R21+2/3*(S21-R21)),0)))","v":8},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$R21,\"ERROR\",IF(E21>$S21,\"ERROR\",IF(E21>=$T21,$U21+(0.2*$U21*ABS(E21-$T21)/ABS($S21-$T21)),$U21*ABS($R21-E21)/ABS($R21-$T21)))))))","v":1.875},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F21=\"\",\"\",IF(F21<$R21,\"ERROR\",IF(F21>$S21,\"ERROR\",IF(F21>=$T21,$U21+(0.2*$U21*ABS(F21-$T21)/ABS($S21-$T21)),$U21*ABS($R21-F21)/ABS($R21-$T21)))))))","v":1.25},2.5,3.125,2.5,1.875,1.25,1.875,2.5,1.875,3.125,4.375,null,null,null,"Requiere acciones correctoras"]
[null,"E3.6","I+","Nº de visitas/reuniones de obra",4,4,4,4,5,6,5,4,4,4,5,5,"(1, (PEM/(Nº meses*75000))",1,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R22+2/3*(S22-R22)),0)))","v":5},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E22=\"\",\"\",IF(E22<$R22,\"ERROR\",IF(E22>$S22,\"ERROR\",IF(E22>=$T22,$U22+(0.2*$U22*ABS(E22-$T22)/ABS($S22-$T22)),$U22*ABS($R22-E22)/ABS($R22-$T22)))))))","v":3.75},3.75,3.75,3.75,5,6,5,3.75,3.75,3.75,5,5,null,null,null,"Requiere acciones correctoras"]
[null,"E3.7","I-","Nº de recomendaciones del Coordinador de seguridad/mes",3,2,3,3,2,2,2,3,2,3,2,1,"(0, (PEM/(Nº meses*150000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*75000)),0)))","v":4},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R23+1/3*(S23-R23)),0)))","v":2},20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$R23,\"ERROR\",IF(E23>$S23,\"ERROR\",IF(E23<=$T23,$U23+(0.2*$U23*ABS(E23-$T23)/ABS($R23-$T23)),$U23*ABS($S23-E23)/ABS($S23-$T23)))))))","v":10},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F23=\"\",\"\",IF(F23<$R23,\"ERROR\",IF(F23>$S23,\"ERROR\",IF(F23<=$T23,$U23+(0.2*$U23*ABS(F23-$T23)/ABS($R23-$T23)),$U23*ABS($S23-F23)/ABS($S23-$T23)))))))","v":20},10,10,20,20,20,10,20,10,20,22,null,null,null,"Requiere acciones correctoras"]
[null,"E3.8","I-","% Ajuste en plazo de la aplicación del Plan de Control/mes",0.9,0.95,1,1,1.05,1.05,1,1.1000000000000001,1,1,1,1,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E24=\"\",\"\",IF(E24<$R24,\"ERROR\",IF(E24>$S24,\"ERROR\",IF(E24<=$T24,$U24+(0.2*$U24*ABS(E24-$T24)/ABS($R24-$T24)),$U24*ABS($S24-E24)/ABS($S24-$T24)))))))","v":21.6},20.8,20,20,15.999999999999996,15.999999999999996,20,11.999999999999993,20,20,20,20,null,null,null,"Valorar acciones de estímulo"]
[null,"E3.9","I-","% Ajuste en presupuesto de la aplicación del Plan de Control/mes",0.9,1.05,0.75,0.75,0.8,1,0.9,1.05,0.95,1,0.75,1.2,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E25=\"\",\"\",IF(E25<$R25,\"ERROR\",IF(E25>$S25,\"ERROR\",IF(E25<=$T25,$U25+(0.2*$U25*ABS(E25-$T25)/ABS($R25-$T25)),$U25*ABS($S25-E25)/ABS($S25-$T25)))))))","v":21.6},15.999999999999996,24,24,23.2,20,21.6,15.999999999999996,20.8,20,24,4.0000000000000036,null,null,null,"Valorar acciones de estímulo"]
[null,null,null,"IC´s PARCIALES DELGRUPO E3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U17:U25)","v":100},{"$f":"SUM(V17:V25)","v":90.324999999999989},{"$f":"SUM(W16:W25)","v":92.55},79.785714285714278,78.029761904761898,91.48571428571428,86.767857142857139,95.51666666666668,71.279761904761898,97.585714285714275,88.625,99.208333333333329,89.375,10,{"$f":"$AH26*V26/100","v":9.0324999999999989},{"$f":"AI26/AH26","v":0.90324999999999989}]
[]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E3 AL IC",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":"(SUM(V26:AG26))/12","v":88.377876984126985}]

{"sheet":"E4 ASISTENCIA TECNICA","index":5,"n_rows":28,"n_cols":37,"rows_kept":28,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,"REF:","OBRA A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E4 INDICADORES ASISTENCIA TÉCNICA","MES 1","MES 2","MES 3","MES 4 ","MES 5","MES 6","MES 7","MES 8","MES 9 ","MES 10 ","MES 11","MES 12","INTERVALO","MIN","MAX","ESTÁNDAR","Peso de referencia","PESO REAL MES 1","PESO REAL MES 2","PESO REAL MES 3","PESO REAL MES 4","PESO REAL MES 5","PESO REAL MES 6","PESO REAL MES 7","PESO REAL MES 8","PESO REAL MES 9","PESO REAL MES 10","PESO REAL MES 11","PESO REAL MES 12","Peso del grupo E4","Peso real del grupo E4","Desviación del IC","ACCIONES"]
[null,"E4.1","I-","Nº de no conformidades detectadas/mes (*)",18,15,10,13,12,11,13,14,13,12,11,6,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*15000)),0)))","v":20},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R16+1/3*(S16-R16)),0)))","v":7},10,{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(E16=\"\",\"\",IF(E16<$R16,\"ERROR\",IF(E16>$S16,\"ERROR\",IF(E16<=$T16,$U16+(0.2*$U16*ABS(E16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-E16)/ABS($S16-$T16)))))))","v":1.5384615384615385},{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(F16=\"\",\"\",IF(F16<$R16,\"ERROR\",IF(F16>$S16,\"ERROR\",IF(F16<=$T16,$U16+(0.2*$U16*ABS(F16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-F16)/ABS($S16-$T16)))))))","v":3.8461538461538463},7.6923076923076925,5.384615384615385,6.1538461538461542,6.9230769230769234,5.384615384615385,4.615384615384615,5.384615384615385,6.1538461538461542,6.9230769230769234,10.285714285714286,null,null,null,{"$f":"IF(V16=\"\",\"\",IF(V16<$U16,\"Requiere acciones correctoras\",IF(V16>$U16,\"Valorar acciones de estímulo\",IF(V16=$U16,\"No requiere acciones\"))))","v":"Requiere acciones correctoras"}]
[null,"E4.2","I+","Nº de no conformidades resueltas/mes (*)",16,15,11,12,14,11,12,11,14,12,11,8,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"E16","v":18},{"$f":"ROUNDUP((R17+2/3*(S17-R17)),0)","v":12},5,{"$f":"IF(E17=\"\",\"\",IF(E17<$R17,\"ERROR\",IF(E17>$S17,\"ERROR\",IF(E17>=$T17,$U17+(0.2*$U17*ABS(E17-$T17)/ABS($S17-$T17)),$U17*ABS($R17-E17)/ABS($R17-$T17)))))","v":5.666666666666667},{"$f":"IF(F17=\"\",\"\",IF(F17<$R17,\"ERROR\",IF(F17>$S17,\"ERROR\",IF(F17>=$T17,$U17+(0.2*$U17*ABS(F17-$T17)/ABS($S17-$T17)),$U17*ABS($R17-F17)/ABS($R17-$T17)))))","v":5.5},4.583333333333333,5,5.333333333333333,4.583333333333333,5,4.583333333333333,5.333333333333333,5,4.583333333333333,3.3333333333333335,null,null,null,"Valorar acciones de estímulo"]
[null,"E4.3","I-","Nº de no conformidades pendientes /mes (*)",{"$f":"E16-E17","v":2},{"$f":"E18+F16-F17","v":2},{"$f":"F18+G16-G17","v":1},{"$f":"G18+H16-H17","v":2},0,0,1,4,3,3,3,1,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"E16","v":18},{"$f":"ROUNDUP((R18+1/3*(S18-R18)),0)","v":6},10,{"$f":"IF(E18=\"\",\"\",IF(E18<$R18,\"ERROR\",IF(E18>$S18,\"ERROR\",IF(E18<=$T18,$U18+(0.2*$U18*ABS(E18-$T18)/ABS($R18-$T18)),$U18*ABS($S18-E18)/ABS($S18-$T18)))))","v":11.333333333333334},{"$f":"IF(F18=\"\",\"\",IF(F18<$R18,\"ERROR\",IF(F18>$S18,\"ERROR\",IF(F18<=$T18,$U18+(0.2*$U18*ABS(F18-$T18)/ABS($R18-$T18)),$U18*ABS($S18-F18)/ABS($S18-$T18)))))","v":11.333333333333334},11.666666666666666,11.333333333333334,12,12,11.666666666666666,10.666666666666666,11,11,11,11.666666666666666,null,null,null,"Valorar acciones de estímulo"]
[null,"E4.4","I-","Nº de acciones de doble control/mes (*)",4,4,2,6,3,4,6,2,4,7,6,4,"(0, No conformidades/3)",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((S16/3),0)))","v":7},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R19+1/3*(S19-R19)),0)))","v":3},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$R19,\"ERROR\",IF(E19>$S19,\"ERROR\",IF(E19<=$T19,$U19+(0.2*$U19*ABS(E19-$T19)/ABS($R19-$T19)),$U19*ABS($S19-E19)/ABS($S19-$T19)))))))","v":3.75},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F19=\"\",\"\",IF(F19<$R19,\"ERROR\",IF(F19>$S19,\"ERROR\",IF(F19<=$T19,$U19+(0.2*$U19*ABS(F19-$T19)/ABS($R19-$T19)),$U19*ABS($S19-F19)/ABS($S19-$T19)))))))","v":3.75},5.333333333333333,1.25,5,3.75,1.25,5.333333333333333,3.75,0,1.25,3.75,null,null,null,"Requiere acciones correctoras"]
[null,"E4.5","I-","Nº de acciones de triple (o +) control/mes (*)",1,2,1,1,1,2,3,1,2,3,3,2,"(0, No conformidades/6)",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((S16/6),0)))","v":4},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R20+1/3*(S20-R20)),0)))","v":2},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$R20,\"ERROR\",IF(E20>$S20,\"ERROR\",IF(E20<=$T20,$U20+(0.2*$U20*ABS(E20-$T20)/ABS($R20-$T20)),$U20*ABS($S20-E20)/ABS($S20-$T20)))))))","v":11},10,11,11,11,10,5,11,10,5,5,10,null,null,null,"Valorar acciones de estímulo"]
[null,"E4.6","I-","Nº de recomendaciones al director de obra/mes",8,4,7,7,8,6,5,5,7,4,5,7,"(0, (PEM/(Nº meses*20000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*20000)),0)))","v":15},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R21+1/3*(S21-R21)),0)))","v":5},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$R21,\"ERROR\",IF(E21>$S21,\"ERROR\",IF(E21<=$T21,$U21+(0.2*$U21*ABS(E21-$T21)/ABS($R21-$T21)),$U21*ABS($S21-E21)/ABS($S21-$T21)))))))","v":7},10.4,8,8,7,9,10,10,8,10.4,10,8,null,null,null,"Requiere acciones correctoras"]
[null,"E4.7","I-","Nº de recomendaciones del Coordinador de seguridad/mes",1,2,3,2,3,2,1,0,0,1,0,0,"(0, (PEM/(Nº meses*300000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R22+1/3*(S22-R22)),0)))","v":2},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E22=\"\",\"\",IF(E22<$R22,\"ERROR\",IF(E22>$S22,\"ERROR\",IF(E22<=$T22,$U22+(0.2*$U22*ABS(E22-$T22)/ABS($R22-$T22)),$U22*ABS($S22-E22)/ABS($S22-$T22)))))))","v":11},10,7.5,10,7.5,10,11,12,12,11,12,12,null,null,null,"Valorar acciones de estímulo"]
[null,"E4.8","I+","Nº de visitas/reuniones de obra/mes",1,6,5,6,1,6,4,4,4,4,5,6,"(1, (PEM/(Nº meses*75000))",1,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R23+2/3*(S23-R23)),0)))","v":5},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$R23,\"ERROR\",IF(E23>$S23,\"ERROR\",IF(E23>=$T23,$U23+(0.2*$U23*ABS(E23-$T23)/ABS($S23-$T23)),$U23*ABS($R23-E23)/ABS($R23-$T23)))))))","v":0},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F23=\"\",\"\",IF(F23<$R23,\"ERROR\",IF(F23>$S23,\"ERROR\",IF(F23>=$T23,$U23+(0.2*$U23*ABS(F23-$T23)/ABS($S23-$T23)),$U23*ABS($R23-F23)/ABS($R23-$T23)))))))","v":12},10,12,0,12,7.5,7.5,7.5,7.5,10,12,null,null,null,"Requiere acciones correctoras"]
[null,"E4.9","I-","Nº de comunicaciones fuera de plazo/mes",2,1,1,1,0,0,1,0,0,0,0,0,"(0, 5)",0,5,4,10,{"$f":"IF(E24=\"\",\"\",IF(E24<$R24,\"ERROR\",IF(E24>$S24,\"ERROR\",IF(E24<=$T24,$U24+(0.2*$U24*ABS(E24-$T24)/ABS($R24-$T24)),$U24*ABS($S24-E24)/ABS($S24-$T24)))))","v":11},{"$f":"IF(F24=\"\",\"\",IF(F24<$R24,\"ERROR\",IF(F24>$S24,\"ERROR\",IF(F24<=$T24,$U24+(0.2*$U24*ABS(F24-$T24)/ABS($R24-$T24)),$U24*ABS($S24-F24)/ABS($S24-$T24)))))","v":11.5},11.5,11.5,12,12,11.5,12,12,12,12,12,null,null,null,"Valorar acciones de estímulo"]
[null,"E4.10","I+","Nº de informes de control para el promotor/mes",2,4,4,4,4,4,4,4,4,5,4,6,"(0, (PEM/(Nº meses*150000))",1,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},1,20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E25=\"\",\"\",IF(E25<$R25,\"ERROR\",IF(E25>$S25,\"ERROR\",IF(E25>=$T25,$U25+(0.2*$U25*ABS(E25-$T25)/ABS($S25-$T25)),$U25*ABS($R25-E25)/ABS($R25-$T25)))))))","v":20.8},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F25=\"\",\"\",IF(F25<$R25,\"ERROR\",IF(F25>$S25,\"ERROR\",IF(F25>=$T25,$U25+(0.2*$U25*ABS(F25-$T25)/ABS($S25-$T25)),$U25*ABS($R25-F25)/ABS($R25-$T25)))))))","v":22.4},22.4,22.4,22.4,22.4,22.4,22.4,22.4,23.2,22.4,24,null,null,null,"Valorar acciones de estímulo"]
[null,null,null,"IC´s PARCIALES DELGRUPO E4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U16:U25)","v":100},{"$f":"SUM(V16:V25)","v":83.088461538461544},{"$f":"SUM(W16:W25)","v":100.72948717948719},99.675641025641028,97.867948717948707,88.38717948717948,102.65641025641025,90.70128205128205,100.09871794871793,97.367948717948707,91.253846153846155,95.156410256410254,107.03571428571428,10,{"$f":"$AH26*AG28/100","v":9.6168253968253961},{"$f":"AI26/AH26","v":0.96168253968253958}]
[]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E4 AL IC",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":"(SUM(V26:AG26))/12","v":96.168253968253964}]

{"sheet":"E5 LABORATORIO DE ENSAYOS","index":6,"n_rows":26,"n_cols":37,"rows_kept":26,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,"REF:","OBRA A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E5  INDICADORES LABORATORIO DE ENSAYOS","MES1","MES 2","MES 3","MES 4","MES 5","MES 6","MES 7","MES 8","MES 9","MES 10","MES 11","MES 12","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","Preal MES 1","Preal MES 2","Preal MES 3","Preal MES 4","Preal MES 5","Preal MES 6","Preal MES 7","PrealL MES 8","Preal MES 9","Preal Mes 10","Preal Mes 11","Preal Mes 12","Peso del grupo E5","Peso real del grupo E5","Desviación del IC","ACCIONES"]
[null,"E5.1","I-","Nº de no conformidades detectadas/mes (*)",18,15,10,13,12,11,13,14,13,12,11,6,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*15000)),0)))","v":20},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R16+1/3*(S16-R16)),0)))","v":7},10,{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(E16=\"\",\"\",IF(E16<$R16,\"ERROR\",IF(E16>$S16,\"ERROR\",IF(E16<=$T16,$U16+(0.2*$U16*ABS(E16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-E16)/ABS($S16-$T16)))))))","v":1.5384615384615385},{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(F16=\"\",\"\",IF(F16<$R16,\"ERROR\",IF(F16>$S16,\"ERROR\",IF(F16<=$T16,$U16+(0.2*$U16*ABS(F16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-F16)/ABS($S16-$T16)))))))","v":3.8461538461538463},{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(G16=\"\",\"\",IF(G16<$R16,\"ERROR\",IF(G16>$S16,\"ERROR\",IF(G16<=$T16,$U16+(0.2*$U16*ABS(G16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-G16)/ABS($S16-$T16)))))))","v":7.6923076923076925},{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(H16=\"\",\"\",IF(H16<$R16,\"ERROR\",IF(H16>$S16,\"ERROR\",IF(H16<=$T16,$U16+(0.2*$U16*ABS(H16-$T16)/ABS($R16-$T16)),$U16*ABS($S16-H16)/ABS($S16-$T16)))))))","v":5.384615384615385},6.1538461538461542,6.9230769230769234,5.384615384615385,4.615384615384615,5.384615384615385,6.1538461538461542,6.9230769230769234,10.285714285714286,null,null,null,{"$f":"IF(V16=\"\",\"\",IF(V16<$U16,\"Requiere acciones correctoras\",IF(V16>$U16,\"Valorar acciones de estímulo\",IF(V16=$U16,\"No requiere acciones\"))))","v":"Requiere acciones correctoras"}]
[null,"E5.2","I-","Nº de ensayos repetidos/mes (*)",6,7,5,6,5,2,3,1,0,0,0,0,"(0, No conformidades/3)",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((S16/3),0)))","v":7},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R17+1/3*(S17-R17)),0)))","v":3},20,{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(E17=\"\",\"\",IF(E17<$R17,\"ERROR\",IF(E17>$S17,\"ERROR\",IF(E17<=$T17,$U17+(0.2*$U17*ABS(E17-$T17)/ABS($R17-$T17)),$U17*ABS($S17-E17)/ABS($S17-$T17)))))))","v":5},{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(F17=\"\",\"\",IF(F17<$R17,\"ERROR\",IF(F17>$S17,\"ERROR\",IF(F17<=$T17,$U17+(0.2*$U17*ABS(F17-$T17)/ABS($R17-$T17)),$U17*ABS($S17-F17)/ABS($S17-$T17)))))))","v":0},10,5,10,21.333333333333332,20,22.666666666666668,24,24,24,24,null,null,null,"Requiere acciones correctoras"]
[null,"E5.3","I-","Nº de comunicaciones de anomalías al director de obra/mes",5,4,4,3,8,12,10,6,1,3,2,1,"(0, (PEM/(Nº meses*20000))",0,22,{"$f":"ROUNDUP((R18+1/3*(S18-R18)),0)","v":8},15,{"$f":"IF(E18=\"\",\"\",IF(E18<$R18,\"ERROR\",IF(E18>$S18,\"ERROR\",IF(E18<=$T18,$U18+(0.2*$U18*ABS(E18-$T18)/ABS($R18-$T18)),$U18*ABS($S18-E18)/ABS($S18-$T18)))))","v":16.125},{"$f":"IF(F18=\"\",\"\",IF(F18<$R18,\"ERROR\",IF(F18>$S18,\"ERROR\",IF(F18<=$T18,$U18+(0.2*$U18*ABS(F18-$T18)/ABS($R18-$T18)),$U18*ABS($S18-F18)/ABS($S18-$T18)))))","v":16.5},16.5,16.875,15,10.714285714285714,12.857142857142858,15.75,17.625,16.875,17.25,17.625,null,null,null,"Valorar acciones de estímulo"]
[null,"E5.4","I-","Nº de recomendaciones del Coordinador de seguridad/mes",1,2,2,2,1,1,1,0,0,1,0,0,"(0, (PEM/(Nº meses*300000))",0,{"$f":"IF(E10=\"\",\"\",ROUNDUP((E9/(E10*300000)),0)+1)","v":2},{"$f":"IF(E10=\"\",\"\",ROUNDUP((R19+1/3*(S19-R19)),0))","v":1},5,{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$R19,\"ERROR\",IF(E19>$S19,\"ERROR\",IF(E19<=$T19,$U19+(0.2*$U19*ABS(E19-$T19)/ABS($R19-$T19)),$U19*ABS($S19-E19)/ABS($S19-$T19)))))))","v":5},{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(F19=\"\",\"\",IF(F19<$R19,\"ERROR\",IF(F19>$S19,\"ERROR\",IF(F19<=$T19,$U19+(0.2*$U19*ABS(F19-$T19)/ABS($R19-$T19)),$U19*ABS($S19-F19)/ABS($S19-$T19)))))))","v":0},0,0,5,5,5,6,6,5,6,6,null,null,null,"No requiere acciones"]
[null,"E5.5","I-","% Ajuste en plazo de la aplicación del Plan de Control/mes",0.9,0.95,0.9,0.95,1.1000000000000001,1,1,1,1.1499999999999999,1,1,1,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,15,{"$f":"IF(E20=\"\",\"\",IF(E20<$R20,\"ERROR\",IF(E20>$S20,\"ERROR\",IF(E20<=$T20,$U20+(0.2*$U20*ABS(E20-$T20)/ABS($R20-$T20)),$U20*ABS($S20-E20)/ABS($S20-$T20)))))","v":16.2},{"$f":"IF(F20=\"\",\"\",IF(F20<$R20,\"ERROR\",IF(F20>$S20,\"ERROR\",IF(F20<=$T20,$U20+(0.2*$U20*ABS(F20-$T20)/ABS($R20-$T20)),$U20*ABS($S20-F20)/ABS($S20-$T20)))))","v":15.600000000000001},16.2,15.600000000000001,8.9999999999999947,15,15,15,6.0000000000000053,15,15,15,null,null,null,"Valorar acciones de estímulo"]
[null,"E5.6","I-","% Ajuste en presupuesto de la aplicación del Plan de Control/mes",0.9,0.95,0.9,0.95,1.1000000000000001,1,1,1,1.1499999999999999,1,1,1,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,15,{"$f":"IF(E21=\"\",\"\",IF(E21<$R21,\"ERROR\",IF(E21>$S21,\"ERROR\",IF(E21<=$T21,$U21+(0.2*$U21*ABS(E21-$T21)/ABS($R21-$T21)),$U21*ABS($S21-E21)/ABS($S21-$T21)))))","v":16.2},15.600000000000001,16.2,15.600000000000001,8.9999999999999947,15,15,15,6.0000000000000053,15,15,15,null,null,null,"Valorar acciones de estímulo"]
[null,"E5.7","I+","Nº de visitas/reuniones de obra/mes",3,6,5,6,1,6,4,4,4,4,5,6,"(1, (PEM/(Nº meses*75000))",1,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9/($E$10*50000)),0)))","v":6},{"$f":"ROUNDUP((R22+2/3*(S22-R22)),0)","v":5},10,{"$f":"IF(E22=\"\",\"\",IF(E22<$R22,\"ERROR\",IF(E22>$S22,\"ERROR\",IF(E22>=$T22,$U22+(0.2*$U22*ABS(E22-$T22)/ABS($S22-$T22)),$U22*ABS($R22-E22)/ABS($R22-$T22)))))","v":5},{"$f":"IF(F22=\"\",\"\",IF(F22<$R22,\"ERROR\",IF(F22>$S22,\"ERROR\",IF(F22>=$T22,$U22+(0.2*$U22*ABS(F22-$T22)/ABS($S22-$T22)),$U22*ABS($R22-F22)/ABS($R22-$T22)))))","v":12},10,12,0,12,7.5,7.5,7.5,7.5,10,12,null,null,null,"Requiere acciones correctoras"]
[null,"E5.8","I+","Nº de informes de control para el promotor/mes",1,3,4,3,4,4,2,2,4,5,4,6,"(0, (PEM/(Nº meses*150000))",1,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",ROUNDUP(($E$9/($E$10*50000)),0)))","v":6},1,10,{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$R23,\"ERROR\",IF(E23>$S23,\"ERROR\",IF(E23>=$T23,$U23+(0.2*$U23*ABS(E23-$T23)/ABS($S23-$T23)),$U23*ABS($R23-E23)/ABS($R23-$T23)))))))","v":10},{"$f":"IF($E10=\"\",\"\",IF($E9=\"\",\"\",IF(F23=\"\",\"\",IF(F23<$R23,\"ERROR\",IF(F23>$S23,\"ERROR\",IF(F23>=$T23,$U23+(0.2*$U23*ABS(F23-$T23)/ABS($S23-$T23)),$U23*ABS($R23-F23)/ABS($R23-$T23)))))))","v":10.8},11.2,10.8,11.2,11.2,10.4,10.4,11.2,11.6,11.2,12,null,null,null,"No requiere acciones"]
[null,null,null,"IC´s PARCIALES DELGRUPO E5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U16:U23)","v":100},{"$f":"SUM(V16:V23)","v":75.063461538461539},{"$f":"SUM(W16:W23)","v":74.346153846153854},87.792307692307702,81.259615384615387,65.353846153846135,97.170695970695974,91.141758241758254,96.93205128205129,83.709615384615404,101.12884615384615,105.37307692307692,111.91071428571428,10,{"$f":"$AH24*AG26/100","v":8.9265178571428567},{"$f":"AI24/AH24","v":0.89265178571428572}]
[]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E5 AL IC",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":"(SUM(V24:AG24))/12","v":89.265178571428564}]

{"sheet":"E6 EMPRESA CONSTRUCTORA","index":7,"n_rows":26,"n_cols":37,"rows_kept":26,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,"REF:","OBRA A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[null,null,null,"FASE EJECUCIÓN"]
[]
[null,null,null,"E6 INDICADORES EMPRESA CONSTRUCTORA","MES 1","MES 2","MES 3","MES 4","MES 5","MES 6","MES 7","MES 8","MES 9","MES 10","MES 11","MES 12","INTERVALO","MIN","MAX","ESTÁNDAR","Peso del indicador","Preal MES 1","Preal MES 2","Preal MES 3","Preal MES 4","Preal MES 5","Preal MES 6","Preal MES 7","PrealL MES 8","Preal MES 9","Preal Mes 10","Preal Mes 11","Preal Mes 12","Peso del grupo E6","Peso real del grupo E6","Desviación del IC","ACCIONES"]
[null,null,null,"DATO: Nº Materiales recibidos/mes= Total mat",10]
[null,"E6.1","I+","Nº de instrucciones de modificación Libro Órdenes/mes",3,3,2,2,3,4,3,2,1,2,3,2,"(0, (PEM/(Nº meses*150000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*100000)),0)))","v":3},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R17+2/3*(S17-R17)),0)))","v":2},5,{"$f":"IF(E17=\"\",\"\",IF(E17<$R17,\"ERROR\",IF(E17>$S17,\"ERROR\",IF(E17>=$T17,$U17+(0.2*$U17*ABS(E17-$T17)/ABS($S17-$T17)),$U17*ABS($R17-E17)/ABS($R17-$T17)))))","v":6},{"$f":"IF(F17=\"\",\"\",IF(F17<$R17,\"ERROR\",IF(F17>$S17,\"ERROR\",IF(F17>=$T17,$U17+(0.2*$U17*ABS(F17-$T17)/ABS($S17-$T17)),$U17*ABS($R17-F17)/ABS($R17-$T17)))))","v":6},5,5,6,"ERROR",6,5,2.5,5,6,5,null,null,null,{"$f":"IF(V17=\"\",\"\",IF(V17<$U17,\"Requiere acciones correctoras\",IF(V17>$U17,\"Valorar acciones de estímulo\",IF(V17=$U17,\"No requiere acciones\"))))","v":"Valorar acciones de estímulo"}]
[null,"E6.2","I-","% Ajuste en plazo de ejecución",0.9,0.95,0.9,0.95,1,0.95,0.9,1,0.9,0.95,0.9,0.9,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,20,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E18=\"\",\"\",IF(E18<$R18,\"ERROR\",IF(E18>$S18,\"ERROR\",IF(E18<=$T18,$U18+(0.2*$U18*ABS(E18-$T18)/ABS($R18-$T18)),$U18*ABS($S18-E18)/ABS($S18-$T18)))))))","v":21.6},{"$f":"IF(F18=\"\",\"\",IF(F18<$R18,\"ERROR\",IF(F18>$S18,\"ERROR\",IF(F18<=$T18,$U18+(0.2*$U18*ABS(F18-$T18)/ABS($R18-$T18)),$U18*ABS($S18-F18)/ABS($S18-$T18)))))","v":20.8},21.6,20.8,20,20.8,21.6,20,21.6,20.8,21.6,21.6,null,null,null,{"$f":"IF(V18<$U18,\"Requiere acciones correctoras\",IF(V18>$U18,\"Valorar acciones de estímulo\",IF(V18=$U18,\"No requiere acciones\")))","v":"Valorar acciones de estímulo"}]
[null,"E6.3","I-","% Ajuste presupuesto sobre el total anual",0.9,0.95,0.9,0.95,1.1000000000000001,0.95,1,1,1.1499999999999999,1,1,1,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,40,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E19=\"\",\"\",IF(E19<$R19,\"ERROR\",IF(E19>$S19,\"ERROR\",IF(E19<=$T19,$U19+(0.2*$U19*ABS(E19-$T19)/ABS($R19-$T19)),$U19*ABS($S19-E19)/ABS($S19-$T19)))))))","v":43.2},41.6,43.2,41.6,23.999999999999986,41.6,40,40,16.000000000000014,40,40,40,null,null,null,"Valorar acciones de estímulo"]
[null,"E6.4","I-","Nº de instrucciones aspectos seguridad laboral/mes ",2,3,4,2,3,4,2,3,1,3,2,2,"(0, (PEM/(Nº meses*150000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R20+1/3*(S20-R20)),0)))","v":2},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E20=\"\",\"\",IF(E20<$R20,\"ERROR\",IF(E20>$S20,\"ERROR\",IF(E20<=$T20,$U20+(0.2*$U20*ABS(E20-$T20)/ABS($R20-$T20)),$U20*ABS($S20-E20)/ABS($S20-$T20)))))))","v":10},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F20=\"\",\"\",IF(F20<$R20,\"ERROR\",IF(F20>$S20,\"ERROR\",IF(F20<=$T20,$U20+(0.2*$U20*ABS(F20-$T20)/ABS($R20-$T20)),$U20*ABS($S20-F20)/ABS($S20-$T20)))))))","v":7.5},5,10,7.5,5,10,7.5,11,7.5,10,10,null,null,null,{"$f":"IF(V20=\"\",\"\",IF(V20<$U20,\"Requiere acciones correctoras\",IF(V20>$U20,\"Valorar acciones de estímulo\",IF(V20=$U20,\"No requiere acciones\"))))","v":"No requiere acciones"}]
[null,"e6.5","I-","Nº de recomendaciones del Coordinador de seguridad/mes",3,4,4,2,5,3,3,2,2,3,2,3,"(0, (PEM/(Nº meses*100000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*50000)),0)))","v":6},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R21+1/3*(S21-R21)),0)))","v":2},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E21=\"\",\"\",IF(E21<$R21,\"ERROR\",IF(E21>$S21,\"ERROR\",IF(E21<=$T21,$U21+(0.2*$U21*ABS(E21-$T21)/ABS($R21-$T21)),$U21*ABS($S21-E21)/ABS($S21-$T21)))))))","v":7.5},5,5,10,2.5,7.5,7.5,10,10,7.5,10,7.5,null,null,null,{"$f":"IF(V21=\"\",\"\",IF(V21<$U21,\"Requiere acciones correctoras\",IF(V21>$U21,\"Valorar acciones de estímulo\",IF(V21=$U21,\"No requiere acciones\"))))","v":"Requiere acciones correctoras"}]
[null,"E6.6","I+","Nº de recomendaciones de la Asistencia Técnica/mes",18,20,15,17,12,12,10,10,8,10,20,3,"(0, (PEM/(Nº meses*25000))",0,{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((E9/(E10*10000)),0)))","v":29},{"$f":"IF(E10=\"\",\"\",IF(E9=\"\",\"\",ROUNDUP((R22+2/3*(S22-R22)),0)))","v":20},5,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E22=\"\",\"\",IF(E22<$R22,\"ERROR\",IF(E22>$S22,\"ERROR\",IF(E22>=$T22,$U22+(0.2*$U22*ABS(E22-$T22)/ABS($S22-$T22)),$U22*ABS($R22-E22)/ABS($R22-$T22)))))))","v":4.5},{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(F22=\"\",\"\",IF(F22<$R22,\"ERROR\",IF(F22>$S22,\"ERROR\",IF(F22>=$T22,$U22+(0.2*$U22*ABS(F22-$T22)/ABS($S22-$T22)),$U22*ABS($R22-F22)/ABS($R22-$T22)))))))","v":5},3.75,4.25,3,3,2.5,2.5,2,2.5,5,0.75,null,null,null,{"$f":"IF(V22=\"\",\"\",IF(V22<$U22,\"Requiere acciones correctoras\",IF(V22>$U22,\"Valorar acciones de estímulo\",IF(V22=$U22,\"No requiere acciones\"))))","v":"Requiere acciones correctoras"}]
[null,"E6.7","I-","Nº de materiales rechazados/mes por cualquier causa",2,6,4,5,4,7,1,5,3,2,1,0,"(0, Total mat)",0,{"$f":"E16","v":10},{"$f":"ROUNDUP((R23+1/3*(S23-R23)),0)","v":4},10,{"$f":"IF($E$10=\"\",\"\",IF($E$9=\"\",\"\",IF(E23=\"\",\"\",IF(E23<$R23,\"ERROR\",IF(E23>$S23,\"ERROR\",IF(E23<=$T23,$U23+(0.2*$U23*ABS(E23-$T23)/ABS($R23-$T23)),$U23*ABS($S23-E23)/ABS($S23-$T23)))))))","v":11},{"$f":"IF(F23=\"\",\"\",IF(F23<$R23,\"ERROR\",IF(F23>$S23,\"ERROR\",IF(F23<=$T23,$U23+(0.2*$U23*ABS(F23-$T23)/ABS($R23-$T23)),$U23*ABS($S23-F23)/ABS($S23-$T23)))))","v":6.666666666666667},10,8.3333333333333339,10,5,11.5,8.3333333333333339,10.5,11,11.5,12,null,null,null,"Valorar acciones de estímulo"]
[null,null,null,"IC´s PARCIALES DELGRUPO E6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U17:U23)","v":100},{"$f":"SUM(V17:V23)","v":103.80000000000001},{"$f":"SUM(W16:W23)","v":92.566666666666677},93.550000000000011,99.983333333333334,72.999999999999986,82.9,99.1,93.333333333333329,73.600000000000023,94.3,104.1,96.85,20,{"$f":"$AH24*AG26/100","v":18.451388888888893},{"$f":"AI24/AH24","v":0.92256944444444466}]
[]
[null,null,null,"CONTRIBUCIÓN DEL GRUPO E6 AL IC",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":"(SUM(V24:AG24))/12","v":92.256944444444457}]

{"sheet":"IC OBRA A","index":8,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"ÍNDICE DE CALIDAD DE LAS CONSTRUCCIONES"]
[]
[]
[null,null,"PROYECTO/OBRA"]
[]
[null,null,"DATOS OBLIGATORIOS"]
[null,null,"REF:","OBRA A"]
[null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79]
[null,null,"TIEMPO DE DURACIÓN en meses",12]
[null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[null,null,null,null," IC parcial MES 1"," IC parcial MES 2"," IC parcial MES 3"," IC parcial MES 4","IC parcial MES 5"," IC parcial MES 6"," IC parcial MES 7"," IC parcial MES 8"," IC parcial MES 9"," IC parcial MES 10"," IC parcial MES 11"," IC parcial MES 12","  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":70.066666666666677},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'P1 P2 PROYECTO'!$K$22","v":70.066666666666677},{"$f":"'P1 P2 PROYECTO'!$L$22","v":20}]
[null,null,"P2 INDICADORES SUPERVISORES PROYECTO",null,{"$f":"'P1 P2 PROYECTO'!$K$28","v":27.6},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'P1 P2 PROYECTO'!$K$28","v":27.6},{"$f":"'P1 P2 PROYECTO'!$L$28","v":5}]
[null,null,"PESO INDICADORES DE PROYECTO",null,{"$f":"E15+E16","v":97.666666666666686},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q15+Q16","v":97.666666666666686},{"$f":"R15+R16","v":25},{"$f":"$R17*Q17/100","v":24.416666666666671}]
[]
[null,null,"FASE EJECUCIÓN"]
[]
[null,null,"E1 INDICADORES SUPERVISORES EJECUCIÓN",null,{"$f":"'E1 SUPERVISORES EJECUCION'!V26","v":101.06602573627745},{"$f":"'E1 SUPERVISORES EJECUCION'!W26","v":94.301135363492335},{"$f":"'E1 SUPERVISORES EJECUCION'!X26","v":80.195990965556192},{"$f":"'E1 SUPERVISORES EJECUCION'!Y26","v":96.615838509316774},{"$f":"'E1 SUPERVISORES EJECUCION'!Z26","v":83.321066252587997},{"$f":"'E1 SUPERVISORES EJECUCION'!AA26","v":69.794772256728777},{"$f":"'E1 SUPERVISORES EJECUCION'!AB26","v":91.05},{"$f":"'E1 SUPERVISORES EJECUCION'!AC26","v":74.720624303233009},{"$f":"'E1 SUPERVISORES EJECUCION'!AD26","v":89.525621118012424},{"$f":"'E1 SUPERVISORES EJECUCION'!AE26","v":79.035817805383019},{"$f":"'E1 SUPERVISORES EJECUCION'!AF26","v":105.37655279503105},{"$f":"'E1 SUPERVISORES EJECUCION'!AG26","v":80.181055900621118},{"$f":"(SUM(E21:P21))/12","v":87.098708417186643},{"$f":"'E1 SUPERVISORES EJECUCION'!$AH$26","v":15},{"$f":"$R21*Q21/100","v":13.064806262577997}]
[null,null,"E2 INDICADORES DIRECTOR OBRA",null,{"$f":"'E2 DIRECTOR OBRA'!V26","v":99.75},{"$f":"'E2 DIRECTOR OBRA'!W26","v":72.821428571428569},{"$f":"'E2 DIRECTOR OBRA'!X26","v":44.976190476190482},{"$f":"'E2 DIRECTOR OBRA'!Y26","v":99.533333333333346},{"$f":"'E2 DIRECTOR OBRA'!Z26","v":78.599999999999994},{"$f":"'E2 DIRECTOR OBRA'!AA26","v":74.5},{"$f":"'E2 DIRECTOR OBRA'!AB26","v":66.25},{"$f":"'E2 DIRECTOR OBRA'!AC26","v":89.807017543859658},{"$f":"'E2 DIRECTOR OBRA'!AD26","v":91.903508771929808},{"$f":"'E2 DIRECTOR OBRA'!AE26","v":82.083333333333343},{"$f":"'E2 DIRECTOR OBRA'!AF26","v":88.421052631578945},{"$f":"'E2 DIRECTOR OBRA'!AG26","v":88.017543859649123},{"$f":"(SUM(E22:P22))/12","v":81.388617376775272},{"$f":"'E2 DIRECTOR OBRA'!$AH$26","v":10},8.1388617376775283]
[null,null,"E3  INDICADORES DIRECTOR EJECUCIÓN OBRA",null,{"$f":"'E3 DIRECTOR EJECUCION'!V26","v":90.324999999999989},{"$f":"'E3 DIRECTOR EJECUCION'!W26","v":92.55},{"$f":"'E3 DIRECTOR EJECUCION'!X26","v":79.785714285714278},{"$f":"'E3 DIRECTOR EJECUCION'!Y26","v":78.029761904761898},{"$f":"'E3 DIRECTOR EJECUCION'!Z26","v":91.48571428571428},{"$f":"'E3 DIRECTOR EJECUCION'!AA26","v":86.767857142857139},{"$f":"'E3 DIRECTOR EJECUCION'!AB26","v":95.51666666666668},{"$f":"'E3 DIRECTOR EJECUCION'!AC26","v":71.279761904761898},{"$f":"'E3 DIRECTOR EJECUCION'!AD26","v":97.585714285714275},{"$f":"'E3 DIRECTOR EJECUCION'!AE26","v":88.625},{"$f":"'E3 DIRECTOR EJECUCION'!AF26","v":99.208333333333329},{"$f":"'E3 DIRECTOR EJECUCION'!AG26","v":89.375},88.377876984126985,{"$f":"'E3 DIRECTOR EJECUCION'!$AH$26","v":10},8.8377876984126988]
[null,null,"E4 INDICADORES ASISTENCIA TÉCNICA",null,{"$f":"'E4 ASISTENCIA TECNICA'!V26","v":83.088461538461544},{"$f":"'E4 ASISTENCIA TECNICA'!W26","v":100.72948717948719},{"$f":"'E4 ASISTENCIA TECNICA'!X26","v":99.675641025641028},{"$f":"'E4 ASISTENCIA TECNICA'!Y26","v":97.867948717948707},{"$f":"'E4 ASISTENCIA TECNICA'!Z26","v":88.38717948717948},{"$f":"'E4 ASISTENCIA TECNICA'!AA26","v":102.65641025641025},{"$f":"'E4 ASISTENCIA TECNICA'!AB26","v":90.70128205128205},{"$f":"'E4 ASISTENCIA TECNICA'!AC26","v":100.09871794871793},{"$f":"'E4 ASISTENCIA TECNICA'!AD26","v":97.367948717948707},{"$f":"'E4 ASISTENCIA TECNICA'!AE26","v":91.253846153846155},{"$f":"'E4 ASISTENCIA TECNICA'!AF26","v":95.156410256410254},{"$f":"'E4 ASISTENCIA TECNICA'!AG26","v":107.03571428571428},96.168253968253964,{"$f":"'E4 ASISTENCIA TECNICA'!$AH$26","v":10},9.6168253968253961]
[null,null,"E5  INDICADORES LABORATORIO DE ENSAYOS",null,{"$f":"'E5 LABORATORIO DE ENSAYOS'!V24","v":75.063461538461539},{"$f":"'E5 LABORATORIO DE ENSAYOS'!W24","v":74.346153846153854},{"$f":"'E5 LABORATORIO DE ENSAYOS'!X24","v":87.792307692307702},{"$f":"'E5 LABORATORIO DE ENSAYOS'!Y24","v":81.259615384615387},{"$f":"'E5 LABORATORIO DE ENSAYOS'!Z24","v":65.353846153846135},{"$f":"'E5 LABORATORIO DE ENSAYOS'!AA24","v":97.170695970695974},{"$f":"'E5 LABORATORIO DE ENSAYOS'!AB24","v":91.141758241758254},{"$f":"'E5 LABORATORIO DE ENSAYOS'!AC24","v":96.93205128205129},{"$f":"'E5 LABORATORIO DE ENSAYOS'!AD24","v":83.709615384615404},{"$f":"'E5 LABORATORIO DE ENSAYOS'!AE24","v":101.12884615384615},{"$f":"'E5 LABORATORIO DE ENSAYOS'!AF24","v":105.37307692307692},{"$f":"'E5 LABORATORIO DE ENSAYOS'!AG24","v":111.91071428571428},89.265178571428564,{"$f":"'E5 LABORATORIO DE ENSAYOS'!$AH$24","v":10},8.9265178571428567]
[null,null,"E6 INDICADORES EMPRESA CONSTRUCTORA",null,{"$f":"'E6 EMPRESA CONSTRUCTORA'!V24","v":103.80000000000001},{"$f":"'E6 EMPRESA CONSTRUCTORA'!W24","v":92.566666666666677},{"$f":"'E6 EMPRESA CONSTRUCTORA'!X24","v":93.550000000000011},{"$f":"'E6 EMPRESA CONSTRUCTORA'!Y24","v":99.983333333333334},{"$f":"'E6 EMPRESA CONSTRUCTORA'!Z24","v":72.999999999999986},{"$f":"'E6 EMPRESA CONSTRUCTORA'!AA24","v":82.9},{"$f":"'E6 EMPRESA CONSTRUCTORA'!AB24","v":99.1},{"$f":"'E6 EMPRESA CONSTRUCTORA'!AC24","v":93.333333333333329},{"$f":"'E6 EMPRESA CONSTRUCTORA'!AD24","v":73.600000000000023},{"$f":"'E6 EMPRESA CONSTRUCTORA'!AE24","v":94.3},{"$f":"'E6 EMPRESA CONSTRUCTORA'!AF24","v":104.1},{"$f":"'E6 EMPRESA CONSTRUCTORA'!AG24","v":96.85},92.256944444444457,{"$f":"'E6 EMPRESA CONSTRUCTORA'!$AH$24","v":20},18.451388888888893]
[]
[null,null,"TOTAL PESO INDICADORES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R17:R27)","v":100},{"$f":"SUM(S17:S27)","v":91.452854508192047}]
[]
[]
[null,null,"ÍNDICE DE CALIDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S26+S25+S24+S23+S22+S21+S17","v":91.452854508192047}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEYENDA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","Buena calidad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","Calidad aceptable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"'[1]DATOS GENERALES'!$E$8","v":"Obra A"},"IC=",{"$f":"'IC OBRA A'!$S$31","v":91.452854508192047}]
[]
[]
[null,null,{"$f":"IF((90<VALUE($F$10))*AND(VALUE($F$10)<=93),VALUE($F$10),\" \")","v":91.452854508192047},{"$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":" "},{"$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"]

{"sheet":"CUADRO DE MANDO","index":10,"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,"DATOS OBLIGATORIOS",null,null,null,null,null,null,"LEYENDA"]
[null,null,null,"REF:","OBRA A",null,null,null,null,null,null,"Colaboración positiva al IC"]
[null,null,null,"PRESUPUESTO DE EJECUCIÓN MATERIAL (PEM) en Euros",3450728.79,null,null,null,null,null,null,"Colaboración neutra al IC"]
[null,null,null,"TIEMPO DE DURACIÓN en meses",12,null,null,null,null,null,null,"Colaboración negativa al IC"]
[null,null,null,"COMPLEJIDAD ORGANIZATIVA DE LA OBRA",1]
[]
[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",12,"(0,PEM/1000000)",0,{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/150000),0))","v":24},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G16+1/3*(H16-G16)),0))","v":8},10,{"$f":"IF(E9=\"\",\"\",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":7.5},null,null,null,"Valores que alcancen el valor del límite superior del intevalo del intervalo deben corregirse en un mes. Si no, rescisión de contrato. Incluir en próximo pliego de condiciones del contrato."]
[null,"P1.2","I-","Número de complementos solicitados",2,"(0,PEM/2000000)",0,{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/1000000),0))","v":4},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G17+1/3*(H17-G17)),0))","v":2},10,{"$f":"IF(E9=\"\",\"\",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,"Valores que alcancen el valor del límite superior del intevalo del intervalo deben corregirse en un mes. Si no, rescisión de contrato. Incluir en próximo pliego de condiciones del contrato."]
[null,"P1.3","I-","Número de correcciones solicitadas",10,"(0,PEM/2000000)",0,{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/150000),0))","v":24},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G18+1/3*(H18-G18)),0))","v":8},20,{"$f":"IF(E9=\"\",\"\",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":17.5},null,null,null,"Más del 50% de los valores por encima del estándar modificará los límites del intervalo el próximo mes."]
[null,"P1.4","I-","Días de respuesta a las solicitudes por parte del proyectista",5,"(1, PEM/suma de solicitudes)",0,{"$f":"16","v":16},{"$f":"ROUNDUP((G19+1/3*(H19-G19)),0)","v":6},20,{"$f":"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":20.666666666666668},null,null,null,"Más del 50% de los valores por debajo del estándar supondrá apercibimiento. "]
[null,"P1.5","I+","% PEM destinado al Plan de Control",1.25,"SI PEM (O, 300000);(1.5,3) SI PEM (300000, 1000000);(1,2) SI PEM>1000000;(0,5-1,5)",0.5,1.25,{"$f":"G20+2/3*(H20-G20)","v":1},12,{"$f":"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":14.4},null,null,null,"Más del 50% de los valores por debajo del estándar modificará los límites del intervalo el próximo mes."]
[null,"P1.6","I+","Número de documentos complementarios/voluntarios",0,"(0,PEM/1000000)",0,{"$f":"IF(E9=\"\",\"\",ROUNDUP(($E$9/4000000),0))","v":1},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G21+2/3*(H21-G21)),0))","v":1},5,{"$f":"IF(E9=\"\",\"\",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":0},null,null,null,"Más del 50% de los valores por encima del estándar supondrá apercibimiento. "]
[null,null,null,"IC PARCIAL GRUPO P1",null,null,null,null,null,{"$f":"SUM(J16:J21)","v":77},{"$f":"SUM(K16:K21)","v":70.066666666666677},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)",2,"(PEM/750000, PEM/500000)",{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/2000000),0))","v":2},{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/500000),0))","v":7},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G25+1/3*(H25-G25)),0))","v":4},10,{"$f":"IF(E9=\"\",\"\",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":12},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":"Valorar acciones de estímulo"}]
[null,"P2.2","I-","Tiempo de redacción del informe de supervisión (horas)",4,"(PEM/1000000, PEM/750000)",{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/1000000),0))","v":4},{"$f":"IF(E9=\"\",\"\",ROUNDUP((E9/750000),0))","v":5},{"$f":"IF(E9=\"\",\"\",ROUNDUP((G26+1/3*(H26-G26)),0))","v":5},8,{"$f":"IF(E9=\"\",\"\",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":9.6},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":"Valorar acciones de estímulo"}]
[null,"P2.3","I-","Tiempo de comunicación al proyectista de las solicitudes (días laborables)",1,"(1, 3)",1,3,2,5,{"$f":"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":6},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":"Valorar acciones de estímulo"}]
[null,null,null,"IC PARCIAL GRUPO P2",null,null,null,null,null,{"$f":"SUM(J25:J27)","v":23},{"$f":"SUM(K25:K27)","v":27.6},5]
[null,null,null,"IC PARCIAL GRUPO P",null,null,null,null,null,{"$f":"J22+J28","v":100},{"$f":"K22+K28","v":97.666666666666686},{"$f":"L22+L28","v":25},{"$f":"$L29*K29/100","v":24.416666666666671},{"$f":"M29/L29","v":0.9766666666666669}]
[]
[null,null,null,"CONTRIBUCIÓN DEL PROYECTO AL IC",null,null,null,null,null,null,{"$f":"$K$29","v":97.666666666666686}]