These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, April 14, 2016

Events Report Automation - Cory Paxton

Executive Summary

This project creates a weekly report used by the HFAC Events Production department from event data exported from an events scheduling software. The code in this project edits the formatting of the data exported from the events scheduling software, uses several loops and if statements to find and capture the desired data, and populates a report on another sheet that contains the information specified by the department in their specified format. The project also includes buttons in their own ribbon and user forms that allow the user to customize the report to their needs. Prior to this project, a full-time employee would spend 4+ hours creating this report manually

This agenda/report is for the coordination meeting of several groups within the events production department in the Harris Fine Arts Center on campus. They are responsible for ensuring events such as concerts, musicals, dance performances, and several others are properly scheduled and executed. The information on the agenda is a key tool for the groups to properly plan for the events in the upcoming weeks. Not only does the automation save on the labor hours, but on errors as well. Prior reports contain spelling errors along with the incorrect information.

The attached Excel file includes the scheduling software data (on sheet “EMS Report”) and the header for the agenda (on sheet “Coordination Mtg Agenda”: the actual agenda is created beneath the header).

No comments:

Post a Comment

Blog Archive