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

{"sheet":"Donnees","index":0,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Familles","Tonnage (kg)","lavage ","Unité de lavage (Kg)","TcycleL","Séchoir","TcycleS","Calandre","TcycleC","TempsTraitement (min)"]
["alése abs PE",970.49648508744758,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU21","v":2},"00:23:00","Plat5",128.32600239659175,10.601259211066251,null,"TBL",null,"lavage ","Étiquettes de lignes","Somme de Poids livré en kg","Cadencement réel ","nombre de passes ","cadencement nominal","C","Cadencement"]
["alése abs PM",2078.2961398818106,"Kannegiesser",53,"00:01:40",{"$f":"'[1]Pliage main'!BU12","v":2},"00:23:00","Plat6",59.425663258835094,15.233893847766728,null,"Étiquettes de lignes","Somme de Tonnage (kg)","Kannegeisser","Plat2",92009.713572368244,{"$f":"P3/$P$8","v":0.26095678207636092},1.5,{"$f":"R3/$R$8","v":0.3},1,"Plat2",null,null,5]
["Bavoir",2107.7192894078671,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU22","v":2},"00:23:00","Plat5",128.32600239659175,36.129966216151892,null,"Plat2",92009.713572368244,"Kannegeisser","Plat3",49855.894259756729,0.14140065465297327,0.5,0.1,2,"Plat2"]
["chmal PE",1567.7250912951076,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU20","v":2},"00:23:00","Plat5",128.32600239659175,17.870051561374904,null,"Plat3",49855.894259756729,"Kannegeisser","Plat4",29070.533135324044,8.2449477187771722E-2,0.5,0.1,3,"Plat3"]
["chmal PM",4991.7814878393356,"Kannegiesser",53,"00:01:40",{"$f":"'[1]Pliage main'!BU16","v":2},"00:23:00","Plat6",59.425663258835094,25.679069167173306,null,"Plat4",29070.533135324044,"Kannegeisser","Plat5",62317.570069485701,0.17674430145204675,1,0.2,4,"Plat4"]
["chp grd",52.202181225934488,"Kannegiesser",53,"00:01:40",{"$f":"[1]Mixte!BU20","v":0},"00:00:00","Plat4",122.75658904999779,42.679907289904499,null,"Plat5",62317.570069485701,"Kannegeisser","Plat6",119332.31045011926,0.33844878463084738,1.5,0.3,5,"Plat5"]
["chp petit",187.01558128514398,"Kannegiesser",53,"00:01:40",{"$f":"[1]Mixte!BU21","v":0},"00:00:00","Plat4",122.75658904999779,71.076447353771258,null,"Plat6",119332.31045011926,"Total",null,{"$f":"SUM(P3:P7)","v":352586.02148705395},1,{"$f":"SUM(R3:R7)","v":5},1,6,"Plat6"]
["drap 1/2",660.63634201947195,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,29.04442177752874,null,"Total général",352586.02148705395,null,null,null,null,null,null,7,"Plat6"]
["Drap ambulatoire",1397.802095350751,"Kannegiesser",53,"00:01:40",{"$f":"[1]Mixte!BU23","v":0},"00:00:00","Plat4",122.75658904999779,27.924067203740442,null,null,null,null,null,null,null,null,null,8,"Plat2"]
["drap bain",16717.42406876275,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU12","v":5},"00:27:00","Plat5",128.32600239659175,15.541683995727912,null,null,null,null,null,null,null,null,null,9,"Plat5"]
["drap bain luxe",995.6298555986865,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU13","v":5},"00:27:00","Plat5",128.32600239659175,7.8190687871465983,null,null,null,null,null,null,null,null,null,10,"Plat6"]
["drap bain spa",307.57273219694491,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU19","v":5},"00:03:00","Plat5",128.32600239659175,7.1849364634392963,null,null,null,null,null,null,null,null,null,11]
["drap grand GP",7194.3295542388323,"Kannegiesser",53,"00:01:40",{"$f":"[1]GP!BU13","v":0},"00:00:00","Plat3",12.968484605365797,10.593184578638812,null,null,null,null,null,null,null,null,null,12]
["drap grand M",2280.6778205505361,"Kannegiesser",53,"00:01:40",{"$f":"[1]Mixte!BU30","v":0},"00:00:00","Plat4",122.75658904999779,15.475941817308406,null,null,null,null,null,null,null,null,null,13]
["drap housse",22937.183830343176,"Kannegiesser",53,"00:01:40",{"$f":"'[1]Pliage main'!BU17","v":2},"00:23:00","Plat6",59.425663258835094,15.330223780685532,null,null,null,null,null,null,null,null,null,14]
["drap luxe",10.89780351668427,"Kannegiesser",53,"00:01:40",{"$f":"[1]GP!BU14","v":0},"00:00:00","Plat3",12.968484605365797,10.378328137146351,null,null,null,null,null,null,null,null,null,15]
["drap petit GP",36603.720375161851,"Kannegiesser",53,"00:01:40",{"$f":"[1]GP!BU12","v":0},"00:00:00","Plat3",12.968484605365797,15.09615011101668,null,null,null,null,null,null,null,null,null,16]
["drap petit M",8818.6209061287409,"Kannegiesser",53,"00:01:40",{"$f":"[1]Mixte!BU29","v":0},"00:00:00","Plat4",122.75658904999779,20.893714617733611,null,null,null,null,null,null,null,null,null,17]
["grde al",596.77736304405698,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,25.943672557999921,null,null,null,null,null,null,null,null,null,18]
["hous trav",4949.8310965348455,"Kannegiesser",53,"00:01:40",{"$f":"[1]Mixte!BU25","v":0},"00:00:00","Plat4",122.75658904999779,66.424402609903183,null,null,null,null,null,null,null,null,null,19]
["housse couette GP",3572.4779160918265,"Kannegiesser",53,"00:01:40",{"$f":"[1]GP!BU15","v":0},"00:00:00","Plat3",12.968484605365797,5.8280417572905003,null,null,null,null,null,null,null,null,null,20]
["housse couette M",1900.5648504587803,"Kannegiesser",53,"00:01:40",{"$f":"[1]Mixte!BU31","v":0},"00:00:00","Plat4",122.75658904999779,11.494417617421783,null,null,null,null,null,null,null,null,null,21]
["petite housse GP",2474.4686107475345,"Kannegiesser",53,"00:01:40",{"$f":"[1]GP!BU16","v":0},"00:00:00","Plat3",12.968484605365797,9.2843848460547385,null,null,null,null,null,null,null,null,null,22]
["petite housse M",1292.3840983119705,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,15.922806259762748,null,null,null,null,null,null,null,null,null,23]
["pte al",6934.0208004138121,"Kannegiesser",53,"00:01:40",{"$f":"[1]Mixte!BU26","v":0},"00:05:00","Plat4",122.75658904999779,28.651055195893566,null,null,null,null,null,null,null,null,null,24]
["serv éponge",30640.564796231411,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU14","v":5},"00:23:00","Plat5",128.32600239659175,32.930319438813818,null,null,null,null,null,null,null,null,null,25]
["serv éponge luxe",373.019033627201,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU15","v":5},"00:12:00","Plat5",128.32600239659175,20.079858026190493,null,null,null,null,null,null,null,null,null,26]
["serv œil",394.82062400415185,"Kannegiesser",53,"00:01:40",{"$f":"[1]PP!BU15","v":0},"00:27:00","Plat2",316.44202400113028,60.233571385417278,null,null,null,null,null,null,null,null,null,27]
["tablier blanc",7609.3535827234555,"Kannegiesser",53,"00:01:40",{"$f":"[1]PP!BU22","v":2},"00:05:00","Plat2",316.44202400113028,22.611992644203188,null,null,null,null,null,null,null,null,null,28]
["tablier bleu",418.20721148871831,"Kannegiesser",53,"00:01:40",{"$f":"[1]PP!BU21","v":2},"00:12:00","Plat2",316.44202400113028,26.522225855348644,null,null,null,null,null,null,null,null,null,29]
["tablier bret",1944.7552455303226,"Kannegiesser",53,"00:01:40",{"$f":"[1]PP!BU23","v":2},"00:03:00","Plat2",316.44202400113028,23.798005043284753,null,null,null,null,null,null,null,null,null,30]
["taie am",19607.131522844975,"Kannegiesser",53,"00:01:40",{"$f":"[1]PP!BU12","v":1},"00:12:00","Plat2",316.44202400113028,62.81166285671268]
["Taie Carrée",36290.022489041316,"Kannegiesser",53,"00:01:40",{"$f":"[1]PP!BU14","v":1},"00:23:00","Plat2",316.44202400113028,45.167626102291202]
["taie luxe",3043.9248573049472,"Kannegiesser",53,"00:01:40",{"$f":"[1]PP!BU13","v":1},"00:27:00","Plat2",316.44202400113028,46.985467062736781]
["tapis bain",8363.9377846856933,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU16","v":5},"00:27:00","Plat5",128.32600239659175,29.813361011801284]
["tapis bain luxe",273.48093259259099,"Kannegiesser",53,"00:01:40",{"$f":"[1]PE!BU17","v":5},"00:23:00","Plat5",128.32600239659175,19.372210721454529]
["torchon",22701.498039430357,"Kannegiesser",53,"00:01:40",{"$f":"[1]PP!BU20","v":1},"00:12:00","Plat2",316.44202400113028,96.967218101448225]
["VT",44662.524496027465,"Kannegiesser",53,"00:01:40",{"$f":"'[1]Pliage main'!BU25","v":0},"00:00:00","Plat6",59.425663258835094,9.0857142857142872]
["VT Séché TF",44662.524496027465,"Kannegiesser",53,"00:01:40",{"$f":"'[1]Pliage main'!BU25","v":0},"00:12:00","Plat6",59.425663258835094,9.0857142857142872]

{"sheet":"Interface","index":1,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["UniteLavage",53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonnage Calandre "]
["TempsBoucle","10 s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plat1"]
["Tonnage Tunel",1060]
["Tonnage semaine ",1060,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock","Plat2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318]
[null,"M1 ","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13","M14","M15","M16","M17","M18","P",null,null,null,"Plat3"]
[null,53,53,53,53,53,53,53,53,53,53,53,53,53,53,53,53,53,53,53,null,null,null,106]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plat4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plat5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,212]
[null,"C","Plat","Stock ","Kg","calandre choisie ",null,"Familles","Tonnage (kg)","lavage ","Unité de lavage (Kg)","TcycleL","Séchoir","TcycleS","Calandre","TcycleC","TempsTraitement (min)","Nouveau Tonnage","Tonnage (kg)",null,null,null,null,"Plat6"]
[null,1,"Plat2",21,100,"Ligne 40",null,"alése abs PE",970.49648508744758,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat5",128.32600239659175,10.601259211066251,null,970.49648508744758,null,null,null,null,318]
[null,2,"Plat2",10,53,"Ligne 42",null,"alése abs PM",2025.2961398818106,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat6",59.425663258835094,15.233893847766728,2025.2961398818106,2078.2961398818106]
[null,3,"Plat3",5,30,"Ligne 33",null,"Bavoir",2107.7192894078671,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat5",128.32600239659175,36.129966216151892,null,2107.7192894078671]
[null,4,"Plat4",null,null,"Ligne 32",null,"chmal PE",1514.7250912951076,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat5",128.32600239659175,17.870051561374904,1514.7250912951076,1567.7250912951076]
[null,5,"Plat5",null,null,"Ligne 22",null,"chmal PM",4938.7814878393356,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat6",59.425663258835094,25.679069167173306,4938.7814878393356,4991.7814878393356]
[null,6,"Plat6",null,null,"Ligne 50",null,"chp grd",52.202181225934488,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,42.679907289904499,null,52.202181225934488]
[null,7,"Plat6",null,null,"Ligne 50",null,"chp petit",187.01558128514398,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,71.076447353771258,null,187.01558128514398]
[null,8,"Plat2",null,null,"Ligne 40",null,"drap 1/2",607.63634201947195,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,29.04442177752874,607.63634201947195,660.63634201947195]
[null,9,"Plat5",null,null,"Ligne 47",null,"Drap ambulatoire",1397.802095350751,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,27.924067203740442,null,1397.802095350751]
[null,10,"Plat6",null,null,"Ligne 17",null,"drap bain",16664.42406876275,"Kannegiesser",53,"00:01:40",5,"00:27:00","Plat5",128.32600239659175,15.541683995727912,16664.42406876275,16717.42406876275]
[null,11,null,null,null,null,null,"drap bain luxe",995.6298555986865,"Kannegiesser",53,"00:01:40",5,"00:27:00","Plat5",128.32600239659175,7.8190687871465983,null,995.6298555986865]
[null,12,null,null,null,null,null,"drap bain spa",307.57273219694491,"Kannegiesser",53,"00:01:40",5,"00:03:00","Plat5",128.32600239659175,7.1849364634392963,null,307.57273219694491]
[null,13,null,null,null,null,null,"drap grand GP",7194.3295542388323,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat3",12.968484605365797,10.593184578638812,null,7194.3295542388323]
[null,14,null,null,null,null,null,"drap grand M",2280.6778205505361,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,15.475941817308406,null,2280.6778205505361]
[null,15,null,null,null,null,null,"drap housse",22884.183830343176,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat6",59.425663258835094,15.330223780685532,22884.183830343176,22937.183830343176]
[null,16,null,null,null,null,null,"drap luxe",10.89780351668427,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat3",12.968484605365797,10.378328137146351,null,10.89780351668427]
[null,17,null,null,null,null,null,"drap petit GP",36550.720375161851,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat3",12.968484605365797,15.09615011101668,36550.720375161851,36603.720375161851]
[null,18,null,null,null,null,null,"drap petit M",8818.6209061287409,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,20.893714617733611,null,8818.6209061287409]
[null,19,null,null,null,null,null,"grde al",596.77736304405698,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,25.943672557999921,null,596.77736304405698]
[null,20,null,null,null,null,null,"hous trav",4896.8310965348455,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,66.424402609903183,4896.8310965348455,4949.8310965348455]
[null,21,null,null,null,null,null,"housse couette GP",3519.4779160918265,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat3",12.968484605365797,5.8280417572905003,3519.4779160918265,3572.4779160918265]
[null,22,null,null,null,null,null,"housse couette M",1900.5648504587803,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,11.494417617421783,null,1900.5648504587803]
[null,23,null,null,null,null,null,"petite housse GP",2474.4686107475345,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat3",12.968484605365797,9.2843848460547385,null,2474.4686107475345]
[null,24,null,null,null,null,null,"petite housse M",1292.3840983119705,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,15.922806259762748,null,1292.3840983119705]
[null,25,null,null,null,null,null,"pte al",6934.0208004138121,"Kannegiesser",53,"00:01:40",0,"00:05:00","Plat4",122.75658904999779,28.651055195893566,null,6934.0208004138121]
[null,26,null,null,null,null,null,"serv éponge",30640.564796231411,"Kannegiesser",53,"00:01:40",5,"00:23:00","Plat5",128.32600239659175,32.930319438813818,null,30640.564796231411]
[null,27,null,null,null,null,null,"serv éponge luxe",320.019033627201,"Kannegiesser",53,"00:01:40",5,"00:12:00","Plat5",128.32600239659175,20.079858026190493,320.019033627201,373.019033627201]
[null,28,null,null,null,null,null,"serv œil",288.82062400415185,"Kannegiesser",53,"00:01:40",0,"00:27:00","Plat2",316.44202400113028,60.233571385417278,288.82062400415185,394.82062400415185]
[null,29,null,null,null,null,null,"tablier blanc",7609.3535827234555,"Kannegiesser",53,"00:01:40",2,"00:05:00","Plat2",316.44202400113028,22.611992644203188,null,7609.3535827234555]
[null,30,null,null,null,null,null,"tablier bleu",365.20721148871831,"Kannegiesser",53,"00:01:40",2,"00:12:00","Plat2",316.44202400113028,26.522225855348644,365.20721148871831,418.20721148871831]
[null,null,null,null,null,null,null,"tablier bret",1891.7552455303226,"Kannegiesser",53,"00:01:40",2,"00:03:00","Plat2",316.44202400113028,23.798005043284753,1891.7552455303226,1944.7552455303226]
[null,null,null,null,null,null,null,"taie am",19554.131522844975,"Kannegiesser",53,"00:01:40",1,"00:12:00","Plat2",316.44202400113028,62.81166285671268,19554.131522844975,19607.131522844975]
[null,null,null,null,null,null,null,"Taie Carrée",36237.022489041316,"Kannegiesser",53,"00:01:40",1,"00:23:00","Plat2",316.44202400113028,45.167626102291202,36237.022489041316,36290.022489041316]
[null,null,null,null,null,null,null,"taie luxe",3043.9248573049472,"Kannegiesser",53,"00:01:40",1,"00:27:00","Plat2",316.44202400113028,46.985467062736781,null,3043.9248573049472]
[null,null,null,null,null,null,null,"tapis bain",8310.9377846856933,"Kannegiesser",53,"00:01:40",5,"00:27:00","Plat5",128.32600239659175,29.813361011801284,8310.9377846856933,8363.9377846856933]
[null,null,null,null,null,null,null,"tapis bain luxe",273.48093259259099,"Kannegiesser",53,"00:01:40",5,"00:23:00","Plat5",128.32600239659175,19.372210721454529,null,273.48093259259099]
[null,null,null,null,null,null,null,"torchon",22701.498039430357,"Kannegiesser",53,"00:01:40",1,"00:12:00","Plat2",316.44202400113028,96.967218101448225,null,22701.498039430357]
[null,null,null,null,null,null,null,"VT",44503.524496027465,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat6",59.425663258835094,9.0857142857142872,44503.524496027465,44662.524496027465]
[null,null,null,null,null,null,null,"VT Séché TF",44662.524496027465,"Kannegiesser",53,"00:01:40",0,"00:12:00","Plat6",59.425663258835094,9.0857142857142872,null,44662.524496027465]

{"sheet":"Feuil2","index":2,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,7,7,9],[20,7,27,12]]}
["C","Plat","Stock ","Kg",null,null,"Familles","Tonnage (kg)","lavage ","Unité de lavage (Kg)","TcycleL","Séchoir","TcycleS","Calandre","TcycleC","TempsTraitement (min)","Affectation de l'unitelavage","Tonnage - unitelavage"]
[1,"Plat2",21,100,null,null,"alése abs PE",970.49648508744758,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat5",128.32600239659175,10.601259211066251]
[2,"Plat2",10,50,null,null,"alése abs PM",2078.2961398818106,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat6",59.425663258835094,15.233893847766728]
[3,"Plat3",5,30,null,null,"Bavoir",2107.7192894078671,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat5",128.32600239659175,36.129966216151892]
[4,"Plat4",null,null,null,null,"chmal PE",1567.7250912951076,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat5",128.32600239659175,17.870051561374904]
[5,"Plat5",null,null,null,null,"chmal PM",4991.7814878393356,"Kannegiesser",53,"00:01:40",2,"00:23:00","Plat6",59.425663258835094,25.679069167173306]
[6,"Plat6",null,null,null,null,"chp grd",52.202181225934488,"Kannegiesser",53,"00:01:40",0,"00:00:00","Plat4",122.75658904999779,42.679907289904499]
[null,"I want to do a  randomly search for those strings of characters",null,null,null,null,null,"I want once my research points to a value of N column that my macro calculation H-J and me instead in Q",null,null,null,null,null,"in this columns",null,null,"Q=H-J"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Note to every random search loop must check what is my place in résulat Q if its > than the  value set in J whether we start calculating Q if not we  must lancer a new random serch where the  Q cells  has a value > than  J  value and if all the Q value is lower than j value loop is finished"]