{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","À propos"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Gantt","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["Créez un diagramme de Gantt dans cette feuille de calcul.\nEntrez le titre de ce projet dans la cellule B1. \nLe titre de la légende figure dans la cellule I1.\nDes informations sur l’utilisation de cette feuille de calcul, notamment des instructions pour les lecteurs d’écran et l’auteur de ce classeur, figurent dans la feuille de calcul À propos.\nContinuez à parcourir la colonne A pour entendre des instructions supplémentaires.","TITRE DU PROJET",{"$nulls":6},"Légende :"]
["Entrez le nom de la société dans la cellule B2.\nUne légende figure dans les cellules I2 à AC2.","Nom de la société",{"$nulls":6},"En bonne voie",{"$nulls":4},"Risque faible",{"$nulls":4},"Risque moyen",{"$nulls":4},"Risque élevé",{"$nulls":4},"Non attribué"]
["Entrez le nom du Responsable du projet dans la cellule B3. Entrez la date de début du projet dans la cellule F3, ou autorisez l’exemple de formule à rechercher la plus petite valeur de date dans le tableau de données du diagramme de Gantt.\nDate de début du projet : l’étiquette figure dans la cellule D3.","Responsable du projet",null,"Date de début du projet :",null,{"$f":"IFERROR(IF(MIN(Jalons[Début])=0,TODAY(),MIN(Jalons[Début])),TODAY())","v":"2018-07-07"}]
["Un incrément de défilement figure dans la cellule F4. \nLes mois des dates dans la ligne 5 s’affichent dans les cellules I4 à BL4.\nNe modifiez pas ces cellules. Elles sont mises à jour automatiquement en fonction de la date de début du projet figurant dans la cellule F3.",null,null,"Incrément de défilement :",null,0,null,null,{"$f":"TEXT(I5,\"mmmm\")","v":"July"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"mmmm\")=I4,\"\",TEXT(P5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"mmmm\")=P4,TEXT(W5,\"mmmm\")=I4),\"\",TEXT(W5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"mmmm\")=W4,TEXT(AD5,\"mmmm\")=P4,TEXT(AD5,\"mmmm\")=I4),\"\",TEXT(AD5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"mmmm\")=AD4,TEXT(AK5,\"mmmm\")=W4,TEXT(AK5,\"mmmm\")=P4,TEXT(AK5,\"mmmm\")=I4),\"\",TEXT(AK5,\"mmmm\"))","v":"August"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"mmmm\")=AK4,TEXT(AR5,\"mmmm\")=AD4,TEXT(AR5,\"mmmm\")=W4,TEXT(AR5,\"mmmm\")=P4),\"\",TEXT(AR5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"mmmm\")=AR4,TEXT(AY5,\"mmmm\")=AK4,TEXT(AY5,\"mmmm\")=AD4,TEXT(AY5,\"mmmm\")=W4),\"\",TEXT(AY5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"mmmm\")=AY4,TEXT(BF5,\"mmmm\")=AR4,TEXT(BF5,\"mmmm\")=AK4,TEXT(BF5,\"mmmm\")=AD4),\"\",TEXT(BF5,\"mmmm\"))","v":""}]
["Les cellules I5 à BL5 contiennent les numéros de jour du mois représenté dans le bloc de cellules au-dessus de chaque cellule de date. Leurs valeurs sont calculées automatiquement.\nNe modifiez pas ces cellules.\nLa date du jour est entourée de rouge (hex #AD3815), depuis la date du jour dans la ligne 5 jusqu’à la colonne de date entière à la fin du planning de projet.",{"$nulls":7},{"$f":"IFERROR(Début_Projet+Incrément_Défilement,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["Une barre de défilement figure dans les cellules I6 à BL6. L’incrément de pagination dans les données est défini sur 2 pages à la fois. Il est possible de le configurer dans les paramètres de la barre de contrôle. \nPour avancer ou reculer dans la chronologie, entrez une valeur égale ou supérieure à 0 dans la cellule F4.\nLa valeur 0 vous permet d’accéder au début du graphique."]
["Cette ligne contient des en-têtes pour le planning de projet figurant sous ceux-ci. \nNaviguez des cellules B7 à BL7 pour entendre l’énoncé du contenu. Première lettre de chaque jour de la semaine pour la date figurant au-dessus de cet en-tête. Commence dans la cellule I7, et continue jusqu’à la cellule BL7.\nLe diagramme entier de chronologie du projet est généré automatiquement en fonction de la catégorie, de la date de début et du nombre de jours entré dans le tableau Jalons.","Description du jalon","Catégorie","Assigné à","Avancement","Début","Nombre de jours",null,{"$f":"LEFT(TEXT(I5,\"jjj\"),1)","v":"j"},"j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j",{"$f":"LEFT(TEXT(AO5,\"jjj\"),1)","v":"j"},"j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j","j"]
["Ne supprimez pas cette ligne. Cette ligne est masquée afin de préserver une formule utilisée pour mettre en évidence le jour en cours au sein du planning de projet. "]
["Entrez les informations du projet des cellules B9 à G9. \nLes cellules B9 à G33 contiennent les exemples de données.\nEntrez la description du jalon, sélectionnez une catégorie dans la liste déroulante, affectez une personne à l’élément, entrez l’avancement, la date de début et le nombre de jours pour la tâche pour démarrer la génération du diagramme.\nL’instruction suivante figure dans la cellule A34.","Titre 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Objectif\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Jalon\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Objectif\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Jalon\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Objectif\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Jalon\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Objectif\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Jalon\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Tâche 1","Objectif","Nom",{"v":0.25,"d":"25 %"},{"$f":"TODAY()","v":"2018-09-19"},3,null,{"$f":"IF(AND($C10=\"Objectif\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Jalon\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 2","Jalon",null,null,{"$f":"TODAY()+5","v":"2018-09-24"},1,null,{"$f":"IF(AND($C11=\"Objectif\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Jalon\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 3","Risque faible",null,{"v":0.5,"d":"50 %"},{"$f":"F10-3","v":"2018-09-16"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 4","Jalon",null,null,{"$f":"F10+20","v":"2018-10-09"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 5","Risque moyen",null,{"v":0.1,"d":"10 %"},{"$f":"F10+6","v":"2018-09-25"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titre 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 1","Risque élevé",null,{"v":0.6,"d":"60 %"},{"$f":"F10+6","v":"2018-09-25"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 2","En bonne voie",null,{"v":0.5,"d":"50 %"},{"$f":"F16+2","v":"2018-09-27"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 3","Risque faible",null,{"v":0.33,"d":"33 %"},{"$f":"F17+5","v":"2018-10-02"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 4","Jalon",null,null,{"$f":"F18+2","v":"2018-10-04"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 5",{"$nulls":3},{"$f":"F19+1","v":"2018-10-05"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titre 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 1","En bonne voie",null,null,{"$f":"F10+15","v":"2018-10-04"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 2","Risque moyen",null,null,{"$f":"F22+3","v":"2018-10-07"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 3","En bonne voie",null,null,{"$f":"F23+15","v":"2018-10-22"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Objectif\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Jalon\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Objectif\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Jalon\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Tâche 4","Objectif",null,null,{"$f":"F19+22","v":"2018-10-26"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Objectif\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Jalon\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 5","Risque faible",null,null,{"$f":"F14","v":"2018-09-25"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Titre 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Objectif\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Jalon\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 1",{"$nulls":3},{"$f":"F25+3","v":"2018-10-29"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 3","Jalon",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Tâche 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Il s’agit d’une ligne vide",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Cette ligne marque la fin des données de jalons du diagramme de Gantt. N’ENTREZ RIEN dans cette ligne. \nPour ajouter des éléments, insérez des lignes au-dessus de celle-ci.","Pour ajouter des données, insérez des lignes AU-DESSUS de celle-ci."]

{"sheet":"À propos","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["À propos de ce modèle"]
["Ce modèle fournit un moyen simple de créer un diagramme de Gantt pour vous aider à visualiser et à suivre votre projet. Entrez simplement la description de vos tâches, sélectionnez une catégorie (Objectif, Jalon, En bonne voie, Risque faible, Risque moyen, Risque élevé, Avancement en tant que pourcentage d’accomplissement de la tâche), une date de début et le nombre de jours pour accomplir la tâche. Le diagramme de Gantt prend forme et utilise un codage couleur pour faciliter la distinction des différentes catégories. Une barre de défilement vous permet de parcourir la chronologie. Insérez des tâches en insérant des lignes.\n"]
["Instructions pour les lecteurs d’écran"]
["Ce classeur contient deux feuilles de calcul. \n\nDiagramme de Gantt\nÀ propos\n\nLes instructions relatives à chaque feuille de calcul figurent dans la colonne A à partir de la cellule A1. Elles sont rédigées en texte masqué. Chaque étape vous explique comment utiliser les informations décrites dans la ligne. Les étapes suivantes sont décrites dans les cellules A2, A3, etc. sauf mention contraire. Par exemple, l’instruction peut indiquer de « consulter la cellule A6 » pour l’étape suivante. \n\nCe texte masqué n’est pas imprimé.\n\nPour supprimer ces instructions de la feuille de calcul, supprimez simplement la colonne A."]
["Ceci est la dernière instruction de cette feuille de calcul."]