This form is protected by Aimy Captcha-Less Form Guard
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.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
Using the SciPy library, we find an optimal solution to Aryabhata's approximation of trigonometric functions using ratios of quadratic polynomials.
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.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
We explore two aspects of refactoring an existing optimization model: Modularization and adding model variations.
Job sequencing is a common problem. Excel Solver can help you make optimal job sequencing decisions to minimize cost.
We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
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.
