Index

ABS function

Add Constraint window

Add objective

Add-ins tab

Additivity

Algebraic formulations

Algebraic models

Algebraic solutions

Algebraic solvers

Algorithms

evolutionary solver

Standard GRG Nonlinear Engine

See also Nonlinear solver

for integer programming

reliable algorithm

simplex algorithm

Alldifferent constraint

Allocation models

investment allocation model

product mix problem

sensitivity analysis

Allocation problem

Allowable Increase/Decrease columns

Alternative optima

Analyst

Arcs

Artificial variables

Assignment models

in the traveling salesperson problem

Assignment problem

Assume Non-Negative option

Automatic Scaling option

Auxiliary variables

Balance equations

funds flow model

general-network models with

transformed flow

network models with

Base case

Basic feasible solution

Basic variables

Binary choice

Binary choice models

capital budgeting problem

matching problem

playoff scheduling problem

set-covering problem

set-packing problem

set-partitioning problem

Binary variables

and the IF function

Binding constraints

Blending models

Blending problem

Bounding

Branch and bound

Branching

Canonical equations

Canonical form

Capacitated facility location problem

Capacity constraints

Capital budgeting problem

Case studies

allocation problem

assignment problem

blending problem

capacitated facility location

problem

capital budgeting problem

data envelopment analysis (DEA)

problem

fixed cost problems

funds flow problem

general-network problem with yield

losses

general-network ...

Get Optimization Modeling with Spreadsheets, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.