{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Listes","Sheet1","Analyse infranationale","Budget bailleurs de fonds","Plan National Riposte Covid19"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":17,"comments":1,"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":"Listes","index":0,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["Listes"]
[]
[]
[]
[null,"Cartographie des ressources et catégories de suivi - Bailleurs de fonds"]
[]
[null,null,"Programme","Abbrév.",null,"Sous Programme","Abbrév.",null,"Sous Programme","Action"]
[null,1,"1. Amélioration de la gouvernance et du leadership ","Programme 1",null,"1.1 : Pilotage, dialogue et coordination des actions et des partenaires du MSP","Sous Programme 1.1",null,"1.1 : Pilotage, dialogue et coordination des actions et des partenaires du MSP","1.1.1 : Promouvoir un dialogue politique multisectoriel en faveur du secteur de la santé"]
[null,2,"2. Accès aux soins et services de santé","Programme 2",null,"1.2 : Réformes sectorielles y compris la décentralisation","Sous Programme 1.2",null,"1.1 : Pilotage, dialogue et coordination des actions et des partenaires du MSP","1.1.2 : Renforcer la coordination des actions et des partenaires "]
[null,3,"3. Prestations des soins et services de santé","Programme 3",null,"1.3 : Contrôles, audits et Inspection Générale des Services","Sous Programme 1.3",null,"1.1 : Pilotage, dialogue et coordination des actions et des partenaires du MSP","1.1.3 : Renforcer la mise en œuvre de la gestion axée sur les résultats"]
[null,4,null,null,null,"1.4 : Participation communautaire","Sous Programme 1.4",null,"1.2 : Réformes sectorielles y compris la décentralisation","1.2.1 : Elaborer une feuille de route pour le suivi de la mise en œuvre des reformes"]
[null,5,null,null,null,"1.5 : Planification, suivi et évaluation","Sous Programme 1.5",null,"1.2 : Réformes sectorielles y compris la décentralisation","1.2.2 : Accélérer la mise en œuvre de la décentralisation dans le secteur de la santé"]
[null,6,null,null,null,"1.6 : Régulation et normalisation","Sous Programme 1.6",null,"1.2 : Réformes sectorielles y compris la décentralisation","1.2.3 : Renforcer la coordination entre la planification sectorielle et les Plans de Développement Communaux (PDC)"]
[null,7,null,null,null,"1.7 : Communication (interne et externe), documentation et archivage","Sous Programme 1.7",null,"1.3 : Contrôles, audits et Inspection Générale des Services","1.3.1 : Renforcer l’Inspection Générale de la Santé (IGS) "]
[null,8,null,null,null,"1.8 : Financement du secteur de la santé (accroissement et gestion)","Sous Programme 1.8",null,"1.3 : Contrôles, audits et Inspection Générale des Services","1.3.2 : Renforcer les activités d’audit interne et externe"]
[null,9,null,null,null,"1.9 : Gestion des ressources matérielles","Sous Programme 1.9",null,"1.4 : Participation communautaire","1.4.1 : Renforcer l’implication effective des communautés dans la gestion des services de santé"]
[null,10,null,null,null,"1.10 : Gestion des ressources humaines","Sous Programme 1.10",null,"1.4 : Participation communautaire","1.4.2 : Adopter les textes sur la participation Communautaire au contexte"]
[null,11,null,null,null,"1.11 : Construction/Réhabilitation et équipement d'infrastructures administratives et éducatives","Sous Programme 1.11",null,"1.4 : Participation communautaire","1.4.3 : Renforcer la mise en œuvre de la stratégie de prise en charge au niveau communautaire (PCAC, PECADOM, PCIME COM, DBC, PFE, ATPC etc.)"]
[null,12,null,null,null,"1.12 : Information sanitaire","Sous Programme 1.12",null,"1.4 : Participation communautaire","1.4.4 : Promouvoir le  PBF (Financement Basé sur la Performance) communautaire"]
[null,13,null,null,null,"1.13 Promotion de la recherche","Sous Programme 1.13",null,"1.5 : Planification, suivi et évaluation","1.5.1 : Renforcer le processus de la planification axée sur les Résultats"]
[null,14,null,null,null,"2.1 : Développement des compétences","Sous Programme 2.1",null,"1.5 : Planification, suivi et évaluation","1.5.2 : Généraliser l’utilisation des plans d’actions prioritaires pluri annuels à tous les niveaux "]
[null,15,null,null,null,"2.2 : Construction/ Réhabilitation d’infrastructures sanitaires","Sous Programme 2.2",null,"1.5 : Planification, suivi et évaluation","1.5.3 : Suivre la mise en œuvre des plans d’actions à travers l’organisation des revues conjointes et les missions périodiques"]
[null,16,null,null,null,"2.3 : Promotion des mécanismes de protection contre le risque financier","Sous Programme 2.3",null,"1.5 : Planification, suivi et évaluation","1.5.4 : Organiser des supervisions intégrées à tous les niveaux"]
[null,17,null,null,null,"2.4 Promotion du secteur sanitaire privé","Sous Programme 2.4",null,"1.5 : Planification, suivi et évaluation","1.5.5 : Organiser les évaluations à mi parcours et finales du PDS"]
[null,18,null,null,null,"2.5 : Acquisition et maintenance des équipements sanitaires","Sous Programme 2.5",null,"1.5 : Planification, suivi et évaluation","1.5.6 : Vulgariser les mécanismes de  mise en œuvre de la carte sanitaire opposables à tous "]
[null,19,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","Sous Programme 2.6",null,"1.6 : Régulation et normalisation","1.6.1 : Réviser le corpus juridique du Ministère de la Santé Publique pour un bon fonctionnement du système de santé "]
[null,20,null,null,null,"2.7 : Promotion de la médecine et de la pharmacopée traditionnelles","Sous Programme 2.7",null,"1.7 : Communication (interne et externe), documentation et archivage","1.7.1 : Mettre en œuvre un plan sectoriel de communication "]
[null,21,null,null,null,"3.1 : Lutte contre les maladies transmissibles","Sous Programme 3.1",null,"1.7 : Communication (interne et externe), documentation et archivage","1.7.2 : Mettre en place des unités de documentation-archives au niveau des DRSP et districts "]
[null,22,null,null,null,"3.2 : Lutte contre les maladies non transmissibles","Sous Programme 3.2",null,"1.7 : Communication (interne et externe), documentation et archivage","1.7.3 : Informatiser   la documentation-archivage à tous les niveaux"]
[null,23,null,null,null,"3.3 : Lutte contre les maladies tropicales négligées","Sous Programme 3.3",null,"1.7 : Communication (interne et externe), documentation et archivage","1.7.4 : Mettre à jour  la base de données « documentation-archives » au niveau des DRSP et districts"]
[null,24,null,null,null,"3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)","Sous Programme 3.4",null,"1.7 : Communication (interne et externe), documentation et archivage","1.7.5 : Rendre accessible sur le site Web et intranet du MSP  la « documentation-archives » collectée à tous les niveaux"]
[null,25,null,null,null,"3.5 : Nutrition","Sous Programme 3.5",null,"1.8 : Financement du secteur de la santé (accroissement et gestion)","1.8.1 : Renforcer les mécanismes de mobilisation des ressources financières internes  "]
[null,26,null,null,null,"3.6 : Promotion de la santé","Sous Programme 3.6",null,"1.8 : Financement du secteur de la santé (accroissement et gestion)","1.8.2 : Initier les mécanismes de financements innovants pour la santé"]
[null,27,null,null,null,"3.7 : Assurance qualité des services et soins de santé","Sous Programme 3.7",null,"1.8 : Financement du secteur de la santé (accroissement et gestion)","1.8.3 : Renforcer la mise en commun des fonds "]
[null,28,null,null,null,"3.8 : Sécurité sanitaire, gestion des épidémies, urgences et catastrophes","Sous Programme 3.8",null,"1.8 : Financement du secteur de la santé (accroissement et gestion)","1.8.4 : Renforcer les capacités d’absorption des crédits accordés"]
[null,29,null,null,null,null,null,null,"1.8 : Financement du secteur de la santé (accroissement et gestion)","1.8.5 : Gérer de manière rationnelle les ressources existantes "]
[null,30,null,null,null,null,null,null,"1.9 : Gestion des ressources matérielles","1.9.1 : Informatiser la gestion des ressources matérielles"]
[null,31,null,null,null,null,null,null,"1.10 : Gestion des ressources humaines","1.10.1 : Mettre en œuvre la reforme organique du MSP pour un bon fonctionnement du système de santé "]
[null,32,null,null,null,null,null,null,"1.10 : Gestion des ressources humaines","1.10.2 : Gerer Efficacement les ressources humaines de la santé"]
[null,33,null,null,null,null,null,null,"1.10 : Gestion des ressources humaines","1.10.3 : Opérationaliser le système d'évaluation et d'avancement  du personnel"]
[null,34,null,null,null,null,null,null,"1.11 : Construction/Réhabilitation et équipement d'infrastructures administratives et éducatives","1.11.1 : Rendre effective la déconcentration des écoles de santé "]
[null,35,null,null,null,null,null,null,"1.11 : Construction/Réhabilitation et équipement d'infrastructures administratives et éducatives","1.11.2 : Rendre opérationnelles les structures techniques et administratives"]
[null,36,null,null,null,null,null,null,"1.12 : Information sanitaire","1.12.1 : Développer une stratégie nationale d’information intégrant les besoins des services à tous les niveaux du système et ceux des partenaires du secteur en termes de suivi de l’impact des actions menées, de connaissance des ressources humaines, matérielles et financières disponibles dans le secteur"]
[null,37,null,null,null,null,null,null,"1.12 : Information sanitaire","1.12.2 : Actualiser les outils de collecte des données en vue de réduire la fragmentation et la multiplicité des outils actuellement observées sur le terrain y compris ceux du secteur "]
[null,38,null,null,null,null,null,null,"1.12 : Information sanitaire","1.12.3 : Renforcer  la retro-information qui permettra d’alimenter les tableaux de bord à tous les niveaux"]
[null,39,null,null,null,null,null,null,"1.12 : Information sanitaire","1.12.4 : Généraliser l'interconnection pour la collecte des données"]
[null,40,null,null,null,null,null,null,"1.13 Promotion de la recherche","1.13.1 : Mettre en place les mécanismes pour le développement de  la recherche en santé"]
[null,41,null,null,null,null,null,null,"2.1 : Développement des compétences","2.1.1 : Poursuivre la formation continue"]
[null,42,null,null,null,null,null,null,"2.1 : Développement des compétences","2.1.2 : Produire des RH de qualité"]
[null,43,null,null,null,null,null,null,"2.1 : Développement des compétences","2.1.3 : Accroitre l’effectif du personnel de santé"]
[null,44,null,null,null,null,null,null,"2.2 : Construction/ Réhabilitation d’infrastructures sanitaires","2.2.1 : Transformation des infrastructures sanitaires"]
[null,45,null,null,null,null,null,null,"2.2 : Construction/ Réhabilitation d’infrastructures sanitaires","2.2.2 : Mise à niveau de l'existant"]
[null,46,null,null,null,null,null,null,"2.2 : Construction/ Réhabilitation d’infrastructures sanitaires","2.2.3 : Réhabilitation des infrastructures sanitaires"]
[null,47,null,null,null,null,null,null,"2.2 : Construction/ Réhabilitation d’infrastructures sanitaires","2.2.4 : Construction de nouvelles infrastructures"]
[null,48,null,null,null,null,null,null,"2.2 : Construction/ Réhabilitation d’infrastructures sanitaires","2.2.5 : Renforcement des stratégies novatrices d'accès géographique au soins et services de santé"]
[null,49,null,null,null,null,null,null,"2.3 : Promotion des mécanismes de protection contre le risque financier","2.3.1 : Soutenir la mise en œuvre de la feuille de route sur la CSU"]
[null,50,null,null,null,null,null,null,"2.3 : Promotion des mécanismes de protection contre le risque financier","2.3.2 : Capitaliser les expériences en matière de Couverture de Risque Maladie (CRM)"]
[null,51,null,null,null,null,null,null,"2.3 : Promotion des mécanismes de protection contre le risque financier","2.3.3 : Renforcer les capacités des collectivités territoriales en gestion de la gratuité des soins de santé"]
[null,52,null,null,null,null,null,null,"2.4 Promotion du secteur sanitaire privé","2.4.1 : Faciliter la collaboration intersectorielle relative aux écoles privées de formation en santé"]
[null,53,null,null,null,null,null,null,"2.4 Promotion du secteur sanitaire privé","2.4.2 : Faciliter l’implantation des structures sanitaires privées conformément à la carte sanitaire"]
[null,54,null,null,null,null,null,null,"2.4 Promotion du secteur sanitaire privé","2.4.3 : Mettre en place le dispositif qualité au niveau  des écoles de santé privées"]
[null,55,null,null,null,null,null,null,"2.4 Promotion du secteur sanitaire privé","2.4.4 : Organiser les promoteurs privés du secteur de la santé en alliance"]
[null,56,null,null,null,null,null,null,"2.4 Promotion du secteur sanitaire privé","2.4.5 : Créer un environnement favorable à une collaboration public-privé dans le secteur de la santé"]
[null,57,null,null,null,null,null,null,"2.5 : Acquisition et maintenance des équipements sanitaires","2.5.1 : Acquisition d'équipements sanitaires"]
[null,58,null,null,null,null,null,null,"2.5 : Acquisition et maintenance des équipements sanitaires","2.5.2  : Maintenance des équipements sanitaires"]
[null,59,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.1 : Recapitaliser l’ONPPC"]
[null,60,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.2 : Renforcer la capacité de stockage de l’ONPPC et en régions"]
[null,61,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.3 : Renforcer la capacité de distribution des médicaments"]
[null,62,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.4 : Améliorer la gestion interne de l’ONPPC et de son circuit de distribution"]
[null,63,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.5 : Renforcement de  la production locale des médicaments"]
[null,64,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.6 : Renforcer le cadre institutionnel de la Direction de la Pharmacie et de la Médecine Traditionnelle"]
[null,65,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.7 : Augmenter les capacités de production de la SONIPHAR"]
[null,66,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.8 : Mettre en place une agence du médicament"]
[null,67,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.9 : Renforcer le contrôle de qualité des médicaments"]
[null,68,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.10 : Intensifier la lutte contre la vente illicite des médicaments et des médicaments contrefaits"]
[null,69,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.11 : Rendre disponible les médicaments, consommables, réactifs , sangs et dérivés et ARV"]
[null,70,null,null,null,null,null,null,"2.6 : Amélioration de la disponibilité des produits de santé","2.6.12 : Mettre en place un système de pharmacovigilance performant"]
[null,71,null,null,null,null,null,null,"2.7 : Promotion de la médecine et de la pharmacopée traditionnelles","2.7.1 : Règlèmenter la médecine et la pharmacopée traditionnelles"]
[null,72,null,null,null,null,null,null,"2.7 : Promotion de la médecine et de la pharmacopée traditionnelles","2.7.2 : Intégrer la médecine et la pharmacopée traditionnelles dans la système de soins "]
[null,73,null,null,null,null,null,null,"3.1 : Lutte contre les maladies transmissibles","3.1.1 : Intensifier la lutte contre les maladies transmissibles (Paludisme,Tuberculose,IST/VIH/Sida, Hépatites virales)"]
[null,74,null,null,null,null,null,null,"3.2 : Lutte contre les maladies non transmissibles","3.2.1 : Intensifier la lutte contre les maladies non transmissibles(le diabète, les maladies cardiovasculaires, le cancer et les maladies respiratoires chroniques (MRC) et la drépanocytose)"]
[null,75,null,null,null,null,null,null,"3.3 : Lutte contre les maladies tropicales négligées","3.3.1 : Intensifier la lutte contre les  maladies tropicales négligées  (la bilharziose, les filarioses lymphatiques, les géo helminthiases, la lèpre, le trachome, la trypanosomiase humaine, ver de Guinée, Onchocercose, la leishmaniose et la rage)"]
[null,76,null,null,null,null,null,null,"3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)","3.4.1 : Renforcer les services de santé de la mère et du nouveau-né"]
[null,77,null,null,null,null,null,null,"3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)","3.4.2 : Instaurer un cadre de coordination multisectorielle pour la SR"]
[null,78,null,null,null,null,null,null,"3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)","3.4.3 : Renforcement des services de planification familiale"]
[null,79,null,null,null,null,null,null,"3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)","3.4.4 : Renforcer  l’offre des services de la santé de l’enfant"]
[null,80,null,null,null,null,null,null,"3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)","3.4.5 : Renforcer l’offre des services de santé de l’homme"]
[null,81,null,null,null,null,null,null,"3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)","3.4.6 : Renforcer l’offre des services de santé des jeunes et adolescents"]
[null,82,null,null,null,null,null,null,"3.5 : Nutrition","3.5.1 : Renforcer la capacité des services de prise en charge de la malnutrition"]
[null,83,null,null,null,null,null,null,"3.5 : Nutrition","3.5.2 : Intensifier  les actions de prévention de la malnutrition"]
[null,84,null,null,null,null,null,null,"3.5 : Nutrition","3.5.3 : Développer la lutte contre le surpoids et l’obésité "]
[null,85,null,null,null,null,null,null,"3.6 : Promotion de la santé","3.6.1 : Réorienter les services de santé aux besoins des populations "]
[null,86,null,null,null,null,null,null,"3.6 : Promotion de la santé","3.6.2 : Renforcer les conditions d’un environnement de vie et de travail  favorable à la santé"]
[null,87,null,null,null,null,null,null,"3.6 : Promotion de la santé","3.6.3 : Créer les conditions favorables aux Ministères sectoriels pour l'adoption de politiques publiques de promotion de la santé"]
[null,88,null,null,null,null,null,null,"3.6 : Promotion de la santé","3.6.4 : Renforcer  les aptitudes et capacités des individus dans les activités de  promotion de la santé "]
[null,89,null,null,null,null,null,null,"3.6 : Promotion de la santé","3.6.5 : Instaurer un cadre de coordination multisectorielle de promotion de la santé au niveau national , régional et départemental et assurer son fonctionnement "]
[null,90,null,null,null,null,null,null,"3.6 : Promotion de la santé","3.6.6 : Renforcer  la participation effective des individus et des communautés à la définition des priorités, à la prise de décision et à la réalisation des actions de santé"]
[null,91,null,null,null,null,null,null,"3.7 : Assurance qualité des services et soins de santé","3.7.1 : Améliorer  la qualité des soins de santé"]
[null,92,null,null,null,null,null,null,"3.8 : Sécurité sanitaire, gestion des épidémies, urgences et catastrophes","3.8.1 : Renforcer le dispositif  de  gestion des épidémies et urgences de santé publique"]
[null,93,null,null,null,null,null,null,"3.8 : Sécurité sanitaire, gestion des épidémies, urgences et catastrophes","3.8.2 : Renforcer la Surveillance Intégrée des Maladies et Riposte (SIMR/RSI)"]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,112]

{"sheet":"Sheet1","index":1,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["1. Amélioration de la gouvernance et du leadership ","2. Accès aux soins et services de santé","3. Prestations des soins et services de santé"]
[{"$f":"Listes!F8","v":"1.1 : Pilotage, dialogue et coordination des actions et des partenaires du MSP"},{"$f":"Listes!F21","v":"2.1 : Développement des compétences"},{"$f":"Listes!F28","v":"3.1 : Lutte contre les maladies transmissibles"}]
[{"$f":"Listes!F9","v":"1.2 : Réformes sectorielles y compris la décentralisation"},{"$f":"Listes!F22","v":"2.2 : Construction/ Réhabilitation d’infrastructures sanitaires"},{"$f":"Listes!F29","v":"3.2 : Lutte contre les maladies non transmissibles"}]
[{"$f":"Listes!F10","v":"1.3 : Contrôles, audits et Inspection Générale des Services"},{"$f":"Listes!F23","v":"2.3 : Promotion des mécanismes de protection contre le risque financier"},{"$f":"Listes!F30","v":"3.3 : Lutte contre les maladies tropicales négligées"}]
[{"$f":"Listes!F11","v":"1.4 : Participation communautaire"},{"$f":"Listes!F24","v":"2.4 Promotion du secteur sanitaire privé"},{"$f":"Listes!F31","v":"3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)"}]
[{"$f":"Listes!F12","v":"1.5 : Planification, suivi et évaluation"},{"$f":"Listes!F25","v":"2.5 : Acquisition et maintenance des équipements sanitaires"},{"$f":"Listes!F32","v":"3.5 : Nutrition"}]
[{"$f":"Listes!F13","v":"1.6 : Régulation et normalisation"},{"$f":"Listes!F26","v":"2.6 : Amélioration de la disponibilité des produits de santé"},{"$f":"Listes!F33","v":"3.6 : Promotion de la santé"}]
[{"$f":"Listes!F14","v":"1.7 : Communication (interne et externe), documentation et archivage"},{"$f":"Listes!F27","v":"2.7 : Promotion de la médecine et de la pharmacopée traditionnelles"},{"$f":"Listes!F34","v":"3.7 : Assurance qualité des services et soins de santé"}]
[{"$f":"Listes!F15","v":"1.8 : Financement du secteur de la santé (accroissement et gestion)"},null,{"$f":"Listes!F35","v":"3.8 : Sécurité sanitaire, gestion des épidémies, urgences et catastrophes"}]
[{"$f":"Listes!F16","v":"1.9 : Gestion des ressources matérielles"}]
[{"$f":"Listes!F17","v":"1.10 : Gestion des ressources humaines"}]
[{"$f":"Listes!F18","v":"1.11 : Construction/Réhabilitation et équipement d'infrastructures administratives et éducatives"}]
[{"$f":"Listes!F19","v":"1.12 : Information sanitaire"}]
[{"$f":"Listes!F20","v":"1.13 Promotion de la recherche"}]
[]
[]
[]
[]
[]
[null,"Count","Start Row"]
["1.1 : Pilotage, dialogue et coordination des actions et des partenaires du MSP",{"$f":"COUNTIF(Listes!$I$8:$I$219,A21)","v":3},{"$f":"MATCH(A21,Listes!$I$8:$I$219,0)","v":1}]
["1.2 : Réformes sectorielles y compris la décentralisation",{"$f":"COUNTIF(Listes!$I$8:$I$219,A22)","v":3},{"$f":"MATCH(A22,Listes!$I$8:$I$219,0)","v":4}]
["1.3 : Contrôles, audits et Inspection Générale des Services",{"$f":"COUNTIF(Listes!$I$8:$I$219,A23)","v":2},{"$f":"MATCH(A23,Listes!$I$8:$I$219,0)","v":7}]
["1.4 : Participation communautaire",{"$f":"COUNTIF(Listes!$I$8:$I$219,A24)","v":4},{"$f":"MATCH(A24,Listes!$I$8:$I$219,0)","v":9}]
["1.5 : Planification, suivi et évaluation",{"$f":"COUNTIF(Listes!$I$8:$I$219,A25)","v":6},{"$f":"MATCH(A25,Listes!$I$8:$I$219,0)","v":13}]
["1.6 : Régulation et normalisation",{"$f":"COUNTIF(Listes!$I$8:$I$219,A26)","v":1},{"$f":"MATCH(A26,Listes!$I$8:$I$219,0)","v":19}]
["1.7 : Communication (interne et externe), documentation et archivage",{"$f":"COUNTIF(Listes!$I$8:$I$219,A27)","v":5},{"$f":"MATCH(A27,Listes!$I$8:$I$219,0)","v":20}]
["1.8 : Financement du secteur de la santé (accroissement et gestion)",{"$f":"COUNTIF(Listes!$I$8:$I$219,A28)","v":5},{"$f":"MATCH(A28,Listes!$I$8:$I$219,0)","v":25}]
["1.9 : Gestion des ressources matérielles",{"$f":"COUNTIF(Listes!$I$8:$I$219,A29)","v":1},{"$f":"MATCH(A29,Listes!$I$8:$I$219,0)","v":30}]
["1.10 : Gestion des ressources humaines",{"$f":"COUNTIF(Listes!$I$8:$I$219,A30)","v":3},{"$f":"MATCH(A30,Listes!$I$8:$I$219,0)","v":31}]
["1.11 : Construction/Réhabilitation et équipement d'infrastructures administratives et éducatives",{"$f":"COUNTIF(Listes!$I$8:$I$219,A31)","v":2},{"$f":"MATCH(A31,Listes!$I$8:$I$219,0)","v":34}]
["1.12 : Information sanitaire",{"$f":"COUNTIF(Listes!$I$8:$I$219,A32)","v":4},{"$f":"MATCH(A32,Listes!$I$8:$I$219,0)","v":36}]
["1.13 Promotion de la recherche",{"$f":"COUNTIF(Listes!$I$8:$I$219,A33)","v":1},{"$f":"MATCH(A33,Listes!$I$8:$I$219,0)","v":40}]
["2.1 : Développement des compétences",{"$f":"COUNTIF(Listes!$I$8:$I$219,A34)","v":3},{"$f":"MATCH(A34,Listes!$I$8:$I$219,0)","v":41}]
["2.2 : Construction/ Réhabilitation d’infrastructures sanitaires",{"$f":"COUNTIF(Listes!$I$8:$I$219,A35)","v":5},{"$f":"MATCH(A35,Listes!$I$8:$I$219,0)","v":44}]
["2.3 : Promotion des mécanismes de protection contre le risque financier",{"$f":"COUNTIF(Listes!$I$8:$I$219,A36)","v":3},{"$f":"MATCH(A36,Listes!$I$8:$I$219,0)","v":49}]
["2.4 Promotion du secteur sanitaire privé",{"$f":"COUNTIF(Listes!$I$8:$I$219,A37)","v":5},{"$f":"MATCH(A37,Listes!$I$8:$I$219,0)","v":52}]
["2.5 : Acquisition et maintenance des équipements sanitaires",{"$f":"COUNTIF(Listes!$I$8:$I$219,A38)","v":2},{"$f":"MATCH(A38,Listes!$I$8:$I$219,0)","v":57}]
["2.6 : Amélioration de la disponibilité des produits de santé",{"$f":"COUNTIF(Listes!$I$8:$I$219,A39)","v":12},{"$f":"MATCH(A39,Listes!$I$8:$I$219,0)","v":59}]
["2.7 : Promotion de la médecine et de la pharmacopée traditionnelles",{"$f":"COUNTIF(Listes!$I$8:$I$219,A40)","v":2},{"$f":"MATCH(A40,Listes!$I$8:$I$219,0)","v":71}]
["3.1 : Lutte contre les maladies transmissibles",{"$f":"COUNTIF(Listes!$I$8:$I$219,A41)","v":1},{"$f":"MATCH(A41,Listes!$I$8:$I$219,0)","v":73}]
["3.2 : Lutte contre les maladies non transmissibles",{"$f":"COUNTIF(Listes!$I$8:$I$219,A42)","v":1},{"$f":"MATCH(A42,Listes!$I$8:$I$219,0)","v":74}]
["3.3 : Lutte contre les maladies tropicales négligées",{"$f":"COUNTIF(Listes!$I$8:$I$219,A43)","v":1},{"$f":"MATCH(A43,Listes!$I$8:$I$219,0)","v":75}]
["3.4 : Santé de la Reproduction (Santé de la mère, de l'enfant, des adolescents et de l'homme)",{"$f":"COUNTIF(Listes!$I$8:$I$219,A44)","v":6},{"$f":"MATCH(A44,Listes!$I$8:$I$219,0)","v":76}]
["3.5 : Nutrition",{"$f":"COUNTIF(Listes!$I$8:$I$219,A45)","v":3},{"$f":"MATCH(A45,Listes!$I$8:$I$219,0)","v":82}]
["3.6 : Promotion de la santé",{"$f":"COUNTIF(Listes!$I$8:$I$219,A46)","v":6},{"$f":"MATCH(A46,Listes!$I$8:$I$219,0)","v":85}]
["3.7 : Assurance qualité des services et soins de santé",{"$f":"COUNTIF(Listes!$I$8:$I$219,A47)","v":1},{"$f":"MATCH(A47,Listes!$I$8:$I$219,0)","v":91}]
["3.8 : Sécurité sanitaire, gestion des épidémies, urgences et catastrophes",{"$f":"COUNTIF(Listes!$I$8:$I$219,A48)","v":2},{"$f":"MATCH(A48,Listes!$I$8:$I$219,0)","v":92}]

{"sheet":"Analyse infranationale","index":2,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Analyse infranationale"]
[]
[]
[]
[]
[]
[]
[1,"Agadez"]
[2,"Diffa"]
[3,"Dosso"]
[4,"Maradi"]
[5,"Niamey"]
[6,"Tahoua"]
[7,"Tillaberi"]
[8,"Zinder"]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]

{"sheet":"Budget bailleurs de fonds","index":3,"n_rows":155,"n_cols":53,"rows_kept":155,"cut":false,"hidden":false,"merged":[[1,42,1,47]]}
[]
[null,null,"1. Description",null,null,null,null,null,null,null,"2. Spécifications budgétaires",null,null,null,"3. Catégories pour l'analyse granulaire du budget ",null,null,null,null,null,null,null,"4.1 Dépenses exécutées par année",null,null,null,null,"4.2 Engagements Budgétaires par année",null,null,null,null,null,null,"5. Questions spécifiques à la riposte de Covid-19",null,null,null,null,null,null,null,"6. Répartition géographique du budget disponible "]
[null,null,"Intitulé du projet ou du résultat attendu","Intitulé de la composante \n(si pertinent)","Intitulé de l'activité","Source de financement (bailleur de fonds)","Agence d'exécution","État de mise en œuvre du projet","Notes",null,"Fonds propres / additionnels","Si additionnels, indiquer le nom du bailleur à l'origine du financement","Appui budgétaire (Etat) / Appui extra budgétaire ",null,{"$f":"donorcat1","v":"Programme"},{"$f":"donorcat2","v":"Sous Programme"},{"$f":"Listes!J7","v":"Action"},"rows moved","columns moved","height","width",null,2017,2018,2019,2020,"TOTAL",2017,2018,2019,2020,2021,"TOTAL",null,"Financement a Covid-19? (Oui/Non)","Volet","Activité","Fonds a l'origine alloués a covid ou reprogrammation?","En cas de reprogrammation, quelle était la programmation originale?","Quel type d'appui (financier, AT, en nature)","Montant de l'allocation",null,"National",{"$f":"'Analyse infranationale'!$B$8","v":"Agadez"},{"$f":"'Analyse infranationale'!$B$9","v":"Diffa"},{"$f":"'Analyse infranationale'!$B$10","v":"Dosso"},{"$f":"'Analyse infranationale'!$B$11","v":"Maradi"},{"$f":"'Analyse infranationale'!$B$12","v":"Niamey"},{"$f":"'Analyse infranationale'!$B$13","v":"Tahoua"},{"$f":"'Analyse infranationale'!$B$14","v":"Tillaberi"},{"$f":"'Analyse infranationale'!$B$15","v":"Zinder"},"SOMME"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P4,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P4,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,{"$f":"SUM(W4:Z4)","v":0},null,null,null,null,null,{"$f":"SUM(AB4:AF4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AQ4:AY4)=0,0,SUM(AQ4:AY4))","v":0},{"$f":"IF(ISBLANK(C4),\"\",IF(AZ4<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P5,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P5,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,{"$f":"SUM(W5:Z5)","v":0},null,null,null,null,null,{"$f":"SUM(AB5:AF5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C5),\"\",IF(AZ5<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P6,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P6,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB6:AF6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",IF(AZ6<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P7,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P7,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB7:AF7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",IF(AZ7<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P8,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P8,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB8:AF8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",IF(AZ8<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P9,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P9,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB9:AF9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",IF(AZ9<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P10,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P10,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB10:AF10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",IF(AZ10<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P11,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P11,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB11:AF11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C11),\"\",IF(AZ11<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P12,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P12,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB12:AF12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C12),\"\",IF(AZ12<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P13,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P13,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB13:AF13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C13),\"\",IF(AZ13<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P14,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P14,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB14:AF14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C14),\"\",IF(AZ14<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P15,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P15,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB15:AF15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C15),\"\",IF(AZ15<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P16,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P16,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB16:AF16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C16),\"\",IF(AZ16<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P17,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P17,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB17:AF17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C17),\"\",IF(AZ17<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P18,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P18,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB18:AF18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C18),\"\",IF(AZ18<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P19,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P19,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB19:AF19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C19),\"\",IF(AZ19<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P20,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P20,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB20:AF20)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C20),\"\",IF(AZ20<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P21,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P21,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB21:AF21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C21),\"\",IF(AZ21<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P22,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P22,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB22:AF22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C22),\"\",IF(AZ22<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P23,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P23,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB23:AF23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C23),\"\",IF(AZ23<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P24,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P24,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB24:AF24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C24),\"\",IF(AZ24<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P25,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P25,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB25:AF25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C25),\"\",IF(AZ25<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P26,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P26,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB26:AF26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C26),\"\",IF(AZ26<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P27,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P27,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB27:AF27)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C27),\"\",IF(AZ27<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P28,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P28,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB28:AF28)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C28),\"\",IF(AZ28<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P29,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P29,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB29:AF29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C29),\"\",IF(AZ29<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P30,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P30,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB30:AF30)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C30),\"\",IF(AZ30<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P31,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P31,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB31:AF31)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C31),\"\",IF(AZ31<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P32,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P32,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB32:AF32)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C32),\"\",IF(AZ32<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P33,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P33,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB33:AF33)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C33),\"\",IF(AZ33<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P34,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P34,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB34:AF34)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C34),\"\",IF(AZ34<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P35,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P35,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB35:AF35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C35),\"\",IF(AZ35<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P36,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P36,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB36:AF36)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AQ36:AY36)=0,0,SUM(AQ36:AY36))","v":0},{"$f":"IF(ISBLANK(C36),\"\",IF(AZ36<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P37,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P37,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB37:AF37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C37),\"\",IF(AZ37<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P38,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P38,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB38:AF38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C38),\"\",IF(AZ38<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P39,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P39,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB39:AF39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C39),\"\",IF(AZ39<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P40,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P40,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB40:AF40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C40),\"\",IF(AZ40<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P41,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P41,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB41:AF41)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C41),\"\",IF(AZ41<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P42,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P42,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB42:AF42)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C42),\"\",IF(AZ42<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P43,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P43,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB43:AF43)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C43),\"\",IF(AZ43<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P44,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P44,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB44:AF44)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C44),\"\",IF(AZ44<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P45,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P45,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB45:AF45)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C45),\"\",IF(AZ45<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P46,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P46,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB46:AF46)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C46),\"\",IF(AZ46<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P47,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P47,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB47:AF47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C47),\"\",IF(AZ47<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P48,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P48,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB48:AF48)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C48),\"\",IF(AZ48<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P49,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P49,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB49:AF49)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C49),\"\",IF(AZ49<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P50,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P50,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB50:AF50)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C50),\"\",IF(AZ50<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P51,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P51,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB51:AF51)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C51),\"\",IF(AZ51<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P52,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P52,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB52:AF52)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C52),\"\",IF(AZ52<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P53,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P53,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB53:AF53)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C53),\"\",IF(AZ53<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P54,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P54,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB54:AF54)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C54),\"\",IF(AZ54<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P55,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P55,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB55:AF55)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C55),\"\",IF(AZ55<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P56,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P56,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB56:AF56)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C56),\"\",IF(AZ56<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P57,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P57,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB57:AF57)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C57),\"\",IF(AZ57<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P58,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P58,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB58:AF58)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C58),\"\",IF(AZ58<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P59,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P59,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB59:AF59)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C59),\"\",IF(AZ59<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P60,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P60,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB60:AF60)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C60),\"\",IF(AZ60<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P61,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P61,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB61:AF61)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C61),\"\",IF(AZ61<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P62,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P62,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB62:AF62)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C62),\"\",IF(AZ62<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P63,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P63,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB63:AF63)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C63),\"\",IF(AZ63<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P64,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P64,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB64:AF64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C64),\"\",IF(AZ64<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P65,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P65,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB65:AF65)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C65),\"\",IF(AZ65<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P66,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P66,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB66:AF66)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C66),\"\",IF(AZ66<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P67,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P67,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB67:AF67)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C67),\"\",IF(AZ67<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P68,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P68,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB68:AF68)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AQ68:AY68)=0,0,SUM(AQ68:AY68))","v":0},{"$f":"IF(ISBLANK(C68),\"\",IF(AZ68<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P69,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P69,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,{"$f":"SUM(W69:Z69)","v":0},null,null,null,null,null,{"$f":"SUM(AB69:AF69)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C69),\"\",IF(AZ69<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P70,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P70,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB70:AF70)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C70),\"\",IF(AZ70<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P71,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P71,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB71:AF71)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C71),\"\",IF(AZ71<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P72,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P72,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB72:AF72)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C72),\"\",IF(AZ72<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P73,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P73,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB73:AF73)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C73),\"\",IF(AZ73<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P74,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P74,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB74:AF74)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C74),\"\",IF(AZ74<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P75,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P75,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB75:AF75)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C75),\"\",IF(AZ75<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P76,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P76,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB76:AF76)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C76),\"\",IF(AZ76<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P77,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P77,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB77:AF77)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C77),\"\",IF(AZ77<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P78,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P78,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB78:AF78)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C78),\"\",IF(AZ78<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P79,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P79,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB79:AF79)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C79),\"\",IF(AZ79<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P80,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P80,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB80:AF80)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C80),\"\",IF(AZ80<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P81,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P81,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB81:AF81)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C81),\"\",IF(AZ81<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P82,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P82,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB82:AF82)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C82),\"\",IF(AZ82<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P83,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P83,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB83:AF83)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C83),\"\",IF(AZ83<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P84,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P84,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB84:AF84)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C84),\"\",IF(AZ84<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P85,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P85,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB85:AF85)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C85),\"\",IF(AZ85<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P86,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P86,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB86:AF86)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C86),\"\",IF(AZ86<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P87,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P87,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB87:AF87)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C87),\"\",IF(AZ87<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P88,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P88,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB88:AF88)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C88),\"\",IF(AZ88<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P89,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P89,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB89:AF89)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C89),\"\",IF(AZ89<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P90,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P90,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB90:AF90)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C90),\"\",IF(AZ90<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P91,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P91,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB91:AF91)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C91),\"\",IF(AZ91<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P92,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P92,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB92:AF92)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C92),\"\",IF(AZ92<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P93,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P93,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB93:AF93)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C93),\"\",IF(AZ93<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P94,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P94,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB94:AF94)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C94),\"\",IF(AZ94<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P95,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P95,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB95:AF95)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C95),\"\",IF(AZ95<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P96,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P96,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB96:AF96)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C96),\"\",IF(AZ96<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P97,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P97,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB97:AF97)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C97),\"\",IF(AZ97<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P98,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P98,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB98:AF98)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C98),\"\",IF(AZ98<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P99,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P99,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB99:AF99)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C99),\"\",IF(AZ99<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P100,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P100,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB100:AF100)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AQ100:AY100)=0,0,SUM(AQ100:AY100))","v":0},{"$f":"IF(ISBLANK(C100),\"\",IF(AZ100<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P101,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P101,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB101:AF101)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C101),\"\",IF(AZ101<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P102,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P102,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB102:AF102)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C102),\"\",IF(AZ102<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P103,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P103,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB103:AF103)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C103),\"\",IF(AZ103<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,101,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P104,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P104,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB104:AF104)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C104),\"\",IF(AZ104<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P105,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P105,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB105:AF105)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C105),\"\",IF(AZ105<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,103,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P106,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P106,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB106:AF106)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C106),\"\",IF(AZ106<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,104,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P107,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P107,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB107:AF107)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C107),\"\",IF(AZ107<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,105,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P108,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P108,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB108:AF108)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C108),\"\",IF(AZ108<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,106,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P109,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P109,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB109:AF109)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C109),\"\",IF(AZ109<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,107,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P110,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P110,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB110:AF110)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C110),\"\",IF(AZ110<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,108,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P111,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P111,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB111:AF111)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C111),\"\",IF(AZ111<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,109,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P112,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P112,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB112:AF112)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C112),\"\",IF(AZ112<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,110,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P113,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P113,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB113:AF113)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C113),\"\",IF(AZ113<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,111,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P114,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P114,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB114:AF114)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C114),\"\",IF(AZ114<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,112,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P115,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P115,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB115:AF115)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C115),\"\",IF(AZ115<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,113,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P116,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P116,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB116:AF116)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C116),\"\",IF(AZ116<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,114,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P117,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P117,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB117:AF117)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C117),\"\",IF(AZ117<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,115,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P118,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P118,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB118:AF118)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C118),\"\",IF(AZ118<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,116,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P119,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P119,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB119:AF119)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C119),\"\",IF(AZ119<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,117,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P120,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P120,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB120:AF120)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C120),\"\",IF(AZ120<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,118,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P121,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P121,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB121:AF121)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C121),\"\",IF(AZ121<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,119,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P122,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P122,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB122:AF122)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C122),\"\",IF(AZ122<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P123,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P123,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB123:AF123)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C123),\"\",IF(AZ123<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,121,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P124,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P124,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB124:AF124)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C124),\"\",IF(AZ124<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,122,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P125,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P125,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB125:AF125)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C125),\"\",IF(AZ125<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,123,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P126,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P126,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB126:AF126)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C126),\"\",IF(AZ126<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,124,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P127,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P127,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB127:AF127)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C127),\"\",IF(AZ127<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P128,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P128,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB128:AF128)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C128),\"\",IF(AZ128<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,126,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P129,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P129,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB129:AF129)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C129),\"\",IF(AZ129<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,127,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P130,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P130,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB130:AF130)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C130),\"\",IF(AZ130<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,128,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P131,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P131,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB131:AF131)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C131),\"\",IF(AZ131<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,129,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P132,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P132,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB132:AF132)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AQ132:AY132)=0,0,SUM(AQ132:AY132))","v":0},{"$f":"IF(ISBLANK(C132),\"\",IF(AZ132<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,130,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P133,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P133,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,{"$f":"SUM(W133:Z133)","v":0},null,null,null,null,null,{"$f":"SUM(AB133:AF133)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C133),\"\",IF(AZ133<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,131,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P134,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P134,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB134:AF134)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C134),\"\",IF(AZ134<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P135,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P135,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB135:AF135)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C135),\"\",IF(AZ135<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,133,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P136,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P136,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB136:AF136)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C136),\"\",IF(AZ136<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,134,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P137,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P137,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB137:AF137)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C137),\"\",IF(AZ137<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,135,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P138,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P138,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB138:AF138)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C138),\"\",IF(AZ138<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,136,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P139,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P139,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB139:AF139)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C139),\"\",IF(AZ139<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,137,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P140,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P140,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB140:AF140)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C140),\"\",IF(AZ140<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,138,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P141,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P141,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB141:AF141)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C141),\"\",IF(AZ141<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,139,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P142,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P142,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB142:AF142)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C142),\"\",IF(AZ142<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P143,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P143,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB143:AF143)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C143),\"\",IF(AZ143<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,141,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P144,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P144,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB144:AF144)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C144),\"\",IF(AZ144<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,142,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P145,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P145,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB145:AF145)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C145),\"\",IF(AZ145<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,143,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P146,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P146,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB146:AF146)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C146),\"\",IF(AZ146<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,144,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P147,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P147,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB147:AF147)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C147),\"\",IF(AZ147<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P148,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P148,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB148:AF148)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C148),\"\",IF(AZ148<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,146,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P149,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P149,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB149:AF149)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C149),\"\",IF(AZ149<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,147,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P150,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P150,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB150:AF150)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C150),\"\",IF(AZ150<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,148,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P151,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P151,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB151:AF151)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C151),\"\",IF(AZ151<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,149,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P152,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P152,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB152:AF152)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C152),\"\",IF(AZ152<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[null,150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(P153,Sheet1!$A$21:$C$57,3,FALSE)","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP(P153,Sheet1!$A$21:$C$57,2,FALSE)","v":{"$error":"#N/A"}},1,null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(AB153:AF153)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISBLANK(C153),\"\",IF(AZ153<>1,\"Error - please ensure all columns add to 100%\",\"\"))","v":""}]
[]
[null,null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W4:W153)","v":0},{"$f":"SUM(X4:X153)","v":0},null,0,{"$f":"SUM(AA4:AA153)","v":0},0,null,null,null,null,{"$f":"SUM(AG4:AG153)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AQ$4:AQ153,$AG$4:$AG$153)","v":0},{"$f":"SUMPRODUCT(AR$4:AR153,$AG$4:$AG$153)","v":0},{"$f":"SUMPRODUCT(AS$4:AS153,$AG$4:$AG$153)","v":0},{"$f":"SUMPRODUCT(AT$4:AT153,$AG$4:$AG$153)","v":0},{"$f":"SUMPRODUCT(AU$4:AU153,$AG$4:$AG$153)","v":0},{"$f":"SUMPRODUCT(AV$4:AV153,$AG$4:$AG$153)","v":0},{"$f":"SUMPRODUCT(AW$4:AW153,$AG$4:$AG$153)","v":0},{"$f":"SUMPRODUCT(AX$4:AX153,$AG$4:$AG$153)","v":0},{"$f":"SUMPRODUCT(AY$4:AY153,$AG$4:$AG$153)","v":0},{"$f":"SUM(AQ155:AY155)","v":0}]

{"sheet":"Plan National Riposte Covid19","index":4,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,"1. Coordination ","2. Surveillance épidémiologique","3. Prévention et contrôle de l'infection","4. Communication de risque et engagement communautaire","5. Capacité des services de santé","6. Sites d'isolement / alimentation / confinement"]
[null,"1.1 Acquerir et installer  du materiel de vidéo conférence ","2.1 Dynamiser le comité National one Health","3.1 Doter les sites de prise en charge , d'isolement et des points d'entrée en matériels et des produits désinfectants ","4.1 Appuyer le fonctionnement et les réunions régulières de la commission communication pendant 6 mois (pausecafé, carburant, carte téléphonique)  ","5.1  Elaborer et reproduire un module de formation en surveillance épidémiologique et biologique et la réponse sur la maladie 2019n_coronavirus ","6.1 Réhabiliter et équiper les sites de prise en charge des cas au niveau des régions "]
[null,"1.2 Doter les secrétariat des comités en Kits informatiques et consommables du bureau  ","2.2 Dynamiser les 8 comités régionaux One Health à tous les niveaux. ","3.2 Doter les sites de soins des incinérateurs modernes ","4.2 Evaluation rapide des connaissances, perceptions et comportements (logiciel du monitorage) ","5.2 Former en cascade les agents de santé sur la surveillance épidémiologique, biologique et la réponse sur la maladie 2019n_coronavirus ","6.2 Acquérir  1000 000 flacons d’1 litre de gels désinfectants au niveau des sites d’isolement et lesstructuresde santé "]
[null,"1.3 Organiser des réunions du Comité de crise  ","2.3 Dynamiser les 72 comités départementaux One Health","3.3 Doter les sites de prise en charge , d'isolement et des points d'entrée des équipements de protection individuelle (EPI) ","4.3 Cartographier les populations à risque de manipulation et les influenceurs, adapter les messages et pre-tester. ","5.3 Rendre Disponible le matériel de protection (kit de protection individuelle)  ","6.3 Aménager et équiper les 54 sites d’isolement des points d’entrée   "]
[null,"1.4 Tenir des réunions hebdomadaires de coordination à tous les niveaux ","2.4 Dynamiser les équipes d’intervention rapide à tous les niveaux ","3.4 Acheter 100 000 000 de masques produits localement en tissu lavable ","4.4 Etablir plans et fiches de monitorage pour chaque activité de communication ","5.4  Fournir les médicaments et autres consommables médicaux de prise en charge symptomatique des cas ","6.4 Assurer la location des sites (Hôtels, Villas, immeubles, ,,,) "]
[null,"1.5 Superviser les  sites d’isolement  ","2.5 Doter le CERMES en réactifs pour le diagnostic des cas suspects  ","3.5 Organiser la distribution porte à porte des masques produits localement et savons ","4.5 Recruter et assurer la prise en charge du personnel nécessaire pour la mise en œuvre du plan ","5.5  Acquérir 1130 boites de  chloroquine de 1000 pour la prise en charge  des patients dans  les 116 sites de prise en charge (bte de 1000) ","6.5 Acquérir 60 tentes de 72 m² pour les 50 sites et 10 pour  les 7 communes de Niamey "]
[null,"1.6 Superviser les sites de prise en charge du pays  ","2.6 Acquerir 2,000,000 tests diagnostics pour et installer  dumateriel de vidéo conférence ","3.6 Acheter 412 500 cartons de 24 savons aux populations vulnérables pour 3 300 000 foyers  ","4.6  Organiser des points de presse, conférence de presse  réguliers et le séminaire gouvernemental sur la situation du Covid-19 ","5.6  Construire et équiper le site de prise en charge de Lazaret ","6.6 Acquérir  30 tentes de 42 m² pour les 50 sites et 10 pour  les 7 communes de Niamey "]
[null,"1.7  Superviser les points d'entrée (PoE) ","2.7 Mettre en place le dispositif d'acheminement des prélèvements des régions vers le niveau central (CERMES)","3.7 Doter les administrations publiques des matériels et des produits désinfectants et les dispositifs de lavage des mains ","4.7 Mettre en place un mécanisme de distribution régulière d’information pour la presse et grand publique et de répondre aux rumeurs (infographie et update journalier sur la situation) ","5.7 Doter 66 structures sanitaires et 50 structures ambilatoires en matériel complet de réaimation pour 10 patients(  7 hôpitaux nationaux, 7 hôpitaux régionaux,  7 centres mère-enfant et 45 hôpitaux de districts d'accès difficiles ) ","6.7 Réhabiliter et équiper le site d'isolement du village chinois à Niamey pour isolement  "]
[null,"1.8  Elaborer les scénarii de l'exercice de simulation à échelle réelle pour tester le Plan National de Préparation et de Réponse aux Urgences Sanitaires "," 2.8 Former les agents de santé dans le cadre de la lutte contre le Covid-19 (Prélèvement) ","3.8 Acquérir 3000 pulverisateurs en pression préalable de 16 litres pour les formations sanitaires ","4.8 Assurer le fonctionnement de la ligne pour la presse  ","5.8  Doter les 66 structures sanitaires et structures ambulatoires en groupes électrogène ","6.8 Assurer l'alimentation des personnes sous isolement  au niveau des sites "]
[null,"1.9 Conduire un exercice de simulation à échelle réelle pour tester le Plan National de Préparation et de Réponse aux Urgences Sanitaires ","2.9 Pré positionner le matériel de prélèvement des cas et autres consommables de laboratoire  ","3.9  Acquérir 3000 pulverisateurs en pression préalable de 1.5 litres pour les formations sanitaires ","4.9 Assurer la prise en charge de 50 agents préventionnistes à déployer aux marchés et gares pour la sensibilisation (prise en charge, crédit de communication et transport) ","5.9  Doter les régions en appareils de production d'oxygiène médical ","6.9  Assurer l'entretien des sites d'isolement "]
[null,"1.10 Conduire un exercice de simulation à échelle réelle pour tester le Plan National de Préparation et de Réponse aux Urgences Sanitaires au niveau de chaque région ","2.10  Doter les formations sanitaires et les points d’entrées terrestres et aéroportuaires en outils de collecte des données ","3.10 Acquérir 300 rampes de 10 robinets de lavage de mains aux différents points d'entrée des marchés ","4.10 Organiser une session d'orientation de 30 journalistes et animateurs radios ","5.10 Doter  28 unités de laboratoire dans les 8 régions et les districts sanitaires éloignés ","6.10  Assurer l'alimentation des personnes des personnes vulnérables  sous isolement  "]
[null,"1.11 Assurer la communication entre les différents niveaux (internet et appel) ","2.11 Motiver les agents des points d’entrée terrestres et aériens  ","3.11 Acquérir 1000 touques de 12 Kgs d'hypochlorite de calcium à 70%  ","4.11  Identifier les influenceurs sur les réseaux sociaux et faire passer les messages ","5.11 Approvisionner les   28 unités de laboratoire en intrants et consommables dans les 8 régions et les districts sanitaires éloignés(paquet de 250 boîtes) "]
[null,"1.12 Organiser des missions d'échange d'expérience ","2.12 Motiver les agents  impliqués dans le suivi des autoisolements","3.12 Equiper les sites de prise en charge, d'isolement et despoints d'entrée de dispositifs d'alimentation en eau potable ","4.12 Développer infographie et vidéographie avec messages clés pour les réseaux sociaux et les médias en ligne et les distribuer ","5.12 Assurer la prise en charge des agents de sécurité des sites d'isolement et de prise en charge "]
[null,"1.13 Organiser les réunions du comité interministériel de lutte contre la pandémie Covid - 19 National ","2.13  Elaborer les procédures opératoires standards (SOPs) ","3.13 Doter les administrations publiques des matériels et des produits désinfectants et les dispositifs de lavage des mains ","4.13 Engager le personnel de santé, médias, ONG et OBC, secteur prive, transport etc. dans la distribution des messages et des produits de communication.  ","5.13 Recruter 1500 agents de santé "]
[null,"1.14 Organiser les réunions du comité consultatif de lutte contre la pandémie Covid - 19 National ","2.14 Assurer la dissémination des SOP ",null,"4.14 Produire spots audio en langues locales et diffusion par les radios nationales et communautaires ","5.14 Assurer la prise en charge de 800 agents volontaires  "]
[null,"1.15 Organiser les réunions du comité d'experts de lutte contre la pandémie Covid - 19 National ","2.15 Elaborer le plan de gestion des urgences de santé publiques au point d’entrée  ",null,"4.15 Produire des spots vidéo en langues et diffusions sur les chaines nationales. ","5.15 Assurer la gestion des dépouilles mortelles "]
[null,"1.16 Organiser les réunions du comité scientifique sur le protocole de prise en charge des cas du Covid - 19  ","2.16 Mettre à la disposition des 15 points d’entrée les fiches techniques  ",null,"4.16 Distribution des alertes par SMS a tous les utilisateurs, en coopération avec les opérateurs téléphonie mobile. ","5.16 Assurer le transport des matériels et équipements dans les régions   "]
[null,"1.17 Dynamiser les 72 comités départementaux One Health","2.17 Mettre à la disposition des formations sanitaires publiques, privées et confectionnelles, la fiche technique de définition de cas de Covid-19  ",null,"4.17  Produire et diffuser les affiches, Kakemono  etc.. ","5.17 Utiliser un avion médicalisé "]
[null,"1.18 Assurer la location d'une ( 1) salle à huis clos pour le comité interministériel ","2.18  à la disposition des points d’entrée identifiés 2000 thermomètres laser y compris pile de recharges ",null,"4.18 Mettre en place les panneaux COVID-19 dans les chefs-lieux de 8 régions    ","5.18 Soutenir les familles/orphelins des victimes "]
[null,"1.19 Assurer la location  3 salles de commissions  pour les comités ( consultatif, experts et sécrétariat) ","2.19 Acquérir des 11 scanners thermiques y compris formation des manipulateurs ",null,"4.19 Briefer le personnel de sante sur les messages clés à passer aux populations sur le COVID-19 dans les 8 régions (aide memoire) "]
[null,"1.20 Motiver les agents de terrain impliqués dans la prise en charge(points d'entrée,suivi auto-isolement, sites prises en charge) ","2. 20 Former le personnel des points d’entrée sur le RSI (2005), en détection précoce des cas des maladies, la notification immédiate et les mesures de prévention et contrôle des infections ",null,"4.20 Organiser des séances de sensibilisation (émissions dans les media)  "]
[null,"1.21 Motiver 4 assistants au secrétariat du comité intersectoriel  ","2.21 Assurer les investigation des cas  ",null,"4.21 Briefer le personnel CREC sur la COVID-19 dans les 8 DRSP Cibles (40 personnes/DRSP)  "]
[null,"1.22 Organiser les réunions du comité interministériel de lutte contre la pandémie Covid - 19  des 8 régions ","2.22 Acquérir 50 tablettes pour le traitement des données et l'application ",null,"4.22 Appuyer les OBC en communication des risques COVID-19 dans les 72 DS  "]
[null,"1.23 Assurer la prise charge la logistique transport (carburant et entretien) ","2.23 Etendre les capacités de la centrale d'appel du SAMU ",null,"4.23 Monitorer les médias et réseaux sociaux et adresser les rumeurs - appui pour l'equipe de suivi et reaction"]
[null,"1.24 Mener une revue après action de l’épidémie ","2.24 Doter les sites de prise en charge de 290 ambulances équipées pour le transport des cas suspects ",null,"4.24 Assurer des mécanismes de feedback communautaire dans les 8 régions "]
[null,"1.25  Diffuser les résultats de l’évaluation ","2.25  Assurer la location des véhicules pour le suivi des contacts ",null,"4.25 Renforcer engagement communautaire à travers les radios communautaires, leaders religieux et traditionnels, groupements formels et informels des femmes et jeunes, relais communautaires. "]
[null,"1.26 Déclarer officiellement la fin de l’épidémie  ","2.26 Doter les équipes de suivi des auto-isolés de 12 véhicules doubles cabine Hard Top ",null,"4.26 Mise en place des supports de communication et supervision des relais et suivi des activités communautaires de prévention contre le COVID-19 "]
[null,null,"2.27 Doter la Coordination de 2 véhicules station wagon 4 x 4 pour les supervisions des activités ",null,"4.27  Organiser des enquêtes communautaires sur la perception de COVID-19  "]
[null,null,"2.28 Doter 12 points d'entrée de Motos tout terrain ",null,"4.28 Appuyer les radios et televisions à la diffusion des émissions sur COVID-19  "]
[null,null,"2.29  Continuer la collecte l’analyse et transmission des données   ",null,"4.29 Effectuer des missions de sensibilisation sur le Covid-19 porte à porte par les relais "]
[null,null,null,null,"4.30 Assurer la diffusion des messages clés et spots COVID-19 dans les médias   "]
[null,null,null,null,"4.31 Assurer le suivi et l'évaluation par le système de monitorage   "]
[null,null,null,null,"4.32 Diffuser le spot vidéo sur Télé-Sahel "]
[null,null,null,null,"4.33 Diffuser le spot audio Voix du Sahel (Chaine public) "]
[null,null,null,null,"4.34 Appuyer les réunions régulières de la commission communication pendant 1 mois (pause-café/déjeuner, carburant, carte téléphonique) "]
[null,null,null,null,"4.35 Organiser 8 sorties d'évaluation des activités de communication dans les 8 régions.  "]
[null,null,null,null,"4.36 Organiser les sorties d'évaluation des activités de communication des régions vers les districts "]