Spreadsheet: 119245d1314283221-optimize-rod-cut-lengths-rod-order
Sheet: Sheet1

Part # | Quantity | Length (in) |  |  | total qty: |  | rods
m1000 | 4 | 104 |  |  | shortest: |  | in
m1002 | 4 | 106.375 |  |  | longest: |  | in
m1003 | 4 | 106.875 |  |  | ave: |  | in
m1004 | 4 | 107.4375
m1005 | 4 | 107.9375 |  |  | stock length: |  | in (32ft)
m1006 | 4 | 108.5 |  |  | min rods:
m1007 | 4 | 109
m1008 | 4 | 108.75 |  |  | Desired output:
m1009 | 4 | 110.9375
m1010 | 4 | 111.4375 |  |  | 1 | Minimum number of stock rods required:(#)
m1011 | 4 | 106.4375 |  |  | 2 | Amount of scrap :(ft or in)
m1012 | 4 | 109.25 |  |  | 3 | If possible, lists of which part numbers get cut from each stock rod, so I can do this in real life
m1013 | 4 | 109.8125
m1014 | 4 | 110.375
m1015 | 1 | 114 |  |  |  | (if it makes it easier, we can round each rod up to the nearest inch, to have fewer bins?)
m1016 | 4 | 116.25
m1017 | 4 | 116.875
m1019 | 4 | 114.5625
m1020 | 4 | 115.125
m1021 | 4 | 115.6875
m1022 | 2 | 114
m1023 | 2 | 111.6875
m1134 | 1 | 111.6875
m1135 | 1 | 114
m1069 | 1 | 86.25
m1070 | 1 | 88.875
m1071 | 1 | 89.3125
m1072 | 1 | 89.75
m1073 | 1 | 90.1875
m1074 | 1 | 90.625
m1075 | 1 | 91.0625
m1001 | 143 | 64.1875
m1024 | 13 | 61.125
1018A | 2 | 116.825
1023A | 2 | 116.25
1026A | 2 | 115.6875
1030A | 2 | 115.125
1035A | 2 | 114.5
1038A | 2 | 113.9375
1040A | 2 | 111.75
1054A | 2 | 111.4375
1057A | 2 | 110.875
1060A | 2 | 110.3125
1063A | 2 | 109.1875
1068A | 2 | 109.25
1070A | 2 | 108.6875
1072A | 2 | 106.4375
1090A | 1 | 109
1093A | 1 | 108.4375
1096A | 1 | 107.9375
1099A | 1 | 107.375
1102A | 1 | 106.875
1105A | 1 | 106.3125
1107A | 1 | 104
1117A | 1 | 109
1120A | 1 | 108.5
1123A | 1 | 107.9675
1127A | 1 | 107.5
1129A | 1 | 106.8125
1131A | 1 | 106.375
1134A | 1 | 104
1143A | 1 | 109.0625
1145A | 1 | 108.5
1147A | 1 | 107.9375
1149A | 1 | 107.4375
1151A | 1 | 106.9375
1154A | 1 | 106.4375
1156A | 1 | 104.0625
1165A | 1 | 109
1167A | 1 | 108.4375
1169A | 1 | 107.9375
1171A | 1 | 107.375
1172A | 1 | 106.875
1174A | 1 | 106.3125
1175A | 1 | 104
1183A | 2 | 111.4375
1185A | 2 | 110.875
1187A | 2 | 110.3125
1189A | 2 | 109.8125
1191A | 2 | 109.25
1193A | 2 | 108.6875
1194A | 2 | 106.4375
1211A | 2 | 116.8125
1213A | 2 | 116.25
1215A | 2 | 115.6875
1217A | 2 | 115.0625
1218A | 2 | 114.5
1220A | 2 | 113.9375
1221A | 2 | 111.75
1235A | 1 | 96.8125
1237A | 1 | 96.375
1239A | 1 | 95.875
1241A | 1 | 95.4375
1243A | 1 | 94.9375
1245A | 1 | 94.5
1246A | 1 | 92
1263A | 1 | 90.4375
1265A | 1 | 90
1266A | 1 | 53.75
1269A | 1 | 89.5625
1271A | 1 | 89.1875
1273A | 1 | 79.5
1274A | 1 | 88.75
1247A | 1 | 193.6875
1248A | 1 | 192.875
1249A | 1 | 191.9375
1250A | 1 | 191.0625
1251A | 1 | 190.1875
1252A | 1 | 189.3125
1253A | 1 | 182.8125
1100A | 1 | 212.9375
1126A | 1 | 213
1161A | 1 | 213
1179A | 1 | 212.9375
1222A | 1 | 227.5625
1014A | 2 | 239.625
1017A | 2 | 238.4375
1022A | 2 | 237.3125
1025A | 2 | 236.125
1029A | 2 | 235
1034A | 2 | 227.875
1036A | 1 | 228.4375
1044A | 1 | 222.4375
1050A | 1 | 222.8125
1052A | 2 | 227.75
1055A | 1 | 226.625
1058A | 2 | 225.5
1061A | 2 | 224.5
1064A | 1 | 223.375
1067A | 1 | 217.75
1074A | 1 | 228.8125
1075A | 1 | 227.75
1076A | 1 | 226.625
1077A | 1 | 225.5
1078A | 1 | 224.5
1079A | 1 | 223.375
1080A | 1 | 217.75
1086A | 1 | 222.875
1088A | 1 | 221.8125
1091A | 2 | 220.75
1094A | 2 | 219.6875
1097A | 1 | 218.625
1111A | 1 | 224
1113A | 1 | 219.9375
1115A | 1 | 221.875
1118A | 1 | 220.75
1121A | 1 | 219.75
1124A | 1 | 218.625
1140A | 1 | 223.875
1152A | 1 | 224
1155A | 1 | 222.9375
1157A | 1 | 221.875
1158A | 1 | 220.75
1159A | 1 | 219.6875
1160A | 1 | 218.625
1176A | 1 | 222.8125
1177A | 1 | 221.8125
1178A | 1 | 218.625
1195A | 1 | 228.8125
1197A | 1 | 227.75
1198A | 1 | 226.625
1199A | 1 | 225.5
1200A | 1 | 224.5
1201A | 1 | 223.375
1202A | 1 | 217.75
1205A | 1 | 226.625
1206A | 1 | 223.375
1207A | 1 | 217.75
1223A | 1 | 239.0625
1224A | 2 | 237.3125
1225A | 2 | 236.1875
1226A | 2 | 233.875
1227A | 1 | 228.4375
1234A | 1 | 228.4375
1277A | 1 | 223.9375
1283A | 1 | 232.5625
1284A | 1 | 235.1875
1285A | 1 | 239.75
1286A | 1 | 235.0625
1291A | 1 | 239.625
1292A | 1 | 238.5
1293A | 1 | 235.125
1294A | 1 | 227.875
1295A | 1 | 225.625
1296A | 1 | 224.5625
1298A | 1 | 220.75
1299A | 1 | 219.625
1301A | 1 | 237.4375
1302A | 1 | 236.5
1303A | 1 | 233.97