Develop Of Shift Work Optimization With Ai And Excel

What you'll learn
Learn the basics of AI using genetic algorithms
Learn practical Excel function techniques
Learn practical VBA techniques
Learn shift optimization theory
Learn techniques to improve daily Excel work
Requirements
It works with Excel 2016 or later version for Windows
Please prepare a version that can use the Spill function
The original is in Japanese, and the English versionwas created utilizing a machine translation
Since this is for advanced users,basic explanations are omitted
Description
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 WindowsImportant notice: Please prepare a version that can use the Spill functionThe 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 ContentFeatures of this courseYou will learn while enjoying the process of building little by little just like assembling a plastic model.You will obtain a shift optimization application that would normally cost several tens of thousands of yen.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.You will also learn the actual development process and VBA tricks.You will be able to apply this to a variety of applications and develop applications that can be sold.For example, you can use it to calculate the shortest itinerary, the 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 IntroductionSeminar IntroductionOverview of Genetic AlgorithmsProgramming GuidelinesDesignCreation of shift table baseGeneration of first shiftGenerational evolution, evaluation, and performance analysis
Overview
Section 1: Seminar Introduction
Lecture 1 Seminar Introduction
Section 2: Overview of Genetic Algorithms
Lecture 2 let me explain about genetic algorithms.
Lecture 3 Now, let's try it out.
Section 3: Programming Guidelines
Lecture 4 Development policy.
Section 4: Design.
Lecture 5 Desine
Section 5: Creation of shift table base
Lecture 6 Now we will create the base table for the shift table.
Section 6: Generation of first shift
Lecture 7 Let's create the first shift table.
Lecture 8 Actually run the macro.
Lecture 9 Create the rank table
Lecture 10 Into the shift table creation process.
Lecture 11 Set up the evaluation formula.
Lecture 12 In order to extract the best ones.
Lecture 13 Each time we run the simulation several times.
Section 7: Generational evolution, evaluation, and performance analysis
Lecture 14 Implement performance analysis.
Person in charge of improving operations in the workplace,People who want to use genetic algorithms in their work.,People who want to streamline shift work schedule creation,People who want to improve their programming skills using VBA

Homepage

https://www.udemy.com/course/develop-of-shift-work-optimization-with-ai-and-excel/