
New Member

February 17, 2021

Hi Catalin,
I need your help about an issue.
I want to efficiently distribute some numbers into a maximum value.
Let's say I have a stick with 6meters long, then I want to efficiently use every stick with certain values of cutting sizes so there will not be many scrap.
I want to know how many sticks I will need for that and how is the distribution of cutting sizes in each stick.
Is it possible to make it in excel?
I hope my explanation is clear.


November 8, 2013

Hi Nur,
Cutting optimization is a complex problem, it's not just a formula. A complex algorithm is needed, see a problem description here: https://www.researchgate.net/p.....tatus_data
There are a few solution, not all free, like this one: http://www.optimalon.com/lengt....._excel.htm
1 Guest(s)
