Page 1 of 2
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.
We replicate a wood cutting pattern model from a published academic paper. Surprisingly, we find a better optimal solution.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
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.