From the course: Excel VBA: Process Modeling
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Define process flow and programming goals
From the course: Excel VBA: Process Modeling
Define process flow and programming goals
- [Instructor] In chapter five, we extended our simulation to allow for rework loops where a customer spends more than the expected time at a station. In this chapter, we will simulate a related scenario where a customer has a probability of moving to either station two or station three after they're done with station one. In both cases, the next station will be station four. So in this chapter, we will record probabilities of moving to one station or another. Now of course, you can extend those techniques to more branches in the process, but we'll keep it simple just for demonstration and do one. You could also add rework loops or other elements, but when you're adding multiple elements to a simulation, you need to make sure that each improvement works before you move on. Get a little bit working, make a backup copy of your workbook, and go on from there.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.