210-processResults.gs

/**
 * Takes an array with results from each game iterations. Outputs processed and
 * formatted results to the log and returns an array processed results that should
 * be displayed in the spreadsheet.
 * 
 * @param {array} results: The array with results from each game iteration. Each
 * entry should be an object with data on the form property:numericValue.
 */
function processResults(results) {
  /**
   * Process and display + return data.
   */

  // Sort results. (Needed for percentiles.)
  var sortedResults = {};
  for (let i in results[0]) {
    sortedResults[i] = [];
  }
  for (let i in results) {
    for (let j in results[i]) {
      sortedResults[j].push(results[i][j]);
    }
  }
  for (let i in sortedResults) {
    sortedResults[i].sort(function(a, b) {return a - b;});
  }

  /**
   * First build log messages.
   */
  // Header row
  let message = 'DISTRIBUTION: average (percentile ';
  let values = [];
  for (let p of BPTstatic.statistics.percentiles) {
    values.push(p);
  }
  message += values.join(' | ') + ')\r\n---\r\n';
  // Each result
  for (let i in sortedResults) {
    message += i + ': ';
    message += average(sortedResults[i]).toFixed(2) + ' (';
    values = [];
    for (let p of BPTstatic.statistics.percentiles) {
      values.push(percentile(sortedResults[i], p).toFixed(2));
    }
    message += values.join(' | ') + ') Positive at ';
    message += getPositiveThreshold(sortedResults[i]).toFixed(2) + '\r\n';
  }
  log(message, 'statistics');

  /**
   * Then build output array to send to a calling spreadsheet.
   */
  // Labels
  let output = [['']];
  for (let i in sortedResults) {
    output[0].push(i);
  }
  // Average values
  output.push(['Average']);
  for (let i in sortedResults) {
    output[1].push(average(sortedResults[i]));
  }
  // First percentile where value is non-zero
  output.push(['Positive at']);
  for (let i in sortedResults) {
    output[2].push(getPositiveThreshold(sortedResults[i]));
  }
  // Percentiles
  for (let p of BPTstatic.statistics.percentiles) {
    let line = ['percentile ' + p];
    for (let i in sortedResults) {
      line.push(percentile(sortedResults[i], p));
    }
    output.push(line);
  }
  return output;
}