Optimizing machine changeovers in Excel and Python
Free Download Optimizing machine changeovers in Excel and Python
Published 11/2023
Created by Linnart Sining Felkl
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 12 Lectures ( 2h 20m ) | Size: 866 MB
An practical introduction to mathematical programming in Excel and Python
What you'll 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
Requirements
Basic knowledge of linear programming required
Basic knowledge of mathematical programming required
Basic Python knowledge required
Basic Excel knowledge required
Description
This course provides a practical introduction to mathematical modeling and optimization in Excel and Python, usingExcel Solver in Excel PuLP and default free solvers through PuLP in PythonA 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 programOptimal changeover sequence for a repeated production cycle, i.e. repetitive cyclic production programAs part of this course, you will see and learnHow to formally define a changeover sequencing problem mathematicallyGet an overview of modeling frameworks and solvers in Excel and PythonHow to setup Excel Solver and how to implement mathematical models with Excel Solver How to implement and solve mathematical optimization models with PuLP in PythonAs 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 courseSome basic knowledge of mathematical programming: You should have head about linear optimization beforeIntermediate Python skills: You should know what a list comprehension is, and you should be familiar with common libraries such as NumPyBeginner 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
Who this course is for
Production planners
Excel and Python learners
Students of majors such as operations research, industrial engineering, production management, or similar
Homepage
https://www.udemy.com/course/optimization-models-in-excel-and-python/
Rapidgator
rcjes.Optimizing.machine.changeovers.in.Excel.and.Python.rar.html
Uploadgig
rcjes.Optimizing.machine.changeovers.in.Excel.and.Python.rar
NitroFlare
rcjes.Optimizing.machine.changeovers.in.Excel.and.Python.rar
Fikper
rcjes.Optimizing.machine.changeovers.in.Excel.and.Python.rar.html
Optimizing machine changeovers in Excel and Python Torrent Download , Optimizing machine changeovers in Excel and Python Watch Free Online , Optimizing machine changeovers in Excel and Python Download Online
In today's era of digital learning, access to high-quality educational resources has become more accessible than ever, with a plethora of platforms offering free download video courses in various disciplines. One of the most sought-after categories among learners is the skillshar free video editing course, which provides aspiring creators with the tools and techniques needed to master the art of video production. These courses cover everything from basic editing principles to advanced techniques, empowering individuals to unleash their creativity and produce professional-quality content.
Comments (0)
Users of Guests are not allowed to comment this publication.