{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["(38)","(38) original"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"(38)","index":0,"n_rows":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,20,0,22],[8,14,13,15]]}
["MATRICULE","NOM","PRENOM","FONCTION","SALAIRE DE BASE","PANIER","TRANSPORT","SALAIRE DE POSTE","RETENUE SS","SALAIRE IMPOSABLE","IRG","Abattement","IRG retenu","SALAIRE NET","augmentation","nouveau salaire","%IRG","Calcul macro",null,null,"Table impôts",null,null,null,"simplif IRG","equiv()","Sal imposable 1","Sal net",null,"Sal net",null,null,"Formule matricielle"]
["00007","SALAIER 1","NABIL","SUPPORT MERCHANDISER",39401.1,6000,6000,{"$f":"+E2","v":39401.1},{"$f":"ROUND(H2*0.09,2)","v":3546.1},{"$f":"+H2-I2+F2+G2","v":47855},{"$f":"VLOOKUP(ROUNDDOWN(J2/Q2,-1),$U$2:$W$5,2,TRUE)*(ROUNDDOWN(J2/Q2,-1)-VLOOKUP(ROUNDDOWN(J2/Q2,-1),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUNDDOWN(J2/Q2,-1),$U$2:$W$5,3,TRUE)","v":9355},{"$f":"IF(ROUNDDOWN(J2/Q2,-1)*40%<1000,1000,IF(ROUNDDOWN(J2/Q2,-1)*40%>1500,1500, ROUNDDOWN(J2/Q2,-1)*40%))","v":1500},{"$f":"K2-L2","v":7855},{"$f":"H2-I2-K2+F2+G2+L2","v":40000},5000,{"$f":"N2+O2","v":45000},1,{"$f":"Sal_base(P2,F2,G2,Q2)","v":47249.45},null,null,0,0,null,null,{"$f":"VLOOKUP(J2,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((J2/Q2),-1)-VLOOKUP(J2,$U$2:$W$5,1,TRUE))+VLOOKUP(J2,$U$2:$W$5,3,TRUE)","v":9355},{"$f":"MATCH(P2,$U$2:$U$5-$W$2:$W$5,1)","v":3},{"$f":"ROUND((P2-INDEX($V$2:$V$5,Z2)*INDEX($U$2:$U$5,Z2)+INDEX($W$2:$W$5,Z2))/(1-INDEX($V$2:$V$5,Z2)),2)","v":57142.86},{"$f":"ROUND((P2+VLOOKUP(AA2,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((AA2/Q2),-1)-VLOOKUP(AA2,$U$2:$W$5,1,TRUE))+VLOOKUP(AA2,$U$2:$W$5,3,TRUE)-G2-F2)/0.91,2)","v":49606.59},null,{"$f":"ROUND((P2+VLOOKUP(ROUND((P2-INDEX($V$2:$V$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,2,TRUE)*(ROUNDDOWN((ROUND((P2-INDEX($V$2:$V$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))),2)/Q2),-1)-VLOOKUP(ROUND((P2-INDEX($V$2:$V$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUND((P2-INDEX($V$2:$V$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P2,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,3,TRUE)-G2-F2-L2)/0.91,2)","v":47958.239999999998},{"$f":"MAX(1000,MIN(1500,J2*40%))","v":1500},{"$f":"H2\n-ROUND(H2*0.09,2)\n-(VLOOKUP(H2-ROUND(H2*0.09,2)+F2+G2,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((H2-ROUND(H2*0.09,2)+F2+G2)/Q2,-1)-VLOOKUP(H2-ROUND(H2*0.09,2)+F2+G2,$U$2:$W$5,1,TRUE))+VLOOKUP(H2-ROUND(H2*0.09,2)+F2+G2,$U$2:$W$5,3,TRUE))\n+F2+G2\n+IF((H2-(ROUND(H2*0.09,2))+F2+G2)*40%<1000,1000,IF((H2-(ROUND(H2*0.09,2))+F2+G2)*40%>1500,1500, (H2-(ROUND(H2*0.09,2))+F2+G2)*40%))","v":40000},"=MIN(SI((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)\n-ARRONDI((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)*0,09;2)\n-(RECHERCHEV((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)-ARRONDI((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)*0,09;2)+F2+G2;$Y$2:$AA$5;2;VRAI)*(ARRONDI.INF(((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)-ARRONDI((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)*0,09;2)+F2+G2)/Q2;-1)-RECHERCHEV((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)-ARRONDI((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)*0,09;2)+F2+G2;$Y$2:$AA$5;1;VRAI))+RECHERCHEV((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)-ARRONDI((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)*0,09;2)+F2+G2;$Y$2:$AA$5;3;VRAI))\n+F2+G2\n+SI(ARRONDI(((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)*(1-0,09)+F2+G2)*40%;2)<1000;1000;SI(ARRONDI(((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)*(1-0,09)+F2+G2)*40%;2)>1500;1500; ARRONDI(((H2+LIGNE(INDIRECT(\"1:1000000\"))/100)*(1-0,09)+F2+G2)*40%;2)))>=P2;H2+LIGNE(INDIRECT(\"1:1000000\"))/100;9^9))"]
["00033","SALAIER 2","MOHAMED AMINE","Responsable Marketing",181735.71,23078,23078,181735.71,16356.21,211535.5,{"$f":"VLOOKUP(ROUNDDOWN(J3/Q3,-1),$U$2:$W$5,2,TRUE)*(ROUNDDOWN(J3/Q3,-1)-VLOOKUP(ROUNDDOWN(J3/Q3,-1),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUNDDOWN(J3/Q3,-1),$U$2:$W$5,3,TRUE)","v":63035.5},{"$f":"IF(ROUNDDOWN(J3/Q3,-1)*40%<1000,1000,IF(ROUNDDOWN(J3/Q3,-1)*40%>1500,1500, ROUNDDOWN(J3/Q3,-1)*40%))","v":1500},61535.5,150000,7000,{"$f":"N3+O3","v":157000},1,{"$f":"Sal_base(P3,F3,G3,Q3)","v":193570.33},null,null,10000,0.2,{"$f":"V2*(U3-U2)","v":0},null,{"$f":"VLOOKUP(J3,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((J3/Q3),-1)-VLOOKUP(J3,$U$2:$W$5,1,TRUE))+VLOOKUP(J3,$U$2:$W$5,3,TRUE)","v":63035.5},{"$f":"MATCH(P3,$U$2:$U$5-$W$2:$W$5,1)","v":4},{"$f":"ROUND((P3-INDEX($V$2:$V$5,Z3)*INDEX($U$2:$U$5,Z3)+INDEX($W$2:$W$5,Z3))/(1-INDEX($V$2:$V$5,Z3)),2)","v":224615.38},{"$f":"ROUND((P3+VLOOKUP(AA3,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((AA3/Q3),-1)-VLOOKUP(AA3,$U$2:$W$5,1,TRUE))+VLOOKUP(AA3,$U$2:$W$5,3,TRUE)-G3-F3)/0.91,2)","v":196107.14},null,{"$f":"ROUND((P3+VLOOKUP(ROUND((P3-INDEX($V$2:$V$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,2,TRUE)*(ROUNDDOWN((ROUND((P3-INDEX($V$2:$V$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))),2)/Q3),-1)-VLOOKUP(ROUND((P3-INDEX($V$2:$V$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUND((P3-INDEX($V$2:$V$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P3,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,3,TRUE)-G3-F3)/0.91,2)","v":196107.14}]
["00035","SALAIER 3","NESRINE SOUHILA","Assistante SAV",39401.1,6000,6000,39401.1,3546.1,47855,9355,1500,7855,40000,4500,44500,1,46465.93,null,null,30000,0.3,{"$f":"W3+V3*(U4-U3)","v":4000},null,{"$f":"VLOOKUP(J4,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((J4/Q4),-1)-VLOOKUP(J4,$U$2:$W$5,1,TRUE))+VLOOKUP(J4,$U$2:$W$5,3,TRUE)","v":9355},{"$f":"MATCH(P4,$U$2:$U$5-$W$2:$W$5,1)","v":3},{"$f":"ROUND((P4-INDEX($V$2:$V$5,Z4)*INDEX($U$2:$U$5,Z4)+INDEX($W$2:$W$5,Z4))/(1-INDEX($V$2:$V$5,Z4)),2)","v":56428.57},{"$f":"ROUND((P4+VLOOKUP(AA4,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((AA4/Q4),-1)-VLOOKUP(AA4,$U$2:$W$5,1,TRUE))+VLOOKUP(AA4,$U$2:$W$5,3,TRUE)-G4-F4)/0.91,2)","v":48819.78},null,{"$f":"ROUND((P4+VLOOKUP(ROUND((P4-INDEX($V$2:$V$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,2,TRUE)*(ROUNDDOWN((ROUND((P4-INDEX($V$2:$V$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))),2)/Q4),-1)-VLOOKUP(ROUND((P4-INDEX($V$2:$V$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUND((P4-INDEX($V$2:$V$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P4,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,3,TRUE)-G4-F4)/0.91,2)","v":48819.78}]
["00037","SALAIER 4","ADEL AMAR","Magasinier",39401.1,6000,6000,39401.1,3546.1,47855,9355,1500,7855,40000,3000,43000,1,44108.79,null,null,120000,0.35,{"$f":"W4+V4*(U5-U4)","v":31000},null,{"$f":"VLOOKUP(J5,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((J5/Q5),-1)-VLOOKUP(J5,$U$2:$W$5,1,TRUE))+VLOOKUP(J5,$U$2:$W$5,3,TRUE)","v":9355},{"$f":"MATCH(P5,$U$2:$U$5-$W$2:$W$5,1)","v":3},{"$f":"ROUND((P5-INDEX($V$2:$V$5,Z5)*INDEX($U$2:$U$5,Z5)+INDEX($W$2:$W$5,Z5))/(1-INDEX($V$2:$V$5,Z5)),2)","v":54285.71},{"$f":"ROUND((P5+VLOOKUP(AA5,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((AA5/Q5),-1)-VLOOKUP(AA5,$U$2:$W$5,1,TRUE))+VLOOKUP(AA5,$U$2:$W$5,3,TRUE)-G5-F5)/0.91,2)","v":46465.93},null,{"$f":"ROUND((P5+VLOOKUP(ROUND((P5-INDEX($V$2:$V$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,2,TRUE)*(ROUNDDOWN((ROUND((P5-INDEX($V$2:$V$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))),2)/Q5),-1)-VLOOKUP(ROUND((P5-INDEX($V$2:$V$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUND((P5-INDEX($V$2:$V$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P5,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,3,TRUE)-G5-F5)/0.91,2)","v":46465.93},null,{"$f":"H2-(ROUND(H2*0.09,2))+F2+G2","v":47855}]
["00041","SALAIER 5","AHMED","Coordinateur De Projet",251052.2,30000,30000,251052.2,22594.7,288457.5,89957.5,1500,88457.5,200000,4400,204400,1,258491.21,null,null,null,null,null,null,{"$f":"VLOOKUP(J6,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((J6/Q6),-1)-VLOOKUP(J6,$U$2:$W$5,1,TRUE))+VLOOKUP(J6,$U$2:$W$5,3,TRUE)","v":89957.5},{"$f":"MATCH(P6,$U$2:$U$5-$W$2:$W$5,1)","v":4},{"$f":"ROUND((P6-INDEX($V$2:$V$5,Z6)*INDEX($U$2:$U$5,Z6)+INDEX($W$2:$W$5,Z6))/(1-INDEX($V$2:$V$5,Z6)),2)","v":297538.46000000002},{"$f":"ROUND((P6+VLOOKUP(AA6,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((AA6/Q6),-1)-VLOOKUP(AA6,$U$2:$W$5,1,TRUE))+VLOOKUP(AA6,$U$2:$W$5,3,TRUE)-G6-F6)/0.91,2)","v":261028.02},null,{"$f":"ROUND((P6+VLOOKUP(ROUND((P6-INDEX($V$2:$V$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,2,TRUE)*(ROUNDDOWN((ROUND((P6-INDEX($V$2:$V$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))),2)/Q6),-1)-VLOOKUP(ROUND((P6-INDEX($V$2:$V$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUND((P6-INDEX($V$2:$V$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P6,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,3,TRUE)-G6-F6)/0.91,2)","v":261028.02}]
["00048","SALAIER 6","SALMA","Assistante de direction",36104.400000000001,7500,7500,36104.400000000001,3249.4,47855,9355,1500,7855,40000,5000,45000,1,43952.75,null,null,null,null,null,null,{"$f":"VLOOKUP(J7,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((J7/Q7),-1)-VLOOKUP(J7,$U$2:$W$5,1,TRUE))+VLOOKUP(J7,$U$2:$W$5,3,TRUE)","v":9355},{"$f":"MATCH(P7,$U$2:$U$5-$W$2:$W$5,1)","v":3},{"$f":"ROUND((P7-INDEX($V$2:$V$5,Z7)*INDEX($U$2:$U$5,Z7)+INDEX($W$2:$W$5,Z7))/(1-INDEX($V$2:$V$5,Z7)),2)","v":57142.86},{"$f":"ROUND((P7+VLOOKUP(AA7,$U$2:$W$5,2,TRUE)*(ROUNDDOWN((AA7/Q7),-1)-VLOOKUP(AA7,$U$2:$W$5,1,TRUE))+VLOOKUP(AA7,$U$2:$W$5,3,TRUE)-G7-F7)/0.91,2)","v":46309.89},null,{"$f":"ROUND((P7+VLOOKUP(ROUND((P7-INDEX($V$2:$V$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,2,TRUE)*(ROUNDDOWN((ROUND((P7-INDEX($V$2:$V$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))),2)/Q7),-1)-VLOOKUP(ROUND((P7-INDEX($V$2:$V$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUND((P7-INDEX($V$2:$V$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))*INDEX($U$2:$U$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))+INDEX($W$2:$W$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1)))/(1-INDEX($V$2:$V$5,MATCH(P7,$U$2:$U$5-$W$2:$W$5,1))),2),$U$2:$W$5,3,TRUE)-G7-F7)/0.91,2)","v":46309.89}]
[]
[null,null,null,"SUPPORT MERCHANDISER",{"$f":"R2","v":47249.45},6000,6000,{"$f":"E9","v":47249.45},{"$f":"ROUND(H9*0.09,2)","v":4252.45},{"$f":"+H9-I9+F9+G9","v":54997},{"$f":"VLOOKUP(ROUNDDOWN(J9/Q9,-1),$U$2:$W$5,2,TRUE)*(ROUNDDOWN(J9/Q9,-1)-VLOOKUP(ROUNDDOWN(J9/Q9,-1),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUNDDOWN(J9/Q9,-1),$U$2:$W$5,3,TRUE)","v":11497},{"$f":"IF(ROUNDDOWN(J9/Q9,-1)*40%<1000,1000,IF(ROUNDDOWN(J9/Q9,-1)*40%>1500,1500, ROUNDDOWN(J9/Q9,-1)*40%))","v":1500},{"$f":"K9-L9","v":9997},{"$f":"H9-I9-K9+F9+G9+L9","v":45000},"Contrôle du résultat macro",null,1]
[null,null,null,"Responsable Marketing",{"$f":"R3","v":193570.33},23078,23078,{"$f":"E10","v":193570.33},17421.330000000002,222305,{"$f":"VLOOKUP(ROUNDDOWN(J10/Q10,-1),$U$2:$W$5,2,TRUE)*(ROUNDDOWN(J10/Q10,-1)-VLOOKUP(ROUNDDOWN(J10/Q10,-1),$U$2:$W$5,1,TRUE))+VLOOKUP(ROUNDDOWN(J10/Q10,-1),$U$2:$W$5,3,TRUE)","v":66805},{"$f":"IF(ROUNDDOWN(J10/Q10,-1)*40%<1000,1000,IF(ROUNDDOWN(J10/Q10,-1)*40%>1500,1500, ROUNDDOWN(J10/Q10,-1)*40%))","v":1500},65305,157000,null,null,1]
[null,null,null,"Assistante SAV",{"$f":"R4","v":46465.93},6000,6000,46465.93,4181.93,54284,11284,1500,9784,44500,null,null,1]
[null,null,null,"Magasinier",{"$f":"R5","v":44108.79},6000,6000,44108.79,3969.79,52139,10639,1500,9139,43000,null,null,1]
[null,null,null,"Coordinateur De Projet",{"$f":"R6","v":258491.21},30000,30000,258491.21,23264.21,295227,92327,1500,90827,204400,null,null,1]
[null,null,null,"Assistante de direction",{"$f":"R7","v":43952.75},7500,7500,43952.75,3955.75,54997,11497,1500,9997,45000,null,null,1]
[]
[]
[]
[]
[null,null,null,null,"Montant n’excédant pas 10 000.00 le taux est de 0%"]
[null,null,null,null,"Montant de 10 000.01 à 30 000.00 le taux est de 20%"]
[null,null,null,null,"Montant de 30 000.01 à 120 000.00 le taux est de 30%"]
[null,null,null,null,"Montant supérieur a 120 000.00 le taux est de 35%"]
[]
[null,null,null,null,"Exemple pour une base imposable de 38 000.00 le calcule sera de"]
[null,null,null,null,"Fraction Différence Taux IRG"]
[null,null,null,null,"De 0 à 10 000.00 10 000.00 0% 0 Da"]
[null,null,null,null,"De 10 000.01 à 30 000.00 30 000.00 20% 4 000.00 Da"]
[null,null,null,null,"De 30 000.01 à 38 000.00 8 000.00 30% 2 400.00 Da"]
[null,null,null,null,"Total cumule 6 400.00 Da"]
[null,null,null,null,"Abattement 1 500.00 Da"]
[null,null,null,null,"Retenu IRG 4 900.00 Da"]
[null,null,null,null,"L’abattement se calcule comme suite SI(Base imposable*40%<1000;1000;SI(Base imposable *40%>1500;1500; Base imposable *40%))"]

{"sheet":"(38) original","index":1,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["MATRICULE","NOM","PRENOM","FONCTION","SALAIRE DE BASE","PANIER","TRANSPORT","SALAIRE DE POSTE","RETENUE SS","SALAIRE IMPOSABLE","IRG","SALAIRE NET","augmentation","nouveau salaire","%IRG"]
["00007","SALAIER 1","NABIL","SUPPORT MERCHANDISER",39401.1,6000,6000,{"$f":"+E2","v":39401.1},{"$f":"+H2*0.09","v":3546.0989999999997},{"$f":"+H2-I2+F2+G2","v":47855.000999999997},{"$f":"(IF(ROUNDDOWN((J2/O2)/10,0)*10>15000,(IF(ROUNDDOWN((J2/O2)/10,0)*10<22500,(ROUNDDOWN((J2/O2)/10,0)*10-15000)*20%,IF(ROUNDDOWN((J2/O2)/10,0)*10<28750,(((ROUNDDOWN((J2/O2)/10,0)*10-22500)*12%)+1500),IF(ROUNDDOWN((J2/O2)/10,0)*10<30000,(((ROUNDDOWN((J2/O2)/10,0)*10-28750)*20%)+22500),IF(ROUNDDOWN((J2/O2)/10,0)*10<120000,(((ROUNDDOWN((J2/O2)/10,0)*10-30000)*30%)+2500),(((ROUNDDOWN((J2/O2)/10,0)*10-120000)*35%)+29500)))))),0))*O2","v":7855},{"$f":"H2-I2-K2+F2+G2","v":40000.000999999997},5000,45000.000999999997,1]
["00033","SALAIER 2","MOHAMED AMINE","Responsable Marketing",181735.71,23078,23078,181735.71,16356.213899999999,211535.49609999999,61535.5,149999.99609999999,7000,156999.99609999999,1]
["00035","SALAIER 3","NESRINE SOUHILA","Assistante SAV",39401.1,6000,6000,39401.1,3546.0989999999997,47855.000999999997,7855,40000.000999999997,4500,44500.000999999997,1]
["00037","SALAIER 4","ADEL AMAR","Magasinier",39401.1,6000,6000,39401.1,3546.0989999999997,47855.000999999997,7855,40000.000999999997,3000,43000.000999999997,1]
["00041","SALAIER 5","AHMED","Coordinateur De Projet",251052.2,30000,30000,251052.2,22594.698,288457.50199999998,88457.5,200000.00200000001,4400,204400.00200000001,1]
["00048","SALAIER 6","SALMA","Assistante de direction",36104.400000000001,7500,7500,36104.400000000001,3249.3960000000002,47855.004000000001,7855,40000.004000000001,5000,45000.004000000001,1]