A tool that solves constrained optimization problems right inside of your Google Sheets™ spreadsheet models.
应用详情更新日期:2025年1月14日
适用于:
1万+
概览
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!
其他信息
定价免费试用
开发者
Optimization Solver”将请求获得以下权限。了解详情
Optimization Solver”将需要访问您的 Google 账号
这样可让Optimization Solver
查看和管理其中已安装此应用的电子表格
在 Google 应用的提示和边栏中显示和运行第三方网页内容
连接到外部服务
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单