{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Registro","79-80","81","82-125","126-127"],"not_rendered":{"charts":51,"images":10,"external_links":6,"defined_names":27},"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":"79-80","index":1,"n_rows":56,"n_cols":5,"rows_kept":56,"merged":[[6,2,6,4],[35,2,35,4]]}
["nº de indicador:",79,"función de transformación:","CA=-1E-4I^2+1","I<100"]
["Indicador:","% de pérdidas de agua en la cuenca hirológica"]
["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(D5<0,\"valor del fuera de rango\",IF(D5<=100,-0.0001*(D5^2)+1,\"valor del indicador fuera rango\"))","v":{"v":0.75,"d":"0.750"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.0001)*A8^2+1","v":{"v":1,"d":"1.000"}}]
[5,{"$f":"(-0.0001)*A9^2+1","v":{"v":0.9975,"d":"0.998"}}]
[10,{"v":0.99,"d":"0.990"}]
[15,{"v":0.9775,"d":"0.978"}]
[20,{"v":0.96,"d":"0.960"}]
[25,{"v":0.9375,"d":"0.938"}]
[30,{"v":0.91,"d":"0.910"}]
[35,{"v":0.8775,"d":"0.878"}]
[40,{"v":0.84,"d":"0.840"}]
[45,{"v":0.7975,"d":"0.798"}]
[50,{"v":0.75,"d":"0.750"}]
[55,{"v":0.6975,"d":"0.698"}]
[60,{"v":0.6399999999999999,"d":"0.640"}]
[65,{"v":0.5774999999999999,"d":"0.578"}]
[70,{"v":0.51,"d":"0.510"}]
[75,{"v":0.4375,"d":"0.438"}]
[80,{"v":0.36,"d":"0.360"}]
[85,{"v":0.27749999999999997,"d":"0.278"}]
[90,{"v":0.18999999999999995,"d":"0.190"}]
[100,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",79,"función de transformación:","CA=-1E-4I^2+1","I<100"]
["Indicador:","% de pérdidas con respecto a la cantidad de recurso disponible"]
["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(D34<0,\"valor del fuera de rango\",IF(D34<=100,-0.0001*(D34^2)+1,\"valor del indicador fuera rango\"))","v":{"v":0.75,"d":"0.750"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.0001)*A37^2+1","v":{"v":1,"d":"1.000"}}]
[5,{"$f":"(-0.0001)*A38^2+1","v":{"v":0.9975,"d":"0.998"}}]
[10,{"v":0.99,"d":"0.990"}]
[15,{"v":0.9775,"d":"0.978"}]
[20,{"v":0.96,"d":"0.960"}]
[25,{"v":0.9375,"d":"0.938"}]
[30,{"v":0.91,"d":"0.910"}]
[35,{"v":0.8775,"d":"0.878"}]
[40,{"v":0.84,"d":"0.840"}]
[45,{"v":0.7975,"d":"0.798"}]
[50,{"v":0.75,"d":"0.750"}]
[55,{"v":0.6975,"d":"0.698"}]
[60,{"v":0.6399999999999999,"d":"0.640"}]
[65,{"v":0.5774999999999999,"d":"0.578"}]
[70,{"v":0.51,"d":"0.510"}]
[75,{"v":0.4375,"d":"0.438"}]
[80,{"v":0.36,"d":"0.360"}]
[85,{"v":0.27749999999999997,"d":"0.278"}]
[90,{"v":0.18999999999999995,"d":"0.190"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"81","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"merged":[[6,2,6,4]]}
["nº de indicador:",81,"función de transformación:","CA=1","0<I<50"]
["Indicador:","% de aumento de la superficie inundable (para un periodo de retorno de 100 años) al modificar la sección del caudal mediante la colocacion de barreras en él.",null,"CA=-4E-4I^2+4E-2I","50<I<100"]
["fórmula del indicador","En el recuadro verde"]
["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(D5<0,\"valor del indicador fuera de rango\",IF(D5<=50,1,IF(D5<=100,(-0.0004*(D5^2))+(0.04*D5),\"valor del indicador fuera de rango\")))","v":{"v":1,"d":"1.000"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[5,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[15,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[20,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[25,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[30,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[35,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[40,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[45,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[50,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A18+3","v":53},{"$f":"(-0.0004)*A19^2+(0.04)*A19","v":{"v":0.9964,"d":"0.996"}}]
[{"$f":"+A19+3","v":56},{"$f":"(-0.0004)*A20^2+(0.04)*A20","v":{"v":0.9856000000000003,"d":"0.986"}}]
[59,{"v":0.9675999999999998,"d":"0.968"}]
[62,{"v":0.9423999999999999,"d":"0.942"}]
[65,{"v":0.9099999999999999,"d":"0.910"}]
[68,{"v":0.8704000000000001,"d":"0.870"}]
[71,{"v":0.8235999999999999,"d":"0.824"}]
[74,{"v":0.7696000000000001,"d":"0.770"}]
[77,{"v":0.7084000000000001,"d":"0.708"}]
[{"$f":"+A27+3","v":80},{"v":0.6400000000000001,"d":"0.640"}]
[83,{"v":0.5644,"d":"0.564"}]
[86,{"v":0.4815999999999998,"d":"0.482"}]
[89,{"v":0.39159999999999995,"d":"0.392"}]
[90,{"v":0.3599999999999999,"d":"0.360"}]
[{"$f":"+A31+3","v":92},{"v":0.2944,"d":"0.294"}]
[95,{"v":0.18999999999999995,"d":"0.190"}]
[{"$f":"+A34+3","v":98},{"v":0.0783999999999998,"d":"0.078"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"82-125","index":3,"n_rows":1393,"n_cols":5,"rows_kept":1393,"merged":[[6,2,6,4],[55,2,55,4],[88,2,88,4],[120,2,120,4],[168,2,168,4],[207,2,207,4],[246,2,246,4],[285,2,285,4],[321,2,321,4],[351,2,351,4],[381,2,381,4],[411,2,411,4],[441,2,441,4],[471,2,471,4],[501,2,501,4],[531,2,531,4],[561,2,561,4],[591,2,591,4],[621,2,621,4],[651,2,651,4],[681,2,681,4],[711,2,711,4],[741,2,741,4],[771,2,771,4],[801,2,801,4],[831,2,831,4],[861,2,861,4],[891,2,891,4],[921,2,921,4],[951,2,951,4],[981,2,981,4],[1011,2,1011,4],[1041,2,1041,4],[1071,2,1071,4],[1101,2,1101,4],[1131,2,1131,4],[1161,2,1161,4],[1191,2,1191,4],[1221,2,1221,4],[1251,2,1251,4],[1281,2,1281,4],[1311,2,1311,4],[1341,2,1341,4],[1371,2,1371,4]]}
["nº de indicador:",82,"función de transformación:","CA=0","0<I<50"]
["Indicador:","Índice de calidad general (ICG). ",null,"CA=-1,25E-04*I^2+3,88E-02*I-1,63","50<I<100"]
["fórmula del indicador"," ICG = å Qi x Pi / å Pi"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",70]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=50,0,IF(D5<=100,(-0.000125*D5^2+0.0388*D5-1.63),\"valor del indicador fuera rango\")))","v":{"v":0.4735000000000005,"d":"0.474"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"$f":"A8+5","v":5},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[10,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[15,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[20,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[25,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[30,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[35,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[40,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[45,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[50,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[55,{"$f":"(-0.000125*A19^2)+(0.0388*A19)-1.63","v":{"v":0.12587499999999996,"d":"0.126"}}]
[60,{"v":0.24800000000000044,"d":"0.248"}]
[65,{"v":0.3638750000000004,"d":"0.364"}]
[70,{"v":0.4735000000000005,"d":"0.474"}]
[75,{"v":0.5768750000000002,"d":"0.577"}]
[80,{"v":0.6740000000000004,"d":"0.674"}]
[85,{"v":0.764875,"d":"0.765"}]
[90,{"v":0.8494999999999999,"d":"0.850"}]
[95,{"v":0.9278750000000002,"d":"0.928"}]
[100,{"v":1,"d":"1.000"}]
{"$rows_empty":21}
["nº de indicador:",83,"función de transformación:","CA=-3E-02*I^2-6E-02*I+1","0<I<2"]
["Indicador:","Demanda biológica de oxígeno (DBO)5",null,"CA=-1,9E-01*I+1,140","2<I<6"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1  de   O2"]
["rango de valores del indicador:","0 - 6","valor del indicador",3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D54<0,\"valor del indicador fuera de rango\",IF(D54<=2,(-0.03*D54^2-0.06*D54+1),IF(D54<=6,(-0.19*D54+1.14),\"valor del indicador fuera rango\")))","v":{"v":0.5699999999999998,"d":"0.570"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"-0.03*A57^2-0.06*A57+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A57+0.3","v":0.3},{"v":0.9793,"d":"0.979"}]
[0.6,{"v":0.9532,"d":"0.953"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.9217,"d":"0.922"}]
[1.2,{"v":0.8848,"d":"0.885"}]
[1.5,{"v":0.8425,"d":"0.843"}]
[1.8,{"v":0.7948,"d":"0.795"}]
[{"v":2,"d":"2.0"},{"$f":"-0.19*A64+1.14","v":{"v":0.7599999999999999,"d":"0.760"}}]
[2.5,{"v":0.6649999999999999,"d":"0.665"}]
[{"v":3,"d":"3.0"},{"v":0.5699999999999998,"d":"0.570"}]
[{"$f":"+A66+0.2","v":3.2},{"v":0.5319999999999998,"d":"0.532"}]
[{"v":3.4000000000000004,"d":"3.4"},{"v":0.4939999999999998,"d":"0.494"}]
[{"v":3.6000000000000005,"d":"3.6"},{"v":0.45599999999999974,"d":"0.456"}]
[{"v":3.8000000000000007,"d":"3.8"},{"v":0.4179999999999997,"d":"0.418"}]
[{"v":4.000000000000001,"d":"4.0"},{"v":0.37999999999999967,"d":"0.380"}]
[{"v":4.200000000000001,"d":"4.2"},{"v":0.34199999999999964,"d":"0.342"}]
[{"v":4.400000000000001,"d":"4.4"},{"v":0.3039999999999996,"d":"0.304"}]
[{"v":4.600000000000001,"d":"4.6"},{"v":0.26599999999999957,"d":"0.266"}]
[{"v":4.800000000000002,"d":"4.8"},{"v":0.22799999999999954,"d":"0.228"}]
[{"v":5.000000000000002,"d":"5.0"},{"v":0.1899999999999995,"d":"0.190"}]
[{"v":5.200000000000002,"d":"5.2"},{"v":0.15199999999999947,"d":"0.152"}]
[{"$f":"+A77+0.2","v":{"v":5.400000000000002,"d":"5.4"}},{"v":0.11399999999999944,"d":"0.114"}]
[{"v":5.600000000000002,"d":"5.6"},{"v":0.0759999999999994,"d":"0.076"}]
[{"v":6,"d":"6.0"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",84,"función de transformación:","CA=-2,13E-04*I^2-9,33E-02*I+1","0<I<5"]
["Indicador:","Oxidabilidad al MnO4K"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1  de   O2"]
["rango de valores del indicador:","0 - 5","valor del indicador",1]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D87<0,\"valor del indicador fuera de rango\",IF(D87<=5,(-0.0213*D87^2-0.0933*D87+1),\"valor del indicador fuera rango\"))","v":{"v":0.8854,"d":"0.885"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"(-0.0213*A90^2)-(0.0933*A90)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A90+0.25","v":{"v":0.25,"d":"0.3"}},{"$f":"(-0.0213*A91^2)-(0.0933*A91)+1","v":{"v":0.97534375,"d":"0.975"}}]
[{"$f":"+A91+0.25","v":0.5},{"v":0.948025,"d":"0.948"}]
[{"v":0.75,"d":"0.8"},{"v":0.91804375,"d":"0.918"}]
[{"v":1,"d":"1.0"},{"v":0.8854,"d":"0.885"}]
[{"v":1.25,"d":"1.3"},{"v":0.85009375,"d":"0.850"}]
[1.5,{"v":0.812125,"d":"0.812"}]
[{"v":1.75,"d":"1.8"},{"v":0.77149375,"d":"0.771"}]
[{"v":2,"d":"2.0"},{"v":0.7282,"d":"0.728"}]
[{"v":2.25,"d":"2.3"},{"v":0.68224375,"d":"0.682"}]
[2.5,{"v":0.633625,"d":"0.634"}]
[{"v":2.75,"d":"2.8"},{"v":0.5823437499999999,"d":"0.582"}]
[{"v":3,"d":"3.0"},{"v":0.5284,"d":"0.528"}]
[{"v":3.25,"d":"3.3"},{"v":0.47179375,"d":"0.472"}]
[3.5,{"v":0.41252500000000003,"d":"0.413"}]
[{"v":3.75,"d":"3.8"},{"v":0.35059375000000004,"d":"0.351"}]
[{"v":4,"d":"4.0"},{"v":0.28600000000000003,"d":"0.286"}]
[4.2,{"v":0.23240799999999995,"d":"0.232"}]
[4.4,{"v":0.17711199999999994,"d":"0.177"}]
[4.6,{"v":0.12011200000000011,"d":"0.120"}]
[4.7,{"v":0.09097299999999997,"d":"0.091"}]
[4.8,{"v":0.06140800000000013,"d":"0.061"}]
[{"v":5,"d":"5.0"},{"v":0.001000000000000112,"d":"0.001"}]
[]
[]
["nº de indicador:",85,"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",40]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D119<0,\"valor del indicador fuera de rango\",IF(D119<=36,-0.0139*D119+1,IF(D119<=131,(-0.00526*D119)+0.689,IF(D119<=140,0,\"valor del indicador fuera rango\"))))","v":{"v":0.4785999999999999,"d":"0.479"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0139*A122+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A122+5","v":5},{"$f":"-0.0139*A123+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*A130+0.689","v":{"v":0.4785999999999999,"d":"0.479"}}]
[45,{"$f":"-0.00526*A131+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"}]
{"$rows_empty":12}
["nº de indicador:",86,"función de transformación:","CA=-2,13E-04*I^2-9,33E-02*I+1","0,2<I<1"]
["Indicador:","Calidad del agua superficial desde el punto de vista de la potabilidad (verano)",null,"CA=-3,33E-02*I^2-5E-02*I+1,08","1<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0.2 - 5","valor del indicador",2]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D167<0.2,\"valor del indicador fuera de rango\",IF(D167<=1,(1.56*D167^2-0.625*D167+0.0625),IF(D167<=5,(-0.0333*D167^2-0.05*D167+1.08),\"valor del indicador fuera rango\")))","v":{"v":0.8468,"d":"0.847"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0.2,{"$f":"(1.56*(A170^2))-(0.625*A170)+0.0625","v":{"v":-9.9999999999988987E-5,"d":"-0.000"}}]
[{"$f":"+A170+0.1","v":0.30000000000000004},{"$f":"(1.56*(A171^2))-(0.625*A171)+0.0625","v":{"v":0.015400000000000025,"d":"0.015"}}]
[{"$f":"+A171+0.1","v":0.4},{"v":0.062100000000000044,"d":"0.062"}]
[0.5,{"v":0.14,"d":"0.140"}]
[0.6,{"v":0.2491,"d":"0.249"}]
[0.7,{"v":0.38939999999999997,"d":"0.389"}]
[0.7999999999999999,{"v":0.5609,"d":"0.561"}]
[0.8999999999999999,{"v":0.7635999999999998,"d":"0.764"}]
[0.95,{"v":0.8766499999999999,"d":"0.877"}]
[1,{"v":0.9975,"d":"0.998"}]
[1,{"$f":"(-0.0333*(A180^2))-(0.05*A180)+1.08","v":{"v":0.9967,"d":"0.997"}}]
[{"$f":"A180+0.2","v":1.2},{"$f":"(-0.0333*(A181^2))-(0.05*A181)+1.08","v":{"v":0.972048,"d":"0.972"}}]
[1.4,{"$f":"(-0.0333*(A182^2))-(0.05*A182)+1.08","v":{"v":0.9447320000000001,"d":"0.945"}}]
[1.5999999999999999,{"$f":"(-0.0333*(A183^2))-(0.05*A183)+1.08","v":{"v":0.914752,"d":"0.915"}}]
[1.7999999999999998,{"$f":"(-0.0333*(A184^2))-(0.05*A184)+1.08","v":{"v":0.8821080000000001,"d":"0.882"}}]
[1.9999999999999998,{"$f":"(-0.0333*(A185^2))-(0.05*A185)+1.08","v":{"v":0.8468000000000001,"d":"0.847"}}]
[2.1999999999999997,{"v":0.8088280000000001,"d":"0.809"}]
[2.4,{"v":0.7681920000000001,"d":"0.768"}]
[2.6,{"v":0.7248920000000001,"d":"0.725"}]
[2.8000000000000003,{"v":0.678928,"d":"0.679"}]
[3.0000000000000004,{"v":0.6302999999999999,"d":"0.630"}]
[3.2000000000000006,{"v":0.5790079999999999,"d":"0.579"}]
[3.400000000000001,{"v":0.5250519999999999,"d":"0.525"}]
[3.600000000000001,{"v":0.46843199999999974,"d":"0.468"}]
[3.800000000000001,{"v":0.4091479999999996,"d":"0.409"}]
[4.000000000000001,{"v":0.34719999999999973,"d":"0.347"}]
[4.200000000000001,{"v":0.28258799999999973,"d":"0.283"}]
[4.400000000000001,{"v":0.21531199999999961,"d":"0.215"}]
[4.600000000000001,{"v":0.1453719999999994,"d":"0.145"}]
[5,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",87,"función de transformación:","CA=5,56*I^2-2,22*I+2,22E-01","0,2<I<0,5"]
["Indicador:","Calidad del agua superficial desde el punto de vista de la potabilidad (primavera-otoño)",null,"CA=-2*I^2+4I-1","0,5<I<1"]
["fórmula del indicador",null,null,"CA=-3,333E-02*I^2-5E-02*I+1,08","1<I<5"]
["unidad del indicador:"]
["rango de valores del indicador:","0.2 - 5","valor del indicador",1.4]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D206<0.2,\"valor del indicador fuera de rango\",IF(D206<=0.5,(5.56*D206^2-2.22*D206+0.222),IF(D206<=1,(-2*D206^2+4*D206-1),IF(D206<=5,(-0.0333*D206^2-0.05*D206+1.08),\"valor del indicador fuera rango\"))))","v":{"v":0.9447320000000001,"d":"0.945"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0.2,{"$f":"(5.56*(A209^2))-(2.22*A209)+0.222","v":{"v":3.9999999999995595E-4,"d":"0.000"}}]
[{"$f":"+A209+0.1","v":0.30000000000000004},{"$f":"(5.56*(A210^2))-(2.22*A210)+0.222","v":{"v":0.05639999999999992,"d":"0.056"}}]
[{"$f":"+A210+0.1","v":0.4},{"$f":"(5.56*(A211^2))-(2.22*A211)+0.222","v":{"v":0.22359999999999994,"d":"0.224"}}]
[0.5,{"$f":"(5.56*(A212^2))-(2.22*A212)+0.222","v":{"v":0.5019999999999998,"d":"0.502"}}]
[0.6,{"$f":"(-2*(A213^2))+(4*A213)-1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[0.7,{"$f":"(-2*(A214^2))+(4*A214)-1","v":{"v":0.8199999999999998,"d":"0.820"}}]
[0.7999999999999999,{"$f":"(-2*(A215^2))+(4*A215)-1","v":{"v":0.9199999999999999,"d":"0.920"}}]
[0.8999999999999999,{"$f":"(-2*(A216^2))+(4*A216)-1","v":{"v":0.98,"d":"0.980"}}]
[0.9999999999999999,{"$f":"(-2*(A217^2))+(4*A217)-1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A217+0.2","v":1.2},{"$f":"-0.0333*A218^2-0.05*A218+1.08","v":{"v":0.972048,"d":"0.972"}}]
[{"$f":"+A218+0.2","v":1.4},{"$f":"-0.0333*A219^2-0.05*A219+1.08","v":{"v":0.9447320000000001,"d":"0.945"}}]
[1.5999999999999999,{"v":0.914752,"d":"0.915"}]
[1.7999999999999998,{"v":0.8821080000000001,"d":"0.882"}]
[1.9999999999999998,{"v":0.8468000000000001,"d":"0.847"}]
[2.1999999999999997,{"v":0.8088280000000001,"d":"0.809"}]
[2.4,{"v":0.7681920000000001,"d":"0.768"}]
[2.6,{"v":0.7248920000000001,"d":"0.725"}]
[2.8000000000000003,{"v":0.678928,"d":"0.679"}]
[3.0000000000000004,{"v":0.6302999999999999,"d":"0.630"}]
[3.2000000000000006,{"v":0.5790079999999999,"d":"0.579"}]
[3.400000000000001,{"v":0.5250519999999999,"d":"0.525"}]
[3.600000000000001,{"v":0.46843199999999974,"d":"0.468"}]
[3.800000000000001,{"v":0.4091479999999996,"d":"0.409"}]
[4.000000000000001,{"v":0.34719999999999973,"d":"0.347"}]
[4.200000000000001,{"v":0.28258799999999973,"d":"0.283"}]
[4.400000000000001,{"v":0.21531199999999961,"d":"0.215"}]
[4.600000000000001,{"v":0.1453719999999994,"d":"0.145"}]
[4.800000000000002,{"v":0.07276799999999928,"d":"0.073"}]
[4.9,{"v":0.03546699999999969,"d":"0.035"}]
[5,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",88,"función de transformación:","CA=(-1,56*I^2)+(3,127*I)-0,563","0,2<I<1"]
["Indicador:","Calidad del agua superficial desde el punto de vista de la potabilidad (invierno)",null,"CA=(-0,0333*I^2) -(0,05*I) + 1,08","1<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0.2 - 5","valor del indicador",0.7]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D245<0.2,\"valor del indicador fuera de rango\",IF(D245<=1,(-1.56*(D245^2)+(3.127*D245)-0.563),IF(D245<=5,(-0.0333*(D245^2))-0.05*D245+1.08,\"valor del indicador fuera rango\")))","v":{"v":0.8614999999999999,"d":"0.862"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0.2,{"$f":"(-1.56*A248^2)+(3.127*A248)-0.563","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A248+0.1","v":0.30000000000000004},{"v":0.23470000000000002,"d":"0.235"}]
[{"$f":"+A249+0.1","v":0.4},{"v":0.4381999999999999,"d":"0.438"}]
[0.5,{"v":0.6104999999999998,"d":"0.611"}]
[0.6,{"v":0.7516,"d":"0.752"}]
[0.7,{"v":0.8614999999999999,"d":"0.862"}]
[0.7999999999999999,{"v":0.9402000000000001,"d":"0.940"}]
[0.8999999999999999,{"v":0.9876999999999996,"d":"0.988"}]
[0.95,{"v":0.9997499999999997,"d":"1.000"}]
[1,{"v":1.0039999999999998,"d":"1.004"}]
[{"v":1,"d":"1.0"},{"$f":"((-0.0333*(A258^2))-(0.05*A258)+1.08)","v":{"v":0.9967,"d":"0.997"}}]
[{"$f":"A258+0.2","v":1.2},{"v":0.972048,"d":"0.972"}]
[1.4,{"v":0.9447320000000001,"d":"0.945"}]
[{"v":1.5999999999999999,"d":"1.6"},{"v":0.914752,"d":"0.915"}]
[{"v":1.7999999999999998,"d":"1.8"},{"v":0.8821080000000001,"d":"0.882"}]
[{"v":1.9999999999999998,"d":"2.0"},{"v":0.8468000000000001,"d":"0.847"}]
[{"v":2.1999999999999997,"d":"2.2"},{"v":0.8088280000000001,"d":"0.809"}]
[2.4,{"v":0.7681920000000001,"d":"0.768"}]
[2.6,{"v":0.7248920000000001,"d":"0.725"}]
[{"v":2.8000000000000003,"d":"2.8"},{"v":0.678928,"d":"0.679"}]
[{"v":3.0000000000000004,"d":"3.0"},{"v":0.6302999999999999,"d":"0.630"}]
[{"v":3.2000000000000006,"d":"3.2"},{"v":0.5790079999999999,"d":"0.579"}]
[{"v":3.400000000000001,"d":"3.4"},{"v":0.5250519999999999,"d":"0.525"}]
[{"v":3.600000000000001,"d":"3.6"},{"v":0.46843199999999974,"d":"0.468"}]
[{"v":3.800000000000001,"d":"3.8"},{"v":0.4091479999999996,"d":"0.409"}]
[{"v":4.000000000000001,"d":"4.0"},{"v":0.34719999999999973,"d":"0.347"}]
[{"v":4.200000000000001,"d":"4.2"},{"v":0.28258799999999973,"d":"0.283"}]
[{"v":4.400000000000001,"d":"4.4"},{"v":0.21531199999999961,"d":"0.215"}]
[{"v":4.600000000000001,"d":"4.6"},{"v":0.1453719999999994,"d":"0.145"}]
[{"v":5,"d":"5.0"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",89,"función de transformación:","CA=1,56E-02*I+1","0<I<20"]
["Indicador:","Calidad del agua: color",null,"CA=-5E-03*I+8E-01","20<I<100"]
["fórmula del indicador",null,null,"CA=-3E-03*I+6E-01","100<I<200"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 200","valor del indicador",190]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D284<0,\"valor del indicador fuera de rango\",IF(D284<=20,(-0.0151*D284+1),IF(D284<=100,(-0.005*D284+0.8),IF(D284<=200,(-0.003*D284+0.6),\"valor del indicador fuera rango\"))))","v":{"v":0.029999999999999916,"d":"0.030"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0151*A287+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A287+10","v":10},{"$f":"-0.0151*A288+1","v":0.849}]
[{"$f":"+A288+5","v":15},{"$f":"-0.0151*A289+1","v":{"v":0.7735,"d":"0.774"}}]
[{"$f":"A288+10","v":20},{"$f":"-0.0151*A290+1","v":0.698}]
[{"$f":"A290+10","v":30},{"$f":"-0.005*A291+0.8","v":{"v":0.65,"d":"0.650"}}]
[40,{"$f":"-0.005*A292+0.8","v":{"v":0.6000000000000001,"d":"0.600"}}]
[50,{"v":0.55,"d":"0.550"}]
[60,{"v":0.5,"d":"0.500"}]
[70,{"v":0.45,"d":"0.450"}]
[80,{"v":0.4,"d":"0.400"}]
[90,{"v":0.35000000000000003,"d":"0.350"}]
[100,{"v":0.30000000000000004,"d":"0.300"}]
[110,{"$f":"-0.003*A299+0.6","v":{"v":0.26999999999999996,"d":"0.270"}}]
[120,{"$f":"-0.003*A300+0.6","v":{"v":0.24,"d":"0.240"}}]
[130,{"v":0.20999999999999996,"d":"0.210"}]
[140,{"v":0.18,"d":"0.180"}]
[{"$f":"+A302+5","v":145},{"v":0.16499999999999998,"d":"0.165"}]
[150,{"v":0.14999999999999997,"d":"0.150"}]
[155,{"v":0.13499999999999995,"d":"0.135"}]
[160,{"v":0.12,"d":"0.120"}]
[165,{"v":0.10499999999999998,"d":"0.105"}]
[170,{"v":0.08999999999999997,"d":"0.090"}]
[175,{"v":0.07499999999999996,"d":"0.075"}]
[180,{"v":0.05999999999999994,"d":"0.060"}]
[185,{"v":0.04499999999999993,"d":"0.045"}]
[190,{"v":0.029999999999999916,"d":"0.030"}]
[200,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",90,"función de transformación:","CA=8,89E-02*I^2-6,44E-01*I+1,154","4<I<7"]
["Indicador:","Calidad el agua: pH",null,"CA=-2E-01*I+2,4","7<I<8,5"]
["fórmula del indicador",null,null,"CA=-4,67E-01*I+4,67","8,5<I<10"]
["unidad del indicador:"]
["rango de valores del indicador:","4 - 10","valor del indicador",8]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D320<4,\"valor del indicador fuera de rango\",IF(D320<=7,0.0889*(D320)^2-0.644*(D320)+1.154,IF(D320<=8.5,-0.2*(D320)+2.4,IF(D320<=10,-0.467*(D320)+4.67))))","v":{"v":0.7999999999999998,"d":"0.800"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[4,{"$f":"0.0889*A323^2-0.644*A323+1.154","v":{"v":3.9999999999995595E-4,"d":"0.000"}}]
[{"$f":"+A323+0.5","v":4.5},{"v":0.05622499999999997,"d":"0.056"}]
[5,{"v":0.15649999999999986,"d":"0.157"}]
[5.5,{"v":0.3012250000000001,"d":"0.301"}]
[6,{"v":0.49040000000000017,"d":"0.490"}]
[6.5,{"v":0.7240250000000001,"d":"0.724"}]
[7,{"v":1,"d":"1.000"}]
[7,{"$f":"-0.2*A330+2.4","v":{"v":0.9999999999999998,"d":"1.000"}}]
[7.3,{"v":0.94,"d":"0.940"}]
[7.5,{"v":0.8999999999999999,"d":"0.900"}]
[7.8,{"v":0.8399999999999999,"d":"0.840"}]
[8,{"v":0.7999999999999998,"d":"0.800"}]
[8.2,{"v":0.76,"d":"0.760"}]
[8.5,{"v":0.6999999999999997,"d":"0.700"}]
[8.5,{"$f":"-0.467*A337+4.67","v":{"v":0.7004999999999999,"d":"0.701"}}]
[8.7,{"v":0.6071,"d":"0.607"}]
[9,{"v":0.46699999999999964,"d":"0.467"}]
[9.3,{"v":0.3268999999999993,"d":"0.327"}]
[9.5,{"v":0.23349999999999937,"d":"0.233"}]
[9.7,{"v":0.14010000000000034,"d":"0.140"}]
[10,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",91,"función de transformación:","CA=((-0,04)*I)+1","0<I<25"]
["Indicador:","Calidad el agua: sólidos en suspensión"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 25","valor del indicador",10]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D350<0,\"valor del indicador fuera de rango\",IF(D350<=25,((-0.04*D350)+1),\"valor del indicador fuera de 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.04)*A353)+1","v":{"v":1,"d":"1.000"}}]
[2,{"$f":"((-0.04)*A354)+1","v":{"v":0.92,"d":"0.920"}}]
[4,{"v":0.84,"d":"0.840"}]
[6,{"v":0.76,"d":"0.760"}]
[8,{"v":0.6799999999999999,"d":"0.680"}]
[10,{"v":0.6,"d":"0.600"}]
[{"$f":"+A358+1","v":11},{"v":0.56,"d":"0.560"}]
[12,{"v":0.52,"d":"0.520"}]
[13,{"v":0.48,"d":"0.480"}]
[14,{"v":0.43999999999999995,"d":"0.440"}]
[15,{"v":0.4,"d":"0.400"}]
[16,{"v":0.36,"d":"0.360"}]
[17,{"v":0.31999999999999995,"d":"0.320"}]
[18,{"v":0.28,"d":"0.280"}]
[19,{"v":0.24,"d":"0.240"}]
[20,{"v":0.19999999999999996,"d":"0.200"}]
[21,{"v":0.16000000000000003,"d":"0.160"}]
[22,{"v":0.12,"d":"0.120"}]
[23,{"v":0.07999999999999996,"d":"0.080"}]
[24,{"v":0.040000000000000036,"d":"0.040"}]
[25,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",92,"función de transformación:","CA=((-0,001)*I)+1","0<I<1000"]
["Indicador:","Calidad del agua: conductividad eléctrica a 20º"]
["fórmula del indicador"]
["unidad del indicador:","µohm cm-1"]
["rango de valores del indicador:","0 - 1000","valor del indicador",650]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D380<0,\"valor del indicador fuera de rango\",IF(D380<=1000,((-0.001*D380)+1),\"valor del indicador fuera de rango\"))","v":{"v":0.35,"d":"0.350"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"((-0.001)*A383)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A383+50","v":50},{"v":0.95,"d":"0.950"}]
[{"$f":"+A384+50","v":100},{"v":0.9,"d":"0.900"}]
[150,{"v":0.85,"d":"0.850"}]
[200,{"v":0.8,"d":"0.800"}]
[250,{"v":0.75,"d":"0.750"}]
[300,{"v":0.7,"d":"0.700"}]
[350,{"v":0.6499999999999999,"d":"0.650"}]
[400,{"v":0.6,"d":"0.600"}]
[450,{"v":0.55,"d":"0.550"}]
[500,{"v":0.5,"d":"0.500"}]
[550,{"v":0.44999999999999996,"d":"0.450"}]
[600,{"v":0.4,"d":"0.400"}]
[650,{"v":0.35,"d":"0.350"}]
[700,{"v":0.29999999999999993,"d":"0.300"}]
[750,{"v":0.25,"d":"0.250"}]
[800,{"v":0.19999999999999996,"d":"0.200"}]
[850,{"v":0.15000000000000002,"d":"0.150"}]
[900,{"v":0.09999999999999998,"d":"0.100"}]
[950,{"v":0.04999999999999993,"d":"0.050"}]
[1000,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",93,"función de transformación:","CA=(-0,3*I)+1","0<I<1"]
["Indicador:","Calidad del agua: concentración de plaguicidad totales",null,"CA=(-0,267*I)+0,967","1<I<2,5"]
["fórmula del indicador",null,null,"CA=(-0,12*I)+0,6","2,5<I<5"]
["unidad del indicador:","µg l-1"]
["rango de valores del indicador:","0 - 5","valor del indicador",3.25]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D410<0,\"valor del indicador fuera de rango\",IF(D410<=1,(-0.3*D410)+1,IF(D410<=2.5,(-0.267*D410)+0.967,IF(D410<=5,(-0.12*D410)+0.6,\"valor del indicador fuera rango\"))))","v":{"v":0.20999999999999996,"d":"0.210"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"(-0.3*A413)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A413+0.25","v":0.25},{"$f":"(-0.3*A414)+1","v":0.925}]
[{"$f":"+A414+0.25","v":{"v":0.5,"d":"0.50"}},{"$f":"(-0.3*A415)+1","v":{"v":0.85,"d":"0.850"}}]
[0.75,{"$f":"(-0.3*A416)+1","v":0.775}]
[{"v":1,"d":"1.00"},{"$f":"(-0.3*A417)+1","v":{"v":0.7,"d":"0.700"}}]
[1.25,{"$f":"(-0.267*A418)+0.967","v":{"v":0.63325,"d":"0.633"}}]
[{"v":1.5,"d":"1.50"},{"v":0.5665,"d":"0.567"}]
[1.75,{"v":0.4997499999999999,"d":"0.500"}]
[{"v":2,"d":"2.00"},{"v":0.43299999999999994,"d":"0.433"}]
[2.25,{"v":0.36624999999999996,"d":"0.366"}]
[{"v":2.5,"d":"2.50"},{"v":0.2995,"d":"0.300"}]
[2.75,{"$f":"(-0.12*A424)+0.6","v":{"v":0.27,"d":"0.270"}}]
[{"v":3,"d":"3.00"},{"v":0.24,"d":"0.240"}]
[3.25,{"v":0.20999999999999996,"d":"0.210"}]
[{"v":3.5,"d":"3.50"},{"v":0.18,"d":"0.180"}]
[3.75,{"v":0.15000000000000002,"d":"0.150"}]
[{"v":4,"d":"4.00"},{"v":0.12,"d":"0.120"}]
[4.25,{"v":0.08999999999999997,"d":"0.090"}]
[{"v":4.5,"d":"4.50"},{"v":0.05999999999999994,"d":"0.060"}]
[4.75,{"v":0.030000000000000027,"d":"0.030"}]
[{"v":5,"d":"5.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",94,"función de transformación:","CA=((-0,0333)*I)+1","0<I<30"]
["Indicador:","calidad del agua: demanda química de 02 (DQO)"]
["fórmula del indicador"]
["unidad del indicador:","mg I-1 O2"]
["rango de valores del indicador:","0 - 30","valor del indicador",3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D440<0,\"valor del indicador fuera de rango\",IF(D440<=30,(-0.0333*D440)+1,\"valor del indicador fuera rango\"))","v":{"v":0.9001,"d":"0.900"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"((-0.0333)*A443)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A443+2","v":2},{"$f":"((-0.0333)*A444)+1","v":{"v":0.9334,"d":"0.933"}}]
[4,{"v":0.8668,"d":"0.867"}]
[6,{"v":0.8002,"d":"0.800"}]
[8,{"v":0.7336,"d":"0.734"}]
[10,0.667]
[11,{"v":0.6336999999999999,"d":"0.634"}]
[12,{"v":0.6003999999999999,"d":"0.600"}]
[13,{"v":0.5670999999999999,"d":"0.567"}]
[14,{"v":0.5337999999999999,"d":"0.534"}]
[15,{"v":0.5005,"d":"0.501"}]
[16,{"v":0.46719999999999995,"d":"0.467"}]
[18,{"v":0.40059999999999996,"d":"0.401"}]
[20,{"v":0.33399999999999996,"d":"0.334"}]
[22,{"v":0.26739999999999997,"d":"0.267"}]
[24,{"v":0.20079999999999987,"d":"0.201"}]
[26,{"v":0.13419999999999987,"d":"0.134"}]
[27,{"v":0.10089999999999988,"d":"0.101"}]
[28,{"v":0.06759999999999988,"d":"0.068"}]
[29,{"v":0.034299999999999886,"d":"0.034"}]
[30,{"v":9.9999999999988987E-4,"d":"0.001"}]
[]
[]
["nº de indicador:",95,"función de transformación:","CA=(0,015*I)-0,45","30<I<50"]
["Indicador:","calidad del agua: oxígeno disuelto",null,"CA=(0,02*I)-0,7","50<I<70"]
["fórmula del indicador",null,null,"CA=0,01*I","70<I<100"]
["unidad del indicador:","% saturación"]
["rango de valores del indicador:","30 - 100","valor del indicador",40]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D470<30,\"valor del indicador fuera de rango\",IF(D470<=50,(0.015*D470)-0.45,IF(D470<=70,(0.02*D470)-0.7,IF(D470<=100,0.01*D470,\"valor del indicador fuera rango\"))))","v":{"v":0.14999999999999997,"d":"0.150"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[30,{"$f":"(0.015*A473)-0.45","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A473+3.5","v":33.5},{"v":0.052499999999999936,"d":"0.052"}]
[{"$f":"+A474+3.5","v":37},{"v":0.10499999999999993,"d":"0.105"}]
[40.5,{"v":0.15749999999999992,"d":"0.158"}]
[44,{"v":0.2099999999999999,"d":"0.210"}]
[47.5,{"v":0.2625,"d":"0.263"}]
[51,{"$f":"(0.02*A479)-0.7","v":{"v":0.32000000000000006,"d":"0.320"}}]
[54.5,{"v":0.3900000000000001,"d":"0.390"}]
[58,{"v":0.45999999999999996,"d":"0.460"}]
[61.5,{"v":0.53,"d":"0.530"}]
[65,{"v":0.6000000000000001,"d":"0.600"}]
[68.5,{"v":0.6700000000000002,"d":"0.670"}]
[72,{"$f":"0.01*A485","v":{"v":0.72,"d":"0.720"}}]
[75.5,0.755]
[79,{"v":0.79,"d":"0.790"}]
[82.5,{"v":0.8250000000000001,"d":"0.825"}]
[86,{"v":0.86,"d":"0.860"}]
[89.5,0.895]
[93,{"v":0.93,"d":"0.930"}]
[96.5,0.965]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",96,"función de transformación:","CA=(-0,1*I) + 1","0<I<3"]
["Indicador:","Calidad del agua: demanda bioquímica de O2 (DBO)",null,"CA=(-0,2*I) + 1,3","3<I<5"]
["fórmula del indicador",null,null,"CA=(-0,15*I) + 1,05","5<x<7"]
["unidad del indicador:","mg I-1 O2"]
["rango de valores del indicador:","0 - 7","valor del indicador",6]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D500<0,\"valor del indicador fuera de rango\",IF(D500<=3,-0.1*D500+1,IF(D500<=5,-0.2*D500+1.3,IF(D500<=7,-0.15*D500+1.05,\"valor del indicador fuera rango\"))))","v":{"v":0.15000000000000013,"d":"0.150"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"(-0.1*A503)+1","v":{"v":1,"d":"1.000"}}]
[0.5,{"v":0.95,"d":"0.950"}]
[{"v":1,"d":"1.0"},{"v":0.9,"d":"0.900"}]
[1.5,{"v":0.85,"d":"0.850"}]
[{"v":2,"d":"2.0"},{"v":0.8,"d":"0.800"}]
[2.5,{"v":0.75,"d":"0.750"}]
[{"v":3,"d":"3.0"},{"$f":"(-0.2*A509)+1.3","v":{"v":0.7,"d":"0.700"}}]
[{"$f":"+A509+0.3","v":3.3},{"$f":"(-0.2*A510)+1.3","v":{"v":0.64,"d":"0.640"}}]
[{"v":3.5999999999999996,"d":"3.6"},{"v":0.5800000000000001,"d":"0.580"}]
[{"v":3.8999999999999995,"d":"3.9"},{"v":0.5200000000000001,"d":"0.520"}]
[{"v":4.199999999999999,"d":"4.2"},{"v":0.4600000000000002,"d":"0.460"}]
[{"v":4.499999999999999,"d":"4.5"},{"v":0.40000000000000013,"d":"0.400"}]
[{"v":4.799999999999999,"d":"4.8"},{"v":0.3400000000000002,"d":"0.340"}]
[{"v":5.099999999999999,"d":"5.1"},{"$f":"(-0.15*A516)+1.05","v":{"v":0.28500000000000025,"d":"0.285"}}]
[{"v":5.399999999999999,"d":"5.4"},{"v":0.24000000000000032,"d":"0.240"}]
[{"v":5.699999999999998,"d":"5.7"},{"v":0.19500000000000028,"d":"0.195"}]
[{"v":5.999999999999998,"d":"6.0"},{"v":0.15000000000000036,"d":"0.150"}]
[{"v":6.299999999999998,"d":"6.3"},{"v":0.10500000000000043,"d":"0.105"}]
[{"v":6.599999999999998,"d":"6.6"},{"v":0.060000000000000386,"d":"0.060"}]
[{"v":6.899999999999998,"d":"6.9"},{"v":0.015000000000000346,"d":"0.015"}]
[{"v":7,"d":"7.0"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",97,"función de transformación:","CA=(-0,006*I) + 1","0<I<50"]
["Indicador:","Calidad del agua: concentración de coliformes totales",null,"CA=(-0,0000808*I) + 0,704","50<I<5000"]
["fórmula del indicador",null,null,"CA=(-0,00000667*I) + 0,333","5000<x<50000"]
["unidad del indicador:","Nº / 100ml (a 37ºC)"]
["rango de valores del indicador:","0 - 50000","valor del indicador",500]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D530<0,\"valor del indicador fuera de rango\",IF(D530<=50,-0.006*D530+1,IF(D530<=5000,-0.0000808*D530+0.704,IF(D530<=50000,-0.00000667*D530+0.333,\"valor del indicador fuera rango\"))))","v":{"v":0.6636,"d":"0.664"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.006*A533)+1","v":{"v":1,"d":"1.000"}}]
[10,{"v":0.94,"d":"0.940"}]
[20,{"v":0.88,"d":"0.880"}]
[30,{"v":0.8200000000000001,"d":"0.820"}]
[40,{"v":0.76,"d":"0.760"}]
[50,{"v":0.7,"d":"0.700"}]
[500,{"$f":"(-0.0000808*A539)+0.704","v":{"v":0.6636,"d":"0.664"}}]
[1000,{"v":0.6232,"d":"0.623"}]
[1500,{"v":0.5828,"d":"0.583"}]
[2000,{"v":0.5424,"d":"0.542"}]
[2500,0.502]
[3000,{"v":0.46159999999999995,"d":"0.462"}]
[3500,{"v":0.42119999999999996,"d":"0.421"}]
[4000,{"v":0.38079999999999997,"d":"0.381"}]
[4500,{"v":0.3404,"d":"0.340"}]
[5000,{"v":0.3,"d":"0.300"}]
[10000,{"$f":"(-0.00000667*A549)+0.333","v":{"v":0.26630000000000004,"d":"0.266"}}]
[20000,{"$f":"(-0.00000667*A550)+0.333","v":{"v":0.19960000000000003,"d":"0.200"}}]
[30000,{"$f":"(-0.00000667*A551)+0.333","v":{"v":0.13290000000000002,"d":"0.133"}}]
[40000,{"$f":"(-0.00000667*A552)+0.333","v":{"v":0.06620000000000004,"d":"0.066"}}]
[50000,{"$f":"(-0.00000667*A553)+0.333","v":{"v":-4.9999999999994493E-4,"d":"-0.000"}}]
[]
[]
["nº de indicador:",98,"función de transformación:","CA=(-0,015*I) + 1","0<I<20"]
["Indicador:","Calidad del agua: concentración de coliformes fecales",null,"CA=(-0,000202*I) + 0,704","20<I<2000"]
["fórmula del indicador",null,null,"CA=(-0,0000167*I) + 0,333","2000<x<20000"]
["unidad del indicador:","Nº / 100ml"]
["rango de valores del indicador:","0 - 20000","valor del indicador",50]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D560<0,\"valor del indicador fuera de rango\",IF(D560<=20,-0.015*D560+1,IF(D560<=2000,-0.000202*D560+0.704,IF(D560<=20000,-0.0000167*D560+0.333,\"valor del indicador fuera rango\"))))","v":{"v":0.6939,"d":"0.694"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.015*A563)+1","v":{"v":1,"d":"1.000"}}]
[5,{"$f":"(-0.015*A564)+1","v":0.925}]
[10,{"$f":"(-0.015*A565)+1","v":{"v":0.85,"d":"0.850"}}]
[15,{"$f":"(-0.015*A566)+1","v":0.775}]
[20,{"$f":"(-0.015*A567)+1","v":{"v":0.7,"d":"0.700"}}]
[50,{"$f":"(-0.000202*A568)+0.704","v":{"v":0.6939,"d":"0.694"}}]
[{"$f":"+A568+200","v":250},{"$f":"(-0.000202*A569)+0.704","v":{"v":0.6535,"d":"0.654"}}]
[{"$f":"+A569+200","v":450},{"v":0.6131,"d":"0.613"}]
[650,{"v":0.5727,"d":"0.573"}]
[850,{"v":0.5323,"d":"0.532"}]
[1050,{"v":0.49189999999999995,"d":"0.492"}]
[1250,{"v":0.45149999999999996,"d":"0.452"}]
[1450,{"v":0.41109999999999997,"d":"0.411"}]
[1650,{"v":0.3707,"d":"0.371"}]
[1850,{"v":0.3302999999999999,"d":"0.330"}]
[2000,{"v":0.29999999999999993,"d":"0.300"}]
[2000,{"$f":"(-0.0000167*A579)+0.333","v":{"v":0.29960000000000003,"d":"0.300"}}]
[{"$f":"+A579+4000","v":6000},{"$f":"(-0.0000167*A580)+0.333","v":{"v":0.2328,"d":"0.233"}}]
[{"$f":"+A580+4000","v":10000},{"$f":"(-0.0000167*A581)+0.333","v":{"v":0.16600000000000004,"d":"0.166"}}]
[{"$f":"+A581+4000","v":14000},{"$f":"(-0.0000167*A582)+0.333","v":{"v":0.09920000000000004,"d":"0.099"}}]
[20000,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",99,"función de transformación:","CA=(-0,015*I) + 1","0<I<20"]
["Indicador:","Calidad del agua: concentración de coliformes fecales",null,"CA=(-0,000408*I) + 0,708","20<I<1000"]
["fórmula del indicador",null,null,"CA=(-0,0000333*I) + 0,33","1000<x<10000"]
["unidad del indicador:","Nº / 100ml"]
["rango de valores del indicador:","0 - 10000","valor del indicador",3000]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D590<0,\"valor del indicador fuera de rango\",IF(D590<=20,-0.015*D590+1,IF(D590<=1000,-0.000408*D590+0.708,IF(D590<=10000,-0.0000333*D590+0.33,\"valor del indicador fuera rango\"))))","v":{"v":0.23010000000000003,"d":"0.230"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.015*A593)+1","v":{"v":1,"d":"1.000"}}]
[5,{"$f":"(-0.015*A594)+1","v":0.925}]
[10,{"$f":"(-0.015*A595)+1","v":{"v":0.85,"d":"0.850"}}]
[15,{"$f":"(-0.015*A596)+1","v":0.775}]
[20,{"$f":"(-0.015*A597)+1","v":{"v":0.7,"d":"0.700"}}]
[50,{"$f":"(-0.000408*A598)+0.708","v":{"v":0.6876,"d":"0.688"}}]
[{"$f":"+A598+100","v":150},{"v":0.6467999999999999,"d":"0.647"}]
[{"$f":"+A599+100","v":250},0.606]
[350,{"v":0.5651999999999999,"d":"0.565"}]
[450,{"v":0.5244,"d":"0.524"}]
[550,{"v":0.4836,"d":"0.484"}]
[650,{"v":0.44279999999999997,"d":"0.443"}]
[750,{"v":0.40199999999999997,"d":"0.402"}]
[850,{"v":0.36119999999999997,"d":"0.361"}]
[950,{"v":0.32039999999999996,"d":"0.320"}]
[1000,{"v":0.3,"d":"0.300"}]
[2000,{"$f":"(-0.0000333*A609)+0.33","v":{"v":0.2634,"d":"0.263"}}]
[{"$f":"+A609+2000","v":4000},{"$f":"(-0.0000333*A610)+0.33","v":{"v":0.1968,"d":"0.197"}}]
[{"$f":"+A610+2000","v":6000},{"$f":"(-0.0000333*A611)+0.33","v":{"v":0.1302,"d":"0.130"}}]
[{"$f":"+A611+2000","v":8000},{"$f":"(-0.0000333*A612)+0.33","v":{"v":0.06359999999999999,"d":"0.064"}}]
[{"$f":"+A612+2000","v":10000},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",100,"función de transformación:","CA=0,0007*I","0<I<1000"]
["Indicador:","Calidad del agua: concentración de salmonelas",null,"CA=(0,000075*I)+0,625","1000<I<3000"]
["fórmula del indicador"]
["unidad del indicador:","Nº / 100ml"]
["rango de valores del indicador:","0 - 3000","valor del indicador",1200]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D620<0,\"valor del indicador fuera de rango\",IF(D620<=1000,0.0007*D620,IF(D620<=3000,0.000075*D620+0.625,\"valor del indicador fuera rango\")))","v":0.715}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0007*A623","v":{"v":0,"d":"0.000"}}]
[100,{"v":0.06999999999999999,"d":"0.070"}]
[200,{"v":0.13999999999999999,"d":"0.140"}]
[300,{"v":0.21,"d":"0.210"}]
[{"$f":"+A626+100","v":400},{"v":0.27999999999999997,"d":"0.280"}]
[{"$f":"+A627+100","v":500},{"v":0.35,"d":"0.350"}]
[600,{"v":0.42,"d":"0.420"}]
[700,{"v":0.49,"d":"0.490"}]
[800,{"v":0.5599999999999999,"d":"0.560"}]
[900,{"v":0.63,"d":"0.630"}]
[1000,{"v":0.7,"d":"0.700"}]
[1200,{"$f":"(0.000075*A634)+0.625","v":0.715}]
[{"$f":"+A634+200","v":1400},{"v":0.73,"d":"0.730"}]
[{"$f":"+A635+200","v":1600},0.745]
[1800,{"v":0.76,"d":"0.760"}]
[2000,0.775]
[2200,{"v":0.79,"d":"0.790"}]
[2400,{"v":0.8049999999999999,"d":"0.805"}]
[2600,{"v":0.82,"d":"0.820"}]
[2800,0.835]
[3000,{"v":0.85,"d":"0.850"}]
[]
[]
["nº de indicador:",101,"función de transformación:","CA=(-1,5*I) + 1","0<I<0,2"]
["Indicador:","Calidad del agua: concentración de detergentes",null,"CA=(-2,33*I)+1,170","0,2<I<0,5"]
["fórmula del indicador"]
["unidad del indicador:","mg ml-1 de laurilsulfato"]
["rango de valores del indicador:","0 - 0,5","valor del indicador",0.05]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D650<0,\"valor del indicador fuera de rango\",IF(D650<=0.2,(-1.5*D650)+1,IF(D650<=0.5,(-2.33*(D650))+1.17,\"valor del indicador fuera rango\")))","v":0.925}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-1.5*(A653)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A653+0.025","v":{"v":0.025,"d":"0.03"}},{"v":0.9625,"d":"0.963"}]
[{"$f":"+A654+0.025","v":0.05},0.925]
[{"v":0.07500000000000001,"d":"0.08"},{"v":0.8875,"d":"0.888"}]
[{"v":0.1,"d":"0.10"},{"v":0.85,"d":"0.850"}]
[{"v":0.125,"d":"0.13"},{"v":0.8125,"d":"0.813"}]
[0.15,0.775]
[{"v":0.175,"d":"0.18"},{"v":0.7375,"d":"0.738"}]
[{"v":0.19999999999999998,"d":"0.20"},{"v":0.7,"d":"0.700"}]
[{"v":0.22499999999999998,"d":"0.23"},{"$f":"-2.33*A662+1.17","v":{"v":0.6457499999999999,"d":"0.646"}}]
[{"v":0.24999999999999997,"d":"0.25"},{"v":0.5875,"d":"0.588"}]
[{"v":0.27499999999999997,"d":"0.28"},{"v":0.52925,"d":"0.529"}]
[{"v":0.3,"d":"0.30"},0.471]
[{"v":0.325,"d":"0.33"},{"v":0.41274999999999984,"d":"0.413"}]
[{"v":0.35000000000000003,"d":"0.35"},{"v":0.3544999999999998,"d":"0.355"}]
[{"v":0.37500000000000006,"d":"0.38"},{"v":0.2962499999999998,"d":"0.296"}]
[{"v":0.4000000000000001,"d":"0.40"},{"v":0.23799999999999977,"d":"0.238"}]
[{"v":0.4250000000000001,"d":"0.43"},{"v":0.17974999999999963,"d":"0.180"}]
[{"v":0.4500000000000001,"d":"0.45"},{"v":0.12149999999999972,"d":"0.122"}]
[{"v":0.47500000000000014,"d":"0.48"},{"v":0.06324999999999958,"d":"0.063"}]
[{"v":0.5000000000000001,"d":"0.50"},{"v":0.004999999999999671,"d":"0.005"}]
[]
[]
["nº de indicador:",102,"función de transformación:","CA=(-0,3*I) + 1","0<I<1"]
["Indicador:","Calidad del agua: concentración de nitrógeno Khedjal",null,"CA=(0,4*I) + 1,1","1<I<2"]
["fórmula del indicador",null,null,"CA=(0,3*I) + 0,9","2<I<3"]
["unidad del indicador:","mgN l-1"]
["rango de valores del indicador:","0 - 3","valor del indicador",2.5]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D680<0,\"valor del indicador fuera de rango\",IF(D680<1,-0.3*(D680)+1,IF(D680<=2,-0.4*(D680)+1.1,IF(D680<=3,-0.3*(D680)+0.9,\"valor fuera de 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.3*(A683)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A683+0.15","v":0.15},0.955]
[{"$f":"+A684+0.15","v":{"v":0.3,"d":"0.30"}},{"v":0.91,"d":"0.910"}]
[{"v":0.44999999999999996,"d":"0.45"},0.865]
[{"v":0.6,"d":"0.60"},{"v":0.8200000000000001,"d":"0.820"}]
[0.75,0.775]
[{"v":0.9,"d":"0.90"},{"v":0.73,"d":"0.730"}]
[1.05,{"$f":"-0.4*A690+1.1","v":{"v":0.68,"d":"0.680"}}]
[{"v":1.2,"d":"1.20"},{"v":0.6200000000000001,"d":"0.620"}]
[{"v":1.3499999999999999,"d":"1.35"},{"v":0.5600000000000002,"d":"0.560"}]
[{"v":1.4999999999999998,"d":"1.50"},{"v":0.5000000000000001,"d":"0.500"}]
[{"v":1.6499999999999997,"d":"1.65"},{"v":0.44000000000000017,"d":"0.440"}]
[{"v":1.7999999999999996,"d":"1.80"},{"v":0.3800000000000002,"d":"0.380"}]
[{"v":1.9499999999999995,"d":"1.95"},{"v":0.3200000000000003,"d":"0.320"}]
[{"v":2.0999999999999996,"d":"2.10"},{"$f":"-0.3*A697+0.9","v":{"v":0.27000000000000013,"d":"0.270"}}]
[{"v":2.2499999999999996,"d":"2.25"},{"v":0.2250000000000002,"d":"0.225"}]
[{"v":2.3999999999999995,"d":"2.40"},{"v":0.18000000000000016,"d":"0.180"}]
[{"v":2.5499999999999994,"d":"2.55"},{"v":0.13500000000000023,"d":"0.135"}]
[{"v":2.6999999999999993,"d":"2.70"},{"v":0.0900000000000003,"d":"0.090"}]
[{"v":2.849999999999999,"d":"2.85"},{"v":0.04500000000000026,"d":"0.045"}]
[{"v":2.999999999999999,"d":"3.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",103,"función de transformación:","CA=(-6*I) + 1","0<I<0,05"]
["Indicador:","Calidad del agua: concentración deamoniaco",null,"CA=(-0,276*I) + 0,714","0,05<I<1,5"]
["fórmula del indicador",null,null,"CA=(0,12*I) + 0,48","1,5<I<4"]
["unidad del indicador:","mgNH4 l-1"]
["rango de valores del indicador:","0 - 4","valor del indicador",1.3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D710<0,\"valor del indicador fuera de rango\",IF(D710<=0.05,-6*(D710)+1,IF(D710<=1.5,-0.276*(D710)+0.714,IF(D710<=4,-0.12*(D710)+0.48,\"valor fuera de rango\"))))","v":{"v":0.3551999999999999,"d":"0.355"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-6*(A713)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A713+0.01","v":0.01},{"v":0.94,"d":"0.940"}]
[{"$f":"+A714+0.01","v":0.02},{"v":0.88,"d":"0.880"}]
[{"$f":"+A715+0.01","v":0.03},{"v":0.8200000000000001,"d":"0.820"}]
[{"$f":"+A716+0.01","v":0.04},{"v":0.76,"d":"0.760"}]
[{"$f":"+A717+0.01","v":0.05},{"v":0.7,"d":"0.700"}]
[{"v":0.1,"d":"0.10"},{"$f":"-0.276*A719+0.714","v":{"v":0.6864,"d":"0.686"}}]
[{"$f":"+A719+0.2","v":{"v":0.30000000000000004,"d":"0.30"}},{"v":0.6312,"d":"0.631"}]
[{"v":0.5,"d":"0.50"},0.576]
[{"v":0.7,"d":"0.70"},{"v":0.5207999999999999,"d":"0.521"}]
[{"v":0.8999999999999999,"d":"0.90"},{"v":0.46559999999999996,"d":"0.466"}]
[{"v":1.0999999999999999,"d":"1.10"},{"v":0.4104,"d":"0.410"}]
[{"v":1.2999999999999998,"d":"1.30"},{"v":0.35519999999999996,"d":"0.355"}]
[{"v":1.4999999999999998,"d":"1.50"},{"v":0.3,"d":"0.300"}]
[{"v":2,"d":"2.00"},{"$f":"-0.12*A727+0.48","v":{"v":0.24,"d":"0.240"}}]
[{"$f":"+A727+0.3","v":{"v":2.3,"d":"2.30"}},{"v":0.20400000000000001,"d":"0.204"}]
[{"$f":"+A728+0.3","v":{"v":2.5999999999999996,"d":"2.60"}},{"v":0.16800000000000004,"d":"0.168"}]
[{"$f":"+A729+0.3","v":{"v":2.8999999999999995,"d":"2.90"}},{"v":0.13200000000000006,"d":"0.132"}]
[{"$f":"+A730+0.3","v":{"v":3.1999999999999993,"d":"3.20"}},{"v":0.09600000000000009,"d":"0.096"}]
[{"$f":"+A731+0.3","v":{"v":3.499999999999999,"d":"3.50"}},{"v":0.06000000000000011,"d":"0.060"}]
[{"v":4,"d":"4.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",104,"función de transformación:","CA=(-30*I) + 1","0<I<0,01"]
["Indicador:","Calidad del agua: concentración de sustancias extraibles con cloroformo",null,"CA=(-2,11*I) + 0,721","0,01<I<0,2"]
["fórmula del indicador",null,null,"CA=-1*I + 0,5","0,2<I<0,5"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 0,5","valor del indicador",0.01]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D740<0,\"valor del indicador fuera de rango\",IF(D740<=0.01,-30*(D740)+1,IF(D740<=0.2,-2.11*(D740)+0.721,IF(D740<=0.5,-1*(D740)+0.5,\"valor fuera de rango\"))))","v":{"v":0.7,"d":"0.700"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.000"},{"$f":"-30*(A743)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A743+0.002","v":{"v":2E-3,"d":"0.002"}},{"v":0.94,"d":"0.940"}]
[{"$f":"+A744+0.002","v":0.004},{"v":0.88,"d":"0.880"}]
[{"$f":"+A745+0.002","v":0.006},{"v":0.8200000000000001,"d":"0.820"}]
[{"$f":"+A746+0.002","v":0.008},{"v":0.76,"d":"0.760"}]
[{"$f":"+A747+0.002","v":{"v":0.01,"d":"0.010"}},{"v":0.7,"d":"0.700"}]
[{"$f":"+A748+0.025","v":0.035},{"$f":"-2.11*A749+0.721","v":{"v":0.64715,"d":"0.647"}}]
[{"$f":"+A749+0.025","v":{"v":0.060000000000000005,"d":"0.060"}},{"v":0.5944,"d":"0.594"}]
[0.085,{"v":0.54165,"d":"0.542"}]
[{"v":0.11000000000000001,"d":"0.110"},{"v":0.48889999999999995,"d":"0.489"}]
[0.135,{"v":0.43615,"d":"0.436"}]
[{"v":0.16,"d":"0.160"},{"v":0.38339999999999996,"d":"0.383"}]
[0.185,{"v":0.33065,"d":"0.331"}]
[{"v":0.2,"d":"0.200"},0.299]
[{"v":0.2,"d":"0.200"},{"$f":"-1*A757+0.5","v":{"v":0.3,"d":"0.300"}}]
[{"v":0.25,"d":"0.250"},{"v":0.25,"d":"0.250"}]
[{"v":0.3,"d":"0.300"},{"v":0.2,"d":"0.200"}]
[{"v":0.35,"d":"0.350"},{"v":0.15000000000000002,"d":"0.150"}]
[{"v":0.4,"d":"0.400"},{"v":0.09999999999999998,"d":"0.100"}]
[{"v":0.45,"d":"0.450"},{"v":0.04999999999999999,"d":"0.050"}]
[{"v":0.5,"d":"0.500"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",105,"función de transformación:","CA=(-0,75*I) + 1","0<I<0,4"]
["Indicador:","Calidad del agua: concentración de fosfatos",null,"CA=(-2,33*I) + 1,630","0,4<I<0,7"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 0,7","valor del indicador",0.14]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D770<0,\"valor del indicador fuera de rango\",IF(D770<=0.4,-0.75*(D770)+1,IF(D770<=0.7,-2.33*(D770)+1.63,\"valor fuera de rango\")))","v":0.895}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.75*(A773)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A773+0.035","v":{"v":0.035,"d":"0.04"}},{"v":0.97375,"d":"0.974"}]
[{"$f":"+A774+0.035","v":0.07},{"v":0.9475,"d":"0.948"}]
[{"v":0.10500000000000001,"d":"0.11"},{"v":0.92125,"d":"0.921"}]
[0.14,0.895]
[{"v":0.17500000000000002,"d":"0.18"},{"v":0.86875,"d":"0.869"}]
[{"v":0.21000000000000002,"d":"0.21"},{"v":0.8425,"d":"0.843"}]
[{"v":0.24500000000000002,"d":"0.25"},{"v":0.8162499999999999,"d":"0.816"}]
[0.28,{"v":0.79,"d":"0.790"}]
[{"v":0.31500000000000006,"d":"0.32"},{"v":0.7637499999999999,"d":"0.764"}]
[{"v":0.3500000000000001,"d":"0.35"},{"v":0.7374999999999999,"d":"0.738"}]
[{"v":0.3850000000000001,"d":"0.39"},{"v":0.7112499999999999,"d":"0.711"}]
[{"v":0.42000000000000015,"d":"0.42"},{"$f":"-2.33*A785+1.63","v":{"v":0.6513999999999995,"d":"0.651"}}]
[{"v":0.4550000000000002,"d":"0.46"},{"v":0.5698499999999995,"d":"0.570"}]
[{"v":0.4900000000000002,"d":"0.49"},{"v":0.4882999999999993,"d":"0.488"}]
[{"v":0.5250000000000002,"d":"0.53"},{"v":0.4067499999999993,"d":"0.407"}]
[{"v":0.5600000000000003,"d":"0.56"},{"v":0.32519999999999927,"d":"0.325"}]
[{"v":0.5950000000000003,"d":"0.60"},{"v":0.24364999999999903,"d":"0.244"}]
[{"v":0.6300000000000003,"d":"0.63"},{"v":0.16209999999999902,"d":"0.162"}]
[{"v":0.6650000000000004,"d":"0.67"},{"v":0.08054999999999901,"d":"0.081"}]
[{"v":0.7000000000000004,"d":"0.70"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",106,"función de transformación:","CA=(-3E02*I)+1","0<I<0,001"]
["Indicador:","Calidad del agua: concentración de fenoles",null,"CA=(-1E02*I)+8E-01","0,001<I<0,005"]
["fórmula del indicador",null,null,"CA=(-3,16*I)+(3,16E-01)","0,005<I<0,1"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 0,1","valor del indicador",0.003]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D800<0,\"valor del indicador fuera de rango\",IF(D800<=0.001,(-300*D800)+1,IF(D800<=0.005,(-100*D800)+0.8,IF(D800<=0.1,(-3.16*D800)+(0.316),IF(D800>0.1,\"valor del indicador fuera rango\")))))","v":{"v":0.5,"d":"0.500"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0000"},{"$f":"(-300*A803)+1","v":{"v":1,"d":"1.000"}}]
[{"v":1E-4,"d":"0.0001"},{"$f":"(-300*A804)+1","v":{"v":0.97,"d":"0.970"}}]
[0.0005,{"$f":"(-300*A805)+1","v":{"v":0.85,"d":"0.850"}}]
[0.0009,{"$f":"(-300*A806)+1","v":{"v":0.73,"d":"0.730"}}]
[{"v":1E-3,"d":"0.001"},{"$f":"(-300*A807)+1","v":{"v":0.7,"d":"0.700"}}]
[{"v":1E-3,"d":"0.001"},{"$f":"-100*A808+(0.8)","v":{"v":0.7000000000000001,"d":"0.700"}}]
[{"$f":"+A808+0.001","v":{"v":2E-3,"d":"0.002"}},{"$f":"-100*A809+(0.8)","v":{"v":0.6000000000000001,"d":"0.600"}}]
[{"$f":"+A809+0.001","v":0.003},{"$f":"-100*A810+(0.8)","v":{"v":0.5,"d":"0.500"}}]
[{"$f":"+A810+0.001","v":0.004},{"$f":"-100*A811+(0.8)","v":{"v":0.4,"d":"0.400"}}]
[{"$f":"+A811+0.001","v":0.005},{"$f":"-100*A812+(0.8)","v":{"v":0.30000000000000004,"d":"0.300"}}]
[0.005,{"$f":"(-3.16*A813)+(0.316)","v":{"v":0.3002,"d":"0.300"}}]
[{"$f":"+A813+0.01","v":0.015},{"v":0.2686,"d":"0.269"}]
[{"$f":"+A814+0.01","v":0.025},0.237]
[0.035,{"v":0.20539999999999997,"d":"0.205"}]
[{"v":0.045000000000000005,"d":"0.045"},{"v":0.17379999999999998,"d":"0.174"}]
[{"v":0.05500000000000001,"d":"0.055"},{"v":0.14219999999999997,"d":"0.142"}]
[0.065,{"v":0.11059999999999998,"d":"0.111"}]
[0.075,{"v":0.07900000000000001,"d":"0.079"}]
[{"v":0.08499999999999999,"d":"0.085"},{"v":0.0474,"d":"0.047"}]
[{"v":0.09499999999999999,"d":"0.095"},{"v":0.015800000000000036,"d":"0.016"}]
[{"v":0.1,"d":"0.100"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",107,"función de transformación:","CA=(-6*I)+1","0<I<0,05"]
["Indicador:","Calidad del agua: concentración de hidrocarburos disueltos o emulsionados",null,"CA=(-2,67*I)+(8,33E-01)","0,05<I<0,2"]
["fórmula del indicador",null,null,"CA=(-3,75E-01*I)+(3,75E-01)","0,2<I<1"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 1","valor del indicador",0.9]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D830<0,\"valor del indicador fuera de rango\",IF(D830<=0.05,(-6*D830)+1,IF(D830<=0.2,(-2.67*D830)+0.833,IF(D830<=1,(-0.375*D830)+0.375,\"valor del indicador fuera rango\"))))","v":{"v":0.03749999999999998,"d":"0.038"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"(-6*A833)+1","v":{"v":1,"d":"1.000"}}]
[0.02,{"$f":"(-6*A834)+1","v":{"v":0.88,"d":"0.880"}}]
[0.04,{"$f":"(-6*A835)+1","v":{"v":0.76,"d":"0.760"}}]
[0.05,{"$f":"(-6*A836)+1","v":{"v":0.7,"d":"0.700"}}]
[0.06,{"$f":"(-2.67*A837)+(0.833)","v":{"v":0.6728,"d":"0.673"}}]
[0.08,{"v":0.6194,"d":"0.619"}]
[{"v":0.1,"d":"0.10"},0.566]
[0.12,{"v":0.5126,"d":"0.513"}]
[0.14,{"v":0.45919999999999994,"d":"0.459"}]
[0.16,{"v":0.40579999999999994,"d":"0.406"}]
[0.18,{"v":0.3524,"d":"0.352"}]
[{"v":0.2,"d":"0.20"},{"v":0.29899999999999993,"d":"0.299"}]
[{"v":0.2,"d":"0.20"},{"$f":"(-0.375*A845)+(0.375)","v":{"v":0.3,"d":"0.300"}}]
[{"$f":"+A845+0.1","v":{"v":0.30000000000000004,"d":"0.30"}},{"v":0.26249999999999996,"d":"0.263"}]
[{"v":0.4,"d":"0.40"},{"v":0.22499999999999998,"d":"0.225"}]
[{"v":0.5,"d":"0.50"},{"v":0.1875,"d":"0.188"}]
[{"v":0.6,"d":"0.60"},{"v":0.15000000000000002,"d":"0.150"}]
[{"v":0.7,"d":"0.70"},{"v":0.11250000000000004,"d":"0.113"}]
[{"v":0.7999999999999999,"d":"0.80"},{"v":0.07500000000000001,"d":"0.075"}]
[{"v":0.8999999999999999,"d":"0.90"},{"v":0.03750000000000003,"d":"0.038"}]
[{"v":0.9999999999999999,"d":"1.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",108,"función de transformación:","CA=(-1,5*I)+1","0<I<0,2"]
["Indicador:","Calidad del agua: concentración de carburos aromáticos policícliocos",null,"CA=(-8,75E-01*I)+(8,75E-01)","0,2<I<1"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 1","valor del indicador",0.9]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D860<0,\"valor del indicador fuera de rango\",IF(D860<=0.2,(-1.5*D860)+1,IF(D860<=1,(0.875*D860)+0.875,\"valor del indicador fuera rango\")))","v":{"v":1.6625,"d":"1.663"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"(-1.5*A863)+1","v":{"v":1,"d":"1.000"}}]
[0.02,{"v":0.97,"d":"0.970"}]
[0.04,{"v":0.94,"d":"0.940"}]
[0.05,0.925]
[0.06,{"v":0.91,"d":"0.910"}]
[0.08,{"v":0.88,"d":"0.880"}]
[{"v":0.1,"d":"0.10"},{"v":0.85,"d":"0.850"}]
[0.12,{"v":0.8200000000000001,"d":"0.820"}]
[0.14,{"v":0.79,"d":"0.790"}]
[0.16,{"v":0.76,"d":"0.760"}]
[0.18,{"v":0.73,"d":"0.730"}]
[{"v":0.2,"d":"0.20"},{"v":0.7,"d":"0.700"}]
[{"v":0.2,"d":"0.20"},{"$f":"(-0.875*A875)+0.875","v":{"v":0.7,"d":"0.700"}}]
[{"$f":"+A875+0.1","v":{"v":0.30000000000000004,"d":"0.30"}},{"v":0.6124999999999999,"d":"0.613"}]
[{"v":0.4,"d":"0.40"},{"v":0.5249999999999999,"d":"0.525"}]
[{"v":0.5,"d":"0.50"},{"v":0.4375,"d":"0.438"}]
[{"v":0.6,"d":"0.60"},{"v":0.35,"d":"0.350"}]
[{"v":0.7,"d":"0.70"},{"v":0.26250000000000007,"d":"0.263"}]
[{"v":0.7999999999999999,"d":"0.80"},{"v":0.17500000000000004,"d":"0.175"}]
[{"v":0.8999999999999999,"d":"0.90"},{"v":0.08750000000000013,"d":"0.088"}]
[{"v":0.9999999999999999,"d":"1.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",109,"función de transformación:","CA=(-2E-02*I)+1","0<I<50"]
["Indicador:","Calidad del agua: concentración de nitratos"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 50","valor del indicador",0.9]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D890<0,\"valor del indicador fuera de rango\",IF(D890<=50,(-0.02*D890)+1,IF(D890>50,\"valor del indicador fuera rango\")))","v":0.982}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.02*A893)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A893+2","v":2},{"v":0.96,"d":"0.960"}]
[5,{"v":0.9,"d":"0.900"}]
[10,{"v":0.8,"d":"0.800"}]
[15,{"v":0.7,"d":"0.700"}]
[20,{"v":0.6,"d":"0.600"}]
[{"$f":"+A898+2","v":22},{"v":0.56,"d":"0.560"}]
[24,{"v":0.52,"d":"0.520"}]
[26,{"v":0.48,"d":"0.480"}]
[28,{"v":0.43999999999999995,"d":"0.440"}]
[30,{"v":0.4,"d":"0.400"}]
[32,{"v":0.36,"d":"0.360"}]
[34,{"v":0.31999999999999995,"d":"0.320"}]
[36,{"v":0.28,"d":"0.280"}]
[38,{"v":0.24,"d":"0.240"}]
[40,{"v":0.19999999999999996,"d":"0.200"}]
[42,{"v":0.16000000000000003,"d":"0.160"}]
[44,{"v":0.12,"d":"0.120"}]
[46,{"v":0.07999999999999996,"d":"0.080"}]
[48,{"v":0.040000000000000036,"d":"0.040"}]
[50,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",110,"función de transformación:","CA=(-2E-01*I)+1","0<I<1,5"]
["Indicador:","Calidad del agua: concentración de fluoruros",null,"CA=(-3,5*I)+5,95","1,5<I<1,,7"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 1,7","valor del indicador",1.6]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D920<0,\"valor del indicador fuera de rango\",IF(D920<=1.5,(-0.2*D920)+1,IF(D920<=1.7,(-3.5*D920)+5.95,\"valor del indicador fuera rango\")))","v":{"v":0.34999999999999964,"d":"0.350"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.000"},{"$f":"(-0.2*A923)+1","v":{"v":1,"d":"1.000"}}]
[{"v":0.1,"d":"0.100"},{"v":0.98,"d":"0.980"}]
[{"v":0.2,"d":"0.200"},{"v":0.96,"d":"0.960"}]
[{"v":0.3,"d":"0.300"},{"v":0.94,"d":"0.940"}]
[{"v":0.4,"d":"0.400"},{"v":0.9199999999999999,"d":"0.920"}]
[{"v":0.5,"d":"0.500"},{"v":0.9,"d":"0.900"}]
[{"v":0.6,"d":"0.600"},{"v":0.88,"d":"0.880"}]
[{"$f":"+A929+0.1","v":{"v":0.7,"d":"0.700"}},{"v":0.86,"d":"0.860"}]
[{"$f":"+A930+0.1","v":{"v":0.7999999999999999,"d":"0.800"}},{"v":0.84,"d":"0.840"}]
[{"v":0.8999999999999999,"d":"0.900"},{"v":0.8200000000000001,"d":"0.820"}]
[{"v":0.9999999999999999,"d":"1.000"},{"v":0.8,"d":"0.800"}]
[{"v":1.0999999999999999,"d":"1.100"},{"v":0.78,"d":"0.780"}]
[{"v":1.2,"d":"1.200"},{"v":0.76,"d":"0.760"}]
[{"v":1.3,"d":"1.300"},{"v":0.74,"d":"0.740"}]
[{"v":1.4000000000000001,"d":"1.400"},{"v":0.72,"d":"0.720"}]
[{"v":1.5000000000000002,"d":"1.500"},{"v":0.7,"d":"0.700"}]
[{"v":1.5,"d":"1.500"},{"$f":"(-3.5*A939)+5.95","v":{"v":0.7000000000000002,"d":"0.700"}}]
[{"$f":"+A939+0.05","v":{"v":1.55,"d":"1.550"}},{"$f":"(-3.5*A940)+5.95","v":{"v":0.5250000000000004,"d":"0.525"}}]
[{"$f":"+A940+0.05","v":{"v":1.6,"d":"1.600"}},{"$f":"(-3.5*A941)+5.95","v":{"v":0.34999999999999964,"d":"0.350"}}]
[{"$f":"+A941+0.05","v":{"v":1.6500000000000001,"d":"1.650"}},{"$f":"(-3.5*A942)+5.95","v":{"v":0.17499999999999982,"d":"0.175"}}]
[{"$f":"+A942+0.05","v":{"v":1.7000000000000002,"d":"1.700"}},{"$f":"(-3.5*A943)+5.95","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",111,"función de transformación:","CA=-I+1","0<I<0,3"]
["Indicador:","Calidad del agua:concentración de hierro disuelto",null,"CA=(-4,12E-01*I)+(8,24E-01)","0,3<I<2"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 2","valor del indicador",0.8]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D950<0,\"valor del indicador fuera de rango\",IF(D950<=0.3,-D950+1,IF(D950<=2,-0.412*D950+0.824,\"valor del indicador fuera rango\")))","v":{"v":0.49439999999999995,"d":"0.494"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"-A953+1","v":{"v":1,"d":"1.000"}}]
[0.1,{"$f":"-A954+1","v":{"v":0.9,"d":"0.900"}}]
[0.2,{"$f":"-A955+1","v":{"v":0.8,"d":"0.800"}}]
[0.3,{"$f":"-A956+1","v":{"v":0.7,"d":"0.700"}}]
[0.4,{"$f":"-0.412*A957+0.824","v":{"v":0.6592,"d":"0.659"}}]
[0.5,{"$f":"-0.412*A958+0.824","v":0.618}]
[0.6,{"v":0.5768,"d":"0.577"}]
[{"$f":"+A959+0.1","v":0.7},{"v":0.5356,"d":"0.536"}]
[{"$f":"+A960+0.1","v":{"v":0.7999999999999999,"d":"0.8"}},{"v":0.4944,"d":"0.494"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.4532,"d":"0.453"}]
[{"v":0.9999999999999999,"d":"1.0"},{"v":0.41200000000000003,"d":"0.412"}]
[{"v":1.0999999999999999,"d":"1.1"},{"v":0.3708,"d":"0.371"}]
[1.2,{"v":0.3296,"d":"0.330"}]
[1.3,{"v":0.2884,"d":"0.288"}]
[{"v":1.4000000000000001,"d":"1.4"},{"v":0.24719999999999998,"d":"0.247"}]
[{"v":1.5000000000000002,"d":"1.5"},{"v":0.20599999999999985,"d":"0.206"}]
[{"v":1.6000000000000003,"d":"1.6"},{"v":0.16479999999999984,"d":"0.165"}]
[{"v":1.7000000000000004,"d":"1.7"},{"v":0.12359999999999982,"d":"0.124"}]
[{"v":1.8000000000000005,"d":"1.8"},{"v":0.0823999999999998,"d":"0.082"}]
[{"v":1.9000000000000006,"d":"1.9"},{"v":0.04119999999999979,"d":"0.041"}]
[{"v":2.0000000000000004,"d":"2.0"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",112,"función de transformación:","CA=-6*I+1","0<I<0,05"]
["Indicador:","Calidad del agua:concentración de manganeso",null,"CA=-8*I+1,1","0,05<I<0,1"]
["fórmula del indicador",null,null,"CA=-3,33E-01*I+3,33E-0,1","0,1<I<1"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 1","valor del indicador",0.08]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D980<0,\"valor del indicador fuera de rango\",IF(D980<=0.05,-6*D980+1,IF(D980<=0.1,-8*D980+1.1,IF(D980<=1,-0.333*D980+0.333,\"valor del indicador fuera rango\"))))","v":{"v":0.4600000000000001,"d":"0.460"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-6*A983+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A983+0.01","v":0.01},{"v":0.94,"d":"0.940"}]
[{"$f":"+A984+0.01","v":0.02},{"v":0.88,"d":"0.880"}]
[0.03,{"v":0.8200000000000001,"d":"0.820"}]
[0.04,{"v":0.76,"d":"0.760"}]
[0.05,{"v":0.7,"d":"0.700"}]
[{"v":0.060000000000000005,"d":"0.06"},{"$f":"-8*A989+1.1","v":{"v":0.6200000000000001,"d":"0.620"}}]
[0.07,{"$f":"-8*A990+1.1","v":{"v":0.54,"d":"0.540"}}]
[0.08,{"$f":"-8*A991+1.1","v":{"v":0.4600000000000001,"d":"0.460"}}]
[0.09,{"$f":"-8*A992+1.1","v":{"v":0.3800000000000001,"d":"0.380"}}]
[{"v":0.09999999999999999,"d":"0.10"},{"$f":"-8*A993+1.1","v":{"v":0.30000000000000016,"d":"0.300"}}]
[{"v":0.1,"d":"0.10"},{"$f":"-0.333*A994+0.333","v":{"v":0.2997,"d":"0.300"}}]
[{"$f":"+A994+0.1","v":{"v":0.2,"d":"0.20"}},{"v":0.2664,"d":"0.266"}]
[{"v":0.30000000000000004,"d":"0.30"},{"v":0.2331,"d":"0.233"}]
[{"v":0.4,"d":"0.40"},{"v":0.1998,"d":"0.200"}]
[{"v":0.5,"d":"0.50"},{"v":0.1665,"d":"0.167"}]
[{"v":0.6,"d":"0.60"},{"v":0.1332,"d":"0.133"}]
[{"v":0.7,"d":"0.70"},{"v":0.09990000000000002,"d":"0.100"}]
[{"v":0.7999999999999999,"d":"0.80"},{"v":0.06660000000000005,"d":"0.067"}]
[{"v":0.8999999999999999,"d":"0.90"},{"v":0.03330000000000005,"d":"0.033"}]
[{"v":0.9999999999999999,"d":"1.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",113,"función de transformación:","CA=-1,4E01*I+1","0<I<0,05"]
["Indicador:","Calidad del agua:concentración de cobre",null,"CA=-3,16E-01*I+3,16E-01","0,05<I<1"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 1","valor del indicador",0.12]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1010<0,\"valor del indicador fuera de rango\",IF(D1010<=0.05,-14*D1010+1,IF(ID1010<=1,-0.316*D1010+0.316,\"valor del indicador fuera rango\")))","v":{"v":0.27808,"d":"0.278"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-14*A1013+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1013+0.01","v":0.01},{"v":0.86,"d":"0.860"}]
[{"$f":"+A1014+0.01","v":0.02},{"v":0.72,"d":"0.720"}]
[0.03,{"v":0.5800000000000001,"d":"0.580"}]
[0.04,{"v":0.43999999999999995,"d":"0.440"}]
[0.05,{"v":0.29999999999999993,"d":"0.300"}]
[{"v":0.060000000000000005,"d":"0.06"},{"$f":"-0.316*A1019+0.316","v":{"v":0.29704,"d":"0.297"}}]
[0.07,{"v":0.29388000000000003,"d":"0.294"}]
[0.08,{"v":0.29072,"d":"0.291"}]
[0.09,{"v":0.28756,"d":"0.288"}]
[{"v":0.09999999999999999,"d":"0.10"},{"v":0.2844,"d":"0.284"}]
[{"v":0.1,"d":"0.10"},{"v":0.2844,"d":"0.284"}]
[{"$f":"+A1024+0.1","v":{"v":0.2,"d":"0.20"}},{"v":0.2528,"d":"0.253"}]
[{"v":0.30000000000000004,"d":"0.30"},{"v":0.2212,"d":"0.221"}]
[{"v":0.4,"d":"0.40"},{"v":0.1896,"d":"0.190"}]
[{"v":0.5,"d":"0.50"},0.158]
[{"v":0.6,"d":"0.60"},{"v":0.1264,"d":"0.126"}]
[{"v":0.7,"d":"0.70"},{"v":0.09480000000000002,"d":"0.095"}]
[{"v":0.7999999999999999,"d":"0.80"},{"v":0.06320000000000003,"d":"0.063"}]
[{"v":0.8999999999999999,"d":"0.90"},{"v":0.03160000000000002,"d":"0.032"}]
[{"v":0.9999999999999999,"d":"1.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",114,"función de transformación:","CA=-1E-01*I+1","0<I<3"]
["Indicador:","Calidad del agua:concentración de zinc",null,"CA=-3,5E-01*I+1,75","3<I<5"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 5","valor del indicador",3.2]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1040<0,\"valor del indicador fuera de rango\",IF(D1040<=3,-0.1*D1040+1,IF(D1040<=5,-0.35*D1040+1.75,\"valor del indicador fuera rango\")))","v":{"v":0.6300000000000001,"d":"0.630"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.1*A1043+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1043+0.25","v":0.25},0.975]
[{"$f":"+A1044+0.25","v":{"v":0.5,"d":"0.50"}},{"v":0.95,"d":"0.950"}]
[0.75,0.925]
[{"v":1,"d":"1.00"},{"v":0.9,"d":"0.900"}]
[1.25,0.875]
[{"v":1.5,"d":"1.50"},{"v":0.85,"d":"0.850"}]
[1.75,0.825]
[{"v":2,"d":"2.00"},{"v":0.8,"d":"0.800"}]
[2.25,0.775]
[{"v":2.5,"d":"2.50"},{"v":0.75,"d":"0.750"}]
[2.75,0.725]
[{"v":3,"d":"3.00"},{"v":0.7,"d":"0.700"}]
[3.25,{"$f":"-0.35*A1056+1.75","v":{"v":0.6125,"d":"0.613"}}]
[{"v":3.5,"d":"3.50"},{"v":0.5250000000000001,"d":"0.525"}]
[3.75,{"v":0.4375,"d":"0.438"}]
[{"v":4,"d":"4.00"},{"v":0.3500000000000001,"d":"0.350"}]
[4.25,{"v":0.2625000000000002,"d":"0.263"}]
[{"v":4.5,"d":"4.50"},{"v":0.17500000000000004,"d":"0.175"}]
[4.75,{"v":0.08750000000000013,"d":"0.088"}]
[{"v":5,"d":"5.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",115,"función de transformación:","CA=-I+1","0<I<1"]
["Indicador:","Calidad del agua:concentración de boro"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 1","valor del indicador",0.4]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1070<0,\"valor del indicador fuera de rango\",IF(D1070<=1,-D1070+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":"-A1073+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1073+0.05","v":0.05},{"v":0.95,"d":"0.950"}]
[{"$f":"+A1074+0.05","v":{"v":0.1,"d":"0.10"}},{"v":0.9,"d":"0.900"}]
[{"v":0.15000000000000002,"d":"0.15"},{"v":0.85,"d":"0.850"}]
[{"v":0.2,"d":"0.20"},{"v":0.8,"d":"0.800"}]
[0.25,{"v":0.75,"d":"0.750"}]
[{"v":0.3,"d":"0.30"},{"v":0.7,"d":"0.700"}]
[0.35,{"v":0.65,"d":"0.650"}]
[{"v":0.39999999999999997,"d":"0.40"},{"v":0.6000000000000001,"d":"0.600"}]
[{"v":0.44999999999999996,"d":"0.45"},{"v":0.55,"d":"0.550"}]
[{"v":0.49999999999999994,"d":"0.50"},{"v":0.5,"d":"0.500"}]
[{"v":0.5499999999999999,"d":"0.55"},{"v":0.45000000000000007,"d":"0.450"}]
[{"v":0.6,"d":"0.60"},{"v":0.4,"d":"0.400"}]
[0.65,{"v":0.35,"d":"0.350"}]
[{"v":0.7000000000000001,"d":"0.70"},{"v":0.29999999999999993,"d":"0.300"}]
[{"v":0.7500000000000001,"d":"0.75"},{"v":0.2499999999999999,"d":"0.250"}]
[{"v":0.8000000000000002,"d":"0.80"},{"v":0.19999999999999984,"d":"0.200"}]
[{"v":0.8500000000000002,"d":"0.85"},{"v":0.1499999999999998,"d":"0.150"}]
[{"v":0.9000000000000002,"d":"0.90"},{"v":0.09999999999999976,"d":"0.100"}]
[{"v":0.9500000000000003,"d":"0.95"},{"v":0.04999999999999971,"d":"0.050"}]
[{"v":1.0000000000000002,"d":"1.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",116,"función de transformación:","CA=-1,4E01*I+1","0<I<0,05"]
["Indicador:","Calidad del agua:concentración de arsénico",null,"CA=-6*I+6E-01","0,05<I<0,1"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 0,1","valor del indicador",0.07]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1100<0,\"valor del indicador fuera de rango\",IF(D1100<=0.05,-14*D1100+1,IF(D1100<=0.1,-6*D1100+0.6,\"valor del indicador fuera rango\")))","v":{"v":0.17999999999999994,"d":"0.180"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.000"},{"$f":"-14*A1103+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1103+0.005","v":0.005},{"v":0.9299999999999999,"d":"0.930"}]
[{"$f":"+A1104+0.005","v":{"v":0.01,"d":"0.010"}},{"v":0.86,"d":"0.860"}]
[0.015,{"v":0.79,"d":"0.790"}]
[{"v":0.02,"d":"0.020"},{"v":0.72,"d":"0.720"}]
[0.025,{"v":0.6499999999999999,"d":"0.650"}]
[{"v":0.030000000000000002,"d":"0.030"},{"v":0.58,"d":"0.580"}]
[0.035,{"v":0.51,"d":"0.510"}]
[{"v":0.04,"d":"0.040"},{"v":0.43999999999999995,"d":"0.440"}]
[0.045,{"v":0.37,"d":"0.370"}]
[{"v":0.049999999999999996,"d":"0.050"},{"v":0.30000000000000004,"d":"0.300"}]
[{"v":0.05499999999999999,"d":"0.055"},{"$f":"-6*A1114+0.6","v":{"v":0.27,"d":"0.270"}}]
[{"v":0.05999999999999999,"d":"0.060"},{"v":0.24000000000000005,"d":"0.240"}]
[{"v":0.06499999999999999,"d":"0.065"},{"v":0.21000000000000008,"d":"0.210"}]
[{"v":0.06999999999999999,"d":"0.070"},{"v":0.18000000000000005,"d":"0.180"}]
[0.075,{"v":0.15000000000000002,"d":"0.150"}]
[{"v":0.08,"d":"0.080"},{"v":0.12,"d":"0.120"}]
[0.085,{"v":0.08999999999999997,"d":"0.090"}]
[{"v":0.09000000000000001,"d":"0.090"},{"v":0.05999999999999994,"d":"0.060"}]
[{"v":0.09500000000000001,"d":"0.095"},{"v":0.029999999999999916,"d":"0.030"}]
[{"v":0.10000000000000002,"d":"0.100"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",117,"función de transformación:","CA=-2E-01*I+1","0<I<5"]
["Indicador:","Calidad del agua:concentración de cadmio"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1    ( x100 )"]
["rango de valores del indicador:","0 - 5","valor del indicador",1]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1130<0,\"valor del indicador fuera de rango\",IF(D1130<=5,-0.2*D1130+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"]
[{"v":0,"d":"0.00"},{"$f":"-0.2*A1133+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1133+0.25","v":0.25},{"v":0.95,"d":"0.950"}]
[{"$f":"+A1134+0.25","v":{"v":0.5,"d":"0.50"}},{"v":0.9,"d":"0.900"}]
[0.75,{"v":0.85,"d":"0.850"}]
[{"v":1,"d":"1.00"},{"v":0.8,"d":"0.800"}]
[1.25,{"v":0.75,"d":"0.750"}]
[{"v":1.5,"d":"1.50"},{"v":0.7,"d":"0.700"}]
[1.75,{"v":0.6499999999999999,"d":"0.650"}]
[{"v":2,"d":"2.00"},{"v":0.6,"d":"0.600"}]
[2.25,{"v":0.55,"d":"0.550"}]
[{"v":2.5,"d":"2.50"},{"v":0.5,"d":"0.500"}]
[2.75,{"v":0.44999999999999996,"d":"0.450"}]
[{"v":3,"d":"3.00"},{"v":0.3999999999999999,"d":"0.400"}]
[3.25,{"v":0.35,"d":"0.350"}]
[{"v":3.5,"d":"3.50"},{"v":0.29999999999999993,"d":"0.300"}]
[3.75,{"v":0.25,"d":"0.250"}]
[{"v":4,"d":"4.00"},{"v":0.19999999999999996,"d":"0.200"}]
[4.25,{"v":0.1499999999999999,"d":"0.150"}]
[{"v":4.5,"d":"4.50"},{"v":0.09999999999999998,"d":"0.100"}]
[4.75,{"v":0.04999999999999993,"d":"0.050"}]
[{"v":5,"d":"5.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",118,"función de transformación:","CA=-2E-01*I+1","0<I<5"]
["Indicador:","Calidad del agua:concentración de cromo"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1    ( x100 )"]
["rango de valores del indicador:","0 - 5","valor del indicador",1]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1160<0,\"valor del indicador fuera de rango\",IF(D1160<=5,-0.2*D1160+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"]
[{"v":0,"d":"0.00"},{"$f":"-0.2*A1163+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1163+0.25","v":0.25},{"v":0.95,"d":"0.950"}]
[{"$f":"+A1164+0.25","v":{"v":0.5,"d":"0.50"}},{"v":0.9,"d":"0.900"}]
[0.75,{"v":0.85,"d":"0.850"}]
[{"v":1,"d":"1.00"},{"v":0.8,"d":"0.800"}]
[1.25,{"v":0.75,"d":"0.750"}]
[{"v":1.5,"d":"1.50"},{"v":0.7,"d":"0.700"}]
[1.75,{"v":0.6499999999999999,"d":"0.650"}]
[{"v":2,"d":"2.00"},{"v":0.6,"d":"0.600"}]
[2.25,{"v":0.55,"d":"0.550"}]
[{"v":2.5,"d":"2.50"},{"v":0.5,"d":"0.500"}]
[2.75,{"v":0.44999999999999996,"d":"0.450"}]
[{"v":3,"d":"3.00"},{"v":0.3999999999999999,"d":"0.400"}]
[3.25,{"v":0.35,"d":"0.350"}]
[{"v":3.5,"d":"3.50"},{"v":0.29999999999999993,"d":"0.300"}]
[3.75,{"v":0.25,"d":"0.250"}]
[{"v":4,"d":"4.00"},{"v":0.19999999999999996,"d":"0.200"}]
[4.25,{"v":0.1499999999999999,"d":"0.150"}]
[{"v":4.5,"d":"4.50"},{"v":0.09999999999999998,"d":"0.100"}]
[4.75,{"v":0.04999999999999993,"d":"0.050"}]
[{"v":5,"d":"5.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",119,"función de transformación:","CA=-2E-01*I+1","0<I<5"]
["Indicador:","Calidad del agua:concentración de plomo"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1    ( x100 )"]
["rango de valores del indicador:","0 - 5","valor del indicador",1]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1190<0,\"valor del indicador fuera de rango\",IF(D1190<=5,-0.2*D1190+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"]
[{"v":0,"d":"0.00"},{"$f":"-0.2*A1193+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1193+0.25","v":0.25},{"v":0.95,"d":"0.950"}]
[{"$f":"+A1194+0.25","v":{"v":0.5,"d":"0.50"}},{"v":0.9,"d":"0.900"}]
[0.75,{"v":0.85,"d":"0.850"}]
[{"v":1,"d":"1.00"},{"v":0.8,"d":"0.800"}]
[1.25,{"v":0.75,"d":"0.750"}]
[{"v":1.5,"d":"1.50"},{"v":0.7,"d":"0.700"}]
[1.75,{"v":0.6499999999999999,"d":"0.650"}]
[{"v":2,"d":"2.00"},{"v":0.6,"d":"0.600"}]
[2.25,{"v":0.55,"d":"0.550"}]
[{"v":2.5,"d":"2.50"},{"v":0.5,"d":"0.500"}]
[2.75,{"v":0.44999999999999996,"d":"0.450"}]
[{"v":3,"d":"3.00"},{"v":0.3999999999999999,"d":"0.400"}]
[3.25,{"v":0.35,"d":"0.350"}]
[{"v":3.5,"d":"3.50"},{"v":0.29999999999999993,"d":"0.300"}]
[3.75,{"v":0.25,"d":"0.250"}]
[{"v":4,"d":"4.00"},{"v":0.19999999999999996,"d":"0.200"}]
[4.25,{"v":0.1499999999999999,"d":"0.150"}]
[{"v":4.5,"d":"4.50"},{"v":0.09999999999999998,"d":"0.100"}]
[4.75,{"v":0.04999999999999993,"d":"0.050"}]
[{"v":5,"d":"5.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",120,"función de transformación:","CA=-1E02*I+1","0<I<0,01"]
["Indicador:","Calidad del agua:concentración de selenio"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1    ( x100 )"]
["rango de valores del indicador:","0 - 0,01","valor del indicador",2E-3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1220<0,\"valor del indicador fuera de rango\",IF(D1220<=0.01,-100*D1220+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"]
[{"v":0,"d":"0.0000"},{"$f":"-100*A1223+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1223+0.0005","v":0.0005},{"v":0.95,"d":"0.950"}]
[{"$f":"+A1224+0.0005","v":{"v":1E-3,"d":"0.0010"}},{"v":0.9,"d":"0.900"}]
[{"v":1.5E-3,"d":"0.0015"},{"v":0.85,"d":"0.850"}]
[{"v":2E-3,"d":"0.0020"},{"v":0.8,"d":"0.800"}]
[0.0025,{"v":0.75,"d":"0.750"}]
[{"v":0.003,"d":"0.0030"},{"v":0.7,"d":"0.700"}]
[0.0035,{"v":0.6499999999999999,"d":"0.650"}]
[{"v":0.004,"d":"0.0040"},{"v":0.6,"d":"0.600"}]
[{"v":4.5000000000000005E-3,"d":"0.0045"},{"v":0.5499999999999999,"d":"0.550"}]
[{"v":5.000000000000001E-3,"d":"0.0050"},{"v":0.4999999999999999,"d":"0.500"}]
[{"v":0.005500000000000001,"d":"0.0055"},{"v":0.44999999999999984,"d":"0.450"}]
[{"v":0.006000000000000002,"d":"0.0060"},{"v":0.3999999999999998,"d":"0.400"}]
[{"v":0.006500000000000002,"d":"0.0065"},{"v":0.34999999999999976,"d":"0.350"}]
[{"v":0.007000000000000003,"d":"0.0070"},{"v":0.2999999999999997,"d":"0.300"}]
[{"v":0.007500000000000003,"d":"0.0075"},{"v":0.24999999999999967,"d":"0.250"}]
[{"v":0.008000000000000004,"d":"0.0080"},{"v":0.19999999999999962,"d":"0.200"}]
[{"v":0.008500000000000004,"d":"0.0085"},{"v":0.14999999999999958,"d":"0.150"}]
[{"v":0.009000000000000005,"d":"0.0090"},{"v":0.09999999999999953,"d":"0.100"}]
[{"v":9.500000000000005E-3,"d":"0.0095"},{"v":0.04999999999999949,"d":"0.050"}]
[{"v":0.010000000000000005,"d":"0.0100"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",121,"función de transformación:","CA=-3I+1","0<I<0,1"]
["Indicador:","Calidad del agua:concentración de selenio",null,"CA=-7,78E-01I+7,78E-01","0,1<I<1"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 1","valor del indicador",0.3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1250<0,\"valor del indicador fuera de rango\",IF(D1250<=0.1,(-3*D1250+1),IF(D1250<=1,(-0.778*D1250+0.778),\"valor del indicador fuera rango\")))","v":{"v":0.5446,"d":"0.545"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-3*A1253+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1253+0.05","v":0.05},{"$f":"-3*A1254+1","v":{"v":0.85,"d":"0.850"}}]
[{"$f":"+A1254+0.05","v":{"v":0.1,"d":"0.10"}},{"$f":"-3*A1255+1","v":{"v":0.7,"d":"0.700"}}]
[{"v":0.15000000000000002,"d":"0.15"},{"$f":"-0.778*A1256+0.778","v":{"v":0.6613,"d":"0.661"}}]
[{"v":0.2,"d":"0.20"},{"v":0.6224000000000001,"d":"0.622"}]
[0.25,{"v":0.5835,"d":"0.584"}]
[{"v":0.3,"d":"0.30"},{"v":0.5446,"d":"0.545"}]
[0.35,{"v":0.5057,"d":"0.506"}]
[{"v":0.39999999999999997,"d":"0.40"},{"v":0.46680000000000005,"d":"0.467"}]
[{"v":0.44999999999999996,"d":"0.45"},{"v":0.42790000000000006,"d":"0.428"}]
[{"v":0.49999999999999994,"d":"0.50"},{"v":0.38900000000000007,"d":"0.389"}]
[{"v":0.5499999999999999,"d":"0.55"},{"v":0.3501000000000001,"d":"0.350"}]
[{"v":0.6,"d":"0.60"},{"$f":"-0.778*A1265+0.778","v":{"v":0.31120000000000003,"d":"0.311"}}]
[0.65,{"$f":"-0.778*A1266+0.778","v":{"v":0.2723,"d":"0.272"}}]
[{"v":0.7000000000000001,"d":"0.70"},{"$f":"-0.778*A1267+0.778","v":{"v":0.23339999999999994,"d":"0.233"}}]
[{"v":0.7500000000000001,"d":"0.75"},{"v":0.1944999999999999,"d":"0.195"}]
[{"v":0.8000000000000002,"d":"0.80"},{"v":0.15559999999999985,"d":"0.156"}]
[{"v":0.8500000000000002,"d":"0.85"},{"v":0.1166999999999998,"d":"0.117"}]
[{"v":0.9000000000000002,"d":"0.90"},{"v":0.07779999999999976,"d":"0.078"}]
[{"v":0.9500000000000003,"d":"0.95"},{"v":0.038899999999999824,"d":"0.039"}]
[{"v":1.0000000000000002,"d":"1.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",122,"función de transformación:","CA=-2E-01*I+1","0<I<5"]
["Indicador:","Calidad del agua:concentración de cianuros"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1    ( x100 )"]
["rango de valores del indicador:","0 - 5","valor del indicador",1]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1280<0,\"valor del indicador fuera de rango\",IF(D1280<=5,-0.2*D1280+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"]
[{"v":0,"d":"0.00"},{"$f":"-0.2*A1283+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1283+0.25","v":0.25},{"v":0.95,"d":"0.950"}]
[{"$f":"+A1284+0.25","v":{"v":0.5,"d":"0.50"}},{"v":0.9,"d":"0.900"}]
[0.75,{"v":0.85,"d":"0.850"}]
[{"v":1,"d":"1.00"},{"v":0.8,"d":"0.800"}]
[1.25,{"v":0.75,"d":"0.750"}]
[{"v":1.5,"d":"1.50"},{"v":0.7,"d":"0.700"}]
[1.75,{"v":0.6499999999999999,"d":"0.650"}]
[{"v":2,"d":"2.00"},{"v":0.6,"d":"0.600"}]
[2.25,{"v":0.55,"d":"0.550"}]
[{"v":2.5,"d":"2.50"},{"v":0.5,"d":"0.500"}]
[2.75,{"v":0.44999999999999996,"d":"0.450"}]
[{"v":3,"d":"3.00"},{"v":0.3999999999999999,"d":"0.400"}]
[3.25,{"v":0.35,"d":"0.350"}]
[{"v":3.5,"d":"3.50"},{"v":0.29999999999999993,"d":"0.300"}]
[3.75,{"v":0.25,"d":"0.250"}]
[{"v":4,"d":"4.00"},{"v":0.19999999999999996,"d":"0.200"}]
[4.25,{"v":0.1499999999999999,"d":"0.150"}]
[{"v":4.5,"d":"4.50"},{"v":0.09999999999999998,"d":"0.100"}]
[4.75,{"v":0.04999999999999993,"d":"0.050"}]
[{"v":5,"d":"5.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",123,"función de transformación:","CA=-4E-03I+1","0<I<250"]
["Indicador:","Calidad del agua:concentración de sulfatos"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 250","valor del indicador",80]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1310<0,\"valor del indicador fuera de rango\",IF(D1310<=250,-0.004*D1310+1))","v":{"v":0.6799999999999999,"d":"0.680"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.004*A1313+1","v":{"v":1,"d":"1.000"}}]
[10,{"v":0.96,"d":"0.960"}]
[20,{"v":0.92,"d":"0.920"}]
[30,{"v":0.88,"d":"0.880"}]
[40,{"v":0.84,"d":"0.840"}]
[50,{"v":0.8,"d":"0.800"}]
[60,{"v":0.76,"d":"0.760"}]
[70,{"v":0.72,"d":"0.720"}]
[80,{"v":0.6799999999999999,"d":"0.680"}]
[90,{"v":0.64,"d":"0.640"}]
[100,{"v":0.6,"d":"0.600"}]
[{"$f":"+A1323+15","v":115},{"v":0.54,"d":"0.540"}]
[130,{"v":0.48,"d":"0.480"}]
[145,{"v":0.42000000000000004,"d":"0.420"}]
[160,{"v":0.36,"d":"0.360"}]
[175,{"v":0.29999999999999993,"d":"0.300"}]
[190,{"v":0.24,"d":"0.240"}]
[205,{"v":0.17999999999999994,"d":"0.180"}]
[220,{"v":0.12,"d":"0.120"}]
[235,{"v":0.05999999999999994,"d":"0.060"}]
[250,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",124,"función de transformación:","CA=-5E-03I+1","0<I<200"]
["Indicador:","Calidad del agua:concentración de cloruros"]
["fórmula del indicador"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 200","valor del indicador",100]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D1340<0,\"valor del indicador fuera de rango\",IF(D1340<=200,-0.005*D1340+1))","v":{"v":0.5,"d":"0.500"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.005*A1343+1","v":{"v":1,"d":"1.000"}}]
[10,{"v":0.95,"d":"0.950"}]
[20,{"v":0.9,"d":"0.900"}]
[30,{"v":0.85,"d":"0.850"}]
[40,{"v":0.8,"d":"0.800"}]
[50,{"v":0.75,"d":"0.750"}]
[60,{"v":0.7,"d":"0.700"}]
[70,{"v":0.6499999999999999,"d":"0.650"}]
[80,{"v":0.6,"d":"0.600"}]
[90,{"v":0.55,"d":"0.550"}]
[100,{"v":0.5,"d":"0.500"}]
[110,{"v":0.44999999999999996,"d":"0.450"}]
[120,{"v":0.4,"d":"0.400"}]
[130,{"v":0.35,"d":"0.350"}]
[140,{"v":0.29999999999999993,"d":"0.300"}]
[150,{"v":0.25,"d":"0.250"}]
[160,{"v":0.19999999999999996,"d":"0.200"}]
[170,{"v":0.15000000000000002,"d":"0.150"}]
[180,{"v":0.09999999999999998,"d":"0.100"}]
[190,{"v":0.04999999999999993,"d":"0.050"}]
[200,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",125,"función de transformación:","CA=-2,33I+1","0<I<0,15"]
["Indicador:","Indicador semicualitativo de calidad de las aguas",null,"CA=-1,75I+9,13E-01","   0,15<I<0,35"]
["fórmula del indicador",null,null,"CA=-2I+1","0,35<I<0,5"]
["unidad del indicador:","ICC"]
["rango de valores del indicador:","0 - 0,5","valor del indicador",0.4]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D1370<0,\"valor del indicador fuera de rango\",IF(D1370<=0.15,-2.33*D1370+1,IF(D1370<=0.35,-1.75*D1370+0.913,IF(D1370<=0.5,-2*D1370+1))))","v":{"v":0.19999999999999996,"d":"0.200"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-2.33*A1373+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A1373+0.025","v":{"v":0.025,"d":"0.03"}},{"v":0.94175,"d":"0.942"}]
[{"$f":"+A1374+0.025","v":0.05},{"v":0.8835,"d":"0.884"}]
[{"v":0.07500000000000001,"d":"0.08"},{"v":0.8252499999999999,"d":"0.825"}]
[{"v":0.1,"d":"0.10"},0.767]
[{"v":0.125,"d":"0.13"},{"v":0.70875,"d":"0.709"}]
[0.15,{"v":0.6505000000000001,"d":"0.651"}]
[{"v":0.175,"d":"0.18"},{"$f":"-1.75*A1380+0.913","v":{"v":0.6067500000000001,"d":"0.607"}}]
[{"v":0.19999999999999998,"d":"0.20"},{"v":0.5630000000000001,"d":"0.563"}]
[{"v":0.22499999999999998,"d":"0.23"},{"v":0.5192500000000001,"d":"0.519"}]
[{"v":0.24999999999999997,"d":"0.25"},{"v":0.4755000000000001,"d":"0.476"}]
[{"v":0.27499999999999997,"d":"0.28"},{"v":0.4317500000000001,"d":"0.432"}]
[{"v":0.3,"d":"0.30"},0.388]
[{"v":0.325,"d":"0.33"},{"v":0.34425000000000006,"d":"0.344"}]
[{"v":0.35000000000000003,"d":"0.35"},{"v":0.3005,"d":"0.301"}]
[{"$f":"+A1387+0.025","v":{"v":0.37500000000000006,"d":"0.38"}},{"$f":"-2*A1388+1","v":{"v":0.2499999999999999,"d":"0.250"}}]
[{"v":0.4000000000000001,"d":"0.40"},{"v":0.19999999999999984,"d":"0.200"}]
[{"v":0.4250000000000001,"d":"0.43"},{"v":0.1499999999999998,"d":"0.150"}]
[{"$f":"+A1390+0.025","v":{"v":0.4500000000000001,"d":"0.45"}},{"v":0.09999999999999976,"d":"0.100"}]
[{"$f":"+A1391+0.025","v":{"v":0.47500000000000014,"d":"0.48"}},{"v":0.04999999999999971,"d":"0.050"}]
[{"$f":"+A1392+0.025","v":{"v":0.5000000000000001,"d":"0.50"}},{"v":0,"d":"0.000"}]

{"sheet":"126-127","index":4,"n_rows":65,"n_cols":5,"rows_kept":65,"merged":[[6,2,6,4],[39,2,39,4]]}
["nº de indicador:",126,"función de transformación:","CA=1,22E-02I2+2,931E-01I+1,760","  -12<I<-5"]
["Indicador:","Tenperatura media del agua",null,"CA=-2,32E-02I2-4E-02I+9,8E-01","  -5<I<5"]
["fórmula del indicador","tª media-tªmedia \"sin\" proyecto",null,"CA=8E-03I2-1,6E-01I+8E-01","   5<I<10"]
["unidad del indicador:","ºC"]
["rango de valores del indicador:","-12  - 10","valor del indicador",6]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-12,\"valor del indicador fuera de rango\",IF(D5<=-5,0.0122*(D5^2)+(0.2931*D5)+1.76,IF(D5<=5,-0.0232*(D5^2)-(0.04*D5)+0.98,IF(D5<=10,0.008*(D5^2)-(0.16*D5)+(0.8),\"valor del indicador fuera rango\"))))","v":{"v":0.1280000000000001,"d":"0.128"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-12,{"$f":"0.0122*(A8^2)+0.2931*A8+1.76","v":{"v":-0.000400000000000178,"d":"-0.000"}}]
[-11,{"$f":"0.0122*(A9^2)+0.2931*A9+1.76","v":{"v":0.012099999999999778,"d":"0.012"}}]
[-10,{"v":0.04899999999999993,"d":"0.049"}]
[-9,{"v":0.11029999999999984,"d":"0.110"}]
[-8,{"v":0.19599999999999995,"d":"0.196"}]
[-7,{"v":0.3060999999999996,"d":"0.306"}]
[-6,{"v":0.4405999999999999,"d":"0.441"}]
[-5,{"v":0.5994999999999999,"d":"0.600"}]
[-5,{"$f":"-0.0232*A16^2-0.04*A16+0.98","v":{"v":0.6000000000000001,"d":"0.600"}}]
[{"$f":"+A16+1","v":-4},{"v":0.7688,"d":"0.769"}]
[-3,{"v":0.8912,"d":"0.891"}]
[-2,{"v":0.9672,"d":"0.967"}]
[-1,{"v":0.9968,"d":"0.997"}]
[0,{"v":0.98,"d":"0.980"}]
[1,{"v":0.9168,"d":"0.917"}]
[2,{"v":0.8071999999999999,"d":"0.807"}]
[3,{"v":0.6512,"d":"0.651"}]
[5,{"v":0.19999999999999996,"d":"0.200"}]
[5,{"$f":"0.008*A26^2-0.16*A26+0.8","v":{"v":0.19999999999999996,"d":"0.200"}}]
[6,{"v":0.1280000000000001,"d":"0.128"}]
[7,{"v":0.07199999999999995,"d":"0.072"}]
[8,{"v":0.03200000000000003,"d":"0.032"}]
[9,{"v":0.008000000000000118,"d":"0.008"}]
[10,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",127,"función de transformación:","CA=1,22E-02 I2+2,931E-01I+1,760","  -12<I<-5"]
["Indicador:","Tenperatura media del agua según NSF",null,"CA=-1,51E-02I2-2,07E-02I+8,75E-01","  -5<I<4"]
["fórmula del indicador","tª media-tªmedia \"sin\" proyecto",null,"CA=3,33E-03I2-1,13E-01I+9,5E-01","   4<I<15"]
["unidad del indicador:","ºC"]
["rango de valores del indicador:","-12  - 15","valor del indicador",-4]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D38<-12,\"valor del indicador fuera de rango\",IF(D38<=-5,0.0122*(D38^2)+(0.2931*D38)+1.76,IF(D38<=4,(-0.0151*(D38^2))-(0.0207*D38)+0.875,IF(D38<15,0.00333*(D38^2)-(0.113*D38)+0.95,\"valor del indicador fuera de rango\"))))","v":{"v":0.7162,"d":"0.716"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-12,{"$f":"0.0122*(A41^2)+0.2931*A41+1.76","v":{"v":-0.000400000000000178,"d":"-0.000"}}]
[-10,{"$f":"0.0122*(A42^2)+0.2931*A42+1.76","v":{"v":0.04899999999999993,"d":"0.049"}}]
[-8,{"$f":"0.0122*(A43^2)+0.2931*A43+1.76","v":{"v":0.19599999999999995,"d":"0.196"}}]
[-6,{"$f":"0.0122*(A44^2)+0.2931*A44+1.76","v":{"v":0.4405999999999999,"d":"0.441"}}]
[-5,{"$f":"0.0122*(A45^2)+0.2931*A45+1.76","v":{"v":0.5994999999999999,"d":"0.600"}}]
[-5,{"$f":"-0.0151*A46^2-0.0207*A46+0.875","v":0.601}]
[{"$f":"+A46+1","v":-4},{"v":0.7162,"d":"0.716"}]
[{"$f":"+A47+1","v":-3},{"v":0.8012,"d":"0.801"}]
[-2,0.856]
[-1,{"v":0.8806,"d":"0.881"}]
[0,0.875]
[1,{"v":0.8392,"d":"0.839"}]
[2,{"v":0.7732,"d":"0.773"}]
[3,0.677]
[4,{"v":0.5506,"d":"0.551"}]
[4,{"$f":"0.00333*A56^2-0.113*A56+0.95","v":{"v":0.55128,"d":"0.551"}}]
[5,{"v":0.4682499999999999,"d":"0.468"}]
[6,{"v":0.3918799999999999,"d":"0.392"}]
[8,{"v":0.2591199999999999,"d":"0.259"}]
[10,{"v":0.1529999999999998,"d":"0.153"}]
[11,{"v":0.10992999999999986,"d":"0.110"}]
[12,{"v":0.07351999999999981,"d":"0.074"}]
[13,{"v":0.043769999999999865,"d":"0.044"}]
[14,{"v":0.02067999999999992,"d":"0.021"}]
[15,{"v":4.249999999999865E-3,"d":"0.004"}]