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.
Define process flow and programming goals
From the course: Excel VBA: Process Modeling
Define process flow and programming goals
- [Instructor] In this chapter, you will create a simulation that defines a series of three stations and moves two customers through those stations. The idea is that the first customer moves through the entire sequence before the second customer starts. That is an unrealistic scenario, but it provides a simplified framework we can use as a base for more complicated models later in the course. Specifically in this chapter, we will declare all the variables we need, define classes for customers and stations, which are the business objects within the simulation, and then we will add stations and assign values to properties. Following that, we will clean up any unneeded objects. Then, with all of that programming in place, we will run the simulation once to make sure it works, and then run it multiple times so that we can see how results vary over time.
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)
-
-
-
-
-
-