Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function myFunction() {
- var sheet = SpreadsheetApp.getActiveSheet();
- var data = sheet.getDataRange().getValues();
- var itemsTaken = {};
- var totalItems = 0;
- var totalUsers = 3;
- var currentUser = 0;
- var aCounter = 0;
- for (var i = 0; i < data.length; i++) {
- if(!Number.isNaN(Number.parseInt(data[i][1], 10)))
- {
- totalItems++;
- }
- }
- for(var s = 0; s < totalItems; s++)
- {
- var smallestNumIndex = -1;
- for (var i = 0; i < data.length; i++) {
- if(!itemsTaken.hasOwnProperty(i) && !Number.isNaN(Number.parseInt(data[i][currentUser+1], 10)))
- {
- if(smallestNumIndex == -1) smallestNumIndex = i;
- if(Number.parseInt(data[i][currentUser+1], 10) < Number.parseInt(data[smallestNumIndex][currentUser+1], 10)) smallestNumIndex = i;
- }
- }
- itemsTaken[smallestNumIndex] = 1;
- sheet.getRange(smallestNumIndex+1,totalUsers+2).setValue(data[0][currentUser+1]);
- Logger.log('Setting: [' + smallestNumIndex + ',' + totalUsers+2 +'] :' + currentUser.toString());
- aCounter++;
- currentUser++;
- currentUser = currentUser%totalUsers;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement