A tool that solves constrained optimization problems right inside of your Google Sheets™ spreadsheet models.
Listing updated:January 14, 2025
Works with:
7K+
Overview
It's time for spreadsheet solver software to be available on the web.


What is Optimization Solver?

Optimization Solver is an add-on for Google Sheets™ that solves linear and nonlinear constrained optimization problems in your spreadsheet models. It boasts a sleek and simple user interface with built-in features to help users navigate the unique challenges of spreadsheet modeling. Optimization Solver is published by Number Engine, LLC: a new developer on the scene!

_____________________________________________________________________________________________________

How does it work?

Solving constrained optimization problems on web-based spreadsheets is a difficult task for many reasons; that's why so few add-ons have been developed to do it. Optimization solver leverages two solution methods: 'Linear', and 'Nonlinear'. The 'Linear' method is designed to provide you with global solutions to linear problems and has the option to solve mixed integer problems as well. The 'Nonlinear' method uses a linear approximation approach to give you a local solution to your nonlinear model. Both support models of up to 50 decision variables at this time.

_____________________________________________________________________________________________________

Why should you use Optimization Solver?

Other solutions on the market try to solve your models with outdated methods that are slow and ineffective, or they try to offload your model's data to an external web service solver. Here at Number Engine, we solved these problems with our very own proprietary methodology. The following are some reasons summarized from our website on why you should use Optimization Solver:

- The App's Internal Execution (via your sheet's own script)
- Our Commitment to Data Privacy
    - The permissions page mentions that we collect your personally 
      identifiable information, but we do not store any of this information in 
      accordance with our privacy policy. This scope is included by default in 
      all add-ons.
- Customizable Settings
- Rigorously Tested Methods & Error Handling

_____________________________________________________________________________________________________

Pricing

A 7-day free trial is available automatically upon installing the app and launching the user interface for the first time. After this point, users may choose from one of two subscription plans to continue optimizing:

- A monthly plan, $2.99 per user per month
- A yearly plan, $29.99 per user per year

Subscriptions to these plans are managed through the Stripe payment platform. All you need to do is visit the respective payment link for the plan you've chosen, check out, and your access to the add-on will be automatically granted!
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Optimization Solver will ask for the permissions shown below. Learn more
Optimization Solver will need access to your Google account
This will allow Optimization Solver to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Susanna Goggans
January 14, 2025
Simple and user friendly design. Both solution methods work much smoother and are more reliable than other web-based solver apps I've tried.
Is this review helpful?
Yes
No
Profile Picture
Srikanth Kakani
May 5, 2025
Couldn't get it to work
Is this review helpful?
Yes
No
Profile Picture
James Teeter
March 6, 2025
Useless, a terrible replacement for Excel solver
Is this review helpful?
Yes
No
1-3 of 3
Search
Clear search
Close search
Google apps
Main menu