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 7, 2011

Eastside Harley-Davidson

Eastside Harley-Davidson in Bellevue, WA is the premier Harley-Davidson motorcycle dealership on the west coast. They are engaged in the sale of new and pre-owned motorcycles, parts, MotorClothes, rentals, and provide repair and maintenance service for their customer’s bikes. The company compiles a daily business report from which managers base many decisions. The report is compiled from several different sources on a daily basis and often consumes 30 minutes, if not more, of an employee’s time to assemble and compute the data. The sources of the daily transaction information include an Excel file which is received through e-mail, an Excel file which is manually pulled out of their in-house database, and several other figures which must be entered by hand. This VBA project minimizes, to the full extent possible, the number of steps, clicks, keystrokes, and time an employee must use to collect and analyze the information and then e-mail it to the managers group. This project also allows the user, at the beginning of each month, to reset the report with blank data as well as update the dates and goal information for each department. - James Tall

Writeup

VBA Project

Eastside Daily Report

Emerald City Daily Report

F&I Log

Store Goals

No comments:

Post a Comment

Blog Archive