When you create a Solver model, you refer to the formulas and data in your worksheet. You can save yourself a lot of time by organizing your worksheet so cells with similar properties, such as costs or summary calculations, are located in the same column or row.
- [Instructor] When you create a Solver model,…you refer to the formulas and data in your worksheet.…You can save yourself a lot of time…by organizing your worksheet…so cells with similar properties,…such as costs or summary calculations,…are located in the same column or row.…In this movie, I will show you one way…to organize an Excel worksheet for use in Solver.…My sample file is the Organizing workbook.…And you can find it in the Chapter01 folder…of the Exercise Files collection.…This workbook contains the data for a mixing problem.…
If we look down at the bottom part of the visible worksheet,…and we'll see in the Mixture section…that I have five mixes.…And each of those mixtures contains a particular percentage,…or proportion, of these four elements.…What I want to do is to create mixtures…that have at least these minimum required amounts…of each of those four elements.…So I see here my target values,…0.18, 0.2, 0.2, and 0.12…for chalcedony, aventurine, rock crystal, and milky quartz,…respectively.…
I want to create 13 units total.…
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