{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Registro","250","251","252-253","254","255"],"not_rendered":{"charts":6,"images":18,"external_links":1,"defined_names":37},"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":"250","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",250,"función de transformación:","CA= -2,78E-02*I^2 + 3,33E-01I","0<I<6"]
["Indicador:","Indicador semicualitativo de variación de la calidad de vida"]
["fórmula del indicador","no hay"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 6","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<=6,-0.0278*(D5^2)+(0.333*D5),\"valor del indicador fuera rango\"))","v":{"v":0.7488000000000001,"d":"0.749"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"-0.0278*A8^2 + 0.333*A8","v":{"v":0,"d":"0.000"}}]
[0.5,{"$f":"-0.0278*A9^2 + 0.333*A9","v":{"v":0.15955,"d":"0.160"}}]
[{"v":1,"d":"1.0"},{"v":0.3052,"d":"0.305"}]
[1.5,{"v":0.43695000000000006,"d":"0.437"}]
[{"v":2,"d":"2.0"},{"v":0.5548000000000001,"d":"0.555"}]
[2.5,{"v":0.6587500000000001,"d":"0.659"}]
[{"v":3,"d":"3.0"},{"v":0.7488000000000001,"d":"0.749"}]
[3.5,{"v":0.8249500000000001,"d":"0.825"}]
[{"v":4,"d":"4.0"},{"v":0.8872000000000001,"d":"0.887"}]
[4.5,{"v":0.9355500000000002,"d":"0.936"}]
[4.8,{"v":0.9578880000000001,"d":"0.958"}]
[{"v":5,"d":"5.0"},{"$f":"-0.0278*A19^2+0.333*A19","v":{"v":0.9700000000000001,"d":"0.970"}}]
[5.5,{"$f":"-0.0278*A20^2+0.333*A20","v":{"v":0.9905500000000002,"d":"0.991"}}]
[{"$f":"+A20+0.1","v":5.6},{"v":0.9929920000000002,"d":"0.993"}]
[{"$f":"+A21+0.1","v":{"v":5.699999999999999,"d":"5.7"}},{"v":0.994878,"d":"0.995"}]
[{"$f":"+A22+0.1","v":{"v":5.799999999999999,"d":"5.8"}},{"v":0.9962080000000002,"d":"0.996"}]
[{"$f":"+A23+0.1","v":{"v":5.899999999999999,"d":"5.9"}},{"v":0.9969820000000003,"d":"0.997"}]
[{"v":6,"d":"6.0"},{"v":0.9972000000000003,"d":"0.997"}]

{"sheet":"251","index":2,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",251,"función de transformación:","CA= + 5,71E-02I^2 - 5,71E-02I + 6,94E -18","1<I<3,5"]
["Indicador:","Indicador semicualitativo de variación de las interacciones sociales",null,"CA=-8E-02I^2 + 9,6E - 01I - 1,880","3,5<I<6"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","2007-06-01","valor del indicador",3]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<1,\"valor del indicador fuera de rango\",IF(D5<=3.5,0.0571*(D5^2)-(0.0571*D5)+0,IF(D5<=6,(-0.08*(D5^2))+(0.96*D5)-1.88,\"valor del indicador fuera rango\")))","v":{"v":0.3426,"d":"0.343"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[1,{"$f":"0.0571*A8^2 - 0.0571*A8 + 6.94E-18","v":{"v":6.94E-18,"d":"0.000"}}]
[{"$f":"+A8+0.3","v":1.3},{"$f":"0.0571*A9^2 - 0.0571*A9","v":{"v":0.022268999999999997,"d":"0.022"}}]
[1.6,{"v":0.05481600000000003,"d":"0.055"}]
[1.9000000000000001,{"v":0.097641,"d":"0.098"}]
[2.2,{"v":0.15074400000000004,"d":"0.151"}]
[2.5,{"v":0.214125,"d":"0.214"}]
[2.8,{"v":0.28778399999999993,"d":"0.288"}]
[3.0999999999999996,{"v":0.37172099999999986,"d":"0.372"}]
[3.3999999999999995,{"v":0.4659359999999998,"d":"0.466"}]
[3.6999999999999993,{"$f":"-0.08*A17^2+0.96*A17-1.88","v":{"v":0.5767999999999995,"d":"0.577"}}]
[3.999999999999999,{"v":0.6799999999999997,"d":"0.680"}]
[4.299999999999999,{"v":0.7687999999999997,"d":"0.769"}]
[4.599999999999999,{"v":0.8431999999999995,"d":"0.843"}]
[4.899999999999999,{"v":0.9032,"d":"0.903"}]
[5.199999999999998,{"v":0.9487999999999994,"d":"0.949"}]
[5.499999999999998,{"v":0.9800000000000004,"d":"0.980"}]
[5.799999999999998,{"v":0.9967999999999995,"d":"0.997"}]
[6,{"v":1,"d":"1.000"}]

{"sheet":"252-253","index":3,"n_rows":53,"n_cols":5,"rows_kept":53,"merged":[[6,2,6,4],[32,2,32,4]]}
["nº de indicador:",252,"función de transformación:","CA= 1E-04I^2 - 2E- 02I + 1","0 < I < 100"]
["Indicador:","% de pobalación en contra del proyecto"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",70]
["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)+1,\"valor del indicador fuera rango\"))","v":{"v":0.08999999999999986,"d":"0.090"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0001*A8^2-0.02*A8+1","v":{"v":1,"d":"1.000"}}]
[5,{"v":0.9025,"d":"0.903"}]
[10,{"v":0.81,"d":"0.810"}]
[15,{"v":0.7225,"d":"0.723"}]
[20,{"v":0.6399999999999999,"d":"0.640"}]
[25,{"v":0.5625,"d":"0.563"}]
[30,{"v":0.49,"d":"0.490"}]
[35,{"v":0.4225,"d":"0.423"}]
[40,{"v":0.36,"d":"0.360"}]
[45,{"v":0.3025,"d":"0.303"}]
[50,{"v":0.25,"d":"0.250"}]
[55,{"v":0.2024999999999999,"d":"0.203"}]
[60,{"v":0.16000000000000014,"d":"0.160"}]
[65,{"v":0.12250000000000005,"d":"0.123"}]
[70,{"v":0.08999999999999986,"d":"0.090"}]
[80,{"v":0.039999999999999925,"d":"0.040"}]
[90,{"v":0.010000000000000009,"d":"0.010"}]
[100,{"v":0,"d":"0.000"}]
[]
["nº de indicador:",253,"función de transformación:","CA=1E-04I^2 - 2E-02I + 1","0<I<100"]
["Indicador:","Número de alegaciones presentadas"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",10]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D31<0,\"valor del indicador fuera de rango\",IF(D31<=100,0.0001*(D31^2)-(0.02*D31)+1,\"valor del indicador fuera rango\"))","v":{"v":0.81,"d":"0.810"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0001*A34^2-0.02*A34+1","v":{"v":1,"d":"1.00"}}]
[5,{"v":0.9025,"d":"0.90"}]
[10,0.81]
[15,{"v":0.7225,"d":"0.72"}]
[20,{"v":0.6399999999999999,"d":"0.64"}]
[25,{"v":0.5625,"d":"0.56"}]
[30,0.49]
[35,{"v":0.4225,"d":"0.42"}]
[40,0.36]
[45,{"v":0.3025,"d":"0.30"}]
[50,0.25]
[55,{"v":0.2024999999999999,"d":"0.20"}]
[60,{"v":0.16000000000000014,"d":"0.16"}]
[65,{"v":0.12250000000000005,"d":"0.12"}]
[70,{"v":0.08999999999999986,"d":"0.09"}]
[75,{"v":0.0625,"d":"0.06"}]
[78,{"v":0.0484,"d":"0.05"}]
[80,{"v":0.039999999999999925,"d":"0.04"}]
[85,{"v":0.022500000000000075,"d":"0.02"}]
[100,{"v":0,"d":"0.00"}]

{"sheet":"254","index":4,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[6,2,6,4]]}
["nº de indicador:",254,"función de transformación:","CA=-2,5E-03x+1","0<x<100"]
["Indicador:","Variación del riesgo",null,"CA=-7,5E-03x+1,500","100<x<200"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 200","valor del indicador",150]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=100,-0.0025*D5+1,IF(D5<200,-0.0075*D5+1.5,IF(D5>200,\"valor del indicador fuera rango\"))))","v":0.375}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0025*A8+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A8+10","v":10},0.975]
[20,{"v":0.95,"d":"0.950"}]
[30,0.925]
[40,{"v":0.9,"d":"0.900"}]
[50,0.875]
[60,{"v":0.85,"d":"0.850"}]
[70,0.825]
[80,{"v":0.8,"d":"0.800"}]
[90,0.775]
[100,{"v":0.75,"d":"0.750"}]
[110,{"$f":"-0.0075*A19+1.5","v":0.675}]
[120,{"v":0.6000000000000001,"d":"0.600"}]
[130,0.525]
[140,{"v":0.44999999999999996,"d":"0.450"}]
[150,0.375]
[160,{"v":0.30000000000000004,"d":"0.300"}]
[170,{"v":0.2250000000000001,"d":"0.225"}]
[180,{"v":0.15000000000000013,"d":"0.150"}]
[190,{"v":0.07499999999999996,"d":"0.075"}]
[200,{"v":0,"d":"0.000"}]

{"sheet":"255","index":5,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[6,2,6,4]]}
["nº de indicador:",255,"función de transformación:","CA=-2,5E-03x+1","0<x<100"]
["Indicador:","Grado de quebrantamientos e interés",null,"CA=-7,5E-03x+1,500","100<x<200"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",150]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=100,-0.0025*D5+1,IF(D5<200,-0.0075*D5+1.5,IF(D5>200,\"valor del indicador fuera rango\"))))","v":0.375}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.2*A8","v":{"v":0,"d":"0.000"}}]
[0.4,{"v":0.08000000000000002,"d":"0.080"}]
[0.6,{"v":0.12,"d":"0.120"}]
[{"$f":"+A10+0.2","v":0.8},{"v":0.16000000000000003,"d":"0.160"}]
[{"v":1,"d":"1.0"},{"v":0.2,"d":"0.200"}]
[1.4,{"v":0.27999999999999997,"d":"0.280"}]
[{"v":1.5999999999999999,"d":"1.6"},{"v":0.32,"d":"0.320"}]
[{"v":1.7999999999999998,"d":"1.8"},{"v":0.36,"d":"0.360"}]
[{"v":1.9999999999999998,"d":"2.0"},{"v":0.39999999999999997,"d":"0.400"}]
[2.4,{"v":0.48,"d":"0.480"}]
[2.6,{"v":0.52,"d":"0.520"}]
[{"v":2.8000000000000003,"d":"2.8"},{"v":0.56,"d":"0.560"}]
[{"v":3.0000000000000004,"d":"3.0"},{"v":0.6000000000000001,"d":"0.600"}]
[3.4,{"v":0.68,"d":"0.680"}]
[3.6,{"v":0.7200000000000001,"d":"0.720"}]
[{"v":3.8000000000000003,"d":"3.8"},{"v":0.7600000000000001,"d":"0.760"}]
[{"v":4,"d":"4.0"},{"v":0.8,"d":"0.800"}]
[4.4,{"v":0.8800000000000001,"d":"0.880"}]
[{"v":4.6000000000000005,"d":"4.6"},{"v":0.9200000000000002,"d":"0.920"}]
[{"v":4.800000000000001,"d":"4.8"},{"v":0.9600000000000002,"d":"0.960"}]
[{"v":5.000000000000001,"d":"5.0"},{"v":1.0000000000000002,"d":"1.000"}]