VBA for Modelers or Practical Management Science

VBA for Modelers: Developing Decision Support Systems Using Microsoft Excel

Author: S Christian Albright

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.

Booknews

This book/CD-ROM package shows professionals and students how to develop customized decision support systems for business problems using Microsoft Excel's Visual Basic for Applications (VBA). Early chapters cover basics of VBA, including general programing concepts, building dialog boxes, and debugging. Later chapters explain how VBA and Excel can be used to create specific decision support applications for problems in employee scheduling, transportation logistics, capital budgeting, pricing American and European options, and portfolio optimization. The CD-ROM contains exercise files. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Table of Contents:

Pt. I	VBA Fundamentals	1
1	Introduction to VBA Development in Excel	3
2	The Excel Object Model	7
3	The Visual Basic Editor	13
4	Getting Started with VBA	27
5	Recording Macros	49
6	Working with Ranges	63
7	Control Logic and Loops	81
8	Working with Other Excel Objects	107
9	Arrays	125
10	More on Variables and Subroutines	147
11	Working with the Solver Add-In in VBA	171
12	User Forms	187
13	Debugging and Error Handling	213
Pt. II	VBA Applications for Management Science	227
14	Basic Ideas for Application Development with VBA	229
15	A Blending Application	253
16	A Product Mix Application	271
17	An Employee Scheduling Application	291
18	A Production Scheduling Application	307
19	A Minimum-Cost Network Flow Application	333
20	A Stock Trading Simulation	353
21	A Capital Budgeting Application	367
22	An Application for Estimating the Relationship Between Two Variables	381
23	An Exponential Utility Application	395
24	Simulation of a Multiserver Queue	409
25	An Application for Pricing European and American Options	427
26	An Application for Finding Betas of Stocks	447
27	A Portfolio Optimization Application	465
28	A Data Envelopment Analysis Application	489
29	An AHP Application for Choosing a Job	509
30	A Poker Simulation	533
	Index	545

New interesting textbook: Food for Life or Reiki Energy Medicine Bringing the Healing Touch into Home Hospital and Hospice

Practical Management Science: Spreadsheet Modeling and Applications

Author: Wayne L Winston

Practical Management Science by Wayne Winston and Chris Albright teaches you by example to formulate and solve real problems from finance, marketing, and operations with a spreadsheet. This new spreadsheet modeling approach gives you a powerful set of analytical thinking tools that you can apply not only to your major area of study but ultimately to your professional career. Spreadsheet modeling and management science provide you with the ability to quantify complex problems and clearly illustrate optimum business decisions. Mastering the concepts introduced in this book will give you deeper insights into your field of study and key advantages in the workplace.

Booknews

The textbook provides a spreadsheet-based, example-driven approach to management science that integrates modeling with finance, marketing and operations management. The second edition adds an introductory chapter on the basics of Excel modeling. The CD-ROM contains Premium Solver, SolverTable, and the DecisionTools Suite. Annotation c. Book News, Inc., Portland, OR (booknews.com)