Had a look at your result and as your manual results are much better than both excel solver and "OpenSolver" there can be no doubt that you should stick to your manual method.
So the conclusion is that you do have the best method for calculating list cutting with a minimum of loss. Care to post your setup?
I did a bit of fiddling with your last uploaded file. I started by setting list of length 856 and 1460 to 0 and found a solution for this setup using 367 rods.
The wastage list after that run looked like this:
awast_1.jpg
I then wrote a macro like this in order to add the the 16 lists with a length of 1460.
This added the required 16 lists in cell D4, so the wastage looked like this after an update.
awast_2.jpg
For the final macro making 160 lists of a length 856 I wrote this macro.
Problem with this macro it picks the waste where it finds it as it works its way along the row, could of course have made to macros. One for 154 pieces in the range 990 to 1634 and finally one for 6 pieces of the 2147 waste.
But still with 367 rods "OpenSolver" only managed to come second best as 364 is the winning number!!!
awast_3.jpg
So this should be the end of this thread unless you care to post you manual setup (and much better method superior to solver)
Alf
Bookmarks