Develop of shift work optimization with AI and Excel
COTAN IT コンサルティングサービス
37:29
Description
For very advanced and professional users. Excel and AI ultra-practical course. Let’s DL source code from resource.
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
Who is this for?
What You Need to Know?
More details
DescriptionLearn
Learn the basics of AI (genetic algorithm)
Learn practical Excel function techniques
Learn practical VBA techniques
Learn shift optimization theory
Learn techniques to improve daily Excel work
Seminar Requirements
It 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 Features
This is a very economical course that gives you the programming skills to make money and the apps to make money.
Curriculum Introduction
1. Seminar Introduction
2. Overview of Genetic Algorithms
3. Programming Guidelines
4. Design
5. Creation of shift table base
6. Generation of first shift
7. Generational evolution, evaluation, and performance analysis
Who this course is for:
- 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
Learn
Learn the basics of AI (genetic algorithm)
Learn practical Excel function techniques
Learn practical VBA techniques
Learn shift optimization theory
Learn techniques to improve daily Excel work
Seminar Requirements
It 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 Features
This is a very economical course that gives you the programming skills to make money and the apps to make money.
Curriculum Introduction
1. Seminar Introduction
2. Overview of Genetic Algorithms
3. Programming Guidelines
4. Design
5. Creation of shift table base
6. Generation of first shift
7. Generational evolution, evaluation, and performance analysis
Who this course is for:
- 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
User Reviews
Rating
COTAN IT コンサルティングサービス
Instructor's Courses
Udemy
View courses Udemy- language english
- Training sessions 14
- duration 37:29
- Release Date 2024/01/03
