We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
Formulating logic conditions in linear programs can be difficult. This two-part article series explains how, using easy to follow steps.
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.
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.