From the course: Excel VBA: Process Modeling
Join today to access over 24,900 courses taught by industry experts.
Run the simulation - Microsoft Excel Tutorial
From the course: Excel VBA: Process Modeling
Run the simulation
- [Instructor] Okay, we have done a lot of work in this chapter. We have extended the clock-based simulation that we created in chapter 3 to add new customers as the simulation runs. Those customers arrival times were calculated using the Poisson distribution, and their time at each station calculated using the normal distribution. In this movie, I will show you how to run your simulation and correct an aspect of station timing that I originally overlooked. The sample file that I will use is Chapter04_05, and you can find it in the Chapter04 folder of the Exercise Files collection. I'm currently on the SimSetup worksheet, which has information about the simulation setup, and also, to generate customer interarrival times. And then we'll write our results out to the Results worksheet. And I have added a couple of formulas to this particular worksheet. In column G, I have the time that a customer has spent in the system, and then also calculating the percentage of idle time. So we have…
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.