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

  1. Download spreadsheet
  2. Upload to your own google sheets
  3. 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;
};

Last Updated on February 17, 2021 at 11:13 pm by Dizzy Jay