{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["GenerateCutMode (ByJimmy)","allocation (ByJimmy)"],"not_rendered":{"macros":1,"defined_names":106},"read":"whole","date_system":"1900"}

{"sheet":"GenerateCutMode (ByJimmy)","index":0,"n_rows":97,"n_cols":15,"rows_kept":97}
[null,null,"List length","List length","List length","List length","List length","List length","List length","List length","List length","List length","List length"]
[null,null,2183,2120,2027,1670,1656,1460,856,0,0,0,0]
[]
[null,"Demand of lists",424,8,16,288,236,16,160,0,0,0,0]
[]
[null,"Solver result(Mode)",2,0,0,0,0,0,1,0,0,0,0]
[null,"Rand Number",0.04574298858642578,0.48335760831832886,0.6306577920913696,0.9958251118659973,0.9166195392608643,0.7928470969200134,0.18583190441131592,0.12937504053115845,0.36875295639038086,0.12809723615646362,0.35513031482696533]
[]
[{"$nulls":6},"Min Waste",850,"<- input the min waste for each cut, suggest minimum length of the demanded rods"]
[null,"Object func",{"$f":"SUMPRODUCT(C6:M6,C7:M7)","v":0.2773178815841675},{"$nulls":3},"Rand Num",10,"<- default 10"]
[]
[null,"Actual Cut",{"$f":"SUMPRODUCT(C2:M2,C6:M6)","v":5222},"<=",6000,"   Length of stock rod"]
[null,"Waste",{"$f":"E12-C12","v":778},"<=",{"$f":"H9","v":850}]
[null,"Column",{"$f":"$I$6","v":1},">=",1,null,"Instruction: This sheet is to generate random cut modes by specifying the rand numbers for each List Length."]
[]
[null,null,{"$f":"C1","v":"List length"},{"$f":"D1","v":"List length"},"List length","List length","List length","List length","List length","List length","List length","List length","List length"]
[null,"Demand",{"$f":"C2","v":2183},2120,2027,1670,1656,1460,856,0,0,0,0,"Waste"]
[null,"Mode 1",1,0,0,2,0,0,0,0,0,0,0,477,{"$f":"COUNTIF(C18:M18,\">0\")","v":2}]
[null,"Mode 2",1,0,1,0,1,0,0,0,0,0,0,134,{"$f":"COUNTIF(C19:M19,\">0\")","v":3}]
[null,"Mode 3",1,0,0,0,2,0,0,0,0,0,0,505,2]
[null,"Mode 4",1,1,0,0,1,0,0,0,0,0,0,41,3]
[null,"Mode 5",1,0,1,1,0,0,0,0,0,0,0,120,3]
[null,"Mode 6",1,0,0,0,0,0,4,0,0,0,0,393,2]
[null,"Mode 7",1,0,0,0,1,1,0,0,0,0,0,701,3]
[null,"Mode 8",1,1,0,0,0,0,1,0,0,0,0,841,3]
[null,"Mode 9",0,1,0,0,0,1,2,0,0,0,0,708,3]
[null,"Mode 10",0,1,0,2,0,0,0,0,0,0,0,540,2]
[null,"Mode 11",0,2,0,0,0,1,0,0,0,0,0,300,2]
[null,"Mode 12",1,1,0,0,0,1,0,0,0,0,0,237,3]
[null,"Mode 13",0,1,0,0,0,0,4,0,0,0,0,456,2]
[null,"Mode 14",0,1,1,0,0,0,2,0,0,0,0,141,3]
[null,"Mode 15",0,1,0,0,2,0,0,0,0,0,0,568,2]
[null,"Mode 16",0,0,1,0,0,0,4,0,0,0,0,549,2]
[null,"Mode 17",0,0,1,0,2,0,0,0,0,0,0,661,2]
[null,"Mode 18",0,0,2,0,0,1,0,0,0,0,0,486,2]
[null,"Mode 19",0,1,1,0,1,0,0,0,0,0,0,197,3]
[null,"Mode 20",0,0,1,2,0,0,0,0,0,0,0,633,2]
[null,"Mode 21",0,0,2,1,0,0,0,0,0,0,0,276,2]
[null,"Mode 22",0,2,0,1,0,0,0,0,0,0,0,90,2]
[null,"Mode 23",1,0,0,1,0,1,0,0,0,0,0,687,3]
[null,"Mode 24",0,2,0,0,1,0,0,0,0,0,0,104,2]
[null,"Mode 25",0,1,0,1,1,0,0,0,0,0,0,554,3]
[null,"Mode 26",0,1,0,0,1,1,0,0,0,0,0,764,3]
[null,"Mode 27",0,0,2,0,1,0,0,0,0,0,0,290,2]
[null,"Mode 28",0,0,0,2,1,0,1,0,0,0,0,148,3]
[null,"Mode 29",0,0,0,0,1,0,5,0,0,0,0,64,2]
[null,"Mode 30",1,0,0,1,1,0,0,0,0,0,0,491,3]
[null,"Mode 31",2,0,0,0,0,1,0,0,0,0,0,174,2]
[null,"Mode 32",0,0,0,0,0,4,0,0,0,0,0,160,1]
[null,"Mode 33",0,0,0,3,0,0,1,0,0,0,0,134,2]
[null,"Mode 34",0,1,0,0,0,2,1,0,0,0,0,104,3]
[null,"Mode 35",0,0,2,0,0,0,2,0,0,0,0,234,2]
[null,"Mode 36",2,0,0,0,0,0,1,0,0,0,0,778,2]
[null,"Mode 37",0,2,0,0,0,0,2,0,0,0,0,48,2]
[null,"Mode 38",0,0,0,0,0,3,1,0,0,0,0,764,2]
[null,"Mode 39",{"$nulls":12},0]
[null,"Mode 40",{"$nulls":12},0]
[null,"Mode 41",{"$nulls":12},0]
[null,"Mode 42",{"$nulls":12},0]
[null,"Mode 43",{"$nulls":12},0]
[null,"Mode 44",{"$nulls":12},0]
[null,"Mode 45",{"$nulls":12},0]
[null,"Mode 46",{"$nulls":12},0]
[null,"Mode 47",{"$nulls":12},0]
[null,"Mode 48",{"$nulls":12},0]
[null,"Mode 49",{"$nulls":12},0]
[null,"Mode 50",{"$nulls":12},0]
[null,"Mode 51",{"$nulls":12},0]
[null,"Mode 52",{"$nulls":12},0]
[null,"Mode 53",{"$nulls":12},0]
[null,"Mode 54",{"$nulls":12},0]
[null,"Mode 55",{"$nulls":12},0]
[null,"Mode 56",{"$nulls":12},0]
[null,"Mode 57"]
[null,"Mode 58"]
[null,"Mode 59"]
[null,"Mode 60"]
[null,"Mode 61"]
[null,"Mode 62"]
[null,"Mode 63"]
[null,"Mode 64"]
[null,"Mode 65"]
[null,"Mode 66"]
[null,"Mode 67"]
[null,"Mode 68"]
[null,"Mode 69"]
[null,"Mode 70"]
[null,"Mode 71"]
[null,"Mode 72"]
[null,"Mode 73"]
[null,"Mode 74"]
[null,"Mode 75"]
[null,"Mode 76"]
[null,"Mode 77"]
[null,"Mode 78"]
[null,"Mode 79"]
[null,"Mode 80"]

{"sheet":"allocation (ByJimmy)","index":1,"n_rows":157,"n_cols":16,"rows_kept":157}
[null,null,"List length","List length","List length","List length","List length","List length","List length","List length","List length","List length","List length"]
[null,null,2183,2120,2027,1670,1656,1460,856,0,0,0,0]
[]
[null,"Demand of lists",424,8,16,288,236,16,160,0,0,0,0]
[]
[{"$nulls":10},"Note: Demand data is automatically copied from Cut Mode page, no need to input."]
[]
[]
[null,"Min Num in Theory",{"$f":"ROUNDUP(SUMPRODUCT(C2:M2,C4:M4)/E12,0)","v":335}]
[null,"Object func",{"$f":"SUM(O18:O300)","v":364}]
[]
[null,"Total waste",{"$f":"SUMPRODUCT($N$18:$N$300,O18:O300)","v":173881},null,{"$f":"'GenerateCutMode (ByJimmy)'!E12","v":6000},"   Length of stock rod"]
[]
[{"$nulls":8},"Any query, you can contact me by Wechat: zhanriming"]
[]
[]
[null,null,{"$f":"SUMPRODUCT(C18:C300,$O$18:$O$300)","v":425},{"$f":"SUMPRODUCT(D18:D300,$O$18:$O$300)","v":8},16,288,236,16,161,0,0,0,0,"Waste","Num of rod","Num of type"]
[null,"Mode 1",1,0,0,2,0,0,0,0,0,0,0,477,144,{"$f":"COUNTIF(C18:M18,\">0\")","v":2}]
[null,"Mode 2",1,0,1,0,1,0,0,0,0,0,0,134,16,{"$f":"COUNTIF(C19:M19,\">0\")","v":3}]
[null,"Mode 3",1,0,0,0,2,0,0,0,0,0,0,505,106,2]
[null,"Mode 4",1,1,0,0,1,0,0,0,0,0,0,41,8,3]
[null,"Mode 5",1,0,1,1,0,0,0,0,0,0,0,120,0,3]
[null,"Mode 6",1,0,0,0,0,0,4,0,0,0,0,393,29,2]
[null,"Mode 7",1,0,0,0,1,1,0,0,0,0,0,701,0,3]
[null,"Mode 8",1,1,0,0,0,0,1,0,0,0,0,841,0,3]
[null,"Mode 9",0,1,0,0,0,1,2,0,0,0,0,708,0,3]
[null,"Mode 10",0,1,0,2,0,0,0,0,0,0,0,540,0,2]
[null,"Mode 11",0,2,0,0,0,1,0,0,0,0,0,300,0,2]
[null,"Mode 12",1,1,0,0,0,1,0,0,0,0,0,237,0,3]
[null,"Mode 13",0,1,0,0,0,0,4,0,0,0,0,456,0,2]
[null,"Mode 14",0,1,1,0,0,0,2,0,0,0,0,141,0,3]
[null,"Mode 15",0,1,0,0,2,0,0,0,0,0,0,568,0,2]
[null,"Mode 16",0,0,1,0,0,0,4,0,0,0,0,549,0,2]
[null,"Mode 17",0,0,1,0,2,0,0,0,0,0,0,661,0,2]
[null,"Mode 18",0,0,2,0,0,1,0,0,0,0,0,486,0,2]
[null,"Mode 19",0,1,1,0,1,0,0,0,0,0,0,197,0,3]
[null,"Mode 20",0,0,1,2,0,0,0,0,0,0,0,633,0,2]
[null,"Mode 21",0,0,2,1,0,0,0,0,0,0,0,276,0,2]
[null,"Mode 22",0,2,0,1,0,0,0,0,0,0,0,90,0,2]
[null,"Mode 23",1,0,0,1,0,1,0,0,0,0,0,687,0,3]
[null,"Mode 24",0,2,0,0,1,0,0,0,0,0,0,104,0,2]
[null,"Mode 25",0,1,0,1,1,0,0,0,0,0,0,554,0,3]
[null,"Mode 26",0,1,0,0,1,1,0,0,0,0,0,764,0,3]
[null,"Mode 27",0,0,2,0,1,0,0,0,0,0,0,290,0,2]
[null,"Mode 28",0,0,0,2,1,0,1,0,0,0,0,148,0,3]
[null,"Mode 29",0,0,0,0,1,0,5,0,0,0,0,64,0,2]
[null,"Mode 30",1,0,0,1,1,0,0,0,0,0,0,491,0,3]
[null,"Mode 31",2,0,0,0,0,1,0,0,0,0,0,174,16,2]
[null,"Mode 32",0,0,0,0,0,4,0,0,0,0,0,160,0,1]
[null,"Mode 33",0,0,0,3,0,0,1,0,0,0,0,134,0,2]
[null,"Mode 34",0,1,0,0,0,2,1,0,0,0,0,104,0,3]
[null,"Mode 35",0,0,2,0,0,0,2,0,0,0,0,234,0,2]
[null,"Mode 36",2,0,0,0,0,0,1,0,0,0,0,778,45,2]
[null,"Mode 37",0,2,0,0,0,0,2,0,0,0,0,48,0,2]
[null,"Mode 38",0,0,0,0,0,3,1,0,0,0,0,764,0,2]
[null,"Mode 39",{"$nulls":12},0,0]
[null,"Mode 40",{"$nulls":12},0,0]
[null,"Mode 41",{"$nulls":12},0,0]
[null,"Mode 42",{"$nulls":12},0,0]
[null,"Mode 43",{"$nulls":12},0,0]
[null,"Mode 44",{"$nulls":12},0,0]
[null,"Mode 45",{"$nulls":12},0,0]
[null,"Mode 46",{"$nulls":12},0,0]
[null,"Mode 47",{"$nulls":12},0,0]
[null,"Mode 48",{"$nulls":12},0,0]
[null,"Mode 49",{"$nulls":12},0,0]
[null,"Mode 50",{"$nulls":12},0,0]
[null,"Mode 51",{"$nulls":12},0,0]
[null,"Mode 52",{"$nulls":12},0,0]
[null,"Mode 53",{"$nulls":12},0,0]
[null,"Mode 54",{"$nulls":12},0,0]
[null,"Mode 55",{"$nulls":12},0,0]
[null,"Mode 56",{"$nulls":12},0,0]
[null,"Mode 57",{"$nulls":12},0,0]
[null,"Mode 58",{"$nulls":12},0,0]
[null,"Mode 59",{"$nulls":12},0,0]
[null,"Mode 60",{"$nulls":12},0,0]
[null,"Mode 61",{"$nulls":12},0,0]
[null,"Mode 62",{"$nulls":12},0,0]
[null,"Mode 63",{"$nulls":12},0,0]
[null,"Mode 64",{"$nulls":12},0,0]
[null,"Mode 65",{"$nulls":12},0,0]
[null,"Mode 66",{"$nulls":12},0,{"$f":"COUNTIF(C83:M83,\">0\")","v":0}]
[null,"Mode 67",{"$nulls":12},0,0]
[null,"Mode 68",{"$nulls":12},0,0]
[null,"Mode 69",{"$nulls":12},0,0]
[null,"Mode 70",{"$nulls":12},0,0]
[null,"Mode 71",{"$nulls":12},0,0]
[null,"Mode 72",{"$nulls":12},0,0]
[null,"Mode 73",{"$nulls":12},0,0]
[null,"Mode 74",{"$nulls":12},0,0]
[null,"Mode 75",{"$nulls":12},0,0]
[null,"Mode 76",{"$nulls":12},0,0]
[null,"Mode 77",{"$nulls":12},0,0]
[null,"Mode 78",{"$nulls":12},0,0]
[null,"Mode 79",{"$nulls":12},0,0]
[null,"Mode 80",{"$nulls":12},0,0]
[null,"Mode 81",{"$nulls":12},0,0]
[null,"Mode 82",{"$nulls":12},0,0]
[null,"Mode 83",{"$nulls":12},0,0]
[null,"Mode 84",{"$nulls":12},0,0]
[null,"Mode 85",{"$nulls":12},0,0]
[null,"Mode 86",{"$nulls":12},0,0]
[null,"Mode 87",{"$nulls":12},0,0]
[null,"Mode 88",{"$nulls":12},0,0]
[null,"Mode 89",{"$nulls":12},0,0]
[null,"Mode 90",{"$nulls":12},0,0]
[null,"Mode 91",{"$nulls":12},0,0]
[null,"Mode 92",{"$nulls":12},0,0]
[null,"Mode 93",{"$nulls":12},0,0]
[null,"Mode 94",{"$nulls":12},0,0]
[null,"Mode 95",{"$nulls":12},0,0]
[null,"Mode 96",{"$nulls":12},0,0]
[null,"Mode 97",{"$nulls":12},0,0]
[null,"Mode 98",{"$nulls":12},0,0]
[null,"Mode 99",{"$nulls":12},0,0]
[null,"Mode 100",{"$nulls":12},0,0]
[null,"Mode 101",{"$nulls":12},0,0]
[null,"Mode 102",{"$nulls":13},0]
[null,"Mode 103",{"$nulls":13},0]
[null,"Mode 104",{"$nulls":13},0]
[null,"Mode 105",{"$nulls":13},0]
[null,"Mode 106",{"$nulls":13},0]
[null,"Mode 107",{"$nulls":13},0]
[null,"Mode 108",{"$nulls":13},0]
[null,"Mode 109",{"$nulls":13},0]
[null,"Mode 110",{"$nulls":13},0]
[null,"Mode 111",{"$nulls":13},0]
[null,"Mode 112",{"$nulls":13},0]
[null,"Mode 113",{"$nulls":13},0]
[null,"Mode 114",{"$nulls":13},0]
[null,"Mode 115",{"$nulls":13},0]
[null,"Mode 116",{"$nulls":13},0]
[null,"Mode 117",{"$nulls":13},0]
[null,"Mode 118",{"$nulls":13},0]
[null,"Mode 119",{"$nulls":13},0]
[null,"Mode 120",{"$nulls":13},0]
[null,"Mode 121",{"$nulls":13},0]
[null,"Mode 122",{"$nulls":13},0]
[null,"Mode 123",{"$nulls":13},0]
[null,"Mode 124",{"$nulls":13},0]
[null,"Mode 125",{"$nulls":13},0]
[null,"Mode 126",{"$nulls":13},0]
[null,"Mode 127",{"$nulls":13},0]
[null,"Mode 128",{"$nulls":13},0]
[null,"Mode 129",{"$nulls":13},0]
[null,"Mode 130",{"$nulls":13},{"$f":"COUNTIF(C147:M147,\">0\")","v":0}]
[null,"Mode 131",{"$nulls":13},0]
[null,"Mode 132",{"$nulls":13},0]
[null,"Mode 133",{"$nulls":13},0]
[null,"Mode 134"]
[null,"Mode 135"]
[null,"Mode 136"]
[null,"Mode 137"]
[null,"Mode 138"]
[null,"Mode 139"]
[null,"Mode 140"]