{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Menu","Paramétrage","chargement","BSI"],"not_rendered":{"charts":1,"macros":1,"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[4,2,4,4]]}
[]
[]
[]
[]
[]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,null,"NOTE: Veuillez ouvrir Outlook avant l'envoi des Emails"]

{"sheet":"Paramétrage","index":1,"n_rows":21,"n_cols":6,"rows_kept":21}
[{"$nulls":3},"Paramétrage","Menu"]
[]
[null,1,"Contenu du Mail"]
[]
[null,null,"Objet du Mail","Objet Mail"]
[null,null,"Corps du Mail","Bonjour ,\nVeuillez trouvez ci-joint votre document.\nCordialement!",{"$f":"LEN(rngBody)","v":65},"caractères"]
[]
[null,2,"Email de Test"]
[null,null,"Entrez un Email de test","monmail@outlook.com"]
[]
[null,3,"Combien de Mails test voulez-vous envoyer?"]
[{"$nulls":3},1]
[]
[null,4,"Dossier de sauvegarde des fichiers joints"]
[null,null,"Enregistrer dans","C:\\Users\\bc00T349\\Desktop\\BSI\\Fichier"]
[]
[]
[]
[null,5,"     Note:Après avoir cliquer sur le bouton d'envoi Email ou de Test Email,"]
[null,null,"une demande de confirmation du nombre d'Email à envoyer vous sera envoyée!"]
[{"$nulls":3},{"$f":"COUNTA(StoreNums) & \" emails ou \" & IF( rngTN>0,rngTN, COUNTA(StoreNums)) & \" test emails seront envoyés\"","v":"6 emails ou 1 test emails seront envoyés"}]

{"sheet":"chargement","index":2,"n_rows":7,"n_cols":6,"rows_kept":7}
["Numéro","Matricule","Nom","Adresse Email","Sexe","Date de naissance"]
[1,"A456","Alphonse ","yourmail@outlook.com","Masculin","1981-08-16"]
[2,"A457","Jean","yourmail@outlook.com","Masculin","1976-07-06"]
[3,"A458","Thibault","yourmail@outlook.com","Féminin","1988-07-25"]
[4,"A459","Eveline","yourmail@outlook.com","Féminin","1995-10-18"]
[5,"A460","Marc","yourmail@outlook.com","Masculin","1990-01-14"]
[6,"A461","Justine","yourmail@outlook.com","Féminin","1992-01-09"]

{"sheet":"BSI","index":3,"n_rows":376,"n_cols":8,"rows_kept":376,"merged":[[233,1,233,4],[234,1,234,2],[234,3,234,4],[235,1,235,2],[235,3,235,4],[236,1,236,2],[236,3,236,4],[237,1,237,4],[238,2,238,4],[239,2,239,4],[240,2,240,4],[241,2,241,4],[244,1,244,4],[245,3,245,4],[246,3,246,4],[247,3,247,4],[248,3,248,4],[249,1,249,4],[250,1,250,2],[250,3,250,4],[251,1,251,2],[251,3,251,4],[252,1,252,2],[252,3,252,4],[253,1,253,2],[253,3,253,4],[265,1,265,4],[266,1,266,4],[270,1,270,3],[271,1,271,3],[272,1,272,3],[273,1,273,3],[274,1,274,3],[277,1,277,3],[278,1,278,3],[279,1,279,3],[280,1,280,3],[281,1,281,3],[282,1,282,3],[284,1,284,4],[285,1,285,4],[303,1,303,3],[304,1,304,3],[305,1,305,3],[306,1,306,3],[307,1,307,3],[308,1,308,3],[309,1,309,3],[310,1,310,3],[311,1,311,3],[312,1,312,3],[316,2,316,3],[339,1,339,4],[342,1,342,3],[343,1,343,3],[344,1,344,3],[345,1,345,3],[346,1,346,3],[347,1,347,3],[355,1,355,4],[357,1,357,3],[358,1,358,3],[359,1,359,3],[360,1,360,3],[372,1,372,4],[373,1,373,4],[375,1,375,4],[376,1,376,4]]}
{"$rows_empty":228}
[null,{"$f":"VLOOKUP($D$235,chargement!$B:$C,2,0)","v":"Alphonse "}]
[]
[{"$nulls":7},"numéro"]
[{"$nulls":7},1]
[]
[null,"ETAT CIVIL"]
[null,"Matricule",null,{"$f":"VLOOKUP($H$232,chargement!$A:$B,2,0)","v":"A456"}]
[null,"Sexe",null,{"$f":"VLOOKUP($D$235,chargement!$B:$AS,4,0)","v":"Masculin"}]
[null,"Date de naissance",null,{"$f":"VLOOKUP($D$235,chargement!$B:$AS,5,0)","v":"1981-08-16"}]
[]
[null,"Direction",{"$f":"VLOOKUP($D$235,chargement!$B:$AS,6,0)","v":0}]
[null,"Service",{"$f":"VLOOKUP($D$235,chargement!$B:$AS,7,0)","v":0}]
[null,"Fonction",{"$f":"VLOOKUP($D$235,chargement!$B:$AS,8,0)","v":0}]
[null,"Classe",{"$f":"VLOOKUP($D$235,chargement!$B:$AS,9,0)","v":0}]
{"$rows_empty":29}
[{"$nulls":4},{"$f":"VLOOKUP($D$235,chargement!$B:$AS,19,0)","v":0}]
[{"$nulls":4},{"$f":"VLOOKUP($D$235,chargement!$B:$AS,20,0)","v":0}]
[{"$nulls":4},{"$f":"VLOOKUP($D$235,chargement!$B:$AS,21,0)","v":0}]
[]
[]
[]
[]
[]
[null,{"$f":"IF(E280=\"\",\"\",\"Bonus recouvreur\")","v":""},null,null,{"$f":"IF(VLOOKUP($D$235,chargement!$B:$AS,23,0)=0,\"\",VLOOKUP($D$235,chargement!$B:$AS,23,0))","v":""}]
[null,{"$f":"IF(E281=\"\",\"\",\"Commissions agents-placeurs\")","v":""},null,null,{"$f":"IF(VLOOKUP($D$235,chargement!$B:$AS,24,0)=0,\"\",VLOOKUP($D$235,chargement!$B:$AS,24,0))","v":""}]
[]
[]
[]
[null,{"$f":"IF(B286=\"\",\"\",\"Votre rémunération différée:\")","v":""}]
[null,{"$f":"IF(VLOOKUP($D$235,chargement!$B:$AS,26,0)=0,\"\",\"Vous avez reçu un montant de LTIs de  \"&ROUND(VLOOKUP($D$235,chargement!$B:$AS,26,0),0)&\" FCFA, au titre de votre performance de l'année 2018.\")","v":""}]
{"$rows_empty":89}
[null,"Pour plus d’informations, "]