![plywood cut optimizer excel plywood cut optimizer excel](https://i.ytimg.com/vi/UEbQUUfoQXA/maxresdefault.jpg)
![plywood cut optimizer excel plywood cut optimizer excel](https://wooddesigner.org/wp-content/sp-resources/forum-image-uploads/admin/2017/10/import-010.png)
I really like how this runs, my only question is. It works well, I have a downloaded but ugly shareware optimizing program which I cannot integrate into my spreadsheet that gets 51 lengths as a best result, so well done. My formula might be called answer by exhaustion but computers don't get tired, do they? If you ever come up with a number of 49 or 48 I'd stop and use that as my answer. The attached never gets to the formula part but simply makes guesses and keeps track of how many pieces of stock are needed with random cutting of slices. If your guess is wrong then you make another guess, until/if you can come up with a formula. I took a math class on "How to Solve It" which said you need to make a guess for an answer as a start. It will copy to the range on the right the best guess.
![plywood cut optimizer excel plywood cut optimizer excel](https://metalopt.com/images2/cutlist.jpg)
Click the button and watch it guess your answer 20 times. I've been noodling on your problem a while and I really like it.