1 / 18

IV paskaita. Kriteriju jungimas. Tiesiniu lygciu sistemos ...

Mia_John
Télécharger la présentation

IV paskaita. Kriteriju jungimas. Tiesiniu lygciu sistemos ...

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. IV paskaita. Kriteriju jungimas. Tiesiniu lygciu sistemos. Excel naudojimas. Sprestuvas (Solver)

    3. Bendro kriterijaus gavimas (1)

    4. Adityvusis kriterijus (2)

    5. W = a 1w1+a2w2+a3w3++anwn .

    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 cellcalled the target cellon 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 specifycalled the adjustable cellsto 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 cellsfor 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.com/solver.htm Solving a Linear Program Using the Excel Solver . http://www-math.cudenver.edu/~billups/courses/ma3300/excel/Excel-solver.html LINEAR OPTIMIZATION PROBLEMS USING EXCEL SOLVER. [su pavyzdiais] http://faculty.babson.edu/aieta/exclcmpn/AppndxB/appndixb.htm#Appendix B

    12. Tiesiniu lygciu sistemos bendras pavidalas

    13. Tiesiniu lygciu sistemos pavyzdys

    14. Parinkti b, kad lygciu sistema turetu sprendini. Pradioje imti b=3

    16. Parinkti b, kad lygciu sistema turetu sprendini. Pradioje imti b=3

    17. Namu darbas Isisavinti lygciu sistemu sprendima naudojantis Excel sprestuvu.

    18. Lygciu sistemu pavyzdiai

More Related