HATO - updateTrafficOfficers

function updateTrafficOfficers() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var memberSheet = spreadsheet.getSheetByName("Members");
  var middleMan = SpreadsheetApp.openById("19El8Db9SBAW4C4LYDl-XFnKiEB6cbapjjH2WoCP6Gnk");
  var middleManSheet = middleMan.getSheetByName("Pending Phase 2");
  var memberArray = memberSheet.getDataRange().getValues();
  var pendingArray = middleManSheet.getDataRange().getValues();
  for (var i = 3; i < pendingArray.length; i++) {
    var c = i + 1;
    var steamID = middleManSheet.getRange(c, 2).getValue();
    if (steamID > 0) {
      for (var u = 1; u < memberArray.length; u++) {
        if (memberArray[u][4] == steamID) {
          var x = u + 1;
          memberSheet.getRange(x, 4).setValue("T/O");
          //Finds Last T/O
          for (var p = 1; p < memberArray.length; p++) {
            if (memberArray[p][3] == "T/O") {
              var targetRow = p + 2;
            }
          }
          var rowSpec = memberSheet.getRange("C" + x + ":O" + x);
          var destinationIndex = targetRow;
          memberSheet.moveRows(rowSpec, destinationIndex);
          var clearrange = middleManSheet.getRange("A" + c + ":C" + c);
          clearrange.clearContent();
          clearrange.clearFormat();
        }
      }
    }
  }
}