{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Planning","Stat","Feuille données"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Planning","index":0,"n_rows":53,"n_cols":167,"rows_kept":53,"cut":false,"hidden":false,"merged":[[7,154,7,155],[7,156,7,157],[7,158,7,159],[7,160,7,161],[7,162,7,163],[7,164,7,165],[7,166,7,167],[7,136,7,137],[7,138,7,139],[7,140,7,141],[7,142,7,143],[7,144,7,145],[7,146,7,147],[7,148,7,149],[7,150,7,151],[7,152,7,153],[7,118,7,119],[7,120,7,121],[7,122,7,123],[7,124,7,125],[7,126,7,127],[7,128,7,129],[7,130,7,131],[7,132,7,133],[7,134,7,135],[7,100,7,101],[7,102,7,103],[7,104,7,105],[7,106,7,107],[7,108,7,109],[7,110,7,111],[7,112,7,113],[7,114,7,115],[7,116,7,117],[7,80,7,81],[7,82,7,83],[7,84,7,85],[7,86,7,87],[7,88,7,89],[7,90,7,91],[7,92,7,93],[7,94,7,95],[7,96,7,97],[3,87,4,100],[8,154,8,155],[8,156,8,157],[8,158,8,159],[8,160,8,161],[8,162,8,163],[8,164,8,165],[8,136,8,137],[8,138,8,139],[8,140,8,141],[8,142,8,143],[8,152,8,153],[8,148,8,149],[8,150,8,151],[8,118,8,119],[8,120,8,121],[8,122,8,123],[8,124,8,125],[8,126,8,127],[8,128,8,129],[8,130,8,131],[8,132,8,133],[8,134,8,135],[7,98,7,99],[2,1,2,4],[9,62,9,63],[9,64,9,65],[9,66,9,67],[9,68,9,69],[9,70,9,71],[9,72,9,73],[9,74,9,75],[3,62,3,63],[3,64,3,70],[4,64,4,70],[4,62,4,63],[4,1,4,4],[6,64,6,65],[3,72,4,85],[7,62,7,63],[7,64,7,65],[7,66,7,67],[7,68,7,69],[7,70,7,71],[7,72,7,73],[7,74,7,75],[7,76,7,77],[7,78,7,79],[9,162,9,163],[9,164,9,165],[8,84,8,85],[8,86,8,87],[8,88,8,89],[8,90,8,91],[8,92,8,93],[8,94,8,95],[8,96,8,97],[8,98,8,99],[8,100,8,101],[8,102,8,103],[8,104,8,105],[8,106,8,107],[8,108,8,109],[8,110,8,111],[8,112,8,113],[8,114,8,115],[8,116,8,117],[8,144,8,145],[8,146,8,147],[9,108,9,109],[9,110,9,111],[9,112,9,113],[9,114,9,115],[9,116,9,117],[9,118,9,119],[9,156,9,157],[9,158,9,159],[9,160,9,161],[9,154,9,155],[9,120,9,121],[9,122,9,123],[9,124,9,125],[9,126,9,127],[9,128,9,129],[9,130,9,131],[9,132,9,133],[9,134,9,135],[9,136,9,137],[9,138,9,139],[9,140,9,141],[9,142,9,143],[9,144,9,145],[9,146,9,147],[9,148,9,149],[9,150,9,151],[9,152,9,153],[9,90,9,91],[9,92,9,93],[9,94,9,95],[9,96,9,97],[9,98,9,99],[9,100,9,101],[9,102,9,103],[9,104,9,105],[9,106,9,107],[8,166,8,167],[9,166,9,167],[8,62,8,63],[3,1,3,4],[1,1,1,4],[5,1,5,4],[9,76,9,77],[9,78,9,79],[9,80,9,81],[9,82,9,83],[8,64,8,65],[8,66,8,67],[8,68,8,69],[8,70,8,71],[8,72,8,73],[8,74,8,75],[8,76,8,77],[8,78,8,79],[8,80,8,81],[8,82,8,83],[6,3,6,4],[9,84,9,85],[9,86,9,87],[9,88,9,89]]}
[]
[null,{"$f":"TODAY()","v":"2023-11-27"}]
[null,{"$f":"WEEKNUM(B2,21)","v":48}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semaine en cours",null,null,null,null,null,null,null,"Clic ici pour remise à zéro des dates de 1ère opération",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clic ici pour remise à zéro des actions réalisées"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour férie dans la semaine"]
[null,"OPTION POUR AJOUT DE LIGNE"]
[null,"Test 1","Machine 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BK9","v":"2023-01-02"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BM9","v":"2023-01-09"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BO9","v":"2023-01-16"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BQ9","v":"2023-01-23"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BS9","v":"2023-01-30"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BU9","v":"2023-02-06"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BW9","v":"2023-02-13"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BY9","v":"2023-02-20"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CA9","v":"2023-02-27"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CC9","v":"2023-03-06"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CE9","v":"2023-03-13"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CG9","v":"2023-03-20"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CI9","v":"2023-03-27"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CK9","v":"2023-04-03"},null,null,null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CO9","v":"2023-04-17"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CQ9","v":"2023-04-24"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CS9","v":"2023-05-01"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CU9","v":"2023-05-08"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CW9","v":"2023-05-15"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CY9","v":"2023-05-22"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DA9","v":"2023-05-29"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DC9","v":"2023-06-05"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DE9","v":"2023-06-12"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DG9","v":"2023-06-19"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DI9","v":"2023-06-26"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DK9","v":"2023-07-03"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DM9","v":"2023-07-10"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DO9","v":"2023-07-17"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DQ9","v":"2023-07-24"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DS9","v":"2023-07-31"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DU9","v":"2023-08-07"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DW9","v":"2023-08-14"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DY9","v":"2023-08-21"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EA9","v":"2023-08-28"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EC9","v":"2023-09-04"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EE9","v":"2023-09-11"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EG9","v":"2023-09-18"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EI9","v":"2023-09-25"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EK9","v":"2023-10-02"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EM9","v":"2023-10-09"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EO9","v":"2023-10-16"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EQ9","v":"2023-10-23"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*ES9","v":"2023-10-30"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EU9","v":"2023-11-06"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EW9","v":"2023-11-13"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*EY9","v":"2023-11-20"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*FA9","v":"2023-11-27"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*FC9","v":"2023-12-04"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*FE9","v":"2023-12-11"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*FG9","v":"2023-12-18"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*FI9","v":"2023-12-25"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*FK9","v":"2024-01-01"}]
[null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"WEEKNUM('Feuille données'!F3)","v":1},null,{"$f":"BK9+1","v":2},null,{"$f":"BM9+1","v":3},null,{"$f":"BO9+1","v":4},null,{"$f":"BQ9+1","v":5},null,{"$f":"BS9+1","v":6},null,{"$f":"BU9+1","v":7},null,{"$f":"BW9+1","v":8},null,{"$f":"BY9+1","v":9},null,{"$f":"CA9+1","v":10},null,{"$f":"CC9+1","v":11},null,{"$f":"CE9+1","v":12},null,{"$f":"CG9+1","v":13},null,{"$f":"CI9+1","v":14},null,{"$f":"CK9+1","v":15},null,{"$f":"CM9+1","v":16},null,{"$f":"CO9+1","v":17},null,{"$f":"CQ9+1","v":18},null,{"$f":"CS9+1","v":19},null,{"$f":"CU9+1","v":20},null,{"$f":"CW9+1","v":21},null,{"$f":"CY9+1","v":22},null,{"$f":"DA9+1","v":23},null,{"$f":"DC9+1","v":24},null,{"$f":"DE9+1","v":25},null,{"$f":"DG9+1","v":26},null,{"$f":"DI9+1","v":27},null,{"$f":"DK9+1","v":28},null,{"$f":"DM9+1","v":29},null,{"$f":"DO9+1","v":30},null,{"$f":"DQ9+1","v":31},null,{"$f":"DS9+1","v":32},null,{"$f":"DU9+1","v":33},null,{"$f":"DW9+1","v":34},null,{"$f":"DY9+1","v":35},null,{"$f":"EA9+1","v":36},null,{"$f":"EC9+1","v":37},null,{"$f":"EE9+1","v":38},null,{"$f":"EG9+1","v":39},null,{"$f":"EI9+1","v":40},null,{"$f":"EK9+1","v":41},null,{"$f":"EM9+1","v":42},null,{"$f":"EO9+1","v":43},null,{"$f":"EQ9+1","v":44},null,{"$f":"ES9+1","v":45},null,{"$f":"EU9+1","v":46},null,{"$f":"EW9+1","v":47},null,{"$f":"EY9+1","v":48},null,{"$f":"FA9+1","v":49},null,{"$f":"FC9+1","v":50},null,{"$f":"FE9+1","v":51},null,{"$f":"FG9+1","v":52},null,{"$f":"FI9+1","v":53}]
[null,"ZONE","SECTEUR","N°","Désignation opération","Date 1ère opération","N°Sem","Périodicité","Nb Se"]
[null,null,null,null,"NE RIEN ECRIRE DANS CETTE CELLULE",null,null,null,{"$f":"IF(H11<>\"\",VLOOKUP($H11,Tableau1[],2,FALSE),\"\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$BK$9:$FL$9,0)+8, MOD(COLUMN()-MATCH($G11,$BK$9:$FL$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""}]
[null,"Test 1","Machine 4",null,null,"2023-01-02",{"$f":"IF(F12<>\"\",WEEKNUM(F12,21),\"\")","v":1},"3 Semaines",{"$f":"IF(H12<>\"\",VLOOKUP($H12,Tableau1[],2,FALSE),\"\")","v":3},{"$f":"IF(ISNUMBER($I12),G12+I12&\"-\"&YEAR($F12+(G12+I12)*7),_xlfn.ISOWEEKNUM(EDATE(F12,LEN(I12)))&\"-\"&YEAR(EDATE(F12,LEN(I12))))","v":"4-2023"},{"$f":"IF(ISNUMBER($I12),_xlfn.ISOWEEKNUM($F12+$I12*(COLUMN()-9)*7)&\"-\"&YEAR($F12+$I12*(COLUMN()-9)*7),_xlfn.ISOWEEKNUM(EDATE($F12,LEN($I12)*(COLUMN()-9)))&\"-\"&YEAR((EDATE($F12,LEN($I12)*(COLUMN()-9)))))","v":"7-2023"},{"$f":"IF(ISNUMBER($I12),_xlfn.ISOWEEKNUM($F12+$I12*(COLUMN()-9)*7)&\"-\"&YEAR($F12+$I12*(COLUMN()-9)*7),_xlfn.ISOWEEKNUM(EDATE($F12,LEN($I12)*(COLUMN()-9)))&\"-\"&YEAR((EDATE($F12,LEN($I12)*(COLUMN()-9)))))","v":"10-2023"},"13-2023","16-2023","19-2023","22-2023","25-2023","28-2023","31-2023","34-2023","37-2023","40-2023","43-2023","46-2023","49-2023","52-2023","3-2024","6-2024","9-2024","12-2024","15-2024","18-2024","21-2024","24-2024","27-2024","30-2024","33-2024","36-2024","39-2024","42-2024","45-2024","48-2024","51-2024","2-2025","5-2025","8-2025","11-2025","14-2025","17-2025","20-2025","23-2025","26-2025","29-2025","32-2025","35-2025","38-2025","41-2025","44-2025","47-2025","50-2025","1-2025","4-2026",{"$f":"IF(AND($G12>0,$H12<>\"\"),IF(BK$9=$G12,\"P\",IF(COUNTIF($J12:$BJ12,BK$9&\"-\"&YEAR(BK$8))=1,\"P\",\"\")),\"\")","v":"P"},null,{"$f":"IF(AND($G12<>\"\",$H12<>\"\"),IF(BM$9=$G12,\"P\",IF(COUNTIF($J12:$BJ12,BM$9&\"-\"&YEAR(BM$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,{"$f":"IF(AND($G12<>\"\",$H12<>\"\"),IF(CC$9=$G12,\"P\",IF(COUNTIF($J12:$BJ12,CC$9&\"-\"&YEAR(CC$8))=1,\"P\",\"\")),\"\")","v":"P"},null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,{"$f":"IF(AND($G12<>\"\",$H12<>\"\"),IF(EO$9=$G12,\"P\",IF(COUNTIF($J12:$BJ12,EO$9&\"-\"&YEAR(EO$8))=1,\"P\",\"\")),\"\")","v":""},null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,"",null,"",null,"P",null,""]
[null,"Test 2","Machine 6",null,null,"2023-01-02",1,"Mensuel",{"$f":"IF(H13<>\"\",VLOOKUP($H13,Tableau1[],2,FALSE),\"\")","v":"m"},{"$f":"IF(ISNUMBER($I13),G13+I13&\"-\"&YEAR($F13+(G13+I13)*7),_xlfn.ISOWEEKNUM(EDATE(F13,LEN(I13)))&\"-\"&YEAR(EDATE(F13,LEN(I13))))","v":"5-2023"},{"$f":"IF(ISNUMBER($I13),_xlfn.ISOWEEKNUM($F13+$I13*(COLUMN()-9)*7)&\"-\"&YEAR($F13+$I13*(COLUMN()-9)*7),_xlfn.ISOWEEKNUM(EDATE($F13,LEN($I13)*(COLUMN()-9)))&\"-\"&YEAR((EDATE($F13,LEN($I13)*(COLUMN()-9)))))","v":"9-2023"},"13-2023","18-2023","22-2023","26-2023","31-2023","35-2023","40-2023","44-2023","48-2023","1-2024","5-2024","9-2024","14-2024","18-2024","22-2024","27-2024","31-2024","36-2024","40-2024","44-2024","49-2024","1-2025","5-2025","9-2025","14-2025","18-2025","23-2025","27-2025","31-2025","36-2025","40-2025","44-2025","49-2025","1-2026","6-2026","10-2026","14-2026","18-2026","23-2026","27-2026","31-2026","36-2026","40-2026","45-2026","49-2026","53-2027","5-2027","9-2027","13-2027","17-2027","22-2027","P",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H14<>\"\",VLOOKUP($H14,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(AND($G14>0,$H14<>\"\"),IF(BK$9=$G14,\"P\",IF(COUNTIF($J14:$BJ14,BK$9&\"-\"&YEAR(BK$8))=1,\"P\",\"\")),\"\")","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,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H15<>\"\",VLOOKUP($H15,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(AND($G15>0,$H15<>\"\"),IF(BK$9=$G15,\"P\",IF(COUNTIF($J15:$BJ15,BK$9&\"-\"&YEAR(BK$8))=1,\"P\",\"\")),\"\")","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,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H16<>\"\",VLOOKUP($H16,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Hebdo",{"$f":"IF(H17<>\"\",VLOOKUP($H17,Tableau1[],2,FALSE),\"\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","6 Semaines",{"$f":"IF(H18<>\"\",VLOOKUP($H18,Tableau1[],2,FALSE),\"\")","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H19<>\"\",VLOOKUP($H19,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":"IF(AND($G19<>\"\",$H19<>\"\"),IF(EM$9=$G19,\"P\",IF(COUNTIF($J19:$BJ19,EM$9&\"-\"&YEAR(EM$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H20<>\"\",VLOOKUP($H20,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H21<>\"\",VLOOKUP($H21,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H22<>\"\",VLOOKUP($H22,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","6 Semaines",{"$f":"IF(H23<>\"\",VLOOKUP($H23,Tableau1[],2,FALSE),\"\")","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Hebdo",{"$f":"IF(H24<>\"\",VLOOKUP($H24,Tableau1[],2,FALSE),\"\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H25<>\"\",VLOOKUP($H25,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H26<>\"\",VLOOKUP($H26,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","6 Semaines",{"$f":"IF(H27<>\"\",VLOOKUP($H27,Tableau1[],2,FALSE),\"\")","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":"IF(AND($G27<>\"\",$H27<>\"\"),IF(EK$9=$G27,\"P\",IF(COUNTIF($J27:$BJ27,EK$9&\"-\"&YEAR(EK$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H28<>\"\",VLOOKUP($H28,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(AND($G28<>\"\",$H28<>\"\"),IF(BM$9=$G28,\"P\",IF(COUNTIF($J28:$BJ28,BM$9&\"-\"&YEAR(BM$8))=1,\"P\",\"\")),\"\")","v":""},null,{"$f":"IF(AND($G28<>\"\",$H28<>\"\"),IF(BO$9=$G28,\"P\",IF(COUNTIF($J28:$BJ28,BO$9&\"-\"&YEAR(BO$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(AND($G28<>\"\",$H28<>\"\"),IF(CC$9=$G28,\"P\",IF(COUNTIF($J28:$BJ28,CC$9&\"-\"&YEAR(CC$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(AND($G28<>\"\",$H28<>\"\"),IF(CS$9=$G28,\"P\",IF(COUNTIF($J28:$BJ28,CS$9&\"-\"&YEAR(CS$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(AND($G28<>\"\",$H28<>\"\"),IF(DI$9=$G28,\"P\",IF(COUNTIF($J28:$BJ28,DI$9&\"-\"&YEAR(DI$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(AND($G28<>\"\",$H28<>\"\"),IF(DY$9=$G28,\"P\",IF(COUNTIF($J28:$BJ28,DY$9&\"-\"&YEAR(DY$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(AND($G28<>\"\",$H28<>\"\"),IF(EO$9=$G28,\"P\",IF(COUNTIF($J28:$BJ28,EO$9&\"-\"&YEAR(EO$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,{"$f":"IF(AND($G28<>\"\",$H28<>\"\"),IF(FE$9=$G28,\"P\",IF(COUNTIF($J28:$BJ28,FE$9&\"-\"&YEAR(FE$8))=1,\"P\",\"\")),\"\")","v":""},null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H29<>\"\",VLOOKUP($H29,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H30<>\"\",VLOOKUP($H30,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H31<>\"\",VLOOKUP($H31,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H32<>\"\",VLOOKUP($H32,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H33<>\"\",VLOOKUP($H33,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H34<>\"\",VLOOKUP($H34,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Trimestriel",{"$f":"IF(H35<>\"\",VLOOKUP($H35,Tableau1[],2,FALSE),\"\")","v":"mmm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H36<>\"\",VLOOKUP($H36,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H37<>\"\",VLOOKUP($H37,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","6 Semaines",{"$f":"IF(H38<>\"\",VLOOKUP($H38,Tableau1[],2,FALSE),\"\")","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Hebdo",{"$f":"IF(H39<>\"\",VLOOKUP($H39,Tableau1[],2,FALSE),\"\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H40<>\"\",VLOOKUP($H40,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H41<>\"\",VLOOKUP($H41,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H42<>\"\",VLOOKUP($H42,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H43<>\"\",VLOOKUP($H43,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","6 Semaines",{"$f":"IF(H44<>\"\",VLOOKUP($H44,Tableau1[],2,FALSE),\"\")","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Hebdo",{"$f":"IF(H45<>\"\",VLOOKUP($H45,Tableau1[],2,FALSE),\"\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H46<>\"\",VLOOKUP($H46,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H47<>\"\",VLOOKUP($H47,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H48<>\"\",VLOOKUP($H48,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H49<>\"\",VLOOKUP($H49,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H50<>\"\",VLOOKUP($H50,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H51<>\"\",VLOOKUP($H51,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H52<>\"\",VLOOKUP($H52,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H53<>\"\",VLOOKUP($H53,Tableau1[],2,FALSE),\"\")","v":"m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,""]

{"sheet":"Stat","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,2,3,4],[3,6,3,7],[1,2,1,7],[6,2,7,2],[6,3,7,3],[6,6,7,6]]}
[]
[null,null,"Stat réalisation annuelle"]
[]
[null,null,null,null,null,null,"Test 1"]
[]
[null,null,null,"Nb","Tx",null,"Nb","Tx"]
[null,null,"Opérations Prévues",{"$f":"COUNTIFS(Planning!BK12:FL1506,\"P\")","v":30},{"$f":"IF(D9>0,1-E9,\"\")","v":""},null,{"$f":"SUMPRODUCT(--(Planning!$B$12:$B$1506=$G$4)*(Planning!$BK$12:$FL$1506=$B$8))","v":18},{"$f":"IF(G9>0,1-H9,\"\")","v":""}]
[null,"P",null,null,{"$f":"IF(D10>0,1-E10,\"\")","v":{"$error":"#N/A"}},null,null,{"$f":"IF(G10>0,1-H10,\"\")","v":{"$error":"#N/A"}}]
[null,"X","Opérations réalisées totales",{"$f":"COUNTIFS(Planning!BK12:FL1506,\"X\")","v":0},{"$f":"IF(D7>0,D9/D7,\"\")","v":0},null,{"$f":"SUMPRODUCT(--(Planning!$B$12:$B$1506=$G$4)*(Planning!$BK$12:$FL$1506=$B$9))","v":0},{"$f":"IF(G7>0,G9/G7,\"\")","v":0}]
[null,null,"Opéarations réalisées à date",{"$f":"SUMPRODUCT((Planning!$BK12:$FL1506=\"X\")*(Planning!$I12:$FK1506=\"P\"))","v":{"$error":"#N/A"}},{"$f":"IF(D7>0,D10/D7,\"\")","v":{"$error":"#N/A"}},null,{"$f":"SUMPRODUCT((Planning!$BK12:$FL1506=\"X\")*(Planning!$I12:$FK1506=\"P\")*(Planning!$B$12:$B$1506=$G$4))","v":{"$error":"#N/A"}},{"$f":"IF(G7>0,G10/G7,\"\")","v":{"$error":"#N/A"}}]

{"sheet":"Feuille données","index":2,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Choix année",null,null,"Premier jour de l'année ",{"$f":"DATE(B4,1,1)","v":"2023-01-01"}]
[null,2023]
[]
[null,"Periodicité","Nbr sem",null,"Date du jour ","Colonne1","Nom Jour férié",null,"ZONE",null,"SECTEUR"]
[null,"Hebdo",1,null,{"$f":"DATE(B4,1,1)","v":"2023-01-01"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":1},"Jour de l’An",null,"Test 1",null,"Machine 1"]
[null,"2 Semaines",{"$f":"C7*2","v":2},null,{"$f":"ROUND(DATE(B4,4,MOD(234-11*MOD(B4,19),30))/7,0)*7-6","v":"2023-04-09"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":15},"Pâques",null,"Test 2",null,"Machine 2"]
[null,"3 Semaines",{"$f":"3*C7","v":3},null,{"$f":"E8+1","v":"2023-04-10"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":15},"Lundi de Pâques",null,null,null,"Machine 3"]
[null,"Mensuel","m",null,{"$f":"DATE(B4,5,1)","v":"2023-05-01"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":18},"Fête du travail",null,null,null,"Machine 4"]
[null,"6 Semaines",{"$f":"C9*2","v":6},null,{"$f":"DATE(B4,5,8)","v":"2023-05-08"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":19},"Victoire 1945",null,null,null,"Machine 5"]
[null,"Trimestriel","mmm",null,{"$f":"E8+39","v":"2023-05-18"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":20},"Ascension",null,null,null,"Machine 6"]
[null,"Semestriel","mmmmmm",null,{"$f":"E8+49","v":"2023-05-28"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":22},"Pentecôte",null,null,null,"Machine 7"]
[null,"Annuel","mmmmmmmmmmmm",null,{"$f":"E8+50","v":"2023-05-29"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":22},"Lundi de Pentecôte",null,null,null,"Machine 8"]
[null,null,null,null,{"$f":"DATE(B4,7,14)","v":"2023-07-14"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":28},"Fête Nationale",null,null,null,"Machine 9"]
[null,null,null,null,{"$f":"DATE(B4,8,15)","v":"2023-08-15"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":33},"Assomption"]
[null,null,null,null,{"$f":"DATE(B4,11,1)","v":"2023-11-01"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":44},"Toussaint"]
[null,null,null,null,{"$f":"DATE(B4,11,11)","v":"2023-11-11"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":45},"Armistice 1918"]
[null,null,null,null,{"$f":"E20-24","v":"2023-12-01"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":48},"St Élois"]
[null,null,null,null,{"$f":"DATE(B4,12,25)","v":"2023-12-25"},{"$f":"WEEKNUM(Tableau2[[#This Row],[Date du jour ]],1)","v":52},"Noël"]