{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["LISTE DU PERSONNEL","LIVRE DE PAIE","Paie Synthèse"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LISTE DU PERSONNEL","index":0,"n_rows":145,"n_cols":52,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"LISTE DU PERSONNEL"]
["Matricule","Civilité","Noms "," Prénoms","Sexe ","Date de\nNaissance","Nationalité","Adresse","Téléphone","Statut Matrimonial","Nombre d'Enfant en Charge","Nombre d'Enfants Majeurs","Date d'Embauche","Date de Sortie","Direction","Service","Emploi","Régime","Nature Contrat","Catégorie","Salaire Catégoriel",{"$f":"#REF!","v":{"$error":"#REF!"}},"Nbre parts IGR","Indemnités Transport","N° CNPS","Mode de\nde Paiement","Numéro de Compte Bancaire","BANQUE"]
[]
["001","M.",null,null,"M","22/03/1980","Ivoirienne","01ABIDJAN 01"," 0 847356","Célibataire",5,0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,4,25000,5236875,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M5=\"\",\"\",\"Trim\"&INT((MONTH(M5)-1)/3)+1)&\"-\"&YEAR(M5)","v":"Trim3-2019"}]
["002","M.",null,null,"M","1984-02-08","Ivoirienne","","+22540452312","Célibataire","4","0","01/07/2019",null,null,"","Chauffeur","Général","CDD","A2",73480,35228,"3,5",25000,4562314,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["003","M.",null,null,"M","1979-01-01","Ivoirienne","","+22570455300","Célibataire","5","0","01/07/2019",null,null,"","Chauffeur","Général","CDD","A2",73480,35228,4,25000,123654,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["004","M.",null,null,"M","01/10/1961","Ivoirienne",null,"+22540451114","Célibataire",6,0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,4.5,25000,789654,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["005","M.",null,null,"M","","Ivoirienne",null,"+22549457818","Célibataire",0,0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,41709,1,25000,12212145,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["006","M.",null,null,"M","24/04/1994","Ivoirienne",null,"+22575452377","Célibataire","1",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,37608,2,25000,455545,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["007","M.",null,null,"M","1989-10-23","Ivoirienne",null,"+22545673490","Célibataire",0,0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,41709,1,25000,753159,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["008","M.",null,null,"M","1980-01-01","Ivoirienne",null,"+22545673490","Célibataire","5",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,4,25000,159753,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["009","M.",null,null,"M","1980-01-01","Ivoirienne",null,"+22545673490","Célibataire","2",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["010","M.",null,null,"M","1978-01-01","Ivoirienne",null,"+22545673490","Célibataire","4",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["011","M.",null,null,"M","1988-12-25","Ivoirienne",null,"+22545673490","Célibataire","3",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["012","M.",null,null,"M","","Ivoirienne",null,"+22540452312","Célibataire",0,0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,41709,1,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["013","M.",null,null,"M","1983-11-28","Ivoirienne",null,"+22570455300","Célibataire","2",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["014","M.",null,null,"M","01/01/1992","Ivoirienne",null,"+22540451114","Célibataire","2",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["015","M.",null,null,"M","10/01/1977","Ivoirienne",null,"+22549457818","Célibataire","3",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["016","M.",null,null,"M","01/01/1974","Ivoirienne",null,"+22575452377","Célibataire","6",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,4.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["017","M.",null,null,"M","20/12/1984","Ivoirienne",null,"+22545673490","Célibataire","2",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["018","M.",null,null,"M","01/01/1991","Ivoirienne",null,"+22545673490","Célibataire",0,0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,41709,1,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["019","M.",null,null,"M","1983-10-02","Ivoirienne",null," 0 847356","Célibataire","1",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,37608,2,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["020","M.",null,null,"M","31/12/ 199","Ivoirienne",null,"+22540452312","Célibataire","1",0,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,37608,2,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["021","M.",null,null,"M","01/01/1996","Ivoirien","","+22570455300","Célibataire",0,"0","2019-07-01",null,null,"S&E","Chauffeur","Général","CDD","A2",73480,41709,1,25000,19841081,"Virement bancaire",521458632,"BNI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["022","M.",null,null,"M","25/12/1981","","","+22540451114","Célibataire","3","0","2019-07-01",null,null,"","Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["023","M.",null,null,"M","03/06/1992","","","+22549457818","Célibataire",0,"0","2019-07-01",null,null,"","Chauffeur","Général","CDD","A2",73480,41709,1,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["024","M.",null,null,"M","19/04/1991","","","+22575452377","Célibataire",0,"0","2019-07-01",null,null,"","Chauffeur","Général","CDD","A2",73480,41709,1,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["025","M.",null,null,"M","08/05/1992","JJ",null,"+22545673490","Célibataire","1","0","2019-07-01",null,null,"","Chauffeur","Général","CDD","A2",73480,37608,2,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["026","M.",null,null,"M","19/04/1981","","","+22545673490","Célibataire","5","0","2019-07-01",null,null,"","Chauffeur","Général","CDD","A2",73480,35228,4,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["027","M.",null,null,"M","07/04/1971","Béninoise","plateau","+22545673490","Célibataire","7","0","2019-07-01",null,null,"PROJET","Chauffeur","Général","CDD","A2",73480,35228,5,25000,"124825 Q","Virement bancaire",401258963321,"ECOBANK-CI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["028","M.",null,null,"M","01/01/1992",null,null,"+22545673490","Célibataire",0,null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,41709,1,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["029","M.",null,null,"M","28/06/1981",null,null,"+22545673490","Célibataire","3",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["030","M.",null,null,"M","02/01/1982",null,null,"+22540452312","Célibataire","3",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["031","M.",null,null,"M","21/01/1992",null,null,"+22570455300","Célibataire","1",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,37608,2,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["032","M.",null,null,"M","03/06/1985",null,null,"+22540451114","Célibataire","3",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["033","M.",null,null,"M","1980-01-01",null,null,"+22549457818","Célibataire","2",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["034","M.",null,null,"M","10/01/1985",null,null,"+22575452377","Célibataire","1",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,37608,2,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["035","M.",null,null,"M","1980-01-01",null,null,"+22545673490","Célibataire","2",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["036","M.",null,null,"M","15/06/1986",null,null,"+22545673490","Célibataire","3",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["037","M.",null,null,"M","20/04/1986",null,null," 0 847356","Célibataire",3,null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["038","M.",null,null,"M","12 /01/199",null,null,"+22540452312","Célibataire",0,null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,41709,1,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["039","M.",null,null,"M","01/01/1982",null,null,"+22570455300","Célibataire","1",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,37608,2,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["040","M.",null,null,"M","1978-01-01",null,null,"+22540451114","Célibataire","4",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["041","M.",null,null,"M","02/06/1986",null,null,"+22549457818","Célibataire","2",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["042","M.",null,null,"M","02/11/1975",null,null,"+22575452377","Célibataire","5",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,4,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["043","M.",null,null,"M","01/01/1980",null,null,"+22545673490","Célibataire","3",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["044","M.",null,null,"M","01/01/1981",null,null,"+22545673490","Célibataire","5",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,4,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["045","M.",null,null,"M","03/06/1991",null,null,"+22545673490","Célibataire","1",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,37608,2,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["046","M.",null,null,"M","1988-12-25",null,null,"+22545673490","Célibataire","2",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["047","M.",null,null,"M","10/08/1990",null,null,"+22545673490","Célibataire","2",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,36276,2.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["048","M.",null,null,"M","10/05/1994",null,null,"+22540452312","Célibataire",0,null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,41709,1,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["049","M.",null,null,"M","01/01/1976",null,null,"+22570455300","Célibataire","4",null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,35228,3.5,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["050","M.",null,null,"M","10/10/1986",null,null,"+22540451114","Célibataire",0,null,"2019-07-01",null,null,null,"Chauffeur","Général","CDD","A2",73480,41709,1,25000,null,"Virement bancaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim3-2019"]
["051","M.",null,null,"M","20/11/1984","Ivoirienne","08 BP 857 abidjan 08","58635223","Célibataire","0","0","02/02/2015",null,null,"Suivi Evaluation","M&E Senior","Général","CDI","A9",1600000,100000,"1,5",30000,"854627 Q","Virement bancaire",321548796548,"BNI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim1-2015"]
["052","Mme",null,null,"F","18/12/1968","Béninoise","05 BP 225 Abidjan 05","76524863","Marié(e)","2","0","05/04/2005",null,null,"PROJET","Directrice","Expatrié","CDI","A10",2500000,500000,2,35000,"758421 Q","Virement bancaire",4127854854,"ECOBANK-CI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trim2-2005"]
["053",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K57>0,IF(+OR(J57=\"Célibataire\",J57=\"Divorcé(e)\"),+IF(L57=0,+IF(K57<>0,1.5,1),+IF(1.5+L57*0.5>5,5,1.5+L57*0.5)),+IF(J57=\"Marié(e)\",+IF(L57=0,2,+IF((2+0.5*L57)>5,5,(2+0.5*L57))),+IF(J57=\"Veuf(ve)\",+IF(L57=0,+IF(K57<>0,1.5,1),+IF((2+L57*0.5)>5,5,(2+L57*0.5))),1+0.5*L57))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["054",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["055",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["056",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["057",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["058",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["059",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["060",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["061",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["062",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["063",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["064",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["065",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["066",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M70=\"\",\"\",\"Trim\"&INT((MONTH(M70)-1)/3)+1)&\"-\"&YEAR(M70)","v":"-1900"}]
["067",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["068",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["069",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["070",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["071",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["072",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["073",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["074",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["075",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["076",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["077",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["078",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["079",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["080",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["081",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["082",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["083",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["084",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["085",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["086",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["087",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["088",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["089",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["090",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["091",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["092",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["093",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["094",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["095",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["096",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["097",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["098",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["099",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-1900"]
["100"]
["101"]
["102"]
["103"]
["104"]
["105"]
["106"]
["107"]
["108"]
["109"]
["110"]
["111"]
["112"]
["113"]
["114"]
["115"]
["116"]
["117"]
["118"]
["119"]
["120"]
["121"]
["122"]
["123"]
["124"]
["125"]
["126"]
["127"]
["128"]
["129"]
["130"]
["131"]
["132"]
["133"]
["134"]
["135"]
["136"]
["137"]
["138"]
["139"]
["140"]
["141"]

{"sheet":"LIVRE DE PAIE","index":1,"n_rows":67,"n_cols":52,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,2,66,34]]}
[]
[null,null,null,null,null,null,null,"LIVRE DE PAIE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($AI$5:$AI$100)","v":5841346.9803541508}]
["Date de Paie","Période de Paie","Matricule","Nom & Prénoms de l'employé ","Poste Occupé/Fonction","Ancienneté","Salaires de base","Sursalaire","Prime d'ancienneté","Prime transport imposable","Gratification","Congés Payés","Avantag en Nature","BRUT IMPOSABLE","Cotisation Rétraite Salarié","IGR Mensuel","ITS Salarié","Contribution Nationale","ITS Employeur","CNPS Retraite Employeur","CNPS AT","CNPS PF","Assurance Maternité","FDFP, Form.Prof.Continue","FDFP Taxe d'apprentissage","Retenues pour Gratif","Retenues pour Indem.Licenciement","Prime de transport non imposable","Indemnité de vehicule","Retenue Assurance Santé","Prêts et Autres\nRetenues","TOTAL GAINS","Totale Retenues Salarié","Totale Retenue Patronale","NET A\nPAYER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critère Vérifiaction"]
["2019-09-21","2019-07-01","001","M. BAKOFYEYA  INNOCENE","Chauffeur","0 an 1 mois",73480,35228,0,0,0,0,0,{"$f":"SUM(G5:M5)","v":108708},6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,{"$f":"N5+AB5","v":133708},{"$f":"O5+P5+Q5+R5+AD5+AE5","v":8707.5959999999995},{"$f":"S5+T5+U5+V5+W5+X5+Y5+Z5","v":25081.341999999997},{"$f":"AF5-AG5","v":125000.40399999999},{"$f":"IF(B5=\"\",\"\",\"Trim\"&TEXT(1+INT((MONTH(B5)-1)/3),\"#\")&\"-\"&TEXT(YEAR(B5),\"####\"))","v":"Trim3-2019"},{"$f":"PROPER(EnTexte(AI5))&\" \"&\"Francs\"&\" \"&\"CFA\"","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C5&TEXT(B5,\"mmmm\")&YEAR(B5)","v":"001juillet2019"}]
["2019-09-21","2019-07-01","002","M. BAMBA  DAOFDA","Chauffeur","0 an 1 mois",73480,35228,0,0,0,0,0,{"$f":"SUM(G6:M6)","v":108708},6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,{"$f":"N6+AB6","v":133708},{"$f":"O6+P6+Q6+R6+AD6+AE6","v":8707.5959999999995},{"$f":"S6+T6+U6+V6+W6+X6+Y6+Z6","v":25081.341999999997},{"$f":"AF6-AG6","v":125000.40399999999},{"$f":"IF(B6=\"\",\"\",\"Trim\"&TEXT(1+INT((MONTH(B6)-1)/3),\"#\")&\"-\"&TEXT(YEAR(B6),\"####\"))","v":"Trim3-2019"},{"$f":"PROPER(EnTexte(AI6))&\" \"&\"Francs\"&\" \"&\"CFA\"","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,"AFRILAND FIRST BANK",null,null,null,null,null,{"$f":"C6&TEXT(B6,\"mmmm\")&YEAR(B6)","v":"002juillet2019"}]
["2019-09-22","2019-07-01","003","M. BANDA  OFMAROF","Chauffeur","",73480,35228,0,0,0,0,0,108708,6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,133708,8707.5959999999995,25081.341999999997,125000.40399999999,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"003juillet2019"]
["2019-09-22","2019-07-01","004","M. CAMARA  ABDOFLAYE","Chauffeur","0 an 1 mois",73480,35228,0,0,0,0,0,108708,6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,133708,8707.5959999999995,25081.341999999997,125000.40399999999,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"004juillet2019"]
["2019-09-22","2019-07-01","005","M. CISSE  AYOFBA","Chauffeur","0 an 1 mois",73480,41709,0,0,0,0,0,115189,7256.9070000000002,5917.4127478260871,1382.268,632.2679999999998,1382.268,8869.5529999999999,3500,3500,525,691.13400000000001,460.75600000000003,7199.3125,2879.7249999999999,25000,0,0,0,140189,15188.855747826088,26128.023500000003,125000.14425217391,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"005juillet2019"]
["2019-09-22","2019-07-01","006","M. COFLIBALY  BAKARY","Chauffeur","0 an 1 mois",73480,37608,0,0,0,0,0,111088,6998.5439999999999,2173.1949818181829,1333.056,583.05600000000004,1333.056,8553.7759999999998,3500,3500,525,666.52800000000002,444.35200000000003,6943,2777.2000000000003,25000,0,0,0,136088,11087.850981818185,25465.712,125000.14901818181,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"006juillet2019"]
["2019-09-22","2019-07-01","007","M. COFLIBALY  KANIGFI","Chauffeur","0 an 1 mois",73480,41709,0,0,0,0,0,115189,7256.9070000000002,5917.4127478260871,1382.268,632.2679999999998,1382.268,8869.5529999999999,3500,3500,525,691.13400000000001,460.75600000000003,7199.3125,2879.7249999999999,25000,0,0,0,140189,15188.855747826088,26128.023500000003,125000.14425217391,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"007juillet2019"]
["2019-09-22","2019-07-01","008","M. COFLIBALY  KARIM","Chauffeur","0 an 1 mois",73480,35228,0,0,0,0,0,108708,6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,133708,8707.5959999999995,25081.341999999997,125000.40399999999,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"008juillet2019"]
["2019-09-22","2019-07-01","009","M. DIALLO  BRAHIMA","Chauffeur","0 an 1 mois",73480,36276,0,0,0,0,0,109756,6914.6279999999997,956.82341818181794,1317.0720000000001,567.07199999999989,1317.0720000000001,8451.2119999999995,3500,3500,525,658.53600000000006,439.024,6859.75,2743.8999999999996,25000,0,0,0,134756,9755.5954181818179,25250.594000000001,125000.40458181818,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"009juillet2019"]
["2019-09-22","2019-07-01","010","M. DIARRA LACINA","Chauffeur","0 an 1 mois",73480,35228,0,0,0,0,0,108708,6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,133708,8707.5959999999995,25081.341999999997,125000.40399999999,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"010juillet2019"]
["2019-09-22","2019-07-01","012","M. FAYAMA  MEDIBAYE","Chauffeur","0 an 1 mois",73480,41709,0,0,0,0,0,115189,7256.9070000000002,5917.4127478260871,1382.268,632.2679999999998,1382.268,8869.5529999999999,3500,3500,525,691.13400000000001,460.75600000000003,7199.3125,2879.7249999999999,25000,0,0,0,140189,15188.855747826088,26128.023500000003,125000.14425217391,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"012juillet2019"]
["2019-09-22","2019-07-01","013","M. HEMA  EIAKOFBE","Chauffeur","0 an 1 mois",73480,36276,0,0,0,0,0,109756,6914.6279999999997,956.82341818181794,1317.0720000000001,567.07199999999989,1317.0720000000001,8451.2119999999995,3500,3500,525,658.53600000000006,439.024,6859.75,2743.8999999999996,25000,0,0,0,134756,9755.5954181818179,25250.594000000001,125000.40458181818,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"013juillet2019"]
["2019-09-22","2019-07-01","014","M. KANAZOE  ZAKARIA","Chauffeur","0 an 1 mois",73480,36276,0,0,0,0,0,109756,6914.6279999999997,956.82341818181794,1317.0720000000001,567.07199999999989,1317.0720000000001,8451.2119999999995,3500,3500,525,658.53600000000006,439.024,6859.75,2743.8999999999996,25000,0,0,0,134756,9755.5954181818179,25250.594000000001,125000.40458181818,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"014juillet2019"]
["2019-09-22","2019-07-01","011","M. DIAWARA  ISSA","Chauffeur","0 an 1 mois",73480,35228,0,0,0,0,0,108708,6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,133708,8707.5959999999995,25081.341999999997,125000.40399999999,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"011juillet2019"]
["2019-09-22","2019-07-01","015","M. KARAMOGO  ZOFMANA","Chauffeur","0 an 1 mois",73480,35228,0,0,0,0,0,108708,6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,133708,8707.5959999999995,25081.341999999997,125000.40399999999,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"015juillet2019"]
["2019-09-22","2019-07-01","016","M. KEIEA  OFSMANE","Chauffeur","0 an 1 mois",73480,35228,0,0,0,0,0,108708,6848.6040000000003,0,1304.4960000000001,554.49599999999987,1304.4960000000001,8370.5159999999996,3500,3500,525,652.24800000000005,434.83199999999999,6794.25,2717.7,25000,0,0,0,133708,8707.5959999999995,25081.341999999997,125000.40399999999,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"016juillet2019"]
["2019-09-22","2019-07-01","017","M. NIKIAMA  ISSIAKA","Chauffeur","0 an 1 mois",73480,36276,0,0,0,0,0,109756,6914.6279999999997,956.82341818181794,1317.0720000000001,567.07199999999989,1317.0720000000001,8451.2119999999995,3500,3500,525,658.53600000000006,439.024,6859.75,2743.8999999999996,25000,0,0,0,134756,9755.5954181818179,25250.594000000001,125000.40458181818,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"017juillet2019"]
["2019-09-22","2019-07-01","018","M. KIMA  YAYA","Chauffeur","0 an 1 mois",73480,41709,0,0,0,0,0,115189,7256.9070000000002,5917.4127478260871,1382.268,632.2679999999998,1382.268,8869.5529999999999,3500,3500,525,691.13400000000001,460.75600000000003,7199.3125,2879.7249999999999,25000,0,0,0,140189,15188.855747826088,26128.023500000003,125000.14425217391,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"018juillet2019"]
["2019-09-25","2019-07-01","019","M. KONAEE  BANGALI","Chauffeur","0 an 1 mois",73480,37608,0,0,0,0,0,111088,6999,2173,1333,583,1333,8554,3500,3500,525,667,444,6943,2777,25000,0,0,0,136088,11088,25466,125000,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"019juillet2019"]
["2019-09-25","2019-07-01","052","Mme EKOUEVIE néé Fassinou Patricia","Directrice","",2500000,500000,50000,10000,0,0,30000,3090000,194670,504947,37080,231900,37080,237930,3500,3500,525,18540,12360,193125,77250,25000,100000,15000,0,3115000,983597,506560,2131403,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"052juillet2019"]
["2019-09-25","2019-08-01","051","M. KONE Datolo Hili","M&E Senior","",1600000,100000,0,5000,0,0,10000,1715000,108045,258067,20580,121900,20580,132055,3500,3500,525,10290,6860,107188,42875,25000,50000,15000,0,1740000,523592,284498,1216408,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"051août2019"]
["2019-09-25","2019-07-01","020","M. KONAEE  FOFSSENI","Chauffeur","0 an 1 mois",73480,37608,0,0,0,0,10000,121088,7629,2773,1453,703,1453,9324,3500,3500,525,727,484,7568,3027,25000,50000,15000,0,146088,27558,27081,118530,"Trim3-2019",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"020juillet2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"",{"$error":"#NAME?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janvier1900"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"© Copyright 2013 LOGIPAIE v50.1, Eric KOUASSI, tous droits réservés"]

{"sheet":"Paie Synthèse","index":2,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[34,3,34,4],[36,3,36,4]]}
[]
[]
[]
[null,null,null,"Du","2019-01-01","Au","2019-12-31"]
[]
[]
[]
[null,null,null,"Part salariale",null,"Part patronale",null,"Total"]
[null,null,"ITS ",null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!Q:Q)","v":84316.88},null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!S:S)","v":84316.88},{"$f":"SUM(E9:G9)","v":168633.76}]
[null,null,"CN",null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!R:R)","v":365456.88},null,null,{"$f":"SUM(E10:G10)","v":365456.88}]
[null,null,"IGR",null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!P:P)","v":797630.13964584982},null,null,{"$f":"SUM(E11:G11)","v":797630.13964584982}]
[null,null,"CE Local",null,null,null,null,{"$f":"SUM(E12:G12)","v":0}]
[null,null,"CE Expatrié",null,null,null,null,{"$f":"SUM(E13:G13)","v":0}]
[null,null,"Total Impots sur salaires",null,{"$f":"SUM(E9:E13)","v":1247403.8996458498},null,{"$f":"SUM(G9:G13)","v":84316.88},{"$f":"SUM(H9:H13)","v":1331720.77964585}]
[]
[null,null,"Prestations familiales",null,null,null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!U:U)","v":77000},{"$f":"SUM(E16:G16)","v":77000}]
[]
[null,null,"Assurance Maternité",null,null,null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!W:W)","v":11550},{"$f":"SUM(E18:G18)","v":11550}]
[]
[null,null,"Accident de travail",null,null,null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!U:U)","v":77000},{"$f":"SUM(E20:G20)","v":77000}]
[]
[null,null,"CR",null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!O:O)","v":442665.12},null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!T:T)","v":541034.48},{"$f":"SUM(E22:G22)","v":983699.6}]
[null,null,"Total Cotisation CNPS",null,{"$f":"SUM(E16:E22)","v":442665.12},null,{"$f":"SUM(G16:G22)","v":706584.48},{"$f":"SUM(H16:H22)","v":1149249.6000000001}]
[]
[null,null,"Taxe d'apprentissage",null,null,null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!Y:Y)","v":28104.960000000003},{"$f":"SUM(E25:G25)","v":28104.960000000003}]
[]
[null,null,"Taxe FPC",null,null,null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!X:X)","v":42159.44},{"$f":"SUM(E27:G27)","v":42159.44}]
[]
[]
[null,null,"Total Taxes FDFP",null,{"$f":"SUM(E25:E29)","v":0},null,{"$f":"SUM(G25:G29)","v":70264.400000000009},{"$f":"SUM(H25:H29)","v":70264.400000000009}]
[]
[null,null,"Total Impôts et Cotisations",null,{"$f":"SUM(E30,E23,E14)","v":1690069.0196458497},null,{"$f":"SUM(G30,G23,G14)","v":861165.76},{"$f":"E32+G32","v":2551234.77964585}]
[]
[]
[null,null,"Brut imposable",{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!N:N)","v":7026416},null,"Retenue /Assur.",null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!AD:AD)","v":45000}]
[]
[null,null,"Ind. de transport",{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!AB:AB)","v":550000},null,"Autres retenues",null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!Z:Z)+SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!AA:AA)+SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!AE:AE)","v":614811.5}]
[]
[null,null,"Autres gains",null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!AC:AC)","v":200000},"Net à payer",null,{"$f":"SUMPRODUCT(('LIVRE DE PAIE'!$A:$A>=$E$4)*('LIVRE DE PAIE'!$A:$A<=$G$4),'LIVRE DE PAIE'!AI:AI)","v":5841346.9803541508}]