{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Registro","1-3","4-7","8-11","12-15","16","17-23","24-30","31","32-34","35-39","40","41-44"],"not_rendered":{"charts":50,"images":24,"macros":1,"external_links":3,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Registro","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
["TITULO","ESTUDIO DE IMPACTO AMBIENTAL: PROCEDIMIENTO Y HERRAMIENTAS"]
[]
["AUTORES","ROBERTO PECHE GONZALEZ"]
[null,"DOLORES ENCINAS MALAGON"]
[null,"ZURIÑE GOMEZ DE BALUGERA LOPEZ DE ALDA"]
[null,"MARIA ARRITOKIETA ORTUZAR IRAGORRI"]
[]
["ISBN:","978-84-613-9696-2"]

{"sheet":"1-3","index":1,"n_rows":109,"n_cols":5,"rows_kept":109,"merged":[[6,2,6,4],[49,2,49,4],[79,2,79,4]]}
["nº de indicador:",1,"función de transformación:","CA=-7,5E-05*I^2+1,75E-02*I","0<I<100"]
["Indicador:","Índice de calidad del aire (ICAIRE)"]
["fórmula del indicador"]
["unidad del indicador:","-"]
["rango de valores del indicador:","0 -100","valor del indicador",20]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=100,(-0.000075*(D5^2))+(0.0175*D5),\"valor del indicador fuera rango\"))","v":{"v":0.32000000000000006,"d":"0.320"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.000075*(A8^2)+0.0175*A8","v":{"v":0,"d":"0.000"}}]
[{"$f":"A8+5","v":5},{"$f":"-0.000075*(A9^2)+0.0175*A9","v":{"v":0.085625,"d":"0.086"}}]
[10,{"v":0.1675,"d":"0.168"}]
[15,{"v":0.245625,"d":"0.246"}]
[20,{"v":0.32000000000000006,"d":"0.320"}]
[25,{"v":0.39062500000000006,"d":"0.391"}]
[30,{"v":0.4575,"d":"0.458"}]
[35,{"v":0.520625,"d":"0.521"}]
[40,{"v":0.5800000000000001,"d":"0.580"}]
[45,{"v":0.6356250000000001,"d":"0.636"}]
[50,{"v":0.6875000000000001,"d":"0.688"}]
[55,{"v":0.7356250000000002,"d":"0.736"}]
[60,{"v":0.78,"d":"0.780"}]
[65,{"v":0.8206250000000002,"d":"0.821"}]
[70,{"v":0.8575000000000002,"d":"0.858"}]
[75,{"v":0.8906250000000002,"d":"0.891"}]
[80,{"v":0.9200000000000002,"d":"0.920"}]
[85,{"v":0.945625,"d":"0.946"}]
[90,{"v":0.9675000000000002,"d":"0.968"}]
[95,{"v":0.9856250000000002,"d":"0.986"}]
[100,{"v":1.0000000000000004,"d":"1.000"}]
{"$rows_empty":15}
["nº de indicador:",2,"función de transformación:","CA=(-0,0000966*I^2) -(0,00517*I) + 1","0<I<50"]
["Indicador:","Índice ORAQI (Oak Ridge Air Quality Index)",null,"CA=(0,0000912*I^2) -(0,0237*I) + 1,46","50<I<100"]
["fórmula del indicador"]
["unidad del indicador:","-"]
["rango de valores del indicador:","0 - 100","valor del indicador",55]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D48<0,\"valor del indicador fuera de rango\",IF(D48<=50,-0.0000966*(D48^2)-(0.00517*D48)+1,IF(D48<=100,(0.0000912*(D48^2))-(0.0237*D48)+1.46,\"valor del indicador fuera rango\")))","v":{"v":0.43238,"d":"0.432"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0000966*(A51^2)-(0.00517*A51)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A51+5","v":5},{"$f":"-0.0000966*(A52^2)-(0.00517*A52)+1","v":{"v":0.971735,"d":"0.972"}}]
[{"$f":"A52+5","v":10},{"v":0.93864,"d":"0.939"}]
[15,{"v":0.9007149999999999,"d":"0.901"}]
[20,{"v":0.8579600000000001,"d":"0.858"}]
[25,{"v":0.810375,"d":"0.810"}]
[30,{"v":0.75796,"d":"0.758"}]
[35,{"v":0.700715,"d":"0.701"}]
[40,{"v":0.63864,"d":"0.639"}]
[45,{"v":0.571735,"d":"0.572"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"$f":"0.0000912*(A62^2)-0.0237*A62+1.46","v":{"v":0.43238,"d":"0.432"}}]
[60,{"$f":"0.0000912*(A63^2)-0.0237*A63+1.46","v":{"v":0.36632,"d":"0.366"}}]
[65,{"v":0.30481999999999987,"d":"0.305"}]
[70,{"v":0.2478800000000001,"d":"0.248"}]
[75,{"v":0.1955,"d":"0.196"}]
[80,{"v":0.14768000000000003,"d":"0.148"}]
[85,{"v":0.10441999999999996,"d":"0.104"}]
[90,{"v":0.06571999999999978,"d":"0.066"}]
[95,{"v":0.03157999999999994,"d":"0.032"}]
[100,{"v":1.9999999999997797E-3,"d":"0.002"}]
[]
[]
["nº de indicador:",3,"función de transformación:","CA=-0,0139*I+1","0<I<36"]
["Indicador:","Índice de caracterización de tratamientos (ICT)",null,"CA=(-0,00526*I)+0,689","36<I<131"]
["fórmula del indicador",null,null,"CA=0","131<I<140"]
["unidad del indicador:","-"]
["rango de valores del indicador:","0 - 140","valor del indicador",60]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D78<0,\"valor del indicador fuera de rango\",IF(D78<=36,-0.0139*D78+1,IF(D78<=131,(-0.00526*D78)+0.689,IF(D78<=140,0,\"valor del indicador fuera rango\"))))","v":{"v":0.37339999999999995,"d":"0.373"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0139*A81+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A81+5","v":5},{"$f":"-0.0139*A82+1","v":{"v":0.9305,"d":"0.931"}}]
[10,0.861]
[15,{"v":0.7915,"d":"0.792"}]
[20,0.722]
[25,{"v":0.6525000000000001,"d":"0.653"}]
[30,0.583]
[35,{"v":0.5135000000000001,"d":"0.514"}]
[40,{"$f":"-0.00526*A89+0.689","v":{"v":0.4785999999999999,"d":"0.479"}}]
[45,{"$f":"-0.00526*A90+0.689","v":{"v":0.4522999999999999,"d":"0.452"}}]
[50,{"v":0.42599999999999993,"d":"0.426"}]
[55,{"v":0.39969999999999994,"d":"0.400"}]
[60,{"v":0.37339999999999995,"d":"0.373"}]
[65,{"v":0.34709999999999996,"d":"0.347"}]
[70,{"v":0.3208,"d":"0.321"}]
[75,{"v":0.29449999999999993,"d":"0.295"}]
[80,{"v":0.26819999999999994,"d":"0.268"}]
[85,{"v":0.24189999999999995,"d":"0.242"}]
[90,{"v":0.21559999999999996,"d":"0.216"}]
[95,{"v":0.18929999999999997,"d":"0.189"}]
[100,{"v":0.16299999999999992,"d":"0.163"}]
[105,{"v":0.13669999999999993,"d":"0.137"}]
[110,{"v":0.11039999999999994,"d":"0.110"}]
[115,{"v":0.08409999999999995,"d":"0.084"}]
[120,{"v":0.05779999999999996,"d":"0.058"}]
[125,{"v":0.03149999999999997,"d":"0.032"}]
[130,{"v":0.005199999999999982,"d":"0.005"}]
[135,{"v":0,"d":"0.000"}]
[140,{"v":0,"d":"0.000"}]

{"sheet":"4-7","index":2,"n_rows":123,"n_cols":5,"rows_kept":123,"merged":[[6,2,6,4],[37,2,37,4],[71,2,71,4],[105,2,105,4]]}
["nº de indicador:",4,"función de transformación:","CA=(-0,0036*I^2) -(0,00482*I) + 1","0<I<10,9"]
["Indicador:","Promedio diario de inmisión de CO",null,"CA=(0,00103*I^2) -(0,0689*I) + 1,15","10,9<I<32"]
["fórmula del indicador",null,null,"CA=0","32<I<34"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 34","valor del indicador",11]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=10.9,-0.0036*(D5^2)-(0.00482*D5)+1,IF(D5<=32,(0.00103*(D5^2))-(0.0689*D5)+1.15,IF(D5<=34,0,\"valor del indicador fuera rango\"))))","v":{"v":0.5167299999999999,"d":"0.517"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0036*(A8^2)-(0.00482*A8)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A8+2","v":2},{"v":0.97596,"d":"0.976"}]
[{"$f":"+A9+2","v":4},{"v":0.9231199999999999,"d":"0.923"}]
[6,{"v":0.84148,"d":"0.841"}]
[8,{"v":0.73104,"d":"0.731"}]
[10,{"v":0.5918,"d":"0.592"}]
[12,{"$f":"0.00103*(A14^2)-(0.0689*A14)+1.15","v":{"v":0.47151999999999994,"d":"0.472"}}]
[14,{"v":0.38727999999999996,"d":"0.387"}]
[16,{"v":0.3112799999999999,"d":"0.311"}]
[18,{"v":0.24351999999999996,"d":"0.244"}]
[20,{"v":0.18399999999999983,"d":"0.184"}]
[22,{"v":0.13271999999999995,"d":"0.133"}]
[24,{"v":0.08967999999999998,"d":"0.090"}]
[26,{"v":0.05487999999999982,"d":"0.055"}]
[27,{"v":0.04056999999999977,"d":"0.041"}]
[28,{"v":0.0283199999999999,"d":"0.028"}]
[29,{"v":0.01812999999999998,"d":"0.018"}]
[30,{"v":0.009999999999999787,"d":"0.010"}]
[31,{"v":0.003929999999999989,"d":"0.004"}]
[32,{"$f":"0.00103*(A27^2)-(0.0689*A27)+1.15","v":{"v":-8.0000000000080007E-5,"d":"-0.000"}}]
[33,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[34,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",5,"función de transformación:","CA=(-0,0036*I^2) -(0,00482*I) + 1","0<I<10,9"]
["Indicador:","Ponderación del nivel diario de inmisión de CO según la superficie de zonas homogéneas",null,"CA=(0,00103*I^2) -(0,0689*I) + 1,15","10,9<I<32"]
["fórmula del indicador",null,null,"CA=0","I>32"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 34","valor del indicador",14]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D36<0,\"valor del indicador fuera de rango\",IF(D36<=10.9,-0.0036*(D36^2)-(0.00482*D36)+1,IF(D36<=32,(0.00103*(D36^2))-(0.0689*D36)+1.15,IF(D36<=34,0,\"valor del indicador fuera rango\"))))","v":{"v":0.38727999999999996,"d":"0.387"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0036*(A39^2)-(0.00482*A39)+1","v":{"v":1,"d":"1.000"}}]
[2,{"v":0.97596,"d":"0.976"}]
[4,{"v":0.9231199999999999,"d":"0.923"}]
[6,{"v":0.84148,"d":"0.841"}]
[8,{"v":0.73104,"d":"0.731"}]
[10,{"v":0.5918,"d":"0.592"}]
[12,{"$f":"0.00103*(A45^2)-(0.0689*A45)+1.15","v":{"v":0.47151999999999994,"d":"0.472"}}]
[{"$f":"+A45+2","v":14},{"$f":"0.00103*(A46^2)-(0.0689*A46)+1.15","v":{"v":0.38727999999999996,"d":"0.387"}}]
[{"$f":"+A46+2","v":16},{"v":0.3112799999999999,"d":"0.311"}]
[{"$f":"+A47+2","v":18},{"v":0.24351999999999996,"d":"0.244"}]
[{"$f":"+A48+2","v":20},{"v":0.18399999999999983,"d":"0.184"}]
[21,{"v":0.15732999999999986,"d":"0.157"}]
[22,{"v":0.13271999999999995,"d":"0.133"}]
[23,{"v":0.1101700000000001,"d":"0.110"}]
[24,{"v":0.08967999999999998,"d":"0.090"}]
[25,{"v":0.07124999999999981,"d":"0.071"}]
[26,{"v":0.05487999999999982,"d":"0.055"}]
[27,{"v":0.04056999999999977,"d":"0.041"}]
[28,{"v":0.0283199999999999,"d":"0.028"}]
[29,{"v":0.01812999999999998,"d":"0.018"}]
[30,{"v":0.009999999999999787,"d":"0.010"}]
[31,{"v":0.003929999999999989,"d":"0.004"}]
[32,{"v":-8.0000000000080007E-5,"d":"-0.000"}]
[33,{"v":0,"d":"0.000"}]
[34,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",6,"función de transformación:","CA=(-0,0036*I^2) -(0,00482*I) + 1","0<I<10,9"]
["Indicador:","Ponderación del nivel diario de inmisión de CO según la población afectada en cada zona",null,"CA=(0,00103*I^2) -(0,0689*I) + 1,15","10,9<I<32"]
["fórmula del indicador",null,null,"CA=0","32<I<34"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 34","valor del indicador",33]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D70<0,\"valor del indicador fuera de rango\",IF(D70<=10.9,-0.0036*(D70^2)-(0.00482*D70)+1,IF(D70<=32,(0.00103*(D70^2))-(0.0689*D70)+1.15,IF(D70<34,0,\"valor del indicador fuera rango\"))))","v":{"v":0,"d":"0.000"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0036*(A73^2)-(0.00482*A73)+1","v":{"v":1,"d":"1.000"}}]
[2,{"v":0.97596,"d":"0.976"}]
[4,{"v":0.9231199999999999,"d":"0.923"}]
[6,{"v":0.84148,"d":"0.841"}]
[8,{"v":0.73104,"d":"0.731"}]
[10,{"v":0.5918,"d":"0.592"}]
[11,{"$f":"0.00103*(A79^2)-(0.0689*A79)+1.15","v":{"v":0.5167299999999999,"d":"0.517"}}]
[12,{"v":0.47151999999999994,"d":"0.472"}]
[14,{"v":0.38727999999999996,"d":"0.387"}]
[18,{"v":0.24351999999999996,"d":"0.244"}]
[20,{"v":0.18399999999999983,"d":"0.184"}]
[{"$f":"+A83+2","v":22},{"v":0.13271999999999995,"d":"0.133"}]
[{"$f":"+A84+1","v":23},{"v":0.1101700000000001,"d":"0.110"}]
[{"$f":"+A87-1","v":24},{"v":0.08967999999999998,"d":"0.090"}]
[25,{"v":0.07124999999999981,"d":"0.071"}]
[26,{"v":0.05487999999999982,"d":"0.055"}]
[27,{"v":0.04056999999999977,"d":"0.041"}]
[28,{"v":0.0283199999999999,"d":"0.028"}]
[29,{"v":0.01812999999999998,"d":"0.018"}]
[30,{"v":0.009999999999999787,"d":"0.010"}]
[31,{"v":0.003929999999999989,"d":"0.004"}]
[32,{"v":-8.0000000000080007E-5,"d":"-0.000"}]
[32,{"v":0,"d":"0.000"}]
[33,{"v":0,"d":"0.000"}]
[34,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",7,"función de transformación:","CA= -0.01* I + 1","0<I<100"]
["Indicador:","% de personas afectadas por los niveles de CO perjudiciales"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",20]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D104<0,\"valor del indicador fuera de rango\",IF(D104<=100,-0.01*(D104)+1,\"valor del indicador fuera rango\"))","v":{"v":0.8,"d":"0.800"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.01*A107+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A107+5","v":5},{"v":0.95,"d":"0.950"}]
[10,{"v":0.9,"d":"0.900"}]
[15,{"v":0.85,"d":"0.850"}]
[20,{"v":0.8,"d":"0.800"}]
[25,{"v":0.75,"d":"0.750"}]
[30,{"v":0.7,"d":"0.700"}]
[35,{"v":0.6499999999999999,"d":"0.650"}]
[40,{"v":0.6,"d":"0.600"}]
[45,{"v":0.55,"d":"0.550"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.44999999999999996,"d":"0.450"}]
[60,{"v":0.4,"d":"0.400"}]
[70,{"v":0.29999999999999993,"d":"0.300"}]
[80,{"v":0.19999999999999996,"d":"0.200"}]
[90,{"v":0.09999999999999998,"d":"0.100"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"8-11","index":3,"n_rows":123,"n_cols":5,"rows_kept":123,"merged":[[6,2,6,4],[37,2,37,4],[71,2,71,4],[105,2,105,4]]}
["nº de indicador:",8,"función de transformación:","CA= -2,5E-0,5*I^2 - 2,21E-03 * I + 1","0<I<104,5"]
["Indicador:","Promedio diario de inmisión de NOx",null,"CA=1,51E-05*I^2-9,81E-03+1,36","104,5<I<200"]
["fórmula del indicador"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 200","valor del indicador",110]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=104.5,-0.000025*(D5^2)-(0.00221*D5)+1,IF(D5<=200,(0.0000151*(D5^2))-(0.00981*D5)+1.36,\"valor del indicador fuera rango\")))","v":{"v":0.4636100000000001,"d":"0.464"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.000025*(A8^2)-(0.00221*A8)+1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"-0.000025*(A9^2)-(0.00221*A9)+1","v":{"v":0.9754,"d":"0.975"}}]
[20,{"v":0.9458,"d":"0.946"}]
[30,{"v":0.9112,"d":"0.911"}]
[40,{"v":0.8715999999999999,"d":"0.872"}]
[50,0.827]
[60,{"v":0.7774,"d":"0.777"}]
[70,{"v":0.7228,"d":"0.723"}]
[80,{"v":0.6632,"d":"0.663"}]
[90,{"v":0.5986,"d":"0.599"}]
[100,{"v":0.5289999999999999,"d":"0.529"}]
[105,{"$f":"0.0000151*(A19^2)-(0.00981*A19)+1.36","v":{"v":0.49642750000000024,"d":"0.496"}}]
[110,{"$f":"0.0000151*(A20^2)-(0.00981*A20)+1.36","v":{"v":0.4636100000000001,"d":"0.464"}}]
[{"$f":"+A20+10","v":120},{"v":0.40024000000000004,"d":"0.400"}]
[130,{"v":0.33989000000000025,"d":"0.340"}]
[140,{"v":0.28256000000000014,"d":"0.283"}]
[150,{"v":0.22825000000000029,"d":"0.228"}]
[160,{"v":0.17696000000000023,"d":"0.177"}]
[170,{"v":0.1286900000000002,"d":"0.129"}]
[180,{"v":0.08344000000000018,"d":"0.083"}]
[190,{"v":0.04121000000000019,"d":"0.041"}]
[200,{"v":0.002000000000000446,"d":"0.002"}]
[]
[]
["nº de indicador:",9,"función de transformación:","CA= -2,5E-0,5*I^2 - 2,21E-03 * I + 1","0<I<104,5"]
["Indicador:","Ponderación del nivel diario de inmisión de NOx según la superficie de zonas homogéneas",null,"CA=1,51E-05*I^2-9,81E-03+1,36","104,5<I<200"]
["fórmula del indicador"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 200","valor del indicador",40]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D36<0,\"valor del indicador fuera de rango\",IF(D36<=104.5,-0.000025*(D36^2)-(0.00221*D36)+1,IF(D36<=200,(0.0000151*(D36^2))-(0.00981*D36)+1.36,\"valor del indicador fuera rango\")))","v":{"v":0.8715999999999999,"d":"0.872"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.000025*(A39^2)-(0.00221*A39)+1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"-0.000025*(A40^2)-(0.00221*A40)+1","v":{"v":0.9754,"d":"0.975"}}]
[20,{"v":0.9458,"d":"0.946"}]
[30,{"v":0.9112,"d":"0.911"}]
[40,{"v":0.8715999999999999,"d":"0.872"}]
[50,0.827]
[60,{"v":0.7774,"d":"0.777"}]
[70,{"v":0.7228,"d":"0.723"}]
[80,{"v":0.6632,"d":"0.663"}]
[90,{"v":0.5986,"d":"0.599"}]
[100,{"v":0.5289999999999999,"d":"0.529"}]
[105,{"$f":"0.0000151*(A50^2)-(0.00981*A50)+1.36","v":{"v":0.49642750000000024,"d":"0.496"}}]
[110,{"$f":"0.0000151*(A51^2)-(0.00981*A51)+1.36","v":{"v":0.4636100000000001,"d":"0.464"}}]
[115,{"v":0.4315475000000001,"d":"0.432"}]
[120,{"v":0.40024000000000004,"d":"0.400"}]
[125,{"v":0.3696875000000003,"d":"0.370"}]
[{"$f":"+A54+10","v":135},{"v":0.31084750000000017,"d":"0.311"}]
[145,{"v":0.25502749999999996,"d":"0.255"}]
[155,{"v":0.20222750000000023,"d":"0.202"}]
[165,{"v":0.1524475000000003,"d":"0.152"}]
[175,{"v":0.10568750000000038,"d":"0.106"}]
[185,{"v":0.061947500000000266,"d":"0.062"}]
[{"$f":"+A60+5","v":190},{"v":0.04121000000000019,"d":"0.041"}]
[{"$f":"+A61+5","v":195},{"v":0.021227500000000177,"d":"0.021"}]
[{"$f":"+A62+5","v":200},{"v":0.002000000000000446,"d":"0.002"}]
[]
[]
["nº de indicador:",10,"función de transformación:","CA= -2,5E-0,5*I^2 - 2,21E-03 * I + 1","0<I<104,5"]
["Indicador:","Ponderación del nivel diario de inmisión de NOx según la población afectada en cada zona",null,"CA=1,51E-05*I^2-9,81E-03+1,36","104,5<I<200"]
["fórmula del indicador"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 200","valor del indicador",110]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D70<0,\"valor del indicador fuera de rango\",IF(D70<=104.5,-0.000025*(D70^2)-(0.00221*D70)+1,IF(D70<=200,(0.0000151*(D70^2))-(0.00981*D70)+1.36,\"valor del indicador fuera rango\")))","v":{"v":0.4636100000000001,"d":"0.464"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.000025*(A73^2)-(0.00221*A73)+1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"-0.000025*(A74^2)-(0.00221*A74)+1","v":{"v":0.9754,"d":"0.975"}}]
[20,{"v":0.9458,"d":"0.946"}]
[30,{"v":0.9112,"d":"0.911"}]
[40,{"v":0.8715999999999999,"d":"0.872"}]
[50,0.827]
[60,{"v":0.7774,"d":"0.777"}]
[70,{"v":0.7228,"d":"0.723"}]
[80,{"v":0.6632,"d":"0.663"}]
[90,{"v":0.5986,"d":"0.599"}]
[100,{"v":0.5289999999999999,"d":"0.529"}]
[105,{"$f":"0.0000151*(A84^2)-(0.00981*A84)+1.36","v":{"v":0.49642750000000024,"d":"0.496"}}]
[110,{"$f":"0.0000151*(A85^2)-(0.00981*A85)+1.36","v":{"v":0.4636100000000001,"d":"0.464"}}]
[115,{"v":0.4315475000000001,"d":"0.432"}]
[120,{"v":0.40024000000000004,"d":"0.400"}]
[125,{"v":0.3696875000000003,"d":"0.370"}]
[{"$f":"+A88+10","v":135},{"v":0.31084750000000017,"d":"0.311"}]
[145,{"v":0.25502749999999996,"d":"0.255"}]
[155,{"v":0.20222750000000023,"d":"0.202"}]
[165,{"v":0.1524475000000003,"d":"0.152"}]
[175,{"v":0.10568750000000038,"d":"0.106"}]
[185,{"v":0.061947500000000266,"d":"0.062"}]
[{"$f":"+A94+5","v":190},{"v":0.04121000000000019,"d":"0.041"}]
[{"$f":"+A95+5","v":195},{"v":0.021227500000000177,"d":"0.021"}]
[{"$f":"+A96+5","v":200},{"v":0.002000000000000446,"d":"0.002"}]
[]
[]
["nº de indicador:",11,"función de transformación:","CA= -0.01* I + 1","0<I<100"]
["Indicador:","% porcentaje de personas aceptadas por niveles de NO2 perjudiciales."]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",10]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D104<0,\"valor del indicador fuera de rango\",IF(D104<=100,-0.01*(D104)+1,\"valor del indicador fuera rango\"))","v":{"v":0.9,"d":"0.900"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.01*A107+1","v":{"v":1,"d":"1.000"}}]
[2,{"v":0.98,"d":"0.980"}]
[4,{"v":0.96,"d":"0.960"}]
[6,{"v":0.94,"d":"0.940"}]
[8,{"v":0.92,"d":"0.920"}]
[10,{"v":0.9,"d":"0.900"}]
[15,{"v":0.85,"d":"0.850"}]
[20,{"v":0.8,"d":"0.800"}]
[25,{"v":0.75,"d":"0.750"}]
[30,{"v":0.7,"d":"0.700"}]
[40,{"v":0.6,"d":"0.600"}]
[50,{"v":0.5,"d":"0.500"}]
[60,{"v":0.4,"d":"0.400"}]
[70,{"v":0.29999999999999993,"d":"0.300"}]
[80,{"v":0.19999999999999996,"d":"0.200"}]
[90,{"v":0.09999999999999998,"d":"0.100"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"12-15","index":4,"n_rows":122,"n_cols":5,"rows_kept":122,"merged":[[6,2,6,4],[37,2,37,4],[71,2,71,4],[104,2,104,4]]}
["nº de indicador:",12,"función de transformación:","CA=(2,3E-06*I2)-(3,05E-03*I) +1","0<I<400"]
["Indicador:","Promedio diario del nivel de inmisión de SO2",null,"CA=(1,22E-06*I2) - (3,05E-03*I) + 0,702","400<I<600"]
["fórmula del indicador",null,null,"CA=0","600<I<800"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 800","valor del indicador",400]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=400,0.0000023*(D5^2)-(0.00305*D5)+1,IF(D5<=600,(0.00000122*(D5^2))-(0.00187*D5)+0.702, IF(D5<800, 0, \"valor del indicador fuera del rango\"))))","v":{"v":0.14800000000000002,"d":"0.148"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"((0.0000023*((A8)^2))-(0.00305*(A8))+1)","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A8+40","v":40},{"$f":"((0.0000023*((A9)^2))-(0.00305*(A9))+1)","v":{"v":0.88168,"d":"0.882"}}]
[{"$f":"+A9+40","v":80},{"v":0.77072,"d":"0.771"}]
[120,{"v":0.6671199999999999,"d":"0.667"}]
[160,{"v":0.5708799999999999,"d":"0.571"}]
[200,0.482]
[240,{"v":0.40047999999999995,"d":"0.400"}]
[280,{"v":0.32631999999999994,"d":"0.326"}]
[320,{"v":0.25952,"d":"0.260"}]
[360,{"v":0.20007999999999992,"d":"0.200"}]
[400,{"v":0.14800000000000002,"d":"0.148"}]
[440,{"$f":"(0.00000122*(A19^2))-(0.00187*A19)+0.702","v":{"v":0.11539199999999994,"d":"0.115"}}]
[480,{"$f":"(0.00000122*(A20^2))-(0.00187*A20)+0.702","v":{"v":0.08548800000000001,"d":"0.085"}}]
[520,{"$f":"(0.00000122*(A21^2))-(0.00187*A21)+0.702","v":{"v":0.059487999999999985,"d":"0.059"}}]
[560,{"$f":"(0.00000122*(A22^2))-(0.00187*A22)+0.702","v":{"v":0.03739200000000009,"d":"0.037"}}]
[600,{"$f":"(0.00000122*(A23^2))-(0.00187*A23)+0.702","v":{"v":0.019200000000000106,"d":"0.019"}}]
[640,{"v":0,"d":"0.000"}]
[{"$f":"+A24+40","v":680},{"v":0,"d":"0.000"}]
[{"$f":"+A25+40","v":720},{"v":0,"d":"0.000"}]
[{"$f":"+A26+40","v":760},{"v":0,"d":"0.000"}]
[780,{"v":0,"d":"0.000"}]
[800,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",13,"función de transformación:","CA=(2,3E-06*I2)-(3,05E-03*I) +1","0<I<400"]
["Indicador:","Ponderación del nivel diario de inmisión de SO2 según la superficie de zonas homogéneas",null,"CA=(1,22E-06*I2) - (3,05E-03*I) + 0,702","400<I<600"]
["fórmula del indicador",null,null,"CA=0","600<I<800"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 800","valor del indicador",600]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D36<0,\"valor del indicador fuera de rango\",IF(D36<=400,0.0000023*(D36^2)-(0.00305*D36)+1,IF(D36<=600,(0.00000122*(D36^2))-(0.00187*D36)+0.702, IF(D36<800, 0, \"valor del indicador fuera del rango\"))))","v":{"v":0.019200000000000106,"d":"0.019"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"((0.0000023*((A39)^2))-(0.00305*(A39))+1)","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A39+40","v":40},{"$f":"((0.0000023*((A40)^2))-(0.00305*(A40))+1)","v":{"v":0.88168,"d":"0.882"}}]
[{"$f":"+A40+40","v":80},{"v":0.77072,"d":"0.771"}]
[120,{"v":0.6671199999999999,"d":"0.667"}]
[160,{"v":0.5708799999999999,"d":"0.571"}]
[200,0.482]
[240,{"v":0.40047999999999995,"d":"0.400"}]
[280,{"v":0.32631999999999994,"d":"0.326"}]
[320,{"v":0.25952,"d":"0.260"}]
[360,{"v":0.20007999999999992,"d":"0.200"}]
[400,{"v":0.14800000000000002,"d":"0.148"}]
[440,{"$f":"(0.00000122*(A50^2))-(0.00187*A50)+0.702","v":{"v":0.11539199999999994,"d":"0.115"}}]
[480,{"$f":"(0.00000122*(A51^2))-(0.00187*A51)+0.702","v":{"v":0.08548800000000001,"d":"0.085"}}]
[520,{"$f":"(0.00000122*(A52^2))-(0.00187*A52)+0.702","v":{"v":0.059487999999999985,"d":"0.059"}}]
[560,{"$f":"(0.00000122*(A53^2))-(0.00187*A53)+0.702","v":{"v":0.03739200000000009,"d":"0.037"}}]
[600,{"$f":"(0.00000122*(A54^2))-(0.00187*A54)+0.702","v":{"v":0.019200000000000106,"d":"0.019"}}]
[640,{"v":0,"d":"0.000"}]
[{"$f":"+A55+20","v":660},{"v":0,"d":"0.000"}]
[{"$f":"+A56+20","v":680},{"v":0,"d":"0.000"}]
[700,{"v":0,"d":"0.000"}]
[720,{"v":0,"d":"0.000"}]
[740,{"v":0,"d":"0.000"}]
[760,{"v":0,"d":"0.000"}]
[780,{"v":0,"d":"0.000"}]
[800,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",14,"función de transformación:","CA=(-2,3E-06*I2)-(3,05E-03*I) +1","0<I<400"]
["Indicador:","Ponderación del nivel diario de inmisión de SO2 según la población afectada en cada zona",null,"CA=(1,22E-06*I2) - (1,87E-03*I) + 1,702","400<I<600"]
["fórmula del indicador",null,null,"CA=0","600<I<800"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 800","valor del indicador",500]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D70<0,\"valor del indicador fuera de rango\",IF(D70<=400,-0.0000023*(D70^2)-(0.00305*D70)+1,IF(D70<=600,(0.00000122*(D70^2))-(0.00187*D70)+1.702, IF(D70<800, 0, \"valor del indicador fuera del rango\"))))","v":1.072}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"((0.0000023*((A73)^2))-(0.00305*(A73))+1)","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A73+40","v":40},{"$f":"((0.0000023*((A74)^2))-(0.00305*(A74))+1)","v":{"v":0.88168,"d":"0.882"}}]
[{"$f":"+A74+40","v":80},{"v":0.77072,"d":"0.771"}]
[120,{"v":0.6671199999999999,"d":"0.667"}]
[160,{"v":0.5708799999999999,"d":"0.571"}]
[200,0.482]
[240,{"v":0.40047999999999995,"d":"0.400"}]
[280,{"v":0.32631999999999994,"d":"0.326"}]
[320,{"v":0.25952,"d":"0.260"}]
[360,{"v":0.20007999999999992,"d":"0.200"}]
[400,{"v":0.14800000000000002,"d":"0.148"}]
[440,{"$f":"(0.00000122*(A84^2))-(0.00187*A84)+0.702","v":{"v":0.11539199999999994,"d":"0.115"}}]
[480,{"$f":"(0.00000122*(A85^2))-(0.00187*A85)+0.702","v":{"v":0.08548800000000001,"d":"0.085"}}]
[520,{"$f":"(0.00000122*(A86^2))-(0.00187*A86)+0.702","v":{"v":0.059487999999999985,"d":"0.059"}}]
[560,{"$f":"(0.00000122*(A87^2))-(0.00187*A87)+0.702","v":{"v":0.03739200000000009,"d":"0.037"}}]
[600,{"$f":"(0.00000122*(A88^2))-(0.00187*A88)+0.702","v":{"v":0.019200000000000106,"d":"0.019"}}]
[640,{"v":0,"d":"0.000"}]
[{"$f":"+A89+20","v":660},{"v":0,"d":"0.000"}]
[{"$f":"+A90+20","v":680},{"v":0,"d":"0.000"}]
[{"$f":"+A91+20","v":700},{"v":0,"d":"0.000"}]
[{"$f":"+A92+20","v":720},{"v":0,"d":"0.000"}]
[740,{"v":0,"d":"0.000"}]
[{"$f":"+A94+20","v":760},{"v":0,"d":"0.000"}]
[800,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",15,"función de transformación:","CA=(-1E-02I) + 1","0<I<100"]
["Indicador:","% porcentaje de personas aceptadas por niveles de SO2 perjudiciales."]
["fórmula del indicador"]
["unidad del indicador:","%"]
["rango de valores del indicador:","0 - 100","valor del indicador",5]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D103<0,\"valor del indicador fuera de rango\",IF(D103<=100,-0.01*(D103)+1,\"valor del indicador fuera rango\"))","v":{"v":0.95,"d":"0.950"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.01*A106)+1","v":{"v":1,"d":"1.000"}}]
[5,{"$f":"(-0.01*A107)+1","v":{"v":0.95,"d":"0.950"}}]
[10,{"v":0.9,"d":"0.900"}]
[15,{"v":0.85,"d":"0.850"}]
[20,{"v":0.8,"d":"0.800"}]
[25,{"v":0.75,"d":"0.750"}]
[30,{"v":0.7,"d":"0.700"}]
[35,{"v":0.6499999999999999,"d":"0.650"}]
[40,{"v":0.6,"d":"0.600"}]
[45,{"v":0.55,"d":"0.550"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.44999999999999996,"d":"0.450"}]
[60,{"v":0.4,"d":"0.400"}]
[70,{"v":0.29999999999999993,"d":"0.300"}]
[80,{"v":0.19999999999999996,"d":"0.200"}]
[90,{"v":0.09999999999999998,"d":"0.100"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"16","index":5,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[6,2,6,4]]}
["nº de indicador:",16,"función de transformación:","CA=(-11*I^2) +(0,2*I) + 1","0<I<0,2"]
["Indicador:","Concentración de hidrocarburos promedio durante 3 horas",null,"CA=(27*I^2) -(18,11*I) + 3,15","0,2<I<0,34"]
["fórmula del indicador",null,null,"CA=0,1","0,34<I<0,4"]
["unidad del indicador:","ppm"]
["rango de valores del indicador:","0 - 0,4","valor del indicador",0.2]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=0.2,-11*(D5^2)+(0.2*D5)+1,IF(D5<=0.34,(27*(D5^2))-(18.1*D5)+3.15,IF(D5<0.4,0.1,\"valor del indicador fuera rango\"))))","v":{"v":0.6,"d":"0.600"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"(-11*A8^2)+(0.2*A8)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A8+0.05","v":0.05},{"$f":"(-11*A9^2)+(0.2*A9)+1","v":{"v":0.9825,"d":"0.983"}}]
[{"$f":"+A9+0.05","v":{"v":0.1,"d":"0.10"}},{"$f":"(-11*A10^2)+(0.2*A10)+1","v":{"v":0.91,"d":"0.910"}}]
[{"$f":"+A10+0.05","v":{"v":0.15000000000000002,"d":"0.15"}},{"$f":"(-11*A11^2)+(0.2*A11)+1","v":{"v":0.7825,"d":"0.783"}}]
[{"$f":"+A11+0.05","v":{"v":0.2,"d":"0.20"}},{"$f":"(-11*A12^2)+(0.2*A12)+1","v":{"v":0.6,"d":"0.600"}}]
[{"$f":"+A12+0.025","v":{"v":0.225,"d":"0.23"}},{"$f":"(27*A13^2)-(18.1*A13)+3.15","v":{"v":0.4443749999999995,"d":"0.444"}}]
[{"$f":"+A13+0.025","v":0.25},{"$f":"(27*A14^2)-(18.1*A14)+3.15","v":{"v":0.31249999999999956,"d":"0.313"}}]
[{"$f":"+A14+0.025","v":{"v":0.275,"d":"0.28"}},{"$f":"(27*A15^2)-(18.1*A15)+3.15","v":{"v":0.2143749999999991,"d":"0.214"}}]
[{"$f":"+A15+0.025","v":{"v":0.30000000000000004,"d":"0.30"}},{"$f":"(27*A16^2)-(18.1*A16)+3.15","v":{"v":0.14999999999999902,"d":"0.150"}}]
[0.33,{"$f":"(27*A17^2)-(18.1*A17)+3.15","v":{"v":0.1172999999999993,"d":"0.117"}}]
[0.34,{"v":0.1,"d":"0.100"}]
[0.35,{"v":0.1,"d":"0.100"}]
[0.36,{"v":0.1,"d":"0.100"}]
[0.37,{"v":0.1,"d":"0.100"}]
[0.38,{"v":0.1,"d":"0.100"}]
[0.39,{"v":0.1,"d":"0.100"}]
[{"v":0.4,"d":"0.40"},{"v":0.1,"d":"0.100"}]

{"sheet":"17-23","index":6,"n_rows":202,"n_cols":5,"rows_kept":202,"merged":[[6,2,6,4],[34,2,34,4],[63,2,63,4],[92,2,92,4],[121,2,121,4],[153,2,153,4],[182,2,182,4]]}
["nº de indicador:",17,"función de transformación:","CA=1","0<I<30"]
["Indicador:","Nivel sonoro equivalente diurno en una zona hospitalaria o escolar",null,"CA=-(2,22E-03*I^2) +(1,33E-01*I) - 1","30<I<45"]
["fórmula del indicador",null,null,"CA= (2,22E-03*I^2)-(2,67E-01*I)+8","45<I<56"]
["unidad del indicador:","dB"]
["rango de valores del indicador:","0 - 56","valor del indicador",52]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor fuera de rango\",IF(D5<=30,1,IF(D5<=45,-0.00222*(D5^2)+(0.133*D5)-1, IF(D5<=56, 0.00222*(D5^2)-(0.267*D5)+8,\"valor fuera de rango\"))))","v":{"v":0.11887999999999987,"d":"0.119"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[30,{"$f":"(-0.00222*A12^2)+(0.133*A12)-1","v":0.992}]
[31,{"v":0.9895800000000001,"d":"0.990"}]
[33,{"v":0.9714200000000002,"d":"0.971"}]
[35,{"v":0.9355000000000002,"d":"0.936"}]
[39,{"v":0.8103799999999999,"d":"0.810"}]
[41,{"v":0.7211799999999999,"d":"0.721"}]
[43,{"v":0.6142199999999995,"d":"0.614"}]
[44,{"v":0.5540799999999999,"d":"0.554"}]
[45,{"v":0.4894999999999996,"d":"0.490"}]
[46,{"$f":"(0.00222*A21^2)-(0.267*A21)+8","v":{"v":0.4155200000000008,"d":"0.416"}}]
[48,{"v":0.2988799999999996,"d":"0.299"}]
[50,{"v":0.1999999999999993,"d":"0.200"}]
[52,{"v":0.11887999999999987,"d":"0.119"}]
[53,{"v":0.08497999999999895,"d":"0.085"}]
[54,{"v":0.05551999999999957,"d":"0.056"}]
[56,{"v":0.009919999999999263,"d":"0.010"}]
[]
["nº de indicador:",18,"función de transformación:","CA=1","0<I<35"]
["Indicador:","Nivel sonoro equivalente diurno en una zona  residencial",null,"CA=-(1,63E-03*I^2) +(1,14E-01*I) - 1","35<I<52,5"]
["fórmula del indicador",null,null,"CA= (1,63E-03*I^2)-(2,29E-01*I)+8","52,5<I<65"]
["unidad del indicador:","dB"]
["rango de valores del indicador:","0 - 65","valor del indicador",65]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D33<0,\"valor del indicador fuera de rango\",IF(D33<=35,1,IF(D33<=52.5,-0.00163*(D33^2)+(0.114*D33)-1,IF(D33<=65,0.00163*(D33^2)-(0.229*D33)+8,\"valor del indicador fuera rango\"))))","v":{"v":1.7500000000003624E-3,"d":"0.002"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[35,{"v":1,"d":"1.000"}]
[35,{"$f":"(-0.00163*A41^2)+(0.114*A41)-1","v":{"v":0.9932500000000002,"d":"0.993"}}]
[37,{"v":0.9865300000000001,"d":"0.987"}]
[40,{"v":0.9520000000000004,"d":"0.952"}]
[43,{"v":0.8881300000000003,"d":"0.888"}]
[45,{"v":0.82925,"d":"0.829"}]
[48,{"v":0.7164800000000007,"d":"0.716"}]
[50,0.625]
[52,{"v":0.52048,"d":"0.520"}]
[53,{"$f":"(0.00163*A49^2)-(0.229*A49)+8","v":{"v":0.44166999999999934,"d":"0.442"}}]
[57,{"v":0.24286999999999903,"d":"0.243"}]
[59,{"v":0.16302999999999912,"d":"0.163"}]
[61,{"v":0.09622999999999848,"d":"0.096"}]
[63,{"v":0.04246999999999801,"d":"0.042"}]
[64,{"v":0.020479999999999166,"d":"0.020"}]
[65,{"v":1.7500000000003624E-3,"d":"0.002"}]
[]
[]
["nº de indicador:",19,"función de transformación:","CA=1","0<I<30"]
["Indicador:","Nivel sonoro equivalente diurno en una zona comercial",null,"CA=-(8E-04*I^2) +(4,8E-02*I) +2,8E-01","30<I<55"]
["fórmula del indicador",null,null,"CA= (8E-04*I^2)-(1,28E-01*I)+ 5,12","55<I<80"]
["unidad del indicador:","dB"]
["rango de valores del indicador:","0 - 80","valor del indicador",60]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D62<0,\"valor del indicador fuera de rango\",IF(D62<=30,1,IF(D62<=55,-0.0008*(D62^2)+(0.048*D62)+0.28,IF(D62<80, 0.0008*(D62^2)-(0.128*D62)+5.12,\"valor del indicador fuera rango\"))))","v":{"v":0.3200000000000012,"d":"0.320"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[30,{"$f":"(-0.0008*A69^2)+(0.048*A69)+0.28","v":{"v":0.9999999999999999,"d":"1.000"}}]
[32,{"v":0.9968,"d":"0.997"}]
[34,{"v":0.9872000000000001,"d":"0.987"}]
[36,{"v":0.9712000000000001,"d":"0.971"}]
[38,{"v":0.9488000000000001,"d":"0.949"}]
[40,{"v":0.9199999999999999,"d":"0.920"}]
[42,{"v":0.8848,"d":"0.885"}]
[44,{"v":0.8432,"d":"0.843"}]
[46,{"v":0.7952000000000001,"d":"0.795"}]
[48,{"v":0.7408000000000001,"d":"0.741"}]
[50,{"v":0.6799999999999999,"d":"0.680"}]
[55,{"$f":"(0.0008*A80^2)-(0.128*A80)+5.12","v":{"v":0.5,"d":"0.500"}}]
[60,{"$f":"(0.0008*A81^2)-(0.128*A81)+5.12","v":{"v":0.3200000000000012,"d":"0.320"}}]
[65,{"$f":"(0.0008*A82^2)-(0.128*A82)+5.12","v":{"v":0.1800000000000006,"d":"0.180"}}]
[70,{"$f":"(0.0008*A83^2)-(0.128*A83)+5.12","v":{"v":0.07999999999999918,"d":"0.080"}}]
[80,{"$f":"(0.0008*A84^2)-(0.128*A84)+5.12","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",20,"función de transformación:","CA=1","0<I<40"]
["Indicador:","Nivel sonoro equivalente diurno en una zona industrial",null,"CA=-(1,25E-03*I^2) +(1E-01*I) - 1","40<I<60"]
["fórmula del indicador",null,null,"CA= (1,25E-03*I^2)-(2E-01*I)+8","60<I<80"]
["unidad del indicador:","dB"]
["rango de valores del indicador:","0 - 80","valor del indicador",50]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D91<0,\"valor del indicador fuera de rango\",IF(D91<=40,1,IF(D91<=60,-0.00125*(D91^2)+(0.1*D91)-1,IF(D91<80,0.00125*(D91^2)-(0.2*D91)+8,\"valor del indicador fuera rango\"))))","v":0.875}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[40,{"v":1,"d":"1.000"}]
[42,{"$f":"(-0.00125*A99^2)+(0.1*A99)-1","v":{"v":0.9950000000000001,"d":"0.995"}}]
[45,{"v":0.96875,"d":"0.969"}]
[48,{"v":0.9200000000000008,"d":"0.920"}]
[50,0.875]
[52,{"v":0.8200000000000003,"d":"0.820"}]
[55,{"v":0.71875,"d":"0.719"}]
[57,{"v":0.6387499999999999,"d":"0.639"}]
[60,{"$f":"(0.00125*A106^2)-(0.2*A106)+8","v":{"v":0.5,"d":"0.500"}}]
[61,{"v":0.45124999999999904,"d":"0.451"}]
[65,{"v":0.28125,"d":"0.281"}]
[67,{"v":0.21124999999999972,"d":"0.211"}]
[70,0.125]
[72,{"v":0.08000000000000007,"d":"0.080"}]
[75,{"v":0.03125,"d":"0.031"}]
[80,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",21,"función de transformación:","CA= +1","0<I<30"]
["Indicador:","Media ponderada del nivel equivalente diurno, ponderado según la superficie de zonas homogéneas",null,"CA=(-5,56E-04*I^2)+(3,33E-02*I) +5E-01","30<I<60"]
["fórmula del indicador",null,null,"CA=(5,56E-04*I^2)-(1E-01*I) +4,5","60<I<90"]
["unidad del indicador:","Leq dB(A)"]
["rango de valores del indicador:","0 - 90","valor del indicador",72]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D120<0,\"valor del indicador fuera de rango\",IF(D120<=30,1,IF(D120<=60,-0.000556*(D120^2)+(0.0333*D120)+0.5,IF(D120<=90,(0.000556*(D120^2))-(0.1*D120)+4.5,\"valor del indicador fuera rango\"))))","v":{"v":0.18230400000000024,"d":"0.182"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[{"$f":"+A123+4","v":4},{"v":1,"d":"1.000"}]
[{"$f":"+A124+4","v":8},{"v":1,"d":"1.000"}]
[12,{"v":1,"d":"1.000"}]
[16,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[24,{"v":1,"d":"1.000"}]
[28,{"v":1,"d":"1.000"}]
[32,{"$f":"-0.000556*(A131^2)+(0.0333*A131)+0.5","v":{"v":0.9962560000000001,"d":"0.996"}}]
[36,{"$f":"-0.000556*(A132^2)+(0.0333*A132)+0.5","v":{"v":0.9782240000000001,"d":"0.978"}}]
[40,{"v":0.9424000000000001,"d":"0.942"}]
[44,{"v":0.8887840000000002,"d":"0.889"}]
[48,{"v":0.8173760000000003,"d":"0.817"}]
[52,{"v":0.7281760000000004,"d":"0.728"}]
[56,{"v":0.6211840000000004,"d":"0.621"}]
[60,{"v":0.4964000000000004,"d":"0.496"}]
[64,{"$f":"0.000556*(A139^2)-(0.1*A139)+4.5","v":{"v":0.37737599999999993,"d":"0.377"}}]
[68,{"v":0.2709439999999992,"d":"0.271"}]
[72,{"v":0.18230400000000024,"d":"0.182"}]
[76,{"v":0.11145599999999867,"d":"0.111"}]
[78,{"v":0.08270399999999967,"d":"0.083"}]
[{"$f":"+A142+4","v":80},{"v":0.058399999999999785,"d":"0.058"}]
[90,{"v":3.5999999999996035E-3,"d":"0.004"}]
[]
[]
["nº de indicador:",22,"función de transformación:","CA= +1","0<I<30"]
["Indicador:","Media ponderada del nivel equivalente diurno, ponderado por el nº de personas afectadas",null,"CA=(-5,56E-04*I^2)+(3,33E-02*I) + 5E-01","30<I<60"]
["fórmula del indicador",null,null,"CA=(5,56E-04*I^2)-(1E-01*I) +4,5","60<I<90"]
["unidad del indicador:","Leq dB(A)"]
["rango de valores del indicador:","0 - 90","valor del indicador",52]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D152<0,\"valor del indicador fuera de rango\",IF(D152<=30,1,IF(D152<=60,-0.000556*(D152^2)+(0.0333*D152)+0.5,IF(D152<=90,(0.000556*(D152^2))-(0.1*D152)+4.5,\"valor del indicador fuera rango\"))))","v":{"v":0.7281760000000004,"d":"0.728"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[{"$f":"+A155+4","v":4},{"v":1,"d":"1.000"}]
[{"$f":"+A156+4","v":8},{"v":1,"d":"1.000"}]
[12,{"v":1,"d":"1.000"}]
[16,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[24,{"v":1,"d":"1.000"}]
[28,{"v":1,"d":"1.000"}]
[32,{"$f":"-0.000556*(A163^2)+(0.0333*A163)+0.5","v":{"v":0.9962560000000001,"d":"0.996"}}]
[36,{"$f":"-0.000556*(A164^2)+(0.0333*A164)+0.5","v":{"v":0.9782240000000001,"d":"0.978"}}]
[40,{"v":0.9424000000000001,"d":"0.942"}]
[44,{"v":0.8887840000000002,"d":"0.889"}]
[48,{"v":0.8173760000000003,"d":"0.817"}]
[52,{"v":0.7281760000000004,"d":"0.728"}]
[60,{"v":0.4964000000000004,"d":"0.496"}]
[64,{"$f":"0.000556*(A170^2)-(0.1*A170)+4.5","v":{"v":0.37737599999999993,"d":"0.377"}}]
[68,{"$f":"0.000556*(A171^2)-(0.1*A171)+4.5","v":{"v":0.2709439999999992,"d":"0.271"}}]
[76,{"$f":"0.000556*(A172^2)-(0.1*A172)+4.5","v":{"v":0.11145599999999867,"d":"0.111"}}]
[80,{"$f":"0.000556*(A173^2)-(0.1*A173)+4.5","v":{"v":0.058399999999999785,"d":"0.058"}}]
[90,{"$f":"0.000556*(A174^2)-(0.1*A174)+4.5","v":{"v":3.5999999999996035E-3,"d":"0.004"}}]
[]
[]
["nº de indicador:",23,"función de transformación:","CA= (-1E-02*I)+1","0<I<100"]
["Indicador:","% de personas afectadas por niveles sonoros diurnos perjudiciales"]
["fórmula del indicador"]
["unidad del indicador:","%"]
["rango de valores del indicador:","0 - 100","valor del indicador",40]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D181<0,\"valor del indicador fuera de rango\",IF(D181<=100,-0.01*(D181)+1,\"valor del indicador fuera rango\"))","v":{"v":0.6,"d":"0.600"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.01*A184)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A184+5","v":5},{"$f":"(-0.01*A185)+1","v":{"v":0.95,"d":"0.950"}}]
[{"$f":"+A185+5","v":10},{"v":0.9,"d":"0.900"}]
[15,{"v":0.85,"d":"0.850"}]
[20,{"v":0.8,"d":"0.800"}]
[25,{"v":0.75,"d":"0.750"}]
[30,{"v":0.7,"d":"0.700"}]
[35,{"v":0.6499999999999999,"d":"0.650"}]
[40,{"v":0.6,"d":"0.600"}]
[45,{"v":0.55,"d":"0.550"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.44999999999999996,"d":"0.450"}]
[60,{"v":0.4,"d":"0.400"}]
[65,{"v":0.35,"d":"0.350"}]
[70,{"v":0.29999999999999993,"d":"0.300"}]
[75,{"v":0.25,"d":"0.250"}]
[80,{"v":0.19999999999999996,"d":"0.200"}]
[90,{"v":0.09999999999999998,"d":"0.100"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"24-30","index":7,"n_rows":204,"n_cols":5,"rows_kept":204,"merged":[[6,2,6,4],[35,2,35,4],[64,2,64,4],[93,2,93,4],[122,2,122,4],[154,2,154,4],[184,2,184,4]]}
["nº de indicador:",24,"función de transformación:","CA=+1","0<I<25"]
["Indicador:","Nivel sonoro equivalente nocturno en una zona hospitalaria o escolar",null,"CA=(-3,2E-03*I^2)+(1,6E-01*I) -1","25<I<37,5"]
["fórmula del indicador",null,null,"CA=(3,2E-0*I^2)-(3,2E-01*I) +8","37,5<I<50"]
["unidad del indicador:","Leq dB(A)"]
["rango de valores del indicador:","0 - 50","valor del indicador",40]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=25,1,IF(D5<=37.5,-0.0032*(D5^2)+(0.16*D5)-1,IF(D5<=50,(0.0032*(D5^2))-(0.32*D5)+8,\"valor del indicador fuera rango\"))))","v":{"v":0.3199999999999994,"d":"0.320"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"v":1,"d":"1.000"}]
[2.5,{"v":1,"d":"1.000"}]
[{"v":5,"d":"5.0"},{"v":1,"d":"1.000"}]
[7.5,{"v":1,"d":"1.000"}]
[{"v":10,"d":"10.0"},{"v":1,"d":"1.000"}]
[12.5,{"v":1,"d":"1.000"}]
[{"v":15,"d":"15.0"},{"v":1,"d":"1.000"}]
[{"v":20,"d":"20.0"},{"v":1,"d":"1.000"}]
[22.5,{"v":1,"d":"1.000"}]
[{"v":25,"d":"25.0"},{"v":1,"d":"1.000"}]
[27.5,{"$f":"-0.0032*(A18^2)+(0.16*A18)-1","v":{"v":0.9800000000000004,"d":"0.980"}}]
[{"v":30,"d":"30.0"},{"$f":"-0.0032*(A19^2)+(0.16*A19)-1","v":{"v":0.9199999999999995,"d":"0.920"}}]
[32.5,{"$f":"-0.0032*(A20^2)+(0.16*A20)-1","v":{"v":0.8199999999999998,"d":"0.820"}}]
[{"v":35,"d":"35.0"},{"$f":"-0.0032*(A21^2)+(0.16*A21)-1","v":{"v":0.6800000000000002,"d":"0.680"}}]
[37.5,{"$f":"-0.0032*(A22^2)+(0.16*A22)-1","v":{"v":0.5,"d":"0.500"}}]
[{"v":40,"d":"40.0"},{"$f":"0.0032*(A23^2)-(0.32*A23)+8","v":{"v":0.3199999999999994,"d":"0.320"}}]
[42.5,{"$f":"0.0032*(A24^2)-(0.32*A24)+8","v":{"v":0.1800000000000006,"d":"0.180"}}]
[{"v":45,"d":"45.0"},{"$f":"0.0032*(A25^2)-(0.32*A25)+8","v":{"v":0.08000000000000007,"d":"0.080"}}]
[47.5,{"$f":"0.0032*(A26^2)-(0.32*A26)+8","v":{"v":0.019999999999999574,"d":"0.020"}}]
[{"v":50,"d":"50.0"},{"$f":"0.0032*(A27^2)-(0.32*A27)+8","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",25,"función de transformación:","CA=+1","0<I<30"]
["Indicador:","Nivel sonoro equivalente nocturno en una zona residencial",null,"CA=(-2,22E-0,3*I^2) +(1,33E-01*I) -1","30<I<45"]
["fórmula del indicador",null,null,"CA=(2,22E-0,3*I^2) -(2,67E-01*I) +8","45<I<56"]
["unidad del indicador:","Leq dB(A)"]
["rango de valores del indicador:","0 - 56","valor del indicador",50]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D34<0,\"valor del indicador fuera de rango\",IF(D34<=30,1,IF(D34<=45,-0.00222*(D34^2)+(0.133*D34)-1,IF(D34<=56,0.00222*(D34^2)-(0.267*D34)+8,\"valor del indicador fuera rango\"))))","v":{"v":0.1999999999999993,"d":"0.200"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[5,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[15,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[25,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[32,{"$f":"-0.00222*(A44^2)+(0.133*A44)-1","v":{"v":0.98272,"d":"0.983"}}]
[34,{"$f":"-0.00222*(A45^2)+(0.133*A45)-1","v":{"v":0.9556800000000001,"d":"0.956"}}]
[36,{"v":0.9108800000000001,"d":"0.911"}]
[38,{"v":0.8483200000000002,"d":"0.848"}]
[40,{"v":0.7679999999999998,"d":"0.768"}]
[42,{"v":0.6699199999999998,"d":"0.670"}]
[44,{"v":0.5540799999999999,"d":"0.554"}]
[46,{"$f":"0.00222*(A51^2)-(0.267*A51)+8","v":{"v":0.4155200000000008,"d":"0.416"}}]
[48,{"v":0.2988799999999996,"d":"0.299"}]
[50,{"v":0.1999999999999993,"d":"0.200"}]
[52,{"v":0.11887999999999987,"d":"0.119"}]
[54,{"v":0.05551999999999957,"d":"0.056"}]
[56,{"v":0.009919999999999263,"d":"0.010"}]
[]
[]
["nº de indicador:",26,"función de transformación:","CA=+1","0<I<35"]
["Indicador:","Nivel sonoro equivalente nocturno en una zona comercial",null,"CA=(-2,22E-0,3*I^2) +(1,56E-01*I) -1,72","35<I<50"]
["fórmula del indicador",null,null,"CA=(2,22E-0,3*I^2) -(2,89E-01*I) +3,39","50<I<62"]
["unidad del indicador:","Leq dB(A)"]
["rango de valores del indicador:","0 - 62","valor del indicador",60]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D63<0,\"valor del indicador fuera de rango\",IF(D63<=35,1,IF(D63<=50,-0.00222*(D63^2)+(0.156*D63)-1.72,IF(D63<=62,0.00222*(D63^2)-(0.289*D63)+9.39,\"valor del indicador fuera rango\"))))","v":{"v":0.04200000000000159,"d":"0.042"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[5,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[15,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[25,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[36,{"$f":"-0.00222*(A73^2)+(0.156*A73)-1.72","v":{"v":1.0188799999999996,"d":"1.019"}}]
[38,{"v":1.0023199999999999,"d":"1.002"}]
[40,{"v":0.9679999999999997,"d":"0.968"}]
[42,{"v":0.9159199999999992,"d":"0.916"}]
[44,{"v":0.8460799999999995,"d":"0.846"}]
[46,{"v":0.7584799999999994,"d":"0.758"}]
[48,{"v":0.6531199999999993,"d":"0.653"}]
[50,{"$f":"-0.00222*(A80^2)+(0.156*A80)-1.72","v":{"v":0.5299999999999991,"d":"0.530"}}]
[52,{"$f":"0.00222*(A81^2)-(0.289*A81)+9.39","v":{"v":0.364880000000003,"d":"0.365"}}]
[56,{"$f":"0.00222*(A82^2)-(0.289*A82)+9.39","v":{"v":0.16792000000000407,"d":"0.168"}}]
[{"$f":"+A82+2","v":58},{"$f":"0.00222*(A83^2)-(0.289*A83)+9.39","v":{"v":0.09608000000000061,"d":"0.096"}}]
[{"$f":"+A83+2","v":60},{"$f":"0.00222*(A84^2)-(0.289*A84)+9.39","v":{"v":0.04200000000000159,"d":"0.042"}}]
[{"$f":"+A84+2","v":62},{"$f":"0.00222*(A85^2)-(0.289*A85)+9.39","v":{"v":0.005680000000001684,"d":"0.006"}}]
[]
[]
["nº de indicador:",27,"función de transformación:","CA=+1","0<I<35"]
["Indicador:","Nivel sonoro equivalente nocturno en una zona industrial",null,"CA=(-1,63E-0,3*I^2) +(1,14E-01*I) -1","35<I<52,5"]
["fórmula del indicador",null,null,"CA=(1,63E-0,3*I^2) -(2,29E-01*I) +8","52,5<I<65"]
["unidad del indicador:","Leq dB(A)"]
["rango de valores del indicador:","0 - 65","valor del indicador",58]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D92<0,\"valor del indicador fuera de rango\",IF(D92<=35,1,IF(D92<=52.5,-0.00163*(D92^2)+(0.114*D92)-1,IF(D92<=65,0.00163*(D92^2)-(0.229*D92)+8,\"valor del indicador fuera rango\"))))","v":{"v":0.20131999999999994,"d":"0.201"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[5,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[15,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[25,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[36,{"$f":"-0.00163*(A102^2)+(0.114*A102)-1","v":{"v":0.99152,"d":"0.992"}}]
[38,{"$f":"-0.00163*(A103^2)+(0.114*A103)-1","v":{"v":0.9782799999999998,"d":"0.978"}}]
[40,{"v":0.9520000000000004,"d":"0.952"}]
[42,{"v":0.9126800000000004,"d":"0.913"}]
[44,{"v":0.8603200000000002,"d":"0.860"}]
[46,{"v":0.7949199999999998,"d":"0.795"}]
[48,{"v":0.7164800000000007,"d":"0.716"}]
[50,0.625]
[52,{"$f":"0.00163*(A110^2)-(0.229*A110)+8","v":{"v":0.49951999999999863,"d":"0.500"}}]
[56,{"$f":"0.00163*(A111^2)-(0.229*A111)+8","v":{"v":0.28767999999999994,"d":"0.288"}}]
[{"$f":"+A111+2","v":58},{"$f":"0.00163*(A112^2)-(0.229*A112)+8","v":{"v":0.20131999999999994,"d":"0.201"}}]
[{"$f":"+A112+2","v":60},{"$f":"0.00163*(A113^2)-(0.229*A113)+8","v":{"v":0.12799999999999923,"d":"0.128"}}]
[65,{"$f":"0.00163*(A114^2)-(0.229*A114)+8","v":{"v":1.7500000000003624E-3,"d":"0.002"}}]
[]
[]
["nº de indicador:",28,"función de transformación:","CA=+1","0<I<30"]
["Indicador:","Media ponderada del nivel equivalente nocturno, ponderado por la superficie de zonas homogéneas",null,"CA=(-1,63E-0,3*I^2) +(1,14E-01*I) -1","30<I<57,5"]
["fórmula del indicador",null,null,"CA=(1,63E-0,3*I^2) -(2,29E-01*I) +8","57,5<I<85"]
["unidad del indicador:","Leq dB(A)"]
["rango de valores del indicador:","0 - 85","valor del indicador",58]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D121<0,\"valor del indicador fuera de rango\",IF(D121<=30,1,IF(D121<=57.5,-0.000661*(D121^2)+(0.0397*D121)+0.405,IF(D121<=85,0.000661*(D121^2)-(0.112*D121)+4.78,\"valor del indicador fuera rango\"))))","v":{"v":0.5076039999999997,"d":"0.508"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[35,{"$f":"-0.000661*(A128^2)+(0.0397*A128)+0.405","v":{"v":0.984775,"d":"0.985"}}]
[37,{"$f":"-0.000661*(A129^2)+(0.0397*A129)+0.405","v":{"v":0.9689909999999998,"d":"0.969"}}]
[40,{"v":0.9354,"d":"0.935"}]
[42,{"v":0.906396,"d":"0.906"}]
[45,{"v":0.852975,"d":"0.853"}]
[47,{"v":0.8107509999999998,"d":"0.811"}]
[50,{"v":0.7374999999999998,"d":"0.738"}]
[52,{"v":0.682056,"d":"0.682"}]
[55,{"v":0.588975,"d":"0.589"}]
[57,{"v":0.5203110000000002,"d":"0.520"}]
[60,{"$f":"0.000661*(A138^2)-(0.112*A138)+4.78","v":{"v":0.43960000000000043,"d":"0.440"}}]
[62,{"v":0.37688400000000044,"d":"0.377"}]
[65,{"v":0.2927249999999999,"d":"0.293"}]
[67,{"v":0.24322900000000036,"d":"0.243"}]
[70,{"v":0.1789000000000005,"d":"0.179"}]
[72,{"v":0.14262400000000053,"d":"0.143"}]
[75,{"v":0.09812500000000046,"d":"0.098"}]
[80,{"v":0.05039999999999978,"d":"0.050"}]
[85,{"v":0.03572500000000112,"d":"0.036"}]
[]
[]
["nº de indicador:",29,"función de transformación:","CA=+1","0<I<30"]
["Indicador:","Media ponderada del nivel equivalente nocturno, ponderado según el nº de personas afectadas",null,"CA=(-6,61E-04*I^2) +(3,97E-02*I) +4,05E-01","30<I<57,5"]
["fórmula del indicador",null,null,"CA=(6,61E-04*I^2) -(1,12E-01*I) +4,78","57,5<I<85"]
["unidad del indicador:","Leq dB(A)"]
["rango de valores del indicador:","0 - 85","valor del indicador",35]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D153<0,\"valor del indicador fuera de rango\",IF(D153<=30,1,IF(D153<=57.5,-0.000661*(D153^2)+(0.0397*D153)+0.405,IF(D153<=85,0.000661*(D153^2)-(0.112*D153)+4.78,\"valor del indicador fuera rango\"))))","v":{"v":0.984775,"d":"0.985"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.000"}]
[10,{"v":1,"d":"1.000"}]
[20,{"v":1,"d":"1.000"}]
[30,{"v":1,"d":"1.000"}]
[35,{"$f":"-0.000661*(A160^2)+(0.0397*A160)+0.405","v":{"v":0.984775,"d":"0.985"}}]
[37,{"$f":"-0.000661*(A161^2)+(0.0397*A161)+0.405","v":{"v":0.9689909999999998,"d":"0.969"}}]
[40,{"v":0.9354,"d":"0.935"}]
[42,{"v":0.906396,"d":"0.906"}]
[45,{"v":0.852975,"d":"0.853"}]
[47,{"v":0.8107509999999998,"d":"0.811"}]
[50,{"v":0.7374999999999998,"d":"0.738"}]
[52,{"v":0.682056,"d":"0.682"}]
[55,{"v":0.588975,"d":"0.589"}]
[60,{"$f":"0.000661*(A169^2)-(0.112*A169)+4.78","v":{"v":0.43960000000000043,"d":"0.440"}}]
[65,{"v":0.2927249999999999,"d":"0.293"}]
[67,{"v":0.24322900000000036,"d":"0.243"}]
[70,{"v":0.1789000000000005,"d":"0.179"}]
[72,{"v":0.14262400000000053,"d":"0.143"}]
[75,{"v":0.09812500000000046,"d":"0.098"}]
[80,{"v":0.05039999999999978,"d":"0.050"}]
[85,{"v":0.03572500000000112,"d":"0.036"}]
[]
[]
["nº de indicador:",30,"función de transformación:","CA= (-1E-02*i)+1","0<I<100"]
["Indicador:","% de personas afectadas por niveles sonoros nocturno perjudiciales."]
["fórmula del indicador"]
["unidad del indicador:","%"]
["rango de valores del indicador:","0 - 100","valor del indicador",40]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D183<0,\"valor del indicador fuera de rango\",IF(D183<=100,(-0.01*D183)+1,\"valor del indicador fuera rango\"))","v":{"v":0.6,"d":"0.600"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.01*A186)+1","v":{"v":1,"d":"1.000"}}]
[5,{"$f":"(-0.01*A187)+1","v":{"v":0.95,"d":"0.950"}}]
[10,{"v":0.9,"d":"0.900"}]
[15,{"v":0.85,"d":"0.850"}]
[20,{"v":0.8,"d":"0.800"}]
[25,{"v":0.75,"d":"0.750"}]
[30,{"v":0.7,"d":"0.700"}]
[35,{"v":0.6499999999999999,"d":"0.650"}]
[40,{"v":0.6,"d":"0.600"}]
[45,{"v":0.55,"d":"0.550"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.44999999999999996,"d":"0.450"}]
[60,{"v":0.4,"d":"0.400"}]
[65,{"v":0.35,"d":"0.350"}]
[70,{"v":0.29999999999999993,"d":"0.300"}]
[75,{"v":0.25,"d":"0.250"}]
[80,{"v":0.19999999999999996,"d":"0.200"}]
[90,{"v":0.09999999999999998,"d":"0.100"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"31","index":8,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[6,2,6,4]]}
["nº de indicador:",31,"función de transformación:","CA= 1,8E-02*I+1,8","− 100  < I <  −50"]
["Indicador:","% de vegetación afectada negativamente por lavariación del spray marino",null,"CA= 2E-0,3*I+1","− 50 < I <  0"]
["fórmula del indicador",null,null,"CA= -1E-02*I+1","0<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:"," -100  -  100","valor del indicador",60]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-100,\"valor del indicador fuera de rango\",IF(D5<=-50,0.018*(D5)+(1.8),IF(D5<=0,(0.002*(D5))+1,IF(D5<=100,(-0.01*(D5))+1,\"valor del indicador fuera rango\"))))","v":{"v":0.4,"d":"0.400"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-100,{"$f":"0.018*A8+1.8","v":{"v":0,"d":"0.000"}}]
[-90,{"v":0.18000000000000016,"d":"0.180"}]
[-80,{"v":0.3600000000000001,"d":"0.360"}]
[-70,{"v":0.54,"d":"0.540"}]
[-60,{"v":0.7200000000000002,"d":"0.720"}]
[-50,{"v":0.9000000000000001,"d":"0.900"}]
[-40,{"$f":"0.002*A14+1","v":{"v":0.92,"d":"0.920"}}]
[-30,{"$f":"0.002*A15+1","v":{"v":0.94,"d":"0.940"}}]
[-20,{"$f":"0.002*A16+1","v":{"v":0.96,"d":"0.960"}}]
[-10,{"$f":"0.002*A17+1","v":{"v":0.98,"d":"0.980"}}]
[0,{"$f":"0.002*A18+1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"-0.01*A19+1","v":{"v":0.9,"d":"0.900"}}]
[20,{"$f":"-0.01*A20+1","v":{"v":0.8,"d":"0.800"}}]
[30,{"v":0.7,"d":"0.700"}]
[40,{"v":0.6,"d":"0.600"}]
[50,{"v":0.5,"d":"0.500"}]
[60,{"v":0.4,"d":"0.400"}]
[80,{"v":0.19999999999999996,"d":"0.200"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"32-34","index":9,"n_rows":79,"n_cols":5,"rows_kept":79,"merged":[[6,2,6,4],[33,2,33,4],[60,2,60,4]]}
["nº de indicador:",32,"función de transformación:","CA=-4E-01*(I^2)+1,4*I","0<I<1"]
["Indicador:","Calidad perceptible del aire según su olor y visibilidad (olor agradable)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:"," 0 - 1","valor del indicador",0.5]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=1,((-0.4*D5^2)+(1.4*D5)),\"valor del indicador fuera rango\"))","v":{"v":0.6,"d":"0.600"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.4*A8^2+1.4*A8","v":{"v":0,"d":"0.000"}}]
[{"$f":"A8+0.05","v":0.05},{"$f":"-0.4*A9^2+1.4*A9","v":{"v":0.06899999999999999,"d":"0.069"}}]
[{"$f":"A9+0.05","v":{"v":0.1,"d":"0.10"}},{"v":0.13599999999999998,"d":"0.136"}]
[{"v":0.15000000000000002,"d":"0.15"},0.201]
[{"v":0.2,"d":"0.20"},{"v":0.26399999999999996,"d":"0.264"}]
[0.25,{"v":0.32499999999999996,"d":"0.325"}]
[{"v":0.3,"d":"0.30"},0.384]
[0.35,{"v":0.44099999999999995,"d":"0.441"}]
[{"v":0.39999999999999997,"d":"0.40"},{"v":0.49599999999999994,"d":"0.496"}]
[{"v":0.44999999999999996,"d":"0.45"},{"v":0.5489999999999999,"d":"0.549"}]
[{"v":0.49999999999999994,"d":"0.50"},{"v":0.5999999999999999,"d":"0.600"}]
[{"v":0.5499999999999999,"d":"0.55"},{"v":0.6489999999999999,"d":"0.649"}]
[{"v":0.6,"d":"0.60"},0.696]
[{"v":0.7,"d":"0.70"},{"v":0.7839999999999999,"d":"0.784"}]
[{"v":0.8,"d":"0.80"},{"v":0.8639999999999999,"d":"0.864"}]
[0.85,0.901]
[{"v":0.9,"d":"0.90"},{"v":0.9359999999999999,"d":"0.936"}]
[{"v":1,"d":"1.00"},{"v":0.9999999999999999,"d":"1.000"}]
[]
[]
["nº de indicador:",33,"función de transformación:","CA=-2,89E-01*(I^2)+1,19*I","0<I<1"]
["Indicador:","Calidad perceptible del aire según su olor y visibilidad (sin olor)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:"," 0 - 1","valor del indicador",0.5]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D32<0,\"valor del indicador fuera de rango\",IF(D32<=1,((-0.289*D32^2)+(1.19*D32)),\"valor del indicador fuera rango\"))","v":{"v":0.5227499999999999,"d":"0.523"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.289*A35^2+1.19*A35","v":{"v":0,"d":"0.000"}}]
[{"$f":"A35+0.05","v":0.05},{"$f":"-0.289*A36^2+1.19*A36","v":{"v":0.058777499999999996,"d":"0.059"}}]
[{"$f":"A36+0.05","v":{"v":0.1,"d":"0.10"}},{"v":0.11610999999999999,"d":"0.116"}]
[{"v":0.15000000000000002,"d":"0.15"},{"v":0.17199750000000003,"d":"0.172"}]
[{"v":0.2,"d":"0.20"},{"v":0.22643999999999997,"d":"0.226"}]
[0.25,{"v":0.2794375,"d":"0.279"}]
[{"v":0.3,"d":"0.30"},{"v":0.33099,"d":"0.331"}]
[0.35,{"v":0.3810975,"d":"0.381"}]
[{"v":0.39999999999999997,"d":"0.40"},{"v":0.4297599999999999,"d":"0.430"}]
[{"v":0.44999999999999996,"d":"0.45"},{"v":0.4769775,"d":"0.477"}]
[{"v":0.49999999999999994,"d":"0.50"},{"v":0.5227499999999998,"d":"0.523"}]
[{"v":0.5499999999999999,"d":"0.55"},{"v":0.5670774999999999,"d":"0.567"}]
[{"v":0.6,"d":"0.60"},{"v":0.60996,"d":"0.610"}]
[{"v":0.7,"d":"0.70"},{"v":0.69139,"d":"0.691"}]
[{"v":0.8,"d":"0.80"},{"v":0.7670399999999999,"d":"0.767"}]
[0.85,{"v":0.8026974999999998,"d":"0.803"}]
[{"v":0.9,"d":"0.90"},{"v":0.8369099999999999,"d":"0.837"}]
[{"v":1,"d":"1.00"},0.901]
[]
[]
["nº de indicador:",34,"función de transformación:","CA=-2E-01*(I^2)+4E-01*I","0<I<1"]
["Indicador:","Calidad perceptible del aire según su olor y visibilidad (olor desagradable)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:"," 0 - 1","valor del indicador",0.5]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D59<0,\"valor del indicador fuera de rango\",IF(D59<=1,((-0.2*D59^2)+(0.4*D59)),\"valor del indicador fuera rango\"))","v":{"v":0.15000000000000002,"d":"0.150"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.2*A62^2+0.4*A62","v":{"v":0,"d":"0.000"}}]
[{"$f":"A62+0.05","v":0.05},{"$f":"-0.2*A63^2+0.4*A63","v":{"v":0.019500000000000003,"d":"0.020"}}]
[{"$f":"A63+0.05","v":{"v":0.1,"d":"0.10"}},{"$f":"-0.2*A64^2+0.4*A64","v":{"v":0.038000000000000006,"d":"0.038"}}]
[{"v":0.15000000000000002,"d":"0.15"},{"v":0.05550000000000001,"d":"0.056"}]
[{"v":0.2,"d":"0.20"},{"v":0.07200000000000001,"d":"0.072"}]
[0.25,{"v":0.08750000000000001,"d":"0.088"}]
[{"v":0.3,"d":"0.30"},0.102]
[0.35,{"v":0.11549999999999999,"d":"0.116"}]
[{"v":0.39999999999999997,"d":"0.40"},0.128]
[{"v":0.44999999999999996,"d":"0.45"},{"v":0.1395,"d":"0.140"}]
[{"v":0.49999999999999994,"d":"0.50"},{"v":0.15,"d":"0.150"}]
[{"v":0.5499999999999999,"d":"0.55"},{"v":0.15949999999999998,"d":"0.160"}]
[{"v":0.6,"d":"0.60"},{"v":0.16799999999999998,"d":"0.168"}]
[0.65,{"v":0.1755,"d":"0.176"}]
[{"v":0.7,"d":"0.70"},0.182]
[{"v":0.8,"d":"0.80"},{"v":0.19200000000000003,"d":"0.192"}]
[{"v":0.9,"d":"0.90"},0.198]
[{"v":1,"d":"1.00"},{"v":0.2,"d":"0.200"}]

{"sheet":"35-39","index":10,"n_rows":153,"n_cols":5,"rows_kept":153,"merged":[[6,2,6,4],[38,2,38,4],[72,2,72,4],[106,2,106,4],[132,2,132,4]]}
["nº de indicador:",35,"función de transformación:","CA= 6,94E-5*(I^2)-1,25E-02*I+1","0  < I <  60"]
["Indicador:","Promedio diario de la concentración de polvo y partículas en suspensión",null,"CA= 1,54E-06*(I^2)-1,94E-03*I+6,1E-01","60 < I <  600"]
["fórmula del indicador"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 600","valor del indicador",120]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=60,(0.0000694*(D5^2)-(0.0125*D5)+1),IF(D5<=600,((0.00000154*D5^2)-(0.00194*D5)+0.61),\"valor del indicador fuera rango\")))","v":{"v":0.39937599999999995,"d":"0.399"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0000694*A8^2-0.0125*A8+1","v":{"v":1,"d":"1.000"}}]
[10,{"v":0.88194,"d":"0.882"}]
[20,{"v":0.77776,"d":"0.778"}]
[30,{"v":0.68746,"d":"0.687"}]
[40,{"v":0.61104,"d":"0.611"}]
[50,{"v":0.5485,"d":"0.549"}]
[60,{"v":0.49984000000000006,"d":"0.500"}]
[90,{"$f":"0.00000154*A15^2-0.00194*A15+0.61","v":{"v":0.447874,"d":"0.448"}}]
[120,{"$f":"0.00000154*A16^2-0.00194*A16+0.61","v":{"v":0.39937599999999995,"d":"0.399"}}]
[150,{"v":0.35364999999999996,"d":"0.354"}]
[180,{"v":0.31069599999999997,"d":"0.311"}]
[210,{"v":0.2705139999999999,"d":"0.271"}]
[240,{"v":0.23310399999999998,"d":"0.233"}]
[270,{"v":0.19846599999999992,"d":"0.198"}]
[300,{"v":0.16659999999999991,"d":"0.167"}]
[330,{"v":0.13750600000000002,"d":"0.138"}]
[360,{"v":0.11118399999999995,"d":"0.111"}]
[450,{"v":0.04884999999999995,"d":"0.049"}]
[480,{"v":0.03361599999999998,"d":"0.034"}]
[510,{"v":0.021154000000000006,"d":"0.021"}]
[540,{"v":0.011463999999999919,"d":"0.011"}]
[570,{"v":4.545999999999939E-3,"d":"0.005"}]
[600,{"v":3.9999999999984492E-4,"d":"0.000"}]
[]
[]
["nº de indicador:",36,"función de transformación:","CA= 6,94E-5*(I^2)-1,25E-02*I+1","0  < I <  60"]
["Indicador:","Ponderación del nivel  diario de la concentración de polvo y partículas en suspensión según superficie de zonas homogeneas ",null,"CA= 1,54E-06*(I^2)-1,94E-03*I+6,1E-01","60 < I <  600"]
["fórmula del indicador"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 600","valor del indicador",120]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D37<0,\"valor del indicador fuera de rango\",IF(D37<=60,(0.0000694*(D37^2)-(0.0125*D37)+1),IF(D37<=600,((0.00000154*D37^2)-(0.00194*D37)+0.61),\"valor del indicador fuera rango\")))","v":{"v":0.39937599999999995,"d":"0.399"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0000694*A40^2-0.0125*A40+1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"0.0000694*A41^2-0.0125*A41+1","v":{"v":0.88194,"d":"0.882"}}]
[20,{"$f":"0.0000694*A42^2-0.0125*A42+1","v":{"v":0.77776,"d":"0.778"}}]
[30,{"$f":"0.0000694*A43^2-0.0125*A43+1","v":{"v":0.68746,"d":"0.687"}}]
[40,{"v":0.61104,"d":"0.611"}]
[45,{"v":0.5780350000000001,"d":"0.578"}]
[50,{"v":0.5485,"d":"0.549"}]
[55,{"v":0.522435,"d":"0.522"}]
[60,{"v":0.49984000000000006,"d":"0.500"}]
[90,{"$f":"0.00000154*A49^2-0.00194*A49+0.61","v":{"v":0.447874,"d":"0.448"}}]
[120,{"$f":"0.00000154*A50^2-0.00194*A50+0.61","v":{"v":0.39937599999999995,"d":"0.399"}}]
[150,{"v":0.35364999999999996,"d":"0.354"}]
[180,{"v":0.31069599999999997,"d":"0.311"}]
[210,{"v":0.2705139999999999,"d":"0.271"}]
[240,{"v":0.23310399999999998,"d":"0.233"}]
[270,{"v":0.19846599999999992,"d":"0.198"}]
[300,{"v":0.16659999999999991,"d":"0.167"}]
[330,{"v":0.13750600000000002,"d":"0.138"}]
[360,{"v":0.11118399999999995,"d":"0.111"}]
[450,{"v":0.04884999999999995,"d":"0.049"}]
[480,{"v":0.03361599999999998,"d":"0.034"}]
[510,{"v":0.021154000000000006,"d":"0.021"}]
[540,{"v":0.011463999999999919,"d":"0.011"}]
[570,{"v":4.545999999999939E-3,"d":"0.005"}]
[600,{"v":3.9999999999984492E-4,"d":"0.000"}]
[]
[]
["nº de indicador:",37,"función de transformación:","CA= 6,94E-5*(I^2)-1,25E-02*I+1","0  < I <  60"]
["Indicador:","Ponderación del nivel  diario de la concentración de polvo y partículas en suspensión según población afectada de la zona ",null,"CA= 1,54E-06*(I^2)-1,94E-03*I+6,1E-01","60 < I <  600"]
["fórmula del indicador"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 600","valor del indicador",210]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D71<0,\"valor del indicador fuera de rango\",IF(D71<=60,(0.0000694*(D71^2)-(0.0125*D71)+1),IF(D71<=600,((0.00000154*D71^2)-(0.00194*D71)+0.61),\"valor del indicador fuera rango\")))","v":{"v":0.2705139999999999,"d":"0.271"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0000694*A74^2-0.0125*A74+1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"0.0000694*A75^2-0.0125*A75+1","v":{"v":0.88194,"d":"0.882"}}]
[20,{"$f":"0.0000694*A76^2-0.0125*A76+1","v":{"v":0.77776,"d":"0.778"}}]
[30,{"$f":"0.0000694*A77^2-0.0125*A77+1","v":{"v":0.68746,"d":"0.687"}}]
[40,{"v":0.61104,"d":"0.611"}]
[45,{"v":0.5780350000000001,"d":"0.578"}]
[50,{"v":0.5485,"d":"0.549"}]
[55,{"v":0.522435,"d":"0.522"}]
[60,{"v":0.49984000000000006,"d":"0.500"}]
[90,{"$f":"0.00000154*A83^2-0.00194*A83+0.61","v":{"v":0.447874,"d":"0.448"}}]
[120,{"$f":"0.00000154*A84^2-0.00194*A84+0.61","v":{"v":0.39937599999999995,"d":"0.399"}}]
[150,{"v":0.35364999999999996,"d":"0.354"}]
[180,{"v":0.31069599999999997,"d":"0.311"}]
[210,{"v":0.2705139999999999,"d":"0.271"}]
[240,{"v":0.23310399999999998,"d":"0.233"}]
[270,{"v":0.19846599999999992,"d":"0.198"}]
[300,{"v":0.16659999999999991,"d":"0.167"}]
[330,{"v":0.13750600000000002,"d":"0.138"}]
[360,{"v":0.11118399999999995,"d":"0.111"}]
[450,{"v":0.04884999999999995,"d":"0.049"}]
[480,{"v":0.03361599999999998,"d":"0.034"}]
[510,{"v":0.021154000000000006,"d":"0.021"}]
[540,{"v":0.011463999999999919,"d":"0.011"}]
[570,{"v":4.545999999999939E-3,"d":"0.005"}]
[600,{"v":3.9999999999984492E-4,"d":"0.000"}]
[]
[]
["nº de indicador:",38,"función de transformación:","CA=-1E-02*I+1","0<I<100"]
["Indicador:","% de personas afectadas por concentraciones perjudiciales de polvo y partículas en suspensión."]
["fórmula del indicador"]
["unidad del indicador:","%"]
["rango de valores del indicador:","0 - 100","valor del indicador",40]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D105<0,\"valor del indicador fuera de rango\",IF(D105<=100,((-0.01*D105)+(1)),\"valor del indicador fuera rango\"))","v":{"v":0.6,"d":"0.600"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.01*A108+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A108+5","v":5},{"$f":"-0.01*A109+1","v":{"v":0.95,"d":"0.950"}}]
[{"$f":"A109+5","v":10},{"v":0.9,"d":"0.900"}]
[15,{"v":0.85,"d":"0.850"}]
[20,{"v":0.8,"d":"0.800"}]
[25,{"v":0.75,"d":"0.750"}]
[30,{"v":0.7,"d":"0.700"}]
[35,{"v":0.6499999999999999,"d":"0.650"}]
[40,{"v":0.6,"d":"0.600"}]
[45,{"v":0.55,"d":"0.550"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.44999999999999996,"d":"0.450"}]
[60,{"v":0.4,"d":"0.400"}]
[70,{"v":0.29999999999999993,"d":"0.300"}]
[80,{"v":0.19999999999999996,"d":"0.200"}]
[90,{"v":0.09999999999999998,"d":"0.100"}]
[100,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",39,"función de transformación:","CA=+1","0<I<2,5"]
["Indicador:","Deposición de polvo por unidad de superficie.",null,"CA=-1,18E-0,2*(I^2)+5,92E-02*I+9,2E-01","2,5<I<9"]
["fórmula del indicador",null,null,"CA=-5,56E-0,2*(I^2)+5,56E-01*I ","9<I<10"]
["unidad del indicador:","g m-2 día-1"]
["rango de valores del indicador:","0 - 10","valor del indicador",9.5]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D131<0,\"valor del indicador fuera de rango\",IF(D131<=2.5,1,IF(D131<=9,-0.0118*(D131^2)+(0.0592*D131)+0.926,IF(D131<=10,-0.0556*(D131^2)+(0.556*D131),\"valor del indicador fuera rango\"))))","v":{"v":0.2641,"d":"0.264"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[0.5,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":1,"d":"1.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[1.5,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":2,"d":"2.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[2.5,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":3,"d":"3.0"},{"$f":"-0.0118*A140^2+0.0592*A140+0.926","v":{"v":0.9974000000000001,"d":"0.997"}}]
[3.5,{"$f":"-0.0118*A141^2+0.0592*A141+0.926","v":{"v":0.98865,"d":"0.989"}}]
[{"v":4,"d":"4.0"},{"v":0.9740000000000001,"d":"0.974"}]
[4.5,{"v":0.9534500000000001,"d":"0.953"}]
[{"v":5,"d":"5.0"},0.927]
[5.5,{"v":0.8946500000000001,"d":"0.895"}]
[{"v":6,"d":"6.0"},{"v":0.8564,"d":"0.856"}]
[6.5,{"v":0.8122500000000001,"d":"0.812"}]
[{"v":7,"d":"7.0"},{"v":0.7622000000000001,"d":"0.762"}]
[{"v":8,"d":"8.0"},{"v":0.6444000000000001,"d":"0.644"}]
[8.5,{"v":0.57665,"d":"0.577"}]
[{"v":9,"d":"9.0"},{"v":0.5030000000000001,"d":"0.503"}]
[9.5,{"$f":"-0.0556*(A152^2)+0.556*(A152)","v":{"v":0.2641,"d":"0.264"}}]
[{"v":10,"d":"10.0"},{"$f":"-0.0556*(A153^2)+0.556*(A153)","v":{"v":0,"d":"0.000"}}]

{"sheet":"40","index":11,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[6,2,6,4]]}
["nº de indicador:",40,"función de transformación:","CA=+1","0<I<2"]
["Indicador:","Indicador semicualitativo del olor del aire.",null,"CA=-0,375E-0,1*I+1,75","2<I<4"]
["fórmula del indicador",null,null,"CA=-0,125E-0,1*I+0,75","4<I<6"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 6","valor del indicador",5]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=2,1,IF(D5<=4,-0.375*(D5)+1.75,IF(D5<=6,-0.125*(D5)+0.75,\"valor del indicador fuera rango\"))))","v":0.125}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[0.1,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A9+0.3","v":0.4},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[0.7,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":1,"d":"1.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[1.3,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[1.6,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":1.9000000000000001,"d":"1.9"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[2.2,{"$f":"-0.375*A16+1.75","v":{"v":0.9249999999999999,"d":"0.925"}}]
[2.5,{"v":0.8125,"d":"0.813"}]
[2.8,{"v":0.7000000000000002,"d":"0.700"}]
[{"v":3.0999999999999996,"d":"3.1"},{"v":0.5875000000000001,"d":"0.588"}]
[{"v":3.3999999999999995,"d":"3.4"},{"v":0.4750000000000001,"d":"0.475"}]
[{"v":3.6999999999999993,"d":"3.7"},{"v":0.36250000000000027,"d":"0.363"}]
[{"v":3.999999999999999,"d":"4.0"},{"$f":"-0.125*A22+0.75","v":{"v":0.2500000000000001,"d":"0.250"}}]
[{"$f":"+A22+0.3","v":{"v":4.299999999999999,"d":"4.3"}},{"v":0.21250000000000013,"d":"0.213"}]
[{"v":4.599999999999999,"d":"4.6"},{"v":0.17500000000000016,"d":"0.175"}]
[{"v":4.899999999999999,"d":"4.9"},{"v":0.13750000000000018,"d":"0.138"}]
[{"v":5.199999999999998,"d":"5.2"},{"v":0.1000000000000002,"d":"0.100"}]
[{"v":5.499999999999998,"d":"5.5"},{"v":0.06250000000000022,"d":"0.063"}]
[{"$f":"+A27+0.3","v":{"v":5.799999999999998,"d":"5.8"}},{"v":0.025000000000000244,"d":"0.025"}]
[{"v":6,"d":"6.0"},{"v":0,"d":"0.000"}]

{"sheet":"41-44","index":12,"n_rows":107,"n_cols":5,"rows_kept":107,"merged":[[6,2,6,4],[32,2,32,4],[60,2,60,4],[88,2,88,4]]}
["nº de indicador:",41,"función de transformación:","CA=-0,446*(I^2)+1","0<I<0,667"]
["Indicador:","promedio diario del nivel de inmisión de Pb",null,"CA=-0,606*I+1,21","0,667<I<1,33"]
["fórmula del indicador",null,null,"CA=0,337*(I^2)-1,35*I+1,6","1,33<I<2"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 2","valor del indicador",2]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=0.667,-0.446*(D5^2)+1,IF(D5<=1.33,-0.606*D5+1.21,IF(D5<=2,(0.337*D5^2)-(1.35*D5)+1.6,\"valor del indicador fuera del rango\"))))","v":0.248}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"(-0.446*A8^2)+ 1","v":{"v":1,"d":"1.000"}}]
[0.1,{"v":0.99554,"d":"0.996"}]
[0.2,{"v":0.98216,"d":"0.982"}]
[0.3,{"v":0.95986,"d":"0.960"}]
[0.4,{"v":0.92864,"d":"0.929"}]
[0.5,{"v":0.8885,"d":"0.889"}]
[0.6,{"v":0.83944,"d":"0.839"}]
[0.7,{"$f":"-0.606*A15+ 1.21","v":{"v":0.7858,"d":"0.786"}}]
[0.8,{"v":0.7252,"d":"0.725"}]
[0.9,{"v":0.6646,"d":"0.665"}]
[{"v":1,"d":"1.0"},0.604]
[1.1,{"v":0.5433999999999999,"d":"0.543"}]
[1.2,{"v":0.4828,"d":"0.483"}]
[1.4,{"$f":"(0.337*A21^2)-1.35*A21+1.6","v":{"v":0.3705200000000002,"d":"0.371"}}]
[1.6,{"$f":"(0.337*A22^2)-1.35*A22+1.6","v":{"v":0.3027200000000003,"d":"0.303"}}]
[1.8,{"$f":"(0.337*A23^2)-1.35*A23+1.6","v":{"v":0.2618800000000001,"d":"0.262"}}]
[{"v":2,"d":"2.0"},{"$f":"(0.337*A24^2)-1.35*A24+1.6","v":0.248}]
[]
[]
["nº de indicador:",42,"función de transformación:","CA=-0,446*(I^2)+1","0<I<0,667"]
["Indicador:","ponderación del nivel diario de inmisión de Pb según la superficie de zonas homogéneas",null,"CA=-0,606*I+1,21","0,667<I<1,33"]
["fórmula del indicador",null,null,"CA=0,337*(I^2)-1,35*I+1,6","1,33<I<2"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 2","valor del indicador",2]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D31<0,\"valor del indicador fuera de rango\",IF(D31<=0.667,-0.446*(D31^2)+1,IF(D31<=1.33,-0.606*D31+1.21,IF(D31<=2,(0.337*D31^2)-(1.35*D31)+1.6,\"valor del indicador fuera del rango\"))))","v":0.248}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"(-0.446*A34^2)+ 1","v":{"v":1,"d":"1.000"}}]
[0.1,{"v":0.99554,"d":"0.996"}]
[0.2,{"v":0.98216,"d":"0.982"}]
[0.3,{"v":0.95986,"d":"0.960"}]
[0.4,{"v":0.92864,"d":"0.929"}]
[0.5,{"v":0.8885,"d":"0.889"}]
[0.6,{"v":0.83944,"d":"0.839"}]
[0.7,{"$f":"-0.606*A41+ 1.21","v":{"v":0.7858,"d":"0.786"}}]
[0.8,{"v":0.7252,"d":"0.725"}]
[0.9,{"v":0.6646,"d":"0.665"}]
[{"v":1,"d":"1.0"},0.604]
[1.1,{"v":0.5433999999999999,"d":"0.543"}]
[1.2,{"v":0.4828,"d":"0.483"}]
[1.4,{"$f":"(0.337*A47^2)-1.35*A47+1.6","v":{"v":0.3705200000000002,"d":"0.371"}}]
[1.5,{"v":0.3332499999999998,"d":"0.333"}]
[1.6,{"v":0.3027200000000003,"d":"0.303"}]
[1.8,{"v":0.2618800000000001,"d":"0.262"}]
[1.9,{"v":0.25157000000000007,"d":"0.252"}]
[{"v":2,"d":"2.0"},0.248]
[]
[]
["nº de indicador:",43,"función de transformación:","CA=-0,446*(I^2)+1","0<I<0,667"]
["Indicador:","ponderación del nivel diario de inmisión de Pb según la población afectada en cada zona",null,"CA=-0,606*I+1,21","0,667<I<1,33"]
["fórmula del indicador",null,null,"CA=0,337*(I^2)-1,35*I+1,6","1,33<I<2"]
["unidad del indicador:","mg m-3"]
["rango de valores del indicador:","0 - 2","valor del indicador",2]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D59<0,\"valor del indicador fuera de rango\",IF(D59<=0.667,-0.446*(D59^2)+1,IF(D59<=1.33,-0.606*D59+1.21,IF(D59<=2,(0.337*D59^2)-(1.35*D59)+1.6,\"valor del indicador fuera del rango\"))))","v":0.248}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"(-0.446*A62^2)+ 1","v":{"v":1,"d":"1.000"}}]
[0.1,{"v":0.99554,"d":"0.996"}]
[0.2,{"v":0.98216,"d":"0.982"}]
[0.3,{"v":0.95986,"d":"0.960"}]
[0.4,{"v":0.92864,"d":"0.929"}]
[0.5,{"v":0.8885,"d":"0.889"}]
[0.6,{"v":0.83944,"d":"0.839"}]
[0.7,{"$f":"-0.606*A69+ 1.21","v":{"v":0.7858,"d":"0.786"}}]
[0.8,{"v":0.7252,"d":"0.725"}]
[0.9,{"v":0.6646,"d":"0.665"}]
[{"v":1,"d":"1.0"},0.604]
[1.1,{"v":0.5433999999999999,"d":"0.543"}]
[1.2,{"v":0.4828,"d":"0.483"}]
[1.4,{"$f":"(0.337*A75^2)-1.35*A75+1.6","v":{"v":0.3705200000000002,"d":"0.371"}}]
[1.5,{"v":0.3332499999999998,"d":"0.333"}]
[1.6,{"v":0.3027200000000003,"d":"0.303"}]
[1.8,{"v":0.2618800000000001,"d":"0.262"}]
[1.9,{"v":0.25157000000000007,"d":"0.252"}]
[{"v":2,"d":"2.0"},0.248]
[]
[]
["nº de indicador:",44,"función de transformación:","CA=-1E-02*I+1","0<I<100"]
["Indicador:","% de personas afectadas por niveles de Pb perjudiciales"]
["fórmula del indicador"]
["unidad del indicador:","%"]
["rango de valores del indicador:","0 - 100","valor del indicador",50]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D87<0,\"valor del indicador fuera de rango\",IF(D87<=100,-0.01*D87+1,IF(D87>=100,\"valor del indicador fuera de rango\")))","v":{"v":0.5,"d":"0.500"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.01*A90+1","v":{"v":1,"d":"1.000"}}]
[5,{"v":0.95,"d":"0.950"}]
[10,{"v":0.9,"d":"0.900"}]
[15,{"v":0.85,"d":"0.850"}]
[20,{"v":0.8,"d":"0.800"}]
[25,{"v":0.75,"d":"0.750"}]
[30,{"v":0.7,"d":"0.700"}]
[35,{"v":0.6499999999999999,"d":"0.650"}]
[40,{"v":0.6,"d":"0.600"}]
[45,{"v":0.55,"d":"0.550"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.44999999999999996,"d":"0.450"}]
[60,{"v":0.4,"d":"0.400"}]
[65,{"v":0.35,"d":"0.350"}]
[70,{"v":0.29999999999999993,"d":"0.300"}]
[80,{"v":0.19999999999999996,"d":"0.200"}]
[90,{"v":0.09999999999999998,"d":"0.100"}]
[100,{"v":0,"d":"0.000"}]