{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Lexique","Informations générales","Planning","Budget","Registre des risques","Résultats","Changement","Réunions","Matrice de responsabilités"],"not_rendered":{"charts":10,"images":0,"macros":1,"external_links":1,"defined_names":54,"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":"Lexique","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,2,1]]}
[]
[]
["BREF LEXIQUE DE LA GESTION DE PROJET"]
[]
["BUDGET","Liste générale des dépenses prévues."]
["CHEF-FE DE PROJET","Personne chargée de la planification et de l'exécution d'un projet et de la direction d'une équipe de projet. "]
["CHANGEMENT DE PÉRIMÈTRE","Ceci fait référence à la façon dont le périmètre d'un projet peut changer au fil du temps et dépasser les paramètres initiaux (objectifs, livrables, ressources). Dans ce cas, il y a un risque de trop dépenser ou de ne pas respecter les délais. \nToute réévaluation majeure du périmètre du projet doit être validée par le-la mandant-e / CoPil. \nUne fois validé, il faut mettre à jour le budget, le planning et les ressources afin que ces derniers soient cohérents avec le nouveau périmètre de projet."]
["EQUIPE DE PROJET","L'organisation de projet est une organisation temporaire qui est en étroite relation avec l'organisation permanente. Elle entre en fonction avec le mandat d'initialisation du projet et est dissoute avec la décision de clore le projet.\nL'organisation de projet se compose de différents rôles (mandant, chef de projet, spécialiste.s) qui règlent les tâches, les compétences et les responsabilités des participant.e.s"]
["INDICATEURS","Indicateurs mesurables de l'état d'avancement du projet, déterminés avant le début du projet.\nEx. Avons-nous atteint 10 000 vues aujourd'hui ? Réalisé 50 appels de vente cette semaine ? Améliorer le temps de résolution des problèmes client-e-s ? \nLes indicateurs permettent de suivre le cheminement du projet et, si nécessaire, de le remettre sur la bonne voie."]
["JALON","n jalon marque le début et la fin de chaque phase du projet. Les jalons sont le résultat de tâches de décision.  les décisions reviennent aux niveaux hiérarchiques du pilotage, de la conduite et de l'exécution. "]
["MANDANT.-E","Responsable de la réussite du projet et de l'atteinte des objectifs dans le cadre des coûts et délais fixés. Il s'agit toujours d'une personne physique unique au sein de l'organisation permanente."]
["OBJECTIF-S DE PROJET","Il est défini en accord avec les stratégies et les objectifs du Service et/ou de l'Etat de Fribourg."]
["PARTIES PRENANTES","Personnes qui ont un intérêt dans la réalisation du projet : chef-fe de service, client-e-s, équipe, prestataires externes, etc. \nCe sont toutes les personnes concernées par le projet."]
["PÉRIMÈTRE DE PROJET","Le périmètre définit avec précision le cadre du projet, ses objectifs, ses résultats et les ressources nécessaires pour s'assurer que tout le travail requis par le projet, et seulement le travail requis, est effectué. Le périmètre du projet porte essentiellement sur la définition et la maîtrise de ce qui est inclus dans le projet et de ce qui en est exclu (hors projet)."]
["PLAN DE GESTION","Le plan de gestion du projet contient la planification générale du projet ainsi que les principales règles concernant les objectifs, le périmètre, le budget, les rôles qui doivent être définies de manière spécifique pour le projet. Il sert de base d'action unique pour tou-te-s les participant-e-s au projet. Il est précisé et actualisé continuellement pendant le projet selon le principe de la planification  continus. À la fin d'une phase, il est adapté aux nouvelles conditions en vue de l'exécution de la phase suivante."]
["REGISTRE DES RISQUES","Document permettant d'analyser les différents risques auxquels un projet est confronté et de planifier la réponse appropriée s'ils se matérialisent."]
["RESSOURCES","Tout ce qui est nécessaire à l'accomplissement d'une tâche. Il peut s'agir de personnes, d'outils, d'argent, de temps et d'installations."]
["RÉSULTATS (LIVRABLES)","Produit de travail livré à une date et dans un état qui ont été définis dans le plan de gestion. Un résultat peut être un produit physique, un fichier, un organigramme, un processus, etc."]

{"sheet":"Informations générales","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,0,12,1],[13,0,13,1],[13,2,13,3],[14,0,17,1],[14,2,22,3],[18,0,18,1],[6,0,6,1],[6,2,6,3],[2,0,2,1],[4,0,4,1],[4,2,4,3],[5,2,5,3],[5,0,5,1]]}
[]
[]
["INFORMATIONS GÉNÉRALES"]
[]
["Nom du projet",null,"Budget (sans coûts des RH internes)"]
["Nom du projet",null,"\"budget de projet approuvé en CHF.-\""]
["Objectif principal",null,"Macro planning (fournir seulement les dates de début)"]
[null,null,"Libération","JJ/MM/AAAA"]
[null,null,"Initialisation","JJ/MM/AAAA"]
[null,null,"Conception","JJ/MM/AAAA"]
[null,null,"Réalisation","JJ/MM/AAAA"]
[null,null,"Déploiement","JJ/MM/AAAA"]
[null,null,"Fin","JJ/MM/AAAA"]
["Périmètre",null,"Risques principaux"]
[]
[]
[]
[]
["Organisation"]
["Nom du/de la mandant-e","Prénom, Nom"]
["Nom du/de la chef-fe de projet","Prénom, Nom"]
[]
["…"]
[]
["INSTRUCTION"]
["Remplir les champs blancs avec les informations correspondentes"]

{"sheet":"Planning","index":2,"n_rows":44,"n_cols":112,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,107,7,110],[7,81,7,84],[7,94,7,97],[7,85,7,89],[7,90,7,93],[7,103,7,106],[7,98,7,102],[7,77,7,80],[7,55,7,58],[7,68,7,71],[7,20,7,23],[7,59,7,63],[7,64,7,67],[7,46,7,50],[7,51,7,54],[7,24,7,28],[7,29,7,32],[7,33,7,36],[7,37,7,41],[7,42,7,45],[0,0,6,1],[0,2,0,5],[3,2,3,5],[5,2,5,5],[7,72,7,76],[7,7,7,11],[7,16,7,19],[7,12,7,15]]}
["PLANNING DU PROJET \n(exemple)",null,"Utilisation",null,null,null,"Colonne F \"Etat\" - explication de la liste déroulante"]
[null,null," - Utiliser copier/coller.",null,null,null,"Dates planifiées et confirmées","Planifié"]
[null,null," - Ne pas modifier le formatage de cellules.",null,null,null,"Activité démarrée",0.25]
[null,null,"MOIS DE DEBUT DE PROJET",null,null,null,"Complétée à 50 %",0.5]
[null,null,null,"2021-03-07",null,null,"Presque fini, quelques tâches restent à finir",0.75]
[null,null,"indiquer ici la date de début du projet",null,null,null,"Fini","Fini","=> Changement en bleue automatique"]
[]
["Activité / Tâche prioritaire","Groupe","Debut","Fin","Nouvelle","Etat","Remarques",{"$f":"H10","v":"2021-03-07"},null,null,null,null,{"$f":"M10","v":"2021-04-11"},null,null,null,{"$f":"Q10","v":"2021-05-09"},null,null,null,{"$f":"U10","v":"2021-06-06"},null,null,null,{"$f":"Y10","v":"2021-07-04"},null,null,null,null,{"$f":"AD10","v":"2021-08-08"},null,null,null,{"$f":"AH10","v":"2021-09-05"},null,null,null,{"$f":"AL10","v":"2021-10-03"},null,null,null,null,{"$f":"AQ10","v":"2021-11-07"},null,null,null,{"$f":"AV10","v":"2021-12-12"},null,null,null,null,{"$f":"AZ10","v":"2022-01-09"},null,null,null,{"$f":"BD10","v":"2022-02-06"},null,null,null,{"$f":"BH10","v":"2022-03-06"},null,null,null,null,{"$f":"BM10","v":"2022-04-10"},null,null,null,{"$f":"BQ10","v":"2022-05-08"},null,null,null,{"$f":"BV10","v":"2022-06-12"},null,null,null,null,{"$f":"BZ10","v":"2022-07-10"},null,null,null,{"$f":"CD10","v":"2022-08-07"},null,null,null,{"$f":"CI10","v":"2022-09-11"},null,null,null,null,{"$f":"CM10","v":"2022-10-09"},null,null,null,{"$f":"CQ10","v":"2022-11-06"},null,null,null,{"$f":"CU10","v":"2022-12-04"},null,null,null,null,{"$f":"CZ10","v":"2023-01-08"},null,null,null,{"$f":"DD10","v":"2023-02-05"}]
[null,null,"date","date","date de fin",null,null,{"$f":"WEEKNUM(H10,2)","v":10},11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,{"$f":"WEEKNUM(AN10,2)","v":42},43,44,45,46,47,48,49,50,51,52,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,{"$f":"WEEKNUM(BT10,2)","v":22},23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,1,{"$f":"WEEKNUM(CZ10,2)","v":2},3,4,5,6,7,8,9]
[null,null,null,null,null,null,null,{"$f":"D5","v":"2021-03-07"},{"$f":"H10+7","v":"2021-03-14"},"2021-03-21","2021-03-28","2021-04-04","2021-04-11","2021-04-18","2021-04-25","2021-05-02","2021-05-09","2021-05-16","2021-05-23","2021-05-30","2021-06-06","2021-06-13","2021-06-20","2021-06-27","2021-07-04","2021-07-11","2021-07-18","2021-07-25","2021-08-01","2021-08-08","2021-08-15","2021-08-22","2021-08-29","2021-09-05",{"$f":"AH10+7","v":"2021-09-12"},"2021-09-19","2021-09-26","2021-10-03",{"$f":"AL10+7","v":"2021-10-10"},{"$f":"AM10+7","v":"2021-10-17"},{"$f":"AN10+7","v":"2021-10-24"},{"$f":"AO10+7","v":"2021-10-31"},{"$f":"AP10+7","v":"2021-11-07"},{"$f":"AQ10+7","v":"2021-11-14"},"2021-11-21","2021-11-28","2021-12-05","2021-12-12","2021-12-19","2021-12-26","2022-01-02","2022-01-09","2022-01-16","2022-01-23","2022-01-30","2022-02-06","2022-02-13","2022-02-20","2022-02-27",{"$f":"BG10+7","v":"2022-03-06"},{"$f":"BH10+7","v":"2022-03-13"},{"$f":"BI10+7","v":"2022-03-20"},"2022-03-27","2022-04-03","2022-04-10","2022-04-17","2022-04-24","2022-05-01","2022-05-08","2022-05-15","2022-05-22","2022-05-29","2022-06-05","2022-06-12","2022-06-19","2022-06-26","2022-07-03","2022-07-10","2022-07-17","2022-07-24","2022-07-31","2022-08-07","2022-08-14","2022-08-21","2022-08-28","2022-09-04","2022-09-11","2022-09-18","2022-09-25","2022-10-02","2022-10-09","2022-10-16","2022-10-23","2022-10-30","2022-11-06","2022-11-13","2022-11-20","2022-11-27","2022-12-04","2022-12-11","2022-12-18","2022-12-25","2023-01-01","2023-01-08","2023-01-15","2023-01-22","2023-01-29","2023-02-05","2023-02-12","2023-02-19","2023-02-26"]
[null,null,null,null,null,null,null,{"$f":"IF(OR(AND($C11>=H$10,$C11< I$10),AND($D11>=H$10,$D11<I$10),AND($E11>=H$10,$E11<I$10),IF($C11<>0,AND($C11<=H$10,$D11>=H$10),FALSE),AND($D11<=H$10,$E11>=H$10)),IF(AND(AND($D11>=H$10,$D11<I$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C11>=AN$10,$C11< AO$10),AND($D11>=AN$10,$D11<AO$10),AND($E11>=AN$10,$E11<AO$10),IF($C11<>0,AND($C11<=AN$10,$D11>=AN$10),FALSE),AND($D11<=AN$10,$E11>=AN$10)),IF(AND(AND($D11>=AN$10,$D11<AO$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C11>=BT$10,$C11< BU$10),AND($D11>=BT$10,$D11<BU$10),AND($E11>=BT$10,$E11<BU$10),IF($C11<>0,AND($C11<=BT$10,$D11>=BT$10),FALSE),AND($D11<=BT$10,$E11>=BT$10)),IF(AND(AND($D11>=BT$10,$D11<BU$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C11>=CZ$10,$C11< DA$10),AND($D11>=CZ$10,$D11<DA$10),AND($E11>=CZ$10,$E11<DA$10),IF($C11<>0,AND($C11<=CZ$10,$D11>=CZ$10),FALSE),AND($D11<=CZ$10,$E11>=CZ$10)),IF(AND(AND($D11>=CZ$10,$D11<DA$10),$E11<>0),IF($F11=\"Done\",\"Z\",\"Y\"),IF($F11=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",""]
["Phases Hermes 5",null,null,null,null,null,null,{"$f":"IF(OR(AND($C12>=H$10,$C12< I$10),AND($D12>=H$10,$D12<I$10),AND($E12>=H$10,$E12<I$10),IF($C12<>0,AND($C12<=H$10,$D12>=H$10),FALSE),AND($D12<=H$10,$E12>=H$10)),IF(AND(AND($D12>=H$10,$D12<I$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C12>=AN$10,$C12< AO$10),AND($D12>=AN$10,$D12<AO$10),AND($E12>=AN$10,$E12<AO$10),IF($C12<>0,AND($C12<=AN$10,$D12>=AN$10),FALSE),AND($D12<=AN$10,$E12>=AN$10)),IF(AND(AND($D12>=AN$10,$D12<AO$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C12>=BT$10,$C12< BU$10),AND($D12>=BT$10,$D12<BU$10),AND($E12>=BT$10,$E12<BU$10),IF($C12<>0,AND($C12<=BT$10,$D12>=BT$10),FALSE),AND($D12<=BT$10,$E12>=BT$10)),IF(AND(AND($D12>=BT$10,$D12<BU$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C12>=CZ$10,$C12< DA$10),AND($D12>=CZ$10,$D12<DA$10),AND($E12>=CZ$10,$E12<DA$10),IF($C12<>0,AND($C12<=CZ$10,$D12>=CZ$10),FALSE),AND($D12<=CZ$10,$E12>=CZ$10)),IF(AND(AND($D12>=CZ$10,$D12<DA$10),$E12<>0),IF($F12=\"Done\",\"Z\",\"Y\"),IF($F12=\"Done\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",""]
["Initialisation",null,"2021-03-07","2021-09-01",null,0.25,null,{"$f":"IF(OR(AND($C13>=H$10,$C13< I$10),AND($D13>=H$10,$D13<I$10),AND($E13>=H$10,$E13<I$10),IF($C13<>0,AND($C13<=H$10,$D13>=H$10),FALSE),AND($D13<=H$10,$E13>=H$10)),IF(AND(AND($D13>=H$10,$D13<I$10),$E13<>0),IF($F13=\"Fini\",\"Z\",\"Y\"),IF($F13=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},"X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","","","","","","",{"$f":"IF(OR(AND($C13>=AN$10,$C13< AO$10),AND($D13>=AN$10,$D13<AO$10),AND($E13>=AN$10,$E13<AO$10),IF($C13<>0,AND($C13<=AN$10,$D13>=AN$10),FALSE),AND($D13<=AN$10,$E13>=AN$10)),IF(AND(AND($D13>=AN$10,$D13<AO$10),$E13<>0),IF($F13=\"Fini\",\"Z\",\"Y\"),IF($F13=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C13>=BT$10,$C13< BU$10),AND($D13>=BT$10,$D13<BU$10),AND($E13>=BT$10,$E13<BU$10),IF($C13<>0,AND($C13<=BT$10,$D13>=BT$10),FALSE),AND($D13<=BT$10,$E13>=BT$10)),IF(AND(AND($D13>=BT$10,$D13<BU$10),$E13<>0),IF($F13=\"Fini\",\"Z\",\"Y\"),IF($F13=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C13>=CZ$10,$C13< DA$10),AND($D13>=CZ$10,$D13<DA$10),AND($E13>=CZ$10,$E13<DA$10),IF($C13<>0,AND($C13<=CZ$10,$D13>=CZ$10),FALSE),AND($D13<=CZ$10,$E13>=CZ$10)),IF(AND(AND($D13>=CZ$10,$D13<DA$10),$E13<>0),IF($F13=\"Fini\",\"Z\",\"Y\"),IF($F13=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",""]
["Tâche 1","Spécialiste","2021-03-07","2021-04-01",null,"Fini",null,{"$f":"IF(OR(AND($C14>=H$10,$C14< I$10),AND($D14>=H$10,$D14<I$10),AND($E14>=H$10,$E14<I$10),IF($C14<>0,AND($C14<=H$10,$D14>=H$10),FALSE),AND($D14<=H$10,$E14>=H$10)),IF(AND(AND($D14>=H$10,$D14<I$10),$E14<>0),IF($F14=\"Fini\",\"Z\",\"Y\"),IF($F14=\"Fini\",\"Z\",\"X\")),\"\")","v":"Z"},"Z","Z","Z","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C14>=AN$10,$C14< AO$10),AND($D14>=AN$10,$D14<AO$10),AND($E14>=AN$10,$E14<AO$10),IF($C14<>0,AND($C14<=AN$10,$D14>=AN$10),FALSE),AND($D14<=AN$10,$E14>=AN$10)),IF(AND(AND($D14>=AN$10,$D14<AO$10),$E14<>0),IF($F14=\"Fini\",\"Z\",\"Y\"),IF($F14=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C14>=BT$10,$C14< BU$10),AND($D14>=BT$10,$D14<BU$10),AND($E14>=BT$10,$E14<BU$10),IF($C14<>0,AND($C14<=BT$10,$D14>=BT$10),FALSE),AND($D14<=BT$10,$E14>=BT$10)),IF(AND(AND($D14>=BT$10,$D14<BU$10),$E14<>0),IF($F14=\"Fini\",\"Z\",\"Y\"),IF($F14=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C14>=CZ$10,$C14< DA$10),AND($D14>=CZ$10,$D14<DA$10),AND($E14>=CZ$10,$E14<DA$10),IF($C14<>0,AND($C14<=CZ$10,$D14>=CZ$10),FALSE),AND($D14<=CZ$10,$E14>=CZ$10)),IF(AND(AND($D14>=CZ$10,$D14<DA$10),$E14<>0),IF($F14=\"Fini\",\"Z\",\"Y\"),IF($F14=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",""]
["Tâche 2","Mandant-e",null,"2021-05-01",null,0.5,null,{"$f":"IF(OR(AND($C15>=H$10,$C15< I$10),AND($D15>=H$10,$D15<I$10),AND($E15>=H$10,$E15<I$10),IF($C15<>0,AND($C15<=H$10,$D15>=H$10),FALSE),AND($D15<=H$10,$E15>=H$10)),IF(AND(AND($D15>=H$10,$D15<I$10),$E15<>0),IF($F15=\"Fini\",\"Z\",\"Y\"),IF($F15=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","X","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C15>=AN$10,$C15< AO$10),AND($D15>=AN$10,$D15<AO$10),AND($E15>=AN$10,$E15<AO$10),IF($C15<>0,AND($C15<=AN$10,$D15>=AN$10),FALSE),AND($D15<=AN$10,$E15>=AN$10)),IF(AND(AND($D15>=AN$10,$D15<AO$10),$E15<>0),IF($F15=\"Fini\",\"Z\",\"Y\"),IF($F15=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C15>=BT$10,$C15< BU$10),AND($D15>=BT$10,$D15<BU$10),AND($E15>=BT$10,$E15<BU$10),IF($C15<>0,AND($C15<=BT$10,$D15>=BT$10),FALSE),AND($D15<=BT$10,$E15>=BT$10)),IF(AND(AND($D15>=BT$10,$D15<BU$10),$E15<>0),IF($F15=\"Fini\",\"Z\",\"Y\"),IF($F15=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C15>=CZ$10,$C15< DA$10),AND($D15>=CZ$10,$D15<DA$10),AND($E15>=CZ$10,$E15<DA$10),IF($C15<>0,AND($C15<=CZ$10,$D15>=CZ$10),FALSE),AND($D15<=CZ$10,$E15>=CZ$10)),IF(AND(AND($D15>=CZ$10,$D15<DA$10),$E15<>0),IF($F15=\"Fini\",\"Z\",\"Y\"),IF($F15=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",""]
["Tâche 3","Chef-fe de projet","2021-04-01","2021-05-01",null,0.25,null,{"$f":"IF(OR(AND($C16>=H$10,$C16< I$10),AND($D16>=H$10,$D16<I$10),AND($E16>=H$10,$E16<I$10),IF($C16<>0,AND($C16<=H$10,$D16>=H$10),FALSE),AND($D16<=H$10,$E16>=H$10)),IF(AND(AND($D16>=H$10,$D16<I$10),$E16<>0),IF($F16=\"Fini\",\"Z\",\"Y\"),IF($F16=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","X","X","X","X","X","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C16>=AN$10,$C16< AO$10),AND($D16>=AN$10,$D16<AO$10),AND($E16>=AN$10,$E16<AO$10),IF($C16<>0,AND($C16<=AN$10,$D16>=AN$10),FALSE),AND($D16<=AN$10,$E16>=AN$10)),IF(AND(AND($D16>=AN$10,$D16<AO$10),$E16<>0),IF($F16=\"Fini\",\"Z\",\"Y\"),IF($F16=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C16>=BT$10,$C16< BU$10),AND($D16>=BT$10,$D16<BU$10),AND($E16>=BT$10,$E16<BU$10),IF($C16<>0,AND($C16<=BT$10,$D16>=BT$10),FALSE),AND($D16<=BT$10,$E16>=BT$10)),IF(AND(AND($D16>=BT$10,$D16<BU$10),$E16<>0),IF($F16=\"Fini\",\"Z\",\"Y\"),IF($F16=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C16>=CZ$10,$C16< DA$10),AND($D16>=CZ$10,$D16<DA$10),AND($E16>=CZ$10,$E16<DA$10),IF($C16<>0,AND($C16<=CZ$10,$D16>=CZ$10),FALSE),AND($D16<=CZ$10,$E16>=CZ$10)),IF(AND(AND($D16>=CZ$10,$D16<DA$10),$E16<>0),IF($F16=\"Fini\",\"Z\",\"Y\"),IF($F16=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","",{"$f":"IF(OR(AND($C16>=DH$10,$C16< DI$10),AND($D16>=DH$10,$D16<DI$10),AND($E16>=DH$10,$E16<DI$10),IF($C16<>0,AND($C16<=DH$10,$D16>=DH$10),FALSE),AND($D16<=DH$10,$E16>=DH$10)),IF(AND(AND($D16>=DH$10,$D16<DI$10),$E16<>0),IF($F16=\"Fini\",\"Z\",\"Y\"),IF($F16=\"Fini\",\"Z\",\"X\")),\"\")","v":""}]
["Tâche 4","Chef-fe de projet","2021-05-01","2021-07-01",null,0.25,null,{"$f":"H18","v":""},{"$f":"IF(OR(AND($C17>=I$10,$C17< J$10),AND($D17>=I$10,$D17<J$10),AND($E17>=I$10,$E17<J$10),IF($C17<>0,AND($C17<=I$10,$D17>=I$10),FALSE),AND($D17<=I$10,$E17>=I$10)),IF(AND(AND($D17>=I$10,$D17<J$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","X","X","X","X","X","X","X","X","X","X","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C17>=AO$10,$C17< AP$10),AND($D17>=AO$10,$D17<AP$10),AND($E17>=AO$10,$E17<AP$10),IF($C17<>0,AND($C17<=AO$10,$D17>=AO$10),FALSE),AND($D17<=AO$10,$E17>=AO$10)),IF(AND(AND($D17>=AO$10,$D17<AP$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C17>=BU$10,$C17< BV$10),AND($D17>=BU$10,$D17<BV$10),AND($E17>=BU$10,$E17<BV$10),IF($C17<>0,AND($C17<=BU$10,$D17>=BU$10),FALSE),AND($D17<=BU$10,$E17>=BU$10)),IF(AND(AND($D17>=BU$10,$D17<BV$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C17>=DA$10,$C17< DB$10),AND($D17>=DA$10,$D17<DB$10),AND($E17>=DA$10,$E17<DB$10),IF($C17<>0,AND($C17<=DA$10,$D17>=DA$10),FALSE),AND($D17<=DA$10,$E17>=DA$10)),IF(AND(AND($D17>=DA$10,$D17<DB$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",{"$f":"IF(OR(AND($C17>=DH$10,$C17< DI$10),AND($D17>=DH$10,$D17<DI$10),AND($E17>=DH$10,$E17<DI$10),IF($C17<>0,AND($C17<=DH$10,$D17>=DH$10),FALSE),AND($D17<=DH$10,$E17>=DH$10)),IF(AND(AND($D17>=DH$10,$D17<DI$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""}]
["Tâche 5","Spécialiste","2021-07-01","2021-08-15",null,"Planifié",null,{"$f":"IF(OR(AND($C17>=H$10,$C17< I$10),AND($D17>=H$10,$D17<I$10),AND($E17>=H$10,$E17<I$10),IF($C17<>0,AND($C17<=H$10,$D17>=H$10),FALSE),AND($D17<=H$10,$E17>=H$10)),IF(AND(AND($D17>=H$10,$D17<I$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","X","X","X","X","X","X","X","X","X","X","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C17>=AN$10,$C17< AO$10),AND($D17>=AN$10,$D17<AO$10),AND($E17>=AN$10,$E17<AO$10),IF($C17<>0,AND($C17<=AN$10,$D17>=AN$10),FALSE),AND($D17<=AN$10,$E17>=AN$10)),IF(AND(AND($D17>=AN$10,$D17<AO$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C17>=BT$10,$C17< BU$10),AND($D17>=BT$10,$D17<BU$10),AND($E17>=BT$10,$E17<BU$10),IF($C17<>0,AND($C17<=BT$10,$D17>=BT$10),FALSE),AND($D17<=BT$10,$E17>=BT$10)),IF(AND(AND($D17>=BT$10,$D17<BU$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C17>=CZ$10,$C17< DA$10),AND($D17>=CZ$10,$D17<DA$10),AND($E17>=CZ$10,$E17<DA$10),IF($C17<>0,AND($C17<=CZ$10,$D17>=CZ$10),FALSE),AND($D17<=CZ$10,$E17>=CZ$10)),IF(AND(AND($D17>=CZ$10,$D17<DA$10),$E17<>0),IF($F17=\"Fini\",\"Z\",\"Y\"),IF($F17=\"Fini\",\"Z\",\"X\")),\"\")","v":""},"","","","","","",{"$f":"IF(OR(AND($C18>=DG$10,$C18< DH$10),AND($D18>=DG$10,$D18<DH$10),AND($E18>=DG$10,$E18<DH$10),IF($C18<>0,AND($C18<=DG$10,$D18>=DG$10),FALSE),AND($D18<=DG$10,$E18>=DG$10)),IF(AND(AND($D18>=DG$10,$D18<DH$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=DH$10,$C18< DI$10),AND($D18>=DH$10,$D18<DI$10),AND($E18>=DH$10,$E18<DI$10),IF($C18<>0,AND($C18<=DH$10,$D18>=DH$10),FALSE),AND($D18<=DH$10,$E18>=DH$10)),IF(AND(AND($D18>=DH$10,$D18<DI$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""}]
["Tâche 6","Mandant-e","2021-08-15","2021-08-22",null,"Planifié",null,{"$f":"IF(OR(AND($C19>=H$10,$C19< I$10),AND($D19>=H$10,$D19<I$10),AND($E19>=H$10,$E19<I$10),IF($C19<>0,AND($C19<=H$10,$D19>=H$10),FALSE),AND($D19<=H$10,$E19>=H$10)),IF(AND(AND($D19>=H$10,$D19<I$10),$E19<>0),IF($F19=\"Fini\",\"Z\",\"Y\"),IF($F19=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=I$10,$C18< J$10),AND($D18>=I$10,$D18<J$10),AND($E18>=I$10,$E18<J$10),IF($C18<>0,AND($C18<=I$10,$D18>=I$10),FALSE),AND($D18<=I$10,$E18>=I$10)),IF(AND(AND($D18>=I$10,$D18<J$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=J$10,$C18< K$10),AND($D18>=J$10,$D18<K$10),AND($E18>=J$10,$E18<K$10),IF($C18<>0,AND($C18<=J$10,$D18>=J$10),FALSE),AND($D18<=J$10,$E18>=J$10)),IF(AND(AND($D18>=J$10,$D18<K$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=K$10,$C18< L$10),AND($D18>=K$10,$D18<L$10),AND($E18>=K$10,$E18<L$10),IF($C18<>0,AND($C18<=K$10,$D18>=K$10),FALSE),AND($D18<=K$10,$E18>=K$10)),IF(AND(AND($D18>=K$10,$D18<L$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=L$10,$C18< M$10),AND($D18>=L$10,$D18<M$10),AND($E18>=L$10,$E18<M$10),IF($C18<>0,AND($C18<=L$10,$D18>=L$10),FALSE),AND($D18<=L$10,$E18>=L$10)),IF(AND(AND($D18>=L$10,$D18<M$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=M$10,$C18< N$10),AND($D18>=M$10,$D18<N$10),AND($E18>=M$10,$E18<N$10),IF($C18<>0,AND($C18<=M$10,$D18>=M$10),FALSE),AND($D18<=M$10,$E18>=M$10)),IF(AND(AND($D18>=M$10,$D18<N$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=N$10,$C18< O$10),AND($D18>=N$10,$D18<O$10),AND($E18>=N$10,$E18<O$10),IF($C18<>0,AND($C18<=N$10,$D18>=N$10),FALSE),AND($D18<=N$10,$E18>=N$10)),IF(AND(AND($D18>=N$10,$D18<O$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=O$10,$C18< P$10),AND($D18>=O$10,$D18<P$10),AND($E18>=O$10,$E18<P$10),IF($C18<>0,AND($C18<=O$10,$D18>=O$10),FALSE),AND($D18<=O$10,$E18>=O$10)),IF(AND(AND($D18>=O$10,$D18<P$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=P$10,$C18< Q$10),AND($D18>=P$10,$D18<Q$10),AND($E18>=P$10,$E18<Q$10),IF($C18<>0,AND($C18<=P$10,$D18>=P$10),FALSE),AND($D18<=P$10,$E18>=P$10)),IF(AND(AND($D18>=P$10,$D18<Q$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=Q$10,$C18< R$10),AND($D18>=Q$10,$D18<R$10),AND($E18>=Q$10,$E18<R$10),IF($C18<>0,AND($C18<=Q$10,$D18>=Q$10),FALSE),AND($D18<=Q$10,$E18>=Q$10)),IF(AND(AND($D18>=Q$10,$D18<R$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=R$10,$C18< S$10),AND($D18>=R$10,$D18<S$10),AND($E18>=R$10,$E18<S$10),IF($C18<>0,AND($C18<=R$10,$D18>=R$10),FALSE),AND($D18<=R$10,$E18>=R$10)),IF(AND(AND($D18>=R$10,$D18<S$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=S$10,$C18< T$10),AND($D18>=S$10,$D18<T$10),AND($E18>=S$10,$E18<T$10),IF($C18<>0,AND($C18<=S$10,$D18>=S$10),FALSE),AND($D18<=S$10,$E18>=S$10)),IF(AND(AND($D18>=S$10,$D18<T$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=T$10,$C18< U$10),AND($D18>=T$10,$D18<U$10),AND($E18>=T$10,$E18<U$10),IF($C18<>0,AND($C18<=T$10,$D18>=T$10),FALSE),AND($D18<=T$10,$E18>=T$10)),IF(AND(AND($D18>=T$10,$D18<U$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=U$10,$C18< V$10),AND($D18>=U$10,$D18<V$10),AND($E18>=U$10,$E18<V$10),IF($C18<>0,AND($C18<=U$10,$D18>=U$10),FALSE),AND($D18<=U$10,$E18>=U$10)),IF(AND(AND($D18>=U$10,$D18<V$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=V$10,$C18< W$10),AND($D18>=V$10,$D18<W$10),AND($E18>=V$10,$E18<W$10),IF($C18<>0,AND($C18<=V$10,$D18>=V$10),FALSE),AND($D18<=V$10,$E18>=V$10)),IF(AND(AND($D18>=V$10,$D18<W$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=W$10,$C18< X$10),AND($D18>=W$10,$D18<X$10),AND($E18>=W$10,$E18<X$10),IF($C18<>0,AND($C18<=W$10,$D18>=W$10),FALSE),AND($D18<=W$10,$E18>=W$10)),IF(AND(AND($D18>=W$10,$D18<X$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=X$10,$C18< Y$10),AND($D18>=X$10,$D18<Y$10),AND($E18>=X$10,$E18<Y$10),IF($C18<>0,AND($C18<=X$10,$D18>=X$10),FALSE),AND($D18<=X$10,$E18>=X$10)),IF(AND(AND($D18>=X$10,$D18<Y$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C18>=Y$10,$C18< Z$10),AND($D18>=Y$10,$D18<Z$10),AND($E18>=Y$10,$E18<Z$10),IF($C18<>0,AND($C18<=Y$10,$D18>=Y$10),FALSE),AND($D18<=Y$10,$E18>=Y$10)),IF(AND(AND($D18>=Y$10,$D18<Z$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C18>=Z$10,$C18< AA$10),AND($D18>=Z$10,$D18<AA$10),AND($E18>=Z$10,$E18<AA$10),IF($C18<>0,AND($C18<=Z$10,$D18>=Z$10),FALSE),AND($D18<=Z$10,$E18>=Z$10)),IF(AND(AND($D18>=Z$10,$D18<AA$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C18>=AA$10,$C18< AB$10),AND($D18>=AA$10,$D18<AB$10),AND($E18>=AA$10,$E18<AB$10),IF($C18<>0,AND($C18<=AA$10,$D18>=AA$10),FALSE),AND($D18<=AA$10,$E18>=AA$10)),IF(AND(AND($D18>=AA$10,$D18<AB$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C18>=AB$10,$C18< AC$10),AND($D18>=AB$10,$D18<AC$10),AND($E18>=AB$10,$E18<AC$10),IF($C18<>0,AND($C18<=AB$10,$D18>=AB$10),FALSE),AND($D18<=AB$10,$E18>=AB$10)),IF(AND(AND($D18>=AB$10,$D18<AC$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C18>=AC$10,$C18< AD$10),AND($D18>=AC$10,$D18<AD$10),AND($E18>=AC$10,$E18<AD$10),IF($C18<>0,AND($C18<=AC$10,$D18>=AC$10),FALSE),AND($D18<=AC$10,$E18>=AC$10)),IF(AND(AND($D18>=AC$10,$D18<AD$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C18>=AD$10,$C18< AE$10),AND($D18>=AD$10,$D18<AE$10),AND($E18>=AD$10,$E18<AE$10),IF($C18<>0,AND($C18<=AD$10,$D18>=AD$10),FALSE),AND($D18<=AD$10,$E18>=AD$10)),IF(AND(AND($D18>=AD$10,$D18<AE$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C18>=AE$10,$C18< AF$10),AND($D18>=AE$10,$D18<AF$10),AND($E18>=AE$10,$E18<AF$10),IF($C18<>0,AND($C18<=AE$10,$D18>=AE$10),FALSE),AND($D18<=AE$10,$E18>=AE$10)),IF(AND(AND($D18>=AE$10,$D18<AF$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},{"$f":"IF(OR(AND($C18>=AF$10,$C18< AG$10),AND($D18>=AF$10,$D18<AG$10),AND($E18>=AF$10,$E18<AG$10),IF($C18<>0,AND($C18<=AF$10,$D18>=AF$10),FALSE),AND($D18<=AF$10,$E18>=AF$10)),IF(AND(AND($D18>=AF$10,$D18<AG$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AG$10,$C18< AH$10),AND($D18>=AG$10,$D18<AH$10),AND($E18>=AG$10,$E18<AH$10),IF($C18<>0,AND($C18<=AG$10,$D18>=AG$10),FALSE),AND($D18<=AG$10,$E18>=AG$10)),IF(AND(AND($D18>=AG$10,$D18<AH$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AH$10,$C18< AI$10),AND($D18>=AH$10,$D18<AI$10),AND($E18>=AH$10,$E18<AI$10),IF($C18<>0,AND($C18<=AH$10,$D18>=AH$10),FALSE),AND($D18<=AH$10,$E18>=AH$10)),IF(AND(AND($D18>=AH$10,$D18<AI$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AI$10,$C18< AJ$10),AND($D18>=AI$10,$D18<AJ$10),AND($E18>=AI$10,$E18<AJ$10),IF($C18<>0,AND($C18<=AI$10,$D18>=AI$10),FALSE),AND($D18<=AI$10,$E18>=AI$10)),IF(AND(AND($D18>=AI$10,$D18<AJ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AJ$10,$C18< AK$10),AND($D18>=AJ$10,$D18<AK$10),AND($E18>=AJ$10,$E18<AK$10),IF($C18<>0,AND($C18<=AJ$10,$D18>=AJ$10),FALSE),AND($D18<=AJ$10,$E18>=AJ$10)),IF(AND(AND($D18>=AJ$10,$D18<AK$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AK$10,$C18< AL$10),AND($D18>=AK$10,$D18<AL$10),AND($E18>=AK$10,$E18<AL$10),IF($C18<>0,AND($C18<=AK$10,$D18>=AK$10),FALSE),AND($D18<=AK$10,$E18>=AK$10)),IF(AND(AND($D18>=AK$10,$D18<AL$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AL$10,$C18< AM$10),AND($D18>=AL$10,$D18<AM$10),AND($E18>=AL$10,$E18<AM$10),IF($C18<>0,AND($C18<=AL$10,$D18>=AL$10),FALSE),AND($D18<=AL$10,$E18>=AL$10)),IF(AND(AND($D18>=AL$10,$D18<AM$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AM$10,$C18< AN$10),AND($D18>=AM$10,$D18<AN$10),AND($E18>=AM$10,$E18<AN$10),IF($C18<>0,AND($C18<=AM$10,$D18>=AM$10),FALSE),AND($D18<=AM$10,$E18>=AM$10)),IF(AND(AND($D18>=AM$10,$D18<AN$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AN$10,$C18< AO$10),AND($D18>=AN$10,$D18<AO$10),AND($E18>=AN$10,$E18<AO$10),IF($C18<>0,AND($C18<=AN$10,$D18>=AN$10),FALSE),AND($D18<=AN$10,$E18>=AN$10)),IF(AND(AND($D18>=AN$10,$D18<AO$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AO$10,$C18< AP$10),AND($D18>=AO$10,$D18<AP$10),AND($E18>=AO$10,$E18<AP$10),IF($C18<>0,AND($C18<=AO$10,$D18>=AO$10),FALSE),AND($D18<=AO$10,$E18>=AO$10)),IF(AND(AND($D18>=AO$10,$D18<AP$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AP$10,$C18< AQ$10),AND($D18>=AP$10,$D18<AQ$10),AND($E18>=AP$10,$E18<AQ$10),IF($C18<>0,AND($C18<=AP$10,$D18>=AP$10),FALSE),AND($D18<=AP$10,$E18>=AP$10)),IF(AND(AND($D18>=AP$10,$D18<AQ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AQ$10,$C18< AR$10),AND($D18>=AQ$10,$D18<AR$10),AND($E18>=AQ$10,$E18<AR$10),IF($C18<>0,AND($C18<=AQ$10,$D18>=AQ$10),FALSE),AND($D18<=AQ$10,$E18>=AQ$10)),IF(AND(AND($D18>=AQ$10,$D18<AR$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AR$10,$C18< AS$10),AND($D18>=AR$10,$D18<AS$10),AND($E18>=AR$10,$E18<AS$10),IF($C18<>0,AND($C18<=AR$10,$D18>=AR$10),FALSE),AND($D18<=AR$10,$E18>=AR$10)),IF(AND(AND($D18>=AR$10,$D18<AS$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AS$10,$C18< AT$10),AND($D18>=AS$10,$D18<AT$10),AND($E18>=AS$10,$E18<AT$10),IF($C18<>0,AND($C18<=AS$10,$D18>=AS$10),FALSE),AND($D18<=AS$10,$E18>=AS$10)),IF(AND(AND($D18>=AS$10,$D18<AT$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AT$10,$C18< AU$10),AND($D18>=AT$10,$D18<AU$10),AND($E18>=AT$10,$E18<AU$10),IF($C18<>0,AND($C18<=AT$10,$D18>=AT$10),FALSE),AND($D18<=AT$10,$E18>=AT$10)),IF(AND(AND($D18>=AT$10,$D18<AU$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AU$10,$C18< AV$10),AND($D18>=AU$10,$D18<AV$10),AND($E18>=AU$10,$E18<AV$10),IF($C18<>0,AND($C18<=AU$10,$D18>=AU$10),FALSE),AND($D18<=AU$10,$E18>=AU$10)),IF(AND(AND($D18>=AU$10,$D18<AV$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AV$10,$C18< AW$10),AND($D18>=AV$10,$D18<AW$10),AND($E18>=AV$10,$E18<AW$10),IF($C18<>0,AND($C18<=AV$10,$D18>=AV$10),FALSE),AND($D18<=AV$10,$E18>=AV$10)),IF(AND(AND($D18>=AV$10,$D18<AW$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AW$10,$C18< AX$10),AND($D18>=AW$10,$D18<AX$10),AND($E18>=AW$10,$E18<AX$10),IF($C18<>0,AND($C18<=AW$10,$D18>=AW$10),FALSE),AND($D18<=AW$10,$E18>=AW$10)),IF(AND(AND($D18>=AW$10,$D18<AX$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AX$10,$C18< AY$10),AND($D18>=AX$10,$D18<AY$10),AND($E18>=AX$10,$E18<AY$10),IF($C18<>0,AND($C18<=AX$10,$D18>=AX$10),FALSE),AND($D18<=AX$10,$E18>=AX$10)),IF(AND(AND($D18>=AX$10,$D18<AY$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AY$10,$C18< AZ$10),AND($D18>=AY$10,$D18<AZ$10),AND($E18>=AY$10,$E18<AZ$10),IF($C18<>0,AND($C18<=AY$10,$D18>=AY$10),FALSE),AND($D18<=AY$10,$E18>=AY$10)),IF(AND(AND($D18>=AY$10,$D18<AZ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=AZ$10,$C18< BA$10),AND($D18>=AZ$10,$D18<BA$10),AND($E18>=AZ$10,$E18<BA$10),IF($C18<>0,AND($C18<=AZ$10,$D18>=AZ$10),FALSE),AND($D18<=AZ$10,$E18>=AZ$10)),IF(AND(AND($D18>=AZ$10,$D18<BA$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BA$10,$C18< BB$10),AND($D18>=BA$10,$D18<BB$10),AND($E18>=BA$10,$E18<BB$10),IF($C18<>0,AND($C18<=BA$10,$D18>=BA$10),FALSE),AND($D18<=BA$10,$E18>=BA$10)),IF(AND(AND($D18>=BA$10,$D18<BB$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BB$10,$C18< BC$10),AND($D18>=BB$10,$D18<BC$10),AND($E18>=BB$10,$E18<BC$10),IF($C18<>0,AND($C18<=BB$10,$D18>=BB$10),FALSE),AND($D18<=BB$10,$E18>=BB$10)),IF(AND(AND($D18>=BB$10,$D18<BC$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BC$10,$C18< BD$10),AND($D18>=BC$10,$D18<BD$10),AND($E18>=BC$10,$E18<BD$10),IF($C18<>0,AND($C18<=BC$10,$D18>=BC$10),FALSE),AND($D18<=BC$10,$E18>=BC$10)),IF(AND(AND($D18>=BC$10,$D18<BD$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BD$10,$C18< BE$10),AND($D18>=BD$10,$D18<BE$10),AND($E18>=BD$10,$E18<BE$10),IF($C18<>0,AND($C18<=BD$10,$D18>=BD$10),FALSE),AND($D18<=BD$10,$E18>=BD$10)),IF(AND(AND($D18>=BD$10,$D18<BE$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BE$10,$C18< BF$10),AND($D18>=BE$10,$D18<BF$10),AND($E18>=BE$10,$E18<BF$10),IF($C18<>0,AND($C18<=BE$10,$D18>=BE$10),FALSE),AND($D18<=BE$10,$E18>=BE$10)),IF(AND(AND($D18>=BE$10,$D18<BF$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BF$10,$C18< BG$10),AND($D18>=BF$10,$D18<BG$10),AND($E18>=BF$10,$E18<BG$10),IF($C18<>0,AND($C18<=BF$10,$D18>=BF$10),FALSE),AND($D18<=BF$10,$E18>=BF$10)),IF(AND(AND($D18>=BF$10,$D18<BG$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BG$10,$C18< BH$10),AND($D18>=BG$10,$D18<BH$10),AND($E18>=BG$10,$E18<BH$10),IF($C18<>0,AND($C18<=BG$10,$D18>=BG$10),FALSE),AND($D18<=BG$10,$E18>=BG$10)),IF(AND(AND($D18>=BG$10,$D18<BH$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BH$10,$C18< BI$10),AND($D18>=BH$10,$D18<BI$10),AND($E18>=BH$10,$E18<BI$10),IF($C18<>0,AND($C18<=BH$10,$D18>=BH$10),FALSE),AND($D18<=BH$10,$E18>=BH$10)),IF(AND(AND($D18>=BH$10,$D18<BI$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BI$10,$C18< BJ$10),AND($D18>=BI$10,$D18<BJ$10),AND($E18>=BI$10,$E18<BJ$10),IF($C18<>0,AND($C18<=BI$10,$D18>=BI$10),FALSE),AND($D18<=BI$10,$E18>=BI$10)),IF(AND(AND($D18>=BI$10,$D18<BJ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BJ$10,$C18< BK$10),AND($D18>=BJ$10,$D18<BK$10),AND($E18>=BJ$10,$E18<BK$10),IF($C18<>0,AND($C18<=BJ$10,$D18>=BJ$10),FALSE),AND($D18<=BJ$10,$E18>=BJ$10)),IF(AND(AND($D18>=BJ$10,$D18<BK$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BK$10,$C18< BL$10),AND($D18>=BK$10,$D18<BL$10),AND($E18>=BK$10,$E18<BL$10),IF($C18<>0,AND($C18<=BK$10,$D18>=BK$10),FALSE),AND($D18<=BK$10,$E18>=BK$10)),IF(AND(AND($D18>=BK$10,$D18<BL$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BL$10,$C18< BM$10),AND($D18>=BL$10,$D18<BM$10),AND($E18>=BL$10,$E18<BM$10),IF($C18<>0,AND($C18<=BL$10,$D18>=BL$10),FALSE),AND($D18<=BL$10,$E18>=BL$10)),IF(AND(AND($D18>=BL$10,$D18<BM$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BM$10,$C18< BN$10),AND($D18>=BM$10,$D18<BN$10),AND($E18>=BM$10,$E18<BN$10),IF($C18<>0,AND($C18<=BM$10,$D18>=BM$10),FALSE),AND($D18<=BM$10,$E18>=BM$10)),IF(AND(AND($D18>=BM$10,$D18<BN$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BN$10,$C18< BO$10),AND($D18>=BN$10,$D18<BO$10),AND($E18>=BN$10,$E18<BO$10),IF($C18<>0,AND($C18<=BN$10,$D18>=BN$10),FALSE),AND($D18<=BN$10,$E18>=BN$10)),IF(AND(AND($D18>=BN$10,$D18<BO$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BO$10,$C18< BP$10),AND($D18>=BO$10,$D18<BP$10),AND($E18>=BO$10,$E18<BP$10),IF($C18<>0,AND($C18<=BO$10,$D18>=BO$10),FALSE),AND($D18<=BO$10,$E18>=BO$10)),IF(AND(AND($D18>=BO$10,$D18<BP$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BP$10,$C18< BQ$10),AND($D18>=BP$10,$D18<BQ$10),AND($E18>=BP$10,$E18<BQ$10),IF($C18<>0,AND($C18<=BP$10,$D18>=BP$10),FALSE),AND($D18<=BP$10,$E18>=BP$10)),IF(AND(AND($D18>=BP$10,$D18<BQ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BQ$10,$C18< BR$10),AND($D18>=BQ$10,$D18<BR$10),AND($E18>=BQ$10,$E18<BR$10),IF($C18<>0,AND($C18<=BQ$10,$D18>=BQ$10),FALSE),AND($D18<=BQ$10,$E18>=BQ$10)),IF(AND(AND($D18>=BQ$10,$D18<BR$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BR$10,$C18< BS$10),AND($D18>=BR$10,$D18<BS$10),AND($E18>=BR$10,$E18<BS$10),IF($C18<>0,AND($C18<=BR$10,$D18>=BR$10),FALSE),AND($D18<=BR$10,$E18>=BR$10)),IF(AND(AND($D18>=BR$10,$D18<BS$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BS$10,$C18< BT$10),AND($D18>=BS$10,$D18<BT$10),AND($E18>=BS$10,$E18<BT$10),IF($C18<>0,AND($C18<=BS$10,$D18>=BS$10),FALSE),AND($D18<=BS$10,$E18>=BS$10)),IF(AND(AND($D18>=BS$10,$D18<BT$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BT$10,$C18< BU$10),AND($D18>=BT$10,$D18<BU$10),AND($E18>=BT$10,$E18<BU$10),IF($C18<>0,AND($C18<=BT$10,$D18>=BT$10),FALSE),AND($D18<=BT$10,$E18>=BT$10)),IF(AND(AND($D18>=BT$10,$D18<BU$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BU$10,$C18< BV$10),AND($D18>=BU$10,$D18<BV$10),AND($E18>=BU$10,$E18<BV$10),IF($C18<>0,AND($C18<=BU$10,$D18>=BU$10),FALSE),AND($D18<=BU$10,$E18>=BU$10)),IF(AND(AND($D18>=BU$10,$D18<BV$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BV$10,$C18< BW$10),AND($D18>=BV$10,$D18<BW$10),AND($E18>=BV$10,$E18<BW$10),IF($C18<>0,AND($C18<=BV$10,$D18>=BV$10),FALSE),AND($D18<=BV$10,$E18>=BV$10)),IF(AND(AND($D18>=BV$10,$D18<BW$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BW$10,$C18< BX$10),AND($D18>=BW$10,$D18<BX$10),AND($E18>=BW$10,$E18<BX$10),IF($C18<>0,AND($C18<=BW$10,$D18>=BW$10),FALSE),AND($D18<=BW$10,$E18>=BW$10)),IF(AND(AND($D18>=BW$10,$D18<BX$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BX$10,$C18< BY$10),AND($D18>=BX$10,$D18<BY$10),AND($E18>=BX$10,$E18<BY$10),IF($C18<>0,AND($C18<=BX$10,$D18>=BX$10),FALSE),AND($D18<=BX$10,$E18>=BX$10)),IF(AND(AND($D18>=BX$10,$D18<BY$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BY$10,$C18< BZ$10),AND($D18>=BY$10,$D18<BZ$10),AND($E18>=BY$10,$E18<BZ$10),IF($C18<>0,AND($C18<=BY$10,$D18>=BY$10),FALSE),AND($D18<=BY$10,$E18>=BY$10)),IF(AND(AND($D18>=BY$10,$D18<BZ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=BZ$10,$C18< CA$10),AND($D18>=BZ$10,$D18<CA$10),AND($E18>=BZ$10,$E18<CA$10),IF($C18<>0,AND($C18<=BZ$10,$D18>=BZ$10),FALSE),AND($D18<=BZ$10,$E18>=BZ$10)),IF(AND(AND($D18>=BZ$10,$D18<CA$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CA$10,$C18< CB$10),AND($D18>=CA$10,$D18<CB$10),AND($E18>=CA$10,$E18<CB$10),IF($C18<>0,AND($C18<=CA$10,$D18>=CA$10),FALSE),AND($D18<=CA$10,$E18>=CA$10)),IF(AND(AND($D18>=CA$10,$D18<CB$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CB$10,$C18< CC$10),AND($D18>=CB$10,$D18<CC$10),AND($E18>=CB$10,$E18<CC$10),IF($C18<>0,AND($C18<=CB$10,$D18>=CB$10),FALSE),AND($D18<=CB$10,$E18>=CB$10)),IF(AND(AND($D18>=CB$10,$D18<CC$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CC$10,$C18< CD$10),AND($D18>=CC$10,$D18<CD$10),AND($E18>=CC$10,$E18<CD$10),IF($C18<>0,AND($C18<=CC$10,$D18>=CC$10),FALSE),AND($D18<=CC$10,$E18>=CC$10)),IF(AND(AND($D18>=CC$10,$D18<CD$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CD$10,$C18< CE$10),AND($D18>=CD$10,$D18<CE$10),AND($E18>=CD$10,$E18<CE$10),IF($C18<>0,AND($C18<=CD$10,$D18>=CD$10),FALSE),AND($D18<=CD$10,$E18>=CD$10)),IF(AND(AND($D18>=CD$10,$D18<CE$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CE$10,$C18< CF$10),AND($D18>=CE$10,$D18<CF$10),AND($E18>=CE$10,$E18<CF$10),IF($C18<>0,AND($C18<=CE$10,$D18>=CE$10),FALSE),AND($D18<=CE$10,$E18>=CE$10)),IF(AND(AND($D18>=CE$10,$D18<CF$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CF$10,$C18< CG$10),AND($D18>=CF$10,$D18<CG$10),AND($E18>=CF$10,$E18<CG$10),IF($C18<>0,AND($C18<=CF$10,$D18>=CF$10),FALSE),AND($D18<=CF$10,$E18>=CF$10)),IF(AND(AND($D18>=CF$10,$D18<CG$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CG$10,$C18< CH$10),AND($D18>=CG$10,$D18<CH$10),AND($E18>=CG$10,$E18<CH$10),IF($C18<>0,AND($C18<=CG$10,$D18>=CG$10),FALSE),AND($D18<=CG$10,$E18>=CG$10)),IF(AND(AND($D18>=CG$10,$D18<CH$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CH$10,$C18< CI$10),AND($D18>=CH$10,$D18<CI$10),AND($E18>=CH$10,$E18<CI$10),IF($C18<>0,AND($C18<=CH$10,$D18>=CH$10),FALSE),AND($D18<=CH$10,$E18>=CH$10)),IF(AND(AND($D18>=CH$10,$D18<CI$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CI$10,$C18< CJ$10),AND($D18>=CI$10,$D18<CJ$10),AND($E18>=CI$10,$E18<CJ$10),IF($C18<>0,AND($C18<=CI$10,$D18>=CI$10),FALSE),AND($D18<=CI$10,$E18>=CI$10)),IF(AND(AND($D18>=CI$10,$D18<CJ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CJ$10,$C18< CK$10),AND($D18>=CJ$10,$D18<CK$10),AND($E18>=CJ$10,$E18<CK$10),IF($C18<>0,AND($C18<=CJ$10,$D18>=CJ$10),FALSE),AND($D18<=CJ$10,$E18>=CJ$10)),IF(AND(AND($D18>=CJ$10,$D18<CK$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CK$10,$C18< CL$10),AND($D18>=CK$10,$D18<CL$10),AND($E18>=CK$10,$E18<CL$10),IF($C18<>0,AND($C18<=CK$10,$D18>=CK$10),FALSE),AND($D18<=CK$10,$E18>=CK$10)),IF(AND(AND($D18>=CK$10,$D18<CL$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CL$10,$C18< CM$10),AND($D18>=CL$10,$D18<CM$10),AND($E18>=CL$10,$E18<CM$10),IF($C18<>0,AND($C18<=CL$10,$D18>=CL$10),FALSE),AND($D18<=CL$10,$E18>=CL$10)),IF(AND(AND($D18>=CL$10,$D18<CM$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CM$10,$C18< CN$10),AND($D18>=CM$10,$D18<CN$10),AND($E18>=CM$10,$E18<CN$10),IF($C18<>0,AND($C18<=CM$10,$D18>=CM$10),FALSE),AND($D18<=CM$10,$E18>=CM$10)),IF(AND(AND($D18>=CM$10,$D18<CN$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CN$10,$C18< CO$10),AND($D18>=CN$10,$D18<CO$10),AND($E18>=CN$10,$E18<CO$10),IF($C18<>0,AND($C18<=CN$10,$D18>=CN$10),FALSE),AND($D18<=CN$10,$E18>=CN$10)),IF(AND(AND($D18>=CN$10,$D18<CO$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CO$10,$C18< CP$10),AND($D18>=CO$10,$D18<CP$10),AND($E18>=CO$10,$E18<CP$10),IF($C18<>0,AND($C18<=CO$10,$D18>=CO$10),FALSE),AND($D18<=CO$10,$E18>=CO$10)),IF(AND(AND($D18>=CO$10,$D18<CP$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CP$10,$C18< CQ$10),AND($D18>=CP$10,$D18<CQ$10),AND($E18>=CP$10,$E18<CQ$10),IF($C18<>0,AND($C18<=CP$10,$D18>=CP$10),FALSE),AND($D18<=CP$10,$E18>=CP$10)),IF(AND(AND($D18>=CP$10,$D18<CQ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CQ$10,$C18< CR$10),AND($D18>=CQ$10,$D18<CR$10),AND($E18>=CQ$10,$E18<CR$10),IF($C18<>0,AND($C18<=CQ$10,$D18>=CQ$10),FALSE),AND($D18<=CQ$10,$E18>=CQ$10)),IF(AND(AND($D18>=CQ$10,$D18<CR$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CR$10,$C18< CS$10),AND($D18>=CR$10,$D18<CS$10),AND($E18>=CR$10,$E18<CS$10),IF($C18<>0,AND($C18<=CR$10,$D18>=CR$10),FALSE),AND($D18<=CR$10,$E18>=CR$10)),IF(AND(AND($D18>=CR$10,$D18<CS$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CS$10,$C18< CT$10),AND($D18>=CS$10,$D18<CT$10),AND($E18>=CS$10,$E18<CT$10),IF($C18<>0,AND($C18<=CS$10,$D18>=CS$10),FALSE),AND($D18<=CS$10,$E18>=CS$10)),IF(AND(AND($D18>=CS$10,$D18<CT$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CT$10,$C18< CU$10),AND($D18>=CT$10,$D18<CU$10),AND($E18>=CT$10,$E18<CU$10),IF($C18<>0,AND($C18<=CT$10,$D18>=CT$10),FALSE),AND($D18<=CT$10,$E18>=CT$10)),IF(AND(AND($D18>=CT$10,$D18<CU$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CU$10,$C18< CV$10),AND($D18>=CU$10,$D18<CV$10),AND($E18>=CU$10,$E18<CV$10),IF($C18<>0,AND($C18<=CU$10,$D18>=CU$10),FALSE),AND($D18<=CU$10,$E18>=CU$10)),IF(AND(AND($D18>=CU$10,$D18<CV$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CV$10,$C18< CW$10),AND($D18>=CV$10,$D18<CW$10),AND($E18>=CV$10,$E18<CW$10),IF($C18<>0,AND($C18<=CV$10,$D18>=CV$10),FALSE),AND($D18<=CV$10,$E18>=CV$10)),IF(AND(AND($D18>=CV$10,$D18<CW$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CW$10,$C18< CX$10),AND($D18>=CW$10,$D18<CX$10),AND($E18>=CW$10,$E18<CX$10),IF($C18<>0,AND($C18<=CW$10,$D18>=CW$10),FALSE),AND($D18<=CW$10,$E18>=CW$10)),IF(AND(AND($D18>=CW$10,$D18<CX$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CX$10,$C18< CY$10),AND($D18>=CX$10,$D18<CY$10),AND($E18>=CX$10,$E18<CY$10),IF($C18<>0,AND($C18<=CX$10,$D18>=CX$10),FALSE),AND($D18<=CX$10,$E18>=CX$10)),IF(AND(AND($D18>=CX$10,$D18<CY$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CY$10,$C18< CZ$10),AND($D18>=CY$10,$D18<CZ$10),AND($E18>=CY$10,$E18<CZ$10),IF($C18<>0,AND($C18<=CY$10,$D18>=CY$10),FALSE),AND($D18<=CY$10,$E18>=CY$10)),IF(AND(AND($D18>=CY$10,$D18<CZ$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=CZ$10,$C18< DA$10),AND($D18>=CZ$10,$D18<DA$10),AND($E18>=CZ$10,$E18<DA$10),IF($C18<>0,AND($C18<=CZ$10,$D18>=CZ$10),FALSE),AND($D18<=CZ$10,$E18>=CZ$10)),IF(AND(AND($D18>=CZ$10,$D18<DA$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=DA$10,$C18< DB$10),AND($D18>=DA$10,$D18<DB$10),AND($E18>=DA$10,$E18<DB$10),IF($C18<>0,AND($C18<=DA$10,$D18>=DA$10),FALSE),AND($D18<=DA$10,$E18>=DA$10)),IF(AND(AND($D18>=DA$10,$D18<DB$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=DB$10,$C18< DC$10),AND($D18>=DB$10,$D18<DC$10),AND($E18>=DB$10,$E18<DC$10),IF($C18<>0,AND($C18<=DB$10,$D18>=DB$10),FALSE),AND($D18<=DB$10,$E18>=DB$10)),IF(AND(AND($D18>=DB$10,$D18<DC$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=DC$10,$C18< DD$10),AND($D18>=DC$10,$D18<DD$10),AND($E18>=DC$10,$E18<DD$10),IF($C18<>0,AND($C18<=DC$10,$D18>=DC$10),FALSE),AND($D18<=DC$10,$E18>=DC$10)),IF(AND(AND($D18>=DC$10,$D18<DD$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=DD$10,$C18< DE$10),AND($D18>=DD$10,$D18<DE$10),AND($E18>=DD$10,$E18<DE$10),IF($C18<>0,AND($C18<=DD$10,$D18>=DD$10),FALSE),AND($D18<=DD$10,$E18>=DD$10)),IF(AND(AND($D18>=DD$10,$D18<DE$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=DE$10,$C18< DF$10),AND($D18>=DE$10,$D18<DF$10),AND($E18>=DE$10,$E18<DF$10),IF($C18<>0,AND($C18<=DE$10,$D18>=DE$10),FALSE),AND($D18<=DE$10,$E18>=DE$10)),IF(AND(AND($D18>=DE$10,$D18<DF$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=DF$10,$C18< DG$10),AND($D18>=DF$10,$D18<DG$10),AND($E18>=DF$10,$E18<DG$10),IF($C18<>0,AND($C18<=DF$10,$D18>=DF$10),FALSE),AND($D18<=DF$10,$E18>=DF$10)),IF(AND(AND($D18>=DF$10,$D18<DG$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""},{"$f":"IF(OR(AND($C18>=DG$10,$C18< DH$10),AND($D18>=DG$10,$D18<DH$10),AND($E18>=DG$10,$E18<DH$10),IF($C18<>0,AND($C18<=DG$10,$D18>=DG$10),FALSE),AND($D18<=DG$10,$E18>=DG$10)),IF(AND(AND($D18>=DG$10,$D18<DH$10),$E18<>0),IF($F18=\"Fini\",\"Z\",\"Y\"),IF($F18=\"Fini\",\"Z\",\"X\")),\"\")","v":""}]
["Jalon (eu vert à la phase de conception)","CoPil","2021-08-23","2021-09-01",null,"Planifié",null,"","","","","","","","","","","","","","","","","","","","","","","","X","X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Conception",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AND($C20>=AF$10,$C20< AG$10),AND($D20>=AF$10,$D20<AG$10),AND($E20>=AF$10,$E20<AG$10),IF($C20<>0,AND($C20<=AF$10,$D20>=AF$10),FALSE),AND($D20<=AF$10,$E20>=AF$10)),IF(AND(AND($D20>=AF$10,$D20<AG$10),$E20<>0),IF($F20=\"Fini\",\"Z\",\"Y\"),IF($F20=\"Fini\",\"Z\",\"X\")),\"\")","v":"X"},"X","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 1",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 2","Mandant-e",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 3","Proj.Mgmt",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 4",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 5",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 6",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Jalon -(feu vert à la phase de réalisation)","Mandant-e",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Réalisation",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 1",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 2",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 3",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 4",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 5",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 6","Mandant-e",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Jalon (feu vert à la phase de déploiement)","Mandant-e",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Déploiement",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 1","Proj.Mgmt",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 2","Proj.Mgmt",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 3","Mandant-e",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 4",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 5","Proj.Mgmt",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Tâche 6","Proj.Mgmt",null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Jalon .- clôture du projet)","Mandant-e","2023-02-21","2023-03-21",null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Budget","index":3,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,0,30,4],[29,0,29,4],[1,0,1,1],[2,0,2,1],[5,4,5,5],[6,1,6,2]]}
[]
[]
["BUDGET"]
["(montants en CHF, TTC)"]
[]
["Projet : ",{"$f":"'Informations générales'!A6","v":"Nom du projet"},null,"Mandant-e :",{"$f":"'Informations générales'!B20","v":"Prénom, Nom"}]
["Chef-fe de projet :",{"$f":"'Informations générales'!B21","v":"Prénom, Nom"},null,"Budget prévisionnel","Coût réel","Différence"]
[null,null,null,{"$f":"SUBTOTAL(9,D10:D27)","v":12500},{"$f":"SUBTOTAL(9,E10:E27)","v":12600},{"$f":"SUBTOTAL(9,F10:F27)","v":200}]
[null,"Type","Justificatifs / Remarques"]
["Rubrique 1 (ex: mobilier, informatique, frais d'études, communication etc.)",null,null,{"$f":"SUBTOTAL(9,D11:D12)","v":7000},{"$f":"SUBTOTAL(9,E11:E12)","v":7600},{"$f":"E10-D10","v":600}]
[null,"Campagne de com.","Création de flyers",4000,4500,{"$f":"E11-D11","v":500}]
[null,null,"Impression des flyers",3000,3100,{"$f":"E12-D12","v":100}]
[]
["Rubrique 2",null,null,{"$f":"SUBTOTAL(9,D15:D18)","v":5500},{"$f":"SUBTOTAL(9,E15:E18)","v":5000},{"$f":"E14-D14","v":-500}]
[null,null,null,1500,1000,{"$f":"E15-D15","v":-500}]
[null,null,null,4000,4000,{"$f":"E16-D16","v":0}]
[null,null,null,0,0,{"$f":"E17-D17","v":0}]
[null,null,null,0,0,0]
[]
["Rubrique 3",null,null,{"$f":"SUBTOTAL(9,D21:D23)","v":0},{"$f":"SUBTOTAL(9,E21:E23)","v":0},{"$f":"E20-D20","v":0}]
[null,null,null,0,0,{"$f":"E21-D21","v":0}]
[null,null,null,0,0,{"$f":"E22-D22","v":0}]
[null,null,null,0,0,{"$f":"E23-D23","v":0}]
[]
["Rubrique 4",null,null,{"$f":"SUBTOTAL(9,D26:D27)","v":0},{"$f":"SUBTOTAL(9,E26:E27)","v":0},{"$f":"E25-D25","v":0}]
[null,null,null,0,0,{"$f":"E26-D26","v":0}]
[null,null,null,0,0,{"$f":"E27-D27","v":0}]
[null,null,"TOTAL",{"$f":"D25+D20+D14+D10","v":12500},{"$f":"E25+E20+E14+E10","v":12600},100]
[]
["INSTRUCTION"]
["- Les cellules vertes sont automatiquement calculées"]
["- Utiliser copier/coller pour ajouter des lignes de budget / ne pas oublier de copier/coller les formules dans les lignes ajoutées"]

{"sheet":"Registre des risques","index":4,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,22,12],[21,0,21,5],[8,5,9,7],[4,0,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
[]
[]
["REGISTRE DES RISQUES"]
[]
["Evaluation du risque \n(probabilité d'incidence)",null,null,"Evaluation du risque \n(gravité de l'impact)","Tendance du risque \n(en régression / stable / en augmentation)"]
[1,"Faible",null,"Faible"]
[2,"Moyen",null,"Moyen","↘"]
[3,"Elevé",null,"Fort","→"]
[4,"Très élevé",null,"Critique","↗","Impacts sur :"]
[]
["ID","Etat","Identifié le","Description des risques","Conséquences","Coûts","Délais","Livrables","Probabilité","Impact","Séverité","Tendance","Mesures"]
["R1","actif",null,"Mauvaise météo","- Pas de construction possible","CHF 2K","6 sem. de retard","pas d'impact sur le livrable",3,3,{"$f":"I12*J12","v":9},"↘","M1 : rattraper le retard perdu sur les phases ultérieures. Le cas échéant informer l'ensemble des parties prenantes pour réviser le planning de mise en oeuvre\n"]
["R2","inactif",null,null,null,null,null,null,null,null,{"$f":"I13*J13","v":0}]
["R3","inactif",null,null,null,null,null,null,null,null,0]
["R4","inactif",null,null,null,null,null,null,null,null,0]
["R5","inactif",null,null,null,null,null,null,null,null,0]
["R6","inactif",null,null,null,null,null,null,null,null,{"$f":"I17*J17","v":0}]
["R7","inactif",null,null,null,null,null,null,null,null,0]
["R8","inactif",null,null,null,null,null,null,null,null,0]
["R9","inactif",null,null,null,null,null,null,null,null,0]
[]
["INFORMATION"]
["Un risque (R) est considéré comme majeur dès qu'il atteint une sévérité de 9. Des mesures (M) sont alors immédiatement nécessaires."]

{"sheet":"Résultats","index":5,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
[]
[]
["RÉSULTATS"]
[]
["Nr.","Résultats","Personnes responsables pour approbation","Indicateurs d'acceptation","Remarques Qualité/Test","Etat"]
[1,"[Produits, services, documents... créés pendant le projet]","[nom ou foncton]","[Lister les indicateurs de validation correpondant au résultats]","[Approuvé/ Refusé / Renvoyé avec commentaires, suggestions]"]
[2,"Processus d'orientation client","CoPiL","1. Augmentation de la résolution des problèmes au 1er contact\n\n2. Durée de traitement des demandes\n\n3. Augmentation de la satisfaction client (sur base de feedback)\n","1. Les personnes de contact doivent encore étendre leur champs de compétences dans la résolution de problèmes de base\n2. Les demandes sont traitées plus rapidement avec la suppression d'étapes de validation redondantes du processus\n3. Le taux de satisfaction a légèrement augmenté lors de la phase test","testé"]
[3,null,null,null,null,"accepté"]
[4,null,null,null,null,"refusé"]
[5,null,null,null,null,"renvoyé"]
[6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"planifié"]
[null,null,null,null,null,"testé"]
[null,null,null,null,null,"accepté"]
[null,null,null,null,null,"refusé"]
[null,null,null,null,null,"renvoyé"]

{"sheet":"Changement","index":6,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[4,0,5,0],[4,1,5,1],[4,7,5,7],[4,8,5,8]]}
[]
[]
["CHANGEMENT DE PÉRIMÈTRE (objectifs et livrables également)"]
[]
["Nr.","Date","Description","Impact",null,null,null,"Remarques","Etat"]
[null,null,null,"Perimétre","Délai","Coûts","Autres"]
[1,"JJ.MM.AAAA","Revoir le périmètre du projet compte tenu de la nouvelle loi sur la santé cantonale","lié avec d'autres projets","Retard de 2 mois sur la livraison de l'organisation","10 000 CHF","na","Avertir le comité de pilotage","Réunion à confirmer, mandant informé"]
[2]
[3]
[4]
[5]
[6]
[7]
[]
["INSTRUCTION"]
["Relater tout changement du perimètre du projet ayant des conséquences sur les délais, coûts et ressources."]
[]
["Exemple d'état: "]
["CoPil informé",null,"Le CoPil a été informé du changement et de l'impat sur le projet. Documenter le feedbak dans le champs remarque."]
["CoPil approuvé",null,"Le CoPil a approuvé le changement et les impacts sur le projet."]
["Fait",null,"Après approbation du COPil, le changement a été mis en place."]

{"sheet":"Réunions","index":7,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
[]
[]
["RÉUNIONS (objectifs et livrables également)"]
[]
["Date","Type de réunion","Présents","Excusés","Agenda","Informations / Décisions / \nAutres points "]
["2021-04-22","Réunion organisation","Prénom, Nom / Prénom, Nom /","Prénom, Nom / Prénom, Nom /","- revue des actions de réorganisation","Information aux membres du CoPil\nValidaltion des actions proposées par le mandant"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["INFORMATION"]
["Lorsqu'un projet s'étale sur une longue période, il est utile de référencer les principales réunions et notamment les décisions prises par les participant-e-s."]

{"sheet":"Matrice de responsabilités","index":8,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[]
[]
["MATRICE DE RESPONSABILITÉS (RACI)"]
[]
["                                  Roles\n\n\nTàches","Mandant-e","Chef-fe de projet / programme","Spécialiste","Prestataire","Autre: spécifier"]
["Tâche 1","R","A","A","I"]
["Tâche 2"]
["Tâche 3"]
["Tâche 4"]
["Tâche 5"]
["Tâche 6"]
["Tâche 7"]
["Tâche 8"]
["Tâche 9"]
[]
["UTILISATION"]
["- Ajouter les parties prenantes en lien avec le projet"]
["- Ajouter les tâches ou domaines en rapport avec le projet"]
[]
["Légende:"]
["R","Décider","Personne qui décide d'une action/tâche"]
["A","Exécuter","Personnes exécutants une action/tâche"]
["C","Consulter","Personnes à consulter"]
["I","Informer","Personnes à informer"]