excel solver
optimization
simulation
excel solver downloads, GRG, spreadsheet solvers

   solver.com

Frontline Systems, Inc.  

quadratic programming, portfolio optimization, quadratic solver 
Developers of Your Spreadsheet's Solver  
robust optimization, stochastic programming, simulation optimization
   
excel solver, gradient method, optimization software

Large-Scale GRG Solver Engine for Excel - Premium Solver Platform


nonlinear programming, Generalized Reduced Gradient

 
Home
Register
What's New
Solver Tutorial
Solver Technology
Select a Product
Excel Users
MATLAB Users
Developers
Government Users
Academic Users
Press/Analysts
Privacy Policy
 

 

 
Large-Scale Smooth Nonlinear Solver

Frontline Systems is pleased to offer the Large-Scale GRG Solver Engine Version 8.0 for Microsoft Excel. The Large-Scale GRG Solver is a new field-installable Solver Engine that "plugs into" the Premium Solver Platform for Excel, and takes advantage of its new Polymorphic Spreadsheet Interpreter.  You can also use it with our Solver Platform SDK to develop applications in a programming language, for one license price!  It extends the power of both Platforms to handle smooth nonlinear optimization problems of up to 4,000 variables and 4,000 constraints in its Standard version, or up to 12,000 variables and 12,000 constraints in its Extended version. It solves global optimization problems using the "multistart" or "clustering" methods available in both Platforms.  And it supports integer variables and "alldifferent" constraints in both Platforms.
 

bulletNew to Spreadsheet Solvers?  Start with our Solver Tutorial
bulletLearn about Large-Scale GRG Solver Product Highlights (on this page)
bulletLearn about the exciting features built into the Premium Solver Platform
bulletLearn about the advanced methods used by the Large-Scale GRG Solver
bulletLearn about the diagnostic aids supported by the Large-Scale GRG Solver
bulletLearn about the ease of use features in the Large-Scale GRG Solver
bulletUsers of earlier Large-Scale GRG Solvers: Learn the good news about upgrading!
bulletUsers of other Solvers for Excel: Learn about competitive upgrade pricing!

Fully Compatible

The Premium Solver Platform is 100% upwardly compatible with the standard Excel Solver. It appears when you select the Tools Premium Solver... menu choice; you'll see a familiar Solver Parameters and Solver Options dialog with many new features. Your existing models can be solved with no changes, faster and more easily than before -- with any appropriate Solver engine for the Premium Solver Platform, including the Large-Scale GRG Solver Engine! And your VBA code designed to control the standard Solver will work as-is with the Premium Solver Platform.

Greater Speed and Capacity

You'll be able to solve smooth nonlinear optimization problems twenty to sixty times larger than the standard Excel Solver -- up to 4,000 variables and 4,000 constraints in the Standard version, or up to 12,000 variables and 12,000 constraints in the Extended version of the Large-Scale GRG Solver Engine.  To handle such large problems, the Large-Scale GRG Solver Engine uses sparse matrix storage methods and advanced methods for maintaining numerical stability.

The Large-Scale GRG Solver can use the new Polymorphic Spreadsheet Interpreter in the Premium Solver Platform to obtain partial derivatives of the problem functions (the Jacobian matrix) at each major iteration or Trial Solution.  This yields huge benefits in speed and accuracy -- up to ten times faster or more than without the Polymorphic Spreadsheet Interpreter!

New Options and Tolerances

The Large-Scale GRG Solver offers several new options and tolerances to improve speed and give you better control of the solution process. The Recognize Linear Vars option allows the Large-Scale GRG Solver to take advantage of linearly occurring variables (often found in a large problem that is nonlinear overall), to save time in computing the Jacobian matrix.

If you've ever had problems with trial solutions that included small violations of the bounds you place on variables (sometimes generated by the standard GRG Solver), you'll appreciate the ability to control this behavior with the Relax Bounds on Variables option in the Large-Scale GRG Solver.

The Bypass Solver Reports option allows you to save time on runs when you don't need to produce report information. Other new options and tolerances control the multistart methods for global optimization.

Comprehensive User Guide

In addition to the User Guide that comes with the Premium Solver Platform, you'll receive our Solver Engine User Guide that describes several field-installable Solver engines, including the Large-Scale GRG Solver.  This guide provides complete information on Large-Scale GRG Solver options, the various messages which the Large-Scale GRG Solver can return, how to diagnose problems, and how to control the Large-Scale GRG Solver from VBA in Excel, or from our Solver Platform SDK.

Order or Upgrade Today!

Prices.  The Standard version of the Large-Scale GRG Solver Engine V8.0 solves smooth nonlinear problems of up to 4,000 variables and 4,000 constraints. The Extended version of the Large-Scale GRG Solver Engine V8.0 solves smooth nonlinear problems of up to 12,000 variables and 12,000 constraints.  For pricing information, click on Excel Software and Support Prices.  If you are ordering for several users, ask us about quantity discounts and Flexible Use Licenses.

What's Included.  The Large-Scale GRG Solver Engine supports all recent versions of Excel (Excel 2007, Excel 2003, Excel XP, and Excel 2000) on Windows NT / 2000 / XP, Windows Server 2003, or Windows Vista.  It comes with a comprehensive User Guide (covering several field-installable Solver engines) and extensive online Help.  You can order today with a 30-day money-back guarantee.

Annual Support Contracts.  An Annual Support Contract for the Large-Scale GRG Solver V8.0 is required for the first year, and at all times in order to obtain software upgrades and technical support beyond basic installation assistance.  An Annual Support Contract includes:

bulletA limited warranty for the functionality and performance of the software product 
bulletAll software upgrades for the product released during the contract term
bulletAbility to trade in this product for an even more powerful Excel Solver product
bulletAccess to protected support pages of our Website
bulletTechnical support by phone and email during normal business hours
bulletUp to 15 minutes of consulting assistance arising during the contract term

Evaluation Versions.  If you want to "try before you buy," simply register by filling out a simple form, then download and run the V8.0 Engine Setup program.  If you don't already own the Premium Solver Platform V8.0 (which is required in order to run the Large-Scale GRG Solver Engine), you can also download and run the V8.0 PSP Setup program.  You'll receive an evaluation license code which will allow you to use a full featured, full capacity, full speed version of the Premium Solver Platform and the Large-Scale GRG Solver Engine 15 days, free of charge.  You can also download and run the V7.2 SDK Setup program, and use the Solver Platform SDK with the Large-Scale GRG Solver Engine for 15 days.

Product Upgrades.  If you own an older version of the Premium Solver Platform or the Solver Platform SDK and the Large-Scale GRG Solver Engine, you'll receive an automatic upgrade to V8.0 at no extra charge if you have a current Annual Support Contract (if you aren't current, see our instructions for "catching up" on annual support and paying the difference in price).

Competitive Upgrades.  If you own another "Solver" product for Microsoft Excel, click here for Competitive Upgrade Prices!

Contact Us Today:  Display or print our Order Form in PDF format, send us email at info@solver.com, call us at (775) 831-0300, or send a fax to (775) 831-0314.

  nonlinear optimization   large scale optimization
spreadsheet solver
scarce resources