{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["INTRO","COUNTRY_INFO","MDA1","MDA2","MDA3","T1","T2","T3_R1","T3_R2","DISTRICT","SUMMARY","PROFILE","DATA_POLICY"],"not_rendered":{"charts":8,"images":3,"macros":1,"external_links":0,"defined_names":5,"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,"Formulaire de Rapport Commun v.3.1"]
[]
[null,"Le but de ce formulaire de rapport commun - disponible sous forme de fichier Excel - est de mettre à disposition des autorités sanitaires nationales et des gestionnaires de données un outil standardisé qui réponde aux défis, facilite l'intégration et par conséquent contribue à améliorer la gestion de programme. Ce formulaire tend à standardiser le rapport de résultats des programmes nationaux, améliore la disponibilité et la coordination des données de chimioprévention à travers les Bureaux des Régions de l'Organisation mondiale de la Santé. \nLes autorités nationales sont priées de compléter ce formulaire et de le soumettre à l'Organisation mondiale de la Santé avant le 15 août de l'année en cours pour rapporter les données des activités de chimioprévention mises en oeuvre l'année précédente."]
[]
[null,"Structure de l'application (feuilles de travail) :"]
[]
[null,"INTRO","Cette feuille contient des instructions pour compléter le formulaire de rapport commun et des informations sur le statut de la chimioprévention pour les maladies d'endémie du pays. "]
[null,"COUNTRY_INFO","Cette feuille contient des informations sur la structure administrative du pays, la population par groupe d'âge, le statut d'endémicité pour chaque maladie, la population devant être traitée par chimioprévention, les interventions prévues et les interventions mises en oeuvre. "]
[null,"MDA1, MDA2, MDA3, T1, T2 et T3","Ces feuilles contiennent des informations sur l'endémicité des districts ciblés pour le traitement aux médicaments spécifiques pour la chimioprévention, les plans de traitement, et le nombre de personnes traitées par groupe d'âge. "]
[null,"DISTRICT","Cette feuille contient un résumé sur les personnes traitées, par maladie, au niveau de mise en oeuvre. Si les données par genre (sexe) sont disponibles, merci de les saisir.  "]
[null,"SUMMARY","Cette feuille contient un résumé sur les personnes traitées, par maladie et par type d'intervention de chimioprévention. Avant de générer le rapport (exécuter macro), veuillez sélectionner la maladie pour laquelle vous souhaitez un rapport. Veuillez suivre le même processus pour générer les divers rapports. \nCette feuille doit être imprimée et soumise comme formulaire de rapport commun (voir les instructions pour la soumission du formulaire sous la feuille SUMMARY). "]
[]
[null,"Instructions pour la saisie des données"]
[]
[null,"La plupart des cellules des feuilles de travail mentionnées ci-dessus contiennent des formules calculées automatiquement en fonction du protocole de traitement recommandé par l'OMS pour chaque maladie.\nVoir : http://www.who.int/neglected_diseases/preventive_chemotherapy/pct_manual/en/index.html"]
[]
[null,"Veuillez entrer vos données dans les cellules en fonction de leur code de couleur :"]
[]
[null,null,"Blanc - la cellule n'est pas protégée. Veuillez entrer la valeur de l'indicateur demandé."]
[]
[null,null,"Jaune - la cellule est protégée et inclut le nom de l'indicateur. Aucune entrée de données requise."]
[]
[null,null,"Orange - la cellule n'est pas protégée et contient un menu déroulant. Veuillez sélectionner la valeur dans le menu déroulant. "]
[]
[]
[null,null,"Vert - la cellule n'est pas protégée et contient des formules. Veuillez changer la valeur indiquée uniquement si vos données sont différentes de celles calculées automatiquement.  "]
[]
[]
[null,null,"Bleu - la cellule est protégée et contient des formules. Aucune entrée de données requise. "]
[]
[null,"Données pays"]
[]
[null,"PAYS",null,null,"STP"]
[]
[null,"Année de rapport des données",null,null,2018]
[]
[null,"Le pays est-il endémique à la filariose lymphatique (FL) ?",null,null,"Endémique"]
[]
[null,"Le pays est-il endémique à l'onchocercose (ONCHO) ? ",null,null,"Non endémique"]
[]
[null,"Le pays est-il endémique aux géohelminthiases (STH) ?",null,null,"Endémique"]
[]
[null,"Le pays est-il endémique à la schistosomiase (SCH) ?",null,null,"Endémique"]
[]
[null,"Combien d'unités administratives compte le pays ?",null,null,7]
[null,"Si les données démographiques par groupe d'âge ne sont pas disponibles au second niveau administratif, veuillez entrer la proportion (%) de population, par groupe d'âge, du pays. Si les données sont disponibles, veuillez laisser les cellules vierges."]
[null,"1-4 ans","Enfants d'âge pré-scolaire (EAPréS)",null,0.123]
[null,"5-14 ans","Enfants d'âge scolaire (EAS)",null,0.26200000000000001]
[null,"15 ans et plus","Adultes",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]]}
["INFORMATIONS PAYS"]
["Structure administrative, population par groupe d'âge, statut d'endémicité, interventions planifiées et interventions mises en oeuvre"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":201784},{"$f":"SUM(E$9:E$1000)","v":24819},{"$f":"SUM(F$9:F$1000)","v":52868},{"$f":"SUM(G$9:G$1000)","v":117642},null,null,null,null,{"$f":"SUM(L$9:L$1000)","v":201784},{"$f":"SUM(M$9:M$1000)","v":0},{"$f":"SUM(N$9:N$1000)","v":77687},{"$f":"SUM(O$9:O$1000)","v":38154.740000000005}]
[]
["Structure administrative du pays",null,null,"Population",null,null,null,"Endémicité",null,null,null,"Population nécessitant la CP",null,null,null,"Nombre de tournées de traitement prévues pour l'année",null,null,null,"Mise en oeuvre de la chimioprévention",null,"Cliquer ci-dessous pour voir la stratégie recommandée"]
["Pays","Région/Département","District","Total","EAPréS","EAS","Adultes","FL","Oncho","STH","SCH","FL","Oncho","STH","SCH","FL","Oncho","STH","SCH","TOURNEE 1","TOURNEE 2",null,null,"IU_ID","IU_Name"]
[]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Agua Grande",77689,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D9*INTRO!$E$48,0))","v":9556},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D9*INTRO!$E$49,0))","v":20355},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D9*INTRO!$E$50,0))","v":45293},1,0,3,2,{"$f":"IF(INTRO!$E$38=\"Endémique\", IF($H9>0, IF($H9=4,\"Inconnu\", IF($H9=99,\"Interrompu\", $D9)), 0),\"Non requis\")","v":77689},{"$f":"IF(INTRO!$E$40=\"Endémique\", IF($I9>0, IF($I9=4,\"Inconnu\",IF($I9=99,\"Interrompu\", $D9)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$42=\"Endémique\", IF(AND($J9>1,$J9<5), IF($J9=4, \"Inconnu\", E9+F9), 0),\"Non requis\")","v":29911},{"$f":"IF(INTRO!$E$44=\"Endémique\", IF(AND($K9>0,$K9<5), IF($K9=4,\"Inconnu\", IF($K9=1, $F9*0.33, IF($K9=2, $F9*0.5+$G9*0.2, SUM(F9:G9)))), 0),\"Non requis\")","v":19236.099999999999},1,null,2,1,"MDA2 (DEC+ALB)","T1 (PZQ+ALB/MBD)",null,null,39143,"Agua Grande",null,{"$f":"Y9=C9","v":true}]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Me-zochi",50821,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D10*INTRO!$E$48,0))","v":6251},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D10*INTRO!$E$49,0))","v":13315},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D10*INTRO!$E$50,0))","v":29629},1,0,3,2,{"$f":"IF(INTRO!$E$38=\"Endémique\", IF($H10>0, IF($H10=4,\"Inconnu\", IF($H10=99,\"Interrompu\", $D10)), 0),\"Non requis\")","v":50821},{"$f":"IF(INTRO!$E$40=\"Endémique\", IF($I10>0, IF($I10=4,\"Inconnu\",IF($I10=99,\"Interrompu\", $D10)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$42=\"Endémique\", IF(AND($J10>1,$J10<5), IF($J10=4, \"Inconnu\", E10+F10), 0),\"Non requis\")","v":19566},{"$f":"IF(INTRO!$E$44=\"Endémique\", IF(AND($K10>0,$K10<5), IF($K10=4,\"Inconnu\", IF($K10=1, $F10*0.33, IF($K10=2, $F10*0.5+$G10*0.2, SUM(F10:G10)))), 0),\"Non requis\")","v":12583.3},1,null,2,1,"MDA2 (DEC+ALB)","T1 (PZQ+ALB/MBD)",null,null,39148,"Me-zochi",null,{"$f":"Y10=C10","v":true}]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Lobata ",21988,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D11*INTRO!$E$48,0))","v":2705},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D11*INTRO!$E$49,0))","v":5761},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D11*INTRO!$E$50,0))","v":12819},1,0,3,1,{"$f":"IF(INTRO!$E$38=\"Endémique\", IF($H11>0, IF($H11=4,\"Inconnu\", IF($H11=99,\"Interrompu\", $D11)), 0),\"Non requis\")","v":21988},{"$f":"IF(INTRO!$E$40=\"Endémique\", IF($I11>0, IF($I11=4,\"Inconnu\",IF($I11=99,\"Interrompu\", $D11)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$42=\"Endémique\", IF(AND($J11>1,$J11<5), IF($J11=4, \"Inconnu\", E11+F11), 0),\"Non requis\")","v":8466},{"$f":"IF(INTRO!$E$44=\"Endémique\", IF(AND($K11>0,$K11<5), IF($K11=4,\"Inconnu\", IF($K11=1, $F11*0.33, IF($K11=2, $F11*0.5+$G11*0.2, SUM(F11:G11)))), 0),\"Non requis\")","v":1901.13},1,null,2,0,"MDA2 (DEC+ALB)","T3 (ALB/MBD)",null,null,39147,"Lobata ",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Cantagalo",19394,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D12*INTRO!$E$48,0))","v":2385},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D12*INTRO!$E$49,0))","v":5081},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D12*INTRO!$E$50,0))","v":11307},1,0,3,1,{"$f":"IF(INTRO!$E$38=\"Endémique\", IF($H12>0, IF($H12=4,\"Inconnu\", IF($H12=99,\"Interrompu\", $D12)), 0),\"Non requis\")","v":19394},{"$f":"IF(INTRO!$E$40=\"Endémique\", IF($I12>0, IF($I12=4,\"Inconnu\",IF($I12=99,\"Interrompu\", $D12)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$42=\"Endémique\", IF(AND($J12>1,$J12<5), IF($J12=4, \"Inconnu\", E12+F12), 0),\"Non requis\")","v":7466},{"$f":"IF(INTRO!$E$44=\"Endémique\", IF(AND($K12>0,$K12<5), IF($K12=4,\"Inconnu\", IF($K12=1, $F12*0.33, IF($K12=2, $F12*0.5+$G12*0.2, SUM(F12:G12)))), 0),\"Non requis\")","v":1676.73},1,null,2,0,"MDA2 (DEC+ALB)","T3 (ALB/MBD)",null,null,39144,"Cantagalo",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Lemba",16272,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D13*INTRO!$E$48,0))","v":2001},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D13*INTRO!$E$49,0))","v":4263},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D13*INTRO!$E$50,0))","v":9487},1,0,3,1,{"$f":"IF(INTRO!$E$38=\"Endémique\", IF($H13>0, IF($H13=4,\"Inconnu\", IF($H13=99,\"Interrompu\", $D13)), 0),\"Non requis\")","v":16272},{"$f":"IF(INTRO!$E$40=\"Endémique\", IF($I13>0, IF($I13=4,\"Inconnu\",IF($I13=99,\"Interrompu\", $D13)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$42=\"Endémique\", IF(AND($J13>1,$J13<5), IF($J13=4, \"Inconnu\", E13+F13), 0),\"Non requis\")","v":6264},{"$f":"IF(INTRO!$E$44=\"Endémique\", IF(AND($K13>0,$K13<5), IF($K13=4,\"Inconnu\", IF($K13=1, $F13*0.33, IF($K13=2, $F13*0.5+$G13*0.2, SUM(F13:G13)))), 0),\"Non requis\")","v":1406.79},1,null,2,0,"MDA2 (DEC+ALB)","T3 (ALB/MBD)",null,null,39146,"Lemba",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"ST","Cauè ",7202,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D14*INTRO!$E$48,0))","v":886},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D14*INTRO!$E$49,0))","v":1887},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D14*INTRO!$E$50,0))","v":4199},1,0,3,1,{"$f":"IF(INTRO!$E$38=\"Endémique\", IF($H14>0, IF($H14=4,\"Inconnu\", IF($H14=99,\"Interrompu\", $D14)), 0),\"Non requis\")","v":7202},{"$f":"IF(INTRO!$E$40=\"Endémique\", IF($I14>0, IF($I14=4,\"Inconnu\",IF($I14=99,\"Interrompu\", $D14)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$42=\"Endémique\", IF(AND($J14>1,$J14<5), IF($J14=4, \"Inconnu\", E14+F14), 0),\"Non requis\")","v":2773},{"$f":"IF(INTRO!$E$44=\"Endémique\", IF(AND($K14>0,$K14<5), IF($K14=4,\"Inconnu\", IF($K14=1, $F14*0.33, IF($K14=2, $F14*0.5+$G14*0.2, SUM(F14:G14)))), 0),\"Non requis\")","v":622.71},1,null,2,0,"MDA2 (DEC+ALB)","T3 (ALB/MBD)",null,null,39145,"Cauè ",null,true]
[{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\"\")","v":"STP"},"Principe","Píncipe",8418,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D15*INTRO!$E$48,0))","v":1035},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D15*INTRO!$E$49,0))","v":2206},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D15*INTRO!$E$50,0))","v":4908},1,0,3,1,{"$f":"IF(INTRO!$E$38=\"Endémique\", IF($H15>0, IF($H15=4,\"Inconnu\", IF($H15=99,\"Interrompu\", $D15)), 0),\"Non requis\")","v":8418},{"$f":"IF(INTRO!$E$40=\"Endémique\", IF($I15>0, IF($I15=4,\"Inconnu\",IF($I15=99,\"Interrompu\", $D15)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$42=\"Endémique\", IF(AND($J15>1,$J15<5), IF($J15=4, \"Inconnu\", E15+F15), 0),\"Non requis\")","v":3241},{"$f":"IF(INTRO!$E$44=\"Endémique\", IF(AND($K15>0,$K15<5), IF($K15=4,\"Inconnu\", IF($K15=1, $F15*0.33, IF($K15=2, $F15*0.5+$G15*0.2, SUM(F15:G15)))), 0),\"Non requis\")","v":727.98},1,null,2,0,"MDA2 (DEC+ALB)","T3 (ALB/MBD)",null,null,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 - Ivermectine (IVM) et Albendazole (ALB)"]
["Structure administrative, population nécessitant une chimioprévention par groupe d'âge, population traitée par groupe d'âge et couverture"]
[]
["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":" "}]
[]
["Structure administrative du pays",null,null,"Mise en oeuvre \nde la CP","Date","Population ciblée pour MDA 1",null,null,null,"Population traitée",null,null,null,"Couverture du Programme (%)"]
["Pays","Région/Département","District",null,null,"EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","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 - Diethylcarbamazine (DEC) + Albendazole (ALB)"]
["Structure administrative, population nécessitant une chimioprévention par groupe d'âge, population traitée par groupe d'âge et couverture"]
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F$9:F$1000)","v":23578.460400000004},{"$f":"SUM(G$9:G$1000)","v":52867.407999999996},111758.06839999997,188203.9368,16561,55654,90297,162512,{"$f":"IF(F4<>0, IF(J4/F4*100=0, \"-\", J4/F4*100), \" \")","v":70.237834527991481},{"$f":"IF(G4<>0, IF(K4/G4*100=0, \"-\", K4/G4*100), \" \")","v":105.27090717214659},{"$f":"IF(H4<>0, IF(L4/H4*100=0, \"-\", L4/H4*100), \" \")","v":80.796850994965851},{"$f":"IF(I4<>0, IF(M4/I4*100=0, \"-\", M4/I4*100), \" \")","v":86.348884493685034}]
[]
["Structure administrative du pays",null,null,"Mise en oeuvre \nde la CP","Date","Population ciblée pour MDA 2",null,null,null,"Population traitée",null,null,null,"Couverture du Programme (%)"]
["Pays","Région/Département","District",null,null,"EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","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":"MDA2 (DEC+ALB)"},"Abril 2018",9077.9596500000007,20354.518,43028.052649999998,{"$f":"SUM(F9:H9)","v":72460.530299999999},6613,21852,37873,{"$f":"SUM(J9:L9)","v":66338},{"$f":"IF(F9<>0, IF(J9/F9*100=0, \"-\", J9/F9*100), \" \")","v":72.846765737717277},107.35700054405612,88.019321506524193,91.550530647993341]
[{"$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":"MDA2 (DEC+ALB)"},"Abril 2018",5938.4338500000003,13315.101999999999,28147.210849999996,{"$f":"SUM(F10:H10)","v":47400.746699999996},3505,12810,17596,{"$f":"SUM(J10:L10)","v":33911},{"$f":"IF(F10<>0, IF(J10/F10*100=0, \"-\", J10/F10*100), \" \")","v":59.022295920666011},{"$f":"IF(G10<>0, IF(K10/G10*100=0, \"-\", K10/G10*100), \" \")","v":96.206548023439851},{"$f":"IF(H10<>0, IF(L10/H10*100=0, \"-\", L10/H10*100), \" \")","v":62.514186907439182},{"$f":"IF(I10<>0, IF(M10/I10*100=0, \"-\", M10/I10*100), \" \")","v":71.541067094624495}]
[{"$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":"MDA2 (DEC+ALB)"},"Abril 2018",2569.2977999999998,5760.8559999999998,12178.0538,20508.207600000002,2011,6813,9811,18635,78.270413028804995,118.26367470389818,80.562954977255899,90.866058913895515]
[{"$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":"MDA2 (DEC+ALB)"},"Abril 2018",2266.1889000000001,5081.2280000000001,10741.366899999999,18088.783799999997,1561,5031,8199,14791,68.882166001254348,99.011498795173139,76.331067324401715,81.768902561597329]
[{"$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":"MDA2 (DEC+ALB)"},"Abril 2018",1901.3832,4263.2639999999992,9012.2471999999998,15176.894399999999,1467,4839,7886,14192,77.154357943206819,113.50458240446758,87.50314793850751,93.510566957624746]
[{"$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":"MDA2 (DEC+ALB)"},"Abril 2018",841.55369999999994,1886.924,3988.8276999999998,6717.3053999999993,594,2045,4074,6713,70.583731020373392,108.37744392460958,102.13527147337049,99.935905847008243]
[{"$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":"MDA2 (DEC+ALB)"},"Abril 2018",983.64330000000018,2205.5160000000001,4662.3092999999999,7851.4686000000002,810,2264,4858,7932,82.346923930656558,102.65171506350441,104.19729124363329,101.02568581882885]

{"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 - Ivermectine (IVM) "]
["Structure administrative, population nécessitant une chimioprévention par groupe d'âge, population traitée par groupe d'âge et couverture"]
[]
["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":" "}]
[]
["Structure administrative du pays",null,null,"Mise en oeuvre \nde la CP","Date","Population ciblée pour MDA 3",null,null,"Population traitée - tournée 1",null,null,"Population traitée - tournée 2",null,null,"Population traitée",null,null,"Couverture du Programme (%)"]
["Pays","Région/Département","District",null,null,"EAS","Adultes","Total","EAS","Adultes","Total","EAS","Adultes","Total","EAS","Adultes","Total","EAS","Adultes","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 - Praziquantel (PZQ) et Albendazole (ALB) ou Mebendazole (MBD)"]
["Structure administrative, population nécessitant une chimioprévention par groupe d'âge, population traitée par groupe d'âge et couverture"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":0},24028,24028,0,{"$f":"SUM(K$9:K$1000)","v":24028},0,22803,0,22803,{"$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":94.901781255202266},{"$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":94.901781255202266}]
[]
["Structure administrative du pays",null,null,"Mise en oeuvre \nde la CP","Médica-ment","Date","Population ciblée pour T1",null,null,null,null,"Population traitée",null,null,null,"Couverture du Programme (%)"]
["Pays","Région/Département","District",null,null,null,"EAPréS (ALB)","EAS (ALB)","EAS (PZQ)","Adultes (PZQ)","Total","EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","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","Novembro 2018",null,14719,14719,null,{"$f":"MAX(H9:I9)+G9+J9","v":14719},null,14524,null,{"$f":"SUM(L9:N9)","v":14524},{"$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":98.675181737889801},{"$f":"IF(J9<>0, IF(N9/J9*100=0, \"-\", N9/J9*100), \" \")","v":" "},98.675181737889801]
[{"$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","Novembro 2018",null,9309,9309,null,{"$f":"MAX(H10:I10)+G10+J10","v":9309},null,8279,null,{"$f":"SUM(L10:N10)","v":8279},{"$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":88.935438822644755},{"$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":88.935438822644755}]
[{"$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":" "},null,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=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":" "},null,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=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":" "},null,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=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":" "},null,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=\"T1 (PZQ+ALB/MBD)\",COUNTRY_INFO!$U$9:$U$1000=\"T1 (PZQ+ALB/MBD)\"), \"T1 (PZQ+ALB/MBD)\", \" \")","v":" "},null,null,null,null,null,null,0,null,null,null,0," "," "," "," "]

{"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 - Praziquantel (PZQ) "]
["Structure administrative, population nécessitant une chimioprévention par groupe d'âge, population traitée par groupe d'âge et couverture"]
[]
["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":" "}]
[]
["Structure administrative du pays",null,null,"Mise en oeuvre \nde la CP","Date","Population ciblée pour T2",null,null,null,"Population traitée",null,null,null,"Couverture du Programme (%)"]
["Pays","Région/Département","District",null,null,"EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","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 - Albendazole (ALB) ou Mebendazole (MBD) - Tournée 1"]
["Structure administrative, population nécessitant une chimioprévention par groupe d'âge, population traitée par groupe d'âge et couverture"]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G$9:G$1000)","v":0},14289,0,14289,0,13210,0,13210,{"$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":92.448736790538177},{"$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":92.448736790538177}]
[]
["Structure administrative du pays",null,null,"Mise en oeuvre \nde la CP","Médica-ment","Date","Population ciblée pour T3",null,null,null,"Population traitée",null,null,null,"Couverture du Programme (%)"]
["Pays","Région/Département","District",null,null,null,"EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","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},0,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},0,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":"T3 (ALB/MBD)"},"MBD","nevembro 2018",null,4112,null,4112,0,3379,null,3379," ",82.174124513618679," ",82.174124513618679]
[{"$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":"T3 (ALB/MBD)"},"MBD","nevembro 2018",null,3422,null,3422,null,3308,null,3308," ",96.668614845119819," ",96.668614845119819]
[{"$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":"T3 (ALB/MBD)"},"MBD","nevembro 2018",null,3446,null,3446,null,3181,null,3181," ",92.309924550203135," ",92.309924550203135]
[{"$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":"T3 (ALB/MBD)"},"MBD","nevembro 2018",null,1333,null,1333,null,1425,null,1425," ",106.90172543135783," ",106.90172543135783]
[{"$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":"T3 (ALB/MBD)"},"MBD","nevembro 2018",null,1976,null,1976,null,1917,null,1917," ",97.014170040485823," ",97.014170040485823]

{"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 - Albendazole (ALB) ou Mebendazole (MBD) - Tournée 2"]
["Structure administrative, population nécessitant une chimioprévention par groupe d'âge, population traitée par groupe d'âge et couverture"]
[]
["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":" "}]
[]
["Structure administrative du pays",null,null,"Mise en oeuvre \nde la CP","Médica-ment","Date","Population ciblée pour T3",null,null,null,"Population traitée",null,null,null,"Couverture du Programme (%)"]
["Pays","Région/Département","District",null,null,null,"EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","Total","EAPréS","EAS","Adultes","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]]}
["Nombre d'individus traités"]
["Structure administrative, population traitée par groupe d'âge et sexe"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":201784},{"$f":"SUM(E$9:E$1000)","v":78135},{"$f":"SUM(F$9:F$1000)","v":84377},{"$f":"SUM(G$9:G$1000)","v":162512},{"$f":"SUM(H$9:H$1000)","v":162512},{"$f":"IF(D4>0, IF(H4/D4*100<>0, H4/D4*100, \"-\"),0)","v":80.537604567260033},{"$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":77687},{"$f":"SUM(Q$9:Q$1000)","v":18470},{"$f":"SUM(R$9:R$1000)","v":17526},{"$f":"SUM(S$9:S$1000)","v":162512},{"$f":"SUM(T$9:T$1000)","v":16561},null,52313,null,{"$f":"SUM(X$9:X$1000)","v":68874},{"$f":"IF(P4>0, IF(X4/P4*100<>0, X4/P4*100, \"-\"),0)","v":88.655759650906845},{"$f":"SUM(Z$9:Z$1000)","v":38154.740000000005},11704,11099,22803,16835,null,0,null,16835,{"$f":"IF(Z4>0, IF(AH4/Z4*100<>0, AH4/Z4*100, \"-\"),0)","v":44.122958248437804}]
[]
["Structure administrative du pays",null,null,"Population nécessitant la CP pour FL","Population traitée pour la filariose lymphatique",null,null,null,null,"Population nécessitant la CP pour ONCHO","Population traitée pour l'onchocercose",null,null,null,null,"Population nécessitant la CP pour STH","Population traitée pour les géohelminthiases",null,null,null,null,null,null,null,null,"Population nécessitant la CP pour SCH","Population traitée pour la schistosomiase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP9:AP1000)","v":6454.9999999999982},24818.999999999996,52868,117642.00000000001,{"$f":"SUM(AT9:AT1000)","v":201784},{"$f":"COUNTIF(AU9:AU1000,\"Y\")","v":2},{"$f":"SUM(AV9:AV1000)","v":16561},55654,90297,{"$f":"SUM(AY9:AY1000)","v":162512},16561,55654,90297,162512,{"$f":"IF(AT6<>0,BC6/AT6,0)","v":0.80537604567260035}]
["Pays","Région/Département","District",null,"Masculine","Féminine","Total traité","Total traité ayant besoin de CP","(%)",null,"Masculine","Féminine","Total traité","Total traité ayant besoin de CP","(%)",null,"Masculine","Féminine","Total traité","EAPréS traité ayant besoin de CP","EAPréS (%)","EAS traité ayant besoin de CP","EAS (%)","Total traité ayant besoin de CP","(%)",null,"Masculine","Féminine","Total traité","EAS traité ayant besoin de CP","EAS (%)","Adultes traité ayant besoin de CP","Adultes (%)","Total traité ayant besoin de CP","(%)",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":77689},31018,35320,{"$f":"MAX('MDA1'!M9,'MDA2'!M9)","v":66338},{"$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":66338},{"$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":85.389179935383382},{"$f":"COUNTRY_INFO!M9","v":"Non requis"},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":29911},7451,7073,{"$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":66338},{"$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":6613},{"$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":69.202595228128928},{"$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":20355},{"$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":100},{"$f":"SUM(T9,V9)","v":26968},{"$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":90.160810404199125},{"$f":"COUNTRY_INFO!O9","v":19236.099999999999},7451,7073,{"$f":"MAX('T1'!L9,'T2'!J9)+MAX('T1'!M9,'T2'!K9)+MAX('T1'!N9,'T2'!L9)","v":14524},{"$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":10177.5},{"$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":10177.5},{"$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.908333809867912},null,{"$f":"IF(AND(D9<>0, D9<>\"Inconnu\",D9<>\"Interrompu\",D9<>\"Non requis\"),D9/COUNTRY_INFO!D9, 0)","v":1},{"$f":"IF(AND(J9<>0,J9<>\"Inconnu\",J9<>\"Interrompu\",J9<>\"Non requis\"),J9/COUNTRY_INFO!D9, 0)","v":0},{"$f":"IF(AND(P9<>0,P9<>\"Inconnu\",P9<>\"Non requis\"),P9/(COUNTRY_INFO!E9+COUNTRY_INFO!F9), 0)","v":1},{"$f":"IF(AND(Z9<>0,Z9<>\"Inconnu\",Z9<>\"Non requis\"),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.52908333809867913},{"$f":"IF(AND(Z9<>0,Z9<>\"Inconnu\",Z9<>\"Non requis\"),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.47091666190132103},{"$f":"MAX(COUNTRY_INFO!D9*AK9*PROFILE!$G$7,COUNTRY_INFO!D9*AL9*PROFILE!$G$7)","v":2485.2440976489711},{"$f":"MAX(COUNTRY_INFO!D9*AK9*PROFILE!$G$8,COUNTRY_INFO!D9*AL9*PROFILE!$G$8,COUNTRY_INFO!D9*AM9*PROFILE!$G$8)","v":9555.5806753756478},{"$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<>\"Inconnu\",Z9<>\"Non requis\"),COUNTRY_INFO!O9*DISTRICT!AN9,0))","v":20354.745926337073},{"$f":"MAX(COUNTRY_INFO!D9*AK9*PROFILE!$G$10,COUNTRY_INFO!D9*AL9*PROFILE!$G$10,IF(AND(DISTRICT!Z9<>\"Inconnu\",Z9<>\"Non requis\"),COUNTRY_INFO!O9*DISTRICT!AO9,0))","v":45293.429300638309},{"$f":"SUM(AP9:AS9)","v":77689},{"$f":"IF(COUNTIFS(AK9:AN9,\">0\")=0,0, IF(COUNTIFS(AK9:AN9,\">0\")<=IF(AND(OR(D9>=0,D9=\"Non requis\",D9=\"Inconnu\",D9=\"Interrompu\"),D9>0,H9>0),1,0)+IF(AND(OR(J9>=0,J9=\"Non requis\",J9=\"Inconnu\",J9=\"Interrompu\"),J9>0,N9>0),1,0)+IF(AND(OR(P9>=0,P9=\"Non requis\",P9=\"Inconnu\"),P9>0,X9>0),1,0)+IF(AND(OR(Z9>=0,Z9=\"Non requis\",Z9=\"Inconnu\"),Z9>0,AH9>0),1,0),\"Y\",0))","v":"Y"},{"$f":"MAX('MDA2'!J9,'T1'!L9,'T2'!J9,T3_R1!K9,T3_R2!K9)","v":6613},{"$f":"MAX('MDA1'!K9,'MDA2'!K9,'MDA3'!I9,'MDA3'!L9,'T1'!M9,'T2'!K9,T3_R1!L9,T3_R2!L9)","v":21852},{"$f":"MAX('MDA1'!L9,'MDA2'!L9,'MDA3'!J9,'MDA3'!M9,'T1'!N9,'T2'!L9,T3_R1!M9,T3_R2!M9)","v":37873},{"$f":"SUM(AV9:AX9)","v":66338},{"$f":"MAX('MDA2'!J9,T9)","v":6613},{"$f":"MAX('MDA1'!K9,'MDA2'!K9,'MDA3'!I9,'MDA3'!L9,V9,AD9)","v":21852},{"$f":"MAX('MDA1'!L9,'MDA2'!L9,'MDA3'!J9,'MDA3'!M9,AF9)","v":37873},{"$f":"IF(AT9<SUM(AZ9:BB9), AT9,SUM(AZ9:BB9))","v":66338},{"$f":"IF(AT9<>0,BC9/AT9*100,0)","v":85.389179935383382}]
[{"$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":50821},16168,17743,{"$f":"MAX('MDA1'!M10,'MDA2'!M10)","v":33911},{"$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":33911},{"$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":66.726353279156257},{"$f":"COUNTRY_INFO!M10","v":"Non requis"},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":19566},4253,4026,{"$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":33911},{"$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":3505},{"$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":56.07102863541833},{"$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":12810},{"$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":96.20728501689824},{"$f":"SUM(T10,V10)","v":16315},{"$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":83.384442400081767},{"$f":"COUNTRY_INFO!O10","v":12583.3},4253,4026,{"$f":"MAX('T1'!L10,'T2'!J10)+MAX('T1'!M10,'T2'!K10)+MAX('T1'!N10,'T2'!L10)","v":8279},{"$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":6657.5},{"$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":6657.5},{"$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.907424920330911},null,{"$f":"IF(AND(D10<>0, D10<>\"Inconnu\",D10<>\"Interrompu\",D10<>\"Non requis\"),D10/COUNTRY_INFO!D10, 0)","v":1},{"$f":"IF(AND(J10<>0,J10<>\"Inconnu\",J10<>\"Interrompu\",J10<>\"Non requis\"),J10/COUNTRY_INFO!D10, 0)","v":0},{"$f":"IF(AND(P10<>0,P10<>\"Inconnu\",P10<>\"Non requis\"),P10/(COUNTRY_INFO!E10+COUNTRY_INFO!F10), 0)","v":1},{"$f":"IF(AND(Z10<>0,Z10<>\"Inconnu\",Z10<>\"Non requis\"),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.52907424920330914},{"$f":"IF(AND(Z10<>0,Z10<>\"Inconnu\",Z10<>\"Non requis\"),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.47092575079669091},{"$f":"MAX(COUNTRY_INFO!D10*AK10*PROFILE!$G$7,COUNTRY_INFO!D10*AL10*PROFILE!$G$7)","v":1625.7461196130514},{"$f":"MAX(COUNTRY_INFO!D10*AK10*PROFILE!$G$8,COUNTRY_INFO!D10*AL10*PROFILE!$G$8,COUNTRY_INFO!D10*AM10*PROFILE!$G$8)","v":6250.8741971613208},{"$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<>\"Inconnu\",Z10<>\"Non requis\"),COUNTRY_INFO!O10*DISTRICT!AN10,0))","v":13315.251100186339},{"$f":"MAX(COUNTRY_INFO!D10*AK10*PROFILE!$G$10,COUNTRY_INFO!D10*AL10*PROFILE!$G$10,IF(AND(DISTRICT!Z10<>\"Inconnu\",Z10<>\"Non requis\"),COUNTRY_INFO!O10*DISTRICT!AO10,0))","v":29629.128583039292},{"$f":"SUM(AP10:AS10)","v":50821},"Y",{"$f":"MAX('MDA2'!J10,'T1'!L10,'T2'!J10,T3_R1!K10,T3_R2!K10)","v":3505},{"$f":"MAX('MDA1'!K10,'MDA2'!K10,'MDA3'!I10,'MDA3'!L10,'T1'!M10,'T2'!K10,T3_R1!L10,T3_R2!L10)","v":12810},{"$f":"MAX('MDA1'!L10,'MDA2'!L10,'MDA3'!J10,'MDA3'!M10,'T1'!N10,'T2'!L10,T3_R1!M10,T3_R2!M10)","v":17596},{"$f":"SUM(AV10:AX10)","v":33911},{"$f":"MAX('MDA2'!J10,T10)","v":3505},{"$f":"MAX('MDA1'!K10,'MDA2'!K10,'MDA3'!I10,'MDA3'!L10,V10,AD10)","v":12810},{"$f":"MAX('MDA1'!L10,'MDA2'!L10,'MDA3'!J10,'MDA3'!M10,AF10)","v":17596},33911,66.726353279156257]
[{"$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":21988},8627,10008,{"$f":"MAX('MDA1'!M11,'MDA2'!M11)","v":18635},{"$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":18635},{"$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":84.750773148990362},{"$f":"COUNTRY_INFO!M11","v":"Non requis"},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":8466},1776,1603,{"$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":18635},{"$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":2011},{"$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":74.343807763401102},{"$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":5761},{"$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":100},7772,{"$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":91.802504134183792},{"$f":"COUNTRY_INFO!O11","v":1901.13},null,null,{"$f":"MAX('T1'!L11,'T2'!J11)+MAX('T1'!M11,'T2'!K11)+MAX('T1'!N11,'T2'!L11)","v":0},{"$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":0},{"$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":0},{"$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},0,{"$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":"-"},null,{"$f":"IF(AND(D11<>0, D11<>\"Inconnu\",D11<>\"Interrompu\",D11<>\"Non requis\"),D11/COUNTRY_INFO!D11, 0)","v":1},{"$f":"IF(AND(J11<>0,J11<>\"Inconnu\",J11<>\"Interrompu\",J11<>\"Non requis\"),J11/COUNTRY_INFO!D11, 0)","v":0},{"$f":"IF(AND(P11<>0,P11<>\"Inconnu\",P11<>\"Non requis\"),P11/(COUNTRY_INFO!E11+COUNTRY_INFO!F11), 0)","v":1},{"$f":"IF(AND(Z11<>0,Z11<>\"Inconnu\",Z11<>\"Non requis\"),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<>\"Inconnu\",Z11<>\"Non requis\"),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":703.38847480474158},{"$f":"MAX(COUNTRY_INFO!D11*AK11*PROFILE!$G$8,COUNTRY_INFO!D11*AL11*PROFILE!$G$8,COUNTRY_INFO!D11*AM11*PROFILE!$G$8)","v":2704.4769258216706},{"$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<>\"Inconnu\",Z11<>\"Non requis\"),COUNTRY_INFO!O11*DISTRICT!AN11,0))","v":5760.9205090591922},{"$f":"MAX(COUNTRY_INFO!D11*AK11*PROFILE!$G$10,COUNTRY_INFO!D11*AL11*PROFILE!$G$10,IF(AND(DISTRICT!Z11<>\"Inconnu\",Z11<>\"Non requis\"),COUNTRY_INFO!O11*DISTRICT!AO11,0))","v":12819.214090314395},21988,0,{"$f":"MAX('MDA2'!J11,'T1'!L11,'T2'!J11,T3_R1!K11,T3_R2!K11)","v":2011},{"$f":"MAX('MDA1'!K11,'MDA2'!K11,'MDA3'!I11,'MDA3'!L11,'T1'!M11,'T2'!K11,T3_R1!L11,T3_R2!L11)","v":6813},{"$f":"MAX('MDA1'!L11,'MDA2'!L11,'MDA3'!J11,'MDA3'!M11,'T1'!N11,'T2'!L11,T3_R1!M11,T3_R2!M11)","v":9811},18635,{"$f":"MAX('MDA2'!J11,T11)","v":2011},{"$f":"MAX('MDA1'!K11,'MDA2'!K11,'MDA3'!I11,'MDA3'!L11,V11,AD11)","v":6813},{"$f":"MAX('MDA1'!L11,'MDA2'!L11,'MDA3'!J11,'MDA3'!M11,AF11)","v":9811},18635,84.750773148990362]
[{"$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":19394},7458,7333,{"$f":"MAX('MDA1'!M12,'MDA2'!M12)","v":14791},{"$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":14791},{"$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":76.265855419201813},{"$f":"COUNTRY_INFO!M12","v":"Non requis"},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":7466},1667,1641,{"$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":14791},{"$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":1561},{"$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":65.45073375262055},{"$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":5031},{"$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":99.015941743751227},6592,{"$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":88.29359764264666},{"$f":"COUNTRY_INFO!O12","v":1676.73},null,null,{"$f":"MAX('T1'!L12,'T2'!J12)+MAX('T1'!M12,'T2'!K12)+MAX('T1'!N12,'T2'!L12)","v":0},{"$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":0},{"$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":0},{"$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},0,{"$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":"-"},null,{"$f":"IF(AND(D12<>0, D12<>\"Inconnu\",D12<>\"Interrompu\",D12<>\"Non requis\"),D12/COUNTRY_INFO!D12, 0)","v":1},{"$f":"IF(AND(J12<>0,J12<>\"Inconnu\",J12<>\"Interrompu\",J12<>\"Non requis\"),J12/COUNTRY_INFO!D12, 0)","v":0},{"$f":"IF(AND(P12<>0,P12<>\"Inconnu\",P12<>\"Non requis\"),P12/(COUNTRY_INFO!E12+COUNTRY_INFO!F12), 0)","v":1},{"$f":"IF(AND(Z12<>0,Z12<>\"Inconnu\",Z12<>\"Non requis\"),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<>\"Inconnu\",Z12<>\"Non requis\"),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":620.40731673472612},{"$f":"MAX(COUNTRY_INFO!D12*AK12*PROFILE!$G$8,COUNTRY_INFO!D12*AL12*PROFILE!$G$8,COUNTRY_INFO!D12*AM12*PROFILE!$G$8)","v":2385.4204793244262},{"$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<>\"Inconnu\",Z12<>\"Non requis\"),COUNTRY_INFO!O12*DISTRICT!AN12,0))","v":5081.2848987035641},{"$f":"MAX(COUNTRY_INFO!D12*AK12*PROFILE!$G$10,COUNTRY_INFO!D12*AL12*PROFILE!$G$10,IF(AND(DISTRICT!Z12<>\"Inconnu\",Z12<>\"Non requis\"),COUNTRY_INFO!O12*DISTRICT!AO12,0))","v":11306.887305237284},19394,0,{"$f":"MAX('MDA2'!J12,'T1'!L12,'T2'!J12,T3_R1!K12,T3_R2!K12)","v":1561},{"$f":"MAX('MDA1'!K12,'MDA2'!K12,'MDA3'!I12,'MDA3'!L12,'T1'!M12,'T2'!K12,T3_R1!L12,T3_R2!L12)","v":5031},{"$f":"MAX('MDA1'!L12,'MDA2'!L12,'MDA3'!J12,'MDA3'!M12,'T1'!N12,'T2'!L12,T3_R1!M12,T3_R2!M12)","v":8199},14791,{"$f":"MAX('MDA2'!J12,T12)","v":1561},{"$f":"MAX('MDA1'!K12,'MDA2'!K12,'MDA3'!I12,'MDA3'!L12,V12,AD12)","v":5031},{"$f":"MAX('MDA1'!L12,'MDA2'!L12,'MDA3'!J12,'MDA3'!M12,AF12)","v":8199},14791,76.265855419201813]
[{"$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":16272},7348,6844,{"$f":"MAX('MDA1'!M13,'MDA2'!M13)","v":14192},{"$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":14192},{"$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":87.217305801376597},{"$f":"COUNTRY_INFO!M13","v":"Non requis"},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":6264},1638,1543,{"$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":14192},{"$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":1467},{"$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":73.313343328335833},{"$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":4263},{"$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":100},5730,{"$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":91.475095785440601},{"$f":"COUNTRY_INFO!O13","v":1406.79},null,null,{"$f":"MAX('T1'!L13,'T2'!J13)+MAX('T1'!M13,'T2'!K13)+MAX('T1'!N13,'T2'!L13)","v":0},{"$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":0},{"$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":0},{"$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},0,{"$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":"-"},null,{"$f":"IF(AND(D13<>0, D13<>\"Inconnu\",D13<>\"Interrompu\",D13<>\"Non requis\"),D13/COUNTRY_INFO!D13, 0)","v":1},{"$f":"IF(AND(J13<>0,J13<>\"Inconnu\",J13<>\"Interrompu\",J13<>\"Non requis\"),J13/COUNTRY_INFO!D13, 0)","v":0},{"$f":"IF(AND(P13<>0,P13<>\"Inconnu\",P13<>\"Non requis\"),P13/(COUNTRY_INFO!E13+COUNTRY_INFO!F13), 0)","v":1},{"$f":"IF(AND(Z13<>0,Z13<>\"Inconnu\",Z13<>\"Non requis\"),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<>\"Inconnu\",Z13<>\"Non requis\"),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":520.53562224953407},{"$f":"MAX(COUNTRY_INFO!D13*AK13*PROFILE!$G$8,COUNTRY_INFO!D13*AL13*PROFILE!$G$8,COUNTRY_INFO!D13*AM13*PROFILE!$G$8)","v":2001.4211632240415},{"$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<>\"Inconnu\",Z13<>\"Non requis\"),COUNTRY_INFO!O13*DISTRICT!AN13,0))","v":4263.3117392855729},{"$f":"MAX(COUNTRY_INFO!D13*AK13*PROFILE!$G$10,COUNTRY_INFO!D13*AL13*PROFILE!$G$10,IF(AND(DISTRICT!Z13<>\"Inconnu\",Z13<>\"Non requis\"),COUNTRY_INFO!O13*DISTRICT!AO13,0))","v":9486.7314752408511},16272,0,{"$f":"MAX('MDA2'!J13,'T1'!L13,'T2'!J13,T3_R1!K13,T3_R2!K13)","v":1467},{"$f":"MAX('MDA1'!K13,'MDA2'!K13,'MDA3'!I13,'MDA3'!L13,'T1'!M13,'T2'!K13,T3_R1!L13,T3_R2!L13)","v":4839},{"$f":"MAX('MDA1'!L13,'MDA2'!L13,'MDA3'!J13,'MDA3'!M13,'T1'!N13,'T2'!L13,T3_R1!M13,T3_R2!M13)","v":7886},14192,{"$f":"MAX('MDA2'!J13,T13)","v":1467},{"$f":"MAX('MDA1'!K13,'MDA2'!K13,'MDA3'!I13,'MDA3'!L13,V13,AD13)","v":4839},{"$f":"MAX('MDA1'!L13,'MDA2'!L13,'MDA3'!J13,'MDA3'!M13,AF13)","v":7886},14192,87.217305801376597]
[{"$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":7202},3437,3276,{"$f":"MAX('MDA1'!M14,'MDA2'!M14)","v":6713},{"$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":6713},{"$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":93.21021938350458},{"$f":"COUNTRY_INFO!M14","v":"Non requis"},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":2773},713,695,{"$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":6713},{"$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":594},{"$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":67.042889390519193},{"$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":1887},{"$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":100},2481,{"$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":89.469888207717275},{"$f":"COUNTRY_INFO!O14","v":622.71},null,null,{"$f":"MAX('T1'!L14,'T2'!J14)+MAX('T1'!M14,'T2'!K14)+MAX('T1'!N14,'T2'!L14)","v":0},{"$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":0},{"$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":0},{"$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},0,{"$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":"-"},null,{"$f":"IF(AND(D14<>0, D14<>\"Inconnu\",D14<>\"Interrompu\",D14<>\"Non requis\"),D14/COUNTRY_INFO!D14, 0)","v":1},{"$f":"IF(AND(J14<>0,J14<>\"Inconnu\",J14<>\"Interrompu\",J14<>\"Non requis\"),J14/COUNTRY_INFO!D14, 0)","v":0},{"$f":"IF(AND(P14<>0,P14<>\"Inconnu\",P14<>\"Non requis\"),P14/(COUNTRY_INFO!E14+COUNTRY_INFO!F14), 0)","v":1},{"$f":"IF(AND(Z14<>0,Z14<>\"Inconnu\",Z14<>\"Non requis\"),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<>\"Inconnu\",Z14<>\"Non requis\"),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":230.38947587519326},{"$f":"MAX(COUNTRY_INFO!D14*AK14*PROFILE!$G$8,COUNTRY_INFO!D14*AL14*PROFILE!$G$8,COUNTRY_INFO!D14*AM14*PROFILE!$G$8)","v":885.83058121555723},{"$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<>\"Inconnu\",Z14<>\"Non requis\"),COUNTRY_INFO!O14*DISTRICT!AN14,0))","v":1886.9451294453477},{"$f":"MAX(COUNTRY_INFO!D14*AK14*PROFILE!$G$10,COUNTRY_INFO!D14*AL14*PROFILE!$G$10,IF(AND(DISTRICT!Z14<>\"Inconnu\",Z14<>\"Non requis\"),COUNTRY_INFO!O14*DISTRICT!AO14,0))","v":4198.8348134639018},7202,0,{"$f":"MAX('MDA2'!J14,'T1'!L14,'T2'!J14,T3_R1!K14,T3_R2!K14)","v":594},{"$f":"MAX('MDA1'!K14,'MDA2'!K14,'MDA3'!I14,'MDA3'!L14,'T1'!M14,'T2'!K14,T3_R1!L14,T3_R2!L14)","v":2045},{"$f":"MAX('MDA1'!L14,'MDA2'!L14,'MDA3'!J14,'MDA3'!M14,'T1'!N14,'T2'!L14,T3_R1!M14,T3_R2!M14)","v":4074},6713,{"$f":"MAX('MDA2'!J14,T14)","v":594},{"$f":"MAX('MDA1'!K14,'MDA2'!K14,'MDA3'!I14,'MDA3'!L14,V14,AD14)","v":2045},{"$f":"MAX('MDA1'!L14,'MDA2'!L14,'MDA3'!J14,'MDA3'!M14,AF14)","v":4074},6713,93.21021938350458]
[{"$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":8418},4079,3853,{"$f":"MAX('MDA1'!M15,'MDA2'!M15)","v":7932},{"$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":7932},{"$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":94.226657163221674},{"$f":"COUNTRY_INFO!M15","v":"Non requis"},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":3241},972,945,{"$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":7932},{"$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":810},{"$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":78.260869565217391},{"$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":2206},{"$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},3016,{"$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":93.05769824128356},{"$f":"COUNTRY_INFO!O15","v":727.98},null,null,{"$f":"MAX('T1'!L15,'T2'!J15)+MAX('T1'!M15,'T2'!K15)+MAX('T1'!N15,'T2'!L15)","v":0},{"$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":0},{"$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":0},{"$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},0,{"$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":"-"},null,{"$f":"IF(AND(D15<>0, D15<>\"Inconnu\",D15<>\"Interrompu\",D15<>\"Non requis\"),D15/COUNTRY_INFO!D15, 0)","v":1},{"$f":"IF(AND(J15<>0,J15<>\"Inconnu\",J15<>\"Interrompu\",J15<>\"Non requis\"),J15/COUNTRY_INFO!D15, 0)","v":0},{"$f":"IF(AND(P15<>0,P15<>\"Inconnu\",P15<>\"Non requis\"),P15/(COUNTRY_INFO!E15+COUNTRY_INFO!F15), 0)","v":1},{"$f":"IF(AND(Z15<>0,Z15<>\"Inconnu\",Z15<>\"Non requis\"),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<>\"Inconnu\",Z15<>\"Non requis\"),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":269.28889307378182},{"$f":"MAX(COUNTRY_INFO!D15*AK15*PROFILE!$G$8,COUNTRY_INFO!D15*AL15*PROFILE!$G$8,COUNTRY_INFO!D15*AM15*PROFILE!$G$8)","v":1035.3959778773342},{"$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<>\"Inconnu\",Z15<>\"Non requis\"),COUNTRY_INFO!O15*DISTRICT!AN15,0))","v":2205.5406969829123},{"$f":"MAX(COUNTRY_INFO!D15*AK15*PROFILE!$G$10,COUNTRY_INFO!D15*AL15*PROFILE!$G$10,IF(AND(DISTRICT!Z15<>\"Inconnu\",Z15<>\"Non requis\"),COUNTRY_INFO!O15*DISTRICT!AO15,0))","v":4907.7744320659713},8418,0,{"$f":"MAX('MDA2'!J15,'T1'!L15,'T2'!J15,T3_R1!K15,T3_R2!K15)","v":810},{"$f":"MAX('MDA1'!K15,'MDA2'!K15,'MDA3'!I15,'MDA3'!L15,'T1'!M15,'T2'!K15,T3_R1!L15,T3_R2!L15)","v":2264},{"$f":"MAX('MDA1'!L15,'MDA2'!L15,'MDA3'!J15,'MDA3'!M15,'T1'!N15,'T2'!L15,T3_R1!M15,T3_R2!M15)","v":4858},7932,{"$f":"MAX('MDA2'!J15,T15)","v":810},{"$f":"MAX('MDA1'!K15,'MDA2'!K15,'MDA3'!I15,'MDA3'!L15,V15,AD15)","v":2264},{"$f":"MAX('MDA1'!L15,'MDA2'!L15,'MDA3'!J15,'MDA3'!M15,AF15)","v":4858},7932,94.226657163221674]

{"sheet":"SUMMARY","index":10,"n_rows":71,"n_cols":8,"rows_kept":71,"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],[70,1,70,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[67,1,67,7],[54,1,60,7],[69,1,69,2],[49,1,49,7],[50,3,50,4],[63,1,63,3],[63,4,63,7],[64,4,65,7],[65,1,65,3],[62,1,62,7]]}
[]
[null,"Formulaire de Rapport Commun v.3.1"]
[]
[null,"Pays",null,{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\" \")","v":"STP"},null,null,"Année",{"$f":"IF(INTRO!$E$36<>0,INTRO!$E$36,\" \")","v":2018}]
[]
[null,"Les autorités nationales sont priées de compléter ce formulaire de rapport commun et de le soumettre à l'Organisation mondiale de la Santé avant le 15 août de l'année en cours pour rapporter les données des activités de chimioprévention mises en oeuvre l'année précédente. "]
[]
[]
[]
[]
[]
[]
[]
[null,"Nombre de personnes ayant reçu un traitement (au moins une fois) pour les maladies"]
[]
[null,null,null,null,"EAPréS","EAS","Adultes","Total"]
[null,"Filariose lymphatique",null,null,16561,55654,90297,{"$f":"SUM(E17:G17)","v":162512}]
[null,"Onchocercose",null,null,"Non admissible",0,0,{"$f":"SUM(E18:G18)","v":0}]
[null,"Géohelminthiases",null,null,16561,55654,90297,{"$f":"SUM(E19:G19)","v":162512}]
[null,"Schistosomiase",null,null,"Non ciblé",22803,0,{"$f":"SUM(E20:G20)","v":22803}]
[]
[null,"Couverture des interventions de CP contre les maladies (%) "]
[]
[null,null,null,null,null,null,"Géographique","National"]
[null,"Filariose lymphatique",null,null,null,null,100,80.537604567260033]
[null,"Onchocercose",null,null,null,null,0,0]
[null,"Géohelminthiases",null,null,null,null,100,88.655759650906845]
[null,"Schistosomiase",null,null,null,null,28.571428571428573,44.122958248437804]
[]
[null,"Nombre de personnes traitées et couverture du programme en pourcentage, par intervention de CP"]
[]
[null,null,null,"EAPréS","EAS","Adultes","Total","Couverture"]
[null,"MDA 1 (IVM+ALB)",null,"Non admissible",{"$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":16561},{"$f":"'MDA2'!$K$4","v":55654},{"$f":"'MDA2'!$L$4","v":90297},{"$f":"'MDA2'!$M$4","v":162512},{"$f":"'MDA2'!$Q$4","v":86.348884493685034}]
[null,"MDA 3 (IVM)",null,"Non admissible",{"$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,\"Non ciblé\")","v":"Non ciblé"},{"$f":"'T1'!$M$4","v":22803},{"$f":"IF('T1'!$N$4<>0,'T1'!$N$4,\"Non ciblé\")","v":"Non ciblé"},{"$f":"'T1'!$O$4","v":22803},{"$f":"'T1'!$S$4","v":94.901781255202266}]
[null,"T 2 (PZQ)",null,{"$f":"IF('T2'!$J$4<>0,'T2'!$J$4,\"Non ciblé\")","v":"Non ciblé"},{"$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) - tournée 1",null,{"$f":"T3_R1!$K$4","v":0},{"$f":"T3_R1!$L$4","v":13210},{"$f":"IF(T3_R1!$M$4<>0,T3_R1!$M$4,\"Non ciblé\")","v":"Non ciblé"},{"$f":"T3_R1!$N$4","v":13210},{"$f":"T3_R1!$R$4","v":92.448736790538177}]
[null,"T 3 (ALB/MBD) - tournée 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,\"Non ciblé\")","v":"Non ciblé"},{"$f":"T3_R2!$N$4","v":0},{"$f":"T3_R2!$R$4","v":" "}]
[]
[null,"Inventaire des médicaments pour la chimiothérapie préventive dans le pays"]
[]
[null,null,"IVM","DEC","ALB (FL)","ALB (STH)","MBD","PZQ"]
[null,"Disponible"]
[null,"Distribué"]
[null,"Gaspillé"]
[null,"Reçus"]
[null,"Restant",{"$f":"C44-C45-C46+C47","v":0},0,0,0,0,0]
[]
[null,"Veuillez indiquer le médicament qui a été utilisé pour traiter les EAPréS, et les mécanismes de distribution"]
[null,"Médicament",null,"Mécanismes de distribution",null,null,"Source"]
[]
[null,"Remarques supplémentaires évenuelles concernant le rapport"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"         J’ai pris connaissance et accepté la politique de la communication de données de l’OMS"]
[null,"Nom et signature du Coordonnateur MTN \nou du Représentant du Ministère de la Santé :",null,null,"Alzira Segunda silva do Rosário "]
[null,null,null,null,"16 de Agosto 2019"]
[null,"Date:"]
[]
[null,"Veuillez envoyer le rapport national (signé et sous format électronique) au représentant de l'OMS du pays en mettant en copie :"]
[]
[null,"Siège de l'OMS ",null,"PC_JointForms@who.int"]
[null,"Bureau régional de l'OMS",null,"Conseiller régional MTN"]

{"sheet":"PROFILE","index":11,"n_rows":124,"n_cols":8,"rows_kept":124,"cut":false,"hidden":true,"merged":[[16,1,16,6],[18,1,18,6],[14,1,14,6],[15,1,15,6],[7,4,7,5],[8,4,8,5],[9,4,9,5],[7,1,7,3],[8,1,8,3],[9,1,9,3],[17,1,17,6],[63,1,63,3],[25,1,25,3],[0,1,0,5],[1,1,1,7],[3,3,3,5],[5,3,5,5],[4,1,4,7],[5,1,5,2],[11,1,11,6],[6,1,6,3],[6,4,6,5],[12,1,12,6],[47,1,47,3],[51,1,51,3],[13,1,13,6],[27,1,27,3],[28,1,28,3],[59,1,59,3],[30,1,30,3],[34,1,34,3],[42,1,42,3],[81,1,81,3],[19,1,19,6],[43,1,43,3],[77,1,77,3],[80,1,80,3],[78,1,78,3],[23,1,23,3],[20,1,20,6],[79,1,79,3],[55,1,55,3],[65,1,65,3],[29,1,29,3],[21,1,21,6],[69,1,69,3],[73,1,73,3],[26,1,26,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,"Formulaire de Rapport Commun v.3.1 - CP"]
[]
[null,"Pays",null,{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\" \")","v":"STP"},null,null,"Année",{"$f":"IF(INTRO!$E$36<>0,INTRO!$E$36,\" \")","v":2018}]
[null,"!!! ATTENTION !!!\nAvant d’analyser les données dans le profil du pays, merci de vous assurer que le rapport dans l’onglet SUMMARY est bien mis à jour"]
[null,"Population totale ",null,null,null,null,1,{"$f":"COUNTRY_INFO!D4","v":201784}]
[null,"Population — autres groupes d’âge",null,null,null,null,{"$f":"IF($H$6<>0,H7/$H$6,0)","v":3.1989652301470876E-2},{"$f":"H6-SUM(H8:H10)","v":6455}]
[null,"Population — EAPréS",null,null,{"$f":"INTRO!B48","v":"1-4 ans"},null,{"$f":"IF($H$6<>0,H8/$H$6,0)","v":0.12299785909685604},{"$f":"COUNTRY_INFO!E4","v":24819}]
[null,"Population — EAS",null,null,{"$f":"INTRO!B49","v":"5-14 ans"},null,{"$f":"IF($H$6<>0,H9/$H$6,0)","v":0.26200293383023432},{"$f":"COUNTRY_INFO!F4","v":52868}]
[null,"Population — Adults",null,null,{"$f":"INTRO!B50","v":"15 ans et plus"},null,0.58300955477143879,{"$f":"COUNTRY_INFO!G4","v":117642}]
[]
[null,"Nombre total d’individus nécessitant une CP pour au moins une des maladies (FL, Oncho, STH, SCH)",null,null,null,null,null,{"$f":"DISTRICT!AT6","v":201784}]
[null,"Proportion du nombre d’individus nécessitant un CP pour au moins une maladie parmi la population totale",null,null,null,null,null,{"$f":"IF(H6<>0,H12/H6,0)","v":1}]
[null,"Nombre d’UMOs nécessitant une CP pour au moins une des maladies (FL, Oncho, STH, SCH)",null,null,null,null,null,{"$f":"COUNTIF(DISTRICT!AT9:AT1000,\">0\")","v":7}]
[null,"Nombre d’UMOs ayant reçu une CP pour au moins une des maladies (FL, Oncho, STH, SCH)",null,null,null,null,null,{"$f":"COUNTIF(DISTRICT!AY9:AY1000,\">0\")","v":7}]
[null,"Proportion d’UMOs nécessitant une CP pour au moins une maladie et l’ayant reçue",null,null,null,null,null,{"$f":"IF(H14<>0,H15/H14,0)","v":1}]
[null,"Nombre total d’individus ayant été traités pour au moins une maladie (FL, Oncho, STH, SCH)",null,null,null,null,null,{"$f":"DISTRICT!AY6","v":162512}]
[null,"Nombre total d’individus nécessitant un traitement ayant reçu une CP pour au moins une maladie (FL, Oncho, STH, SCH)",null,null,null,null,null,{"$f":"DISTRICT!BC6","v":162512}]
[null,"Couverture CP pour au moins une maladie (FL, Oncho, STH, SCH)",null,null,null,null,null,{"$f":"DISTRICT!BD6","v":0.80537604567260035}]
[null,"Nombre d’UMOs ayant été traitées pour toutes les maladies nécessitant une CP dans ces unités",null,null,null,null,null,{"$f":"DISTRICT!AU6","v":2}]
[null,"Population nécessitant une CP dans des UMOs qui ont été traitées pour toutes les maladies requérant une CP",null,null,null,null,null,{"$f":"SUMIF(DISTRICT!AU9:AU1000,\"Y\",DISTRICT!AT9:AT1000)","v":128510}]
[null,"Population ayant reçu une CP dans des UMOs qui ont été traitées pour toutes les maladies nécessitant une CP",null,null,null,null,null,{"$f":"SUMIF(DISTRICT!AU9:AU1000,\"Y\",DISTRICT!AY9:AY1000)","v":100249}]
[]
[null,null,null,null,"FL","ONCHO","STH","SCH"]
[]
[null,"Maladies nécessitant une CP dans la pays",null,null,{"$f":"IF(INTRO!E38=\"Endémique\",\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(INTRO!E40=\"Endémique\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(INTRO!E42=\"Endémique\",\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(INTRO!E44=\"Endémique\",\"Yes\",\"No\")","v":"Yes"}]
[null,"Nombre d’UMOs dans le pays",null,null,{"$f":"IF(E26=\"Yes\",INTRO!$E$46,\"-\")","v":7},{"$f":"IF(F26=\"Yes\",INTRO!$E$46,\"-\")","v":"-"},{"$f":"IF(G26=\"Yes\",INTRO!$E$46,\"-\")","v":7},{"$f":"IF(H26=\"Yes\",INTRO!$E$46,\"-\")","v":7}]
[null,"Nombre d’UMOs dont le statut d’endémicité est connu",null,null,{"$f":"IF(E26=\"Yes\",E27-E29,\"-\")","v":7},{"$f":"IF(F26=\"Yes\",F27-F29,\"-\")","v":"-"},{"$f":"IF(G26=\"Yes\",G27-G29,\"-\")","v":7},{"$f":"IF(H26=\"Yes\",H27-H29,\"-\")","v":7}]
[null,"Nombre d’UMOs dont le statut d’endémicité est inconnu",null,null,{"$f":"IF(E26=\"Yes\",E27-(992-COUNTIF(COUNTRY_INFO!H$9:H$1000,\"\"))+COUNTIF(COUNTRY_INFO!H$9:H$1000,\"=4\"),\"-\")","v":0},{"$f":"IF(F26=\"Yes\",F27-(992-COUNTIF(COUNTRY_INFO!I$9:I$1000,\"\"))+COUNTIF(COUNTRY_INFO!I$9:I$1000,\"=4\"),\"-\")","v":"-"},{"$f":"IF(G26=\"Yes\",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=\"Yes\",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,"Nombre d’UMOs non-endémiques",null,null,{"$f":"IF(E26=\"Yes\",COUNTIF(COUNTRY_INFO!H$9:H$1000,\"=0\"),\"-\")","v":0},{"$f":"IF(F26=\"Yes\",COUNTIF(COUNTRY_INFO!I$9:I$1000,\"=0\"),\"-\")","v":"-"},{"$f":"IF(G26=\"Yes\",COUNTIF(COUNTRY_INFO!J$9:J$1000,\"=0\"),\"-\")","v":0},{"$f":"IF(H26=\"Yes\",COUNTIF(COUNTRY_INFO!K$9:K$1000,\"=0\"),\"-\")","v":0}]
[null,"Nombre d’UMOs nécessitant une CP (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,"prevalence basse",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,"prevalence modérée",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,"prevalence haute",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,"Population nécessitant une CP dans le pays (total) ",null,null,{"$f":"COUNTRY_INFO!L4","v":201784},{"$f":"COUNTRY_INFO!M4","v":0},{"$f":"COUNTRY_INFO!N4","v":77687},{"$f":"COUNTRY_INFO!O4","v":38154.740000000005}]
[null,null,"EAPréS","prevalence modérée",null,null,{"$f":"SUMIF(COUNTRY_INFO!J$9:J$1000,\"=2\",COUNTRY_INFO!E$9:E$1000)","v":0}]
[null,null,null,"prevalence haute",null,null,{"$f":"SUMIF(COUNTRY_INFO!J$9:J$1000,\"=3\",COUNTRY_INFO!E$9:E$1000)","v":24819}]
[null,null,"EAS","prevalence basse",null,null,null,{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=1\",COUNTRY_INFO!F$9:F$1000)*0.33","v":6335.34}]
[null,null,null,"prevalence modérée",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":16835}]
[null,null,null,"prevalence haute",null,null,{"$f":"SUMIF(COUNTRY_INFO!J$9:J$1000,\"=3\",COUNTRY_INFO!F$9:F$1000)","v":52868},{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=3\",COUNTRY_INFO!F$9:F$1000)","v":0}]
[null,null,"Adults","prevalence modérée",null,null,null,{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=2\",COUNTRY_INFO!G$9:G$1000)*0.2","v":14984.400000000001}]
[null,null,null,"prevalence haute",null,null,null,{"$f":"SUMIF(COUNTRY_INFO!K$9:K$1000,\"=3\",COUNTRY_INFO!G$9:G$1000)","v":0}]
[null,"Nombre d’UMOs où une CP a été mise en oeuvre (total)",null,null,{"$f":"COUNTIF(DISTRICT!G$9:G$1000,\">0\")","v":7},{"$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":2}]
[null,"Nombre d’UMOs nécessitant une CP et  où elle a été mise en oeuvre",null,null,{"$f":"COUNTIF(DISTRICT!H$9:H$1000,\">0\")","v":7},{"$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":2}]
[null,null,"EAPréS",null,null,null,{"$f":"COUNTIF(DISTRICT!T$9:T$1000,\">0\")","v":7}]
[null,null,"EAS",null,null,null,{"$f":"COUNTIF(DISTRICT!V$9:V$1000,\">0\")","v":7},{"$f":"COUNTIF(DISTRICT!AD$9:AD$1000,\">0\")","v":2}]
[null,null,"Adults",null,null,null,null,{"$f":"COUNTIF(DISTRICT!AF$9:AF$1000,\">0\")","v":0}]
[null,"Nombre d’individus traités (total)",null,null,{"$f":"DISTRICT!G4","v":162512},{"$f":"DISTRICT!M4","v":0},{"$f":"DISTRICT!S4","v":162512},{"$f":"DISTRICT!AC4","v":22803}]
[null,null,"EAPréS",null,{"$f":"SUMMARY!$E17","v":16561},{"$f":"SUMMARY!$E18","v":"Non admissible"},{"$f":"SUMMARY!$E19","v":16561},{"$f":"SUMMARY!$E20","v":"Non ciblé"}]
[null,null,"EAS",null,{"$f":"SUMMARY!$F17","v":55654},{"$f":"SUMMARY!$F18","v":0},{"$f":"SUMMARY!$F19","v":55654},{"$f":"SUMMARY!$F20","v":22803}]
[null,null,"Adults",null,{"$f":"SUMMARY!$G17","v":90297},{"$f":"SUMMARY!$G18","v":0},{"$f":"SUMMARY!$G19","v":90297},{"$f":"SUMMARY!$G20","v":0}]
[null,"Nombre d’individus nécessitant CP et traités (total)",null,null,{"$f":"DISTRICT!H4","v":162512},{"$f":"DISTRICT!N4","v":0},{"$f":"DISTRICT!X4","v":68874},{"$f":"DISTRICT!AH4","v":16835}]
[null,null,"EAPréS",null,null,null,{"$f":"DISTRICT!T4","v":16561}]
[null,null,"EAS",null,null,null,{"$f":"DISTRICT!V4","v":52313},{"$f":"DISTRICT!AD4","v":16835}]
[null,null,"Adults",null,null,null,null,{"$f":"DISTRICT!AF4","v":0}]
[null,"Couverture géographique (tous âges)",null,null,{"$f":"IF(E31<>0,E44/E31,0)","v":1},{"$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":0.2857142857142857}]
[null,null,"EAPréS",null,null,null,{"$f":"IF(G31<>0,G45/G31,0)","v":1}]
[null,null,"EAS",null,null,null,{"$f":"IF(G31<>0,G46/G31,0)","v":1},{"$f":"IF(H31<>0,H46/H31,0)","v":0.2857142857142857}]
[null,null,"Adults",null,null,null,null,{"$f":"IF(SUM(H33:H34)<>0,H47/SUM(H33:H34),0)","v":0}]
[null,"Couverture nationale (total)",null,null,{"$f":"IF(E35<>0,E52/E35,0)","v":0.80537604567260035},{"$f":"IF(F35<>0,F52/F35,0)","v":0},{"$f":"IF(G35<>0,G52/G35,0)","v":0.8865575965090684},{"$f":"IF(H35<>0,H52/H35,0)","v":0.44122958248437805}]
[null,null,"EAPréS",null,null,null,{"$f":"IF(SUM(G36:G37)<>0,G53/SUM(G36:G37),0)","v":0.66727104234658929}]
[null,null,"EAS",null,null,null,{"$f":"IF(SUM(G39:G40)<>0,G54/SUM(G39:G40),0)","v":0.9895021563138382},{"$f":"IF(SUM(H38:H40)<>0,H54/SUM(H38:H40),0)","v":0.72657544084376835}]
[null,null,"Adults",null,null,null,null,{"$f":"IF(SUM(H41:H42)<>0,H55/SUM(H41:H42),0)","v":0}]
[null,null,null,null,"FL","ONCHO","STH","SCH"]
[]
[null,"Nombre d’UMOs ayant réalisé une couverture efficace (tous âges)",null,null,{"$f":"COUNTIF(DISTRICT!I$9:I$1000,\">=65\")","v":7},{"$f":"COUNTIF(DISTRICT!O$9:O$1000,\">=65\")","v":0},{"$f":"COUNTIF(DISTRICT!Y$9:Y$1000,\">=75\")","v":7},{"$f":"COUNTIF(DISTRICT!AI$9:AI$1000,\">=75\")","v":0}]
[null,null,"EAPréS",null,null,null,{"$f":"COUNTIF(DISTRICT!U$9:U$1000,\">=75\")","v":1}]
[null,null,"EAS",null,null,null,{"$f":"COUNTIF(DISTRICT!W$9:W$1000,\">=75\")","v":7},{"$f":"COUNTIF(DISTRICT!AE$9:AE$1000,\">=75\")","v":2}]
[null,null,"Adults",null,null,null,null,{"$f":"COUNTIF(DISTRICT!AG$9:AG$1000,\">=75\")","v":0}]
[null,"Nombre d’individus nécessitant un traitement dans des UMOs ayant réalisé une couverture efficace (total)",null,null,{"$f":"SUMIF(DISTRICT!I9:I1000,\">=65\",DISTRICT!H9:H1000)","v":162512},{"$f":"SUMIF(DISTRICT!O9:O1000,\">=65\",DISTRICT!N9:N1000)","v":0},{"$f":"SUMIF(DISTRICT!Y9:Y1000,\">=75\",DISTRICT!X9:X1000)","v":68874},{"$f":"SUMIF(DISTRICT!AI9:AI1000,\">=75\",DISTRICT!AH9:AH1000)","v":0}]
[null,null,"EAPréS",null,null,null,{"$f":"SUMIF(DISTRICT!U9:U1000,\">=75\",DISTRICT!T9:T1000)","v":810}]
[null,null,"EAS",null,null,null,{"$f":"SUMIF(DISTRICT!W9:W1000,\">=75\",DISTRICT!V9:V1000)","v":52313},{"$f":"SUMIF(DISTRICT!AE9:AE1000,\">=75\",DISTRICT!AD9:AD1000)","v":16835}]
[null,null,"Adults",null,null,null,null,{"$f":"SUMIF(DISTRICT!AG9:AG1000,\">=75\",DISTRICT!AF9:AF1000)","v":0}]
[null,"Proportion d’UMOs nécessitant une CP and ayant réalisé une couverture efficace (total)",null,null,{"$f":"IF(E44<>0,E66/E44,0)","v":1},{"$f":"IF(F44<>0,F66/F44,0)","v":0},{"$f":"IF(G44<>0,G66/G44,0)","v":1},{"$f":"IF(H44<>0,H66/H44,0)","v":0}]
[null,null,"EAPréS",null,null,null,{"$f":"IF(G45<>0,G67/G45,0)","v":0.14285714285714285}]
[null,null,"EAS",null,null,null,{"$f":"IF(G46<>0,G68/G46,0)","v":1},{"$f":"IF(H46<>0,H68/H46,0)","v":1}]
[null,null,"Adults",null,null,null,null,{"$f":"IF(H47<>0,H69/H47,0)","v":0}]
[null,"Nombre d’UMOs où la CP a été stoppée (càd sous surveillance)",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,"Nombre d’individus dans les UMOs ne nécessitant plus de CP (stoppée)",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,"Nombre d’individus nécessitant une CP vivants dans des UMOs ciblées pour la CP",null,null,{"$f":"SUMIF(DISTRICT!H$9:H$1000,\">0\",DISTRICT!D$9:D$1000)","v":201784},{"$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":77687},{"$f":"SUMIF(DISTRICT!AH$9:AH$1000,\">0\",DISTRICT!Z$9:Z$1000)","v":31819.399999999998}]
[null,"Nombre d’individus nécessitant une CP vivant dans des UMOs non ciblées pour la CP",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":0},{"$f":"SUMIF(DISTRICT!AH$9:AH$1000,\"=0\",DISTRICT!Z$9:Z$1000)","v":6335.34}]
[null,null,null,null,{"$f":"E35-E52","v":39272},{"$f":"F35-F52","v":0},8813,21319.740000000005]
[null,"Nombre d’UMOs nécessitant et recevant la CP",null,null,{"$f":"E31-E44","v":0},{"$f":"F31-F44","v":0},0,5]
[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,"Nécessitant et recevant une CP"]
[null,null,null,null,null,null,"Nécessitant mais ne recevant pas de CP"]
[null,null,null,null,null,null,"Ne nécessitant pas de CP"]
[null,null,null,null,null,null,"Statut inconnu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cliquer ici pour accéder au portail des données de la CP"]

{"sheet":"DATA_POLICY","index":12,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":true,"merged":[[55,1,55,2],[0,1,0,5],[1,1,1,7],[3,3,3,5],[6,1,6,7],[8,1,12,7],[13,1,16,7],[17,1,21,7],[22,1,25,7],[26,2,36,7],[38,1,45,7]]}
[]
[null,"Formulaire de Rapport Commun v.3.1"]
[]
[null,"Pays",null,{"$f":"IF(INTRO!$E$34<>0,INTRO!$E$34,\" \")","v":"STP"},null,null,"Année",{"$f":"IF(INTRO!$E$36<>0,INTRO!$E$36,\" \")","v":2018}]
[]
[]
[null,"Déclaration de principe sur la communication de données par l’OMS"]
[]
[null,"Les données sont le fondement de toutes les mesures rationnelles de santé publique et les avantages de la communication de données, y compris pour la science et la santé publique, sont largement reconnus. L’OMS souhaite promouvoir autant que possible la communication de données sanitaires, y compris, mais pas uniquement, de données épidémiologiques et de surveillance."]
[]
[]
[]
[]
[null,{"$f":"\"À cet égard, et sans préjudice des instruments juridiquement contraignants régissant la communication et la publication d’informations, le Ministère de la santé de \" & D4 & \", en fournissant des données à l’OMS :\"","v":"À cet égard, et sans préjudice des instruments juridiquement contraignants régissant la communication et la publication d’informations, le Ministère de la santé de STP, en fournissant des données à l’OMS :"}]
[]
[]
[]
[null,"confirme que toutes les données à fournir à l’OMS, ont été collectées conformément à la législation nationale applicable, y compris aux lois de protection des données visant à préserver l’anonymat des personnes identifiables ;"]
[]
[]
[]
[]
[null,{"$f":"\"convient que l’OMS aura le droit, toujours sous réserve des mesures visant à garantir l’utilisation éthique et sécurisée des données et toujours sous réserve d’une reconnaissance appropriée de la part de \"&D4&\":\"","v":"convient que l’OMS aura le droit, toujours sous réserve des mesures visant à garantir l’utilisation éthique et sécurisée des données et toujours sous réserve d’une reconnaissance appropriée de la part de STP:"}]
[]
[]
[]
[null,null,"de publier les données, dépourvues de tout élément d’identification personnelle (ci-après dénommées « les données ») et de les mettre à la disposition de toute partie intéressée, sur demande (dans la mesure où elles n’ont pas, ou pas encore, été publiées par l’OMS), selon des modalités autorisant leur utilisation non commerciale et sans but lucratif à des fins de santé publique (pour autant que l’OMS garde la maîtrise de la publication des données) ;\nd’utiliser, de compiler, d’agréger, d’évaluer et d’analyser les données et de publier et de diffuser les résultats obtenus grâce à ces données en rapport avec des travaux de l’OMS et conformément aux politiques et pratiques de l’Organisation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Sauf lorsque des instruments juridiquement contraignants (RSI, Règlement de Nomenclature de l’OMS, de 1967, etc.) disposent que les données doivent être communiquées et publiées, le Ministère de la santé de \", D4,\" peut, pour certaines données, décider de ne pas appliquer (tout ou partie des) (les) dispositions qui précèdent,\" & \" en informant l’OMS par écrit à l’adresse suivante, à condition que cette notification précise clairement les données, \" & \"dont il s’agit et indique clairement lesquelles des dispositions qui précèdent ne seront pas appliquées, et pour quels motifs.\")","v":"Sauf lorsque des instruments juridiquement contraignants (RSI, Règlement de Nomenclature de l’OMS, de 1967, etc.) disposent que les données doivent être communiquées et publiées, le Ministère de la santé de STP peut, pour certaines données, décider de ne pas appliquer (tout ou partie des) (les) dispositions qui précèdent, en informant l’OMS par écrit à l’adresse suivante, à condition que cette notification précise clairement les données, dont il s’agit et indique clairement lesquelles des dispositions qui précèdent ne seront pas appliquées, et pour quels motifs."}]