Developing spreadsheet-based decision support systems : Using excel and VBA for excel [printed text] / Michelle M.H. Seref, Author ; Ravindra K. Ahuja, Author ; Wayne L. Winston, Author . - [S.l.] : Dynamic Ideas, 2007 . - xviii, 892 p. : ill (col) ; 26 cm.
ISBN : 978-0-9759146-5-6

Keywords:	Spreadsheets,  Excel,  VBA,  Decision  Support  Systems
Class number:	005.329
Abstract:	Developing Spreadsheet-Based Support Systems is a comprehensive book which describes how to build decision support systems using the Excel spreadsheet framework, and illustrates it using several case studies arising in Operations Research, Industrial Engineering, and Business. The book contains three parts: Part I Excel Essentials. Part II VBA for Excel and Part 3 Case Studies. Each topic covered is illustrated through examples and hands-on tutorials. Each chapter contains numerous hands-on exercises for additional practice. This book is ideally suited as a textbook, can be used as a supplementary reference book, and can also be used as a self-study manual.
Contents note:	Preface Part I Excel Essentials Chapter 1 Introduction; Chapter 2 Excel Basics and Formatting; Chapter 3 Referencing and Names; Chapter 4 Functionsa and Formulas; Chapter 5 Charts; Chapter 6 Pivot Tables; Chapter 7 Statistical Analysis with Excel; Chapter 8 Using Excel Solver to Solve Mathematical Programs; Chapter 9 Simulation; Chapter 10 Working with Large Data Part II VBA for Excel Chapter 11 Introduction to the Visual Basic Environment; Chapter 12 Recording Macros; Chapter 13 More on Objects; Chapter 14 Variables; Chapter 15 Sub Procedures and Function Procedures; Chapter 16 Programming Structures; Chapter 17 Arrays; Chapter 18 User Interface; Chapter 19 The Solver Revisited; Chapter 20 Simulation Revisited; Chapter 21 Working with Large Data Using VBA Part III Case Studies Chapter 22 The DSS Development Process; Chapter 23 GUI Design; Chapter 24 Programming Principles; Case Study 1 Birthday Simulation; Case Study 2 Eight Queens; Case Study 3 Inventory Management; Case Study 4 Warehouse Layout; Case Study 5 Forecasting Methods; Case Study 6 Facility Layout; Case Study 7 Portfolio Management and Optimization; Case Study 8 Reliability Analysis; Case Study 9 Retirement Planning; Case Study 10 Queuing Simulation: Single Server and Multi Server; Appendix A Excel Add-Ins; Appendix B Debugging and Error Checking; Appendix C Advanced Programming Topics References; About the Authors; Index.