function importCSVchanges() {
  
  // II XP II Scripting
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Citadel"); 
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Script"); 
  
  var range = sheet.getRange("F1:I501");
  range.clearContent();
  
  var cellValue = ss.getRange("Citadel!A2").getValue();      
  var rsurl = "http://services.runescape.com/m=clan-hiscores/members_lite.ws?clanName=";  
  var csvUrl = rsurl+cellValue;
  var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();                                        
  var csvData = Utilities.parseCsv(csvContent);
  
  sheet.getRange(1, 6, csvData.length, csvData[0].length).setValues(csvData);   
  
  var range = ss.getRange("Q3:Q503");
  range.clearContent();  
  ss.getRange(4,1).setValue(new Date()); 
}
  
  

 function Runemetrics100() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Citadel"); 
  ss.getRange(14,1).setValue('Scanning...');
  var dataArray = new Array();
  ss.getRange(3,17,502).clear();
  var nameArray = ss.getRange(3, 2, 502).getValues();
  for(row = 0; row < nameArray.length; row++) {          
    if (!nameArray[row] || nameArray[row] == '') break;
    if (!dataArray[row]) { dataArray[row] = [];}
    var urlstart = "https://apps.runescape.com/runemetrics/profile/profile?user="; 
    var urlend = "&activities=20"
    var url = urlstart+nameArray[row]+urlend             
    var response = UrlFetchApp.fetch(url, {muteHttpExceptions: true}); 
    dataArray[row][0] = response;
  }
  ss.getRange(3,17,dataArray.length).setValues(dataArray); 
  ss.getRange(14,1).setValue('Finished scan');  
}

function trackcapped() {  
  var ss = SpreadsheetApp.getActive().getSheetByName('capped') 
  var range = ss.getRange("A:A").getValues();
  var lastRow = range.filter(String).length;                                    
  range = ss.getRange("C2:D");
  range.copyValuesToRange(ss,1,2,lastRow + 1,1000);        // Sheet-col-colend-row-rowend
  
  range = ss.getRange("E:E").getValues();
  lastRow = range.filter(String).length;                                    
  range = ss.getRange("G2:H");
  range.copyValuesToRange(ss,5,6,lastRow + 1,1000);  
}

function trackhistory() {
  var ss = SpreadsheetApp.getActive().getSheetByName('Historical Tracking') ;
  var range = ss.getRange("B4:B");
  var currentWeek = ss.getRange(1, 2).getValue();
  range.copyValuesToRange(ss, currentWeek + 2, currentWeek + 2, 4, range.getNumRows());
}

function cleartrackcapped() { 
  trackhistory();
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("capped");   
  var range = sheet.getRange("A2:B");
  range.clearContent();
  range = sheet.getRange("E2:F");
  range.clearContent();
}

/**
 * Converts a datetime string to a datetime string in a target timezone.
 *
 *@param {"October 29, 2016 1:00 PM CDT"} datetimeString Date, time and timezone.
 *@param {"Timezone"} timeZone Target timezone
 */
function utcNow() {
    return new Date(Utilities.formatDate(new Date(), "GMT", "YYYY-MM-dd hh:mm a z"));
}