{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Registro","56-60","61","62-66","67-75","76-78"],"not_rendered":{"charts":23,"images":15,"external_links":3,"defined_names":11},"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":"56-60","index":1,"n_rows":147,"n_cols":5,"rows_kept":147,"merged":[[6,2,6,4],[32,2,32,4],[62,2,62,4],[93,2,93,4],[124,2,124,4]]}
["nº de indicador:",56,"función de transformación:","CA=(-1E-4*I^2)+(4,17E-4*I)+1","0<I<100"]
["Indicador:","% de superficie alterada del entorno"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 -100","valor del indicador",90]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<=0,\"valor del indicador fuera de rango\",IF(D5<=100,(-0.0001*(D5^2))+(0.000417*D5)+1,\"valor del indicador fuera rango\"))","v":{"v":0.2275299999999999,"d":"0.228"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.0001*(A8^2))+(0.000417*A8)+1","v":{"v":1,"d":"1.000"}}]
[5,{"$f":"(-0.0001*(A9^2))+(0.000417*A9)+1","v":{"v":0.999585,"d":"1.000"}}]
[10,{"v":0.99417,"d":"0.994"}]
[15,{"v":0.983755,"d":"0.984"}]
[20,{"v":0.96834,"d":"0.968"}]
[25,{"v":0.947925,"d":"0.948"}]
[30,{"v":0.9225099999999999,"d":"0.923"}]
[35,{"v":0.892095,"d":"0.892"}]
[40,{"v":0.85668,"d":"0.857"}]
[45,{"v":0.816265,"d":"0.816"}]
[50,{"v":0.77085,"d":"0.771"}]
[55,{"v":0.7204349999999999,"d":"0.720"}]
[60,{"v":0.66502,"d":"0.665"}]
[70,{"v":0.53919,"d":"0.539"}]
[80,{"v":0.39335999999999993,"d":"0.393"}]
[90,{"v":0.2275299999999999,"d":"0.228"}]
[100,{"v":0.04169999999999996,"d":"0.042"}]
[]
[]
["nº de indicador:",57,"función de transformación:","CA= (1E-2*I)","0<I<100"]
["Indicador:","Coeficiente medio de interés del factor topográfico ponderado por la superficie de zonas homogéneas (medio rural)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 -100","valor del indicador",25]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D31<=0,\"valor del indicador fuera de rango\",IF(D31<=100,(0.01*(D31)),\"valor del indicador fuera rango\"))","v":{"v":0.25,"d":"0.250"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.01*A34","v":{"v":0,"d":"0.000"}}]
[5,{"v":0.05,"d":"0.050"}]
[10,{"v":0.1,"d":"0.100"}]
[15,{"v":0.15,"d":"0.150"}]
[20,{"v":0.2,"d":"0.200"}]
[25,{"v":0.25,"d":"0.250"}]
[30,{"v":0.3,"d":"0.300"}]
[35,{"v":0.35000000000000003,"d":"0.350"}]
[40,{"v":0.4,"d":"0.400"}]
[45,{"v":0.45,"d":"0.450"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.55,"d":"0.550"}]
[60,{"v":0.6,"d":"0.600"}]
[65,{"v":0.65,"d":"0.650"}]
[70,{"v":0.7000000000000001,"d":"0.700"}]
[75,{"v":0.75,"d":"0.750"}]
[78,{"v":0.78,"d":"0.780"}]
[80,{"v":0.8,"d":"0.800"}]
[85,{"v":0.85,"d":"0.850"}]
[90,{"v":0.9,"d":"0.900"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",58,"función de transformación:","CA=0","0<I<33"]
["Indicador:","Coeficiente medio de interés del factor topográfico ponderado por la superficie de zonas homogéneas (medio urbano)",null,"CA=( 1,5E-2*I)-(4,99E-0,1)","33<I<100"]
["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(D61<0,\"valor del indicador fuera de rango\",IF(D61<=33,0,IF(D61<=100,(0.015*(D61))-(0.499),\"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","v":{"v":0,"d":"0.000"}}]
[{"$f":"A64+5","v":5},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"$f":"A65+5","v":10},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"$f":"A66+5","v":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.015*A71-0.499","v":{"v":0.026000000000000023,"d":"0.026"}}]
[40,{"$f":"0.015*A72-0.499","v":{"v":0.10099999999999998,"d":"0.101"}}]
[45,{"v":0.17599999999999993,"d":"0.176"}]
[50,0.251]
[55,{"v":0.32599999999999996,"d":"0.326"}]
[60,{"v":0.4009999999999999,"d":"0.401"}]
[65,0.476]
[70,0.551]
[75,0.626]
[80,0.701]
[82,0.731]
[{"$f":"A80+5","v":85},{"v":0.7759999999999999,"d":"0.776"}]
[90,{"v":0.8509999999999999,"d":"0.851"}]
[95,0.926]
[100,1.001]
[]
[]
["nº de indicador:",59,"función de transformación:","CA= (-1E-4*I^2)+(2E-2I)","0<I<100"]
["Indicador:","Coeficiente medio de interés del factor topográfico en relación a la situación \"sin\" proyecto (medio rural). "]
["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(D92<0,\"valor del indicador fuera de rango\",IF(D92<=100,(-0.0001*(D92^2))+(0.02*D92),\"valor del indicador fuera rango\"))","v":{"v":0.64,"d":"0.640"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0001*A95^2+0.02*A95","v":{"v":0,"d":"0.000"}}]
[5,{"$f":"-0.0001*A96^2+0.02*A96","v":{"v":0.0975,"d":"0.098"}}]
[10,{"v":0.19,"d":"0.190"}]
[15,{"v":0.27749999999999997,"d":"0.278"}]
[20,{"v":0.36000000000000004,"d":"0.360"}]
[25,{"v":0.4375,"d":"0.438"}]
[30,{"v":0.51,"d":"0.510"}]
[35,{"v":0.5775,"d":"0.578"}]
[40,{"v":0.64,"d":"0.640"}]
[45,{"v":0.6975,"d":"0.698"}]
[50,{"v":0.75,"d":"0.750"}]
[55,{"v":0.7975000000000001,"d":"0.798"}]
[60,{"v":0.8399999999999999,"d":"0.840"}]
[65,{"v":0.8775,"d":"0.878"}]
[70,{"v":0.9100000000000001,"d":"0.910"}]
[72,{"v":0.9216,"d":"0.922"}]
[75,{"v":0.9375,"d":"0.938"}]
[80,{"v":0.9600000000000001,"d":"0.960"}]
[85,{"v":0.9774999999999999,"d":"0.978"}]
[90,{"$f":"-0.0001*A114^2+0.02*A114","v":{"v":0.99,"d":"0.990"}}]
[95,{"$f":"-0.0001*A115^2+0.02*A115","v":{"v":0.9975,"d":"0.998"}}]
[100,{"$f":"-0.0001*A116^2+0.02*A116","v":{"v":1,"d":"1.000"}}]
[]
[]
["nº de indicador:",60,"función de transformación:","CA=0","0<I<40"]
["Indicador:","Coeficiente medio de interés del factor topográfico en relación a la situación \"sin\" proyecto (medio urbano). ",null,"CA= (-1,86E-4*I^2)+(4,26E-2I)-1,41","40<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 -100","valor del indicador",60]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D123<0,\"valor del indicador fuera de rango\",IF(D123<=40,0,IF(D123<=100,(-0.000186*(D123^2))+(0.0426*D123)-1.41,\"valor del indicador fuera rango\")))","v":{"v":0.47640000000000016,"d":"0.476"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[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.000186*A135^2+0.0426*A135-1.41","v":{"v":0.1303500000000002,"d":"0.130"}}]
[50,{"$f":"-0.000186*A136^2+0.0426*A136-1.41","v":{"v":0.2550000000000001,"d":"0.255"}}]
[55,{"v":0.37034999999999996,"d":"0.370"}]
[60,{"v":0.47640000000000016,"d":"0.476"}]
[65,{"v":0.5731500000000003,"d":"0.573"}]
[70,{"v":0.6605999999999999,"d":"0.661"}]
[75,{"v":0.7387499999999998,"d":"0.739"}]
[80,{"v":0.8076000000000001,"d":"0.808"}]
[85,{"v":0.8671499999999999,"d":"0.867"}]
[90,{"v":0.9174,"d":"0.917"}]
[95,{"v":0.9583499999999996,"d":"0.958"}]
[98,{"v":0.9784560000000007,"d":"0.978"}]
[100,{"v":0.99,"d":"0.990"}]

{"sheet":"61","index":2,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[6,2,6,4]]}
["nº de indicador:",61,"función de transformación:","CA=1","0<I<75"]
["Indicador:","Cantidad de recursos minerales afectados",null,"CA=(-1,6E-3*I^2) +(2,4E-1*I)-8","75<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 -100","valor del indicador",80]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=75,1,IF(D5<=100,(-0.0016*(D5^2))+(0.24*D5)-8,\"valor del indicador fuera rango\")))","v":{"v":0.9599999999999991,"d":"0.960"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[20,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[30,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[40,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[50,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[55,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[60,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[65,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[70,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[75,{"$f":"(-0.0016*A18^2) +(0.24*A18)-8","v":{"v":1,"d":"1.000"}}]
[80,{"v":0.9599999999999991,"d":"0.960"}]
[85,{"v":0.8399999999999981,"d":"0.840"}]
[90,{"v":0.639999999999997,"d":"0.640"}]
[95,{"v":0.35999999999999943,"d":"0.360"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"62-66","index":3,"n_rows":141,"n_cols":5,"rows_kept":141,"merged":[[6,2,6,4],[35,2,35,4],[64,2,64,4],[93,2,93,4],[121,2,121,4]]}
["nº de indicador:",62,"función de transformación:","CA=(-1E-4*I^2)+(2E-2*I)","0<I<100"]
["Indicador:","Recursos culturales equivalentes (recursos de interés nacional)"]
["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 indicador fuera de rango\",IF(D5<=100,(-0.0001*(D5^2))+(0.02*D5)))","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)+(0.02*A8)","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+5","v":5},{"v":0.0975,"d":"0.098"}]
[{"$f":"+A9+5","v":10},{"v":0.19,"d":"0.190"}]
[15,{"v":0.27749999999999997,"d":"0.278"}]
[20,{"v":0.36000000000000004,"d":"0.360"}]
[25,{"v":0.4375,"d":"0.438"}]
[30,{"v":0.51,"d":"0.510"}]
[35,{"v":0.5775,"d":"0.578"}]
[40,{"v":0.64,"d":"0.640"}]
[45,{"v":0.6975,"d":"0.698"}]
[50,{"v":0.75,"d":"0.750"}]
[55,{"v":0.7975000000000001,"d":"0.798"}]
[60,{"v":0.8399999999999999,"d":"0.840"}]
[65,{"v":0.8775,"d":"0.878"}]
[70,{"v":0.9100000000000001,"d":"0.910"}]
[75,{"v":0.9375,"d":"0.938"}]
[80,{"v":0.9600000000000001,"d":"0.960"}]
[85,{"v":0.9774999999999999,"d":"0.978"}]
[90,{"v":0.99,"d":"0.990"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",63,"función de transformación:","CA=0","0<I<25"]
["Indicador:","Recursos culturales equivalentes (recursos de interés regional)",null,"CA=(-1,77E-4*I^2)+(3,55E-2*I)-(7,76E-1)","25<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",100]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D34<0,\"valor del indicador fuera de rango\",IF(D34<=25,0,IF(D34<=100,(-0.000177*(D34^2))+(0.0355*D34)-(0.78),\"valor del indicador fuera rango\")))","v":{"v":0.9999999999999998,"d":"1.000"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[5,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"$f":"5+A38","v":10},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"$f":"5+A39","v":15},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[20,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[25,{"$f":"(-0.000177*A42^2)+(0.0355*A42)-(0.776)","v":{"v":8.7499999999995914E-4,"d":"0.001"}}]
[30,{"$f":"(-0.000177*A43^2)+(0.0355*A43)-(0.776)","v":{"v":0.12969999999999993,"d":"0.130"}}]
[35,{"v":0.24967499999999987,"d":"0.250"}]
[40,{"v":0.3608,"d":"0.361"}]
[45,{"v":0.4630749999999999,"d":"0.463"}]
[50,{"v":0.5565,"d":"0.557"}]
[55,{"v":0.6410750000000001,"d":"0.641"}]
[60,{"v":0.7167999999999999,"d":"0.717"}]
[65,{"v":0.7836749999999997,"d":"0.784"}]
[70,{"v":0.8416999999999999,"d":"0.842"}]
[75,{"v":0.8908749999999996,"d":"0.891"}]
[80,{"v":0.9311999999999998,"d":"0.931"}]
[85,{"v":0.9626749999999997,"d":"0.963"}]
[90,{"v":0.9852999999999998,"d":"0.985"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",64,"función de transformación:","CA=0","0<I<50"]
["Indicador:","Recursos culturales equivalentes (recursos de interés local)",null,"CA=(-1,67E-4*I^2)+(4,5E-2*I)-1,83","50<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",15]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D63<=0,\"valor del indicador fuera de rango\",IF(D63<=50,0,IF(D63<=100,-0.000167*D63^2+0.045*D63-1.83,\"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,{"v":0,"d":"0.000"}]
[5,{"v":0,"d":"0.000"}]
[10,{"v":0,"d":"0.000"}]
[15,{"v":0,"d":"0.000"}]
[20,{"v":0,"d":"0.000"}]
[25,{"v":0,"d":"0.000"}]
[30,{"v":0,"d":"0.000"}]
[35,{"v":0,"d":"0.000"}]
[40,{"v":0,"d":"0.000"}]
[45,{"v":0,"d":"0.000"}]
[50,{"v":0,"d":"0.000"}]
[55,{"$f":"(-0.000167*A77^2)+(0.045*A77)-1.83","v":{"v":0.1398250000000001,"d":"0.140"}}]
[60,{"$f":"(-0.000167*A78^2)+(0.045*A78)-1.83","v":{"v":0.2687999999999997,"d":"0.269"}}]
[65,{"v":0.3894249999999997,"d":"0.389"}]
[70,{"v":0.5017,"d":"0.502"}]
[75,{"v":0.6056249999999999,"d":"0.606"}]
[80,{"v":0.7011999999999996,"d":"0.701"}]
[85,{"v":0.7884249999999997,"d":"0.788"}]
[90,{"v":0.8672999999999997,"d":"0.867"}]
[100,{"$f":"(-0.000167*A85^2)+(0.045*A85)-1.83","v":{"v":1,"d":"1.000"}}]
[]
[]
["nº de indicador:",65,"función de transformación:","CA=1E-2I","0<I<100"]
["Indicador:","Rango medio del interés de los recursos culturales existentes (bajo rigor conservacionista)",null,"CA=1","I>100"]
["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(D92<0,\"valor del indicador fuera de rango\",IF(D92<=100,(0.01*(D92))))","v":{"v":0.4,"d":"0.400"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.01*A95","v":{"v":0,"d":"0.000"}}]
[5,{"$f":"0.01*A96","v":{"v":0.05,"d":"0.050"}}]
[10,{"v":0.1,"d":"0.100"}]
[15,{"v":0.15,"d":"0.150"}]
[20,{"v":0.2,"d":"0.200"}]
[25,{"v":0.25,"d":"0.250"}]
[30,{"v":0.3,"d":"0.300"}]
[35,{"v":0.35000000000000003,"d":"0.350"}]
[40,{"v":0.4,"d":"0.400"}]
[45,{"v":0.45,"d":"0.450"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.55,"d":"0.550"}]
[60,{"v":0.6,"d":"0.600"}]
[65,{"v":0.65,"d":"0.650"}]
[70,{"v":0.7000000000000001,"d":"0.700"}]
[75,{"v":0.75,"d":"0.750"}]
[80,{"v":0.8,"d":"0.800"}]
[90,{"v":0.9,"d":"0.900"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",66,"función de transformación:","CA=0","0<I<33"]
["Indicador:","Rango medio del interés de los recursos culturales existentes (elevado rigor conservacionista)",null,"CA=(1,5E-2*I)-(4,99E-1)","I<100"]
["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(D120<0,\"valor del indicador fuera de rango\",IF(D120<=33,0,IF(D120<=100,(0.015*(D120))-(0.499),\"valor del indicador fuera rango\")))","v":0.251}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[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.015*A130)-(0.499)","v":{"v":0.026000000000000023,"d":"0.026"}}]
[40,{"$f":"(0.015*A131)-(0.499)","v":{"v":0.10099999999999998,"d":"0.101"}}]
[45,{"v":0.17599999999999993,"d":"0.176"}]
[50,0.251]
[55,{"v":0.32599999999999996,"d":"0.326"}]
[60,{"v":0.4009999999999999,"d":"0.401"}]
[65,0.476]
[70,0.551]
[75,0.626]
[80,0.701]
[90,{"v":0.8509999999999999,"d":"0.851"}]
[100,1.001]

{"sheet":"67-75","index":4,"n_rows":271,"n_cols":5,"rows_kept":271,"merged":[[6,2,6,4],[36,2,36,4],[66,2,66,4],[96,2,96,4],[126,2,126,4],[156,2,156,4],[181,2,181,4],[211,2,211,4],[241,2,241,4]]}
["nº de indicador:",67,"función de transformación:","CA=(-2,45E-2*I^2)-(2E-3*I)+1","0<I<4"]
["Indicador:","Conductividad del extracto saturado del suelo",null,"CA=(4,56E-3*I^2) -(1,41E-1*I)+1,09","4<I<15"]
["fórmula del indicador"]
["unidad del indicador:"," ds m-1"]
["rango de valores del indicador:","0 -15","valor del indicador",5]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=4,(-0.0245*D5^2)-(0.002*D5)+1,IF(D5<=15,(0.00456*D5^2)-(0.141*D5)+1.09,\"valor del indicador fuera rango\")))","v":{"v":0.4990000000000001,"d":"0.499"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"(-0.0245*A8^2)-(0.002*A8)+1","v":{"v":1,"d":"1.000"}}]
[0.5,{"$f":"(-0.0245*A9^2)-(0.002*A9)+1","v":{"v":0.992875,"d":"0.993"}}]
[{"v":1,"d":"1.0"},{"v":0.9735,"d":"0.974"}]
[1.5,{"v":0.941875,"d":"0.942"}]
[{"v":2,"d":"2.0"},0.898]
[2.5,{"v":0.8418749999999999,"d":"0.842"}]
[{"v":3,"d":"3.0"},{"v":0.7735,"d":"0.774"}]
[3.5,{"v":0.6928749999999999,"d":"0.693"}]
[{"v":4,"d":"4.0"},{"$f":"(0.00456*A16^2) -(0.141*A16)+1.09","v":{"v":0.5989600000000002,"d":"0.599"}}]
[{"v":5,"d":"5.0"},{"v":0.4990000000000001,"d":"0.499"}]
[{"v":6,"d":"6.0"},{"v":0.4081600000000002,"d":"0.408"}]
[{"v":7,"d":"7.0"},{"v":0.3264400000000002,"d":"0.326"}]
[{"v":8,"d":"8.0"},{"v":0.2538400000000002,"d":"0.254"}]
[{"v":9,"d":"9.0"},{"v":0.19036000000000008,"d":"0.190"}]
[{"v":10,"d":"10.0"},{"v":0.13600000000000012,"d":"0.136"}]
[{"v":11,"d":"11.0"},{"v":0.09076000000000017,"d":"0.091"}]
[{"v":12,"d":"12.0"},{"v":0.054640000000000244,"d":"0.055"}]
[{"v":13,"d":"13.0"},{"v":0.02764000000000033,"d":"0.028"}]
[{"v":14,"d":"14.0"},{"v":0.009760000000000213,"d":"0.010"}]
[14.5,{"v":0.004240000000000244,"d":"0.004"}]
[{"v":15,"d":"15.0"},{"v":1.000000000000334E-3,"d":"0.001"}]
[]
[]
["nº de indicador:",68,"función de transformación:","CA=(-2,45E-2*I^2)-(2E-3*I)+1","0<I<4"]
["Indicador:","Conductividad del extracto saturado del suelo ponderado por la superficie de zonas homogéneas",null,"CA=(4,56E-3*I^2) -(1,41E-1*I)+1,09","4<I<15"]
["fórmula del indicador"]
["unidad del indicador:"," ds m-1"]
["rango de valores del indicador:","0 -15","valor del indicador",6]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D35<0,\"valor del indicador fuera de rango\",IF(D35<=4,(-0.0245*D35^2)-(0.002*D35)+1,IF(D35<=15,(0.00456*D35^2)-(0.141*D35)+1.09,\"valor del indicador fuera rango\")))","v":{"v":0.4081600000000002,"d":"0.408"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"(-0.0245*A38^2)-(0.002*A38)+1","v":{"v":1,"d":"1.000"}}]
[0.5,{"$f":"(-0.0245*A39^2)-(0.002*A39)+1","v":{"v":0.992875,"d":"0.993"}}]
[{"v":1,"d":"1.0"},{"v":0.9735,"d":"0.974"}]
[1.5,{"v":0.941875,"d":"0.942"}]
[{"v":2,"d":"2.0"},0.898]
[2.5,{"v":0.8418749999999999,"d":"0.842"}]
[{"v":3,"d":"3.0"},{"v":0.7735,"d":"0.774"}]
[3.5,{"v":0.6928749999999999,"d":"0.693"}]
[{"v":4,"d":"4.0"},{"$f":"(0.00456*A46^2) -(0.141*A46)+1.09","v":{"v":0.5989600000000002,"d":"0.599"}}]
[{"v":5,"d":"5.0"},{"v":0.4990000000000001,"d":"0.499"}]
[{"v":6,"d":"6.0"},{"v":0.4081600000000002,"d":"0.408"}]
[{"v":7,"d":"7.0"},{"v":0.3264400000000002,"d":"0.326"}]
[{"v":8,"d":"8.0"},{"v":0.2538400000000002,"d":"0.254"}]
[{"v":9,"d":"9.0"},{"v":0.19036000000000008,"d":"0.190"}]
[{"v":10,"d":"10.0"},{"v":0.13600000000000012,"d":"0.136"}]
[{"v":11,"d":"11.0"},{"v":0.09076000000000017,"d":"0.091"}]
[{"v":12,"d":"12.0"},{"v":0.054640000000000244,"d":"0.055"}]
[{"v":13,"d":"13.0"},{"v":0.02764000000000033,"d":"0.028"}]
[{"v":14,"d":"14.0"},{"v":0.009760000000000213,"d":"0.010"}]
[14.5,{"v":0.004240000000000244,"d":"0.004"}]
[{"v":15,"d":"15.0"},{"v":1.000000000000334E-3,"d":"0.001"}]
[]
[]
["nº de indicador:",69,"función de transformación:","CA=(6,25E-4*I^2)+(6,25E-2*I)+1,5","`-40<I<-20"]
["Indicador:","% de variación de la salinidad con respecto a la natural",null,"CA=(1,25E-3*I^2)+1","`-20<I<20"]
["fórmula del indicador",null,null,"CA=(1,25E-3*I^2)-(1*E-1*I)+2","20<I<40"]
["unidad del indicador:"]
["rango de valores del indicador:","  -40  -  40","valor del indicador",32]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D65<(-40),\"valor del indicador fuera de rango\",IF(D65<=(-20),(0.000625*D65^2)+(0.0625*D65)+1.5,IF(D65<=20,(-0.00125*D65^2)+1,IF(D65<=40,(0.00125*D65^2)-(0.1*D65)+2,\"valor del indicador fuera rango\"))))","v":{"v":0.07999999999999985,"d":"0.080"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-40,{"$f":"(0.000625*A68^2)+(0.0625*A68)+1.5","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A68+2","v":-38},{"v":0.027499999999999858,"d":"0.027"}]
[{"$f":"+A69+2","v":-36},{"v":0.06000000000000005,"d":"0.060"}]
[-34,{"v":0.09750000000000014,"d":"0.098"}]
[-32,{"v":0.14000000000000012,"d":"0.140"}]
[-30,{"v":0.1875,"d":"0.188"}]
[-28,{"v":0.24,"d":"0.240"}]
[-26,{"v":0.2974999999999999,"d":"0.298"}]
[-24,{"v":0.3599999999999999,"d":"0.360"}]
[-20,{"$f":"(-0.00125*A77^2)+1","v":{"v":0.5,"d":"0.500"}}]
[-16,{"$f":"(-0.00125*A78^2)+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-12,{"v":0.8200000000000001,"d":"0.820"}]
[-8,{"v":0.92,"d":"0.920"}]
[0,{"v":1,"d":"1.000"}]
[4,{"v":0.98,"d":"0.980"}]
[8,{"v":0.92,"d":"0.920"}]
[16,{"v":0.6799999999999999,"d":"0.680"}]
[20,{"$f":"(0.00125*A85^2)-(0.1*A85)+2","v":{"v":0.5,"d":"0.500"}}]
[28,{"$f":"(0.00125*A86^2)-(0.1*A86)+2","v":{"v":0.17999999999999972,"d":"0.180"}}]
[32,{"$f":"(0.00125*A87^2)-(0.1*A87)+2","v":{"v":0.07999999999999985,"d":"0.080"}}]
[40,{"$f":"(0.00125*A88^2)-(0.1*A88)+2","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",70,"función de transformación:","CA=(4,37E-3*I^2)+1","0<I<10,7"]
["Indicador:","Proporción o cantidad relativa de sodio intercambiable(PSI)",null,"CA=(1,34E-3*I^2)-(8,05E-2*I)+1,21","10,7<I<30"]
["fórmula del indicador","% medio de sodio intercambiable"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 30","valor del indicador",15]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D95<0,\"valor del indicador fuera de rango\",IF(D95<=10.7,(-0.00437*D95^2)+1,IF(D95<=30,(0.00134*D95^2)-(0.0805*D95)+1.21,\"valor del indicador fuera rango\")))","v":{"v":0.30399999999999994,"d":"0.304"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.00437*A98^2)+1","v":{"v":1,"d":"1.000"}}]
[2,{"v":0.98252,"d":"0.983"}]
[4,{"v":0.93008,"d":"0.930"}]
[6,{"v":0.84268,"d":"0.843"}]
[8,{"v":0.7203200000000001,"d":"0.720"}]
[10,0.563]
[10.7,{"$f":"(0.00134*A104^2)-(0.0805*A104)+1.21","v":{"v":0.5020666,"d":"0.502"}}]
[11,{"v":0.48663999999999996,"d":"0.487"}]
[12,{"v":0.43696,"d":"0.437"}]
[13,{"v":0.38996,"d":"0.390"}]
[14,{"v":0.34563999999999995,"d":"0.346"}]
[15,{"v":0.30399999999999994,"d":"0.304"}]
[16,{"v":0.26503999999999994,"d":"0.265"}]
[18,{"v":0.19516,"d":"0.195"}]
[21,{"v":0.11043999999999987,"d":"0.110"}]
[22,{"v":0.08755999999999986,"d":"0.088"}]
[23,{"v":0.06735999999999986,"d":"0.067"}]
[24,{"v":0.049840000000000106,"d":"0.050"}]
[25,{"v":0.0349999999999997,"d":"0.035"}]
[27,{"v":0.013359999999999816,"d":"0.013"}]
[30,{"v":9.9999999999988987E-4,"d":"0.001"}]
[]
[]
["nº de indicador:",71,"función de transformación:","CA=-4,37E-3*I^2+1","0<I<10,7"]
["Indicador:","% medio de sodio intercambiable (PSI) ponderado según la superficie de zonas homogéneas.",null,"CA=(1,34E-3*I^2) -(8,05E-2*I) + 1,21","10,7<I<30"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 30","valor del indicador",12]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D125<0,\"valor del indicador fuera de rango\",IF(D125<=10.7,-0.00437*(D125^2)+1,IF(D125<=30,(0.00134*(D125^2))-(0.0805*D125)+1.21,\"valor del indicador fuera rango\")))","v":{"v":0.43696,"d":"0.437"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.00437*A128^2)+1","v":{"v":1,"d":"1.000"}}]
[2,{"v":0.98252,"d":"0.983"}]
[4,{"v":0.93008,"d":"0.930"}]
[6,{"v":0.84268,"d":"0.843"}]
[8,{"v":0.7203200000000001,"d":"0.720"}]
[10,0.563]
[10.7,{"$f":"(0.00134*A134^2)-(0.0805*A134)+1.21","v":{"v":0.5020666,"d":"0.502"}}]
[11,{"v":0.48663999999999996,"d":"0.487"}]
[12,{"v":0.43696,"d":"0.437"}]
[13,{"v":0.38996,"d":"0.390"}]
[14,{"v":0.34563999999999995,"d":"0.346"}]
[15,{"v":0.30399999999999994,"d":"0.304"}]
[16,{"v":0.26503999999999994,"d":"0.265"}]
[17,{"v":0.22875999999999985,"d":"0.229"}]
[18,{"v":0.19516,"d":"0.195"}]
[19,{"v":0.16423999999999994,"d":"0.164"}]
[20,{"v":0.1359999999999999,"d":"0.136"}]
[22,{"v":0.08755999999999986,"d":"0.088"}]
[24,{"v":0.049840000000000106,"d":"0.050"}]
[26,{"v":0.02283999999999997,"d":"0.023"}]
[30,{"v":9.9999999999988987E-4,"d":"0.001"}]
[]
[]
["nº de indicador:",72,"función de transformación:","CA=0","0<I<64"]
["Indicador:","Nitrógeno en el suelo",null,"CA=(-6,1E-5*I^2) +(2,34E-2*I) -1,25","64<I<192"]
["fórmula del indicador","kg ha-1",null,"CA=(1,36E-5*I^2)-(1,3E-2*I)+3","192<I<384"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 384","valor del indicador",228]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D155<0,\"valor del indicador fuera de rango\",IF(D155<=64,0,IF(D155<=192,(-0.000061*(D155^2))+(0.0234*D155)-1.25,IF(D155<=384,(0.0000136*D155^2)-(0.013*D155)+3,\"valor del indicador fuera de rango\"))))","v":{"v":0.7429823999999998,"d":"0.743"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":0,"d":"0.000"}]
[{"$f":"+A158+25","v":25},{"v":0,"d":"0.000"}]
[63,{"v":0,"d":"0.000"}]
[64,{"v":0,"d":"0.000"}]
[{"$f":"+A161+32","v":96},{"$f":"(-0.000061*(A162^2))+(0.0234*A162)-1.25","v":{"v":0.43422399999999994,"d":"0.434"}}]
[{"$f":"+A162+32","v":128},{"$f":"(-0.000061*(A163^2))+(0.0234*A163)-1.25","v":{"v":0.7457760000000002,"d":"0.746"}}]
[{"$f":"+A163+32","v":160},{"$f":"(-0.000061*(A164^2))+(0.0234*A164)-1.25","v":{"v":0.9324000000000003,"d":"0.932"}}]
[{"$f":"+A164+32","v":192},{"$f":"(-0.000061*(A165^2))+(0.0234*A165)-1.25","v":{"v":0.9940959999999999,"d":"0.994"}}]
[192,{"$f":"(0.0000136*(A166^2))-(0.013*A166)+3","v":{"v":1.0053504,"d":"1.005"}}]
[{"$f":"+A166+25","v":217},{"v":0.8194104000000002,"d":"0.819"}]
[242,{"v":0.6504704000000001,"d":"0.650"}]
[267,{"v":0.4985304000000004,"d":"0.499"}]
[292,{"v":0.3635904000000001,"d":"0.364"}]
[317,{"v":0.2456504000000006,"d":"0.246"}]
[342,{"v":0.14471040000000013,"d":"0.145"}]
[367,{"v":0.0607704,"d":"0.061"}]
[]
[]
["nº de indicador:",73,"función de transformación:","CA=0","0<I<1"]
["Indicador:","Índice GUS de contaminación del suelo por plaguicidas y pesticidas (suelos poco permeables).",null,"CA=(5,56E-1*I) -5,56E-1 ","1<I<2,8"]
["fórmula del indicador","log t1/2 * 4 [-log(Koc)]"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 2,8","valor del indicador",1.5]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D180<0,\"valor del indicador fuera de rango\",IF(D180<=1,0,IF(D180<=2.8,(0.556*D180)-0.556,\"valor del indicador fuera rango\")))","v":0.278}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"v":0,"d":"0.000"}]
[{"$f":"+A183+0.15","v":0.15},{"v":0,"d":"0.000"}]
[{"$f":"+A184+0.15","v":{"v":0.3,"d":"0.30"}},{"v":0,"d":"0.000"}]
[{"v":0.44999999999999996,"d":"0.45"},{"v":0,"d":"0.000"}]
[{"v":0.6,"d":"0.60"},{"v":0,"d":"0.000"}]
[0.75,{"v":0,"d":"0.000"}]
[{"v":0.9,"d":"0.90"},{"v":0,"d":"0.000"}]
[{"v":1,"d":"1.00"},{"$f":"(0.556*A190)-0.556","v":{"v":0,"d":"0.000"}}]
[1.15,{"v":0.08339999999999992,"d":"0.083"}]
[{"v":1.2999999999999998,"d":"1.30"},{"v":0.16679999999999995,"d":"0.167"}]
[{"v":1.4499999999999997,"d":"1.45"},{"v":0.25019999999999987,"d":"0.250"}]
[{"v":1.5999999999999996,"d":"1.60"},{"v":0.3335999999999998,"d":"0.334"}]
[{"v":1.7499999999999996,"d":"1.75"},{"v":0.4169999999999998,"d":"0.417"}]
[{"v":1.8999999999999995,"d":"1.90"},{"v":0.5003999999999997,"d":"0.500"}]
[{"v":2.0499999999999994,"d":"2.05"},{"v":0.5837999999999997,"d":"0.584"}]
[{"v":2.1999999999999993,"d":"2.20"},{"v":0.6671999999999996,"d":"0.667"}]
[{"v":2.349999999999999,"d":"2.35"},{"v":0.7505999999999997,"d":"0.751"}]
[{"v":2.499999999999999,"d":"2.50"},{"v":0.8339999999999996,"d":"0.834"}]
[{"v":2.649999999999999,"d":"2.65"},{"v":0.9173999999999995,"d":"0.917"}]
[{"v":2.7,"d":"2.70"},{"v":0.9452000000000003,"d":"0.945"}]
[{"v":2.8,"d":"2.80"},{"v":1.0008,"d":"1.001"}]
[]
[]
["nº de indicador:",74,"función de transformación:","CA=0","0<I<1,4"]
["Indicador:","Índice GUS de contaminación del suelo por plaguicidas y pesticidas (suelos permeables).",null,"CA=1,13*I-1,58","1,4<I<1,8"]
["fórmula del indicador","log t1/2 * 4 [-log(Koc)]",null,"CA=(5,56E-1*I) -5,56E-1 ","1,8<I<2,8"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 2,8","valor del indicador",2]
["Tipo de indicador","1 (T=0)","calidad ambiental",{"$f":"IF(D210<0,\"valor del indicador fuera de rango\",IF(D210<=1.4,0,IF(D210<=1.8,1.13*D210-1.58,IF(D210<=2.8,(0.556*D210)-0.556,\"valor del indicador fuera rango\"))))","v":0.556}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":0,"d":"0.000"}]
[0.1,{"v":0,"d":"0.000"}]
[0.2,{"v":0,"d":"0.000"}]
[0.3,{"v":0,"d":"0.000"}]
[0.4,{"v":0,"d":"0.000"}]
[0.5,{"v":0,"d":"0.000"}]
[0.6,{"v":0,"d":"0.000"}]
[1.5,{"$f":"1.13*(A220)-1.58","v":{"v":0.11499999999999977,"d":"0.115"}}]
[1.6,{"$f":"1.13*(A221)-1.58","v":{"v":0.22799999999999976,"d":"0.228"}}]
[1.7,{"$f":"1.13*(A222)-1.58","v":{"v":0.34099999999999975,"d":"0.341"}}]
[1.8,{"$f":"1.13*(A223)-1.58","v":{"v":0.45399999999999974,"d":"0.454"}}]
[1.9,{"$f":"(0.556*A224)-0.556","v":{"v":0.5004,"d":"0.500"}}]
[2,{"$f":"(0.556*A225)-0.556","v":0.556}]
[2.1,{"v":0.6116000000000001,"d":"0.612"}]
[2.2,{"v":0.6672000000000002,"d":"0.667"}]
[2.3,{"v":0.7227999999999999,"d":"0.723"}]
[2.4,{"v":0.7784,"d":"0.778"}]
[2.5,{"v":0.8340000000000001,"d":"0.834"}]
[2.6,{"v":0.8896000000000002,"d":"0.890"}]
[2.7,{"v":0.9452000000000003,"d":"0.945"}]
[2.8,{"v":1.0008,"d":"1.001"}]
[]
[]
["nº de indicador:",75,"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","no hay",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(D240<0,\"valor del indicador fuera de rango\",IF(D240<=36,-0.0139*D240+1,IF(D240<=131,(-0.00526*D240)+0.689,IF(D240<=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*A243+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A243+5","v":5},{"$f":"-0.0139*A244+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*A251+0.689","v":{"v":0.4785999999999999,"d":"0.479"}}]
[45,{"$f":"-0.00526*A252+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":"76-78","index":5,"n_rows":86,"n_cols":5,"rows_kept":86,"merged":[[6,2,6,4],[33,2,33,4],[63,2,63,4]]}
["nº de indicador:",76,"función de transformación:","CA=1E-2*I","0<I<100"]
["Indicador:","Calidad media del suelo basada en su grado de evolución genética y estado de conservación"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 -100","valor del indicador",60]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=100,(0.01*D5)))","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*A8","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+6","v":6},{"$f":"0.01*A9","v":{"v":0.06,"d":"0.060"}}]
[{"$f":"+A9+6","v":12},{"v":0.12,"d":"0.120"}]
[18,{"v":0.18,"d":"0.180"}]
[24,{"v":0.24,"d":"0.240"}]
[30,{"v":0.3,"d":"0.300"}]
[36,{"v":0.36,"d":"0.360"}]
[42,{"v":0.42,"d":"0.420"}]
[48,{"v":0.48,"d":"0.480"}]
[54,{"v":0.54,"d":"0.540"}]
[60,{"v":0.6,"d":"0.600"}]
[66,{"v":0.66,"d":"0.660"}]
[72,{"v":0.72,"d":"0.720"}]
[78,{"v":0.78,"d":"0.780"}]
[84,{"v":0.84,"d":"0.840"}]
[90,{"v":0.9,"d":"0.900"}]
[96,{"v":0.96,"d":"0.960"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",77,"función de transformación:","CA=-1E-4*(I^2)+(2E-2*I)","0<I<100"]
["Indicador:","Superficie de las clases agrológicas ponderada según productividad"]
["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(D32<0,\"valor del indicador fuera de rango\",IF(D32<=100,(-0.0001*(D32^2)+(0.02*D32))))","v":{"v":0.64,"d":"0.640"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0001*(A35^2)+(0.02*A35)","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A35+5","v":5},{"$f":"-0.0001*(A36^2)+(0.02*A36)","v":{"v":0.0975,"d":"0.098"}}]
[{"$f":"+A36+5","v":10},{"v":0.19,"d":"0.190"}]
[15,{"v":0.27749999999999997,"d":"0.278"}]
[20,{"v":0.36000000000000004,"d":"0.360"}]
[25,{"v":0.4375,"d":"0.438"}]
[30,{"v":0.51,"d":"0.510"}]
[35,{"v":0.5775,"d":"0.578"}]
[40,{"v":0.64,"d":"0.640"}]
[45,{"v":0.6975,"d":"0.698"}]
[50,{"v":0.75,"d":"0.750"}]
[55,{"v":0.7975000000000001,"d":"0.798"}]
[60,{"v":0.8399999999999999,"d":"0.840"}]
[65,{"v":0.8775,"d":"0.878"}]
[70,{"v":0.9100000000000001,"d":"0.910"}]
[75,{"v":0.9375,"d":"0.938"}]
[80,{"v":0.9600000000000001,"d":"0.960"}]
[85,{"v":0.9774999999999999,"d":"0.978"}]
[90,{"v":0.99,"d":"0.990"}]
[95,{"v":0.9975,"d":"0.998"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",78,"función de transformación:","CA=-1E-4*(I^2)+(2E-2*I)","0<I<100"]
["Indicador:","Superficie equivalente de clase agrológica I."]
["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(D62<0,\"valor del indicador fuera de rango\",IF(D62<=100,(-0.0001*(D62^2)+(0.02*D62))))","v":{"v":0.64,"d":"0.640"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0001*(A65^2)+(0.02*A65)","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A65+5","v":5},{"$f":"-0.0001*(A66^2)+(0.02*A66)","v":{"v":0.0975,"d":"0.098"}}]
[{"$f":"+A66+5","v":10},{"v":0.19,"d":"0.190"}]
[15,{"v":0.27749999999999997,"d":"0.278"}]
[20,{"v":0.36000000000000004,"d":"0.360"}]
[25,{"v":0.4375,"d":"0.438"}]
[30,{"v":0.51,"d":"0.510"}]
[35,{"v":0.5775,"d":"0.578"}]
[40,{"v":0.64,"d":"0.640"}]
[45,{"v":0.6975,"d":"0.698"}]
[50,{"v":0.75,"d":"0.750"}]
[55,{"v":0.7975000000000001,"d":"0.798"}]
[60,{"v":0.8399999999999999,"d":"0.840"}]
[65,{"v":0.8775,"d":"0.878"}]
[70,{"v":0.9100000000000001,"d":"0.910"}]
[75,{"v":0.9375,"d":"0.938"}]
[80,{"v":0.9600000000000001,"d":"0.960"}]
[85,{"v":0.9774999999999999,"d":"0.978"}]
[90,{"v":0.99,"d":"0.990"}]
[92,{"v":0.9936,"d":"0.994"}]
[{"$f":"+A83+5","v":95},{"v":0.9975,"d":"0.998"}]
[100,{"v":1,"d":"1.000"}]