{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Grille","Param"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":12,"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":"Grille","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[null,{"$f":"\"Grille de Rémunération Brute au \"&VAL_VRS","v":"Grille de Rémunération Brute au 1er janvier 2021"}]
[null,{"$f":"\"* Sur base Salaire National Brut de \"&VAL_SNB& \"€.\"","v":"* Sur base Salaire National Brut de 507,25€."}]
[]
[null,null,"A",null,"B"]
[null,"Niveau de Rémunération (NR)",135,null,135]
[null,"Echelon d'Ancienneté",8,null,8]
[null,"Temps de travail","35h",null,"35h"]
[null,"Majoration résidentielle",0.25,null,0.25]
[]
[null,"Salaire Mensuel brut",{"$f":"VAL_SNB*VLOOKUP(C6,TB_NR,2,FALSE)*(1+VLOOKUP(C7,TB_ECH,2,FALSE)/100)*VLOOKUP(C8,TB_TDT,2,FALSE)*(1+C9)/100","v":2751.5395812499996},null,{"$f":"VAL_SNB*VLOOKUP(E6,TB_NR,2,FALSE)*(1+VLOOKUP(E7,TB_ECH,2,FALSE)/100)*VLOOKUP(E8,TB_TDT,2,FALSE)*(1+E9)/100","v":2751.5395812499996}]
[null,"Aide Reduction Temps Travail",{"$f":"IF(VLOOKUP(C6,TB_NR,2,FALSE)*(1+VLOOKUP(C7,TB_ECH,2,FALSE)/100)<VLOOKUP(100,TB_NR,2,FALSE)*(1+VLOOKUP(4,TB_ECH,2,FALSE)/100),VAL_SNB*VLOOKUP(100,TB_NR,2,FALSE)*(1+VLOOKUP(4,TB_ECH,2,FALSE)/100)*VLOOKUP(C8,TB_TDT,3,FALSE)*(1+C9)/100,VAL_SNB*VLOOKUP(C6,TB_NR,2,FALSE)*(1+VLOOKUP(C7,TB_ECH,2,FALSE)/100)*VLOOKUP(C8,TB_TDT,3,FALSE)*(1+C9)/100)","v":0},null,{"$f":"IF(VLOOKUP(E6,TB_NR,2,FALSE)*(1+VLOOKUP(E7,TB_ECH,2,FALSE)/100)<VLOOKUP(100,TB_NR,2,FALSE)*(1+VLOOKUP(4,TB_ECH,2,FALSE)/100),VAL_SNB*VLOOKUP(100,TB_NR,2,FALSE)*(1+VLOOKUP(4,TB_ECH,2,FALSE)/100)*VLOOKUP(E8,TB_TDT,3,FALSE)*(1+E9)/100,VAL_SNB*VLOOKUP(E6,TB_NR,2,FALSE)*(1+VLOOKUP(E7,TB_ECH,2,FALSE)/100)*VLOOKUP(E8,TB_TDT,3,FALSE)*(1+E9)/100)","v":0}]
[null,"Salaire Mensuel brut + ARTT",{"$f":"C11+C12","v":2751.5395812499996},null,{"$f":"E11+E12","v":2751.5395812499996}]
[null,"Salaire Annuel brut + ARTT",{"$f":"C13*13","v":35770.014556249997},null,{"$f":"E13*13","v":35770.014556249997}]
[]
[null,null,null,"Ecart [B-A]"]
[null,"Ecart Salaire Mensuel",null,{"$f":"IF(VAL_ARTT,E13-C13,E11-C11)","v":0}]
[null,"Ecart Salaire Annuel",null,{"$f":"D17*13","v":0}]
[null,"… avec prise en compte ARTT"]
[]
[]
[]
[null,"https://www.fnem-fo.org/"]

{"sheet":"Param","index":1,"n_rows":74,"n_cols":22,"rows_kept":74,"cut":false,"hidden":true,"merged":[[18,20,18,21],[19,20,19,21],[11,14,11,15],[11,17,11,18],[11,20,11,21],[18,14,18,15],[19,14,19,15],[17,17,17,18],[18,17,18,18],[19,17,19,18],[14,17,14,18],[16,17,16,18],[14,20,14,21],[17,14,17,15],[17,20,17,21],[16,20,16,21],[10,13,10,15],[10,16,10,18],[10,19,10,21],[12,17,12,18],[13,17,13,18],[12,20,12,21],[13,20,13,21],[12,14,12,15],[13,14,13,15],[14,14,14,15],[16,14,16,15],[15,14,15,15],[15,17,15,18],[15,20,15,21]]}
["Paramètres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"Correspondance Plage M3E / GF / Collège"]
["SNB","Salaire National de Base",507.25]
["Version",null,"1er janvier 2021",null,null,null,null,null,null,null,null,null,"Echelon",4,5,6,7,8,9,10,11,12]
["IndARTT",null,true,null,null,null,null,null,null,null,null,null,"Ancienneté",4,6,9.5,13,17,"21","25","30","34"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Majoration",0.09,0.12,0.15,0.18,0.22,0.26,0.3,0.315,0.33]
["NR","Indice",null,"Echelon","Majoration",null,"Temps de travail","Coef","ARTT",null,"MajorationResidientielle"]
[30,226,null,4,9,null,"35h",1,0,null,0.25,null,"Plage M3E","I","H","G","F","E","D","C","B","A"]
[35,230.4,null,5,12,null,"32h Collectif",{"$f":"32/35","v":0.91428571428571426},{"$f":"2/35","v":5.7142857142857141E-2},null,0.245,null,"GF","2 - 4","3 - 7","7 - 9","9 - 11","10 - 12","11 - 13","13 - 15","15 - 17","17 - 19"]
[40,234.9,null,6,15,null,"32h Individuel",{"$f":"32/35","v":0.91428571428571426},{"$f":"1/35","v":2.8571428571428571E-2},null,0.24]
[45,239.6,null,7,18,null,"28h",{"$f":"28/35","v":0.8},{"$f":"1.5/35","v":4.2857142857142858E-2},null,null,null,"Collège","Exécution",null,null,"Maîtrise",null,null,"Cadre"]
[50,244.3,null,8,22,null,null,null,null,null,null,null,null,"GF","NR",null,"GF","NR",null,"GF","NR"]
[55,249,null,9,26,null,null,null,null,null,null,null,null,3,"30 - 160",null,7,"60 - 240",null,12,"160 - 370"]
[60,253.8,null,10,30,null,null,null,null,null,null,null,null,4,"40 - 160",null,8,"80 - 240",null,13,"180 - 370"]
[65,259,null,11,31.5,null,null,null,null,null,null,null,null,5,"50 - 160",null,9,"100 - 240",null,14,"200 - 370"]
[70,264.39999999999998,null,12,33,null,null,null,null,null,null,null,null,6,"60 - 160",null,10,"120 - 240",null,15,"220 - 370"]
[75,269.39999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"140 - 240",null,16,"240 - 370"]
[80,274.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"260 - 370"]
[85,280.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"280 - 370"]
[90,286.89999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"300 - 370"]
[95,293.2]
[100,299.8]
[105,306.7]
[110,313.89999999999998]
[115,321.7]
[120,330.6]
[125,338.9]
[130,347.1]
[135,355.7]
[140,364.5]
[145,373.6]
[150,382.8]
[155,392.1]
[160,403]
[165,412.7]
[170,422]
[175,433.3]
[180,444]
[185,454.9]
[190,466.1]
[195,477.6]
[200,489.3]
[205,501.5]
[210,513.9]
[215,526.5]
[220,539.4]
[225,552.9]
[230,566.5]
[235,580.6]
[240,598.5]
[245,613.20000000000005]
[250,628.29999999999995]
[255,643.9]
[260,659.8]
[265,676.2]
[270,692.9]
[275,709.9]
[280,727.5]
[285,744]
[290,760.7]
[295,777.6]
[300,794.9]
[305,812.6]
[310,830.7]
[315,849.3]
[320,868.5]
[325,887.4]
[330,906.7]
[340,929]
[350,949.6]
[355,971.4]
[360,993.8]
[365,1016.7]
[370,1040]