{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DONNEES","B.D. ETAT DE PAIE","Bulletin de Paie"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":3,"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":"DONNEES","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[40,7,40,8],[0,0,0,11],[11,3,11,4],[3,3,3,6],[19,3,19,6],[7,3,7,4],[9,3,9,4],[13,3,13,4],[15,3,15,4],[17,3,17,4],[21,3,21,4],[23,3,23,4],[27,7,27,8],[27,2,27,4],[36,7,36,8]]}
["DONNEES"]
[]
[]
[null,"DENOMINATION DE LA SOCIETE",null,"STE XXXXXXX"]
[]
[null,"FORMEJURIDIQUE",null,"SARL","CAPITAL",null,100000]
[]
[null,"N° PATENTE",null,172172172]
[]
[null,"N° IF",null,414141]
[]
[null,"N° RC",null,222222]
[]
[null,"N° CNSS",null,123456789,null,null,"Part patronale",{"$f":"13.46%-4.48%+6.4%+1.6%","v":0.16980000000000001},"Part salariale",4.48E-2]
[]
[null,"N°CIMR",null,123456789,null,null,"Part patronale",3.9E-2,"Part salariale",0.03]
[]
[null,"N° ASSURANCE",null,123456789,null,null,"Part patronale",0.04,"Part salariale",0.03]
[]
[null,"ADRESSE",null," "]
[]
[null,"TEL",null,"000000000"]
[]
[null,"FAX",null,"00000000"]
[]
[]
[]
[null,null," Barème d'IR  Mensual",null,null,null,null,"Barème d'anciennté"]
[null,null,"Revenus","Taux","∑ à déduire",null,null,"Nbr années","Taux",null,"S.F."]
[null,null,0,0,0,null,null,0,0,null,"M"]
[null,null,2001,0.1,250,null,null,2,0.05,null,"C"]
[null,null,4167,0.2,666.67,null,null,5,0.1,null,"D"]
[null,null,5001,0.3,1166.67,null,null,12,0.15,null,"V"]
[null,null,6667,0.34,1433.33,null,null,20,0.2]
[null,null,15001,0.38,2033.33,null,null,25,0.25]
[]
[null,null,"FONCTIONS",null,null,null,null,"COTISATION AMO"]
[null,null,"D. Général",null,null,null,null,"Part patronale","Part salariale"]
[null,null,"D.Financier",null,null,null,null,4.1099999999999998E-2,2.2599999999999999E-2]
[null,null,"Technicien"]
[null,null,"Comptable",null,null,null,null,"COTISATION CNSS"]
[null,null,"Technicien",null,null,null,null,"Part patronale","Part salariale"]
[null,null,"Informaticien",null,null,null,null,0.16980000000000001,4.48E-2]
[null,null,"Secrétaire"]
[null,null,"Ouvrier"]
[null,null,"Concierge"]
[null,null,"Ingénieur"]

{"sheet":"B.D. ETAT DE PAIE","index":1,"n_rows":24,"n_cols":46,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,9,24,10],[1,2,4,17]]}
[]
[null,"Période de ","ETAT DE PAIE"]
[]
[null,"2022-01-31"]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44]
["IMMATRICLATION","Nom et prénom","Dates\nNaissances","Dates\nd'embauche","Fonction","Situation Fam","Nombre d'enfants","H,N","CHN","Salaire de\n base 1","HS","HS à\n 25%","CHS à\n 25%","HS à \n50%","CHS à\n 50%","HS à\n 100%","CHS à\n 100%","Salaire de\nBase 2","Prime\n d'anciennté","Prime de\nrendement","Prime de \nresponsabilité","Prime\nd'assiduité","Avantages \nen Natures","Avantages en \nEspèces","AF","FDJ","Salaire\nBrut","Salaire Brut\nImposable","IMMAT\nCNSS","CNSS\n4,48%","AMO\n2,26%","IMMAT\nCIMR","CIMR\n6%","IMMAT\nASSUR","Assurance\n3%","Frais Prof\n17%","Salaire\nImposable","Logement\nEconomique","Crédit log\nTraite","Crédit log\nIntérêt","SNI","IR BRUT","IR NET","Net à payer "]
["0001","SAID SAID","1980-03-02","1990-01-01","D. Général","M",1,190,72,{"$f":"H8*I8","v":13680},{"$f":"L8+N8+P8","v":24},10,{"$f":"(I8*25%)+I8","v":90},6,{"$f":"(I8*50%)+I8","v":108},8,{"$f":"(I8*100%)+I8","v":144},{"$f":"J8+L8*M8+N8*O8+P8*Q8","v":16380},{"$f":"VLOOKUP(($B$4-D8)/365,Barèmes_d_an,2)*R8","v":4095},{"$f":"K8*10","v":240},1000,500,3000,500,{"$f":"IF(G8>6,(3*150)+(3*36),IF(G8>3,(3*150)+(G8-3)*36,150*G8))","v":150},500,{"$f":"R8+S8+T8+U8+V8+W8+X8+Y8+Z8","v":26365},{"$f":"AA8-Y8-Z8","v":25715},159159159,{"$f":"IF((AB8>=6000),6000*DONNEES!$J$14,AB8*DONNEES!$J$14)","v":268.8},{"$f":"AB8*DONNEES!$I$39","v":581.15899999999999},224321,{"$f":"IF((AB8-W8)*DONNEES!$J$16>=900,900,(AB8-W8)*DONNEES!$J$16)","v":681.44999999999993},321456,{"$f":"R8*DONNEES!$J$18","v":491.4},{"$f":"IF((AB8-W8-X8)*17%>=2000,2000,(AB8-W8-X8)*17%)","v":2000},{"$f":"AB8-AD8-AE8-AG8-AI8-AJ8","v":21692.190999999999},"non",9000,1000,{"$f":"IF(AL8=\"oui\",IF((AM8+AN8)>=AK8*10%,AK8-(AK8*10%),AK8-(AM8+AN8)),IF(AN8>=AK8*10%,AK8-(AK8*10%),AK8-AN8))","v":20692.190999999999},{"$f":"AO8*VLOOKUP(AO8,IR,2)-VLOOKUP(AO8,IR,3)","v":5829.7025800000001},{"$f":"IF(AP8-IF(G8=0,0,IF((G8+1)<=6,(G8+1)*15,6*15))<0,0,AP8-IF(G8=0,0,IF((G8+1)<=6,(G8+1)*15,6*15)))","v":5799.7025800000001},{"$f":"AA8-AD8-AE8-AG8-AI8-AQ8","v":18542.488419999998},null,{"$f":"IF(OR(H8>190,I8<9.66),\"Vous n'avez pas repéctez le Droit de travail qui stipule que nbre HN<=190 et CHN>=9,66\",\"\")","v":""}]
[{"$f":"A8+1","v":2},"SAID SAID","1960-06-01","1981-07-26","D.Financier","M",4,190,66,{"$f":"H9*I9","v":12540},{"$f":"L9+N9+P9","v":0},0,{"$f":"(I9*25%)+I9","v":82.5},0,{"$f":"(I9*50%)+I9","v":99},0,{"$f":"(I9*100%)+I9","v":132},{"$f":"J9+L9*M9+N9*O9+P9*Q9","v":12540},{"$f":"VLOOKUP(($B$4-D9)/365,Barèmes_d_an,2)*R9","v":3135},0,null,null,null,null,486,null,{"$f":"R9+S9+T9+U9+V9+W9+X9+Y9+Z9","v":16161},{"$f":"AA9-Y9-Z9","v":15675},159159160,{"$f":"IF((AB9>=6000),6000*DONNEES!$J$14,AB9*DONNEES!$J$14)","v":268.8},{"$f":"AB9*DONNEES!$I$39","v":354.255},224322,{"$f":"IF((AB9-W9)*DONNEES!$J$16>=900,900,(AB9-W9)*DONNEES!$J$16)","v":470.25},321457,{"$f":"R9*DONNEES!$J$18","v":376.2},{"$f":"IF((AB9-W9-X9)*17%>=2000,2000,(AB9-W9-X9)*17%)","v":2000},{"$f":"AB9-AD9-AE9-AG9-AI9-AJ9","v":12205.495000000001},null,null,null,{"$f":"IF(AL9=\"oui\",IF((AM9+AN9)>=AK9*10%,AK9-(AK9*10%),AK9-(AM9+AN9)),IF(AN9>=AK9*10%,AK9-(AK9*10%),AK9-AN9))","v":12205.495000000001},{"$f":"AO9*VLOOKUP(AO9,IR,2)-VLOOKUP(AO9,IR,3)","v":2716.5383000000011},{"$f":"IF(AP9-IF(G9=0,0,IF((G9+1)<=6,(G9+1)*15,6*15))<0,0,AP9-IF(G9=0,0,IF((G9+1)<=6,(G9+1)*15,6*15)))","v":2641.5383000000011},{"$f":"AA9-AD9-AE9-AG9-AI9-AQ9","v":12049.956699999999},null,{"$f":"IF(OR(H9>190,I9<9.66),\"Vous n'avez pas repéctez le Droit de travail qui stipule que nbre HN<=190 et CHN>=9,66\",\"\")","v":""}]
[{"$f":"A9+1","v":3},"SAID SAID","1970-12-12","2000-02-15","Comptable","M",4,160,28.13,4500.8,{"$f":"L10+N10+P10","v":16},8,35.162500000000001,4,42.195,4,56.26,5175.92,1035.184,160,null,null,null,null,486,400,7257.1040000000003,6371.1040000000003,159159161,{"$f":"IF((AB10>=6000),6000*DONNEES!$J$14,AB10*DONNEES!$J$14)","v":268.8},{"$f":"AB10*DONNEES!$I$39","v":143.98695039999998},224323,{"$f":"IF((AB10-W10)*DONNEES!$J$16>=900,900,(AB10-W10)*DONNEES!$J$16)","v":191.13311999999999},321458,{"$f":"R10*DONNEES!$J$18","v":155.27760000000001},1083.0876800000001,4528.8186495999998,null,null,null,4528.8186495999998,239.0937299200001,164.0937299200001,6333.812599679999,null,""]
[4,"SAID SAID","1977-08-10","2006-01-01","Technicien","C",0,190,24.04,4567.5999999999995,{"$f":"L11+N11+P11","v":0},0,30.049999999999997,0,36.06,0,48.08,4567.5999999999995,685.13999999999987,0,null,null,null,null,0,null,5252.74,5252.74,159159162,{"$f":"IF((AB11>=6000),6000*DONNEES!$J$14,AB11*DONNEES!$J$14)","v":235.32275199999998},{"$f":"AB11*DONNEES!$I$39","v":118.71192399999998},224324,{"$f":"IF((AB11-W11)*DONNEES!$J$16>=900,900,(AB11-W11)*DONNEES!$J$16)","v":157.5822},321459,{"$f":"R11*DONNEES!$J$18","v":137.02799999999999},892.96580000000006,3711.1293239999995,"non",1600,600,3340.0163915999997,84.001639159999968,84.001639159999968,4520.0934848399993,null,""]
[5,"SAID SAID","1975-05-01","1980-01-01","Technicien","M",6,190,14.4,2736,{"$f":"L12+N12+P12","v":24},4,18,12,21.6,8,28.8,3297.6,824.4,240,null,null,null,null,558,null,4920,4362,159159163,{"$f":"IF((AB12>=6000),6000*DONNEES!$J$14,AB12*DONNEES!$J$14)","v":195.41759999999999},{"$f":"AB12*DONNEES!$I$39","v":98.581199999999995},224325,{"$f":"IF((AB12-W12)*DONNEES!$J$16>=900,900,(AB12-W12)*DONNEES!$J$16)","v":130.85999999999999},321460,{"$f":"R12*DONNEES!$J$18","v":98.927999999999997},741.54000000000008,3096.6732000000002,null,null,null,3096.6732000000002,59.667320000000018,0,4396.2132000000011,null,""]
[6,"SAID SAID","1965-01-06","1999-06-16","Ouvrier","M",3,190,14.56,2766.4,0,0,18.2,0,21.84,0,29.12,2766.4,553.28000000000009,0,null,null,null,null,450,800,4569.68,3319.6800000000003,159159164,{"$f":"IF((AB13>=6000),6000*DONNEES!$J$14,AB13*DONNEES!$J$14)","v":148.721664},{"$f":"AB13*DONNEES!$I$39","v":75.024768000000009},224326,{"$f":"IF((AB13-W13)*DONNEES!$J$16>=900,900,(AB13-W13)*DONNEES!$J$16)","v":99.590400000000002},321461,{"$f":"R13*DONNEES!$J$18","v":82.992000000000004},564.3456000000001,2349.0055679999996,null,null,null,2349.0055679999996,-15.099443200000024,0,4163.3511680000001,null,""]
[7,"SAID SAID","1966-04-04","1986-01-01","Ouvrier","M",7,190,12.02,2283.7999999999997,0,0,15.024999999999999,0,18.03,0,24.04,2283.7999999999997,570.94999999999993,0,null,500,800,350,558,650,5712.75,4504.75,159159165,{"$f":"IF((AB14>=6000),6000*DONNEES!$J$14,AB14*DONNEES!$J$14)","v":201.81280000000001},{"$f":"AB14*DONNEES!$I$39","v":101.80735},224327,{"$f":"IF((AB14-W14)*DONNEES!$J$16>=900,900,(AB14-W14)*DONNEES!$J$16)","v":111.1425},321462,{"$f":"R14*DONNEES!$J$18","v":68.513999999999996},570.3075,3451.1658500000003,"oui",1000,250,3106.0492650000001,60.604926500000033,0,5229.4733500000002,null,""]
[8,"SAID SAID","1977-09-02","1986-04-21","Technicien","D",1,190,15,2850,17,5,18.75,10,22.5,2,30,3228.75,807.1875,170,null,null,null,null,150,null,4355.9375,4205.9375,159159166,{"$f":"IF((AB15>=6000),6000*DONNEES!$J$14,AB15*DONNEES!$J$14)","v":188.42599999999999},{"$f":"AB15*DONNEES!$I$39","v":95.054187499999998},224328,{"$f":"IF((AB15-W15)*DONNEES!$J$16>=900,900,(AB15-W15)*DONNEES!$J$16)","v":126.17812499999999},321463,{"$f":"R15*DONNEES!$J$18","v":96.862499999999997},715.00937500000009,2984.4073125,null,null,null,2984.4073125,48.440731249999999,18.440731249999999,3830.9759562499994,null,""]
[9,"SAID SAID","1981-10-09","2005-02-11","Informaticien","M",3,156,15,2340,11,5,18.75,2,22.5,4,30,2598.75,389.8125,110,1000,null,null,null,450,null,4548.5625,4098.5625,159159167,{"$f":"IF((AB16>=6000),6000*DONNEES!$J$14,AB16*DONNEES!$J$14)","v":183.6156},{"$f":"AB16*DONNEES!$I$39","v":92.627512499999995},224329,{"$f":"IF((AB16-W16)*DONNEES!$J$16>=900,900,(AB16-W16)*DONNEES!$J$16)","v":122.956875},321464,{"$f":"R16*DONNEES!$J$18","v":77.962499999999991},696.75562500000001,2924.6443874999995,null,null,null,2924.6443874999995,42.464438749999943,0,4071.4000124999998,null,""]
[10,"SAID SAID","1985-07-01","2006-05-28","Secrétaire","C",0,130,9.66,1255.8,26,9,12.074999999999999,13,14.49,4,19.32,1630.1249999999998,244.51874999999995,260,null,null,null,null,0,null,2134.6437499999997,2134.6437499999997,159159168,{"$f":"IF((AB17>=6000),6000*DONNEES!$J$14,AB17*DONNEES!$J$14)","v":95.632039999999989},{"$f":"AB17*DONNEES!$I$39","v":48.242948749999989},224330,{"$f":"IF((AB17-W17)*DONNEES!$J$16>=900,900,(AB17-W17)*DONNEES!$J$16)","v":64.039312499999994},321465,{"$f":"R17*DONNEES!$J$18","v":48.903749999999988},362.88943749999999,1514.9362612499997,null,null,null,1514.9362612499997,0,0,1877.8256987499997,null,""]
[11,"SAID SAID","1978-04-08","2006-05-30","Ouvrier","C",0,120,10,1200,0,null,12.5,null,15,null,20,1200,180,0,null,null,null,null,0,null,1380,1380,159159169,{"$f":"IF((AB18>=6000),6000*DONNEES!$J$14,AB18*DONNEES!$J$14)","v":61.823999999999998},{"$f":"AB18*DONNEES!$I$39","v":31.187999999999999},224331,{"$f":"IF((AB18-W18)*DONNEES!$J$16>=900,900,(AB18-W18)*DONNEES!$J$16)","v":41.4},321466,{"$f":"R18*DONNEES!$J$18","v":36},234.60000000000002,974.98799999999972,null,null,null,974.98799999999972,0,0,1209.5879999999997,null,""]
[12,"SAID SAID","1980-06-07","2006-05-30","Ingénieur","M",8,190,60,11400,14,2,75,5,90,7,120,12840,1926,140,800,800,1000,null,558,null,18064,17506,159159170,{"$f":"IF((AB19>=6000),6000*DONNEES!$J$14,AB19*DONNEES!$J$14)","v":268.8},{"$f":"AB19*DONNEES!$I$39","v":395.63559999999995},224332,{"$f":"IF((AB19-W19)*DONNEES!$J$16>=900,900,(AB19-W19)*DONNEES!$J$16)","v":495.18},321467,{"$f":"R19*DONNEES!$J$18","v":385.2},2000,13961.184399999998,null,null,null,13961.184399999998,3313.4726959999998,3223.4726959999998,13295.711703999998,null,""]
[13,"SAID SAID","1960-01-12","2006-07-01","Comptable","M",2,190,20,3800,7,5,25,1,30,1,40,3995,599.25,70,null,null,null,null,300,null,4964.25,4664.25,159159171,{"$f":"IF((AB20>=6000),6000*DONNEES!$J$14,AB20*DONNEES!$J$14)","v":208.95840000000001},{"$f":"AB20*DONNEES!$I$39","v":105.41204999999999},224333,{"$f":"IF((AB20-W20)*DONNEES!$J$16>=900,900,(AB20-W20)*DONNEES!$J$16)","v":139.92749999999998},321468,{"$f":"R20*DONNEES!$J$18","v":119.85},792.92250000000001,3297.1795499999998,null,null,null,3297.1795499999998,79.717955000000018,34.717955000000018,4355.3840949999994,null,""]
[14,"SAID SAID","1977-04-08","2006-08-04","Ingénieur","C",0,190,60,11400,17,7,75,4,90,6,120,13005,1950.75,170,300,300,null,null,0,null,15725.75,15725.75,159159172,{"$f":"IF((AB21>=6000),6000*DONNEES!$J$14,AB21*DONNEES!$J$14)","v":268.8},{"$f":"AB21*DONNEES!$I$39","v":355.40195},224334,{"$f":"IF((AB21-W21)*DONNEES!$J$16>=900,900,(AB21-W21)*DONNEES!$J$16)","v":471.77249999999998},321469,{"$f":"R21*DONNEES!$J$18","v":390.15},2000,12239.625550000002,null,null,null,12239.625550000002,2728.1426870000014,2728.1426870000014,11511.482863000001,null,""]
[15,"SAID SAID","1979-05-06","2006-09-05","Technicien","M",4,180,15,2700,0,null,18.75,null,22.5,null,30,2700,405,0,null,300,null,null,486,null,3891,3405,159159173,{"$f":"IF((AB22>=6000),6000*DONNEES!$J$14,AB22*DONNEES!$J$14)","v":152.54400000000001},{"$f":"AB22*DONNEES!$I$39","v":76.952999999999989},224335,{"$f":"IF((AB22-W22)*DONNEES!$J$16>=900,900,(AB22-W22)*DONNEES!$J$16)","v":102.14999999999999},321470,{"$f":"R22*DONNEES!$J$18","v":81},578.85,2413.5030000000002,null,null,null,2413.5030000000002,-8.6496999999999673,0,3478.3530000000001,null,""]
[16,"SAID SAID","1977-01-01","2006-10-01","Concierge","M",2,190,9.66,1835.4,0,null,12.074999999999999,null,14.49,null,19.32,1835.4,275.31,0,null,null,null,null,300,null,2410.71,2110.71,159159174,{"$f":"IF((AB23>=6000),6000*DONNEES!$J$14,AB23*DONNEES!$J$14)","v":94.559808000000004},{"$f":"AB23*DONNEES!$I$39","v":47.702045999999996},224336,{"$f":"IF((AB23-W23)*DONNEES!$J$16>=900,900,(AB23-W23)*DONNEES!$J$16)","v":63.321300000000001},321471,{"$f":"R23*DONNEES!$J$18","v":55.061999999999998},358.82070000000004,1491.2441460000002,null,null,null,1491.2441460000002,0,0,2150.0648460000002,null,""]
[{"$f":"A23+1","v":17},"SAID SAID",null,null,null,null,null,null,null,{"$f":"H24*I24","v":0},{"$f":"L24+N24+P24","v":0},null,{"$f":"(I24*25%)+I24","v":0},null,{"$f":"(I24*50%)+I24","v":0},null,{"$f":"(I24*100%)+I24","v":0},{"$f":"J24+L24*M24+N24*O24+P24*Q24","v":0},{"$f":"VLOOKUP(($B$4-D24)/365,Barèmes_d_an,2)*R24","v":0},{"$f":"K24*10","v":0},null,null,null,null,{"$f":"IF(G24>6,(3*150)+(3*36),IF(G24>3,(3*150)+(G24-3)*36,150*G24))","v":0},null,{"$f":"R24+S24+T24+U24+V24+W24+X24+Y24+Z24","v":0},{"$f":"AA24-Y24-Z24","v":0},null,{"$f":"IF((AB24>=6000),6000*DONNEES!$J$14,AB24*DONNEES!$J$14)","v":0},{"$f":"AB24*DONNEES!$I$39","v":0},null,{"$f":"IF((AB24-W24)*DONNEES!$J$16>=900,900,(AB24-W24)*DONNEES!$J$16)","v":0},null,{"$f":"R24*DONNEES!$J$18","v":0},{"$f":"IF((AB24-W24-X24)*17%>=2000,2000,(AB24-W24-X24)*17%)","v":0},{"$f":"AB24-AD24-AE24-AG24-AI24-AJ24","v":0},null,null,null,{"$f":"IF(AL24=\"oui\",IF((AM24+AN24)>=AK24*10%,AK24-(AK24*10%),AK24-(AM24+AN24)),IF(AN24>=AK24*10%,AK24-(AK24*10%),AK24-AN24))","v":0},{"$f":"AO24*VLOOKUP(AO24,IR,2)-VLOOKUP(AO24,IR,3)","v":0},{"$f":"IF(AP24-IF(G24=0,0,IF((G24+1)<=6,(G24+1)*15,6*15))<0,0,AP24-IF(G24=0,0,IF((G24+1)<=6,(G24+1)*15,6*15)))","v":0},{"$f":"AA24-AD24-AE24-AG24-AI24-AQ24","v":0}]

{"sheet":"Bulletin de Paie","index":2,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[24,5,24,6],[25,5,25,6],[26,5,26,6],[23,5,23,6],[27,5,27,6],[31,5,31,6],[3,4,3,5],[2,12,2,13],[1,2,1,3],[12,12,12,13],[11,12,11,13],[1,12,1,13],[12,6,12,11],[13,0,13,2],[9,0,9,13],[11,0,11,2],[12,0,12,2],[13,9,13,11],[13,7,13,8],[13,12,13,13],[11,3,11,5],[12,3,12,5],[11,6,11,11],[16,12,16,13],[17,5,17,6],[17,12,17,13],[17,8,17,11],[16,8,16,11],[22,8,22,11],[23,8,23,11],[19,12,19,13],[14,0,14,2],[16,0,16,4],[16,5,16,6],[14,12,14,13],[18,12,18,13],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[14,9,14,11],[14,7,14,8],[18,5,18,6],[38,8,38,11],[18,8,18,11],[19,8,19,11],[20,8,20,11],[21,8,21,11],[20,12,20,13],[30,8,30,11],[31,8,31,11],[21,12,21,13],[22,12,22,13],[23,12,23,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[36,8,36,11],[44,0,44,13],[24,8,24,11],[25,8,25,11],[26,8,26,11],[27,8,27,11],[28,8,28,11],[29,8,29,11],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[29,12,29,13],[32,5,32,6],[33,5,33,6],[33,8,33,11],[32,8,32,11],[37,5,37,6],[39,5,39,7],[38,0,38,7],[28,5,28,6],[29,5,29,6],[30,5,30,6],[43,0,43,4],[40,5,40,6],[41,5,41,6],[42,0,42,4],[42,5,42,6],[43,5,43,6],[40,0,40,4],[41,0,41,4],[33,12,33,13],[34,12,34,13],[35,12,35,13],[34,5,34,6],[34,8,34,11],[35,8,35,11],[35,5,35,6],[39,0,39,4],[36,5,36,6],[43,12,43,13],[41,12,41,13],[42,12,42,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[40,12,40,13],[39,8,39,13]]}
[]
[null,null,{"$f":"DONNEES!D4","v":"STE XXXXXXX"},null,{"$f":"DONNEES!D6","v":"SARL"},"de Capital de :",null,{"$f":"DONNEES!G6","v":100000},null,null,null,null,"MOIS DE PAIE :"]
[null,null,{"$f":"DONNEES!D20","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"+'B.D. ETAT DE PAIE'!B4","v":"2022-01-31"}]
[null,null,null,"N° TEL :",{"$f":"+DONNEES!D22","v":"000000000"},null,"N° FAX :",{"$f":"+DONNEES!D24","v":"00000000"}]
[null,null,"CNSS :",{"$f":"DONNEES!D8","v":172172172},"N° IF :",{"$f":"DONNEES!D10","v":414141},"N° PAT :",{"$f":"DONNEES!D8","v":172172172}]
[null,null,"N° RC :",{"$f":"+DONNEES!D12","v":222222},"N° CIMR :",{"$f":"+DONNEES!D16","v":123456789},"N° ASSUR :",{"$f":"+DONNEES!D18","v":123456789}]
[]
[]
[]
["BULLETIN DE PAIE"]
[]
["Matricule",null,null,"Nom et prénom",null,null,"Fonction",null,null,null,null,null,"Mode de Paiement"]
[13,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,2)","v":"SAID SAID"},null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,5)","v":"Comptable"},null,null,null,null,null,"Virement"]
["Date\nNaissance",null,null,"Date\nEmbauche","Sit. Fam","Nbre\nEnf","Matricule\nCIMR","Matricule\nASSUR",null,"Matricule\nCNSS",null,null,"Durée\nTravaillée"]
[{"$f":"VLOOKUP(A13,ETAT_PAIE,3)","v":"1960-01-12"},null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,4)","v":"2006-07-01"},{"$f":"VLOOKUP(A13,ETAT_PAIE,6)","v":"M"},{"$f":"VLOOKUP(A13,ETAT_PAIE,7)","v":2},{"$f":"VLOOKUP(A13,ETAT_PAIE,32)","v":224333},{"$f":"VLOOKUP(A13,ETAT_PAIE,34)","v":321468},null,{"$f":"VLOOKUP(A13,ETAT_PAIE,29)","v":159159171},null,null,{"$f":"('B.D. ETAT DE PAIE'!B4-D15)","v":5693}]
[]
["Libellé",null,null,null,null,"Bases",null,"Taux","Gains",null,null,null,"Retenues"]
[null,"SALAIRE DE BASE",null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,18)","v":3995}]
[null,null,"Heures normales",null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,8)","v":190},null,{"$f":"VLOOKUP(A13,ETAT_PAIE,9)","v":20},{"$f":"VLOOKUP(A13,ETAT_PAIE,10)","v":3800}]
[null,null,"Heures supplémentaires",null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,11)","v":7},null,{"$f":"IF(F20=0,0,I20/F20)","v":27.857142857142858},{"$f":"VLOOKUP(A13,ETAT_PAIE,13)*VLOOKUP(A13,ETAT_PAIE,12)+VLOOKUP(A13,ETAT_PAIE,15)*VLOOKUP(A13,ETAT_PAIE,14)+VLOOKUP(A13,ETAT_PAIE,17)*VLOOKUP(A13,ETAT_PAIE,16)","v":195}]
[null,"Prime d'ancienneté",null,null,null,null,null,null,{"$f":"VLOOKUP($A$13,ETAT_PAIE,19)","v":599.25}]
[null,"Prime de rendement",null,null,null,null,null,null,{"$f":"VLOOKUP($A$13,ETAT_PAIE,20)","v":70}]
[null,"Prime de \nresponsabilité",null,null,null,null,null,null,{"$f":"VLOOKUP($A$13,ETAT_PAIE,21)","v":0}]
[null,"Prime\nd'assiduité",null,null,null,null,null,null,{"$f":"VLOOKUP($A$13,ETAT_PAIE,22)","v":0}]
[null,"Avantages \nen Natures",null,null,null,null,null,null,{"$f":"VLOOKUP($A$13,ETAT_PAIE,23)","v":0}]
[null,"Avantages en \nEspèces",null,null,null,null,null,null,{"$f":"VLOOKUP($A$13,ETAT_PAIE,24)","v":0}]
[null,"Allocations familiales",null,null,null,null,null,null,{"$f":"VLOOKUP($A$13,ETAT_PAIE,25)","v":300}]
[null,"Frais de déplacements justifies",null,null,null,null,null,null,{"$f":"VLOOKUP($A$13,ETAT_PAIE,26)","v":0}]
[null,"SALAIRE BRUT",null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,27)","v":4964.25}]
[null,"SALAIRE BRUT IMPOSABLE",null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,28)","v":4664.25}]
[null,"Cotisation CNSS",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,30)","v":208.95840000000001}]
[null,"Cotisation AMO",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,31)","v":105.41204999999999}]
[null,"Cotisation CIMR",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,33)","v":139.92749999999998}]
[null,"Cotisation Assurance",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,35)","v":119.85}]
[null,"SALAIRE NET IMPOSABLE",null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,41)","v":3297.1795499999998}]
[null,"IR net",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,43)","v":34.717955000000018}]
[]
[]
["TOTAUX",null,null,null,null,null,null,null,{"$f":"SUM(I19:K28)","v":4964.25},null,null,null,{"$f":"SUM(M31:N34)+M36","v":608.86590500000011}]
[null,null,null,null,null,"NET A PAYER",null,null,{"$f":"VLOOKUP(A13,ETAT_PAIE,44)","v":4355.3840949999994}]
[null,null,null,null,null,"SIGNATURE :"]
[]
[]
[]
["Dans votre intérêt, conservez ce bulletin sans limitation de durée."]