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.
Page 2 of 35
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
Bin packing is a common problem. A new formulation helps us solve a simple, yet difficult to solve, bin packing model.
Job sequencing is a common problem. Excel Solver can help you make optimal job sequencing decisions to minimize cost.
We minimize trim waste in a paper manufacturing process. A theoretically perfect solution is impractical, so what can we do?
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
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.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
Formulating logic conditions in linear programs can be difficult. This two-part article series explains how, using easy to follow steps.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
