To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
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.
Why does my model find different solutions? Some solutions are better than others – how can that be true? How do I find the overall best solution?
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.