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.

Add more stations to the simulation

Add more stations to the simulation - Microsoft Excel Tutorial

From the course: Excel VBA: Process Modeling

Start my 1-month free trial Buy for my team

Add more stations to the simulation

“

- [Instructor] Up until now, all of our examples have assumed a business process with three stations. In this movie, I will show you how to add more stations to the process. And the good news is that all we really need to do is add information about the station's average processing time, standard deviation and capacity. The code we've built can bring in the data with no problem. My sample file is chapter 0504, and you can find it in the chapter five folder of the exercise files collection. This is the same data that we used in the previous movie with one change, and that is for station number three. The next station is four instead of minus one. And again, minus one is the next station value we are using to indicate that a customer has successfully completed the process and has left the business. So let's go ahead and add in information for stations four and five. So click cell A8, and this will be station number four. And then the mean processing time, the average is 12, standard…

Contents