Introduction
Enhance your Solver analysis by adding VBA
(00:29)
What you should know
(01:08)
1. Defining Solver Simulations Using VBA
Create a reference to the Solver VBA library
(02:09)
Record and run a Solver macro
(06:50)
Generate random inputs
(07:11)
Define a loop structure to run multiple simulations
(05:56)
2. Analyzing Solver Simulation Results
Create an output summary worksheet
(05:18)
Write model output to the summary worksheets
(06:51)
Identify successful and unsuccessful solutions
(05:32)
Create a results dashboard
(06:49)
Explore alternative scenarios using Solver
(05:35)
Conclusion
Next steps
(01:11)
Ex_Files_Excel_Supply_Chain_Analysis.zip
(215 KB)