{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Registro","260-263","264"],"not_rendered":{"charts":5,"images":4,"external_links":9,"defined_names":50},"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":"260-263","index":1,"n_rows":118,"n_cols":5,"rows_kept":118,"merged":[[6,2,6,4],[36,2,36,4],[66,2,66,4],[96,2,96,4]]}
["nº de indicador:",260,"función de transformación:","CA=1E-04x^2","0<x<100"]
["Indicador:","Variación del valor cultural de la trama urbana, con respecto a la situación sin proyecto"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0  -  100","valor del indicador",50]
["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,IF(D5>100,\"valor del indicador fuera rango\")))","v":{"v":0.25,"d":"0.250"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.0001*A8^2","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+5","v":5},{"v":0.0025,"d":"0.003"}]
[{"$f":"+A9+5","v":10},{"v":0.01,"d":"0.010"}]
[15,{"v":0.022500000000000003,"d":"0.023"}]
[20,{"v":0.04,"d":"0.040"}]
[25,{"v":0.0625,"d":"0.063"}]
[30,{"v":0.09000000000000001,"d":"0.090"}]
[35,{"v":0.12250000000000001,"d":"0.123"}]
[40,{"v":0.16,"d":"0.160"}]
[45,{"v":0.2025,"d":"0.203"}]
[50,{"v":0.25,"d":"0.250"}]
[55,{"v":0.3025,"d":"0.303"}]
[60,{"v":0.36000000000000004,"d":"0.360"}]
[65,{"v":0.42250000000000004,"d":"0.423"}]
[70,{"v":0.49000000000000005,"d":"0.490"}]
[75,{"v":0.5625,"d":"0.563"}]
[80,{"v":0.64,"d":"0.640"}]
[85,{"v":0.7225,"d":"0.723"}]
[90,{"v":0.81,"d":"0.810"}]
[95,{"v":0.9025000000000001,"d":"0.903"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",261,"función de transformación:","CA=2,5E-01x","0<x<4"]
["Indicador:","Indicador semicualitativo de la variación de la accesibilidad y permeabilidad (núcleos sin problemas)",null,"CA=1","4<x<8"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 8","valor del indicador",7]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D35<0,\"valor del indicador fuera de rango\",IF(D35<=4,0.25*D35,IF(D35<=8,1,IF(D35>8,\"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"]
[0,{"$f":"0.25*A38","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A38+0.4","v":0.4},{"$f":"0.25*A39","v":{"v":0.1,"d":"0.100"}}]
[{"$f":"+A39+0.4","v":0.8},{"v":0.2,"d":"0.200"}]
[{"v":1.2000000000000002,"d":"1.2"},{"v":0.30000000000000004,"d":"0.300"}]
[1.6,{"v":0.4,"d":"0.400"}]
[{"v":2,"d":"2.0"},{"v":0.5,"d":"0.500"}]
[2.4,{"v":0.6,"d":"0.600"}]
[2.8,{"v":0.7,"d":"0.700"}]
[{"v":3.1999999999999997,"d":"3.2"},{"v":0.7999999999999999,"d":"0.800"}]
[{"v":3.5999999999999996,"d":"3.6"},{"v":0.8999999999999999,"d":"0.900"}]
[{"v":3.9999999999999996,"d":"4.0"},{"v":0.9999999999999999,"d":"1.000"}]
[{"v":4.3999999999999995,"d":"4.4"},{"v":1,"d":"1.000"}]
[4.8,{"v":1,"d":"1.000"}]
[5.2,{"v":1,"d":"1.000"}]
[{"v":5.6000000000000005,"d":"5.6"},{"v":1,"d":"1.000"}]
[{"v":6.000000000000001,"d":"6.0"},{"v":1,"d":"1.000"}]
[{"v":6.400000000000001,"d":"6.4"},{"v":1,"d":"1.000"}]
[{"v":6.800000000000002,"d":"6.8"},{"v":1,"d":"1.000"}]
[{"v":7.200000000000002,"d":"7.2"},{"v":1,"d":"1.000"}]
[{"v":7.600000000000002,"d":"7.6"},{"v":1,"d":"1.000"}]
[{"v":8.000000000000002,"d":"8.0"},{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",262,"función de transformación:","CA=1,88E-01x","0<x<4"]
["Indicador:","Indicador semicualitativo de la variación de la accesibilidad y permeabilidad (núcleos con problemas moderados)",null,"CA=6,25E-02x+5E-01","4<x<8"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 8","valor del indicador",6]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D65<0,\"valor del indicador fuera de rango\",IF(D65<=4,0.188*D65,IF(D65<=8,0.0625*D65+0.5,IF(D65>8,\"valor del indicador fuera rango\"))))","v":0.875}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.188*A68","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A68+0.4","v":0.4},{"v":0.0752,"d":"0.075"}]
[{"$f":"+A69+0.4","v":0.8},{"v":0.1504,"d":"0.150"}]
[{"v":1.2000000000000002,"d":"1.2"},{"v":0.22560000000000002,"d":"0.226"}]
[1.6,{"v":0.3008,"d":"0.301"}]
[{"v":2,"d":"2.0"},0.376]
[2.4,{"v":0.4512,"d":"0.451"}]
[2.8,{"v":0.5264,"d":"0.526"}]
[{"v":3.1999999999999997,"d":"3.2"},{"v":0.6015999999999999,"d":"0.602"}]
[{"v":3.5999999999999996,"d":"3.6"},{"v":0.6768,"d":"0.677"}]
[{"v":3.9999999999999996,"d":"4.0"},{"$f":"0.188*A78","v":{"v":0.7519999999999999,"d":"0.752"}}]
[{"v":4.3999999999999995,"d":"4.4"},{"$f":"0.0625*A79+0.5","v":{"v":0.7749999999999999,"d":"0.775"}}]
[4.8,{"$f":"0.0625*A80+0.5","v":{"v":0.8,"d":"0.800"}}]
[5.2,0.825]
[{"v":5.6000000000000005,"d":"5.6"},{"v":0.8500000000000001,"d":"0.850"}]
[{"v":6.000000000000001,"d":"6.0"},0.875]
[{"v":6.400000000000001,"d":"6.4"},{"v":0.9000000000000001,"d":"0.900"}]
[{"v":6.800000000000002,"d":"6.8"},0.925]
[{"v":7.200000000000002,"d":"7.2"},{"v":0.9500000000000002,"d":"0.950"}]
[{"v":7.600000000000002,"d":"7.6"},{"v":0.9750000000000001,"d":"0.975"}]
[{"v":8.000000000000002,"d":"8.0"},{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",263,"función de transformación:","CA=1,25E-01x","0<x<8"]
["Indicador:","Indicador semicualitativo de la variación de la accesibilidad y permeabilidad (núcleos con problemas fuertes)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 8","valor del indicador",3]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D95<0,\"valor del indicador fuera de rango\",IF(D95<=8,0.125*D95,IF(D95>8,\"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.125*A98","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A98+0.4","v":0.4},{"v":0.05,"d":"0.050"}]
[{"$f":"+A99+0.4","v":0.8},{"v":0.1,"d":"0.100"}]
[{"v":1.2000000000000002,"d":"1.2"},{"v":0.15000000000000002,"d":"0.150"}]
[1.6,{"v":0.2,"d":"0.200"}]
[{"v":2,"d":"2.0"},{"v":0.25,"d":"0.250"}]
[2.4,{"v":0.3,"d":"0.300"}]
[2.8,{"v":0.35,"d":"0.350"}]
[{"v":3.1999999999999997,"d":"3.2"},{"v":0.39999999999999997,"d":"0.400"}]
[{"v":3.5999999999999996,"d":"3.6"},{"v":0.44999999999999996,"d":"0.450"}]
[{"v":3.9999999999999996,"d":"4.0"},{"v":0.49999999999999994,"d":"0.500"}]
[{"v":4.3999999999999995,"d":"4.4"},{"v":0.5499999999999999,"d":"0.550"}]
[4.8,{"v":0.6,"d":"0.600"}]
[5.2,{"v":0.65,"d":"0.650"}]
[{"v":5.6000000000000005,"d":"5.6"},{"v":0.7000000000000001,"d":"0.700"}]
[{"v":6.000000000000001,"d":"6.0"},{"v":0.7500000000000001,"d":"0.750"}]
[{"v":6.400000000000001,"d":"6.4"},{"v":0.8000000000000002,"d":"0.800"}]
[{"v":6.800000000000002,"d":"6.8"},{"v":0.8500000000000002,"d":"0.850"}]
[{"v":7.200000000000002,"d":"7.2"},{"v":0.9000000000000002,"d":"0.900"}]
[{"v":7.600000000000002,"d":"7.6"},{"v":0.9500000000000003,"d":"0.950"}]
[{"v":8.000000000000002,"d":"8.0"},{"v":1.0000000000000002,"d":"1.000"}]

{"sheet":"264","index":2,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",264,"función de transformación:","CA=1,78E-01x^2+2E-01","0<x<1,5"]
["Indicador:","Efecto de la tipología del conjunto sobre la población",null,"CA=-1,78E-01x^2+1,07x-6E-01","1,5<x<3"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 3","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<=1.5,0.178*D5^2+0.2,IF(D5<=3,-0.178*D5^2+1.07*D5-0.6,IF(D5>3,\"valor del indicador fuera rango\"))))","v":{"v":0.8280000000000002,"d":"0.828"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.178*A8^2+0.2","v":{"v":0.2,"d":"0.200"}}]
[0.1,{"v":0.20178000000000001,"d":"0.202"}]
[0.2,{"v":0.20712000000000003,"d":"0.207"}]
[0.5,{"v":0.2445,"d":"0.245"}]
[0.6,{"v":0.26408,"d":"0.264"}]
[0.7,{"v":0.28722,"d":"0.287"}]
[0.8,{"v":0.31392000000000003,"d":"0.314"}]
[{"$f":"+A14+0.2","v":{"v":1,"d":"1.0"}},0.378]
[1.2,{"v":0.45632,"d":"0.456"}]
[1.4,{"v":0.5488799999999999,"d":"0.549"}]
[{"v":1.5999999999999999,"d":"1.6"},{"$f":"-0.178*A18^2+1.07*A18-0.6","v":{"v":0.6563200000000001,"d":"0.656"}}]
[{"v":1.7999999999999998,"d":"1.8"},{"v":0.7492800000000001,"d":"0.749"}]
[{"v":1.9999999999999998,"d":"2.0"},0.828]
[{"v":2.1999999999999997,"d":"2.2"},{"v":0.89248,"d":"0.892"}]
[2.4,{"v":0.9427200000000001,"d":"0.943"}]
[2.6,{"v":0.9787200000000004,"d":"0.979"}]
[{"v":2.8000000000000003,"d":"2.8"},{"v":1.00048,"d":"1.000"}]
[{"v":3.0000000000000004,"d":"3.0"},{"v":1.0080000000000005,"d":"1.008"}]