function addTournamentToLeaderBoard(){
  var sheet= SpreadsheetApp.getActiveSpreadsheet();
  var sourceTournament = sheet.getSheetByName("TournamentAdding");
  var targetLeaderBoard = sheet.getSheetByName("Current Season");
  var tournamentType = sourceTournament.getRange('h3').getValue();
  var tournamentNumber = sourceTournament.getRange('h4').getValue();

  //'type normal, add rest later'
  if (tournamentType == "Normal"){

    var nameArrayRange = targetLeaderBoard.getSheetValues(2, 1, sourceTournament.getLastRow(), 1);
    var sourceNameRange =  sourceTournament.getSheetValues(2, 2, sourceTournament.getLastRow(), 1);
    var sourcePointsRange =  sourceTournament.getSheetValues(2, 3, sourceTournament.getLastRow(), 1);

   // var nameArray = nameArrayRange.filter(String);
    var sourceName = sourceNameRange.filter(String);
    var sourcePoints = sourcePointsRange.filter(String);


    var duplicate = false;
    //find duplicate and add the points to the right tournement
    for each(var i in nameArrayRange){
      duplicate =false;
      for each(var name in sourceName){
        if (name == i){
          duplicate= true;
          break;}
      }
      if(duplicate){
        var nameVal = 1+tournamentNumber;
        targetLeaderBoard.getRange(1+i, 1+tournamentNumber,1, 1).setValue(sourcePoints[i].toString());
        targetLeaderBoard.getRange(1+i, 1, 1+i, 1).setValues(sourceName);
      }
    }
    if(!duplicate){
      targetLeaderBoard.getRange(targetLeaderBoard.getLastRow()+1, 1+tournamentNumber,sourcePoints.length, 1).setValues(sourcePoints);
      targetLeaderBoard.getRange(targetLeaderBoard.getLastRow()+1, 1,sourceName.length, 1).setValues(sourceName);
    }