OpenSolver

opensolver.org ↗

Optimization models inside Excel worksheets

SI Score
80/100
Pricing
Open Source AI reading, not confirmed
Free plan
Not confirmed
Sign-up required
Not confirmed

Ask SI about OpenSolver

Answers use saved listing facts and recorded sources.

What it does

OpenSolver extends Excel’s Solver workflow with optimization engines and a model visualizer for decision variables, objectives and constraints.

OpenSolver extends Excel Solver models with selectable engines and highlights objective, decision variables and constraints on the sheet, marking integer/binary variables. In the documented CBC workflow it extracts the worksheet model into a file, solves it and automatically loads results back into the spreadsheet. The linearity checks are partial; the modeller must ensure the chosen linear solver fits the formulas. QuickSolve reuses an initialized model while specified parameter cells change, assuming their effect on constraint right-hand sides is linear. There is no artificial model-size cap, but memory and solve time remain limits. Its published API distinguishes optimal, infeasible, unbounded and limited-suboptimal status; retain that status with any result. The Sheets route is separate from the Excel add-in.

Strengths

  • Works with existing Excel Solver models
  • Model visualizer highlights objectives and constraints

Watch out for

  • Large models can be slow and are constrained by available resources

Best for

  • Reviewing a spreadsheet optimization model

Sources