{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Détails","Test","Nomenclatures","Nomen"],"not_rendered":{"macros":1,"defined_names":11,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Détails","index":0,"n_rows":174,"n_cols":12,"rows_kept":174}
["Client","Ref Produit","N° CDE","Date Expédition","Dte Liv","Qte","Cartons","Unités","Ligne","Mois Execution","Date Prod","Date Prod"]
["AIR TRANSAT","0205","4500807312",null,"2017-08-04","2P",216,{"$f":"G2*256","v":{"v":55296,"d":"55,296 "}},"L","AOUT"]
["EXKI","0213","AC4896",null,"2017-08-08","2P",216,{"v":55296,"d":"55,296 "},"K","AOUT"]
["STOCK","0300",null,null,"2017-08-16","1P",108,{"v":27648,"d":"27,648 "},"K","AOUT"]
["EVA AIR","0500","QP17002575",null,"2017-08-25","2P",192,{"v":49152,"d":"49,152 "},"L","AOUT"]
["LSG","0500","4500873808",null,"2017-07-29","2P",200,{"v":51200,"d":"51,200 "},"L","AOUT"]
["CLASSIC FINE FOOD","0506","BC593558",null,"2017-09-04","2P",150,{"v":38400,"d":"38,400 "},"L","AOUT"]
["ANA","1300",null,null,"2017-08-16","2P",216,{"v":55296,"d":"55,296 "},"K","AOUT"]
["ALCAMORETTI","1311",null,null,"2017-09-04","1P",400,{"$f":"G9*50","v":{"v":20000,"d":"20,000 "}},"K","AOUT"]
["IFOOD","1400",null,null,"2017-09-04","1P",108,{"$f":"G10*256","v":{"v":27648,"d":"27,648 "}},"L","AOUT"]
["IFOOD","1500","PO17UK02423",null,"2017-08-11","1P",108,{"v":27648,"d":"27,648 "},"L","AOUT"]
["MIX BUFFET","1901","CA1707000324",null,"2017-08-18","8P",864,{"$f":"G12*256","v":{"v":221184,"d":"221,184 "}},"K","AOUT"]
["MIX BUFFET","1910","CA1706000403",null,"2017-08-28","8P",864,{"v":221184,"d":"221,184 "},"K","AOUT"]
["MIX BUFFET","1910","CA1707000324",null,"2017-08-18","8P",864,{"v":221184,"d":"221,184 "},"L","AOUT"]
["AERO MEXICO","0500","21888-4",null,"2018-05-11","2P",141,{"v":36096,"d":"36,096 "},"L","AVRIL"]
["EVA AIR","0500",null,null,"2017-07-05","3P",288,{"v":73728,"d":"73,728 "},"L","AVRIL"]
["DEAN & DELUCA","0203","BAILL20171201",null,"2017-12-29",null,40,{"v":10240,"d":"10,240 "},"L","DECEMBRE"]
["VANDENBOGAERDE","0302","34974",null,"2017-12-11","1P",108,{"v":27648,"d":"27,648 "},"K","DECMBRE"]
["DEAN & DELUCA","0303","BAILL20171201",null,"2017-12-29",null,40,{"v":10240,"d":"10,240 "},"L","DECEMBRE"]
["DEAN & DELUCA","0403","BAILL20171201",null,"2017-12-29",null,40,{"v":10240,"d":"10,240 "},"L","DECEMBRE"]
["EVA AIR","0500","QP17006037",null,"2018-01-02","2P",192,{"v":49152,"d":"49,152 "},"L","DECEMBRE"]
["FBS","1300","CFF1706786",null,"2017-12-13","3P",294,{"v":75264,"d":"75,264 "},"L","DECEMBRE"]
["DEAN & DELUCA","1303","BAILL20171201",null,"2017-12-29",null,40,{"v":10240,"d":"10,240 "},"L","DECEMBRE"]
["DEAN & DELUCA","1483","BAILL20171202",null,"2017-12-30",null,40,{"v":2000,"d":"2,000 "},"N","DECEMBRE"]
["DEAN & DELUCA","1503","BAILL20171201",null,"2017-12-29",null,40,{"$f":"G25*256","v":{"v":10240,"d":"10,240 "}},"L","DECEMBRE"]
["DEAN & DELUCA","1683B","BAILL20171201",null,"2017-12-29",null,40,{"v":2000,"d":"2,000 "},"N","DECEMBRE"]
["DEAN & DELUCA","1783","BAILL20171201",null,"2017-12-29",null,40,{"v":2000,"d":"2,000 "},"N","DECEMBRE"]
["MIX BUFFET","1901","CA1711000872",null,"2017-12-18","6P",648,{"$f":"G28*256","v":{"v":165888,"d":"165,888 "}},"K","DECEMBRE"]
["MIX BUFFET","1910","CA1711000871",null,"2018-01-02","4P",432,{"v":110592,"d":"110,592 "},"L","DECEMBRE"]
["DEAN & DELUCA","1913","BAILL20171201",null,"2017-12-29",null,40,{"v":10240,"d":"10,240 "},"L","DECEMBRE"]
["AIR FRANCE","0100","5319478","6007296","2018-02-28","5P",540,{"v":138240,"d":"138,240 "},"L","FEVRIER"]
["AERO MEXICO","0500","21888-2",null,"2018-03-12","2P",141,{"v":36096,"d":"36,096 "},"L","FEVRIER"]
["AIR CANADA","0500","AC083698",null,"2018-02-23","20P",2700,{"v":691200,"d":"691,200 "},"K","FEVRIER"]
["AIR FRANCE","0100","5319316","6007296","2017-01-08","6P",648,{"v":165888,"d":"165,888 "},"L","JANVIER"]
["COMATEC","0206","CF008733",null,"2018-01-10","1P",108,{"v":27648,"d":"27,648 "},"L","JANVIER"]
["EVA AIR","0500","QP17006587",null,"2018-02-20","2P",192,{"v":49152,"d":"49,152 "},"K","JANVIER"]
["AERO MEXICO","0500","21888-1",null,"2018-02-05","2P",125,{"v":32000,"d":"32,000 "},"L","JANVIER"]
["EVA AIR","0500","QP17006586",null,"2018-01-20","2P",192,{"v":49152,"d":"49,152 "},"K","JANVIER"]
["LSG KOREA","0500","4500962773",null,"2018-01-20","2P",200,{"v":51200,"d":"51,200 "},"K","JANVIER"]
["EVA AIR","0500","QP17006383",null,"2018-01-11","2P",192,{"v":49152,"d":"49,152 "},"L","JANVIER"]
["HACO","0504","PO00157901",null,"2018-01-18","10P",1080,{"v":276480,"d":"276,480 "},"L","JANVIER"]
["ANA","1300","4500395141",null,"2018-01-15","2P",216,{"v":55296,"d":"55,296 "},"K","JANVIER"]
["MIX BUFFET","1910","CA1801000247",null,"2018-02-02","4P",432,{"v":110592,"d":"110,592 "},"L","JANVIER"]
["MIX BUFFET","1910","CA1801000035",null,"2018-01-26","4P",432,{"v":110592,"d":"110,592 "},"L","JANVIER"]
["MIX BUFFET","1910","CA1801000248",null,"2018-01-18","4P",432,{"v":110592,"d":"110,592 "},"L","JANVIER"]
["PERI","1992",null,null,"2018-01-15","30P",2550,{"v":652800,"d":"652,800 "},"M","JANVIER"]
["COMATEC","0206",null,null,"2017-07-21","2P",108,{"v":27648,"d":"27,648 "},"K","JUILLET"]
["EXKI","0213","AC4793",null,"2017-07-24","2P",216,{"v":55296,"d":"55,296 "},"L","JUILLET"]
["SYSTÈME U EST","0217",null,null,"2017-07-10","1P",100,{"v":5000,"d":"5,000 "},"K","JUILLET"]
["STOCK","0250",null,null,"2017-08-04","2P",240,{"v":30720,"d":"30,720 "},"M","JUILLET"]
["CLASS CROUTE","0252",null,null,"2017-08-04","6P",720,{"v":92160,"d":"92,160 "},"M","JUILLET"]
["VANDENBOGAERDE","0302","33963",null,"2017-08-01","1P",108,{"v":27648,"d":"27,648 "},"K","JUILLET"]
["SYSTÈME U EST","0417",null,null,"2017-07-10","1P",100,{"v":5000,"d":"5,000 "},"K","JUILLET"]
["STOCK","0450",null,null,"2017-07-21",null,12,{"$f":"G54*128","v":{"v":1536,"d":"1,536 "}},"M","JUILLET"]
["AERO MEXICO","0500","AM14107_6",null,"2017-07-29","2P",148,{"$f":"G55*256","v":{"v":37888,"d":"37,888 "}},"L","JUILLET"]
["LSG","0500","4500873807",null,"2017-07-02","2P",200,{"$f":"G56*256","v":{"v":51200,"d":"51,200 "}},"L","JUILLET"]
["HACO","0504","PO00140992",null,"2017-08-04","6P",648,{"$f":"G57*256","v":{"v":165888,"d":"165,888 "}},"L","JUILLET"]
["LEGUFRUIT","0550",null,null,"2017-07-21",null,50,{"$f":"G58*128","v":{"v":6400,"d":"6,400 "}},"M","JUILLET"]
["NOON SANDWICH","0600","0000019452",null,"2017-08-04","1P",42,{"$f":"G59*256","v":{"v":10752,"d":"10,752 "}},"L","JUILLET"]
["LEGUFRUIT","0750",null,null,"2017-07-21",null,15,{"$f":"G60*128","v":{"v":1920,"d":"1,920 "}},"M","JUILLET"]
["ANA","1300","4500377323",null,"2017-08-04","2P",216,{"$f":"G61*256","v":{"v":55296,"d":"55,296 "}},"L","JUILLET"]
["STOCK","1300",null,null,"2017-07-28","2P",216,{"$f":"G62*256","v":{"v":55296,"d":"55,296 "}},"L","JUILLET"]
["CLASSIC FINE FOOD","1306","16461",null,"2017-08-04","1P",40,{"$f":"G63*256","v":{"v":10240,"d":"10,240 "}},"L","JUILLET"]
["IFOOD","1400","PO17UKT00115",null,"2017-07-11","1P",108,{"$f":"G64*256","v":{"v":27648,"d":"27,648 "}},"L","JUILLET"]
["LEGUFRUIT","1450",null,null,"2017-07-21",null,65,{"$f":"G65*128","v":{"v":8320,"d":"8,320 "}},"M","JUILLET"]
["IFOOD","1500","PO17UKT00116",null,"2017-09-25","1P",108,{"$f":"G66*256","v":{"v":27648,"d":"27,648 "}},"K","JUILLET"]
["MIX BUFFET","1901","CA1706000402",null,"2017-08-28","8P",864,{"$f":"G67*256","v":{"v":221184,"d":"221,184 "}},"K","JUILLET"]
["MIX BUFFET","1901","CA1706000401",null,"2017-08-07","8P",864,{"$f":"G68*256","v":{"v":221184,"d":"221,184 "}},"K","JUILLET"]
["MIX BUFFET","1901","STOCK ÉTÉ",null,"2017-08-04","8P",864,{"$f":"G69*256","v":{"v":221184,"d":"221,184 "}},"K","JUILLET"]
["AIR FRANCE","1908","5306056",null,"2017-07-24","1P",120,{"v":15360,"d":"15,360 "},"M","JUILLET"]
["MIX BUFFET","1910","CA1706000401",null,"2017-08-07","8P",864,{"$f":"G71*256","v":{"v":221184,"d":"221,184 "}},"K","JUILLET"]
["MIX BUFFET","1910","STOCK ÉTÉ",null,"2017-08-04","8P",864,{"v":221184,"d":"221,184 "},"L","JUILLET"]
["MIX BUFFET","1910","CA1705001099",null,"2017-07-24","8P",864,{"v":221184,"d":"221,184 "},"L","JUILLET"]
["PERI","1992",null,null,"2017-07-13","46P",3900,{"v":998400,"d":"998,400 "},"M","JUILLET"]
["IFOOD","2301","PO17UK00110",null,"2017-07-28","3P",324,{"v":82944,"d":"82,944 "},"M","JUILLET"]
["IFOOD","2301","PO17UK02279",null,"2017-07-28","1P",108,{"v":27648,"d":"27,648 "},"M","JUILLET"]
["IFOOD","2301","PO17UK00111",null,"2017-07-28","1P",108,{"v":27648,"d":"27,648 "},"M","JUILLET"]
["CLASSIC FINE FOOD","2706","16461",null,"2017-08-04","1P",10,{"v":2560,"d":"2,560 "},"L","JUILLET"]
["MIX BUFFET"," 15 BD5 + 1 olive medelys 7 P5","CA1705001100",null,"2017-06-19","8P",864,{"v":221184,"d":"221,184 "},"K","JUIN"]
["AIR FRANCE","0100","5302711",null,"2017-08-04","6P",648,{"v":165888,"d":"165,888 "},"K","JUIN"]
["AIR TRANSAT","0205","4500799187",null,"2017-06-23","1P",108,{"v":27648,"d":"27,648 "},"K","JUIN"]
["STOCK - COMATEC","0206",null,null,"2017-06-20","2P",216,{"v":55296,"d":"55,296 "},"K","JUIN"]
["AERO MEXICO","0500","21888-6",null,"2018-07-09","2P",176,{"v":45056,"d":"45,056 "},"L","JUIN"]
["AIR CANADA","0500",null,null,"2017-07-24","20P",2700,{"v":691200,"d":"691,200 "},"L","JUIN"]
["AERO MEXICO","0500","AM14107_5",null,"2017-06-29","2P",168,{"v":43008,"d":"43,008 "},"L","JUIN"]
["LSG","0500","4500873806",null,"2017-06-15","2P",200,{"v":51200,"d":"51,200 "},"L","JUIN"]
["HACO","0504","PO00138706",null,"2017-07-07","5P",540,{"v":138240,"d":"138,240 "},"L","JUIN"]
["ALCAMORETTI","0511",null,null,"2017-06-30","1P",400,{"$f":"G88*50","v":{"v":20000,"d":"20,000 "}},"L","JUIN"]
["ANA","1300",null,null,"2017-07-05","2P",216,{"$f":"G89*256","v":{"v":55296,"d":"55,296 "}},"K","JUIN"]
["ANA","1300",null,null,"2017-06-29","3P",324,{"$f":"G90*256","v":{"v":82944,"d":"82,944 "}},"L","JUIN"]
["AIR FRANCE","1908",null,null,"2017-06-23","1P",40,{"v":5120,"d":"5,120 "},"M","JUIN"]
["MIX BUFFET","1910","CA1705001151",null,"2017-07-04","8P",864,{"$f":"G92*256","v":{"v":221184,"d":"221,184 "}},"L","JUIN"]
["IFOOD","3001",null,null,"2017-06-21","1P",108,{"v":27648,"d":"27,648 "},"M","JUIN"]
["STOCK","0200",{"$nulls":3},"40P",4320,{"v":1105920,"d":"1,105,920 "},"L","MAI"]
["AERO MEXICO","0500","21888-5",null,"2018-06-11","2P",176,{"v":45056,"d":"45,056 "},"L","MAI"]
["AERO MEXICO","0500","21888-3",null,"2018-04-09","2P",156,{"v":39936,"d":"39,936 "},"L","MARS"]
["AIR FRANCE","0100","5314131",null,"2017-11-27","6P",648,{"v":165888,"d":"165,888 "},"L","NOVEMBRE"]
["EXKI","0213","AC5026",null,"2017-11-17","3P",324,{"v":82944,"d":"82,944 "},"L","NOVEMBRE"]
["NGMODT","0218",null,null,"2017-11-28","1P",40,{"v":10240,"d":"10,240 "},"L","NOVEMBRE"]
["STOCK","0250",null,null,"2017-11-08","5P",600,{"$f":"G100*128","v":{"v":76800,"d":"76,800 "}},"M","NOVEMBRE"]
["CLASS CROUTE","0252",{"$nulls":3},"6P",720,{"$f":"G101*128","v":{"v":92160,"d":"92,160 "}},"M","NOVEMBRE"]
["AERO MEXICO","0500","18210-6",null,"2017-12-10","2P",125,{"$f":"G102*256","v":{"v":32000,"d":"32,000 "}},"K","NOVEMBRE"]
["EVA AIR","0500","QP17005390",null,"2017-12-04","2P",192,{"$f":"G103*256","v":{"v":49152,"d":"49,152 "}},"K","NOVEMBRE"]
["EVA AIR","0500","QP17004984",null,"2017-11-13","2P",192,{"$f":"G104*256","v":{"v":49152,"d":"49,152 "}},"K","NOVEMBRE"]
["HACO","0504","PO00154825",null,"2017-12-15","6P",648,{"$f":"G105*256","v":{"v":165888,"d":"165,888 "}},"L","NOVEMBRE"]
["CLASSIC FINE FOOD","0506","PO18794","lot b","2017-12-12","1P",60,{"$f":"G106*256","v":{"v":15360,"d":"15,360 "}},"L","NOVEMBRE"]
["ALCAMORETTI","0511",null,null,"2017-12-01","1P",null,{"v":20000,"d":"20,000 "},"L","NOVEMBRE"]
["AIR FRANCE","05GR50","5313869",null,"2017-11-27","1P",120,{"$f":"G108*128","v":{"v":15360,"d":"15,360 "}},"M","NOVEMBRE"]
["CLASSIC FINE FOOD","1306","PO18794","lot b","2017-12-12","1P",40,{"$f":"G109*256","v":{"v":10240,"d":"10,240 "}},"L","NOVEMBRE"]
["CLASSIC FINE FOOD","1306","PO18793","lot a","2017-12-05","1P",20,{"$f":"G110*256","v":{"v":5120,"d":"5,120 "}},"L","NOVEMBRE"]
["ALCAMORETTI","1311",null,null,"2017-12-01","1P",null,{"v":20000,"d":"20,000 "},"L","NOVEMBRE"]
["IFOOD","1400",null,null,"2017-12-05","1P",54,{"$f":"G112*256","v":{"v":13824,"d":"13,824 "}},"L","NOVEMBRE"]
["IFOOD","1400","PO17UKT00175",null,"2017-11-08","1P",108,{"$f":"G113*256","v":{"v":27648,"d":"27,648 "}},"K","NOVEMBRE"]
["LEGUFRUIT","1450",null,null,"2017-11-08","1P",30,{"$f":"G114*128","v":{"v":3840,"d":"3,840 "}},"M","NOVEMBRE"]
["MIX BUFFET","1901","CA1711000242",null,"2017-12-04","6P",648,{"$f":"G115*256","v":{"v":165888,"d":"165,888 "}},"K","NOVEMBRE"]
["MIX BUFFET","1910","CA1711000242",null,"2017-12-04","4P",432,{"$f":"G116*256","v":{"v":110592,"d":"110,592 "}},"K","NOVEMBRE"]
["PERI","1992",{"$nulls":3},"11TC",1870,{"$f":"G117*256","v":{"v":478720,"d":"478,720 "}},"M","NOVEMBRE"]
["AIR FRANCE","3150","5313869",null,"2017-11-27","1P",36,{"$f":"G118*128","v":{"v":4608,"d":"4,608 "}},"M","NOVEMBRE"]
["EXKI","0213","AC4945",null,"2017-10-06","2P",216,{"$f":"G119*256","v":{"v":55296,"d":"55,296 "}},"K","OCTOBRE"]
["AERO MEXICO","0500","18210-5",null,"2017-11-10","2P",125,{"v":32000,"d":"32,000 "},"K","OCTOBRE"]
["EVA AIR","0500","QP17004576",null,"2017-10-30","2P",192,{"v":49152,"d":"49,152 "},"L","OCTOBRE"]
["AERO MEXICO","0500","18210-4",null,"2017-10-10","2P",137,{"v":35072,"d":"35,072 "},"K","OCTOBRE"]
["LSG","0500","4500925649",null,"2017-10-06","2P",200,{"v":51200,"d":"51,200 "},"L","OCTOBRE"]
["HACO","0504","PO00151046",null,"2017-10-16","6P",648,{"v":165888,"d":"165,888 "},"K","OCTOBRE"]
["HACO","0504","PO00149747",null,"2017-10-15","10P",1080,{"v":276480,"d":"276,480 "},"K","OCTOBRE"]
["LEGUFRUIT","0750","TEL",null,"2017-10-10","1P",30,{"$f":"G126*128","v":{"v":3840,"d":"3,840 "}},"M","OCTOBRE"]
["ELAL","1302","4000000829",null,"2017-10-23","2P",270,{"$f":"G127*256","v":{"v":69120,"d":"69,120 "}},"K","OCTOBRE"]
["LEGUFRUIT","1450","TEL",null,"2017-10-10","1P",30,{"$f":"G128*128","v":{"v":3840,"d":"3,840 "}},"M","OCTOBRE"]
["IFOOD","1500","PO17UK03806",null,"2017-10-18","1P",108,{"$f":"G129*256","v":{"v":27648,"d":"27,648 "}},"K","OCTOBRE"]
["MIX BUFFET","1901","CA1710000764",null,"2017-11-04","6P",648,{"v":165888,"d":"165,888 "},"K","OCTOBRE"]
["MIX BUFFET","1910","1710000764",null,"2017-11-27","4P",432,{"v":110592,"d":"110,592 "},"K","OCTOBRE"]
["MIX BUFFET","1910","CA1710000151",null,"2017-10-27","4P",432,{"v":110592,"d":"110,592 "},"K","OCTOBRE"]
["PERI","1992",null,null,"2017-11-06","28P",2380,{"v":609280,"d":"609,280 "},"M","OCTOBRE"]
["AIR FRANCE","0100","5308765",null,"2017-10-19","6P",648,{"v":165888,"d":"165,888 "},"K","SEPTEMBRE"]
["AIR FRANCE","0100","5308763",null,"2017-09-14","6P",648,{"v":165888,"d":"165,888 "},"K","SEPTEMBRE"]
["LSG Belgique","0200","4505956507",null,"2017-09-22","1P",120,{"v":30720,"d":"30,720 "},"K","SEPTEMBRE"]
["DEAN & DELUCA","0203","BAILLY20170712",null,"2017-09-10",null,40,{"v":10240,"d":"10,240 "},"M","SEPTEMBRE"]
["QUALIFIRST","0204","29128",null,"2017-09-15","1P",135,{"v":34560,"d":"34,560 "},"K","SEPTEMBRE"]
["AIR TRANSAT","0205","4500821104",null,"2017-10-02","2P",216,{"v":55296,"d":"55,296 "},"L","SEPTEMBRE"]
["COMATEC","0206",null,null,"2017-10-03","1P",108,{"v":27648,"d":"27,648 "},"L","SEPTEMBRE"]
["COMATEC","0206",null,null,"2017-09-15","1P",108,{"v":27648,"d":"27,648 "},"K","SEPTEMBRE"]
["EXKI","0213","AC4880",null,"2017-09-14","2P",216,{"v":55296,"d":"55,296 "},"K","SEPTEMBRE"]
["SYSTÈME U EST","0217",null,null,"2017-09-13","1P",216,{"$f":"G143*50","v":{"v":10800,"d":"10,800 "}},"K","SEPTEMBRE"]
["STOCK","0300",null,null,"2017-09-13","1P",108,{"$f":"G144*256","v":{"v":27648,"d":"27,648 "}},"K","SEPTEMBRE"]
["VANDENBOGAERDE","0302","34395",null,"2017-10-02","1P",108,{"$f":"G145*256","v":{"v":27648,"d":"27,648 "}},"K","SEPTEMBRE"]
["DEAN & DELUCA","0303","BAILLY20170712",null,"2017-09-10",null,40,{"$f":"G146*256","v":{"v":10240,"d":"10,240 "}},"M","SEPTEMBRE"]
["LOGIESMOSE","0402","K04012616",null,"2017-11-17","1P",57,{"$f":"G147*256","v":{"v":14592,"d":"14,592 "}},"K","SEPTEMBRE"]
["DEAN & DELUCA","0403","BAILLY20170712",null,"2017-09-10",null,40,{"$f":"G148*256","v":{"v":10240,"d":"10,240 "}},"M","SEPTEMBRE"]
["SYSTÈME U EST","0417",null,null,"2017-09-13","1P",216,{"$f":"G149*50","v":{"v":10800,"d":"10,800 "}},"K","SEPTEMBRE"]
["AIR CANADA","0500","AC075954",null,"2017-11-01","20P",2700,{"$f":"G150*256","v":{"v":691200,"d":"691,200 "}},"K","SEPTEMBRE"]
["EVA AIR","0500","QP17004367",null,"2017-10-05","2P",192,{"v":49152,"d":"49,152 "},"K","SEPTEMBRE"]
["AERO MEXICO","0500","18210-3",null,"2017-09-22","2P",137,{"v":35072,"d":"35,072 "},"K","SEPTEMBRE"]
["AERO MEXICO","0500","18210-1",null,"2017-09-22","2P",156,{"v":39936,"d":"39,936 "},"K","SEPTEMBRE"]
["AERO MEXICO","0500","18210-2",null,"2017-09-22","2P",125,{"v":32000,"d":"32,000 "},"K","SEPTEMBRE"]
["EVA AIR","0500","QP17004367",null,"2017-09-15","2P",192,{"v":49152,"d":"49,152 "},"K","SEPTEMBRE"]
["LSG KOREA","0500",null,null,"2017-09-13","2P",200,{"v":51200,"d":"51,200 "},"L","SEPTEMBRE"]
["HALTE NATURE","0502",null,null,"2017-10-02","1P",40,{"v":10240,"d":"10,240 "},"L","SEPTEMBRE"]
["HACO","0504","PO00148759",null,"2017-09-25","4P",432,{"v":110592,"d":"110,592 "},"K","SEPTEMBRE"]
["AIR FRANCE","05GR50","5303690",null,"2017-09-08","1P",120,{"v":15360,"d":"15,360 "},"M","SEPTEMBRE"]
["FBS","1300",{"$nulls":3},"3P",294,{"$f":"G160*256","v":{"v":75264,"d":"75,264 "}},"K","SEPTEMBRE"]
["RAFFAEL","1301",null,null,"2017-10-10","1P",20,{"$f":"G161*256","v":{"v":5120,"d":"5,120 "}},"L","SEPTEMBRE"]
["DEAN & DELUCA","1303","BAILLY20170712",null,"2017-09-10",null,40,{"$f":"G162*256","v":{"v":10240,"d":"10,240 "}},"M","SEPTEMBRE"]
["STOCK","1400",null,null,"2017-09-15","1P",108,{"$f":"G163*256","v":{"v":27648,"d":"27,648 "}},"K","SEPTEMBRE"]
["DEAN & DELUCA","1483","BAILLY20170712",null,"2017-09-10",null,40,{"$f":"G164*50","v":{"v":2000,"d":"2,000 "}},"M","SEPTEMBRE"]
["IFOOD","1500","PO17UK03400",null,"2017-09-29","1P",108,{"$f":"G165*256","v":{"v":27648,"d":"27,648 "}},"K","SEPTEMBRE"]
["DEAN & DELUCA","1503","BAILLY20170712",null,"2017-09-10",null,40,{"$f":"G166*256","v":{"v":10240,"d":"10,240 "}},"M","SEPTEMBRE"]
["DEAN & DELUCA","1683B","BAILLY20170712",null,"2017-09-10",null,40,{"$f":"G167*50","v":{"v":2000,"d":"2,000 "}},"M","SEPTEMBRE"]
["DEAN & DELUCA","1783","BAILLY20170712",null,"2017-09-10",null,40,{"$f":"G168*50","v":{"v":2000,"d":"2,000 "}},"M","SEPTEMBRE"]
["DEAN & DELUCA","1913","BAILLY20170712",null,"2017-09-10",null,40,{"$f":"G169*256","v":{"v":10240,"d":"10,240 "}},"M","SEPTEMBRE"]
["IFOOD","2301","PO17UK03344",null,"2017-10-02","1P",108,{"v":27648,"d":"27,648 "},"L","SEPTEMBRE"]
["IFOOD","2301","PO17UK03247",null,"2017-10-02","1P",108,{"v":27648,"d":"27,648 "},"L","SEPTEMBRE"]
["IFOOD","2301","PO17UK00112",null,"2017-09-19","1P",108,{"v":27648,"d":"27,648 "},"M","SEPTEMBRE"]
["IFOOD","2301","PO17UKT00116",null,"2017-09-15","1P",108,{"v":27648,"d":"27,648 "},"M","SEPTEMBRE"]
["LOGIESMOSE","3202","K04012616",null,"2017-11-17","1P",57,{"v":14592,"d":"14,592 "},"K","SEPTEMBRE"]

{"sheet":"Test","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[1,2,1,6],[1,7,1,11],[4,0,4,1],[6,0,6,1],[7,0,7,1],[8,0,8,1]]}
[]
["Réf","Bouchon Métal"]
["Délai Livraison (MOIS)",2,"JANVIER","FEVRIER","MARS","AVRIL","MAI","JUIN","JUILLET","AOUT","SEPTEMBRE","OCTOBRE","NOVEMBRE","DECEMBRE"]
["Taille de lot",1000000]
["Quantité à livrer",null,{"$f":"SUMIF(Détails!$J:$J,\"*\"&C3,Détails!$H:$H)","v":1740544},{"$f":"SUMIF(Détails!$J:$J,\"*\"&D3,Détails!$H:$H)","v":865536},{"$f":"SUMIF(Détails!$J:$J,\"*\"&E3,Détails!$H:$H)","v":39936},{"$f":"SUMIF(Détails!$J:$J,\"*\"&F3,Détails!$H:$H)","v":109824},{"$f":"SUMIF(Détails!$J:$J,\"*\"&G3,Détails!$H:$H)","v":1150976},{"$f":"SUMIF(Détails!$J:$J,\"*\"&H3,Détails!$H:$H)","v":1850912},{"$f":"SUMIF(Détails!$J:$J,\"*\"&I3,Détails!$H:$H)","v":3185168},{"$f":"SUMIF(Détails!$J:$J,\"*\"&J3,Détails!$H:$H)","v":1071136},{"$f":"SUMIF(Détails!$J:$J,\"*\"&K3,Détails!$H:$H)","v":2066640},{"$f":"SUMIF(Détails!$J:$J,\"*\"&L3,Détails!$H:$H)","v":1765888},{"$f":"SUMIF(Détails!$J:$J,\"*\"&M3,Détails!$H:$H)","v":1615424},{"$f":"SUMIF(Détails!$J:$J,\"*\"&N3,Détails!$H:$H)","v":468336}]
["Stock (SI)",5000000,{"$f":"IF(B6-C5>=0,B6-C5,C8+B6-C5)","v":3259456},{"$f":"IF(C6-D5>=0,C6-D5,D8+C6-D5)","v":2393920},2353984,2244160,1093184,242272,57104,985968,919328,153440,538016,69680]
["Quantité Manquante",null,{"$f":"IF(B6-C5>0,0,ABS(B6-C5))","v":0},{"$f":"IF(C6-D5>0,0,ABS(C6-D5))","v":0},0,0,0,757728,2942896,1014032,1080672,846560,1461984,0]
["Quantité à commander",null,{"$f":"IF(B6-C5>0,0,ROUNDUP(C7,0))","v":0},{"$f":"IF(C6-D5>0,0,ROUNDUP(D7,0))","v":0},0,0,0,{"$f":"IF(G6-H5>0,0,ROUNDUP(H7,-6))","v":1000000},{"$f":"IF(H6-I5>0,0,ROUNDUP(I7,-6))","v":3000000},2000000,2000000,1000000,2000000,0]
["Quantité à lancer en commande",null,{"$f":"OFFSET(C8,0,$B$3)","v":0},{"$f":"OFFSET(D8,0,$B$3)","v":0},0,1000000,3000000,2000000,2000000,1000000,{"$f":"OFFSET(K8,0,$B$3)","v":2000000},0,0,0]
[]
[]
[{"$nulls":3},"bonne formule",{"$f":"SUM(SUMIF(Détails!B:B,Nomen!C4:C35,Détails!H:H),SUMIF(Nomen!C2:H2,Test!B2,Détails!H:H),SUMIF(Détails!J:J,Test!C3,Détails!H:H))","v":15505904}]
[]
[]
[{"$nulls":4},{"$f":"SUM(SUMIF(Détails!B:B,Nomen!C4:C35,Détails!H:H))","v":13765360}]

{"sheet":"Nomenclatures","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Nomen","index":3,"n_rows":35,"n_cols":8,"rows_kept":35,"merged":[[1,2,1,3],[1,4,1,5],[1,6,1,7]]}
[]
["BP",null,"Blle SOM 20ML",null,"Blle EUR 20ML",null,"Blle EUR 30ML"]
["BM",null,"BM","BP","BM","BP","BM","BP"]
["Blle EUR 20ML",null,"0100",null,"0100",302,"0250"]
["Blle EUR 30ML",null,"0200",null,null,1901,"0252"]
["Blle SOM 20ML",null,"0203",null,null,2105,"0450"]
["Blle SOM 30ML",null,"0204",{"$nulls":3},"0550"]
[null,null,"0205",{"$nulls":3},"0750"]
[null,null,"0206",{"$nulls":3},"1450"]
[null,null,"0213",{"$nulls":3},"1908"]
[null,null,"0217",{"$nulls":3},"3150"]
[null,null,"0218"]
[null,null,"0402"]
[null,null,"0403"]
[null,null,"0417"]
[null,null,"0500"]
[null,null,"0502"]
[null,null,"0504"]
[null,null,"0506"]
[null,null,"0511"]
[null,null,"0600"]
[null,null,"1300"]
[null,null,"1301"]
[null,null,"1311"]
[null,null,"1302"]
[null,null,"1306"]
[null,null,"1400"]
[null,null,"1500"]
[null,null,"1910"]
[null,null,"1913"]
[null,null,"1992"]
[null,null,"2301"]
[null,null,"2706"]
[null,null,"3001"]
[null,null,"3202"]