{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Registro","232-233","234","235","236","237","238","239","240"],"not_rendered":{"charts":9,"images":6,"external_links":7,"defined_names":69},"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":"232-233","index":1,"n_rows":54,"n_cols":5,"rows_kept":54,"merged":[[6,2,6,4],[34,2,34,4]]}
["nº de indicador:",232,"función de transformación:","CA=(-1E-04)x^2+(2E-02)x","0<x<100"]
["Indicador:","Superficie equivalente de espacios de ocio, expresada como % sobre el total"]
["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(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 de rango\")))","v":{"v":0.19,"d":"0.190"}}]
["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"}}]
[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"}]
[{"$f":"+A19+5","v":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"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",233,"función de transformación:","CA=(-1E-04)x^2+1","0<x<100"]
["Indicador:","% de variación de la superficie equivalente destinada a espacios de ocio"]
["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(D33<0,\"valor del indicador fuera de rango\",IF(D33<=100,-0.0001*(D33^2)+1,IF(D33>100,\"valor del indicador fuera de rango\")))","v":{"v":0.99,"d":"0.990"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0001*(A36^2)+1","v":{"v":1,"d":"1.000"}}]
[10,{"v":0.99,"d":"0.990"}]
[{"$f":"+A37+5","v":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"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"234","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[6,2,6,4]]}
["nº de indicador:",234,"función de transformación:","CA=(1E-02)x","0<x<100"]
["Indicador:","Índice de productividad de la caza"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",15]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=100,0.01*(D5),IF(D5>100,\"valor del indicador fuera de rango\")))","v":{"v":0.15,"d":"0.150"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.01*(A8)","v":{"v":0,"d":"0.000"}}]
[2,{"v":0.02,"d":"0.020"}]
[5,{"v":0.05,"d":"0.050"}]
[7,{"v":0.07,"d":"0.070"}]
[10,{"v":0.1,"d":"0.100"}]
[{"$f":"+A12+5","v":15},{"v":0.15,"d":"0.150"}]
[20,{"v":0.2,"d":"0.200"}]
[25,{"v":0.25,"d":"0.250"}]
[30,{"v":0.3,"d":"0.300"}]
[35,{"v":0.35000000000000003,"d":"0.350"}]
[40,{"v":0.4,"d":"0.400"}]
[45,{"v":0.45,"d":"0.450"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.55,"d":"0.550"}]
[60,{"v":0.6,"d":"0.600"}]
[65,{"v":0.65,"d":"0.650"}]
[70,{"v":0.7000000000000001,"d":"0.700"}]
[75,{"v":0.75,"d":"0.750"}]
[80,{"v":0.8,"d":"0.800"}]
[85,{"v":0.85,"d":"0.850"}]
[90,{"v":0.9,"d":"0.900"}]
[100,{"v":1,"d":"1.000"}]

{"sheet":"235","index":3,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[6,2,6,4]]}
["nº de indicador:",235,"función de transformación:","CA=(1E-02)x","0<x<100"]
["Indicador:","Índice de productividad de la pesca"]
["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.01*(D5),IF(D5>100,\"valor del indicador fuera de rango\")))","v":{"v":0.2,"d":"0.200"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.01*(A8)","v":{"v":0,"d":"0.000"}}]
[10,{"v":0.1,"d":"0.100"}]
[20,{"v":0.2,"d":"0.200"}]
[{"$f":"+A10+5","v":25},{"v":0.25,"d":"0.250"}]
[30,{"v":0.3,"d":"0.300"}]
[35,{"v":0.35000000000000003,"d":"0.350"}]
[40,{"v":0.4,"d":"0.400"}]
[45,{"v":0.45,"d":"0.450"}]
[50,{"v":0.5,"d":"0.500"}]
[55,{"v":0.55,"d":"0.550"}]
[60,{"v":0.6,"d":"0.600"}]
[{"$f":"+A18+5","v":65},{"v":0.65,"d":"0.650"}]
[70,{"v":0.7000000000000001,"d":"0.700"}]
[75,{"v":0.75,"d":"0.750"}]
[80,{"v":0.8,"d":"0.800"}]
[85,{"v":0.85,"d":"0.850"}]
[90,{"v":0.9,"d":"0.900"}]
[95,{"v":0.9500000000000001,"d":"0.950"}]
[100,{"v":1,"d":"1.000"}]

{"sheet":"236","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",236,"función de transformación:","CA=x","0<x<4"]
["Indicador:","Aptitud para el baño"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 4","valor del indicador",0.4]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=4,D5/4,IF(D5<=4,1,IF(D5>4,\"valor del indicador fuera de rango\"))))","v":{"v":0.1,"d":"0.100"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"+A8/4","v":{"v":0,"d":"0.000"}}]
[0.2,{"$f":"+A9/4","v":{"v":0.05,"d":"0.050"}}]
[0.4,{"v":0.1,"d":"0.100"}]
[0.6,{"v":0.15,"d":"0.150"}]
[0.8,{"v":0.2,"d":"0.200"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"$f":"+A14+0.3","v":1.3},0.325]
[1.5,0.375]
[{"$f":"+A16+0.3","v":1.8},{"v":0.45,"d":"0.450"}]
[{"v":2,"d":"2.0"},{"v":0.5,"d":"0.500"}]
[{"$f":"+A18+0.3","v":2.3},0.575]
[{"$f":"+A19+0.3","v":{"v":2.5999999999999996,"d":"2.6"}},{"v":0.6499999999999999,"d":"0.650"}]
[{"v":3,"d":"3.0"},{"v":0.75,"d":"0.750"}]
[{"$f":"+A21+0.3","v":3.3},0.825]
[{"$f":"+A22+0.3","v":{"v":3.5999999999999996,"d":"3.6"}},{"v":0.8999999999999999,"d":"0.900"}]
[{"$f":"+A23+0.3","v":{"v":3.8999999999999995,"d":"3.9"}},{"v":0.9749999999999999,"d":"0.975"}]
[{"v":4,"d":"4.0"},{"v":1,"d":"1.000"}]

{"sheet":"237","index":5,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",237,"función de transformación:","CA=x","0<x<4"]
["Indicador:","Aptitud para el recreo concentrado"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 4","valor del indicador",0.6]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=4,D5/4,IF(D5<=4,1,IF(D5>4,\"valor del indicador fuera de rango\"))))","v":{"v":0.15,"d":"0.150"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"+A8/4","v":{"v":0,"d":"0.000"}}]
[0.2,{"$f":"+A9/4","v":{"v":0.05,"d":"0.050"}}]
[0.4,{"v":0.1,"d":"0.100"}]
[0.6,{"v":0.15,"d":"0.150"}]
[0.8,{"v":0.2,"d":"0.200"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"$f":"+A14+0.3","v":1.3},0.325]
[1.5,0.375]
[{"$f":"+A16+0.3","v":1.8},{"v":0.45,"d":"0.450"}]
[{"v":2,"d":"2.0"},{"v":0.5,"d":"0.500"}]
[{"$f":"+A18+0.3","v":2.3},0.575]
[{"$f":"+A19+0.3","v":{"v":2.5999999999999996,"d":"2.6"}},{"v":0.6499999999999999,"d":"0.650"}]
[{"v":3,"d":"3.0"},{"v":0.75,"d":"0.750"}]
[{"$f":"+A21+0.3","v":3.3},0.825]
[{"$f":"+A22+0.3","v":{"v":3.5999999999999996,"d":"3.6"}},{"v":0.8999999999999999,"d":"0.900"}]
[{"$f":"+A23+0.3","v":{"v":3.8999999999999995,"d":"3.9"}},{"v":0.9749999999999999,"d":"0.975"}]
[{"v":4,"d":"4.0"},{"v":1,"d":"1.000"}]

{"sheet":"238","index":6,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",238,"función de transformación:","CA=x","0<x<4"]
["Indicador:","Aptitud para la acampada"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 4","valor del indicador",0.4]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=4,D5/4,IF(D5<=4,1,IF(D5>4,\"valor del indicador fuera de rango\"))))","v":{"v":0.1,"d":"0.100"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"+A8/4","v":{"v":0,"d":"0.000"}}]
[0.2,{"$f":"+A9/4","v":{"v":0.05,"d":"0.050"}}]
[0.4,{"v":0.1,"d":"0.100"}]
[0.6,{"v":0.15,"d":"0.150"}]
[0.8,{"v":0.2,"d":"0.200"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"$f":"+A14+0.3","v":1.3},0.325]
[1.5,0.375]
[{"$f":"+A16+0.3","v":1.8},{"v":0.45,"d":"0.450"}]
[{"v":2,"d":"2.0"},{"v":0.5,"d":"0.500"}]
[{"$f":"+A18+0.3","v":2.3},0.575]
[{"$f":"+A19+0.3","v":{"v":2.5999999999999996,"d":"2.6"}},{"v":0.6499999999999999,"d":"0.650"}]
[{"v":3,"d":"3.0"},{"v":0.75,"d":"0.750"}]
[{"$f":"+A21+0.3","v":3.3},0.825]
[{"$f":"+A22+0.3","v":{"v":3.5999999999999996,"d":"3.6"}},{"v":0.8999999999999999,"d":"0.900"}]
[{"$f":"+A23+0.3","v":{"v":3.8999999999999995,"d":"3.9"}},{"v":0.9749999999999999,"d":"0.975"}]
[{"v":4,"d":"4.0"},{"v":1,"d":"1.000"}]

{"sheet":"239","index":7,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",239,"función de transformación:","CA=x","0<x<4"]
["Indicador:","Aptitud para el recreo difuso y el senderismo"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 4","valor del indicador",2]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=4,D5/4,IF(D5<=4,1,IF(D5>4,\"valor del indicador fuera de 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/4","v":{"v":0,"d":"0.000"}}]
[0.2,{"$f":"+A9/4","v":{"v":0.05,"d":"0.050"}}]
[0.4,{"v":0.1,"d":"0.100"}]
[0.6,{"v":0.15,"d":"0.150"}]
[0.8,{"v":0.2,"d":"0.200"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"$f":"+A14+0.3","v":1.3},0.325]
[1.5,0.375]
[{"$f":"+A16+0.3","v":1.8},{"v":0.45,"d":"0.450"}]
[{"v":2,"d":"2.0"},{"v":0.5,"d":"0.500"}]
[{"$f":"+A18+0.3","v":2.3},0.575]
[{"$f":"+A19+0.3","v":{"v":2.5999999999999996,"d":"2.6"}},{"v":0.6499999999999999,"d":"0.650"}]
[{"v":3,"d":"3.0"},{"v":0.75,"d":"0.750"}]
[{"$f":"+A21+0.3","v":3.3},0.825]
[{"$f":"+A22+0.3","v":{"v":3.5999999999999996,"d":"3.6"}},{"v":0.8999999999999999,"d":"0.900"}]
[{"$f":"+A23+0.3","v":{"v":3.8999999999999995,"d":"3.9"}},{"v":0.9749999999999999,"d":"0.975"}]
[{"v":4,"d":"4.0"},{"v":1,"d":"1.000"}]

{"sheet":"240","index":8,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",240,"función de transformación:","CA=x","0<x<4"]
["Indicador:","Aptitud para los miradores turísticos"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 4","valor del indicador",2]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=4,D5/4,IF(D5<=4,1,IF(D5>4,\"valor del indicador fuera de 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/4","v":{"v":0,"d":"0.000"}}]
[0.2,{"$f":"+A9/4","v":{"v":0.05,"d":"0.050"}}]
[0.4,{"v":0.1,"d":"0.100"}]
[0.6,{"v":0.15,"d":"0.150"}]
[0.8,{"v":0.2,"d":"0.200"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"v":1,"d":"1.0"},{"v":0.25,"d":"0.250"}]
[{"$f":"+A14+0.3","v":1.3},0.325]
[1.5,0.375]
[{"$f":"+A16+0.3","v":1.8},{"v":0.45,"d":"0.450"}]
[{"v":2,"d":"2.0"},{"v":0.5,"d":"0.500"}]
[{"$f":"+A18+0.3","v":2.3},0.575]
[{"$f":"+A19+0.3","v":{"v":2.5999999999999996,"d":"2.6"}},{"v":0.6499999999999999,"d":"0.650"}]
[{"v":3,"d":"3.0"},{"v":0.75,"d":"0.750"}]
[{"$f":"+A21+0.3","v":3.3},0.825]
[{"$f":"+A22+0.3","v":{"v":3.5999999999999996,"d":"3.6"}},{"v":0.8999999999999999,"d":"0.900"}]
[{"$f":"+A23+0.3","v":{"v":3.8999999999999995,"d":"3.9"}},{"v":0.9749999999999999,"d":"0.975"}]
[{"v":4,"d":"4.0"},{"v":1,"d":"1.000"}]