Amazon cover image
Image from Amazon.com

Optimization modeling with spreadsheets / Kenneth R. Baker.

By: Material type: TextTextPublication details: Hoboken, N.J. : Wiley, ©2011.Edition: 2nd edDescription: 1 online resource (xiv, 415 pages) : illustrations, mapsContent type:
  • text
Media type:
  • computer
Carrier type:
  • online resource
ISBN:
  • 9780470949092
  • 0470949090
  • 9780470949108
  • 0470949104
Subject(s): Genre/Form: Additional physical formats: Print version:: Optimization modeling with spreadsheets.DDC classification:
  • 005.54 519.6028554
LOC classification:
  • HB143.7 .B35 2011eb
Other classification:
  • 85.03
Online resources:
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 Programming.
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 Risk Solver Platform (RSP) for optimization, including its Evolutionary Solver, which employs many recently developed ideas for heuristic programming. The author provides expanded coverage of integer programming and discusses linear and nonlinear programming using a systematic approach that emphasizes the use of spreadsheet-based optimization tools"--Provided by publisher.
List(s) this item appears in: Sofware Engineering & Computer Science
Tags from this library: No tags from this library for this title. Log in to add tags.
No physical items for this record

Includes bibliographical references and index.

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

"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 Risk Solver Platform (RSP) for optimization, including its Evolutionary Solver, which employs many recently developed ideas for heuristic programming. The author provides expanded coverage of integer programming and discusses linear and nonlinear programming using a systematic approach that emphasizes the use of spreadsheet-based optimization tools"--Provided by publisher.

Print version record.

Computer Science and Engineering