Optimization modeling with spreadsheets

"Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and...

Full description

Saved in:
Bibliographic Details
Main Authors: Baker, Kenneth R., 1943
Published:
Literature type: Electronic eBook
Language: English
Edition: 2nd ed.
Subjects:
Online Access: http://onlinelibrary.wiley.com/book/10.1002/9780470949108
Summary: "Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Second Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets to represent and analyze those models. Developed and extensively classroom-tested by the author, the book features a systematic approach that equips readers with the skills to apply optimization tools effectively without the need to rely on specialized algorithms. This new edition uses the powerful software package Ris
Carrier Form: 1 online resource (xiv, 415 pages) : illustrations, maps
Bibliography: Includes bibliographical references and index.
ISBN: 9780470949092
0470949090
9780470949108
0470949104
Index Number: HB143
CLC: TP317.3
Contents: 1. Introduction to Spreadsheet Models for Optimization -- 2. Linear Programming: Allocation, Covering, and Blending Models -- 3. Linear Programming: Network Models -- 4. Sensitivity Analysis in Linear Programs -- 5. Linear Programming: Data Envelopment Analysis -- 6. Integer Programming: Binary Choice Models -- 7. Integer Programming: Logical Constraints -- 8. Nonlinear Programming -- 9. Heuristic Solutions with the Evolutionary Solver -- Appendices: 1. Optimization Software and Supplemental Files -- 2. Graphical Methods in Linear Programming -- 3. The Simplex Method -- 4. Stochastic Program