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

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

View Full Document Right Arrow Icon
    WELCOME WELCOME EF 105                Spring 2006
Background image of page 1

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

View Full DocumentRight Arrow Icon
    1.Reinforcing the Use of SOLVER 2. Integration with Excel 3. Differentiation with Excel 4. Macros Topics
Background image of page 2
    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
Background image of page 3

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

View Full DocumentRight Arrow Icon
    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.
Background image of page 4
    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
Background image of page 5

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

View Full DocumentRight Arrow Icon
    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:
Background image of page 6
    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 “
Background image of page 7

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

View Full DocumentRight Arrow Icon
Image of page 8
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 Right Arrow Icon
Ask a homework question - tutors are online