- Jun 25, 2009
- 774
- 367
- AFL Club
- Collingwood
I'm sure quite a lot of you have developed spreadsheets and other tools to help you manage your SuperCoach team. I'm pretty proud of mine so I thought I'd share a link.
Basically, this tool works by finding the best possible team for my money. I input a bunch of info and then push a button and let it find how I can maximize my points given the available salary. It contains historical averages and games played for each player going back to 2005. I use this info, as well as NAB Cup info to estimate the average PPG and games played for each player for the current year. I can tell it which players are unavailable or which ones it must pick.
Other constraints I can input are the minimum and maximum number of 1st year players and the salary distribution by defence, mids, fwds and rucks.
Here's a little video of it. I put it together with the thought of maybe one day making some money off it, so I'm not going to share the tool itself.
I love to hear about other tools that people have put together.
Basically, this tool works by finding the best possible team for my money. I input a bunch of info and then push a button and let it find how I can maximize my points given the available salary. It contains historical averages and games played for each player going back to 2005. I use this info, as well as NAB Cup info to estimate the average PPG and games played for each player for the current year. I can tell it which players are unavailable or which ones it must pick.
Other constraints I can input are the minimum and maximum number of 1st year players and the salary distribution by defence, mids, fwds and rucks.
Here's a little video of it. I put it together with the thought of maybe one day making some money off it, so I'm not going to share the tool itself.
I love to hear about other tools that people have put together.