VBA for Modelers: Developing Decision Support Systems Using Microsoft Excel

This handbook helps students learn to use Visual Basic for Applications (VBA - a programming environment within Microsoft Office) as a means to automate methods and models and create special applications. With VBA, sophisticated management science techniques work behind a simple and nice interface. Gaining valuable experience, students will develop applications that are user friendly and tailored to a specific problem while the number crunching takes place behind the scenes of Microsoft Excel. This book is for professional models or to complement a course in Management Science, or Operations Research thta includes survey of optimization, decision analysis, simulation, and other mathematical methods applied to business.