|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/optimization-with-excel-operations-research-without-coding/
课程评论：没有评论
课程名称：使用Excel进行优化：无代码的运筹学 课程概述： 近年来，企业的运营规划和长期规划变得愈加复杂。信息变化迅速，决策制定成为一项艰巨的任务。为了解决这些问题，优化算法（运筹学）被广泛应用于寻找最佳解决方案。该领域的专业人员在市场上十分抢手。如果你不懂编码，或者希望借助Excel解决优化问题，那么这是一个完美的课程。 在本课程中，你将学习如何应用以下方法无须编码地解决问题： - 线性规划 (LP) - 混合整数线性规划 (MILP) - 非线性规划 (NLP) - 混合整数非线性规划 (MINLP) - 遗传算法 (GA) - 带时间窗口的车辆路径规划问题 (VRPTW) 课程将探讨以下求解器：Gurobi、CBC、IPOPT、Bonmin、Couenne。此外，我们还将使用来自NEOS服务器的CPLEX限制版。 我会为你提供工作簿，帮助你轻松解决这些问题。GA和VRPTW将通过易于操作的工作簿解决。课程包括数学建模和Excel主要公式的简要介绍，方便你跟上课程的进度。 在课程和练习中，我们将逐步解决以下问题： - 路线优化问题 - 租车店收益最大化 - 维护计划问题 - 优化电力流：电力系统 - 其他多个示例，包括简单和复杂的问题，涉及求和和许多约束条件。 请注意：本课程的方法不适用于： - 需要分解和迭代的复杂问题 - 实时执行的操作性问题 - 需要快速解决的大型问题 - 多目标问题 课程中的方法不使用Excel的标准求解器，而在变量或约束条件的数量上没有限制。我不会教你如何安装Excel，但会教授所需工具的安装方法。你需要在计算机上安装Excel，并且课程工具只在Windows和MAC上经过测试。 课堂使用从商业概念到解决方案逐步创建的示例。我希望这个课程能够帮助你的职业发展，并且你将获得Udemy的认证。 关键词：运筹学、数学优化、优化决策
Operational planning and long term planning for companies are more complex in recent years. Information changes fast, and the decision making is a hard task. Therefore, optimization algorithms (operations research) are used to find optimal solutions for these problems. Professionals in this field are one of the most valued in the market.And if you do not known how to code and/or if you wish to solve optimization problems using Excel, this is a perfect course for you.In this course you will learn what is necessary to solve problems applying (without any coding):Linear Programming (LP)Mixed-Integer Linear Programming (MILP)NonLinear Programming (NLP)Mixed-Integer Linear Programming (MINLP)Genetic Algorithm (GA)And how to solve Vehicle Routing Problems with Time Window (VRPTW)The following solvers will be explored: Gurobi - CBC - IPOPT - Bonmin - Couenne We will also use CPLEX, but a limited version from NEOS server.Also, I provide workbooks for you that will facilitate to solve these problems. GA and VRPTW will be solved using workbooks that are very easy to work with.The course has a nice introduction on mathematical modeling and the main formulas from Excel. Thus, you can easily follow the classes.In addition to the classes and exercises, the following problems will be solved step by step:Route optimization problemMaximize the revenue in a rental car storeMaintenance planning problemOptimal Power Flow: Electrical SystemsMany other examples, some simple, some complexes, including summations and many constraints.You should NOT solve optimization problems in Excel for:Complex problems that requires decompositions and iterations. Since we do not use any programming language in the course, our approach would not be recommended to solve problems that requires iterations, such as Benders.Operational problems for real-time execution.Large problems that require fast solutions. The approach from the course does not have a limitation, but large problems may take a while to be converted from the Excel's formulas to the solver.Solve multi-objective problems.Attention:The approach in this course is NOT using the standard solver from Excel, our approach here has NO limitations on the number of variables or constraints.I do NOT show you how to install Excel. But I teach how to install the required tools.To follow the course you will need Excel installed on your computer. Moreover, the tools from the courses have been tested in Windows and MAC only.The classes use examples that are created step by step, from the business concept to the resolution.I hope this course can help you in your carrier. Yet, you will receive a certification from Udemy.Operations Research Operational Research Mathematical Optimization
