NBA Mock Lottery Draft

I love basketball so for my final VBA project, I decided to create a mock draft for the upcoming NBA lottery.  On May 20^th, 2014 the real NBA Lottery will occur for each team that failed to make the playoffs.  Each team is assigned a given a number of balls according to how many wins and losses that they had the previous season.  The team with the worst record is assigned the most balls; the team with the second worst record is assigned the second most balls, and so on.  There are a total of 1000 balls.  The breakdown for each team is shown below.

Team Rank (out of 30)	Number of Balls	Chance of winning lottery
30	250	25.0%
29	199	19.9%
28	156	15.6%
27	119	11.9%
26	88	8.8%
25	63	6.3%
24	43	4.3%
23	28	2.8%
22	17	1.7%
21	11	1.1%
20	8	.8%
19	7	.7%
18	6	.6%
17	5	.5%

            The purpose of the lottery is to determine the real draft order that occurs when the season is over at the end of June.  “Winning” the lottery means that you will be the first to draft the player of your choice that is coming out of college.  The lottery is completely random and is designed to give the teams with the worst records a better shot at getting a higher draft pick which will allow them to choose the player that they feel will fit best with their team.  The hope is that whichever player they select will then help them win more games the upcoming year.

            The purpose of my project was to recreate this lottery based off of accurate up-to-the-minute data to see what the chances each team had of winning the lottery, so that I wouldn’t have to wait until the end of the season to start guessing where the best college players are most likely to end up next year.

http://files.gove.net/shares/files/14w/paytonvo/final_write_up_vba.pdf

http://files.gove.net/shares/files/14w/paytonvo/FinalProject_Lottery.xlsm