Stack Overflow - 30150095

function setForegroundColor() {
  var spreadSheet = SpreadsheetApp.openByUrl("");
  var sheet = spreadSheet.getSheets()[0];
  var range = sheet.getRange(3, 2, 1, 10); //getRange(row, column, numRows, numColumns) (change the last value to increase the columns serviced)
  for (i = 1; i < 11; i++) {
    cell = range.getCell(1,i);
    color = cell.getBackground();
    cell.setFontColor(color);
  }
}

function calculateBLUFORManPower() {
 var spreadSheet = SpreadsheetApp.openByUrl("");
  var sheet = spreadSheet.getSheets()[0];
  var x = 0;
  var range = sheet.getRange(3, 2, 1, 10); //getRange(row, column, numRows, numColumns) (change the last value to increase the columns serviced)
  var cell = sheet.getRange("A17");
  var BLUFORColor = cell.getBackground();
  for (i = 1; i < 11; i++) {
    cell = range.getCell(1,i);
    color = cell.getBackground();
    if (color == BLUFORColor && cell.getValue != "") {
      x = x + cell.getValue();
    }
  }
  var cell = sheet.getRange("B19");
  cell.setValue(x);
}

function calculateBLUFORUnits() {
  var spreadSheet = SpreadsheetApp.openByUrl("");
  var sheet = spreadSheet.getSheets()[0];
  var x = 0;
  var range = sheet.getRange(3, 2, 1, 10); //getRange(row, column, numRows, numColumns) (change the last value to increase the columns serviced)
  var cell = sheet.getRange("A17");
  var BLUFORColor = cell.getBackground();
  for (i = 1; i < 11; i++) {
    cell = range.getCell(1,i);
    color = cell.getBackground();
    if (color == BLUFORColor) {
      x += 1;
    }
  }
  var cell = sheet.getRange("B18");
  cell.setValue(x);
}

function calculateOPFORManPower() {
  var spreadSheet = SpreadsheetApp.openByUrl("");
  var sheet = spreadSheet.getSheets()[0];
  var x = 0;
  var range = sheet.getRange(3, 2, 1, 10); //getRange(row, column, numRows, numColumns) (change the last value to increase the columns serviced)
  var cell = sheet.getRange("A20");
  var OPFORColor = cell.getBackground();
  for (i = 1; i < 11; i++) {
    cell = range.getCell(1,i);
    color = cell.getBackground();
    if (color == OPFORColor && cell.getValue != "") {
      x = x + cell.getValue();
    }
  }
  var cell = sheet.getRange("B22");
  cell.setValue(x);
}

function calculateOPFORUnits() {
  var spreadSheet = SpreadsheetApp.openByUrl("");
  var sheet = spreadSheet.getSheets()[0];
  var x = 0;
  var range = sheet.getRange(3, 2, 1, 10); //getRange(row, column, numRows, numColumns) (change the last value to increase the columns serviced)
  var cell = sheet.getRange("A20");
  var OPFORColor = cell.getBackground();
  for (i = 1; i < 11; i++) {
    cell = range.getCell(1,i);
    color = cell.getBackground();
    if (color == OPFORColor) {
      x += 1;
    }
  }
  var cell = sheet.getRange("B21");
  cell.setValue(x);
}

function OPFOR() {
  calculateOPFORUnits();
  calculateOPFORManPower();
}

function BLUFOR() {
  calculateBLUFORUnits();
  calculateBLUFORManPower();
}

function ALL(){
  setForegroundColor();
  BLUFOR();
  OPFOR();
}