{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Planning","Feuil1","Feuil2","Outils","CdC"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Planning","index":0,"n_rows":47,"n_cols":367,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,50,0],[3,0,5,1],[1,0,2,1],[15,0,16,0],[18,0,20,0],[7,0,9,1],[22,0,23,0],[25,0,29,0],[31,0,40,0],[11,0,13,1],[6,0,6,1],[10,0,10,1]]}
[{"$f":"DATE(2022,1,1)","v":"2022-01-01"},"SEMAINE",{"$f":"_xlfn.ISOWEEKNUM(C3)","v":52},{"$f":"_xlfn.ISOWEEKNUM(D3)","v":52},1,1,1,1,1,1,1,2,2,2,2,2,2,2,3,3,3,3,3,3,3,4,4,4,4,4,4,4,5,5,5,5,5,5,5,6,6,6,6,6,6,6,7,7,7,7,7,7,7,8,8,8,8,8,8,8,9,9,9,9,9,9,9,{"$f":"_xlfn.ISOWEEKNUM(BP3)","v":10},10,10,10,10,10,10,11,11,11,11,11,11,11,12,12,12,12,12,12,12,13,13,13,13,13,13,13,14,14,14,14,14,14,14,15,15,15,15,15,15,15,16,16,16,16,16,16,16,17,17,17,17,17,17,17,18,18,18,18,18,18,18,19,{"$f":"_xlfn.ISOWEEKNUM(EB3)","v":19},19,19,19,19,19,20,20,20,20,20,20,20,21,21,21,21,21,21,21,22,22,22,22,22,22,22,23,23,23,23,23,23,23,24,24,24,24,24,24,24,25,25,25,25,25,25,25,26,26,26,26,26,26,26,27,27,27,27,27,27,27,28,28,{"$f":"_xlfn.ISOWEEKNUM(GN3)","v":28},28,28,28,28,29,29,29,29,29,29,29,30,30,30,30,30,30,30,31,31,31,31,31,31,31,32,32,32,32,32,32,32,33,33,33,33,33,33,33,34,34,34,34,34,34,34,35,35,35,35,35,35,35,36,36,36,36,36,36,36,37,37,37,{"$f":"_xlfn.ISOWEEKNUM(IZ3)","v":37},37,37,37,38,38,38,38,38,38,38,39,39,39,39,39,39,39,40,40,40,40,40,40,40,41,41,41,41,41,41,41,42,42,42,42,42,42,42,43,43,43,43,43,43,43,44,44,44,44,44,44,44,45,45,45,45,45,45,45,46,46,46,46,{"$f":"_xlfn.ISOWEEKNUM(LL3)","v":46},46,46,47,47,47,47,47,47,47,48,48,48,48,48,48,48,49,49,49,49,49,49,49,50,50,50,50,50,50,50,51,51,51,51,51,51,51,52,52,52,52,52,52]
["DATE",null,{"$f":"WEEKDAY(C$3)","v":"1900-01-07"},{"$f":"WEEKDAY(D$3)","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01",{"$f":"WEEKDAY(BP$3)","v":"1900-01-02"},"1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02",{"$f":"WEEKDAY(EB$3)","v":"1900-01-03"},"1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03",{"$f":"WEEKDAY(GN$3)","v":"1900-01-04"},"1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04",{"$f":"WEEKDAY(IZ$3)","v":"1900-01-05"},"1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05",{"$f":"WEEKDAY(LL$3)","v":"1900-01-06"},"1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07"]
[null,null,{"$f":"DATE(YEAR(A1),1,1)","v":"2022-01-01"},{"$f":"(C$3)+1","v":"2022-01-02"},{"$f":"(D$3)+1","v":"2022-01-03"},"2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09","2022-01-10","2022-01-11","2022-01-12","2022-01-13","2022-01-14","2022-01-15","2022-01-16","2022-01-17","2022-01-18","2022-01-19","2022-01-20","2022-01-21","2022-01-22","2022-01-23","2022-01-24","2022-01-25","2022-01-26","2022-01-27","2022-01-28","2022-01-29","2022-01-30","2022-01-31","2022-02-01","2022-02-02","2022-02-03","2022-02-04","2022-02-05","2022-02-06","2022-02-07","2022-02-08","2022-02-09","2022-02-10","2022-02-11","2022-02-12","2022-02-13","2022-02-14","2022-02-15","2022-02-16","2022-02-17","2022-02-18","2022-02-19","2022-02-20","2022-02-21","2022-02-22","2022-02-23","2022-02-24","2022-02-25","2022-02-26","2022-02-27","2022-02-28","2022-03-01","2022-03-02","2022-03-03","2022-03-04","2022-03-05","2022-03-06","2022-03-07",{"$f":"(BP$3)+1","v":"2022-03-08"},"2022-03-09","2022-03-10","2022-03-11","2022-03-12","2022-03-13","2022-03-14","2022-03-15","2022-03-16","2022-03-17","2022-03-18","2022-03-19","2022-03-20","2022-03-21","2022-03-22","2022-03-23","2022-03-24","2022-03-25","2022-03-26","2022-03-27","2022-03-28","2022-03-29","2022-03-30","2022-03-31","2022-04-01","2022-04-02","2022-04-03","2022-04-04","2022-04-05","2022-04-06","2022-04-07","2022-04-08","2022-04-09","2022-04-10","2022-04-11","2022-04-12","2022-04-13","2022-04-14","2022-04-15","2022-04-16","2022-04-17","2022-04-18","2022-04-19","2022-04-20","2022-04-21","2022-04-22","2022-04-23","2022-04-24","2022-04-25","2022-04-26","2022-04-27","2022-04-28","2022-04-29","2022-04-30","2022-05-01","2022-05-02","2022-05-03","2022-05-04","2022-05-05","2022-05-06","2022-05-07","2022-05-08","2022-05-09","2022-05-10",{"$f":"(EB$3)+1","v":"2022-05-11"},"2022-05-12","2022-05-13","2022-05-14","2022-05-15","2022-05-16","2022-05-17","2022-05-18","2022-05-19","2022-05-20","2022-05-21","2022-05-22","2022-05-23","2022-05-24","2022-05-25","2022-05-26","2022-05-27","2022-05-28","2022-05-29","2022-05-30","2022-05-31","2022-06-01","2022-06-02","2022-06-03","2022-06-04","2022-06-05","2022-06-06","2022-06-07","2022-06-08","2022-06-09","2022-06-10","2022-06-11","2022-06-12","2022-06-13","2022-06-14","2022-06-15","2022-06-16","2022-06-17","2022-06-18","2022-06-19","2022-06-20","2022-06-21","2022-06-22","2022-06-23","2022-06-24","2022-06-25","2022-06-26","2022-06-27","2022-06-28","2022-06-29","2022-06-30","2022-07-01","2022-07-02","2022-07-03","2022-07-04","2022-07-05","2022-07-06","2022-07-07","2022-07-08","2022-07-09","2022-07-10","2022-07-11","2022-07-12","2022-07-13",{"$f":"(GN$3)+1","v":"2022-07-14"},"2022-07-15","2022-07-16","2022-07-17","2022-07-18","2022-07-19","2022-07-20","2022-07-21","2022-07-22","2022-07-23","2022-07-24","2022-07-25","2022-07-26","2022-07-27","2022-07-28","2022-07-29","2022-07-30","2022-07-31","2022-08-01","2022-08-02","2022-08-03","2022-08-04","2022-08-05","2022-08-06","2022-08-07","2022-08-08","2022-08-09","2022-08-10","2022-08-11","2022-08-12","2022-08-13","2022-08-14","2022-08-15","2022-08-16","2022-08-17","2022-08-18","2022-08-19","2022-08-20","2022-08-21","2022-08-22","2022-08-23","2022-08-24","2022-08-25","2022-08-26","2022-08-27","2022-08-28","2022-08-29","2022-08-30","2022-08-31","2022-09-01","2022-09-02","2022-09-03","2022-09-04","2022-09-05","2022-09-06","2022-09-07","2022-09-08","2022-09-09","2022-09-10","2022-09-11","2022-09-12","2022-09-13","2022-09-14","2022-09-15",{"$f":"(IZ$3)+1","v":"2022-09-16"},"2022-09-17","2022-09-18","2022-09-19","2022-09-20","2022-09-21","2022-09-22","2022-09-23","2022-09-24","2022-09-25","2022-09-26","2022-09-27","2022-09-28","2022-09-29","2022-09-30","2022-10-01","2022-10-02","2022-10-03","2022-10-04","2022-10-05","2022-10-06","2022-10-07","2022-10-08","2022-10-09","2022-10-10","2022-10-11","2022-10-12","2022-10-13","2022-10-14","2022-10-15","2022-10-16","2022-10-17","2022-10-18","2022-10-19","2022-10-20","2022-10-21","2022-10-22","2022-10-23","2022-10-24","2022-10-25","2022-10-26","2022-10-27","2022-10-28","2022-10-29","2022-10-30","2022-10-31","2022-11-01","2022-11-02","2022-11-03","2022-11-04","2022-11-05","2022-11-06","2022-11-07","2022-11-08","2022-11-09","2022-11-10","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","2022-11-16","2022-11-17","2022-11-18",{"$f":"(LL$3)+1","v":"2022-11-19"},"2022-11-20","2022-11-21","2022-11-22","2022-11-23","2022-11-24","2022-11-25","2022-11-26","2022-11-27","2022-11-28","2022-11-29","2022-11-30","2022-12-01","2022-12-02","2022-12-03","2022-12-04","2022-12-05","2022-12-06","2022-12-07","2022-12-08","2022-12-09","2022-12-10","2022-12-11","2022-12-12","2022-12-13","2022-12-14","2022-12-15","2022-12-16","2022-12-17","2022-12-18","2022-12-19","2022-12-20","2022-12-21","2022-12-22","2022-12-23","2022-12-24","2022-12-25","2022-12-26","2022-12-27","2022-12-28","2022-12-29","2022-12-30","2022-12-31"]
["FORMATIONS"]
[null,null,null,null,null,null,null,"*"]
[]
["RÉUNION CCHPA / CHSCT"]
["SOUTIENS SANITAIRES",null,null,null,null,null,null,null,null,null,null,"*"]
[]
[null,null,null,null,null,null,"*"]
["STAND DE TIR B6"]
["ÉVÈNEMENTS DIVERS",null,null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[null,null,null,null,null,null,"*",null,"*"]
[]
[]
["MÉDECINS"]
[]
[]
["INFIRMIERS"]
[null,null,null,null,null,null,null,"*",null,null,null,null,null,null,null,null,null,"*",null,null,null,"*"]
[]
[]
["SECRÉTAIRES"]
[]
[]
["AUXILIAIRES\nSANITAIRES"]
[]
[]
[]
[]
[]
["RÉSERVISTES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PSYCHOLOGUE"]
[]
["STAGIAIRES"]
[]
["VÉHICULES"]

{"sheet":"Feuil1","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Remi2236"]
[null,null,null,"24 sept. 2021 à 13:17"]
[null,null,null,"Bonjour,"]
[]
[null,null,null,"Désolé j'ai été pas mal pris par le boulot. J'ai trouvé une alternative pour l'astreinte. J'ai fait en sorte que quand on clique sur astreinte, ça marque astreinte au titre et sur le commentaire."]
[]
[null,null,null,"En testant le tableau, je me suis dis que ça serait sympa de pouvoir changer la date de début et de fin de l'activité. J'ai rajouté des txt_box et et boutons de défilement sur l'Userform."]
[]
[null,null,null,"1/ J'aimerais que lorsque l'on clique sur l'un des rectangles pour le modifier, que la date de début et de fin de l'activité apparaisse dans les txt_box en haut de l'userform"]
[]
[null,null,null,"2/ Ensuite, j'aimerais qu'avec les boutons de défilement on puisse modifier la date inscrite dans les txt_box en ajoutant +1 à la date avec le bouton du haut, et -1 à la date avec le bouton du bas."]
[]
[null,null,null,"3/ De plus, j'aimerais que si l'on veut, on puisse inscrire directement la date au clavier dans les txt_box contenant la date."]
[]
[null,null,null,"4/ Enfin, que la date de fin ne puisse pas être antérieure à la date de début de l'activité, mais que les deux puissent être égales (ex : date début 21/09/2021 et date de fin 21/09/2021 mais que cela soit impossible de mettre en date de fin 19/09/2021 pour l'exemple, que cela affiche un message d'erreur si on le marque manuellement au clavier. Et que les boutons de défilement empêche de pouvoir le faire)."]
[]
[null,null,null,"Vous auriez une solution ?"]

{"sheet":"Feuil2","index":2,"n_rows":1,"n_cols":24,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]

{"sheet":"Outils","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["JOUR FÉRIÉ","DATE"]
["Jour de l'an","2022-01-01"]
["Vendredi saint","2022-04-15"]
["Lundi de Pâques","2022-04-18"]
["Fête du Travail","2022-05-01"]
["Victoire 1945","2022-05-08"]
["Ascension","2022-05-26"]
["Lundi de Pentecôte","2022-06-06"]
["Fête nationale","2022-07-14"]
["Assomption","2022-08-15"]
["Toussaint","2022-11-01"]
["Armistice 1918","2022-11-11"]
["Noël","2022-12-25"]
["Saint Etienne","2022-12-26"]

{"sheet":"CdC","index":4,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Insérer des formes dans un planning via un userform"]
[null,null,null,"Signaler"]
[null,null,null,"Remi2236 - 7 sept. 2021 à 20:43"]
[null,null,null,"Bonjour,"]
[]
[null,null,null,"Tout d'abord j'espère que vous vous portez bien. je viens demander votre aide. N'étant pas très doué sur VBA, j'ai fais un planning pour le travail où il y a des MFC pour les couleurs des week-ends notamment. Bref !"]
[]
[null,null,null,"Je cherche à faire en sorte que, en sélectionnant une plage de données, par exemple de A1 à A6 et en faisant clic droit, ça affiche mon Userform1."]
[]
[null,null,null,"Ensuite, sur cet userform1, il y a des boutons (congés, missions, divers...) et une case commentaire nommée \"Description de l’activé\". J'aimerais que quand je clique sur l'un de ces boutons et que je mets un commentaire, que cela affiche sur la plage de donnée initialement sélectionnée (A1 à A6 pour l'exemple) une forme rectangulaire (de la couleur des boutons sur le Userform1) comme dans l'exemple que je mets en pièce jointe, et que dessus apparaisse le commentaire mis sur l'Userform1."]
[]
[null,null,null,"Je ne sais pas si je suis clair ou non. Je vous mets le tableau que j'ai fait et le modèle que j'ai trouvé mais dont je ne comprends pas le fonctionnement...merci par avance !!!"]
[]
[null,null,null,"Mon planning :"]
[null,null,null,"https://www.cjoint.com/c/KIhsLAo80cT"]
[]
[null,null,null,"Exemple trouvé :"]
[null,null,null,"https://www.cjoint.com/c/KIhsMfVPjYT"]