[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1049
  • Last Modified:

Determining boxes per layer in Excel

I have what I thought would be easy but is not.  Can someone suggest a formula/fucntion to figure the following:

How many boxes that are X x Y inches can fit on a pallet that is XX x YY inches without over hanging.  I thought this would be easy by just dividing the areas of each and rounding down but it does not work correctly because you might have a 4 inch strip around the outside permiter that technically has enough area for another box BUT the box is constrained to its own dimensions.

So for example if I have a 12x12 inch box I know (using common sense) it would get 12 boxes (4x3) on a 48x45 inch pallet.
  • 2
1 Solution
drhamel69Author Commented:
I figured it out myself.  :)

=MAX(INT(UnitLoadLength / ContLength) * INT(UnitLoadWidth / ContainerWidth), INT(UnitLoadWidth / ContLength) * INT(UnitLoadLength / ContainerWidth))
drhamel69Author Commented:
I figured out a formula myself after posting my question and not getting any responses.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now