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

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…

Contents