Excel funtion to find how many boxes in larger container
 

I would like to know if there is a funtion in Excel to find out how many
containers, with determined measures, would fit in a larger container with
specific measures too? or simply, How many little boxes in a bigger box?

Any suggestions or option would be appreciated.

Thx.

A1 contains the cubic size of one little box.

A2 contains the cubic size of large box.

A3 contains the formula =A2/A1

Gord Dibben Excel MVP

On Mon, 20 Dec 2004 08:31:06 -0800, "logistics learner" <logistics
wrote:

I would like to know if there is a funtion in Excel to find out how many
containers, with determined measures, would fit in a larger container with
specific measures too? or simply, How many little boxes in a bigger box?

Any suggestions or option would be appreciated.

Thx.

Gord Dibben wrote:
A1 contains the cubic size of one little box.

A2 contains the cubic size of large box.

A3 contains the formula =A2/A1

So that means a 3x3x3 container should be able to hold at least two
2x2x2 boxes. Care to enlighten us how that's possible? After doing
that, continue to enighten us with how one packs 3 2x2x2 boxes into a
24x1x1 container.

Worst case, with container width, height and length denoted Cw, Ch and
Cl, respectively, and box width, height and length denoted Bw, Bh and
Bl, the container can hold only

INT(Cw/Bw)*INT(Ch/Bh)*INT(Cl/Bl)

boxes. Nonuniform orientation of noncube boxes within the container may
allow more than this number of boxes to fit in the container, but I
doubt anyone could pack the necessary logic into a single cell formula
to calculate that.

Thanks Harlan

Did look a little too simple<g

Gord

On 20 Dec 2004 13:32:55 -0800, wrote:

Gord Dibben wrote:
A1 contains the cubic size of one little box.

A2 contains the cubic size of large box.

A3 contains the formula =A2/A1

So that means a 3x3x3 container should be able to hold at least two
2x2x2 boxes. Care to enlighten us how that's possible? After doing
that, continue to enighten us with how one packs 3 2x2x2 boxes into a
24x1x1 container.

Worst case, with container width, height and length denoted Cw, Ch and
Cl, respectively, and box width, height and length denoted Bw, Bh and
Bl, the container can hold only

INT(Cw/Bw)*INT(Ch/Bh)*INT(Cl/Bl)

boxes. Nonuniform orientation of noncube boxes within the container may
allow more than this number of boxes to fit in the container, but I
doubt anyone could pack the necessary logic into a single cell formula
to calculate that.