{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Registro","284","285","286","287-289"],"not_rendered":{"charts":6,"images":4,"external_links":10,"defined_names":61},"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":"284","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",284,"función de transformación:","CA=0"," -100<I<-20"]
["Indicador:","Variación del empleo en las actividades afectadas",null,"CA=2,5E-02I + 5E-01"," -20<I<0"]
["fórmula del indicador",null,null,"CA=5E-03I + 5E-01","0<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:"," -100 y 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<=-20,0,IF(D5<=0,0.025*D5+0.5,IF(D5<=100,0.005*D5+0.5,IF(D5>100,\"valor del indicador fuera rango\")))))","v":{"v":0.6,"d":"0.600"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-100,{"v":0,"d":"0.000"}]
[-80,{"v":0,"d":"0.000"}]
[-60,{"v":0,"d":"0.000"}]
[-40,{"v":0,"d":"0.000"}]
[{"$f":"+A11+10","v":-30},{"v":0,"d":"0.000"}]
[-20,{"$f":"(0.025*A13)+(0.5)","v":{"v":0,"d":"0.000"}}]
[-10,{"$f":"(0.025*A14)+(0.5)","v":{"v":0.25,"d":"0.250"}}]
[0,{"$f":"(0.025*A15)+(0.5)","v":{"v":0.5,"d":"0.500"}}]
[10,{"$f":"(0.005*A16)+(0.5)","v":{"v":0.55,"d":"0.550"}}]
[20,{"v":0.6,"d":"0.600"}]
[30,{"v":0.65,"d":"0.650"}]
[40,{"v":0.7,"d":"0.700"}]
[50,{"v":0.75,"d":"0.750"}]
[60,{"v":0.8,"d":"0.800"}]
[70,{"v":0.8500000000000001,"d":"0.850"}]
[80,{"v":0.9,"d":"0.900"}]
[90,{"v":0.95,"d":"0.950"}]
[100,{"v":1,"d":"1.000"}]

{"sheet":"285","index":2,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",285,"función de transformación:","CA=-1E-04I^2 + 2E-02I","0<I<100"]
["Indicador:","% de empleo generado",null,"CA=0","I<0"]
["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(D5<0,\"valor del indicador fuera de rango\",IF(D5<=100,-0.0001*(D5^2)+0.02*(D5),IF(D5>100,\"valor del indicador fuera rango\")))","v":{"v":0.36000000000000004,"d":"0.360"}}]
["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+10","v":10},{"v":0.19,"d":"0.190"}]
[{"$f":"+A9+10","v":20},{"v":0.36000000000000004,"d":"0.360"}]
[30,{"v":0.51,"d":"0.510"}]
[40,{"v":0.64,"d":"0.640"}]
[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"}]

{"sheet":"286","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",286,"función de transformación:","CA=I","0<I<1"]
["Indicador:","Aptitud para el uso extractivo",null,"CA=1","1<I<4"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 4","valor del indicador",0.5]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=1,D5,IF(D5<=4,1,\"valor del indicador fuera rango\")))","v":{"v":0.5,"d":"0.500"}}]
["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"}}]

{"sheet":"287-289","index":4,"n_rows":70,"n_cols":5,"rows_kept":70,"merged":[[6,2,6,4],[30,2,30,4],[54,2,54,4]]}
["nº de indicador:",287,"función de transformación:","CA=-2E-05I^2+1","0<I<100"]
["Indicador:","% del suelo desarrollado según distintos tipos de densidad (válido para suelo urbano)(densidad débil)"]
["fórmula del indicador"]
["unidad del indicador:"]
["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<=100,-0.00002*D5^2+1,\"valor del indicador fuera de rango\"))","v":0.982}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.00002*A8^2+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A8+5","v":5},{"v":0.9995,"d":"1.000"}]
[10,0.998]
[15,{"v":0.9955,"d":"0.996"}]
[20,0.992]
[25,{"v":0.9875,"d":"0.988"}]
[30,0.982]
[35,{"v":0.9755,"d":"0.976"}]
[40,0.968]
[{"$f":"+A16+10","v":50},{"v":0.95,"d":"0.950"}]
[60,{"v":0.9279999999999999,"d":"0.928"}]
[70,0.902]
[80,0.872]
[90,0.838]
[100,{"v":0.8,"d":"0.800"}]
[]
[]
["nº de indicador:",288,"función de transformación:","CA=-1E-04I^2+1","0<I<50"]
["Indicador:","% del suelo desarrollado según distintos tipos de densidad (válido para suelo urbano)(densidad media)",null,"CA=1,6E-04I^2-3,2E-02I+1,950","50<I<100"]
["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(D29<0,\"valor del indicador fuera de rango\",IF(D29<=50,-0.0001*(D29^2)+1,IF(D29<=100,(0.00016*(D29^2))-(0.032*D29)+1.95,\"valor del indicador fuera rango\")))","v":{"v":0.4939999999999998,"d":"0.494"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0001*A32^2+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A32+5","v":5},{"v":0.9975,"d":"0.998"}]
[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"}]
[{"$f":"+A40+10","v":50},{"$f":"0.00016*A41^2-0.032*A41+1.95","v":{"v":0.7499999999999998,"d":"0.750"}}]
[60,{"v":0.6060000000000001,"d":"0.606"}]
[70,{"v":0.4939999999999998,"d":"0.494"}]
[80,{"v":0.4139999999999999,"d":"0.414"}]
[90,{"v":0.3660000000000001,"d":"0.366"}]
[100,{"v":0.34999999999999987,"d":"0.350"}]
[]
[]
["nº de indicador:",289,"función de transformación:","CA=-3,4E-04I^2+1","0<I<25"]
["Indicador:","% del suelo desarrollado según distintos tipos de densidad (válido para suelo urbano)(densidad alta)",null,"CA=-1,33E-02I+1,130","25<I<70"]
["fórmula del indicador",null,null,"CA=8,33E-05I^2-2,08E-02I+1,250","70<I<100"]
["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(D53<0,\"valor del indicador fuera de rango\",IF(D53<=25,-0.00034*(D53^2)+1,IF(D53<=70,(-0.0133*(D53)+1.13),IF(D53<=100,0.0000833*(D53^2)-0.0208*(D53)+1.25,\"valor del indicador fuera rango\"))))","v":{"v":0.11912000000000011,"d":"0.119"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.00034*A56^2+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A56+5","v":5},{"v":0.9915,"d":"0.992"}]
[10,0.966]
[15,{"v":0.9235,"d":"0.924"}]
[20,0.864]
[25,{"v":0.7875,"d":"0.788"}]
[30,{"$f":"-0.0133*A62+1.13","v":{"v":0.7309999999999999,"d":"0.731"}}]
[35,{"v":0.6644999999999999,"d":"0.665"}]
[40,{"v":0.5979999999999999,"d":"0.598"}]
[{"$f":"+A64+10","v":50},{"v":0.46499999999999997,"d":"0.465"}]
[60,{"v":0.33199999999999996,"d":"0.332"}]
[70,{"v":0.19899999999999995,"d":"0.199"}]
[80,{"$f":"0.0000833*A68^2-0.0208*A68+1.25","v":{"v":0.11912000000000011,"d":"0.119"}}]
[90,{"$f":"0.0000833*A69^2-0.0208*A69+1.25","v":{"v":0.052730000000000166,"d":"0.053"}}]
[100,{"$f":"0.0000833*A70^2-0.0208*A70+1.25","v":{"v":3.0000000000001137E-3,"d":"0.003"}}]