# week05 - WELCOME EF 105 Spring 2006 Topics 1.Reinforcing...

This preview shows pages 1–8. Sign up to view the full content.

WELCOME WELCOME EF 105                Spring 2006

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
1.Reinforcing the Use of SOLVER 2. Integration with Excel 3. Differentiation with Excel 4. Macros Topics
Microsoft Microsoft  Excel - Solver Excel - Solver  Linear equations: 2 x  + 3 y  = 4 3 x  - 5 y  = 6 Type data in Excel: A B C 1 X Y 2 2x+3y=4 =2*B1+3*C1 3 3x-5y=6 =3*B1-5*C1 x y 2x+3y=4 #VALUE! 3x-5y=6 #VALUE! Active Spreadsheet Active Spreadsheet

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Solver Solver. From Tools   menu, select Solver .  (Add as  needed). Select “ target cell ” as B2. Select “ Value of  ” and enter “4” in box. In the “ By Changing Cells  ” box, type B1,C1.  (The  cells where you typed “x”, “y”.). Click “ Add  ” under “ Subject to Constraints  Now  click the cell with the formula for the L.H.S. of the  2nd. equation.  Select “ = ”.  In last box, enter “6”. Click  OK  – to return to Solver  menu. Click  Solve. Answers for   “x”, “y” will appear in cells B1,C1.
Linear programming Linear programming Maximize Maximize 6 6 x x – 3 – 3 y y 2 2 x x + 3 + 3 y y <= 48 <= 48 7 7 x x + 3 + 3 y y <= 21 <= 21 x x >= 0, >= 0, y y >= 0 >= 0 Type in Excel: Type in Excel: A B C 1 x y 2 6x-3y =6*B1-3*C1 3 2x+3y<=48 =2*B1+3*C1 4 7x+3y<=21 =7*B1+3*C1 5 x>=0 =B1 6 y>=0 =C1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Active Active Spreadsheet Spreadsheet x y 6x-3y #VALUE! 2x+3y<=48 #VALUE! 7x+3y<=21 #VALUE! x>=0 x y>=0 y Now, simply run solver as before, suitably Now, simply run solver as before, suitably modified: modified:
Solver Solver. From From Tools Tools menu, select menu, select Solver Solver . (Add as . (Add as needed). needed). Select “ Select “ target cell target cell ” as B2. ” as B2. Select “

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 07/13/2008 for the course EF 105 taught by Professor Jackson during the Spring '05 term at University of Tennessee.

### Page1 / 35

week05 - WELCOME EF 105 Spring 2006 Topics 1.Reinforcing...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online