{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Registro","224-228","229-230","231"],"not_rendered":{"charts":8,"images":5,"external_links":7,"defined_names":35},"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":"224-228","index":1,"n_rows":136,"n_cols":5,"rows_kept":136,"merged":[[6,2,6,4],[34,2,34,4],[62,2,62,4],[90,2,90,4],[117,2,117,4]]}
["nº de indicador:",224,"función de transformación:","CA=-0,0001*I^2+ 0,02*I ","0<I<100"]
["Indicador:","Lugares o monumentos histórico-artisticos equivalentes (interés bajo)"]
["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)+(0.02*D5),\"valor del indicador fuera rango\"))","v":{"v":0.75,"d":"0.750"}}]
["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"}]
[{"$f":"+A9+5","v":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"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",225,"función de transformación:","CA=0 ","0<I<25"]
["Indicador:","Lugares o monumentos histórico-artisticos equivalentes (interés medio)",null,"CA= -0,000107*I^2+0,0267*I-0,6","25<I<100"]
["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(D33<0,\"valor del indicador fuera de rango\",IF(D33<=25,0,IF(D33<=100,(-0.000107*(D33^2))+(0.0267*D33)-0.6,\"valor del indicador fuera rango\")))","v":{"v":0.4674999999999999,"d":"0.468"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":0,"d":"0.000"}]
[10,{"v":0,"d":"0.000"}]
[{"$f":"+A37+5","v":15},{"v":0,"d":"0.000"}]
[20,{"v":0,"d":"0.000"}]
[25,{"v":0,"d":"0.000"}]
[30,{"$f":"-0.000107*(A41^2)+(0.0267*(A41))-0.6","v":{"v":0.10470000000000013,"d":"0.105"}}]
[35,{"v":0.20342500000000008,"d":"0.203"}]
[40,{"v":0.29680000000000006,"d":"0.297"}]
[45,{"v":0.3848250000000001,"d":"0.385"}]
[50,{"v":0.4674999999999999,"d":"0.468"}]
[55,{"v":0.5448250000000002,"d":"0.545"}]
[60,{"v":0.6168000000000001,"d":"0.617"}]
[65,{"v":0.6834250000000001,"d":"0.683"}]
[70,{"v":0.7447000000000003,"d":"0.745"}]
[75,{"v":0.800625,"d":"0.801"}]
[80,{"v":0.8512000000000001,"d":"0.851"}]
[85,{"v":0.8964250000000004,"d":"0.896"}]
[90,{"v":0.9363,"d":"0.936"}]
[100,{"v":0.9999999999999999,"d":"1.000"}]
[]
[]
["nº de indicador:",226,"función de transformación:","CA=0 ","0<I<50"]
["Indicador:","Lugares o monumentos histórico-artisticos equivalentes (interés alto)",null,"CA= -0,0002*I^2+0,05*I-2","50<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",75]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D61<0,\"valor del indicador fuera de rango\",IF(D61<=50,0,IF(D61<=100,(-0.0002*(D61^2))+(0.05*D61)-2,\"valor del indicador fuera rango\")))","v":0.625}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":0,"d":"0.000"}]
[10,{"v":0,"d":"0.000"}]
[{"$f":"+A65+5","v":15},{"v":0,"d":"0.000"}]
[20,{"v":0,"d":"0.000"}]
[25,{"v":0,"d":"0.000"}]
[30,{"v":0,"d":"0.000"}]
[35,{"v":0,"d":"0.000"}]
[40,{"v":0,"d":"0.000"}]
[45,{"v":0,"d":"0.000"}]
[50,{"v":0,"d":"0.000"}]
[55,{"$f":"-0.0002*(A74^2)+(0.05*(A74))-2","v":{"v":0.14500000000000002,"d":"0.145"}}]
[60,{"v":0.2799999999999998,"d":"0.280"}]
[65,{"v":0.4049999999999998,"d":"0.405"}]
[70,{"v":0.52,"d":"0.520"}]
[75,0.625]
[80,{"v":0.7199999999999998,"d":"0.720"}]
[85,{"v":0.8049999999999997,"d":"0.805"}]
[90,{"v":0.8799999999999999,"d":"0.880"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",227,"función de transformación:","CA=0,01I ","0<I<100"]
["Indicador:","Interés medio de los lugares o monumentos históricos y/o artísticos existentes (interés bajo)"]
["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(D89<0,\"valor del indicador fuera de rango\",IF(D89<=100,0.01*(D89),\"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"]
[0,{"$f":"0.01*A92","v":{"v":0,"d":"0.000"}}]
[10,{"v":0.1,"d":"0.100"}]
[20,{"v":0.2,"d":"0.200"}]
[30,{"v":0.3,"d":"0.300"}]
[{"$f":"+A95+5","v":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"}]
[95,{"v":0.9500000000000001,"d":"0.950"}]
[{"$f":"+A108+5","v":100},{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",228,"función de transformación:","CA=0 ","0<I<25"]
["Indicador:","Interés medio de los lugares o monumentos históricos y/o artísticos existentes (interés alto)",null,"CA= 0,0133*I-0,333","25<I<100"]
["fórmula del indicador",null,null,"CA=0","0<I<25"]
["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(D116<0,\"valor del indicador fuera de rango\",IF(D116<=25,0,IF(D116<=100,(0.0133*(D116))-(0.333),\"valor del indicador fuera rango\")))","v":{"v":0.3319999999999999,"d":"0.332"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"v":0,"d":"0.000"}]
[{"$f":"+A119+5","v":5},{"v":0,"d":"0.000"}]
[10,{"v":0,"d":"0.000"}]
[15,{"v":0,"d":"0.000"}]
[20,{"v":0,"d":"0.000"}]
[25,{"v":0,"d":"0.000"}]
[30,{"$f":"0.0133*A125-0.333","v":{"v":0.06599999999999995,"d":"0.066"}}]
[40,0.199]
[50,{"v":0.3319999999999999,"d":"0.332"}]
[60,{"v":0.4649999999999999,"d":"0.465"}]
[65,{"v":0.5314999999999999,"d":"0.532"}]
[70,{"v":0.5979999999999999,"d":"0.598"}]
[75,{"v":0.6644999999999999,"d":"0.665"}]
[80,{"v":0.7310000000000001,"d":"0.731"}]
[85,{"v":0.7974999999999999,"d":"0.798"}]
[90,{"v":0.8639999999999999,"d":"0.864"}]
[95,{"v":0.9304999999999999,"d":"0.931"}]
[100,{"v":0.9969999999999999,"d":"0.997"}]

{"sheet":"229-230","index":2,"n_rows":68,"n_cols":5,"rows_kept":68,"merged":[[6,2,6,4],[41,2,41,4]]}
["nº de indicador:",229,"función de transformación:","CA=0","0<x<1"]
["Indicador:","Indice medio de calidad de los yacimientos arqueológicos (yacimentos terrestres)",null,"CA=(4,69E-02)x^2-(9,38E-0,2)x+2,97E-01","1<x<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","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,0,IF(D5<5,0.0469*(D5^2)-0.0938*(D5)+0.297,\"valor del indicador fuera de rango\")))","v":0.297}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"v":0,"d":"0.000"}]
[{"$f":"+A8+0.2","v":0.2},{"v":0,"d":"0.000"}]
[{"$f":"+A9+0.2","v":0.4},{"v":0,"d":"0.000"}]
[{"v":0.6000000000000001,"d":"0.6"},{"v":0,"d":"0.000"}]
[0.8,{"v":0,"d":"0.000"}]
[{"v":1,"d":"1.0"},{"v":0,"d":"0.000"}]
[1.2,{"$f":"(0.0469)*A14^2-(0.0938)*A14+0.297","v":{"v":0.251976,"d":"0.252"}}]
[1.4,{"v":0.25760399999999994,"d":"0.258"}]
[{"v":1.5999999999999999,"d":"1.6"},{"v":0.266984,"d":"0.267"}]
[{"v":1.7999999999999998,"d":"1.8"},{"v":0.280116,"d":"0.280"}]
[{"v":1.9999999999999998,"d":"2.0"},{"v":0.29699999999999993,"d":"0.297"}]
[{"v":2.1999999999999997,"d":"2.2"},{"v":0.317636,"d":"0.318"}]
[2.4,{"v":0.342024,"d":"0.342"}]
[2.6,{"v":0.370164,"d":"0.370"}]
[{"v":2.8000000000000003,"d":"2.8"},{"v":0.4020560000000001,"d":"0.402"}]
[{"v":3.0000000000000004,"d":"3.0"},{"v":0.4377000000000001,"d":"0.438"}]
[{"v":3.2000000000000006,"d":"3.2"},{"v":0.4770960000000001,"d":"0.477"}]
[{"v":3.400000000000001,"d":"3.4"},{"v":0.5202440000000002,"d":"0.520"}]
[{"v":3.600000000000001,"d":"3.6"},{"v":0.5671440000000001,"d":"0.567"}]
[{"v":3.800000000000001,"d":"3.8"},{"v":0.6177960000000002,"d":"0.618"}]
[{"v":4.000000000000001,"d":"4.0"},{"v":0.6722000000000001,"d":"0.672"}]
[{"v":4.200000000000001,"d":"4.2"},{"v":0.7303560000000002,"d":"0.730"}]
[{"v":4.400000000000001,"d":"4.4"},{"v":0.7922640000000003,"d":"0.792"}]
[{"v":4.600000000000001,"d":"4.6"},{"v":0.8579240000000006,"d":"0.858"}]
[{"v":4.800000000000002,"d":"4.8"},{"v":0.9273360000000004,"d":"0.927"}]
[{"v":5.000000000000002,"d":"5.0"},{"v":1.0005000000000006,"d":"1.001"}]
[]
[]
["nº de indicador:",230,"función de transformación:","CA=(3E-02)x^2+(2,5E-01)","0<x<5"]
["Indicador:","Indice medio de calidad de los yacimientos arqueológicos (yacimentos marítimos)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",0.6]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D40<0,\"valor del indicador fuera de rango\",IF(D40<=5,0.03*(D40^2)+0.25,IF(D40>5,\"valor del indicador fuera de rango\")))","v":{"v":0.2608,"d":"0.261"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.03*(A43^2)+(0.25)","v":{"v":0.25,"d":"0.250"}}]
[{"$f":"+A43+0.2","v":0.2},{"v":0.2512,"d":"0.251"}]
[{"$f":"+A44+0.2","v":0.4},{"v":0.2548,"d":"0.255"}]
[{"v":0.6000000000000001,"d":"0.6"},{"v":0.2608,"d":"0.261"}]
[0.8,{"v":0.2692,"d":"0.269"}]
[{"v":1,"d":"1.0"},{"v":0.28,"d":"0.280"}]
[1.2,{"v":0.2932,"d":"0.293"}]
[1.4,{"v":0.30879999999999996,"d":"0.309"}]
[{"v":1.5999999999999999,"d":"1.6"},{"v":0.3268,"d":"0.327"}]
[{"v":1.7999999999999998,"d":"1.8"},{"v":0.34719999999999995,"d":"0.347"}]
[{"v":1.9999999999999998,"d":"2.0"},{"v":0.37,"d":"0.370"}]
[{"v":2.1999999999999997,"d":"2.2"},{"v":0.3952,"d":"0.395"}]
[2.4,{"v":0.42279999999999995,"d":"0.423"}]
[2.6,{"v":0.4528,"d":"0.453"}]
[{"v":2.8000000000000003,"d":"2.8"},{"v":0.4852000000000001,"d":"0.485"}]
[{"v":3.0000000000000004,"d":"3.0"},{"v":0.52,"d":"0.520"}]
[{"v":3.2000000000000006,"d":"3.2"},{"v":0.5572000000000001,"d":"0.557"}]
[{"v":3.400000000000001,"d":"3.4"},{"v":0.5968000000000002,"d":"0.597"}]
[{"v":3.600000000000001,"d":"3.6"},{"v":0.6388000000000001,"d":"0.639"}]
[{"v":3.800000000000001,"d":"3.8"},{"v":0.6832000000000003,"d":"0.683"}]
[{"v":4.000000000000001,"d":"4.0"},{"v":0.7300000000000002,"d":"0.730"}]
[{"v":4.200000000000001,"d":"4.2"},{"v":0.7792000000000002,"d":"0.779"}]
[{"v":4.400000000000001,"d":"4.4"},{"v":0.8308000000000003,"d":"0.831"}]
[{"v":4.600000000000001,"d":"4.6"},{"v":0.8848000000000004,"d":"0.885"}]
[{"v":4.800000000000002,"d":"4.8"},{"v":0.9412000000000005,"d":"0.941"}]
[{"v":5.000000000000002,"d":"5.0"},{"v":1.0000000000000004,"d":"1.000"}]

{"sheet":"231","index":3,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[6,2,6,4]]}
["nº de indicador:",231,"función de transformación:","CA=(2E-02)x^2+(1E-01)x","0<x<5"]
["Indicador:","Grado de conservación de las estructuras y edificaciones tradicionales"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","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<=5,0.02*(D5^2)+0.1*D5,IF(D5>5,\"valor del indicador fuera de rango\")))","v":0.055}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.02*(A8^2)+0.1*A8","v":{"v":0,"d":"0.000"}}]
[0.5,0.055]
[{"v":1,"d":"1.0"},{"v":0.12000000000000001,"d":"0.120"}]
[1.5,0.195]
[1.8,{"v":0.24480000000000002,"d":"0.245"}]
[{"$f":"+A12+0.2","v":{"v":2,"d":"2.0"}},{"v":0.28,"d":"0.280"}]
[2.2,{"v":0.3168,"d":"0.317"}]
[{"v":2.4000000000000004,"d":"2.4"},{"v":0.35520000000000007,"d":"0.355"}]
[{"v":2.6000000000000005,"d":"2.6"},{"v":0.3952000000000001,"d":"0.395"}]
[{"v":2.8000000000000007,"d":"2.8"},{"v":0.4368000000000002,"d":"0.437"}]
[{"v":3.000000000000001,"d":"3.0"},{"v":0.4800000000000002,"d":"0.480"}]
[{"v":3.200000000000001,"d":"3.2"},{"v":0.5248000000000003,"d":"0.525"}]
[{"v":3.4000000000000012,"d":"3.4"},{"v":0.5712000000000003,"d":"0.571"}]
[{"v":3.6000000000000014,"d":"3.6"},{"v":0.6192000000000004,"d":"0.619"}]
[{"v":3.8000000000000016,"d":"3.8"},{"v":0.6688000000000004,"d":"0.669"}]
[{"v":4.000000000000002,"d":"4.0"},{"v":0.7200000000000004,"d":"0.720"}]
[{"v":4.200000000000002,"d":"4.2"},{"v":0.7728000000000005,"d":"0.773"}]
[{"v":4.400000000000002,"d":"4.4"},{"v":0.8272000000000006,"d":"0.827"}]
[{"v":4.600000000000002,"d":"4.6"},{"v":0.8832000000000007,"d":"0.883"}]
[{"v":4.8000000000000025,"d":"4.8"},{"v":0.9408000000000007,"d":"0.941"}]
[{"v":5.000000000000003,"d":"5.0"},{"v":1.0000000000000009,"d":"1.000"}]