{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["VARIAS OBRAS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"VARIAS OBRAS","index":0,"n_rows":119,"n_cols":18,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,null,"DATOS PROYECTO/OBRA"]
[null,null,"PEM (PRESUPUESTO DE EJECUCIÓN MATERIAL)",10000000]
[]
[null,null,"TIEMPO DE DURACIÓN EN MESES",18]
[]
[]
[null,null,"INDICADORES DE CONTROL DE CALIDAD "]
[]
[]
[null,null,"ÍNDICE DE CALIDAD DE VARIAS OBRAS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Peso de los indicadores",null,null,null,"Peso del grupo"]
[null,null,null,null,null,null,null,null,null,null,null,"OBRA 1","OBRA 2","OBRA 3","PESO DE REF DEL GRUPO","OBRA 1","OBRA 2","OBRA 3"]
[null,null,"FASE DE PROYECTO"]
["TIPO",null,"P INDICADORES SUPERVISORES PROYECTO","OBRA 1","OBRA 2","OBRA 3","INTERVALO","MIN","MAX","ESTÁNDAR","PESO DE REFERENCIA","PESO REAL 1","PESO REAL 2","PESO REAL 3","PESO DE REF DEL GRUPO","PESO REAL DEL GRUPO 1","PESO REAL DEL GRUPO 2","PESO REAL DEL GRUPO 3"]
[]
["NEG",null,"Número de aclaraciones solicitadas",10,4,8,"(0,PEM/1000000)",0,{"$f":"ROUNDUP((D2/1000000),0)","v":10},{"$f":"ROUNDUP((H17+1/3*(I17-H17)),0)","v":4},10,{"$f":"IF(D17<$H17,\"ERROR\",IF(D17>$I17,\"ERROR\",IF(D17<=$J17,$K17+(0.2*$K17*ABS(D17-$J17)/ABS($H17-$J17)),$K17*ABS($I17-D17)/ABS($I17-$J17))))","v":0},{"$f":"IF(E17<$H17,\"ERROR\",IF(E17>$I17,\"ERROR\",IF(E17<=$J17,$K17+(0.2*$K17*ABS(E17-$J17)/ABS($H17-$J17)),$K17*ABS($I17-E17)/ABS($I17-$J17))))","v":10},3.3333333333333335]
["NEG",null,"Número de complementos solicitados",1,2,5,"(0,PEM/2000000)",0,{"$f":"ROUNDUP((D2/2000000),0)","v":5},2,10,{"$f":"IF(D18<$H18,\"ERROR\",IF(D18>$I18,\"ERROR\",IF(D18<=$J18,$K18+(0.2*$K18*ABS(D18-$J18)/ABS($H18-$J18)),$K18*ABS($I18-D18)/ABS($I18-$J18))))","v":11},10,0]
["NEG",null,"Número de correcciones solicitadas",0,2,3,"(0,PEM/2000000)",0,{"$f":"ROUNDUP((D2/2000000),0)","v":5},2,20,24,20,13.333333333333334]
["NEG",null,"Días de respuesta a las solicitudes por parte del proyectista",2,2,10,"(1, PEM/suma de solicitudes)",1,{"$f":"ROUNDUP(($D$2/((D17+D18+D19)*100000)),0)","v":10},4,20,22.666666666666668,22.666666666666668,0]
["NEG",null,"Tiempo de supervisión del proyecto (días laborables)",16,17,18,"(PEM/750000, PEM/500000)",{"$f":"ROUNDUP((D2/750000),0)","v":14},{"$f":"ROUNDUP((D2/500000),0)","v":20},16,10,10,7.5,5]
["NEG",null,"Tiempo de redacción del informe de supervisión (horas)",10,10,10,"(PEM/1000000, PEM/750000)",{"$f":"ROUNDUP((D2/1000000),0)","v":10},{"$f":"ROUNDUP((D2/750000),0)","v":14},12,8,9.6,9.6,9.6]
["NEG",null,"Tiempo de comunicación al proyectista de las solicitudes (días laborables)",1,2,2,"(1, 3)",1,3,2,5,6,5,5]
["POS",null,"Número de documentos complementarios/voluntarios",3,1,0,"(0,PEM/1000000)",0,{"$f":"ROUNDUP(($D$2/4000000),0)","v":3},{"$f":"ROUNDUP((H24+2/3*(I24-H24)),0)","v":2},5,{"$f":"IF(D24<$H24,\"ERROR\",IF(D24>$I24,\"ERROR\",IF(D24>=$J24,$K24+(0.2*$K24*ABS(D24-$J24)/ABS($I24-$J24)),$K24*ABS($H24-D24)/ABS($H24-$J24))))","v":6},{"$f":"IF(E24<$H24,\"ERROR\",IF(E24>$I24,\"ERROR\",IF(E24>=$J24,$K24+(0.2*$K24*ABS(E24-$J24)/ABS($I24-$J24)),$K24*ABS($H24-E24)/ABS($H24-$J24))))","v":2.5},0]
["POS",null,"% PEM destinado al Plan de Control",1,1,0.8,"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":"H25+2/3*(I25-H25)","v":1},12,12,12,7.2000000000000011]
[]
[null,null,"P INDICADORES SUPERVISORES PROYECTO",null,null,null,null,null,null,null,{"$f":"SUM(K17:K25)","v":100},{"$f":"SUM(L17:L25)","v":101.26666666666667},{"$f":"SUM(M17:M25)","v":99.266666666666666},{"$f":"SUM(N17:N25)","v":43.466666666666669},10,{"$f":"$O27*L27/100","v":10.126666666666667},{"$f":"$O27*M27/100","v":9.9266666666666659},{"$f":"$O27*N27/100","v":4.3466666666666667}]
[]
[null,null,"FASE DE EJECUCIÓN"]
[null,null,"E1 INDICADORES SUPERVISORES EJECUCIÓN","OBRA 1","OBRA 2","OBRA 3","INTERVALO","MIN","MAX","ESTÁNDAR","PESO DE REFERENCIA","PESO REAL","PESO REAL 2","PESO REAL 3","PESO DE REF DEL GRUPO","PESO REAL DEL GRUPO 1","PESO REAL DEL GRUPO 2","PESO REAL DEL GRUPO 3"]
["NEG",null,"Cumplimiento cuantitativo del plan de control/mes (€)",0.9,1,0.75,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,10,{"$f":"IF(D31<$H31,\"ERROR\",IF(D31>$I31,\"ERROR\",IF(D31<=$J31,$K31+(0.2*$K31*ABS(D31-$J31)/ABS($H31-$J31)),$K31*ABS($I31-D31)/ABS($I31-$J31))))","v":10.8},{"$f":"IF(E31<$H31,\"ERROR\",IF(E31>$I31,\"ERROR\",IF(E31<=$J31,$K31+(0.2*$K31*ABS(E31-$J31)/ABS($H31-$J31)),$K31*ABS($I31-E31)/ABS($I31-$J31))))","v":10},12]
["POS",null,"resultados aceptados/mes",0.85,0.85,0.85,"(NINGUNO, TODOS)",0,1,0.8,10,{"$f":"IF(D32<$H32,\"ERROR\",IF(D32>$I32,\"ERROR\",IF(D32>=$J32,$K32+(0.2*$K32*ABS(D32-$J32)/ABS($I32-$J32)),$K32*ABS($H32-D32)/ABS($H32-$J32))))","v":10.5},{"$f":"IF(E32<$H32,\"ERROR\",IF(E32>$I32,\"ERROR\",IF(E32>=$J32,$K32+(0.2*$K32*ABS(E32-$J32)/ABS($I32-$J32)),$K32*ABS($H32-E32)/ABS($H32-$J32))))","v":10.5},{"$f":"IF(F32<$H32,\"ERROR\",IF(F32>$I32,\"ERROR\",IF(F32>=$J32,$K32+(0.2*$K32*ABS(F32-$J32)/ABS($I32-$J32)),$K32*ABS($H32-F32)/ABS($H32-$J32))))","v":10.5}]
["NEG",null,"Resultados rechazados/mes",0.15,0.15,0.15,"(NINGUNO, TODOS)",0,1,0.2,10,{"$f":"IF(D33<$H33,\"ERROR\",IF(D33>$I33,\"ERROR\",IF(D33<=$J33,$K33+(0.2*$K33*ABS(D33-$J33)/ABS($H33-$J33)),$K33*ABS($I33-D33)/ABS($I33-$J33))))","v":10.5},10.5,10.5]
["NEG",null,"Acciones que necesitan modificación de ejecución/mes",2,2,2,"(0, (PEM/(Nº meses*20000))*1,33)",0,{"$f":"ROUNDUP((D2/(D4*200000)),0)","v":3},{"$f":"ROUNDUP((H34+1/3*(I34-H34)),0)","v":1},5,{"$f":"IF(D34<$H34,\"ERROR\",IF(D34>$I34,\"ERROR\",IF(D34<=$J34,$K34+(0.2*$K34*ABS(D34-$J34)/ABS($H34-$J34)),$K34*ABS($I34-D34)/ABS($I34-$J34))))","v":2.5},2.5,2.5]
["NEG",null,"Acciones que necesitan modificación presupuesto/mes",0,1,3,"(0, (PEM/(Nº meses*20000)))",0,{"$f":"ROUNDUP((D2/(D4*200000)),0)","v":3},1,25,{"$f":"IF(D35<$H35,\"ERROR\",IF(D35>$I35,\"ERROR\",IF(D35<=$J35,$K35+(0.2*$K35*ABS(D35-$J35)/ABS($H35-$J35)),$K35*ABS($I35-D35)/ABS($I35-$J35))))","v":30},25,0]
["NEG",null,"No conformidades detectadas/mes (*)",18,18,18,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"ROUNDUP((D2/(D4*15000)),0)","v":38},{"$f":"ROUNDUP((H36+1/3*(I36-H36)),0)","v":13},5,{"$f":"IF(D36<$H36,\"ERROR\",IF(D36>$I36,\"ERROR\",IF(D36<=$J36,$K36+(0.2*$K36*ABS(D36-$J36)/ABS($H36-$J36)),$K36*ABS($I36-D36)/ABS($I36-$J36))))","v":4},4,4]
["POS",null,"No conformidades resueltas/mes (*)",16,16,10,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"D36","v":18},{"$f":"ROUNDUP((H37+2/3*(I37-H37)),0)","v":12},5,{"$f":"IF(D37<$H37,\"ERROR\",IF(D37>$I37,\"ERROR\",IF(D37>=$J37,$K37+(0.2*$K37*ABS(D37-$J37)/ABS($I37-$J37)),$K37*ABS($H37-D37)/ABS($H37-$J37))))","v":5.666666666666667},{"$f":"IF(E37<$H37,\"ERROR\",IF(E37>$I37,\"ERROR\",IF(E37>=$J37,$K37+(0.2*$K37*ABS(E37-$J37)/ABS($I37-$J37)),$K37*ABS($H37-E37)/ABS($H37-$J37))))","v":5.666666666666667},{"$f":"IF(F37<$H37,\"ERROR\",IF(F37>$I37,\"ERROR\",IF(F37>=$J37,$K37+(0.2*$K37*ABS(F37-$J37)/ABS($I37-$J37)),$K37*ABS($H37-F37)/ABS($H37-$J37))))","v":4.166666666666667}]
["NEG",null,"No conformidades pendientes /mes (*)",{"$f":"D36-D37","v":2},6,8,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"D36","v":18},{"$f":"ROUNDUP((H38+1/3*(I38-H38)),0)","v":6},10,{"$f":"IF(D38<$H38,\"ERROR\",IF(D38>$I38,\"ERROR\",IF(D38<=$J38,$K38+(0.2*$K38*ABS(D38-$J38)/ABS($H38-$J38)),$K38*ABS($I38-D38)/ABS($I38-$J38))))","v":11.333333333333334},10,8.3333333333333339]
["NEG",null,"Nº de acciones de doble control/mes (*)",4,5,7,"(0, (PEM/(Nº meses*5000)*)1/3)",0,{"$f":"ROUNDUP((I36/3),0)","v":13},{"$f":"ROUNDUP((H39+1/3*(I39-H39)),0)","v":5},10,{"$f":"IF(D39<$H39,\"ERROR\",IF(D39>$I39,\"ERROR\",IF(D39<=$J39,$K39+(0.2*$K39*ABS(D39-$J39)/ABS($H39-$J39)),$K39*ABS($I39-D39)/ABS($I39-$J39))))","v":10.4},10,7.5]
["NEG",null,"Nº de acciones de triple (o +) control/mes (*)",1,2,4,"(0, (PEM/(Nº meses*5000)*)1/6)",0,{"$f":"ROUNDUP((I36/6),0)","v":7},3,10,{"$f":"IF(D40<$H40,\"ERROR\",IF(D40>$I40,\"ERROR\",IF(D40<=$J40,$K40+(0.2*$K40*ABS(D40-$J40)/ABS($H40-$J40)),$K40*ABS($I40-D40)/ABS($I40-$J40))))","v":11.333333333333334},10.666666666666666,7.5]
[]
[]
[null,null,"E1 INDICADORES SUPERVISORES EJECUCIÓN",null,null,null,null,null,null,null,{"$f":"SUM(K31:K40)","v":100},{"$f":"SUM(L31:L40)","v":107.03333333333333},{"$f":"SUM(M31:M40)","v":98.833333333333343},{"$f":"SUM(N31:N40)","v":67},30,{"$f":"$O43*L43/100","v":32.11},{"$f":"$O43*M43/100","v":29.650000000000006},{"$f":"$O43*N43/100","v":20.100000000000001}]
[]
[]
[null,null,"E2 INDICADORES DIRECTOR OBRA","OBRA 1","OBRA 2","OBRA 3","INTERVALO","MIN","MAX","ESTÁNDAR","PESO DE REFERENCIA","PESO REAL","PESO REAL 2","PESO REAL 3","PESO DEL GRUPO","PESO REAL DEL GRUPO 1","PESO REAL DEL GRUPO 2","PESO REAL DEL GRUPO 3"]
["NEG",null,"Nº de correcciones del proyecto/mes",1,1,1,"(0, (PEM/(Nº meses*250000))",0,{"$f":"ROUNDUP((D2/(D4*250000)),0)","v":3},{"$f":"ROUNDUP((H47+1/3*(I47-H47)),0)","v":1},15,{"$f":"IF(D47<$H47,\"ERROR\",IF(D47>$I47,\"ERROR\",IF(D47<=$J47,$K47+(0.2*$K47*ABS(D47-$J47)/ABS($H47-$J47)),$K47*ABS($I47-D47)/ABS($I47-$J47))))","v":15},{"$f":"IF(E47<$H47,\"ERROR\",IF(E47>$I47,\"ERROR\",IF(E47<=$J47,$K47+(0.2*$K47*ABS(E47-$J47)/ABS($H47-$J47)),$K47*ABS($I47-E47)/ABS($I47-$J47))))","v":15},15]
["NEG",null,"Nº de correcciones de la ejecución/mes",1,2,1,"(0, (PEM/(Nº meses*150000))",0,{"$f":"ROUNDUP((D2/(D4*150000)),0)","v":4},2,10,{"$f":"IF(D48<$H48,\"ERROR\",IF(D48>$I48,\"ERROR\",IF(D48<=$J48,$K48+(0.2*$K48*ABS(D48-$J48)/ABS($H48-$J48)),$K48*ABS($I48-D48)/ABS($I48-$J48))))","v":11},10,11]
["NEG",null,"Nº de modificaciones del presupuesto/mes",1,1,1,"(0, (PEM/(Nº meses*250000))",0,{"$f":"ROUNDUP((D2/(D4*250000)),0)","v":3},1,10,{"$f":"IF(D49<$H49,\"ERROR\",IF(D49>$I49,\"ERROR\",IF(D49<=$J49,$K49+(0.2*$K49*ABS(D49-$J49)/ABS($H49-$J49)),$K49*ABS($I49-D49)/ABS($I49-$J49))))","v":10},10,10]
["POS",null,"Nº de instrucciones de modificación Libro Órdenes/mes",4,3,34,"(0, (PEM/(Nº meses*150000))",0,{"$f":"ROUNDUP((D2/(D4*150000)),0)","v":4},{"$f":"ROUNDUP((H50+2/3*(I50-H50)),0)","v":3},5,{"$f":"IF(D50<$H50,\"ERROR\",IF(D50>$I50,\"ERROR\",IF(D50>=$J50,$K50+(0.2*$K50*ABS(D50-$J50)/ABS($I50-$J50)),$K50*ABS($H50-D50)/ABS($H50-$J50))))","v":6},{"$f":"IF(E50<$H50,\"ERROR\",IF(E50>$I50,\"ERROR\",IF(E50>=$J50,$K50+(0.2*$K50*ABS(E50-$J50)/ABS($I50-$J50)),$K50*ABS($H50-E50)/ABS($H50-$J50))))","v":5},"ERROR"]
["POS",null,"Nº de apuntes (seguimiento) Libro Órdenes/mes",6,4,4,"(1, (PEM/(Nº meses*75000))",1,{"$f":"ROUNDUP((D2/(D4*75000)),0)","v":8},{"$f":"ROUNDUP((H51+2/3*(I51-H51)),0)","v":6},10,{"$f":"IF(D51<$H51,\"ERROR\",IF(D51>$I51,\"ERROR\",IF(D51>=$J51,$K51+(0.2*$K51*ABS(D51-$J51)/ABS($I51-$J51)),$K51*ABS($H51-D51)/ABS($H51-$J51))))","v":10},6,6]
["POS",null,"Nº de visitas/reuniones de obra/mes",6,5,5,"(1, (PEM/(Nº meses*75000))",1,{"$f":"ROUNDUP((D2/(D4*75000)),0)","v":8},{"$f":"ROUNDUP((H52+2/3*(I52-H52)),0)","v":6},5,{"$f":"IF(D52<$H52,\"ERROR\",IF(D52>$I52,\"ERROR\",IF(D52>=$J52,$K52+(0.2*$K52*ABS(D52-$J52)/ABS($I52-$J52)),$K52*ABS($H52-D52)/ABS($H52-$J52))))","v":5},4,4]
["POS",null,"Nº de informes de control para el promotor/mes",6,5,3,"(0, (PEM/(Nº meses*150000))",1,{"$f":"ROUNDUP((D2/(D4*75000)),0)","v":8},{"$f":"ROUNDUP((H53+2/3*(I53-H53)),0)","v":6},15,{"$f":"IF(D53<$H53,\"ERROR\",IF(D53>$I53,\"ERROR\",IF(D53>=$J53,$K53+(0.2*$K53*ABS(D53-$J53)/ABS($I53-$J53)),$K53*ABS($H53-D53)/ABS($H53-$J53))))","v":15},12,6]
["NEG",null,"Nº de recomendaciones del Coordinador de seguridad/mes",2,2,3,"(0, (PEM/(Nº meses*150000))",0,{"$f":"ROUNDUP((D2/(D4*150000)),0)","v":4},2,20,{"$f":"IF(D54<$H54,\"ERROR\",IF(D54>$I54,\"ERROR\",IF(D54<=$J54,$K54+(0.2*$K54*ABS(D54-$J54)/ABS($H54-$J54)),$K54*ABS($I54-D54)/ABS($I54-$J54))))","v":20},20,10]
["NEG",null,"Nº de recomendaciones de la Asistencia Técnica/mes",10,10,10,"(0, (PEM/(Nº meses*20000))",0,{"$f":"ROUNDUP((D2/(D4*20000)),0)","v":28},10,5,{"$f":"IF(D55<$H55,\"ERROR\",IF(D55>$I55,\"ERROR\",IF(D55<=$J55,$K55+(0.2*$K55*ABS(D55-$J55)/ABS($H55-$J55)),$K55*ABS($I55-D55)/ABS($I55-$J55))))","v":5},5,5]
["POS",null,"Nº de recomendaciones de la Asistencia Técnica consideradas/mes",13,11,9,"(0, (PEM/(Nº meses*25000))",0,{"$f":"ROUNDUP((D2/(D4*25000)),0)","v":23},{"$f":"ROUNDUP((H56+2/3*(I56-H56)),0)","v":16},5,{"$f":"IF(D56<$H56,\"ERROR\",IF(D56>$I56,\"ERROR\",IF(D56>=$J56,$K56+(0.2*$K56*ABS(D56-$J56)/ABS($I56-$J56)),$K56*ABS($H56-D56)/ABS($H56-$J56))))","v":4.0625},{"$f":"IF(E56<$H56,\"ERROR\",IF(E56>$I56,\"ERROR\",IF(E56>=$J56,$K56+(0.2*$K56*ABS(E56-$J56)/ABS($I56-$J56)),$K56*ABS($H56-E56)/ABS($H56-$J56))))","v":3.4375},{"$f":"IF(F56<$H56,\"ERROR\",IF(F56>$I56,\"ERROR\",IF(F56>=$J56,$K56+(0.2*$K56*ABS(F56-$J56)/ABS($I56-$J56)),$K56*ABS($H56-F56)/ABS($H56-$J56))))","v":2.8125}]
[null,null,"E2 INDICADORES DIRECTOR OBRA",null,null,null,null,null,null,null,{"$f":"SUM(K47:K56)","v":100},{"$f":"SUM(L47:L56)","v":101.0625},{"$f":"SUM(M47:M56)","v":90.4375},{"$f":"SUM(N47:N56)","v":69.8125},10,{"$f":"$O57*L57/100","v":10.106249999999999},{"$f":"$O57*M57/100","v":9.0437499999999993},{"$f":"$O57*N57/100","v":6.9812500000000002}]
[]
[]
[null,null,"E3 INDICADORES DIRECTOR EJECUCIÓN OBRA","OBRA 1","OBRA 2","OBRA 3","INTERVALO","MIN","MAX","ESTÁNDAR","PESO DE REFERENCIA","PESO REAL","PESO REAL 2","PESO REAL 3","PESO DE REF DEL GRUPO","PESO REAL DEL GRUPO 1","PESO REAL DEL GRUPO 2","PESO REAL DEL GRUPO 3"]
[null,null,"DATO: Nº Materiales recibidos/mes= Total mat",10]
["NEG",null,"Nº de materiales rechazados/mes por doc. incompleta",2,3,4,"(0, Total mat)",0,{"$f":"D61","v":10},{"$f":"ROUNDUP((H62+1/3*(I62-H62)),0)","v":4},10,{"$f":"IF(D62<$H62,\"ERROR\",IF(D62>$I62,\"ERROR\",IF(D62<=$J62,$K62+(0.2*$K62*ABS(D62-$J62)/ABS($H62-$J62)),$K62*ABS($I62-D62)/ABS($I62-$J62))))","v":11},{"$f":"IF(E62<$H62,\"ERROR\",IF(E62>$I62,\"ERROR\",IF(E62<=$J62,$K62+(0.2*$K62*ABS(E62-$J62)/ABS($H62-$J62)),$K62*ABS($I62-E62)/ABS($I62-$J62))))","v":10.5},10]
["POS",null,"Nº de materiales aceptados/mes",8,8,6,"(0, Total mat)",0,{"$f":"D61","v":10},{"$f":"ROUNDUP((H63+2/3*(I63-H63)),0)","v":7},5,{"$f":"IF(D63<$H63,\"ERROR\",IF(D63>$I63,\"ERROR\",IF(D63>=$J63,$K63+(0.2*$K63*ABS(D63-$J63)/ABS($I63-$J63)),$K63*ABS($H63-D63)/ABS($H63-$J63))))","v":5.333333333333333},{"$f":"IF(E63<$H63,\"ERROR\",IF(E63>$I63,\"ERROR\",IF(E63>=$J63,$K63+(0.2*$K63*ABS(E63-$J63)/ABS($I63-$J63)),$K63*ABS($H63-E63)/ABS($H63-$J63))))","v":5.333333333333333},{"$f":"IF(F63<$H63,\"ERROR\",IF(F63>$I63,\"ERROR\",IF(F63>=$J63,$K63+(0.2*$K63*ABS(F63-$J63)/ABS($I63-$J63)),$K63*ABS($H63-F63)/ABS($H63-$J63))))","v":4.2857142857142856}]
["NEG",null,"Nº de solicitudes complementarias de documentación de materiales",5,5,6,"(0, Total mat)",0,{"$f":"D61","v":10},{"$f":"ROUNDUP((H64+1/3*(I64-H64)),0)","v":4},5,{"$f":"IF(D64<$H64,\"ERROR\",IF(D64>$I64,\"ERROR\",IF(D64<=$J64,$K64+(0.2*$K64*ABS(D64-$J64)/ABS($H64-$J64)),$K64*ABS($I64-D64)/ABS($I64-$J64))))","v":4.166666666666667},4.166666666666667,3.3333333333333335]
["NEG",null,"Nº de correcciones de la ejecución/mes",1,2,4,"(0, (PEM/(Nº meses*150000))*1,33)",0,{"$f":"ROUNDUP((D2/(D4*75000)),0)","v":8},{"$f":"ROUNDUP((H65+1/3*(I65-H65)),0)","v":3},10,{"$f":"IF(D65<$H65,\"ERROR\",IF(D65>$I65,\"ERROR\",IF(D65<=$J65,$K65+(0.2*$K65*ABS(D65-$J65)/ABS($H65-$J65)),$K65*ABS($I65-D65)/ABS($I65-$J65))))","v":11.333333333333334},10.666666666666666,8]
["POS",null,"Nº de recomendaciones de la Asistencia Técnica consideradas/mes",15,12,6,"(0, (PEM/(Nº meses*25000))",0,{"$f":"ROUNDUP((D2/(D4*25000)),0)","v":23},{"$f":"ROUNDUP((H66+2/3*(I66-H66)),0)","v":16},5,{"$f":"IF(D66<$H66,\"ERROR\",IF(D66>$I66,\"ERROR\",IF(D66>=$J66,$K66+(0.2*$K66*ABS(D66-$J66)/ABS($I66-$J66)),$K66*ABS($H66-D66)/ABS($H66-$J66))))","v":4.6875},3.75,1.875]
["POS",null,"Nº de visitas/reuniones de obra",6,4,4,"(1, (PEM/(Nº meses*75000))",1,{"$f":"ROUNDUP((D2/(D4*75000)),0)","v":8},{"$f":"ROUNDUP((H67+2/3*(I67-H67)),0)","v":6},5,5,3,3]
["NEG",null,"Nº de recomendaciones del Coordinador de seguridad/mes",2,3,3,"(0, (PEM/(Nº meses*150000))",0,{"$f":"ROUNDUP((D2/(D4*150000)),0)","v":4},{"$f":"ROUNDUP((H68+1/3*(I68-H68)),0)","v":2},20,{"$f":"IF(D68<$H68,\"ERROR\",IF(D68>$I68,\"ERROR\",IF(D68<=$J68,$K68+(0.2*$K68*ABS(D68-$J68)/ABS($H68-$J68)),$K68*ABS($I68-D68)/ABS($I68-$J68))))","v":20},10,10]
["NEG",null,"% Ajuste en plazo de la aplicación del Plan de Control/mes",0.9,1,1,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,20,{"$f":"IF(D69<$H69,\"ERROR\",IF(D69>$I69,\"ERROR\",IF(D69<=$J69,$K69+(0.2*$K69*ABS(D69-$J69)/ABS($H69-$J69)),$K69*ABS($I69-D69)/ABS($I69-$J69))))","v":21.6},20,20]
["NEG",null,"% Ajuste en presupuesto de la aplicación del Plan de Control/mes",0.9,1.1499999999999999,1.1000000000000001,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,20,{"$f":"IF(D70<$H70,\"ERROR\",IF(D70>$I70,\"ERROR\",IF(D70<=$J70,$K70+(0.2*$K70*ABS(D70-$J70)/ABS($H70-$J70)),$K70*ABS($I70-D70)/ABS($I70-$J70))))","v":21.6},8.0000000000000071,11.999999999999993]
[null,null,"E3 INDICADORES DIRECTOR EJECUCIÓN OBRA",null,null,null,null,null,null,null,{"$f":"SUM(K62:K70)","v":100},{"$f":"SUM(L62:L70)","v":104.72083333333333},{"$f":"SUM(M62:M70)","v":75.416666666666657},{"$f":"SUM(N62:N70)","v":72.49404761904762},10,{"$f":"$O71*L71/100","v":10.472083333333332},{"$f":"$O71*M71/100","v":7.5416666666666652},{"$f":"$O71*N71/100","v":7.2494047619047617}]
[]
[]
[null,null,"E4 INDICADORES ASISTENCIA TÉCNICA","OBRA 1","OBRA 2","OBRA 3","INTERVALO","MIN","MAX","ESTÁNDAR","PESO","PESO REAL","PESO REAL 2","PESO REAL 3","PESO DE REF DEL GRUPO","PESO REAL DEL GRUPO 1","PESO REAL DEL GRUPO 2","PESO REAL DEL GRUPO 3"]
["NEG",null,"No conformidades detectadas/mes (*)",18,18,20,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"ROUNDUP((D2/(D4*15000)),0)","v":38},{"$f":"ROUNDUP((H75+1/3*(I75-H75)),0)","v":13},10,{"$f":"IF(D75<$H75,\"ERROR\",IF(D75>$I75,\"ERROR\",IF(D75<=$J75,$K75+(0.2*$K75*ABS(D75-$J75)/ABS($H75-$J75)),$K75*ABS($I75-D75)/ABS($I75-$J75))))","v":8},{"$f":"IF(E75<$H75,\"ERROR\",IF(E75>$I75,\"ERROR\",IF(E75<=$J75,$K75+(0.2*$K75*ABS(E75-$J75)/ABS($H75-$J75)),$K75*ABS($I75-E75)/ABS($I75-$J75))))","v":8},7.2]
["POS",null,"No conformidades resueltas/mes (*)",16,13,16,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"D75","v":18},{"$f":"ROUNDUP((H76+2/3*(I76-H76)),0)","v":12},5,{"$f":"IF(D76<$H76,\"ERROR\",IF(D76>$I76,\"ERROR\",IF(D76>=$J76,$K76+(0.2*$K76*ABS(D76-$J76)/ABS($I76-$J76)),$K76*ABS($H76-D76)/ABS($H76-$J76))))","v":5.666666666666667},{"$f":"IF(E76<$H76,\"ERROR\",IF(E76>$I76,\"ERROR\",IF(E76>=$J76,$K76+(0.2*$K76*ABS(E76-$J76)/ABS($I76-$J76)),$K76*ABS($H76-E76)/ABS($H76-$J76))))","v":5.166666666666667},{"$f":"IF(F76<$H76,\"ERROR\",IF(F76>$I76,\"ERROR\",IF(F76>=$J76,$K76+(0.2*$K76*ABS(F76-$J76)/ABS($I76-$J76)),$K76*ABS($H76-F76)/ABS($H76-$J76))))","v":5.666666666666667}]
["NEG",null,"No conformidades pendientes /mes (*)",{"$f":"D75-D76","v":2},{"$f":"E75-E76","v":5},{"$f":"F75-F76","v":4},"(0, (PEM/(Nº meses*1500)))",0,{"$f":"D75","v":18},{"$f":"ROUNDUP((H77+1/3*(I77-H77)),0)","v":6},10,{"$f":"IF(D77<$H77,\"ERROR\",IF(D77>$I77,\"ERROR\",IF(D77<=$J77,$K77+(0.2*$K77*ABS(D77-$J77)/ABS($H77-$J77)),$K77*ABS($I77-D77)/ABS($I77-$J77))))","v":11.333333333333334},10.333333333333334,10.666666666666666]
["NEG",null,"Nº de acciones de doble control/mes (*)",4,8,10,"(0, No conformidades/3)",0,{"$f":"ROUNDUP((I75/3),0)","v":13},{"$f":"ROUNDUP((H78+1/3*(I78-H78)),0)","v":5},5,{"$f":"IF(D78<$H78,\"ERROR\",IF(D78>$I78,\"ERROR\",IF(D78<=$J78,$K78+(0.2*$K78*ABS(D78-$J78)/ABS($H78-$J78)),$K78*ABS($I78-D78)/ABS($I78-$J78))))","v":5.2},3.125,1.875]
["NEG",null,"Nº de acciones de triple (o +) control/mes (*)",1,3,5,"(0, No conformidades/6)",0,{"$f":"ROUNDUP((I75/6),0)","v":7},{"$f":"ROUNDUP((H79+1/3*(I79-H79)),0)","v":3},10,{"$f":"IF(D79<$H79,\"ERROR\",IF(D79>$I79,\"ERROR\",IF(D79<=$J79,$K79+(0.2*$K79*ABS(D79-$J79)/ABS($H79-$J79)),$K79*ABS($I79-D79)/ABS($I79-$J79))))","v":11.333333333333334},10,5]
["NEG",null,"Nº de recomendaciones al director de obra/mes",8,15,18,"(0, (PEM/(Nº meses*20000))",0,{"$f":"ROUNDUP((D2/(D4*20000)),0)","v":28},{"$f":"ROUNDUP((H80+1/3*(I80-H80)),0)","v":10},10,{"$f":"IF(D80<$H80,\"ERROR\",IF(D80>$I80,\"ERROR\",IF(D80<=$J80,$K80+(0.2*$K80*ABS(D80-$J80)/ABS($H80-$J80)),$K80*ABS($I80-D80)/ABS($I80-$J80))))","v":10.4},7.2222222222222223,5.5555555555555554]
["NEG",null,"Nº de recomendaciones del Coordinador de seguridad/mes",1,1,2,"(0, (PEM/(Nº meses*300000))",0,{"$f":"ROUNDUP((D2/(D4*300000)),0)","v":2},{"$f":"ROUNDUP((H81+1/3*(I81-H81)),0)","v":1},10,{"$f":"IF(D81<$H81,\"ERROR\",IF(D81>$I81,\"ERROR\",IF(D81<=$J81,$K81+(0.2*$K81*ABS(D81-$J81)/ABS($H81-$J81)),$K81*ABS($I81-D81)/ABS($I81-$J81))))","v":10},10,0]
["POS",null,"Nº de visitas/reuniones de obra/mes",5,4,4,"(1, (PEM/(Nº meses*75000))",1,{"$f":"ROUNDUP((D2/(D4*75000)),0)","v":8},{"$f":"ROUNDUP((H82+2/3*(I82-H82)),0)","v":6},10,{"$f":"IF(D82<$H82,\"ERROR\",IF(D82>$I82,\"ERROR\",IF(D82>=$J82,$K82+(0.2*$K82*ABS(D82-$J82)/ABS($I82-$J82)),$K82*ABS($H82-D82)/ABS($H82-$J82))))","v":8},{"$f":"IF(E82<$H82,\"ERROR\",IF(E82>$I82,\"ERROR\",IF(E82>=$J82,$K82+(0.2*$K82*ABS(E82-$J82)/ABS($I82-$J82)),$K82*ABS($H82-E82)/ABS($H82-$J82))))","v":6},{"$f":"IF(F82<$H82,\"ERROR\",IF(F82>$I82,\"ERROR\",IF(F82>=$J82,$K82+(0.2*$K82*ABS(F82-$J82)/ABS($I82-$J82)),$K82*ABS($H82-F82)/ABS($H82-$J82))))","v":6}]
[null,null,"Nº de comunicaciones fuera de plazo/mes",2,4,4,"(0, 5)",0,5,4,10,{"$f":"IF(D83<$H83,\"ERROR\",IF(D83>$I83,\"ERROR\",IF(D83<=$J83,$K83+(0.2*$K83*ABS(D83-$J83)/ABS($H83-$J83)),$K83*ABS($I83-D83)/ABS($I83-$J83))))","v":11},10,10]
["POS",null,"Nº de informes de control para el promotor/mes",2,1,2,"(0, (PEM/(Nº meses*150000))",1,{"$f":"ROUNDUP((D2/(D4*150000)),0)","v":4},1,20,{"$f":"IF(D84<$H84,\"ERROR\",IF(D84>$I84,\"ERROR\",IF(D84>=$J84,$K84+(0.2*$K84*ABS(D84-$J84)/ABS($I84-$J84)),$K84*ABS($H84-D84)/ABS($H84-$J84))))","v":21.333333333333332},{"$f":"IF(E84<$H84,\"ERROR\",IF(E84>$I84,\"ERROR\",IF(E84>=$J84,$K84+(0.2*$K84*ABS(E84-$J84)/ABS($I84-$J84)),$K84*ABS($H84-E84)/ABS($H84-$J84))))","v":20},{"$f":"IF(F84<$H84,\"ERROR\",IF(F84>$I84,\"ERROR\",IF(F84>=$J84,$K84+(0.2*$K84*ABS(F84-$J84)/ABS($I84-$J84)),$K84*ABS($H84-F84)/ABS($H84-$J84))))","v":21.333333333333332}]
[null,null,"E4 INDICADORES ASISTENCIA TÉCNICA",null,null,null,null,null,null,null,{"$f":"SUM(K75:K84)","v":100},{"$f":"SUM(L75:L84)","v":102.26666666666667},{"$f":"SUM(M75:M84)","v":89.847222222222229},{"$f":"SUM(N75:N84)","v":73.297222222222217},10,{"$f":"$O85*L85/100","v":10.226666666666667},{"$f":"$O85*M85/100","v":8.9847222222222225},{"$f":"$O85*N85/100","v":7.3297222222222214}]
[]
[]
[null,null,"E5 INDICADORES LABORATORIO DE ENSAYOS","OBRA 1","OBRA 2","OBRA 3","INTERVALO","MIN","MAX","ESTÁNDAR","PESO","PESO REAL","PESO REAL 2","PESO REAL 3","PESO DE REF DEL GRUPO","PESO REAL DEL GRUPO 1","PESO REAL DEL GRUPO 2","PESO REAL DEL GRUPO 3"]
["NEG",null,"No conformidades detectadas/mes (*)",18,18,25,"(0, (PEM/(Nº meses*1500)))",0,{"$f":"ROUNDUP((D2/(D4*15000)),0)","v":38},{"$f":"ROUNDUP((H89+1/3*(I89-H89)),0)","v":13},10,{"$f":"IF(D89<$H89,\"ERROR\",IF(D89>$I89,\"ERROR\",IF(D89<=$J89,$K89+(0.2*$K89*ABS(D89-$J89)/ABS($H89-$J89)),$K89*ABS($I89-D89)/ABS($I89-$J89))))","v":8},{"$f":"IF(E89<$H89,\"ERROR\",IF(E89>$I89,\"ERROR\",IF(E89<=$J89,$K89+(0.2*$K89*ABS(E89-$J89)/ABS($H89-$J89)),$K89*ABS($I89-E89)/ABS($I89-$J89))))","v":8},5.2]
["NEG",null,"Nº de ensayos repetidos/mes (*)",6,6,10,"(0, No conformidades/3)",0,{"$f":"ROUNDUP((I89/3),0)","v":13},{"$f":"ROUNDUP((H90+1/3*(I90-H90)),0)","v":5},20,17.5,17.5,7.5]
["NEG",null,"Nº de comunicaciones de anomalías al director de obra/mes",5,6,6,"(0, (PEM/(Nº meses*20000))",0,22,{"$f":"ROUNDUP((H91+1/3*(I91-H91)),0)","v":8},15,16.125,15.75,15.75]
["NEG",null,"Nº de recomendaciones del Coordinador de seguridad/mes",1,1,1,"(0, (PEM/(Nº meses*300000))",0,{"$f":"ROUNDUP((D20/(D21*300000)),0)","v":1},{"$f":"ROUNDUP((H92+1/3*(I92-H92)),0)","v":1},5,5,5,5]
["NEG",null,"% Ajuste en plazo de la aplicación del Plan de Control/mes",0.9,1,1,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,15,16.2,15,15]
["NEG",null,"% Ajuste en presupuesto de la aplicación del Plan de Control/mes",0.9,1.05,1,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,15,16.2,11.999999999999996,15]
["POS",null,"Nº de visitas/reuniones de obra/mes",3,3,3,"(1, (PEM/(Nº meses*75000))",1,4,{"$f":"ROUNDUP((H95+2/3*(I95-H95)),0)","v":3},10,{"$f":"IF(D95<$H95,\"ERROR\",IF(D95>$I95,\"ERROR\",IF(D95>=$J95,$K95+(0.2*$K95*ABS(D95-$J95)/ABS($I95-$J95)),$K95*ABS($H95-D95)/ABS($H95-$J95))))","v":10},10,10]
["POS",null,"Nº de informes de control para el promotor/mes",1,1,1,"(0, (PEM/(Nº meses*150000))",1,{"$f":"ROUNDUP((D2/(D4*150000)),0)","v":4},1,10,10,10,10]
[null,null,"E5 INDICADORES LABORATORIO DE ENSAYOS",null,null,null,null,null,null,null,{"$f":"SUM(K89:K96)","v":100},{"$f":"SUM(L89:L96)","v":99.025000000000006},{"$f":"SUM(M89:M96)","v":93.25},{"$f":"SUM(N89:N96)","v":83.45},10,{"$f":"$O97*L97/100","v":9.9024999999999999},{"$f":"$O97*M97/100","v":9.3249999999999993},{"$f":"$O97*N97/100","v":8.3450000000000006}]
[]
[]
[null,null,"E6 INDICADORES EMPRESA CONSTRUCTORA","OBRA 1","OBRA 2","OBRA 3","INTERVALO","MIN","MAX","ESTÁNDAR","PESO","PESO REAL 1","PESO REAL 2","PESO REAL 3","PESO DE REF DEL GRUPO","PESO REAL DEL GRUPO 1","PESO REAL DEL GRUPO 2","PESO REAL DEL GRUPO 3"]
["POS",null,"Nº de instrucciones de modificación Libro Órdenes/mes",3,3,4,"(0, (PEM/(Nº meses*150000))",0,{"$f":"ROUNDUP((D2/(D4*150000)),0)","v":4},{"$f":"ROUNDUP((H101+2/3*(I101-H101)),0)","v":3},5,{"$f":"IF(D101<$H101,\"ERROR\",IF(D101>$I101,\"ERROR\",IF(D101>=$J101,$K101+(0.2*$K101*ABS(D101-$J101)/ABS($I101-$J101)),$K101*ABS($H101-D101)/ABS($H101-$J101))))","v":5},{"$f":"IF(E101<$H101,\"ERROR\",IF(E101>$I101,\"ERROR\",IF(E101>=$J101,$K101+(0.2*$K101*ABS(E101-$J101)/ABS($I101-$J101)),$K101*ABS($H101-E101)/ABS($H101-$J101))))","v":5},{"$f":"IF(F101<$H101,\"ERROR\",IF(F101>$I101,\"ERROR\",IF(F101>=$J101,$K101+(0.2*$K101*ABS(F101-$J101)/ABS($I101-$J101)),$K101*ABS($H101-F101)/ABS($H101-$J101))))","v":6}]
["NEG",null,"% Ajuste en plazo de ejecución",0.9,1,1.1000000000000001,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,20,{"$f":"IF(D102<$H102,\"ERROR\",IF(D102>$I102,\"ERROR\",IF(D102<=$J102,$K102+(0.2*$K102*ABS(D102-$J102)/ABS($H102-$J102)),$K102*ABS($I102-D102)/ABS($I102-$J102))))","v":21.6},{"$f":"IF(E102<$H102,\"ERROR\",IF(E102>$I102,\"ERROR\",IF(E102<=$J102,$K102+(0.2*$K102*ABS(E102-$J102)/ABS($H102-$J102)),$K102*ABS($I102-E102)/ABS($I102-$J102))))","v":20},{"$f":"IF(F102<$H102,\"ERROR\",IF(F102>$I102,\"ERROR\",IF(F102<=$J102,$K102+(0.2*$K102*ABS(F102-$J102)/ABS($H102-$J102)),$K102*ABS($I102-F102)/ABS($I102-$J102))))","v":11.999999999999993}]
["NEG",null,"% Ajuste presupuesto sobre el total anual",0.9,1.05,0.9,"(75%PEM CONTROL, 125% PEM Control)",0.75,1.25,1,40,{"$f":"IF(D103<$H103,\"ERROR\",IF(D103>$I103,\"ERROR\",IF(D103<=$J103,$K103+(0.2*$K103*ABS(D103-$J103)/ABS($H103-$J103)),$K103*ABS($I103-D103)/ABS($I103-$J103))))","v":43.2},{"$f":"IF(E103<$H103,\"ERROR\",IF(E103>$I103,\"ERROR\",IF(E103<=$J103,$K103+(0.2*$K103*ABS(E103-$J103)/ABS($H103-$J103)),$K103*ABS($I103-E103)/ABS($I103-$J103))))","v":31.999999999999993},43.2]
["NEG",null,"Nº de instrucciones aspectos seguridad laboral/mes ",2,2,4,"(0, (PEM/(Nº meses*150000))",0,{"$f":"ROUNDUP((D2/(D4*150000)),0)","v":4},{"$f":"ROUNDUP((H104+1/3*(I104-H104)),0)","v":2},10,{"$f":"IF(D104<$H104,\"ERROR\",IF(D104>$I104,\"ERROR\",IF(D104<=$J104,$K104+(0.2*$K104*ABS(D104-$J104)/ABS($H104-$J104)),$K104*ABS($I104-D104)/ABS($I104-$J104))))","v":10},{"$f":"IF(E104<$H104,\"ERROR\",IF(E104>$I104,\"ERROR\",IF(E104<=$J104,$K104+(0.2*$K104*ABS(E104-$J104)/ABS($H104-$J104)),$K104*ABS($I104-E104)/ABS($I104-$J104))))","v":10},{"$f":"IF(F104<$H104,\"ERROR\",IF(F104>$I104,\"ERROR\",IF(F104<=$J104,$K104+(0.2*$K104*ABS(F104-$J104)/ABS($H104-$J104)),$K104*ABS($I104-F104)/ABS($I104-$J104))))","v":0}]
["NEG",null,"Nº de recomendaciones del Coordinador de seguridad/mes",3,4,5,"(0, (PEM/(Nº meses*100000))",0,{"$f":"ROUNDUP((D2/(D4*100000)),0)","v":6},{"$f":"ROUNDUP((H105+1/3*(I105-H105)),0)","v":2},10,{"$f":"IF(D105<$H105,\"ERROR\",IF(D105>$I105,\"ERROR\",IF(D105<=$J105,$K105+(0.2*$K105*ABS(D105-$J105)/ABS($H105-$J105)),$K105*ABS($I105-D105)/ABS($I105-$J105))))","v":7.5},5,2.5]
["NEG",null,"Nº de materiales rechazados/mes por cualquier causa",2,4,6,"(0, Total mat)",0,{"$f":"D61","v":10},{"$f":"ROUNDUP((H106+1/3*(I106-H106)),0)","v":4},10,{"$f":"IF(D106<$H106,\"ERROR\",IF(D106>$I106,\"ERROR\",IF(D106<=$J106,$K106+(0.2*$K106*ABS(D106-$J106)/ABS($H106-$J106)),$K106*ABS($I106-D106)/ABS($I106-$J106))))","v":11},{"$f":"IF(E106<$H106,\"ERROR\",IF(E106>$I106,\"ERROR\",IF(E106<=$J106,$K106+(0.2*$K106*ABS(E106-$J106)/ABS($H106-$J106)),$K106*ABS($I106-E106)/ABS($I106-$J106))))","v":10},{"$f":"IF(F106<$H106,\"ERROR\",IF(F106>$I106,\"ERROR\",IF(F106<=$J106,$K106+(0.2*$K106*ABS(F106-$J106)/ABS($H106-$J106)),$K106*ABS($I106-F106)/ABS($I106-$J106))))","v":6.666666666666667}]
["POS",null,"Nº de recomendaciones de la Asistencia Técnica/mes",20,18,17,"(0, (PEM/(Nº meses*25000))",0,{"$f":"ROUNDUP((D2/(D4*25000)),0)","v":23},{"$f":"ROUNDUP((H107+2/3*(I107-H107)),0)","v":16},5,{"$f":"IF(D107<$H107,\"ERROR\",IF(D107>$I107,\"ERROR\",IF(D107>=$J107,$K107+(0.2*$K107*ABS(D107-$J107)/ABS($I107-$J107)),$K107*ABS($H107-D107)/ABS($H107-$J107))))","v":5.5714285714285712},{"$f":"IF(E107<$H107,\"ERROR\",IF(E107>$I107,\"ERROR\",IF(E107>=$J107,$K107+(0.2*$K107*ABS(E107-$J107)/ABS($I107-$J107)),$K107*ABS($H107-E107)/ABS($H107-$J107))))","v":5.2857142857142856},{"$f":"IF(F107<$H107,\"ERROR\",IF(F107>$I107,\"ERROR\",IF(F107>=$J107,$K107+(0.2*$K107*ABS(F107-$J107)/ABS($I107-$J107)),$K107*ABS($H107-F107)/ABS($H107-$J107))))","v":5.1428571428571432}]
[null,null,"E6 INDICADORES EMPRESA CONSTRUCTORA",null,null,null,null,null,null,null,{"$f":"SUM(K101:K107)","v":100},{"$f":"SUM(L101:L107)","v":103.87142857142858},{"$f":"SUM(M101:M107)","v":87.285714285714292},{"$f":"SUM(N101:N107)","v":75.509523809523799},20,{"$f":"$O108*L108/100","v":20.774285714285714},{"$f":"$O108*M108/100","v":17.457142857142859},{"$f":"$O108*N108/100","v":15.101904761904759}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBRA 1","OBRA 2","OBRA 3"]
[null,null,"ÍNDICE DE CALIDAD",null,null,null,null,null,null,null,null,null,null,null,{"$f":"O108+O85+O71+O57+O43+O27+O97","v":100},{"$f":"P108+P97+P85+P71+P57+P43+P27","v":103.71845238095237},{"$f":"Q108+Q97+Q85+Q71+Q57+Q43+Q27","v":91.928948412698418},{"$f":"R108+R97+R85+R71+R57+R43+R27","v":69.453948412698423}]
[]
[]
[]
[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,"A","Buena calidad"]
[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,"C","Calidad deficiente"]
[null,null,null,null,null,null,null,null,null,null,null,null,"D","Mala calidad"]