function clearRange(range, sheet, logx) {
  SpreadsheetApp.getActive().getSheetByName(sheet).getRange(range).clearContent();
  log(range, sheet, "Data Cleared", "clearRange");
}

function log(range, sheet, action, func) {
  var date = new Date();
    SpreadsheetApp.getActive().getSheetByName('Log').appendRow([date, action, "Automatic", sheet, range, func])
  }

function copyData(cSheet, cRange, dSheet, dRange, contentOnly) {
  if (contentOnly == true) {
    SpreadsheetApp.getActive().getSheetByName(cSheet).getRange(cRange).copyTo(SpreadsheetApp.getActive().getSheetByName(dSheet).getRange(dRange), {contentsOnly:true});
    log(cRange, cSheet, "Data Copied (C)", "copyData");
    log(dRange, dSheet, "Data Pasted (C)", "copyData");
  }
  else {
    SpreadsheetApp.getActive().getSheetByName(cSheet).getRange(cRange).copyTo(SpreadsheetApp.getActive().getSheetByName(dSheet).getRange(dRange));
    log(cRange, cSheet, "Data Copied", "copyData");
    log(dRange, dSheet, "Data Pasted", "copyData");
  }
}

function deleteRow(sheet, row) {
  SpreadsheetApp.getActive().getSheetByName(sheet).deleteRow(row);
  log(row, sheet, "Row Deleted", "deleteRow");
}

function addRow(sheet, rowStart, rowAdd) {
  SpreadsheetApp.getActive().getSheetByName(sheet).insertRows(rowStart, rowAdd);
  log("Row "+rowStart, sheet, "Adding "+rowAdd+" Rows", "addRow");
}

function monthClear() {
  log(null, null, "Function Executed", "monthClear");
  clearRange('B3:O6', 'Monthly Schedule');
  clearRange('B8:O11', 'Monthly Schedule');
  clearRange('B13:O16', 'Monthly Schedule');
  clearRange('B18:O21', 'Monthly Schedule');
  clearRange('B23:E24', 'Monthly Schedule');
  clearRange('B26:E26', 'Monthly Schedule');
  clearRange('F23:O26', 'Monthly Schedule');
  clearRange('C2', 'Monthly Schedule');
  clearRange('E2', 'Monthly Schedule');
  clearRange('G2', 'Monthly Schedule');
  clearRange('I2', 'Monthly Schedule');
  clearRange('K2', 'Monthly Schedule');
  clearRange('M2', 'Monthly Schedule');
  clearRange('O2', 'Monthly Schedule');
  clearRange('O7', 'Monthly Schedule');
  clearRange('M7', 'Monthly Schedule');
  clearRange('K7', 'Monthly Schedule');
  clearRange('I7', 'Monthly Schedule');
  clearRange('G7', 'Monthly Schedule');
  clearRange('E7', 'Monthly Schedule');
  clearRange('C7', 'Monthly Schedule');
  clearRange('C12', 'Monthly Schedule');
  clearRange('E12', 'Monthly Schedule');
  clearRange('G12', 'Monthly Schedule');
  clearRange('I12', 'Monthly Schedule');
  clearRange('K12', 'Monthly Schedule');
  clearRange('M12', 'Monthly Schedule');
  clearRange('O12', 'Monthly Schedule');
  clearRange('O17', 'Monthly Schedule');
  clearRange('O22', 'Monthly Schedule');
  clearRange('M22', 'Monthly Schedule');
  clearRange('M17', 'Monthly Schedule');
  clearRange('K17', 'Monthly Schedule');
  clearRange('K22', 'Monthly Schedule');
  clearRange('I22', 'Monthly Schedule');
  clearRange('I17', 'Monthly Schedule');
  clearRange('G17', 'Monthly Schedule');
  clearRange('E17', 'Monthly Schedule');
  clearRange('G22', 'Monthly Schedule');
  clearRange('E22', 'Monthly Schedule');
  clearRange('E25', 'Monthly Schedule');
  clearRange('C25', 'Monthly Schedule');
  clearRange('C22', 'Monthly Schedule');
  clearRange('C17', 'Monthly Schedule');
  clearRange('B3:O6', 'Conflict Calander');
  clearRange('B8:O11', 'Conflict Calander');
  clearRange('B13:O16', 'Conflict Calander');
  clearRange('B18:O21', 'Conflict Calander');
  clearRange('B23:E24', 'Conflict Calander');
  clearRange('B26:E26', 'Conflict Calander');
  clearRange('F23:O26', 'Conflict Calander');
}

function weekClear() {
  log(null, null, "Function Executed", "weekClear");
  clearRange('B3:V6', 'Weekly Schedule', 'true', 'weekClear');
}

function coachNotes() {
  log(null, null, "Coach Notes Submitted", "coachNotes");
  addRow("Coaches Notes", 3, 16);
  copyData("Coaches Notes", "A19:U34", "Coaches Notes", "A3:U18");
  copyData("Coaches Notes", "B2", "Coaches Notes", "B4:D14", true);
  copyData("Coaches Notes", "C2", "Coaches Notes", "F4:H14", true);
  copyData("Coaches Notes", "D2", "Coaches Notes", "J4:L14", true);
  copyData("Coaches Notes", "E2", "Coaches Notes", "N4:P14", true);
  copyData("Coaches Notes", "F2", "Coaches Notes", "R4:T14", true);
  copyData("Coaches Notes", "A2", "Coaches Notes", "L16:M17", true);
  deleteRow("Coaches Notes", 2);
}