Tuesday, April 14, 2015

Boostability Employee Efficiency Report Generator - By Brett Bishopp





Employee Efficiency Report Generator
By Brett Bishopp

Executive Summary

Boostability is an internet marketing company. A large part of what they do is create internet content to draw appropriate attention towards their clients’ websites. Efficiency Reports are key in understanding both the effectiveness of an employee’s time in being able to generate internet traffic for a client.  It is the heart of what the business does for the client.

This program will automate the creation of these Efficiency Reports. Because the user base for implementation of these reports will be changing, foresight into possible user errors are key into the making of this program work smoothly.

Due to potential for high employee turnover, this program integrates the option to update employee data while the program is running. User-entered data will be retained, minimizing the user-interface required in the future.

Overall, these Efficiency Reports are a great tool but take time to create, especially in training the frequently changing user base. Daily, weekly, and monthly reports are created to track progress and trends. The time demanded to generate these reports adds up. This program automates the creation of these reports, both giving back time to the user base as well as ensuring quality data due to decreased risk of user error.

VBA Program:
Supporting Excel files (VBA code will ask for supporting files):
 PDF Project Overview:

No comments:

Post a Comment