About this product

Product Identifiers

PublisherBrooks/Cole

ISBN-100534380123

ISBN-139780534380120

eBay Product ID (ePID)1850260

Product Key Features

Number of Pages576 Pages

Publication NameVba for Modelers : Developing Decision Support Systems Using Microsoft Excel

LanguageEnglish

Publication Year2000

SubjectProgramming Languages / Visual Basic, Management Information Systems, Desktop Applications / Spreadsheets, Statistics

TypeTextbook

Subject AreaComputers, Business & Economics

AuthorS. Christian Albright

FormatTrade Paperback

Dimensions

Item Weight33.7 Oz

Item Length9.4 in

Item Width7.5 in

Additional Product Features

Intended AudienceCollege Audience

LCCN00-064357

Dewey Edition21

IllustratedYes

Dewey Decimal658.4/03/02855369

Table Of ContentPART 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.

SynopsisThis 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., 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.

LC Classification NumberT58.62.A43 2001