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 with added station capacity

Run the simulation with added station capacity - Microsoft Excel Tutorial

From the course: Excel VBA: Process Modeling

Start my 1-month free trial Buy for my team

Run the simulation with added station capacity

“

- [Instructor] In the previous movie, we added properties to the station class and code to the main subroutine to give each station the ability to handle multiple customers at a time. In this movie, we will run the simulation and see how increasing capacity copes with shorter and shorter times between customer arrivals. My sample file is Chapter 05_03, and that is a macro-enabled Excel workbook that you can find in the Chapter 5 folder of the Exercise Files collection. I made a couple of changes to the SimSetup workbook. Specifically I added a capacity column, so now each station has a capacity. So Station 1 can handle two customers at once, Station 2 can still only do one, but Station 3 can also do two. And I also changed the mean for the poisson distribution, and we have our lookup table here. And the maximum value is 44. All right, with all of that in mind, I'll press Alt-F11 to move to the Visual Basic editor. And here I have code Module2 displayed. And I will make the code window…

Contents