From the course: Excel Supply Chain Analysis: Managing Simulations Using VBA
Join today to access over 24,800 courses taught by industry experts.
Create an output summary worksheet - Microsoft Excel Tutorial
From the course: Excel Supply Chain Analysis: Managing Simulations Using VBA
Create an output summary worksheet
- [Narrator] Running simulations based on hundreds or thousands of solver scenarios, doesn't do you a lot of good. If you don't save the results for later analysis. In this movie, I will show you how to set up Excel worksheets to record the output summary from a small transportation model. My sample file is 02-01 results sheets, and you can find it in the exercise files folder. In this workbook I have three worksheets, the model sheet, which you see here is the model that we have worked with earlier in this course. I want to write the results from this model to another worksheet, actually two other worksheets, and that will start by moving to demand. So I'll go to the demand worksheet. And it's currently blank. My goal is to create an Excel table that will automatically number each row and that I can use to bring in the results from a simulation run. In cell A1, which I currently have selected I'll type my…
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.