Solved

# Determining boxes per layer in Excel

Posted on 2011-05-10
764 Views
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.
0
Question by:drhamel69

LVL 2

Accepted Solution

I figured it out myself.  :)

0

LVL 2

Author Closing Comment

I figured out a formula myself after posting my question and not getting any responses.
0

## Featured Post

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.