Optimization modelling in Excel

  • Microsoft. Microsoft provide an overview of defining and solving an optimization problem using the Solver add-in.
  • OpenSolver. Documentation and other useful information relating to the OpenSolver add-in, which is available to download for free.
  • Solver. Frontline Systems provide additional information about the Solver add-in that is bundled with Excel, including more than 100 example models.

Optimization modelling in Python

  • CVXPY. A modelling language for convex optimization problems.
  • Gekko. Package for model construction, analysis, and visualization of simulation and optimization.
  • OR Tools. Tools for modelling and solving combinatorial optimization problems.
  • PuLP. Linear programming modelling package.
  • Pyomo. Package for building optimization models.
  • Python-MIP. Collection of Python tools for the modeling and solution of Mixed-Integer Linear programs.
  • SciPy. A collection of algorithms and functions for conducting a wide range of modelling and analyses.

Blogs about optimization

  • Alireza Soroudi. Pyomo modelling newsletter on LinkedIn by Associate Professor Alireza Soroudi.
  • Analytics Guy. YouTube videos related to optimization, data analytics, and mathematical literacy by Tallys Yunes.
  • Farkas' Dilemma. Combinatorial optimization and integer programming blog by Austin Buchanan.
  • Jay, Barry & Chuck's OM blog. A blog for Operations Management educators.
  • Katie McConky. Videos from an 'Introduction to Operations Research' class.
  • Kevin Gue. Focused on problems in warehousing and distribution.
  • Nathan Brixius. Data science, optimization, analytics, and sports blog by Nathan Brixius.
  • Operations Room. A forum for discussing current topics in operations management (OM).
  • Optimization 101. A gentle introduction to the major topics in optimization.
  • Optimisation in the real world. Initiative to raise awareness of how optimisation regularly influences our lives.
  • O.R. by the Beach. Blog by Associate Professor Tallys Yunes about complex decision problems that arise from a variety of practical applications.
  • OR in an OB World. Operations research items and software tricks by Professor Emeritus Paul A. Rubin.
  • OR in Devon. Thoughts and observations about Operational Research by David Smith.
  • Punk Rock Operations Research. Blog by Professor Laura Albert about operations research modelling.
  • Quest for Optimality. Blog by Marc-Andre Carle, Professor at Téluq Quebec.
  • RENeW. Dr. Anna Nagurney writing about research, networks, and the world.
  • Sysid. Blog about optimization, math, software development, and machine learning.
  • Supply Chain Data Analytics. Blog and knowledge base related to advanced analytics in supply chain management and manufacturing.
  • Yet Another Math Programming Consultant. Erwin Kalvelagen's technical notes and optimization examples.


Spreadsheet good practice

Social media


If you want help with your own models, or if you would like to know more about how to adapt any of the models on this website to your needs, then please contact us.