VBA for Modelers Developing Decision Support Systems Using Microsoft Excel

ISBN-10: 0534380123
ISBN-13: 9780534380120
Edition: 2001
List price: $98.95
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: 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  More...

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Medical Terminology Online content $4.95 $1.99
Add to cart
Study Briefs
Medical Math Online content $4.95 $1.99
Add to cart
Study Briefs
Careers in Medical Assisting Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $98.95
Copyright year: 2001
Publisher: Brooks/Cole
Publication date: 12/12/2000
Binding: Paperback
Pages: 576
Size: 7.25" wide x 9.00" long x 1.25" tall
Weight: 2.2
Language: English

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.

S. Christian 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. His current interest is in spreadsheet modeling, including development of VBA applications in Excel. Dr. Albright has published more than 20 articles in leading operations research journals in the area of applied probability as well as a number of successful textbooks, including DATA ANALYSIS AND DECISION MAKING, DATA ANALYSIS FOR MANAGERS, and SPREADSHEET MODELING AND APPLICATIONS.

VBA Fundamentalsp. 1
Introduction to VBA Development in Excelp. 3
Introductionp. 3
Example Applicationsp. 4
Required Backgroundp. 4
Visual Basic Versus VBAp. 5
Summaryp. 6
The Excel Object Modelp. 7
Introductionp. 7
Objects, Properties, and Methodsp. 7
Collections as Objectsp. 8
The Hierarchy of Objectsp. 9
Object Models in Generalp. 12
Summaryp. 12
The Visual Basic Editorp. 13
Introductionp. 13
Important Features of the VBEp. 13
The Object Browserp. 17
The Immediate and Watch Windowsp. 18
A First Programp. 18
Summaryp. 23
Getting Started with VBAp. 27
Introductionp. 27
Subroutinesp. 27
Understanding and Declaring Variablesp. 28
Input Boxes and Message Boxesp. 31
Commentsp. 35
Stringsp. 35
Specifying Objects, Properties, and Methodsp. 39
The With Constructionp. 41
Other Useful VBA Tipsp. 43
Summaryp. 44
Recording Macrosp. 49
Introductionp. 49
How to Record a Macrop. 49
Recorded Macro Examplesp. 51
Summaryp. 61
Working with Rangesp. 63
Introductionp. 63
Exercisep. 63
Important Properties and Methods of Rangesp. 64
Specifying Ranges with VBAp. 68
Examples of Ranges with VBAp. 70
Summaryp. 78
Control Logic and Loopsp. 81
Introductionp. 81
Exercisep. 81
If Constructionsp. 83
Case Constructionsp. 89
For Loopsp. 91
For Each Loopsp. 96
Do Loopsp. 98
Summaryp. 102
Working with Other Excel Objectsp. 107
Introductionp. 107
Exercisep. 107
Collections and Specific Members of Collectionsp. 109
Examples of Workbooks in VBAp. 110
Examples of Worksheets in VBAp. 113
Examples of Charts in VBAp. 118
Summaryp. 122
Arraysp. 125
Introductionp. 125
Exercisep. 125
The Need for Arraysp. 126
Rules for Working with Arraysp. 128
Examples of Arrays in VBAp. 130
Array Functionsp. 144
Summaryp. 144
More on Variables and Subroutinesp. 147
Introductionp. 147
Exercisep. 147
Scope of Variables and Subroutinesp. 150
Modularizing Programsp. 152
Passing Argumentsp. 155
Function Subroutinesp. 160
The Workbook_Open Subroutinep. 165
Summaryp. 166
Working with the Solver Add-In in VBAp. 171
Introductionp. 171
Exercisep. 171
Invoking the Solver in VBAp. 173
A Solver VBA Bugp. 182
Summaryp. 183
User Formsp. 187
Introductionp. 187
Exercisep. 187
Designing User Formsp. 190
Setting Properties of Controlsp. 194
Creating a User Form Templatep. 197
Writing Event Code for User Formsp. 198
Displaying a User Formp. 206
Looping Through the Controls on a User Formp. 207
Working with List Boxesp. 208
Summaryp. 209
Debugging and Error Handlingp. 213
Introductionp. 213
Exercisep. 213
Debuggingp. 214
Error Handlingp. 220
Summaryp. 223
VBA Applications for Management Sciencep. 227
Basic Ideas for Application Development with VBAp. 229
Introductionp. 229
Guidelines for Application Developmentp. 229
A Car Loan Applicationp. 234
Summaryp. 250
A Blending Applicationp. 253
Introductionp. 253
Functionality of the Applicationp. 253
Running the Applicationp. 254
Setting Up the Excel Sheetsp. 260
Getting Started with the VBAp. 260
Designing the User Forms and Writing Their Event Codep. 262
The VBA Code in the Modulep. 266
Summaryp. 269
A Product Mix Applicationp. 271
Introductionp. 271
Functionality of the Applicationp. 272
Running the Applicationp. 272
Setting Up the Excel Sheetsp. 274
Getting Started with the VBAp. 275
Designing the User Form and Writing Its Event Codep. 276
The VBA Code in the Modulep. 278
Summaryp. 287
An Employee Scheduling Applicationp. 291
Introductionp. 291
Functionality of the Applicationp. 291
Running the Applicationp. 292
Setting Up the Excel Sheetsp. 295
Getting Started with the VBAp. 297
Designing the User Forms and Writing Their Event Codep. 298
The VBA Code in the Modulep. 301
Summaryp. 304
A Production Scheduling Applicationp. 307
Introductionp. 307
Functionality of the Applicationp. 307
Running the Applicationp. 308
Setting Up the Excel Sheetsp. 315
Getting Started with the VBAp. 317
Designing the User Forms and Writing Their Event Codep. 318
The VBA Code in the Modulep. 322
Summaryp. 330
A Minimum-Cost Network Flow Applicationp. 333
Introductionp. 333
Functionality of the Applicationp. 334
Running the Applicationp. 334
Setting Up the Access Databasep. 335
Setting Up the Excel Worksheetsp. 338
Getting Started with the VBAp. 338
A Quick Introduction to ADOp. 340
The VBA Code in the Modulep. 342
Summaryp. 350
A Stock Trading Simulationp. 353
Introductionp. 353
Functionality of the Applicationp. 354
Running the Applicationp. 354
Setting Up the Excel Sheetsp. 357
Getting Started with the VBAp. 359
The VBA Code in the Modulep. 360
Summaryp. 364
A Capital Budgeting Applicationp. 367
Introductionp. 367
Functionality of the Applicationp. 368
Running the Applicationp. 368
Setting Up the Excel Sheetsp. 370
Getting Started with the VBAp. 371
Designing the User Form and Writing Its Event Codep. 372
The VBA Code in the Modulep. 373
Summaryp. 378
An Application for Estimating the Relationship Between Two Variablesp. 381
Introductionp. 381
Functionality of the Applicationp. 381
Running the Applicationp. 382
Setting Up the Excel Sheetsp. 384
Getting Started with the VBAp. 385
Designing the User Form and Writing Its Event Codep. 386
The VBA Code in the Modulep. 388
Summaryp. 392
An Exponential Utility Applicationp. 395
Introductionp. 395
Functionality of the Applicationp. 395
Running the Applicationp. 396
Setting Up the Excel Sheetsp. 399
Getting Started with the VBAp. 400
Designing the User Form and Writing Its Event Codep. 401
The VBA Code in the Modulep. 403
Summaryp. 406
Simulation of a Multiserver Queuep. 409
Introductionp. 409
Functionality of the Applicationp. 410
Running the Applicationp. 410
Setting Up the Excel Sheetsp. 412
Getting Started with the VBAp. 412
The Structure of a Queueing Simulationp. 413
The VBA Code in the Modulep. 415
Summaryp. 424
An Application for Pricing European and American Optionsp. 427
Introductionp. 427
Functionality of the Applicationp. 428
Running the Applicationp. 428
Setting Up the Excel Sheetsp. 430
Getting Started with the VBAp. 431
Designing the User Form and Writing Its Event Codep. 433
The VBA Code in the Modulep. 436
Summaryp. 445
An Application for Finding Betas of Stocksp. 447
Introductionp. 447
Functionality of the Applicationp. 447
Running the Applicationp. 448
Setting Up the Excel Sheetsp. 449
Getting Started with the VBAp. 452
Designing the User Forms and Writing Their Event Codep. 453
The VBA Code in the Modulep. 456
Summaryp. 462
A Portfolio Optimization Applicationp. 465
Introductionp. 465
Functionality of the Applicationp. 465
Running the Applicationp. 466
Web Queries in Excelp. 470
Setting Up the Excel Sheetsp. 473
Getting Started with the VBAp. 473
Designing the User Forms and Writing Their Event Codep. 474
The VBA Code in the Modulep. 477
Summaryp. 486
A Data Envelopment Analysis Applicationp. 489
Introductionp. 489
Functionality of the Applicationp. 489
Running the Applicationp. 490
Setting Up the Excel Sheets and the Text Filep. 492
Getting Started with the VBAp. 493
Designing the User Form and Writing Its Event Codep. 494
Getting Data from a Text Filep. 495
The VBA Code in the Modulep. 496
Summaryp. 506
An AHP Application for Choosing a Jobp. 509
Introductionp. 509
Functionality of the Applicationp. 509
Running the Applicationp. 510
Setting Up the Excel Sheetsp. 513
Getting Started with the VBAp. 515
Designing the User Forms and Writing Their Event Codep. 518
The VBA Code in the Modulep. 521
Summaryp. 531
A Poker Simulationp. 533
Introductionp. 533
Functionality of the Applicationp. 534
Running the Applicationp. 534
Setting Up the Excel Sheetsp. 536
Getting Started with the VBAp. 536
The VBA Code in the Modulep. 536
Summaryp. 542
Indexp. 545
Table of Contents provided by Syndetics. All Rights Reserved.

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×