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.
Add customers to the simulation
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, the simulation's internal clock, reaches that arrival time. In this movie, I'll add the customer generation code inside the ticker loop and calculate the arrival time for the next customer as well. My sample file is chapter 04-03, and you can find it in the chapter four folder of the exercise files collection. In this workbook, on the SimSetup worksheet, you'll see that we have the Station data over on the left and the Poisson data for arrival times on the right. You might see a different value in cell K2, which is currently the active cell, and that's just because we're using randomization to create new values. So, don't worry if what you see is different. We won't be making any changes on this worksheet in this movie, so…
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.