We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Bin packing is a common optimization problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
Allocating people to teams is a task common in both sport and business. We allocate 32 people to 4 teams that are as balanced as possible.