{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil1","Feuil1 (copie)","Feuil2","Liste déroulante"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Feuil1","index":0,"n_rows":100,"n_cols":208,"rows_kept":100,"cut":false,"hidden":false,"merged":[[6,3,6,4],[30,3,30,4],[6,1,7,1],[6,5,6,6]]}
[]
[]
[]
[null,null,null,null,null,"Contrôle",null,{"$f":"SUM(H9:H13)","v":0},0,0,0,0,0,0,0,0,0,1483,2333,2333,{"$f":"SUM(U9:U13)","v":2333},{"$f":"SUM(V9:V13)","v":1000},2500,6000,2837,2837,2837,{"$f":"SUM(AB9:AB13)","v":2837},{"$f":"SUM(AC9:AC13)","v":2837},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41},{"$f":"COLUMN()","v":42},{"$f":"COLUMN()","v":43},{"$f":"COLUMN()","v":44},{"$f":"COLUMN()","v":45},{"$f":"COLUMN()","v":46},{"$f":"COLUMN()","v":47},{"$f":"COLUMN()","v":48},{"$f":"COLUMN()","v":49},{"$f":"COLUMN()","v":50},{"$f":"COLUMN()","v":51},{"$f":"COLUMN()","v":52},{"$f":"COLUMN()","v":53},{"$f":"COLUMN()","v":54},{"$f":"COLUMN()","v":55},{"$f":"COLUMN()","v":56},{"$f":"COLUMN()","v":57},{"$f":"COLUMN()","v":58},{"$f":"COLUMN()","v":59},{"$f":"COLUMN()","v":60},{"$f":"COLUMN()","v":61},{"$f":"COLUMN()","v":62},{"$f":"COLUMN()","v":63},{"$f":"COLUMN()","v":64},{"$f":"COLUMN()","v":65},{"$f":"COLUMN()","v":66},{"$f":"COLUMN()","v":67},{"$f":"COLUMN()","v":68},{"$f":"COLUMN()","v":69},{"$f":"COLUMN()","v":70},{"$f":"COLUMN()","v":71},{"$f":"COLUMN()","v":72},{"$f":"COLUMN()","v":73},{"$f":"COLUMN()","v":74},{"$f":"COLUMN()","v":75},{"$f":"COLUMN()","v":76},{"$f":"COLUMN()","v":77},{"$f":"COLUMN()","v":78},{"$f":"COLUMN()","v":79},{"$f":"COLUMN()","v":80},{"$f":"COLUMN()","v":81},{"$f":"COLUMN()","v":82},{"$f":"COLUMN()","v":83},{"$f":"COLUMN()","v":84},{"$f":"COLUMN()","v":85},{"$f":"COLUMN()","v":86},{"$f":"COLUMN()","v":87},{"$f":"COLUMN()","v":88},{"$f":"COLUMN()","v":89},{"$f":"COLUMN()","v":90},{"$f":"COLUMN()","v":91},{"$f":"COLUMN()","v":92},{"$f":"COLUMN()","v":93},{"$f":"COLUMN()","v":94},{"$f":"COLUMN()","v":95},{"$f":"COLUMN()","v":96},{"$f":"COLUMN()","v":97},{"$f":"COLUMN()","v":98},{"$f":"COLUMN()","v":99},{"$f":"COLUMN()","v":100},{"$f":"COLUMN()","v":101},{"$f":"COLUMN()","v":102},{"$f":"COLUMN()","v":103},{"$f":"COLUMN()","v":104},{"$f":"COLUMN()","v":105},{"$f":"COLUMN()","v":106},{"$f":"COLUMN()","v":107},{"$f":"COLUMN()","v":108},{"$f":"COLUMN()","v":109},{"$f":"COLUMN()","v":110},{"$f":"COLUMN()","v":111},{"$f":"COLUMN()","v":112},{"$f":"COLUMN()","v":113},{"$f":"COLUMN()","v":114},{"$f":"COLUMN()","v":115},{"$f":"COLUMN()","v":116},{"$f":"COLUMN()","v":117},{"$f":"COLUMN()","v":118},{"$f":"COLUMN()","v":119},{"$f":"COLUMN()","v":120},{"$f":"COLUMN()","v":121},{"$f":"COLUMN()","v":122},{"$f":"COLUMN()","v":123},{"$f":"COLUMN()","v":124},{"$f":"COLUMN()","v":125},{"$f":"COLUMN()","v":126},{"$f":"COLUMN()","v":127},{"$f":"COLUMN()","v":128},{"$f":"COLUMN()","v":129},{"$f":"COLUMN()","v":130},{"$f":"COLUMN()","v":131},{"$f":"COLUMN()","v":132},{"$f":"COLUMN()","v":133},{"$f":"COLUMN()","v":134},{"$f":"COLUMN()","v":135},{"$f":"COLUMN()","v":136},{"$f":"COLUMN()","v":137},{"$f":"COLUMN()","v":138},{"$f":"COLUMN()","v":139},{"$f":"COLUMN()","v":140},{"$f":"COLUMN()","v":141},{"$f":"COLUMN()","v":142},{"$f":"COLUMN()","v":143},{"$f":"COLUMN()","v":144},{"$f":"COLUMN()","v":145},{"$f":"COLUMN()","v":146},{"$f":"COLUMN()","v":147},{"$f":"COLUMN()","v":148},{"$f":"COLUMN()","v":149},{"$f":"COLUMN()","v":150},{"$f":"COLUMN()","v":151},{"$f":"COLUMN()","v":152},{"$f":"COLUMN()","v":153},{"$f":"COLUMN()","v":154},{"$f":"COLUMN()","v":155},{"$f":"COLUMN()","v":156},{"$f":"COLUMN()","v":157},{"$f":"COLUMN()","v":158},{"$f":"COLUMN()","v":159},{"$f":"COLUMN()","v":160},{"$f":"COLUMN()","v":161},{"$f":"COLUMN()","v":162},{"$f":"COLUMN()","v":163},{"$f":"COLUMN()","v":164},{"$f":"COLUMN()","v":165},{"$f":"COLUMN()","v":166},{"$f":"COLUMN()","v":167},{"$f":"COLUMN()","v":168},{"$f":"COLUMN()","v":169},{"$f":"COLUMN()","v":170},{"$f":"COLUMN()","v":171},{"$f":"COLUMN()","v":172},{"$f":"COLUMN()","v":173},{"$f":"COLUMN()","v":174},{"$f":"COLUMN()","v":175},{"$f":"COLUMN()","v":176},{"$f":"COLUMN()","v":177},{"$f":"COLUMN()","v":178},{"$f":"COLUMN()","v":179},{"$f":"COLUMN()","v":180},{"$f":"COLUMN()","v":181},{"$f":"COLUMN()","v":182},{"$f":"COLUMN()","v":183},{"$f":"COLUMN()","v":184},{"$f":"COLUMN()","v":185},{"$f":"COLUMN()","v":186},{"$f":"COLUMN()","v":187},{"$f":"COLUMN()","v":188},{"$f":"COLUMN()","v":189},{"$f":"COLUMN()","v":190},{"$f":"COLUMN()","v":191},{"$f":"COLUMN()","v":192},{"$f":"COLUMN()","v":193},{"$f":"COLUMN()","v":194},{"$f":"COLUMN()","v":195},{"$f":"COLUMN()","v":196},{"$f":"COLUMN()","v":197},{"$f":"COLUMN()","v":198},{"$f":"COLUMN()","v":199},{"$f":"COLUMN()","v":200},{"$f":"COLUMN()","v":201},{"$f":"COLUMN()","v":202},{"$f":"COLUMN()","v":203},{"$f":"COLUMN()","v":204},{"$f":"COLUMN()","v":205},{"$f":"COLUMN()","v":206},{"$f":"COLUMN()","v":207},{"$f":"COLUMN()","v":208}]
[null,null,null,null,null,null,null,"Lundi ","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi"]
[null,"Ordre de production à respecter",null,"Date de début de production",null,"Qtité à produire et à répartir chaque jour en fonction des limites",null,"2021-02-01","2021-02-02","2021-02-03","2021-02-04","2021-02-05","2021-02-06","2021-02-07","2021-02-08","2021-02-09","2021-02-10","2021-02-11","2021-02-12","2021-02-13","2021-02-14","2021-02-15","2021-02-16","2021-02-17","2021-02-18","2021-02-19","2021-02-20","2021-02-21","2021-02-22","2021-02-23","2021-02-24","2021-02-25","2021-02-26","2021-02-27","2021-02-28","2021-03-01","2021-03-02","2021-03-03","2021-03-04","2021-03-05","2021-03-06","2021-03-07","2021-03-08","2021-03-09","2021-03-10","2021-03-11","2021-03-12","2021-03-13","2021-03-14","2021-03-15","2021-03-16","2021-03-17","2021-03-18","2021-03-19","2021-03-20","2021-03-21","2021-03-22","2021-03-23","2021-03-24","2021-03-25","2021-03-26","2021-03-27","2021-03-28","2021-03-29","2021-03-30","2021-03-31","2021-04-01","2021-04-02","2021-04-03","2021-04-04","2021-04-05","2021-04-06","2021-04-07","2021-04-08","2021-04-09","2021-04-10","2021-04-11","2021-04-12","2021-04-13","2021-04-14","2021-04-15","2021-04-16","2021-04-17","2021-04-18","2021-04-19","2021-04-20","2021-04-21","2021-04-22","2021-04-23","2021-04-24","2021-04-25","2021-04-26","2021-04-27","2021-04-28","2021-04-29","2021-04-30","2021-05-01","2021-05-02","2021-05-03","2021-05-04","2021-05-05","2021-05-06","2021-05-07","2021-05-08","2021-05-09","2021-05-10","2021-05-11","2021-05-12","2021-05-13","2021-05-14","2021-05-15","2021-05-16","2021-05-17","2021-05-18","2021-05-19","2021-05-20","2021-05-21","2021-05-22","2021-05-23","2021-05-24","2021-05-25","2021-05-26","2021-05-27","2021-05-28","2021-05-29","2021-05-30","2021-05-31","2021-06-01","2021-06-02","2021-06-03","2021-06-04","2021-06-05","2021-06-06","2021-06-07","2021-06-08","2021-06-09","2021-06-10","2021-06-11","2021-06-12","2021-06-13","2021-06-14","2021-06-15","2021-06-16","2021-06-17","2021-06-18","2021-06-19","2021-06-20","2021-06-21","2021-06-22","2021-06-23","2021-06-24","2021-06-25","2021-06-26","2021-06-27","2021-06-28","2021-06-29","2021-06-30","2021-07-01","2021-07-02","2021-07-03","2021-07-04","2021-07-05","2021-07-06","2021-07-07","2021-07-08","2021-07-09","2021-07-10","2021-07-11","2021-07-12","2021-07-13","2021-07-14","2021-07-15","2021-07-16","2021-07-17","2021-07-18","2021-07-19","2021-07-20","2021-07-21","2021-07-22","2021-07-23","2021-07-24","2021-07-25","2021-07-26","2021-07-27","2021-07-28","2021-07-29","2021-07-30","2021-07-31","2021-08-01","2021-08-02","2021-08-03","2021-08-04","2021-08-05","2021-08-06","2021-08-07","2021-08-08","2021-08-09","2021-08-10","2021-08-11","2021-08-12","2021-08-13","2021-08-14","2021-08-15","2021-08-16","2021-08-17","2021-08-18","2021-08-19","2021-08-20"]
[null,null,"types de disques","Date de début de livraison",null,"Quantité à répartir",null,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,1,"Disque A1","2021-03-07","quantités à produire déjà réservé du 07/03/2021 au 09/03/2021",null,10000]
[null,2,"Disque A2","2021-03-06","quantités de production à répartir en fonction des quantités de production déjà réservé par disque A",null,{"$f":"SUM(H10:GZ10)","v":27167},null,null,null,null,null,null,null,null,null,null,1483,2333,2333,2333,1000,1000,2500,2837,2837,2837,2837,2837,"se","se","se","se","se","se","se","ov","ov","ov","ov","li"]
[null,3,"Disque A3","2021-03-03","répartition au prorata des possibilités de production plafonnée à 3500/jour et des quantités de production déjà réservé par dique A1 et disque A2",5000,5000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1500,3500,"se","se","se","se","se","se","se","ov","ov","ov","ov","ov","ov","li"]
[null,4,"Disque A4","2021-03-01",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prod","se","se","se","se","se","se","se","ov","ov","ov","ov","ov","ov","li"]
[null,5,"Disque A5","2021-03-08",null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,"TOTAL",null,"production plafonnée à 3500 disques/jour",null,{"$f":"SUM(H9:H30)","v":0},{"$f":"SUM(I9:I30)","v":0},0,0,0,0,0,0,0,0,1483,2333,2333,2333,1000,2500,6000,2837,2837,2837,2837,2837,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(CD9:CD30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(EP9:EP30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,1,2,3,4,5,6,7]
[null,null,null,null,null,null,null,null,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":"4+2","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,{"$f":"4+2","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,{"$f":"4+2","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,{"$f":"4+2","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,{"$f":"4+0","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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":"4+0","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"4+1","v":5}]

{"sheet":"Feuil1 (copie)","index":1,"n_rows":100,"n_cols":209,"rows_kept":100,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,3,6,4],[6,5,6,6],[30,3,30,4]]}
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"COLUMN()","v":8}]
[null,null,null,null,null,null,null,{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41}]
[null,null,null,null,null,null,null,"Lundi ","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi"]
[null,"Ordre de production à respecter","[https://img-19.ccm2.net/mqcOsCFVu6QGBrO9FqqOUgE6AOU=/663d6f06ddab47bbbf952ce2410e680f/tmp/Capturecollone_A.PNG [image:https://img-19.ccm2.net/mqcOsCFVu6QGBrO9FqqOUgE6AOU=/663d6f06ddab47bbbf952ce2410e680f/tmp/Capturecollone_A.PNG|440px||center]|fancy]","Date de début de production",null,"Qtité à produire et à répartir chaque jour en fonction des limites",null,"2021-02-01","2021-02-02","2021-02-03","2021-02-04","2021-02-05","2021-02-06","2021-02-07","2021-02-08","2021-02-09","2021-02-10","2021-02-11","2021-02-12","2021-02-13","2021-02-14","2021-02-15","2021-02-16","2021-02-17","2021-02-18","2021-02-19","2021-02-20","2021-02-21","2021-02-22","2021-02-23","2021-02-24","2021-02-25","2021-02-26","2021-02-27","2021-02-28","2021-03-01","2021-03-02","2021-03-03","2021-03-04","2021-03-05","2021-03-06","2021-03-07","2021-03-08","2021-03-09","2021-03-10","2021-03-11","2021-03-12","2021-03-13","2021-03-14","2021-03-15","2021-03-16","2021-03-17","2021-03-18","2021-03-19","2021-03-20","2021-03-21","2021-03-22","2021-03-23","2021-03-24","2021-03-25","2021-03-26","2021-03-27","2021-03-28","2021-03-29","2021-03-30","2021-03-31","2021-04-01","2021-04-02","2021-04-03","2021-04-04","2021-04-05","2021-04-06","2021-04-07","2021-04-08","2021-04-09","2021-04-10","2021-04-11","2021-04-12","2021-04-13","2021-04-14","2021-04-15","2021-04-16","2021-04-17","2021-04-18","2021-04-19","2021-04-20","2021-04-21","2021-04-22","2021-04-23","2021-04-24","2021-04-25","2021-04-26","2021-04-27","2021-04-28","2021-04-29","2021-04-30","2021-05-01","2021-05-02","2021-05-03","2021-05-04","2021-05-05","2021-05-06","2021-05-07","2021-05-08","2021-05-09","2021-05-10","2021-05-11","2021-05-12","2021-05-13","2021-05-14","2021-05-15","2021-05-16","2021-05-17","2021-05-18","2021-05-19","2021-05-20","2021-05-21","2021-05-22","2021-05-23","2021-05-24","2021-05-25","2021-05-26","2021-05-27","2021-05-28","2021-05-29","2021-05-30","2021-05-31","2021-06-01","2021-06-02","2021-06-03","2021-06-04","2021-06-05","2021-06-06","2021-06-07","2021-06-08","2021-06-09","2021-06-10","2021-06-11","2021-06-12","2021-06-13","2021-06-14","2021-06-15","2021-06-16","2021-06-17","2021-06-18","2021-06-19","2021-06-20","2021-06-21","2021-06-22","2021-06-23","2021-06-24","2021-06-25","2021-06-26","2021-06-27","2021-06-28","2021-06-29","2021-06-30","2021-07-01","2021-07-02","2021-07-03","2021-07-04","2021-07-05","2021-07-06","2021-07-07","2021-07-08","2021-07-09","2021-07-10","2021-07-11","2021-07-12","2021-07-13","2021-07-14","2021-07-15","2021-07-16","2021-07-17","2021-07-18","2021-07-19","2021-07-20","2021-07-21","2021-07-22","2021-07-23","2021-07-24","2021-07-25","2021-07-26","2021-07-27","2021-07-28","2021-07-29","2021-07-30","2021-07-31","2021-08-01","2021-08-02","2021-08-03","2021-08-04","2021-08-05","2021-08-06","2021-08-07","2021-08-08","2021-08-09","2021-08-10","2021-08-11","2021-08-12","2021-08-13","2021-08-14","2021-08-15","2021-08-16","2021-08-17","2021-08-18","2021-08-19","2021-08-20","date de début de fabrication"]
["durée choisie",null,"types de disques","Date de début de livraison",null,"Quantité à répartir",null,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,1,"Disque A1","2021-03-07","quantités à produire déjà réservé du 07/03/2021 au 09/03/2021",null,{"$f":"SUM(H9:GZ9)","v":10000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3500,3500,3000]
[null,2,"Disque A2","2021-03-06","quantités de production à répartir en fonction des quantités de production déjà réservé par disque A",null,{"$f":"SUM(H10:GZ10)","v":30000},null,null,null,null,null,null,null,null,null,null,1483,2333,2333,2333,2333,2500,2500,2837,2837,2837,2837,2837,"se","se","se","se","se","se","se","ov","ov","ov","ov","li"]
[null,3,"Disque A3","2021-03-03","répartition au prorata des possibilités de production plafonnée à 3500/jour et des quantités de production déjà réservé par dique A1 et disque A2",null,5000,null,null,null,null,null,null,null,null,41,2187,388,388,388,388,388,416,416,"se","se","se","se","se","se","se","ov","ov","ov","ov","ov","ov","li"]
[null,4,"Disque A4","2021-03-01",null,null,2767,null,null,null,null,null,null,null,null,523,1312,233,233,233,233,"prod","se","se","se","se","se","se","se","ov","ov","ov","ov","ov","ov","li"]
[null,5,"Disque A5","2021-03-08",null,null,7000,null,null,null,null,null,null,null,null,null,null,348,544,544,544,544,583,583,662,662,662,662,662,"se","se","se","se","se","se","se","ov","ov","ov","ov","ov","ov","li"]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,"TOTAL",null,"production plafonnée à 3500 disques/jour",null,{"$f":"SUM(H9:H30)","v":0},{"$f":"SUM(I9:I30)","v":0},0,0,0,0,0,0,564,3499,2452,3498,3498,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(CD9:CD30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(EP9:EP30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche","Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,1,2,3,4,5,6,7]
[null,null,null,null,null,null,null,null,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":"4+2","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,{"$f":"4+2","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,{"$f":"4+2","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,{"$f":"4+2","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,{"$f":"4+0","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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":"4+0","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"4+1","v":5}]

{"sheet":"Feuil2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Liste déroulante","index":3,"n_rows":404,"n_cols":1,"rows_kept":404,"cut":false,"hidden":true,"merged":[]}
["2021-02-01"]
["2021-02-02"]
["2021-02-03"]
["2021-02-04"]
["2021-02-05"]
["2021-02-06"]
["2021-02-07"]
["2021-02-08"]
["2021-02-09"]
["2021-02-10"]
["2021-02-11"]
["2021-02-12"]
["2021-02-13"]
["2021-02-14"]
["2021-02-15"]
["2021-02-16"]
["2021-02-17"]
["2021-02-18"]
["2021-02-19"]
["2021-02-20"]
["2021-02-21"]
["2021-02-22"]
["2021-02-23"]
["2021-02-24"]
["2021-02-25"]
["2021-02-26"]
["2021-02-27"]
["2021-02-28"]
["2021-03-01"]
["2021-03-02"]
["2021-03-03"]
["2021-03-04"]
["2021-03-05"]
["2021-03-06"]
["2021-03-07"]
["2021-03-08"]
["2021-03-09"]
["2021-03-10"]
["2021-03-11"]
["2021-03-12"]
["2021-03-13"]
["2021-03-14"]
["2021-03-15"]
["2021-03-16"]
["2021-03-17"]
["2021-03-18"]
["2021-03-19"]
["2021-03-20"]
["2021-03-21"]
["2021-03-22"]
["2021-03-23"]
["2021-03-24"]
["2021-03-25"]
["2021-03-26"]
["2021-03-27"]
["2021-03-28"]
["2021-03-29"]
["2021-03-30"]
["2021-03-31"]
["2021-04-01"]
["2021-04-02"]
["2021-04-03"]
["2021-04-04"]
["2021-04-05"]
["2021-04-06"]
["2021-04-07"]
["2021-04-08"]
["2021-04-09"]
["2021-04-10"]
["2021-04-11"]
["2021-04-12"]
["2021-04-13"]
["2021-04-14"]
["2021-04-15"]
["2021-04-16"]
["2021-04-17"]
["2021-04-18"]
["2021-04-19"]
["2021-04-20"]
["2021-04-21"]
["2021-04-22"]
["2021-04-23"]
["2021-04-24"]
["2021-04-25"]
["2021-04-26"]
["2021-04-27"]
["2021-04-28"]
["2021-04-29"]
["2021-04-30"]
["2021-05-01"]
["2021-05-02"]
["2021-05-03"]
["2021-05-04"]
["2021-05-05"]
["2021-05-06"]
["2021-05-07"]
["2021-05-08"]
["2021-05-09"]
["2021-05-10"]
["2021-05-11"]
["2021-05-12"]
["2021-05-13"]
["2021-05-14"]
["2021-05-15"]
["2021-05-16"]
["2021-05-17"]
["2021-05-18"]
["2021-05-19"]
["2021-05-20"]
["2021-05-21"]
["2021-05-22"]
["2021-05-23"]
["2021-05-24"]
["2021-05-25"]
["2021-05-26"]
["2021-05-27"]
["2021-05-28"]
["2021-05-29"]
["2021-05-30"]
["2021-05-31"]
["2021-06-01"]
["2021-06-02"]
["2021-06-03"]
["2021-06-04"]
["2021-06-05"]
["2021-06-06"]
["2021-06-07"]
["2021-06-08"]
["2021-06-09"]
["2021-06-10"]
["2021-06-11"]
["2021-06-12"]
["2021-06-13"]
["2021-06-14"]
["2021-06-15"]
["2021-06-16"]
["2021-06-17"]
["2021-06-18"]
["2021-06-19"]
["2021-06-20"]
["2021-06-21"]
["2021-06-22"]
["2021-06-23"]
["2021-06-24"]
["2021-06-25"]
["2021-06-26"]
["2021-06-27"]
["2021-06-28"]
["2021-06-29"]
["2021-06-30"]
["2021-07-01"]
["2021-07-02"]
["2021-07-03"]
["2021-07-04"]
["2021-07-05"]
["2021-07-06"]
["2021-07-07"]
["2021-07-08"]
["2021-07-09"]
["2021-07-10"]
["2021-07-11"]
["2021-07-12"]
["2021-07-13"]
["2021-07-14"]
["2021-07-15"]
["2021-07-16"]
["2021-07-17"]
["2021-07-18"]
["2021-07-19"]
["2021-07-20"]
["2021-07-21"]
["2021-07-22"]
["2021-07-23"]
["2021-07-24"]
["2021-07-25"]
["2021-07-26"]
["2021-07-27"]
["2021-07-28"]
["2021-07-29"]
["2021-07-30"]
["2021-07-31"]
["2021-08-01"]
["2021-08-02"]
["2021-08-03"]
["2021-08-04"]
["2021-08-05"]
["2021-08-06"]
["2021-08-07"]
["2021-08-08"]
["2021-08-09"]
["2021-08-10"]
["2021-08-11"]
["2021-08-12"]
["2021-08-13"]
["2021-08-14"]
["2021-08-15"]
["2021-08-16"]
["2021-08-17"]
["2021-08-18"]
["2021-08-19"]
["2021-08-20"]
["2021-08-21"]
["2021-08-22"]
["2021-08-23"]
["2021-08-24"]
["2021-08-25"]
["2021-08-26"]
["2021-08-27"]
["2021-08-28"]
["2021-08-29"]
["2021-08-30"]
["2021-08-31"]
["2021-09-01"]
["2021-09-02"]
["2021-09-03"]
["2021-09-04"]
["2021-09-05"]
["2021-09-06"]
["2021-09-07"]
["2021-09-08"]
["2021-09-09"]
["2021-09-10"]
["2021-09-11"]
["2021-09-12"]
["2021-09-13"]
["2021-09-14"]
["2021-09-15"]
["2021-09-16"]
["2021-09-17"]
["2021-09-18"]
["2021-09-19"]
["2021-09-20"]
["2021-09-21"]
["2021-09-22"]
["2021-09-23"]
["2021-09-24"]
["2021-09-25"]
["2021-09-26"]
["2021-09-27"]
["2021-09-28"]
["2021-09-29"]
["2021-09-30"]
["2021-10-01"]
["2021-10-02"]
["2021-10-03"]
["2021-10-04"]
["2021-10-05"]
["2021-10-06"]
["2021-10-07"]
["2021-10-08"]
["2021-10-09"]
["2021-10-10"]
["2021-10-11"]
["2021-10-12"]
["2021-10-13"]
["2021-10-14"]
["2021-10-15"]
["2021-10-16"]
["2021-10-17"]
["2021-10-18"]
["2021-10-19"]
["2021-10-20"]
["2021-10-21"]
["2021-10-22"]
["2021-10-23"]
["2021-10-24"]
["2021-10-25"]
["2021-10-26"]
["2021-10-27"]
["2021-10-28"]
["2021-10-29"]
["2021-10-30"]
["2021-10-31"]
["2021-11-01"]
["2021-11-02"]
["2021-11-03"]
["2021-11-04"]
["2021-11-05"]
["2021-11-06"]
["2021-11-07"]
["2021-11-08"]
["2021-11-09"]
["2021-11-10"]
["2021-11-11"]
["2021-11-12"]
["2021-11-13"]
["2021-11-14"]
["2021-11-15"]
["2021-11-16"]
["2021-11-17"]
["2021-11-18"]
["2021-11-19"]
["2021-11-20"]
["2021-11-21"]
["2021-11-22"]
["2021-11-23"]
["2021-11-24"]
["2021-11-25"]
["2021-11-26"]
["2021-11-27"]
["2021-11-28"]
["2021-11-29"]
["2021-11-30"]
["2021-12-01"]
["2021-12-02"]
["2021-12-03"]
["2021-12-04"]
["2021-12-05"]
["2021-12-06"]
["2021-12-07"]
["2021-12-08"]
["2021-12-09"]
["2021-12-10"]
["2021-12-11"]
["2021-12-12"]
["2021-12-13"]
["2021-12-14"]
["2021-12-15"]
["2021-12-16"]
["2021-12-17"]
["2021-12-18"]
["2021-12-19"]
["2021-12-20"]
["2021-12-21"]
["2021-12-22"]
["2021-12-23"]
["2021-12-24"]
["2021-12-25"]
["2021-12-26"]
["2021-12-27"]
["2021-12-28"]
["2021-12-29"]
["2021-12-30"]
["2021-12-31"]
["2022-01-01"]
["2022-01-02"]
["2022-01-03"]
["2022-01-04"]
["2022-01-05"]
["2022-01-06"]
["2022-01-07"]
["2022-01-08"]
["2022-01-09"]
["2022-01-10"]
["2022-01-11"]
["2022-01-12"]
["2022-01-13"]
["2022-01-14"]
["2022-01-15"]
["2022-01-16"]
["2022-01-17"]
["2022-01-18"]
["2022-01-19"]
["2022-01-20"]
["2022-01-21"]
["2022-01-22"]
["2022-01-23"]
["2022-01-24"]
["2022-01-25"]
["2022-01-26"]
["2022-01-27"]
["2022-01-28"]
["2022-01-29"]
["2022-01-30"]
["2022-01-31"]
["2022-02-01"]
["2022-02-02"]
["2022-02-03"]
["2022-02-04"]
["2022-02-05"]
["2022-02-06"]
["2022-02-07"]
["2022-02-08"]
["2022-02-09"]
["2022-02-10"]
["2022-02-11"]
["2022-02-12"]
["2022-02-13"]
["2022-02-14"]
["2022-02-15"]
["2022-02-16"]
["2022-02-17"]
["2022-02-18"]
["2022-02-19"]
["2022-02-20"]
["2022-02-21"]
["2022-02-22"]
["2022-02-23"]
["2022-02-24"]
["2022-02-25"]
["2022-02-26"]
["2022-02-27"]
["2022-02-28"]
["2022-03-01"]
["2022-03-02"]
["2022-03-03"]
["2022-03-04"]
["2022-03-05"]
["2022-03-06"]
["2022-03-07"]
["2022-03-08"]
["2022-03-09"]
["2022-03-10"]
["2022-03-11"]