I have a player valuation spreadsheet for you. This tool will help working out who to trade in or out of your team to get the best money changes after the end of round 3.
Brief instructions:
- You only have to enter information into the green cells, the other cells are protected to prevent any errors.
- Confirm or change Magic Number estimate for the end of round 3 – cell Q2. I’ve put it at 5,050 – if you think you know enough about MN to put another number you can change it.
- Enter your players using the drop down menu. In the menu only the players who fit that position are named in full, other players are reduced to 3 letters.
- For each player in your team data is pulled up automatically –
- Team and position for 2013. If this is different to 2012, their previous team and position is also shown, or if this is their 1st year playing.
- 2013 starting price.
- Points expected based on that price (using initial magic number 5,150).
- The difference in points between their 2013 base and their points average for all of 2012. For most players who played last year this difference will be zero.
- 2012 Performance in 3 columns – average points, games played, standard deviation.
- There are 3 green cells to enter the actual scores (or your estimates) for your players for the first 3 rounds. Based on these scores the last 2 columns calculate the price change and new price after round 3.
- If you leave any cell blank the calculation assumes the player gets their 2013 base score for that round – i.e. the score in column G is used in the calculation.
- The player has to play 3 games for their price to change, so if the players miss a game the price change won’t happen until after they play 3 games.
- I’ve put in scores for Goddard, Gibbs and Heppell to give you the idea; you can remove these. Also the captain’s score isn’t doubled so the total score won’t match your real DT score for the rounds.
At the bottom of the spreadsheet there are 2 more tables. One table looks at the structure of your team, the other looks at distribution of byes.
Download the spreadsheet (excel 2007): DT2013 R1pub
I don’t want to write too much here, as many players on this forum have good understanding of how this works. But if you don’t understand or have any questions or comments please post below, or tweet me @NixTrader.
Recent Comments