VBA for Modelers
Developing Decision Support Systems Using Microsoft Excel
704 pages, parution le 15/01/2006
(2eme édition)
Résumé
This book 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 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® Excel®.
Benefits:
- Four new chapters (Chapters 13 through 16) have been added. Chapter 13 discusses the manipulation of files and folders with some useful and efficient techniques. Chapter 14 covers the use of ADO (ActiveX Data Objects) to import data from relational databases into Excel, along with an introduction to SQL (Structured Query Language). Chapter 15 discusses automating pivot tables with VBA. Chapter 16 discusses the manipulation of Excel's menus and toolbars, both with Excel's user interface and with VBA.
- The previous edition's Chapter 11 has been moved to Chapter 17 in the new edition. In addition to covering programming with Solver, it now includes a brief section on programming with other add-ins such as Palisade's @RISK.
- Motivated by the idea that all programmers make errors, the chapter on Debugging has been moved to the front of the text. Students now have the opportunity to learn important debugging techniques earlier in the text.
- The application in Chapter 19 has been changed from a general minimum cost network flow model to a more specific transportation model. It now allows users to choose the suppliers and retailers to include in the model, while still employing ADO to import data from an Access® database.
- Improvements have been made throughout the text in the readability and consistency of the code. For instance, the text consistently uses a popular variable naming convention known as Camel Case, in which compound words and phrases are connected without spaces, and the first letter of each word after the first is capitalized, as in unitCost.
- There are dozens of new exercises in the first part of the book, not counting those in the new chapters.
- Illustrates the power of Visual Basic for Applications (VBA) when coupled with management science models.
- Allows students to go beyond simple calculations by using easy-to-use, sophisticated VBA programs.
- Serves as an ideal companion book to any text in Quantitative Methods, Management Science, or Operations Research. It can also be used as a stand-alone text.
Sommaire
- Introduction to VBA Development In Excel
- The Excel Object Model
- The Visual Basic Editor
- Recording Macros
- Getting Started With VBA
- Working with Ranges
- Control Logic and Loops
- Working with Other Excel Objects
- Arrays
- More on Variables and Subroutines
- User Forms
- Error Handling
- Working with Files And Folders
- Importing Data into Excel from a Database
- Working with Pivot Tables
- Working with Menus and Toolbars
- Automating Solver and Other Add-Ins
- 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
Voir tout
Replier
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Thomson - Brooks/Cole |
| Auteur(s) | S. Christian Albright |
| Parution | 15/01/2006 |
| Édition | 2eme édition |
| Nb. de pages | 704 |
| Format | 19 x 23,5 |
| Couverture | Broché |
| Poids | 1040g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780495106852 |
| ISBN13 | 978-0-495-10685-2 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
