Determining boxes per layer in Excel

Posted on 2011-05-10
Last Modified: 2012-05-11
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.
Question by:drhamel69
    LVL 2

    Accepted Solution

    I figured it out myself.  :)

    =MAX(INT(UnitLoadLength / ContLength) * INT(UnitLoadWidth / ContainerWidth), INT(UnitLoadWidth / ContLength) * INT(UnitLoadLength / ContainerWidth))
    LVL 2

    Author Closing Comment

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

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    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.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now