| Title : | VBA for modelers | | Other title : | Developing decision support systems with Microsoft - excel | | Material Type: | printed text | | Authors: | S. Christian Albright, Author | | Edition statement: | 2nd Edition International | | Publisher: | Belmont, CA : Thomson/Brooks/Cole | | Publication Date: | 2007 | | Pagination: | xxi, 681 p. | | Layout: | ill (b & w) | | Size: | 24 cm | | ISBN (or other code): | 978-0-495-10685-2 | | Class number: | 005.133 | | Abstract: | This book helps students learn to use Visual Basic for Applications (VBA - a programming environment within Microsoft[registered] Office) as a means to automate methods and models and create special applications. With VBA, sophisticated management science techniques work behind a clean and simple 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[registered] Excel[registered]. | | Contents note: | Part 1 VBA Fundamentals: 1. Introduction to VBA Development in Excel; 2. The Escel Objet 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;
Part 2. VBA Management Science Applications: 18. Basic ideas for application development with VBA;
19. A blending application; 20. A product mix application;21. An employee-scheduling application; 22. A production-planning application; 23. A logistics application; 24. A stock-trading simulation application; 25. A capital-budgeting application; 26. A regression application; 27. An exponential utility application; 28. A queueing simulation application; 29. An option-pricing application; 30. An application for finding betas of stocks; 31. A portfolio optimization application; 32. A data envelopment analysis application; 33. An AHP application for choosing a job; 34. A poker simulation application. |
VBA for modelers ; Developing decision support systems with Microsoft - excel [printed text] / S. Christian Albright, Author . - 2nd Edition International . - Belmont, CA : Thomson/Brooks/Cole, 2007 . - xxi, 681 p. : ill (b & w) ; 24 cm. ISBN : 978-0-495-10685-2 | Class number: | 005.133 | | Abstract: | This book helps students learn to use Visual Basic for Applications (VBA - a programming environment within Microsoft[registered] Office) as a means to automate methods and models and create special applications. With VBA, sophisticated management science techniques work behind a clean and simple 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[registered] Excel[registered]. | | Contents note: | Part 1 VBA Fundamentals: 1. Introduction to VBA Development in Excel; 2. The Escel Objet 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;
Part 2. VBA Management Science Applications: 18. Basic ideas for application development with VBA;
19. A blending application; 20. A product mix application;21. An employee-scheduling application; 22. A production-planning application; 23. A logistics application; 24. A stock-trading simulation application; 25. A capital-budgeting application; 26. A regression application; 27. An exponential utility application; 28. A queueing simulation application; 29. An option-pricing application; 30. An application for finding betas of stocks; 31. A portfolio optimization application; 32. A data envelopment analysis application; 33. An AHP application for choosing a job; 34. A poker simulation application. |
|
Home
VBA for modelers
