{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Registro","270-274","275"],"not_rendered":{"charts":6,"images":4,"external_links":10,"defined_names":51},"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":"270-274","index":1,"n_rows":146,"n_cols":5,"rows_kept":146,"merged":[[6,2,6,4],[36,2,36,4],[66,2,66,4],[96,2,96,4],[126,2,126,4]]}
["nº de indicador:",270,"función de transformación:","CA=(1E-04*I^2) +(2E-02*I) + 1"," - 100<I<0"]
["Indicador:","% de disminución del sector agrícola "]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",-12]
["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)+(0.02*(D5))+1,\"valor del indicador fuera rango\"))","v":{"v":0.7744,"d":"0.774"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-100,{"$f":"0.0001*(A8^2)+(0.02*A8)+1","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+5","v":-95},{"v":2.4999999999999467E-3,"d":"0.002"}]
[-90,{"v":0.010000000000000009,"d":"0.010"}]
[-85,{"v":0.022500000000000075,"d":"0.023"}]
[-80,{"v":0.039999999999999925,"d":"0.040"}]
[-75,{"v":0.0625,"d":"0.063"}]
[-70,{"v":0.08999999999999986,"d":"0.090"}]
[-65,{"v":0.12250000000000005,"d":"0.123"}]
[-60,{"v":0.16000000000000014,"d":"0.160"}]
[-55,{"v":0.2024999999999999,"d":"0.203"}]
[-50,{"v":0.25,"d":"0.250"}]
[-45,{"v":0.3025,"d":"0.303"}]
[-40,{"v":0.36,"d":"0.360"}]
[-35,{"v":0.4225,"d":"0.423"}]
[-30,{"v":0.49,"d":"0.490"}]
[-25,{"v":0.5625,"d":"0.563"}]
[-20,{"v":0.6399999999999999,"d":"0.640"}]
[-15,{"v":0.7225,"d":"0.723"}]
[-10,{"v":0.81,"d":"0.810"}]
[-5,{"v":0.9025,"d":"0.903"}]
[{"$f":"+A27+5","v":0},{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",271,"función de transformación:","CA=(5E-05*I^2) -(1,5E-02*I) + 1","0<I<100"]
["Indicador:","% de aumento del sector industrial"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",16]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D35<0,\"valor del indicador fuera de rango\",IF(D35<=100,0.00005*(D35^2)-(0.015*D35)+1,\"valor del indicador fuera rango\"))","v":{"v":0.7728,"d":"0.773"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.00005*(A38^2)-(0.015*A38)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A38+5","v":5},{"v":0.92625,"d":"0.926"}]
[{"$f":"+A39+5","v":10},0.855]
[15,{"v":0.78625,"d":"0.786"}]
[20,{"v":0.72,"d":"0.720"}]
[25,{"v":0.65625,"d":"0.656"}]
[30,0.595]
[35,{"v":0.53625,"d":"0.536"}]
[40,{"v":0.48,"d":"0.480"}]
[45,{"v":0.42625,"d":"0.426"}]
[50,0.375]
[55,{"v":0.32625000000000004,"d":"0.326"}]
[60,{"v":0.28000000000000014,"d":"0.280"}]
[65,{"v":0.23625000000000007,"d":"0.236"}]
[70,{"v":0.19499999999999995,"d":"0.195"}]
[75,{"v":0.15625,"d":"0.156"}]
[80,{"v":0.1200000000000001,"d":"0.120"}]
[85,{"v":0.08625000000000016,"d":"0.086"}]
[90,{"v":0.05500000000000016,"d":"0.055"}]
[95,{"v":0.026249999999999996,"d":"0.026"}]
[100,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",272,"función de transformación:","CA=(-1E-04*I^2) + 1","0<I<100"]
["Indicador:","% de aumento del sector servicios"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",16]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D65<0,\"valor del indicador fuera de rango\",IF(D65<=100,-0.0001*(D65^2)+1,\"valor del indicador fuera rango\"))","v":{"v":0.9744,"d":"0.974"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0001*(A68^2)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A68+5","v":5},{"v":0.9975,"d":"0.998"}]
[{"$f":"+A69+5","v":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"}]
[95,{"v":0.09749999999999992,"d":"0.097"}]
[100,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",273,"función de transformación:","CA=(-2E-03*I) + 1","0<I<50"]
["Indicador:","% de aumento del sector construcción",null,"CA=(-1,59E-04*I^2) +(1,19E-02*I) + 7,02E-01","50<I<95"]
["fórmula del indicador",null,null,"CA=(-8E-02*I) + 8","95<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",98]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D95<0,\"valor del indicador fuera de rango\",IF(D95<=50,-0.002*(D95)+1,IF(D95<=95,(-0.000159*(D95^2))+(0.0119*D95)+0.702,IF(D95<=100,-0.08*(D95)+8,\"valor del indicador fuera rango\"))))","v":{"v":0.16000000000000014,"d":"0.160"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"(-0.002*A98)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A98+5","v":5},{"v":0.99,"d":"0.990"}]
[{"$f":"+A99+5","v":10},{"v":0.98,"d":"0.980"}]
[15,{"v":0.97,"d":"0.970"}]
[20,{"v":0.96,"d":"0.960"}]
[25,{"v":0.95,"d":"0.950"}]
[30,{"v":0.94,"d":"0.940"}]
[35,{"v":0.9299999999999999,"d":"0.930"}]
[40,{"v":0.92,"d":"0.920"}]
[45,{"v":0.91,"d":"0.910"}]
[50,{"v":0.9,"d":"0.900"}]
[55,{"$f":"-0.000159*(A109^2)+ (0.0119*A109) +0.702","v":{"v":0.8755250000000001,"d":"0.876"}}]
[60,{"v":0.8436000000000001,"d":"0.844"}]
[65,{"v":0.8037250000000001,"d":"0.804"}]
[70,{"v":0.7559000000000001,"d":"0.756"}]
[75,{"v":0.7001250000000001,"d":"0.700"}]
[80,{"v":0.6364000000000002,"d":"0.636"}]
[85,{"v":0.5647250000000001,"d":"0.565"}]
[94,{"v":0.41567600000000016,"d":"0.416"}]
[95,{"$f":" -0.08*A117 + 8","v":{"v":0.39999999999999947,"d":"0.400"}}]
[100,{"$f":" -0.08*A118 + 8","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",274,"función de transformación:","CA= I","0<I<1"]
["Indicador:","% de variación de la población de cada sector (integración)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 1","valor del indicador",0.2]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D125<0,\"valor del indicador fuera de rango\",IF(D125<=1,1*+D125,\"valor del indicador fuera rango\"))","v":{"v":0.2,"d":"0.200"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"A128","v":{"v":0,"d":"0.000"}}]
[{"v":0.1,"d":"0.10"},{"v":0.1,"d":"0.100"}]
[{"v":0.2,"d":"0.20"},{"v":0.2,"d":"0.200"}]
[{"$f":"+A130+0.05","v":0.25},{"v":0.25,"d":"0.250"}]
[{"v":0.3,"d":"0.30"},{"v":0.3,"d":"0.300"}]
[0.35,{"v":0.35,"d":"0.350"}]
[{"v":0.39999999999999997,"d":"0.40"},{"v":0.39999999999999997,"d":"0.400"}]
[{"v":0.44999999999999996,"d":"0.45"},{"v":0.44999999999999996,"d":"0.450"}]
[{"v":0.49999999999999994,"d":"0.50"},{"v":0.49999999999999994,"d":"0.500"}]
[{"v":0.5499999999999999,"d":"0.55"},{"v":0.5499999999999999,"d":"0.550"}]
[{"v":0.6,"d":"0.60"},{"v":0.6,"d":"0.600"}]
[0.65,{"v":0.65,"d":"0.650"}]
[{"v":0.7000000000000001,"d":"0.70"},{"v":0.7000000000000001,"d":"0.700"}]
[{"v":0.7500000000000001,"d":"0.75"},{"v":0.7500000000000001,"d":"0.750"}]
[{"v":0.8000000000000002,"d":"0.80"},{"v":0.8000000000000002,"d":"0.800"}]
[{"v":0.8500000000000002,"d":"0.85"},{"v":0.8500000000000002,"d":"0.850"}]
[{"v":0.9000000000000002,"d":"0.90"},{"v":0.9000000000000002,"d":"0.900"}]
[{"v":0.9500000000000003,"d":"0.95"},{"v":0.9500000000000003,"d":"0.950"}]
[{"v":1.0000000000000002,"d":"1.00"},{"v":1.0000000000000002,"d":"1.000"}]

{"sheet":"275","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[6,2,6,4]]}
["nº de indicador:",275,"función de transformación:","CA=(-1E-04*I^2) +(2E-02*I) ","0<I<200"]
["Indicador:","% de empleo neto"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 200","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<=200,-0.0001*(D5^2)+(0.02*D5),\"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)+(0.02*A8)","v":{"v":0,"d":"0.000"}}]
[20,{"v":0.36000000000000004,"d":"0.360"}]
[40,{"v":0.64,"d":"0.640"}]
[{"$f":"+A10+10","v":50},{"v":0.75,"d":"0.750"}]
[60,{"v":0.8399999999999999,"d":"0.840"}]
[70,{"v":0.9100000000000001,"d":"0.910"}]
[80,{"v":0.9600000000000001,"d":"0.960"}]
[90,{"v":0.99,"d":"0.990"}]
[100,{"v":1,"d":"1.000"}]
[110,{"v":0.9900000000000002,"d":"0.990"}]
[120,{"v":0.9599999999999997,"d":"0.960"}]
[130,{"v":0.9099999999999999,"d":"0.910"}]
[140,{"v":0.8400000000000001,"d":"0.840"}]
[150,{"v":0.75,"d":"0.750"}]
[160,{"v":0.6400000000000001,"d":"0.640"}]
[170,{"v":0.5099999999999998,"d":"0.510"}]
[180,{"v":0.3599999999999999,"d":"0.360"}]
[190,{"v":0.18999999999999995,"d":"0.190"}]
[200,{"v":0,"d":"0.000"}]