Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
Page 9 of 35
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
A new role mining model is claimed to be more tractable and practical. We test that assertion using constraint programming and MILP.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
Sometimes we need more power to solve a model. This article describes how to solve a model using the CPLEX solver via the NEOS Server.
Why does my model find different solutions? Some solutions are better than others – how can that be? How do I find the best solution?
We present an example of project crashing using an optimization model to help the project manager decide what to do.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
