{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["INTRO","COUNTRY_INFO","DEC","ALB_MBD","PZQ","IVM","IVM+","SUMMARY","SHIPMENT","DATA_POLICY"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":10,"comments":9,"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":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,2,7,4],[11,1,11,4],[4,1,4,4],[10,2,10,4],[20,2,20,4],[17,1,17,4],[13,1,13,4],[18,2,18,4],[8,2,8,4],[9,2,9,4],[19,1,19,4],[12,1,12,4],[16,1,16,4],[14,1,14,4],[15,1,15,4],[0,1,0,4],[2,1,2,4],[1,1,1,4],[5,1,5,4],[3,1,3,4],[21,1,21,4],[46,1,46,4],[38,1,38,2],[40,1,40,2],[42,1,42,2],[44,1,44,2],[36,1,36,2],[22,2,23,4],[25,2,26,4],[27,1,27,4],[32,1,32,2],[29,1,29,4],[30,1,30,4],[28,2,28,4],[24,1,24,4],[34,1,34,2]]}
[]
[null,"Formulaire de demande commune de médicaments pour CP v.4.0"]
[]
[null,"Dans le cadre des efforts mondiaux entrepris pour accélérer l'expansion de la chimioprévention (CP) pour l'élimination de la filariose lymphatique et la lutte contre la schistosomiase et les géohelminthiases, l'Organisation mondiale de la Santé (OMS) facilite l'approvisionnement en albendazole, comprimés de 400 mg (GSK), pour les programmes nationaux d'élimination de la filariose lymphatique et programmes nationaux de lutte contre les géohelminthiases; en diethylcarbamazine, comprimés de 100 mg (Eisai), pour les programmes nationaux d'élimination de la filariose lymphatique; en mebendazole, comprimés de 500 mg (J&J) pour les programmes nationaux de lutte contre les géohelminthiases et en praziquantel, comprimés de 600 mg (Merck KGaA), destinés aux enfants d'âge scolaire, pour les programmes nationaux de lutte contre la schistosomiase. L'OMS contribue également à l'approvisionnement en ivermectine, comprimés de 3 mg (Merck), pour les programmes de donation pour l'onchocercose et la filariose lymphatique. \nCet outil Excel est concu pour aider les pays à quantifier le nombre de comprimés nécessaires, selon le traitement de chimioprévention requis, pour atteindre les objectifs de couverture de traitement de populations et districts pour l'année de la demande de médicaments. Le résultat de cet outil est une demande commune de médicaments pour la chimioprévention des maladies tropicales négligées, qui peut être imprimée, signée et soumise à l'OMS pour la demande de ces médicaments. "]
[]
[null,"Structure de l'application (feuilles de travail) :"]
[]
[null,"INTRO","Cette feuille contient des instructions pour compléter le formulaire de demande de médicaments pour la chimioprévention 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 et les interventions prévues."]
[null,"DEC, ALB_MBD, PZQ et IVM","Ces feuilles contiennent des informations sur l'endémicité des districts ciblés pour le traitement aux médicaments spécifiques à la chimioprévention, les plans de traitement, et le nombre de comprimés requis et demandés."]
[null,"SUMMARY","Cette feuille inclut un résumé du nombre de comprimés demandés, des informations concernant le stock et les dates de soumission de la demande de médicaments. Avant de générer le rapport (run macros), veuillez sélectionner le médicament pour lequel le rapport est nécessaire. Veuillez suivre la même règle pour voir le nombre de personnes à traiter pour les maladies spécifiques. \nCette feuille doit être imprimée et soumise en tant que \"Formulaire de demande commune de médicaments pour chimioprévention\" (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 : https://www.who.int/publications/i/item/9789241599993."]
[]
[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,"Guinée Équatoriale"]
[null,null,null,null,5]
[null,"Année de la demande de médicaments",null,null,2023]
[]
[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,"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,18]
[]
[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,8.2900000000000001E-2]
[null,"5-14 ans","Enfants d'âge scolaire (EAS)",null,0.24709999999999999]
[null,"15 ans et plus","Adultes",null,0.61229999999999996]
[null,"15-49 ans","Femmes en âge de procréer (FAP)",null,0.22589999999999999]

{"sheet":"COUNTRY_INFO","index":1,"n_rows":27,"n_cols":35,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,28,7,28],[6,29,7,29],[6,17,6,20],[6,25,7,25],[6,22,7,22],[6,23,7,23],[6,24,7,24],[6,26,7,26],[6,27,7,27],[6,3,7,3],[6,2,7,2],[6,1,7,1],[6,0,7,0],[6,21,7,21],[6,13,6,16],[6,11,7,11],[6,12,7,12],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,6,7,6],[6,5,7,5],[6,4,7,4],[3,0,3,2],[3,7,3,10],[3,21,3,24],[5,0,5,2],[3,26,3,29],[5,26,5,29],[5,3,5,6],[5,7,5,10],[5,11,5,20],[5,21,5,24]]}
["INFORMATIONS PAYS"]
["Struture administrative, population par groupe d'âge, statut d'endémicité et interventions planifiées"]
[]
["TOTAL",null,null,{"$f":"SUBTOTAL(9,D$10:D$1010)","v":1228703},{"$f":"SUBTOTAL(9,E$10:E$1010)","v":101860},303613,752335,null,null,null,null,{"$f":"SUBTOTAL(9,L$10:L$1010)","v":997269},0,101153,301505,275637,678295,25552,101550,251633,378735]
[]
["Structure administrative du pays",null,null,"Population",null,null,null,"Endémicité",null,null,null,"Population nécessitant la CP",null,null,null,null,null,null,null,null,null,"Nombre de tournées de traitement prévues pour l'année",null,null,null,"Criteria to apply for \nIVM+DEC+ALB therapy","Enquêtes épidémiologiques planifiées pour l’année"]
["Pays","Région/Département","District","Total","EAPréS","EAS","Adultes","FL","Oncho","STH","SCH","FL","ONCHO","STH",null,null,null,"SCH",null,null,null,"FL","Oncho","STH","SCH","FL","FL","Oncho","STH","SCH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"EAPréS","EAS","FAP","TOTAL","EAPréS","EAS","Adultes","TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,"IU_ID","IU_Name"]
[]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Annobon","Annonbon",8532,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D10*INTRO!$E$48,0))","v":707},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D10*INTRO!$E$49,0))","v":2108},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D10*INTRO!$E$50,0))","v":5224},4,4,4,4,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H10>0,IF($H10=4,\"Inconnu\",IF($H10=99,\"Interrompu\",$D10)),0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I10>0, IF($I10=4,\"Inconnu\",IF($I10=99,\"Interrompu\",$D10)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J10>1, IF($J10=4, \"Inconnu\", IF($J10=99, \"Surveillance\", E10)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J10>1, IF($J10=4, \"Inconnu\", IF($J10=99, \"Surveillance\", F10)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J10>1, IF($J10=4, \"Inconnu\", IF($J10=99, \"Surveillance\", ROUND(D10*INTRO!$E$51,0))), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J10>1, IF($J10=4, \"Inconnu\", IF($J10=99, \"Surveillance\", SUM($N10:$P10))), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K10>1, IF($K10=4, \"Inconnu\", IF($K10=99, \"Surveillance\", ROUND(E10*0.75,0))), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K10>1, IF($K10=4, \"Inconnu\", IF($K10=99, \"Surveillance\", F10)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K10>1, IF($K10=4, \"Inconnu\", IF($K10=99, \"Surveillance\", G10)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K10>1, IF($K10=4, \"Inconnu\", IF($K10=99, \"Surveillance\", SUM($R10:$T10))), 0),\"Non requis\")","v":"Inconnu"},0,0,0,0,null,null,null,null,null,null,null,null,16411,"Annonbon"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Bioko Norte","Baney",32364,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D11*INTRO!$E$48,0))","v":2683},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D11*INTRO!$E$49,0))","v":7997},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D11*INTRO!$E$50,0))","v":19816},1,99,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H11>0,IF($H11=4,\"Inconnu\",IF($H11=99,\"Interrompu\",$D11)),0),\"Non requis\")","v":32364},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I11>0, IF($I11=4,\"Inconnu\",IF($I11=99,\"Interrompu\",$D11)), 0),\"Non requis\")","v":"Interrompu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J11>1, IF($J11=4, \"Inconnu\", IF($J11=99, \"Surveillance\", E11)), 0),\"Non requis\")","v":2683},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J11>1, IF($J11=4, \"Inconnu\", IF($J11=99, \"Surveillance\", F11)), 0),\"Non requis\")","v":7997},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J11>1, IF($J11=4, \"Inconnu\", IF($J11=99, \"Surveillance\", ROUND(D11*INTRO!$E$51,0))), 0),\"Non requis\")","v":7311},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J11>1, IF($J11=4, \"Inconnu\", IF($J11=99, \"Surveillance\", SUM($N11:$P11))), 0),\"Non requis\")","v":17991},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K11>1, IF($K11=4, \"Inconnu\", IF($K11=99, \"Surveillance\", ROUND(E11*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K11>1, IF($K11=4, \"Inconnu\", IF($K11=99, \"Surveillance\", F11)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K11>1, IF($K11=4, \"Inconnu\", IF($K11=99, \"Surveillance\", G11)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K11>1, IF($K11=4, \"Inconnu\", IF($K11=99, \"Surveillance\", SUM($R11:$T11))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16412,"Baney"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Bioko Norte","Malabo",194944,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D12*INTRO!$E$48,0))","v":16161},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D12*INTRO!$E$49,0))","v":48171},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D12*INTRO!$E$50,0))","v":119364},0,99,3,2,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H12>0,IF($H12=4,\"Inconnu\",IF($H12=99,\"Interrompu\",$D12)),0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I12>0, IF($I12=4,\"Inconnu\",IF($I12=99,\"Interrompu\",$D12)), 0),\"Non requis\")","v":"Interrompu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J12>1, IF($J12=4, \"Inconnu\", IF($J12=99, \"Surveillance\", E12)), 0),\"Non requis\")","v":16161},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J12>1, IF($J12=4, \"Inconnu\", IF($J12=99, \"Surveillance\", F12)), 0),\"Non requis\")","v":48171},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J12>1, IF($J12=4, \"Inconnu\", IF($J12=99, \"Surveillance\", ROUND(D12*INTRO!$E$51,0))), 0),\"Non requis\")","v":44038},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J12>1, IF($J12=4, \"Inconnu\", IF($J12=99, \"Surveillance\", SUM($N12:$P12))), 0),\"Non requis\")","v":108370},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K12>1, IF($K12=4, \"Inconnu\", IF($K12=99, \"Surveillance\", ROUND(E12*0.75,0))), 0),\"Non requis\")","v":12121},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K12>1, IF($K12=4, \"Inconnu\", IF($K12=99, \"Surveillance\", F12)), 0),\"Non requis\")","v":48171},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K12>1, IF($K12=4, \"Inconnu\", IF($K12=99, \"Surveillance\", G12)), 0),\"Non requis\")","v":119364},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K12>1, IF($K12=4, \"Inconnu\", IF($K12=99, \"Surveillance\", SUM($R12:$T12))), 0),\"Non requis\")","v":179656},0,0,2,1,null,null,null,null,null,null,null,null,16413,"Malabo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Bioko Sur","Luba",27958,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D13*INTRO!$E$48,0))","v":2318},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D13*INTRO!$E$49,0))","v":6908},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D13*INTRO!$E$50,0))","v":17119},0,99,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H13>0,IF($H13=4,\"Inconnu\",IF($H13=99,\"Interrompu\",$D13)),0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I13>0, IF($I13=4,\"Inconnu\",IF($I13=99,\"Interrompu\",$D13)), 0),\"Non requis\")","v":"Interrompu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J13>1, IF($J13=4, \"Inconnu\", IF($J13=99, \"Surveillance\", E13)), 0),\"Non requis\")","v":2318},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J13>1, IF($J13=4, \"Inconnu\", IF($J13=99, \"Surveillance\", F13)), 0),\"Non requis\")","v":6908},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J13>1, IF($J13=4, \"Inconnu\", IF($J13=99, \"Surveillance\", ROUND(D13*INTRO!$E$51,0))), 0),\"Non requis\")","v":6316},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J13>1, IF($J13=4, \"Inconnu\", IF($J13=99, \"Surveillance\", SUM($N13:$P13))), 0),\"Non requis\")","v":15542},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K13>1, IF($K13=4, \"Inconnu\", IF($K13=99, \"Surveillance\", ROUND(E13*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K13>1, IF($K13=4, \"Inconnu\", IF($K13=99, \"Surveillance\", F13)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K13>1, IF($K13=4, \"Inconnu\", IF($K13=99, \"Surveillance\", G13)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K13>1, IF($K13=4, \"Inconnu\", IF($K13=99, \"Surveillance\", SUM($R13:$T13))), 0),\"Non requis\")","v":0},0,0,1,0,null,null,null,null,null,null,null,null,16414,"Luba"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Bioko Sur","Riaba",10065,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D14*INTRO!$E$48,0))","v":834},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D14*INTRO!$E$49,0))","v":2487},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D14*INTRO!$E$50,0))","v":6163},1,99,3,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H14>0,IF($H14=4,\"Inconnu\",IF($H14=99,\"Interrompu\",$D14)),0),\"Non requis\")","v":10065},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I14>0, IF($I14=4,\"Inconnu\",IF($I14=99,\"Interrompu\",$D14)), 0),\"Non requis\")","v":"Interrompu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J14>1, IF($J14=4, \"Inconnu\", IF($J14=99, \"Surveillance\", E14)), 0),\"Non requis\")","v":834},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J14>1, IF($J14=4, \"Inconnu\", IF($J14=99, \"Surveillance\", F14)), 0),\"Non requis\")","v":2487},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J14>1, IF($J14=4, \"Inconnu\", IF($J14=99, \"Surveillance\", ROUND(D14*INTRO!$E$51,0))), 0),\"Non requis\")","v":2274},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J14>1, IF($J14=4, \"Inconnu\", IF($J14=99, \"Surveillance\", SUM($N14:$P14))), 0),\"Non requis\")","v":5595},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K14>1, IF($K14=4, \"Inconnu\", IF($K14=99, \"Surveillance\", ROUND(E14*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K14>1, IF($K14=4, \"Inconnu\", IF($K14=99, \"Surveillance\", F14)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K14>1, IF($K14=4, \"Inconnu\", IF($K14=99, \"Surveillance\", G14)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K14>1, IF($K14=4, \"Inconnu\", IF($K14=99, \"Surveillance\", SUM($R14:$T14))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16415,"Riaba"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Centro Sur","Acurenam",35186,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D15*INTRO!$E$48,0))","v":2917},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D15*INTRO!$E$49,0))","v":8694},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D15*INTRO!$E$50,0))","v":21544},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H15>0,IF($H15=4,\"Inconnu\",IF($H15=99,\"Interrompu\",$D15)),0),\"Non requis\")","v":35186},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I15>0, IF($I15=4,\"Inconnu\",IF($I15=99,\"Interrompu\",$D15)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J15>1, IF($J15=4, \"Inconnu\", IF($J15=99, \"Surveillance\", E15)), 0),\"Non requis\")","v":2917},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J15>1, IF($J15=4, \"Inconnu\", IF($J15=99, \"Surveillance\", F15)), 0),\"Non requis\")","v":8694},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J15>1, IF($J15=4, \"Inconnu\", IF($J15=99, \"Surveillance\", ROUND(D15*INTRO!$E$51,0))), 0),\"Non requis\")","v":7949},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J15>1, IF($J15=4, \"Inconnu\", IF($J15=99, \"Surveillance\", SUM($N15:$P15))), 0),\"Non requis\")","v":19560},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K15>1, IF($K15=4, \"Inconnu\", IF($K15=99, \"Surveillance\", ROUND(E15*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K15>1, IF($K15=4, \"Inconnu\", IF($K15=99, \"Surveillance\", F15)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K15>1, IF($K15=4, \"Inconnu\", IF($K15=99, \"Surveillance\", G15)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K15>1, IF($K15=4, \"Inconnu\", IF($K15=99, \"Surveillance\", SUM($R15:$T15))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16416,"Acurenam"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Centro Sur","Evinayong",64599,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D16*INTRO!$E$48,0))","v":5355},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D16*INTRO!$E$49,0))","v":15962},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D16*INTRO!$E$50,0))","v":39554},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H16>0,IF($H16=4,\"Inconnu\",IF($H16=99,\"Interrompu\",$D16)),0),\"Non requis\")","v":64599},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I16>0, IF($I16=4,\"Inconnu\",IF($I16=99,\"Interrompu\",$D16)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J16>1, IF($J16=4, \"Inconnu\", IF($J16=99, \"Surveillance\", E16)), 0),\"Non requis\")","v":5355},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J16>1, IF($J16=4, \"Inconnu\", IF($J16=99, \"Surveillance\", F16)), 0),\"Non requis\")","v":15962},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J16>1, IF($J16=4, \"Inconnu\", IF($J16=99, \"Surveillance\", ROUND(D16*INTRO!$E$51,0))), 0),\"Non requis\")","v":14593},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J16>1, IF($J16=4, \"Inconnu\", IF($J16=99, \"Surveillance\", SUM($N16:$P16))), 0),\"Non requis\")","v":35910},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K16>1, IF($K16=4, \"Inconnu\", IF($K16=99, \"Surveillance\", ROUND(E16*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K16>1, IF($K16=4, \"Inconnu\", IF($K16=99, \"Surveillance\", F16)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K16>1, IF($K16=4, \"Inconnu\", IF($K16=99, \"Surveillance\", G16)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K16>1, IF($K16=4, \"Inconnu\", IF($K16=99, \"Surveillance\", SUM($R16:$T16))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16417,"Evinayong"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Centro Sur","Niefang",82760,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D17*INTRO!$E$48,0))","v":6861},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D17*INTRO!$E$49,0))","v":20450},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D17*INTRO!$E$50,0))","v":50674},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H17>0,IF($H17=4,\"Inconnu\",IF($H17=99,\"Interrompu\",$D17)),0),\"Non requis\")","v":82760},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I17>0, IF($I17=4,\"Inconnu\",IF($I17=99,\"Interrompu\",$D17)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J17>1, IF($J17=4, \"Inconnu\", IF($J17=99, \"Surveillance\", E17)), 0),\"Non requis\")","v":6861},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J17>1, IF($J17=4, \"Inconnu\", IF($J17=99, \"Surveillance\", F17)), 0),\"Non requis\")","v":20450},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J17>1, IF($J17=4, \"Inconnu\", IF($J17=99, \"Surveillance\", ROUND(D17*INTRO!$E$51,0))), 0),\"Non requis\")","v":18695},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J17>1, IF($J17=4, \"Inconnu\", IF($J17=99, \"Surveillance\", SUM($N17:$P17))), 0),\"Non requis\")","v":46006},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K17>1, IF($K17=4, \"Inconnu\", IF($K17=99, \"Surveillance\", ROUND(E17*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K17>1, IF($K17=4, \"Inconnu\", IF($K17=99, \"Surveillance\", F17)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K17>1, IF($K17=4, \"Inconnu\", IF($K17=99, \"Surveillance\", G17)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K17>1, IF($K17=4, \"Inconnu\", IF($K17=99, \"Surveillance\", SUM($R17:$T17))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16418,"Niefang"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Kientem","Ebebiyin",137821,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D18*INTRO!$E$48,0))","v":11425},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D18*INTRO!$E$49,0))","v":34056},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D18*INTRO!$E$50,0))","v":84388},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H18>0,IF($H18=4,\"Inconnu\",IF($H18=99,\"Interrompu\",$D18)),0),\"Non requis\")","v":137821},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I18>0, IF($I18=4,\"Inconnu\",IF($I18=99,\"Interrompu\",$D18)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J18>1, IF($J18=4, \"Inconnu\", IF($J18=99, \"Surveillance\", E18)), 0),\"Non requis\")","v":11425},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J18>1, IF($J18=4, \"Inconnu\", IF($J18=99, \"Surveillance\", F18)), 0),\"Non requis\")","v":34056},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J18>1, IF($J18=4, \"Inconnu\", IF($J18=99, \"Surveillance\", ROUND(D18*INTRO!$E$51,0))), 0),\"Non requis\")","v":31134},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J18>1, IF($J18=4, \"Inconnu\", IF($J18=99, \"Surveillance\", SUM($N18:$P18))), 0),\"Non requis\")","v":76615},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K18>1, IF($K18=4, \"Inconnu\", IF($K18=99, \"Surveillance\", ROUND(E18*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K18>1, IF($K18=4, \"Inconnu\", IF($K18=99, \"Surveillance\", F18)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K18>1, IF($K18=4, \"Inconnu\", IF($K18=99, \"Surveillance\", G18)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K18>1, IF($K18=4, \"Inconnu\", IF($K18=99, \"Surveillance\", SUM($R18:$T18))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16419,"Ebebiyin"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Kientem","Micomiseng",90615,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D19*INTRO!$E$48,0))","v":7512},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D19*INTRO!$E$49,0))","v":22391},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D19*INTRO!$E$50,0))","v":55484},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H19>0,IF($H19=4,\"Inconnu\",IF($H19=99,\"Interrompu\",$D19)),0),\"Non requis\")","v":90615},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I19>0, IF($I19=4,\"Inconnu\",IF($I19=99,\"Interrompu\",$D19)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J19>1, IF($J19=4, \"Inconnu\", IF($J19=99, \"Surveillance\", E19)), 0),\"Non requis\")","v":7512},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J19>1, IF($J19=4, \"Inconnu\", IF($J19=99, \"Surveillance\", F19)), 0),\"Non requis\")","v":22391},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J19>1, IF($J19=4, \"Inconnu\", IF($J19=99, \"Surveillance\", ROUND(D19*INTRO!$E$51,0))), 0),\"Non requis\")","v":20470},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J19>1, IF($J19=4, \"Inconnu\", IF($J19=99, \"Surveillance\", SUM($N19:$P19))), 0),\"Non requis\")","v":50373},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K19>1, IF($K19=4, \"Inconnu\", IF($K19=99, \"Surveillance\", ROUND(E19*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K19>1, IF($K19=4, \"Inconnu\", IF($K19=99, \"Surveillance\", F19)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K19>1, IF($K19=4, \"Inconnu\", IF($K19=99, \"Surveillance\", G19)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K19>1, IF($K19=4, \"Inconnu\", IF($K19=99, \"Surveillance\", SUM($R19:$T19))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16420,"Micomiseng"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Kientem","Nsoknsomo",52242,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D20*INTRO!$E$48,0))","v":4331},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D20*INTRO!$E$49,0))","v":12909},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D20*INTRO!$E$50,0))","v":31988},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H20>0,IF($H20=4,\"Inconnu\",IF($H20=99,\"Interrompu\",$D20)),0),\"Non requis\")","v":52242},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I20>0, IF($I20=4,\"Inconnu\",IF($I20=99,\"Interrompu\",$D20)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J20>1, IF($J20=4, \"Inconnu\", IF($J20=99, \"Surveillance\", E20)), 0),\"Non requis\")","v":4331},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J20>1, IF($J20=4, \"Inconnu\", IF($J20=99, \"Surveillance\", F20)), 0),\"Non requis\")","v":12909},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J20>1, IF($J20=4, \"Inconnu\", IF($J20=99, \"Surveillance\", ROUND(D20*INTRO!$E$51,0))), 0),\"Non requis\")","v":11801},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J20>1, IF($J20=4, \"Inconnu\", IF($J20=99, \"Surveillance\", SUM($N20:$P20))), 0),\"Non requis\")","v":29041},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K20>1, IF($K20=4, \"Inconnu\", IF($K20=99, \"Surveillance\", ROUND(E20*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K20>1, IF($K20=4, \"Inconnu\", IF($K20=99, \"Surveillance\", F20)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K20>1, IF($K20=4, \"Inconnu\", IF($K20=99, \"Surveillance\", G20)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K20>1, IF($K20=4, \"Inconnu\", IF($K20=99, \"Surveillance\", SUM($R20:$T20))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16421,"Nsoknsomo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Litoral","Bata",216020,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D21*INTRO!$E$48,0))","v":17908},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D21*INTRO!$E$49,0))","v":53379},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D21*INTRO!$E$50,0))","v":132269},1,4,3,2,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H21>0,IF($H21=4,\"Inconnu\",IF($H21=99,\"Interrompu\",$D21)),0),\"Non requis\")","v":216020},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I21>0, IF($I21=4,\"Inconnu\",IF($I21=99,\"Interrompu\",$D21)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J21>1, IF($J21=4, \"Inconnu\", IF($J21=99, \"Surveillance\", E21)), 0),\"Non requis\")","v":17908},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J21>1, IF($J21=4, \"Inconnu\", IF($J21=99, \"Surveillance\", F21)), 0),\"Non requis\")","v":53379},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J21>1, IF($J21=4, \"Inconnu\", IF($J21=99, \"Surveillance\", ROUND(D21*INTRO!$E$51,0))), 0),\"Non requis\")","v":48799},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J21>1, IF($J21=4, \"Inconnu\", IF($J21=99, \"Surveillance\", SUM($N21:$P21))), 0),\"Non requis\")","v":120086},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K21>1, IF($K21=4, \"Inconnu\", IF($K21=99, \"Surveillance\", ROUND(E21*0.75,0))), 0),\"Non requis\")","v":13431},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K21>1, IF($K21=4, \"Inconnu\", IF($K21=99, \"Surveillance\", F21)), 0),\"Non requis\")","v":53379},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K21>1, IF($K21=4, \"Inconnu\", IF($K21=99, \"Surveillance\", G21)), 0),\"Non requis\")","v":132269},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K21>1, IF($K21=4, \"Inconnu\", IF($K21=99, \"Surveillance\", SUM($R21:$T21))), 0),\"Non requis\")","v":199079},1,0,2,1,null,null,null,null,null,null,null,null,16422,"Bata"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Litoral","Kogo",44190,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D22*INTRO!$E$48,0))","v":3663},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D22*INTRO!$E$49,0))","v":10919},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D22*INTRO!$E$50,0))","v":27058},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H22>0,IF($H22=4,\"Inconnu\",IF($H22=99,\"Interrompu\",$D22)),0),\"Non requis\")","v":44190},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I22>0, IF($I22=4,\"Inconnu\",IF($I22=99,\"Interrompu\",$D22)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J22>1, IF($J22=4, \"Inconnu\", IF($J22=99, \"Surveillance\", E22)), 0),\"Non requis\")","v":3663},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J22>1, IF($J22=4, \"Inconnu\", IF($J22=99, \"Surveillance\", F22)), 0),\"Non requis\")","v":10919},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J22>1, IF($J22=4, \"Inconnu\", IF($J22=99, \"Surveillance\", ROUND(D22*INTRO!$E$51,0))), 0),\"Non requis\")","v":9983},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J22>1, IF($J22=4, \"Inconnu\", IF($J22=99, \"Surveillance\", SUM($N22:$P22))), 0),\"Non requis\")","v":24565},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K22>1, IF($K22=4, \"Inconnu\", IF($K22=99, \"Surveillance\", ROUND(E22*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K22>1, IF($K22=4, \"Inconnu\", IF($K22=99, \"Surveillance\", F22)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K22>1, IF($K22=4, \"Inconnu\", IF($K22=99, \"Surveillance\", G22)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K22>1, IF($K22=4, \"Inconnu\", IF($K22=99, \"Surveillance\", SUM($R22:$T22))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16423,"Kogo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Litoral","Mbini",42456,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D23*INTRO!$E$48,0))","v":3520},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D23*INTRO!$E$49,0))","v":10491},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D23*INTRO!$E$50,0))","v":25996},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H23>0,IF($H23=4,\"Inconnu\",IF($H23=99,\"Interrompu\",$D23)),0),\"Non requis\")","v":42456},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I23>0, IF($I23=4,\"Inconnu\",IF($I23=99,\"Interrompu\",$D23)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J23>1, IF($J23=4, \"Inconnu\", IF($J23=99, \"Surveillance\", E23)), 0),\"Non requis\")","v":3520},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J23>1, IF($J23=4, \"Inconnu\", IF($J23=99, \"Surveillance\", F23)), 0),\"Non requis\")","v":10491},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J23>1, IF($J23=4, \"Inconnu\", IF($J23=99, \"Surveillance\", ROUND(D23*INTRO!$E$51,0))), 0),\"Non requis\")","v":9591},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J23>1, IF($J23=4, \"Inconnu\", IF($J23=99, \"Surveillance\", SUM($N23:$P23))), 0),\"Non requis\")","v":23602},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K23>1, IF($K23=4, \"Inconnu\", IF($K23=99, \"Surveillance\", ROUND(E23*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K23>1, IF($K23=4, \"Inconnu\", IF($K23=99, \"Surveillance\", F23)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K23>1, IF($K23=4, \"Inconnu\", IF($K23=99, \"Surveillance\", G23)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K23>1, IF($K23=4, \"Inconnu\", IF($K23=99, \"Surveillance\", SUM($R23:$T23))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16424,"Mbini"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Welenzas","Akonibe",27425,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D24*INTRO!$E$48,0))","v":2274},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D24*INTRO!$E$49,0))","v":6777},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D24*INTRO!$E$50,0))","v":16792},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H24>0,IF($H24=4,\"Inconnu\",IF($H24=99,\"Interrompu\",$D24)),0),\"Non requis\")","v":27425},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I24>0, IF($I24=4,\"Inconnu\",IF($I24=99,\"Interrompu\",$D24)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J24>1, IF($J24=4, \"Inconnu\", IF($J24=99, \"Surveillance\", E24)), 0),\"Non requis\")","v":2274},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J24>1, IF($J24=4, \"Inconnu\", IF($J24=99, \"Surveillance\", F24)), 0),\"Non requis\")","v":6777},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J24>1, IF($J24=4, \"Inconnu\", IF($J24=99, \"Surveillance\", ROUND(D24*INTRO!$E$51,0))), 0),\"Non requis\")","v":6195},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J24>1, IF($J24=4, \"Inconnu\", IF($J24=99, \"Surveillance\", SUM($N24:$P24))), 0),\"Non requis\")","v":15246},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K24>1, IF($K24=4, \"Inconnu\", IF($K24=99, \"Surveillance\", ROUND(E24*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K24>1, IF($K24=4, \"Inconnu\", IF($K24=99, \"Surveillance\", F24)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K24>1, IF($K24=4, \"Inconnu\", IF($K24=99, \"Surveillance\", G24)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K24>1, IF($K24=4, \"Inconnu\", IF($K24=99, \"Surveillance\", SUM($R24:$T24))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16425,"Akonibe"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Welenzas","Anisok",68408,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D25*INTRO!$E$48,0))","v":5671},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D25*INTRO!$E$49,0))","v":16904},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D25*INTRO!$E$50,0))","v":41886},1,4,3,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H25>0,IF($H25=4,\"Inconnu\",IF($H25=99,\"Interrompu\",$D25)),0),\"Non requis\")","v":68408},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I25>0, IF($I25=4,\"Inconnu\",IF($I25=99,\"Interrompu\",$D25)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J25>1, IF($J25=4, \"Inconnu\", IF($J25=99, \"Surveillance\", E25)), 0),\"Non requis\")","v":5671},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J25>1, IF($J25=4, \"Inconnu\", IF($J25=99, \"Surveillance\", F25)), 0),\"Non requis\")","v":16904},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J25>1, IF($J25=4, \"Inconnu\", IF($J25=99, \"Surveillance\", ROUND(D25*INTRO!$E$51,0))), 0),\"Non requis\")","v":15453},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J25>1, IF($J25=4, \"Inconnu\", IF($J25=99, \"Surveillance\", SUM($N25:$P25))), 0),\"Non requis\")","v":38028},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K25>1, IF($K25=4, \"Inconnu\", IF($K25=99, \"Surveillance\", ROUND(E25*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K25>1, IF($K25=4, \"Inconnu\", IF($K25=99, \"Surveillance\", F25)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K25>1, IF($K25=4, \"Inconnu\", IF($K25=99, \"Surveillance\", G25)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K25>1, IF($K25=4, \"Inconnu\", IF($K25=99, \"Surveillance\", SUM($R25:$T25))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16426,"Anisok"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Welenzas","Mongomo",71868,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D26*INTRO!$E$48,0))","v":5958},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D26*INTRO!$E$49,0))","v":17759},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D26*INTRO!$E$50,0))","v":44005},1,4,3,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H26>0,IF($H26=4,\"Inconnu\",IF($H26=99,\"Interrompu\",$D26)),0),\"Non requis\")","v":71868},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I26>0, IF($I26=4,\"Inconnu\",IF($I26=99,\"Interrompu\",$D26)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J26>1, IF($J26=4, \"Inconnu\", IF($J26=99, \"Surveillance\", E26)), 0),\"Non requis\")","v":5958},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J26>1, IF($J26=4, \"Inconnu\", IF($J26=99, \"Surveillance\", F26)), 0),\"Non requis\")","v":17759},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J26>1, IF($J26=4, \"Inconnu\", IF($J26=99, \"Surveillance\", ROUND(D26*INTRO!$E$51,0))), 0),\"Non requis\")","v":16235},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J26>1, IF($J26=4, \"Inconnu\", IF($J26=99, \"Surveillance\", SUM($N26:$P26))), 0),\"Non requis\")","v":39952},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K26>1, IF($K26=4, \"Inconnu\", IF($K26=99, \"Surveillance\", ROUND(E26*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K26>1, IF($K26=4, \"Inconnu\", IF($K26=99, \"Surveillance\", F26)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K26>1, IF($K26=4, \"Inconnu\", IF($K26=99, \"Surveillance\", G26)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K26>1, IF($K26=4, \"Inconnu\", IF($K26=99, \"Surveillance\", SUM($R26:$T26))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16427,"Mongomo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Guinée Équatoriale"},"Welenzas","Nsork",21250,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D27*INTRO!$E$48,0))","v":1762},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D27*INTRO!$E$49,0))","v":5251},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D27*INTRO!$E$50,0))","v":13011},1,4,3,1,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H27>0,IF($H27=4,\"Inconnu\",IF($H27=99,\"Interrompu\",$D27)),0),\"Non requis\")","v":21250},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I27>0, IF($I27=4,\"Inconnu\",IF($I27=99,\"Interrompu\",$D27)), 0),\"Non requis\")","v":"Inconnu"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J27>1, IF($J27=4, \"Inconnu\", IF($J27=99, \"Surveillance\", E27)), 0),\"Non requis\")","v":1762},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J27>1, IF($J27=4, \"Inconnu\", IF($J27=99, \"Surveillance\", F27)), 0),\"Non requis\")","v":5251},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J27>1, IF($J27=4, \"Inconnu\", IF($J27=99, \"Surveillance\", ROUND(D27*INTRO!$E$51,0))), 0),\"Non requis\")","v":4800},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF($J27>1, IF($J27=4, \"Inconnu\", IF($J27=99, \"Surveillance\", SUM($N27:$P27))), 0),\"Non requis\")","v":11813},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K27>1, IF($K27=4, \"Inconnu\", IF($K27=99, \"Surveillance\", ROUND(E27*0.75,0))), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K27>1, IF($K27=4, \"Inconnu\", IF($K27=99, \"Surveillance\", F27)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K27>1, IF($K27=4, \"Inconnu\", IF($K27=99, \"Surveillance\", G27)), 0),\"Non requis\")","v":0},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF($K27>1, IF($K27=4, \"Inconnu\", IF($K27=99, \"Surveillance\", SUM($R27:$T27))), 0),\"Non requis\")","v":0},1,0,2,0,null,null,null,null,null,null,null,null,16428,"Nsork"]

{"sheet":"DEC","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[6,10,7,10],[6,0,7,0],[6,11,7,11],[5,3,5,6],[5,9,5,11],[6,4,7,4],[6,3,7,3],[6,8,7,8],[6,7,7,7],[6,6,7,6],[6,9,7,9],[3,0,3,2],[5,0,5,2],[6,5,7,5],[6,2,7,2],[6,1,7,1]]}
["Diethylcarbamazine (DEC)"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés"]
[]
["TOTAL",null,null,{"$f":"SUBTOTAL(9,D$10:D$1010)","v":0},0,0,0,null,{"$f":"SUBTOTAL(9,I$10:I$1010)","v":0},0,0,0]
[]
["Structure administrative du pays",null,null,"Population nécessitant un traitement avec DEC",null,null,null,"Plan de traitement","Population cible","Diethylcarbamazine (DEC)"]
["Pays","Région/Département","District","EAPréS","EAS","Adultes","Total","FL","FL","Total requis","Reste en stock","Comprimés devant être fournis"]
[]
[]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!E10,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!F10,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!G10,0)))","v":0},{"$f":"SUM(D10:F10)","v":0},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V10),\"Traiter avec IVM\")","v":"Traiter avec IVM"},{"$f":"IF(H10=1,G10,0)","v":0},{"$f":"IF(I10>0,I10*2.5,0)","v":0},null,{"$f":"IF($J10>$K10,$J10-$K10,0)","v":0}]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!E11,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!F11,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!G11,0)))","v":0},{"$f":"SUM(D11:F11)","v":0},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V11),\"Traiter avec IVM\")","v":"Traiter avec IVM"},{"$f":"IF(H11=1,G11,0)","v":0},{"$f":"IF(I11>0,I11*2.5,0)","v":0},null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!E12,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!F12,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!G12,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V12),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!E13,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!F13,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!G13,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V13),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!E14,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!F14,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!G14,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V14),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!E15,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!F15,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!G15,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V15),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!E16,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!F16,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!G16,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V16),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!E17,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!F17,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!G17,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V17),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!E18,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!F18,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!G18,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V18),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!E19,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!F19,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!G19,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V19),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!E20,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!F20,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!G20,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V20),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!E21,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!F21,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!G21,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V21),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!E22,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!F22,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!G22,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V22),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!E23,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!F23,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!G23,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V23),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!E24,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!F24,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!G24,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V24),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H25=1,COUNTRY_INFO!E25,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H25=1,COUNTRY_INFO!F25,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H25=1,COUNTRY_INFO!G25,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V25),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H26=1,COUNTRY_INFO!E26,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H26=1,COUNTRY_INFO!F26,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H26=1,COUNTRY_INFO!G26,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V26),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H27=1,COUNTRY_INFO!E27,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H27=1,COUNTRY_INFO!F27,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H27=1,COUNTRY_INFO!G27,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!V27),\"Traiter avec IVM\")","v":"Traiter avec IVM"},0,0,null,0]

{"sheet":"ALB_MBD","index":3,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,12,5,17],[6,20,7,20],[5,18,5,20],[6,18,7,18],[6,19,7,19],[6,16,7,16],[6,17,7,17],[6,15,7,15],[6,12,7,12],[6,13,7,13],[6,14,7,14],[3,0,3,2],[3,3,3,4],[5,0,5,2],[5,3,5,4],[5,5,7,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,9,6,10],[6,11,7,11],[0,6,0,10],[1,6,1,7],[1,9,1,10],[5,6,5,11],[6,6,6,7]]}
["Albendazole (ALB) et Mebendazole (MBD)",null,null,null,null,null,"Choisir le médicament pour le traitement de STH \npour chaque groupe d'âge"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés",null,null,null,null,null,"ALB",null,"ALB","ALB"]
[]
["TOTAL",null,null,null,null,{"$f":"SUBTOTAL(9,F$10:F$1010)","v":857054},null,{"$f":"SUBTOTAL(9,H$10:H$1010)","v":34640},103250,null,94392,232282,1714108,0,1714108,232282,0,232282,0,0,0]
[]
["Structure administrative du pays",null,null,"Plan de traitement",null,"Population couverte par le PEFL avec ALB","Population cible pour STH",null,null,null,null,null,"Albendazole (ALB)",null,null,null,null,null,"Mebendazole (MBD)"]
["Pays","Région/Département","District","FL","STH",null,"EAPréS",null,"EAS","FAP",null,"Total","Total requis (FL)","Reste en stock (FL)","Comprimés devant être fournis (FL)","Total requis (STH)","Reste en stock (STH)","Comprimés devant être fournis (STH)","Total requis","Reste en stock","Comprimés devant être fournis"]
[null,null,null,null,null,null,"Tournées","Personnes","Personnes","Tournées","Personnes"]
[]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"Annobon"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Annonbon"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!V10)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!X10)","v":0},0,null,{"$f":"IF(OR(COUNTRY_INFO!N10=\"Inconnu\",COUNTRY_INFO!N10=\"Surveillance\",COUNTRY_INFO!N10=\"Non requis\",COUNTRY_INFO!N10=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E10<>0,$G10=\"\"),IF($F10=0,COUNTRY_INFO!N10*$E10,COUNTRY_INFO!N10*($E10-$D10)),IF(AND($E10<>0,$G10<>0),IF($F10=0,COUNTRY_INFO!N10*$G10,COUNTRY_INFO!N10*($G10-$D10)),0)),IF($G10=\"\",COUNTRY_INFO!N10*$E10,COUNTRY_INFO!N10*$G10)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O10=\"Inconnu\",COUNTRY_INFO!O10=\"Surveillance\",COUNTRY_INFO!O10=\"Non requis\",COUNTRY_INFO!O10=0),0,IF($E10<>0, IF($F10=0,COUNTRY_INFO!O10*$E10,COUNTRY_INFO!O10*($E10-$D10)),COUNTRY_INFO!O10*$E10))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P10=\"Inconnu\",COUNTRY_INFO!P10=\"Surveillance\",COUNTRY_INFO!P10=\"Non requis\",COUNTRY_INFO!P10=0),0,IF(AND($E10<>0,$J10=\"\"),IF($F10=0,COUNTRY_INFO!P10*$E10,COUNTRY_INFO!P10*($E10-$D10)), IF(AND($E10<>0,$J10<>0),IF($F10=0,COUNTRY_INFO!P10*$J10,COUNTRY_INFO!P10*($J10-$D10)), COUNTRY_INFO!P10*$J10)))","v":0},{"$f":"ROUND($H10,0)+ROUND($I10,0)+ROUND($K10,0)","v":0},{"$f":"F10*D10","v":0},null,{"$f":"IF($M10>$N10, $M10-$N10,0)","v":0},{"$f":"ROUND((IF($G$2=\"ALB\",$H10,0)+IF($I$2=\"ALB\",$I10,0)+IF($J$2=\"ALB\",$K10,0)),0)","v":0},null,{"$f":"IF($P10>$Q10,$P10-$Q10,0)","v":0},{"$f":"ROUND((IF($G$2=\"MBD\",$H10,0)+IF($I$2=\"MBD\",$I10,0)+IF($J$2=\"MBD\",$K10,0)),0)","v":0},null,{"$f":"IF($S10>$T10,$S10-$T10,0)","v":0}]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"Bioko Norte"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Baney"},2,0,27813,null,{"$f":"IF(OR(COUNTRY_INFO!N11=\"Inconnu\",COUNTRY_INFO!N11=\"Surveillance\",COUNTRY_INFO!N11=\"Non requis\",COUNTRY_INFO!N11=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E11<>0,$G11=\"\"),IF($F11=0,COUNTRY_INFO!N11*$E11,COUNTRY_INFO!N11*($E11-$D11)),IF(AND($E11<>0,$G11<>0),IF($F11=0,COUNTRY_INFO!N11*$G11,COUNTRY_INFO!N11*($G11-$D11)),0)),IF($G11=\"\",COUNTRY_INFO!N11*$E11,COUNTRY_INFO!N11*$G11)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O11=\"Inconnu\",COUNTRY_INFO!O11=\"Surveillance\",COUNTRY_INFO!O11=\"Non requis\",COUNTRY_INFO!O11=0),0,IF($E11<>0, IF($F11=0,COUNTRY_INFO!O11*$E11,COUNTRY_INFO!O11*($E11-$D11)),COUNTRY_INFO!O11*$E11))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P11=\"Inconnu\",COUNTRY_INFO!P11=\"Surveillance\",COUNTRY_INFO!P11=\"Non requis\",COUNTRY_INFO!P11=0),0,IF(AND($E11<>0,$J11=\"\"),IF($F11=0,COUNTRY_INFO!P11*$E11,COUNTRY_INFO!P11*($E11-$D11)), IF(AND($E11<>0,$J11<>0),IF($F11=0,COUNTRY_INFO!P11*$J11,COUNTRY_INFO!P11*($J11-$D11)), COUNTRY_INFO!P11*$J11)))","v":0},0,55626,null,55626,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Bioko Norte"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"Malabo"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!V12)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!X12)","v":2},0,null,{"$f":"IF(OR(COUNTRY_INFO!N12=\"Inconnu\",COUNTRY_INFO!N12=\"Surveillance\",COUNTRY_INFO!N12=\"Non requis\",COUNTRY_INFO!N12=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E12<>0,$G12=\"\"),IF($F12=0,COUNTRY_INFO!N12*$E12,COUNTRY_INFO!N12*($E12-$D12)),IF(AND($E12<>0,$G12<>0),IF($F12=0,COUNTRY_INFO!N12*$G12,COUNTRY_INFO!N12*($G12-$D12)),0)),IF($G12=\"\",COUNTRY_INFO!N12*$E12,COUNTRY_INFO!N12*$G12)))","v":32322},{"$f":"IF(OR(COUNTRY_INFO!O12=\"Inconnu\",COUNTRY_INFO!O12=\"Surveillance\",COUNTRY_INFO!O12=\"Non requis\",COUNTRY_INFO!O12=0),0,IF($E12<>0, IF($F12=0,COUNTRY_INFO!O12*$E12,COUNTRY_INFO!O12*($E12-$D12)),COUNTRY_INFO!O12*$E12))","v":96342},null,{"$f":"IF(OR(COUNTRY_INFO!P12=\"Inconnu\",COUNTRY_INFO!P12=\"Surveillance\",COUNTRY_INFO!P12=\"Non requis\",COUNTRY_INFO!P12=0),0,IF(AND($E12<>0,$J12=\"\"),IF($F12=0,COUNTRY_INFO!P12*$E12,COUNTRY_INFO!P12*($E12-$D12)), IF(AND($E12<>0,$J12<>0),IF($F12=0,COUNTRY_INFO!P12*$J12,COUNTRY_INFO!P12*($J12-$D12)), COUNTRY_INFO!P12*$J12)))","v":88076},216740,0,null,0,216740,null,216740,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"Bioko Sur"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Luba"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!V13)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!X13)","v":1},0,null,{"$f":"IF(OR(COUNTRY_INFO!N13=\"Inconnu\",COUNTRY_INFO!N13=\"Surveillance\",COUNTRY_INFO!N13=\"Non requis\",COUNTRY_INFO!N13=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E13<>0,$G13=\"\"),IF($F13=0,COUNTRY_INFO!N13*$E13,COUNTRY_INFO!N13*($E13-$D13)),IF(AND($E13<>0,$G13<>0),IF($F13=0,COUNTRY_INFO!N13*$G13,COUNTRY_INFO!N13*($G13-$D13)),0)),IF($G13=\"\",COUNTRY_INFO!N13*$E13,COUNTRY_INFO!N13*$G13)))","v":2318},{"$f":"IF(OR(COUNTRY_INFO!O13=\"Inconnu\",COUNTRY_INFO!O13=\"Surveillance\",COUNTRY_INFO!O13=\"Non requis\",COUNTRY_INFO!O13=0),0,IF($E13<>0, IF($F13=0,COUNTRY_INFO!O13*$E13,COUNTRY_INFO!O13*($E13-$D13)),COUNTRY_INFO!O13*$E13))","v":6908},null,{"$f":"IF(OR(COUNTRY_INFO!P13=\"Inconnu\",COUNTRY_INFO!P13=\"Surveillance\",COUNTRY_INFO!P13=\"Non requis\",COUNTRY_INFO!P13=0),0,IF(AND($E13<>0,$J13=\"\"),IF($F13=0,COUNTRY_INFO!P13*$E13,COUNTRY_INFO!P13*($E13-$D13)), IF(AND($E13<>0,$J13<>0),IF($F13=0,COUNTRY_INFO!P13*$J13,COUNTRY_INFO!P13*($J13-$D13)), COUNTRY_INFO!P13*$J13)))","v":6316},15542,0,null,0,15542,null,15542,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"Bioko Sur"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Riaba"},2,0,8650,null,{"$f":"IF(OR(COUNTRY_INFO!N14=\"Inconnu\",COUNTRY_INFO!N14=\"Surveillance\",COUNTRY_INFO!N14=\"Non requis\",COUNTRY_INFO!N14=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E14<>0,$G14=\"\"),IF($F14=0,COUNTRY_INFO!N14*$E14,COUNTRY_INFO!N14*($E14-$D14)),IF(AND($E14<>0,$G14<>0),IF($F14=0,COUNTRY_INFO!N14*$G14,COUNTRY_INFO!N14*($G14-$D14)),0)),IF($G14=\"\",COUNTRY_INFO!N14*$E14,COUNTRY_INFO!N14*$G14)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O14=\"Inconnu\",COUNTRY_INFO!O14=\"Surveillance\",COUNTRY_INFO!O14=\"Non requis\",COUNTRY_INFO!O14=0),0,IF($E14<>0, IF($F14=0,COUNTRY_INFO!O14*$E14,COUNTRY_INFO!O14*($E14-$D14)),COUNTRY_INFO!O14*$E14))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P14=\"Inconnu\",COUNTRY_INFO!P14=\"Surveillance\",COUNTRY_INFO!P14=\"Non requis\",COUNTRY_INFO!P14=0),0,IF(AND($E14<>0,$J14=\"\"),IF($F14=0,COUNTRY_INFO!P14*$E14,COUNTRY_INFO!P14*($E14-$D14)), IF(AND($E14<>0,$J14<>0),IF($F14=0,COUNTRY_INFO!P14*$J14,COUNTRY_INFO!P14*($J14-$D14)), COUNTRY_INFO!P14*$J14)))","v":0},0,17300,null,17300,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"Centro Sur"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Acurenam"},2,0,30238,null,{"$f":"IF(OR(COUNTRY_INFO!N15=\"Inconnu\",COUNTRY_INFO!N15=\"Surveillance\",COUNTRY_INFO!N15=\"Non requis\",COUNTRY_INFO!N15=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E15<>0,$G15=\"\"),IF($F15=0,COUNTRY_INFO!N15*$E15,COUNTRY_INFO!N15*($E15-$D15)),IF(AND($E15<>0,$G15<>0),IF($F15=0,COUNTRY_INFO!N15*$G15,COUNTRY_INFO!N15*($G15-$D15)),0)),IF($G15=\"\",COUNTRY_INFO!N15*$E15,COUNTRY_INFO!N15*$G15)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O15=\"Inconnu\",COUNTRY_INFO!O15=\"Surveillance\",COUNTRY_INFO!O15=\"Non requis\",COUNTRY_INFO!O15=0),0,IF($E15<>0, IF($F15=0,COUNTRY_INFO!O15*$E15,COUNTRY_INFO!O15*($E15-$D15)),COUNTRY_INFO!O15*$E15))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P15=\"Inconnu\",COUNTRY_INFO!P15=\"Surveillance\",COUNTRY_INFO!P15=\"Non requis\",COUNTRY_INFO!P15=0),0,IF(AND($E15<>0,$J15=\"\"),IF($F15=0,COUNTRY_INFO!P15*$E15,COUNTRY_INFO!P15*($E15-$D15)), IF(AND($E15<>0,$J15<>0),IF($F15=0,COUNTRY_INFO!P15*$J15,COUNTRY_INFO!P15*($J15-$D15)), COUNTRY_INFO!P15*$J15)))","v":0},0,60476,null,60476,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"Centro Sur"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Evinayong"},2,0,55516,null,{"$f":"IF(OR(COUNTRY_INFO!N16=\"Inconnu\",COUNTRY_INFO!N16=\"Surveillance\",COUNTRY_INFO!N16=\"Non requis\",COUNTRY_INFO!N16=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E16<>0,$G16=\"\"),IF($F16=0,COUNTRY_INFO!N16*$E16,COUNTRY_INFO!N16*($E16-$D16)),IF(AND($E16<>0,$G16<>0),IF($F16=0,COUNTRY_INFO!N16*$G16,COUNTRY_INFO!N16*($G16-$D16)),0)),IF($G16=\"\",COUNTRY_INFO!N16*$E16,COUNTRY_INFO!N16*$G16)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O16=\"Inconnu\",COUNTRY_INFO!O16=\"Surveillance\",COUNTRY_INFO!O16=\"Non requis\",COUNTRY_INFO!O16=0),0,IF($E16<>0, IF($F16=0,COUNTRY_INFO!O16*$E16,COUNTRY_INFO!O16*($E16-$D16)),COUNTRY_INFO!O16*$E16))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P16=\"Inconnu\",COUNTRY_INFO!P16=\"Surveillance\",COUNTRY_INFO!P16=\"Non requis\",COUNTRY_INFO!P16=0),0,IF(AND($E16<>0,$J16=\"\"),IF($F16=0,COUNTRY_INFO!P16*$E16,COUNTRY_INFO!P16*($E16-$D16)), IF(AND($E16<>0,$J16<>0),IF($F16=0,COUNTRY_INFO!P16*$J16,COUNTRY_INFO!P16*($J16-$D16)), COUNTRY_INFO!P16*$J16)))","v":0},0,111032,null,111032,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"Centro Sur"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Niefang"},2,0,71124,null,{"$f":"IF(OR(COUNTRY_INFO!N17=\"Inconnu\",COUNTRY_INFO!N17=\"Surveillance\",COUNTRY_INFO!N17=\"Non requis\",COUNTRY_INFO!N17=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E17<>0,$G17=\"\"),IF($F17=0,COUNTRY_INFO!N17*$E17,COUNTRY_INFO!N17*($E17-$D17)),IF(AND($E17<>0,$G17<>0),IF($F17=0,COUNTRY_INFO!N17*$G17,COUNTRY_INFO!N17*($G17-$D17)),0)),IF($G17=\"\",COUNTRY_INFO!N17*$E17,COUNTRY_INFO!N17*$G17)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O17=\"Inconnu\",COUNTRY_INFO!O17=\"Surveillance\",COUNTRY_INFO!O17=\"Non requis\",COUNTRY_INFO!O17=0),0,IF($E17<>0, IF($F17=0,COUNTRY_INFO!O17*$E17,COUNTRY_INFO!O17*($E17-$D17)),COUNTRY_INFO!O17*$E17))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P17=\"Inconnu\",COUNTRY_INFO!P17=\"Surveillance\",COUNTRY_INFO!P17=\"Non requis\",COUNTRY_INFO!P17=0),0,IF(AND($E17<>0,$J17=\"\"),IF($F17=0,COUNTRY_INFO!P17*$E17,COUNTRY_INFO!P17*($E17-$D17)), IF(AND($E17<>0,$J17<>0),IF($F17=0,COUNTRY_INFO!P17*$J17,COUNTRY_INFO!P17*($J17-$D17)), COUNTRY_INFO!P17*$J17)))","v":0},0,142248,null,142248,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"Kientem"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Ebebiyin"},2,0,118444,null,{"$f":"IF(OR(COUNTRY_INFO!N18=\"Inconnu\",COUNTRY_INFO!N18=\"Surveillance\",COUNTRY_INFO!N18=\"Non requis\",COUNTRY_INFO!N18=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E18<>0,$G18=\"\"),IF($F18=0,COUNTRY_INFO!N18*$E18,COUNTRY_INFO!N18*($E18-$D18)),IF(AND($E18<>0,$G18<>0),IF($F18=0,COUNTRY_INFO!N18*$G18,COUNTRY_INFO!N18*($G18-$D18)),0)),IF($G18=\"\",COUNTRY_INFO!N18*$E18,COUNTRY_INFO!N18*$G18)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O18=\"Inconnu\",COUNTRY_INFO!O18=\"Surveillance\",COUNTRY_INFO!O18=\"Non requis\",COUNTRY_INFO!O18=0),0,IF($E18<>0, IF($F18=0,COUNTRY_INFO!O18*$E18,COUNTRY_INFO!O18*($E18-$D18)),COUNTRY_INFO!O18*$E18))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P18=\"Inconnu\",COUNTRY_INFO!P18=\"Surveillance\",COUNTRY_INFO!P18=\"Non requis\",COUNTRY_INFO!P18=0),0,IF(AND($E18<>0,$J18=\"\"),IF($F18=0,COUNTRY_INFO!P18*$E18,COUNTRY_INFO!P18*($E18-$D18)), IF(AND($E18<>0,$J18<>0),IF($F18=0,COUNTRY_INFO!P18*$J18,COUNTRY_INFO!P18*($J18-$D18)), COUNTRY_INFO!P18*$J18)))","v":0},0,236888,null,236888,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"Kientem"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Micomiseng"},2,0,77875,null,{"$f":"IF(OR(COUNTRY_INFO!N19=\"Inconnu\",COUNTRY_INFO!N19=\"Surveillance\",COUNTRY_INFO!N19=\"Non requis\",COUNTRY_INFO!N19=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E19<>0,$G19=\"\"),IF($F19=0,COUNTRY_INFO!N19*$E19,COUNTRY_INFO!N19*($E19-$D19)),IF(AND($E19<>0,$G19<>0),IF($F19=0,COUNTRY_INFO!N19*$G19,COUNTRY_INFO!N19*($G19-$D19)),0)),IF($G19=\"\",COUNTRY_INFO!N19*$E19,COUNTRY_INFO!N19*$G19)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O19=\"Inconnu\",COUNTRY_INFO!O19=\"Surveillance\",COUNTRY_INFO!O19=\"Non requis\",COUNTRY_INFO!O19=0),0,IF($E19<>0, IF($F19=0,COUNTRY_INFO!O19*$E19,COUNTRY_INFO!O19*($E19-$D19)),COUNTRY_INFO!O19*$E19))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P19=\"Inconnu\",COUNTRY_INFO!P19=\"Surveillance\",COUNTRY_INFO!P19=\"Non requis\",COUNTRY_INFO!P19=0),0,IF(AND($E19<>0,$J19=\"\"),IF($F19=0,COUNTRY_INFO!P19*$E19,COUNTRY_INFO!P19*($E19-$D19)), IF(AND($E19<>0,$J19<>0),IF($F19=0,COUNTRY_INFO!P19*$J19,COUNTRY_INFO!P19*($J19-$D19)), COUNTRY_INFO!P19*$J19)))","v":0},0,155750,null,155750,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Kientem"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Nsoknsomo"},2,0,44897,null,{"$f":"IF(OR(COUNTRY_INFO!N20=\"Inconnu\",COUNTRY_INFO!N20=\"Surveillance\",COUNTRY_INFO!N20=\"Non requis\",COUNTRY_INFO!N20=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E20<>0,$G20=\"\"),IF($F20=0,COUNTRY_INFO!N20*$E20,COUNTRY_INFO!N20*($E20-$D20)),IF(AND($E20<>0,$G20<>0),IF($F20=0,COUNTRY_INFO!N20*$G20,COUNTRY_INFO!N20*($G20-$D20)),0)),IF($G20=\"\",COUNTRY_INFO!N20*$E20,COUNTRY_INFO!N20*$G20)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O20=\"Inconnu\",COUNTRY_INFO!O20=\"Surveillance\",COUNTRY_INFO!O20=\"Non requis\",COUNTRY_INFO!O20=0),0,IF($E20<>0, IF($F20=0,COUNTRY_INFO!O20*$E20,COUNTRY_INFO!O20*($E20-$D20)),COUNTRY_INFO!O20*$E20))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P20=\"Inconnu\",COUNTRY_INFO!P20=\"Surveillance\",COUNTRY_INFO!P20=\"Non requis\",COUNTRY_INFO!P20=0),0,IF(AND($E20<>0,$J20=\"\"),IF($F20=0,COUNTRY_INFO!P20*$E20,COUNTRY_INFO!P20*($E20-$D20)), IF(AND($E20<>0,$J20<>0),IF($F20=0,COUNTRY_INFO!P20*$J20,COUNTRY_INFO!P20*($J20-$D20)), COUNTRY_INFO!P20*$J20)))","v":0},0,89794,null,89794,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"Litoral"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Bata"},2,0,185648,null,{"$f":"IF(OR(COUNTRY_INFO!N21=\"Inconnu\",COUNTRY_INFO!N21=\"Surveillance\",COUNTRY_INFO!N21=\"Non requis\",COUNTRY_INFO!N21=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E21<>0,$G21=\"\"),IF($F21=0,COUNTRY_INFO!N21*$E21,COUNTRY_INFO!N21*($E21-$D21)),IF(AND($E21<>0,$G21<>0),IF($F21=0,COUNTRY_INFO!N21*$G21,COUNTRY_INFO!N21*($G21-$D21)),0)),IF($G21=\"\",COUNTRY_INFO!N21*$E21,COUNTRY_INFO!N21*$G21)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O21=\"Inconnu\",COUNTRY_INFO!O21=\"Surveillance\",COUNTRY_INFO!O21=\"Non requis\",COUNTRY_INFO!O21=0),0,IF($E21<>0, IF($F21=0,COUNTRY_INFO!O21*$E21,COUNTRY_INFO!O21*($E21-$D21)),COUNTRY_INFO!O21*$E21))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P21=\"Inconnu\",COUNTRY_INFO!P21=\"Surveillance\",COUNTRY_INFO!P21=\"Non requis\",COUNTRY_INFO!P21=0),0,IF(AND($E21<>0,$J21=\"\"),IF($F21=0,COUNTRY_INFO!P21*$E21,COUNTRY_INFO!P21*($E21-$D21)), IF(AND($E21<>0,$J21<>0),IF($F21=0,COUNTRY_INFO!P21*$J21,COUNTRY_INFO!P21*($J21-$D21)), COUNTRY_INFO!P21*$J21)))","v":0},0,371296,null,371296,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"Litoral"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"Kogo"},2,0,37977,null,{"$f":"IF(OR(COUNTRY_INFO!N22=\"Inconnu\",COUNTRY_INFO!N22=\"Surveillance\",COUNTRY_INFO!N22=\"Non requis\",COUNTRY_INFO!N22=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E22<>0,$G22=\"\"),IF($F22=0,COUNTRY_INFO!N22*$E22,COUNTRY_INFO!N22*($E22-$D22)),IF(AND($E22<>0,$G22<>0),IF($F22=0,COUNTRY_INFO!N22*$G22,COUNTRY_INFO!N22*($G22-$D22)),0)),IF($G22=\"\",COUNTRY_INFO!N22*$E22,COUNTRY_INFO!N22*$G22)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O22=\"Inconnu\",COUNTRY_INFO!O22=\"Surveillance\",COUNTRY_INFO!O22=\"Non requis\",COUNTRY_INFO!O22=0),0,IF($E22<>0, IF($F22=0,COUNTRY_INFO!O22*$E22,COUNTRY_INFO!O22*($E22-$D22)),COUNTRY_INFO!O22*$E22))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P22=\"Inconnu\",COUNTRY_INFO!P22=\"Surveillance\",COUNTRY_INFO!P22=\"Non requis\",COUNTRY_INFO!P22=0),0,IF(AND($E22<>0,$J22=\"\"),IF($F22=0,COUNTRY_INFO!P22*$E22,COUNTRY_INFO!P22*($E22-$D22)), IF(AND($E22<>0,$J22<>0),IF($F22=0,COUNTRY_INFO!P22*$J22,COUNTRY_INFO!P22*($J22-$D22)), COUNTRY_INFO!P22*$J22)))","v":0},0,75954,null,75954,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"Litoral"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Mbini"},2,0,36487,null,{"$f":"IF(OR(COUNTRY_INFO!N23=\"Inconnu\",COUNTRY_INFO!N23=\"Surveillance\",COUNTRY_INFO!N23=\"Non requis\",COUNTRY_INFO!N23=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E23<>0,$G23=\"\"),IF($F23=0,COUNTRY_INFO!N23*$E23,COUNTRY_INFO!N23*($E23-$D23)),IF(AND($E23<>0,$G23<>0),IF($F23=0,COUNTRY_INFO!N23*$G23,COUNTRY_INFO!N23*($G23-$D23)),0)),IF($G23=\"\",COUNTRY_INFO!N23*$E23,COUNTRY_INFO!N23*$G23)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O23=\"Inconnu\",COUNTRY_INFO!O23=\"Surveillance\",COUNTRY_INFO!O23=\"Non requis\",COUNTRY_INFO!O23=0),0,IF($E23<>0, IF($F23=0,COUNTRY_INFO!O23*$E23,COUNTRY_INFO!O23*($E23-$D23)),COUNTRY_INFO!O23*$E23))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P23=\"Inconnu\",COUNTRY_INFO!P23=\"Surveillance\",COUNTRY_INFO!P23=\"Non requis\",COUNTRY_INFO!P23=0),0,IF(AND($E23<>0,$J23=\"\"),IF($F23=0,COUNTRY_INFO!P23*$E23,COUNTRY_INFO!P23*($E23-$D23)), IF(AND($E23<>0,$J23<>0),IF($F23=0,COUNTRY_INFO!P23*$J23,COUNTRY_INFO!P23*($J23-$D23)), COUNTRY_INFO!P23*$J23)))","v":0},0,72974,null,72974,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"Welenzas"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"Akonibe"},2,0,23569,null,{"$f":"IF(OR(COUNTRY_INFO!N24=\"Inconnu\",COUNTRY_INFO!N24=\"Surveillance\",COUNTRY_INFO!N24=\"Non requis\",COUNTRY_INFO!N24=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E24<>0,$G24=\"\"),IF($F24=0,COUNTRY_INFO!N24*$E24,COUNTRY_INFO!N24*($E24-$D24)),IF(AND($E24<>0,$G24<>0),IF($F24=0,COUNTRY_INFO!N24*$G24,COUNTRY_INFO!N24*($G24-$D24)),0)),IF($G24=\"\",COUNTRY_INFO!N24*$E24,COUNTRY_INFO!N24*$G24)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O24=\"Inconnu\",COUNTRY_INFO!O24=\"Surveillance\",COUNTRY_INFO!O24=\"Non requis\",COUNTRY_INFO!O24=0),0,IF($E24<>0, IF($F24=0,COUNTRY_INFO!O24*$E24,COUNTRY_INFO!O24*($E24-$D24)),COUNTRY_INFO!O24*$E24))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P24=\"Inconnu\",COUNTRY_INFO!P24=\"Surveillance\",COUNTRY_INFO!P24=\"Non requis\",COUNTRY_INFO!P24=0),0,IF(AND($E24<>0,$J24=\"\"),IF($F24=0,COUNTRY_INFO!P24*$E24,COUNTRY_INFO!P24*($E24-$D24)), IF(AND($E24<>0,$J24<>0),IF($F24=0,COUNTRY_INFO!P24*$J24,COUNTRY_INFO!P24*($J24-$D24)), COUNTRY_INFO!P24*$J24)))","v":0},0,47138,null,47138,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":"Welenzas"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":"Anisok"},2,0,58790,null,{"$f":"IF(OR(COUNTRY_INFO!N25=\"Inconnu\",COUNTRY_INFO!N25=\"Surveillance\",COUNTRY_INFO!N25=\"Non requis\",COUNTRY_INFO!N25=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E25<>0,$G25=\"\"),IF($F25=0,COUNTRY_INFO!N25*$E25,COUNTRY_INFO!N25*($E25-$D25)),IF(AND($E25<>0,$G25<>0),IF($F25=0,COUNTRY_INFO!N25*$G25,COUNTRY_INFO!N25*($G25-$D25)),0)),IF($G25=\"\",COUNTRY_INFO!N25*$E25,COUNTRY_INFO!N25*$G25)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O25=\"Inconnu\",COUNTRY_INFO!O25=\"Surveillance\",COUNTRY_INFO!O25=\"Non requis\",COUNTRY_INFO!O25=0),0,IF($E25<>0, IF($F25=0,COUNTRY_INFO!O25*$E25,COUNTRY_INFO!O25*($E25-$D25)),COUNTRY_INFO!O25*$E25))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P25=\"Inconnu\",COUNTRY_INFO!P25=\"Surveillance\",COUNTRY_INFO!P25=\"Non requis\",COUNTRY_INFO!P25=0),0,IF(AND($E25<>0,$J25=\"\"),IF($F25=0,COUNTRY_INFO!P25*$E25,COUNTRY_INFO!P25*($E25-$D25)), IF(AND($E25<>0,$J25<>0),IF($F25=0,COUNTRY_INFO!P25*$J25,COUNTRY_INFO!P25*($J25-$D25)), COUNTRY_INFO!P25*$J25)))","v":0},0,117580,null,117580,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":"Welenzas"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":"Mongomo"},2,0,61764,null,{"$f":"IF(OR(COUNTRY_INFO!N26=\"Inconnu\",COUNTRY_INFO!N26=\"Surveillance\",COUNTRY_INFO!N26=\"Non requis\",COUNTRY_INFO!N26=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E26<>0,$G26=\"\"),IF($F26=0,COUNTRY_INFO!N26*$E26,COUNTRY_INFO!N26*($E26-$D26)),IF(AND($E26<>0,$G26<>0),IF($F26=0,COUNTRY_INFO!N26*$G26,COUNTRY_INFO!N26*($G26-$D26)),0)),IF($G26=\"\",COUNTRY_INFO!N26*$E26,COUNTRY_INFO!N26*$G26)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O26=\"Inconnu\",COUNTRY_INFO!O26=\"Surveillance\",COUNTRY_INFO!O26=\"Non requis\",COUNTRY_INFO!O26=0),0,IF($E26<>0, IF($F26=0,COUNTRY_INFO!O26*$E26,COUNTRY_INFO!O26*($E26-$D26)),COUNTRY_INFO!O26*$E26))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P26=\"Inconnu\",COUNTRY_INFO!P26=\"Surveillance\",COUNTRY_INFO!P26=\"Non requis\",COUNTRY_INFO!P26=0),0,IF(AND($E26<>0,$J26=\"\"),IF($F26=0,COUNTRY_INFO!P26*$E26,COUNTRY_INFO!P26*($E26-$D26)), IF(AND($E26<>0,$J26<>0),IF($F26=0,COUNTRY_INFO!P26*$J26,COUNTRY_INFO!P26*($J26-$D26)), COUNTRY_INFO!P26*$J26)))","v":0},0,123528,null,123528,0,null,0,0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":"Guinée Équatoriale"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":"Welenzas"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":"Nsork"},2,0,18262,null,{"$f":"IF(OR(COUNTRY_INFO!N27=\"Inconnu\",COUNTRY_INFO!N27=\"Surveillance\",COUNTRY_INFO!N27=\"Non requis\",COUNTRY_INFO!N27=0),0,IF(INTRO!$E$39=\"Non endémique\",IF(AND($E27<>0,$G27=\"\"),IF($F27=0,COUNTRY_INFO!N27*$E27,COUNTRY_INFO!N27*($E27-$D27)),IF(AND($E27<>0,$G27<>0),IF($F27=0,COUNTRY_INFO!N27*$G27,COUNTRY_INFO!N27*($G27-$D27)),0)),IF($G27=\"\",COUNTRY_INFO!N27*$E27,COUNTRY_INFO!N27*$G27)))","v":0},{"$f":"IF(OR(COUNTRY_INFO!O27=\"Inconnu\",COUNTRY_INFO!O27=\"Surveillance\",COUNTRY_INFO!O27=\"Non requis\",COUNTRY_INFO!O27=0),0,IF($E27<>0, IF($F27=0,COUNTRY_INFO!O27*$E27,COUNTRY_INFO!O27*($E27-$D27)),COUNTRY_INFO!O27*$E27))","v":0},null,{"$f":"IF(OR(COUNTRY_INFO!P27=\"Inconnu\",COUNTRY_INFO!P27=\"Surveillance\",COUNTRY_INFO!P27=\"Non requis\",COUNTRY_INFO!P27=0),0,IF(AND($E27<>0,$J27=\"\"),IF($F27=0,COUNTRY_INFO!P27*$E27,COUNTRY_INFO!P27*($E27-$D27)), IF(AND($E27<>0,$J27<>0),IF($F27=0,COUNTRY_INFO!P27*$J27,COUNTRY_INFO!P27*($J27-$D27)), COUNTRY_INFO!P27*$J27)))","v":0},0,36524,null,36524,0,null,0,0,null,0]

{"sheet":"PZQ","index":4,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,12,5,17],[5,10,5,11],[6,10,7,10],[6,14,7,14],[6,15,7,15],[6,16,7,16],[6,13,7,13],[6,11,7,11],[3,0,3,2],[5,0,5,2],[5,4,5,7],[5,8,5,9],[6,17,7,17],[6,6,7,6],[6,7,7,7],[6,9,7,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,4,7,4],[5,3,7,3],[6,5,7,5],[6,8,7,8],[6,12,7,12]]}
["Praziquantel (PZQ)"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés"]
[]
["TOTAL",null,null,null,{"$f":"SUBTOTAL(9,E$10:E$1010)","v":25552},101550,251633,378735,null,0,null,null,{"$f":"SUBTOTAL(9,M$10:M$1010)","v":0},253875,754899,1008774,0,1008774]
[]
["Structure administrative du pays",null,null,"Plan de traitement\nSCH","Population cible pour SCH",null,null,null,"Hotspots",null,"Année précédent l’AMM",null,"Praziquantel (PZQ)"]
["Pays","Région/Département","District",null,"EAPréS","EAS","Adultes","Total","Prévue","Population","Tournées","Groupes d'âge","EAPréS","EAS","Adultes","Total requis","Reste en stock","Comprimés devant être fournis"]
[]
[]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"Annobon"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Annonbon"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y10)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R10=\"Inconnu\",COUNTRY_INFO!R10=\"Surveillance\",COUNTRY_INFO!R10=\"Non requis\",COUNTRY_INFO!R10=0),0,IF($D10<>0, COUNTRY_INFO!R10,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S10=\"Inconnu\",COUNTRY_INFO!S10=\"Surveillance\",COUNTRY_INFO!S10=\"Non requis\",COUNTRY_INFO!S10=0),0,IF($D10<>0, COUNTRY_INFO!S10,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T10=\"Inconnu\",COUNTRY_INFO!T10=\"Surveillance\",COUNTRY_INFO!T10=\"Non requis\",COUNTRY_INFO!T10=0),0,IF($D10<>0, COUNTRY_INFO!T10,0))","v":0},{"$f":"SUM(E10:G10)","v":0},null,null,null,null,null,{"$f":"IF($I10<>\"Oui\",$F10*2.5,($F10+ROUND(J10*$F10/SUM(COUNTRY_INFO!$E10:$G10),0))*2.5)","v":0},{"$f":"IF($I10<>\"Oui\",$G10*3,($G10+ROUND(J10*$G10/SUM(COUNTRY_INFO!$E10:$G10),0))*3)","v":0},{"$f":"SUM(M10:O10)","v":0},null,{"$f":"IF($P10>$Q10,P10-Q10,0)","v":0}]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"Bioko Norte"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Baney"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y11)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R11=\"Inconnu\",COUNTRY_INFO!R11=\"Surveillance\",COUNTRY_INFO!R11=\"Non requis\",COUNTRY_INFO!R11=0),0,IF($D11<>0, COUNTRY_INFO!R11,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S11=\"Inconnu\",COUNTRY_INFO!S11=\"Surveillance\",COUNTRY_INFO!S11=\"Non requis\",COUNTRY_INFO!S11=0),0,IF($D11<>0, COUNTRY_INFO!S11,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T11=\"Inconnu\",COUNTRY_INFO!T11=\"Surveillance\",COUNTRY_INFO!T11=\"Non requis\",COUNTRY_INFO!T11=0),0,IF($D11<>0, COUNTRY_INFO!T11,0))","v":0},{"$f":"SUM(E11:G11)","v":0},null,null,null,null,null,{"$f":"IF($I11<>\"Oui\",$F11*2.5,($F11+ROUND(J11*$F11/SUM(COUNTRY_INFO!$E11:$G11),0))*2.5)","v":0},{"$f":"IF($I11<>\"Oui\",$G11*3,($G11+ROUND(J11*$G11/SUM(COUNTRY_INFO!$E11:$G11),0))*3)","v":0},{"$f":"SUM(M11:O11)","v":0},null,{"$f":"IF($P11>$Q11,P11-Q11,0)","v":0}]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Bioko Norte"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"Malabo"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y12)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R12=\"Inconnu\",COUNTRY_INFO!R12=\"Surveillance\",COUNTRY_INFO!R12=\"Non requis\",COUNTRY_INFO!R12=0),0,IF($D12<>0, COUNTRY_INFO!R12,0))","v":12121},{"$f":"IF(OR(COUNTRY_INFO!S12=\"Inconnu\",COUNTRY_INFO!S12=\"Surveillance\",COUNTRY_INFO!S12=\"Non requis\",COUNTRY_INFO!S12=0),0,IF($D12<>0, COUNTRY_INFO!S12,0))","v":48171},{"$f":"IF(OR(COUNTRY_INFO!T12=\"Inconnu\",COUNTRY_INFO!T12=\"Surveillance\",COUNTRY_INFO!T12=\"Non requis\",COUNTRY_INFO!T12=0),0,IF($D12<>0, COUNTRY_INFO!T12,0))","v":119364},179656,null,null,0,null,null,{"$f":"IF($I12<>\"Oui\",$F12*2.5,($F12+ROUND(J12*$F12/SUM(COUNTRY_INFO!$E12:$G12),0))*2.5)","v":120427.5},{"$f":"IF($I12<>\"Oui\",$G12*3,($G12+ROUND(J12*$G12/SUM(COUNTRY_INFO!$E12:$G12),0))*3)","v":358092},478519.5,null,478519.5]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"Bioko Sur"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Luba"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y13)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R13=\"Inconnu\",COUNTRY_INFO!R13=\"Surveillance\",COUNTRY_INFO!R13=\"Non requis\",COUNTRY_INFO!R13=0),0,IF($D13<>0, COUNTRY_INFO!R13,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S13=\"Inconnu\",COUNTRY_INFO!S13=\"Surveillance\",COUNTRY_INFO!S13=\"Non requis\",COUNTRY_INFO!S13=0),0,IF($D13<>0, COUNTRY_INFO!S13,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T13=\"Inconnu\",COUNTRY_INFO!T13=\"Surveillance\",COUNTRY_INFO!T13=\"Non requis\",COUNTRY_INFO!T13=0),0,IF($D13<>0, COUNTRY_INFO!T13,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I13<>\"Oui\",$F13*2.5,($F13+ROUND(J13*$F13/SUM(COUNTRY_INFO!$E13:$G13),0))*2.5)","v":0},{"$f":"IF($I13<>\"Oui\",$G13*3,($G13+ROUND(J13*$G13/SUM(COUNTRY_INFO!$E13:$G13),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"Bioko Sur"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Riaba"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y14)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R14=\"Inconnu\",COUNTRY_INFO!R14=\"Surveillance\",COUNTRY_INFO!R14=\"Non requis\",COUNTRY_INFO!R14=0),0,IF($D14<>0, COUNTRY_INFO!R14,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S14=\"Inconnu\",COUNTRY_INFO!S14=\"Surveillance\",COUNTRY_INFO!S14=\"Non requis\",COUNTRY_INFO!S14=0),0,IF($D14<>0, COUNTRY_INFO!S14,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T14=\"Inconnu\",COUNTRY_INFO!T14=\"Surveillance\",COUNTRY_INFO!T14=\"Non requis\",COUNTRY_INFO!T14=0),0,IF($D14<>0, COUNTRY_INFO!T14,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I14<>\"Oui\",$F14*2.5,($F14+ROUND(J14*$F14/SUM(COUNTRY_INFO!$E14:$G14),0))*2.5)","v":0},{"$f":"IF($I14<>\"Oui\",$G14*3,($G14+ROUND(J14*$G14/SUM(COUNTRY_INFO!$E14:$G14),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"Centro Sur"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Acurenam"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y15)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R15=\"Inconnu\",COUNTRY_INFO!R15=\"Surveillance\",COUNTRY_INFO!R15=\"Non requis\",COUNTRY_INFO!R15=0),0,IF($D15<>0, COUNTRY_INFO!R15,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S15=\"Inconnu\",COUNTRY_INFO!S15=\"Surveillance\",COUNTRY_INFO!S15=\"Non requis\",COUNTRY_INFO!S15=0),0,IF($D15<>0, COUNTRY_INFO!S15,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T15=\"Inconnu\",COUNTRY_INFO!T15=\"Surveillance\",COUNTRY_INFO!T15=\"Non requis\",COUNTRY_INFO!T15=0),0,IF($D15<>0, COUNTRY_INFO!T15,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I15<>\"Oui\",$F15*2.5,($F15+ROUND(J15*$F15/SUM(COUNTRY_INFO!$E15:$G15),0))*2.5)","v":0},{"$f":"IF($I15<>\"Oui\",$G15*3,($G15+ROUND(J15*$G15/SUM(COUNTRY_INFO!$E15:$G15),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"Centro Sur"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Evinayong"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y16)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R16=\"Inconnu\",COUNTRY_INFO!R16=\"Surveillance\",COUNTRY_INFO!R16=\"Non requis\",COUNTRY_INFO!R16=0),0,IF($D16<>0, COUNTRY_INFO!R16,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S16=\"Inconnu\",COUNTRY_INFO!S16=\"Surveillance\",COUNTRY_INFO!S16=\"Non requis\",COUNTRY_INFO!S16=0),0,IF($D16<>0, COUNTRY_INFO!S16,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T16=\"Inconnu\",COUNTRY_INFO!T16=\"Surveillance\",COUNTRY_INFO!T16=\"Non requis\",COUNTRY_INFO!T16=0),0,IF($D16<>0, COUNTRY_INFO!T16,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I16<>\"Oui\",$F16*2.5,($F16+ROUND(J16*$F16/SUM(COUNTRY_INFO!$E16:$G16),0))*2.5)","v":0},{"$f":"IF($I16<>\"Oui\",$G16*3,($G16+ROUND(J16*$G16/SUM(COUNTRY_INFO!$E16:$G16),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"Centro Sur"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Niefang"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y17)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R17=\"Inconnu\",COUNTRY_INFO!R17=\"Surveillance\",COUNTRY_INFO!R17=\"Non requis\",COUNTRY_INFO!R17=0),0,IF($D17<>0, COUNTRY_INFO!R17,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S17=\"Inconnu\",COUNTRY_INFO!S17=\"Surveillance\",COUNTRY_INFO!S17=\"Non requis\",COUNTRY_INFO!S17=0),0,IF($D17<>0, COUNTRY_INFO!S17,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T17=\"Inconnu\",COUNTRY_INFO!T17=\"Surveillance\",COUNTRY_INFO!T17=\"Non requis\",COUNTRY_INFO!T17=0),0,IF($D17<>0, COUNTRY_INFO!T17,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I17<>\"Oui\",$F17*2.5,($F17+ROUND(J17*$F17/SUM(COUNTRY_INFO!$E17:$G17),0))*2.5)","v":0},{"$f":"IF($I17<>\"Oui\",$G17*3,($G17+ROUND(J17*$G17/SUM(COUNTRY_INFO!$E17:$G17),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"Kientem"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Ebebiyin"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y18)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R18=\"Inconnu\",COUNTRY_INFO!R18=\"Surveillance\",COUNTRY_INFO!R18=\"Non requis\",COUNTRY_INFO!R18=0),0,IF($D18<>0, COUNTRY_INFO!R18,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S18=\"Inconnu\",COUNTRY_INFO!S18=\"Surveillance\",COUNTRY_INFO!S18=\"Non requis\",COUNTRY_INFO!S18=0),0,IF($D18<>0, COUNTRY_INFO!S18,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T18=\"Inconnu\",COUNTRY_INFO!T18=\"Surveillance\",COUNTRY_INFO!T18=\"Non requis\",COUNTRY_INFO!T18=0),0,IF($D18<>0, COUNTRY_INFO!T18,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I18<>\"Oui\",$F18*2.5,($F18+ROUND(J18*$F18/SUM(COUNTRY_INFO!$E18:$G18),0))*2.5)","v":0},{"$f":"IF($I18<>\"Oui\",$G18*3,($G18+ROUND(J18*$G18/SUM(COUNTRY_INFO!$E18:$G18),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"Kientem"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Micomiseng"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y19)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R19=\"Inconnu\",COUNTRY_INFO!R19=\"Surveillance\",COUNTRY_INFO!R19=\"Non requis\",COUNTRY_INFO!R19=0),0,IF($D19<>0, COUNTRY_INFO!R19,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S19=\"Inconnu\",COUNTRY_INFO!S19=\"Surveillance\",COUNTRY_INFO!S19=\"Non requis\",COUNTRY_INFO!S19=0),0,IF($D19<>0, COUNTRY_INFO!S19,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T19=\"Inconnu\",COUNTRY_INFO!T19=\"Surveillance\",COUNTRY_INFO!T19=\"Non requis\",COUNTRY_INFO!T19=0),0,IF($D19<>0, COUNTRY_INFO!T19,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I19<>\"Oui\",$F19*2.5,($F19+ROUND(J19*$F19/SUM(COUNTRY_INFO!$E19:$G19),0))*2.5)","v":0},{"$f":"IF($I19<>\"Oui\",$G19*3,($G19+ROUND(J19*$G19/SUM(COUNTRY_INFO!$E19:$G19),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Kientem"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Nsoknsomo"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y20)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R20=\"Inconnu\",COUNTRY_INFO!R20=\"Surveillance\",COUNTRY_INFO!R20=\"Non requis\",COUNTRY_INFO!R20=0),0,IF($D20<>0, COUNTRY_INFO!R20,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S20=\"Inconnu\",COUNTRY_INFO!S20=\"Surveillance\",COUNTRY_INFO!S20=\"Non requis\",COUNTRY_INFO!S20=0),0,IF($D20<>0, COUNTRY_INFO!S20,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T20=\"Inconnu\",COUNTRY_INFO!T20=\"Surveillance\",COUNTRY_INFO!T20=\"Non requis\",COUNTRY_INFO!T20=0),0,IF($D20<>0, COUNTRY_INFO!T20,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I20<>\"Oui\",$F20*2.5,($F20+ROUND(J20*$F20/SUM(COUNTRY_INFO!$E20:$G20),0))*2.5)","v":0},{"$f":"IF($I20<>\"Oui\",$G20*3,($G20+ROUND(J20*$G20/SUM(COUNTRY_INFO!$E20:$G20),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"Litoral"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Bata"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y21)","v":1},{"$f":"IF(OR(COUNTRY_INFO!R21=\"Inconnu\",COUNTRY_INFO!R21=\"Surveillance\",COUNTRY_INFO!R21=\"Non requis\",COUNTRY_INFO!R21=0),0,IF($D21<>0, COUNTRY_INFO!R21,0))","v":13431},{"$f":"IF(OR(COUNTRY_INFO!S21=\"Inconnu\",COUNTRY_INFO!S21=\"Surveillance\",COUNTRY_INFO!S21=\"Non requis\",COUNTRY_INFO!S21=0),0,IF($D21<>0, COUNTRY_INFO!S21,0))","v":53379},{"$f":"IF(OR(COUNTRY_INFO!T21=\"Inconnu\",COUNTRY_INFO!T21=\"Surveillance\",COUNTRY_INFO!T21=\"Non requis\",COUNTRY_INFO!T21=0),0,IF($D21<>0, COUNTRY_INFO!T21,0))","v":132269},199079,null,null,0,null,null,{"$f":"IF($I21<>\"Oui\",$F21*2.5,($F21+ROUND(J21*$F21/SUM(COUNTRY_INFO!$E21:$G21),0))*2.5)","v":133447.5},{"$f":"IF($I21<>\"Oui\",$G21*3,($G21+ROUND(J21*$G21/SUM(COUNTRY_INFO!$E21:$G21),0))*3)","v":396807},530254.5,null,530254.5]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"Litoral"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"Kogo"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y22)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R22=\"Inconnu\",COUNTRY_INFO!R22=\"Surveillance\",COUNTRY_INFO!R22=\"Non requis\",COUNTRY_INFO!R22=0),0,IF($D22<>0, COUNTRY_INFO!R22,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S22=\"Inconnu\",COUNTRY_INFO!S22=\"Surveillance\",COUNTRY_INFO!S22=\"Non requis\",COUNTRY_INFO!S22=0),0,IF($D22<>0, COUNTRY_INFO!S22,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T22=\"Inconnu\",COUNTRY_INFO!T22=\"Surveillance\",COUNTRY_INFO!T22=\"Non requis\",COUNTRY_INFO!T22=0),0,IF($D22<>0, COUNTRY_INFO!T22,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I22<>\"Oui\",$F22*2.5,($F22+ROUND(J22*$F22/SUM(COUNTRY_INFO!$E22:$G22),0))*2.5)","v":0},{"$f":"IF($I22<>\"Oui\",$G22*3,($G22+ROUND(J22*$G22/SUM(COUNTRY_INFO!$E22:$G22),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"Litoral"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Mbini"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y23)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R23=\"Inconnu\",COUNTRY_INFO!R23=\"Surveillance\",COUNTRY_INFO!R23=\"Non requis\",COUNTRY_INFO!R23=0),0,IF($D23<>0, COUNTRY_INFO!R23,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S23=\"Inconnu\",COUNTRY_INFO!S23=\"Surveillance\",COUNTRY_INFO!S23=\"Non requis\",COUNTRY_INFO!S23=0),0,IF($D23<>0, COUNTRY_INFO!S23,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T23=\"Inconnu\",COUNTRY_INFO!T23=\"Surveillance\",COUNTRY_INFO!T23=\"Non requis\",COUNTRY_INFO!T23=0),0,IF($D23<>0, COUNTRY_INFO!T23,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I23<>\"Oui\",$F23*2.5,($F23+ROUND(J23*$F23/SUM(COUNTRY_INFO!$E23:$G23),0))*2.5)","v":0},{"$f":"IF($I23<>\"Oui\",$G23*3,($G23+ROUND(J23*$G23/SUM(COUNTRY_INFO!$E23:$G23),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"Welenzas"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"Akonibe"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y24)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R24=\"Inconnu\",COUNTRY_INFO!R24=\"Surveillance\",COUNTRY_INFO!R24=\"Non requis\",COUNTRY_INFO!R24=0),0,IF($D24<>0, COUNTRY_INFO!R24,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S24=\"Inconnu\",COUNTRY_INFO!S24=\"Surveillance\",COUNTRY_INFO!S24=\"Non requis\",COUNTRY_INFO!S24=0),0,IF($D24<>0, COUNTRY_INFO!S24,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T24=\"Inconnu\",COUNTRY_INFO!T24=\"Surveillance\",COUNTRY_INFO!T24=\"Non requis\",COUNTRY_INFO!T24=0),0,IF($D24<>0, COUNTRY_INFO!T24,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I24<>\"Oui\",$F24*2.5,($F24+ROUND(J24*$F24/SUM(COUNTRY_INFO!$E24:$G24),0))*2.5)","v":0},{"$f":"IF($I24<>\"Oui\",$G24*3,($G24+ROUND(J24*$G24/SUM(COUNTRY_INFO!$E24:$G24),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":"Welenzas"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":"Anisok"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y25)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R25=\"Inconnu\",COUNTRY_INFO!R25=\"Surveillance\",COUNTRY_INFO!R25=\"Non requis\",COUNTRY_INFO!R25=0),0,IF($D25<>0, COUNTRY_INFO!R25,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S25=\"Inconnu\",COUNTRY_INFO!S25=\"Surveillance\",COUNTRY_INFO!S25=\"Non requis\",COUNTRY_INFO!S25=0),0,IF($D25<>0, COUNTRY_INFO!S25,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T25=\"Inconnu\",COUNTRY_INFO!T25=\"Surveillance\",COUNTRY_INFO!T25=\"Non requis\",COUNTRY_INFO!T25=0),0,IF($D25<>0, COUNTRY_INFO!T25,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I25<>\"Oui\",$F25*2.5,($F25+ROUND(J25*$F25/SUM(COUNTRY_INFO!$E25:$G25),0))*2.5)","v":0},{"$f":"IF($I25<>\"Oui\",$G25*3,($G25+ROUND(J25*$G25/SUM(COUNTRY_INFO!$E25:$G25),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":"Welenzas"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":"Mongomo"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y26)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R26=\"Inconnu\",COUNTRY_INFO!R26=\"Surveillance\",COUNTRY_INFO!R26=\"Non requis\",COUNTRY_INFO!R26=0),0,IF($D26<>0, COUNTRY_INFO!R26,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S26=\"Inconnu\",COUNTRY_INFO!S26=\"Surveillance\",COUNTRY_INFO!S26=\"Non requis\",COUNTRY_INFO!S26=0),0,IF($D26<>0, COUNTRY_INFO!S26,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T26=\"Inconnu\",COUNTRY_INFO!T26=\"Surveillance\",COUNTRY_INFO!T26=\"Non requis\",COUNTRY_INFO!T26=0),0,IF($D26<>0, COUNTRY_INFO!T26,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I26<>\"Oui\",$F26*2.5,($F26+ROUND(J26*$F26/SUM(COUNTRY_INFO!$E26:$G26),0))*2.5)","v":0},{"$f":"IF($I26<>\"Oui\",$G26*3,($G26+ROUND(J26*$G26/SUM(COUNTRY_INFO!$E26:$G26),0))*3)","v":0},0,null,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":"Welenzas"},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":"Nsork"},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!Y27)","v":0},{"$f":"IF(OR(COUNTRY_INFO!R27=\"Inconnu\",COUNTRY_INFO!R27=\"Surveillance\",COUNTRY_INFO!R27=\"Non requis\",COUNTRY_INFO!R27=0),0,IF($D27<>0, COUNTRY_INFO!R27,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!S27=\"Inconnu\",COUNTRY_INFO!S27=\"Surveillance\",COUNTRY_INFO!S27=\"Non requis\",COUNTRY_INFO!S27=0),0,IF($D27<>0, COUNTRY_INFO!S27,0))","v":0},{"$f":"IF(OR(COUNTRY_INFO!T27=\"Inconnu\",COUNTRY_INFO!T27=\"Surveillance\",COUNTRY_INFO!T27=\"Non requis\",COUNTRY_INFO!T27=0),0,IF($D27<>0, COUNTRY_INFO!T27,0))","v":0},0,null,null,null,null,null,{"$f":"IF($I27<>\"Oui\",$F27*2.5,($F27+ROUND(J27*$F27/SUM(COUNTRY_INFO!$E27:$G27),0))*2.5)","v":0},{"$f":"IF($I27<>\"Oui\",$G27*3,($G27+ROUND(J27*$G27/SUM(COUNTRY_INFO!$E27:$G27),0))*3)","v":0},0,null,0]

{"sheet":"IVM","index":5,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,7,7,7],[6,9,7,9],[6,10,7,10],[6,11,7,11],[3,0,3,2],[3,4,3,5],[6,4,7,4],[6,5,7,5],[5,8,5,13],[6,0,7,0],[6,1,7,1],[6,2,7,2],[5,0,5,2],[5,4,5,5],[5,6,5,7],[6,12,7,12],[5,3,7,3],[6,13,7,13],[6,8,7,8],[6,6,7,6]]}
["Ivermectine (IVM)"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés"]
[]
["TOTAL",null,null,{"$f":"SUBTOTAL(9,D$10:D$1010)","v":857054},null,null,{"$f":"SUBTOTAL(9,G$10:G$1010)","v":0},0,0,0,0,0,0,0]
[]
["Structure administrative du pays",null,null,"Population nécessitant un traitement avec IVM","Plan de traitement",null,"Population cible",null,"Ivermectine (IVM)"]
["Pays","Région/Département","District",null,"FL","Oncho","FL","Oncho","FL uniquement","Oncho uniquement","FL+Oncho","Total requis","Reste en stock","Comprimés devant être fournis"]
[]
[]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"Annobon"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Annonbon"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!F10+COUNTRY_INFO!G10,0),IF(COUNTRY_INFO!$H10=1,COUNTRY_INFO!F10+COUNTRY_INFO!G10,IF(COUNTRY_INFO!$I10=1,IF(COUNTRY_INFO!M10>=(COUNTRY_INFO!F10+COUNTRY_INFO!G10),COUNTRY_INFO!F10+COUNTRY_INFO!G10,COUNTRY_INFO!$M10),0))))","v":0},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V10))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W10,\"Non requis\")","v":0},{"$f":"IF(COUNTRY_INFO!H10=1, IF($E10=1,$D10, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I10=1, IF($F10=1,$D10, 0),0)","v":0},{"$f":"IF(G10<H10,0,IF($E10=1, (G10-H10)*2.8, 0))","v":0},{"$f":"IF($E10<$F10, H10*(F10-E10)*2.8, 0)","v":0},{"$f":"IF(AND($E10=1, $F10<>0), H10*2.8, 0)","v":0},{"$f":"SUM(I10:K10)","v":0},null,{"$f":"IF($L10>$M10,$L10-$M10,0)","v":0}]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"Bioko Norte"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Baney"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!F11+COUNTRY_INFO!G11,0),IF(COUNTRY_INFO!$H11=1,COUNTRY_INFO!F11+COUNTRY_INFO!G11,IF(COUNTRY_INFO!$I11=1,IF(COUNTRY_INFO!M11>=(COUNTRY_INFO!F11+COUNTRY_INFO!G11),COUNTRY_INFO!F11+COUNTRY_INFO!G11,COUNTRY_INFO!$M11),0))))","v":27813},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V11))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W11,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I11=1, IF($F11=1,$D11, 0),0)","v":0},0,0,{"$f":"IF(AND($E11=1, $F11<>0), H11*2.8, 0)","v":0},{"$f":"SUM(I11:K11)","v":0},null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Bioko Norte"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"Malabo"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!F12+COUNTRY_INFO!G12,0),IF(COUNTRY_INFO!$H12=1,COUNTRY_INFO!F12+COUNTRY_INFO!G12,IF(COUNTRY_INFO!$I12=1,IF(COUNTRY_INFO!M12>=(COUNTRY_INFO!F12+COUNTRY_INFO!G12),COUNTRY_INFO!F12+COUNTRY_INFO!G12,COUNTRY_INFO!$M12),0))))","v":0},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V12))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W12,\"Non requis\")","v":0},{"$f":"IF(COUNTRY_INFO!H12=1, IF($E12=1,$D12, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I12=1, IF($F12=1,$D12, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"Bioko Sur"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Luba"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!F13+COUNTRY_INFO!G13,0),IF(COUNTRY_INFO!$H13=1,COUNTRY_INFO!F13+COUNTRY_INFO!G13,IF(COUNTRY_INFO!$I13=1,IF(COUNTRY_INFO!M13>=(COUNTRY_INFO!F13+COUNTRY_INFO!G13),COUNTRY_INFO!F13+COUNTRY_INFO!G13,COUNTRY_INFO!$M13),0))))","v":0},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V13))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W13,\"Non requis\")","v":0},{"$f":"IF(COUNTRY_INFO!H13=1, IF($E13=1,$D13, 0),0)","v":0},{"$f":"IF(COUNTRY_INFO!I13=1, IF($F13=1,$D13, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"Bioko Sur"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Riaba"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!F14+COUNTRY_INFO!G14,0),IF(COUNTRY_INFO!$H14=1,COUNTRY_INFO!F14+COUNTRY_INFO!G14,IF(COUNTRY_INFO!$I14=1,IF(COUNTRY_INFO!M14>=(COUNTRY_INFO!F14+COUNTRY_INFO!G14),COUNTRY_INFO!F14+COUNTRY_INFO!G14,COUNTRY_INFO!$M14),0))))","v":8650},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V14))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W14,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I14=1, IF($F14=1,$D14, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"Centro Sur"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Acurenam"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!F15+COUNTRY_INFO!G15,0),IF(COUNTRY_INFO!$H15=1,COUNTRY_INFO!F15+COUNTRY_INFO!G15,IF(COUNTRY_INFO!$I15=1,IF(COUNTRY_INFO!M15>=(COUNTRY_INFO!F15+COUNTRY_INFO!G15),COUNTRY_INFO!F15+COUNTRY_INFO!G15,COUNTRY_INFO!$M15),0))))","v":30238},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V15))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W15,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I15=1, IF($F15=1,$D15, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"Centro Sur"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Evinayong"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!F16+COUNTRY_INFO!G16,0),IF(COUNTRY_INFO!$H16=1,COUNTRY_INFO!F16+COUNTRY_INFO!G16,IF(COUNTRY_INFO!$I16=1,IF(COUNTRY_INFO!M16>=(COUNTRY_INFO!F16+COUNTRY_INFO!G16),COUNTRY_INFO!F16+COUNTRY_INFO!G16,COUNTRY_INFO!$M16),0))))","v":55516},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V16))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W16,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I16=1, IF($F16=1,$D16, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"Centro Sur"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Niefang"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!F17+COUNTRY_INFO!G17,0),IF(COUNTRY_INFO!$H17=1,COUNTRY_INFO!F17+COUNTRY_INFO!G17,IF(COUNTRY_INFO!$I17=1,IF(COUNTRY_INFO!M17>=(COUNTRY_INFO!F17+COUNTRY_INFO!G17),COUNTRY_INFO!F17+COUNTRY_INFO!G17,COUNTRY_INFO!$M17),0))))","v":71124},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V17))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W17,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I17=1, IF($F17=1,$D17, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"Kientem"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Ebebiyin"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!F18+COUNTRY_INFO!G18,0),IF(COUNTRY_INFO!$H18=1,COUNTRY_INFO!F18+COUNTRY_INFO!G18,IF(COUNTRY_INFO!$I18=1,IF(COUNTRY_INFO!M18>=(COUNTRY_INFO!F18+COUNTRY_INFO!G18),COUNTRY_INFO!F18+COUNTRY_INFO!G18,COUNTRY_INFO!$M18),0))))","v":118444},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V18))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W18,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I18=1, IF($F18=1,$D18, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"Kientem"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Micomiseng"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!F19+COUNTRY_INFO!G19,0),IF(COUNTRY_INFO!$H19=1,COUNTRY_INFO!F19+COUNTRY_INFO!G19,IF(COUNTRY_INFO!$I19=1,IF(COUNTRY_INFO!M19>=(COUNTRY_INFO!F19+COUNTRY_INFO!G19),COUNTRY_INFO!F19+COUNTRY_INFO!G19,COUNTRY_INFO!$M19),0))))","v":77875},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V19))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W19,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I19=1, IF($F19=1,$D19, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Kientem"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Nsoknsomo"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!F20+COUNTRY_INFO!G20,0),IF(COUNTRY_INFO!$H20=1,COUNTRY_INFO!F20+COUNTRY_INFO!G20,IF(COUNTRY_INFO!$I20=1,IF(COUNTRY_INFO!M20>=(COUNTRY_INFO!F20+COUNTRY_INFO!G20),COUNTRY_INFO!F20+COUNTRY_INFO!G20,COUNTRY_INFO!$M20),0))))","v":44897},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V20))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W20,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I20=1, IF($F20=1,$D20, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"Litoral"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Bata"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!F21+COUNTRY_INFO!G21,0),IF(COUNTRY_INFO!$H21=1,COUNTRY_INFO!F21+COUNTRY_INFO!G21,IF(COUNTRY_INFO!$I21=1,IF(COUNTRY_INFO!M21>=(COUNTRY_INFO!F21+COUNTRY_INFO!G21),COUNTRY_INFO!F21+COUNTRY_INFO!G21,COUNTRY_INFO!$M21),0))))","v":185648},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V21))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W21,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I21=1, IF($F21=1,$D21, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"Litoral"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"Kogo"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!F22+COUNTRY_INFO!G22,0),IF(COUNTRY_INFO!$H22=1,COUNTRY_INFO!F22+COUNTRY_INFO!G22,IF(COUNTRY_INFO!$I22=1,IF(COUNTRY_INFO!M22>=(COUNTRY_INFO!F22+COUNTRY_INFO!G22),COUNTRY_INFO!F22+COUNTRY_INFO!G22,COUNTRY_INFO!$M22),0))))","v":37977},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V22))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W22,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I22=1, IF($F22=1,$D22, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"Litoral"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Mbini"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!F23+COUNTRY_INFO!G23,0),IF(COUNTRY_INFO!$H23=1,COUNTRY_INFO!F23+COUNTRY_INFO!G23,IF(COUNTRY_INFO!$I23=1,IF(COUNTRY_INFO!M23>=(COUNTRY_INFO!F23+COUNTRY_INFO!G23),COUNTRY_INFO!F23+COUNTRY_INFO!G23,COUNTRY_INFO!$M23),0))))","v":36487},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V23))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W23,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I23=1, IF($F23=1,$D23, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"Welenzas"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"Akonibe"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!F24+COUNTRY_INFO!G24,0),IF(COUNTRY_INFO!$H24=1,COUNTRY_INFO!F24+COUNTRY_INFO!G24,IF(COUNTRY_INFO!$I24=1,IF(COUNTRY_INFO!M24>=(COUNTRY_INFO!F24+COUNTRY_INFO!G24),COUNTRY_INFO!F24+COUNTRY_INFO!G24,COUNTRY_INFO!$M24),0))))","v":23569},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V24))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W24,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I24=1, IF($F24=1,$D24, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":"Welenzas"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":"Anisok"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H25=1,COUNTRY_INFO!F25+COUNTRY_INFO!G25,0),IF(COUNTRY_INFO!$H25=1,COUNTRY_INFO!F25+COUNTRY_INFO!G25,IF(COUNTRY_INFO!$I25=1,IF(COUNTRY_INFO!M25>=(COUNTRY_INFO!F25+COUNTRY_INFO!G25),COUNTRY_INFO!F25+COUNTRY_INFO!G25,COUNTRY_INFO!$M25),0))))","v":58790},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V25))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W25,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I25=1, IF($F25=1,$D25, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":"Welenzas"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":"Mongomo"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H26=1,COUNTRY_INFO!F26+COUNTRY_INFO!G26,0),IF(COUNTRY_INFO!$H26=1,COUNTRY_INFO!F26+COUNTRY_INFO!G26,IF(COUNTRY_INFO!$I26=1,IF(COUNTRY_INFO!M26>=(COUNTRY_INFO!F26+COUNTRY_INFO!G26),COUNTRY_INFO!F26+COUNTRY_INFO!G26,COUNTRY_INFO!$M26),0))))","v":61764},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V26))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W26,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I26=1, IF($F26=1,$D26, 0),0)","v":0},0,0,0,0,null,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":"Guinée Équatoriale"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":"Welenzas"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":"Nsork"},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H27=1,COUNTRY_INFO!F27+COUNTRY_INFO!G27,0),IF(COUNTRY_INFO!$H27=1,COUNTRY_INFO!F27+COUNTRY_INFO!G27,IF(COUNTRY_INFO!$I27=1,IF(COUNTRY_INFO!M27>=(COUNTRY_INFO!F27+COUNTRY_INFO!G27),COUNTRY_INFO!F27+COUNTRY_INFO!G27,COUNTRY_INFO!$M27),0))))","v":18262},{"$f":"IF(AND(INTRO!$E$39=\"Non endémique\",INTRO!$E$37=\"Non endémique\"),\"Non requis\",IF(INTRO!$E$39=\"Non endémique\",\"Traiter avec DEC\",COUNTRY_INFO!V27))","v":1},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!W27,\"Non requis\")","v":0},0,{"$f":"IF(COUNTRY_INFO!I27=1, IF($F27=1,$D27, 0),0)","v":0},0,0,0,0,null,0]

{"sheet":"IVM+","index":6,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[6,5,7,5],[6,6,7,6],[6,7,7,7],[5,4,7,4],[5,5,5,7],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[3,0,3,2],[5,0,5,2]]}
["Ivermectine (IVM) pour IDA thérapie"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés"]
[]
["TOTAL",null,null,null,{"$f":"SUBTOTAL(9,E$10:E$1010)","v":0},0,0,0]
[]
["Structure administrative du pays",null,null,"Plan de traitement","Population nécessitant un traitement avec IVM\n(IDA thérapie)","Ivermectine (IVM)"]
["Pays","Région/Département","District","FL",null,"Total requis","Reste en stock","Comprimés devant être fournis"]
[]
[]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z10<>\"\",COUNTRY_INFO!V10,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z10<>\"\",COUNTRY_INFO!$H10=1),COUNTRY_INFO!F10+COUNTRY_INFO!G10,0)","v":0},{"$f":"E10*2.8","v":0},null,{"$f":"IF($F10>$G10,$F10-$G10,0)","v":0}]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z11<>\"\",COUNTRY_INFO!V11,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z11<>\"\",COUNTRY_INFO!$H11=1),COUNTRY_INFO!F11+COUNTRY_INFO!G11,0)","v":0},{"$f":"E11*2.8","v":0},null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z12<>\"\",COUNTRY_INFO!V12,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z12<>\"\",COUNTRY_INFO!$H12=1),COUNTRY_INFO!F12+COUNTRY_INFO!G12,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z13<>\"\",COUNTRY_INFO!V13,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z13<>\"\",COUNTRY_INFO!$H13=1),COUNTRY_INFO!F13+COUNTRY_INFO!G13,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z14<>\"\",COUNTRY_INFO!V14,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z14<>\"\",COUNTRY_INFO!$H14=1),COUNTRY_INFO!F14+COUNTRY_INFO!G14,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z15<>\"\",COUNTRY_INFO!V15,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z15<>\"\",COUNTRY_INFO!$H15=1),COUNTRY_INFO!F15+COUNTRY_INFO!G15,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z16<>\"\",COUNTRY_INFO!V16,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z16<>\"\",COUNTRY_INFO!$H16=1),COUNTRY_INFO!F16+COUNTRY_INFO!G16,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z17<>\"\",COUNTRY_INFO!V17,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z17<>\"\",COUNTRY_INFO!$H17=1),COUNTRY_INFO!F17+COUNTRY_INFO!G17,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z18<>\"\",COUNTRY_INFO!V18,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z18<>\"\",COUNTRY_INFO!$H18=1),COUNTRY_INFO!F18+COUNTRY_INFO!G18,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z19<>\"\",COUNTRY_INFO!V19,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z19<>\"\",COUNTRY_INFO!$H19=1),COUNTRY_INFO!F19+COUNTRY_INFO!G19,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z20<>\"\",COUNTRY_INFO!V20,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z20<>\"\",COUNTRY_INFO!$H20=1),COUNTRY_INFO!F20+COUNTRY_INFO!G20,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z21<>\"\",COUNTRY_INFO!V21,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z21<>\"\",COUNTRY_INFO!$H21=1),COUNTRY_INFO!F21+COUNTRY_INFO!G21,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z22<>\"\",COUNTRY_INFO!V22,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z22<>\"\",COUNTRY_INFO!$H22=1),COUNTRY_INFO!F22+COUNTRY_INFO!G22,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z23<>\"\",COUNTRY_INFO!V23,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z23<>\"\",COUNTRY_INFO!$H23=1),COUNTRY_INFO!F23+COUNTRY_INFO!G23,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z24<>\"\",COUNTRY_INFO!V24,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z24<>\"\",COUNTRY_INFO!$H24=1),COUNTRY_INFO!F24+COUNTRY_INFO!G24,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z25<>\"\",COUNTRY_INFO!V25,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z25<>\"\",COUNTRY_INFO!$H25=1),COUNTRY_INFO!F25+COUNTRY_INFO!G25,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z26<>\"\",COUNTRY_INFO!V26,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z26<>\"\",COUNTRY_INFO!$H26=1),COUNTRY_INFO!F26+COUNTRY_INFO!G26,0)","v":0},0,null,0]
[{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27),\" \")","v":" "},{"$f":"IF(AND(INTRO!$E$37=\"Endémique\",INTRO!$E$39=\"Non endémique\"),IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27),\" \")","v":" "},{"$f":"IF(COUNTRY_INFO!Z27<>\"\",COUNTRY_INFO!V27,0)","v":0},{"$f":"IF(AND(COUNTRY_INFO!Z27<>\"\",COUNTRY_INFO!$H27=1),COUNTRY_INFO!F27+COUNTRY_INFO!G27,0)","v":0},0,null,0]

{"sheet":"SUMMARY","index":7,"n_rows":93,"n_cols":8,"rows_kept":93,"cut":false,"hidden":false,"merged":[[57,1,57,7],[82,2,82,6],[63,4,63,6],[75,2,75,3],[97,1,97,7],[75,4,75,5],[70,4,70,5],[71,4,71,5],[70,2,70,3],[71,2,71,3],[92,1,92,7],[76,4,76,5],[87,1,87,7],[91,1,91,7],[86,1,86,7],[84,1,84,2],[84,3,84,7],[83,1,83,2],[0,1,0,7],[1,1,1,7],[2,1,2,5],[3,1,3,7],[4,1,4,7],[6,1,6,7],[5,2,5,5],[65,1,65,7],[54,1,54,7],[53,1,53,7],[36,1,36,7],[41,2,41,3],[41,4,41,5],[41,6,41,7],[55,1,55,7],[9,1,10,1],[9,3,9,6],[9,2,10,2],[17,1,19,1],[21,1,23,1],[25,1,27,1],[9,7,10,7],[32,2,35,4],[81,2,81,7],[83,3,83,7],[59,4,59,6],[50,1,50,7],[56,1,56,7],[51,1,51,7],[52,1,52,7],[80,1,80,7],[58,1,58,7],[78,1,78,7],[79,1,79,7],[66,1,66,7],[76,2,76,3],[74,2,74,3],[74,4,74,5],[73,2,73,3],[73,4,73,5],[60,4,60,6],[61,4,61,6],[62,4,62,6],[72,2,72,3],[72,4,72,5]]}
[]
[null,"Formulaire de demande commune de médicaments pour CP v.4.0"]
[]
[null,"Ce formulaire constitue une demande officielle du Gouvernement à l'OMS pour l'approvisionnement des médicaments mentionnés ci-dessus. Ce formulaire peut-être soumis à n'importe quel moment, avant le 15 août de l'année en cours, pour une livraison de médicaments au courant de l'année suivante, mais au moins 6-8 mois avant l’intervention planifiée afin de laisser le temps nécessaire pour réviser et approuver la demande, placer la commande, élaborer les médicaments et les expédier vers les pays."]
[]
[null,"Pays",{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Guinée Équatoriale"},null,null,null,"Année",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2023}]
[]
[null,"Information on PC medicines requested to WHO"]
[]
[null,"Le médicament","Groupe ciblé","Nombre de comprimés",null,null,null,"Préciser l’origine"]
[null,null,null,"Requis","En stock","En cours de demande","Demandés"]
[null,"Diethylcarbamazine","TOUTE",0,0,null,{"$f":"IF(D12>(E12+F12),D12-E12-F12, 0)","v":0}]
[null,null,null,null,null,null,0]
[null,"Ivermectine","TOUTE",0,0,null,0]
[]
[null,"Albendazole pour FL","TOUTE",1714108,857000,null,857108]
[null,null,null,null,null,null,0]
[null,"Albendazole pour STH","EAPréS",34640,null,null,34640]
[null,null,"EAS",103250,null,null,103250]
[null,null,"Adultes",94392,null,null,94392]
[]
[null,"Mebendazole","EAPréS",null,null,null,0]
[null,null,"EAS",null,null,null,0]
[null,null,"Adultes",null,null,null,0]
[]
[null,"Praziquantel","EAPréS",0,null,null,0]
[null,null,"EAS",203100,null,null,203100]
[null,null,"Adultes",754899,null,null,{"$f":"IF(D28>(E28+F28),D28-E28-F28, 0)","v":754899}]
[]
[null,"Nombre de personnes devant être traitées avec le médicament donné"]
[]
[null,"La maladie",null,null,null,"1er tour","2ème tour","3ème tour"]
[null,"Filariose lymphatique","Ces chiffres sont estimés uniquement pour les goupes d'âge ciblés pour le traitement avec les médicaments donnés, dans les régions où le traitement de maladies spécifiques est requis",null,null,857054]
[null,"Onchocercose",null,null,null,0,0]
[null,"Schistosomiase",null,null,null,353183,0]
[null,"Géohelminthiases",null,null,null,123912,108370,0]
[]
[]
[]
[null,"Informations sur les interventions CP planifiées "]
[]
[null,"Le médicament","Veuillez sélectionner une date (mois et année) pour la 1ère tournée de CP",null,"Veuillez sélectionner une date (mois et année) pour la 2ème tournée de CP",null,"Date à laquelle les médicaments devraient atteindre l’entrepôt national"]
[null,"Diethylcarbamazine"]
[null,"Ivermectine"]
[null,"Albendazole pour FL","Juillet",2023,null,null,"Avril",2023]
[null,"Albendazole pour STH","Juillet",2023,"Décembre",2023,"Avril",2023]
[null,"Mebendazole"]
[null,"Praziquantel","Juillet",2023,null,null,"Avril",2023]
[]
[null,"Récapitulatif - Checklist"]
[null,"Submission"]
[null,"Que faut-il soumettre ?"]
[null,"L'approvisionnement des médicaments demandés doit être basé sur des données épidémiologiques à jour, des plans d'utilisation des médicaments spécifiques et sur la capacité de mise en oeuvre. La liste suivante permet d'assurer que tous les formulaires et toutes les informations sont fournis à l'OMS (en format électronique)."]
[null,"Formulaire de demande commune de médicaments pour chimioprévention"]
[null,"Formulaire de rapport commun"]
[null,"Déclaration des données épidémiologiques pour la CP"]
[]
[null,"Disponibilité de financement pour la mise en oeuvre de tournées pendant l’année pour laquelle les medicaments ont été demandés"]
[]
[null,"Maladies ciblées pour la mise en oeuvre","# de traitements ","Financement assuré pour","Origine",null,null,"Montant"]
[null,"Filariose lymphatique",{"$f":"SUM(F33:H33)","v":857054},null,"ESPEN/OMS"]
[null,"Onchocercose",{"$f":"SUM(F34:H34)","v":0}]
[null,"Schistosomiase",{"$f":"SUM(F35:H35)","v":353183},null,"ESPEN/OMS"]
[null,"Géohelminthiases",{"$f":"SUM(F36:H36)","v":232282},null,"ESPEN/OMS"]
[]
[null,"Qui doit remplir le formulaire ?"]
[null,"Le Coordonnateur national MTN doit compiler toutes les informations nécessaires pour compléter le formulaire de demande.  En l'absence d'un coordonnateur, les gestionnaires de programmes spécifiques devraient coordonner leurs sections respectives. Une fois finalisée, chaque demande individuelle doit être approuvée par le Ministère de la Santé."]
[]
[null,"Informations concernant la (les) personne(s) ayant rempli le formulaire"]
[]
[null,"Titre/fonction ","Nom",null,"Téléphone",null,"Email","Date"]
[null,"Coordonnateur MTN/CP","Rufino Nguema Andeme",null,"00240 222 27 01 24",null,"rufonguema@yahoo.es","2022-11-11"]
[]
[]
[]
[]
[]
[]
[null,"L’OMS recommende que tous les effets secondaires graves suspectés d’être associés à l’ingestion de médicaments de CP soient rapportés en suivant les lignes directrices nationales de pharmacovigilance.  En l’absence d’un système de pharmacovigilance national, contactez le département de Contrôle des Maladies Tropicales Négligées pour être conseillé."]
[null,"L’OMS s’est engagée à rendre possible la donation de médicaments en fournissant gratuitement: a) albendazole, mebendazole et praziquantel à l’entrepôt national du Ministère de la Santé et b) diethylcarbamazine au port d’entrée du pays receveur."]
[null,"L’institution soumettant la présente requête est responsable de: a) l’organisation du déchargement des médicaments du camion, du stockage dans l’entrepôt national et de l’expédition vers les centres où aura lieu la distribution finale; b) de l’enregistrement, si nécessaire, des médicaments donnés, auprès des autorités nationales en charge; et de c) de l’information de n’importe quels changements ayant trait à leurs campagnes de traitement (par exemple le report d’une date planifiée de distribution en masse de médicaments, le remplacement d’un coordonateur MTN, etc.)."]
[null,null,"J’ai pris connaissance et accepté la politique de la communication \nde données de l’OMS"]
[null,null,"Je confirme que toutes les informations fournies dans ce formulaire sont complètes et correctes"]
[null,"Nom et signature \ndu Coordonnateur MTN ou du \nReprésentant du Ministère de la Santé",null,"Rufino Nguema Andeme"]
[null,"Date"]
[]
[null,"Si vous avez plus d'un destinataire final pour les médicaments de chimioprévention demandés, veuillez compléter les informations de la rubrique \"Informations concernant l'envoi et le destinataire\" dans la feuille de travail SHIPMENT."]
[null,"Veuillez envoyer le rapport national (signé et sous format électronique) au représentant de I'OMS du pays en mettant en copie:"]
[null,"Siège de l'OMS ","PC_JointForms@who.int"]
[null,"Bureau régional de l'OMS","Conseiller régional MTN"]
[null,"Mectizan donation programme","Dr Yao Sodahlon, email: ysodahlon@taskforce.org"]
[]
[null,"Veuillez noter que votre demande sera examinée par un panel d'experts indépendants (Comité ad hoc d’évaluation conjointe). Les informations contenues dans ce formulaire, le rapport commun d'activités (ou rapport national d'activités) et le plan d'action annuel sont essentiels à l'OMS pour assurer un usage optimal des médicaments. Dans le cadre de ses activités courantes de suivi et d'évaluation, et afin d'honorer ses obligations contractuelles envers les bailleurs de fonds  et autres partenaires, l'OMS et ses agents affiliés se réservent le droit d'inspecter, périodiquement, les stocks de médicaments au niveau national. "]

{"sheet":"SHIPMENT","index":8,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[32,2,32,4],[32,5,32,7],[29,2,29,4],[29,5,29,7],[30,2,30,4],[30,5,30,7],[31,2,31,4],[31,5,31,7],[26,2,26,4],[26,5,26,7],[27,2,27,4],[27,5,27,7],[28,2,28,4],[28,5,28,7],[23,2,23,4],[23,5,23,7],[21,5,21,7],[16,5,16,7],[17,2,17,4],[12,2,12,4],[12,5,12,7],[13,2,13,4],[13,5,13,7],[14,2,14,4],[14,5,14,7],[9,2,9,4],[9,5,9,7],[10,2,10,4],[10,5,10,7],[11,2,11,4],[11,5,11,7],[6,1,6,7],[7,2,7,4],[7,5,7,7],[8,2,8,4],[8,5,8,7],[15,5,15,7],[20,2,20,4],[18,2,18,4],[16,2,16,4],[47,1,54,7],[45,1,45,7],[37,1,37,6],[38,1,38,5],[40,1,40,7],[41,1,41,6],[39,1,39,6],[42,1,42,6],[43,1,43,7],[25,2,25,4],[25,5,25,7],[24,1,24,7],[34,1,34,7],[36,1,36,7],[0,1,0,7],[1,1,1,7],[2,1,2,5],[17,5,17,7],[18,5,18,7],[19,2,19,4],[19,5,19,7],[21,2,21,4],[3,2,3,5],[4,1,4,7],[22,2,22,4],[22,5,22,7],[15,2,15,4],[20,5,20,7]]}
[]
[null,"Formulaire de demande commune de médicaments pour CP v.4.0"]
[]
[null,"Pays",{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Guinée Équatoriale"},null,null,null,"Année",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2023}]
[]
[null,"Information on shipment and consignee "]
[]
[null,null,"Destinataire",null,null,"Destinataire final\nsi différent du destinaire précédent"]
[null,"Nom","MANKELE ANTONIN RAYLOUIS",null,null,"RUFINO NGUEMA ANDEME"]
[null,"Département/Unité",null,null,null,"PROGRAMME DE LUTTE CONTRE LES MTN-CTP"]
[null,"Organisation","ORGANISATION MONDIALE DE LA SANTE",null,null,"MINISTERE DE LA SANTE ET DU BIEN ETRE"]
[null,"Téléphone","00240 222 21 68 54",null,null,"00240 222 27 01 24"]
[null,"Fax"]
[null,"E-mail","mankeler@who.int",null,null,"rufonguema@yahoo.es"]
[null,"Adresse postale"]
[]
[null,null,"Destinataire",null,null,"Destinataire final\nsi différent du destinaire précédent"]
[null,"Nom","MANKELE ANTONIN RAYLOUIS",null,null,"RUFINO NGUEMA ANDEME"]
[null,"Département/Unité",null,null,null,"PROGRAMME DE LUTTE CONTRE LES MTN-CTP"]
[null,"Organisation","ORGANISATION MONDIALE DE LA SANTE",null,null,"MINISTERE DE LA SANTE ET DU BIEN ETRE"]
[null,"Téléphone","00240 222 21 68 54",null,null,"00240 222 27 01 24"]
[null,"Fax"]
[null,"E-mail","mankeler@who.int",null,null,"rufonguema@yahoo.es"]
[null,"Adresse postale"]
[]
[null,null,"Destinataire",null,null,"Destinataire final\nsi différent du destinaire précédent"]
[null,"Nom","MANKELE ANTONIN RAYLOUIS",null,null,"RUFINO NGUEMA ANDEME"]
[null,"Département/Unité",null,null,null,"PROGRAMME DE LUTTE CONTRE LES MTN-CTP"]
[null,"Organisation","ORGANISATION MONDIALE DE LA SANTE",null,null,"MINISTERE DE LA SANTE ET DU BIEN ETRE"]
[null,"Téléphone","00240 222 21 68 54",null,null,"00240 222 27 01 24"]
[null,"Fax"]
[null,"E-mail","mankeler@who.int",null,null,"rufonguema@yahoo.es"]
[null,"Adresse postale"]
[]
[]
[null,"Information concernant les obligations légales d’importation"]
[]
[null,"Est le permis d'importation nécessaire?",null,null,null,null,null,"Oui"]
[null,"Combien de temps cela prend-il pour obtenir le permis d’importation?",null,null,null,null,null,"Semaines"]
[null,"Avez vous besoin que certains documents soient remis en même temps que la demande de permis d’importation?",null,null,null,null,null,"Oui"]
[]
[null,"Est-ce que le destinataire doit procéder au dédouanement avant que l’expédition puisse avoir lieu?",null,null,null,null,null,"No"]
[null,"Y a-t-il des informations supplémentaires qui pourraient être utiles afin d’assurer un dédouanement et une livraison rapide des médicaments dans votre pays?",null,null,null,null,null,"No"]
[]
[]
[null,"Remarques supplémentaires éventuelles liées à cette requête"]

{"sheet":"DATA_POLICY","index":9,"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 demande commune de médicaments pour CP v.4.0"]
[]
[null,"Pays",null,{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Guinée Équatoriale"},null,null,"Année",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2023}]
[]
[]
[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 Guinée Équatoriale, 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 Guinée Équatoriale:"}]
[]
[]
[]
[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 Guinée Équatoriale 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."}]