1
I created a spreadsheet to allow players to track their tournament score for each game.
Here is a breakdown of each column and how to use it.
Column A: This column just tracks the game # no need to enter any data in it.
Column B: Enter how many kills this game.
Column C: Enter how many assists this game.
Column D: Enter how much damage this game.
Column E: Enter how much friendly fire damage this game (oooooops!)
Column F: Enter a 1 if you won this game. Otherwise leave blank.
Column G: Enter a 1 if you lost this game. Otherwise leave blank.
Column H: Enter a 1 if you survived this game. Otherwise leave blank.
Column I: Enter a 1 if you died this game. Otherwise leave blank.
Column J: This column calculates your game score based on the formula provided by PGI.
Column K: This column takes your top 10 games and adds them up. Giving you your tournament score for that mech.
You can copy and paste more sheets if you need to track more than 1 mech.
Here is how the spreadsheet looks.
Here is a link to download the spreadsheet.
https://docs.google....W5tYnIyWTA/edit
Enjoy
