{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Solver_suboptimal","All_in_one_go","Macro_walk_through"],"not_rendered":{"macros":1,"defined_names":72},"read":"whole","date_system":"1900"}

{"sheet":"Solver_suboptimal","index":0,"n_rows":397,"n_cols":24,"rows_kept":397}
[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":4},424,8,16,288,236,16,160]
[]
[null,"Solver result"]
[]
[null,"Target demand",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C8:M8)","v":0}]
[]
[null,"Object func",{"$f":"F12-SUMPRODUCT(C2:M2,C6:M6)","v":6000}]
[]
[null,"constr 3",{"$f":"SUMPRODUCT(C2:M2,C6:M6)","v":0},null,"    =< ",6000,"   Length of stock rod"]
[]
[]
[]
[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,"Solver result",{"$f":"C2","v":2183},{"$f":"D2","v":2120},2027,1670,1656,1460,856,0,0,0,0,null,"Waste"]
[null,"Rod nr 1",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 2",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 3",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 4",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 5",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 6",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 7",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 8",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 9",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 10",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 11",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 12",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 13",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 14",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 15",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 16",0,0,1,0,1,1,1,0,0,0,0,null,1]
[null,"Rod nr 17",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 18",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 19",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 20",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 21",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 22",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 23",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 24",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 25",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 26",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 27",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 28",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 29",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 30",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 31",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 32",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 33",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 34",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 35",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 36",0,0,0,0,0,0,7,0,0,0,0,null,8]
[null,"Rod nr 37",1,1,0,1,0,0,0,0,0,0,0,null,27]
[null,"Rod nr 38",1,1,0,1,0,0,0,0,0,0,0,null,27]
[null,"Rod nr 39",1,1,0,1,0,0,0,0,0,0,0,null,27]
[null,"Rod nr 40",1,1,0,1,0,0,0,0,0,0,0,null,27]
[null,"Rod nr 41",1,1,0,1,0,0,0,0,0,0,0,null,27]
[null,"Rod nr 42",1,1,0,1,0,0,0,0,0,0,0,null,27]
[null,"Rod nr 43",1,1,0,1,0,0,0,0,0,0,0,null,27]
[null,"Rod nr 44",1,1,0,1,0,0,0,0,0,0,0,null,27]
[null,"Rod nr 45",0,0,0,2,0,0,3,0,0,0,0,null,92]
[null,"Rod nr 46",0,0,0,3,0,0,1,0,0,0,0,null,134]
[null,"Rod nr 47",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 48",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 49",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 50",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 51",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 52",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 53",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 54",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 55",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 56",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 57",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 58",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 59",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 60",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 61",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 62",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 63",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 64",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 65",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 66",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 67",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 68",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 69",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 70",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 71",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 72",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 73",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 74",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 75",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 76",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 77",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 78",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 79",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 80",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 81",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 82",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 83",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 84",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 85",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 86",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 87",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 88",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 89",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 90",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 91",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 92",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 93",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 94",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 95",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 96",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 97",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 98",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 99",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 100",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 101",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 102",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 103",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 104",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 105",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 106",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 107",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 108",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 109",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 110",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 111",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 112",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 113",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 114",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 115",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 116",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 117",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 118",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 119",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 120",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 121",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 122",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 123",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 124",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 125",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 126",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 127",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 128",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 129",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 130",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 131",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 132",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 133",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 134",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 135",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 136",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 137",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 138",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 139",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 140",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 141",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 142",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 143",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 144",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 145",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 146",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 147",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 148",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 149",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 150",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 151",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 152",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 153",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 154",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 155",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 156",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 157",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 158",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 159",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 160",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 161",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 162",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 163",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 164",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 165",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 166",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 167",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 168",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 169",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 170",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 171",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 172",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 173",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 174",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 175",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 176",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 177",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 178",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 179",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 180",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 181",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 182",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 183",1,0,0,2,0,0,0,0,0,0,0,null,477]
[null,"Rod nr 184",1,0,0,1,1,0,0,0,0,0,0,null,491]
[null,"Rod nr 185",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 186",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 187",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 188",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 189",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 190",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 191",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 192",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 193",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 194",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 195",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 196",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 197",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 198",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 199",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 200",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 201",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 202",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 203",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 204",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 205",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 206",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 207",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 208",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 209",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 210",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 211",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 212",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 213",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 214",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 215",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 216",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 217",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 218",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 219",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 220",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 221",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 222",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 223",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 224",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 225",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 226",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 227",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 228",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 229",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 230",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 231",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 232",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 233",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 234",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 235",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 236",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 237",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 238",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 239",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 240",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 241",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 242",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 243",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 244",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 245",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 246",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 247",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 248",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 249",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 250",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 251",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 252",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 253",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 254",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 255",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 256",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 257",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 258",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 259",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 260",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 261",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 262",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 263",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 264",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 265",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 266",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 267",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 268",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 269",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 270",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 271",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 272",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 273",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 274",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 275",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 276",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 277",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 278",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 279",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 280",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 281",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 282",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 283",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 284",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 285",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 286",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 287",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 288",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 289",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 290",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 291",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 292",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 293",1,0,0,0,2,0,0,0,0,0,0,null,505]
[null,"Rod nr 294",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 295",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 296",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 297",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 298",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 299",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 300",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 301",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 302",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 303",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 304",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 305",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 306",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 307",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 308",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 309",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 310",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 311",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 312",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 313",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 314",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 315",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 316",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 317",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 318",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 319",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 320",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 321",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 322",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 323",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 324",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 325",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 326",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 327",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 328",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 329",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 330",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 331",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 332",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 333",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 334",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 335",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 336",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 337",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 338",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 339",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 340",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 341",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 342",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 343",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 344",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 345",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 346",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 347",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 348",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 349",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 350",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 351",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 352",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 353",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 354",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 355",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 356",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 357",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 358",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 359",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 360",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 361",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 362",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 363",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 364",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 365",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 366",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 367",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 368",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 369",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 370",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 371",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 372",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 373",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 374",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 375",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 376",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 377",2,0,0,0,0,0,0,0,0,0,0,null,1634]
[null,"Rod nr 378",1,0,0,0,1,0,0,0,0,0,0,null,2161]
[]
[null,"Total",{"$f":"SUM(C18:C395)","v":424},{"$f":"SUM(D18:D395)","v":8},16,288,236,16,160,0,0,0,0,"   Total wastage",{"$f":"SUM(O18:O395)","v":260920}]

{"sheet":"All_in_one_go","index":1,"n_rows":61,"n_cols":13,"rows_kept":61}
[]
[{"$nulls":3},"List length","List length","List length","List length","List length","List length","List length","Waste","Number","Totale"]
[null,6000,null,2183,2120,2027,1670,1656,1460,856,"pr rod","of Rods","wast"]
[null,null,"Cut 1",{"$f":"2*L4","v":32},{"$nulls":4},{"$f":"1*L4","v":16},null,{"$f":"IF(L4=0,0,$B$3-2*$D$3-1*$I$3)","v":174},16,{"$f":"L4*K4","v":2784}]
[null,null,"Cut 2",{"$f":"2*L5","v":172},{"$nulls":5},{"$f":"1*L5","v":86},{"$f":"IF(L5=0,0,$B$3-2*$D$3-1*$J$3)","v":778},86,{"$f":"L5*K5","v":66908}]
[null,null,"Cut 3",{"$f":"1*L6","v":8},{"$f":"1*L6","v":8},null,{"$f":"1*L6","v":8},{"$nulls":3},{"$f":"IF(L6=0,0,$B$3-$D$3-$E$3-$G$3)","v":27},8,{"$f":"L6*K6","v":216}]
[null,null,"Cut 4",14,null,{"$f":"1*L7","v":14},{"$f":"1*L7","v":14},{"$nulls":3},{"$f":"IF(L7=0,0,$B$3-$D$3-$F$3-$G$3)","v":120},14,{"$f":"L7*K7","v":1680}]
[null,null,"Cut 5",0,null,null,{"$f":"2*L8","v":0},{"$nulls":3},{"$f":"IF(L8=0,0,$B$3-$D$3-$G$3*2)","v":0},0,0]
[null,null,"Cut 6",198,null,null,{"$f":"1*L9","v":198},{"$f":"1*L9","v":198},null,null,{"$f":"IF(L9=0,0,$B$3-$D$3-$G$3-$H$3)","v":491},198,97218]
[null,null,"Cut 7",0,null,null,{"$f":"1*L10","v":0},null,{"$f":"1*L10","v":0},null,{"$f":"IF(L10=0,0,$B$3-$D$3-$G$3-$I$3)","v":0},0,0]
[null,null,"Cut 8",0,null,null,{"$f":"1*L11","v":0},null,null,{"$f":"2*L11","v":0},{"$f":"IF(L11=0,0,$B$3-$D$3-$G$3-$J$3*2)","v":0},0,0]
[null,null,"Cut 9",0,{"$nulls":3},{"$f":"2*L12","v":0},null,null,{"$f":"IF(L12=0,0,$B$3-$D$3-$H$3*2)","v":0},0,0]
[null,null,"Cut 10",0,{"$nulls":3},{"$f":"1*L13","v":0},{"$f":"1*L13","v":0},null,{"$f":"IF(L13=0,0,$B$3-$D$3-$H$3-$I$3)","v":0},0,0]
[null,null,"Cut 11",0,{"$nulls":4},{"$f":"2*L14","v":0},{"$f":"1*L14","v":0},{"$f":"IF(L14=0,0,$B$3-$D$3-$I$3*2-J3)","v":0},0,0]
[null,null,"Cut 12",0,{"$nulls":4},{"$f":"1*L15","v":0},{"$f":"2*L15","v":0},{"$f":"IF(L15=0,0,$B$3-$D$3-$I$3-$J$3*2)","v":0},0,0]
[null,null,"Cut 13",0,{"$nulls":5},{"$f":"4*L16","v":0},{"$f":"IF(L16=0,0,$B$3-$D$3-$J$3*4)","v":0},0,0]
[null,null,"Cut 14",null,{"$f":"2*L17","v":0},null,{"$f":"1*L17","v":0},{"$nulls":3},{"$f":"IF(L17=0,0,$B$3-$E$3*2-$G$3)","v":0},0,0]
[null,null,"Cut 15",null,{"$f":"2*L18","v":0},null,null,{"$f":"1*L18","v":0},null,null,{"$f":"IF(L18=0,0,$B$3-$E$3*2-$H$3)","v":0},0,0]
[null,null,"Cut 16",null,{"$f":"2*L19","v":0},{"$nulls":3},{"$f":"1*L19","v":0},null,{"$f":"IF(L19=0,0,$B$3-$E$3*2-$I$3)","v":0},0,0]
[null,null,"Cut 17",null,{"$f":"2*L20","v":0},{"$nulls":4},{"$f":"2*L20","v":0},{"$f":"IF(L20=0,0,$B$3-$E$3*2-$J$3*2)","v":0},0,0]
[null,null,"Cut 18",null,{"$f":"1*L21","v":0},{"$f":"1*L21","v":0},{"$f":"1*L21","v":0},{"$nulls":3},{"$f":"IF(L21=0,0,$B$3-$E$3-$F$3-$G$3)","v":0},0,0]
[null,null,"Cut 19",null,0,null,{"$f":"2*L22","v":0},{"$nulls":3},{"$f":"IF(L22=0,0,$B$3-$E$3-$G$3*2)","v":0},0,0]
[null,null,"Cut 20",null,0,null,{"$f":"1*L23","v":0},{"$f":"1*L23","v":0},null,null,{"$f":"IF(L23=0,0,$B$3-$E$3-$G$3-$H$3)","v":0},0,0]
[null,null,"Cut 21",null,0,null,{"$f":"1*L24","v":0},null,{"$f":"1*L24","v":0},null,{"$f":"IF(L24=0,0,$B$3-$E$3-$G$3-$I$3)","v":0},0,0]
[null,null,"Cut 22",null,0,null,{"$f":"1*L25","v":0},null,null,{"$f":"2*L25","v":0},{"$f":"IF(L25=0,0,$B$3-$E$3-$G$3-$J$3*2)","v":0},0,0]
[null,null,"Cut 23",null,0,null,null,{"$f":"1*L26","v":0},null,{"$f":"2*L26","v":0},{"$f":"IF(L26=0,0,$B$3-$E$3-$H$3-$J$3*2)","v":0},0,0]
[null,null,"Cut 24",null,0,{"$nulls":3},{"$f":"2*L27","v":0},{"$f":"1*L27","v":0},{"$f":"IF(L27=0,0,$B$3-$E$3-$I$3*2-$J$3)","v":0},0,0]
[null,null,"Cut 25",null,0,{"$nulls":3},{"$f":"1*L28","v":0},{"$f":"2*L28","v":0},{"$f":"IF(L28=0,0,$B$3-$E$3-$I$3-$J$3*2)","v":0},0,0]
[null,null,"Cut 26",null,0,{"$nulls":4},{"$f":"4*L29","v":0},{"$f":"IF(L29=0,0,$B$3-$E$3-$J$3*4)","v":0},0,0]
[null,null,"Cut 27",null,null,{"$f":"2*L30","v":0},{"$f":"1*L30","v":0},{"$nulls":3},{"$f":"IF(L30=0,0,$B$3-$F$3*2-$G$3)","v":0},0,0]
[null,null,"Cut 28",null,null,{"$f":"1*L31","v":0},{"$f":"2*L31","v":0},{"$nulls":3},{"$f":"IF(L31=0,0,$B$3-$F$3-$G$3*2)","v":0},0,0]
[null,null,"Cut 29",null,null,1,{"$f":"1*L32","v":1},{"$nulls":3},{"$f":"IF(L32=0,0,$B$3-$F$3-$G$3-$H$3)","v":647},1,647]
[null,null,"Cut 30",null,null,1,null,{"$f":"2*L33","v":2},null,null,{"$f":"IF(L33=0,0,$B$3-$F$3-$H$3*2)","v":661},1,661]
[null,null,"Cut 31",null,null,0,null,{"$f":"1*L34","v":0},{"$f":"1*L34","v":0},{"$f":"1*M34","v":0},{"$f":"IF(L34=0,0,$B$3-$F$3-$H$3-$I$3-$J$3)","v":0},0,0]
[null,null,"Cut 32",null,null,0,null,null,{"$f":"2*L35","v":0},{"$f":"1*L35","v":0},{"$f":"IF(L35=0,0,$B$3-$F$3-$I$3*2-$J$3)","v":0},0,0]
[null,null,"Cut 33",null,null,0,null,null,{"$f":"1*L36","v":0},{"$f":"2*L36","v":0},{"$f":"IF(L36=0,0,$B$3-$F$3-$I$3-$J$3*2)","v":0},0,0]
[null,null,"Cut 34",null,null,0,{"$nulls":3},{"$f":"4*L37","v":0},{"$f":"IF(L37=0,0,$B$3-$F$3-$J$3*4)","v":0},0,0]
[null,null,"Cut 35",{"$nulls":3},{"$f":"3*L38","v":66},null,null,{"$f":"1*L38","v":22},{"$f":"IF(L38=0,0,$B$3-$G$3*3-$J$3)","v":134},22,2948]
[null,null,"Cut 36",{"$nulls":3},{"$f":"2*L39","v":0},{"$f":"1*L39","v":0},null,{"$f":"1*L39","v":0},{"$f":"IF(L39=0,0,$B$3-$G$3*2-$H$3-$J$3)","v":0},0,0]
[null,null,"Cut 37",{"$nulls":3},{"$f":"2*L40","v":0},null,{"$f":"1*L40","v":0},{"$f":"1*L40","v":0},{"$f":"IF(L40=0,0,$B$3-$G$3*2-$I$3-$J$3)","v":0},0,0]
[null,null,"Cut 38",{"$nulls":3},{"$f":"2*L41","v":0},null,null,{"$f":"3*L41","v":0},{"$f":"IF(L41=0,0,$B$3-$G$3*2-$J$3*3)","v":0},0,0]
[null,null,"Cut 39",{"$nulls":3},{"$f":"1*L42","v":1},{"$f":"2*L42","v":2},null,{"$f":"1*L42","v":1},{"$f":"IF(L42=0,0,$B$3-$G$3-$H$3*2-$J$3)","v":162},1,162]
[null,null,"Cut 40",{"$nulls":3},{"$f":"1*L43","v":0},{"$f":"1*L43","v":0},{"$f":"1*L43","v":0},{"$f":"1*L43","v":0},{"$f":"IF(L43=0,0,$B$3-$G$3-$H$3-$I$3-$J$3)","v":0},0,0]
[null,null,"Cut 41",{"$nulls":4},{"$f":"3*L44","v":0},null,{"$f":"1*L44","v":0},{"$f":"IF(L44=0,0,$B$3-$H$3*3-$J$3)","v":0},0,0]
[null,null,"Cut 42",{"$nulls":4},{"$f":"2*L45","v":0},{"$f":"1*L45","v":0},{"$f":"1*L45","v":0},{"$f":"IF(L45=0,0,$B$3-$H$3*2-$I$3-$J$3)","v":0},0,0]
[null,null,"Cut 43",{"$nulls":4},{"$f":"2*L46","v":34},null,{"$f":"3*L46","v":51},{"$f":"IF(L46=0,0,$B$3-$H$3*2-$J$3*3)","v":120},17,2040]
[null,null,"Cut 44",{"$nulls":4},{"$f":"1*L47","v":0},{"$f":"2*L47","v":0},{"$f":"1*L47","v":0},{"$f":"IF(L47=0,0,$B$3-$H$3-$I$3*2-$J$3)","v":0},0,0]
[null,null,"Cut 45",{"$nulls":4},{"$f":"1*L48","v":0},{"$f":"1*L48","v":0},{"$f":"3*L48","v":0},{"$f":"IF(L48=0,0,$B$3-$H$3-$I$3-$J$3*3)","v":0},0,0]
[null,null,"Cut 46",{"$nulls":4},{"$f":"1*L49","v":0},null,{"$f":"5*L49","v":0},{"$f":"IF(L49=0,0,$B$3-$H$3-$J$3*5)","v":0},0,0]
[null,null,"Cut 47",{"$nulls":5},{"$f":"4*L50","v":0},null,{"$f":"IF(L50=0,0,$B$3-$I$3*4-$J$3*0)","v":0},0,0]
[null,null,"Cut 48",{"$nulls":5},{"$f":"3*L51","v":0},{"$f":"1*L51","v":0},{"$f":"IF(L51=0,0,$B$3-$I$3*3-$J$3)","v":0},0,0]
[null,null,"Cut 49",{"$nulls":5},{"$f":"2*L52","v":0},{"$f":"3*L52","v":0},{"$f":"IF(L52=0,0,$B$3-$I$3*2-$J$3*3)","v":0},0,{"$f":"L52*K52","v":0}]
[null,null,"Cut 50",{"$nulls":5},{"$f":"1*L53","v":0},{"$f":"5*L53","v":0},{"$f":"IF(L53=0,0,$B$3-$I$3-$J$3*5)","v":0},0,{"$f":"L53*K53","v":0}]
[null,null,"Cut 51",{"$nulls":6},{"$f":"7*L54","v":0},{"$f":"IF(L54=0,0,$B$3-$J$3*7)","v":0},0,0]
[null,"Solver total",null,{"$f":"SUM(D4:D54)","v":424},{"$f":"SUM(E4:E54)","v":8},16,288,236,16,160,3314,364,175264]
[]
[null,"Demand",null,424,8,16,288,236,16,160]
[]
[null,"Excess",null,{"$f":"D55-D57","v":0},{"$f":"E55-E57","v":0},0,0,0,0,0]
[]
[null,"Total Wastage",null,{"$f":"M55","v":175264}]

{"sheet":"Macro_walk_through","index":2,"n_rows":86,"n_cols":10,"rows_kept":86}
[]
[]
[null,"Option Explicit",{"$nulls":7},"This tells Excel all variables should be defined"]
[]
[null,"Sub SolverLoop()",{"$nulls":7},"Macros start with the Sub command, then text and parentheses"]
[null,"Dim i As Integer",{"$nulls":7},"Dim i, declare i as an integer"]
[null,"Dim cell As Range",{"$nulls":7},"Declare cell as a range"]
[]
[null,"i = Range(\"B\" & Rows.Count).End(xlUp).Row",{"$nulls":7},"Count the rows in the B column going from bottom of spreadsheet to first row with a value or text or a blank signs and i will be the row number of this cell. "]
[]
[null,"If i <= 17 Then",{"$nulls":7},"If i <= 17 tells macro what to do if this condition exists"]
[{"$nulls":9},"as there is no command macro does nothing."]
[null,"    Else",{"$nulls":7},"Else tells macro there is a command coming next."]
[]
[null,"        Range(\"B18:P\" & i).Clear",{"$nulls":7},"Macro is told to clear range B8:P & i"]
[null,"        "]
[null,"End If",{"$nulls":7},"End If command must always follows after an If command to mark the end of it."]
[]
[null,"Range(\"C4:M4\").Copy",{"$nulls":7},"Copy C4:M4"]
[]
[null,"Range(\"C8\").PasteSpecial xlPasteValues",{"$nulls":7},"To C8 and only the values from range C4:M4. This is the number of all lists that should be made in order to meet the specified demand"]
[]
[null,"Application.CutCopyMode = False",{"$nulls":7},"This will stop the \"marching ants\" from the range macro copied from."]
[]
[null,"Range(\"B17\") = \"Solver result\"",{"$nulls":7},"Write text \"Solver result\" to cell B17"]
[]
[null,"Range(\"O17\") = \"Waste\"",{"$nulls":7},"Write text \"Waste\" to cell O17"]
[]
[null,"i = 1",{"$nulls":7},"Whatever i was before it no shall be 1"]
[]
[null,"Application.ScreenUpdating = False",{"$nulls":7},"Freeze screen so there is no flickering,"]
[]
[null,"Do Until Range(\"O8\") = 0",{"$nulls":7},"This is the start of a Loop command add repeat the loop until cell O8 is 0. At the start the cell value of O8 is 1148 i.e. summing of all lists that should be made."]
[]
[null,"SolverReset",{"$nulls":7},"As solver is run in a loop it's a good idea to clear solver between each run."]
[null,"    SolverOk SetCell:=\"$C$10\", MaxMinVal:=2, ByChange:=\"$C$6:$M$6\", Engine:=2",{"$nulls":7},"Solver is told target cell C10 shall be set to minimum by changing cells in range C6:M6 and use the simplex lp engine."]
[null,"    SolverAdd CellRef:=\"$C$6:$M$6\", Relation:=4, FormulaText:=\"integer\"\"\"",{"$nulls":7},"The cells in C6:M6 shall be integers."]
[null,"    SolverAdd CellRef:=\"$C$6:$M$6\", Relation:=1, FormulaText:=\"$C$8:$M$8\"",{"$nulls":7},"cells in range C6:M6 should be equal to or less than cells in range C8:M8"]
[null,"    SolverAdd CellRef:=\"$C$12\", Relation:=1, FormulaText:=\"$F$12\"",{"$nulls":7},"cell C12 should be equal to or less than cell F12"]
[null,"    SolverSolve UserFinish:=True",{"$nulls":7},"Don't stop and show the solver result window keep on going"]
[null,"    "]
[null,"    Range(\"C10\").Copy",{"$nulls":7},"Copy result from C10 (waste)"]
[null,"    "]
[null,"    Range(\"O\" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues",{"$nulls":7},"and find the first cell in column O with value (O17) and paste the C10 value one row below that. This is the offset command. The first value is the row offset, the second is the column offset."]
[]
[null,"    Range(\"B\" & Rows.Count).End(xlUp).Offset(1, 0) = \"Rod nr\" & \" \" & i",{"$nulls":7},"Then macro writes text in the B column \"Rod nr\" and i value starting as 1"]
[null,"    "]
[null,"    Range(\"C6:M6\").Copy",{"$nulls":7},"The solver result in range C6:M6 are copied "]
[null,"    "]
[null,"    Range(\"B\" & Rows.Count).End(xlUp).Offset(0, 1).PasteSpecial xlPasteAll",{"$nulls":7},"Pasting the values are to the first row in the B column with an offset(0, 1) which means that the values are copied to the C column."]
[null,"    "]
[null,"    Range(\"C8\").PasteSpecial Paste:=xlPasteAll, Operation:=xlSubtract",{"$nulls":7},"Finally the value are copied to cell C8 and the values are subtracted from the previous values in range C8:M8"]
[null,"    "]
[null,"    Range(\"C6:M6\").ClearContents",{"$nulls":7},"The range C6:M6 with result from the solver run is cleared"]
[null,"    "]
[null,"    Application.CutCopyMode = False",{"$nulls":7},"This will stop the \"marching ants\" from the range macro copied from."]
[null,"    "]
[null,"    i = i + 1",{"$nulls":7},"The i value are increased with 1 unit."]
[null,"    "]
[null,"    Loop",{"$nulls":7},"This command makes the macro jump back to the \"Do until Range(\"$O$8\") = 0\" line"]
[null,"    "]
[null,"    Range(\"B\" & i + 18) = \"Total\"",{"$nulls":7},"Setting text to cell. As the first value is written to row 18 and i starts at 1 and increases with 1 for every loop made the sum of i + 18 will be the final row where \"Total\" shall be written."]
[null,"    "]
[null,"    Range(\"C\" & i + 18).Formula = \"=Sum(C18:C\" & i + 16 & \")\"",{"$nulls":7},"Building a sum formula in cell"]
[null,"    "]
[null,"    Range(\"C\" & i + 18).Copy",{"$nulls":7},"Copy formula"]
[null,"    "]
[null,"    Range(\"D\" & i + 18 & \":M\" & i + 18).PasteSpecial xlPasteFormulas",{"$nulls":7},"and pasting it to a range"]
[null,"    "]
[null,"    Range(\"O\" & i + 18).PasteSpecial xlPasteFormulas",{"$nulls":7},"and a cell in the O column"]
[null,"    "]
[null,"    Range(\"O18:O\" & i + 18).HorizontalAlignment = xlCenter",{"$nulls":7},"Centering values in O column"]
[null,"    "]
[null,"    Range(\"N\" & i + 18) = \"   Total wastage\"",{"$nulls":7},"Adding more text"]
[null,"    "]
[null,"    Range(\"C\" & i + 18 & \":M\" & i + 18).HorizontalAlignment = xlCenter",{"$nulls":7},"Centering values in C to M column"]
[null,"    "]
[null,"    Application.CutCopyMode = False",{"$nulls":7},"Stop the \"marching ants\" from the range macro copied from."]
[null,"    "]
[null,"    Range(\"B18:B\" & Range(\"B\" & Rows.Count).End(xlUp).Row).Font.Bold = True",{"$nulls":7},"Setting B column to Bold"]
[null,"    "]
[null,"    Range(\"C\" & i + 18 & \":P\" & i + 18).Font.Bold = True",{"$nulls":7},"Setting range C:P columns to Bold"]
[null,"    "]
[null,"Application.ScreenUpdating = True",{"$nulls":7},"Unlock screen"]
[]
[null,"End Sub",{"$nulls":7},"End of macro"]