|
|
|
In stock, usually dispatched within 24 hours
|
- Product code: 15556
- ISBN: 0534380123,
ISBN13: 9780534380120,
250 pages, CD-Rom + pb
Published by Duxbury Press, 2001
Rate this book...
Rating: 0.0/5 (0 votes cast)
|
|
|
|
|
Description of VBA for Modelers |
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.
|
Contents of VBA for Modelers |
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
|
About S. Christian Albright |
Chris Albright received his B.S. degree in Mathematics from Stanford in 1968 and his Ph.D. in Operations Research from Stanford in 1972. Since then, he has been teaching in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University. He has taught courses in management science, computer simulation, and statistics to all levels of business students: undergraduates, MBAs, and doctoral students.
He has published over 20 articles in leading operations research journals in the area of applied probability, and he has authored other successful Duxbury titles including PRACTICAL MANAGEMENT SCIENCE, Second Edition, VBA FOR MODELERS, and DATA ANALYSIS AND DECISION MAKING, Second Edition. His current interest is in spreadsheet modeling, including development of VBA applications in Excel.
|
Bulk buying
| If you need bulk copies of VBA for Modelers, or are interested in opening a corporate account, please contact us. |
|
|
Shopping basket