{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Liste des Onglets","TDB","DonnéesUtiles","NDC","Listes","Q","C&D","QCDR","Guide_support","R","Format_A3","RACI","Objectifs","Analyse_PP","Plan_DOC","Plan_Comm","BilanTemps","SADT_Modèle","PCO","Lexique","Plan_Collecte","Couleurs","N+1","LOG","Tables"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":22,"comments":8,"pivot_tables":1},"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":"Liste des Onglets","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Etape","Nom","Lien vers la Feuille","Description"]
[null,"TDB","TDB!A1","Tableau de Bord"]
[null,"C&D","C&D'!A1","Collectes et Indicateurs C (Couts) et D (Délais)"]
[null,"R","R'!A1","Collecte et Indicateur R (Risque)"]
[null,"Q","Q!A1","Collecte et Indicateur Q (Qualité)"]
[null,"RACI","RACI!A1","RACI (Planification et Plan de Communication)"]
[null,"Analyse_PP","Analyse_PP!A1","Analyse des Parties Prenantes"]
[null,"Plan_Comm","Plan_Comm!A1","Plan de Communication"]

{"sheet":"TDB","index":1,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,4,9,4],[3,13,3,14],[20,13,20,14],[27,13,27,14],[29,5,31,9],[1,5,3,5],[1,6,3,9],[8,5,9,6]]}
[]
[null,null,null,null,null,{"$f":"DonnéesUtiles!A16","v":"Code_Projet"},{"$f":"DonnéesUtiles!B16","v":"<titre du projet>"}]
[null,null,"Phase actuelle","Fin prévue ",null,null,null,null,null,null,null,"Date"]
[null,null,{"$f":"DonnéesUtiles!$G$9","v":"Décider"},{"$f":"VLOOKUP(C4,DonnéesUtiles!C22:E31,3,FALSE)","v":"00:00:00"},null,null,null,null,null,null,null,"2026-03-01",null,"Equipe projet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I46","v":"Chef(s) de Projet"},{"$f":"DonnéesUtiles!J46","v":"Fonction"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I47","v":" "},{"$f":"DonnéesUtiles!J47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I48","v":" "},{"$f":"DonnéesUtiles!J48","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I49","v":"Pilote(s)"},{"$f":"DonnéesUtiles!J49","v":"Fonction"}]
[null,null,null,null,{"$f":"DonnéesUtiles!D9","v":3},{"$f":"VLOOKUP(E9,Tables!$A$1:$B$9,2,FALSE)","v":"Initialisé"},null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I50","v":"(Aucun)"},{"$f":"DonnéesUtiles!J50","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I51","v":" "},{"$f":"DonnéesUtiles!J51","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I52","v":"Expert(s)"},{"$f":"DonnéesUtiles!J52","v":"Fonction"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I53","v":"(Aucun)"},{"$f":"DonnéesUtiles!J53","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I54","v":0},{"$f":"DonnéesUtiles!J54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I55","v":0},{"$f":"DonnéesUtiles!J55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I56","v":0},{"$f":"DonnéesUtiles!J56","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I57","v":0},{"$f":"DonnéesUtiles!J57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I58","v":0},{"$f":"DonnéesUtiles!J58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I59","v":0},{"$f":"DonnéesUtiles!J59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!I60","v":0},{"$f":"DonnéesUtiles!J60","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre d'Actions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"au Total :",{"$f":"COUNTIF(Q!L:L,\"> \")-1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"en Cours :",{"$f":"COUNTIF(Q!L:L,\"En Cours\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"à Attribuer :",{"$f":"O22-O25-COUNTIF(Q!L:L,\"En Cours\")-COUNTIF(Q!L:L,\"Close\")-COUNTIF(Q!L:L,\"Attribuée\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"en Retard :",{"$f":"COUNTIF(Q!L:L,\"En Retard\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FPY des Closes :",{"$f":"DonnéesUtiles!H9","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Jalon (PRJ3) à venir"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"En fin de Phase :",{"$f":"DonnéesUtiles!J30","v":"Terminer"}]
[null,null,null,null,null,"<commentaire du chef de projet>",null,null,null,null,null,null,null,"Échéance :",{"$f":"DonnéesUtiles!I30","v":"(Si Applicable)"}]

{"sheet":"DonnéesUtiles","index":2,"n_rows":63,"n_cols":22,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["Données uniquement présentes dans le Pilotage de la Gouvernance (parce que pourraient évoluer indépendamment)"]
["Version :","0.82",null,"Gouvern.","Comité de Projet","Matrice"]
[null,null,null,null,"PRJ3","PS"]
[]
[]
["Données de Sortie du Fichier"]
[]
[null,"Nom du Projet",null,"Statut","Statut_TXT","Avancement","Phase\n(en cours)","Q(Qualité)","C(Coût)","D(Délai)","R(Risque)","Mot du Chef de Projet",null,"Mise à Jour"]
[null,{"$f":"TDB!G2","v":"<titre du projet>"},null,{"$f":"IF(K9>=75%,1,VLOOKUP(DonnéesUtiles!F9,Tables!G1:H12,2,FALSE))","v":3},{"$f":"TDB!F9","v":"Initialisé"},{"$f":"MAX('C&D'!K:K,0)","v":0},{"$f":"VLOOKUP(DonnéesUtiles!$F$9,Tables!$E$1:$F$12,2,FALSE)","v":"Décider"},{"$f":"IFERROR((COUNTIF(Q!L:L,\"Close\")-(COUNTIF(Q!K:K,\">0\") + COUNTIF(Q!K:K,\"> \")-1))/COUNTIF(Q!L:L,\"Close\"),100%)","v":1},{"$f":"IFERROR(L18/L20,0%)","v":0},{"$f":"IFERROR(F9/K31,200%)","v":0},{"$f":"IFERROR(MAX('R'!S:S),0%)","v":0},{"$f":"TDB!F30","v":"<commentaire du chef de projet>"},null,{"$f":"TDB!L4","v":"2026-03-01"}]
[null,"De TDB!G2",null,null,"De TDB!F9","De C&D!D","Calculé ici","Calculé ici","Calculé ici","Calculé ici","Calculé ici","De TDB!F30",null,"De TDB!L4"]
[]
[]
["Données Issues de l'onglet \"Node de Cadrage\" :",null,null,null,null,"A renseigner à la Main dans un Premier temps"]
[]
["Code Projet",null,"Initiateur",null,null,null,null,null,null,null,null,"Budget (h)"]
[{"$f":"NDC!F5","v":"Code_Projet"},{"$f":"IFERROR(LEFT(NDC!E8,FIND(CHAR(10),NDC!E8)-1),\"<titre du projet>\")","v":"<titre du projet>"},{"$f":"NDC!D4","v":0},null,null,null,null,null,null,null,null,{"$f":"NDC!B25","v":0}]
["En F2"]
[null,null,null,null,null,null,null,null,null,null,"Consommation :",{"$f":"SUM(Q23:Q30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Au :",{"$f":"TDB!L4","v":"2026-03-01"},{"$f":"MAX('C&D'!A:A)","v":"00:00:00"}]
[null,"Que se passera-t-il avec 1 phase (ou 2) en moins? ",null,null,null,null,null,null,null,null,"Prévisionnel :",{"$f":"IFERROR((L19-D23+1)/(I31-D23+1)*L30,0)","v":0}]
[]
["BudgetMax","Jalon","Phase","Début","Fin","Fini ?","Prochains","Phase","Date Prochain","Nom Phase","Phase Prévue","Prévisionnel","Par Phase","Par Phase","debut","fin","Temps Effectif","Fin Effective","Début Effectif","Phase","Objectif","Effectif"]
[{"$f":"IFERROR(E23-D23+1,0)","v":1},{"$f":"IF(NDC!F37 <> \"¨\",\"Oui\",IF(C23 = \"Communiquer\",\"Oui\",\"Non\"))","v":"Non"},{"$f":"NDC!B37","v":"Définir"},{"$f":"NDC!D37","v":"00:00:00"},{"$f":"NDC!E37","v":"00:00:00"},{"$f":"IF(ISERROR(VLOOKUP($C23 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B23=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Non"},{"$f":"IF(ISERROR(VLOOKUP($C23 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B23=\"Oui\",$E23,\"\"),\"\")","v":""},{"$f":"C23","v":"Définir"},null,null,{"$f":"IFERROR(IF(SUM(K24:K$30)>0,\"\",IF(D23<TDB!L$4,VLOOKUP(H23,Tables!$F$1:$G$12,2,FALSE),0)),0)","v":""},{"$f":"SUM(A$23:A23)/$A$31*$L$16","v":0},{"$f":"IFERROR(VLOOKUP(C23,Tables!F:G,2,FALSE),\"\")","v":1},{"$f":"L23","v":0},{"$f":"D23","v":"00:00:00"},{"$f":"E23","v":"00:00:00"},{"$f":"SUMIF('C&D'!K:K,M23,'C&D'!$G:$G)","v":0},{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M23,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M23,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""},{"$f":"IF(MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H23)<>0,MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H23),\"\")","v":""},{"$f":"H23","v":"Définir"},{"$f":"SUM(N23:N$23)","v":0},{"$f":"SUM(Q23:Q$23)","v":0}]
[{"$f":"IFERROR(E24-D24+1,0)","v":1},{"$f":"IF(NDC!F38 <> \"¨\",\"Oui\",IF(C24 = \"Communiquer\",\"Oui\",\"Non\"))","v":"Non"},{"$f":"NDC!B38","v":"Mesurer"},{"$f":"NDC!D38","v":"00:00:00"},{"$f":"NDC!E38","v":"00:00:00"},{"$f":"IF(ISERROR(VLOOKUP($C24 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B24=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Non"},{"$f":"IF(ISERROR(VLOOKUP($C24 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B24=\"Oui\",$E24,\"\"),\"\")","v":""},{"$f":"C24","v":"Mesurer"},null,null,{"$f":"IFERROR(IF(SUM(K25:K$30)>0,\"\",IF(D24<TDB!L$4,VLOOKUP(H24,Tables!$F$1:$G$12,2,FALSE),0)),0)","v":""},{"$f":"SUM(A$23:A24)/$A$31*$L$16","v":0},{"$f":"IFERROR(VLOOKUP(C24,Tables!F:G,2,FALSE),\"\")","v":2},{"$f":"L24-L23","v":0},{"$f":"D24","v":"00:00:00"},"00:00:00",{"$f":"SUMIF('C&D'!K:K,M24,'C&D'!$G:$G)","v":0},{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M24,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M24,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""},{"$f":"IF(MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H24)<>0,MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H24),\"\")","v":""},{"$f":"H24","v":"Mesurer"},{"$f":"SUM(N$23:N24)","v":0},{"$f":"SUM(Q$23:Q24)","v":0}]
[1,{"$f":"IF(NDC!F39 <> \"¨\",\"Oui\",IF(C25 = \"Communiquer\",\"Oui\",\"Non\"))","v":"Non"},{"$f":"NDC!B39","v":"Analyser"},{"$f":"NDC!D39","v":"00:00:00"},{"$f":"NDC!E39","v":"00:00:00"},{"$f":"IF(ISERROR(VLOOKUP($C25 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B25=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Non"},{"$f":"IF(ISERROR(VLOOKUP($C25 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B25=\"Oui\",$E25,\"\"),\"\")","v":""},"Analyser",null,null,{"$f":"IFERROR(IF(SUM(K26:K$30)>0,\"\",IF(D25<TDB!L$4,VLOOKUP(H25,Tables!$F$1:$G$12,2,FALSE),0)),0)","v":""},{"$f":"SUM(A$23:A25)/$A$31*$L$16","v":0},{"$f":"IFERROR(VLOOKUP(C25,Tables!F:G,2,FALSE),\"\")","v":3},0,"00:00:00","00:00:00",{"$f":"SUMIF('C&D'!K:K,M25,'C&D'!$G:$G)","v":0},{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M25,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M25,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""},{"$f":"IF(MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H25)<>0,MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H25),\"\")","v":""},"Analyser",{"$f":"SUM(N$23:N25)","v":0},{"$f":"SUM(Q$23:Q25)","v":0}]
[1,{"$f":"IF(NDC!F40 <> \"¨\",\"Oui\",IF(C26 = \"Communiquer\",\"Oui\",\"Non\"))","v":"Non"},{"$f":"NDC!B40","v":"Innover"},{"$f":"NDC!D40","v":"00:00:00"},{"$f":"NDC!E40","v":"00:00:00"},{"$f":"IF(ISERROR(VLOOKUP($C26 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B26=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Non"},{"$f":"IF(ISERROR(VLOOKUP($C26 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B26=\"Oui\",$E26,\"\"),\"\")","v":""},"Innover",null,null,{"$f":"IFERROR(IF(SUM(K27:K$30)>0,\"\",IF(D26<TDB!L$4,VLOOKUP(H26,Tables!$F$1:$G$12,2,FALSE),0)),0)","v":""},{"$f":"SUM(A$23:A26)/$A$31*$L$16","v":0},{"$f":"IFERROR(VLOOKUP(C26,Tables!F:G,2,FALSE),\"\")","v":4},0,"00:00:00","00:00:00",{"$f":"SUMIF('C&D'!K:K,M26,'C&D'!$G:$G)","v":0},{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M26,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M26,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""},{"$f":"IF(MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H26)<>0,MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H26),\"\")","v":""},"Innover",{"$f":"SUM(N$23:N26)","v":0},{"$f":"SUM(Q$23:Q26)","v":0}]
[1,{"$f":"IF(NDC!F41 <> \"¨\",\"Oui\",IF(C27 = \"Communiquer\",\"Oui\",\"Non\"))","v":"Non"},{"$f":"NDC!B41","v":"Contrôler"},{"$f":"NDC!D41","v":"00:00:00"},{"$f":"NDC!E41","v":"00:00:00"},{"$f":"IF(ISERROR(VLOOKUP($C27 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B27=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Non"},{"$f":"IF(ISERROR(VLOOKUP($C27 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B27=\"Oui\",$E27,\"\"),\"\")","v":""},"Contrôler",null,null,{"$f":"IFERROR(IF(SUM(K28:K$30)>0,\"\",IF(D27<TDB!L$4,VLOOKUP(H27,Tables!$F$1:$G$12,2,FALSE),0)),0)","v":5},{"$f":"SUM(A$23:A27)/$A$31*$L$16","v":0},{"$f":"IFERROR(VLOOKUP(C27,Tables!F:G,2,FALSE),\"\")","v":5},0,"00:00:00","00:00:00",{"$f":"SUMIF('C&D'!K:K,M27,'C&D'!$G:$G)","v":0},{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M27,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M27,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""},{"$f":"IF(MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H27)<>0,MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H27),\"\")","v":""},"Contrôler",{"$f":"SUM(N$23:N27)","v":0},{"$f":"SUM(Q$23:Q27)","v":0}]
[0,{"$f":"IF(NDC!F42 <> \"¨\",\"Oui\",IF(C28 = \"Communiquer\",\"Oui\",\"Non\"))","v":"Non"},{"$f":"NDC!B42","v":"Standardiser"},{"$f":"IF(NDC!D42=0,\"\",NDC!D42)","v":""},{"$f":"IF(NDC!E42=0,\"\",NDC!E42)","v":""},{"$f":"IF(ISERROR(VLOOKUP($C28 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B28=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Non"},{"$f":"IF(ISERROR(VLOOKUP($C28 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B28=\"Oui\",$E28,\"\"),\"\")","v":""},"Standardiser",null,null,{"$f":"IFERROR(IF(SUM(K29:K$30)>0,\"\",IF(D28<TDB!L$4,VLOOKUP(H28,Tables!$F$1:$G$12,2,FALSE),0)),0)","v":0},{"$f":"SUM(A$23:A28)/$A$31*$L$16","v":0},{"$f":"IFERROR(VLOOKUP(C28,Tables!F:G,2,FALSE),\"\")","v":6},0,"","",{"$f":"SUMIF('C&D'!K:K,M28,'C&D'!$G:$G)","v":0},{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M28,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M28,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""},{"$f":"IF(MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H28)<>0,MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H28),\"\")","v":""},"Standardiser",{"$f":"SUM(N$23:N28)","v":0},{"$f":"SUM(Q$23:Q28)","v":0}]
[0,{"$f":"IF(NDC!F43 <> \"¨\",\"Oui\",IF(C29 = \"Communiquer\",\"Oui\",\"Non\"))","v":"Non"},{"$f":"NDC!B43","v":"Clôturer"},{"$f":"IF(NDC!D43=0,\"\",NDC!D43)","v":""},{"$f":"IF(NDC!E43=0,\"\",NDC!E43)","v":""},{"$f":"IF(ISERROR(VLOOKUP($C29 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B29=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Non"},{"$f":"IF($C29=\"\",\"\",IF(ISERROR(VLOOKUP($C29 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B29=\"Oui\",$E29,\"\"),\"\"))","v":""},"Clôturer",null,null,{"$f":"IFERROR(IF(SUM(K30:K$30)>0,\"\",IF(D29<TDB!L$4,VLOOKUP(H29,Tables!$F$1:$G$12,2,FALSE),0)),0)","v":0},{"$f":"SUM(A$23:A29)/$A$31*$L$16","v":0},{"$f":"IFERROR(VLOOKUP(C29,Tables!F:G,2,FALSE),\"\")","v":7},0,"","",{"$f":"SUMIF('C&D'!K:K,M29,'C&D'!$G:$G)","v":0},{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M29,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M29,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""},{"$f":"IF(MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H29)<>0,MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H29),\"\")","v":""},"Clôturer",{"$f":"SUM(N$23:N29)","v":0},{"$f":"SUM(Q$23:Q29)","v":0}]
[0,{"$f":"IF(NDC!F44 <> \"¨\",\"Oui\",IF(C30 = \"Communiquer\",\"Oui\",\"Non\"))","v":"Oui"},{"$f":"NDC!B44","v":"Communiquer"},{"$f":"IF(NDC!D44=0,\"\",NDC!D44)","v":""},{"$f":"IF(NDC!E44=0,\"\",NDC!E44)","v":""},{"$f":"IF(ISERROR(VLOOKUP($C30 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B30=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Oui"},{"$f":"IF($C30=\"\",\"\",IF(ISERROR(VLOOKUP($C30 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B30=\"Oui\",$E30,\"\"),\"\"))","v":""},{"$f":"C30","v":"Communiquer"},{"$f":"IF(MIN(G23:G30)=0,\"(Si Applicable)\",MIN(G23:G30))","v":"(Si Applicable)"},{"$f":"IFERROR(VLOOKUP(I30,G23:H30,2,FALSE),\"Terminer\")","v":"Terminer"},{"$f":"IFERROR(IF(D30<TDB!L$4,VLOOKUP(H30,Tables!$F$1:$G$12,2,FALSE),0),0)","v":0},{"$f":"SUM(A$23:A30)/$A$31*$L$16","v":0},{"$f":"IFERROR(VLOOKUP(C30,Tables!F:G,2,FALSE),\"\")","v":8},{"$f":"L30-L29","v":0},{"$f":"D30","v":""},{"$f":"E30","v":""},{"$f":"SUMIF('C&D'!K:K,M30,'C&D'!$G:$G)","v":0},{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M30,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M30,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""},{"$f":"IF(MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H30)<>0,MIN_SI_ENS('C&D'!$A:$A,'C&D'!$I:$I,H30),\"\")","v":""},"Communiquer",{"$f":"SUM(N$23:N30)","v":0},{"$f":"SUM(Q$23:Q30)","v":0}]
[{"$f":"SUM(A23:A30)","v":5},null,"Décider",null,{"$f":"IF(F31=\"Finie\",R31,D23)","v":"00:00:00"},{"$f":"IF(ISERROR(VLOOKUP($C31 & \"_X\",'C&D'!$L:$L,1,FALSE)),IF($B31=\"Oui\",\"Oui\",\"Non\"),\"Finie\")","v":"Non"},null,"Dernière Phase:",{"$f":"VLOOKUP(J31,C22:E30,3,FALSE)","v":""},"Communiquer",{"$f":"MAX(K23:K30)","v":5},null,0,null,null,null,null,{"$f":"IF(SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M31,'C&D'!$H:$H,\"Fin de Phase\")<>0,SUMIFS('C&D'!$A:$A,'C&D'!$K:$K,M31,'C&D'!$H:$H,\"Fin de Phase\"),\"\")","v":""}]
[]
[null,"CDP","Pilote ","Expert"]
[null,{"$f":"NDC!E23","v":1},{"$f":"NDC!E24","v":0},{"$f":"NDC!E25","v":0}]
[]
["Chef de Projet",{"$f":"NDC!E31","v":0},{"$f":"NDC!F31","v":0},{"$f":"NDC!G31","v":0},{"$f":"NDC!H31","v":0},{"$f":"NDC!I31","v":0},{"$f":"NDC!J31","v":0},{"$f":"NDC!K31","v":0},{"$f":"NDC!L31","v":0},{"$f":"NDC!M31","v":0}]
[{"$f":"NDC!L4","v":" "},{"$f":"IF(AND(B36>\" \",NDC!E32=0),\" PNOM ?\",NDC!E32)","v":0},{"$f":"IF(AND(C36>\" \",NDC!F32=0),\" PNOM ?\",NDC!F32)","v":0},{"$f":"IF(AND(D36>\" \",NDC!G32=0),\" PNOM ?\",NDC!G32)","v":0},{"$f":"IF(AND(E36>\" \",NDC!H32=0),\" PNOM ?\",NDC!H32)","v":0},{"$f":"IF(AND(F36>\" \",NDC!I32=0),\" PNOM ?\",NDC!I32)","v":0},{"$f":"IF(AND(G36>\" \",NDC!J32=0),\" PNOM ?\",NDC!J32)","v":0},{"$f":"IF(AND(H36>\" \",NDC!K32=0),\" PNOM ?\",NDC!K32)","v":0},{"$f":"IF(AND(I36>\" \",NDC!L32=0),\" PNOM ?\",NDC!L32)","v":0},{"$f":"IF(AND(J36>\" \",NDC!M32=0),\" PNOM ?\",NDC!M32)","v":0}]
[{"$f":"VLOOKUP(A37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(I37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(J37,Listes!$C:$D,2,FALSE)","v":{"$error":"#N/A"}}]
[1.25,{"$f":"IF(LEFT(B36,1)=\"C\",1.5,IF(LEFT(B36,1)=\"P\",2.5,IF(LEFT(B36,1)=\"E\",3.5,\"\")))","v":""},{"$f":"IF(LEFT(C36,1)=\"C\",1.5,IF(LEFT(C36,1)=\"P\",2.5,IF(LEFT(C36,1)=\"E\",3.5,\"\")))","v":""},"","","","","","",""]
[]
[null,4,1,2,3,null,null,"Puis … Actualiser ce TCD !"]
[null,"Position","Titre","Nom","Fonction",null,null,"s'assurer du tri croissant en H46 … Je ferai une macro plus tard …"]
[1,{"$f":"INDEX($A$36:$K$39,B$41,$A43)","v":1.25},"Chef de Projet",{"$f":"IF(INDEX($A$36:$K$39,D$41,$A43)=0,\"\",INDEX($A$36:$K$39,D$41,$A43)) & IF(INDEX($A$36:$K$39,D$41,$A43)=\" PNOM ?\",REPT(\" \",A43),\"\")","v":" "},{"$f":"IFERROR(INDEX($A$36:$K$39,E$41,$A43),\"\")","v":""}]
[2,"",0,"",{"$f":"IFERROR(INDEX($A$36:$K$39,E$41,$A44),\"\")","v":""}]
[3,"",0,"","",{"$f":"REPT(\" \",2)","v":"  "}]
[4,"",0,"","",null,null,1,"Chef(s) de Projet","Fonction","(vide)"]
[5,"",0,{"$f":"IF(INDEX($A$36:$K$39,D$41,$A47)=0,\"\",INDEX($A$36:$K$39,D$41,$A47)) & IF(INDEX($A$36:$K$39,D$41,$A47)=\" PNOM ?\",REPT(\" \",A47),\"\")","v":""},"",null,null,1.25," ",null,"Chef de Projet"]
[6,"",0,{"$f":"IF(INDEX($A$36:$K$39,D$41,$A48)=0,\"\",INDEX($A$36:$K$39,D$41,$A48)) & IF(INDEX($A$36:$K$39,D$41,$A48)=\" PNOM ?\",REPT(\" \",A48),\"\")","v":""},"",null,null,1.99," "," ","interligne"]
[7,"",0,"","",null,null,2,"Pilote(s)","Fonction","(vide)"]
[8,"",0,"","",null,null,2.5,"(Aucun)"," ","(vide)"]
[9,"",0,"","",null,null,2.99," "," ","interligne"]
[10,"",0,"","",null,null,3,"Expert(s)","Fonction","(vide)"]
[null,1,null,"Chef(s) de Projet","Fonction",null,null,3.5,"(Aucun)"," ","(vide)"]
[null,2,null,"Pilote(s)","Fonction",null,null,null,null,null,0]
[null,3,null,"Expert(s)","Fonction"]
[null,1.99,"interligne"," "," "]
[null,2.99,"interligne"," "," "]
[2.5,{"$f":"IF(ISERROR(VLOOKUP($A58,$B$43:$B$52,1,FALSE)),$A58,\"\")","v":2.5},null,{"$f":"IF($B58<>\"\",\"(Aucun)\",\" \")","v":"(Aucun)"},{"$f":"IF($B58<>\"\",\" \",\" \")","v":" "}]
[3.5,{"$f":"IF(ISERROR(VLOOKUP($A59,$B$43:$B$52,1,FALSE)),$A59,\"\")","v":3.5},null,{"$f":"IF($B59<>\"\",\"(Aucun)\",\" \")","v":"(Aucun)"},{"$f":"IF($B59>0,\" \",\" \")","v":" "}]
[]
[]
[null,"Validation NDC :",{"$f":"IF(LEN(CONCATENATE(B63,C63,D63,E63,F63))>5,1,-1)","v":-1},null,null,null,"Non utilisé !"]
[null,{"$f":"NDC!D51","v":0},{"$f":"NDC!F51","v":0},{"$f":"NDC!H51","v":0},{"$f":"NDC!J51","v":0},{"$f":"NDC!L51","v":0}]

{"sheet":"NDC","index":3,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":true,"merged":[[48,13,50,13],[26,1,26,2],[27,1,27,2],[21,1,21,3],[9,1,13,2],[16,2,16,3],[17,2,17,3],[16,1,19,1],[18,2,18,3],[19,2,19,3],[15,2,15,3],[45,1,45,3],[45,4,45,12],[16,8,16,9],[17,4,17,5],[9,13,13,13],[16,13,19,13],[31,13,33,13],[48,5,48,6],[49,5,49,6],[6,1,6,12],[8,1,8,12],[14,1,14,12],[20,1,20,12],[25,6,27,12],[25,1,25,3],[19,4,19,5],[21,7,24,12],[15,10,15,11],[16,10,16,11],[19,8,19,9],[19,6,19,7],[16,4,16,5],[16,6,16,7],[48,9,48,10],[49,9,49,10],[50,9,50,10],[47,9,47,10],[50,7,50,8],[28,4,28,12],[40,1,40,2],[35,1,35,2],[29,1,29,12],[30,1,30,3],[34,1,34,12],[31,1,33,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[35,6,35,7],[0,11,0,12],[1,11,1,12],[2,11,2,12],[15,6,15,7],[3,3,3,4],[7,4,7,12],[7,1,7,3],[3,1,3,2],[3,9,3,10],[5,9,5,11],[4,9,4,11],[4,1,4,3],[5,1,5,3],[4,5,5,8],[2,5,3,8],[3,11,3,12],[48,1,50,1],[50,3,50,4],[47,3,47,4],[48,7,48,8],[44,1,44,12],[47,1,47,2],[46,1,46,12],[47,7,47,8],[49,11,49,12],[50,11,50,12],[48,11,48,12],[47,5,47,6],[48,3,48,4],[49,3,49,4],[50,5,50,6],[49,7,49,8],[43,1,43,2],[9,4,12,7],[9,9,12,12],[15,8,15,9],[19,10,19,11],[18,6,18,7],[18,8,18,9],[17,10,17,11],[18,10,18,11],[15,4,15,5],[17,6,17,7],[18,4,18,5],[17,8,17,9],[28,1,28,3],[42,1,42,2],[41,1,41,2]]}
[null,null,null,null,null,null,null,null,null,null,null,"ENR 230 "]
[null,null,null,null,null,null,null,null,null,null,null,"Ind C 10/02/2020  "]
[null,null,null,null,null,"Projet"]
[null,"Initiateur :",null,0,null,null,null,null,null,"Chef de Projet :",null," "]
[null,"Date de Début :",null,null,"00:00:00","Code_Projet",null,null,null,"Date de Début : ",null,null,"00:00:00"]
[null,"Date de Fin :",null,null,"00:00:00",null,null,null,null,"Date de Fin  :",null,null,"00:00:00"]
[]
[null,"Description du Projet\nContexte, enjeux, cible et contraintes temporelles.",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[null,"Périmètre(s)\nInclus ou Exclus du Projet, y compris, si applicables, les Processus, Clients, Parties Prenantes,  Produits, etc.",null,"þ",0,null,null,null,"þ",0]
[null,null,null,"Inclusion:",null,null,null,null,"Exclusion:"]
[]
[]
[null,null,null,"Site(s):","EINEA","LCO","OB","SELHA","Site(s):",0,0,0,0]
[]
[null,"Objectifs ","Indicateur",null,"Intitulé ",null,"Initial",null,"Objectif",null,"Cible",null,"U.M"]
[null,"\"Cible\" visée et Métriques impactés.","Principal",null,0,null,0,null,0,null,0,null,"Unité ?"]
[null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,"Dépenses Estimées",null,null,"Nombre","J / Sem","Coût Mat.",0]
[null,0,"k€","Chef",1,0,0]
[null,0,"Semaines","Pilote(s)",0,0,"Cout M/O"]
[null,0,"Heures","Expert(s)",0,0,0]
[null,"Gains Financiers Estimés",null,null,"k€ / An","R.O.I.",0]
[null,"… sur Projet:",null,"¨",0,0]
[null,"… après projet:",null,"¨",0,0]
[null,"Autres Gains Estimés\nNon valorisés: Humains (QVT),  Image de Marque, Robustesse du Processus, Maturité, etc.",null,null,0]
[]
[null,"Constitution de l'Equipe",null,null,0,0,0,0,0,0,0,0,0]
[null,"Par le Visa, le N+1 s'engage à rendre le membre concerné disponible pour la durée estimée.",null,"PNOM :",0,0,0,0,0,0,0,0,0]
[null,null,null,"son N+1 :",0,0,0,0,0,0,0,0,0]
[null,null,null,"Visa:",0,0,0,0,0,0,0,0,0]
[]
[null,"Phases",null,"Début","Fin","Jalon ?","Macro Planning"]
[null,"Définir",null,"00:00:00","00:00:00","¨"]
[null,"Mesurer",null,"00:00:00","00:00:00","¨"]
[null,"Analyser",null,"00:00:00","00:00:00","¨"]
[null,"Innover",null,"00:00:00","00:00:00","¨"]
[null,"Contrôler",null,"00:00:00","00:00:00","¨"]
[null,"Standardiser",null,"00:00:00","00:00:00","¨"]
[null,"Clôturer",null,"00:00:00","00:00:00","¨"]
[null,"Communiquer",null,"00:00:00","00:00:00","¨"]
[]
[null,"Autres Risques Principaux\nConnus, et qui sont déjà, ou devraient être, mis sous contrôle.",null,null,0]
[]
[null,"Validation",null,"Initiateur",null,"Chef de Projet",null,"(son) Responsable",null,"Gouvernance ",null,"Comité ?:","¨"]
[null,"Projet","PNOM:",0,null,0,null,0,null,0,null,0]
[null,null,"Date:","00:00:00",null,"00:00:00",null,"00:00:00",null,"00:00:00",null,"00:00:00"]
[null,null,"Visa:",0,null,0,null,0,null,0,null,0]

{"sheet":"Listes","index":4,"n_rows":174,"n_cols":6,"rows_kept":174,"cut":false,"hidden":true,"merged":[]}
["Unité ?","Membre ?"," PNOM ?",null,"Processus ?","Direction ?"]
["%","Pilote"," PNOM ?","Titre ?","DG (Diriger le Groupe)","Président"]
["ppm","Expert","AABDELFETTAH",null,"GRC (Gérer la Relation Client)","DDC (Direction Développement Commercial)"]
["DPMO","Chef_Adj.","AAFFANE",null,"GI (Gérer les Infrastructures)","DA (Direction Achats)"]
["k€/An",null,"AATBIR",null,"GRH (Gérer les Ressources Humaines)","DO (Direction Opérations)"]
["min/Unité",null,"ABRIODIN",null,"GRIC (Gérer les Ressources Informatiques et de Communication)","DI (Direction Ingineering)"]
["h/Jour",null,"ABRISARD",null,"MDE (Mettre à Disposition les Eléments)","DQ (Direction QHSSSE)"]
["Cpk",null,"ADATCHY",null,"PRL (Produire, Réparer & Livrer les Produits) ","DF (Direction Finances)"]
["Unité/Sem",null,"AGARWALANE",null,"RPS (Réaliser des Prestations de Service)","DRH (Direction Ressources Humaines)"]
["nombre Z",null,"AGAUDUCHON"]
["Jour",null,"AGILBERT"]
[null,null,"AKAKANI"]
[null,null,"ALEBLANC"]
[null,null,"ALEGUENNEC"]
[null,null,"AMAHE"]
[null,null,"AMARQUES"]
[null,null,"AMOUNIR"]
[null,null,"APLANCHENAUL"]
[null,null,"APORTAIS"]
[null,null,"APROVOST"]
[null,null,"BDURAND"]
[null,null,"BESNAULT","Alt. AC"]
[null,null,"BFERTUN"]
[null,null,"BGOINARD"]
[null,null,"BVASLIN"]
[null,null,"CBELLAY"]
[null,null,"CBONNEAU"]
[null,null,"CCHEVREL"]
[null,null,"CDRIENCOURT","Tech. AC"]
[null,null,"CDUNAND","Dir. Site"]
[null,null,"CELUARD"]
[null,null,"CFLOURIOT"]
[null,null,"CGROSBOIS"]
[null,null,"CGUILLEMOT"]
[null,null,"CJOUTEL"]
[null,null,"CMICHEL"]
[null,null,"CMOTAY"]
[null,null,"CPLOUZENNEC","Resp. Qualité Op."]
[null,null,"CPOIRIER"]
[null,null,"CSELLE","Dir. RH"]
[null,null,"CTROVALET","Chargé Accueil &VA"]
[null,null,"DESNAUD","Alt. AC"]
[null,null,"DMABIRE"]
[null,null,"DMORILLE","Resp. CdG"]
[null,null,"DOBEE"]
[null,null,"DORILLARD"]
[null,null,"DSAHUT"]
[null,null,"EBARBIER"]
[null,null,"ECADO"]
[null,null,"ECORBIN"]
[null,null,"EDEMAZEUX"]
[null,null,"EGUERRAULT"]
[null,null,"ELAPERDRIX"]
[null,null,"ELENOIR","Resp. SQP Groupe"]
[null,null,"EMENU"]
[null,null,"EMILET","Tech. Qualité/Process"]
[null,null,"ERIDHI"]
[null,null,"FDESOLLE","Tech. HSE"]
[null,null,"FJACOB","Tech. SQP Groupe"]
[null,null,"FLAUNAY"]
[null,null,"FLEBEAU"]
[null,null,"FMARIETTE","Dir. Dévl. Ccial"]
[null,null,"FMAUGENDRE"]
[null,null,"FMAURICE"]
[null,null,"FMOLLET"]
[null,null,"FRHOURDAOUI"]
[null,null,"FSELLIN"]
[null,null,"GBRAULT"]
[null,null,"GCHASSAT","Dir. QHSSE"]
[null,null,"GDELARUE"]
[null,null,"GGAUDIN"]
[null,null,"GRC (Gérer la Relation Client)","DDC (Direction Développement Commercial)"]
[null,null,"GROUSSEAU"]
[null,null,"GVILAIN"]
[null,null,"HBOULAL"]
[null,null,"HCORTYL"]
[null,null,"HHOUDMON","Resp. Qualité Sys."]
[null,null,"HLEGUERNIC","Resp. Perf. Fourn."]
[null,null,"HMEZIERE"]
[null,null,"HMEZIERES"]
[null,null,"IBOURROU"]
[null,null,"ILAUNAY"]
[null,null,"ILONCKE"]
[null,null,"IZUNINO"]
[null,null,"JBBUISSON","Président"]
[null,null,"JBNTAWUKIRUWABO","Expert Composants"]
[null,null,"JBOINET"]
[null,null,"JBOSCO"]
[null,null,"JEHUBERT"]
[null,null,"JFMAHE"]
[null,null,"JGATINEAU","Dir. Site"]
[null,null,"JLVERLHAC"]
[null,null,"JMBALE"]
[null,null,"JMCAVAREC"]
[null,null,"JORILLARD"]
[null,null,"JRICQUEBOURG"]
[null,null,"JSIMONEAU"]
[null,null,"KELOUAZZANI","Dir. Site"]
[null,null,"KGUILLEMOT"]
[null,null,"KGUILLEMOT/HCORTYL"]
[null,null,"LBONNAUD"]
[null,null,"LBROSSIER"]
[null,null,"LCASTELLIER"]
[null,null,"LDEVAUCHELLE"]
[null,null,"LHOCDE"]
[null,null,"LLEBRET","Tech. HSSE"]
[null,null,"LSEBIRE"]
[null,null,"LTHEIL","Resp. RH"]
[null,null,"LTHEULIER"]
[null,null,"LTHIBAULT","Tech. Qualité Op."]
[null,null,"LVERDIER"]
[null,null,"MADHAIM"]
[null,null,"MBLAES"]
[null,null,"MCHAIKHI"]
[null,null,"MCOLLIOU","Dir. Opérations"]
[null,null,"MDURAND"]
[null,null,"MLACHGAR"]
[null,null,"MLAHLALI"]
[null,null,"MLODE"]
[null,null,"MLOUIN"]
[null,null,"MMONNIER"]
[null,null,"MOUADDAF"]
[null,null,"MQUENEY"]
[null,null,"NCHARPENTIER"]
[null,null,"NFRAIHA"]
[null,null,"NHAMON"]
[null,null,"NHANIA"]
[null,null,"NJOUAN"]
[null,null,"NLAHROUR"]
[null,null,"NPEULEVEY","Dir. Ingineering"]
[null,null,"NSAINTYVES"]
[null,null,"NSANSON"]
[null,null,"NTHUAL"]
[null,null,"OLEMERCIER"]
[null,null,"PAS_A_PAS"]
[null,null,"PLEFEBVRE"]
[null,null,"PMASSELIN"]
[null,null,"PPAVAGEAU"]
[null,null,"PPELLOIE","Resp. Qualité Op."]
[null,null,"PSEJOURNE"]
[null,null,"PYCARRIOU"]
[null,null,"RBOULANGER","Tech. Qualité Sys."]
[null,null,"RHANSSENS"]
[null,null,"RJOUSSE"]
[null,null,"RLENDA"]
[null,null,"RPETIT"]
[null,null,"RREBBAJ"]
[null,null,"SBENARD"]
[null,null,"SCHANEL"]
[null,null,"SCHAPRON"]
[null,null,"SCOURNE"]
[null,null,"SCOURNE/FSELLIN"]
[null,null,"SESNAUX"]
[null,null,"SFATIEN"]
[null,null,"SFONTAINE"]
[null,null,"SGALNEIL"]
[null,null,"SIZMAOUEN"]
[null,null,"SLANGLOIS"]
[null,null,"SLECLERC"]
[null,null,"SREMAUD"]
[null,null,"SROUGER"]
[null,null,"STRICAULT"]
[null,null,"TBECQUET"]
[null,null,"TCHAUVIRE"]
[null,null,"TLEBLANC","Dir. Site"]
[null,null,"TPOTELLE"]
[null,null,"VBARRAIS"]
[null,null,"VBOUDET"]
[null,null,"VBRIQUET"]
[null,null,"VGILET"]
[null,null,"VLUCAS"]
[null,null,"VROUSSEAU"]
[null,null,"WBONSERGENT"]
[null,null,"ZHAMMI"]

{"sheet":"Q","index":5,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["N° d'Action","Source du déclenchement de l'action","Cause racine ou \nRisque ","Plan d'action","PNOM du Resp.","Gain Estimé","Date de Début","Date de fin prévue","Date de Fin","Justificatif d'Efficacité","N° d'action (si non efficace)","Statut Qualité",{"$f":"QCDR!F3","v":0.10003483733937224}]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I2>0,\"Close\",IF(AND(H2>0,H2<TDB!L$4),\"En Retard\",IF(AND(G2>0,G2<=TDB!L$4),\"En Cours\",IF(E2>\"\",\"Attribuée\",IF(D2>\"\",\"Définie\",IF(OR(C2>\"\",NOT(ISERROR(VLOOKUP(A2,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I3>0,\"Close\",IF(AND(H3>0,H3<TDB!L$4),\"En Retard\",IF(AND(G3>0,G3<=TDB!L$4),\"En Cours\",IF(E3>\"\",\"Attribuée\",IF(D3>\"\",\"Définie\",IF(OR(C3>\"\",NOT(ISERROR(VLOOKUP(A3,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I4>0,\"Close\",IF(AND(H4>0,H4<TDB!L$4),\"En Retard\",IF(AND(G4>0,G4<=TDB!L$4),\"En Cours\",IF(E4>\"\",\"Attribuée\",IF(D4>\"\",\"Définie\",IF(OR(C4>\"\",NOT(ISERROR(VLOOKUP(A4,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I5>0,\"Close\",IF(AND(H5>0,H5<TDB!L$4),\"En Retard\",IF(AND(G5>0,G5<=TDB!L$4),\"En Cours\",IF(E5>\"\",\"Attribuée\",IF(D5>\"\",\"Définie\",IF(OR(C5>\"\",NOT(ISERROR(VLOOKUP(A5,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I6>0,\"Close\",IF(AND(H6>0,H6<TDB!L$4),\"En Retard\",IF(AND(G6>0,G6<=TDB!L$4),\"En Cours\",IF(E6>\"\",\"Attribuée\",IF(D6>\"\",\"Définie\",IF(OR(C6>\"\",NOT(ISERROR(VLOOKUP(A6,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[6,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I7>0,\"Close\",IF(AND(H7>0,H7<TDB!L$4),\"En Retard\",IF(AND(G7>0,G7<=TDB!L$4),\"En Cours\",IF(E7>\"\",\"Attribuée\",IF(D7>\"\",\"Définie\",IF(OR(C7>\"\",NOT(ISERROR(VLOOKUP(A7,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[7,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I8>0,\"Close\",IF(AND(H8>0,H8<TDB!L$4),\"En Retard\",IF(AND(G8>0,G8<=TDB!L$4),\"En Cours\",IF(E8>\"\",\"Attribuée\",IF(D8>\"\",\"Définie\",IF(OR(C8>\"\",NOT(ISERROR(VLOOKUP(A8,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[8,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I9>0,\"Close\",IF(AND(H9>0,H9<TDB!L$4),\"En Retard\",IF(AND(G9>0,G9<=TDB!L$4),\"En Cours\",IF(E9>\"\",\"Attribuée\",IF(D9>\"\",\"Définie\",IF(OR(C9>\"\",NOT(ISERROR(VLOOKUP(A9,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[9,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I10>0,\"Close\",IF(AND(H10>0,H10<TDB!L$4),\"En Retard\",IF(AND(G10>0,G10<=TDB!L$4),\"En Cours\",IF(E10>\"\",\"Attribuée\",IF(D10>\"\",\"Définie\",IF(OR(C10>\"\",NOT(ISERROR(VLOOKUP(A10,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[10,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I11>0,\"Close\",IF(AND(H11>0,H11<TDB!L$4),\"En Retard\",IF(AND(G11>0,G11<=TDB!L$4),\"En Cours\",IF(E11>\"\",\"Attribuée\",IF(D11>\"\",\"Définie\",IF(OR(C11>\"\",NOT(ISERROR(VLOOKUP(A11,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[11,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12>0,\"Close\",IF(AND(H12>0,H12<TDB!L$4),\"En Retard\",IF(AND(G12>0,G12<=TDB!L$4),\"En Cours\",IF(E12>\"\",\"Attribuée\",IF(D12>\"\",\"Définie\",IF(OR(C12>\"\",NOT(ISERROR(VLOOKUP(A12,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[12,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I13>0,\"Close\",IF(AND(H13>0,H13<TDB!L$4),\"En Retard\",IF(AND(G13>0,G13<=TDB!L$4),\"En Cours\",IF(E13>\"\",\"Attribuée\",IF(D13>\"\",\"Définie\",IF(OR(C13>\"\",NOT(ISERROR(VLOOKUP(A13,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[13,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I14>0,\"Close\",IF(AND(H14>0,H14<TDB!L$4),\"En Retard\",IF(AND(G14>0,G14<=TDB!L$4),\"En Cours\",IF(E14>\"\",\"Attribuée\",IF(D14>\"\",\"Définie\",IF(OR(C14>\"\",NOT(ISERROR(VLOOKUP(A14,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[14,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I15>0,\"Close\",IF(AND(H15>0,H15<TDB!L$4),\"En Retard\",IF(AND(G15>0,G15<=TDB!L$4),\"En Cours\",IF(E15>\"\",\"Attribuée\",IF(D15>\"\",\"Définie\",IF(OR(C15>\"\",NOT(ISERROR(VLOOKUP(A15,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[15,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I16>0,\"Close\",IF(AND(H16>0,H16<TDB!L$4),\"En Retard\",IF(AND(G16>0,G16<=TDB!L$4),\"En Cours\",IF(E16>\"\",\"Attribuée\",IF(D16>\"\",\"Définie\",IF(OR(C16>\"\",NOT(ISERROR(VLOOKUP(A16,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[16,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I17>0,\"Close\",IF(AND(H17>0,H17<TDB!L$4),\"En Retard\",IF(AND(G17>0,G17<=TDB!L$4),\"En Cours\",IF(E17>\"\",\"Attribuée\",IF(D17>\"\",\"Définie\",IF(OR(C17>\"\",NOT(ISERROR(VLOOKUP(A17,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[17,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I18>0,\"Close\",IF(AND(H18>0,H18<TDB!L$4),\"En Retard\",IF(AND(G18>0,G18<=TDB!L$4),\"En Cours\",IF(E18>\"\",\"Attribuée\",IF(D18>\"\",\"Définie\",IF(OR(C18>\"\",NOT(ISERROR(VLOOKUP(A18,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[18,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I19>0,\"Close\",IF(AND(H19>0,H19<TDB!L$4),\"En Retard\",IF(AND(G19>0,G19<=TDB!L$4),\"En Cours\",IF(E19>\"\",\"Attribuée\",IF(D19>\"\",\"Définie\",IF(OR(C19>\"\",NOT(ISERROR(VLOOKUP(A19,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[19,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I20>0,\"Close\",IF(AND(H20>0,H20<TDB!L$4),\"En Retard\",IF(AND(G20>0,G20<=TDB!L$4),\"En Cours\",IF(E20>\"\",\"Attribuée\",IF(D20>\"\",\"Définie\",IF(OR(C20>\"\",NOT(ISERROR(VLOOKUP(A20,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[20,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I21>0,\"Close\",IF(AND(H21>0,H21<TDB!L$4),\"En Retard\",IF(AND(G21>0,G21<=TDB!L$4),\"En Cours\",IF(E21>\"\",\"Attribuée\",IF(D21>\"\",\"Définie\",IF(OR(C21>\"\",NOT(ISERROR(VLOOKUP(A21,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[21,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I22>0,\"Close\",IF(AND(H22>0,H22<TDB!L$4),\"En Retard\",IF(AND(G22>0,G22<=TDB!L$4),\"En Cours\",IF(E22>\"\",\"Attribuée\",IF(D22>\"\",\"Définie\",IF(OR(C22>\"\",NOT(ISERROR(VLOOKUP(A22,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[22,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I23>0,\"Close\",IF(AND(H23>0,H23<TDB!L$4),\"En Retard\",IF(AND(G23>0,G23<=TDB!L$4),\"En Cours\",IF(E23>\"\",\"Attribuée\",IF(D23>\"\",\"Définie\",IF(OR(C23>\"\",NOT(ISERROR(VLOOKUP(A23,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[23,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I24>0,\"Close\",IF(AND(H24>0,H24<TDB!L$4),\"En Retard\",IF(AND(G24>0,G24<=TDB!L$4),\"En Cours\",IF(E24>\"\",\"Attribuée\",IF(D24>\"\",\"Définie\",IF(OR(C24>\"\",NOT(ISERROR(VLOOKUP(A24,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[24,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I25>0,\"Close\",IF(AND(H25>0,H25<TDB!L$4),\"En Retard\",IF(AND(G25>0,G25<=TDB!L$4),\"En Cours\",IF(E25>\"\",\"Attribuée\",IF(D25>\"\",\"Définie\",IF(OR(C25>\"\",NOT(ISERROR(VLOOKUP(A25,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[25,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I26>0,\"Close\",IF(AND(H26>0,H26<TDB!L$4),\"En Retard\",IF(AND(G26>0,G26<=TDB!L$4),\"En Cours\",IF(E26>\"\",\"Attribuée\",IF(D26>\"\",\"Définie\",IF(OR(C26>\"\",NOT(ISERROR(VLOOKUP(A26,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[26,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I27>0,\"Close\",IF(AND(H27>0,H27<TDB!L$4),\"En Retard\",IF(AND(G27>0,G27<=TDB!L$4),\"En Cours\",IF(E27>\"\",\"Attribuée\",IF(D27>\"\",\"Définie\",IF(OR(C27>\"\",NOT(ISERROR(VLOOKUP(A27,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[27,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I28>0,\"Close\",IF(AND(H28>0,H28<TDB!L$4),\"En Retard\",IF(AND(G28>0,G28<=TDB!L$4),\"En Cours\",IF(E28>\"\",\"Attribuée\",IF(D28>\"\",\"Définie\",IF(OR(C28>\"\",NOT(ISERROR(VLOOKUP(A28,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[28,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I29>0,\"Close\",IF(AND(H29>0,H29<TDB!L$4),\"En Retard\",IF(AND(G29>0,G29<=TDB!L$4),\"En Cours\",IF(E29>\"\",\"Attribuée\",IF(D29>\"\",\"Définie\",IF(OR(C29>\"\",NOT(ISERROR(VLOOKUP(A29,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[29,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I30>0,\"Close\",IF(AND(H30>0,H30<TDB!L$4),\"En Retard\",IF(AND(G30>0,G30<=TDB!L$4),\"En Cours\",IF(E30>\"\",\"Attribuée\",IF(D30>\"\",\"Définie\",IF(OR(C30>\"\",NOT(ISERROR(VLOOKUP(A30,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[30,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I31>0,\"Close\",IF(AND(H31>0,H31<TDB!L$4),\"En Retard\",IF(AND(G31>0,G31<=TDB!L$4),\"En Cours\",IF(E31>\"\",\"Attribuée\",IF(D31>\"\",\"Définie\",IF(OR(C31>\"\",NOT(ISERROR(VLOOKUP(A31,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[31,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I32>0,\"Close\",IF(AND(H32>0,H32<TDB!L$4),\"En Retard\",IF(AND(G32>0,G32<=TDB!L$4),\"En Cours\",IF(E32>\"\",\"Attribuée\",IF(D32>\"\",\"Définie\",IF(OR(C32>\"\",NOT(ISERROR(VLOOKUP(A32,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[32,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I33>0,\"Close\",IF(AND(H33>0,H33<TDB!L$4),\"En Retard\",IF(AND(G33>0,G33<=TDB!L$4),\"En Cours\",IF(E33>\"\",\"Attribuée\",IF(D33>\"\",\"Définie\",IF(OR(C33>\"\",NOT(ISERROR(VLOOKUP(A33,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[33,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I34>0,\"Close\",IF(AND(H34>0,H34<TDB!L$4),\"En Retard\",IF(AND(G34>0,G34<=TDB!L$4),\"En Cours\",IF(E34>\"\",\"Attribuée\",IF(D34>\"\",\"Définie\",IF(OR(C34>\"\",NOT(ISERROR(VLOOKUP(A34,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[34,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I35>0,\"Close\",IF(AND(H35>0,H35<TDB!L$4),\"En Retard\",IF(AND(G35>0,G35<=TDB!L$4),\"En Cours\",IF(E35>\"\",\"Attribuée\",IF(D35>\"\",\"Définie\",IF(OR(C35>\"\",NOT(ISERROR(VLOOKUP(A35,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[35,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I36>0,\"Close\",IF(AND(H36>0,H36<TDB!L$4),\"En Retard\",IF(AND(G36>0,G36<=TDB!L$4),\"En Cours\",IF(E36>\"\",\"Attribuée\",IF(D36>\"\",\"Définie\",IF(OR(C36>\"\",NOT(ISERROR(VLOOKUP(A36,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[36,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I37>0,\"Close\",IF(AND(H37>0,H37<TDB!L$4),\"En Retard\",IF(AND(G37>0,G37<=TDB!L$4),\"En Cours\",IF(E37>\"\",\"Attribuée\",IF(D37>\"\",\"Définie\",IF(OR(C37>\"\",NOT(ISERROR(VLOOKUP(A37,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[37,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,\"Close\",IF(AND(H38>0,H38<TDB!L$4),\"En Retard\",IF(AND(G38>0,G38<=TDB!L$4),\"En Cours\",IF(E38>\"\",\"Attribuée\",IF(D38>\"\",\"Définie\",IF(OR(C38>\"\",NOT(ISERROR(VLOOKUP(A38,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[38,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,\"Close\",IF(AND(H39>0,H39<TDB!L$4),\"En Retard\",IF(AND(G39>0,G39<=TDB!L$4),\"En Cours\",IF(E39>\"\",\"Attribuée\",IF(D39>\"\",\"Définie\",IF(OR(C39>\"\",NOT(ISERROR(VLOOKUP(A39,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[39,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I40>0,\"Close\",IF(AND(H40>0,H40<TDB!L$4),\"En Retard\",IF(AND(G40>0,G40<=TDB!L$4),\"En Cours\",IF(E40>\"\",\"Attribuée\",IF(D40>\"\",\"Définie\",IF(OR(C40>\"\",NOT(ISERROR(VLOOKUP(A40,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[40,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I41>0,\"Close\",IF(AND(H41>0,H41<TDB!L$4),\"En Retard\",IF(AND(G41>0,G41<=TDB!L$4),\"En Cours\",IF(E41>\"\",\"Attribuée\",IF(D41>\"\",\"Définie\",IF(OR(C41>\"\",NOT(ISERROR(VLOOKUP(A41,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[41,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I42>0,\"Close\",IF(AND(H42>0,H42<TDB!L$4),\"En Retard\",IF(AND(G42>0,G42<=TDB!L$4),\"En Cours\",IF(E42>\"\",\"Attribuée\",IF(D42>\"\",\"Définie\",IF(OR(C42>\"\",NOT(ISERROR(VLOOKUP(A42,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[42,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I43>0,\"Close\",IF(AND(H43>0,H43<TDB!L$4),\"En Retard\",IF(AND(G43>0,G43<=TDB!L$4),\"En Cours\",IF(E43>\"\",\"Attribuée\",IF(D43>\"\",\"Définie\",IF(OR(C43>\"\",NOT(ISERROR(VLOOKUP(A43,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[43,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I44>0,\"Close\",IF(AND(H44>0,H44<TDB!L$4),\"En Retard\",IF(AND(G44>0,G44<=TDB!L$4),\"En Cours\",IF(E44>\"\",\"Attribuée\",IF(D44>\"\",\"Définie\",IF(OR(C44>\"\",NOT(ISERROR(VLOOKUP(A44,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[44,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I45>0,\"Close\",IF(AND(H45>0,H45<TDB!L$4),\"En Retard\",IF(AND(G45>0,G45<=TDB!L$4),\"En Cours\",IF(E45>\"\",\"Attribuée\",IF(D45>\"\",\"Définie\",IF(OR(C45>\"\",NOT(ISERROR(VLOOKUP(A45,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[45,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I46>0,\"Close\",IF(AND(H46>0,H46<TDB!L$4),\"En Retard\",IF(AND(G46>0,G46<=TDB!L$4),\"En Cours\",IF(E46>\"\",\"Attribuée\",IF(D46>\"\",\"Définie\",IF(OR(C46>\"\",NOT(ISERROR(VLOOKUP(A46,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[46,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I47>0,\"Close\",IF(AND(H47>0,H47<TDB!L$4),\"En Retard\",IF(AND(G47>0,G47<=TDB!L$4),\"En Cours\",IF(E47>\"\",\"Attribuée\",IF(D47>\"\",\"Définie\",IF(OR(C47>\"\",NOT(ISERROR(VLOOKUP(A47,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[47,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I48>0,\"Close\",IF(AND(H48>0,H48<TDB!L$4),\"En Retard\",IF(AND(G48>0,G48<=TDB!L$4),\"En Cours\",IF(E48>\"\",\"Attribuée\",IF(D48>\"\",\"Définie\",IF(OR(C48>\"\",NOT(ISERROR(VLOOKUP(A48,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[48,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I49>0,\"Close\",IF(AND(H49>0,H49<TDB!L$4),\"En Retard\",IF(AND(G49>0,G49<=TDB!L$4),\"En Cours\",IF(E49>\"\",\"Attribuée\",IF(D49>\"\",\"Définie\",IF(OR(C49>\"\",NOT(ISERROR(VLOOKUP(A49,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[49,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I50>0,\"Close\",IF(AND(H50>0,H50<TDB!L$4),\"En Retard\",IF(AND(G50>0,G50<=TDB!L$4),\"En Cours\",IF(E50>\"\",\"Attribuée\",IF(D50>\"\",\"Définie\",IF(OR(C50>\"\",NOT(ISERROR(VLOOKUP(A50,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[50,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I51>0,\"Close\",IF(AND(H51>0,H51<TDB!L$4),\"En Retard\",IF(AND(G51>0,G51<=TDB!L$4),\"En Cours\",IF(E51>\"\",\"Attribuée\",IF(D51>\"\",\"Définie\",IF(OR(C51>\"\",NOT(ISERROR(VLOOKUP(A51,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[51,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I52>0,\"Close\",IF(AND(H52>0,H52<TDB!L$4),\"En Retard\",IF(AND(G52>0,G52<=TDB!L$4),\"En Cours\",IF(E52>\"\",\"Attribuée\",IF(D52>\"\",\"Définie\",IF(OR(C52>\"\",NOT(ISERROR(VLOOKUP(A52,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[52,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I53>0,\"Close\",IF(AND(H53>0,H53<TDB!L$4),\"En Retard\",IF(AND(G53>0,G53<=TDB!L$4),\"En Cours\",IF(E53>\"\",\"Attribuée\",IF(D53>\"\",\"Définie\",IF(OR(C53>\"\",NOT(ISERROR(VLOOKUP(A53,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[53,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I54>0,\"Close\",IF(AND(H54>0,H54<TDB!L$4),\"En Retard\",IF(AND(G54>0,G54<=TDB!L$4),\"En Cours\",IF(E54>\"\",\"Attribuée\",IF(D54>\"\",\"Définie\",IF(OR(C54>\"\",NOT(ISERROR(VLOOKUP(A54,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[54,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I55>0,\"Close\",IF(AND(H55>0,H55<TDB!L$4),\"En Retard\",IF(AND(G55>0,G55<=TDB!L$4),\"En Cours\",IF(E55>\"\",\"Attribuée\",IF(D55>\"\",\"Définie\",IF(OR(C55>\"\",NOT(ISERROR(VLOOKUP(A55,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[55,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I56>0,\"Close\",IF(AND(H56>0,H56<TDB!L$4),\"En Retard\",IF(AND(G56>0,G56<=TDB!L$4),\"En Cours\",IF(E56>\"\",\"Attribuée\",IF(D56>\"\",\"Définie\",IF(OR(C56>\"\",NOT(ISERROR(VLOOKUP(A56,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[56,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I57>0,\"Close\",IF(AND(H57>0,H57<TDB!L$4),\"En Retard\",IF(AND(G57>0,G57<=TDB!L$4),\"En Cours\",IF(E57>\"\",\"Attribuée\",IF(D57>\"\",\"Définie\",IF(OR(C57>\"\",NOT(ISERROR(VLOOKUP(A57,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[57,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I58>0,\"Close\",IF(AND(H58>0,H58<TDB!L$4),\"En Retard\",IF(AND(G58>0,G58<=TDB!L$4),\"En Cours\",IF(E58>\"\",\"Attribuée\",IF(D58>\"\",\"Définie\",IF(OR(C58>\"\",NOT(ISERROR(VLOOKUP(A58,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[58,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I59>0,\"Close\",IF(AND(H59>0,H59<TDB!L$4),\"En Retard\",IF(AND(G59>0,G59<=TDB!L$4),\"En Cours\",IF(E59>\"\",\"Attribuée\",IF(D59>\"\",\"Définie\",IF(OR(C59>\"\",NOT(ISERROR(VLOOKUP(A59,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[59,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I60>0,\"Close\",IF(AND(H60>0,H60<TDB!L$4),\"En Retard\",IF(AND(G60>0,G60<=TDB!L$4),\"En Cours\",IF(E60>\"\",\"Attribuée\",IF(D60>\"\",\"Définie\",IF(OR(C60>\"\",NOT(ISERROR(VLOOKUP(A60,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[60,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I61>0,\"Close\",IF(AND(H61>0,H61<TDB!L$4),\"En Retard\",IF(AND(G61>0,G61<=TDB!L$4),\"En Cours\",IF(E61>\"\",\"Attribuée\",IF(D61>\"\",\"Définie\",IF(OR(C61>\"\",NOT(ISERROR(VLOOKUP(A61,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[61,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I62>0,\"Close\",IF(AND(H62>0,H62<TDB!L$4),\"En Retard\",IF(AND(G62>0,G62<=TDB!L$4),\"En Cours\",IF(E62>\"\",\"Attribuée\",IF(D62>\"\",\"Définie\",IF(OR(C62>\"\",NOT(ISERROR(VLOOKUP(A62,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[62,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I63>0,\"Close\",IF(AND(H63>0,H63<TDB!L$4),\"En Retard\",IF(AND(G63>0,G63<=TDB!L$4),\"En Cours\",IF(E63>\"\",\"Attribuée\",IF(D63>\"\",\"Définie\",IF(OR(C63>\"\",NOT(ISERROR(VLOOKUP(A63,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[63,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I64>0,\"Close\",IF(AND(H64>0,H64<TDB!L$4),\"En Retard\",IF(AND(G64>0,G64<=TDB!L$4),\"En Cours\",IF(E64>\"\",\"Attribuée\",IF(D64>\"\",\"Définie\",IF(OR(C64>\"\",NOT(ISERROR(VLOOKUP(A64,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[64,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I65>0,\"Close\",IF(AND(H65>0,H65<TDB!L$4),\"En Retard\",IF(AND(G65>0,G65<=TDB!L$4),\"En Cours\",IF(E65>\"\",\"Attribuée\",IF(D65>\"\",\"Définie\",IF(OR(C65>\"\",NOT(ISERROR(VLOOKUP(A65,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[65,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I66>0,\"Close\",IF(AND(H66>0,H66<TDB!L$4),\"En Retard\",IF(AND(G66>0,G66<=TDB!L$4),\"En Cours\",IF(E66>\"\",\"Attribuée\",IF(D66>\"\",\"Définie\",IF(OR(C66>\"\",NOT(ISERROR(VLOOKUP(A66,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[66,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I67>0,\"Close\",IF(AND(H67>0,H67<TDB!L$4),\"En Retard\",IF(AND(G67>0,G67<=TDB!L$4),\"En Cours\",IF(E67>\"\",\"Attribuée\",IF(D67>\"\",\"Définie\",IF(OR(C67>\"\",NOT(ISERROR(VLOOKUP(A67,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[67,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I68>0,\"Close\",IF(AND(H68>0,H68<TDB!L$4),\"En Retard\",IF(AND(G68>0,G68<=TDB!L$4),\"En Cours\",IF(E68>\"\",\"Attribuée\",IF(D68>\"\",\"Définie\",IF(OR(C68>\"\",NOT(ISERROR(VLOOKUP(A68,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[68,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I69>0,\"Close\",IF(AND(H69>0,H69<TDB!L$4),\"En Retard\",IF(AND(G69>0,G69<=TDB!L$4),\"En Cours\",IF(E69>\"\",\"Attribuée\",IF(D69>\"\",\"Définie\",IF(OR(C69>\"\",NOT(ISERROR(VLOOKUP(A69,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[69,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I70>0,\"Close\",IF(AND(H70>0,H70<TDB!L$4),\"En Retard\",IF(AND(G70>0,G70<=TDB!L$4),\"En Cours\",IF(E70>\"\",\"Attribuée\",IF(D70>\"\",\"Définie\",IF(OR(C70>\"\",NOT(ISERROR(VLOOKUP(A70,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]
[70,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I71>0,\"Close\",IF(AND(H71>0,H71<TDB!L$4),\"En Retard\",IF(AND(G71>0,G71<=TDB!L$4),\"En Cours\",IF(E71>\"\",\"Attribuée\",IF(D71>\"\",\"Définie\",IF(OR(C71>\"\",NOT(ISERROR(VLOOKUP(A71,'R'!K:K,1,FALSE)))),\"A Traiter\",\"\"))))))","v":""}]

{"sheet":"C&D","index":6,"n_rows":140,"n_cols":18,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["Date","Sujet","Chef","Pilote","Expert","Temps","Statut \nCoût","Nature","Phase","Autres Informations (Annulation, Retard, Dépassement...)","Statut Délai","FPX",{"$f":"QCDR!F4","v":1.1701944087076921E-3},{"$f":"QCDR!F5","v":0.89999252904770466}]
[null,null,null,null,null,null,{"$f":"SUM(C2:E2)*F2","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(I2,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},{"$f":"IF(H2=\"Fin de Phase\",I2&\"_X\",\"\")","v":""},{"$f":"DonnéesUtiles!M23","v":1},{"$f":"DonnéesUtiles!N23","v":0},{"$f":"DonnéesUtiles!O23","v":"00:00:00"},{"$f":"DonnéesUtiles!P23","v":"00:00:00"},{"$f":"DonnéesUtiles!Q23","v":0},{"$f":"DonnéesUtiles!R23","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I3,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},"",{"$f":"DonnéesUtiles!M24","v":2},{"$f":"DonnéesUtiles!N24","v":0},{"$f":"DonnéesUtiles!O24","v":"00:00:00"},{"$f":"DonnéesUtiles!P24","v":"00:00:00"},{"$f":"DonnéesUtiles!Q24","v":0},{"$f":"DonnéesUtiles!R24","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I4,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},"",{"$f":"DonnéesUtiles!M25","v":3},{"$f":"DonnéesUtiles!N25","v":0},{"$f":"DonnéesUtiles!O25","v":"00:00:00"},{"$f":"DonnéesUtiles!P25","v":"00:00:00"},{"$f":"DonnéesUtiles!Q25","v":0},{"$f":"DonnéesUtiles!R25","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I5,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},"",{"$f":"DonnéesUtiles!M26","v":4},{"$f":"DonnéesUtiles!N26","v":0},{"$f":"DonnéesUtiles!O26","v":"00:00:00"},{"$f":"DonnéesUtiles!P26","v":"00:00:00"},{"$f":"DonnéesUtiles!Q26","v":0},{"$f":"DonnéesUtiles!R26","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I6,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},"",{"$f":"DonnéesUtiles!M27","v":5},{"$f":"DonnéesUtiles!N27","v":0},{"$f":"DonnéesUtiles!O27","v":"00:00:00"},{"$f":"DonnéesUtiles!P27","v":"00:00:00"},{"$f":"DonnéesUtiles!Q27","v":0},{"$f":"DonnéesUtiles!R27","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I7,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},"",{"$f":"DonnéesUtiles!M28","v":6},{"$f":"DonnéesUtiles!N28","v":0},{"$f":"DonnéesUtiles!O28","v":""},{"$f":"DonnéesUtiles!P28","v":""},{"$f":"DonnéesUtiles!Q28","v":0},{"$f":"DonnéesUtiles!R28","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I8,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},"",{"$f":"DonnéesUtiles!M29","v":7},{"$f":"DonnéesUtiles!N29","v":0},{"$f":"DonnéesUtiles!O29","v":""},{"$f":"DonnéesUtiles!P29","v":""},{"$f":"DonnéesUtiles!Q29","v":0},{"$f":"DonnéesUtiles!R29","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I9,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},"",{"$f":"DonnéesUtiles!M30","v":8},{"$f":"DonnéesUtiles!N30","v":0},{"$f":"DonnéesUtiles!O30","v":""},{"$f":"DonnéesUtiles!P30","v":""},{"$f":"DonnéesUtiles!Q30","v":0},{"$f":"DonnéesUtiles!R30","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I10,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I11,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I12,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I13,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I14,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I15,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I16,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I17,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I18,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I19,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I20,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I21,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I22,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I23,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I24,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I25,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I26,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I27,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I28,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I29,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I30,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I31,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I32,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I33,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,{"$f":"SUM(C34:E34)*F34","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(I34,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I35,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I36,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I37,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I38,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I39,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I40,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I41,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I42,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I43,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I44,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I45,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I46,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I47,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},{"$f":"IF(H47=\"Fin de Phase\",I47&\"_X\",\"\")","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I48,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I49,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I50,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I51,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I52,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I53,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I54,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I55,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I56,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I57,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I58,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I59,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I60,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I61,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I62,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I63,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I64,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I65,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,{"$f":"SUM(C66:E66)*F66","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(I66,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},{"$f":"IF(H66=\"Fin de Phase\",I66&\"_X\",\"\")","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I67,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I68,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I69,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I70,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I71,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I72,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I73,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I74,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I75,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I76,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I77,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},{"$f":"IF(H77=\"Fin de Phase\",I77&\"_X\",\"\")","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I78,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I79,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I80,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I81,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I82,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I83,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I84,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I85,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I86,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I87,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I88,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I89,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I90,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I91,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I92,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I93,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I94,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I95,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I96,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I97,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,{"$f":"SUM(C98:E98)*F98","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(I98,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I99,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I100,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,{"$f":"SUM(C101:E101)*F101","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(I101,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},{"$f":"IF(H101=\"Fin de Phase\",I101&\"_X\",\"\")","v":""}]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I102,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I103,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I104,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I105,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I106,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I107,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I108,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I109,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I110,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I111,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I112,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I113,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I114,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I115,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I116,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I117,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I118,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I119,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I120,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I121,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I122,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I123,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I124,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I125,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I126,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I127,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I128,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I129,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I130,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I131,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I132,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I133,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I134,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I135,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I136,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I137,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I138,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I139,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,0,null,null,null,{"$f":"IFERROR(VLOOKUP(I140,Tables!$F$1:$G$12,2,FALSE),\"\")","v":""},""]

{"sheet":"QCDR","index":7,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Nota: XLIM atteint donne une valeur objectif à ~37% => 100-37 = 73%",null,null,null,null,null,null,null,null,24]
[null,"xLIM","xNQ","xGQ","Mesure","QCDR","Cible","Limite","Dépassement"]
["Qualité",0.8,0,1,{"$f":"DonnéesUtiles!H9","v":1},{"$f":"100%-IF((IF(E3>B3,1,-1)*IF(D3>C3,1,-1))>0,EXP(-EXP(-(2.25/(D3-B3))*(E3-B3))),EXP(-EXP(-(-0.834/(C3-B3))*(E3-B3))))","v":0.10003483733937224},0.37,0.73,1.1000000000000001]
["Coût",1.2,1.5,0.8,{"$f":"DonnéesUtiles!I9","v":0},{"$f":"100%-IF((IF(E4>B4,1,-1)*IF(D4>C4,1,-1))>0,EXP(-EXP(-(2.25/(D4-B4))*(E4-B4))),EXP(-EXP(-(-0.834/(C4-B4))*(E4-B4))))","v":1.1701944087076921E-3},0.37,0.73,1.1000000000000001]
["Délai",0.8,0,1,{"$f":"DonnéesUtiles!J9","v":0},{"$f":"100%-IF((IF(E5>B5,1,-1)*IF(D5>C5,1,-1))>0,EXP(-EXP(-(2.25/(D5-B5))*(E5-B5))),EXP(-EXP(-(-0.834/(C5-B5))*(E5-B5))))","v":0.89999252904770466},0.37,0.73,1.1000000000000001]
["Risques",0.25,1,0,{"$f":"DonnéesUtiles!K9","v":0},{"$f":"100%-IF((IF(E6>B6,1,-1)*IF(D6>C6,1,-1))>0,EXP(-EXP(-(2.25/(D6-B6))*(E6-B6))),EXP(-EXP(-(-0.834/(C6-B6))*(E6-B6))))","v":0.10003483733937224},0.37,0.73,1.1000000000000001]

{"sheet":"Guide_support","index":8,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[9,3,9,4],[9,5,9,6],[9,7,9,8],[10,3,10,4],[10,5,10,6],[10,7,10,8]]}
[]
[null,"Chemin gestion de projet"]
[null,"Mode op de fonctionnement ou support"]
[null,"Accès ndc"]
[null,"Gouvernance"]
[null,"Table des risques"]
[null,"Outils qualité (+flyer…) "]
[null,null,null,null,null,null,"Base ou capitalisation des risques… ou un indice de conficance"]
[]
[null,null,null,"Gravité (G)",null,"Occurrence (O)",null,"Détection (D)"]
[null,null,null,"Effet maximal impactant la réussite du projet pouvant être induit par le risque",null,"Probabilité d'apparition du risque pour une cause donnée",null,"Probabilité de détection du risque au cours du projet"]
[null,null,1,"Insignifiante","Risque sans impact  sur la sécurité, sur la finance, sur les délais et sur les autres processus/activités","Improbable","N'a jamais été constaté sur un projet\n","Certaine","Détection systématique avant apparition à 100% des cas \nForcément avant le lancement du projet "]
[]
[null,null,2,"Mineure","Impact  mineur avec correction (de - 2h), sans conséquences (couts/délais/qualité) sur le projet","Inopinée","Déjà arrivé de mémoire sur moins de 10% des projets","Probable","Contrôle en place pour détecter le risque dans 75% des cas\nDétéctable en début de projet"]
[]
[null,null,3,"Majeure","Par défaut ou inconu\nConséquences possibles sur les livrables et Objectifs à partir de 5% \nA traiter Particulièremnt en PRJ1 : corrections d'une journée","Probable","Par défaut ou inconu\nApparu historiquement sur moins de 50% des projets","Aléatoire","Par défaut ou inconu\nAucun contrôle mais détection possible de manière inattendu ou/et au moins sur 50% des cas "]
[]
[null,null,4,"Critique","Projet bloqué ou en danger \nImpact critque (à partir 20% de qualité des livrables) et/ou avec corrections supérieures à  une semaine \nA traiter en PRJ2 : mobilisation de ressources","Prévisible","Identifié sur moins de 75% des projets","Difficile","Contrôle exsitant mais non robuste\nDétectable seulement sur moins de 25% des cas ou/et avant la fin du projet"]
[]
[null,null,5,"Sécurité","Projet qui n'aboutira pas et/ou  impact financier, sur la sécurité des collaborateurs et sur les Processus(activités) \nA traiter en PRJ3 : pour prise de décisions","Systématique","Tracé et capitalisé dans tout les cas sur 100% des projets","Impossible","Non détectable ou aucune solution de détection connue à ce jour\nDétection uniquement en fin/après projet"]

{"sheet":"R","index":9,"n_rows":81,"n_cols":20,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["N°","Etape / Fonction / Exigence","Mode de Défaillance Potentielle","Effet(s) Potentiel(s) de la Défaillance","G","Cause(s) Potentielle(s) de la Défaillance","O","Prévention sur Cause / Inspection sur Mode ou Effets Existante(s)","D","NPR (>25)","Action N°","Info Action(s)","G'","O'","D'","NPR'","Acceptation des risques résiduels / Remarques","Traité le","Statut Risque",{"$f":"QCDR!F6","v":0.10003483733937224}]
[1,null,null,null,null,null,null,null,null,{"$f":"E2*G2*I2","v":0},null,{"$f":"IF(ISNUMBER(K2),VLOOKUP(K2,Q!A:L,12,FALSE),\" \")","v":" "},{"$f":"E2","v":0},null,null,{"$f":"M2*N2*O2","v":0},null,null,{"$f":"IFERROR(IF(OR(R2>0,AND(P2>0,P2<25,L2=\"Close\"),AND(J2>0,J2<25)),0%,IF(L2=\"Attente Décision\",100%,IF(L2=\"Attente Ressource\",75%,IF(K2>0,25%,IF(OR(J2>25,C2>\"\"),50%,\"\")))))+IF(OR(L2=\"En Retard\",AND(L2=\"Close\",OR(P2>=25,P2=0))),25%,0%),\"\")","v":""}]
[{"$f":"A2+1","v":2},null,null,null,null,null,null,null,null,{"$f":"E3*G3*I3","v":0},null,{"$f":"IF(ISNUMBER(K3),VLOOKUP(K3,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,{"$f":"M3*N3*O3","v":0},null,null,{"$f":"IFERROR(IF(OR(R3>0,AND(P3>0,P3<25,L3=\"Close\"),AND(J3>0,J3<25)),0%,IF(L3=\"Attente Décision\",100%,IF(L3=\"Attente Ressource\",75%,IF(K3>0,25%,IF(OR(J3>25,C3>\"\"),50%,\"\")))))+IF(OR(L3=\"En Retard\",AND(L3=\"Close\",OR(P3>=25,P3=0))),25%,0%),\"\")","v":""}]
[{"$f":"A3+1","v":3},null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K4),VLOOKUP(K4,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,{"$f":"M4*N4*O4","v":0},null,null,{"$f":"IFERROR(IF(OR(R4>0,AND(P4>0,P4<25,L4=\"Close\"),AND(J4>0,J4<25)),0%,IF(L4=\"Attente Décision\",100%,IF(L4=\"Attente Ressource\",75%,IF(K4>0,25%,IF(OR(J4>25,C4>\"\"),50%,\"\")))))+IF(OR(L4=\"En Retard\",AND(L4=\"Close\",OR(P4>=25,P4=0))),25%,0%),\"\")","v":""}]
[4,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K5),VLOOKUP(K5,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,{"$f":"M5*N5*O5","v":0},null,null,""]
[5,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K6),VLOOKUP(K6,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,{"$f":"M6*N6*O6","v":0},null,null,""]
[6,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K7),VLOOKUP(K7,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[7,null,null,null,null,null,null,null,null,{"$f":"E8*G8*I8","v":0},null,{"$f":"IF(ISNUMBER(K8),VLOOKUP(K8,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[{"$f":"A8+1","v":8},null,null,null,null,null,null,null,null,{"$f":"E9*G9*I9","v":0},null,{"$f":"IF(ISNUMBER(K9),VLOOKUP(K9,Q!A:L,12,FALSE),\" \")","v":" "},{"$f":"E9","v":0},null,null,{"$f":"M9*N9*O9","v":0},null,null,{"$f":"IFERROR(IF(OR(R9>0,AND(P9>0,P9<25,L9=\"Close\"),AND(J9>0,J9<25)),0%,IF(L9=\"Attente Décision\",100%,IF(L9=\"Attente Ressource\",75%,IF(K9>0,25%,IF(OR(J9>25,C9>\"\"),50%,\"\")))))+IF(OR(L9=\"En Retard\",AND(L9=\"Close\",OR(P9>=25,P9=0))),25%,0%),\"\")","v":""}]
[9,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K10),VLOOKUP(K10,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[10,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K11),VLOOKUP(K11,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[11,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K12),VLOOKUP(K12,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[12,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K13),VLOOKUP(K13,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[13,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K14),VLOOKUP(K14,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[14,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K15),VLOOKUP(K15,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[15,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K16),VLOOKUP(K16,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[16,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K17),VLOOKUP(K17,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,{"$f":"IFERROR(IF(OR(R17>0,AND(P17>0,P17<25,L17=\"Close\"),AND(J17>0,J17<25)),0%,IF(L17=\"Attente Décision\",100%,IF(L17=\"Attente Ressource\",75%,IF(K17>0,25%,IF(OR(J17>25,C17>\"\"),50%,\"\")))))+IF(OR(L17=\"En Retard\",AND(L17=\"Close\",OR(P17>=25,P17=0))),25%,0%),\"\")","v":""}]
[17,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K18),VLOOKUP(K18,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[18,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K19),VLOOKUP(K19,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[{"$f":"A19+1","v":19},null,null,null,null,null,null,null,null,{"$f":"E20*G20*I20","v":0},null,{"$f":"IF(ISNUMBER(K20),VLOOKUP(K20,Q!A:L,12,FALSE),\" \")","v":" "},{"$f":"E20","v":0},null,null,{"$f":"M20*N20*O20","v":0},null,null,{"$f":"IFERROR(IF(OR(R20>0,AND(P20>0,P20<25,L20=\"Close\"),AND(J20>0,J20<25)),0%,IF(L20=\"Attente Décision\",100%,IF(L20=\"Attente Ressource\",75%,IF(K20>0,25%,IF(OR(J20>25,C20>\"\"),50%,\"\")))))+IF(OR(L20=\"En Retard\",AND(L20=\"Close\",OR(P20>=25,P20=0))),25%,0%),\"\")","v":""}]
[{"$f":"A20+1","v":20},null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K21),VLOOKUP(K21,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[21,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K22),VLOOKUP(K22,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[22,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K23),VLOOKUP(K23,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[23,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K24),VLOOKUP(K24,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[24,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K25),VLOOKUP(K25,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[25,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K26),VLOOKUP(K26,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[26,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K27),VLOOKUP(K27,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[27,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K28),VLOOKUP(K28,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[28,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K29),VLOOKUP(K29,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[29,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K30),VLOOKUP(K30,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[30,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K31),VLOOKUP(K31,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,{"$f":"IFERROR(IF(OR(R31>0,AND(P31>0,P31<25,L31=\"Close\"),AND(J31>0,J31<25)),0%,IF(L31=\"Attente Décision\",100%,IF(L31=\"Attente Ressource\",75%,IF(K31>0,25%,IF(OR(J31>25,C31>\"\"),50%,\"\")))))+IF(OR(L31=\"En Retard\",AND(L31=\"Close\",OR(P31>=25,P31=0))),25%,0%),\"\")","v":""}]
[31,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K32),VLOOKUP(K32,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[32,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K33),VLOOKUP(K33,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,{"$f":"IFERROR(IF(OR(R33>0,AND(P33>0,P33<25,L33=\"Close\"),AND(J33>0,J33<25)),0%,IF(L33=\"Attente Décision\",100%,IF(L33=\"Attente Ressource\",75%,IF(K33>0,25%,IF(OR(J33>25,C33>\"\"),50%,\"\")))))+IF(OR(L33=\"En Retard\",AND(L33=\"Close\",OR(P33>=25,P33=0))),25%,0%),\"\")","v":""}]
[33,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K34),VLOOKUP(K34,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,{"$f":"IFERROR(IF(OR(R34>0,AND(P34>0,P34<25,L34=\"Close\"),AND(J34>0,J34<25)),0%,IF(L34=\"Attente Décision\",100%,IF(L34=\"Attente Ressource\",75%,IF(K34>0,25%,IF(OR(J34>25,C34>\"\"),50%,\"\")))))+IF(OR(L34=\"En Retard\",AND(L34=\"Close\",OR(P34>=25,P34=0))),25%,0%),\"\")","v":""}]
[34,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K35),VLOOKUP(K35,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,{"$f":"IFERROR(IF(OR(R35>0,AND(P35>0,P35<25,L35=\"Close\"),AND(J35>0,J35<25)),0%,IF(L35=\"Attente Décision\",100%,IF(L35=\"Attente Ressource\",75%,IF(K35>0,25%,IF(OR(J35>25,C35>\"\"),50%,\"\")))))+IF(OR(L35=\"En Retard\",AND(L35=\"Close\",OR(P35>=25,P35=0))),25%,0%),\"\")","v":""}]
[35,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K36),VLOOKUP(K36,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,{"$f":"IFERROR(IF(OR(R36>0,AND(P36>0,P36<25,L36=\"Close\"),AND(J36>0,J36<25)),0%,IF(L36=\"Attente Décision\",100%,IF(L36=\"Attente Ressource\",75%,IF(K36>0,25%,IF(OR(J36>25,C36>\"\"),50%,\"\")))))+IF(OR(L36=\"En Retard\",AND(L36=\"Close\",OR(P36>=25,P36=0))),25%,0%),\"\")","v":""}]
[36,null,null,null,null,null,null,null,null,{"$f":"E37*G37*I37","v":0},null,{"$f":"IF(ISNUMBER(K37),VLOOKUP(K37,Q!A:L,12,FALSE),\" \")","v":" "},{"$f":"E37","v":0},null,null,{"$f":"M37*N37*O37","v":0},null,null,{"$f":"IFERROR(IF(OR(R37>0,AND(P37>0,P37<25,L37=\"Close\"),AND(J37>0,J37<25)),0%,IF(L37=\"Attente Décision\",100%,IF(L37=\"Attente Ressource\",75%,IF(K37>0,25%,IF(OR(J37>25,C37>\"\"),50%,\"\")))))+IF(OR(L37=\"En Retard\",AND(L37=\"Close\",OR(P37>=25,P37=0))),25%,0%),\"\")","v":""}]
[37,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K38),VLOOKUP(K38,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[38,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K39),VLOOKUP(K39,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[39,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K40),VLOOKUP(K40,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[40,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K41),VLOOKUP(K41,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[41,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K42),VLOOKUP(K42,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[42,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K43),VLOOKUP(K43,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[43,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K44),VLOOKUP(K44,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[44,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K45),VLOOKUP(K45,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[45,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K46),VLOOKUP(K46,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[46,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K47),VLOOKUP(K47,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[47,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K48),VLOOKUP(K48,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[48,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K49),VLOOKUP(K49,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,{"$f":"M49*N49*O49","v":0},null,null,""]
[49,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K50),VLOOKUP(K50,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[50,null,null,null,null,null,null,null,null,{"$f":"E51*G51*I51","v":0},null,{"$f":"IF(ISNUMBER(K51),VLOOKUP(K51,Q!A:L,12,FALSE),\" \")","v":" "},{"$f":"E51","v":0},null,null,{"$f":"M51*N51*O51","v":0},null,null,{"$f":"IFERROR(IF(OR(R51>0,AND(P51>0,P51<25,L51=\"Close\"),AND(J51>0,J51<25)),0%,IF(L51=\"Attente Décision\",100%,IF(L51=\"Attente Ressource\",75%,IF(K51>0,25%,IF(OR(J51>25,C51>\"\"),50%,\"\")))))+IF(OR(L51=\"En Retard\",AND(L51=\"Close\",OR(P51>=25,P51=0))),25%,0%),\"\")","v":""}]
[51,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K52),VLOOKUP(K52,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[52,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K53),VLOOKUP(K53,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[53,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K54),VLOOKUP(K54,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[54,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K55),VLOOKUP(K55,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[55,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K56),VLOOKUP(K56,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[56,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K57),VLOOKUP(K57,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[57,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K58),VLOOKUP(K58,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[58,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K59),VLOOKUP(K59,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[59,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K60),VLOOKUP(K60,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[60,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K61),VLOOKUP(K61,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[61,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K62),VLOOKUP(K62,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[62,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K63),VLOOKUP(K63,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[63,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K64),VLOOKUP(K64,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[64,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K65),VLOOKUP(K65,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[65,null,null,null,null,null,null,null,null,0,null,null,0,null,null,{"$f":"M66*N66*O66","v":0},null,null,{"$f":"IFERROR(IF(OR(R66>0,AND(P66>0,P66<25,L66=\"Close\"),AND(J66>0,J66<25)),0%,IF(L66=\"Attente Décision\",100%,IF(L66=\"Attente Ressource\",75%,IF(K66>0,25%,IF(OR(J66>25,C66>\"\"),50%,\"\")))))+IF(OR(L66=\"En Retard\",AND(L66=\"Close\",OR(P66>=25,P66=0))),25%,0%),\"\")","v":""}]
[66,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K67),VLOOKUP(K67,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[67,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K68),VLOOKUP(K68,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[{"$f":"A68+1","v":68},null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K69),VLOOKUP(K69,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[69,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K70),VLOOKUP(K70,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[70,null,null,null,null,null,null,null,null,{"$f":"E71*G71*I71","v":0},null,{"$f":"IF(ISNUMBER(K71),VLOOKUP(K71,Q!A:L,12,FALSE),\" \")","v":" "},{"$f":"E71","v":0},null,null,{"$f":"M71*N71*O71","v":0},null,null,{"$f":"IFERROR(IF(OR(R71>0,AND(P71>0,P71<25,L71=\"Close\"),AND(J71>0,J71<25)),0%,IF(L71=\"Attente Décision\",100%,IF(L71=\"Attente Ressource\",75%,IF(K71>0,25%,IF(OR(J71>25,C71>\"\"),50%,\"\")))))+IF(OR(L71=\"En Retard\",AND(L71=\"Close\",OR(P71>=25,P71=0))),25%,0%),\"\")","v":""}]
[71,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K72),VLOOKUP(K72,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[72,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K73),VLOOKUP(K73,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[73,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K74),VLOOKUP(K74,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[74,null,null,null,null,null,null,null,null,{"$f":"E75*G75*I75","v":0},null,{"$f":"IF(ISNUMBER(K75),VLOOKUP(K75,Q!A:L,12,FALSE),\" \")","v":" "},{"$f":"E75","v":0},null,null,{"$f":"M75*N75*O75","v":0},null,null,{"$f":"IFERROR(IF(OR(R75>0,AND(P75>0,P75<25,L75=\"Close\"),AND(J75>0,J75<25)),0%,IF(L75=\"Attente Décision\",100%,IF(L75=\"Attente Ressource\",75%,IF(K75>0,25%,IF(OR(J75>25,C75>\"\"),50%,\"\")))))+IF(OR(L75=\"En Retard\",AND(L75=\"Close\",OR(P75>=25,P75=0))),25%,0%),\"\")","v":""}]
[75,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K76),VLOOKUP(K76,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[76,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K77),VLOOKUP(K77,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[77,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K78),VLOOKUP(K78,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[78,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K79),VLOOKUP(K79,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[79,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(ISNUMBER(K80),VLOOKUP(K80,Q!A:L,12,FALSE),\" \")","v":" "},0,null,null,0,null,null,""]
[80,null,null,null,null,null,null,null,null,{"$f":"E81*G81*I81","v":0},null,{"$f":"IF(ISNUMBER(K81),VLOOKUP(K81,Q!A:L,12,FALSE),\" \")","v":" "},{"$f":"E81","v":0},null,null,{"$f":"M81*N81*O81","v":0},null,null,{"$f":"IFERROR(IF(OR(R81>0,AND(P81>0,P81<25,L81=\"Close\"),AND(J81>0,J81<25)),0%,IF(L81=\"Attente Décision\",100%,IF(L81=\"Attente Ressource\",75%,IF(K81>0,25%,IF(OR(J81>25,C81>\"\"),50%,\"\")))))+IF(OR(L81=\"En Retard\",AND(L81=\"Close\",OR(P81>=25,P81=0))),25%,0%),\"\")","v":""}]

{"sheet":"Format_A3","index":10,"n_rows":55,"n_cols":19,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,6,4,13],[1,10,2,13],[1,6,2,9],[7,1,8,4],[7,5,8,6],[7,11,8,14],[14,5,15,6],[39,1,51,8],[7,15,8,16],[9,1,12,8],[16,1,21,8],[25,1,35,8],[23,5,24,6],[25,11,36,18],[9,11,21,18],[23,11,24,14],[38,11,39,14],[40,11,51,18],[37,5,38,6],[38,15,39,16],[23,15,24,16],[53,1,54,2],[53,3,54,4],[37,1,38,4],[23,1,24,4],[14,1,15,4]]}
[]
[null,null,null,null,null,null,"Projet :",null,null,null,{"$f":"TDB!F2","v":"Code_Projet"}]
[]
[null,null,null,null,null,null,{"$f":"TDB!G2","v":"<titre du projet>"}]
[]
[]
[]
[null,"1 - Contexte et Enjeux",null,null,null,"DÉCIDER",null,null,null,null,null,"5 - Mesures Proposées",null,null,null,"INNOVER",null,"Fin planifiée:",{"$f":"VLOOKUP(P8,DonnéesUtiles!$C$23:$E$30,3,FALSE)","v":"00:00:00"}]
[null,null,null,null,null,null,null,"Fin effective:",{"$f":"DonnéesUtiles!$E$313","v":"00:00:00"},null,null,null,null,null,null,null,null,"Fin effective:",{"$f":"DonnéesUtiles!$R$26","v":""}]
[]
[]
[]
[]
[]
[null,"2 -  Situation Initiale",null,null,null,"DÉFINIR",null,"Fin planifiée:",{"$f":"VLOOKUP(F15,DonnéesUtiles!$C$23:$E$30,3,FALSE)","v":"00:00:00"}]
[null,null,null,null,null,null,null,"Fin effective:",{"$f":"DonnéesUtiles!$R$23","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"3 - Indicateurs / Objectifs",null,null,null,"MESURER",null,"Fin planifiée:",{"$f":"VLOOKUP(F24,DonnéesUtiles!$C$23:$E$30,3,FALSE)","v":"00:00:00"},null,null,"6 - Plan d'Actions",null,null,null,"STANDARDISER",null,"Fin planifiée:",{"$f":"VLOOKUP(P24,DonnéesUtiles!$C$23:$E$30,3,FALSE)","v":""}]
[null,null,null,null,null,null,null,"Fin effective:",{"$f":"DonnéesUtiles!$R$24","v":""},null,null,null,null,null,null,null,null,"Fin effective:",{"$f":"VLOOKUP(P24,DonnéesUtiles!$C$23:$R$30,16,FALSE)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4 - Analyse",null,null,null,"ANALYSER",null,"Fin planifiée:",{"$f":"VLOOKUP(F38,DonnéesUtiles!$C$23:$E$30,3,FALSE)","v":"00:00:00"}]
[null,null,null,null,null,null,null,"Fin effective:",{"$f":"DonnéesUtiles!$R$25","v":""},null,null,"7 - Résultat et Suivi",null,null,null,"COMMUNIQUER",null,"Fin planifiée:",{"$f":"VLOOKUP(P39,DonnéesUtiles!$C$23:$E$30,3,FALSE)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fin effective:",{"$f":"VLOOKUP(P39,DonnéesUtiles!$C$23:$R$30,16,FALSE)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Chef de Projet : ",null,{"$f":"TDB!N6","v":" "},null,null,null,null,null,null,null,null,null,null,null,"Date: ",{"$f":"TDB!L4","v":"2026-03-01"},null,"Page"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 / 1"]

{"sheet":"RACI","index":11,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[[69,1,69,2],[26,1,26,2],[33,1,33,2],[40,1,40,2],[48,1,48,2],[54,1,54,2],[62,1,62,2],[1,93,2,93],[1,94,2,94],[1,71,2,71],[1,72,2,72],[1,73,2,73],[1,74,2,74],[1,63,2,63],[1,64,2,64],[1,65,2,65],[1,66,2,66],[1,67,2,67],[1,68,2,68],[1,57,2,57],[1,58,2,58],[1,59,2,59],[1,60,2,60],[1,61,2,61],[1,95,2,95],[3,1,3,2],[7,1,7,2],[21,1,21,2],[1,87,2,87],[1,88,2,88],[1,89,2,89],[1,90,2,90],[1,91,2,91],[1,92,2,92],[1,81,2,81],[1,82,2,82],[1,83,2,83],[1,84,2,84],[1,85,2,85],[1,86,2,86],[1,75,2,75],[1,76,2,76],[1,77,2,77],[1,78,2,78],[1,79,2,79],[1,80,2,80],[1,69,2,69],[1,70,2,70],[1,62,2,62],[1,51,2,51],[1,52,2,52],[1,53,2,53],[1,54,2,54],[1,55,2,55],[1,56,2,56],[1,45,2,45],[1,46,2,46],[1,47,2,47],[1,48,2,48],[1,49,2,49],[1,50,2,50],[1,39,2,39],[1,40,2,40],[1,41,2,41],[1,42,2,42],[1,43,2,43],[1,44,2,44],[1,33,2,33],[1,34,2,34],[1,35,2,35],[1,36,2,36],[1,37,2,37],[1,38,2,38],[1,27,2,27],[1,28,2,28],[1,29,2,29],[1,30,2,30],[1,31,2,31],[1,32,2,32],[1,21,2,21],[1,22,2,22],[1,23,2,23],[1,24,2,24],[1,25,2,25],[1,26,2,26],[1,18,2,18],[1,19,2,19],[1,20,2,20],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,15,2,15],[1,16,2,16],[1,17,2,17]]}
[null,"G","G","GP","G","P","P","PE","C"]
[null," ","QUI","Initiateur","Resp. Gouvernance","Chef de Projet","Directeur xxx","Président","Dir. R.H."]
[null,"QUOI"," "]
[null,"Décider"]
[null,"Identification des Parties Prenantes"]
[null,"Préparer le Pressenti (avec les PP)"]
[null,"Valider le Pressenti"]
[null,"Définir"]
[null,"Vérification des Parties Prenantes (RACI)"]
[null,"Analyse des Parties Prenantes [§4]"]
[null,"Initialisation de la Note de Cadrage [§4.1]"]
[null,"Planning de Réunions [§4.2]"]
[null,"Initialisation du Tableau de Bord [§4.2.1]"]
[null,"Finaliser l'Equipe et Membres [§4.3]"]
[null,"Cartographie du Processus [§4.4]"]
[null,"Analyse de Risques [§4.5]"]
[null,"Suivi des Actions [§4.6]"]
[null,"Finalisation du Tableau de Bord [§4.7]"]
[null,"Plan de Communication [§4.8]"]
[null,"Finalisation de la Note de Cadrage [§4.9]"]
[null,"Conclusion de la Phase Définir [§4.10]"]
[null,"Mesurer"]
[null,"Analyse de Risque liée au Projet [§6.1]"]
[null,"Plan de Collecte [§6.2]"]
[null,"Confirmer les Objectifs [§6.3]"]
[null,"Conclusion de la Phase Mesurer [§6.4]"]
[null,"Analyser"]
[null,"Analyse de Risque liée au Projet [§7.1]"]
[null,"Hiérarchiser les Causes à Traiter [§7.2]"]
[null,"Quick Win [§7.3]"]
[null,"Confirmation des Impacts [§7.4]"]
[null,"Synthèse Pb/Caus/Opp (ou AMDEC) [§7.5]"]
[null,"Conclusion de la Phase Analyser [§7.6]"]
[null,"Innover"]
[null,"Analyse de Risque liée au Projet [§8.1]"]
[null,"Génération des Solutions [§8.2]"]
[null,"Analyse de Risque liée aux Changements [§8.3]"]
[null,"Expérimenter les Solutions [§8.4]"]
[null,"Projection de Chaque Innovation [§8.5]"]
[null,"Conclusion de la Phase Innover [§8.6]"]
[null,"Contrôler"]
[null,"Analyse de Risque Robustesse Solutions [§9.1]"]
[null,"Efficacité des Actions d'Amélioration [§9.2]"]
[null,"Valider les Spécifications [§9.3]"]
[null,"Définir les Modes Opératoires [§9.4]"]
[null,"Plan de Documentation [§9.5]"]
[null,"Prévoir un Plan de Surveillance [§9.6]"]
[null,"Conclusion de la Phase Contrôler [§9.7]"]
[null,"Standardiser"]
[null,"Analyse de Risques Robustesse Mise en Oeuvre [§10.1]"]
[null,"Finaliser les Modes Opératoires [§10.2]"]
[null,"Construire le Plan de Formation [§10.3]"]
[null,"Préparation Audit de Pérennité [§10.4]"]
[null,"Conclusion de la Phase Standardiser [§10.5]"]
[null,"Clôturer"]
[null,"Bilan du Projet [§11.1]"]
[null,"Recommandations / Bonnes Pratiques [§11.2]"]
[null,"Actions Résiduelles [§11.3]"]
[null,"Analyse de Risques [§11.4]"]
[null,"Mesure d'Efficacité du Projet [§11.5]"]
[null,"Piste d'Innovation/Nouveaux Projets [§11.6]"]
[null,"Conclusion de la Phase Cloturer [§11.7]"]
[null,"Communiquer"]
[null,"Analyse de Risques [§12.1]"]
[null,"Soutenance Gouvernance [§12.2]"]
[null,"Promotion et Reconnaissance [§12.3]"]
[null,"Communication Transversale [§12.4]"]
[null,"Soutenance et Rapport [§12.5]"]
[null,"Conclusion de la Phase Communiquer [§12.6]"]
[null,"Terminer"]
[null,"Passage de Relais [§13.1]"]
[null,"Retex du Projet [§13.2]"]
[null,"Dernière Communication [§13.3]"]
[null,"Conclusion de la Phase Terminer [§13.4]"]

{"sheet":"Objectifs","index":12,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["<Ici les objectifs du Projet, et reprendre les verbes d'action et les décomposer>"]
["ACTION","QUOI","SUJET","CRITERE","OPTION","BENCHMARK","MESURE","COMMENTAIRES","Traité pendant","Sources","Extensions",null,"Revue du __/__/____"]

{"sheet":"Analyse_PP","index":13,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,0,5,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Role (Qui)",null,"RACI",null,"Rôle","Qui","Pouvoir","Intérêt","Analyse_PI","Quoi faire ?","Synergie","Antagonisme","Type de Partie","Analyse_SA",null,"SX-AX","Analyse_SA"]
[null,null,null,null,{"$f":"IFERROR(TRIM(LEFT(A2,SEARCH(\"(\",A2)-1)),\"\")","v":""},{"$f":"IFERROR(TRIM(MID(A2,SEARCH(\"(\",A2)+1,SEARCH(\")\",A2)-SEARCH(\"(\",A2)-1)),\"\")","v":""},null,null,{"$f":"IF(G2>2,IF(H2>2,\"A Manager\",\"A Informer\"),IF(H2>2,\"A Satisfaire\",IF(H2>0,\"A Contrôler\",\"\")))","v":""},{"$f":"IF(I2=\"A Manager\",\"Efforts spécifiques à déployer pour obtenir sa participation. Elle doit être impérativement consultée, ou intégrée aux décisions liées au sujet (C idéalement)\",IF(I2=\"A Satisfaire\",\"Assurer une communication de qualité et ciblée, et essayer d'augmenter son intérêt. (R idéalement)\",IF(I2=\"A Contrôler\",\"Ne pas susciter plus son intérêt, la communication sur le sujet doit être disponible mais ne doit pas lui être adressée. (I maximum)\",IF(I2=\"A Informer\",\"Ne pas la perdre en route, donc bien la tenir informée, l'utiliser comme relais de communication et en écoute discrète des A Contrôler sur son périmètre. (I minimum)\",\"\"))))","v":""},null,null,{"$f":"IF(C2=\"I\",\"Intéressée\",IF(C2>\"\",\"Prenante\",\"\"))","v":""},{"$f":"IFERROR(VLOOKUP(\"S\"&K2&\"-A\"&L2,P:Q,2,FALSE),\"\")","v":""},null,"S1-A1","Passive"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S1-A2","Divergeante / Grognon"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S1-A3","Opposante"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S1-A4","Irréductible / Révoltée"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S2-A1","Suiveuse (entre passive et engagée)"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S2-A2","Hésitante"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S2-A3","Opposante"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S2-A4","Irréductible / Révoltée"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S3-A1","Engagée / Militante"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S3-A2","Concertative / Constructive"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S3-A3","Hésitante"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S3-A4","Irréductible / Révoltée"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S4-A1","Engagée / Militante"]
[null,null,null,null,"","",null,null,"","",null,null,"","",null,"S4-A2","Concertative / Constructive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S4-A3","Concertative / Constructive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S4-A4","Déchirée"]

{"sheet":"Plan_DOC","index":14,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Quoi","%","Quand","Où","Qui","Comment","Combien","Pourquoi"]

{"sheet":"Plan_Comm","index":15,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Quoi ?","A qui ?","Quand ?","Responsable","Comment ?","Où ?","Pourquoi ?"]

{"sheet":"BilanTemps","index":16,"n_rows":13,"n_cols":40,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","Durée",null,"Temps",null,"Début",null,"Fin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T22","v":"Phase"},{"$f":"DonnéesUtiles!U22","v":"Objectif"},{"$f":"DonnéesUtiles!V22","v":"Effectif"},{"$f":"AG3","v":"Objectif"},{"$f":"AH3","v":"Effectif"},"Objectif",{"$f":"AJ3","v":"Effectif"},{"$f":"AK3","v":"Objectif"},"Effectif"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T23","v":"Définir"},{"$f":"DonnéesUtiles!U23","v":0},{"$f":"DonnéesUtiles!V23","v":0},{"$f":"AG4","v":0},{"$f":"AH4","v":0},{"$f":"DonnéesUtiles!O23","v":"00:00:00"},{"$f":"DonnéesUtiles!S23","v":""},{"$f":"DonnéesUtiles!P23","v":"00:00:00"},{"$f":"DonnéesUtiles!R23","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T24","v":"Mesurer"},{"$f":"DonnéesUtiles!U24","v":0},{"$f":"DonnéesUtiles!V24","v":0},{"$f":"AG5-AG4","v":0},{"$f":"AH5-AH4","v":0},{"$f":"DonnéesUtiles!O24","v":"00:00:00"},{"$f":"DonnéesUtiles!S24","v":""},{"$f":"DonnéesUtiles!P24","v":"00:00:00"},{"$f":"DonnéesUtiles!R24","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T25","v":"Analyser"},{"$f":"DonnéesUtiles!U25","v":0},{"$f":"DonnéesUtiles!V25","v":0},{"$f":"AG6-AG5","v":0},0,{"$f":"DonnéesUtiles!O25","v":"00:00:00"},{"$f":"DonnéesUtiles!S25","v":""},{"$f":"DonnéesUtiles!P25","v":"00:00:00"},{"$f":"DonnéesUtiles!R25","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T26","v":"Innover"},{"$f":"DonnéesUtiles!U26","v":0},{"$f":"DonnéesUtiles!V26","v":0},0,0,{"$f":"DonnéesUtiles!O26","v":"00:00:00"},{"$f":"DonnéesUtiles!S26","v":""},{"$f":"DonnéesUtiles!P26","v":"00:00:00"},{"$f":"DonnéesUtiles!R26","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T27","v":"Contrôler"},{"$f":"DonnéesUtiles!U27","v":0},{"$f":"DonnéesUtiles!V27","v":0},0,0,{"$f":"DonnéesUtiles!O27","v":"00:00:00"},{"$f":"DonnéesUtiles!S27","v":""},{"$f":"DonnéesUtiles!P27","v":"00:00:00"},{"$f":"DonnéesUtiles!R27","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T28","v":"Standardiser"},{"$f":"DonnéesUtiles!U28","v":0},{"$f":"DonnéesUtiles!V28","v":0},0,0,{"$f":"DonnéesUtiles!O28","v":""},{"$f":"DonnéesUtiles!S28","v":""},{"$f":"DonnéesUtiles!P28","v":""},{"$f":"DonnéesUtiles!R28","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T29","v":"Clôturer"},{"$f":"IF($AF10=\"\",\"\",DonnéesUtiles!U29)","v":0},{"$f":"IF($AF10=\"\",\"\",DonnéesUtiles!V29)","v":0},{"$f":"IF($AF10=\"\",\"\",AG10-AG9)","v":0},{"$f":"IF($AF10=\"\",\"\",AH10-AH9)","v":0},{"$f":"DonnéesUtiles!O29","v":""},{"$f":"DonnéesUtiles!S29","v":""},{"$f":"DonnéesUtiles!P29","v":""},{"$f":"DonnéesUtiles!R29","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DonnéesUtiles!T30","v":"Communiquer"},{"$f":"IF($AF11=\"\",\"\",DonnéesUtiles!U30)","v":0},{"$f":"IF($AF11=\"\",\"\",DonnéesUtiles!V30)","v":0},{"$f":"IF($AF11=\"\",\"\",AG11-AG10)","v":0},{"$f":"IF($AF11=\"\",\"\",AH11-AH10)","v":0},{"$f":"DonnéesUtiles!O30","v":""},{"$f":"DonnéesUtiles!S30","v":""},{"$f":"DonnéesUtiles!P30","v":""},{"$f":"DonnéesUtiles!R30","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Global",null,null,{"$f":"DonnéesUtiles!U30","v":0},{"$f":"DonnéesUtiles!V30","v":0}]

{"sheet":"SADT_Modèle","index":17,"n_rows":41,"n_cols":75,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Décomposition Fonctionnelle du Processus :",{"$f":"I9 & \" [\" & BB38 & \"]\"","v":"<Saisir en I9 le Processus> [<et BB38 le Code>]"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Supérieur:","??????",null,null,null,"<Saisir en I9 le Processus>"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode.Op"]
[]
[null,null,null,null,null,null,null,null,null,null,"Quoi",null,null,null,null,null,null,null,null,"Quoi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode.Op"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode.Op",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quoi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qui",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quoi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quoi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qui"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode.Op"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qui",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partager la Vision"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quoi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collecter des détails de la demande"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode.Op"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qui",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mesurer le Réel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quoi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comprendre la Demande (évolutions …)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode.Op"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qui",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analyser les Ecarts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quoi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vérifier qu'on a bien toutes les Données d'entrée"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qui",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Améliorer le Système"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comment on répond à l'attente du Client"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mettre en place la Traçabilité (pour UDI)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<et BB38 le Code>",null,null,null,null,null,null,null,null,null,null,null,"Piloter l'Apprentissage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ex. PROQUAL 16188 - Gérer les Améliorations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour d'Expérience"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qu'est-ce qui est à améliorer dans le processus"]

{"sheet":"PCO","index":18,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,1,32,2],[1,1,1,2],[24,1,24,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[13,1,13,2],[14,1,14,2],[23,1,23,2],[22,1,22,2]]}
[]
[null,"Tableaux des Problématiques / Causes / Opportunités concernant les Objetifs du Projet"]
[null,"Livrable de fin de Phase Analyser et permettant de partager la vision avec les Initiateurs de manière synthétique"]
[null,"Problématique : [1] Non tenue de l'Objectif Principal"]
[null,"Mettre en place une …"]
[null,"Causes Testées et Hiérarchisées :","Opportunités d’Amélioration :"]
[null,"1. Incomplète","1. Avoir une …"]
[null,"2. Non-Efficiente","2. Ne pas avoir une …"]
[null,"3. Mettre effectivement en place","3. Proposer un …"]
[null,"Autres Causes Possibles :","Opportunités d’Amélioration :"]
[null,"4. ...","4. ..."]
[null,"5. ...","5. ..."]
[]
[null,"Problématique : [2] Non tenue d'un Objectif Secondaire"]
[null,"Avoir une …"]
[null,"Causes Testées et Hiérarchisées :","Opportunités d’Amélioration :"]
[null,"1. Incomplète","1. Lister …"]
[null,"2. Trop complète","2. Réduire …"]
[null,"3. …","3. …"]
[null,"Autres Causes Possibles :","Opportunités d’Amélioration :"]
[null,"4. ...","4. ..."]
[null,"5. ...","5. ..."]
[]
[null,"Problématique : [3] Non tenue d'un Objectif Secondaire"]
[null,"Assurer le …"]
[null,"Causes Testées et Hiérarchisées :","Opportunités d’Amélioration :"]
[null,"1. Pas …","1. Proposer …"]
[null,"2. Pas …","2. …"]
[null,"3. Pas …","3. …"]
[null,"Autres Causes Possibles :","Opportunités d’Amélioration :"]
[null,"4. …","4. …"]
[null,"5. …","5. …"]

{"sheet":"Lexique","index":19,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Terme","Domaine","Définition","Obligations","Interdictions","Projet"]

{"sheet":"Plan_Collecte","index":20,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,6,0,7]]}
[null,"QUOI","QUI","OÙ","QUAND",null,"COMMENT",null,"COMBIEN","POURQUOI"]
["N°","Caractéristique mesurée / CTQ","Acteur de\nla mesure","Etape","Période","Fréquence","Instructions de Mesure","Capabilité","Nb de mesures","Pourquoi cette mesure est nécessaire"]

{"sheet":"Couleurs","index":21,"n_rows":139,"n_cols":6,"rows_kept":139,"cut":false,"hidden":true,"merged":[]}
["Index","Nom","Vue","R","V","B"]
[null,"black",null,"0","0","0"]
[null,"dimgray, dimgrey",null,"105","105","105"]
[6,"gray, grey",null,"128","128","128"]
[null,"darkgray, darkgrey",null,"169","169","169"]
[null,"silver",null,"192","192","192"]
[1,"lightgray, lightgrey",null,"211","211","211"]
[null,"gainsboro",null,"220","220","220"]
[null,"whitesmoke",null,"245","245","245"]
[null,"white",null,"255","255","255"]
[null,"lavenderblush",null,"255","240","245"]
[2,"palevioletred",null,"219","112","147"]
[null,"crimson",null,"220","20","60"]
[null,"pink",null,"255","192","203"]
[null,"lightpink",null,"255","182","193"]
[null,"maroon",null,"128","0","0"]
[null,"darkred",null,"139","0","0"]
[null,"red",null,"255","0","0"]
[null,"firebrick",null,"178","34","34"]
[4,"brown",null,"165","42","42"]
[null,"indianred",null,"205","92","92"]
[null,"lightcoral",null,"240","128","128"]
[null,"rosybrown",null,"188","143","143"]
[null,"snow",null,"255","250","250"]
[null,"mistyrose",null,"255","228","225"]
[null,"salmon",null,"250","128","114"]
[null,"tomato",null,"255","99","71"]
[null,"darksalmon",null,"233","150","122"]
[13,"coral",null,"255","127","80"]
[null,"orangered",null,"255","69","0"]
[null,"lightsalmon",null,"255","160","122"]
[null,"sienna",null,"160","82","45"]
[null,"seashell",null,"255","245","238"]
[null,"saddlebrown",null,"139","69","19"]
[3,"chocolate",null,"210","105","30"]
[null,"sandybrown",null,"244","164","96"]
[null,"peachpuff",null,"255","218","185"]
[null,"peru",null,"205","133","63"]
[null,"linen",null,"250","240","230"]
[null,"bisque",null,"255","228","196"]
[null,"darkorange",null,"255","140","0"]
[14,"burlywood",null,"222","184","135"]
[null,"tan",null,"210","180","140"]
[null,"antiquewhite",null,"250","235","215"]
[null,"navajowhite",null,"255","222","173"]
[null,"blanchedalmond",null,"255","235","205"]
[null,"papayawhip",null,"255","239","213"]
[null,"moccasin",null,"255","228","181"]
[null,"orange",null,"255","165","0"]
[null,"wheat",null,"245","222","179"]
[null,"oldlace",null,"253","245","230"]
[null,"floralwhite",null,"255","250","240"]
[null,"darkgoldenrod",null,"184","134","11"]
[null,"goldenrod",null,"218","165","32"]
[null,"cornsilk",null,"255","248","220"]
[12,"gold",null,"255","215","0"]
[null,"khaki",null,"240","230","140"]
[null,"lemonchiffon",null,"255","250","205"]
[null,"palegoldenrod",null,"238","232","170"]
[null,"darkkhaki",null,"189","183","107"]
[null,"olive",null,"128","128","0"]
[5,"yellow",null,"255","255","0"]
[null,"lightgoldenrodyellow",null,"250","250","210"]
[null,"lightyellow",null,"255","255","224"]
[null,"beige",null,"245","245","220"]
[null,"ivory",null,"255","255","240"]
[null,"olivedrab",null,"107","142","35"]
[15,"yellowgreen",null,"154","205","50"]
[null,"darkolivegreen",null,"85","107","47"]
[null,"greenyellow",null,"173","255","47"]
[null,"chartreuse",null,"127","255","0"]
[null,"lawngreen",null,"124","252","0"]
[null,"darkgreen",null,"0","100","0"]
[null,"green",null,"0","128","0"]
[null,"lime",null,"0","255","0"]
[null,"limegreen",null,"50","205","50"]
[null,"forestgreen",null,"34","139","34"]
[11,"lightgreen",null,"144","238","144"]
[null,"palegreen",null,"152","251","152"]
[null,"darkseagreen",null,"143","188","143"]
[null,"honeydew",null,"240","255","240"]
[null,"seagreen",null,"46","139","87"]
[null,"mediumseagreen",null,"60","179","113"]
[null,"springgreen",null,"0","255","127"]
[null,"mintcream",null,"245","255","250"]
[10,"mediumspringgreen",null,"0","250","154"]
[null,"mediumaquamarine",null,"102","205","170"]
[null,"aquamarine",null,"127","255","212"]
[null,"turquoise",null,"64","224","208"]
[null,"lightseagreen",null,"32","178","170"]
[null,"mediumturquoise",null,"72","209","204"]
[null,"teal",null,"0","128","128"]
[null,"darkcyan",null,"0","139","139"]
[null,"aqua, cyan",null,"0","255","255"]
[null,"darkslategray, darkslategrey",null,"47","79","79"]
[null,"paleturquoise",null,"175","238","238"]
[null,"lightcyan",null,"224","255","255"]
[null,"azure",null,"240","255","255"]
[null,"darkturquoise",null,"0","206","209"]
[null,"cadetblue",null,"95","158","160"]
[null,"powderblue",null,"176","224","230"]
[null,"lightblue",null,"173","216","230"]
[null,"deepskyblue",null,"0","191","255"]
[null,"skyblue",null,"135","206","235"]
[null,"lightskyblue",null,"135","206","250"]
[8,"steelblue",null,"70","130","180"]
[null,"aliceblue",null,"240","248","255"]
[null,"dodgerblue",null,"30","144","255"]
[null,"slategray, slategrey",null,"112","128","144"]
[null,"lightslategray, lightslategrey",null,"119","136","153"]
[null,"lightsteelblue",null,"176","196","222"]
[null,"cornflowerblue",null,"100","149","237"]
[9,"royalblue",null,"65","105","225"]
[null,"navy",null,"0","0","128"]
[null,"darkblue",null,"0","0","139"]
[null,"mediumblue",null,"0","0","205"]
[null,"blue",null,"0","0","255"]
[null,"midnightblue",null,"25","25","112"]
[null,"lavender",null,"230","230","250"]
[null,"ghostwhite",null,"248","248","255"]
[null,"slateblue",null,"106","90","205"]
[null,"mediumslateblue",null,"123","104","238"]
[null,"darkslateblue",null,"72","61","139"]
[null,"mediumpurple",null,"147","112","219"]
[null,"blueviolet",null,"138","43","226"]
[null,"indigo",null,"75","0","130"]
[null,"darkorchid",null,"153","50","204"]
[null,"darkviolet",null,"148","0","211"]
[null,"mediumorchid",null,"186","85","211"]
[null,"purple",null,"128","0","128"]
[null,"darkmagenta",null,"139","0","139"]
[null,"fuchsia, magenta",null,"255","0","255"]
[null,"violet",null,"238","130","238"]
[7,"plum",null,"221","160","221"]
[null,"thistle",null,"216","191","216"]
[null,"orchid",null,"218","112","214"]
[null,"mediumvioletred",null,"199","21","133"]
[null,"deeppink",null,"255","20","147"]
[null,"hotpink",null,"255","105","180"]

{"sheet":"N+1","index":22,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[" PNOM ?"," N+1 !","PRJ3","PRJ2"]
["AAFFANE"]
["AATBIR","KELOUAZZANI"]
["ABRISARD"]
["AGAUDUCHON"]
["AGILBERT","CFLOURIOT"]
["AMARQUES","GCHASSAT"]
["BESNAULT","ELENOIR"]
["CBELLAY","JGATINEAU"]
["CDRIENCOURT","ELENOIR"]
["CDUNAND","MCOLLIOU"]
["CFLOURIOT","JBBUISSON","PRJ3"]
["CPLOUZENNEC","TLEBLANC"]
["CSELLE","JBBUISSON"]
["CTROVALET"]
["DMORILLE"]
["EBARBIER"]
["EGUERRAULT"]
["ELENOIR","GCHASSAT","PRJ3","PRJ2"]
["EMENU"]
["FJACOB","ELENOIR"]
["FMARIETTE","JBBUISSON","PRJ3"]
["GCHASSAT","JBBUISSON","PRJ3","PRJ2"]
["GDELARUE","JLVERLHAC"]
["GVILAIN"]
["HHOUDMON","GCHASSAT"]
["JBBUISSON","SELHAGROUP","PRJ3"]
["JEHUBERT"]
["JFMAHE","JBBUISSON"]
["JGATINEAU","MCOLLIOU"]
["JLVERLHAC"]
["JMCAVAREC"]
["KELOUAZZANI"]
["LLEBRET","AMARQUES"]
["LTHEIL","CSELLE"]
["LTHEULIER","LTHEIL"]
["LTHIBAULT","CPLOUZENNEC"]
["MCOLLIOU","JBBUISSON","PRJ3"]
["MDURAND"]
["MLODE","LTHEIL"]
["NPEULEVEY"]
["PMASSELIN","JBBUISSON","PRJ3"]
["PPELLOIE","CDUNAND"]
["RBOULANGER","HHOUDMON"]
["RJOUSSE"]
["SFATIEN","CFLOURIOT"]
["TCHAUVIRE","JFMAHE"]
["TLEBLANC","MCOLLIOU"]
["VBARRAIS"]
["VBOUDET"]
["VBRIQUET","EGUERRAULT"]
["VLUCAS"]

{"sheet":"LOG","index":23,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Qui","LogIn","LogOut","Quoi","Où"]

{"sheet":"Tables","index":24,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Statut","Statut_TXT","=>",null,"CPE","Phase_En_Cours","CPS","ST","Q","Q_TXT","C","C_TXT","D","D_TXT","R","R_TXT"]
[-1,"Annulé","0",null,0,"Décider",0,3,"?",null,"?",null,"?",null,1,"Attente décision"]
[0,"Temporisé","0",null,1,"Définir",1,4,null,null,null,null,null,null,0.75,"Attente ressource"]
[1,"Bloqué","0-9",null,2,"Mesurer",2,4,null,null,null,null,null,null,0.5,"Problème identifié (non couvert)"]
[2,"Pressenti","0",null,3,"Analyser",3,4,null,null,null,null,null,null,0.25,"Risque identifié et action en cours"]
[3,"Initialisé","0-1",null,4,"Innover",4,4,null,null,null,null,null,null,0,"Aucun risque identifié ou risque sous contrôle"]
[4,"En-Cours","1-8",null,5,"Contrôler",5,4,"Qualité",null,"Coût",null,"Délai",null,"Risque"]
[5,"Terminé","9",null,6,"Standardiser",6,4,"Meilleure note",null,"Meilleure note",null,"Meilleure note",null,"Meilleure note"]
[6,"Archivé",10,null,7,"Clôturer",7,4,1,null,0,null,2,null,0]
[null,null,null,null,8,"Communiquer",8,4,"Objectif",null,"Objectif",null,"Objectif",null,"Objectif"]
[null,null,null,null,9,"Terminer",9,4,0.8,null,1,null,1,null,0.25]
[null,null,null,null,10,"Archiver",10,5,"Pire note",null,"Pire note",null,"Pire note",null,"Pire note"]
[null,null,null,null,null,null,null,null,0,null,2,null,0,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avec 75 ou 100 entraitant un basculement du statut à bloqué !"]
[null,null,null,null,null,null,null,null,"idée: challenge de l'équipe sur leurs livrables!",null,"ex. 82h 21 semaines"]
[null,null,null,null,null,null,null,null,"lien avec plan d'actions",null,"pb semaines : fermeture"]
[null,null,null,null,null,null,null,null,null,null,"solution : heures !"]
[null,null,null,null,null,null,null,null,"Q : nb actions bonnes du premier coup / nombre répondu",null,"C = heures réellement passées / heures prévues.",null,"D = avancement actuel / avancement prévu"]
[null,null,null,null,null,null,null,null,"idée : support de comptabilisation à créer et à proposer",null,"idée : support de comptabilisation à créer et à proposer"]
[null,null,null,null,null,null,null,null,"Stratégique : obligatoire",null,"Stratégique : obligatoire",null,"Stratégique : obligatoire"]
[null,null,null,null,null,null,null,null,"Autre projet ou non calculable (accepte évaluation au nez)",null,"Autre projet ou non calculable (accepte évaluation au nez)",null,"Autre projet ou non calculable (accepte évaluation au nez)"]
[]
[null,null,null,null,null,null,null,null,"Risque Gouvernance : 2 objectifs différents : simplicité (Excel) et suivi d'actions (SAP)"]