Full Sized Products Analytic Solver Basic Analytic Solver ...

[Pages:2]Platform

Built-in Solver Engine Size Limits Evolutionary Linear Nonlinear Interval Global SOCP Barrier Optimization Problem Types and Sizes Solvers LP, MIP, NLP, and NSP problem types Special Solvers for QP, QCP, and SOCP problem types Linear Variables x Constraints Nonlinear Varaibles x Constraints Non-Smooth Variables x Constraints Integer Variables Accepts optional plug-in Solver Engines (w/ unlimited Variables x Constraints) Constraints Normal, Integer, Binary, semi-continuous, and AllDifferent Constriants Second Order Cone Constraints Probabilistic and Chance Constraints Global Optimization Non-Smooth Problems (Evolutionary) Nonlinear Problems (Multistart) Nonlinear Problems (Interval Global) Plug-in Solver Engines (Several Approaches) Advanced Stochastic Optimization Solve stochasic programming deterministic equivalent model Robust optimization for large scale models with uncertainty Automatic adjustment of chance constraints in robust optimization VaR/CVaR constriants with adjustable tolerances Simulation and Simulation Optimization Fastest Monte Carlo simulation and simulation optimizations in Excel Fastest simulation optimizations in Excel State of the art simulation optimization & sensitivity/scenario analysis Simulation Optimization Variables and Constraints Over 50 distributions and over 30 statistics and risk measures built-in Full support for fitting, certifying, and sharing distributions Ability to correlate uncertain input distributions Built-in chance constraints and risk measure objectives Full support for recourse decisions under uncertainty Decision Trees Easy to use decision trees with rollback values and sensitivity analysis Support for simulation with probability distributions in the tree Support for optimization of values in the tree Ease of Use and Guidance Context sensitive help and included example moels Comprehensive charting, reporting, and sensitivity/scenario analysis Constraint wizard for easily specifying needed constraints Distribution wizard to help you select the right probability distribution Built-in Guided Mode assistance Automatic diagnoss of model type and selection of best engine Solution Speed and Accuracy Directly access all available processor cores Find linear, nonlinear, non-smooth formulas Determine whether model is convex Determine if and how objective and constraints depend on uncertainty to enable stochastic transformation

Use vectorized calculations to speed Monte Carlo trials "Linearize" IF, MIN, MAX, ABS, logical formulas for faster solution times and probably optimal solutions

Psi Interpreter for fastest, most accurate, optimization solves Psi Interperter for fastest, most accurate, simulations Use Stochastic Programming for Recourse constraints Use Robust Optimization for Chance constraints Speed (approximate vs. the basic Excel Solver) Problem Setup Linear Problems Nonlinear Problems Mixed-Integer Problems Non-Smooth Problems Plug-in Solver Engines Solver Reports Answer Report Solutions Report Population Report Limits Report Linearity Report Feasibility Report Sensitivity Report Simulation Report Simulation Parameter Sensitivity Report Uncertianty Report Scaling Report Structure/Convexity Report Transformation Report Charting Capabilities Comprehensive chart customization including type (line, area, bar), headings, axis, and legend labels, cutoffs, and markers

Sensitivity charting including Tornado and Parameter Analysis Multiple Optimization charts including Monitored Cell and Parameter Analysis Multiple Simulation charting including Overlay Trend, Box-Whisker, Parameter Analytis and Statistics charts

Frontline Solvers Tools for Excel Comparison Chart (We also have comparison charts available for our Academic products and our SDK products for developers.)

Limited Size Products

Analytic Solver Basic

Analytic Solver Upgrade

All Features/Limited Size Limits

Expanded Size Limits for Optimization Basic Size Limits for Simulation, Data Mining

W indows

W indows

Analytic Solver Simulation

Full Size Limits for Simulation

Basic

Size Limits for Optimization, Data Mining

W indows

Full Sized Products

Analytic Solver Optimization

Analytic Solver Data Mining

Full Size Limits for Optimization Basic Size Limits for Simulation, Data Mining

Full Size Limits for Data Mining Basic Size Limits for Optimization, Simulation

W indows

W indows

Yes Yes Yes Yes Yes

Yes Yes 200 x 100 200 x 100 200 x 100 Up to 200 No

Yes Yes Yes

Yes Yes Yes No

Yes Yes Yes Yes

Yes Yes Yes 50 x 25 Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes

Yes Yes Yes Yes Yes

2-100X 40X 7-15X 10-200X 1-10X

Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Yes Yes Yes Yes Yes

Yes Yes 2,000 x 8,000 500 x 250 500 x 250 Up to 1,000 for LP and 500 for NLP/NSP No

Yes Yes Yes

Yes Yes Yes No

Yes Yes Yes Yes

Yes Yes Yes 50 x 25 Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes

Yes Yes Yes Yes Yes

2-100X 40X 7-15X 10-200X 1-10X

Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Yes Yes Yes Yes Yes

Yes Yes 200 x 100 200 x 100 200 x 100 Up to 200 No

Yes Yes Yes

Yes Yes Yes No

Yes Yes Yes Yes

Yes Yes Yes Unlimited x Unlimited Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes

Yes Yes Yes Yes Yes

2-100X 40X 7-15X 10-200X 1-10X

Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Yes Yes Yes (Upgraded Engine) Yes Yes

Yes Yes 8,000 x 8,000 1,000 x 1,000 1,000 x 1,000 Up to 2,000 for LP and 1,000 for NLP/NSP Yes

Yes Yes Yes

Yes Yes Yes Yes

Yes Yes Yes Yes

Yes Yes Yes 50 x 25 Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes

Yes Yes Yes Yes Yes

2-100X 40x 7-15x 10-200x 1-10x 10-1000x

Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Yes Yes Yes Yes Yes

Yes Yes 200 x 100 200 x 100 200 x 100 Up to 200 No

Yes Yes Yes

Yes Yes Yes No

Yes Yes Yes Yes

Yes Yes Yes 50 x 25 Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes

Yes Yes Yes Yes Yes

2-100X 40X 7-15X 10-200X 1-10X

Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Analytic Solver Comprehensive

Full Size Limits for all Features

W indows

Yes Yes Yes (Upgraded Engine) Yes Yes

Yes Yes 8,000 x 8,000 1,000 x 1,000 1,000 x 1,000 Up to 2,000 for LP and 1,000 for NLP/NSP Yes

Yes Yes Yes

Yes Yes Yes Yes

Yes Yes Yes Yes

Yes Yes Yes Unlimited x Unlimited Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes Yes Yes Yes Yes

Yes Yes Yes

Yes Yes

Yes Yes Yes Yes Yes

2-100X 40X 7-15X 10-200X 1-10X 10-1000x

Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Yes Yes Yes

Yes

Multiple Simulation Results charting including Overlay, Trend, and Box Whisker Uncertain Functions charts including Frequency, Cumulative, Reverse Cumulative, Sensitivity, and Scatter Plots DataMining Capabilities

Partitioning

Sample from Worksheet

Sample from Database

Text Mining

Feature Selection Handling Missing Values (#Rows x #Missing Values to be treated at one time) Bin Continuous Data (#Rows x #Columns in ouput)

Transform Categorical Data (#Rows x #Columns) Time Series (#Rows)

Classification and Prediction (#Rows) Affinity - Association Rules (#Transactions) Data Exploration & Reduction (#Rows x # Columns) # Clusters displayed in Dendogram Charts (#Rows x #Columns)

Frontline Solvers Tools for Excel Comparison Chart (We also have comparison charts available for our Academic products and our SDK products for developers.)

Analytic Solver Basic Yes

Limited Size Products Analytic Solver Upgrade Yes

Yes

Original Data: 65,000 Records Output: 50 Variables Original Data: 65,000 Records Output: 50 Variables (Stratified: 30) Original Data: 1,000,000 Records Output: 50 Variables (Stratified: 30) 100 Documents, 5,000 Characters, 50 Terms, 1 Text Variable

Yes

Original Data: 65,000 Records Output: 50 Variables Original Data: 65,000 Records Output: 50 Variables (Stratified: 30) Original Data: 1,000,000 Records Output: 50 Variables (Stratified: 30) 100 Documents, 5,000 Characters, 50 Terms, 1 Text Variable

10,000 Records, 50 Variables, 30 Distinct Classes 65,000 Records, 50 Variables 65,000 Records

10,000 Records, 50 Variables, 30 Distinct Classes 65,000 Records, 50 Variables 65,000 Records, 50 Variables

65,000 Records, 50 Variables, 30 Distinct Values 1,000 Rows

Training: 10,000 Training + Validation: 65,000 Scoring 65,000 65000, 100 Distinct Items 65,000 x 50 10 65,000 x 100

65,000 Records, 50 Variables, 30 Distinct Values 1,000 Rows

Training: 10,000 Training + Validation: 65,000 Scoring 10,000 65,000 65,000 x 50 10 65,000 x 50

Analytic Solver Simulation Yes

Yes

Original Data: 65,000 Records Output: 50 Variables Original Data: 65,000 Records Output: 50 Variables (Stratified: 30) Original Data: 1,000,000 Records Output: 50 Variables (Stratified: 30) 100 Documents, 5,000 Characters, 50 Terms, 1 Text Variable

10,000 Records, 50 Variables, 30 Distinct Classes 65,000 Records, 50 Variables 65,000 Records, 50 Variables

65,000 Records, 50 Variables, 30 Distinct Values 1,000 Rows

Training: 10,000 Training + Validation: 65,000 Scoring 10,000 65,000 65,000 x 50 10 65,000 x 50

Full Sized Products Analytic Solver Optimization

Yes

Analytic Solver Data Mining Yes

Yes

Yes

Original Data: 65,000 Records Output: 50 Variables Original Data: 65,000 Records Output: 50 Variables (Stratified: 30) Original Data: 1,000,000 Records Output: 50 Variables (Stratified: 30) 100 Documents, 5,000 Characters, 50 Terms, 1 Text Variable

10,000 Records, 50 Variables, 30 Distinct Classes 65,000 Records, 50 Variables 65,000 Records, 50 Variables

65,000 Records, 50 Variables, 30 Distinct Values 1,000 Rows

Original Data: Unlimited Records Output: Unlimited Variables Original Data: Unlimited Records Output: Unlimited Variables Original Data: Unlimited Records Output: Unlimited Variables Unlimited Documents, Unlimited Characters, Unlimited Terms, Unlimited Text Variables Unlimited Records, Unlimited Variables, Unlimited Distinct Classes

Unlimited Records, Unlimited Variables

Unlimited Records, Unlimited Variables Unlimited Records, Unlimited Variables, Unlimited Distinct Values

Unlimited Rows

Training: 10,000 Training + Validation: 65,000 Scoring 10,000

Transactions: 65000, #Distinct Items: 100 65,000 x 50 10 65,000 x 50

Training: Unlimited Records Training + Validation: Unlimited Scoring Unlimited

Transactions: Unlimited #Distinct Items: 5,000 Unlimited x Unlimited Unlimited Unlimited x Unlimited

Analytic Solver Comprehensive Yes

Yes

Original Data: Unlimited Records Output: Unlimited Variables Original Data: Unlimited Records Output: Unlimited Variables Original Data: Unlimited Records Output: Unlimited Variables Unlimited Documents, Unlimited Characters, Unlimited Terms, Unlimited Text Variables Unlimited Records, Unlimited Variables, Unlimited Distinct Classes

Unlimited Records, Unlimited Variables Unlimited Records, Unlimited Variables Unlimited Records, Unlimited Variables, Unlimited Distinct Values

Unlimited Rows

Training: Unlimited Records Training + Validation: Unlimited Scoring Unlimited

Transactions: Unlimited #Distinct Items: 5,000 Unlimited x Unlimited Unlimited Unlimited x Unlimited

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download