This form is protected by Aimy Captcha-Less Form Guard
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.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
We explore methods to decide the best order for positioning devices in a rack: enumerate, heuristic, constraint programming, and linear program.
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've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
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.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
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 compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.