Pyrgos - rankNext

function rankNext(input) {
  if (input !== '') {
    var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var nameConFig = spreadsheet.getSheetByName('nameConFig');
    var names = [];
    var i = 1;
    var LR = nameConFig.getLastRow();
    do {
      var playerName = nameConFig.getRange(i, 1).getValue();
      var palyerRank = nameConFig.getRange(i, 2).getValue();
      names.push({
        name: playerName,
        rank: palyerRank
      });
      i++;
    }
    while (i <= LR);
    for (var i = 0; i < names.length; i++) {
      if (names[i].name == input) {
        var rank = names[i].rank;
        break;
      }
    }
    switch (rank) {
      case 'PC':
        promoRank = 'SPC';
        break;
      case 'SPC':
        promoRank = 'DC';
        break;
      case 'DC':
        promoRank = 'DS';
        break;
      case 'DS':
        promoRank = 'INSP';
        break;
      default:
        promoRank = 'Contact RUZBE';
    }
    return promoRank;
  }
}