Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
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?
This series of 13 articles compares Python libraries Pyomo, PuLP, OR-Tools, Gekko, CVXPY, and SciPy for building a linear programming model.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.