Automation
Margin Report
Excel .xlsm file - via MS VBA, Excel
A Microsoft Excel report with Pivot Tables assembled via a macro. The user copies and pastes raw data from a generated
file into the workbook then runs a macro that inserts multiple pivot tables to more easily consume information.
Web Scraping GasBuddy - via Python (Selenium, Pandas)
A Python script to web scrape using Selenium. Collects local gas prices from the
GasBuddy website
to be used in a diesel tracking dashboard.
Python code
Word Report Automation
FCD Students Attitudes and Behaviors Survey Report Automation - via Microsoft VBA, Excel, Word
Abstract: Freedom from Chemical Dependency Prevention Works (FCD) administers the Students
Attitudes and Behavior Survey (SABS) to measure student attitudes and behaviors regarding
alcohol and other drugs as well as their perceptions of schoolmates’ attitudes and behaviors. The
survey results are then communicated within a 100-page report. The goal of this project was to
automate the report. Using Microsoft Visual Basic for Applications (VBA), ways to automate intext inputs, tables, and charts from Excel to Word were determined. While the whole report was
not completed, the completed portion runs much faster than the previous method of manual
input.