1. Introduction to Visual Basic for Applications LT Craig Maxey

2. Context • Analyst’s are constantly tasked with an excess of work. Programming capabilities introduced to the analyst community will elevate the efficacy of their work. • Purpose • Introduce analysts to the capabilities and functionality of a powerful programming platform resident on each of their machines • Outcome • Will provide analysts an overview of capabilities if they choose to increase their knowledge of Excel VBA FOR OFFICIAL USE ONLY

3. Overview • Introduction • Capabilities • Macro’s • Integrated Development Environment • Data Types • Range Objects • Iterative Programming • Practice

4. Capabilities • Applications • HEDIS Opportunity Tool • Data Manipulation • PEB Data Manipulation • Fit To Fill Workflow • Data Cleanup • M2 Data cleanup

5. ApplicationsHEDIS Opportunity Tool

6. PEB Data Manipulation

7. PEB Data Manipulation (Cont.)

8. M2 Data Cleanup

9. Macro’s

10. Integrated Development Environment (IDE)/WorkFlow

11. Programming Basics FOR OFFICIAL USE ONLY

12. Data Types • Int - Integers • Double – Double Precision Floating Point • Range from -1.7E308 to 1.7E308 (That’s Big) • Strings – Text (These are objects, but we will worry about what that means later) • Booleans – T/F

13. Range Object • Represents a contiguous area of cells in a spreadsheet • Range is the base object in Excel VBA Programming

14. Iterative Programming • For Loop • Do Loop

15. Summation Idea • Let’s Make a Calculator!!! • What do we need? • How do we return a value?

16. Questions?