Developing Spreadsheet-Based Decision Support Systems
Developing Spreadsheet-Based Decision Support Systems
by Sandra D. Ekşioğlu, Michelle M.H. Şeref, Ravindra K. Ahuja, and Wayne L. Winston
A decision support system (DSS) is an intelligent information system that uses data, models it, processes or analyzes it using problem-specific methodologies, and assists the user in the decision-making process through a graphical user interface (GUI). Developing Spreadsheet-Based Decision Support Systems, 2nd Edition, is a comprehensive book that describes how to build decision support systems using the Excel spreadsheet framework. Risk Solver Platform for Education, an Excel VBA Add-In, is used for optimization and simulation. This book illustrates complete decision support development applications through several case studies arising in operations research, industrial engineering, management, and business administration.
The ability to extract data from external sources and embed analytical decision models within larger systems are two of the most valuable skills required for entering today’s information technology dominated workplace. Such decision support systems (DSSs) may be developed in various environments that support data storage, data analysis, solution method development, and graphical user interface. Microsoft Excel spreadsheet software provides all of the necessary components to build a DSS. It enables the data to be stored in a spreadsheet, optimization and simulations models to be built, and data to be manipulated using the programming language VBA for Excel, and it provides tools to build graphical user interfaces. Microsoft Excel Add-Ins, such as, Risk Solver Platform for Education, are accessory software that extend the capabilities of existing Excel applications to perform optimization, simulation, risk analyses, etc. Microsoft Excel is the most popular software engineers and managers use in their workplace. Thus, Excel offers an excellent environment to build a DSS, and our students can very easily acquire these skills. This book describes all the necessary techniques to build such systems.
The book is designed to meet the needs of undergraduate as well graduate students for courses in business school or operations research or industrial engineering departments. The book can be used as a textbook for full courses, or it can be used as a reference book to supplement the current material in existing courses. The book is also written in a style so that managers, engineers, and practitioners can use it for self-study. The book is self-complete and does not require any previous background. The 25 case studies developed give the instructors a wonderful selection to cover in the class depending upon the audience. The case studies not only illustrate the applications of models to real-life applications but also illustrate methodologies not often covered in courses, such as neighborhood search and genetic algorithms.
- A unified approach that describes all technologies necessary to build a complete spreadsheet-based decision support system. The book covers the material found in several books in one book and makes it highly accessible for students with little previous background.
- This is the first book that covers Excel functionalities, VBA for Excel, and a variety of case studies arising in industrial engineering, operations research, operations management, and business administration in a single book.
- All important topics are explained using easy-to-follow and interesting hands-on tutorials. The focus is on learning by doing. Numerous hands-on exercises further supplement the learning experience.
- This book can be used as a textbook for teaching courses at the undergraduate as well as graduate levels in industrial engineering, operations research, and business departments. The book can also be used as a self-study guide by practitioners wanting to learn more about operations research and/or information technology.
- The book can also be used to supplement existing courses such as spreadsheet-based modeling courses. The book material is organized in a modular fashion so that instructors can pick and choose certain modules to supplement other courses they teach.
The book is composed of the three following parts:
- Part 1: Excel Essentials
- Part 2: VBA for Excel
- Part 3: Case Studies
What's new in the second edition?
Part I - This book features Excel 2010. In Chapter 2 we give an overview of the Ribbon, Quick Access Toolbar and File Menu tab which is a new addition to Excel's interface. In this Chapter we also discuss the new conditional formatting features of Excel. In Chapter 3 we discuss the new and improved charting interface of Excel and introduce Sparklines. In Chapter 4 we discuss some of the improvements made on Excel's function library. In Chapter 6 we present some of the improved capabilities for working with pivot tables and introduce Slicers. In Chapters 8 and 9 we use Risk Solver Platform for Education to model and solve optimization and simulation problems. In Chapter 10 we present the new Official Excel Table tools and discuss its capabilities to organize and manipulate data.
Part II - In Chapters 19 and 20 we discuss how to use Object Oriented API with Risk Solver Platform to modify and solve optimization and simulation models using VBA commands. For instructions on how to access Risk Solver Platform for Education, please visit this page www.solver.com/professor-and-student-users.htm.
Part III - A number of the case studies (such as, Birthday Simulation, Portfolio Management and Optimization, Single and Multi-Server Queuing Simulation, etc.), are updated to use Risk Solver Platform for optimization and simulation. The use of Risk Solver Platform has especially improved the coding efficiency and performance of these case studies.
Case Studies: An additional 15 case studies based on different application settings such as supply-chain management, project management, financial management, and sports.
Case Files: Excel files for all the case studies described in the book or the website.
Chapter Examples: Both the finished and unfinished Excel files for all the hands-on examples in the book.
Chapter Exercises: Excel files for exercises in all chapters. Solutions available only to the instructors.
Chapter PowerPoints: PowerPoint presentations for all the book chapters.
Projects Manual: A compilation of 75 student (team) projects describing additional applications of spreadsheet-based decision support systems.
All material is available at www.dssbooks.com/excel2.
Tips for instructors and sample course schedules offered to qualified instructors. Upon request, a solution manual will be provided on a CD to instructors offering courses using this book as the principal textbook. Please fill out the form in the "For Instructors" section under Resources.