This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 5 Pick one of the Solver cells (I picked the first one) as the "Target Cell" in the Solver feature of Excel: a. Highlight the first Solver cell b. c. Set the value of this cell equal to the value of the RHS for that particular equation (zero). d. Set "By Changing Cells" to the cell indices of variables a, b, and c. e. Set the constraints such that the other two Solver cells must equal their respective RHS: i) ii) The Solver window for this example should look like the image below. f. 6 If all goes well, the Solver cells should equal the RHS cells respectively, and the values of a, b, and c will automatically adjust to their final iterated correct values. Tools-Add-Ins-Solver Add-in-OK Tools-Solver Click Add , and then construct two equations as the constraints. Solve and then OK ....
View Full Document
- Fall '07