…In some Solver models it's okay to have decimal values in your answers.…For example, you might be looking at proportions of…products, and it's okay to go down to decimal values.…But in this case, I'm looking at a…mailing, and I can't mail 0.18 of a coupon.…So what I need to do is identify a…solution that uses only integer, or whole number values.…I will show you how to do that, using the Integer Solutions…workbook, which you can find in the…chapter two folder of your exercise files archive.…
I've already applied a Solver model to this workbook, to find…the optimum mix of coupon mailings that generate the most revenue.…The problem is that offer one and offer two both have decimal…values, and I don't know how to mail 0.18 of a coupon.…So what I want to do is require Solver to use integers only.…To do that, I'll open up the Solver dialog box by clicking the Data tab, and…then clicking Solver, there's the Solver Parameters dialog…box with the constraints that I put in.…
And now I need to add another constraint that requires cells…
- Explain how to create a scenario in Excel.
- Identify the two input values that should be used to create a two variable data table.
- Recall what the Excel feature Goal Seek is used for.
- Recognize the three things that must be separated from one another to make reading a worksheet with multiple units easier.
- Describe the tools that Excel provides to manipulate data.
- Break down the steps required to recalculate a worksheet's formulas.
Skill Level Intermediate
1. Defining Scenarios and Data Tables
2. Creating Goal Seek and Solver Models
3. Creating a Configurable Model
4. Performing Monte Carlo Simulation
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.