From the course: Excel Supply Chain Analysis: Managing Simulations Using VBA
Join today to access over 24,400 courses taught by industry experts.
Identify successful and unsuccessful solutions - Microsoft Excel Tutorial
From the course: Excel Supply Chain Analysis: Managing Simulations Using VBA
Identify successful and unsuccessful solutions
- [Instructor] When you run a solver model using VBA, you can configure solver. So it keeps running, even if it can't find the solution for a particular value set. Knowing which trials were successful, meaning a solution was found and which were not, can be extremely useful. In this movie, I will show you one way to keep track of which runs were successful and which were not. My sample files 02 03 Fulfillment. And you can find that in the exercise files folder. I haven't changed anything on the model sheet worksheet. However, we do need to make some changes by adding formulas to the demand and shipments worksheets. So I'll click the demand sheet tab, and here we need to find the total of our demand, which will be written in from VBA. So once we have a total, we can indicate whether demand was greater than capacity, which is in cell I2. And whether we have any unfulfilled demand. So we have a one or a zero indicating…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
