Pyrgos - archive

function archive() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var OCreports = spreadsheet.getSheetByName("OC Reports");
  var OCreportArchive = spreadsheet.getSheetByName("Archive OC Reports");
  var reportLS = OCreports.getLastRow();
  var addedRows = 0;
  var rowNumber = [];
  for (var a = 11; a <= reportLS; a++) {
    var checked = OCreports.getRange(a, 13).getValue();
    if (checked == "Checked") {
      rowNumber.push(a);
      var archiveTR = 10;
      OCreportArchive.insertRowBefore(archiveTR);
      OCreports.getRange("D" + a + ":L" + a).moveTo(OCreportArchive.getRange(archiveTR, 4));
      var rank = OCreportArchive.getRange(archiveTR, 5).getValue();
      OCreportArchive.getRange(archiveTR, 5).setValue(rank);
      addedRows++;
    }
  }
  var forLength = addedRows + 10;
  for (var e = 10; e <= forLength; e++) {
    var setBoaderStyle = OCreportArchive.getRange("D" + e + ":L" + e);
    setBoaderStyle.setBorder(null, null, true, null, true, null, null, SpreadsheetApp.BorderStyle.DASHED);
    setBoaderStyle.setBorder(null, null, null, true, null, null);
  }
  for (var i = rowNumber.length; i--;) {
    OCreports.deleteRows(rowNumber[i])
  }
  var reportLS = OCreports.getLastRow();
  var setBoaderStyle = OCreports.getRange("D" + reportLS + ":M" + reportLS);
  setBoaderStyle.setBorder(null, null, true, null, null, null);
  var reportLS = OCreports.getLastRow();
  var rowCount = 0;
  for (var b = 11; b <= reportLS; b++) {
    rowCount++;
  }
  if (rowCount < 1) {
    EliInsertRow();
  }
  if (rowCount < 2) {
    EliInsertRow();
  }
}

function EliInsertRow() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var OCreport = spreadsheet.getSheetByName("OC Reports");
  var lastRow = OCreport.getLastRow();
  var clearrange = OCreport.getRange("D" + lastRow + ":M" + lastRow);
  clearrange.setBorder(null, true, false, true, null, null);
  OCreport.insertRowAfter(lastRow);
  var lastRow = lastRow + 1;
  var setBoaderStyle = OCreport.getRange("D" + lastRow + ":M" + lastRow);
  setBoaderStyle.setBorder(true, null, null, null, true, true, null, SpreadsheetApp.BorderStyle.DASHED);
  setBoaderStyle.setBorder(null, true, true, true, null, null);
  var setFormula = OCreport.getRange("E" + lastRow).setFormula("=IFERROR(VLOOKUP(D" + lastRow + ",nameConFig!$A$1:$B$63,2,FALSE),\"Select Rank\")");
  OCreport.setRowHeight(lastRow, 130);
}