A new role mining model is claimed to be more tractable and practical. We test that assertion using constraint programming and MILP.
Page 3 of 35
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
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?
Why does my model find different solutions? Some solutions are better than others – how can that be? How do I find the best solution?
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.
This series of 13 articles compares Python libraries Pyomo, PuLP, OR-Tools, Gekko, CVXPY, and SciPy for building a linear programming model.
Using the SciPy library, we find an optimal solution to Aryabhata's approximation of trigonometric functions using ratios of quadratic polynomials.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
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.
