VBA for modelers: developing decision support systems using Microsoft Excel
Author: Albright, S. Christian Publisher: Duxbury Press, 2007.Language: EnglishDescription: 681 p. : Graphs/Ill. ; 26 cm. includes CD-ROM / DVDISBN: 0495106836Type of document: BookBibliography/Index: Includes indexContents Note: CD available inside back cover
| Item type | Current location | Collection | Call number | Status | Notes | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|---|
|
Europe Campus Main Collection |
T58.62 .A53 2007
(Browse shelf) 001279627 |
Available | CD available inside back cover | 001279627 |
Includes index
CD available inside back cover
Digitized
VBA for Modelers Developing Decision Support Systems with Microsoft® Excel Brief Contents PART I VBA Fundamentals 1. Introduction to VBA Development in Excel 2. The Excel Object Model 3. The Visual Basic Editor 4. Recording Macros 5. Getting Started with VBA 6. Working with Ranges 7. Control Logic and Loops 8. Working with Other Excel Objects 9. Arrays 10. More on Variables and Subroutines 11. User Forms 12. Error Handling 13. Working with Files and Folders 14. Importing Data into Excel from a Database 15. Working with Pivot Tables 16. Working with Menus and Toolbars 17. Automating Solver and Other Add-Ins 1 3 8 16 31 46 81 101 130 150 176 202 236 243 264 287 306 326 Part II VBA Management Science Applications 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. Basic Ideas for Application Development with VBA A Blending Application A Product Mix Application An Employee-Scheduling Application A Production-Planning Application A Logistics Application A Stock-Trading Simulation Application A Capital-Budgeting Application A Regression Application An Exponential Utility Application A Queueing Simulation Application An Option-Pricing Application An Application for Finding Betas of Stocks A Portfolio Optimization Application A Data Envelopment Analysis Application An AHP Application for Choosing a Job A Poker Simulation Application 347 349 374 391 411 423 451 471 484 498 512 525 544 567 586 611 631 657
There are no comments for this item.