The Microsoft Excel workbook “BPP Spreadsheet Solver” is an open source unified platform for representing, solving, and visualising the results of Bin Packing Problems (BPPs). It can solve BPPs with up to 200 items and 50 bins.
BPP Spreadsheet Solver is a continuation of the VRP Spreadsheet Solver and FLP Spreadsheet Solver, and is based on the same design principles and similar worksheet and menu structures. It is capable of solving the one-dimensional and two-dimensional BPPs, allows for multiple bin types and the possibility of adding item-item and bin-item compatibility constraints.
What’s new in Version 2.0:
- Changing problem data is reflected on the solution worksheet with a warning.
- Custom ribbon for the BPP Spreadsheet Solver menu.
- Users can specify image files for each item type to be shown on the visualization worksheet.
- Minor bug fixes.