Powerful Data Analysis in Excel

Solver SDK

Add Optimization & Simulation to your Your Desktop, Web or Mobile Apps. You can use Solver SDK from C/C++, VBA, C#, VB.Net, Java, or MATLAB -- or from PHP or JavaScript as a Web Service

Industry Leading Conventional Optimization Capabilities from Premium Solver Platform

Analytic Solver Platform provides best-in-class tools to help you solve virtually any conventional optimization problem of any size.
Excel Solver compatibleUse existing Solver models and VBA macros as-is, but solve faster -- just open your workbook and solve.
Unlimited size modelsHandle problems with up to 8,000 decision variables (40 times larger than the Excel Solver) using built-in Solver engines, and virtually unlimited size problems with optional plug-in Solver engines.
Easier model buildingOur Constraint Wizard helps you think about and define constraints.  Guided Mode helps you better understand your model, refine it for better answers in less time, and find and correct any errors.  When you're up to speed, Auto-Help Mode gives you expert help only when you encounter an error.
Dimensional modelingBuild more structured, easily readable, compact Excel models, that represent business situations with many 'dimensions' such as products, customer types, geographic regions, or time periods.
Helpful example modelsOver 60 example models show you step by step how to create a basic Solver model, build more complex models, and use more advanced features.
Better solutionsFind better solutions to portfolio optimization problems, global optimization problems, and models using arbitrary Excel functions with the built-in LP/Quadratic, SOCP Barrier, Interval Global and Evolutionary Solvers.
Faster solutionsFind solutions between 2X and 200X faster thanks to more advanced Solver engines, better optimization algorithms, and our super-fast, proven accurate PSI Interpreter.
Insightful reports & chartsEasily understand and share results, and get insight into the key drivers of your model results and potential decision trade-offs you can make.
Easy to use interfaceUse either a dialog-based interface that matches the basic Excel Solver, or our Ribbon and Task Pane interface with quick access to advanced features and help.
Remove guessworkSimply define your model in Excel -- Premium Solver Platform will analyze it algebraically and automatically choose the best available Solver engine for it.
Automatic transformationPremium Solver Platform goes beyond model analysis -- if your model would solve slowly because it uses functions like IF, VLOOKUP and HLOOKUP, MIN and MAX, it will seek to transform your model automatically into a form that can be solved much more quickly and accurately.
Upgrade Solver EnginesWe developed the solver in Excel -- you get an extremely powerful, 100% compatible upgrade now, and the ability to "plug in" the world's best Solver engines for every type of optimization problem, whenever you need them.  Your plug-in Solver engines will work with all our Platform products.

Everything You Need to Develop and Deploy Powerful Optimization and Simulation Applications

Common, Easy-to-Use Object-Oriented API Use the same high-level objects (like Problem, Solver, Variable and Function), collections, properties and methods across different programming languages.
Web Service API for
PHP and JavaScript
The same object-oriented API is exposed "over the wire" through Web Services WS-* standards to remote clients in PHP, JavaScript, C# and other languages.
Procedural API for
Procedural languages can use conventional calls that correspond naturally to the properties and methods of the Object-Oriented API.
Solve linear, nonlinear, non-smooth problems Linear and quadratic programming, mixed-integer programming, smooth nonlinear optimization, global optimization, and non-smooth evolutionary and tabu search are all included.
8 Plug-in Large-Scale Solver Engines The world's best optimizers, from Gurobi™, XPRESS™ and MOSEK™ for linear, quadratic and conic models to KNITRO™, SQP and GRG methods for nonlinear models "plug into" Solver SDK.
Fast Monte Carlo Simulation Engine Easily define uncertain variables with sampling from 50 continuous, discrete and custom distributions, rank-order correlation of dissimilar distributions, and distribution fitting.
Large-Scale Sparse Matrix Objects Easily create a sparse DoubleMatrix object with 1 million rows and columns, and use it in your code with high performance and minimal memory use.
Parallelized Solver Algorithms Exploit multiple processor cores for optimization and Monte Carlo simulation using Solver SDK's built-in parallelized algorithms, without having to write parallel code yourself.
Thread-safe for Multi-user Applications Call Solver SDK on multiple concurrent threads -- making it easy to build Web server and other applications that handle multiple clients concurrently.
Solver Server Handles Multiple Client Apps Our Solver Server that supports a WS-* standard Web Services API is included with Solver SDK -- use it support to multiple remote clients concurrently.
Load, Update, Solve Excel Workbook Models Solver SDK can read Excel workbooks, interpret Excel formulas, and run Excel-based optimization and simulation model -- while running on a server without Excel itself.
Load, Update, Solve RASON Models Solver SDK can interpret models in our high-level RASON modeling language, bind to external data sources, and run RASON optimization and simulation models.
Load and Solve LP, MPS, OSiL Files Solver SDK can load and solve linear and mixed-integer programming models defined in these traditional file formats.
Example Applications in Multiple Languages Source code is included in each supported programming language for over 35 example applications, illustrating how to set up and solve every type of problem.
Help and Support Our 344-page SDK User Guide, 723-page SDK Reference Guide, 183-page Solver Engines User Guide, and our highly-regarded technical support supports your efforts.
Straightforward Runtime Licensing Obtain licenses to distribute Solver SDK with your application, or use it on your on-premise or cloud-based server(s), with simple terms that work for your application.

Compare Solver SDK Platform and Solver SDK Pro

The comparison chart below summarizes the differences between Solver SDK Platform and Solver SDK Pro.
We're happy to assist with any questions, to help make sure you find the right product for your unique needs.
Compare Solver SDK Platform and SDK Pro