{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["INTRO","COUNTRY_INFO","DEC","ALB_MBD","PZQ","IVM","SUMMARY","SHIPMENT","DATA_POLICY"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INTRO","index":0,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[21,1,21,4],[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],[0,1,0,4],[2,1,2,4],[1,1,1,4],[5,1,5,4],[3,1,3,4],[24,1,24,4],[9,2,9,4],[46,1,46,4],[38,1,38,2],[40,1,40,2],[42,1,42,2],[44,1,44,2],[34,1,34,2],[36,1,36,2],[22,2,23,4],[25,2,26,4],[19,1,19,4],[12,1,12,4],[16,1,16,4],[14,1,14,4],[15,1,15,4],[27,1,27,4],[32,1,32,2],[29,1,29,4],[30,1,30,4],[28,2,28,4]]}
[]
[null,"Formulaire de demande commune de médicaments pour CP v.3.1"]
[]
[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 : http://www.who.int/neglected_diseases/preventive_chemotherapy/pct_manual/en/index.html"]
[]
[null,"Veuillez entrer vos données dans les cellules en fonction de leur code de couleur :"]
[]
[null,null,"Blanc - la cellule n'est pas protégée. Veuillez entrer la valeur de l'indicateur demandé."]
[]
[null,null,"Jaune - la cellule est protégée et inclut le nom de l'indicateur. Aucune entrée de données requise."]
[]
[null,null,"Orange - la cellule n'est pas protégée et contient un menu déroulant. Veuillez sélectionner la valeur dans le menu déroulant. "]
[]
[]
[null,null,"Vert - la cellule n'est pas protégée et contient des formules. Veuillez changer la valeur indiquée uniquement si vos données sont différentes de celles calculées automatiquement.  "]
[]
[]
[null,null,"Bleu - la cellule est protégée et contient des formules. Aucune entrée de données requise. "]
[]
[null,"Données pays"]
[]
[null,"PAYS",null,null,"Cabo Verde"]
[]
[null,"Année de la demande de médicaments",null,null,2020]
[]
[null,"Le pays est-il endémique à la filariose lymphatique (FL) ?",null,null,"Non endémique"]
[]
[null,"Le pays est-il endémique à l'onchocercose (ONCHO) ? ",null,null,"Non endémique"]
[]
[null,"Le pays est-il endémique aux géohelminthiases (STH) ?",null,null,"Endémique"]
[]
[null,"Le pays est-il endémique à la schistosomiase (SCH) ?",null,null,"Non endémique"]
[]
[null,"Combien d'unités administratives compte le pays ?",null,null,22]
[]
[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,6.4000000000000001E-2]
[null,"5-14 ans","Enfants d'âge scolaire (EAS)",null,0.185]
[null,"15 ans et plus","Adultes",null,0.73899999999999999]

{"sheet":"COUNTRY_INFO","index":1,"n_rows":30,"n_cols":25,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,0,5,2],[3,19,3,22],[5,19,5,22],[7,0,7,18],[5,3,5,6],[5,7,5,10],[5,11,5,14],[5,15,5,18],[3,0,3,2],[3,7,3,10],[3,15,3,18]]}
["INFORMATIONS PAYS"]
["Struture administrative, population par groupe d'âge, statut d'endémicité et interventions planifiées",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0118]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":556859},{"$f":"SUM(E$9:E$1000)","v":35639},{"$f":"SUM(F$9:F$1000)","v":103020},{"$f":"SUM(G$9:G$1000)","v":411518},null,null,null,null,{"$f":"SUM(L$9:L$1000)","v":0},{"$f":"SUM(M$9:M$1000)","v":0},{"$f":"SUM(N$9:N$1000)","v":138659},{"$f":"SUM(O$9:O$1000)","v":0}]
[]
["Structure administrative du pays",null,null,"Population",null,null,null,"Endémicité",null,null,null,"Population nécessitant la CP",null,null,null,"Nombre de tournées de traitement prévues pour l'année",null,null,null,"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","SCH","FL","Oncho","STH","SCH","FL","Oncho","STH","SCH","IU_ID","IU_NAME"]
[]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Barlavento - Ilha SA","Ribeira Grande",15444,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D9*INTRO!$E$48,0))","v":988},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D9*INTRO!$E$49,0))","v":2857},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D9*INTRO!$E$50,0))","v":11413},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H9>0,IF($H9=4,\"Inconnu\",IF($H9=99,\"Interrompu\",$D9)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I9>0, IF($I9=4,\"Inconnu\",IF($I9=99,\"Interrompu\",$D9)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J9>1,$J9<5), IF($J9=4, \"Inconnu\", E9+F9), 0),\"Non requis\")","v":3845},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K9>0,$K9<5), IF($K9=4,\"Inconnu\", IF($K9=1, $F9*0.33, IF($K9=2, $F9*0.5+$G9*0.2, SUM(F9:G9)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8614,"Ribeira Grande"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Barlavento - Ilha SA","Paul",5382,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D10*INTRO!$E$48,0))","v":344},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D10*INTRO!$E$49,0))","v":996},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D10*INTRO!$E$50,0))","v":3977},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H10>0,IF($H10=4,\"Inconnu\",IF($H10=99,\"Interrompu\",$D10)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I10>0, IF($I10=4,\"Inconnu\",IF($I10=99,\"Interrompu\",$D10)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J10>1,$J10<5), IF($J10=4, \"Inconnu\", E10+F10), 0),\"Non requis\")","v":1340},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K10>0,$K10<5), IF($K10=4,\"Inconnu\", IF($K10=1, $F10*0.33, IF($K10=2, $F10*0.5+$G10*0.2, SUM(F10:G10)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8612,"Paul"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Barlavento - Ilha SA","Porto Novo",16832,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D11*INTRO!$E$48,0))","v":1077},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D11*INTRO!$E$49,0))","v":3114},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D11*INTRO!$E$50,0))","v":12439},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H11>0,IF($H11=4,\"Inconnu\",IF($H11=99,\"Interrompu\",$D11)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I11>0, IF($I11=4,\"Inconnu\",IF($I11=99,\"Interrompu\",$D11)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J11>1,$J11<5), IF($J11=4, \"Inconnu\", E11+F11), 0),\"Non requis\")","v":4191},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K11>0,$K11<5), IF($K11=4,\"Inconnu\", IF($K11=1, $F11*0.33, IF($K11=2, $F11*0.5+$G11*0.2, SUM(F11:G11)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8613,"Porto Novo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Barlavento - Ilha SV","São Vicente",84964,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D12*INTRO!$E$48,0))","v":5438},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D12*INTRO!$E$49,0))","v":15718},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D12*INTRO!$E$50,0))","v":62788},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H12>0,IF($H12=4,\"Inconnu\",IF($H12=99,\"Interrompu\",$D12)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I12>0, IF($I12=4,\"Inconnu\",IF($I12=99,\"Interrompu\",$D12)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J12>1,$J12<5), IF($J12=4, \"Inconnu\", E12+F12), 0),\"Non requis\")","v":21156},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K12>0,$K12<5), IF($K12=4,\"Inconnu\", IF($K12=1, $F12*0.33, IF($K12=2, $F12*0.5+$G12*0.2, SUM(F12:G12)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8633,"São Vicente"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Barlavento - Ilha SN","Ribeira Brava",6836,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D13*INTRO!$E$48,0))","v":438},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D13*INTRO!$E$49,0))","v":1265},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D13*INTRO!$E$50,0))","v":5052},0,0,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":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I13>0, IF($I13=4,\"Inconnu\",IF($I13=99,\"Interrompu\",$D13)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J13>1,$J13<5), IF($J13=4, \"Inconnu\", E13+F13), 0),\"Non requis\")","v":1703},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K13>0,$K13<5), IF($K13=4,\"Inconnu\", IF($K13=1, $F13*0.33, IF($K13=2, $F13*0.5+$G13*0.2, SUM(F13:G13)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8636,"Ribeira Brava"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Barlavento - Ilha SN","Tarrafal de São Nicolau",5195,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D14*INTRO!$E$48,0))","v":332},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D14*INTRO!$E$49,0))","v":961},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D14*INTRO!$E$50,0))","v":3839},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H14>0,IF($H14=4,\"Inconnu\",IF($H14=99,\"Interrompu\",$D14)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I14>0, IF($I14=4,\"Inconnu\",IF($I14=99,\"Interrompu\",$D14)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J14>1,$J14<5), IF($J14=4, \"Inconnu\", E14+F14), 0),\"Non requis\")","v":1293},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K14>0,$K14<5), IF($K14=4,\"Inconnu\", IF($K14=1, $F14*0.33, IF($K14=2, $F14*0.5+$G14*0.2, SUM(F14:G14)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8635,"Tarrafal de São Nicolau"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Barlavento - Ilha SAL","Sal",41121,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D15*INTRO!$E$48,0))","v":2632},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D15*INTRO!$E$49,0))","v":7607},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D15*INTRO!$E$50,0))","v":30388},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H15>0,IF($H15=4,\"Inconnu\",IF($H15=99,\"Interrompu\",$D15)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I15>0, IF($I15=4,\"Inconnu\",IF($I15=99,\"Interrompu\",$D15)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J15>1,$J15<5), IF($J15=4, \"Inconnu\", E15+F15), 0),\"Non requis\")","v":10239},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K15>0,$K15<5), IF($K15=4,\"Inconnu\", IF($K15=1, $F15*0.33, IF($K15=2, $F15*0.5+$G15*0.2, SUM(F15:G15)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8631,"Sal"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Barlavento - Ilha BV","Boa Vista",19879,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D16*INTRO!$E$48,0))","v":1272},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D16*INTRO!$E$49,0))","v":3678},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D16*INTRO!$E$50,0))","v":14691},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H16>0,IF($H16=4,\"Inconnu\",IF($H16=99,\"Interrompu\",$D16)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I16>0, IF($I16=4,\"Inconnu\",IF($I16=99,\"Interrompu\",$D16)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J16>1,$J16<5), IF($J16=4, \"Inconnu\", E16+F16), 0),\"Non requis\")","v":4950},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K16>0,$K16<5), IF($K16=4,\"Inconnu\", IF($K16=1, $F16*0.33, IF($K16=2, $F16*0.5+$G16*0.2, SUM(F16:G16)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8609,"Boa Vista"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha MAIO","Maio",7525,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D17*INTRO!$E$48,0))","v":482},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D17*INTRO!$E$49,0))","v":1392},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D17*INTRO!$E$50,0))","v":5561},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H17>0,IF($H17=4,\"Inconnu\",IF($H17=99,\"Interrompu\",$D17)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I17>0, IF($I17=4,\"Inconnu\",IF($I17=99,\"Interrompu\",$D17)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J17>1,$J17<5), IF($J17=4, \"Inconnu\", E17+F17), 0),\"Non requis\")","v":1874},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K17>0,$K17<5), IF($K17=4,\"Inconnu\", IF($K17=1, $F17*0.33, IF($K17=2, $F17*0.5+$G17*0.2, SUM(F17:G17)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8620,"Maio"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","Tarrafal",18085,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D18*INTRO!$E$48,0))","v":1157},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D18*INTRO!$E$49,0))","v":3346},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D18*INTRO!$E$50,0))","v":13365},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H18>0,IF($H18=4,\"Inconnu\",IF($H18=99,\"Interrompu\",$D18)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I18>0, IF($I18=4,\"Inconnu\",IF($I18=99,\"Interrompu\",$D18)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J18>1,$J18<5), IF($J18=4, \"Inconnu\", E18+F18), 0),\"Non requis\")","v":4503},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K18>0,$K18<5), IF($K18=4,\"Inconnu\", IF($K18=1, $F18*0.33, IF($K18=2, $F18*0.5+$G18*0.2, SUM(F18:G18)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8629,"Tarrafal"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","Santa Catarina",47181,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D19*INTRO!$E$48,0))","v":3020},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D19*INTRO!$E$49,0))","v":8728},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D19*INTRO!$E$50,0))","v":34867},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H19>0,IF($H19=4,\"Inconnu\",IF($H19=99,\"Interrompu\",$D19)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I19>0, IF($I19=4,\"Inconnu\",IF($I19=99,\"Interrompu\",$D19)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J19>1,$J19<5), IF($J19=4, \"Inconnu\", E19+F19), 0),\"Non requis\")","v":11748},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K19>0,$K19<5), IF($K19=4,\"Inconnu\", IF($K19=1, $F19*0.33, IF($K19=2, $F19*0.5+$G19*0.2, SUM(F19:G19)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8623,"Santa Catarina"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","Santa Cruz",25917,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D20*INTRO!$E$48,0))","v":1659},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D20*INTRO!$E$49,0))","v":4795},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D20*INTRO!$E$50,0))","v":19153},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H20>0,IF($H20=4,\"Inconnu\",IF($H20=99,\"Interrompu\",$D20)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I20>0, IF($I20=4,\"Inconnu\",IF($I20=99,\"Interrompu\",$D20)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J20>1,$J20<5), IF($J20=4, \"Inconnu\", E20+F20), 0),\"Non requis\")","v":6454},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K20>0,$K20<5), IF($K20=4,\"Inconnu\", IF($K20=1, $F20*0.33, IF($K20=2, $F20*0.5+$G20*0.2, SUM(F20:G20)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8626,"Santa Cruz"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","Praia",170236,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D21*INTRO!$E$48,0))","v":10895},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D21*INTRO!$E$49,0))","v":31494},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D21*INTRO!$E$50,0))","v":125804},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H21>0,IF($H21=4,\"Inconnu\",IF($H21=99,\"Interrompu\",$D21)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I21>0, IF($I21=4,\"Inconnu\",IF($I21=99,\"Interrompu\",$D21)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J21>1,$J21<5), IF($J21=4, \"Inconnu\", E21+F21), 0),\"Non requis\")","v":42389},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K21>0,$K21<5), IF($K21=4,\"Inconnu\", IF($K21=1, $F21*0.33, IF($K21=2, $F21*0.5+$G21*0.2, SUM(F21:G21)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8621,"Praia"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","São Domingos",14198,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D22*INTRO!$E$48,0))","v":909},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D22*INTRO!$E$49,0))","v":2627},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D22*INTRO!$E$50,0))","v":10492},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H22>0,IF($H22=4,\"Inconnu\",IF($H22=99,\"Interrompu\",$D22)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I22>0, IF($I22=4,\"Inconnu\",IF($I22=99,\"Interrompu\",$D22)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J22>1,$J22<5), IF($J22=4, \"Inconnu\", E22+F22), 0),\"Non requis\")","v":3536},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K22>0,$K22<5), IF($K22=4,\"Inconnu\", IF($K22=1, $F22*0.33, IF($K22=2, $F22*0.5+$G22*0.2, SUM(F22:G22)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8627,"São Domingos"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","Calheta de São Miguel",13779,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D23*INTRO!$E$48,0))","v":882},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D23*INTRO!$E$49,0))","v":2549},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D23*INTRO!$E$50,0))","v":10183},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H23>0,IF($H23=4,\"Inconnu\",IF($H23=99,\"Interrompu\",$D23)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I23>0, IF($I23=4,\"Inconnu\",IF($I23=99,\"Interrompu\",$D23)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J23>1,$J23<5), IF($J23=4, \"Inconnu\", E23+F23), 0),\"Non requis\")","v":3431},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K23>0,$K23<5), IF($K23=4,\"Inconnu\", IF($K23=1, $F23*0.33, IF($K23=2, $F23*0.5+$G23*0.2, SUM(F23:G23)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8628,"Calheta de São Miguel"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","São Salvador do Mundo",8596,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D24*INTRO!$E$48,0))","v":550},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D24*INTRO!$E$49,0))","v":1590},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D24*INTRO!$E$50,0))","v":6352},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H24>0,IF($H24=4,\"Inconnu\",IF($H24=99,\"Interrompu\",$D24)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I24>0, IF($I24=4,\"Inconnu\",IF($I24=99,\"Interrompu\",$D24)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J24>1,$J24<5), IF($J24=4, \"Inconnu\", E24+F24), 0),\"Non requis\")","v":2140},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K24>0,$K24<5), IF($K24=4,\"Inconnu\", IF($K24=1, $F24*0.33, IF($K24=2, $F24*0.5+$G24*0.2, SUM(F24:G24)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8637,"São Salvador do Mundo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","São Lourenço Orgãos",6913,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D25*INTRO!$E$48,0))","v":442},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D25*INTRO!$E$49,0))","v":1279},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D25*INTRO!$E$50,0))","v":5109},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H25>0,IF($H25=4,\"Inconnu\",IF($H25=99,\"Interrompu\",$D25)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I25>0, IF($I25=4,\"Inconnu\",IF($I25=99,\"Interrompu\",$D25)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J25>1,$J25<5), IF($J25=4, \"Inconnu\", E25+F25), 0),\"Non requis\")","v":1721},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K25>0,$K25<5), IF($K25=4,\"Inconnu\", IF($K25=1, $F25*0.33, IF($K25=2, $F25*0.5+$G25*0.2, SUM(F25:G25)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8638,"São Lourenço Orgãos"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha ST","Ribeira Grande Santiago",8556,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D26*INTRO!$E$48,0))","v":548},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D26*INTRO!$E$49,0))","v":1583},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D26*INTRO!$E$50,0))","v":6323},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H26>0,IF($H26=4,\"Inconnu\",IF($H26=99,\"Interrompu\",$D26)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I26>0, IF($I26=4,\"Inconnu\",IF($I26=99,\"Interrompu\",$D26)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J26>1,$J26<5), IF($J26=4, \"Inconnu\", E26+F26), 0),\"Non requis\")","v":2131},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K26>0,$K26<5), IF($K26=4,\"Inconnu\", IF($K26=1, $F26*0.33, IF($K26=2, $F26*0.5+$G26*0.2, SUM(F26:G26)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8639,"Ribeira Grande Santiago"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha FOGO","Mosteiros",9243,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D27*INTRO!$E$48,0))","v":592},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D27*INTRO!$E$49,0))","v":1710},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D27*INTRO!$E$50,0))","v":6831},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H27>0,IF($H27=4,\"Inconnu\",IF($H27=99,\"Interrompu\",$D27)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I27>0, IF($I27=4,\"Inconnu\",IF($I27=99,\"Interrompu\",$D27)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J27>1,$J27<5), IF($J27=4, \"Inconnu\", E27+F27), 0),\"Non requis\")","v":2302},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K27>0,$K27<5), IF($K27=4,\"Inconnu\", IF($K27=1, $F27*0.33, IF($K27=2, $F27*0.5+$G27*0.2, SUM(F27:G27)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8615,"Mosteiros"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha FOGO","São Filipe",20366,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D28*INTRO!$E$48,0))","v":1303},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D28*INTRO!$E$49,0))","v":3768},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D28*INTRO!$E$50,0))","v":15050},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H28>0,IF($H28=4,\"Inconnu\",IF($H28=99,\"Interrompu\",$D28)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I28>0, IF($I28=4,\"Inconnu\",IF($I28=99,\"Interrompu\",$D28)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J28>1,$J28<5), IF($J28=4, \"Inconnu\", E28+F28), 0),\"Non requis\")","v":5071},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K28>0,$K28<5), IF($K28=4,\"Inconnu\", IF($K28=1, $F28*0.33, IF($K28=2, $F28*0.5+$G28*0.2, SUM(F28:G28)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8616,"São Filipe"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha FOGO","Santa Catarina do Fogo",5206,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D29*INTRO!$E$48,0))","v":333},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D29*INTRO!$E$49,0))","v":963},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D29*INTRO!$E$50,0))","v":3847},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H29>0,IF($H29=4,\"Inconnu\",IF($H29=99,\"Interrompu\",$D29)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I29>0, IF($I29=4,\"Inconnu\",IF($I29=99,\"Interrompu\",$D29)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J29>1,$J29<5), IF($J29=4, \"Inconnu\", E29+F29), 0),\"Non requis\")","v":1296},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K29>0,$K29<5), IF($K29=4,\"Inconnu\", IF($K29=1, $F29*0.33, IF($K29=2, $F29*0.5+$G29*0.2, SUM(F29:G29)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8640,"Santa Catarina do Fogo"]
[{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33, \" \")","v":"Cabo Verde"},"Sotavento - Ilha BRAVA","Brava",5405,{"$f":"IF(INTRO!$E$48=\"\",\"\",ROUND($D30*INTRO!$E$48,0))","v":346},{"$f":"IF(INTRO!$E$49=\"\",\"\",ROUND($D30*INTRO!$E$49,0))","v":1000},{"$f":"IF(INTRO!$E$50=\"\",\"\",ROUND($D30*INTRO!$E$50,0))","v":3994},0,0,2,0,{"$f":"IF(INTRO!$E$37=\"Endémique\",IF($H30>0,IF($H30=4,\"Inconnu\",IF($H30=99,\"Interrompu\",$D30)),0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$39=\"Endémique\", IF($I30>0, IF($I30=4,\"Inconnu\",IF($I30=99,\"Interrompu\",$D30)), 0),\"Non requis\")","v":"Non requis"},{"$f":"IF(INTRO!$E$41=\"Endémique\", IF(AND($J30>1,$J30<5), IF($J30=4, \"Inconnu\", E30+F30), 0),\"Non requis\")","v":1346},{"$f":"IF(INTRO!$E$43=\"Endémique\", IF(AND($K30>0,$K30<5), IF($K30=4,\"Inconnu\", IF($K30=1, $F30*0.33, IF($K30=2, $F30*0.5+$G30*0.2, SUM(F30:G30)))), 0),\"Non requis\")","v":"Non requis"},null,null,1,null,null,null,null,null,8610,"Brava"]

{"sheet":"DEC","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":true,"merged":[[3,0,3,2],[5,0,5,2],[6,5,7,5],[6,2,7,2],[6,1,7,1],[6,0,7,0],[5,3,5,6],[6,6,7,6],[5,9,5,12],[6,11,7,11],[6,4,7,4],[6,3,7,3],[6,8,7,8],[6,7,7,7],[6,9,7,9],[6,10,7,10],[6,12,7,12]]}
["Diethylcarbamazine (DEC)"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":0},{"$f":"SUM(E$9:E$1000)","v":0},{"$f":"SUM(F$9:F$1000)","v":0},{"$f":"SUM(G$9:G$1000)","v":0},null,{"$f":"SUM(I$9:I$1000)","v":0},{"$f":"SUM(J$9:J$1000)","v":0},{"$f":"SUM(K$9:K$1000)","v":0},{"$f":"SUM(L$9:L$1000)","v":0},{"$f":"SUM(M$9:M$1000)","v":0}]
[]
["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","Flacons (100mg)\n1000 comprimés"]
[]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H9=1,COUNTRY_INFO!E9,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H9=1,COUNTRY_INFO!F9,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H9=1,COUNTRY_INFO!G9,0)))","v":0},{"$f":"SUM(D9:F9)","v":0},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!P9),\"Traiter avec IVM\")","v":"Non requis"},{"$f":"IF(H9=1,G9,0)","v":0},{"$f":"IF(I9>0,I9*2.5,0)","v":0},null,{"$f":"IF($J9>$K9,$J9-$K9,0)","v":0},{"$f":"ROUNDUP($J9/1000,0)","v":0}]
[{"$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},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!P10),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!P11),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P12),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P13),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P14),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P15),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P16),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P17),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P18),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P19),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P20),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P21),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P22),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P23),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P24),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P25),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P26),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,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!P27),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H28=1,COUNTRY_INFO!E28,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H28=1,COUNTRY_INFO!F28,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H28=1,COUNTRY_INFO!G28,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!P28),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H29=1,COUNTRY_INFO!E29,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H29=1,COUNTRY_INFO!F29,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H29=1,COUNTRY_INFO!G29,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!P29),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", \" \", IF(INTRO!$E$37=\"Non endémique\",\" \", IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30)))","v":" "},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H30=1,COUNTRY_INFO!E30,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H30=1,COUNTRY_INFO!F30,0)))","v":0},{"$f":"IF(INTRO!$E$39<>\"Non endémique\", 0, IF(INTRO!$E$37=\"Non endémique\",0,IF(COUNTRY_INFO!$H30=1,COUNTRY_INFO!G30,0)))","v":0},0,{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF(INTRO!$E$37=\"Non endémique\",\"Non requis\",COUNTRY_INFO!P30),\"Traiter avec IVM\")","v":"Non requis"},0,0,null,0,0]

{"sheet":"ALB_MBD","index":3,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,6,3,7],[5,0,5,2],[5,6,5,7],[5,3,5,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[5,18,5,23],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,14,6,17],[5,9,7,9],[6,10,6,13],[5,10,5,17],[5,8,7,8],[6,20,7,20],[6,22,7,22],[5,24,5,26],[6,24,7,24],[6,21,7,21],[6,18,7,18],[6,19,7,19],[6,23,7,23],[6,25,7,25],[6,26,7,26]]}
["Albendazole (ALB) et Mebendazole (MBD)"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":35639},{"$f":"SUM(E$9:E$1000)","v":103020},{"$f":"SUM(F$9:F$1000)","v":138659},null,null,{"$f":"SUM(I$9:I$1000)","v":0},null,{"$f":"SUM(K$9:K$1000)","v":0},{"$f":"SUM(L$9:L$1000)","v":0},{"$f":"SUM(M$9:M$1000)","v":0},{"$f":"SUM(N$9:N$1000)","v":0},{"$f":"SUM(O$9:O$1000)","v":35639},{"$f":"SUM(P$9:P$1000)","v":103020},0,138659,0,0,0,0,0,0,0,138659,697]
[]
["Structure administrative du pays",null,null,"Population nécessitant un traitement avec ALB/MBD",null,null,"Plan de traitement",null,"Population couverte par le PEFL avec ALB","Médicament choisi pour le traitement des STH","Population cible",null,null,null,null,null,null,null,"Albendazole (ALB)",null,null,null,null,null,"Mebendazole (MBD)"]
["Pays","Région/Département","District","EAPréS","EAS","Total","FL","STH",null,null,"STH (ALB)",null,null,null,"STH (MBD)",null,null,null,"Reste en stock (FL)","Comprimés devant être fournis (FL)","Flacons (400mg)\n200 comprimés (FL)","Reste en stock (STH)","Comprimés devant être fournis pour EAS (STH)","Flacons (400mg)\n200 comprimés (STH)","Reste en stock","Comprimés devant être fournis pour EAS","Flacons (500mg)\n150 comprimés"]
[null,null,null,null,null,null,null,null,null,null,"EAPréS","EAS","Autres","Total","EAPréS","EAS","Autres","Total"]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9))","v":"Barlavento - Ilha SA"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9))","v":"Ribeira Grande"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H9=0,COUNTRY_INFO!$H9=4,COUNTRY_INFO!$H9=99),OR(COUNTRY_INFO!$J9=0,COUNTRY_INFO!$J9=4)),0,COUNTRY_INFO!$E9))","v":988},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H9=0,COUNTRY_INFO!$H9=4,COUNTRY_INFO!$H9=99),OR(COUNTRY_INFO!$J9=0,COUNTRY_INFO!$J9=4)),0,COUNTRY_INFO!$F9))","v":2857},{"$f":"SUM(D9:E9)","v":3845},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P9)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R9)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G9=1,DEC!I9,0),IF($G9=1,IVM!G9,0))","v":0},"MBD",{"$f":"IF($J9=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H9<>0,$D9*($H9-$G9),0),$D9*$H9), 0)","v":0},{"$f":"IF($J9=\"ALB\", IF($H9<>0, IF($I9=0, $E9*$H9, $E9*($H9-$G9)),0), 0)","v":0},null,{"$f":"SUM(K9:M9)","v":0},{"$f":"IF($J9=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H9<>0,$D9*($H9-$G9),0),$D9*$H9),0)","v":988},{"$f":"IF($J9=\"MBD\", IF($H9<>0,IF($I9=0, $E9*$H9, $E9*($H9-$G9)),0), 0 )","v":2857},null,{"$f":"SUM(O9:Q9)","v":3845},null,{"$f":"IF($I9>$S9, $I9-$S9,0)","v":0},{"$f":"ROUNDUP($I9/200,0)","v":0},null,{"$f":"IF($L9>$V9,$L9-$V9,0)","v":0},{"$f":"ROUNDUP($L9/200,0)","v":0},null,{"$f":"IF($P9>$Y9,$P9-$Y9,0)+O9","v":3845},{"$f":"ROUNDUP($P9/150,0)","v":20}]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":"Barlavento - Ilha SA"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":"Paul"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H10=0,COUNTRY_INFO!$H10=4,COUNTRY_INFO!$H10=99),OR(COUNTRY_INFO!$J10=0,COUNTRY_INFO!$J10=4)),0,COUNTRY_INFO!$E10))","v":344},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H10=0,COUNTRY_INFO!$H10=4,COUNTRY_INFO!$H10=99),OR(COUNTRY_INFO!$J10=0,COUNTRY_INFO!$J10=4)),0,COUNTRY_INFO!$F10))","v":996},1340,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P10)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R10)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G10=1,DEC!I10,0),IF($G10=1,IVM!G10,0))","v":0},"MBD",{"$f":"IF($J10=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H10<>0,$D10*($H10-$G10),0),$D10*$H10), 0)","v":0},0,null,0,{"$f":"IF($J10=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H10<>0,$D10*($H10-$G10),0),$D10*$H10),0)","v":344},996,null,1340,null,0,0,null,0,0,null,{"$f":"IF($P10>$Y10,$P10-$Y10,0)+O10","v":1340},7]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":"Barlavento - Ilha SA"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":"Porto Novo"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H11=0,COUNTRY_INFO!$H11=4,COUNTRY_INFO!$H11=99),OR(COUNTRY_INFO!$J11=0,COUNTRY_INFO!$J11=4)),0,COUNTRY_INFO!$E11))","v":1077},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H11=0,COUNTRY_INFO!$H11=4,COUNTRY_INFO!$H11=99),OR(COUNTRY_INFO!$J11=0,COUNTRY_INFO!$J11=4)),0,COUNTRY_INFO!$F11))","v":3114},4191,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P11)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R11)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G11=1,DEC!I11,0),IF($G11=1,IVM!G11,0))","v":0},"MBD",{"$f":"IF($J11=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H11<>0,$D11*($H11-$G11),0),$D11*$H11), 0)","v":0},0,null,0,{"$f":"IF($J11=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H11<>0,$D11*($H11-$G11),0),$D11*$H11),0)","v":1077},3114,null,4191,null,0,0,null,0,0,null,4191,21]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":"Barlavento - Ilha SV"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":"São Vicente"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H12=0,COUNTRY_INFO!$H12=4,COUNTRY_INFO!$H12=99),OR(COUNTRY_INFO!$J12=0,COUNTRY_INFO!$J12=4)),0,COUNTRY_INFO!$E12))","v":5438},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H12=0,COUNTRY_INFO!$H12=4,COUNTRY_INFO!$H12=99),OR(COUNTRY_INFO!$J12=0,COUNTRY_INFO!$J12=4)),0,COUNTRY_INFO!$F12))","v":15718},21156,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P12)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R12)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G12=1,DEC!I12,0),IF($G12=1,IVM!G12,0))","v":0},"MBD",{"$f":"IF($J12=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H12<>0,$D12*($H12-$G12),0),$D12*$H12), 0)","v":0},0,null,0,{"$f":"IF($J12=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H12<>0,$D12*($H12-$G12),0),$D12*$H12),0)","v":5438},15718,null,21156,null,0,0,null,0,0,null,21156,105]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":"Barlavento - Ilha SN"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":"Ribeira Brava"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H13=0,COUNTRY_INFO!$H13=4,COUNTRY_INFO!$H13=99),OR(COUNTRY_INFO!$J13=0,COUNTRY_INFO!$J13=4)),0,COUNTRY_INFO!$E13))","v":438},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H13=0,COUNTRY_INFO!$H13=4,COUNTRY_INFO!$H13=99),OR(COUNTRY_INFO!$J13=0,COUNTRY_INFO!$J13=4)),0,COUNTRY_INFO!$F13))","v":1265},1703,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P13)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R13)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G13=1,DEC!I13,0),IF($G13=1,IVM!G13,0))","v":0},"MBD",{"$f":"IF($J13=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H13<>0,$D13*($H13-$G13),0),$D13*$H13), 0)","v":0},0,null,0,{"$f":"IF($J13=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H13<>0,$D13*($H13-$G13),0),$D13*$H13),0)","v":438},1265,null,1703,null,0,0,null,0,0,null,1703,9]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":"Barlavento - Ilha SN"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":"Tarrafal de São Nicolau"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H14=0,COUNTRY_INFO!$H14=4,COUNTRY_INFO!$H14=99),OR(COUNTRY_INFO!$J14=0,COUNTRY_INFO!$J14=4)),0,COUNTRY_INFO!$E14))","v":332},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H14=0,COUNTRY_INFO!$H14=4,COUNTRY_INFO!$H14=99),OR(COUNTRY_INFO!$J14=0,COUNTRY_INFO!$J14=4)),0,COUNTRY_INFO!$F14))","v":961},1293,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P14)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R14)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G14=1,DEC!I14,0),IF($G14=1,IVM!G14,0))","v":0},"MBD",{"$f":"IF($J14=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H14<>0,$D14*($H14-$G14),0),$D14*$H14), 0)","v":0},0,null,0,{"$f":"IF($J14=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H14<>0,$D14*($H14-$G14),0),$D14*$H14),0)","v":332},961,null,1293,null,0,0,null,0,0,null,1293,7]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":"Barlavento - Ilha SAL"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":"Sal"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H15=0,COUNTRY_INFO!$H15=4,COUNTRY_INFO!$H15=99),OR(COUNTRY_INFO!$J15=0,COUNTRY_INFO!$J15=4)),0,COUNTRY_INFO!$E15))","v":2632},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H15=0,COUNTRY_INFO!$H15=4,COUNTRY_INFO!$H15=99),OR(COUNTRY_INFO!$J15=0,COUNTRY_INFO!$J15=4)),0,COUNTRY_INFO!$F15))","v":7607},10239,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P15)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R15)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G15=1,DEC!I15,0),IF($G15=1,IVM!G15,0))","v":0},"MBD",{"$f":"IF($J15=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H15<>0,$D15*($H15-$G15),0),$D15*$H15), 0)","v":0},0,null,0,{"$f":"IF($J15=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H15<>0,$D15*($H15-$G15),0),$D15*$H15),0)","v":2632},7607,null,10239,null,0,0,null,0,0,null,10239,51]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":"Barlavento - Ilha BV"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":"Boa Vista"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H16=0,COUNTRY_INFO!$H16=4,COUNTRY_INFO!$H16=99),OR(COUNTRY_INFO!$J16=0,COUNTRY_INFO!$J16=4)),0,COUNTRY_INFO!$E16))","v":1272},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H16=0,COUNTRY_INFO!$H16=4,COUNTRY_INFO!$H16=99),OR(COUNTRY_INFO!$J16=0,COUNTRY_INFO!$J16=4)),0,COUNTRY_INFO!$F16))","v":3678},4950,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P16)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R16)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G16=1,DEC!I16,0),IF($G16=1,IVM!G16,0))","v":0},"MBD",{"$f":"IF($J16=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H16<>0,$D16*($H16-$G16),0),$D16*$H16), 0)","v":0},0,null,0,{"$f":"IF($J16=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H16<>0,$D16*($H16-$G16),0),$D16*$H16),0)","v":1272},3678,null,4950,null,0,0,null,0,0,null,4950,25]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":"Sotavento - Ilha MAIO"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":"Maio"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H17=0,COUNTRY_INFO!$H17=4,COUNTRY_INFO!$H17=99),OR(COUNTRY_INFO!$J17=0,COUNTRY_INFO!$J17=4)),0,COUNTRY_INFO!$E17))","v":482},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H17=0,COUNTRY_INFO!$H17=4,COUNTRY_INFO!$H17=99),OR(COUNTRY_INFO!$J17=0,COUNTRY_INFO!$J17=4)),0,COUNTRY_INFO!$F17))","v":1392},1874,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P17)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R17)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G17=1,DEC!I17,0),IF($G17=1,IVM!G17,0))","v":0},"MBD",{"$f":"IF($J17=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H17<>0,$D17*($H17-$G17),0),$D17*$H17), 0)","v":0},0,null,0,{"$f":"IF($J17=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H17<>0,$D17*($H17-$G17),0),$D17*$H17),0)","v":482},1392,null,1874,null,0,0,null,0,0,null,1874,10]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":"Tarrafal"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H18=0,COUNTRY_INFO!$H18=4,COUNTRY_INFO!$H18=99),OR(COUNTRY_INFO!$J18=0,COUNTRY_INFO!$J18=4)),0,COUNTRY_INFO!$E18))","v":1157},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H18=0,COUNTRY_INFO!$H18=4,COUNTRY_INFO!$H18=99),OR(COUNTRY_INFO!$J18=0,COUNTRY_INFO!$J18=4)),0,COUNTRY_INFO!$F18))","v":3346},4503,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P18)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R18)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G18=1,DEC!I18,0),IF($G18=1,IVM!G18,0))","v":0},"MBD",{"$f":"IF($J18=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H18<>0,$D18*($H18-$G18),0),$D18*$H18), 0)","v":0},0,null,0,{"$f":"IF($J18=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H18<>0,$D18*($H18-$G18),0),$D18*$H18),0)","v":1157},3346,null,4503,null,0,0,null,0,0,null,4503,23]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":"Santa Catarina"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H19=0,COUNTRY_INFO!$H19=4,COUNTRY_INFO!$H19=99),OR(COUNTRY_INFO!$J19=0,COUNTRY_INFO!$J19=4)),0,COUNTRY_INFO!$E19))","v":3020},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H19=0,COUNTRY_INFO!$H19=4,COUNTRY_INFO!$H19=99),OR(COUNTRY_INFO!$J19=0,COUNTRY_INFO!$J19=4)),0,COUNTRY_INFO!$F19))","v":8728},11748,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P19)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R19)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G19=1,DEC!I19,0),IF($G19=1,IVM!G19,0))","v":0},"MBD",{"$f":"IF($J19=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H19<>0,$D19*($H19-$G19),0),$D19*$H19), 0)","v":0},0,null,0,{"$f":"IF($J19=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H19<>0,$D19*($H19-$G19),0),$D19*$H19),0)","v":3020},8728,null,11748,null,0,0,null,0,0,null,11748,59]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":"Santa Cruz"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H20=0,COUNTRY_INFO!$H20=4,COUNTRY_INFO!$H20=99),OR(COUNTRY_INFO!$J20=0,COUNTRY_INFO!$J20=4)),0,COUNTRY_INFO!$E20))","v":1659},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H20=0,COUNTRY_INFO!$H20=4,COUNTRY_INFO!$H20=99),OR(COUNTRY_INFO!$J20=0,COUNTRY_INFO!$J20=4)),0,COUNTRY_INFO!$F20))","v":4795},6454,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P20)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R20)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G20=1,DEC!I20,0),IF($G20=1,IVM!G20,0))","v":0},"MBD",{"$f":"IF($J20=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H20<>0,$D20*($H20-$G20),0),$D20*$H20), 0)","v":0},0,null,0,{"$f":"IF($J20=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H20<>0,$D20*($H20-$G20),0),$D20*$H20),0)","v":1659},4795,null,6454,null,0,0,null,0,0,null,6454,32]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":"Praia"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H21=0,COUNTRY_INFO!$H21=4,COUNTRY_INFO!$H21=99),OR(COUNTRY_INFO!$J21=0,COUNTRY_INFO!$J21=4)),0,COUNTRY_INFO!$E21))","v":10895},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H21=0,COUNTRY_INFO!$H21=4,COUNTRY_INFO!$H21=99),OR(COUNTRY_INFO!$J21=0,COUNTRY_INFO!$J21=4)),0,COUNTRY_INFO!$F21))","v":31494},42389,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P21)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R21)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G21=1,DEC!I21,0),IF($G21=1,IVM!G21,0))","v":0},"MBD",{"$f":"IF($J21=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H21<>0,$D21*($H21-$G21),0),$D21*$H21), 0)","v":0},0,null,0,{"$f":"IF($J21=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H21<>0,$D21*($H21-$G21),0),$D21*$H21),0)","v":10895},31494,null,42389,null,0,0,null,0,0,null,42389,210]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":"São Domingos"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H22=0,COUNTRY_INFO!$H22=4,COUNTRY_INFO!$H22=99),OR(COUNTRY_INFO!$J22=0,COUNTRY_INFO!$J22=4)),0,COUNTRY_INFO!$E22))","v":909},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H22=0,COUNTRY_INFO!$H22=4,COUNTRY_INFO!$H22=99),OR(COUNTRY_INFO!$J22=0,COUNTRY_INFO!$J22=4)),0,COUNTRY_INFO!$F22))","v":2627},3536,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P22)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R22)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G22=1,DEC!I22,0),IF($G22=1,IVM!G22,0))","v":0},"MBD",{"$f":"IF($J22=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H22<>0,$D22*($H22-$G22),0),$D22*$H22), 0)","v":0},0,null,0,{"$f":"IF($J22=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H22<>0,$D22*($H22-$G22),0),$D22*$H22),0)","v":909},2627,null,3536,null,0,0,null,0,0,null,3536,18]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":"Calheta de São Miguel"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H23=0,COUNTRY_INFO!$H23=4,COUNTRY_INFO!$H23=99),OR(COUNTRY_INFO!$J23=0,COUNTRY_INFO!$J23=4)),0,COUNTRY_INFO!$E23))","v":882},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H23=0,COUNTRY_INFO!$H23=4,COUNTRY_INFO!$H23=99),OR(COUNTRY_INFO!$J23=0,COUNTRY_INFO!$J23=4)),0,COUNTRY_INFO!$F23))","v":2549},3431,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P23)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R23)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G23=1,DEC!I23,0),IF($G23=1,IVM!G23,0))","v":0},"MBD",{"$f":"IF($J23=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H23<>0,$D23*($H23-$G23),0),$D23*$H23), 0)","v":0},0,null,0,{"$f":"IF($J23=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H23<>0,$D23*($H23-$G23),0),$D23*$H23),0)","v":882},2549,null,3431,null,0,0,null,0,0,null,3431,17]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":"São Salvador do Mundo"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H24=0,COUNTRY_INFO!$H24=4,COUNTRY_INFO!$H24=99),OR(COUNTRY_INFO!$J24=0,COUNTRY_INFO!$J24=4)),0,COUNTRY_INFO!$E24))","v":550},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H24=0,COUNTRY_INFO!$H24=4,COUNTRY_INFO!$H24=99),OR(COUNTRY_INFO!$J24=0,COUNTRY_INFO!$J24=4)),0,COUNTRY_INFO!$F24))","v":1590},2140,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P24)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R24)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G24=1,DEC!I24,0),IF($G24=1,IVM!G24,0))","v":0},"MBD",{"$f":"IF($J24=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H24<>0,$D24*($H24-$G24),0),$D24*$H24), 0)","v":0},0,null,0,{"$f":"IF($J24=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H24<>0,$D24*($H24-$G24),0),$D24*$H24),0)","v":550},1590,null,2140,null,0,0,null,0,0,null,2140,11]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":"São Lourenço Orgãos"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H25=0,COUNTRY_INFO!$H25=4,COUNTRY_INFO!$H25=99),OR(COUNTRY_INFO!$J25=0,COUNTRY_INFO!$J25=4)),0,COUNTRY_INFO!$E25))","v":442},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H25=0,COUNTRY_INFO!$H25=4,COUNTRY_INFO!$H25=99),OR(COUNTRY_INFO!$J25=0,COUNTRY_INFO!$J25=4)),0,COUNTRY_INFO!$F25))","v":1279},1721,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P25)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R25)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G25=1,DEC!I25,0),IF($G25=1,IVM!G25,0))","v":0},"MBD",{"$f":"IF($J25=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H25<>0,$D25*($H25-$G25),0),$D25*$H25), 0)","v":0},0,null,0,{"$f":"IF($J25=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H25<>0,$D25*($H25-$G25),0),$D25*$H25),0)","v":442},1279,null,1721,null,0,0,null,0,0,null,1721,9]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":"Sotavento - Ilha ST"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":"Ribeira Grande Santiago"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H26=0,COUNTRY_INFO!$H26=4,COUNTRY_INFO!$H26=99),OR(COUNTRY_INFO!$J26=0,COUNTRY_INFO!$J26=4)),0,COUNTRY_INFO!$E26))","v":548},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H26=0,COUNTRY_INFO!$H26=4,COUNTRY_INFO!$H26=99),OR(COUNTRY_INFO!$J26=0,COUNTRY_INFO!$J26=4)),0,COUNTRY_INFO!$F26))","v":1583},2131,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P26)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R26)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G26=1,DEC!I26,0),IF($G26=1,IVM!G26,0))","v":0},"MBD",{"$f":"IF($J26=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H26<>0,$D26*($H26-$G26),0),$D26*$H26), 0)","v":0},0,null,0,{"$f":"IF($J26=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H26<>0,$D26*($H26-$G26),0),$D26*$H26),0)","v":548},1583,null,2131,null,0,0,null,0,0,null,2131,11]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":"Sotavento - Ilha FOGO"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":"Mosteiros"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H27=0,COUNTRY_INFO!$H27=4,COUNTRY_INFO!$H27=99),OR(COUNTRY_INFO!$J27=0,COUNTRY_INFO!$J27=4)),0,COUNTRY_INFO!$E27))","v":592},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H27=0,COUNTRY_INFO!$H27=4,COUNTRY_INFO!$H27=99),OR(COUNTRY_INFO!$J27=0,COUNTRY_INFO!$J27=4)),0,COUNTRY_INFO!$F27))","v":1710},2302,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P27)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R27)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G27=1,DEC!I27,0),IF($G27=1,IVM!G27,0))","v":0},"MBD",{"$f":"IF($J27=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H27<>0,$D27*($H27-$G27),0),$D27*$H27), 0)","v":0},0,null,0,{"$f":"IF($J27=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H27<>0,$D27*($H27-$G27),0),$D27*$H27),0)","v":592},1710,null,2302,null,0,0,null,0,0,null,2302,12]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28))","v":"Sotavento - Ilha FOGO"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28))","v":"São Filipe"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H28=0,COUNTRY_INFO!$H28=4,COUNTRY_INFO!$H28=99),OR(COUNTRY_INFO!$J28=0,COUNTRY_INFO!$J28=4)),0,COUNTRY_INFO!$E28))","v":1303},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H28=0,COUNTRY_INFO!$H28=4,COUNTRY_INFO!$H28=99),OR(COUNTRY_INFO!$J28=0,COUNTRY_INFO!$J28=4)),0,COUNTRY_INFO!$F28))","v":3768},5071,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P28)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R28)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G28=1,DEC!I28,0),IF($G28=1,IVM!G28,0))","v":0},"MBD",{"$f":"IF($J28=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H28<>0,$D28*($H28-$G28),0),$D28*$H28), 0)","v":0},0,null,0,{"$f":"IF($J28=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H28<>0,$D28*($H28-$G28),0),$D28*$H28),0)","v":1303},3768,null,5071,null,0,0,null,0,0,null,5071,26]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29))","v":"Sotavento - Ilha FOGO"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29))","v":"Santa Catarina do Fogo"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H29=0,COUNTRY_INFO!$H29=4,COUNTRY_INFO!$H29=99),OR(COUNTRY_INFO!$J29=0,COUNTRY_INFO!$J29=4)),0,COUNTRY_INFO!$E29))","v":333},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H29=0,COUNTRY_INFO!$H29=4,COUNTRY_INFO!$H29=99),OR(COUNTRY_INFO!$J29=0,COUNTRY_INFO!$J29=4)),0,COUNTRY_INFO!$F29))","v":963},1296,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P29)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R29)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G29=1,DEC!I29,0),IF($G29=1,IVM!G29,0))","v":0},"MBD",{"$f":"IF($J29=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H29<>0,$D29*($H29-$G29),0),$D29*$H29), 0)","v":0},0,null,0,{"$f":"IF($J29=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H29<>0,$D29*($H29-$G29),0),$D29*$H29),0)","v":333},963,null,1296,null,0,0,null,0,0,null,1296,7]
[{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30))","v":"Cabo Verde"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30))","v":"Sotavento - Ilha BRAVA"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),\" \",IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30))","v":"Brava"},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H30=0,COUNTRY_INFO!$H30=4,COUNTRY_INFO!$H30=99),OR(COUNTRY_INFO!$J30=0,COUNTRY_INFO!$J30=4)),0,COUNTRY_INFO!$E30))","v":346},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,IF(AND(OR(COUNTRY_INFO!$H30=0,COUNTRY_INFO!$H30=4,COUNTRY_INFO!$H30=99),OR(COUNTRY_INFO!$J30=0,COUNTRY_INFO!$J30=4)),0,COUNTRY_INFO!$F30))","v":1000},1346,{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!P30)","v":0},{"$f":"IF(AND(INTRO!$E$37=\"Non endémique\",INTRO!$E$41=\"Non endémique\"),0,COUNTRY_INFO!R30)","v":1},{"$f":"IF(INTRO!$E$39=\"Non endémique\",IF($G30=1,DEC!I30,0),IF($G30=1,IVM!G30,0))","v":0},"MBD",{"$f":"IF($J30=\"ALB\", IF(INTRO!$E$39=\"Non endémique\",IF($H30<>0,$D30*($H30-$G30),0),$D30*$H30), 0)","v":0},0,null,0,{"$f":"IF($J30=\"MBD\", IF(INTRO!$E$39=\"Non endémique\",IF($H30<>0,$D30*($H30-$G30),0),$D30*$H30),0)","v":346},1000,null,1346,null,0,0,null,0,0,null,1346,7]

{"sheet":"PZQ","index":4,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":true,"merged":[[5,12,5,17],[6,6,7,6],[6,8,7,8],[6,9,7,9],[3,0,3,2],[5,0,5,2],[5,3,5,5],[5,8,5,11],[5,6,5,7],[6,10,7,10],[6,17,7,17],[6,13,7,13],[6,14,7,14],[6,15,7,15],[6,11,7,11],[6,12,7,12],[6,16,7,16],[6,4,7,4],[6,5,7,5],[6,7,7,7],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3]]}
["Praziquantel (PZQ)"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":0},{"$f":"SUM(E$9:E$1000)","v":0},{"$f":"SUM(F$9:F$1000)","v":0},null,null,{"$f":"SUM(I$9:I$1000)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Structure administrative du pays",null,null,"Population nécessitant un traitement avec PZQ",null,null,"Plan de traitement",null,"Population cible",null,null,null,"Praziquantel (PZQ)"]
["Pays","Région/Département","District","EAS","Adultes","Total","SCH","Tous EAS ciblés ?","EAS","EAS à un niveau inférieur","Adultes","Total","EAS","Adultes","Total requis\npour EAS","Reste en stock","Comprimés devant être fournis","Flacons (600mg)\n1000 comprimés"]
[]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K9>0, IF(COUNTRY_INFO!$K9=4, 0, IF(COUNTRY_INFO!$K9=1, COUNTRY_INFO!$F9*0.33, IF(COUNTRY_INFO!$K9=2, COUNTRY_INFO!$F9*0.5, COUNTRY_INFO!$F9))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K9>0, IF(COUNTRY_INFO!$K9=4, 0, IF(COUNTRY_INFO!$K9=1, 0, IF(COUNTRY_INFO!$K9=2, COUNTRY_INFO!$G9*0.2, COUNTRY_INFO!$G9))), 0))","v":0},{"$f":"SUM(D9:E9)","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S9)","v":"Non requis"},null,{"$f":"IF($D9=0,0,IF(AND($G9>0,$H9<>\"Oui\"),D9,IF(AND($G9>0,$H9=\"Oui\"),COUNTRY_INFO!$F9,0)))","v":0},null,{"$f":"IF($G9>0,E9, 0)","v":0},{"$f":"IF($J9=0,SUM(I9,K9),SUM(J9,K9))","v":0},{"$f":"IF($J9=0,$I9*2.5,$J9*2.5)","v":0},{"$f":"$K9*3","v":0},{"$f":"M9","v":0},null,{"$f":"IF($O9>$P9,O9-P9,0)","v":0},{"$f":"ROUNDUP($O9/1000,0)","v":0}]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K10>0, IF(COUNTRY_INFO!$K10=4, 0, IF(COUNTRY_INFO!$K10=1, COUNTRY_INFO!$F10*0.33, IF(COUNTRY_INFO!$K10=2, COUNTRY_INFO!$F10*0.5, COUNTRY_INFO!$F10))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K10>0, IF(COUNTRY_INFO!$K10=4, 0, IF(COUNTRY_INFO!$K10=1, 0, IF(COUNTRY_INFO!$K10=2, COUNTRY_INFO!$G10*0.2, COUNTRY_INFO!$G10))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S10)","v":"Non requis"},null,{"$f":"IF($D10=0,0,IF(AND($G10>0,$H10<>\"Oui\"),D10,IF(AND($G10>0,$H10=\"Oui\"),COUNTRY_INFO!$F10,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K11>0, IF(COUNTRY_INFO!$K11=4, 0, IF(COUNTRY_INFO!$K11=1, COUNTRY_INFO!$F11*0.33, IF(COUNTRY_INFO!$K11=2, COUNTRY_INFO!$F11*0.5, COUNTRY_INFO!$F11))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K11>0, IF(COUNTRY_INFO!$K11=4, 0, IF(COUNTRY_INFO!$K11=1, 0, IF(COUNTRY_INFO!$K11=2, COUNTRY_INFO!$G11*0.2, COUNTRY_INFO!$G11))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S11)","v":"Non requis"},null,{"$f":"IF($D11=0,0,IF(AND($G11>0,$H11<>\"Oui\"),D11,IF(AND($G11>0,$H11=\"Oui\"),COUNTRY_INFO!$F11,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K12>0, IF(COUNTRY_INFO!$K12=4, 0, IF(COUNTRY_INFO!$K12=1, COUNTRY_INFO!$F12*0.33, IF(COUNTRY_INFO!$K12=2, COUNTRY_INFO!$F12*0.5, COUNTRY_INFO!$F12))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K12>0, IF(COUNTRY_INFO!$K12=4, 0, IF(COUNTRY_INFO!$K12=1, 0, IF(COUNTRY_INFO!$K12=2, COUNTRY_INFO!$G12*0.2, COUNTRY_INFO!$G12))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S12)","v":"Non requis"},null,{"$f":"IF($D12=0,0,IF(AND($G12>0,$H12<>\"Oui\"),D12,IF(AND($G12>0,$H12=\"Oui\"),COUNTRY_INFO!$F12,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K13>0, IF(COUNTRY_INFO!$K13=4, 0, IF(COUNTRY_INFO!$K13=1, COUNTRY_INFO!$F13*0.33, IF(COUNTRY_INFO!$K13=2, COUNTRY_INFO!$F13*0.5, COUNTRY_INFO!$F13))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K13>0, IF(COUNTRY_INFO!$K13=4, 0, IF(COUNTRY_INFO!$K13=1, 0, IF(COUNTRY_INFO!$K13=2, COUNTRY_INFO!$G13*0.2, COUNTRY_INFO!$G13))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S13)","v":"Non requis"},null,{"$f":"IF($D13=0,0,IF(AND($G13>0,$H13<>\"Oui\"),D13,IF(AND($G13>0,$H13=\"Oui\"),COUNTRY_INFO!$F13,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K14>0, IF(COUNTRY_INFO!$K14=4, 0, IF(COUNTRY_INFO!$K14=1, COUNTRY_INFO!$F14*0.33, IF(COUNTRY_INFO!$K14=2, COUNTRY_INFO!$F14*0.5, COUNTRY_INFO!$F14))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K14>0, IF(COUNTRY_INFO!$K14=4, 0, IF(COUNTRY_INFO!$K14=1, 0, IF(COUNTRY_INFO!$K14=2, COUNTRY_INFO!$G14*0.2, COUNTRY_INFO!$G14))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S14)","v":"Non requis"},null,{"$f":"IF($D14=0,0,IF(AND($G14>0,$H14<>\"Oui\"),D14,IF(AND($G14>0,$H14=\"Oui\"),COUNTRY_INFO!$F14,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K15>0, IF(COUNTRY_INFO!$K15=4, 0, IF(COUNTRY_INFO!$K15=1, COUNTRY_INFO!$F15*0.33, IF(COUNTRY_INFO!$K15=2, COUNTRY_INFO!$F15*0.5, COUNTRY_INFO!$F15))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K15>0, IF(COUNTRY_INFO!$K15=4, 0, IF(COUNTRY_INFO!$K15=1, 0, IF(COUNTRY_INFO!$K15=2, COUNTRY_INFO!$G15*0.2, COUNTRY_INFO!$G15))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S15)","v":"Non requis"},null,{"$f":"IF($D15=0,0,IF(AND($G15>0,$H15<>\"Oui\"),D15,IF(AND($G15>0,$H15=\"Oui\"),COUNTRY_INFO!$F15,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K16>0, IF(COUNTRY_INFO!$K16=4, 0, IF(COUNTRY_INFO!$K16=1, COUNTRY_INFO!$F16*0.33, IF(COUNTRY_INFO!$K16=2, COUNTRY_INFO!$F16*0.5, COUNTRY_INFO!$F16))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K16>0, IF(COUNTRY_INFO!$K16=4, 0, IF(COUNTRY_INFO!$K16=1, 0, IF(COUNTRY_INFO!$K16=2, COUNTRY_INFO!$G16*0.2, COUNTRY_INFO!$G16))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S16)","v":"Non requis"},null,{"$f":"IF($D16=0,0,IF(AND($G16>0,$H16<>\"Oui\"),D16,IF(AND($G16>0,$H16=\"Oui\"),COUNTRY_INFO!$F16,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K17>0, IF(COUNTRY_INFO!$K17=4, 0, IF(COUNTRY_INFO!$K17=1, COUNTRY_INFO!$F17*0.33, IF(COUNTRY_INFO!$K17=2, COUNTRY_INFO!$F17*0.5, COUNTRY_INFO!$F17))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K17>0, IF(COUNTRY_INFO!$K17=4, 0, IF(COUNTRY_INFO!$K17=1, 0, IF(COUNTRY_INFO!$K17=2, COUNTRY_INFO!$G17*0.2, COUNTRY_INFO!$G17))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S17)","v":"Non requis"},null,{"$f":"IF($D17=0,0,IF(AND($G17>0,$H17<>\"Oui\"),D17,IF(AND($G17>0,$H17=\"Oui\"),COUNTRY_INFO!$F17,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K18>0, IF(COUNTRY_INFO!$K18=4, 0, IF(COUNTRY_INFO!$K18=1, COUNTRY_INFO!$F18*0.33, IF(COUNTRY_INFO!$K18=2, COUNTRY_INFO!$F18*0.5, COUNTRY_INFO!$F18))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K18>0, IF(COUNTRY_INFO!$K18=4, 0, IF(COUNTRY_INFO!$K18=1, 0, IF(COUNTRY_INFO!$K18=2, COUNTRY_INFO!$G18*0.2, COUNTRY_INFO!$G18))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S18)","v":"Non requis"},null,{"$f":"IF($D18=0,0,IF(AND($G18>0,$H18<>\"Oui\"),D18,IF(AND($G18>0,$H18=\"Oui\"),COUNTRY_INFO!$F18,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K19>0, IF(COUNTRY_INFO!$K19=4, 0, IF(COUNTRY_INFO!$K19=1, COUNTRY_INFO!$F19*0.33, IF(COUNTRY_INFO!$K19=2, COUNTRY_INFO!$F19*0.5, COUNTRY_INFO!$F19))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K19>0, IF(COUNTRY_INFO!$K19=4, 0, IF(COUNTRY_INFO!$K19=1, 0, IF(COUNTRY_INFO!$K19=2, COUNTRY_INFO!$G19*0.2, COUNTRY_INFO!$G19))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S19)","v":"Non requis"},null,{"$f":"IF($D19=0,0,IF(AND($G19>0,$H19<>\"Oui\"),D19,IF(AND($G19>0,$H19=\"Oui\"),COUNTRY_INFO!$F19,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K20>0, IF(COUNTRY_INFO!$K20=4, 0, IF(COUNTRY_INFO!$K20=1, COUNTRY_INFO!$F20*0.33, IF(COUNTRY_INFO!$K20=2, COUNTRY_INFO!$F20*0.5, COUNTRY_INFO!$F20))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K20>0, IF(COUNTRY_INFO!$K20=4, 0, IF(COUNTRY_INFO!$K20=1, 0, IF(COUNTRY_INFO!$K20=2, COUNTRY_INFO!$G20*0.2, COUNTRY_INFO!$G20))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S20)","v":"Non requis"},null,{"$f":"IF($D20=0,0,IF(AND($G20>0,$H20<>\"Oui\"),D20,IF(AND($G20>0,$H20=\"Oui\"),COUNTRY_INFO!$F20,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K21>0, IF(COUNTRY_INFO!$K21=4, 0, IF(COUNTRY_INFO!$K21=1, COUNTRY_INFO!$F21*0.33, IF(COUNTRY_INFO!$K21=2, COUNTRY_INFO!$F21*0.5, COUNTRY_INFO!$F21))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K21>0, IF(COUNTRY_INFO!$K21=4, 0, IF(COUNTRY_INFO!$K21=1, 0, IF(COUNTRY_INFO!$K21=2, COUNTRY_INFO!$G21*0.2, COUNTRY_INFO!$G21))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S21)","v":"Non requis"},null,{"$f":"IF($D21=0,0,IF(AND($G21>0,$H21<>\"Oui\"),D21,IF(AND($G21>0,$H21=\"Oui\"),COUNTRY_INFO!$F21,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K22>0, IF(COUNTRY_INFO!$K22=4, 0, IF(COUNTRY_INFO!$K22=1, COUNTRY_INFO!$F22*0.33, IF(COUNTRY_INFO!$K22=2, COUNTRY_INFO!$F22*0.5, COUNTRY_INFO!$F22))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K22>0, IF(COUNTRY_INFO!$K22=4, 0, IF(COUNTRY_INFO!$K22=1, 0, IF(COUNTRY_INFO!$K22=2, COUNTRY_INFO!$G22*0.2, COUNTRY_INFO!$G22))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S22)","v":"Non requis"},null,{"$f":"IF($D22=0,0,IF(AND($G22>0,$H22<>\"Oui\"),D22,IF(AND($G22>0,$H22=\"Oui\"),COUNTRY_INFO!$F22,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K23>0, IF(COUNTRY_INFO!$K23=4, 0, IF(COUNTRY_INFO!$K23=1, COUNTRY_INFO!$F23*0.33, IF(COUNTRY_INFO!$K23=2, COUNTRY_INFO!$F23*0.5, COUNTRY_INFO!$F23))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K23>0, IF(COUNTRY_INFO!$K23=4, 0, IF(COUNTRY_INFO!$K23=1, 0, IF(COUNTRY_INFO!$K23=2, COUNTRY_INFO!$G23*0.2, COUNTRY_INFO!$G23))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S23)","v":"Non requis"},null,{"$f":"IF($D23=0,0,IF(AND($G23>0,$H23<>\"Oui\"),D23,IF(AND($G23>0,$H23=\"Oui\"),COUNTRY_INFO!$F23,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K24>0, IF(COUNTRY_INFO!$K24=4, 0, IF(COUNTRY_INFO!$K24=1, COUNTRY_INFO!$F24*0.33, IF(COUNTRY_INFO!$K24=2, COUNTRY_INFO!$F24*0.5, COUNTRY_INFO!$F24))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K24>0, IF(COUNTRY_INFO!$K24=4, 0, IF(COUNTRY_INFO!$K24=1, 0, IF(COUNTRY_INFO!$K24=2, COUNTRY_INFO!$G24*0.2, COUNTRY_INFO!$G24))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S24)","v":"Non requis"},null,{"$f":"IF($D24=0,0,IF(AND($G24>0,$H24<>\"Oui\"),D24,IF(AND($G24>0,$H24=\"Oui\"),COUNTRY_INFO!$F24,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K25>0, IF(COUNTRY_INFO!$K25=4, 0, IF(COUNTRY_INFO!$K25=1, COUNTRY_INFO!$F25*0.33, IF(COUNTRY_INFO!$K25=2, COUNTRY_INFO!$F25*0.5, COUNTRY_INFO!$F25))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K25>0, IF(COUNTRY_INFO!$K25=4, 0, IF(COUNTRY_INFO!$K25=1, 0, IF(COUNTRY_INFO!$K25=2, COUNTRY_INFO!$G25*0.2, COUNTRY_INFO!$G25))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S25)","v":"Non requis"},null,{"$f":"IF($D25=0,0,IF(AND($G25>0,$H25<>\"Oui\"),D25,IF(AND($G25>0,$H25=\"Oui\"),COUNTRY_INFO!$F25,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K26>0, IF(COUNTRY_INFO!$K26=4, 0, IF(COUNTRY_INFO!$K26=1, COUNTRY_INFO!$F26*0.33, IF(COUNTRY_INFO!$K26=2, COUNTRY_INFO!$F26*0.5, COUNTRY_INFO!$F26))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K26>0, IF(COUNTRY_INFO!$K26=4, 0, IF(COUNTRY_INFO!$K26=1, 0, IF(COUNTRY_INFO!$K26=2, COUNTRY_INFO!$G26*0.2, COUNTRY_INFO!$G26))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S26)","v":"Non requis"},null,{"$f":"IF($D26=0,0,IF(AND($G26>0,$H26<>\"Oui\"),D26,IF(AND($G26>0,$H26=\"Oui\"),COUNTRY_INFO!$F26,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K27>0, IF(COUNTRY_INFO!$K27=4, 0, IF(COUNTRY_INFO!$K27=1, COUNTRY_INFO!$F27*0.33, IF(COUNTRY_INFO!$K27=2, COUNTRY_INFO!$F27*0.5, COUNTRY_INFO!$F27))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K27>0, IF(COUNTRY_INFO!$K27=4, 0, IF(COUNTRY_INFO!$K27=1, 0, IF(COUNTRY_INFO!$K27=2, COUNTRY_INFO!$G27*0.2, COUNTRY_INFO!$G27))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S27)","v":"Non requis"},null,{"$f":"IF($D27=0,0,IF(AND($G27>0,$H27<>\"Oui\"),D27,IF(AND($G27>0,$H27=\"Oui\"),COUNTRY_INFO!$F27,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K28>0, IF(COUNTRY_INFO!$K28=4, 0, IF(COUNTRY_INFO!$K28=1, COUNTRY_INFO!$F28*0.33, IF(COUNTRY_INFO!$K28=2, COUNTRY_INFO!$F28*0.5, COUNTRY_INFO!$F28))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K28>0, IF(COUNTRY_INFO!$K28=4, 0, IF(COUNTRY_INFO!$K28=1, 0, IF(COUNTRY_INFO!$K28=2, COUNTRY_INFO!$G28*0.2, COUNTRY_INFO!$G28))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S28)","v":"Non requis"},null,{"$f":"IF($D28=0,0,IF(AND($G28>0,$H28<>\"Oui\"),D28,IF(AND($G28>0,$H28=\"Oui\"),COUNTRY_INFO!$F28,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K29>0, IF(COUNTRY_INFO!$K29=4, 0, IF(COUNTRY_INFO!$K29=1, COUNTRY_INFO!$F29*0.33, IF(COUNTRY_INFO!$K29=2, COUNTRY_INFO!$F29*0.5, COUNTRY_INFO!$F29))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K29>0, IF(COUNTRY_INFO!$K29=4, 0, IF(COUNTRY_INFO!$K29=1, 0, IF(COUNTRY_INFO!$K29=2, COUNTRY_INFO!$G29*0.2, COUNTRY_INFO!$G29))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S29)","v":"Non requis"},null,{"$f":"IF($D29=0,0,IF(AND($G29>0,$H29<>\"Oui\"),D29,IF(AND($G29>0,$H29=\"Oui\"),COUNTRY_INFO!$F29,0)))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\",\" \", IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30))","v":" "},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K30>0, IF(COUNTRY_INFO!$K30=4, 0, IF(COUNTRY_INFO!$K30=1, COUNTRY_INFO!$F30*0.33, IF(COUNTRY_INFO!$K30=2, COUNTRY_INFO!$F30*0.5, COUNTRY_INFO!$F30))), 0))","v":0},{"$f":"IF(INTRO!$E$43=\"Non endémique\", 0, IF(COUNTRY_INFO!$K30>0, IF(COUNTRY_INFO!$K30=4, 0, IF(COUNTRY_INFO!$K30=1, 0, IF(COUNTRY_INFO!$K30=2, COUNTRY_INFO!$G30*0.2, COUNTRY_INFO!$G30))), 0))","v":0},0,{"$f":"IF(INTRO!$E$43=\"Non endémique\", \"Non requis\", COUNTRY_INFO!S30)","v":"Non requis"},null,{"$f":"IF($D30=0,0,IF(AND($G30>0,$H30<>\"Oui\"),D30,IF(AND($G30>0,$H30=\"Oui\"),COUNTRY_INFO!$F30,0)))","v":0},null,0,0,0,0,0,null,0,0]

{"sheet":"IVM","index":5,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":true,"merged":[[5,10,5,16],[6,15,7,15],[6,16,7,16],[6,14,7,14],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[5,0,5,2],[5,4,5,5],[5,6,5,9],[6,6,7,6],[3,0,3,2],[3,4,3,5],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,7,6,9]]}
["Ivermectine (IVM)"]
["Structure administrative, population ciblée par groupe d'âge, plan de traitement et information sur les comprimés"]
[]
["TOTAL",null,null,{"$f":"SUM(D$9:D$1000)","v":0},null,null,{"$f":"SUM(G$9:G$1000)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Structure administrative du pays",null,null,null,"Plan de traitement",null,"Population cible",null,null,null,"Ivermectine (IVM)"]
["Pays","Région/Département","District","Population nécessitant un traitement avec IVM","FL","Oncho","FL","Oncho",null,null,"FL uniquement","Oncho uniquement","FL+Oncho","Total requis","Reste en stock","Comprimés devant être fournis","Flacons (3mg)\n500 comprimés"]
[null,null,null,null,null,null,null,"dans le district","dans les village","total"]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A9=0,\" \",COUNTRY_INFO!A9))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B9=0,\" \",COUNTRY_INFO!B9))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C9=0,\" \",COUNTRY_INFO!C9))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H9=1,COUNTRY_INFO!F9+COUNTRY_INFO!G9,0),IF(COUNTRY_INFO!$H9=1,COUNTRY_INFO!F9+COUNTRY_INFO!G9,IF(COUNTRY_INFO!$I9=1,IF(COUNTRY_INFO!M9>=(COUNTRY_INFO!F9+COUNTRY_INFO!G9),COUNTRY_INFO!F9+COUNTRY_INFO!G9,COUNTRY_INFO!$M9),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!P9))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q9,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H9=1, IF($E9=1,$D9, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I9=1,$F9<>0),IF(COUNTRY_INFO!M9>=(COUNTRY_INFO!F9+COUNTRY_INFO!G9),COUNTRY_INFO!F9+COUNTRY_INFO!G9,COUNTRY_INFO!$M9), 0))","v":0},null,{"$f":"IF(I9=0,H9,IF(I9>H9,H9,I9))","v":0},{"$f":"IF(G9<J9,0,IF($E9=1, (G9-J9)*2.8, 0))","v":0},{"$f":"IF($E9<$F9, J9*(F9-E9)*2.8, 0)","v":0},{"$f":"IF(AND($E9=1, $F9<>0), J9*2.8, 0)","v":0},{"$f":"SUM(K9:M9)","v":0},null,{"$f":"IF($N9>$O9,$N9-$O9,0)","v":0},{"$f":"ROUNDUP($N9/500,0)","v":0}]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A10=0,\" \",COUNTRY_INFO!A10))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B10=0,\" \",COUNTRY_INFO!B10))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C10=0,\" \",COUNTRY_INFO!C10))","v":" "},{"$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!P10))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q10,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H10=1, IF($E10=1,$D10, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I10=1,$F10<>0),IF(COUNTRY_INFO!M10>=(COUNTRY_INFO!F10+COUNTRY_INFO!G10),COUNTRY_INFO!F10+COUNTRY_INFO!G10,COUNTRY_INFO!$M10), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A11=0,\" \",COUNTRY_INFO!A11))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B11=0,\" \",COUNTRY_INFO!B11))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C11=0,\" \",COUNTRY_INFO!C11))","v":" "},{"$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":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!P11))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q11,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H11=1, IF($E11=1,$D11, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I11=1,$F11<>0),IF(COUNTRY_INFO!M11>=(COUNTRY_INFO!F11+COUNTRY_INFO!G11),COUNTRY_INFO!F11+COUNTRY_INFO!G11,COUNTRY_INFO!$M11), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A12=0,\" \",COUNTRY_INFO!A12))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B12=0,\" \",COUNTRY_INFO!B12))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C12=0,\" \",COUNTRY_INFO!C12))","v":" "},{"$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!P12))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q12,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H12=1, IF($E12=1,$D12, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I12=1,$F12<>0),IF(COUNTRY_INFO!M12>=(COUNTRY_INFO!F12+COUNTRY_INFO!G12),COUNTRY_INFO!F12+COUNTRY_INFO!G12,COUNTRY_INFO!$M12), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A13=0,\" \",COUNTRY_INFO!A13))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B13=0,\" \",COUNTRY_INFO!B13))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C13=0,\" \",COUNTRY_INFO!C13))","v":" "},{"$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!P13))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q13,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H13=1, IF($E13=1,$D13, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I13=1,$F13<>0),IF(COUNTRY_INFO!M13>=(COUNTRY_INFO!F13+COUNTRY_INFO!G13),COUNTRY_INFO!F13+COUNTRY_INFO!G13,COUNTRY_INFO!$M13), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A14=0,\" \",COUNTRY_INFO!A14))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B14=0,\" \",COUNTRY_INFO!B14))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C14=0,\" \",COUNTRY_INFO!C14))","v":" "},{"$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":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!P14))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q14,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H14=1, IF($E14=1,$D14, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I14=1,$F14<>0),IF(COUNTRY_INFO!M14>=(COUNTRY_INFO!F14+COUNTRY_INFO!G14),COUNTRY_INFO!F14+COUNTRY_INFO!G14,COUNTRY_INFO!$M14), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A15=0,\" \",COUNTRY_INFO!A15))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B15=0,\" \",COUNTRY_INFO!B15))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C15=0,\" \",COUNTRY_INFO!C15))","v":" "},{"$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":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!P15))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q15,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H15=1, IF($E15=1,$D15, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I15=1,$F15<>0),IF(COUNTRY_INFO!M15>=(COUNTRY_INFO!F15+COUNTRY_INFO!G15),COUNTRY_INFO!F15+COUNTRY_INFO!G15,COUNTRY_INFO!$M15), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A16=0,\" \",COUNTRY_INFO!A16))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B16=0,\" \",COUNTRY_INFO!B16))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C16=0,\" \",COUNTRY_INFO!C16))","v":" "},{"$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":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!P16))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q16,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H16=1, IF($E16=1,$D16, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I16=1,$F16<>0),IF(COUNTRY_INFO!M16>=(COUNTRY_INFO!F16+COUNTRY_INFO!G16),COUNTRY_INFO!F16+COUNTRY_INFO!G16,COUNTRY_INFO!$M16), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A17=0,\" \",COUNTRY_INFO!A17))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B17=0,\" \",COUNTRY_INFO!B17))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C17=0,\" \",COUNTRY_INFO!C17))","v":" "},{"$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":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!P17))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q17,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H17=1, IF($E17=1,$D17, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I17=1,$F17<>0),IF(COUNTRY_INFO!M17>=(COUNTRY_INFO!F17+COUNTRY_INFO!G17),COUNTRY_INFO!F17+COUNTRY_INFO!G17,COUNTRY_INFO!$M17), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A18=0,\" \",COUNTRY_INFO!A18))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B18=0,\" \",COUNTRY_INFO!B18))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C18=0,\" \",COUNTRY_INFO!C18))","v":" "},{"$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":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!P18))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q18,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H18=1, IF($E18=1,$D18, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I18=1,$F18<>0),IF(COUNTRY_INFO!M18>=(COUNTRY_INFO!F18+COUNTRY_INFO!G18),COUNTRY_INFO!F18+COUNTRY_INFO!G18,COUNTRY_INFO!$M18), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A19=0,\" \",COUNTRY_INFO!A19))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B19=0,\" \",COUNTRY_INFO!B19))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C19=0,\" \",COUNTRY_INFO!C19))","v":" "},{"$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":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!P19))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q19,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H19=1, IF($E19=1,$D19, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I19=1,$F19<>0),IF(COUNTRY_INFO!M19>=(COUNTRY_INFO!F19+COUNTRY_INFO!G19),COUNTRY_INFO!F19+COUNTRY_INFO!G19,COUNTRY_INFO!$M19), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A20=0,\" \",COUNTRY_INFO!A20))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B20=0,\" \",COUNTRY_INFO!B20))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C20=0,\" \",COUNTRY_INFO!C20))","v":" "},{"$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":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!P20))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q20,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H20=1, IF($E20=1,$D20, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I20=1,$F20<>0),IF(COUNTRY_INFO!M20>=(COUNTRY_INFO!F20+COUNTRY_INFO!G20),COUNTRY_INFO!F20+COUNTRY_INFO!G20,COUNTRY_INFO!$M20), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A21=0,\" \",COUNTRY_INFO!A21))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B21=0,\" \",COUNTRY_INFO!B21))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C21=0,\" \",COUNTRY_INFO!C21))","v":" "},{"$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":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!P21))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q21,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H21=1, IF($E21=1,$D21, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I21=1,$F21<>0),IF(COUNTRY_INFO!M21>=(COUNTRY_INFO!F21+COUNTRY_INFO!G21),COUNTRY_INFO!F21+COUNTRY_INFO!G21,COUNTRY_INFO!$M21), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A22=0,\" \",COUNTRY_INFO!A22))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B22=0,\" \",COUNTRY_INFO!B22))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C22=0,\" \",COUNTRY_INFO!C22))","v":" "},{"$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":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!P22))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q22,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H22=1, IF($E22=1,$D22, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I22=1,$F22<>0),IF(COUNTRY_INFO!M22>=(COUNTRY_INFO!F22+COUNTRY_INFO!G22),COUNTRY_INFO!F22+COUNTRY_INFO!G22,COUNTRY_INFO!$M22), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A23=0,\" \",COUNTRY_INFO!A23))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B23=0,\" \",COUNTRY_INFO!B23))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C23=0,\" \",COUNTRY_INFO!C23))","v":" "},{"$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":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!P23))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q23,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H23=1, IF($E23=1,$D23, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I23=1,$F23<>0),IF(COUNTRY_INFO!M23>=(COUNTRY_INFO!F23+COUNTRY_INFO!G23),COUNTRY_INFO!F23+COUNTRY_INFO!G23,COUNTRY_INFO!$M23), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A24=0,\" \",COUNTRY_INFO!A24))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B24=0,\" \",COUNTRY_INFO!B24))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C24=0,\" \",COUNTRY_INFO!C24))","v":" "},{"$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":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!P24))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q24,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H24=1, IF($E24=1,$D24, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I24=1,$F24<>0),IF(COUNTRY_INFO!M24>=(COUNTRY_INFO!F24+COUNTRY_INFO!G24),COUNTRY_INFO!F24+COUNTRY_INFO!G24,COUNTRY_INFO!$M24), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A25=0,\" \",COUNTRY_INFO!A25))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B25=0,\" \",COUNTRY_INFO!B25))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C25=0,\" \",COUNTRY_INFO!C25))","v":" "},{"$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":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!P25))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q25,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H25=1, IF($E25=1,$D25, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I25=1,$F25<>0),IF(COUNTRY_INFO!M25>=(COUNTRY_INFO!F25+COUNTRY_INFO!G25),COUNTRY_INFO!F25+COUNTRY_INFO!G25,COUNTRY_INFO!$M25), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A26=0,\" \",COUNTRY_INFO!A26))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B26=0,\" \",COUNTRY_INFO!B26))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C26=0,\" \",COUNTRY_INFO!C26))","v":" "},{"$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":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!P26))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q26,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H26=1, IF($E26=1,$D26, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I26=1,$F26<>0),IF(COUNTRY_INFO!M26>=(COUNTRY_INFO!F26+COUNTRY_INFO!G26),COUNTRY_INFO!F26+COUNTRY_INFO!G26,COUNTRY_INFO!$M26), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A27=0,\" \",COUNTRY_INFO!A27))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B27=0,\" \",COUNTRY_INFO!B27))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C27=0,\" \",COUNTRY_INFO!C27))","v":" "},{"$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":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!P27))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q27,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H27=1, IF($E27=1,$D27, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I27=1,$F27<>0),IF(COUNTRY_INFO!M27>=(COUNTRY_INFO!F27+COUNTRY_INFO!G27),COUNTRY_INFO!F27+COUNTRY_INFO!G27,COUNTRY_INFO!$M27), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A28=0,\" \",COUNTRY_INFO!A28))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B28=0,\" \",COUNTRY_INFO!B28))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C28=0,\" \",COUNTRY_INFO!C28))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H28=1,COUNTRY_INFO!F28+COUNTRY_INFO!G28,0),IF(COUNTRY_INFO!$H28=1,COUNTRY_INFO!F28+COUNTRY_INFO!G28,IF(COUNTRY_INFO!$I28=1,IF(COUNTRY_INFO!M28>=(COUNTRY_INFO!F28+COUNTRY_INFO!G28),COUNTRY_INFO!F28+COUNTRY_INFO!G28,COUNTRY_INFO!$M28),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!P28))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q28,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H28=1, IF($E28=1,$D28, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I28=1,$F28<>0),IF(COUNTRY_INFO!M28>=(COUNTRY_INFO!F28+COUNTRY_INFO!G28),COUNTRY_INFO!F28+COUNTRY_INFO!G28,COUNTRY_INFO!$M28), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A29=0,\" \",COUNTRY_INFO!A29))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B29=0,\" \",COUNTRY_INFO!B29))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C29=0,\" \",COUNTRY_INFO!C29))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H29=1,COUNTRY_INFO!F29+COUNTRY_INFO!G29,0),IF(COUNTRY_INFO!$H29=1,COUNTRY_INFO!F29+COUNTRY_INFO!G29,IF(COUNTRY_INFO!$I29=1,IF(COUNTRY_INFO!M29>=(COUNTRY_INFO!F29+COUNTRY_INFO!G29),COUNTRY_INFO!F29+COUNTRY_INFO!G29,COUNTRY_INFO!$M29),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!P29))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q29,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H29=1, IF($E29=1,$D29, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I29=1,$F29<>0),IF(COUNTRY_INFO!M29>=(COUNTRY_INFO!F29+COUNTRY_INFO!G29),COUNTRY_INFO!F29+COUNTRY_INFO!G29,COUNTRY_INFO!$M29), 0))","v":0},null,0,0,0,0,0,null,0,0]
[{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!A30=0,\" \",COUNTRY_INFO!A30))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!B30=0,\" \",COUNTRY_INFO!B30))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",\" \",IF(COUNTRY_INFO!C30=0,\" \",COUNTRY_INFO!C30))","v":" "},{"$f":"IF(INTRO!$E$39=\"Non endémique\",0,IF(INTRO!$E$39=\"Endémique mais pas de CP\",IF(COUNTRY_INFO!$H30=1,COUNTRY_INFO!F30+COUNTRY_INFO!G30,0),IF(COUNTRY_INFO!$H30=1,COUNTRY_INFO!F30+COUNTRY_INFO!G30,IF(COUNTRY_INFO!$I30=1,IF(COUNTRY_INFO!M30>=(COUNTRY_INFO!F30+COUNTRY_INFO!G30),COUNTRY_INFO!F30+COUNTRY_INFO!G30,COUNTRY_INFO!$M30),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!P30))","v":"Non requis"},{"$f":"IF(INTRO!$E$39<>\"Non endémique\",COUNTRY_INFO!Q30,\"Non requis\")","v":"Non requis"},{"$f":"IF(COUNTRY_INFO!H30=1, IF($E30=1,$D30, 0),0)","v":0},{"$f":"IF(INTRO!$E$39<>\"Endémique\",0, IF(AND(COUNTRY_INFO!$I30=1,$F30<>0),IF(COUNTRY_INFO!M30>=(COUNTRY_INFO!F30+COUNTRY_INFO!G30),COUNTRY_INFO!F30+COUNTRY_INFO!G30,COUNTRY_INFO!$M30), 0))","v":0},null,0,0,0,0,0,null,0,0]

{"sheet":"SUMMARY","index":6,"n_rows":93,"n_cols":8,"rows_kept":93,"cut":false,"hidden":false,"merged":[[86,1,86,7],[77,2,77,3],[77,4,77,5],[69,1,69,7],[83,1,83,2],[73,2,73,3],[73,4,73,5],[84,3,84,7],[84,1,84,2],[81,1,81,7],[83,3,83,7],[82,1,82,7],[21,2,24,5],[25,1,25,7],[53,1,53,7],[75,2,75,3],[75,4,75,5],[46,5,46,6],[47,5,47,6],[58,1,58,7],[54,1,54,7],[66,4,66,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[30,6,30,7],[42,5,42,6],[30,2,30,3],[68,1,68,7],[76,4,76,5],[43,5,43,6],[44,5,44,6],[45,5,45,6],[65,4,65,6],[40,5,40,6],[41,5,41,6],[60,1,60,7],[63,4,63,6],[64,4,64,6],[62,4,62,6],[9,1,10,1],[9,2,9,5],[9,6,9,7],[5,2,5,5],[92,1,92,7],[87,1,87,7],[91,1,91,7],[57,1,57,7],[30,4,30,5],[56,1,56,7],[76,2,76,3],[38,1,38,7],[79,1,79,7],[80,1,80,7],[6,1,6,7],[55,1,55,7],[0,1,0,7],[1,1,1,7],[2,1,2,5],[3,1,3,7],[4,1,4,7]]}
[]
[null,"Formulaire de demande commune de médicaments pour CP v.3.1"]
[]
[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":"Cabo Verde"},null,null,null,"Année",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2020}]
[]
[null,"Informations concernant les médicaments CP demandés à l’OMS"]
[]
[null,"Le médicament","Nombre de comprimés",null,null,null,"Nombre total de flacons"]
[null,null,"Requis","En stock","En cours de demande","Demandés","Requis","Demandés"]
[null,"Mebendazole (EAS)",103020,14003,null,{"$f":"IF(C12>(D12+E12),C12-D12-E12, 0)","v":89017},{"$f":"IF($C12=0,0, IF($B12=\"Albendazole pour FL\", IF($C12=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C12/200,0)), IF($B12=\"Albendazole pour STH (EAS)\", IF($C12=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C12/200,0)), IF($B12=\"Mebendazole (EAS)\", IF($C12=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C12/150,0)), IF($B12=\"Diethylcarbamazine\", IF($C12=DEC!$J$4,DEC!$M$4,ROUNDUP($C12/1000,0)), IF($B12=\"Praziquantel (EAS)\", IF($C12=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C12/1000,0)), IF($B12=\"Ivermectine\", IF($C12=IVM!$N$4,IVM!$Q$4,$C12/500+0.49),0)))))))","v":697},{"$f":"IF($F12=0,0,IF(OR($B12=\"Albendazole pour FL\",$B12=\"Albendazole pour STH (EAS)\"),$G12-ROUNDUP(($E12+$D12)/200,0),IF($B12=\"Ivermectine\",$G12-ROUNDUP(($E12+$D12)/500,0),IF($B12=\"Mebendazole (EAS)\",$G12-ROUNDUP(($E12+$D12)/150,0),$G12-ROUNDUP(($E12+$D12)/1000,0)))))","v":603}]
[null,null,0,0,null,0,{"$f":"IF($C13=0,0, IF($B13=\"Albendazole pour FL\", IF($C13=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C13/200,0)), IF($B13=\"Albendazole pour STH (EAS)\", IF($C13=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C13/200,0)), IF($B13=\"Mebendazole (EAS)\", IF($C13=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C13/150,0)), IF($B13=\"Diethylcarbamazine\", IF($C13=DEC!$J$4,DEC!$M$4,ROUNDUP($C13/1000,0)), IF($B13=\"Praziquantel (EAS)\", IF($C13=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C13/1000,0)), IF($B13=\"Ivermectine\", IF($C13=IVM!$N$4,IVM!$Q$4,$C13/500+0.49),0)))))))","v":0},0]
[null,null,0,0,null,0,{"$f":"IF($C14=0,0, IF($B14=\"Albendazole pour FL\", IF($C14=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C14/200,0)), IF($B14=\"Albendazole pour STH (EAS)\", IF($C14=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C14/200,0)), IF($B14=\"Mebendazole (EAS)\", IF($C14=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C14/150,0)), IF($B14=\"Diethylcarbamazine\", IF($C14=DEC!$J$4,DEC!$M$4,ROUNDUP($C14/1000,0)), IF($B14=\"Praziquantel (EAS)\", IF($C14=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C14/1000,0)), IF($B14=\"Ivermectine\", IF($C14=IVM!$N$4,IVM!$Q$4,$C14/500+0.49),0)))))))","v":0},0]
[null,null,0,0,null,0,{"$f":"IF($C15=0,0, IF($B15=\"Albendazole pour FL\", IF($C15=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C15/200,0)), IF($B15=\"Albendazole pour STH (EAS)\", IF($C15=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C15/200,0)), IF($B15=\"Mebendazole (EAS)\", IF($C15=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C15/150,0)), IF($B15=\"Diethylcarbamazine\", IF($C15=DEC!$J$4,DEC!$M$4,ROUNDUP($C15/1000,0)), IF($B15=\"Praziquantel (EAS)\", IF($C15=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C15/1000,0)), IF($B15=\"Ivermectine\", IF($C15=IVM!$N$4,IVM!$Q$4,$C15/500+0.49),0)))))))","v":0},0]
[null,null,0,0,null,0,{"$f":"IF($C16=0,0, IF($B16=\"Albendazole pour FL\", IF($C16=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C16/200,0)), IF($B16=\"Albendazole pour STH (EAS)\", IF($C16=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C16/200,0)), IF($B16=\"Mebendazole (EAS)\", IF($C16=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C16/150,0)), IF($B16=\"Diethylcarbamazine\", IF($C16=DEC!$J$4,DEC!$M$4,ROUNDUP($C16/1000,0)), IF($B16=\"Praziquantel (EAS)\", IF($C16=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C16/1000,0)), IF($B16=\"Ivermectine\", IF($C16=IVM!$N$4,IVM!$Q$4,$C16/500+0.49),0)))))))","v":0},0]
[null,null,0,0,null,0,{"$f":"IF($C17=0,0, IF($B17=\"Albendazole pour FL\", IF($C17=ALB_MBD!$I$4,ALB_MBD!$U$4,ROUNDUP($C17/200,0)), IF($B17=\"Albendazole pour STH (EAS)\", IF($C17=ALB_MBD!$L$4,ALB_MBD!$X$4,ROUNDUP($C17/200,0)), IF($B17=\"Mebendazole (EAS)\", IF($C17=ALB_MBD!$P$4,ALB_MBD!$AA$4,ROUNDUP($C17/150,0)), IF($B17=\"Diethylcarbamazine\", IF($C17=DEC!$J$4,DEC!$M$4,ROUNDUP($C17/1000,0)), IF($B17=\"Praziquantel (EAS)\", IF($C17=PZQ!$O$4,PZQ!$R$4,ROUNDUP($C17/1000,0)), IF($B17=\"Ivermectine\", IF($C17=IVM!$N$4,IVM!$Q$4,$C17/500+0.49),0)))))))","v":0},0]
[]
[null,"Nombre de personnes devant être traitées avec le médicament donné"]
[]
[null,"Veuillez sélectionner la maladie",null,null,null,null,"1er tour","2ème tour"]
[null,"Géohelminthiases","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,null,103020,0]
[null,null,null,null,null,null," "," "]
[null,null,null,null,null,null," "," "]
[null,null,null,null,null,null," "," "]
[]
[]
[]
[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,"Mebendazole (EAS)","Novembre",2020,null,null,"Juillet",2020]
[]
[]
[]
[]
[]
[]
[null,"Informations sur les médicaments de chimiothérapie préventive pour le traitement de populations non ciblées par la donation en cours via l’OMS"]
[]
[null,"Le médicament","Groupe d'âge","# de personnes","# de comprimés","Source",null,"Statut"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,{"$f":"B22","v":"Géohelminthiases"},{"$f":"SUM(G22:H22)","v":103020},null,"Gouvernement, UNICEF, OMS"]
[null,{"$f":"B23","v":0},{"$f":"SUM(G23:H23)","v":0}]
[null,{"$f":"B24","v":0},{"$f":"SUM(G24:H24)","v":0}]
[null,{"$f":"B25","v":0},{"$f":"SUM(G25:H25)","v":0}]
[]
[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","Irina Spencer",null,2617023,null,"irina.spencer@ms.gov.cv","2020-06-30"]
[]
[]
[]
[]
[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,"         J’ai pris connaissance et accepté la politique de la communication de données de l’OMS"]
[null,"Nom et signature \ndu Coordonnateur MTN ou du \nReprésentant du Ministère de la Santé",null,"Irina Spencer"]
[null,"Date",null,"2020-06-30"]
[]
[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":7,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,1,35,7],[47,1,57,7],[45,1,45,7],[30,2,30,4],[30,5,30,7],[31,2,31,4],[31,5,31,7],[32,2,32,4],[32,5,32,7],[36,1,36,6],[37,1,37,5],[39,1,39,7],[40,1,40,6],[38,1,38,6],[41,1,41,6],[42,1,42,7],[28,2,28,4],[28,5,28,7],[29,2,29,4],[29,5,29,7],[27,2,27,4],[27,5,27,7],[13,5,13,7],[17,5,17,7],[26,2,26,4],[20,2,20,4],[20,5,20,7],[26,5,26,7],[21,5,21,7],[18,5,18,7],[19,2,19,4],[19,5,19,7],[23,2,23,4],[21,2,21,4],[17,2,17,4],[25,2,25,4],[25,5,25,7],[18,2,18,4],[0,1,0,7],[1,1,1,7],[2,1,2,5],[12,2,12,4],[15,1,15,7],[14,2,14,4],[14,5,14,7],[12,5,12,7],[13,2,13,4],[11,5,11,7],[11,2,11,4],[6,1,6,7],[9,2,9,4],[7,2,7,4],[7,5,7,7],[8,2,8,4],[9,5,9,7],[10,2,10,4],[10,5,10,7],[3,2,3,5],[4,1,4,7],[8,5,8,7],[23,5,23,7],[16,2,16,4],[16,5,16,7],[22,2,22,4],[22,5,22,7]]}
[]
[null,"Formulaire de demande commune de médicaments pour CP v.3.1"]
[]
[null,"Pays",{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Cabo Verde"},null,null,null,"Année",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2020}]
[]
[null,"Informations sur l'envoi et le destinataire "]
[]
[null,null,"Destinataire",null,null,"Destinataire final\nsi différent du destinaire précédent"]
[null,"Nom","Hernando AGUDELO",null,null,"Bruno Santos"]
[null,"Département/Unité","WR",null,null,"Diretor do Gabinete de Assuntos Farmacéuticos"]
[null,"Organisation","OMS, Cabo Verde",null,null,"Ministério da Saúde"]
[null,"Téléphone","(238) 2601900 / 2601901",null,null,"(238) 2610172 / 5163015"]
[null,"Fax","(238) 2621408"]
[null,"E-mail","agudeloh@who.int; empereira@who.int",null,null,"bruno.santos@ms.gov.cv"]
[null,"Adresse postale","C.P. 266, Praia, Cabo Verde",null,null," Palacio do Governo Av. Cidade LisboaCP 47"]
[]
[null,null,"Destinataire",null,null,"Destinataire final\nsi différent du destinaire précédent"]
[null,"Nom"]
[null,"Département/Unité"]
[null,"Organisation"]
[null,"Téléphone"]
[null,"Fax"]
[null,"E-mail"]
[null,"Adresse postale"]
[]
[null,null,"Destinataire",null,null,"Destinataire final\nsi différent du destinaire précédent"]
[null,"Nom"]
[null,"Département/Unité"]
[null,"Organisation"]
[null,"Téléphone"]
[null,"Fax"]
[null,"E-mail"]
[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,"15 JOURS "]
[null,"Avez vous besoin que certains documents soient remis en même temps que la demande de permis d’importation?"]
[null,"Si oui, merci de bien vouloir spécifier lesquels ici"]
[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,"Oui"]
[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,"Si oui, merci de bien vouloir spécifier lesquels ici"]
[]
[]
[null,"Remarques supplémentaires éventuelles liées à cette requête"]

{"sheet":"DATA_POLICY","index":8,"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.3.1"]
[]
[null,"Pays",null,{"$f":"IF(INTRO!$E$33<>0,INTRO!$E$33,\" \")","v":"Cabo Verde"},null,null,"Année",{"$f":"IF(INTRO!$E$35<>0,INTRO!$E$35,\" \")","v":2020}]
[]
[]
[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 Cabo Verde, 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 Cabo Verde:"}]
[]
[]
[]
[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 Cabo Verde 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."}]