Pallets, part pallets and cartons calculator

This is not as complicated as you might think. Before I help you with some code: why don't you try to write down (in human readable language) which steps you would take yourself when you have a number of items and want to know how much of each kind of packaging is required. These are the steps you'll have to automate! (And I'm happy to help you with that.)

Also think of the format in which you want to have the result returned after entering an amount of items in your formula or function. Are there any cells to be filled with the different number of cartons and pallets, or do you want a message box to show the result? etc. And: where is the amount of items entered? Is it the value of a specific cell on a worksheet, or do you want to enter it in an input box?

Read more

How does it work?

Enter in information related to your unit and pallet size, and desired configuration. Our pallet builder will generate a 3D visual rendering of your full pallet load and provide a comprehensive list of helpful measurements and specifications.

Step 1 Unit information

Type in the width, length, height and weight of your units, whether boxes or bags.

Step 2 Pallet data

Select your preferred pallet size from the predefined list. Create a custom dimension if your pallet size is not listed, or if pallet height is different than the default of 6 in or 152 mm.

Here are the most common pallet sizes:

48 x 40

• Most standard pallet type across North America
• Safe working load up to 4,600 kg

mm x 800 mm

• Standard across European countries
• Safe working load up to 1,500 kg

mm x mm

Link to Mastek

Commonly used in Europe for larger loads

• 40 x 24 (North America)
• 800 mm x 600 mm (Europe)

Used for smaller loads that wont fill a full pallet but still need to be shipped

Step 3 Layer configuration

Here, you have the option to let the calculator determine the optimal number of units per layer or to specify your desired quantity.

Then, select the appropriate layer configuration for your project from a range of options, as well as choosing whether the units will be aligned with the pallet or overhang.

Step 4 Layer alignment

Specify your total load height (number of layers). Then select the desired layer alignment to improve the stability of your pallet load.

Alignment can be:

• H-mirrored: units are mirrored horizontally along the center of the pallet
• V-mirrored: units are mirrored vertically along the center of the pallet
• Rotated: units are rotated, typically by 90 or 180 degrees
• Parallel: units are aligned in the same direction on the pallet, either horizontally or vertically

Step 5 Results

At this final step, you receive a full list of specifications for your pallet including:

• Total dimensions
• Total weight
• Total height
• Units per layer
• Total number of units
• Surface usage

These numbers are also downloadable into a file for future reference.

If you are looking for more details, kindly visit How Many Cartons per Pallet.