Tweet
I created an advanced spreadsheet as a pet project some time ago which includes all regular season statistics and playoff games from season 12 all the way to the most recent season, and figured it would be cool to share it to the few in this community who care about statistical spreadsheets such as this one. Unfortunately data prior to these seasons was lost in time due to a certain individual removing a lot of data to make more space on the server. I have attempted to combine all known aliases under their main name, but certainly might have missed some people as this list has statistics of over 500 players.
HOW TO READ AND USE THIS SPREADSHEET
- numbers under season columns represents which rank a player during the regular season and playoffs. as an example, megaman89 was the sixth best performing player in the regular season and second best performing player in the playoffs inseason 12. players highlighted with golden color played in the playoffsand won the season that year, and players highlighted with silver color played in the playoffs and finished second place.
- the formula to determine the performance rating of a player israther simple: (PM * 3) + (KKPM * 2) * Confidence.
and last, but most certainly not least, you can search players and see their kills, deaths, rank, and squad history by using the player search tool. it takes a while for the spreadsheet to process all information as the formulas are not optimized and google spreadsheets in general tends to be slow. You can access the spreadsheet by clicking the link below:
https://docs.google.com/spreadsheets...-wwVw87gCVA6rU
HOW TO READ AND USE THIS SPREADSHEET
- numbers under season columns represents which rank a player during the regular season and playoffs. as an example, megaman89 was the sixth best performing player in the regular season and second best performing player in the playoffs inseason 12. players highlighted with golden color played in the playoffsand won the season that year, and players highlighted with silver color played in the playoffs and finished second place.
- the formula to determine the performance rating of a player israther simple: (PM * 3) + (KKPM * 2) * Confidence.
- PM stands for Plus-Minus score of the player which is essentially kills minus deaths.
- KKPM is essentially total kills of the player plus Plus-Minus score.
- Confidence is an added multiplier where players who only played in few games get a slight penalty to their overall rating. I have additionally adjusted all player ratings across the seasons with an added multiplier to keep the ratings at around same value as the amount of games player in both regular season and playoffs has changed drastically over the years.
- below regular season is theaverage rating of a player which features their three best regular season performances, and the column next to it displays the total rating across all regular seasons.
- below playoffs is the average rating of a player featuring their four best playoff performances, and the column next to it displays the total rating of all playoffs.
- players on this spreadsheet are ranked based on the total rating of their three best regular seasons and four best playoff seasons.
and last, but most certainly not least, you can search players and see their kills, deaths, rank, and squad history by using the player search tool. it takes a while for the spreadsheet to process all information as the formulas are not optimized and google spreadsheets in general tends to be slow. You can access the spreadsheet by clicking the link below:
https://docs.google.com/spreadsheets...-wwVw87gCVA6rU