Original creator of a Stats Sheet has posted over on reddit a v1.1 of his Stat sheet, VilkusRex (aka CarolusRex). You can directly access the file by going to it here EHT Stat Tracker V1.1.
Below is one of my own home-grown versions, much simpler than his own.
You may want to see how all your hunters stats are; there isn’t a simple way to see that besides inputting it into a spreadsheet. Use my spreadsheet as a sample to get started.
Steps
- Download spreadsheet
- Upload to your own google sheets
- Input your data
Note: If you want to have the hunter stat calculator, you’ll have to add more effort (might not be worth it).
Steps for hunter stats calculator
- Read through the documentation about google sheets custom functions
- Follow the video on how to add custom functions
- Check the code below and add it as your custom function
/**
* @param {range} countRange Range to be evaluated
* @param {range} colorRef Cell with font color to be searched for in countRange
* @return {number}
* @customfunction
*/
function countFontColoredCells(countFontRange,colorRef) {
var activeRange = SpreadsheetApp.getActiveRange();
var activeSheet = activeRange.getSheet();
var formula = activeRange.getFormula();
var rangeA1Notation = formula.match(/\((.*)\,/).pop();
var range = activeSheet.getRange(rangeA1Notation);
var bg = range.getFontColors();
var values = range.getValues();
var colorCellA1Notation = formula.match(/\,(.*)\)/).pop();
var colorCell = activeSheet.getRange(colorCellA1Notation);
var color = colorCell.getFontColor();
var count = 0;
for(var i=0;i<bg.length;i++)
for(var j=0;j<bg[0].length;j++)
if( bg[i][j] == color )
count=count+1;
return count;
};