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...
Saved in:
Main Authors: | |
---|---|
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 |