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

Wednesday, April 13, 2011

Aflac Report Generator

Aflac as a company generates a lot of reports about their business based on agents and locations. These reports take a lot of time to load and analyze for their leadership team. To save time and energy, I created a program that tracks the agents’ progress in the Boise region. This will help the regional manager more efficiently and effectively manage his agents.

I enabled the program to download the various reports to excel and automated calculations that were being done manually before. The manager will now get a text informing him when his reports are finished being compiled and give him the option to send e-mail reminders to the other managers in the territory and his own agents.

No comments:

Post a Comment

Blog Archive