Programming for Engineers

Featuring Excel Automation with VBA

An SPE YP Webinar Series

Presented by Derrick W. Turk | terminus data science, LLC

Session 1: "Eat Your Vegetables"

Session 1 Slides

Session 1 Finished Excel Workbooks:

• Hello VBA
  
• Funcs & Subs
  
• Pseudopressure
  

Session 1 Code Examples:

• Hello VBA
  
• Funcs & Subs
  
• Pseudopressure
  

Session 2: "Composite Materials"

Session 2 Slides

Session 2 Finished Excel Workbooks:

• Hyperbolic Decline
  

Session 2 Code Examples:

• Hyperbolic Decline
  
• Passing Modes
  

Session 3: "Object Lesson"

Session 3 Slides
Well decline data workbook

Session 3 Finished Excel Workbooks:

• Ballot Box
  
• Decline Forecaster
  

Session 3 Code Examples:

• Ballot Box Class
  
• Ballot Box Client
  
• Hyperbolic Decline
  
• Decline Forecaster
  
• Forecast Setup Form
  

Session 4: "One Small Step"

Session 4 Slides

Session 4 Finished Excel Workbooks:

• Logger
  
• Improved Decline Forecaster
  

Session 4 Code Examples:

• ILogger
  
• DebugLogger
  
• ExcelLogger
  
• Logger Client
  
• IDecline
  
• Hyperbolic Decline
  
• Duong Decline
  
• Decline Factory
  
• Decline Forecaster
  
• Forecast Setup Form
  
• Python Forecaster
  

TAMU Workshop 2017

TAMU Workshop 2017 Finished Excel Workbooks:

• Monte Carlo Volumetrics
  

TAMU Workshop 2017 Code Examples:

• MCVolumetrics
  

TAMU Workshop 2017 Additional Material:

• Errata, Unanswered Q&A, and Further Reading

References

• MSDN: VBA Language Reference
  
• MSDN: Excel Object Model Reference
  

(c) 2017 dwt | terminus data science, LLC
Webinar material is licensed under the Creative Commons CC-BY-NC 4.0 license (free for non-commercial use with attribution); all code samples and Excel examples are licensed under the MIT license (free for commercial or non-commercial use).