|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/develop-of-shift-work-optimization-with-ai-and-excel/
课程评论：没有评论
**Coursera 课程总结： 使用 AI 和 Excel 进行排班优化开发** 本课程教授如何利用人工智能（特别是遗传算法）和 Excel（包括 VBA）来优化排班工作。课程面向具有 Excel 基础的高级用户，旨在帮助学员掌握排班优化理论和实际操作技巧，以及提升日常 Excel 工作效率。 **核心亮点：** * **AI 基础：** 深入了解遗传算法的基本原理。 * **Excel 实操：** 学习实用的 Excel 函数和 VBA 编程技巧。 * **排班优化理论：** 理解排班优化的核心概念。 * **项目式学习：** 课程采用循序渐进的搭建方式，如同组装模型，让学习过程更具趣味性。 * **高价值源码：** 提供市场上稀缺的排班优化应用程序源码，并附带源码解释，允许学员自由定制，具有极高的实际价值（相当于数百万日元）。 * **开发实战：** 学习实际的开发流程和 VBA 技巧，学员将能够开发出可用于各种场景的实用应用程序，例如规划行程、成本估算或材料利用率优化等。 * **经济高效：** 课程不仅传授能带来收益的编程技能，还提供能直接创造价值的应用工具，性价比极高。 **课程内容（部分）：** * 遗传算法概述 * 编程指导 * 排班表设计与创建 * 生成初始排班 * 代际演化、评估与性能分析 **必备要求：** * Excel 2016 或更高版本的 Windows 版本。 * 支持 Spill 函数。 **重要提示：** * 课程内容侧重于高级应用，基础知识将不予赘述。 * 课程内容为机器翻译，可能存在少量误译。
LearnLearn the basics of AI (genetic algorithm)Learn practical Excel function techniquesLearn practical VBA techniquesLearn shift optimization theoryLearn techniques to improve daily Excel workSeminar RequirementsIt works with Excel 2016 or later version for Windows.Important notice: Please prepare a version that can use the Spill function.The original is in Japanese, and the English version was created utilizing a machine translation.There might be some mistranslations.Since this is for advanced users, basic explanations are omitted.Course Content Features of this course You will learn while enjoying the process of building little by little just like assembling a plastic model. Usually get an expensive shift optimization app. The source code, which is not available on the market, is also included, so it is worth several hundred thousand yen in real value. Furthermore, you can freely customize it to your needs because it even comes with an explanation of the source code.Will also learn the actual development process and VBA tips.Will be able to apply it to various uses and develop useful applications.For example, it can be used to calculate the shortest or cheapest itinerary, or to plan products that make effective use of materials.Key FeaturesThis is a very economical course that gives you the programming skills to make money and the apps to make money.Curriculum Introduction1. Seminar Introduction2. Overview of Genetic Algorithms3. Programming Guidelines4. Design5. Creation of shift table base6. Generation of first shift7. Generational evolution, evaluation, and performance analysis
