{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Setup","1-Reception & Dedouanement","2-Stockage & Gestion","3-Distribution","4-Rapportage & SIGL","5-Controle qualite & Paiement","6-Normes stockage","Calc","Orientations","Dashboard","Questionnaire","Feuil1","Plan_Actions"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":15,"defined_names":287},"read":"whole","date_system":"1900"}

{"sheet":"Setup","index":0,"n_rows":186,"n_cols":35,"rows_kept":186,"merged":[[0,5,1,20],[1,31,1,35],[2,31,2,35],[4,31,4,36],[10,11,11,14],[12,10,12,12],[17,6,17,7],[17,31,17,35],[19,7,19,10],[20,7,20,10],[21,7,21,10],[21,31,21,35],[25,5,25,10],[25,11,25,13],[26,5,26,10],[26,11,26,13],[27,5,27,10],[27,11,27,13],[28,5,28,10],[28,11,28,13],[29,5,29,10],[29,11,29,13],[29,32,29,35],[30,5,30,10],[30,11,30,13],[30,31,32,35],[31,5,31,10],[31,11,31,13],[32,5,32,10],[32,11,32,13],[33,5,33,10],[33,11,33,13],[34,5,34,10],[34,11,34,13]]}
[{"$nulls":5},{"$f":"UPPER(IF(L8=1,\"Document-type hors ligne pour l'evaluation des centrales d'achat & distribution\",\"Standard offline tool for the evaluation of Procurement & distribution agency\"))","v":"DOCUMENT-TYPE HORS LIGNE POUR L'EVALUATION DES CENTRALES D'ACHAT & DISTRIBUTION"}]
[{"$nulls":31},{"$f":"IF(L8=1,\"Cliquer ci-dessous pour acceder\",\"Click below to access\")","v":"Cliquer ci-dessous pour acceder"}]
[{"$nulls":31},""]
[]
[null,null,"DOCUMENT-TYPE HORS LIGNE POUR EVALUATION DES CAPACITES DES SRS DU SECTEUR PUBLIC","STANDARD OFFLINE TOOL FOR PUBLIC SRS CAPACITY EVALUATION",{"$nulls":27},{"$f":"UPPER(IF(L8=1,\"Modules Evaluation\",\"Evaluation Modules\"))","v":"MODULES EVALUATION"}]
[{"$nulls":4},"Liste"]
[null,null,"Francais",1]
[null,null,"Anglais",2,{"$nulls":5},{"$f":"UPPER(IF(L8=1,C19,D19))","v":"LANGUE:"},"Francais",{"$f":"IF(K8=\"Francais\",1,2)","v":1}]
[]
[null,null,"<== Il faut s'assurer de mettre a jour la composante si vous changez de langue"]
[null,null,"<== Make sure to update component if you change the language",{"$nulls":6},{"$f":"UPPER(IF(L8=1,\"Composante:\",\"Component:\"))","v":"COMPOSANTE:"},"VIH/SIDA",{"$f":"IF(L8=1,C10,C11)","v":"<== Il faut s'assurer de mettre a jour la composante si vous changez de langue"}]
[]
[null,null,"VIH/SIDA","HIV/AIDS",{"$nulls":5},{"$f":"UPPER(IF(L8=1,\"Pays:\",\"Country:\"))","v":"PAYS:"},"Congo"]
[null,null,"Tuberculose","Tuberculosis"]
[null,null,"Paludisme","Malaria"]
[null,null,"VIH/TB","HIV/TB"]
[null,null,"RSS","HSS",null,{"$f":"UPPER(IF(L8=1,\"Date d'evaluation\",\"Evaluation date\"))","v":"DATE D'EVALUATION"}]
[{"$nulls":5},"Jour","Mois",null,"Annee",{"$f":"L11","v":"<== Il faut s'assurer de mettre a jour la composante si vous changez de langue"},{"$nulls":21},{"$f":"UPPER(IF(L8=1,\"Resultats Evaluation\",\"Evaluation issues\"))","v":"RESULTATS EVALUATION"}]
[null,null,"Langue:","Langage:"]
[{"$nulls":5},{"$f":"UPPER(IF(L8=1,\"Structure-1\",\"Structure-1\"))","v":"STRUCTURE-1"}]
[null,null,"Composante","Component",null,{"$f":"UPPER(IF(L8=1,\"Structure-2\",\"Structure-2\"))","v":"STRUCTURE-2"}]
[{"$nulls":5},{"$f":"UPPER(IF(L8=1,\"Central d'achat\",\"Central purchasing\"))","v":"CENTRAL D'ACHAT"},{"$nulls":25},{"$f":"UPPER(IF(L8=1,\"Plan d'amelioration\",\"capacity investment Plan\"))","v":"PLAN D'AMELIORATION"}]
[null,null,"Recipiendaire","Recipient ID"]
[]
[{"$nulls":5},{"$f":"UPPER(IF(L8=1,\"Equipe d'evaluation\",\"Evaluation Team\"))","v":"EQUIPE D'EVALUATION"},{"$nulls":5},{"$f":"UPPER(IF(L8=1,\"Structure\",\"Institution\"))","v":"STRUCTURE"}]
[{"$nulls":14},{"$f":"IF(L8=1,\"Leader Equipe\",\"Team Leader\")","v":"Leader Equipe"}]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"},{"$nulls":19},1]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"},{"$nulls":16},{"$f":"UPPER(IF(L8=1,\"Demande d'appui/suggestions\",\"Technical resquest/suggestions\"))","v":"DEMANDE D'APPUI/SUGGESTIONS"}]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"}]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"}]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"},{"$nulls":16},"Pour tout besoin, envoyez un mail sur ==> direction@sapsapservices.com"]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"}]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"}]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"}]
[{"$nulls":14},{"$f":"IF(L8=1,\"Membre\",\"Member\")","v":"Membre"}]
[]
[{"$nulls":34},1]
[]
[]
[]
[]
[]
[{"$nulls":21},"Afghanistan",null,null,"Jour","Day","Mois","Month","Annee","Year"]
[{"$nulls":21},"Albania",null,null,1,1,"Janvier","January",2014,2014]
[{"$nulls":21},"Algeria",null,null,2,2,"Fevrier","February",2015,2015]
[{"$nulls":21},"Angola",null,null,3,3,"Mars","March",2016,2016]
[{"$nulls":21},"Argentina",null,null,4,4,"Avril","April",2017,2017]
[{"$nulls":21},"Armenia",null,null,5,5,"Mai","May",2018,2018]
[{"$nulls":21},"Azerbaijan",null,null,6,6,"Juin","June",2019,2019]
[{"$nulls":21},"Bangladesh",null,null,7,7,"Juillet","July",2020,2020]
[{"$nulls":21},"Belarus",null,null,8,8,"Août","August",2021,2021]
[{"$nulls":21},"Belize",null,null,9,9,"Septembre","September",2022,2022]
[{"$nulls":21},"Benin",null,null,10,10,"Octobre","October",2023,2023]
[{"$nulls":21},"Bolivia (Plurinational State)",null,null,11,11,"Novembre","November",2024,2024]
[{"$nulls":21},"Bosnia and Herzegovina",null,null,12,12,"Décembre","December",2025,2025]
[{"$nulls":21},"Brazil",null,null,13,13]
[{"$nulls":21},"Bulgaria",null,null,14,14]
[{"$nulls":21},"Burkina Faso",null,null,15,15]
[{"$nulls":21},"Burundi",null,null,16,16]
[{"$nulls":21},"Buthan",null,null,17,17]
[{"$nulls":21},"Cambodia",null,null,18,18]
[{"$nulls":21},"Cameroon",null,null,19,19]
[{"$nulls":21},"Cape Verde",null,null,20,20]
[{"$nulls":21},"Central African Republic",null,null,21,21]
[{"$nulls":21},"Chad",null,null,22,22]
[{"$nulls":21},"Chile",null,null,23,23]
[{"$nulls":21},"China",null,null,24,24]
[{"$nulls":21},"Colombia",null,null,25,25]
[{"$nulls":21},"Comoros",null,null,26,26]
[{"$nulls":21},"Congo",null,null,27,27]
[{"$nulls":21},"Congo (Democratic Republic)",null,null,28,28]
[{"$nulls":21},"Costa Rica",null,null,29,29]
[{"$nulls":21},"Cote d'Ivoire",null,null,30,30]
[{"$nulls":21},"Croatia",null,null,31,31]
[{"$nulls":21},"Cuba"]
[{"$nulls":21},"Djibouti"]
[{"$nulls":21},"Dominican Republic"]
[{"$nulls":21},"Ecuador"]
[{"$nulls":21},"Egypt"]
[{"$nulls":21},"El Salvador"]
[{"$nulls":21},"Equatorial Guinea"]
[{"$nulls":21},"Eritrea"]
[{"$nulls":21},"Estonia"]
[{"$nulls":21},"Ethipia"]
[{"$nulls":21},"Fiji"]
[{"$nulls":21},"Gabon"]
[{"$nulls":21},"Gambia"]
[{"$nulls":21},"Georgia"]
[{"$nulls":21},"Ghana"]
[{"$nulls":21},"Guatemala"]
[{"$nulls":21},"Guinea"]
[{"$nulls":21},"Guinea-Bissau"]
[{"$nulls":21},"Guyana"]
[{"$nulls":21},"Haiti"]
[{"$nulls":21},"Honduras"]
[{"$nulls":21},"India"]
[{"$nulls":21},"Indonesia"]
[{"$nulls":21},"Iran (Islamic Republic)"]
[{"$nulls":21},"Iraq"]
[{"$nulls":21},"Jamaica"]
[{"$nulls":21},"Jordan"]
[{"$nulls":21},"Kazakhstan"]
[{"$nulls":21},"Kenya"]
[{"$nulls":21},"Korea (Democratic Peoples Republic)"]
[{"$nulls":21},"Kosovo"]
[{"$nulls":21},"Kyrgyzstan"]
[{"$nulls":21},"Lao (Peoples Democratic Republic)"]
[{"$nulls":21},"Lesotho"]
[{"$nulls":21},"Liberia"]
[{"$nulls":21},"Lutheran World Federation"]
[{"$nulls":21},"Macedonia (Former Yugoslav Republic)"]
[{"$nulls":21},"Madagascar"]
[{"$nulls":21},"Malawi"]
[{"$nulls":21},"Malaysia"]
[{"$nulls":21},"Maldives"]
[{"$nulls":21},"Mali"]
[{"$nulls":21},"Mauritania"]
[{"$nulls":21},"Mauritius"]
[{"$nulls":21},"Mexico"]
[{"$nulls":21},"Moldavia"]
[{"$nulls":21},"Mongolia"]
[{"$nulls":21},"Montenegro"]
[{"$nulls":21},"Morocco"]
[{"$nulls":21},"Mozambique"]
[{"$nulls":21},"Multicountry Africa (RMCC)"]
[{"$nulls":21},"Multicountry Africa (SADC)"]
[{"$nulls":21},"Multicountry Americas (Andean)"]
[{"$nulls":21},"Multicountry Americas (CARICOM/PANCAP)"]
[{"$nulls":21},"Multicountry Americas (COPRECOS)"]
[{"$nulls":21},"Multicountry Americas (CRN+)"]
[{"$nulls":21},"Multicountry Americas (Meso)"]
[{"$nulls":21},"Multicountry Americas (OECS)"]
[{"$nulls":21},"Multicountry Americas (REDCA+)"]
[{"$nulls":21},"Multicountry Americas (REDTRASEX)"]
[{"$nulls":21},"Multicountry East Asia and Pacific (APN+)"]
[{"$nulls":21},"Multicountry East Asia and Pacific (RAI)"]
[{"$nulls":21},"Multicountry East Asia and Pacific (SEAN-HIVOS)"]
[{"$nulls":21},"Multicountry Eastern Europe- Central Aisa (EHRN)"]
[{"$nulls":21},"Multicountry Middle East-North Africa (MENAHRA)"]
[{"$nulls":21},"Multicountry South Asia"]
[{"$nulls":21},"Multicountry Western Pacific"]
[{"$nulls":21},"Myanmar"]
[{"$nulls":21},"Namibia"]
[{"$nulls":21},"Nepal"]
[{"$nulls":21},"Nicaragua"]
[{"$nulls":21},"Niger"]
[{"$nulls":21},"Nigeria"]
[{"$nulls":21},"Pakistan"]
[{"$nulls":21},"Palestine"]
[{"$nulls":21},"Panama"]
[{"$nulls":21},"Papua New Guinea"]
[{"$nulls":21},"Peru"]
[{"$nulls":21},"Philippines"]
[{"$nulls":21},"Romania"]
[{"$nulls":21},"Russian Federation"]
[{"$nulls":21},"Rwanda"]
[{"$nulls":21},"Sao Tome and Principe"]
[{"$nulls":21},"Senegal"]
[{"$nulls":21},"Serbia"]
[{"$nulls":21},"Sierra Leone"]
[{"$nulls":21},"Solomon Islands"]
[{"$nulls":21},"South Africa"]
[{"$nulls":21},"South Sudan"]
[{"$nulls":21},"Sri Lanka"]
[{"$nulls":21},"Sudan"]
[{"$nulls":21},"Suriname"]
[{"$nulls":21},"Swaziland"]
[{"$nulls":21},"Switzerland"]
[{"$nulls":21},"Syrian Arab Republic"]
[{"$nulls":21},"Tajikistan"]
[{"$nulls":21},"Tanzania (United Republic)"]
[{"$nulls":21},"Thailand"]
[{"$nulls":21},"Timor-Leste"]
[{"$nulls":21},"Togo"]
[{"$nulls":21},"Tunusia"]
[{"$nulls":21},"Turkey"]
[{"$nulls":21},"Turkmenistan"]
[{"$nulls":21},"Uganda"]
[{"$nulls":21},"Ukraine"]
[{"$nulls":21},"Uruguay"]
[{"$nulls":21},"Uzbekistan"]
[{"$nulls":21},"Viet Nam"]
[{"$nulls":21},"Yemen"]
[{"$nulls":21},"Zambia"]
[{"$nulls":21},"Zanzibar"]
[{"$nulls":21},"Zimbabwe"]

{"sheet":"1-Reception & Dedouanement","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[0,0,0,5]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"1-Reception & dedouanement\",\"1-reception & customs\"))","v":"1-RECEPTION & DEDOUANEMENT"}]
[]
[]
[{"$f":"UPPER(IF(Setup!L8=1,\"1-Reception & dedouanement\",\"1-reception & customs\"))","v":"1-RECEPTION & DEDOUANEMENT"},{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IFERROR(SUM(D6:D11)/E4,\"\")","v":""},{"$f":"SUM(E6:E11)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations/commentaires\",\"Notes/commentaries\"))","v":"OBSERVATIONS/COMMENTAIRES"}]
[]
["1.1-le Délai entre l'arrivée des produits à l'aérport et fla in dédouanement / arrivée des produits à la centrale d’achat et de stockage est-il adequat ?","Voir délais sur 12 ders mois","Select",{"$f":"IF(C6=\"Select\",\"\",IF(VLOOKUP(C6,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(C6,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(C6=\"Select\",OR(C6=\"Non/Not applicable\")),0,1)","v":0}]
["1.2-Existe-t-il un outil permettant de mesurer la performance de la centrale d’achat et de stockage en matière de dédouanement des produits (date d'arrivée à l'aéroport, date de livraison dans les entrepôts CAMEG, date de réception provisoire)?","Voir outil","Select",{"$f":"IF(C7=\"Select\",\"\",IF(VLOOKUP(C7,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(C7,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(C7=\"Select\",OR(C7=\"Non/Not applicable\")),0,1)","v":0}]
["1.3- Y a-t-il une réception provisoire (avec mise en quarantaine) puis une réception définitive, avec des délais  satisfaisants ?","Voir bons réception provisoire et bons réception définitive","Select",{"$f":"IF(C8=\"Select\",\"\",IF(VLOOKUP(C8,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(C8,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["1.4- il n'y a jamais  eu des cas de non conformité ? (Si il y en a eu, veuillez preciser dans la colonne observations ce qui a été fait)","Se referer a la feuille de résultats du laboratoire","Select",{"$f":"IF(C9=\"Select\",\"\",IF(VLOOKUP(C9,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(C9,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["1.5- Le document de suivi des réceptions du PPM est t-il  été rempli a chaque fois ?","Voir documents de suivi de réception du PPM sur 12 ders mois","Select",{"$f":"IF(C10=\"Select\",\"\",IF(VLOOKUP(C10,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(C10,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["1.6-La liste des produits réceptionnés (avec numéro de lot, péremption, quantité) est -elle transmise au PR après chaque réception?",null,"Select",{"$f":"IF(C11=\"Select\",\"\",IF(VLOOKUP(C11,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(C11,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[]
[]
[{"$nulls":7},"Select"]
[{"$nulls":7},"Oui, satisfaisant",1]
[{"$nulls":7},"En partie,Peu satisfaisant",0.5]
[{"$nulls":7},"En partie,tres peu satisfaisant",0.25]
[{"$nulls":7},"Non",0]
[{"$nulls":7},"Non applicable"]

{"sheet":"2-Stockage & Gestion","index":2,"n_rows":32,"n_cols":9,"rows_kept":32,"merged":[[0,0,0,6]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"2-Stokage & Gestion\",\"2-storage and management\"))","v":"2-STOKAGE & GESTION"}]
[]
[null,{"$f":"UPPER(IF(Setup!L8=1,\"2.1-Stokage\",\"2.1-Storage\"))","v":"2.1-STOKAGE"},{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IFERROR(SUM(E5:E18)/F3,\"\")","v":""},{"$f":"SUM(F5:F18)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"}]
[null,"Tous les produits de la subvention sont-ils stockés à  la centrale d’achat et de stockage?","Quels intrants encore stockés au niveaus PRs ou Programmes?","Select",{"$f":"IF(D4=\"Select\",\"\",IF(VLOOKUP(D4,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D4,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D4=\"Select\",OR(D4=\"Non/Not applicable\")),0,1)","v":0},null,"Select"]
[null,"Des procédures pour le stockage et la gestion de stock sont-elles disponibles?","Visite entrepôts centraux (médicaments, réactifs, TDRs, préservatifs), Voir fiches température sur 12 ders mois","Select",{"$f":"IF(D5=\"Select\",\"\",IF(VLOOKUP(D5,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D5,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D5=\"Select\",OR(D5=\"Non/Not applicable\")),0,1)","v":0},null,"Oui, satisfaisant",1]
[null,"L'espace de stockage est-il suffisant pour permettre un entreposage ordonné?","Veirifier l'etta du magasin et la situation de rangement des colis dans les enttrepots","Select",{"$f":"IF(D6=\"Select\",\"\",IF(VLOOKUP(D6,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D6,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D6=\"Select\",OR(D6=\"Non/Not applicable\")),0,1)","v":0},null,"En partie,Peu satisfaisant",0.5]
[null,"L’entrepôt ou le magasin sont-ils nettoyes et desinfectes regulierement?\n","Verifier de visu l'etat de proprete des locaux et les alentours","Select",{"$f":"IF(D7=\"Select\",\"\",IF(VLOOKUP(D7,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D7,Calc!$C$34:$D$39,2,FALSE)))","v":""},0,null,"En partie,tres peu satisfaisant",0.25]
[null,"Entreposez-vous les produits dans un local sans humidité, bien éclairé et bien ventilé, à l’abri d’une exposition directe aux rayons du soleil?",null,"Select",{"$f":"IF(D8=\"Select\",\"\",IF(VLOOKUP(D8,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D8,Calc!$C$34:$D$39,2,FALSE)))","v":""},0,null,"Non",0]
[null,"Des thermomètres sont-ils disponibles pour surveiller la température, avec enregistrement réguliers des températures (y compris dans les chambres froides)?","Verifier l'existence et l'etat de fonctionnement des thermometres et la relevee des temperatudes","Select",{"$f":"IF(D9=\"Select\",\"\",IF(VLOOKUP(D9,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D9,Calc!$C$34:$D$39,2,FALSE)))","v":""},0,null,"Non applicable"]
[null,"Les équipements de lutte contre l’incendie  sont disponibles et accessibles et le personnel  formé pour son utilisation?","Verifier l'existence des equipements et les preuves de formations des agents","Select",{"$f":"IF(D10=\"Select\",\"\",IF(VLOOKUP(D10,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D10,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les conditions de stockage au niveau régional sont-elles adéquates (pour chaque type d'intrant)? Y compris sécurrité des stocks?","Visite entrepôts régionaux (médicaments, réactifs, TDRs, préservatifs)","Select",{"$f":"IF(D11=\"Select\",\"\",IF(VLOOKUP(D11,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D11,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les lieux de stockage des produits sont-ils contrôlés avec des clés de securite?","Verifier l'existence de barres de protections et de cadenas","Select",{"$f":"IF(D12=\"Select\",\"\",IF(VLOOKUP(D12,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D12,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les produits pharmaceutiques sont ils entreposes séparément des produits inflammables?","Demander et verifier de visu","Select",{"$f":"IF(D13=\"Select\",\"\",IF(VLOOKUP(D13,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D13,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les cartons sont-ils entreposes à au moins 10 centimètres du sol, à 30 centimètres des murs et des autres piles, et à une hauteur de 2,5 mètres maximum?",null,"Select",{"$f":"IF(D14=\"Select\",\"\",IF(VLOOKUP(D14,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D14,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Disposez-vous les cartons de sorte que les flèches pointent vers le haut et veiller à ce que les étiquettes d’identification, les dates de péremption et les numéros de lot soient clairement visibles?  ","Il est primordial que les produits qui arrivent à expiration en premier soient également les premiers distribués (indépendamment du moment où ils sont arrivés dans le local d’entreposage). ","Select",{"$f":"IF(D15=\"Select\",\"\",IF(VLOOKUP(D15,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D15,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Entreposez-vous les produits d’une manière qui facilite l’application du principe du PPPS, le comptage ainsi que la gestion générale? ",null,"Select",{"$f":"IF(D16=\"Select\",\"\",IF(VLOOKUP(D16,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D16,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Procédez-vous immédiatement à  la séparation et à la destruction de tout produit endommagé ou périmé.",null,"Select",{"$f":"IF(D17=\"Select\",\"\",IF(VLOOKUP(D17,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D17,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les produits stockés sont-ils assurés? Une copie du contrat d'assurance a-t-elle été transmise aux PRs?",null,"Select",{"$f":"IF(D18=\"Select\",\"\",IF(VLOOKUP(D18,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D18,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,{"$f":"UPPER(IF(Setup!L8=1,\"2.2-Gestion\",\"2.2-Management\"))","v":"2.2-GESTION"},{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},null,{"$f":"SUM(F20:F32)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"}]
[null,"Les système de gestion de stock permet-il d'enregistrer les numéros de lot et les dates de péremption?",null,"Select",{"$f":"IF(D20=\"Select\",\"\",IF(VLOOKUP(D20,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D20,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D20=\"Select\",OR(D20=\"Non/Not applicable\")),0,1)","v":0}]
[null,"Les enregistrements des mouvements sont-ils conservés?",null,"Select",{"$f":"IF(D21=\"Select\",\"\",IF(VLOOKUP(D21,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D21,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Tout écart de stock significatif lors des inventaires donne-t-il lieu à une investigation?",null,"Select",{"$f":"IF(D22=\"Select\",\"\",IF(VLOOKUP(D22,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D22,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Chaque mouvement de stock est-il enregistré?",null,"Select",{"$f":"IF(D23=\"Select\",\"\",IF(VLOOKUP(D23,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D23,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Chaque enregistrement contient-il toutes les precisions suivantes: description des produits, quantité, fournisseur, numéro de lot, date de réception, date de péremption?","Verifier le registre d'enregistrement","Select",{"$f":"IF(D24=\"Select\",\"\",IF(VLOOKUP(D24,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D24,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Des invenatires sont-ils effectués régulièrement? A quelle fréquence?","Voir inventaires sur 12 ders mois","Select",{"$f":"IF(D25=\"Select\",\"\",IF(VLOOKUP(D25,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D25,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les osont-ils utils de gestion de stock utilisés pour chaque type d'intrants (y compris préservatifs, réactifs, MIOs, etc.)?","Voir outils de stock  / voir si sont a jours sur 12 ders mois","Select",{"$f":"IF(D26=\"Select\",\"\",IF(VLOOKUP(D26,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D26,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les agences régionales ont-elles tous les outils de gestion pour les intrants Fonds Mondial, y compris pour les réactifs? Le personnel est-il formé à leur utilisation?",null,"Select",{"$f":"IF(D27=\"Select\",\"\",IF(VLOOKUP(D27,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D27,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Pour chaque intrant, des outils de gestion de stock (logiciel, SAGE, Fiche de stock, etc.) sont-ils utilisés au niveau central et au niveau régional?","Voir outils cités et voir si sont à jour.","Select",{"$f":"IF(D28=\"Select\",\"\",IF(VLOOKUP(D28,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D28,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les outils de gestion de stock permettent-ils de collecter les données sur les périmés (y compris valorisation) et les ruptures?","Voir ruptures et péremption sur 12 der mois (sur base fiches de stock)?","Select",{"$f":"IF(D29=\"Select\",\"\",IF(VLOOKUP(D29,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D29,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"La règle du FEFO (ou PPPS=Premiere a perimer, premier a sortir) a-t-elle ete respectée sur les 12 derniers mois?","Voir respect FEFO (sur fiches de stock)","Select",{"$f":"IF(D30=\"Select\",\"\",IF(VLOOKUP(D30,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D30,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"La Centrale d’achat et de stockage calcule-t-elle les CMM, les niveaux de stock maxi et mini pour chaque item?","Voir si ces données sont sur fiches de stock ou dans outil de gestion de stock","Select",{"$f":"IF(D31=\"Select\",\"\",IF(VLOOKUP(D31,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D31,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les bons de livraison / bons de réception sont-ils disponibles pour la précédente période?","Voir bons de livraison / bons de réception sur un échantillon de structures sur 12 ders mois","Select",{"$f":"IF(D32=\"Select\",\"\",IF(VLOOKUP(D32,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D32,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]

{"sheet":"3-Distribution","index":3,"n_rows":22,"n_cols":24,"rows_kept":22,"merged":[[0,0,0,6]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"3-Distribution\",\"3-Distribution\"))","v":"3-DISTRIBUTION"},{"$nulls":22},"Select"]
[]
[null,{"$f":"UPPER(\"3.1- Procedures et dispositifs\")","v":"3.1- PROCEDURES ET DISPOSITIFS"},{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IF((SUM(E4:E10))=0,\"\",SUM(E4:E10))","v":""},{"$f":"SUM(F4:F10)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"}]
[null,"Existe t-il des procédures pour la distribution?",null,"Select",{"$f":"IF(VLOOKUP(D4,$H$4:$I$9,2,FALSE)=\"\",\"\",VLOOKUP(D4,$H$4:$I$9,2,FALSE))","v":""},{"$f":"IF(OR(D4=\"Select\",OR(D4=\"Non/Not applicable\")),0,1)","v":0},null,"Select"]
[null,"Existe t-il des procédures pour les distributions d'urgence?",null,"Select","",{"$f":"IF(OR(D5=\"Select\",OR(D5=\"Non/Not applicable\")),0,1)","v":0},null,"Oui, satisfaisant",1]
[null,"Les plans de distribution sont-ils transmis régulièrement par les PRs? A quelle fréquence?","Voir plans de distribution fournis par les PRs sur 12 ders mois","Select","",0,null,"En partie,Peu satisfaisant",0.5]
[null,"Des planning de distribution détaillés ont-ils été élaborés?","Voir planning distribution","Select","",0,null,"En partie,tres peu satisfaisant",0.25]
[null,"Les distributions faites par la Centrale d'achat/stockage sont-elles faites en accord avec les plans de distribution?","Voir bons de distribution sur 2 trimestres versus plans distribution","Select","",0,null,"Non",0]
[null,"Quel est le délai entre reception du plan de distribution et la distribuion effective?","Voir délai sur 12 ders mois","Select","",0,null,"Non applicable"]
[null,"Les conditions de distribution Magasin central - service déconcentré  de la centrale pour les régionaux ou provinciaux) sont-elles adéquates?","Visite moyens logisitiques","Select","",0]
[null,{"$f":"UPPER(\"3.2- Conditions de transport\")","v":"3.2- CONDITIONS DE TRANSPORT"},{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IF((SUM(E12:E18))=0,\"\",SUM(E12:E18))","v":""},{"$f":"SUM(F12:F18)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"}]
[null,"Les conditions de transport permettent de préserver l'intégrité des produit et de garantir les conditions de stockage (température)?",null,"Select",{"$f":"IF(D12=\"Select\",\"\",IF(VLOOKUP(D12,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D12,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D12=\"Select\",OR(D12=\"Non/Not applicable\")),0,1)","v":0}]
[null,"Toutes les précautions sont-elles prises afin de réduire le risque de vol et de fraude?",null,"Select",{"$f":"IF(D13=\"Select\",\"\",IF(VLOOKUP(D13,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D13,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D13=\"Select\",OR(D13=\"Non/Not applicable\")),0,1)","v":0}]
[null,"Les produits sont-ils assurés pendant le transport?",null,"Select",{"$f":"IF(D14=\"Select\",\"\",IF(VLOOKUP(D14,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D14,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Le processus de conditionnement pour le transport des produits en chaine du froid est il validé?",null,"Select",{"$f":"IF(D15=\"Select\",\"\",IF(VLOOKUP(D15,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D15,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Des dispositifs étalonnés sont-ils utilisés pour surveiller les conditions de transport?",null,"Select",{"$f":"IF(D16=\"Select\",\"\",IF(VLOOKUP(D16,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D16,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,{"$f":"UPPER(\"3.3- Enregistrement des livraisons\")","v":"3.3- ENREGISTREMENT DES LIVRAISONS"},{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IF((SUM(E18:E24))=0,\"\",SUM(E18:E24))","v":""},{"$f":"SUM(F18:F24)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"}]
[null,"Les produits sont-ils expédiés uniquement qu'après réception d'un Bon de Livraison détaillé?",null,"Select",{"$f":"IF(D18=\"Select\",\"\",IF(VLOOKUP(D18,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D18,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D18=\"Select\",OR(D18=\"Non/Not applicable\")),0,1)","v":0}]
[null,"Les enregistrements de toutes les livraisons sont -ils conservés et disponibles?",null,"Select",{"$f":"IF(D19=\"Select\",\"\",IF(VLOOKUP(D19,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D19,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D19=\"Select\",OR(D19=\"Non/Not applicable\")),0,1)","v":0}]
[null,"Les enregistrement des livraisons fournissent-ils  toutes les donnees suivantes: Date de livraison; Nom et adresse du client; Description du produit, numéro de lot et quantité; Conditions de transport?",null,"Select",{"$f":"IF(D20=\"Select\",\"\",IF(VLOOKUP(D20,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D20,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Le Bon de Livraison est-il signé par le destinatire des produits?","1 exemplaire est remis au destinataire et 1 exemplaire est retourné à la Centrale d'achat et de stockage","Select",{"$f":"IF(D21=\"Select\",\"\",IF(VLOOKUP(D21,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D21,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Toute anomalie fait -elle l'objet d'une investigation et est suivie de mesures appropriées?",null,"Select",{"$f":"IF(D22=\"Select\",\"\",IF(VLOOKUP(D22,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D22,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]

{"sheet":"4-Rapportage & SIGL","index":4,"n_rows":15,"n_cols":25,"rows_kept":15,"merged":[[0,0,0,7]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"4-Rapportage et SGIL\",\"4-Reports & LMIS\"))","v":"4-RAPPORTAGE ET SGIL"},{"$nulls":23},"Select"]
[]
[null,"4.1- SIGL",{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IF((SUM(E4:E7))=0,\"\",SUM(E4:E7))","v":""},{"$f":"SUM(F4:F7)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"},"Select"]
[null,"Les donnees rapportées par les services déconcentrés  de la centrale(region/procince/..) contiennent -elles les informations necessaires (qu. distribuées, CMM, niveaux de stock…)?","Voir rapports agences régionales au niveau central","Select",{"$f":"IF(D4=\"Select\",\"\",IF(VLOOKUP(D4,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D4,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D4=\"Select\",OR(D4=\"Non/Not applicable\")),0,1)","v":0},null,"Oui, satisfaisant",1]
[null,"Constatez vous souvent des ecarts entre stocks reels et stocks dans les logiciels?",null,"Select",{"$f":"IF(D5=\"Select\",\"\",IF(VLOOKUP(D5,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D5,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D5=\"Select\",OR(D5=\"Non/Not applicable\")),0,1)","v":0},null,"En partie,Peu satisfaisant",0.5]
[null,"Les données de distribution sont-elles compilées par la Centrale d'achat et de stockage? Par les agences?","Voir outil de compilation / données compilées","Select",{"$f":"IF(D6=\"Select\",\"\",IF(VLOOKUP(D6,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D6,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D6=\"Select\",OR(D6=\"Non/Not applicable\")),0,1)","v":0},null,"En partie,tres peu satisfaisant",0.25]
[null,"Le SIGL fonctionne t-il de maniere optimale (en recevant, enregistrant, traitant et avertissant des evenements/incidents)?",null,"Select",{"$f":"IF(D7=\"Select\",\"\",IF(VLOOKUP(D7,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D7,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D7=\"Select\",OR(D7=\"Non/Not applicable\")),0,1)","v":0},null,"Non",0]
[null,"4.2- Rapportage",{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IF((SUM(E9:E15))=0,\"\",SUM(E9:E15))","v":""},{"$f":"SUM(F9:F15)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"},"Non applicable"]
[null,"Existe-t-il un canevas harmonisé de rapportage pour les agences régionales?","Voir canevas disponible","Select",{"$f":"IF(D9=\"Select\",\"\",IF(VLOOKUP(D9,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D9,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D9=\"Select\",OR(D9=\"Non/Not applicable\")),0,1)","v":0}]
[null,"Le canevas de rapportage est-il approprié pour répondre à la demande d'information des PRs?","Voir canevas disponible","Select",{"$f":"IF(D10=\"Select\",\"\",IF(VLOOKUP(D10,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D10,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les copies des BLs du trimestre ont-elles été régulièrement transmises (cf. convention)? Au 30 du mois suivant?",null,"Select",{"$f":"IF(D11=\"Select\",\"\",IF(VLOOKUP(D11,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D11,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Un etat de stocks a-t-il été envoyé trimestriellement à chaque PR et aux SR? Au 30 du mois suivant?",null,"Select",{"$f":"IF(D12=\"Select\",\"\",IF(VLOOKUP(D12,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D12,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"L'état de stock trimestriel inclut-il une analyse des niveaux de stock prenant en compte les dates de péremption? ",null,"Select",{"$f":"IF(D13=\"Select\",\"\",IF(VLOOKUP(D13,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D13,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Les données sur les quantités périmées sont-elles incluses dans le rapport? ",null,"Select",{"$f":"IF(D14=\"Select\",\"\",IF(VLOOKUP(D14,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D14,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"L'inventaire annuel a-t-il été fait (avec les partenaires, cf. convention) et envoyé aux PRs? Au 30 du mois de janvier?","Voir rapport d'inventaire au niveau CAMEG et au niveau PRs","Select",{"$f":"IF(D15=\"Select\",\"\",IF(VLOOKUP(D15,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D15,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]

{"sheet":"5-Controle qualite & Paiement","index":5,"n_rows":11,"n_cols":25,"rows_kept":11,"merged":[[0,0,0,7]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"5-Controle qualite & Paiement\",\"5-Quality control & Clearence\"))","v":"5-CONTROLE QUALITE & PAIEMENT"},{"$nulls":23},"Select"]
[]
[null,"5.1- Contrôle Qualité",{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IF(SUM(E4:E7)=0,\"\",SUM(E4:E7))","v":""},{"$f":"SUM(F4:F7)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"},"Select"]
[null,"La Centrale d'achat/stockage dispose-t-elle de procédures pour le contrôle de qualité prémarketing (allant du prélèvement jusqu'à la réception et transmission des résultats aux PRs). Cette procédure est-elle appliquée?","Voir procédure","Select",{"$f":"IF(D4=\"Select\",\"\",IF(VLOOKUP(D4,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D4,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D4=\"Select\",OR(D4=\"Non/Not applicable\")),0,1)","v":0},null,"Oui, satisfaisant",1]
[null,"Des contrôle qualité ont-ils été réalisés dans le cadre de la précédente convention?","Voir résultats tests CQ","Select",{"$f":"IF(D5=\"Select\",\"\",IF(VLOOKUP(D5,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D5,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D5=\"Select\",OR(D5=\"Non/Not applicable\")),0,1)","v":0},null,"En partie,Peu satisfaisant",0.5]
[null,"Un laboratoire conforme aux exigences FM a-t-il été sélectionné? Si oui selon quelle procédure?","Voir processus sélection labo","Select",{"$f":"IF(D6=\"Select\",\"\",IF(VLOOKUP(D6,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D6,Calc!$C$34:$D$39,2,FALSE)))","v":""},0,null,"En partie,tres peu satisfaisant",0.25]
[null,"Les documents de qualité ont-ils été transmis aux PRs (certificats d'analyse fournisseurs, fiche de notification CQ prémarketing, résultats tests CQ)?",null,"Select",{"$f":"IF(D7=\"Select\",\"\",IF(VLOOKUP(D7,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D7,Calc!$C$34:$D$39,2,FALSE)))","v":""},0,null,"Non",0]
[null,"5.2- Modalités de paiement",{"$f":"UPPER(IF(Setup!L8=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L8=1,\"Reponse\",\"Response\"))","v":"REPONSE"},{"$f":"IF(SUM(E9:E11)=0,\"\",SUM(E9:E11))","v":""},{"$f":"SUM(F9:F11)","v":0},{"$f":"UPPER(IF(Setup!L8=1,\"Observations\",\"Notes\"))","v":"OBSERVATIONS"},"Non applicable"]
[null,"Les factures de la Centrale d'achat et de stockage ont-elles été émises (pour les frais d'approche, pour les frais de gestion, pour les frais de stockage et distribution)? Avec docs justificatifs?","Voir factures envoyées PRs","Select",{"$f":"IF(D9=\"Select\",\"\",IF(VLOOKUP(D9,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D9,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D9=\"Select\",OR(D9=\"Non/Not applicable\")),0,1)","v":0}]
[null,"Les paiements ont-ils été faits xx% à la signature des cotations et xx% après transmission des derniers documents de réception (comme prévu dans la convention)?",null,"Select",{"$f":"IF(D10=\"Select\",\"\",IF(VLOOKUP(D10,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D10,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"Tous les documents justificatifs ont-ils été fournis pour le paiement (facture Centrale d'achat/stockage, copie factures fournisseurs, attestation de destination, admission en franchise, estimation valeur CIF, PV réception)?","Voir factures émises et pièces justificatives?","Select",{"$f":"IF(D11=\"Select\",\"\",IF(VLOOKUP(D11,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D11,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]

{"sheet":"6-Normes stockage","index":6,"n_rows":37,"n_cols":9,"rows_kept":37,"merged":[[0,0,0,7]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"normes de stockage\",\"storage standards\"))","v":"NORMES DE STOCKAGE"}]
[]
[null,"6.1 Sécurité incendie",{"$f":"UPPER(IF(Setup!L22=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L22=1,\"Reponse\",\"Response\"))","v":"RESPONSE"},{"$f":"IF(SUM(E4:E14)=0,\"\",SUM(E4:E14))","v":""},{"$f":"SUM(F4:F14)","v":0},{"$f":"'5-Controle qualite & Paiement'!I3","v":0}]
["6.1.1","Il existe un document de politique et de procedures de lutte contre les incendies","Demander à voir le document (existence, ventilation/ diffusion)","Select",{"$f":"IF(D4=\"Select\",\"\",IF(VLOOKUP(D4,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D4,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D4=\"Select\",OR(D4=\"Non/Not applicable\")),0,1)","v":0}]
["6.1.2","Il existe un point focal lutte contre les incendies ","Voire l'acte de nomination/ désignation","Select",{"$f":"IF(D5=\"Select\",\"\",IF(VLOOKUP(D5,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D5,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D5=\"Select\",OR(D5=\"Non/Not applicable\")),0,1)","v":0}]
["6.1.3","Le personnel de la Centrale d'achat a été formé aux techniques de lutte anti-incendie (procédures, utilisation du matériel, documentation)","Vérifier si des exercices sont régulièrement conduits","Select",{"$f":"IF(D6=\"Select\",\"\",IF(VLOOKUP(D6,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D6,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D6=\"Select\",OR(D6=\"Non/Not applicable\")),0,1)","v":0}]
["6.1.4","Le personnel de la société de gardiennage ont été formés à  la lutte anti-incendie (procédures, utilisation du matériel, documentation)","Vérifier si des exercices sont régulièrement conduits","Select",{"$f":"IF(D7=\"Select\",\"\",IF(VLOOKUP(D7,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D7,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.1.5","Il existe des dispositifs sonore d'alerte anti-incendie fonctionnels","Vérifier que les dispoitifs sont sonores et sont autonomes et non branchés au courant électrique","Select",{"$f":"IF(D8=\"Select\",\"\",IF(VLOOKUP(D8,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D8,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.1.6","il existe des bombonnes anti-incendie non périmé","Vérifier les dates de pérémption","Select",{"$f":"IF(D9=\"Select\",\"\",IF(VLOOKUP(D9,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D9,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.1.7","La fonctionalité des Bombonnes est périodiquement vérifiée","Vérifier la programmation et la réalisation des vérifications","Select",{"$f":"IF(D10=\"Select\",\"\",IF(VLOOKUP(D10,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D10,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.1.8","L'emplcement et la disposition des bombonnes /bornes anti-incendie sont adéquats",null,"Select",{"$f":"IF(D11=\"Select\",\"\",IF(VLOOKUP(D11,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D11,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.1.9","Les rangements ne favorisent pas un départ d'incendie","vérifier la proximité des rideaux, cartons, papiers avec les prises électriques par exemple","Select",{"$f":"IF(D12=\"Select\",\"\",IF(VLOOKUP(D12,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D12,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.1.10","Il est formellement interdit de fumer dans les locaux de la Centrale (notamment endroits proches des magasins)","Vérifier l'existence d'affiches, de note et de fouille à l'approche des magasins","Select",{"$f":"IF(D13=\"Select\",\"\",IF(VLOOKUP(D13,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D13,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.1.11","Il existe une assurance anti-incendie en cours de validité et qui couvre le montant du risque","Demandr à vérifier le contrat et comparer avec les autres années et à la valeur des intrants","Select",{"$f":"IF(D14=\"Select\",\"\",IF(VLOOKUP(D14,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D14,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"6.2 Sécurité physique",{"$f":"UPPER(IF(Setup!L22=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L22=1,\"Reponse\",\"Response\"))","v":"RESPONSE"},{"$f":"IF(SUM(E16:E21)=0,\"\",SUM(E16:E21))","v":0.5},{"$f":"SUM(F16:F21)","v":1},{"$f":"UPPER(IF(Setup!L22=1,\"Observations\",\"Notes\"))","v":"NOTES"}]
["6.2.1","Les murs d'enceinte de la centrale d'achat sont innacessibles","Voire la hauteur, existence de barbelées simples ou électriques","Select",{"$f":"IF(D16=\"Select\",\"\",IF(VLOOKUP(D16,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D16,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D16=\"Select\",OR(D16=\"Non/Not applicable\")),0,1)","v":0}]
["6.2.2","Les magasins sont éloignés des murs de clôture","Vérifir la distance entre les magasins et les murs de clôture (environ 3-5 mètres)","Select",{"$f":"IF(D17=\"Select\",\"\",IF(VLOOKUP(D17,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D17,Calc!$C$34:$D$39,2,FALSE)))","v":""},0,null,null,{"$f":"SUM(E16:E17)","v":0}]
["6.2.3","Les magasiins dispose de cadenas (uniquemen accessibles par le personnel approprié-magasinier)","Vérifier qu'il n'y a pas de multiples personnes pouvant ouvrir seul les magasins, vérifier l'existence et la qualité des cadenas","Select",{"$f":"IF(D18=\"Select\",\"\",IF(VLOOKUP(D18,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D18,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.2.4","il existe un coffret sécurisé pour les clés des magasins","Vérifier que les clés ne sont pas emportés à la maison par le magasinier et l'exitence d'un coffret de stockage des clés","Select",{"$f":"IF(D19=\"Select\",\"\",IF(VLOOKUP(D19,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D19,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.2.5","En cas d'incendie/ départ de feu, il existe des procédures de forçage des portes","Vérifier l'existence d'une procédure écrite","En partie,Peu satisfaisant",{"$f":"IF(D20=\"Select\",\"\",IF(VLOOKUP(D20,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D20,Calc!$C$34:$D$39,2,FALSE)))","v":0.5},1]
["6.2.6","Il existe un journal tenu à jour sur l'ourverture, la fermeture et les incidents concernant la sécuroté des magasins",null,"Select",{"$f":"IF(D21=\"Select\",\"\",IF(VLOOKUP(D21,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D21,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"6.3 Assurance qualité du stockage",{"$f":"UPPER(IF(Setup!L26=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L26=1,\"Reponse\",\"Response\"))","v":"RESPONSE"},{"$f":"IF(SUM(E23:E29)=0,\"\",SUM(E23:E29))","v":0.25},{"$f":"SUM(F23:F29)","v":1},{"$f":"UPPER(IF(Setup!L26=1,\"Observations\",\"Notes\"))","v":"NOTES"}]
["6.3.1","Tous les produis sont entreposés sur des palettes",null,"Select",{"$f":"IF(D23=\"Select\",\"\",IF(VLOOKUP(D23,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D23,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D23=\"Select\",OR(D23=\"Non/Not applicable\")),0,1)","v":0}]
["6.3.2","La disposition des pallettes est conforme aux normes","Vérifier la qualité du rangement, vérifier que l'existence d'espace entre les pallettes et le toit des magasins","Select",{"$f":"IF(D24=\"Select\",\"\",IF(VLOOKUP(D24,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D24,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D24=\"Select\",OR(D24=\"Non/Not applicable\")),0,1)","v":0}]
["6.3.3","Les dispositifs de surveillance de la température sont fonctionnels","Existence de thermomètre, relèvement périodique de la température","En partie,tres peu satisfaisant",{"$f":"IF(D25=\"Select\",\"\",IF(VLOOKUP(D25,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D25,Calc!$C$34:$D$39,2,FALSE)))","v":0.25},{"$f":"IF(OR(D25=\"Select\",OR(D25=\"Non/Not applicable\")),0,1)","v":1}]
["6.3.4","Les dispositifs de surveillance de la température fait l'objet de monitorage et d'attention","Rapport de contrôle, discussion dans les stafs","Select",{"$f":"IF(D26=\"Select\",\"\",IF(VLOOKUP(D26,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D26,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.3.5","Les magasins sont imperméables à la poussière et aux infiltrations d'eau",null,"Select",{"$f":"IF(D27=\"Select\",\"\",IF(VLOOKUP(D27,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D27,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.3.6","Les magasins sont exemptes d'humidité",null,"Select",{"$f":"IF(D28=\"Select\",\"\",IF(VLOOKUP(D28,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D28,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.3.7","Les locaux de magasins sont propres ainsi que le personnel y travaillant","Prendre en compte l'ensemble des locaux de la centrale d'achat","Select",{"$f":"IF(D29=\"Select\",\"\",IF(VLOOKUP(D29,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D29,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
[null,"6.4 Etat des moyens de manutention",{"$f":"UPPER(IF(Setup!L30=1,\"Source/Details\",\"Source/Details\"))","v":"SOURCE/DETAILS"},{"$f":"UPPER(IF(Setup!L30=1,\"Reponse\",\"Response\"))","v":"RESPONSE"},{"$f":"IF(SUM(E31:E37)=0,\"\",SUM(E31:E37))","v":""},{"$f":"SUM(F31:F37)","v":0},{"$f":"UPPER(IF(Setup!L30=1,\"Observations\",\"Notes\"))","v":"NOTES"}]
["6.4.1","Il existe des moyens de manutention fonctionnels pour déplacer les pallettes en toute sécurité","véririer l'existence et la fontionnalité","Select",{"$f":"IF(D31=\"Select\",\"\",IF(VLOOKUP(D31,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D31,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D31=\"Select\",OR(D31=\"Non/Not applicable\")),0,1)","v":0}]
["6.4.2","Tous les caristes ont-ils été formés à l'utilisation (conduite, entretien) des moyens de mnutention",null,"Select",{"$f":"IF(D32=\"Select\",\"\",IF(VLOOKUP(D32,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D32,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.4.3","Les moyens de manutention sont adaptés et utilisés pour déplacer les palettes",null,"Select",{"$f":"IF(D33=\"Select\",\"\",IF(VLOOKUP(D33,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D33,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.4.4","D'autres personnes non dédiées utilisent-elles les moyens de manutention?",null,"Select",{"$f":"IF(D34=\"Select\",\"\",IF(VLOOKUP(D34,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D34,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D34=\"Select\",OR(D34=\"Non/Not applicable\")),0,1)","v":0}]
["6.4.5","Il existe des moyens roulants fonctionnels et adaptés aux types de produits gérés ","Prendre en compte les intrants froids et non froids, les intrants solides et liquides, dangereux et non dangereux)","Select",{"$f":"IF(D35=\"Select\",\"\",IF(VLOOKUP(D35,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D35,Calc!$C$34:$D$39,2,FALSE)))","v":""},0]
["6.4.6","Seuls les moyens de manutention sont  utilisés pour déplacer les palettes ",null,"Select",{"$f":"IF(D36=\"Select\",\"\",IF(VLOOKUP(D36,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D36,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D36=\"Select\",OR(D36=\"Non/Not applicable\")),0,1)","v":0}]
["6.4.7","Seuls les moyens de manutention sont  utilisés pour déplacer à l'intérieur du pays lors de la distribution",null,"Select",{"$f":"IF(D37=\"Select\",\"\",IF(VLOOKUP(D37,Calc!$C$34:$D$39,2,FALSE)=\"\",\"\",VLOOKUP(D37,Calc!$C$34:$D$39,2,FALSE)))","v":""},{"$f":"IF(OR(D37=\"Select\",OR(D37=\"Non/Not applicable\")),0,1)","v":0}]

{"sheet":"Calc","index":7,"n_rows":71,"n_cols":20,"rows_kept":71,"hidden":true}
[]
["Recapitulatif"]
["1. Recepetion & Dedouanement",{"$nulls":18},"somme"]
[null,null,"1. Arrivee des produits",{"$f":"T4","v":""},{"$f":"IFERROR(D4*20/('1-Reception & Dedouanement'!E6+'1-Reception & Dedouanement'!E8),\"\")","v":""},{"$f":"'1-Reception & Dedouanement'!D6","v":""},{"$f":"'1-Reception & Dedouanement'!D8","v":""},{"$nulls":12},{"$f":"IF(AND(F4=\"\",AND(G4=\"\")),\"\",SUM(F4:S4))","v":""}]
[null,null,"2. Dedouanement des produits",{"$f":"T5","v":""},{"$f":"IFERROR(D5*20/('1-Reception & Dedouanement'!E7+'1-Reception & Dedouanement'!E10),\"\")","v":""},{"$f":"'1-Reception & Dedouanement'!D7","v":""},{"$f":"'1-Reception & Dedouanement'!D10","v":""},{"$nulls":12},{"$f":"IF(AND(F5=\"\",AND(G5=\"\")),\"\",SUM(F5:S5))","v":""}]
[null,null,"3. Suivi et conformite","",{"$f":"IFERROR(D6*20/('1-Reception & Dedouanement'!E11+'1-Reception & Dedouanement'!E9),\"\")","v":""},{"$f":"'1-Reception & Dedouanement'!D11","v":""},{"$f":"'1-Reception & Dedouanement'!D9","v":""},{"$nulls":12},{"$f":"IF(AND(F6=\"\",AND(G6=\"\")),\"\",SUM(F6:S6))","v":""}]
["2. Stockage et gestion"]
[null,null,"procedures de stockage",{"$f":"T8","v":""},{"$f":"IFERROR((D8*20/('2-Stockage & Gestion'!F4+'2-Stockage & Gestion'!F5)),\"\")","v":""},"b3-4",{"$f":"'2-Stockage & Gestion'!E4","v":""},{"$f":"'2-Stockage & Gestion'!E5","v":""},{"$nulls":11},{"$f":"IF(AND(H8=\"\",AND(G8=\"\")),\"\",SUM(G8:S8))","v":""}]
[null,null,"condition de stockage","",{"$f":"IFERROR((D9*20/SUM('2-Stockage & Gestion'!F6:F18)),\"\")","v":""},"b5-17",{"$f":"'2-Stockage & Gestion'!E6","v":""},{"$f":"'2-Stockage & Gestion'!E7","v":""},{"$f":"'2-Stockage & Gestion'!E8","v":""},{"$f":"'2-Stockage & Gestion'!E9","v":""},{"$f":"'2-Stockage & Gestion'!E10","v":""},{"$f":"'2-Stockage & Gestion'!E11","v":""},{"$f":"'2-Stockage & Gestion'!E12","v":""},{"$f":"'2-Stockage & Gestion'!E13","v":""},{"$f":"'2-Stockage & Gestion'!E14","v":""},{"$f":"'2-Stockage & Gestion'!E15","v":""},{"$f":"'2-Stockage & Gestion'!E16","v":""},{"$f":"'2-Stockage & Gestion'!E17","v":""},{"$f":"'2-Stockage & Gestion'!E18","v":""},{"$f":"IF(AND(H9=\"\",AND(G9=\"\",AND(I9=\"\",AND(J9=\"\",AND(K9=\"\",AND(L9=\"\",AND(M9=\"\",AND(N9=\"\",AND(O9=\"\",AND(P9=\"\",AND(Q9=\"\",AND(R9=\"\",AND(S9=\"\"))))))))))))),\"\",SUM(G9:S9))","v":""}]
[null,null,"Systeme de gestion","",{"$f":"IFERROR((D10*20/SUM('2-Stockage & Gestion'!F20:F25)),\"\")","v":""},"b19-24",{"$f":"'2-Stockage & Gestion'!E20","v":""},{"$f":"'2-Stockage & Gestion'!E21","v":""},{"$f":"'2-Stockage & Gestion'!E22","v":""},{"$f":"'2-Stockage & Gestion'!E23","v":""},{"$f":"'2-Stockage & Gestion'!E24","v":""},{"$f":"'2-Stockage & Gestion'!E25","v":""},{"$nulls":7},{"$f":"IF(AND(H10=\"\",AND(G10=\"\",AND(I10=\"\",AND(J10=\"\",AND(K10=\"\",AND(L10=\"\")))))),\"\",SUM(G10:S10))","v":""}]
[null,null,"Outils de gestion","",{"$f":"IFERROR((D11*20/SUM('2-Stockage & Gestion'!F26:F29)),\"\")","v":""},"b25-28",{"$f":"'2-Stockage & Gestion'!E26","v":""},{"$f":"'2-Stockage & Gestion'!E27","v":""},{"$f":"'2-Stockage & Gestion'!E28","v":""},{"$f":"'2-Stockage & Gestion'!E29","v":""},{"$nulls":9},{"$f":"IF(AND(H11=\"\",AND(G11=\"\",AND(I11=\"\",AND(J11=\"\")))),\"\",SUM(G11:S11))","v":""}]
[null,null,"Regles et CCM","",{"$f":"IFERROR((D12*20/SUM('2-Stockage & Gestion'!F30:F32)),\"\")","v":""},"b29-31",{"$f":"'2-Stockage & Gestion'!E30","v":""},{"$f":"'2-Stockage & Gestion'!E31","v":""},{"$f":"'2-Stockage & Gestion'!E32","v":""},{"$nulls":10},{"$f":"IF(AND(H12=\"\",AND(G12=\"\",AND(I12=\"\"))),\"\",SUM(G12:S12))","v":""}]
["3. Distribution"]
[null,null,"Procedures et dispositifs","",{"$f":"IFERROR((D14*20/7),\"\")","v":""},{"$f":"'3-Distribution'!E3","v":""},{"$nulls":13},{"$f":"IF(F14=\"\",\"\",SUM(F14:S14))","v":""}]
[null,null,"Condition de transport","",{"$f":"IFERROR((D15*20/5),\"\")","v":""},{"$f":"'3-Distribution'!E11","v":""},{"$nulls":13},{"$f":"IF(F15=\"\",\"\",SUM(F15:S15))","v":""}]
[null,null,"Enregistrement des livraisons","",{"$f":"IFERROR((D16*20/5),\"\")","v":""},{"$f":"'3-Distribution'!E17","v":""},{"$nulls":13},""]
["4. Rapportage et SGIL"]
[null,null,"SIGL","",{"$f":"IFERROR((D18*20/2),\"\")","v":""},{"$f":"'4-Rapportage & SIGL'!E3","v":""},{"$nulls":13},{"$f":"IF(F18=\"\",\"\",SUM(F18:S18))","v":""}]
[null,null,"Rapportage","",{"$f":"IFERROR((D19*20/7),\"\")","v":""},{"$f":"'4-Rapportage & SIGL'!E8","v":""},{"$nulls":13},""]
["5. Controle qualite et paiement"]
[null,null,"Controle qualite","",{"$f":"IFERROR((D21*20/'5-Controle qualite & Paiement'!F3),\"\")","v":""},{"$f":"'5-Controle qualite & Paiement'!E3","v":""},{"$nulls":13},{"$f":"IF(F21=\"\",\"\",SUM(F21:S21))","v":""}]
[null,null,"Paiement","",{"$f":"IFERROR((D22*20/'5-Controle qualite & Paiement'!F8),\"\")","v":""},{"$f":"'5-Controle qualite & Paiement'!E8","v":""},{"$nulls":13},{"$f":"IF(F22=\"\",\"\",SUM(F22:S22))","v":""}]
["6. Normes de stockage"]
[null,null,"Sécurité incendie","",{"$f":"IFERROR((D24*20/'6-Normes stockage'!F3),\"\")","v":""},{"$f":"'6-Normes stockage'!E3","v":""},{"$nulls":13},{"$f":"IF(F24=\"\",\"\",SUM(F24:S24))","v":""}]
[null,null,"Sécurité physique (accès)",0.5,{"$f":"IFERROR((D25*20/'6-Normes stockage'!F15),\"\")","v":10},{"$f":"'6-Normes stockage'!E15","v":0.5},{"$nulls":13},0.5]
[null,null,"Assurance qualité du stockage",0.25,{"$f":"IFERROR((D26*20/'6-Normes stockage'!F22),\"\")","v":5},{"$f":"'6-Normes stockage'!E22","v":0.25},{"$nulls":13},0.25]
[null,null,"Etat des moyens de manutention","",{"$f":"IFERROR((D27*20/'6-Normes stockage'!F30),\"\")","v":""},{"$f":"'6-Normes stockage'!E30","v":""},{"$nulls":13},""]
[null,"6.1"]
[null,null,"Select"]
[null,null,"Oui",1]
[null,null,"Non",0]
[null,null,"Non applicable"]
[]
[null,null,"Select",0]
[null,null,"Oui, satisfaisant",1]
[null,null,"En partie,Peu satisfaisant",0.5]
[null,null,"En partie,tres peu satisfaisant",0.25]
[null,null,"Non",0]
[null,null,"Non applicable"]
[]
[null,null,"Select"]
[null,null,"1-Conditions de reception et de deduanement"]
[null,null,"2.1-Stockage des produits"]
[null,null,"2.2--Gestion des produits"]
[null,null,"3-Distribution des produits"]
[null,null,"4-1-SIGL"]
[null,null,"4.2- Stockage"]
[null,null,"5.1- Controle qualite"]
[null,null,"5.2- Modalites de paiement"]
[null,null,"6.1-Sécurité incendie"]
[null,null,"6.2-Sécurité physique (accès)"]
[null,null,"6.3-Assurance qualité du stockage"]
[null,null,"6.4Etat des moyens de manutention"]
[]
[]
[null,null,"Select"]
[null,null,"Nouvelle activité"]
[null,null,"Nouveau Appui technique"]
[null,null,"Appui technique/Activité finalisé"]
[null,null,"Appui technique/Activité en cours"]
[null,null,"Appui technique/Activité non débuté"]
[]
[null,null,"Select \"année\""]
[null,null,2018]
[null,null,2019]
[null,null,2020]
[null,null,2021]
[null,null,2022]
[null,null,2023]
[null,null,2024]
[null,null,2025]

{"sheet":"Orientations","index":8,"n_rows":30,"n_cols":18,"rows_kept":30,"merged":[[0,0,0,10],[2,0,2,1],[2,6,2,7],[6,6,6,7],[9,0,9,1],[10,6,10,7],[14,6,14,7],[16,0,16,1],[17,6,17,7],[20,6,20,7],[21,0,21,1],[25,0,25,1],[26,6,26,7]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"Orientations pour le plan d'amelioration\",\"orientations for the improvement actions plan\"))","v":"ORIENTATIONS POUR LE PLAN D'AMELIORATION"}]
[]
["1-Conditions de reception et de deduanement",null,"Notes","Quest","Notes pond",null,"3-Distribution des produits",null,"Notes","Quest","Notes pond",null,null,{"$f":"A3","v":"1-Conditions de reception et de deduanement"}]
[null,"Arrivee des produits a l'aeroport",{"$f":"'1-Reception & Dedouanement'!D6","v":""},5,{"$f":"IFERROR(C4*20/1,\"\")","v":""},null,null,"Procedures et dispositifs",{"$f":"'3-Distribution'!E3","v":""},"e2",{"$f":"IFERROR(I4*20/1,\"\")","v":""},null,null,{"$f":"A10","v":"2.1-Stockage des produits"}]
[null,"Performance en matiere de reception/dedouanement",{"$f":"'1-Reception & Dedouanement'!D7","v":""},6,"",null,null,"Conditions de transport lors de la distribution",{"$f":"'3-Distribution'!E11","v":""},"e10",{"$f":"IFERROR(I5*20/1,\"\")","v":""},null,null,{"$f":"A17","v":"2.2--Gestion des produits"}]
[null,"Reception provisoire",{"$f":"'1-Reception & Dedouanement'!D8","v":""},7,"",null,null,"Enregistrement des livraisons",{"$f":"'3-Distribution'!E17","v":""},"e16",{"$f":"IFERROR(I6*20/1,\"\")","v":""},null,null,{"$f":"G3","v":"3-Distribution des produits"}]
[null,"Conformite des produits recus",{"$f":"'1-Reception & Dedouanement'!D9","v":""},8,"",null,"4-1-SIGL",{"$nulls":6},{"$f":"G7","v":"4-1-SIGL"}]
[null,"Suivi des receptions des produits PPM",{"$f":"'1-Reception & Dedouanement'!D10","v":""},9,"",null,null,"Completude des informations",{"$f":"'4-Rapportage & SIGL'!E4","v":""},4,{"$f":"IFERROR(I8*20/1,\"\")","v":""},null,null,{"$f":"G11","v":"4.2- Stockage"}]
[null,"Transmission de la liste des produits aux PRs",{"$f":"'1-Reception & Dedouanement'!D11","v":""},10,"",null,null,"Gestion des ecarts d'information",{"$f":"'4-Rapportage & SIGL'!E5","v":""},5,{"$f":"IFERROR(I9*20/1,\"\")","v":""},null,null,{"$f":"G15","v":"5.1- Controle qualite"}]
["2.1-Stockage des produits",{"$nulls":6},"Fonctionnement du SIGL",{"$f":"IFERROR(('4-Rapportage & SIGL'!E6+'4-Rapportage & SIGL'!E7),\"\")","v":""},"6;7",{"$f":"IFERROR(I10*20/2,\"\")","v":""},null,null,{"$f":"G18","v":"5.2- Modalites de paiement"}]
[null,"Qualite du stockage",{"$f":"IFERROR(('2-Stockage & Gestion'!E4+'2-Stockage & Gestion'!E5+'2-Stockage & Gestion'!E6+'2-Stockage & Gestion'!E7+'2-Stockage & Gestion'!E8),\"\")","v":""},"3;4;5;6;7",{"$f":"IFERROR(C11*20/5,\"\")","v":""},null,"4.2- Stockage"]
[null,"Thermometre",{"$f":"'2-Stockage & Gestion'!E9","v":""},8,{"$f":"IFERROR(C12*20/1,\"\")","v":""},null,null,"Canevas de rapportage",{"$f":"IFERROR(('4-Rapportage & SIGL'!E9+'4-Rapportage & SIGL'!E10),\"\")","v":""},"9;10",{"$f":"IFERROR(I12*20/2,\"\")","v":""}]
[null,"Mesures anti-incendie",{"$f":"IFERROR(('2-Stockage & Gestion'!E10+'2-Stockage & Gestion'!E11),\"\")","v":""},"9;10",{"$f":"IFERROR(C13*20/2,\"\")","v":""},null,null,"Transmission des etats de stocks aux PRs",{"$f":"IFERROR(('4-Rapportage & SIGL'!E11+'4-Rapportage & SIGL'!E12+'4-Rapportage & SIGL'!E13),\"\")","v":""},"11;12;13",{"$f":"IFERROR(I13*20/3,\"\")","v":""}]
[null,"lieu et qualite de rangement/entreposage",{"$f":"IFERROR(('2-Stockage & Gestion'!E12+'2-Stockage & Gestion'!E13+'2-Stockage & Gestion'!E14),\"\")","v":""},"11;12;13",{"$f":"IFERROR(C14*20/3,\"\")","v":""},null,null,"Inventaire et gestion des peremptions",{"$f":"IFERROR(('4-Rapportage & SIGL'!E14+'4-Rapportage & SIGL'!E15),\"\")","v":""},"14;15",{"$f":"IFERROR(I14*20/2,\"\")","v":""}]
[null,"Gestion des produits perimes",{"$f":"IFERROR(('2-Stockage & Gestion'!E15+'2-Stockage & Gestion'!E16+'2-Stockage & Gestion'!E17),\"\")","v":""},"14;15;16",{"$f":"IFERROR(C15*20/3,\"\")","v":""},null,"5.1- Controle qualite"]
[null," Assurance des produits stockes",{"$f":"'2-Stockage & Gestion'!E18","v":""},17,{"$f":"IFERROR(C16*20/1,\"\")","v":""},null,null,"Procedures de controle qualite",{"$f":"'5-Controle qualite & Paiement'!E4","v":""},4,{"$f":"IFERROR(I16*20/1,\"\")","v":""}]
["2.2--Gestion des produits",{"$nulls":6},"Realisation du controle qualite",{"$f":"IFERROR(('5-Controle qualite & Paiement'!E5+'5-Controle qualite & Paiement'!E6+'5-Controle qualite & Paiement'!E7),\"\")","v":""},"5;6;7",{"$f":"IFERROR(I17*20/3,\"\")","v":""}]
[null,"Systeme de gestion",{"$f":"IFERROR(('2-Stockage & Gestion'!E20+'2-Stockage & Gestion'!E21),\"\")","v":""},"19;20",{"$f":"IFERROR(C18*20/2,\"\")","v":""},null,"5.2- Modalites de paiement"]
[null,"Gestion des mouvements",{"$f":"IFERROR(('2-Stockage & Gestion'!E22+'2-Stockage & Gestion'!E23+'2-Stockage & Gestion'!E24),\"\")","v":""},"21;22;23",{"$f":"IFERROR(C19*20/3,\"\")","v":""},null,null,"Emission des paiements",{"$f":"IFERROR(('5-Controle qualite & Paiement'!E9+'5-Controle qualite & Paiement'!E10),\"\")","v":""},"9;10",{"$f":"IFERROR(I19*20/2,\"\")","v":""}]
[null,"Inventaires",{"$f":"'2-Stockage & Gestion'!E25","v":""},24,{"$f":"IFERROR(C20*20/1,\"\")","v":""},null,null,"Justificatifs des paiements",{"$f":"'5-Controle qualite & Paiement'!E11","v":""},11,{"$f":"IFERROR(I20*20/1,\"\")","v":""}]
[null,"Outils de gestion",{"$f":"IFERROR(('2-Stockage & Gestion'!E26+'2-Stockage & Gestion'!E27+'2-Stockage & Gestion'!E28+'2-Stockage & Gestion'!E29+'2-Stockage & Gestion'!E30+'2-Stockage & Gestion'!E31+'2-Stockage & Gestion'!E32),\"\")","v":""},"25;26;27;28;29;30;31",{"$f":"IFERROR(C21*20/7,\"\")","v":""},null,"6.1 Sécurité incendie",{"$nulls":3},"&"]
["6.3 Assurance qualité du stockage",{"$nulls":3},"&",null,null,"Procédures et politiques anti-incendie",{"$f":"IFERROR((L22+M22+Q22),\"\")","v":0},"6.1.1;6.1.2;6110",{"$f":"IFERROR(I22*20/('6-Normes stockage'!F4+'6-Normes stockage'!F5+'6-Normes stockage'!F13),\"\")","v":""},{"$f":"IF('6-Normes stockage'!E4=\"\",0,'6-Normes stockage'!E4)","v":0},{"$f":"IF('6-Normes stockage'!E5=\"\",0,'6-Normes stockage'!E5)","v":0},{"$nulls":3},{"$f":"IF('6-Normes stockage'!E13=\"\",0,'6-Normes stockage'!E13)","v":0}]
[null,"Entreposage des produits",{"$f":"IFERROR(('6-Normes stockage'!E23+'6-Normes stockage'!E24),\"\")","v":""},"631;632",{"$f":"IFERROR((C23*20/('6-Normes stockage'!F23+'6-Normes stockage'!F24)),\"\")","v":""},null,null,"Dispositifs anti-incendie",{"$f":"IFERROR((L23+M23+Q23+R23),\"\")","v":0},"615;616;618;619",{"$f":"IFERROR((I23*20/('6-Normes stockage'!F8+'6-Normes stockage'!F9+'6-Normes stockage'!F11+'6-Normes stockage'!F12)),\"\")","v":""},{"$f":"IF('6-Normes stockage'!E8=\"\",0,'6-Normes stockage'!E8)","v":0},{"$f":"IF('6-Normes stockage'!E9=\"\",0,'6-Normes stockage'!E9)","v":0},{"$nulls":3},{"$f":"IF('6-Normes stockage'!E10=\"\",0,'6-Normes stockage'!E10)","v":0},{"$f":"IF('6-Normes stockage'!E11=\"\",0,'6-Normes stockage'!E11)","v":0}]
[null,"Maintien de la température adéquate",{"$f":"IFERROR(('6-Normes stockage'!E25+'6-Normes stockage'!E26),\"\")","v":""},"633;634",{"$f":"IFERROR((C24*20/('6-Normes stockage'!F25+'6-Normes stockage'!F26)),\"\")","v":""},null,null,"Fonctionnalité des dispositis anti-incendie",{"$f":"IFERROR((L24+M24),\"\")","v":0},"616;617",{"$f":"IFERROR((I24*20/('6-Normes stockage'!F9+'6-Normes stockage'!F10)),\"\")","v":""},{"$f":"IF('6-Normes stockage'!E9=\"\",0,'6-Normes stockage'!E9)","v":0},{"$f":"IF('6-Normes stockage'!E10=\"\",0,'6-Normes stockage'!E10)","v":0}]
[null,"Propreté et imperméabilité des locaux",{"$f":"IFERROR(('6-Normes stockage'!E27+'6-Normes stockage'!E28+'6-Normes stockage'!E29),\"\")","v":""},"635;636;637",{"$f":"IFERROR((C25*20/('6-Normes stockage'!F27+'6-Normes stockage'!F28+'6-Normes stockage'!F29)),\"\")","v":""},null,null,"Capacité de lutte contre les incendies",{"$f":"IFERROR(('6-Normes stockage'!E6+'6-Normes stockage'!E7),\"\")","v":""},"613;614",{"$f":"IFERROR((I25*20/('6-Normes stockage'!F6+'6-Normes stockage'!F7)),\"\")","v":""},"x"]
["6.4 Etat des moyens de manutention",{"$nulls":6},"Assurance anti-incendie",{"$f":"'6-Normes stockage'!E14","v":""},"6.1.11",{"$f":"IFERROR(I26*20/1,\"\")","v":""}]
[null,"Existence de moyens adéquats de manutention",{"$f":"IFERROR(SUM('6-Normes stockage'!E31+'6-Normes stockage'!E35+'6-Normes stockage'!E33),\"\")","v":""},"641;643;645",{"$f":"IFERROR(C27*20/('6-Normes stockage'!F31+'6-Normes stockage'!E35+'6-Normes stockage'!F33),\"\")","v":""},null,"6.2 Sécurité phyique des locaux",{"$nulls":3},"&"]
[null,"Capacité à utiliser les moyens de manutention",{"$f":"IFERROR(SUM('6-Normes stockage'!E32+'6-Normes stockage'!E34),\"\")","v":""},"644;642;",{"$f":"IFERROR(C28*20/('6-Normes stockage'!F32+'6-Normes stockage'!F34),\"\")","v":""},null,null,"Sécurité d'accès à la cours de la Centrale d'achat",{"$f":"L28+M28","v":0},"621;622",{"$f":"IFERROR((I28*20/SUM('6-Normes stockage'!F16+'6-Normes stockage'!F17)),\"\")","v":""},{"$f":"IF('6-Normes stockage'!E16=\"\",0,'6-Normes stockage'!E16)","v":0},{"$f":"IF('6-Normes stockage'!E17=\"\",0,'6-Normes stockage'!E17)","v":0}]
[null,"Utilisation adéquate des moyens de moyens de manutention",{"$f":"IFERROR(SUM('6-Normes stockage'!E36+'6-Normes stockage'!E37),\"\")","v":""},"646;647",{"$f":"IFERROR(C29*20/('6-Normes stockage'!F36+'6-Normes stockage'!F37),\"\")","v":""},null,null,"Sécurité d'accès à l'intérieur des magasins de la centrale",{"$f":"IFERROR(SUM(L29+M29+Q29+R29),\"\")","v":0.25},"623;624;625;626",{"$f":"IFERROR((I29*20/('6-Normes stockage'!F18+'6-Normes stockage'!F21+'6-Normes stockage'!F19+'6-Normes stockage'!F20)),\"\")","v":5},{"$f":"IF('6-Normes stockage'!E23=\"\",0,'6-Normes stockage'!E23)","v":0},{"$f":"IF('6-Normes stockage'!E24=\"\",0,'6-Normes stockage'!E24)","v":0},{"$nulls":3},{"$f":"IF('6-Normes stockage'!E25=\"\",0,'6-Normes stockage'!E25)","v":0.25},{"$f":"IF('6-Normes stockage'!E26=\"\",0,'6-Normes stockage'!E26)","v":0}]
[{"$nulls":10},"&"]

{"sheet":"Dashboard","index":9,"n_rows":82,"n_cols":11,"rows_kept":82,"merged":[[0,0,0,12],[16,6,17,9],[16,10,17,10],[18,6,18,12],[33,6,33,12]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"tableau de bord\",\"dashboard\"))","v":"TABLEAU DE BORD"}]
{"$rows_empty":14}
["Situation des principaux aspects de l'evaluation"]
[{"$nulls":6},"NIVEAU GLOBAL DU RISQUE",{"$nulls":3},{"$f":"IF(F44>=0.9,\"Faible\",IF(F44<0.59,\"Elevé\",IF(0.9<F44>0.59,\"Moyen\")))","v":"Moyen"}]
[]
["A-Reception & dedouanement",{"$nulls":4},"Score","Global"]
["1. Arrivee des produits",{"$nulls":4},{"$f":"IFERROR(Calc!E4,\"\")","v":""}]
["2. Dedouanement des produits",{"$nulls":4},{"$f":"IFERROR(Calc!E5,\"\")","v":""}]
["3. Suivi et conformite",{"$nulls":4},{"$f":"IFERROR(Calc!E6,\"\")","v":""}]
["B-Stokage et gestion des stocks"]
["4. Procedures de stockage",{"$nulls":4},{"$f":"IFERROR(Calc!E8,\"\")","v":""}]
["5. Condition de stockage",{"$nulls":4},{"$f":"IFERROR(Calc!E9,\"\")","v":""}]
["6. Systeme de gestion",{"$nulls":4},{"$f":"IFERROR(Calc!E10,\"\")","v":""}]
["7. Outils de gestion",{"$nulls":4},{"$f":"IFERROR(Calc!E11,\"\")","v":""}]
["8. Regles et CCM",{"$nulls":4},{"$f":"IFERROR(Calc!E12,\"\")","v":""}]
["C-Distribution des produits"]
["9. Procedures et dispositifs",{"$nulls":4},{"$f":"IFERROR(Calc!E14,\"\")","v":""}]
["10. Condition de transport",{"$nulls":4},{"$f":"IFERROR(Calc!E15,\"\")","v":""}]
["11. Enregistrement des livraisons",{"$nulls":4},{"$f":"IFERROR(Calc!E16,\"\")","v":""}]
["D-Rapportage et SIGL"]
["12. SIGL",{"$nulls":4},{"$f":"IFERROR(Calc!E18,\"\")","v":""},"Normes de stockage"]
["13. Rapportage",{"$nulls":4},{"$f":"IFERROR(Calc!E19,\"\")","v":""}]
["E-Controle qualite et paiement"]
["14. Controle qualite",{"$nulls":4},{"$f":"IFERROR(Calc!E21,\"\")","v":""}]
["15. Modalite de paiement",{"$nulls":4},{"$f":"IFERROR(Calc!E22,\"\")","v":""}]
["F-Normes de stockage"]
["16.Sécurité incendie",{"$nulls":4},{"$f":"IFERROR(Calc!E24,\"\")","v":""}]
["17. Sécurité physique (accès)",{"$nulls":4},{"$f":"IFERROR(Calc!E25,\"\")","v":10}]
["18. Assurance qualité du stockage",{"$nulls":4},{"$f":"IFERROR(Calc!E26,\"\")","v":5}]
["19. Etat des moyens de manutention",{"$nulls":4},{"$f":"IFERROR(Calc!E27,\"\")","v":""}]
[{"$nulls":5},{"$f":"SUM(F20:F43)/20","v":{"v":0.75,"d":"0.8"}}]
[{"$f":"A19","v":"A-Reception & dedouanement"},{"$f":"SUM(F20:F22)/3","v":0}]
[{"$f":"A23","v":"B-Stokage et gestion des stocks"},{"$f":"IFERROR(SUM(F24:F28)/5,\"\")","v":0}]
[{"$f":"A29","v":"C-Distribution des produits"},{"$f":"IFERROR(SUM(F30:F32)/3,\"\")","v":0}]
[{"$f":"A33","v":"D-Rapportage et SIGL"},{"$f":"IFERROR(SUM(F34:F35)/2,\"\")","v":0}]
[{"$f":"A36","v":"E-Controle qualite et paiement"},{"$f":"IFERROR(SUM(F37:F38)/2,\"\")","v":0}]
[{"$f":"A39","v":"F-Normes de stockage"}]
[]
[]
["F.1_Sécurité incendie",{"$f":"IFERROR('6-Normes stockage'!E3/'6-Normes stockage'!F3,\"\")","v":""}]
["F.2_Sécurité physique (accès)",{"$f":"IFERROR('6-Normes stockage'!E15/'6-Normes stockage'!F15,\"\")","v":0.5}]
["F.3_Assurance qualité du stockage",{"$f":"IFERROR('6-Normes stockage'!E22/'6-Normes stockage'!F22,\"\")","v":0.25}]
["F.4_Etat des moyens de manutention",{"$f":"IFERROR('6-Normes stockage'!E30/'6-Normes stockage'!F30,\"\")","v":""}]
{"$rows_empty":9}
["Evolution de la prévalence du VIH",{"$nulls":3},2010,2011]
[{"$nulls":3},"Nationale-Globale",0,0]
[{"$nulls":3},"Nationale- Femmes enceintes",0,0]
[{"$nulls":3},"Région-Globale",0,0]
[{"$nulls":3},"Femmes enceintes",0,0]
[]
["Evolution file active",{"$nulls":3},2010,2011]
[{"$nulls":3},"PVVIH Totaux",0,0]
[{"$nulls":3},"Total PVVIH sous ARV",0,0]
[{"$nulls":3},"Adultes sous ARV",0,0]
[{"$nulls":3},"Enfants sous ARV",0,0]
[]
["Evolution des services"]
[{"$nulls":4},2010,2011]
[{"$nulls":3},"PVVIH ayant fait CD4",0,0]
[{"$nulls":3},"PVVIH ayant fait CV",0,0]
[{"$nulls":3},"Enfants ayant fait PCR",0,0]

{"sheet":"Questionnaire","index":10,"n_rows":49,"n_cols":7,"rows_kept":49,"hidden":true,"merged":[[2,2,7,2],[2,3,7,3],[9,2,12,2],[9,3,11,3],[14,2,21,2],[14,3,21,3],[23,2,27,2],[23,3,27,3],[29,2,30,2],[29,3,30,3],[33,2,38,2],[33,3,38,3],[41,2,44,2],[41,3,44,3],[46,2,48,2],[46,3,48,3]]}
["Questions","Visites / Docs à collecter (CAMEG)","Grille complémentaire","Indicateur clé"]
["1. Réception/Dédouanement"]
["Délai entre arrivée des produits à l'aérport et fin dédouanement / arrivée des produits à la CAMEG ?","Voir délais sur 12 ders mois",null,"Dédouanement: Nombre moyen de jour entre l'arrivée à l'aéroport et la date du dédouanement"]
["Existe-t-il un outil permettant de mesurer la performance de la CAMEG en matière de dédouanement des produits (date d'arrivée à l'aéroport, date de livraison dans les entrepôts CAMEG, date de réception provisoire)?","Voir outil"]
["Y a-t-il une réception provisoire (avec mise en quarantaine) puis une réception définitive? Délais à chaque étape?","Voir bons réception provisoire et bons réception définitive"]
["Y a-t-il eu des cas de non conformité? Si oui qu'est-ce qui a été fait?"]
["Le document de suivi des réceptions du PPM a-t-il été rempli?","Voir documents de suivi de réception du PPM sur 12 ders mois"]
["La liste des produits réceptionnés (avec numéro de lot, péremption, quantité) a-t-elle été transmise au PR après chaque réception?"]
["2. Stockage"]
["Les conditions de stockage au niveau central sont-elles adéquates (pour chaque type d'intrant)? Y compris sécurité des stocks (incendie, vol, etc.)?","Visite entrepôts centraux (médicaments, réactifs, TDRs, préservatifs)\nVoir fiches température sur 12 ders mois","Eval. stockage"]
["Les conditions de stockage au niveau régional sont-elles adéquates (pour chaque type d'intrant)? Y compris sécurrité des stocks?","Visite entrepôts régionaux (médicaments, réactifs, TDRs, préservatifs)"]
["Tous les produits de la subvention sont-ils stockés à  la CAMEG?","Quels intrants encore stockés au niveaus PRs ou Programmes?",{"$nulls":4},"SI(RECHERCHEV(C5;$K$3:$L$9;2;FAUX)=\"\";\"\";RECHERCHEV(C5;$K$3:$L$9;2;FAUX))"]
["Les produits stockés sont-ils assurés? Une copie du contrat d'assurance a-t-elle été transmise aux PRs?"]
["3. Gestion de stock"]
["Des invenatires sont-ils effectués régulièrement? A quelle fréquence?","Voir inventaires sur 12 ders mois","Eval. Stockage","Contrôle des stocks: Pourcentage d’établissements de santé qui transmettent des rapports complets sur le contrôle des stocks dans les délais prévus, selon un calendrier préétabli, pendant une période donnée.\n\nPertes: Pourcentage de quantités perdues de chaque produit par rapport aux quantités totales disponibles (stock de départ + quantités reçues) au cours de l’année écoulée.\n\nStock mini et contrôle des stocks: Pourcentage des établissements de santé ayant passé leurs commandes pendant une période donnée alors que le niveau du stock en cours, d’un ou plusieurs produits, était inférieur au niveau du stock minimum.\n\nDisponibilité: Pourcentage d’établissements de santé ayant connu une rupture de stock d’un ou de plusieurs médicaments nécessaires au cours d’une période donnée"]
["Outils de gestion de stock utilisés pour chaque type d'intrants (y compris préservatifs, réactifs, MIOs, etc.)?","Voir outils de stock  / voir si sont a jours sur 12 ders mois"]
["Les agences régionales ont-elles tous les outils de gestion pour les intrants Fonds Mondial, y compris pour les réactifs? Le personnel est-il formé à leur utilisation?"]
["Pour chaque intrant, quels outils de gestion de stock sont utilisés (logiciel, SAGE, Fiche de stock, etc.)? (au niveau central et au niveau régional)","Voir outils cités et voir si sont à jour."]
["Ruptures/péremptions: les outils de gestion de stock permettent-ils de collecter les données sur les périmés (y compris valorisation) et les ruptures?","Voir ruptures et péremption sur 12 der mois (sur base fiches de stock)?"]
["La règle du FEFO a-t-elle respectée sur les 12 derniers mois?","Voir respect FEFO (sur fiches de stock)"]
["La CAMEG calcule-t-elle les CMM, les niveaux de stock maxi et mini pour chaque item?","Voir si ces données sont sur fiches de stock ou dans outil de gestion de stock"]
["Les bons de livraison / bons de réception sont-ils disponibles pour la précédente période?","Voir bons de livraison / bons de réception sur un échantillon de structures sur 12 ders mois"]
["4. Distribution"]
["Les plans de distribution sont-ils transmis régulièrement par les PRs? A quelle fréquence?","Voir plans de distribution fournis par les PRs sur 12 ders mois","Eval. distribution","Distribution: Pourcentage d'agences régionales ayant reçu toutes les commandes en intégralité et à temps pendant une période donnée."]
["Des planning de distribution détaillsé ont-ils été élaborés?","Voir planning distribution"]
["Les distributions faites par la CAMEG sont-elles faites en accord avec les plans de distribution?","Voir bons de distribution sur 2 trimestres versus plans distribution"]
["Quel délai entre reception plan de distribution et distribuion effective?","Voir délai sur 12 ders mois"]
["Les conditions de distribution (CAMEG central - CAMEG régions) sont-elles adéquates?","Visite moyens logisitiques"]
["5. SIGL"]
["Quelles sont les données rapportées par les CAMEG régionales (qu. distribuées, CMM, niveaux de stock…)?","Voir rapports agences régionales au niveau central"]
["Les données de distribution sont-elles compilées par la CAMEG? Par les agences?","Voir outil de compilation / données compilées"]
["6. Rapportage"]
["Existe-t-il un canevas harmonisé de rapportage pour les agences régionales?","Voir canevas disponible"]
["Le canevas de rapportage est-il approprié pour répondre à la demande d'information des PRs?","Voir canevas disponible"]
["Les copies des BLs du trimestre ont-elles été régulièrement transmises (cf. convention)? Au 30 du mois suivant?"]
["Un etats de stocks a-t-il été envoyé trimestriellement à chaque PR et aux BS? Au 30 du mois suivant?"]
["L'état de stock trimestriel inclut-il une analyse des niveaux de stock prenant en compte les dates de péremption? "]
["Les données sur les quantités périmées sont-elles incluses dans le rapport? "]
["L'inventaire annuel a-t-il été fait (avec les partenaires, cf. convention) et envoyé aux PRs? Au 30 du mois de janvier?","Voir rapport d'inventaire au niveau CAMEG et au niveau PRs"]
["7. Contrôle Qualité"]
["La CAMEG dispose-t-elle de procédures pour le contrôle de qualité prémarketing (allant du prélèvement jusqu'à la réception et transmission des résultats aux PRs). Cette procédure est-elle appliquée?","Voir procédure"]
["Des contrôle qualité ont-ils été réalisés dans le cadre de la précédente convention?","Voir résultats tests CQ",null,"Contrôle de la qualité: Pourcentage de lots de produits testés au cours de l’année écoulée qui sont conformes aux critères de qualité établis au niveau national et international."]
["Si non quelles en sont les princiales raisons?"]
["Un laboratoire conforme aux exigences FM a-t-il été sélectionné? Si oui selon quelle procédure?","Voir processus sélection labo"]
["Les documents de qualité ont-ils été transmis aux PRs (certificats d'analyse fournisseurs, fiche de notification CQ prémarketing, résultats tests CQ)?"]
["8. Modalités de paiement"]
["Les factures CAMEG ont-elles été émises (pour les frais d'approche, pour les frais de gestion, pour les frais de stockage et distribution)? Avec docs justificatifs?","Voir factures envoyées PRs"]
["Les paiements ont-ils été faits 20% à la signature des cotations et 80% après transmission des derniers documents de réception (comme prévu dans la convention)?"]
["Tous les documents justificatifs ont-ils été fournis pour le paiement (facture CAMEG, copie factures fournisseurs, attestation de destination, admission en franchise, estimation valeur CIF, PV réception)?","Voir factures émises et pièces justificatives?"]

{"sheet":"Feuil1","index":11,"n_rows":49,"n_cols":2,"rows_kept":49,"hidden":true}
["Questions PRs","Observations PRs"]
[]
[]
["Existe-t-il un outil permettant de mesurer la performance de la CAMEG en matière de dédouanement?"]
[]
[]
["Les documents de suivi de réception des produits PPM ont-ils été reçus sur les 12 derniers mois?"]
{"$rows_empty":8}
[null,"Outil pour ACTs ok (via Sage). Pour autres intrants insuffisant. Même l'outil pour les ARVs pose problèmes car disponibles dans toutes les agences et si disponible pas toujours bien utilisé."]
{"$rows_empty":17}
[null,"Nécessité d'améliorer le rapportage: rapports souvent soumis tardivement, canevas de rapportage à revoir. Idéalement valider un canevas standard pour les 3 maladies et pour tous les intrants."]
["Rapports trimestriels envoyés par la CAMEG sur les 12 ders mois."]
[]
[]
[]
[]
[]
[]
[null,"Evaluer si CAMEG est prête pour nouvelles subventions, afin que cette activité soit effectivement réalisée (laboratoire sélectionné? Procédures en place? Etc.).\nVoir options pour que DGPML conduise cette activité (comme CQ post marketting) si CAMEG ne le fait pas."]
[]
[]
["Résultats tests CQ reçus sur les 12 derniers mois."]
[]
[]
[]
["Les factures CAMEG ont-elles bien été soumises avec tous les documents justificatifs nécessaires?"]

{"sheet":"Plan_Actions","index":12,"n_rows":100,"n_cols":28,"rows_kept":100,"merged":[[0,0,0,15],[2,0,3,0],[2,1,3,1],[2,3,3,3],[2,4,3,5],[2,6,3,6],[2,7,3,7],[2,8,2,11],[2,12,2,15],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[54,4,54,5],[74,4,74,5]]}
[{"$f":"UPPER(IF(Setup!L8=1,\"plan d'amelioration\",\"improvement actions plan\"))","v":"PLAN D'AMELIORATION"}]
[{"$nulls":17},"Select"]
["N°","Domaine d'evaluation",null,"Types d'action","Mésures de prévention ou d'attenuation",null,"Responsible mise en oeuvre","Partenaires de realisation","Select \"année\"",{"$nulls":3},"Select \"année\"",{"$nulls":4},"1-Conditions de reception et de deduanement",1,1,{"$f":"R3","v":"1-Conditions de reception et de deduanement"},{"$f":"R4","v":"2.1-Stockage des produits"},{"$f":"R5","v":"2.2--Gestion des produits"},{"$f":"R6","v":"3-Distribution des produits"},{"$f":"R7","v":"4-1-SIGL"},{"$f":"R8","v":"4.2- Stockage"},{"$f":"R9","v":"5.1- Controle qualite"},{"$f":"R10","v":"5.2- Modalites de paiement"}]
[{"$nulls":8},"T1","T2","T3","T4","T1","T2","T3","T4",null,"2.1-Stockage des produits",2,2,"Arrivee des produits a l'aeroport","Qualite du stockage","Systeme de gestion","Procedures et dispositifs","Completude des informations","Canevas de rapportage","Procedures de controle qualite","Emission des paiements"]
[1,"Select",{"$f":"IF(VLOOKUP(B5,$R$2:$S$10,2,FALSE)=\"\",\"\",VLOOKUP(B5,$R$2:$S$10,2,FALSE))","v":""},"Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select",null,"2.2--Gestion des produits",3,3,"Performance en matiere de reception/dedouanement","Thermometre","Gestion des mouvements","Conditions de transport lors de la distribution","Gestion des ecarts d'information","Transmission des etats de stocks aux PRs","Realisation du controle qualite","Justificatifs des paiements"]
[2,"Select",{"$f":"IF(VLOOKUP(B6,$R$2:$S$10,2,FALSE)=\"\",\"\",VLOOKUP(B6,$R$2:$S$10,2,FALSE))","v":""},"Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select",null,"3-Distribution des produits",4,4,"Reception provisoire","Mesures anti-incendie","Inventaires","Enregistrement des livraisons","Fonctionnement du SIGL","Inventaire et gestion des peremptions"]
[3,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select",null,"4-1-SIGL",5,5,"Conformite des produits recus","lieu et qualite de rangement/entreposage","Outils de gestion"]
[4,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select",null,"4.2- Stockage",6,6,"Suivi des receptions des produits PPM","Gestion des produits perimes"]
[5,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select",null,"5.1- Controle qualite",7,7,"Transmission de la liste des produits aux PRs"," Assurance des produits stockes"]
[6,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select",null,"5.2- Modalites de paiement",8,8]
[7,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[8,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[9,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[10,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[11,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[12,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[13,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[14,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[15,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[16,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[17,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[18,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[19,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[20,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[21,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[22,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[23,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[24,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[25,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[26,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[27,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[28,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[29,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[30,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[31,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[32,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[33,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[34,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[35,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[36,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[37,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[38,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[39,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[40,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[41,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[42,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[43,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[44,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[45,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[46,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[47,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[48,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[49,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[50,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[51,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[52,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[53,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[54,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[55,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[56,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[57,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[58,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[59,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[60,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[61,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[62,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[63,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[64,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[65,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[66,"Select",{"$f":"IF(VLOOKUP(B70,$R$2:$S$10,2,FALSE)=\"\",\"\",VLOOKUP(B70,$R$2:$S$10,2,FALSE))","v":""},"Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[67,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[68,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[69,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[70,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[71,"Select","","Select",{"$nulls":4},"Select","Select","Select","Select","Select","Select","Select","Select"]
[72,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[73,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[74,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[75,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[76,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[77,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[78,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[79,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[80,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[81,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[82,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[83,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[84,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[85,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[86,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[87,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[88,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[89,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[90,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[91,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[92,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[93,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[94,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[95,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]
[96,"Select","","Select","Select",{"$nulls":3},"Select","Select","Select","Select","Select","Select","Select","Select"]