IV paskaita' Tiesiniu lygciu sistemos' Excel naudojimas

1
IV paskaita. Tiesiniu lygciu sistemos. Excel
naudojimas
2
Tiesiniu lygciu sistemos. Excel Sprestuvas

• Tiesiniu lygciu sistemos
• Excel naudojimas
• Excel Sprestuvas
• Lygciu sistemu sprendimas su Sprestuvu
• Pavyzdiai

3
Programos Excel naudojimas

• Formuliu skaiciavimas
• Funkcijos
• Diagramos
• Priedai (Add-Inns) duomenu analize, sprestuvas
  (Solver)

4
Sprestuvas (Solver)

• Solver Add-In Calculates solutions to what-if
  scenarios based on adjustable cells and
  constraint cells.
• Placiau www.solver.com

5
Sprestuvo (Solver) naudojimas

• Instaliavimas (Tools - Add-Inns- Solver)
• About Solver (Excel Help)
• Solver is part of a suite of commands sometimes
  called what-if analysis tools. With Solver, you
  can find an optimal value for a formula in one
  cell called the target cell on a worksheet.
  Solver works with a group of cells that are
  related, either directly or indirectly, to the
  formula in the target cell. Solver adjusts the
  values in the changing cells you specify called
  the adjustable cells to produce the result you
  specify from the target cell formula. You can
  apply constraints to restrict the values Solver
  can use in the model, and the constraints can
  refer to other cells that affect the target cell
  formula.
• Use Solver to determine the maximum or minimum
  value of one cell by changing other cells for
  example, you can change the amount of your
  projected advertising budget and see the affect
  on your projected profit amount.

6
Apie Excel sprestuva skaitykite

• The Solver Add-in for Excel . http//www.add-ins.c
  om/solver.htm
• Solving a Linear Program Using the Excel Solver .
  http//www-math.cudenver.edu/billups/courses/ma33
  00/excel/Excel-solver.html
• LINEAR OPTIMIZATION PROBLEMS USING EXCEL SOLVER.
  su pavyzdiais http//faculty.babson.edu/aieta/e
  xclcmpn/AppndxB/appndixb.htmAppendix B

7
Tiesiniu lygciu sistemos bendras pavidalas
a11x1a12x2a13x3a1nxnb1 a21x1a22x2a23x3a
2nxnb2 am1x1am2x2am3x3amnxnbm m
lygciu skaicius, n kintamuju skaicius.
8
Tiesiniu lygciu sistemos pavyzdys
x-y5z-6 3x3y-z10 x3y2z5
9

• Parinkti b, kad lygciu sistema turetu sprendini.
  Pradioje imti b3

10

• Parinkti b, kad lygciu sistema turetu sprendini.
  Pradioje imti b3

11

• Parinkti b, kad lygciu sistema turetu sprendini.
  Pradioje imti b3

12
Namu darbas

• Isisavinti lygciu sistemu sprendima naudojantis
  Excel sprestuvu.

13
Lygciu sistemu pavyzdiai

• Parinkti b, kad lygciu sistema turetu sprendini.
  Pradioje imti b3