{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["INICIO","VUD-Madera","VUD-Infraestructura","VUD-Suelo Productivo","VUD-Recreación","BIOMASA","VUI-Sumidero de carbono","VUI Soporte y Regulación ","Flujo E.Regulacion ","VUI-Salud","Población VUI salud","VNU-Coberturas","Flujo E.Conservación","VET"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":6,"comments":7,"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":"INICIO","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[15,0,16,16],[12,2,12,9],[13,2,13,9],[6,2,6,9],[7,2,7,9],[8,2,8,9],[10,2,10,9],[9,2,9,9],[11,2,11,9]]}
[]
[]
[]
[]
[]
[]
[null,null,"Recomendaciones "]
[null,null,"1.En cada hoja las celdas que se encuentran en verde requieren información. "]
[null,null,"2.Cada hoja cuenta con comentarios en las celdas que requieren información."]
[null,null,"3.Los datos de consulta que se requieren, se deben tomar del año o mes en el que ocurre el incendio forestal."]
[null,null,"4.Los porcentajes se deben ingresar en la  fracción correspondiente, es decir si es 100% ingresar el numero 1."]
[null,null,"5.Para determinar el VUI de sumidero de carbono es necesario primero completar la información de biomasa."]
[null,null,"6.Para el VUI de salud  en afectación indirecta, será necesario completar la información de población afectada."]
[null,null,"7.Para el VNU-existencia de las coberturas, será necesario, posterior a obtener la información requerida para el componente de conservación, completar los datos de la hoja de flujo económico y así obtener el valor final."]
[]
["CONTENIDO "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"VUD-Madera","index":1,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[9,2,9,6],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[61,0,61,1],[62,0,62,1],[31,5,37,5],[55,0,55,1],[63,0,63,1],[56,0,56,8],[57,0,57,2],[58,0,58,1],[59,0,59,1],[60,0,60,1],[40,5,46,5],[40,7,46,7],[31,7,37,7],[49,5,55,5],[49,7,55,7],[29,0,29,8],[15,0,17,0],[18,0,20,0],[21,0,23,0],[24,0,26,0],[27,0,27,5],[0,0,0,8],[1,0,1,8],[2,0,2,8],[49,0,49,1],[50,0,50,1],[39,0,39,2],[38,0,38,8],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[30,0,30,2],[4,5,4,6],[64,0,64,1],[48,0,48,2],[47,0,47,8],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[58,7,64,7],[58,5,64,5]]}
["SECRETARIA DISTRITAL DE AMBIENTE SDA"]
["METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
["VALOR DE USO DIRECTO DE LA MADERA "]
[]
[null,null,"Valor de uso directo de la madera ",{"$f":"G28","v":220376256},null,"Cobertura"]
[null,null,null,null,null,"A","Pastos arbolados"]
[null,null,"Precio actualizado madera dura",1036405,null,"B","Plantación de coníferas"]
[null,null,"Precio actualizado madera liviana ",980728.4,null,"C","Arbustal abierto mesófilo"]
[null,null,null,null,null,"D"]
[null,null,"Volumen comercial "]
[null,null,"Nombre científico","Densidad básica  Tn /m3","Volumen perdido  m3","Precio m3 mercado ","Costo "]
["Sp1",null,{"$f":"C32","v":"Eucalyptus globulus"},0.74,{"$f":"I32+I41+I50+I59","v":211.12129899999999},{"$f":"IF(D12>0.5,$D$7,$D$8)","v":1036405},{"$f":"E12*F12","v":218807169.890095}]
["Sp2",null,{"$f":"C33","v":"Pinus patula"},0.6,{"$f":"I33+I42+I51+I60","v":0.66250799999999999},1036405,{"$f":"E13*F13","v":686626.60373999993}]
["Sp3",null,"Urapán",0.45,{"$f":"I34+I43+I52+I61","v":0.89979999999999993},980728.4,882459.41431999998]
["Sp4",null,0,null,{"$f":"I35+I44+I53+I62","v":0},980728.4,0]
["A",1,0,null,{"$f":"I36","v":0},980728.4,0]
[null,2,0,null,{"$f":"I37","v":0},980728.4,0]
[null,3,0,null,{"$f":"I38","v":0},980728.4,0]
["B",1,{"$f":"C45","v":0},null,{"$f":"I45","v":0},980728.4,0]
[null,2,{"$f":"C46","v":0},null,{"$f":"I46","v":0},980728.4,0]
[null,3,{"$f":"C47","v":0},null,{"$f":"I47","v":0},980728.4,0]
["C",1,{"$f":"C54","v":0},null,{"$f":"I54","v":0},980728.4,0]
[null,2,{"$f":"C55","v":0},null,{"$f":"I55","v":0},980728.4,0]
[null,3,{"$f":"C56","v":0},null,{"$f":"I56","v":0},980728.4,0]
["D",1,{"$f":"C63","v":0},null,{"$f":"I63","v":0},980728.4,0]
[null,2,{"$f":"C64","v":0},null,{"$f":"I64","v":0},980728.4,0]
[null,3,{"$f":"C65","v":0},null,{"$f":"I65","v":0},980728.4,0]
["Total Valor de uso directo  de la madera ",null,null,null,null,null,{"$f":"ROUND(SUM(G12:G27),0)","v":220376256}]
[]
["Cobertura A (Resultado del inventario)"]
["Nombre científico",null,null,"Volumen área testigo m3/ha","Volumen residual A. Media m3/ha","Área afectación media (ha) ","Volumen residual A. Alta m3/ha","Área afectación alta (ha) ","Total"]
["Sp1",null,"Eucalyptus globulus",13.0693,null,null,null,7.17,{"$f":"((D32-E32)*$F$32)+((D32-G32)*$H$32)","v":93.706880999999996}]
["Sp2",null,"Pinus patula",9.2399999999999996E-2,null,null,null,null,0.66250799999999999]
["Sp3",null,"Urapán",0,null,null,null,null,0]
["Sp4",null,null,null,null,null,null,null,0]
[1,null,null,null,null,null,null,null,0]
[2,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,0]
["Cobertura B (Resultado del inventario)"]
["Nombre científico",null,null,"Volumen área testigo m3/ha","Volumen residual A.media m3/ha","Área afectación media (ha) ","Volumen residual A.alta m3/ha","Área afectación alta (ha) ","Total"]
["Sp1",null,{"$f":"C32","v":"Eucalyptus globulus"},175.24539999999999,null,null,null,0.67,{"$f":"((D41-E41)*$F$41)+((D41-G41)*$H$41)","v":117.414418}]
["Sp2",null,{"$f":"C33","v":"Pinus patula"},0,null,null,null,null,{"$f":"((D42-E42)*$F$41)+((D42-G42)*$H$41)","v":0}]
["Sp3",null,{"$f":"C34","v":"Urapán"},0,null,null,null,null,{"$f":"((D43-E43)*F41)+((D43-G43)*H41)","v":0}]
["Sp4",null,{"$f":"C35","v":0},null,null,null,null,null,{"$f":"((D44-E44)*F41)+((D44-G44)*H41)","v":0}]
[1,null,null,null,null,null,null,null,{"$f":"((D45-E45)*F41)+((D45-G45)*H41)","v":0}]
[2,null,null,null,null,null,null,null,{"$f":"((D46-E46)*F41)+((D46-G46)*H41)","v":0}]
[3,null,null,null,null,null,null,null,{"$f":"((D47-E47)*F41)+((D47-G47)*H41)","v":0}]
["Cobertura C (Resultado del inventario)"]
["Nombre científico",null,null,"Volumen área testigo m3/ha","Volumen residual A.media m3/ha","Área afectación media (ha) ","Volumen residual A.alta m3/ha","Área afectación alta (ha) ","Total"]
["Sp1",null,{"$f":"C32","v":"Eucalyptus globulus"},0,null,2.75,null,null,{"$f":"((D50-E50)*$F$50)+((D50-G50)*$H$50)","v":0}]
["Sp2",null,{"$f":"C33","v":"Pinus patula"},0,null,null,null,null,0]
["Sp3",null,{"$f":"C34","v":"Urapán"},0.32719999999999999,null,null,null,null,0.89979999999999993]
["Sp4",null,{"$f":"C35","v":0},null,null,null,null,null,0]
[1,null,null,null,null,null,null,null,0]
[2,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,0]
["Cobertura D (Resultado del inventario)"]
["Nombre científico",null,null,"Volumen área testigo m3/ha","Volumen residual A.media m3/ha","Área afectación media (ha) ","Volumen residual A.alta m3/ha","Área afectación alta (ha) ","Total"]
["Sp1",null,{"$f":"C32","v":"Eucalyptus globulus"},null,null,null,null,null,{"$f":"((D59-E59)*$F$59)+((D59-G59)*$H$59)","v":0}]
["Sp2",null,{"$f":"C33","v":"Pinus patula"},null,null,null,null,null,0]
["Sp3",null,{"$f":"C34","v":"Urapán"},null,null,null,null,null,0]
["Sp4",null,{"$f":"C35","v":0},null,null,null,null,null,0]
[1,null,null,null,null,null,null,null,0]
[2,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,0]

{"sheet":"VUD-Infraestructura","index":2,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,1],[47,0,47,3],[5,5,5,8],[5,0,5,4]]}
["SECRETARIA DISTRITAL DE AMBIENTE SDA"]
["METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
["INFRAESTRUCTURA"]
["Valor de uso directo de infraestructura ",null,{"$f":"ROUND(E48+I8+I27,0)","v":0}]
[]
["Perdida directa de uso ",null,null,null,null,"Perdida indirecta  de uso "]
["Tipo de estructura ","Cuantificación de la medida ","Unidad de medida ","Precio de mercado por unidad de medida ","Total ","Cantidad de Empleos ","Salario SMDLV","Días de suspensión ","Total"]
[null,null,null,null,{"$f":"B8*D8","v":0},null,null,null,{"$f":"F8*G8*H8","v":0}]
[null,null,null,null,0," Tipo de Infraestructura","Costo arriendo (días)","Días inhabilitados de uso ","Total "]
[null,null,null,null,0,null,null,null,{"$f":"G10*H10","v":0}]
[null,null,null,null,0,null,null,null,{"$f":"G11*H11","v":0}]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0," Servicio ","Costo de reconexion ","Costo de rehabilitatación de la infraestructura ","Total "]
[null,null,null,null,0,"Agua",null,null,{"$f":"G18+H18","v":0}]
[null,null,null,null,0,"Gas",null,null,{"$f":"G19+H19","v":0}]
[null,null,null,null,0,"Luz",null,null,0]
[null,null,null,null,0,"Electricidad",null,null,0]
[null,null,null,null,0,"Internet ",null,null,0]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0]
[null,null,null,null,0,"Total ",null,null,{"$f":"ROUND(SUM(I10:I16,I18:I26),0)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["Total ",null,null,null,{"$f":"ROUND(SUM(E8:E47),0)","v":0}]
["Fuente:","Precios IDU"]

{"sheet":"VUD-Suelo Productivo","index":3,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,1,13],[2,1,2,13],[31,1,31,9],[19,2,19,9],[7,0,11,0],[12,0,16,0],[21,0,25,0],[26,0,30,0]]}
[null,"SECRETARIA DISTRITAL DE AMBIENTE SDA"]
[null,"METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
[null,"SUELO PRODUCTIVO "]
[]
[null,"valor de uso directo de suelo productivo ",{"$f":"K32","v":0}]
[null,"SMLV"]
[null,"Producción  ","Rendimiento (t-lt)/ha/año","Área afectada  (ha) ","Precio de mercado (tn)","Perdida de  producción","Empleos generados por ha ","SMLV","Perdida de empleo ","Tiempo de recuperación del suelo  (años)","Tiempo de recuperación de la porductividad (años)","Perdida de empleo","Costos de establecimiento (ha) ","Costos de producción (ha)"]
["Cultivos transitorios",null,null,null,null,{"$f":"C8*D8*E8","v":0},null,{"$f":"$C$6*12","v":0},{"$f":"G8*H8","v":0},null,null,{"$f":"G8*H8*J8","v":0}]
[null,null,null,null,null,{"$f":"C9*D9*E9","v":0},null,0,{"$f":"G9*H9","v":0},null,null,0]
[null,null,null,null,null,0,null,0,0,null,null,0]
[null,null,null,null,null,null,null,0,0,null,null,0]
[null,null,null,null,null,0,null,0,0,null,null,0]
["Cultivos permanentes ",null,null,null,null,0,null,0,0,null,null,0]
[null,null,null,null,null,0,null,0,0,null,null,0]
[null,null,null,null,null,0,null,0,0,null,null,0]
[null,null,null,null,null,0,null,0,0,null,null,0]
[null,null,null,null,null,0,null,0,0,null,null,0]
[]
[]
[null,null,"Tiempo (años ) "]
[null,"Producción  ",0,1,2,3,4,5,6,7,"VPN "]
["Cultivos transitorios",{"$f":"B8","v":0},{"$f":"N8","v":0},{"$f":"F8","v":0},null,null,null,null,null,null,{"$f":"NPV(8.5%,D22:J22)+C22","v":0}]
[null,{"$f":"B9","v":0},{"$f":"N9","v":0},{"$f":"F9","v":0},null,null,null,null,null,null,0]
[null,{"$f":"B10","v":0},{"$f":"N10","v":0},{"$f":"F10","v":0},null,null,null,null,null,null,0]
[null,{"$f":"B11","v":0},{"$f":"N11","v":0},{"$f":"F11","v":0},null,null,null,null,null,null,0]
[null,0,0,0,null,null,null,null,null,null,0]
["Cultivos permanentes ",0,{"$f":"M13","v":0},{"$f":"F13+I13","v":0},null,null,null,null,null,null,0]
[null,0,{"$f":"M14","v":0},{"$f":"F14+I14","v":0},null,null,null,null,null,null,0]
[null,0,0,0,null,null,null,null,null,null,0]
[null,0,0,0,null,null,null,null,null,null,0]
[null,0,0,0,null,null,null,null,null,null,0]
[null,"Total valor presente neto perdida de suelo productivo",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K22:K31),0)","v":0}]

{"sheet":"VUD-Recreación","index":4,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,0,12,1],[11,0,11,2],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[24,0,25,3],[0,0,0,3],[1,0,1,3],[2,0,2,3],[27,3,28,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[23,0,23,2],[27,2,28,2]]}
["SECRETARIA DISTRITAL DE AMBIENTE SDA"]
["METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
["RECREACIÓN "]
[]
["Valor de uso directo de recreación ",{"$f":"C22","v":0}]
["SMLV MENSUAL ",null,1300000]
["SMMLV DIARIO ",null,{"$f":"C6/30","v":43333.333333333336}]
["RECARGO DOMINICAL FESTIVO ",null,{"$f":"0.25","v":0.25}]
["TRANSPORTE ",null,{"$f":"0.538","v":0.53800000000000003}]
["DISFRUTE (REFRIGERIO)",null,{"$f":"0.22","v":0.22}]
[]
["ESTIMACIÓN DEL VALOR DE USO DIRECTO DE LA RECREACIÓN "]
["Día SMLV ",null,{"$f":"C7/8","v":5416.666666666667}]
["Horas de Disfrute",null,0]
["SMMLV 1 día + Recargo dominical y/o festivo ",null,{"$f":"C8*C7","v":10833.333333333334}]
["Horas de Desplazamiento ",null,2.8]
["Población adulta que visita el lugar",null,0]
["Tiempo de cierre (días)",null,0]
["Costos de Transporte",null,{"$f":"C9*C7","v":23313.333333333336}]
["Costo de Disfrute ",null,{"$f":"C10*C7","v":9533.3333333333339}]
["Población Total ",null,0]
["VALOR ECONÓMICO TOTAL DE USO DIRECTO DE RECREACIÓN",null,{"$f":" ROUND((((C13*C14)+(C15*C16))*C17*C18)+((C19+C20)*C21*C18),0)","v":0}]
[]
[]
["En caso de no encontrar discriminado entre la población adulta y niños, tomar una relación 1:1, es decir por cada adulto, 1 niño; resultando la mitad de la población encontrada como referente de adultos y la otra mitad como niños."]

{"sheet":"BIOMASA","index":5,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[25,11,25,12],[0,0,0,12],[1,0,1,12],[2,0,2,12],[17,11,18,12],[9,11,10,12],[7,0,32,0],[8,1,18,1],[8,2,18,2],[19,2,25,2],[19,1,25,1],[51,0,51,1],[33,0,33,1],[50,0,50,1],[44,1,49,1],[44,2,49,2],[34,1,43,1],[34,2,43,2],[34,0,49,0]]}
["SECRETARIA DISTRITAL DE AMBIENTE SDA"]
["METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
["BIOMASA"]
[]
[]
[]
[]
["Cobertura área testigo ","Tipo","Area total afectacion alta y media (ha)","Especies","Volumen total  perdido para afectacion alta y media (m3)","Volumen ponderado para el area afectada (m3/ha)","Densidad (t/m3)","Biomasa (t/ha)","Dm"]
[null,"Arbustal abierto mesófilo",2.75,"Ageratina aristei",1.0302460408366026E-2,{"$f":"E9/$C$34","v":3.0124153240836333E-3},0.45,{"$f":"F9*G9","v":1.355586895837635E-3},{"$f":"(E9/$E$52)*G9","v":2.6181225049939329E-5}]
[null,null,null,"Cavendishia bracteata",7.9567004937731056E-2,2.3265206122143584E-2,0.45,{"$f":"F10*G10","v":1.0469342754964613E-2},2.0220040458808817E-4,null,null,"Biomasa coberturas diferentes a pastos y herbazales"]
[null,null,null,"Clusia multiflora",0.39099364568677536,0.11432562739379397,0.45,5.1446532327207285E-2,9.9361630378206407E-4]
[null,null,null,"Diplostephium rosmarinifolium",3.3929200658769765E-5,9.92081890607303E-6,0.45,4.4643685077328633E-6,8.6222902394311352E-8,null,null,"Volumen total m3/ha",{"$f":"E52","v":177.07754984427115}]
[null,null,null,"Dodonaea viscosa",0.18045083802744513,5.2763402932001505E-2,0.45,2.3743531319400678E-2,4.5857240053164987E-4,null,null,"Dm Tn/m3",{"$f":"I52","v":0.73699946596537436}]
[null,null,null,"Fraxinus uhdei",0.32717443492385129,9.5665039451418507E-2,0.45,4.3049267753138332E-2,8.3143513023085946E-4,null,null,"Factor de Expansión de Biomasa",{"$f":"IF(H52>190,1.74,(3.212-0.506*LN(H52)))","v":1.369259770916508}]
[null,null,null,"Hemionitis sp",2.0781635403496485E-4,6.076501579969733E-5,0.45,2.7344257109863799E-5,5.2811527716515714E-7,null,null,"Biomasa total Tn",{"$f":"M12*M13*M14","v":178.69669736652872}]
[null,null,null,"Miconia squamulosa",0.21165358506184948,6.1887013175979382E-2,0.45,2.7849155929190721E-2,5.3786667684070416E-4]
[null,null,null,"Monnina aestuans",4.2815419878923747E-2,1.2519128619568347E-2,0.45,5.6336078788057561E-3,1.0880509111663098E-4]
[null,null,null,"Paspalum quadrifarium",0.3083316109865703,9.0155441808938683E-2,0.45,{"$f":"F18*G18","v":4.0569948814022407E-2},7.8355062550830459E-4,null,null,"Biomasa Herbazal abierto  y denso "]
[null,null,null,"Xylosma spiculifera",0.21204628414354817,{"$f":"E19/$C$34","v":6.2001837468873736E-2},0.45,{"$f":"F19*G19","v":2.7900826860993183E-2},{"$f":"(E19/$E$52)*G19","v":5.3886462709989752E-4}]
[null,"Plantación de coníferas",0.67,"Cavendishia bracteata",3.5342917352885171E-4,1.033418636049274E-4,0.45,4.6503838622217329E-5,8.9815523327407652E-7,null,null,"Área ha",0]
[null,null,null,"Eucalyptus globulus",175.2453870336648,51.241341237913687,0.74,37.91859251605613,0.73234346487716229,null,null,"Área de borde ha",0]
[null,null,null,"Hemionitis sp",8.9064151729270644E-6,2.6042149628441711E-6,0.45,1.1718967332798771E-6,2.2633511878506732E-8,null,null,"Biomasa IDEAM (tan/ha)",28.2]
[null,null,null,"Miconia squamulosa",3.3222342311712061E-2,9.7141351788631765E-3,0.45,4.3713608304884292E-3,8.4426591927763201E-5,null,null,"Biomasa total Tn",{"$f":"M20*M22","v":0}]
[null,null,null,"Paspalum quadrifarium",6.1072561185785573E-4,1.7857474030931453E-4,0.45,8.0358633139191539E-5,1.5520122430976044E-6]
[null,null,null,"Stelis s.p.",1.5833626974092557E-2,4.6297154895007476E-3,0.45,2.0833719702753363E-3,4.0237354450678634E-5]
[null,null,null,"Xylosma spiculifera",1.855675051024518E-2,5.4259504415921584E-3,0.45,2.4416776987164711E-3,4.7157517917737834E-5,null,null,"Biomasa Pastizales"]
[null,null,null,null,null,null,null,null,null,null,null,"Área ha",7.15]
[null,null,null,null,null,null,null,null,null,null,null,"Área de borde ha",2]
[null,null,null,null,null,null,null,null,null,null,null,"Biomasa IDEAM (tan/ha)",12.7]
[null,null,null,null,null,null,null,null,null,null,null,"Biomasa total Tn",{"$f":"SUM(M27:M28)*M29","v":116.205}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"BIOMASA TOTAL PERDIDA  Tn",{"$f":"M15+M23+M30","v":294.90169736652871}]
["Total",null,{"$f":"SUM(C9:C33)","v":3.42},null,{"$f":"SUM(E9:E33)","v":177.07754984427115},{"$f":"SUM(F9:F33)","v":51.777061357974027},"-",{"$f":"SUM(H9:H33)","v":38.159666570083289},{"$f":"SUM(I9:I33)","v":0.73699946596537436}]
["C.Borde","Arbustal abierto mesófilo",1.42,null,null,{"$f":"E35/$C$51","v":0},0.4,{"$f":"F35*G35","v":0},{"$f":"(E35/$E$52)*G35","v":0}]
[null,null,null,null,null,0,0.4,{"$f":"F36*G36","v":0},0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,{"$f":"F39*G39","v":0},0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,{"$f":"F43*G43","v":0},0]
[null,null,null,null,null,0,0.4,0,0]
[null,"Plantación de coníferas",1.99,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,0,0]
[null,null,null,null,null,0,0.4,0,0]
["Total",null,{"$f":"SUM(C35:C50)","v":3.41},{"$f":"SUM(D35:D50)","v":0},{"$f":"SUM(E35:E50)","v":0},{"$f":"SUM(F35:F50)","v":0},"-",{"$f":"SUM(H35:H50)","v":0},{"$f":"SUM(I35:I50)","v":0}]
["Total",null,{"$f":"C34+C51","v":6.83},null,{"$f":"E34+E51","v":177.07754984427115},{"$f":"F34+F51","v":51.777061357974027},"-",{"$f":"H34+H51","v":38.159666570083289},{"$f":"I34+I51","v":0.73699946596537436}]

{"sheet":"VUI-Sumidero de carbono","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,1,6,2],[0,1,0,2],[1,1,1,2],[2,1,2,2]]}
[null,"SECRETARIA DISTRITAL DE AMBIENTE SDA"]
[null,"METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
[null,"SUMIDERO DE CARBONO"]
[]
[null,"Valor de uso indirecto de sumidero de carbono",{"$f":"C13","v":165741304}]
[]
[null,"Sumidero de carbono"]
[null,"Biomasa total",{"$f":"BIOMASA!M33","v":294.90169736652871}]
[null,"Carbono contenido (factor)",{"$f":"0.51","v":0.51}]
[null,"Carbono equivalente (factor)",{"$f":"3.67","v":3.67}]
[null,"Precio en el mercado  € ",64.91]
[null,"Tasa de cambio  € a $",4626]
[null,"Valor uso indirecto sumidero de carbono",{"$f":"ROUND(C8*C9*C10*C12*C11,0)","v":165741304}]
[null,"Fuente de precios","Sendeco2"]

{"sheet":"VUI Soporte y Regulación ","index":7,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[29,1,30,1],[31,0,31,6],[12,0,14,0],[12,1,16,1],[12,2,16,2],[15,0,16,0],[17,0,19,0],[17,1,21,1],[17,2,21,2],[20,0,21,0],[22,2,26,2],[25,0,26,0],[27,1,28,1],[27,2,28,2],[51,10,51,13],[0,0,0,15],[1,0,1,15],[2,0,2,15],[9,10,9,14],[10,0,11,0],[10,7,11,7],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[9,0,9,7],[10,1,10,2],[29,2,30,2],[22,0,24,0],[22,1,26,1]]}
["SECRETARIA DISTRITAL DE AMBIENTE SDA"]
["METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES "]
["SOPORTE Y  REGULACIÓN "]
[]
[]
["Valor de uso indirecto de soporte y regulación ",{"$f":"H32+O52","v":2034460808}]
[]
["SMMLV",1300000]
[]
["REGULACIÓN ",null,null,null,null,null,null,null,null,null,"SOPORTE"]
["Coberturas ","Rendimientos ",null,"Afectación ","Años recuperación ","Área (ha)","$/m3","Costo ",null,null,"Grupo agrologico-Grupo cobertura ","Área (ha) ","Recomendaciones","Costos tratamientos (Ha)","Costo total remediación "]
[null,"Estudio (lt/s/Km2)","m3 /año/ha",null,null,null,null,null,null,null,"1A",null,"3,4,5,6,7,8",12519304.9,{"$f":"L12*N12","v":0}]
["Eucalipto y latifoliadas\n",21,{"$f":"(B13*0.001*86400*365)/100","v":6622.56},"Alta",10,0.67,null,{"$f":"'Flujo E.Regulacion '!M25","v":145779088.91890931},null,null,"1B",null,"3,4,5,6,7,8",12519304.9,0]
[null,null,null,"Media ",7.5,null,null,{"$f":"'Flujo E.Regulacion '!M26","v":0},null,null,"1C",null,"3,4,5,6,7,8",12519304.9,0]
[null,null,null,"Baja",2,null,null,{"$f":"'Flujo E.Regulacion '!M27","v":0},null,null,"1D",null,"3,4,5,6,7,8",12519304.9,0]
["Eucalipto y latifoliadas Borde ",null,null,"Alta",10,null,null,{"$f":"'Flujo E.Regulacion '!M28","v":0},null,null,"1E",null,"3,4,5,6,7,8",12519304.9,0]
[null,null,null,"Media ",7.5,1.99,null,{"$f":"'Flujo E.Regulacion '!M29","v":372131651.17699218},null,null,"1F",null,"3,4,5,6,7",8924705,0]
["Pino y Ciprés\n",29,{"$f":"(B18*0.001*86400*365)/100","v":9145.44},"Alta",10,null,null,{"$f":"'Flujo E.Regulacion '!M30","v":0},null,null,"1G",null,"4,5,6,7",7588277,0]
[null,null,null,"Media ",7.5,null,null,{"$f":"'Flujo E.Regulacion '!M31","v":0},null,null,"1H",null,"4,5,6,7",7588277,0]
[null,null,null,"Baja",2,null,null,{"$f":"'Flujo E.Regulacion '!M32","v":0},null,null,"2A",null,"3,4,5,6,7,8",12519304.9,0]
["Pino y Ciprés Borde \n",null,null,"Alta",10,null,null,{"$f":"'Flujo E.Regulacion '!M33","v":0},null,null,"2B",null,"3,4,5,6,7,8",12519304.9,0]
[null,null,null,"Media ",7.5,null,null,{"$f":"'Flujo E.Regulacion '!M34","v":0},null,null,"2C",null,"3,4,5,6,7,8",12519304.9,0]
["\nBosques natural /arbustales\n",34,{"$f":"(B23*0.001*86400*365)/100","v":10722.240000000002},"Alta",10,null,null,{"$f":"'Flujo E.Regulacion '!M35","v":0},null,null,"2D",null,"3,4,5,6,7,8",12519304.9,0]
[null,null,null,"Media ",7.5,2.75,{"$f":"(0.355/100)*B8","v":4615},{"$f":"'Flujo E.Regulacion '!M36","v":832598925.24469543},null,null,"2E",null,"3,4,5,6,7,8",12519304.9,0]
[null,null,null,"Baja",2,null,null,{"$f":"'Flujo E.Regulacion '!M37","v":0},null,null,"2F",null,"3,4,5,6,7",8924705,0]
["Arbustales borde ",null,null,"Alta",10,null,null,{"$f":"'Flujo E.Regulacion '!M38","v":0},null,null,"2G",null,"4,5,6,7",7588277,0]
[null,null,null,"Media ",7.5,1.42,null,{"$f":"'Flujo E.Regulacion '!M39","v":429923807.53710026},null,null,"2H",null,"4,5,6,7",7588277,0]
["Páramo/herbazales ",39,{"$f":"(B28*0.001*86400*365)/100","v":12299.04},"Alta",5,null,null,{"$f":"'Flujo E.Regulacion '!M40","v":0},null,null,"3A",null,"3,4,5,6,7,8",12519304.9,0]
["Páramo/herbazales  borde",null,null,"Alta",5,null,null,{"$f":"'Flujo E.Regulacion '!M41","v":0},null,null,"3B",null,"3,4,5,6,7,8",12519304.9,0]
["Pastos",7.6,{"$f":"(B30*0.001*86400*365)/100","v":2396.7359999999999},"Alta",2,7.15,null,{"$f":"'Flujo E.Regulacion '!M42","v":151975740.31797236},null,null,"3C",null,"3,4,5,6,7,8",12519304.9,0]
["Pastos Borde ",null,null,"Alta",2,2,null,{"$f":"'Flujo E.Regulacion '!M43","v":42510696.041474655},null,null,"3D",null,"3,4,5,6,7,8",12519304.9,0]
["Costo total ",null,null,null,null,null,null,{"$f":"ROUND(SUM(H13:H30),0)","v":1932409213},null,null,"3E",null,"3,4,5,6,7,8",12519304.9,0]
[null,null,null,null,null,null,null,null,null,null,"3F",null,"3,4,5,6,7",8924705,0]
[null,null,null,null,null,null,null,null,null,null,"3G",null,6.7,5265924,0]
[null,null,null,null,null,null,null,null,null,null,"3H",null,6.7,5265924,0]
[null,null,null,null,null,null,null,null,null,null,"4A",null,"1,2,3,6,7,8",19223951.899999999,{"$f":"L36*N36","v":0}]
[null,null,null,null,null,null,null,null,null,null,"4B",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"4C",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"4D",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"4E",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"4F",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"4G",null,6.7,5265924,0]
[null,null,null,null,null,null,null,null,null,null,"4H",null,6.7,5265924,0]
[null,null,null,null,null,null,null,null,null,null,"5A",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"5B",2.68,"1,2,3,6,7,8",19223951.899999999,51520191.092]
[null,null,null,null,null,null,null,null,null,null,"5C",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"5D",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"5E",0.67,"1,2,3,6,7,8",19223951.899999999,12880047.773]
[null,null,null,null,null,null,null,null,null,null,"5F",null,"1,2,3,6,7,8",19223951.899999999,0]
[null,null,null,null,null,null,null,null,null,null,"5G",7.15,6.7,5265924,37651356.600000001]
[null,null,null,null,null,null,null,null,null,null,"5H",null,6.7,5265924,0]
[null,null,null,null,null,null,null,null,null,null,"Total costos remediación ",null,null,null,{"$f":"ROUND(SUM(O12:O51),0)","v":102051595}]

{"sheet":"Flujo E.Regulacion ","index":8,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,0,9,0],[7,1,9,1],[15,1,16,1],[15,2,16,2],[5,2,6,2],[12,1,14,1],[43,0,43,11],[29,0,31,0],[34,0,36,0],[22,2,22,11],[12,0,14,0],[2,6,20,6],[10,0,11,0],[10,1,11,1],[10,2,11,2],[2,0,4,0],[2,1,4,1],[2,2,4,2],[37,0,38,0],[7,2,9,2],[5,0,6,0],[5,1,6,1],[0,8,0,14],[0,0,1,0],[0,1,0,2],[0,3,1,3],[0,4,1,4],[0,6,1,6],[0,5,1,5],[24,0,26,0],[32,0,33,0],[27,0,28,0],[12,2,14,2],[15,0,16,0]]}
["Coberturas ","Rendimientos ",null,"Afectación ","Años recuperación ","Área (ha)","$/m3"]
[null,"Estudio (lt/s/Km2)","m3 /año/ha"]
["Eucalipto y latifoliadas\n",21,{"$f":"(B3*0.001*86400*365)/100","v":6622.56},"Alta",10,{"$f":"'VUI Soporte y Regulación '!F13","v":0.67},{"$f":"'VUI Soporte y Regulación '!G24","v":4615}]
[null,null,null,"Media ",7.5,{"$f":"'VUI Soporte y Regulación '!F14","v":0}]
[null,null,null,"Baja",2,{"$f":"'VUI Soporte y Regulación '!F15","v":0}]
["Eucalipto y latifoliadas Borde ",21,{"$f":"(B3*0.001*86400*365)/100","v":6622.56},"Alta",10,{"$f":"'VUI Soporte y Regulación '!F16","v":0}]
[null,null,null,"Media ",7.5,{"$f":"'VUI Soporte y Regulación '!F17","v":1.99}]
["Pino y Ciprés\n",29,{"$f":"(B8*0.001*86400*365)/100","v":9145.44},"Alta",10,{"$f":"'VUI Soporte y Regulación '!F18","v":0}]
[null,null,null,"Media ",7.5,{"$f":"'VUI Soporte y Regulación '!F19","v":0}]
[null,null,null,"Baja",2,{"$f":"'VUI Soporte y Regulación '!F20","v":0}]
["Pino y Ciprés Borde\n",29,{"$f":"(B8*0.001*86400*365)/100","v":9145.44},"Alta",10,{"$f":"'VUI Soporte y Regulación '!F21","v":0}]
[null,null,null,"Media ",7.5,{"$f":"'VUI Soporte y Regulación '!F22","v":0}]
["\nBosques natural /arbustales\n",34,{"$f":"(B13*0.001*86400*365)/100","v":10722.240000000002},"Alta",10,{"$f":"'VUI Soporte y Regulación '!F23","v":0}]
[null,null,null,"Media ",7.5,{"$f":"'VUI Soporte y Regulación '!F24","v":2.75}]
[null,null,null,"Baja",2,{"$f":"'VUI Soporte y Regulación '!F25","v":0}]
["Arbustales borde ",34,{"$f":"C13","v":10722.240000000002},"Alta",10,{"$f":"'VUI Soporte y Regulación '!F26","v":0}]
[null,null,null,"Media ",7.5,{"$f":"'VUI Soporte y Regulación '!F27","v":1.42}]
["Páramo/herbazales ",39,{"$f":"(B18*0.001*86400*365)/100","v":12299.04},"Alta",5,{"$f":"'VUI Soporte y Regulación '!F28","v":0}]
["Páramo/herbazales  borde",39,{"$f":"(B19*0.001*86400*365)/100","v":12299.04},"Alta",5,{"$f":"'VUI Soporte y Regulación '!F29","v":0}]
["Pastos",7.6,{"$f":"(B20*0.001*86400*365)/100","v":2396.7359999999999},"Alta",2,{"$f":"'VUI Soporte y Regulación '!F30","v":7.15}]
["Pastos Borde",7.6,{"$f":"(B21*0.001*86400*365)/100","v":2396.7359999999999},"Alta",2,{"$f":"'VUI Soporte y Regulación '!F31","v":2}]
[]
[null,null,"Horizonte de tiempo "]
["Cobertura","Nivel de afectación ",0,1,2,3,4,5,6,7,8,9,"VPN DEL VALOR REGULACIÓN"]
["Eucalipto y latifoliadas\n","Alta",{"$f":"ROUND(F3*$G$3*C3,0)","v":20477287},{"$f":"C25","v":20477287},20477287,20477287,20477287,20477287,20477287,20477287,20477287,20477287,{"$f":"NPV(8.5%,D25:L25)+C25","v":145779088.91890931}]
[null,"Media ",{"$f":"ROUND(F4*$G$3*C3,0)","v":0},0,0,0,0,0,0,0,null,null,{"$f":"NPV(8.5%,D26:J26)+C26","v":0}]
[null,"Baja",{"$f":"ROUND(F5*$G$3*C3,0)","v":0},{"$f":"C27","v":0},null,null,null,null,null,null,null,null,{"$f":"NPV(8.5%,D27)+C27","v":0}]
["Eucalipto y latifoliadas Borde\n","Alta",{"$f":"ROUND(F6*$G$3*C6,0)","v":0},{"$f":"C28","v":0},{"$f":"D28","v":0},0,0,0,0,{"$f":"I28","v":0},{"$f":"J28","v":0},{"$f":"K28","v":0},{"$f":"NPV(8.5%,D28:L28)+C28","v":0}]
[null,"Media ",{"$f":"ROUND(F7*$G$3*C6,0)","v":60820598},{"$f":"C29","v":60820598},60820598,60820598,60820598,60820598,60820598,60820598,null,null,{"$f":"NPV(8.5%,D29:J29)+C29","v":372131651.17699218}]
["Pino y Ciprés\n","Alta",{"$f":"ROUND(F8*$G$3*C8,0)","v":0},{"$f":"C30","v":0},0,0,0,0,0,0,0,0,{"$f":"NPV(8.5%,D30:L30)+C30","v":0}]
[null,"Media ",{"$f":"ROUND(F9*$G$3*C8,0)","v":0},0,0,0,0,0,0,0,null,null,{"$f":"NPV(8.5%,D31:J31)+C31","v":0}]
[null,"Baja",{"$f":"ROUND(F10*$G$3*C8,0)","v":0},{"$f":"C32","v":0},null,0,null,null,null,null,null,null,{"$f":"NPV(8.5%,D32)+C32","v":0}]
["Pino y Ciprés Borde","Alta",{"$f":"ROUND(F11*$G$3*C11,0)","v":0},{"$f":"C33","v":0},{"$f":"D33","v":0},0,0,0,0,0,0,0,{"$f":"NPV(8.5%,D33:L33)+C33","v":0}]
[null,"Media ",{"$f":"ROUND(F12*$G$3*C11,0)","v":0},{"$f":"C34","v":0},0,0,0,0,0,0,null,null,{"$f":"NPV(8.5%,D34:J34)+C34","v":0}]
["\nBosques natural /arbustales\n","Alta",{"$f":"ROUND(F13*$G$3*C13,0)","v":0},{"$f":"C35","v":0},0,0,0,0,0,0,0,0,{"$f":"NPV(8.5%,D35:L35)+C35","v":0}]
[null,"Media ",{"$f":"ROUND(F14*$G$3*C13,0)","v":136078628},{"$f":"C36","v":136078628},136078628,136078628,136078628,136078628,136078628,136078628,null,null,{"$f":"NPV(8.5%,D36:J36)+C36","v":832598925.24469543}]
[null,"Baja",{"$f":"ROUND(F15*$G$3*C13,0)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"NPV(8.5%,D37)+C37","v":0}]
["Arbustales borde ","Alta",{"$f":"ROUND(F16*$G$3*C16,0)","v":0},0,{"$f":"D38","v":0},0,0,0,0,0,0,0,{"$f":"NPV(8.5%,D38:L38)+C38","v":0}]
[null,"Media ",{"$f":"ROUND(F17*$G$3*C16,0)","v":70266055},70266055,{"$f":"D39","v":70266055},70266055,70266055,70266055,70266055,70266055,{"$f":"J39","v":70266055},{"$f":"K39","v":70266055},{"$f":"NPV(8.5%,D39:J39)+C39","v":429923807.53710026}]
["Páramo/herbazales ","Alta",{"$f":"ROUND(F18*$G$3*C19,0)","v":0},0,{"$f":"D40","v":0},0,0,0,{"$f":"H40","v":0},{"$f":"I40","v":0},0,0,{"$f":"NPV(8.5%,D40:G40)+C40","v":0}]
["Páramo/herbazales  borde","Alta",{"$f":"ROUND(F19*$G$3*C19,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"NPV(8.5%,D41:G41)+C41","v":0}]
["Pastos","Alta",{"$f":"ROUND(F20*$G$3*C20,0)","v":79085697},79085697,79085697,79085697,79085697,79085697,79085697,79085697,79085697,79085697,{"$f":"NPV(8.5%,D42)+C42","v":151975740.31797236}]
["Pastos borde ","Alta",{"$f":"ROUND(F21*$G$3*C21,0)","v":22121873},22121873,22121873,22121873,22121873,22121873,22121873,22121873,22121873,22121873,{"$f":"NPV(8.5%,D43)+C43","v":42510696.041474655}]
["Total VPN  por servicio ecosistémico de regulación ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25:M43)","v":1974919909.2371442}]

{"sheet":"VUI-Salud","index":9,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[30,15,30,16],[15,8,15,12],[16,8,16,10],[14,8,14,10],[17,8,17,12],[18,8,18,10],[19,8,19,10],[22,8,22,10],[23,8,23,10],[24,8,24,10],[25,8,25,10],[27,16,28,16],[21,1,21,3],[15,0,15,4],[8,0,8,6],[21,8,21,11],[13,8,13,10],[9,0,9,2],[19,1,19,4],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[12,8,12,10],[22,1,22,3],[23,1,23,3],[26,1,26,3],[24,1,24,3],[25,1,25,3],[0,0,0,12],[1,0,1,12],[2,0,2,12],[20,1,20,3],[4,0,4,1],[14,0,14,2],[6,0,6,1],[8,8,8,10],[9,8,9,10],[10,8,10,12],[11,8,11,10]]}
["SECRETARIA DISTRITAL DE AMBIENTE SDA"]
["METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
["VALOR DE USO INDIRECTO-SALUD"]
[]
["VALOR DE USO INDIRECTO SALUD",null,{"$f":"E27+L26","v":0}]
[]
["SMMLV"]
[]
["Costos de atención ",null,null,null,null,null,null,null,"Costos de atención  IRA",null,null,"SMMLV","Precio"]
["Tipo de atención ",null,null,"Cantidad de personas","SMDLV  $","Costo en SMDLV $","Costo",null,"Consulta de urgencias ",null,null,1.97,{"$f":"$E$22*L10","v":0}]
["Valoración inicial intrahospitalaria, por el médico general tratante, del paciente ingresado para tratamiento no quirúrgico u obstétrico",null,null,null,1.91,{"$f":" ROUND(D11*(($C$7/30)*E11),0)","v":0},{"$f":"D11*F11","v":0},null,"Exámenes"]
["Consulta de urgencias ",null,null,null,1.97,{"$f":" ROUND(D12*(($C$7/30)*E12),0)","v":0},{"$f":"D12*F12","v":0},null,"Gases arteriales ",null,null,1.86,{"$f":"$E$22*L12","v":0}]
["Sutura",null,null,null,0.56000000000000005,0,{"$f":"D13*F13","v":0},null,"Mecánica respiratoria, pletismógrafo inductiva tórax y abdomen, fuerza y resistencia de músculo respiratorio",null,null,5.08,{"$f":"$E$22*L13","v":0}]
["Materiales de sutura y curación, medicamentos y soluciones, oxígeno, agentes y gases anestésicos",null,null,null,2.31,0,{"$f":"D14*F14","v":0},null,"Gammagrafía Pulmonar, Perfusión y ventilación ",null,null,19.21,{"$f":"$E$22*L14","v":0}]
["cuidado intermedio quemaduras",null,null,null,26.64,{"$f":" ROUND(D15*(($C$7/30)*E15),0)","v":0},{"$f":"D15*F15","v":0},null,"Espirómetro simple más volumen respiratorio y capacidad pulmonar total",null,null,6.06,{"$f":"$E$22*L15","v":0}]
["Total costos de atención",null,null,null,null,null,{"$f":"ROUND(SUM(G11:G15),0)","v":0},null,"Hospitalización"]
[null,null,null,null,null,null,null,null,"Habitación unipersonal (5dias)",null,null,31.25,{"$f":"$E$22*L17","v":0}]
[null,null,null,null,null,null,null,null,"Terapia"]
[null,null,null,null,null,null,null,null,"Inhalo terapia, sesión (nebulizador ultrasónico o presión positiva intermitente) ",null,null,11.55,{"$f":"$E$22*L19","v":0}]
[null,"Costos directos de salud",null,null,null,null,null,null,"Total ",null,null,{"$f":"L10+L12+L13+L14+L15+L17+L19","v":76.98},{"$f":"ROUND(SUM(M10:M19),0)","v":0}]
[null,"Costos por servicio de Ambulancia (1.23 SMMLV).",null,null,{"$f":"(C7*1.23)*D12","v":0}]
[null,"SMDLV",null,null,{"$f":"C7/30","v":0},null,null,null,"Costos indirectos de salud $"]
[null,"Costos de atención ",null,null,{"$f":"G16","v":0},null,null,null,"Población potencialmente afectable en un rango dañino para grupos sensibles (Rango 38-55 µg/m3)"]
[null,"Tiempo de incapacidad (días)",null,null,null,null,null,null,"Población potencialmente afectable en un rango dañino para la salud (Rango 56-150 µg/m3)"]
[null,"Población incapacitada",null,null,null,null,null,null,"Costos de atención IRA",null,null,{"$f":"M20","v":0}]
[null,"Costo de oportunidad del tiempo   ",null,null,{"$f":"E22*E25*E24","v":0},null,null,null,"Total costos indirectos ",null,null,{"$f":"(L23+L24)*L25","v":0}]
[null,"Total costos directos ",null,null,{"$f":"ROUND((E21+E23)+(E24*E25*E26),0)","v":0}]

{"sheet":"Población VUI salud","index":10,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,4,7,5],[21,4,21,5],[24,4,24,5],[10,4,10,5],[11,4,11,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[13,4,13,5],[15,4,15,5],[8,4,8,5],[9,4,9,5],[20,4,20,5],[12,4,12,5],[14,4,14,5],[16,4,16,5],[25,7,25,9],[22,7,22,9],[23,7,23,9],[24,7,24,9],[29,1,29,4],[25,1,25,3],[27,1,27,3],[28,1,28,3],[24,1,24,3],[26,1,26,3],[23,1,23,3],[22,1,22,3],[22,4,22,5],[23,4,23,5],[0,1,0,5],[0,7,0,10],[2,4,2,5],[5,4,5,5],[6,4,6,5],[1,4,1,5],[3,4,3,5],[4,4,4,5]]}
[null,"Rango 38-55 µg/m3",null,null,null,null,null,"Rango 56-150 µg/m3"]
[null,"LOCALIDADES ","ÁREA AFECTADA (ha)","DENSIDAD POBLACIONAL  (INDIV/ha)","POBLACIÓN POTENCIALMENTE AFECTABLE ESTIMADA",null,null,"LOCALIDADES ","ÁREA AFECTADA (ha) ","DENSIDAD POBLACIONAL (INDIV/ha)","POBLACIÓN POTENCIALMENTE AFECTABLE ESTIMADA"]
[null,"USAQUÉN",null,null,{"$f":"ROUND(C3*D3,0)","v":0},null,null,"USAQUÉN",null,null,{"$f":"ROUND(I3*J3,0)","v":0}]
[null,"CHAPINERO",null,null,{"$f":"ROUND(C4*D4,0)","v":0},null,null,"CHAPINERO",null,null,{"$f":"ROUND(I4*J4,0)","v":0}]
[null,"SANTA FE",null,null,0,null,null,"SANTA FE",null,null,0]
[null,"SAN CRISTÓBAL",null,null,0,null,null,"SAN CRISTÓBAL",null,null,0]
[null,"USME",null,null,0,null,null,"USME",null,null,0]
[null,"TUNJUELITO",null,null,0,null,null,"TUNJUELITO",null,null,0]
[null,"BOSA",null,null,0,null,null,"BOSA",null,null,0]
[null,"KENNEDY",null,null,0,null,null,"KENNEDY",null,null,0]
[null,"FONTIBÓN",null,null,0,null,null,"FONTIBÓN",null,null,0]
[null,"ENGATIVÁ",null,null,0,null,null,"ENGATIVÁ",null,null,0]
[null,"SUBA",null,null,0,null,null,"SUBA",null,null,0]
[null,"BARRIOS UNIDOS",null,null,0,null,null,"BARRIOS UNIDOS",null,null,0]
[null,"TEUSAQUILLO",null,null,0,null,null,"TEUSAQUILLO",null,null,0]
[null,"LOS MÁRTIRES",null,null,0,null,null,"LOS MÁRTIRES",null,null,0]
[null,"ANTONIO NARIÑO",null,null,0,null,null,"ANTONIO NARIÑO",null,null,0]
[null,"PUENTE ARANDA",null,null,0,null,null,"PUENTE ARANDA",null,null,0]
[null,"LA CANDELARIA",null,null,0,null,null,"LA CANDELARIA",null,null,0]
[null,"RAFAEL URIBE URIBE",null,null,0,null,null,"RAFAEL URIBE URIBE",null,null,0]
[null,"CIUDAD BOLÍVAR",null,null,0,null,null,"CIUDAD BOLÍVAR",null,null,0]
[null,"SUMAPAZ",null,null,0,null,null,"SUMAPAZ",null,null,0]
[null,"Total población ",null,null,{"$f":"ROUND(SUM(E3:F22),0)","v":0},null,null,"Total de población potencialmente afectable ",null,null,{"$f":"ROUND(SUM(K3:K21),0)","v":0}]
[null,"Morbilidad por enfermedad respiratoria -Bogotá %",null,null,null,null,null,"Morbilidad por enfermedad respiratoria -Bogotá %",null,null,{"$f":"E24","v":0}]
[null,"Resultado morbilidad por enfermedad respiratoria ",null,null,{"$f":" ROUND(E23*E24,0)","v":0},null,null,"Resultado morbilidad por enfermedad respiratoria ",null,null,{"$f":"ROUND(K23*K24,0)","v":0}]
[null,"Población sensible ",null,null,"< 4 años",">60 años ",null,"Población estimada como afectada 24% (PM 2,5)",null,null,{"$f":"ROUND(K25*0.24,0)","v":0}]
[null,"Porcentaje de población sensible < 4 años  y   >60 años "]
[null,"Población atendida por enfermedad respiratoria 33% y 9% ",null,null,{"$f":"ROUND(E25*E27,0)","v":0},{"$f":"ROUND(E25*F27,0)","v":0}]
[null,"Población estimada como afectada 13% (PM 2,5)",null,null,{"$f":"ROUND(E28*0.13,0)","v":0},{"$f":"ROUND(F28*0.13,0)","v":0}]
[null,"TOTAL POBLACIÓN ESTIMADA COMO AFECTADA (PM2,5)",null,null,null,{"$f":"ROUND(SUM(E29:F29),0)","v":0}]

{"sheet":"VNU-Coberturas","index":11,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[25,6,27,6],[18,0,18,1],[10,3,15,3],[10,5,15,5],[13,6,15,6],[16,3,21,3],[16,5,21,5],[16,6,18,6],[19,6,21,6],[31,10,32,10],[40,3,40,8],[28,3,33,3],[28,5,33,5],[28,6,30,6],[34,3,39,3],[34,5,39,5],[34,6,36,6],[37,6,39,6],[0,0,0,24],[1,0,1,24],[2,0,2,24],[9,0,9,1],[34,12,34,20],[31,6,33,6],[9,12,9,24],[17,12,17,24],[30,11,30,23],[8,11,8,24],[10,6,12,6],[23,10,24,10],[8,3,8,9],[22,3,27,3],[22,5,27,5],[22,6,24,6]]}
["SECRETARIA DISTRITAL DE AMBIENTE SDA"]
["METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
["VALOR DE EXISTENCIA DE LA COBERTURA "]
[]
["Valor de existencia de las coberturas",{"$f":"ROUND(B33+J41+M36,0)","v":26844837245}]
["SMMLV",1300000]
[]
[]
[null,null,null,"VALOR ECONÓMICO DE COSTOS DE REPOSICIÓN ",null,null,null,null,null,null,null,"VALOR ECONÓMICO DE COSTOS INCURRIDOS POR CONSERVACIÓN "]
["VALOR ECONÓMICO DE COSTOS POR EXTINCIÓN ",null,null,"COBERTURA","Estados de desarrollo ","AFECTACIÓN","ÁREA ha","IVP/ha","SMMLV","IMPORTANCIA DEL ARBOLADO",null,null,"Predios"]
["Entidad","Costos ",null,"Plantaciones coníferas","Fustal ","ALTA",0.67,2800,{"$f":"B6","v":1300000},{"$f":"ROUND($G$11*H11*I11,0)","v":2438800000},null,"Nombre del predio (chip catastral)","AAA0004XORJ","AAA0005SERJ","AAA0155NFNX","AAA0176OEBR","AAA0155NFOM","AAA0011KBRJ","AAA0011KBYN","AAA0163PMHK","AAA0163PMJZ"]
["Cruz roja",0,null,null,"Latizal",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$11*H12*I12,0)","v":0},null,"Puntaje",90,90,90,90,90,90,90,90,90]
["Defensa civil",0,null,null,"Brinzal",null,null,null,{"$f":"0.4379*$B$6","v":569270},0,null,"Estado de conservación  ","Preservación","Preservación","Preservación","Preservación","Preservación","Preservación","Preservación","Preservación","Preservación"]
["UAECOB",7664123,null,null,"Fustal  Borde",null,1.99,2200,{"$f":"B6","v":1300000},{"$f":"ROUND($G$14*H14*I14,0)","v":5691400000}]
["IDIGER",0,null,null,"Latizal Borde",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$14*H15*I15,0)","v":0}]
["TOTAL",{"$f":"ROUND(SUM(B12:B15),0)","v":7664123},null,null,"Brinzal Borde ",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$14*H16*I16,0)","v":0}]
[null,null,null,"Arbustal abierto mesófilo","Fustal ","MEDIA",2.75,null,{"$f":"B6","v":1300000},{"$f":"ROUND($G$17*H17*I17,0)","v":0}]
[null,null,null,null,"Latizal",null,null,2800,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$17*H18*I18,0)","v":4383379000},null,null,"Predios"]
["OTRAS ENTIDADES",null,null,null,"Brinzal",null,null,2200,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$17*H19*I19,0)","v":3444083500},null,null,{"$f":"M11","v":"AAA0004XORJ"},"AAA0005SERJ",{"$f":"O11","v":"AAA0155NFNX"},"AAA0176OEBR","AAA0155NFOM","AAA0011KBRJ","AAA0011KBYN","AAA0163PMHK","AAA0163PMJZ"]
["Entidad ","Costos",null,null,"Fustal  Borde",null,1.42,null,{"$f":"B6","v":1300000},{"$f":"ROUND($G$20*H20*I20,0)","v":0},null,"Área del predio (ha)",9.01,6.69,1.8,18.489999999999998,2.58,10.54,5.41,2.13,3.02]
[null,null,null,null,"Latizal Borde",null,null,1800,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$20*H21*I21,0)","v":1455054120},null,"Área afectada ",0.02,0.42299999999999999,0.08,0.13300000000000001,2.25,3.4E-5,3.76,1.46,2.4620000000000002]
[null,null,null,null,"Brinzal Borde ",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$20*H22*I22,0)","v":0},null,"VpAv /ha",{"$f":"12.31*$B$6","v":16003000},{"$f":"12.31*$B$6","v":16003000},{"$f":"12.31*$B$6","v":16003000},16003000,16003000,16003000,16003000,16003000,16003000]
[null,null,null,"Pastos arbolados","Fustal ","ALTA",7.15,null,{"$f":"B6","v":1300000},{"$f":"ROUND($G$23*H23*I23,0)","v":0},null,"Valor avalúo ",{"$f":"M20*M22","v":144187030},{"$f":"N20*N22","v":107060070},{"$f":"O20*O22","v":28805400},295895470,41287740,168671620,86576230,34086390,48329060]
[null,null,null,null,"Latizal",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$23*H24*I24,0)","v":0},null,"Equivalencia en SMMLV",{"$f":"M23/$B$6","v":110.9131},82.353899999999996,{"$f":"O23/$B$6","v":22.158000000000001},227.61189999999999,31.759799999999998,129.7474,66.597099999999998,26.220300000000002,37.176200000000001]
[null,null,null,null,"Brinzal",null,null,1700,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$23*H25*I25,0)","v":6919476850},null,"Valor de cálculo impuesto ",{"$f":"IF(M24  <= 135,\"0,004\",\"0,0065\")","v":"0,004"},{"$f":"IF(N24  <= 135,\"0,004\",\"0,0065\")","v":"0,004"},{"$f":"IF(O24  <= 135,\"0,004\",\"0,0065\")","v":"0,004"},"0,0065","0,004","0,004","0,004","0,004","0,004"]
[null,null,null,null,"Fustal  Borde",null,2,null,{"$f":"B6","v":1300000},{"$f":"ROUND($G$26*H26*I26,0)","v":0},null,"Impuesto predio",{"$f":"M25*M23","v":576748.12},{"$f":"N25*N23","v":428240.28},{"$f":"O25*O23","v":115221.6},1923320.5549999999,165150.96,674686.48,346304.92,136345.56,193316.24]
[null,null,null,null,"Latizal Borde",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$26*H27*I27,0)","v":0},null,"Impuesto área afectada",{"$f":"(M26/M20)*M21","v":1280.24},{"$f":"(N26/N20)*N21","v":27077.076000000001},{"$f":"(O26/O20)*O21","v":5120.96},13834.593500000001,144026.99999999997,2.1764079999999999,240685.11999999997,93457.52,157597.54400000002]
[null,null,null,null,"Brinzal Borde ",null,null,2200,{"$f":"0.4379*$B$6","v":569270},2504788000,null,"Valor de calculo incentivo ",{"$f":"IF(M12 >74,\"0,002\",IF(M12>49,\"0,005\",IF(M12 >19,\"0,01\",IF(M12<=19,\"0,016\",\"NA\"))))","v":"0,002"},"0,002",{"$f":"IF(O12 >74,\"0,002\",IF(O12>49,\"0,005\",IF(O12 >19,\"0,01\",IF(O12<=19,\"0,016\",\"NA\"))))","v":"0,002"},"0,002","0,002","0,002","0,002","0,002","0,002"]
[null,null,null,null,"Fustal ",null,null,null,{"$f":"B6","v":1300000},{"$f":"ROUND($G$29*H29*I29,0)","v":0},null,"Valor a pagar con el incentivo ",{"$f":"M28*M27","v":2.5604800000000001},{"$f":"N28*N27","v":54.154152000000003},10.24192,27.669187000000001,288.05399999999997,4.3528159999999998E-3,481.37023999999997,186.91504,315.19508800000006]
["Total",{"$f":"ROUND(SUM(B20:B29),0)","v":0},null,null,"Latizal",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$29*H30*I30,0)","v":0},null,"Costo social",{"$f":"(M27-M29)/M21","v":63883.975999999995},{"$f":"(N27-N29)/N21","v":63883.97600000001},63883.975999999995,103811.46100000001,63883.975999999988,63883.976000000002,63883.975999999995,63883.976000000002,63883.976000000002]
[null,null,null,null,"Brinzal",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$29*H31*I31,0)","v":0},null,"TOTAL VALOR DE CONSERVACIÓN ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M30:Y30)","v":614883.26900000009}]
[null,null,null,null,"Fustal  Borde",null,null,null,{"$f":"B6","v":1300000},{"$f":"ROUND($G$32*H32*I32,0)","v":0}]
["TOTAL ENTIDADES ",{"$f":"ROUND(SUM(B16+B30),0)","v":7664123},null,null,"Latizal Borde",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$32*H33*I33,0)","v":0}]
[null,null,null,null,"Brinzal Borde ",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$32*H34*I34,0)","v":0}]
[null,null,null,null,"Fustal ",null,null,null,{"$f":"B12","v":0},{"$f":"ROUND($G$29*H35*I35,0)","v":0}]
[null,null,null,null,"Latizal",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$29*H36*I36,0)","v":0},null,"Total costos incurridos en  conservación ",{"$f":"ROUND(SUM(M30:O30),0)","v":191652}]
[null,null,null,null,"Brinzal",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$29*H37*I37,0)","v":0}]
[null,null,null,null,"Fustal  Borde",null,null,null,{"$f":"B12","v":0},{"$f":"ROUND($G$32*H38*I38,0)","v":0}]
[null,null,null,null,"Latizal Borde",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$32*H39*I39,0)","v":0}]
[null,null,null,null,"Brinzal Borde ",null,null,null,{"$f":"0.4379*$B$6","v":569270},{"$f":"ROUND($G$32*H40*I40,0)","v":0}]
[null,null,null,"l",null,null,null,null,null,{"$f":"ROUND(SUM(J11:J40),0)","v":26836981470}]

{"sheet":"Flujo E.Conservación","index":12,"n_rows":77,"n_cols":15,"rows_kept":77,"cut":false,"hidden":false,"merged":[[27,2,31,2],[67,2,71,2],[72,2,76,2],[2,1,4,1],[7,1,7,3],[32,2,36,2],[62,2,66,2],[37,2,41,2],[42,2,46,2],[47,2,51,2],[52,2,56,2],[57,2,61,2],[2,0,6,0],[0,2,0,14],[12,2,16,2],[17,2,21,2],[22,2,26,2]]}
[null,null,"Predios "]
[null,"Cobertura ","Afectación","Tiempo de recuperación ",{"$f":"'VNU-Coberturas'!M11","v":"AAA0004XORJ"},{"$f":"'VNU-Coberturas'!N11","v":"AAA0005SERJ"},{"$f":"'VNU-Coberturas'!O11","v":"AAA0155NFNX"},{"$f":"'VNU-Coberturas'!P11","v":"AAA0176OEBR"},{"$f":"'VNU-Coberturas'!Q11","v":"AAA0155NFOM"},{"$f":"'VNU-Coberturas'!R11","v":"AAA0011KBRJ"},{"$f":"'VNU-Coberturas'!S11","v":"AAA0011KBYN"},{"$f":"'VNU-Coberturas'!T11","v":"AAA0163PMHK"},{"$f":"'VNU-Coberturas'!U11","v":"AAA0163PMJZ"},{"$f":"'VNU-Coberturas'!V11","v":0},{"$f":"'VNU-Coberturas'!W11","v":0}]
["Área","Coberturas lignificadas","Alta",10,0.02,null,null,0.13300000000000001,null,3.4E-5,0.51400000000000001]
[null,null,"Media",7.5,null,0.42299999999999999,0.08,null,2.25]
[null,null,"Baja",2]
[null,"Herbazales","Alta",5]
[null,"Pastos","Alta",2,null,null,null,null,null,null,3.246,1.46,2.4620000000000002]
[null,"Costo social por hectárea",null,null,{"$f":"'VNU-Coberturas'!M30","v":63883.975999999995},{"$f":"'VNU-Coberturas'!N30","v":63883.97600000001},{"$f":"'VNU-Coberturas'!O30","v":63883.975999999995},{"$f":"'VNU-Coberturas'!P30","v":103811.46100000001},{"$f":"'VNU-Coberturas'!Q30","v":63883.975999999988},{"$f":"'VNU-Coberturas'!R30","v":63883.976000000002},{"$f":"'VNU-Coberturas'!S30","v":63883.975999999995},{"$f":"'VNU-Coberturas'!T30","v":63883.976000000002},{"$f":"'VNU-Coberturas'!U30","v":63883.976000000002},{"$f":"'VNU-Coberturas'!V30","v":0},{"$f":"'VNU-Coberturas'!W30","v":0}]
[]
[]
[]
[null,null,"Predio","Afectación",0,1,2,3,4,5,6,7,8,9,"VPN DEL VALOR DE EXISTENCIA"]
[null,null,{"$f":"E2","v":"AAA0004XORJ"},"Alta",{"$f":"ROUND(E3*$E$8,0)","v":1278},{"$f":"ROUND(E3*$E$8,0)","v":1278},{"$f":"E13","v":1278},{"$f":"F13","v":1278},1278,1278,1278,1278,1278,1278,{"$f":"NPV(8.5%,F13:N13)+E13","v":9098.1620582045889}]
[null,null,null,"Media",{"$f":"ROUND(E4*$E$8,0)","v":0},{"$f":"ROUND(E4*$E$8,0)","v":0},{"$f":"ROUND(E4*$E$8,0)","v":0},{"$f":"G14","v":0},{"$f":"H14","v":0},{"$f":"I14","v":0},{"$f":"J14","v":0},{"$f":"K14","v":0},0,0,{"$f":"NPV(8.5%,F14:N14)+E14","v":0}]
[null,null,null,"Baja",{"$f":"ROUND(E5*$E$8,0)","v":0},{"$f":"E15","v":0},0,0,0,0,0,0,0,0,{"$f":"NPV(8.5%,F15:N15)+E15","v":0}]
[null,null,null,"Herbazal",{"$f":"ROUND(E6*$E$8,0)","v":0},{"$f":"E16","v":0},{"$f":"F16","v":0},{"$f":"G16","v":0},0,0,0,0,0,0,{"$f":"NPV(8.5%,F16:N16)+E16","v":0}]
[null,null,null,"Pastos",{"$f":"ROUND(E7*$E$8,0)","v":0},{"$f":"E17","v":0},0,0,0,0,0,0,0,{"$f":"M17","v":0},0]
[null,null,{"$f":"F2","v":"AAA0005SERJ"},"Alta",{"$f":"ROUND(F3*F8,0)","v":0},{"$f":"E18","v":0},{"$f":"F18","v":0},0,0,0,0,0,0,{"$f":"M18","v":0},0]
[null,null,null,"Media",{"$f":"F4*$F$8","v":27022.921848000002},{"$f":"E19","v":27022.921848000002},{"$f":"F19","v":27022.921848000002},27022.921848000002,27022.921848000002,27022.921848000002,27022.921848000002,{"$f":"K19","v":27022.921848000002},0,0,165340.11268555853]
[null,null,null,"Baja",{"$f":"F5*$F$8","v":0},{"$f":"E20","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Herbazal",{"$f":"ROUND(F6*$F$8,0)","v":0},0,{"$f":"F21","v":0},{"$f":"G21","v":0},{"$f":"H21","v":0},0,0,0,0,0,0]
[null,null,null,"Pastos",{"$f":"ROUND(F7*$F$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"G2","v":"AAA0155NFNX"},"Alta",{"$f":"ROUND(G3*$G$8,0)","v":0},0,{"$f":"F23","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Media",{"$f":"ROUND(G4*$G$8,0)","v":5111},5111,{"$f":"F24","v":5111},5111,5111,5111,5111,5111,0,0,31271.722602359267]
[null,null,null,"Baja",{"$f":"ROUND(G5*$G$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Herbazal",{"$f":"ROUND(G6*$G$8,0)","v":0},0,{"$f":"F26","v":0},{"$f":"G26","v":0},{"$f":"H26","v":0},0,0,0,0,0,0]
[null,null,null,"Pastos",{"$f":"ROUND(G7*$G$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"H2","v":"AAA0176OEBR"},"Alta",{"$f":"ROUND(H3*$H$8,0)","v":13807},13807,{"$f":"F28","v":13807},13807,13807,13807,13807,13807,13807,13807,98292.897916768998]
[null,null,null,"Media",{"$f":"ROUND(H4*$H$8,0)","v":0},0,{"$f":"F29","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Baja",{"$f":"ROUND(H5*$H$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Herbazal",{"$f":"ROUND(H6*$H$8,0)","v":0},0,{"$f":"ROUND(J6*$H$8,0)","v":0},{"$f":"G31","v":0},{"$f":"ROUND(L6*$H$8,0)","v":0},0,0,0,0,0,0]
[null,null,null,"Pastos",{"$f":"ROUND(H7*$H$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"I2","v":"AAA0155NFOM"},"Alta",{"$f":"ROUND(I3*$I$8,0)","v":0},0,{"$f":"F33","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Media",{"$f":"ROUND(I4*$I$8,0)","v":143739},143739,{"$f":"F34","v":143739},143739,143739,143739,143739,143739,null,null,879469.014897382]
[null,null,null,"Baja",{"$f":"ROUND(I5*$I$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Herbazal",{"$f":"ROUND(I6*$I$8,0)","v":0},0,{"$f":"F36","v":0},{"$f":"G36","v":0},{"$f":"H36","v":0},0,0,0,0,0,0]
[null,null,null,"Pastos",{"$f":"ROUND(I7*$I$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"J2","v":"AAA0011KBRJ"},"Alta",{"$f":"ROUND(J3*$J$8,0)","v":2},2,{"$f":"F38","v":2},2,2,2,2,2,2,2,14.238125286705149]
[null,null,null,"Media",{"$f":"ROUND(J4*$J$8,0)","v":0},0,{"$f":"F39","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Baja",{"$f":"ROUND(J5*$J$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Herbazal",{"$f":"ROUND(J6*$J$8,0)","v":0},0,{"$f":"F41","v":0},{"$f":"G41","v":0},{"$f":"H41","v":0},0,0,0,0,0,0]
[null,null,null,"Pastos",{"$f":"ROUND(J7*$J$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"K2","v":"AAA0011KBYN"},"Alta",{"$f":"ROUND(K3*$K$8,0)","v":32836},32836,{"$f":"F43","v":32836},32836,32836,32836,32836,32836,32836,32836,233761.54095712511]
[null,null,null,"Media",{"$f":"ROUND(K4*$K$8,0)","v":0},0,{"$f":"F44","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Baja",{"$f":"ROUND(K5*$K$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Herbazal",{"$f":"ROUND(K6*$K$8,0)","v":0},0,{"$f":"F46","v":0},{"$f":"G46","v":0},{"$f":"H46","v":0},0,0,0,0,0,0]
[null,null,null,"Pastos",{"$f":"ROUND(K7*$K$8,0)","v":207367},207367,0,0,0,0,0,0,0,0,398488.65898617508]
[null,null,{"$f":"L2","v":"AAA0163PMHK"},"Alta",{"$f":"ROUND(L3*$L$8,0)","v":0},0,{"$f":"F48","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Media",{"$f":"ROUND(L4*$L$8,0)","v":0},{"$f":"E49","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Baja",{"$f":"ROUND(L5*$L$8,0)","v":0},{"$f":"E50","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Herbazal",{"$f":"ROUND(L6*$L$8,0)","v":0},{"$f":"E51","v":0},{"$f":"F51","v":0},{"$f":"G51","v":0},{"$f":"H51","v":0},0,0,0,0,0,0]
[null,null,null,"Pastos",{"$f":"ROUND(L7*$L$8,0)","v":93271},{"$f":"E52","v":93271},0,0,0,0,0,0,0,0,179235.05529953918]
[null,null,{"$f":"M2","v":"AAA0163PMJZ"},"Alta",{"$f":"ROUND(M3*$M$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Media",{"$f":"ROUND(M4*$M$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Baja",{"$f":"ROUND(M5*$M$8,0)","v":0},0,0,0,0,null,null,null,null,null,0]
[null,null,null,"Herbazal",{"$f":"ROUND(M6*$M$8,0)","v":0},0,0,0,0,null,null,null,null,null,0]
[null,null,null,"Pastos",{"$f":"ROUND(M7*$M$8,0)","v":157282},157282,null,null,null,null,null,null,null,null,302242.36866359448]
[null,null,{"$f":"N2","v":0},"Alta",{"$f":"ROUND(N3*$N$8,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Media",{"$f":"ROUND(N4*$N$8,0)","v":0},{"$f":"E59","v":0},0,0,0,0,0,0,null,null,0]
[null,null,null,"Baja",{"$f":"ROUND(N5*$N$8,0)","v":0},{"$f":"E60","v":0},null,null,null,null,null,null,null,null,0]
[null,null,null,"Herbazal",{"$f":"ROUND(N6*$N$8,0)","v":0},0,{"$f":"F61","v":0},{"$f":"G61","v":0},{"$f":"H61","v":0},null,null,null,null,null,0]
[null,null,null,"Pastos",{"$f":"ROUND(N7*$N$8,0)","v":0},0,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"O2","v":0},"Alta",{"$f":"ROUND(O3*$O$8,0)","v":0},0,{"$f":"F63","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Media",{"$f":"ROUND(O4*$O$8,0)","v":0},0,{"$f":"F64","v":0},0,0,0,0,0,null,null,0]
[null,null,null,"Baja",{"$f":"ROUND(O5*$O$8,0)","v":0},0,null,null,null,null,null,null,null,null,0]
[null,null,null,"Herbazal",{"$f":"ROUND(O6*$O$8,0)","v":0},0,{"$f":"F66","v":0},{"$f":"G66","v":0},{"$f":"H66","v":0},null,null,null,null,null,0]
[null,null,null,"Pastos",{"$f":"ROUND(O7*$O$8,0)","v":0},0,null,null,null,null,null,null,null,null,0]
[null,null,0,"Alta",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E68","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"Media",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E69","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"}]
[null,null,null,"Baja",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,"Herbazal",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E71","v":{"$error":"#REF!"}},{"$f":"F71","v":{"$error":"#REF!"}},{"$f":"G71","v":{"$error":"#REF!"}},{"$f":"H71","v":{"$error":"#REF!"}},null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,"Pastos",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E72","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,null,0,"Alta",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E73","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"NPV(8.5%,F73:N73)+E73","v":{"$error":"#REF!"}}]
[null,null,null,"Media",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E74","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"}]
[null,null,null,"Baja",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E75","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,"Herbazal",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E76","v":{"$error":"#REF!"}},{"$f":"F76","v":{"$error":"#REF!"}},{"$f":"G76","v":{"$error":"#REF!"}},{"$f":"H76","v":{"$error":"#REF!"}},null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,"Pastos",{"$f":"ROUND(#REF!*#REF!,0)","v":{"$error":"#REF!"}},{"$f":"E77","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,{"$f":"NPV(8.5%,F77:N77)+E77","v":{"$error":"#REF!"}}]

{"sheet":"VET","index":13,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,3,13,5],[14,3,14,5],[15,3,15,5],[0,0,0,12],[1,0,1,12],[2,0,2,12],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5]]}
["SECRETARIA DISTRITAL DE AMBIENTE SDA"]
["METODOLOGÍA DE VALORACIÓN ECONÓMICA Y AMBIENTAL DE DAÑOS OCASIONADOS POR INCENDIOS FORESTALES PARA LA RESTAURACIÓN"]
["APROXIMACIÓN AL VALOR ECONÓMICO TOTAL"]
[]
[]
[]
[null,null,null,"Aproximación al Valor Económico Total ",null,null,"Costo"]
[null,null,null,"Valor de uso directo de la madera",null,null,{"$f":"'VUD-Madera'!D5","v":220376256}]
[null,null,null,"Valor de uso directo de la infraestructura ",null,null,{"$f":"'VUD-Infraestructura'!C4","v":0}]
[null,null,null,"Valor de uso directo de la recreación",null,null,{"$f":"'VUD-Recreación'!B5","v":0}]
[null,null,null,"Valor de uso directo del suelo",null,null,{"$f":"'VUD-Suelo Productivo'!C5","v":0}]
[null,null,null,"Valor de uso indirecto de sumidero de carbono",null,null,{"$f":"'VUI-Sumidero de carbono'!C5","v":165741304}]
[null,null,null,"Valor de uso indirecto de soporte y regulación",null,null,{"$f":"'VUI Soporte y Regulación '!B6","v":2034460808}]
[null,null,null,"Valor de uso indirecto de la calidad del aire por afectación a la salud ",null,null,{"$f":"'VUI-Salud'!C5","v":0}]
[null,null,null,"Valor de existencia de las coberturas",null,null,{"$f":"'VNU-Coberturas'!B5","v":26844837245}]
[null,null,null,"TOTAL",null,null,{"$f":"SUM(G8:G15)","v":29265415613}]