Seems simple enough but i have been unscuccesful
DATA:
columns
NodeName, Weight
A1, 800
A2, 800.1
A3,820.9
A4,815.3
A5,801.6
A6,801.6
A7,815.3
you get the idea. very simple data, except i have thousands.
I've tried creating histograms and that works fairly well but you can't really see the forumlas or how its doing it much less alter it very much.
Normally these items are physically sorted in the real world by a human that is pretty much guessing what works best. when you look at the bulk lot you'll notice standard distributions with really light items on end and really heavy on the other. the idea is to group them up in BIN so to best utilize the items within a certain tolerance.
To view how my BIN quantiies change I'd like to be able to plug in a variable in a cell that represents the desired tolerance. Say +/- .7 so the magic of excel *should* go look at the entire set of items and tell me how to best group them up in BINS based on the min/max of a particular BIN being with the MEAN/MODE of +/- .7grams Some times i need to alter than to say .5 or go up to 1.5 in either case it will result in less waste at either end and create appropriate sized BINs.
Hopefully that makes sense. I could really use them help.
Thank
DP
DATA:
columns
NodeName, Weight
A1, 800
A2, 800.1
A3,820.9
A4,815.3
A5,801.6
A6,801.6
A7,815.3
you get the idea. very simple data, except i have thousands.
I've tried creating histograms and that works fairly well but you can't really see the forumlas or how its doing it much less alter it very much.
Normally these items are physically sorted in the real world by a human that is pretty much guessing what works best. when you look at the bulk lot you'll notice standard distributions with really light items on end and really heavy on the other. the idea is to group them up in BIN so to best utilize the items within a certain tolerance.
To view how my BIN quantiies change I'd like to be able to plug in a variable in a cell that represents the desired tolerance. Say +/- .7 so the magic of excel *should* go look at the entire set of items and tell me how to best group them up in BINS based on the min/max of a particular BIN being with the MEAN/MODE of +/- .7grams Some times i need to alter than to say .5 or go up to 1.5 in either case it will result in less waste at either end and create appropriate sized BINs.
Hopefully that makes sense. I could really use them help.
Thank
DP
