To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
Page 26 of 35
Minimize the number of racks to store all pallets in a warehouse, freeing space for other activities and allowing company growth.
Academic research papers can be tremendously valuable. But only if they are complete. So, academics, please publish your data and code.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
Using the SciPy library, we find an optimal solution to Aryabhata's approximation of trigonometric functions using ratios of quadratic polynomials.
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 compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
A new role mining model is claimed to be more tractable and practical. We test that assertion using constraint programming and MILP.
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.
