This may be more complex than what this forum is intended for, but I will state my desired goal and see if someone is willing to help me through it.
I am attempting to create a Fantasy Football Draft assistance worksheet for my personal use. We have a very unusual setup with our league, and to my knowledge there is nothing existing out there that will fit our constraints. Here is a rundown of the rules(that pertain to this worksheet).
1. Number of Teams in the League varies between 8-12 each year depending on participants
2. We select 60 players to "Auction Draft" (usually top 20 at each position QB,RB,WR but we also toss in a couple of TE deducting from one of the other positions to keep the total balance at 60)
3.In the Auction each team has $200 to bid on players
4.We have a 16 player roster
5.Starters each week is 1xQB/2xRB/2xWR/1xTE/1xK/1xD/ and 1x FLEX (QB,RB,WR,TE) (essentially it is a 2 QB league as you almost always would start a QB in the Flex based on the way the points roll out in our league)
6.Once all 60 players are "Auction drafted" we begin a "Snake Draft" to fill out the remainder of our Rosters (Draft Order is determined by $ remaining from the Auction)
I think that gives the basic layout needed to understand my question, so here goes. I am looking for help with the "Auction part of the Draft and Dynamically assigning $ values to players based on a few things. I have already worked up a "Points Value" for each player and a curve set associated with it. What I need to be able to do is translate that number to a $ amount that takes into account That each team only has $200 so if a player goes for more than the value I have assigned to them the others below Dynamically adjust or vise versa. I would also like it to be able to take into account my team needs. i.e. if I already have 1 QB it does not weight QB as heavily for the remainder.
It seems I cannot Attach files to the forums so I will try to make a quick and dirty example with the tools for the forum.
Any help would be greatly appreciated!! Thanks folks
<tbody>
</tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
I am attempting to create a Fantasy Football Draft assistance worksheet for my personal use. We have a very unusual setup with our league, and to my knowledge there is nothing existing out there that will fit our constraints. Here is a rundown of the rules(that pertain to this worksheet).
1. Number of Teams in the League varies between 8-12 each year depending on participants
2. We select 60 players to "Auction Draft" (usually top 20 at each position QB,RB,WR but we also toss in a couple of TE deducting from one of the other positions to keep the total balance at 60)
3.In the Auction each team has $200 to bid on players
4.We have a 16 player roster
5.Starters each week is 1xQB/2xRB/2xWR/1xTE/1xK/1xD/ and 1x FLEX (QB,RB,WR,TE) (essentially it is a 2 QB league as you almost always would start a QB in the Flex based on the way the points roll out in our league)
6.Once all 60 players are "Auction drafted" we begin a "Snake Draft" to fill out the remainder of our Rosters (Draft Order is determined by $ remaining from the Auction)
I think that gives the basic layout needed to understand my question, so here goes. I am looking for help with the "Auction part of the Draft and Dynamically assigning $ values to players based on a few things. I have already worked up a "Points Value" for each player and a curve set associated with it. What I need to be able to do is translate that number to a $ amount that takes into account That each team only has $200 so if a player goes for more than the value I have assigned to them the others below Dynamically adjust or vise versa. I would also like it to be able to take into account my team needs. i.e. if I already have 1 QB it does not weight QB as heavily for the remainder.
It seems I cannot Attach files to the forums so I will try to make a quick and dirty example with the tools for the forum.
Any help would be greatly appreciated!! Thanks folks
<tbody>
</tbody>
| Order | Name/Team/Position | Projected Value | Estimated $ value |
| 1 | Manning, Peyton (Den) QB | 461 | |
| 2 | Rodgers, Aaron (GB) QB | 425 | |
| 3 | Peterson, Adrian (Min) RB | 317 | |
| 4 | Brees, Drew (NO) QB | 421 | |
| 5 | Luck, Andrew (Ind) QB | 365 | |
| 6 | Brady, Tom (NE) QB | 345 | |
| 7 | Charles, Jamaal (KC) RB | 305 | |
| 8 | Newton, Cam (Car) QB | 367 | |
| 9 | McCoy, LeSean (Phi) RB | 308 | |
| 10 | Stafford, Matthew (Det) QB | 369 | |
| 11 | Griffin, Robert (Wsh) QB | 363 | |
| 12 | Lynch, Marshawn (Sea) RB | 295 | |
| 13 | Wilson, Russell (Sea) QB | 338 | |
| 14 | Romo, Tony (Dal) QB | 350 | |
| 15 | Johnson, Calvin (Det) WR | 254 | |
| 16 | Kaepernick, Colin (SF) QB | 335 | |
| 17 | Foles, Nick (Phi) QB | 350 | |
| 18 | Ryan, Matt (Atl) QB | 348 | |
| 19 | Forte, Matt (Chi) RB | 303 | |
| 20 | Martin, Doug (TB) RB | 267 | |
| 21 | Thomas, Demaryius (Den) WR | 234 | |
| 22 | Stacy, Zac (StL) RB | 243 | |
| 23 | Foster, Arian (Hou) RB | 234 | |
| 24 | Bryant, Dez (Dal) WR | 220 | |
| 25 | Green, A.J. (Cin) WR | 217 | |
| 26 | Lacy, Eddie (GB) RB | 279 | |
| 27 | Murray, DeMarco (Dal) RB | 242 | |
| 28 | Bell, Le'Veon (Pit) RB | 285 | |
| 29 | Morris, Alfred (Wsh) RB | 236 | |
| 30 | Rivers, Philip (SD) QB | 338 | |
| 31 | Cutler, Jay (Chi) QB | 311 | |
| 32 | Graham, Jimmy (NO) TE | 205 | |
| 33 | Roethlisberger, Ben (Pit) QB | 303 | |
| 34 | Dalton, Andy (Cin) QB | 310 | |
| 35 | Marshall, Brandon (Chi) WR | 214 | |
| 36 | Jones, Julio (Atl) WR | 210 | |
| 37 | Nelson, Jordy (GB) WR | 204 | |
| 38 | Bush, Reggie (Det) RB | 224 | |
| 39 | Jeffery, Alshon (Chi) WR | 207 | |
| 40 | Brown, Antonio (Pit) WR | 209 | |
| 41 | Johnson, Andre (Hou) WR | 198 | |
| 42 | Thomas, Julius (Den) TE | 178 | |
| 43 | Jackson, Vincent (TB) WR | 186 | |
| 44 | Manning, Eli (NYG) QB | 294 | |
| 45 | Cobb, Randall (GB) WR | 202 | |
| 46 | Fitzgerald, Larry (Ari) WR | 171 | |
| 47 | Garcon, Pierre (Wsh) WR | 166 | |
| 48 | Jackson, DeSean (Wsh) WR | 160 | |
| 49 | Allen, Keenan (SD) WR | 167 | |
| 50 | Ball, Montee (Den) RB | 232 | |
| 51 | Bernard, Giovani (Cin) RB | 229 | |
| 52 | Cruz, Victor (NYG) WR | 160 | |
| 53 | Flacco, Joe (Bal) QB | 284 | |
| 54 | Mathews, Ryan (SD) RB | 212 | |
| 55 | Spiller, C.J. (Buf) RB | 212 | |
| 56 | Gore, Frank (SF) RB | 223 | |
| 57 | Rice, Ray (Bal) RB | 214 | |
| 58 | Hilton, T.Y. (Ind) WR | 154 | |
| 59 | Palmer, Carson (Ari) QB | 293 | |
| 60 | Welker, Wes (Den) WR | 148 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
| Team 1 | $200 |
| Team 2 | $200 |
| Team 3 | $200 |
| Team 4 | $200 |
| Team 5 | $200 |
| Team 6 | $200 |
| Team 7 | $200 |
| Team 8 | $200 |
| Team 9 | $200 |
| Team 10 | $200 |
| Total: | $2,000 |
<colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
