{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Registro","154","155-156","157-159","160","161-163","164-165","166-167","168-171"],"not_rendered":{"charts":18,"images":9,"external_links":5,"defined_names":27},"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":"154","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[6,2,6,4]]}
["nº de indicador:",154,"función de transformación:","CA=-1E-04x2+1","0<I<100"]
["Indicador:","% de superficie alterada"]
["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)+1,\"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+1","v":{"v":1,"d":"1.000"}}]
[10,{"$f":"-0.0001*A9^2+1","v":{"v":0.99,"d":"0.990"}}]
[20,{"v":0.96,"d":"0.960"}]
[30,{"v":0.91,"d":"0.910"}]
[40,{"v":0.84,"d":"0.840"}]
[45,{"v":0.7975,"d":"0.798"}]
[{"$f":"A13+5","v":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"}]
[95,{"v":0.09749999999999992,"d":"0.097"}]
[100,{"v":0,"d":"0.000"}]

{"sheet":"155-156","index":2,"n_rows":60,"n_cols":5,"rows_kept":60,"merged":[[6,2,6,4],[38,2,38,4]]}
["nº de indicador:",155,"función de transformación:","CA=-1E-04x2+2E-02x","0<I<100"]
["Indicador:","% de variación de coeficiente de interés de la naturaleza del fondo marino con respecto a las condiciones \"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)+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"}}]
[3,{"$f":"-0.0001*A9^2+0.02*A9","v":{"v":0.0591,"d":"0.059"}}]
[6,{"v":0.11639999999999999,"d":"0.116"}]
[10,{"v":0.19,"d":"0.190"}]
[13,{"v":0.2431,"d":"0.243"}]
[16,{"v":0.2944,"d":"0.294"}]
[20,{"v":0.36000000000000004,"d":"0.360"}]
[{"$f":"A14+5","v":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"}]
[95,{"v":0.9975,"d":"0.998"}]
[100,{"v":1,"d":"1.000"}]
[]
[]
["nº de indicador:",156,"función de transformación:","CA=6,67E-03I","0<I<75"]
["Indicador:","% de variación de coeficiente de interés de la naturaleza del fondo marino con respecto a las condiciones naturales",null,"CA=(4E-04*I2) -(5E-02*I) +2","75<I<100"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 100","valor del indicador",80]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D37<0,\"valor del indicador fuera de rango\",IF(D37<=75,0.00667*D37,IF(D37<=100,(0.0004*(D37^2))-(0.05*D37)+2,\"valor del indicador fuera rango\")))","v":{"v":0.56,"d":"0.560"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.00667*A40","v":{"v":0,"d":"0.000"}}]
[{"$f":"A40+5","v":5},{"v":0.03335,"d":"0.033"}]
[10,{"v":0.0667,"d":"0.067"}]
[15,{"v":0.10005,"d":"0.100"}]
[20,{"v":0.1334,"d":"0.133"}]
[25,{"v":0.16674999999999998,"d":"0.167"}]
[30,{"v":0.2001,"d":"0.200"}]
[35,{"v":0.23345,"d":"0.233"}]
[40,{"v":0.2668,"d":"0.267"}]
[45,{"v":0.30015,"d":"0.300"}]
[50,{"v":0.33349999999999996,"d":"0.334"}]
[55,{"v":0.36685,"d":"0.367"}]
[60,{"v":0.4002,"d":"0.400"}]
[65,{"v":0.43355,"d":"0.434"}]
[70,{"v":0.4669,"d":"0.467"}]
[75,{"$f":"0.00667*A55","v":{"v":0.50025,"d":"0.500"}}]
[80,{"$f":"(0.0004*A56^2)-(0.05*A56)+2","v":{"v":0.56,"d":"0.560"}}]
[{"$f":"A56+5","v":85},{"$f":"(0.0004*A57^2)-(0.05*A57)+2","v":{"v":0.6400000000000001,"d":"0.640"}}]
[{"$f":"A57+5","v":90},{"$f":"(0.0004*A58^2)-(0.05*A58)+2","v":{"v":0.7400000000000002,"d":"0.740"}}]
[95,{"$f":"(0.0004*A59^2)-(0.05*A59)+2","v":{"v":0.8600000000000003,"d":"0.860"}}]
[100,{"$f":"(0.0004*A60^2)-(0.05*A60)+2","v":{"v":1,"d":"1.000"}}]

{"sheet":"157-159","index":3,"n_rows":98,"n_cols":5,"rows_kept":98,"merged":[[6,2,6,4],[40,2,40,4],[73,2,73,4]]}
["nº de indicador:",157,"función de transformación:","CA=-2E-01*I+1","0<I<5"]
["Indicador:","Indicador de disminución de corriente (corrientes fuertes y muy fuertes)."]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",4]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=5,(-0.2*D5)+1,\"valor del indicador fuera rango\"))","v":{"v":0.19999999999999996,"d":"0.200"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.2*A8+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A8+0.2","v":{"v":0.2,"d":"0.20"}},{"v":0.96,"d":"0.960"}]
[{"$f":"A9+0.2","v":{"v":0.4,"d":"0.40"}},{"v":0.9199999999999999,"d":"0.920"}]
[{"v":0.6000000000000001,"d":"0.60"},{"v":0.88,"d":"0.880"}]
[{"v":0.8,"d":"0.80"},{"v":0.84,"d":"0.840"}]
[{"v":1,"d":"1.00"},{"v":0.8,"d":"0.800"}]
[{"v":1.2,"d":"1.20"},{"v":0.76,"d":"0.760"}]
[{"v":1.4,"d":"1.40"},{"v":0.72,"d":"0.720"}]
[{"v":1.5999999999999999,"d":"1.60"},{"v":0.6799999999999999,"d":"0.680"}]
[{"v":1.7999999999999998,"d":"1.80"},{"v":0.64,"d":"0.640"}]
[{"v":1.9999999999999998,"d":"2.00"},{"v":0.6000000000000001,"d":"0.600"}]
[{"v":2.1999999999999997,"d":"2.20"},{"v":0.56,"d":"0.560"}]
[{"v":2.4,"d":"2.40"},{"v":0.52,"d":"0.520"}]
[{"v":2.6,"d":"2.60"},{"v":0.48,"d":"0.480"}]
[{"v":2.8000000000000003,"d":"2.80"},{"v":0.43999999999999995,"d":"0.440"}]
[{"v":3.0000000000000004,"d":"3.00"},{"v":0.3999999999999999,"d":"0.400"}]
[{"v":3.2000000000000006,"d":"3.20"},{"v":0.3599999999999999,"d":"0.360"}]
[{"v":3.400000000000001,"d":"3.40"},{"v":0.31999999999999984,"d":"0.320"}]
[{"v":3.600000000000001,"d":"3.60"},{"v":0.2799999999999998,"d":"0.280"}]
[{"v":3.800000000000001,"d":"3.80"},{"v":0.23999999999999977,"d":"0.240"}]
[{"v":4.000000000000001,"d":"4.00"},{"v":0.19999999999999973,"d":"0.200"}]
[{"v":4.200000000000001,"d":"4.20"},{"v":0.1599999999999997,"d":"0.160"}]
[{"v":4.400000000000001,"d":"4.40"},{"v":0.11999999999999966,"d":"0.120"}]
[{"v":4.600000000000001,"d":"4.60"},{"v":0.07999999999999963,"d":"0.080"}]
[{"v":5,"d":"5.00"},{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",158,"función de transformación:","CA=-3,33E-01*I+1","0<I<3"]
["Indicador:","Indicador de disminución de corriente (corrientes medias)",null,"CA=0","3<I<5"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 5","valor del indicador",4]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D39<0,\"valor del indicador fuera de rango\",IF(D39<=3,(-0.333*D39)+1,IF(D39<=5,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"]
[{"v":0,"d":"0.00"},{"$f":"-0.333*A42+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A42+0.2","v":{"v":0.2,"d":"0.20"}},{"v":0.9334,"d":"0.933"}]
[{"$f":"A43+0.2","v":{"v":0.4,"d":"0.40"}},{"v":0.8668,"d":"0.867"}]
[{"v":0.6000000000000001,"d":"0.60"},{"v":0.8002,"d":"0.800"}]
[{"v":0.8,"d":"0.80"},{"v":0.7336,"d":"0.734"}]
[{"v":1,"d":"1.00"},0.667]
[{"v":1.2,"d":"1.20"},{"v":0.6004,"d":"0.600"}]
[{"v":1.4,"d":"1.40"},{"v":0.5338,"d":"0.534"}]
[{"v":1.5999999999999999,"d":"1.60"},{"v":0.46720000000000006,"d":"0.467"}]
[{"v":1.7999999999999998,"d":"1.80"},{"v":0.40060000000000007,"d":"0.401"}]
[{"v":1.9999999999999998,"d":"2.00"},{"v":0.3340000000000001,"d":"0.334"}]
[{"v":2.1999999999999997,"d":"2.20"},{"v":0.2674000000000001,"d":"0.267"}]
[{"v":2.4,"d":"2.40"},{"v":0.20079999999999998,"d":"0.201"}]
[{"v":2.6,"d":"2.60"},{"v":0.13419999999999987,"d":"0.134"}]
[{"v":2.8000000000000003,"d":"2.80"},{"v":0.06759999999999988,"d":"0.068"}]
[{"v":3.0000000000000004,"d":"3.00"},{"v":9.9999999999977884E-4,"d":"0.001"}]
[{"v":3.2000000000000006,"d":"3.20"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3.400000000000001,"d":"3.40"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3.600000000000001,"d":"3.60"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3.800000000000001,"d":"3.80"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":4.000000000000001,"d":"4.00"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":4.200000000000001,"d":"4.20"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":4.5,"d":"4.50"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":5,"d":"5.00"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",159,"función de transformación:","CA=-I+1","0<I<1"]
["Indicador:","Indicador de disminución de corriente (corrientes debiles y muy débiles)",null,"CA=0","1<I<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(D72<0,\"valor del indicador fuera de rango\",IF(D72<=1,(-D72)+1,IF(D72<=5,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"]
[{"v":0,"d":"0.00"},{"$f":"-A75+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"A75+0.2","v":{"v":0.2,"d":"0.20"}},{"$f":"-A76+1","v":{"v":0.8,"d":"0.800"}}]
[{"$f":"A76+0.2","v":{"v":0.4,"d":"0.40"}},{"$f":"-A77+1","v":{"v":0.6,"d":"0.600"}}]
[{"v":0.6000000000000001,"d":"0.60"},{"$f":"-A78+1","v":{"v":0.3999999999999999,"d":"0.400"}}]
[{"v":0.8,"d":"0.80"},{"$f":"-A79+1","v":{"v":0.19999999999999996,"d":"0.200"}}]
[{"v":1,"d":"1.00"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":1.2,"d":"1.20"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":1.4,"d":"1.40"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":1.5999999999999999,"d":"1.60"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":1.7999999999999998,"d":"1.80"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":1.9999999999999998,"d":"2.00"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":2.1999999999999997,"d":"2.20"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":2.4,"d":"2.40"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":2.6,"d":"2.60"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":2.8000000000000003,"d":"2.80"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3.0000000000000004,"d":"3.00"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3.2000000000000006,"d":"3.20"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3.400000000000001,"d":"3.40"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3.600000000000001,"d":"3.60"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3.800000000000001,"d":"3.80"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":4.000000000000001,"d":"4.00"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":4.200000000000001,"d":"4.20"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":4.5,"d":"4.50"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":5,"d":"5.00"},{"$f":"0","v":{"v":0,"d":"0.000"}}]

{"sheet":"160","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[6,2,6,4]]}
["nº de indicador:",160,"función de transformación:","CA=(5E-01*I2)+(2*I)+2","(-2)<I<-1"]
["Indicador:","tª media en el ámbito de referencia",null,"CA=(-5E-01*I2)+1","(-1)<I<1"]
["fórmula del indicador","tª media- tª media\"sin proyecto\"",null,"CA=(5E-01*I2)-(2*I)+2","1<I<2"]
["unidad del indicador:","ºC"]
["rango de valores del indicador:"," -2 - 2","valor del indicador",1.6]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<-2,\"valor del indicador fuera de rango\",IF(D5<=-1,0.5*D5^2+2*D5+2,IF(D5<=1,-0.5*D5^2+1,IF(D5<=2,0.5*D5^2-2*D5+2,\"valor del indicador fuera rango\"))))","v":{"v":0.08000000000000007,"d":"0.080"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":-2,"d":"-2.0"},{"$f":"(0.5*A8^2)+(2*A8)+2","v":{"v":0,"d":"0.000"}}]
[-1.8,{"v":0.020000000000000018,"d":"0.020"}]
[-1.6,{"v":0.08000000000000007,"d":"0.080"}]
[-1.4,{"v":0.18000000000000016,"d":"0.180"}]
[-1.2,{"v":0.32000000000000006,"d":"0.320"}]
[{"v":-1,"d":"-1.0"},{"v":0.5,"d":"0.500"}]
[-0.8,{"$f":"(-0.5*A14^2)+1","v":{"v":0.6799999999999999,"d":"0.680"}}]
[-0.6,{"$f":"(-0.5*A15^2)+1","v":{"v":0.8200000000000001,"d":"0.820"}}]
[-0.2,{"$f":"(-0.5*A16^2)+1","v":{"v":0.98,"d":"0.980"}}]
[{"v":0,"d":"0.0"},{"v":1,"d":"1.000"}]
[0.2,{"v":0.98,"d":"0.980"}]
[0.4,{"v":0.9199999999999999,"d":"0.920"}]
[0.6,{"v":0.8200000000000001,"d":"0.820"}]
[{"v":1,"d":"1.0"},{"v":0.5,"d":"0.500"}]
[1.2,{"$f":"(0.5*A22^2)-(2*A22)+2","v":{"v":0.32000000000000006,"d":"0.320"}}]
[1.4,{"$f":"(0.5*A23^2)-(2*A23)+2","v":{"v":0.18000000000000016,"d":"0.180"}}]
[1.8,{"$f":"(0.5*A24^2)-(2*A24)+2","v":{"v":0.020000000000000018,"d":"0.020"}}]
[{"v":2,"d":"2.0"},{"$f":"(0.5*A25^2)-(2*A25)+2","v":{"v":0,"d":"0.000"}}]

{"sheet":"161-163","index":5,"n_rows":85,"n_cols":5,"rows_kept":85,"merged":[[6,2,6,4],[36,2,36,4],[66,2,66,4]]}
["nº de indicador:",161,"función de transformación:","y=-6,67E-03x2+1,67E-01x","0<x<10"]
["Indicador:","Profundidad del disco de Secci (bahías abiertas)",null,"y=1","10<x<20"]
["fórmula del indicador"]
["unidad del indicador:","m"]
["rango de valores del indicador:","0 - 20","valor del indicador",12]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=9,-0.00667*(D5^2)+(0.167*D5),IF(D5<=20,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"]
[0,{"$f":"-0.00667*(A8^2)+(0.167*A8)","v":{"v":0,"d":"0.000"}}]
[{"$f":"A8+1","v":1},{"v":0.16033,"d":"0.160"}]
[{"$f":"A9+1","v":2},{"v":0.30732000000000004,"d":"0.307"}]
[3,{"v":0.44097,"d":"0.441"}]
[4,{"v":0.56128,"d":"0.561"}]
[5,{"v":0.6682500000000001,"d":"0.668"}]
[6,{"v":0.76188,"d":"0.762"}]
[7,{"v":0.8421700000000001,"d":"0.842"}]
[8,{"v":0.9091200000000002,"d":"0.909"}]
[9,{"v":0.9627300000000001,"d":"0.963"}]
[10,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[11,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[12,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[13,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[14,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[15,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[16,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[17,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[18,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[19,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[20,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[]
[]
["nº de indicador:",162,"función de transformación:","y=-6,67E-03x2+1,67E-01x","0<x<10"]
["Indicador:","Profundidad del disco de Secci (bahías cerradas)",null,"y=1","10<x<20"]
["fórmula del indicador"]
["unidad del indicador:","m"]
["rango de valores del indicador:","0 - 20","valor del indicador",12]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D35<0,\"valor del indicador fuera de rango\",IF(D35<=9,-0.00667*(D35^2)+(0.167*D35),IF(D35<=20,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"]
[0,{"$f":"0.01*(A38^2)","v":{"v":0,"d":"0.000"}}]
[{"$f":"A38+1","v":1},{"v":0.01,"d":"0.010"}]
[{"$f":"A39+1","v":2},{"v":0.04,"d":"0.040"}]
[3,{"v":0.09,"d":"0.090"}]
[4,{"v":0.16,"d":"0.160"}]
[5,{"v":0.25,"d":"0.250"}]
[6,{"v":0.36,"d":"0.360"}]
[7,{"v":0.49,"d":"0.490"}]
[8,{"v":0.64,"d":"0.640"}]
[9,{"v":0.81,"d":"0.810"}]
[10,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[11,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[12,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[13,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[14,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[15,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[16,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[17,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[18,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[19,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[20,{"$f":"1","v":{"v":1,"d":"1.000"}}]
[]
[]
["nº de indicador:",163,"función de transformación:","CA=1,38E-04I2-1,89E-02I+1","0<I<50"]
["Indicador:","Turbidez de las aguas",null,"CA=-4,44E-03I+6,22E-01","50<I<140"]
["fórmula del indicador"]
["unidad del indicador:","unidades Jackson"]
["rango de valores del indicador:","0 - 140","valor del indicador",100]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D65<0,\"valor del indicador fuera de rango\",IF(D65<=50,0.000138*D65^2-0.0189*D65+1,IF(D65<=140,-0.00444*D65+0.622,\"valor del indicador fuera rango\")))","v":{"v":0.17799999999999994,"d":"0.178"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"0.000138*A68^2-0.0189*A68+1","v":{"v":1,"d":"1.000"}}]
[5,{"v":0.90895,"d":"0.909"}]
[10,{"v":0.8248,"d":"0.825"}]
[15,{"v":0.74755,"d":"0.748"}]
[20,{"v":0.6772,"d":"0.677"}]
[{"$f":"+A72+10","v":30},{"v":0.5572,"d":"0.557"}]
[40,{"v":0.4648,"d":"0.465"}]
[50,{"v":0.3999999999999999,"d":"0.400"}]
[60,{"$f":"-0.00444*A76+0.622","v":{"v":0.35559999999999997,"d":"0.356"}}]
[70,{"v":0.3112,"d":"0.311"}]
[80,{"v":0.2668,"d":"0.267"}]
[90,{"v":0.2224,"d":"0.222"}]
[100,{"v":0.17799999999999994,"d":"0.178"}]
[110,{"v":0.13359999999999994,"d":"0.134"}]
[120,{"v":0.08919999999999995,"d":"0.089"}]
[130,{"v":0.04479999999999995,"d":"0.045"}]
[135,{"v":0.022599999999999953,"d":"0.023"}]
[140,{"v":3.9999999999995595E-4,"d":"0.000"}]

{"sheet":"164-165","index":6,"n_rows":48,"n_cols":5,"rows_kept":48,"merged":[[6,2,6,4],[31,2,31,4]]}
["nº de indicador:",164,"función de transformación:","y=-2,5E-03x+1","0<x<100"]
["Indicador:","Concentración de coliformes fecales",null,"y=-8,33E-04x+8,33E-01","100<x<1000"]
["fórmula del indicador"]
["unidad del indicador:","nº / 100ml"]
["rango de valores del indicador:","0 - 1000","valor del indicador",300]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=100,-0.0025*(D5)+1,IF(D5<=1000,-0.000833*(D5)+0.833,\"valor del indicador fuera rango\")))","v":{"v":0.5831,"d":"0.583"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0025*(A8)+1","v":{"v":1,"d":"1.000"}}]
[20,{"$f":"-0.0025*(A9)+1","v":{"v":0.95,"d":"0.950"}}]
[30,{"$f":"-0.0025*(A10)+1","v":0.925}]
[40,{"$f":"-0.0025*(A11)+1","v":{"v":0.9,"d":"0.900"}}]
[50,0.875]
[60,{"v":0.85,"d":"0.850"}]
[80,{"v":0.8,"d":"0.800"}]
[90,0.775]
[100,{"v":0.75,"d":"0.750"}]
[200,{"$f":"-0.000833*(A17)+0.833","v":{"v":0.6664,"d":"0.666"}}]
[400,{"v":0.49979999999999997,"d":"0.500"}]
[600,{"v":0.3332,"d":"0.333"}]
[700,{"v":0.2499,"d":"0.250"}]
[800,{"v":0.16659999999999997,"d":"0.167"}]
[900,{"v":0.08330000000000004,"d":"0.083"}]
[1000,{"v":0,"d":"0.000"}]
[]
[]
["nº de indicador:",165,"función de transformación:","y=1.25E-03x2-1,5E-01x+4,5","60<x<80"]
["Indicador:","% de saturación de oxígeno disuelto",null,"y=-1,25E-03x2+2,5E-01x-1,15E01","80<x<100"]
["fórmula del indicador"]
["unidad del indicador:","%"]
["rango de valores del indicador:","60 - 100","valor del indicador",84]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D30<60,\"valor del indicador fuera de rango\",IF(D30<=80,0.00125*(D30^2)-0.15*(D30)+4.5,IF(D30<=100,-0.00125*(D30^2)+0.25*(D30)-11.5,\"valor del indicador fuera rango\")))","v":{"v":0.6799999999999997,"d":"0.680"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[60,{"$f":"0.00125*(A33^2)-0.15*A33+4.5","v":{"v":0,"d":"0.000"}}]
[63,{"$f":"0.00125*(A34^2)-0.15*A34+4.5","v":{"v":0.011250000000000426,"d":"0.011"}}]
[66,{"v":0.04499999999999993,"d":"0.045"}]
[70,0.125]
[{"$f":"+A36+2","v":72},{"v":0.1800000000000015,"d":"0.180"}]
[{"$f":"+A37+2","v":74},{"v":0.2450000000000001,"d":"0.245"}]
[{"$f":"+A38+2","v":76},{"v":0.3199999999999994,"d":"0.320"}]
[{"$f":"+A39+2","v":78},{"v":0.40500000000000114,"d":"0.405"}]
[{"$f":"+A40+2","v":80},{"v":0.5,"d":"0.500"}]
[{"$f":"+A41+3","v":83},{"$f":"-0.00125*(A42^2)+0.25*(A42)-11.5","v":{"v":0.6387499999999999,"d":"0.639"}}]
[86,{"v":0.754999999999999,"d":"0.755"}]
[89,{"v":0.848749999999999,"d":"0.849"}]
[92,{"v":0.9199999999999999,"d":"0.920"}]
[95,{"v":0.96875,"d":"0.969"}]
[98,{"v":0.9949999999999992,"d":"0.995"}]
[100,{"v":1,"d":"1.000"}]

{"sheet":"166-167","index":7,"n_rows":48,"n_cols":5,"rows_kept":48,"merged":[[6,2,6,4],[31,2,31,4]]}
["nº de indicador:",166,"función de transformación:","y=-4E-04x+1","0<x<500"]
["Indicador:","Coliformes fecales por 100ml de arena",null,"y=-6E-01x+1,1","500<x<1500"]
["fórmula del indicador",null,null,"y=-4E-04x+8E-01","1500<x<2000"]
["unidad del indicador:","nº / 100ml"]
["rango de valores del indicador:","0 - 2000","valor del indicador",1800]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=500,-0.0004*(D5)+1,IF(D5<=1500,-0.0006*(D5)+1.1,IF(D5<=2000,-0.0004*(D5)+0.8,\"valor del indicador fuera rango\"))))","v":{"v":0.07999999999999996,"d":"0.080"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[0,{"$f":"-0.0004*(A8)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A8+130","v":130},{"$f":"-0.0004*(A9)+1","v":0.948}]
[{"$f":"+A9+130","v":260},{"$f":"-0.0004*(A10)+1","v":0.896}]
[390,{"$f":"-0.0004*(A11)+1","v":0.844}]
[520,{"$f":"-0.0006*(A12)+1.1","v":0.788}]
[650,{"v":0.7100000000000002,"d":"0.710"}]
[780,{"v":0.6320000000000001,"d":"0.632"}]
[910,{"v":0.5540000000000002,"d":"0.554"}]
[1040,{"v":0.4760000000000001,"d":"0.476"}]
[1170,{"v":0.39800000000000013,"d":"0.398"}]
[1300,{"v":0.3200000000000002,"d":"0.320"}]
[1430,{"v":0.24200000000000021,"d":"0.242"}]
[1560,{"$f":"-0.0004*A20+0.8","v":{"v":0.17600000000000005,"d":"0.176"}}]
[1690,{"$f":"-0.0004*A21+0.8","v":0.124}]
[1820,{"$f":"-0.0004*A22+0.8","v":{"v":0.07200000000000006,"d":"0.072"}}]
[2000,{"$f":"-0.0004*A23+0.8","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",167,"función de transformación:","y=-2E-02x2+1","0<x<5"]
["Indicador:","Residuos sólidos no naturales",null,"y=2E-02x2-4E-01x +2","5<x<10"]
["fórmula del indicador","no hay"]
["unidad del indicador:","g m-2"]
["rango de valores del indicador:","0 - 10","valor del indicador",7]
["Tipo de indicador","2 (T=0,25)","calidad ambiental",{"$f":"IF(D30<0,\"valor del indicador fuera de rango\",IF(D30<=5,-0.02*((D30^2))+1,IF(D30<=10,0.02*((D30^2))-0.4*(D30)+2,\"valor del indicador fuera rango\")))","v":{"v":0.17999999999999972,"d":"0.180"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"-0.02*(A33^2)+1","v":{"v":1,"d":"1.000"}}]
[0.5,0.995]
[{"v":1,"d":"1.0"},{"v":0.98,"d":"0.980"}]
[1.5,0.955]
[{"v":2,"d":"2.0"},{"v":0.92,"d":"0.920"}]
[2.5,0.875]
[{"v":3,"d":"3.0"},{"v":0.8200000000000001,"d":"0.820"}]
[3.5,0.755]
[{"v":4,"d":"4.0"},{"v":0.6799999999999999,"d":"0.680"}]
[4.5,0.595]
[{"v":5,"d":"5.0"},{"$f":"0.02*(A43^2)-0.4*A43+2","v":{"v":0.5,"d":"0.500"}}]
[{"$f":"+A43+1","v":{"v":6,"d":"6.0"}},{"v":0.3199999999999996,"d":"0.320"}]
[{"$f":"+A44+1","v":{"v":7,"d":"7.0"}},{"v":0.17999999999999972,"d":"0.180"}]
[{"$f":"+A45+1","v":{"v":8,"d":"8.0"}},{"v":0.07999999999999985,"d":"0.080"}]
[{"$f":"+A46+1","v":{"v":9,"d":"9.0"}},{"v":0.020000000000000018,"d":"0.020"}]
[{"$f":"+A47+1","v":{"v":10,"d":"10.0"}},{"v":0,"d":"0.000"}]

{"sheet":"168-171","index":8,"n_rows":114,"n_cols":5,"rows_kept":114,"merged":[[6,2,6,4],[35,2,35,4],[64,2,64,4],[93,2,93,4]]}
["nº de indicador:",168,"función de transformación:","y=-5E-01x+1","0<x<2"]
["Indicador:","Indicador cualitativo de la calidad perceptible del agua (color, materias flotantes y grasas y aceites)",null,"y=0","2<x<6"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 6","valor del indicador",2.4]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D5<0,\"valor del indicador fuera de rango\",IF(D5<=2,-0.5*(D5)+1,IF(D5<=6,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"]
[{"v":0,"d":"0.0"},{"$f":"-0.5*(A8)+1","v":{"v":1,"d":"1.000"}}]
[0.3,{"v":0.85,"d":"0.850"}]
[0.6,{"v":0.7,"d":"0.700"}]
[{"v":1,"d":"1.0"},{"v":0.5,"d":"0.500"}]
[1.3,{"v":0.35,"d":"0.350"}]
[1.6,{"v":0.19999999999999996,"d":"0.200"}]
[{"v":2,"d":"2.0"},{"v":0,"d":"0.000"}]
[2.1,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[2.5,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":3,"d":"3.0"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[3.3,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[3.6,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[3.9,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[4.2,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[4.5,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[4.8,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[5.1,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[5.4,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[5.7,{"$f":"0","v":{"v":0,"d":"0.000"}}]
[{"v":6,"d":"6.0"},{"$f":"0","v":{"v":0,"d":"0.000"}}]
[]
[]
["nº de indicador:",169,"función de transformación:","y=-3,5E-02x2-9,5E-02x+1","0<x<3"]
["Indicador:","Indicador cualitativo de la calidad perceptible del agua (sin olor)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 3","valor del indicador",0.15]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D34<0,\"valor del indicador fuera de rango\",IF(D34<=3,-0.035*(D34^2)-0.095*(D34)+1,))","v":{"v":0.9849625,"d":"0.985"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.00"},{"$f":"-0.035*(A37^2)-0.095*(A37)+1","v":{"v":1,"d":"1.000"}}]
[{"$f":"+A37+0.15","v":0.15},{"$f":"-0.035*(A38^2)-0.095*(A38)+1","v":{"v":0.9849625,"d":"0.985"}}]
[{"$f":"+A38+0.15","v":{"v":0.3,"d":"0.30"}},{"v":0.96835,"d":"0.968"}]
[{"v":0.44999999999999996,"d":"0.45"},{"v":0.9501625,"d":"0.950"}]
[{"v":0.6,"d":"0.60"},{"v":0.9304,"d":"0.930"}]
[0.75,{"v":0.9090625,"d":"0.909"}]
[{"v":0.9,"d":"0.90"},{"v":0.88615,"d":"0.886"}]
[1.05,{"v":0.8616625,"d":"0.862"}]
[{"v":1.2,"d":"1.20"},{"v":0.8356,"d":"0.836"}]
[{"v":1.3499999999999999,"d":"1.35"},{"v":0.8079625,"d":"0.808"}]
[{"v":1.4999999999999998,"d":"1.50"},{"v":0.77875,"d":"0.779"}]
[{"v":1.6499999999999997,"d":"1.65"},{"v":0.7479625000000001,"d":"0.748"}]
[{"v":1.7999999999999996,"d":"1.80"},{"v":0.7156,"d":"0.716"}]
[{"v":1.9499999999999995,"d":"1.95"},{"v":0.6816625000000001,"d":"0.682"}]
[{"v":2.0999999999999996,"d":"2.10"},{"v":0.6461500000000001,"d":"0.646"}]
[{"v":2.2499999999999996,"d":"2.25"},{"v":0.6090625000000001,"d":"0.609"}]
[{"v":2.3999999999999995,"d":"2.40"},{"v":0.5704000000000001,"d":"0.570"}]
[{"v":2.5499999999999994,"d":"2.55"},{"v":0.5301625000000001,"d":"0.530"}]
[{"v":2.6999999999999993,"d":"2.70"},{"v":0.4883500000000002,"d":"0.488"}]
[{"v":3,"d":"3.00"},{"v":0.3999999999999999,"d":"0.400"}]
[]
[]
["nº de indicador:",170,"función de transformación:","y=-5E-02x2-5E-02x+0,7","0<x<3"]
["Indicador:","Indicador cualitativo de la calidad perceptible del agua (olor imperceptible)"]
["fórmula del indicador"]
["unidad del indicador:"]
["rango de valores del indicador:","0 - 3","valor del indicador",0.15]
["Tipo de indicador","3 (T=0,50)","calidad ambiental",{"$f":"IF(D63<0,\"valor del indicador fuera de rango\",IF(D63<=3,-0.05*(D63^2)-0.05*(D63)+0.7,\"valor del indicador fuera de rango\"))","v":{"v":0.691375,"d":"0.691"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"-0.05*(A66^2)-0.05*(A66)+0.7","v":{"v":0.7,"d":"0.700"}}]
[{"$f":"+A66+0.15","v":{"v":0.15,"d":"0.2"}},{"v":0.691375,"d":"0.691"}]
[{"$f":"+A67+0.15","v":0.3},{"v":0.6805,"d":"0.681"}]
[{"v":0.44999999999999996,"d":"0.5"},{"v":0.6673749999999999,"d":"0.667"}]
[0.6,{"v":0.6519999999999999,"d":"0.652"}]
[{"v":0.75,"d":"0.8"},{"v":0.6343749999999999,"d":"0.634"}]
[0.9,{"v":0.6144999999999999,"d":"0.615"}]
[{"v":1.05,"d":"1.1"},{"v":0.592375,"d":"0.592"}]
[1.2,0.568]
[{"v":1.3499999999999999,"d":"1.4"},{"v":0.5413749999999999,"d":"0.541"}]
[{"v":1.4999999999999998,"d":"1.5"},{"v":0.5125,"d":"0.513"}]
[{"v":1.6499999999999997,"d":"1.7"},{"v":0.481375,"d":"0.481"}]
[{"v":1.7999999999999996,"d":"1.8"},{"v":0.44800000000000006,"d":"0.448"}]
[{"v":1.9499999999999995,"d":"2.0"},{"v":0.41237500000000005,"d":"0.412"}]
[{"v":2.0999999999999996,"d":"2.1"},{"v":0.37450000000000006,"d":"0.375"}]
[{"v":2.2499999999999996,"d":"2.3"},{"v":0.33437500000000003,"d":"0.334"}]
[{"v":2.3999999999999995,"d":"2.4"},{"v":0.2920000000000001,"d":"0.292"}]
[{"v":2.5499999999999994,"d":"2.6"},{"v":0.24737500000000012,"d":"0.247"}]
[{"v":2.6999999999999993,"d":"2.7"},{"v":0.20050000000000012,"d":"0.201"}]
[{"v":3,"d":"3.0"},{"v":0.09999999999999987,"d":"0.100"}]
[]
[]
["nº de indicador:",171,"función de transformación:","y=-2,5E-02x2-2,5E-02x+3E-01","0<x<3"]
["Indicador:","Indicador cualitativo de la calidad perceptible del agua (olor notorio)"]
["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(D92<0,\"valor del indicador fuera de rango\",IF(D92<=3,-0.025*(D92^2)-0.025*(D92)+0.3,\"valor del indicador fuera de rango\"))","v":{"v":0.14999999999999997,"d":"0.150"}}]
["valor del  indicador","calidad ambiental","representación de la función de transformación"]
[{"v":0,"d":"0.0"},{"$f":"-0.025*(A95^2)-0.025*(A95)+0.3","v":{"v":0.3,"d":"0.300"}}]
[{"$f":"+A95+0.15","v":{"v":0.15,"d":"0.2"}},{"v":0.2956875,"d":"0.296"}]
[{"$f":"+A96+0.15","v":0.3},{"v":0.29025,"d":"0.290"}]
[{"v":0.44999999999999996,"d":"0.5"},{"v":0.2836875,"d":"0.284"}]
[0.6,{"v":0.27599999999999997,"d":"0.276"}]
[{"v":0.75,"d":"0.8"},{"v":0.26718749999999997,"d":"0.267"}]
[0.9,{"v":0.25725,"d":"0.257"}]
[{"v":1.05,"d":"1.1"},{"v":0.24618749999999998,"d":"0.246"}]
[1.2,{"v":0.23399999999999999,"d":"0.234"}]
[{"v":1.3499999999999999,"d":"1.4"},{"v":0.2206875,"d":"0.221"}]
[{"v":1.4999999999999998,"d":"1.5"},{"v":0.20625000000000002,"d":"0.206"}]
[{"v":1.6499999999999997,"d":"1.7"},{"v":0.1906875,"d":"0.191"}]
[{"v":1.7999999999999996,"d":"1.8"},{"v":0.17400000000000004,"d":"0.174"}]
[{"v":1.9499999999999995,"d":"2.0"},{"v":0.15618750000000003,"d":"0.156"}]
[{"v":2.0999999999999996,"d":"2.1"},{"v":0.13725000000000004,"d":"0.137"}]
[{"v":2.2499999999999996,"d":"2.3"},{"v":0.11718750000000003,"d":"0.117"}]
[{"v":2.3999999999999995,"d":"2.4"},{"v":0.09600000000000006,"d":"0.096"}]
[{"v":2.5499999999999994,"d":"2.6"},{"v":0.07368750000000007,"d":"0.074"}]
[{"v":2.6999999999999993,"d":"2.7"},{"v":0.05025000000000007,"d":"0.050"}]
[{"v":3,"d":"3.0"},{"v":0,"d":"0.000"}]