Solver Max - Philippe Olivier

Blog written by Philippe Olivier, who specializes in consulting and advising on operations research matters for startups.

Topics include:

Optimizing Multiplayer Online Battle Arena (MOBA) free hero rotations.
Generating crossword grids using Constraint Programming.
Land lot optimization.

Blog: Philippe Olivier's blog.

Blogs

Essential reading

Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
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.
We explore methods to decide the best order for positioning devices in a rack: enumerate, heuristic, constraint programming, and linear program.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
Given available stock of wire and a list of pieces required, what is the best way to cut the stock to fulfil demand while minimizing waste?
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.
Minimize the number of racks to store all pallets in a warehouse, freeing space for other activities and allowing company growth.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
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.

Philippe Olivier

Essential reading

Latest blog articles

Latest resources

Featured