Ok, so this may be an easy ? for you excel experts, but I'm only a novice and could use some help if anyone would like to
lend a hand. I am working on a spreadsheet to be used in fantasy football and what I am attempting to do is predict the best
order to select certain positions in a draft. I'll break down below what I am attempting to calculate, and would greatly
appreciate if someone could tell me if this can be done (I would assume it can) and how to do it.
So what I am
looking for is to determine the best order for the selection of 8 different football positions in a fantasy football draft.
The positions are Quarterback, Wide Receiver, Wide Receiver 2, Wide Receiver 3, Running Back, Running Back 2, Flex 1 (QB, WR,
or RB), and Flex 2 (again QB, WR, RB). Now the first thing I need to do is have excel generate all the different combinations
of these possible picks across the first 8 rounds of a draft. For example-
Three potential orders of picks for
QB, QB2 (Flex1), QB3 (Flex2), WR, WR2, WR3, RB, RB2
QB, QB2 (Flex1), WR, WR2, WR3, RB, RB2, QB3 (Flex2)
QB, WR, WR2, WR3, RB, RB2, QB2 (Flex 1), QB2 (Flex2)
Obviously there are going to be thousands of potential
combinations which is why I need to find a way (if possible) for excel to generate them.
Once all of the
combinations are generated I will insert values for each of the picks. For example a QB picked in round 1 is worth 300, in
round 2 is worth 275, and so on. Same for all of the other options. This part of it I know how to do with if/then formulas,
but I can't figure out how to get excel to generate the combinations for me.
Let me know if I'm not being clear
enough to understand what I am looking to do. I appreciate any help anyone can offer.