Using Excel for Optimization

Using Excel for Optimization by Michael Nichols

Initial Setup The Analysis ToolPack on the Microsoft Office CD includes the Solver. Select the Tools menu and choose “Add Ins”. Check the box corresponding to the Analysis ToolPack.

Transportation Example

Problem Setup Each Garage has a cost associated with sending to each Location. Each Location has a minimum number of needed buses.

Problem Setup (cont.) Each Garage has the total number of buses being sent as a constraint. Each location has the total number of buses allocated, also as a constraint. This will be the area that can be modified by the solver to find the solution.

Problem Setup (cont.) Each Time entry is a sum of the Buses sent multiplied by the cost to send to each location. Ex: “=(LocA*Garage1)+(LocA*Garage2)+(LocA*Garage3)” Total is a sum of the times.

Solver Settings Select “Solver” from the Tools menu. In this section, you will be able to enter your constraints as well as select the method used to find your solution.

Problem solution

Using Excel for Optimization

Using Excel for Optimization

Presentation Transcript

Using Excel for Test Metrics

Using Excel Solver for Linear Optimization Problems

Using Excel

Solving Nonlinear Optimization Problems with Excel Solver for Microsoft Excel 2000

Using excel

Querying Using Excel

Optimization in Excel

Using Excel for Data Analysis

Using Excel Program

Plot Using Excel

Demo Using Excel

Using Excel

Using Microsoft Excel

Solving Linear Optimization Problems with Excel Solver for Microsoft Excel 2000

Using Microsoft Excel

USING EXCEL FOR KEEPING STUDENT RECORDS

Statistics for Managers Using Microsoft Excel

Using MS Excel for LP

Using Excel

Numerics for PDE using EXCEL