{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cuantitativa","Comentarios Cuantitativa"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Cuantitativa","index":0,"n_rows":24,"n_cols":35,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,1,12],[2,0,2,12],[7,3,8,3],[5,0,5,3],[7,1,8,1],[7,11,7,13],[7,4,8,4],[7,2,8,2],[7,0,8,0],[3,0,4,2],[3,3,3,4],[7,5,7,10],[3,5,3,10],[3,11,3,12],[4,9,4,12],[4,5,4,8],[9,0,23,0],[9,23,22,23],[9,24,22,24],[9,26,22,26],[9,27,22,27],[23,2,23,4],[23,5,23,10],[23,14,23,19],[23,25,23,33],[9,25,22,25],[9,31,22,31],[9,33,22,33],[9,32,22,32],[3,23,5,29],[3,30,5,30],[4,3,4,4],[7,34,8,34],[9,28,22,28],[9,29,22,29],[9,34,23,34],[9,30,22,30],[7,23,7,33],[5,7,5,11],[7,14,7,19],[7,20,7,22]]}
[" 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,"Persistencia (PE)  Temporal=1                                                                    Permanente=4",null,"Capacidad de recuperación (CR)                                            Reversible=2                                                    Ireversible-Recuperable=4                             Irreversible-Mitigable=8                    Irreversible-Irrecuperable=12",null,null,null,null,null,"Causa-efecto (EF). Indirecto=1                                 Directo=4",null,null,null,null," ",null,null,null,null,null,null,"Valor global ponderado del impacto generado por el proyecto sin medidas correctoras (Vp) en esta fase",null,null,null,null,null,null,{"$f":"SUM($AH25:$AH955)","v":0}]
[null,null,null,"Momento (MO) Largo=1             Medio=2               Corto=3     Inmediato=4               Crítico (+4)",null,"Interrelación de impactos (II)                                      Simple=2                                               Acumulativo=4                                                         Sinérgico=8",null,null,null,"Periodicidad(PR).                         Irregular=1                               Periodico=2                                          Continuo=4"]
["máximo valor de la importancia (Imax)",null,null,null,40,null,null,"mínimo valor de la importancia (Imin)",null,null,null,null,8]
[]
["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,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","Vstj","Vpj"]
[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)),0)","v":0},{"$f":"($M10*$B10)","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)),0)","v":0},{"$f":"($V10*$B10)","v":0},null,null,null,null,null,{"$f":"+AB10-AA10","v":0},null,{"$f":"(1+($AD10*(ABS(($M24-$V24)*2)-1)))","v":1},{"$f":"$AE10*$AC10","v":0},{"$f":"+$AF10/(1+$AD10)","v":0},{"$f":"$AG10*$B10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$F11+$G11+$H11+$I11+$J11+$K11","v":0},0,0,null,null,null,null,null,null,{"$f":"+$O11+$P11+$Q11+$R11+$S11+$T11","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$F12+$G12+$H12+$I12+$J12+$K12","v":0},0,0,null,null,null,null,null,null,{"$f":"+$O12+$P12+$Q12+$R12+$S12+$T12","v":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,0,0,0,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,{"$f":"+$O15+$P15+$Q15+$R15+$S15+$T15","v":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,0,0,0,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,0,0,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$F20+$G20+$H20+$I20+$J20+$K20","v":0},0,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$F21+$G21+$H21+$I21+$J21+$K21","v":0},0,0,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,0,0,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,"Importancias globales positivas: 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)),0)","v":0},"Importancias globales negativas: 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},0,{"$f":"IF(SUM($U10:$U23),(($V24*$B24)),0)","v":0},"Ipj",{"$f":"$N24-$W24","v":0}," "]

{"sheet":"Comentarios Cuantitativa","index":1,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
["Acción","IMPACTO","INDICADOR","ENJUICIAMIENTO"]
["Nombre","Descripción del impacto: Efecto-subfactor-acción","Nombre","Juico","Comentarios"]