With our data, chart, and control formulas in place, we can define our Solver model and analyze the results. This is a complex problem, so you'll need to use the evolutionary algorithm to find a solution.
- [Instructor] With our data, chart, and control formulas…in place we can define our solver model…and analyze the results.…This is a complex problem so we…will need to use the evolutionary algorithm…to find a solution.…I'll demonstrate how to create the solver model…using the location 05 workbook.…You can find it in the chapter three folder…of the exercise files collection.…I've already installed solver…and if you haven't you can find directions…on how to do that elsewhere in this course…but once it's installed, you can go to the data tab…of the ribbon and in the analyze group…at the far right click solver.…
Doing so displays the solver dialog box…which I'll drag just a little bit over to the right.…First thing we need to do is to set our objective…and that is to minimize the total distance…that will need to be traveled.…So that means that the total distance formula…which is in cell H6 will be the value that appears…in the set objective box so make sure…that the cursor is flashing there and click cell H6…and we want to minimize the value…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Finding target values using Goal Seek
- Finding a solution using Solver
- Tuning investment portfolios
- Organizing worksheets
- Creating objective and control formulas
- Experimenting with different constraints
- Optimizing resource placement
- Defining decision trees