01176nam 2200337Ia 450 99639753530331620221103135230.0(CKB)4940000000055984(EEBO)2240892750(OCoLC)11998200(EXLCZ)99494000000005598419850504d1682 uy |engurbn||||a|bb|Considerations of present use, concerning the danger resulting from the change of our church-government[electronic resource]London Printed by T.M. for Fin. Gardiner ...1682[2], 20 pAttributed to Henry Hammond. Cf. Halkett & Laing (2nd ed.).Reproduction of original in Huntington Library.eebo-0113Church and stateChurch of EnglandChurch and stateChurch of England.Hammond Henry1605-1660.322258EAAEAAm/cWaOLNBOOK996397535303316Considerations of present use concerning the danger resulting from the change of our church government2320571UNISA05709nam 2200781 a 450 991101973910332120170816123708.0978661367804197811180089731118008979978128076727212807672789780470949108047094910497804709490920470949090(CKB)2670000000080895(EBL)675064(SSID)ssj0000477785(PQKBManifestationID)12157984(PQKBTitleCode)TC0000477785(PQKBWorkID)10513078(PQKB)10358473(MiAaPQ)EBC675064(OCoLC)711779385(CaSebORM)9780470928639(OCoLC)806221029(OCoLC)ocn806221029 (EXLCZ)99267000000008089520100907d2011 uy 0engur|n|---|||||txtccrOptimization modeling with spreadsheets /Kenneth R. Baker2nd ed.Hoboken, N.J. Wiley20111 online resource (431 p.)Description based upon print version of record.9780470928639 0470928638 Includes bibliographical references and index.CONTENTS; Preface; 1. Introduction to Spreadsheet Models for Optimization; 1.1 Elements of a Model; 1.2 Spreadsheet Models; 1.3 A Hierarchy for Analysis; 1.4 Optimization Software; 1.5 Using Solver; Summary; Exercises; References; 2. Linear Programming: Allocation, Covering, and Blending Models; 2.1 Linear Models; 2.1.1 Linear Constraints; 2.1.2 Formulation; 2.1.3 Layout; 2.1.4 Results; 2.2 Allocation Models; 2.2.1 The Product Mix Problem; 2.3 Covering Models; 2.3.1 The Staff-Scheduling Problem; 2.4 Blending Models; 2.5 Modeling Errors in Linear Programming; 2.5.1 Exceptions; 2.5.2 Debugging2.5.3 LogicSummary; Exercises; Case: JetGreen; 3. Linear Programming: Network Models; 3.1 The Transportation Model; 3.2 The Assignment Model; 3.3 The Transshipment Model; 3.4 Features of Special Network Models; 3.5 Building Network Models with Balance Equations; 3.6 General Network Models with Yields; 3.6.1 Models with Yield Losses; 3.6.2 Models with Yield Gains; 3.7 General Network Models with Transformed Flows; Summary; Exercises; Case: Casey's Famous Roast Beef; Case: Hollingsworth Paper Company; Production and Distribution Facilities; Patterns of Distribution; Expansion Proposals4. Sensitivity Analysis in Linear Programs4.1 Parameter Analysis in the Transportation Example; 4.2 Parameter Analysis in the Allocation Example; 4.3 The Sensitivity Report and the Transportation Example; 4.4 The Sensitivity Report and the Allocation Example; 4.5 Degeneracy and Alternative Optima; 4.6 Patterns in Linear Programming Solutions; 4.6.1 The Transportation Model; 4.6.2 The Product Portfolio Model; 4.6.3 The Investment Model; 4.6.4 The Allocation Model; 4.6.5 The Refinery Model; Summary; Exercises; Case: Cox Cable and Wire Company; Background; The Contract; The Analysis5. Linear Programming: Data Envelopment Analysis5.1 A Graphical Perspective on DEA; 5.2 An Algebraic Perspective on DEA; 5.3 A Spreadsheet Model for DEA; 5.4 Indexing; 5.5 Finding Reference Sets and HCUs; 5.6 Assumptions and Limitations of DEA; Summary; Exercises; Case: Branch Performance at Nashville National Bank; Branch Growth at Nashville National Bank; Assessing Branch Productivity; Branch Managers Revolt; Measuring Branches: Available Techniques; The DEA Study; 6. Integer Programming: Binary Choice Models; 6.1 Using Solver with Integer Requirements; 6.2 The Capital Budgeting Problem6.3 Set Covering6.4 Set Packing; 6.5 Set Partitioning; 6.6 Playoff Scheduling; 6.7 Solving a Large-Scale Set Partitioning Problem; 6.8 The Algorithm for Solving Integer Programs; Summary; Exercises; Case: Motel Location for Nature's Inn; 7. Integer Programming: Logical Constraints; 7.1 Simple Logical Constraints: Exclusivity and Contingency; 7.2 Linking Constraints: The Fixed Cost Problem; 7.3 Linking Constraints: The Threshold Level Problem; 7.4 Linking Constraints: The Facility Location Model; 7.4.1 Capacitated Version; 7.4.2 Uncapacitated Version7.5 Disjunctive Constraints: The Machine Sequencing ProblemReflects the latest applied research and features state-of-the-art software for building and solving spreadsheet optimization models 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 skilMathematical optimizationManagerial economicsMathematical modelsElectronic spreadsheetsProgramming (Mathematics)Mathematical optimization.Managerial economicsMathematical models.Electronic spreadsheets.Programming (Mathematics)005.54519.6028554Baker Kenneth R.1943-513780MiAaPQMiAaPQMiAaPQBOOK9911019739103321Optimization modeling with spreadsheets853508UNINA