{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Registro","Cualitativa","Cuantitativa","Comentarios Cualitativa","Comentarios Cuantitativa"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Registro","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["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-612-5875-8"]

{"sheet":"Cualitativa","index":1,"n_rows":24,"n_cols":41,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,14,5,15],[3,8,3,10],[3,11,3,15],[4,13,4,15],[3,3,3,4],[3,5,3,7],[4,8,4,12],[4,3,4,4],[4,5,4,7],[0,0,1,15],[7,0,8,0],[23,5,23,12],[23,16,23,23],[7,16,7,23],[7,5,7,12],[3,22,3,29],[3,0,4,2],[7,27,8,27],[7,13,7,15],[2,0,2,15],[4,22,4,29],[5,22,5,29],[5,0,5,4],[5,7,5,13],[5,5,5,6],[9,0,23,0],[7,3,8,3],[7,1,8,1],[9,40,22,40],[7,28,7,35],[7,36,7,38],[7,40,8,40],[9,39,22,39],[7,39,8,39],[23,29,23,35],[7,24,7,26],[23,2,23,4],[7,4,8,4],[7,2,8,2]]}
[" valoración cualititativa de impactos ambientales"]
[]
["se reparten 1000 UIP entre todos los factores ambientales"]
["Fórmula de la importancia:                     I = +-(3IN + 2EX + MO + PE + CR + EF + II + PR)",null,null,"Intensidad (IN).                Baja=1;                  Media=2;                               Alta=4;                                          Muy alta=8;                    Total=12",null,"Extensión (EX). Puntual=1; Parcial=2; Extenso=4; Total=8         Crítico (+4)",null,null,"Momento (MO). Largo plazo=1;                  Medio plazo=2;                    Inmediato=4;                          Crítico (+4)",null,null,"Capacidad de recuperación (CR). Reversible=2;                                        Ireversible-Recuperable=4;                             Irreversible-Mitigable=8;                    Irreversible-Irrecuperable=12",null,null,null,null,null,null,null,null,null,null,"mportancia global ponderada del impacto sobre el entorno generado por el proyecto en ausencia de medidas correctoras (INP)",null,null,null,null,null,null,null,{"$f":"SUM($AB1:$AB882)","v":0}]
[null,null,null,"Persistencia (PE). Fugaz=1;                    Temporal=2;                       Permanente=4",null,"Efecto (EF). Indirecto=1;                              Directo=4",null,null,"Interrelación de impactos (II)               Simple=2;                                 Acumulativo=4;                                                         Sinérgico=8",null,null,null,null,"Periodicidad (PR). Irregular=1; Periodico=2; Continuo=4",null,null,null,null,null,null,null,null,"Importancia global ponderada del impacto sobre el entorno generado por el proyecto más las medidas correctoras  (INCC)",null,null,null,null,null,null,null,{"$f":"SUM(AN1:AN9882)","v":0}]
["máximo valor de la importancia         (Imax)",null,null,null,null,100,null,"mínimo valor de la importancia            (Imin)",null,null,null,null,null,null,13,null,null,null,null,null,null,null,"Importancia total del impacto provocado por el proyecto y las medidas correctoras (INP+CC)",null,null,null,null,null,null,null,{"$f":"$AE$4+$AE$5","v":0}]
[]
["Subfactor","Pj","Acción","Impacto","signo","atributos de los impactos POSITIVOS ",null,null,null,null,null,null,null,"Importancia",null,null,"atributos de los impactos NEGATIVOS SIN medidas correctoras",null,null,null,null,null,null,null,"Importancia",null,null,"CC","atributos de los impactos NEGATIVOS  CON medidas correctoras (con+CC)",null,null,null,null,null,null,null,"Importancia",null,null,"IpjCC","Juicio global"]
[null,null,null,null,null,"IN","EX","MO","PE","CR","EF","II","PR","I+ij","Ist+ij","Ip+ij","IN","EX","MO","PE","CR","EF","II","PR","I-ij","Ist-ij","Ip-ij",null,"IN con+CC","EX con+CC","MO con+CC","PE con+CC","CR con+CC","EF con+CC","II  con+CC","PR con+CC","I-ij   con+CC","Ist-ij con+CC","Ip-ij con+CC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3*$F10)+(2*$G10)+$H10+$I10+$J10+$K10+$L10+M10","v":0},{"$f":"IF($N10<>0,(($N10-$O$6)/($F$6-$O$6))*100,0)","v":0},{"$f":"($O10*$B10)/100","v":0},null,null,null,null,null,null,null,null,{"$f":"(3*$Q10)+(2*$R10)+$S10+$T10+$U10+$V10+$W10+$X10","v":0},{"$f":"IF($Y10<>0,(($Y10-$O$6)/($F$6-$O$6))*100,0)","v":0},{"$f":"($Z10*$B10)/100","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(3*$AC10)+(2*$AD10)+$AE10+$AF10+$AG10+$AH10+$AI10+$AJ10","v":0},{"$f":"IF($AK10<>0,(($AK10-$O$6)/($F$6-$O$6))*100,0)","v":0},{"$f":"($AL10*$B10)/100","v":0},{"$f":"$AO24-$AB24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3*$F11)+(2*$G11)+$H11+$I11+$J11+$K11+$L11+M11","v":0},0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($AK11<>0,(($AK11-$O$6)/($F$6-$O$6))*100,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3*$F12)+(2*$G12)+$H12+$I12+$J12+$K12+$L12+M12","v":0},0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,"Importancias globales positivos: I+j; Ist+j; Ip+j;",null,null,null,null,null,null,null,{"$f":"IF(SUM($N10:$N23),(1-EXP(-((SUM($N10:$N23)/COUNTIF($N10:$N23,\">0\"))^1)))*($F$6-(MAX($N10:$N23)))*(1-1/(EXP((((COUNTIF($N10:$N23,\">0\")^1)-1)*0.1))))+(MAX($N10:$N23)),0)","v":0},0,{"$f":"IF(SUM($N10:$N23),(($O24*$B24)/100),0)","v":0},"Importancias globales negativos: I+j; Ist+j; Ip+j;",null,null,null,null,null,null,null,{"$f":"IF(SUM($Y10:$Y23),(1-EXP(-((SUM($Y10:$Y23)/COUNTIF($Y10:$Y23,\">0\"))^1)))*($F$6-(MAX($Y10:$Y23)))*(1-1/(EXP((((COUNTIF($Y10:$Y23,\">0\")^1)-1)*0.1))))+(MAX($Y10:$Y23)),0)","v":0},0,{"$f":"IF(SUM($Y10:$Y23),(($Z24*$B24)/100),0)","v":0},{"$f":"+P24-AA24","v":0},"Ipj","Importancias globales negativos+CC: I+j; Ist+j; Ip+j;",null,null,null,null,null,null,{"$f":"IF(SUM($AK10:$AK23),(1-EXP(-((SUM($AK10:$AK23)/COUNTIF($AK10:$AK23,\">0\"))^1)))*($F$6-(MAX($AK10:$AK23)))*(1-1/(EXP((((COUNTIF($AK10:$AK23,\">0\")^1)-1)*0.1))))+(MAX($AK10:$AK23)),0)","v":0},{"$f":"IF($AK24<>0,(($AK24-$O$6)/($F$6-$O$6))*100,0)","v":0},{"$f":"IF(SUM($AK10:$AK23),(($AL24*$B24)/100),0)","v":0},"Ipjcon+CC",{"$f":"$P24-$AM24","v":0}]

{"sheet":"Cuantitativa","index":2,"n_rows":24,"n_cols":52,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,51,8,51],[9,0,23,0],[9,23,22,23],[9,24,22,24],[9,26,22,26],[9,27,22,27],[9,28,22,28],[9,29,22,29],[7,34,7,39],[7,5,7,10],[7,11,7,13],[7,4,8,4],[23,45,23,48],[7,49,7,50],[23,49,23,50],[23,2,23,4],[3,9,3,12],[5,5,5,11],[4,3,4,4],[9,51,23,51],[23,5,23,10],[23,14,23,19],[23,33,23,39],[9,30,22,30],[9,31,22,31],[9,32,22,32],[9,49,22,49],[9,48,22,48],[9,46,22,46],[9,47,22,47],[9,44,22,44],[9,43,22,43],[0,0,1,12],[2,0,2,12],[3,23,3,29],[7,3,8,3],[5,23,5,29],[4,5,4,9],[5,0,5,3],[7,1,8,1],[7,2,8,2],[7,23,7,32],[7,20,7,22],[7,0,8,0],[3,0,4,2],[3,3,3,4],[3,5,3,8],[4,10,4,12],[4,23,4,29],[23,25,23,32],[7,14,7,19],[9,25,22,25],[9,50,22,50],[7,43,7,48],[9,45,22,45],[7,40,7,42],[7,33,8,33]]}
[" valoración cuantitativa de impactos ambientales"]
[]
["se reparten 1000 UIP entre todos los factores ambientales"]
["Fórmula de la importancia:                        I = +-(MO + PE + CR + EF+ II+ PR)",null,null,"Momento (MO).             Largo plazo=1;                  Medio plazo=2;                    Inmediato=4;                          Crítico (+4)",null,"Persistencia (PE) Fugaz=1;                     Temporal=2; Permanente=4",null,null,null,"Capacidad de recuperación (CR) Reversible=2;                                        Ireversible-Recuperable=4;                             Irreversible-Mitigable=8;                    Irreversible-Irrecuperable=12",null,null,null,null,null,null," ",null,null,null,null,null,null,"Valor global ponderado del impacto sobre el entorno generado por proyecto sin medidas correctoras (Vp)",null,null,null,null,null,null,{"$f":"SUM($AG25:$AG955)","v":0}]
[null,null,null,"Causa-efecto (EF). Indirecto=1                                 Directo=4",null,"Interrelación de impactos (II)               Simple=2;                                 Acumulativo=4;                                                         Sinérgico=8",null,null,null,null,"Periodicidad(PR). Irregular=1;                   Periodico=2;                         Continuo=4",null,null,null,null,null,null,null,null,null,null,null,null,"Valor global ponderado del impacto sobre el entorno generado por las medidas correctoras (VpCC)",null,null,null,null,null,null,{"$f":"SUM(AY25:AY955)","v":0}]
["máximo valor de la importancia (Imax)",null,null,null,40,"mínimo valor de la importancia (Imin)",null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"Valor global ponderado del impacto sobre el entorno generado por el proyecto y las medidas correctoras (Vpcon+CC)",null,null,null,null,null,null,{"$f":"$AE$4+$AE$5","v":0}]
[]
["Subfactor","Pj","Acción","Impacto","Signo","Atributos: impactos POSITIVOS ",null,null,null,null,null,"Importancia",null,null,"Atributos: impactos NEGATIVOS SIN medidas correctoras",null,null,null,null,null,"Importancia",null,null,"Valoración cuantitativa SIN medidas correctoras",null,null,null,null,null,null,null,null,null,"CC","Atributos: impactos NEGATIVOS con y medidas correctoras (con+CC)",null,null,null,null,null,"Importancia",null,null,"Valoración cuantitativa CON y medidas correctoras (con+CC)",null,null,null,null,null,"Efecto medidas correctiras",null,"Juicio global"]
[null,null,null,null,null,"MO","PE","CR","EF","II","PR","I+ij","Ist+ij","Ip+ij","MO","PE","CR","EF","II","PR","I-ij","Ist-ij","Ip-ij","Ind","Indj sin","Indj con","Caj sin","Caj con","Mj","Tj","Fcj","Vj","Vpj",null,"MO con+CC","PE con+CC","CR con+CC","EF con+CC","II con+CC","PR con+CC","I-ij   con+CC","Ist-ij con+CC","Ip-ij con+CC","Indj con+CC","CAj con+CC","Mj con+CC","Fcj con+CC","Vj con+CC","Vpj con+CC","IpjCC","VpjCC"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F10+$G10+$H10+$I10+$J10+$K10","v":0},{"$f":"IF($L10<>0,(($L10-$M$6)/($E$6-$M$6))*100,0)","v":0},{"$f":"($M10*$B10)/100","v":0},null,null,null,null,null,null,{"$f":"$O10+$P10+$Q10+$R10+$S10+$T10","v":0},{"$f":"IF($U10<>0,(($U10-$M$6)/($E$6-$M$6))*100,0)","v":0},{"$f":"($V10*$B10)/100","v":0},null,null,null,null,null,{"$f":"+AB10-AA10","v":0},null,{"$f":"(1/(1+$AD10))+(($AD10*(ABS(($M24-$V24))-50))/(50*(1+$AD10)))","v":1},{"$f":"$AE10*$AC10","v":0},{"$f":"$AF10*$B10","v":0},null,null,null,null,null,null,null,{"$f":"$AI10+$AJ10+$AK10+$AL10+$AM10+$AN10","v":0},{"$f":"IF($AO10<>0,(($AO10-$M$6)/($E$6-$M$6))*100,0)","v":0},{"$f":"($AP10*$B10)/100","v":0},null,null,{"$f":"+AS10-AA10","v":0},{"$f":"(1/(1+$AD10))+(($AD10*(ABS(($M24-$AP24))-50))/(50*(1+$AD10)))","v":1},{"$f":"$AT10*$AU10","v":0},{"$f":"$AV10*$B10","v":0},{"$f":"$AS24-$Y24","v":0},{"$f":"$AW10-$AG10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($L11<>0,(($L11-$M$6)/($E$6-$M$6))*100,0)","v":0},0,null,null,null,null,null,null,0,{"$f":"IF($U11<>0,(($U11-$M$6)/($E$6-$M$6))*100,0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,"Importancias globales positivos: I+j; Ist+j; Ip+j;",null,null,null,null,null,{"$f":"IF(SUM($L10:$L23),(1-EXP(-((SUM($L10:$L23)/COUNTIF($L10:$L23,\">0\"))^1)))*($E$6-(MAX($L10:$L23)))*(1-1/(EXP((((COUNTIF($L10:$L23,\">0\")^1)-1)*0.1))))+(MAX($L10:$L23)),0)","v":0},0,{"$f":"IF(SUM($L10:$L23),(($M24*$B24)/100),0)","v":0},"Importancias globales negativos: I+j; Ist+j; Ip+j;",null,null,null,null,null,{"$f":"IF(SUM($U10:$U23),(1-EXP(-((SUM($U10:$U23)/COUNTIF($U10:$U23,\">0\"))^1)))*($E$6-(MAX($U10:$U23)))*(1-1/(EXP((((COUNTIF($U10:$U23,\">0\")^1)-1)*0.1))))+(MAX($U10:$U23)),0)","v":0},{"$f":"IF($U24<>0,(($U24-$M$6)/($E$6-$M$6))*100,0)","v":0},{"$f":"IF(SUM($U10:$U23),(($V24*$B24)/100),0)","v":0},"Ipj",{"$f":"$N24-$W24","v":0}," ",null,null,null,null,null,null,null,"Importancias globales negativos+CC: I+j; Ist+j; Ip+j;",null,null,null,null,null,null,{"$f":"IF(SUM($AO10:$AO23),(1-EXP(-((SUM($AO10:$AO23)/COUNTIF($AO10:$AO23,\">0\"))^1)))*($E$6-(MAX($AO10:$AO23)))*(1-1/(EXP((((COUNTIF($AO10:$AO23,\">0\")^1)-1)*0.1))))+(MAX($AO10:$AO23)),0)","v":0},0,{"$f":"IF(SUM($AO10:$AO23),(($AP24*$B24)/100),0)","v":0},"Ipj con+CC",{"$f":"$N24-$AQ24","v":0}]

{"sheet":"Comentarios Cualitativa","index":3,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,2,1,2]]}
["ACCIÓN","IMPACTO","MEDIDA CORRECTORA","ENJUICIAMIENTO"]
["Nombre","Descripción del impacto: Efecto-subfactor-acción",null,"Juico","Comentarios"]

{"sheet":"Comentarios Cuantitativa","index":4,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,5,0,6],[0,3,1,3],[0,4,1,4]]}
["ACCION","IMPACTO","INDICADOR","MEDIDA CORRECTORA","Comentarios acerca de la valoración","ENJUICIAMIENTO"]
["Nombre","Descripción del impacto: Efecto-subfactor-acción","Nombre",null,null,"Juico","Comentarios"]