IV paskaita' Kriteriju jungimas' Tiesiniu lygciu sistemos' Excel naudojimas' Sprestuvas Solver

1
IV paskaita. Kriteriju jungimas. Tiesiniu lygciu
sistemos. Excel naudojimas. Sprestuvas (Solver)
2
Kriteriju jungimo (agregavimo) problema

• Sudetingu udaviniu sprendime tenka ivertinti
  daugiau nei viena kriteriju.
• Vienas i tokios situacijos nagrinejimo budu
  sujungti kriterijus, sudaryti bendra kriteriju
• Yra keletas kriteriju jungimo budu vienas i
  paprasciausiu sumavimas (adityvusis
  kriterijus). Danai dar ivertinami ir komponentu
  svoriai.
• Paprasciausias - trupmeninis kriterijus

3
Bendro kriterijaus gavimas (1)
4
Adityvusis kriterijus (2)
5

• W a 1w1a2w2a3w3anwn

• .

6
(No Transcript)
7
Tiesiniu lygciu sistemos. Excel Sprestuvas

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

8
Programos Excel naudojimas

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

9
Sprestuvas (Solver)

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

10
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.

11
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

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

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

15

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

16

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

17
Namu darbas

• Isisavinti lygciu sistemu sprendima naudojantis
  Excel sprestuvu.

18
Lygciu sistemu pavyzdiai

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