最新消息:请大家多多支持

Lynda – Solving Optimization and Scheduling Problems in Excel

教程/Tutorials dsgsd 210浏览 0评论


Lynda - Solving Optimization and Scheduling Problems in Excel

Lynda – Solving Optimization and Scheduling Problems in Excel

Size: 291MB | Duration: 2h 19m | Video: AVC (.mp4) 1280×720 15fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

Learn how to use Solver, a free Excel add-in, to find optimal solutions to problems with multiple constraints, including linear and nonlinear mixtures, transportation problems, and scheduling conflicts. Along the way, author Curt Frye shows how to organize Excel worksheets for use with Solver, add and swap data, and set each problem’s criteria in Solver. In the final chapter, you’ll learn how to analyze Solver’s results, create scenarios, and change parameters by hand.

Topics include:

* Finding target values using Goal Seek
* Organizing worksheets
* Finding a solution using Solver
* Solving linear and nonlinear mixture problems
* Solving transportation problems
* Solving resource scheduling or sports scheduling problems
* Analyzing Solver results
Lynda - Solving Optimization and Scheduling Problems in ExcelLynda - Solving Optimization and Scheduling Problems in Excel

转载请注明:0daytown » Lynda – Solving Optimization and Scheduling Problems in Excel

您必须 登录 才能发表评论!