The Microsoft Excel workbook “CLP Spreadsheet Solver” is an open source tool for representing, solving, and visualising the results of Container Loading Problems (CLPs), also known as 3D Bin Packing Problems.


What’s new in version 1.6

Users can now animate the loading plan and the unloading plan.

What’s new in version 1.55

Users can now select the unit of weight and length from the console worksheet. All items and containers should be declared using the same units. For example, if the items are declared in feet and kg, so should the containers be.

What’s new in version 1.5

Multi-language support. Users can now set the language of the menu and the rest of the interface from the console worksheet. The available languages are: Turkish, German, Spanish, Italian, French, Portuguese, Arabic, Indonesian, Urdu, Bengali, Swahili, Persian, and Malay. As you may expect, I do not speak all these languages. The translations are from Google Translate, so expect minor (i.e. significant) inconsistencies. You can also add your own language or jargon, details are in the new User’s Manual. Special thanks to Rusuhi Cantay for his help with the multi-language support.

What’s new in version 1.4

Further improvements to the solver, and minor bug fixes.

What’s new in version 1.3

The solver has been improved, and also minimises the moment with respect to the z-axis (i.e. approximately equal load for the right and left sides of the container) for balanced load.

What’s new in version 1.2

The users now can define item types to be “heavy” or “fragile”. “Heavy” items can only be placed at the floor level, since placing them on any other item will result in the other item being damaged. “Fragile” items cannot vertically support any item (i.e. it is not allowed to place any item on top of them), no matter its weight. An item type can be both “heavy” and “fragile” simultaneously.