{"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":114,"rows_kept":53,"cut":false,"hidden":false,"merged":[[8,113,8,114],[9,113,9,114],[8,9,8,10],[3,1,3,4],[1,1,1,4],[5,1,5,4],[9,23,9,24],[9,25,9,26],[9,27,9,28],[9,29,9,30],[8,11,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,18],[8,19,8,20],[8,21,8,22],[8,23,8,24],[8,25,8,26],[8,27,8,28],[8,29,8,30],[6,3,6,4],[9,31,9,32],[9,33,9,34],[9,35,9,36],[9,37,9,38],[9,39,9,40],[9,41,9,42],[9,43,9,44],[9,45,9,46],[9,47,9,48],[9,49,9,50],[9,51,9,52],[9,53,9,54],[9,61,9,62],[9,63,9,64],[9,65,9,66],[9,103,9,104],[9,105,9,106],[9,107,9,108],[9,101,9,102],[9,67,9,68],[9,69,9,70],[9,71,9,72],[9,73,9,74],[9,75,9,76],[9,77,9,78],[9,79,9,80],[9,81,9,82],[9,83,9,84],[9,85,9,86],[9,87,9,88],[9,89,9,90],[9,91,9,92],[9,93,9,94],[9,95,9,96],[9,97,9,98],[9,99,9,100],[9,109,9,110],[9,111,9,112],[8,31,8,32],[8,33,8,34],[8,35,8,36],[8,37,8,38],[8,39,8,40],[8,41,8,42],[8,43,8,44],[8,45,8,46],[8,47,8,48],[8,49,8,50],[8,51,8,52],[8,53,8,54],[8,55,8,56],[8,57,8,58],[8,59,8,60],[8,61,8,62],[8,63,8,64],[8,91,8,92],[8,93,8,94],[9,55,9,56],[9,57,9,58],[9,59,9,60],[2,1,2,4],[9,9,9,10],[9,11,9,12],[9,13,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[3,9,3,10],[3,11,3,17],[4,11,4,17],[4,9,4,10],[4,1,4,4],[6,11,6,12],[3,19,4,32],[7,9,7,10],[7,11,7,12],[7,13,7,14],[7,15,7,16],[7,17,7,18],[7,19,7,20],[7,21,7,22],[7,23,7,24],[7,25,7,26],[3,34,4,47],[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,83,8,84],[8,85,8,86],[8,87,8,88],[8,89,8,90],[8,99,8,100],[8,95,8,96],[8,97,8,98],[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],[7,45,7,46],[7,27,7,28],[7,29,7,30],[7,31,7,32],[7,33,7,34],[7,35,7,36],[7,37,7,38],[7,39,7,40],[7,41,7,42],[7,43,7,44],[7,47,7,48],[7,49,7,50],[7,51,7,52],[7,53,7,54],[7,55,7,56],[7,57,7,58],[7,59,7,60],[7,61,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,7,80],[7,81,7,82],[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,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,7,98],[7,99,7,100]]}
[]
[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,"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,"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,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*J9","v":"2023-01-02"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*L9","v":"2023-01-09"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*N9","v":"2023-01-16"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*P9","v":"2023-01-23"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*R9","v":"2023-01-30"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*T9","v":"2023-02-06"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*V9","v":"2023-02-13"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*X9","v":"2023-02-20"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*Z9","v":"2023-02-27"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AB9","v":"2023-03-06"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AD9","v":"2023-03-13"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AF9","v":"2023-03-20"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AH9","v":"2023-03-27"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AJ9","v":"2023-04-03"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AL9","v":"2023-04-10"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AN9","v":"2023-04-17"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AP9","v":"2023-04-24"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AR9","v":"2023-05-01"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AT9","v":"2023-05-08"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AV9","v":"2023-05-15"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AX9","v":"2023-05-22"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*AZ9","v":"2023-05-29"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BB9","v":"2023-06-05"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BD9","v":"2023-06-12"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BF9","v":"2023-06-19"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BH9","v":"2023-06-26"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BJ9","v":"2023-07-03"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BL9","v":"2023-07-10"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BN9","v":"2023-07-17"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BP9","v":"2023-07-24"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BR9","v":"2023-07-31"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BT9","v":"2023-08-07"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BV9","v":"2023-08-14"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BX9","v":"2023-08-21"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*BZ9","v":"2023-08-28"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CB9","v":"2023-09-04"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CD9","v":"2023-09-11"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CF9","v":"2023-09-18"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CH9","v":"2023-09-25"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CJ9","v":"2023-10-02"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CL9","v":"2023-10-09"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CN9","v":"2023-10-16"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CP9","v":"2023-10-23"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CR9","v":"2023-10-30"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CT9","v":"2023-11-06"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CV9","v":"2023-11-13"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CX9","v":"2023-11-20"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*CZ9","v":"2023-11-27"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DB9","v":"2023-12-04"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DD9","v":"2023-12-11"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DF9","v":"2023-12-18"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DH9","v":"2023-12-25"},null,{"$f":"DATE(YEAR(TODAY()),1,3)-WEEKDAY(DATE(YEAR(TODAY()),1,3))-5+7*DJ9","v":"2024-01-01"}]
[null,41,null,null,null,null,null,null,null,{"$f":"WEEKNUM('Feuille données'!F3)","v":1},null,{"$f":"J9+1","v":2},null,{"$f":"L9+1","v":3},null,{"$f":"N9+1","v":4},null,{"$f":"P9+1","v":5},null,{"$f":"R9+1","v":6},null,{"$f":"T9+1","v":7},null,{"$f":"V9+1","v":8},null,{"$f":"X9+1","v":9},null,{"$f":"Z9+1","v":10},null,{"$f":"AB9+1","v":11},null,{"$f":"AD9+1","v":12},null,{"$f":"AF9+1","v":13},null,{"$f":"AH9+1","v":14},null,{"$f":"AJ9+1","v":15},null,{"$f":"AL9+1","v":16},null,{"$f":"AN9+1","v":17},null,{"$f":"AP9+1","v":18},null,{"$f":"AR9+1","v":19},null,{"$f":"AT9+1","v":20},null,{"$f":"AV9+1","v":21},null,{"$f":"AX9+1","v":22},null,{"$f":"AZ9+1","v":23},null,{"$f":"BB9+1","v":24},null,{"$f":"BD9+1","v":25},null,{"$f":"BF9+1","v":26},null,{"$f":"BH9+1","v":27},null,{"$f":"BJ9+1","v":28},null,{"$f":"BL9+1","v":29},null,{"$f":"BN9+1","v":30},null,{"$f":"BP9+1","v":31},null,{"$f":"BR9+1","v":32},null,{"$f":"BT9+1","v":33},null,{"$f":"BV9+1","v":34},null,{"$f":"BX9+1","v":35},null,{"$f":"BZ9+1","v":36},null,{"$f":"CB9+1","v":37},null,{"$f":"CD9+1","v":38},null,{"$f":"CF9+1","v":39},null,{"$f":"CH9+1","v":40},null,{"$f":"CJ9+1","v":41},null,{"$f":"CL9+1","v":42},null,{"$f":"CN9+1","v":43},null,{"$f":"CP9+1","v":44},null,{"$f":"CR9+1","v":45},null,{"$f":"CT9+1","v":46},null,{"$f":"CV9+1","v":47},null,{"$f":"CX9+1","v":48},null,{"$f":"CZ9+1","v":49},null,{"$f":"DB9+1","v":50},null,{"$f":"DD9+1","v":51},null,{"$f":"DF9+1","v":52},null,{"$f":"DH9+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":""},{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$9,0)+8,$I11)=1),\"P\",\"\"),\"\")","v":""},null,{"$f":"IF(AND($G11<>\"\",$H11<>\"\"),IF(AND(COLUMN()>=MATCH($G11,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G11,$J$9:$DK$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},"2 Semaines",{"$f":"IF(H12<>\"\",VLOOKUP($H12,Tableau1[],2,FALSE),\"\")","v":4},{"$f":"IF(AND($G12<>\"\",$H12<>\"\"),IF(AND(COLUMN()>=MATCH($G12,$J$9:$DK$9,0)+8, MOD(COLUMN()-MATCH($G12,$J$9:$DK$9,0)+8,$I12)=1),\"P\",\"\"),\"\")","v":"P"},null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P",null,"",null,"P"]
[null,"Test 2","Machine 6",null,null,"2023-01-02",1,"Trimestriel",{"$f":"IF(H13<>\"\",VLOOKUP($H13,Tableau1[],2,FALSE),\"\")","v":24},"",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"P",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"P"]
[null,null,null,null,null,null,"","Mensuel",{"$f":"IF(H14<>\"\",VLOOKUP($H14,Tableau1[],2,FALSE),\"\")","v":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":2},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":12},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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(H20<>\"\",VLOOKUP($H20,Tableau1[],2,FALSE),\"\")","v":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":12},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":2},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":12},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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(H28<>\"\",VLOOKUP($H28,Tableau1[],2,FALSE),\"\")","v":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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(H29<>\"\",VLOOKUP($H29,Tableau1[],2,FALSE),\"\")","v":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":24},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":12},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":2},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":12},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":2},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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":8},"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,"",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!J12:DK1506,\"P\")","v":32},{"$f":"IF(D9>0,1-E9,\"\")","v":""},null,{"$f":"SUMPRODUCT(--(Planning!$B$12:$B$1506=$G$4)*(Planning!$J$12:$DK$1506=$B$8))","v":27},{"$f":"IF(G9>0,1-H9,\"\")","v":""}]
[null,"P",null,null,{"$f":"IF(D10>0,1-E10,\"\")","v":""},null,null,{"$f":"IF(G10>0,1-H10,\"\")","v":""}]
[null,"X","Opérations réalisées totales",{"$f":"COUNTIFS(Planning!J12:DK1506,\"X\")","v":0},{"$f":"IF(D7>0,D9/D7,\"\")","v":0},null,{"$f":"SUMPRODUCT(--(Planning!$B$12:$B$1506=$G$4)*(Planning!$J$12:$DK$1506=$B$9))","v":0},{"$f":"IF(G7>0,G9/G7,\"\")","v":0}]
[null,null,"Opéarations réalisées à date",{"$f":"SUMPRODUCT((Planning!$J12:$DK1506=\"X\")*(Planning!$I12:$DJ1506=\"P\"))","v":0},{"$f":"IF(D7>0,D10/D7,\"\")","v":0},null,{"$f":"SUMPRODUCT((Planning!$J12:$DK1506=\"X\")*(Planning!$I12:$DJ1506=\"P\")*(Planning!$B$12:$B$1506=$G$4))","v":0},{"$f":"IF(G7>0,G10/G7,\"\")","v":0}]

{"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 Jours",null,"Date du jour ","Colonne1","Nom Jour férié",null,"ZONE",null,"SECTEUR"]
[null,"Hebdo",2,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":4},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":6},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",{"$f":"C7*4","v":8},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":12},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",{"$f":"C10*3","v":24},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",{"$f":"6*C10","v":48},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",{"$f":"2*C13","v":96},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"]