{"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":24,"macros":1,"external_links":0,"defined_names":1,"comments":4,"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":73,"n_cols":9,"rows_kept":73,"cut":false,"hidden":false,"merged":[[65,1,65,17],[24,5,24,17],[25,5,26,17],[27,5,27,17],[30,1,30,17],[33,2,33,8],[34,2,34,8],[35,2,35,8],[36,2,36,8],[37,2,37,8],[38,2,38,8],[39,2,39,8],[11,1,11,6],[1,1,1,17],[2,1,2,17],[14,1,14,17],[5,1,5,17],[7,1,7,17],[8,1,9,13]]}
[]
[null,"REPORTE ANUAL DE GASES DE EFECTO INVERNADERO "]
[null,"Sector Desechos"]
[null,null,null,null,null,null,null,null,"Tratamiento y eliminación de aguas residuales domésticas"]
[]
[null,"INSTRUCCIONES "]
[]
[null,"ALCANCE"]
[null,"El 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 fuente"]
[null,null,"Resultados GEI para Tratamiento y eliminación de aguas residuales domésticas"]
[]
[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":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[10,4,12,4],[10,3,12,3],[10,2,12,2],[10,10,11,10],[1,1,1,14],[6,1,6,4],[10,14,11,14],[13,1,14,1],[10,1,12,1],[13,11,14,11],[13,12,14,12],[10,11,12,11],[10,6,12,6],[10,5,12,5],[10,12,12,12],[13,5,14,5],[13,4,14,4],[13,3,14,3],[13,6,14,6],[13,2,14,2]]}
[]
[null,"Caracterización de Datos - Sector Desechos (Tratamiento y eliminación de aguas residuales domésticas)"]
[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 servida con 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,"Tratamiento de aguas residuales","%",1]
[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. \nLas unidades originales deben ser: g/hab∙dia ",null,null,null,"Prop. y Fact. de conversión\n"]
[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,"Instituto Nacional de Salud",null,null,null,"InfoBase 6B2b"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"g/hab∙día"]

{"sheet":"InfoBase 6B2a","index":2,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":false,"merged":[[9,3,9,4],[9,6,9,7],[10,2,10,8],[12,1,13,1],[15,3,16,3],[15,1,16,1],[15,5,16,5],[15,2,16,2],[15,4,16,4],[1,1,1,8],[3,1,3,8],[4,2,4,8],[5,2,5,8],[6,1,8,1],[6,3,6,8],[7,3,7,8],[8,3,8,8]]}
[]
[null,"Información Básica: Tratamiento de aguas residuales y población servida con alcantarillado"]
[null,null,null,null,null,null,null,null,null,null,"Relación de esta hoja, con otras:"]
[null,"DATOS DE LA INFORMACIÓN BASE"]
[null,"Código","6B2"]
[null,"Subcodigo ","6B2a"]
[null,"Información ","Nivel de actividad","Tratamiento de aguas residuales (%) y población servida con alcantarillado (población)"]
[null,null,"Documento",null,null,null,null,null,null,null,null,"Llenar información en estas celdas"]
[null,null,"Título "]
[null,"Ubicación especifica","Pagina",null,null,"Cuadro",null,null,"Anexo "]
[null,"Vínculo"]
[null,"Institución informante:"]
[null,"Dirección de línea:\nEntidad:"]
[]
[]
[null,"Código","Región","Empresa Prestadora de Servicio","Tratamiento de aguas residuales \n(%)","Población servida con alcantarillado\n(habitantes)"]
[]
[null,1,"Amazonas","EMUSAP Amazonas"]
[null,7,"Amazonas","EPSSMU S.R.Ltda."]
[null,35,"Amazonas","EMAPAB S.R.LTDA. "]
[null,14,"Áncash","SEDACHIMBOTE S.A."]
[null,33,"Áncash","EPS CHAVIN S.A."]
[null,43,"Apurímac","EMUSAP ABANCAY S.A. "]
[null,44,"Apurímac","EMSAP CHANKA S.R.L."]
[null,51,"Arequipa","SEDAPAR S.R.L. (Rioja)"]
[null,15,"Ayacucho","EPSASA"]
[null,11,"Cajamarca","SEDACAJ S.A."]
[null,45,"Cajamarca","EPS MARAÑON S.R.L.                 "]
[null,9,"Cerro de Pasco","EMAPA Pasco S.A."]
[null,31,"Cusco","SEDACUSCO S.A. "]
[null,34,"Cusco","EMAQ S.R.LTDA."]
[null,38,"Cusco","EMPSSAPAL S.A."]
[null,47,"Cusco","EMSAPA CALCA S.R.L."]
[null,21,"Huancavelica","EMAPA HUANCAVELICA S.A.C "]
[null,2,"Huánuco","SEDA Huánuco S.A."]
[null,10,"Ica","EMAPISCO S.A."]
[null,13,"Ica","EMAPAVIGS S.A.C."]
[null,18,"Ica","SEMAPACH S.A."]
[null,37,"Ica","EMAPICA S.A.               "]
[null,19,"Junín","EPS Selva Central S.A."]
[null,39,"Junín","EPS SIERRA CENTRAL S.R.L."]
[null,42,"Junín","EPS MANTARO S.A."]
[null,46,"Junín","SEDAM HUANCAYO S.A.C."]
[null,50,"Junín","EMSAPA YAULI S.RL.L."]
[null,28,"La Libertad","SEDALIB S.A."]
[null,29,"Lambayeque","EPSEL S.A."]
[null,5,"Lima","EMAPA Cañete S.A."]
[null,24,"Lima","EMAPA HUARAL S.A."]
[null,25,"Lima","EMAPA HUACHO S.A."]
[null,26,"Lima","SEDAPAL S.A."]
[null,36,"Lima","SEMAPA BARRANCA S.A.               "]
[null,4,"Loreto","EPS SEDALORETO S.A."]
[null,17,"Madre de Dios","EMAPAT S.R.Ltda."]
[null,22,"Moquegua","EPS MOQUEGUA S.A."]
[null,27,"Moquegua","EPS ILO S.A."]
[null,32,"Piura","EPS GRAU S.A."]
[null,6,"Puno","EMSA Puno S.A."]
[null,23,"Puno","EMAPA Y S.R.L."]
[null,40,"Puno","EPS NOR PUNO S.A."]
[null,41,"Puno","SEDAJULIACA S.A."]
[null,48,"Puno","EPS AGUAS DEL ALTIPLANO"]
[null,16,"San Martín","EMAPA San Martín S.A."]
[null,20,"San Martín","EMAPA MOYOBAMBA S.R.LTDA. "]
[null,30,"San Martín","SEDAPAR S.A."]
[null,12,"Tacna","EPS TACNA S.A."]
[null,8,"Tumbes","Aguas de Tumbes"]
[null,3,"Ucayali","EMAPACOP S.A."]

{"sheet":"InfoBase 6B2b (población)","index":3,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[13,1,14,1],[10,1,11,1],[9,3,9,4],[9,6,9,7],[10,2,10,9],[11,2,11,9],[1,1,1,9],[3,1,3,9],[4,2,4,9],[5,2,5,9],[6,1,8,1],[6,3,6,9],[7,3,7,9],[8,3,8,9]]}
[]
[null,"Información Básica: Población nacional"]
[]
[null,"DATOS DE LA INFORMACIÓN BASE"]
[null,"Código","6B2"]
[null,"Subcodigo ","6B2b"]
[null,"Información ","Nivel de actividad","Población nacional del Perú"]
[null,null,"Documento"]
[null,null,"Título "]
[null,"Ubicación especifica","Pagina",null,null,"Cuadro",null,null,"Anexo "]
[null,"Vínculo"]
[]
[null,"Institución informante:"]
[null,"Dirección de línea:\nEntidad:"]
[]
[]
[]
[null,null,"Población total oficial del Perú:",null,null,null,null,"Relación de esta hoja, con otras:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Llenar información en estas celdas"]

{"sheet":"InfoBase 6B2b","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,9],[3,1,3,9],[4,2,4,9],[5,2,5,9],[6,1,8,1],[6,3,6,9],[7,3,7,9],[8,3,8,9],[16,1,16,2],[9,3,9,4],[9,6,9,7],[10,2,10,9],[10,1,11,1],[11,2,11,9],[13,1,14,1]]}
[]
[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"]
[null,null,"Título "]
[null,"Ubicación especifica","Pagina",null,null,"Cuadro",null,null,"Anexo "]
[null,"Vínculo"]
[]
[null,"Institución informante:"]
[null,"Dirección de línea:\nEntidad:"]
[]
[]
[null,"Porcentaje de proteínas",null,null,"g/persona·día",null,"Relación de esta hoja, con otras:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Llenar información en estas celdas"]

{"sheet":"InfoProc 6B2a","index":5,"n_rows":124,"n_cols":8,"rows_kept":124,"cut":false,"hidden":false,"merged":[[3,5,4,5],[3,4,4,4],[1,1,1,5],[3,1,4,1],[3,2,4,2],[3,3,4,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 \n[miles]"]
[]
[null,{"$f":"'InfoBase 6B2a'!B18","v":1},{"$f":"'InfoBase 6B2a'!C18","v":"Amazonas"},{"$f":"'InfoBase 6B2a'!D18","v":"EMUSAP Amazonas"},{"$f":"VLOOKUP(D6,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D6,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B19","v":7},{"$f":"'InfoBase 6B2a'!C19","v":"Amazonas"},{"$f":"'InfoBase 6B2a'!D19","v":"EPSSMU S.R.Ltda."},{"$f":"VLOOKUP(D7,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D7,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B20","v":35},{"$f":"'InfoBase 6B2a'!C20","v":"Amazonas"},{"$f":"'InfoBase 6B2a'!D20","v":"EMAPAB S.R.LTDA. "},{"$f":"VLOOKUP(D8,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D8,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B21","v":14},{"$f":"'InfoBase 6B2a'!C21","v":"Áncash"},{"$f":"'InfoBase 6B2a'!D21","v":"SEDACHIMBOTE S.A."},{"$f":"VLOOKUP(D9,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D9,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B22","v":33},{"$f":"'InfoBase 6B2a'!C22","v":"Áncash"},{"$f":"'InfoBase 6B2a'!D22","v":"EPS CHAVIN S.A."},{"$f":"VLOOKUP(D10,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D10,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B23","v":43},{"$f":"'InfoBase 6B2a'!C23","v":"Apurímac"},{"$f":"'InfoBase 6B2a'!D23","v":"EMUSAP ABANCAY S.A. "},{"$f":"VLOOKUP(D11,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D11,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B24","v":44},{"$f":"'InfoBase 6B2a'!C24","v":"Apurímac"},{"$f":"'InfoBase 6B2a'!D24","v":"EMSAP CHANKA S.R.L."},{"$f":"VLOOKUP(D12,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D12,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B25","v":51},{"$f":"'InfoBase 6B2a'!C25","v":"Arequipa"},{"$f":"'InfoBase 6B2a'!D25","v":"SEDAPAR S.R.L. (Rioja)"},{"$f":"VLOOKUP(D13,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D13,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B26","v":15},{"$f":"'InfoBase 6B2a'!C26","v":"Ayacucho"},{"$f":"'InfoBase 6B2a'!D26","v":"EPSASA"},{"$f":"VLOOKUP(D14,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D14,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B27","v":11},{"$f":"'InfoBase 6B2a'!C27","v":"Cajamarca"},{"$f":"'InfoBase 6B2a'!D27","v":"SEDACAJ S.A."},{"$f":"VLOOKUP(D15,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D15,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B28","v":45},{"$f":"'InfoBase 6B2a'!C28","v":"Cajamarca"},{"$f":"'InfoBase 6B2a'!D28","v":"EPS MARAÑON S.R.L.                 "},{"$f":"VLOOKUP(D16,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D16,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[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(D17,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D17,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B30","v":31},{"$f":"'InfoBase 6B2a'!C30","v":"Cusco"},{"$f":"'InfoBase 6B2a'!D30","v":"SEDACUSCO S.A. "},{"$f":"VLOOKUP(D18,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D18,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B31","v":34},{"$f":"'InfoBase 6B2a'!C31","v":"Cusco"},{"$f":"'InfoBase 6B2a'!D31","v":"EMAQ S.R.LTDA."},{"$f":"VLOOKUP(D19,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D19,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B32","v":38},{"$f":"'InfoBase 6B2a'!C32","v":"Cusco"},{"$f":"'InfoBase 6B2a'!D32","v":"EMPSSAPAL S.A."},{"$f":"VLOOKUP(D20,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D20,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B33","v":47},{"$f":"'InfoBase 6B2a'!C33","v":"Cusco"},{"$f":"'InfoBase 6B2a'!D33","v":"EMSAPA CALCA S.R.L."},{"$f":"VLOOKUP(D21,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D21,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B34","v":21},{"$f":"'InfoBase 6B2a'!C34","v":"Huancavelica"},{"$f":"'InfoBase 6B2a'!D34","v":"EMAPA HUANCAVELICA S.A.C "},{"$f":"VLOOKUP(D22,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D22,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B35","v":2},{"$f":"'InfoBase 6B2a'!C35","v":"Huánuco"},{"$f":"'InfoBase 6B2a'!D35","v":"SEDA Huánuco S.A."},{"$f":"VLOOKUP(D23,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D23,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B36","v":10},{"$f":"'InfoBase 6B2a'!C36","v":"Ica"},{"$f":"'InfoBase 6B2a'!D36","v":"EMAPISCO S.A."},{"$f":"VLOOKUP(D24,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D24,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B37","v":13},{"$f":"'InfoBase 6B2a'!C37","v":"Ica"},{"$f":"'InfoBase 6B2a'!D37","v":"EMAPAVIGS S.A.C."},{"$f":"VLOOKUP(D25,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D25,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B38","v":18},{"$f":"'InfoBase 6B2a'!C38","v":"Ica"},{"$f":"'InfoBase 6B2a'!D38","v":"SEMAPACH S.A."},{"$f":"VLOOKUP(D26,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D26,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B39","v":37},{"$f":"'InfoBase 6B2a'!C39","v":"Ica"},{"$f":"'InfoBase 6B2a'!D39","v":"EMAPICA S.A.               "},{"$f":"VLOOKUP(D27,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D27,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B40","v":19},{"$f":"'InfoBase 6B2a'!C40","v":"Junín"},{"$f":"'InfoBase 6B2a'!D40","v":"EPS Selva Central S.A."},{"$f":"VLOOKUP(D28,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D28,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B41","v":39},{"$f":"'InfoBase 6B2a'!C41","v":"Junín"},{"$f":"'InfoBase 6B2a'!D41","v":"EPS SIERRA CENTRAL S.R.L."},{"$f":"VLOOKUP(D29,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D29,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B42","v":42},{"$f":"'InfoBase 6B2a'!C42","v":"Junín"},{"$f":"'InfoBase 6B2a'!D42","v":"EPS MANTARO S.A."},{"$f":"VLOOKUP(D30,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D30,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B43","v":46},{"$f":"'InfoBase 6B2a'!C43","v":"Junín"},{"$f":"'InfoBase 6B2a'!D43","v":"SEDAM HUANCAYO S.A.C."},{"$f":"VLOOKUP(D31,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D31,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B44","v":50},{"$f":"'InfoBase 6B2a'!C44","v":"Junín"},{"$f":"'InfoBase 6B2a'!D44","v":"EMSAPA YAULI S.RL.L."},{"$f":"VLOOKUP(D32,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D32,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B45","v":28},{"$f":"'InfoBase 6B2a'!C45","v":"La Libertad"},{"$f":"'InfoBase 6B2a'!D45","v":"SEDALIB S.A."},{"$f":"VLOOKUP(D33,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D33,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B46","v":29},{"$f":"'InfoBase 6B2a'!C46","v":"Lambayeque"},{"$f":"'InfoBase 6B2a'!D46","v":"EPSEL S.A."},{"$f":"VLOOKUP(D34,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D34,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B47","v":5},{"$f":"'InfoBase 6B2a'!C47","v":"Lima"},{"$f":"'InfoBase 6B2a'!D47","v":"EMAPA Cañete S.A."},{"$f":"VLOOKUP(D35,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D35,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B48","v":24},{"$f":"'InfoBase 6B2a'!C48","v":"Lima"},{"$f":"'InfoBase 6B2a'!D48","v":"EMAPA HUARAL S.A."},{"$f":"VLOOKUP(D36,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D36,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B49","v":25},{"$f":"'InfoBase 6B2a'!C49","v":"Lima"},{"$f":"'InfoBase 6B2a'!D49","v":"EMAPA HUACHO S.A."},{"$f":"VLOOKUP(D37,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D37,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B50","v":26},{"$f":"'InfoBase 6B2a'!C50","v":"Lima"},{"$f":"'InfoBase 6B2a'!D50","v":"SEDAPAL S.A."},{"$f":"VLOOKUP(D38,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D38,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B51","v":36},{"$f":"'InfoBase 6B2a'!C51","v":"Lima"},{"$f":"'InfoBase 6B2a'!D51","v":"SEMAPA BARRANCA S.A.               "},{"$f":"VLOOKUP(D39,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D39,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B52","v":4},{"$f":"'InfoBase 6B2a'!C52","v":"Loreto"},{"$f":"'InfoBase 6B2a'!D52","v":"EPS SEDALORETO S.A."},{"$f":"VLOOKUP(D40,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D40,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B53","v":17},{"$f":"'InfoBase 6B2a'!C53","v":"Madre de Dios"},{"$f":"'InfoBase 6B2a'!D53","v":"EMAPAT S.R.Ltda."},{"$f":"VLOOKUP(D41,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D41,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B54","v":22},{"$f":"'InfoBase 6B2a'!C54","v":"Moquegua"},{"$f":"'InfoBase 6B2a'!D54","v":"EPS MOQUEGUA S.A."},{"$f":"VLOOKUP(D42,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D42,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B55","v":27},{"$f":"'InfoBase 6B2a'!C55","v":"Moquegua"},{"$f":"'InfoBase 6B2a'!D55","v":"EPS ILO S.A."},{"$f":"VLOOKUP(D43,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D43,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B56","v":32},{"$f":"'InfoBase 6B2a'!C56","v":"Piura"},{"$f":"'InfoBase 6B2a'!D56","v":"EPS GRAU S.A."},{"$f":"VLOOKUP(D44,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D44,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B57","v":6},{"$f":"'InfoBase 6B2a'!C57","v":"Puno"},{"$f":"'InfoBase 6B2a'!D57","v":"EMSA Puno S.A."},{"$f":"VLOOKUP(D45,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D45,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B58","v":23},{"$f":"'InfoBase 6B2a'!C58","v":"Puno"},{"$f":"'InfoBase 6B2a'!D58","v":"EMAPA Y S.R.L."},{"$f":"VLOOKUP(D46,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D46,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B59","v":40},{"$f":"'InfoBase 6B2a'!C59","v":"Puno"},{"$f":"'InfoBase 6B2a'!D59","v":"EPS NOR PUNO S.A."},{"$f":"VLOOKUP(D47,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D47,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B60","v":41},{"$f":"'InfoBase 6B2a'!C60","v":"Puno"},{"$f":"'InfoBase 6B2a'!D60","v":"SEDAJULIACA S.A."},{"$f":"VLOOKUP(D48,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D48,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B61","v":48},{"$f":"'InfoBase 6B2a'!C61","v":"Puno"},{"$f":"'InfoBase 6B2a'!D61","v":"EPS AGUAS DEL ALTIPLANO"},{"$f":"VLOOKUP(D49,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D49,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B62","v":16},{"$f":"'InfoBase 6B2a'!C62","v":"San Martín"},{"$f":"'InfoBase 6B2a'!D62","v":"EMAPA San Martín S.A."},{"$f":"VLOOKUP(D50,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D50,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B63","v":20},{"$f":"'InfoBase 6B2a'!C63","v":"San Martín"},{"$f":"'InfoBase 6B2a'!D63","v":"EMAPA MOYOBAMBA S.R.LTDA. "},{"$f":"VLOOKUP(D51,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D51,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B64","v":30},{"$f":"'InfoBase 6B2a'!C64","v":"San Martín"},{"$f":"'InfoBase 6B2a'!D64","v":"SEDAPAR S.A."},{"$f":"VLOOKUP(D52,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D52,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B65","v":12},{"$f":"'InfoBase 6B2a'!C65","v":"Tacna"},{"$f":"'InfoBase 6B2a'!D65","v":"EPS TACNA S.A."},{"$f":"VLOOKUP(D53,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D53,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B66","v":8},{"$f":"'InfoBase 6B2a'!C66","v":"Tumbes"},{"$f":"'InfoBase 6B2a'!D66","v":"Aguas de Tumbes"},{"$f":"VLOOKUP(D54,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D54,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[null,{"$f":"'InfoBase 6B2a'!B67","v":3},{"$f":"'InfoBase 6B2a'!C67","v":"Ucayali"},{"$f":"'InfoBase 6B2a'!D67","v":"EMAPACOP S.A."},{"$f":"VLOOKUP(D55,'InfoBase 6B2a'!$D$18:$F$67,2,FALSE)","v":0},{"$f":"VLOOKUP(D55,'InfoBase 6B2a'!$D$18:$F$67,3,FALSE)/1000","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"AVERAGE('InfoBase 6B2a'!#REF!)","v":{"$error":"#REF!"}},{"$f":"AVERAGE('InfoBase 6B2a'!E18:E67)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Prop. y Fact. de conversión","index":6,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[33,1,34,1],[1,1,1,3],[12,1,12,3],[10,1,10,3],[31,1,31,3],[24,1,25,3],[27,1,27,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,"Relación CH4/C",{"$f":"(C4+C5*4)/C4","v":1.3333333333333333}]
[null,"Fuente: Tabla periódica de los elementos"]
[]
[null,"Conversión de unidades"]
[]
[null,"Masa"]
[null,"1 tonelada",1000,"kg"]
[null,"1 kilogramo",1000,"g"]
[null,"1 tonelada",{"$f":"C14*C15","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,null,{"$f":"C34*365/C15*1000","v":18250},"kg/1000 personas.año"]
[null,"Reglamento Nacional de Edificaciones – Norma OS.090: Plantas de Tratamiento de Aguas Residuales."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":65,"n_cols":16,"rows_kept":65,"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","Fracción real de metano","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'!C6& \"- \" & 'InfoBase 6B2a'!D18","v":"Amazonas- EMUSAP Amazonas"},{"$f":"'InfoProc 6B2a'!F6","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,{"$f":"(C15*D15*(1-E15))","v":0},{"$f":"C15*D15*E15","v":0},null,{"$f":"'InfoProc 6B2a'!E6","v":0},{"$f":"'FE 6B2'!C4","v":0.8},{"$f":"I15*J15","v":0},{"$f":"'FE 6B2'!C9","v":0.6},{"$f":"K15*L15","v":0},{"$f":"F15*M15","v":0},null,{"$f":"(N15-O15)/1000000","v":0}]
[null,{"$f":"'InfoProc 6B2a'!C7& \"- \" & 'InfoBase 6B2a'!D19","v":"Amazonas- EPSSMU S.R.Ltda."},{"$f":"'InfoProc 6B2a'!F7","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,{"$f":"(C16*D16*(1-E16))","v":0},{"$f":"C16*D16*E16","v":0},null,{"$f":"'InfoProc 6B2a'!E7","v":0},{"$f":"'FE 6B2'!C4","v":0.8},{"$f":"I16*J16","v":0},{"$f":"'FE 6B2'!C9","v":0.6},{"$f":"K16*L16","v":0},0,null,{"$f":"(N16-O16)/1000000","v":0}]
[null,{"$f":"'InfoProc 6B2a'!C8& \"- \" & 'InfoBase 6B2a'!D20","v":"Amazonas- EMAPAB S.R.LTDA. "},{"$f":"'InfoProc 6B2a'!F8","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E8","v":0},{"$f":"'FE 6B2'!C4","v":0.8},{"$f":"I17*J17","v":0},{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C9& \"- \" & 'InfoBase 6B2a'!D21","v":"Áncash- SEDACHIMBOTE S.A."},{"$f":"'InfoProc 6B2a'!F9","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,{"$f":"(C18*D18*(1-E18))","v":0},{"$f":"C18*D18*E18","v":0},null,{"$f":"'InfoProc 6B2a'!E9","v":0},{"$f":"'FE 6B2'!C4","v":0.8},{"$f":"I18*J18","v":0},{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C10& \"- \" & 'InfoBase 6B2a'!D22","v":"Áncash- EPS CHAVIN S.A."},{"$f":"'InfoProc 6B2a'!F10","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E10","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C11& \"- \" & 'InfoBase 6B2a'!D23","v":"Apurímac- EMUSAP ABANCAY S.A. "},{"$f":"'InfoProc 6B2a'!F11","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C12& \"- \" & 'InfoBase 6B2a'!D24","v":"Apurímac- EMSAP CHANKA S.R.L."},{"$f":"'InfoProc 6B2a'!F12","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C13& \"- \" & 'InfoBase 6B2a'!D25","v":"Arequipa- SEDAPAR S.R.L. (Rioja)"},{"$f":"'InfoProc 6B2a'!F13","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C14& \"- \" & 'InfoBase 6B2a'!D26","v":"Ayacucho- EPSASA"},{"$f":"'InfoProc 6B2a'!F14","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C15& \"- \" & 'InfoBase 6B2a'!D27","v":"Cajamarca- SEDACAJ S.A."},{"$f":"'InfoProc 6B2a'!F15","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E15","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C16& \"- \" & 'InfoBase 6B2a'!D28","v":"Cajamarca- EPS MARAÑON S.R.L.                 "},{"$f":"'InfoProc 6B2a'!F16","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E16","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C17& \"- \" & 'InfoBase 6B2a'!D29","v":"Cerro de Pasco- EMAPA Pasco S.A."},{"$f":"'InfoProc 6B2a'!F17","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E17","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C18& \"- \" & 'InfoBase 6B2a'!D30","v":"Cusco- SEDACUSCO S.A. "},{"$f":"'InfoProc 6B2a'!F18","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C19& \"- \" & 'InfoBase 6B2a'!D31","v":"Cusco- EMAQ S.R.LTDA."},{"$f":"'InfoProc 6B2a'!F19","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E19","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C20& \"- \" & 'InfoBase 6B2a'!D32","v":"Cusco- EMPSSAPAL S.A."},{"$f":"'InfoProc 6B2a'!F20","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C21& \"- \" & 'InfoBase 6B2a'!D33","v":"Cusco- EMSAPA CALCA S.R.L."},{"$f":"'InfoProc 6B2a'!F21","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C22& \"- \" & 'InfoBase 6B2a'!D34","v":"Huancavelica- EMAPA HUANCAVELICA S.A.C "},{"$f":"'InfoProc 6B2a'!F22","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C23& \"- \" & 'InfoBase 6B2a'!D35","v":"Huánuco- SEDA Huánuco S.A."},{"$f":"'InfoProc 6B2a'!F23","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C24& \"- \" & 'InfoBase 6B2a'!D36","v":"Ica- EMAPISCO S.A."},{"$f":"'InfoProc 6B2a'!F24","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C25& \"- \" & 'InfoBase 6B2a'!D37","v":"Ica- EMAPAVIGS S.A.C."},{"$f":"'InfoProc 6B2a'!F25","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E25","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C26& \"- \" & 'InfoBase 6B2a'!D38","v":"Ica- SEMAPACH S.A."},{"$f":"'InfoProc 6B2a'!F26","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E26","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C27& \"- \" & 'InfoBase 6B2a'!D39","v":"Ica- EMAPICA S.A.               "},{"$f":"'InfoProc 6B2a'!F27","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E27","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C28& \"- \" & 'InfoBase 6B2a'!D40","v":"Junín- EPS Selva Central S.A."},{"$f":"'InfoProc 6B2a'!F28","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E28","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C29& \"- \" & 'InfoBase 6B2a'!D41","v":"Junín- EPS SIERRA CENTRAL S.R.L."},{"$f":"'InfoProc 6B2a'!F29","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E29","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C30& \"- \" & 'InfoBase 6B2a'!D42","v":"Junín- EPS MANTARO S.A."},{"$f":"'InfoProc 6B2a'!F30","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C31& \"- \" & 'InfoBase 6B2a'!D43","v":"Junín- SEDAM HUANCAYO S.A.C."},{"$f":"'InfoProc 6B2a'!F31","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E31","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C32& \"- \" & 'InfoBase 6B2a'!D44","v":"Junín- EMSAPA YAULI S.RL.L."},{"$f":"'InfoProc 6B2a'!F32","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C33& \"- \" & 'InfoBase 6B2a'!D45","v":"La Libertad- SEDALIB S.A."},{"$f":"'InfoProc 6B2a'!F33","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C34& \"- \" & 'InfoBase 6B2a'!D46","v":"Lambayeque- EPSEL S.A."},{"$f":"'InfoProc 6B2a'!F34","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E34","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C35& \"- \" & 'InfoBase 6B2a'!D47","v":"Lima- EMAPA Cañete S.A."},{"$f":"'InfoProc 6B2a'!F35","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E35","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,{"$f":"(N44-O44)/1000000","v":0}]
[null,{"$f":"'InfoProc 6B2a'!C36& \"- \" & 'InfoBase 6B2a'!D48","v":"Lima- EMAPA HUARAL S.A."},{"$f":"'InfoProc 6B2a'!F36","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E36","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C37& \"- \" & 'InfoBase 6B2a'!D49","v":"Lima- EMAPA HUACHO S.A."},{"$f":"'InfoProc 6B2a'!F37","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C38& \"- \" & 'InfoBase 6B2a'!D50","v":"Lima- SEDAPAL S.A."},{"$f":"'InfoProc 6B2a'!F38","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E38","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,{"$f":"F47*M47","v":0},null,0]
[null,{"$f":"'InfoProc 6B2a'!C39& \"- \" & 'InfoBase 6B2a'!D51","v":"Lima- SEMAPA BARRANCA S.A.               "},{"$f":"'InfoProc 6B2a'!F39","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E39","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C40& \"- \" & 'InfoBase 6B2a'!D52","v":"Loreto- EPS SEDALORETO S.A."},{"$f":"'InfoProc 6B2a'!F40","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C41& \"- \" & 'InfoBase 6B2a'!D53","v":"Madre de Dios- EMAPAT S.R.Ltda."},{"$f":"'InfoProc 6B2a'!F41","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C42& \"- \" & 'InfoBase 6B2a'!D54","v":"Moquegua- EPS MOQUEGUA S.A."},{"$f":"'InfoProc 6B2a'!F42","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C43& \"- \" & 'InfoBase 6B2a'!D55","v":"Moquegua- EPS ILO S.A."},{"$f":"'InfoProc 6B2a'!F43","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E43","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C44& \"- \" & 'InfoBase 6B2a'!D56","v":"Piura- EPS GRAU S.A."},{"$f":"'InfoProc 6B2a'!F44","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E44","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C45& \"- \" & 'InfoBase 6B2a'!D57","v":"Puno- EMSA Puno S.A."},{"$f":"'InfoProc 6B2a'!F45","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E45","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C46& \"- \" & 'InfoBase 6B2a'!D58","v":"Puno- EMAPA Y S.R.L."},{"$f":"'InfoProc 6B2a'!F46","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E46","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C47& \"- \" & 'InfoBase 6B2a'!D59","v":"Puno- EPS NOR PUNO S.A."},{"$f":"'InfoProc 6B2a'!F47","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C48& \"- \" & 'InfoBase 6B2a'!D60","v":"Puno- SEDAJULIACA S.A."},{"$f":"'InfoProc 6B2a'!F48","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E48","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C49& \"- \" & 'InfoBase 6B2a'!D61","v":"Puno- EPS AGUAS DEL ALTIPLANO"},{"$f":"'InfoProc 6B2a'!F49","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,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,null,0]
[null,{"$f":"'InfoProc 6B2a'!C50& \"- \" & 'InfoBase 6B2a'!D62","v":"San Martín- EMAPA San Martín S.A."},{"$f":"'InfoProc 6B2a'!F50","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E50","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C51& \"- \" & 'InfoBase 6B2a'!D63","v":"San Martín- EMAPA MOYOBAMBA S.R.LTDA. "},{"$f":"'InfoProc 6B2a'!F51","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E51","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C52& \"- \" & 'InfoBase 6B2a'!D64","v":"San Martín- SEDAPAR S.A."},{"$f":"'InfoProc 6B2a'!F52","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E52","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C53& \"- \" & 'InfoBase 6B2a'!D65","v":"Tacna- EPS TACNA S.A."},{"$f":"'InfoProc 6B2a'!F53","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E53","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C54& \"- \" & 'InfoBase 6B2a'!D66","v":"Tumbes- Aguas de Tumbes"},{"$f":"'InfoProc 6B2a'!F54","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E54","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},0,0,null,0]
[null,{"$f":"'InfoProc 6B2a'!C55& \"- \" & 'InfoBase 6B2a'!D67","v":"Ucayali- EMAPACOP S.A."},{"$f":"'InfoProc 6B2a'!F55","v":0},{"$f":"'Prop. y Fact. de conversión'!$C$35","v":18250},0,0,0,null,{"$f":"'InfoProc 6B2a'!E55","v":0},{"$f":"'FE 6B2'!C4","v":0.8},0,{"$f":"'FE 6B2'!C9","v":0.6},{"$f":"K64*L64","v":0},0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(P15:P64)","v":0}]

{"sheet":"Emisiones GEI 6B2b","index":9,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,2,3,3],[4,2,4,3],[5,2,5,3],[7,1,8,1]]}
[]
[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,"Fuente de residuos sólidos","A","B","C","D","E","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)","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","E","H = (D x E) x  (44/28) / 1 000 000"]
[null,"Total Perú",{"$f":"'InfoBase 6B2b'!D17/'Prop. y Fact. de conversión'!C15*365","v":0},{"$f":"'InfoBase 6B2b (población)'!D18","v":0},{"$f":"'FE 6B2'!C14","v":0.16},{"$f":"C11*D11*E11","v":0},{"$f":"'FE 6B2'!C19","v":0.01},{"$f":"(F11*G11)*(44/28)/1000000","v":0}]

{"sheet":"Resultados INGEI","index":10,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
[null,"REPORTE ANUAL DE GASES DE EFECTO INVERNADERO - SECTOR DESECHOS  - TRATAMIENTO Y ELIMINACIÓN DE AGUAS RESIDUALES DOMÉSTICAS"]
[]
[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":0},0,{"$f":"J6+J8","v":0}]
[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":0},{"$f":"SUM(I9:I10)","v":0},{"$f":"SUM(J9:J10)","v":0}]
[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":0},0,0]
[null,null,null,null,"6B2a","Aguas residuales domésticas",0,{"$f":"'Emisiones GEI 6B2a'!P65*1000","v":0},0,{"$f":"ROUND(G11+H11*21/1000+I11*310/1000,4)","v":0}]
[null,null,null,null,"6B2b","Excretas humanas",0,0,{"$f":"'Emisiones GEI 6B2b'!H11*1000","v":0},0]