# Creating Stats Sheet

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

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

• 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 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.length;j++)
if( bg[i][j] == color )
count=count+1;
return count;
};``````