From the course: Excel VBA: Process Modeling

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Run the simulation

Run the simulation - Microsoft Excel Tutorial

From the course: Excel VBA: Process Modeling

Start my 1-month free trial Buy for my team

Run the simulation

“

- [Instructor] In this chapter, we have modified an existing simulation to give a probability that customers will have to do a station instead of everyone having to do all of them. The sample file that I'm using is Chapter 06_03, and you can find that in the Chapter 6 folder of the Exercise Files collection. The specific changes we made are to the SimSetup worksheet, and here I have a new column for probability must do, and that is the probability a customer has to go through a particular station. So 85% of the time, customers will need to go through Station 2, but only 15% of the time, they will have to go through Station 3. So let's run a simulation and see what kind of results that we get. The results will be tabulated on the Results worksheet, and we're especially interested in the amount of time that customers are idle within the system. Our goal is to minimize that. So I'll press Alt-F11 to move to the Visual Basic editor. And then I'll change the window to the Module2 code…

Contents