|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/operations-research-with-microsoft-excel/
课程评论：没有评论
课程名称：运筹学——运输、分配与排序 课程概述：运筹学（Operations Research，简称OR）是一门通过开发和应用高级分析方法以改善决策的学科。它被视为数学科学的一个子领域，也广泛应用于管理科学。运筹学运用其他数学科学的技术，如建模、统计和优化，能够为复杂的决策问题提供最佳或近似最佳的解决方案。由于其强调实际应用，运筹学与许多其他学科有交集，包括工业工程等。运筹学通常关注于确定某些现实目标的极值，例如在利润、绩效或产量方面的最大值，或在损失、风险或成本方面的最小值。运筹学起源于二战前的军事需求，其技术已扩展到多个行业以解决各种问题。 在本课程中，我将教授如何使用Microsoft Excel解决运筹学问题，包括运输问题和分配问题等。我将演示两个具体问题的解决方案，相关的Excel电子表格可供下载。课程将首先介绍运筹学的基本概念，然后说明如何利用Microsoft Excel的强大功能来解决运筹学问题。Excel中的求解器（Solver）功能比目标搜索（Goal Seek）更为强大，课程将以此为基础进行讲解。该课程适合不同水平的运筹学和Excel学习者。祝大家学习愉快！
Operations research also called "OR" is a discipline that deals with the development and application of advanced analytical methods to improve decision-making. It is could be considered as a subfield of mathematical sciences and it is also used in management science. Employing techniques from other mathematical sciences, such as modeling, statistics, and optimization, operations research arrives at optimal or near-optimal solutions to complex decision-making problems. Because of its emphasis on practical applications, operations research has overlap with many other disciplines including but not limited to industrial engineering. Operations research is often concerned with determining the extreme values of some real-world objective: the maximum values in case of profit, performance, or yield or minimum of loss, risk, or cost. Like many other fields it originated in military efforts before World War II, its techniques have grown to address the problems in a variety of industries. In this program I am teaching how to solve operations research problems using Microsoft Excel. This could be transportation problem, assignment problem etc. I shall be solving two problems here. The relevant Excel spreadsheets which are fully open can be downloaded from here. In this course I shall discuss what is operations research and then explain how the power of Microsoft Excel can be used for solving operations research problems. Excel has a very powerful engine behind its solver, which will be used for the purpose of solutions given in this course. Solver is more powerful than Goal Seek in Excel. This can be taken by students of operations research and Microsoft Excel of all levels. Happy learning!
