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

Tuesday, April 12, 2011

Daily Transaction Emailer

In the production accounting department of BYU Broadcasting we are tasked with managing and tracking the budgets and costs of around 150 different projects ranging from TV shows to radio programs. We have 6 Unit Production Managers (UPMs) who are each assigned to a number of these projects. In order to facilitate better decision-making for those involved in these projects I developed a program that downloads all the transactions across all projects from the previous day, parses them into different files according to UPM, and subsequently emails the files to each UPM.

1 comment:

Blog Archive