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

Monday, April 15, 2013

Searching for MMA Fighters

Mixed Martial Arts is one of the fastest growing sports in the world. As with most professional sports, many people want to compare the athletes’ statistics against each other. While it is not difficult to view one fighter’s statistics online, it can be difficult to compare hundreds of fighters’ statistics simultaneously, especially if you want to try and search for all the fighters that meet certain qualification.

 In order to solve this problem, I wrote an excel vba project that downloads fighters statistics off of the website and allows users to perform more comprehensive searches.

First, the worksheet downloads 20 different statistics on each fighter on the website. Then it gives users an advanced search form. It allows them to search numeric values using the logical comparators of less than, equal to or more than. It supports up to five different simultaneous search filters.

Once a user has found the records that they are looking for, they can export the data in two different ways. One way is to save the results into a new worksheet. The second way is to attach the results to an email and send them using Yahoo or Gmail.

This project interacts with the user through four different user forms that have robust error handling.

Here is the user's manual.

Here is the excel document.

No comments:

Post a Comment

Blog Archive