Skip to content

Instantly share code, notes, and snippets.

@thomasweng15
Created December 23, 2017 06:57
Show Gist options
  • Save thomasweng15/ea84179c09c615ffa450b6a574c22bf6 to your computer and use it in GitHub Desktop.
Save thomasweng15/ea84179c09c615ffa450b6a574c22bf6 to your computer and use it in GitHub Desktop.
[Google Apps Script] Randomize range
function randomizeImages() {
spreadsheetId = "1u3XwgQ5ga36KX9j2yKkSuyUlUJo7lTdAsmj2JJ4Yq08";
var ss = SpreadsheetApp.openById(spreadsheetId);
SpreadsheetApp.setActiveSpreadsheet(ss);
var uploadSheetName = "HIT Upload";
SpreadsheetApp.setActiveSheet(ss.getSheetByName(uploadSheetName));
var sheet = ss.getActiveSheet();
var sheetData = sheet.getDataRange().getValues();
for (var col_index = 0; col_index < 126; col_index++) {
var range = sheet.getRange(2, col_index + 1, 42);
var array = range.getValues();
shuffleArray(array);
range.setValues(array);
}
}
/**
* Randomize array element order in-place.
* Using Durstenfeld shuffle algorithm.
*/
function shuffleArray(array) {
for (var i = array.length - 1; i > 0; i--) {
var j = Math.floor(Math.random() * (i + 1));
var temp = array[i];
array[i] = array[j];
array[j] = temp;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment