{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Accueil","bareme","saisi","salaire","Salaire brut - net"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"comments":1,"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":"Accueil","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[18,2,18,9],[21,5,21,6],[2,2,2,9],[5,5,5,6],[6,5,6,6],[11,3,11,8],[14,3,14,8],[8,2,9,9]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"Nous somme le :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2018-11-28T23:28:06.780"}]
[]
[null,null,"La feuille salaire brut - net est autonome des autres feuilles ! "]
[]
[]
[null,null,null,"Net - brut"]

{"sheet":"bareme","index":1,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,1,4,3],[17,1,17,3],[20,1,20,3],[21,1,21,3],[23,1,23,3],[16,1,16,3],[24,1,24,3],[22,1,22,3],[28,1,28,3],[35,1,35,3],[27,1,27,3],[34,1,34,3],[30,1,30,3],[31,1,31,3]]}
[]
[]
[]
[]
[null," Barème d'IR  Mensuel"]
[null,"Revenus","Taux","∑ à déduire"]
[null,0,0,0]
[null,2501,0.1,250]
[null,4168.68,0.2,666.67]
[null,5000.01,0.3,1166.67]
[null,6666.68,0.34,1433.33]
[null,15000.01,0.38,2033.33]
[]
[]
[]
[]
[null,"Déduction charge familiale"]
[null,30]
[]
[]
[null,"Frais professionnel"]
[null,0.2]
[]
[null,"Seuil mensuel"]
[null,2500]
[]
[]
[null,"Taux CNSS"]
[null,4.48E-2]
[]
[null,"Plafond CNSS"]
[null,6000]
[]
[]
[null,"Taux AMO"]
[null,2.2599999999999999E-2]

{"sheet":"saisi","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,2,3],[13,2,14,3],[16,3,16,4]]}
[]
[]
[]
[]
[]
[null,null,"Salaire brut",5555,null,null,null,4000]
[]
[null,null,"Nombre de déduction",2]
[]
[null,null,"Salaire net",null,null,null,null,0]

{"sheet":"salaire","index":3,"n_rows":16,"n_cols":256,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,7,15,8],[15,3,15,4],[5,3,5,4],[7,3,7,4],[0,243,0,254],[9,7,9,8],[11,7,11,8],[2,8,2,9],[9,3,9,4],[11,3,11,4],[3,3,3,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+H4","v":4000},null,{"$f":"+IJ2+IK2","v":4000},{"$f":"+H7","v":0},{"$f":"+IJ2*bareme!B22","v":800},{"$f":"IF(IN2<bareme!B25,IN2,bareme!B25)","v":800},{"$f":"IF(IJ2>bareme!B32,bareme!B32*bareme!B29,IJ2 *bareme!B29)","v":179.2},{"$f":"IF(IT2<=0,0,IT2)","v":43.04000000000002},{"$f":"IJ2*bareme!B36","v":90.399999999999991},{"$f":"+IJ2-IO2-IP2-IR2","v":2930.4},{"$f":"IF(IS2>bareme!B12,IS2*bareme!C12-(bareme!D12+IM2*bareme!B18),IF(IS2>bareme!B11,IS2*bareme!C11-(bareme!D11+IM2*bareme!B18),IF(IS2>bareme!B10,IS2*bareme!C10-(bareme!D10+IM2*bareme!B18),IF(IS2>bareme!B9,IS2*bareme!C9-(bareme!D9+IM2*bareme!B18),IF(IS2>bareme!B8,IS2*bareme!C8-(bareme!D8+IM2*bareme!B18),IF(IS2<bareme!B6,0))))))","v":43.04000000000002},{"$f":"+IL2-(IP2+IR2+IQ2)","v":3687.36},{"$f":"+IQ2+IR2+IP2","v":312.64}]
[]
[null,null,"Salaire brut",{"$f":"+H4","v":4000},null,null,null,{"$f":"+saisi!H6","v":4000}]
[null,null,null,null,null,null,null,{"$f":"+saisi!H8","v":0}]
[null,null,"Nombre de déduction",{"$f":"+IM2","v":0}]
[null,null,null,null,null,null,null,{"$f":"+saisi!H10","v":0}]
[null,null,"C.N.S.S",{"$f":"+IP2","v":179.2}]
[]
[null,null,"A.M.O",{"$f":"+IR2","v":90.399999999999991},null,null,null,"Total retenues"]
[]
[null,null,"I . R",{"$f":"+IQ2","v":43.04000000000002},null,null,null,{"$f":"+D8+D10+D12","v":312.64}]
[]
[]
[]
[null,null,"Salaire net",{"$f":"+IU2","v":3687.36}]

{"sheet":"Salaire brut - net","index":4,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,3,0,5],[9,3,9,4],[15,0,15,1],[32,2,32,7],[38,2,38,7],[12,0,13,1],[29,2,29,7]]}
[null,null,null,"Barème de l'IGR mensuel"]
[null,null,null,0,0,0]
[null,null,null,2501,0.1,250]
[null,null,null,4168.68,0.2,666.66666666666663]
[null,null,null,5000.01,0.3,1166.6666666666667]
[null,null,null,6666.68,0.34,1433.3333333333333]
[null,null,null,15000.01,0.38,2033.3333333333333]
[]
[]
[null,null,null,"Ancienneté "]
[null,null,null,0,0]
[null,null,null,{"$f":"365*2","v":730},0.05]
["Simulateur salaire du brut au net ",null,null,{"$f":"365*5","v":1825},0.1]
[null,null,null,{"$f":"365*12","v":4380},0.15]
[null,null,null," ",0.2]
["Zone en vert à remplir manuellement",null,null,{"$f":"365*25","v":9125},0.25]
[]
["Date de paiement","2015-12-31"]
["Date embauche","2015-02-01"]
["Ancienneté (en jours)",{"$f":"B18-B19","v":333}]
["Taux d'ancienneté",{"$f":"VLOOKUP((B18-B19),D11:E16,2)","v":0}]
["Salaire de base",5000]
["Prime exonerée sous CNSS et IR A selon la loi en vigueur ",0]
["Prime exonerée sous CNSS et IR B selon la loi en vigueur ",0]
["Prime d'anciennenté",{"$f":"B22*B21","v":0}]
["Salaire brut imposable",{"$f":"B22+B25","v":5000}]
["Frais professionnel",{"$f":"MIN(B26*20%,2500)","v":1000}]
["CNSS",{"$f":"MIN(B26*4.48%,268.8)","v":224.00000000000003}]
["AMO",{"$f":"B26*2.26%","v":112.99999999999999}]
["Nombre de jours déclaré en CNSS",26]
["Salaire net imposable",{"$f":"IF(B30<=0,0,(B26-SUM(B27:B29))*26/B30)","v":3663}]
["IR brut",{"$f":"((B31*VLOOKUP(B31,D2:F7,2))-VLOOKUP(B31,D2:F7,3))*(B30/26)","v":116.30000000000001}]
["Déductions",0]
["IR net",{"$f":"IF(B32-MIN(B33*30,180)<=0,0,(B32-MIN(B33*30,180)))","v":116.30000000000001}]
["Salaire net théorique",{"$f":"SUM(B22:B25)-SUM(B28:B29)-B34","v":4546.7}]
["Part salarial : CNSS + AMO ",{"$f":"SUM(B28:B29)","v":337}]
["Part patronal : CNSS + AMO ",{"$f":"MIN(B26,6000)*8.98%+B26*8%+B26*4.11%","v":1054.5}]
["coût global CNSS + AMO + IR ",{"$f":"B34+SUM(B36:B37)","v":1507.8}]
["Coût global à payer (salaire & charges sociales -fiscales)",{"$f":"B35+B38","v":6054.5}]