From the course: Excel VBA: Process Modeling
Join today to access over 25,300 courses taught by industry experts.
Run the simulation - Microsoft Excel Tutorial
From the course: Excel VBA: Process Modeling
Run the simulation
- [Instructor] 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 applied that information to discover how long customers will spend within the system. In this movie, we will run the simulation a couple of times to see its results. My sample file is chapter 0207, and you can find it in the chapter two folder of the exercise files collection. I don't need to do anything in the sim setup worksheet, so I'll press ALT+F11 to move to the Visual Basic editor, and then I will click the title bar of the module one code module and then I'll just expand a little bit so the contents are easier to read, although we won't do any editing. The output will be written to the immediate window, which is below, and if you don't see it, you can press Ctrl+G to display it. So I can hide it and then press Ctrl+G to display it again. To run my code, I will click inside of the…
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.
Contents
-
-
-
-
(Locked)
Describe process flow and programming goals1m
-
(Locked)
Declare variables used in the simulation7m 12s
-
Define the Customers class and add a customer3m 46s
-
(Locked)
Define the Stations class and add stations8m 12s
-
(Locked)
Add code to calculate and write out times6m 21s
-
(Locked)
Delete unneeded objects1m 47s
-
(Locked)
Run the simulation1m 43s
-
(Locked)
Adapt the code for multiple runs5m 12s
-
(Locked)
-
-
-
-
-
-