Excel Supply Chain Analysis: Managing Simulations Using VBA

Focused View

Curt Frye

54:59

0 View

[1] Introduction

[1] Enhance your Solver analysis by adding VBA.mp4

00:29

[2] What you should know.mp4

01:08

[2] 1. Defining Solver Simulations Using VBA

[1] Create a reference to the Solver VBA library.mp4

02:09

[2] Record and run a Solver macro.mp4

06:50

[3] Generate random inputs.mp4

07:11

[4] Define a loop structure to run multiple simulations.mp4

05:56

[3] 2. Analyzing Solver Simulation Results

[1] Create an output summary worksheet.mp4

05:18

[2] Write model output to the summary worksheets.mp4

06:51

[3] Identify successful and unsuccessful solutions.mp4

05:32

[4] Create a results dashboard.mp4

06:49

[5] Explore alternative scenarios using Solver.mp4

05:35

[4] Conclusion

[1] Next steps.mp4

01:11

Description

Did you know you can record and run Solver macros, generate random inputs, run multiple simulations, and more, in Excel? Moreover, you can do all this without buying expensive specialty software. In this course, instructor Curt Frye shows how to enhance your supply chain analysis using the Solver add-in in combination with VBA. Working from an example transportation problem, Curt steps through creating a reference to the Solver VBA library, recording and running a Solver macro, generating random inputs, and defining a loop structure to run multiple simulations. Then he moves on to enabling detailed analysis by writing model output, creating a results dashboard to analyze your model output, exploring alternative scenarios with a Solver model, and more.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel VBA

Supply Chain

Curt Frye

Instructor's Courses

I'm president and founder of Technology and Society, Incorporated, an Oregon "C" Corporation that encompasses my work as a course developer, writer, and speaker. I offer programs on effective teamwork, personal development, and business storytelling. BA (political science) and MBA.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.