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 15, 2014

Liberty Security Sales Summarizer

 Liberty Security is a security sales and monitoring company that is based out of Edmonton, Alberta Canada. Nathan Baldry, one of the two owners, married my wife’s cousin 7 years ago. Before they were married he was my roommate for a year.

One of the secretaries at Liberty is in charge of creating a summary document of all the sales and cancellations that happened over the past month. She gets these numbers from their CRM system which outputs a csv file for sales and cancellations of the indicated period.

The purpose of this project is to automate the summarizing process so that what was once a 2 to 3 hour task can be accomplished in a matter of seconds. My project allows the user to select the appropriate csv files from their directory. It then proceeds to summarize the information and put into the desired types of tables that our find on the summary worksheet.

No comments:

Post a Comment

Blog Archive