Kavala - archiveDiscipline

function myArchive() {
  try {
    var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var disciplineSheet = spreadsheet.getSheetByName("Discipline");
    var archiveSheet = spreadsheet.getSheetByName("Discipline Archive");
    var disciplineConfig = spreadsheet.getSheetByName("disciplineConfig");
    for (var i = 12; i < 17; i++) {
      var readyForArchive = disciplineSheet.getRange(i, 17).getValue();
      if (readyForArchive == "Checked") {
        var disciplinary1 = disciplineConfig.getRange("I3").getFormula();
        var disciplinary2 = disciplineConfig.getRange("L3").getFormula();
        var disciplinary3 = disciplineConfig.getRange("O3").getFormula();
        var disciplinary4 = disciplineConfig.getRange("R3").getFormula();
        var disciplinary5 = disciplineConfig.getRange("U3").getFormula();
        var targetRow = archiveSheet.getLastRow() + 1;
        archiveSheet.insertRowBefore(targetRow);
        disciplineSheet.getRange(i, 14).copyTo(disciplineSheet.getRange("F5"));
        disciplineSheet.getRange("C" + i + ":P" + i).moveTo(archiveSheet.getRange(targetRow, 3));
        archiveSheet.setRowHeight(targetRow, 42);
        var date = Utilities.formatDate(new Date(), "GMT", "dd/MM/yyyy");
        archiveSheet.getRange(targetRow, 10).setValue(date);
        disciplineSheet.getRange("C16:P16").copyTo(disciplineSheet.getRange("C" + i + ":P" + i));
        var rowFormat = disciplineSheet.getRange("Q" + i);
        rowFormat.copyFormatToRange(disciplineSheet, 3, 17, i, i);
        disciplineSheet.getRange("C" + i + ":D" + i).merge();
        disciplineSheet.getRange("F" + i + ":G" + i).merge();
        disciplineSheet.getRange("K" + i + ":L" + i).merge();
        disciplineSheet.getRange("F5").copyTo(disciplineSheet.getRange(i, 14));
        disciplineSheet.getRange("F8").copyTo(disciplineSheet.getRange("F5"));
        var clearrange = disciplineSheet.getRange(i, 14);
        var clearrange1 = disciplineSheet.getRange(i, 17);
        clearrange.clearContent();
        clearrange1.clearContent();
        disciplineConfig.getRange("I3").setFormula(disciplinary1);
        disciplineConfig.getRange("L3").setFormula(disciplinary2);
        disciplineConfig.getRange("O3").setFormula(disciplinary3);
        disciplineConfig.getRange("R3").setFormula(disciplinary4);
        disciplineConfig.getRange("U3").setFormula(disciplinary5);
      }
    }
  } catch (error) {
    throw new Error("Contact RUZBE");
  }
}