Join Curt Frye for an in-depth discussion in this video Reading the simulation results as written, part of Excel VBA: Process Modeling.
- After you run a simulation or set of simulations,…you should take some time to examine the results…to gain insights into the system you modeled.…The code we created in this course writes out information…about each customer's progress through a series…of stations in a process but we could just have…easily have written out information about stations…and the time they spend idle and occupied.…In this movie, I will show you how to gain…insights into your operation by looking over a…simulation's results as written by our code.…
My sample file is the Excel workbook Chapter06_01…and you can find that in the chapter six folder of…the exercise files collection.…I have already run a simulation, and we can…find the results on the Results worksheet,…so I'll click that tab now.…And there we can see the results.…The first thing I'll do is just to quick scan to…make sure that no customers…got caught in a particular station.…If you remember from chapter four, I made…a programming error in the early iterations of…development, and what happened was that…
Author
Released
3/2/2016- Creating a class module in VBA
- Defining class properties
- Creating collections
- Describing process flow and programming goals
- Creating loops
- Increasing capacity of a model
- Running simulations
- Analyzing simulation results
Skill Level Advanced
Duration
Views
Related Courses
-
Windows Server 2012 R2: Configuring Hyper-V
with Timothy Pintello2h 24m Intermediate
-
Introduction
-
Welcome1m 16s
-
-
1. Defining Necessary VBA Constructs
-
Creating a class module3m 16s
-
Defining class properties5m 58s
-
Creating collections8m 33s
-
-
2. Developing Process Control Structures
-
Deleting unneeded objects2m 38s
-
Running the simulation2m 27s
-
3. Adding a Ticker to Track Time
-
Running the simulation2m 48s
-
4. Adding Customers During the Simulation
-
Running the simulation8m 11s
-
5. Recording Simulation State
-
Adding rework loops to stations11m 22s
-
6. Analyzing Simulation Results
-
Conclusion
-
Next steps1m 55s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Reading the simulation results as written