Optimizing machine changeovers in Excel and Python

Optimizing machine changeovers in Excel and Python, available at $19.99, with 12 lectures, and has 1 subscribers.

You will learn about How to use Excel Solver in Excel for mathematical programming How to use Python for mathematical programming Define a changeover matrix for a machine Define changeover sequencing problem as mathematical optimization problem Implement a single machine changeover sequence optimization problem in Excel Solver Implement a single machine changeover sequence optimization problem in Python This course is ideal for individuals who are Production planners or Excel and Python learners or Students of majors such as operations research, industrial engineering, production management, or similar It is particularly useful for Production planners or Excel and Python learners or Students of majors such as operations research, industrial engineering, production management, or similar.

Enroll now: Optimizing machine changeovers in Excel and Python

Summary

Title: Optimizing machine changeovers in Excel and Python

Price: $19.99

Number of Lectures: 12

Number of Published Lectures: 12

Number of Curriculum Items: 12

Number of Published Curriculum Objects: 12

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

How to use Excel Solver in Excel for mathematical programming
How to use Python for mathematical programming
Define a changeover matrix for a machine
Define changeover sequencing problem as mathematical optimization problem
Implement a single machine changeover sequence optimization problem in Excel Solver
Implement a single machine changeover sequence optimization problem in Python

Who Should Attend

Production planners
Excel and Python learners
Students of majors such as operations research, industrial engineering, production management, or similar

Target Audiences

Production planners
Excel and Python learners
Students of majors such as operations research, industrial engineering, production management, or similar

This course provides a practical introduction to mathematical modeling and optimization in Excel and Python, using

Excel Solver in Excel
PuLP and default free solvers through PuLP in Python

A concrete use case serves as application example: Mathematical optimization of machine setup and changeover sequences. There are many versions of this problem, but in course we will focus on two single machine setup and changeover sequencing problems:

Optimal setup and changeover sequence for a one-time production program
Optimal changeover sequence for a repeated production cycle, i.e. repetitive cyclic production program

As part of this course, you will see and learn

How to formally define a changeover sequencing problem mathematically
Get an overview of modeling frameworks and solvers in Excel and Python
How to setup Excel Solver and how to implement mathematical models with Excel Solver
How to implement and solve mathematical optimization models with PuLP in Python

As part of the course you will be get access to case study data, case study descriptions, mathematical model defintions, Excel files, and Python scripts. You can use these as templates for your specific problem.

Requirements for taking this course

Some basic knowledge of mathematical programming: You should have head about linear optimization before
Intermediate Python skills: You should know what a list comprehension is, and you should be familiar with common libraries such as NumPy
Beginner Excel skills: You should be comfortable writing and using formulas, but you do not need to have heard about Excel Solver before; and you will also not need to write any macros etc. at all

Course Curriculum

Chapter 1: Introduction to machine changeover sequencing

Lecture 1: Course introduction and overview

Lecture 2: Understanding the changeover and setup sequencing problem

Chapter 2: Mathematical programming for machine changeover sequencing

Lecture 1: Mathematical model for the one time only production program

Lecture 2: Mathematical model for the repeated production cycle problem

Chapter 3: Solving machine changeover sequencing problem with Excel Solver

Lecture 1: Activating and using the Excel Solver add-in

Lecture 2: Getting started in Excel Solver – simple first optimization model

Lecture 3: Implementing the repeated production cycle problem in Excel Solver

Lecture 4: Implementing the one-time-only production program problem in Excel Solver

Chapter 4: Solving machine changeover sequencing problem in Python

Lecture 1: Tools in Python for mathematical modeling and optimization

Lecture 2: Getting started in Python – simple first optimization model

Lecture 3: Implementing the repeated production cycle problem in Python

Lecture 4: Implementing the one-time-only production program in Python

Instructors

Linnart Sining Felkl
Simulation expert and engineer

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu