Amazon cover image
Image from Amazon.com

Optimization modeling with spreadsheets / Kenneth R. Baker.

By: Publication details: New Jersey John Wiley & sons 2016Edition: 3rd EditionDescription: xiii, 374 pages ; 25 cmISBN:
  • 9781118937693 (hardback)
Subject(s): Additional physical formats: Online version:: Optimization modeling with spreadsheetsDDC classification:
  • 005.54 23
LOC classification:
  • HB143.7.B35 2016
Other classification:
  • BUS042000 | BUS101000 | TEC009060
Summary: "Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Third Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets for analysis. Developed and extensively classroom-tested, the book features a systematic approach that equips readers with the skills needed to apply optimization tools effectively without the need to rely on specialized algorithms. This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, with an emphasis on model building using Excel's freely available Solver. The focus on model building (rather than algorithms) is one feature that makes this book distinctive as most books devote more space to algorithmic details than to formulation principles. These days, however, it is not necessary to know a great deal about algorithms in order to apply optimization tools, especially when relying on the spreadsheet as a solution platform. This emphasis on spreadsheets is another feature that makes this book distinctive. Few books devoted to optimization pay much attention to spreadsheet implementation of optimization principles, and most books that emphasize model building ignore spreadsheets entirely. To address the capabilities of sensitivity analysis, the use of Excel's Sensitivity Toolkit is employed. In addition, the book's past use of the Risk Solver Platform for Education (RSPE) is not completely abandoned as the author does include instructions on the use of RSPE for solving optimization problems within an appendix"--Summary: "This book focuses on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets for analysis. Developed and extensively classroom-tested, the book features a systematic approach that equips readers with the skills needed to apply optimization tools effectively without the need to rely on specialized algorithms. This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, with an emphasis on model building using Excel's freely available Solver"--
Reviews from LibraryThing.com:
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Call number Status Date due Barcode Item holds
BOOK BOOK General Collection Open Shelf HB143.7.B35 2016 Available 84516
BOOK BOOK Strathmore University (Main Library) Open Shelf HB143.7.B35 2016 Available 83737
BOOK BOOK General Collection Open Shelf HB143.7.B35 2016 Available 83733
BOOK BOOK Strathmore University (Main Library) Open Shelf HB143.7.B35 2016 Available 83617
BOOK BOOK Strathmore University (Main Library) Open Shelf HB143.7.B35 2016 Available 84601
Total holds: 0

Revised edition of the author's Optimization modeling with spreadsheets, 2011.

Includes bibliographical references and index.

"Thoroughly updated to reflect the latest topical and technical advances in the field, Optimization Modeling with Spreadsheets, Third Edition continues to focus on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets for analysis. Developed and extensively classroom-tested, the book features a systematic approach that equips readers with the skills needed to apply optimization tools effectively without the need to rely on specialized algorithms. This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, with an emphasis on model building using Excel's freely available Solver. The focus on model building (rather than algorithms) is one feature that makes this book distinctive as most books devote more space to algorithmic details than to formulation principles. These days, however, it is not necessary to know a great deal about algorithms in order to apply optimization tools, especially when relying on the spreadsheet as a solution platform. This emphasis on spreadsheets is another feature that makes this book distinctive. Few books devoted to optimization pay much attention to spreadsheet implementation of optimization principles, and most books that emphasize model building ignore spreadsheets entirely. To address the capabilities of sensitivity analysis, the use of Excel's Sensitivity Toolkit is employed. In addition, the book's past use of the Risk Solver Platform for Education (RSPE) is not completely abandoned as the author does include instructions on the use of RSPE for solving optimization problems within an appendix"--

"This book focuses on solving real-world optimization problems through the creation of mathematical models and the use of spreadsheets for analysis. Developed and extensively classroom-tested, the book features a systematic approach that equips readers with the skills needed to apply optimization tools effectively without the need to rely on specialized algorithms. This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming, and heuristic programming, with an emphasis on model building using Excel's freely available Solver"--

There are no comments on this title.

to post a comment.

© Strathmore University Library
Madaraka Estate, Ole Sangale Road | P. O. Box 59857 - 00200 City Square, Nairobi, Kenya
(+254) (0)703 034 000/200/300 | (+254) (0)20-607498