{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Page 1 - PlanningAgent","Page 2 Détail calcul"],"not_rendered":{"external_links":2,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Page 1 - PlanningAgent","index":0,"n_rows":83,"n_cols":24,"rows_kept":83,"merged":[[0,0,0,23],[1,0,1,4],[1,5,1,15],[1,16,1,20],[1,21,1,23],[1,24,2,25],[1,26,2,27],[2,0,2,4],[2,5,2,15],[2,16,2,20],[2,21,2,23],[4,0,4,23],[8,0,8,3],[8,4,8,7],[8,8,8,11],[8,12,8,15],[8,16,8,19],[8,20,8,23],[9,2,9,3],[9,18,9,19],[14,14,14,15],[16,18,16,19],[22,18,22,19],[33,18,33,19],[37,6,37,7],[38,6,38,7],[39,6,39,7],[39,14,39,15],[39,22,39,23],[40,13,40,23],[41,2,41,12],[43,2,43,12],[43,14,43,15],[45,0,45,3],[45,4,45,7],[45,8,45,11],[45,12,45,15],[45,16,45,19],[45,20,45,23],[46,18,46,19],[56,18,56,19],[59,2,59,3],[60,6,60,7],[70,22,70,23],[77,13,77,23],[78,2,78,12],[78,15,78,23],[80,2,80,12],[80,14,80,15],[82,0,82,7],[82,10,82,14],[82,21,82,23]],"flags":["formulas_cached_only"]}
["ANNEE CIVILE 2026\n(Aucun texte réglementaire ne prévoit le calcul de l’annualisation du temps\n de travail des agents tant à temps complet qu’à temps non complet.)\n"]
["NOM DE LA COLLECTIVITE :",{"$nulls":15},"DATE DE DEBUT DE \nLA PERIODE D'EMPLOI :",{"$nulls":4},"2026-01-01"]
["NOM ET PRENOM DE L'AGENT:",{"$nulls":15},"DATE DE FIN DE LA \nPERIODE D'EMPLOI :",{"$nulls":4},"2026-12-31"]
[]
["Complétez ce calendrier en indiquant des valeurs décimales (ex : si l'agent travaille 7h15min par jour, inscrire 7.25 h). Vous obtiendrez en bas du document le nombre d'heures effectuées dans l'année et la durée hebdomadaire de service à retenir. ATTENTION : seuls les jours réellement travaillés dans la période du contrat de travail doivent être indiqués."]
[]
[]
[]
["JANVIER",{"$nulls":3},"FEVRIER",{"$nulls":3},"MARS",{"$nulls":3},"AVRIL",{"$nulls":3},"MAI",{"$nulls":3},"JUIN"]
["jeudi",1,"FERIE",null,"dimanche",1,null,"h","dimanche",1,null,"h","mercredi",1,null,"h","vendredi",1,"FERIE",null,"lundi",1,null,"h"]
["vendredi",2,null,"h","lundi",2,null,"h","lundi",2,null,"h","jeudi",2,null,"h","samedi",2,null,"h","mardi",2,null,"h"]
["samedi",3,null,"h","mardi",3,null,"h","mardi",3,null,"h","vendredi",3,null,"h","dimanche",3,null,"h","mercredi",3,null,"h"]
["dimanche",4,null,"h","mercredi",4,null,"h","mercredi",4,null,"h","samedi",4,null,"h","lundi",4,null,"h","jeudi",4,null,"h"]
["lundi",5,null,"h","jeudi",5,null,"h","jeudi",5,null,"h","dimanche",5,null,"h","mardi",5,null,"h","vendredi",5,null,"h"]
["mardi",6,null,"h","vendredi",6,null,"h","vendredi",6,null,"h","lundi",6,"FERIE",null,"mercredi",6,null,"h","samedi",6,null,"h"]
["mercredi",7,null,"h","samedi",7,null,"h","samedi",7,null,"h","mardi",7,null,"h","jeudi",7,null,"h","dimanche",7,null,"h"]
["jeudi",8,null,"h","dimanche",8,null,"h","dimanche",8,null,"h","mercredi",8,null,"h","vendredi",8,"FERIE",null,"lundi",8,null,"h"]
["vendredi",9,null,"h","lundi",10,null,"h","lundi",9,null,"h","jeudi",9,null,"h","samedi",9,null,"h","mardi",9,null,"h"]
["samedi",10,null,"h","mardi",11,null,"h","mardi",10,null,"h","vendredi",10,null,"h","dimanche",10,null,"h","mercredi",10,null,"h"]
["dimanche",11,null,"h","mercredi",11,null,"h","mercredi",11,null,"h","samedi",11,null,"h","lundi",11,null,"h","jeudi",11,null,"h"]
["lundi",12,null,"h","jeudi",12,null,"h","jeudi",12,null,"h","dimanche",12,null,"h","mardi",12,null,"h","vendredi",12,null,"h"]
["mardi",13,null,"h","vendredi",13,null,"h","vendredi",13,null,"h","lundi",13,null,"h","mercredi",13,null,"h","samedi",13,null,"h"]
["mercredi",14,null,"h","samedi",14,null,"h","samedi",14,null,"h","mardi",14,null,"h","jeudi",14,"FERIE",null,"dimanche",14,null,"h"]
["jeudi",15,null,"h","dimanche",15,null,"h","dimanche",15,null,"h","mercredi",15,null,"h","vendredi",15,null,"h","lundi",15,null,"h"]
["vendredi",16,null,"h","lundi",16,null,"h","lundi",16,null,"h","jeudi",16,null,"h","samedi",16,null,"h","mardi",16,null,"h"]
["samedi",17,null,"h","mardi",17,null,"h","mardi",17,null,"h","vendredi",17,null,"h","dimanche",17,null,"h","mercredi",17,null,"h"]
["dimanche",18,null,"h","mercredi",18,null,"h","mercredi",18,null,"h","samedi",18,null,"h","lundi",18,null,"h","jeudi",18,null,"h"]
["lundi",19,null,"h","jeudi",19,null,"h","jeudi",19,null,"h","dimanche",19,null,"h","mardi",19,null,"h","vendredi",19,null,"h"]
["mardi",20,null,"h","vendredi",20,null,"h","vendredi",20,null,"h","lundi",20,null,"h","mercredi",20,null,"h","samedi",20,null,"h"]
["mercredi",21,null,"h","samedi",21,null,"h","samedi",21,null,"h","mardi",21,null,"h","jeudi",21,null,"h","dimanche",21,null,"h"]
["jeudi",22,null,"h","dimanche",22,null,"h","dimanche",22,null,"h","mercredi",22,null,"h","vendredi",22,null,"h","lundi",22,null,"h"]
["vendredi",23,null,"h","lundi",23,null,"h","lundi",23,null,"h","jeudi",23,null,"h","samedi",23,null,"h","mardi",23,null,"h"]
["samedi",24,null,"h","mardi",24,null,"h","mardi",24,null,"h","vendredi",24,null,"h","dimanche",24,null,"h","mercredi",24,null,"h"]
["dimanche",25,null,"h","mercredi",25,null,"h","mercredi",25,null,"h","samedi",25,null,"h","lundi",25,"FERIE",null,"jeudi",25,null,"h"]
["lundi",26,null,"h","jeudi",26,null,"h","jeudi",26,null,"h","dimanche",26,null,"h","mardi",26,null,"h","vendredi",26,null,"h"]
["mardi",27,null,"h","vendredi",27,null,"h","vendredi",27,null,"h","lundi",27,null,"h","mercredi",27,null,"h","samedi",27,null,"h"]
["mercredi",28,null,"h","samedi",28,null,"h","samedi",28,null,"h","mardi",28,null,"h","jeudi",28,null,"h","dimanche",28,null,"h"]
["jeudi",29,null,"h",{"$nulls":4},"dimanche",29,null,"h","mercredi",29,null,"h","vendredi",29,null,"h","lundi",29,null,"h"]
["vendredi",30,null,"h",{"$nulls":4},"lundi",30,null,"h","jeudi",30,null,"h","samedi",30,null,"h","mardi",30,null,"h"]
["samedi",31,null,"h",{"$nulls":4},"mardi",31,null,"h",{"$nulls":4},"dimanche",31,null,"h"]
[{"$nulls":13},"N.B. : ce planning est construit à partir du calendrier national."]
[null,null,"vacances scolaires / jours férié"]
[]
[null,null,"Week end"]
[]
["JUILLET",{"$nulls":3},"AOUT",{"$nulls":3},"SEPTEMBRE",{"$nulls":3},"OCTOBRE",{"$nulls":3},"NOVEMBRE",{"$nulls":3},"DECEMBRE"]
["mercredi",1,null,"h","samedi",1,null,"h","mardi",1,null,"h","jeudi",1,null,"h","dimanche",1,"FERIE",null,"mardi",1,null,"h"]
["jeudi",2,null,"h","dimanche",2,null,"h","mercredi",2,null,"h","vendredi",2,null,"h","lundi",2,null,"h","mercredi",2,null,"h"]
["vendredi",3,null,"h","lundi",3,null,"h","jeudi",3,null,"h","samedi",3,null,"h","mardi",3,null,"h","jeudi",3,null,"h"]
["samedi",4,null,"h","mardi",4,null,"h","vendredi",4,null,"h","dimanche",4,null,"h","mercredi",4,null,"h","vendredi",4,null,"h"]
["dimanche",5,null,"h","mercredi",5,null,"h","samedi",5,null,"h","lundi",5,null,"h","jeudi",5,null,"h","samedi",5,null,"h"]
["lundi",6,null,"h","jeudi",6,null,"h","dimanche",6,null,"h","mardi",6,null,"h","vendredi",6,null,"h","dimanche",6,null,"h"]
["mardi",7,null,"h","vendredi",7,null,"h","lundi",7,null,"h","mercredi",7,null,"h","samedi",7,null,"h","lundi",7,null,"h"]
["mercredi",8,null,"h","samedi",8,null,"h","mardi",8,null,"h","jeudi",8,null,"h","dimanche",8,null,"h","mardi",8,null,"h"]
["jeudi",9,null,"h","dimanche",9,null,"h","mercredi",9,null,"h","vendredi",9,null,"h","lundi",9,null,"h","mercredi",9,null,"h"]
["vendredi",10,null,"h","lundi",10,null,"h","jeudi",10,null,"h","samedi",10,null,"h","mardi",10,null,"h","jeudi",10,null,"h"]
["samedi",11,null,"h","mardi",11,null,"h","vendredi",11,null,"h","dimanche",11,null,"h","mercredi",11,"FERIE",null,"vendredi",11,null,"h"]
["dimanche",12,null,"h","mercredi",12,null,"h","samedi",12,null,"h","lundi",12,null,"h","jeudi",12,null,"h","samedi",12,null,"h"]
["lundi",13,null,"h","jeudi",13,null,"h","dimanche",13,null,"h","mardi",13,null,"h","vendredi",13,null,"h","dimanche",13,null,"h"]
["mardi",14,"FERIE",null,"vendredi",14,null,"h","lundi",14,null,"h","mercredi",14,null,"h","samedi",14,null,"h","lundi",14,null,"h"]
["mercredi",15,null,"h","samedi",15,"FERIE",null,"mardi",15,null,"h","jeudi",15,null,"h","dimanche",15,null,"h","mardi",15,null,"h"]
["jeudi",16,null,"h","dimanche",16,null,"h","mercredi",16,null,"h","vendredi",16,null,"h","lundi",16,null,"h","mercredi",16,null,"h"]
["vendredi",17,null,"h","lundi",17,null,"h","jeudi",17,null,"h","samedi",17,null,"h","mardi",17,null,"h","jeudi",17,null,"h"]
["samedi",18,null,"h","mardi",18,null,"h","vendredi",18,null,"h","dimanche",18,null,"h","mercredi",18,null,"h","vendredi",18,null,"h"]
["dimanche",19,null,"h","mercredi",19,null,"h","samedi",19,null,"h","lundi",19,null,"h","jeudi",19,null,"h","samedi",19,null,"h"]
["lundi",20,null,"h","jeudi",20,null,"h","dimanche",20,null,"h","mardi",20,null,"h","vendredi",20,null,"h","dimanche",20,null,"h"]
["mardi",21,null,"h","vendredi",21,null,"h","lundi",21,null,"h","mercredi",21,null,"h","samedi",21,null,"h","lundi",21,null,"h"]
["mercredi",22,null,"h","samedi",22,null,"h","mardi",22,null,"h","jeudi",22,null,"h","dimanche",22,null,"h","mardi",22,null,"h"]
["jeudi",23,null,"h","dimanche",23,null,"h","mercredi",23,null,"h","vendredi",23,null,"h","lundi",23,null,"h","mercredi",23,null,"h"]
["vendredi",24,null,"h","lundi",24,null,"h","jeudi",24,null,"h","samedi",24,null,"h","mardi",24,null,"h","jeudi",24,null,"h"]
["samedi",25,null,"h","mardi",25,null,"h","vendredi",25,null,"h","dimanche",25,null,"h","mercredi",25,null,"h","vendredi",25,"FERIE"]
["dimanche",26,null,"h","mercredi",26,null,"h","samedi",26,null,"h","lundi",26,null,"h","jeudi",26,null,"h","samedi",26,null,"h"]
["lundi",27,null,"h","jeudi",27,null,"h","dimanche",27,null,"h","mardi",27,null,"h","vendredi",27,null,"h","dimanche",27,null,"h"]
["mardi",28,null,"h","vendredi",28,null,"h","lundi",28,null,"h","mercredi",28,null,"h","samedi",28,null,"h","lundi",28,null,"h"]
["mercredi",29,null,"h","samedi",29,null,"h","mardi",29,null,"h","jeudi",29,null,"h","dimanche",29,null,"h","mardi",29,null,"h"]
["jeudi",30,null,"h","dimanche",30,null,"h","mercredi",30,null,"h","vendredi",30,null,"h","lundi",30,null,"h","mercredi",30,null,"h"]
["vendredi",31,null,"h","lundi",31,null,"h",{"$nulls":4},"samedi",31,null,"h",{"$nulls":4},"jeudi",31,null,"h"]
[{"$nulls":13},"N.B. : ce planning est construit à partir du calendrier national."]
[null,null,"vacances scolaires / jours férié"]
[]
[null,null,"Week end"]
[]
["Nombre d'heures de travail effectuées sur la période :",{"$nulls":7},{"v":0,"d":"0.00"},"h"]

{"sheet":"Page 2 Détail calcul","index":1,"n_rows":70,"n_cols":16,"rows_kept":70,"merged":[[1,0,8,9],[10,0,12,9],[14,0,14,2],[21,0,21,6],[21,8,21,9],[22,0,22,6],[24,0,24,4],[25,2,25,4],[25,6,25,7],[26,2,26,4],[26,6,26,7],[30,0,30,2],[32,2,32,3],[32,5,32,6],[32,8,32,9],[36,0,36,3],[38,2,38,5],[39,2,39,5],[39,11,39,12],[41,7,41,8],[43,0,43,1],[43,5,43,6],[50,0,50,1],[51,0,60,9],[62,0,62,4],[63,1,63,6],[64,1,64,6],[65,1,65,6],[66,1,66,6],[67,1,67,9],[68,1,68,9],[69,1,69,9]],"flags":["formulas_cached_only"]}
["REFERENCES DE CALCUL :"]
["Un agent à temps complet :\n-> doit effectuer 1 600 heures de travail dans l'année + 7 heures pour la journée de solidarité\n-> est payé 1 820 heures par an (35Heures x52 semaines)\n-> est payé 151,67 heures par mois\n-> est payé 35 heures par semaine"]
{"$rows_empty":8}
["*Il faut bien faire une différence entre le nombre d’heures de travail effectif annuel soit 1607 heures et la durée d’heures annuelles rémunérées, 1820. Cela résulte de la somme des congés annuels et du forfait de jours fériés ( 365 - 104 jous de WE - 25 jours CA- 8 jours fériés)"]
[]
[]
[]
["Calcul de la durée du contrat :",{"$nulls":10},"Jour début de contrat",1,null,"Jour fin de contrat",31]
[{"$nulls":11},"Mois début de contrat",1,null,"Mois fin de contrat",12]
[null,null,"Date de début du contrat :",null,null,"2026-01-01",{"$nulls":5},"Année début de contrat",2026,null,"Année fin de contrat",2026]
[null,null,"Date de fin du contrat :",null,null,"2026-12-31"]
[{"$nulls":11},"Nombre de jours du premier mois",30,null,"Nombre de jours sur les autres mois",300]
[null,null,"Durée du contrat (en mois)",null,null,{"v":12,"d":"12.00"},{"$nulls":5},"Nombre de jours du dernier mois",30]
[]
["Nombre d'heures de travail effectuées sur la période (voir le résultat de la page 1) :",{"$nulls":6},{"v":0,"d":"0.00"},"heures"]
["Nombre d'heures de travail à effectuer sur la période de contrat au titre de la journée de solidarité :",{"$nulls":6},{"v":0,"d":"0.00"}]
["Nombre d'heures à effectuer sur la période",{"$nulls":6},{"v":0,"d":"0.00"}]
["Nombre d'heures de travail payées sur la période :"]
[null,{"v":1607,"d":"1,607"},"heures faites correspondent à ",null,null,{"v":1820,"d":"1,820"},"heures payées"]
[null,{"v":0,"d":"0.00"},"heures faites correspondent à ",null,null,{"v":0,"d":"0.00"},"heures payées"]
[]
[{"$nulls":5},{"v":0,"d":"0.00"},"x 1820 / 1607"]
[]
["Nombre d'heures payées par mois :"]
[]
[null,{"v":0,"d":"0.00"},"heures payées sur",null,{"v":12,"d":"12.00"},"mois correspondent à ",null,{"v":0,"d":"0.00"},"heures payées par mois"]
[]
[{"$nulls":7},{"v":0,"d":"0.00"},"∕",{"v":12,"d":"12.00"}]
[]
["Nombre d'heures payées par semaine :"]
[]
[null,151.67,"heures payées par mois correspondent à ",{"$nulls":3},{"v":35,"d":"35.00"},"heures payées par semaine",{"$nulls":3},"Valeur entière DHS",null,0]
[null,{"v":0,"d":"0.00"},"heures payées par mois correspondent à ",{"$nulls":3},{"v":0,"d":"0.00"},"heures payées par semaine",{"$nulls":3},"Valeur décimale convertie en minutes",null,0]
[]
[{"$nulls":6},{"v":0,"d":"0.00"}," x 35 / 151,67"]
[]
["CONCLUSION :"]
[]
["La durée hebdomadaire à retenir (qui sera indiquée sur l'acte d'engagement et servira pour la paie) est égale à  :"]
[]
[null,{"v":0,"d":"0.00"},"heures/semaine soit :",null,0,"heures",0,"minutes"]
[]
[]
["ATTENTION :"]
["Si vous utilisez ce simulateur, le calcul d'annualisation doit être fait tous les ans, mais conduit à deux hypothèses :\n\n- soit le temps de travail de l'agent sera ajusté tous les ans. Si le planning de l'agent ne lui permet pas une année de réaliser son temps de travail, il faudra rajouter du temps, par exemple aux vacances scolaires. Si le planning de l'agent le conduit à réaliser plus que ce qu'il devrait, alors soit la collectivité lui ote quelques jours de travail soit elle lui rémunére les quelques heures en heures complémentaires/supplémentaires.\nExemple : si l'agent est nommé sur un poste à 27h17 minutes en 2022/2023 (1252.46 heures à effectuer ) et que pour la rentrée scolaire 2023/2024, l'agent devra effectuer réellement  1260 heures, alors l'agent devra à la collectivité 7,54 heures que la collectivité devra caler dans son planning. Par contre, si pour l'année scolaire 2024/2025 l'agent ne doit effectuer que 1250 heures, alors la collectivité soit donnera 2,56 heures en récupération à l'agent soit paiera 2,56 heures complémentaires.\n\n- soit la collectivité considère qu'en fonction du nombre de jours travaillés chaque année, un \"lissage du nombre d'heures\" se fait d'une année sur l'autre. Aussi, si l'agent travaille quelques heures en moins sur une année, il est considéré qu'il travaillera quelques heures en plus une autre année."]
{"$rows_empty":10}
["En résumé voici les étapes à suivre pour utiliser ce simulateur :"]
[1,"entrer la date de début et la date de fin de contrat"]
[2,"saisir les heures planifiées sur la période de contrat de travail ( jour par jour)"]
[3,"le total des heures à effectuer apparait en cellule I 83 de la page 1"]
[4,"En page 2, différents calculs sont automatiquement effectués"]
[5,"le nombre d'heures au titre de la journée de solidarité est calculé (il conviendra de demander à l'agent de réaliser ces heures en plus de celles arrêtées dans le planning)"]
[6,"la durée hebdomadaire à payer apparait en cellule G40"]
[7,"Il n'y a pas lieu de payer en plus les jours fériés et les congés annuels qui ont été intégrés en référence aux 1607 heures"]