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

{"sheet":"ensachage","index":0,"n_rows":786,"n_cols":8,"rows_kept":786,"cut":false,"hidden":false,"merged":[[4,0,13,0],[4,2,13,2],[4,7,13,7],[0,3,3,7],[4,1,13,1],[4,3,13,3],[4,4,13,4],[4,6,13,6],[4,5,13,5]]}
[null,null,null,"Données à remplir"]
[]
[]
[]
["Année","Mois","Semaine","Date","Quart","Quantité conditionnée par produit (kg)","Ensachage (minutes)","Ouverture (minutes)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(D15=\"\",\"\",YEAR(D15))","v":2017},{"$f":"IF(D15=\"\",\"\",MONTH(D15))","v":10},{"$f":"IF(D15=\"\",\"\",WEEKNUM(D15,21))","v":40},"2017-10-02","J",1725,"05:45:00","07:00:00"]
[{"$f":"IF(D16=\"\",\"\",YEAR(D16))","v":2017},{"$f":"IF(D16=\"\",\"\",MONTH(D16))","v":10},{"$f":"IF(D16=\"\",\"\",WEEKNUM(D16,21))","v":40},"2017-10-03","J",2600,"05:15:00","07:00:00"]
[2017,10,40,"2017-10-04","J",425,"05:45:00","07:00:00"]
[2017,10,40,"2017-10-05","J",600,"05:00:00","07:00:00"]
[2017,10,40,"2017-10-06","J",1075,"04:25:00","07:00:00"]
[2017,10,41,"2017-10-10","J",1700,"05:15:00","07:00:00"]
[2017,10,41,"2017-10-11","J",1825,"04:45:00","07:00:00"]
[2017,10,41,"2017-10-12","J",6050,"05:45:00","07:00:00"]
[2017,10,41,"2017-10-13","J",5100,"04:45:00","07:00:00"]
[2017,10,42,"2017-10-17","J",5250,"06:00:00","07:00:00"]
[2017,10,42,"2017-10-18","J",1650,"04:00:00","07:00:00"]
[2017,10,42,"2017-10-19","J",5325,"05:50:00","07:00:00"]
[2017,10,42,"2017-10-20","J",1075,"05:15:00","07:00:00"]
[2017,10,43,"2017-10-23","J",850,"05:30:00","07:00:00"]
[2017,10,43,"2017-10-24","J",2250,"05:05:00","07:00:00"]
[2017,10,43,"2017-10-25","J",2800,"04:45:00","07:00:00"]
[2017,10,43,"2017-10-26","J",3575,"05:00:00","07:00:00"]
[2017,10,43,"2017-10-27","J",500,"04:45:00","07:00:00"]
[2017,10,44,"2017-10-30","J",1925,"04:45:00","07:00:00"]
[2017,10,44,"2017-10-31","J",750,"05:45:00","07:00:00"]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D38=\"\",\"\",YEAR(D38))","v":""},{"$f":"IF(D38=\"\",\"\",MONTH(D38))","v":""},{"$f":"IF(D38=\"\",\"\",WEEKNUM(D38,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D102=\"\",\"\",YEAR(D102))","v":""},{"$f":"IF(D102=\"\",\"\",MONTH(D102))","v":""},{"$f":"IF(D102=\"\",\"\",WEEKNUM(D102,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D166=\"\",\"\",YEAR(D166))","v":""},{"$f":"IF(D166=\"\",\"\",MONTH(D166))","v":""},{"$f":"IF(D166=\"\",\"\",WEEKNUM(D166,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D230=\"\",\"\",YEAR(D230))","v":""},{"$f":"IF(D230=\"\",\"\",MONTH(D230))","v":""},{"$f":"IF(D230=\"\",\"\",WEEKNUM(D230,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D294=\"\",\"\",YEAR(D294))","v":""},{"$f":"IF(D294=\"\",\"\",MONTH(D294))","v":""},{"$f":"IF(D294=\"\",\"\",WEEKNUM(D294,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D358=\"\",\"\",YEAR(D358))","v":""},{"$f":"IF(D358=\"\",\"\",MONTH(D358))","v":""},{"$f":"IF(D358=\"\",\"\",WEEKNUM(D358,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D422=\"\",\"\",YEAR(D422))","v":""},{"$f":"IF(D422=\"\",\"\",MONTH(D422))","v":""},{"$f":"IF(D422=\"\",\"\",WEEKNUM(D422,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D486=\"\",\"\",YEAR(D486))","v":""},{"$f":"IF(D486=\"\",\"\",MONTH(D486))","v":""},{"$f":"IF(D486=\"\",\"\",WEEKNUM(D486,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D550=\"\",\"\",YEAR(D550))","v":""},{"$f":"IF(D550=\"\",\"\",MONTH(D550))","v":""},{"$f":"IF(D550=\"\",\"\",WEEKNUM(D550,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D614=\"\",\"\",YEAR(D614))","v":""},{"$f":"IF(D614=\"\",\"\",MONTH(D614))","v":""},{"$f":"IF(D614=\"\",\"\",WEEKNUM(D614,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[{"$f":"IF(D678=\"\",\"\",YEAR(D678))","v":""},{"$f":"IF(D678=\"\",\"\",MONTH(D678))","v":""},{"$f":"IF(D678=\"\",\"\",WEEKNUM(D678,21))","v":""}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,{"$f":"IF(D742=\"\",\"\",MONTH(D742))","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Feuil1","index":1,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Année","(Tous)"]
["Mois","(Tous)"]
["Semaine","(Tous)"]
[null,null,null,null,null,null,null,null,"=((10000/420)*'Ouverture (minutes)'*1440-'Quantité conditionnée par produit (kg)')/(10000/420)/1440"]
["Étiquettes de lignes","Quantité conditionnée par produit (kg)","Ensachage (minutes)","Ouverture (minutes)"," A justifier (théo en min)","Somme de A justifier (%)",null,null,"Attendu","diff.","à justifier"]
["2017-10-02",1725,"05:45:00","07:00:00",5.4102647924158212E-2,0.82750000000000001,null,null,{"$f":"10000/420*C6*1440","v":8214.2857142857156},{"$f":"10000/420*C6*1440-B6","v":6489.2857142857156},{"$f":"J6/(10000/420)/1440","v":"04:32:33"}]
["2017-10-03",2600,"05:15:00","07:00:00",4.8381824125531214E-2,0.74,null,null,{"$f":"10000/420*C7*1440","v":7500.0000000000009},{"$f":"10000/420*C7*1440-B7","v":4900.0000000000009},{"$f":"J7/(10000/420)/1440","v":"03:25:48"}]
["2017-10-04",425,"05:45:00","07:00:00",6.2602157567832606E-2,0.9574999999999998,null,null,8214.2857142857156,{"$f":"10000/420*C8*1440-B8","v":7789.2857142857156},"05:27:09"]
["2017-10-05",600,"05:00:00","07:00:00",6.1457992808107216E-2,0.94,null,null,7142.8571428571431,{"$f":"10000/420*C9*1440-B9","v":6542.8571428571431},"04:34:48"]
["2017-10-06",1075,"04:25:00","07:00:00",5.8352402745995416E-2,0.89249999999999996,null,null,6309.5238095238101,{"$f":"10000/420*C10*1440-B10","v":5234.5238095238101},"03:39:51"]
["2017-10-10",1700,"05:15:00","07:00:00",5.4266100032690411E-2,0.82999999999999985,null,null,7500.0000000000009,{"$f":"10000/420*C11*1440-B11","v":5800.0000000000009},"04:03:36"]
["2017-10-11",1825,"04:45:00","07:00:00",5.3448839490029404E-2,0.81749999999999989,null,null,6785.7142857142853,{"$f":"10000/420*C12*1440-B12","v":4960.7142857142853},"03:28:21"]
["2017-10-12",6050,"05:45:00","07:00:00",2.5825433148087606E-2,0.39500000000000002,null,null,8214.2857142857156,{"$f":"10000/420*C13*1440-B13","v":2164.2857142857156},"01:30:54"]
["2017-10-13",5100,"04:45:00","07:00:00",3.2036613272311207E-2,0.48999999999999994,null,null,6785.7142857142853,{"$f":"10000/420*C14*1440-B14","v":1685.7142857142853},"01:10:48"]
["2017-10-17",5250,"06:00:00","07:00:00",3.1055900621118009E-2,0.47499999999999998,null,null,8571.4285714285725,{"$f":"10000/420*C15*1440-B15","v":3321.4285714285725},"02:19:30"]
["2017-10-18",1650,"04:00:00","07:00:00",5.4593004249754808E-2,0.83499999999999996,null,null,5714.2857142857147,{"$f":"10000/420*C16*1440-B16","v":4064.2857142857147},"02:50:42"]
["2017-10-19",5325,"05:50:00","07:00:00",3.0565544295521406E-2,0.46749999999999997,null,null,8333.3333333333339,{"$f":"10000/420*C17*1440-B17","v":3008.3333333333339},"02:06:21"]
["2017-10-20",1075,"05:15:00","07:00:00",5.8352402745995416E-2,0.89249999999999996,null,null,7500.0000000000009,{"$f":"10000/420*C18*1440-B18","v":6425.0000000000009},"04:29:51"]
["2017-10-23",850,"05:30:00","07:00:00",5.9823471722785217E-2,0.91500000000000004,null,null,7857.1428571428578,{"$f":"10000/420*C19*1440-B19","v":7007.1428571428578},"04:54:18"]
["2017-10-24",2250,"05:05:00","07:00:00",5.0670153644982015E-2,0.77499999999999991,null,null,7261.9047619047615,{"$f":"10000/420*C20*1440-B20","v":5011.9047619047615},"03:30:30"]
["2017-10-25",2800,"04:45:00","07:00:00",4.7074207257273612E-2,0.72,null,null,6785.7142857142853,{"$f":"10000/420*C21*1440-B21","v":3985.7142857142853},"02:47:24"]
["2017-10-26",3575,"05:00:00","07:00:00",4.2007191892775408E-2,0.64249999999999985,null,null,7142.8571428571431,{"$f":"10000/420*C22*1440-B22","v":3567.8571428571431},"02:29:51"]
["2017-10-27",500,"04:45:00","07:00:00",6.2111801242236017E-2,0.95,null,null,6785.7142857142853,{"$f":"10000/420*C23*1440-B23","v":6285.7142857142853},"04:24:00"]
["2017-10-30",1925,"04:45:00","07:00:00",5.279503105590061E-2,0.80749999999999988,null,null,6785.7142857142853,{"$f":"10000/420*C24*1440-B24","v":4860.7142857142853},"03:24:09"]
["2017-10-31",750,"05:45:00","07:00:00",6.0477280156914011E-2,0.92499999999999993,null,null,8214.2857142857156,{"$f":"10000/420*C25*1440-B25","v":7464.2857142857156},"05:13:30"]
["Total général",null,null,null,1,0.76474999999999993]