{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Location vehicules","OUTILS DE GESTION"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Location vehicules","index":0,"n_rows":97,"n_cols":10,"rows_kept":97,"cut":false,"hidden":false,"merged":[[96,1,96,2],[4,6,5,6],[4,9,5,9],[4,7,4,8],[10,1,10,2],[20,1,20,2],[95,1,95,2],[58,0,72,0],[73,0,95,0],[0,0,1,4],[4,0,5,0],[6,0,10,0],[11,0,20,0],[21,0,29,0],[30,0,34,0],[35,0,57,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5]]}
["PLAN DE LOCATION VEHICULES CDM 2020"]
[]
[]
[]
["Lots","Activités","Type de vehicules","Nombre de Vehicules","Zone à couvrir",null,"Distance à parcourrir","Periode de location",null,"Nombre de jours"]
[{"$nulls":4},"Au depart de","Itineraire",null,"Début","Fin"]
[1,"Supervision ","4 X 4",1,"Selibaby ","Selibaby (Capital 4 X 4)",1700,null,null,12]
[null,"Supervision ","4 X 4",1,"NkTT","Nouak-Selibaby-Nouak",1640,null,null,13]
[null,"Supervision ","4 X 4",2,"Selibaby ","Selibaby ",1200,null,null,12]
[null,"Distribution","PICK UP HILUX",15,"Selibaby","Selibaby",3000,null,null,10]
[null,"Total Guidimahaga",null,{"$f":"SUM(D7:D10)","v":19},null,null,{"$f":"SUM(G7:G10)","v":7540},{"$f":"SUM(H7:H10)","v":0},0,47]
[2,"Distribution","PICK UP HILUX",6,"Moudjriye","Moudjriye",3000,null,null,10]
[null,"Supervision ","4 X 4",2,"Moudjriye","Moudjriye",1200,null,null,12]
[null,"Supervision ","Nat",1,"NkTT","Nouak-Moudjriye-Nouak",1200,null,null,13]
[null,"Supervision ","4 X 4",1,"Tidjikja","Moudgeria-Tidjikja",1800,null,null,12]
[null,"Supervision ","4 X 4",2,"Tidjikja","Tidjikja",1200,null,null,12]
[null,"Consultant","4 X 4",1,"NkTT","Tidikja-Moudjeria-NKTT",{"$f":"150*25","v":3750},null,null,25]
[null,"Supervision ","4 X 4",1,"NkTT","Nouak-Tidjikja-Nouak",1500,null,null,13]
[null,"Supervision ","4 X 4",1,"Tidjikja","Tdjikja (Capital 4 X 4)",1500,null,null,12]
[null,"Distribution","PICK UP HILUX",4,"Tidjikja","Tidjikja",3000,null,null,10]
[null,"Total Tagant",null,{"$f":"SUM(D12:D20)","v":19},0,0,18150,0,0,119]
[3,"Formation FF","4 X 4",1,"NkTT","Nouak-Aleg-Nouak",512,null,null,4]
[null,"Formation LOG","4 X 4",1,"NkTT","Nouak-Aleg-Nouak",520,null,null,4]
[null,"Distribution","PICK UP HILUX",11,"Aleg","Aleg",3000,null,null,10]
[null,"Consultant","4 X 4",1,"NkTT","Aleg-Kaedi-Selibaby-NKTT",{"$f":"150*25","v":3750},null,null,25]
[null,"Supervision ","Nat",1,"NkTT","Nouak-Aleg-Nouak",820,null,null,13]
[null,"Supervision","4 X 4",1,"Aleg","Aleg (Capital 4 X 4)",1500,null,null,12]
[null,"Supervision","4 X 4",2,"Aleg","Aleg",1200,null,null,12]
[null,"Lancement","4 X 4",1,"NkTT","Nktt-Aleg-Nktt",600,null,null,2]
[null,"Total Brakna",null,{"$f":"SUM(D22:D29)","v":19},{"$f":"SUM(E22:E29)","v":0},0,11902,0,0,82]
[4,"Supervision ","4 X 4",1,"Kaedi","Kaedi (Capital 4 X 4)",1500,null,null,12]
[null,"Supervision ","4 X 4",2,"Kaedi","Kaedi",1200,null,null,12]
[null,"Supervision ","4 X 4",1,"NkTT","Nouak-Kaedi-Nouak",1160,null,null,13]
[null,"Distribution","PICK UP HILUX",12,"Kaedi","Kaedi",3000,null,null,10]
[null,"Total Gorgol",null,{"$f":"SUM(D31:D34)","v":16},{"$f":"SUM(E31:E34)","v":0},0,6860,0,0,47]
[5,"Distribution","PICK UP HILUX",11,"Bakeol","Bakeol",3000,null,null,10]
[null,"Supervision ","4 X 4",2,"Bakeol","Bakeol",1200,null,null,12]
[null,"Supervision ","Nat",1,"NKTT","NkTT- Barkeol-NkTT",1420,null,null,13]
[null,"Distribution","PICK UP HILUX",2,"Boumdeid","Boumdeid",3000,null,null,10]
[null,"Supervision","Nat",1,"NKTT","NkTT- Boumdei-NkTT",1700,null,null,13]
[null,"Supervision","4 X 4",2,"Boumdeid","Boumdeid",1200,null,null,12]
[null,"Distribution","PICK UP HILUX",3,"Guerrou","Guerrou",3000,null,null,10]
[null,"Supervision","4 X 4",2,"Guerrou","Guerrou",1200,null,null,12]
[null,"Supervision","5 X 4",1,"NKTT","NkTT- Gueroul-NkTT",1400,null,null,13]
[null,"Distribution","PICK UP HILUX",10,"Kankossa","Kankossa",3000,null,null,10]
[null,"Supervision","4 X 4",1,"NKTT","NkTT- Kankossa-NkTT",1700,null,null,13]
[null,"Supervision","4 X 4",2,"Kankossa","Kankossa",1200,null,null,12]
[null,"Consultant","4 X 4",1,"NkTT","Barkeole-Kiffa-boumdeid-Guerou-Kankossa-NKTT",{"$f":"150*25","v":3750},null,null,25]
[null,"Formation LOG","4 X 4",1,"NkTT","Nouak- Kiffa-Nouak",1200,null,null,4]
[null,"Formation SNIS","4 X 4",1,"NkTT","Nouak- Kiffa-Nouak",1250,null,null,4]
[null,"Formation FF","4 X 4",1,"NkTT","Nouak-Kiffa-Nouak",1200,null,null,4]
[null,"Supervision","4 X 4",2,"Kiffa","Kiffa",1200,null,null,12]
[null,"Supervision","4 X 4",1,"Kiffa","Guerou-Barkeol-Kiffa",1900,null,null,12]
[null,"Supervision","4 X 4",1,"Kiffa","Boumdeid-Kiffa",1700,null,null,12]
[null,"Supervision","5 X 4",1,"NKTT","NkTT- Kiffa-NkTT",1500,null,null,13]
[null,"Supervision","4 X 4",1,"Kiffa","Kenkossa-Kiffa",1700,null,null,12]
[null,"Distribution","PICK UP HILUX",11,"Kiffa","Kiffa",3000,null,null,10]
[null,"Total Assaba",null,{"$f":"SUM(D36:D57)","v":59},0,0,41420,0,0,248]
[6,"Formation FF","4 X 4",1,"NkTT","Nouak-Aioun-Nouak",1620,null,null,4]
[null,"Formation LOG","4 X 4",1,"NkTT","Nouak-Aioun-Nouak",1620,null,null,4]
[null,"Consultant","4 X 4",1,"NkTT","Ajoun, kobeni, Tamchaket, Tintane-NKTT",{"$f":"150*25","v":3750},null,null,25]
[null,"Supervision ","4 X 4",1,"Aioun","Kobenij-Aioun",1700,null,null,12]
[null,"Supervision ","4 X 4",2,"Aioun","Aioun",1200,null,null,12]
[null,"Supervision ","4 X 4",1,"Aioun","Tintane- Tamchekett-Aioun",1910,null,null,12]
[null,"Distribution","PICK UP HILUX",8,"Aioun","Aioun",3000,null,null,10]
[null,"Distribution","PICK UP HILUX",6,"Tamchaket","Tamchaket",3000,null,null,10]
[null,"Supervision","4 X 4",2,"Tamchaket","TAmchaket",1200,null,null,12]
[null,"Distribution","PICK UP HILUX",13,"Tintane","Tintane",3000,null,null,10]
[null,"Supervision ","4 X 4",1,"NKTT","NKTT-Tintane-NKTT",1800,null,null,13]
[null,"Supervision ","4 X 4",2,"Tintane","Tintane",1200,null,null,12]
[null,"Supervision ","4 X 4",2,"Kobeni","Kobeni",1200,null,null,12]
[null,"Distribution","PICK UP HILUX",12,"Kobeni","Kobeni",3000,null,null,10]
[null,"Total Elgarbi",null,{"$f":"SUM(D59:D72)","v":53},{"$f":"SUM(E59:E72)","v":0},0,29200,0,0,158]
[7,"Supervision","4 X 4",2,"AMOURJ","AMOURJ",1200,null,null,12]
[null,"Distribution","PICK UP HILUX",12,"AMOURJ","AMOURJ",3000,null,null,10]
[null,"Distribution","PICK UP HILUX",13,"BassiKinou","BassiKinou",3000,null,null,10]
[null,"Supervision","4 X 4",2,"BassiKinou","BassiKinou",1200,null,null,12]
[null,"Supervision","4 X 4",1,"Bassikinou/Camp M'berra","Bassikinou/Camp M'berra",{"$f":"50*12","v":600},null,null,12]
[null,"Distribution","PICK UP HILUX",8,"Djigueni","Djigueni",3000,null,null,10]
[null,"Supervision","4 X 4",2,"Djigueni","Djigueni",1200,null,null,12]
[null,"Formation FF","4 X 4",1,"NkTT","Nouak-Nema-Nouak",2200,null,null,4]
[null,"Formation LOG","4 X 4",1,"NkTT","Nouak-Nema-Nouak",2200,null,null,4]
[null,"Distribution","PICK UP HILUX",10,"Nema","Nema",3000,null,null,10]
[null,"Supervision","4 X 4",2,"Nema","Nema",1200,null,null,12]
[null,"Supervision","4 X 4",1,"Nema","Amourj-Nema",1700,null,null,12]
[null,"Consultant","4 X 4/MRT/CS",1,"NkTT","Nema,Oualata, Timbedra,Amourj, Bassikinu Mberra, Bassikinu-NKTT",{"$f":"150*25","v":3750},null,null,25]
[null,"Supervision","4 X 4",1,"Nema","Bassiknou-Nema",2300,null,null,12]
[null,"Supervision","4 X 4",1,"Nema","Tembedra-Djigueni-Nema",1900,null,null,12]
[null,"Supervision","4 X 4",1,"Nema","N'beiket-Oualata-Nema",2000,null,null,12]
[null,"Distribution","PICK UP HILUX",2,"Oualata","Oualata",3000,null,null,10]
[null,"Supervision","4 X 4",2,"Oualata","Oualata",1200,null,null,12]
[null,"Distribution","PICK UP HILUX",10,"Timbedra","Timbedra",3000,null,null,10]
[null,"Supervision","4 X 4",2,"Timbedra","Timbedra",1200,null,null,12]
[null,"Supervision","4 X 4",2,"Nbeikit","Nbeikit",1200,null,null,12]
[null,"Distribution","PICK UP HILUX",2,"Nbeikit","Nbeikit",3000,null,null,10]
[null,"Total Echarghi",null,{"$f":"SUM(D74:D95)","v":79},{"$f":"SUM(E74:E95)","v":0},0,46050,0,0,247]
[null,"TOTAL VEHICULE",null,{"$f":"D96+D73+D58+D35+D30+D21+D11","v":264},0,0,161122,0,0,948]

{"sheet":"OUTILS DE GESTION","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[[2,1,2,4],[3,7,3,8]]}
[]
[]
[null," Besoins en outils /Équipements de la CDM "]
[null,"Documents et outils",{"$nulls":5},"Donnee de base"]
[null,"Description:","Unites:","Quantite:","Description et protocole","Description pour impression","Date probable  de livraison","Nombre d'equipe",1148]
[null,"Besoin Fiche de stock (photocopie)",1,{"$f":"((2*I11)+(4*I9))*1.05","v":2316.3000000000002},"2 fiches de stock pour chaque Moughataa et 4 fiches par centre et PS. ","3 feuilles A4 recto","13 aout","Nombre de volontaire",{"$f":"(I5*2)*1.1","v":2525.6000000000004}]
[null,"Bordereau de livraison ",1,{"$f":"(2*I11)*1.1","v":46.2},"2 par Moughataa. 4 feuilles par bordereau.","25x4 feuillets autocopiant de 60g/m2","13 aout","Nombre de superviseurs de proximite",{"$f":"I6/3","v":841.86666666666679}]
[null,"Bon d'Approvisionnement des Equipes de Distribution",1,{"$f":"(1*I5)*1.1","v":1262.8000000000002},"carnet  par CS/PS. 3 feuilles par bordereau.","50x3 feuillets autocopiant de 60g/m3","13 aout"]
[null,"Besoin fiche d'evaluation des entrepots  (photocopie)",1,{"$f":"((2*I11)+(2*I9))*1.1","v":1236.4000000000001},"2 entrepot  par Moughataa et 2 par CS/PS","1 feuille A4 recto","13 aout","Nombre de superviseurs centre de sante",541]
[null,"Fiche d'identification des circuits de ravitaillements des CS/PS",1,{"$f":"(4*I11)*1.1","v":92.4},"4 par Moughataa","1 feuille A4 recto",null,"Nombre de superviseurs Moughataas",{"$f":"21*2","v":42},"2 superviseurs par Moughataas"]
[null,"Fiche d'inventaire ",1,{"$f":"((I11*3)+(I9*3))*1.05","v":1770.3000000000002},"3 fiches par Moughataa et par CS/PS","1 feuille A4 recto","13 aout","Nombre de superviseurs Wilayas",21,"1 superviseur de wilayas par Moughataas"]
[null,"Fiche de PV de reception ",1,{"$f":"((I11*3)+(I9*3))*1.05","v":1770.3000000000002},"3 fiches par Moughataa et par CS/PS","1 feuille A4 recto",null,"Nombre de superviseurs du niveau national",{"$f":"2*7","v":14},"2 superviseurs SLP par Wilayas"]
[null,"Besoin fiche de contrat pour prestataire (photocopie)",1,"PM","Plus necessaire ",null,null,"Nombre de village",1381]
[null,"Fiche de Distribution (nom du chef de menage,  numero, nombre de personnes dans les menages )",1,{"$f":"(4*I5)*10*1.05","v":48216},"4 fiches par jour par equipe de distribution (pour 35 menages en moyenne par jour)","1 feuille A4 recto","13 aout","Nombre de Moughataa",22]
[null," Fiche de synthese journaliere pour Superviseur de proximité",1,{"$f":"2*I7*10*1.05","v":17679.200000000004},"2 fiches par superviseur de proximite par jour.","1 feuille A4 recto","13 aout","Nombre de Wilaya",7]
[null," Fiche de synthese journaliere pour Superviseur de CS/PS",1,{"$f":"2*I9*10*1.05","v":11361},"2 fiches par superviseur CS/PS  par jour pour la distribution","1 feuille A4 recto","13 aout"]
[null,"Besoin en modules de formation en logistique (1 par superviseur centre de sante )",1,{"$f":"((2*I11)+I9)*1.1","v":641.30000000000007},"21 Moughataas et CS/PS. Module de 10 pages. ","10 feuilles A4 recto","13 aout"]
[null,"Aide mémoire pour distributeurs",1,{"$f":"(I6+I7)*1.05","v":3535.8400000000006},"Aide mémoire de 3 pages ","3 feuilles A4 recto","13 aout"]
[null,"Aide mémoire pour mobilisateurs",1,{"$f":"I6*20%*1.05","v":530.37600000000009},"Aide mémoire de 3 pages ","3  feuilles A4 recto","13 aout"]
[null,"Besoin Fiche de Pointage MILDA  (photocopie)",1,"PM","Plus necessaire"]
[null,"Besoin Fiches de Supervision Distribution  (photocopie)",1,{"$f":"((I10*2)+ (2*I12)+(I11*2))*10*1.05","v":1617},"2 fiches par jour par superviseurs de , CS/PS, Moughataas/Wilayas/Central par jre X 10 jours","2 feuilles A4 recto","13 aout"]
[null,"Fiche de collecte des donnees",1,"PM","2 fiches par moughataas et wilayas par jour","Version electronique"]