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.
Run the simulation
- So far in this chapter you have created a simulation that takes information about a series of stations within a business process, such as a sandwich shop that makes food to order, and applies that information to discover how long customers will spend within the system. In this movie we'll run the simulation a couple of times to see its results. We have already ran all the information we need from the sim setup worksheet so I'll press ALT+F11 to move to the visual basic editor. And here we have to code that we completed in the last movie. What this process does is read in the number of stations and then it creates customers and stations collections, adds customers and stations, reads in information about the stations, the station ID, the average processing time, and the standard deviation and then steps through to generate a processing time for each station within the system. At present it only does…
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.
Contents
-
-
-
-
(Locked)
Define process flow and programming goals55s
-
Declare variables used in the simulation6m
-
(Locked)
Define the Customers class and add a customer4m 48s
-
(Locked)
Define the Stations class and add a station8m 56s
-
(Locked)
Add code to calculate and write out times6m 2s
-
(Locked)
Delete unneeded objects1m 50s
-
(Locked)
Run the simulation1m 55s
-
(Locked)
Adapt the code for multiple runs4m 8s
-
(Locked)
-
-
-
-
-
-