{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Salaire","Horaires","Feries"],"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":"Salaire","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[10,10,12,10],[51,5,52,5],[51,7,52,7],[0,2,0,7],[1,2,1,7],[44,8,44,9],[23,5,24,5],[23,7,24,7],[31,5,32,5],[31,7,32,7],[23,4,24,4],[7,5,7,6]]}
[null,null," Bulletin de Salaire"]
[null,null,"Ce bulletin de salaire doit être conservé sans limitation de durée"]
[null,"Cotisations salariales applicables au 1er janvier 2007"]
[]
[1,"BULLETIN DE PAIE",null,null,"du ………………………","2017-08-01","au ……………………..","31/08/2017"]
[2,"NOM du salarié ……………………………..",null,null,"Prénom ……………………………."]
[3,"Adresse ……………………………………………………………………………………."]
[4,"N° immatriculation sociale du salarié : ………………………………………"]
[5,"Convention collective nationale des assistants maternels du particulier employeur",null,null,null,null,null,"NAF-88-91A"]
[6,"Emploi : Assistant Maternel"]
[7,"Congés : du ………………………...  Au  …………………………………..",null,null,null,null,null,null,null,null,"nombre d'heures théoriques"]
[]
[8,"SALAIRE MENSUEL BRUT",null,null,null,null,null,null,null,"Jours"]
[9,"Salaire mensualisé brut de base :",null,null,"nombres d'heures: ",120,null,{"$f":"F14*F18","v":504},null,1,"10:30:00","Mar",null,0.4375]
[10,"Heures complémentaires :",null,null,"nombres d'heures: ",null,null,null,null,2," ","Mer",null," "]
[11,"Heures majorées :",null,null,"nombres d'heures ………….",null,null,null,null,3,"10:30:00","Jeu",null,0.4375]
[12,"Accueil Occasionnel :",null,null,"nombres d'heures ………….",null,null,null,null,4,"09:30:00","Ven",null,0.39583333333333331]
[13,"Absences :",null,null,"Taux horaire brut",4.2,null,null,null,5," ","Sam",null," "]
[14,"Congés Payés : ………………………………………………………………….",null,0.1,null,null,null,{"$f":"H14*D19","v":50.400000000000006},null,6," ","Dim",null," "]
[15,"Divers :","…………………………………………………………………….",null,null,null,null,null,null,7,"09:30:00","Lun",null,0.39583333333333331]
[16,null,null,null,null,null,null,null,null,8,"10:30:00","Mar",null,0.4375]
[17,null,null,null,null,"SALAIRE TOTAL BRUT",null,{"$f":"H14+H19+H15-H18-H13","v":554.4},null,9," ","Mer",null," "]
[18,"A déduire",null,null,null,null,null,null,null,10,"10:30:00","Jeu",null,0.4375]
[19,"Part salariale des cotisations sociales",null,null,"BASE (100 % du salaire brut)","TAUX",null,"MONTANT",null,11,"09:30:00","Ven",null,0.39583333333333331]
[20,null,null,null,null,null,null,null,null,12," ","Sam",null," "]
[21,"SECURITE SOCIALE",null,"Maladie et vieillesse","…………….",8.0500000000000002E-2,null,{"$f":"F26*H22","v":44.629199999999997},null,13," ","Dim",null," "]
[null,null,null,null,"…………….",0,null,null,null,14,"09:30:00","Lun",null,0.39583333333333331]
[22,"RETRAITE COMPLEMENTAIRE",null,null,"…………….",3.1E-2,null,{"$f":"F28*H22","v":17.186399999999999},null,15,"10:30:00","Mar","FERIE",0.4375]
[23,"AGFF",null,null,"…………….",8.0000000000000002E-3,null,{"$f":"F29*H22","v":4.4352},null,16," ","Mer",null," "]
[24,"ASSEDIC (si l'AM a moins de 65 ans)",null,null,"…………….",2.4E-2,null,{"$f":"F30*H22","v":13.3056},null,17,"10:30:00","Jeu",null,0.4375]
[25,"PREVOYANCE",null,null,"…………….",1.15E-2,null,{"$f":"F31*H22","v":6.3755999999999995},null,18,"09:30:00","Ven",null,0.39583333333333331]
[26,null,null,null,"98,25 % du","TAUX",null,"MONTANT",null,19," ","Sam",null," "]
[27,null,null,null,"salaire brut",null,null,null,null,20," ","Dim",null," "]
[28,"C.S.G. déductible",null,null,{"$f":"0.9825*H22","v":544.69799999999998},5.0999999999999997E-2,null,{"$f":"E34*F34","v":27.779597999999996},null,21,"09:30:00","Lun",null,0.39583333333333331]
[29,"C.S.G. et C.R.D.S. non déductibles",null,null,{"$f":"0.9825*H22","v":544.69799999999998},2.9000000000000001E-2,null,{"$f":"E35*F35","v":15.796241999999999},null,22,"10:30:00","Mar",null,0.4375]
[30,null,null,null,"Total des retenues (lignes 21 à 29)",null,null,{"$f":"SUM(H26:H35)","v":129.50783999999999},null,23," ","Mer",null," "]
[31,null,null,null,null,"SALAIRE NET",null,{"$f":"H22-H36","v":424.89215999999999},null,24,"10:30:00","Jeu",null,0.4375]
[32,"A ajouter : Indemnités",null,null,"Nb Jours","à",null,null,null,25,"09:30:00","Ven",null,0.39583333333333331]
[33,"Fourniture, entretien : nombre de jours",null,null,{"$f":"K47","v":18},3.3,null,{"$f":"E39*F39","v":59.4},null,26," ","Sam",null," "]
[34,"Nourriture-repas : nombre",null,null,{"$f":"K47","v":18},4.5,null,{"$f":"E40*F40","v":81},null,27," ","Dim",null," "]
[35,"Déplacement : nombre de kilomètres",null,null,0,0,null,{"$f":"E41*F41","v":0},null,28,"09:30:00","Lun",null,0.39583333333333331]
[36,"Divers :",null,null,0,0,null,{"$f":"E42*F42","v":0},null,29,"10:30:00","Mar",null,0.4375]
[37,null,null,null,"Total à ajouter (lignes 33 à 36)",null,null,{"$f":"H39+H40","v":140.4},null,30," ","Mer",null," "]
[38,null,null,null,"NET A PAYER (lignes 31 + 37)",null,null,{"$f":"SUM(H37+H43)","v":565.29215999999997},null,31,"10:30:00","Jeu",null,0.4375]
[39,null,null,null,"Acomptes versés",null,null,null,"Total H",null,{"$f":"SUM(K14:K44)","v":7.5416666666666661}]
[null,null,null,null,null,null,null,null,null,"Total"]
[40,null,null,null,"Solde à verser",null,null,null,null,"jours",{"$f":"COUNT(K14:K44)","v":18}]
[41,"NOM de l'employeur : ……………………………………………………………………………."]
[42,"Adresse : ………………………………………………………………………………………….."]
[43,"U.R.S.S.A.F. de …………..",null,"N° ……………………………",null,"ou N° PAJEMPLOI ……………………………"]
[44,"N° d'identification employeur …………………………………………………………………"]
[45,"Part patronale des cotisations sociales",null,null,"BASE(salaire","TAUX",null,"MONTANT"]
[46,null,null,null,"brut)"]
[47,"SECURITE SOCIALE+ CSA + FNAL",null,null,"……………..",0.29349999999999998,null,{"$f":"F54*H22","v":162.71639999999999}]
[48,"RETRAITE COMPLEMENTAIRE",null,null,"……………..",4.58E-2,null,{"$f":"F55*H22","v":25.39152}]
[49,"AGFF",null,null,"……………..",1.2E-2,null,{"$f":"F56*H22","v":6.6528}]
[50,"ASSEDIC",null,null,"……………..",0.04,null,{"$f":"F57*H22","v":22.175999999999998}]
[51,"PREVOYANCE",null,null,"……………..",1.37E-2,null,5.23]
[52,"FORMATION PROFESSIONNELLE",null,null,"……………..",1.5E-3,null,{"$f":"F59*H22","v":0.83160000000000001}]
[53,"Total des cotisations patronales",null,null,null,null,null,{"$f":"SUM(H54:H59)","v":222.99831999999998}]
[54,null,null,null,"Pour information"]
[55,null,null,"Net à payer (ligne38) : ",{"$f":"H44","v":565.29215999999997},"nbre de jours d'accueil effectués : …………",null,{"$f":"K47","v":18}]
[56,null,null,"C.S.G. et C.R.D.S. non déduct (ligne29) : ",{"$f":"H35","v":15.796241999999999}]
[57,null,null,"Montant imposable (ligne 55et 56) :",{"$f":"E62+E63","v":581.08840199999997},"nbre d'heures ",null,{"$f":"K45","v":7.5416666666666661}]
[]
[null,"Date de paiement :",null,{"$f":"H5","v":"31/08/2017"},"Signature de l'employeur :"]

{"sheet":"Horaires","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Lun","09:30:00"]
["Mar","10:30:00"]
["Mer"," "]
["Jeu","10:30:00"]
["Ven","09:30:00"]
["Sam"," "]
["Dim"," "]
[]
[]
["Entrez ici les heures de garde par jour"]

{"sheet":"Feries","index":2,"n_rows":48,"n_cols":68,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Exemple de calcul de durée de travail"]
[]
["Date de début de carrière","Date de fin de carrière","Période de début temps partiel","Période de fin de temps partiel","Nb de jours ouvrés"]
["1980-02-01","2010-02-01",null,null,{"$f":"NETWORKDAYS(A4,B4)","v":7827},"* doit servir de référence pour le calcul car cela correspond à 30 ans de jours ouvrés sans aucun temps partie"]
[null,null,null,null,null,"et sans jours fériés"]
[]
["Pour les jours fériés, j'ai trouvé ceci :"]
["http://xxl-leblog.svmlemag.fr/2005/03/table-des-jours.html"]
[]
[null,{"$f":"YEAR(A4)","v":1980},{"$f":"B10+1","v":1981},{"$f":"C10+1","v":1982},1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,{"$f":"AD10+1","v":2009},2010,{"$f":"AF10+1","v":2011},{"$f":"AG10+1","v":2012},{"$f":"AH10+1","v":2013},{"$f":"AI10+1","v":2014},{"$f":"AJ10+1","v":2015},{"$f":"AK10+1","v":2016},{"$f":"AL10+1","v":2017},{"$f":"AM10+1","v":2018},{"$f":"AN10+1","v":2019},{"$f":"AO10+1","v":2020},{"$f":"AP10+1","v":2021},{"$f":"AQ10+1","v":2022},{"$f":"AR10+1","v":2023},{"$f":"AS10+1","v":2024},{"$f":"AT10+1","v":2025},{"$f":"AU10+1","v":2026},{"$f":"AV10+1","v":2027},{"$f":"AW10+1","v":2028},{"$f":"AX10+1","v":2029},{"$f":"AY10+1","v":2030},{"$f":"AZ10+1","v":2031},{"$f":"BA10+1","v":2032},{"$f":"BB10+1","v":2033},{"$f":"BC10+1","v":2034},{"$f":"BD10+1","v":2035},{"$f":"BE10+1","v":2036},{"$f":"BF10+1","v":2037},{"$f":"BG10+1","v":2038},{"$f":"BH10+1","v":2039},{"$f":"BI10+1","v":2040},{"$f":"BJ10+1","v":2041},{"$f":"BK10+1","v":2042},{"$f":"BL10+1","v":2043},{"$f":"BM10+1","v":2044},{"$f":"BN10+1","v":2045},{"$f":"BO10+1","v":2046}]
["Premier de l'an",{"$f":"DATE(B10,1,1)","v":"1980-01-01"},{"$f":"DATE(C10,1,1)","v":"1981-01-01"},"1982-01-01","1983-01-01","1984-01-01","1985-01-01","1986-01-01","1987-01-01","1988-01-01","1989-01-01","1990-01-01","1991-01-01","1992-01-01","1993-01-01","1994-01-01","1995-01-01","1996-01-01","1997-01-01","1998-01-01","1999-01-01","2000-01-01","2001-01-01","2002-01-01","2003-01-01","2004-01-01","2005-01-01","2006-01-01","2007-01-01","2008-01-01","2009-01-01","2010-01-01",{"$f":"DATE(AG10,1,1)","v":"2011-01-01"},"2012-01-01","2013-01-01","2014-01-01","2015-01-01","2016-01-01","2017-01-01","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01","2037-01-01","2038-01-01","2039-01-01","2040-01-01","2041-01-01","2042-01-01","2043-01-01","2044-01-01","2045-01-01","2046-01-01"]
["Lundi de Pâques",{"$f":"B22+1","v":"1980-04-07"},"1981-04-20","1982-04-12","1983-04-04","1984-04-23","1985-04-08","1986-03-31","1987-04-20","1988-04-04","1989-03-27","1990-04-16","1991-04-01","1992-04-20","1993-04-12","1994-04-04","1995-04-17","1996-04-08","1997-03-31","1998-04-13","1999-04-05","2000-04-24","2001-04-16","2002-04-01","2003-04-21","2004-04-12","2005-03-28","2006-04-17","2007-04-09","2008-03-24","2009-04-13","2010-04-05",{"$f":"AG22+1","v":"2011-04-25"},"2012-04-09","2013-04-01","2014-04-21","2015-04-06","2016-03-28","2017-04-17","2018-04-02","2019-04-22","2020-04-13","2021-04-05","2022-04-18","2023-04-10","2024-04-01","2025-04-21","2026-04-06","2027-03-29","2028-04-17","2029-04-02","2030-04-22","2031-04-14","2032-03-29","2033-04-18","2034-04-10","2035-03-26","2036-04-14","2037-04-06","2038-04-26","2039-04-11","2040-04-02","2041-04-22","2042-04-07","2043-03-30","2044-04-18","2045-04-10","2046-03-26"]
["Fête du travail",{"$f":"DATE(B10,5,1)","v":"1980-05-01"},{"$f":"DATE(C10,5,1)","v":"1981-05-01"},"1982-05-01","1983-05-01","1984-05-01","1985-05-01","1986-05-01","1987-05-01","1988-05-01","1989-05-01","1990-05-01","1991-05-01","1992-05-01","1993-05-01","1994-05-01","1995-05-01","1996-05-01","1997-05-01","1998-05-01","1999-05-01","2000-05-01","2001-05-01","2002-05-01","2003-05-01","2004-05-01","2005-05-01","2006-05-01","2007-05-01","2008-05-01","2009-05-01","2010-05-01",{"$f":"DATE(AG10,5,1)","v":"2011-05-01"},"2012-05-01","2013-05-01","2014-05-01","2015-05-01","2016-05-01","2017-05-01","2018-05-01","2019-05-01","2020-05-01","2021-05-01","2022-05-01","2023-05-01","2024-05-01","2025-05-01","2026-05-01","2027-05-01","2028-05-01","2029-05-01","2030-05-01","2031-05-01","2032-05-01","2033-05-01","2034-05-01","2035-05-01","2036-05-01","2037-05-01","2038-05-01","2039-05-01","2040-05-01","2041-05-01","2042-05-01","2043-05-01","2044-05-01","2045-05-01","2046-05-01"]
["Victoire de 1945",{"$f":"DATE(B10,5,8)","v":"1980-05-08"},{"$f":"DATE(C10,5,8)","v":"1981-05-08"},"1982-05-08","1983-05-08","1984-05-08","1985-05-08","1986-05-08","1987-05-08","1988-05-08","1989-05-08","1990-05-08","1991-05-08","1992-05-08","1993-05-08","1994-05-08","1995-05-08","1996-05-08","1997-05-08","1998-05-08","1999-05-08","2000-05-08","2001-05-08","2002-05-08","2003-05-08","2004-05-08","2005-05-08","2006-05-08","2007-05-08","2008-05-08","2009-05-08","2010-05-08",{"$f":"DATE(AG10,5,8)","v":"2011-05-08"},"2012-05-08","2013-05-08","2014-05-08","2015-05-08","2016-05-08","2017-05-08","2018-05-08","2019-05-08","2020-05-08","2021-05-08","2022-05-08","2023-05-08","2024-05-08","2025-05-08","2026-05-08","2027-05-08","2028-05-08","2029-05-08","2030-05-08","2031-05-08","2032-05-08","2033-05-08","2034-05-08","2035-05-08","2036-05-08","2037-05-08","2038-05-08","2039-05-08","2040-05-08","2041-05-08","2042-05-08","2043-05-08","2044-05-08","2045-05-08","2046-05-08"]
["Ascension",{"$f":"B22+39","v":"1980-05-15"},"1981-05-28","1982-05-20","1983-05-12","1984-05-31","1985-05-16","1986-05-08","1987-05-28","1988-05-12","1989-05-04","1990-05-24","1991-05-09","1992-05-28","1993-05-20","1994-05-12","1995-05-25","1996-05-16","1997-05-08","1998-05-21","1999-05-13","2000-06-01","2001-05-24","2002-05-09","2003-05-29","2004-05-20","2005-05-05","2006-05-25","2007-05-17","2008-05-01","2009-05-21","2010-05-13",{"$f":"AG22+39","v":"2011-06-02"},"2012-05-17","2013-05-09","2014-05-29","2015-05-14","2016-05-05","2017-05-25","2018-05-10","2019-05-30","2020-05-21","2021-05-13","2022-05-26","2023-05-18","2024-05-09","2025-05-29","2026-05-14","2027-05-06","2028-05-25","2029-05-10","2030-05-30","2031-05-22","2032-05-06","2033-05-26","2034-05-18","2035-05-03","2036-05-22","2037-05-14","2038-06-03","2039-05-19","2040-05-10","2041-05-30","2042-05-15","2043-05-07","2044-05-26","2045-05-18","2046-05-03"]
["Pentecôte",{"$f":"B22+50","v":"1980-05-26"},"1981-06-08","1982-05-31","1983-05-23","1984-06-11","1985-05-27","1986-05-19","1987-06-08","1988-05-23","1989-05-15","1990-06-04","1991-05-20","1992-06-08","1993-05-31","1994-05-23","1995-06-05","1996-05-27","1997-05-19","1998-06-01","1999-05-24","2000-06-12","2001-06-04","2002-05-20","2003-06-09","2004-05-31","2005-05-16","2006-06-05","2007-05-28","2008-05-12","2009-06-01","2010-05-24",{"$f":"AG22+50","v":"2011-06-13"},"2012-05-28","2013-05-20","2014-06-09","2015-05-25","2016-05-16","2017-06-05","2018-05-21","2019-06-10","2020-06-01","2021-05-24","2022-06-06","2023-05-29","2024-05-20","2025-06-09","2026-05-25","2027-05-17","2028-06-05","2029-05-21","2030-06-10","2031-06-02","2032-05-17","2033-06-06","2034-05-29","2035-05-14","2036-06-02","2037-05-25","2038-06-14","2039-05-30","2040-05-21","2041-06-10","2042-05-26","2043-05-18","2044-06-06","2045-05-29","2046-05-14"]
["Fête nationale",{"$f":"DATE(B10,7,14)","v":"1980-07-14"},{"$f":"DATE(C10,7,14)","v":"1981-07-14"},"1982-07-14","1983-07-14","1984-07-14","1985-07-14","1986-07-14","1987-07-14","1988-07-14","1989-07-14","1990-07-14","1991-07-14","1992-07-14","1993-07-14","1994-07-14","1995-07-14","1996-07-14","1997-07-14","1998-07-14","1999-07-14","2000-07-14","2001-07-14","2002-07-14","2003-07-14","2004-07-14","2005-07-14","2006-07-14","2007-07-14","2008-07-14","2009-07-14","2010-07-14",{"$f":"DATE(AG10,7,14)","v":"2011-07-14"},"2012-07-14","2013-07-14","2014-07-14","2015-07-14","2016-07-14","2017-07-14","2018-07-14","2019-07-14","2020-07-14","2021-07-14","2022-07-14","2023-07-14","2024-07-14","2025-07-14","2026-07-14","2027-07-14","2028-07-14","2029-07-14","2030-07-14","2031-07-14","2032-07-14","2033-07-14","2034-07-14","2035-07-14","2036-07-14","2037-07-14","2038-07-14","2039-07-14","2040-07-14","2041-07-14","2042-07-14","2043-07-14","2044-07-14","2045-07-14","2046-07-14"]
["Assomption",{"$f":"DATE(B10,8,15)","v":"1980-08-15"},{"$f":"DATE(C10,8,15)","v":"1981-08-15"},"1982-08-15","1983-08-15","1984-08-15","1985-08-15","1986-08-15","1987-08-15","1988-08-15","1989-08-15","1990-08-15","1991-08-15","1992-08-15","1993-08-15","1994-08-15","1995-08-15","1996-08-15","1997-08-15","1998-08-15","1999-08-15","2000-08-15","2001-08-15","2002-08-15","2003-08-15","2004-08-15","2005-08-15","2006-08-15","2007-08-15","2008-08-15","2009-08-15","2010-08-15",{"$f":"DATE(AG10,8,15)","v":"2011-08-15"},"2012-08-15","2013-08-15","2014-08-15","2015-08-15","2016-08-15","2017-08-15","2018-08-15","2019-08-15","2020-08-15","2021-08-15","2022-08-15","2023-08-15","2024-08-15","2025-08-15","2026-08-15","2027-08-15","2028-08-15","2029-08-15","2030-08-15","2031-08-15","2032-08-15","2033-08-15","2034-08-15","2035-08-15","2036-08-15","2037-08-15","2038-08-15","2039-08-15","2040-08-15","2041-08-15","2042-08-15","2043-08-15","2044-08-15","2045-08-15","2046-08-15"]
["Toussaint",{"$f":"DATE(B10,11,1)","v":"1980-11-01"},{"$f":"DATE(C10,11,1)","v":"1981-11-01"},"1982-11-01","1983-11-01","1984-11-01","1985-11-01","1986-11-01","1987-11-01","1988-11-01","1989-11-01","1990-11-01","1991-11-01","1992-11-01","1993-11-01","1994-11-01","1995-11-01","1996-11-01","1997-11-01","1998-11-01","1999-11-01","2000-11-01","2001-11-01","2002-11-01","2003-11-01","2004-11-01","2005-11-01","2006-11-01","2007-11-01","2008-11-01","2009-11-01","2010-11-01",{"$f":"DATE(AG10,11,1)","v":"2011-11-01"},"2012-11-01","2013-11-01","2014-11-01","2015-11-01","2016-11-01","2017-11-01","2018-11-01","2019-11-01","2020-11-01","2021-11-01","2022-11-01","2023-11-01","2024-11-01","2025-11-01","2026-11-01","2027-11-01","2028-11-01","2029-11-01","2030-11-01","2031-11-01","2032-11-01","2033-11-01","2034-11-01","2035-11-01","2036-11-01","2037-11-01","2038-11-01","2039-11-01","2040-11-01","2041-11-01","2042-11-01","2043-11-01","2044-11-01","2045-11-01","2046-11-01"]
["Armistice",{"$f":"DATE(B10,11,11)","v":"1980-11-11"},{"$f":"DATE(C10,11,11)","v":"1981-11-11"},"1982-11-11","1983-11-11","1984-11-11","1985-11-11","1986-11-11","1987-11-11","1988-11-11","1989-11-11","1990-11-11","1991-11-11","1992-11-11","1993-11-11","1994-11-11","1995-11-11","1996-11-11","1997-11-11","1998-11-11","1999-11-11","2000-11-11","2001-11-11","2002-11-11","2003-11-11","2004-11-11","2005-11-11","2006-11-11","2007-11-11","2008-11-11","2009-11-11","2010-11-11",{"$f":"DATE(AG10,11,11)","v":"2011-11-11"},"2012-11-11","2013-11-11","2014-11-11","2015-11-11","2016-11-11","2017-11-11","2018-11-11","2019-11-11","2020-11-11","2021-11-11","2022-11-11","2023-11-11","2024-11-11","2025-11-11","2026-11-11","2027-11-11","2028-11-11","2029-11-11","2030-11-11","2031-11-11","2032-11-11","2033-11-11","2034-11-11","2035-11-11","2036-11-11","2037-11-11","2038-11-11","2039-11-11","2040-11-11","2041-11-11","2042-11-11","2043-11-11","2044-11-11","2045-11-11","2046-11-11"]
["Noël",{"$f":"DATE(B10,12,25)","v":"1980-12-25"},{"$f":"DATE(C10,12,25)","v":"1981-12-25"},"1982-12-25","1983-12-25","1984-12-25","1985-12-25","1986-12-25","1987-12-25","1988-12-25","1989-12-25","1990-12-25","1991-12-25","1992-12-25","1993-12-25","1994-12-25","1995-12-25","1996-12-25","1997-12-25","1998-12-25","1999-12-25","2000-12-25","2001-12-25","2002-12-25","2003-12-25","2004-12-25","2005-12-25","2006-12-25","2007-12-25","2008-12-25","2009-12-25","2010-12-25",{"$f":"DATE(AG10,12,25)","v":"2011-12-25"},"2012-12-25","2013-12-25","2014-12-25","2015-12-25","2016-12-25","2017-12-25","2018-12-25","2019-12-25","2020-12-25","2021-12-25","2022-12-25","2023-12-25","2024-12-25","2025-12-25","2026-12-25","2027-12-25","2028-12-25","2029-12-25","2030-12-25","2031-12-25","2032-12-25","2033-12-25","2034-12-25","2035-12-25","2036-12-25","2037-12-25","2038-12-25","2039-12-25","2040-12-25","2041-12-25","2042-12-25","2043-12-25","2044-12-25","2045-12-25","2046-12-25"]
["Pâques",{"$f":"DATE(B10,IF((25-MOD((11*MOD(B10-1900,19)+4-INT((7*MOD(B10-1900,19)+1)/19)),29)-MOD(B10-1900+INT((B10-1900)/4)+31-MOD((11*MOD(B10-1900,19)+4-INT((7*MOD(B10-1900,19)+1)/19)),29),7))>0,4,3),IF((25-MOD((11*MOD(B10-1900,19)+4-INT((7*MOD(B10-1900,19)+1)/19)),29)-MOD(B10-1900+INT((B10-1900)/4)+31-MOD((11*MOD(B10-1900,19)+4-INT((7*MOD(B10-1900,19)+1)/19)),29),7))>0,(25-MOD((11*MOD(B10-1900,19)+4-INT((7*MOD(B10-1900,19)+1)/19)),29)-MOD(B10-1900+INT((B10-1900)/4)+31-MOD((11*MOD(B10-1900,19)+4-INT((7*MOD(B10-1900,19)+1)/19)),29),7)),31+(25-MOD((11*MOD(B10-1900,19)+4-INT((7*MOD(B10-1900,19)+1)/19)),29)-MOD(B10-1900+INT((B10-1900)/4)+31-MOD((11*MOD(B10-1900,19)+4-INT((7*MOD(B10-1900,19)+1)/19)),29),7))))","v":"1980-04-06"},"1981-04-19","1982-04-11","1983-04-03","1984-04-22","1985-04-07","1986-03-30","1987-04-19","1988-04-03","1989-03-26","1990-04-15","1991-03-31","1992-04-19","1993-04-11","1994-04-03","1995-04-16","1996-04-07","1997-03-30","1998-04-12","1999-04-04","2000-04-23","2001-04-15","2002-03-31","2003-04-20","2004-04-11","2005-03-27","2006-04-16","2007-04-08","2008-03-23","2009-04-12","2010-04-04",{"$f":"DATE(AG10,IF((25-MOD((11*MOD(AG10-1900,19)+4-INT((7*MOD(AG10-1900,19)+1)/19)),29)-MOD(AG10-1900+INT((AG10-1900)/4)+31-MOD((11*MOD(AG10-1900,19)+4-INT((7*MOD(AG10-1900,19)+1)/19)),29),7))>0,4,3),IF((25-MOD((11*MOD(AG10-1900,19)+4-INT((7*MOD(AG10-1900,19)+1)/19)),29)-MOD(AG10-1900+INT((AG10-1900)/4)+31-MOD((11*MOD(AG10-1900,19)+4-INT((7*MOD(AG10-1900,19)+1)/19)),29),7))>0,(25-MOD((11*MOD(AG10-1900,19)+4-INT((7*MOD(AG10-1900,19)+1)/19)),29)-MOD(AG10-1900+INT((AG10-1900)/4)+31-MOD((11*MOD(AG10-1900,19)+4-INT((7*MOD(AG10-1900,19)+1)/19)),29),7)),31+(25-MOD((11*MOD(AG10-1900,19)+4-INT((7*MOD(AG10-1900,19)+1)/19)),29)-MOD(AG10-1900+INT((AG10-1900)/4)+31-MOD((11*MOD(AG10-1900,19)+4-INT((7*MOD(AG10-1900,19)+1)/19)),29),7))))","v":"2011-04-24"},"2012-04-08","2013-03-31","2014-04-20","2015-04-05","2016-03-27","2017-04-16","2018-04-01","2019-04-21","2020-04-12","2021-04-04","2022-04-17","2023-04-09","2024-03-31","2025-04-20","2026-04-05","2027-03-28","2028-04-16","2029-04-01","2030-04-21","2031-04-13","2032-03-28","2033-04-17","2034-04-09","2035-03-25","2036-04-13","2037-04-05","2038-04-25","2039-04-10","2040-04-01","2041-04-21","2042-04-06","2043-03-29","2044-04-17","2045-04-09","2046-03-25"]
[]
["Attention, la ligne de Pâques sert juste de référence pour situer ce jour dans l'année"]
[]
[]
["Ce qui donne quand on inclut les jours fériés (et a priori, la formule tient compte des jours non ouvrés) :"]
[]
["Date de début de carrière","Date de fin de carrière","Période de début temps partiel","Période de fin de temps partiel","Nb de jours ouvrés"]
["1980-02-01","2010-02-01",null,null,{"$f":"NETWORKDAYS(A30,B30,$B$11:$AF$21)","v":7567},"sur les trentes années entre 1980 et 2010"]
[]
[]
["Donc en prenant l'exemple d'un salarié lambda"]
[]
["Date de début de carrière","Date de fin de carrière","Période de début temps partiel","Période de fin de temps partiel","Nb de jours ouvrés","Nb de jours restants pour les 30 ans","Estimé en année"]
["1980-11-01","2010-02-01","1990-05-10","1990-12-31",{"$f":"NETWORKDAYS(A36,B36,$B$11:$AF$21)-NETWORKDAYS(C36,D36,$B$11:$AF$21)","v":7215},{"$f":"E30-E36","v":352},{"$f":"F36/365","v":0.96438356164383565}]
[]
[]
[]
[]
["En complément d'informations :"]
[]
["1. La date de début de calcul des jours fériés a été fixé à 1980, soit la date d'ancienneté du salarié exemple. Pour une table d'employés plus importantes, il conviendra de prendre comme date de départ la plus ancienne."]
["La table pourra se réajuster juste en faisant une copie incrémentée (+1 à chaque fois). Il est aussi possible de mettre cette table dans un autre onglet."]
["2. Je n'ai pas vérifié l'exactitude des dates de jours fériés remontés mais, a priori, cela semble correct."]
["3. Pour que le compteur de jours soit dynamique, la donnée dans la cellule de date de fin de carrière doit être en formule, soit =>",null,null,null,null,null,{"$f":"TODAY()","v":"2017-11-01"}]
["4. Dans le dernier exemple, un salarié qui aurait travaillé à temps partiel pendant quelques mois, voit son nombre de jours augmenter"]
["5. Pour le calcul soit exact, il faudra néanmoins le faire pour chacun, ce qui signifie que la table des jours fériés doit aller jusque 30 ans après l'entrée du dernier salarié."]