So each office pool entry would have an Excel worksheet that looks like this:
Game 1 Points Rebounds Assists Blocks Steals Turnovers
Player 1
Player 2
Player 3
...
Player 10
and then repeated for subsequent games
So I'm trying to figure out how to automatically have excel multiply actual stats into fantasy points (10 blocks = 20 fantasy points as a simple example).
|