perfect.
Thanks again Guido.
jfarr3ll
Last Activity: May 10 '13, 12:23 PM
Joined: Apr 2 '12
Location:
-
Hi Guido,
Last year you were increadibly helpful with this problem, and I was hoping you could provide some of your expertise again to help with a slight issue I've identified when using your code in practise.
It is perfect as long as a multiple of 4 is not entered. However, when a multiple of 4 is entered it seems to ignore one record.
Alternatively if anyone else can help I'd greatly appreciate it....Leave a comment:
-
That's perfect. Thank you so much for this.Leave a comment:
-
That looks perfect. I can't thank you enough. If you wouldn't mind sending the explanation that would be v useful for me.Leave a comment:
-
sorry this is my inability to express myself fully.
What I want to see is all the data split into groups of 4 where the sum of all the values in each group are as close to a whole number as possible.
In this way we can share packs of parts across the group and waste fewer packs.
I think the central assumption is that without grouping a repair requiring 1.3 parts would need 2 packs and waste .7 of a pack....Leave a comment:
-
I am missing the step From getting them in order to sorting into the groups of 4 to produce the least wastage.
for example if I changed the values column K as follows:
record G = 1.3
record H = 1.2
record M = 1.3
record P = 1.2
I was hoping the code would identify that this combination would produce zero wastage and group them together.
I thought I'd add for clarity that my definition...Leave a comment:
-
these are the results I get when I run the filter macro...
G 1.62
H 2.82
J 2.97
K 1.74
Total 9.15
L 2.31
M 3.3
N 4.35
P 1.8
Total 11.76
TOTAL 20.91
Are you getting different results?Leave a comment:
-
Thank you for this the code looks good, but it doesn't quite do what I was looking for. It seems to just work down grouping the records by row order not by minimal wastage.
Is there a way to tweak it so that it examines all the records and then groups them according to least wastage not just in order?Leave a comment:
-
Sorry I don't think I explained myself very well.
I'm looking for a code which will identify from column L which machines need a repair and then use column K to calculate the 4 machine combinations of these machines which minimises total wastage.
I may have been misleading talking about whole numbers as I think they're not necessarily what I need. (You can probably tell this is a bit above my skill level).
...Leave a comment:
-
Hi Guido Geurs
This is a dummy workbook to show the structure...Leave a comment:
-
Bin Packing Problem
Hi all,
I'm struggling with a specific bin packing problem...
I have a dataset where there is a column which identifies certain records. i.e. the cell takes a value 1 if the record needs including and 0 if not.
There is also a column which gives a number of parts needed. i.e. 1.56 or 2.73 etc.
What I'm trying to do is split the records into batches of 4 to minimise wastage. So I need a code to look...
No activity results to display
Leave a comment: