To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
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.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
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?
