{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Registro","297","298","299","300-301","302","303-305","306","307"],"not_rendered":{"charts":11,"images":6,"external_links":11,"defined_names":89},"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":"297","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",297,"función de transformación:","CA=1,6E-01*I^2","0<I<2,5"]
["Indicador:","Grado de adecuación del equipamiento deportivo, de esparcimiento y recreo",null,"CA=-1,6E-01*I^2+8E-01*I","2,5<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",2.8]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=2.5,0.16*(D5^2),IF(D5<=5,(-0.16*(D5^2))+(0.8*D5),\"valor del indicador fuera rango\")))","v":{"v":0.9855999999999998,"d":"0.986"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.16*A8^2","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+0.3","v":0.3},{"v":0.0144,"d":"0.014"}]
[0.6,{"v":0.0576,"d":"0.058"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.12959999999999997,"d":"0.130"}]
[1.2,{"v":0.2304,"d":"0.230"}]
[1.5,{"v":0.36,"d":"0.360"}]
[1.8,{"v":0.5184000000000001,"d":"0.518"}]
[2.1,{"v":0.7056,"d":"0.706"}]
[2.4,{"v":0.9216,"d":"0.922"}]
[2.5,{"$f":"-0.16*A17^2+0.8*A17","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A17+0.3","v":2.8},{"v":0.9855999999999998,"d":"0.986"}]
[{"v":3.0999999999999996,"d":"3.1"},{"v":0.9424000000000003,"d":"0.942"}]
[{"v":3.3999999999999995,"d":"3.4"},{"v":0.8704000000000003,"d":"0.870"}]
[{"v":3.6999999999999993,"d":"3.7"},{"v":0.7696000000000005,"d":"0.770"}]
[{"v":3.999999999999999,"d":"4.0"},{"v":0.6400000000000006,"d":"0.640"}]
[{"v":4.299999999999999,"d":"4.3"},{"v":0.4816000000000007,"d":"0.482"}]
[{"v":4.599999999999999,"d":"4.6"},{"v":0.2944000000000009,"d":"0.294"}]
[{"v":5,"d":"5.0"},{"v":0,"d":"0.000"}]

{"sheet":"298","index":2,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",298,"función de transformación:","CA=1,6E-01*I^2","0<I<2,5"]
["Indicador:","Grado de adecuación de los equipamientos turísticos",null,"CA=-1,6E-01*I^2+8E-01*I","2,5<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",2.8]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=2.5,0.16*(D5^2),IF(D5<=5,(-0.16*(D5^2))+(0.8*D5),\"valor del indicador fuera rango\")))","v":{"v":0.9855999999999998,"d":"0.986"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.16*A8^2","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+0.3","v":0.3},{"v":0.0144,"d":"0.014"}]
[0.6,{"v":0.0576,"d":"0.058"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.12959999999999997,"d":"0.130"}]
[1.2,{"v":0.2304,"d":"0.230"}]
[1.5,{"v":0.36,"d":"0.360"}]
[1.8,{"v":0.5184000000000001,"d":"0.518"}]
[2.1,{"v":0.7056,"d":"0.706"}]
[2.4,{"v":0.9216,"d":"0.922"}]
[2.5,{"$f":"-0.16*A17^2+0.8*A17","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A17+0.3","v":2.8},{"v":0.9855999999999998,"d":"0.986"}]
[{"v":3.0999999999999996,"d":"3.1"},{"v":0.9424000000000003,"d":"0.942"}]
[{"v":3.3999999999999995,"d":"3.4"},{"v":0.8704000000000003,"d":"0.870"}]
[{"v":3.6999999999999993,"d":"3.7"},{"v":0.7696000000000005,"d":"0.770"}]
[{"v":3.999999999999999,"d":"4.0"},{"v":0.6400000000000006,"d":"0.640"}]
[{"v":4.299999999999999,"d":"4.3"},{"v":0.4816000000000007,"d":"0.482"}]
[{"v":4.599999999999999,"d":"4.6"},{"v":0.2944000000000009,"d":"0.294"}]
[{"v":5,"d":"5.0"},{"v":0,"d":"0.000"}]

{"sheet":"299","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",299,"función de transformación:","CA=1,6E-01*I^2","0<I<2,5"]
["Indicador:","Grado de adecuación de los servicios oficiales",null,"CA=-1,6E-01*I^2+8E-01*I","2,5<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",2.8]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=2.5,0.16*(D5^2),IF(D5<=5,(-0.16*(D5^2))+(0.8*D5),\"valor del indicador fuera rango\")))","v":{"v":0.9855999999999998,"d":"0.986"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.16*A8^2","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+0.3","v":0.3},{"v":0.0144,"d":"0.014"}]
[0.6,{"v":0.0576,"d":"0.058"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.12959999999999997,"d":"0.130"}]
[1.2,{"v":0.2304,"d":"0.230"}]
[1.5,{"v":0.36,"d":"0.360"}]
[1.8,{"v":0.5184000000000001,"d":"0.518"}]
[2.1,{"v":0.7056,"d":"0.706"}]
[2.4,{"v":0.9216,"d":"0.922"}]
[2.5,{"$f":"-0.16*A17^2+0.8*A17","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A17+0.3","v":2.8},{"v":0.9855999999999998,"d":"0.986"}]
[{"v":3.0999999999999996,"d":"3.1"},{"v":0.9424000000000003,"d":"0.942"}]
[{"v":3.3999999999999995,"d":"3.4"},{"v":0.8704000000000003,"d":"0.870"}]
[{"v":3.6999999999999993,"d":"3.7"},{"v":0.7696000000000005,"d":"0.770"}]
[{"v":3.999999999999999,"d":"4.0"},{"v":0.6400000000000006,"d":"0.640"}]
[{"v":4.299999999999999,"d":"4.3"},{"v":0.4816000000000007,"d":"0.482"}]
[{"v":4.599999999999999,"d":"4.6"},{"v":0.2944000000000009,"d":"0.294"}]
[{"v":5,"d":"5.0"},{"v":0,"d":"0.000"}]

{"sheet":"300-301","index":4,"n_rows":53,"n_cols":5,"rows_kept":53,"merged":[[6,2,6,4],[33,2,33,4]]}
["nº de indicador:",300,"función de transformación:","CA=5E-05I^2","0<I<100"]
["Indicador:","% de viajes en transporte público en relación a la situación sin proyecto",null,"CA=5E-03I","100<I<200"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 200","valor del indicador",70]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=100,0.00005*(D5^2),IF(D5<=200,(0.005*D5))))","v":{"v":0.24500000000000002,"d":"0.245"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.00005*A8^2","v":{"v":0,"d":"0.000"}}]
[20,{"v":0.02,"d":"0.020"}]
[40,{"v":0.08,"d":"0.080"}]
[{"$f":"+A10+10","v":50},0.125]
[60,{"v":0.18000000000000002,"d":"0.180"}]
[70,{"v":0.24500000000000002,"d":"0.245"}]
[80,{"v":0.32,"d":"0.320"}]
[90,0.405]
[100,{"v":0.5,"d":"0.500"}]
[120,{"$f":"0.005*A17","v":{"v":0.6,"d":"0.600"}}]
[130,{"v":0.65,"d":"0.650"}]
[140,{"v":0.7000000000000001,"d":"0.700"}]
[{"$f":"+A19+10","v":150},{"v":0.75,"d":"0.750"}]
[160,{"v":0.8,"d":"0.800"}]
[170,{"v":0.85,"d":"0.850"}]
[180,{"v":0.9,"d":"0.900"}]
[190,{"v":0.9500000000000001,"d":"0.950"}]
[200,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",301,"función de transformación:","CA=2E-02*I^2+2E-01I+5E-01","(-5)<I<0"]
["Indicador:","Variación de la relación transporte privado/transporte público",null,"CA=-2E-02*I^2+2E-01*I+5E-01","0<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","  -5  -  5","valor del indicador",0.6]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D32<-5,\"valor del indicador fuera de rango\",IF(D32<=0,0.02*D32^2+0.2*D32+0.5,IF(D32<=5,-0.02*D32^2+0.2*D32+0.5,\"valor del indicador fuera de rango\")))","v":{"v":0.6128,"d":"0.613"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-5,"d":"-5.0"},{"$f":"0.02*A35^2+0.2*A35+0.5","v":{"v":0,"d":"0.000"}}]
[{"v":-4,"d":"-4.0"},{"v":0.019999999999999962,"d":"0.020"}]
[{"v":-3,"d":"-3.0"},{"v":0.0799999999999999,"d":"0.080"}]
[{"$f":"+A37+0.5","v":-2.5},0.125]
[{"v":-2,"d":"-2.0"},{"v":0.18,"d":"0.180"}]
[{"$f":"+A39+0.5","v":-1.5},{"v":0.24499999999999994,"d":"0.245"}]
[{"v":-1,"d":"-1.0"},{"v":0.31999999999999995,"d":"0.320"}]
[-0.5,0.405]
[{"v":0,"d":"0.0"},{"v":0.5,"d":"0.500"}]
[0.5,{"$f":"-0.02*A44^2+0.2*A44+0.5","v":0.595}]
[{"v":1,"d":"1.0"},{"v":0.68,"d":"0.680"}]
[1.5,{"v":0.7550000000000001,"d":"0.755"}]
[{"v":2,"d":"2.0"},{"v":0.8200000000000001,"d":"0.820"}]
[2.5,0.875]
[{"v":3,"d":"3.0"},{"v":0.9200000000000002,"d":"0.920"}]
[3.5,{"v":0.9550000000000001,"d":"0.955"}]
[{"v":4,"d":"4.0"},{"v":0.98,"d":"0.980"}]
[4.5,{"$f":"-0.02*A52^2+0.2*A52+0.5","v":0.995}]
[{"$f":"+A52+0.5","v":{"v":5,"d":"5.0"}},{"$f":"-0.02*A53^2+0.2*A53+0.5","v":{"v":1,"d":"1.000"}}]

{"sheet":"302","index":5,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",302,"función de transformación:","CA=1,6E-01*I^2","0<I<2,5"]
["Indicador:","Grado de adecuación de las comunicaciones",null,"CA=-1,6E-01*I^2+8E-01*I","2,5<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",2.8]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=2.5,0.16*(D5^2),IF(D5<=5,(-0.16*(D5^2))+(0.8*D5),\"valor del indicador fuera rango\")))","v":{"v":0.9855999999999998,"d":"0.986"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.16*A8^2","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+0.3","v":0.3},{"v":0.0144,"d":"0.014"}]
[0.6,{"v":0.0576,"d":"0.058"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.12959999999999997,"d":"0.130"}]
[1.2,{"v":0.2304,"d":"0.230"}]
[1.5,{"v":0.36,"d":"0.360"}]
[1.8,{"v":0.5184000000000001,"d":"0.518"}]
[2.1,{"v":0.7056,"d":"0.706"}]
[2.4,{"v":0.9216,"d":"0.922"}]
[2.5,{"$f":"-0.16*A17^2+0.8*A17","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A17+0.3","v":2.8},{"v":0.9855999999999998,"d":"0.986"}]
[{"v":3.0999999999999996,"d":"3.1"},{"v":0.9424000000000003,"d":"0.942"}]
[{"v":3.3999999999999995,"d":"3.4"},{"v":0.8704000000000003,"d":"0.870"}]
[{"v":3.6999999999999993,"d":"3.7"},{"v":0.7696000000000005,"d":"0.770"}]
[{"v":3.999999999999999,"d":"4.0"},{"v":0.6400000000000006,"d":"0.640"}]
[{"v":4.299999999999999,"d":"4.3"},{"v":0.4816000000000007,"d":"0.482"}]
[{"v":4.599999999999999,"d":"4.6"},{"v":0.2944000000000009,"d":"0.294"}]
[{"v":5,"d":"5.0"},{"v":0,"d":"0.000"}]

{"sheet":"303-305","index":6,"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:",303,"función de transformación:","CA=0","0<I<0,75"]
["Indicador:","Relación viviendas disponibles/viviendas demandadas",null,"CA=4*I-3","0,75<I<1"]
["fórmula del indicador",null,null,"CA=-(I^2)+2*I","1<I<2"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 2","valor del indicador",1.1]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=0.75,0,IF(D5<=1,(D5*4)-3,IF(D5<=2,-(D5^2)+(2*D5)))))","v":{"v":0.99,"d":"0.990"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"v":0,"d":"0.000"}]
[{"v":0.2,"d":"0.20"},{"v":0,"d":"0.000"}]
[{"v":0.4,"d":"0.40"},{"v":0,"d":"0.000"}]
[{"v":0.6,"d":"0.60"},{"v":0,"d":"0.000"}]
[0.75,{"$f":"(4*A12)-3","v":{"v":0,"d":"0.000"}}]
[{"v":0.8,"d":"0.80"},{"v":0.20000000000000018,"d":"0.200"}]
[0.85,{"v":0.3999999999999999,"d":"0.400"}]
[{"v":0.9,"d":"0.90"},{"v":0.6000000000000001,"d":"0.600"}]
[0.95,{"v":0.7999999999999998,"d":"0.800"}]
[{"v":1,"d":"1.00"},{"v":1,"d":"1.000"}]
[{"v":1.2,"d":"1.20"},{"$f":"-(A18^2)+(2*A18)","v":{"v":0.96,"d":"0.960"}}]
[{"v":1.4,"d":"1.40"},{"$f":"-(A19^2)+(2*A19)","v":{"v":0.8400000000000001,"d":"0.840"}}]
[{"v":1.6,"d":"1.60"},{"$f":"-(A20^2)+(2*A20)","v":{"v":0.6399999999999997,"d":"0.640"}}]
[{"v":1.8,"d":"1.80"},{"$f":"-(A21^2)+(2*A21)","v":{"v":0.3599999999999999,"d":"0.360"}}]
[{"v":2,"d":"2.00"},{"$f":"-(A22^2)+(2*A22)","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",304,"función de transformación:","CA=5E-01*I+5E-01","0<I<1"]
["Indicador:","Relación entre segundas residencias ofertadas y demandadas",null,"CA=-I^2+2*I","1<I<2"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 2","valor del indicador",1.8]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D29<0,\"valor del indicador fuera de rango\",IF(D29<=1,0.5*(D29)+0.5,IF(D29<=2,-(D29^2)+2*(D29))))","v":{"v":0.3599999999999999,"d":"0.360"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"0.5*A32+0.5","v":{"v":0.5,"d":"0.500"}}]
[{"$f":"+A32+0.15","v":0.15},0.575]
[{"$f":"+A33+0.15","v":{"v":0.3,"d":"0.30"}},{"v":0.65,"d":"0.650"}]
[{"v":0.44999999999999996,"d":"0.45"},0.725]
[{"v":0.6,"d":"0.60"},{"v":0.8,"d":"0.800"}]
[0.75,0.875]
[{"v":0.9,"d":"0.90"},{"$f":"0.5*A38+0.5","v":{"v":0.95,"d":"0.950"}}]
[1.05,{"$f":"-(A39^2)+2*A39","v":{"v":0.9975,"d":"0.998"}}]
[{"v":1.2,"d":"1.20"},{"$f":"-(A40^2)+2*A40","v":{"v":0.96,"d":"0.960"}}]
[{"v":1.3499999999999999,"d":"1.35"},{"v":0.8775000000000002,"d":"0.878"}]
[{"v":1.4999999999999998,"d":"1.50"},{"v":0.7500000000000004,"d":"0.750"}]
[{"v":1.6499999999999997,"d":"1.65"},{"v":0.5775000000000006,"d":"0.578"}]
[{"v":1.7999999999999996,"d":"1.80"},{"v":0.36000000000000076,"d":"0.360"}]
[{"v":1.9499999999999995,"d":"1.95"},{"v":0.09750000000000103,"d":"0.098"}]
[{"v":2,"d":"2.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",305,"función de transformación:","CA=5E-01*I+5E-01","0<I<1"]
["Indicador:","Relación entre las camas hoteleras disponibles y demandadas",null,"CA=-I^2+2*I","1<I<2"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 2","valor del indicador",1.8]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D53<0,\"valor del indicador fuera de rango\",IF(D53<=1,0.5*(D53)+0.5,IF(D53<=2,-(D53^2)+2*(D53))))","v":{"v":0.3599999999999999,"d":"0.360"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"0.5*A56+0.5","v":{"v":0.5,"d":"0.500"}}]
[{"$f":"+A56+0.15","v":0.15},0.575]
[{"$f":"+A57+0.15","v":{"v":0.3,"d":"0.30"}},{"v":0.65,"d":"0.650"}]
[{"v":0.44999999999999996,"d":"0.45"},0.725]
[{"v":0.6,"d":"0.60"},{"v":0.8,"d":"0.800"}]
[0.75,0.875]
[{"v":0.9,"d":"0.90"},{"v":0.95,"d":"0.950"}]
[1.05,{"$f":"-(A63^2)+2*A63","v":{"v":0.9975,"d":"0.998"}}]
[{"v":1.2,"d":"1.20"},{"$f":"-(A64^2)+2*A64","v":{"v":0.96,"d":"0.960"}}]
[{"v":1.3499999999999999,"d":"1.35"},{"v":0.8775000000000002,"d":"0.878"}]
[{"v":1.4999999999999998,"d":"1.50"},{"v":0.7500000000000004,"d":"0.750"}]
[{"v":1.6499999999999997,"d":"1.65"},{"v":0.5775000000000006,"d":"0.578"}]
[{"v":1.7999999999999996,"d":"1.80"},{"v":0.36000000000000076,"d":"0.360"}]
[{"v":1.9499999999999995,"d":"1.95"},{"v":0.09750000000000103,"d":"0.098"}]
[{"v":2,"d":"2.00"},{"v":0,"d":"0.000"}]

{"sheet":"306","index":7,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",306,"función de transformación:","CA=1,6E-01*I^2","0<I<2,5"]
["Indicador:","Grado de adecuación del sistema sanitario",null,"CA=-1,6E-01*I^2+8E-01*I","2,5<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",2.8]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=2.5,0.16*(D5^2),IF(D5<=5,(-0.16*(D5^2))+(0.8*D5),\"valor del indicador fuera rango\")))","v":{"v":0.9855999999999998,"d":"0.986"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.16*A8^2","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+0.3","v":0.3},{"v":0.0144,"d":"0.014"}]
[0.6,{"v":0.0576,"d":"0.058"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.12959999999999997,"d":"0.130"}]
[1.2,{"v":0.2304,"d":"0.230"}]
[1.5,{"v":0.36,"d":"0.360"}]
[1.8,{"v":0.5184000000000001,"d":"0.518"}]
[2.1,{"v":0.7056,"d":"0.706"}]
[2.4,{"v":0.9216,"d":"0.922"}]
[2.5,{"$f":"-0.16*A17^2+0.8*A17","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A17+0.3","v":2.8},{"v":0.9855999999999998,"d":"0.986"}]
[{"v":3.0999999999999996,"d":"3.1"},{"v":0.9424000000000003,"d":"0.942"}]
[{"v":3.3999999999999995,"d":"3.4"},{"v":0.8704000000000003,"d":"0.870"}]
[{"v":3.6999999999999993,"d":"3.7"},{"v":0.7696000000000005,"d":"0.770"}]
[{"v":3.999999999999999,"d":"4.0"},{"v":0.6400000000000006,"d":"0.640"}]
[{"v":4.299999999999999,"d":"4.3"},{"v":0.4816000000000007,"d":"0.482"}]
[{"v":4.599999999999999,"d":"4.6"},{"v":0.2944000000000009,"d":"0.294"}]
[{"v":5,"d":"5.0"},{"v":0,"d":"0.000"}]

{"sheet":"307","index":8,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",307,"función de transformación:","CA=1,6E-01*I^2","0<I<2,5"]
["Indicador:","Grado de adecuación de los equipamientos educativos",null,"CA=-1,6E-01*I^2+8E-01*I","2,5<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",2.8]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=2.5,0.16*(D5^2),IF(D5<=5,(-0.16*(D5^2))+(0.8*D5),\"valor del indicador fuera rango\")))","v":{"v":0.9855999999999998,"d":"0.986"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"0.16*A8^2","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+0.3","v":0.3},{"v":0.0144,"d":"0.014"}]
[0.6,{"v":0.0576,"d":"0.058"}]
[{"v":0.8999999999999999,"d":"0.9"},{"v":0.12959999999999997,"d":"0.130"}]
[1.2,{"v":0.2304,"d":"0.230"}]
[1.5,{"v":0.36,"d":"0.360"}]
[1.8,{"v":0.5184000000000001,"d":"0.518"}]
[2.1,{"v":0.7056,"d":"0.706"}]
[2.4,{"v":0.9216,"d":"0.922"}]
[2.5,{"$f":"-0.16*A17^2+0.8*A17","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A17+0.3","v":2.8},{"v":0.9855999999999998,"d":"0.986"}]
[{"v":3.0999999999999996,"d":"3.1"},{"v":0.9424000000000003,"d":"0.942"}]
[{"v":3.3999999999999995,"d":"3.4"},{"v":0.8704000000000003,"d":"0.870"}]
[{"v":3.6999999999999993,"d":"3.7"},{"v":0.7696000000000005,"d":"0.770"}]
[{"v":3.999999999999999,"d":"4.0"},{"v":0.6400000000000006,"d":"0.640"}]
[{"v":4.299999999999999,"d":"4.3"},{"v":0.4816000000000007,"d":"0.482"}]
[{"v":4.599999999999999,"d":"4.6"},{"v":0.2944000000000009,"d":"0.294"}]
[{"v":5,"d":"5.0"},{"v":0,"d":"0.000"}]