{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Salariés","1- écart rémunération","2- écart augmentations","2 - message","3- AI maternité","4- 10 + hautes rému","index","barèmes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":2,"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":"Salariés","index":0,"n_rows":149,"n_cols":23,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
[]
[null,"x","Remplir les données de votre entreprise",null,null,"Les données ci-dessous recenssent le personnel au 31/12/2019, non démissionnaire et hors procédure de départ. Le directeur général en a été retiré. "]
[null,"x","Ne pas modifier: valeur calculée automatiquement"]
[]
[null,"Date du jour",null,"2019-06-30"]
[]
[]
[null,"N°","PRENOM","NOM","SEXE","DATE NAISSANCE","DATE EMBAUCHE","CATEGORIE","SERVICE","EMPLOI","CONTRAT","DUREE DU TRAVAIL","HORAIRES","PROMOTIONS","HEURES FORMATION (EXTERNE UNIQUEMENT) N-1","BRUT ANNUEL (hors hsup/anc) /12","AUGMENTATION AU COURS DES 12 DERNIERS MOIS","NOMBRE D'ACCIDENTS DU TRAVAIL/MP","Age","Ancienneté","Tranche âge","Tranche ancienneté","Tranches rémunération"]
[null,1000,"LUCIENNE","DUBOS","F","2004-04-04","2029-08-10","3. Cadre","Qualité","Responsable Qualité","CDI","TC","FORFAIT","0",77,40477.995000000003,2.7E-2,0,{"$f":"INT((date_jour-$F9)/365.25)","v":15},{"$f":"INT((date_jour-$G9)/365.25)","v":-11},{"$f":"tranche_age(S9)","v":"1. moins de 30 ans"},{"$f":"IF(ISNUMBER(T9),IF(T9=0,\"0 : - d'1 an\",INT(T9/5)+1&\" : \"&IF(INT(T9/5)=0,1,INT(T9/5)*5)&\"-\"&INT(T9/5)*5+4),\"\")","v":"-2 : -15--11"},{"$f":"IF(P9=0,\" \",(IF(P9<20000,\"<20000\",IF(P9<=30000,\"1:20000-30000\",IF(P9<=45000,\"2:30000-45000\",IF(P9<=60000,\"3:45000-60000\",\"4:<60000\"))))))","v":"2:30000-45000"}]
[null,1001,"ANNETTE","HENRION","F","1972-07-03","2030-04-16","2. Etam","R&D","Technicien essais","CDI","TC","JOURNEE","0",40,21306.05,0.02,0,46,-11,{"$f":"tranche_age(S10)","v":"3. 40 à 49 ans"},"-2 : -15--11","1:20000-30000"]
[null,1002,"MATHILDE","ROSSET","F","1985-08-09","2008-03-24","2. Etam","Marketing","Assistante Commerciale","CDI","TC","JOURNEE","0",0,32793.360000000001,0,0,33,11,{"$f":"tranche_age(S11)","v":"2. 30 à 49 ans"},"3 : 10-14","2:30000-45000"]
[null,1003,"MARIE-LOUISE","BELAIR","H","1957-10-22","1992-11-13","3. Cadre","Qualité","Responsable Qualité","CDI","TC","FORFAIT","0",7,62779.839599999992,0.02,0,61,26,{"$f":"tranche_age(S12)","v":"4. 50 ans et plus"},"6 : 25-29","4:<60000"]
[null,1004,"JEANNINE","SEUX","F","1957-02-17","1989-09-18","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",10.5,24129.42,0.01,0,62,29,{"$f":"tranche_age(S13)","v":"4. 50 ans et plus"},"6 : 25-29","1:20000-30000"]
[null,1005,"CASSANDRA","COUDERC","H","1964-06-18","1996-09-24","2. Etam","Fabrication","Technicien Fabrication","CDI","TC","JOURNEE","0",0,26645.22,0,0,55,22,{"$f":"tranche_age(S14)","v":"4. 50 ans et plus"},"5 : 20-24","1:20000-30000"]
[null,1006,"BERNADETTE","BONHOURE","H","1959-06-23","1992-06-16","3. Cadre","R&D","Ingénieur Méthodes","CDI","TC","FORFAIT","0",24.5,36300.708000000006,0.02,0,60,27,{"$f":"tranche_age(S15)","v":"4. 50 ans et plus"},"6 : 25-29","2:30000-45000"]
[null,1007,"HOURIA","GARRET","F","1958-05-25","1992-05-06","1. Ouvrier","Fabrication","Contrôleur","CDI","TC","EQUIPE","1",0,24934.739999999998,2.2499999999999999E-2,0,61,27,{"$f":"tranche_age(S16)","v":"4. 50 ans et plus"},"6 : 25-29","1:20000-30000"]
[null,1008,"PIERRETTE","METAIS","F","1980-04-14","2012-06-09","3. Cadre","Qualité","Chargé d'Affaires","CDI","TC","FORFAIT","0",28,37174.842000000004,2.2499999999999999E-2,0,39,7,{"$f":"tranche_age(S17)","v":"2. 30 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1009,"MOUNA","GITTON","F","1960-12-01","2011-05-01","1. Ouvrier","Ordo & logistique","Agent de Fabrication","CDI","TC","EQUIPE","0",54,23875.129999999997,1.7500000000000002E-2,0,58,8,{"$f":"tranche_age(S18)","v":"4. 50 ans et plus"},"2 : 5-9","1:20000-30000"]
[null,1010,"AMÉLIE","ADOLPHE","F","1962-06-22","1999-11-28","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","1",10.5,19086.689999999999,0.04,0,57,19,{"$f":"tranche_age(S19)","v":"4. 50 ans et plus"},"4 : 15-19","<20000"]
[null,1011,"VIVIEN","PIVETEAU","H","1988-03-27","2013-05-23","2. Etam","Fabrication","Technicien de Fabrication","CDI","TC","EQUIPE","0",45.5,30426.639999999999,4.4999999999999998E-2,0,31,6,{"$f":"tranche_age(S20)","v":"2. 30 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1012,"LUCIA","LEROUX","F","1968-06-08","2015-05-11","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,21201.48,1.4999999999999999E-2,0,51,4,{"$f":"tranche_age(S21)","v":"4. 50 ans et plus"},"1 : 1-4","1:20000-30000"]
[null,1013,"SAMANTHA","MICHON","F","1972-08-30","1994-06-25","2. Etam","Qualité","Contrôleur","CDI","TC","EQUIPE","0",0,27880.3,2.2499999999999999E-2,0,46,25,{"$f":"tranche_age(S22)","v":"3. 40 à 49 ans"},"6 : 25-29","1:20000-30000"]
[null,1014,"JONATHAN","ANCEL","H","1974-03-22","2002-08-06","3. Cadre","R&D","Ingénieur Dévelop.","CDI","TC","FORFAIT","0",60,38384.370000000003,0.03,0,45,16,{"$f":"tranche_age(S23)","v":"3. 40 à 49 ans"},"4 : 15-19","2:30000-45000"]
[null,1015,"CHARLIE","SERRE","F","1981-03-20","2020-02-12","2. Etam","Administration","Assistante Admin et Production","CDI","TC","JOURNEE","0",14,23290.149999999998,1.7500000000000002E-2,0,38,-1,{"$f":"tranche_age(S24)","v":"2. 30 à 49 ans"},"0 : -5--1","1:20000-30000"]
[null,1016,"MAYLANE","DESMET","F","1996-11-26","2035-05-02","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,19793.259999999998,3.2500000000000001E-2,0,22,-16,{"$f":"tranche_age(S25)","v":"1. moins de 30 ans"},"-3 : -20--16","<20000"]
[null,1017,"GASPARD","COUTURE","H","1988-09-28","2011-01-09","2. Etam","Fabrication","Technicien de Fabrication","CDI","TC","JOURNEE","1",10.5,32245.429999999997,0.01,0,30,8,{"$f":"tranche_age(S26)","v":"2. 30 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1018,"MARIE-HÉLÈNE","MEIGNAN","F","1999-07-29","2025-11-07","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,24669.94,4.4999999999999998E-2,0,19,-7,{"$f":"tranche_age(S27)","v":"1. moins de 30 ans"},"-1 : -10--6","1:20000-30000"]
[null,1019,"MARTIAL","FOUCHARD","H","1991-05-19","2034-11-29","3. Cadre","R&D","Ingénieur Dévelop.","CDI","TC","FORFAIT","0",14,55521.631999999998,1.4999999999999999E-2,0,28,-16,{"$f":"tranche_age(S28)","v":"1. moins de 30 ans"},"-3 : -20--16","3:45000-60000"]
[null,1020,"MÉLANIE","FABRY","F","1968-03-12","2022-08-06","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,22659.21,1.4999999999999999E-2,0,51,-4,{"$f":"tranche_age(S29)","v":"4. 50 ans et plus"},"0 : -5--1","1:20000-30000"]
[null,1021,"YVETTE","GUIHENEUF","F","1981-04-04","2004-11-10","3. Cadre","Réglementaire/Clinique","Chef Comptable","CDI","TC","FORFAIT","0",7,37498.008000000002,2.5000000000000001E-2,0,38,14,{"$f":"tranche_age(S30)","v":"2. 30 à 49 ans"},"3 : 10-14","2:30000-45000"]
[null,1022,"ETIENNE","AUBRY","H","1986-02-02","2018-12-30","2. Etam","Ordo & logistique","Magasinier","CDI","TC","JOURNEE","0",0,19277.149999999998,0.02,0,33,0,{"$f":"tranche_age(S31)","v":"2. 30 à 49 ans"},"0 : - d'1 an","<20000"]
[null,1023,"ALINE","VIDAL","F","1983-10-29","2003-01-17","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,18834.259999999998,4.4999999999999998E-2,0,35,16,{"$f":"tranche_age(S32)","v":"2. 30 à 49 ans"},"4 : 15-19","<20000"]
[null,1024,"AYOUB","CESBRON","H","2003-04-21","2031-11-01","2. Etam","Fabrication","Technicien R&D","CDI","TC","JOURNEE","0",10.5,19139.66,1.4999999999999999E-2,0,16,-13,{"$f":"tranche_age(S33)","v":"1. moins de 30 ans"},"-2 : -15--11","<20000"]
[null,1025,"ANTONIN","ANCEL","H","1968-01-09","2004-06-03","3. Cadre","Marketing","Commercial","CDI","TC","FORFAIT","0",0,45827.256000000001,0.05,0,51,15,{"$f":"tranche_age(S34)","v":"4. 50 ans et plus"},"4 : 15-19","3:45000-60000"]
[null,1026,"NOËLLE","JOB","F","1964-04-28","1998-12-07","3. Cadre","Qualité","Ingénieur Dévelop.","CDI","TC","FORFAIT","0",21,38622.200000000004,0.02,0,55,20,{"$f":"tranche_age(S35)","v":"4. 50 ans et plus"},"5 : 20-24","2:30000-45000"]
[null,1027,"PIERRETTE","MAUGER","F","1958-02-14","1989-04-29","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,20681.739999999998,1.4999999999999999E-2,0,61,30,{"$f":"tranche_age(S36)","v":"4. 50 ans et plus"},"7 : 30-34","1:20000-30000"]
[null,1028,"INGRID","CHUPIN","F","1982-01-08","2007-05-11","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",10.5,24349.609999999997,1.4999999999999999E-2,0,37,12,{"$f":"tranche_age(S37)","v":"2. 30 à 49 ans"},"3 : 10-14","1:20000-30000"]
[null,1029,"GABRIEL","GODART","H","1978-02-13","2025-02-11","3. Cadre","Administration","Directeur de Site","CDI","TC","FORFAIT","0",7,87517.542199999982,0.02,0,41,-6,{"$f":"tranche_age(S38)","v":"3. 40 à 49 ans"},"-1 : -10--6","4:<60000"]
[null,1030,"EMILIE","VIGIER","F","1992-07-15","2021-06-14","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,21024.39,0,0,26,-2,{"$f":"tranche_age(S39)","v":"1. moins de 30 ans"},"0 : -5--1","1:20000-30000"]
[null,1031,"PRISCILLA","PORET","F","1970-01-31","2013-09-25","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",10.5,17995.289999999997,5.0000000000000001E-3,0,49,5,{"$f":"tranche_age(S40)","v":"3. 40 à 49 ans"},"2 : 5-9","<20000"]
[null,1032,"PIERRE","FRANCISCO","H","1969-05-22","1993-12-18","3. Cadre","Qualité","Ingénieur Qualité","CDI","TC","FORFAIT","0",21,38192.016000000003,2.2499999999999999E-2,0,{"$f":"INT((date_jour-$F41)/365.25)","v":50},{"$f":"INT((date_jour-$G41)/365.25)","v":25},{"$f":"tranche_age(S41)","v":"4. 50 ans et plus"},{"$f":"IF(ISNUMBER(T41),IF(T41=0,\"0 : - d'1 an\",INT(T41/5)+1&\" : \"&IF(INT(T41/5)=0,1,INT(T41/5)*5)&\"-\"&INT(T41/5)*5+4),\"\")","v":"6 : 25-29"},{"$f":"IF(P41=0,\" \",(IF(P41<20000,\"<20000\",IF(P41<=30000,\"1:20000-30000\",IF(P41<=45000,\"2:30000-45000\",IF(P41<=60000,\"3:45000-60000\",\"4:<60000\"))))))","v":"2:30000-45000"}]
[null,1033,"CARINE","HUCHET","F","1995-07-02","2024-12-10","3. Cadre","Réglementaire/Clinique","Chargé d'Affaires","CDI","TC","FORFAIT","0",7,36378,0,0,23,-6,{"$f":"tranche_age(S42)","v":"1. moins de 30 ans"},"-1 : -10--6","2:30000-45000"]
[null,1034,"COLEEN","COULAUD","F","1972-05-21","2014-08-02","3. Cadre","Marketing","Ingénieur Dévelop.","CDI","TC","FORFAIT","0",28,33444.46,1.2500000000000001E-2,0,47,4,{"$f":"tranche_age(S43)","v":"3. 40 à 49 ans"},"1 : 1-4","2:30000-45000"]
[null,1035,"GERMAINE","ROUDIER","F","1969-01-11","2009-09-19","2. Etam","Marketing","Assistante Commerciale","CDD","TC","JOURNEE","0",0,24546.219999999998,0,0,50,9,{"$f":"tranche_age(S44)","v":"4. 50 ans et plus"},"2 : 5-9","1:20000-30000"]
[null,1036,"Enzo","MINADOTI","H","1986-09-19","2025-02-10","3. Cadre","Administration","Responsable Ressources humaines","CDI","TC","FORFAIT","0",0,39547.872000000003,6.5000000000000002E-2,0,32,-6,{"$f":"tranche_age(S45)","v":"2. 30 à 49 ans"},"-1 : -10--6","2:30000-45000"]
[null,1037,"BÉATRICE","FAVE","F","1990-03-01","2027-02-26","3. Cadre","Réglementaire/Clinique","Chargé d'Affaires","CDI","TC","FORFAIT","0",42,38895.300000000003,1.4999999999999999E-2,0,29,-8,{"$f":"tranche_age(S46)","v":"1. moins de 30 ans"},"-1 : -10--6","2:30000-45000"]
[null,1038,"CÉDRIC","THEVENIN","H","1972-04-14","2013-11-11","3. Cadre","Fabrication","Responsable Fabrication","CDI","TC","FORFAIT","0",10.5,36611.272000000004,1.7500000000000002E-2,0,47,5,{"$f":"tranche_age(S47)","v":"3. 40 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1039,"KENZA","BLONDIN","F","1992-08-01","2038-05-04","3. Cadre","Ordo & logistique","Responsable logistique","CDI","TC","FORFAIT","0",0,47468.024000000005,0.02,0,26,-19,{"$f":"tranche_age(S48)","v":"1. moins de 30 ans"},"-3 : -20--16","3:45000-60000"]
[null,1040,"SYLVAIN","FREMONT","H","1990-10-22","2020-05-21","3. Cadre","R&D","Ingénieur Dévelop.","CDI","TC","FORFAIT","0",28,36736.866000000009,2.2499999999999999E-2,0,28,-1,{"$f":"tranche_age(S49)","v":"1. moins de 30 ans"},"0 : -5--1","2:30000-45000"]
[null,1041,"EVAN","PONCELET","H","2004-06-19","2038-06-28","3. Cadre","Qualité","Technicien R&D","CDI","TC","FORFAIT","1",21,30860.23,0,0,15,-19,{"$f":"tranche_age(S50)","v":"1. moins de 30 ans"},"-3 : -20--16","2:30000-45000"]
[null,1042,"JACQUES","CAUX","H","1987-03-20","2014-02-08","3. Cadre","Administration","Acheteur Approvisionneur","CDI","TC","FORFAIT","0",0,40174.480000000003,0.02,0,32,5,{"$f":"tranche_age(S51)","v":"2. 30 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1043,"GABRIEL","RIVES","H","1976-05-30","2020-08-09","2. Etam","Administration","Technicien de Maintenance","CDI","TC","JOURNEE","0",0,25152.609999999997,0,0,43,-2,{"$f":"tranche_age(S52)","v":"3. 40 à 49 ans"},"0 : -5--1","1:20000-30000"]
[null,1044,"AMÉLIE","GAILLARD","F","1998-08-20","2035-02-09","2. Etam","Administration","Comptable","CDI","TC","JOURNEE","1",0,33351.11,0.04,0,20,-16,{"$f":"tranche_age(S53)","v":"1. moins de 30 ans"},"-3 : -20--16","2:30000-45000"]
[null,1045,"LOUANNE","CHARBONNIER","F","1975-01-26","2010-08-18","2. Etam","Administration","Comptable","CDI","TC","JOURNEE","0",0,25058.289999999997,0,0,44,8,{"$f":"tranche_age(S54)","v":"3. 40 à 49 ans"},"2 : 5-9","1:20000-30000"]
[null,1046,"TANIA","SALVAT","F","1998-12-11","2022-10-22","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,18259.89,0.01,0,20,-4,{"$f":"tranche_age(S55)","v":"1. moins de 30 ans"},"0 : -5--1","<20000"]
[null,1047,"ODETTE","CHALUMEAU","F","1978-12-03","2000-05-16","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,23032.699999999997,1.4999999999999999E-2,0,40,19,{"$f":"tranche_age(S56)","v":"3. 40 à 49 ans"},"4 : 15-19","1:20000-30000"]
[null,1048,"NOÉ","MATHIEU","H","1989-04-14","2022-10-03","2. Etam","R&D","Technicien Essais","CDI","TC","JOURNEE","0",14,26598.269999999997,0.03,0,30,-4,{"$f":"tranche_age(S57)","v":"2. 30 à 49 ans"},"0 : -5--1","1:20000-30000"]
[null,1049,"SARAH","BEAUDET","F","1979-12-14","2000-09-08","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,19293.519999999997,0,0,39,18,{"$f":"tranche_age(S58)","v":"2. 30 à 49 ans"},"4 : 15-19","<20000"]
[null,1050,"ANNA","GALY","F","1967-05-07","2013-10-26","1. Ouvrier","Qualité","Contrôleur","CDI","TC","EQUIPE","1",0,23982.69,2.2499999999999999E-2,0,52,5,{"$f":"tranche_age(S59)","v":"4. 50 ans et plus"},"2 : 5-9","1:20000-30000"]
[null,1051,"GRÉGOIRE","LIGER","H","1984-08-13","2006-10-22","2. Etam","Administration","Acheteur Approvisionneur","CDI","TC","JOURNEE","0",0,27918,0,0,34,12,{"$f":"tranche_age(S60)","v":"2. 30 à 49 ans"},"3 : 10-14","1:20000-30000"]
[null,1052,"ROSE","LECERF","F","1966-07-16","1985-09-27","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,20565.259999999998,0,0,52,33,{"$f":"tranche_age(S61)","v":"4. 50 ans et plus"},"7 : 30-34","1:20000-30000"]
[null,1053,"AMBRE","DIAS","F","1975-02-11","2016-09-15","1. Ouvrier","Ordo & logistique","Agent de Fabrication","CDI","TC","EQUIPE","0",40,23638.769999999997,0.05,0,44,2,{"$f":"tranche_age(S62)","v":"3. 40 à 49 ans"},"1 : 1-4","1:20000-30000"]
[null,1054,"GISÈLE","FASQUEL","F","1973-11-06","2042-01-15","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,19926.859999999997,0.01,0,45,-23,{"$f":"tranche_age(S63)","v":"3. 40 à 49 ans"},"-4 : -25--21","<20000"]
[null,1055,"BLANCHE","LAPIERRE","F","1975-02-04","2006-10-10","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,20222.949999999997,1.4999999999999999E-2,0,44,12,{"$f":"tranche_age(S64)","v":"3. 40 à 49 ans"},"3 : 10-14","1:20000-30000"]
[null,1056,"ALBERT","FASQUEL","H","1969-06-01","2020-06-22","2. Etam","Qualité","Responsable Qualité","CDI","TC","EQUIPE","0",0,30744.89,0.02,0,50,-1,{"$f":"tranche_age(S65)","v":"4. 50 ans et plus"},"0 : -5--1","2:30000-45000"]
[null,1057,"MARINE","DELOR","F","1975-11-29","2025-07-13","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,18511.099999999999,0,0,43,-7,{"$f":"tranche_age(S66)","v":"3. 40 à 49 ans"},"-1 : -10--6","<20000"]
[null,1058,"LENNY","PLANCHENAULT","H","1962-10-14","2000-08-18","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,18110.34,0,0,56,18,{"$f":"tranche_age(S67)","v":"4. 50 ans et plus"},"4 : 15-19","<20000"]
[null,1059,"VALENTINE","PIGNON","F","1981-08-24","2003-12-06","1. Ouvrier","Qualité","Contrôleur","CDI","TC","EQUIPE","1",0,25530.959999999999,2.2499999999999999E-2,0,37,15,{"$f":"tranche_age(S68)","v":"2. 30 à 49 ans"},"4 : 15-19","1:20000-30000"]
[null,1060,"JIMMY","PION","H","1982-09-12","2010-06-02","3. Cadre","Marketing","Ingénieur Dévelop.","CDI","TC","FORFAIT","0",0,38673.450000000004,0,0,36,9,{"$f":"tranche_age(S69)","v":"2. 30 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1061,"LUCIE","LAFOSSE","F","1967-05-14","2026-06-11","3. Cadre","Administration","Contrôleur de gestion ","CDI","TC","FORFAIT","0",0,36646.160000000003,2.5000000000000001E-2,0,52,-7,{"$f":"tranche_age(S70)","v":"4. 50 ans et plus"},"-1 : -10--6","2:30000-45000"]
[null,1062,"CHRISTIANE","LE BRAS","F","1988-04-03","2019-03-11","1. Ouvrier","Ordo & logistique","Agent de Fabrication","CDI","TC","EQUIPE","0",0,17709.59,2.3E-2,0,31,0,{"$f":"tranche_age(S71)","v":"2. 30 à 49 ans"},"0 : - d'1 an","<20000"]
[null,1063,"BERTHE","NEDELEC","F","1983-01-08","2015-10-20","2. Etam","Ordo & logistique","Assistante Ordonnancement","CDI","TC","JOURNEE","0",0,26243.16,1.4999999999999999E-2,0,36,3,{"$f":"tranche_age(S72)","v":"2. 30 à 49 ans"},"1 : 1-4","1:20000-30000"]
[null,1064,"BRUNO","VIEL","H","1983-04-08","2006-08-15","3. Cadre","Informatique","Responsable Informatique","CDI","TC","FORFAIT","0",0,42181.808000000005,0.02,1,{"$f":"INT((date_jour-$F73)/365.25)","v":36},{"$f":"INT((date_jour-$G73)/365.25)","v":12},{"$f":"tranche_age(S73)","v":"2. 30 à 49 ans"},{"$f":"IF(ISNUMBER(T73),IF(T73=0,\"0 : - d'1 an\",INT(T73/5)+1&\" : \"&IF(INT(T73/5)=0,1,INT(T73/5)*5)&\"-\"&INT(T73/5)*5+4),\"\")","v":"3 : 10-14"},{"$f":"IF(P73=0,\" \",(IF(P73<20000,\"<20000\",IF(P73<=30000,\"1:20000-30000\",IF(P73<=45000,\"2:30000-45000\",IF(P73<=60000,\"3:45000-60000\",\"4:<60000\"))))))","v":"2:30000-45000"}]
[null,1065,"THAÏS","JEANNIN","F","1988-06-30","2028-12-22","2. Etam","Administration","Assistant RH","CDI","TC","JOURNEE","0",30,31056.679999999997,0.02,0,30,-10,{"$f":"tranche_age(S74)","v":"2. 30 à 49 ans"},"-1 : -10--6","2:30000-45000"]
[null,1066,"ANDRÉE","COURTOIS","F","1958-07-09","1994-12-10","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,19208.14,1.4999999999999999E-2,0,60,24,{"$f":"tranche_age(S75)","v":"4. 50 ans et plus"},"5 : 20-24","<20000"]
[null,1067,"GAUTHIER","VILLAUME","H","1999-04-21","2033-02-07","3. Cadre","R&D","Ingénieur Dévelop.","CDI","TC","FORFAIT","0",14,37201.572,3.7499999999999999E-2,0,20,-14,{"$f":"tranche_age(S76)","v":"1. moins de 30 ans"},"-2 : -15--11","2:30000-45000"]
[null,1068,"AHMET","LUBIN","H","1967-05-15","2018-10-01","2. Etam","R&D","Technicien R&D","CDI","TC","JOURNEE","0",40,25685.3,0.03,0,52,0,{"$f":"tranche_age(S77)","v":"4. 50 ans et plus"},"0 : - d'1 an","1:20000-30000"]
[null,1069,"MAURICETTE","CHAUVEAU","F","1958-12-31","1986-02-23","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",10.5,20748.559999999998,0.02,0,60,33,{"$f":"tranche_age(S78)","v":"4. 50 ans et plus"},"7 : 30-34","1:20000-30000"]
[null,1070,"MARIE-PIERRE","DELESTRE","F","1972-06-27","2007-03-23","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,18905.109999999997,0.01,0,47,12,{"$f":"tranche_age(S79)","v":"3. 40 à 49 ans"},"3 : 10-14","<20000"]
[null,1071,"LIAM","BEAUDET","H","1955-04-10","1993-06-22","3. Cadre","Fabrication","Responsable Fabrication","CDI","TC","FORFAIT","0",0,56052,0,0,64,26,{"$f":"tranche_age(S80)","v":"4. 50 ans et plus"},"6 : 25-29","3:45000-60000"]
[null,1072,"LILOU","HERRMANN","F","1982-05-18","2033-03-13","2. Etam","Administration","Aide Comptable","CDI","TC","JOURNEE","0",0,18618.989999999998,1.2500000000000001E-2,0,37,-14,{"$f":"tranche_age(S81)","v":"2. 30 à 49 ans"},"-2 : -15--11","<20000"]
[null,1073,"ARMAND","FORTIER","H","1974-05-21","2029-04-04","3. Cadre","Fabrication","Technicien de Fabrication","CDI","TC","JOURNEE","0",0,36277.29,0.04,0,45,-10,{"$f":"tranche_age(S82)","v":"3. 40 à 49 ans"},"-1 : -10--6","2:30000-45000"]
[null,1074,"YVELINE","FOUQUE","F","1996-01-23","2019-03-25","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,17766.84,0,0,23,0,{"$f":"tranche_age(S83)","v":"1. moins de 30 ans"},"0 : - d'1 an","<20000"]
[null,1075,"JEAN-YVES","MAZE","H","1978-11-10","1999-08-10","3. Cadre","Marketing","Resp. zone export","CDI","TC","FORFAIT","0",0,36788.208000000006,0.06,0,40,19,{"$f":"tranche_age(S84)","v":"3. 40 à 49 ans"},"4 : 15-19","2:30000-45000"]
[null,1076,"GILLES","PEAN","H","1984-12-15","2018-07-15","2. Etam","Administration","Aide Comptable","CDD","TC","JOURNEE","0",0,28181.199999999997,0,0,34,0,{"$f":"tranche_age(S85)","v":"2. 30 à 49 ans"},"0 : - d'1 an","1:20000-30000"]
[null,1077,"MARYLINE","FABRY","F","1998-06-03","2029-08-15","3. Cadre","Marketing","Commercial","CDI","TC","FORFAIT","0",0,31315.19,0.01,0,21,-11,{"$f":"tranche_age(S86)","v":"1. moins de 30 ans"},"-2 : -15--11","2:30000-45000"]
[null,1078,"YANNICK","PUGET","H","1969-04-29","2017-07-09","3. Cadre","Marketing","Commercial","CDI","TC","FORFAIT","0",0,44247.48,1.4999999999999999E-2,0,50,1,{"$f":"tranche_age(S87)","v":"4. 50 ans et plus"},"1 : 1-4","2:30000-45000"]
[null,1079,"MÉLIA","LABROUSSE","F","1969-12-21","2012-11-19","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,17895.169999999998,0.02,0,49,6,{"$f":"tranche_age(S88)","v":"3. 40 à 49 ans"},"2 : 5-9","<20000"]
[null,1080,"CYLIA","ENJALBERT","F","1988-08-06","2032-04-20","3. Cadre","Réglementaire/Clinique","Chargé d'Affaires","CDI","TC","FORFAIT","0",0,29162.92,0.06,0,30,-13,{"$f":"tranche_age(S89)","v":"2. 30 à 49 ans"},"-2 : -15--11","1:20000-30000"]
[null,1081,"MICHEL","ROUSTAN","H","1950-12-08","1989-09-25","2. Etam","Fabrication","Technicien de Fabrication","CDI","TC","EQUIPE","0",0,25218,0,0,68,29,{"$f":"tranche_age(S90)","v":"4. 50 ans et plus"},"6 : 25-29","1:20000-30000"]
[null,1082,"LYLOU","DURANT","F","1973-09-02","1995-07-21","3. Cadre","Marketing","Chef de Produits","CDI","TC","FORFAIT","0",7,45620.928000000007,1.4999999999999999E-2,0,45,23,{"$f":"tranche_age(S91)","v":"3. 40 à 49 ans"},"5 : 20-24","3:45000-60000"]
[null,1083,"MARIE-THÉRÈSE","ZIMMERMANN","F","1976-07-02","2007-12-28","2. Etam","Marketing","Assistante Commerciale","CDI","TC","JOURNEE","0",0,23102.329999999998,0.03,0,42,11,{"$f":"tranche_age(S92)","v":"3. 40 à 49 ans"},"3 : 10-14","1:20000-30000"]
[null,1084,"CHIARA","SIBILLE","F","1972-04-08","2011-08-21","3. Cadre","Réglementaire/Clinique","Chargé d'Affaires","CDI","TC","FORFAIT","0",28,39260.39,0.06,0,47,7,{"$f":"tranche_age(S93)","v":"3. 40 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1085,"YOHANN","PONSOT","H","1979-12-20","2006-07-10","3. Cadre","R&D","Ingénieur Dévelop.","CDI","TC","JOURNEE","0",0,32569.599999999999,2.5000000000000001E-2,0,39,12,{"$f":"tranche_age(S94)","v":"2. 30 à 49 ans"},"3 : 10-14","2:30000-45000"]
[null,1086,"LUCILE","DELACROIX","F","1983-08-07","2035-07-30","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,22509.51,1.4999999999999999E-2,0,35,-17,{"$f":"tranche_age(S95)","v":"2. 30 à 49 ans"},"-3 : -20--16","1:20000-30000"]
[null,1087,"KATIA","DANIELOU","F","1963-07-22","2017-04-01","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",10.5,24321.199999999997,4.4999999999999998E-2,0,55,2,{"$f":"tranche_age(S96)","v":"4. 50 ans et plus"},"1 : 1-4","1:20000-30000"]
[null,1088,"ELLIOT","COTTON","H","1961-11-10","2028-10-26","2. Etam","R&D","Technicien R&D","CDI","TC","JOURNEE","0",0,25184.25,0,0,57,-10,{"$f":"tranche_age(S97)","v":"4. 50 ans et plus"},"-1 : -10--6","1:20000-30000"]
[null,1089,"JULIENNE","GOY","F","1963-07-17","2000-04-05","3. Cadre","Marketing","Chef de Produits","CDI","TC","FORFAIT","0",14,38914.730000000003,1.4999999999999999E-2,0,55,19,{"$f":"tranche_age(S98)","v":"4. 50 ans et plus"},"4 : 15-19","2:30000-45000"]
[null,1090,"CHRISTIANE","FISCHER","F","1987-07-19","2018-06-11","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",14,16878.719999999998,0.05,0,31,1,{"$f":"tranche_age(S99)","v":"2. 30 à 49 ans"},"1 : 1-4","<20000"]
[null,1091,"ESTEBAN","BIANCO","H","1976-08-05","2028-06-13","2. Etam","Ordo & logistique","Magasinier","CDI","TC","JOURNEE","1",0,21308.09,3.2500000000000001E-2,0,42,-9,{"$f":"tranche_age(S100)","v":"3. 40 à 49 ans"},"-1 : -10--6","1:20000-30000"]
[null,1092,"LUDIVINE","PICOT","F","1997-01-30","2031-02-10","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,17960.559999999998,4.4999999999999998E-2,1,22,-12,{"$f":"tranche_age(S101)","v":"1. moins de 30 ans"},"-2 : -15--11","<20000"]
[null,1093,"FRANCIS","ROUZE","H","1973-06-22","2024-02-04","2. Etam","R&D","Technicien R&D","CDI","TP","JOURNEE","0",0,31613.66,1.4999999999999999E-2,0,46,-5,{"$f":"tranche_age(S102)","v":"3. 40 à 49 ans"},"0 : -5--1","2:30000-45000"]
[null,1094,"Christiane","LENOBLE","F","1972-04-01","2017-04-01","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,17052.349999999999,0.02,0,47,2,{"$f":"tranche_age(S103)","v":"3. 40 à 49 ans"},"1 : 1-4","<20000"]
[null,1095,"MARCELLE","GUILLEMARD","F","1970-10-23","2006-11-02","3. Cadre","Qualité","Responsable Qualité","CDI","TC","FORFAIT","0",7,40513.616000000009,2.2499999999999999E-2,0,48,12,{"$f":"tranche_age(S104)","v":"3. 40 à 49 ans"},"3 : 10-14","2:30000-45000"]
[null,1096,"NATHAN","FERRON","H","1964-08-31","2004-06-23","3. Cadre","R&D","Directeur R&D","CDI","TC","FORFAIT","1",7,72526.441600000006,0.104,0,{"$f":"INT((date_jour-$F105)/365.25)","v":54},{"$f":"INT((date_jour-$G105)/365.25)","v":15},{"$f":"tranche_age(S105)","v":"4. 50 ans et plus"},{"$f":"IF(ISNUMBER(T105),IF(T105=0,\"0 : - d'1 an\",INT(T105/5)+1&\" : \"&IF(INT(T105/5)=0,1,INT(T105/5)*5)&\"-\"&INT(T105/5)*5+4),\"\")","v":"4 : 15-19"},{"$f":"IF(P105=0,\" \",(IF(P105<20000,\"<20000\",IF(P105<=30000,\"1:20000-30000\",IF(P105<=45000,\"2:30000-45000\",IF(P105<=60000,\"3:45000-60000\",\"4:<60000\"))))))","v":"4:<60000"}]
[null,1097,"RÉMI","MUSSET","H","1988-03-10","2014-02-19","3. Cadre","R&D","Ingénieur Méthodes","CDI","TC","FORFAIT","0",0,38956.04,1.4999999999999999E-2,0,31,5,{"$f":"tranche_age(S106)","v":"2. 30 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1098,"EMMANUELLE","CHATEAU","F","1988-01-05","2016-12-12","3. Cadre","Réglementaire/Clinique","Responsable Marketing","CDI","TC","FORFAIT","0",7,59225.248,0.01,0,31,2,{"$f":"tranche_age(S107)","v":"2. 30 à 49 ans"},"1 : 1-4","3:45000-60000"]
[null,1099,"KATIA","BRABANT","F","1959-12-01","1989-11-20","3. Cadre","Réglementaire/Clinique","Directrice qualité","CDI","TC","FORFAIT","0",0,81222.803999999989,0,0,59,29,{"$f":"tranche_age(S108)","v":"4. 50 ans et plus"},"6 : 25-29","4:<60000"]
[null,1100,"RANYA","DELARUE","F","1981-03-25","2016-11-27","2. Etam","Qualité","Technicien R&D","CDI","TC","JOURNEE","0",21,25721.01,2.2499999999999999E-2,0,38,2,{"$f":"tranche_age(S109)","v":"2. 30 à 49 ans"},"1 : 1-4","1:20000-30000"]
[null,1101,"SERINE","JEANSON","F","2001-11-02","2032-01-04","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TP","EQUIPE","0",10.5,20493,4.4999999999999998E-2,0,17,-13,{"$f":"tranche_age(S110)","v":"1. moins de 30 ans"},"-2 : -15--11","1:20000-30000"]
[null,1102,"MAGALI","LEPRINCE","F","1951-01-02","1995-12-10","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,21309.989999999998,4.4999999999999998E-2,0,68,23,{"$f":"tranche_age(S111)","v":"4. 50 ans et plus"},"5 : 20-24","1:20000-30000"]
[null,1103,"IRÈNE","MICHAUT","F","1970-10-23","2000-04-29","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,20612.289999999997,3.2500000000000001E-2,0,48,19,{"$f":"tranche_age(S112)","v":"3. 40 à 49 ans"},"4 : 15-19","1:20000-30000"]
[null,1104,"GAËTAN","GUILBAUD","H","1964-01-09","1991-07-31","2. Etam","R&D","Technicien R&D","CDI","TC","JOURNEE","0",14,29657.89,0.02,0,55,27,{"$f":"tranche_age(S113)","v":"4. 50 ans et plus"},"6 : 25-29","1:20000-30000"]
[null,1105,"JEANNE","BERRIER","F","1987-09-21","2009-05-07","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",10.5,24784.399999999998,4.4999999999999998E-2,0,31,10,{"$f":"tranche_age(S114)","v":"2. 30 à 49 ans"},"3 : 10-14","1:20000-30000"]
[null,1106,"ELIANE","LACOTE","F","2001-10-29","2041-08-17","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TP","EQUIPE","0",0,23434.12,1.4999999999999999E-2,0,17,-23,{"$f":"tranche_age(S115)","v":"1. moins de 30 ans"},"-4 : -25--21","1:20000-30000"]
[null,1107,"EVA","TRIBOUT","F","1993-09-04","2026-09-26","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,17982.649999999998,0,0,25,-8,{"$f":"tranche_age(S116)","v":"1. moins de 30 ans"},"-1 : -10--6","<20000"]
[null,1108,"ALICIA","BENTZ","F","1972-08-06","2022-10-07","1. Ouvrier","Ordo & logistique","Agent de Fabrication","CDI","TC","EQUIPE","0",0,20042.109999999997,4.4999999999999998E-2,0,46,-4,{"$f":"tranche_age(S117)","v":"3. 40 à 49 ans"},"0 : -5--1","1:20000-30000"]
[null,1109,"GABRIEL","OSTER","H","1984-01-23","2014-10-07","2. Etam","R&D","Technicien R&D","CDI","TC","JOURNEE","0",0,31065.25,1.7500000000000002E-2,0,35,4,{"$f":"tranche_age(S118)","v":"2. 30 à 49 ans"},"1 : 1-4","2:30000-45000"]
[null,1110,"ALINE","CAVALIER","F","1964-03-25","2005-02-26","3. Cadre","Marketing","Chef de Produits","CDI","TC","FORFAIT","0",7,44498.376000000004,2.5000000000000001E-2,0,55,14,{"$f":"tranche_age(S119)","v":"4. 50 ans et plus"},"3 : 10-14","2:30000-45000"]
[null,1111,"RAYMOND","CHATENET","H","1958-08-10","1982-12-13","3. Cadre","Marketing","Commercial","CDI","TC","FORFAIT","0",0,50140.4,0.02,0,60,36,{"$f":"tranche_age(S120)","v":"4. 50 ans et plus"},"8 : 35-39","3:45000-60000"]
[null,1112,"PAULE","POREE","F","1986-08-12","2005-01-15","1. Ouvrier","Ordo & logistique","Agent de Fabrication","CDI","TC","EQUIPE","1",45,20632.849999999999,0.03,0,32,14,{"$f":"tranche_age(S121)","v":"2. 30 à 49 ans"},"3 : 10-14","1:20000-30000"]
[null,1113,"CHRISTOPHER","ROSSI","H","1981-10-15","2012-05-03","3. Cadre","R&D","Ingénieur Méthodes","CDI","TC","FORFAIT","0",0,36862.559999999998,0,0,37,7,{"$f":"tranche_age(S122)","v":"2. 30 à 49 ans"},"2 : 5-9","2:30000-45000"]
[null,1114,"GÉRARD","GARRET","H","1970-04-30","2015-06-20","2. Etam","R&D","Dessinateur","CDI","TC","JOURNEE","0",0,27404.09,0.02,0,49,4,{"$f":"tranche_age(S123)","v":"3. 40 à 49 ans"},"1 : 1-4","1:20000-30000"]
[null,1115,"INÉS","BELOT","F","1991-06-17","2014-01-07","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,20329.57,1.4999999999999999E-2,0,28,5,{"$f":"tranche_age(S124)","v":"1. moins de 30 ans"},"2 : 5-9","1:20000-30000"]
[null,1116,"BERTRAND","BAYON","H","1987-07-25","2020-09-11","2. Etam","R&D","Dessinateur","CDI","TC","JOURNEE","0",0,27646.149999999998,0.02,0,31,-2,{"$f":"tranche_age(S125)","v":"2. 30 à 49 ans"},"0 : -5--1","1:20000-30000"]
[null,1117,"GILBERT","PEYROT","H","1964-10-23","2000-05-24","3. Cadre","R&D","Responsable Méthodes ","CDI","TC","FORFAIT","0",0,40408.584000000003,1.4999999999999999E-2,0,54,19,{"$f":"tranche_age(S126)","v":"4. 50 ans et plus"},"4 : 15-19","2:30000-45000"]
[null,1118,"FERNAND","SAIDI","H","1978-10-23","2017-08-13","3. Cadre","Marketing","Directeur des Ventes","CDI","TC","FORFAIT","0",7,91709.923399999985,2.5000000000000001E-2,0,40,1,{"$f":"tranche_age(S127)","v":"3. 40 à 49 ans"},"1 : 1-4","4:<60000"]
[null,1119,"SYLVIANE","BERAUD","F","1972-03-01","2015-09-01","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",14,17746.539999999997,0.03,0,47,3,{"$f":"tranche_age(S128)","v":"3. 40 à 49 ans"},"1 : 1-4","<20000"]
[null,1120,"THIAGO","MORILLON","H","2002-09-21","2035-06-27","2. Etam","Fabrication","Technicien Fabrication","CDI","TC","JOURNEE","0",14,37426.200000000004,2.5000000000000001E-2,0,16,-16,{"$f":"tranche_age(S129)","v":"1. moins de 30 ans"},"-3 : -20--16","2:30000-45000"]
[null,1121,"ÉLISA","HECQUET","F","1989-06-20","2036-11-24","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,19723.519999999997,0,0,30,-18,{"$f":"tranche_age(S130)","v":"2. 30 à 49 ans"},"-3 : -20--16","<20000"]
[null,1122,"JEANINE","SEJOURNE","F","1976-04-09","2023-01-17","2. Etam","Ordo & logistique","Magasinier","CDI","TC","JOURNEE","0",14,18422.599999999999,1.7500000000000002E-2,0,43,-4,{"$f":"tranche_age(S131)","v":"3. 40 à 49 ans"},"0 : -5--1","<20000"]
[null,1123,"YVETTE","CAILLAT","F","1982-02-10","2029-03-27","3. Cadre","Administration","Responsable Adm.& Finan.","CDI","TC","JOURNEE","0",30,66515.685799999992,2.5000000000000001E-2,0,37,-10,{"$f":"tranche_age(S132)","v":"2. 30 à 49 ans"},"-1 : -10--6","4:<60000"]
[null,1124,"MICHELLE","BONNEL","F","1980-04-24","2008-06-18","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","1",10.5,18102.739999999998,0.03,0,39,11,{"$f":"tranche_age(S133)","v":"2. 30 à 49 ans"},"3 : 10-14","<20000"]
[null,1125,"AUDREY","DELESTRE","F","1971-05-19","1994-12-01","3. Cadre","Qualité","Ingénieur qualité","CDI","TC","JOURNEE","0",0,28282.719999999998,2.75E-2,0,48,24,{"$f":"tranche_age(S134)","v":"3. 40 à 49 ans"},"5 : 20-24","1:20000-30000"]
[null,1126,"AURÉLIEN","RABIER","H","1983-11-01","2035-05-03","2. Etam","Qualité","Contrôleur","CDI","TC","EQUIPE","0",45,22063.129999999997,2.2499999999999999E-2,0,35,-16,{"$f":"tranche_age(S135)","v":"2. 30 à 49 ans"},"-3 : -20--16","1:20000-30000"]
[null,1127,"SABRINA","DEJEAN","F","1971-08-28","2033-10-05","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",10.5,19117.939999999999,2.5000000000000001E-2,0,47,-15,{"$f":"tranche_age(S136)","v":"3. 40 à 49 ans"},"-2 : -15--11","<20000"]
[null,1128,"HANNA","PERRAULT","F","1969-06-12","2003-01-23","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,20838.48,3.2199999999999999E-2,0,{"$f":"INT((date_jour-$F137)/365.25)","v":50},{"$f":"INT((date_jour-$G137)/365.25)","v":16},{"$f":"tranche_age(S137)","v":"4. 50 ans et plus"},{"$f":"IF(ISNUMBER(T137),IF(T137=0,\"0 : - d'1 an\",INT(T137/5)+1&\" : \"&IF(INT(T137/5)=0,1,INT(T137/5)*5)&\"-\"&INT(T137/5)*5+4),\"\")","v":"4 : 15-19"},{"$f":"IF(P137=0,\" \",(IF(P137<20000,\"<20000\",IF(P137<=30000,\"1:20000-30000\",IF(P137<=45000,\"2:30000-45000\",IF(P137<=60000,\"3:45000-60000\",\"4:<60000\"))))))","v":"1:20000-30000"}]
[null,1129,"INGRID","GOURGUES","F","1968-11-19","2001-11-15","2. Etam","Marketing","Assistante Commerciale","CDI","TC","JOURNEE","0",0,36607.760000000002,1.4999999999999999E-2,0,50,17,{"$f":"tranche_age(S138)","v":"4. 50 ans et plus"},"4 : 15-19","2:30000-45000"]
[null,1130,"THÉRÈSE","FARGIER","F","1971-02-12","2000-04-26","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,19744.169999999998,4.4999999999999998E-2,0,48,19,{"$f":"tranche_age(S139)","v":"3. 40 à 49 ans"},"4 : 15-19","<20000"]
[null,1131,"MARIE-FRANÇOISE","COLINET","F","1980-02-17","2001-05-30","2. Etam","Administration","Assistante Admin et Production","CDI","TC","JOURNEE","0",0,22936.769999999997,1.7500000000000002E-2,0,39,18,{"$f":"tranche_age(S140)","v":"2. 30 à 49 ans"},"4 : 15-19","1:20000-30000"]
[null,1132,"HOCINE","LANGE","H","1978-09-29","2007-06-04","2. Etam","Informatique","Technicien Informatique","CDI","TC","JOURNEE","0",0,25114.32,0,0,40,12,{"$f":"tranche_age(S141)","v":"3. 40 à 49 ans"},"3 : 10-14","1:20000-30000"]
[null,1133,"DOLORES","THEBAUD","F","1974-10-01","1993-09-11","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",10.5,18855.199999999997,0.02,0,44,25,{"$f":"tranche_age(S142)","v":"3. 40 à 49 ans"},"6 : 25-29","<20000"]
[null,1134,"MATHILDE","GOBIN","F","1964-08-09","1993-05-03","3. Cadre","Administration","Contrôleur de gestion ","CDI","TC","JOURNEE","0",0,35539.910000000003,0,0,54,26,{"$f":"tranche_age(S143)","v":"4. 50 ans et plus"},"6 : 25-29","2:30000-45000"]
[null,1135,"AUGUSTIN","MIOT","H","2007-01-29","2033-04-21","3. Cadre","R&D","Ingénieur Dévelop.","CDI","TC","JOURNEE","0",0,40500.459000000003,0.02,0,12,-14,{"$f":"tranche_age(S144)","v":"1. moins de 30 ans"},"-2 : -15--11","2:30000-45000"]
[null,1136,"GAËTAN","GROSS","H","1973-10-10","2032-08-17","2. Etam","Fabrication","Technicien Fabrication","CDI","TC","JOURNEE","0",0,25216.38,0,0,45,-14,{"$f":"tranche_age(S145)","v":"3. 40 à 49 ans"},"-2 : -15--11","1:20000-30000"]
[null,1137,"ALEXANDRA","ROSTAING","F","1972-01-06","2018-01-10","3. Cadre","Marketing","Resp. zone export","CDI","TC","JOURNEE","0",0,60346.543999999994,1.4999999999999999E-2,0,47,1,{"$f":"tranche_age(S146)","v":"3. 40 à 49 ans"},"1 : 1-4","4:<60000"]
[null,1138,"CANDICE","PONCIN","F","1977-07-05","2008-07-06","3. Cadre","Qualité","Ingénieur Qualité","CDD","TC","JOURNEE","0",0,34769.920000000006,0,0,41,10,{"$f":"tranche_age(S147)","v":"3. 40 à 49 ans"},"3 : 10-14","2:30000-45000"]
[null,1139,"PASCALE","HOARAU","F","1976-08-21","2023-10-07","1. Ouvrier","Fabrication","Agent de Fabrication","CDI","TC","EQUIPE","0",0,21732.219999999998,0,0,42,-5,{"$f":"tranche_age(S148)","v":"3. 40 à 49 ans"},"0 : -5--1","1:20000-30000"]
[null,1140,"FRANÇOIS","BECK","H","1988-04-03","2019-03-11","2. Etam","Ordo & logistique","Magasinier","CDI","TC","JOURNEE",0,0,16802.099999999999,0,0,31,0,{"$f":"tranche_age(S149)","v":"2. 30 à 49 ans"},"0 : - d'1 an","<20000"]

{"sheet":"1- écart rémunération","index":1,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[9,0,10,0],[9,2,9,3],[9,4,10,4],[9,1,10,1],[23,0,23,1],[15,0,18,0],[11,0,14,0],[19,0,22,0],[23,6,23,7],[7,3,7,10],[9,8,10,8],[9,10,10,10],[9,9,10,9],[9,5,10,5],[9,6,9,7]]}
["1- Indicateur d'écart de rémunération"]
[]
["Saisir vos données dans les seules cellules vertes. Ne rien saisir dans les autres cellules. "]
["Les résultats apparaissent dans les cellules jaunes. Ils peuvent être accompagnés de commentaires pour les interpréter. "]
["Ne renseigner les salaires moyens que lorsqu'ils sont calculés sur au moins trois personnes."]
[]
["Catégories de postes équivalents :",null,"4 CSP","Par défaut, les catégories de postes équivalents sont les 4 catégories socioprofessionnelles (CSP)."]
["Seuil de pertinence associé :",null,0.05,"Par défaut, le seuil de pertinence est fixé à 5 % (pour une catégorisation en 4 CSP). Pour toute autre catégorisation, il est fixé à 2 %. Remplacer 5 % par 2 % si vous êtes dans ce cas."]
[]
["catégorie socioprofessionnelle (CSP)","tranche d'âge","rémunération annuelle brute moyenne par EQTP",null,"écart de rémunération moyenne","écart après application du seuil de pertinence","nombre de salariés",null,"validité du groupe (1=oui, 0=non)","effectifs valides (groupes pris en compte)","écart pondéré"]
[null,null,"femmes","hommes",null,null,"femmes","hommes"]
["ouvriers","moins de 30 ans",null,null,{"$f":"IF(AND(C12>0,D12>0),(D12-C12)/D12,\" \")","v":" "},{"$f":"IF(ISNUMBER(E12),SIGN(E12)*MAX(0,ABS(E12)-$C$8),\" \")","v":" "},null,null,{"$f":"IF(AND(G12>=3,H12>=3),1,0)","v":0},{"$f":"I12*SUM(G12:H12)","v":0},{"$f":"IF(I12=1,F12*J12/J$24,0)","v":0}]
[null,"30 à 39 ans",null,null,{"$f":"IF(AND(C13>0,D13>0),(D13-C13)/D13,\" \")","v":" "},{"$f":"IF(ISNUMBER(E13),SIGN(E13)*MAX(0,ABS(E13)-$C$8),\" \")","v":" "},null,null,{"$f":"IF(AND(G13>=3,H13>=3),1,0)","v":0},{"$f":"I13*SUM(G13:H13)","v":0},0]
[null,"40 à 49 ans",null,null," "," ",null,null,0,0,0]
[null,"50 ans et plus",null,null," "," ",null,null,0,0,0]
["techniciens et agents de maîtrise","moins de 30 ans",null,null," "," ",null,null,0,0,0]
[null,"30 à 39 ans",null,null," "," ",null,null,0,0,0]
[null,"40 à 49 ans",null,null,{"$f":"IF(AND(C18>0,D18>0),(D18-C18)/D18,\" \")","v":" "}," ",null,null,0,0,0]
[null,"50 ans et plus",null,null," "," ",null,null,0,0,0]
["ingénieurs et cadres","moins de 30 ans",null,null," "," ",null,null,0,0,0]
[null,"30 à 39 ans",null,null," "," ",null,null,0,0,0]
[null,"40 à 49 ans",null,null," "," ",null,null,0,0,0]
[null,"50 ans et plus",null,null," "," ",null,null,0,0,0]
["ensemble des salariés",null,{"$f":"SUMPRODUCT(C12:C23,G12:G23)/SUM(G12:G23)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(D12:D23,H12:H23)/SUM(H12:H23)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(C24>0,D24>0),(D24-C24)/D24,\" \")","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G12:H23)","v":0},null,null,{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0}]
[]
["Pour des catégories de postes équivalents plus fines que les 4 CSP, dupliquer et insérer les lignes 12 à 15 après la ligne 19 autant de fois que nécessaire et modifier les intitulés de catégories de postes."]
[]
["indicateur calculable (1=oui, 0=non) :",null,null,{"$f":"IF(G24>0,IF(J24>=40%*G24,1,0),\"#N/A\")","v":"#N/A"},{"$f":"IF(D28=1,\"Les effectifs valides représentent plus de 40 % des effectifs totaux.\",IF(D28=0,\"Les effectifs valides représentent moins de 40 % des effectifs totaux.\",\" \"))","v":" "}]
["indicateur d'écart de rémunération (%) :",null,null,{"$f":"IF(D28=1,ABS(ROUND(100*K24,1)),IF(D28=0,\"INCALCULABLE\",\"#N/A\"))","v":"#N/A"},{"$f":"IF(AND(K24>0,D28=1),\"Un écart de rémunération est constaté en faveur des hommes.\",IF(AND(K24<0,D28=1),\"Un écart de rémunération est constaté en faveur des femmes.\",\" \"))","v":" "}]
["note obtenue sur 40 :",null,null,{"$f":"VLOOKUP(D29,barèmes!B5:C26,2)","v":{"$error":"#N/A"}}]

{"sheet":"2- écart augmentations","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,0,7,0],[6,1,6,2],[6,8,7,8],[15,4,16,9],[6,3,6,4],[6,5,6,6],[6,7,7,7],[6,9,7,9]]}
["2- indicateur d'écart de taux d'augmentations individuelles"]
[]
["Saisir vos données dans les seules cellules vertes. Ne rien saisir dans les autres cellules. "]
["Les résultats apparaissent dans les cellules jaunes. Ils peuvent être accompagnés de commmentaires pour les interpréter. "]
["En l'absence de modification de votre part, les nombres de salariés sont calculés d'après les données renseignées pour l'indicateur d'écarts de rémunération (cellules grises)."]
[]
[null,"nombre de salariés augmentés au cours de la période de référence *",null,"nombre de salariés",null,"taux d'augmentation",null,"écart de taux d'augmen-tation","écart absolu de taux d'augmen-tation","écart en nombre équivalent de salariés"]
[null,"femmes","hommes","femmes","hommes","femmes","hommes"]
["ensemble des salariés",null,null,{"$f":"SUM('1- écart rémunération'!G12:G23)","v":0},{"$f":"SUM('1- écart rémunération'!H12:H23)","v":0},{"$f":"B9/D9","v":{"$error":"#DIV/0!"}},{"$f":"C9/E9","v":{"$error":"#DIV/0!"}},{"$f":"G9-F9","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(0<=B9,B9<=D9,0<=C9,C9<=E9),ABS(F9-G9),\"#VALEUR!\")","v":{"$error":"#DIV/0!"}},{"$f":"I9*MIN(D9,E9)","v":{"$error":"#DIV/0!"}}]
["* Seules les augmentations individuelles du salaire de base sont à prendre en compte, qu'elles correspondent ou non à une promotion. ",null,null,null,null,null,null,null,{"$f":"IF(I9=\"#VALEUR!\",\"Incohérence dans les nombres de salariés saisis.\",\" \")","v":{"$error":"#DIV/0!"}}]
["Il ne faut comptabiliser les salariés augmentés que parmi ceux qui entrent dans le calcul de l'index."]
["La période de référence retenue pour évaluer la présence d'augmentations peut être allongée à deux ou trois ans. Son caractère pluriannuel peut alors être révisé tous les trois ans"]
[]
["indicateur calculable (1=oui, 0=non) :",null,null,{"$f":"IF(AND(ISBLANK(B9),ISBLANK(C9)),\"#N/A\",IF(AND(D9>=5,E9>=5,B9+C9>0),1,0))","v":"#N/A"},{"$f":"IF(D14=1,\"Il y a eu des augmentations et les effectifs comportent au moins 5 femmes et 5 hommes.\",IF(OR(D9<5,E9<5),\"Les effectifs comprennent moins de 5 femmes ou moins de 5 hommes.\",IF(AND(ISBLANK(B9),ISBLANK(C9)),\" \",\"Il n'y a pas eu d'augmentations dans l'entreprise.\")))","v":"Les effectifs comprennent moins de 5 femmes ou moins de 5 hommes."}]
["écart absolu de taux d'augmentation (points de %) :",null,null,{"$f":"IF(D14=1,ABS(ROUND(100*I9,1)),IF(D14=0,\"INCALCULABLE\",\"#N/A\"))","v":"#N/A"},{"$f":"IF(AND(H9>=0.05%,D14=1),\"Un écart de taux d'augmentation est constaté en faveur des hommes.\",IF(AND(H9<=-0.05%,D14=1),\"Un écart de taux d'augmentation est constaté en faveur des femmes.\",\" \"))","v":{"$error":"#DIV/0!"}}]
["écart en nombre équivalent de salariés :",null,null,{"$f":"IF(D14=1,ABS(ROUND(J9,1)),IF(D14=0,\"INCALCULABLE\",\"#N/A\"))","v":"#N/A"},{"$f":"IF(AND(D14=1,H9>=0.05%,E9>=D9),'2 - message'!C4,IF(AND(D14=1,H9>=0.05%,E9<D9),'2 - message'!C5,IF(AND(D14=1,H9<=-0.05%,E9<=D9),'2 - message'!C8,IF(AND(D14=1,H9<=-0.05%,D9<E9),'2 - message'!C7,\" \"))))","v":{"$error":"#DIV/0!"}}]
[]
["note correspondant à l'écart absolu de taux d'augmentation :",null,null,{"$f":"IF('1- écart rémunération'!D28=1,IF(AND('1- écart rémunération'!D30<MAX(barèmes!C5:C26), SIGN(H9)=-SIGN('1- écart rémunération'!K24)),MAX(barèmes!F5:F8),VLOOKUP(D15,barèmes!E5:F8,2)),VLOOKUP(D15,barèmes!E5:F8,2))","v":{"$error":"#N/A"}}]
["note correspondant à l'écart en nombre équivalent de salariés :",null,null,{"$f":"IF('1- écart rémunération'!D28=1,IF(AND('1- écart rémunération'!D30<MAX(barèmes!C5:C26), SIGN(H9)=-SIGN('1- écart rémunération'!K24)),MAX(barèmes!F5:F8),VLOOKUP(D16,barèmes!E5:F8,2)),VLOOKUP(D16,barèmes!E5:F8,2))","v":{"$error":"#N/A"}}]
["note obtenue sur 35 :",null,null,{"$f":"MAX(D18,D19)","v":{"$error":"#N/A"}},{"$f":"IF('1- écart rémunération'!D28=1,IF(AND('1- écart rémunération'!D30<MAX(barèmes!C5:C26), SIGN(H9)=-SIGN('1- écart rémunération'!K24),D15>=0.1),\"L'écart d'augmentations réduit l'écart de rémunération. Tous les points sont accordés.\",\" \"),\" \")","v":" "}]

{"sheet":"2 - message","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,2,2,2],[1,0,1,1]]}
[]
["Situation",null,"Message accompagnant l'écart en nombre équivalent de salariés :"]
["écart en faveur des :","Plus petit nombre de salariés :"]
["hommes","femmes","Si ce nombre de femmes supplémentaires avait bénéficié d'une augmentation, les taux d'augmentation seraient égaux entre hommes et femmes."]
["hommes","hommes","Si ce nombre d'hommes n'avait pas reçu d'augmentation parmi les bénéficiaires, les taux d'augmentation seraient égaux entre hommes et femmes."]
["hommes","égal",{"$f":"C4","v":"Si ce nombre de femmes supplémentaires avait bénéficié d'une augmentation, les taux d'augmentation seraient égaux entre hommes et femmes."}]
["femmes","femmes","Si ce nombre de femmes n'avait pas reçu d'augmentation parmi les bénéficiaires, les taux d'augmentation seraient égaux entre hommes et femmes."]
["femmes","hommes","Si ce nombre d'hommes supplémentaires avait bénéficié d'une augmentation, les taux d'augmentation seraient égaux entre hommes et femmes."]
["femmes","égal",{"$f":"C8","v":"Si ce nombre d'hommes supplémentaires avait bénéficié d'une augmentation, les taux d'augmentation seraient égaux entre hommes et femmes."}]
["aucun","femmes"]
["aucun","hommes"]
["aucun","égal"]

{"sheet":"3- AI maternité","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,12],[8,0,8,3],[9,0,9,3],[12,0,12,1],[13,3,13,12],[5,0,6,0],[5,1,5,2],[5,3,6,3]]}
["3- pourcentage de salariés ayant bénéficié d'une augmentation dans l'année suivant leur retour de congé maternité"]
[]
["Saisir vos données dans les seules cellules vertes. Ne rien saisir dans les autres cellules. "]
["Les résultats apparaissent dans les cellules jaunes. Ils peuvent être accompagnés de commmentaires pour les interpréter. "]
[]
[null,"nombre de salariés de retour de congé maternité/adoption*",null,"pourcentage de salariés augmentés"]
[null,"total","augmentés**"]
["ensemble des salariés",null,null,{"$f":"IF(C12=1, IF(AND(C8>=0,C8<=B8),C8/B8,\"ERREUR\"),\" \")","v":" "}]
["*  Les salariés à considérer sont les salariés revenus de congé maternité ou d’adoption (éventuellement prolongé par un congé parental) pendant la période de référence, et durant lequel sont intervenues des augmentations générales et/ou individuelles pour les salariés relevant de la même catégorie professionnelle, ou à défaut, pour l’ensemble des salariés de l’entreprise. Même si ces salariés ont été absents plus de la moitié de la période de référence, ils doivent être pris en compte pour le calcul de l'indicateur. "]
["** Les augmentations à prendre en compte sont celles qui sont intervenues soit pendant le congé maternité/adoption, soit à son retour, avant la fin de la période de référence."]
[]
["indicateur calculable (1=oui, 0=non) :",null,{"$f":"IF(ISBLANK(B8),\"#N/A\",IF(B8>0,1,0))","v":"#N/A"},{"$f":"IF(C12=1,\"Il y a eu au moins un retour de congé maternité avec augmentation pendant ce congé.\",IF(C12=0,\"Il n'y a pas eu de retour de congé maternité avec augmentation pendant ce congé.\",\" \"))","v":" "}]
["indicateur de pourcentage de salariés ayant bénéficié d'une augmentation dans l'année suivant leur retour de congé maternité (%) :",null,{"$f":"IF(C12=1,ABS(ROUND(100*D8,1)),IF(C12=0,\"INCALCULABLE\",\"#N/A\"))","v":"#N/A"}]
["note obtenue sur 15 :",null,{"$f":"VLOOKUP(C13,barèmes!H5:I6,2)","v":{"$error":"#N/A"}},{"$f":"IF(C14=0,\"Les salariés de retour de congé maternité ou d’adoption, durant lequel des augmentations sont intervenues, n’ont pas tous été augmentés. Aucun point n’est accordé.\",IF(C14=MAX(barèmes!I5:I6),\"Tous les salariés de retour de congé maternité ou d’adoption, durant lequel des augmentations sont intervenues, ont été augmentés. Tous les points sont accordés.\",\" \"))","v":{"$error":"#N/A"}}]

{"sheet":"4- 10 + hautes rému","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,1,5,3],[5,0,6,0],[5,4,6,4],[10,0,10,1]]}
["4- nombre de salariés du sexe sous-représenté parmi les 10 plus hautes rémunérations"]
[]
["Saisir vos données dans les seules cellules vertes. Ne rien saisir dans les autres cellules. "]
["Les résultats apparaissent dans les cellules jaunes. Ils peuvent être accompagnés de commmentaires pour les interpréter. "]
[]
[null,"Nombre de salariés parmi les 10 plus hautes rémunérations*",null,null,"nombre de salariés du sexe sous-représenté"]
[null,"femmes","hommes","ensemble"]
["ensemble des salariés",null,null,{"$f":"B8+C8","v":0},{"$f":"IF(D8=10,MIN(B8,C8),\"TOTAL différent de 10\")","v":"TOTAL différent de 10"}]
["* Les rémunérations à considérer sont les rémunérations brutes annuelles par EQTP utilisées pour l'indicateur 1."]
[]
["indicateur du nombre de salariés du sexe sous-représenté parmi les 10 plus hautes rémunérations :",null,{"$f":"E8","v":"TOTAL différent de 10"},{"$f":"IF(D8=10,IF(B8>C8,\"Les hommes sont sous-représentés parmi les salariés les mieux rémunérés.\",IF(C8>B8,\"Les femmes sont sous-représentées parmi les salariés les mieux rémunérés.\",\"Les hommes et les femmes sont à parité parmi les salariés les mieux rémunérés.\")),\" \")","v":" "}]
["note obtenue sur 10 :",null,{"$f":"VLOOKUP(C11,barèmes!K5:L7,2)","v":{"$error":"#N/A"}}]

{"sheet":"index","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Calcul de l'index d'égalité professionnelle femmes-hommes"]
[]
["Calculs automatiques, ne pas modifier."]
[]
[null,"indicateur calculable (1=oui, 0=non)","valeur de l'indicateur","points obtenus","nombre de points maximum de l'indicateur","nombre de points maximum des indicateurs calculables"]
["1- écart de remuneration (en %)",{"$f":"'1- écart rémunération'!D28","v":"#N/A"},{"$f":"'1- écart rémunération'!D29","v":"#N/A"},{"$f":"IF(B6=1,'1- écart rémunération'!D30,\" \")","v":" "},40,{"$f":"B6*E6","v":{"$error":"#VALUE!"}}]
["2- écarts d'augmentations individuelles (en points de % ou en nombre équivalent de salariés)",{"$f":"'2- écart augmentations'!D14","v":"#N/A"},{"$f":"IF(B7=1,MIN('2- écart augmentations'!D15,'2- écart augmentations'!D16),IF(B7=0,\"INCALCULABLE\",\"#N/A\"))","v":"#N/A"},{"$f":"IF(B7=1,'2- écart augmentations'!D20,\" \")","v":" "},35,{"$f":"B7*E7","v":{"$error":"#VALUE!"}}]
["3- pourcentage de salariés augmentés au retour d'un congé maternité (%)",{"$f":"'3- AI maternité'!C12","v":"#N/A"},{"$f":"'3- AI maternité'!C13","v":"#N/A"},{"$f":"IF(B8=1,'3- AI maternité'!C14,\" \")","v":" "},15,{"$error":"#VALUE!"}]
["4- nombre de salariés du sexe sous-représenté parmi les 10 plus hautes rémunérations",1,{"$f":"'4- 10 + hautes rému'!C11","v":"TOTAL différent de 10"},{"$f":"IF(B9=1,'4- 10 + hautes rému'!C12,\" \")","v":{"$error":"#N/A"}},10,10]
["Total des indicateurs calculables",null,null,{"$f":"SUM(D6:D9)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F6:F9)","v":{"$error":"#VALUE!"}}]
["INDEX (sur 100 points)",null,null,{"$f":"IF(F10>=75,D10*100/F10,\"INCALCULABLE\")","v":{"$error":"#VALUE!"}},null,100]
[{"$f":"IF(F10<75,\"L'index est incalculable car le nombre de points maximum des indicateurs calculables est inférieur à 75.\",IF(AND(F10>=75,F10<100),\"Le total des indicateurs calculables est ramené sur 100 points en appliquant la règle de la proportionnalité.\",\" \"))","v":{"$error":"#VALUE!"}}]

{"sheet":"barèmes","index":7,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5],[2,7,2,8],[2,10,2,11]]}
[]
[null,"Ne pas modifier les barèmes des indicateurs. "]
[null,"Indicateur 1 : écart de rémunération (%)",null,null,"Indicateur 2 : écart de taux d'augmentations individuelles (points de %)",null,null,"Indicateur 3 : pourcentage de salariés ayant bénéficié d'une augmentation dans l'année suivant leur retour de congé maternité (%)",null,null,"Indicateur 4 : nombre de salariés du sexe sous-représenté parmi les 10 plus hautes rémunérations"]
[null,"plancher","note",null,"plancher","note",null,"plancher","note",null,"plancher","note"]
[null,0,40,null,0,35,null,0,0,null,0,0]
[null,0.1,39,null,2.1,25,null,100,15,null,2,5]
[null,{"$f":"B6+1","v":1.1000000000000001},38,null,5.0999999999999996,15,null,null,null,null,4,10]
[null,{"$f":"B7+1","v":2.1},37,null,10.1,0]
[null,3.1,36]
[null,4.0999999999999996,35]
[null,5.0999999999999996,34]
[null,6.1,33]
[null,7.1,31]
[null,8.1,29]
[null,9.1,27]
[null,10.1,25]
[null,11.1,23]
[null,12.1,21]
[null,13.1,19]
[null,14.1,17]
[null,15.1,14]
[null,16.100000000000001,11]
[null,17.100000000000001,8]
[null,18.100000000000001,5]
[null,19.100000000000001,2]
[null,{"$f":"B25+1","v":20.100000000000001},0]