{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instrucciones","Características datos","InfoBase 6B2a","InfoBase 6B2b(población)","InfoBase 6B2b","InfoProc 6B2a","Prop. y Fact. de conversión","FE 6B2","Emisiones GEI 6B2a","Emisiones GEI 6B2b","Resultados INGEI"],"not_rendered":{"charts":2,"images":27,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Instrucciones","index":0,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[64,1,64,17],[23,5,23,17],[24,5,25,17],[26,5,26,17],[29,1,29,17],[32,2,32,8],[33,2,33,8],[34,2,34,8],[35,2,35,8],[36,2,36,8],[37,2,37,8],[38,2,38,8],[10,1,10,6],[1,1,1,17],[2,1,2,17],[13,1,13,17],[4,1,4,17],[6,1,6,17],[7,1,8,13]]}
[]
[null,"INVENTARIO NACIONAL DE GASES DE EFECTO INVERNADERO - AÑO BASE 2010"]
[null,"Sector Desechos - Subcategoría de Tratamiento y eliminación de aguas residuales domésticas"]
[]
[null,"INSTRUCCIONES "]
[]
[null,"ALCANCE"]
[null,"La subcategoría de Tratamiento y eliminación de aguas residuales domésticas, involucra a todas las emisiones de gases de efecto invernadero que se generan por la descomposición de aguas residuales domésticas en condiciones anaeróbicas. Se contabilizan además las emisiones procedentes de las excretas humanas."]
[]
[]
[null,"El Tratamiento y eliminación de aguas residuales domésticas, comprende las siguientes fuentes:\n\n- Aguas residuales domésticas. \n- Excretas humanas"]
[]
[]
[null,"METODOLOGÍA DE CALCULO"]
[]
[null,"Directrices del IPCC para Inventarios Nacionales del IPCC - 1996 (GL 1996) en lo que respecta a aguas residuales"]
[null,"Orientación del IPCC sobre las buenas prácticas y la gestión de la incertidumbre en los inventarios nacionales de Gases de Efecto Invernadero (OBP 2000)"]
[null,"Sector: Desechos"]
[null,null,null,null,null,"Para el cálculo de Emisiones GEI:"]
[]
[]
[]
[]
[null,null,null,null,null,"Nivel 1: El método mas básico que es aplicado cuando se utiliza niveles de actividad disponibles y factores de emisión por defecto de las guías del IPCC."]
[null,null,null,null,null,"Nivel 2: Método intermedio de cálculo en términos de esfuerzo y sofisticación, en la mayoría de casos se basa en el uso de niveles de actividad disponible y factores de emisión mas detallados o específicos."]
[]
[null,null,null,null,null,"Nivel 3: El método mas exigente en términos de complejidad y requerimientos de datos, usualmente implica el uso de modelos y ecuaciones complejas."]
[]
[]
[null,"ESTRUCTURA DE LA HOJA DE CALCULO "]
[]
[null,"Las hojas de cálculo, en este libro, están agrupadas por los siguientes colores:"]
[null,"Color de hoja","Descripción"]
[null,null,"Caracterización de datos"]
[null,null,"Información base de nivel de actividad"]
[null,null,"Información procesada de nivel de actividad"]
[null,null,"Propiedades, Factores de conversión y Factores de emisión de GEI"]
[null,null,"Hojas de estimaciones de emisiones GEI por desechos"]
[null,null,"Resultados GEI por desechos"]
[]
[null,"Los grupos de hojas se relacionan como se muestra en el diagrama:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ABREVIATURAS "]
[]
[null,"GEI",": Gases de Efecto Invernadero"]
[null,"FE",": Factor de Emisión"]
[null,"INGEI",": Inventario Nacional de Gases de Efecto Invernadero "]
[null,"CH4",": Metano"]
[null,"N2O",": Oxido Nitroso"]
[null,"CO2e",": Dióxido de carbono equivalente"]

{"sheet":"Características datos","index":1,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,11,16,11],[15,12,16,12],[10,1,14,1],[10,2,14,2],[10,3,14,3],[10,4,14,4],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[10,11,12,11],[10,12,14,12],[10,14,11,14],[13,11,14,11],[13,14,14,14],[1,1,1,14],[6,1,6,4],[10,5,14,5],[10,6,14,6],[15,5,16,5],[15,6,16,6]]}
[]
[null,"Caracterización de Datos - Sector Desechos (Residuos sólidos)"]
[null,"Definición IPCC: se refiere a la definición -literal o abreviada- de las GL1996. En algunos casos la definición abreviada se acompaña de un comentario (columna G) con la definición literal"]
[null,"Definición INGEI: se refiere a la definición de las GL1996, ajustada a la realidad o circunstancias del Perú. Este ajuste se identificó en el desarrollo del INGEI y mantiene el concepto general de la definición original en las GL1996"]
[null,null,"No aplica o no se considera en este INGEI"]
[]
[null,"Categorización",null,null,null,"Fuente de emisión / captura","Definición","Nivel de actividad","Unidad","TIER/Nivel","Fuente de información","Uso de la información","Gases de GEI generados por el nivel de actividad","Comentarios","Hojas relacionada"]
[null,6,null,null,null,"Desechos"]
[null,null,"6B",null,null,"Tratamiento de aguas residuales","Definición IPCC: Metano y óxido nitroso generados por la descomposición de materia orgánica en las aguas.residuales.\nDefinición INGEI: metano y óxido nitroso generados por la descomposición de materia orgánica en las aguas residuales industriales y domésticas ."]
[null,null,null,"6B2",null,"Tratamiento y eliminación de aguas residuales domésticas","Definición IPCC: Emisiones de metano que se generan en los tratamientos de aguas residuales y lodos procedentes de las viviendas y fuentes comerciales. Se consideran además las emisiones de oxido nitroso procedentes de las excretas humanas vertidas en ambientes acuáticos. \n\nDefinición INGEI: Emisiones de metano generadas en los procesos de tratamiento de aguas residuales domésticas."]
[null,null,null,null,"6B2a","Aguas residuales domésticas","Definición IPCC: Manejo de aguas residuales y lodo, de fuentes domésticas y comerciales (incluyendo residuos humanos), a través de la recolección y tratamiento de aguas residuales, letrinas o descarga en fuentes de agua. \n\nDefinición INGEI: Emisiones de metano generadas en los procesos de tratamiento de aguas residuales domésticas, considerando los vertimientos al alcatarillado público.","Población con sistema de alcantarillado","número de personas en miles",1,"Superintendencia Nacional de Servicios de Saneamiento (SUNASS)","Sirven para determinar en su conjunto las emisiones de metano generadas por el tratamiento de las aguas residuales domésticas.","CH4",null,"InfoProc 6B2a"]
[null,null,null,null,null,null,null,"Porcentaje de aguas residuales tratadas","%",1,"Superintendencia Nacional de Servicios de Saneamiento (SUNASS)"]
[null,null,null,null,null,null,null,"Demanda Biológica de Oxígeno (DBO)","Kg DBO/1000 pesonas∙año",1,"Reglamento Nacional de Edificaciones – Norma OS.090: Plantas de Tratamiento de Aguas Residuales. (Debe hacerse un ajuste para llevarlo a las unidades requeridas).",null,null,null,"Prop. y Fact. de conversión\n"]
[null,null,null,null,null,null,null,"Población del ámbito de la EPS","número de personas en miles",1,"Superintendencia Nacional de Servicios de Saneamiento (SUNASS)","La población de ámbito de la EPS y el Porcentaje de cobertura de alcantarillado, son usados para estimar la Población con sistema de alcantarillado, en caso esta información no está disponible:\nPoblación con sistema de alcantarillado = Población de ámbito de la EPS x  Porcentaje de cobertura de alcantarillado",null,null,"InfoBase 6B2a"]
[null,null,null,null,null,null,null,"Porcentaje de cobertura de alcantarillado","%",1,"Superintendencia Nacional de Servicios de Saneamiento (SUNASS)"]
[null,null,null,null,"6B2b","Excretas humanas","Definición IPCC: Las emisiones de N2O de las excretas humanas, están directamente relacionadas al ciclo del nitrógeno en la Agricultura. \n\nDefinición INGEI: se considera las emisiones indirectas de N2O por la ingesta de proteinas en la población. Estas emisiones no son consideradas en Agricultura y forman parte de las \"Aguas residuales domésticas\", que solo contabilizan CH4.","Población nacional","número de personas en miles",null,"Instituto Nacional de Estadísticas e Informática (INEI)","Sirve para determinar la cantidad de nitrógeno contenida en la orina humana","N2O",null,"infoBase6B2b(población)"]
[null,null,null,null,null,null,null,"Consumo de proteínas","g/persona∙día",1,"Organización de las Naciones Unidas para la Agricultura y la Alimentación (FAO)",null,null,null,"InfoBase 6B2b"]

{"sheet":"InfoBase 6B2a","index":2,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[18,3,19,3],[18,1,19,1],[18,5,19,5],[18,6,19,6],[18,2,19,2],[1,1,1,9],[3,1,3,9],[4,2,4,9],[9,3,9,9],[10,3,10,4],[10,6,10,7],[5,2,5,9],[6,1,9,1],[6,3,6,9],[7,3,7,9],[8,3,8,9],[11,2,11,9],[13,1,14,1],[13,2,13,9],[14,2,14,9],[11,1,12,1],[12,2,12,9]]}
[]
[null,"Información Básica: Feacción de aguas residuales que son tratadas"]
[]
[null,"DATOS DE LA INFORMACIÓN BASE"]
[null,"Código","6B"]
[null,"Subcodigo ","6B2a"]
[null,"Información ","Nivel de actividad","Porcentaje a nivel nacional de las aguas tratadas"]
[null,null,"Documento","Las EPS y su desarrollo 2013 - Datos 2010"]
[null,null,"Título ","Fracción de agua residual tratada"]
[null,null,"Subtitulo"]
[null,"Ubicación especifica","Pagina",18,null,"Cuadro",null,null,"Anexo "]
[null,"Vínculo","http://www.sunass.gob.pe/doc/eps_desarrollo_2013.pdf"]
[null,null,"Visitado en mayo 2015"]
[null,"Institución ","Superintendencia Nacional de Servicios de Saneamiento (SUNASS)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Relación de esta hoja, con otras:"]
[null,"Código","Región","Empresa Prestadora de Servicio","Tratamiento de aguas residuales","Población ámbito EPS","Población con alcantarillado"]
[null,null,null,null,2010]
[null,1,"Amazonas","EMUSAP Amazonas",0,24481.773865969175,17736.922930264671]
[null,2,"Huánuco","SEDA Huánuco S.A.",0,223196.91342521331,164483.3020784726]
[null,3,"Ucayali","EMAPACOP S.A.",0,214009.60675307398,111124.57691687338]
[null,4,"Loreto","EPS SEDALORETO S.A.",0,459618.22808807058,193960.27438607407]
[null,5,"Lima","EMAPA Cañete S.A.",8.5900000000000004E-2,171969.30664000116,98458]
[null,6,"Puno","EMSA Puno S.A.",0.65549999999999997,164096.28471680649,132391]
[null,7,"Amazonas","EPSSMU S.R.Ltda.",0,30223.964803382623,15237.504858333332]
[null,8,"Tumbes","Aguas de Tumbes",0.29469999999999996,188098.30741760091,92724.237790607469]
[null,9,"Cerro de Pasco","EMAPA Pasco S.A.",0,74812.774583160455,57122]
[null,10,"Ica","EMAPISCO S.A.",1,81196.596955387213,66133]
[null,11,"Cajamarca","SEDACAJ S.A.",7.4099999999999999E-2,171858.50143277406,140337]
[null,12,"Tacna","EPS TACNA S.A.",0.87870000000000004,258218.89459425904,243294.71920909185]
[null,13,"Ica","EMAPAVIGS S.A.C.",0.97160000000000002,36324.604404661128,27371.854828340656]
[null,14,"Áncash","SEDACHIMBOTE S.A.",0.57979999999999998,397746.07437704917,327521.52694447897]
[null,15,"Ayacucho","EPSASA",0.99719999999999998,208663.45230014343,165660.04108622178]
[null,16,"San Martín","EMAPA San Martín S.A.",4.24E-2,161463.55036870978,134321.89169976671]
[null,17,"Madre de Dios","EMAPAT S.R.Ltda.",0,62696.208327534092,25480.443749768168]
[null,18,"Ica","SEMAPACH S.A.",0.99849999999999994,173969.42293232333,126821.85987950145]
[null,19,"Junín","EPS Selva Central S.A.",0.33929999999999999,113739.55950414274,40725]
[null,20,"San Martín","EMAPA MOYOBAMBA S.R.LTDA. ",0.21489999999999998,63577.130345421181,39337]
[null,21,"Huancavelica","EMAPA HUANCAVELICA S.A.C ",0,33128.990811349475,24367]
[null,22,"Moquegua","EPS MOQUEGUA S.A.",0.53139999999999998,49023.128167915733,41145]
[null,23,"Puno","EMAPA Y S.R.L.",0,11519.844925751713,9019]
[null,24,"Lima","EMAPA HUARAL S.A.",0,81964.782540735279,59847.482559193988]
[null,25,"Lima","EMAPA HUACHO S.A.",0,116186.97466318455,96612.749143384819]
[null,26,"Lima","SEDAPAL S.A.",0.20739999999999997,8966401.6655225139,7632603.0654634899]
[null,27,"Moquegua","EPS ILO S.A.",0.97629999999999995,65036.973088242827,59660]
[null,28,"La Libertad","SEDALIB S.A.",0.67059999999999997,899597.67775907251,675212]
[null,29,"Lambayeque","EPSEL S.A.",0.88060000000000005,836889.80623452784,672727.42275723605]
[null,30,"San Martín","SEDAPAR S.A.",0.15039999999999998,998843.06983803108,763675.95537702192]
[null,31,"Cusco","SEDACUSCO S.A. ",0.9294,373545.97003205318,345370.37040960375]
[null,32,"Piura","EPS GRAU S.A.",0.48969999999999997,1009161.4167337499,695406.66042389639]
[null,33,"Áncash","EPS CHAVIN S.A.",0,114247.32924973551,84734.943394639369]
[null,34,"Cusco","EMAQ S.R.LTDA.",0,26311.310327848605,16755.680234135314]
[null,35,"Amazonas","EMAPAB S.R.LTDA. ",0,25655.498272718203,15794.033730000001]
[null,36,"Lima","SEMAPA BARRANCA S.A.               ",0,72070.646353427408,64483.0845939551]
[null,37,"Ica","EMAPICA S.A.               ",1,198320.45629137303,149663.96412986246]
[null,38,"Cusco","EMPSSAPAL S.A.",0,52958.033110584176,40074.909163424265]
[null,39,"Junín","EPS SIERRA CENTRAL S.R.L.",0,41134.116673391029,32589.111550754005]
[null,40,"Puno","EPS NOR PUNO S.A.",0.51700000000000002,22645.216298085317,16139.702180560456]
[null,41,"Puno","SEDAJULIACA S.A.",0,233466.00908579468,184589.77702808715]
[null,42,"Junín","EPS MANTARO S.A.",3.8399999999999997E-2,76702.685203211717,39791.052314007153]
[null,43,"Apurímac","EMUSAP ABANCAY S.A. ",0,46099.304088467259,38544.411573101992]
[null,44,"Apurímac","EMSAP CHANKA S.R.L.",0,29549.89548800889,13354.468473082046]
[null,45,"Cajamarca","EPS MARAÑON S.R.L.                 ",0.92779999999999996,92891.014595256871,39182.962588028167]
[null,46,"Junín","SEDAM HUANCAYO S.A.C.",0,361513.09637182805,247537.59398573992]
[null,47,"Cusco","EMSAPA CALCA S.R.L.",0,11015.08584622297,0]
[null,48,"Puno","EPS AGUAS DEL ALTIPLANO",0.24309999999999998,18786.187360193839,18258.119442691503]
[null,50,"Junín","EMSAPA YAULI S.RL.L.",0,26446.35269282592,7990.8394156102304]
[null,51,"Arequipa","SEDAPAR S.R.L. (Rioja)",0,20109.068979452808,9705.1248916042568]
[null,null,null,null,null,{"$f":"SUM(F21:F70)","v":18191182.762441237},{"$f":"SUM(G21:G70)","v":14315078.64118091}]

{"sheet":"InfoBase 6B2b(población)","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,1,14,1],[13,2,13,9],[14,2,14,9],[10,3,10,4],[10,6,10,7],[11,2,11,9],[11,1,12,1],[12,2,12,9],[1,1,1,9],[3,1,3,9],[4,2,4,9],[5,2,5,9],[6,1,9,1],[6,3,6,9],[7,3,7,9],[8,3,8,9],[9,3,9,9]]}
[]
[null,"Información Básica: Población nacional según región"]
[]
[null,"DATOS DE LA INFORMACIÓN BASE"]
[null,"Código","6A y 6B2"]
[null,"Subcodigo "]
[null,"Información ","Nivel de actividad","Población según región/provincia/distrito"]
[null,null,"Documento","-"]
[null,null,"Título ","Poblaciónal 2010"]
[null,null,"Subtitulo"]
[null,"Ubicación especifica","Pagina",null,null,"Cuadro",null,null,"Anexo "]
[null,"Vínculo","http://proyectos.inei.gob.pe/web/poblacion/#"]
[null,null,"Visitado en mayo 2015"]
[null,"Institución ","Instituto Nacional de Estadísticas e Informática"]
[]
[]
[]
[null,null,"Población total oficial del Perú:",29461933,null,null,null,"Relación de esta hoja, con otras:"]

{"sheet":"InfoBase 6B2b","index":4,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,9],[3,1,3,9],[4,2,4,9],[5,2,5,9],[6,1,9,1],[6,3,6,9],[7,3,7,9],[8,3,8,9],[9,3,9,9],[16,1,16,2],[10,3,10,4],[10,6,10,7],[11,2,11,9],[13,1,14,1],[13,2,13,9],[14,2,14,9],[11,1,12,1],[12,2,12,9]]}
[]
[null,"Consumo diario de proteínas"]
[]
[null,"DATOS DE LA INFORMACIÓN BASE"]
[null,"Código","6B"]
[null,"Subcodigo ","6B2a"]
[null,"Información ","Nivel de actividad","Consumo de proteína per cápita"]
[null,null,"Documento","Perfil de País: Indicadores de Seguridad Alimentaria"]
[null,null,"Título ","Suministro Alimentario para el Consumo Humano"]
[null,null,"Subtitulo","Consumo total de proteínas"]
[null,"Ubicación especifica","Pagina",1,null,"Cuadro",null,null,"Anexo "]
[null,"Vínculo","http://www.fao.org/fileadmin/templates/ess/documents/food_security_statistics/country_profiles/esp/Peru_S.pdf"]
[null,null,"Visitado en mayo 2015"]
[null,"Institución ","ORGANIZACION DE LAS NACIONES UNIDAS PARA LA AGRICULTURA Y LA ALIMENTACION - FAO"]
[]
[]
[null,"Porcentaje de proteínas",null,67,"g/persona·día",null,"Relación de esta hoja, con otras:"]

{"sheet":"InfoProc 6B2a","index":5,"n_rows":181,"n_cols":9,"rows_kept":181,"cut":false,"hidden":false,"merged":[[4,5,5,5],[4,4,5,4],[1,1,1,5],[4,1,5,1],[4,2,5,2],[4,3,5,3]]}
[]
[null,"Información Procesada: Población nacional según región (millares)"]
[null,null,null,null,null,null,null,"Relación de esta hoja, con otras:"]
[]
[null,"Código","Región","Empresa Prestadora de Servicio","Tratamiento de aguas residuales [%]","Población con alcantarillado [miles]"]
[]
[null,{"$f":"'InfoBase 6B2a'!B21","v":1},{"$f":"'InfoBase 6B2a'!C21","v":"Amazonas"},{"$f":"'InfoBase 6B2a'!D21","v":"EMUSAP Amazonas"},{"$f":"VLOOKUP(D7,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D7,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":17.736922930264672}]
[null,{"$f":"'InfoBase 6B2a'!B27","v":7},{"$f":"'InfoBase 6B2a'!C27","v":"Amazonas"},{"$f":"'InfoBase 6B2a'!D27","v":"EPSSMU S.R.Ltda."},{"$f":"VLOOKUP(D8,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D8,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":15.237504858333331}]
[null,{"$f":"'InfoBase 6B2a'!B55","v":35},{"$f":"'InfoBase 6B2a'!C55","v":"Amazonas"},{"$f":"'InfoBase 6B2a'!D55","v":"EMAPAB S.R.LTDA. "},{"$f":"VLOOKUP(D9,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D9,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":15.794033730000001}]
[null,{"$f":"'InfoBase 6B2a'!B34","v":14},{"$f":"'InfoBase 6B2a'!C34","v":"Áncash"},{"$f":"'InfoBase 6B2a'!D34","v":"SEDACHIMBOTE S.A."},{"$f":"VLOOKUP(D10,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.57979999999999998},{"$f":"VLOOKUP(D10,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":327.52152694447898}]
[null,{"$f":"'InfoBase 6B2a'!B53","v":33},{"$f":"'InfoBase 6B2a'!C53","v":"Áncash"},{"$f":"'InfoBase 6B2a'!D53","v":"EPS CHAVIN S.A."},{"$f":"VLOOKUP(D11,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D11,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":84.734943394639373}]
[null,{"$f":"'InfoBase 6B2a'!B63","v":43},{"$f":"'InfoBase 6B2a'!C63","v":"Apurímac"},{"$f":"'InfoBase 6B2a'!D63","v":"EMUSAP ABANCAY S.A. "},{"$f":"VLOOKUP(D12,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D12,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":38.544411573101989}]
[null,{"$f":"'InfoBase 6B2a'!B64","v":44},{"$f":"'InfoBase 6B2a'!C64","v":"Apurímac"},{"$f":"'InfoBase 6B2a'!D64","v":"EMSAP CHANKA S.R.L."},{"$f":"VLOOKUP(D13,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D13,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":13.354468473082047}]
[null,{"$f":"'InfoBase 6B2a'!B70","v":51},{"$f":"'InfoBase 6B2a'!C70","v":"Arequipa"},{"$f":"'InfoBase 6B2a'!D70","v":"SEDAPAR S.R.L. (Rioja)"},{"$f":"VLOOKUP(D14,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D14,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":9.7051248916042567}]
[null,{"$f":"'InfoBase 6B2a'!B35","v":15},{"$f":"'InfoBase 6B2a'!C35","v":"Ayacucho"},{"$f":"'InfoBase 6B2a'!D35","v":"EPSASA"},{"$f":"VLOOKUP(D15,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.99719999999999998},{"$f":"VLOOKUP(D15,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":165.66004108622178}]
[null,{"$f":"'InfoBase 6B2a'!B31","v":11},{"$f":"'InfoBase 6B2a'!C31","v":"Cajamarca"},{"$f":"'InfoBase 6B2a'!D31","v":"SEDACAJ S.A."},{"$f":"VLOOKUP(D16,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":7.4099999999999999E-2},{"$f":"VLOOKUP(D16,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":140.33699999999999}]
[null,{"$f":"'InfoBase 6B2a'!B65","v":45},{"$f":"'InfoBase 6B2a'!C65","v":"Cajamarca"},{"$f":"'InfoBase 6B2a'!D65","v":"EPS MARAÑON S.R.L.                 "},{"$f":"VLOOKUP(D17,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.92779999999999996},{"$f":"VLOOKUP(D17,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":39.182962588028168}]
[null,{"$f":"'InfoBase 6B2a'!B29","v":9},{"$f":"'InfoBase 6B2a'!C29","v":"Cerro de Pasco"},{"$f":"'InfoBase 6B2a'!D29","v":"EMAPA Pasco S.A."},{"$f":"VLOOKUP(D18,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D18,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":57.122}]
[null,{"$f":"'InfoBase 6B2a'!B51","v":31},{"$f":"'InfoBase 6B2a'!C51","v":"Cusco"},{"$f":"'InfoBase 6B2a'!D51","v":"SEDACUSCO S.A. "},{"$f":"VLOOKUP(D19,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.9294},{"$f":"VLOOKUP(D19,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":345.37037040960377}]
[null,{"$f":"'InfoBase 6B2a'!B54","v":34},{"$f":"'InfoBase 6B2a'!C54","v":"Cusco"},{"$f":"'InfoBase 6B2a'!D54","v":"EMAQ S.R.LTDA."},{"$f":"VLOOKUP(D20,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D20,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":16.755680234135315}]
[null,{"$f":"'InfoBase 6B2a'!B58","v":38},{"$f":"'InfoBase 6B2a'!C58","v":"Cusco"},{"$f":"'InfoBase 6B2a'!D58","v":"EMPSSAPAL S.A."},{"$f":"VLOOKUP(D21,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D21,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":40.074909163424266}]
[null,{"$f":"'InfoBase 6B2a'!B67","v":47},{"$f":"'InfoBase 6B2a'!C67","v":"Cusco"},{"$f":"'InfoBase 6B2a'!D67","v":"EMSAPA CALCA S.R.L."},{"$f":"VLOOKUP(D22,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D22,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B41","v":21},{"$f":"'InfoBase 6B2a'!C41","v":"Huancavelica"},{"$f":"'InfoBase 6B2a'!D41","v":"EMAPA HUANCAVELICA S.A.C "},{"$f":"VLOOKUP(D23,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D23,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":24.367000000000001}]
[null,{"$f":"'InfoBase 6B2a'!B22","v":2},{"$f":"'InfoBase 6B2a'!C22","v":"Huánuco"},{"$f":"'InfoBase 6B2a'!D22","v":"SEDA Huánuco S.A."},{"$f":"VLOOKUP(D24,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D24,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":164.4833020784726}]
[null,{"$f":"'InfoBase 6B2a'!B30","v":10},{"$f":"'InfoBase 6B2a'!C30","v":"Ica"},{"$f":"'InfoBase 6B2a'!D30","v":"EMAPISCO S.A."},{"$f":"VLOOKUP(D25,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":1},{"$f":"VLOOKUP(D25,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":66.132999999999996}]
[null,{"$f":"'InfoBase 6B2a'!B33","v":13},{"$f":"'InfoBase 6B2a'!C33","v":"Ica"},{"$f":"'InfoBase 6B2a'!D33","v":"EMAPAVIGS S.A.C."},{"$f":"VLOOKUP(D26,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.97160000000000002},{"$f":"VLOOKUP(D26,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":27.371854828340656}]
[null,{"$f":"'InfoBase 6B2a'!B38","v":18},{"$f":"'InfoBase 6B2a'!C38","v":"Ica"},{"$f":"'InfoBase 6B2a'!D38","v":"SEMAPACH S.A."},{"$f":"VLOOKUP(D27,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.99849999999999994},{"$f":"VLOOKUP(D27,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":126.82185987950146}]
[null,{"$f":"'InfoBase 6B2a'!B57","v":37},{"$f":"'InfoBase 6B2a'!C57","v":"Ica"},{"$f":"'InfoBase 6B2a'!D57","v":"EMAPICA S.A.               "},{"$f":"VLOOKUP(D28,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":1},{"$f":"VLOOKUP(D28,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":149.66396412986245}]
[null,{"$f":"'InfoBase 6B2a'!B39","v":19},{"$f":"'InfoBase 6B2a'!C39","v":"Junín"},{"$f":"'InfoBase 6B2a'!D39","v":"EPS Selva Central S.A."},{"$f":"VLOOKUP(D29,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.33929999999999999},{"$f":"VLOOKUP(D29,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":40.725000000000001}]
[null,{"$f":"'InfoBase 6B2a'!B59","v":39},{"$f":"'InfoBase 6B2a'!C59","v":"Junín"},{"$f":"'InfoBase 6B2a'!D59","v":"EPS SIERRA CENTRAL S.R.L."},{"$f":"VLOOKUP(D30,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D30,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":32.589111550754005}]
[null,{"$f":"'InfoBase 6B2a'!B62","v":42},{"$f":"'InfoBase 6B2a'!C62","v":"Junín"},{"$f":"'InfoBase 6B2a'!D62","v":"EPS MANTARO S.A."},{"$f":"VLOOKUP(D31,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":3.8399999999999997E-2},{"$f":"VLOOKUP(D31,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":39.791052314007153}]
[null,{"$f":"'InfoBase 6B2a'!B66","v":46},{"$f":"'InfoBase 6B2a'!C66","v":"Junín"},{"$f":"'InfoBase 6B2a'!D66","v":"SEDAM HUANCAYO S.A.C."},{"$f":"VLOOKUP(D32,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D32,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":247.53759398573993}]
[null,{"$f":"'InfoBase 6B2a'!B69","v":50},{"$f":"'InfoBase 6B2a'!C69","v":"Junín"},{"$f":"'InfoBase 6B2a'!D69","v":"EMSAPA YAULI S.RL.L."},{"$f":"VLOOKUP(D33,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D33,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":7.99083941561023}]
[null,{"$f":"'InfoBase 6B2a'!B48","v":28},{"$f":"'InfoBase 6B2a'!C48","v":"La Libertad"},{"$f":"'InfoBase 6B2a'!D48","v":"SEDALIB S.A."},{"$f":"VLOOKUP(D34,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.67059999999999997},{"$f":"VLOOKUP(D34,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":675.21199999999999}]
[null,{"$f":"'InfoBase 6B2a'!B49","v":29},{"$f":"'InfoBase 6B2a'!C49","v":"Lambayeque"},{"$f":"'InfoBase 6B2a'!D49","v":"EPSEL S.A."},{"$f":"VLOOKUP(D35,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.88060000000000005},{"$f":"VLOOKUP(D35,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":672.72742275723601}]
[null,{"$f":"'InfoBase 6B2a'!B25","v":5},{"$f":"'InfoBase 6B2a'!C25","v":"Lima"},{"$f":"'InfoBase 6B2a'!D25","v":"EMAPA Cañete S.A."},{"$f":"VLOOKUP(D36,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":8.5900000000000004E-2},{"$f":"VLOOKUP(D36,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":98.457999999999998}]
[null,{"$f":"'InfoBase 6B2a'!B44","v":24},{"$f":"'InfoBase 6B2a'!C44","v":"Lima"},{"$f":"'InfoBase 6B2a'!D44","v":"EMAPA HUARAL S.A."},{"$f":"VLOOKUP(D37,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D37,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":59.847482559193985}]
[null,{"$f":"'InfoBase 6B2a'!B45","v":25},{"$f":"'InfoBase 6B2a'!C45","v":"Lima"},{"$f":"'InfoBase 6B2a'!D45","v":"EMAPA HUACHO S.A."},{"$f":"VLOOKUP(D38,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D38,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":96.612749143384818}]
[null,{"$f":"'InfoBase 6B2a'!B46","v":26},{"$f":"'InfoBase 6B2a'!C46","v":"Lima"},{"$f":"'InfoBase 6B2a'!D46","v":"SEDAPAL S.A."},{"$f":"VLOOKUP(D39,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.20739999999999997},{"$f":"VLOOKUP(D39,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":7632.6030654634897}]
[null,{"$f":"'InfoBase 6B2a'!B56","v":36},{"$f":"'InfoBase 6B2a'!C56","v":"Lima"},{"$f":"'InfoBase 6B2a'!D56","v":"SEMAPA BARRANCA S.A.               "},{"$f":"VLOOKUP(D40,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D40,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":64.483084593955098}]
[null,{"$f":"'InfoBase 6B2a'!B24","v":4},{"$f":"'InfoBase 6B2a'!C24","v":"Loreto"},{"$f":"'InfoBase 6B2a'!D24","v":"EPS SEDALORETO S.A."},{"$f":"VLOOKUP(D41,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D41,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":193.96027438607408}]
[null,{"$f":"'InfoBase 6B2a'!B37","v":17},{"$f":"'InfoBase 6B2a'!C37","v":"Madre de Dios"},{"$f":"'InfoBase 6B2a'!D37","v":"EMAPAT S.R.Ltda."},{"$f":"VLOOKUP(D42,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D42,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":25.480443749768167}]
[null,{"$f":"'InfoBase 6B2a'!B42","v":22},{"$f":"'InfoBase 6B2a'!C42","v":"Moquegua"},{"$f":"'InfoBase 6B2a'!D42","v":"EPS MOQUEGUA S.A."},{"$f":"VLOOKUP(D43,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.53139999999999998},{"$f":"VLOOKUP(D43,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":41.145000000000003}]
[null,{"$f":"'InfoBase 6B2a'!B47","v":27},{"$f":"'InfoBase 6B2a'!C47","v":"Moquegua"},{"$f":"'InfoBase 6B2a'!D47","v":"EPS ILO S.A."},{"$f":"VLOOKUP(D44,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.97629999999999995},{"$f":"VLOOKUP(D44,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":59.66}]
[null,{"$f":"'InfoBase 6B2a'!B52","v":32},{"$f":"'InfoBase 6B2a'!C52","v":"Piura"},{"$f":"'InfoBase 6B2a'!D52","v":"EPS GRAU S.A."},{"$f":"VLOOKUP(D45,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.48969999999999997},{"$f":"VLOOKUP(D45,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":695.40666042389637}]
[null,{"$f":"'InfoBase 6B2a'!B26","v":6},{"$f":"'InfoBase 6B2a'!C26","v":"Puno"},{"$f":"'InfoBase 6B2a'!D26","v":"EMSA Puno S.A."},{"$f":"VLOOKUP(D46,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.65549999999999997},{"$f":"VLOOKUP(D46,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":132.39099999999999}]
[null,{"$f":"'InfoBase 6B2a'!B43","v":23},{"$f":"'InfoBase 6B2a'!C43","v":"Puno"},{"$f":"'InfoBase 6B2a'!D43","v":"EMAPA Y S.R.L."},{"$f":"VLOOKUP(D47,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D47,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":9.0190000000000001}]
[null,{"$f":"'InfoBase 6B2a'!B60","v":40},{"$f":"'InfoBase 6B2a'!C60","v":"Puno"},{"$f":"'InfoBase 6B2a'!D60","v":"EPS NOR PUNO S.A."},{"$f":"VLOOKUP(D48,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.51700000000000002},{"$f":"VLOOKUP(D48,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":16.139702180560455}]
[null,{"$f":"'InfoBase 6B2a'!B61","v":41},{"$f":"'InfoBase 6B2a'!C61","v":"Puno"},{"$f":"'InfoBase 6B2a'!D61","v":"SEDAJULIACA S.A."},{"$f":"VLOOKUP(D49,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D49,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":184.58977702808716}]
[null,{"$f":"'InfoBase 6B2a'!B68","v":48},{"$f":"'InfoBase 6B2a'!C68","v":"Puno"},{"$f":"'InfoBase 6B2a'!D68","v":"EPS AGUAS DEL ALTIPLANO"},{"$f":"VLOOKUP(D50,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.24309999999999998},{"$f":"VLOOKUP(D50,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":18.258119442691502}]
[null,{"$f":"'InfoBase 6B2a'!B36","v":16},{"$f":"'InfoBase 6B2a'!C36","v":"San Martín"},{"$f":"'InfoBase 6B2a'!D36","v":"EMAPA San Martín S.A."},{"$f":"VLOOKUP(D51,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":4.24E-2},{"$f":"VLOOKUP(D51,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":134.32189169976672}]
[null,{"$f":"'InfoBase 6B2a'!B40","v":20},{"$f":"'InfoBase 6B2a'!C40","v":"San Martín"},{"$f":"'InfoBase 6B2a'!D40","v":"EMAPA MOYOBAMBA S.R.LTDA. "},{"$f":"VLOOKUP(D52,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.21489999999999998},{"$f":"VLOOKUP(D52,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":39.337000000000003}]
[null,{"$f":"'InfoBase 6B2a'!B50","v":30},{"$f":"'InfoBase 6B2a'!C50","v":"San Martín"},{"$f":"'InfoBase 6B2a'!D50","v":"SEDAPAR S.A."},{"$f":"VLOOKUP(D53,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.15039999999999998},{"$f":"VLOOKUP(D53,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":763.67595537702186}]
[null,{"$f":"'InfoBase 6B2a'!B32","v":12},{"$f":"'InfoBase 6B2a'!C32","v":"Tacna"},{"$f":"'InfoBase 6B2a'!D32","v":"EPS TACNA S.A."},{"$f":"VLOOKUP(D54,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.87870000000000004},{"$f":"VLOOKUP(D54,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":243.29471920909185}]
[null,{"$f":"'InfoBase 6B2a'!B28","v":8},{"$f":"'InfoBase 6B2a'!C28","v":"Tumbes"},{"$f":"'InfoBase 6B2a'!D28","v":"Aguas de Tumbes"},{"$f":"VLOOKUP(D55,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0.29469999999999996},{"$f":"VLOOKUP(D55,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":92.724237790607475}]
[null,{"$f":"'InfoBase 6B2a'!B23","v":3},{"$f":"'InfoBase 6B2a'!C23","v":"Ucayali"},{"$f":"'InfoBase 6B2a'!D23","v":"EMAPACOP S.A."},{"$f":"VLOOKUP(D56,'InfoBase 6B2a'!$D$21:$G$70,2,FALSE)","v":0},{"$f":"VLOOKUP(D56,'InfoBase 6B2a'!$D$21:$G$70,4,FALSE)/1000","v":111.12457691687338}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Prop. y Fact. de conversión'!C36*365/'Prop. y Fact. de conversión'!C17*1000","v":18250},"kg/1000 personas.año"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C98:C101)","v":808436},{"$f":"SUM(D98:D101)","v":259098}]
[null,null,438834,93349,21.27]
[null,null,273868,146592,53.53]
[null,null,65654,10989,16.739999999999998]
[null,null,30080,8168,27.16]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Demanda Bioquímica de Oxígeno (DBO)"]
[]
[null,"DBO5"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AVERAGE('InfoBase 6B2a'!E21:E70)","v":0.29389399999999993},{"$f":"AVERAGE('InfoBase 6B2a'!#REF!)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"AVERAGE('InfoBase 6B2a'!#REF!)","v":{"$error":"#REF!"}},{"$f":"AVERAGE('InfoBase 6B2a'!#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"AVERAGE('InfoBase 6B2a'!#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"Prop. y Fact. de conversión","index":6,"n_rows":68,"n_cols":6,"rows_kept":68,"cut":false,"hidden":false,"merged":[[1,1,1,3],[14,1,14,3],[12,1,12,3],[33,1,33,3],[42,1,42,3],[26,1,27,3],[29,1,29,3]]}
[]
[null,"Relación de metano/carbono y oxido nitroso/nitrógeno"]
[]
[null,"Peso atómico del carbono",12]
[null,"Peso atómico del hidrógeno",1]
[null,"Peso atómico del nitrógeno",14]
[null,"Peso atómico del oxígeno",16]
[null,"Fuente: Tabla periódica de los elementos"]
[]
[null,"Relación CH4/C",{"$f":"(C4+C5*4)/C4","v":1.3333333333333333}]
[]
[]
[null,"Conversión de unidades"]
[]
[null,"Masa"]
[null,"1 tonelada",1000,"kg"]
[null,"1 kilogramo",1000,"g"]
[null,"1 tonelada",{"$f":"C16*C17","v":1000000},"g"]
[]
[null,"Prefijo","Simbolo","Factor "]
[null,"deca","da",{"$f":"10^1","v":10}]
[null,"hecto","h",{"$f":"10^2","v":100}]
[null,"kilo","k",{"$f":"10^3","v":1000}]
[null,"mega","M",{"$f":"10^6","v":1000000}]
[null,"giga","G",{"$f":"10^9","v":1000000000}]
[null,"tera","T",{"$f":"10^12","v":1000000000000}]
[null,"Fuente: Sistema Internacional - Guide for the Use of the International System of Units (SI)\nhttp://physics.nist.gov/cuu/pdf/sp811.pdf"]
[]
[]
[null,"Volumen"]
[null,"1 centimetro cúbico",{"$f":"1/1000","v":1E-3},"l"]
[null,"Fuente: http://www.metric-conversions.org/es/volumen/tabla-de-conversion-de-centimetros-cubicos-a-litros.htm"]
[]
[null,"Demanda Bioquímica de Oxígeno (DBO)"]
[]
[null,"DBO5",50,"g/hab.día"]
[]
[]
[]
[]
[]
[]
[null,"Densidades de bebidas"]
[]
[null,"Densidad del vino",{"$f":"(996+997)/2","v":996.5},"g/l"]
[null,"Densidad de cerveza",1010,"g/cm3"]
[]
[]
[]
[]
[null,null,null,null,null,"http://www.inti.gob.ar/interlaboratorios/informes/2010/alimentos/2010_informe_final_vinos.pdf"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"http://www.atpplleal.com/Pujat/file/DENSIDAD%20Y%20PESO%20ESPECIFICO.pdf"]

{"sheet":"FE 6B2","index":7,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,16,4],[18,3,18,4],[6,1,6,5],[8,3,8,4],[1,1,1,6],[11,1,11,4],[13,3,13,4]]}
[]
[null,"Factor de conversión de metano para el sistema de manejo (FCM)"]
[]
[null,"FCM",0.8]
[null,"Fuente: GL 1996, cuadro 6-7, página 6.20 "]
[]
[null,"Capacidad máxima de producción de metano (Bo)"]
[]
[null,"Bo",0.6,"kg CH4/kg DBO"]
[null,"Fuente: OBP 2000, página 5.18"]
[]
[null,"Fracción de nitrógeno en la proteína"]
[]
[null,"FracNPR",0.16,"Kg N/Kg proteína"]
[null,"Fuente: IPCC 1996, página 6.25"]
[]
[null,"Factor de emisión por excretas humanas"]
[]
[null,"EF6",0.01,"kgCH4/kgDBO"]
[null,"Fuente: IPCC 1996, página 6.25"]

{"sheet":"Emisiones GEI 6B2a","index":8,"n_rows":63,"n_cols":16,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,2,3,3],[4,2,4,3],[5,2,5,3]]}
[]
[null,"Estimación de metano generado por el tratamiento de aguas residuales domésticas "]
[]
[null,"Sector","Desechos"]
[null,"Categoría","Aguas residuales domésticas"]
[null,"Código de categoría","6B2a"]
[]
[]
[]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O"]
[null,"Región - EPS","Población con alcantarillado               \n(1,000 personas)","Componente orgánico degradable                       \n(kg DBO/1000 personas/año)    ","Fracción del componente orgánico degradable removido como lodo","Total del componente orgánico del agua residual doméstica residual/comercial                       \n(kg DBO/año)","Total  del componente orgánico del lodo doméstico/comercial                        \n(kg DBO/año)","Sistemas de manejo de aguas residuales ","Fracción de agua residual tratada por el sistema de manejo","Factor de conversión de metano para el sistema de manejo","Producto","Capacidad máxima de producción de metano\n(kg CH4/kg DBO)","Factor de emisión para aguas residuales domésticas\n(kg CH4/kg DBO)","Emisiones de metano sin recuperación o quema              \n(Kg CH4)","Metano recuperado o quemado \n(Kg CH4)","Emisiones netas de metano\n(Gg CH4)"]
[null,null,null,null,null,"E = [B x C x (1-D)]","F = (B x C x D)",null,null,null,"J = (H x I )",null,"L = (J x K)","M = (E x L)",null,"K = (M - N)/1 000 000"]
[null,{"$f":"'InfoProc 6B2a'!C7& \"- \" & 'InfoBase 6B2a'!D21","v":"Amazonas- EMUSAP Amazonas"},{"$f":"'InfoProc 6B2a'!F7","v":17.736922930264672},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,{"$f":"(C13*D13*(1-E13))","v":323698.84347733029},{"$f":"C13*D13*E13","v":0},null,{"$f":"'InfoProc 6B2a'!E7","v":0},{"$f":"'FE 6B2'!C4","v":0.8},{"$f":"I13*J13","v":0},{"$f":"'FE 6B2'!C9","v":0.6},{"$f":"K13*L13","v":0},{"$f":"F13*M13","v":0},{"$f":"M13","v":0},{"$f":"(N13-O13)/1000000","v":0}]
[null,{"$f":"'InfoProc 6B2a'!C8& \"- \" & 'InfoBase 6B2a'!D22","v":"Amazonas- SEDA Huánuco S.A."},{"$f":"'InfoProc 6B2a'!F8","v":15.237504858333331},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,{"$f":"(C14*D14*(1-E14))","v":278084.46366458328},{"$f":"C14*D14*E14","v":0},null,{"$f":"'InfoProc 6B2a'!E8","v":0},{"$f":"'FE 6B2'!C4","v":0.8},{"$f":"I14*J14","v":0},{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M14","v":0},{"$f":"(N14-O14)/1000000","v":0}]
[null,{"$f":"'InfoProc 6B2a'!C9& \"- \" & 'InfoBase 6B2a'!D23","v":"Amazonas- EMAPACOP S.A."},{"$f":"'InfoProc 6B2a'!F9","v":15.794033730000001},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,288241.11557249998,0,null,{"$f":"'InfoProc 6B2a'!E9","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M15","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C10& \"- \" & 'InfoBase 6B2a'!D24","v":"Áncash- EPS SEDALORETO S.A."},{"$f":"'InfoProc 6B2a'!F10","v":327.52152694447898},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,5977267.8667367417,0,null,{"$f":"'InfoProc 6B2a'!E10","v":0.57979999999999998},{"$f":"'FE 6B2'!C4","v":0.8},0.46384000000000003,{"$f":"'FE 6B2'!C9","v":0.6},0.278304,1663497.5563843022,{"$f":"M16","v":0.278304},1.6634972780803023]
[null,{"$f":"'InfoProc 6B2a'!C11& \"- \" & 'InfoBase 6B2a'!D25","v":"Áncash- EMAPA Cañete S.A."},{"$f":"'InfoProc 6B2a'!F11","v":84.734943394639373},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1546412.7169521686,0,null,{"$f":"'InfoProc 6B2a'!E11","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M17","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C12& \"- \" & 'InfoBase 6B2a'!D26","v":"Apurímac- EMSA Puno S.A."},{"$f":"'InfoProc 6B2a'!F12","v":38.544411573101989},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,703435.51120911131,0,null,{"$f":"'InfoProc 6B2a'!E12","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M18","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C13& \"- \" & 'InfoBase 6B2a'!D27","v":"Apurímac- EPSSMU S.R.Ltda."},{"$f":"'InfoProc 6B2a'!F13","v":13.354468473082047},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,243719.04963374735,0,null,{"$f":"'InfoProc 6B2a'!E13","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M19","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C14& \"- \" & 'InfoBase 6B2a'!D28","v":"Arequipa- Aguas de Tumbes"},{"$f":"'InfoProc 6B2a'!F14","v":9.7051248916042567},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,177118.52927177769,0,null,{"$f":"'InfoProc 6B2a'!E14","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M20","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C15& \"- \" & 'InfoBase 6B2a'!D29","v":"Ayacucho- EMAPA Pasco S.A."},{"$f":"'InfoProc 6B2a'!F15","v":165.66004108622178},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,3023295.7498235474,0,null,{"$f":"'InfoProc 6B2a'!E15","v":0.99719999999999998},{"$f":"'FE 6B2'!C4","v":0.8},0.79776000000000002,{"$f":"'FE 6B2'!C9","v":0.6},0.47865599999999997,1447118.6504275398,{"$f":"M21","v":0.47865599999999997},1.4471181717715398]
[null,{"$f":"'InfoProc 6B2a'!C16& \"- \" & 'InfoBase 6B2a'!D30","v":"Cajamarca- EMAPISCO S.A."},{"$f":"'InfoProc 6B2a'!F16","v":140.33699999999999},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,2561150.25,0,null,{"$f":"'InfoProc 6B2a'!E16","v":7.4099999999999999E-2},{"$f":"'FE 6B2'!C4","v":0.8},5.9279999999999999E-2,{"$f":"'FE 6B2'!C9","v":0.6},3.5567999999999995E-2,91094.992091999986,{"$f":"M22","v":3.5567999999999995E-2},9.1094956523999973E-2]
[null,{"$f":"'InfoProc 6B2a'!C17& \"- \" & 'InfoBase 6B2a'!D31","v":"Cajamarca- SEDACAJ S.A."},{"$f":"'InfoProc 6B2a'!F17","v":39.182962588028168},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,715089.06723151403,0,null,{"$f":"'InfoProc 6B2a'!E17","v":0.92779999999999996},{"$f":"'FE 6B2'!C4","v":0.8},0.74224000000000001,{"$f":"'FE 6B2'!C9","v":0.6},0.44534400000000002,318460.62555715139,{"$f":"M23","v":0.44534400000000002},0.31846018021315137]
[null,{"$f":"'InfoProc 6B2a'!C18& \"- \" & 'InfoBase 6B2a'!D32","v":"Cerro de Pasco- EPS TACNA S.A."},{"$f":"'InfoProc 6B2a'!F18","v":57.122},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1042476.5,0,null,{"$f":"'InfoProc 6B2a'!E18","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M24","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C19& \"- \" & 'InfoBase 6B2a'!D33","v":"Cusco- EMAPAVIGS S.A.C."},{"$f":"'InfoProc 6B2a'!F19","v":345.37037040960377},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,6303009.2599752685,0,null,{"$f":"'InfoProc 6B2a'!E19","v":0.9294},{"$f":"'FE 6B2'!C4","v":0.8},0.74352000000000007,{"$f":"'FE 6B2'!C9","v":0.6},0.44611200000000001,2811848.0669860872,{"$f":"M25","v":0.44611200000000001},2.8118476208740875]
[null,{"$f":"'InfoProc 6B2a'!C20& \"- \" & 'InfoBase 6B2a'!D34","v":"Cusco- SEDACHIMBOTE S.A."},{"$f":"'InfoProc 6B2a'!F20","v":16.755680234135315},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,305791.16427296953,0,null,{"$f":"'InfoProc 6B2a'!E20","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M26","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C21& \"- \" & 'InfoBase 6B2a'!D35","v":"Cusco- EPSASA"},{"$f":"'InfoProc 6B2a'!F21","v":40.074909163424266},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,731367.09223249287,0,null,{"$f":"'InfoProc 6B2a'!E21","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M27","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C22& \"- \" & 'InfoBase 6B2a'!D36","v":"Cusco- EMAPA San Martín S.A."},{"$f":"'InfoProc 6B2a'!F22","v":0},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E22","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M28","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C23& \"- \" & 'InfoBase 6B2a'!D37","v":"Huancavelica- EMAPAT S.R.Ltda."},{"$f":"'InfoProc 6B2a'!F23","v":24.367000000000001},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,444697.75,0,null,{"$f":"'InfoProc 6B2a'!E23","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M29","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C24& \"- \" & 'InfoBase 6B2a'!D38","v":"Huánuco- SEMAPACH S.A."},{"$f":"'InfoProc 6B2a'!F24","v":164.4833020784726},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,3001820.262932125,0,null,{"$f":"'InfoProc 6B2a'!E24","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M30","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C25& \"- \" & 'InfoBase 6B2a'!D39","v":"Ica- EPS Selva Central S.A."},{"$f":"'InfoProc 6B2a'!F25","v":66.132999999999996},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1206927.25,0,null,{"$f":"'InfoProc 6B2a'!E25","v":1},{"$f":"'FE 6B2'!C4","v":0.8},0.8,{"$f":"'FE 6B2'!C9","v":0.6},0.48,579325.07999999996,{"$f":"M31","v":0.48},0.57932459999999997]
[null,{"$f":"'InfoProc 6B2a'!C26& \"- \" & 'InfoBase 6B2a'!D40","v":"Ica- EMAPA MOYOBAMBA S.R.LTDA. "},{"$f":"'InfoProc 6B2a'!F26","v":27.371854828340656},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,499536.35061721696,0,null,{"$f":"'InfoProc 6B2a'!E26","v":0.97160000000000002},{"$f":"'FE 6B2'!C4","v":0.8},0.77728000000000008,{"$f":"'FE 6B2'!C9","v":0.6},0.466368,232967.76876465025,{"$f":"M32","v":0.466368},0.23296730239665026]
[null,{"$f":"'InfoProc 6B2a'!C27& \"- \" & 'InfoBase 6B2a'!D41","v":"Ica- EMAPA HUANCAVELICA S.A.C "},{"$f":"'InfoProc 6B2a'!F27","v":126.82185987950146},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,2314498.9428009018,0,null,{"$f":"'InfoProc 6B2a'!E27","v":0.99849999999999994},{"$f":"'FE 6B2'!C4","v":0.8},0.79879999999999995,{"$f":"'FE 6B2'!C9","v":0.6},0.47927999999999993,1109293.0533056161,{"$f":"M33","v":0.47927999999999993},1.1092925740256161]
[null,{"$f":"'InfoProc 6B2a'!C28& \"- \" & 'InfoBase 6B2a'!D42","v":"Ica- EPS MOQUEGUA S.A."},{"$f":"'InfoProc 6B2a'!F28","v":149.66396412986245},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,2731367.3453699895,0,null,{"$f":"'InfoProc 6B2a'!E28","v":1},{"$f":"'FE 6B2'!C4","v":0.8},0.8,{"$f":"'FE 6B2'!C9","v":0.6},0.48,1311056.3257775949,{"$f":"M34","v":0.48},1.3110558457775949]
[null,{"$f":"'InfoProc 6B2a'!C29& \"- \" & 'InfoBase 6B2a'!D43","v":"Junín- EMAPA Y S.R.L."},{"$f":"'InfoProc 6B2a'!F29","v":40.725000000000001},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,743231.25,0,null,{"$f":"'InfoProc 6B2a'!E29","v":0.33929999999999999},{"$f":"'FE 6B2'!C4","v":0.8},0.27144000000000001,{"$f":"'FE 6B2'!C9","v":0.6},0.16286400000000001,121045.6143,{"$f":"M35","v":0.16286400000000001},0.121045451436]
[null,{"$f":"'InfoProc 6B2a'!C30& \"- \" & 'InfoBase 6B2a'!D44","v":"Junín- EMAPA HUARAL S.A."},{"$f":"'InfoProc 6B2a'!F30","v":32.589111550754005},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,594751.28580126062,0,null,{"$f":"'InfoProc 6B2a'!E30","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M36","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C31& \"- \" & 'InfoBase 6B2a'!D45","v":"Junín- EMAPA HUACHO S.A."},{"$f":"'InfoProc 6B2a'!F31","v":39.791052314007153},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,726186.7047306305,0,null,{"$f":"'InfoProc 6B2a'!E31","v":3.8399999999999997E-2},{"$f":"'FE 6B2'!C4","v":0.8},3.0719999999999997E-2,{"$f":"'FE 6B2'!C9","v":0.6},1.8431999999999997E-2,13385.07334159498,{"$f":"M37","v":1.8431999999999997E-2},1.338505490959498E-2]
[null,{"$f":"'InfoProc 6B2a'!C32& \"- \" & 'InfoBase 6B2a'!D46","v":"Junín- SEDAPAL S.A."},{"$f":"'InfoProc 6B2a'!F32","v":247.53759398573993},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,4517561.0902397539,0,null,{"$f":"'InfoProc 6B2a'!E32","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M38","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C33& \"- \" & 'InfoBase 6B2a'!D47","v":"Junín- EPS ILO S.A."},{"$f":"'InfoProc 6B2a'!F33","v":7.99083941561023},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,145832.81933488671,0,null,{"$f":"'InfoProc 6B2a'!E33","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M39","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C34& \"- \" & 'InfoBase 6B2a'!D48","v":"La Libertad- SEDALIB S.A."},{"$f":"'InfoProc 6B2a'!F34","v":675.21199999999999},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,12322619,0,null,{"$f":"'InfoProc 6B2a'!E34","v":0.67059999999999997},{"$f":"'FE 6B2'!C4","v":0.8},0.53647999999999996,{"$f":"'FE 6B2'!C9","v":0.6},0.32188799999999995,3966503.1846719994,{"$f":"M40","v":0.32188799999999995},3.9665028627839996]
[null,{"$f":"'InfoProc 6B2a'!C35& \"- \" & 'InfoBase 6B2a'!D49","v":"Lambayeque- EPSEL S.A."},{"$f":"'InfoProc 6B2a'!F35","v":672.72742275723601},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,12277275.465319557,0,null,{"$f":"'InfoProc 6B2a'!E35","v":0.88060000000000005},{"$f":"'FE 6B2'!C4","v":0.8},0.70448000000000011,{"$f":"'FE 6B2'!C9","v":0.6},0.42268800000000006,5189457.0118849939,{"$f":"M41","v":0.42268800000000006},5.1894565891969942]
[null,{"$f":"'InfoProc 6B2a'!C36& \"- \" & 'InfoBase 6B2a'!D50","v":"Lima- SEDAPAR S.A."},{"$f":"'InfoProc 6B2a'!F36","v":98.457999999999998},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1796858.5,0,null,{"$f":"'InfoProc 6B2a'!E36","v":8.5900000000000004E-2},{"$f":"'FE 6B2'!C4","v":0.8},6.8720000000000003E-2,{"$f":"'FE 6B2'!C9","v":0.6},4.1231999999999998E-2,74088.069671999998,{"$f":"M42","v":4.1231999999999998E-2},7.4088028439999995E-2]
[null,{"$f":"'InfoProc 6B2a'!C37& \"- \" & 'InfoBase 6B2a'!D51","v":"Lima- SEDACUSCO S.A. "},{"$f":"'InfoProc 6B2a'!F37","v":59.847482559193985},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1092216.5567052902,0,null,{"$f":"'InfoProc 6B2a'!E37","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M43","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C38& \"- \" & 'InfoBase 6B2a'!D52","v":"Lima- EPS GRAU S.A."},{"$f":"'InfoProc 6B2a'!F38","v":96.612749143384818},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1763182.6718667729,0,null,{"$f":"'InfoProc 6B2a'!E38","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M44","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C39& \"- \" & 'InfoBase 6B2a'!D53","v":"Lima- EPS CHAVIN S.A."},{"$f":"'InfoProc 6B2a'!F39","v":7632.6030654634897},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,139295005.94470868,0,null,{"$f":"'InfoProc 6B2a'!E39","v":0.20739999999999997},{"$f":"'FE 6B2'!C4","v":0.8},0.16591999999999998,{"$f":"'FE 6B2'!C9","v":0.6},9.9551999999999988E-2,13867096.431807637,{"$f":"M45","v":9.9551999999999988E-2},13.867096332255636]
[null,{"$f":"'InfoProc 6B2a'!C40& \"- \" & 'InfoBase 6B2a'!D54","v":"Lima- EMAQ S.R.LTDA."},{"$f":"'InfoProc 6B2a'!F40","v":64.483084593955098},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1176816.2938396805,0,null,{"$f":"'InfoProc 6B2a'!E40","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M46","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C41& \"- \" & 'InfoBase 6B2a'!D55","v":"Loreto- EMAPAB S.R.LTDA. "},{"$f":"'InfoProc 6B2a'!F41","v":193.96027438607408},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,3539775.0075458521,0,null,{"$f":"'InfoProc 6B2a'!E41","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M47","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C42& \"- \" & 'InfoBase 6B2a'!D56","v":"Madre de Dios- SEMAPA BARRANCA S.A.               "},{"$f":"'InfoProc 6B2a'!F42","v":25.480443749768167},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,465018.09843326907,0,null,{"$f":"'InfoProc 6B2a'!E42","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M48","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C43& \"- \" & 'InfoBase 6B2a'!D57","v":"Moquegua- EMAPICA S.A.               "},{"$f":"'InfoProc 6B2a'!F43","v":41.145000000000003},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,750896.25,0,null,{"$f":"'InfoProc 6B2a'!E43","v":0.53139999999999998},{"$f":"'FE 6B2'!C4","v":0.8},0.42512,{"$f":"'FE 6B2'!C9","v":0.6},0.25507199999999997,191532.60827999999,{"$f":"M49","v":0.25507199999999997},0.19153235320799999]
[null,{"$f":"'InfoProc 6B2a'!C44& \"- \" & 'InfoBase 6B2a'!D58","v":"Moquegua- EMPSSAPAL S.A."},{"$f":"'InfoProc 6B2a'!F44","v":59.66},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1088795,0,null,{"$f":"'InfoProc 6B2a'!E44","v":0.97629999999999995},{"$f":"'FE 6B2'!C4","v":0.8},0.78103999999999996,{"$f":"'FE 6B2'!C9","v":0.6},0.46862399999999993,510235.4680799999,{"$f":"M50","v":0.46862399999999993},0.51023499945599993]
[null,{"$f":"'InfoProc 6B2a'!C45& \"- \" & 'InfoBase 6B2a'!D59","v":"Piura- EPS SIERRA CENTRAL S.R.L."},{"$f":"'InfoProc 6B2a'!F45","v":695.40666042389637},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,12691171.552736109,0,null,{"$f":"'InfoProc 6B2a'!E45","v":0.48969999999999997},{"$f":"'FE 6B2'!C4","v":0.8},0.39176,{"$f":"'FE 6B2'!C9","v":0.6},0.23505599999999999,2983136.0204999386,{"$f":"M51","v":0.23505599999999999},2.9831357854439386]
[null,{"$f":"'InfoProc 6B2a'!C46& \"- \" & 'InfoBase 6B2a'!D60","v":"Puno- EPS NOR PUNO S.A."},{"$f":"'InfoProc 6B2a'!F46","v":132.39099999999999},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,2416135.75,0,null,{"$f":"'InfoProc 6B2a'!E46","v":0.65549999999999997},{"$f":"'FE 6B2'!C4","v":0.8},0.52439999999999998,{"$f":"'FE 6B2'!C9","v":0.6},0.31463999999999998,760212.95237999992,{"$f":"M52","v":0.31463999999999998},0.76021263773999992]
[null,{"$f":"'InfoProc 6B2a'!C47& \"- \" & 'InfoBase 6B2a'!D61","v":"Puno- SEDAJULIACA S.A."},{"$f":"'InfoProc 6B2a'!F47","v":9.0190000000000001},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,164596.75,0,null,{"$f":"'InfoProc 6B2a'!E47","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M53","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C48& \"- \" & 'InfoBase 6B2a'!D62","v":"Puno- EPS MANTARO S.A."},{"$f":"'InfoProc 6B2a'!F48","v":16.139702180560455},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,294549.5647952283,0,null,{"$f":"'InfoProc 6B2a'!E48","v":0.51700000000000002},{"$f":"'FE 6B2'!C4","v":0.8},0.41360000000000002,{"$f":"'FE 6B2'!C9","v":0.6},0.24815999999999999,73095.419999583857,{"$f":"M54","v":0.24815999999999999},7.3095171839583861E-2]
[null,{"$f":"'InfoProc 6B2a'!C49& \"- \" & 'InfoBase 6B2a'!D63","v":"Puno- EMUSAP ABANCAY S.A. "},{"$f":"'InfoProc 6B2a'!F49","v":184.58977702808716},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,3368763.4307625904,0,null,{"$f":"'InfoProc 6B2a'!E49","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,{"$f":"M55","v":0},0]
[null,{"$f":"'InfoProc 6B2a'!C50& \"- \" & 'InfoBase 6B2a'!D64","v":"Puno- EMSAP CHANKA S.R.L."},{"$f":"'InfoProc 6B2a'!F50","v":18.258119442691502},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,333210.67982911994,0,null,{"$f":"'InfoProc 6B2a'!E50","v":0.24309999999999998},{"$f":"'FE 6B2'!C4","v":0.8},0.19447999999999999,{"$f":"'FE 6B2'!C9","v":0.6},0.11668799999999999,38881.687807900344,{"$f":"M56","v":0.11668799999999999},3.8881571119900343E-2]
[null,{"$f":"'InfoProc 6B2a'!C51& \"- \" & 'InfoBase 6B2a'!D65","v":"San Martín- EPS MARAÑON S.R.L.                 "},{"$f":"'InfoProc 6B2a'!F51","v":134.32189169976672},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,2451374.5235207425,0,null,{"$f":"'InfoProc 6B2a'!E51","v":4.24E-2},{"$f":"'FE 6B2'!C4","v":0.8},3.3919999999999999E-2,{"$f":"'FE 6B2'!C9","v":0.6},2.0351999999999999E-2,49890.374302694152,{"$f":"M57","v":2.0351999999999999E-2},4.9890353950694154E-2]
[null,{"$f":"'InfoProc 6B2a'!C52& \"- \" & 'InfoBase 6B2a'!D66","v":"San Martín- SEDAM HUANCAYO S.A.C."},{"$f":"'InfoProc 6B2a'!F52","v":39.337000000000003},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,717900.25000000012,0,null,{"$f":"'InfoProc 6B2a'!E52","v":0.21489999999999998},{"$f":"'FE 6B2'!C4","v":0.8},0.17191999999999999,{"$f":"'FE 6B2'!C9","v":0.6},0.10315199999999999,74052.846588,{"$f":"M58","v":0.10315199999999999},7.4052743436000004E-2]
[null,{"$f":"'InfoProc 6B2a'!C53& \"- \" & 'InfoBase 6B2a'!D67","v":"San Martín- EMSAPA CALCA S.R.L."},{"$f":"'InfoProc 6B2a'!F53","v":763.67595537702186},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,13937086.185630649,0,null,{"$f":"'InfoProc 6B2a'!E53","v":0.15039999999999998},{"$f":"'FE 6B2'!C4","v":0.8},0.12031999999999998,{"$f":"'FE 6B2'!C9","v":0.6},7.2191999999999992E-2,1006146.1259130477,{"$f":"M59","v":7.2191999999999992E-2},1.0061460537210476]
[null,{"$f":"'InfoProc 6B2a'!C54& \"- \" & 'InfoBase 6B2a'!D68","v":"Tacna- EPS AGUAS DEL ALTIPLANO"},{"$f":"'InfoProc 6B2a'!F54","v":243.29471920909185},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,4440128.6255659265,0,null,{"$f":"'InfoProc 6B2a'!E54","v":0.87870000000000004},{"$f":"'FE 6B2'!C4","v":0.8},0.70296000000000003,{"$f":"'FE 6B2'!C9","v":0.6},0.42177599999999998,1872739.6911766941,{"$f":"M60","v":0.42177599999999998},1.8727392694006941]
[null,{"$f":"'InfoProc 6B2a'!C55& \"- \" & 'InfoBase 6B2a'!D69","v":"Tumbes- EMSAPA YAULI S.RL.L."},{"$f":"'InfoProc 6B2a'!F55","v":92.724237790607475},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,1692217.3396785865,0,null,{"$f":"'InfoProc 6B2a'!E55","v":0.29469999999999996},{"$f":"'FE 6B2'!C4","v":0.8},0.23575999999999997,{"$f":"'FE 6B2'!C9","v":0.6},0.14145599999999997,239374.29600157408,{"$f":"M61","v":0.14145599999999997},0.23937415454557406]
[null,{"$f":"'InfoProc 6B2a'!C56& \"- \" & 'InfoBase 6B2a'!D70","v":"Ucayali- SEDAPAR S.R.L. (Rioja)"},{"$f":"'InfoProc 6B2a'!F56","v":111.12457691687338},{"$f":"'InfoProc 6B2a'!$C$92","v":18250},0,2028023.5287329392,0,null,{"$f":"'InfoProc 6B2a'!E56","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},{"$f":"K62*L62","v":0},0,{"$f":"M62","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P13:P62)","v":40.595527942546596}]

{"sheet":"Emisiones GEI 6B2b","index":9,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9],[3,2,3,3],[4,2,4,3],[5,2,5,3]]}
[]
[null,"Estimación de óxido nitroso generado por excretas humanas"]
[]
[null,"Sector","Desechos"]
[null,"Categoría","Aguas residuales domésticas"]
[null,"Código de categoría","6B2b"]
[]
[]
[]
[null,null,"A","B","C","D","E","F","G","H"]
[null,null,"Consumo per-cápita de proteínas \n(Kg proteína/persona/año)","Población (número)","Fracción de Nitrógeno en la proteína \n(Kg N/Kg proteína)","Cantidad de N en las excretas producidas \n(Kg N/año)","Cantidad de N en la orina \n(Kg N/año)","Cantidad neta de N en la orina producida \n(Kg N/año)","Factor de Emisión \n(Kg N2O-N/Kg N en el excremento producido)","Total Anual de Emisiones de N2O \n(Gg N2O/año)"]
[]
[null,null,null,null,null,"D = A x B x C",null,"F = D - E",null,"H = (F x G) x  (44/28) / 1 000 000"]
[null,"Total ",{"$f":"'InfoBase 6B2b'!D17/'Prop. y Fact. de conversión'!C17*365","v":24.455000000000002},{"$f":"'InfoBase 6B2b(población)'!D18","v":29461933},{"$f":"'FE 6B2'!C14","v":0.16},{"$f":"C14*D14*E14","v":115278651.44240002},0,{"$f":"F14-G14","v":115278651.44240002},{"$f":"'FE 6B2'!C19","v":0.01},{"$f":"(H14*I14)*(44/28)/1000000","v":1.8115216655234287}]

{"sheet":"Resultados INGEI","index":10,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
[null,"Inventario de emisiones de gases de efecto invernadero para sector Desechos - 2010"]
[]
[null,"Código de categorías de fuentes 1996*",null,null,null,"Categorías de fuentes y sumideros","Dióxido de carbono\n[GgCO2]","Metano\n[MgCH4]","Óxido nitroso\n[MgN2O]","Emisiones de GEI\n[GgCO2e]"]
[null,6,null,null,null,"Desechos",{"$f":"G6+G8","v":0},{"$f":"H6+H8","v":40595.5279425466},1811.5216655234287,{"$f":"J6+J8","v":1414.0778}]
[null,null,"6A",null,null,"Disposición de residuos sólidos",{"$f":"SUM(G7)","v":0}]
[null,null,null,"6A1",null,"Residuos sólidos"]
[null,null,"6B",null,null,"Tratamiento de aguas residuales",{"$f":"SUM(G9:G10)","v":0},{"$f":"SUM(H9:H10)","v":40595.5279425466},{"$f":"SUM(I9:I10)","v":1811.5216655234287},{"$f":"SUM(J9:J10)","v":1414.0778}]
[null,null,null,"6B1",null,"Efluentes industriales"]
[null,null,null,"6B2",null,"Tratamiento y eliminación de aguas residuales domésticas",{"$f":"SUM(G11:G12)","v":0},{"$f":"SUM(H11:H12)","v":40595.5279425466},1811.5216655234287,1414.0778]
[null,null,null,null,"6B2a","Aguas residuales domésticas",0,{"$f":"'Emisiones GEI 6B2a'!P63*1000","v":40595.5279425466},0,{"$f":"ROUND(G11+H11*21/1000+I11*310/1000,4)","v":852.50609999999995}]
[null,null,null,null,"6B2b","Excretas humanas",0,0,{"$f":"'Emisiones GEI 6B2b'!J14*1000","v":1811.5216655234287},561.57169999999996]
[null,"* Han sido creadas para el INGEI 6A1, 6B2a y 6B2b (ver hoja de caracterización)"]