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.
Read the simulation results as written - Microsoft Excel Tutorial
From the course: Excel VBA: Process Modeling
Read the simulation results as written
- [Instructor] After you run a simulation or a set of simulations, you should take some time to examine your results to gain insights into your system. The code we've created in this course writes out information about each customer's progress through a series of stations in a process, but we could just as 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 simulations results as written. My sample file is Chapter 0701, and you can find it in the chapter seven folder of the exercise files collection. I have already run the simulation, so I will change to the results worksheet, and here I have my Excel table. And what I can do is just scroll through the data, and see if there's anything that catches my attention. For example, the first thing that I see looking down to the right is that this customer, customer number 16, had an idle time of 36.17%. However…
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.