{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Planning","Outils","CdC"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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,null,"*",null,null,null,null,null,"*"]
["RÉUNION CCHPA / CHSCT",null,null,null,null,null,null,"*"]
["SOUTIENS SANITAIRES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[]
[]
["STAND DE TIR B6",null,null,null,null,null,null,null,"*",null,null,null,null,null,"*",null,null,null,null,null,"*"]
["ÉVÈNEMENTS DIVERS"]
[]
[]
[]
["MÉDECINS"]
[]
[]
["INFIRMIERS"]
[]
[]
[]
["SECRÉTAIRES"]
[]
[]
["AUXILIAIRES\nSANITAIRES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[]
[]
[]
[]
["RÉSERVISTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PSYCHOLOGUE"]
[]
["STAGIAIRES"]
[]
["VÉHICULES"]

{"sheet":"Outils","index":1,"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":2,"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"]