We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.

We present an example of project crashing using an optimization model to help the project manager decide what to do.

We explore methods to decide the best order for positioning devices in a rack: enumerate, heuristic, constraint programming, and linear program.

We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.

How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.

We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.

We report our experience of Copilot coding a non-trivial optimization model, focussing on what went well and what didn't go well as the model evolves.

The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.

Using the SciPy library, we find an optimal solution to Aryabhata's approximation of trigonometric functions using ratios of quadratic polynomials.

We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.

This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.

To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.