function getMissingNames(){

  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var tempFilledInList = sheet.getRange("B1:B60").getValues();
  //Logger.log("SS ID:" + SpreadsheetApp.getActiveSpreadsheet().getId());

  var firstEmptyRow;
  var firstRowArray = sheet.getRange("A1:A100").getValues();
  var normalFirstRowArray = [];

   for(var i = 0; i < 100; i++){  //converting shit 2 dimension sheet array into normal ppl array
    normalFirstRowArray[i] = firstRowArray[i][0];
  }

  for(firstEmptyRow = 0; firstEmptyRow < normalFirstRowArray.length-1; ){
     if(normalFirstRowArray[firstEmptyRow]){
       firstEmptyRow++;
     }else{
       break;
     }
  }

  var ss = SpreadsheetApp.openById("spreadsheet_ID");
  var sheets = ss.getSheets();
  var tempMemberList = ss.getRange("E5:P21").getValues();
  var filledInCount = tempFilledInList.length;

  var filledInList = [];  //people that filled in
  var didntFillInList = []; //array of people that didnt fill
  var memberList = [];

  for(var i = 0; i < 12;){
    var j = 0
    for(;  j < 17;){

      if(tempMemberList[j][i]){
        memberList.push(tempMemberList[j][i]);
         }
      j++;
    }
    i++;
  }
    var memberCount = memberList.length;

  for(var i = 0; i < filledInCount; i++){  //converting shit 2 dimension sheet array into normal ppl array
    filledInList[i] = tempFilledInList[i][0];
  }

  for(var i = 0; i < memberCount; i++){
    memberList[i] =  memberList[i].toLowerCase();
  }
    for(var i = 0; i < filledInCount; i++){
    filledInList[i] = filledInList[i].toLowerCase();
  }


  for (var i = 0, j = 0; j < memberCount;i++ ) {
            //var tempCheckingName = filledInList[i];
            if ((filledInList[i]).indexOf(memberList[j]) > -1) {
                i = 0;
                j++;
            }
            if (i == filledInCount - 1) {
                didntFillInList.push(memberList[j]);
                i = 0;
                j++;
            }
        }



  var cell = sheet.getRange(firstEmptyRow + 11,1);

  for(var t = 0; t < 115; t++){
    cell = sheet.getRange(firstEmptyRow + t + 2, 1);
    cell.setValue("");

  }

  var missingCell = sheet.getRange(firstEmptyRow + 10,1);
  missingCell.setValue("Missing" + " (" +  didntFillInList.length + ")");

  for(var k = 0; k < didntFillInList.length; k++){
    cell = sheet.getRange(firstEmptyRow + 11 + k, 1);
    cell.setValue(didntFillInList[k])
  }

  //console stuff
  //for (var i = 0; i < didntFillInList.length; i++) {
  //  Logger.log('Missing name: ' + didntFillInList[i]);
 // }

 }