{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Registro","45-47","48-49","50-51","52-54","55"],"not_rendered":{"charts":11,"images":6,"external_links":3,"defined_names":11},"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":"45-47","index":1,"n_rows":81,"n_cols":5,"rows_kept":81,"merged":[[6,2,6,4],[33,2,33,4],[61,2,61,4]]}
["nº de indicador:",45,"función de transformación:","CA=(0,08*I^2)+ 0,8*I+2","(-5)<I<-2,5"]
["Indicador:","Tª media en el ambito de referencia",null,"CA=(-0,08*I^2)+1","(-2,5)<I<2,5"]
["fórmula del indicador"," tª media - tª media sin proyecto",null,"CA=(0,08*I^2)-0,8*I+2","2,5<I<5"]
["unidad del indicador:"]
["rango de valores del indicador:"," -5    -   5","valor del indicador",3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-5,\"valor del indicador fuera de rango\",IF(D5<=-2.5,(0.08*D5^2)+(0.8*D5)+2,IF(D5<=2.5,(-0.08*D5^2)+1,IF(D5<=5,(0.08*D5^2)-(0.8*D5)+2,\"valor del indicador fuera rango\"))))","v":{"v":0.3199999999999996,"d":"0.320"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-5,"d":"-5.0"},{"$f":"(0.08*A8^2)+ 0.8*A8+2","v":{"v":0,"d":"0.000"}}]
[-4.5,{"v":0.020000000000000018,"d":"0.020"}]
[{"v":-4,"d":"-4.0"},{"v":0.07999999999999985,"d":"0.080"}]
[-3.5,{"v":0.17999999999999972,"d":"0.180"}]
[{"v":-3,"d":"-3.0"},{"v":0.3199999999999996,"d":"0.320"}]
[-2.5,{"v":0.5,"d":"0.500"}]
[{"v":-2,"d":"-2.0"},{"$f":"(-0.08*A14^2)+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-1.5,{"v":0.8200000000000001,"d":"0.820"}]
[{"v":-1,"d":"-1.0"},{"v":0.92,"d":"0.920"}]
[-0.5,{"v":0.98,"d":"0.980"}]
[{"v":0,"d":"0.0"},{"v":1,"d":"1.000"}]
[0.5,{"v":0.98,"d":"0.980"}]
[{"v":1,"d":"1.0"},{"v":0.92,"d":"0.920"}]
[{"v":3,"d":"3.0"},{"$f":"(0.08*A21^2)-0.8*A21+2","v":{"v":0.3199999999999996,"d":"0.320"}}]
[3.5,{"$f":"(0.08*A22^2)-0.8*A22+2","v":{"v":0.17999999999999972,"d":"0.180"}}]
[{"v":4,"d":"4.0"},{"$f":"(0.08*A23^2)-0.8*A23+2","v":{"v":0.07999999999999985,"d":"0.080"}}]
[4.5,{"$f":"(0.08*A24^2)-0.8*A24+2","v":{"v":0.020000000000000018,"d":"0.020"}}]
[{"v":5,"d":"5.0"},{"$f":"(0.08*A25^2)-0.8*A25+2","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",46,"función de transformación:","CA=(0,08*I^2)+ 0,8*I+2","(-5)<I<-2,5"]
["Indicador:","Tª media ponderada por la superficie de zonas homogéneas",null,"CA=(-0,08*I^2)+1","(-2,5)<I<2,5"]
["fórmula del indicador",null,null,"CA=(0,08*I^2)-0,8*I+2","2,5<I<5"]
["unidad del indicador:"]
["rango de valores del indicador:"," -5    -   5","valor del indicador",4]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D32<-5,\"valor del indicador fuera de rango\",IF(D32<=-2.5,(0.08*D32^2)+(0.8*D32)+2,IF(D32<=2.5,(-0.08*D32^2)+1,IF(D32<=5,(0.08*D32^2)-(0.8*D32)+2,\"valor del indicador fuera rango\"))))","v":{"v":0.07999999999999985,"d":"0.080"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-5,"d":"-5.0"},{"$f":"(0.08*A35^2)+ 0.8*A35+2","v":{"v":0,"d":"0.000"}}]
[-4.5,{"v":0.020000000000000018,"d":"0.020"}]
[{"v":-4,"d":"-4.0"},{"v":0.07999999999999985,"d":"0.080"}]
[-3.5,{"v":0.17999999999999972,"d":"0.180"}]
[{"v":-3,"d":"-3.0"},{"v":0.3199999999999996,"d":"0.320"}]
[-2.5,{"v":0.5,"d":"0.500"}]
[{"v":-2,"d":"-2.0"},{"$f":"(-0.08*A41^2)+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-1.5,{"v":0.8200000000000001,"d":"0.820"}]
[{"v":-1,"d":"-1.0"},{"v":0.92,"d":"0.920"}]
[-0.5,{"v":0.98,"d":"0.980"}]
[{"v":0,"d":"0.0"},{"v":1,"d":"1.000"}]
[0.5,{"v":0.98,"d":"0.980"}]
[{"v":1,"d":"1.0"},{"v":0.92,"d":"0.920"}]
[2.5,{"v":0.5,"d":"0.500"}]
[{"v":3,"d":"3.0"},{"$f":"(0.08*A49^2)-0.8*A49+2","v":{"v":0.3199999999999996,"d":"0.320"}}]
[3.5,{"$f":"(0.08*A50^2)-0.8*A50+2","v":{"v":0.17999999999999972,"d":"0.180"}}]
[{"v":4,"d":"4.0"},{"$f":"(0.08*A51^2)-0.8*A51+2","v":{"v":0.07999999999999985,"d":"0.080"}}]
[4.5,{"$f":"(0.08*A52^2)-0.8*A52+2","v":{"v":0.020000000000000018,"d":"0.020"}}]
[{"v":5,"d":"5.0"},{"$f":"(0.08*A53^2)-0.8*A53+2","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",47,"función de transformación:","CA=(0,08*I^2)+ 0,8*I+2","(-5)<I<-2,5"]
["Indicador:","Tº media ponderada por la población residente en las diferentes zonas",null,"CA=(-0,08*I^2)+1","(-2,5)<I<2,5"]
["fórmula del indicador",null,null,"CA=(0,08*I^2)-0,8*I+2","2,5<I<5"]
["unidad del indicador:"]
["rango de valores del indicador:"," -5    -   5","valor del indicador",3]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D60<-5,\"valor del indicador fuera de rango\",IF(D60<=-2.5,(0.08*D60^2)+(0.8*D60)+2,IF(D60<=2.5,(-0.08*D60^2)+1,IF(D60<=5,(0.08*D60^2)-(0.8*D60)+2,\"valor del indicador fuera rango\"))))","v":{"v":0.3199999999999996,"d":"0.320"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-5,"d":"-5.0"},{"$f":"(0.08*A63^2)+ 0.8*A63+2","v":{"v":0,"d":"0.000"}}]
[-4.5,{"v":0.020000000000000018,"d":"0.020"}]
[{"v":-4,"d":"-4.0"},{"v":0.07999999999999985,"d":"0.080"}]
[-3.5,{"v":0.17999999999999972,"d":"0.180"}]
[{"v":-3,"d":"-3.0"},{"v":0.3199999999999996,"d":"0.320"}]
[-2.5,{"v":0.5,"d":"0.500"}]
[{"v":-2,"d":"-2.0"},{"$f":"(-0.08*A69^2)+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-1.5,{"v":0.8200000000000001,"d":"0.820"}]
[{"v":-1,"d":"-1.0"},{"v":0.92,"d":"0.920"}]
[-0.5,{"v":0.98,"d":"0.980"}]
[{"v":0,"d":"0.0"},{"v":1,"d":"1.000"}]
[0.5,{"v":0.98,"d":"0.980"}]
[{"v":1,"d":"1.0"},{"v":0.92,"d":"0.920"}]
[2.5,{"v":0.5,"d":"0.500"}]
[{"v":3,"d":"3.0"},{"$f":"(0.08*A77^2)-0.8*A77+2","v":{"v":0.3199999999999996,"d":"0.320"}}]
[3.5,{"$f":"(0.08*A78^2)-0.8*A78+2","v":{"v":0.17999999999999972,"d":"0.180"}}]
[{"v":4,"d":"4.0"},{"$f":"(0.08*A79^2)-0.8*A79+2","v":{"v":0.07999999999999985,"d":"0.080"}}]
[4.5,{"$f":"(0.08*A80^2)-0.8*A80+2","v":{"v":0.020000000000000018,"d":"0.020"}}]
[{"v":5,"d":"5.0"},{"$f":"(0.08*A81^2)-0.8*A81+2","v":{"v":0,"d":"0.000"}}]

{"sheet":"48-49","index":2,"n_rows":55,"n_cols":5,"rows_kept":55,"merged":[[6,2,6,4],[34,2,34,4]]}
["nº de indicador:",48,"función de transformación:","CA=2E-4*I^2+4E-2*I+2","(-100<I<-50)"]
["Indicador:","precipitaciones medias en el ámbito de referencia",null,"CA=-2E-4*I^2+1","(-50<I<50)"]
["fórmula del indicador","precip.media - precip.media \"sin\"proyecto",null,"CA=2E-4*I^2-4E-2*I+2","50<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:"," -100   -  100","valor del indicador",80]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-100,\"valor del indicador fuera de rango\",IF(D5<=-50,0.0002*D5^2+0.04*D5+2,IF(D5<=50,-0.0002*D5^2+1,IF(D5<=100,0.0002*D5^2-0.04*D5+2,IF(D5>100,\"valor del indicador fuera rango\")))))","v":{"v":0.07999999999999985,"d":"0.080"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-100,{"$f":"0.0002*A8^2+0.04*A8+2","v":{"v":0,"d":"0.000"}}]
[-90,{"v":0.020000000000000018,"d":"0.020"}]
[-80,{"v":0.07999999999999985,"d":"0.080"}]
[-70,{"v":0.17999999999999972,"d":"0.180"}]
[-60,{"v":0.3200000000000003,"d":"0.320"}]
[-50,{"v":0.5,"d":"0.500"}]
[-30,{"$f":"-0.0002*A14^2+1","v":{"v":0.82,"d":"0.820"}}]
[-20,{"$f":"-0.0002*A15^2+1","v":{"v":0.92,"d":"0.920"}}]
[-10,{"v":0.98,"d":"0.980"}]
[0,{"v":1,"d":"1.000"}]
[10,{"v":0.98,"d":"0.980"}]
[20,{"v":0.92,"d":"0.920"}]
[30,{"$f":"-0.0002*A20^2+1","v":{"v":0.82,"d":"0.820"}}]
[50,{"v":0.5,"d":"0.500"}]
[60,{"$f":"0.0002*A22^2-0.04*A22+2","v":0.3200000000000003}]
[70,{"$f":"0.0002*A23^2-0.04*A23+2","v":0.17999999999999972}]
[80,{"$f":"0.0002*A24^2-0.04*A24+2","v":0.07999999999999985}]
[90,{"$f":"0.0002*A25^2-0.04*A25+2","v":0.020000000000000018}]
[100,{"$f":"0.0002*A26^2-0.04*A26+2","v":0}]
[]
[]
["nº de indicador:",49,"función de transformación:","CA=2E-4*I^2+4E-2*I+2","(-100<I<-50)"]
["Indicador:","precipitaciones medias ponderadas según la superficie de zonas homogéneas",null,"CA=-2E-4*I^2+1","(-50<I<50)"]
["fórmula del indicador",null,null,"CA=2E-4*I^2-4E-2*I+2","50<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:"," -100   -  100","valor del indicador",90]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D33<-100,\"valor del indicador fuera de rango\",IF(D33<=-50,0.0002*D33^2+0.04*D33+2,IF(D33<=50,-0.0002*D33^2+1,IF(D33<=100,0.0002*D33^2-0.04*D33+2,IF(D33>100,\"valor del indicador fuera rango\")))))","v":{"v":0.020000000000000018,"d":"0.020"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-100,{"$f":"0.0002*A36^2+0.04*A36+2","v":{"v":0,"d":"0.000"}}]
[-90,{"v":0.020000000000000018,"d":"0.020"}]
[-80,{"v":0.07999999999999985,"d":"0.080"}]
[-70,{"v":0.17999999999999972,"d":"0.180"}]
[-60,{"v":0.3200000000000003,"d":"0.320"}]
[-50,{"v":0.5,"d":"0.500"}]
[-40,{"$f":"-0.0002*A42^2+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-30,{"$f":"-0.0002*A43^2+1","v":{"v":0.82,"d":"0.820"}}]
[-20,{"v":0.92,"d":"0.920"}]
[-10,{"v":0.98,"d":"0.980"}]
[0,{"v":1,"d":"1.000"}]
[10,{"v":0.98,"d":"0.980"}]
[20,{"$f":"-0.0002*A48^2+1","v":{"v":0.92,"d":"0.920"}}]
[40,{"v":0.6799999999999999,"d":"0.680"}]
[50,{"v":0.5,"d":"0.500"}]
[60,{"$f":"0.0002*A51^2-0.04*A51+2","v":0.3200000000000003}]
[70,{"$f":"0.0002*A52^2-0.04*A52+2","v":0.17999999999999972}]
[80,{"$f":"0.0002*A53^2-0.04*A53+2","v":0.07999999999999985}]
[90,{"$f":"0.0002*A54^2-0.04*A54+2","v":0.020000000000000018}]
[100,{"$f":"0.0002*A55^2-0.04*A55+2","v":0}]

{"sheet":"50-51","index":3,"n_rows":53,"n_cols":5,"rows_kept":53,"merged":[[6,2,6,4],[33,2,33,4]]}
["nº de indicador:",50,"función de transformación:","CA=2e-2*I^2","0<I<5"]
["Indicador:","velocidad del viento",null,"CA=-2e-2*I^2+4e-1*I-1","5<I<15"]
["fórmula del indicador",null,null,"CA=2e-2*I^2-8e-1*I+8","15<I<20"]
["unidad del indicador:","m s-1"]
["rango de valores del indicador:","0 - 20","valor del indicador",17]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<=0,\"valor del indicador fuera de rango\",IF(D5<=5,0.02*D5^2,IF(D5<=15,-0.02*D5^2+0.4*D5-1,IF(D5<=20,0.02*D5^2-0.8*D5+8,\"valor del indicador fuera rango\"))))","v":{"v":0.17999999999999883,"d":"0.180"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.02*A8^2","v":{"v":0,"d":"0.00"}}]
[1,0.02]
[2,0.08]
[3,0.18]
[4,0.32]
[5,{"v":0.5,"d":"0.50"}]
[6,{"$f":"-0.02*A14^2+0.4*A14-1","v":{"v":0.6800000000000004,"d":"0.68"}}]
[7,{"$f":"-0.02*A15^2+0.4*A15-1","v":{"v":0.8200000000000003,"d":"0.82"}}]
[8,{"v":0.9200000000000002,"d":"0.92"}]
[9,0.98]
[10,{"v":1,"d":"1.00"}]
[11,{"v":0.9800000000000004,"d":"0.98"}]
[12,{"v":0.9200000000000008,"d":"0.92"}]
[15,{"$f":"-0.02*A21^2+0.4*A21-1","v":{"v":0.5,"d":"0.50"}}]
[16,{"$f":"0.02*A22^2-0.8*A22+8","v":{"v":0.3199999999999994,"d":"0.32"}}]
[17,{"$f":"0.02*A23^2-0.8*A23+8","v":{"v":0.17999999999999883,"d":"0.18"}}]
[18,{"$f":"0.02*A24^2-0.8*A24+8","v":{"v":0.08000000000000007,"d":"0.08"}}]
[20,{"$f":"0.02*A25^2-0.8*A25+8","v":{"v":0,"d":"0.00"}}]
[]
[]
["nº de indicador:",51,"función de transformación:","CA=-1,12e-2*I+1","0<I<66,7"]
["Indicador:","% de superficie donde se acumula aire ponderadoporel número de días de helada que provoca esta acumulación",null,"CA=2,25e-4*I^2-4,5e-2*I+2,25","66,7<I<100"]
["fórmula del indicador",null,null,"CA=0","100<I<200"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 200","valor del indicador",180]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D32<0,\"valor del indicador fuera de rango\",IF(D32<=66.7,-0.0112*D32+1,IF(D32<=100,0.000225*D32^2-0.045*D32+2.25,IF(D32<=200,0,\"valor del indicador fuera rango\"))))","v":{"v":0,"d":"0.000"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0112*A35+1","v":{"v":1,"d":"1.000"}}]
[10,0.888]
[20,0.776]
[30,{"v":0.6639999999999999,"d":"0.664"}]
[40,0.552]
[50,{"v":0.44000000000000006,"d":"0.440"}]
[60,{"v":0.32799999999999996,"d":"0.328"}]
[66.7,{"v":0.25295999999999996,"d":"0.253"}]
[70,{"$f":"0.000225*A43^2-0.045*A43+2.25","v":{"v":0.20250000000000012,"d":"0.203"}}]
[80,{"$f":"0.000225*A44^2-0.045*A44+2.25","v":{"v":0.0900000000000003,"d":"0.090"}}]
[90,{"$f":"0.000225*A45^2-0.045*A45+2.25","v":{"v":0.022499999999999964,"d":"0.023"}}]
[100,{"$f":"0.000225*A46^2-0.045*A46+2.25","v":{"v":0,"d":"0.000"}}]
[110,{"v":0,"d":"0.000"}]
[120,{"v":0,"d":"0.000"}]
[130,{"v":0,"d":"0.000"}]
[140,{"v":0,"d":"0.000"}]
[150,{"v":0,"d":"0.000"}]
[160,{"v":0,"d":"0.000"}]
[200,{"v":0,"d":"0.000"}]

{"sheet":"52-54","index":4,"n_rows":85,"n_cols":5,"rows_kept":85,"merged":[[6,2,6,4],[35,2,35,4],[64,2,64,4]]}
["nº de indicador:",52,"función de transformación:","CA=2e-4*I^2+4e-2*I+2","(-100<I<50)"]
["Indicador:","radiación solar global",null,"CA=-2e-4*I^2+1","(-50<I<50)"]
["fórmula del indicador",null,null,"CA=2e-4*I^2+4e-2*I+2","50<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100   -   100","valor del indicador",-30]
["Tipo de indicador",null,"calidad ambiental",{"$f":"IF(D5<-100,\"valor del indicador fuera de rango\",IF(D5<=-50,0.0002*D5^2+0.04*D5+2,IF(D5<=50,-0.0002*D5^2+1,IF(D5<=100,0.0002*D5^2-0.04*D5+2,IF(D5>100,\"valor del indicador fuera rango\")))))","v":{"v":0.82,"d":"0.820"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-100,{"$f":"0.0002*A8^2+0.04*A8+2","v":{"v":0,"d":"0.000"}}]
[-90,{"v":0.020000000000000018,"d":"0.020"}]
[-80,{"v":0.07999999999999985,"d":"0.080"}]
[-70,{"v":0.17999999999999972,"d":"0.180"}]
[-60,{"v":0.3200000000000003,"d":"0.320"}]
[-50,{"v":0.5,"d":"0.500"}]
[-40,{"$f":"-0.0002*A14^2+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-30,{"$f":"-0.0002*A15^2+1","v":{"v":0.82,"d":"0.820"}}]
[-20,{"v":0.92,"d":"0.920"}]
[-10,{"$f":"-0.0002*A17^2+1","v":{"v":0.98,"d":"0.980"}}]
[0,{"v":1,"d":"1.000"}]
[10,{"v":0.98,"d":"0.980"}]
[20,{"$f":"-0.0002*A20^2+1","v":{"v":0.92,"d":"0.920"}}]
[40,{"v":0.6799999999999999,"d":"0.680"}]
[50,{"$f":"-0.0002*A22^2+1","v":{"v":0.5,"d":"0.500"}}]
[60,{"$f":"0.0002*A23^2-0.04*A23+2","v":{"v":0.3200000000000003,"d":"0.320"}}]
[70,{"$f":"0.0002*A24^2-0.04*A24+2","v":{"v":0.17999999999999972,"d":"0.180"}}]
[80,{"$f":"0.0002*A25^2-0.04*A25+2","v":{"v":0.07999999999999985,"d":"0.080"}}]
[90,{"$f":"0.0002*A26^2-0.04*A26+2","v":{"v":0.020000000000000018,"d":"0.020"}}]
[100,{"$f":"0.0002*A27^2-0.04*A27+2","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",53,"función de transformación:","CA=2e-4*I^2+4e-2*I+2","(-100<I<50)"]
["Indicador:","radiación solar ultravioleta",null,"CA=-2e-4*I^2+1","(-50<I<50)"]
["fórmula del indicador",null,null,"CA=2e-4*I^2+4e-2*I+2","50<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100   -   100","valor del indicador",-30]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D34<-100,\"valor del indicador fuera de rango\",IF(D34<=-50,0.0002*D34^2+0.04*D34+2,IF(D34<=50,-0.0002*D34^2+1,IF(D34<=100,0.0002*D34^2-0.04*D34+2,IF(D34>100,\"valor del indicador fuera rango\")))))","v":{"v":0.82,"d":"0.820"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-100,{"$f":"0.0002*A37^2+0.04*A37+2","v":{"v":0,"d":"0.000"}}]
[-90,{"v":0.020000000000000018,"d":"0.020"}]
[-80,{"v":0.07999999999999985,"d":"0.080"}]
[-70,{"v":0.17999999999999972,"d":"0.180"}]
[-60,{"v":0.3200000000000003,"d":"0.320"}]
[-50,{"v":0.5,"d":"0.500"}]
[-40,{"$f":"-0.0002*A43^2+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-30,{"$f":"-0.0002*A44^2+1","v":{"v":0.82,"d":"0.820"}}]
[-20,{"v":0.92,"d":"0.920"}]
[-10,{"$f":"-0.0002*A46^2+1","v":{"v":0.98,"d":"0.980"}}]
[0,{"v":1,"d":"1.000"}]
[10,{"v":0.98,"d":"0.980"}]
[20,{"$f":"-0.0002*A49^2+1","v":{"v":0.92,"d":"0.920"}}]
[40,{"v":0.6799999999999999,"d":"0.680"}]
[50,{"$f":"-0.0002*A51^2+1","v":{"v":0.5,"d":"0.500"}}]
[60,{"$f":"0.0002*A52^2-0.04*A52+2","v":{"v":0.3200000000000003,"d":"0.320"}}]
[70,{"$f":"0.0002*A53^2-0.04*A53+2","v":{"v":0.17999999999999972,"d":"0.180"}}]
[80,{"$f":"0.0002*A54^2-0.04*A54+2","v":{"v":0.07999999999999985,"d":"0.080"}}]
[90,{"$f":"0.0002*A55^2-0.04*A55+2","v":{"v":0.020000000000000018,"d":"0.020"}}]
[100,{"$f":"0.0002*A56^2-0.04*A56+2","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",54,"función de transformación:","CA=2e-4*I^2+4e-2*I+2","(-100<I<50)"]
["Indicador:","radiación solar ultravioleta",null,"CA=-2e-4*I^2+1","(-50<I<50)"]
["fórmula del indicador",null,null,"CA=2e-4*I^2+4e-2*I+2","50<I<100"]
["unidad del indicador:"]
["rango de valores del indicador:","  -100   -   100","valor del indicador",-30]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D63<-100,\"valor del indicador fuera de rango\",IF(D63<=-50,0.0002*D63^2+0.04*D63+2,IF(D63<=50,-0.0002*D63^2+1,IF(D63<=100,0.0002*D63^2-0.04*D63+2,IF(D63>100,\"valor del indicador fuera rango\")))))","v":{"v":0.82,"d":"0.820"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[-100,{"$f":"0.0002*A66^2+0.04*A66+2","v":{"v":0,"d":"0.000"}}]
[-90,{"v":0.020000000000000018,"d":"0.020"}]
[-80,{"v":0.07999999999999985,"d":"0.080"}]
[-70,{"v":0.17999999999999972,"d":"0.180"}]
[-60,{"v":0.3200000000000003,"d":"0.320"}]
[-50,{"v":0.5,"d":"0.500"}]
[-40,{"$f":"-0.0002*A72^2+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-30,{"$f":"-0.0002*A73^2+1","v":{"v":0.82,"d":"0.820"}}]
[-20,{"v":0.92,"d":"0.920"}]
[-10,{"$f":"-0.0002*A75^2+1","v":{"v":0.98,"d":"0.980"}}]
[0,{"v":1,"d":"1.000"}]
[10,{"v":0.98,"d":"0.980"}]
[20,{"$f":"-0.0002*A78^2+1","v":{"v":0.92,"d":"0.920"}}]
[40,{"v":0.6799999999999999,"d":"0.680"}]
[50,{"$f":"-0.0002*A80^2+1","v":{"v":0.5,"d":"0.500"}}]
[60,{"$f":"0.0002*A81^2-0.04*A81+2","v":{"v":0.3200000000000003,"d":"0.320"}}]
[70,{"$f":"0.0002*A82^2-0.04*A82+2","v":{"v":0.17999999999999972,"d":"0.180"}}]
[80,{"$f":"0.0002*A83^2-0.04*A83+2","v":{"v":0.07999999999999985,"d":"0.080"}}]
[90,{"$f":"0.0002*A84^2-0.04*A84+2","v":{"v":0.020000000000000018,"d":"0.020"}}]
[100,{"$f":"0.0002*A85^2-0.04*A85+2","v":{"v":0,"d":"0.000"}}]

{"sheet":"55","index":5,"n_rows":27,"n_cols":5,"rows_kept":27,"merged":[[6,2,6,4]]}
["nº de indicador:",55,"función de transformación:","CA=I","0<I<1"]
["Indicador:","Aptitud del clima para los usos principales del territorio (semicualitativo)",null,"CA=1","1<I<4"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 4","valor del indicador",3]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=1,D5,IF(D5<=4,(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"]
[{"v":0,"d":"0.0"},{"$f":"+A8","v":{"v":0,"d":"0.000"}}]
[{"$f":"+A8+0.2","v":0.2},{"$f":"+A9","v":{"v":0.2,"d":"0.200"}}]
[{"$f":"+A9+0.2","v":0.4},{"$f":"+A10","v":{"v":0.4,"d":"0.400"}}]
[{"v":0.6000000000000001,"d":"0.6"},{"$f":"+A11","v":{"v":0.6000000000000001,"d":"0.600"}}]
[0.8,{"$f":"+A12","v":{"v":0.8,"d":"0.800"}}]
[{"v":1,"d":"1.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[1.2,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[1.4,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":1.5999999999999999,"d":"1.6"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":1.7999999999999998,"d":"1.8"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":1.9999999999999998,"d":"2.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":2.1999999999999997,"d":"2.2"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[2.4,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[2.6,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":2.8000000000000003,"d":"2.8"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":3.0000000000000004,"d":"3.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":3.2000000000000006,"d":"3.2"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":3.400000000000001,"d":"3.4"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":3.600000000000001,"d":"3.6"},{"$f":"1","v":{"v":1,"d":"1.000"}}]
[{"v":4,"d":"4.0"},{"$f":"1","v":{"v":1,"d":"1.000"}}]