At some point if we have a lot of people working on these we can convert to a google sheet
to handle live changes etc. For now though its just excel, so best if we have just one person working on each club.
Instructions:
- grab the spreadsheet.
- so far it has all players who played a game in 2018.
- The script i used to grab them from the web did some rough guesses based on their stats for the season. Not accurate at all, just a starting point.
- tab 1 (calculations and lists) is the data for the dropdowns on the ratings tab, and calculations for position ratings. Dont change anything here. (useful to look at for reference though)
To build a player:
- go to your club's tab.
- fill in the skills (green). Ratings will calculate from those
- use dropdowns for original club/state
- dont edit anything in blue or grey.
- for adding a new players, you can just add a row. PlayerID can be generated from any one of a number of online utilities like this:
https://www.guidgenerator.com/online-guid-generator.aspxBalance
- first pass through we can just get players roughed in, then comb through them a few more times as we get closer to release
- As a rule of thumb AFL standard players will rate generally in the 60-100 range.
- PC2011 distribution looked like this:
https://www.amazon.com/clouddrive/share/Ew0YdEm8Jox2m2nBlDzM1uLZ3006DtBbRsyKQHQ2zfE