MgtOp 556 Lecture Notes

Topic 1—VBA Programming in Excel for Decision Support Systems

Set 1—VBA Basics, Input/Message Boxes, Interacting with the Spreadsheet, VBA Constants, Using Excel Functions in VBA, String Functions, and User-Defined Functions

Set 2—Referencing Worksheets, “With” Construction, and Working with Ranges

Set 3—Control Logic and Loops

Set 4—Workbooks & Worksheets, Arrays, Calling Subs & Passing Arguments, Global vs. Local Variables

Set 5—User Forms: Becoming a True “Windows Programmer”

Topic 2—The Craft of Modeling

Set 1—Modeling and Heuristics

Set 2—Excel Tools for Model Analysis

Topic 3—Monte Carlo Simulation

Topic 4—Waiting Lines and Queuing Theory

Topic 5—Mathematical Programming