×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

VBA for Modelers: Developing Decision Support Systems Using Microsoft Excel / Edition 1
     

VBA for Modelers: Developing Decision Support Systems Using Microsoft Excel / Edition 1

by S. Christian Albright
 

ISBN-10: 0534380123

ISBN-13: 9780534380120

Pub. Date: 12/28/2000

Publisher: Cengage Learning

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

Overview

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.

Product Details

ISBN-13:
9780534380120
Publisher:
Cengage Learning
Publication date:
12/28/2000
Edition description:
Older Edition
Pages:
576
Product dimensions:
7.42(w) x 9.20(h) x 1.20(d)

Table of Contents

PART I: VBA FUNDAMENTALS. 1. Introduction to VBA Development in Excel. 2. The Excel Object Model. 3. The Visual Basic Editor. 4. Getting Started with VBA. 5. Recording Macros. 6. Working with Ranges. 7. Control Logic and Loops. 8. Working with Other Excel Objects. 9. Arrays. 10. More on Variables and Subroutines. 11. Working with the Solver Add-In in VBA. 12. User Forms. 13. Debugging and Error Handling. PART II: VBA APPLICATIONS FOR MANAGEMENT SCIENCE. 14. Basic Ideas for Application Development with VBA. 15. A Blending Application. 16. A Product Mix Application. 17. An Employee Scheduling Application. 18. A Production Scheduling Application. 19. A Minimum-Cost Network Flow Application. 20. A Stock Trading Simulation. 21. A Capital Budgeting Application. 22. An Application for Estimating the Relationship Between Two Variables. 23. An Exponential Utility Application. 24. Simulation of a Multiserver Queue. 25. An Application for Pricing European and American Options. 26. An Application for Finding Betas of Stocks. 27. A Portfolio Optimization Application. 28. A Data Envelopment Analysis Application. 29. An AHP Application for Choosing a Job. 30. A Poker Simulation. Index.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews