Hello,

This asking a lot, I know, and I will honestly be surprised if anyone is following me. I decided to explain why this was a problem first before asking for help because I thought it might better facilitate someone in coming up with a solution. If any potential problem solvers just want to skip to the nitty gritty of the problem, just scroll down and click the last image.

I have an interesting Excel problem and I just can't seem to figure it out. So my situation is that I like to play in fantasy basketball leagues. The way Fantasy Basketball works is that you draft a team of actual NBA players, and you try to pick a team that finishes highest in all of the league's scoring categories, which are typically points, rebounds, assists, steals, blocks, 3-pointers made, field goal percentage (FG%), and free throw percentage (FT%).

Now points, rebounds, steals, blocks, and 3s are pretty self-explanatory - but it gets tricky when you rate percentage players. For example, the average NBA player shoots 46% from the field. LeBron James shoots 49%, and a lesser known player who shoots much less than LeBron does named Ronnie Turiaf shoots 51% from the field. So conventional wisdom would say that Turiaf is the better player to have to improve your team's FG% since he shoots a higher percentage. Not necessarily! Since you have to play 11 other players, on average in a 20-team league 11 players will shoot 54-117 from the field, 46%. Adding Ronnie Turiaf's average of 2.4 shots per 4.6 attempts per game will get your team up to just 46.4% shooting. However, adding LeBron's 9.7 makes per 19.9 shots will get your team's percentage up to 46.6%, so even though LeBron shoots a worse percentage than Turiaf his positive impact in the category is greater.

OK - So now on to my Excel question. In a larger league where more NBA players have to be rostered, the effect of one guy like LeBron who takes a huge amount of shots is greater than in a smaller league where only high quality NBA players who also take a lot of shots are rostered. What I am trying to do is create a dynamic spreadsheet that can use different baselines for leagues of different sizes.

http://i301.photobucket.com/albums/n...ingsFolder.jpg

For the cells titled "Rounds of Draft" and "Teams in League" - multiplying those 2 numbers gives you the number of players rostered in your league.

http://i301.photobucket.com/albums/n...layerstats.jpg

The above image shows my spreadsheet with all of the players' stats. So, for the league settings I have entered in my first picture, 12-team league with 13 rounds of the draft, 12*13=156, so for the field goals made value of a generic player I'd want the average FGM of the highest rated 156 players on my list. However, if I were playing in a 20-team league with 13 rounds, a total of 260 NBA players would be rostered, so for the generic players in my first image I'd want their FGM and FGA to be the average for the top 260 players, and then I could enter in LeBron James or Ronnie Turiaf and see what type of impact they'd have in the category given leagues of varying sizes.

SO - After all that Intro - FINALLY - My true Excel question!! (I apologize!!)

What I want to do is create a sheet that will set these baselines for me and all I have to do is type in the number of teams and the number of rounds of the draft. I tried to explain EXACTLY what i'm trying to do in this final image:

http://i301.photobucket.com/albums/n...celProblem.jpg

Can anyone help me out? I'd be very appreciate. Thanks for reading and for trying.