From the course: Excel VBA: Process Modeling
Unlock the full course today
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 three we added a timer to our simulation so we could track the movements of two customers through three stations. In this chapter we will extend that model to add customers throughout the simulation. We will use the Poisson distribution to generate random customer arrival times based on a known average gap between arrivals. We will also move the customer generation code inside of the timer, because the timing will be driving when new customers arrive. We'll write the results of the simulation to a worksheet instead of using debug.print like we were before. And finally, we will run the simulation and fix a mistake that could lead to customers getting stuck in a particular station.
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.