{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Accueil","Donnees","Ordonnancement","Ordonna","Usine","Commentaires","Informations"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":18,"comments":1,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"NOW()","v":"2016-08-03T14:16:52.850"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"momo"]

{"sheet":"Donnees","index":1,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Familles","Poids livré\nen kg","équipement de lavage ","Unité de lavage (Kg)","TcycleL","Séchoir",null,"Calandre","TcycleC","TempsTraitement (min)",null,"CodeFamille","PourCent\nPoids","Code à 2 chiffres","PourCent\ncumulés",{"$f":"L1","v":"CodeFamille"},{"$f":"C1","v":"équipement de lavage "},{"$f":"D1","v":"Unité de lavage (Kg)"},{"$f":"H1","v":"Calandre"},"Temps total",null,"TcycleC",null,"Total Poids livré"]
["alése abs",1607.9333333333332,2,{"$f":"IF(C2=2,50)","v":50},"00:03:00",2,null,"Plat5","02:08:19.560",10.601259211066251,null,"alése abs - 01",{"$f":"B2/$X$2","v":1.0048088261534084E-2},"01",0,{"$f":"L2","v":"alése abs - 01"},{"$f":"C2","v":2},{"$f":"D2","v":50},"Plat5",{"$f":"E2+G2+I2","v":"02:11:19.560"},null,128.32600239659175,{"$f":"V2/24/60","v":8.9115279442077602E-2},{"$f":"SUM(B2:B52)","v":160023.80666666667}]
["Bavoir",494.08333333333337,2,{"$f":"IF(C3=2,50)","v":50},"00:03:00",2,null,"Plat5","00:59:25.540",15.233893847766728,null,"Bavoir - 02",{"$f":"B3/$X$2","v":3.0875614299222397E-3},"02",{"$f":"O2+M2","v":1.0048088261534084E-2},"Bavoir - 02",{"$f":"C3","v":2},50,"Plat5",{"$f":"E3+G3+I3","v":"01:02:25.540"},null,59.425663258835094,{"$f":"V3/24/60","v":4.1267821707524376E-2}]
["carré/gant",953.04500000000007,4,{"$f":"IF(C4=4,100)","v":100},"01:12:03.140",2,null,"Plat6","02:08:19.560",36.129966216151892,null,"carré/gant - 03",5.9556450996395499E-3,"03",1.3135649691456324E-2,"carré/gant - 03",4,100,"Plat6","03:20:22.700",null,128.32600239659175,8.9115279442077602E-2]
["ch tab",95.147999999999982,5,{"$f":"IF(C5=5,100)","v":100},"01:06:21.565",0,null,"Plat4","02:08:19.560",17.870051561374904,null,"ch tab - 04",5.9458653047915228E-4,"04",1.9091294791095875E-2,"ch tab - 04",5,100,"Plat4","03:14:41.125",null,128.32600239659175,8.9115279442077602E-2]
["chmal",1929.3690000000001,2,{"$f":"IF(C6=2,50)","v":50},"00:03:00",2,null,"Plat5","00:59:25.540",25.679069167173306,null,"chmal - 05",1.2056762304242149E-2,"05",1.9685881321575026E-2,"chmal - 05",2,50,"Plat5","01:02:25.540",null,59.425663258835094,4.1267821707524376E-2]
["chp grd",26.667000000000002,2,{"$f":"IF(C7=2,50)","v":50},"00:03:00",0,null,"Plat4","02:02:45.395",42.679907289904499,null,"chp grd - 06",1.6664395476823012E-4,"06",3.1742643625817177E-2,"chp grd - 06",2,50,"Plat4","02:05:45.395",null,122.75658904999779,8.5247631284720696E-2]
["chp petit",50.195999999999998,2,{"$f":"IF(C8=2,50)","v":50},"00:03:00",0,null,"Plat4","02:02:45.395",71.076447353771258,null,"chp petit - 07",3.1367832727888695E-4,"07",3.1909287580585408E-2,"chp petit - 07",2,50,"Plat4","02:05:45.395",null,122.75658904999779,8.5247631284720696E-2]
["couche",28.434999999999999,4,{"$f":"IF(C9=4,100)","v":100},"01:12:03.140",0,null,"Plat2","02:02:45.395",29.04442177752874,null,"couche - 08",1.7769231086491255E-4,"08",3.2222965907864297E-2,"couche - 08",4,100,"Plat2","03:14:48.535",null,122.75658904999779,8.5247631284720696E-2]
["couette/couv",3873.5363333333335,4,{"$f":"IF(C10=4,100)","v":100},"01:12:03.140",3,null,"Plat6","02:02:45.395",27.924067203740442,null,"couette/couv - 09",2.4206000432185695E-2,"09",3.2400658218729207E-2,"couette/couv - 09",4,100,"Plat6","03:14:48.535",null,122.75658904999779,8.5247631284720696E-2]
["des lit",646.65266666666662,4,{"$f":"IF(C11=4,100)","v":100},"01:12:03.140",0,null,"Plat4","02:08:19.560",15.541683995727912,null,"des lit - 10",4.0409779028295414E-3,"10",5.6606658650914903E-2,"des lit - 10",4,100,"Plat4","03:20:22.700",null,128.32600239659175,8.9115279442077602E-2]
["drap 1/2",555.42666666666673,2,{"$f":"IF(C12=2,50)","v":50},"00:03:00",0,null,"Plat4","02:08:19.560",7.8190687871465983,null,"drap 1/2 - 11",3.4709002256372609E-3,"11",6.0647636553744444E-2,"drap 1/2 - 11",2,50,"Plat4","02:11:19.560",null,128.32600239659175,8.9115279442077602E-2]
["Drap ambulatoire",1018.6213333333334,2,{"$f":"IF(C13=2,50)","v":50},"00:03:00",0,null,"Plat4","02:08:19.560",7.1849364634392963,null,"Drap ambulatoire - 12",6.365436209470666E-3,"12",6.4118536779381702E-2,"Drap ambulatoire - 12",2,50,"Plat4","02:11:19.560",null,128.32600239659175,8.9115279442077602E-2]
["drap bain",9110.1656666666677,1,{"$f":"IF(C14=1,50)","v":50},"00:01:35",5,null,"Plat5","00:12:58.109",10.593184578638812,null,"drap bain - 13",5.6930064697456893E-2,"13",7.0483972988852367E-2,"drap bain - 13",1,50,"Plat5","00:14:33.109",null,12.968484605365797,9.0058920870595797E-3]
["drap bain luxe",1078.4446666666665,1,50,"00:01:35",5,null,"Plat5","02:02:45.395",15.475941817308406,null,"drap bain luxe - 14",6.7392764184962305E-3,"14",0.12741403768630927,"drap bain luxe - 14",1,50,"Plat5","02:04:20.395",null,122.75658904999779,8.5247631284720696E-2]
["drap bain spa",362.56,1,50,"00:01:35",5,null,"Plat5","00:59:25.540",15.330223780685532,null,"drap bain spa - 15",2.2656628882427535E-3,"15",0.13415331410480549,"drap bain spa - 15",1,50,"Plat5","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["drap grand",15308.128333333334,1,50,"00:01:35",0,null,"Plat3","00:12:58.109",10.378328137146351,null,"drap grand - 16",9.5661568439129332E-2,"16",0.13641897699304825,"drap grand - 16",1,50,"Plat3","00:14:33.109",null,12.968484605365797,9.0058920870595797E-3]
["drap housse",9131.2170000000006,1,50,"00:01:35",2,null,"Plat6","00:12:58.109",15.09615011101668,null,"drap housse - 17",5.706161595705906E-2,"17",0.2320805454321776,"drap housse - 17",1,50,"Plat6","00:14:33.109",null,12.968484605365797,9.0058920870595797E-3]
["drap luxe",18.516666666666666,1,50,"00:01:35",0,null,"Plat3","02:02:45.395",20.893714617733611,null,"drap luxe - 18",1.1571194969281861E-4,"18",0.28914216138923665,"drap luxe - 18",1,50,"Plat3","02:04:20.395",null,122.75658904999779,8.5247631284720696E-2]
["drap petit",51798.104666666659,1,50,"00:01:35",0,null,"Plat3","02:02:45.395",25.943672557999921,null,"drap petit - 19",0.32368999179330438,"19",0.28925787333892949,"drap petit - 19",1,50,"Plat3","02:04:20.395",null,122.75658904999779,8.5247631284720696E-2]
["franges",3041.5460000000003,4,{"$f":"IF(C21=4,100)","v":100},"01:12:03.140",3,null,"Plat6","02:02:45.395",66.424402609903183,null,"franges - 20",1.9006834441425403E-2,"20",0.61294786513223387,"franges - 20",4,100,"Plat6","03:14:48.535",null,122.75658904999779,8.5247631284720696E-2]
["grde al",413.01799999999992,1,{"$f":"IF(C22=1,50)","v":50},"00:01:35",0,null,"Plat4","00:12:58.109",5.8280417572905003,null,"grde al - 21",2.5809784719115327E-3,"21",0.63195469957365924,"grde al - 21",1,50,"Plat4","00:14:33.109",null,12.968484605365797,9.0058920870595797E-3]
["hous trav",1010.9209999999999,1,{"$f":"IF(C23=1,50)","v":50},"00:01:35",0,null,"Plat4","02:02:45.395",11.494417617421783,null,"hous trav - 22",6.317316285980948E-3,"22",0.63453567804557076,"hous trav - 22",1,50,"Plat4","02:04:20.395",null,122.75658904999779,8.5247631284720696E-2]
["housse couette",15856.307333333336,1,{"$f":"IF(C24=1,50)","v":50},"00:01:35",0,null,"Plat3","00:12:58.109",9.2843848460547385,null,"housse couette - 23",9.9087177487049746E-2,"23",0.64085299433155174,"housse couette - 23",1,50,"Plat3","00:14:33.109",null,12.968484605365797,9.0058920870595797E-3]
["nap .30",39.099666666666657,5,{"$f":"IF(C25=5,100)","v":100},"01:06:21.565",0,null,"Plat4","02:02:45.395",15.922806259762748,null,"nap .30 - 24",2.4433656142246494E-4,"24",0.7399401718186015,"nap .30 - 24",5,100,"Plat4","03:09:06.960",null,122.75658904999779,8.5247631284720696E-2]
["nap 12",315.1183333333334,5,100,"01:06:21.565",0,null,"Plat4","02:02:45.395",28.651055195893566,null,"nap 12 - 25",1.9691965832917113E-3,"25",0.74018450838002392,"nap 12 - 25",5,100,"Plat4","03:09:06.960",null,122.75658904999779,8.5247631284720696E-2]
["nap 15 + 18",1164.675666666667,5,100,"01:06:21.565",0,null,"Plat4","02:08:19.560",32.930319438813818,null,"nap 15 + 18 - 26",7.2781399900873102E-3,"26",0.74215370496331567,"nap 15 + 18 - 26",5,100,"Plat4","03:14:41.125",null,128.32600239659175,8.9115279442077602E-2]
["nap 20",441.90366666666671,5,100,"01:06:21.565",0,null,"Plat4","02:08:19.560",20.079858026190493,null,"nap 20 - 27",2.761487030408934E-3,"27",0.74943184495340298,"nap 20 - 27",5,100,"Plat4","03:14:41.125",null,128.32600239659175,8.9115279442077602E-2]
["nap 24",148.86666666666665,5,100,"01:06:21.565",0,null,"Plat4","05:16:26.521",60.233571385417278,null,"nap 24 - 28",9.3027824901553171E-4,"28",0.75219333198381189,"nap 24 - 28",5,100,"Plat4","06:22:48.086",null,316.44202400113028,0.21975140555634048]
["npr",57.142666666666663,5,100,"01:06:21.565",0,null,"Plat4","05:16:26.521",22.611992644203188,null,"npr - 29",3.5708853486841603E-4,"29",0.75312361023282737,"npr - 29",5,100,"Plat4","06:22:48.086",null,316.44202400113028,0.21975140555634048]
["npr 10",47.757666666666665,5,100,"01:06:21.565",0,null,"Plat4","05:16:26.521",26.522225855348644,null,"npr 10 - 30",2.9844101113121876E-4,"30",0.75348069876769574,"npr 10 - 30",5,100,"Plat4","06:22:48.086",null,316.44202400113028,0.21975140555634048]
["peignoir/cas",465.88699999999994,4,{"$f":"IF(C32=4,100)","v":100},"01:12:03.140",2,null,"Plat6","05:16:26.521",23.798005043284753,null,"peignoir/cas - 31",2.9113605638094427E-3,"31",0.75377913977882693,"peignoir/cas - 31",4,100,"Plat6","06:28:29.661",null,316.44202400113028,0.21975140555634048]
["petite housse",6854.1320000000005,1,{"$f":"IF(C33=1,50)","v":50},"00:01:35",0,null,"Plat3","05:16:26.521",62.81166285671268,null,"petite housse - 32",4.2831951962480921E-2,"32",0.75669050034263641,"petite housse - 32",1,50,"Plat3","05:18:01.521",null,316.44202400113028,0.21975140555634048]
["Protège matelas",14.94,4,{"$f":"IF(C34=4,100)","v":100},"01:12:03.140",2,null,"Plat6","05:16:26.521",45.167626102291202,null,"Protège matelas - 33",9.3361108645042848E-5,"33",0.79952245230511731,{"$f":"L34","v":"Protège matelas - 33"},4,100,{"$f":"H34","v":"Plat6"},"06:28:29.661",null,316.44202400113028,0.21975140555634048]
["pte al",3283.2126666666663,2,{"$f":"IF(C35=2,50)","v":50},"00:03:00",0,null,"Plat4","05:16:26.521",46.985467062736781,null,"pte al - 34",2.0517026404112952E-2,"34",{"$f":"O34+M34","v":0.79961581341376231},"pte al - 34",2,50,"Plat4","05:19:26.521",null,316.44202400113028,0.21975140555634048]
["sac",4140.0693333333338,5,{"$f":"IF(C36=5,100)","v":100},"01:06:21.565",0,null,"Plat6","02:08:19.560",29.813361011801284,null,"sac - 35",2.5871583857251908E-2,"35",0.82013283981787521,"sac - 35",5,100,"Plat6","03:14:41.125",null,128.32600239659175,8.9115279442077602E-2]
["serv épges coiffeur",50.443333333333328,4,{"$f":"IF(C37=4,100)","v":100},"01:12:03.140",3,null,"Plat5","02:08:19.560",19.372210721454529,null,"serv épges coiffeur - 36",3.1522393063932027E-4,"36",0.84600442367512707,"serv épges coiffeur - 36",4,100,"Plat5","03:20:22.700",null,128.32600239659175,8.9115279442077602E-2]
["serv éponge",7880.5370000000012,1,{"$f":"IF(C38=1,50)","v":50},"00:01:35",5,null,"Plat5","05:16:26.521",96.967218101448225,null,"serv éponge - 37",4.9246028851290508E-2,"37",0.84631964760576639,"serv éponge - 37",1,50,"Plat5","05:18:01.521",null,316.44202400113028,0.21975140555634048]
["serv éponge luxe",157.33499999999998,1,{"$f":"IF(C39=1,50)","v":50},"00:01:35",5,null,"Plat5","00:59:25.540",9.0857142857142872,null,"serv éponge luxe - 38",9.8319745841150027E-4,"38",0.89556567645705687,"serv éponge luxe - 38",1,50,"Plat5","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["serv œil",41.615000000000002,1,{"$f":"IF(C40=1,50)","v":50},"00:01:35",0,null,"Plat2","00:59:25.540",9.0857142857142872,null,"serv œil - 39",2.6005505597479644E-4,"39",0.89654887391546834,"serv œil - 39",1,50,"Plat2","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["serv tab gde",17.18933333333333,5,{"$f":"IF(C41=5,100)","v":100},"01:06:21.565",0,null,"Plat2","00:59:25.540",9.0857142857142872,null,"serv tab gde - 40",1.0741735052671953E-4,"40",0.89680892897144315,"serv tab gde - 40",5,100,"Plat2","02:05:47.105",null,59.425663258835101,4.1267821707524376E-2]
["serv tab gde prestige",1.1200000000000001,5,{"$f":"IF(C42=5,100)","v":100},"01:06:21.565",0,null,"Plat2","00:59:25.540",9.0857142857142872,null,"serv tab gde prestige - 41",6.9989586132829987E-6,"41",0.89691634632196993,"serv tab gde prestige - 41",5,100,"Plat2","02:05:47.105",null,59.425663258835094,4.1267821707524376E-2]
["serv tab pte",2263.3356666666668,5,{"$f":"IF(C43=5,100)","v":100},"01:06:21.565",0,null,"Plat2","00:59:25.540",9.0857142857142872,null,"serv tab pte - 42",1.4143743445506505E-2,"42",0.89692334528058326,"serv tab pte - 42",5,100,"Plat2","02:05:47.105",null,59.425663258835094,4.1267821707524376E-2]
["tablier blanc",2136.4740000000002,1,{"$f":"IF(C44=1,50)","v":50},"00:01:35",2,null,"Plat2","00:59:25.540",9.0857142857142872,null,"tablier blanc - 43",1.3350975986031412E-2,"43",0.91106708872608977,"tablier blanc - 43",1,50,"Plat2","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["tablier bleu",100.10833333333333,1,50,"00:01:35",2,null,"Plat2","00:59:25.540",9.0857142857142872,null,"tablier bleu - 44",6.2558400164708827E-4,"44",0.92441806471212118,"tablier bleu - 44",1,50,"Plat2","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["tablier bret",518.81566666666663,1,50,"00:01:35",2,null,"Plat2","00:59:25.540",9.0857142857142872,null,"tablier bret - 45",3.2421155168953818E-3,"45",0.92504364871376832,"tablier bret - 45",1,50,"Plat2","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["taie am",1981.8120000000004,1,50,"00:01:35",1,null,"Plat2","00:59:25.540",9.0857142857142872,null,"taie am - 46",1.2384482292238937E-2,"46",0.92828576423066367,"taie am - 46",1,50,"Plat2","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["Taie Carrée",5100.9216666666671,1,50,"00:01:35",1,null,"Plat2","00:59:25.540",9.0857142857142872,null,"Taie Carrée - 47",3.1876017530891552E-2,"47",0.94067024652290265,"Taie Carrée - 47",1,50,"Plat2","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["taie luxe",411.30033333333336,1,50,"00:01:35",1,null,"Plat2","00:59:25.540",9.0857142857142872,null,"taie luxe - 48",2.5702446523477693E-3,"48",0.97254626405379418,"taie luxe - 48",1,50,"Plat2","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["tapis bain",2376.0460000000003,1,50,"00:01:35",5,null,"Plat5","00:59:25.540",9.0857142857142872,null,"tapis bain - 49",1.4848078229693409E-2,"49",0.97511650870614197,"tapis bain - 49",1,50,"Plat5","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["tapis bain luxe",119.56466666666668,1,50,"00:01:35",5,null,"Plat5","00:59:25.540",9.0857142857142872,null,"tapis bain luxe - 50",7.4716799429551557E-4,"50",0.98996458693583533,"tapis bain luxe - 50",1,50,"Plat5","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]
["torchon",1486.3403333333333,1,50,"00:01:35",1,null,"Plat2","00:59:25.540",9.0857142857142872,null,"torchon - 51",9.2882450698689792E-3,"51",0.99071175493013086,"torchon - 51",1,50,"Plat2","01:01:00.540",null,59.425663258835094,4.1267821707524376E-2]

{"sheet":"Ordonnancement","index":2,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,8,22,9],[22,10,22,11],[23,8,23,11],[23,13,23,15]]}
["Produit Tunnel","Equipement lavage","Calandre",null,"Produit Laveuse","Equipement lavage","Calandre"]
["serv tab gde - 40",5,"Plat2",null,"couche - 08",4,"Plat2"]
["serv œil - 39",1,"Plat2",null,"couche - 08",4,"Plat2"]
["housse couette - 23",1,"Plat3"]
["grde al - 21",1,"Plat4"]
["serv éponge - 37",1,"Plat5"]
["housse couette - 23",1,"Plat3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Vers tunnels",null,"Vers laveuses",null,null,null,"Vers tunnels"]
[null,null,null,null,null,null,null,null,"Choix familles Aléatoire",null,null,null,null,"Choix familles Imposé"]

{"sheet":"Ordonna","index":3,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,11,0,12],[0,0,0,2],[0,4,0,7]]}
["Données",null,null,null,"Pour tirage au sort",null,null,null,null,null,null,"Sélection"]
["CodeFamille","Calandre","Tonnage (kg)",null,"en %","%\ncumulés","CodeFamille","Calandre",null,null,null,"CodeFamille","Calandre"]
[{"$f":"Donnees!L2","v":"alése abs - 01"},{"$f":"Donnees!S2","v":"Plat5"},{"$f":"Donnees!B2","v":1607.9333333333332},null,{"$f":"C3/$C$54","v":1.0048088261534084E-2},0,{"$f":"A3","v":"alése abs - 01"},{"$f":"B3","v":"Plat5"},null,null,null,"hous trav - 22","Plat5"]
[{"$f":"Donnees!L3","v":"Bavoir - 02"},{"$f":"Donnees!S3","v":"Plat5"},{"$f":"Donnees!B3","v":494.08333333333337},null,{"$f":"C4/$C$54","v":3.0875614299222397E-3},{"$f":"F3+E3","v":1.0048088261534084E-2},{"$f":"A4","v":"Bavoir - 02"},"Plat5",null,null,null,"drap grand - 16","Plat3"]
[{"$f":"Donnees!L4","v":"carré/gant - 03"},{"$f":"Donnees!S4","v":"Plat6"},{"$f":"Donnees!B4","v":953.04500000000007},null,5.9556450996395499E-3,{"$f":"F4+E4","v":1.3135649691456324E-2},"carré/gant - 03","Plat6",null,null,null,"drap 1/2 - 11","Plat4"]
[{"$f":"Donnees!L5","v":"ch tab - 04"},{"$f":"Donnees!S5","v":"Plat4"},{"$f":"Donnees!B5","v":95.147999999999982},null,5.9458653047915228E-4,1.9091294791095875E-2,"ch tab - 04","Plat4",null,null,null,"drap bain luxe - 14","Plat5"]
[{"$f":"Donnees!L6","v":"chmal - 05"},{"$f":"Donnees!S6","v":"Plat5"},{"$f":"Donnees!B6","v":1929.3690000000001},null,1.2056762304242149E-2,1.9685881321575026E-2,"chmal - 05","Plat5"]
[{"$f":"Donnees!L7","v":"chp grd - 06"},{"$f":"Donnees!S7","v":"Plat4"},{"$f":"Donnees!B7","v":26.667000000000002},null,1.6664395476823012E-4,3.1742643625817177E-2,"chp grd - 06","Plat4"]
[{"$f":"Donnees!L8","v":"chp petit - 07"},{"$f":"Donnees!S8","v":"Plat4"},{"$f":"Donnees!B8","v":50.195999999999998},null,3.1367832727888695E-4,3.1909287580585408E-2,"chp petit - 07","Plat4"]
[{"$f":"Donnees!L9","v":"couche - 08"},{"$f":"Donnees!S9","v":"Plat2"},{"$f":"Donnees!B9","v":28.434999999999999},null,1.7769231086491255E-4,3.2222965907864297E-2,"couche - 08","Plat2"]
[{"$f":"Donnees!L10","v":"couette/couv - 09"},{"$f":"Donnees!S10","v":"Plat6"},{"$f":"Donnees!B10","v":3873.5363333333335},null,2.4206000432185695E-2,3.2400658218729207E-2,"couette/couv - 09","Plat6"]
[{"$f":"Donnees!L11","v":"des lit - 10"},{"$f":"Donnees!S11","v":"Plat4"},{"$f":"Donnees!B11","v":646.65266666666662},null,4.0409779028295414E-3,5.6606658650914903E-2,"des lit - 10","Plat4"]
[{"$f":"Donnees!L12","v":"drap 1/2 - 11"},{"$f":"Donnees!S12","v":"Plat4"},{"$f":"Donnees!B12","v":555.42666666666673},null,3.4709002256372609E-3,6.0647636553744444E-2,"drap 1/2 - 11","Plat4"]
[{"$f":"Donnees!L13","v":"Drap ambulatoire - 12"},{"$f":"Donnees!S13","v":"Plat4"},{"$f":"Donnees!B13","v":1018.6213333333334},null,6.365436209470666E-3,6.4118536779381702E-2,"Drap ambulatoire - 12","Plat4"]
[{"$f":"Donnees!L14","v":"drap bain - 13"},{"$f":"Donnees!S14","v":"Plat5"},{"$f":"Donnees!B14","v":9110.1656666666677},null,5.6930064697456893E-2,7.0483972988852367E-2,"drap bain - 13","Plat5"]
[{"$f":"Donnees!L15","v":"drap bain luxe - 14"},{"$f":"Donnees!S15","v":"Plat5"},{"$f":"Donnees!B15","v":1078.4446666666665},null,6.7392764184962305E-3,0.12741403768630927,"drap bain luxe - 14","Plat5"]
[{"$f":"Donnees!L16","v":"drap bain spa - 15"},{"$f":"Donnees!S16","v":"Plat5"},{"$f":"Donnees!B16","v":362.56},null,2.2656628882427535E-3,0.13415331410480549,"drap bain spa - 15","Plat5"]
[{"$f":"Donnees!L17","v":"drap grand - 16"},{"$f":"Donnees!S17","v":"Plat3"},{"$f":"Donnees!B17","v":15308.128333333334},null,9.5661568439129332E-2,0.13641897699304825,"drap grand - 16","Plat3"]
[{"$f":"Donnees!L18","v":"drap housse - 17"},{"$f":"Donnees!S18","v":"Plat6"},{"$f":"Donnees!B18","v":9131.2170000000006},null,5.706161595705906E-2,0.2320805454321776,"drap housse - 17","Plat6"]
[{"$f":"Donnees!L19","v":"drap luxe - 18"},{"$f":"Donnees!S19","v":"Plat3"},{"$f":"Donnees!B19","v":18.516666666666666},null,1.1571194969281861E-4,0.28914216138923665,"drap luxe - 18","Plat3"]
[{"$f":"Donnees!L20","v":"drap petit - 19"},{"$f":"Donnees!S20","v":"Plat3"},{"$f":"Donnees!B20","v":51798.104666666659},null,0.32368999179330438,0.28925787333892949,"drap petit - 19","Plat3"]
[{"$f":"Donnees!L21","v":"franges - 20"},{"$f":"Donnees!S21","v":"Plat6"},{"$f":"Donnees!B21","v":3041.5460000000003},null,1.9006834441425403E-2,0.61294786513223387,"franges - 20","Plat6"]
[{"$f":"Donnees!L22","v":"grde al - 21"},{"$f":"Donnees!S22","v":"Plat4"},{"$f":"Donnees!B22","v":413.01799999999992},null,2.5809784719115327E-3,0.63195469957365924,"grde al - 21","Plat4"]
[{"$f":"Donnees!L23","v":"hous trav - 22"},{"$f":"Donnees!S23","v":"Plat4"},{"$f":"Donnees!B23","v":1010.9209999999999},null,6.317316285980948E-3,0.63453567804557076,"hous trav - 22","Plat4"]
[{"$f":"Donnees!L24","v":"housse couette - 23"},{"$f":"Donnees!S24","v":"Plat3"},{"$f":"Donnees!B24","v":15856.307333333336},null,9.9087177487049746E-2,0.64085299433155174,"housse couette - 23","Plat3"]
[{"$f":"Donnees!L25","v":"nap .30 - 24"},{"$f":"Donnees!S25","v":"Plat4"},{"$f":"Donnees!B25","v":39.099666666666657},null,2.4433656142246494E-4,0.7399401718186015,"nap .30 - 24","Plat4"]
[{"$f":"Donnees!L26","v":"nap 12 - 25"},{"$f":"Donnees!S26","v":"Plat4"},{"$f":"Donnees!B26","v":315.1183333333334},null,{"$f":"C27/$C$54","v":1.9691965832917113E-3},0.74018450838002392,"nap 12 - 25","Plat4"]
[{"$f":"Donnees!L27","v":"nap 15 + 18 - 26"},{"$f":"Donnees!S27","v":"Plat4"},{"$f":"Donnees!B27","v":1164.675666666667},null,7.2781399900873102E-3,0.74215370496331567,"nap 15 + 18 - 26","Plat4"]
[{"$f":"Donnees!L28","v":"nap 20 - 27"},{"$f":"Donnees!S28","v":"Plat4"},{"$f":"Donnees!B28","v":441.90366666666671},null,2.761487030408934E-3,0.74943184495340298,"nap 20 - 27","Plat4"]
[{"$f":"Donnees!L29","v":"nap 24 - 28"},{"$f":"Donnees!S29","v":"Plat4"},{"$f":"Donnees!B29","v":148.86666666666665},null,9.3027824901553171E-4,0.75219333198381189,"nap 24 - 28","Plat4"]
[{"$f":"Donnees!L30","v":"npr - 29"},{"$f":"Donnees!S30","v":"Plat4"},{"$f":"Donnees!B30","v":57.142666666666663},null,3.5708853486841603E-4,0.75312361023282737,"npr - 29","Plat4"]
[{"$f":"Donnees!L31","v":"npr 10 - 30"},{"$f":"Donnees!S31","v":"Plat4"},{"$f":"Donnees!B31","v":47.757666666666665},null,2.9844101113121876E-4,0.75348069876769574,"npr 10 - 30","Plat4"]
[{"$f":"Donnees!L32","v":"peignoir/cas - 31"},{"$f":"Donnees!S32","v":"Plat6"},{"$f":"Donnees!B32","v":465.88699999999994},null,2.9113605638094427E-3,0.75377913977882693,"peignoir/cas - 31","Plat6"]
[{"$f":"Donnees!L33","v":"petite housse - 32"},{"$f":"Donnees!S33","v":"Plat3"},{"$f":"Donnees!B33","v":6854.1320000000005},null,4.2831951962480921E-2,0.75669050034263641,"petite housse - 32","Plat3"]
[{"$f":"Donnees!L34","v":"Protège matelas - 33"},{"$f":"Donnees!S34","v":"Plat6"},{"$f":"Donnees!B34","v":14.94},null,9.3361108645042848E-5,0.79952245230511731,"Protège matelas - 33","Plat6"]
[{"$f":"Donnees!L35","v":"pte al - 34"},{"$f":"Donnees!S35","v":"Plat4"},{"$f":"Donnees!B35","v":3283.2126666666663},null,2.0517026404112952E-2,0.79961581341376231,"pte al - 34","Plat4"]
[{"$f":"Donnees!L36","v":"sac - 35"},{"$f":"Donnees!S36","v":"Plat6"},{"$f":"Donnees!B36","v":4140.0693333333338},null,2.5871583857251908E-2,0.82013283981787521,"sac - 35","Plat6"]
[{"$f":"Donnees!L37","v":"serv épges coiffeur - 36"},{"$f":"Donnees!S37","v":"Plat5"},{"$f":"Donnees!B37","v":50.443333333333328},null,3.1522393063932027E-4,0.84600442367512707,"serv épges coiffeur - 36","Plat5"]
[{"$f":"Donnees!L38","v":"serv éponge - 37"},{"$f":"Donnees!S38","v":"Plat5"},{"$f":"Donnees!B38","v":7880.5370000000012},null,4.9246028851290508E-2,0.84631964760576639,"serv éponge - 37","Plat5"]
[{"$f":"Donnees!L39","v":"serv éponge luxe - 38"},{"$f":"Donnees!S39","v":"Plat5"},{"$f":"Donnees!B39","v":157.33499999999998},null,9.8319745841150027E-4,0.89556567645705687,"serv éponge luxe - 38","Plat5"]
[{"$f":"Donnees!L40","v":"serv œil - 39"},{"$f":"Donnees!S40","v":"Plat2"},{"$f":"Donnees!B40","v":41.615000000000002},null,2.6005505597479644E-4,0.89654887391546834,"serv œil - 39","Plat2"]
[{"$f":"Donnees!L41","v":"serv tab gde - 40"},{"$f":"Donnees!S41","v":"Plat2"},{"$f":"Donnees!B41","v":17.18933333333333},null,1.0741735052671953E-4,0.89680892897144315,"serv tab gde - 40","Plat2"]
[{"$f":"Donnees!L42","v":"serv tab gde prestige - 41"},{"$f":"Donnees!S42","v":"Plat2"},{"$f":"Donnees!B42","v":1.1200000000000001},null,6.9989586132829987E-6,0.89691634632196993,{"$f":"A43","v":"serv tab gde prestige - 41"},"Plat2"]
[{"$f":"Donnees!L43","v":"serv tab pte - 42"},{"$f":"Donnees!S43","v":"Plat2"},{"$f":"Donnees!B43","v":2263.3356666666668},null,1.4143743445506505E-2,0.89692334528058326,"serv tab pte - 42","Plat2"]
[{"$f":"Donnees!L44","v":"tablier blanc - 43"},{"$f":"Donnees!S44","v":"Plat2"},{"$f":"Donnees!B44","v":2136.4740000000002},null,1.3350975986031412E-2,0.91106708872608977,"tablier blanc - 43","Plat2"]
[{"$f":"Donnees!L45","v":"tablier bleu - 44"},{"$f":"Donnees!S45","v":"Plat2"},{"$f":"Donnees!B45","v":100.10833333333333},null,6.2558400164708827E-4,0.92441806471212118,"tablier bleu - 44","Plat2"]
[{"$f":"Donnees!L46","v":"tablier bret - 45"},{"$f":"Donnees!S46","v":"Plat2"},{"$f":"Donnees!B46","v":518.81566666666663},null,3.2421155168953818E-3,0.92504364871376832,"tablier bret - 45","Plat2"]
[{"$f":"Donnees!L47","v":"taie am - 46"},{"$f":"Donnees!S47","v":"Plat2"},{"$f":"Donnees!B47","v":1981.8120000000004},null,1.2384482292238937E-2,0.92828576423066367,"taie am - 46","Plat2"]
[{"$f":"Donnees!L48","v":"Taie Carrée - 47"},{"$f":"Donnees!S48","v":"Plat2"},{"$f":"Donnees!B48","v":5100.9216666666671},null,{"$f":"C49/$C$54","v":3.1876017530891552E-2},0.94067024652290265,"Taie Carrée - 47","Plat2"]
[{"$f":"Donnees!L49","v":"taie luxe - 48"},{"$f":"Donnees!S49","v":"Plat2"},{"$f":"Donnees!B49","v":411.30033333333336},null,2.5702446523477693E-3,0.97254626405379418,"taie luxe - 48","Plat2"]
[{"$f":"Donnees!L50","v":"tapis bain - 49"},{"$f":"Donnees!S50","v":"Plat5"},{"$f":"Donnees!B50","v":2376.0460000000003},null,1.4848078229693409E-2,0.97511650870614197,"tapis bain - 49","Plat5"]
[{"$f":"Donnees!L51","v":"tapis bain luxe - 50"},{"$f":"Donnees!S51","v":"Plat5"},{"$f":"Donnees!B51","v":119.56466666666668},null,7.4716799429551557E-4,0.98996458693583533,"tapis bain luxe - 50","Plat5"]
[{"$f":"Donnees!L52","v":"torchon - 51"},{"$f":"Donnees!S52","v":"Plat2"},{"$f":"Donnees!B52","v":1486.3403333333333},null,9.2882450698689792E-3,0.99071175493013086,"torchon - 51","Plat2"]
[null,null,{"$f":"SUM(C3:C53)","v":160023.80666666667},null,null,0.99999999999999989]
[null,null,null,null,null,null,null,null,null,null,"drap petit - 19"]

{"sheet":"Usine","index":4,"n_rows":50,"n_cols":47,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,28,0,32],[0,36,0,40],[18,15,18,17],[0,20,0,24],[1,0,1,4],[1,6,1,10]],"read":"row_number_cap"}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipements de lavage",null,null,null,null,"Lavage",null,null,"Approvisionnement",null,null,null,null,"Séchoir",null,null,"Approvisionnement",null,null,null,null,"Calandre",null,"Sortie ","Heure de Sortie ","Commentaire calandre ","Durée"]
["Vers tunnel",null,null,null,null,null,"Vers laveuses",null,null,null,null,null,null,"Unité lavage",50,null,null,null,null,null,"n°","Modèle",null,null,null,null,null,null,"n°","Modèle",null,null,null,null,null,null,"n°","Modèle",null,null,null,null,null,null,null,null,{"$f":"SUM(SUMIF($A$3:$A$40,AR2,$D$3:$D$40),SUMIF($G$3:$G$40,AR2,$J$3:$J$40))","v":0}]
["Produit Tunnel","Calandre","Entrée","Durée","Sortie",null,"Produit Laveuses","Calandre","Entrée","Durée","Sortie",null,null,"Tonnage semaine",1000,null,null,null,null,"Machine",1,1,"Tunnel",null,null,null,null,"Machine",1,0,null,null,null,null,null,"Machine",1,"Plat1",null,null,null,null,null,null,null,null,{"$f":"SUM(SUMIF($A$3:$A$40,AR3,$D$3:$D$40),SUMIF($G$3:$G$40,AR3,$J$3:$J$40))","v":0}]
[null,null,null,{"$f":"IF(C4=\"\",\"\",VLOOKUP(A4,Donnees!$P$2:$U$40,5))","v":""},{"$f":"IF(C4=\"\",\"\",C4+D4)","v":""},null,null,null,null,{"$f":"IF(I4=\"\",\"\",VLOOKUP(G4,Donnees!$P$2:$U$40,5))","v":""},{"$f":"IF(I4=\"\",\"\",I4+J4)","v":""},null,null,"Débit total",{"$f":"(SUM(AP3,AP9,AP15,AP21,AP27,AP33)/SUM(AU2:AU45))","v":{"$error":"#DIV/0!"}},null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C5=\"\",\"\",VLOOKUP(A5,Donnees!$P$2:$U$40,5))","v":""},{"$f":"IF(C5=\"\",\"\",C5+D5)","v":""},null,null,null,null,{"$f":"IF(I5=\"\",\"\",VLOOKUP(G5,Donnees!$P$2:$U$40,5))","v":""},{"$f":"IF(I5=\"\",\"\",I5+J5)","v":""},null,null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C6=\"\",\"\",VLOOKUP(A6,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I6=\"\",\"\",VLOOKUP(G6,Donnees!$P$2:$U$40,5))","v":""},"",null,null,"Heure départ",0.25,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C7=\"\",\"\",VLOOKUP(A7,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I7=\"\",\"\",VLOOKUP(G7,Donnees!$P$2:$U$40,5))","v":""},"",null,null,"Heure fin",1.25,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C8=\"\",\"\",VLOOKUP(A8,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I8=\"\",\"\",VLOOKUP(G8,Donnees!$P$2:$U$40,5))","v":""},"",null,null,"Heure simulée",null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C9=\"\",\"\",VLOOKUP(A9,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I9=\"\",\"\",VLOOKUP(G9,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Machine",2,2,"Tunnel",null,null,null,null,"Machine",2,1,null,null,null,null,null,"Machine",2,"Plat2",null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(A10,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I10=\"\",\"\",VLOOKUP(G10,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(A11,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I11=\"\",\"\",VLOOKUP(G11,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(A12,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I12=\"\",\"\",VLOOKUP(G12,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(A13,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I13=\"\",\"\",VLOOKUP(G13,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(A14,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I14=\"\",\"\",VLOOKUP(G14,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(A15,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I15=\"\",\"\",VLOOKUP(G15,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Machine",3,4,"Laveuse",null,null,null,null,"Machine",3,2,null,null,null,null,null,"Machine",3,"Plat3",null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(A16,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I16=\"\",\"\",VLOOKUP(G16,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(A17,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I17=\"\",\"\",VLOOKUP(G17,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(A18,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I18=\"\",\"\",VLOOKUP(G18,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(A19,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I19=\"\",\"\",VLOOKUP(G19,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(A20,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I20=\"\",\"\",VLOOKUP(G20,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(A21,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I21=\"\",\"\",VLOOKUP(G21,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Machine",4,4,"Laveuse",null,null,null,null,"Machine",4,3,null,null,null,null,null,"Machine",4,"Plat4",null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(A22,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I22=\"\",\"\",VLOOKUP(G22,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(A23,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I23=\"\",\"\",VLOOKUP(G23,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(A24,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I24=\"\",\"\",VLOOKUP(G24,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(A25,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I25=\"\",\"\",VLOOKUP(G25,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(A26,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I26=\"\",\"\",VLOOKUP(G26,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(A27,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I27=\"\",\"\",VLOOKUP(G27,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Machine",5,4,"Laveuse",null,null,null,null,"Machine",5,4,null,null,null,null,null,"Machine",5,"Plat5",null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C28=\"\",\"\",VLOOKUP(A28,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I28=\"\",\"\",VLOOKUP(G28,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C29=\"\",\"\",VLOOKUP(A29,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I29=\"\",\"\",VLOOKUP(G29,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C30=\"\",\"\",VLOOKUP(A30,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I30=\"\",\"\",VLOOKUP(G30,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C31=\"\",\"\",VLOOKUP(A31,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I31=\"\",\"\",VLOOKUP(G31,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C32=\"\",\"\",VLOOKUP(A32,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I32=\"\",\"\",VLOOKUP(G32,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C33=\"\",\"\",VLOOKUP(A33,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I33=\"\",\"\",VLOOKUP(G33,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Machine",6,5,"Laveuse",null,null,null,null,"Machine",6,5,null,null,null,null,null,"Machine",2,"Plat6",null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C34=\"\",\"\",VLOOKUP(A34,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I34=\"\",\"\",VLOOKUP(G34,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,"Produit",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C35=\"\",\"\",VLOOKUP(A35,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I35=\"\",\"\",VLOOKUP(G35,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,"Quantité",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C36=\"\",\"\",VLOOKUP(A36,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I36=\"\",\"\",VLOOKUP(G36,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,"Heure entrée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C37=\"\",\"\",VLOOKUP(A37,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I37=\"\",\"\",VLOOKUP(G37,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,"Durée",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I38=\"\",\"\",VLOOKUP(G38,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,"Heure sortie",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C39=\"\",\"\",VLOOKUP(A39,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I39=\"\",\"\",VLOOKUP(G39,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Machine",7,5,"Laveuse"]
[null,null,null,{"$f":"IF(C40=\"\",\"\",VLOOKUP(A40,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,{"$f":"IF(I40=\"\",\"\",VLOOKUP(G40,Donnees!$P$2:$U$40,5))","v":""},"",null,null,null,null,null,null,null,null,"Produit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quantité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heure entrée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Durée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heure sortie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machine",8,5,"Laveuse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Produit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quantité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heure entrée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Durée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heure sortie"]

{"sheet":"Commentaires","index":5,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["N°","Commentaires"]
[1,"ELIS"]
[2,"momo"]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]

{"sheet":"Informations","index":6,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[10,2,11,6],[10,7,11,7]]}
["Ceci est un \"poste de travail\"",null,null,null,null,null,null,null,null,"le poste de travail est un \"modèle\" applicable aux séchoirs et aux calendreuses"]
[]
[null,null,null,null,null,null,null,null,null,"Qmin, Qmax non utilisés. Il pourrait être envisagé que la machine n'accepte que des quantités minimales et maximales, le produit restant en attente si quantité insuffisante"]
[null,null,"n°","Modèle","Qmin","Qmax",null,"Tot",null,"Chaque machine a un n° particulier, mais plusieurs machines peuvent être du même \"Modèle\". Chaque produit est travaillé par un modèle particulier (non prévu: produit pouvant être traité par plusieurs modèles différents)"]
[null,"Machine",1,0,null,null,null,null,null,"description de la machine - dernière colonne = la machine elle-même, les 5 colonnes qui précèdent = Approvisionnement = file d'attente avant d'entrer dans la machine"]
[null,"Produit",null,null,null,null,null,null,null,"indique le code du produit à travailler"]
[null,"Quantité",null,null,null,null,null,null,null,"indique la quantité de ce produit"]
[null,"Heure entrée",null,null,null,null,null,null,null,"heure d'entrée du produit au point indiqué"]
[null,"Durée",null,null,null,null,null,null,null,"durée du traitement",null,null,null,"est une fonction du produit"]
[null,"Heure sortie",null,null,null,null,null,null,null,"heure de sortie (= heure d'entrée + durée)"]
[null,null,"file d'attente",null,null,null,null,"machine"]
[]
[]
[null,null,"la file d'attente ne correspond pas nécessairement à une réalité physique"]
[null,null,"mais elle permet dans la simulation de localiser les points à problème: là où \"ça n'avance pas\""]
[]
[]
[null,"Simulation:"]
[null,"se fait en partant des sorties vers l'entrée"]
[null,"1) sur chaque machine pour faire \"sortir\" les produits + poussée de la file"]
[null,"quand un produit a été traité (heure sortie atteinte), "]
[null,null,"ce produit est \"sorti\" de la machine (cellule à droite de la machine)"]
[null,null,"les produits en file d'attente (approvisionnement) sont décalés versla droite: un nouveau produit entre donc dans la machine (s'il y en avait dans la file)"]
[null,"2) sur chaque produit \"sorti\", déterminer son poste de travail suivant"]
[null,null,"cela peut être directement en machine ou dans la file d'approvisionnement de la machine"]
[null,null,"après la dernière machine (calandreuse), le produit est enregistré en Sortie finale"]
[]
[null,"Certains produits ne doivent pas passer au séchage, ou à la calendreuse."]
[null,"Ces produits vont alors \"sauter\" ce poste, et être placés en \"sortie\" du poste (après la dernière machine de ce poste)"]
[null,"Vu ces sauts, il faut reprendre la partie (2) jusqu'au moment où il n'y a plus de produit en restant en sortie"]
[]
[]
[]
[]
[null," Indispensable de laisser la colonne K:K de la feuille donnés vide pour éviter que un tri ou un filtre dans la plage A:J ne vienne modifier les formules se trouvant dans les colonnes suivantes."]