From the course: Excel Supply Chain Analysis: Managing Simulations Using VBA

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Define a loop structure to run multiple simulations

Define a loop structure to run multiple simulations - Microsoft Excel Tutorial

From the course: Excel Supply Chain Analysis: Managing Simulations Using VBA

Start my 1-month free trial Buy for my team

Define a loop structure to run multiple simulations

“

- [Instructor] The real strength of VBA is using it to automate Solver simulations. Analyzing one set of inputs gives you an idea of how a scenario might play out, but running hundreds or even thousands of simulations with random data helps you develop a better picture of how a transportation network or other supply chain scenario might perform. In this movie, I will start to show you how to add multiple runs to a Solver simulation. My sample file is 01_04_MultipleRuns, and you can find it in the Exercise Files folders. This is the same model worksheet that we have been working with in previous movies. And remember that the values in cells C4 through C6 are generated below in cells C21 through C23, added up in cell C24. And then we used VBA to copy those values up. The reason we do that is because the RAND function is volatile, and we need to make sure that the values that we see in C4 to C6 match the values that we see…

Contents