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

NBA Fantasy Forecaster

Fantasy sports gaming is tremendously popular. In fact, in 2007, 29.9 million people aged 12 and older in the United States and Canada played fantasy sports. I have played fantasy basketball for over ten years and enjoy the competition, researching players, and following player statistics. Because player stats are so carefully tracked and widely available on the internet, I realized that instead of randomly picking players each week to put into my lineup I could use these stats to estimate how players would perform on a weekly basis. In the past I have tried to put together complex spreadsheets and searched the internet for hours to find the information I needed. It always took a lot of time and I eventually stopped doing it because of the time commitment.

The model I have built utilizes player statistics from the internet that will predict the most likely outcome of a weekly matchup. The user will open the spreadsheet, enter their team information as well as opponent team information into user forms, click a button to download the latest player statistics as well as weekly team schedules from the internet, and then click a button to calculate the projected score totals for both fantasy teams. These totals, as well as the final score, will then be shown to the user. If unsatisfied with the projected score, the user could then adjust their team lineup in the user form to see if a better outcome could be achieved.

No comments:

Post a Comment

Blog Archive