最新消息:网盘下载利器JDownloader--|--发布资讯--|--解压出错.密码问题

Lynda – Solving Optimization and Scheduling Problems in Excel

教程/Tutorials killking 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) 1280x720 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 Excel

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

网友最新评论 (1)

  1. Lynda - 使用Excel解决优化和计划问题 学习如何使用一个免费的Excel插件——Solver,找出角有多个约束问题的优化解决方案,包括线性和非线性混合、运输问题、计划冲突。作者Cur Frye会演示如何使用Solver组织Excle工作簿,添加和交换数据以及在Solver中建立每个问题的标准。在最后一章,你将学习如何分析Solver的结果、创建场景以及手动改变参数。 主要内容:使用Goal Seek找到目标值;组织工作簿;使用Solver找到解决方案;解决线性和非线性混合问题;解决运输问题;解决资源计划或体育计划位图;分析Solver结果。
    wilde(特殊组-翻译)2年前 (2015-06-24)