|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need to analyze list of numbers and build groups of cells that meet my target cell (or as close)
I have a list of items that are a specific length. I need to group the items together (need a way to mark each group) that will be equal or smaller than the target number.
It would have to find the best combinations that would get each group as close as possible to the target length. Real world story: I have orders for profiles at requested lengths. I have stock of profiles at 4.3. I need a way to group the items that are the best to cut from a single profile. Need to find the groups that would create the least amount of waste. |
#2
|
|||
|
|||
Any kerf allowance ?
|
#3
|
|||
|
|||
3mm per cut
3 mm per cut
|
#4
|
||||
|
||||
Have you searched the Net ? This problem has been solved many times
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Quote:
I am happy for some links if it has. Maybe I didnt search for correct keywords. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting if certain cell meet certain conditions | bbutl027 | Excel | 1 | 11-25-2016 12:52 AM |
How can I build figures list and tables list separately | lopesdasilva | Word | 2 | 05-31-2016 01:30 AM |
convert list in one cell into multiple cells | RayK | Excel | 2 | 02-09-2016 04:53 AM |
Arranging x numbers in y groups with an approximate sum of z | hiwire03 | Excel | 0 | 12-11-2014 10:14 PM |
How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |