what i have:

- the top 120 players in fbb from the 04-05 season (all are one of the following positions -- PG, SG, SF, PF, C)

- values for each of those players in each of the 9 standard scoring categories (field goal %, free throw %, 3-pointers made, points, rebounds, assists, steals, blocks, turnovers)

the setup:

- 12 teams, 10 players each

- 10 standard positions for each team (PG, SG, G, SF, PF, F, C, C, UTIL, UTIL) G can be filled by a player with either PG or SG eligibility, F with either SF or PF, and UTIL by any player

- previously mentioned 9 scoring categories

what i'd like to do:

- randomize the players on each team

- team values for each of the 9 statistical categories are calculated by adding the players' individual values

- teams are given points for each category based on the sum of the values -- as an example, the team with the highest rebound value sum gets 12 points, the least gets 1

- team category points are added together to get a total score, and teams are given a standing (1-12, first to last) based on this total score (highest to lowest)

- the individual category point values and overall team rankings are assigned to each player and calculated each time the teams are randomized -- a player will have an average for each stat category point and an overall team standing average, based on the teams they were part of

i'd have to assume that the following are huge issues:

- the teams need to be randomized

- any PG or SG can be used to fill the G position each time, any SF or PF can be used for the F position, and any player can be used for the UTIL spots

-----------------------

this article is where the idea for this came about. there is a bit more detail from the author there on his methods. he is a PhD of Economics and was likely using something a bit more advanced than microsoft excel when he ran his 40,000 sims, but i'm trying to make due with what i have

i actually have no idea if this is possible, but since no one has told me 'no' as of yet, i'm still holding out hope. i can go into more detail if anyone needs it -- thanks for checking out my post