{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Accueil","Donnees","Ordonnancement","Ordonna","Usine","Commentaires","Informations"],"not_rendered":{"charts":1,"images":6,"macros":1,"external_links":1,"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":[[0,0,1,0]]}
[{"$f":"NOW()","v":"2016-08-10T09:53:47.170"}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Roanne"]
[]
[]
[]
[]
[]
[]
[null,null,null,"momo"]

{"sheet":"Donnees","index":1,"n_rows":61,"n_cols":24,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Familles","Poids livré\nen kg","équipement de lavage ","Unité de lavage (Kg)","TcycleL","Séchoir","TcycleS","Calandre","TcycleC",null,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é"]
["Blanchissage plat1",20.953448275862069,1,50,"00:01:47",5,"00:13:00","plat6",3.6711416617612609,null,null,{"$f":"CONCATENATE(A2, \" - \",N2)","v":"Blanchissage plat1 - 01"},{"$f":"B2/$X$2","v":2.9819698277022428E-3},"01",0,{"$f":"L2","v":"Blanchissage plat1 - 01"},{"$f":"C2","v":1},{"$f":"D2","v":50},"plat6",{"$f":"E2+G2+I2","v":3.6814078654649647},null,128.32600239659175,{"$f":"V2/24/60","v":8.9115279442077602E-2},{"$f":"SUM(B2:B100)","v":7026.7137115896812}]
["Blanchissage plat6",48.6,4,540,"00:00:00",5,"00:13:00","plat3",7.3260073260073284,null,null,{"$f":"CONCATENATE(A3, \" - \",N3)","v":"Blanchissage plat6 - 02"},{"$f":"B3/$X$2","v":6.9164622318169033E-3},"02",{"$f":"O2+M2","v":2.9819698277022428E-3},"Blanchissage plat6 - 02",{"$f":"C3","v":4},540,"plat3",{"$f":"E3+G3+I3","v":7.3350351037851063},null,59.425663258835094,{"$f":"V3/24/60","v":4.1267821707524376E-2}]
["alése abs",28.309141694652538,1,50,"00:01:47",6,"00:20:00","plat6","12:06:40.252",null,null,"alése abs - 03",4.0287882581526218E-3,"03",9.8984320595191452E-3,"alése abs - 03",1,50,"plat6","12:28:27.252",null,128.32600239659175,8.9115279442077602E-2]
["carré/gant",2.319337700514589,1,50,"00:01:47",6,"00:20:00","plat6",2.1557878349886934,null,null,"carré/gant - 04",3.3007431293082754E-4,"04",1.3927220317671768E-2,"carré/gant - 04",1,50,"plat6",2.1709151498035082,null,128.32600239659175,8.9115279442077602E-2]
["ch tab",6.8697528894561444,1,50,"00:01:47",1,"00:02:27","plat3","11:52:58.475",null,null,"ch tab - 05",9.7766227164276668E-4,"05",1.4257294630602595E-2,"ch tab - 05",1,50,"plat3","11:57:12.475",null,59.425663258835094,4.1267821707524376E-2]
["chmal",12.500000000000004,1,50,"00:01:47",6,"00:20:00","plat6",3.0769230769230762,null,null,"chmal - 06",1.7789254711463233E-3,"06",1.5234956902245361E-2,"chmal - 06",1,50,"plat6",3.092050391737891,null,122.75658904999779,8.5247631284720696E-2]
["couette/couv",64.551515151515147,1,50,"00:01:47",6,"00:20:00","plat6","14:52:18.635",null,null,"couette/couv - 07",9.1865867603294453E-3,"07",1.7013882373391683E-2,"couette/couv - 07",1,50,"plat6","15:14:05.635",null,122.75658904999779,8.5247631284720696E-2]
["drap petit",46.1271992793286,1,50,"00:01:47",2,"00:02:30","plat1","02:01:42.462",null,null,"drap petit - 08",6.5645479768511959E-3,"08",2.6200469133721128E-2,"drap petit - 08",1,50,"plat1","02:05:59.462",null,122.75658904999779,8.5247631284720696E-2]
["drap grand",61.197316254440814,1,50,"00:01:47",2,"00:02:30","plat1","01:44:34.785",null,null,"drap grand - 09",8.7092371720657313E-3,"09",3.2765017110572323E-2,"drap grand - 09",1,50,"plat1","01:48:51.785",null,122.75658904999779,8.5247631284720696E-2]
["drap bain",21.601842470896688,1,50,"00:01:47",3,"00:22:00","plat4","04:00:28.784",null,null,"drap bain - 10",3.074245423613483E-3,"10",4.1474254282638054E-2,"drap bain - 10",1,50,"plat4","04:24:15.784",null,128.32600239659175,8.9115279442077602E-2]
["drap bain luxe",29.862010627316515,1,50,"00:01:47",3,"00:22:00","plat4","03:08:39.672",null,null,"drap bain luxe - 11",4.2497833059660425E-3,"11",4.4548499706251535E-2,"drap bain luxe - 11",1,50,"plat4","03:32:26.672",null,128.32600239659175,8.9115279442077602E-2]
["drap housse",29.794174323601368,1,50,"00:01:47",6,"00:20:00","plat6","10:35:56.523",null,null,"drap housse - 12",4.2401292476822589E-3,"12",4.8798283012217579E-2,"drap housse - 12",1,50,"plat6","10:57:43.523",null,128.32600239659175,8.9115279442077602E-2]
["drap luxe",57.892990358677842,1,50,"00:01:47",2,"00:02:30","plat1","01:50:32.927",null,null,"drap luxe - 13",8.2389852119904398E-3,"13",5.3038412259899838E-2,"drap luxe - 13",1,50,"plat1","01:54:49.927",null,12.968484605365797,9.0058920870595797E-3]
["grde al",25.482406885598653,1,50,"00:01:47",2,"00:02:30","plat1","03:04:40.309",null,null,"grde al - 14",3.6265042139924709E-3,"14",6.1277397471890274E-2,"grde al - 14",1,50,"plat1","03:08:57.309",null,122.75658904999779,8.5247631284720696E-2]
["nap .30",607.62571061093252,4,540,"00:00:00",1,"00:02:27","plat2",2.0640890049337739,null,null,"nap .30 - 15",8.6473668282333785E-2,"15",6.4903901685882739E-2,"nap .30 - 15",4,540,"plat2",2.0657903938226627,null,59.425663258835094,4.1267821707524376E-2]
["nap .50",1649.8251608667103,4,540,"00:00:00",1,"00:02:27","plat2",1.2669964249708998,null,null,"nap .50 - 16",0.23479328012830963,"16",0.15137756996821652,"nap .50 - 16",4,540,"plat2",1.2686978138597886,null,12.968484605365797,9.0058920870595797E-3]
["nap 12",237.43458022649278,4,540,"00:00:00",1,"00:02:27","plat2",1.886524982392294,null,null,"nap 12 - 17",3.3790273799667446E-2,"17",0.38617085009652619,"nap 12 - 17",4,540,"plat2",1.8882263712811829,null,12.968484605365797,9.0058920870595797E-3]
["nap 15",393.0269343242868,4,540,"00:00:00",1,"00:02:27","plat2",1.3676200631426092,null,null,"nap 15 - 18",5.5933249945282142E-2,"18",0.41996112389619361,"nap 15 - 18",4,540,"plat2",1.369321452031498,null,122.75658904999779,8.5247631284720696E-2]
["nap 18",456.83291384950934,4,540,"00:00:00",1,"00:02:27","plat2",1.1766041903766924,null,null,"nap 18 - 19",6.5013736520390872E-2,"19",0.47589437384147576,"nap 18 - 19",4,540,"plat2",1.1783055792655812,null,122.75658904999779,8.5247631284720696E-2]
["nap 20",543.56314585799578,4,540,"00:00:00",1,"00:02:27","plat2",1.2818643038216897,null,null,"nap 20 - 20",7.7356666027456999E-2,"20",0.54090811036186659,"nap 20 - 20",4,540,"plat2",1.2835656927105785,null,122.75658904999779,8.5247631284720696E-2]
["nap 22",713.83806596733177,4,540,"00:00:00",1,"00:02:27","plat2",1.1979355060738925,null,null,"nap 22 - 21",0.10158917742584923,"21",0.61826477638932364,"nap 22 - 21",4,540,"plat2",1.1996368949627814,null,12.968484605365797,9.0058920870595797E-3]
["nap 24",820.738923569794,4,540,"00:00:00",1,"00:02:27","plat2",1.0419049715468571,null,null,"nap 24 - 22",0.11680267010396173,"22",0.71985395381517292,"nap 24 - 22",4,540,"plat2",1.0436063604357459,null,122.75658904999779,8.5247631284720696E-2]
["npr",135,4,540,"00:00:00",5,"00:13:00","plat7",5.9340659340659352,null,null,"npr - 23",1.9212395088380286E-2,"23",0.83665662391913465,"npr - 23",4,540,"plat7",5.943093711843713,null,12.968484605365797,9.0058920870595797E-3]
["npr 10",170.15629825998946,4,540,"00:00:00",1,"00:02:27","plat2",2.1262016404675652,null,null,"npr 10 - 24",2.4215629844053278E-2,"24",0.85586901900751489,"npr 10 - 24",4,540,"plat2",2.127903029356454,null,122.75658904999779,8.5247631284720696E-2]
["peignoir/cas",73.112805982768336,1,50,"00:01:47",6,"00:20:00","plat6","17:16:36.606",null,null,"peignoir/cas - 25",1.0404978626378068E-2,"25",0.88008464885156812,"peignoir/cas - 25",1,50,"plat6","17:38:23.606",null,122.75658904999779,8.5247631284720696E-2]
["pte al",16.5,1,50,"00:01:47",2,"00:02:30","plat1","03:35:29.293",null,null,"pte al - 26",2.3481816219131459E-3,"26",0.89048962747794613,"pte al - 26",1,50,"plat1","03:39:46.293",null,128.32600239659175,8.9115279442077602E-2]
["sac",134.79894694796471,4,540,"00:00:00",5,"00:13:00","plat6",4.3264432935453696,null,null,"sac - 27",1.9183782416754901E-2,"27",0.89283780909985933,"sac - 27",4,540,"plat6",4.3354710713231475,null,128.32600239659175,8.9115279442077602E-2]
["serv éponge",9.4747462549560542,1,50,"00:01:47",3,"00:22:00","plat4","07:49:04.993",null,null,"serv éponge - 28",1.3483893956471645E-3,"28",0.91202159151661422,"serv éponge - 28",1,50,"plat4","08:12:51.993",null,316.44202400113028,0.21975140555634048]
["serv éponge luxe",14.572347143077161,1,50,"00:01:47",3,"00:22:00","plat4","05:22:55.941",null,null,"serv éponge luxe - 29",2.0738495605765049E-3,"29",0.9133699809122614,"serv éponge luxe - 29",1,50,"plat4","05:46:42.941",null,316.44202400113028,0.21975140555634048]
["serv œil",33.273810338925038,4,540,"00:00:00",5,"00:13:00","plat3",5.7166661181976366,null,null,"serv œil - 30",4.7353302987204488E-3,"30",0.91544383047283795,"serv œil - 30",4,540,"plat3",5.7256938959754144,null,316.44202400113028,0.21975140555634048]
["serv tab gde",57.778249109713357,4,540,"00:00:00",5,"00:13:00","plat3",3.8762533841286229,null,null,"serv tab gde - 31",8.2226559215605143E-3,"31",0.92017916077155837,"serv tab gde - 31",4,540,"plat3",3.8852811619064007,null,316.44202400113028,0.21975140555634048]
["serv tab pte",42.664717693820165,4,540,"00:00:00",5,"00:13:00","plat3",4.1725807094175114,null,null,"serv tab pte - 32",6.0717882419843109E-3,"32",0.92840181669311883,"serv tab pte - 32",4,540,"plat3",4.1816084871952892,null,316.44202400113028,0.21975140555634048]
["serv tab pte",42.664717693820165,4,540,"00:00:00",5,"00:13:00","plat7",12.517742128252539,null,null,"serv tab pte - 33",6.0717882419843109E-3,"33",0.93447360493510312,{"$f":"L34","v":"serv tab pte - 33"},4,540,{"$f":"H34","v":"plat7"},12.526769906030317,null,316.44202400113028,0.21975140555634048]
["taie luxe",7.529084544710642,1,50,"00:01:47",1,"00:02:27","plat7","23:14:00.661",null,null,"taie luxe - 34",1.0714944216799901E-3,"34",{"$f":"O34+M34","v":0.94054539317708741},"taie luxe - 34",1,50,"plat7","23:18:14.661",null,316.44202400113028,0.21975140555634048]
["tapis bain",12.017367385144885,1,50,"00:01:47",3,"00:22:00","plat4","06:13:59.434",null,null,"tapis bain - 35",1.7102400750045855E-3,"35",0.94161688759876738,"tapis bain - 35",1,50,"plat4","06:37:46.434",null,128.32600239659175,8.9115279442077602E-2]
["torchon",48.479822030891825,4,540,"00:00:00",0,"00:00:00","plat3",3.2548017130025984,null,null,"torchon - 36",6.8993592197915295E-3,"36",0.94332712767377191,"torchon - 36",4,540,"plat3",3.2548017130025984,null,128.32600239659175,8.9115279442077602E-2]
["set",43.2,4,540,"00:00:00",1,"00:02:27","plat7",13.392857142857146,null,null,"set - 37",6.1479664282816917E-3,"37",0.95022648689356348,"set - 37",4,540,"plat7",13.394558531746036,null,316.44202400113028,0.21975140555634048]
["serv_alim",27,4,540,"00:00:00",5,"00:13:00","plat6",24.545454545454547,null,null,"serv_alim - 38",3.842479017676057E-3,"38",0.95637445332184512,"serv_alim - 38",4,540,"plat6",24.554482323232325,null,59.425663258835094,4.1267821707524376E-2]
["HC GD portrait",96.149790587033024,1,50,"00:01:47",1,"00:02:27","plat1","01:19:14.486",null,null,"HC GD portrait - 39",1.3683464921652639E-2,"39",0.96021693233952121,"HC GD portrait - 39",1,50,"plat1","01:23:28.486",null,59.425663258835094,4.1267821707524376E-2]
["HC GD portrait",96.149790587033024,1,50,"00:01:47",1,"00:02:27","plat2","02:26:23.948",null,null,"HC GD portrait - 40",1.3683464921652639E-2,"40",0.97390039726117383,"HC GD portrait - 40",1,50,"plat2","02:30:37.948",null,59.425663258835101,4.1267821707524376E-2]
["HC MOY portrait",63.749538313780718,1,50,"00:01:47",1,"00:02:27","plat2","02:53:29.400",null,null,"HC MOY portrait - 41",9.0724541984162337E-3,"41",0.98758386218282646,"HC MOY portrait - 41",1,50,"plat2","02:57:43.400",null,59.425663258835094,4.1267821707524376E-2]
["Taie",8.6951075311380048,1,50,"00:01:47",1,"00:02:27","plat3","05:52:03.772",null,null,"Taie - 42",1.2374358609198092E-3,"42",0.99665631638124264,"Taie - 42",1,50,"plat3","05:56:17.772",null,59.425663258835094,4.1267821707524376E-2]
["tapis bain luxe",14.799999999999999,1,50,"00:01:47",3,"00:22:00","plat4","05:10:39.329",null,null,"tapis bain luxe - 43",2.106247757837246E-3,"43",0.99789375224216248,"tapis bain luxe - 43",1,50,"plat4","05:34:26.329",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 44",0,"44",0.99999999999999978," - 44",0,0,0,"00:00:00",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 45",0,"45",0.99999999999999978," - 45",0,0,0,"00:00:00",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 46",0,"46",0.99999999999999978," - 46",0,0,0,"00:00:00",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 47",0,"47",0.99999999999999978," - 47",0,0,0,"00:00:00",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 48",0,"48",0.99999999999999978," - 48",0,0,0,"00:00:00",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 49",0,"49",0.99999999999999978," - 49",0,0,0,"00:00:00",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 50",0,"50",0.99999999999999978," - 50",0,0,0,"00:00:00",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 51",0,"51",0.99999999999999978," - 51",0,0,0,"00:00:00",null,59.425663258835094,4.1267821707524376E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 52",{"$f":"B53/$X$2","v":0},"52",{"$f":"O52+M52","v":0.99999999999999978},{"$f":"L53","v":" - 52"},{"$f":"C53","v":0},{"$f":"D53","v":0},{"$f":"H53","v":0},{"$f":"E53+G53+I53","v":"00:00:00"},null,60.425663258835101,{"$f":"V53/24/60","v":4.1962266151968824E-2}]
[null,null,null,null,null,null,null,null,null,null,null," - 53",0,"53",0.99999999999999978," - 53",0,0,0,"00:00:00",null,61.425663258835101,4.2656710596413266E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 54",0,"54",0.99999999999999978," - 54",0,0,0,"00:00:00",null,62.425663258835101,4.3351155040857708E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 55",0,"55",0.99999999999999978," - 55",0,0,0,"00:00:00",null,63.425663258835101,4.4045599485302157E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 56",0,"56",0.99999999999999978," - 56",0,0,0,"00:00:00",null,64.425663258835101,4.4740043929746599E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 57",0,"57",0.99999999999999978," - 57",0,0,0,"00:00:00",null,65.425663258835101,4.5434488374191041E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 58",0,"58",0.99999999999999978," - 58",0,0,0,"00:00:00",null,66.425663258835101,4.612893281863549E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 59",0,"59",0.99999999999999978," - 59",0,0,0,"00:00:00",null,67.425663258835101,4.6823377263079932E-2]
[null,null,null,null,null,null,null,null,null,null,null," - 60",0,"60",0.99999999999999978," - 60",0,0,0,"00:00:00",null,68.425663258835101,4.7517821707524374E-2]

{"sheet":"Ordonnancement","index":2,"n_rows":37,"n_cols":15,"rows_kept":37,"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"]
["HC MOY portrait - 41",1,"plat2"]
["ch tab - 05",1,"plat3"]
["tapis bain luxe - 43",1,"plat2"]
["serv éponge luxe - 29",1,"plat3"]
["drap petit - 08",1,"plat2"]
["couette/couv - 07",1,"plat3"]
["drap housse - 12",1,"plat2"]
["couette/couv - 07",1,"plat3"]
["serv éponge - 28",1,"plat2"]
["drap petit - 08",1,"plat3"]
["drap grand - 09",1,"plat2"]
["serv éponge - 28",1,"plat3"]
["peignoir/cas - 25",1,"plat2"]
["HC MOY portrait - 41",1,"plat3"]
["drap petit - 08",1,"plat2"]
["peignoir/cas - 25",1,"plat3"]
["serv éponge - 28",1,"plat2"]
["HC GD portrait - 40",1,"plat3"]
["HC GD portrait - 39",1,"plat2"]
["couette/couv - 07",1,"plat3"]
["HC GD portrait - 39",1,"plat2"]
["drap luxe - 13",1,"plat3",null,null,null,null,null,"Vers tunnels",null,"Vers laveuses",null,null,null,"Vers tunnels"]
["drap petit - 08",1,"plat2",null,null,null,null,null,"Choix familles Aléatoire",null,null,null,null,"Choix familles Imposé"]
["drap grand - 09",1,"plat3"]
["drap grand - 09",1,"plat2"]
["drap bain luxe - 11",1,"plat3"]
["couette/couv - 07",1,"plat2"]
["tapis bain luxe - 43",1,"plat3"]
["carré/gant - 04",1,"plat2"]
["couette/couv - 07",1,"plat3"]
["couette/couv - 07",1,"plat2"]
["HC GD portrait - 39",1,"plat3"]
["HC GD portrait - 39",1,"plat2"]
["drap luxe - 13",1,"plat3"]
["HC GD portrait - 40",1,"plat2"]
["HC GD portrait - 40",1,"plat3"]

{"sheet":"Ordonna","index":3,"n_rows":54,"n_cols":13,"rows_kept":54,"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,"nap 22 - 21","CodeFamille","Calandre"]
[{"$f":"Donnees!L2","v":"Blanchissage plat1 - 01"},{"$f":"Donnees!S2","v":"plat6"},{"$f":"Donnees!B2","v":20.953448275862069},null,{"$f":"C3/$C$54","v":2.9819698277022428E-3},0,{"$f":"A3","v":"Blanchissage plat1 - 01"},{"$f":"B3","v":"plat6"},null,null,"nap 24 - 22","hous trav - 22","Plat5"]
[{"$f":"Donnees!L3","v":"Blanchissage plat6 - 02"},{"$f":"Donnees!S3","v":"plat3"},{"$f":"Donnees!B3","v":48.6},null,{"$f":"C4/$C$54","v":6.9164622318169033E-3},{"$f":"F3+E3","v":2.9819698277022428E-3},{"$f":"A4","v":"Blanchissage plat6 - 02"},"plat3",null,null,"nap 22 - 21","drap grand - 16","Plat3"]
[{"$f":"Donnees!L4","v":"alése abs - 03"},{"$f":"Donnees!S4","v":"plat6"},{"$f":"Donnees!B4","v":28.309141694652538},null,4.0287882581526218E-3,{"$f":"F4+E4","v":9.8984320595191452E-3},"alése abs - 03","plat6",null,null,"HC GD portrait - 39","drap 1/2 - 11","Plat4"]
[{"$f":"Donnees!L5","v":"carré/gant - 04"},{"$f":"Donnees!S5","v":"plat6"},{"$f":"Donnees!B5","v":2.319337700514589},null,3.3007431293082754E-4,1.3927220317671768E-2,"carré/gant - 04","plat6",null,null,"nap .50 - 16","drap bain luxe - 14","Plat5"]
[{"$f":"Donnees!L6","v":"ch tab - 05"},{"$f":"Donnees!S6","v":"plat3"},{"$f":"Donnees!B6","v":6.8697528894561444},null,9.7766227164276668E-4,1.4257294630602595E-2,"ch tab - 05","plat3",null,null,"serv tab pte - 32"]
[{"$f":"Donnees!L7","v":"chmal - 06"},{"$f":"Donnees!S7","v":"plat6"},{"$f":"Donnees!B7","v":12.500000000000004},null,1.7789254711463233E-3,1.5234956902245361E-2,"chmal - 06","plat6"]
[{"$f":"Donnees!L8","v":"couette/couv - 07"},{"$f":"Donnees!S8","v":"plat6"},{"$f":"Donnees!B8","v":64.551515151515147},null,9.1865867603294453E-3,1.7013882373391683E-2,"couette/couv - 07","plat6"]
[{"$f":"Donnees!L9","v":"drap petit - 08"},{"$f":"Donnees!S9","v":"plat1"},{"$f":"Donnees!B9","v":46.1271992793286},null,6.5645479768511959E-3,2.6200469133721128E-2,"drap petit - 08","plat1"]
[{"$f":"Donnees!L10","v":"drap grand - 09"},{"$f":"Donnees!S10","v":"plat1"},{"$f":"Donnees!B10","v":61.197316254440814},null,8.7092371720657313E-3,3.2765017110572323E-2,"drap grand - 09","plat1"]
[{"$f":"Donnees!L11","v":"drap bain - 10"},{"$f":"Donnees!S11","v":"plat4"},{"$f":"Donnees!B11","v":21.601842470896688},null,3.074245423613483E-3,4.1474254282638054E-2,"drap bain - 10","plat4"]
[{"$f":"Donnees!L12","v":"drap bain luxe - 11"},{"$f":"Donnees!S12","v":"plat4"},{"$f":"Donnees!B12","v":29.862010627316515},null,4.2497833059660425E-3,4.4548499706251535E-2,"drap bain luxe - 11","plat4"]
[{"$f":"Donnees!L13","v":"drap housse - 12"},{"$f":"Donnees!S13","v":"plat6"},{"$f":"Donnees!B13","v":29.794174323601368},null,4.2401292476822589E-3,4.8798283012217579E-2,"drap housse - 12","plat6"]
[{"$f":"Donnees!L14","v":"drap luxe - 13"},{"$f":"Donnees!S14","v":"plat1"},{"$f":"Donnees!B14","v":57.892990358677842},null,8.2389852119904398E-3,5.3038412259899838E-2,"drap luxe - 13","plat1"]
[{"$f":"Donnees!L15","v":"grde al - 14"},{"$f":"Donnees!S15","v":"plat1"},{"$f":"Donnees!B15","v":25.482406885598653},null,3.6265042139924709E-3,6.1277397471890274E-2,"grde al - 14","plat1"]
[{"$f":"Donnees!L16","v":"nap .30 - 15"},{"$f":"Donnees!S16","v":"plat2"},{"$f":"Donnees!B16","v":607.62571061093252},null,8.6473668282333785E-2,6.4903901685882739E-2,"nap .30 - 15","plat2"]
[{"$f":"Donnees!L17","v":"nap .50 - 16"},{"$f":"Donnees!S17","v":"plat2"},{"$f":"Donnees!B17","v":1649.8251608667103},null,0.23479328012830963,0.15137756996821652,"nap .50 - 16","plat2"]
[{"$f":"Donnees!L18","v":"nap 12 - 17"},{"$f":"Donnees!S18","v":"plat2"},{"$f":"Donnees!B18","v":237.43458022649278},null,3.3790273799667446E-2,0.38617085009652619,"nap 12 - 17","plat2"]
[{"$f":"Donnees!L19","v":"nap 15 - 18"},{"$f":"Donnees!S19","v":"plat2"},{"$f":"Donnees!B19","v":393.0269343242868},null,5.5933249945282142E-2,0.41996112389619361,"nap 15 - 18","plat2"]
[{"$f":"Donnees!L20","v":"nap 18 - 19"},{"$f":"Donnees!S20","v":"plat2"},{"$f":"Donnees!B20","v":456.83291384950934},null,6.5013736520390872E-2,0.47589437384147576,"nap 18 - 19","plat2"]
[{"$f":"Donnees!L21","v":"nap 20 - 20"},{"$f":"Donnees!S21","v":"plat2"},{"$f":"Donnees!B21","v":543.56314585799578},null,7.7356666027456999E-2,0.54090811036186659,"nap 20 - 20","plat2"]
[{"$f":"Donnees!L22","v":"nap 22 - 21"},{"$f":"Donnees!S22","v":"plat2"},{"$f":"Donnees!B22","v":713.83806596733177},null,0.10158917742584923,0.61826477638932364,"nap 22 - 21","plat2"]
[{"$f":"Donnees!L23","v":"nap 24 - 22"},{"$f":"Donnees!S23","v":"plat2"},{"$f":"Donnees!B23","v":820.738923569794},null,0.11680267010396173,0.71985395381517292,"nap 24 - 22","plat2"]
[{"$f":"Donnees!L24","v":"npr - 23"},{"$f":"Donnees!S24","v":"plat7"},{"$f":"Donnees!B24","v":135},null,1.9212395088380286E-2,0.83665662391913465,"npr - 23","plat7"]
[{"$f":"Donnees!L25","v":"npr 10 - 24"},{"$f":"Donnees!S25","v":"plat2"},{"$f":"Donnees!B25","v":170.15629825998946},null,2.4215629844053278E-2,0.85586901900751489,"npr 10 - 24","plat2"]
[{"$f":"Donnees!L26","v":"peignoir/cas - 25"},{"$f":"Donnees!S26","v":"plat6"},{"$f":"Donnees!B26","v":73.112805982768336},null,{"$f":"C27/$C$54","v":1.0404978626378068E-2},0.88008464885156812,"peignoir/cas - 25","plat6"]
[{"$f":"Donnees!L27","v":"pte al - 26"},{"$f":"Donnees!S27","v":"plat1"},{"$f":"Donnees!B27","v":16.5},null,2.3481816219131459E-3,0.89048962747794613,"pte al - 26","plat1"]
[{"$f":"Donnees!L28","v":"sac - 27"},{"$f":"Donnees!S28","v":"plat6"},{"$f":"Donnees!B28","v":134.79894694796471},null,1.9183782416754901E-2,0.89283780909985933,"sac - 27","plat6"]
[{"$f":"Donnees!L29","v":"serv éponge - 28"},{"$f":"Donnees!S29","v":"plat4"},{"$f":"Donnees!B29","v":9.4747462549560542},null,1.3483893956471645E-3,0.91202159151661422,"serv éponge - 28","plat4"]
[{"$f":"Donnees!L30","v":"serv éponge luxe - 29"},{"$f":"Donnees!S30","v":"plat4"},{"$f":"Donnees!B30","v":14.572347143077161},null,2.0738495605765049E-3,0.9133699809122614,"serv éponge luxe - 29","plat4"]
[{"$f":"Donnees!L31","v":"serv œil - 30"},{"$f":"Donnees!S31","v":"plat3"},{"$f":"Donnees!B31","v":33.273810338925038},null,4.7353302987204488E-3,0.91544383047283795,"serv œil - 30","plat3"]
[{"$f":"Donnees!L32","v":"serv tab gde - 31"},{"$f":"Donnees!S32","v":"plat3"},{"$f":"Donnees!B32","v":57.778249109713357},null,8.2226559215605143E-3,0.92017916077155837,"serv tab gde - 31","plat3"]
[{"$f":"Donnees!L33","v":"serv tab pte - 32"},{"$f":"Donnees!S33","v":"plat3"},{"$f":"Donnees!B33","v":42.664717693820165},null,6.0717882419843109E-3,0.92840181669311883,"serv tab pte - 32","plat3"]
[{"$f":"Donnees!L34","v":"serv tab pte - 33"},{"$f":"Donnees!S34","v":"plat7"},{"$f":"Donnees!B34","v":42.664717693820165},null,6.0717882419843109E-3,0.93447360493510312,"serv tab pte - 33","plat7"]
[{"$f":"Donnees!L35","v":"taie luxe - 34"},{"$f":"Donnees!S35","v":"plat7"},{"$f":"Donnees!B35","v":7.529084544710642},null,1.0714944216799901E-3,0.94054539317708741,"taie luxe - 34","plat7"]
[{"$f":"Donnees!L36","v":"tapis bain - 35"},{"$f":"Donnees!S36","v":"plat4"},{"$f":"Donnees!B36","v":12.017367385144885},null,1.7102400750045855E-3,0.94161688759876738,"tapis bain - 35","plat4"]
[{"$f":"Donnees!L37","v":"torchon - 36"},{"$f":"Donnees!S37","v":"plat3"},{"$f":"Donnees!B37","v":48.479822030891825},null,6.8993592197915295E-3,0.94332712767377191,"torchon - 36","plat3"]
[{"$f":"Donnees!L38","v":"set - 37"},{"$f":"Donnees!S38","v":"plat7"},{"$f":"Donnees!B38","v":43.2},null,6.1479664282816917E-3,0.95022648689356348,"set - 37","plat7"]
[{"$f":"Donnees!L39","v":"serv_alim - 38"},{"$f":"Donnees!S39","v":"plat6"},{"$f":"Donnees!B39","v":27},null,3.842479017676057E-3,0.95637445332184512,"serv_alim - 38","plat6"]
[{"$f":"Donnees!L40","v":"HC GD portrait - 39"},{"$f":"Donnees!S40","v":"plat1"},{"$f":"Donnees!B40","v":96.149790587033024},null,1.3683464921652639E-2,0.96021693233952121,"HC GD portrait - 39","plat1"]
[{"$f":"Donnees!L41","v":"HC GD portrait - 40"},{"$f":"Donnees!S41","v":"plat2"},{"$f":"Donnees!B41","v":96.149790587033024},null,1.3683464921652639E-2,0.97390039726117383,"HC GD portrait - 40","plat2"]
[{"$f":"Donnees!L42","v":"HC MOY portrait - 41"},{"$f":"Donnees!S42","v":"plat2"},{"$f":"Donnees!B42","v":63.749538313780718},null,9.0724541984162337E-3,0.98758386218282646,{"$f":"A43","v":"HC MOY portrait - 41"},"plat2"]
[{"$f":"Donnees!L43","v":"Taie - 42"},{"$f":"Donnees!S43","v":"plat3"},{"$f":"Donnees!B43","v":8.6951075311380048},null,1.2374358609198092E-3,0.99665631638124264,"Taie - 42","plat3"]
[{"$f":"Donnees!L44","v":"tapis bain luxe - 43"},{"$f":"Donnees!S44","v":"plat4"},{"$f":"Donnees!B44","v":14.799999999999999},null,2.106247757837246E-3,0.99789375224216248,"tapis bain luxe - 43","plat4"]
[{"$f":"Donnees!L45","v":" - 44"},{"$f":"Donnees!S45","v":0},{"$f":"Donnees!B45","v":0},null,0,0.99999999999999978," - 44",0]
[{"$f":"Donnees!L46","v":" - 45"},{"$f":"Donnees!S46","v":0},{"$f":"Donnees!B46","v":0},null,0,0.99999999999999978," - 45",0]
[{"$f":"Donnees!L47","v":" - 46"},{"$f":"Donnees!S47","v":0},{"$f":"Donnees!B47","v":0},null,0,0.99999999999999978," - 46",0]
[{"$f":"Donnees!L48","v":" - 47"},{"$f":"Donnees!S48","v":0},{"$f":"Donnees!B48","v":0},null,{"$f":"C49/$C$54","v":0},0.99999999999999978," - 47",0]
[{"$f":"Donnees!L49","v":" - 48"},{"$f":"Donnees!S49","v":0},{"$f":"Donnees!B49","v":0},null,0,0.99999999999999978," - 48",0]
[{"$f":"Donnees!L50","v":" - 49"},{"$f":"Donnees!S50","v":0},{"$f":"Donnees!B50","v":0},null,0,0.99999999999999978," - 49",0]
[{"$f":"Donnees!L51","v":" - 50"},{"$f":"Donnees!S51","v":0},{"$f":"Donnees!B51","v":0},null,0,0.99999999999999978," - 50",0]
[{"$f":"Donnees!L52","v":" - 51"},{"$f":"Donnees!S52","v":0},{"$f":"Donnees!B52","v":0},null,0,0.99999999999999978," - 51",0]
[null,null,{"$f":"SUM(C3:C53)","v":7026.7137115896812},null,null,0.99999999999999978]

{"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,null,null,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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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,null,null,null,null,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:$T$61,5,FALSE))","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,null,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:$T$61,5,FALSE))","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,null,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:$T$61,5,FALSE))","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,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,null,null,null,0]
[null,null,null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(A13,Donnees!$P$2:$T$61,5,FALSE))","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,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,null,null,null,0]
[null,null,null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(A14,Donnees!$P$2:$T$61,5,FALSE))","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,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,null,null,null,0]
[null,null,null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(A15,Donnees!$P$2:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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:$T$61,5,FALSE))","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,null,"Machine",7,6]
[null,null,null,{"$f":"IF(C40=\"\",\"\",VLOOKUP(A40,Donnees!$P$2:$T$61,5,FALSE))","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,"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,"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,"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,"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,"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":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["N°","Commentaires","Centre","Débit Total"]
[1,null,null,139]
[2,null,null,25]
[3,null,null,85]
[4,null,null,500]
[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":true,"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."]