Optimization modeling with spreadsheets
Baker, Kenneth R.
1943-
creator
text
bibliography
Electronic books.
nju
Hoboken, N.J
Wiley
©2011
2011
2nd ed.
monographic
eng
1 online resource (xiv, 415 pages) : illustrations, maps
"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.
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.
Kenneth R. Baker.
Includes bibliographical references and index.
Mathematical optimization
Managerial economics
Mathematical models
Electronic spreadsheets
Programming (Mathematics)
Business
Mathematics
Computer science
Mathematical optimization
Managerial economics
Mathematical models
Electronic spreadsheets
Programming (Mathematics)
COMPUTERS
Desktop Applications
Spreadsheets
Electronic spreadsheets
Managerial economics
Mathematical models
Mathematical optimization
Programming (Mathematics)
Mathematical optimization
Managerial economics / Mathematical models
Electronic spreadsheets
Programming (Mathematics)
HB143.7 .B35 2011eb
005.54 519.6028554
85.03
Optimization modeling with spreadsheets
Baker, Kenneth R., 1943-
Hoboken, N.J. : Wiley, ©2011
2nd ed.
(DLC) 2010036840
(OCoLC)663459290
9780470949092
0470949090
9780470949108
0470949104
10.1002/9780470949108 Wiley InterScience
http://dx.doi.org/10.1002/9780470949108
http://dx.doi.org/10.1002/9780470949108
EBLCP
110418
20220701010833.0
ocn713010153
eng