From the course: Excel VBA: Process Modeling
Join today to access over 25,300 courses taught by industry experts.
Add customers to the simulation - Microsoft Excel Tutorial
From the course: Excel VBA: Process Modeling
Add customers to the simulation
- [Instructor] Now that we have the structure in place to calculate each customer's arrival time, with the first starting at time one, we can add the code to create new customers when the ticker, which is the simulations internal clock, reaches that arrival time. In this movie, I will add the customer generation code inside of the ticker loop, and calculate the arrival time for the next customer as well. My sample file is chapter 0403, and that is a macro enabled workbook that you can find in the chapter four folder of the exercise files collection. On the SIM setup worksheet, I have the Poisson Data lookup that I created earlier, and we are going to use that inside of our Excel VBA code to generate random customer arrival times. You'll probably see a different number than 20, because, it's a random number. And, I'll just press F nine a few times to recalculate, so we get 11, which is pretty small, 18, closer to average, back to 11, and we could keep going. It appears that everything…
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.