{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Registro","241-243","244","245"],"not_rendered":{"charts":5,"images":12,"external_links":1,"defined_names":23},"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":"241-243","index":1,"n_rows":86,"n_cols":5,"rows_kept":86,"merged":[[6,2,6,4],[34,2,34,4],[64,2,64,4]]}
["nº de indicador:",241,"función de transformación:","CA=1E-02I","0<I<100"]
["Indicador:","% de la producción"]
["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":"+D5*0.01","v":{"v":0.4,"d":"0.40"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.01*A8","v":{"v":0,"d":"0.00"}}]
[5,{"$f":"0.01*A9","v":0.05}]
[10,{"v":0.1,"d":"0.10"}]
[15,0.15]
[20,{"v":0.2,"d":"0.20"}]
[25,0.25]
[30,{"v":0.3,"d":"0.30"}]
[35,{"v":0.35000000000000003,"d":"0.35"}]
[40,{"v":0.4,"d":"0.40"}]
[45,0.45]
[50,{"v":0.5,"d":"0.50"}]
[55,0.55]
[60,{"v":0.6,"d":"0.60"}]
[65,0.65]
[70,{"v":0.7000000000000001,"d":"0.70"}]
[80,{"v":0.8,"d":"0.80"}]
[90,{"v":0.9,"d":"0.90"}]
[95,{"v":0.9500000000000001,"d":"0.95"}]
[100,{"v":1,"d":"1.00"}]
[]
[]
["nº de indicador:",242,"función de transformación:","CA=4,35E-04I","0<I<2300"]
["Indicador:","Productividad media",null,"CA=1","2300<I<3000"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 300","valor del indicador",600]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D33<0,\"valor del indicador fuera de rango\",IF(D33<=2300,0.000435*(D33),IF(D33<=3000,1,\"valor del indicador fuera rango\")))","v":0.261}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.000435*A36","v":{"v":0,"d":"0.000"}}]
[100,{"$f":"0.000435*A37","v":{"v":0.0435,"d":"0.044"}}]
[200,0.087]
[300,{"v":0.1305,"d":"0.131"}]
[400,0.174]
[500,{"v":0.2175,"d":"0.218"}]
[600,0.261]
[700,{"v":0.3045,"d":"0.305"}]
[800,0.348]
[900,{"v":0.3915,"d":"0.392"}]
[1000,0.435]
[1100,{"v":0.4785,"d":"0.479"}]
[1200,0.522]
[1300,{"v":0.5655,"d":"0.566"}]
[1500,{"v":0.6525,"d":"0.653"}]
[1800,0.783]
[2000,{"v":0.87,"d":"0.870"}]
[2300,{"v":1,"d":"1.000"}]
[2600,{"v":1,"d":"1.000"}]
[2700,{"v":1,"d":"1.000"}]
[3000,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",243,"función de transformación:","CA= - 1E-04 I^2 + 2E-02I","0<I<100"]
["Indicador:","Superficie relativa, ponderada según la productividad"]
["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(D63<0,\"valor del indicador fuera de rango\",IF(D63<=100,-0.0001*(D63^2)+0.02*D63,\"valor del indicador fuera rango\"))","v":{"v":0.8399999999999999,"d":"0.840"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0001*A66^2+0.02*A66","v":{"v":0,"d":"0.000"}}]
[5,{"$f":"-0.0001*A67^2+0.02*A67","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"}]
[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"}]

{"sheet":"244","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[6,2,6,4]]}
["nº de indicador:",244,"función de transformación:","CA=2E-02 I","0<I<50"]
["Indicador:","% de la producción sometida a pastoreo",null,"CA=1","50<I<60"]
["fórmula del indicador",null,null,"CA= - 3,33E- 0,2I + 3","60<I<90"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 90","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<=50,0.02*(D5),IF(D5<=60,1,IF(D5<=90,-0.0333*D5+3,\"valor del indicador fuera rango\"))))","v":{"v":0.33599999999999985,"d":"0.336"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.02*A8","v":{"v":0,"d":"0.000"}}]
[5,{"v":0.1,"d":"0.100"}]
[10,{"v":0.2,"d":"0.200"}]
[15,{"v":0.3,"d":"0.300"}]
[20,{"v":0.4,"d":"0.400"}]
[25,{"v":0.5,"d":"0.500"}]
[30,{"v":0.6,"d":"0.600"}]
[35,{"v":0.7000000000000001,"d":"0.700"}]
[40,{"v":0.8,"d":"0.800"}]
[45,{"v":0.9,"d":"0.900"}]
[50,{"v":1,"d":"1.000"}]
[55,{"v":1,"d":"1.000"}]
[60,{"v":1,"d":"1.000"}]
[65,{"$f":"-0.0333*A21+3","v":{"v":0.8354999999999997,"d":"0.836"}}]
[70,{"$f":"-0.0333*A22+3","v":{"v":0.6689999999999996,"d":"0.669"}}]
[80,{"$f":"-0.0333*A23+3","v":{"v":0.33599999999999985,"d":"0.336"}}]
[90,{"$f":"-0.0333*A24+3","v":{"v":2.9999999999996696E-3,"d":"0.003"}}]

{"sheet":"245","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",245,"función de transformación:","CA=I","0<I<1"]
["Indicador:","Aptitud para el uso forestal",null,"CA=1","1<I<4"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 4","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,1*D5,IF(D5<=4,1,\"valor del indicador fuera rango\")))","v":{"v":1,"d":"1.000"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"A8","v":{"v":0,"d":"0.00"}}]
[{"$f":"+A8+0.2","v":0.2},{"v":0.2,"d":"0.20"}]
[0.4,{"v":0.4,"d":"0.40"}]
[0.6,{"v":0.6,"d":"0.60"}]
[0.8,{"v":0.8,"d":"0.80"}]
[{"v":1,"d":"1.0"},{"v":1,"d":"1.00"}]
[1.2,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[1.4,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[1.6,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[1.8,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[{"v":2,"d":"2.0"},{"$f":"1","v":{"v":1,"d":"1.00"}}]
[2.2,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[2.4,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[2.6,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[2.8,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[{"v":3,"d":"3.0"},{"$f":"1","v":{"v":1,"d":"1.00"}}]
[3.4,{"$f":"1","v":{"v":1,"d":"1.00"}}]
[{"v":4,"d":"4.0"},{"$f":"1","v":{"v":1,"d":"1.00"}}]