function checkHours() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getSheetByName('Roster');
    var lastrow = sheet.getLastRow();
    var response;
    var hours;
    var hoursList = [];
    var notesList = [];
    var bmidRange = sheet.getRange("F:F").getValues();
    var notesRange = sheet.getRange("K:K").getNotes();


    for (var i = 0; i < lastrow; i++) {
          if (bmidRange[i] > 1) {
            response = UrlFetchApp.fetch('https://lemmen.xyz/bmapi.php?bm=' + bmidRange[i] + '&fr=7');
            var seconds = response.getContentText();
              if (seconds == "ERROR!"){
              hours = "ERROR!";
              } else {
              hours = seconds/60/60;
              }
             Logger.log(hours);
            hoursList.push([hours]);
            var note = "Activity Check performed: "+ hours + " hours " +  new Date() + "\n\n" + notesRange[i];
            notesList.push([note]);
          } else if(bmidRange[i] == "") {
            hoursList.push(bmidRange[i]);
            notesList.push(['INSERT BATTLEMETRICS ID ' + new Date()]);
          } else if(bmidRange[i] == "BMID") {
            hoursList.push(["Hours Played"]);
            notesList.push(notesRange[i]);
          } else {
          hoursList.push(bmidRange[i]);
          notesList.push(notesRange[i]);
          }
          Utilities.sleep(500);
    }

    Logger.log(notesRange.length === notesList.length)

    sheet.getRange("K:K").offset(0, 0, hoursList.length).setValues(hoursList);
    sheet.getRange(1,11,notesList.length,1).setNotes(notesList);

  }