{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Registro","128-131","132-135","136","137","138","139-140","141","142-145","146-147","148-149","150","151-152","153"],"not_rendered":{"charts":26,"images":20,"macros":1,"external_links":5,"defined_names":28},"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":"128-131","index":1,"n_rows":125,"n_cols":5,"rows_kept":125,"merged":[[6,2,6,4],[40,2,40,4],[74,2,74,4],[105,2,105,4]]}
["nº de indicador:",128,"función de transformación:","CA=-1E-04I2+2E-02I","0<I<100"]
["Indicador:","Longitud de los elementos de la red ponderados por su importancia (hipótesis A)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",7]
["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.13510000000000003,"d":"0.135"}}]
["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+4","v":4},{"$f":"-0.0001*A9^2+0.02*A9","v":{"v":0.0784,"d":"0.078"}}]
[{"$f":"+A9+4","v":8},{"v":0.15360000000000001,"d":"0.154"}]
[12,{"v":0.2256,"d":"0.226"}]
[16,{"v":0.2944,"d":"0.294"}]
[20,{"v":0.36000000000000004,"d":"0.360"}]
[24,{"v":0.4224,"d":"0.422"}]
[28,{"v":0.48160000000000003,"d":"0.482"}]
[32,{"v":0.5376,"d":"0.538"}]
[36,{"v":0.5904,"d":"0.590"}]
[40,{"v":0.64,"d":"0.640"}]
[44,{"v":0.6864,"d":"0.686"}]
[48,{"v":0.7295999999999999,"d":"0.730"}]
[52,{"v":0.7696000000000001,"d":"0.770"}]
[56,{"v":0.8064000000000001,"d":"0.806"}]
[60,{"v":0.8399999999999999,"d":"0.840"}]
[64,{"v":0.8704000000000001,"d":"0.870"}]
[68,{"v":0.8976000000000001,"d":"0.898"}]
[72,{"v":0.9216,"d":"0.922"}]
[76,{"v":0.9424,"d":"0.942"}]
[80,{"v":0.9600000000000001,"d":"0.960"}]
[84,{"v":0.9743999999999999,"d":"0.974"}]
[88,{"v":0.9855999999999999,"d":"0.986"}]
[94,{"v":0.9964000000000001,"d":"0.996"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",129,"función de transformación:","CA=0","0<I<33"]
["Indicador:","Longitud de los elementos de la red ponderados por su importancia (hipótesis B)",null,"CA=-2,23E-04I2+4,46E-02I-1,230","33<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",44]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D39<0,\"valor del indicador fuera de rango\",IF(D39<=33,0,IF(D39<=100,-0.000223*D39^2+0.0446*D39-1.23,\"valor del indicador fuera rango\")))","v":{"v":0.30067200000000005,"d":"0.301"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,0,{"v":0,"d":"0.000"}]
[{"$f":"+A42+4","v":4},0,{"v":0,"d":"0.000"}]
[{"$f":"+A43+4","v":8},0,{"v":0,"d":"0.000"}]
[12,0,{"v":0,"d":"0.000"}]
[16,0,{"v":0,"d":"0.000"}]
[20,0,{"v":0,"d":"0.000"}]
[24,0,{"v":0,"d":"0.000"}]
[28,0,{"v":0,"d":"0.000"}]
[32,0,{"v":0,"d":"0.000"}]
[36,{"$f":"-0.000223*A51^2+0.0446*A51-1.23","v":{"v":0.086592,"d":"0.087"}}]
[40,{"v":0.19720000000000004,"d":"0.197"}]
[44,{"v":0.30067200000000005,"d":"0.301"}]
[48,{"v":0.397008,"d":"0.397"}]
[52,{"v":0.486208,"d":"0.486"}]
[56,{"v":0.5682720000000003,"d":"0.568"}]
[60,{"v":0.6432000000000002,"d":"0.643"}]
[64,{"v":0.7109920000000001,"d":"0.711"}]
[68,{"v":0.7716479999999999,"d":"0.772"}]
[72,{"v":0.8251680000000001,"d":"0.825"}]
[76,{"v":0.8715519999999999,"d":"0.872"}]
[80,{"v":0.9108,"d":"0.911"}]
[84,{"v":0.9429120000000002,"d":"0.943"}]
[88,{"v":0.9678880000000003,"d":"0.968"}]
[94,{"v":0.9919720000000001,"d":"0.992"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",130,"función de transformación:","CA=1E-02I","0<I<100"]
["Indicador:","Importancia media de los elementos e la red"]
["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(D73<0,\"valor del indicador fuera de rango\",IF(D73<=100,0.01*D73))","v":{"v":0.2,"d":"0.200"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.01*A76","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"}]
[{"$f":"+A76+4","v":4},{"$f":"0.01*A77","v":{"v":0.04,"d":"0.040"}},{"v":0,"d":"0.000"}]
[{"$f":"+A77+4","v":8},{"v":0.08,"d":"0.080"},{"v":0,"d":"0.000"}]
[12,{"v":0.12,"d":"0.120"},{"v":0,"d":"0.000"}]
[16,{"v":0.16,"d":"0.160"},{"v":0,"d":"0.000"}]
[20,{"v":0.2,"d":"0.200"},{"v":0,"d":"0.000"}]
[24,{"v":0.24,"d":"0.240"},{"v":0,"d":"0.000"}]
[28,{"v":0.28,"d":"0.280"},{"v":0,"d":"0.000"}]
[32,{"v":0.32,"d":"0.320"},{"v":0,"d":"0.000"}]
[36,{"v":0.36,"d":"0.360"}]
[40,{"v":0.4,"d":"0.400"}]
[44,{"v":0.44,"d":"0.440"}]
[48,{"v":0.48,"d":"0.480"}]
[52,{"v":0.52,"d":"0.520"}]
[56,{"v":0.56,"d":"0.560"}]
[60,{"v":0.6,"d":"0.600"}]
[64,{"v":0.64,"d":"0.640"}]
[68,{"v":0.68,"d":"0.680"}]
[70,{"v":0.7000000000000001,"d":"0.700"}]
[74,{"v":0.74,"d":"0.740"}]
[90,{"v":0.9,"d":"0.900"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",131,"función de transformación:","CA=-6,92E-05I2+1","0<I<85"]
["Indicador:","Disminución de la funcionalidad de la red",null,"CA=-1,52E-03I2+2,47E-01I-9,550","85<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(D104<0,\"valor del indicador fuera de rango\",IF(D104<=85,-0.0000692*D104^2+1,IF(D104<=100,-0.00152*D104^2+0.247*D104-9.55,\"valor del indicador fuera rango\")))","v":{"v":-0.05000000000000249,"d":"-0.050"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0000692*A107^2+1","v":{"v":1,"d":"1.000"}},{"v":0,"d":"0.000"}]
[{"$f":"+A107+4","v":4},{"v":0.9988928,"d":"0.999"},{"v":0,"d":"0.000"}]
[{"$f":"+A108+4","v":8},{"v":0.9955712,"d":"0.996"},{"v":0,"d":"0.000"}]
[12,{"v":0.9900352,"d":"0.990"},{"v":0,"d":"0.000"}]
[16,{"v":0.9822848,"d":"0.982"},{"v":0,"d":"0.000"}]
[20,{"v":0.97232,"d":"0.972"},{"v":0,"d":"0.000"}]
[24,{"v":0.9601408,"d":"0.960"},{"v":0,"d":"0.000"}]
[28,{"v":0.9457472,"d":"0.946"},{"v":0,"d":"0.000"}]
[32,{"v":0.9291392,"d":"0.929"},{"v":0,"d":"0.000"}]
[36,{"v":0.9103168,"d":"0.910"}]
[40,{"v":0.88928,"d":"0.889"}]
[50,0.827]
[60,{"v":0.75088,"d":"0.751"}]
[70,{"v":0.66092,"d":"0.661"}]
[80,{"v":0.5571200000000001,"d":"0.557"}]
[85,{"$f":"-0.00152*(A122^2)+(0.247*A122)-9.55","v":{"v":0.4629999999999992,"d":"0.463"}}]
[90,{"$f":"-0.00152*(A123^2)+(0.247*A123)-9.55","v":{"v":0.36799999999999855,"d":"0.368"}}]
[95,{"$f":"-0.00152*(A124^2)+(0.247*A124)-9.55","v":{"v":0.19699999999999918,"d":"0.197"}}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"132-135","index":2,"n_rows":100,"n_cols":5,"rows_kept":100,"merged":[[6,2,6,4],[32,2,32,4],[57,2,57,4],[83,2,83,4]]}
["nº de indicador:",132,"función de transformación:","CA=-4E-06I2+4E-03I","0<I<500"]
["Indicador:","Concentración de sales disueltas",null,"CA=-4E-07I2+4E-04I+9E-01","500<I<1500"]
["fórmula del indicador",null,null,"CA=2,67E-07I2-1,6E-03I+2,400","1500<I<3000"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 3000","valor del indicador",1700]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=500,-0.000004*(D5^2)+0.004*D5,IF(D5<=1500,(-0.0000004*(D5^2))+(0.0004*D5)+0.9,IF(D5<=3000,(0.000000267*(D5^2))-(0.0016*D5)+2.4,\"valor del indicador fuera rango\"))))","v":{"v":0.45162999999999975,"d":"0.452"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.000004*A8^2+0.004*A8","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+100","v":100},{"v":0.36000000000000004,"d":"0.360"}]
[{"$f":"+A9+100","v":200},{"v":0.64,"d":"0.640"}]
[{"$f":"+A10+100","v":300},{"v":0.84,"d":"0.840"}]
[{"$f":"+A11+100","v":400},{"v":0.9600000000000001,"d":"0.960"}]
[{"$f":"+A12+100","v":500},{"v":1,"d":"1.000"}]
[{"$f":"+A13+200","v":700},{"$f":"-0.0000004*A14^2+0.0004*A14+0.9","v":{"v":0.9840000000000001,"d":"0.984"}}]
[{"$f":"+A14+200","v":900},{"$f":"-0.0000004*A15^2+0.0004*A15+0.9","v":0.936}]
[1100,{"$f":"-0.0000004*A16^2+0.0004*A16+0.9","v":{"v":0.8560000000000001,"d":"0.856"}}]
[1300,{"$f":"-0.0000004*A17^2+0.0004*A17+0.9","v":{"v":0.7440000000000001,"d":"0.744"}}]
[1500,{"$f":"-0.0000004*A18^2+0.0004*A18+0.9","v":{"v":0.6000000000000001,"d":"0.600"}}]
[1700,{"$f":"0.000000267*A19^2-0.0016*A19+2.4","v":{"v":0.45162999999999975,"d":"0.452"}}]
[1900,{"v":0.3238699999999999,"d":"0.324"}]
[2100,{"v":0.2174699999999996,"d":"0.217"}]
[2300,{"v":0.13242999999999983,"d":"0.132"}]
[2500,{"v":0.06875000000000009,"d":"0.069"}]
[3000,{"v":3.0000000000001137E-3,"d":"0.003"}]
[]
[]
["nº de indicador:",133,"función de transformación:","CA=1","0<I<500"]
["Indicador:","Concentración de sales disueltas (Curva propuesta por ORSANCO)",null,"CA=8E-01","500<I<1000"]
["fórmula del indicador",null,null,"CA=4E-01","1000<I<1700"]
["unidad del indicador:","mg l-1"]
["rango de valores del indicador:","0 - 1700","valor del indicador",1200]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D31<0,\"valor del indicador fuera de rango\",IF(D31<=500,1,IF(D31<=1000,0.8,IF(D31<=1700,0.4,\"valor del indicador fuera rango\"))))","v":{"v":0.4,"d":"0.400"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.0"}]
[{"$f":"+A34+100","v":100},{"v":1,"d":"1.0"}]
[{"$f":"+A35+100","v":200},{"v":1,"d":"1.0"}]
[300,{"v":1,"d":"1.0"}]
[400,{"v":1,"d":"1.0"}]
[500,{"v":1,"d":"1.0"}]
[600,0.8]
[700,0.8]
[800,0.8]
[900,0.8]
[1000,0.8]
[1100,0.4]
[1200,0.4]
[1300,0.4]
[1500,0.4]
[1700,0.4]
[]
[]
["nº de indicador:",134,"función de transformación:","CA=-1,78E-06I2+2,67E-03I","0<I<750"]
["Indicador:","Conductividad eléctrica (CE) de las aguas",null,"CA=-1,78E-07I2+2,64E-04I+9E-01","750<I<2250"]
["fórmula del indicador",null,null,"CA= 1,19E-07I2-1,07E-03I+2,400","2250<I<4500"]
["unidad del indicador:","dS m-1"]
["rango de valores del indicador:","0 - 4500","valor del indicador",3000]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D56<0,\"valor del indicador fuera de rango\",IF(D56<=750,-0.00000178*(D56^2)+(0.00267*D56),IF(D56<=2250,(-0.000000178*(D56^2))+(0.000264*D56)+0.9,IF(D56<=4500,0.000000119*(D56^2)-(0.00107*D56)+2.4,\"valor del indicador fuera rango\"))))","v":{"v":0.2609999999999997,"d":"0.261"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":" -0.00000178*A59^2+0.00267*A59","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A59+280","v":280},{"$f":" -0.00000178*A60^2+0.00267*A60","v":{"v":0.608048,"d":"0.608"}}]
[{"$f":"+A60+280","v":560},{"$f":" -0.00000178*A61^2+0.00267*A61","v":{"v":0.9369920000000002,"d":"0.937"}}]
[840,{"$f":"-0.000000178*A62^2+0.000264*A62+0.9","v":{"v":0.9961632,"d":"0.996"}}]
[1120,{"v":0.9723968000000001,"d":"0.972"}]
[1400,{"v":0.92072,"d":"0.921"}]
[1680,{"v":0.8411328,"d":"0.841"}]
[1960,{"v":0.7336352,"d":"0.734"}]
[2240,{"v":0.5982272,"d":"0.598"}]
[2520,{"$f":"0.000000119*A68^2-0.00107*A68+2.4","v":{"v":0.45929759999999975,"d":"0.459"}}]
[2800,{"v":0.3369599999999999,"d":"0.337"}]
[3080,{"v":0.2332816000000002,"d":"0.233"}]
[3360,{"v":0.14826239999999968,"d":"0.148"}]
[3640,{"v":0.08190239999999971,"d":"0.082"}]
[3920,{"v":0.03420159999999983,"d":"0.034"}]
[4200,{"v":0.005160000000000053,"d":"0.005"}]
[4500,{"v":-0.005249999999999755,"d":"-0.005"}]
[]
[]
["nº de indicador:",135,"función de transformación:","CA=-1,78E-06I2+2,67E-03I","0<I<750"]
["Indicador:","Conductividad eléctrica (CE) de las aguas (curva propuesta por ORSANCO)",null,"CA=-1,78E-07I2+2,64E-04I+9E-01","750<I<2250"]
["fórmula del indicador",null,null,"CA= 1,19E-07I2-1,07E-03I+2,400","2250<I<4500"]
["unidad del indicador:","dS m-1"]
["rango de valores del indicador:","0 - 2500","valor del indicador",3000]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D82<0,\"valor del indicador fuera de rango\",IF(D82<=750,-0.00000178*(D82^2)+(0.00267*D82),IF(D82<=2250,(-0.000000178*(D82^2))+(0.000264*D82)+0.9,IF(D82<=4500,0.000000119*(D82^2)-(0.00107*D82)+2.4,\"valor del indicador fuera rango\"))))","v":{"v":0.2609999999999997,"d":"0.261"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":1,"d":"1.0"}]
[200,{"v":1,"d":"1.0"}]
[400,{"v":1,"d":"1.0"}]
[500,{"v":1,"d":"1.0"}]
[800,0.6]
[1000,0.6]
[{"$f":"+A90+150","v":1150},0.6]
[1300,0.6]
[1450,0.6]
[1600,0.4]
[1750,0.4]
[1900,0.4]
[2050,0.4]
[2200,0.4]
[2350,0.4]
[2500,0.4]

{"sheet":"136","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[6,2,6,4]]}
["nº de indicador:",136,"función de transformación:","CA=1,38E-04I2-1,89E-02I+1","0<I<50"]
["Indicador:","Turbidez de las aguas",null,"CA=-4,44E-03I+6,22E-01","50<I<140"]
["fórmula del indicador"]
["unidad del indicador:","unidades Jackson"]
["rango de valores del indicador:","0 - 140","valor del indicador",100]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=50,0.000138*D5^2-0.0189*D5+1,IF(D5<=140,-0.00444*D5+0.622,\"valor del indicador fuera rango\")))","v":{"v":0.17799999999999994,"d":"0.178"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.000138*A8^2-0.0189*A8+1","v":{"v":1,"d":"1.000"}}]
[5,{"v":0.90895,"d":"0.909"}]
[10,{"v":0.8248,"d":"0.825"}]
[15,{"v":0.74755,"d":"0.748"}]
[20,{"v":0.6772,"d":"0.677"}]
[{"$f":"+A12+10","v":30},{"v":0.5572,"d":"0.557"}]
[40,{"v":0.4648,"d":"0.465"}]
[50,{"v":0.3999999999999999,"d":"0.400"}]
[60,{"$f":"-0.00444*A16+0.622","v":{"v":0.35559999999999997,"d":"0.356"}}]
[70,{"v":0.3112,"d":"0.311"}]
[80,{"v":0.2668,"d":"0.267"}]
[90,{"v":0.2224,"d":"0.222"}]
[100,{"v":0.17799999999999994,"d":"0.178"}]
[110,{"v":0.13359999999999994,"d":"0.134"}]
[120,{"v":0.08919999999999995,"d":"0.089"}]
[130,{"v":0.04479999999999995,"d":"0.045"}]
[140,{"v":3.9999999999995595E-4,"d":"0.000"}]

{"sheet":"137","index":4,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[6,2,6,4]]}
["nº de indicador:",137,"función de transformación:","CA=-6,67E-04I2+1","0<I<15"]
["Indicador:","Concentración media de fósforo en las aguas",null,"CA=1,18E-04I2-2,35E-02I+1,180","15<I<100"]
["fórmula del indicador"]
["unidad del indicador:","mg  m-3"]
["rango de valores del indicador:","0 - 100","valor del indicador",30]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=15,-0.000667*D5^2+1,IF(D5<=100,0.000118*D5^2-0.0235*D5+1.18,\"valor del indicador fuera rango\")))","v":{"v":0.5811999999999999,"d":"0.581"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.000667*A8^2+1","v":{"v":1,"d":"1.000"}}]
[2,{"v":0.997332,"d":"0.997"}]
[4,{"v":0.989328,"d":"0.989"}]
[6,{"v":0.975988,"d":"0.976"}]
[8,{"v":0.957312,"d":"0.957"}]
[10,{"v":0.9333,"d":"0.933"}]
[12,{"v":0.903952,"d":"0.904"}]
[15,{"v":0.849925,"d":"0.850"}]
[15,{"$f":"0.000118*(A16^2)-0.0235*A16+1.18","v":{"v":0.85405,"d":"0.854"}}]
[30,{"$f":"0.000118*(A17^2)-0.0235*A17+1.18","v":{"v":0.5811999999999999,"d":"0.581"}}]
[40,{"v":0.42879999999999996,"d":"0.429"}]
[50,{"v":0.2999999999999998,"d":"0.300"}]
[60,{"v":0.19479999999999997,"d":"0.195"}]
[70,{"v":0.11319999999999975,"d":"0.113"}]
[80,{"v":0.055199999999999916,"d":"0.055"}]
[100,{"v":0.009999999999999787,"d":"0.010"}]

{"sheet":"138","index":5,"n_rows":31,"n_cols":5,"rows_kept":31,"merged":[[6,2,6,4]]}
["nº de indicador:",138,"función de transformación:","CA=-2,5E-01I+1","0<I<1"]
["Indicador:","Variación de la peligrosidad potencial",null,"CA=-1,88E-01I+9,38E-01","1<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",3]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=1,-0.25*D5+1,IF(D5<=5,-0.188*D5+0.938,\"valor del indicador fuera rango\")))","v":{"v":0.3739999999999999,"d":"0.374"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.25*A8+1","v":{"v":1,"d":"1.000"}}]
[{"v":0.1,"d":"0.10"},0.975]
[{"v":0.2,"d":"0.20"},{"v":0.95,"d":"0.950"}]
[{"v":0.3,"d":"0.30"},0.925]
[{"v":0.4,"d":"0.40"},{"v":0.9,"d":"0.900"}]
[{"v":0.5,"d":"0.50"},0.875]
[{"$f":"+A13+0.25","v":0.75},{"v":0.8125,"d":"0.813"}]
[{"v":1,"d":"1.00"},{"$f":"-0.25*A15+1","v":{"v":0.75,"d":"0.750"}}]
[1.25,{"$f":"-0.188*A16+0.938","v":0.703}]
[{"v":1.5,"d":"1.50"},{"$f":"-0.188*A17+0.938","v":{"v":0.6559999999999999,"d":"0.656"}}]
[1.75,0.609]
[{"v":2,"d":"2.00"},{"v":0.5619999999999999,"d":"0.562"}]
[2.25,{"v":0.5149999999999999,"d":"0.515"}]
[{"v":2.5,"d":"2.50"},{"v":0.46799999999999997,"d":"0.468"}]
[2.75,{"v":0.42099999999999993,"d":"0.421"}]
[{"v":3,"d":"3.00"},{"v":0.3739999999999999,"d":"0.374"}]
[3.25,{"v":0.32699999999999996,"d":"0.327"}]
[{"v":3.5,"d":"3.50"},{"v":0.2799999999999999,"d":"0.280"}]
[3.75,{"v":0.23299999999999998,"d":"0.233"}]
[{"v":4,"d":"4.00"},{"v":0.18599999999999994,"d":"0.186"}]
[4.25,{"v":0.1389999999999999,"d":"0.139"}]
[{"v":4.5,"d":"4.50"},{"v":0.09199999999999997,"d":"0.092"}]
[4.75,{"v":0.04499999999999993,"d":"0.045"}]
[{"v":5,"d":"5.00"},{"v":0,"d":"0.000"}]

{"sheet":"139-140","index":6,"n_rows":50,"n_cols":5,"rows_kept":50,"merged":[[6,2,6,4],[32,2,32,4]]}
["nº de indicador:",139,"función de transformación:","CA=-1E-01I+1","0<I<5"]
["Indicador:","% de superdicie afectada por procesos de erosión-sedimentación",null,"CA=1,25E-03I2-6,25E-02I+7,81E-01","5<I<25"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 25","valor del indicador",10]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=5,(-0.1*(D5))+1,IF(D5<=25,(0.00125*(D5^2))-(0.0625*D5)+0.781,\"valor del indicador fuera rango\")))","v":0.281}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.1*A8+1","v":{"v":1,"d":"1.000"}}]
[{"v":1,"d":"1.00"},{"v":0.9,"d":"0.900"}]
[{"v":2,"d":"2.00"},{"v":0.8,"d":"0.800"}]
[{"v":3,"d":"3.00"},{"v":0.7,"d":"0.700"}]
[{"v":4,"d":"4.00"},{"v":0.6,"d":"0.600"}]
[{"v":5,"d":"5.00"},{"v":0.5,"d":"0.500"}]
[{"v":6,"d":"6.00"},{"$f":"0.00125*A14^2-0.0625*A14+0.781","v":0.451}]
[{"v":7,"d":"7.00"},{"$f":"0.00125*A15^2-0.0625*A15+0.781","v":{"v":0.40475000000000005,"d":"0.405"}}]
[{"$f":"+A15+2","v":{"v":9,"d":"9.00"}},{"$f":"0.00125*A16^2-0.0625*A16+0.781","v":{"v":0.31975000000000003,"d":"0.320"}}]
[{"v":11,"d":"11.00"},{"$f":"0.00125*A17^2-0.0625*A17+0.781","v":{"v":0.24475000000000002,"d":"0.245"}}]
[{"v":13,"d":"13.00"},{"v":0.17974999999999997,"d":"0.180"}]
[{"v":15,"d":"15.00"},{"v":0.12475000000000003,"d":"0.125"}]
[{"v":17,"d":"17.00"},{"v":0.0797500000000001,"d":"0.080"}]
[{"v":19,"d":"19.00"},{"v":0.044749999999999956,"d":"0.045"}]
[{"v":21,"d":"21.00"},{"v":0.019750000000000045,"d":"0.020"}]
[{"v":23,"d":"23.00"},{"v":4.750000000000032E-3,"d":"0.005"}]
[{"v":25,"d":"25.00"},{"v":-2.4999999999997247E-4,"d":"-0.000"}]
[]
[]
["nº de indicador:",140,"función de transformación:","CA=-1E-01I+1","0<I<5"]
["Indicador:",null,null,"CA=1,25E-03I2-6,25E-02I+7,81E-01","5<I<25"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 25","valor del indicador",11]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D31<0,\"valor del indicador fuera de rango\",IF(D31<=5,(-0.1*(D31^2))+1,IF(D31<=25,(0.00125*(D31^2))-(0.0625*D31)+0.781,\"valor del indicador fuera rango\")))","v":{"v":0.24475000000000002,"d":"0.245"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.1*A34+1","v":{"v":1,"d":"1.000"}}]
[{"v":1,"d":"1.00"},{"v":0.9,"d":"0.900"}]
[{"v":2,"d":"2.00"},{"v":0.8,"d":"0.800"}]
[{"v":3,"d":"3.00"},{"v":0.7,"d":"0.700"}]
[{"v":4,"d":"4.00"},{"v":0.6,"d":"0.600"}]
[{"v":5,"d":"5.00"},{"v":0.5,"d":"0.500"}]
[{"v":6,"d":"6.00"},{"$f":"0.00125*A40^2-0.0625*A40+0.781","v":0.451}]
[{"v":7,"d":"7.00"},{"$f":"0.00125*A41^2-0.0625*A41+0.781","v":{"v":0.40475000000000005,"d":"0.405"}}]
[{"$f":"+A41+2","v":{"v":9,"d":"9.00"}},{"$f":"0.00125*A42^2-0.0625*A42+0.781","v":{"v":0.31975000000000003,"d":"0.320"}}]
[{"v":11,"d":"11.00"},{"$f":"0.00125*A43^2-0.0625*A43+0.781","v":{"v":0.24475000000000002,"d":"0.245"}}]
[{"v":13,"d":"13.00"},{"v":0.17974999999999997,"d":"0.180"}]
[{"v":15,"d":"15.00"},{"v":0.12475000000000003,"d":"0.125"}]
[{"v":17,"d":"17.00"},{"v":0.0797500000000001,"d":"0.080"}]
[{"v":19,"d":"19.00"},{"v":0.044749999999999956,"d":"0.045"}]
[{"v":21,"d":"21.00"},{"v":0.019750000000000045,"d":"0.020"}]
[{"v":23,"d":"23.00"},{"v":4.750000000000032E-3,"d":"0.005"}]
[{"v":25,"d":"25.00"},{"v":-2.4999999999997247E-4,"d":"-0.000"}]

{"sheet":"141","index":7,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",141,"función de transformación:","CA= -4,5E-05*(I^2)+5,5E-03*I+1","(-100)<I<0"]
["Indicador:",null,null,"CA=1","0<I<20"]
["fórmula del indicador",null,null,"CA=-1,56E-04*(I^2)+6,25E-03*(I)+9,38E-01","20<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",32]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-100,\"valor del indicador fuera de rango\",IF(D5<=0,-0.000045*D5^2+0.0055*D5+1,IF(D5<=20,1,IF(D5<=100,-0.000156*D5^2+0.00625*D5+0.938,\"valor del indicador fuera rango\"))))","v":{"v":0.978256,"d":"0.978"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-100,"d":"-100.00"},{"$f":"-0.000045*(A8^2)+0.0055*A8+1","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+12","v":{"v":-88,"d":"-88.00"}},{"$f":"-0.000045*(A9^2)+0.0055*A9+1","v":{"v":0.16752,"d":"0.168"}}]
[{"$f":"+A9+12","v":{"v":-76,"d":"-76.00"}},{"v":0.3220799999999999,"d":"0.322"}]
[{"v":-64,"d":"-64.00"},{"v":0.46368,"d":"0.464"}]
[{"v":-52,"d":"-52.00"},{"v":0.59232,"d":"0.592"}]
[{"v":-40,"d":"-40.00"},0.708]
[{"v":-28,"d":"-28.00"},{"v":0.81072,"d":"0.811"}]
[{"v":-16,"d":"-16.00"},{"v":0.90048,"d":"0.900"}]
[{"v":-4,"d":"-4.00"},{"v":0.97728,"d":"0.977"}]
[{"v":8,"d":"8.00"},{"v":1,"d":"1.000"}]
[{"v":20,"d":"20.00"},{"v":1,"d":"1.000"}]
[{"v":32,"d":"32.00"},{"$f":"-0.000156*(A19^2)+0.00625*A19+0.938","v":{"v":0.978256,"d":"0.978"}}]
[{"v":44,"d":"44.00"},{"$f":"-0.000156*(A20^2)+0.00625*A20+0.938","v":{"v":0.910984,"d":"0.911"}}]
[{"v":56,"d":"56.00"},{"v":0.7987839999999999,"d":"0.799"}]
[{"v":68,"d":"68.00"},{"v":0.641656,"d":"0.642"}]
[{"v":80,"d":"80.00"},{"v":0.4396,"d":"0.440"}]
[{"v":92,"d":"92.00"},{"v":0.192616,"d":"0.193"}]
[{"v":100,"d":"100.00"},{"v":2.9999999999998916E-3,"d":"0.003"}]

{"sheet":"142-145","index":8,"n_rows":102,"n_cols":5,"rows_kept":102,"merged":[[6,2,6,4],[32,2,32,4],[58,2,58,4],[84,2,84,4]]}
["nº de indicador:",142,"función de transformación:","CA= 1E-04*(I^2)+2E-02*I+1,500","(-100)<I<(-50)"]
["Indicador:","Variación del tiempo de permanencia del agua en la superficie respecto a la situación \"sin\" proyecto (núcleos urbanos)",null,"CA=-4E-04*(I^2)-2E-02*I+7,5E-01","(-50)<I<0"]
["fórmula del indicador",null,null,"CA= 7,5-05*(I^2)-1,5E-02*I+7,5E-01","0<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",90]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-100,\"valor del indicador fuera de rango\",IF(D5<=-50,0.0001*(D5^2)+(0.02*D5)+1.5,IF(D5<=0,(-0.0004*(D5^2))-(0.02*D5)+0.75,IF(D5<=100,0.000075*(D5^2)-0.015*D5+0.75,\"valor del indicador fuera rango\"))))","v":{"v":0.007500000000000062,"d":"0.008"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-100,"d":"-100.00"},{"$f":"0.0001*(A8^2)+0.02*(A8)+1.5","v":{"v":0.5,"d":"0.500"}}]
[{"v":-80,"d":"-80.00"},{"$f":"0.0001*(A9^2)+0.02*(A9)+1.5","v":{"v":0.5399999999999999,"d":"0.540"}}]
[{"v":-60,"d":"-60.00"},{"$f":"0.0001*(A10^2)+0.02*(A10)+1.5","v":{"v":0.6600000000000001,"d":"0.660"}}]
[{"v":-55,"d":"-55.00"},{"$f":"0.0001*(A11^2)+0.02*(A11)+1.5","v":{"v":0.7024999999999999,"d":"0.703"}}]
[{"v":-50,"d":"-50.00"},{"$f":"0.0001*(A12^2)+0.02*(A12)+1.5","v":{"v":0.75,"d":"0.750"}}]
[{"v":-40,"d":"-40.00"},{"$f":"-0.0004*(A13^2)-0.02*(A13)+0.75","v":{"v":0.91,"d":"0.910"}}]
[{"v":-30,"d":"-30.00"},{"$f":"-0.0004*(A14^2)-0.02*(A14)+0.75","v":{"v":0.99,"d":"0.990"}}]
[{"v":-20,"d":"-20.00"},{"$f":"-0.0004*(A15^2)-0.02*(A15)+0.75","v":{"v":0.99,"d":"0.990"}}]
[{"v":-10,"d":"-10.00"},{"$f":"-0.0004*(A16^2)-0.02*(A16)+0.75","v":{"v":0.91,"d":"0.910"}}]
[{"v":0,"d":"0.00"},{"$f":"-0.0004*(A17^2)-0.02*(A17)+0.75","v":{"v":0.75,"d":"0.750"}}]
[{"v":10,"d":"10.00"},{"$f":"0.000075*(A18)*(A18)-0.015*(A18)+0.75","v":{"v":0.6075,"d":"0.608"}}]
[{"v":32,"d":"32.00"},{"v":0.3468,"d":"0.347"}]
[{"v":44,"d":"44.00"},{"v":0.23520000000000008,"d":"0.235"}]
[{"v":56,"d":"56.00"},{"v":0.1452,"d":"0.145"}]
[{"v":68,"d":"68.00"},{"v":0.07679999999999998,"d":"0.077"}]
[{"v":80,"d":"80.00"},{"v":0.030000000000000027,"d":"0.030"}]
[{"v":100,"d":"100.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",143,"función de transformación:","CA= 6E-05(I^2)+1,2E-0,2*I+1,2","(-100)<I<(-50)"]
["Indicador:","Variación del tiempo de permanencia del agua en la superficie respecto a la situación \"sin\" proyecto (núcleos no urbanos)",null,"CA= -4E-04*(I^2)-2E-02*I+7,5E-01","(-50)<I<0"]
["fórmula del indicador",null,null,"CA= -7,5E-03*I+7,5E-01","0<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",90]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D31<-100,\"valor del indicador fuera de rango\",IF(D31<=-50,0.00006*(D31^2)+(0.012*D31)+1.2,IF(D31<=0,(-0.0004*(D31^2))-(0.02*D31)+0.75,IF(D31<=100,-0.0075*(D31)+0.75,\"valor del indicador fuera rango\"))))","v":{"v":0.07500000000000007,"d":"0.075"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-100,"d":"-100.00"},{"$f":"0.00006*(A34^2)+0.012*A34+1.2","v":{"v":0.6,"d":"0.600"}}]
[{"v":-80,"d":"-80.00"},{"$f":"0.00006*(A35^2)+0.012*A35+1.2","v":0.624}]
[{"v":-60,"d":"-60.00"},{"$f":"0.00006*(A36^2)+0.012*A36+1.2","v":0.696}]
[{"v":-55,"d":"-55.00"},{"$f":"0.00006*(A37^2)+0.012*A37+1.2","v":{"v":0.7214999999999999,"d":"0.722"}}]
[{"v":-50,"d":"-50.00"},{"$f":"0.00006*(A38^2)+0.012*A38+1.2","v":{"v":0.75,"d":"0.750"}}]
[{"v":-40,"d":"-40.00"},{"$f":"-0.0004*(A39^2)-0.02*A39+0.75","v":{"v":0.91,"d":"0.910"}}]
[{"v":-30,"d":"-30.00"},{"$f":"-0.0004*(A40^2)-0.02*A40+0.75","v":{"v":0.99,"d":"0.990"}}]
[{"v":-20,"d":"-20.00"},{"$f":"-0.0004*(A41^2)-0.02*A41+0.75","v":{"v":0.99,"d":"0.990"}}]
[{"v":-10,"d":"-10.00"},{"$f":"-0.0004*(A42^2)-0.02*A42+0.75","v":{"v":0.91,"d":"0.910"}}]
[{"v":0,"d":"0.00"},{"$f":"-0.0004*(A43^2)-0.02*A43+0.75","v":{"v":0.75,"d":"0.750"}}]
[{"v":10,"d":"10.00"},{"$f":"-0.0075*A44+0.75","v":0.675}]
[{"v":32,"d":"32.00"},{"v":0.51,"d":"0.510"}]
[{"v":44,"d":"44.00"},{"v":0.42000000000000004,"d":"0.420"}]
[{"v":56,"d":"56.00"},{"v":0.33,"d":"0.330"}]
[{"v":68,"d":"68.00"},{"v":0.24,"d":"0.240"}]
[{"v":80,"d":"80.00"},{"v":0.15000000000000002,"d":"0.150"}]
[{"v":100,"d":"100.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",144,"función de transformación:","CA= 1E-04*(I^2)+2E-02*I+1,500","(-100)<I<(-50)"]
["Indicador:","Variación del tiempo de permanencia del agua en la superficie respecto a las condiciones naturales (núcleos urbanos)",null,"CA=-4E-04*(I^2)-2E-02*I+7,5E-01","(-50)<I<0"]
["fórmula del indicador",null,null,"CA= 7,5-05*(I^2)-1,5E-02*I+7,5E-01","0<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",90]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D57<-100,\"valor del indicador fuera de rango\",IF(D57<=-50,0.0001*(D57^2)+(0.02*D57)+1.5,IF(D57<=0,(-0.0004*(D57^2))-(0.02*D57)+0.75,IF(D57<=100,0.000075*(D57^2)-0.015*D57+0.75,\"valor del indicador fuera rango\"))))","v":{"v":0.007500000000000062,"d":"0.008"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-100,"d":"-100.00"},{"$f":"0.0001*(A60^2)+0.02*(A60)+1.5","v":{"v":0.5,"d":"0.500"}}]
[{"v":-80,"d":"-80.00"},{"$f":"0.0001*(A61^2)+0.02*(A61)+1.5","v":{"v":0.5399999999999999,"d":"0.540"}}]
[{"v":-60,"d":"-60.00"},{"$f":"0.0001*(A62^2)+0.02*(A62)+1.5","v":{"v":0.6600000000000001,"d":"0.660"}}]
[{"v":-55,"d":"-55.00"},{"$f":"0.0001*(A63^2)+0.02*(A63)+1.5","v":{"v":0.7024999999999999,"d":"0.703"}}]
[{"v":-50,"d":"-50.00"},{"$f":"0.0001*(A64^2)+0.02*(A64)+1.5","v":{"v":0.75,"d":"0.750"}}]
[{"v":-40,"d":"-40.00"},{"$f":"-0.0004*(A65^2)-0.02*(A65)+0.75","v":{"v":0.91,"d":"0.910"}}]
[{"v":-30,"d":"-30.00"},{"$f":"-0.0004*(A66^2)-0.02*(A66)+0.75","v":{"v":0.99,"d":"0.990"}}]
[{"v":-20,"d":"-20.00"},{"$f":"-0.0004*(A67^2)-0.02*(A67)+0.75","v":{"v":0.99,"d":"0.990"}}]
[{"v":-10,"d":"-10.00"},{"$f":"-0.0004*(A68^2)-0.02*(A68)+0.75","v":{"v":0.91,"d":"0.910"}}]
[{"v":0,"d":"0.00"},{"$f":"-0.0004*(A69^2)-0.02*(A69)+0.75","v":{"v":0.75,"d":"0.750"}}]
[{"v":10,"d":"10.00"},{"$f":"0.000075*(A70)*(A70)-0.015*(A70)+0.75","v":{"v":0.6075,"d":"0.608"}}]
[{"v":32,"d":"32.00"},{"v":0.3468,"d":"0.347"}]
[{"v":44,"d":"44.00"},{"v":0.23520000000000008,"d":"0.235"}]
[{"v":56,"d":"56.00"},{"v":0.1452,"d":"0.145"}]
[{"v":68,"d":"68.00"},{"v":0.07679999999999998,"d":"0.077"}]
[{"v":80,"d":"80.00"},{"v":0.030000000000000027,"d":"0.030"}]
[{"v":100,"d":"100.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",145,"función de transformación:","CA= 6E-05(I^2)+1,2E-0,2*I+1,2","(-100)<I<(-50)"]
["Indicador:","Variación del tiempo de permanencia del agua en la superficie respecto a las condiciones naturales (núcleos no urbanos)",null,"CA= -4E-04*(I^2)-2E-02*I+7,5E-01","(-50)<I<0"]
["fórmula del indicador",null,null,"CA= -7,5E-03*I+7,5E-01","0<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",90]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D83<-100,\"valor del indicador fuera de rango\",IF(D83<=-50,0.00006*(D83^2)+(0.012*D83)+1.2,IF(D83<=0,(-0.0004*(D83^2))-(0.02*D83)+0.75,IF(D83<=100,-0.0075*(D83)+0.75,\"valor del indicador fuera rango\"))))","v":{"v":0.07500000000000007,"d":"0.075"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-100,"d":"-100.00"},{"$f":"0.00006*(A86^2)+0.012*A86+1.2","v":{"v":0.6,"d":"0.600"}}]
[{"v":-80,"d":"-80.00"},{"$f":"0.00006*(A87^2)+0.012*A87+1.2","v":0.624}]
[{"v":-60,"d":"-60.00"},{"$f":"0.00006*(A88^2)+0.012*A88+1.2","v":0.696}]
[{"v":-55,"d":"-55.00"},{"$f":"0.00006*(A89^2)+0.012*A89+1.2","v":{"v":0.7214999999999999,"d":"0.722"}}]
[{"v":-50,"d":"-50.00"},{"$f":"0.00006*(A90^2)+0.012*A90+1.2","v":{"v":0.75,"d":"0.750"}}]
[{"v":-40,"d":"-40.00"},{"$f":"-0.0004*(A91^2)-0.02*A91+0.75","v":{"v":0.91,"d":"0.910"}}]
[{"v":-30,"d":"-30.00"},{"$f":"-0.0004*(A92^2)-0.02*A92+0.75","v":{"v":0.99,"d":"0.990"}}]
[{"v":-20,"d":"-20.00"},{"$f":"-0.0004*(A93^2)-0.02*A93+0.75","v":{"v":0.99,"d":"0.990"}}]
[{"v":-10,"d":"-10.00"},{"$f":"-0.0004*(A94^2)-0.02*A94+0.75","v":{"v":0.91,"d":"0.910"}}]
[{"v":0,"d":"0.00"},{"$f":"-0.0004*(A95^2)-0.02*A95+0.75","v":{"v":0.75,"d":"0.750"}}]
[{"v":10,"d":"10.00"},{"$f":"-0.0075*A96+0.75","v":0.675}]
[{"v":32,"d":"32.00"},{"v":0.51,"d":"0.510"}]
[{"v":44,"d":"44.00"},{"v":0.42000000000000004,"d":"0.420"}]
[{"v":56,"d":"56.00"},{"v":0.33,"d":"0.330"}]
[{"v":68,"d":"68.00"},{"v":0.24,"d":"0.240"}]
[{"v":80,"d":"80.00"},{"v":0.15000000000000002,"d":"0.150"}]
[{"v":100,"d":"100.00"},{"v":0,"d":"0.000"}]

{"sheet":"146-147","index":9,"n_rows":58,"n_cols":5,"rows_kept":58,"merged":[[6,2,6,4],[36,2,36,4]]}
["nº de indicador:",146,"función de transformación:","CA=1","0>I>(-100)"]
["Indicador:","Variación del riesgo de inundaciones ponderado según el daño potencial",null,"CA=-1*E-4*I2+1","0<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",10]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-100,\"valor del indicador fuera de rango\",IF(D5<=0,1,IF(D5<=100,(-0.0001*(D5^2))+1,\"valor del indicador fuera de rango\")))","v":{"v":0.99,"d":"0.990"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-100,"d":"-100.00"},{"v":1,"d":"1.000"}]
[{"$f":"+A8+10","v":{"v":-90,"d":"-90.00"}},{"v":1,"d":"1.000"}]
[{"$f":"+A9+10","v":{"v":-80,"d":"-80.00"}},{"v":1,"d":"1.000"}]
[{"v":-70,"d":"-70.00"},{"v":1,"d":"1.000"}]
[{"v":-60,"d":"-60.00"},{"v":1,"d":"1.000"}]
[{"v":-50,"d":"-50.00"},{"v":1,"d":"1.000"}]
[{"v":-40,"d":"-40.00"},{"v":1,"d":"1.000"}]
[{"v":-30,"d":"-30.00"},{"v":1,"d":"1.000"}]
[{"v":-20,"d":"-20.00"},{"v":1,"d":"1.000"}]
[{"v":-10,"d":"-10.00"},{"v":1,"d":"1.000"}]
[{"v":0,"d":"0.00"},{"v":1,"d":"1.000"}]
[{"v":10,"d":"10.00"},{"$f":"-0.0001*A19^2+1","v":{"v":0.99,"d":"0.990"}}]
[{"v":20,"d":"20.00"},{"v":0.96,"d":"0.960"}]
[{"v":30,"d":"30.00"},{"v":0.91,"d":"0.910"}]
[{"v":40,"d":"40.00"},{"v":0.84,"d":"0.840"}]
[{"v":50,"d":"50.00"},{"v":0.75,"d":"0.750"}]
[{"v":60,"d":"60.00"},{"v":0.6399999999999999,"d":"0.640"}]
[{"v":70,"d":"70.00"},{"v":0.51,"d":"0.510"}]
[{"v":80,"d":"80.00"},{"v":0.36,"d":"0.360"}]
[{"v":90,"d":"90.00"},{"v":0.18999999999999995,"d":"0.190"}]
[{"v":100,"d":"100.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",147,"función de transformación:","CA=2E-4*I2+4E-2*I+2","( -100)<I<(-50)"]
["Indicador:","Variación del riesgo de inundaciones con respecto a las condiciones naturales ponderado por el daño potencial",null,"CA=-2E-4*I2+1","(-50)<I<50"]
["fórmula del indicador",null,null,"CA=2E-4*I2+4E-2*I+2","50<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",10]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D35<-100,\"valor del indicador fuera de rango\",IF(D35<=-50,0.0002*D35^2+0.04*D35+2,IF(D35<=50,-0.0002*D35^2+1,IF(D35<=100,0.0002*D35^2-0.04*D35+2,\"valor del indicador fuera de rango\"))))","v":{"v":0.98,"d":"0.980"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-100,"d":"-100.00"},{"$f":"0.0002*A38^2+0.04*A38+2","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A38+10","v":{"v":-90,"d":"-90.00"}},{"v":0.020000000000000018,"d":"0.020"}]
[{"$f":"+A39+10","v":{"v":-80,"d":"-80.00"}},{"v":0.07999999999999985,"d":"0.080"}]
[{"v":-70,"d":"-70.00"},{"v":0.17999999999999972,"d":"0.180"}]
[{"v":-60,"d":"-60.00"},{"v":0.3200000000000003,"d":"0.320"}]
[{"v":-50,"d":"-50.00"},{"v":0.5,"d":"0.500"}]
[{"v":-40,"d":"-40.00"},{"$f":"-0.0002*A44^2+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[{"v":-30,"d":"-30.00"},{"v":0.82,"d":"0.820"}]
[{"v":-20,"d":"-20.00"},{"v":0.92,"d":"0.920"}]
[{"v":-10,"d":"-10.00"},{"v":0.98,"d":"0.980"}]
[{"v":0,"d":"0.00"},{"v":1,"d":"1.000"}]
[{"v":10,"d":"10.00"},{"v":0.98,"d":"0.980"}]
[{"v":20,"d":"20.00"},{"v":0.92,"d":"0.920"}]
[{"v":30,"d":"30.00"},{"v":0.82,"d":"0.820"}]
[{"v":40,"d":"40.00"},{"v":0.6799999999999999,"d":"0.680"}]
[{"v":50,"d":"50.00"},{"v":0.5,"d":"0.500"}]
[{"v":60,"d":"60.00"},{"$f":"0.0002*A54^2-0.04*A54+2","v":{"v":0.3200000000000003,"d":"0.320"}}]
[{"v":70,"d":"70.00"},{"$f":"0.0002*A55^2-0.04*A55+2","v":{"v":0.17999999999999972,"d":"0.180"}}]
[{"v":80,"d":"80.00"},{"$f":"0.0002*A56^2-0.04*A56+2","v":{"v":0.07999999999999985,"d":"0.080"}}]
[{"v":90,"d":"90.00"},{"$f":"0.0002*A57^2-0.04*A57+2","v":{"v":0.020000000000000018,"d":"0.020"}}]
[{"v":100,"d":"100.00"},{"$f":"0.0002*A58^2-0.04*A58+2","v":{"v":0,"d":"0.000"}}]

{"sheet":"148-149","index":10,"n_rows":54,"n_cols":5,"rows_kept":54,"merged":[[6,2,6,4],[36,2,36,4]]}
["nº de indicador:",148,"función de transformación:","CA=-6E-3*I2+1","0<I<5"]
["Indicador:","Media ponderada de los materiales desplazados según la superficie de zonas homogéneas",null,"CA=2,13E-3*I2-1,06E-1*I+1,330","5<I<25"]
["fórmula del indicador",null,null,"CA=0","25<I<100"]
["unidad del indicador:","T ha-1 año-1"]
["rango de valores del indicador:","0     -   100","valor del indicador",40]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=5,-0.006*D5^2+1,IF(D5<=25,0.00213*D5^2-0.106*D5+1.33,IF(D5<=100,0,\"valor del indicador fuera de rango\"))))","v":{"v":0,"d":"0.000"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.006*A8^2+1","v":{"v":1,"d":"1.000"}}]
[2,{"$f":"-0.006*A9^2+1","v":0.976}]
[4,{"$f":"-0.006*A10^2+1","v":0.904}]
[5,{"$f":"-0.006*A11^2+1","v":{"v":0.85,"d":"0.850"}}]
[9,{"$f":"0.00213*A12^2-0.106*A12+1.33","v":{"v":0.5485300000000001,"d":"0.549"}}]
[{"$f":"+A12+2","v":11},{"v":0.42173000000000016,"d":"0.422"}]
[{"$f":"+A13+2","v":13},{"v":0.3119700000000001,"d":"0.312"}]
[15,{"v":0.21925000000000017,"d":"0.219"}]
[17,{"v":0.14356999999999998,"d":"0.144"}]
[19,{"v":0.0849300000000004,"d":"0.085"}]
[21,{"v":0.04333000000000009,"d":"0.043"}]
[23,{"v":0.018770000000000397,"d":"0.019"}]
[25,{"v":0,"d":"0.000"}]
[35,{"v":0,"d":"0.000"}]
[45,{"v":0,"d":"0.000"}]
[{"$f":"+A22+10","v":55},{"v":0,"d":"0.000"}]
[{"$f":"+A23+10","v":65},{"v":0,"d":"0.000"}]
[{"$f":"+A24+10","v":75},{"v":0,"d":"0.000"}]
[{"$f":"+A25+10","v":85},{"v":0,"d":"0.000"}]
[95,{"v":0,"d":"0.000"}]
[100,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",149,"función de transformación:","CA=-1,21E-1*I2+1","0<I<1,7"]
["Indicador:","Materiales desplazados por erosión eólica",null,"CA=5,97E-2*I2-5,97E-1*I+1,490","1,7<I<5"]
["fórmula del indicador"]
["unidad del indicador:","kg m-2 a-1"]
["rango de valores del indicador:","0 - 5","valor del indicador",3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D35<0,\"valor del indicador fuera de rango\",IF(D35<=1.7,-0.121*D35^2+1,IF(D35<=5,0.0597*D35^2-0.597*D35+1.49,\"valor del indicador fuera de rango\")))","v":{"v":0.23630000000000018,"d":"0.236"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.121*A38^2+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A38+0.3","v":0.3},{"v":0.98911,"d":"0.989"}]
[{"$f":"+A39+0.3","v":0.6},{"v":0.95644,"d":"0.956"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.9019900000000001,"d":"0.902"}]
[1.2,{"v":0.82576,"d":"0.826"}]
[1.5,{"v":0.72775,"d":"0.728"}]
[1.8,{"$f":"0.0597*A44^2-0.597*A44+1.49","v":{"v":0.608828,"d":"0.609"}}]
[2.1,{"v":0.49957699999999994,"d":"0.500"}]
[2.4,{"v":0.4010720000000001,"d":"0.401"}]
[{"v":2.6999999999999997,"d":"2.7"},{"v":0.3133130000000002,"d":"0.313"}]
[{"v":2.9999999999999996,"d":"3.0"},{"v":0.23630000000000018,"d":"0.236"}]
[{"v":3.2999999999999994,"d":"3.3"},{"v":0.17003300000000032,"d":"0.170"}]
[{"v":3.599999999999999,"d":"3.6"},{"v":0.11451200000000017,"d":"0.115"}]
[{"v":3.899999999999999,"d":"3.9"},{"v":0.06973700000000038,"d":"0.070"}]
[{"v":4.199999999999999,"d":"4.2"},{"v":0.03570800000000007,"d":"0.036"}]
[{"v":4.499999999999999,"d":"4.5"},{"v":0.012425000000000352,"d":"0.012"}]
[{"v":5,"d":"5.0"},{"v":0,"d":"0.000"}]

{"sheet":"150","index":11,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[6,2,6,4]]}
["nº de indicador:",150,"función de transformación:","CA=-1E-4*I2+1","(-100)<I<0"]
["Indicador:","Variación del volumen de deposición en zonas sensibles con respecto a las condiciones naturales",null,"CA=-6,4E-5*I2-3,6E-3*I+1","0<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",10]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-100,\"valor del indicador fuera de rango\",IF(D5<=0,-0.0001*D5^2+1,IF(D5<=100,-0.000064*D5^2-0.0036*D5+1,\"valor del indicador fuera de rango\")))","v":{"v":0.9576,"d":"0.958"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-100,"d":"-100.00"},{"$f":"-0.0001*A8^2+1","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+10","v":{"v":-90,"d":"-90.00"}},{"v":0.18999999999999995,"d":"0.190"}]
[{"$f":"+A9+10","v":{"v":-80,"d":"-80.00"}},{"v":0.36,"d":"0.360"}]
[{"v":-70,"d":"-70.00"},{"v":0.51,"d":"0.510"}]
[{"v":-60,"d":"-60.00"},{"v":0.6399999999999999,"d":"0.640"}]
[{"v":-50,"d":"-50.00"},{"v":0.75,"d":"0.750"}]
[{"v":-40,"d":"-40.00"},{"v":0.84,"d":"0.840"}]
[{"v":-30,"d":"-30.00"},{"v":0.91,"d":"0.910"}]
[{"v":-20,"d":"-20.00"},{"v":0.96,"d":"0.960"}]
[{"v":-10,"d":"-10.00"},{"v":0.99,"d":"0.990"}]
[{"v":0,"d":"0.00"},{"v":1,"d":"1.000"}]
[{"v":10,"d":"10.00"},{"$f":"-0.000064*(A19^2)-0.0036*A19+1","v":{"v":0.9576,"d":"0.958"}}]
[{"v":20,"d":"20.00"},{"$f":"-0.000064*(A20^2)-0.0036*A20+1","v":{"v":0.9024,"d":"0.902"}}]
[{"v":30,"d":"30.00"},{"v":0.8344,"d":"0.834"}]
[{"v":40,"d":"40.00"},{"v":0.7536,"d":"0.754"}]
[{"v":50,"d":"50.00"},{"v":0.66,"d":"0.660"}]
[{"v":70,"d":"70.00"},{"v":0.4344,"d":"0.434"}]
[{"v":90,"d":"90.00"},{"$f":"-0.000064*(A25^2)-0.0036*A25+1","v":{"v":0.15759999999999996,"d":"0.158"}}]
[{"v":100,"d":"100.00"},{"v":0,"d":"0.000"}]

{"sheet":"151-152","index":12,"n_rows":63,"n_cols":5,"rows_kept":63,"merged":[[6,2,6,4],[36,2,36,4]]}
["nº de indicador:",151,"función de transformación:","CA=1"," -100<I<0"]
["Indicador:","Variación de los riesgos existentes",null,"CA=-1E-02x+1","0<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",20]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-100,\"valor del indicador fuera de rango\",IF(D5<=0,1,IF(D5<=100,(-0.01*D5+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":-100,"d":"-100.00"},{"v":1,"d":"1.000"}]
[{"$f":"+A8+10","v":{"v":-90,"d":"-90.00"}},{"v":1,"d":"1.000"}]
[{"$f":"+A9+10","v":{"v":-80,"d":"-80.00"}},{"v":1,"d":"1.000"}]
[{"v":-70,"d":"-70.00"},{"v":1,"d":"1.000"}]
[{"v":-60,"d":"-60.00"},{"v":1,"d":"1.000"}]
[{"v":-50,"d":"-50.00"},{"v":1,"d":"1.000"}]
[{"v":-40,"d":"-40.00"},{"v":1,"d":"1.000"}]
[{"v":-30,"d":"-30.00"},{"v":1,"d":"1.000"}]
[{"v":-20,"d":"-20.00"},{"v":1,"d":"1.000"}]
[{"v":-10,"d":"-10.00"},{"v":1,"d":"1.000"}]
[{"v":0,"d":"0.00"},{"v":1,"d":"1.000"}]
[{"v":10,"d":"10.00"},{"$f":"-0.01*A19+1","v":{"v":0.9,"d":"0.90"}}]
[{"v":20,"d":"20.00"},{"v":0.8,"d":"0.80"}]
[{"v":30,"d":"30.00"},{"v":0.7,"d":"0.70"}]
[{"v":40,"d":"40.00"},{"v":0.6,"d":"0.60"}]
[{"v":50,"d":"50.00"},{"v":0.5,"d":"0.50"}]
[{"v":60,"d":"60.00"},{"v":0.4,"d":"0.40"}]
[{"v":70,"d":"70.00"},{"v":0.29999999999999993,"d":"0.30"}]
[{"v":80,"d":"80.00"},{"v":0.19999999999999996,"d":"0.20"}]
[{"v":90,"d":"90.00"},{"v":0.09999999999999998,"d":"0.10"}]
[{"v":100,"d":"100.00"},{"v":0,"d":"0.00"}]
[]
[]
["nº de indicador:",152,"función de transformación:","CA=1"," -100<I<0"]
["Indicador:","Variación de los riesgos existentes ponderados según el valor ambiental y el daño potencial",null,"CA=-1E-02x+1","0<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100     -   100","valor del indicador",20]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D35<-100,\"valor del indicador fuera de rango\",IF(D35<=0,1,IF(D35<=100,(-0.01*D35+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":-100,"d":"-100.00"},{"v":1,"d":"1.000"}]
[{"$f":"+A38+10","v":{"v":-90,"d":"-90.00"}},{"v":1,"d":"1.000"}]
[{"$f":"+A39+10","v":{"v":-80,"d":"-80.00"}},{"v":1,"d":"1.000"}]
[{"v":-70,"d":"-70.00"},{"v":1,"d":"1.000"}]
[{"v":-60,"d":"-60.00"},{"v":1,"d":"1.000"}]
[{"v":-50,"d":"-50.00"},{"v":1,"d":"1.000"}]
[{"v":-40,"d":"-40.00"},{"v":1,"d":"1.000"}]
[{"v":-30,"d":"-30.00"},{"v":1,"d":"1.000"}]
[{"v":-20,"d":"-20.00"},{"v":1,"d":"1.000"}]
[{"v":-10,"d":"-10.00"},{"v":1,"d":"1.000"}]
[{"v":0,"d":"0.00"},{"v":1,"d":"1.000"}]
[{"v":10,"d":"10.00"},{"$f":"-0.01*A49+1","v":{"v":0.9,"d":"0.90"}}]
[{"v":20,"d":"20.00"},{"v":0.8,"d":"0.80"}]
[{"v":30,"d":"30.00"},{"v":0.7,"d":"0.70"}]
[{"v":40,"d":"40.00"},{"v":0.6,"d":"0.60"}]
[{"v":50,"d":"50.00"},{"v":0.5,"d":"0.50"}]
[{"$f":"+A53+5","v":{"v":55,"d":"55.00"}},{"v":0.44999999999999996,"d":"0.45"}]
[{"v":60,"d":"60.00"},{"v":0.4,"d":"0.40"}]
[{"v":65,"d":"65.00"},0.35]
[{"v":70,"d":"70.00"},{"v":0.29999999999999993,"d":"0.30"}]
[{"v":75,"d":"75.00"},0.25]
[{"v":80,"d":"80.00"},{"v":0.19999999999999996,"d":"0.20"}]
[{"v":85,"d":"85.00"},{"v":0.15000000000000002,"d":"0.15"}]
[{"v":90,"d":"90.00"},{"v":0.09999999999999998,"d":"0.10"}]
[{"v":95,"d":"95.00"},{"v":0.04999999999999993,"d":"0.05"}]
[{"v":100,"d":"100.00"},{"v":0,"d":"0.00"}]

{"sheet":"153","index":13,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[6,2,6,4]]}
["nº de indicador:",153,"función de transformación:","CA=-8,89E-05x2+1,33E-02x+5E-0,1","0<I<75"]
["Indicador:","variación de la compactación del terreno en relación a las condiciones naturales",null,"CA=1","75<I<100"]
["fórmula del indicador",null,null,"CA=-1E-04x2+2E-02x","100<I<200"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 200","valor del indicador",105]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=75,-0.0000889*D5^2+0.0133*D5+0.5,IF(D5<=100,1,IF(D5<=200,-0.0001*D5^2+0.02*D5,\"valor del indicador fuera rango\"))))","v":{"v":0.9975,"d":"0.998"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0000889*A8^2+0.0133*A8+0.5","v":{"v":0.5,"d":"0.500"}}]
[10,{"v":0.62411,"d":"0.624"}]
[20,{"v":0.73044,"d":"0.730"}]
[30,{"v":0.8189899999999999,"d":"0.819"}]
[40,{"v":0.88976,"d":"0.890"}]
[50,{"v":0.94275,"d":"0.943"}]
[60,{"v":0.9779599999999999,"d":"0.978"}]
[70,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[80,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[90,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[100,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[120,{"$f":"-0.0001*A19^2+0.02*A19","v":{"v":0.9599999999999997,"d":"0.960"}}]
[140,{"$f":"-0.0001*A20^2+0.02*A20","v":{"v":0.8400000000000001,"d":"0.840"}}]
[160,{"$f":"-0.0001*A21^2+0.02*A21","v":{"v":0.6400000000000001,"d":"0.640"}}]
[180,{"$f":"-0.0001*A22^2+0.02*A22","v":{"v":0.3599999999999999,"d":"0.360"}}]
[200,{"$f":"-0.0001*A23^2+0.02*A23","v":{"v":0,"d":"0.000"}}]