Run real linear programming, integer programming, and nonlinear optimization models — directly inside Google Sheets™.
Дата оновлення:13 липня 2026 р.
Підтримує:
357
Огляд
SolveSheet runs linear, integer, and nonlinear optimization models directly in your spreadsheet — using the same Set Objective / By Changing Variable Cells / Subject to Constraints workflow you already know from Excel's Solver. Models built for Excel reproduce in SolveSheet using the same logic.

WHO IT'S FOR

• Operations Research and Management Science students working through course assignments
• Business analysts solving product mix, resource allocation, transportation, assignment, and scheduling problems
• Finance teams running portfolio optimization and asset allocation
• Operations teams handling production planning, inventory, supply chain, and facility location
• Marketing teams modeling media mix and budget allocation across channels

SOLVING METHODS

• Simplex LP — fast, exact solver for linear problems (Free tier and up)
• Mixed-Integer Linear (MILP) — linear models with integer or binary variables (Pro and up)
• Cloud Nonlinear (NLP) — smooth nonlinear objectives and constraints via cloud-powered IPOPT (Pro and up)
• Cloud MINLP — nonlinear models with integer variables, via Bonmin (Business)
• Evolutionary — genetic algorithm for non-smooth, non-convex, and combinatorial problems including TSP, assignment, and AllDifferent puzzles (Business)

PROFESSIONAL REPORTS

Each solve can produce an Answer Report with original and final values, constraint status, and slack columns — formatted to match the Excel output your professor or auditor expects. Pro and Business plans add Sensitivity and Limits Reports with shadow prices, reduced costs, and allowable ranges.

ADDITIONAL FEATURES (Pro and Business)

• Save & Load Models — store your objective, variables, and constraints with the spreadsheet
• Parameter Sweep — re-solve across a range of constraint values
• Feasibility Chart — visualize the feasible region for 2-variable LP problems
• Cell pickers, range selection, integer / binary / AllDifferent constraints

PRICING

• Free — up to 10 variables and 5 constraints, Simplex LP, Answer Report. No credit card, no trial timer, no expiration.
• Pro ($5.99/month or $49/year) — 200 variables, 100 constraints, MILP and NLP, all reports, Save & Load, Parameter Sweep, Feasibility Chart.
• Business ($12.99/month or $129/year) — unlimited variables and constraints, MINLP and Evolutionary solvers, admin-managed Workspace install.

Volume pricing for teams of 2 or more — visit sheetshelp.com/contact for a quote.

PRIVACY

SolveSheet processes your spreadsheet data only to compute the optimal solution you request. The Cloud Nonlinear sends the model to a private Google Cloud Run™ service operated by Sheets Help; data is not stored, logged beyond standard request metadata, or shared with third parties. Full details in our Privacy Policy.

LEARN MORE

Documentation, tutorials, and the full feature list at sheetshelp.com/solvesheet.
Додаткова iнформацiя
ЦіниБезкоштовна пробна версія
Розробник
Політика конфіденційності
Умови використання
Додаток SolveSheet запитає наведені нижче дозволи. Докладніше
Додатку SolveSheet буде потрібен доступ до облікового запису Google
Після цього додаток SolveSheet зможе:
Перегляд електронних таблиць, у яких установлено цей додаток, і керування ними
Показуйте веб-вміст третіх сторін у підказках і на бічних панелях у додатках Google
Під’єднання до зовнішніх служб
Переглядати основну електронну адресу облікового запису Google
Переглядайте особисту інформацію, зокрема всі відомості, які зробили загальнодоступними
Відгуки
Мова:
Сортувати:
Google не перевіряє відгуки й оцінки. Докладніше про відгуки
Немає коментарів
Пошук
Очистити пошук
Закрити пошук
Додатки Google
Головне меню