04415nam 2200625 450 991082114080332120230912174832.01-118-93770-81-118-93773-2(CKB)24989731900041(Au-PeEL)EBL1953319(CaPaEBR)ebr11069588(CaONFJC)MIL802214(OCoLC)905668049(CaSebORM)9781118937693(MiAaPQ)EBC1953319(JP-MeL)3000110479(MiAaPQ)EBC7104253(EXLCZ)992498973190004120150707h20162016 uy 0engur|||||||||||rdacontentrdamediardacarrierOptimization modeling with spreadsheets /Kenneth R. BakerThird edition.Hoboken, New Jersey :Wiley,2016.20161 online resource (391 pages) illustrations, tablesPrevious ed.: c2011Includes bibliographical references and indexOnline version: Baker, Kenneth R., 1943- Optimization modeling with spreadsheets Third Edition. Hoboken : Wiley, 2015 9781118937709 (DLC) 2015011816 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"--Provided by publisher."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"--Provided by publisher.Mathematical optimizationManagerial economicsMathematical modelsElectronic spreadsheetsProgramming (Mathematics)Mathematical optimization.Managerial economicsMathematical models.Electronic spreadsheets.Programming (Mathematics)005.54417njb/09005.54njb/09Baker Kenneth R.1943-513780MiAaPQMiAaPQMiAaPQBOOK9910821140803321Optimization modeling with spreadsheets853508UNINA