number of items fit into item

D

Dreamstar_1961

can any one think of a formula to find out how many items will fit in to a
given Dimension, that is I have a item that is so many width*height*depth
into a location of width*height*depth
ex 10*10*10 into a item of 10*10*10 = 1
 
A

andy62

Seems like you would just multiply to compute the respective volumes, and
then divide. So what's the catch?
 
D

Dreamstar_1961

tryed that but dos't seem to be working, what this is for is a fit size, that
is we have a number of location of a given size, I need a formula that when
we put the size of the part in it will show how many will fit in a given
location
 
A

andy62

Can you provide an example of what you mean? Include some data, and point
out what is making it so tricky.
 
D

Dreamstar_1961

what I'm trying to get is if item is say 28*13*14 and the value of the item
it's to go into is 29*14*15 then what will fit is 1, but if the item is 1*1*1
then the answer is 1000's what I'm after is the formula to work out the
number, this is being used for a fit size test.
 
A

andy62

Let me know if this works:

=INT(A2/A3)*INT(B2/B3)*INT(C2/C3)

Where the numerators are the width/height/depth of the available space
("Dimension" from your first note) and the denominators are for the given
part/item.
 
D

Dreamstar_1961

that worked but is there a way to put it in that test all ways, I can't be
sure that when the part is Measured that it will be Measured in relation to
the location, this is for a work sheet for a warehouse work group where there
are 12 locations, all different sizes, the size will be put on one place and
it's to test to see which location will be best for the location, I looked at
the chitest to see if that would work
 
A

andy62

If I understand correctly, you're saying the formula works but you want it to
be more flexible in case the part might fit more efficiently with a different
orientation. To accomplish this, I would use the same formula as before but
with two changes:
- Check each of the six possible configurations instead of just one
- Use the MAX function to find which of the six configurations is the best

Here's what I mean:

=MAX(INT(A2/A3)*INT(B2/B3)*INT(C2/C3),INT(A2/A3)*INT(B2/C3)*INT(C2/B3),INT(A2/B3)*INT(B2/A3)*INT(C2/C3),etc.)

Let me know if we've got it.
 
D

Dreamstar_1961

that worked, thnkyou

andy62 said:
If I understand correctly, you're saying the formula works but you want it to
be more flexible in case the part might fit more efficiently with a different
orientation. To accomplish this, I would use the same formula as before but
with two changes:
- Check each of the six possible configurations instead of just one
- Use the MAX function to find which of the six configurations is the best

Here's what I mean:

=MAX(INT(A2/A3)*INT(B2/B3)*INT(C2/C3),INT(A2/A3)*INT(B2/C3)*INT(C2/B3),INT(A2/B3)*INT(B2/A3)*INT(C2/C3),etc.)

Let me know if we've got it.
Click to expand...
 
D

Dana DeLouis

Hi. In Operational Research projects, optimal "packing" is probably one of
the hardest to do. I really don't think you will find a "Formula" to do
this. You might work out a formula if you make a lot of assumptions though.
For example, when testing an algorithm, you might want to check that it can
pack all 18 items into a 5*5*5 box.

http://mathworld.wolfram.com/ConwayPuzzle.html

As you can see, a simple Formula will probably not work.
 
Top