Frontline Systems' Solver add-on for Google Sheets makes it easier than ever to optimize business models defined in spreadsheets, on desktop PCs, mobile devices, and in the cloud.

Optimization with Solver is used to find better ways to allocate scarce resources, maximize profits or minimize costs or risks, in a wide range of applications in finance and investment, marketing, manufacturing and production, distribution and logistics, purchasing, and human resources, as well as science and engineering.

Optimization models are solved on Frontline’s RASON® Server, running on Microsoft Azure, which also handles ‘embedded analytics’ models in web and mobile add-ons written in the RASON modeling language.

New User Interface Optimized for Tablets and Browsers

The Solver add-on features a task pane based interface that works well in touch-based use on the iPad, as well as touchpad use on laptops, while still serving mouse-based users on desktops.  In addition, the add-on includes automatic algebraic diagnosis of optimization models and more powerful linear, nonlinear and evolutionary Solver Engines.

Ability to Scale from Small to Large State-of-the-Art Models

The Solver add-on enables everyone to solve modest-size optimization models for free, up to 200 decision variables and 100 constraints (same as the Solver in desktop Excel).  But users of Frontline’s Premium Solver® and Analytic Solver® tools for desktop Excel can ‘publish’ their models to Google Sheets, and solve much larger problems, use more powerful Solver engines and more computing time, up to the limits of their desktop licenses (from 2,000 to over 2 million decision variables) – all using the same Solver add-on.  For more information, see the Frontline Solver User Guide.