Best yield from table

**sleazyfish** · 09-08-2010, 07:58 AM

Hi,

I have a table with 2 columns for raw material (Length and Width) and i have two seperate cells for product size also called length and width. What i'm trying to do is input my product size which will then return the best fit raw material by the least amount of waste. This would be applicable to multiples. For example:

Product Size (input)
lenght Width
600 300

Raw Material Size (table)
Length Width
500 230
1220 310
1000 310
1900 350
1850 310

Result
Length Width
1220 310

The above result would be the correct answer as you would get 2 products from the one sheet of raw material with the least amount of waste. Hope this makes sense

I would really appreciatre some help/advice. I've attached my workings so far.

Thanks in advance

**DonkeyOte** · 09-08-2010, 08:15 AM

Should you not also be taking into account width simultaneously ?

Based on sample file - perhaps:

Please Login or Register  to view this content.

As you alter C4/D4 so the result should update accordingly (eg 600/300 returns 1250/350 whereas 600/400 returns 1050/550)

**sleazyfish** · 09-08-2010, 08:29 AM

Should you not also be taking into account width simultaneously ?

This works great but yes you are right. Width does need to be taken into account simultaneously. Is this possible?

Thanks in advance

**DonkeyOte** · 09-08-2010, 08:35 AM

Originally Posted by sleazyfish

Width does need to be taken into account simultaneously. Is this possible?

It already is (I tried to illustrate that by means of examples and outputs)

**DonkeyOte** · 09-08-2010, 08:45 AM

I take that back - the above was not an accurate solution... is the below better ?

Please Login or Register  to view this content.

So waste is determined by: waste height * width + waste width * complete units (as determined by height)

Example:

250/175 would return 1250/350 rather than 500/230 given the former leaves no waste whatsoever

**sleazyfish** · 09-08-2010, 09:11 AM

I changed the bottom entry in the table to 600 x 550 and put 600 x 350 in the product dimensions and was expecting the outcome to be 1250 x 350 but it was 600 x 550 instead.

Any ideas DonkeyOte?

**DonkeyOte** · 09-08-2010, 09:23 AM

I'm not having a good day am I ?

If (big if) I am correct in assuming waste would be calculated using:

waste height * width + waste width * height

then:

Please Login or Register  to view this content.

**sleazyfish** · 09-08-2010, 09:32 AM

That worked perfectly.

Thank you so much. I've worked on this on and off for some time. I even looked into MOD as a method but disgarded it!

Thanks again