{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Registro","215","216-219"],"not_rendered":{"charts":5,"images":5,"external_links":7,"defined_names":32},"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":"215","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",215,"función de transformación:","CA=1"," - 50<I< 0"]
["Indicador:","% de variación en el nº de unidades de paisaje",null,"CA=-0,0004I^2 +1","0<I<50"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","   -50    -    50","valor del indicador",-3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<(-50),\"valor del indicador fuera de rango\",IF(D5<=0,1,IF(D5<=50,(-0.0004*(D5^2))+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"]
[-50,{"v":1,"d":"1.000"}]
[-40,{"v":1,"d":"1.000"}]
[-30,{"v":1,"d":"1.000"}]
[-20,{"v":1,"d":"1.000"}]
[-15,{"v":1,"d":"1.000"}]
[{"$f":"+A12+5","v":-10},{"v":1,"d":"1.000"}]
[-5,{"v":1,"d":"1.000"}]
[0,{"v":1,"d":"1.000"}]
[5,{"$f":"-0.0004*(A16^2)+1","v":{"v":0.99,"d":"0.990"}}]
[10,{"v":0.96,"d":"0.960"}]
[15,{"v":0.91,"d":"0.910"}]
[20,{"v":0.84,"d":"0.840"}]
[25,{"v":0.75,"d":"0.750"}]
[30,{"v":0.6399999999999999,"d":"0.640"}]
[35,{"v":0.51,"d":"0.510"}]
[40,{"v":0.36,"d":"0.360"}]
[45,{"v":0.18999999999999995,"d":"0.190"}]
[50,{"v":0,"d":"0.000"}]

{"sheet":"216-219","index":2,"n_rows":110,"n_cols":5,"rows_kept":110,"merged":[[6,2,6,4],[34,2,34,4],[61,2,61,4],[88,2,88,4]]}
["nº de indicador:",216,"función de transformación:","CA=0,00667I"," 0<I<75"]
["Indicador:","Calidad paisajística media",null,"CA=0,0004I^2-0,05I+2","75<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:"," 0 - 100","valor del indicador",78]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=75,0.00667*D5,IF(D5<=100,0.0004*D5^2-0.05*D5+2,\"valor del indicador fuera rango\")))","v":{"v":0.5335999999999999,"d":"0.534"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.00667*A8","v":{"v":0,"d":"0.000"}}]
[10,{"v":0.0667,"d":"0.067"}]
[20,{"v":0.1334,"d":"0.133"}]
[{"$f":"+A10+5","v":25},{"v":0.16674999999999998,"d":"0.167"}]
[30,{"v":0.2001,"d":"0.200"}]
[35,{"v":0.23345,"d":"0.233"}]
[40,{"v":0.2668,"d":"0.267"}]
[45,{"v":0.30015,"d":"0.300"}]
[50,{"v":0.33349999999999996,"d":"0.334"}]
[55,{"v":0.36685,"d":"0.367"}]
[60,{"v":0.4002,"d":"0.400"}]
[65,{"v":0.43355,"d":"0.434"}]
[70,{"v":0.4669,"d":"0.467"}]
[75,{"$f":"(0.0004*A21^2)-(0.05*A21)+2","v":{"v":0.5,"d":"0.500"}}]
[80,{"v":0.56,"d":"0.560"}]
[85,{"v":0.6400000000000001,"d":"0.640"}]
[90,{"v":0.7400000000000002,"d":"0.740"}]
[95,{"v":0.8600000000000003,"d":"0.860"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",217,"función de transformación:","CA=0,0005I^2+0,015I"," 0<I<20"]
["Indicador:","Valor relativo del paisaje, ponderado según la superficie de las diferentes unidades de paisaje",null,"CA=-0,000134I^2+0,0218I+0,118","20<I<80"]
["fórmula del indicador",null,null,"CA=1","80<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:"," 0 - 100","valor del indicador",25]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D33<(0),\"valor del indicador fuera de rango\",IF(D33<=20,(0.0005*(D33^2))+(0.015*D33),IF(D33<=80,-(0.000134*(D33^2))+(0.0218*D33)+0.118,IF(D33<=100,1,\"valor del indicador fuera rango\"))))","v":{"v":0.57925,"d":"0.579"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0005*(A36^2)+0.015*A36","v":{"v":0,"d":"0.000"}}]
[5,{"$f":"0.0005*(A37^2)+0.015*A37","v":{"v":0.0875,"d":"0.088"}}]
[10,{"$f":"0.0005*(A38^2)+0.015*A38","v":{"v":0.2,"d":"0.200"}}]
[15,{"$f":"0.0005*(A39^2)+0.015*A39","v":{"v":0.33749999999999997,"d":"0.338"}}]
[20,{"$f":"0.0005*(A40^2)+0.015*A40","v":{"v":0.5,"d":"0.500"}}]
[20,{"$f":"-(0.000134*(A41^2))+(0.0218*A41)+0.118","v":{"v":0.5004,"d":"0.500"}}]
[30,{"v":0.6514,"d":"0.651"}]
[40,{"v":0.7756,"d":"0.776"}]
[50,{"v":0.8730000000000001,"d":"0.873"}]
[60,{"v":0.9436000000000001,"d":"0.944"}]
[70,{"v":0.9873999999999999,"d":"0.987"}]
[80,{"v":1.0044,"d":"1.004"}]
[80,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A48+5","v":85},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A49+5","v":90},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A50+5","v":95},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[97,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[100,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[]
[]
["nº de indicador:",218,"función de transformación:","CA=0,0005I^2+0,015I"," 0<I<20"]
["Indicador:","% de variación del valor de conservación del paisaje",null,"CA=-0,000134I^2+0,0218I+0,118","20<I<80"]
["fórmula del indicador",null,null,"CA=1","80<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:"," 0 - 100","valor del indicador",25]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D60<(0),\"valor del indicador fuera de rango\",IF(D60<=20,(0.0005*(D60^2))+(0.015*D60),IF(D60<=80,-(0.000134*(D60^2))+(0.0218*D60)+0.118,IF(D60<=100,1,\"valor del indicador fuera rango\"))))","v":{"v":0.57925,"d":"0.579"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0005*(A63^2)+0.015*A63","v":{"v":0,"d":"0.000"}}]
[5,{"$f":"0.0005*(A64^2)+0.015*A64","v":{"v":0.0875,"d":"0.088"}}]
[10,{"$f":"0.0005*(A65^2)+0.015*A65","v":{"v":0.2,"d":"0.200"}}]
[15,{"$f":"0.0005*(A66^2)+0.015*A66","v":{"v":0.33749999999999997,"d":"0.338"}}]
[20,{"$f":"0.0005*(A67^2)+0.015*A67","v":{"v":0.5,"d":"0.500"}}]
[20,{"$f":"-(0.000134*(A68^2))+(0.0218*A68)+0.118","v":{"v":0.5004,"d":"0.500"}}]
[30,{"v":0.6514,"d":"0.651"}]
[40,{"v":0.7756,"d":"0.776"}]
[50,{"v":0.8730000000000001,"d":"0.873"}]
[60,{"v":0.9436000000000001,"d":"0.944"}]
[70,{"v":0.9873999999999999,"d":"0.987"}]
[80,{"v":1.0044,"d":"1.004"}]
[80,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A75+5","v":85},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A76+5","v":90},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A77+5","v":95},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[97,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[100,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[]
[]
["nº de indicador:",219,"función de transformación:","CA=(-0,00009*I^2) + (0,019*I)","0<I<100"]
["Indicador:","Fragilidad relativa del paisaje"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:"," 0 - 100","valor del indicador",25]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D87<0,\"valor del indicador fuera de rango\",IF(D87<100,-0.00009*(D87^2)+(0.019*D87),\"valor del indicador fuera rango\"))","v":{"v":0.41874999999999996,"d":"0.419"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.00009*(A90^2)+0.019*A90","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A90+5","v":5},{"v":0.09275,"d":"0.093"}]
[{"$f":"+A91+5","v":10},0.181]
[15,{"v":0.26475,"d":"0.265"}]
[20,0.344]
[25,{"v":0.41874999999999996,"d":"0.419"}]
[30,{"v":0.48899999999999993,"d":"0.489"}]
[35,{"v":0.5547500000000001,"d":"0.555"}]
[40,0.616]
[45,{"v":0.67275,"d":"0.673"}]
[50,0.725]
[55,{"v":0.7727499999999999,"d":"0.773"}]
[60,{"v":0.8159999999999998,"d":"0.816"}]
[65,{"v":0.8547499999999999,"d":"0.855"}]
[70,0.889]
[75,{"v":0.9187500000000001,"d":"0.919"}]
[80,0.944]
[85,{"v":0.96475,"d":"0.965"}]
[90,{"v":0.9809999999999999,"d":"0.981"}]
[95,{"v":0.9927499999999999,"d":"0.993"}]
[100,{"v":0.9999999999999999,"d":"1.000"}]