{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["INTRO","COUNTRY_INFO","MDA1","MDA2","MDA3","T1","T2","T3_R1","T3_R2","DISTRICT","SUMMARY","PROFILE"],"not_rendered":{"charts":8,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":11,"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":"INTRO","index":0,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,1,45,2],[10,2,10,4],[41,1,41,2],[43,1,43,2],[46,1,46,4],[33,1,33,2],[35,1,35,2],[26,2,27,4],[37,1,37,2],[39,1,39,2],[28,1,28,4],[29,2,29,4],[30,1,30,4],[31,1,31,4],[20,1,20,4],[21,2,21,4],[22,1,22,4],[23,2,24,4],[25,1,25,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,2,19,4],[9,2,9,4],[11,2,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[7,2,7,4],[8,2,8,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4]]}
[]
[null,"Formato de Reporte Conjunto para QP v.3"]
[]
[null,"El propósito de ésta plantilla en Excel, denominada Formato de Reporte Conjunto (Joint Reporting Form-JRF nombre en inglés), es proporcionar una herramienta estandarizada para las autoridades nacionales de salud y gestores de datos para hacer frente a los desafíos del reporte, facilitar la integración y contribuir aún más a la mejora de la gestión general del programa. Esta plantilla tiene como objetivo estandarizar los informes nacionales de los resultados de la ejecución del programa, mejorar la disponibilidad y la coordinación de los datos de quimioterapia preventiva-QP en todas las regiones de la OMS. Se solicita a las autoridades nacionales completar este formulario para ser enviado a la Organización Mundial de la Salud antes del 15 de agosto del año en curso para presentar datos sobre las intervenciones de QP implementadas durante el año anterior."]
[]
[null,"Estructura de la apliación (hojas de trabajo):"]
[]
[null,"INTRO","Esta hoja incluye instrucciones sobre cómo completar el formulario de reporte conjunto y la información sobre el estado de la QP para las enfermedades endémicas en el país"]
[null,"COUNTRY_INFO","Esta hoja incluye información sobre la estructura administrativa del país, la población por grupos de edad, el estado de endemicidad para cada enfermedad, la población que requiere QP, las intervenciones planeadas y las intervenciones realizadas"]
[null,"MDA1, MDA2, MDA3, T1, T2 and T3","Estas hojas incluyen información sobre los distritos endémicos focalizados para el tratamiento con medicamentos específicos para QP, plan de tratamiento y el número de personas que recibieron tratamiento por grupo de edad"]
[null,"DISTRICT","Esta hoja incluye el resumen de las personas tratadas por cada enfermedad al nivel de implementación definido. Si los datos por sexo estan disponibles, estos deben ser ingresados"]
[null,"SUMMARY","Esta hoja incluye el resumen de las personas tratadas por cada enfermedad y por tipo de intervención de QP. Antes de generar el informe (ejecutar macros), por favor seleccione la enfermedad para la que usted necesita el informe. Siga la misma regla para generar diversos informes.\nEsta hoja de trabajo debe ser impresa y presentada como un Reporte Conjunto (vea la instrucción para la presentación de la hoja de SUMMARY)."]
[]
[null,"Instrucciones para la entrada de datos"]
[]
[null,"La mayoría de las celdas en las hojas de trabajo mencionados anteriormente incluyen fórmulas que son calculadas automáticamente de acuerdo con la política de tratamiento recomendada por la OMS para cada enfermedad.\nVea el vínculo http://www.who.int/neglected_diseases/preventive_chemotherapy/pct_manual/en/index.html"]
[]
[null,"Por favor introduzca sus datos en las celdas de acuerdo con el siguiente código de color:"]
[]
[null,null,"Blanco - celda no protegida. Por favor ingrese el valor del indicador solicitado."]
[]
[null,null,"Amarillo - celda protegida que incluye el nombre del indicador. No se requiere de entrada de datos."]
[]
[null,null,"Naranja - celda no protegida e incluye un menú desplegable de opciones. Por favor seleccione el valor de la lista que se despliega."]
[]
[]
[null,null,"Verde -  celda no protegida e incluye fórmula. Por favor cambie el valor solamente si sus datos son diferentes a los que se calcularon automáticamente."]
[]
[]
[null,null,"Azul - celda protegida e incluye fórmula. No se requiere la entrada de datos."]
[]
[null,"Datos del País"]
[]
[null,"PAÍS",null,null,"STP"]
[]
[null,"Año del reporte de datos",null,null,2016]
[]
[null,"¿El país es endémico para filariasis linfática (FL)?",null,null,"Endémico"]
[]
[null,"¿El país es endémico para oncocercosis (ONCO)?",null,null,"No endémico"]
[]
[null,"¿El país es endémico para helmintiasis transmitidas por el contacto \n  con el suelo (HTS)?",null,null,"Endémico"]
[]
[null,"¿El país es endémico para esquistosomiasis (ESQ)?",null,null,"Endémico"]
[]
[null,"¿Cuántas unidades administrativas tiene el país?",null,null,7]
[null,"Si no se dispone de los datos demográficos a segundo nivel administrativo por grupo de edad, por favor ingrese la proporción (%) de población por grupo de edad en el país. Si el dato está disponible, por favor deje estas celdas en blanco."]
[null,"1-4 años","Niños en edad preescolar (PreESC)",null,0.123]
[null,"5-14 años","Niños en edad escolar (ESC)",null,0.26200000000000001]
[null,"15 años o más","Adultos",null,0.58299999999999996]

{"sheet":"COUNTRY_INFO","index":1,"n_rows":16,"n_cols":27,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,7,3,10],[3,19,3,20],[5,0,5,2],[3,15,3,18],[5,15,5,18],[3,21,3,22],[5,21,5,22],[5,3,5,6],[5,7,5,10],[5,11,5,14],[5,19,5,20]]}
["INFORMACIÓN DEL PAÍS"]
["Estructura administrativa, población por grupo de edad, estatus de endemicidad, intervenciones planeadas e intervenciones implementadas"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":188134},{"$f":"SUM(E$9:E$1000)","v":23141},{"$f":"SUM(F$9:F$1000)","v":49291},{"$f":"SUM(G$9:G$1000)","v":109682},null,null,null,null,{"$f":"SUM(L$9:L$1000)","v":188134},{"$f":"SUM(M$9:M$1000)","v":0},{"$f":"SUM(N$9:N$1000)","v":72432},{"$f":"SUM(O$9:O$1000)","v":35677.97}]
[]
["Estructura Administrativa del País",null,null,"Población",null,null,null,"Endemicidad",null,null,null,"Población requiriendo QP",null,null,null,"Número de rondas de tratamiento planeadas por año",null,null,null,"QP implementada",null,"Haga click para ver la estrategia recomendada"]
["País","Provincia/Estado","Distrito/municipio","Total","PreESC","ESC","Adultos","FL","Onco","HTS","ESQ","FL","Onco","HTS","ESQ","FL","Onco","HTS","ESQ","RONDA 1","RONDA 2",null,null,"IU_ID","IU_Name"]
[]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Agua Grande",73648,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D9*INTRO!$E$48,0))","v":9059},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D9*INTRO!$E$49,0))","v":19296},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D9*INTRO!$E$50,0))","v":42937},1,null,3,2,{"$f":"IF(INTRO!$E$38=\"Endémico\", IF($H9>0, IF($H9=4,\"Desconocido\", IF($H9=99,\"Suspendida\", $D9)), 0),\"No requerido\")","v":73648},{"$f":"IF(INTRO!$E$40=\"Endémico\", IF($I9>0, IF($I9=4,\"Desconocido\",IF($I9=99,\"Suspendida\", $D9)), 0),\"No requerido\")","v":"No requerido"},{"$f":"IF(INTRO!$E$42=\"Endémico\", IF(AND($J9>1,$J9<5), IF($J9=4, \"Desconocido\", E9+F9), 0),\"No requerido\")","v":28355},{"$f":"IF(INTRO!$E$44=\"Endémico\", IF(AND($K9>0,$K9<5), IF($K9=4,\"Desconocido\", IF($K9=1, $F9*0.33, IF($K9=2, $F9*0.5+$G9*0.2, SUM(F9:G9)))), 0),\"No requerido\")","v":18235.400000000001},1,null,2,1,"T1 (PZQ+ALB/MBD)",null,"MDA 2","T1",39143,"Agua Grande",null,{"$f":"Y9=C9","v":true}]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Me-zochi",46818,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D10*INTRO!$E$48,0))","v":5759},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D10*INTRO!$E$49,0))","v":12266},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D10*INTRO!$E$50,0))","v":27295},1,null,3,2,{"$f":"IF(INTRO!$E$38=\"Endémico\", IF($H10>0, IF($H10=4,\"Desconocido\", IF($H10=99,\"Suspendida\", $D10)), 0),\"No requerido\")","v":46818},{"$f":"IF(INTRO!$E$40=\"Endémico\", IF($I10>0, IF($I10=4,\"Desconocido\",IF($I10=99,\"Suspendida\", $D10)), 0),\"No requerido\")","v":"No requerido"},{"$f":"IF(INTRO!$E$42=\"Endémico\", IF(AND($J10>1,$J10<5), IF($J10=4, \"Desconocido\", E10+F10), 0),\"No requerido\")","v":18025},{"$f":"IF(INTRO!$E$44=\"Endémico\", IF(AND($K10>0,$K10<5), IF($K10=4,\"Desconocido\", IF($K10=1, $F10*0.33, IF($K10=2, $F10*0.5+$G10*0.2, SUM(F10:G10)))), 0),\"No requerido\")","v":11592},1,null,2,1,"T1 (PZQ+ALB/MBD)",null,"MDA 2","T1",39148,"Me-zochi",null,{"$f":"Y10=C10","v":true}]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Lobata ",20309,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D11*INTRO!$E$48,0))","v":2498},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D11*INTRO!$E$49,0))","v":5321},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D11*INTRO!$E$50,0))","v":11840},1,null,3,1,{"$f":"IF(INTRO!$E$38=\"Endémico\", IF($H11>0, IF($H11=4,\"Desconocido\", IF($H11=99,\"Suspendida\", $D11)), 0),\"No requerido\")","v":20309},{"$f":"IF(INTRO!$E$40=\"Endémico\", IF($I11>0, IF($I11=4,\"Desconocido\",IF($I11=99,\"Suspendida\", $D11)), 0),\"No requerido\")","v":"No requerido"},{"$f":"IF(INTRO!$E$42=\"Endémico\", IF(AND($J11>1,$J11<5), IF($J11=4, \"Desconocido\", E11+F11), 0),\"No requerido\")","v":7819},{"$f":"IF(INTRO!$E$44=\"Endémico\", IF(AND($K11>0,$K11<5), IF($K11=4,\"Desconocido\", IF($K11=1, $F11*0.33, IF($K11=2, $F11*0.5+$G11*0.2, SUM(F11:G11)))), 0),\"No requerido\")","v":1755.93},1,null,2,0,"T1 (PZQ+ALB/MBD)",null,"MDA 2","T1",39147,"Lobata ",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Cantagalo",18010,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D12*INTRO!$E$48,0))","v":2215},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D12*INTRO!$E$49,0))","v":4719},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D12*INTRO!$E$50,0))","v":10500},1,null,3,1,{"$f":"IF(INTRO!$E$38=\"Endémico\", IF($H12>0, IF($H12=4,\"Desconocido\", IF($H12=99,\"Suspendida\", $D12)), 0),\"No requerido\")","v":18010},{"$f":"IF(INTRO!$E$40=\"Endémico\", IF($I12>0, IF($I12=4,\"Desconocido\",IF($I12=99,\"Suspendida\", $D12)), 0),\"No requerido\")","v":"No requerido"},{"$f":"IF(INTRO!$E$42=\"Endémico\", IF(AND($J12>1,$J12<5), IF($J12=4, \"Desconocido\", E12+F12), 0),\"No requerido\")","v":6934},{"$f":"IF(INTRO!$E$44=\"Endémico\", IF(AND($K12>0,$K12<5), IF($K12=4,\"Desconocido\", IF($K12=1, $F12*0.33, IF($K12=2, $F12*0.5+$G12*0.2, SUM(F12:G12)))), 0),\"No requerido\")","v":1557.27},1,null,2,0,"T1 (PZQ+ALB/MBD)",null,"MDA 2","T1",39144,"Cantagalo",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Lemba",15558,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D13*INTRO!$E$48,0))","v":1914},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D13*INTRO!$E$49,0))","v":4076},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D13*INTRO!$E$50,0))","v":9070},1,null,3,1,{"$f":"IF(INTRO!$E$38=\"Endémico\", IF($H13>0, IF($H13=4,\"Desconocido\", IF($H13=99,\"Suspendida\", $D13)), 0),\"No requerido\")","v":15558},{"$f":"IF(INTRO!$E$40=\"Endémico\", IF($I13>0, IF($I13=4,\"Desconocido\",IF($I13=99,\"Suspendida\", $D13)), 0),\"No requerido\")","v":"No requerido"},{"$f":"IF(INTRO!$E$42=\"Endémico\", IF(AND($J13>1,$J13<5), IF($J13=4, \"Desconocido\", E13+F13), 0),\"No requerido\")","v":5990},{"$f":"IF(INTRO!$E$44=\"Endémico\", IF(AND($K13>0,$K13<5), IF($K13=4,\"Desconocido\", IF($K13=1, $F13*0.33, IF($K13=2, $F13*0.5+$G13*0.2, SUM(F13:G13)))), 0),\"No requerido\")","v":1345.0800000000002},1,null,2,0,"T1 (PZQ+ALB/MBD)",null,"MDA 2","T1",39146,"Lemba",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Cauè ",6162,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D14*INTRO!$E$48,0))","v":758},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D14*INTRO!$E$49,0))","v":1614},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D14*INTRO!$E$50,0))","v":3592},1,null,3,1,{"$f":"IF(INTRO!$E$38=\"Endémico\", IF($H14>0, IF($H14=4,\"Desconocido\", IF($H14=99,\"Suspendida\", $D14)), 0),\"No requerido\")","v":6162},{"$f":"IF(INTRO!$E$40=\"Endémico\", IF($I14>0, IF($I14=4,\"Desconocido\",IF($I14=99,\"Suspendida\", $D14)), 0),\"No requerido\")","v":"No requerido"},{"$f":"IF(INTRO!$E$42=\"Endémico\", IF(AND($J14>1,$J14<5), IF($J14=4, \"Desconocido\", E14+F14), 0),\"No requerido\")","v":2372},{"$f":"IF(INTRO!$E$44=\"Endémico\", IF(AND($K14>0,$K14<5), IF($K14=4,\"Desconocido\", IF($K14=1, $F14*0.33, IF($K14=2, $F14*0.5+$G14*0.2, SUM(F14:G14)))), 0),\"No requerido\")","v":532.62},1,null,2,0,"T1 (PZQ+ALB/MBD)",null,"MDA 2","T1",39145,"Cauè ",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"Principe","Píncipe",7629,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D15*INTRO!$E$48,0))","v":938},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D15*INTRO!$E$49,0))","v":1999},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D15*INTRO!$E$50,0))","v":4448},1,null,3,1,{"$f":"IF(INTRO!$E$38=\"Endémico\", IF($H15>0, IF($H15=4,\"Desconocido\", IF($H15=99,\"Suspendida\", $D15)), 0),\"No requerido\")","v":7629},{"$f":"IF(INTRO!$E$40=\"Endémico\", IF($I15>0, IF($I15=4,\"Desconocido\",IF($I15=99,\"Suspendida\", $D15)), 0),\"No requerido\")","v":"No requerido"},{"$f":"IF(INTRO!$E$42=\"Endémico\", IF(AND($J15>1,$J15<5), IF($J15=4, \"Desconocido\", E15+F15), 0),\"No requerido\")","v":2937},{"$f":"IF(INTRO!$E$44=\"Endémico\", IF(AND($K15>0,$K15<5), IF($K15=4,\"Desconocido\", IF($K15=1, $F15*0.33, IF($K15=2, $F15*0.5+$G15*0.2, SUM(F15:G15)))), 0),\"No requerido\")","v":659.67000000000007},1,null,2,0,"T1 (PZQ+ALB/MBD)",null,"MDA 2","T1",39142,"Píncipe",null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]

{"sheet":"MDA1","index":2,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":true,"merged":[[5,13,5,16],[3,0,3,2],[5,0,5,2],[5,5,5,8],[5,9,5,12],[5,3,6,3],[5,4,6,4]]}
["MDA 1 - Ivermectina (IVM) y Albendazol (ALB)"]
["Estructura administrativa, población requiriendo QP por grupo de edad, población tratada por grupo de edad y cobertura"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":0},{"$f":"SUM(H$9:H$1000)","v":0},{"$f":"SUM(I$9:I$1000)","v":0},null,{"$f":"SUM(K$9:K$1000)","v":0},{"$f":"SUM(L$9:L$1000)","v":0},{"$f":"SUM(M$9:M$1000)","v":0},null,{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":" "},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "}]
[]
["Estructura administrativa del país",null,null,"QP implementada","Fecha","Población objetivo para MDA 1",null,null,null,"Población tratada",null,null,null,"Cobertura del programa (%)"]
["País","Provincia/Estado","Distrito/municipio",null,null,"PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Agua Grande"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA1 (IVM+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,{"$f":"SUM(F9:H9)","v":0},null,null,null,{"$f":"SUM(J9:L9)","v":0},null,{"$f":"IF(G9<>0, IF(K9/G9*100=0, \"-\", K9/G9*100), \" \")","v":" "},{"$f":"IF(H9<>0, IF(L9/H9*100=0, \"-\", L9/H9*100), \" \")","v":" "}," "]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Me-zochi"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA1 (IVM+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,{"$f":"SUM(F10:H10)","v":0},null,null,null,{"$f":"SUM(J10:L10)","v":0},null,{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":" "},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Lobata "},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA1 (IVM+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0,null," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Cantagalo"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA1 (IVM+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0,null," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Lemba"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA1 (IVM+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0,null," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Cauè "},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA1 (IVM+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0,null," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"Principe"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Píncipe"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA1 (IVM+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0,null," "," "," "]

{"sheet":"MDA2","index":3,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,5,5,8],[5,9,5,12],[5,13,5,16],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,4,6,4]]}
["MDA 2 - Citrato de dietilcarbamazina (DEC) + Albendazol (ALB)"]
["Estructura administrativa, población requiriendo QP por grupo de edad, población tratada por grupo de edad y cobertura"]
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F$9:F$1000)","v":0},{"$f":"SUM(G$9:G$1000)","v":0},0,0,0,0,0,0,{"$f":"IF(F4<>0, IF(J4/F4*100=0, \"-\", J4/F4*100), \" \")","v":" "},{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":" "},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "}]
[]
["Estructura administrativa del país",null,null,"QP implementada","Fecha","Población objetivo para MDA 2",null,null,null,"Población tratada",null,null,null,"Cobertura del programa (%)"]
["País","Provincia/Estado","Distrito/municipio",null,null,"PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Agua Grande"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,{"$f":"SUM(F9:H9)","v":0},null,null,null,{"$f":"SUM(J9:L9)","v":0},{"$f":"IF(F9<>0, IF(J9/F9*100=0, \"-\", J9/F9*100), \" \")","v":" "}," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Me-zochi"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,{"$f":"SUM(F10:H10)","v":0},null,null,null,{"$f":"SUM(J10:L10)","v":0},{"$f":"IF(F10<>0, IF(J10/F10*100=0, \"-\", J10/F10*100), \" \")","v":" "},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":" "},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Lobata "},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Cantagalo"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Lemba"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Cauè "},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"Principe"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Píncipe"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA2 (DEC+ALB)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]

{"sheet":"MDA3","index":4,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":true,"merged":[[5,5,5,7],[5,17,5,19],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,4,6,4],[5,8,5,10],[5,11,5,13],[5,14,5,16]]}
["MDA 3 - Ivermectina (IVM) "]
["Estructura administrativa, población requiriendo QP por grupo de edad, población tratada por grupo de edad y cobertura"]
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F$9:F$1000)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(F4<>0, IF(O4/F4*100=0, \"-\", O4/F4*100), \" \")","v":" "},{"$f":"IF(G4<>0, IF(P4/G4*100=0, \"-\", P4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(Q4/H4*100=0, \"-\", Q4/H4*100), \" \")","v":" "}]
[]
["Estructura administrativa del país",null,null,"QP implementada","Fecha","Población objetivo para MDA 3",null,null,"Población tratada - 1a ronda",null,null,"Población tratada - 2a ronda",null,null,"Población tratada",null,null,"Cobertura del programa (%)"]
["País","Provincia/Estado","Distrito/municipio",null,null,"ESC","Adultos","Total","ESC","Adultos","Total","ESC","Adultos","Total","ESC","Adultos","Total","ESC","Adultos","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Agua Grande"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA3 (IVM)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,{"$f":"SUM(F9:G9)","v":0},null,null,{"$f":"SUM(I9:J9)","v":0},null,null,{"$f":"SUM(L9:M9)","v":0},{"$f":"MAX(I9,L9)","v":0},0,{"$f":"SUM(O9:P9)","v":0},{"$f":"IF(F9<>0, IF(MAX(I9,L9)/F9*100=0, \"-\", MAX(I9,L9)/F9*100), \" \")","v":" "}," ",{"$f":"IF(H9<>0, IF((MAX(I9,L9)+MAX(J9,M9))/H9*100=0, \"-\",(MAX(I9,L9)+MAX(J9,M9))/H9*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Me-zochi"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA3 (IVM)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,{"$f":"SUM(F10:G10)","v":0},null,null,{"$f":"SUM(I10:J10)","v":0},null,null,{"$f":"SUM(L10:M10)","v":0},{"$f":"MAX(I10,L10)","v":0},{"$f":"MAX(J10,M10)","v":0},{"$f":"SUM(O10:P10)","v":0},{"$f":"IF(F10<>0, IF(MAX(I10,L10)/F10*100=0, \"-\", MAX(I10,L10)/F10*100), \" \")","v":" "},{"$f":"IF(G10<>0, IF(MAX(J10,M10)/G10*100=0, \"-\", MAX(J10,M10)/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF((MAX(I10,L10)+MAX(J10,M10))/H10*100=0, \"-\",(MAX(I10,L10)+MAX(J10,M10))/H10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Lobata "},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA3 (IVM)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,0,null,null,0,null,null,0,0,0,0," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Cantagalo"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA3 (IVM)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,0,null,null,0,null,null,0,0,0,0," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Lemba"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA3 (IVM)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,0,null,null,0,null,null,0,0,0,0," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Cauè "},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA3 (IVM)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,0,null,null,0,null,null,0,0,0,0," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"Principe"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Píncipe"},{"$f":"IF(COUNTRY_INFO!$T$9:$T$1000=\"MDA3 (IVM)\", COUNTRY_INFO!$T$9:$T$1000, \" \")","v":" "},null,null,null,0,null,null,0,null,null,0,0,0,0," "," "," "]

{"sheet":"T1","index":5,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,6,5,10],[5,11,5,14],[5,15,5,18],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,5,6,5],[5,4,6,4]]}
["T 1 - Prazicuantel (PZQ) y Albendazol (ALB) o Mebendazol (MBD)"]
["Estructura administrativa, población requiriendo QP por grupo de edad, población tratada por grupo de edad y cobertura"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":0},36601,36601,0,{"$f":"SUM(K$9:K$1000)","v":36601},0,32201,0,32201,{"$f":"IF(G4<>0, IF(L4/G4*100=0, \"-\", L4/G4*100), \" \")","v":" "},{"$f":"IF(OR(I4<>0,H4<>0), IF(M4/MAX(H4,I4)*100=0, \"-\", M4/MAX(H4,I4)*100), \" \")","v":87.978470533591974},{"$f":"IF(J4<>0, IF(N4/J4*100=0, \"-\", N4/J4*100), \" \")","v":" "},{"$f":"IF(K4<>0, IF(O4/K4*100=0, \"-\", O4/K4*100), \" \")","v":87.978470533591974}]
[]
["Estructura administrativa del país",null,null,"QP implementada","Medica-mento","Fecha","Población objetivo para T1",null,null,null,null,"Población tratada",null,null,null,"Cobertura del programa (%)"]
["País","Provincia/Estado","Distrito/municipio",null,null,null,"PreESC (ALB)","ESC (ALB)","ESC (PZQ)","Adultos (PZQ)","Total","PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Agua Grande"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":"T1 (PZQ+ALB/MBD)"},"PZQ+MBD","Nov/Dec 2016",null,14288,14288,null,{"$f":"MAX(H9:I9)+G9+J9","v":14288},null,10719,null,10719,{"$f":"IF(G9<>0, IF(L9/G9*100=0, \"-\", L9/G9*100), \" \")","v":" "},{"$f":"IF(OR(I9<>0,H9<>0), IF(M9/MAX(H9,I9)*100=0, \"-\", M9/MAX(H9,I9)*100), \" \")","v":75.020996640537518},{"$f":"IF(J9<>0, IF(N9/J9*100=0, \"-\", N9/J9*100), \" \")","v":" "},75.020996640537518]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Me-zochi"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":"T1 (PZQ+ALB/MBD)"},"PZQ+MBD","Nov/Dec 2016",null,8716,8716,null,{"$f":"MAX(H10:I10)+G10+J10","v":8716},null,8050,null,8050,{"$f":"IF(G10<>0, IF(L10/G10*100=0, \"-\", L10/G10*100), \" \")","v":" "},{"$f":"IF(OR(I10<>0,H10<>0), IF(M10/MAX(H10,I10)*100=0, \"-\", M10/MAX(H10,I10)*100), \" \")","v":92.358880220284533},{"$f":"IF(J10<>0, IF(N10/J10*100=0, \"-\", N10/J10*100), \" \")","v":" "},{"$f":"IF(K10<>0, IF(O10/K10*100=0, \"-\", O10/K10*100), \" \")","v":92.358880220284533}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Lobata "},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":"T1 (PZQ+ALB/MBD)"},"PZQ+MBD","Nov/Dec 2016",null,3870,3870,null,3870,null,3941,null,3941," ",101.83462532299741," ",101.83462532299741]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Cantagalo"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":"T1 (PZQ+ALB/MBD)"},"PZQ+MBD","Nov/Dec 2016",null,3262,3262,null,3262,null,3244,null,3244," ",99.448191293684857," ",99.448191293684857]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Lemba"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":"T1 (PZQ+ALB/MBD)"},"PZQ+MBD","Nov/Dec 2016",null,3215,3215,null,3215,null,2927,null,2927," ",91.041990668740283," ",91.041990668740283]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Cauè "},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":"T1 (PZQ+ALB/MBD)"},"PZQ+MBD","Nov/Dec 2016",null,1383,1383,null,1383,null,1256,null,1256," ",90.817064352856107," ",90.817064352856107]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"Principe"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Píncipe"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":"T1 (PZQ+ALB/MBD)"},"PZQ+MBD","Nov/Dec 2016",null,1867,1867,null,1867,null,2064,null,2064," ",110.5516871987145," ",110.5516871987145]

{"sheet":"T2","index":6,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,5,5,8],[5,9,5,12],[5,13,5,16],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,4,6,4]]}
["T 2 - Prazicuantel (PZQ) "]
["Estructura administrativa, población requiriendo QP por grupo de edad, población tratada por grupo de edad y cobertura"]
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F$9:F$1000)","v":0},0,0,0,0,0,0,0,{"$f":"IF(F4<>0, IF(J4/F4*100=0, \"-\", J4/F4*100), \" \")","v":" "},{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":" "},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "}]
[]
["Estructura administrativa del país",null,null,"QP implementada","Fecha","Población objetivo para T2",null,null,null,"Población tratada",null,null,null,"Cobertura del programa (%)"]
["País","Provincia/Estado","Distrito/municipio",null,null,"PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Agua Grande"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T2 (PZQ)\",COUNTRY_INFO!$U$9:$U$1000=\"T2 (PZQ)\"), \"T2 (PZQ)\", \" \")","v":" "},null,null,null,null,{"$f":"SUM(F9:H9)","v":0},null,null,null,{"$f":"SUM(J9:L9)","v":0},{"$f":"IF(F9<>0, IF(J9/F9*100=0, \"-\", J9/F9*100), \" \")","v":" "}," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Me-zochi"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T2 (PZQ)\",COUNTRY_INFO!$U$9:$U$1000=\"T2 (PZQ)\"), \"T2 (PZQ)\", \" \")","v":" "},null,null,null,null,{"$f":"SUM(F10:H10)","v":0},null,null,null,{"$f":"SUM(J10:L10)","v":0},{"$f":"IF(F10<>0, IF(J10/F10*100=0, \"-\", J10/F10*100), \" \")","v":" "},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":" "},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Lobata "},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T2 (PZQ)\",COUNTRY_INFO!$U$9:$U$1000=\"T2 (PZQ)\"), \"T2 (PZQ)\", \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Cantagalo"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T2 (PZQ)\",COUNTRY_INFO!$U$9:$U$1000=\"T2 (PZQ)\"), \"T2 (PZQ)\", \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Lemba"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T2 (PZQ)\",COUNTRY_INFO!$U$9:$U$1000=\"T2 (PZQ)\"), \"T2 (PZQ)\", \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Cauè "},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T2 (PZQ)\",COUNTRY_INFO!$U$9:$U$1000=\"T2 (PZQ)\"), \"T2 (PZQ)\", \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"Principe"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Píncipe"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T2 (PZQ)\",COUNTRY_INFO!$U$9:$U$1000=\"T2 (PZQ)\"), \"T2 (PZQ)\", \" \")","v":" "},null,null,null,null,0,null,null,null,0," "," "," "," "]

{"sheet":"T3_R1","index":7,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,6,5,9],[5,10,5,13],[5,14,5,17],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,5,6,5],[5,4,6,4]]}
["T 3 - Albendazol (ALB) o Mebendazol (MBD) - Ronda 1"]
["Estructura administrativa, población requiriendo QP por grupo de edad, población tratada por grupo de edad y cobertura"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":0},0,0,0,0,0,0,0,{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":" "},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "},{"$f":"IF(J4<>0, IF(N4/J4*100=0, \"-\", N4/J4*100), \" \")","v":" "}]
[]
["Estructura administrativa del país",null,null,"QP implementada","Medica-mento","Fecha","Población objetivo para T3",null,null,null,"Población tratada",null,null,null,"Cobertura del programa (%)"]
["País","Provincia/Estado","Distrito/municipio",null,null,null,"PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Agua Grande"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,{"$f":"SUM(G9:I9)","v":0},null,null,null,{"$f":"SUM(K9:M9)","v":0},{"$f":"IF(G9<>0, IF(K9/G9*100=0, \"-\", K9/G9*100), \" \")","v":" "}," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Me-zochi"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,{"$f":"SUM(G10:I10)","v":0},null,null,null,{"$f":"SUM(K10:M10)","v":0},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":" "},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "},{"$f":"IF(J10<>0, IF(N10/J10*100=0, \"-\", N10/J10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Lobata "},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Cantagalo"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Lemba"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Cauè "},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"Principe"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Píncipe"},{"$f":"IF(OR(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]

{"sheet":"T3_R2","index":8,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,6,5,9],[5,10,5,13],[5,14,5,17],[3,0,3,2],[5,0,5,2],[5,3,6,3],[5,5,6,5],[5,4,6,4]]}
["T 3 - Albendazol (ALB) o Mebendazol (MBD) - Ronda 2"]
["Estructura administrativa, población requiriendo QP por grupo de edad, población tratada por grupo de edad y cobertura"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":0},0,0,0,0,0,0,0,{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":" "},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":" "},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":" "},{"$f":"IF(J4<>0, IF(N4/J4*100=0, \"-\", N4/J4*100), \" \")","v":" "}]
[]
["Estructura administrativa del país",null,null,"QP implementada","Medica-mento","Fecha","Población objetivo para T3",null,null,null,"Población tratada",null,null,null,"Cobertura del programa (%)"]
["País","Provincia/Estado","Distrito/municipio",null,null,null,"PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total","PreESC","ESC","Adultos","Total"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Agua Grande"},{"$f":"IF(AND(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,{"$f":"SUM(G9:I9)","v":0},null,null,null,{"$f":"SUM(K9:M9)","v":0},{"$f":"IF(G9<>0, IF(K9/G9*100=0, \"-\", K9/G9*100), \" \")","v":" "}," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Me-zochi"},{"$f":"IF(AND(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,{"$f":"SUM(G10:I10)","v":0},null,null,null,{"$f":"SUM(K10:M10)","v":0},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":" "},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":" "},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":" "},{"$f":"IF(J10<>0, IF(N10/J10*100=0, \"-\", N10/J10*100), \" \")","v":" "}]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Lobata "},{"$f":"IF(AND(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Cantagalo"},{"$f":"IF(AND(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Lemba"},{"$f":"IF(AND(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Cauè "},{"$f":"IF(AND(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"Principe"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Píncipe"},{"$f":"IF(AND(COUNTRY_INFO!$T$9:$T$1000=\"T3 (ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T3 (ALB/MBD)\"), \"T3 (ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,0,null,null,null,0," "," "," "," "]

{"sheet":"DISTRICT","index":9,"n_rows":15,"n_cols":56,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,26,5,34],[5,3,6,3],[5,9,6,9],[5,15,6,15],[5,25,6,25],[3,0,3,2],[5,0,5,2],[5,4,5,8],[5,10,5,14],[5,16,5,24]]}
["Número de personas tratadas"]
["Estructura administrativa, población tratada por grupo de edad y sexo"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":188134},{"$f":"SUM(E$9:E$1000)","v":0},{"$f":"SUM(F$9:F$1000)","v":0},{"$f":"SUM(G$9:G$1000)","v":0},{"$f":"SUM(H$9:H$1000)","v":0},{"$f":"IF(D4>0, IF(H4/D4*100<>0, H4/D4*100, \"-\"),0)","v":"-"},{"$f":"SUM(J$9:J$1000)","v":0},{"$f":"SUM(K$9:K$1000)","v":0},{"$f":"SUM(L$9:L$1000)","v":0},{"$f":"SUM(M$9:M$1000)","v":0},{"$f":"SUM(N$9:N$1000)","v":0},{"$f":"IF(J4>0, IF(N4/J4*100<>0, N4/J4*100, \"-\"),0)","v":0},{"$f":"SUM(P$9:P$1000)","v":72432},{"$f":"SUM(Q$9:Q$1000)","v":0},{"$f":"SUM(R$9:R$1000)","v":0},{"$f":"SUM(S$9:S$1000)","v":32201},{"$f":"SUM(T$9:T$1000)","v":0},null,32136,null,{"$f":"SUM(X$9:X$1000)","v":32136},{"$f":"IF(P4>0, IF(X4/P4*100<>0, X4/P4*100, \"-\"),0)","v":44.367130550033131},{"$f":"SUM(Z$9:Z$1000)","v":35677.97},0,0,32201,21631.57,null,0,null,21631.57,{"$f":"IF(Z4>0, IF(AH4/Z4*100<>0, AH4/Z4*100, \"-\"),0)","v":60.630047057049488}]
[]
["Estructura administrativa del país",null,null,"Población requiriendo QP para FL","Población tratada para filariasis linfática",null,null,null,null,"Población requiriendo QP para Onco","Población tratada para oncocercosis",null,null,null,null,"Población requiriendo QP para HTS","Población tratada para HTS",null,null,null,null,null,null,null,null,"Población requiriendo QP para ESQ","Población tratada para esquistosomiasis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP9:AP1000)","v":6020},23141,49291,109681.99999999999,{"$f":"SUM(AT9:AT1000)","v":188134},{"$f":"COUNTIF(AU9:AU1000,\"Y\")","v":0},{"$f":"SUM(AV9:AV1000)","v":0},32201,0,{"$f":"SUM(AY9:AY1000)","v":32201},0,32136,0,32136,{"$f":"IF(AT6<>0,BC6/AT6,0)","v":0.17081441950949855}]
["País","Provincia/Estado","Distrito/municipio",null,"Hombres","Mujeres","Total tratados","Total tratados que necesitan QP","(%)",null,"Hombres","Mujeres","Total tratados","Total tratados que necesitan QP","(%)",null,"Hombres","Mujeres","Total tratados","PreESC tratados que necesitan QP","PreESC (%)","ESC tratados que necesitan QP","ESC (%)","Total tratados que necesitan QP","(%)",null,"Hombres","Mujeres","Total tratados","ESC tratados que necesitan QP","ESC (%)","Adultos tratados que necesitan QP","Adultos (%)","Total tratados que necesitan QP","(%)",null,"LF","ONCHO","STH","SCH-SAC","SCH_Adults","<1","PreSAC","SAC","Adults","Total","Dis","PreSAC","SAC","Adults","Total","PreSAC","SAC","Adults","Total","Coverage"]
[]
[{"$f":"IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)","v":"Agua Grande"},{"$f":"COUNTRY_INFO!L9","v":73648},null,null,{"$f":"MAX('MDA1'!M9,'MDA2'!M9)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H9>0,COUNTRY_INFO!H9<4),IF(D9>MAX('MDA1'!M9,'MDA2'!M9),MAX('MDA1'!M9,'MDA2'!M9),D9),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H9>0,COUNTRY_INFO!H9<4), IF(G9/D9*100<>0, IF(G9/D9*100>100,100,G9/D9*100), \"-\"),0)","v":"-"},{"$f":"COUNTRY_INFO!M9","v":"No requerido"},null,null,{"$f":"MAX('MDA1'!M9,MAX('MDA3'!I9,'MDA3'!L9)+MAX('MDA3'!J9,'MDA3'!M9))","v":0},{"$f":"IF(AND(COUNTRY_INFO!I9>0,COUNTRY_INFO!I9<4),IF(J9>MAX('MDA1'!M9,MAX('MDA3'!I9,'MDA3'!L9)+MAX('MDA3'!J9,'MDA3'!M9)),MAX('MDA1'!M9,MAX('MDA3'!I9,'MDA3'!L9)+MAX('MDA3'!J9,'MDA3'!M9)),J9),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I9>0,COUNTRY_INFO!I9<4), IF(M9/J9*100<>0, IF(M9/J9*100>100,100,M9/J9*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!N9","v":28355},null,null,{"$f":"SUM(MAX('MDA2'!J9, 'T1'!L9, MAX(T3_R1!K9, T3_R2!K9)), MAX('MDA1'!K9, 'MDA2'!K9, 'T1'!M9, MAX(T3_R1!L9, T3_R2!L9)), MAX('MDA1'!L9, 'MDA2'!L9, 'T1'!N9, MAX(T3_R1!M9, T3_R2!M9)))","v":10719},{"$f":"IF(AND(COUNTRY_INFO!J9>1,COUNTRY_INFO!J9<4),IF(COUNTRY_INFO!E9>MAX('MDA2'!J9,'T1'!L9,MAX(T3_R1!K9,T3_R2!K9)),MAX('MDA2'!J9,'T1'!L9,MAX(T3_R1!K9,T3_R2!K9)),COUNTRY_INFO!E9),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J9>1,COUNTRY_INFO!J9<4), IF(T9/COUNTRY_INFO!E9*100<>0, IF(T9/COUNTRY_INFO!E9*100>100,100,T9/COUNTRY_INFO!E9*100), \"-\"),0)","v":"-"},{"$f":"IF(AND(COUNTRY_INFO!J9>1,COUNTRY_INFO!J9<4),IF(COUNTRY_INFO!F9>MAX('MDA1'!K9,'MDA2'!K9,'T1'!M9,MAX(T3_R1!L9,T3_R2!L9)),MAX('MDA1'!K9,'MDA2'!K9,'T1'!M9,MAX(T3_R1!L9,T3_R2!L9)),COUNTRY_INFO!F9),0)","v":10719},{"$f":"IF(AND(COUNTRY_INFO!J9>1,COUNTRY_INFO!J9<4), IF(V9/COUNTRY_INFO!F9*100<>0, IF(V9/COUNTRY_INFO!F9*100>100,100,V9/COUNTRY_INFO!F9*100), \"-\"),0)","v":55.550373134328353},{"$f":"SUM(T9,V9)","v":10719},{"$f":"IF(AND(COUNTRY_INFO!J9>1,COUNTRY_INFO!J9<4), IF(S9/P9*100<>0, IF(X9/P9*100>100,100,X9/P9*100), \"-\"),0)","v":37.802856639040733},{"$f":"COUNTRY_INFO!O9","v":18235.400000000001},null,null,{"$f":"MAX('T1'!L9,'T2'!J9)+MAX('T1'!M9,'T2'!K9)+MAX('T1'!N9,'T2'!L9)","v":10719},{"$f":"IF(COUNTRY_INFO!K9=1,IF(COUNTRY_INFO!F9*0.33>MAX('T1'!M9,'T2'!K9),MAX('T1'!M9,'T2'!K9),COUNTRY_INFO!F9*0.33),IF(COUNTRY_INFO!K9=2,IF(COUNTRY_INFO!F9*0.5>MAX('T1'!M9,'T2'!K9),MAX('T1'!M9,'T2'!K9),COUNTRY_INFO!F9*0.5),IF(COUNTRY_INFO!K9=3,IF(COUNTRY_INFO!F9>MAX('T1'!M9,'T2'!K9),MAX('T1'!M9,'T2'!K9),COUNTRY_INFO!F9),0)))","v":9648},{"$f":"IF(AND(COUNTRY_INFO!K9>0,COUNTRY_INFO!K9<4),IF(Z9>0,IF(COUNTRY_INFO!K9=1, AD9/(COUNTRY_INFO!F9*0.33)*100, IF(COUNTRY_INFO!K9=2, AD9/(COUNTRY_INFO!F9*0.5)*100, IF(COUNTRY_INFO!K9=3, AD9/COUNTRY_INFO!F9*100))),\"-\"),0)","v":100},{"$f":"IF(COUNTRY_INFO!K9=2,IF(COUNTRY_INFO!G9*0.2>MAX('T1'!N9,'T2'!L9),MAX('T1'!N9,'T2'!L9),COUNTRY_INFO!G9*0.2),IF(COUNTRY_INFO!K9=3,IF(COUNTRY_INFO!G9>MAX('T1'!N9,'T2'!L9),MAX('T1'!N9,'T2'!L9),COUNTRY_INFO!G9),0))","v":0},{"$f":"IF(AND(COUNTRY_INFO!K9>0,COUNTRY_INFO!K9<4),IF(Z9>0,IF(COUNTRY_INFO!K9=1, 0, IF(COUNTRY_INFO!K9=2, AF9/(COUNTRY_INFO!G9*0.2)*100, IF(COUNTRY_INFO!K9=3, AF9/COUNTRY_INFO!G9*100))),\"-\"),0)","v":0},{"$f":"SUM(AD9,AF9)","v":9648},{"$f":"IF(AND(COUNTRY_INFO!K9>0,COUNTRY_INFO!K9<4), IF(AC9/Z9*100<>0, IF(AH9/Z9*100>100,100,AH9/Z9*100), \"-\"),0)","v":52.908079888568381},null,{"$f":"IF(AND(D9<>0, D9<>\"Desconocido\",D9<>\"Suspendida\",D9<>\"No requerido\"),D9/COUNTRY_INFO!D9, 0)","v":1},{"$f":"IF(AND(J9<>0,J9<>\"Desconocido\",J9<>\"Suspendida\",J9<>\"No requerido\"),J9/COUNTRY_INFO!D9, 0)","v":0},{"$f":"IF(AND(P9<>0,P9<>\"Desconocido\",P9<>\"No requerido\"),P9/(COUNTRY_INFO!E9+COUNTRY_INFO!F9), 0)","v":1},{"$f":"IF(AND(Z9<>0,Z9<>\"Desconocido\",Z9<>\"No requerido\"),IF(COUNTRY_INFO!K9=1,1,IF(COUNTRY_INFO!K9=2,0.5*COUNTRY_INFO!F9/(0.5*COUNTRY_INFO!F9+0.2*COUNTRY_INFO!G9),IF(COUNTRY_INFO!K9=3,COUNTRY_INFO!F9/(COUNTRY_INFO!F9+COUNTRY_INFO!G9)))),0)","v":0.52908079888568382},{"$f":"IF(AND(Z9<>0,Z9<>\"Desconocido\",Z9<>\"No requerido\"),IF(COUNTRY_INFO!K9=1,0,IF(COUNTRY_INFO!K9=2,0.2*COUNTRY_INFO!G9/(0.5*COUNTRY_INFO!F9+0.2*COUNTRY_INFO!G9),IF(COUNTRY_INFO!K9=3,COUNTRY_INFO!G9/(COUNTRY_INFO!F9+COUNTRY_INFO!G9)))),0)","v":0.47091920111431607},{"$f":"MAX(COUNTRY_INFO!D9*AK9*PROFILE!$G$7,COUNTRY_INFO!D9*AL9*PROFILE!$G$7)","v":2356.6232578906524},{"$f":"MAX(COUNTRY_INFO!D9*AK9*PROFILE!$G$8,COUNTRY_INFO!D9*AL9*PROFILE!$G$8,COUNTRY_INFO!D9*AM9*PROFILE!$G$8)","v":9058.9067792105634},{"$f":"MAX(COUNTRY_INFO!D9*AK9*PROFILE!$G$9,COUNTRY_INFO!D9*AL9*PROFILE!$G$9,COUNTRY_INFO!D9*AM9*PROFILE!$G$9,IF(AND(DISTRICT!Z9<>\"Desconocido\",Z9<>\"No requerido\"),COUNTRY_INFO!O9*DISTRICT!AN9,0))","v":19295.733721708995},{"$f":"MAX(COUNTRY_INFO!D9*AK9*PROFILE!$G$10,COUNTRY_INFO!D9*AL9*PROFILE!$G$10,IF(AND(DISTRICT!Z9<>\"Desconocido\",Z9<>\"No requerido\"),COUNTRY_INFO!O9*DISTRICT!AO9,0))","v":42936.736241189792},{"$f":"SUM(AP9:AS9)","v":73648},{"$f":"IF(COUNTIFS(AK9:AN9,\">0\")=0,0, IF(COUNTIFS(AK9:AN9,\">0\")<=IF(AND(OR(D9>=0,D9=\"No requerido\",D9=\"Desconocido\",D9=\"Suspendida\"),D9>0,H9>0),1,0)+IF(AND(OR(J9>=0,J9=\"No requerido\",J9=\"Desconocido\",J9=\"Suspendida\"),J9>0,N9>0),1,0)+IF(AND(OR(P9>=0,P9=\"No requerido\",P9=\"Desconocido\"),P9>0,X9>0),1,0)+IF(AND(OR(Z9>=0,Z9=\"No requerido\",Z9=\"Desconocido\"),Z9>0,AH9>0),1,0),\"Y\",0))","v":0},{"$f":"MAX('MDA2'!J9,'T1'!L9,'T2'!J9,T3_R1!K9,T3_R2!K9)","v":0},{"$f":"MAX('MDA1'!K9,'MDA2'!K9,'MDA3'!I9,'MDA3'!L9,'T1'!M9,'T2'!K9,T3_R1!L9,T3_R2!L9)","v":10719},{"$f":"MAX('MDA1'!L9,'MDA2'!L9,'MDA3'!J9,'MDA3'!M9,'T1'!N9,'T2'!L9,T3_R1!M9,T3_R2!M9)","v":0},{"$f":"SUM(AV9:AX9)","v":10719},{"$f":"MAX('MDA2'!J9,T9)","v":0},{"$f":"MAX('MDA1'!K9,'MDA2'!K9,'MDA3'!I9,'MDA3'!L9,V9,AD9)","v":10719},{"$f":"MAX('MDA1'!L9,'MDA2'!L9,'MDA3'!J9,'MDA3'!M9,AF9)","v":0},{"$f":"IF(AT9<SUM(AZ9:BB9), AT9,SUM(AZ9:BB9))","v":10719},{"$f":"IF(AT9<>0,BC9/AT9*100,0)","v":14.554366717358244}]
[{"$f":"IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)","v":"Me-zochi"},{"$f":"COUNTRY_INFO!L10","v":46818},null,null,{"$f":"MAX('MDA1'!M10,'MDA2'!M10)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H10>0,COUNTRY_INFO!H10<4),IF(D10>MAX('MDA1'!M10,'MDA2'!M10),MAX('MDA1'!M10,'MDA2'!M10),D10),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H10>0,COUNTRY_INFO!H10<4), IF(G10/D10*100<>0, IF(G10/D10*100>100,100,G10/D10*100), \"-\"),0)","v":"-"},{"$f":"COUNTRY_INFO!M10","v":"No requerido"},null,null,{"$f":"MAX('MDA1'!M10,MAX('MDA3'!I10,'MDA3'!L10)+MAX('MDA3'!J10,'MDA3'!M10))","v":0},{"$f":"IF(AND(COUNTRY_INFO!I10>0,COUNTRY_INFO!I10<4),IF(J10>MAX('MDA1'!M10,MAX('MDA3'!I10,'MDA3'!L10)+MAX('MDA3'!J10,'MDA3'!M10)),MAX('MDA1'!M10,MAX('MDA3'!I10,'MDA3'!L10)+MAX('MDA3'!J10,'MDA3'!M10)),J10),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I10>0,COUNTRY_INFO!I10<4), IF(M10/J10*100<>0, IF(M10/J10*100>100,100,M10/J10*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!N10","v":18025},null,null,{"$f":"SUM(MAX('MDA2'!J10, 'T1'!L10, MAX(T3_R1!K10, T3_R2!K10)), MAX('MDA1'!K10, 'MDA2'!K10, 'T1'!M10, MAX(T3_R1!L10, T3_R2!L10)), MAX('MDA1'!L10, 'MDA2'!L10, 'T1'!N10, MAX(T3_R1!M10, T3_R2!M10)))","v":8050},{"$f":"IF(AND(COUNTRY_INFO!J10>1,COUNTRY_INFO!J10<4),IF(COUNTRY_INFO!E10>MAX('MDA2'!J10,'T1'!L10,MAX(T3_R1!K10,T3_R2!K10)),MAX('MDA2'!J10,'T1'!L10,MAX(T3_R1!K10,T3_R2!K10)),COUNTRY_INFO!E10),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J10>1,COUNTRY_INFO!J10<4), IF(T10/COUNTRY_INFO!E10*100<>0, IF(T10/COUNTRY_INFO!E10*100>100,100,T10/COUNTRY_INFO!E10*100), \"-\"),0)","v":"-"},{"$f":"IF(AND(COUNTRY_INFO!J10>1,COUNTRY_INFO!J10<4),IF(COUNTRY_INFO!F10>MAX('MDA1'!K10,'MDA2'!K10,'T1'!M10,MAX(T3_R1!L10,T3_R2!L10)),MAX('MDA1'!K10,'MDA2'!K10,'T1'!M10,MAX(T3_R1!L10,T3_R2!L10)),COUNTRY_INFO!F10),0)","v":8050},{"$f":"IF(AND(COUNTRY_INFO!J10>1,COUNTRY_INFO!J10<4), IF(V10/COUNTRY_INFO!F10*100<>0, IF(V10/COUNTRY_INFO!F10*100>100,100,V10/COUNTRY_INFO!F10*100), \"-\"),0)","v":65.628566769933144},{"$f":"SUM(T10,V10)","v":8050},{"$f":"IF(AND(COUNTRY_INFO!J10>1,COUNTRY_INFO!J10<4), IF(S10/P10*100<>0, IF(X10/P10*100>100,100,X10/P10*100), \"-\"),0)","v":44.660194174757287},{"$f":"COUNTRY_INFO!O10","v":11592},null,null,{"$f":"MAX('T1'!L10,'T2'!J10)+MAX('T1'!M10,'T2'!K10)+MAX('T1'!N10,'T2'!L10)","v":8050},{"$f":"IF(COUNTRY_INFO!K10=1,IF(COUNTRY_INFO!F10*0.33>MAX('T1'!M10,'T2'!K10),MAX('T1'!M10,'T2'!K10),COUNTRY_INFO!F10*0.33),IF(COUNTRY_INFO!K10=2,IF(COUNTRY_INFO!F10*0.5>MAX('T1'!M10,'T2'!K10),MAX('T1'!M10,'T2'!K10),COUNTRY_INFO!F10*0.5),IF(COUNTRY_INFO!K10=3,IF(COUNTRY_INFO!F10>MAX('T1'!M10,'T2'!K10),MAX('T1'!M10,'T2'!K10),COUNTRY_INFO!F10),0)))","v":6133},{"$f":"IF(AND(COUNTRY_INFO!K10>0,COUNTRY_INFO!K10<4),IF(Z10>0,IF(COUNTRY_INFO!K10=1, AD10/(COUNTRY_INFO!F10*0.33)*100, IF(COUNTRY_INFO!K10=2, AD10/(COUNTRY_INFO!F10*0.5)*100, IF(COUNTRY_INFO!K10=3, AD10/COUNTRY_INFO!F10*100))),\"-\"),0)","v":100},{"$f":"IF(COUNTRY_INFO!K10=2,IF(COUNTRY_INFO!G10*0.2>MAX('T1'!N10,'T2'!L10),MAX('T1'!N10,'T2'!L10),COUNTRY_INFO!G10*0.2),IF(COUNTRY_INFO!K10=3,IF(COUNTRY_INFO!G10>MAX('T1'!N10,'T2'!L10),MAX('T1'!N10,'T2'!L10),COUNTRY_INFO!G10),0))","v":0},{"$f":"IF(AND(COUNTRY_INFO!K10>0,COUNTRY_INFO!K10<4),IF(Z10>0,IF(COUNTRY_INFO!K10=1, 0, IF(COUNTRY_INFO!K10=2, AF10/(COUNTRY_INFO!G10*0.2)*100, IF(COUNTRY_INFO!K10=3, AF10/COUNTRY_INFO!G10*100))),\"-\"),0)","v":0},{"$f":"SUM(AD10,AF10)","v":6133},{"$f":"IF(AND(COUNTRY_INFO!K10>0,COUNTRY_INFO!K10<4), IF(AC10/Z10*100<>0, IF(AH10/Z10*100>100,100,AH10/Z10*100), \"-\"),0)","v":52.907177363699098},null,{"$f":"IF(AND(D10<>0, D10<>\"Desconocido\",D10<>\"Suspendida\",D10<>\"No requerido\"),D10/COUNTRY_INFO!D10, 0)","v":1},{"$f":"IF(AND(J10<>0,J10<>\"Desconocido\",J10<>\"Suspendida\",J10<>\"No requerido\"),J10/COUNTRY_INFO!D10, 0)","v":0},{"$f":"IF(AND(P10<>0,P10<>\"Desconocido\",P10<>\"No requerido\"),P10/(COUNTRY_INFO!E10+COUNTRY_INFO!F10), 0)","v":1},{"$f":"IF(AND(Z10<>0,Z10<>\"Desconocido\",Z10<>\"No requerido\"),IF(COUNTRY_INFO!K10=1,1,IF(COUNTRY_INFO!K10=2,0.5*COUNTRY_INFO!F10/(0.5*COUNTRY_INFO!F10+0.2*COUNTRY_INFO!G10),IF(COUNTRY_INFO!K10=3,COUNTRY_INFO!F10/(COUNTRY_INFO!F10+COUNTRY_INFO!G10)))),0)","v":0.52907177363699098},{"$f":"IF(AND(Z10<>0,Z10<>\"Desconocido\",Z10<>\"No requerido\"),IF(COUNTRY_INFO!K10=1,0,IF(COUNTRY_INFO!K10=2,0.2*COUNTRY_INFO!G10/(0.5*COUNTRY_INFO!F10+0.2*COUNTRY_INFO!G10),IF(COUNTRY_INFO!K10=3,COUNTRY_INFO!G10/(COUNTRY_INFO!F10+COUNTRY_INFO!G10)))),0)","v":0.47092822636300896},{"$f":"MAX(COUNTRY_INFO!D10*AK10*PROFILE!$G$7,COUNTRY_INFO!D10*AL10*PROFILE!$G$7)","v":1498.1043298925235},{"$f":"MAX(COUNTRY_INFO!D10*AK10*PROFILE!$G$8,COUNTRY_INFO!D10*AL10*PROFILE!$G$8,COUNTRY_INFO!D10*AM10*PROFILE!$G$8)","v":5758.7429066516424},{"$f":"MAX(COUNTRY_INFO!D10*AK10*PROFILE!$G$9,COUNTRY_INFO!D10*AL10*PROFILE!$G$9,COUNTRY_INFO!D10*AM10*PROFILE!$G$9,IF(AND(DISTRICT!Z10<>\"Desconocido\",Z10<>\"No requerido\"),COUNTRY_INFO!O10*DISTRICT!AN10,0))","v":12266.289123709697},{"$f":"MAX(COUNTRY_INFO!D10*AK10*PROFILE!$G$10,COUNTRY_INFO!D10*AL10*PROFILE!$G$10,IF(AND(DISTRICT!Z10<>\"Desconocido\",Z10<>\"No requerido\"),COUNTRY_INFO!O10*DISTRICT!AO10,0))","v":27294.863639746141},{"$f":"SUM(AP10:AS10)","v":46818},0,{"$f":"MAX('MDA2'!J10,'T1'!L10,'T2'!J10,T3_R1!K10,T3_R2!K10)","v":0},{"$f":"MAX('MDA1'!K10,'MDA2'!K10,'MDA3'!I10,'MDA3'!L10,'T1'!M10,'T2'!K10,T3_R1!L10,T3_R2!L10)","v":8050},{"$f":"MAX('MDA1'!L10,'MDA2'!L10,'MDA3'!J10,'MDA3'!M10,'T1'!N10,'T2'!L10,T3_R1!M10,T3_R2!M10)","v":0},{"$f":"SUM(AV10:AX10)","v":8050},{"$f":"MAX('MDA2'!J10,T10)","v":0},{"$f":"MAX('MDA1'!K10,'MDA2'!K10,'MDA3'!I10,'MDA3'!L10,V10,AD10)","v":8050},{"$f":"MAX('MDA1'!L10,'MDA2'!L10,'MDA3'!J10,'MDA3'!M10,AF10)","v":0},8050,17.194241531035072]
[{"$f":"IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)","v":"Lobata "},{"$f":"COUNTRY_INFO!L11","v":20309},null,null,{"$f":"MAX('MDA1'!M11,'MDA2'!M11)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H11>0,COUNTRY_INFO!H11<4),IF(D11>MAX('MDA1'!M11,'MDA2'!M11),MAX('MDA1'!M11,'MDA2'!M11),D11),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H11>0,COUNTRY_INFO!H11<4), IF(G11/D11*100<>0, IF(G11/D11*100>100,100,G11/D11*100), \"-\"),0)","v":"-"},{"$f":"COUNTRY_INFO!M11","v":"No requerido"},null,null,{"$f":"MAX('MDA1'!M11,MAX('MDA3'!I11,'MDA3'!L11)+MAX('MDA3'!J11,'MDA3'!M11))","v":0},{"$f":"IF(AND(COUNTRY_INFO!I11>0,COUNTRY_INFO!I11<4),IF(J11>MAX('MDA1'!M11,MAX('MDA3'!I11,'MDA3'!L11)+MAX('MDA3'!J11,'MDA3'!M11)),MAX('MDA1'!M11,MAX('MDA3'!I11,'MDA3'!L11)+MAX('MDA3'!J11,'MDA3'!M11)),J11),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I11>0,COUNTRY_INFO!I11<4), IF(M11/J11*100<>0, IF(M11/J11*100>100,100,M11/J11*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!N11","v":7819},null,null,{"$f":"SUM(MAX('MDA2'!J11, 'T1'!L11, MAX(T3_R1!K11, T3_R2!K11)), MAX('MDA1'!K11, 'MDA2'!K11, 'T1'!M11, MAX(T3_R1!L11, T3_R2!L11)), MAX('MDA1'!L11, 'MDA2'!L11, 'T1'!N11, MAX(T3_R1!M11, T3_R2!M11)))","v":3941},{"$f":"IF(AND(COUNTRY_INFO!J11>1,COUNTRY_INFO!J11<4),IF(COUNTRY_INFO!E11>MAX('MDA2'!J11,'T1'!L11,MAX(T3_R1!K11,T3_R2!K11)),MAX('MDA2'!J11,'T1'!L11,MAX(T3_R1!K11,T3_R2!K11)),COUNTRY_INFO!E11),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J11>1,COUNTRY_INFO!J11<4), IF(T11/COUNTRY_INFO!E11*100<>0, IF(T11/COUNTRY_INFO!E11*100>100,100,T11/COUNTRY_INFO!E11*100), \"-\"),0)","v":"-"},{"$f":"IF(AND(COUNTRY_INFO!J11>1,COUNTRY_INFO!J11<4),IF(COUNTRY_INFO!F11>MAX('MDA1'!K11,'MDA2'!K11,'T1'!M11,MAX(T3_R1!L11,T3_R2!L11)),MAX('MDA1'!K11,'MDA2'!K11,'T1'!M11,MAX(T3_R1!L11,T3_R2!L11)),COUNTRY_INFO!F11),0)","v":3941},{"$f":"IF(AND(COUNTRY_INFO!J11>1,COUNTRY_INFO!J11<4), IF(V11/COUNTRY_INFO!F11*100<>0, IF(V11/COUNTRY_INFO!F11*100>100,100,V11/COUNTRY_INFO!F11*100), \"-\"),0)","v":74.065025371170833},3941,{"$f":"IF(AND(COUNTRY_INFO!J11>1,COUNTRY_INFO!J11<4), IF(S11/P11*100<>0, IF(X11/P11*100>100,100,X11/P11*100), \"-\"),0)","v":50.402864816472693},{"$f":"COUNTRY_INFO!O11","v":1755.93},null,null,{"$f":"MAX('T1'!L11,'T2'!J11)+MAX('T1'!M11,'T2'!K11)+MAX('T1'!N11,'T2'!L11)","v":3941},{"$f":"IF(COUNTRY_INFO!K11=1,IF(COUNTRY_INFO!F11*0.33>MAX('T1'!M11,'T2'!K11),MAX('T1'!M11,'T2'!K11),COUNTRY_INFO!F11*0.33),IF(COUNTRY_INFO!K11=2,IF(COUNTRY_INFO!F11*0.5>MAX('T1'!M11,'T2'!K11),MAX('T1'!M11,'T2'!K11),COUNTRY_INFO!F11*0.5),IF(COUNTRY_INFO!K11=3,IF(COUNTRY_INFO!F11>MAX('T1'!M11,'T2'!K11),MAX('T1'!M11,'T2'!K11),COUNTRY_INFO!F11),0)))","v":1755.93},{"$f":"IF(AND(COUNTRY_INFO!K11>0,COUNTRY_INFO!K11<4),IF(Z11>0,IF(COUNTRY_INFO!K11=1, AD11/(COUNTRY_INFO!F11*0.33)*100, IF(COUNTRY_INFO!K11=2, AD11/(COUNTRY_INFO!F11*0.5)*100, IF(COUNTRY_INFO!K11=3, AD11/COUNTRY_INFO!F11*100))),\"-\"),0)","v":100},{"$f":"IF(COUNTRY_INFO!K11=2,IF(COUNTRY_INFO!G11*0.2>MAX('T1'!N11,'T2'!L11),MAX('T1'!N11,'T2'!L11),COUNTRY_INFO!G11*0.2),IF(COUNTRY_INFO!K11=3,IF(COUNTRY_INFO!G11>MAX('T1'!N11,'T2'!L11),MAX('T1'!N11,'T2'!L11),COUNTRY_INFO!G11),0))","v":0},{"$f":"IF(AND(COUNTRY_INFO!K11>0,COUNTRY_INFO!K11<4),IF(Z11>0,IF(COUNTRY_INFO!K11=1, 0, IF(COUNTRY_INFO!K11=2, AF11/(COUNTRY_INFO!G11*0.2)*100, IF(COUNTRY_INFO!K11=3, AF11/COUNTRY_INFO!G11*100))),\"-\"),0)","v":0},1755.93,{"$f":"IF(AND(COUNTRY_INFO!K11>0,COUNTRY_INFO!K11<4), IF(AC11/Z11*100<>0, IF(AH11/Z11*100>100,100,AH11/Z11*100), \"-\"),0)","v":100},null,{"$f":"IF(AND(D11<>0, D11<>\"Desconocido\",D11<>\"Suspendida\",D11<>\"No requerido\"),D11/COUNTRY_INFO!D11, 0)","v":1},{"$f":"IF(AND(J11<>0,J11<>\"Desconocido\",J11<>\"Suspendida\",J11<>\"No requerido\"),J11/COUNTRY_INFO!D11, 0)","v":0},{"$f":"IF(AND(P11<>0,P11<>\"Desconocido\",P11<>\"No requerido\"),P11/(COUNTRY_INFO!E11+COUNTRY_INFO!F11), 0)","v":1},{"$f":"IF(AND(Z11<>0,Z11<>\"Desconocido\",Z11<>\"No requerido\"),IF(COUNTRY_INFO!K11=1,1,IF(COUNTRY_INFO!K11=2,0.5*COUNTRY_INFO!F11/(0.5*COUNTRY_INFO!F11+0.2*COUNTRY_INFO!G11),IF(COUNTRY_INFO!K11=3,COUNTRY_INFO!F11/(COUNTRY_INFO!F11+COUNTRY_INFO!G11)))),0)","v":1},{"$f":"IF(AND(Z11<>0,Z11<>\"Desconocido\",Z11<>\"No requerido\"),IF(COUNTRY_INFO!K11=1,0,IF(COUNTRY_INFO!K11=2,0.2*COUNTRY_INFO!G11/(0.5*COUNTRY_INFO!F11+0.2*COUNTRY_INFO!G11),IF(COUNTRY_INFO!K11=3,COUNTRY_INFO!G11/(COUNTRY_INFO!F11+COUNTRY_INFO!G11)))),0)","v":0},{"$f":"MAX(COUNTRY_INFO!D11*AK11*PROFILE!$G$7,COUNTRY_INFO!D11*AL11*PROFILE!$G$7)","v":649.85691049996285},{"$f":"MAX(COUNTRY_INFO!D11*AK11*PROFILE!$G$8,COUNTRY_INFO!D11*AL11*PROFILE!$G$8,COUNTRY_INFO!D11*AM11*PROFILE!$G$8)","v":2498.062917920206},{"$f":"MAX(COUNTRY_INFO!D11*AK11*PROFILE!$G$9,COUNTRY_INFO!D11*AL11*PROFILE!$G$9,COUNTRY_INFO!D11*AM11*PROFILE!$G$9,IF(AND(DISTRICT!Z11<>\"Desconocido\",Z11<>\"No requerido\"),COUNTRY_INFO!O11*DISTRICT!AN11,0))","v":5320.9463414374859},{"$f":"MAX(COUNTRY_INFO!D11*AK11*PROFILE!$G$10,COUNTRY_INFO!D11*AL11*PROFILE!$G$10,IF(AND(DISTRICT!Z11<>\"Desconocido\",Z11<>\"No requerido\"),COUNTRY_INFO!O11*DISTRICT!AO11,0))","v":11840.133830142346},20309,0,{"$f":"MAX('MDA2'!J11,'T1'!L11,'T2'!J11,T3_R1!K11,T3_R2!K11)","v":0},{"$f":"MAX('MDA1'!K11,'MDA2'!K11,'MDA3'!I11,'MDA3'!L11,'T1'!M11,'T2'!K11,T3_R1!L11,T3_R2!L11)","v":3941},{"$f":"MAX('MDA1'!L11,'MDA2'!L11,'MDA3'!J11,'MDA3'!M11,'T1'!N11,'T2'!L11,T3_R1!M11,T3_R2!M11)","v":0},3941,{"$f":"MAX('MDA2'!J11,T11)","v":0},{"$f":"MAX('MDA1'!K11,'MDA2'!K11,'MDA3'!I11,'MDA3'!L11,V11,AD11)","v":3941},{"$f":"MAX('MDA1'!L11,'MDA2'!L11,'MDA3'!J11,'MDA3'!M11,AF11)","v":0},3941,19.40518981732237]
[{"$f":"IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)","v":"Cantagalo"},{"$f":"COUNTRY_INFO!L12","v":18010},null,null,{"$f":"MAX('MDA1'!M12,'MDA2'!M12)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H12>0,COUNTRY_INFO!H12<4),IF(D12>MAX('MDA1'!M12,'MDA2'!M12),MAX('MDA1'!M12,'MDA2'!M12),D12),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H12>0,COUNTRY_INFO!H12<4), IF(G12/D12*100<>0, IF(G12/D12*100>100,100,G12/D12*100), \"-\"),0)","v":"-"},{"$f":"COUNTRY_INFO!M12","v":"No requerido"},null,null,{"$f":"MAX('MDA1'!M12,MAX('MDA3'!I12,'MDA3'!L12)+MAX('MDA3'!J12,'MDA3'!M12))","v":0},{"$f":"IF(AND(COUNTRY_INFO!I12>0,COUNTRY_INFO!I12<4),IF(J12>MAX('MDA1'!M12,MAX('MDA3'!I12,'MDA3'!L12)+MAX('MDA3'!J12,'MDA3'!M12)),MAX('MDA1'!M12,MAX('MDA3'!I12,'MDA3'!L12)+MAX('MDA3'!J12,'MDA3'!M12)),J12),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I12>0,COUNTRY_INFO!I12<4), IF(M12/J12*100<>0, IF(M12/J12*100>100,100,M12/J12*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!N12","v":6934},null,null,{"$f":"SUM(MAX('MDA2'!J12, 'T1'!L12, MAX(T3_R1!K12, T3_R2!K12)), MAX('MDA1'!K12, 'MDA2'!K12, 'T1'!M12, MAX(T3_R1!L12, T3_R2!L12)), MAX('MDA1'!L12, 'MDA2'!L12, 'T1'!N12, MAX(T3_R1!M12, T3_R2!M12)))","v":3244},{"$f":"IF(AND(COUNTRY_INFO!J12>1,COUNTRY_INFO!J12<4),IF(COUNTRY_INFO!E12>MAX('MDA2'!J12,'T1'!L12,MAX(T3_R1!K12,T3_R2!K12)),MAX('MDA2'!J12,'T1'!L12,MAX(T3_R1!K12,T3_R2!K12)),COUNTRY_INFO!E12),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J12>1,COUNTRY_INFO!J12<4), IF(T12/COUNTRY_INFO!E12*100<>0, IF(T12/COUNTRY_INFO!E12*100>100,100,T12/COUNTRY_INFO!E12*100), \"-\"),0)","v":"-"},{"$f":"IF(AND(COUNTRY_INFO!J12>1,COUNTRY_INFO!J12<4),IF(COUNTRY_INFO!F12>MAX('MDA1'!K12,'MDA2'!K12,'T1'!M12,MAX(T3_R1!L12,T3_R2!L12)),MAX('MDA1'!K12,'MDA2'!K12,'T1'!M12,MAX(T3_R1!L12,T3_R2!L12)),COUNTRY_INFO!F12),0)","v":3244},{"$f":"IF(AND(COUNTRY_INFO!J12>1,COUNTRY_INFO!J12<4), IF(V12/COUNTRY_INFO!F12*100<>0, IF(V12/COUNTRY_INFO!F12*100>100,100,V12/COUNTRY_INFO!F12*100), \"-\"),0)","v":68.743377834286918},3244,{"$f":"IF(AND(COUNTRY_INFO!J12>1,COUNTRY_INFO!J12<4), IF(S12/P12*100<>0, IF(X12/P12*100>100,100,X12/P12*100), \"-\"),0)","v":46.783963080473029},{"$f":"COUNTRY_INFO!O12","v":1557.27},null,null,{"$f":"MAX('T1'!L12,'T2'!J12)+MAX('T1'!M12,'T2'!K12)+MAX('T1'!N12,'T2'!L12)","v":3244},{"$f":"IF(COUNTRY_INFO!K12=1,IF(COUNTRY_INFO!F12*0.33>MAX('T1'!M12,'T2'!K12),MAX('T1'!M12,'T2'!K12),COUNTRY_INFO!F12*0.33),IF(COUNTRY_INFO!K12=2,IF(COUNTRY_INFO!F12*0.5>MAX('T1'!M12,'T2'!K12),MAX('T1'!M12,'T2'!K12),COUNTRY_INFO!F12*0.5),IF(COUNTRY_INFO!K12=3,IF(COUNTRY_INFO!F12>MAX('T1'!M12,'T2'!K12),MAX('T1'!M12,'T2'!K12),COUNTRY_INFO!F12),0)))","v":1557.27},{"$f":"IF(AND(COUNTRY_INFO!K12>0,COUNTRY_INFO!K12<4),IF(Z12>0,IF(COUNTRY_INFO!K12=1, AD12/(COUNTRY_INFO!F12*0.33)*100, IF(COUNTRY_INFO!K12=2, AD12/(COUNTRY_INFO!F12*0.5)*100, IF(COUNTRY_INFO!K12=3, AD12/COUNTRY_INFO!F12*100))),\"-\"),0)","v":100},{"$f":"IF(COUNTRY_INFO!K12=2,IF(COUNTRY_INFO!G12*0.2>MAX('T1'!N12,'T2'!L12),MAX('T1'!N12,'T2'!L12),COUNTRY_INFO!G12*0.2),IF(COUNTRY_INFO!K12=3,IF(COUNTRY_INFO!G12>MAX('T1'!N12,'T2'!L12),MAX('T1'!N12,'T2'!L12),COUNTRY_INFO!G12),0))","v":0},{"$f":"IF(AND(COUNTRY_INFO!K12>0,COUNTRY_INFO!K12<4),IF(Z12>0,IF(COUNTRY_INFO!K12=1, 0, IF(COUNTRY_INFO!K12=2, AF12/(COUNTRY_INFO!G12*0.2)*100, IF(COUNTRY_INFO!K12=3, AF12/COUNTRY_INFO!G12*100))),\"-\"),0)","v":0},1557.27,{"$f":"IF(AND(COUNTRY_INFO!K12>0,COUNTRY_INFO!K12<4), IF(AC12/Z12*100<>0, IF(AH12/Z12*100>100,100,AH12/Z12*100), \"-\"),0)","v":100},null,{"$f":"IF(AND(D12<>0, D12<>\"Desconocido\",D12<>\"Suspendida\",D12<>\"No requerido\"),D12/COUNTRY_INFO!D12, 0)","v":1},{"$f":"IF(AND(J12<>0,J12<>\"Desconocido\",J12<>\"Suspendida\",J12<>\"No requerido\"),J12/COUNTRY_INFO!D12, 0)","v":0},{"$f":"IF(AND(P12<>0,P12<>\"Desconocido\",P12<>\"No requerido\"),P12/(COUNTRY_INFO!E12+COUNTRY_INFO!F12), 0)","v":1},{"$f":"IF(AND(Z12<>0,Z12<>\"Desconocido\",Z12<>\"No requerido\"),IF(COUNTRY_INFO!K12=1,1,IF(COUNTRY_INFO!K12=2,0.5*COUNTRY_INFO!F12/(0.5*COUNTRY_INFO!F12+0.2*COUNTRY_INFO!G12),IF(COUNTRY_INFO!K12=3,COUNTRY_INFO!F12/(COUNTRY_INFO!F12+COUNTRY_INFO!G12)))),0)","v":1},{"$f":"IF(AND(Z12<>0,Z12<>\"Desconocido\",Z12<>\"No requerido\"),IF(COUNTRY_INFO!K12=1,0,IF(COUNTRY_INFO!K12=2,0.2*COUNTRY_INFO!G12/(0.5*COUNTRY_INFO!F12+0.2*COUNTRY_INFO!G12),IF(COUNTRY_INFO!K12=3,COUNTRY_INFO!G12/(COUNTRY_INFO!F12+COUNTRY_INFO!G12)))),0)","v":0},{"$f":"MAX(COUNTRY_INFO!D12*AK12*PROFILE!$G$7,COUNTRY_INFO!D12*AL12*PROFILE!$G$7)","v":576.29242986382053},{"$f":"MAX(COUNTRY_INFO!D12*AK12*PROFILE!$G$8,COUNTRY_INFO!D12*AL12*PROFILE!$G$8,COUNTRY_INFO!D12*AM12*PROFILE!$G$8)","v":2215.2795879532673},{"$f":"MAX(COUNTRY_INFO!D12*AK12*PROFILE!$G$9,COUNTRY_INFO!D12*AL12*PROFILE!$G$9,COUNTRY_INFO!D12*AM12*PROFILE!$G$9,IF(AND(DISTRICT!Z12<>\"Desconocido\",Z12<>\"No requerido\"),COUNTRY_INFO!O12*DISTRICT!AN12,0))","v":4718.6096611989324},{"$f":"MAX(COUNTRY_INFO!D12*AK12*PROFILE!$G$10,COUNTRY_INFO!D12*AL12*PROFILE!$G$10,IF(AND(DISTRICT!Z12<>\"Desconocido\",Z12<>\"No requerido\"),COUNTRY_INFO!O12*DISTRICT!AO12,0))","v":10499.818320983981},18010,0,{"$f":"MAX('MDA2'!J12,'T1'!L12,'T2'!J12,T3_R1!K12,T3_R2!K12)","v":0},{"$f":"MAX('MDA1'!K12,'MDA2'!K12,'MDA3'!I12,'MDA3'!L12,'T1'!M12,'T2'!K12,T3_R1!L12,T3_R2!L12)","v":3244},{"$f":"MAX('MDA1'!L12,'MDA2'!L12,'MDA3'!J12,'MDA3'!M12,'T1'!N12,'T2'!L12,T3_R1!M12,T3_R2!M12)","v":0},3244,{"$f":"MAX('MDA2'!J12,T12)","v":0},{"$f":"MAX('MDA1'!K12,'MDA2'!K12,'MDA3'!I12,'MDA3'!L12,V12,AD12)","v":3244},{"$f":"MAX('MDA1'!L12,'MDA2'!L12,'MDA3'!J12,'MDA3'!M12,AF12)","v":0},3244,18.01221543586896]
[{"$f":"IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)","v":"Lemba"},{"$f":"COUNTRY_INFO!L13","v":15558},null,null,{"$f":"MAX('MDA1'!M13,'MDA2'!M13)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H13>0,COUNTRY_INFO!H13<4),IF(D13>MAX('MDA1'!M13,'MDA2'!M13),MAX('MDA1'!M13,'MDA2'!M13),D13),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H13>0,COUNTRY_INFO!H13<4), IF(G13/D13*100<>0, IF(G13/D13*100>100,100,G13/D13*100), \"-\"),0)","v":"-"},{"$f":"COUNTRY_INFO!M13","v":"No requerido"},null,null,{"$f":"MAX('MDA1'!M13,MAX('MDA3'!I13,'MDA3'!L13)+MAX('MDA3'!J13,'MDA3'!M13))","v":0},{"$f":"IF(AND(COUNTRY_INFO!I13>0,COUNTRY_INFO!I13<4),IF(J13>MAX('MDA1'!M13,MAX('MDA3'!I13,'MDA3'!L13)+MAX('MDA3'!J13,'MDA3'!M13)),MAX('MDA1'!M13,MAX('MDA3'!I13,'MDA3'!L13)+MAX('MDA3'!J13,'MDA3'!M13)),J13),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I13>0,COUNTRY_INFO!I13<4), IF(M13/J13*100<>0, IF(M13/J13*100>100,100,M13/J13*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!N13","v":5990},null,null,{"$f":"SUM(MAX('MDA2'!J13, 'T1'!L13, MAX(T3_R1!K13, T3_R2!K13)), MAX('MDA1'!K13, 'MDA2'!K13, 'T1'!M13, MAX(T3_R1!L13, T3_R2!L13)), MAX('MDA1'!L13, 'MDA2'!L13, 'T1'!N13, MAX(T3_R1!M13, T3_R2!M13)))","v":2927},{"$f":"IF(AND(COUNTRY_INFO!J13>1,COUNTRY_INFO!J13<4),IF(COUNTRY_INFO!E13>MAX('MDA2'!J13,'T1'!L13,MAX(T3_R1!K13,T3_R2!K13)),MAX('MDA2'!J13,'T1'!L13,MAX(T3_R1!K13,T3_R2!K13)),COUNTRY_INFO!E13),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J13>1,COUNTRY_INFO!J13<4), IF(T13/COUNTRY_INFO!E13*100<>0, IF(T13/COUNTRY_INFO!E13*100>100,100,T13/COUNTRY_INFO!E13*100), \"-\"),0)","v":"-"},{"$f":"IF(AND(COUNTRY_INFO!J13>1,COUNTRY_INFO!J13<4),IF(COUNTRY_INFO!F13>MAX('MDA1'!K13,'MDA2'!K13,'T1'!M13,MAX(T3_R1!L13,T3_R2!L13)),MAX('MDA1'!K13,'MDA2'!K13,'T1'!M13,MAX(T3_R1!L13,T3_R2!L13)),COUNTRY_INFO!F13),0)","v":2927},{"$f":"IF(AND(COUNTRY_INFO!J13>1,COUNTRY_INFO!J13<4), IF(V13/COUNTRY_INFO!F13*100<>0, IF(V13/COUNTRY_INFO!F13*100>100,100,V13/COUNTRY_INFO!F13*100), \"-\"),0)","v":71.810598626104024},2927,{"$f":"IF(AND(COUNTRY_INFO!J13>1,COUNTRY_INFO!J13<4), IF(S13/P13*100<>0, IF(X13/P13*100>100,100,X13/P13*100), \"-\"),0)","v":48.864774624373958},{"$f":"COUNTRY_INFO!O13","v":1345.0800000000002},null,null,{"$f":"MAX('T1'!L13,'T2'!J13)+MAX('T1'!M13,'T2'!K13)+MAX('T1'!N13,'T2'!L13)","v":2927},{"$f":"IF(COUNTRY_INFO!K13=1,IF(COUNTRY_INFO!F13*0.33>MAX('T1'!M13,'T2'!K13),MAX('T1'!M13,'T2'!K13),COUNTRY_INFO!F13*0.33),IF(COUNTRY_INFO!K13=2,IF(COUNTRY_INFO!F13*0.5>MAX('T1'!M13,'T2'!K13),MAX('T1'!M13,'T2'!K13),COUNTRY_INFO!F13*0.5),IF(COUNTRY_INFO!K13=3,IF(COUNTRY_INFO!F13>MAX('T1'!M13,'T2'!K13),MAX('T1'!M13,'T2'!K13),COUNTRY_INFO!F13),0)))","v":1345.0800000000002},{"$f":"IF(AND(COUNTRY_INFO!K13>0,COUNTRY_INFO!K13<4),IF(Z13>0,IF(COUNTRY_INFO!K13=1, AD13/(COUNTRY_INFO!F13*0.33)*100, IF(COUNTRY_INFO!K13=2, AD13/(COUNTRY_INFO!F13*0.5)*100, IF(COUNTRY_INFO!K13=3, AD13/COUNTRY_INFO!F13*100))),\"-\"),0)","v":100},{"$f":"IF(COUNTRY_INFO!K13=2,IF(COUNTRY_INFO!G13*0.2>MAX('T1'!N13,'T2'!L13),MAX('T1'!N13,'T2'!L13),COUNTRY_INFO!G13*0.2),IF(COUNTRY_INFO!K13=3,IF(COUNTRY_INFO!G13>MAX('T1'!N13,'T2'!L13),MAX('T1'!N13,'T2'!L13),COUNTRY_INFO!G13),0))","v":0},{"$f":"IF(AND(COUNTRY_INFO!K13>0,COUNTRY_INFO!K13<4),IF(Z13>0,IF(COUNTRY_INFO!K13=1, 0, IF(COUNTRY_INFO!K13=2, AF13/(COUNTRY_INFO!G13*0.2)*100, IF(COUNTRY_INFO!K13=3, AF13/COUNTRY_INFO!G13*100))),\"-\"),0)","v":0},1345.0800000000002,{"$f":"IF(AND(COUNTRY_INFO!K13>0,COUNTRY_INFO!K13<4), IF(AC13/Z13*100<>0, IF(AH13/Z13*100>100,100,AH13/Z13*100), \"-\"),0)","v":100},null,{"$f":"IF(AND(D13<>0, D13<>\"Desconocido\",D13<>\"Suspendida\",D13<>\"No requerido\"),D13/COUNTRY_INFO!D13, 0)","v":1},{"$f":"IF(AND(J13<>0,J13<>\"Desconocido\",J13<>\"Suspendida\",J13<>\"No requerido\"),J13/COUNTRY_INFO!D13, 0)","v":0},{"$f":"IF(AND(P13<>0,P13<>\"Desconocido\",P13<>\"No requerido\"),P13/(COUNTRY_INFO!E13+COUNTRY_INFO!F13), 0)","v":1},{"$f":"IF(AND(Z13<>0,Z13<>\"Desconocido\",Z13<>\"No requerido\"),IF(COUNTRY_INFO!K13=1,1,IF(COUNTRY_INFO!K13=2,0.5*COUNTRY_INFO!F13/(0.5*COUNTRY_INFO!F13+0.2*COUNTRY_INFO!G13),IF(COUNTRY_INFO!K13=3,COUNTRY_INFO!F13/(COUNTRY_INFO!F13+COUNTRY_INFO!G13)))),0)","v":1},{"$f":"IF(AND(Z13<>0,Z13<>\"Desconocido\",Z13<>\"No requerido\"),IF(COUNTRY_INFO!K13=1,0,IF(COUNTRY_INFO!K13=2,0.2*COUNTRY_INFO!G13/(0.5*COUNTRY_INFO!F13+0.2*COUNTRY_INFO!G13),IF(COUNTRY_INFO!K13=3,COUNTRY_INFO!G13/(COUNTRY_INFO!F13+COUNTRY_INFO!G13)))),0)","v":0},{"$f":"MAX(COUNTRY_INFO!D13*AK13*PROFILE!$G$7,COUNTRY_INFO!D13*AL13*PROFILE!$G$7)","v":497.83218344371568},{"$f":"MAX(COUNTRY_INFO!D13*AK13*PROFILE!$G$8,COUNTRY_INFO!D13*AL13*PROFILE!$G$8,COUNTRY_INFO!D13*AM13*PROFILE!$G$8)","v":1913.6768367227614},{"$f":"MAX(COUNTRY_INFO!D13*AK13*PROFILE!$G$9,COUNTRY_INFO!D13*AL13*PROFILE!$G$9,COUNTRY_INFO!D13*AM13*PROFILE!$G$9,IF(AND(DISTRICT!Z13<>\"Desconocido\",Z13<>\"No requerido\"),COUNTRY_INFO!O13*DISTRICT!AN13,0))","v":4076.1870687913934},{"$f":"MAX(COUNTRY_INFO!D13*AK13*PROFILE!$G$10,COUNTRY_INFO!D13*AL13*PROFILE!$G$10,IF(AND(DISTRICT!Z13<>\"Desconocido\",Z13<>\"No requerido\"),COUNTRY_INFO!O13*DISTRICT!AO13,0))","v":9070.3039110421305},15558,0,{"$f":"MAX('MDA2'!J13,'T1'!L13,'T2'!J13,T3_R1!K13,T3_R2!K13)","v":0},{"$f":"MAX('MDA1'!K13,'MDA2'!K13,'MDA3'!I13,'MDA3'!L13,'T1'!M13,'T2'!K13,T3_R1!L13,T3_R2!L13)","v":2927},{"$f":"MAX('MDA1'!L13,'MDA2'!L13,'MDA3'!J13,'MDA3'!M13,'T1'!N13,'T2'!L13,T3_R1!M13,T3_R2!M13)","v":0},2927,{"$f":"MAX('MDA2'!J13,T13)","v":0},{"$f":"MAX('MDA1'!K13,'MDA2'!K13,'MDA3'!I13,'MDA3'!L13,V13,AD13)","v":2927},{"$f":"MAX('MDA1'!L13,'MDA2'!L13,'MDA3'!J13,'MDA3'!M13,AF13)","v":0},2927,18.81347216865921]
[{"$f":"IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)","v":"ST"},{"$f":"IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)","v":"Cauè "},{"$f":"COUNTRY_INFO!L14","v":6162},null,null,{"$f":"MAX('MDA1'!M14,'MDA2'!M14)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H14>0,COUNTRY_INFO!H14<4),IF(D14>MAX('MDA1'!M14,'MDA2'!M14),MAX('MDA1'!M14,'MDA2'!M14),D14),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H14>0,COUNTRY_INFO!H14<4), IF(G14/D14*100<>0, IF(G14/D14*100>100,100,G14/D14*100), \"-\"),0)","v":"-"},{"$f":"COUNTRY_INFO!M14","v":"No requerido"},null,null,{"$f":"MAX('MDA1'!M14,MAX('MDA3'!I14,'MDA3'!L14)+MAX('MDA3'!J14,'MDA3'!M14))","v":0},{"$f":"IF(AND(COUNTRY_INFO!I14>0,COUNTRY_INFO!I14<4),IF(J14>MAX('MDA1'!M14,MAX('MDA3'!I14,'MDA3'!L14)+MAX('MDA3'!J14,'MDA3'!M14)),MAX('MDA1'!M14,MAX('MDA3'!I14,'MDA3'!L14)+MAX('MDA3'!J14,'MDA3'!M14)),J14),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I14>0,COUNTRY_INFO!I14<4), IF(M14/J14*100<>0, IF(M14/J14*100>100,100,M14/J14*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!N14","v":2372},null,null,{"$f":"SUM(MAX('MDA2'!J14, 'T1'!L14, MAX(T3_R1!K14, T3_R2!K14)), MAX('MDA1'!K14, 'MDA2'!K14, 'T1'!M14, MAX(T3_R1!L14, T3_R2!L14)), MAX('MDA1'!L14, 'MDA2'!L14, 'T1'!N14, MAX(T3_R1!M14, T3_R2!M14)))","v":1256},{"$f":"IF(AND(COUNTRY_INFO!J14>1,COUNTRY_INFO!J14<4),IF(COUNTRY_INFO!E14>MAX('MDA2'!J14,'T1'!L14,MAX(T3_R1!K14,T3_R2!K14)),MAX('MDA2'!J14,'T1'!L14,MAX(T3_R1!K14,T3_R2!K14)),COUNTRY_INFO!E14),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J14>1,COUNTRY_INFO!J14<4), IF(T14/COUNTRY_INFO!E14*100<>0, IF(T14/COUNTRY_INFO!E14*100>100,100,T14/COUNTRY_INFO!E14*100), \"-\"),0)","v":"-"},{"$f":"IF(AND(COUNTRY_INFO!J14>1,COUNTRY_INFO!J14<4),IF(COUNTRY_INFO!F14>MAX('MDA1'!K14,'MDA2'!K14,'T1'!M14,MAX(T3_R1!L14,T3_R2!L14)),MAX('MDA1'!K14,'MDA2'!K14,'T1'!M14,MAX(T3_R1!L14,T3_R2!L14)),COUNTRY_INFO!F14),0)","v":1256},{"$f":"IF(AND(COUNTRY_INFO!J14>1,COUNTRY_INFO!J14<4), IF(V14/COUNTRY_INFO!F14*100<>0, IF(V14/COUNTRY_INFO!F14*100>100,100,V14/COUNTRY_INFO!F14*100), \"-\"),0)","v":77.819083023543982},1256,{"$f":"IF(AND(COUNTRY_INFO!J14>1,COUNTRY_INFO!J14<4), IF(S14/P14*100<>0, IF(X14/P14*100>100,100,X14/P14*100), \"-\"),0)","v":52.951096121416526},{"$f":"COUNTRY_INFO!O14","v":532.62},null,null,{"$f":"MAX('T1'!L14,'T2'!J14)+MAX('T1'!M14,'T2'!K14)+MAX('T1'!N14,'T2'!L14)","v":1256},{"$f":"IF(COUNTRY_INFO!K14=1,IF(COUNTRY_INFO!F14*0.33>MAX('T1'!M14,'T2'!K14),MAX('T1'!M14,'T2'!K14),COUNTRY_INFO!F14*0.33),IF(COUNTRY_INFO!K14=2,IF(COUNTRY_INFO!F14*0.5>MAX('T1'!M14,'T2'!K14),MAX('T1'!M14,'T2'!K14),COUNTRY_INFO!F14*0.5),IF(COUNTRY_INFO!K14=3,IF(COUNTRY_INFO!F14>MAX('T1'!M14,'T2'!K14),MAX('T1'!M14,'T2'!K14),COUNTRY_INFO!F14),0)))","v":532.62},{"$f":"IF(AND(COUNTRY_INFO!K14>0,COUNTRY_INFO!K14<4),IF(Z14>0,IF(COUNTRY_INFO!K14=1, AD14/(COUNTRY_INFO!F14*0.33)*100, IF(COUNTRY_INFO!K14=2, AD14/(COUNTRY_INFO!F14*0.5)*100, IF(COUNTRY_INFO!K14=3, AD14/COUNTRY_INFO!F14*100))),\"-\"),0)","v":100},{"$f":"IF(COUNTRY_INFO!K14=2,IF(COUNTRY_INFO!G14*0.2>MAX('T1'!N14,'T2'!L14),MAX('T1'!N14,'T2'!L14),COUNTRY_INFO!G14*0.2),IF(COUNTRY_INFO!K14=3,IF(COUNTRY_INFO!G14>MAX('T1'!N14,'T2'!L14),MAX('T1'!N14,'T2'!L14),COUNTRY_INFO!G14),0))","v":0},{"$f":"IF(AND(COUNTRY_INFO!K14>0,COUNTRY_INFO!K14<4),IF(Z14>0,IF(COUNTRY_INFO!K14=1, 0, IF(COUNTRY_INFO!K14=2, AF14/(COUNTRY_INFO!G14*0.2)*100, IF(COUNTRY_INFO!K14=3, AF14/COUNTRY_INFO!G14*100))),\"-\"),0)","v":0},532.62,{"$f":"IF(AND(COUNTRY_INFO!K14>0,COUNTRY_INFO!K14<4), IF(AC14/Z14*100<>0, IF(AH14/Z14*100>100,100,AH14/Z14*100), \"-\"),0)","v":100},null,{"$f":"IF(AND(D14<>0, D14<>\"Desconocido\",D14<>\"Suspendida\",D14<>\"No requerido\"),D14/COUNTRY_INFO!D14, 0)","v":1},{"$f":"IF(AND(J14<>0,J14<>\"Desconocido\",J14<>\"Suspendida\",J14<>\"No requerido\"),J14/COUNTRY_INFO!D14, 0)","v":0},{"$f":"IF(AND(P14<>0,P14<>\"Desconocido\",P14<>\"No requerido\"),P14/(COUNTRY_INFO!E14+COUNTRY_INFO!F14), 0)","v":1},{"$f":"IF(AND(Z14<>0,Z14<>\"Desconocido\",Z14<>\"No requerido\"),IF(COUNTRY_INFO!K14=1,1,IF(COUNTRY_INFO!K14=2,0.5*COUNTRY_INFO!F14/(0.5*COUNTRY_INFO!F14+0.2*COUNTRY_INFO!G14),IF(COUNTRY_INFO!K14=3,COUNTRY_INFO!F14/(COUNTRY_INFO!F14+COUNTRY_INFO!G14)))),0)","v":1},{"$f":"IF(AND(Z14<>0,Z14<>\"Desconocido\",Z14<>\"No requerido\"),IF(COUNTRY_INFO!K14=1,0,IF(COUNTRY_INFO!K14=2,0.2*COUNTRY_INFO!G14/(0.5*COUNTRY_INFO!F14+0.2*COUNTRY_INFO!G14),IF(COUNTRY_INFO!K14=3,COUNTRY_INFO!G14/(COUNTRY_INFO!F14+COUNTRY_INFO!G14)))),0)","v":0},{"$f":"MAX(COUNTRY_INFO!D14*AK14*PROFILE!$G$7,COUNTRY_INFO!D14*AL14*PROFILE!$G$7)","v":197.17456706390129},{"$f":"MAX(COUNTRY_INFO!D14*AK14*PROFILE!$G$8,COUNTRY_INFO!D14*AL14*PROFILE!$G$8,COUNTRY_INFO!D14*AM14*PROFILE!$G$8)","v":757.94296618367764},{"$f":"MAX(COUNTRY_INFO!D14*AK14*PROFILE!$G$9,COUNTRY_INFO!D14*AL14*PROFILE!$G$9,COUNTRY_INFO!D14*AM14*PROFILE!$G$9,IF(AND(DISTRICT!Z14<>\"Desconocido\",Z14<>\"No requerido\"),COUNTRY_INFO!O14*DISTRICT!AN14,0))","v":1614.4404626489629},{"$f":"MAX(COUNTRY_INFO!D14*AK14*PROFILE!$G$10,COUNTRY_INFO!D14*AL14*PROFILE!$G$10,IF(AND(DISTRICT!Z14<>\"Desconocido\",Z14<>\"No requerido\"),COUNTRY_INFO!O14*DISTRICT!AO14,0))","v":3592.4420041034582},6162,0,{"$f":"MAX('MDA2'!J14,'T1'!L14,'T2'!J14,T3_R1!K14,T3_R2!K14)","v":0},{"$f":"MAX('MDA1'!K14,'MDA2'!K14,'MDA3'!I14,'MDA3'!L14,'T1'!M14,'T2'!K14,T3_R1!L14,T3_R2!L14)","v":1256},{"$f":"MAX('MDA1'!L14,'MDA2'!L14,'MDA3'!J14,'MDA3'!M14,'T1'!N14,'T2'!L14,T3_R1!M14,T3_R2!M14)","v":0},1256,{"$f":"MAX('MDA2'!J14,T14)","v":0},{"$f":"MAX('MDA1'!K14,'MDA2'!K14,'MDA3'!I14,'MDA3'!L14,V14,AD14)","v":1256},{"$f":"MAX('MDA1'!L14,'MDA2'!L14,'MDA3'!J14,'MDA3'!M14,AF14)","v":0},1256,20.382992534891269]
[{"$f":"IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)","v":"STP"},{"$f":"IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)","v":"Principe"},{"$f":"IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)","v":"Píncipe"},{"$f":"COUNTRY_INFO!L15","v":7629},null,null,{"$f":"MAX('MDA1'!M15,'MDA2'!M15)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H15>0,COUNTRY_INFO!H15<4),IF(D15>MAX('MDA1'!M15,'MDA2'!M15),MAX('MDA1'!M15,'MDA2'!M15),D15),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!H15>0,COUNTRY_INFO!H15<4), IF(G15/D15*100<>0, IF(G15/D15*100>100,100,G15/D15*100), \"-\"),0)","v":"-"},{"$f":"COUNTRY_INFO!M15","v":"No requerido"},null,null,{"$f":"MAX('MDA1'!M15,MAX('MDA3'!I15,'MDA3'!L15)+MAX('MDA3'!J15,'MDA3'!M15))","v":0},{"$f":"IF(AND(COUNTRY_INFO!I15>0,COUNTRY_INFO!I15<4),IF(J15>MAX('MDA1'!M15,MAX('MDA3'!I15,'MDA3'!L15)+MAX('MDA3'!J15,'MDA3'!M15)),MAX('MDA1'!M15,MAX('MDA3'!I15,'MDA3'!L15)+MAX('MDA3'!J15,'MDA3'!M15)),J15),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!I15>0,COUNTRY_INFO!I15<4), IF(M15/J15*100<>0, IF(M15/J15*100>100,100,M15/J15*100), \"-\"),0)","v":0},{"$f":"COUNTRY_INFO!N15","v":2937},null,null,{"$f":"SUM(MAX('MDA2'!J15, 'T1'!L15, MAX(T3_R1!K15, T3_R2!K15)), MAX('MDA1'!K15, 'MDA2'!K15, 'T1'!M15, MAX(T3_R1!L15, T3_R2!L15)), MAX('MDA1'!L15, 'MDA2'!L15, 'T1'!N15, MAX(T3_R1!M15, T3_R2!M15)))","v":2064},{"$f":"IF(AND(COUNTRY_INFO!J15>1,COUNTRY_INFO!J15<4),IF(COUNTRY_INFO!E15>MAX('MDA2'!J15,'T1'!L15,MAX(T3_R1!K15,T3_R2!K15)),MAX('MDA2'!J15,'T1'!L15,MAX(T3_R1!K15,T3_R2!K15)),COUNTRY_INFO!E15),0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!J15>1,COUNTRY_INFO!J15<4), IF(T15/COUNTRY_INFO!E15*100<>0, IF(T15/COUNTRY_INFO!E15*100>100,100,T15/COUNTRY_INFO!E15*100), \"-\"),0)","v":"-"},{"$f":"IF(AND(COUNTRY_INFO!J15>1,COUNTRY_INFO!J15<4),IF(COUNTRY_INFO!F15>MAX('MDA1'!K15,'MDA2'!K15,'T1'!M15,MAX(T3_R1!L15,T3_R2!L15)),MAX('MDA1'!K15,'MDA2'!K15,'T1'!M15,MAX(T3_R1!L15,T3_R2!L15)),COUNTRY_INFO!F15),0)","v":1999},{"$f":"IF(AND(COUNTRY_INFO!J15>1,COUNTRY_INFO!J15<4), IF(V15/COUNTRY_INFO!F15*100<>0, IF(V15/COUNTRY_INFO!F15*100>100,100,V15/COUNTRY_INFO!F15*100), \"-\"),0)","v":100},1999,{"$f":"IF(AND(COUNTRY_INFO!J15>1,COUNTRY_INFO!J15<4), IF(S15/P15*100<>0, IF(X15/P15*100>100,100,X15/P15*100), \"-\"),0)","v":68.062648961525369},{"$f":"COUNTRY_INFO!O15","v":659.67000000000007},null,null,{"$f":"MAX('T1'!L15,'T2'!J15)+MAX('T1'!M15,'T2'!K15)+MAX('T1'!N15,'T2'!L15)","v":2064},{"$f":"IF(COUNTRY_INFO!K15=1,IF(COUNTRY_INFO!F15*0.33>MAX('T1'!M15,'T2'!K15),MAX('T1'!M15,'T2'!K15),COUNTRY_INFO!F15*0.33),IF(COUNTRY_INFO!K15=2,IF(COUNTRY_INFO!F15*0.5>MAX('T1'!M15,'T2'!K15),MAX('T1'!M15,'T2'!K15),COUNTRY_INFO!F15*0.5),IF(COUNTRY_INFO!K15=3,IF(COUNTRY_INFO!F15>MAX('T1'!M15,'T2'!K15),MAX('T1'!M15,'T2'!K15),COUNTRY_INFO!F15),0)))","v":659.67000000000007},{"$f":"IF(AND(COUNTRY_INFO!K15>0,COUNTRY_INFO!K15<4),IF(Z15>0,IF(COUNTRY_INFO!K15=1, AD15/(COUNTRY_INFO!F15*0.33)*100, IF(COUNTRY_INFO!K15=2, AD15/(COUNTRY_INFO!F15*0.5)*100, IF(COUNTRY_INFO!K15=3, AD15/COUNTRY_INFO!F15*100))),\"-\"),0)","v":100},{"$f":"IF(COUNTRY_INFO!K15=2,IF(COUNTRY_INFO!G15*0.2>MAX('T1'!N15,'T2'!L15),MAX('T1'!N15,'T2'!L15),COUNTRY_INFO!G15*0.2),IF(COUNTRY_INFO!K15=3,IF(COUNTRY_INFO!G15>MAX('T1'!N15,'T2'!L15),MAX('T1'!N15,'T2'!L15),COUNTRY_INFO!G15),0))","v":0},{"$f":"IF(AND(COUNTRY_INFO!K15>0,COUNTRY_INFO!K15<4),IF(Z15>0,IF(COUNTRY_INFO!K15=1, 0, IF(COUNTRY_INFO!K15=2, AF15/(COUNTRY_INFO!G15*0.2)*100, IF(COUNTRY_INFO!K15=3, AF15/COUNTRY_INFO!G15*100))),\"-\"),0)","v":0},659.67000000000007,{"$f":"IF(AND(COUNTRY_INFO!K15>0,COUNTRY_INFO!K15<4), IF(AC15/Z15*100<>0, IF(AH15/Z15*100>100,100,AH15/Z15*100), \"-\"),0)","v":100},null,{"$f":"IF(AND(D15<>0, D15<>\"Desconocido\",D15<>\"Suspendida\",D15<>\"No requerido\"),D15/COUNTRY_INFO!D15, 0)","v":1},{"$f":"IF(AND(J15<>0,J15<>\"Desconocido\",J15<>\"Suspendida\",J15<>\"No requerido\"),J15/COUNTRY_INFO!D15, 0)","v":0},{"$f":"IF(AND(P15<>0,P15<>\"Desconocido\",P15<>\"No requerido\"),P15/(COUNTRY_INFO!E15+COUNTRY_INFO!F15), 0)","v":1},{"$f":"IF(AND(Z15<>0,Z15<>\"Desconocido\",Z15<>\"No requerido\"),IF(COUNTRY_INFO!K15=1,1,IF(COUNTRY_INFO!K15=2,0.5*COUNTRY_INFO!F15/(0.5*COUNTRY_INFO!F15+0.2*COUNTRY_INFO!G15),IF(COUNTRY_INFO!K15=3,COUNTRY_INFO!F15/(COUNTRY_INFO!F15+COUNTRY_INFO!G15)))),0)","v":1},{"$f":"IF(AND(Z15<>0,Z15<>\"Desconocido\",Z15<>\"No requerido\"),IF(COUNTRY_INFO!K15=1,0,IF(COUNTRY_INFO!K15=2,0.2*COUNTRY_INFO!G15/(0.5*COUNTRY_INFO!F15+0.2*COUNTRY_INFO!G15),IF(COUNTRY_INFO!K15=3,COUNTRY_INFO!G15/(COUNTRY_INFO!F15+COUNTRY_INFO!G15)))),0)","v":0},{"$f":"MAX(COUNTRY_INFO!D15*AK15*PROFILE!$G$7,COUNTRY_INFO!D15*AL15*PROFILE!$G$7)","v":244.11632134542404},{"$f":"MAX(COUNTRY_INFO!D15*AK15*PROFILE!$G$8,COUNTRY_INFO!D15*AL15*PROFILE!$G$8,COUNTRY_INFO!D15*AM15*PROFILE!$G$8)","v":938.38800535788323},{"$f":"MAX(COUNTRY_INFO!D15*AK15*PROFILE!$G$9,COUNTRY_INFO!D15*AL15*PROFILE!$G$9,COUNTRY_INFO!D15*AM15*PROFILE!$G$9,IF(AND(DISTRICT!Z15<>\"Desconocido\",Z15<>\"No requerido\"),COUNTRY_INFO!O15*DISTRICT!AN15,0))","v":1998.7936205045341},{"$f":"MAX(COUNTRY_INFO!D15*AK15*PROFILE!$G$10,COUNTRY_INFO!D15*AL15*PROFILE!$G$10,IF(AND(DISTRICT!Z15<>\"Desconocido\",Z15<>\"No requerido\"),COUNTRY_INFO!O15*DISTRICT!AO15,0))","v":4447.7020527921595},7629.0000000000009,0,{"$f":"MAX('MDA2'!J15,'T1'!L15,'T2'!J15,T3_R1!K15,T3_R2!K15)","v":0},{"$f":"MAX('MDA1'!K15,'MDA2'!K15,'MDA3'!I15,'MDA3'!L15,'T1'!M15,'T2'!K15,T3_R1!L15,T3_R2!L15)","v":2064},{"$f":"MAX('MDA1'!L15,'MDA2'!L15,'MDA3'!J15,'MDA3'!M15,'T1'!N15,'T2'!L15,T3_R1!M15,T3_R2!M15)","v":0},2064,{"$f":"MAX('MDA2'!J15,T15)","v":0},{"$f":"MAX('MDA1'!K15,'MDA2'!K15,'MDA3'!I15,'MDA3'!L15,V15,AD15)","v":1999},{"$f":"MAX('MDA1'!L15,'MDA2'!L15,'MDA3'!J15,'MDA3'!M15,AF15)","v":0},1999,26.20264779132258]

{"sheet":"SUMMARY","index":10,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[15,1,15,3],[0,1,0,5],[1,1,1,7],[5,1,11,7],[3,3,3,5],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[23,1,23,5],[31,1,31,2],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5],[69,1,69,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[66,1,66,7],[62,1,62,2],[54,1,60,7],[68,1,68,2],[63,3,64,7],[49,1,49,7],[62,3,62,7],[50,3,50,4]]}
[]
[null,"Formato de Reporte Conjunto para QP v.3"]
[]
[null,"País",null,{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\" \")","v":"STP"},null,null,"Año",{"$f":"IF(INTRO!$E$36<>0,INTRO!$E$36,\" \")","v":2016}]
[]
[null,"Se solicita a las autoridades nacionales completar este formulario para ser enviado a la Organización Mundial de la Salud antes del 15 de agosto del año en curso para presentar datos sobre las intervenciones de QP implementadas durante el año anterior."]
[]
[]
[]
[]
[]
[]
[]
[null,"Número de personas que recibieron tratamiento (al menos una vez) para las enfermedades"]
[]
[null,null,null,null,"PreESC","ESC","Adultos","Total"]
[null,"Filariasis linfática",null,null,0,0,0,{"$f":"SUM(E17:G17)","v":0}]
[null,"Oncocercosis",null,null,"No elegible",0,0,{"$f":"SUM(E18:G18)","v":0}]
[null,"Helmintiasis transmitidas por el contacto con el suelo",null,null,0,32201,0,{"$f":"SUM(E19:G19)","v":32201}]
[null,"Esquistosomiasis",null,null,"No focalizado",32201,0,{"$f":"SUM(E20:G20)","v":32201}]
[]
[null,"Cobertura de las intervenciones de QP contra las enfermedades (%)"]
[]
[null,null,null,null,null,null,"Geográfico","Nacional"]
[null,"Filariasis linfática",null,null,null,null,0,"-"]
[null,"Oncocercosis",null,null,null,null,0,0]
[null,"Helmintiasis transmitidas por el contacto con el suelo",null,null,null,null,100,44.367130550033131]
[null,"Esquistosomiasis",null,null,null,null,100,60.630047057049488]
[]
[null,"Número de personas tratadas y cobertura del programa (%) para intervenciones de QP"]
[]
[null,null,null,"PreESC","ESC","Adultos","Total","Cobertura"]
[null,"MDA 1 (IVM+ALB)",null,"No elegible",{"$f":"'MDA1'!$K$4","v":0},{"$f":"'MDA1'!$L$4","v":0},{"$f":"'MDA1'!$M$4","v":0},{"$f":"'MDA1'!$Q$4","v":" "}]
[null,"MDA 2 (DEC+ALB)",null,{"$f":"'MDA2'!$J$4","v":0},{"$f":"'MDA2'!$K$4","v":0},{"$f":"'MDA2'!$L$4","v":0},{"$f":"'MDA2'!$M$4","v":0},{"$f":"'MDA2'!$Q$4","v":" "}]
[null,"MDA 3 (IVM)",null,"No elegible",{"$f":"'MDA3'!$O$4","v":0},{"$f":"'MDA3'!$P$4","v":0},{"$f":"'MDA3'!$Q$4","v":0},{"$f":"'MDA3'!$T$4","v":" "}]
[null,"T 1 (PZQ+ALB/MBD)",null,{"$f":"IF('T1'!$L$4<>0,'T1'!$L$4,\"No focalizado\")","v":"No focalizado"},{"$f":"'T1'!$M$4","v":32201},{"$f":"IF('T1'!$N$4<>0,'T1'!$N$4,\"No focalizado\")","v":"No focalizado"},{"$f":"'T1'!$O$4","v":32201},{"$f":"'T1'!$S$4","v":87.978470533591974}]
[null,"T 2 (PZQ)",null,{"$f":"IF('T2'!$J$4<>0,'T2'!$J$4,\"No focalizado\")","v":"No focalizado"},{"$f":"'T2'!$K$4","v":0},{"$f":"'T2'!$L$4","v":0},{"$f":"'T2'!$M$4","v":0},{"$f":"'T2'!$Q$4","v":" "}]
[null,"T 3 (ALB/MBD) - ronda 1",null,{"$f":"T3_R1!$K$4","v":0},{"$f":"T3_R1!$L$4","v":0},{"$f":"IF(T3_R1!$M$4<>0,T3_R1!$M$4,\"No focalizado\")","v":"No focalizado"},{"$f":"T3_R1!$N$4","v":0},{"$f":"T3_R1!$R$4","v":" "}]
[null,"T 3 (ALB/MBD) - ronda 2",null,{"$f":"T3_R2!$K$4","v":0},{"$f":"T3_R2!$L$4","v":0},{"$f":"IF(T3_R2!$M$4<>0,T3_R2!$M$4,\"No focalizado\")","v":"No focalizado"},{"$f":"T3_R2!$N$4","v":0},{"$f":"T3_R2!$R$4","v":" "}]
[]
[null,"Inventario de los medicamentos para el QP en el país"]
[]
[null,null,"IVM","DEC","ALB (FL)","ALB (HTS)","MBD","PZQ"]
[null,"Disponible"]
[null,"Distribuido"]
[null,"Desechado"]
[null,"Recibidas"]
[null,"Restante",{"$f":"C44-C45-C46+C47","v":0},0,0,0,0,0]
[]
[null,"Por favor introduzca el fármaco que ha sido utilizado para tratar los PreESC, y los mecanismos de distribución"]
[null,"Medicamento",null,"Mecanismos de distribución",null,null,"Fuente"]
[]
[null,"Información adicional"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Nombre y firma del coordinador de ETD o representante del ministerio de salud:"]
[null,null,null,"03/05/2/18"]
[null,"Fecha:"]
[]
[null,"Por favor envíe el reporte nacional (firmado y en formato electrónico) al correspondiente Representante de OMS en su país con copia a:"]
[]
[null,"OMS oficina central",null,"PC_JointForms@who.int"]
[null,"OMS oficina regional",null,"Asesor Regional para ETD"]

{"sheet":"PROFILE","index":11,"n_rows":124,"n_cols":8,"rows_kept":124,"cut":false,"hidden":true,"merged":[[12,1,12,6],[47,1,47,3],[51,1,51,3],[55,1,55,3],[65,1,65,3],[29,1,29,3],[21,1,21,6],[16,1,16,6],[18,1,18,6],[17,1,17,6],[63,1,63,3],[13,1,13,6],[14,1,14,6],[15,1,15,6],[0,1,0,5],[1,1,1,7],[3,3,3,5],[69,1,69,3],[73,1,73,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[59,1,59,3],[5,3,5,5],[30,1,30,3],[34,1,34,3],[42,1,42,3],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[4,1,4,7],[5,1,5,2],[81,1,81,3],[19,1,19,6],[9,3,9,5],[43,1,43,3],[77,1,77,3],[80,1,80,3],[6,3,6,5],[7,3,7,5],[8,3,8,5],[78,1,78,3],[23,1,23,3],[11,1,11,6],[20,1,20,6],[79,1,79,3],[123,1,124,7],[85,6,85,7],[87,6,87,7],[89,6,89,7],[86,6,86,7],[88,6,88,7]]}
[]
[null,"Formato de Reporte Conjunto para QP v.3 - perfil de país"]
[]
[null,"País",null,{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\" \")","v":"STP"},null,null,"Año",{"$f":"IF(INTRO!$E$36<>0,INTRO!$E$36,\" \")","v":2016}]
[null,"!!! ADVERTENCIA !!!\nAntes de analizar los datos en el perfil de país, asegúrese de que su informe en la pestaña SUMMARY esté actualizado"]
[null,"Población total",null,null,null,null,1,{"$f":"COUNTRY_INFO!D4","v":188134}]
[null,"Población — otros grupos de edad",null,null,null,null,{"$f":"IF($H$6<>0,H7/$H$6,0)","v":3.1998469176225459E-2},{"$f":"H6-SUM(H8:H10)","v":6020}]
[null,"Población — Pre-ESC",null,{"$f":"INTRO!B48","v":"1-4 años"},null,null,{"$f":"IF($H$6<>0,H8/$H$6,0)","v":0.12300275335665005},{"$f":"COUNTRY_INFO!E4","v":23141}]
[null,"Población — ESC",null,{"$f":"INTRO!B49","v":"5-14 años"},null,null,{"$f":"IF($H$6<>0,H9/$H$6,0)","v":0.26199942594108455},{"$f":"COUNTRY_INFO!F4","v":49291}]
[null,"Población — Adultos",null,{"$f":"INTRO!B50","v":"15 años o más"},null,null,0.58299935152603999,{"$f":"COUNTRY_INFO!G4","v":109682}]
[]
[null,"Número total de personas que necesitan QP para al menos una enfermedad (FL, ONCO, HTS, ESQ)",null,null,null,null,null,{"$f":"DISTRICT!AT6","v":188134}]
[null,"Proporción del número de personas que necesitan QP para al menos una enfermedad del total de la población ",null,null,null,null,null,{"$f":"IF(H6<>0,H12/H6,0)","v":1}]
[null,"Número de UI que requieren QP para al menos una enfermedad (FL, ONCO, HTS, ESQ)",null,null,null,null,null,{"$f":"COUNTIF(DISTRICT!AT9:AT1000,\">0\")","v":7}]
[null,"Número de UI que recibieron QP para al menos una enfermedad (FL, ONCO, HTS, ESQ)",null,null,null,null,null,{"$f":"COUNTIF(DISTRICT!AY9:AY1000,\">0\")","v":7}]
[null,"Proporción de UI que requieren QP para al menos una enfermedad y que lo recibieron",null,null,null,null,null,{"$f":"IF(H14<>0,H15/H14,0)","v":1}]
[null,"Número total de personas que recibieron QP para al menos una enfermedad (FL, ONCO, HTS, ESQ)",null,null,null,null,null,{"$f":"DISTRICT!AY6","v":32201}]
[null,"Número total de personas que necesitan y que recibieron QP para al menos una enfermedad (FL, ONCO, HTS, ESQ)",null,null,null,null,null,{"$f":"DISTRICT!BC6","v":32136}]
[null,"Cobertura de la QP para al menos una enfermedad (FL, ONCO, HTS, ESQ)",null,null,null,null,null,{"$f":"DISTRICT!BD6","v":0.17081441950949855}]
[null,"Número de UI que recibieron tratamiento para todas la enfermedades que requieren QP en esas UI",null,null,null,null,null,{"$f":"DISTRICT!AU6","v":0}]
[null,"Población requiriendo QP en UI que recibieron tratamiento para todas las enfermedades que necesitan QP",null,null,null,null,null,{"$f":"SUMIF(DISTRICT!AU9:AU1000,\"Y\",DISTRICT!AT9:AT1000)","v":0}]
[null,"Población que recibió QP en UI que fueron tratadas para todas las enfermedades que necesitaban QP",null,null,null,null,null,{"$f":"SUMIF(DISTRICT!AU9:AU1000,\"Y\",DISTRICT!AY9:AY1000)","v":0}]
[]
[null,null,null,null,"FL","Onco","HTS","ESQ"]
[]
[null,"Enfermedades que requieren QP en el país",null,null,{"$f":"IF(INTRO!E38=\"Endémico\",\"Sí\",\"No\")","v":"Sí"},{"$f":"IF(INTRO!E40=\"Endémico\",\"Sí\",\"No\")","v":"No"},{"$f":"IF(INTRO!E42=\"Endémico\",\"Sí\",\"No\")","v":"Sí"},{"$f":"IF(INTRO!E44=\"Endémico\",\"Sí\",\"No\")","v":"Sí"}]
[null,"Número de unidades de implementación (UI) en el país",null,null,{"$f":"IF(E26=\"Sí\",INTRO!$E$46,\"-\")","v":7},{"$f":"IF(F26=\"Sí\",INTRO!$E$46,\"-\")","v":"-"},{"$f":"IF(G26=\"Sí\",INTRO!$E$46,\"-\")","v":7},{"$f":"IF(H26=\"Sí\",INTRO!$E$46,\"-\")","v":7}]
[null,"Número de UI con estado de endemicidad conocido",null,null,{"$f":"IF(E26=\"Sí\",E27-E29,\"-\")","v":7},{"$f":"IF(F26=\"Sí\",F27-F29,\"-\")","v":"-"},{"$f":"IF(G26=\"Sí\",G27-G29,\"-\")","v":7},{"$f":"IF(H26=\"Sí\",H27-H29,\"-\")","v":7}]
[null,"Número de UI con estado de endemicidad desconocido",null,null,{"$f":"IF(E26=\"Sí\",E27-(992-COUNTIF(COUNTRY_INFO!H$9:H$1000,\"\"))+COUNTIF(COUNTRY_INFO!H$9:H$1000,\"=4\"),\"-\")","v":0},{"$f":"IF(F26=\"Sí\",F27-(992-COUNTIF(COUNTRY_INFO!I$9:I$1000,\"\"))+COUNTIF(COUNTRY_INFO!I$9:I$1000,\"=4\"),\"-\")","v":"-"},{"$f":"IF(G26=\"Sí\",G27-(992-COUNTIF(COUNTRY_INFO!J$9:J$1000,\"\"))+COUNTIF(COUNTRY_INFO!J$9:J$1000,\"=4\")+COUNTIF(COUNTRY_INFO!J$9:J$1000,\"=5\"),\"-\")","v":0},{"$f":"IF(H26=\"Sí\",H27-(992-COUNTIF(COUNTRY_INFO!K$9:K$1000,\"\"))+COUNTIF(COUNTRY_INFO!K$9:K$1000,\"=4\")+COUNTIF(COUNTRY_INFO!K$9:K$1000,\"=5\"),\"-\")","v":0}]
[null,"Número de UI no endémicas",null,null,{"$f":"IF(E26=\"Sí\",COUNTIF(COUNTRY_INFO!H$9:H$1000,\"=0\"),\"-\")","v":0},{"$f":"IF(F26=\"Sí\",COUNTIF(COUNTRY_INFO!I$9:I$1000,\"=0\"),\"-\")","v":"-"},{"$f":"IF(G26=\"Sí\",COUNTIF(COUNTRY_INFO!J$9:J$1000,\"=0\"),\"-\")","v":0},{"$f":"IF(H26=\"Sí\",COUNTIF(COUNTRY_INFO!K$9:K$1000,\"=0\"),\"-\")","v":0}]
[null,"Número de UI que requieren QP (total)",null,null,{"$f":"COUNTIF(COUNTRY_INFO!H$9:H$1000,\"=1\")","v":7},{"$f":"COUNTIF(COUNTRY_INFO!I$9:I$1000,\"=1\")","v":0},{"$f":"SUM(G33:G34)","v":7},{"$f":"SUM(H32:H34)","v":7}]
[null,null,null,"prevalencia baja",null,null,{"$f":"COUNTIF(COUNTRY_INFO!J$9:J$1000,\"=1\")","v":0},{"$f":"COUNTIF(COUNTRY_INFO!K$9:K$1000,\"=1\")","v":5}]
[null,null,null,"prevalencia moderada",null,null,{"$f":"COUNTIF(COUNTRY_INFO!J$9:J$1000,\"=2\")","v":0},{"$f":"COUNTIF(COUNTRY_INFO!K$9:K$1000,\"=2\")","v":2}]
[null,null,null,"prevalencia alta",null,null,{"$f":"COUNTIF(COUNTRY_INFO!J$9:J$1000,\"=3\")","v":7},{"$f":"COUNTIF(COUNTRY_INFO!K$9:K$1000,\"=3\")","v":0}]
[null,"Población que requiere QP en el país (total)",null,null,{"$f":"COUNTRY_INFO!L4","v":188134},{"$f":"COUNTRY_INFO!M4","v":0},{"$f":"COUNTRY_INFO!N4","v":72432},{"$f":"COUNTRY_INFO!O4","v":35677.97}]
[null,null,"Pre-ESC","prevalencia moderada",null,null,{"$f":"SUMIF(COUNTRY_INFO!J$9:J$1000,\"=2\",COUNTRY_INFO!E$9:E$1000)","v":0}]
[null,null,null,"prevalencia alta",null,null,{"$f":"SUMIF(COUNTRY_INFO!J$9:J$1000,\"=3\",COUNTRY_INFO!E$9:E$1000)","v":23141}]
[null,null,"ESC","prevalencia baja",null,null,null,{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=1\",COUNTRY_INFO!F$9:F$1000)*0.33","v":5850.5700000000006}]
[null,null,null,"prevalencia moderada",null,null,{"$f":"SUMIF(COUNTRY_INFO!J$9:J$1000,\"=2\",COUNTRY_INFO!F$9:F$1000)","v":0},{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=2\",COUNTRY_INFO!F$9:F$1000)*0.5","v":15781}]
[null,null,null,"prevalencia alta",null,null,{"$f":"SUMIF(COUNTRY_INFO!J$9:J$1000,\"=3\",COUNTRY_INFO!F$9:F$1000)","v":49291},{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=3\",COUNTRY_INFO!F$9:F$1000)","v":0}]
[null,null,"Adultos","prevalencia moderada",null,null,null,{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=2\",COUNTRY_INFO!G$9:G$1000)*0.2","v":14046.400000000001}]
[null,null,null,"prevalencia alta",null,null,null,{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=3\",COUNTRY_INFO!G$9:G$1000)","v":0}]
[null,"Número de UI en las que se implementó QP (total)",null,null,{"$f":"COUNTIF(DISTRICT!G$9:G$1000,\">0\")","v":0},{"$f":"COUNTIF(DISTRICT!M$9:M$1000,\">0\")","v":0},{"$f":"COUNTIF(DISTRICT!S$9:S$1000,\">0\")","v":7},{"$f":"COUNTIF(DISTRICT!AC$9:AC$1000,\">0\")","v":7}]
[null,"Número de UI en necesidad donde se implementó PC (total)",null,null,{"$f":"COUNTIF(DISTRICT!H$9:H$1000,\">0\")","v":0},{"$f":"COUNTIF(DISTRICT!N$9:N$1000,\">0\")","v":0},{"$f":"COUNTIF(DISTRICT!X$9:X$1000,\">0\")","v":7},{"$f":"COUNTIF(DISTRICT!AH$9:AH$1000,\">0\")","v":7}]
[null,null,"Pre-ESC",null,null,null,{"$f":"COUNTIF(DISTRICT!T$9:T$1000,\">0\")","v":0}]
[null,null,"ESC",null,null,null,{"$f":"COUNTIF(DISTRICT!V$9:V$1000,\">0\")","v":7},{"$f":"COUNTIF(DISTRICT!AD$9:AD$1000,\">0\")","v":7}]
[null,null,"Adultos",null,null,null,null,{"$f":"COUNTIF(DISTRICT!AF$9:AF$1000,\">0\")","v":0}]
[null,"Número de personas tratadas (total)",null,null,{"$f":"DISTRICT!G4","v":0},{"$f":"DISTRICT!M4","v":0},{"$f":"DISTRICT!S4","v":32201},{"$f":"DISTRICT!AC4","v":32201}]
[null,null,"Pre-ESC",null,{"$f":"SUMMARY!$E17","v":0},{"$f":"SUMMARY!$E18","v":"No elegible"},{"$f":"SUMMARY!$E19","v":0},{"$f":"SUMMARY!$E20","v":"No focalizado"}]
[null,null,"ESC",null,{"$f":"SUMMARY!$F17","v":0},{"$f":"SUMMARY!$F18","v":0},{"$f":"SUMMARY!$F19","v":32201},{"$f":"SUMMARY!$F20","v":32201}]
[null,null,"Adultos",null,{"$f":"SUMMARY!$G17","v":0},{"$f":"SUMMARY!$G18","v":0},{"$f":"SUMMARY!$G19","v":0},{"$f":"SUMMARY!$G20","v":0}]
[null,"Número de personas que necesitaban y que fueron tratadas (total)",null,null,{"$f":"DISTRICT!H4","v":0},{"$f":"DISTRICT!N4","v":0},{"$f":"DISTRICT!X4","v":32136},{"$f":"DISTRICT!AH4","v":21631.57}]
[null,null,"Pre-ESC",null,null,null,{"$f":"DISTRICT!T4","v":0}]
[null,null,"ESC",null,null,null,{"$f":"DISTRICT!V4","v":32136},{"$f":"DISTRICT!AD4","v":21631.57}]
[null,null,"Adultos",null,null,null,null,{"$f":"DISTRICT!AF4","v":0}]
[null,"Cobertura geográfica (todas las edades)",null,null,{"$f":"IF(E31<>0,E44/E31,0)","v":0},{"$f":"IF(F31<>0,F44/F31,0)","v":0},{"$f":"IF(G31<>0,G44/G31,0)","v":1},{"$f":"IF(H31<>0,H44/H31,0)","v":1}]
[null,null,"Pre-ESC",null,null,null,{"$f":"IF(G31<>0,G45/G31,0)","v":0}]
[null,null,"ESC",null,null,null,{"$f":"IF(G31<>0,G46/G31,0)","v":1},{"$f":"IF(H31<>0,H46/H31,0)","v":1}]
[null,null,"Adultos",null,null,null,null,{"$f":"IF(SUM(H33:H34)<>0,H47/SUM(H33:H34),0)","v":0}]
[null,"Cobertura nacional (total)",null,null,{"$f":"IF(E35<>0,E52/E35,0)","v":0},{"$f":"IF(F35<>0,F52/F35,0)","v":0},{"$f":"IF(G35<>0,G52/G35,0)","v":0.44367130550033135},{"$f":"IF(H35<>0,H52/H35,0)","v":0.60630047057049485}]
[null,null,"Pre-ESC",null,null,null,{"$f":"IF(SUM(G36:G37)<>0,G53/SUM(G36:G37),0)","v":0}]
[null,null,"ESC",null,null,null,{"$f":"IF(SUM(G39:G40)<>0,G54/SUM(G39:G40),0)","v":0.65196486173946566},{"$f":"IF(SUM(H38:H40)<>0,H54/SUM(H38:H40),0)","v":1}]
[null,null,"Adultos",null,null,null,null,{"$f":"IF(SUM(H41:H42)<>0,H55/SUM(H41:H42),0)","v":0}]
[null,null,null,null,"FL","Onco","HTS","ESQ"]
[]
[null,"Número de UI que alcanzaron la cobertura efectiva (todas las edades)",null,null,{"$f":"COUNTIF(DISTRICT!I$9:I$1000,\">=65\")","v":0},{"$f":"COUNTIF(DISTRICT!O$9:O$1000,\">=65\")","v":0},{"$f":"COUNTIF(DISTRICT!Y$9:Y$1000,\">=75\")","v":0},{"$f":"COUNTIF(DISTRICT!AI$9:AI$1000,\">=75\")","v":5}]
[null,null,"Pre-ESC",null,null,null,{"$f":"COUNTIF(DISTRICT!U$9:U$1000,\">=75\")","v":0}]
[null,null,"ESC",null,null,null,{"$f":"COUNTIF(DISTRICT!W$9:W$1000,\">=75\")","v":2},{"$f":"COUNTIF(DISTRICT!AE$9:AE$1000,\">=75\")","v":7}]
[null,null,"Adultos",null,null,null,null,{"$f":"COUNTIF(DISTRICT!AG$9:AG$1000,\">=75\")","v":0}]
[null,"Número de personas en necesidad que fueron tratados en UI que alcanzaron cobertura efectiva (total)",null,null,{"$f":"SUMIF(DISTRICT!I9:I1000,\">=65\",DISTRICT!H9:H1000)","v":0},{"$f":"SUMIF(DISTRICT!O9:O1000,\">=65\",DISTRICT!N9:N1000)","v":0},{"$f":"SUMIF(DISTRICT!Y9:Y1000,\">=75\",DISTRICT!X9:X1000)","v":0},{"$f":"SUMIF(DISTRICT!AI9:AI1000,\">=75\",DISTRICT!AH9:AH1000)","v":5850.57}]
[null,null,"Pre-ESC",null,null,null,{"$f":"SUMIF(DISTRICT!U9:U1000,\">=75\",DISTRICT!T9:T1000)","v":0}]
[null,null,"ESC",null,null,null,{"$f":"SUMIF(DISTRICT!W9:W1000,\">=75\",DISTRICT!V9:V1000)","v":3255},{"$f":"SUMIF(DISTRICT!AE9:AE1000,\">=75\",DISTRICT!AD9:AD1000)","v":21631.57}]
[null,null,"Adultos",null,null,null,null,{"$f":"SUMIF(DISTRICT!AG9:AG1000,\">=75\",DISTRICT!AF9:AF1000)","v":0}]
[null,"Proporción de UI que requieren QP y alcanzaron cobertura efectiva (total)",null,null,{"$f":"IF(E44<>0,E66/E44,0)","v":0},{"$f":"IF(F44<>0,F66/F44,0)","v":0},{"$f":"IF(G44<>0,G66/G44,0)","v":0},{"$f":"IF(H44<>0,H66/H44,0)","v":0.7142857142857143}]
[null,null,"Pre-ESC",null,null,null,{"$f":"IF(G45<>0,G67/G45,0)","v":0}]
[null,null,"ESC",null,null,null,{"$f":"IF(G46<>0,G68/G46,0)","v":0.2857142857142857},{"$f":"IF(H46<>0,H68/H46,0)","v":1}]
[null,null,"Adultos",null,null,null,null,{"$f":"IF(H47<>0,H69/H47,0)","v":0}]
[null,"Número de unidades de implementación en las que se detuvo la QP (es decir, bajo vigilancia)",null,null,{"$f":"COUNTIF(COUNTRY_INFO!H$9:H$1000,\"=99\")","v":0},{"$f":"COUNTIF(COUNTRY_INFO!I$9:I$1000,\"=99\")","v":0}]
[null,"Número de personas  en las UI que ya no requieren QP (detenido)",null,null,{"$f":"SUMIF(COUNTRY_INFO!H$9:H$1000,\"=99\",COUNTRY_INFO!D$9:D$1000)","v":0},{"$f":"SUMIF(COUNTRY_INFO!I$9:I$1000,\"=99\",COUNTRY_INFO!D$9:D$1000)","v":0}]
[null,"Número de personas que requieren QP que viven en UI focalizadas para la QP",null,null,{"$f":"SUMIF(DISTRICT!H$9:H$1000,\">0\",DISTRICT!D$9:D$1000)","v":0},{"$f":"SUMIF(DISTRICT!N$9:N$1000,\">0\",DISTRICT!J$9:J$1000)","v":0},{"$f":"SUMIF(DISTRICT!X$9:X$1000,\">0\",DISTRICT!P$9:P$1000)","v":72432},{"$f":"SUMIF(DISTRICT!AH$9:AH$1000,\">0\",DISTRICT!Z$9:Z$1000)","v":35677.97}]
[null,"Número de personas que requieren QP que viven en UI no focalizadas para la QP",null,null,{"$f":"SUMIF(DISTRICT!H$9:H$1000,\"=0\",DISTRICT!D$9:D$1000)","v":188134},{"$f":"SUMIF(DISTRICT!N$9:N$1000,\"=0\",DISTRICT!J$9:J$1000)","v":0},{"$f":"SUMIF(DISTRICT!X$9:X$1000,\"=0\",DISTRICT!P$9:P$1000)","v":0},{"$f":"SUMIF(DISTRICT!AH$9:AH$1000,\"=0\",DISTRICT!Z$9:Z$1000)","v":0}]
[null,null,null,null,{"$f":"E35-E52","v":188134},{"$f":"F35-F52","v":0},40296,14046.400000000001]
[null,"Número de UI que requieren y reciben QP",null,null,{"$f":"E31-E44","v":7},{"$f":"F31-F44","v":0},0,0]
[null,null,null,null,{"$f":"E27-E31-E29","v":0},{"$error":"#VALUE!"},0,{"$f":"H27-H31-H29","v":0}]
[]
[null,null,null,null,null,null,"Requieren y reciben QP"]
[null,null,null,null,null,null,"Requieren y no reciben QP"]
[null,null,null,null,null,null,"No requieren QP"]
[null,null,null,null,null,null,"Estado desconocido"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Haga clic aquí para acceder a los datos del Portal de Datos sobre Quimioterapia Preventiva"]