To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
How many other optimal solutions exist? How do I find those solutions. This article explains how to use the CPLEX solution pool.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
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.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.